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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Expense_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_expense_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_expense_list()")->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_ledgergroup_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledgergroup_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($vid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$vid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL expense_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function create_expense($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_expense('".$data['vendor_id']."','".$data['expense_date']."','".$data['invoice_no']."','".$data['ledger_group_id']."','".$data['taxable_amount']."','".$data['tax_rate']."','".$data['igst']."','".$data['cgst']."','".$data['sgst']."','".$data['total_amount']."','".$data['remarks']."','".$data['expense_no']."','".$data['expense_bill']."','".$data['created_on']."','".$data['created_by']."','".$data['location_id']."','".$data['tds_value']."','".$data['other_charges']."','".$data['is_fixed_asset']."','".$data['ledger_list_id']."')");
    //$this->db->close();
    return $result;
  }
  public function get_expense_by_id($vid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_expense_by_id('".$vid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_expense($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_expense('".$data['vendor_id']."','".$data['expense_date']."','".$data['invoice_no']."','".$data['ledger_group_id']."','".$data['taxable_amount']."','".$data['tax_rate']."','".$data['igst']."','".$data['cgst']."','".$data['sgst']."','".$data['total_amount']."','".$data['remarks']."','".$data['modified_on']."','".$data['modified_by']."','".$data['expense_id']."','".$data['expense_bill']."','".$data['location_id']."','".$data['tds_value']."','".$data['other_charges']."','".$data['is_fixed_asset']."','".$data['ledger_list_id']."')");
    //$this->db->close();
    return $result;
  }
  public function expense_delete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL expense_delete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_location_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function delete_tax_ledger_line_item_by_expense_type_id($expid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_tax_ledger_line_item_by_expense_type_id('".$expid."')");
    //$this->db->close();
    return $result;
  }
  public function insert_tds_payable_line_item($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL insert_tds_payable_line_item('".$data['tds_payable_line_item_date']."','".$data['ledger_list_id']."','".$data['expense_id']."','".$data['amount']."','".$data['created_on']."','".$data['created_by']."')");
    //$this->db->close();
    return $result;
  }
  public function delete_tds_payable_line_item_by_expense_id($expid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_tds_payable_line_item_by_expense_id('".$expid."')");
    //$this->db->close();
    return $result;
  }
  public function expense_approve($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL expense_approve('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_asset_ledger_list_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_asset_ledger_list_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function insert_fixed_asset_ledger_line_item($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL insert_fixed_asset_ledger_line_item('".$data['fixed_asset_ledger_line_item_date']."','".$data['ledger_list_id']."','".$data['expense_id']."','".$data['amount']."','".$data['created_on']."','".$data['created_by']."')");
    //$this->db->close();
    return $result;
  }
  public function delete_fixed_asset_ledger_line_item_by_expense_id($expid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_fixed_asset_ledger_line_item_by_expense_id('".$expid."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Expense_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation