View file mc-master/modules/news/controllers/news_admin.php

<?php

/**
 * MobileCMS
 *
 * Open source content management system for mobile sites
 *
 * @author MobileCMS Team <[email protected]>
 * @copyright Copyright (c) 2011-2019, MobileCMS Team
 * @link https://mobilecms.pro Official site
 * @license MIT license
 */


/**
 * Новости, админская часть
 */
class News_Admin_Controller extends Controller
{

    /**
     * Уровень доступа
     */
    public $access_level = 10;

    /**
     * Тема шаблонов
     */
    public $template_theme = 'admin';

    /**
     * Constructor
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Действие по умолчанию
     */
    public function action_index()
    {
        $this->action_list_news();
    }

    /**
     * Добавление / Редактирование новости
     */
    public function action_edit()
    {
        if (is_numeric($_GET['news_id'])) {
            $news = $this->db->get_row("SELECT * FROM #__news WHERE news_id = '" . intval($_GET['news_id']) . "'");
            $action = 'edit';
        } else {
            $news = array('subject' => '', 'text' => '');
            $action = 'add';
        }

        if (isset($_POST['submit'])) {
            main::is_demo();

            if (empty($_POST['subject'])) {
                $this->error .= 'Укажите тему новости<br />';
            }

            if (empty($_POST['editor_text'])) {
                $this->error .= 'Укажите текст новости<br />';
            }

            if (!$this->error) {
                if ($action == 'add') {
                    $this->db->query("INSERT INTO #__news SET
  						subject = '" . a_safe($_POST['subject']) . "',
  						text = '" . mysqli_real_escape_string($this->db->db_link, main::tinymce_p_br($_POST['editor_text'])) . "',
  						time = UNIX_TIMESTAMP()
  					");

                    $message = 'Новость успешно добавлена!';
                }

                if ($action == 'edit') {
                    $this->db->query("UPDATE #__news SET
  						subject = '" . a_safe($_POST['subject']) . "',
  						text = '" . mysqli_real_escape_string($this->db->db_link, main::tinymce_p_br($_POST['editor_text'])) . "'
  						WHERE news_id = '" . intval($_GET['news_id']) . "'
  					");

                    $message = 'Новость успешно изменена!';
                }

                a_notice($message, a_url('news/admin'));
            }
        }
        if (!isset($_POST['submit']) || $this->error) {
            $this->tpl->assign(array(
                'news' => $news,
                'error' => $this->error,
                'action' => $action
            ));

            $this->tpl->display('edit');
        }
    }

    /**
     * Удаление новости
     */
    public function action_delete()
    {
        main::is_demo();
        $this->db->query("DELETE FROM #__news WHERE news_id = '" . intval($_GET['news_id']) . "'");
        a_notice('Новость успешно удалена!', a_url('news/admin'));
    }

    /**
     * Листинг новостей
     */
    public function action_list_news()
    {
        $this->per_page = 20;

        # Получение данных
        $list_news = $this->db->get_array("SELECT SQL_CALC_FOUND_ROWS * FROM #__news ORDER BY news_id DESC LIMIT $this->start, $this->per_page");
        $total = $this->db->get_one("SELECT FOUND_ROWS()");

        # Пагинация
        $pg_conf['base_url'] = a_url('news/admin', 'start=');
        $pg_conf['total_rows'] = $total;
        $pg_conf['per_page'] = $this->per_page;

        a_import('libraries/pagination');
        $pg = new CI_Pagination($pg_conf);

        $this->tpl->assign(array(
            'list_news' => $list_news,
            'total' => $total,
            'pagination' => $pg->create_links()
        ));

        $this->tpl->display('list_news');
    }

}

?>