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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Profitloss_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
/*public function get_daybook_group_by_voucher_type()
{
  //$this->db->reconnect();
  $result = $this->db->query("CALL get_daybook_group_by_voucher_type()")->result_array();
  //$this->db->close();
  return $result;
}
public function get_expense_group_by_voucher_type($sfyear,$styear)
{
  //$this->db->reconnect();
  $result = $this->db->query("CALL get_expense_group_by_voucher_type('".$sfyear."','".$styear."')")->result_array();
  //$this->db->close();
  return $result;
}
public function get_income_group_by_voucher_type($sfyear,$styear)
{
  //$this->db->reconnect();
  $result = $this->db->query("CALL get_income_group_by_voucher_type('".$sfyear."','".$styear."')")->result_array();
  //$this->db->close();
  return $result;
}*/
  public function get_purchase_amount_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_amount_by_custom_date('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_by_custom_date('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_in_direct_expense_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_in_direct_expense_by_custom_date('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_sales_amount_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sales_amount_by_custom_date('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_amount_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_amount_by_custom_date('".$sfyear."','".$styear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_other_receipt_by_custom_date($sfyear,$styear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_other_receipt_by_custom_date('".$sfyear."','".$styear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_opening_stock_by_custom_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_opening_stock_by_custom_date('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_closing_stock_by_custom_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_closing_stock_by_custom_date('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_amount_by_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_amount_by_date('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_sales_amount_by_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sales_amount_by_date('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_amount_by_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_amount_by_date('".$sfyear."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_stock_ledger($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_stock_ledger('".$data['purchase_amount']."',".$data['sales_amount'].",'".$data['closing_stock']."','".$data['stock_ledger_date']."','".$data['location_id']."')");
    //$this->db->close();
    return $result;
  }
  public function create_stock_ledger($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_stock_ledger('".$data['stock_ledger_date']."',".$data['opening_stock'].",'".$data['purchase_amount']."','".$data['sales_amount']."','".$data['closing_stock']."','".$data['location_id']."')");
    //$this->db->close();
    return $result;
  }
  public function get_stock_ledger_by_date($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_stock_ledger_by_date('".$sfyear."')")->row();
    //$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_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_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_location_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_amount_by_date_loc_id($sfyear,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_amount_by_date_loc_id('".$sfyear."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_sales_amount_by_date_loc_id($sfyear,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_sales_amount_by_date_loc_id('".$sfyear."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_amount_by_date_loc_id($sfyear,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_amount_by_date_loc_id('".$sfyear."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_stock_ledger_by_date_loc_id($sfyear,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_stock_ledger_by_date_loc_id('".$sfyear."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_id($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_group_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_group_by_singledate('".$sfyear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_in_direct_expense_group_by_singledate($sfyear)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_in_direct_expense_group_by_singledate('".$sfyear."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_ledger()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_ledger()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_expense_ledger()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_expense_ledger()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_de_ledger_details_view_by_lid_date($llid,$cdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_de_ledger_details_view_by_lid_date('".$llid."','".$cdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_de_ledger_details_view_by_lid_daterange($llid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_de_ledger_details_view_by_lid_daterange('".$llid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_de_ledger_details_view_by_lid_cid_date($llid,$cid,$cdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_de_ledger_details_view_by_lid_cid_date('".$llid."','".$cid."','".$cdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_de_ledger_details_view_by_lid_cid_daterange($llid,$cid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_de_ledger_details_view_by_lid_cid_daterange('".$llid."','".$cid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_ledger_by_group_id($lgid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_ledger_by_group_id('".$lgid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_expense_ledger_by_group_id($lgid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_expense_ledger_by_group_id('".$lgid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_voucher_group()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_voucher_group()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_expense_voucher_group()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_expense_voucher_group()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_expense_ledger_by_group_comp_id($lgid,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_expense_ledger_by_group_comp_id('".$lgid."','".$cid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_expense_ledger_by_group_comp_id($lgid,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_expense_ledger_by_group_comp_id('".$lgid."','".$cid."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_direct_income_ledger_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_income_ledger_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_indirect_income_ledger_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_indirect_income_ledger_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_ledger_list_id_date($lgid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_ledger_list_id_date('".$lgid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_ledger_list_id_daterange($lgid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_ledger_list_id_daterange('".$lgid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_ledger_list_id_date_cid($lgid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_ledger_list_id_date_cid('".$lgid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_tds_ledger_from_ledger_list_id_daterange_cid($lgid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tds_ledger_from_ledger_list_id_daterange_cid('".$lgid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payable_ledger_from_ledger_list_id_date($lgid,$fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payable_ledger_from_ledger_list_id_date('".$lgid."','".$fdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payable_ledger_from_ledger_list_id_daterange($lgid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payable_ledger_from_ledger_list_id_daterange('".$lgid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payable_ledger_from_ledger_list_id_date_cid($lgid,$fdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payable_ledger_from_ledger_list_id_date_cid('".$lgid."','".$fdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payable_ledger_from_ledger_list_id_daterange_cid($lgid,$fdate,$tdate,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payable_ledger_from_ledger_list_id_daterange_cid('".$lgid."','".$fdate."','".$tdate."','".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_expense_staff_expense_by_singledate($fdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_expense_staff_expense_by_singledate('".$fdate."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function insert_cron_statistics($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL insert_cron_statistics('".$data['cron_name']."','".$data['cron_date']."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Profitloss_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation