<?php if(!defined('BASEPATH')) exit('No direct script access allowed');

require APPPATH . '/libraries/BaseController.php';
require APPPATH . '/third_party/mpdf/mpdf.php';
/**
 * Class : cash Book Controller (cash Book)
 * User Class to control all user related operations.
 * @author : Gandhimathi
 * @version : 1.1
 * @since : 13 Nov 2017  
 */
class cashbook extends BaseController
{
    /**
     * This is default constructor of the class new
     */
	 public function __construct() 
    {
        parent::__construct();
        $this->load->model('cashbook_model');
		$this->load->model('employeedetails_model');
        $this->isLoggedIn(); 
		$this->load->helper(array('form','url'));
		$this->load->library('upload');
		// $this->CompanyName = "RESICO";
   		
    }
	
	function incomeExpenseList()
	{
		
		$aid = $this->uri->segment(3);
		$str = $this->uri->segment(4);
	if(!empty($aid)){

        if(!empty($str))
		{
			//echo "PDF";
				  $data['company'] = $this->cashbook_model->getCompany();
				 
				  $data['data'] = $this->cashbook_model->getIncomeExpenseList($aid);
				 //$pic1 = $data['company'][0]->ProfilePic;
				 //echo $pic1;
				 //$pic = base_url().'uploads/images'.$pic1;
				 //echo $pic;
				  //die();
				  $totalamt = $data['data'][0]->total;
				  $data['amtinwords'] = $this->convertNumber($totalamt);
				  $mpdf=new mPDF('utf-8','A4-P',7, 10,10, 10, 3, 0, 0, 0); 
				  $mpdf->SetHTMLHeader($HtmlHeading);
				  $html = $this->load->view('cashbookpdf',$data,true);
				  $mpdf->SetDisplayMode('fullpage');
				  $mpdf->setFooter($HTMLFooter . "Page {PAGENO} of {nb}");
				  $mpdf->list_indent_first_level = 1;
				  $mpdf->setAutoTopMargin = 'stretch';
				  $mpdf->setAutoBottomMargin = 'stretch';
				  $mpdf->WriteHTML($html);
				  $filename = "cashbook.pdf";
				  $mpdf->Output($filename,I);
       }
		else		
		{
		
		$data['data'] = $this->cashbook_model->getIncomeExpenseList($aid);
		//print_r($data['dropdownvalues']);die();
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: View Income Expense ';
        $this->loadViews("viewIndIncomeExpense", $this->global, $data , NULL);
			
		}
		
	}else{
		 // $data['list'] = $this->cashbook_model->getIncomeExpenseList();
		// $this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
        
		// $this->loadViews("income_expense_list", $this->global, $data , NULL);
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
		$data['finyear']=$this->cashbook_model->finyear();
		
		if ($this->input->post('btn_submit')) {
			
			 $fromdt = $this->input->post('from_date');
			 $todt = $this->input->post('to_date');
			 $ab=$this->input->post('financialyear');
			
			 $fromyear=substr($ab,0,-5);
			 $toyear=substr($ab,5,5);
			 
			
		     $data['finyear']=$this->cashbook_model->finyear();
			 $data['list'] = $this->cashbook_model->getIncomeExpense($fromyear,$toyear,$fromdt,$todt);
			
			}
		// else{
			
			// if (date('m') <= 3) {
				// $preyear = (date('Y')-1);
				// $currentyear = date('Y');
			// } else {
				// $preyear = date('Y') ;
				// $currentyear = (date('Y') + 1);
			// }
			
			// $data['list'] = $this->cashbook_model->getIncomeExpense($preyear,$currentyear);
			// $data['finyear']=$this->cashbook_model->finyear();
		// }
            $this->loadViews("income_expense_list", $this->global, $data , NULL);
	}
	
	
	}
	
	
	function bankreceipt()
	{
		
		$aid = $this->uri->segment(3);
		$str = $this->uri->segment(4);
	if(!empty($aid)){

        if(!empty($str))
		{

				  $data['company'] = $this->cashbook_model->getCompany();
				  $data['data'] = $this->cashbook_model->getIncomeExpenseList($aid);
				  $totalamt = $data['data'][0]->total;
				  $data['amtinwords'] = $this->convertNumber($totalamt);
				  $mpdf=new mPDF('utf-8','A4-P',7, 10,10, 10, 3, 0, 0, 0); 
				  $mpdf->SetHTMLHeader($HtmlHeading);
				  $html = $this->load->view('cashbookpdf',$data,true);
				  $mpdf->SetDisplayMode('fullpage');
				  $mpdf->setFooter($HTMLFooter . "Page {PAGENO} of {nb}");
				  $mpdf->list_indent_first_level = 1;
				  $mpdf->setAutoTopMargin = 'stretch';
				  $mpdf->setAutoBottomMargin = 'stretch';
				  $mpdf->WriteHTML($html);
				  $filename = "bankreceipt.pdf";
				  $mpdf->Output($filename,I);
       }
		else		
		{
		
		$data['data'] = $this->cashbook_model->getIncomeExpenseList($aid);
		//print_r($data['dropdownvalues']);die();
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: View Income Expense ';
        $this->loadViews("viewIndIncomeExpense", $this->global, $data , NULL);
			
		}
		
	}else{
		// $data['list'] = $this->cashbook_model->getIncomeExpenseList();
		// $this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
        
		// $this->loadViews("income_expense_list", $this->global, $data , NULL);
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
		
		if ($this->input->post('btn_submit')) {
			
			 $fromdt = $this->input->post('from_date');
			 $todt = $this->input->post('to_date');
			 $ab=$this->input->post('financialyear');
			
			 $fromyear=substr($ab,0,-5);
			 $toyear=substr($ab,5,5);
			 
			
		     $data['finyear']=$this->cashbook_model->finyear();
			 $data['list'] = $this->cashbook_model->getIncomeExpense($fromyear,$toyear,$fromdt,$todt);
			
			}
		else{
			
			if (date('m') <= 3) {
				$preyear = (date('Y')-1);
				$currentyear = date('Y');
			} else {
				$preyear = date('Y') ;
				$currentyear = (date('Y') + 1);
			}
			
			$data['list'] = $this->cashbook_model->getIncomeExpense($preyear,$currentyear);
			$data['finyear']=$this->cashbook_model->finyear();
		}
            $this->loadViews("income_expense_list", $this->global, $data , NULL);
	}
	
	
	}
	
	
	function addNewIncomeExpenseLoad()
	{
		
		$data['dropdownvalues'] = $this->cashbook_model->getAccounTypes();
		$data['getsupplier'] = $this->cashbook_model->getsupplier();
		//print_r($data['dropdownvalues']);die();
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Add New Income Expense ';
        $this->loadViews("addnewIncomeExpense", $this->global, $data , NULL);
	}
	
	function autocomplete()
	{
		//$this->load->model('model','cashbook_model');
		$mer = $this->input->get('query');	
		$query= $this->cashbook_model->checkMerchant($mer);
		echo json_encode($query);
	
	} 
	
	function getSupplierDtls()
	{	 
		$s = $this->input->post('id');
		$supp = $this->cashbook_model->getsupp_dtls($s);
		echo json_encode($supp);
	}

	function bankfileview()
	{
		
		//$data['dropdownvalues'] = $this->cashbook_model->getAccounTypes();
		//print_r($data['dropdownvalues']);die();
		$data['bankdetails']=$this->employeedetails_model->getBankDetails();
		//$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Add New Income Expense ';
		$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - File Upload';
		$data['bankbalance'] = $this->cashbook_model->getbalancedetails();
		$data['cleareddebitbalance'] = $this->cashbook_model->cleareddebitbalance();
		$data['clearedcreditbalance'] = $this->cashbook_model->clearedcreditbalance();
        $this->loadViews("bankingfile", $this->global, $data , NULL);
	}
	function bankfileupload()
	{
		//document => default NULL
	    $document = null;
		// fs => File Name default 0
		$fs = 0;
		if(!empty($_FILES['userfile']['name']))
        {
				//echo "FILE AVAILABLE";
				$config['file_name'] = $_FILES['userfile']['name']; // This Also FileName with format.
				$myFIle = $config['file_name']; // This Also FileName with format.
				// xls File destination folder Given Below.
				$config['upload_path'] = 'uploads/banking/';
				$path = $config['upload_path'];
				//Destionation Path => uploads/banking.
				$filename = $config['file_name'];// This Also FileName with format.
				$document = $path.$filename;
				
				
				$fs = $this->uploadFile1();
				// $this->function_alert($fs);
				$document = $path.$fs;
				$created_by = $this->session->userdata('userId');

				 $openingbalance=0;
				 $closingbalance=0;
				$inputFileName = $_FILES['userfile']['tmp_name'];
                require_once  APPPATH .'third_party/PHPExcel/IOFactory.php';
                $objTpl = PHPExcel_IOFactory::load($inputFileName);
                $sheet = $objTpl->getActiveSheet();//->toArray(null, true,true,true);

				$highestRow = $sheet->getHighestRow(); 
				$highestColumn = $sheet->getHighestColumn();
				
					
				 $highestRow4=$highestRow-4;
               

				$bank = $this->input->post('bankbranchname');
				$fileupload=  array('Bankname'=>$bank,'document'=>$document);
				
				$res = $this->cashbook_model->bankfile($fileupload);
				for($x=21;$x<=$highestRow4;$x++){

					if($x == 21){

                    // $openingbalance=$sheet->getCell('H'.$x)->getValue(); 
					$openingbalance=preg_replace('/\D/', '', $sheet->getCell('H'.$highestRow4)->getValue());

					}
					if($x == $highestRow4){

						// $closingbalance=$sheet->getCell('H'.$highestRow4)->getValue(); 
						$closingbalance=preg_replace('/\D/', '', $sheet->getCell('H'.$highestRow4)->getValue());
						
					}



									   $t=$sheet->getCell('A'.$x)->getValue();
									   $dat= str_replace('/','-',$t);	
									   
									   if (empty($dat))
									   {      
										 $Date1 = NULL;
									   }
									   else
									   {
										 $Date1 = strtotime( $dat);
										 $Date1 = date("Y-m-d ", $Date1);
									   }
							   
									
		
									$s=$sheet->getCell('B'.$x)->getValue();						
									$dat1= str_replace('/','-',$s);
									


									if (empty($dat1))
									{      
									  $Date2 = NULL;
									}
									else
									{
									  
									 $Date2 = date('Y-m-d',strtotime($dat1));							
		 
									}
								   
		
									 $chqno =  (($sheet->getCell('C'.$x)->getValue() == '') || ($sheet->getCell('C'.$x)->getValue() == null))  ? $sheet->getCell('C'.$x)->getValue() : "-" ;
					                 $narration = $sheet->getCell('D'.$x)->getValue();
					                 $cod  =(($sheet->getCell('E'.$x)->getValue() == '') || ($sheet->getCell('E'.$x)->getValue() == null))  ? $sheet->getCell('E'.$x)->getValue() : 0 ;
									 $debit  = (($sheet->getCell('F'.$x)->getValue() == '') || ($sheet->getCell('F'.$x)->getValue() == null))  ? $sheet->getCell('F'.$x)->getValue() : 0 ;
		                             $credit=(($sheet->getCell('G'.$x)->getValue() == '') || ($sheet->getCell('G'.$x)->getValue() == null))  ? $sheet->getCell('G'.$x)->getValue() : 0 ;
									 $balance=(($sheet->getCell('H'.$x)->getValue() == '') || ($sheet->getCell('H'.$x)->getValue() == null))  ? $sheet->getCell('H'.$x)->getValue() : 0 ;
				                     if($debit==0)
									 {
										 $Status='';
									 }
                                     else
									 {
										 $Status='OPEN';
									 } 
									 if ($credit==0)
									 {
										 $cstatus='';
									 }
									 else
									 {
										$cstatus='OPEN'; 
									 }
                                     									 
                    // $IsActive=0;
					$filedataupload= array('reportdate'=>$Date1,'valuedate'=>$Date2,'chequeNo'=>$cod,'Narration'=>$narration,'Cod'=> $chqno,'Debit'=>$debit,'Credit'=>$credit,'cbalancetocleared'=>$credit,'Balance'=>$balance,'Bankname'=>$bank,'Status'=>$Status,'cstatus'=>$cstatus);
					// print_r($filedataupload);
					
			   $res = $this->cashbook_model->bankfiledata($filedataupload);
			//    echo "response ".$res; 
			}
			// die();
			$balance=  array('filename'=>$config['file_name'],'created_by'=>$created_by,'openingbalance'=>$openingbalance,'closingbalance'=>$closingbalance);
			$bal = $this->cashbook_model->balance($balance);
	   
			
			if( $res == 1 ){
				echo "<script>alert('Saved Successfully!');window.location.href='Bankingstatement';</script>";
			}
			else
			{
				echo "<script>alert('Saved unsuccessfully!');window.location.href='Bankingstatement';</script>";	
			}
	    }
	}

