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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Workorder_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL workorder_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_open_order_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_open_order_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_product_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_product_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_pending_wo_order_product_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pending_wo_order_product_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_product_details_by_op_id($pid,$oid,$opid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_product_details_by_op_id('".$pid."','".$oid."','".$opid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_product_details_by_id($pid,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_product_details_by_id('".$pid."','".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_details_by_ids($rmids)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_details_by_ids('".$rmids."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_view_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_view_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_so_product_by_oid_pid($oid,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_product_by_oid_pid('".$oid."','".$pid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_details_by_location_id($locId,$rmId,$samt)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_details_by_location_id('".$locId."','".$rmId."','".$samt."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_workorder($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_workorder('".$data['work_order_no']."','".$data['order_id']."','".$data['work_order_date']."','".$data['created_on']."',".$data['created_by'].",'".$data['delivery_date_time']."')");
    //$this->db->close();
    return $result;
  }
  public function create_work_order_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_work_order_product('".$data['work_order_id']."','".$data['product_id']."','".$data['spec']."','".$data['uom']."',".$data['order_qty'].",'".$data['rawmaterial_id']."','".$data['rawmaterial_qty']."','".$data['order_product_id']."')");
    //$this->db->close();
    return $result;
  }
  public function update_order_status($data,$ordId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_order_status('".$data['status']."','".$ordId."')");
    //$this->db->close();
    return $result;
  }
  public function get_work_order_by_id($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_by_id('".$woid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_work_order_product_by_id($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_product_by_id('".$woid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_work_order_rm_details_by_id($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_rm_details_by_id('".$woid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_work_order_list($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_list('".$fdate."','".$tdate."')")->result_array();
    //$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 update_so_prod_for_wo($woqty,$oid,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_so_prod_for_wo('".$woqty."','".$oid."','".$pid."')");
    //$this->db->close();
    return $result;
  }
  public function get_so_prod_qty_diff_by_oid($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_prod_qty_diff_by_oid('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_product_list_by_op_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_product_list_by_op_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_location_rawmaterial_id($lid,$rmId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_location_rawmaterial_id('".$lid."','".$rmId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_total_by_location_rawmaterial_id($lid,$rmId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_total_by_location_rawmaterial_id('".$lid."','".$rmId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_user_work_order_list($uid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_work_order_list('".$uid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_open_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_open_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_work_order_list($uid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_work_order_list('".$uid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_open_order_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_open_order_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_by_work_order_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_by_work_order_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_product_by_op_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_product_by_op_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_woq_by_op_id($upwoqty,$opid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_woq_by_op_id('".$upwoqty."','".$opid."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Workorder_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation