Index: temp/trunk/html/admin/home.php
===================================================================
--- temp/trunk/html/admin/home.php	(revision 1328)
+++ temp/trunk/html/admin/home.php	(revision 4608)
@@ -58,5 +58,5 @@
 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,5 +67,5 @@
 	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,5 +79,5 @@
 	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,5 +89,5 @@
 	$objQuery = new SC_Query();
 	$col = "SUM(point)";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$from = "dtb_customer";
 	$ret = $objQuery->get($from, $col, $where);
@@ -97,5 +97,5 @@
 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,5 +104,5 @@
 
 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,5 +125,5 @@
 	$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);