Hello All!
WARNING: Only Tested on Asterisk2Billing V1.2.3 (BrainCoral)
As per request this thread should...hopefully show you how to add Rate Letter Sorting to your Call Rates.....as i have done here:
http://forum.a2billing.net/viewtopic.php?t=1700
Keep in mind this fix is
NOT for the faint of heart, as this is a fairly intensive addon.....but well worth it in my opinion....
PP_menu.php
Change Line 117
Code:
href="A2B_entity_ratecard.php?form_action=list"
TOCode:
href="A2B_entity_ratecard.php?form_action=list&ratesort=A"
A2B_entity_ratecard.phpBelow ( Line 8 )Code:
if (! has_rights (ACX_ACCESS)){
Header ("HTTP/1.0 401 Unauthorized");
Header ("Location: PP_error.php?c=accessdenied");
die();
}
ADDCode:
$ratesort = $_GET['ratesort'];
if (strlen($ratesort)==0) $ratesort='A';
FINALCode:
if (! has_rights (ACX_ACCESS)){
Header ("HTTP/1.0 401 Unauthorized");
Header ("Location: PP_error.php?c=accessdenied");
die();
}
$ratesort = $_GET['ratesort'];
if (strlen($ratesort)==0) $ratesort='A';
Below ( Line 19 )Code:
$HD_Form -> setDBHandler (DbConnect());
$HD_Form -> init();
ADDCode:
$HD_Form -> FG_TABLE_CLAUSE .= " AND SUBSTRING(cc_ratecard.destination,1,1)='".strtolower($ratesort)."'"; // sort by first letter
FINALCode:
$HD_Form -> setDBHandler (DbConnect());
$HD_Form -> init();
$HD_Form -> FG_TABLE_CLAUSE .= " AND SUBSTRING(cc_ratecard.destination,1,1)='".strtolower($ratesort)."'"; // sort by first letter
Below ( Line 52 )Code:
// #### TOP SECTION PAGE
$HD_Form -> create_toppage ($form_action);
ADDCode:
?>
<table width="75%" border=0 cellspacing=1 cellpadding=3 bgcolor="#000033" align="center">
<tr>
<td bgcolor="#000033" width="100%" valign="top" align="center" class="bb2">
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=A">A</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=B">B</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=C">C</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=D">D</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=E">E</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=F">F</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=G">G</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=H">H</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=I">I</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=J">J</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=K">K</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=L">L</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=M">M</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=N">N</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=O">O</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=P">P</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Q">Q</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=R">R</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=S">S</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=T">T</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=U">U</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=V">V</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=W">W</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=X">X</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Y">Y</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Z">Z</a>
</td>
</tr>
</table>
<?php
FINALCode:
// #### TOP SECTION PAGE
$HD_Form -> create_toppage ($form_action);
?>
<table width="75%" border=0 cellspacing=1 cellpadding=3 bgcolor="#000033" align="center">
<tr>
<td bgcolor="#000033" width="100%" valign="top" align="center" class="bb2">
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=A">A</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=B">B</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=C">C</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=D">D</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=E">E</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=F">F</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=G">G</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=H">H</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=I">I</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=J">J</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=K">K</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=L">L</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=M">M</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=N">N</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=O">O</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=P">P</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Q">Q</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=R">R</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=S">S</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=T">T</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=U">U</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=V">V</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=W">W</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=X">X</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Y">Y</a>
<a href="A2B_entity_ratecard.php?form_action=list&ratesort=Z">Z</a>
</td>
</tr>
</table>
<?php
// #### CREATE FORM OR LIST
../lib/Form/Class.FormHandler.inc.phpfunction create_formBelow ( Line 1954 )
Code:
if (isset($_POST['stitle'])) $stitle = $_POST['stitle'];
else $stitle = $_GET['stitle'];
ADDCode:
if (isset($_POST['ratesort'])) $ratesort = $_POST['ratesort'];
else $ratesort = $_GET['ratesort'];
FINALCode:
if (isset($_POST['stitle'])) $stitle = $_POST['stitle'];
else $stitle = $_GET['stitle'];
if (isset($_POST['ratesort'])) $ratesort = $_POST['ratesort'];
else $ratesort = $_GET['ratesort'];
Below ( Line 1964 )Code:
$atmenu = $_GET['atmenu'];
ADDCode:
$ratesort = $_GET['ratesort'];
FINALCode:
$atmenu = $_GET['atmenu'];
$ratesort = $_GET['ratesort'];
../lib/Form/Class.ViewHandler.inc.phpBelow ( Line 94 )Code:
$stitle = $_GET['stitle'];
ADDCode:
$ratesort = $_GET['ratesort'];
FINALCode:
$stitle = $_GET['stitle'];
$ratesort = $_GET['ratesort'];
Change ( Line 455 )FROMCode:
$c_url = $_SERVER['PHP_SELF'].'?stitle='.$stitle.'&atmenu='.$atmenu.'¤t_page=%s'."&filterprefix=".$_GET['filterprefix']."&order=".$_GET['order']."&sens=".$_GET['sens']."&mydisplaylimit=".$_GET['mydisplaylimit'].$this-> CV_FOLLOWPARAMETERS;
TOCode:
$c_url = $_SERVER['PHP_SELF'].'?stitle='.$stitle.'&atmenu='.$atmenu.'¤t_page=%s'."&filterprefix=".$_GET['filterprefix']."&order=".$_GET['order']."&sens=".$_GET['sens']."&mydisplaylimit=".$_GET['mydisplaylimit']."&ratesort=".$ratesort.$this-> CV_FOLLOWPARAMETERS;
PHEW...did you make it this far? If so congrats....check out your new toy....post problems, suggestions, or anything else here.....have fun everyone!