Changeset 4818 for temp

Timestamp:

2006/09/16 21:10:04 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/batch/daily.php (modified) (3 diffs)

temp/trunk/html/admin/batch/daily.php

@@ -98 +98 @@
 
 // ¥Ð¥Ã¥Á½¸·×ÍѤÎSQLʸ¤ò¼èÆÀ¤¹¤ë¡£
-function lfGetOrderDailySQL() {
+function lfGetOrderDailySQL($start, $end) {
     $from = " FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) ";
-    $where = " WHERE T1.del_flg = 0 AND T1.create_date BETWEEN ? AND ? ";
+    $where = " WHERE T1.del_flg = 0 AND T1.create_date BETWEEN $start AND $end ";
     
     $sql = "SELECT ";
@@ -141 +141 @@
     global $arrWDAY;
     
-    $sql = lfGetOrderDailySQL();
-    
     // ½¸·×ÂоÝÆü¤ò¼èÆÀ¤¹¤ë
     $date = date("Y-m-d", $time);
@@ -148 +146 @@
     $start = $date . " 00:00:00";
     $end = $date . " 23:59:59";
+    
+    $sql = lfGetOrderDailySQL($start,$end);
     
     $objQuery = new SC_Query();