protected function getData() { parent::getData(); $query = "SELECT * FROM `ContactsUnitsTypes` ;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $type) { $this->data[$key]['title'] = $this->getContactsUnitsType($type['type']); } }
protected function getData() { parent::getData(); $query = "SELECT * FROM `MaterialsCategoriesList` ;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $list) { $this->data[$key]['title'] = $this->getListDataText($list['name']); $this->data[$key]['category'] = $this->getMaterialCategoriesData($list['name']); } }
protected function getData() { parent::getData(); $query = "SELECT * FROM `MaterialsCategories` order by `lastChange` desc;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $category) { $this->data[$key]['title'] = $this->getMaterialCategoriesDataText($category['alias']); $this->data[$key]['list'] = $this->getMaterialsCategoriesInListData($category['alias']); } }
protected function getData() { parent::getData(); $query = "SELECT * FROM `Materials` order by `created` desc;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $material) { $this->data[$key]['title'] = $this->getMaterialDataText($material['alias']); $this->data[$key]['category'] = $this->getMaterialCategoriesData($material['alias']); } }
protected function getData() { parent::getData(); $query = "SELECT *\n FROM ( SELECT `feedback` FROM `FeedbacksIsComments`) AS FIC\n LEFT JOIN `Feedbacks` AS FS \n ON FIC.`feedback`= FS.`id` ORDER BY `date` DESC ;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $comment) { $parent = $this->getDataParentFeedback($comment['id']); $this->data[$key]['parentFeedback'] = $parent['parentFeedback']; $this->data[$key]['parentFeedbackFio'] = $parent['fio']; } }
protected function getData() { parent::getData(); $this->getDataComments(); $query = "SELECT * FROM `Feedbacks` ORDER BY `date` DESC ;"; $result = $this->SQL_HELPER->select($query); foreach ($result as $value) { if (!in_array($value['id'], $this->dataCommentsKeyFeedbackPure)) { $this->data[] = $value; } } }
protected function getData() { parent::getData(); parent::getData(); $query = "SELECT * FROM `ContactsWorkers` ;"; $this->data = $this->SQL_HELPER->select($query); foreach ($this->data as $key => $worker) { $this->data[$key]['name'] = $worker['worker']; $this->data[$key]['unit'] = $this->getWorkersUnitData($worker['worker']); $this->data[$key]['post'] = $worker['post']; } }
protected function getData() { parent::getData(); $query = "SELECT * FROM `FeedbacksListIP` ;"; $this->data = $this->SQL_HELPER->select($query); }