	function addIncomeExpense()
	{   
	
	    
	  $bankdate = $this->input->post('bankdate');
	  $bankid = $this->input->post('bakid');
	  $remaindebitamount=$this->input->post('remaindebitamount');
	  $remaincreditamount=$this->input->post('remaincreditamount');
	  $amount = $this->input->post('bankamount');
	  $amounttype = $this->input->post('type');   
	  $totalbankamount = $this->input->post('totalbankamount');   
	  $alreadypaid=$this->input->post('alreadydebitpaid');
	  $directamount = $this->input->post('totalamount');
	  $debitamount=$this->input->post('debitamount');
	  $alreadycreditpaid=$this->input->post('alreadycreditpaid');
	  $bankorcash=$this->input->post('borc');
	  $total=$directamount+$alreadypaid;
	  $ctotal=$directamount+$alreadycreditpaid;
	  $updateBalancetocleared= $remaindebitamount-$directamount;
	  $updatecbalancetocleared= $remaincreditamount-$directamount;
	  if($amounttype==CREDIT)
	  {
		  $type=RECEIPT;
		  $bankamounttype=CREDIT;
	  }
	  else
	  {
		 $type=PAYMENT;
         $bankamounttype=DEBIT;		 
	  } 
		
		
		
		
		$accounttype = $this->input->post('myradio');
		//$accounttype1 = $this->input->post('myrad');
		//echo $accounttype;
		//echo $accounttype1;
		if($accounttype == 1)
		{
			$accounttype = 'RECEIPT';
		}
		else
		{
			$accounttype = 'PAYMENT';
		}
		
		$accountcode = $this->input->post('accode');
		$date = $this->input->post('Date');
		$date = date_create($date);//,'Y-m-d');
		$date = date_format($date,'Y-m-d');
		$towhome = $this->input->post('towhome');
		$supplier = $this->input->post('supplier');
		
		$gsttoggle = $this->input->post('gsttoggle');
		$invoiceno = null;
			$merchantname = null;
			$mergstno = null;
			$hsn = null;
			$beforegst = null;
			$sgst = null;
			$cgst = null;
			$igst = null;
		if(!empty($gsttoggle))
		{
		$invoiceno = $this->input->post('Invoiceno');
		$merchantname = $this->input->post('merchant');
		$mergstno = $this->input->post('Merchantgst');
		$hsn = $this->input->post('hsn');
		$beforegst = $this->input->post('valuebeforegST');
		$sgst = $this->input->post('SGST');
		$cgst = $this->input->post('CGST');
		$igst = $this->input->post('IGST');
		
		}
		
		
		$cashbookamount=$this->input->post('totalamount1');
		$totalamount=$directamount+$cashbookamount;
		$description = $this->input->post('description');
		if(empty($description)){$description = 'NA';}
		$document = null;
		
		$fs = 0;
		if(!empty($_FILES['myfile']['name']))
            {
				//echo "FILE AVAILABLE";
				$config['file_name'] = $_FILES['myfile']['name'];
				$config['upload_path'] = 'uploads/cashbook/';
				$path = $config['upload_path'];
				//$filename = $config['file_name'];
				$document = $path.$filename;
				//echo $document;
				$fs = $this->uploadFile();
				$document = $path.$fs;

			}
			if($bankorcash==Bank)
	     	{
			$option=Bank;
		   }
		  else
		  {
			$option=Cash;
		  }
			$balance=$totalbankamount-$totalamount;
			$IsActive=1;
			$created_by = $this->session->userdata('userId');
			$addincomexpense =  array('type'=>$accounttype,'account_code'=>$accountcode,'date'=>$date,'towhom'=>$towhome,'Supplier_id'=>$supplier,'invoice_no'=>$invoiceno,'merchant'=>$merchantname,'merchant_gst'=>$mergstno,'HSN'=>$hsn	,'value_before_gst'=>$beforegst,'sgst'=>$sgst,'cgst'=>$cgst,'igst'=>$igst,'total'=>$totalamount,'description'=>$description,'document'=>$document,'Created_By'=>$created_by,'cashtype'=>$option,'bankid'=>$bankid,'totalbankamount'=>$totalbankamount,'balance'=>$balance,'gststatus'=>(!empty($gsttoggle)?'1':'0'),'amounttype'=>$amounttype,'IsActive'=>$IsActive);
			//print_r($addincomexpense);
			//die();
			if($balance=='0')
		   {
		   $stat='CLOSE';	
		   }
		   else
		   {
		   $stat='OPEN';		
		   }
		   $creditbalance=$totalbankamount-$ctotal;
		   //echo $creditbalance; 
		   //die();
		   if($creditbalance==0)
			
		   {
		   $statu='CLOSE';	
		   }
		   else
		   {
		   $statu='OPEN';		
		   }
		   $debitbalance=$totalbankamount-$total;
		   if($debitbalance==0)
					 
			{
			$statu1='CLOSE';	
			}
			else
			{
			$statu1='OPEN';		
			}
			$isactive=1;
		    //$clearbalance=$totalbankamount-
			if($amounttype=='CREDIT')
	         { 
		        $cashbookstatus1= array('cclearbalance'=>$ctotal,'cbalancetocleared'=>$updatecbalancetocleared,'cstatus'=>$statu,'IsActive'=>$isactive);
				//print_r($cashbookstatus1);
				//die();
		        $res1 = $this->cashbook_model->cashcreditupdate($cashbookstatus1,$bankid);
			 }
			 else
			 {
				$cashbookstatus = array('Clearbalance'=>$total,'Balancetocleared'=>$updateBalancetocleared,'Status'=>$statu1,'IsActive'=>$isactive);
                $res23 = $this->cashbook_model->cashbankupdate($cashbookstatus,$bankid);
				 
			 }
			 
			$res = $this->cashbook_model->saveIncomeExpense($addincomexpense);
			if( $res == 1  ){
				//echo "<script>alert('Saved Successfully!');window.location.href='ViewIncomeExpense';</script>";
				   echo "<script>alert('Saved Successfully!');</script>";
				
				    if($bankorcash==Bank)//Redirct To Listing Screen
                    {
                    	redirect('Bankingstatement','refresh');
                     	
                    }
                    else if($bankorcash != ' ')//Redirct To Bank Report Screen
                    {
                       redirect('ViewIncomeExpense','refresh');	
                    }
			}
			
	}
	public function cashpayment()
    {
	  $bankdate = $this->input->post('bankdate');
	  $bankid = $this->input->post('bankid');
	  $amount = $this->input->post('bankamount');
	  $amounttype = $this->input->post('type');
	  $forstatus = $this->input->post('forstatus');
	  $alreadypaid=$this->input->post('alreadypaid');
	  $alreadycreditpaid=$this->input->post('alreadycreditpaid');
	  $debitamount=$this->input->post('debitamount');
	  $creditamount=$this->input->post('creditamount');
	  $total=$amount+$alreadypaid;
	  
	  $option=Bank;
	  if($amounttype==0)
	  {
		  $type=RECEIPT;
		  $bankamounttype=CREDIT;
	  }
	  else
	  {
		 $type=PAYMENT;
         $bankamounttype=DEBIT;		 
	  }
	  
	  $bankcash1 =  array('cdate'=>$bankdate,'mid'=>$bankid,'btype'=>$type,'amount'=>$alreadypaid,'boption'=>$option,'mappingamount'=>$forstatus,'totalamount'=>$amount,'amounttype'=>$bankamounttype,'alreadycreditpaid'=>$alreadycreditpaid);
	  //print_r($bankcash1);
	  //die();
	 // $res1 = $this->cashbook_model->addcashbook($bankcash1);
        
    }	
	
	function uploadFile()
	{
		
				//echo "INSIDE UPLOAFD";
				 	
				//$this->load->library('upload')
		        $pathinfo = pathinfo($_FILES['myfile']['name']);
                $config['upload_path'] = 'uploads/cashbook/';
                $config['allowed_types'] ='png|jpg|jpeg|pdf';
                $config['file_name'] = $_FILES['myfile']['name'];
                // $config['overwrite'] = true;
                
                //Load upload library and initialize configuration
                $this->load->library('upload',$config);
                $this->upload->initialize($config);
                
                
                        if($this->upload->do_upload('myfile'))
                        {
                            $uploadData = $this->upload->data();
                            $uploadfilename = $uploadData['file_name'];
                            return $uploadfilename;
                            
                        }
                        else
                        {
                            $error = array('error' => $this->upload->display_errors());
                            $uploadfilename = '';
							print_r($error);
							return 0;
                        }
	
	}
	function uploadFile1()
	{
		
				 	
				//$this->load->library('upload')
		        $pathinfo = pathinfo($_FILES['userfile']['name']);
                $config['upload_path'] = 'uploads/banking/';
				// $config['allowed_types'] = 'png|jpg|jpeg|xlsx';
				$config['allowed_types'] = '*';
                $config['file_name'] = $_FILES['userfile']['name'];
                $config['overwrite'] = true;
                //Load upload library and initialize configuration
                $this->load->library('upload',$config);
                $this->upload->initialize($config);
                
                
                        if($this->upload->do_upload('userfile'))
                        {
                            $uploadData = $this->upload->data();
                            $uploadfilename = $uploadData['file_name'];
                            return $uploadfilename;
                            
                        }
                        else
                        {
                            $error = array('error' => $this->upload->display_errors());
                            $uploadfilename = '';
							// print_r($error);
							return 0;
                        }
	
	}
	
	function viewIE()
	{
		
		$aid = $this->uri->segment(3);
		
		$data['data'] = $this->cashbook_model->getAccounutInfo();
		//print_r($data['dropdownvalues']);die();
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: View Income Expense ';
        $this->loadViews("viewIndIncomeExpense", $this->global, $data , NULL);
		
	}
	
	 public function index()
    {
		//$data['dropdownvalues1'] = $this->cashbook_model->getAccounTypes1();
		
        $this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Details';
        $this->loadViews("cashbooklisting", $this->global, NULL , NULL);

	}
	

   
   public function cashbookList()
    {
         
      
            $this->load->model('cashbook_model');
            $data['dropdownvalues1'] = $this->cashbook_model->getAccounTypes1();
			//print_r($data['dropdownvalues1']);
            $data['cashbook'] = $this->cashbook_model->Selectcash();

            $this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Listing';
            
            $this->loadViews("cashbooklisting", $this->global, $data, NULL);
        
	}
	

	//advance list
	public function AdvanceList()
    {
		
		$aid = $this->uri->segment(3);
		$str = $this->uri->segment(4);
	if(!empty($aid)){

        if(!empty($str))
		{
			//echo "PDF";
				  $data['company'] = $this->cashbook_model->getCompany();
				 
				  $data['data'] = $this->cashbook_model->getAdvanceList($aid);
				 //$pic1 = $data['company'][0]->ProfilePic;
				 //echo $pic1;
				 //$pic = base_url().'uploads/images'.$pic1;
				 //echo $pic;
				  //die();
				  $totalamt = $data['data'][0]->total;
				  $data['amtinwords'] = $this->convertNumber($totalamt);
				  $mpdf=new mPDF('utf-8','A4-P',7, 10,10, 10, 3, 0, 0, 0); 
				  $mpdf->SetHTMLHeader($HtmlHeading);
				  $html = $this->load->view('cashbookpdf',$data,true);
				  $mpdf->SetDisplayMode('fullpage');
				  $mpdf->setFooter($HTMLFooter . "Page {PAGENO} of {nb}");
				  $mpdf->list_indent_first_level = 1;
				  $mpdf->setAutoTopMargin = 'stretch';
				  $mpdf->setAutoBottomMargin = 'stretch';
				  $mpdf->WriteHTML($html);
				  $filename = "cashbook.pdf";
				  $mpdf->Output($filename,I);
       }
		else		
		{
		
		$data['data'] = $this->cashbook_model->getAdvanceList($aid);
		//print_r($data['dropdownvalues']);die();
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: View Income Expense ';
        $this->loadViews("viewIndIncomeExpense", $this->global, $data , NULL);
			
		}
		
	}else{
		// $data['list'] = $this->cashbook_model->getIncomeExpenseList();
		// $this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
        
		// $this->loadViews("income_expense_list", $this->global, $data , NULL);
		$this->global['pageTitle'] = $this->CompanyName.' :  Cash Book: Listing';
	    $data['finyear']=$this->cashbook_model->finyear();
		if ($this->input->post('btn_submit')) {
			
			 $fromdt = $this->input->post('from_date');
			 $todt = $this->input->post('to_date');
			 $ab=$this->input->post('financialyear');
			
			 $fromyear=substr($ab,0,-5);
			 $toyear=substr($ab,5,5);
			 
			
		     $data['finyear']=$this->cashbook_model->finyear();
			 $data['list'] = $this->cashbook_model->getAdvance($fromyear,$toyear,$fromdt,$todt);
			
			}
		// else{
			
			// if (date('m') <= 3) {
				// $preyear = (date('Y')-1);
				// $currentyear = date('Y');
			// } else {
				// $preyear = date('Y') ;
				// $currentyear = (date('Y') + 1);
			// }
			
			// $data['list'] = $this->cashbook_model->getAdvance($preyear,$currentyear);
			// $data['finyear']=$this->cashbook_model->finyear();
		// }
            $this->loadViews("Advancelist", $this->global, $data , NULL);
	}
	
	
	}
	
	
    
    
    public function cashbookdtl()
    {

        
        $id = $this->input->post('id');
        $tablevalue = json_decode($id,true);
         //print_r($tablevalue);
         foreach($tablevalue as $tv)
         {    
				if(!empty($tv['AccountCodeType'])){
                  $acc_type = $tv['AccountCodeType'];
                  $acc_code = $tv['AccountCode'];
                  $acc_name = $tv['AccountName'];
				  $acc_pname = $tv['ParentAccountName'];
				  $acc_categories = $tv['Categories'];
                  $acc_desc = $tv['Description'];
                  $acc_state = $tv['Status'];
                  if(strtoupper($acc_state) == 'YES')
            {
                    $acc_status = 1;
            }
            else{
                    $acc_status = 0;
            }
		 
                   
                  $dt = new DateTime('now', new DateTimeZone('Asia/Kolkata'));               
                  $acc_createddt =  $dt->format('Y-m-d H:i:s');
                 
                  $cashbookdatas = array('type'=>$acc_type,'code'=>$acc_code,'name'=>$acc_name,'accountname'=>$acc_pname,'categories'=>$acc_categories,'description'=>$acc_desc,'status'=>$acc_status,'created_on'=>$acc_createddt); 
                // print_r($cashbookdatas);
				
                 $result  = $this->cashbook_model->Cashbook($cashbookdatas);
		 }
		}

                       
                          //redirect('cashbook/cashbookList','refresh');
                          echo "Successfully Saved!"; 
                          
         
       
        
                       
    }
	
	 public function editcashbook()
    {
	  $sid = $this->input->get('sid');
	  if($sid == '')
      {
       $cash =  $_GET['sid']; 
      }
      else
      { 
       $cash  = $sid;      
	  }
         
          
            $this->load->model('cashbook_model');
			
            $data['DepDetails'] = $this->cashbook_model->viewdepartment($cash);
			
			//$data['deletefile'] = $this->cashbook-model->deletefile($cash);
			$data['dropdownvalues'] = $this->cashbook_model->getAccounTypes();
			$data['getsupplier'] = $this->cashbook_model->getsupplier();
			//print_r( $data['DepDetails']);die();
            $this->global['pageTitle'] = $this->CompanyName.' :  Edit Cashbook'; 
            $this->loadViews("editincomeexpenses", $this->global,$data, NULL);
        
    }
	public function deletefile()
    {
	         $cashfile = $this->input->post('id');
			 $cashid = $this->input->post('ide');
			 //echo 'dsmkjsn';
			 //echo $cashid;
			 
			 //echo $cashfile;
			 //die();
             //$this->load->model('cashbook_model');
			 $filedata= $this->cashbook_model->deletefile($cashid);
			 echo $filedata;
            //$this->global['pageTitle'] = $this->CompanyName.' :  Edit Cashbook'; 
            //$this->loadViews("income_expense_list", $this->global,$data, NULL);
        
    }
	function updateExpense()
	{    
	    $id1=$this->input->post('id1');
		$myradio1= $this->input->post('myradio');
		//$myradio2= $this->input->post('myrad');
		$option='';
		if($myradio1==1)
		{
			$option=RECEIPT;
		}
		else
		{
		    $option=PAYMENT;	
		}
		//echo $option;die();
		$ans1 = $this->input->post('ans');
		$Date1 = $this->input->post('Date');
		//echo $Date1;
		$date = date_create($Date1);//,'Y-m-d');
		$date = date_format($date,'Y-m-d');
		//echo $date;
		//$Date1 = $this->input->post('Date');
		$accountcode1 = $this->input->post('accode');
		//echo $accountcode1;die();
		$towhome1 = $this->input->post('towhome');
		$supplier = $this->input->post('supplier');
		$Invoiceno1 = $this->input->post('Invoiceno');
		$merchant1 = $this->input->post('merchant');
		$Merchantgst1 = $this->input->post('Merchantgst');
		$hsn1 = $this->input->post('hsn');
		$valuebeforegST1 = $this->input->post('valuebeforegST');
		$SGST1 = $this->input->post('SGST');
		$CGST1 = $this->input->post('CGST');
		$IGST1 = $this->input->post('IGST');
		$totalamount1 = $this->input->post('totalamount');
		$description1 = $this->input->post('description');
		$deleteflag = $this->input->post('deleteflag');
		$oldfile = $this->input->post('oldfile');
		$amounttype = $this->input->post('amounttype');
		$bankid=$this->input->post('bankid');
		$normalid=$this->input->post('normalid');
		$bankamount=$this->input->post('bankamount');
		$gsttoggle = $this->input->post('gsttoggle');
		$document =null;
		
		//$document1=$this->input->post('myfile');
		$fs = 0;
		if(!empty($_FILES['myfile']['name']))
            {
				//echo "FILE AVAILABLE";
				$config['file_name'] = $_FILES['myfile']['name'];
				$config['upload_path'] = 'uploads/cashbook/';
				$path = $config['upload_path'];
				//$filename = $config['file_name'];
				//$document = $path.$filename;
				//echo $document;
				$fs = $this->uploadFile();
				$document = $path.$fs;
				

			}
			else
			{
				if($deleteflag == 0)
				{
					$document = $oldfile;
				}
				else if($deleteflag == 1)
				{
					$document = null;
				}
			}
			
			   
				$updateaccount =  array('type'=>$option,'account_code'=>$accountcode1,'date'=>$date,'towhom'=>$towhome1,'Supplier_id'=>$supplier,'invoice_no'=>$Invoiceno1,'merchant'=>$merchant1,'merchant_gst'=>$Merchantgst1,'HSN'=>$hsn1,'value_before_gst'=>$valuebeforegST1,'sgst'=>$SGST1,'cgst'=>$CGST1,'igst'=>$IGST1,'total'=>$totalamount1,'gststatus'=>(!empty($gsttoggle)?'1':'0'),'description'=>$description1,'document'=>$document);
				$res = $this->cashbook_model->updatedepartment($updateaccount,$id1);
			//print_r($updateaccount);die();
			   $cashbookamount=$this->cashbook_model->cashbookamount($bankid);
			   $invoiceamount=$this->cashbook_model->invoiceamonut($bankid);
			 $poamount=$this->cashbook_model->poamonut($bankid);
			 foreach($invoiceamount as $ia)
			 {
				 $invam=$ia->amountreceived;
			 }
			  foreach($poamount as $pa)
			 {
				 $poamnt=$pa->amountpaid;
			 }
			 foreach($cashbookamount as $ca)
			 {
				 $cashamnt=$ca->total;
			 }
			 if($bankamount==$cashamnt)
			 {
				 $status='CLOSE'; 
			 }
			 else
			 {
				  $status='OPEN'; 
			 }
			 //print_r($invoiceamount);
			 if($amounttype=='CREDIT')
	          { 
		        $updatecredit=$invam+$cashamnt;
				$isactive=0;
		        $cashbookstatus1= array('cclearbalance'=>$updatecredit,'cstatus'=>$status,'IsActive'=>$isactive);
				//print_r($cashbookstatus1);
				//die();
				
		        $res1 = $this->cashbook_model->cashcreditupdate($cashbookstatus1,$bankid);
			 }
			
			 else
			 {
				 $updatedepit=$poamnt+$cashamnt;
				 $cashbookstatus = array('Clearbalance'=>$updatedepit,'Status'=>$status,'IsActive'=>$isactive);
				// print_r($cashbookstatus);
				 //die();
                 $res = $this->cashbook_model->cashbankupdate($cashbookstatus,$bankid);
				 
			 }
			
			
			//if( $res == 1  ){
				echo "<script>alert('Saved Successfully!');window.location.href='ViewIncomeExpense';</script>";
			//}			
	}
	
	public function bankdata()
	{
		$this->global['pageTitle'] = $this->CompanyName.' :  Bank Statement';
			 if ($this->input->post('btn_submit'))
	{ 
			 $this->global['pageTitle'] = $this->CompanyName.' :  bankstatement';
			 $ab=$this->input->post('financialyear');
			
			 $fa=substr($ab,0,-5);
			 $aa=substr($ab,5,5);

			
			 $fdate = $this->input->post('from_date');
		 $tdate = $this->input->post('to_date');
	}
	         $data['finyear']=$this->cashbook_model->report_finyear();
			 $data['bankreport'] = $this->cashbook_model->bankstatement($fdate,$tdate,$fa,$aa);
				  
			
			$this->loadViews("bankstatement", $this->global, $data,NULL);
		
	}
	public function bankdebitdata()
    {
		$this->global['pageTitle'] = $this->CompanyName.' :  Bank Debit Report';
              if ($this->input->post('btn_submit'))
				  {  
			      $SupplierName = $this->input->post('SupplierName');	  
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
		          //$data['cash']  =  $_GET['sid'];
			      //$data['bankid'] = $_GET['d'];
			      $data['bankdepitpaid'] = $this->cashbook_model->debitbankstatemet($SupplierName,$fdate,$tdate);
				 // print_r($data['bankdepitpaid']);
				  }
				  
			   $data['getsupplier'] = $this->cashbook_model->getsupplier();
			  $this->loadViews("bankdebit",$this->global,$data,NULL);
			//die();
        
    }
	public function bankinvoice()
    {
		$this->global['pageTitle'] = $this->CompanyName.' :  Bank Invoice Report';
          if ($this->input->post('btn_submit'))
				  { 
               $Customer = $this->input->post('Customer');
		       $fdate = $this->input->post('from_date');
	           $tdate = $this->input->post('to_date');			  
			   $data['bankinvoicedata'] = $this->cashbook_model->bankinvoice($Customer,$fdate,$tdate);
			  // $data['bankreceivedamount']= $this->cashbook_model->receivedamount($Customer,$fdate,$tdate);
			   // print_r($data['bankreceivedamount']);
			   //$data['supplier'] =  $this->cashbook_model->getsupplier();
				  }
			 $data['getcustomer'] = $this->cashbook_model->getcustomer();	  
            
            $this->loadViews("bankinvoice", $this->global,$data,NULL);
        
    }
   

 function IGRFilelist()
  {
    $igrno= $this->input->post('igrno');
    $pono =$this->input->post('pono');	
	// $igrsingle = $this->cashbook_model->igrmastersingle($igrno,$pono);
	 $igrmultiple =$this->cashbook_model->igrmastermultiple($igrno,$pono);
	 $data = array_merge($igrmultiple);
	echo json_encode($data);
	

 }
  /*end*/

  	 public function filelist()

 	  {
		  
	 $igrno= $this->input->post('igrno'); 
	 $pono =$this->input->post('pono');	
	 $data = $this->cashbook_model->debitimage($igrno,$pono);

 	 echo json_encode($data);
 	
	   }

     
	public function mappingpo()
    {
		     $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Debited Settlements';
             $SupplierName = $this->input->post('SupplierName');
             $fdate = $this->input->post('from_date');
	         $tdate = $this->input->post('to_date');
			 $bankid= $_GET['d'];
			 $data['clearbalance']= $_GET['clearbalance'];
			 if($data['clearbalance']==0)
			 {
			  echo "<script>alert('No Mapped Amount!')</script>";
             redirect('Bankingstatement','refresh');			  
			 }
			 else
			 {
			 $data['balancetoclear'] =$_GET['balancetoclear'];
             $data['mappingcashbook']=$this->cashbook_model->mappingcashbankid($bankid); 			 
			 $data['mapping'] = $this->cashbook_model->debitpolist($bankid);
             $data['paidcbook'] = $this->cashbook_model->cashbookamount($bankid);
			 $data['paidpoamount'] = $this->cashbook_model->poamonut($bankid);
			 $data['supplier'] =  $this->cashbook_model->getsupplier();
             $this->loadViews("banksettlement", $this->global,$data,NULL);
			 }
        
    }	
	public function mappinginvoice()
    {
         
      
			 //$this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Listing';
			 $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Credited Settlements';
             $SupplierName = $this->input->post('SupplierName');
             $fdate = $this->input->post('from_date');
	         $tdate = $this->input->post('to_date');
			 $bankid= $_GET['d'];
			 $data['clearbalance']=$_GET['cb'];
			 $data['balancetoclear']=$_GET['btc'];
			 $data['mappingiv'] = $this->cashbook_model->creditinvoicelist($bankid);
			  //print_r($data['mappingiv']);
			  $data['invoiceramount'] = $this->cashbook_model->invoiceamonut($bankid);
             $data['mappingcashbook']=$this->cashbook_model->mappingcashcreditbankid($bankid); 			 
			 $data['paidcbook'] = $this->cashbook_model->cashbookamount($bankid);
			$data['supplier'] =  $this->cashbook_model->getsupplier();
			 //redirect('Bankingstatement','refresh');
             $this->loadViews("bankinvoicesettlement", $this->global,$data,NULL);
            
    }	
	public function mappingdebit()
    {
         
      
	 //        $this->global['pageTitle'] = $this->CompanyName.' :  mappingdebit';
	         $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Debited Details';
             $SupplierName = $this->input->post('SupplierName');
             $fdate = $this->input->post('from_date');
	         $tdate = $this->input->post('to_date');
			 $pono= $_GET['sid']; 
			 $data['debitmapping'] = $this->cashbook_model->debitlistpo($pono);
             $this->loadViews("bankposettlement", $this->global,$data,NULL);
        
    }
	public function mappingcredit()
    {
         
      
		 //    $this->global['pageTitle'] = $this->CompanyName.' :  mappingcredit';
		 $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Credited Details ';
             $SupplierName = $this->input->post('SupplierName');
             $fdate = $this->input->post('from_date');
	         $tdate = $this->input->post('to_date');
			 $invno= $_GET['sid']; 
			 $data['creditmapping'] = $this->cashbook_model->creditlistinv($invno);
             $this->loadViews("bankinvoisettle", $this->global,$data,NULL);
        
    }

