public static function addTransport($arr)
{
self::initDB();
$carrierSql = array();
if (!empty($arr['carrierNameCnInput'])) {
$carrierSql[] = "carrierNameCn = '{$arr['carrierNameCnInput']}'";
$isexist = self::checkTransportCnNameExist($arr['carrierNameCnInput']);
if ($isexist) {
//该名称已经存在 则出错返回
self::$errCode = "003";
self::$errMsg = "运输方式中文名重复";
return;
}
}
if (!empty($arr['carrierNameEnInput'])) {
$carrierSql[] = "carrierNameEn = '{$arr['carrierNameEnInput']}'";
}
if (!empty($arr['weightMinInput'])) {
$carrierSql[] = "weightMin = '{$arr['weightMinInput']}'";
}
if (!empty($arr['weightMaxInput'])) {
$carrierSql[] = "weightMax = '{$arr['weightMaxInput']}'";
}
if (!empty($arr['timecountInput'])) {
$carrierSql[] = "timecount = '{$arr['timecountInput']}'";
}
if (!empty($arr['noteInput'])) {
$carrierSql[] = "note = '{$arr['noteInput']}'";
}
$sql = "INSERT INTO " . self::$table . " SET " . join(',', $carrierSql);
$query = self::$dbConn->query($sql);
$carrierId = self::$dbConn->insert_id();
if ($query) {
channelsManageModel::insertChannelsall($carrierId, '', '');
self::addTransportRelation($carrierId, $arr['platform']);
//添加关系联系表
self::addShippingAddressRelation($carrierId, $arr['shippingAddress']);
//添加关系联系表
return true;
} else {
self::$errCode = "003";
self::$errMsg = "添加运输方式失败";
return false;
}
}
function act_transById($id)
{
$trans = channelsManageModel::transById($id);
return $trans;
}
public static function carrierShowById($id)
{
self::initDB();
$sql = "SELECT * FROM trans_carrier where id={$id}";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret;
} else {
self::$errCode = "003";
self::$errMsg = "die";
return false;
}
}
