<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Customer extends CI_Controller
{
	function __construct() {
		parent::__construct();
		$this->load->model('customer_model');
		$this->load->model('log_model');
	}
	public function index(){
		//get all customer records to display list
		$data['data'] = $this->customer_model->getCustomer();
		$this->load->view('customer/list',$data);
	} 
	/*
		get all state of country
	*/
	public function getState($id){
		$data = $this->customer_model->getState($id);
		echo json_encode($data);
	}
	/*
		get all city of state
	*/
	public function getCity($id){
		$data = $this->customer_model->getCity($id);
		echo json_encode($data);
	}
	/* 
		Delete selected  Customer Record 
	*/
	public function delete($id){
		if($this->customer_model->deleteModel($id)){
			$log_data = array(
						'user_id'  => $this->session->userdata('user_id'),
						'table_id' => $id,
						'message'  => 'Customer Deleted'
					);
				$this->log_model->insert_log($log_data);
			redirect('customer','refresh');
		}
		else{
			$this->session->set_flashdata('fail', 'Customer can not be Deleted.');
			redirect("customer",'refresh');
		}
	}
	/* 
		call add view to add customer record 
	*/
	public function add(){
		$data['country']  = $this->customer_model->getCountry();
		$this->load->view('customer/add',$data);
	}
	/* 
		call edit view to edit customer record 
	*/
	public function edit($id){
		$data['data'] = $this->customer_model->getRecord($id);
		$data['country']  = $this->customer_model->getCountry();
		$data['state'] = $this->customer_model->getState($data['data'][0]->country_id);
		$data['city'] = $this->customer_model->getCity($data['data'][0]->state_id);
		$this->load->view('customer/edit',$data);
	}
	/* 
		This function used to add record in database 
	*/
	public function addCustomer(){
		$this->form_validation->set_rules('customer_name','Customer Name','trim|required|min_length[3]|callback_alpha_dash_space1');
		//$this->form_validation->set_rules('gstid', 'GSTID', 'trim|required');
		$this->form_validation->set_rules('company_name', 'Company Name', 'trim|required|min_length[3]|callback_alpha_dash_space');
		$this->form_validation->set_rules('address', 'Address', 'required');
		$this->form_validation->set_rules('city', 'City', 'trim|required');
		$this->form_validation->set_rules('country', 'Country', 'trim|required');
		$this->form_validation->set_rules('state', 'State', 'trim|required');
		//$this->form_validation->set_rules('mobile', 'Mobile', 'trim|required|numeric|min_length[10]|max_length[10]|callback_mobile');
		//$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
		$this->form_validation->set_rules('postal_code', 'Postal Code', 'trim|required|numeric|min_length[6]|max_length[6]|callback_postal_code');

		if($this->form_validation->run()==false){
			$this->add();
		}
		else
		{
			
			$data = array(
						"customer_name"	=>	$this->input->post('customer_name'),
						"company_name"	=>	$this->input->post('company_name'),
						"address"	=>	$this->input->post('address'),
						"city_id"	=>	$this->input->post('city'),
						"country_id"	=>	$this->input->post('country'),
						"state_id"	=>	$this->input->post('state'),
						"mobile"	=>	$this->input->post('mobile'),
						"email"		=>	$this->input->post('email'),
						"postal_code"	=>	$this->input->post('postal_code'),
						"gstid"		=>	$this->input->post('gstid'),
						"vat_no"    =>	$this->input->post('vatno'),
						"pan_no"    =>	$this->input->post('panno'),
						"tan_no"    =>	$this->input->post('tan'),
						"cst_reg_no"    =>	$this->input->post('cstregno'),
						"excise_reg_no"    =>	$this->input->post('exciseregno'),
						"lbt_reg_no"    =>	$this->input->post('lbtregno'),
						"servicetax_reg_no"    =>	$this->input->post('servicetaxno'),
						"gst_registration_type" =>	$this->input->post('gstregtype')
					);

			if($id = $this->customer_model->addModel($data)){ 
				$log_data = array(
						'user_id'  => $this->session->userdata('user_id'),
						'table_id' => $id,
						'message'  => 'Customer Inserted'
					);
				$this->log_model->insert_log($log_data);
				redirect('customer','refresh');
			}
			else{
				$this->session->set_flashdata('fail', 'Customer can not be Inserted.');
				redirect("customer",'refresh');
			}
		}
		
	}
	/* 
		This function used to edit customer record in database 
	*/
	public function editCustomer(){
		$id = $this->input->post('id');
		$this->form_validation->set_rules('customer_name','Customer Name','trim|required|min_length[3]|callback_alpha_dash_space1');
		//$this->form_validation->set_rules('gstid', 'GSTID', 'trim|required');
		$this->form_validation->set_rules('company_name', 'Company Name', 'trim|required|min_length[3]|callback_alpha_dash_space');
		$this->form_validation->set_rules('address', 'Address', 'required');
		$this->form_validation->set_rules('city', 'City', 'trim|required');
		$this->form_validation->set_rules('country', 'Country', 'trim|required');
		$this->form_validation->set_rules('state', 'State', 'trim|required');
		//$this->form_validation->set_rules('mobile', 'Mobile', 'trim|required|numeric|min_length[10]|max_length[10]|callback_mobile');
		//$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
		$this->form_validation->set_rules('postal_code', 'Postal Code', 'trim|required|numeric|min_length[6]|max_length[6]|callback_postal_code');

		if($this->form_validation->run()==false){
			$this->edit($id);
		}
		else
		{
			$data = array(
						"customer_name"	=>	$this->input->post('customer_name'),
						"company_name"	=>	$this->input->post('company_name'),
						"address"		=>	$this->input->post('address'),
						"city_id"		=>	$this->input->post('city'),
						"country_id"	=>	$this->input->post('country'),
						"state_id"		=>	$this->input->post('state'),
						"mobile"		=>	$this->input->post('mobile'),
						"email"			=>	$this->input->post('email'),
						"postal_code"	=>	$this->input->post('postal_code'),
						"gstid"			=>	$this->input->post('gstid'),
						"vat_no"    =>	$this->input->post('vatno'),
						"pan_no"    =>	$this->input->post('panno'),
						"tan_no"    =>	$this->input->post('tan'),
						"cst_reg_no"    =>	$this->input->post('cstregno'),
						"excise_reg_no"    =>	$this->input->post('exciseregno'),
						"lbt_reg_no"    =>	$this->input->post('lbtregno'),
						"servicetax_reg_no"    =>	$this->input->post('servicetaxno'),
						"gst_registration_type" =>	$this->input->post('gstregtype'),
						"customer_id"	=>	$this->input->post('id')
						);
			if($this->customer_model->editModel($data,$id)){
				$log_data = array(
						'user_id'  => $this->session->userdata('user_id'),
						'table_id' => $id,
						'message'  => 'Customer Updated'
					);
				$this->log_model->insert_log($log_data);
				redirect('customer','refresh');
			}
			else{
				$this->session->set_flashdata('fail', 'Customer can not be Updated.');
				redirect("customer",'refresh');
			}
		}
	}
	function alpha_dash_space($str) {
		if (! preg_match("/^([-a-zA-Z ])+$/i", $str))
	    {
	        $this->form_validation->set_message('alpha_dash_space', 'The %s field may only contain alpha, spaces and dashes.');
	        return FALSE;
	    }
	    else
	    {
	        return TRUE;
	    }
	}
	function alpha_dash_space1($str) {
		if (! preg_match("/^([a-zA-Z ])+$/i", $str))
	    {
	        $this->form_validation->set_message('alpha_dash_space1', 'The %s field may only contain alpha and spaces.');
	        return FALSE;
	    }
	    else
	    {
	        return TRUE;
	    }
	}
	function mobile($str) {
		if (! preg_match("/^[6-9][0-9]{9}$/", $str))
	    {
	        $this->form_validation->set_message('mobile', 'The %s field may only contain Numeric and 10 digit(Ex.9898767654)');
	        return FALSE;
	    }
	    else
	    {
	        return TRUE;
	    }
	}
	function postal_code($str) {
		if (! preg_match("/^[1-9][0-9]{5}$/", $str))
	    {
	        $this->form_validation->set_message('postal_code', 'The %s field may only contain Numeric and 6 digit (Ex.382463)');
	        return FALSE;
	    }
	    else
	    {
	        return TRUE;
	    }
	}
	function generateRandomString($length) {
	    $characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
	    $charactersLength = strlen($characters);
	    $randomString = '';
	    for ($i = 0; $i < $length; $i++) {
	        $randomString .= $characters[rand(0, $charactersLength - 1)];
	    }
	    return $randomString;
	}
	public function test(){
		$data = array(
				'customer_name' => $this->input->post('customer_name'),
				'address'	 =>	$this->input->post('address'),
				'city_id'	 =>	$this->input->post('city'),
				'country_id'	=>	$this->input->post('country'),
				'state_id'	 =>	$this->input->post('state'),
				'mobile'	 =>$this->input->post('mobile')
			);
		echo $this->db->insert('customer',$data);
	}
}
?>