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

require_once("Secure_Controller.php");

class Sabarimalai_pkg extends Secure_Controller
{
	public function __construct()
	{
		parent::__construct('sabarimalai_pkg');
		$this->load->model('Sabarimalai_pkg_model');
	}

	public function index()
	{

		if(!$this->Appconfig->isAppvalid()){
			redirect('config');
		}
		 $data['table_headers'] = $this->xss_clean(get_sabarimalai_pkg_table_headers());

		   $package[""] = "---- Select Package ----";
		foreach($this->Sabarimalai_pkg_model->get_package()->result_array() as $row){
		    $package[$this->xss_clean($row['package_id'])] = $this->xss_clean($row['package_name']);
		}
		$package["All"] = "ALL";
		$data['package'] = $package;

		$this->load->view('sabarimalai_pkg/manage', $data);
	}

	/*
	Returns Supplier table data rows. This will be called with AJAX.
	*/
	public function search()
	{
		$search = $this->input->get('search');
  		$limit = $this->input->get('limit');
  		$offset = $this->input->get('offset');
  		$sort = $this->input->get('sort');
  		$order = $this->input->get('order');
      $filters = array('crm' => $this->input->get('crm'),
						'crmto' => $this->input->get('crmto'));
       $all_leads = $this->Sabarimalai_pkg_model->search($search, $filters, $limit, $offset, $sort, $order);
        $total_rows = $this->Sabarimalai_pkg_model->get_found_rows($search, $filters);
        $data_rows = array();
        foreach($all_leads->result() as $leads){
            $data_rows[] = get_transfer_data_row($leads, $this);
        }
        echo json_encode(array('total' => $total_rows, 'rows' => $data_rows));
	}	

	/*
	This abstrack_report
	*/
	public function sabarimalai_pkg_report(){
		$filters = array('start_date' => $this->input->post('start_date'), 'end_date' => $this->input->post('end_date'));	
		$package  = $this->input->post('package');
		$result = $this->Sabarimalai_pkg_model->sabarimalai_pkg_report($filters,$package);		
		echo $result;
		
	}
}
?>