41 lines
1.4 KiB
PHP
41 lines
1.4 KiB
PHP
<?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'];
|
|
}
|
|
}
|