Changeset 4910 for temp

Timestamp:

2006/09/17 20:11:59 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/batch/daily.php (modified) (1 diff)

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

@@ -107 +107 @@
     $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.customer_id <> 0) AS nonmember ) AS member, ";
     $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1) AS nonmember ) AS men, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2)) AS nonmember ) AS women, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND customer_id <> 0)) AS nonmember ) AS men_member, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND customer_id = 0) AS nonmember ) AS men_nonmember, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND customer_id <> 0) AS nonmember ) AS women_member, ";
-    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND customer_id = 0) AS nonmember ) AS women_nonmember, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2) AS nonmember ) AS women, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND T2.customer_id <> 0)) AS nonmember ) AS men_member, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 1 AND T2.customer_id = 0) AS nonmember ) AS men_nonmember, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND T2.customer_id <> 0) AS nonmember ) AS women_member, ";
+    $sql.= "(SELECT sum(cnt) FROM (SELECT COUNT(*) AS cnt $from $where AND T1.order_sex = 2 AND T2.customer_id = 0) AS nonmember ) AS women_nonmember, ";
     $sql.= "SUM(total) AS total, ";
     $sql.= "(AVG(total)) AS total_average ";