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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Payment_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_so_details_by_so_no($bno)
  {    
    //$this->db->reconnect();
    $result = $this->db->query("call get_so_details_by_so_no('".$bno."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_contact_details($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_contact_details('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_so_payment_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_payment_by_order_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_payment($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_payment('".$data['order_id']."','".$data['payment_date']."','".$data['payment_mode']."','".$data['payment_amount']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['status']."','".$data['created_on']."',".$data['created_by'].",'".$data['invoice_id']."')");
    //$this->db->close();
    return $result;
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL payment_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_payment_details_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_payment_details_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_payment_by_invoice_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_payment_by_invoice_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_payment($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_payment('".$data['payment_date']."','".$data['payment_mode']."','".$data['payment_amount']."','".$data['cheque_no']."','".$data['bank_name']."','".$data['branch_name']."','".$data['status']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['payment_id']."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Payment_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation