Changeset 4668 for temp/trunk

Timestamp:

2006/09/13 10:49:24 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/home.php (modified) (2 diffs)

temp/trunk/html/admin/home.php

@@ -85 +85 @@
     if ( $method == 'SUM' or $method == 'COUNT'){
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM') = ? 
+                 WHERE del_flg = 0 AND cast(substring(create_date,1,6) as date) = ? 
                  AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
         $return = $conn->getOne($sql, array($month));
@@ -136 +136 @@
     $col.= "(SELECT det.product_name FROM dtb_order_detail AS det WHERE ord.order_id = det.order_id LIMIT 1) AS product_name, ";
     $col.= "(SELECT pay.payment_method FROM dtb_payment AS pay WHERE ord.payment_id = pay.payment_id) AS payment_method, "; 
-    $col.= "current_timestamp ";
+    $col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";
     $from = "dtb_order AS ord";
     $where = "del_flg = 0";