public function _indexconfig() { $network = Network::where(['NETWORK_TYPE' => 1])->get(['ID', 'NAME']); $result = []; foreach ($network as $n) { $tmp = []; $count = AllocJob::where(['NETWORK_ID' => $n->ID])->count(); if ($count > 0) { $tmp['NAME'] = $n->NAME . '(' . $count . ')'; } else { $tmp['NAME'] = $n->NAME; } $tmp['ID'] = $n->ID; array_push($result, $tmp); } $code_alloc_value_type = CodeAllocValueType::all('ID', 'NAME'); $facility = Facility::all('ID', 'NAME'); $code_alloc_type = CodeAllocType::all('ID', 'NAME'); $codeFlowPhase = CodeFlowPhase::all('ID', 'NAME'); $codeAllocValueType = CodeAllocValueType::all('ID', 'NAME'); return view('front.allocset', ['result' => $result, 'CodeAllocValueType' => $code_alloc_value_type, 'facility' => $facility, 'codeAllocType' => $code_alloc_type, 'codeFlowPhase' => $codeFlowPhase, 'codeAllocValueType' => $codeAllocValueType]); }
public function loadFormSetting(Request $request) { $data = $request->all(); $result = array(); $value = $data['value']; $task_id = isset($data['task_id']) ? $data['task_id'] : 0; switch ($value) { case 'ALLOC_CHECK': case 'ALLOC_RUN': $network = Network::getTableName(); $allocJob = AllocJob::getTableName(); $tm = []; $tm = DB::table($network . ' AS a')->join($allocJob . ' AS b', 'a.ID', '=', 'b.NETWORK_ID')->distinct()->get(['a.ID', 'a.NAME']); $alloc_job = AllocJob::where(['NETWORK_ID' => $tm[0]->ID])->get(['ID', 'NAME']); $result['network'] = $tm; $result['allocJob'] = $alloc_job; break; case 'VIS_REPORT': $result = Facility::all(['ID', 'NAME']); break; case 'FDC_EU': $models = ['Facility', 'EnergyUnitGroup', 'CodeReadingFrequency', 'CodeFlowPhase', 'CodeEventType', 'CodeAllocType', 'CodePlanType', 'CodeForecastType']; foreach ($models as $m) { $tm = []; $model = 'App\\Models\\' . $m; $tm = $model::all(['ID', 'NAME']); $result[$m] = $tm; } break; case 'FDC_FLOW': $models = ['Facility', 'CodeReadingFrequency', 'CodeFlowPhase']; foreach ($models as $m) { $tm = []; $model = 'App\\Models\\' . $m; $tm = $model::all(['ID', 'NAME']); $result[$m] = $tm; } break; case 'INT_IMPORT_DATA': $tm = []; $tm = IntConnection::all(['ID', 'NAME']); $intTagSet = IntTagSet::where(['CONNECTION_ID' => $tm[0]->ID])->get(['ID', 'NAME']); $result['IntConnection'] = $tm; $result['IntTagSet'] = $intTagSet; break; default: $result = []; } $task = TmWorkflowTask::where(['ID' => $task_id])->get(); $result['task'] = $task; $result['value'] = $value; return response()->json(array('result' => $result)); }
public function editUser(Request $request, $id) { $userDataScope = UserDataScope::getTableName(); $loProductionUnit = LoProductionUnit::getTableName(); $loArea = LoArea::getTableName(); $facility = Facility::getTableName(); $user = User::getTableName(); $listColumn = ['a.ID', 'a.USERNAME', 'a.PASSWORD', 'b.PU_ID', 'b.AREA_ID', 'b.FACILITY_ID', 'LAST_NAME', 'MIDDLE_NAME', 'FIRST_NAME', 'EMAIL', 'a.EXPIRE_DATE', 'a.ACTIVE']; \DB::enableQueryLog(); $user = DB::table($user . ' AS a')->leftJoin($userDataScope . ' AS b', 'a.id', '=', 'b.user_id')->leftJoin($loProductionUnit . ' AS pu', 'pu.id', '=', 'b.PU_ID')->leftJoin($loArea . ' AS ar', 'ar.id', '=', 'b.AREA_ID')->leftJoin($facility . ' AS fa', 'fa.id', '=', 'b.FACILITY_ID')->where(['a.ID' => $id])->select($listColumn)->first(); \Log::info(\DB::getQueryLog()); $user->EXPIRE_DATE = date('m/d/Y', strtotime($user->EXPIRE_DATE)); $userRole = UserRole::where(['ACTIVE' => 1])->get(['ID', 'NAME']); $userUserRole = UserUserRole::where(['USER_ID' => $user->ID])->get(['ROLE_ID']); $loProductionUnit = LoProductionUnit::all(['ID', 'NAME']); $area = LoArea::all(['ID', 'NAME']); $facility = Facility::all(['ID', 'NAME']); return view('admin.edit_users', ['user' => $user, 'userRole' => $userRole, 'userUserRole' => $userUserRole, 'loProductionUnit' => $loProductionUnit, 'LoArea' => $area, 'facility' => $facility]); }