Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Invoice_old.php

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

class Invoice extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Invoice_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Quotation_model'));
    $this->load->model(array('Lead_model'));
    $this->load->model(array('Payment_model'));
    $this->load->model(array('Customer_model'));
    $this->load->model(array('Warehousestocktransfer_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->model(array('Product_model','Paymentterm_model','Deliveryterm_model','Purchase_model'));
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Invoice');
  }

public function barcode_print($id)
  {
    $data['inv_barcode'] = $this->Invoice_model->get_invoice_barcode_by_id($id);
    $this->load->view('invoice/barcode_printview',$data);
  }

public function index()
  {
    $data['application'] = $this->Order_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    $data['location'] = $this->Invoice_model->get_active_location();
    $data['product_category'] = $this->Invoice_model->get_product_category();
    $data['product_list'] = $this->Invoice_model->get_active_products();

$data['order_list'] = $this->Invoice_model->get_dc_order_list();
    if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      /*$applichange = $this->input->post('filterappli');
      $refchange = $this->input->post('filterref');
      if($applichange!='')
        $app = 'AND o.application_id='.$applichange;
      else
        $app = '';

if($refchange!='')
        $ref = 'AND o.reference_id='.$refchange;
      else
        $ref = '';
      $data['applichange'] = $applichange;
      $data['refchange'] = $refchange;
      $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o WHERE o.order_id = i.order_id $app $ref ORDER BY i.invoice_id DESC")->result_array();*/

$this->session->set_userdata('compchange', $this->input->post('filtercomp')); $compchange = $this->input->post('filtercomp');
      $this->session->set_userdata('unitchange', $this->input->post('filterunit')); $unitchange = $this->input->post('filterunit');
      $this->session->set_userdata('pcatchange', $this->input->post('filterpcat')); $pcatchange = $this->input->post('filterpcat');
      $this->session->set_userdata('prodchange', $this->input->post('filterprod')); $prodchange = $this->input->post('filterprod');
      if($compchange!='')
      {
        $comp = 'AND o.location_id='.$compchange;
        $comp1 = 'AND i.location_id='.$compchange;
      }
      else
      {
        $comp = '';
        $comp1='';
      }
      if($unitchange!='')
      {
        $unit = 'AND o.prod_unit="'.$unitchange.'"';
        $unit1 = 'AND i.prod_unit="'.$unitchange.'"';
      }
      else
      {
        $unit = '';
        $unit1='';
      }
      if($pcatchange!='')
      {
        $pcat = 'AND p.category_id="'.$pcatchange.'"';
      }
      else
      {
        $pcat = '';
      }
      if($prodchange!='')
      {
        $prod = 'AND ip.product_id="'.$prodchange.'"';
      }
      else
      {
        $prod = '';
      }

$data['compchange'] = $compchange;
      $data['unitchange'] = $unitchange;
      $data['pcatchange'] = $pcatchange;
      $data['prodchange'] = $prodchange;
      //$data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o WHERE o.order_id = i.order_id $comp $unit UNION SELECT * FROM invoice i WHERE i.order_id=0 $comp1 $unit1 ORDER BY invoice_id DESC")->result_array();

$this->session->set_userdata('btn', $this->input->post('goButton')); $btn = $this->input->post('goButton');
      $this->session->set_userdata('schange', $this->input->post('searchChange')); $schange = $this->input->post('searchChange');
      $this->session->set_userdata('dtrange', $this->input->post('dtrange')); $dtrange = $this->input->post('dtrange');

if($schange == '')
        $schange='';

if($schange == '')
      {
        /*$fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');*/
        
        if(isset($_SESSION['fin2cstart']))
        {
          if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
          {
            $fdate = $_SESSION['fin2cstart'].'-04-01';
            $tdate = $_SESSION['fin2cend'].'-03-31'; 
          }
          else
          {
            $fdate = date('Y-m-d', strtotime('-7 days'));
            $tdate = date('Y-m-d');
          }
        }
        else
        {
          $fdate = date('Y-m-d', strtotime('-7 days'));
          $tdate = date('Y-m-d');
        }

$data['drnge'] = '';
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp $unit $pcat $prod UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp1 $unit1 $pcat $prod UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp1 $unit1 ORDER BY invoice_id DESC")->result_array();
 }
 elseif($schange == 'today')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() ORDER BY invoice_id DESC")->result_array();
 }
 else if($schange == 'thisweek')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY invoice_id DESC")->result_array();
 } 
 else if($schange == 'thismonth')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY invoice_id DESC")->result_array();
 }
 else if($schange == 'thisyear')
 {
 $finstart = $_SESSION['finstart'];
 $finend = $_SESSION['finend'];
 /*$data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY invoice_id DESC")->result_array();*/
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY invoice_id DESC")->result_array();
 }
 else
 {
 $data['drnge'] = $dtrange;
 $dr = explode(' - ', $dtrange);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
 $tdate = $td[2].'-'.$td[0].'-'.$td[1];
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY invoice_id DESC")->result_array();
 }
 //echo $schange;exit;
 $data['purchasesearch'] = $schange;
 $data['drnge'] = $dtrange;

if($this->input->post('top_fin_year')!='')
      {
        $topfin = explode('-', $this->input->post('top_fin_year'));
        $_SESSION['fin2cstart'] = $topfin[0];
        $_SESSION['fin2cend'] = $topfin[1];

if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
 {
 $fdate = $_SESSION['fin2cstart'].'-04-01';
 $tdate = $_SESSION['fin2cend'].'-03-31'; 
 }
 else
 {
 $fdate = date('Y-m-d', strtotime('-7 days'));
 $tdate = date('Y-m-d');
 }
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY invoice_id DESC")->result_array();
 }
 }

else if(isset($_SESSION['compchange']) && ($_SESSION['compchange']!='' || $_SESSION['unitchange']!='' || $_SESSION['pcatchange']!='' || $_SESSION['prodchange']!='' || $_SESSION['btn']!='' || $_SESSION['schange']!='' || $_SESSION['dtrange']!=''))
    {

$compchange = $_SESSION['compchange'];
      $unitchange = $_SESSION['unitchange'];
      $pcatchange = $_SESSION['pcatchange'];
      $prodchange = $_SESSION['prodchange'];
      if($compchange!='')
      {
        $comp = 'AND o.location_id='.$compchange;
        $comp1 = 'AND i.location_id='.$compchange;
      }
      else
      {
        $comp = '';
        $comp1='';
      }
      if($unitchange!='')
      {
        $unit = 'AND o.prod_unit="'.$unitchange.'"';
        $unit1 = 'AND i.prod_unit="'.$unitchange.'"';
      }
      else
      {
        $unit = '';
        $unit1='';
      }
      if($pcatchange!='')
      {
        $pcat = 'AND p.category_id="'.$pcatchange.'"';
      }
      else
      {
        $pcat = '';
      }
      if($prodchange!='')
      {
        $prod = 'AND ip.product_id="'.$prodchange.'"';
      }
      else
      {
        $prod = '';
      }

$btn = $_SESSION['btn'];
      $schange = $_SESSION['schange'];
      $dtrange = $_SESSION['dtrange'];

if($schange == '')
        $schange='';

if($schange == '')
 {
 $fdate = date('Y-m-d', strtotime('-7 days'));
 $tdate = date('Y-m-d');
 $data['drnge'] = '';
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp $unit $pcat $prod UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp1 $unit1 $pcat $prod UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $comp1 $unit1 ORDER BY invoice_id DESC")->result_array();
 }
 elseif($schange == 'today')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') = CURDATE() ORDER BY invoice_id DESC")->result_array();
 }
 else if($schange == 'thisweek')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and YEARWEEK(STR_TO_DATE(i.invoice_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY invoice_id DESC")->result_array();
 } 
 else if($schange == 'thismonth')
 {
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and MONTH(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY invoice_id DESC")->result_array();
 }
 else if($schange == 'thisyear')
 {
 //$data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and YEAR(STR_TO_DATE(i.invoice_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY invoice_id DESC")->result_array();
 $finstart = $_SESSION['finstart'];
 $finend = $_SESSION['finend'];
 $data['invoice_list'] = $this->db->query("SELECT i.* FROM invoice i,`order` o,invoice_product ip,product p WHERE o.order_id = i.order_id AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp $unit $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,product p WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.product_id = p.product_id $comp1 $unit1 $pcat $prod and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') UNION SELECT i.* FROM invoice i,invoice_product ip,rawmaterial r WHERE i.order_id=0 AND i.invoice_id = ip.invoice_id AND ip.rawmaterial_id = r.rawmaterial_id $comp1 $unit1 and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY invoice_id DESC")->result_array();
 }
 else
 {
 $data['drnge'] = $dtrange;
 $dr = explode(' - ', $dtrange);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

else
    {
      /*$fdate = date('Y-m-d', strtotime('-7 days'));
      $tdate = date('Y-m-d');*/
      
      if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31'; 
        }
        else
        {
          $fdate = date('Y-m-d', strtotime('-7 days'));
          $tdate = date('Y-m-d');
        }
      }
      else
      {
        $fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');
      }
      
      //$data['applichange'] = '';
      //$data['refchange'] = '';      
      $data['compchange'] = '';     
      $data['unitchange'] = '';
      $data['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['pcatchange'] = '';
      $data['prodchange'] = '';
      $data['invoice_list'] = $this->Invoice_model->get_invoice_list($fdate,$tdate);
    }
    $this->load->view('invoice/invoice_list',$data);
  }

public function wo_list()
  {
    $data['order_list'] = $this->Invoice_model->get_dc_order_list();
    $this->load->view('invoice/pending_delivery_challan',$data);
  }

public function invoice_add()
  {

$last_id_value = $this->Invoice_model->invoice_no_last_id();
    if(count($last_id_value)==0)
    {
      $data['invoice_no'] = date("Y").'/'.date('m').'/INV001';
    }
    else
    {
      $lno = $last_id_value->invoice_no;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $data['invoice_no'] = date("Y").'/'.date('m').'/INV'.$nval;
    }

$data['order_list'] = $this->Invoice_model->get_dc_order_list();
    $data['payment_term'] = $this->Invoice_model->get_inv_payment_term();
    $data['delivery_term'] = $this->Invoice_model->get_so_delivery_term();
    $data['freight_term'] = $this->Invoice_model->get_freight_term();
    $data['last_invoice'] = $this->Invoice_model->last_id();

$this->load->view('invoice/invoice_add',$data);
  }

public function getRawmaterialByLocation()
 {
 $whid = $_POST['wid'];
 $lid = $_POST['id'];
 //$product = $this->Invoice_model->get_rm_stock_by_loc_id($lid);
 $product = $this->Invoice_model->get_warehouse_rm_stock_by_loc_wh_id($lid,$whid);
 if(count($product)>0)
 {
 $st = '<option value="">Select Raw Material</option>';
 $s=0;
 foreach ($product as $prod) {
 if($prod['stock']>0)
 {
 $st.='<option value='.$prod["rawmaterial_id"].'>'.$prod["rawmaterial"].'</option>';
 $s=1;
 }
 }
 if($s==0)
 {
 $st = '<option value="">No Raw Material Available</option>';
 }
 }
 else
 {
 $st = '<option value="">No Raw Material Available</option>';
 }
 echo $st;
 }

public function getProductByLocation()
 {
 $lid = $_POST['id'];
 $type = $_POST['type'];
 $punit = $_POST['punit'];
 $whid = $_POST['wid'];
 if($type == 'trading product')
 $product = $this->Invoice_model->get_wh_prod_stock_by_loc_id_punit($lid,$punit,$whid);
 else
 $product = $this->Invoice_model->get_wh_std_prod_stock_by_loc_id_punit($lid,$punit,$whid);
 if(count($product)>0)
 {
 $st = '<option value="">Select Product</option>';
 $s=0;
 foreach ($product as $prod) {
 if($prod['stock']>0)
 {
 $st.='<option value='.$prod["product_id"].'>'.$prod["product_code"].' - '.$prod["product_name"].'</option>';
 $s=1;
 }
 }
 if($s==0)
 {
 $st = '<option value="">No Products Available</option>';
 }
 }
 else
 {
 $st = '<option value="">No Products Available</option>';
 }
 echo $st;
 }

public function getRawMaterialDetails()
  {
    $lid = $_POST['lid'];
    $rmid = $_POST['id'];
    $whid = $_POST['whid'];
    //$rmdet = $this->Invoice_model->get_rm_details_by_rm_loc_id($rmid,$lid);
    $rmdet = $this->Invoice_model->get_whstock_rm_details_by_rm_loc_wh_id($rmid,$lid,$whid);
    echo $rmdet->rawmaterial_uom."|".$rmdet->rawmaterial_uom_id."|".$rmdet->stk."|".$rmdet->gst;
  }

public function getProductDetails()
  {
    $lid = $_POST['lid'];
    $pid = $_POST['id'];
    $whid = $_POST['whid'];
    //$rmdet = $this->Invoice_model->get_pr_details_by_pr_loc_id($pid,$lid);
    $rmdet = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($pid,$lid,$whid);
    echo $rmdet->uom."|".$rmdet->uom_id."|".$rmdet->stock."|".$rmdet->gst."|".$rmdet->unit_price."|".$rmdet->accessories_weight;
  }

public function invoice_direct_add()
  {

/*$last_id_value = $this->Invoice_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['invoice_no'] = date("Y").'/'.date('m').'/INV001';
    }
    else
    {
      $lno = $last_id_value->invoice_no;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $data['invoice_no'] = date("Y").'/'.date('m').'/INV'.$nval;
    }*/

$data['customer_list'] = $this->Invoice_model->get_customer_list();
    $data['location_list'] = $this->Invoice_model->get_active_location();
    $data['payment_term'] = $this->Invoice_model->get_inv_payment_term();
    $data['delivery_term'] = $this->Invoice_model->get_so_delivery_term();
    $data['freight_term'] = $this->Invoice_model->get_freight_term();
    $data['genset'] = $this->Quotation_model->get_general_settings_details();
    $data['open_order_list'] = $this->Invoice_model->get_open_order_list();
    $data['last_invoice'] = $this->Invoice_model->last_id();

$this->load->view('invoice/invoice_direct_add',$data);
  }

public function getProduct()
  {
    $woid = $_POST['id'];
    $oid = $_POST['oid'];
    //$work_order = $data['work_order'] = $this->Worklog_model->get_work_order_by_id($pt_id);
    //$data['wo_product'] = $this->Worklog_model->get_work_order_product_by_id($pt_id);
    //$data['order'] = $this->Workorder_model->get_order_view_by_id($work_order->order_id);
    //$data['user_list'] = $this->Worklog_model->user_active_list();
    /*if($woid==0)
    {
      $data['order_dc_list'] = $this->Invoice_model->get_dc_list_by_order_id($oid);
      $data['order_product_list'] = $this->Invoice_model->get_order_product_by_id($oid);
    }
    else
    {
      $data['order_dc_list'] = $this->Invoice_model->get_dc_list_by_work_order_id($woid);
      $data['order_product_list'] = $this->Invoice_model->get_work_order_product_for_inv_by_id($woid);
    }*/

$dclist = $data['order_dc_list'] = $this->Invoice_model->get_dc_list_by_work_order_id($woid);
    if(count($dclist)>0)
    {
      $data['order_product_list'] = $this->Invoice_model->get_work_order_product_for_inv_by_id($woid);
    }
    else
    {
      $data['order_dc_list'] = $this->Invoice_model->get_dc_list_by_order_id($oid);
      $data['order_product_list'] = $this->Invoice_model->get_order_product_by_id($oid);
    }

$this->load->view('invoice/invoice_product_detail',$data);
  }

public function create_invoice()
  {  
    //$ino = $data['invoice_no']=$this->input->post('invoice_no');
    $ddt = explode('/', $this->input->post('invoice_date'));
    $invdate = $data['invoice_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    //$ordId = $data['order_id']=$this->input->post('order_id');
    $exp = explode('-', $this->input->post('order_id'));
    $ordId = $data['order_id']=$exp[0];
    $data['work_order_id']=$exp[1];
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_total']=$this->input->post('tax_total');
    $data['round_off']=$this->input->post('round_off');
    $invtot = $data['grand_total']=$this->input->post('grand_total');
    $data['payment_term_id']=$this->input->post('payment_term_id');
    $data['delivery_term_id']=$this->input->post('delivery_term_id');
    $data['freight_term_id']=$this->input->post('freight_term_id');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']='';
    $data['lr_rr_no']=$this->input->post('lr_rr_no');
    $data['eway_bill_no']=$this->input->post('eway_bill_no');
    $data['remarks']=$this->input->post('remarks');
    $nop = $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['net_weight']=$this->input->post('net_weight');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['packing_charges']=$this->input->post('packing_charges');
    $data['other_charges']=$this->input->post('other_charges');
    $data['destination_point']=$this->input->post('destination_point');

$olist = $this->Order_model->get_order_view_by_id($ordId);

$locDetails = $this->Invoice_model->get_location_by_id($olist->location_id);

//$last_id_value = $this->Invoice_model->last_id_by_locid($olist->location_id);
    $last_id_value = $this->Invoice_model->last_id_by_loc_code($locDetails->location_code);
    /*if(count($last_id_value)==0)
    {
      $ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV001';
    }
    else
    {
      $lno = $last_id_value->invoice_no;
      $exlno = substr($lno,14);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV'.$nval;
    }*/

$fin2start = $_SESSION['fin2start'];
    $fin2end = $_SESSION['fin2end'];

$finhi = $fin2start.'-'.$fin2end;

if(count($last_id_value)==0)
    {
      //$ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV001';
      $ino = $data['invoice_no'] = $locDetails->location_code.'-001/'.$fin2start.'-'.$fin2end;
    }
    else
    {
      $lno = $last_id_value->invoice_no;
      $exlno = explode('/', $lno);
      if($finhi == $exlno[1])
      {
        $valexp = explode('-', $exlno[0]);
        $next_value = (int)$valexp[1] + 1;
        $slen = strlen($next_value);
        if($slen==1)
          $nval = '00'.$next_value;
        else if($slen==2)
          $nval = '0'.$next_value;
        else
          $nval = $next_value;
        $ino = $data['invoice_no'] = $locDetails->location_code.'-'.$nval.'/'.$finhi;
      }
      else
      {
        $ino = $data['invoice_no'] = $locDetails->location_code.'-001/'.$finhi;
      }
      /*$exlno = substr($lno,14);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV'.$nval;*/
    }

$data['delivery_type'] = $olist->delivery_type;

if(!empty($_FILES['lr_rr_bill']['name']))
    {
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['lr_rr_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'lrrrbill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('lr_rr_bill'))
      {
        $uploadData = $this->upload->data();
        $data['lr_rr_bill'] = $profileName;
      }
      else
      {
        $data['lr_rr_bill'] = '';
      }
    }
    else
    {
      $data['lr_rr_bill'] = '';
    }

if(!empty($_FILES['eway_bill']['name']))
    {
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['eway_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'ewaybill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('eway_bill'))
      {
        $uploadData = $this->upload->data();
        $data['eway_bill'] = $profileName;
      }
      else
      {
        $data['eway_bill'] = '';
      }
    }
    else
    {
      $data['eway_bill'] = '';
    }
    
    $result = $this->Invoice_model->create_invoice($data);

if ($result) {
      $last_id_value = $this->Invoice_model->last_id();
      $last_value=$last_id_value->count_val;
      $invoice_id = $last_value;

if($this->input->post('product_id')!='')
      {
        $pid = explode(",",implode(",",$this->input->post('product_id')));
        $uom = explode(",",implode(",",$this->input->post('uom_id')));
        $ptid = explode(",",implode(",",$this->input->post('product_type_id')));
        $pgst = explode(",",implode(",",$this->input->post('product_gst')));
        $pfid = explode(",",implode(",",$this->input->post('price_formula_id')));
        $rpsf = explode(",",implode(",",$this->input->post('rate_per_sqft')));
        $csl = explode(",",implode(",",$this->input->post('cut_size_length')));
        $csw = explode(",",implode(",",$this->input->post('cut_size_width')));
        $csh = explode(",",implode(",",$this->input->post('cut_size_height')));
        $fsl = explode(",",implode(",",$this->input->post('finish_size_length')));
        $fsw = explode(",",implode(",",$this->input->post('finish_size_width')));
        $fsh = explode(",",implode(",",$this->input->post('finish_size_height')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $rt = explode(",",implode(",",$this->input->post('rate')));
        $dis = explode(",",implode(",",$this->input->post('disc')));
        $amt = explode(",",implode(",",$this->input->post('amount')));
        $wgt = explode(",",implode(",",$this->input->post('weight')));

$subcount = count($this->input->post('product_id')); 
 $data1['invoice_id'] = $invoice_id;
 for($i=0;$i<$subcount;$i++)
 {
 if($pid[$i] != ''){
 $data1['product_id'] = $pid[$i];
 $data1['uom_id'] = $uom[$i];
 $data1['product_type_id'] = $ptid[$i];
 $pgst1 = $data1['product_gst'] = $pgst[$i];
 $data1['price_formula_id'] = $pfid[$i];
 $data1['rate_per_sqft'] = $rpsf[$i];
 $data1['cut_size_length'] = $csl[$i];
 $data1['cut_size_width'] = $csw[$i];
 $data1['cut_size_height'] = $csh[$i];
 $data1['finish_size_length'] = $fsl[$i];
 $data1['finish_size_width'] = $fsw[$i];
 $data1['finish_size_height'] = $fsh[$i];
 $data1['quantity'] = $qty[$i];
 $data1['rate'] = $rt[$i];
 $data1['disc'] = $dis[$i];
 $data1['amount'] = $amt[$i];
 $data1['weight'] = $wgt[$i];
 $this->Invoice_model->create_invoice_product($data1);
 }
 }
 }

/*$paydata['order_id'] = 0;
      $paydata['invoice_id']=$invoice_id;
      $odt = explode('/', $this->input->post('payment_date'));
      $paydata['payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $pmode = $paydata['payment_mode'] = $this->input->post('payment_mode');    
      $paydata['payment_amount'] = $this->input->post('payment_amount');
      if(($pmode == 'Cheque') || ($pmode == 'Post Date Cheque'))
      {
        $paydata['cheque_no'] = $this->input->post('cheque_no');
        $paydata['bank_name'] = $this->input->post('bank_name');
        $paydata['branch_name'] = $this->input->post('branch_name');
        $paydata['status']=1;
      }
      else
      {
        $paydata['cheque_no'] = '';
        $paydata['bank_name'] = '';
        $paydata['branch_name'] = '';
        $paydata['status']=0;
      }
      $paydata['created_on'] = date('Y-m-d H:i:s');
      $paydata['created_by'] = $_SESSION['user_id'];

$result = $this->Payment_model->create_payment($paydata);*/

$workLog = $this->Invoice_model->get_invoice_by_order_id($ordId);
      $wlId = $workLog->work_log_id;
      $woId = $workLog->work_order_id;

$dcsts['status']=1;
      //$this->Invoice_model->update_delivery_challan_status_by_order_id($dcsts,$ordId);
      $this->Invoice_model->update_delivery_challan_status_by_order_id($dcsts,$woId);

$wlsts['status']=2;
      $this->Invoice_model->update_work_log_status($wlsts,$wlId);

$irsts['status']=3;
      $this->Invoice_model->update_issue_register_status($irsts,$woId);

$wosts['status']=4;
      $this->Invoice_model->update_work_order_status($wosts,$woId);

$ordsts['status']=5;
      $this->Invoice_model->update_order_status($ordsts,$ordId);

$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($ordId);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$badd='';
      $sadd = '';
      /*foreach($cus_address as $cadd)
      {
        if($cadd['address_type_id']==1)
        {
          $badd = $cadd['address'];
        }
        if($cadd['address_type_id']==2)
        {
          $sadd = $cadd['address'];
        }
      }
      if($badd=='')
      {
        $pdata['badd'] = $badd = $sadd;
      }
      else
      {
        $pdata['badd'] = $badd = $badd;
      }
      if($sadd=='')
      {
        $pdata['sadd'] = $sadd = $badd;
      }
      else
      {
        $pdata['sadd'] = $sadd = $sadd;
      }*/

if($order_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $stid = $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$invoice = $pdata['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);

$pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);

for($i=1;$i<=$nop;$i++)
 {
 $rmnorep = str_replace('/', '-', $ino);
 $this->load->library('zend');
 $this->zend->load('Zend/Barcode');
 $bcode = $rmnorep.'_'.$i;
 $file = Zend_Barcode::draw('code128', 'image', array('text' => $bcode), array());
 $store_image = imagepng($file,"./invoicebarcode/{$bcode}.png");
 $this->Invoice_model->create_invoice_barcode($bcode,$invoice_id);
 }

if($stid == 33)
      {
        $cgstledgname = 'OUTPUT CGST '.$pgst1.'%';
        $cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$order_list->location_id);
        if(count($cgstledg)>0)
        {
          $cgst = $invoice->tax_total/2;
          $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
          $cgstdata['tax_type'] = 0;
          $cgstdata['type'] = 'Invoice Tax';
          $cgstdata['type_id'] = $invoice->invoice_id;
          $cgstdata['amount'] = $cgst;
          $cgstdata['status'] = 0;
          $cgstdata['created_on'] = date('Y-m-d H:i:s');
          $cgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$order_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$cgstledgname;
          $this->Ledger_model->create_ledger_list($led);

$cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$order_list->location_id);
          if(count($cgstledg)>0)
          {
            $cgst = $invoice->tax_total/2;
            $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
            $cgstdata['tax_type'] = 0;
            $cgstdata['type'] = 'Invoice Tax';
            $cgstdata['type_id'] = $invoice->invoice_id;
            $cgstdata['amount'] = $cgst;
            $cgstdata['status'] = 0;
            $cgstdata['created_on'] = date('Y-m-d H:i:s');
            $cgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
          }
        }

$sgstledgname = 'OUTPUT SGST '.$pgst1.'%';
        $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$order_list->location_id);
        if(count($sgstledg)>0)
        {
          $sgst = $invoice->tax_total/2;
          $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
          $sgstdata['tax_type'] = 0;
          $sgstdata['type'] = 'Invoice Tax';
          $sgstdata['type_id'] = $invoice->invoice_id;
          $sgstdata['amount'] = $sgst;
          $sgstdata['status'] = 0;
          $sgstdata['created_on'] = date('Y-m-d H:i:s');
          $sgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$order_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$sgstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$order_list->location_id);
          if(count($sgstledg)>0)
          {
            $sgst = $invoice->tax_total/2;
            $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
            $sgstdata['tax_type'] = 0;
            $sgstdata['type'] = 'Invoice Tax';
            $sgstdata['type_id'] = $invoice->invoice_id;
            $sgstdata['amount'] = $sgst;
            $sgstdata['status'] = 0;
            $sgstdata['created_on'] = date('Y-m-d H:i:s');
            $sgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
          }
        }
        
        //$sgst = $invoice->tax_total/2;
      }
      else
      {
        //$igst = $invoice->tax_total;
        $igsttax = $pgst1*2;
        $igstledgname = 'OUTPUT IGST '.$igsttax.'%';
        $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$order_list->location_id);
        if(count($igstledg)>0)
        {
          $igst = $invoice->tax_total;
          $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
          $igstdata['tax_type'] = 0;
          $igstdata['type'] = 'Invoice Tax';
          $igstdata['type_id'] = $invoice->invoice_id;
          $igstdata['amount'] = $igst;
          $igstdata['status'] = 0;
          $igstdata['created_on'] = date('Y-m-d H:i:s');
          $igstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$order_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$igstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$order_list->location_id);
          if(count($igstledg)>0)
          {
            $igst = $invoice->tax_total;
            $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
            $igstdata['tax_type'] = 0;
            $igstdata['type'] = 'Invoice Tax';
            $igstdata['type_id'] = $invoice->invoice_id;
            $igstdata['amount'] = $igst;
            $igstdata['status'] = 0;
            $igstdata['created_on'] = date('Y-m-d H:i:s');
            $igstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
          }
        }
      }

//SMS
      $genset = $this->Order_model->get_general_settings_details();
      $nlcontent = $this->Invoice_model->get_new_invoice_msg();
      $content = $nlcontent->sms_content;
      $content = str_replace('#invNo#', $ino, $content);
      $content = str_replace('#invDate#', $invdate, $content);
      $content = str_replace('#invAmt#', $invtot, $content);
      sendsms($cphone,$content,$genset->sms_auth_key,$genset->sms_sender_id);
      //SMS

$this->session->set_flashdata('add_success', 'Invoice has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $pdata['iprint'] = "0";
    $this->load->view('invoice/printview',$pdata);
    //redirect('/deliverychallan');
  }

public function create_direct_invoice()
  {  
    //$data['invoice_no']=$this->input->post('invoice_no');
    $ddt = explode('/', $this->input->post('invoice_date'));
    $invdate = $data['invoice_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    //$data['invoice_date'] = date('Y-m-d');
    $edt = explode('/', $this->input->post('delivery_date'));
    $data['delivery_date'] = $edt[2].'-'.$edt[0].'-'.$edt[1];
    $cusId = $data['customer_id']=$this->input->post('customer_id');
    $type = $data['type']=$this->input->post('type');
    $locId = $data['location_id']=$this->input->post('location_id');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_total']=$this->input->post('tax_total');
    $data['round_off']=$this->input->post('round_off');
    $invtot = $data['grand_total']=$this->input->post('grand_total');
    $data['payment_term_id']=$this->input->post('payment_term_id');
    $data['delivery_term_id']=$this->input->post('delivery_term_id');
    $data['freight_term_id']=$this->input->post('freight_term_id');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']='';
    $data['lr_rr_no']=$this->input->post('lr_rr_no');
    $data['eway_bill_no']=$this->input->post('eway_bill_no');
    $data['remarks']=$this->input->post('remarks');
    $nop = $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['net_weight']=$this->input->post('net_weight');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['packing_charges']=$this->input->post('packing_charges');
    $data['other_charges']=$this->input->post('other_charges');
    $data['prod_unit']=$this->input->post('prod_unit');
    $data['destination_point']=$this->input->post('destination_point');
    $data['customer_billing_address_id'] = $this->input->post('customer_billing_address_id');
    $data['customer_shipping_address_id'] = $this->input->post('customer_shipping_address_id');

$locDetails = $this->Invoice_model->get_location_by_id($locId);

//$last_id_value = $this->Invoice_model->last_id_by_locid($locId);
    $last_id_value = $this->Invoice_model->last_id_by_loc_code($locDetails->location_code);
    /*if(count($last_id_value)==0)
    {
      $ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV001';
    }
    else
    {
      $lno = $last_id_value->invoice_no;
      $exlno = substr($lno,14);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $ino = $data['invoice_no'] = date("Y").'/'.date('m').'/'.$locDetails->location_code.'/INV'.$nval;
    }*/

$fin2start = $_SESSION['fin2start'];
    $fin2end = $_SESSION['fin2end'];

$finhi = $fin2start.'-'.$fin2end;

$dsoid = $data['direct_so_id']=$this->input->post('direct_so_id');
    $data['delivery_type'] = $this->input->post('delivery_type');
    $whId = $data['warehouse_id']=$this->input->post('warehouse_id');

$result = $this->Invoice_model->create_direct_invoice($data);

if ($result) {
      $last_id_value = $this->Invoice_model->last_id();
      $last_value=$last_id_value->count_val;
      $invoice_id = $last_value;

if($type=='raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $uom = explode(",",implode(",",$this->input->post('rm_uom_id')));
          $rpsf = explode(",",implode(",",$this->input->post('rm_rate_per_sqft')));
          $qty = explode(",",implode(",",$this->input->post('rm_quantity')));
          $rt = explode(",",implode(",",$this->input->post('rm_rate')));
          $dis = explode(",",implode(",",$this->input->post('rm_disc')));
          $amt = explode(",",implode(",",$this->input->post('rm_amount')));
          $gst = explode(",",implode(",",$this->input->post('rawmaterial_gst')));

$subcount = count($this->input->post('rawmaterial_id')); 
 $data1['invoice_id'] = $invoice_id;
 for($i=0;$i<$subcount;$i++)
 {
 if($pid[$i] != ''){
 $data1['rawmaterial_id'] = $pid[$i];
 $data1['rm_uom_id'] = $uom[$i];
 $data1['rm_rate_per_sqft'] = $rpsf[$i];
 $data1['rm_quantity'] = $qty[$i];
 $data1['rm_rate'] = $rt[$i];
 $data1['rm_disc'] = $dis[$i];
 $data1['rm_amount'] = $amt[$i];
 $pgst = $data1['product_gst'] = $gst[$i];
 $data1['accessories_weight'] = 0;
 $this->Invoice_model->create_direct_invoice_rawmaterial($data1);

//$stockdet = $this->Invoice_model->get_rawmaterial_stock_by_location_rawmaterial_id($locId,$pid[$i]);
              $stockdet = $this->Invoice_model->get_whstock_rm_details_by_rm_loc_wh_id($pid[$i],$locId,$whId);
              $reqstock = $qty[$i];
              $s=0;
              //foreach($stockdet as $rmsdet)
              //{
                if($stockdet->stk>=$reqstock)
                {
                  $stk = $reqstock;
                  $s=1;
                }
                else
                {
                  $reqstock = $reqstock - $stockdet->stk;
                  $stk = $stockdet->stk;
                }

/*$rmsid = $rmsdet['rawmaterial_stock_id'];
                $stok = $rmsdet['stock'];
                $fstk = $stok-$stk;
                $upstk['stock'] = $fstk;
                $upstk['location_id'] = $locId; 
                $upstk['rawmaterial_id'] = $pid[$i];
                $upstk['modified_on'] = date('Y-m-d H:i:s');
                $upstk['modified_by'] = $_SESSION['user_id'];

$this->Invoice_model->update_rawmaterial_stock_by_location_id($locId,$pid[$i],$upstk,$rmsid);*/

$whsid = $stockdet->warehouse_stock_id;
                $stok = $stockdet->stk;
                $fstk = $stok-$stk;
                $upstk['stock'] = $fstk;
                $upstk['modified_on'] = date('Y-m-d H:i:s');
                $upstk['modified_by'] = $_SESSION['user_id'];

$this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);

/*if($s==1)
                  break;*/
              //}

/*$pstock = $this->Invoice_model->get_rawmaterial_stock_details_by_location_id($locId,$pid[$i],$qty[$i]);
              $ostk = $pstock->stock;
              $rmsid = $pstock->rawmaterial_stock_id;
              $nstk = $ostk - $qty[$i];
              $upstk['location_id'] = $locId; 
              $upstk['rawmaterial_id'] = $pid[$i]; 
              $upstk['stock'] = $nstk; 
              $upstk['modified_on'] = date('Y-m-d H:i:s');
              $upstk['modified_by'] = $_SESSION['user_id'];*/
              //$this->Invoice_model->update_rawmaterial_stock_by_location_id($locId,$pid[$i],$upstk,$rmsid);
            }
          }
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('product_id')));
          $uom = explode(",",implode(",",$this->input->post('pr_uom_id')));
          $rpsf = explode(",",implode(",",$this->input->post('pr_rate_per_sqft')));
          $qty = explode(",",implode(",",$this->input->post('pr_quantity')));
          $rt = explode(",",implode(",",$this->input->post('pr_rate')));
          $dis = explode(",",implode(",",$this->input->post('pr_disc')));
          $amt = explode(",",implode(",",$this->input->post('pr_amount')));
          $gst = explode(",",implode(",",$this->input->post('product_gst')));
          $accwgt = explode(",",implode(",",$this->input->post('pr_accessories_weight')));

//$pstock = $this->Invoice_model->get_product_stock_by_location_id($pid[$i],$locId);
              $pstock = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($pid[$i],$locId,$whId);
              $ostk = $pstock->stock;
              $nstk = $ostk - $qty[$i];
              $whsid = $pstock->warehouse_stock_id;
              $upstk['stock'] = $nstk; 
              $upstk['modified_on'] = date('Y-m-d H:i:s');
              $upstk['modified_by'] = $_SESSION['user_id'];
              $this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);
            }
          }
        }
      }

