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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Incomeexpense extends CI_Controller {
 public function __construct()
 {
 parent::__construct();
 $this->load->model(array('Incomeexpense_model'));
 $this->load->model(array('Dashboard_model'));
 $this->load->model(array('Ledger_model'));
 $this->load->model(array('Accountjournal_model'));
 $this->load->model(array('Balancesheet_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', 'Income & Expense');
 }

/*public function index()
  {
      if($_SERVER['REQUEST_METHOD'] == 'POST')
      {
        if($this->input->post('searchChange')=='curdate')
      {
        $curdate = date('Y-m-d');
        $data['dtrange'] = '';
        $data['drnge'] = '';
        $data['purchasesearch'] = 'curdate';
      }
      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';
      }
      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';
      }

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

if($company_id!='')
        $cid = 'AND ll.location_id='.$company_id;
      else
        $cid = '';

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $arissu = '';
          $apissu = '';
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $arissu = 'AND ar.created_by='.$_SESSION['user_id'];
            $apissu = 'AND ap.created_by='.$_SESSION['user_id'];
          }
          else
          {
            $arissu = '';
            $apissu = '';
          }
        }
      }
      else
      {
        $compId = 'AND ll.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $arissu = 'AND ar.created_by='.$_SESSION['user_id'];
          $apissu = 'AND ap.created_by='.$_SESSION['user_id'];
        }
        else
        {
          $arissu = '';
          $apissu = '';
        }
      }

if($this->input->post('searchChange')!='daterange')
        {
          $data['income_amount'] = $this->db->query("SELECT ar.*,sum(ar.amount) as tamt FROM `account_receipt` ar, ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date='$curdate' $cid $compId $arissu AND ar.expense_type='sales receipt'")->result_array();
          $data['expense_amount'] = $this->db->query("SELECT ap.*,sum(ap.amount) as tamt FROM `account_payment` ap, ledger_list ll WHERE ap.ledger_list_id = ll.ledger_list_id AND ap.account_payment_date='$curdate' $cid $compId $apissu AND ap.expense_type='others' GROUP BY particulars")->result_array();

}
 else
 {
 $data['income_amount'] = $this->db->query("SELECT ar.*,sum(ar.amount) as tamt FROM `account_receipt` ar, ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' $cid $compId $arissu AND ar.expense_type='sales receipt'")->result_array();
 $data['expense_amount'] = $this->db->query("SELECT ap.*,sum(ap.amount) as tamt FROM `account_payment` ap, ledger_list ll WHERE ap.ledger_list_id = ll.ledger_list_id AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' $cid $compId $apissu AND ap.expense_type='others' GROUP BY particulars")->result_array();
 }
 }
 else
 {
 $curdate = date('Y-m-d');
 $data['dtrange'] = '';
 $data['drnge'] = '';
 $data['purchasesearch'] = 'curdate';
 $data['company_id'] = '';
 if($_SESSION['company_id']==0)
 {
 if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
 {
 $data['income_amount'] = $this->Incomeexpense_model->get_income_from_account_receipt_by_singledate($curdate);
 $data['expense_amount'] = $this->Incomeexpense_model->get_expense_from_account_payment_by_singledate($curdate);
 }
 else
 {
 $data['income_amount'] = $this->Incomeexpense_model->get_user_income_from_account_receipt_by_singledate($curdate,$_SESSION['user_id']);
 $data['expense_amount'] = $this->Incomeexpense_model->get_user_expense_from_account_payment_by_singledate($curdate,$_SESSION['user_id']);
 }
 }
 else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
 { 
 $data['income_amount'] = $this->Incomeexpense_model->get_user_income_from_account_receipt_by_singledate($curdate,$_SESSION['user_id']);
 $data['expense_amount'] = $this->Incomeexpense_model->get_user_expense_from_account_payment_by_singledate($curdate,$_SESSION['user_id']);
 }
 else
 {
 $data['income_amount'] = $this->Incomeexpense_model->get_super_user_income_from_account_receipt_by_singledate($curdate,$_SESSION['company_id']);
 $data['expense_amount'] = $this->Incomeexpense_model->get_super_user_expense_from_account_payment_by_singledate($curdate,$_SESSION['company_id']);
 }

}

if($_SESSION['company_id']==0)
        $data['location_list'] = $this->Accountjournal_model->get_location_list();
      else
        $data['location_list'] = $this->Accountjournal_model->get_location_by_comp_id($_SESSION['company_id']);
      $this->load->view('incomeexpense/incomeexpense_list',$data);
  }

public function getYearMonth()
  {
    $year = $_POST['year'];

$sdate = $this->Dashboard_model->get_start_date();

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

$monthList = $syearmonth;
 $option ="<option value=''>Select Month</option>";
 foreach($monthList as $schart)
 {
 $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
 }
 echo $option;
 }

public function printincomeexpense()
  {
    $fyear = $this->input->post('fyear');
    $fmonth = $this->input->post('fmonth');
    $tyear = $this->input->post('tyear');
    $tmonth = $this->input->post('tmonth');
    $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;
    $sfyear = $fyear.'-'.$fmonth;
    $styear = $tyear.'-'.$tmonth;
    $data['income_amount'] = $this->Incomeexpense_model->get_income_from_account_receipt($sfyear,$styear);
    $data['expense_amount'] = $this->Incomeexpense_model->get_expense_from_account_payment($sfyear,$styear);
    $this->load->view('incomeexpense/print_incomeexpense',$data);
  }*/

public function index()
  {
      if($_SERVER['REQUEST_METHOD'] == 'POST')
      {
        if($this->input->post('searchChange')=='curdate')
        {
          $today = date('Y-m-d');
          $data['dtrange'] = '';
          $data['drnge'] = '';
          $data['purchasesearch'] = 'curdate';
        }
        elseif($this->input->post('searchChange')=='date')
        {
          if($this->input->post('dtrange')!='')
          {
            $odt = explode('/', $this->input->post('dtrange'));
            $today = $odt[2].'-'.$odt[0].'-'.$odt[1];
          }
          else
          {
            $today = date('Y-m-d');
          }
          $data['dtrange'] = $this->input->post('dtrange');
          $data['drnge'] = '';
          $data['purchasesearch'] = 'date';
        }
        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';
        }

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

if($this->input->post('searchChange')!='daterange')
 {
 if($company_id!='')
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($accorecList)>0)
              {
                $accorec = $accorecList->accrec;
              }
              else
              {
                $accorec = 0;
              }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($accpayList)>0)
              {
                $accpay = $accpayList->accpay;
              }
              else
              {
                $accpay = 0;
              }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($accopayList)>0)
              {
                $accopay = $accopayList->accpay;
              }
              else
              {
                $accopay = 0;
              }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($acccntsum)>0)
              {
                $acccontsum = $acccntsum->depamt;
              }
              else
              {
                $acccontsum = 0;
              }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($acccntdiff)>0)
              {
                $acccontdiff = $acccntdiff->debamt;
              }
              else
              {
                $acccontdiff = 0;
              }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($voucherdiff)>0)
              {
                $vdiff = $voucherdiff->voucherpay;
              }
              else
              {
                $vdiff = 0;
              }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($accjournsum)>0)
              {
                $accjournalsum = $accjournsum->creditamt;
              }
              else
              {
                $accjournalsum = 0;
              }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
              if(count($accjourndiff)>0)
              {
                $accjournaldiff = $accjourndiff->debitamt;
              }
              else
              {
                $accjournaldiff = 0;
              }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 //$data['today_cash_list'] = $lopt;
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 else
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($accorecList)>0)
              {
                $accorec = $accorecList->accrec;
              }
              else
              {
                $accorec = 0;
              }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($accpayList)>0)
              {
                $accpay = $accpayList->accpay;
              }
              else
              {
                $accpay = 0;
              }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($accopayList)>0)
              {
                $accopay = $accopayList->accpay;
              }
              else
              {
                $accopay = 0;
              }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($acccntsum)>0)
              {
                $acccontsum = $acccntsum->depamt;
              }
              else
              {
                $acccontsum = 0;
              }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($acccntdiff)>0)
              {
                $acccontdiff = $acccntdiff->debamt;
              }
              else
              {
                $acccontdiff = 0;
              }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($voucherdiff)>0)
              {
                $vdiff = $voucherdiff->voucherpay;
              }
              else
              {
                $vdiff = 0;
              }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($accjournsum)>0)
              {
                $accjournalsum = $accjournsum->creditamt;
              }
              else
              {
                $accjournalsum = 0;
              }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
              if(count($accjourndiff)>0)
              {
                $accjournaldiff = $accjourndiff->debitamt;
              }
              else
              {
                $accjournaldiff = 0;
              }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 //$data['today_cash_list'] = $lopt;
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 }
 else
 {
 if($company_id!='')
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($accorecList)>0)
              {
                $accorec = $accorecList->accrec;
              }
              else
              {
                $accorec = 0;
              }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($accpayList)>0)
              {
                $accpay = $accpayList->accpay;
              }
              else
              {
                $accpay = 0;
              }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($accopayList)>0)
              {
                $accopay = $accopayList->accpay;
              }
              else
              {
                $accopay = 0;
              }

$acccntsum = $this->Balancesheet_model->get_acc_contra_amt_by_from_credit_ledger_list_id_drange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($acccntsum)>0)
              {
                $acccontsum = $acccntsum->depamt;
              }
              else
              {
                $acccontsum = 0;
              }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($acccntdiff)>0)
              {
                $acccontdiff = $acccntdiff->debamt;
              }
              else
              {
                $acccontdiff = 0;
              }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($voucherdiff)>0)
              {
                $vdiff = $voucherdiff->voucherpay;
              }
              else
              {
                $vdiff = 0;
              }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($accjournsum)>0)
              {
                $accjournalsum = $accjournsum->creditamt;
              }
              else
              {
                $accjournalsum = 0;
              }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
              if(count($accjourndiff)>0)
              {
                $accjournaldiff = $accjourndiff->debitamt;
              }
              else
              {
                $accjournaldiff = 0;
              }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 //$data['today_cash_list'] = $lopt;
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 else
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($accorecList)>0)
              {
                $accorec = $accorecList->accrec;
              }
              else
              {
                $accorec = 0;
              }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($accpayList)>0)
              {
                $accpay = $accpayList->accpay;
              }
              else
              {
                $accpay = 0;
              }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($accopayList)>0)
              {
                $accopay = $accopayList->accpay;
              }
              else
              {
                $accopay = 0;
              }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($acccntsum)>0)
              {
                $acccontsum = $acccntsum->depamt;
              }
              else
              {
                $acccontsum = 0;
              }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($acccntdiff)>0)
              {
                $acccontdiff = $acccntdiff->debamt;
              }
              else
              {
                $acccontdiff = 0;
              }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($voucherdiff)>0)
              {
                $vdiff = $voucherdiff->voucherpay;
              }
              else
              {
                $vdiff = 0;
              }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($accjournsum)>0)
              {
                $accjournalsum = $accjournsum->creditamt;
              }
              else
              {
                $accjournalsum = 0;
              }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
              if(count($accjourndiff)>0)
              {
                $accjournaldiff = $accjourndiff->debitamt;
              }
              else
              {
                $accjournaldiff = 0;
              }

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

if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
 {
 $fdate = $_SESSION['fin2cstart'].'-04-01';
 $tdate = $_SESSION['fin2cend'].'-03-31'; 
 if($company_id!='')
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($accorecList)>0)
                {
                  $accorec = $accorecList->accrec;
                }
                else
                {
                  $accorec = 0;
                }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($accpayList)>0)
                {
                  $accpay = $accpayList->accpay;
                }
                else
                {
                  $accpay = 0;
                }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($accopayList)>0)
                {
                  $accopay = $accopayList->accpay;
                }
                else
                {
                  $accopay = 0;
                }

$acccntsum = $this->Balancesheet_model->get_acc_contra_amt_by_from_credit_ledger_list_id_drange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($acccntsum)>0)
                {
                  $acccontsum = $acccntsum->depamt;
                }
                else
                {
                  $acccontsum = 0;
                }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($acccntdiff)>0)
                {
                  $acccontdiff = $acccntdiff->debamt;
                }
                else
                {
                  $acccontdiff = 0;
                }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($voucherdiff)>0)
                {
                  $vdiff = $voucherdiff->voucherpay;
                }
                else
                {
                  $vdiff = 0;
                }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($accjournsum)>0)
                {
                  $accjournalsum = $accjournsum->creditamt;
                }
                else
                {
                  $accjournalsum = 0;
                }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
                if(count($accjourndiff)>0)
                {
                  $accjournaldiff = $accjourndiff->debitamt;
                }
                else
                {
                  $accjournaldiff = 0;
                }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 //$data['today_cash_list'] = $lopt;
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 else
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($accorecList)>0)
                {
                  $accorec = $accorecList->accrec;
                }
                else
                {
                  $accorec = 0;
                }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($accpayList)>0)
                {
                  $accpay = $accpayList->accpay;
                }
                else
                {
                  $accpay = 0;
                }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($accopayList)>0)
                {
                  $accopay = $accopayList->accpay;
                }
                else
                {
                  $accopay = 0;
                }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($acccntsum)>0)
                {
                  $acccontsum = $acccntsum->depamt;
                }
                else
                {
                  $acccontsum = 0;
                }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($acccntdiff)>0)
                {
                  $acccontdiff = $acccntdiff->debamt;
                }
                else
                {
                  $acccontdiff = 0;
                }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($voucherdiff)>0)
                {
                  $vdiff = $voucherdiff->voucherpay;
                }
                else
                {
                  $vdiff = 0;
                }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($accjournsum)>0)
                {
                  $accjournalsum = $accjournsum->creditamt;
                }
                else
                {
                  $accjournalsum = 0;
                }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange($u_list['ledger_list_id'],$fdate,$tdate);
                if(count($accjourndiff)>0)
                {
                  $accjournaldiff = $accjourndiff->debitamt;
                }
                else
                {
                  $accjournaldiff = 0;
                }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 }
 else
 {
 $data['purchasesearch'] = 'curdate';
 $today = date('Y-m-d');
 if($company_id!='')
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($accorecList)>0)
                  {
                    $accorec = $accorecList->accrec;
                  }
                  else
                  {
                    $accorec = 0;
                  }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($accpayList)>0)
                  {
                    $accpay = $accpayList->accpay;
                  }
                  else
                  {
                    $accpay = 0;
                  }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($accopayList)>0)
                  {
                    $accopay = $accopayList->accpay;
                  }
                  else
                  {
                    $accopay = 0;
                  }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($acccntsum)>0)
                  {
                    $acccontsum = $acccntsum->depamt;
                  }
                  else
                  {
                    $acccontsum = 0;
                  }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($acccntdiff)>0)
                  {
                    $acccontdiff = $acccntdiff->debamt;
                  }
                  else
                  {
                    $acccontdiff = 0;
                  }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($voucherdiff)>0)
                  {
                    $vdiff = $voucherdiff->voucherpay;
                  }
                  else
                  {
                    $vdiff = 0;
                  }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($accjournsum)>0)
                  {
                    $accjournalsum = $accjournsum->creditamt;
                  }
                  else
                  {
                    $accjournalsum = 0;
                  }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date_cid($u_list['ledger_list_id'],$today,$company_id);
                  if(count($accjourndiff)>0)
                  {
                    $accjournaldiff = $accjourndiff->debitamt;
                  }
                  else
                  {
                    $accjournaldiff = 0;
                  }

$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $cre = ($accrec+$acccontsum+$accjournalsum+$accopay);
 $deb = ($accpay + $acccontdiff + $vdiff + $accjournaldiff + $accorec);
 $income+=$cre;$expense+=$deb;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td>".$cre."</td><td>".$deb."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'></a></td></tr>";
 }
 //$data['today_cash_list'] = $lopt;
 }
 $data['today_cash_list'] = $lopt;
 $data['income'] = $income;
 $data['expense'] = $expense;
 }
 else
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($accorecList)>0)
                {
                  $accorec = $accorecList->accrec;
                }
                else
                {
                  $accorec = 0;
                }

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($accpayList)>0)
                {
                  $accpay = $accpayList->accpay;
                }
                else
                {
                  $accpay = 0;
                }

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($accopayList)>0)
                {
                  $accopay = $accopayList->accpay;
                }
                else
                {
                  $accopay = 0;
                }

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($acccntsum)>0)
                {
                  $acccontsum = $acccntsum->depamt;
                }
                else
                {
                  $acccontsum = 0;
                }

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($acccntdiff)>0)
                {
                  $acccontdiff = $acccntdiff->debamt;
                }
                else
                {
                  $acccontdiff = 0;
                }

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($voucherdiff)>0)
                {
                  $vdiff = $voucherdiff->voucherpay;
                }
                else
                {
                  $vdiff = 0;
                }

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($accjournsum)>0)
                {
                  $accjournalsum = $accjournsum->creditamt;
                }
                else
                {
                  $accjournalsum = 0;
                }

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
                if(count($accjourndiff)>0)
                {
                  $accjournaldiff = $accjourndiff->debitamt;
                }
                else
                {
                  $accjournaldiff = 0;
                }

if(isset($_SESSION['fin2cstart']))
 {
 if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
 {
 $fdate = $_SESSION['fin2cstart'].'-04-01';
 $tdate = $_SESSION['fin2cend'].'-03-31'; 
 if($company_id!='')
 {
 $lopt = '';$income=0;$expense=0;
 for($i=6;$i<=7;$i++)
 {
 $ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
 $ledgerAssAmt = 0;
 //$lopt = '';
 foreach($ledger_list as $u_list)
 {
 $accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
 if(count($accrecList)>0)
 {
 $accrec = $accrecList->accrec;
 }
 else
 {
 $accrec = 0;
 }