Changeset 11982 for branches/comu/html/admin/customer/index.php

Timestamp:

2007/03/28 13:01:38 (17 years ago)

Author:

uehara

Message:

 

File:

• branches/comu/html/admin/customer/index.php (modified) (6 diffs)

branches/comu/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"]));
-    }
-    $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-    $objConn->query($sql, array($result_customer[0]["email"]));
+        $objQuery->conn->query($sql, array($_POST["edit_customer_id"]));
+    }
 }
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
@@ -170 +168 @@
         }
         
-        $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
+        $objPage->search_data = $objQuery->conn->getAll($searchSql, $objSelect->arrVal);
         
         switch($_POST['mode']) {
@@ -209 +207 @@
 
             $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"])); 
             
             break;
@@ -225 +221 @@
 
             // ¹Ô¿ô¤Î¼èÆÀ
-            $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
+            $linemax = $objQuery->conn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
             $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
 
@@ -316 +312 @@
     $objErr->doFunc(array("ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
     $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array('·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹', "email_mobile", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 
     $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
     $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));