Changeset 4608 for temp/trunk/html/admin/customer/index.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/customer/index.php (modified) (3 diffs)

temp/trunk/html/admin/customer/index.php

@@ -118 +118 @@
 // ¸ÜµÒºï½ü
 if ($_POST['mode'] == "delete") {
-    $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+    $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
     $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
 
     if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
-        $arrDel = array("delete" => 1, "update_date" => "NOW()"); 
+        $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
         $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
     } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
@@ -138 +138 @@
     $objPage->arrErr = lfCheckError($objPage->arrForm);
 
-    $where = "delete = 0";
+    $where = "del_flg = 0";
 
     /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
@@ -197 +197 @@
             // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
             $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
-            $sqlval['delete'] = 1;
+            $sqlval['del_flg'] = 1;
             $objQuery->update("dtb_products", $sqlval, $where, $arrval);
 
-            $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+            $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
             $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
 
             if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
-                $arrDel = array("delete" => 1, "update_date" => "NOW()");
+                $arrDel = array("del_flg" => 1, "update_date" => "NOW()");
                 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
             } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü