Index: branches/dev/html/admin/total/index.php
===================================================================
--- branches/dev/html/admin/total/index.php	(revision 12162)
+++ branches/dev/html/admin/total/index.php	(revision 12163)
@@ -200,6 +200,6 @@
 		// ¥Ð¥Ã¥Á¥â¡¼¥É¤Î¾ì¹ç¤Î¤ß¼Â¹Ô¤¹¤ë
 		if(DAILY_BATCH_MODE) {
-			// 3ÆüÁ°¤Þ¤Ç¤Î½¸·×
-			lfStartDailyTotal(3,0);
+			// 1¥ö·îʬ¤Î½¸·×
+			lfStartDailyTotal(31,0);
 		}
 	}
@@ -617,14 +617,14 @@
 	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") {