	 public function receipt()
    {
                $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Store Debited Details';
                $check = $this->input->post('check');
               // echo 'check'.$check;
				$rw = $this->input->post('rw');
				 // echo 'rw'.$rw;
			    $date = $this->input->post('podate');
				$date = date_create($date);
		        $date = date_format($date,'Y-m-d');
				$bankdate =$this->input->post('bankdate');
				$bankdate = date_create($bankdate);//,'Y-m-d');
		        $bankdate = date_format($bankdate,'Y-m-d');
				$pono = $this->input->post('pono');
				$igrno=$this->input->post('igrno');
							
			    $sname = $this->input->post('sname');
				$sid = $this->input->post('sid');
			    $tot = $this->input->post('tot');
			    
                //$now = date('Y-m-d H:i:s');
				$rowcount = $this->input->post('rc');

				$totalpaidamount= $this->input->post('tpv');
				//echo 'totalpaidamount'.$totalpaidamount;

				$bankdebitamountamount= $this->input->post('bda');
	            //echo 'bankdebitamountamount'.$bankdebitamountamount;
				$bankid =$this->input->post('bi'); 
				$alreadypaid = 0;
				//echo $earlypaid;
				$alreadypaid = $this->cashbook_model->getalreadypaid($bankid);
				
			     if(empty($alreadypaid))
				 {
					 $aPay=0;
				 }
				 else
				 {
					 foreach($alreadypaid as $ap)
					 {
						 $aPay = $ap->Clearbalance; 
					 }
				 }
				// echo 'apay',$apay;
				
				if($check == 1)
				{
				$clearedblnce=($totalpaidamount+$aPay); 
				//echo 'clearbalance'.$clearedblnce;

				$balancetocleared=($bankdebitamountamount-$totalpaidamount);
				$check =1;
				}
				//echo 'Balancetocleared'.$balancetocleared;
				//die();
				 if($balancetocleared>0)
				 {
					 $status='OPEN';
				 }
				else
				{
					$status='CLOSE';
				}
				$active=1;
				$bankdata =  array('Clearbalance'=>$clearedblnce,'Balancetocleared'=>$balancetocleared,'Status'=>$status,'IsActive'=>$active);
				
				if($check == 1)
				{
				$res = $this->cashbook_model->bankupdate($bankdata,$bankid);
				}
				$earlypaid = 0;
				//echo $earlypaid;
				$earlypaid = $this->cashbook_model->getearlyamount($igrno);
			     if(empty($earlypaid))
				 {
					 $ePay=0;
				 }
				 else
				 {
					 foreach($earlypaid as $ep)
					 {
						 $ePay = $ep->Amountpaid; 
					 }
				 }
				 //echo 'epay'.$epay;
				 
				$ip=$this->input->post('aa');
			    $balancetopay=($tot-($ip+$ePay));
				
				
				$amtpaid= ($ip+$ePay);
			    $IsActive=1;
				
				
				$igrdata1 =  array('Podate'=>$date,'PONO'=>$pono,'IGRNO'=>$igrno,'Suppliername'=>$sname,'SupplierID'=>$sid,'Totalpoamount'=>$tot,'Amountpaid'=>$ip,'Balancetopay'=>$balancetopay,'mid'=>$bankid,'IsActive'=>$IsActive,'BankDate'=>$bankdate);
				
				$resultn  = $this->cashbook_model->mappingpo($igrdata1);
				//print_r($podata1);
				$igrdata =  array('Podate'=>$date,'PONO'=>$pono,'IGRNO'=>$igrno,'Suppliername'=>$sname,'SupplierID'=>$sid,'Totalpoamount'=>$tot,'Amountpaid'=>$amtpaid,'Balancetopay'=>$balancetopay,'mid'=>$bankid,'IsActive'=>$IsActive,'BankDate'=>$bankdate);
				//die();
			  
				$result3 = $this->cashbook_model->getigrno($igrno);
			   
				
				if(count($result3)<=0)
				{
			   
			     $result  = $this->cashbook_model->bankporeportdata($igrdata);
				
				}
				else
				{
				//echo "update";
				$result3 = $this->cashbook_model->bankporeportupdate($igrdata,$igrno);
				
			    }
				if($rw == $rowcount)
				{
				echo "Saved Successfully!";
				}

				
			  $now = date('Y-m-d H:i:s');
			  if($balancetopay==0)
			  {
				  $igrpaidstatus=AMOUNT_PAIDIGR;
			  }
			  else
			  {
				 $igrpaidstatus=PARTIALLY_PAIDIGR;  
				
			  }
			  $igrmaster=array('Paymentstatus'=>$igrpaidstatus,'StatusUpdatedDate'=>$now);
			  //$podetails=array('Paymentstatus'=>$postatus);
			  //$result1 =  $this->cashbook_model->igrdetailstatus($podetails,$pono);  
			  $result1 =  $this->cashbook_model->igrstatus($igrmaster,$igrno); 
			  $this->loadViews("bankstatement", $this->global,$data, NULL);
    }
	public function invoiceamount1()
    {
				//$this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Listing';
				$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Store Credited Details';
                $check = $this->input->post('check');
				$rw = $this->input->post('rw');
               
                $date = $this->input->post('date');
				$date = date_create($date);//,'Y-m-d');
		        $date = date_format($date,'Y-m-d');
			    $invid = $this->input->post('invid');
			    $cname = $this->input->post('cname');
				 $cid = $this->input->post('cid');
			    $invamount = $this->input->post('invamount');
				$invoicereceived = $this->input->post('ir');
				$rowcount = $this->input->post('rc');
				$totalpaidamount= $this->input->post('tpv');
				$bankcreditamount= $this->input->post('bda');
				$invoicetext=$this->input->post('invrec');
				$bankid = $this->input->post('bi');
				$bankdate =$this->input->post('bankdate');
				$bankdate = date_create($bankdate);//,'Y-m-d');
		        $bankdate = date_format($bankdate,'Y-m-d');
				$alreadyreceived = 0;
				
				//echo $earlypaid;
				$alreadyreceived = $this->cashbook_model->getalreadyreceived($bankid);
			    if(empty($alreadyreceived))
				{
					 $arec=0;
				 }
				 else
				 {
					 foreach($alreadyreceived as $ar)
					 {
						 $arec = $ar->cclearbalance; 
					 }
					 
				 }
				
				if($check == 1)
				{
				//echo $arec;
				if($totalpaidamount>0)
				{
               	 $clearedblnce=($totalpaidamount+$arec);
				}
				else
				{
				$clearedblnce=$totalpaidamount+$arec;	
				}
				 $balancetoreceived =($bankcreditamount-$totalpaidamount);
				 $check =1;
				}
				//echo $balancetocleared;
				//die();
				 if($balancetoreceived>0)
				 {
					 $status='OPEN';
				 }
				else
				{
					$status='CLOSE';
				}
				
				
				$active=1; 
				$bankdata =  array('cclearbalance'=>$clearedblnce,'cbalancetocleared'=>$balancetoreceived,'cstatus'=>$status,'IsActive'=>$active);
				if($check == 1)
				{
				$res = $this->cashbook_model->bankcreditupdate($bankdata,$bankid);
				}
				$earlyreceived = 0;
				//echo $earlypaid;
				$earlyreceived = $this->cashbook_model->getearlyamountcredit($invid);
				//$earlyreceivedmappingiv = $this->cashbook_model->getearlymappingiv($invid);//new change
				
				// if(empty($earlyreceivedmappingiv))
				 // {
					 // $eRec1=0;
				 // }
				  // else
				 // {
					
						// foreach($earlyreceived as $ar)
					 // {
						 // $eRec1 = $ar->amountreceived; 
					 // }
					// $updatenew=($invamount-($eRec1+$invoicetext)); 
				 // }
				// echo $earlyreceivedmappingiv;
				// die();
			     if(empty($earlyreceived))
				 {
					 $eRec=0;
				 }
				 else
				 {
					 foreach($earlyreceived as $ec)
					 {
						 $eRec = $ec->amountreceived; 
					 }
				 }
				//echo $eRec;
				$ip=$this->input->post('ar');
			    $balancetoreceived1=($invamount-($ip+$eRec));
				$amtpaid= ($ip+$eRec);
				
				$updateamount=($totalpaidamount+$eRec);
				$IsActive=1;
				 $invoicedata1 = array('indate'=>$date,'invoiceno'=>$invid,'customername'=>$cname,'customerid'=>$cid,'totinvoiceamount'=>$invamount,'balancetoreceived'=>$balancetoreceived1,'amountreceived'=>$amtpaid,'bankid'=>$bankid,'IsActive'=>$IsActive,'BankDate'=>$bankdate);
				
				 $invoicedata = array('indate'=>$date,'invoiceno'=>$invid,'customername'=>$cname,'customerid'=>$cid,'totinvoiceamount'=>$invamount,'balancetoreceived'=>$balancetoreceived1,'amountreceived'=>$ip,'bankid'=>$bankid,'IsActive'=>$IsActive,'BankDate'=>$bankdate);
				
				// //print_r ($invoicedata);
				// //die();
				 $result3 = $this->cashbook_model->invoiceupdate($invid);
				 $resultn  = $this->cashbook_model->mappinginvoice($invoicedata);
				
				if(count($result3)<=0)
				{
			    //echo "insert";
			     $result  = $this->cashbook_model->invoicedata($invoicedata1);
				
				}
				else
				{
				//echo "update";
				$result3 = $this->cashbook_model->invoiceupdate1($invoicedata1,$invid);
				
			    }
				$now = date('Y-m-d H:i:s');
				if($balancetoreceived1==0)
			   {
			   $status=AMOUNT_RECEIVED;
			   
			  }
			  else
			  {
				 $status=PARTIALLY_RECEIVED;
			  }
			  $invoicemaster= array('receivedstatus'=>$status,'StatusUpdatedDate'=>$now);
			 
			  $result1 = $this->cashbook_model->invoiceamountstatus($invoicemaster,$invid); 
				
				echo "<script>alert('Saved Successfully!');window.location.href='Bankingstatement';</script>";
			
	}
   public function amountpaid()
       {
         
             
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			//$suppliername= $_GET['sid'];
			if ($this->input->post('btn_submit'))
				  {  
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $supplierID= $this->input->post('supplier');
				  $data['supplierid']=$supplierID;
				  $suppliername= $this->input->post('suppliername');
				  $data['suppliername']=$suppliername;
				  $data['fa']=$fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				  $data['suppliername']= $suppliername;
				  $data['bankdebit'] = $this->cashbook_model->debitpolistfilter($supplierID,$fa,$aa,$m,$fdate,$tdate);
				  //print_r($data['bankdebit']);
				  }
				  else
				  {
				
				   $fa=$_GET['fa'];
				   $aa=$_GET['aa'];
				   $m=$_GET['m'];
				   $fdate=$_GET['fdate'];
				   $tdate=$_GET['tdate'];
				   $data['fa']=$fa;
				   $data['aa']=$aa;
				   $data['m']=$m;
				   $data['fdate']=$fdate;
				   $data['tdate']=$tdate;
				   $supplierid= $_GET['sid'];
                   $data['supplierid']= $supplierid;
				   $suppliername= $_GET['sn'];
				   $data['suppliername']=$suppliername;
                   $data['bankdebit'] = $this->cashbook_model->paided($supplierid,$fa,$aa,$m,$fdate,$tdate);
				  }
				  $data['finyear']=$this->cashbook_model->report_amountpaid();
             $this->loadViews("bankamountpaid", $this->global,$data, NULL);

      }	
	  public function amountpaidcashbook()
       {
         
             
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			//$suppliername= $_GET['sid'];
			if ($this->input->post('btn_submit'))
				  {
                  				
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $accountcode= $this->input->post('accountcode');
                  $data['accountcode']= $accountcode;
				  $accountname= $this->input->post('accountname');
				  $data['accountname']=$accountname;
				  $data['fa']=$fa;
				   $data['aa']=$aa;
				   $data['m']=$m;
				   $data['fdate']=$fdate;
				   $data['tdate']=$tdate;
				  $data['bankmappingcash'] = $this->cashbook_model->mappingcashfilter($accountcode,$fa,$aa,$m,$fdate,$tdate);
				  
				  }
				  else
				  {
				  $fa=$_GET['fa'];
				  $aa=$_GET['aa'];
				  $m=$_GET['m'];
				  $fdate=$_GET['fdate'];
				  $tdate=$_GET['tdate'];	
				  $accountcode= $_GET['ac'];
                 $data['accountcode']= $accountcode;
				 $accountname= $_GET['an'];
				 $data['accountname']=$accountname;
				 $data['fa']=$fa;
				   $data['aa']=$aa;
				   $data['m']=$m;
				   $data['fdate']=$fdate;
				   $data['tdate']=$tdate;
                 $data['bankmappingcash'] = $this->cashbook_model->mappingcash($accountcode,$fa,$aa,$m,$fdate,$tdate);
				  }
				  $data['finyear']=$this->cashbook_model->report_cashbook();
                $this->loadViews("banksettlementcash", $this->global,$data, NULL);

      }	
	  public function amountreceivedcashbook()
       {
         
             
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			//$suppliername= $_GET['sid'];
			if ($this->input->post('btn_submit'))
				  {
                  				
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $accountcode= $this->input->post('accountcode');
                  $data['accountcode']= $accountcode;
				  $accountname= $this->input->post('accountname');
				  $data['accountname']=$accountname;
				   $data['fa']=$fa;
				   $data['aa']=$aa;
				   $data['m']=$m;
				   $data['fdate']=$fdate;
				   $data['tdate']=$tdate;
				  $data['bankmappingcashreceived'] = $this->cashbook_model->mappingcashreceivedfilter($accountcode,$fa,$aa,$m,$fdate,$tdate);
				  
				  }
				  else
				  {
				$fa=$_GET['fa'];
				$aa=$_GET['aa'];
				$m=$_GET['m'];
				$fdate=$_GET['fdate'];
				$tdate=$_GET['tdate'];	
				 $accountcode= $_GET['ac'];
                 $data['accountcode']= $accountcode;
				 $accountname= $_GET['an'];
				 $data['accountname']=$accountname;
				  $data['fa']=$fa;
				   $data['aa']=$aa;
				   $data['m']=$m;
				   $data['fdate']=$fdate;
				   $data['tdate']=$tdate;
                 $data['bankmappingcashreceived'] = $this->cashbook_model->mappingcashreceived($accountcode,$fa,$aa,$m,$fdate,$tdate);
				  }
				  $data['finyear']=$this->cashbook_model->report_cashbook();
                $this->loadViews("banksettlementcredit", $this->global,$data, NULL);

      }	
	 
