示例#1
0
 /**
  * ChannelPriceModel::delChannelPrice()
  * 运费价目删除
  * @param integer $id 运费价目ID
  * @param string $tab 运费价目表名
  * @return bool
  */
 public static function delChannelPrice($tab, $id)
 {
     self::initDB();
     $sql = "UPDATE `" . self::$prefixfee . $tab . "` SET is_delete = 1 WHERE id = {$id}";
     $query = self::$dbConn->query($sql);
     if ($query) {
         $rows = self::$dbConn->affected_rows();
         if ($rows) {
             return $rows;
         } else {
             self::$errCode = 30001;
             self::$errMsg = "删除数据失败";
             return false;
         }
     } else {
         self::$errCode = 30000;
         self::$errMsg = "执行SQL语句失败!";
         return false;
     }
 }
示例#2
0
 public function view_modify()
 {
     $this->smarty->assign('title', '修改运费价目');
     $id = isset($_GET['id']) ? intval(trim($_GET['id'])) : 0;
     $chid = isset($_GET['chid']) ? intval($_GET['chid']) : 0;
     //渠道ID
     $chname = isset($_GET['chname']) ? post_check($_GET['chname']) : "";
     //渠道别名
     if (empty($id) || !is_numeric($id) || empty($chname)) {
         redirect_to("index.php?mod=channelPrice&act=index");
         exit;
     }
     if (in_array($chname, array('ups_calcfree', 'usps_calcfree', 'usps_first_class', 'ups_ground_commercia', 'sv_sure_post'))) {
         $zoneList = CountriesUsazoneModel::listZone();
         $this->smarty->assign('zoneList', $zoneList);
         //分区列表
     }
     $channelPrice = new ChannelPriceAct();
     $res = $channelPrice->actModify($chname, $id);
     $carrierId = ChannelPriceModel::getCarrierId($chid);
     if (in_array($chname, array('usps_first_class', 'ups_ground_commercia', 'sv_sure_post'))) {
         $weights = explode("-", $res['pr_kilo_next']);
         $minW = $weights[0];
         $maxW = $weights[1];
     }
     $this->smarty->assign('chid', $chid);
     $this->smarty->assign('carrierId', $carrierId);
     $this->smarty->assign('pr_group', $res['pr_group']);
     $this->smarty->assign('pr_kilo', $res['pr_kilo']);
     $this->smarty->assign('pr_discount', $res['pr_discount']);
     $this->smarty->assign('pr_handlefee', $res['pr_handlefee']);
     $this->smarty->assign('pr_country', stripslashes($res['pr_country']));
     $this->smarty->assign('pr_kilo_next', $res['pr_kilo_next']);
     $this->smarty->assign('weight_from', $minW);
     $this->smarty->assign('weight_to', $maxW);
     $this->smarty->assign('pr_file', $res['pr_file']);
     $this->smarty->assign('pr_isfile', $res['pr_isfile']);
     $this->smarty->assign('pr_air', $res['pr_air']);
     $this->smarty->assign('pr_other', $res['pr_other']);
     $this->smarty->assign('id', $res['id']);
     $this->smarty->assign('chname', $chname);
     if ($chname == 'hkpostsf_hk' || $chname == 'hkpostrg_hk') {
         $this->smarty->display('channelPriceModifyHk.htm');
     } else {
         if ($chname == 'ems_shenzhen') {
             $this->smarty->display('channelPriceModifyEms.htm');
         } else {
             if (in_array($chname, array('eub_shenzhen', 'eub_fujian', 'eub_jiete'))) {
                 $this->smarty->display('channelPriceModifyEub.htm');
             } else {
                 if ($chname == 'dhl_shenzhen') {
                     $this->smarty->display('channelPriceModifyDhl.htm');
                 } else {
                     if ($chname == 'fedex_shenzhen') {
                         $this->smarty->display('channelPriceModifyFedex.htm');
                     } else {
                         if ($chname == 'globalmail_shenzhen') {
                             $this->smarty->display('channelPriceModifyGlobalmail.htm');
                         } else {
                             if (in_array($chname, array('ups_us', 'ups_uk', 'ups_fr', 'ups_ger'))) {
                                 $this->smarty->display('channelPriceModifyUpsus.htm');
                             } else {
                                 if ($chname == 'ups_calcfree') {
                                     $this->smarty->display('channelPriceModifyUps.htm');
                                 } else {
                                     if ($chname == 'usps_calcfree') {
                                         $this->smarty->display('channelPriceModifyUsps.htm');
                                     } else {
                                         if (in_array($chname, array('sto_shenzhen', 'zto_shenzhen', 'yto_shenzhen', 'yundaex_shenzhen', 'best_shenzhen', 'jym_shenzhen', 'gto_shenzhen'))) {
                                             $countrylist = TransOpenApiModel::getCountriesChina();
                                             //中国城市名称列表
                                             $this->smarty->assign('countrylist', $countrylist);
                                             $this->smarty->display('channelPriceModifyChina.htm');
                                         } else {
                                             if (in_array($chname, array('ruston_packet_py', 'ruston_packet_gh', 'ruston_large_package'))) {
                                                 $this->smarty->display('channelPriceModifyRuston.htm');
                                             } else {
                                                 if (in_array($chname, array('sg_dhl_gm_gh', 'sg_dhl_gm_py'))) {
                                                     $this->smarty->display('channelPriceModifySGDHLGM.htm');
                                                 } else {
                                                     if (in_array($chname, array('ruishi_xb_py', 'ruishi_xb_gh'))) {
                                                         $this->smarty->display('channelPriceModifyRuishi.htm');
                                                     } else {
                                                         if (in_array($chname, array('bilishi_xb_py', 'bilishi_xb_gh'))) {
                                                             $this->smarty->display('channelPriceModifyBilishi.htm');
                                                         } else {
                                                             if ($chname == 'usps_first_class') {
                                                                 $this->smarty->display('channelPriceModifySVUSPS.htm');
                                                             } else {
                                                                 if ($chname == 'ups_ground_commercia') {
                                                                     $this->smarty->display('channelPriceModifySVUPS.htm');
                                                                 } else {
                                                                     if ($chname == 'sv_sure_post') {
                                                                         $this->smarty->display('channelPriceModifySVSurePost.htm');
                                                                     } else {
                                                                         if (in_array($chname, array('aoyoubao_py', 'aoyoubao_gh'))) {
                                                                             $this->smarty->display('channelPriceModifyAyb.htm');
                                                                         } else {
                                                                             $this->smarty->display('channelPriceModify.htm');
                                                                         }
                                                                     }
                                                                 }
                                                             }
                                                         }
                                                     }
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }
示例#3
0
 /**
  * ChannelPriceAct::act_delChannelPrice()
  * 删除运费价目
  * @param int $id 运费价目ID
  * @return  bool
  */
 public function act_delChannelPrice()
 {
     $id = isset($_POST["id"]) ? intval(trim($_POST["id"])) : 0;
     $chname = isset($_POST["chname"]) ? $_POST["chname"] : "";
     $act = isset($_REQUEST["act"]) ? post_check($_REQUEST["act"]) : "";
     $mod = isset($_REQUEST["mod"]) ? post_check($_REQUEST["mod"]) : "";
     if (!AuthUser::checkLogin($mod, $act)) {
         self::$errCode = 30002;
         self::$errMsg = "对不起,您无数据删除权限!";
         return false;
     }
     if (empty($id) || !is_numeric($id)) {
         self::$errCode = 30000;
         self::$errMsg = "运费价目ID有误!";
         return false;
     }
     if (!in_array($chname, self::$chnameArr)) {
         self::$errCode = 30001;
         self::$errMsg = "渠道运费参数有误!";
         return false;
     }
     $res = ChannelPriceModel::delChannelPrice($chname, $id);
     self::$errCode = ChannelPriceModel::$errCode;
     self::$errMsg = ChannelPriceModel::$errMsg;
     if (empty(self::$errCode)) {
         $cacheFee = TransOpenApiModel::updateCacheTableFee($chname, $data);
     }
     return $res;
 }