Changeset 900
- Timestamp:
- 07/25/08 12:17:53 (1 month ago)
- Files:
-
- trunk/admin/Public/call-log-customers.php (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/admin/Public/call-log-customers.php
r892 r900 11 11 } 12 12 13 getpost_ifset(array('customer', 'entercustomer', 'enterprovider', 'entertariffgroup', 'entertrunk', 'enterratecard', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'srctype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'choose_currency', 'terminatecause', 'choose_calltype'));13 getpost_ifset(array('customer', 'entercustomer', 'enterprovider', 'entertariffgroup', 'entertrunk', 'enterratecard', 'posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'srctype','dnidtype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src','dnid', 'clid', 'choose_currency', 'terminatecause', 'choose_calltype')); 14 14 15 15 … … 73 73 $FG_TABLE_COL[]=array (gettext("Calldate"), "starttime", "15%", "center", "SORT", "19", "", "", "", "", "", "display_dateformat"); 74 74 $FG_TABLE_COL[]=array (gettext("Source"), "src", "7%", "center", "SORT", "30"); 75 $FG_TABLE_COL[]=array (gettext("Dnid"), "dnid", "7%", "center", "SORT", "30"); 75 76 $FG_TABLE_COL[]=array (gettext("CalledNumber"), "calledstation", "10%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 76 77 $FG_TABLE_COL[]=array (gettext("Destination"), "destination", "10%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); … … 93 94 94 95 // This Variable store the argument for the SQL query 95 $FG_COL_QUERY='t1.starttime, t1.src, t1. calledstation, t1.destination, t1.sessiontime, t1.username, t3.trunkcode, t1.terminatecause, t1.sipiax, t1.buycost, t1.sessionbill, case when t1.sessionbill!=0 then ((t1.sessionbill-t1.buycost)/t1.sessionbill)*100 else NULL end as margin,case when t1.buycost!=0 then ((t1.sessionbill-t1.buycost)/t1.buycost)*100 else NULL end as markup';96 $FG_COL_QUERY='t1.starttime, t1.src, t1.dnid ,t1.calledstation, t1.destination, t1.sessiontime, t1.username, t3.trunkcode, t1.terminatecause, t1.sipiax, t1.buycost, t1.sessionbill, case when t1.sessionbill!=0 then ((t1.sessionbill-t1.buycost)/t1.sessionbill)*100 else NULL end as margin,case when t1.buycost!=0 then ((t1.sessionbill-t1.buycost)/t1.buycost)*100 else NULL end as markup'; 96 97 if (LINK_AUDIO_FILE) { 97 98 $FG_COL_QUERY .= ', t1.uniqueid'; … … 134 135 $SQLcmd = do_field($SQLcmd, 'src', 'src'); 135 136 $SQLcmd = do_field($SQLcmd, 'dst', 'calledstation'); 137 $SQLcmd = do_field($SQLcmd, 'dnid', 'dnid'); 136 138 } 137 139 … … 480 482 </tr> 481 483 484 <tr> 485 <td align="left" class="bgcolor_004"> 486 <font class="fontstyle_003"> <?php echo gettext("DNID");?></font> 487 </td> 488 <td class="bgcolor_005" align="left"> 489 <table width="100%" border="0" cellspacing="0" cellpadding="0" > 490 <tr><td> <INPUT TYPE="text" NAME="dnid" value="<?php echo "$dnid";?>" class="form_input_text"></td> 491 <td class="fontstyle_searchoptions" align="center" ><input type="radio" NAME="dnidtype" value="1" <?php if((!isset($dnidtype))||($dnidtype==1)){?>checked<?php }?>><?php echo gettext("Exact");?></td> 492 <td class="fontstyle_searchoptions" align="center" ><input type="radio" NAME="dnidtype" value="2" <?php if($dnidtype==2){?>checked<?php }?>><?php echo gettext("Begins with");?></td> 493 <td class="fontstyle_searchoptions" align="center" ><input type="radio" NAME="dnidtype" value="3" <?php if($dnidtype==3){?>checked<?php }?>><?php echo gettext("Contains");?></td> 494 <td class="fontstyle_searchoptions" align="center" ><input type="radio" NAME="dnidtype" value="4" <?php if($dnidtype==4){?>checked<?php }?>><?php echo gettext("Ends with");?></td> 495 </tr></table></td> 496 </tr> 497 482 498 <!-- Select Calltype: --> 483 499 <tr>
