Changeset 18631 for branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php

Timestamp:

2010/05/05 20:11:17 (14 years ago)

Author:

Seasoft

Message:

#698(メルマガ配信に誤りがある) 改修

File:

• branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php (modified) (4 diffs)

branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php

@@ -58 +58 @@
      */
     function process() {
-        //---- ページ初期設定
+        // ページ初期設定
         $conn = new SC_DBConn();
         $objView = new SC_AdminView();
@@ -72 +72 @@
 
         // 削除時
-        if (SC_Utils_Ex::sfCheckNumLength($_GET['send_id']) && ($_GET['mode']=='delete') ){
+        if (SC_Utils_Ex::sfCheckNumLength($_GET['send_id']) && ($_GET['mode']=='delete')) {
 
             $sql = "UPDATE dtb_send_history SET del_flg = 1 WHERE send_id = ?";
@@ -79 +79 @@
             $this->reload();
         }
-        $col = "*";
         $from = "dtb_send_history";
 
@@ -102 +101 @@
         $objQuery->setorder($order);
 
+        $col = "*";
+        $col .= ",(SELECT COUNT(*) FROM dtb_send_customer WHERE dtb_send_customer.send_id = dtb_send_history.send_id) AS count_all";
+        $col .= ",(SELECT COUNT(*) FROM dtb_send_customer WHERE dtb_send_customer.send_id = dtb_send_history.send_id AND send_flag = 1) AS count_sent";
+        $col .= ",(SELECT COUNT(*) FROM dtb_send_customer WHERE dtb_send_customer.send_id = dtb_send_history.send_id AND send_flag = 2) AS count_error";
+        $col .= ",(SELECT COUNT(*) FROM dtb_send_customer WHERE dtb_send_customer.send_id = dtb_send_history.send_id AND send_flag IS NULL) AS count_unsent";
+
         // 検索結果の取得
         $this->arrDataList = $objQuery->select($col, $from, $where, $arrval);
 
-        //---- ページ表示
+        // ページ表示
         $objView->assignobj($this);
         $objView->display(MAIN_FRAME);