Changeset 11611

Timestamp:

2007/03/08 15:59:54 (17 years ago)

Author:

uehara

Message:

 

Location:

branches/dev

Files:

• data/class/SC_CustomerList.php (modified) (2 diffs)
• data/lib/slib.php (modified) (1 diff)
• html/admin/mail/index.php (modified) (3 diffs)

branches/dev/data/class/SC_CustomerList.php

@@ -67 +67 @@
             */
             // ÅÐÏ¿Æü¤ò¼¨¤¹¥«¥é¥à
-            $regdate_col = 'dtb_customer_mail.create_date';
+            $regdate_col = 'dtb_customer.create_date';
         }
                 
@@ -301 +301 @@
     }
     
-    function getListMailMagazineCount() {
-        $this->select = "SELECT COUNT(*) FROM dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
-        return $this->getSql(0);    
-    }
-    //¹ØÆþ¾¦ÉÊ¥³¡¼¥É¸¡º÷ÍÑSQL
-    function getBuyList(){
-        $this->select = "SELECT A.customer_id, A.name01, A.name02, A.kana01, A.kana02, A.sex, A.email, A.tel01, A.tel02, A.tel03, A.pref, A.mailmaga_flg, B.order_email, B.order_id, C.product_code 
-                        FROM (dtb_customer LEFT OUTER JOIN dtb_customer_mail USING (email)) AS A LEFT OUTER JOIN dtb_order AS B ON 
-                        A.email=B.order_email LEFT OUTER JOIN dtb_order_detail AS C ON B.order_id = C.order_id";
-    }
-
     //¡¡¸¡º÷Áí¿ô¥«¥¦¥ó¥ÈÍÑSQL
     function getListCount() {

branches/dev/data/lib/slib.php

@@ -2283 +2283 @@
     $arrRegist["update_date"] = "NOW()";
     
-    $sqlval["create_date"] = "NOW()";
-    $sqlval["update_date"] = "NOW()";
-    $sqlval['email'] = $array['email'];
-    $sqlval['mail_flag'] = $array['mail_flag'];
     //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô
     $objQuery->begin();
     $objQuery->update("dtb_customer", $arrRegist, "customer_id = ? ", array($array['customer_id']));
-    $objQuery->delete("dtb_customer_mail", "email = ?", array($array['email']));
-    $objQuery->insert("dtb_customer_mail", $sqlval);
     $objQuery->commit();
 }

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

@@ -106 +106 @@
 
 if($_POST['mode'] == 'delete') {
-    $objQuery = new SC_Query();
-    $objQuery->delete("dtb_customer_mail", "email = ?", array($_POST['result_email']));
 }
 
@@ -140 +138 @@
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
         $objQuery = new SC_Query();
-        $from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+        $from = "dtb_customer";
 
         // ¹Ô¿ô¤Î¼èÆÀ
@@ -167 +165 @@
             dtb_customer.tel03,
             dtb_customer.pref,
-            dtb_customer_mail.mail_flag";
+            dtb_customer.mail_flag";
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);