Changeset 2142

Timestamp:

2006/08/26 18:31:21 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_CustomerList.php (modified) (1 diff)
• html/admin/mail/index.php (modified) (1 diff)

temp/trunk/data/class/SC_CustomerList.php

@@ -265 +265 @@
     //¹ØÆþ¾¦ÉÊ¥³¡¼¥É¸¡º÷ÍÑ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, A.other_flag, A.other_data, 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.mail_flag, 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";

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

@@ -338 +338 @@
     $dtb_send_history["subject"] = $arrData['subject'];
     $dtb_send_history["body"] = $arrData['body'];
-    $dtb_send_history["start_date"] = $arrData['send_year'] ."/".$arrData['send_month']."/".$arrData['send_day']." ".$arrData['send_hour'].":".$arrData['send_minutes'];
+    $dtb_send_history["start_date"] = "now()";
     $dtb_send_history["creator_id"] = $_SESSION['member_id'];
     $dtb_send_history["send_count"] = $dataCnt;