public function getDataSet($postData, $dcTable, $facility_id, $occur_date, $properties) { $mdlName = $postData[config("constants.tabTable")]; $mdl = "App\\Models\\{$mdlName}"; $date_end = $postData['date_end']; $date_end = \Helper::parseDate($date_end); $dataSet = null; $codeDeferGroupType = CodeDeferGroupType::getTableName(); $where = ['FACILITY_ID' => $facility_id]; $dataSet = $mdl::leftJoin($codeDeferGroupType, "{$dcTable}.DEFER_GROUP_TYPE", '=', "{$codeDeferGroupType}.ID")->where($where)->whereDate("{$dcTable}.BEGIN_TIME", '>=', $occur_date)->whereDate("{$dcTable}.END_TIME", '<=', $date_end)->select("{$dcTable}.ID as {$dcTable}", "{$codeDeferGroupType}.CODE as DEFER_GROUP_CODE", "{$dcTable}.ID as DT_RowId", "{$dcTable}.ID", "{$dcTable}.*")->get(); $bunde = ['FACILITY_ID' => $facility_id]; $extraDataSet = $this->getExtraDataSet($dataSet, $bunde); return ['dataSet' => $dataSet, 'extraDataSet' => $extraDataSet]; }