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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Rawmaterialstock_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL rawstock_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_location()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function rawmaterial_stock_mno_unique($name)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL rawmaterial_stock_mno_unique('".$name."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_id($locid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$locid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_name($locid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_name('".$locid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_id($rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_id('".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_name($rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_name('".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_location_rawmaterial_id($locid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_location_rawmaterial_id('".$locid."','".$rmid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_list()")->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_active_rawmaterials()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_rawmaterials()")->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_purchase()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_purchase()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_location_id($pid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_location_id('".$pid."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function add_rawmaterial_stock_by_location_id($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL add_rawmaterial_stock_by_location_id('".$data['location_id']."','".$data['rawmaterial_id']."','".$data['stock']."','".$data['created_on']."','".$data['created_by']."','".$data['m_no']."','".$data['net_weight']."','".$data['vendor_id']."','".$data['rm_date']."','".$data['transport_name']."','".$data['vehicle_no']."','".$data['driver_name']."','".$data['driver_contact_no']."','".$data['purchase_id']."','".$data['bill_copy_no']."')");
    //$this->db->close();
    return $result;
  }
  public function update_rawmaterial_stock_by_location_id($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_rawmaterial_stock_by_location_id('".$data['location_id']."','".$data['rawmaterial_id']."','".$data['stock']."','".$data['modified_on']."','".$data['modified_by']."')");
    //$this->db->close();
    return $result;
  }
  public function clear_rawmaterial_stock()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL clear_rawmaterial_stock()");
    //$this->db->close();
    return $result;
  }
  public function get_purchase_product_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_product_by_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_purchase_status($pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_status('".$pid."')");
    //$this->db->close();
    return $result;
  }
  public function update_purchase_product_by_id($rmwgt,$ppid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_product_by_id('".$rmwgt."','".$ppid."')");
    //$this->db->close();
    return $result;
  }
  public function check_bno_exist_in_grn($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL check_bno_exist_in_grn('".$bno."')")->row();
    //$this->db->close();
    return $result;
  }
  public function check_purchase_by_bno($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL check_purchase_by_bno('".$bno."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_id($pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_id('".$pid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_active_rawmaterial_stock()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_rawmaterial_stock()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rms_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rms_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_rawmaterial_stock_by_mno($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_rawmaterial_stock_by_mno('".$data['m_no']."','".$data['stock']."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Rawmaterialstock_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation