Changeset 11611 for branches/dev/data/class

Timestamp:

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

Author:

uehara

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (2 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() {