Register - Revision history

Dana: /* Section [call.cdr] */

2014-01-11T10:47:26Z

‎Section [call.cdr]

Dana: /* Section [call.cdr] */

2014-01-11T10:37:26Z

‎Section [call.cdr]

Dana: /* Section [call.cdr] */

2014-01-11T10:36:48Z

‎Section [call.cdr]

Monica: /* Section [resource.subscribe] */

2013-11-04T11:19:22Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-11-04T11:14:52Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-10-31T14:00:17Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-10-31T13:56:23Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-10-31T13:46:22Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-10-31T13:45:50Z

‎Section [resource.subscribe]

Monica: /* Section [resource.subscribe] */

2013-08-23T08:11:06Z

‎Section [resource.subscribe]

@@ Line 161: / Line 161: @@
 **initquery=UPDATE cdr SET ended=true WHERE ended IS NULL OR NOT ended
 **cdr_initialize=INSERT INTO cdr VALUES(TIMESTAMP 'EPOCH' + INTERVAL '${time} s','${chan}','${address}','${direction}','${billid}','${caller}','${called}',INTERVAL '${duration} s' ,INTERVAL '${billtime} s',INTERVAL '${ringtime} s','${status}','${reason}',false)
-**cdr_update=UPDATE cdr SET caller='${caller}',called='${called}',duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}' WHERE chan='${chan}' AND billid='${billid}'
+**cdr_update=UPDATE cdr SET address='${address}',direction='${direction}',billid='${billid}', caller='${caller}',called='${called}',duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}', reason='${reason}' WHERE chan='${chan}' AND time=TIMESTAMP 'EPOCH' + INTERVAL '${time} s'
-**cdr_finalize=UPDATE cdr SET caller='${caller}', called='${called}', duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}',ended=true WHERE chan='${chan}' AND billid='${billid}'
+**cdr_finalize=UPDATE cdr SET address='${address}',direction='${direction}', billid='${billid}',caller='${caller}',called='${called}',duration=INTERVAL '${duration} s', billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}', reason='${reason}',ended=true WHERE chan='${chan}' AND time=TIMESTAMP 'EPOCH' + INTERVAL '${time} s'
 **cdr_combined=INSERT INTO cdr VALUES(TIMESTAMP 'EPOCH' + INTERVAL '${time} s','${chan}','${address}','${caller}','${called}',INTERVAL '${duration} s', INTERVAL '${billtime} s', INTERVAL '${ringtime} s','${status}','${reason}','${out_leg.chan}','${out_leg.address}', INTERVAL '${out_leg.billtime} s',INTERVAL '${out_leg.ringtime} s', INTERVAL '${out_leg.duration} s','${out_leg.reason}'

@@ Line 163: / Line 163: @@
 **cdr_update=UPDATE cdr SET caller='${caller}',called='${called}',duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}' WHERE chan='${chan}' AND billid='${billid}'
 **cdr_finalize=UPDATE cdr SET caller='${caller}', called='${called}', duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}',ended=true WHERE chan='${chan}' AND billid='${billid}'
-**cdr_combined=INSERT INTO cdr VALUES(TIMESTAMP 'EPOCH' + INTERVAL '${time} s','${chan}','${address}','${caller}','${called}',INTERVAL '${duration} s',INTERVAL '${billtime} s',
+**cdr_combined=INSERT INTO cdr VALUES(TIMESTAMP 'EPOCH' + INTERVAL '${time} s','${chan}','${address}','${caller}','${called}',INTERVAL '${duration} s', INTERVAL '${billtime} s', INTERVAL '${ringtime} s','${status}','${reason}','${out_leg.chan}','${out_leg.address}', INTERVAL '${out_leg.billtime} s',INTERVAL '${out_leg.ringtime} s', INTERVAL '${out_leg.duration} s','${out_leg.reason}'
 INTERVAL '${ringtime} s','${status}','${reason}','${out_leg.chan}','${out_leg.address}', INTERVAL '${out_leg.billtime} s',INTERVAL '${out_leg.ringtime} s',
 INTERVAL '${out_leg.duration} s','${out_leg.reason}'
 '''BE CAREFUL:'''

@@ Line 163: / Line 163: @@
 **cdr_update=UPDATE cdr SET caller='${caller}',called='${called}',duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}' WHERE chan='${chan}' AND billid='${billid}'
 **cdr_finalize=UPDATE cdr SET caller='${caller}', called='${called}', duration=INTERVAL '${duration} s',billtime=INTERVAL '${billtime} s',ringtime=INTERVAL '${ringtime} s',status='${status}',reason='${reason}',ended=true WHERE chan='${chan}' AND billid='${billid}'
 '''BE CAREFUL:'''

← Older revision		Revision as of 11:19, 4 November 2013
Line 213:		Line 213:
	* [[Routing]]		* [[Routing]]

−	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:~~Subscription~~]] [[Category:Call counters]] [[Category:Users]] [[Category:Billing]]	+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscribe]] [[Category:Call counters]] [[Category:Users]] [[Category:Billing]]

← Older revision		Revision as of 11:14, 4 November 2013
Line 213:		Line 213:
	* [[Routing]]		* [[Routing]]

−	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]] [[Category:Call counters]] [[Category:Users]]	+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]] [[Category:Call counters]] [[Category:Users]] [[Category:Billing]]

← Older revision		Revision as of 14:00, 31 October 2013
Line 213:		Line 213:
	* [[Routing]]		* [[Routing]]

−	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]] [[Category:Call counters]]	+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]] [[Category:Call counters]] [[Category:Users]]

← Older revision		Revision as of 13:56, 31 October 2013
Line 213:		Line 213:
	* [[Routing]]		* [[Routing]]

−	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]]	+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]] [[Category:Call counters]]

← Older revision		Revision as of 13:46, 31 October 2013
Line 213:		Line 213:
	* [[Routing]]		* [[Routing]]

−	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]]	+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]] [[Category:Subscription]]

← Older revision		Revision as of 13:45, 31 October 2013
Line 212:		Line 212:
	* [[CDR File Module]]		* [[CDR File Module]]
	* [[Routing]]		* [[Routing]]
		+
		+	[[Category:Routing]] [[Category:Registration]] [[Category:Authorization]] [[Category:CDR]] [[Category:Database]]

@@ Line 208: / Line 208: @@
 '''See also'''
-* See [[Register Database Schema]] for PostgreSQL and Mysql database schema and MySQL CDR queries.
+* [[Register Database Schema]] for PostgreSQL and Mysql database schema and MySQL CDR queries.
 * [[CDR Build Module]]
 * [[CDR File Module]]
 * [[Routing]]