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

Timestamp:

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

Author:

uehara

Message:

 

File:

• branches/comu/html/admin/customer/edit.php (modified) (10 diffs)

branches/comu/html/admin/customer/edit.php

@@ -36 +36 @@
         $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl';
         $this->tpl_subtitle = '¸ÜµÒ¥Þ¥¹¥¿';
-        
+
         global $arrPref;
         $this->arrPref = $arrPref;
@@ -68 +68 @@
                              array(  "column" => "addr02",      "convert" => "aKV" ),
                              array(  "column" => "email",       "convert" => "a" ),
+                             array(  "column" => "email_mobile",    "convert" => "a" ),
                              array(  "column" => "tel01",       "convert" => "n" ),
                              array(  "column" => "tel02",       "convert" => "n" ),
@@ -80 +81 @@
                              array(  "column" => "reminder",    "convert" => "n" ),
                              array(  "column" => "reminder_answer", "convert" => "aKV" ),
+                             array(  "column" => "mailmaga_flg", "convert" => "n" ),                         
                              array(  "column" => "note",        "convert" => "aKV" ),
                              array(  "column" => "point",       "convert" => "n" ),
@@ -106 +108 @@
 
     //--¡¡¸ÜµÒ¥Ç¡¼¥¿¼èÆÀ
-    $sql = "SELECT A.*, B.mail_flag FROM dtb_customer AS A LEFT OUTER JOIN dtb_customer_mail AS B USING(email)
-             WHERE A.del_flg = 0 AND A.customer_id = ?";
+    $sql = "SELECT * FROM dtb_customer WHERE del_flg = 0 AND customer_id = ?";
     $result = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
     $objPage->list_data = $result[0];
@@ -128 +129 @@
 
 //----¡¡¸ÜµÒ¾ðÊóÊÔ½¸
-if ( $_POST["mode"] != "edit" && is_numeric($_POST["customer_id"])) {
+if ( $_POST["mode"] != "edit" && $_POST["mode"] != "edit_search" && is_numeric($_POST["customer_id"])) {
 
     //-- POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
@@ -207 +208 @@
 
     $arrRegist["update_date"] = "Now()";
-    $arrRegistMail["update_date"] = "Now()";
-    $arrRegistMail["mail_flag"] = $array["mail_flag"];
-    $arrRegistMail['email'] = $array['email'];
+
     //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô
     $objConn->query("BEGIN");
     $objQuery->Insert("dtb_customer", $arrRegist, "customer_id = '" .addslashes($array["customer_id"]). "'");
-    
-    //-- ¥á¥ë¥Þ¥¬ÅÐÏ¿
-    $mailmaga = $objQuery->getAll("SELECT * FROM dtb_customer_mail WHERE email = ?", $array["edit_email"]);
-    
-    if(count($mailmaga) > 0 ){
-        $objQuery->Update("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($array["edit_email"]). "'");
-    }else{
-        $arrRegistMail["create_date"] = "Now()";
-        //$arrRegist["create_date"] = date( "Y/m/d H:i:s", time());
-        $objQuery->Insert("dtb_customer_mail", $arrRegistMail);
-    }
+
     $objConn->query("COMMIT");
 }
@@ -282 +271 @@
     
     $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹(¥â¥Ð¥¤¥ë)', "email_mobile", MTEXT_LEN) ,array("EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+    //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä
+    if (strlen($array["email_mobile"]) > 0) {
+        $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
+        $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]);
+        $result = $objConn->getAll($sql, array($checkMail, $array["customer_id"]));
+        if (count($result) > 0) {
+            $objErr->arrErr["email_mobile"] .= "¢¨ ¤¹¤Ç¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹(¥â¥Ð¥¤¥ë)¤Ç¤¹¡£";
+        } 
+    }
+    
+    
     $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK"));
     $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK"));
@@ -294 +294 @@
     $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿¤È¤­¤Î¥Ò¥ó¥È ¼ÁÌä", "reminder") ,array("SELECT_CHECK", "NUM_CHECK")); 
     $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿¤È¤­¤Î¥Ò¥ó¥È Åú¤¨", "reminder_answer", STEXT_LEN) ,array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mail_flag") ,array("SELECT_CHECK", "NUM_CHECK"));
+    $objErr->doFunc(array("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mailmaga_flg") ,array("SELECT_CHECK", "NUM_CHECK"));
     $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE"));
-    $objErr->doFunc(array("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", 'mail_flag'), array("SELECT_CHECK"));
     $objErr->doFunc(array("SHOPÍÑ¥á¥â", 'note', LTEXT_LEN), array("MAX_LENGTH_CHECK"));
     $objErr->doFunc(array("½ê»ý¥Ý¥¤¥ó¥È", "point", TEL_LEN) ,array("MAX_LENGTH_CHECK", "NUM_CHECK"));
@@ -314 +313 @@
         $page_max = SEARCH_PMAX;
         //¹ØÆþÍúÎò¤Î·ï¿ô¼èÆÀ
-        $objPage->tpl_linemax = $objQuery->count("dtb_order","customer_id=?", array($customer_id));
+        $objPage->tpl_linemax = $objQuery->count("dtb_order","customer_id=? AND del_flg = 0 ", array($customer_id));
         $linemax = $objPage->tpl_linemax;
         
@@ -329 +328 @@
         $objQuery->setorder($order);
         //¹ØÆþÍúÎò¾ðÊó¤Î¼èÆÀ
-        $arrPurchaseHistory = $objQuery->select("*", "dtb_order", "customer_id=?", array($customer_id));
+        $arrPurchaseHistory = $objQuery->select("*", "dtb_order", "customer_id=? AND del_flg = 0 ", array($customer_id));
         
         return $arrPurchaseHistory;