public function view_query()
{
$ship_add = isset($_POST['ship_add']) ? abs(intval($_POST['ship_add'])) : 0;
//发货地址ID
$ship_country = isset($_POST['ship_country']) ? abs(intval($_POST['ship_country'])) : 0;
//发往国家ID
$ship_weight = isset($_POST['ship_weight']) ? abs(floatval($_POST['ship_weight'])) : 0;
//重量
$ship_carrier = isset($_POST['ship_carrier']) ? abs(intval($_POST['ship_carrier'])) : 0;
//运输方式ID
$ship_postcode = isset($_POST['ship_postcode']) ? trim($_POST['ship_postcode']) : '';
//待定
$ship_tid = isset($_POST['ship_tid']) ? intval($_POST['ship_tid']) : 0;
$errMsg = "";
//错误信息
$this->smarty->assign('title', '运费查询结果');
$queryObj = new ShipfeeQueryModel();
$addrlist = $queryObj->getAllShipAddrList();
//发货地列表
$this->smarty->assign('addrlist', $addrlist);
if ($ship_add == 5) {
$countrylist = TransOpenApiModel::getCountriesChina();
//中国地区名称列表
$this->smarty->assign('countrylist', $countrylist);
} else {
$countrylist = $queryObj->getStandardCountryName();
//标准国家名称列表
$this->smarty->assign('countrylist', $countrylist);
$transitlist = TransitCenterModel::modList(1, 1, 200);
$this->smarty->assign('transitlist', $transitlist);
}
$carrierlist = TransOpenApiModel::getCarrierByAdd($ship_add);
//获得所有的运输方式
$this->smarty->assign('carrierlist', $carrierlist);
$this->smarty->assign('ship_add', $ship_add);
$this->smarty->assign('ship_tid', $ship_tid);
$this->smarty->assign('ship_country', $ship_country);
$this->smarty->assign('ship_weight', $ship_weight);
$this->smarty->assign('ship_carrier', $ship_carrier);
$this->smarty->assign('ship_postcode', $ship_postcode);
if (empty($ship_add)) {
$errMsg .= "发货地址有误！<br/>";
}
if (empty($ship_country) && $ship_add != 2) {
$errMsg .= "发往国家/地区有误！<br/>";
}
if (empty($ship_weight)) {
$errMsg .= "重量输入有误！<br/>";
}
//是否存在国家/地区
if ($ship_add == 1) {
$countryinfo = $queryObj->getStdCountryNameById($ship_country);
if (empty($countryinfo)) {
$errMsg .= "发往国家不存在！<br/>";
}
}
if ($ship_add == 5) {
$countryinfo = TransOpenApiModel::getCountriesChina($ship_country);
if (empty($countryinfo)) {
$errMsg .= "发往地区不存在！<br/>";
}
}
//根据发货地ID获取相应的发货方式列表
$shiplist = $queryObj->getShipListByShipaddr($ship_add);
if (!empty($ship_carrier)) {
//如果选择了运输方式 验证改运输方式是否存在于选择的发货地
$exist = FALSE;
foreach ($shiplist as $shval) {
if ($shval['id'] == intval($ship_carrier)) {
$exist = TRUE;
unset($shiplist);
$shiplist = array($shval);
break;
}
}
if (!$exist) {
$errMsg .= "发货地和发货方式不匹配！";
}
}
// 计算每一种发货方式的运费
$shipfeeResult = array();
//运费计算结果集
foreach ($shiplist as $shipval) {
$result = array();
$channel = $queryObj->getChannelInfo($shipval['id']);
if (empty($channel)) {
//没找到合适的渠道信息 则跳过该运输方式
continue;
}
foreach ($channel as $ch) {
$result['chname'] = $ch['channelName'];
//渠道名
$result['carriername'] = $shipval['carrierNameCn'];
//运输方式名
$carriercountryname = $queryObj->translateStdCountryNameToShipCountryName($countryinfo['countryNameEn'], $shipval['id']);
if ($ship_add == 5) {
$res = $queryObj->calculateShipfee($ch['channelAlias'], $ship_weight, $ship_country, array('postCode' => $ship_postcode, 'transitId' => $ship_tid));
} else {
$res = $queryObj->calculateShipfee($ch['channelAlias'], $ship_weight, $carriercountryname, array('postCode' => $ship_postcode, 'transitId' => $ship_tid));
}
if (!$res) {
//FALSE 跳过
continue;
}
$result['totalfee'] = $res['totalfee'];
$result['shipfee'] = $res['fee'];
$result['rate'] = $res['discount'];
$shipfeeResult[] = $result;
}
}
$this->smarty->assign('errMsg', $errMsg);
$this->smarty->assign('lists', $shipfeeResult);
$this->smarty->display('shipfeeQuery.htm');
}
/**
* CountriesUsazoneAct::actModify()
* 返回某个美国邮政分区信息
* @param int $id 查询ID
* @return array
*/
public function actModify()
{
$data = array();
$id = isset($_GET['id']) ? intval(trim($_GET['id'])) : 0;
if (empty($id)) {
show_message($this->smarty, "ID不能为空？", "");
return false;
}
$data['id'] = $id;
$data['lists'] = TransitCenterModel::modList(1, 1, 200);
$data['res'] = CountriesUsazoneModel::modModify($id);
if (empty($data['res'])) {
show_message($this->smarty, "数据为空，请返回确认条件!", "");
return false;
}
self::$errCode = CountriesUsazoneModel::$errCode;
self::$errMsg = CountriesUsazoneModel::$errMsg;
if (self::$errCode != 0) {
show_message($this->smarty, self::$errMsg, "");
return false;
}
return $data;
}
/**
* TransitCenterAct::act_delTransitCenter()
* 删除转运中心
* @param int $id 转运中心ID
* @return bool
*/
public function act_delTransitCenter()
{
$id = isset($_POST["id"]) ? intval(trim($_POST["id"])) : 0;
$act = isset($_REQUEST["act"]) ? post_check($_REQUEST["act"]) : "";
$mod = isset($_REQUEST["mod"]) ? post_check($_REQUEST["mod"]) : "";
if (!AuthUser::checkLogin($mod, $act)) {
self::$errCode = 10001;
self::$errMsg = "对不起,您无数据删除权限！";
return false;
}
if (empty($id) || !is_numeric($id)) {
self::$errCode = 10000;
self::$errMsg = "转运中心ID有误！";
return false;
}
$res = TransitCenterModel::delTransitCenter($id);
self::$errCode = TransitCenterModel::$errCode;
self::$errMsg = TransitCenterModel::$errMsg;
return $res;
}
/**
* TransitCenterModel::delTransitCenter()
* 转运中心删除
* @param integer $id 平台ID
* @return bool
*/
public static function delTransitCenter($id)
{
self::initDB();
$sql = "UPDATE `" . self::$prefix . self::$table . "` SET is_delete = 1 WHERE id = {$id}";
$query = self::$dbConn->query($sql);
if ($query) {
$rows = self::$dbConn->affected_rows();
if ($rows) {
return $res;
} else {
self::$errCode = 10001;
self::$errMsg = "删除数据失败";
return false;
}
} else {
self::$errCode = 10000;
self::$errMsg = "执行SQL语句失败！";
return false;
}
}
