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/models

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: Balancesheet_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Balancesheet_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_liabilities_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_liabilities_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_assets_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_assets_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_liabilities_amount_form_day_book($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_liabilities_amount_form_day_book('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_assets_amount_form_day_book($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_assets_amount_form_day_book('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_bs_by_date($date)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_bs_by_date('".$date."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_credit_bs_amt()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_bs_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_bs_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_opening_stock_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_opening_stock_by_singledate('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_amount_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_amount_by_singledate('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_by_singledate('".$sfyear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_in_direct_expense_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_in_direct_expense_by_singledate('".$sfyear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_sales_amount_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sales_amount_by_singledate('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_amount_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_amount_by_singledate('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_other_receipt_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_other_receipt_by_singledate('".$sfyear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_closing_stock_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_closing_stock_by_singledate('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_amount_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_amount_by_daterange('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_by_daterange('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_in_direct_expense_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_in_direct_expense_by_daterange('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_sales_amount_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sales_amount_by_daterange('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_amount_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_amount_by_daterange('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_other_receipt_by_daterange($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_other_receipt_by_daterange('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_location_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt_by_loc_id($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt_by_loc_id('".$locId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt_by_loc_id($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt_by_loc_id('".$locId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_credit_bs_amt_by_loc_id($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt_by_loc_id('".$locId."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_credit_bs_amt_by_date($fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt_by_date('".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_credit_bs_amt_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_credit_bs_amt_by_loc_id_date($locId,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt_by_loc_id_date('".$locId."','".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_credit_bs_amt_by_loc_id_daterange($locId,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_bs_amt_by_loc_id_daterange('".$locId."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt_by_date($fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt_by_date('".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt_by_loc_id_date($locId,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt_by_loc_id_date('".$locId."','".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_hand_amt_by_loc_id_daterange($locId,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_hand_amt_by_loc_id_daterange('".$locId."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt_by_date($fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt_by_date('".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt_by_loc_id_date($locId,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt_by_loc_id_date('".$locId."','".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_cash_in_bank_amt_by_loc_id_daterange($locId,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_cash_in_bank_amt_by_loc_id_daterange('".$locId."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_ledger_list_by_account_attributes_id($aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_by_account_attributes_id('".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_account_receipt_amt_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_amt_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_account_receipt_oamt_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_oamt_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_amt_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_amt_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_oamt_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_oamt_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_from_credit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_from_credit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_debit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_debit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_voucher_amt_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_voucher_amt_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_account_receipt_amt_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_amt_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_account_receipt_oamt_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_oamt_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_amt_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_amt_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_oamt_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_oamt_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_from_credit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_from_credit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_debit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_debit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_voucher_amt_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_voucher_amt_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  
  public function get_account_receipt_amt_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_amt_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  
  public function get_account_receipt_oamt_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_oamt_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_amt_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_amt_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_oamt_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_oamt_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_from_credit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_from_credit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_debit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_debit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_voucher_amt_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_voucher_amt_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  
  public function get_account_receipt_amt_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_amt_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  
  public function get_account_receipt_oamt_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_receipt_oamt_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_amt_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_amt_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_oamt_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_oamt_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_acc_contra_amt_by_from_credit_ledger_list_id_drange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_acc_contra_amt_by_from_credit_ledger_list_id_drange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_debit_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_voucher_amt_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_voucher_amt_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_credit_ledger_list_id_date($lid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_credit_ledger_list_id_date('".$lid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_debit_ledger_list_id_date($lid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_debit_ledger_list_id_date('".$lid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_credit_ledger_list_id_daterange($lid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_credit_ledger_list_id_daterange('".$lid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_debit_ledger_list_id_daterange($lid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_debit_ledger_list_id_daterange('".$lid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_credit_ledger_list_id_date_cid($lid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_credit_ledger_list_id_date_cid('".$lid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_debit_ledger_list_id_date_cid($lid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_debit_ledger_list_id_date_cid('".$lid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_credit_ledger_list_id_daterange_cid($lid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_credit_ledger_list_id_daterange_cid('".$lid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_journal_from_debit_ledger_list_id_daterange_cid($lid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_journal_from_debit_ledger_list_id_daterange_cid('".$lid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_tax_ledger_from_credit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_credit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_tax_ledger_from_debit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_debit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_from_credit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_credit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_tax_ledger_from_debit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_debit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_from_credit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_credit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_tax_ledger_from_debit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_debit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_from_credit_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_credit_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_tax_ledger_from_debit_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_from_debit_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_debit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_debit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_tds_ledger_from_debit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_debit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_debit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_debit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_debit_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_debit_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }  
  public function get_sexp_ledger_from_debit_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sexp_ledger_from_debit_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  } 
  public function get_sexp_ledger_from_debit_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sexp_ledger_from_debit_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_sexp_ledger_from_debit_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sexp_ledger_from_debit_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_sexp_ledger_from_debit_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sexp_ledger_from_debit_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_ledger_list_by_account_attributes_company_id($aaid,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_by_account_attributes_company_id('".$aaid."','".$cid."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_credit_note_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_note_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_note_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_note_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_credit_note_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_note_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_note_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_note_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_credit_note_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_note_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_note_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_note_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_credit_note_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_credit_note_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_debit_note_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_debit_note_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_contra_amt_by_from_credit_ledger_list_id_drange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_contra_amt_by_from_credit_ledger_list_id_drange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_fixed_asset_line_item_by_ledger_list_id_date($llid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_fixed_asset_line_item_by_ledger_list_id_date('".$llid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_fixed_asset_line_item_by_ledger_list_id_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_fixed_asset_line_item_by_ledger_list_id_daterange('".$llid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_fixed_asset_line_item_by_ledger_list_id_date_cid($llid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_fixed_asset_line_item_by_ledger_list_id_date_cid('".$llid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_fixed_asset_line_item_by_ledger_list_id_daterange_cid($llid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_fixed_asset_line_item_by_ledger_list_id_daterange_cid('".$llid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_ledger_details_view_by_custom_date_cid($fdate,$tdate,$id,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_details_view_by_custom_date_cid('".$fdate."','".$tdate."','".$id."','".$cid."')")->result_array();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Balancesheet_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation