Changeset 11533 for branches/dev/html

Timestamp:

2007/03/05 17:52:29 (19 years ago)

Author:

inoue

Message:

SC_Query()が未定義な箇所を修正。同時にSC_DbConn()を使わないように。

File:

• branches/dev/html/admin/customer/index.php (modified) (5 diffs)

branches/dev/html/admin/customer/index.php

@@ -86 +86 @@
 
 //---- ¥Ú¡¼¥¸½é´üÀßÄê
-$objConn = new SC_DBConn();
+$objQuery = new SC_Query();
 $objPage = new LC_Page();
 $objView = new SC_AdminView();
@@ -123 +123 @@
 if ($_POST['mode'] == "delete") {
     $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
-    $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
+    $result_customer = $objQuery->conn->getAll($sql, array($_POST["edit_customer_id"]));
 
     if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
         $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
-        $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
+        $objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
     } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
         $sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
-        $objConn->query($sql, array($_POST["edit_customer_id"]));
+        $objQuery->conn->query($sql, array($_POST["edit_customer_id"]));
     }
     $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-    $objConn->query($sql, array($result_customer[0]["email"]));
+    $objQuery->conn->query($sql, array($result_customer[0]["email"]));
 }
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
@@ -170 +170 @@
         }
         
-        $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
+        $objPage->search_data = $objQuery->conn->getAll($searchSql, $objSelect->arrVal);
         
         switch($_POST['mode']) {
@@ -209 +209 @@
 
             $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
-            $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
+            $result_customer = $objQuery->conn->getAll($sql, array($_POST["del_customer_id"]));
 
             if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
                 $arrDel = array("del_flg" => 1, "update_date" => "NOW()");
-                $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
+                $objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
             } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
                 $sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
-                $objConn->query($sql, array($_POST["del_customer_id"]));
+                $objQuery->conn->query($sql, array($_POST["del_customer_id"]));
             }
             $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-            $objConn->query($sql, array($result_customer[0]["email"])); 
+            $objQuery->conn->query($sql, array($result_customer[0]["email"]));  
             
             break;
@@ -225 +225 @@
 
             // ¹Ô¿ô¤Î¼èÆÀ
-            $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
+            $linemax = $objQuery->conn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
             $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