public function cargodocuments() { $filterGroups = array('productionFilterGroup' => ['Facility' => 'Storage'], 'enableSaveButton' => false, 'dateFilterGroup' => array(['id' => 'date_begin', 'name' => 'From date'], ['id' => 'date_end', 'name' => 'To date'])); $contractAttributes = PdReportList::orderBy('ORDER')->get(); $activities = PdDocumentSet::select(['ID as SET_ID', 'NAME as SET_NAME'])->get(); return view('front.cargomanagement.cargodocuments', ['filters' => $filterGroups, 'contractAttributes' => $contractAttributes, 'activities' => $activities]); }
public function activities(Request $request) { $postData = $request->all(); $set_id = $postData['id']; $pdDocumentSetList = PdDocumentSetList::getTableName(); $pdReportList = PdReportList::getTableName(); $dataSet = PdDocumentSetList::join($pdReportList, "{$pdDocumentSetList}.DOCUMENT_ID", '=', "{$pdReportList}.ID")->where("SET_ID", '=', $set_id)->select("{$pdReportList}.ID as ID", "{$pdReportList}.CODE as CODE", "{$pdReportList}.NAME")->get(); $results = ['updatedData' => [$this->detailModel => $dataSet], 'postData' => $postData]; return response()->json($results); }