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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Accountpayment_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_account_payment_by_date($date)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_by_date('".$date."')")->result_array();
    //$this->db->close();
    return $result;
  }
  /*public function create_accountpayment($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_accountpayment('".$data['account_payment_date']."','".$data['user_type']."','".$data['user_id']."','".$data['payment_type']."','".$data['account_attributes_id']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['created_on']."',".$data['created_by'].",'".$data['expense_type']."')");
    //$this->db->close();
    return $result;
  }*/
  public function create_accountpayment($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_accountpayment('".$data['account_payment_date']."','".$data['payment_type']."','".$data['expense_type']."','".$data['particulars']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['created_on']."',".$data['created_by'].",'".$data['user_id']."','".$data['ledger_list_id']."','".$data['remarks']."','".$data['parti_ledger_list_id']."','".$data['parti_ledger_list_type']."')");
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_by_date_and_aaid($date,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_by_date_and_aaid('".$date."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_by_daterange_and_aaid($fdate,$tdate,$aaid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_by_daterange_and_aaid('".$fdate."','".$tdate."','".$aaid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_by_daterange($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_by_daterange('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_ledger_list_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledger_list_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_account_payment_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_account_payment_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_accountpayment($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_accountpayment('".$data['account_payment_date']."','".$data['payment_type']."','".$data['expense_type']."','".$data['particulars']."','".$data['amount']."','".$data['payment_mode']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['user_id']."','".$data['ledger_list_id']."','".$data['account_payment_id']."','".$data['remarks']."','".$data['parti_ledger_list_id']."','".$data['parti_ledger_list_type']."')");
    //$this->db->close();
    return $result;
  }
  public function accountpayment_delete($apid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL accountpayment_delete('".$apid."')");
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_ledgersubgroup_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_ledgersubgroup_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_payment_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_payment_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_payment_by_date($date,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_payment_by_date('".$date."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_account_payment_by_daterange($fdate,$tdate,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_account_payment_by_daterange('".$fdate."','".$tdate."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_account_payment_by_daterange($fdate,$tdate,$uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_account_payment_by_daterange('".$fdate."','".$tdate."','".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  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_user_purchase_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_purchase_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_expense_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_expense_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_pur_payment_total_by_pur_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pur_payment_total_by_pur_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_exp_payment_total_by_exp_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_exp_payment_total_by_exp_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_expense_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_expense_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_staff_expense_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_staff_expense_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_staffexp_payment_total_by_sexp_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_staffexp_payment_total_by_sexp_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_staff_expense_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_staff_expense_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function account_payment_approve($apid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL account_payment_approve('".$apid."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountpayment_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation