public function changeServiceUnivalence()
{
$userId = Input::get("userId");
try {
DB::beginTransaction();
if (Input::has("expressUnivalence")) {
$expressUnivalence = Input::get("expressUnivalence");
$feetype = DB::table("fee_types")->select("id")->where("category", "20")->where("item", "1")->first();
$query = DB::table("user_fee")->where("user_id", $userId)->where("fee_type_id", $feetype->id);
if (count($query->first()) == 0) {
$userFee = new UserFee();
$userFee->user_id = $userId;
$userFee->fee_type_id = $feetype->id;
$userFee->fee_no = $expressUnivalence;
$userFee->save();
} else {
$query->update(["fee_no" => $expressUnivalence]);
}
}
if (Input::has("agencyUnivalence")) {
$agencyUnivalence = Input::get("agencyUnivalence");
$feetype = DB::table("fee_types")->select("id")->where("category", "30")->where("item", "1")->first();
$query = DB::table("user_fee")->where("user_id", $userId)->where("fee_type_id", $feetype->id);
if (count($query->first()) == 0) {
$userFee = new UserFee();
$userFee->user_id = $userId;
$userFee->fee_type_id = $feetype->id;
$userFee->fee_no = $agencyUnivalence;
$userFee->save();
} else {
$query->update(["fee_no" => $agencyUnivalence]);
}
}
DB::commit();
} catch (Exception $e) {
DB::rollback();
return Response::json(array('errCode' => 1, "errMsg" => "[数据库错误]修改失败"));
}
return Response::json(array('errCode' => 0));
}
