<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Blog_app_article_model extends CI_Model {

    public function __constructor() {
        parrent::__constructor();
    }

    public function getBlogs($params = null, $page = 0, $limit = 10) {
        $queryString = 'SELECT * FROM blog_app_articles';
        $countString = 'SELECT COUNT(*) FROM blog_app_articles';
        $whereString = ' WHERE 1=1';
        $orderByString = ' ORDER BY id DESC';
        $offset = $page * $limit;
        $paginationString = " LIMIT $limit OFFSET $offset";

        if(isset($params['blog_id']) && !empty($params['blog_id'])) {
            $whereString .= " AND blog_id = '" . pg_escape_string($params['blog_id']) . "' ";
        }
        
        if(isset($params['status']) && $params['status'] > -1) {
            $whereString .= " AND status = '" . pg_escape_string($params['status']) . "' ";
        }

        if(isset($params['description']) && !empty($params['description'])) {
            $whereString .= " AND description ILIKE '%" . pg_escape_string($params['description']) . "%' ";
        }

        $queryString .= $whereString . $orderByString . $paginationString;
        $countString .= $whereString;

        $query = $this->db->query($queryString);
        $countQuery = $this->db->query($countString);
        
        $data = [
            'result' => $query->result_array(),
            'total' => $countQuery->result_array()[0]['count'],
            'pageSize' => $limit,
            'pageNo' => $page
        ];

        return $data;
    }

    public function store($data) {
        $this->db->insert('blog_app_articles', $data);
    }

    public function update($id, $data) {
        $this->db->update('blog_app_articles', $data, "id = $id");
    }

    public function delete($params) {
        $this->db->delete('blog_app_articles', $params);
    }

}

?>