Exemple #1
0
 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];
 }