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