Changeset 22012 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php

Timestamp:

2012/08/30 14:15:56 (12 years ago)

Author:

shutta

Message:

refs #1925 (SC_Queryのupdateメソッドの使用を推奨)
SC_Queryのupdateメソッドを使用するように書き換えた。

File:

• branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php (modified) (3 diffs)

branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php

@@ -469 +469 @@
             $rank = $objQuery->get('rank', 'dtb_category', $where, array($parent_category_id));
             // 追加レコードのランク以上のレコードを一つあげる。
-            $sqlup = 'UPDATE dtb_category SET rank = (rank + 1) WHERE rank >= ?';
-            $objQuery->exec($sqlup, array($rank));
+            $where = 'rank >= ?';
+            $arrRawSql = array(
+                'rank' => '(rank + 1)',
+            );
+            $objQuery->update('dtb_category', array(), $where, array($rank), $arrRawSql);
         }
 
@@ -564 +567 @@
         $arrRet = $objDb->sfGetChildrenArray($table, $pid_name, $id_name, $id);
         $line = SC_Utils_Ex::sfGetCommaList($arrRet);
-        $sql = "UPDATE $table SET rank = (rank + $count) WHERE $id_name IN ($line) ";
-        $sql.= 'AND del_flg = 0';
-        $ret = $objQuery->exec($sql);
-        return $ret;
+        $where = "$id_name IN ($line) AND del_flg = 0";
+        $arrRawVal = array(
+            'rank' => "(rank + $count)",
+        );
+        return $objQuery->update($table, array(), $where, array(), $arrRawVal);
     }
 
@@ -575 +579 @@
         $arrRet = $objDb->sfGetChildrenArray($table, $pid_name, $id_name, $id);
         $line = SC_Utils_Ex::sfGetCommaList($arrRet);
-        $sql = "UPDATE $table SET rank = (rank - $count) WHERE $id_name IN ($line) ";
-        $sql.= 'AND del_flg = 0';
-        $ret = $objQuery->exec($sql);
-        return $ret;
+        $where = "$id_name IN ($line) AND del_flg = 0";
+        $arrRawVal = array(
+            'rank' => "(rank - $count)",
+        );
+        return $objQuery->update($table, array(), $where, array(), $arrRawVal);
     }
 }