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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Purchase_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_last_id()")->row();
    //$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_pending_grn()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pending_grn()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_pending_po_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pending_po_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 create_purchase($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchase('".$data['vendor_id']."','".$data['purchase_date']."','".$data['purchase_receipt_no']."','".$data['invoice_no']."','".$data['invoice_date']."','".$data['grn_id']."','".$data['total_amount']."','".$data['purchase_no']."','".$data['purchase_bill']."','".$data['created_on']."','".$data['created_by']."','".$data['purchase_order_id']."','".$data['taxable_amount']."','".$data['tax_percent']."','".$data['tax_amount']."','".$data['other_charges']."','".$data['no_of_rolls']."','".$data['remarks']."','".$data['location_id']."')");
    //$this->db->close();
    return $result;
  }
  public function create_purchase_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchase_product('".$data['purchase_id']."','".$data['rawmaterial_id']."','".$data['gsm']."','".$data['grn_weight']."','".$data['quantity']."','".$data['net_weight']."','".$data['rate']."','".$data['amount']."','".$data['rm_weight']."','".$data['purchase_quantity']."','".$data['disc_percentage']."')");
    //$this->db->close();
    return $result;
  }
  public function create_purchase_product_by_product_id($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_purchase_product_by_product_id('".$data['purchase_id']."','".$data['product_id']."','".$data['gsm']."','".$data['grn_weight']."','".$data['quantity']."','".$data['net_weight']."','".$data['rate']."','".$data['amount']."','".$data['rm_weight']."','".$data['purchase_quantity']."','".$data['disc_percentage']."')");
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_id('".$id."')")->row();
    //$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 get_purchase_product_by_product_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_product_by_product_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_purchase($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase('".$data['vendor_id']."','".$data['purchase_date']."','".$data['purchase_receipt_no']."','".$data['invoice_no']."','".$data['invoice_date']."','".$data['grn_id']."','".$data['total_amount']."','".$data['purchase_id']."','".$data['purchase_bill']."','".$data['modified_on']."','".$data['modified_by']."','".$data['purchase_order_id']."','".$data['taxable_amount']."','".$data['tax_percent']."','".$data['tax_amount']."','".$data['other_charges']."','".$data['no_of_rolls']."','".$data['remarks']."')");
    //$this->db->close();
    return $result;
  }  
  public function delete_purchase_product_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_purchase_product_by_id('".$id."')");
    //$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_grn_by_bil_no($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_grn_by_bil_no('".$bno."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_stock_by_location_id($pid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_stock_by_location_id('".$pid."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function getGRNProduct($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL getGRNProduct('".$bno."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function getGRNProduct_by_product($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL getGRNProduct_by_product('".$bno."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_bcno($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_bcno('".$bno."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_weight_by_rmid_bcno($rmid,$bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_weight_by_rmid_bcno('".$rmid."','".$bno."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_purchase_product_rmwgt_by_pid_rmid($wgt,$rmid,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_product_rmwgt_by_pid_rmid('".$wgt."','".$rmid."','".$pid."')");
    //$this->db->close();
    return $result;
  }
  public function update_rmstock_purchase_id_by_bcno($bcno,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_rmstock_purchase_id_by_bcno('".$bcno."','".$pid."')");
    //$this->db->close();
    return $result;
  }
  public function get_grn_product_by_bill_no($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_grn_product_by_bill_no('".$bno."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function create_rawmaterial_stock($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_rawmaterial_stock('".$data['location_id']."','".$data['rm_date']."','".$data['rawmaterial_id']."','".$data['m_no']."','".$data['stock']."','".$data['net_weight']."','".$data['created_on']."','".$data['created_by']."','".$data['grn_id']."')");
    //$this->db->close();
    return $result;
  }
  public function update_grn_status($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_grn_status('".$data['grn_id']."','".$data['status']."','".$data['modified_on']."','".$data['modified_by']."')");
    //$this->db->close();
    return $result;
  }
  public function purchaseApprove($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL purchaseApprove('".$data['purchase_id']."','".$data['status']."','".$data['modified_on']."','".$data['modified_by']."')");
    //$this->db->close();
    return $result;
  }
  public function get_po_rm_qty_by_poid_rmid($poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_po_rm_qty_by_poid_rmid('".$poid."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_po_rm_qty_by_poid_prodid($poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_po_rm_qty_by_poid_prodid('".$poid."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_qty_by_pid_rmid($poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_qty_by_pid_rmid('".$poid."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_qty_by_pid_prodid($poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_qty_by_pid_prodid('".$poid."','".$rmid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_purchase_order_prod_remqty($data,$poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_order_prod_remqty('".$data['received_quantity']."','".$data['status']."','".$poid."','".$rmid."')");
    //$this->db->close();
    return $result;
  } 
  public function update_purchase_order_prod_remqty_prodid($data,$poid,$rmid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_order_prod_remqty_prodid('".$data['received_quantity']."','".$data['status']."','".$poid."','".$rmid."')");
    //$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 get_pop_status_sum_by_poid($poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pop_status_sum_by_poid('".$poid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_purchase_order_status_by_id($data,$poid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_order_status_by_id('".$data['status']."','".$poid."')");
    //$this->db->close();
    return $result;
  }   
  public function update_product_stock_by_location_id($lid,$pid,$data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_product_stock_by_location_id('".$lid."','".$pid."','".$data['stock']."','".$data['modified_on']."','".$data['modified_by']."','".$data['booked']."','".$data['need_production']."')");
    //$this->db->close();
    return $result;
  }
  public function add_product_stock_by_location_id($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL add_product_stock_by_location_id('".$data['location_id']."','".$data['product_id']."','".$data['stock']."','".$data['created_on']."','".$data['created_by']."')");
    //$this->db->close();
    return $result;
  }
  public function get_grn_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_grn_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_grn_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_grn_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_grn_product_by_grn_id($bno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_grn_product_by_grn_id('".$bno."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function purchase_delete($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL purchase_delete('".$bid."')");
    //$this->db->close();
    return $result;
  }
  public function get_purchase_order_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_order_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_purchase_bill($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_purchase_bill('".$data['purchase_id']."','".$data['purchase_bill']."','".$data['modified_on']."','".$data['modified_by']."')");
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_stock_by_grn_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_by_grn_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_purchase_by_purchase_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_purchase_by_purchase_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_invoice_no($ino)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_invoice_no('".$ino."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_direct_purchase_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_purchase_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_location_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_list()")->result_array();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Purchase_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation