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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Profitloss extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Profitloss_model'));
    $this->load->model(array('Dashboard_model'));
    $this->load->model(array('Balancesheet_model'));
    $this->load->model(array('Ledger_model'));
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Profit & Loss');
  }

/*public function index()
  {
    $data['expense_list'] = $this->Profitloss_model->get_expense_group_by_voucher_type();
    $data['income_list'] = $this->Profitloss_model->get_income_group_by_voucher_type();
    $this->load->view('profitloss/profitloss_list',$data);
  }*/

/*public function index()
  {
    $sdate = $this->Dashboard_model->get_start_date();
      $diff = date('Y') - $sdate->year;
      $opt = "";
      for($i=$diff;$i>=0;$i--)
      {
        $y = date('Y') - $i;
        if($y==date('Y'))
          $opt.="<option value=".$y." selected>".$y."</option>";
        else
          $opt.="<option value=".$y.">".$y."</option>";
      }
      $data['fyearList'] = $opt;
      $data['tyearList'] = $opt;

if($sdate->year == date('Y'))
      {
        $syearmonth = $this->Dashboard_model->get_start_year_months($sdate->month);
      }
      else
      {
        $syearmonth = $this->Dashboard_model->get_other_year_months();
      }

$option = "";
      foreach($syearmonth as $schart){
          if($schart['month'] == date('m')){
          $option.="<option value=".$schart['month']." selected>".$schart['name']."</option>";
      }else{
          $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
      }}

$data['fmonthList'] = $option;
      $data['tmonthList'] = $option;

if($_SERVER['REQUEST_METHOD'] == 'POST')
      {
        $fyear = $this->input->post('fromYear');
        $fmonth = $this->input->post('fromMonth');
        $tyear = $this->input->post('toYear');
        $tmonth = $this->input->post('toMonth');

if(strlen($fmonth)==1)
          $fmonth = '0'.$fmonth;
        if(strlen($tmonth)==1)
          $tmonth = '0'.$tmonth;

$sfyear = $fyear.'-'.$fmonth;
        $styear = $tyear.'-'.$tmonth;
        // $data['liabilities_amount'] = $this->Balancesheet_model->get_liabilities_amount_form_day_book($fyear,$fmonth,$tyear,$tmonth);
        // $data['assets_amount'] = $this->Balancesheet_model->get_assets_amount_form_day_book($fyear,$fmonth,$tyear,$tmonth);

$opt = "";
        for($i=$diff;$i>=0;$i--)
        {
          $y = date('Y') - $i;
          if($y==$fyear)
            $opt.="<option value=".$y." selected>".$y."</option>";
          else
            $opt.="<option value=".$y.">".$y."</option>";
        }
        $data['fyearList'] = $opt;

$opt = "";
        for($i=$diff;$i>=0;$i--)
        {
          $y = date('Y') - $i;
          if($y==$tyear)
            $opt.="<option value=".$y." selected>".$y."</option>";
          else
            $opt.="<option value=".$y.">".$y."</option>";
        }
        $data['tyearList'] = $opt;

if($sdate->year == $fyear)
        {
          $fsyearmonth = $this->Dashboard_model->get_start_year_change_months($sdate->month);
        }
        else if($fyear<date('Y'))
        {
          $fsyearmonth = $this->Dashboard_model->get_other_year_change_months();
        }
        else
        {
          $fsyearmonth = $this->Dashboard_model->get_other_year_months();
        }

$option = "";
        foreach($fsyearmonth as $schart){
            if($schart['month'] == $fmonth){
            $option.="<option value=".$schart['month']." selected>".$schart['name']."</option>";
        }else{
            $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
        }}

$data['fmonthList'] = $option;

if($sdate->year == $tyear)
        {
          $tsyearmonth = $this->Dashboard_model->get_start_year_change_months($sdate->month);
        }
        else if($tyear<date('Y'))
        {
          $tsyearmonth = $this->Dashboard_model->get_other_year_change_months();
        }
        else
        {
          $tsyearmonth = $this->Dashboard_model->get_other_year_months();
        }

$option = "";
        foreach($tsyearmonth as $schart){
            if($schart['month'] == $tmonth){
            $option.="<option value=".$schart['month']." selected>".$schart['name']."</option>";
        }else{
            $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
        }}

$data['tmonthList'] = $option;
        //print_r($data);exit;
      }
      else
      {
        $fyear = date('Y');
        $fmonth = date('m');
        $tyear = date('Y');
        $tmonth = date('m');

if(strlen($fmonth)==1)
          $fmonth = '0'.$fmonth;
        if(strlen($tmonth)==1)
          $tmonth = '0'.$tmonth;

$data['expense_list'] = $this->Profitloss_model->get_expense_group_by_voucher_type($sfyear,$styear);
        $data['income_list'] = $this->Profitloss_model->get_income_group_by_voucher_type($sfyear,$styear);
      }
      $fmonthName = date('M', mktime(0, 0, 0, $fmonth, 10));
      $tmonthName = date('M', mktime(0, 0, 0, $tmonth, 10));
      $data['fmy'] = $fmonthName.' '.$fyear;
      $data['tmy'] = $tmonthName.' '.$tyear;

$data['fyear'] = $fyear;
      $data['fmonth'] = $fmonth;
      $data['tyear'] = $tyear;
      $data['tmonth'] = $tmonth;

$this->load->view('profitloss/profitloss_list',$data);
  }*/

$data['fmonthList'] = $option;
      $data['tmonthList'] = $option;

if(strlen($fmonth)==1)
          $fmonth = '0'.$fmonth;
        if(strlen($tmonth)==1)
          $tmonth = '0'.$tmonth;

//$data['expense_list'] = $this->Profitloss_model->get_expense_group_by_voucher_type($sfyear,$styear);
        //$data['income_list'] = $this->Profitloss_model->get_income_group_by_voucher_type($sfyear,$styear);

$data['opening_stock'] = $this->Profitloss_model->get_opening_stock_by_custom_date($sfyear);

$data['purchase_amt'] = $this->Profitloss_model->get_purchase_amount_by_custom_date($sfyear,$styear);
        $data['direct_expense'] = $this->Profitloss_model->get_direct_expense_by_custom_date($sfyear,$styear);
        $data['in_direct_expense'] = $this->Profitloss_model->get_in_direct_expense_by_custom_date($sfyear,$styear);
        $data['sales_amt'] = $this->Profitloss_model->get_sales_amount_by_custom_date($sfyear,$styear);
        $data['direct_invoice'] = $this->Profitloss_model->get_direct_invoice_amount_by_custom_date($sfyear,$styear);
        $data['other_receipt'] = $this->Profitloss_model->get_other_receipt_by_custom_date($sfyear,$styear);

$data['closing_stock'] = $this->Profitloss_model->get_closing_stock_by_custom_date($styear);

$data['fmonthList'] = $option;

if(strlen($fmonth)==1)
          $fmonth = '0'.$fmonth;
        if(strlen($tmonth)==1)
          $tmonth = '0'.$tmonth;

$sfyear = $fyear.'-'.$fmonth;
        $styear = $tyear.'-'.$tmonth;

$data['opening_stock'] = $this->Profitloss_model->get_opening_stock_by_custom_date($sfyear);

$data['closing_stock'] = $this->Profitloss_model->get_closing_stock_by_custom_date($styear);
        //print_r($data);exit;
      }
      $fmonthName = date('M', mktime(0, 0, 0, $fmonth, 10));
      $tmonthName = date('M', mktime(0, 0, 0, $tmonth, 10));
      $data['fmy'] = $fmonthName.' '.$fyear;
      $data['tmy'] = $tmonthName.' '.$tyear;

$data['fyear'] = $fyear;
      $data['fmonth'] = $fmonth;
      $data['tyear'] = $tyear;
      $data['tmonth'] = $tmonth;

$this->load->view('profitloss/profitloss_list',$data);
  }*/

public function index()
  {
      if($_SERVER['REQUEST_METHOD'] == 'POST')
      {
        $data['ostock'] = $this->input->post('ostock');
        $data['cstock'] = $this->input->post('cstock');
        if($this->input->post('searchChange')=='curdate')
        {
          $curdate = date('Y-m-d');
          $data['dtrange'] = '';
          $data['drnge'] = '';
          $data['purchasesearch'] = 'curdate';
          $data['curdate'] = $curdate;
          $data['fdate'] = '';
          $data['tdate'] = '';
        }
        elseif($this->input->post('searchChange')=='date')
        {
          if($this->input->post('dtrange')!='')
          {
            $odt = explode('/', $this->input->post('dtrange'));
            $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
          }
          else
          {
            $curdate = date('Y-m-d');
          }
          $data['dtrange'] = $this->input->post('dtrange');
          $data['drnge'] = '';
          $data['purchasesearch'] = 'date';
          $data['curdate'] = $curdate;
          $data['fdate'] = '';
          $data['tdate'] = '';
        }
        else
        {
          $dtrange = $this->input->post('dtrangepicker');
          $dr = explode(' - ', $dtrange);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
          $tdate = $td[2].'-'.$td[0].'-'.$td[1];
          $data['dtrange'] = '';
          $data['drnge'] = $dtrange;
          $data['purchasesearch'] = 'daterange';
          $data['curdate'] = '';
          $data['fdate'] = $fdate;
          $data['tdate'] = $tdate;
        }

$company_id = $this->input->post('company_id');
        $data['company_id'] = $company_id;

if($company_id!='')
        {
          $cid = 'AND location_id='.$company_id;
          $decid = 'AND l.location_id='.$company_id;
          $purid = 'AND po.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."'";
        }
        else
        {
          $cid = '';
          $decid = '';
          $purid = '';
          $slocid = '';
          $data['compDet'] = '';
          $compqry = "";
          $dcompqry = "";
        }

if($this->input->post('searchChange')!='daterange')
        {          
          /*$data['opening_stock'] = $this->Profitloss_model->get_opening_stock_by_singledate($curdate);
          $data['purchase_amt'] = $this->Profitloss_model->get_purchase_amount_by_singledate($curdate);
          $data['direct_expense'] = $this->Profitloss_model->get_direct_expense_by_singledate($curdate);
          $data['in_direct_expense'] = $this->Profitloss_model->get_in_direct_expense_by_singledate($curdate);
          $data['sales_amt'] = $this->Profitloss_model->get_sales_amount_by_singledate($curdate);
          $data['direct_invoice'] = $this->Profitloss_model->get_direct_invoice_amount_by_singledate($curdate);
          $data['other_receipt'] = $this->Profitloss_model->get_other_receipt_by_singledate($curdate);
          $data['closing_stock'] = $this->Profitloss_model->get_closing_stock_by_singledate($curdate);*/

//$data['opening_stock'] = $this->db->query("SELECT sum(opening_stock) as opening_stock FROM `stock_ledger` WHERE stock_ledger_date='$curdate' $cid")->row();
          $data['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='$curdate' AND p.status!=5 $purid")->row();

//$data['direct_expense_group'] = $this->db->query("SELECT lg.ledger_group_id,lg.ledger_group,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='$curdate' $decid AND l.status=0 AND lt.ledger_type_id=1 GROUP BY lg.ledger_group_id")->result_array();

//$data['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='$curdate' $decid AND l.status=0 AND lt.ledger_type_id=1 GROUP BY l.ledger_sub_group_id")->result_array();

//$data['in_direct_expense_group'] = $this->db->query("SELECT lg.ledger_group_id,lg.ledger_group,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='$curdate' $decid AND l.status=0 AND lt.ledger_type_id!=1 GROUP BY lg.ledger_group_id")->result_array();

//$data['in_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='$curdate' $decid AND l.status=0 AND lt.ledger_type_id!=1 GROUP BY l.ledger_sub_group_id")->result_array();

//$data['in_direct_expense'] = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.total_amount) as amt FROM ((SELECT e.expense_date,e.invoice_no,e.taxable_value,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 WHERE e.vendor_id = v.vendor_id AND e.ledger_group_id = lg.ledger_group_id AND e.expense_date='$curdate' AND e.status!=2 $slocid) UNION (SELECT l.ledger_date,l.ledger_no as invoice_no,l.amount as taxable_value,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 WHERE l.ledger_sub_group_id = lsg.ledger_sub_group_id AND lsg.ledger_group_id = lg.ledger_group_id AND l.ledger_date='$curdate' $decid)) led GROUP BY led.ledger_group_id ")->result_array();

$data['in_direct_expense'] = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.tamt) as amt FROM ((SELECT e.expense_date,e.invoice_no,sum(e.taxable_value) as tamt,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='$curdate' 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,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='$curdate' $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,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='$curdate' $slocid GROUP BY lg.ledger_group_id)) led GROUP BY led.ledger_group_id ")->result_array();

//$data['sales_amt'] = $this->db->query("SELECT sum(grand_total) as amt FROM `order` WHERE order_date='$curdate' $cid")->row();

$data['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='$curdate' $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='$curdate' $dcompqry)) a")->row();

$data['direct_invoice'] = $this->db->query("SELECT sum(grand_total) as amt FROM `invoice` WHERE invoice_date='$curdate' AND customer_id!=0 $cid")->row();
          //$data['other_receipt'] = $this->db->query("SELECT ar.particulars,sum(ar.amount) as amt FROM `account_receipt` ar, ledger_list l WHERE l.ledger_list_id = ar.ledger_list_id AND ar.account_receipt_date='$curdate' AND ar.expense_type='others' $decid GROUP BY ar.particulars")->result_array();
          //$data['closing_stock'] = $this->db->query("SELECT sum(closing_stock) as closing_stock FROM `stock_ledger` WHERE stock_ledger_date='$curdate' $cid")->row();

//$data['direct_expense_list'] = $this->db->query("SELECT s.ledger_group_id,s.ledger_group, sum(s.amt) as amount FROM ((SELECT lg.ledger_group_id, lg.ledger_group,sum(e.taxable_value) as 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 = 0 AND lt.expense_type = 'Direct' AND e.expense_date='$curdate' $slocid GROUP BY lg.ledger_group_id)UNION(SELECT lg.ledger_group_id, lg.ledger_group,sum(e.net_salary) as 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 = 0 AND lt.expense_type = 'Direct' AND e.staff_expense_date='$curdate' $slocid GROUP BY lg.ledger_group_id)) s GROUP BY s.ledger_group_id ")->result_array();

$data['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='$curdate' $decid AND l.status=0 AND lt.expense_type = 'Direct' GROUP BY l.ledger_sub_group_id")->result_array();

}
        else
        {
          /*$data['opening_stock'] = $this->Balancesheet_model->get_opening_stock_by_singledate($fdate);
          $data['purchase_amt'] = $this->Balancesheet_model->get_purchase_amount_by_daterange($fdate,$tdate);
          $data['direct_expense'] = $this->Balancesheet_model->get_direct_expense_by_daterange($fdate,$tdate);
          $data['in_direct_expense'] = $this->Balancesheet_model->get_in_direct_expense_by_daterange($fdate,$tdate);
          $data['sales_amt'] = $this->Balancesheet_model->get_sales_amount_by_daterange($fdate,$tdate);
          $data['direct_invoice'] = $this->Balancesheet_model->get_direct_invoice_amount_by_daterange($fdate,$tdate);
          $data['other_receipt'] = $this->Balancesheet_model->get_other_receipt_by_daterange($fdate,$tdate);
          $data['closing_stock'] = $this->Balancesheet_model->get_closing_stock_by_singledate($fdate);*/

//$data['opening_stock'] = $this->db->query("SELECT sum(opening_stock) as opening_stock FROM `stock_ledger` WHERE stock_ledger_date='$fdate' $cid")->row();
          $data['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();

//$data['direct_expense_group'] = $this->db->query("SELECT lg.ledger_group_id,lg.ledger_group,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.ledger_type_id=1 GROUP BY lg.ledger_group_id")->result_array();

//$data['in_direct_expense_group'] = $this->db->query("SELECT lg.ledger_group_id,lg.ledger_group,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.ledger_type_id!=1 GROUP BY lg.ledger_group_id")->result_array();

//$data['in_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 = 'In Direct' GROUP BY l.ledger_sub_group_id")->result_array();

$data['in_direct_expense'] = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.tamt) as amt FROM ((SELECT e.expense_date,e.invoice_no,sum(e.taxable_value) as tamt,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,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,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();

//$data['sales_amt'] = $this->db->query("SELECT sum(grand_total) as amt FROM `order` WHERE order_date>='$fdate' AND order_date<='$tdate' $cid")->row();

$data['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();

$data['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();
          //$data['other_receipt'] = $this->db->query("SELECT ar.particulars,sum(ar.amount) as amt FROM `account_receipt` ar, ledger_list l WHERE l.ledger_list_id = ar.ledger_list_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.expense_type='others' $decid GROUP BY ar.particulars")->result_array();
          //$data['closing_stock'] = $this->db->query("SELECT sum(closing_stock) as closing_stock FROM `stock_ledger` WHERE stock_ledger_date='$tdate' $cid")->row();

$data['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();

$data['direct_expense_list'] = $this->db->query("SELECT s.ledger_group_id,s.ledger_group, sum(s.amt) as amount FROM ((SELECT lg.ledger_group_id, lg.ledger_group,sum(e.taxable_value) as 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 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();
        }
      }
      else
      {
        $curdate = date('Y-m-d');
        $data['dtrange'] = '';
        $data['drnge'] = '';
        $data['company_id'] = '';
        $data['purchasesearch'] = 'curdate';
        $data['compDet'] = '';
        $data['curdate'] = $curdate;
        $data['fdate'] = '';
        $data['tdate'] = '';
        $data['ostock'] = 0;
        $data['cstock'] = 0;

/*$data['opening_stock'] = $this->Profitloss_model->get_opening_stock_by_custom_date($sfyear);
        $data['purchase_amt'] = $this->Profitloss_model->get_purchase_amount_by_custom_date($sfyear,$styear);
        $data['direct_expense'] = $this->Profitloss_model->get_direct_expense_by_custom_date($sfyear,$styear);
        $data['in_direct_expense'] = $this->Profitloss_model->get_in_direct_expense_by_custom_date($sfyear,$styear);
        $data['sales_amt'] = $this->Profitloss_model->get_sales_amount_by_custom_date($sfyear,$styear);
        $data['direct_invoice'] = $this->Profitloss_model->get_direct_invoice_amount_by_custom_date($sfyear,$styear);
        $data['other_receipt'] = $this->Profitloss_model->get_other_receipt_by_custom_date($sfyear,$styear);
        $data['closing_stock'] = $this->Profitloss_model->get_closing_stock_by_custom_date($styear);*/

//$data['opening_stock'] = $this->Profitloss_model->get_opening_stock_by_singledate($curdate);

$data['purchase_amt'] = $this->Profitloss_model->get_purchase_amount_by_singledate($curdate);
        //$data['direct_expense_group'] = $this->Profitloss_model->get_direct_expense_group_by_singledate($curdate);
        $data['direct_expense_group'] = $this->Profitloss_model->get_direct_expense_voucher_group();
        //$data['direct_expense'] = $this->Profitloss_model->get_direct_expense_by_singledate($curdate);
        //$data['in_direct_expense_group'] = $this->Profitloss_model->get_in_direct_expense_group_by_singledate($curdate);
        $data['in_direct_expense'] = $this->Profitloss_model->get_in_direct_expense_by_singledate($curdate);
        $data['sales_amt'] = $this->Profitloss_model->get_sales_amount_by_singledate($curdate);
        $data['direct_invoice'] = $this->Profitloss_model->get_direct_invoice_amount_by_singledate($curdate);
        //$data['other_receipt'] = $this->Profitloss_model->get_other_receipt_by_singledate($curdate);

$data['direct_expense'] = $this->Profitloss_model->get_direct_expense_by_singledate($curdate);
        $data['direct_expense_list'] = $this->Profitloss_model->get_expense_staff_expense_by_singledate($curdate);

//$data['closing_stock'] = $this->Profitloss_model->get_closing_stock_by_singledate($curdate);
        //print_r($data);exit;
      }

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

$data['direct_income_ledger'] = $this->Profitloss_model->get_direct_income_ledger_list();
      $data['indirect_income_ledger'] = $this->Profitloss_model->get_indirect_income_ledger_list();

$data['location_list'] = $this->Ledger_model->get_location_list();
      $this->load->view('profitloss/profitloss_list',$data);
  }

public function profitloss_export($cid = null,$psearch=null,$dtrange=null,$drnge=null,$ostock,$cstock)
  {
      
        $ostock = $ostock;
        $cstock = $cstock;
        if($psearch=='curdate')
        {
          $curdate = date('Y-m-d');
          $fdate = '';
          $tdate = '';
        }
        elseif($psearch=='date')
        {
          if($dtrange!='-')
          {
            $odt = explode('/', str_replace('_', '/', $dtrange));
            $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
          }
          else
          {
            $curdate = date('Y-m-d');
          }
          $curdate = $curdate;
          $fdate = '';
          $tdate = '';
        }
        else
        {
          //$dtrange = $drnge;
          $dtrange = str_replace('_', '/', str_replace('-', ' - ', $drnge));
          $dr = explode(' - ', $dtrange);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
          $tdate = $td[2].'-'.$td[0].'-'.$td[1];
          $curdate = '';
          $fdate = $fdate;
          $tdate = $tdate;
        }

$company_id = $cid;

if($company_id!='-')
        {
          $cid = 'AND location_id='.$company_id;
          $decid = 'AND l.location_id='.$company_id;
          $purid = 'AND po.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."'";
        }
        else
        {
          $cid = '';
          $decid = '';
          $purid = '';
          $data['compDet'] = '';
          $compqry = "";
          $dcompqry = "";
        }

if($psearch!='daterange')
        {
          $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='$curdate' AND p.status!=5 $purid")->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='$curdate' $decid AND l.status=0 AND lt.expense_type = 'Direct' GROUP BY l.ledger_sub_group_id")->result_array();

$in_direct_expense = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.tamt) as amt FROM ((SELECT e.expense_date,e.invoice_no,sum(e.taxable_value) as tamt,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='$curdate' 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,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='$curdate' $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,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='$curdate' $slocid GROUP BY lg.ledger_group_id)) led GROUP BY led.ledger_group_id")->result_array();

//$sales_amt = $this->db->query("SELECT sum(grand_total) as amt FROM `order` WHERE order_date='$curdate' $cid")->row();

$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='$curdate' $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='$curdate' $dcompqry)) a")->row();

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

$direct_expense_list = $this->db->query("SELECT s.ledger_group_id,s.ledger_group, sum(s.amt) as amount FROM ((SELECT lg.ledger_group_id, lg.ledger_group,sum(e.taxable_value) as 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='$curdate' $slocid GROUP BY lg.ledger_group_id)UNION(SELECT lg.ledger_group_id, lg.ledger_group,sum(e.net_salary) as 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='$curdate' $slocid GROUP BY lg.ledger_group_id)) s GROUP BY s.ledger_group_id")->result_array();

}
        else
        {
          $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();

$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();

$in_direct_expense = $this->db->query("SELECT led.ledger_group,led.ledger_group_id,sum(led.tamt) as amt FROM ((SELECT e.expense_date,e.invoice_no,sum(e.taxable_value) as tamt,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,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,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(grand_total) as amt FROM `order` WHERE order_date>='$fdate' AND order_date<='$tdate' $cid")->row();

$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_list = $this->db->query("SELECT s.ledger_group_id,s.ledger_group, sum(s.amt) as amount FROM ((SELECT lg.ledger_group_id, lg.ledger_group,sum(e.taxable_value) as 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 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();

$location_list = $this->Ledger_model->get_location_list();

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
        'font' => array(
            'bold' => true,
            'color' => array('rgb' => '000000')
        )/*,
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )*/
    );

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Expense');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Amount');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('B2', 'To Opening Stock');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', $ostock);
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('B3', 'To Purchase');
    $objPHPExcel->getActiveSheet()->getStyle('B3')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F3', $purchase_amt->amt-$purchase_amt->ocharge);
    $objPHPExcel->getActiveSheet()->getStyle('F3')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('B4', 'Direct Expense');
    $objPHPExcel->getActiveSheet()->getStyle('B4')->applyFromArray($styleArray);

$gvar = 'C';$svar = 'E';$j=5;$de=1; $etot=0; foreach($direct_expense_group as $degroup){
      $s=$j;
      $objPHPExcel->getActiveSheet()->setCellValue($gvar.$s, $degroup['ledger_group']);
      $objPHPExcel->getActiveSheet()->getStyle($gvar.$s)->applyFromArray($styleArray);
      if($company_id=='-')
      {
        $direct_expense_ledger = $this->Profitloss_model->get_direct_expense_ledger_by_group_id($degroup['ledger_group_id']);
      }
      else
      {
        $direct_expense_ledger = $this->Profitloss_model->get_direct_expense_ledger_by_group_comp_id($degroup['ledger_group_id'],$company_id);
      }

$svar++;
      $detot=0;foreach($direct_expense_ledger as $del){
        if($company_id=='-')
        {
          if($fdate=='')
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_date($del['ledger_list_id'],$curdate);
          }
          else
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_daterange($del['ledger_list_id'],$fdate,$tdate);
          }
        }
        else
        {
          if($fdate=='')
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_cid_date($del['ledger_list_id'],$company_id,$curdate);
          }
          else
          {
            $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+=$deltot;

$j++;
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, 'To '.$del['ledger_list']);
        $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $deltot);
        $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);

}

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

$j++;
            $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, 'To '.$llist['ledger_sub_group']);
            $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);
            $objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $llist['amt']);
            $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);
            $deamt+=$llist['amt'];
          }
        }

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

$j++;
            $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, 'To '.$llist['ledger_group']);
            $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);
            $objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $llist['amount']);
            $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);
            $dseamt+=$llist['amount'];
          }
        }

$objPHPExcel->getActiveSheet()->setCellValue($svar.$s, ($deamt+$detot+$dseamt));
      $objPHPExcel->getActiveSheet()->getStyle($svar.$s)->applyFromArray($styleArray);
    $j++;$svar = 'E';$de++;$etot+=($deamt+$detot+$dseamt);}

$diamt = 0;foreach($direct_income_ledger as $diledger)
    {
      if($company_id == '-')
      {
        if($fdate=='')
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
        }
        else
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);  
        }
      }
      else
      {
        if($fdate=='')
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
        }
        else
        {
          $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($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;
      else
        $ledgerAmt = ($diledger['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay+$taxledgersum+$cnotesum) - $accpay - $acccontdiff - $vdiff -$accjournaldiff-$accorec-$taxledgerdiff-$tdsleddiff-$sepayleddiff-$dnotediff;

$diamt+=$ledgerAmt;
    }

$gp = ($sales_amt->txamt+$sales_amt->pc+$sales_amt->oc+$cstock+$diamt)-($purchase_amt->amt-$purchase_amt->ocharge+$etot+$ostock);
    if($gp>=0){
      $gpamt = $gp;
      $glamt = 0;
    }
    else
    {
      $glamt = abs($gp);
      $gpamt = 0;
    }

if($gp>=0){
      $lgp = $gp;
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$j, 'To gross Profit c/d');
      $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $gp);
      $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);
    $j++;}
    else
    {
      $lgp=0;
    }

$objPHPExcel->getActiveSheet()->setCellValue('B'.$j, 'Sub Total');
    $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, ($purchase_amt->amt-$purchase_amt->ocharge+$etot+$lgp+$ostock));
    $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);
    $j++;

if($glamt>0){
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$j, 'To gross loss b/d');
      $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $glamt);
      $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);
    $j++;}

$gvar = 'C';$svar = 'E';$ide=1; $ietot=0;foreach($in_direct_expense_group as $idegroup){
      $s=$j;
      $objPHPExcel->getActiveSheet()->setCellValue($gvar.$s, $idegroup['ledger_group']);
      $objPHPExcel->getActiveSheet()->getStyle($gvar.$s)->applyFromArray($styleArray);

if($company_id=='-')
      {
        $indirect_expense_ledger = $this->Profitloss_model->get_indirect_expense_ledger_by_group_id($idegroup['ledger_group_id']);
      }
      else
      {
        $indirect_expense_ledger = $this->Profitloss_model->get_indirect_expense_ledger_by_group_comp_id($idegroup['ledger_group_id'],$company_id);
      }
      $svar++;
      $idetot=0;foreach($indirect_expense_ledger as $idel)
      {
        if($company_id=='-')
        {
          if($fdate=='')
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_date($idel['ledger_list_id'],$curdate);
          }
          else
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_daterange($idel['ledger_list_id'],$fdate,$tdate);
          }
        }
        else
        {
          if($fdate=='')
          {
            $ledgdet = $this->Profitloss_model->get_de_ledger_details_view_by_lid_cid_date($idel['ledger_list_id'],$company_id,$curdate);
          }
          else
          {
            $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'];
          }
          else
          {
            $ideltot-=$dldet['amount'];
          }
        }
        $idetot+=$ideltot;
        $j++;
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, 'To '.$idel['ledger_list']);
        $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $ideltot);
        $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);
      }

$ideamt = 0;foreach($in_direct_expense as $llist){
          if($llist['ledger_group_id'] == $idegroup['ledger_group_id']){
            $j++;
            $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, 'To '.$llist['ledger_group']);
            $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);
            $objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $llist['amt']);
            $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);
            $ideamt+=$llist['amt'];
          }
        }
      $objPHPExcel->getActiveSheet()->setCellValue($svar.$s, ($ideamt+$idetot));
      $objPHPExcel->getActiveSheet()->getStyle($svar.$s)->applyFromArray($styleArray);
      $j++;$svar = 'E';$ide++;$ietot+=($ideamt+$idetot);
    }

$pprof = $glamt+$ietot;

$objPHPExcel->getActiveSheet()->setCellValue('B'.$j, 'Net Total');
    $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $pprof);
    $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);

$expline = $j;

$objPHPExcel->getActiveSheet()->setCellValue('H1', 'Income');
    $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('K1', 'Amount');
    $objPHPExcel->getActiveSheet()->getStyle('K1')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('I2', 'By Sales');
    $objPHPExcel->getActiveSheet()->getStyle('I2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('K2', ($sales_amt->txamt+$sales_amt->pc+$sales_amt->oc));
    $objPHPExcel->getActiveSheet()->getStyle('K2')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('I3', 'By Closing Stock');
    $objPHPExcel->getActiveSheet()->getStyle('I3')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('K3', $cstock);
    $objPHPExcel->getActiveSheet()->getStyle('K3')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('I4', 'Direct Income');
    $objPHPExcel->getActiveSheet()->getStyle('I4')->applyFromArray($styleArray);

$gvar = 'J';$svar = 'J';$j=5;foreach($direct_income_ledger as $diledger)
    {
      if($company_id == '-')
      {
        if($fdate=='')
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_date($diledger['ledger_list_id'],$curdate);
        }
        else
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_daterange($diledger['ledger_list_id'],$fdate,$tdate);  
        }
      }
      else
      {
        if($fdate=='')
        {
          $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $taxledsum = $this->Balancesheet_model->get_tax_ledger_from_credit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $taxleddiff = $this->Balancesheet_model->get_tax_ledger_from_debit_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $tdsleddiff = $this->Profitloss_model->get_tds_ledger_from_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $sepleddiff = $this->Profitloss_model->get_payable_ledger_from_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $cnote = $this->Balancesheet_model->get_credit_note_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
          $dnote = $this->Balancesheet_model->get_debit_note_by_ledger_list_id_date_cid($diledger['ledger_list_id'],$curdate,$company_id);
        }
        else
        {
          $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);  
        }
      }