	   public function amountreceivednew()
       {
         
            //$this->global['pageTitle'] = $this->CompanyName.' :  amountpaid';
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			if ($this->input->post('btn_submit'))
				  {  
			      $SupplierName = $this->input->post('SupplierName');
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
				  $data['bankreceivable'] = $this->cashbook_model->creditinvoicewisefilter($SupplierName,$fdate,$tdate);
				  }
				  else
				  {
			     $suppliername= $_GET['sid'];		 
                 $data['bankreceivable'] = $this->cashbook_model->creditinvoicesupplierwise($suppliername);
				  }
				  
			 $data['supplier'] = $this->cashbook_model->getsupplier();
			// $this->loadViews("bankpaidsupp", $this->global,$data, NULL);
             $this->loadViews("bankamountreceived", $this->global,$data, NULL);

      }	
	  public function amountpaidsupplier()
       {
         
            //$this->global['pageTitle'] = $this->CompanyName.' :  amountpaid';
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			if ($this->input->post('btn_submit'))
				  {  
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $data['ab']=$ab;
				  $data['fa']=$fa;
				  $data['aa']=$aa;
				  $data['m']= $m;
				  $data['fdate']= $fdate;
				  $data['tdate']=$tdate;
				  $data['bankdebitsupp'] = $this->cashbook_model->amountpaidsupplierwisefilter($fa,$aa,$m,$fdate,$tdate);
				  $data['amountpaidcashbook']=$this->cashbook_model->amountpaidcashbookfilter($fa,$aa,$m,$fdate,$tdate);
				  }
				  // else
				  // {
					 
              // $data['bankdebitsupp'] = $this->cashbook_model->amountpaidsupplierwise();
			 
			  // $data['amountpaidcashbook']=$this->cashbook_model->amountpaidcashbook();
			  
				  // }
			$data['finyear']=$this->cashbook_model->report_amountpaid();		  
			 $data['supplier'] = $this->cashbook_model->getsupplier();
			 $this->loadViews("bankpaidsupp", $this->global,$data, NULL);
             //$this->loadViews("bankamountpaid", $this->global,$data, NULL);

      }
   // function supplierledger()
      // {
		  	// $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			// //$suppliername= $_GET['sid'];
			// if ($this->input->post('btn_submit'))
				  // {  
			      // $ab=$this->input->post('financialyear');
			      // $fa=substr($ab,0,-5);
				  // $aa=substr($ab,5,5);
				  // $m=$this->input->post('month');
		          // $fdate = $this->input->post('from_date');
				  // $tdate = $this->input->post('to_date');
				  // $supplierID= $this->input->post('supplier');
				  // $data['supplierid']=$supplierID;
				  // $suppliername= $this->input->post('suppliername');
				  // $data['suppliername']=$suppliername;
				  // $data['fa']=$fa;
				  // $data['aa']=$aa;
				  // $data['m']=$m;
				  // $data['fdate']=$fdate;
				  // $data['tdate']=$tdate;
				  // $data['suppliername']= $suppliername;
				  // $data['bankdebit'] = $this->cashbook_model->debitpolistfilter($supplierID,$fa,$aa,$m,$fdate,$tdate);
				  // //print_r($data['bankdebit']);
				  // }
				  // else
				  // {
				
				   // $fa=$_GET['fa'];
				   // $aa=$_GET['aa'];
				   // $m=$_GET['m'];
				   // $fdate=$_GET['fdate'];
				   // $tdate=$_GET['tdate'];
				   // $data['fa']=$fa;
				   // $data['aa']=$aa;
				   // $data['m']=$m;
				   // $data['fdate']=$fdate;
				   // $data['tdate']=$tdate;
				   // $supplierid= $_GET['sid'];
                   // $data['supplierid']= $supplierid;
				   // $suppliername= $_GET['sn'];
				   // $data['suppliername']=$suppliername;
                   // $data['bankdebit'] = $this->cashbook_model->paided($supplierid,$fa,$aa,$m,$fdate,$tdate);
				  // }
				  // $data['finyear']=$this->cashbook_model->report_amountpaid();
                  // $this->loadViews("banksupplierledger", $this->global,$data, NULL);

      // }	
			 
        function supplierledger()
      {
		  	$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			//$suppliername= $_GET['sid'];
			if ($this->input->post('btn_submit'))
				  {  
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');			  
				  $supplierID= $this->input->post('supplier');
				  $data['supplierid']=$supplierID;
				  $suppliername= $this->input->post('SupplierName');	  
				  $data['suppliername']=$suppliername;
				  $data['fa']=$fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				  $data['suppliername']= $suppliername;
				  $data['supplierledger'] = $this->cashbook_model->supplierledger($suppliername,$fdate,$tdate,$fa,$aa,$m);
				 $data['openingbalancesupplier'] = $this->cashbook_model->openingbalancesupplier($customer,$fdate,$tdate,$fa,$aa,$m);
				  //print_r($data['supplierledger']);
				  }
				  
				  $data['finyear']=$this->cashbook_model->report_amountpaid();
				  $data['getsupplier'] = $this->cashbook_model->getsupplier();
                  $this->loadViews("banksupplierledger", $this->global,$data, NULL);

      }	
	  function customerledger()
      {
		  	$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Amount Payment Details';
			//$suppliername= $_GET['sid'];
			if ($this->input->post('btn_submit'))
				  {  
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');		  
				  $supplierID= $this->input->post('supplier');
				  $data['supplierid']=$supplierID;
				  $customer = $this->input->post('Customer');
				  $data['suppliername']=$suppliername;
				  $data['fa']=$fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				  $data['customername']= $Customer;
				  $data['customerledger'] = $this->cashbook_model->customerledger($customer,$fdate,$tdate,$fa,$aa,$m);
				  $data['openingbalance'] = $this->cashbook_model->openingbalance($customer,$fdate,$tdate,$fa,$aa,$m);
				   
				  }
				  
				  $data['finyear']=$this->cashbook_model->report_amountpaid();
				  $data['getcustomer'] = $this->cashbook_model->getcustomer();
                  $this->loadViews("bankcustomerledger", $this->global,$data, NULL);

      }	
			      
	
      	  
