Navigation

← Previous Changeset
Next Changeset →

Changeset 1004

Timestamp:

09/13/08 23:42:09 (3 years ago)

Author:

areski

Message:

Optimization on terminatecause

Files:

trunk/customer/A2B_entity_call_details_pdf.php (modified) (2 diffs)
trunk/customer/A2B_entity_call_details.php (modified) (3 diffs)
trunk/customer/call-history.php (modified) (9 diffs)
trunk/customer/card-history.php (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/customer/A2B_entity_call_details_pdf.php

r776	r1004
14	14	}
15	15
16		getpost_ifset(array('customer', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'fromstatsmonth_sday', 'fromstatsmonth_shour', 'tostatsmonth_sday', 'tostatsmonth_shour', 'srctype', 'src', 'choose_currency','exporttype','terminatecause'));
	16	getpost_ifset(array('customer', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'fromstatsmonth_sday', 'fromstatsmonth_shour', 'tostatsmonth_sday', 'tostatsmonth_shour', 'srctype', 'src', 'choose_currency','exporttype','terminatecauseid'));
17	17
18	18	$customer = $_SESSION["pr_login"];
…	…
166	166
167	167
168		if (!isset($terminatecause)){
169		$terminatecause="ALL";
170		}
171		if ($terminatecause=="ANSWER") {
	168	if (!isset($terminatecauseid)){
	169	$terminatecauseid="ALL";
	170	}
	171	if ($terminatecauseid=="ANSWER") {
172	172	if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
173		$FG_TABLE_CLAUSE.=" (t1.terminatecause~~='ANSWER' OR t1.terminatecause='ANSWERED'~~) ";
	173	$FG_TABLE_CLAUSE.=" (t1.terminatecauseid=1) ";
174	174	}
175	175

trunk/customer/A2B_entity_call_details.php

r776	r1004
12	12	}
13	13
14		getpost_ifset(array('customer', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'fromstatsmonth_sday', 'fromstatsmonth_shour', 'tostatsmonth_sday', 'tostatsmonth_shour', 'srctype', 'src', 'choose_currency','exporttype','terminatecause'));
	14	getpost_ifset(array('customer', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'fromstatsmonth_sday', 'fromstatsmonth_shour', 'tostatsmonth_sday', 'tostatsmonth_shour', 'srctype', 'src', 'choose_currency','exporttype','terminatecauseid'));
