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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Warehousestocktransfer_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL warehousestocktransfer_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_stock_transfer_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_stock_transfer_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_by_location_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_by_location_id('".$lid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_location_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_location_id('".$lid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_stock_location_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_stock_location_id('".$lid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_totstock_by_id($rmId,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_totstock_by_id('".$rmId."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_totstock_by_id($pId,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_totstock_by_id('".$pId."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_warehousestocktransfer($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_warehousestocktransfer('".$data['transfer_date']."','".$data['location_id']."','".$data['warehouse_id']."','".$data['created_on']."','".$data['created_by']."')");
    //$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 update_rawmaterial_stock_by_id($stk,$rmsid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_rawmaterial_stock_by_id('".$stk."','".$rmsid."')");
    //$this->db->close();
    return $result;
  }
  public function create_warehousestocktransfer_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_warehousestocktransfer_product('".$data['warehouse_transfer_id']."','".$data['type']."','".$data['rawmaterial_id']."','".$data['product_id']."','".$data['stock']."')");
    //$this->db->close();
    return $result;
  }
  public function get_product_stock_by_location_id($pId,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_stock_by_location_id('".$pId."','".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_product_stock_by_product_stock_id($psid,$stk)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_product_stock_by_product_stock_id('".$psid."','".$stk."')");
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_stock_transfer_by_id($wstid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_stock_transfer_by_id('".$wstid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_stock_transfer_product_by_id($wstid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_stock_transfer_product_by_id('".$wstid."')")->result_array();
    //$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_product_view_by_id($rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_view_by_id('".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_whstock_by_location_wh_rawmaterial($locId,$whId,$rmId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_whstock_by_location_wh_rawmaterial('".$locId."','".$whId."','".$rmId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_warehouse_stock_by_id($stk,$wsid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_warehouse_stock_by_id('".$stk."','".$wsid."')");
    //$this->db->close();
    return $result;
  }
  public function create_warehouse_stock($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_warehouse_stock('".$data['location_id']."','".$data['warehouse_id']."','".$data['rawmaterial_id']."','".$data['product_id']."','".$data['stock']."','".$data['created_on']."','".$data['created_by']."')");
    //$this->db->close();
    return $result;
  }
  public function get_whstock_by_location_wh_product($locId,$whId,$pId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_whstock_by_location_wh_product('".$locId."','".$whId."','".$pId."')")->row();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Warehousestocktransfer_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation