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

Timestamp:

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

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/customer/edit.php (modified) (2 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"]));