Changeset 11982 for branches/comu/html/admin/mail/index.php

Timestamp:

2007/03/28 13:01:38 (17 years ago)

Author:

uehara

Message:

 

File:

• branches/comu/html/admin/mail/index.php (modified) (11 diffs)

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

@@ -27 +27 @@
         global $arrSex;     
         $this->arrSex = $arrSex;
+        global $arrMailType;
+        $this->arrMailType = $arrMailType;
         global $arrPageRows;
         $this->arrPageRows = $arrPageRows;
@@ -93 +95 @@
         $list_data['job_disp'] = $job_disp;
     }
-    
+        
     // ¥«¥Æ¥´¥êÊÑ´¹
     $arrCatList = sfGetCategoryList();
@@ -106 +108 @@
 
 if($_POST['mode'] == 'delete') {
-    $objQuery = new SC_Query();
-    $objQuery->delete("dtb_customer_mail", "email = ?", array($_POST['result_email']));
 }
 
@@ -120 +120 @@
     //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È
     $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn);
-    
+        
     //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯
     $objPage->arrErr = lfErrorCheck($objPage->list_data);
@@ -132 +132 @@
         //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 
         $objSelect = new SC_CustomerList($objPage->list_data, "magazine");
-
         // À¸À®¤µ¤ì¤¿WHEREʸ¤ò¼èÆÀ¤¹¤ë      
         list($where, $arrval) = $objSelect->getWhere();
+    
         // ¡ÖWHERE¡×Éôʬ¤òºï½ü¤¹¤ë¡£
         $where = ereg_replace("^WHERE", "", $where);
@@ -140 +140 @@
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
         $objQuery = new SC_Query();
-        $from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+        $from = "dtb_customer";
 
         // ¹Ô¿ô¤Î¼èÆÀ
@@ -155 +155 @@
         // ɽ¼¨½ç½ø
         $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_mail.mail_flag";
+        
+        // ¸¡º÷·ë²Ì¤Î¼èÆÀ   
+        $col = $objSelect->getMailMagazineColumn(lfGetIsMobile($_POST['mail_type']));
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
-
         //¸½ºß»þ¹ï¤Î¼èÆÀ
         $objPage->arrNowDate = lfGetNowDate();
@@ -175 +164 @@
     break;
 /*
-    input:¸¡º÷·ë²Ì²èÌÌ¡ÖÇÛ¿®ÆâÍÆÀßÄê¡×¥Ü¥¿¥ó
+    input:¸¡º÷·ë²Ì²èÌÌ¡ÖhtmlmailÆâÍÆÀßÄê¡×¥Ü¥¿¥ó
 */
 case 'input':
@@ -278 +267 @@
     break;
 default:
+    $objPage->list_data['mail_type'] = 1;
     break;
 }
@@ -386 +376 @@
     
     $objQuery = new SC_Query();
-        
     $objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" );
-    $search_data = $conn->getAll($objSelect->getListMailMagazine(), $objSelect->arrVal);
+    
+    $search_data = $conn->getAll($objSelect->getListMailMagazine(lfGetIsMobile($_POST['mail_type'])), $objSelect->arrVal);
     $dataCnt = count($search_data);
     
@@ -439 +429 @@
     return $arrCampaign;
 }
+
+function lfGetIsMobile($mail_type) {
+    // ¸¡º÷·ë²Ì¤Î¼èÆÀ           
+    $is_mobile = false;
+    switch($mail_type) {
+        case 1:
+            $is_mobile = false;
+            break;
+        case 2:
+            $is_mobile = true;      
+            break;
+        default:
+            $is_mobile = false;
+            break;
+    }
+    
+    return $is_mobile;
+}
 ?>