Changeset 12163

Timestamp:

2007/04/18 15:31:53 (17 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/html/admin/total/index.php (modified) (2 diffs)

branches/dev/html/admin/total/index.php

@@ -200 +200 @@
         // ¥Ð¥Ã¥Á¥â¡¼¥É¤Î¾ì¹ç¤Î¤ß¼Â¹Ô¤¹¤ë
         if(DAILY_BATCH_MODE) {
-            // 3ÆüÁ°¤Þ¤Ç¤Î½¸·×
-            lfStartDailyTotal(3,0);
+            // 1¥ö·îʬ¤Î½¸·×
+            lfStartDailyTotal(31,0);
         }
     }
@@ -617 +617 @@
     list($where, $arrval) = lfGetWhereMember('create_date', $sdate, $edate, $type);
     
-    $sql = "SELECT T1.product_id, T1.product_code, T1.product_name, T1.products_count, T1.order_count, T1.price, T1.total ";
+    $sql = "SELECT T1.product_id, T1.product_code, T2.name, T1.products_count, T1.order_count, T1.price, T1.total ";
     $sql.= "FROM ( ";
-    $sql.= "SELECT product_id, product_name, product_code, price, ";
+    $sql.= "SELECT product_id, product_code, price, ";
     $sql.= "COUNT(*) AS order_count, ";
     $sql.= "SUM(quantity) AS products_count, ";
     $sql.= "(price * sum(quantity)) AS total ";
     $sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE $where ) ";
-    $sql.= "GROUP BY product_id, product_name, product_code, price ";
-    $sql.= ") AS T1 ";
-    $sql.= "ORDER BY T1.total DESC ";
+    $sql.= "GROUP BY product_id, product_code, price ";
+    $sql.= ") ";
+    $sql.= "AS T1 LEFT JOIN dtb_products AS T2 USING (product_id) WHERE T2.name IS NOT NULL AND status = 1 ORDER BY T1.total DESC ";
     
     if($mode != "csv") {