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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Cashflow extends CI_Controller {
 public function __construct()
 {
 parent::__construct();
 $this->load->model(array('Cashflow_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', 'Cash Flow');
 }

/*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['income_amount'] = $this->Cashflow_model->get_account_receipt($sfyear,$styear);
        $data['expense_amount'] = $this->Cashflow_model->get_account_payment($sfyear,$styear);

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

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

$data['income_amount'] = $this->Cashflow_model->get_account_receipt($sfyear,$styear);
        $data['expense_amount'] = $this->Cashflow_model->get_account_payment($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('cashflow/cashflow_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;

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

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!='')
 {
 for($i=6;$i<=6;$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 = ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

/*if($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
 else
 {
 for($i=6;$i<=6;$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($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
 }
 else
 {
 if($company_id!='')
 {
 for($i=6;$i<=6;$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;
              }

/*if($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
 else
 {
 for($i=6;$i<=6;$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;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

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!='')
 {
 for($i=6;$i<=6;$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 = ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

/*if($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
 else
 {
 for($i=6;$i<=6;$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;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

if($company_id!='')
 {
 for($i=6;$i<=6;$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;
 }

}
 else
 {
 $today = date('Y-m-d');
 $data['dtrange'] = '';
 $data['drnge'] = '';
 $data['company_id'] = '';
 $data['purchasesearch'] = 'curdate';
 /*$data['income_amount'] = $this->Cashflow_model->get_account_receipt_by_singledate($curdate);
 $data['expense_amount'] = $this->Cashflow_model->get_account_payment_by_singledate($curdate);*/
 if(isset($_SESSION['fin2cstart']))
{
 if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
 {
 $fdate = $_SESSION['fin2cstart'].'-04-01';
 $tdate = $_SESSION['fin2cend'].'-03-31'; 
 for($i=6;$i<=6;$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;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

/*if($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
 else
 {
 $today = date('Y-m-d');
 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 = ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 $lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
 //$ledgerAssAmt+= ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 //$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
 }
 //$lopt.="</table>";
 //$lval = "".number_format($ledgerAssAmt,2)."";

/*if($i==6)
 {
 $data['accounts_cash_today'] = $ledgerAssAmt;
 $data['today_cash_list'] = $lopt;
 }
 else
 {
 $data['accounts_bank_today'] = $ledgerAssAmt;
 $data['today_bank_list'] = $lopt;
 }*/
 $data['today_cash_list'] = $lopt;
 }
 }
}
 else
 {
 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;
 }

//$data['location_list'] = $this->Ledger_model->get_location_list();
      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('cashflow/cashflow_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 printcashflow()
  {
    $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->Cashflow_model->get_account_receipt($sfyear,$styear);
    $data['expense_amount'] = $this->Cashflow_model->get_account_payment($sfyear,$styear);
    $this->load->view('cashflow/print_cashflow',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Cashflow.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation