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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Invoice_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  public function get_active_products()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_products()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_category()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_category()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_list($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_list('".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function last_id_by_locid($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL invoice_last_id_by_locid('".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function last_id_by_loc_code($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL last_id_by_loc_code('".$locId."')")->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 last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL invoice_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function invoice_no_last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL invoice_no_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dc_order_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dc_order_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_inv_payment_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_inv_payment_term()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_so_delivery_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_delivery_term()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_freight_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_freight_term()")->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_order_view_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_view_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_view_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_view_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rm_details_by_rm_loc_id($rmid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rm_details_by_rm_loc_id('".$rmid."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_pr_details_by_pr_loc_id($pid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pr_details_by_pr_loc_id('".$pid."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rm_stock_by_loc_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rm_stock_by_loc_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_prod_stock_by_loc_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_prod_stock_by_loc_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_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_product_view_by_id($pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_view_by_id('".$pid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_uom_by_id($pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_uom_by_id('".$pid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_weight_by_order_product_id($pid,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_weight_by_order_product_id('".$pid."','".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_invoice($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_invoice('".$data['invoice_no']."','".$data['invoice_date']."','".$data['order_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['freight_term_id']."','".$data['transporter']."','".$data['vehicle_no']."','".$data['lr_rr_no']."','".$data['eway_bill_no']."','".$data['remarks']."','".$data['no_of_packets']."','".$data['net_weight']."','".$data['created_on']."',".$data['created_by'].",'".$data['gross_weight']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['lr_rr_bill']."','".$data['destination_point']."','".$data['work_order_id']."','".$data['delivery_type']."','".$data['eway_bill']."','".$data['status']."')");
    //$this->db->close();
    return $result;
  }
  public function create_invoice_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_invoice_product('".$data['invoice_id']."','".$data['product_id']."','".$data['uom_id']."','".$data['product_type_id']."','".$data['product_gst']."','".$data['price_formula_id']."','".$data['rate_per_sqft']."','".$data['cut_size_length']."','".$data['cut_size_width']."','".$data['cut_size_height']."','".$data['finish_size_length']."','".$data['finish_size_width']."','".$data['finish_size_height']."','".$data['quantity']."','".$data['rate']."','".$data['disc']."','".$data['amount']."','".$data['weight']."')");
    //$this->db->close();
    return $result;
  }

public function create_direct_invoice($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_direct_invoice('".$data['invoice_no']."','".$data['invoice_date']."','".$data['delivery_date']."','".$data['customer_id']."','".$data['type']."','".$data['location_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['freight_term_id']."','".$data['transporter']."','".$data['vehicle_no']."','".$data['lr_rr_no']."','".$data['eway_bill_no']."','".$data['remarks']."','".$data['no_of_packets']."','".$data['net_weight']."','".$data['created_on']."',".$data['created_by'].",'".$data['gross_weight']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['prod_unit']."','".$data['lr_rr_bill']."','".$data['destination_point']."','".$data['direct_so_id']."','".$data['delivery_type']."','".$data['warehouse_id']."','".$data['eway_bill']."','".$data['customer_billing_address_id']."','".$data['customer_shipping_address_id']."','".$data['online_type']."','".$data['online_invoice_no']."','".$data['status']."')");
    //$this->db->close();
    return $result;
  }

public function update_direct_invoice($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_direct_invoice('".$data['invoice_id']."','".$data['invoice_date']."','".$data['delivery_date']."','".$data['customer_id']."','".$data['type']."','".$data['location_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['freight_term_id']."','".$data['transporter']."','".$data['vehicle_no']."','".$data['lr_rr_no']."','".$data['eway_bill_no']."','".$data['remarks']."','".$data['no_of_packets']."','".$data['net_weight']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['gross_weight']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['prod_unit']."','".$data['lr_rr_bill']."','".$data['destination_point']."','".$data['direct_so_id']."','".$data['delivery_type']."','".$data['warehouse_id']."','".$data['eway_bill']."','".$data['customer_billing_address_id']."','".$data['customer_shipping_address_id']."','".$data['status']."')");
    //$this->db->close();
    return $result;
  }

public function create_direct_invoice_rawmaterial($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_direct_invoice_rawmaterial('".$data['invoice_id']."','".$data['rawmaterial_id']."','".$data['rm_uom_id']."','".$data['rm_rate_per_sqft']."','".$data['rm_quantity']."','".$data['rm_rate']."','".$data['rm_disc']."','".$data['rm_amount']."','".$data['product_gst']."','".$data['accessories_weight']."')");
    //$this->db->close();
    return $result;
  }

public function create_direct_invoice_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_direct_invoice_product('".$data['invoice_id']."','".$data['product_id']."','".$data['pr_uom_id']."','".$data['pr_rate_per_sqft']."','".$data['pr_quantity']."','".$data['pr_rate']."','".$data['pr_disc']."','".$data['pr_amount']."','".$data['product_gst']."','".$data['accessories_weight']."')");
    //$this->db->close();
    return $result;
  }
  public function update_delivery_challan_status_by_order_id($data,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_delivery_challan_status_by_order_id('".$data['status']."','".$oid."')");
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_product_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_product_by_id('".$iid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_patyment_term_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_patyment_term_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_delivery_term_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_delivery_term_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_freight_term_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_freight_term_by_id('".$id."')")->row();
    //$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 get_invoice_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_order_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_work_log_status($data,$wlId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_work_log_status('".$data['status']."','".$wlId."')");
    //$this->db->close();
    return $result;
  }
  public function update_work_order_status($data,$woId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_work_order_status('".$data['status']."','".$woId."')");
    //$this->db->close();
    return $result;
  }
  public function update_issue_register_status($data,$woId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_issue_register_status('".$data['status']."','".$woId."')");
    //$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 update_invoice($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_invoice('".$data['invoice_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['freight_term_id']."','".$data['transporter']."','".$data['vehicle_no']."','".$data['lr_rr_no']."','".$data['eway_bill_no']."','".$data['remarks']."','".$data['no_of_packets']."','".$data['net_weight']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['gross_weight']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['lr_rr_bill']."','".$data['destination_point']."','".$data['eway_bill']."','".$data['status']."')");
    //$this->db->close();
    return $result;
  }
  public function get_dc_list_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dc_list_by_order_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_stock_by_location_id($prodId,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_stock_by_location_id('".$prodId."','".$locId."')")->row();
    //$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 get_rawmaterial_stock_details_by_location_id($locId,$prodId,$amt)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_stock_details_by_location_id('".$locId."','".$prodId."','".$amt."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_rawmaterial_stock_by_location_id($lid,$pid,$data,$rmsid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_rawmaterial_stock_by_location_id('".$lid."','".$pid."','".$data['stock']."','".$data['modified_on']."','".$data['modified_by']."','".$rmsid."')");
    //$this->db->close();
    return $result;
  }
  public function get_direct_invoice_view_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_invoice_view_by_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_product_by_rawmaterial_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_product_by_rawmaterial_id('".$iid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_state_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_state_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_application_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_application_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_reference_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_reference_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_payment_details_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_payment_details_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function delete_invoice_product_by_id($invid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_invoice_product_by_id('".$invid."')");
    //$this->db->close();
    return $result;
  }
  public function delete_invoice_by_id($invid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_invoice_by_id('".$invid."')");
    //$this->db->close();
    return $result;
  }
  public function delete_payment_by_invoice_id($invid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_payment_by_invoice_id('".$invid."')");
    //$this->db->close();
    return $result;
  }
  public function get_direct_rm_invoice_product_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_rm_invoice_product_by_id('".$iid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_direct_prod_invoice_product_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_direct_prod_invoice_product_by_id('".$iid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function create_invoice_barcode($bcode,$iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_invoice_barcode('".$bcode."','".$iid."')");
    //$this->db->close();
    return $result;
  }
  public function delete_invoice_barcode_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_invoice_barcode_by_id('".$iid."')");
    //$this->db->close();
    return $result;
  }
  public function get_invoice_barcode_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_barcode_by_id('".$iid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_dispatched_packets_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dispatched_packets_by_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payment_by_order_id($locId,$invId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payment_by_order_id('".$locId."','".$invId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_payment_by_invoice_id($locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payment_by_invoice_id('".$locId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_std_prod_stock_by_loc_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_std_prod_stock_by_loc_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function get_prod_stock_by_loc_id_punit($oid,$punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_prod_stock_by_loc_id_punit('".$oid."','".$punit."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_std_prod_stock_by_loc_id_punit($oid,$punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_std_prod_stock_by_loc_id_punit('".$oid."','".$punit."')")->result_array();
    //$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_invoice_view_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_view_by_id('".$iid."')")->row();
    //$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_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_by_order_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dc_list_by_work_order_id($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dc_list_by_work_order_id('".$woid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_work_order_product_for_inv_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_product_for_inv_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_price_weight_by_prod_uom_id($prod,$uom)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_price_weight_by_prod_uom_id('".$prod."','".$uom."')")->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 update_invoice_status($data,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_invoice_status('".$data['status']."','".$oid."')");
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_rm_stock_by_loc_wh_id($lid,$whid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_rm_stock_by_loc_wh_id('".$lid."','".$whid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_whstock_rm_details_by_rm_loc_wh_id($rmid,$lid,$whid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_whstock_rm_details_by_rm_loc_wh_id('".$rmid."','".$lid."','".$whid."')")->row();
    //$this->db->close();
    return $result;
  }

public function get_wh_prod_stock_by_loc_id_punit($lid,$punit,$whid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_wh_prod_stock_by_loc_id_punit('".$lid."','".$punit."','".$whid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_wh_std_prod_stock_by_loc_id_punit($lid,$punit,$whid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_wh_std_prod_stock_by_loc_id_punit('".$lid."','".$punit."','".$whid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_whstock_pr_details_by_pr_loc_wh_id($pid,$lid,$whid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_whstock_pr_details_by_pr_loc_wh_id('".$pid."','".$lid."','".$whid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_warehouse_stock_by_warehouse_stock_id($data,$whsid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_warehouse_stock_by_warehouse_stock_id('".$data['stock']."','".$data['modified_on']."','".$data['modified_by']."','".$whsid."')");
    //$this->db->close();
    return $result;
  }
  public function invoice_details_by_id($iid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL invoice_details_by_id('".$iid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_invoice_approve_status($data,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_invoice_approve_status('".$data['approve_status']."','".$oid."')");
    //$this->db->close();
    return $result;
  }
  public function get_tax_ledger_by_name_loc_id($ledgname,$locid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_tax_ledger_by_name_loc_id('".$ledgname."','".$locid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function insert_tax_ledger_line_item($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL insert_tax_ledger_line_item('".$data['tax_ledger_line_item_date']."','".$data['ledger_list_id']."','".$data['tax_type']."','".$data['type']."','".$data['type_id']."','".$data['amount']."','".$data['status']."','".$data['created_on']."',".$data['created_by'].")");
    //$this->db->close();
    return $result;
  }
  public function delete_tax_ledger_line_item_by_invoice_type_id($invid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_tax_ledger_line_item_by_invoice_type_id('".$invid."')");
    //$this->db->close();
    return $result;
  }
  public function get_new_invoice_msg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_invoice_msg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterial_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_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_name($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterial_by_name('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_rawmaterialcategory_by_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_rawmaterialcategory_by_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function checkFreighttermUnique($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkFreighttermUnique('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_stock_by_loc_war_prod_id($lid,$wid,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_stock_by_loc_war_prod_id('".$lid."','".$wid."','".$pid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_warehouse_stock_by_loc_war_rm_id($lid,$wid,$pid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_warehouse_stock_by_loc_war_rm_id('".$lid."','".$wid."','".$pid."')")->row();
    //$this->db->close();
    return $result;
  }

public function update_invoice_amount_value($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_invoice_amount_value('".$data['invoice_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."')");
    //$this->db->close();
    return $result;
  }
  public function get_state_by_name($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_state_by_name('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_name($locname)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_name('".$locname."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_vendor_by_id($locname)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_vendor_by_id('".$locname."')")->row();
    //$this->db->close();
    return $result;
  }

public function update_possync_invoice($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_possync_invoice('".$data['invoice_id']."','".$data['invoice_date']."','".$data['delivery_date']."','".$data['customer_id']."','".$data['type']."','".$data['location_id']."','".$data['taxable_amount']."','".$data['tax_total']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['freight_term_id']."','".$data['transporter']."','".$data['vehicle_no']."','".$data['lr_rr_no']."','".$data['eway_bill_no']."','".$data['remarks']."','".$data['no_of_packets']."','".$data['net_weight']."','".$data['created_on']."',".$data['created_by'].",'".$data['gross_weight']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['prod_unit']."','".$data['lr_rr_bill']."','".$data['destination_point']."','".$data['direct_so_id']."','".$data['delivery_type']."','".$data['warehouse_id']."','".$data['eway_bill']."','".$data['customer_billing_address_id']."','".$data['customer_shipping_address_id']."')");
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Invoice_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation