blob: 32dee4bf9ba03e04b6367d22ec8497d7ba1e210d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
--- call-log.php.orig 2012-04-05 10:48:18.000000000 +0300
+++ call-log.php 2012-04-05 10:48:29.000000000 +0300
@@ -229,7 +229,7 @@
/************************/
- $QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)"; //extract(DAY from calldate)
+ $QUERY = "SELECT cast(calldate as date) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY cast(calldate as date) order by 1 desc"; //extract(DAY from calldate)
//echo "$QUERY";
|
