Changeset 21563 for branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php

Timestamp:

2012/02/28 22:35:14 (12 years ago)

Author:

Seasoft

Message:

#1669 (変数の初期化漏れ)
#1613 (typo修正・ソース整形・ソースコメントの改善)

File:

• branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php (modified) (6 diffs)

branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php

@@ -104 +104 @@
      *               $add == false で, データが存在しない場合 false
      */
-    function sfDataExists($table_name, $where, $arrval, $dsn = '', $sql = '', $add = false) {
+    function sfDataExists($table_name, $where, $arrWhereVal, $dsn = '', $sql = '', $add = false) {
         $dbFactory = SC_DB_DBFactory_Ex::getInstance();
         $dsn = $dbFactory->getDSN($dsn);
 
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $exists = $objQuery->exists($table_name, $where, $arrval);
+        $exists = $objQuery->exists($table_name, $where, $arrWhereVal);
 
         // データを追加する
@@ -771 +771 @@
         $from = $objProduct->alldtlSQL($where_products_class);
         foreach ($arrTgtCategory_id as $category_id) {
-            $arrval = array();
-            list($tmp_where, $tmp_arrval) = $this->sfGetCatWhere($category_id);
+            $arrWhereVal = array();
+            list($tmp_where, $arrTmpVal) = $this->sfGetCatWhere($category_id);
             if ($tmp_where != '') {
                 $sql_where_product_ids = 'product_id IN (SELECT product_id FROM dtb_product_categories WHERE ' . $tmp_where . ')';
-                $arrval = $tmp_arrval;
+                $arrWhereVal = $arrTmpVal;
             } else {
                 $sql_where_product_ids = '0<>0'; // 一致させない
@@ -781 +781 @@
             $where = "($sql_where) AND ($sql_where_product_ids)";
 
-            $arrUpdateData[$category_id] = $objQuery->count($from, $where, $arrval);
+            $arrUpdateData[$category_id] = $objQuery->count($from, $where, $arrWhereVal);
         }
 
@@ -933 +933 @@
      * @param string $valname データ内容のカラム名
      * @param string $where WHERE句
-     * @param array $arrval プレースホルダ
+     * @param array $arrWhereVal プレースホルダ
      * @return array SELECT ボックス用リストの配列
      */
@@ -1230 +1230 @@
      * @param string $table テーブル名
      * @param string $col カラム名
-     * @param array $arrval 要素の配列
+     * @param array $arrVal 要素の配列
      * @param array $addwhere SQL の AND 条件である WHERE 句
      * @return bool レコードが存在する場合 true
      */
-    function sfIsRecord($table, $col, $arrval, $addwhere = '') {
+    function sfIsRecord($table, $col, $arrVal, $addwhere = '') {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $arrCol = preg_split('/[, ]/', $col);
@@ -1253 +1253 @@
             }
         }
-        $ret = $objQuery->get($col, $table, $where, $arrval);
+        $ret = $objQuery->get($col, $table, $where, $arrVal);
 
         if ($ret != '') {