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



class Beauty_tips_m extends MY_Model
{



    protected $_table_name = 'beauty_tips';

    protected $_primary_key = 'id';

    protected $_order_by = 'id';



    public $rules = array(

        array(

            'field'   => 'beauty_tips',

            'label'   => 'Beauty Tips',

            'rules'   => 'trim|required|callback__cek_existing_beauty_tips_title'

        ),

        // array(

        //      'field'   => 'status', 

        //      'label'   => 'status',

        //      'rules'   => 'trim|required'

        // ),

        // array(

        //      'field'   => 'description',

        //      'label'   => 'description',

        //      'rules'   => 'trim'

        // ),     

        //  array(

        //      'field'   => 'author',

        //      'label'   => 'author',

        //      'rules'   => 'trim'

        // ),  

        //  array(

        //      'field'   => 'publish_date',

        //      'label'   => 'publish date',

        //      'rules'   => 'trim|required'

        // ),    



    );



    function __construct()
    {

        parent::__construct();
    }



    //pagination included

    function get_all_blog($limit, $start)
    {

        $this->db->select('*');

        $this->db->from('blog');

        $this->db->order_by('publish_date', 'DESC');

        $this->db->limit($limit, $start);

        $query = $this->db->get();

        return $query->result();
    }



    //function to display new blog, where all fields are empty

    public function get_new()
    {

        $beauty_tips = new stdClass();

        $beauty_tips->beauty_tips         = '';

        $beauty_tips->status             = '';

        $beauty_tips->beauty_tips_type     = '';

        $beauty_tips->description         = '';

        $beauty_tips->description_en         = '';

        $beauty_tips->priority             = '';

        $beauty_tips->author             = '';

        $beauty_tips->publish_date         = '';



        return $beauty_tips;
    }



    //get all blog 

    function get_blog()
    {

        $this->db->select('*');

        $this->db->from('beauty_tips');

        $this->db->order_by('id asc');

        $query = $this->db->get();

        return $query->result();
    }



    //function add new blog

    function add_beauty_tips($data)
    {

        $this->db->insert('beauty_tips', $data);

        return $this->db->insert_id();
    }



    //function edit blog

    function edit_beauty_tips($id, $data)
    {

        $this->db->where('id', $id);

        $this->db->update('beauty_tips', $data);
    }



    //function count all record for blog

    public function record_count()
    {

        return $this->db->get('beauty_tips')->num_rows();
    }



    //function count if existing record exist

    public function count_exist($id)
    {

        $this->db->select('*');

        $this->db->from('beauty_tips');

        $this->db->where('id', $id);

        $query = $this->db->get();

        return $query->num_rows();
    }



    //cek if blog title already exist

    public function cek_existing_beauty_tips_title($str, $id)
    {



        $this->db->select('id');

        $this->db->from('beauty_tips');

        $this->db->where('beauty_tips', $str);

        if ($id != NULL) {

            $this->db->where('id !=', $id);
        }

        $query = $this->db->get();

        return $query->num_rows();
    }
}