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; } } }