Index: temp/trunk/html/admin/home.php
===================================================================
--- temp/trunk/html/admin/home.php	(revision 4608)
+++ temp/trunk/html/admin/home.php	(revision 4666)
@@ -66,6 +66,12 @@
 function lfGetOrderYesterday($conn, $method){
 	if ( $method == 'SUM' or $method == 'COUNT'){
-		$sql = "SELECT ".$method."(total) FROM dtb_order
-				 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
+		// postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
+		if (DB_TYPE == "pgsql") {
+			$sql = "SELECT ".$method."(total) FROM dtb_order
+					 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
+		}else if (DB_TYPE == "mysql") {
+			$sql = "SELECT ".$method."(total) FROM dtb_order
+					 WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day)";
+		}
 		$return = $conn->getOne($sql);
 	}
@@ -80,5 +86,5 @@
 		$sql = "SELECT ".$method."(total) FROM dtb_order
 				 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')";
+				 AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
 		$return = $conn->getOne($sql, array($month));
 	}
@@ -96,7 +102,14 @@
 
 function lfGetReviewYesterday($conn){
-	$sql = "SELECT COUNT (*) FROM dtb_review 
-			 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')";
+	// postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
+	if (DB_TYPE == "pgsql") {
+		$sql = "SELECT COUNT (*) FROM dtb_review 
+				 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')";
+	}else if (DB_TYPE == "mysql") {
+		$sql = "SELECT COUNT (*) FROM dtb_review 
+				 WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day)
+				 AND cast(substring(create_date,1, 10) as date) != cast(substring(now(),1, 10) as date)";
+	}
 	$return = $conn->getOne($sql);
 	return $return;