<?php

class DbAction {
    private $dataConnect = '';
    function __construct(){
        $this->dataConnect = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
       mysqli_query($this->dataConnect,'SET NAMES utf8 COLLATE utf8_general_ci');
       mysqli_query($this->dataConnect,'SET CONNECTION_COLLATION utf8');

        if (mysqli_connect_errno()) {
            printf("Неможливе підключення до сервера: %s\n", mysqli_connect_error());
            exit;
        }

    }


    public function  getItems($page = 1){
        $pageOfset = ($page-1) * PAGE_LIMIT;
        $limit = " LIMIT $pageOfset, ".PAGE_LIMIT;
        $query  = "SELECT `id`, `html`"
            ." FROM posts"
            ." WHERE deleted != 1 AND action_id=".ACTION_ID." AND is_news = 0 "
            ." ORDER BY create_date DESC"
            .$limit;
        return $this->getData($query);
    }

    public function getNews(){
        $limit = " LIMIT 0, ".NEWS_LIMIT;
        $query  = "SELECT `id`, `html`, name "
            ." FROM posts"
            ." WHERE deleted != 1 AND action_id=".ACTION_ID." AND is_news = 1 "
            ." ORDER BY create_date DESC"
            .$limit;

        return $this->getData($query);
    }



    public function  getAdminItems($page = 1){
       // $pageOfset = ($page-1) * PAGE_ADMIN_LIMIT;
      //  $limit = " LIMIT $pageOfset, ".PAGE_ADMIN_LIMIT;
        $query  = "SELECT `id`, `name`, `html` , `create_date`"
            ." FROM posts"
            ." WHERE deleted != 1 AND action_id=".ACTION_ID." AND is_news = 0 "
            ." ORDER BY create_date DESC";
          /*  .$limit;*/
        return $this->getData($query);

    }

    public function getAdminNews(){
        $query  = "SELECT `id`, `html`, name, create_date "
            ." FROM posts"
            ." WHERE deleted != 1 AND action_id=".ACTION_ID." AND is_news = 1 "
            ." ORDER BY create_date DESC";

        return $this->getData($query);
    }

    public function  removeItem($id){
        $query  = "UPDATE posts"
            ." SET deleted = 1"
            ." WHERE id = ".$id;
        $this->dataConnect->query($query);
    }

    public function  addItem($nameItem, $htmlItem, $isNews){
        $query  = "INSERT INTO posts (name, html, action_id, is_news)
              VALUES ('".$nameItem."', '".$htmlItem."', '".ACTION_ID."', ".$isNews.")";
        $this->dataConnect->query($query);
    }

    public function  getEditItem($id){
        $query  = "SELECT `name`, `html`"
            ." FROM posts"
            ." WHERE id =".$id;
        return $this->getData($query);
    }

    public function  editItem($id, $name , $html){
        $query  = "UPDATE posts"
            ." SET name = '".$name
            ."', html = '".$html
            ."' WHERE id = ".$id;
        $this->dataConnect->query($query);
    }



    public function getPaginatorCount(){
        $query  = "SELECT COUNT(*)"
            ." FROM posts WHERE deleted <> 1 AND is_news <> 1 && action_id=".ACTION_ID;
        $query_res = $this->dataConnect->query($query);
        if(isset($query_res) && !empty($query_res)){
            $item_arr = $query_res->fetch_array();
        } else {$item_arr = array();}

        if($query_res){
            $query_res->close();
        }
        return $item_arr[0];

    }



    protected   function getData($query){
        $query_res = $this->dataConnect->query($query);
        if(isset($query_res) && !empty($query_res)){
            $item_arr = $query_res->fetch_all(MYSQLI_ASSOC);
        } else {$item_arr = array();}

        if($query_res){
            $query_res->close();
        }
        return $item_arr;
    }


    function __destruct() {
        $this->dataConnect->close();
    }

}