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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Purchaseorder_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL purchase_order_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_active_purchase_product_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_purchase_product_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_vendor()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_vendor()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_location()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_location()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_order_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_order_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_rawmaterials()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_rawmaterials()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_id($rm_id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_id('".$rm_id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_purchaseorder($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchaseorder('".$data['vendor_id']."','".$data['purchase_order_date']."','".$data['location_id']."','".$data['purchase_order_no']."','".$data['created_on']."','".$data['created_by']."','".$data['type']."')");
    //$this->db->close();
    return $result;
  }
  public function create_purchaseorder_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchaseorder_product('".$data['purchase_order_id']."','".$data['rawmaterial_id']."','".$data['gsm']."','".$data['color']."','".$data['width']."','".$data['quantity']."')");
    //$this->db->close();
    return $result;
  }
  public function create_purchaseorder_product_by_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchaseorder_product_by_product('".$data['purchase_order_id']."','".$data['product_id']."','".$data['quantity']."')");
    //$this->db->close();
    return $result;
  }
  public function get_purchase_order_by_id($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_order_by_id('".$poid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_order_product_by_id($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_order_product_by_id('".$poid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_order_product_by_product_id($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_order_product_by_product_id('".$poid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_purchaseorder($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchaseorder('".$data['vendor_id']."','".$data['purchase_order_date']."','".$data['location_id']."','".$data['modified_on']."','".$data['modified_by']."','".$data['purchase_order_id']."','".$data['type']."')");
    //$this->db->close();
    return $result;
  } 
  public function delete_purchase_order_product_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_purchase_order_product_by_id('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function purchase_order_complete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL purchase_order_complete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function purchase_order_delete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL purchase_order_delete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_user_purchase_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_purchase_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_purchase_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_purchase_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_poid($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_poid('".$poid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_by_company_id($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_company_id('".$poid."')")->result_array();
    //$this->db->close();
    return $result;
  }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Purchaseorder_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation