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

class Dailysettlement extends MY_Controller {
	public function __construct() {
		parent::__construct();
		//$this->redirect_guest();
		$this->admin=$this->session->userdata('admin'); 
		$this->load->helper('download');	
		$this->load->model('admin/mdriver');
		$this->load->model('admin/mdailysettlement');
	}
	public function  index() { 
		$settlement_date=$this->input->post('settlement_date');
		if($settlement_date){
			$settlement_format_date = date('Y-m-d', strtotime(str_replace('/', '-', $settlement_date)));
		}else{
			$settlement_format_date=date('Y-m-d');
		}
		$this->_load_list_view_new_driver($settlement_format_date);		
	}	
	private function _load_list_view_new_driver($settlement_format_date) {
		$data					=  array();
		$data['customer_list']=$this->mcommon->getDetails('master_customer',array('customer_status'=>1));
		$data['cash_in_data']=$this->mdailysettlement->get_transaction_data_cash_in($settlement_format_date,1);
		$data['cash_in_details']=$this->mdailysettlement->get_transaction_data_cash_in_out_details($settlement_format_date,1);
		$data['cash_out_data']=$this->mdailysettlement->get_transaction_data_cash_out($settlement_format_date,2);
		$data['cash_out_details']=$this->mdailysettlement->get_transaction_data_cash_in_out_details($settlement_format_date,2);
		$data['docket_header']=$this->mdailysettlement->get_docket_header($settlement_format_date);
		$data['docket_details']=$this->mdailysettlement->get_docket_details($settlement_format_date);
		$data['settlement_data']=$this->mcommon->getRow('daily_transactions_settle',array('transaction_date'=>$settlement_format_date));
		$data['transaction_date']=date('d/m/Y',strtotime($settlement_format_date));
		
		//$transaction_previous_date=date('Y-m-d', strtotime('-1 day', strtotime($settlement_format_date)));
		$data['opening_balance']=$this->mcommon->getRow('daily_transactions_settle',array("transaction_date < '".$settlement_format_date."' ORDER BY transaction_date DESC LIMIT 1"=>null));
		//echo $this->db->last_query();die;

		
		
		$data['content'] 		= 'admin/daily_settlement/daily_settlement';
		$this->load->view('admin/layouts/index', $data);
		
	}

	public function add_money(){

		$daily_settlement_data=array(); 
		
		$daily_settlement_data['transaction_date'] =date('Y-m-d');
		$daily_settlement_data['customer_id'] =$this->input->post('customer_id');
		$daily_settlement_data['transaction_type '] =1; //1=> Add,2=>Deduct
		$daily_settlement_data['5c_coins_qty'] =$this->input->post('5c_coins_qty');
		$daily_settlement_data['5c_coins_amt'] =$this->input->post('5c_coins_amt');
		$daily_settlement_data['10c_coins_qty'] =$this->input->post('10c_coins_qty');
		$daily_settlement_data['10c_coins_amt'] =$this->input->post('10c_coins_amt');
		$daily_settlement_data['20c_coins_qty'] =$this->input->post('20c_coins_qty');
		$daily_settlement_data['20c_coins_amt'] =$this->input->post('20c_coins_amt');
		$daily_settlement_data['50c_coins_qty'] =$this->input->post('50c_coins_qty');
		$daily_settlement_data['50c_coins_amt'] =$this->input->post('50c_coins_amt');
		$daily_settlement_data['1d_coins_qty'] =$this->input->post('1d_coins_qty');
		$daily_settlement_data['1d_coins_amt'] =$this->input->post('1d_coins_amt');
		$daily_settlement_data['2d_coins_qty'] =$this->input->post('2d_coins_qty');
		$daily_settlement_data['2d_coins_amt'] =$this->input->post('2d_coins_amt');
		$daily_settlement_data['5d_notes_qty'] =$this->input->post('5d_notes_qty');
		$daily_settlement_data['5d_notes_amt'] =$this->input->post('5d_notes_amt');
		$daily_settlement_data['10d_notes_qty'] =$this->input->post('10d_notes_qty');
		$daily_settlement_data['10d_notes_amt'] =$this->input->post('10d_notes_amt');
		$daily_settlement_data['20d_notes_qty'] =$this->input->post('20d_notes_qty');
		$daily_settlement_data['20d_notes_amt'] =$this->input->post('20d_notes_amt');
		$daily_settlement_data['50d_notes_qty'] =$this->input->post('50d_notes_qty');
		$daily_settlement_data['50d_notes_amt'] =$this->input->post('50d_notes_amt');
		$daily_settlement_data['100d_notes_qty'] =$this->input->post('100d_notes_qty');
		$daily_settlement_data['100d_notes_amt'] =$this->input->post('100d_notes_amt');
		$daily_settlement_data['total_amount'] =$this->input->post('total_amount');
		$daily_settlement_data['created_by'] =$this->session->userdata('user_data');
		$daily_settlement_data['created_ts'] =date('Y-m-d H:i:s');

		$transaction_id = $this->mcommon->insert('daily_transactions',$daily_settlement_data);
		if($transaction_id){
			$return_data=array('status'=>true,'msg'=>'Amount added successfully');

		}
		else{
			$return_data=array('status'=>false,'msg'=>'Oops!something went wrong...');

		}
		echo json_encode($return_data);
	}

