public function _indexDiagram() { $codeFlowPhase = CodeFlowPhase::all(['ID', 'NAME']); $loProductionUnit = LoProductionUnit::all(['ID', 'NAME']); $loArea = LoArea::where(['PRODUCTION_UNIT_ID' => $loProductionUnit[0]->ID])->get(['ID', 'NAME']); $facility = Facility::where(['AREA_ID' => $loArea[0]->ID])->get(['ID', 'NAME']); $intObjectType = IntObjectType::where(['DISPLAY_TYPE' => 1])->get(['CODE', 'NAME']); $tmp = ucwords($intObjectType[0]->NAME); $mode = 'App\\Models\\' . str_replace(' ', '', $tmp); $type = $mode::where(['FACILITY_ID' => $facility[0]->ID])->get(['ID', 'NAME']); return view('front.diagram', ['codeFlowPhase' => $codeFlowPhase, 'loProductionUnit' => $loProductionUnit, 'loArea' => $loArea, 'facility' => $facility, 'intObjectType' => $intObjectType, 'type' => $type]); }
private function getWorkSpaceInfo() { $user_name = ''; if (auth()->user() != null) { $user_name = auth()->user()->username; } $user_workspace = UserWorkspace::getTableName(); $facility = Facility::getTableName(); $lo_area = LoArea::getTableName(); $lo_production_unit = LoProductionUnit::getTableName(); $workspace = DB::table($user_workspace . ' AS a')->join($facility . ' AS b', 'a.W_FACILITY_ID', '=', 'b.ID')->join($lo_area . ' AS c', 'b.AREA_ID', '=', 'c.ID')->join($lo_production_unit . ' AS d', 'c.PRODUCTION_UNIT_ID', '=', 'd.ID')->where(['a.USER_NAME' => $user_name])->select('a.*', DB::raw('DATE_FORMAT(a.W_DATE_BEGIN, "%m/%d/%Y") as DATE_BEGIN'), DB::raw('DATE_FORMAT(a.W_DATE_END, "%m/%d/%Y") as DATE_END'), 'b.AREA_ID', 'c.PRODUCTION_UNIT_ID')->first(); return $workspace; }
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]); }
public function getVarList(Request $request) { $data = $request->all(); $tmp = FoVar::where(['FORMULA_ID' => $data['formula_id']])->orderBy('ORDER', 'ID')->select('*')->get(); $s = ""; $i = 0; $html = ""; $result = []; foreach ($tmp as $row) { $rowLO = null; $r = []; $table_name = $row->OBJECT_TYPE; $entity = strtolower(str_replace('_', ' ', $table_name)); $entity = ucwords($entity); $entity = str_replace(' ', '', $entity); $model = 'App\\Models\\' . $entity; $tablea = $model::getTableName(); $facility = Facility::getTableName(); $lo_area = LoArea::getTableName(); $rowLO = DB::table($tablea . ' AS a')->join($facility . ' AS b', 'b.ID', '=', 'a.FACILITY_ID')->join($lo_area . ' AS c', 'c.ID', '=', 'b.AREA_ID')->where(['a.ID' => $row->OBJECT_ID])->select('a.NAME AS OBJECT_NAME', 'a.FACILITY_ID', 'b.AREA_ID', 'c.PRODUCTION_UNIT_ID')->first(); if (count($rowLO) > 0) { $row['PRODUCTION_UNIT_ID'] = $rowLO->PRODUCTION_UNIT_ID; $row['AREA_ID'] = $rowLO->AREA_ID; $row['FACILITY_ID'] = $rowLO->FACILITY_ID; $row['OBJECT_NAME'] = $rowLO->OBJECT_NAME; } else { $row['PRODUCTION_UNIT_ID'] = ""; $row['AREA_ID'] = ""; $row['FACILITY_ID'] = ""; $row['OBJECT_NAME'] = ""; } array_push($result, $row); } return response()->json($result); }