Changeset 15343 for branches/feature-module-update/data/class/util/SC_Utils.php

Timestamp:

2007/08/24 12:52:51 (19 years ago)

Author:

nanasess

Message:

メソッド移動+未定義変数の修正

File:

• branches/feature-module-update/data/class/util/SC_Utils.php (modified) (9 diffs)

branches/feature-module-update/data/class/util/SC_Utils.php

@@ -453 +453 @@
         }
         for($i = 1; $i <= $max; $i++) {
-            if(isset($arrTmp) && $arrTmp[$i] == "1") {
+            if(isset($arrTmp[$i]) && $arrTmp[$i] == "1") {
                 $ret.= "1";
             } else {
@@ -705 +705 @@
     }
 
-    // カテゴリツリーの取得($products_check:true商品登録済みのものだけ取得)
-    function sfGetCategoryList($addwhere = "", $products_check = false, $head = CATEGORY_HEAD) {
-        $objQuery = new SC_Query();
-        $where = "del_flg = 0";
-
-        if($addwhere != "") {
-            $where.= " AND $addwhere";
-        }
-
-        $objQuery->setoption("ORDER BY rank DESC");
-
-        if($products_check) {
-            $col = "T1.category_id, category_name, level";
-            $from = "dtb_category AS T1 LEFT JOIN dtb_category_total_count AS T2 ON T1.category_id = T2.category_id";
-            $where .= " AND product_count > 0";
-        } else {
-            $col = "category_id, category_name, level";
-            $from = "dtb_category";
-        }
-
-        $arrRet = $objQuery->select($col, $from, $where);
-
-        $max = count($arrRet);
-        for($cnt = 0; $cnt < $max; $cnt++) {
-            $id = $arrRet[$cnt]['category_id'];
-            $name = $arrRet[$cnt]['category_name'];
-            $arrList[$id] = "";
-            /*
-            for($n = 1; $n < $arrRet[$cnt]['level']; $n++) {
-                $arrList[$id].= "　";
-            }
-            */
-            for($cat_cnt = 0; $cat_cnt < $arrRet[$cnt]['level']; $cat_cnt++) {
-                $arrList[$id].= $head;
-            }
-            $arrList[$id].= $name;
-        }
-        return $arrList;
-    }
-
-    // カテゴリツリーの取得（親カテゴリのValue:0)
-    function sfGetLevelCatList($parent_zero = true) {
-        $objQuery = new SC_Query();
-        $col = "category_id, category_name, level";
-        $where = "del_flg = 0";
-        $objQuery->setoption("ORDER BY rank DESC");
-        $arrRet = $objQuery->select($col, "dtb_category", $where);
-        $max = count($arrRet);
-
-        for($cnt = 0; $cnt < $max; $cnt++) {
-            if($parent_zero) {
-                if($arrRet[$cnt]['level'] == LEVEL_MAX) {
-                    $arrValue[$cnt] = $arrRet[$cnt]['category_id'];
-                } else {
-                    $arrValue[$cnt] = "";
-                }
-            } else {
-                $arrValue[$cnt] = $arrRet[$cnt]['category_id'];
-            }
-
-            $arrOutput[$cnt] = "";
-            /*
-            for($n = 1; $n < $arrRet[$cnt]['level']; $n++) {
-                $arrOutput[$cnt].= "　";
-            }
-            */
-            for($cat_cnt = 0; $cat_cnt < $arrRet[$cnt]['level']; $cat_cnt++) {
-                $arrOutput[$cnt].= CATEGORY_HEAD;
-            }
-            $arrOutput[$cnt].= $arrRet[$cnt]['category_name'];
-        }
-        return array($arrValue, $arrOutput);
-    }
-
     function sfGetErrorColor($val) {
         if($val != "") {
@@ -785 +711 @@
         return "";
     }
-
 
     function sfGetEnabled($val) {
@@ -998 +923 @@
             $where = "product_id = ?";
             $objQuery->delete("dtb_products_class", $where, array($product_id));
+
+            // 配列の添字を定義
+            $checkArray = array("product_code", "stock", "stock_unlimited", "price01", "price02");
+            $arrList = SC_Utils_Ex::arrayDefineIndexes($arrList, $checkArray);
+
             $sqlval['product_id'] = $product_id;
             $sqlval['classcategory_id1'] = '0';
@@ -1432 +1362 @@
             $category_id = (int) $category_id;
             $product_id = (int) $product_id;
-            if(SC_Utils_Ex::sfIsInt($category_id) && SC_Utils_Ex::sfIsRecord("dtb_category","category_id", $category_id)) {
+            $objDb = new SC_Helper_DB_Ex();
+            if(SC_Utils_Ex::sfIsInt($category_id) && $objDb->sfIsRecord("dtb_category","category_id", $category_id)) {
                 $g_category_id = $category_id;
-            } else if (SC_Utils_Ex::sfIsInt($product_id) && SC_Utils_Ex::sfIsRecord("dtb_products","product_id", $product_id, "status = 1")) {
+            } else if (SC_Utils_Ex::sfIsInt($product_id) && $objDb->sfIsRecord("dtb_products","product_id", $product_id, "status = 1")) {
                 $objQuery = new SC_Query();
                 $where = "product_id = ?";
@@ -1813 +1744 @@
         }
 
-        if($_GET['tpl'] != "") {
+        if(isset($_GET['tpl']) && $_GET['tpl'] != "") {
             $tpl_name = $_GET['tpl'];
         } else {
@@ -1903 +1834 @@
     }
 
-    function sfCategory_Count($objQuery){
-        $sql = "";
-
-        //テーブル内容の削除
-        $objQuery->query("DELETE FROM dtb_category_count");
-        $objQuery->query("DELETE FROM dtb_category_total_count");
-
-        //各カテゴリ内の商品数を数えて格納
-        $sql = " INSERT INTO dtb_category_count(category_id, product_count, create_date) ";
-        $sql .= " SELECT T1.category_id, count(T2.category_id), now() FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 ";
-        $sql .= " ON T1.category_id = T2.category_id  ";
-        $sql .= " WHERE T2.del_flg = 0 AND T2.status = 1 ";
-        $sql .= " GROUP BY T1.category_id, T2.category_id ";
-        $objQuery->query($sql);
-
-        //子カテゴリ内の商品数を集計する
-        $arrCat = $objQuery->getAll("SELECT * FROM dtb_category");
-
-        $sql = "";
-        foreach($arrCat as $key => $val){
-
-            // 子ID一覧を取得
-            $arrRet = sfGetChildrenArray('dtb_category', 'parent_category_id', 'category_id', $val['category_id']);
-            $line = sfGetCommaList($arrRet);
-
-            $sql = " INSERT INTO dtb_category_total_count(category_id, product_count, create_date) ";
-            $sql .= " SELECT ?, SUM(product_count), now() FROM dtb_category_count ";
-            $sql .= " WHERE category_id IN (" . $line . ")";
-
-            $objQuery->query($sql, array($val['category_id']));
-        }
-    }
-
     // 2つの配列を用いて連想配列を作成する
     function sfarrCombine($arrKeys, $arrValues) {
@@ -1952 +1850 @@
 
         return false;
-    }
-
-    /* 階層構造のテーブルから子ID配列を取得する */
-    function sfGetChildrenArray($table, $pid_name, $id_name, $id) {
-        $objQuery = new SC_Query();
-        $col = $pid_name . "," . $id_name;
-         $arrData = $objQuery->select($col, $table);
-
-        $arrPID = array();
-        $arrPID[] = $id;
-        $arrChildren = array();
-        $arrChildren[] = $id;
-
-        $arrRet = SC_Utils::sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrPID);
-
-        while(count($arrRet) > 0) {
-            $arrChildren = array_merge($arrChildren, $arrRet);
-            $arrRet = SC_Utils::sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrRet);
-        }
-
-        return $arrChildren;
-    }
-
-    /* 親ID直下の子IDをすべて取得する */
-    function sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrPID) {
-        $arrChildren = array();
-        $max = count($arrData);
-
-        for($i = 0; $i < $max; $i++) {
-            foreach($arrPID as $val) {
-                if($arrData[$i][$pid_name] == $val) {
-                    $arrChildren[] = $arrData[$i][$id_name];
-                }
-            }
-        }
-        return $arrChildren;
-    }
-
-
-    /* 階層構造のテーブルから親ID配列を取得する */
-    function sfGetParentsArray($table, $pid_name, $id_name, $id) {
-        $objQuery = new SC_Query();
-        $col = $pid_name . "," . $id_name;
-         $arrData = $objQuery->select($col, $table);
-
-        $arrParents = array();
-        $arrParents[] = $id;
-        $child = $id;
-
-        $ret = SC_Utils::sfGetParentsArraySub($arrData, $pid_name, $id_name, $child);
-
-        while($ret != "") {
-            $arrParents[] = $ret;
-            $ret = SC_Utils::sfGetParentsArraySub($arrData, $pid_name, $id_name, $ret);
-        }
-
-        $arrParents = array_reverse($arrParents);
-
-        return $arrParents;
     }
 
@@ -2349 +2188 @@
     }
 
+    /**
+     * 配列の添字が未定義の場合は空文字を代入して定義する.
+     *
+     * @param array $array 添字をチェックする配列
+     * @param array $defineIndexes チェックする添字
+     * @return array 添字を定義した配列
+     */
+    function arrayDefineIndexes($array, $defineIndexes) {
+        foreach ($defineIndexes as $key) {
+            if (!isset($array[$key])) $array[$key] = "";
+        }
+        return $array;
+    }
+
     /* デバッグ用 ------------------------------------------------------------------------------------------------*/
     function sfPrintR($obj) {