public function deleteGroup(Request $request) { $data = $request->all(); DB::beginTransaction(); try { //\DB::enableQueryLog (); FoVar::whereIn('FORMULA_ID', function ($query) use($data) { $query->select('ID')->from('FORMULA')->where(['GROUP_ID' => $data['id']]); })->delete(); //\Log::info ( \DB::getQueryLog () ); Formula::where(['ID' => $data['id']])->delete(); FoGroup::where(['ID' => $data['id']])->delete(); $fo_group = $this->getFoGroup(); } catch (\Exception $e) { \Log::info($e->getMessage()); DB::rollback(); } DB::commit(); return response()->json($fo_group); }
public function _indexWorkFlow() { $ebfunctions = EbFunctions::where('USE_FOR', 'like', '%TASK_GROUP%')->whereIn('LEVEL', [1, 2])->get(['PARENT_CODE', 'CODE', 'NAME', 'PATH']); $result = array(); foreach ($ebfunctions as $eb) { $name = ""; if (!is_null($eb->PARENT_CODE)) { $name = "---"; } $eb['FUNCTION_NAME'] = $name . $eb->NAME; $eb['FUNCTION_CODE'] = $eb->CODE; $eb['FUNCTION_URL'] = $eb->PATH; array_push($result, $eb); } $users = array(); $user = User::where(['ACTIVE' => 1])->get(['USERNAME', 'LAST_NAME', 'MIDDLE_NAME', 'FIRST_NAME']); foreach ($user as $u) { $u['NAME'] = $u->LAST_NAME . ' ' . $u->MIDDLE_NAME . ' ' . $u->FIRST_NAME; array_push($users, $u); } $foGroup = FoGroup::all('ID', 'NAME'); return view('front.workflow', array('ebfunctions' => $result, 'user' => $users, 'foGroup' => $foGroup)); }
public function _index() { $facility = Facility::whereIn('ID', [18, 19])->get(['ID', 'NAME']); $fogroup = FoGroup::get(['ID', 'NAME']); return view('front.flowreport', ['facility' => $facility, 'fogroup' => $fogroup]); }