Changeset 11606

Timestamp:

2007/03/08 15:31:03 (17 years ago)

Author:

uehara

Message:

 

Location:

branches/dev/html/admin/customer

Files:

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

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

@@ -80 +80 @@
                              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 +107 @@
 
     //--¡¡¸ÜµÒ¥Ç¡¼¥¿¼èÆÀ
-    $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];
@@ -207 +207 @@
 
     $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");
 }

branches/dev/html/admin/customer/index.php

@@ -132 +132 @@
         $objQuery->conn->query($sql, array($_POST["edit_customer_id"]));
     }
-    $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-    $objQuery->conn->query($sql, array($result_customer[0]["email"]));
 }
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
@@ -218 +216 @@
                 $objQuery->conn->query($sql, array($_POST["del_customer_id"]));
             }
-            $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-            $objQuery->conn->query($sql, array($result_customer[0]["email"]));  
             
             break;