Changeset 11577 for branches/dev/data/class/SC_CustomerList.php

Timestamp:

2007/03/08 09:33:33 (20 years ago)

Author:

uehara

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (3 diffs)

branches/dev/data/class/SC_CustomerList.php

@@ -167 +167 @@
         if ( $mode == 'magazine' ){
             if ( strlen($this->arrSql['htmlmail']) > 0 ) {
-                $this->setWhere( " mail_flag = ? ");
+                $this->setWhere( " mailmaga_flg = ? ");
                 $this->arrVal[] = $this->arrSql['htmlmail'];
             } else {
-                $this->setWhere( " (mail_flag = 1 or mail_flag = 2) ");
+                $this->setWhere( " (mailmaga_flg = 1 or mailmaga_flg = 2) ");
             }
         }
@@ -295 +295 @@
                 dtb_customer.tel03,
                 dtb_customer.pref, 
-                dtb_customer_mail.mail_flag 
+                dtb_customer.mailmaga_flg 
             FROM 
-                dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+                dtb_customer";
         return $this->getSql(0);    
     }
@@ -307 +307 @@
     //¹ØÆþ¾¦ÉÊ¥³¡¼¥É¸¡º÷ÍÑ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.mail_flag, B.order_email, B.order_id, C.product_code 
+        $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";