public function nominate(Request $request)
{
$postData = $request->all();
$cargo_id = $postData['cargoId'];
$pdCargo = PdCargo::getTableName();
$pdCargoNomination = PdCargoNomination::getTableName();
/* $checkNominated = PdCargo::join($pdCargoNomination,"$pdCargoNomination.CARGO_ID", '=', "$pdCargo.ID")
->where("$pdCargo.ID",'=',$cargo_id)
->select("$pdCargo.NAME")
->first(); */
$pdCargoNomination = PdCargoNomination::firstOrNew(["CARGO_ID" => $cargo_id]);
if ($pdCargoNomination) {
if ($pdCargoNomination->exists) {
$result = ['code' => 'EXIST', 'message' => "Cargo id {$cargo_id} has been nominated already."];
} else {
$cargo = PdCargo::find($cargo_id);
if ($cargo) {
$values = ["CARGO_ID" => $cargo_id, "REQUEST_DATE" => $cargo->REQUEST_DATE, "REQUEST_QTY" => $cargo->REQUEST_QTY, "REQUEST_QTY_UOM" => $cargo->REQUEST_UOM];
$insertId = $pdCargoNomination->fill($values)->save();
if ($insertId > 0) {
$result = ['code' => 'DONE', 'message' => "Cargo id {$cargo_id} is nominated successfully!"];
} else {
$result = ['code' => 'ERROR', 'message' => "unsuccessfully!"];
}
} else {
$result = ['code' => 'NOT_EXIST', 'message' => "Cargo id {$cargo_id} not exist!"];
}
}
} else {
$result = ['code' => 'ERROR', 'message' => "unsuccessfully!"];
}
return response()->json($result);
}
