Attachment #123335 for bug #166662

Lines 7-13 Link Here

(-)Makefile (-1 / +2 lines)
7		7
8	PORTNAME= asterisk-stat	8	PORTNAME= asterisk-stat
9	PORTVERSION= 2.0.1	9	PORTVERSION= 2.0.1
10	PORTREVISION= 10	10	PORTREVISION= 11
11	CATEGORIES= www	11	CATEGORIES= www
12	MASTER_SITES= http://www.areski.net/${SITE_SUBDIR}/	12	MASTER_SITES= http://www.areski.net/${SITE_SUBDIR}/
13	DISTNAME= ${PORTNAME}-v${PORTVERSION:S/./_/g}	13	DISTNAME= ${PORTNAME}-v${PORTVERSION:S/./_/g}
Lines 32-37 Link Here
32		32
33	.if defined(WITH_PGSQL)	33	.if defined(WITH_PGSQL)
34	ASTERISKSTATDB= pgsql	34	ASTERISKSTATDB= pgsql
		35	EXTRA_PATCHES+= ${FILESDIR}/pgsql__patch-call.log.php
35	.else	36	.else
36	ASTERISKSTATDB= mysql	37	ASTERISKSTATDB= mysql
37	RUN_DEPENDS+= ${LOCALBASE}/lib/asterisk/modules/cdr_addon_mysql.so:${PORTSDIR}/net/asterisk16-addons	38	RUN_DEPENDS+= ${LOCALBASE}/lib/asterisk/modules/cdr_addon_mysql.so:${PORTSDIR}/net/asterisk16-addons

Added Link Here

(-)files/pgsql__patch-call.log.php (+9 lines)
1	--- call-log.php.orig 2012-04-05 10:48:18.000000000 +0300
2	+++ call-log.php 2012-04-05 10:48:29.000000000 +0300
3	@@ -229,7 +229,7 @@
4
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 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)
9	//echo "$QUERY";

Return to bug 166662