$paydata['order_id'] = 0;
      $paydata['invoice_id']=$invoice_id;
      $odt = explode('/', $this->input->post('payment_date'));
      $paydata['payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $pmode = $paydata['payment_mode'] = $this->input->post('payment_mode');    
      $paydata['payment_amount'] = $this->input->post('payment_amount');
      if(($pmode == 'Cheque') || ($pmode == 'Post Date Cheque'))
      {
        $paydata['cheque_no'] = $this->input->post('cheque_no');
        $paydata['bank_name'] = $this->input->post('bank_name');
        $paydata['branch_name'] = $this->input->post('branch_name');
        $paydata['status']=1;
      }
      else
      {
        $paydata['cheque_no'] = '';
        $paydata['bank_name'] = '';
        $paydata['branch_name'] = '';
        $paydata['status']=0;
      }
      $paydata['created_on'] = date('Y-m-d H:i:s');
      $paydata['created_by'] = $_SESSION['user_id'];

$result = $this->Payment_model->create_payment($paydata);

$customer_details = $this->Customer_model->get_customer_by_id($cusId);
        if($customer_details->is_sister_concern==1)
        {
          $locdetails = $this->Invoice_model->get_location_by_id($locId);
          $locname = $locdetails->location_name;
          $vendetails = $this->Invoice_model->get_vendor_by_name($locname);

$purdata['vendor_id']=$vendetails->vendor_id;
          $purdata['purchase_date'] = $invdate;

$last_id_value = $this->Purchase_model->last_id();
          if(count($last_id_value)==0)
          {
            $purdata['purchase_receipt_no'] = date("Y").'/'.date('m').'/001';
          }
          else
          {
            $lno = $last_id_value->purchase_receipt_no;
            $exlno = substr($lno,8);
            $next_value = (int)$exlno + 1;
            $slen = strlen($next_value);
            if($slen==1)
              $nval = '00'.$next_value;
            else if($slen==2)
              $nval = '0'.$next_value;
            else
              $nval = $next_value;
            $purdata['purchase_receipt_no'] = date("Y").'/'.date('m').'/'.$nval;
          }
          $purdata['invoice_no']=$ino;
          $purdata['invoice_date'] = $invdate; 
          $purdata['taxable_amount']=$this->input->post('taxable_amount');
          $purdata['tax_amount']=$this->input->post('tax_total');
          $purdata['tax_percent']=($this->input->post('tax_total')*100)/$this->input->post('taxable_amount');
          $purdata['total_amount']=$this->input->post('taxable_amount')+$this->input->post('tax_total');
          $purdata['purchase_order_id'] = 0;

$last_id_value = $this->Purchase_model->last_id();
          if(count($last_id_value)==0)
          {
            $pno = $purdata['purchase_no'] = date("Y").'/'.date('m').'/PUR001';
          }
          else
          {
            $lno = $last_id_value->purchase_no;
            $exlno = substr($lno,11);
            $next_value = (int)$exlno + 1;
            $slen = strlen($next_value);
            if($slen==1)
              $nval = '00'.$next_value;
            else if($slen==2)
              $nval = '0'.$next_value;
            else
              $nval = $next_value;
            $pno = $purdata['purchase_no'] = date("Y").'/'.date('m').'/PUR'.$nval;
          }
          $purdata['purchase_bill'] = '';
          $purdata['created_on'] = date('Y-m-d H:i:s');
          $purdata['created_by'] = $_SESSION['user_id'];
          $purdata['grn_id'] = 0;
          $purdata['other_charges'] = $this->input->post('packing_charges')+$this->input->post('other_charges');
          $purdata['no_of_rolls'] = $nop;
          $purdata['remarks'] = '';
          $purdata['location_id'] = $customer_details->sister_concern_location_id;
          $result1 = $this->Purchase_model->create_purchase($purdata);

if($result1)
          {
            $last_id_value = $this->Purchase_model->last_id();
            $last_value=$last_id_value->count_val;
            $purproduct['purchase_id'] = $last_value;

if($type=='raw material')
            {
              if($this->input->post('rawmaterial_id')!='')
              {
                $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
                $qty = explode(",",implode(",",$this->input->post('rm_quantity')));
                $rate = explode(",",implode(",",$this->input->post('rm_rate_per_sqft')));
                $amt = explode(",",implode(",",$this->input->post('rm_rate')));
                $purqty = explode(",",implode(",",$this->input->post('rm_quantity')));

$subcount = count($this->input->post('rawmaterial_id')); 
 $s=0;
 for($i=0;$i<$subcount;$i++)
 {
 if($rmid[$i] != ''){
 $rmdetails = $this->Invoice_model->get_rawmaterial_by_id($rmid[$i]);
 $purproduct['rawmaterial_id'] = $rmid[$i];
 $purproduct['gsm'] = $rmdetails->rawmaterial_gsm;
 $purproduct['quantity'] = $qty[$i];
 $purproduct['net_weight'] = 0;
 $purproduct['grn_weight'] = 0;
 $purproduct['rm_weight'] = 0;
 $purproduct['rate'] = $rate[$i];
 $purproduct['amount'] = $amt[$i];
 $purproduct['purchase_quantity'] = $purqty[$i];
 $this->Purchase_model->create_purchase_product($purproduct);

}
                }
              }
            }
            else
            {
              if($this->input->post('product_id')!='')
              {
                $prod = explode(",",implode(",",$this->input->post('product_id')));
                $qty = explode(",",implode(",",$this->input->post('pr_quantity')));
                $rate = explode(",",implode(",",$this->input->post('pr_rate_per_sqft')));
                $amt = explode(",",implode(",",$this->input->post('pr_rate')));
                $purqty = explode(",",implode(",",$this->input->post('pr_quantity')));

$subcount = count($this->input->post('product_id')); 
 $s=0;
 for($i=0;$i<$subcount;$i++)
 {
 if($prod[$i] != ''){
 $purproduct['product_id'] = $prod[$i];
 $purproduct['gsm'] = 0;
 $purproduct['quantity'] = $qty[$i];
 $purproduct['net_weight'] = 0;
 $purproduct['grn_weight'] = 0;
 $purproduct['rm_weight'] = 0;
 $purproduct['rate'] = $rate[$i];
 $purproduct['amount'] = $amt[$i];
 $purproduct['purchase_quantity'] = $purqty[$i];
 $this->Purchase_model->create_purchase_product_by_product_id($purproduct);

}
                }
              }
            }
          }
        }

$invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

if($invoice_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $stid = $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$invoice = $pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

if($invoice_list->type=='raw material')
      {
        $pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_rawmaterial_id($invoice_id);
      }
      else
      {
        $pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
      }

if($dsoid!=0)
      {
        $ordsts['status']=5;
        $this->Invoice_model->update_order_status($ordsts,$dsoid);
      }

//$tledg = $this->Invoice_model->get_tax_ledger_by_gst_loc_id($pgst,$invoice->location_id);

if($stid == 33)
      {
        $cgstledgname = 'OUTPUT CGST '.$pgst.'%';
        $cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$invoice->location_id);
        if(count($cgstledg)>0)
        {
          $cgst = $invoice->tax_total/2;
          $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
          $cgstdata['tax_type'] = 0;
          $cgstdata['type'] = 'Invoice Tax';
          $cgstdata['type_id'] = $invoice->invoice_id;
          $cgstdata['amount'] = $cgst;
          $cgstdata['status'] = 0;
          $cgstdata['created_on'] = date('Y-m-d H:i:s');
          $cgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$invoice->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$cgstledgname;
          $this->Ledger_model->create_ledger_list($led);

$cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$invoice->location_id);
          if(count($cgstledg)>0)
          {
            $cgst = $invoice->tax_total/2;
            $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
            $cgstdata['tax_type'] = 0;
            $cgstdata['type'] = 'Invoice Tax';
            $cgstdata['type_id'] = $invoice->invoice_id;
            $cgstdata['amount'] = $cgst;
            $cgstdata['status'] = 0;
            $cgstdata['created_on'] = date('Y-m-d H:i:s');
            $cgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
          }
        }

$sgstledgname = 'OUTPUT SGST '.$pgst.'%';
        $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$invoice->location_id);
        if(count($sgstledg)>0)
        {
          $sgst = $invoice->tax_total/2;
          $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
          $sgstdata['tax_type'] = 0;
          $sgstdata['type'] = 'Invoice Tax';
          $sgstdata['type_id'] = $invoice->invoice_id;
          $sgstdata['amount'] = $sgst;
          $sgstdata['status'] = 0;
          $sgstdata['created_on'] = date('Y-m-d H:i:s');
          $sgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$invoice->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$sgstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$invoice->location_id);
          if(count($sgstledg)>0)
          {
            $sgst = $invoice->tax_total/2;
            $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
            $sgstdata['tax_type'] = 0;
            $sgstdata['type'] = 'Invoice Tax';
            $sgstdata['type_id'] = $invoice->invoice_id;
            $sgstdata['amount'] = $sgst;
            $sgstdata['status'] = 0;
            $sgstdata['created_on'] = date('Y-m-d H:i:s');
            $sgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
          }
        }
        
        //$sgst = $invoice->tax_total/2;
      }
      else
      {
        //$igst = $invoice->tax_total;
        $igsttax = $pgst*2;
        $igstledgname = 'OUTPUT IGST '.$igsttax.'%';
        $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$invoice->location_id);
        if(count($igstledg)>0)
        {
          $igst = $invoice->tax_total;
          $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
          $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
          $igstdata['tax_type'] = 0;
          $igstdata['type'] = 'Invoice Tax';
          $igstdata['type_id'] = $invoice->invoice_id;
          $igstdata['amount'] = $igst;
          $igstdata['status'] = 0;
          $igstdata['created_on'] = date('Y-m-d H:i:s');
          $igstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$invoice->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$igstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$invoice->location_id);
          if(count($igstledg)>0)
          {
            $igst = $invoice->tax_total;
            $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
            $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
            $igstdata['tax_type'] = 0;
            $igstdata['type'] = 'Invoice Tax';
            $igstdata['type_id'] = $invoice->invoice_id;
            $igstdata['amount'] = $igst;
            $igstdata['status'] = 0;
            $igstdata['created_on'] = date('Y-m-d H:i:s');
            $igstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
          }
        }
      }

