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