Changeset 11749 for branches/dev

Timestamp:

2007/03/12 10:41:01 (17 years ago)

Author:

uehara

Message:

 

File:

• branches/dev/html/admin/mail/index.php (modified) (3 diffs)

branches/dev/html/admin/mail/index.php

@@ -141 +141 @@
         //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 
         $objSelect = new SC_CustomerList($objPage->list_data, "magazine");
-
         // À¸À®¤µ¤ì¤¿WHEREʸ¤ò¼èÆÀ¤¹¤ë      
         list($where, $arrval) = $objSelect->getWhere();
@@ -165 +164 @@
         // ɽ¼¨½ç½ø
         $objQuery->setorder("customer_id DESC");
+        
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-        $col = "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.mailmaga_flg";
+        $is_mobile = false;
+        switch($_POST['mail_type']) {
+            case 1:
+                $is_mobile = false;
+                break;
+            case 2:
+                $is_mobile = true;      
+                break;
+            default:
+                $is_mobile = false;
+                break;
+        }
+        $col = $objSelect->getListMailMagazine($is_mobile);
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
-
+sfprintr($where);
         //¸½ºß»þ¹ï¤Î¼èÆÀ
         $objPage->arrNowDate = lfGetNowDate();
@@ -397 +398 @@
     
     $objQuery = new SC_Query();
-        
     $objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" );
+    
     $search_data = $conn->getAll($objSelect->getListMailMagazine(), $objSelect->arrVal);
     $dataCnt = count($search_data);