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