public function reset(Request $request)
{
$postData = $request->all();
$id = $postData['nominationId'];
$pdCargo = PdCargo::getTableName();
$pdCargoNomination = PdCargoNomination::getTableName();
$nomi_row = PdCargoNomination::find($id);
if (!$nomi_row) {
throw new DataInputException("cargo nomination id {$id} not existed");
}
$code = "OK";
$message = "reset successfully";
TerminalTimesheetData::whereIn('PARENT_ID', function ($query) use($id) {
$query->select('ID')->from(PdCargoLoad::getTableName())->where('NOMINATION_ID', $id);
})->where('IS_LOAD', 1)->delete();
PdCargoLoad::where('NOMINATION_ID', $id)->delete();
TerminalTimesheetData::whereIn('PARENT_ID', function ($query) use($id) {
$query->select('ID')->from(PdCargoUnload::getTableName())->where('NOMINATION_ID', $id);
})->where('IS_LOAD', 0)->delete();
PdCargoUnload::where('NOMINATION_ID', $id)->delete();
PdVoyageDetail::whereIn('VOYAGE_ID', function ($query) use($id) {
$query->select('ID')->from(PdVoyage::getTableName())->where('NOMINATION_ID', $id);
})->delete();
PdVoyage::where('NOMINATION_ID', $id)->delete();
PdCargoSchedule::where('NOMINATION_ID', $id)->delete();
$nomi_row->CARGO_STATUS = 1;
$nomi_row->save();
$result = ['code' => $code, 'message' => $message];
return response()->json($result);
}
