Model Associates

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

class Associates_model extends CI_Model {

	public function __construct() {
		$this->load->database();
	}

	// Listing
	public function listAssociates() {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->order_by('id_staff','ASC');
		$query = $this->db->get();
		return $query->result();
	}

	// Semua
	public function semua_associates($limit, $start) {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->where(array('status_staff'=>'Yes'));
		$this->db->limit($limit, $start);
		$this->db->order_by('urutan','ASC');
		$query = $this->db->get();
		return $query->result();
	}


	// Semua
	public function total_associates() {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->where(array('status_staff'=>'Ya'));
		$this->db->order_by('urutan','ASC');
		$query = $this->db->get();
		return $query->num_rows();
	}

	// Listing Besar
	public function listing_besar() {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->where(array('status_staff'=>'Ya','ukuran' => 'Besar'));
		$this->db->order_by('id_staff','DESC');
		$query = $this->db->get();
		return $query->result();
	}

	// Besar
	public function total_besar() {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->where(array('status_staff'=>'Ya','ukuran' => 'Besar'));
		$this->db->order_by('id_staff','DESC');
		$query = $this->db->get();
		return $query->num_rows();
	}

	// Detail
	public function detail($id_staff) {
		$this->db->select('*');
		$this->db->from('associates');
		$this->db->where('id_staff',$id_staff);
		$this->db->order_by('id_staff','DESC');
		$query = $this->db->get();
		return $query->row();
	}

	 // Read Product
    public function readAsc($slugAsc) {
        $this->db->select('*');
        $this->db->from('associates');
        $this->db->where('slug_asc',$slugAsc);
        $query = $this->db->get();
        return $query->row_array();
    }

    // End Product
        public function endAsc() {
            $this->db->select('*');
            $this->db->from('associates');
            $this->db->order_by('urutan','DESC');
            $query = $this->db->get();
            return $query->row_array();
        }


	// Tambah
	public function tambah($data) {
		$this->db->insert('associates',$data);
	}

	// Edit
	public function edit($data) {
		$this->db->where('id_staff',$data['id_staff']);
		$this->db->update('associates',$data);
	}

	// Check delete
	public function check($id_staff) {
		$query = $this->db->get_where('produk',array('id_staff' => $id_staff));
		return $query->num_rows();
	}

	// Delete
	public function delete($data) {
		$this->db->where('id_staff',$data['id_staff']);
		$this->db->delete('associates',$data);
	}
}