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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Closingstock_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_current_rawmaterial_stock()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_current_rawmaterial_stock()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_inward_stock_by_lid_rmid_date($lid,$rmid,$dte)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_inward_stock_by_lid_rmid_date('".$lid."','".$rmid."','".$dte."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_outward_stock_by_lid_rmid_date($lid,$rmid,$dte)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_outward_stock_by_lid_rmid_date('".$lid."','".$rmid."','".$dte."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_wastage_by_dt_rmid($dte,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_wastage_by_dt_rmid('".$dte."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_inward_stock_by_lid_rmid_daterange($lid,$rmid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_inward_stock_by_lid_rmid_daterange('".$lid."','".$rmid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_outward_stock_by_lid_rmid_daterange($lid,$rmid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_outward_stock_by_lid_rmid_daterange('".$lid."','".$rmid."','".$fdate."','".$tdate."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_wastage_by_dtrange_rmid($fdate,$tdate,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_wastage_by_dtrange_rmid('".$fdate."','".$tdate."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Closingstock_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation