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.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'));
 $this->load->model(array('Balancesheet_model'));
 $this->load->model(array('Accountsjob_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){

$av_cus_rec = $this->db->query("SELECT * FROM sma_companies WHERE id=".$pcust['id'])->row();
        if(count($av_cus_rec)==0)
        {
          $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){

$av_sale_rec = $this->db->query("SELECT * FROM sma_sales WHERE id=".$pinv['id'])->row();
        if(count($av_sale_rec)==0)
        {
          $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){

$av_cus_rec = $this->db->query("SELECT * FROM customer WHERE pos_customer_id=".$pcust['id'])->row();
    if(count($av_cus_rec)==0)
    {

$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;
        $data['arjun_agri']=0;
        $data['arjun_tarpaulin']=0;
        $data['subhiksha_organics']=1;
        
        $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)
  {
    $av_sale_rec = $this->db->query("SELECT * FROM invoice WHERE pos_invoice_id=".$pinv['id'])->row();
    if(count($av_sale_rec)==0)
    {
      $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;
        }*/

if($pinv['shipping']>0)
        {
          $txval = $maxtax*2;
          $ship = $pinv['shipping'];
          $txblshipamt = ($ship*100)/(100+$txval);
          $stax = $ship - $txblshipamt;
        }
        else
        {
          $txblshipamt = $pinv['shipping'];
        }

$disc_amt = $pinv['order_discount'];

$totinvtax = $pinv['total_tax']+$stax;
        //$gtotal = $pinv['total']+$totinvtax+$pinv['shipping']-$disc_amt;
        $gtotal = $pinv['total']+$totinvtax+$txblshipamt-$disc_amt;
        $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,disc_amount=$disc_amt,packing_charges=$txblshipamt 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;
            if($pinv['warehouse_id']==3)
                $whId = $data['warehouse_id']=12;

//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");

}
          }
    }
    
    
    public function taxledgerchange()
    {
        $bill_zero_order_list = $this->db->query("SELECT * FROM `order` WHERE customer_billing_address_id=0 AND customer_id!=0")->result_array();
        foreach($bill_zero_order_list as $bzol)
        {
            $cid = $bzol['customer_id'];
            $oid = $bzol['order_id'];
            $locid = $bzol['location_id'];
            
            $customer_billing_address = $this->db->query("SELECT * FROM `customer_address` WHERE customer_id='".$cid."' AND address_type_id=1")->row();
            
            if(count($customer_billing_address)>0)
            {
                $cbaid = $customer_billing_address->customer_address_id;
                $stid = $customer_billing_address->address_state_id;
            }
            else
            {
                $cbaid = 0;
                $cus_list = $this->db->query("SELECT * FROM customer WHERE customer_id = ".$cid)->row();
                $stid = $cus_list->state_id;
            }
            
            $customer_shipping_address = $this->db->query("SELECT * FROM `customer_address` WHERE customer_id='".$cid."' AND address_type_id=2")->row();
            if(count($customer_shipping_address)>0)
                $csaid = $customer_shipping_address->customer_address_id;
            else
                $csaid = 0;
            
            $this->db->query("UPDATE `order` SET customer_billing_address_id=$cbaid,customer_shipping_address_id=$csaid WHERE order_id=$oid");
            
            $ord_inv = $this->db->query("SELECT * FROM invoice WHERE order_id=".$oid)->row();
            if(count($ord_inv)>0)
            {
                $invid = $ord_inv->invoice_id;
                $ptax = $ord_inv->tax_total;
                $invdate = $ord_inv->invoice_date;
                $inv_product = $this->db->query("SELECT * FROM invoice_product WHERE invoice_id=".$invid." ORDER BY invoice_product_id DESC LIMIT 1")->row();
                
                $this->db->query("DELETE FROM tax_ledger_line_item WHERE type='Invoice Tax' AND type_id=$invid");
                
                $pgst = $inv_product->product_gst;
                if($stid == 33)
                {
                  $cgstledgname = 'OUTPUT CGST '.$pgst.'%';
                  $cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$locid);
                  if(count($cgstledg)>0)
                  {
                    $cgst = $ptax/2;
                    $cgstdata['tax_ledger_line_item_date'] = $invdate;
                    $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
                    $cgstdata['tax_type'] = 0;
                    $cgstdata['type'] = 'Invoice Tax';
                    $cgstdata['type_id'] = $invid;
                    $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']=$invid;
                    $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,$locid);
                    if(count($cgstledg)>0)
                    {
                      $cgst = $ptax/2;
                      $cgstdata['tax_ledger_line_item_date'] = $invdate;
                      $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
                      $cgstdata['tax_type'] = 0;
                      $cgstdata['type'] = 'Invoice Tax';
                      $cgstdata['type_id'] = $invid;
                      $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,$locid);
                  if(count($sgstledg)>0)
                  {
                    $sgst = $ptax/2;
                    $sgstdata['tax_ledger_line_item_date'] = $invdate;
                    $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
                    $sgstdata['tax_type'] = 0;
                    $sgstdata['type'] = 'Invoice Tax';
                    $sgstdata['type_id'] = $invid;
                    $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']=$invid;
                    $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,$locid);
                    if(count($sgstledg)>0)
                    {
                      $sgst = $ptax/2;
                      $sgstdata['tax_ledger_line_item_date'] = $invdate;
                      $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
                      $sgstdata['tax_type'] = 0;
                      $sgstdata['type'] = 'Invoice Tax';
                      $sgstdata['type_id'] = $invid;
                      $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,$locid);
                  if(count($igstledg)>0)
                  {
                    $igst = $ptax;
                    $igstdata['tax_ledger_line_item_date'] = $invdate;
                    $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
                    $igstdata['tax_type'] = 0;
                    $igstdata['type'] = 'Invoice Tax';
                    $igstdata['type_id'] = $invid;
                    $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']=$invid;
                    $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,$locid);
                    if(count($igstledg)>0)
                    {
                      $igst = $ptax;
                      $igstdata['tax_ledger_line_item_date'] = $invdate;
                      $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
                      $igstdata['tax_type'] = 0;
                      $igstdata['type'] = 'Invoice Tax';
                      $igstdata['type_id'] = $invid;
                      $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);
                    }
                  }
                }
                
                
            }
        }
    }

public function accounts_cron_execution()
  {
    //Cron Log Start Time
    $txt = "[".date('Y-m-d H:i:s')."] => Cron Starting Time";            
    $mostRecentFilePath = "";
    $mostRecentFileMTime = 0;

$iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator("logs/Cron"), RecursiveIteratorIterator::CHILD_FIRST);
    foreach ($iterator as $fileinfo) {
        if ($fileinfo->isFile()) {
            if ($fileinfo->getMTime() > $mostRecentFileMTime) {
                $mostRecentFileMTime = $fileinfo->getMTime();
                $mostRecentFilePath = $fileinfo->getPathname();
            }
        }
    }

$fsize = filesize($mostRecentFilePath);
    if($fsize>1000000)
      $myfile = file_put_contents('logs/Cron/cron_log-'.date("Y-m-d").'.txt', $txt.PHP_EOL , FILE_APPEND | LOCK_EX);
    else
      $myfile = file_put_contents($mostRecentFilePath, $txt.PHP_EOL , FILE_APPEND | LOCK_EX);
    //Cron Log Start Time End

$processing_account_job_list = $this->Accountsjob_model->get_processing_account_job_list();

if(count($processing_account_job_list)>0)
    {
      //Trial Balance Start
      if($processing_account_job_list->accounts_module=='Trial Balance')
      {
        $this->db->query("UPDATE `accounts_cron_job` SET `status`='1' WHERE `accounts_cron_job_id`='".$processing_account_job_list->accounts_cron_job_id."'");

$liabilities_list = $this->Balancesheet_model->get_liabilities_list();
      $assets_list = $this->Balancesheet_model->get_assets_list();

$cstock = $processing_account_job_list->closing_stock;
      $ostock = $processing_account_job_list->opening_stock;

$fdate = $processing_account_job_list->from_date;
      $tdate = $processing_account_job_list->to_date;

$pDay = new DateTime(date($fdate).' - 1 day');
        $pdate = $pDay->format('Y-m-d');
        $psdate = '2019-04-01';

$company_id = $processing_account_job_list->company_id;

$cid = 'AND location_id='.$company_id;
      $decid = 'AND l.location_id='.$company_id;
      $purid = 'AND po.location_id='.$company_id;
      $ajcid = 'AND aj.location_id='.$company_id;
      $loc = 'AND po.location_id='.$company_id;
      $iloc = 'AND ll.location_id='.$company_id;
      $eloc = 'AND e.location_id='.$company_id;
      $oloc = 'AND o.location_id='.$company_id;
      $invloc = 'AND i.location_id='.$company_id;
      $ajloc = 'AND ar.location_id='.$company_id;
      $cob = 'AND cob.location_id='.$company_id;
      $vob = 'AND vob.location_id='.$company_id;
      $gloc = 'AND g.location_id='.$company_id;
      $cdnloc = 'AND cdn.location_id='.$company_id;
      $slocid = 'AND e.location_id='.$company_id;
      $compDet = $this->Profitloss_model->get_location_by_id($company_id);
      $data['compDet'] = $compDet->location_name;
      $compqry = " AND o.location_id='".$company_id."'";
      $dcompqry = " AND i.location_id='".$company_id."'";

if($company_id==1)
      {
        $comp = ' AND arjun_agri=1';
      }
      elseif($company_id==2)
      {
        $comp = ' AND arjun_tarpaulin=1';
      }
      else
      {
        $comp = ' AND subhiksha_organics=1';
      }

$sundry_debtors_list = $this->db->query("SELECT * FROM customer WHERE status=0 $comp ORDER BY customer_id ASC")->result_array();
 
 
 /*$sundry_debtors_list = $this->db->query("SELECT s.customer_id,sum(s.dpayment_amount) AS dpamt,sum(s.cpayment_amount) AS cpamt FROM ((SELECT 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 dpayment_amount,0 as cpayment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,c.created_on,'Opening Balance' as particulars 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' $cob GROUP BY c.customer_id)UNION(SELECT 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,0 as dpayment_amount,sum(cob.opening_balance) as cpayment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,c.created_on,'Opening Balance' as particulars 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' $cob GROUP BY c.customer_id)UNION(SELECT 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,sum(i.grand_total) as dpayment_amount,0 as cpayment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,i.created_on,'New Invoice' as particulars FROM `invoice` i WHERE i.order_id=0 AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $invloc AND i.status!=20 GROUP BY i.customer_id)UNION(SELECT 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,sum(i.grand_total) as dpayment_amount,0 as cpayment_amount,0 as cheque_no,0 as bank_name,0 as branch_name,i.created_on,'Order Invoice' as particulars FROM invoice i,`order` o WHERE o.order_id = i.order_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $oloc AND i.status!=20 GROUP BY o.customer_id)UNION(SELECT 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,0 as dpayment_amount,sum(ar.amount) as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars FROM account_receipt ar, `order` o WHERE ar.user_id = o.order_id AND ar.user_type='Sales' AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' $oloc AND ar.status!=2 GROUP BY o.customer_id)UNION(SELECT 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,0 as dpayment_amount,sum(ar.amount) as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars FROM account_receipt ar, `invoice` i WHERE ar.user_id = i.invoice_id AND ar.user_type='Invoice' AND i.customer_id !=0 AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' $invloc AND ar.status!=2 GROUP BY i.customer_id)UNION(SELECT ar.account_receipt_date as pdate,0 as order_id,ar.user_id as invoice_id,o.customer_id,0 as user_id,ar.payment_mode,ar.payment_type,0 as dpayment_amount,sum(ar.amount) as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars FROM account_receipt ar, `invoice` i,`order` o WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND ar.user_type='Invoice' AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' $oloc AND ar.status!=2 GROUP BY o.customer_id)UNION(SELECT 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,'' as payment_type,0 as dpayment_amount,sum(ar.amount) as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars FROM account_journal ar WHERE ar.ledger_list2_type='customer' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' $ajloc AND ar.status!=2 GROUP BY ar.ledger_list2_id)UNION(SELECT 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,'' as payment_type,sum(ar.amount) as dpayment_amount,0 as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars FROM account_journal ar WHERE ar.ledger_list1_type='customer' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' $ajloc AND ar.status!=2 GROUP BY ar.ledger_list1_id)UNION(SELECT 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,0 as dpayment_amount,sum(ar.amount) as cpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars 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' $iloc AND ar.status!=2 GROUP BY ar.parti_ledger_list_id)UNION(SELECT 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,'' as payment_type,0 as dpayment_amount,sum(cdn.amount) as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY cdn.customer_id)UNION(SELECT 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,'' as payment_type,sum(cdn.amount) as dpayment_amount,0 as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY cdn.customer_id)UNION(SELECT 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,'' as payment_type,sum(amount) as dpayment_amount,0 as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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 cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY i.customer_id)UNION(SELECT 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,'' as payment_type,sum(amount) as dpayment_amount,0 as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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 cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY o.customer_id)UNION(SELECT 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,'' as payment_type,0 as dpayment_amount,sum(amount) as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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 cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY o.customer_id)UNION(SELECT 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,'' as payment_type,0 as dpayment_amount,sum(amount) as cpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on,'' as particulars 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 cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' AND cdn.status!=2 $cdnloc GROUP BY i.customer_id)) s GROUP BY s.customer_id ORDER BY s.customer_id ASC")->result_array();*/

$sundry_creditors_list = $this->db->query("SELECT ven.vendor_id,sum(ven.dpayment_amount) AS dpamt,sum(ven.cpayment_amount) AS cpamt FROM ((SELECT v.created_on as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(vob.opening_balance) as cpayment_amount,0 as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,v.created_on,'Opening Balance' as particulars,'' as expense_type 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' $vob GROUP BY v.vendor_id)UNION(SELECT v.created_on as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(vob.opening_balance) as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,v.created_on,'Opening Balance' as particulars,'' as expense_type 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' $vob GROUP BY v.vendor_id)UNION(SELECT p.purchase_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,p.vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(p.total_amount) as cpayment_amount,0 as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,p.created_on,'New Purchase' as particulars,'' as expense_type FROM purchase p,purchase_order po WHERE p.purchase_order_id = po.purchase_order_id AND p.purchase_date>='$fdate' AND p.purchase_date<='$tdate' $loc AND p.status=1 AND p.status!=2 GROUP BY p.vendor_id)UNION(SELECT e.expense_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,e.vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(e.total_amount) as cpayment_amount,0 as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,e.created_on,'Expense' as particulars,'' as expense_type FROM expense e WHERE e.expense_date>='$fdate' AND e.expense_date<='$tdate' $eloc AND e.status!=2 GROUP BY e.vendor_id)UNION(SELECT ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id,0 as oth_id,ap.payment_mode,ap.payment_type,0 as cpayment_amount,sum(ap.amount) as dpayment_amount,ap.cheque_no,ap.bank_name,ap.branch_name,ap.created_on,ap.particulars,ap.expense_type FROM account_payment ap,purchase p,vendor v,ledger_list ll WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.ledger_list_id = ll.ledger_list_id $iloc AND ap.expense_type='vendor payment' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' AND ap.status!=2 GROUP BY v.vendor_id)UNION(SELECT ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id,0 as oth_id,ap.payment_mode,ap.payment_type,0 as cpayment_amount,sum(ap.amount) as dpayment_amount,ap.cheque_no,ap.bank_name,ap.branch_name,ap.created_on,ap.particulars,ap.expense_type FROM account_payment ap,expense e,vendor v,ledger_list ll WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.ledger_list_id = ll.ledger_list_id $iloc AND ap.expense_type='expense' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' AND ap.status!=2 GROUP BY v.vendor_id)UNION(SELECT ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ar.ledger_list2_id as vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(ar.amount) as cpayment_amount,0 as dpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,'' as expense_type FROM account_journal ar WHERE ar.ledger_list2_type='vendor' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' $ajloc AND ar.status!=2 GROUP BY ar.ledger_list2_id)UNION(SELECT ar.account_journal_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ar.ledger_list1_id as vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(ar.amount) as dpayment_amount,ar.cheque_no,ar.bank_name,ar.branch_name,ar.created_on,ar.remarks as particulars,'' as expense_type FROM account_journal ar WHERE ar.ledger_list1_type='vendor' AND ar.account_journal_date>='$fdate' AND ar.account_journal_date<='$tdate' $ajloc AND ar.status!=2 GROUP BY ar.ledger_list1_id)UNION(SELECT ap.account_payment_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,ap.parti_ledger_list_id as vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(ap.amount) as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,ap.created_on,ap.particulars,'' as expense_type 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' $iloc AND ap.status!=2 GROUP BY ap.parti_ledger_list_id)UNION(SELECT cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(cdn.amount) as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on, cdn.particulars,'' as expense_type FROM credit_debit_note cdn,vendor v WHERE cdn.vendor_id = v.vendor_id AND cdn.credit_debit = 'Debit' AND cdn.type_id = 0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc AND cdn.status!=2 GROUP BY v.vendor_id)UNION(SELECT cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(cdn.amount) as cpayment_amount,0 as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on, cdn.particulars,'' as expense_type FROM credit_debit_note cdn,vendor v WHERE cdn.vendor_id = v.vendor_id AND cdn.credit_debit = 'Receipt' AND cdn.type_id = 0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc AND cdn.status!=2 GROUP BY v.vendor_id)UNION(SELECT cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(cdn.amount) as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on, cdn.particulars,'' as expense_type FROM credit_debit_note cdn,purchase p,grn g,vendor v WHERE cdn.type_id = p.purchase_id AND p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND cdn.credit_debit = 'Debit' AND cdn.type_id != 0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc AND cdn.status!=2 GROUP BY v.vendor_id)UNION(SELECT cdn.credit_debit_note_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id as vendor_id,0 as oth_id,'' as payment_mode,'credit' as payment_type,sum(cdn.amount) as cpayment_amount,0 as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,cdn.created_on, cdn.particulars,'' as expense_type FROM credit_debit_note cdn,purchase p,grn g,vendor v WHERE cdn.type_id = p.purchase_id AND p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND cdn.credit_debit = 'Receipt' AND cdn.type_id != 0 AND cdn.credit_debit_note_date>='$fdate' AND cdn.credit_debit_note_date<='$tdate' $cdnloc AND cdn.status!=2 GROUP BY v.vendor_id)UNION(SELECT tp.tds_payable_line_item_date as pdate,0 as order_id,0 as invoice_id,0 as customer_id,v.vendor_id,0 as oth_id,'' as payment_mode,'debit' as payment_type,0 as cpayment_amount,sum(tp.amount) as dpayment_amount,'' as cheque_no,'' as bank_name,'' as branch_name,tp.created_on,'TDS' as particulars,'' as expense_type 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 tp.tds_payable_line_item_date>='$fdate' AND tp.tds_payable_line_item_date<='$tdate' $eloc AND tp.status!=2 GROUP BY v.vendor_id)) ven GROUP BY ven.vendor_id ORDER BY ven.vendor_id ASC")->result_array();

$account_journal_list = $this->db->query("SELECT aj.*,aa.account_attributes, sum(aj.amount) as tamt FROM account_journal aj,account_attributes aa WHERE aj.account_attributes_id = aa.account_attributes_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $ajcid GROUP BY aj.account_attributes_id ORDER BY aj.account_journal_id DESC")->result_array();

$purchase_amt = $this->db->query("SELECT sum(p.taxable_amount) as amt,sum(p.other_charges) as ocharge FROM `purchase`p, purchase_order po WHERE p.purchase_order_id = po.purchase_order_id AND p.invoice_date>='$fdate' AND p.invoice_date<='$tdate' AND p.status!=5 $purid")->row();

$in_direct_expense = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.tamt) as amt, sum(led.other_charges_amt) as oc_amount FROM ((SELECT e.expense_date,e.invoice_no,sum(e.taxable_value) as tamt,sum(e.other_charges) as other_charges_amt,e.other_charges,e.sgst,e.cgst,e.igst,e.total_amount,e.tds_value,v.vendor_name,v.gst_no,lg.ledger_group,lg.ledger_group_id FROM `expense` e,vendor v,ledger_group lg,ledger_type lt WHERE e.vendor_id = v.vendor_id AND e.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND e.expense_date>='$fdate' AND e.expense_date<='$tdate' AND e.status!=2 AND lt.expense_type = 'In Direct' $slocid GROUP BY lg.ledger_group_id) UNION (SELECT l.ledger_date,l.ledger_no as invoice_no,sum(l.amount) as tamt,0 as other_charges_amt,0 as other_charges,0 as sgst,0 as cgst,0 as igst,l.amount as total_amount,0 as tds_value,l.payee_name as vendor_name ,'' as gst_no,lg.ledger_group,lg.ledger_group_id FROM ledger l,ledger_sub_group lsg,ledger_group lg,ledger_type lt WHERE l.ledger_sub_group_id = lsg.ledger_sub_group_id AND lsg.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND l.status=0 AND lt.expense_type = 'In Direct' AND l.ledger_date>='$fdate' AND l.ledger_date<='$tdate' $decid GROUP BY lg.ledger_group_id)UNION(SELECT e.staff_expense_date,e.voucher_no as invoice_no,sum(e.net_salary) as tamt,0 as other_charges_amt,0 as other_charges,0 as sgst,0 as cgst,0 as igst,e.net_salary as total_amount,0 as tds_value,'' as vendor_name ,'' as gst_no,lg.ledger_group,lg.ledger_group_id FROM staff_expense e,ledger_group lg,ledger_type lt WHERE e.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND e.status != 2 AND lt.expense_type = 'In Direct' AND e.staff_expense_date>='$fdate' AND e.staff_expense_date<='$tdate' $slocid GROUP BY lg.ledger_group_id)) led GROUP BY led.ledger_group_id ")->result_array();

$sales_amt = $this->db->query("SELECT sum(a.taxamt) as txamt,sum(a.pcharge) as pc, sum(a.ocharge) as oc FROM ((SELECT sum(i.taxable_amount) as taxamt,sum(i.packing_charges) as pcharge,sum(i.other_charges) as ocharge FROM invoice i,`order` o WHERE i.order_id = o.order_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $compqry)UNION(SELECT sum(i.taxable_amount) as taxamt,sum(i.packing_charges) as pcharge,sum(i.other_charges) as ocharge FROM invoice i WHERE i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $dcompqry)) a")->row();

$direct_invoice = $this->db->query("SELECT sum(grand_total) as amt FROM `invoice` WHERE invoice_date>='$fdate' AND invoice_date<='$tdate' AND customer_id!=0 $cid")->row();

$direct_expense = $this->db->query("SELECT lg.ledger_group_id,lsg.ledger_sub_group,sum(l.amount) as amt FROM `ledger` l,ledger_sub_group lsg,ledger_group lg,ledger_type lt WHERE l.ledger_sub_group_id = lsg.ledger_sub_group_id AND lsg.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND l.ledger_date>='$fdate' AND l.ledger_date<='$tdate' $decid AND l.status=0 AND lt.expense_type = 'Direct' GROUP BY l.ledger_sub_group_id")->result_array();

$direct_expense_list = $this->db->query("SELECT s.ledger_group_id,s.ledger_group, sum(s.amt) as amount, sum(s.other_charges_amt) as oc_amount FROM ((SELECT lg.ledger_group_id, lg.ledger_group,sum(e.taxable_value) as amt,sum(e.other_charges) as other_charges_amt FROM expense e,ledger_group lg,ledger_type lt WHERE e.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND e.status != 2 AND lt.expense_type = 'Direct' AND e.expense_date>='$fdate' AND e.expense_date<='$tdate' $slocid GROUP BY lg.ledger_group_id)UNION(SELECT lg.ledger_group_id, lg.ledger_group,sum(e.net_salary) as amt, 0 as other_charges_amt FROM staff_expense e,ledger_group lg,ledger_type lt WHERE e.ledger_group_id = lg.ledger_group_id AND lg.ledger_type_id = lt.ledger_type_id AND e.status != 2 AND lt.expense_type = 'Direct' AND e.staff_expense_date>='$fdate' AND e.staff_expense_date<='$tdate' $slocid GROUP BY lg.ledger_group_id)) s GROUP BY s.ledger_group_id ")->result_array();

$direct_expense_ledger = $this->Profitloss_model->get_direct_expense_ledger();
      $indirect_expense_ledger = $this->Profitloss_model->get_indirect_expense_ledger();
      $direct_expense_group = $this->Profitloss_model->get_direct_expense_voucher_group();
      $in_direct_expense_group = $this->Profitloss_model->get_indirect_expense_voucher_group();

$direct_income_ledger = $this->Profitloss_model->get_direct_income_ledger_list();
      $indirect_income_ledger = $this->Profitloss_model->get_indirect_income_ledger_list();

$acdeb=0;
    $accre=0;
    $var = 'A';$j=5;$ltot=0;foreach($liabilities_list as $llist){

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
 $data1['side'] = 'Left';
 $data1['parent_id'] = 0;
 $data1['main_title'] = $llist['account_category'];
 $data1['sub_title'] = '';
 $data1['inner_title'] = '';
 $data1['amount_1'] = 0;
 $data1['amount_2'] = 0;
 $data1['amount_3'] = 0;
 $this->Accountsjob_model->create_accounts_cron_job_result($data1);
$j++;
 $aattri = explode(',', $llist['account_attributes']);
 $aattriid = explode(',', $llist['account_attributes_id']);
 $bs_status = explode(',', $llist['bs_status']);
 $lhcre=$lhdeb=0;for($i=0;$i<count($aattri);$i++)
 {

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
                          $data1['side'] = 'Left';
                          $data1['parent_id'] = 0;
                          $data1['main_title'] = '';
                          $data1['sub_title'] = $aattri[$i];
                          $data1['inner_title'] = '';
                          $data1['amount_1'] = 0;
                          $data1['amount_2'] = 0;
                          $data1['amount_3'] = 0;
                          $this->Accountsjob_model->create_accounts_cron_job_result($data1);
                          $last_sub_title = $this->Accountsjob_model->get_last_sub_title_record();

$totcre=0;
                                       $totdeb=0;
                                
                                  if($bs_status[$i]==0)
                                  {
                                      $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_company_id($aattriid[$i],$company_id);

if(count($ledger_list)>0)
                                      {
                                        $ledgerAmt = 0;
                                        foreach($ledger_list as $u_list)
                                        {
                                          $ledgcre=0;
                                          $ledgdeb=0;
                                          if($u_list['crdr']==1)
                                          {
                                            $opdeb = abs($u_list['opening_balance']);
                                            $opcre = 0;
                                          }
                                          else
                                          {
                                            $opdeb = 0;
                                            $opcre = abs($u_list['opening_balance']);
                                          }

if($tdate=='')
                                            {
                                              
                                                    $current_ledger_details_view_list = $this->Balancesheet_model->get_ledger_details_view_by_custom_date_cid($fdate,$fdate,$u_list['ledger_list_id'],$company_id);

if(count($current_ledger_details_view_list>0))
                                              {
                                                foreach($current_ledger_details_view_list as $opdet)
                                                {
                                                  if($opdet['payment_type']=='credit')
                                                  {
                                                    if($opdet['user_type'] == 'Sales')
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='Invoice')
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='transfer')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='withdraw')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='deposit')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='cash transfer')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Purchase Tax' || $opdet['user_type']=='Expense Tax')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'CN INV' || $opdet['user_type'] == 'RCN INV')  
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'CN OTH')                  
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'RCN OTH')                 
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    } 
                                                    else if($opdet['user_type']=='STF Deduct')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }   
                                                    else if($opdet['user_type']=='Fixed Asset')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Journal')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    } 
                                                    else if($opdet['user_type']=='Debit Receipt for P&L')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }   
                                                    else
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                  }
                                                  else
                                                  {
                                                    if($opdet['expense_type'] == 'vendor payment')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['expense_type'] == 'expense')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['expense_type'] == 'staff expense')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='deposit')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='withdraw')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='transfer')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='cash transfer')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Voucher')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Invoice Tax')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='TDS')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='STF EXP')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='STF Allow')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'DN PUR' || $opdet['user_type'] == 'PDN PUR')  
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'DN OTH')                  
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'PDN OTH')                 
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }   
                                                    else if($opdet['user_type']=='Journal')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Credit Receipt for P&L')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                  }
                                                 }
                                              }

$opbal = $opdeb-$opcre;

}
                                            else
                                            {

if($fdate>'2019-04-01')
                                                    $previous_ledger_details_view_list = $this->Balancesheet_model->get_ledger_details_view_by_custom_date_cid($psdate,$pdate,$u_list['ledger_list_id'],$company_id);

if(count($previous_ledger_details_view_list>0))
                                              {
                                                foreach($previous_ledger_details_view_list as $opdet)
                                                {
                                                  if($opdet['payment_type']=='credit')
                                                  {
                                                    if($opdet['user_type'] == 'Sales')
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='Invoice')
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='transfer')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='withdraw')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='deposit')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='cash transfer')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Purchase Tax' || $opdet['user_type']=='Expense Tax')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'CN INV' || $opdet['user_type'] == 'RCN INV')  
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'CN OTH')                  
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'RCN OTH')                 
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    } 
                                                    else if($opdet['user_type']=='STF Deduct')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }   
                                                    else if($opdet['user_type']=='Fixed Asset')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Journal')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    } 
                                                    else if($opdet['user_type']=='Debit Receipt for P&L')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }   
                                                    else
                                                    {
                                                      $opcre+= 0;
                                                      $opdeb+= $opdet['amount'];
                                                    }
                                                  }
                                                  else
                                                  {
                                                    if($opdet['expense_type'] == 'vendor payment')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['expense_type'] == 'expense')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['expense_type'] == 'staff expense')
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                    else if($opdet['user_type']=='deposit')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='withdraw')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='transfer')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='cash transfer')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Voucher')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Invoice Tax')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='TDS')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='STF EXP')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type']=='STF Allow')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'DN PUR' || $opdet['user_type'] == 'PDN PUR')  
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'DN OTH')                  
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else if($opdet['user_type'] == 'PDN OTH')                 
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }   
                                                    else if($opdet['user_type']=='Journal')
                                                    {
                                                      $opdeb+= $opdet['amount'];
                                                      $opcre+= 0;
                                                    }
                                                    else if($opdet['user_type']=='Credit Receipt for P&L')
                                                    {
                                                      $opcre+= $opdet['amount'];
                                                      $opdeb+= 0;
                                                    }
                                                    else
                                                    {
                                                      $opdeb+= 0;
                                                      $opcre+= $opdet['amount'];
                                                    }
                                                  }
                                                 }
                                              }

