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