15	15
16	16	$customer = $_SESSION["pr_login"];
…	…
181	181
182	182
183		if (!isset($terminatecause)){
184		$terminatecause="ALL";
185		}
186		if ($terminatecause=="ANSWER") {
	183	if (!isset($terminatecauseid)){
	184	$terminatecauseid="ALL";
	185	}
	186	if ($terminatecauseid=="ANSWER") {
187	187	if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
188		$FG_TABLE_CLAUSE.=" (t1.terminatecause~~='ANSWER' OR t1.terminatecause='ANSWERED'~~) ";
	188	$FG_TABLE_CLAUSE.=" (t1.terminatecauseid=1) ";
189	189	}
190	190
…	…
512	512	<td class="fontstyle_searchoptions">
513	513	<?php echo gettext("Answered Calls"); ?>
514		<input name="terminatecause~~" type="radio" value="ANSWER" <?php if((!isset($terminatecause))\|\|($terminatecause~~=="ANSWER")){?>checked<?php }?> />
	514	<input name="terminatecauseid" type="radio" value="ANSWER" <?php if((!isset($terminatecauseid))\|\|($terminatecauseid=="ANSWER")){?>checked<?php }?> />
515	515	<?php echo gettext("All Calls"); ?>
516	516
517		<input name="terminatecause~~" type="radio" value="ALL" <?php if($terminatecause~~=="ALL"){?>checked<?php }?>/>
	517	<input name="terminatecauseid" type="radio" value="ALL" <?php if($terminatecauseid=="ALL"){?>checked<?php }?>/>
518	518	</td>
519	519	</tr>

trunk/customer/call-history.php

r776	r1004
31	31	$customer = $_SESSION["pr_login"];
32	32
33		getpost_ifset(array('posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'choose_currency', 'terminatecause', 'choose_calltype'));
	33	getpost_ifset(array('posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'choose_currency', 'terminatecauseid', 'choose_calltype'));
34	34
35	35
…	…
70	70	$FG_TABLE_COL[]=array (gettext("Duration"), "sessiontime", "7%", "center", "SORT", "30", "", "", "", "", "", "display_minute");
71	71	$FG_TABLE_COL[]=array (gettext("Cardused"), "username", "11%", "center", "SORT", "30");
72		$FG_TABLE_COL[]=array ('<acronym title="'.gettext("Terminate Cause").'">'.gettext("TC").'</acronym>', "terminatecause", "9%", "center", "SORT", "30");
	72	$FG_TABLE_COL[]=array ('<acronym title="'.gettext("Terminate Cause").'">'.gettext("TC").'</acronym>', "terminatecauseid", "9%", "center", "SORT", "30");
73	73	$FG_TABLE_COL[]=array (gettext("Calltype"), "sipiax", "6%", "center", "SORT", "", "list", $list_calltype);
74	74	$FG_TABLE_COL[]=array (gettext("InitalRate"), "calledrate", "9%", "center", "SORT", "30", "", "", "", "", "", "display_2bill");
…	…
80	80
81	81	// This Variable store the argument for the SQL query
82		$FG_COL_QUERY='t1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecause, t1.sipiax, t1.calledrate, t1.sessionbill';
	82	$FG_COL_QUERY='t1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecauseid, t1.sipiax, t1.calledrate, t1.sessionbill';
83	83	// t1.stoptime,
84	84
…	…
178	178	}
179	179
180		//To select just terminatecause=ANSWER
181		if (!isset($terminatecause)){
182		$terminatecause="ANSWER";
183		}
184		if ($terminatecause=="ANSWER") {
	180	//To select just terminatecauseid=ANSWER
	181	if (!isset($terminatecauseid)){
	182	$terminatecauseid="ANSWER";
	183	}
	184	if ($terminatecauseid=="ANSWER") {
185	185	if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
186		$FG_TABLE_CLAUSE .= " (t1.terminatecause~~='ANSWER' OR t1.terminatecause='ANSWERED'~~) ";
	186	$FG_TABLE_CLAUSE .= " (t1.terminatecauseid=1) ";
187	187	}
188	188
…	…
257	257	<!-- Part for the research -->
258	258	<center>
259		<FORM METHOD=POST ACTION="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo $current_page?>&terminatecause~~=<?php echo $terminatecause~~?>">
	259	<FORM METHOD=POST ACTION="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo $current_page?>&terminatecauseid=<?php echo $terminatecauseid?>">
260	260	<INPUT TYPE="hidden" NAME="posted" value=1>
261	261	<INPUT TYPE="hidden" NAME="current_page" value=0>
…	…
427	427	<td width="80%" class="fontstyle_searchoptions">
428	428	<?php echo gettext("Answered Calls"); ?>
429		<input name="terminatecause~~" type="radio" value="ANSWER" <?php if((!isset($terminatecause))\|\|($terminatecause~~=="ANSWER")){?>checked<?php }?> />
	429	<input name="terminatecauseid" type="radio" value="ANSWER" <?php if((!isset($terminatecauseid))\|\|($terminatecauseid=="ANSWER")){?>checked<?php }?> />
430	430	<?php echo gettext("All Calls"); ?>
431	431
432		<input name="terminatecause~~" type="radio" value="ALL" <?php if($terminatecause~~=="ALL"){?>checked<?php }?>/>
	432	<input name="terminatecauseid" type="radio" value="ALL" <?php if($terminatecauseid=="ALL"){?>checked<?php }?>/>
433	433	</td>
434	434	</tr>
…	…
505	505	<?php if (strtoupper($FG_TABLE_COL[$i][4])=="SORT"){?>
506	506	<a href="<?php echo $PHP_SELF."?customer=$customer&s=1&t=0&stitle=$stitle&atmenu=$atmenu&current_page=$current_page&order=".$FG_TABLE_COL[$i][1]."&sens="; if ($sens=="ASC"){echo"DESC";}else{echo"ASC";}
507		echo "&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecause~~=$terminatecause~~&choose_calltype=$choose_calltype";?>">
	507	echo "&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecauseid=$terminatecauseid&choose_calltype=$choose_calltype";?>">
508	508	<span class="liens"><?php } ?>
509	509	<?php echo $FG_TABLE_COL[$i][0]?>
…	…
622	622	<?php if ($current_page>0){?>
623	623	<img src="<?php echo Images_Path_Main ?>/fleche-g.gif" width="5" height="10"> <a href="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo ($current_page-1)?><?php if (!is_null($letter) && ($letter!="")){ echo "&letter=$letter";}
624		echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecause~~=$terminatecause~~&choose_calltype=$choose_calltype";?>">
	624	echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecauseid=$terminatecauseid&choose_calltype=$choose_calltype";?>">
625	625	<?php echo gettext("PREVIOUS");?> </a> -
626	626	<?php }?>
…	…
628	628	<?php if ($current_page<$nb_record_max-1){?>
629	629	- <a href="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo ($current_page+1)?><?php if (!is_null($letter) && ($letter!="")){ echo "&letter=$letter";}
630		echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecause~~=$terminatecause~~&choose_calltype=$choose_calltype";?>">
	630	echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid&terminatecauseid=$terminatecauseid&choose_calltype=$choose_calltype";?>">
631	631	<?php echo gettext("NEXT");?> </a> <img src="<?php echo Images_Path_Main ?>/fleche-d.gif" width="5" height="10">
632	632	</B></SPAN>

trunk/customer/card-history.php

r566	r1004
164	164	<!-- Part for the research -->
165	165	<center>
166		<FORM METHOD=POST ACTION="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo $current_page?>&terminatecause~~=<?php echo $terminatecause~~?>">
	166	<FORM METHOD=POST ACTION="<?php echo $PHP_SELF?>?s=1&t=0&order=<?php echo $order?>&sens=<?php echo $sens?>&current_page=<?php echo $current_page?>&terminatecauseid=<?php echo $terminatecauseid?>">
167	167	<INPUT TYPE="hidden" NAME="posted" value=1>
168	168	<INPUT TYPE="hidden" NAME="current_page" value=0>

Download in other formats: