Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php

Timestamp:

2012/02/15 19:56:17 (12 years ago)

Author:

Seasoft

Message:

#1625 (typo修正・ソース整形・ソースコメントの改善)

File:

• branches/version-2_12-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php

@@ -107 +107 @@
 
         // 該当全体件数の取得
-        $linemax = $objQuery->count('dtb_send_history',"del_flg = 0");
+        $linemax = $objQuery->count('dtb_send_history','del_flg = 0');
 
         // 一覧データの取得
-        $objSelect->setOrder("start_date DESC, send_id DESC");
+        $objSelect->setOrder('start_date DESC, send_id DESC');
 
-        $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";
+        $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';
 
         // ページ送りの取得
         $offset = SEARCH_PMAX * ($search_pageno - 1);
         $objSelect->setLimitOffset(SEARCH_PMAX, $offset);
-        $arrResult = $objSelect->select($col, 'dtb_send_history', " del_flg = 0");
+        $arrResult = $objSelect->select($col, 'dtb_send_history', ' del_flg = 0');
 
         $objNavi = new SC_PageNavi_Ex($search_pageno,
@@ -139 +139 @@
             $objQuery->update('dtb_send_history',
                               array('del_flg' =>1),
-                              "send_id = ?",
+                              'send_id = ?',
                               array($send_id));
     }