	public function add_money_cash_out(){

		$daily_settlement_data=array(); 
		
		$daily_settlement_data['transaction_date'] =date('Y-m-d');
		$daily_settlement_data['customer_id'] =$this->input->post('customer_id_out');
		$daily_settlement_data['transaction_type '] =2; //1=> Add,2=>Deduct
		$daily_settlement_data['5c_coins_qty'] =$this->input->post('5c_coins_qty');
		$daily_settlement_data['5c_coins_amt'] =$this->input->post('5c_coins_amt');
		$daily_settlement_data['10c_coins_qty'] =$this->input->post('10c_coins_qty');
		$daily_settlement_data['10c_coins_amt'] =$this->input->post('10c_coins_amt');
		$daily_settlement_data['20c_coins_qty'] =$this->input->post('20c_coins_qty');
		$daily_settlement_data['20c_coins_amt'] =$this->input->post('20c_coins_amt');
		$daily_settlement_data['50c_coins_qty'] =$this->input->post('50c_coins_qty');
		$daily_settlement_data['50c_coins_amt'] =$this->input->post('50c_coins_amt');
		$daily_settlement_data['1d_coins_qty'] =$this->input->post('1d_coins_qty');
		$daily_settlement_data['1d_coins_amt'] =$this->input->post('1d_coins_amt');
		$daily_settlement_data['2d_coins_qty'] =$this->input->post('2d_coins_qty');
		$daily_settlement_data['2d_coins_amt'] =$this->input->post('2d_coins_amt');
		$daily_settlement_data['5d_notes_qty'] =$this->input->post('5d_notes_qty');
		$daily_settlement_data['5d_notes_amt'] =$this->input->post('5d_notes_amt');
		$daily_settlement_data['10d_notes_qty'] =$this->input->post('10d_notes_qty');
		$daily_settlement_data['10d_notes_amt'] =$this->input->post('10d_notes_amt');
		$daily_settlement_data['20d_notes_qty'] =$this->input->post('20d_notes_qty');
		$daily_settlement_data['20d_notes_amt'] =$this->input->post('20d_notes_amt');
		$daily_settlement_data['50d_notes_qty'] =$this->input->post('50d_notes_qty');
		$daily_settlement_data['50d_notes_amt'] =$this->input->post('50d_notes_amt');
		$daily_settlement_data['100d_notes_qty'] =$this->input->post('100d_notes_qty');
		$daily_settlement_data['100d_notes_amt'] =$this->input->post('100d_notes_amt');
		$daily_settlement_data['total_amount'] =$this->input->post('total_amount_out');
		$daily_settlement_data['created_by'] =$this->session->userdata('user_data');
		$daily_settlement_data['created_ts'] =date('Y-m-d H:i:s');

		$transaction_id = $this->mcommon->insert('daily_transactions',$daily_settlement_data);
		if($transaction_id){
			$return_data=array('status'=>true,'msg'=>'Amount added successfully');

		}
		else{
			$return_data=array('status'=>false,'msg'=>'Oops!something went wrong...');

		}
		echo json_encode($return_data);
	}
	

	public function daily_settle_submit(){

		$remarks=$this->input->post('remarks');
		$settlement_date = $this->input->post('settlement_date_hid');
		//echo $settlement_date;die;
		$check_previous_day_status = $this->mdailysettlement->check_previous_day_status($settlement_date);
		//echo '<pre>';print_r($check_previous_day_status);die;
		if(!empty($check_previous_day_status) && $check_previous_day_status['cnt'] > 0){
			$this->session->set_flashdata('error_msg','Next date settlement already done please check');
			redirect(base_url('admin/dailysettlement'));
			
		}else{
			$transaction_settle_id =$this->mdailysettlement->daily_settle_submit($remarks,$settlement_date);
			if($transaction_settle_id){
				$this->session->set_flashdata('success_msg','Settle request submitted successfully');
			} else {
				$this->session->set_flashdata('error_msg','Settle request does not completed!please try again later');
			}
			redirect(base_url('admin/dailysettlement'));
		}	
	
	}

	
	
	
	
}