Changeset 4608 for temp/trunk/html/admin/customer

Timestamp:

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

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin/customer

Files:

• edit.php (modified) (2 diffs)
• index.php (modified) (3 diffs)

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

@@ -103 +103 @@
     //--¡¡¸ÜµÒ¥Ç¡¼¥¿¼èÆÀ
     $sql = "SELECT A.*, EXTRACT(EPOCH FROM A.birth) AS birth_unix, B.mail_flag FROM dtb_customer AS A LEFT OUTER JOIN dtb_customer_mail AS B USING(email)
-             WHERE A.delete = 0 AND A.customer_id = ?";
+             WHERE A.del_flg = 0 AND A.customer_id = ?";
     $result = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
     $objPage->list_data = $result[0];
@@ -257 +257 @@
     //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä
     if (strlen($array["email"]) > 0) {
-        $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND delete = 0 AND customer_id <> ?";
+        $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
         $checkMail = ereg_replace( "_", "#_", $array["email"]);
         $result = $objConn->getAll($sql, array($checkMail, $array["customer_id"]));

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) {     //²¾²ñ°÷ºï½ü