IDCOL/api/application/models/Upgrade_model.php

<?php
if (!defined('BASEPATH'))exit('No direct script access allowed');
include_once(FCPATH . 'application/models/Base_model.php');
class Upgrade_model extends Base_model {

    protected $table = 'upgrade_package';

    public function __construct() {
        parent::__construct();
    }
    
    public function getList($filter,$page = null,$limit = null){
    	$where_sql = "";
		if (isset($filter['id'])){
			$where_sql = " AND id=".$filter['id']." ";
		}
		
		if (isset($filter['upgradename'])){
			$where_sql = " AND upgradename LIKE '%".$filter['upgradename']."%'";
		}
		
		if (isset($filter['productname'])){
			$where_sql = " AND productname LIKE '%".$filter['productname']."%' ";
		}
		
		if (isset($filter['productmold'])){
			$where_sql = " AND productmold LIKE '%".$filter['productmold']."%' ";
		}
		
    	$sql = "SELECT * FROM upgrade_package WHERE 1=1 ";
    	$limit_sql = "";
    	if ($page != null && $limit != null){
    		$limit_sql = " LIMIT ".($page-1)*$limit.",".$limit;
    	}
    	 
    	$query  = $sql.$where_sql."  ORDER BY pulishdate DESC  ".$limit_sql;
    	$query  = $this->db->query($query);
    	return  $query->result_array();
    }
    
    public function getTotal($filter){
    	$where_sql = "";
		if (isset($filter['id'])){
			$where_sql = " AND id=".$filter['id']." ";
		}
		
		if (isset($filter['upgradename'])){
			$where_sql = " AND upgradename LIKE '%".$filter['upgradename']."%' ";
		}
		
		if (isset($filter['productname'])){
			$where_sql = " AND productname LIKE '%".$filter['productname']."%' ";
		}
		
		if (isset($filter['productmold'])){
			$where_sql = " AND productmold LIKE '%".$filter['productmold']."%' ";
		}
		
    	$sql = "SELECT COUNT(*) AS total FROM upgrade_package WHERE 1=1 ";
    	$limit_sql = "";
    	$query  = $sql.$where_sql."  ORDER BY pulishdate DESC  ".$limit_sql;
    	$query  = $this->db->query($query);
    	$row =   $query->row_array();
    	return   $row['total'];
    }
    
    public function delete($filter){
    	if (!empty($filter)){
    		foreach ($filter as $k => $v) {
    			$this->db->where($k,$v);
    		}
    	}
    	$this->db->delete('upgrade_package');
    	if ($this->db->affected_rows() > 0) {
    		return true;
    	} else {
    		return false;
    	}
    }
    
    public function getUpgradeOne($id){
    	$sql = "SELECT * FROM upgrade_package WHERE id=".$id;
    	$query  = $this->db->query($sql);
    	return  $query->row_array();
    }

}