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