Attachment 123335 Details for Bug 166662 – www_askrisk-stat.patch

[patch] www_askrisk-stat.patch

www_askrisk-stat.patch (text/x-patch), 1.62 KB, created by Michael Scheidell on 2012-05-26 12:57:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Michael Scheidell

Created: 2012-05-26 12:57:04 UTC

Size: 1.62 KB

patch

obsolete

>Index: Makefile
>===================================================================
>RCS file: /home/pcvs/ports/www/asterisk-stat/Makefile,v
>retrieving revision 1.13
>diff -u -r1.13 Makefile
>--- Makefile	14 Sep 2011 21:42:04 -0000	1.13
>+++ Makefile	26 May 2012 11:52:41 -0000
>@@ -7,7 +7,7 @@
> 
> PORTNAME=	asterisk-stat
> PORTVERSION=	2.0.1
>-PORTREVISION=	10
>+PORTREVISION=	11
> CATEGORIES=	www
> MASTER_SITES=	http://www.areski.net/${SITE_SUBDIR}/
> DISTNAME=	${PORTNAME}-v${PORTVERSION:S/./_/g}
>@@ -32,6 +32,7 @@
> 
> .if defined(WITH_PGSQL)
> ASTERISKSTATDB=	pgsql
>+EXTRA_PATCHES+=	${FILESDIR}/pgsql__patch-call.log.php
> .else
> ASTERISKSTATDB=	mysql
> RUN_DEPENDS+=	${LOCALBASE}/lib/asterisk/modules/cdr_addon_mysql.so:${PORTSDIR}/net/asterisk16-addons
>Index: files/pgsql__patch-call.log.php
>===================================================================
>RCS file: files/pgsql__patch-call.log.php
>diff -N files/pgsql__patch-call.log.php
>--- /dev/null	1 Jan 1970 00:00:00 -0000
>+++ files/pgsql__patch-call.log.php	26 May 2012 11:52:41 -0000
>@@ -0,0 +1,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";

Actions: View | Diff

Attachments on bug 166662: 123334 | 123335