<?php
class Gallery_model extends CI_Model {
    public function __construct() {

    }
    public function get_paintings_active_all() {
        $sql = 'CALL paintings_get_active_all()';
        $query = $this->db->query($sql);
        return $query->result_array();
    }
    public function get_paintings_active_limit($limit) {
        $sql = 'CALL paintings_get_active_limit(?)';
        $params = array($limit);
        $query = $this->db->query($sql, $params);
        return $query->result_array();
    }
    public function get_paintings_on_display_limit($limit) {
        $sql = 'CALL paintings_get_on_display_limit(?)';
        $params = array($limit);
        $query = $this->db->query($sql, $params);
        return $query->result_array();
    }
    public function get_painting_by_id($id) {
        $sql = 'CALL paintings_get_by_id(?)';
        $params = array($id);
        $query = $this->db->query($sql, $params);
        return $query->row_array();
    }
    public function set_painting_status($id, $status = 0) {
        $sql = 'CALL paintings_set_status(?,?)';
        $params = array($id, $status);
        $result = $this->db->query($sql, $params);
        return $this->db->affected_rows();
    }
    public function get_reference() {
        $result = $this->db->query('CALL general_reference()');
        $array = $result->row_array();
        return $array['reference'];
    }
}