	  public function amountunpaid()
       {
         
           $this->global['pageTitle'] = $this->CompanyName.' :  Bank Debit Report';
		    if ($this->input->post('btn_submit'))
				{
			      $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $data['ab']= $ab;
				  $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				 $data['bankunpaid'] = $this->cashbook_model->suppliertotalfilter($fa,$aa,$m,$fdate,$tdate); 
				}
				
			  $data['finyear']=$this->cashbook_model->report_finyearunpaid();	 
			  $data['getsupplier'] = $this->cashbook_model->getsupplier();
			  $this->loadViews("bankunpaidsupp",$this->global,$data,NULL);
	

      }	
	  public function supplierwise()
	  {
		   $this->global['pageTitle'] = $this->CompanyName.' :  Bank Debit Report';
		        
		        //$sd=$this->input->post('supplierid');
		        if ($this->input->post('btn_submit'))
				{
				  
                  $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  
				  $aa=substr($ab,5,5);			  
				  $m=$this->input->post('month');
		          $fdate = $this->input->post('from_date');
				  $tdate = $this->input->post('to_date');
				  $sd= $this->input->post('supplier');
				  $data['suppliername']=$sd; 
				  $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				   
                  $data['bankunpaid'] = $this->cashbook_model->amountunpaidfilter($sd,$fa,$aa,$m,$fdate,$tdate);				  
				}
				else
				{
			       $supplierid1  = $_GET['sid'];
				   
				   $fa=$_GET['fa'];
				   $aa=$_GET['aa'];
				   $m=$_GET['m'];
				   $fdate=$_GET['fdate'];
				   $tdate=$_GET['tdate'];
				   $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				   
				  $data['suppliername']=$supplierid1; 
				  
			      $data['bankunpaid'] = $this->cashbook_model->amountunpaid($supplierid1,$fa,$aa,$m,$fdate,$tdate);
				}
				   $data['finyear']=$this->cashbook_model->report_finyearunpaid();	
			  // $data['getsupplier'] = $this->cashbook_model->getsupplier();
			   $this->loadViews("bankamountunpaid",$this->global,$data,NULL);
			//die();

		  
	  }
	public function amountreceived()
    {
         
      
           // $this->load->model('cashbook_model');
			//$this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Listing';
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Received Amount Details';
			 if ($this->input->post('btn_submit'))
				  {

                  $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');			  
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
				  $clientname = $this->input->post('customer');
				  $data['clientname']=$clientname;
				  $clientid = $this->input->post('clientid');
				  $data['clientid']=$clientid;
				  $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
			     $data['amountreceived'] = $this->cashbook_model->creditinvoicelistfilter($clientid,$fdate,$tdate,$fa,$aa,$m);
				  }
				  else
				  {
					   
				   $fa=$_GET['fa'];
				   $aa=$_GET['aa'];
				   $m=$_GET['m'];
				   $fdate=$_GET['fdate'];
				   $tdate=$_GET['tdate'];
				   $clientid= $_GET['sid'];
				  $data['clientid']=$clientid;	
                 $cname= $_GET['cname'];				 
                 $data['clientname']=$cname;
                  $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				   				 
                 $data['amountreceived'] = $this->cashbook_model->received($clientid,$fdate,$tdate,$fa,$aa,$m);
				  }
			$data['finyear']=$this->cashbook_model->report_finyearamountreceived();		  
            $data['getcustomer'] = $this->cashbook_model->getcustomer();			
            $this->loadViews("bankamountreceived", $this->global,$data, NULL);
        
    }
	      public function bankreceivedsupp()
	      {
		 $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Received Amount Details supplierwise';
			 if ($this->input->post('btn_submit'))
				  {

                  $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');
			  
			      //$Customer = $this->input->post('CustomerName');
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
				  $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
			     
				 $data['amountreceivedsupplier'] = $this->cashbook_model->creditinvoicewisefilter($fdate,$tdate,$fa,$aa,$m);
				 
				 $data['amountpaidcashbook']=$this->cashbook_model->amountreceivedcashbookfilter($fa,$aa,$m,$fdate,$tdate);
				  }
				  else
				  {
                 $data['amountreceivedsupplier'] = $this->cashbook_model->creditinvoicesupplierwise();
				  $data['amountpaidcashbook']=$this->cashbook_model->amountreceivedcashbook();
				  }
			    $data['finyear']=$this->cashbook_model->report_finyearamountreceived();		  
                $data['getcustomer'] = $this->cashbook_model->getcustomer();			
                $this->loadViews("bankreceivedsupp", $this->global,$data, NULL);
		
	}
	public function bankunreceivedsupp()
	{
		$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Received Amount Details supplierwise';
			 if ($this->input->post('btn_submit'))
				  {

                  $ab=$this->input->post('financialyear');
				 
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');			  
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
			      $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				 $data['amountunreceivedsupplier'] = $this->cashbook_model->uncreditinvoicewisefilter($fdate,$tdate,$fa,$aa,$m);
				  }
				  else
				  {
				
                 $data['amountunreceivedsupplier'] = $this->cashbook_model->unreceivedsupplier();
				  }
			$data['finyear']=$this->cashbook_model->report_finyearamountunreceived();				
            $data['getcustomer'] = $this->cashbook_model->getcustomer();			
            $this->loadViews("bankunreceivedsupp", $this->global,$data, NULL);
		
	}
    public function amountunreceived()
    {
         
      
           // $this->load->model('cashbook_model');
			//$this->global['pageTitle'] = $this->CompanyName.' :  Cashbook Listing';
			$this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Received Amount Details';
			 if ($this->input->post('btn_submit'))
				  {  
			       $ab=$this->input->post('financialyear');
			      $fa=substr($ab,0,-5);
				  $aa=substr($ab,5,5);
				  $m=$this->input->post('month');			  
		          $fdate = $this->input->post('from_date');
	              $tdate = $this->input->post('to_date');
				  $client =$this->input->post('client');
				  $data['client']=$client;
				   $data['fa']= $fa;
				  $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
				 $data['amountunreceived'] = $this->cashbook_model->uncreditinvoicelistfilter($client,$fdate,$tdate,$fa,$aa,$m);
				  }
				  else
				  {
			       $fa=$_GET['fa'];
				   $aa=$_GET['aa'];
				   $m=$_GET['m'];
				   $fdate=$_GET['fdate'];
				   $tdate=$_GET['tdate'];		  
                   $clientname=$_GET['sid'];
			       $data['client']=$clientname;
			       $data['fa']= $fa;
				   $data['aa']=$aa;
				  $data['m']=$m;
				  $data['fdate']=$fdate;
				  $data['tdate']=$tdate;
            $data['amountunreceived'] = $this->cashbook_model->unreceived($clientname,$fdate,$tdate,$fa,$aa,$m);
				  }
		    $data['finyear']=$this->cashbook_model->report_finyearamountunreceived();	
            $data['getcustomer'] = $this->cashbook_model->getcustomer();			
            $this->loadViews("bankamountunreceived", $this->global,$data, NULL);
        
    }	
	public function cashbanking()
    {
		    $this->global['pageTitle'] =$this->CompanyName.': bankcashbook';
		    $data['dropdownvalues'] = $this->cashbook_model->getAccounTypes();
			//$data['cashbanking'] = $this->cashbook_model->newcashbook();
			$data['getsupplier'] = $this->cashbook_model->getsupplier();
		  
            $this->loadViews("bankcashnew", $this->global,$data,NULL);
        
    }
	public function Deletemappingporeport()
	{
	
	 $totalamount =$this->input->post('Totalpoamount');
	 $Amount = $this->input->post('paidamount');
	
	 $id=$this->input->post('mappingid');
	 
	 $igrno = $this->input->post('igrno');
	 $pono = $this->input->post('pono');
	 $Bankid =  $this->input->post('bankid');
	 $balancetoclear=$this->input->post('balancetobankingclear');
	 $clearedbalance=$this->input->post('clearbalance');
	 $updateamount=$clearedbalance-$Amount;
	 $updatebalancetoclear=$Amount+$balancetoclear;
	 $data['$bankmappingamount'] = $this->cashbook_model->gettotalbankmappingpo($id);
	 $amountpaid=$data['$bankmappingamount'][0]->Amountpaid;
	 $data['$bankmappingamountcount'] = $this->cashbook_model->gettotalbankmappingpocount($igrno);
	 $count= $data['$bankmappingamountcount'][0]->countAmountpaid;
	  //$data['$totallineitemamount']=$this->cashbook_model->gettotallineitem($igrno);
	 
	   if($count==1)
	  {
		$PaymentStatus=NO_PAIDIGR;  
	  }
	  else
	  {
		$PaymentStatus=PARTIALLY_PAIDIGR;  
	  }
	  
	 
	
	 $result= $this->cashbook_model->IGRStatusUpdate($igrno,$PaymentStatus);
	 $Status=OPEN;
	 $result1= $this->cashbook_model->deletemapping($Bankid,$updateamount,$updatebalancetoclear,$Status);
	 //for update mapping amount in t_bankmappingpo table//
	 $balancetopay=$this->input->post('balancetopay');
	 $totalbalancetopay=$Amount+$balancetopay;
	 $updatebankpoamount=$totalamount-$totalbalancetopay;
	 //$updateamount=0;
	 $IsActive=0;
	 $result2= $this->cashbook_model->deleteBankmappingpo($id,$IsActive);
	 $data['$poreportamount'] = $this->cashbook_model->gettotalbankpoamount($igrno);
	  $amountpaidpo= $data['$poreportamount'][0]->Amountpaid;
	  $balancetopaypo= $data['$poreportamount'][0]->Balancetopay;
	  $amountpaidupdate=($amountpaidpo) - ($Amount);
	  $balancetopayupdate=($balancetopaypo) + ($Amount);
	  if($amountpaidupdate==0)
	  {
		$IsAct=0; 
	  }
	  else
	  {
		$IsAct=1;    
	  }
	 $result3= $this->cashbook_model->updateBankporeport($igrno,$balancetopayupdate,$amountpaidupdate,$IsAct);
     $this->loadViews("bankstatement", $this->global,$data, NULL);	 
	}
public function Deletemappingpo()
	{
     $totalamount = $_GET['totalpoamount'];//totalpoamount
	 $Bankid =  $_GET['bankid'];
	 $Amount = $_GET['amount'];//paid amount
	 $igrno = $_GET['igrno'];
	 $balancetoclear=$_GET['balancetoclear'];
	 //for T_Bankreport IsActive//
	 $bankdebit=$_GET['debit'];
	 $mapped= $Amount+$balancetoclear;
	 
     
	 $id=$_GET['id'];
	 $bankamount=$_GET['bankamount'];
	 $updateamount=$bankamount-$Amount;
	 $updatebalancetoclear=$Amount+$balancetoclear;
	 $data['$bankmappingamount'] = $this->cashbook_model->gettotalbankmappingpo($id);
	 $amountpaid=$data['$bankmappingamount'][0]->Amountpaid;
	 $data['$bankmappingamountcount'] = $this->cashbook_model->gettotalbankmappingpocount($igrno);
	 $count= $data['$bankmappingamountcount'][0]->countAmountpaid;
	
	 
	  if($count==1)
	  {
		$PaymentStatus=NO_PAIDIGR;  
	  }
	  else
	  {
		$PaymentStatus=PARTIALLY_PAIDIGR;  
	  }
	  
	
	 $result= $this->cashbook_model->IGRStatusUpdate($igrno,$PaymentStatus);
	  $Status=OPEN;
	 $result1= $this->cashbook_model->deletemapping($Bankid,$updateamount,$updatebalancetoclear,$Status);
	 //for update mapping amount in t_bankreport table//
	 $balancetopay=$_GET['balancetopay'];//balancetopay
	 $totalbalancetopay=$Amount + $balancetopay;
	 $IsActive=0;
	 $updatebankpoamount=$totalamount-$totalbalancetopay;
	 $result2= $this->cashbook_model->deleteBankmappingpo($id,$IsActive);
	//$result3= $this->cashbook_model->updatemappingamount($igrno,$amountpaid);
	 $data['$poreportamount'] = $this->cashbook_model->gettotalbankpoamount($igrno);
	  $amountpaidpo= $data['$poreportamount'][0]->Amountpaid;
	  $balancetopay= $data['$poreportamount'][0]->Balancetopay;
	  $amountpaidupdate=$amountpaidpo-$Amount;
	  $balancetopayupdate=$balancetopay+$Amount;
	  
	  //die();
	  if($amountpaidupdate==0)
	  {
		$IsAct=0;  
	  }
	  else
	  {
		$IsAct=1;    
	  }
	  
	 $result3= $this->cashbook_model->updateBankporeport($igrno,$balancetopayupdate,$amountpaidupdate,$IsAct);
	 
	if(count($result3)>0)
		 {
		 redirect('Bankingstatement','refresh');
		 }
	
	}
	public function deletemappingiv()
	{
	
    $this->global['pageTitle'] = $this->CompanyName.' :  Bank Report - Delete Mapping Invoice';
	$credit= $this->input->post('credit');
	$invoiceno = $this->input->post('invoiceno');
	$bankid = $this->input->post('bankid');
	$mappingid=$this->input->post('mappingid');
	
	$amountreceived = $this->input->post('amountreceived');
	$bankingclear = $this->input->post('bankingclear');
	$bankingbalclear = $this->input->post('bankingbalclear');
	$totinvoiceamount = $this->input->post('totinvoiceamount');
	$balancetoreceived = $this->input->post('balancetoreceived');
	
	$updatebalancetoclear=$amountreceived+$bankingbalclear;
	
	if($amountreceived<0)
	{
	$updateclearbalance=$bankingclear-($amountreceived);//450-(-250)
	}
	else
	{
	$updateclearbalance=$bankingclear-$amountreceived;//450-650
	}
	
	
	
	//update Isactive field in T_Bankreport //////
	$mapped=$balancetoreceived+$amountreceived;
	// if($credit==$mapped)
	// {
		$CStatus=OPEN;
	// }
	// else
	// {
		// $active=1;
	// }
	$bankstatement=array('cbalancetocleared'=>$updatebalancetoclear,'cclearbalance'=>$updateclearbalance,'cstatus'=>$CStatus);
	$result1= $this->cashbook_model->updatebankreportiv($bankid,$bankstatement);
	
		
	
	 
	 $data['$invoicereportamount'] = $this->cashbook_model->gettotalbankreceivedamount($invoiceno);
	  $amountreceivedinvoice= $data['$invoicereportamount'][0]->amountreceived;
	  $$balancetoreceived= $data['$invoicereportamount'][0]->balancetoreceived;
	  $amountreceivedupdate=$amountreceivedinvoice-$amountreceived;
	  $balancetoreceivedupdate=$balancetoreceived+$amountreceived;
	 if($amountreceivedupdate==0)
	  {
		$IsAct=0;  
	  }
	  else
	  {
		$IsAct=1;    
	  }
	
	// $updatebalancetoreceived=$balancetoreceived+$amountreceived;
	// $updateamountreceived=$totinvoiceamount-$updatebalancetoreceived;
	$result3= $this->cashbook_model->updatebankinvoicereport($invoiceno,$balancetoreceivedupdate,$amountreceivedupdate,$IsAct);
	$IsActive=0;
	if(count($result3)>0)
	{
	 $data['$bankreceivedamountcount'] = $this->cashbook_model->gettotalbankmappinginvoicecount($invoiceno);
	 $counting= $data['$bankreceivedamountcount'][0]->countamountreceived;
	  if($counting==1)
	  {
		$receivedstatus=NO_RECEIVED;  
	  }
	  else
	  {
		$receivedstatus=PARTIALLY_RECEIVED;  
	  }
	 $result1=$this->cashbook_model->UpdateIpinvoiceStatus($invoiceno,$receivedstatus);
	 $result2= $this->cashbook_model->deletemappinginvoice($mappingid,$IsActive);
	 // if(count($result2)>0)
	// {
	 // $result4= $this->cashbook_model->updatemappinginvoice($invoiceno,$amountreceived);
	// }
	}
	 $this->loadViews("bankstatement", $this->global,$data, NULL);
    
	// if(count($result2)>0)
	// {
		 // redirect('Bankingstatement','refresh');
	// }
		 
	}
	public function Deletemappingcashbook()
	{
		 $bankamount=$_GET['bankamount'];
		 $Bankid =  $_GET['bankid'];
		 $Amount = $_GET['amount'];
		 $accountname = $_GET['accountname'];
		 $id=$_GET['id'];
		 $IsActive=0;
		 $balancetoclear=$_GET['balancetoclear'];
		 $clearbalance =$bankamount-$Amount;
		 $updatebankamount= $Amount+$balancetoclear;
		// $data['$accountcode'] = $this->cashbook_model->getaccountcode($accountname);
		// $accountcode=$data['$accountcode'][0]->code;
		 $result=$this->cashbook_model->deletecashbookdata($Bankid,$updatebankamount,$clearbalance,$IsActive);
		 $result1=$this->cashbook_model->StatusUpadateCashbook($id,$IsActive);
		  if(count($result1)>0)
		 {
		 redirect('Bankingstatement','refresh');
		 }
		
	}	
	public function Deletemappingcashbookcredit()
	{
		 $bankamount=$_GET['bankamount'];
		 $Bankid =  $_GET['bankid'];
		 $Amount = $_GET['amount'];
		 $accountname = $_GET['accountname'];
		 $id=$_GET['id'];
		 $IsActive=0;
		 $balancetoclear=$_GET['balancetoclear'];
		 $clearbalance =$_GET['clearbalance'];
		 $updateclearbalance=$clearbalance-$Amount;
		 $updatebalancetoclear=$balancetoclear+$Amount;
		// $data['$accountcode'] = $this->cashbook_model->getaccountcode($accountname);
		// $accountcode=$data['$accountcode'][0]->code;
		 $result=$this->cashbook_model->deletecashbookdatacredit($Bankid,$updateclearbalance,$updatebalancetoclear);
		 $result1=$this->cashbook_model->StatusUpadateCashbook($id,$IsActive);
		 if(count($result1)>0)
		 {
		// $this->loadViews("Bankingstatement", $this->global,$result1, NULL);
		 // echo "<script>alert('Deleted Successfully!');window.location.href='Bankingstatement';</script>";
		 redirect('Bankingstatement','refresh');
		 }
	}

	
	public function convertNumber($amt){
			//echo $amt;die();
$ShowPaise='0';
$totalAmt=explode(".",$amt);

$number = $totalAmt[0];
   $no = $number;
			
if(!empty($totalAmt[1]) && $totalAmt[1]!=0){
$point = $totalAmt[1];
	$ShowPaise='1';
}
   else{
$point=0;
	   $ShowPaise='0';
}


   $hundred = null;
   $digits_1 = strlen($no);

   $i = 0;
   $str = array();
   $words = array('0' => '', '1' => 'One', '2' => 'Two',
    '3' => 'three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
    '7' => 'seven', '8' => 'eight', '9' => 'nine',
    '10' => 'ten', '11' => 'eleven', '12' => 'twelve',
    '13' => 'thirteen', '14' => 'fourteen',
    '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen',
    '18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty',
    '30' => 'thirty', '40' => 'forty', '50' => 'fifty',
    '60' => 'sixty', '70' => 'seventy',
    '80' => 'eighty', '90' => 'ninety','06'=>'Zero Six','01'=>'Zero One','02'=>'Zero Two'
    ,'03'=>'Zero Three','04'=>'Zero Four','05'=>'Zero Five','07'=>'Zero Seven','08'=>'Zero Eight','09'=>'Zero Nine');
	 $words1 = array('2' => 'twenty',
    '3' => 'thirty', '4' => 'fourty',
    '5' => 'fifty', '6' => 'sixty', '7' => 'seventy',
    '8' => 'eighty', '9' =>'ninty');
	 $words12 = array('11' => 'eleven',
    '12' => 'twelve', '13' => 'thirteen', '14' => 'fourteen',
    '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen',
    '18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty',);
   $digits = array('', 'hundred', 'thousand', 'lakh', 'crore');
   while ($i < $digits_1) {
     $divider = ($i == 2) ? 10 : 100;
     $number = floor($no % $divider);
     $no = floor($no / $divider);
     $i += ($divider == 10) ? 1 : 2;
     if ($number) {
        $plural = (($counter = count($str)) && $number > 1) ? 's' : null;
		//print_r($plural);
        $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
		//print_r($hundred);
        $str [] = ($number < 21) ? $words[$number] .
            " " . $digits[$counter] . $plural . " " . $hundred
            :
            $words[floor($number / 10) * 10]
            . " " . $words[$number % 10] . " "
            . $digits[$counter] . $plural . " " . $hundred;
     } else $str[] = null;
  }
  $str = array_reverse($str);
  $result = implode('', $str);
  if($point>=1 && $point<=10)
  {
	 $points = ($point) ?
          " " . $words[$point] : " ";  
  }
  else if($point>=11 && $point<=20)
  {
         $points = ($point) ?
          " " . $words12[$point] : " ";
  }
  else
  {
	$points = ($point) ?
          " " . $words1[$point / 10] . " " . 
          $words[$point = $point % 10] : '';  
  }

if($ShowPaise=='0'){

$amountInWords = "Rupees " . $result." Only";
}
else{

$amountInWords = "Rupees " . $result ." Paise ". $points." Only";
}
  

  return $amountInWords;
  }

}
?>