Changeset 4846 for temp/trunk/html

Timestamp:

2006/09/17 13:41:33 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/mail/index.php (modified) (3 diffs)

temp/trunk/html/admin/mail/index.php

@@ -135 +135 @@
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
         $objQuery = new SC_Query();
-        $from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+        $from = "dtb_customer_mail as mail LEFT OUTER JOIN dtb_customer as cus USING(email)";
 
         // ¹Ô¿ô¤Î¼èÆÀ
@@ -151 +151 @@
         $objQuery->setorder("customer_id DESC");
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-        $col = "customer_id,name01,name02,kana01,kana02,sex,email,tel01,tel02,tel03,pref,mail_flag";
+        $col = "cus.customer_id,cus.name01,cus.name02,cus.kana01,cus.kana02,cus.sex,cus.email,cus.tel01,cus.tel02,cus.tel03,cus.pref,mail.mail_flag";
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
 
@@ -276 +276 @@
 function lfGetCustomerOrderId($keyword) {
     if($keyword != "") {
-        $col = "customer_id, order_id";
+        $col = "dtb_order.customer_id, dtb_order.order_id";
         $from = "dtb_order LEFT JOIN dtb_order_detail USING(order_id)";
         $where = "product_code LIKE ? AND del_flg = 0";