function showBuyRate($prefix)
{
global $locate;
$objResponse = new xajaxResponse();
//echo $prefix;exit;
if ($_SESSION['curuser']['usertype'] == 'reseller') {
$buyrate = astercc::searchRate($prefix, $_SESSION['curuser']['groupid'], $_SESSION['curuser']['resellerid'], 'resellerrate', "prefix");
if ($buyrate['id'] != '') {
$buyrateDesc = astercc::readRateDesc($buyrate);
$objResponse->assign("spanShowBuyRate", "innerHTML", $locate->Translate("Buy Rate") . ":" . $buyrate['destination'] . "(" . $buyrateDesc . ")");
} else {
$objResponse->assign("spanShowBuyRate", "innerHTML", "");
}
}
return $objResponse;
}
function searchRate($content, $type)
{
$objResponse = new xajaxResponse();
// echo $type;exit;
if ($content == '') {
return $objResponse;
}
$rate = astercc::searchRate($content, $_SESSION['curuser']['groupid'], $_SESSION['curuser']['resellerid'], "myrate", $type);
$rateDesc = astercc::readRateDesc($rate, 'search');
// remove the connect charge part
// $rateDesc = split("seconds",$rateDesc);
// $rateDesc = $rateDesc[1]." seconds";
if ($type == "prefix") {
$objResponse->addAssign("divRate", "innerHTML", $rate['destination'] . "(" . $rateDesc . ")");
} else {
$objResponse->addAssign("divRate", "innerHTML", $rate['dialprefix'] . "(" . $rateDesc . ")");
}
return $objResponse;
}
function searchRate($dst, $groupid, $resellerid, $tbl = 'myrate', $type = "prefix")
{
global $db;
$dst = trim($dst);
if ($groupid == '' || $groupid == '-1') {
#print "invalid identity";
return;
}
if ($type == "prefix") {
if ($tbl == "resellerrate") {
$sql = "SELECT * FROM {$tbl} WHERE resellerid = {$resellerid}";
} else {
$sql = "SELECT * FROM {$tbl} WHERE groupid = {$groupid} AND resellerid = {$resellerid}";
}
//echo $sql;exit;
astercc::events($sql);
$rates =& $db->query($sql);
$maxprefix = '';
$myrate = array();
$default = '';
while ($rates->fetchInto($list)) {
#print "start\n";
if ($list['dialprefix'] == 'default') {
$default = $list;
continue;
}
$prefixlength = strlen($list['dialprefix']);
if (substr($dst, 0, $prefixlength) == $list['dialprefix']) {
if ($prefixlength > strlen($maxprefix)) {
$myrate = $list;
$maxprefix = $list['dialprefix'];
}
}
}
if ($maxprefix == '' && $default == '') {
// did get rate from group
if ($groupid == "0" && $resellerid == "0") {
//print "done\n";
//exit;
return;
}
if ($groupid != "0" && $resellerid != "0") {
//print "here\n";
return astercc::searchRate($dst, "0", $resellerid, $tbl);
}
if ($groupid == 0 && $resellerid != 0) {
//print "ok";
//exit;
return astercc::searchRate($dst, "0", "0", $tbl, 'prefix');
}
//return astercc::readRate($dst,$groupid, $tbl);
}
if ($maxprefix == '') {
return $default;
} else {
return $myrate;
}
} else {
$sql = "SELECT * FROM {$tbl} WHERE groupid = {$groupid} AND resellerid = {$resellerid} AND destination = '" . $dst . "'";
//echo $sql;exit;
astercc::events($sql);
$rates =& $db->getRow($sql);
if ($rates['id'] != '') {
return $rates;
} elseif ($groupid != 0 && $resellerid != 0) {
return astercc::searchRate($dst, "0", "0", $tbl, 'dest');
} else {
return;
}
}
}
