| 1 |
--- call-log.php.old 2009-07-07 13:16:12.000000000 +0400 |
|---|
| 2 |
+++ call-log.php 2009-07-07 14:09:33.000000000 +0400 |
|---|
| 3 |
@@ -287,7 +287,7 @@ |
|---|
| 4 |
$_SESSION["pr_sql_export"]="SELECT $FG_COL_QUERY FROM $FG_TABLE_NAME WHERE $FG_TABLE_CLAUSE"; |
|---|
| 5 |
|
|---|
| 6 |
/************************/ |
|---|
| 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) |
|---|
| 8 |
+ $QUERY = "SELECT to_char(calldate,'DD') AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY to_char(calldate,'DD')"; //extract(DAY from calldate) |
|---|
| 9 |
//echo "$QUERY"; |
|---|
| 10 |
|
|---|
