<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Sap_pages_m extends MY_Model
{

    protected $_table_name = 'sap_pages';
    protected $_primary_key = 'id_sap_pages';
    protected $_order_by = 'id_sap_pages';

    public $rules = array(
        array(
            'field'   => 'sap_page_title',
            'label'   => 'sap_page Title',
            'rules'   => 'trim|required'
        )
    );

    function __construct()
    {
        parent::__construct();
    }

    //pagination included
    function get_all_pages($limit, $start)
    {
        $this->db->select('*');
        $this->db->from('sap_pages');
        $this->db->where('id_sap_pages !=', '0');
        $this->db->order_by('id_sap_pages');
        $this->db->limit($limit, $start);
        $query = $this->db->get();
        return $query->result();
    }

    //function count all record for pages
    public function record_count()
    {
        return $this->db->get('sap_pages')->num_rows();
    }

    //function count if existing record exist
    public function count_exist($id)
    {
        $this->db->select('*');
        $this->db->from('sap_pages');
        $this->db->where('id_sap_pages', $id);
        $query = $this->db->get();
        return $query->num_rows();
    }

    function get_page($slug)
    {

        $this->db->select('*');
        $this->db->from('sap_pages');
        $this->db->where('alias', $slug);
        $query = $this->db->get();
        return $query->row();
    }

    //function to display new page, where all fields are empty
    public function get_new()
    {
        $pages = new stdClass();
        $pages->sap_page_title = '';
        $pages->sap_page_title_en = '';
        $pages->body_text = '';
        $pages->body_text_en = '';
        $pages->body_text2 = '';
        $pages->body_text2_en = '';
        $pages->body_text3 = '';
        $pages->body_text3_en = '';
        $pages->body_text4 = '';
        $pages->body_text4_en = '';
        $pages->body_text5 = '';
        $pages->body_text5_en = '';
        $pages->body_text6 = '';
        $pages->body_text6_en = '';
        $pages->body_text7 = '';
        $pages->body_text7_en = '';
        $pages->body_text8 = '';
        $pages->body_text8_en = '';
        $pages->body_text9 = '';
        $pages->body_text9_en = '';
        $pages->image1 = '';
        $pages->image2 = '';
        $pages->image3 = '';
        $pages->image4 = '';
        $pages->image5 = '';
        $pages->status = '';
        $pages->meta_description = '';
        $pages->meta_keywords = '';
        $pages->template = '';
        return $pages;
    }

    //function add new page
    function add_page($data)
    {
        $this->db->insert('sap_pages', $data);
        return $this->db->insert_id();
    }

    //function edit page
    function edit_page($id, $data)
    {
        $this->db->where('id_sap_pages', $id);
        $this->db->update('sap_pages', $data);
    }

    //cek if page title already exist
    public function cek_existing_page_title($str, $page_id)
    {
        $this->db->select('id_sap_pages');
        $this->db->from('sap_pages');
        $this->db->where('sap_page_title', $str);

        if ($page_id != NULL) {
            $this->db->where('id_sap_pages !=', $page_id);
        }

        $query = $this->db->get();
        return $query->num_rows();
    }
}