<?php
class Pk_cust_report_model extends CI_Model{
	public function search($search,$filters,$rows = 0,$limit_from= 0,$sort='',$order='asc'){
		$start_date = $filters['start_date'];
		$end_date   = $filters['end_date'];
		if(!$sort){
			$sort = "from_date"; 
		}
		$package_list  = $this->get_package();
		$list_check = "";
		$count = 0;
		foreach($package_list as $package){			
			$package_name = $package->package_name;
			$is_check = $filters[$package_name];
			if($is_check !== false){
				/*
				$count++;
				if((int)$count === 1){
					$list_check .= "where('package_name','".$package_name."')";
				}else{
					$list_check .= "->or_where('package_name','".$package_name."')";
				}
				*/
				$list_check .= "$package_name,";
			}
		}
		
		
		$this->db->from('package_line');
		$this->db->join('package_management', 'package_management.package_id = package_line.package_id','left');
		$this->db->join('customers', 'customers.cust_id = package_line.cust_id','left');
		
		$this->db->group_start();
			$this->db->where('DATE_FORMAT(from_date, "%Y-%m-%d") BETWEEN '. $this->db->escape($start_date).' AND '.$this->db->escape($end_date));
		$this->db->group_end();
		
		if($list_check !== ""){
			$list_check = rtrim($list_check,",");
			$list = explode(",",$list_check);
			$this->db->group_start();
				$this->db->where_in('package_name', $list);
			$this->db->group_end();
		}
		
		$this->db->where('package_line.status',1);
		if($rows>0){
			$this->db->limit($rows, $limit_from);
		}
		
		
		return $this->db->get();
	}
	public function get_package() {
		$this->db->select('package_name');
		$this->db->from('sblt_package_management');
		$this->db->group_by('package_name', 'asc');
		$this->db->order_by('package_id', 'asc');
		return $this->db->get()->result();
	}
	public function get_found_rows($search,$filters){
		return $this->search($search, $filters)->num_rows();
	}
	public function excel_package_type_report($start_date, $end_date){
		
		$this->db->select('*,customer_name,phone_number,payment_type,cust_email,cust_address,person_count,trip_days,bus_count');
		$this->db->from('package_line');
		$this->db->join('package_management', 'package_management.package_id = package_line.package_id','left');
		$this->db->join('customers', 'customers.cust_id = package_line.cust_id','left');
		
		
		$this->db->group_start();
			$this->db->where('DATE_FORMAT(from_date, "%Y-%m-%d") BETWEEN '. $this->db->escape($start_date).' AND '.$this->db->escape($end_date));
		$this->db->group_end();
		
		$this->db->where('package_line.status',1);
		$excel = $this->db->get();
		
	    return $excel->result_array();
		//print_r($xx);
			
	}
	
	
	
}
?>