$this->session->set_flashdata('add_success', 'Invoice has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $pdata['diprint'] = "0";
    $this->load->view('invoice/direct_invoice_printview',$pdata);
  }

public function direct_invoice_print($invoice_id)
  {

$invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

if($invoice_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

public function invoice_print($invoice_id)
  {

$invoice = $pdata['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);
      $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($invoice->order_id);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

if($order_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
      $pdata['iprint'] = "1";
    $this->load->view('invoice/printview',$pdata);
  }

public function invoice_edit($invoice_id)
  {
    $data['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);
    $data['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
    $data['payment_term'] = $this->Invoice_model->get_inv_payment_term();
    $data['delivery_term'] = $this->Invoice_model->get_so_delivery_term();
    $data['freight_term'] = $this->Invoice_model->get_freight_term();
    $this->load->view('invoice/invoice_edit',$data);
  }

public function invoice_direct_edit($invoice_id)
  {
    $inv = $data['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);
    if($inv->type=='raw material')
    {
      $data['invoice_product'] = $this->Invoice_model->get_direct_rm_invoice_product_by_id($invoice_id);
    }
    else
    {
      $data['invoice_product'] = $this->Invoice_model->get_direct_prod_invoice_product_by_id($invoice_id);
    }
    $data['customer_list'] = $this->Invoice_model->get_customer_list();
    $data['location_list'] = $this->Invoice_model->get_active_location();
    $data['payment_term'] = $this->Invoice_model->get_inv_payment_term();
    $data['delivery_term'] = $this->Invoice_model->get_so_delivery_term();
    $data['freight_term'] = $this->Invoice_model->get_freight_term();
    $data['open_order_list'] = $this->Invoice_model->get_open_order_list();
    $data['genset'] = $this->Quotation_model->get_general_settings_details();
    $this->load->view('invoice/invoice_direct_edit',$data);
  }

public function update_direct_invoice()
  {  
    $invoice_id = $data['invoice_id']=$this->input->post('invoice_id');
    $ino = $this->input->post('invoice_no');
    $ddt = explode('/', $this->input->post('invoice_date'));
    $data['invoice_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    $edt = explode('/', $this->input->post('delivery_date'));
    $data['delivery_date'] = $edt[2].'-'.$edt[0].'-'.$edt[1];
    $cusId = $data['customer_id']=$this->input->post('customer_id');
    $type = $data['type']=$this->input->post('type');
    $locId = $data['location_id']=$this->input->post('location_id');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_total']=$this->input->post('tax_total');
    $data['round_off']=$this->input->post('round_off');
    $data['grand_total']=$this->input->post('grand_total');
    $data['payment_term_id']=$this->input->post('payment_term_id');
    $data['delivery_term_id']=$this->input->post('delivery_term_id');
    $data['freight_term_id']=$this->input->post('freight_term_id');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']='';
    $data['lr_rr_no']=$this->input->post('lr_rr_no');
    $data['eway_bill_no']=$this->input->post('eway_bill_no');
    $data['remarks']=$this->input->post('remarks');
    $nop = $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['net_weight']=$this->input->post('net_weight');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['packing_charges']=$this->input->post('packing_charges');
    $data['other_charges']=$this->input->post('other_charges');
    $data['prod_unit']=$this->input->post('prod_unit');
    $data['destination_point']=$this->input->post('destination_point');
    $data['customer_billing_address_id'] = $this->input->post('customer_billing_address_id');
    $data['customer_shipping_address_id'] = $this->input->post('customer_shipping_address_id');
    $lrbno = $this->input->post('lr_rr_bill_val');
    $ewbno = $this->input->post('eway_bill_val');

if(!empty($_FILES['lr_rr_bill']['name']))
    {
      if($lrbno!=''){
        unlink('lrrrbill/'.$lrbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['lr_rr_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'lrrrbill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('lr_rr_bill'))
      {
        $uploadData = $this->upload->data();
        $data['lr_rr_bill'] = $profileName;
      }
      else
      {
        $data['lr_rr_bill'] = '';
      }
    }
    else
    {
      $data['lr_rr_bill'] = '';
    }

if(!empty($_FILES['eway_bill']['name']))
    {
      if($ewbno!=''){
        unlink('ewaybill/'.$ewbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['eway_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'ewaybill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('eway_bill'))
      {
        $uploadData = $this->upload->data();
        $data['eway_bill'] = $profileName;
      }
      else
      {
        $data['eway_bill'] = '';
      }
    }
    else
    {
      $data['eway_bill'] = '';
    }

$result = $this->Invoice_model->update_direct_invoice($data);

if ($result) {
      $this->Invoice_model->delete_invoice_product_by_id($invoice_id);
      $this->Invoice_model->delete_invoice_barcode_by_id($invoice_id);
      $invoice_id = $invoice_id;

$stockdet = $this->Invoice_model->get_whstock_rm_details_by_rm_loc_wh_id($pid[$i],$locId,$whId);
              $reqstock = $qty[$i];
              $s=0;
                if($stockdet->stk>=$reqstock)
                {
                  $stk = $reqstock;
                  $s=1;
                }
                else
                {
                  $reqstock = $reqstock - $stockdet->stk;
                  $stk = $stockdet->stk;
                }

$this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);
            }
          }
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('product_id')));
          $uom = explode(",",implode(",",$this->input->post('pr_uom_id')));
          $rpsf = explode(",",implode(",",$this->input->post('pr_rate_per_sqft')));
          $qty = explode(",",implode(",",$this->input->post('pr_quantity')));
          $rt = explode(",",implode(",",$this->input->post('pr_rate')));
          $dis = explode(",",implode(",",$this->input->post('pr_disc')));
          $amt = explode(",",implode(",",$this->input->post('pr_amount')));
          $gst = explode(",",implode(",",$this->input->post('product_gst')));
          $accwgt = explode(",",implode(",",$this->input->post('pr_accessories_weight')));

$pstock = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($pid[$i],$locId,$whId);
              $ostk = $pstock->stock;
              $nstk = $ostk - $qty[$i];
              $whsid = $pstock->warehouse_stock_id;
              $upstk['stock'] = $nstk; 
              $upstk['modified_on'] = date('Y-m-d H:i:s');
              $upstk['modified_by'] = $_SESSION['user_id'];
              $this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);
            }
          }
        }
      }

$dipayment = $this->Payment_model->get_invoice_payment_by_invoice_id($invoice_id);
      if(count($dipayment)>0)
      {
        $paydata['payment_id'] = $dipayment->payment_id;
        $odt = explode('/', $this->input->post('payment_date'));
        $paydata['payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
        $pmode = $paydata['payment_mode'] = $this->input->post('payment_mode');    
        $paydata['payment_amount'] = $this->input->post('payment_amount');
        if(($pmode == 'Cheque') || ($pmode == 'Post Date Cheque'))
        {
          $paydata['cheque_no'] = $this->input->post('cheque_no');
          $paydata['bank_name'] = $this->input->post('bank_name');
          $paydata['branch_name'] = $this->input->post('branch_name');
          $paydata['status']=1;
        }
        else
        {
          $paydata['cheque_no'] = '';
          $paydata['bank_name'] = '';
          $paydata['branch_name'] = '';
          $paydata['status']=0;
        }
        $paydata['modified_on'] = date('Y-m-d H:i:s');
        $paydata['modified_by'] = $_SESSION['user_id'];

$result = $this->Payment_model->update_payment($paydata);
      }

$result = $this->Payment_model->create_payment($paydata);*/

$invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$pdata['customer_phone'] = $cphone;

$invoice = $pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

if($dsoid!=0)
      {
        $ordsts['status']=5;
        $this->Invoice_model->update_order_status($ordsts,$dsoid);
      }

$this->Invoice_model->delete_tax_ledger_line_item_by_invoice_type_id($invoice_id);

$this->session->set_flashdata('add_success', 'Invoice has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $pdata['diprint'] = "0";
    $this->load->view('invoice/direct_invoice_printview',$pdata);
  }

/*public function update_direct_invoice()
  {  
    $invoice_id = $data['invoice_id']=$this->input->post('invoice_id');
    $ino = $this->input->post('invoice_no');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_total']=$this->input->post('tax_total');
    $data['round_off']=$this->input->post('round_off');
    $data['grand_total']=$this->input->post('grand_total');
    $data['payment_term_id']=$this->input->post('payment_term_id');
    $data['delivery_term_id']=$this->input->post('delivery_term_id');
    $data['freight_term_id']=$this->input->post('freight_term_id');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']='';
    $data['lr_rr_no']=$this->input->post('lr_rr_no');
    $data['eway_bill_no']=$this->input->post('eway_bill_no');
    $data['remarks']=$this->input->post('remarks');
    $nop = $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['net_weight']=$this->input->post('net_weight');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['packing_charges']=$this->input->post('packing_charges');
    $data['other_charges']=$this->input->post('other_charges');
    $lrbno = $this->input->post('lr_rr_bill_val');
    $data['destination_point']=$this->input->post('destination_point');
    $ewbno = $this->input->post('eway_bill_val');

if(!empty($_FILES['lr_rr_bill']['name']))
    {
      if($lrbno!=''){
        unlink('lrrrbill/'.$lrbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['lr_rr_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'lrrrbill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('lr_rr_bill'))
      {
        $uploadData = $this->upload->data();
        $data['lr_rr_bill'] = $profileName;
      }
      else
      {
        $data['lr_rr_bill'] = $lrbno;
      }
    }
    else
    {
      $data['lr_rr_bill'] = $lrbno;
    }

if(!empty($_FILES['eway_bill']['name']))
    {
      if($ewbno!=''){
        unlink('ewaybill/'.$ewbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['eway_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'ewaybill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('eway_bill'))
      {
        $uploadData = $this->upload->data();
        $data['eway_bill'] = $profileName;
      }
      else
      {
        $data['eway_bill'] = $ewbno;
      }
    }
    else
    {
      $data['eway_bill'] = $ewbno;
    }
    
    $result = $this->Invoice_model->update_invoice($data);

if ($result) {

$invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$badd='';
      $sadd = '';

if($invoice_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$this->Invoice_model->delete_invoice_barcode_by_id($invoice_id);
 for($i=1;$i<=$nop;$i++)
 {
 $rmnorep = str_replace('/', '-', $ino);
 $this->load->library('zend');
 $this->zend->load('Zend/Barcode');
 $bcode = $rmnorep.'_'.$i;
 $file = Zend_Barcode::draw('code128', 'image', array('text' => $bcode), array());
 $store_image = imagepng($file,"./invoicebarcode/{$bcode}.png");
 $this->Invoice_model->create_invoice_barcode($bcode,$invoice_id);
 }

$this->session->set_flashdata('add_success', 'Invoice has been updated successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $this->load->view('invoice/direct_invoice_printview',$pdata);
    //redirect('/deliverychallan');
  }*/

public function update_invoice()
  {  
    $invoice_id = $data['invoice_id']=$this->input->post('invoice_id');
    $ino=$this->input->post('invoice_no');
    $ordId = $data['order_id']=$this->input->post('order_id');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_total']=$this->input->post('tax_total');
    $data['round_off']=$this->input->post('round_off');
    $data['grand_total']=$this->input->post('grand_total');
    $data['payment_term_id']=$this->input->post('payment_term_id');
    $data['delivery_term_id']=$this->input->post('delivery_term_id');
    $data['freight_term_id']=$this->input->post('freight_term_id');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']='';
    $data['lr_rr_no']=$this->input->post('lr_rr_no');
    $data['eway_bill_no']=$this->input->post('eway_bill_no');
    $data['remarks']=$this->input->post('remarks');
    $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['net_weight']=$this->input->post('net_weight');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['packing_charges']=$this->input->post('packing_charges');
    $data['other_charges']=$this->input->post('other_charges');
    $lrbno = $this->input->post('lr_rr_bill_val');
    $data['destination_point']=$this->input->post('destination_point');
    $ewbno = $this->input->post('eway_bill_val');

if(!empty($_FILES['lr_rr_bill']['name']))
    {
      if($lrbno!=''){
        unlink('lrrrbill/'.$lrbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['lr_rr_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'lrrrbill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('lr_rr_bill'))
      {
        $uploadData = $this->upload->data();
        $data['lr_rr_bill'] = $profileName;
      }
      else
      {
        $data['lr_rr_bill'] = $lrbno;
      }
    }
    else
    {
      $data['lr_rr_bill'] = $lrbno;
    }

if(!empty($_FILES['eway_bill']['name']))
    {
      if($ewbno!=''){
        unlink('ewaybill/'.$ewbno);
      }
      $rmnorep = str_replace('/', '-', $ino);
      $ext = pathinfo($_FILES['eway_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'ewaybill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('eway_bill'))
      {
        $uploadData = $this->upload->data();
        $data['eway_bill'] = $profileName;
      }
      else
      {
        $data['eway_bill'] = $ewbno;
      }
    }
    else
    {
      $data['eway_bill'] = $ewbno;
    }
    
    $result = $this->Invoice_model->update_invoice($data);

if ($result) {

$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($ordId);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

if($order_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);

$pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);

$this->session->set_flashdata('add_success', 'Invoice has been updated successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $pdata['iprint'] = "0";
    $this->load->view('invoice/printview',$pdata);
    //redirect('/deliverychallan');
  }

public function convertToIndianCurrency($number) {
 $no = round($number);
 $decimal = round($number - ($no = floor($number)), 2) * 100; 
 $digits_length = 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');
 $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
 while ($i < $digits_length) {
 $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 > 9) ? 's' : null; 
 $str [] = ($number < 21) ? $words[$number] . ' ' . $digits[$counter] . $plural : $words[floor($number / 10) * 10] . ' ' . $words[$number % 10] . ' ' . $digits[$counter] . $plural;
 } else {
 $str [] = null;
 } 
 }
 
 $Rupees = implode(' ', array_reverse($str));
 $paise = ($decimal) ? "And Paise " . ($words[$decimal - $decimal%10]) ." " .($words[$decimal%10]) : '';
 return ($Rupees ? 'Rupees ' . $Rupees : '') . $paise . " Only";
}

public function sendotp()
  {
    $cusid = $_POST['cusid'];
    $pid = $_POST['pid'];
    $data['type'] = $type = $_POST['type'];
    $data['disc'] = $disc = $_POST['disc'];
    $data['v'] = $v = $_POST['v'];
    $rate = $_POST['rate'];
    $logid = $_SESSION['user_id'];
    $log_user = $this->Lead_model->user_view_details($logid);

$genset = $this->Quotation_model->get_general_settings_details();

$cusDetails = $this->Invoice_model->get_customer_view_by_id($cusid);
    if($type!='raw material')
    {
      $prodDetails = $this->Invoice_model->get_product_view_by_id($pid);
      $prodName = $prodDetails->product_name;
      $prod = 'Product';
    }
    else
    {
      $rmDetails = $this->Invoice_model->get_rawmaterial_by_id($pid);
      $prodName = $rmDetails->rawmaterial;
      $prod = 'Raw Material';
    }

$data['otp'] = $otp = mt_rand(1000,9999);

//$content = 'Cutomer '.$cusDetails->customer_name.' '.$prod.' '.$prodName.' gave '.$disc.'% discount. If you accept send this otp no to sales person. Otp Number is '.$otp;

$content = $log_user->displayname.' requests Discount '.$disc.'% exceeding the limit for Customer Name: '.$cusDetails->customer_name.' '.$prod.': '.$prodName.' Rate: '.$rate.' OTP: '.$otp;

//$log_user->displayname.' requests Discount '.$disc.'% exceeding the limit for Customer Name: '.$cusDetails->customer_name.' '.$prod.': '.$prodName.'OTP: '.$otp

$mno = explode(',', $genset->otp_message_mobile);
 for($i=0;$i<count($mno);$i++)
 {
 $cphone = $mno[$i];
 sendsms($cphone,$content,$genset->sms_auth_key,$genset->sms_sender_id);
 }

$this->load->view('invoice/confirm_otp',$data);
    //$rmdet = $this->Invoice_model->get_rm_details_by_rm_loc_id($rmid,$lid);
    //echo $rmdet->rawmaterial_uom."|".$rmdet->rawmaterial_uom_id."|".$rmdet->stk;
  }

public function direct_receipt_print($id)
  {
    $data['invoice_payment_details'] = $this->Invoice_model->get_invoice_payment_details_by_id($id);
    $pdata['drprint'] = "1";
    $this->load->view('invoice/direct_receipt_printview',$data);
  }

public function invoice_short_close()
  {
    $lid = $data['bid']=$_POST['id'];
    $this->load->view('invoice/invoice_short_close',$data);
  }

public function short_close()
  {
    $invId = $this->input->post('invoice_id');
    
    $invlist = $this->Invoice_model->get_invoice_by_id($invId);
    if($invlist->order_id!=0)
    {
      $ordId = $invlist->order_id;
      $workLog = $this->Invoice_model->get_invoice_by_order_id($ordId);
      $wlId = $workLog->work_log_id;
      $woId = $workLog->work_order_id;

$dcsts['status']=0;
      $this->Invoice_model->update_delivery_challan_status_by_order_id($dcsts,$woId);

$wlsts['status']=1;
      $this->Invoice_model->update_work_log_status($wlsts,$wlId);

$irsts['status']=2;
      $this->Invoice_model->update_issue_register_status($irsts,$woId);

$wosts['status']=3;
      $this->Invoice_model->update_work_order_status($wosts,$woId);

$ordsts['status']=4;
      $this->Invoice_model->update_order_status($ordsts,$ordId);

$this->Invoice_model->delete_payment_by_invoice_id($invId);
      $this->Invoice_model->delete_invoice_product_by_id($invId);
      $this->Invoice_model->delete_invoice_barcode_by_id($invId);
      $this->Invoice_model->delete_invoice_by_id($invId);
    }
    else
    {
      $this->Invoice_model->delete_payment_by_invoice_id($invId);
      $this->Invoice_model->delete_invoice_product_by_id($invId);
      $this->Invoice_model->delete_invoice_barcode_by_id($invId);
      $this->Invoice_model->delete_invoice_by_id($invId);
    }

$this->Invoice_model->delete_tax_ledger_line_item_by_invoice_type_id($invId);

$this->session->set_flashdata('add_success', 'Invoice has been Deleted successfully.');
    redirect('/invoice');

}

public function mark_dispatch()
  {
    $lid = $data['bid']=$_POST['id'];
    $data['invlist'] = $this->Invoice_model->get_invoice_by_id($lid);
    $this->load->view('invoice/mark_dispatch',$data);
  }

public function dispatch_invoice()
  {
    $invId = $this->input->post('invoice_id');
    $invsts['status']=1;
    $this->Invoice_model->update_invoice_status($invsts,$invId);

$paydata['order_id'] = 0;
    $paydata['invoice_id']=$invId;
    $odt = explode('/', $this->input->post('payment_date'));
    $paydata['payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
    $pmode = $paydata['payment_mode'] = $this->input->post('payment_mode');    
    $paydata['payment_amount'] = $this->input->post('payment_amount');
    if(($pmode == 'Cheque') || ($pmode == 'Post Date Cheque'))
    {
      $paydata['cheque_no'] = $this->input->post('cheque_no');
      $paydata['bank_name'] = $this->input->post('bank_name');
      $paydata['branch_name'] = $this->input->post('branch_name');
      $paydata['status']=1;
    }
    else
    {
      $paydata['cheque_no'] = '';
      $paydata['bank_name'] = '';
      $paydata['branch_name'] = '';
      $paydata['status']=0;
    }
    $paydata['created_on'] = date('Y-m-d H:i:s');
    $paydata['created_by'] = $_SESSION['user_id'];

$result = $this->Payment_model->create_payment($paydata);

$this->session->set_flashdata('add_success', 'Invoice has been Dispatched successfully.');
    redirect('/invoice');

}

public function approve_invoice()
  {
    $invoice_id = $pdata['bid']=$_POST['id'];

$invoice = $pdata['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);
      $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($invoice->order_id);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$badd='';
      $sadd = '';

if($order_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);

$this->load->view('invoice/approve_invoice',$pdata);
  }

public function approve_direct_invoice()
  {
    $invoice_id = $pdata['bid']=$_POST['id'];

$invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

if($invoice_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        $baddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_billing_address_id);
        $saddress = $this->Order_model->get_customer_address_by_id($invoice_list->customer_shipping_address_id);
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$pdata['customer_phone'] = $cphone;

$pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$this->load->view('invoice/approve_direct_invoice',$pdata);
  }

public function invoice_approve()
  {
    $invId = $this->input->post('invoice_id');
    $invsts['approve_status']=1;
    $this->Invoice_model->update_invoice_approve_status($invsts,$invId);

$this->session->set_flashdata('add_success', 'Invoice has been Approved successfully.');
    redirect('/invoice');

}

public function barcode_sample_download($id)
  {
    $inv_barcode = $this->Invoice_model->get_invoice_barcode_by_id($id);
    //$this->load->view('invoice/barcode_printview',$data);

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
            'font' => array(
                'bold' => true,
                'color' => array('rgb' => '000000')
            )
        );
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Barcode');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);

$i=2;
    $g_settings = general_setting_details();
    foreach($inv_barcode as $rms) {
      $invDet = $this->Invoice_model->invoice_details_by_id($rms['invoice_id']);
      $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($invDet->invoice_date),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $rms['invoice_barcode']);
      $i++;
      $invno = $invDet->invoice_no;
    }
    $ino = str_replace('/', '-', $invno);
    $filename='invoice_'.$ino.'.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
    //if you want to save it as .XLSX Excel 2007 format
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
    $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function create_customer()
  {
    $data['state_list'] = $this->Customer_model->get_state_list();

$this->load->view('invoice/create_customer',$data);
  }

public function customer_add()
  {

$last_id_value = $this->Customer_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['customer_code'] = date("Y").'/'.date('m').'/CUS001';
    }
    else
    {
      $lno = $last_id_value->customer_code;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $data['customer_code'] = date("Y").'/'.date('m').'/CUS'.$nval;
    }

$customerName = $data['customer_name']=$_POST['customer_name'];
    $data['customer_type']=1;
    $data['customer_category']=1;
    $data['company_name']='';
    $data['pan_no']='';
    $data['gst_no']='';
    $data['address']='';
    $data['website']='';
    $data['bank_name']='';
    $data['branch_name']='';
    $data['account_no']='';
    $data['payment_term']=0;
    $data['lead_id'] = 0;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['is_self']=0;

$data['intrested_products'] = '';
    $data['state_id']=$_POST['stid']; 
    $data['pincode']=''; 
    $data['opening_balance']=$_POST['obal'];
    $data['crdr']=$_POST['cr_dr'];
    $data['is_sister_concern']=0;
    $data['sister_concern_location_id']=0;
    
    $result = $this->Customer_model->create_customer($data);

if ($result) {
      $last_id_value = $this->Customer_model->last_id();
      $last_value=$last_id_value->count_val;
      $customer_id = $last_value;

if($_POST['email_id']!='')
      {
        $data1['customer_id'] =  $customer_id;
        $data1['email_type_id'] = 0;
        $data1['email_id'] = $_POST['email_id'];
        $this->Customer_model->create_customer_email($data1);
      }

if($_POST['phone_no']!='')
      {
        $pno = $_POST['phone_no'];    
        $data2['customer_id'] =  $customer_id;
        $data2['phone_type_id'] = 0;
        $data2['phone_no'] = $pno;
        $this->Customer_model->create_customer_phone($data2);
      }

if($_POST['baddr']!='')
      {
        $atid = $_POST['batid'];
        $adress = $_POST['baddr'];
        $basid = $_POST['basid'];
        $bapin = $_POST['bapin'];
        $data3['customer_id'] =  $customer_id;
        $data3['address_type_id'] = $atid;
        $data3['address'] = $adress;
        $data3['address_state_id'] = $basid;
        $data3['address_pincode'] = $bapin;
        $this->Customer_model->create_customer_address($data3);
      }

if($_POST['saddr']!='')
      {
        $atid = $_POST['satid'];
        $adress = $_POST['saddr'];
        $sasid = $_POST['sasid'];
        $sapin = $_POST['sapin'];
        $data4['customer_id'] =  $customer_id;
        $data4['address_type_id'] = $atid;
        $data4['address'] = $adress;
        $data4['address_state_id'] = $sasid;
        $data4['address_pincode'] = $sapin;
        $this->Customer_model->create_customer_address($data4);
      }

$customer_list = $this->Invoice_model->get_customer_list();

$option = '<option value="">Select Customer</option>';
 foreach($customer_list as $clist)
 { 
 $cusDetails = $this->Invoice_model->get_customer_contact_details($clist['customer_id']);
 $pno = $cusDetails->phone_no;
 if($clist['customer_id'] == $customer_id)
 {
 $option.='<option value='.$clist['customer_id'].' selected>'.$clist['customer_code'].' - '.$clist['customer_name'].' - '.$pno.'</option>';
 }
 else
 {
 $option.='<option value='.$clist['customer_id'].'>'.$clist['customer_code'].' - '.$clist['customer_name'].' - '.$pno.'</option>';
 }
 }
 echo $option."|".$customer_id;

}
  }

public function invoice_upload()
  {    
    $this->load->view('invoice/invoice_upload');
  }

public function sampleupload()
  {
    $objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
            'font' => array(
                'bold' => true,
                'color' => array('rgb' => '000000')
            )/*,
            'alignment' => array(
                'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
            )*/
        );
    //$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(20);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Customer Contact No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Delivery Date');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Type');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Company');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Warehouse');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Unit');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Delivery Type');
    $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Product');
    $objPHPExcel->getActiveSheet()->getStyle('I1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Rawmaterial');
    $objPHPExcel->getActiveSheet()->getStyle('J1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('K1', 'UOM');
    $objPHPExcel->getActiveSheet()->getStyle('K1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Rate/sq.ft');
    $objPHPExcel->getActiveSheet()->getStyle('L1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Quantity');
    $objPHPExcel->getActiveSheet()->getStyle('M1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('N1', 'Discount');
    $objPHPExcel->getActiveSheet()->getStyle('N1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('O1', 'Payment Term');
    $objPHPExcel->getActiveSheet()->getStyle('O1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('P1', 'Delivery Term');
    $objPHPExcel->getActiveSheet()->getStyle('P1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('Q1', 'Freight Term');
    $objPHPExcel->getActiveSheet()->getStyle('Q1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('R1', 'Transport');
    $objPHPExcel->getActiveSheet()->getStyle('R1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('S1', 'Destination Point');
    $objPHPExcel->getActiveSheet()->getStyle('S1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('T1', 'Packing & Forwarding Charge');
    $objPHPExcel->getActiveSheet()->getStyle('T1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('U1', 'Other Charge');
    $objPHPExcel->getActiveSheet()->getStyle('U1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('V1', 'No of Packets');
    $objPHPExcel->getActiveSheet()->getStyle('V1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('W1', 'Nett Weight');
    $objPHPExcel->getActiveSheet()->getStyle('W1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('X1', 'Gross Weight');
    $objPHPExcel->getActiveSheet()->getStyle('X1')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('Y1', 'Customer Name');
    $objPHPExcel->getActiveSheet()->getStyle('Y1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('Z1', 'State');
    $objPHPExcel->getActiveSheet()->getStyle('Z1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AA1', 'Billing Address');
    $objPHPExcel->getActiveSheet()->getStyle('AA1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AB1', 'Billing State');
    $objPHPExcel->getActiveSheet()->getStyle('AB1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AC1', 'Billing Pincode');
    $objPHPExcel->getActiveSheet()->getStyle('AC1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AD1', 'Shipping Address');
    $objPHPExcel->getActiveSheet()->getStyle('AD1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AE1', 'Shipping State');
    $objPHPExcel->getActiveSheet()->getStyle('AE1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('AF1', 'Shipping Pincode');
    $objPHPExcel->getActiveSheet()->getStyle('AF1')->applyFromArray($styleArray);

$objWorkSheet = $objPHPExcel->createSheet('2');
    $objPHPExcel->setActiveSheetIndex(1)->getRowDimension(1)->setRowHeight(20);
    $objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', 'Type');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('A1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

/*$prodType = $this->Product_model->get_product_type();

foreach($prodType as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A'.$i, $row['product_type']);
      $i++;
      $j++;      
    }*/
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A2', 'Raw Material');
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A3', 'Trading Product');
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A4', 'Standard Product');

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('B1', 'Location');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('B1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$loc = $this->Order_model->get_location();

foreach($loc as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('B'.$i, $row['location_name']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('C')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('C1', 'Warehouse');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('C1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$delper = $this->Invoice_model->get_warehouse_list();

foreach($delper as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('C'.$i, $row['warehouse_name']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('D')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D1', 'Delivery Type');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('D1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

/*$appli = $this->Product_model->get_active_application();

foreach($appli as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D'.$i, $row['application']);
      $i++;
      $j++;      
    }*/
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D2', 'Delivery');
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D3', 'Dispatch');

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('E1', 'UOM');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('E1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$uomlist = $this->Product_model->get_uom_list();

foreach($uomlist as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('E'.$i, $row['uom']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('F')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('F1', 'Raw Material');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('F1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$refer = $this->Invoice_model->get_rawmaterial_list();

foreach($refer as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('F'.$i, $row['rawmaterial']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('G')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('G1', 'Product');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('G1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$prodlist = $this->Order_model->get_product_list();

foreach($prodlist as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('G'.$i, $row['product_name']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('H')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('H1', 'Payment Term');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('H1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$pterm = $this->Invoice_model->get_inv_payment_term();

foreach($pterm as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('H'.$i, $row['payment_term']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('I')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('I1', 'Delivery Term');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('I1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$dterm = $this->Invoice_model->get_so_delivery_term();

foreach($dterm as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('I'.$i, $row['delivery_term']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('J')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('J1', 'Freight Term');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('J1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$dterm = $this->Invoice_model->get_freight_term();

foreach($dterm as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('J'.$i, $row['freight_term']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('K')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('K1', 'State');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('K1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$state_list = $this->Customer_model->get_state_list();

foreach($state_list as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('K'.$i, $row['state']);
      $i++;
      $j++;      
    }

$objWorkSheet->setTitle("Dropdown Information");

$filename='Sample_Direct_Invoice.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output'); 
  }

public function invoice_import()
 {
 if(isset($_POST["import"]))
 {
 PHPExcel_IOFactory::createReader('Excel2007');
 $filename=$_FILES["file"]["tmp_name"];
 if($_FILES["file"]["size"] > 0)
 {
 try
 {
 $objPHPExcel = PHPExcel_IOFactory::load($filename);
 }catch(Exception $e)
 {
 die('Error loading file "'.pathinfo($filename,PATHINFO_BASENAME).'": '.$e->getMessage());
 }
 $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
 $arrayCount = count($allDataInSheet); // Here get total count of row in that Excel sheet
 //echo $arrayCount;exit;
 $ins=0;$alr=0;$emptrow=1;
 //print_r($allDataInSheet[1]);exit;
 if(trim($allDataInSheet[1]["A"])=='Date' && trim($allDataInSheet[1]["B"])=='Customer Contact No' && trim($allDataInSheet[1]["C"])=='Delivery Date' && trim($allDataInSheet[1]["D"])=='Type' && trim($allDataInSheet[1]["E"])=='Company' && trim($allDataInSheet[1]["F"])=='Warehouse' && trim($allDataInSheet[1]["G"])=='Unit' && trim($allDataInSheet[1]["H"])=='Delivery Type' && trim($allDataInSheet[1]["I"])=='Product' && trim($allDataInSheet[1]["J"])=='Rawmaterial' && trim($allDataInSheet[1]["K"])=='UOM' && trim($allDataInSheet[1]["L"])=='Rate/sq.ft' && trim($allDataInSheet[1]["M"])=='Quantity' && trim($allDataInSheet[1]["N"])=='Discount' && trim($allDataInSheet[1]["O"])=='Payment Term' && trim($allDataInSheet[1]["P"])=='Delivery Term' && trim($allDataInSheet[1]["Q"])=='Freight Term' && trim($allDataInSheet[1]["R"])=='Transport' && trim($allDataInSheet[1]["S"])=='Destination Point' && trim($allDataInSheet[1]["T"])=='Packing & Forwarding Charge' && trim($allDataInSheet[1]["U"])=='Other Charge' && trim($allDataInSheet[1]["V"])=='No of Packets' && trim($allDataInSheet[1]["W"])=='Nett Weight' && trim($allDataInSheet[1]["X"])=='Gross Weight' && trim($allDataInSheet[1]["Y"])=='Customer Name' && trim($allDataInSheet[1]["Z"])=='State' && trim($allDataInSheet[1]["AA"])=='Billing Address' && trim($allDataInSheet[1]["AB"])=='Billing State' && trim($allDataInSheet[1]["AC"])=='Billing Pincode' && trim($allDataInSheet[1]["AD"])=='Shipping Address' && trim($allDataInSheet[1]["AE"])=='Shipping State' && trim($allDataInSheet[1]["AF"])=='Shipping Pincode' )
 {
 $val=0;$iv='';$err='';$pid='';
 for($i=2;$i<=$arrayCount;$i++){
 $pu = '';$idate='';$d='';$loc='';$ddate='';$typ='';$warh='';$deltype='';$pname='';$rmname = '';$rpsf = '';$pqty = '';$discou = '';$pterm='';$dterm='';$fterm='';$trans='';$despoint='';$paf = '';$ochar = '';$nopac = '';$nwgt = '';$gwgt = '';$um = '';
 if(trim($allDataInSheet[1]["A"])=='' && trim($allDataInSheet[1]["B"])==''&&trim($allDataInSheet[1]["C"])=='' && trim($allDataInSheet[1]["D"])=='' && trim($allDataInSheet[1]["E"])=='' && trim($allDataInSheet[1]["F"])=='' && trim($allDataInSheet[1]["G"])=='' && trim($allDataInSheet[1]["H"])=='' && trim($allDataInSheet[1]["I"])=='' && trim($allDataInSheet[1]["J"])=='' && trim($allDataInSheet[1]["K"])=='' && trim($allDataInSheet[1]["L"])=='' && trim($allDataInSheet[1]["M"])=='' && trim($allDataInSheet[1]["N"])=='' && trim($allDataInSheet[1]["O"])=='' && trim($allDataInSheet[1]["P"])=='' && trim($allDataInSheet[1]["Q"])=='' && trim($allDataInSheet[1]["R"])=='' && trim($allDataInSheet[1]["S"])=='' && trim($allDataInSheet[1]["T"])=='' && trim($allDataInSheet[1]["U"])=='' && trim($allDataInSheet[1]["V"])=='' && trim($allDataInSheet[1]["W"])=='' && trim($allDataInSheet[1]["X"])=='' && trim($allDataInSheet[1]["Y"])=='' && trim($allDataInSheet[1]["Z"])=='' && trim($allDataInSheet[1]["AA"])=='' && trim($allDataInSheet[1]["AB"])=='' && trim($allDataInSheet[1]["AC"])=='' && trim($allDataInSheet[1]["AD"])=='' && trim($allDataInSheet[1]["AE"])=='' && trim($allDataInSheet[1]["AF"])=='')
 {
 $emptrow++;
 $errmsg = '1';
 }
 else
 {
 if(trim($allDataInSheet[$i]["A"])!='')
 {
 $proddata['invoice_date'] = date_format(date_create(trim($allDataInSheet[$i]["A"])),'Y-m-d')." 00:00";
 } 
 else
 {
 $idate = $i;
 }

if(trim($allDataInSheet[$i]["B"])!='')
              {
                //$dealer = $this->Order_model->dealer_phone_no_unique(trim($allDataInSheet[$i]["B"]));
                $dealer = $this->Order_model->customer_phone_no_unique(trim($allDataInSheet[$i]["B"]));
                if(count($dealer)>0)
                {
                  $proddata['customer_id'] = $dealer->customer_id;
                  $customerdet = $this->Order_model->get_customer_view_by_id($dealer->customer_id);
                  $dbill_address = $this->Order_model->get_dealer_first_billing_address_by_id($dealer->customer_id);
                  $dship_address = $this->Order_model->get_dealer_first_shipping_address_by_id($dealer->customer_id);
                  $stid = $dbill_address->address_state_id;
                  $badd = $sadd = '';
                  if(count($dbill_address)>0)
                  {
                    $badd = $dbill_address->customer_address_id;
                  }
                  if(count($dship_address)>0)
                  {
                    $sadd = $dship_address->customer_address_id;
                  }

if($badd=='')
                  {
                    $proddata['customer_billing_address_id'] = $badd = $sadd;
                  }
                  else
                  {
                    $proddata['customer_billing_address_id'] = $badd = $badd;
                  }
                  if($sadd=='')
                  {
                    $proddata['customer_shipping_address_id'] = $sadd = $badd;
                  }
                  else
                  {
                    $proddata['customer_shipping_address_id'] = $sadd = $sadd;
                  }
                }
                else
                {
                  if(trim($allDataInSheet[$i]["Y"])!='' && trim($allDataInSheet[$i]["Z"])!='' && trim($allDataInSheet[$i]["AA"])!='' && trim($allDataInSheet[$i]["AB"])!='' && trim($allDataInSheet[$i]["AC"])!='' && trim($allDataInSheet[$i]["AD"])!='' && trim($allDataInSheet[$i]["AE"])!='' && trim($allDataInSheet[$i]["AF"])!='')
                  {
                    $last_id_value = $this->Customer_model->last_id();
                    if(count($last_id_value)==0)
                    {
                      $data['customer_code'] = date("Y").'/'.date('m').'/CUS001';
                    }
                    else
                    {
                      $lno = $last_id_value->customer_code;
                      $exlno = substr($lno,11);
                      $next_value = (int)$exlno + 1;
                      $slen = strlen($next_value);
                      if($slen==1)
                        $nval = '00'.$next_value;
                      else if($slen==2)
                        $nval = '0'.$next_value;
                      else
                        $nval = $next_value;
                      $data['customer_code'] = date("Y").'/'.date('m').'/CUS'.$nval;
                    }

$statelist = $this->Invoice_model->get_state_by_name(trim($allDataInSheet[$i]["Z"]));

$data['customer_name']=trim($allDataInSheet[$i]["Y"]);
                    $data['customer_type']=1;
                    $data['customer_category']=1;
                    $data['company_name']='';
                    $data['pan_no']='';
                    $data['gst_no']='';
                    $data['address']='';
                    $data['website']='';
                    $data['bank_name']='';
                    $data['branch_name']='';
                    $data['account_no']='';
                    $data['payment_term']=0;
                    $data['lead_id'] = 0;
                    $data['created_on'] = date('Y-m-d H:i:s');
                    $data['created_by'] = $_SESSION['user_id'];
                    $data['is_self']=0;

$data['intrested_products'] = '';
                    $data['state_id']=$statelist->state_id; 
                    $data['pincode']=''; 
                    $data['opening_balance']=0;
                    $data['crdr']=0;
                    $data['is_sister_concern']=0;
                    $data['sister_concern_location_id']=0;
                    
                    $result = $this->Customer_model->create_customer($data);
                    if ($result) {
                      $last_id_value = $this->Customer_model->last_id();
                      $last_value=$last_id_value->count_val;
                      $customer_id = $last_value;

if(trim($allDataInSheet[$i]["B"])!='')
                      {
                        //$pno = trim($allDataInSheet[1]["B"]);    
                        $data2['customer_id'] =  $customer_id;
                        $data2['phone_type_id'] = 0;
                        $data2['phone_no'] = trim($allDataInSheet[$i]["B"]);
                        $this->Customer_model->create_customer_phone($data2);
                      }

if(trim($allDataInSheet[$i]["AA"])!='' && trim($allDataInSheet[$i]["AB"])!='' && trim($allDataInSheet[$i]["AC"])!='')
                      {
                        $bstatelist = $this->Invoice_model->get_state_by_name(trim($allDataInSheet[$i]["AB"]));
                        $atid = 1;
                        $adress = trim($allDataInSheet[$i]["AA"]);
                        $basid = $bstatelist->state_id;
                        $bapin = trim($allDataInSheet[$i]["AC"]);
                        $data3['customer_id'] =  $customer_id;
                        $data3['address_type_id'] = $atid;
                        $data3['address'] = $adress;
                        $data3['address_state_id'] = $basid;
                        $data3['address_pincode'] = $bapin;
                        $this->Customer_model->create_customer_address($data3);
                      }

if(trim($allDataInSheet[$i]["AD"])!='' && trim($allDataInSheet[$i]["AE"])!='' && trim($allDataInSheet[$i]["AF"])!='')
                      {
                        $sstatelist = $this->Invoice_model->get_state_by_name(trim($allDataInSheet[$i]["AE"]));
                        $atid = 2;
                        $adress = trim($allDataInSheet[$i]["AD"]);
                        $sasid = $sstatelist->state_id;
                        $sapin = trim($allDataInSheet[$i]["AF"]);
                        $data4['customer_id'] =  $customer_id;
                        $data4['address_type_id'] = $atid;
                        $data4['address'] = $adress;
                        $data4['address_state_id'] = $sasid;
                        $data4['address_pincode'] = $sapin;
                        $this->Customer_model->create_customer_address($data4);
                      }
                    }

$proddata['customer_id'] = $customer_id;
                    $customerdet = $this->Order_model->get_customer_view_by_id($customer_id);
                    $dbill_address = $this->Order_model->get_dealer_first_billing_address_by_id($customer_id);
                    $dship_address = $this->Order_model->get_dealer_first_shipping_address_by_id($customer_id);
                    $stid = $dbill_address->address_state_id;
                    $badd = $sadd = '';
                    if(count($dbill_address)>0)
                    {
                      $badd = $dbill_address->customer_address_id;
                    }
                    if(count($dship_address)>0)
                    {
                      $sadd = $dship_address->customer_address_id;
                    }

}
                  else
                  {
                    $d = $i;
                  }
                }
              }
              else
              {
                $d = $i;
              }
              if(trim($allDataInSheet[$i]["C"])!='')
              {
                 $proddata['delivery_date'] = date_format(date_create(trim($allDataInSheet[$i]["C"])),'Y-m-d')." 00:00";
              }              
              else
              {
                $ddate = $i;
              }

if(trim($allDataInSheet[$i]["D"])!='')
              {
                if(trim($allDataInSheet[$i]["D"])=='Raw Material')
                {
                  $proddata['type'] = 'raw material';
                }
                else if(trim($allDataInSheet[$i]["D"])=='Trading Product')
                {
                  $proddata['type'] = 'trading product';
                }
                else if(trim($allDataInSheet[$i]["D"])=='Standard Product')
                {
                  $proddata['type'] = 'standard product';
                }
                else
                {
                  $typ = $i;
                }
              }
              else
              {
                $typ = $i;
              }

if(trim($allDataInSheet[$i]["E"])!='')
              {
                $loclist = $this->Order_model->get_location_by_name(trim($allDataInSheet[$i]["E"]));
                if(count($loclist)>0)
                {
                  $locId = $proddata['location_id'] = $loclist->location_id;
                }
                else
                {
                  $locId = '';
                  $loc = $i;
                }
              }
              else
              {
                $locId = '';
                $loc = $i;
              }

if(trim($allDataInSheet[$i]["F"])!='')
              {
                if($locId!='')
                {
                  $locwarlist = $this->Invoice_model->get_warehouse_by_location_id($locId);
                  if(count($locwarlist)>0)
                  {
                    $wid = '';
                    foreach($locwarlist as $lwlist)
                    {
                      if($lwlist['warehouse_name'] == trim($allDataInSheet[$i]["F"]))
                      {
                        $wid = $lwlist['warehouse_id'];
                      }
                    }
                    if($wid!='')
                      $proddata['warehouse_id'] = $wid;
                    else
                      $warh = $i;
                  }
                  else
                  {
                    $warh = $i;
                  }
                }
                else
                {
                  $warh = $i;
                }
              }
              else
              {
                $warh = $i;
              }

if(trim($allDataInSheet[$i]["G"])!='')
              {
                if(trim($allDataInSheet[$i]["G"])=='Unit 1')
                {
                  $punit = $proddata['prod_unit'] = 'unit1';
                }
                else if(trim($allDataInSheet[$i]["G"])=='Unit 2')
                {
                  $punit = $proddata['prod_unit'] = 'unit2';
                }
                else
                {
                  $pu = $i;
                }
              }
              else
              {
                $pu = $i;
              }

if(trim($allDataInSheet[$i]["H"])!='')
              {
                if(trim($allDataInSheet[$i]["H"])=='Delivery')
                {
                  $proddata['delivery_type'] = '0';
                }
                else if(trim($allDataInSheet[$i]["H"])=='Dispatch')
                {
                  $proddata['delivery_type'] = '1';
                }
                else
                {
                  $deltype = $i;
                }
              }
              else
              {
                $deltype = $i;
              }

$pd=0;
              if(trim($allDataInSheet[$i]["I"])!='' && trim($allDataInSheet[$i]["J"])=='')
              {
                $delterm = $this->Order_model->get_product_by_name(trim($allDataInSheet[$i]["I"]));
                if(count($delterm)>0)
                {
                  $whlocprod = $this->Invoice_model->get_warehouse_stock_by_loc_war_prod_id($locId,$wid,$delterm->product_id);
                  if(count($whlocprod)>0 && $whlocprod->stock>0)
                  {
                    $prodid = $ordprod['product_id'] = $delterm->product_id;
                    $pgst = $ordprod['product_gst'] = $delterm->gst;
                    $ordprod['accessories_weight'] = 0;
                    $pd=1;
                  }
                  else
                  {
                    $pname = $i;
                  }
                }
                else
                {
                  $pname = $i;
                }
              }

$rm=0;
              if(trim($allDataInSheet[$i]["J"])!='' && trim($allDataInSheet[$i]["I"])=='')
              {
                $delterm = $this->Invoice_model->get_rawmaterial_by_name(trim($allDataInSheet[$i]["J"]));
                //echo count($delterm);
                if(count($delterm)>0)
                {
                  $whlocrm = $this->Invoice_model->get_warehouse_stock_by_loc_war_rm_id($locId,$wid,$delterm->rawmaterial_id);
                  /*print_r($whlocrm);
                  echo count($whlocrm);
                  echo $whlocrm->stock;*/
                  if(count($whlocrm)>0 && $whlocrm->stock>0)
                  {
                    /*echo $whlocrm->stock;
                    echo "count_if";*/
                    $rmid = $ordprod['rawmaterial_id'] = $delterm->rawmaterial_id;
                    $rmcat = $this->Invoice_model->get_rawmaterialcategory_by_id($delterm->rawmaterial_category_id);
                    $pgst = $ordprod['product_gst'] = $rmcat->gst;
                    $ordprod['accessories_weight'] = 0;
                    $rm=1;
                  }
                  else
                  {
                    $rmname = $i;
                  }
                }
                else
                {
                  $rmname = $i;
                }
              }

if(trim($allDataInSheet[$i]["K"])!='')
              {
                $uom = $this->Product_model->get_uom_by_name(trim($allDataInSheet[$i]["K"]));
                if(count($uom)>0)
                {
                  $ordprod['uom_id'] = $uom->uom_id;
                }
                else
                {
                  $um = $i;
                }
              }

if(trim($allDataInSheet[$i]["L"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["L"])))
                  $orate = $ordprod['rate_per_sqft'] = trim($allDataInSheet[$i]["L"]);
                else
                  $rpsf = $i;
              }
              else
              {
                $rpsf = $i;
              }

if(trim($allDataInSheet[$i]["M"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["M"])))
                  $oqty = $ordprod['quantity'] = trim($allDataInSheet[$i]["M"]);
                else
                  $pqty = $i;
              }
              else
              {
                $pqty = $i;
              }

if(trim($allDataInSheet[$i]["N"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["N"])))
                  $disvalue = $ordprod['disc'] = trim($allDataInSheet[$i]["N"]);
                else
                  $discou = $i;
              }
              else
              {
                $disvalue = $ordprod['disc'] = 0;
              }

if(trim($allDataInSheet[$i]["O"])!='')
              {
                $payterm = $this->Paymentterm_model->checkPaymenttermUnique(trim($allDataInSheet[$i]["O"]));
                if(count($payterm)>0)
                {
                  $proddata['payment_term_id'] = $payterm->payment_term_id;
                }
                else
                {
                  $pterm = $i;
                }
              }
              else
              {
                $pterm = $i;
              }

if(trim($allDataInSheet[$i]["P"])!='')
              {
                $delterm = $this->Deliveryterm_model->checkDeliverytermUnique(trim($allDataInSheet[$i]["P"]));
                if(count($delterm)>0)
                {
                  $proddata['delivery_term_id'] = $delterm->delivery_term_id;
                }
                else
                {
                  $dterm = $i;
                }
              }
              else
              {
                $dterm = $i;
              }

if(trim($allDataInSheet[$i]["Q"])!='')
              {
                $delterm = $this->Invoice_model->checkFreighttermUnique(trim($allDataInSheet[$i]["Q"]));
                if(count($delterm)>0)
                {
                  $proddata['freight_term_id'] = $delterm->freight_term_id;
                }
                else
                {
                  $fterm = $i;
                }
              }
              else
              {
                $fterm = $i;
              }

if(trim($allDataInSheet[$i]["R"])!='')
              {
                $proddata['transporter'] = trim($allDataInSheet[$i]["R"]);
              }
              else
              {
                $proddata['transporter'] = '';
              }

if(trim($allDataInSheet[$i]["S"])!='')
              {
                $proddata['destination_point'] = trim($allDataInSheet[$i]["S"]);
              }
              else
              {
                $proddata['destination_point'] = '';
              }

if(trim($allDataInSheet[$i]["T"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["T"])))
                  $packcharge = $proddata['packing_charges'] = trim($allDataInSheet[$i]["T"]);
                else
                  $paf = $i;
              }
              else
              {
                $packcharge = $proddata['packing_charges'] = 0;
              }

if(trim($allDataInSheet[$i]["U"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["U"])))
                  $ocharge = $proddata['other_charges'] = trim($allDataInSheet[$i]["U"]);
                else
                  $ochar = $i;
              }
              else
              {
                $ocharge = $proddata['other_charges'] = 0;
              }

if(trim($allDataInSheet[$i]["V"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["V"])))
                  $nopackets = $proddata['no_of_packets'] = trim($allDataInSheet[$i]["V"]);
                else
                  $nopac = $i;
              }
              else
              {
                $nopac = $i;
              }

if(trim($allDataInSheet[$i]["W"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["W"])))
                  $proddata['net_weight'] = trim($allDataInSheet[$i]["W"]);
                else
                  $nwgt = $i;
              }
              else
              {
                $nwgt = $i;
              }

if(trim($allDataInSheet[$i]["X"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["X"])))
                  $proddata['gross_weight'] = trim($allDataInSheet[$i]["X"]);
                else
                  $gwgt = $i;
              }
              else
              {
                $gwgt = $i;
              }

/*print_r($proddata);
 echo " ";
 echo $pu .'=pu '.$idate.'=idate '.$d.'=d '.$loc.'=loc '.$ddate.'=ddate '.$typ.'=typ '.$warh.'=warh '.$deltype.'=deltype '.$pname.'=pname '.$rmname. '=rmname '.$rpsf. '=rpsf '.$pqty. '=pqty '.$discou. '=discou '.$pterm.'=pterm '.$dterm.'=dterm '.$fterm.'=fterm '.$trans.'=trans '.$despoint.'=despoint '.$paf. '=paf '.$ochar. '=ochar '.$nopac. '=nopac '.$nwgt. '=nwgt '.$gwgt. '=gwgt '.$um. '=um ';exit;*/

}

if($pu == '' && $idate=='' && $d=='' && $loc=='' && $ddate=='' && $typ=='' && $warh=='' && $deltype=='' && $pname=='' && $rmname == '' && $rpsf == '' && $pqty == '' && $discou == '' && $pterm=='' && $dterm=='' && $fterm=='' && $trans=='' && $despoint=='' && $paf == '' && $ochar == '' && $nopac == '' && $nwgt == '' && $gwgt == '' && $um == '')
            {
              //echo "if";exit;
              $tamt=0;$ttot=0;$roff=0;$totamt=0;
              $proddata['taxable_amount']=0;
              $proddata['tax_total']=0;
              $proddata['round_off']=0;
              $proddata['grand_total']=0;
              $proddata['vehicle_no']='';
              $proddata['lr_rr_no']='';
              $proddata['eway_bill_no']='';
              $proddata['lr_rr_bill']='';
              $proddata['eway_bill']='';
              $proddata['remarks']='';
              $proddata['created_on'] = date('Y-m-d H:i:s');
              $proddata['created_by'] = $_SESSION['user_id'];
              $locDetails = $this->Invoice_model->get_location_by_id($locId);
              $last_id_value = $this->Invoice_model->last_id_by_loc_code($locDetails->location_code);
              $fin2start = $_SESSION['fin2start'];
              $fin2end = $_SESSION['fin2end'];

$finhi = $fin2start.'-'.$fin2end;

if(count($last_id_value)==0)
              {
                $ino = $proddata['invoice_no'] = $locDetails->location_code.'-001/'.$fin2start.'-'.$fin2end;
              }
              else
              {
                $lno = $last_id_value->invoice_no;
                $exlno = explode('/', $lno);
                if($finhi == $exlno[1])
                {
                  $valexp = explode('-', $exlno[0]);
                  $next_value = (int)$valexp[1] + 1;
                  $slen = strlen($next_value);
                  if($slen==1)
                    $nval = '00'.$next_value;
                  else if($slen==2)
                    $nval = '0'.$next_value;
                  else
                    $nval = $next_value;
                  $ino = $proddata['invoice_no'] = $locDetails->location_code.'-'.$nval.'/'.$finhi;
                }
                else
                {
                  $ino = $proddata['invoice_no'] = $locDetails->location_code.'-001/'.$finhi;
                }
                $proddata['direct_so_id']=0;
                $result = $this->Invoice_model->create_direct_invoice($proddata);
                if($result)
                {
                  $last_id_value = $this->Invoice_model->last_id();
                  $last_value=$last_id_value->count_val;
                  $invoice_id = $last_value;
                  $ordprod['invoice_id'] = $invoice_id;

if($rm==1)
                  {
                    $ordprod['rm_uom_id'] = $ordprod['uom_id'];
                    $ordprod['rm_rate_per_sqft'] = $ordprod['rate_per_sqft'];
                    $ordprod['rm_quantity'] = $ordprod['quantity'];
                    $ordprod['rm_disc'] = $ordprod['disc'];
                    $rate = $orate * $oqty;
                    $ordprod['rm_rate'] = $rate;
                    $disccalc = ($rate*$disvalue)/100;
                    $amout = $rate-$disccalc;
                    $ordprod['rm_amount'] = $amout;
                    $this->Invoice_model->create_direct_invoice_rawmaterial($ordprod);

$stockdet = $this->Invoice_model->get_whstock_rm_details_by_rm_loc_wh_id($rmid,$locId,$wid);
                    $reqstock = $oqty;
                    $s=0;
                    if($stockdet->stk>=$reqstock)
                    {
                      $stk = $reqstock;
                      $s=1;
                    }
                    else
                    {
                      $reqstock = $reqstock - $stockdet->stk;
                      $stk = $stockdet->stk;
                    }

$whsid = $stockdet->warehouse_stock_id;
                    $stok = $stockdet->stk;
                    $fstk = $stok-$stk;
                    $upstk['stock'] = $fstk;
                    $upstk['modified_on'] = date('Y-m-d H:i:s');
                    $upstk['modified_by'] = $_SESSION['user_id'];

$this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);
                  }
                  else
                  {
                    $ordprod['pr_uom_id'] = $ordprod['uom_id'];
                    $ordprod['pr_rate_per_sqft'] = $ordprod['rate_per_sqft'];
                    $ordprod['pr_quantity'] = $ordprod['quantity'];
                    $ordprod['pr_disc'] = $ordprod['disc'];
                    $rate = $orate * $oqty;
                    $ordprod['pr_rate'] = $rate;
                    $disccalc = ($rate*$disvalue)/100;
                    $amout = $rate-$disccalc;
                    $ordprod['pr_amount'] = $amout;
                    $this->Invoice_model->create_direct_invoice_product($ordprod);

$pstock = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($prodid,$locId,$wid);
                    $ostk = $pstock->stock;
                    $nstk = $ostk - $oqty;
                    $whsid = $pstock->warehouse_stock_id;
                    $upstk['stock'] = $nstk; 
                    $upstk['modified_on'] = date('Y-m-d H:i:s');
                    $upstk['modified_by'] = $_SESSION['user_id'];
                    $this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);
                  }
                  if($rm==1)
                  {
                    $invoice_product_list = $this->Invoice_model->get_invoice_product_by_rawmaterial_id($invoice_id);
                  }
                  else
                  {
                    $invoice_product_list = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
                  }
                  //print_r($invoice_product_list);
                  foreach($invoice_product_list as $oplist)
                  {
                    $tax = (($oplist['amount']*$oplist['product_gst'])/100)*2;
                    $tamt+=$oplist['amount'];
                    $ttot+=$tax;
                  }
                  $tottaxamt = $tamt+$ttot;
                  $totamt = round($tottaxamt);
                  $roff = $totamt-$tottaxamt;
                  $uporder['taxable_amount'] = $tamt;
                  $uporder['tax_total'] = $ttot;
                  $uporder['round_off'] = number_format($roff,2);
                  $uporder['grand_total'] = $totamt;
                  $uporder['invoice_id'] = $invoice_id;
                  //print_r($uporder);exit;
                  $this->Invoice_model->update_invoice_amount_value($uporder);

for($s=1;$s<=$nop;$s++)
 {
 $rmnorep = str_replace('/', '-', $ino);
 $this->load->library('zend');
 $this->zend->load('Zend/Barcode');
 $bcode = $rmnorep.'_'.$s;
 $file = Zend_Barcode::draw('code128', 'image', array('text' => $bcode), array());
 $store_image = imagepng($file,"./invoicebarcode/{$bcode}.png");
 $this->Invoice_model->create_invoice_barcode($bcode,$invoice_id);
 }

if($stid == 33)
                  {
                    $cgstledgname = 'OUTPUT CGST '.$pgst.'%';
                    $cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$locId);
                    if(count($cgstledg)>0)
                    {
                      $cgst = $ttot/2;
                      $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                      $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
                      $cgstdata['tax_type'] = 0;
                      $cgstdata['type'] = 'Invoice Tax';
                      $cgstdata['type_id'] = $invoice_id;
                      $cgstdata['amount'] = $cgst;
                      $cgstdata['status'] = 0;
                      $cgstdata['created_on'] = date('Y-m-d H:i:s');
                      $cgstdata['created_by'] = $_SESSION['user_id'];
                      $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
                    }
                    else
                    {
                      $led['type']='Liabilities';
                      $led['account_attributes_id']=10;
                      $led['location_id']=$locId;
                      $led['remarks']='';
                      $led['opening_balance']=0;
                      $led['status'] = 0;
                      $led['created_on'] = date('Y-m-d H:i:s');
                      $led['created_by'] = $_SESSION['user_id'];
                      $led['ledger_code']='';
                      $led['crdr']=0;
                      $led['tax_ledger_status']=1;
                      $led['ledger_list']=$cgstledgname;
                      $this->Ledger_model->create_ledger_list($led);

$cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$locId);
                      if(count($cgstledg)>0)
                      {
                        $cgst = $ttot/2;
                        $cgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                        $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
                        $cgstdata['tax_type'] = 0;
                        $cgstdata['type'] = 'Invoice Tax';
                        $cgstdata['type_id'] = $invoice_id;
                        $cgstdata['amount'] = $cgst;
                        $cgstdata['status'] = 0;
                        $cgstdata['created_on'] = date('Y-m-d H:i:s');
                        $cgstdata['created_by'] = $_SESSION['user_id'];
                        $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
                      }
                    }

$sgstledgname = 'OUTPUT SGST '.$pgst.'%';
                    $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$locId);
                    if(count($sgstledg)>0)
                    {
                      $sgst = $ttot/2;
                      $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                      $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
                      $sgstdata['tax_type'] = 0;
                      $sgstdata['type'] = 'Invoice Tax';
                      $sgstdata['type_id'] = $invoice_id;
                      $sgstdata['amount'] = $sgst;
                      $sgstdata['status'] = 0;
                      $sgstdata['created_on'] = date('Y-m-d H:i:s');
                      $sgstdata['created_by'] = $_SESSION['user_id'];
                      $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
                    }
                    else
                    {
                      $led['type']='Liabilities';
                      $led['account_attributes_id']=10;
                      $led['location_id']=$locId;
                      $led['remarks']='';
                      $led['opening_balance']=0;
                      $led['status'] = 0;
                      $led['created_on'] = date('Y-m-d H:i:s');
                      $led['created_by'] = $_SESSION['user_id'];
                      $led['ledger_code']='';
                      $led['crdr']=0;
                      $led['tax_ledger_status']=1;
                      $led['ledger_list']=$sgstledgname;
                      $this->Ledger_model->create_ledger_list($led);
                      
                      $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$locId);
                      if(count($sgstledg)>0)
                      {
                        $sgst = $ttot/2;
                        $sgstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                        $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
                        $sgstdata['tax_type'] = 0;
                        $sgstdata['type'] = 'Invoice Tax';
                        $sgstdata['type_id'] = $invoice_id;
                        $sgstdata['amount'] = $sgst;
                        $sgstdata['status'] = 0;
                        $sgstdata['created_on'] = date('Y-m-d H:i:s');
                        $sgstdata['created_by'] = $_SESSION['user_id'];
                        $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
                      }
                    }
                    
                    //$sgst = $invoice->tax_total/2;
                  }
                  else
                  {
                    //$igst = $invoice->tax_total;
                    $igsttax = $pgst*2;
                    $igstledgname = 'OUTPUT IGST '.$igsttax.'%';
                    $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$locId);
                    if(count($igstledg)>0)
                    {
                      $igst = $ttot;
                      $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                      $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
                      $igstdata['tax_type'] = 0;
                      $igstdata['type'] = 'Invoice Tax';
                      $igstdata['type_id'] = $invoice_id;
                      $igstdata['amount'] = $igst;
                      $igstdata['status'] = 0;
                      $igstdata['created_on'] = date('Y-m-d H:i:s');
                      $igstdata['created_by'] = $_SESSION['user_id'];
                      $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
                    }
                    else
                    {
                      $led['type']='Liabilities';
                      $led['account_attributes_id']=10;
                      $led['location_id']=$locId;
                      $led['remarks']='';
                      $led['opening_balance']=0;
                      $led['status'] = 0;
                      $led['created_on'] = date('Y-m-d H:i:s');
                      $led['created_by'] = $_SESSION['user_id'];
                      $led['ledger_code']='';
                      $led['crdr']=0;
                      $led['tax_ledger_status']=1;
                      $led['ledger_list']=$igstledgname;
                      $this->Ledger_model->create_ledger_list($led);
                      
                      $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$locId);
                      if(count($igstledg)>0)
                      {
                        $igst = $ttot;
                        $igstdata['tax_ledger_line_item_date'] = date('Y-m-d');
                        $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
                        $igstdata['tax_type'] = 0;
                        $igstdata['type'] = 'Invoice Tax';
                        $igstdata['type_id'] = $invoice_id;
                        $igstdata['amount'] = $igst;
                        $igstdata['status'] = 0;
                        $igstdata['created_on'] = date('Y-m-d H:i:s');
                        $igstdata['created_by'] = $_SESSION['user_id'];
                        $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
                      }
                    }
                  }
                  
                }

}

}
            else
            {
              if($iv=='')
                $iv = $i;
              else
                $iv.= ','.$i;
            }

}

if($emptrow==$arrayCount)
            $this->session->set_flashdata('add_err', 'All Rows are Empty');
          else if($iv=='')
            $this->session->set_flashdata('add_success', 'Invoice Added Successfully.');
          else
            $this->session->set_flashdata('add_err', 'Some Error In row '.$iv);
          redirect('/invoice/invoice_upload');

}
        else
        {
          $this->session->set_flashdata('add_err', 'Invalid File.');
          redirect('/invoice/invoice_upload');
        }
      }
    }
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Invoice_old.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation