Changeset 4608 for temp/trunk/html/admin/home.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

temp/trunk/html/admin/home.php

@@ -58 +58 @@
 function lfGetCustomerCnt($conn){
     
-    $sql = "SELECT COUNT(customer_id) FROM dtb_customer WHERE delete = 0 AND status = 2";
+    $sql = "SELECT COUNT(customer_id) FROM dtb_customer WHERE del_flg = 0 AND status = 2";
     $return = $conn->getOne($sql);
     return $return;
@@ -67 +67 @@
     if ( $method == 'SUM' or $method == 'COUNT'){
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE delete = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
+                 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
         $return = $conn->getOne($sql);
     }
@@ -79 +79 @@
     if ( $method == 'SUM' or $method == 'COUNT'){
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE delete = 0 AND to_char(create_date,'YYYY/MM') = ? 
+                 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM') = ? 
                  AND to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD')";
         $return = $conn->getOne($sql, array($month));
@@ -89 +89 @@
     $objQuery = new SC_Query();
     $col = "SUM(point)";
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     $from = "dtb_customer";
     $ret = $objQuery->get($from, $col, $where);
@@ -97 +97 @@
 function lfGetReviewYesterday($conn){
     $sql = "SELECT COUNT (*) FROM dtb_review 
-             WHERE delete=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
+             WHERE del_flg=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
              AND to_char(create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
     $return = $conn->getOne($sql);
@@ -104 +104 @@
 
 function lfGetReviewNonDisp($conn){
-    $sql = "SELECT COUNT (*) FROM dtb_review WHERE delete=0 AND status=2";
+    $sql = "SELECT COUNT (*) FROM dtb_review WHERE del_flg=0 AND status=2";
     $return = $conn->getOne($sql);
     return $return;
@@ -125 +125 @@
     $col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";
     $from = "dtb_order AS ord";
-    $where = "delete = 0";
+    $where = "del_flg = 0";
     $objQuery->setoption("ORDER BY create_date DESC LIMIT 10 OFFSET 0");
     $arrRet = $objQuery->select($col, $from, $where);