Changeset 4849 for temp

Timestamp:

2006/09/17 14:21:34 (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) (2 diffs)

temp/trunk/data/class/SC_CustomerList.php

@@ -258 +258 @@
 
     function getListMailMagazine() {
-        $this->select = "SELECT customer_id,name01,name02,kana01,kana02,sex,email,tel01,tel02,tel03,pref, mail_flag FROM dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+        $this->select = "
+            SELECT 
+                dtb_customer.customer_id,
+                dtb_customer.name01,
+                dtb_customer.name02,
+                dtb_customer.kana01,
+                dtb_customer.kana02,
+                dtb_customer.sex,
+                dtb_customer.email,
+                dtb_customer.tel01,
+                dtb_customer.tel02,
+                dtb_customer.tel03,
+                dtb_customer.pref, 
+                dtb_customer_mail.mail_flag 
+            FROM 
+                dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
         return $this->getSql(0);    
     }

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

@@ -369 +369 @@
     global $conn;
     global $arrSearchColumn;
+    
+    $objQuery = new SC_Query();
         
     $objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" );
@@ -375 +377 @@
     
     $dtb_send_history = array();
-    $dtb_send_history["send_id"] = $conn->getOne("SELECT NEXTVAL('dtb_send_history_send_id_seq')");
+//  $dtb_send_history["send_id"] = $conn->getOne("SELECT NEXTVAL('dtb_send_history_send_id_seq')");
+    $dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
     $dtb_send_history["mail_method"] = $arrData['mail_method'];
     $dtb_send_history["subject"] = $arrData['subject'];