$current_ledger_details_view_list = $this->Balancesheet_model->get_ledger_details_view_by_custom_date_cid($fdate,$tdate,$u_list['ledger_list_id'],$company_id);

$opbal = $opdeb-$opcre;

}

$ledgcre+=$opcre;
                                        $ledgdeb+=$opdeb;

if($opbal>0)
                                          {

$lamt= $opbal;
                                          }
                                          else
                                          {
                                            $lamt= $opbal;
                                          }

$ledgbal = $ledgcre-$ledgdeb;
                                          /*if($ledgbal>0)
                                          {
                                            $ledtype = 'CR';
                                            $totcre+=$ledgbal;
                                          }
                                          else
                                          {
                                            $ledtype = 'DR';
                                            $totdeb+=abs($ledgbal);
                                          }*/
                                          if($llist['account_category']=='Capital Account')
                                            $totcre+=$ledgbal;
                                          else
                                            $totcre+=$ledgbal;

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
                              $data1['side'] = 'Left';
                              $data1['parent_id'] = $last_sub_title->accounts_cron_job_result_id;
                              $data1['main_title'] = '';
                              $data1['sub_title'] = '';
                              $data1['inner_title'] = $u_list['ledger_list'];
                              $data1['amount_1'] = $ledgdeb;
                              $data1['amount_2'] = $ledgcre;
                              $data1['amount_3'] = $ledgbal;
                              $this->Accountsjob_model->create_accounts_cron_job_result($data1);

if($opbal>0)
                                            $ledgerAmt+= $opbal;
                                          else
                                            $ledgerAmt+= $opbal;
                                        }
                                      $lcheck=1; $ltot+=abs($ledgerAmt);}
                                      else
                                      {
                                        $lopt = '';
                                        $lcheck=0;
                                      }

$this->db->query("UPDATE `accounts_cron_job_result` SET `amount_1`='".$totdeb."', `amount_2`='".$totcre."' WHERE `accounts_cron_job_result_id`='".$last_sub_title->accounts_cron_job_result_id."'");

$acdeb+=$totdeb;$accre+=$totcre;$j++;}else if($bs_status[$i]==1){

$sctot = 0;

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
                        $data1['side'] = 'Left';
                        $data1['parent_id'] = 0;
                        $data1['main_title'] = '';
                        $data1['sub_title'] = $aattri[$i];
                        $data1['inner_title'] = '';
                        $data1['amount_1'] = 0;
                        $data1['amount_2'] = 0;
                        $data1['amount_3'] = 0;
                        $this->Accountsjob_model->create_accounts_cron_job_result($data1);

$last_sub_title = $this->Accountsjob_model->get_last_sub_title_record();

foreach($sundry_creditors_list as $sc_list){
                                      $vendorDetails = $this->Ledger_model->get_vendor_by_id($sc_list['vendor_id']);
                                      if($vendorDetails->status==0)
                                      {
                                            $id=$sc_list['vendor_id'];

$opening_balance_details = $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.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.vendor_id=$id $vob)")->result_array();

if($fdate>'2019-04-01')
 {
 $previous_ledger_list = $this->db->query("(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>='$psdate' AND p.purchase_date<='$pdate' AND p.vendor_id=$id AND p.status!=2)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.expense_date>='$psdate' AND e.expense_date<='$pdate' AND e.vendor_id=$id $eloc AND e.status!=2)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>='$psdate' AND ap.account_payment_date<='$pdate' AND v.vendor_id=$id $iloc AND ap.status!=2)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>='$psdate' AND ap.account_payment_date<='$pdate' AND v.vendor_id=$id $iloc AND ap.status!=2)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>='$psdate' AND ar.account_journal_date<='$pdate' AND ar.ledger_list2_id=$id $ajloc AND ar.status!=2)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>='$psdate' AND ar.account_journal_date<='$pdate' AND ar.ledger_list1_id=$id $ajloc AND ar.status!=2)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>='$psdate' AND ap.account_payment_date<='$pdate' AND ap.parti_ledger_list_id=$id $iloc AND ap.status!=2)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>='$psdate' AND tp.tds_payable_line_item_date<='$pdate' $eloc AND tp.status!=2) 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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' $cdnloc AND cdn.status!=2)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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' $cdnloc AND cdn.status!=2)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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' $cdnloc AND cdn.status!=2)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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' $cdnloc AND cdn.status!=2)ORDER BY op ASC, pdate ASC")->result_array();
 }

$ledger_det_list = $this->db->query("(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 AND p.status!=2)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.expense_date>='$fdate' AND e.expense_date<='$tdate' AND e.vendor_id=$id $eloc AND e.status!=2)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 AND ap.status!=2)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 AND ap.status!=2)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 AND ar.status!=2)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 AND ar.status!=2)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 AND ap.status!=2)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 AND tp.status!=2) 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 AND cdn.status!=2)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 AND cdn.status!=2)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 AND cdn.status!=2)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 AND cdn.status!=2)ORDER BY op ASC, pdate ASC")->result_array();

$opcre=$opdeb=0;
                                        foreach($opening_balance_details as $opdet)
                                        {
                                          if($opdet['payment_type']=='credit')
                                          {
                                            $opdeb+= 0;
                                            $opcre+= $opdet['payment_amount']!=''?$opdet['payment_amount']:0;
                                          }
                                          else
                                          {
                                            $opcre+= 0;
                                            $opdeb+= $opdet['payment_amount']!=''?$opdet['payment_amount']:0;
                                          }
                                        }

if(count($previous_ledger_list>0))
                                        {
                                          foreach($previous_ledger_list as $opdet)
                                          {
                                            if($opdet['payment_type']=='credit')
                                            {
                                              $opdeb+= 0;
                                              $opcre+= $opdet['payment_amount'];
                                            }
                                            else
                                            {
                                              $opcre+= 0;
                                              $opdeb+= $opdet['payment_amount'];
                                            }
                                           }
                                        }

$opbal = $opcre-$opdeb;

$credit = $opcre;
          $debit = $opdeb;

$op=0;foreach ($ledger_det_list as $ud_list ) {

if($opbal=='')
 {
 $op=0;
 if($ud_list['payment_type']=='credit')
 {
 $deb = 0;
 $cre = $ud_list['payment_amount'];
 }
 else
 {
 $cre = 0;
 $deb = $ud_list['payment_amount'];
 }
 }
 else
 {
 if($ud_list['particulars']=='Opening Balance' && $op==0)
 {
 if($opbal<0)
 {
 $cre=abs($opbal);
 $deb = 0;
 }
 else
 {
 $cre=0;
 $deb=abs($opbal);
 }
 $op=1;
 }
 else
 { 
 if($op==1)
 {
 $deb = $deb;
 $cre = $cre;
 }
 $op=0; 
 if($ud_list['payment_type']=='credit')
 {
 if($ud_list['particulars']!='Opening Balance')
 {
 $deb = 0;
 $cre = $ud_list['payment_amount'];
 }
 }
 else
 {
 if($ud_list['particulars']!='Opening Balance')
 {
 $cre = 0;
 $deb = $ud_list['payment_amount'];
 }
 }
 }
 }
 if($op==0)
 {
 $debit+=$deb;$credit+=$cre;
 $lbal = $credit-$debit;
 }
 }
$bal = $credit-$debit;
 //$bal = ($opcre+$sc_list['cpamt'])-($opdeb+$sc_list['dpamt']);
 /*$totcre+=$opcre+$sc_list['cpamt'];
 $totdeb+=$opdeb+$sc_list['dpamt'];*/

/*$ledgcre=$opcre+$sc_list['cpamt'];
                                      $ledgdeb=$opdeb+$sc_list['dpamt'];*/

$ledgcre=$credit;
                                      $ledgdeb=$debit;
                                          
                                      $ledgbal = $ledgcre-$ledgdeb;
                                      if($ledgbal>0)
                                      {
                                        $ledtype = 'CR';
                                        $totcre+=$ledgbal;
                                      }
                                      else
                                      {
                                        $ledtype = 'DR';
                                        $totdeb+=abs($ledgbal);
                                      }

if(round($bal)!=0)
{
                                      $data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
                              $data1['side'] = 'Left';
                              $data1['parent_id'] = $last_sub_title->accounts_cron_job_result_id;
                              $data1['main_title'] = '';
                              $data1['sub_title'] = '';
                              $data1['inner_title'] = $vendorDetails->vendor_name.' - '.$vendorDetails->contact_no;
                              $data1['amount_1'] = $ledgdeb;
                              $data1['amount_2'] = $ledgcre;
                              $data1['amount_3'] = $ledgbal;
                              $this->Accountsjob_model->create_accounts_cron_job_result($data1);
                            }

$sctot+=$bal;}}
                                    
                                    
                                    $this->db->query("UPDATE `accounts_cron_job_result` SET `amount_1`='".abs($totdeb)."', `amount_2`='".abs($totcre)."' WHERE `accounts_cron_job_result_id`='".$last_sub_title->accounts_cron_job_result_id."'");

$j++;
                                  $ltot+=$sctot;$acdeb+=$totdeb;$accre+=$totcre;}
                                 $lhcre+=$totcre;$lhdeb+=$totdeb;}

/*$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
                        $data1['side'] = 'Left';
                        $data1['parent_id'] = 0;
                        $data1['main_title'] = '';
                        $data1['sub_title'] = 'Total';
                        $data1['inner_title'] = '';
                        $data1['amount_1'] = $lhdeb;
                        $data1['amount_2'] = $lhcre;
                        $data1['amount_3'] = 0;
                        $this->Accountsjob_model->create_accounts_cron_job_result($data1);*/

$j++;}

$atot=0;foreach($assets_list as $llist){

$aattri = explode(',', $llist['account_attributes']);
 $aattriid = explode(',', $llist['account_attributes_id']);
 $bs_status = explode(',', $llist['bs_status']);
 $ahcre=$ahdeb=0;for($i=0;$i<count($aattri);$i++)
 {

$totcre=0;
         $totdeb=0;

if($bs_status[$i]==0)
    {

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
              $data1['side'] = 'Left';
              $data1['parent_id'] = 0;
              $data1['main_title'] = '';
              $data1['sub_title'] = $aattri[$i];
              $data1['inner_title'] = '';
              $data1['amount_1'] = 0;
              $data1['amount_2'] = 0;
              $data1['amount_3'] = 0;
              $this->Accountsjob_model->create_accounts_cron_job_result($data1);

$last_sub_title = $this->Accountsjob_model->get_last_sub_title_record();

$ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_company_id($aattriid[$i],$company_id);
         
        if(count($ledger_list)>0)
        {
          $ledgerAssAmt = 0;
          foreach($ledger_list as $u_list)
          {
                                          $ledgcre=0;
                                          $ledgdeb=0;
            if($u_list['crdr']==1)
            {
              $opdeb = abs($u_list['opening_balance']);
              $opcre = 0;
            }
            else
            {
              $opdeb = 0;
              $opcre = abs($u_list['opening_balance']);
            }

if($tdate=='')
              {
                
                    $current_ledger_details_view_list = $this->Balancesheet_model->get_ledger_details_view_by_custom_date_cid($fdate,$fdate,$u_list['ledger_list_id'],$company_id);

$opbal = $opdeb-$opcre;
              }
              else
              {

if($fdate>'2019-04-01')
                    $previous_ledger_details_view_list = $this->Balancesheet_model->get_ledger_details_view_by_custom_date_cid($psdate,$pdate,$u_list['ledger_list_id'],$company_id);

$opbal = $opdeb-$opcre;
              }
            
          
          $ledgcre+=$opcre;
          $ledgdeb+=$opdeb;
            if($opbal>0)
              $lamt = $opbal;
            else
              $lamt = $opbal;

//$ledgbal = $ledgcre-$ledgdeb;
            $ledgbal = $ledgdeb-$ledgcre;
          /*if($ledgbal>0)
          {
            $ledtype = 'CR';
            $totcre+=$ledgbal;
          }
          else
          {
            $ledtype = 'DR';
            $totdeb+=$ledgbal;
          }*/
          $totdeb+=$ledgbal;

if($opbal>0)
              $ledgerAssAmt+= $opbal;
            else
              $ledgerAssAmt+= $opbal;
          }

$acheck=1; $atot+=$ledgerAssAmt;}
        else
        {
          $lopt = '';
          $acheck=0;
        }

$this->db->query("UPDATE `accounts_cron_job_result` SET `amount_1`='".abs($totdeb)."', `amount_2`='".abs($totcre)."' WHERE `accounts_cron_job_result_id`='".$last_sub_title->accounts_cron_job_result_id."'");

$j++;}else if($bs_status[$i]==1){
      $sdtot = 0;

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
              $data1['side'] = 'Left';
              $data1['parent_id'] = 0;
              $data1['main_title'] = '';
              $data1['sub_title'] = $aattri[$i];
              $data1['inner_title'] = '';
              $data1['amount_1'] = 0;
              $data1['amount_2'] = 0;
              $data1['amount_3'] = 0;
              $this->Accountsjob_model->create_accounts_cron_job_result($data1);

$last_sub_title = $this->Accountsjob_model->get_last_sub_title_record();

$id = $sd_list['customer_id'];

$opening_balance_details = $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.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.customer_id=$id $cob)")->result_array();

if($fdate>'2019-04-01')
 {
 $previous_ledger_list = $this->db->query("(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>='$psdate' AND i.invoice_date<='$pdate' AND i.customer_id=$id $invloc AND i.status!=20)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>='$psdate' AND i.invoice_date<='$pdate' AND o.customer_id=$id $oloc AND i.status!=20)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>='$psdate' AND ar.account_receipt_date<='$pdate' AND o.customer_id=$id AND ar.status!=2 $oloc)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>='$psdate' AND ar.account_receipt_date<='$pdate' AND o.customer_id=$id AND ar.status!=2 $oloc)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>='$psdate' AND ar.account_receipt_date<='$pdate' AND i.customer_id=$id AND ar.status!=2 $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>='$psdate' AND ar.account_journal_date<='$pdate' AND ar.ledger_list2_id=$id AND ar.status!=2 $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>='$psdate' AND ar.account_journal_date<='$pdate' AND ar.ledger_list1_id=$id AND ar.status!=2 $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.adjustment_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>='$psdate' AND ar.account_receipt_date<='$pdate' AND ar.parti_ledger_list_id=$id AND ar.status!=2 $iloc)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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $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>='$psdate' AND cdn.credit_debit_note_date<='$pdate' AND cdn.status!=2 $cdnloc)ORDER BY op ASC, pdate ASC")->result_array();
 }

$ledger_cre_list = $this->db->query("(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 $invloc AND i.status!=20)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 $oloc AND i.status!=20)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 AND ar.status!=2 $oloc)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 AND ar.status!=2 $oloc)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 AND ar.status!=2 $invloc)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 AND ar.status!=2 $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 AND ar.status!=2 $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.adjustment_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, ledger_list ll, location l WHERE ar.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_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 AND ar.status!=2 $iloc)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,ll.ledger_list,l.location_name, 1 as op FROM credit_debit_note cdn, ledger_list ll, location l WHERE cdn.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_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' AND cdn.status!=2 $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,ll.ledger_list,l.location_name, 1 as op FROM credit_debit_note cdn, ledger_list ll, location l WHERE cdn.ledger_list_id = ll.ledger_list_id AND ll.location_id = l.location_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' AND cdn.status!=2 $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' AND cdn.status!=2 $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' AND cdn.status!=2 $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' AND cdn.status!=2 $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' AND cdn.status!=2 $cdnloc)ORDER BY op ASC, pdate ASC")->result_array();

$opdeb=$opcre=0;
              foreach($opening_balance_details as $opdet)
          {
            if($opdet['payment_type']=='credit')
            {
              $opdeb+= 0;
              $opcre+= $opdet['payment_amount']!=''?$opdet['payment_amount']:0;
            }
            else
            {
              $opcre+= 0;
              $opdeb+= $opdet['payment_amount']!=''?$opdet['payment_amount']:0;
            }
          }

$opbal = $opcre-$opdeb;
          $lbal=$opbal;

$credit = $opcre;
          $debit = $opdeb;

$op=0;foreach ($ledger_cre_list as $uc_list ) {

if($opbal=='')
 {
 $op=0;
 if($uc_list['payment_type']=='credit')
 {
 $deb = 0;
 $cre = $uc_list['payment_amount'];
 }
 else
 {
 $cre = 0;
 $deb = $uc_list['payment_amount'];
 }
 }
 else
 {
 if($uc_list['particulars']=='Opening Balance' && $op==0)
 {
 if($opbal<0)
 {
 $cre=abs($opbal);
 $deb = 0;
 }
 else
 {
 $cre=0;
 $deb=abs($opbal);
 }
 $op=1;
 }
 else
 { 
 if($op==1)
 {
 $deb = $deb;
 $cre = $cre;
 }
 $op=0; 
 if($uc_list['payment_type']=='credit')
 {
 if($uc_list['particulars']!='Opening Balance')
 {
 $deb = 0;
 $cre = $uc_list['payment_amount'];
 }
 }
 else
 {
 if($uc_list['particulars']!='Opening Balance')
 {
 $cre = 0;
 $deb = $uc_list['payment_amount'];
 }
 }
 }
 }
 if($op==0)
 {
 $debit+=$deb;$credit+=$cre;
 $lbal = $lbal+$cre-$deb;
 }
 }

//$bal = ($opdeb+$sd_list['dpamt'])-($opcre+$sd_list['cpamt']);
          $bal = $debit-$credit;

//$ledgcre=$opcre+$sd_list['cpamt'];
        //$ledgdeb=$opdeb+$sd_list['dpamt'];
        $ledgcre=$credit;
        $ledgdeb=$debit;

//$ledgbal = $ledgcre-$ledgdeb;
        $ledgbal = $ledgdeb-$ledgcre;
        if($ledgbal>0)
        {
          $ledtype = 'CR';
          $totdeb+=$ledgbal;
        }
        else
        {
          $ledtype = 'DR';
          $totcre+=abs($ledgbal);
        }

if(round($bal)!=0)
        {
          $data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
          $data1['side'] = 'Left';
          $data1['parent_id'] = $last_sub_title->accounts_cron_job_result_id;
          $data1['main_title'] = '';
          $data1['sub_title'] = '';
          $data1['inner_title'] = $customerDetails->customer_name;
          $data1['amount_1'] = $ledgdeb;
          $data1['amount_2'] = $ledgcre;
          $data1['amount_3'] = $ledgbal;
          $this->Accountsjob_model->create_accounts_cron_job_result($data1);
        }

$sdtot+=$bal;}

$atot+=$sdtot;}
   $acdeb+=abs($totdeb);$accre+=$totcre;$ahcre+=$totcre;$ahdeb+=$totdeb;}  
  
    /*$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
  $data1['side'] = 'Left';
  $data1['parent_id'] = 0;
  $data1['main_title'] = '';
  $data1['sub_title'] = 'Total';
  $data1['inner_title'] = '';
  $data1['amount_1'] = abs($ahdeb);
  $data1['amount_2'] = abs($ahcre);
  $data1['amount_3'] = 0;
  $this->Accountsjob_model->create_accounts_cron_job_result($data1);*/
 $j++;}

$j++;
$acdeb+=$processing_account_job_list->opening_stock;

if(count($direct_expense)>0 || count($direct_expense_ledger)>0 || count($direct_expense_group)>0){

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
$data1['side'] = 'Left';
$data1['parent_id'] = 0;
$data1['main_title'] = 'Direct Expense';
$data1['sub_title'] = '';
$data1['inner_title'] = '';
$data1['amount_1'] = 0;
$data1['amount_2'] = 0;
$data1['amount_3'] = 0;
$this->Accountsjob_model->create_accounts_cron_job_result($data1);

$j++;
}

$de=1; $etot=0; $decre=$dedeb=0; foreach($direct_expense_group as $degroup){

$detot=0;
  $direct_expense_ledger = $this->Profitloss_model->get_direct_expense_ledger_by_group_comp_id($degroup['ledger_group_id'],$company_id);

$detot=0;foreach($direct_expense_ledger as $del){

$ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_cid_daterange($del['ledger_list_id'],$company_id,$fdate,$tdate);

$deltot = 0;
  foreach($ledgdet as $dldet)
  {
    if($dldet['payment_type']=='credit')
    {
      $deltot+=$dldet['amount'];
    }
    else
    {
      $deltot-=$dldet['amount'];
    }
  }
  $detot+=abs($deltot);

}

$deamt = 0;foreach($direct_expense as $llist){
    if($llist['ledger_group_id'] == $degroup['ledger_group_id']){

$deamt+=abs($llist['amt']);}}

$dseamt = 0;foreach($direct_expense_list as $llist){
    if($llist['ledger_group_id'] == $degroup['ledger_group_id']){

$dseamt+=abs($llist['amount']+$llist['oc_amount']);}}

$this->db->query("UPDATE `accounts_cron_job_result` SET `amount_1`='".($deamt+$detot+$dseamt)."', `amount_2`='0' WHERE `accounts_cron_job_result_id`='".$last_sub_title->accounts_cron_job_result_id."'");

$j++;
$de++;$etot+=($deamt+$detot+$dseamt);$acdeb+=($deamt+$detot+$dseamt);$decre+=0;$dedeb+=($deamt+$detot+$dseamt);}

if(count($direct_expense)>0 || count($direct_expense_ledger)>0 || count($direct_expense_group)>0){

$j++;
}

if(count($in_direct_expense_group)>0){

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
$data1['side'] = 'Left';
$data1['parent_id'] = 0;
$data1['main_title'] = 'In Direct Expense';
$data1['sub_title'] = '';
$data1['inner_title'] = '';
$data1['amount_1'] = 0;
$data1['amount_2'] = 0;
$data1['amount_3'] = 0;
$this->Accountsjob_model->create_accounts_cron_job_result($data1);

$j++;
}

$ide=1; $ietot=0;$idecre=$idedeb=0;foreach($in_direct_expense_group as $idegroup){

$data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
$data1['side'] = 'Left';
$data1['parent_id'] = 0;
$data1['main_title'] = '';
$data1['sub_title'] = $idegroup['ledger_group'];
$data1['inner_title'] = '';
$data1['amount_1'] = 0;
$data1['amount_2'] = 0;
$data1['amount_3'] = 0;
$this->Accountsjob_model->create_accounts_cron_job_result($data1);
$last_sub_title = $this->Accountsjob_model->get_last_sub_title_record();
 
        $indirect_expense_ledger = $this->Profitloss_model->get_indirect_expense_ledger_by_group_comp_id($idegroup['ledger_group_id'],$company_id);

$idetot=0;foreach($indirect_expense_ledger as $idel)
        {
          $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_cid_daterange($idel['ledger_list_id'],$company_id,$fdate,$tdate);

$ideltot = 0;
          foreach($ledgdet as $dldet)
          {
            if($dldet['payment_type']=='credit')
            {
              //$ideltot+=$dldet['amount'];
              if($dldet['user_type']!='STF Deduct')
              {
                $ideltot+=$dldet['amount'];
              }
              else
              {
                $ideltot-=$dldet['amount'];
              }
            }
            else
            {
              if($idel['ledger_list_id']==38 || $idel['ledger_list_id']==39)
              {
                if($dldet['user_type']!='Journal')
                  $ideltot-=$dldet['amount'];
              }
              else
              {
                $ideltot-=$dldet['amount'];
              }
            }
          }
          if($idel['ledger_list_id']==225)
          {
            $lamt2 = abs($ideltot);
            $lamt1=0;
          }
          else
          {
            $lamt2 = 0;
            $lamt1=abs($ideltot);
          }
          $idetot+=$lamt1-$lamt2;

$ideamt = 0; foreach($in_direct_expense as $llist){
      if($llist['ledger_group_id'] == $idegroup['ledger_group_id']){

$this->db->query("UPDATE `accounts_cron_job_result` SET `amount_1`='".($ideamt+$idetot)."', `amount_2`='0' WHERE `accounts_cron_job_result_id`='".$last_sub_title->accounts_cron_job_result_id."'");
$j++;

$ide++;$ietot+=($ideamt+$idetot);$acdeb+=($ideamt+$idetot);$idecre+=0;$idedeb+=($ideamt+$idetot);}

/*if(count($in_direct_expense_group)>0){

if(count($direct_income_ledger)>0){
  $data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
  $data1['side'] = 'Left';
  $data1['parent_id'] = 0;
  $data1['main_title'] = 'Direct Income';
  $data1['sub_title'] = '';
  $data1['inner_title'] = '';
  $data1['amount_1'] = 0;
  $data1['amount_2'] = 0;
  $data1['amount_3'] = 0;
  $this->Accountsjob_model->create_accounts_cron_job_result($data1);

$j++;
  foreach($direct_income_ledger as $diledger)
  {

if($diledger['location_id'] == $company_id)
    {

$prevaccrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevaccorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevaccopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevaccpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevacccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_drange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevacccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevvoucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevaccjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevaccjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevtaxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevtaxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevtdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevsepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevcnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);
      $prevdnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$psdate,$pdate,$company_id);

$accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_drange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);
      $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_daterange_cid($diledger['ledger_list_id'],$fdate,$tdate,$company_id);

/*if(count($prevaccrecList)>0)
      {
        $accrec= $prevaccrecList->accrec;
      }
      else
      {
        $accrec= 0;
      }

if(count($prevaccorecList)>0)
      {
        $accorec= $prevaccorecList->accrec;
      }
      else
      {
        $accorec= 0;
      }

if(count($prevaccopayList)>0)
      {
        $accopay= $prevaccopayList->accpay;
      }
      else
      {
        $accopay= 0;
      }

if(count($prevaccpayList)>0)
      {
        $accpay= $prevaccpayList->accpay;
      }
      else
      {
        $accpay= 0;
      }

if(count($prevacccntsum)>0)
      {
        $acccontsum= $prevacccntsum->depamt;
      }
      else
      {
        $acccontsum= 0;
      }

if(count($prevacccntdiff)>0)
      {
        $acccontdiff= $prevacccntdiff->debamt;
      }
      else
      {
        $acccontdiff= 0;
      }

if(count($prevvoucherdiff)>0)
      {
        $vdiff= $prevvoucherdiff->voucherpay;
      }
      else
      {
        $vdiff= 0;
      }

if(count($prevaccjournsum)>0)
      {
        $accjournalsum= $prevaccjournsum->creditamt;
      }
      else
      {
        $accjournalsum= 0;
      }

if(count($prevaccjourndiff)>0)
      {
        $accjournaldiff= $prevaccjourndiff->debitamt;
      }
      else
      {
        $accjournaldiff= 0;
      }

if(count($prevtaxledsum)>0)
      {
        $taxledgersum= $prevtaxledsum->creditamt;
      }
      else
      {
        $taxledgersum= 0;
      }

if(count($prevtaxleddiff)>0)
      {
        $taxledgerdiff= $prevtaxleddiff->debitamt;
      }
      else
      {
        $taxledgerdiff= 0;
      }

if(count($prevtdsleddiff)>0)
      {
        $tdsleddiff= $prevtdsleddiff->debitamt;
      }
      else
      {
        $tdsleddiff= 0;
      }

if(count($prevsepleddiff)>0)
      {
        $sepayleddiff= $prevsepleddiff->debitamt;
      }
      else
      {
        $sepayleddiff= 0;
      }

if(count($prevcnote)>0)
      {
        $cnotesum= $prevcnote->creditamt;
      }
      else
      {
        $cnotesum= 0;
      }

if(count($prevdnote)>0)
      {
        $dnotediff= $prevdnote->debitamt;
      }
      else
      {
        $dnotediff= 0;
      }*/

$accrec= 0;
      $accorec= 0;
      $accopay= 0;
      $accpay= 0;
      $acccontsum= 0;
      $acccontdiff= 0;
      $vdiff= 0;
      $accjournalsum= 0;
      $accjournaldiff= 0;
      $taxledgersum= 0;
      $taxledgerdiff= 0;
      $tdsleddiff= 0;
      $sepayleddiff= 0;
      $cnotesum= 0;
      $dnotediff= 0;

if(count($accrecList)>0)
      {
        $accrec+= $accrecList->accrec;
      }
      else
      {
        $accrec+= 0;
      }

if(count($accorecList)>0)
      {
        $accorec+= $accorecList->accrec;
      }
      else
      {
        $accorec+= 0;
      }

if(count($accopayList)>0)
      {
        $accopay+= $accopayList->accpay;
      }
      else
      {
        $accopay+= 0;
      }

if(count($accpayList)>0)
      {
        $accpay+= $accpayList->accpay;
      }
      else
      {
        $accpay+= 0;
      }

if(count($acccntsum)>0)
      {
        $acccontsum+= $acccntsum->depamt;
      }
      else
      {
        $acccontsum+= 0;
      }

if(count($acccntdiff)>0)
      {
        $acccontdiff+= $acccntdiff->debamt;
      }
      else
      {
        $acccontdiff+= 0;
      }

if(count($voucherdiff)>0)
      {
        $vdiff+= $voucherdiff->voucherpay;
      }
      else
      {
        $vdiff+= 0;
      }

if(count($accjournsum)>0)
      {
        $accjournalsum+= $accjournsum->creditamt;
      }
      else
      {
        $accjournalsum+= 0;
      }

if(count($accjourndiff)>0)
      {
        $accjournaldiff+= $accjourndiff->debitamt;
      }
      else
      {
        $accjournaldiff+= 0;
      }

if(count($taxledsum)>0)
      {
        $taxledgersum+= $taxledsum->creditamt;
      }
      else
      {
        $taxledgersum+= 0;
      }

if(count($taxleddiff)>0)
      {
        $taxledgerdiff+= $taxleddiff->debitamt;
      }
      else
      {
        $taxledgerdiff+= 0;
      }

if(count($tdsleddiff)>0)
      {
        $tdsleddiff+= $tdsleddiff->debitamt;
      }
      else
      {
        $tdsleddiff+= 0;
      }

if(count($sepleddiff)>0)
      {
        $sepayleddiff+= $sepleddiff->debitamt;
      }
      else
      {
        $sepayleddiff+= 0;
      }

if(count($cnote)>0)
      {
        $cnotesum+= $cnote->creditamt;
      }
      else
      {
        $cnotesum+= 0;
      }

if(count($dnote)>0)
      {
        $dnotediff+= $dnote->debitamt;
      }
      else
      {
        $dnotediff+= 0;
      }

if($diledger['crdr'] == '1')
      {
        //$ledgerAmt = ($accrec+$acccontsum+$accjournalsum+$accopay+$taxledgersum+$cnotesum) - $diledger['opening_balance'] -$accpay - $acccontdiff - $vdiff -$accjournaldiff-$accorec-$taxledgerdiff-$tdsleddiff-$sepayleddiff-$dnotediff;
        $ledgerAmt = ($accrec+$acccontsum+$accjournalsum+$accopay+$taxledgersum+$dnotediff) - $diledger['opening_balance'] -$accpay - $acccontdiff - $vdiff -$accjournaldiff-$accorec-$taxledgerdiff-$tdsleddiff-$sepayleddiff-$cnotesum;
      }
      else
      {
        //$ledgerAmt = ($diledger['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay+$taxledgersum+$cnotesum) - $accpay - $acccontdiff - $vdiff -$accjournaldiff-$accorec-$taxledgerdiff-$tdsleddiff-$sepayleddiff-$dnotediff;
        $ledgerAmt = ($diledger['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay+$taxledgersum+$dnotediff) - $accpay - $acccontdiff - $vdiff -$accjournaldiff-$accorec-$taxledgerdiff-$tdsleddiff-$sepayleddiff-$cnotesum;
      }

//echo $ledgerAmt;exit;
      
      $data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
      $data1['side'] = 'Left';
      $data1['parent_id'] = 0;
      $data1['main_title'] = '';
      $data1['sub_title'] = $diledger['ledger_list'];
      $data1['inner_title'] = '';
      $data1['amount_1'] = 0;
      $data1['amount_2'] = abs($ledgerAmt);
      $data1['amount_3'] = 0;
      $this->Accountsjob_model->create_accounts_cron_job_result($data1);
      $j++;
      $accre+=abs($ledgerAmt);
    }
  }

}

if(count($indirect_income_ledger)>0){
  $data1['accounts_cron_job_id'] = $processing_account_job_list->accounts_cron_job_id;
  $data1['side'] = 'Left';
  $data1['parent_id'] = 0;
  $data1['main_title'] = 'In Direct Income';
  $data1['sub_title'] = '';
  $data1['inner_title'] = '';
  $data1['amount_1'] = 0;
  $data1['amount_2'] = 0;
  $data1['amount_3'] = 0;
  $this->Accountsjob_model->create_accounts_cron_job_result($data1);

$j++;
  $orec=0;foreach($indirect_income_ledger as $diledger)
  {
    if($diledger['location_id'] == $company_id)
    {