GRAYBYTE WORDPRESS FILE MANAGER9830

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

class Appversions_model extends CI_Model
{
    var $table = TABLE_APP_VERSIONS;

    public function __construct()
    {
        parent::__construct();
    }
	
	public function getAppVersionList($params = array())
	{
		$this->db->select('av.*');
        $this->db->from($this->table. ' av');
        if(!empty($params['search']['mobile_no'])){
            $this->db->where('c.mobile_no',$params['search']['mobile_no']);
        }
		if(!empty($params['search']['profile_name'])){
            $this->db->like('c.profile_name',$params['search']['profile_name']);
        }
		if(!empty($params['search']['customer_status'])){
            $this->db->where('c.customer_status',$params['search']['customer_status']);
        }
		$this->db->order_by('av.doc','DESC');
		
        //set start and limit
        if(array_key_exists("start",$params) && array_key_exists("limit",$params)) {
            $this->db->limit($params['limit'],$params['start']);
        } elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params)) {
            $this->db->limit($params['limit']);
        }
        return $this->db->get()->result();
	}
	
	public function getAppData($app_id)
	{
		$this->db->select('*');	
		$this->db->where('app_id', $app_id);
		$this->db->limit(1);
		return $this->db->get($this->table)->row();
	}
	
	public function getApkFileName($app_id)
	{
		$this->db->select('app_file');	
		$this->db->where('app_id', $app_id);
		$this->db->limit(1);
		$data = $this->db->get($this->table)->row();
		return $data->app_file;
	}
	
	public function saveAppVersion($data_array, $id = 0)
	{
		if($id == 0) {
			$this->db->insert($this->table, $data_array);
			$last_id = $this->db->insert_id();
		} else {
			$this->db->where('app_id', $id);
			$this->db->update($this->table, $data_array);
			$last_id = $id;
		}
		return $last_id;
	}
}