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