public function search()
{
$lang = Router::getLanguage();
$dbc = Connect::getConnection();
$indexModel = new IndexModel();
$material_type_array = $indexModel->getType_of_Materials();
$data_total = array();
foreach ($material_type_array as $val) {
$material_type = $val['type_name'];
if ($material_type != 'Admin') {
$fields = new FieldsModel($material_type);
$fields_list = '';
$fields_list_value = '';
foreach ($fields->getFields() as $v) {
if ($v != 'id' && $v != 'alias' && $v != 'id_' . $material_type . '') {
$fields_list .= ',`' . $v . '` ';
$fields_list_value .= $v . " LIKE '%" . $this->search_request . "%' OR ";
}
}
$fields_list_value = trim($fields_list_value, 'OR ');
$sql = "SELECT `id`, `id_{$material_type}` {$fields_list}, `alias` FROM `{$material_type}_{$lang}` WHERE {$fields_list_value}";
$placeholders = array();
$data = $dbc->getDate($sql, $placeholders);
$data_total[$material_type] = $data;
}
}
return $data_total;
}
public function getAliasDate()
{
$dbc = Connect::getConnection();
$sql = "SELECT type_name FROM type_of_materyals";
$placeholders = array();
$data = $dbc->getDate($sql, $placeholders);
// Debugger::PrintR($data);
$data_low_register = array();
foreach ($data as $val) {
$data_low_register[]['type_name'] = strtolower($val['type_name']);
}
// Debugger::PrintR($data_low_register);
foreach ($data_low_register as $v) {
if ($v['type_name'] != 'admin') {
$sql_arr[] = "SELECT p.id, p.controller, p.action, {$v['type_name']}_en.alias AS alias_en, {$v['type_name']}_uk.alias AS alias_uk FROM\npages p JOIN `{$v['type_name']}` JOIN `{$v['type_name']}_en` JOIN `{$v['type_name']}_uk` ON (p.id = {$v['type_name']}.id_page AND {$v['type_name']}.id =\n{$v['type_name']}_en.id_{$v['type_name']}) AND (p.id = {$v['type_name']}.id_page AND {$v['type_name']}.id = {$v['type_name']}_uk.id_{$v['type_name']} )";
} else {
$sql_arr[] = "SELECT p.id, p.controller, p.action, {$v['type_name']}.alias AS alias_en, {$v['type_name']}.alias AS alias_uk FROM\npages p JOIN `{$v['type_name']}` ON p.id = {$v['type_name']}.id_page";
}
}
$sql = implode(' UNION ALL ', $sql_arr);
$placeholders = array();
$data = $dbc->getDate($sql, $placeholders);
$d = array();
foreach ($data as $v) {
$d[$v['id']] = $v;
unset($d[$v['id']]['id']);
}
return $d;
}
public function saveToDb()
{
$placeholders = array('name' => $this->name, 'email' => $this->email, 'date' => $this->date, 'message' => $this->message);
$sql = 'INSERT INTO message (user_name, user_email, message_date, message) VALUES (:name,:email, :date, :message)';
$dbc = Connect::getConnection();
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
public function getMaxId()
{
$placeholders = array();
$dbc = Connect::getConnection();
$sql = "SELECT MAX(id) AS max_id FROM `main_menu` ";
$data = $dbc->getDate($sql, $placeholders);
return $data[0]['max_id'];
}
public function deleteMessage($id)
{
$placeholders = array('id' => $id);
$dbc = Connect::getConnection();
$sql = "DELETE FROM `message` WHERE id = :id";
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
public function insertIntoDB()
{
$placeholders = array('username' => $this->username, 'email' => $this->email, 'password' => new Password($this->password));
$sql = 'INSERT INTO users (username, email, password) VALUES (:username,:email, :password)';
$dbc = Connect::getConnection();
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
public function delete()
{
$this->delete_from_menu();
$placeholders = array('id' => $this->id);
$dbc = Connect::getConnection();
$sql = "DELETE FROM `pages` WHERE id = :id";
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
public function getMenuDatePage($id_page)
{
$lang = Router::getLanguage();
$dbc = Connect::getConnection();
$placeholders = array('id_page' => $id_page);
$sql = "SELECT mm.id as id_menu_item, mm.id_parent_page, mm_{$lang}.name AS name_menu_item, mm_{$lang}.alias_menu, mm.status\n FROM main_menu mm JOIN main_menu_{$lang} mm_{$lang} ON mm.id_page = :id_page AND mm.id = mm_{$lang}.id_main_menu";
$date = $dbc->getDate($sql, $placeholders);
return $date;
}
public function getBooksCount()
{
$dbc = Connect::getConnection();
$sql = 'SELECT count(*) AS itemsCount FROM books';
$placeholders = array();
$count_array = $dbc->getDate($sql, $placeholders);
$count = $count_array[0]['itemsCount'];
return $count;
}
public function getUser()
{
$dbc = Connect::getConnection();
$sql = "SELECT * FROM users WHERE username = :username AND password = :password";
$placeholders = array('username' => $this->username, 'password' => new Password($this->password));
$date = $dbc->getDate($sql, $placeholders);
if (!$date) {
return false;
}
return $date;
//!empty($date);
}
public function updateStaticTranslation(Request $request)
{
$dbc = Connect::getConnection();
$text_en = str_replace("'", " ", $request->post('text_en'));
$text_uk = str_replace("'", " ", $request->post('text_uk'));
$text_en = $request->post('text_en');
$text_uk = $request->post('text_uk');
$placeholders = array('key' => $request->post('key'), 'text_en' => $text_en, 'text_uk' => $text_uk);
Debugger::PrintR($placeholders);
$sql = "UPDATE `static_translation` SET `text_en`= :text_en,`text_uk`= :text_uk WHERE `key`= :key";
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
private function takeFields($material_type)
{
$lang = Config::get('default_language');
$dbc = Connect::getConnection();
$sql = "SELECT COLUMN_NAME\nFROM INFORMATION_SCHEMA.COLUMNS\nWHERE table_name = '" . $material_type . "_" . $lang . "'";
$placeholders = array();
$d = $dbc->getDate($sql, $placeholders);
$data = array();
foreach ($d as $v) {
$data[] = $v['COLUMN_NAME'];
}
$data = array_unique($data);
return $data;
}
public function update()
{
$dbc = Connect::getConnection();
$placeholders = array();
$sql = "DELETE FROM `pages_in_block`";
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
$this->id_array = array_diff_key($this->id_array, $this->delete_array);
// Debugger::PrintR($this->id_array);
if (!empty($this->id_array)) {
$values = '';
foreach ($this->id_array as $v) {
if ($v) {
$values .= ',(' . $v . ',' . $v . ')';
}
}
$values = substr($values, 1);
$sql = "INSERT INTO `pages_in_block`(`id`, `id_page`) VALUES {$values}";
// echo $sql;
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
}
}
public function getBasicPageBlock()
{
$dbc = Connect::getConnection();
$placeholders = array();
$sql = "SELECT `id_page` FROM `pages_in_block`";
$d = $dbc->getDate($sql, $placeholders);
$data = array();
if (!empty($d)) {
$id_pages = '';
foreach ($d as $v) {
$id_pages .= ',' . $v['id_page'];
}
$id_pages = substr($id_pages, 1);
$placeholders = array();
$lang = Router::getLanguage();
$sql = "SELECT bp_{$lang}.title, bp_{$lang}.alias, bp.id_page FROM basic_page_{$lang} bp_{$lang} JOIN basic_page bp ON bp_{$lang}.id_basic_page = bp.id AND bp.id_page IN({$id_pages})";
$data = $dbc->getDate($sql, $placeholders);
}
return $data;
}
private function edit_menu($id_page, $lang, $new_alias, $title = null, $id_parent = null)
{
$placeholders = array('id' => $id_page);
$dbc = Connect::getConnection();
$sql = "SELECT id_page FROM `main_menu` WHERE id_parent_page = :id";
$data = $dbc->getDate($sql, $placeholders);
// Debugger::PrintR($date);
$new_title = $title ? $title : $this->title_or_menu_name;
$id_p = $id_parent ? $id_parent : $this->id_parent;
// $lang = Router::getLanguage();
$placeholders = array('id' => $id_page, 'title' => $new_title, 'alias' => $new_alias, 'id_parent_page' => $id_p);
$sql = "UPDATE main_menu_{$lang} mm_{$lang} JOIN main_menu mm SET mm_{$lang}.name = :title, mm_{$lang}.alias_menu = :alias, mm.id_parent_page = :id_parent_page\n WHERE mm_{$lang}.id_main_menu = mm.id AND mm.id_page = :id";
$sth = $dbc->getPDO()->prepare($sql);
$sth->execute($placeholders);
$placeholders = array();
$this->recurs_update_menu($dbc, $data, $placeholders, $lang);
}