Changeset 4817 for temp/trunk/html

Timestamp:

2006/09/16 21:06:33 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• batch/daily.php (modified) (2 diffs)
• total/index.php (modified) (1 diff)

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

@@ -99 +99 @@
 // ¥Ð¥Ã¥Á½¸·×ÍѤÎSQLʸ¤ò¼èÆÀ¤¹¤ë¡£
 function lfGetOrderDailySQL() {
+    $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 ? ";
+    
+    $sql = "SELECT ";
+    $sql.= "COUNT(*) AS total_order, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt FROM $from WHERE $where AND customer_id = 0) AS nonmember ) AS nonmember, ";
+/*  $sql.= "SUM((SELECT COUNT(*) WHERE customer_id <> 0 GROUP BY customer_id)) AS member, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1)) AS men, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2)) AS women, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1 AND customer_id <> 0)) AS men_member, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 1 AND customer_id = 0)) AS men_nonmember, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2 AND customer_id <> 0)) AS women_member, ";
+    $sql.= "SUM((SELECT COUNT(*) WHERE order_sex = 2 AND customer_id = 0)) AS women_nonmember, ";*/
+    $sql.= "SUM(total) AS total, ";
+    $sql.= "int8(AVG(total)) AS total_average ";
+    $sql.= $from;
+    $sql.= $where;      // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
+    
+    
+/*  
     $sql = "SELECT ";
     $sql.= "COUNT(*) AS total_order, ";
@@ -111 +131 @@
     $sql.= "SUM(total) AS total, ";
     $sql.= "int8(AVG(total)) AS total_average ";
-    $sql.= "FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) ";
-    $sql.= "WHERE T1.del_flg = 0 AND T1.create_date BETWEEN ? AND ?";       // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
+    $sql.= $from;
+    $sql.= $where;      // ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
+*/
     return $sql;
 }

temp/trunk/html/admin/total/index.php

@@ -193 +193 @@
 $objPage->tpl_subtitle = $objPage->arrTitle[$objFormParam->getValue('page')];
 
-
 $objView->assignobj($objPage);
 $objView->display(MAIN_FRAME);