moneyPara = $moneyPara"; if($add_area){ echo " "; exit(); } //编辑后保持对应tariff_id的页面 if ($keep_id != 1){ $tariff_id=isset($tariff_id)?$tariff_id:'00'; } else {$tariff_id=$return_tariff_id;} if($DEBUG) {echo "
keep_id=$keep_id
tariff_id=$return_tariff_id
";} $where=" WHERE tariff_id=$tariff_id "; //echo "
where=$where"; $str_sql ="SELECT count(*) FROM $table_name ".$where; // echo "
str_sql=$str_sql"; $result=mysqli_query($objDbConn,$str_sql); $record = mysqli_fetch_array($result); $number_of_records = $record[0]; $order = " ORDER BY $sort_field $sort_direction "; $sel_sql ="SELECT * FROM $table_name ".$where.$order; //echo "
sel_sql=$sel_sql"; $result = @mysqli_query($objDbConn,$sel_sql); $rows = @mysqli_fetch_array($result); echo mysqli_error($objDbConn); ?>

"> "; echo ""; echo ""; echo "$strThisPage"; echo ""; echo ""; showHelp($helpId); echo ""; echo ""; echo ""; echo ""; echo "$strTotal $strDisplayRecords: $number_of_records"; echo ""; echo ""; echo "$strResideZone: "; $maxCosSql = " SELECT pubVarValue FROM OMC_PUB.omcPubVarConf WHERE pubVarName = 'maxCOSNumber' "; $maxCosRes = @mysqli_query($pubConn,$maxCosSql); $maxCosRow = @mysqli_fetch_array($maxCosRes); $maxCosNum = $maxCosRow[pubVarValue]; echo ""; echo ""; echo ""; echo ""; adjust_title_tail(); adjust_content_head(); echo "
"; ?> "; echo "$strTariffNoRecords $tariff_id"."!"; exit(); } ?> $strResideZone"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?> "; // echo ""; echo ""; echo ""; if($rows[call_type]==4) echo ""; elseif($rows[call_type]==5) echo ""; else echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; /* $base_fee=$rows[base_fee]/$moneyPara; if($moneyPara < 10){ printf("",$base_fee); } elseif($moneyPara < 100){ printf("",$base_fee); } else{ printf("",$base_fee); } $long_distance_fee=$rows[long_distance_fee]/$moneyPara; if($moneyPara < 10){ printf("", $long_distance_fee); } elseif($moneyPara < 100){ printf("", $long_distance_fee); } else{ printf("", $long_distance_fee); } $adjustment_fee=$rows[adjustment]/$moneyPara; if($moneyPara < 10){ printf("", $adjustment_fee); } elseif($moneyPara < 100){ printf("", $adjustment_fee); } else{ printf("", $adjustment_fee); }*/ echo ""; }while($rows = mysqli_fetch_array($result)); ?>

Call
type

Discount
ID

$strUnitChargingTimeSecond

$strFreeChargeUnit

$strMinimumChargingUnit

$strBasicInitial

Tier Level

Tier0 Unit

$strBasicFee

$strBasicLongDistance

Tier1 Unit

$strBasicFee

$strBasicLongDistance

Tier2 Unit

$strBasicFee

$strBasicLongDistance

$rows[tariff_id]

$rows[bill_id]

$rows[area]

Local call in

Trunk call in

---

$rows[discount_id]

$rows[unit_time]

$rows[free_time]

$rows[mini_time]

$rows[base_fee]

$rows[long_distance_fee]

$rows[adjustment]

$rows[tier_level]

$rows[tier_unit_0]

$rows[base_fee_0]

$rows[long_distance_fee_0]

$rows[tier_unit_1]

$rows[base_fee_1]

$rows[long_distance_fee_1]

$rows[tier_unit_2]

$rows[base_fee_2]

$rows[long_distance_fee_2]

%5.0f

%5.1f

%5.2f

%5.0f

%5.1f

%5.2f

%5.0f

%5.1f

%5.2f

MMS Retrieve

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tableName="PPS_DB.vas_mms_retrieve_tariff"; $sql="select * from $tableName where tariff_id=$tariff_id order by mms_retrieve_id asc "; $res=@mysqli_query($objDbConn,$sql); $num=@mysqli_num_rows($res); $mms_retrieve_cap_flag_label=array(0=>"Disable",1=>"Enable"); $mms_retrieve_call_type_label=array(4=>"Local call in",5=>"Trunk call in"); for($i=0;$i<$num;$i++) { $row=@mysqli_fetch_array($res); echo ""; //ID $mms_retrieve_id=$row[mms_retrieve_id]; echo ""; //Prefix echo ""; //Call type echo ""; //Dest name echo ""; //Discount ID echo ""; //Charge fee echo ""; //Cap flag echo ""; echo ""; } //echo "tariff_id=$tariff_id
"; echo "
ID Prefix Call type Dest name Discount ID Charge fee Cap flag
"; echo "$mms_retrieve_id"; echo " "; if(trim($row[prefix]) == "") echo "--"; else echo "{$row[prefix]}"; echo " "; echo "{$mms_retrieve_call_type_label[$row[call_type]]} "; echo " "; if(trim($row[dest_name]) == "") echo "--"; else echo "{$row[dest_name]}"; echo " "; echo "{$row[discount_id]} "; echo " "; echo "{$row[charge_fee]} "; echo " "; echo "{$mms_retrieve_cap_flag_label[$row[cap_flag]]} "; echo "
"; ?> MMS Email

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tableName="PPS_DB.vas_mms_email_tariff"; $sql="select * from $tableName where tariff_id=$tariff_id order by email_id asc "; $res=@mysqli_query($objDbConn,$sql); $num=@mysqli_num_rows($res); $email_cap_flag_label=array(0=>"Disable",1=>"Enable"); $email_call_type_label=array(4=>"Local call in",5=>"Trunk call in"); for($i=0;$i<$num;$i++) { $row=@mysqli_fetch_array($res); echo ""; //ID $email_id=$row[email_id]; echo ""; //Prefix echo ""; //Call type echo ""; //Dest name echo ""; //Discount ID echo ""; //Charge fee echo ""; //Cap flag echo ""; echo ""; } //echo "tariff_id=$tariff_id
"; echo "
ID Prefix Call type Dest name Discount ID Charge fee Cap flag
"; echo "$email_id"; echo " "; if(trim($row[prefix]) == "") echo "--"; else echo "{$row[prefix]}"; echo " "; echo "{$email_call_type_label[$row[call_type]]} "; echo " "; if(trim($row[dest_name]) == "") echo "--"; else echo "{$row[dest_name]}"; echo " "; echo "{$row[discount_id]} "; echo " "; echo "{$row[charge_fee]} "; echo " "; echo "{$email_cap_flag_label[$row[cap_flag]]} "; echo "
"; ?>

ID	Prefix	Call type	Dest name	Discount ID	Charge fee	Cap flag
"; echo "$mms_retrieve_id"; echo "	"; if(trim($row[prefix]) == "") echo "--"; else echo "{$row[prefix]}"; echo "	"; echo "{$mms_retrieve_call_type_label[$row[call_type]]} "; echo "	"; if(trim($row[dest_name]) == "") echo "--"; else echo "{$row[dest_name]}"; echo "	"; echo "{$row[discount_id]} "; echo "	"; echo "{$row[charge_fee]} "; echo "	"; echo "{$mms_retrieve_cap_flag_label[$row[cap_flag]]} "; echo "