Changeset 19729 for branches/version-2_5-dev/data/class/pages/admin

Timestamp:

2010/12/16 23:12:59 (14 years ago)

Author:

Seasoft

Message:

#855(SC_Query の #select, #getRow, #getCol, #get, #min, #max の引数順を統一する)

• SC_Query#get を改訂

Location:

branches/version-2_5-dev/data/class/pages/admin

Files:

• LC_Page_Admin_Home.php (modified) (1 diff)
• products/LC_Page_Admin_Products_Category.php (modified) (7 diffs)
• products/LC_Page_Admin_Products_Class.php (modified) (1 diff)
• products/LC_Page_Admin_Products_ClassCategory.php (modified) (3 diffs)
• products/LC_Page_Admin_Products_UploadCSVCategory.php (modified) (3 diffs)
• system/LC_Page_Admin_System_Delete.php (modified) (1 diff)

branches/version-2_5-dev/data/class/pages/admin/LC_Page_Admin_Home.php

@@ -161 +161 @@
         $where = "del_flg = 0";
         $from = "dtb_customer";
-        $ret = $objQuery->get($from, $col, $where);
+        $ret = $objQuery->get($col, $from, $where);
         return $ret;
     }

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

@@ -119 +119 @@
             $objQuery = new SC_Query();
             $where = "category_id = ?";
-            $cat_name = $objQuery->get("dtb_category", "category_name", $where, array($_POST['category_id']));
+            $cat_name = $objQuery->get("category_name", "dtb_category", $where, array($_POST['category_id']));
             // 入力項目にカテゴリ名を入力する。
             $this->arrForm['category_name'] = $cat_name;
@@ -190 +190 @@
         
                 // 移動したデータのrank、level、parent_category_idを取得
-                $rank   = $objQuery->get("dtb_category", "rank", "category_id = ?", array($keys[0]));
-                $level  = $objQuery->get("dtb_category", "level", "category_id = ?", array($keys[0]));
-                $parent = $objQuery->get("dtb_category", "parent_category_id", "category_id = ?", array($keys[0]));
+                $rank   = $objQuery->get("rank", "dtb_category", "category_id = ?", array($keys[0]));
+                $level  = $objQuery->get("level", "dtb_category", "category_id = ?", array($keys[0]));
+                $parent = $objQuery->get("parent_category_id", "dtb_category", "category_id = ?", array($keys[0]));
 
                 // 同一level内のrank配列を作成
@@ -280 +280 @@
             // 親のランクを自分のランクとする。
             $where = "category_id = ?";
-            $rank = $objQuery->get("dtb_category", "rank", $where, array($parent_category_id));
+            $rank = $objQuery->get("rank", "dtb_category", $where, array($parent_category_id));
             // 追加レコードのランク以上のレコードを一つあげる。
             $sqlup = "UPDATE dtb_category SET rank = (rank + 1) WHERE rank >= ?";
@@ -288 +288 @@
         $where = "category_id = ?";
         // 自分のレベルを取得する(親のレベル + 1)
-        $level = $objQuery->get("dtb_category", "level", $where, array($parent_category_id)) + 1;
+        $level = $objQuery->get("level", "dtb_category", $where, array($parent_category_id)) + 1;
 
         // 入力データを渡す。
@@ -345 +345 @@
         if(!isset($objErr->arrErr['category_name'])) {
             $objQuery = new SC_Query();
-            $level = $objQuery->get("dtb_category", "level", "category_id = ?", array($_POST['parent_category_id']));
+            $level = $objQuery->get("level", "dtb_category", "category_id = ?", array($_POST['parent_category_id']));
 
             if($level >= LEVEL_MAX) {
@@ -382 +382 @@
         $col = "$pid_name";
         $where = "$id_name = ?";
-        $pid = $objQuery->get($table, $col, $where, $id);
+        $pid = $objQuery->get($col, $table, $where, $id);
         // すべての子を取得する。
         $col = "$id_name";
@@ -403 +403 @@
         $col = "$pid_name";
         $where = "$id_name = ?";
-        $pid = $objQuery->get($table, $col, $where, $id);
+        $pid = $objQuery->get($col, $table, $where, $id);
         // すべての子を取得する。
         $col = "$id_name";

branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Class.php

@@ -111 +111 @@
             // 編集項目をDBより取得する。
             $where = "class_id = ?";
-            $class_name = $objQuery->get("dtb_class", "name", $where, array($_POST['class_id']));
+            $class_name = $objQuery->get("name", "dtb_class", $where, array($_POST['class_id']));
             // 入力項目にカテゴリ名を入力する。
             $this->arrForm['name'] = $class_name;

branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ClassCategory.php

@@ -79 +79 @@
         if(SC_Utils_Ex::sfIsInt($_GET['class_id'])) {
             // 規格名の取得
-            $this->tpl_class_name = $objQuery->get("dtb_class", "name", "class_id = ?", array($_GET['class_id']));
+            $this->tpl_class_name = $objQuery->get("name", "dtb_class", "class_id = ?", array($_GET['class_id']));
             if($this->tpl_class_name != "") {
                 // 規格IDの引き継ぎ
@@ -135 +135 @@
             // 編集項目をDBより取得する。
             $where = "classcategory_id = ?";
-            $name = $objQuery->get("dtb_classcategory", "name", $where, array($_POST['classcategory_id']));
+            $name = $objQuery->get("name", "dtb_classcategory", $where, array($_POST['classcategory_id']));
             // 入力項目にカテゴリ名を入力する。
             $this->arrForm['name'] = $name;
@@ -174 +174 @@
         // 親規格IDの存在チェック
         $where = "del_flg <> 1 AND class_id = ?";
-        $ret =  $objQuery->get("dtb_class", "class_id", $where, array($_POST['class_id']));
+        $ret =  $objQuery->get("class_id", "dtb_class", $where, array($_POST['class_id']));
         if($ret != "") {
             // INSERTする値を作成する。

branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php

@@ -258 +258 @@
             $sqlval['level'] = 1;
         } else {
-            $parent_level = $objQuery->get("dtb_category", "level", "category_id = ?", array($sqlval['parent_category_id']));
+            $parent_level = $objQuery->get("level", "dtb_category", "category_id = ?", array($sqlval['parent_category_id']));
             $sqlval['level'] = $parent_level + 1;
         }
@@ -289 +289 @@
                 // 親のランクを自分のランクとする。
                 $where = "category_id = ?";
-                $sqlval['rank'] = $objQuery->get("dtb_category", "rank", $where, array($sqlval['parent_category_id']));
+                $sqlval['rank'] = $objQuery->get("rank", "dtb_category", $where, array($sqlval['parent_category_id']));
                 // 追加レコードのランク以上のレコードを一つあげる。
                 $sqlup = "UPDATE dtb_category SET rank = rank + 1 WHERE rank >= ?";
@@ -335 +335 @@
         // 階層チェック
         if (!isset($objErr->arrErr['category_name']) && !isset($objErr->arrErr['parent_category_id'])) {
-            $level = $objQuery->get("dtb_category", "level", "category_id = ?", array($parent_category_id));
+            $level = $objQuery->get("level", "dtb_category", "category_id = ?", array($parent_category_id));
             if ($level >= LEVEL_MAX) {
                 $objErr->arrErr['category_name'] = "※ ".LEVEL_MAX."階層以上の登録はできません。<br>";

branches/version-2_5-dev/data/class/pages/admin/system/LC_Page_Admin_System_Delete.php

@@ -115 +115 @@
         $where = "member_id = ?";
         // ランクの取得
-        $rank = $objQuery->get("dtb_member", "rank", $where, array($id));
+        $rank = $objQuery->get("rank", "dtb_member", $where, array($id));
 
         // 削除したレコードより上のランキングを下げてRANKの空きを埋める。