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: Stockcron_old.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
ini_set('max_execution_time',259200);
class Stockcron extends CI_Controller {
 public function __construct()
 {
 parent::__construct();
 $this->load->model(array('Profitloss_model'));
 $this->load->model(array('Dashboard_model'));
 $this->load->model(array('Gstrworkings_model'));
 $this->load->model(array('Ledger_model'));
 $this->load->model(array('Accountjournal_model'));
 $this->load->model(array('Accountreceipt_model'));
 $this->load->model(array('Quotation_model'));
 $this->load->model(array('Order_model'));
 $this->load->model(array('Purchase_model'));
 $this->load->model(array('Grn_model'));
 $this->load->model(array('Invoice_model'));
 $this->load->model(array('Expense_model'));
 $this->load->model(array('Vendor_model'));
 $this->load->model(array('Posdb_model'));
 $this->load->model(array('Customer_model'));
 $this->load->model(array('Payment_model'));
 //date_default_timezone_set("Asia/Kolkata");
 }

public function stock_cron()
  {
    $ledger_list = $this->Ledger_model->get_ledger_list_list();
    $vendor_list = $this->Vendor_model->get_vendor_list();
    $customer_list = $this->Ledger_model->get_customer_list();
    $location_list = $this->Order_model->get_location();

//db Backup Start
    $this->load->dbutil();

$prefs = array(     
        'format'      => 'zip',             
        'filename'    => 'my_db_backup.sql'
        );

$backup =$this->dbutil->backup($prefs);

$db_name = 'backup-on-'. date("Y-m-d-H-i-s") .'.zip';
    $save = 'dbbackup/'.$db_name;

$this->load->helper('file');
    write_file($save, $backup); 
    //db Backup End

$locList = $this->Profitloss_model->get_location_list();
    $cdate = date("Y-m-d");
    $pDay = new DateTime(date("Y-m-d").' - 1 day');
    $pdate = $pDay->format('Y-m-d');

foreach($locList as $loc)
    {
        $locId = $loc['location_id'];
        $pamt = $data['purchase_amt'] = $this->Profitloss_model->get_purchase_amount_by_date_loc_id($pdate,$locId);
        $samt = $data['sales_amt'] = $this->Profitloss_model->get_sales_amount_by_date_loc_id($pdate,$locId);
        $diamt = $data['direct_invoice'] = $this->Profitloss_model->get_direct_invoice_amount_by_date_loc_id($pdate,$locId);

if(count($pamt)>0)
            $pmt = $pamt->ptot;
        else
            $pmt = 0;

if(count($samt)>0)
            $smt = $samt->stot;
        else
            $smt = 0;

if(count($diamt)>0)
            $dimt = $diamt->ditot;
        else
            $dimt = 0;

$sled = $this->Profitloss_model->get_stock_ledger_by_date_loc_id($pdate,$locId);

if(count($sled)>0)
        {
            $selddata['purchase_amount'] = $pmt;
            $selddata['sales_amount'] = $smt+$dimt;
            $cstock = ($sled->opening_stock+$pmt)-($smt+$dimt);
            $selddata['closing_stock'] = $cstock;
            $selddata['stock_ledger_date'] = $pdate;
            $selddata['location_id'] = $locId;
            $this->Profitloss_model->update_stock_ledger($selddata);

$adddata['stock_ledger_date'] = $cdate;
            $adddata['opening_stock'] = $cstock;
            $adddata['purchase_amount'] = 0;
            $adddata['sales_amount'] = 0;
            $adddata['closing_stock'] = 0;
            $adddata['location_id'] = $locId;
            $this->Profitloss_model->create_stock_ledger($adddata);
        }
        else
        {
            $adddata1['stock_ledger_date'] = $pdate;
            $adddata1['opening_stock'] = 0;
            $adddata1['purchase_amount'] = $pmt;
            $adddata1['sales_amount'] = $smt+$dimt;
            $cstock = ($sled->opening_stock+$pmt)-($smt+$dimt);
            $adddata1['closing_stock'] = $cstock;
            $adddata1['location_id'] = $locId;
            $this->Profitloss_model->create_stock_ledger($adddata1);

$adddata2['stock_ledger_date'] = $cdate;
            $adddata2['opening_stock'] = $cstock;
            $adddata2['purchase_amount'] = 0;
            $adddata2['sales_amount'] = 0;
            $adddata2['closing_stock'] = 0;
            $adddata2['location_id'] = $locId;
            $this->Profitloss_model->create_stock_ledger($adddata2);
        }

$syear = date('Y');
        $smonth = date('m');
        if($smonth!=1)
        {
          $pmonth = $smonth-1;
          $pyear = $syear;
        }
        else
        {
          $pmonth = 12;
          $pyear = $syear-1;
        }
        $pmonth_tax = $this->Gstrworkings_model->get_gst_tax_by_year_month_location($pyear,$pmonth,$locId);

$tn_sales = $this->db->query("SELECT product_gst,sum(amt) as tamt,sum(packing_charges) as tpcharge, sum(other_charges) as tocharge FROM ((SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id=33 AND o.location_id='$locId' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) UNION (SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice` i,invoice_product ip,customer c WHERE i.invoice_id = ip.invoice_id AND i.customer_id = c.customer_id AND c.state_id=33 AND i.location_id='$locId' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) ORDER BY product_gst ASC) t GROUP BY product_gst")->result_array();

$os_sales = $this->db->query("SELECT product_gst,sum(amt) as tamt,sum(packing_charges) as tpcharge, sum(other_charges) as tocharge FROM ((SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id!=33 AND o.location_id='$locId' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) UNION (SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice` i,invoice_product ip,customer c WHERE i.invoice_id = ip.invoice_id AND i.customer_id = c.customer_id AND c.state_id!=33 AND i.location_id='$locId' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) ORDER BY product_gst ASC) t GROUP BY product_gst")->result_array();

$expense_list = $this->db->query("SELECT sum(taxable_value) as tblvalue,sum(igst) as tigst,sum(cgst) as tcgst,sum(sgst) as tsgst FROM expense WHERE location_id='$locId' AND YEAR(expense_date)='$syear' AND MONTH(expense_date)='$smonth' AND tax_rate!=0 AND status!=2")->row();

$tn_purchase_list = $this->db->query("SELECT sum(p.taxable_amount) as tblamt,sum(p.tax_amount) as txamt FROM `purchase` p,purchase_order po,vendor v WHERE p.purchase_order_id = po.purchase_order_id AND po.vendor_id = v.vendor_id AND v.state_id=33 AND YEAR(p.purchase_date)='$syear' AND MONTH(p.purchase_date)='$smonth' AND po.location_id='$locId'")->row();

$os_purchase_list = $this->db->query("SELECT sum(p.taxable_amount) as tblamt,sum(p.tax_amount) as txamt FROM `purchase` p,purchase_order po,vendor v WHERE p.purchase_order_id = po.purchase_order_id AND po.vendor_id = v.vendor_id AND v.state_id!=33 AND YEAR(p.purchase_date)='$syear' AND MONTH(p.purchase_date)='$smonth' AND po.location_id='$locId'")->row();

$tntot = 0;$tnigst=0;$tncgst = 0;$tnsgst = 0;$tntottax = 0;
        foreach($tn_sales as $tns)
        {
            $val = $tns['tamt']+$tns['tpcharge']+$tns['tocharge'];
            $tax = ($val*$tns['product_gst'])/100;
            $tntot+=$val;$tncgst+=$tax;$tnsgst+=$tax;$tntottax+=($tax*2);
        }

$ostot = 0;$osigst=0;$oscgst = 0;$ossgst = 0;$ostottax = 0;
        foreach($os_sales as $oss)
        {
            $val = $oss['tamt']+$oss['tpcharge']+$oss['tocharge'];
            $tax = ($val*$oss['product_gst'])/100;
            $ostot+=$val;$osigst+=($tax*2);$tntottax+=($tax*2);
        }

$ambigst = ($tnigst+$osigst)-($os_purchase_list->txamt+$expense_list->tigst);
        $ambcgst = ($tncgst+$oscgst)-($tn_purchase_list->txamt/2+$expense_list->tcgst);
        $ambsgst = ($tnsgst+$ossgst)-($tn_purchase_list->txamt/2+$expense_list->tsgst);
        $ambttax = ($tntottax+$ostottax)-($os_purchase_list->txamt+$tn_purchase_list->txamt+$expense_list->tigst+$expense_list->tcgst+$expense_list->tsgst);

if(count($pmonth_tax)>0)
        {
            $pigst = $pmonth_tax->igst;
            $pcgst = $pmonth_tax->cgst;
            $psgst = $pmonth_tax->sgst;
            //$pttax = $pmonth_tax->total_tax;

if($pigst<0||$pcgst<0||$psgst<0)
 {
 if($pigst<0)
 $ambigst = $ambigst+$pigst;
 else
 $pigst = 0;
 if($pcgst<0)
 $ambcgst = $ambcgst + $pcgst;
 else
 $pcgst = 0;
 if($psgst<0)
 $ambsgst = $ambsgst + $psgst;
 else
 $psgst = 0;
 $pttax = $pigst+$pcgst+$psgst;

$ambttax = $ambttax + $pttax;
            }
        }

$gtax = $this->Gstrworkings_model->get_gst_tax_by_year_month_location($syear,$smonth,$locId);
        if(count($gtax)==0)
        {
            $data['year'] = $syear;
            $data['month'] = $smonth;
            $data['location_id'] = $locId;
            $data['igst'] = $ambigst;
            $data['cgst'] = $ambcgst;
            $data['sgst'] = $ambsgst;
            $data['total_tax'] = $ambttax;
            $this->Gstrworkings_model->create_gst_tax($data);
        }
        else
        {
            $data1['year'] = $syear;
            $data1['month'] = $smonth;
            $data1['location_id'] = $locId;
            $data1['igst'] = $ambigst;
            $data1['cgst'] = $ambcgst;
            $data1['sgst'] = $ambsgst;
            $data1['total_tax'] = $ambttax;
            $this->Gstrworkings_model->udpate_gst_tax($data1);
        }
    }

$data['cron_name'] = 'Stock Cron';
    $data['cron_date'] = date('Y-m-d H:i:s');
    $this->Profitloss_model->insert_cron_statistics($data);

}

public function possync()
    {

$lastsynccusid = $this->db->query("SELECT id FROM sma_companies ORDER BY id DESC LIMIT 1")->row();
      if(count($lastsynccusid)>0)
      {
          $poscusid=$lastsynccusid->id;
      }
      else
      {
          $poscusid = 0;
      }
      $poscustomer = $this->Posdb_model->get_pos_customer($poscusid);
      foreach($poscustomer as $pcust){

$this->db->query("INSERT INTO `sma_companies`(`id`, `group_id`, `group_name`, `customer_group_id`, `customer_group_name`, `name`, `company`, `vat_no`, `address`, `city`, `state`, `postal_code`, `country`, `phone`, `email`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `invoice_footer`, `payment_term`, `logo`, `award_points`, `deposit_amount`, `price_group_id`, `price_group_name`, `gst_no`) VALUES ('".$pcust['id']."','".$pcust['group_id']."','".$pcust['group_name']."','".$pcust['customer_group_id']."','".$pcust['customer_group_name']."','".str_replace("'", "`", $pcust['name'])."','".str_replace("'", "`", $pcust['company'])."','".$pcust['vat_no']."','".str_replace("'", "`", $pcust['address'])."','".$pcust['city']."','".$pcust['state']."','".$pcust['postal_code']."','".$pcust['country']."','".$pcust['phone']."','".$pcust['email']."','".$pcust['cf1']."','".$pcust['cf2']."','".$pcust['cf3']."','".$pcust['cf4']."','".$pcust['cf5']."','".$pcust['cf6']."','".$pcust['invoice_footer']."','".$pcust['payment_term']."','".$pcust['logo']."','".$pcust['award_points']."','".$pcust['deposit_amount']."','".$pcust['price_group_id']."','".$pcust['price_group_name']."','".$pcust['gst_no']."')");

}

$lastsyncsaleid = $this->db->query("SELECT id FROM sma_sales ORDER BY id DESC LIMIT 1")->row();
      if(count($lastsyncsaleid)>0)
      {
          $possaleid=$lastsyncsaleid->id;
      }
      else
      {
          $possaleid = 0;
      }
      $possale = $this->Posdb_model->get_pos_invoice($possaleid);
      foreach($possale as $pinv){

$posprod = $this->Posdb_model->get_pos_invoice_product($pinv['id']);

$this->db->query("INSERT INTO `sma_sales`(`id`, `date`, `reference_no`, `customer_id`, `customer`, `biller_id`, `biller`, `warehouse_id`, `note`, `staff_note`, `total`, `product_discount`, `order_discount_id`, `total_discount`, `order_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `shipping`, `grand_total`, `sale_status`, `payment_status`, `payment_term`, `due_date`, `created_by`, `updated_by`, `updated_at`, `total_items`, `pos`, `paid`, `return_id`, `surcharge`, `attachment`, `return_sale_ref`, `sale_id`, `return_sale_total`, `rounding`, `suspend_note`, `api`, `shop`, `address_id`, `reserve_id`, `hash`, `manual_payment`, `cgst`, `sgst`, `igst`, `payment_method`) VALUES ('".$pinv['id']."','".$pinv['date']."','".$pinv['reference_no']."','".$pinv['customer_id']."','".str_replace("'", "`", $pinv['customer'])."','".$pinv['biller_id']."','".$pinv['biller']."','".$pinv['warehouse_id']."','".$pinv['note']."','".$pinv['staff_note']."','".$pinv['total']."','".$pinv['product_discount']."','".$pinv['order_discount_id']."','".$pinv['total_discount']."','".$pinv['order_discount']."','".$pinv['product_tax']."','".$pinv['order_tax_id']."','".$pinv['order_tax']."','".$pinv['total_tax']."','".$pinv['shipping']."','".$pinv['grand_total']."','".$pinv['sale_status']."','".$pinv['payment_status']."','".$pinv['payment_term']."','".$pinv['due_date']."','".$pinv['created_by']."','".$pinv['updated_by']."','".$pinv['updated_at']."','".$pinv['total_items']."','".$pinv['pos']."','".$pinv['paid']."','".$pinv['return_id']."','".$pinv['surcharge']."','".$pinv['attachment']."','".$pinv['return_sale_ref']."','".$pinv['sale_id']."','".$pinv['return_sale_total']."','".$pinv['rounding']."','".$pinv['suspend_note']."','".$pinv['api']."','".$pinv['shop']."','".$pinv['address_id']."','".$pinv['reserve_id']."','".$pinv['hash']."','".$pinv['manual_payment']."','".$pinv['cgst']."','".$pinv['sgst']."','".$pinv['igst']."','".$pinv['payment_method']."')");

foreach($posprod as $pprod)
        {
          $this->db->query("INSERT INTO `sma_sale_items`(`id`, `sale_id`, `product_id`, `product_code`, `product_name`, `product_type`, `option_id`, `net_unit_price`, `unit_price`, `quantity`, `warehouse_id`, `item_tax`, `tax_rate_id`, `tax`, `discount`, `item_discount`, `subtotal`, `serial_no`, `real_unit_price`, `sale_item_id`, `product_unit_id`, `product_unit_code`, `unit_quantity`, `comment`, `gst`, `cgst`, `sgst`, `igst`) VALUES ('".$pprod['id']."','".$pprod['sale_id']."','".$pprod['product_id']."','".$pprod['product_code']."','".$pprod['product_name']."','".$pprod['product_type']."','".$pprod['option_id']."','".$pprod['net_unit_price']."','".$pprod['unit_price']."','".$pprod['quantity']."','".$pprod['warehouse_id']."','".$pprod['item_tax']."','".$pprod['tax_rate_id']."','".$pprod['tax']."','".$pprod['discount']."','".$pprod['item_discount']."','".$pprod['subtotal']."','".$pprod['serial_no']."','".$pprod['real_unit_price']."','".$pprod['sale_item_id']."','".$pprod['product_unit_id']."','".$pprod['product_unit_code']."','".$pprod['unit_quantity']."','".$pprod['comment']."','".$pprod['gst']."','".$pprod['cgst']."','".$pprod['sgst']."','".$pprod['igst']."')");
        }

}
    }

public function syncdb()
{

$lastsynccusid = $this->db->query("SELECT pos_customer_id FROM customer WHERE pos_customer_id!=0 ORDER BY customer_id DESC LIMIT 1")->row();
  if(count($lastsynccusid)>0)
  {
      $poscusid=$lastsynccusid->pos_customer_id;
  }
  else
  {
      $poscusid = 0;
  }
  $poscustomer = $this->db->query("SELECT * FROM sma_companies WHERE id>$poscusid")->result_array();

foreach($poscustomer as $pcust){
    $state_list = $this->Posdb_model->get_state_by_state_code($pcust['state']);
    if(count($state_list)>0)
    {
      $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']=$pcust['name'];
      $data['customer_type']=1;
      $data['customer_category']=1;
      $data['company_name']=$pcust['company'];
      $data['pan_no']='';
      $data['gst_no']=$pcust['gst_no'];
      $data['address']=$pcust['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'] = 1;
      $data['is_self']=0;

$data['intrested_products'] = '';
      $data['state_id']=$state_list->state_id; 
      $data['pincode']=$pcust['postal_code']; 
      $data['discount_percentage']=0;
      $data['opening_balance']=0;
      $data['crdr']=0;
      $issis = $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($pcust['email']!='')
        {
          $data1['customer_id'] =  $customer_id;
          $data1['email_type_id'] = 0;
          $data1['email_id'] = $pcust['email'];
          $this->Customer_model->create_customer_email($data1);
        }

$data2['customer_id'] =  $customer_id;
        $data2['phone_type_id'] = 0;
        $data2['phone_no'] = $pcust['phone'];
        $this->Customer_model->create_customer_phone($data2);

$data3['customer_id'] =  $customer_id;
        $data3['address_type_id'] = 1;
        $data3['address'] = $pcust['address'];
        $data3['address_state_id'] = $state_list->state_id;
        $data3['address_pincode'] = $pcust['postal_code'];
        $this->Customer_model->create_customer_address($data3);

$data4['customer_id'] =  $customer_id;
        $data4['address_type_id'] = 2;
        $data4['address'] = $pcust['address'];
        $data4['address_state_id'] = $state_list->state_id;
        $data4['address_pincode'] = $pcust['postal_code'];
        $this->Customer_model->create_customer_address($data4);

$location_list = $this->Order_model->get_location();
        
        foreach($location_list as $llist)
        {
          $data5['customer_id'] =  $customer_id;
          $data5['location_id'] = $llist['location_id'];
          $data5['opening_balance'] = 0;
          $data5['crdr'] = 0;

$this->Customer_model->create_customer_opening_balance($data5);
        }
        $pcusid = $pcust['id'];
        $this->db->query("UPDATE customer SET pos_customer_id=$pcusid WHERE customer_id=$customer_id");

}
    }
  }

$lastsyncinvid = $this->db->query("SELECT pos_invoice_id FROM invoice WHERE pos_invoice_id!=0 ORDER BY invoice_id DESC LIMIT 1")->row();
  if(count($lastsyncinvid)>0)
  {
      $posinvid=$lastsyncinvid->pos_invoice_id;
  }
  else
  {
      $posinvid = 0;
  }

$posinvoice = $this->db->query("SELECT * FROM sma_sales WHERE id>$posinvid")->result_array();

foreach($posinvoice as $pinv)
  {
    $pinvid = $pinv['id'];
    $pinvcusid = $pinv['customer_id'];
    $posprod = $this->db->query("SELECT * FROM sma_sale_items WHERE sale_id=$pinvid")->result_array();
    $erpcusid = $this->db->query("SELECT customer_id FROM customer WHERE pos_customer_id=$pinvcusid")->row();

$billingadd = $this->db->query("SELECT ca.*,sl.state FROM customer_address ca,state_list sl WHERE ca.address_state_id = sl.state_id AND ca.customer_id = $erpcusid->customer_id AND ca.address_type_id = 1 ORDER BY ca.customer_address_id ASC LIMIT 1")->row();
    $shippingadd = $this->db->query("SELECT ca.*,sl.state FROM customer_address ca,state_list sl WHERE ca.address_state_id = sl.state_id AND ca.customer_id = $erpcusid->customer_id AND ca.address_type_id = 2 ORDER BY ca.customer_address_id ASC LIMIT 1")->row();

$cusdetails = $this->db->query("SELECT * FROM customer WHERE customer_id = $erpcusid->customer_id")->row();

$invdate = $data['invoice_date'] = date('Y-m-d',strtotime($pinv['date']));
    $data['delivery_date'] = date('Y-m-d',strtotime($pinv['date']));
    $cusId = $data['customer_id']=$erpcusid->customer_id;
    $type = $data['type']='trading product';
    $locId = $data['location_id']=3;
    $data['taxable_amount']=$pinv['total'];
    $data['tax_total']=$pinv['total_tax'];
    $data['round_off']=0;
    $invtot = $data['grand_total']=$pinv['grand_total'];
    $data['payment_term_id']=1;
    $data['delivery_term_id']=1;
    $data['freight_term_id']=1;
    $data['transporter']='Personal Delivery';
    $data['vehicle_no']='';
    $data['lr_rr_no']='';
    $data['eway_bill_no']='';
    $data['remarks']='';
    $nop = $data['no_of_packets']=1;
    $data['net_weight']=0;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = 1;
    $data['gross_weight']=0;
    $data['packing_charges']=$pinv['shipping'];
    $data['other_charges']=0;
    $data['prod_unit']='unit1';
    $data['destination_point']='';
    $data['customer_billing_address_id'] = $billingadd->customer_address_id;
    $data['customer_shipping_address_id'] = $shippingadd->customer_address_id;

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

$last_id_value = $this->Invoice_model->last_id_by_loc_code('SO');

$financial_year_to2 = (date('m') > 3) ? date('y') +1 : date('y');
    $financial_year_from2 = $financial_year_to2 - 1;

$fin2start = $financial_year_from2;
    $fin2end = $financial_year_to2;

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

if(count($last_id_value)==0)
    {
      $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;
      }

}

$data['lr_rr_bill'] = '';

$data['eway_bill'] = '';

$dsoid = $data['direct_so_id']=0;
    $data['delivery_type'] = 1;

if($pinv['warehouse_id']==2)
        $whId = $data['warehouse_id']=9;
    if($pinv['warehouse_id']==1)
        $whId = $data['warehouse_id']=8;
    if($pinv['warehouse_id']==3)
        $whId = $data['warehouse_id']=12;

$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(count($posprod)>0)
      {     
        $maxtax = 0;
        $data1['invoice_id'] =  $invoice_id;
        foreach($posprod as $pprod)
        {
            $ppcode = $pprod['product_code'];
          $prodList = $this->db->query("SELECT * FROM product WHERE product_code='".$ppcode."'")->row();
          if(count($prodList)>0){
            $prodrate = $pprod['net_unit_price']*$pprod['quantity'];
            $data1['product_id'] = $prodList->product_id;
            $data1['pr_uom_id'] = $prodList->uom_id;
            $data1['pr_rate_per_sqft'] = $pprod['net_unit_price'];
            $data1['pr_quantity'] = $pprod['quantity'];
            $data1['pr_rate'] = $prodrate;
            $data1['pr_disc'] = 0;
            $data1['pr_amount'] = $prodrate;
            $pgst = $data1['product_gst'] = str_replace('%','',$pprod['tax'])/2;
            $data1['accessories_weight'] = 0;
            $this->Invoice_model->create_direct_invoice_product($data1);

$pstock = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($prodList->product_id,$locId,$whId);
            $ostk = $pstock->stock;
            $nstk = $ostk - $pprod['quantity'];
            $whsid = $pstock->warehouse_stock_id;
            $upstk['stock'] = $nstk; 
            $upstk['modified_on'] = date('Y-m-d H:i:s');
            $upstk['modified_by'] = 1;
            $this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);

$ptax = $prodrate*$pgst/100;
            if($pgst>0)
            {
              $invoice = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);
              if($cusdetails->state_id == 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 = $ptax;
                  $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'] = 1;
                  $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'] = 1;
                  $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 = $ptax;
                    $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'] = 1;
                    $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 = $ptax;
                  $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'] = 1;
                  $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'] = 1;
                  $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 = $ptax;
                    $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'] = 1;
                    $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
                  }
                }

}
              else
              {
                $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 = $ptax*2;
                  $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'] = 1;
                  $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'] = 1;
                  $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 = $ptax*2;
                    $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'] = 1;
                    $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
                  }
                }
              }
            }

}
          if($pgst>$maxtax)
            $maxtax = $pgst;
        }
      }

if($pinv['payment_status']=='paid')
      {
        $paydata['order_id'] = 0;
        $paydata['invoice_id']=$invoice_id;
        $paydata['payment_date'] = date('Y-m-d',strtotime($pinv['updated_at']));
        $pmode = $paydata['payment_mode'] = 'Cash';    
        $paydata['payment_amount'] = $pinv['paid'];
        $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'] = 1;

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

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);
 }

$stax=0;
      if($pinv['shipping']>0)
      {
        $stax = ($pinv['shipping']*$maxtax*2)/100;
      }

$totinvtax = $pinv['total_tax']+$stax;
      $gtotal = $pinv['total']+$totinvtax+$pinv['shipping'];
      $rofftot = round($gtotal);
      $roff = $rofftot - $gtotal;

$pinvoiceid = $pinv['id'];
      $this->db->query("UPDATE invoice SET tax_total=$totinvtax,grand_total=$rofftot,pos_invoice_id=$pinvoiceid,round_off=$roff WHERE invoice_id=$invoice_id");

}
  }

redirect($_SESSION['cururl']);

}

public function ledger_balance_by_date()
  {
    $ledger_list = $this->Ledger_model->get_ledger_list_list();
    $vendor_list = $this->Vendor_model->get_vendor_list();
    $customer_list = $this->Ledger_model->get_customer_list();
    $location_list = $this->Order_model->get_location();
    $sdate = '2019-05-26';
    $edate = date('Y-m-d');
    //$edate = '2019-04-02';

$date1=date_create($sdate);
 $date2=date_create($edate);
 $diff=date_diff($date1,$date2);
 $ddays = $diff->format("%a");
 //echo $ddays." ";
 for($i=0;$i<=$ddays;$i++)
 {
 $stop_date = date('Y-m-d', strtotime($sdate . ' +'.$i.' day'));

$exenddate = explode('-', $stop_date);
 //print_r($exenddate);
 $dir = 'assets/opening_balance/'.$exenddate[0].'/'.$exenddate[1].'/'.$exenddate[2].'/opening_balance.txt';
 if(!file_exists(dirname($dir)))
 mkdir(dirname($dir), 0777, true);
//exit;
 foreach($ledger_list as $llist)
 {
 //echo $stop_date." ";
 $ledger_details_view_list = $this->Ledger_model->get_ledger_details_view_by_custom_date($sdate,$stop_date,$llist['ledger_list_id']);
 $debit=$llist['crdr']=='1'?$llist['opening_balance']:0;
 $credit=$llist['crdr']=='0'?$llist['opening_balance']:0;
 foreach ($ledger_details_view_list as $u_list ) {
 if($u_list['payment_mode']=='cheque' || $u_list['payment_mode']=='Cheque'){
 $cdet = 'Cheque No : '.$u_list['cheque_no'].' Bank Name : '.$u_list['bank_name'].' Branch Name : '.$u_list['branch_name'];
 }
 else
 {
 $cdet = '';
 }

if($u_list['payment_type']=='credit')
 {
 //$deb = 0;
 //$cre = $u_list['amount'];
 if($u_list['user_type'] == 'Sales')
 {
 $orderlist = $this->Ledger_model->get_order_view_by_id($u_list['user_id']);
 $clist = $this->Ledger_model->get_customer_view_by_id($orderlist->customer_id);
 $cusDetails = $this->Ledger_model->get_customer_contact_details($orderlist->customer_id);
 $cusdet = $clist->customer_name.' - '.$cusDetails->phone_no;
 $particulars = 'Customer : '.$cusdet.' - SO No : '.$orderlist->order_no;
 $deb = 0;
 $cre = $u_list['amount'];
 }
 else if($u_list['user_type']=='Invoice')
 {
 $orderlist = $this->Ledger_model->get_direct_invoice_view_by_id($u_list['user_id']);
 if(count($orderlist)==0)
 $orderlist = $this->Ledger_model->get_invoice_by_id($u_list['user_id']);
 $clist = $this->Ledger_model->get_customer_view_by_id($orderlist->customer_id);
 $cusDetails = $this->Ledger_model->get_customer_contact_details($orderlist->customer_id);
 $cusdet = $clist->customer_name.' - '.$cusDetails->phone_no;
 $particulars = 'Customer : '.$cusdet.' - INV No : '.$orderlist->invoice_no;
 $deb = 0;
 $cre = $u_list['amount'];
 }
 else if($u_list['user_type']=='transfer')
 {
 $banklist1 = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $banklist2 = $this->Ledger_model->get_bank_by_id($u_list['bank2_id']);
 $particulars = 'Bank Transfer Bank Name : '.$banklist1->bank_name.' - Branch Name : '.$banklist1->branch_name.' - Account No : '.$banklist1->account_no.' To Bank Name : '.$banklist2->bank_name.' - Branch Name : '.$banklist2->branch_name.' - Account No : '.$banklist2->account_no;
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type']=='withdraw')
 {
 $banklist1 = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $particulars = 'Bank Withdraw Bank Name : '.$banklist1->bank_name.' - Branch Name : '.$banklist1->branch_name.' - Account No : '.$banklist1->account_no.' ';
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type']=='deposit')
 {
 $banklist1 = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $particulars = 'Bank Deposit Bank Name : '.$banklist1->bank_name.' - Branch Name : '.$banklist1->branch_name.' - Account No : '.$banklist1->account_no.' ';
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type']=='cash transfer')
 {
 $particulars = 'Cash Transfer';
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type']=='Journal')
 {
 $ajournal = $this->Ledger_model->get_account_journal_by_id($u_list['account_receipt_id']);
 /*$llist = $this->Ledger_model->get_ledger_list_by_id($ajournal->ledger_list1_id);
 if($llist->ledger_code!='')
 $lcode = $llist->ledger_code.' - ';
 else
 $lcode = '';*/

if($ajournal->ledger_list1_type=='ledger')
                        {
                            $byledger = $this->Ledger_model->get_ledger_list_by_id($ajournal->ledger_list1_id);
                            $bledger = $byledger->location_name.' - '.$byledger->ledger_list;
                        }
                        elseif($ajournal->ledger_list1_type=='customer')
                        {
                            $byledger = $this->Accountjournal_model->get_customer_view_by_id($ajournal->ledger_list1_id);
                            $bledger = $byledger->customer_name;
                        }
                        else
                        {
                            $byledger = $this->Accountjournal_model->get_vendor_by_id($ajournal->ledger_list1_id);
                            $bledger = $byledger->vendor_name.' - '.$byledger->contact_no;
                        }

//$particulars = 'Journal Entry By '.$lcode.$llist->ledger_list;
 $particulars = 'Journal Entry By '.$byledger;
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type']=='Purchase Tax' || $u_list['user_type']=='Expense Tax')
 {
 if($u_list['user_type']=='Purchase Tax')
 {
 $purchaseList = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 $particulars = 'Tax : Purchase No : '.$purchaseList->purchase_no;
 }
 else
 {
 $expenseList = $this->Ledger_model->get_expense_by_id($u_list['user_id']);
 $particulars = 'Tax : Expense No : '.$expenseList->expense_no;
 }
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type'] == 'CN INV' || $u_list['user_type'] == 'RCN INV') 
 {
 $invoiceList = $this->Ledger_model->get_invoice_by_invoice_id($u_list['user_id']);
 $particulars = 'Credit Note : Invoice No : '.$invoiceList->invoice_no;
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type'] == 'CN OTH') 
 {
 $clist = $this->Accountjournal_model->get_customer_view_by_id($u_list['user_id']);
 $particulars = 'Credit Note : Customer : '.$clist->customer_name.' '.$u_list['particulars'];
 $cre = $u_list['amount'];
 $deb = 0;
 }
 else if($u_list['user_type'] == 'RCN OTH') 
 {
 $clist = $this->Accountjournal_model->get_vendor_by_id($u_list['user_id']);
 $particulars = 'Receipt : Vendor : '.$clist->vendor_name.' '.$u_list['particulars'];
 $cre = $u_list['amount'];
 $deb = 0;
 } 
 else
 {
 $particulars = ucwords($u_list['particulars']);
 $deb = 0;
 $cre = $u_list['amount'];
 }
 }
 else
 {
 //$cre = 0;
 //$deb = $u_list['amount'];
 if($u_list['expense_type'] == 'vendor payment')
 {
 /*$vlist = $this->Ledger_model->get_vendor_by_id($u_list['user_id']);
 $cusdet = $vlist->vendor_name.' - '.$vlist->contact_no;
 $particulars = 'Vendor : '.$cusdet;*/
 $vlist = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 $cusdet = $vlist->purchase_no.' - '.$vlist->vendor_name;
 $particulars = 'Purchase : '.$cusdet;
 $cre = 0;
 $deb = $u_list['amount'];
 }
 else if($u_list['expense_type'] == 'expense')
 {
 /*$vlist = $this->Ledger_model->get_ledgersubgroup_by_id($u_list['user_id']);
 $cusdet = $vlist->ledger_sub_group;
 $particulars = 'Expense : '.$cusdet;*/
 $vlist = $this->Ledger_model->get_expense_by_id($u_list['user_id']);
 $cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $particulars = 'Expense : '.$cusdet;
 $cre = 0;
 $deb = $u_list['amount'];
 }
 else if($u_list['expense_type'] == 'staff expense')
 {
 $vlist = $this->Ledger_model->get_staff_expense_by_id($u_list['user_id']);
 $cusdet = $vlist->staff_expense_no.' - '.$vlist->staff_name;
 $particulars = 'Staff Expense : '.$cusdet;
 $cre = 0;
 $deb = $u_list['amount'];
 }
 else if($u_list['user_type']=='deposit')
 {
 $banklist = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $particulars = 'Bank Deposit Bank Name : '.$banklist->bank_name.' - Branch Name : '.$banklist->branch_name.' - Account No : '.$banklist->account_no;
 /*$deb = 0;
 $cre = $u_list['amount'];*/
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='withdraw')
 {
 $banklist = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $particulars = 'Bank Withdraw Bank Name : '.$banklist->bank_name.' - Branch Name : '.$banklist->branch_name.' - Account No : '.$banklist->account_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='transfer')
 {
 $banklist1 = $this->Ledger_model->get_bank_by_id($u_list['bank1_id']);
 $banklist2 = $this->Ledger_model->get_bank_by_id($u_list['bank2_id']);
 $particulars = 'Bank Transfer Bank Name : '.$banklist1->bank_name.' - Branch Name : '.$banklist1->branch_name.' - Account No : '.$banklist1->account_no.' To Bank Name : '.$banklist2->bank_name.' - Branch Name : '.$banklist2->branch_name.' - Account No : '.$banklist2->account_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='cash transfer')
 {
 $particulars = 'Cash Transfer';
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='Journal')
 {
 $ajournal = $this->Ledger_model->get_account_journal_by_id($u_list['account_receipt_id']);
 /*$llist = $this->Ledger_model->get_ledger_list_by_id($ajournal->ledger_list2_id);
 if($llist->ledger_code!='')
 $lcode = $llist->ledger_code.' - ';
 else
 $lcode = '';*/
 if($ajournal->ledger_list2_type=='ledger')
 {
 $toledger = $this->Ledger_model->get_ledger_list_by_id($ajournal->ledger_list2_id);
 $tledger = $toledger->location_name.' - '.$toledger->ledger_list;
 }
 elseif($ajournal->ledger_list2_type=='customer')
 {
 $toledger = $this->Accountjournal_model->get_customer_view_by_id($ajournal->ledger_list2_id);
 $tledger = $toledger->customer_name;
 }
 else
 {
 $toledger = $this->Accountjournal_model->get_vendor_by_id($ajournal->ledger_list2_id);
 $tledger = $toledger->vendor_name.' - '.$toledger->contact_no;
 }
 //$particulars = 'Journal Entry To '.$lcode.$llist->ledger_list;
 $particulars = 'Journal Entry To '.$tledger;
 //$particulars = 'Journal Entry';
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='Voucher')
 {
 $vchlist = $this->Ledger_model->get_ledgersubgroup_by_id($u_list['user_id']);
 $particulars = 'Voucher : '.$vchlist->ledger_sub_group;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='Invoice Tax')
 {
 $invoiceList = $this->Ledger_model->get_invoice_by_invoice_id($u_list['user_id']);
 $particulars = 'Tax : Invoice No : '.$invoiceList->invoice_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='TDS')
 {
 $expenseList = $this->Ledger_model->get_expense_by_id($u_list['user_id']);
 $particulars = 'TDS Payable Vendor : '.$expenseList->vendor_name.' Expense No : '.$expenseList->expense_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type']=='STF EXP')
 {
 $expenseList = $this->Ledger_model->get_staff_expense_by_id($u_list['user_id']);
 $particulars = 'Staff Expense Staff : '.$expenseList->staff_name.' Expense No : '.$expenseList->staff_expense_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type'] == 'DN PUR' || $u_list['user_type'] == 'PDN PUR') 
 {
 $purchaseList = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 $particulars = 'Debit Note : Purchase No : '.$purchaseList->purchase_no;
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type'] == 'DN OTH') 
 {
 $clist = $this->Accountjournal_model->get_vendor_by_id($u_list['user_id']);
 $particulars = 'Debit Note : Vendor : '.$clist->vendor_name.' '.$u_list['particulars'];
 $deb = $u_list['amount'];
 $cre = 0;
 }
 else if($u_list['user_type'] == 'PDN OTH') 
 {
 $clist = $this->Accountjournal_model->get_customer_view_by_id($u_list['user_id']);
 $particulars = 'Payment : Customer : '.$clist->customer_name.' '.$u_list['particulars'];
 $deb = $u_list['amount'];
 $cre = 0;
 } 
 else
 {
 $particulars = ucwords($u_list['particulars']);
 $cre = 0;
 $deb = $u_list['amount'];
 }
 }
 $debit+=$deb;$credit+=$cre;
 $lbal = $credit-$debit;
 }

$bal = $debit - $credit;

$str = 'Ledger||'.$llist['ledger_list_id'].'||'.$bal.PHP_EOL;

/*$exenddate = explode('/', $stop_date);

$dir = 'assets/opening_balance/'.$exenddate[0].'/'.$exenddate[1].'/'.$exenddate[2].'/opening_balance.txt';
            if(!file_exists(dirname($dir)))
                mkdir(dirname($dir), 0777, true);*/
            file_put_contents($dir, $str, FILE_APPEND | LOCK_EX);
        }

foreach($vendor_list as $venlist)
        {
            $id = $venlist['vendor_id'];
            foreach($location_list as $llist)
            {
                $locchange = $llist['location_id'];
                $loc = 'AND po.location_id='.$locchange;
                $iloc = 'AND ll.location_id='.$locchange;
                $eloc = 'AND e.location_id='.$locchange;
                $ajloc = 'AND ar.location_id='.$locchange;
                $vob = 'AND vob.location_id='.$locchange;
                $gloc = 'AND g.location_id='.$locchange;
                $cdnloc = 'AND cdn.location_id='.$locchange;

$fdate = $sdate;
                $tdate = $stop_date;

$creditors_ledger_list = $this->db->query("(SELECT v.vendor_id as scld_id, v.created_on as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as user_id,'' as payment_mode,'credit' as payment_type,sum(vob.opening_balance) as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,v.created_on,'Opening Balance' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 0 as op FROM vendor v,vendor_opening_balance vob WHERE v.vendor_id = vob.vendor_id AND vob.crdr=0 AND v.created_on>='$fdate' AND v.created_on<='$tdate' AND v.vendor_id=$id $vob)UNION(SELECT v.vendor_id as scld_id, v.created_on as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as user_id,'' as payment_mode,'debit' as payment_type,sum(vob.opening_balance) as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,v.created_on,'Opening Balance' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 0 as op FROM vendor v, vendor_opening_balance vob WHERE v.vendor_id = vob.vendor_id AND vob.crdr=1 AND v.created_on>='$fdate' AND v.created_on<='$tdate' AND v.vendor_id=$id $vob)UNION(SELECT p.purchase_id as scld_id, p.purchase_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,p.vendor_id as user_id,'' as payment_mode,'credit' as payment_type,p.total_amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,p.created_on,'New Purchase' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM purchase p, purchase_order po WHERE p.purchase_order_id = po.purchase_order_id $loc AND p.status=1 AND p.purchase_date>='$fdate' AND p.purchase_date<='$tdate' AND p.vendor_id=$id)UNION(SELECT e.expense_id as scld_id, e.expense_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,e.vendor_id as user_id,'' as payment_mode,'credit' as payment_type,e.total_amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,e.created_on,'Expense' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM expense e WHERE e.status=0 AND e.expense_date>='$fdate' AND e.expense_date<='$tdate' AND e.vendor_id=$id $eloc)UNION(SELECT ap.account_payment_id as scld_id, ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ap.user_id,ap.payment_mode,ap.payment_type,ap.amount as payment_amount,ap.cheque_no,ap.bank_name,ap.branch_name,ap.created_on,ap.particulars,ap.expense_type,ll.ledger_list,l.location_name, 1 as op FROM account_payment ap,purchase p,vendor v,ledger_list ll,location l WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ll.ledger_list_id = ap.ledger_list_id AND ll.location_id = l.location_id AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' AND v.vendor_id=$id $iloc)UNION(SELECT ap.account_payment_id as scld_id, ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ap.user_id,ap.payment_mode,ap.payment_type,ap.amount as payment_amount,ap.cheque_no,ap.bank_name,ap.branch_name,ap.created_on,ap.particulars,ap.expense_type,ll.ledger_list,l.location_name, 1 as op FROM account_payment ap,expense e,vendor v,ledger_list ll,location l WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ll.ledger_list_id = ap.ledger_list_id AND ll.location_id = l.location_id AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' AND v.vendor_id=$id $iloc)UNION(SELECT ar.account_journal_id as scld_id, ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ar.ledger_list2_id as user_id,'' as payment_mode,'credit' as payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,'Journal' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM account_journal ar,location l WHERE ar.location_id = l.location_id AND ar.ledger_list2_type='vendor' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' AND ar.ledger_list2_id=$id $ajloc)UNION(SELECT ar.account_journal_id as scld_id, ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ar.ledger_list1_id as user_id,'' as payment_mode,'debit' as payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,'Journal' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM account_journal ar,location l WHERE ar.location_id = l.location_id AND ar.ledger_list1_type='vendor' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' AND ar.ledger_list1_id=$id $ajloc)UNION(SELECT ap.account_payment_id as scld_id, ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,ap.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,ap.created_on,particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM account_payment ap, ledger_list ll WHERE ap.ledger_list_id = ll.ledger_list_id AND ap.parti_ledger_list_type = 'vendor' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' AND ap.parti_ledger_list_id=$id $iloc)UNION(SELECT tp.tds_payable_line_item_id as scld_id, tp.tds_payable_line_item_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,tp.expense_id as user_id,'' as payment_mode,'debit' as payment_type,tp.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,tp.created_on,'TDS' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM tds_payable_line_item tp,expense e,vendor v WHERE tp.expense_id = e.expense_id AND e.vendor_id = v.vendor_id AND v.vendor_id=$id AND tp.tds_payable_line_item_date>='$fdate' AND tp.tds_payable_line_item_date<='$tdate' $eloc) UNION(SELECT cdn.credit_debit_note_id as scld_id, cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,cdn.type_id as user_id,'' as payment_mode,'debit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'DN PUR' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,purchase p,vendor v WHERE cdn.type_id = p.purchase_id AND p.vendor_id = v.vendor_id AND cdn.credit_debit = 'Debit' AND v.vendor_id=$id AND cdn.type_id !=0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id, cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,cdn.type_id as user_id,'' as payment_mode,'credit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'RDN PUR' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,purchase p,vendor v WHERE cdn.type_id = p.purchase_id AND p.vendor_id = v.vendor_id AND cdn.credit_debit = 'Receipt' AND v.vendor_id=$id AND cdn.type_id!=0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id, cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,cdn.vendor_id as user_id,'' as payment_mode,'debit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'DN OTH' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,vendor v WHERE cdn.vendor_id = v.vendor_id AND cdn.credit_debit = 'Debit' AND v.vendor_id=$id AND cdn.type_id=0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id, cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,cdn.vendor_id as user_id,'' as payment_mode,'credit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'RDN OTH' as particulars,'' as expense_type,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,vendor v WHERE cdn.vendor_id = v.vendor_id AND cdn.credit_debit = 'Receipt' AND v.vendor_id=$id AND cdn.type_id=0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)ORDER BY op ASC, pdate ASC")->result_array();

$debit=0;$credit=0;

foreach ($creditors_ledger_list as $u_list ) {
 if($u_list['payment_mode']=='cheque' || $u_list['payment_mode']=='Cheque'){
 $cdet = 'Cheque No : '.$u_list['cheque_no'].' Bank Name : '.$u_list['bank_name'].' Branch Name : '.$u_list['branch_name'];
 }
 else
 {
 $cdet = '';
 }

if($u_list['payment_type']=='credit')
                    {
                        $deb = 0;
                        $cre = $u_list['payment_amount'];
                    }
                    else
                    {
                        $cre = 0;
                        $deb = $u_list['payment_amount'];
                    }

if($u_list['customer_id']!=0)
 {
 $clist = $this->Ledger_model->get_customer_view_by_id($u_list['customer_id']);
 $cusDetails = $this->Ledger_model->get_customer_contact_details($u_list['customer_id']);
 $cusdet = $clist->customer_name.' - '.$cusDetails->phone_no;
 $cudetails = 'Customer : '.$cusdet.' - ';
 }
 else if($u_list['user_id']!=0 && $u_list['particulars']!='Opening Balance')
 {
 /*$vlist = $this->Ledger_model->get_vendor_by_id($u_list['user_id']);
 $cusdet = $vlist->vendor_name.' - '.$vlist->contact_no;
 $cudetails = 'Vendor : '.$cusdet;*/
 if($u_list['particulars']=='')
 {
 if($u_list['expense_type'] == 'vendor payment')
 {
 $vlist = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 $cusdet = $vlist->purchase_no.' - '.$vlist->vendor_name;
 $cudetails = 'Purchase Payment : '.$cusdet;
 }
 if($u_list['expense_type'] == 'expense')
 {
 $vlist = $this->Ledger_model->get_expense_by_id($u_list['user_id']);
 $cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $cudetails = 'Expense Payment : '.$cusdet;
 }
 }
 else
 {
 if($u_list['particulars']=='Expense')
 {
 $vlist = $this->Ledger_model->get_expense_by_id($u_list['scld_id']);
 //$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $cusdet = $vlist->expense_no;
 $cudetails = ''.$u_list['particulars'].' : '.$cusdet.' Invoice No : '.$vlist->invoice_no;
 }
 else if($u_list['particulars']=='DN PUR')
 {
 $vlist = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 //$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $cusdet = $vlist->purchase_no;
 $cudetails = 'Credit Note : '.$vlist->purchase_no;
 }
 else if($u_list['particulars']=='RDN PUR')
 {
 $vlist = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
 //$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $cusdet = $vlist->purchase_no;
 $cudetails = 'Receipt : '.$vlist->purchase_no;
 }
 else if($u_list['particulars']=='DN OTH')
 {
 $vlist = $this->Accountjournal_model->get_vendor_by_id($u_list['user_id']);
 //$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 //$cusdet = $vlist->purchase_no;
 $cudetails = 'Credit Note : '.$vlist->vendor_name;
 }
 else if($u_list['particulars']=='RDN OTH')
 {
 $vlist = $this->Accountjournal_model->get_vendor_by_id($u_list['user_id']);
 //$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 //$cusdet = $vlist->purchase_no;
 $cudetails = 'Receipt : '.$vlist->vendor_name;
 }
 else if($u_list['particulars']=='TDS')
 {
 $expenseList = $this->Ledger_model->get_expense_by_id($u_list['user_id']);
 /*$cusdet = $vlist->expense_no.' - '.$vlist->vendor_name;
 $cudetails = $u_list['particulars'].' : '.$cusdet;*/
 $cudetails = 'TDS Payable Expense : '.$expenseList->expense_no.' Invoice No : '.$expenseList->invoice_no;
 }
 else if($u_list['particulars']=='Journal')
 {
 $ajid = $this->Accountjournal_model->get_account_journal_by_id($u_list['scld_id']);

if($ajid->ledger_list1_type=='ledger')
                                {
                                    $byledger = $this->Ledger_model->get_ledger_list_by_id($ajid->ledger_list1_id);
                                    $bledger = $byledger->location_name.' - '.$byledger->ledger_list;
                                }
                                elseif($ajid->ledger_list1_type=='customer')
                                {
                                    $byledger = $this->Accountjournal_model->get_customer_view_by_id($ajid->ledger_list1_id);
                                    $bledger = $byledger->customer_name;
                                }
                                else
                                {
                                    $byledger = $this->Accountjournal_model->get_vendor_by_id($ajid->ledger_list1_id);
                                    $bledger = $byledger->vendor_name.' - '.$byledger->contact_no;
                                }

if($ajid->ledger_list2_type=='ledger')
                                {
                                    $toledger = $this->Ledger_model->get_ledger_list_by_id($ajid->ledger_list2_id);
                                    $tledger = $toledger->location_name.' - '.$toledger->ledger_list;
                                }
                                elseif($ajid->ledger_list2_type=='customer')
                                {
                                    $toledger = $this->Accountjournal_model->get_customer_view_by_id($ajid->ledger_list2_id);
                                    $tledger = $toledger->customer_name;
                                }
                                else
                                {
                                    $toledger = $this->Accountjournal_model->get_vendor_by_id($ajid->ledger_list2_id);
                                    $tledger = $toledger->vendor_name.' - '.$toledger->contact_no;
                                }

$cusdet = 'By Ledger : '.$bledger.' ; To Ledger : '.$tledger;
                                $cudetails = $u_list['particulars'].' : '.$cusdet;

}
                            else
                            {
                                $vlist = $this->Ledger_model->get_purchase_by_id($u_list['scld_id']);
                                $cusdet = $vlist->purchase_no.' - '.$vlist->vendor_name;
                                $cudetails = $u_list['particulars'].' : '.$cusdet;
                            }
                            /*$vlist = $this->Ledger_model->get_purchase_by_id($u_list['user_id']);
                            $cusdet = $vlist->purchase_no.' - '.$vlist->vendor_name;
                            $cudetails = 'Vendor : '.$cusdet;*/
                            /*$vlist = $this->Ledger_model->get_vendor_by_id($u_list['user_id']);
                            $cusdet = $vlist->vendor_name.' - '.$vlist->contact_no;
                            $cudetails = 'Vendor : '.$cusdet;*/
                        }

}
                    else
                    {
                        $cudetails = $u_list['particulars'];
                    }
                    $debit+=$deb;$credit+=$cre;
                    $lbal = $credit-$debit;
                }

$bal = $debit - $credit;

$str = 'Vendor||'.$venlist['vendor_id'].'||'.$locchange.'||'.$bal.PHP_EOL;

/*$exenddate = explode('/', $stop_date);

$dir = 'assets/opening_balance/'.$exenddate[0].'/'.$exenddate[1].'/'.$exenddate[2].'/opening_balance.txt';
                if(!file_exists(dirname($dir)))
                    mkdir(dirname($dir), 0777, true);*/
                file_put_contents($dir, $str, FILE_APPEND | LOCK_EX);
            }
        }

foreach($customer_list as $cuslist)
        {
            $id = $cuslist['customer_id'];
            foreach($location_list as $llist)
            {
                $locchange = $llist['location_id'];
                $loc = 'AND o.location_id='.$locchange;
                $iloc = 'AND i.location_id='.$locchange;
                $ajloc = 'AND ar.location_id='.$locchange;
                $cob = 'AND cob.location_id='.$locchange;
                $llloc = 'AND ll.location_id='.$locchange;
                $cdnloc = 'AND cdn.location_id='.$locchange;

$fdate = $sdate;
                $tdate = $stop_date;

$debtors_ledger_list = $this->db->query("(SELECT c.customer_id as scld_id,c.created_on as pdate,'' as order_id,'' as invoice_id,c.customer_id,0 as user_id,'' as payment_mode,'credit' as payment_type,sum(cob.opening_balance) as payment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,c.created_on,'Opening Balance' as particulars,'' as ledger_list,'' as location_name, 0 as op FROM `customer` c,customer_opening_balance cob WHERE c.customer_id = cob.customer_id AND cob.crdr=0 AND c.created_on>='$fdate' AND c.created_on<='$tdate' AND c.customer_id=$id $cob)UNION(SELECT c.customer_id as scld_id,c.created_on as pdate,'' as order_id,'' as invoice_id,c.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,sum(cob.opening_balance) as payment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,c.created_on,'Opening Balance' as particulars,'' as ledger_list,'' as location_name, 0 as op FROM `customer` c,customer_opening_balance cob WHERE c.customer_id = cob.customer_id AND cob.crdr=1 AND c.created_on>='$fdate' AND c.created_on<='$tdate' AND c.customer_id=$id $cob)UNION(SELECT i.invoice_id as scld_id,i.invoice_date as pdate,i.order_id,i.invoice_id,i.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,i.grand_total as payment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,i.created_on,'New Invoice' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM `invoice` i WHERE i.order_id=0 AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' AND i.customer_id=$id $iloc)UNION(SELECT i.invoice_id as scld_id,i.invoice_date as pdate,i.order_id,i.invoice_id,o.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,i.grand_total as payment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,i.created_on,'Order Invoice' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM invoice i,`order` o WHERE o.order_id = i.order_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' AND o.customer_id=$id $loc)UNION(SELECT ar.account_receipt_id as scld_id,ar.account_receipt_date as pdate,ar.user_id as order_id,0 as invoice_id,o.customer_id,0 as user_id,ar.payment_mode,ar.payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,ll.ledger_list,l.location_name, 1 as op FROM account_receipt ar, `order` o,ledger_list ll,location l WHERE ar.user_id = o.order_id AND ar.user_type='Sales' AND ar.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND o.customer_id=$id $loc)UNION(SELECT ar.account_receipt_id as scld_id,ar.account_receipt_date as pdate,ar.user_id as order_id,0 as invoice_id,o.customer_id,0 as user_id,ar.payment_mode,ar.payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,ll.ledger_list,l.location_name, 1 as op FROM account_receipt ar, `order` o, invoice i, ledger_list ll, location l WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND ar.user_type='Invoice' AND ar.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND o.customer_id=$id $loc)UNION(SELECT ar.account_receipt_id as scld_id,ar.account_receipt_date as pdate,0 as order_id,ar.user_id as invoice_id,i.customer_id,0 as user_id,ar.payment_mode,ar.payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,ll.ledger_list,l.location_name, 1 as op FROM account_receipt ar, `invoice` i, ledger_list ll,location l WHERE ar.user_id = i.invoice_id AND ar.user_type='Invoice' AND ar.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND i.customer_id=$id $iloc)UNION(SELECT ar.account_journal_id as scld_id,ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,ar.ledger_list2_id as customer_id,0 as user_id,'' as payment_mode,'credit' as payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,'Journal' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM account_journal ar,location l WHERE ar.location_id = l.location_id AND ar.ledger_list2_type='customer' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' AND ar.ledger_list2_id=$id $ajloc)UNION(SELECT ar.account_journal_id as scld_id,ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,ar.ledger_list1_id as customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,'Journal' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM account_journal ar,location l WHERE ar.location_id = l.location_id AND ar.ledger_list1_type='customer' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' AND ar.ledger_list1_id=$id $ajloc)UNION(SELECT ar.account_receipt_id as scld_id,ar.account_receipt_date as pdate,0 as order_id,0 as invoice_id,ar.parti_ledger_list_id as customer_id,0 as user_id,ar.payment_mode,ar.payment_type,ar.amount as payment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,'' as ledger_list,'' as location_name, 1 as op FROM account_receipt ar, ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.parti_ledger_list_type = 'customer' AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.parti_ledger_list_id=$id $llloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,cdn.customer_id,0 as user_id,'' as payment_mode,'credit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'CN OTH' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn, ledger_list ll WHERE cdn.ledger_list_id = ll.ledger_list_id AND cdn.credit_debit='Credit' AND cdn.type_id = 0 AND cdn.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,cdn.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'PCN OTH' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn, ledger_list ll WHERE cdn.ledger_list_id = ll.ledger_list_id AND cdn.credit_debit='Payment' AND cdn.type_id = 0 AND cdn.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,cdn.type_id as invoice_id,i.customer_id,0 as user_id,'' as payment_mode,'credit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'CN INV' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,invoice i,customer c WHERE cdn.type_id = i.invoice_id AND i.customer_id = c.customer_id AND i.customer_id !=0 AND cdn.credit_debit='Credit' AND cdn.type_id != 0 AND i.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,cdn.type_id as invoice_id,i.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'PCN INV' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,invoice i,customer c WHERE cdn.type_id = i.invoice_id AND i.customer_id = c.customer_id AND i.customer_id !=0 AND cdn.credit_debit='Payment' AND cdn.type_id != 0 AND i.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,cdn.type_id as invoice_id,o.customer_id,0 as user_id,'' as payment_mode,'credit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'CN INV' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,invoice i,`order` o,customer c WHERE cdn.type_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.customer_id =0 AND cdn.credit_debit='Credit' AND cdn.type_id != 0 AND o.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)UNION(SELECT cdn.credit_debit_note_id as scld_id,cdn.credit_debit_note_date as pdate,0 as order_id,cdn.type_id as invoice_id,o.customer_id,0 as user_id,'' as payment_mode,'debit' as payment_type,cdn.amount as payment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'PCN INV' as particulars,'' as ledger_list,'' as location_name, 1 as op FROM credit_debit_note cdn,invoice i,`order` o,customer c WHERE cdn.type_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.customer_id =0 AND cdn.credit_debit='Payment' AND cdn.type_id != 0 AND o.customer_id=$id AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc)ORDER BY op ASC, pdate ASC")->result_array();

$debit=0;$credit=0;

foreach ($debtors_ledger_list as $u_list ) {
 if($u_list['payment_mode']=='cheque' || $u_list['payment_mode']=='Cheque'){
 $cdet = 'Cheque No : '.$u_list['cheque_no'].' Bank Name : '.$u_list['bank_name'].' Branch Name : '.$u_list['branch_name'];
 }
 else
 {
 $cdet = '';
 }

if($u_list['payment_type']=='debit')
                    {
                        if($u_list['order_id']!=0)
                        {
                            $invdet = $this->Ledger_model->get_invoice_by_id($u_list['invoice_id']);
                            $invno = ' - '.$invdet->invoice_no;
                        }
                        else
                        {
                            if($u_list['particulars']!='Journal' && $u_list['particulars']!='Opening Balance' && $u_list['invoice_id']!=0)
                            {
                                $invdet = $this->Ledger_model->get_direct_invoice_view_by_id($u_list['invoice_id']);
                                $invno = ' - '.$invdet->invoice_no;
                            }
                            else
                            {
                                $invno = '';
                            }
                        }
                    }
                    else
                    {
                        $invno = '';
                    }

$parti = $cudetails.' '.$u_list['particulars'].' '.$invno;

if($u_list['particulars']=='CN OTH')
 {
 $cnote = $this->Ledger_model->get_credit_debit_note_by_id($u_list['scld_id']);
 $parti = 'Credit Note : '.$cnote->particulars;
 }
 if($u_list['particulars']=='CN INV')
 {
 $cnote = $this->Ledger_model->get_invoice_by_invoice_id($u_list['invoice_id']);
 $parti = 'Credit Note : Invoice -> '.$cnote->invoice_no;
 }

if($u_list['particulars']=='PCN OTH')
 {
 $cnote = $this->Ledger_model->get_credit_debit_note_by_id($u_list['scld_id']);
 $parti = 'Payment : '.$cnote->particulars;
 }

if($u_list['particulars']=='PCN INV')
 {
 $cnote = $this->Ledger_model->get_invoice_by_invoice_id($u_list['invoice_id']);
 $parti = 'Payment : Invoice -> '.$cnote->invoice_no;
 }

if($u_list['particulars']=='Journal')
                    {
                        $ajid = $this->Accountjournal_model->get_account_journal_by_id($u_list['scld_id']);

if($ajid->ledger_list1_type=='ledger')
                        {
                            $byledger = $this->Ledger_model->get_ledger_list_by_id($ajid->ledger_list1_id);
                            $bledger = $byledger->location_name.' - '.$byledger->ledger_list;
                        }
                        elseif($ajid->ledger_list1_type=='customer')
                        {
                            $byledger = $this->Accountjournal_model->get_customer_view_by_id($ajid->ledger_list1_id);
                            $bledger = $byledger->customer_name;
                        }
                        else
                        {
                            $byledger = $this->Accountjournal_model->get_vendor_by_id($ajid->ledger_list1_id);
                            $bledger = $byledger->vendor_name.' - '.$byledger->contact_no;
                        }

if($ajid->ledger_list2_type=='ledger')
                        {
                            $toledger = $this->Ledger_model->get_ledger_list_by_id($ajid->ledger_list2_id);
                            $tledger = $toledger->location_name.' - '.$toledger->ledger_list;
                        }
                        elseif($ajid->ledger_list2_type=='customer')
                        {
                            $toledger = $this->Accountjournal_model->get_customer_view_by_id($ajid->ledger_list2_id);
                            $tledger = $toledger->customer_name;
                        }
                        else
                        {
                            $toledger = $this->Accountjournal_model->get_vendor_by_id($ajid->ledger_list2_id);
                            $tledger = $toledger->vendor_name.' - '.$toledger->contact_no;
                        }

$cusdet = 'By Ledger : '.$bledger.' ; To Ledger : '.$tledger;
                        $parti = $u_list['particulars'].' : '.$cusdet;
                    }
                }

$bal = $debit - $credit;

$str = 'Customer||'.$cuslist['customer_id'].'||'.$locchange.'||'.$bal.PHP_EOL;

/*$exenddate = explode('/', $stop_date);

$dir = 'assets/opening_balance/'.$exenddate[0].'/'.$exenddate[1].'/'.$exenddate[2].'/opening_balance.txt';
                if(!file_exists(dirname($dir)))
                    mkdir(dirname($dir), 0777, true);*/
                file_put_contents($dir, $str, FILE_APPEND | LOCK_EX);
            }
        }
    }

}

public function getfcontents()
  {
    /*$string = read_file(base_url()."opfiles/opfile.txt");
    print_r($string);*/
    /*$MyFile = file_get_contents(base_url()."opfiles/opfile.txt");
    echo $MyFile;*/

/*$fileResource = fopen(base_url()."opfiles/opfile.txt", "r");
 $op=0;
 if ($fileResource) {
 while (($line = fgets($fileResource)) !== false) {
 echo $line." ";
 $lsplit = explode('-', $line);
 if($lsplit[0]=='Customer' && $lsplit[1]==4105)
 {
 $op = $lsplit[2];
 break;
 }
 }
 echo " ".$op;
 fclose($fileResource);
 } */

/*$str = 'Customer-4105';
 $lines = file(base_url()."opfiles/opfile.txt");
 foreach ($lines as $lineNumber => $line) {
 echo $line." ";
 if (strpos($line, $str) !== false) {
 echo " ".$line." ";
 break;
 }
 }*/

$str = 'Customer-4071';
    $file = base_url()."opfiles/opfile.txt";

$contents = file_get_contents($file);
         $pattern = preg_quote($str, '/');
        $pattern = "/^.*$pattern.*\$/m";

if(preg_match_all($pattern, $contents, $matches)){
 echo "Found matches: ";
 echo implode(" ", $matches[0]);
 }
 else{
 echo "No matches found";
 //fclose ($file); 
 }

}

public function changevermitax()
 {
 $invoice_list = $this->db->query("SELECT ip.*,i.invoice_no,i.pos_invoice_id FROM `invoice_product` ip, invoice i WHERE i.invoice_id = ip.invoice_id AND ip.product_gst!=0 AND (ip.product_id=2002 OR ip.product_id=2265) AND i.invoice_date>='2020-06-01' AND i.invoice_date<='2020-06-30' GROUP BY ip.invoice_id")->result_array();

foreach($invoice_list as $ilist)
        {
            $invid = $ilist['invoice_id'];
            $invoice_product_list = $this->db->query("SELECT * FROM `invoice_product` WHERE invoice_id=$invid AND (product_id=2002 OR product_id = 2265)")->result_array();

$remtax=0;
            foreach($invoice_product_list as $iplist)
            {
                $invprodid = $iplist['invoice_product_id'];
                $amt = $iplist['amount'];
                $ptax = $iplist['product_gst']*2;
                $tax = ($amt*$ptax)/100;
                $remtax+=round($tax,2);

$famt = $amt+round($tax,2);
                $rate = round((($famt*100)/(100-$iplist['disc'])),2);

$rpsf = round(($rate/$iplist['quantity']),2);

$this->db->query("UPDATE `invoice_product` SET `product_gst`=0,`rate_per_sqft`='$rpsf',`rate`='$rate',`amount`='$famt' WHERE `invoice_product_id`=$invprodid");
            }

$sinvoice = $this->db->query("SELECT * FROM invoice WHERE invoice_id=$invid")->row();

$taxbleamt = $sinvoice->taxable_amount+$remtax;
            $tottax = $sinvoice->tax_total;

$newtottax = $tottax-$remtax;

$gtot = $taxbleamt+$newtottax+$sinvoice->packing_charges+$sinvoice->other_charges;

$gtotround = round($gtot);

$roff = $gtotround-$gtot;

$rof = number_format($roff,2);

$this->db->query("UPDATE `invoice` SET `taxable_amount`=$taxbleamt,`tax_total`=$newtottax,`round_off`=$rof,`grand_total`=$gtotround WHERE `invoice_id`=$invid");

$tax_ledger_details = $this->db->query("SELECT * FROM `tax_ledger_line_item` WHERE type='Invoice Tax' AND type_id = $invid")->result_array();

if(count($tax_ledger_details)>1)
            {
                $ledgtax = $newtottax/2;
            }
            else
            {
                $ledgtax = $newtottax;
            }

foreach($tax_ledger_details as $tledgdet)
            {
                $this->db->query("UPDATE `tax_ledger_line_item` SET `amount`=$ledgtax WHERE `type`='Invoice Tax' AND `type_id`=$invid");
            }
        }
    }

public function update_possync()
    {
        $lastsyncinvid = $this->db->query("SELECT pos_invoice_id FROM invoice where pos_invoice_id!=0 ORDER BY invoice_id DESC LIMIT 1")->row();
          if(count($lastsyncinvid)>0)
          {
              $posinvid=$lastsyncinvid->pos_invoice_id;
          }
          else
          {
              $posinvid = 0;
          }
          //echo $posinvid;//exit;

$posinvoice = $this->db->query("SELECT * FROM sma_sales WHERE id<=$posinvid")->result_array();
//print_r($posinvoice);//exit;
 foreach($posinvoice as $pinv)
 {
 $pinvid = $pinv['id'];
 $pinvcusid = $pinv['customer_id'];
 $posprod = $this->db->query("SELECT * FROM sma_sale_items WHERE sale_id=$pinvid")->result_array();
 $erpcusid = $this->db->query("SELECT customer_id FROM customer WHERE pos_customer_id=$pinvcusid")->row();

$billingadd = $this->db->query("SELECT ca.*,sl.state FROM customer_address ca,state_list sl WHERE ca.address_state_id = sl.state_id AND ca.customer_id = $erpcusid->customer_id AND ca.address_type_id = 1 ORDER BY ca.customer_address_id ASC LIMIT 1")->row();
            $shippingadd = $this->db->query("SELECT ca.*,sl.state FROM customer_address ca,state_list sl WHERE ca.address_state_id = sl.state_id AND ca.customer_id = $erpcusid->customer_id AND ca.address_type_id = 2 ORDER BY ca.customer_address_id ASC LIMIT 1")->row();

$cusdetails = $this->db->query("SELECT * FROM customer WHERE customer_id = $erpcusid->customer_id")->row();

$erpinvid = $this->db->query("SELECT * FROM invoice WHERE pos_invoice_id=$pinvid")->row();

$data['invoice_id'] = $erpinvid->invoice_id;
            $invdate = $data['invoice_date'] = date('Y-m-d',strtotime($pinv['date']));
            $data['delivery_date'] = date('Y-m-d',strtotime($pinv['date']));
            $cusId = $data['customer_id']=$erpcusid->customer_id;
            $type = $data['type']='trading product';
            $locId = $data['location_id']=3;
            $data['taxable_amount']=$pinv['total'];
            $data['tax_total']=$pinv['total_tax'];
            $data['round_off']=0;
            $invtot = $data['grand_total']=$pinv['grand_total'];
            $data['payment_term_id']=1;
            $data['delivery_term_id']=1;
            $data['freight_term_id']=1;
            $data['transporter']='Personal Delivery';
            $data['vehicle_no']='';
            $data['lr_rr_no']='';
            $data['eway_bill_no']='';
            $data['remarks']='';
            $nop = $data['no_of_packets']=1;
            $data['net_weight']=0;
            $data['created_on'] = date('Y-m-d H:i:s');
            $data['created_by'] = 1;
            $data['gross_weight']=0;
            $data['packing_charges']=$pinv['shipping'];
            $data['other_charges']=0;
            $data['prod_unit']='unit1';
            $data['destination_point']='';
            $data['customer_billing_address_id'] = $billingadd->customer_address_id;
            $data['customer_shipping_address_id'] = $shippingadd->customer_address_id;

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

$last_id_value = $this->Invoice_model->last_id_by_loc_code('SO');

$financial_year_to2 = (date('m') > 3) ? date('y') +1 : date('y');
            $financial_year_from2 = $financial_year_to2 - 1;

$fin2start = $financial_year_from2;
            $fin2end = $financial_year_to2;

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

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

if(count($last_id_value)==0)
            {
              $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;
              }

}

$data['lr_rr_bill'] = '';

$data['eway_bill'] = '';

$dsoid = $data['direct_so_id']=0;
            $data['delivery_type'] = 1;

if($pinv['warehouse_id']==2)
                $whId = $data['warehouse_id']=9;
            if($pinv['warehouse_id']==1)
                $whId = $data['warehouse_id']=8;

//print_r($data);exit;
            $result = $this->Invoice_model->update_possync_invoice($data);

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

$this->db->query("DELETE FROM invoice_product WHERE invoice_id=$invoice_id");
              $this->db->query("DELETE FROM invoice_barcode WHERE invoice_id=$invoice_id");
              $this->db->query("DELETE FROM payment WHERE invoice_id=$invoice_id");
              $this->db->query("DELETE FROM tax_ledger_line_item WHERE type='Invoice Tax' AND type_id=$invoice_id");

if(count($posprod)>0)
              {     
                $maxtax = 0;
                $data1['invoice_id'] =  $invoice_id;
                foreach($posprod as $pprod)
                {
                    $ppcode = $pprod['product_code'];
                  $prodList = $this->db->query("SELECT * FROM product WHERE product_code='".$ppcode."'")->row();
                  if(count($prodList)>0){
                    $prodrate = $pprod['net_unit_price']*$pprod['quantity'];
                    $data1['product_id'] = $prodList->product_id;
                    $data1['pr_uom_id'] = $prodList->uom_id;
                    $data1['pr_rate_per_sqft'] = $pprod['net_unit_price'];
                    $data1['pr_quantity'] = $pprod['quantity'];
                    $data1['pr_rate'] = $prodrate;
                    $data1['pr_disc'] = 0;
                    $data1['pr_amount'] = $prodrate;
                    $pgst = $data1['product_gst'] = str_replace('%','',$pprod['tax'])/2;
                    $data1['accessories_weight'] = 0;
                    $this->Invoice_model->create_direct_invoice_product($data1);

$pstock = $this->Invoice_model->get_whstock_pr_details_by_pr_loc_wh_id($prodList->product_id,$locId,$whId);
                    $ostk = $pstock->stock;
                    $nstk = $ostk - $pprod['quantity'];
                    $whsid = $pstock->warehouse_stock_id;
                    $upstk['stock'] = $nstk; 
                    $upstk['modified_on'] = date('Y-m-d H:i:s');
                    $upstk['modified_by'] = 1;
                    $this->Invoice_model->update_warehouse_stock_by_warehouse_stock_id($upstk,$whsid);

$ptax = $prodrate*$pgst/100;

$invoice = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);
                    if($cusdetails->state_id == 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 = $ptax;
                        $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'] = 1;
                        $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'] = 1;
                        $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 = $ptax;
                          $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'] = 1;
                          $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 = $ptax;
                        $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'] = 1;
                        $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'] = 1;
                        $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 = $ptax;
                          $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'] = 1;
                          $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
                        }
                      }

}
                    else
                    {
                      $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 = $ptax*2;
                        $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'] = 1;
                        $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'] = 1;
                        $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 = $ptax*2;
                          $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'] = 1;
                          $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
                        }
                      }
                    }

}
                  if($pgst>$maxtax)
                    $maxtax = $pgst;
                }
              }

if($pinv['payment_status']=='paid')
              {
                $paydata['order_id'] = 0;
                $paydata['invoice_id']=$invoice_id;
                $paydata['payment_date'] = date('Y-m-d',strtotime($pinv['updated_at']));
                $pmode = $paydata['payment_mode'] = 'Cash';    
                $paydata['payment_amount'] = $pinv['paid'];
                $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'] = 1;

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

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);
 }

$stax=0;
              if($pinv['shipping']>0)
              {
                $stax = ($pinv['shipping']*$maxtax*2)/100;
              }

$totinvtax = $pinv['total_tax']+$stax;
              $gtotal = $pinv['total']+$totinvtax+$pinv['shipping'];

$pinvoiceid = $pinv['id'];
              $this->db->query("UPDATE invoice SET tax_total=$totinvtax,grand_total=$gtotal,pos_invoice_id=$pinvoiceid WHERE invoice_id=$invoice_id");

}
          }
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Stockcron_old.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation