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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Order_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }

function getcustomerlist($postData){

$response = array();

if(isset($postData['search']) ){

$customerrecords = $this->db->query("SELECT c.*,cp.phone_no FROM customer c, customer_phone cp WHERE cp.customer_id = c.customer_id AND (c.customer_name LIKE '%".$postData['search']."%' OR cp.phone_no LIKE '%".$postData['search']."%')")->result();

foreach($customerrecords as $row ){
          $response[] = array("value"=>$row->customer_id,"label"=>$row->customer_name.' - '.$row->phone_no);
       }

}

return $response;
  }

public function get_state_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_state_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_payment_history_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payment_history_by_order_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_list($fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_list('".$fdate."','".$tdate."')")->result_array();
    
    // Elan * 2022-06-17
    // $result = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o, `location` l, `admin_users` au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_date>='".$fdate."' AND o.order_date<='".$tdate."' GROUP BY o.order_id ORDER BY o.order_id DESC");
    // $sqlquery = $this->db->query($sql);
    // $result = $sqlquery->result() ;
    
    // $sql = "SELECT o.*,l.location_name,au.displayname FROM `order` o, `location` l, `admin_users` au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_date>='".$fdate."' AND o.order_date<='".$tdate."' GROUP BY o.order_id ORDER BY o.order_id DESC";
    // $result = $this->db->query($sql)->result();
    
    
    
    //$this->db->close();
    return $result;
  }
  public function get_active_application()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_application()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_active_reference()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_reference()")->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_location()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_comp_id($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$punit."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_so_payment_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_so_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_delivery_permission()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_delivery_permission()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_type()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_type()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function customer_unique_email($name)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_unique_email('".$name."')")->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 customer_phone_no_unique($name)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_phone_no_unique('".$name."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_uom_by_id($name)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_uom_by_id('".$name."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_uom_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_uom_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_by_product_type_id($ptId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_product_type_id('".$ptId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_price_formula_by_uom_id($uomid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_price_formula_by_uom_id('".$uomid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_details_by_id($prodId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_view_by_id('".$prodId."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_deliverypermission_by_id($dpid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_deliverypermission_by_id('".$dpid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_application_by_id($appid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_application_by_id('".$appid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function last_order_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL last_order_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function last_order_id_by_unit($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL last_order_id_by_unit('".$punit."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_order($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_order('".$data['order_no']."','".$data['customer_id']."','".$data['location_id']."','".$data['order_date']."','".$data['del_date']."','".$data['created_on']."','".$data['created_by']."','".$data['taxable_amount']."','".$data['total_tax']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['transport']."','".$data['booking_place']."','".$data['incharge']."','".$data['advance_amount']."','".$data['balance_amount']."','".$data['product_type_id']."','".$data['quotation_id']."','".$data['delivery_permission_id']."','".$data['is_customer_po']."','".$data['customer_po_no']."','".$data['customer_po_bill']."','".$data['application_id']."','".$data['prod_unit']."','".$data['reference_id']."','".$data['dealer_id']."','".$data['supply_from']."','".$data['supply_to']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['remarks']."','".$data['eyelets']."','".$data['delivery_type']."','".$data['customer_billing_address_id']."','".$data['customer_shipping_address_id']."','".$data['advance_payment_mode']."','".$data['packing_instruction']."','".$data['is_job_card']."')");
    //$this->db->close();
    return $result;
  }
  public function create_order_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_order_product('".$data['order_id']."','".$data['product_id']."','".$data['uom_id']."','".$data['product_type_id']."','".$data['price_formula_id']."','".$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['rate_per_sqft']."','".$data['quantity']."','".$data['rate']."','".$data['disc']."','".$data['amount']."','".$data['product_gst']."','".$data['booked']."','".$data['need_production']."')");
    //$this->db->close();
    return $result;
  }
  public function get_order_view_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_view_by_id('".$id."')")->row();
    //$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_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_general_settings_details(){

//$this->db->reconnect();
    $query  = $this->db->query("call general_setting_details()");
    $result = $query->row();
    //$this->db->close();
    return $result;     
  }
  public function get_customer_address($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_address('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }

public function order_mail_template()
  {
      //$this->db->reconnect();
      $query = $this->db->query("call order_mail_template()");
      $res = $query->row();
      //$this->db->close();
      return $res;
  }
  public function get_customer_email_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_email_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_view_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_view_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_pstock_by_locid_prodid($locId,$prodId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_pstock_by_locid_prodid('".$locId."','".$prodId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_order($data,$oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_order('".$data['customer_id']."','".$data['location_id']."','".$data['order_date']."','".$data['del_date']."','".$data['modified_on']."','".$data['modified_by']."','".$oid."','".$data['taxable_amount']."','".$data['total_tax']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['transport']."','".$data['booking_place']."','".$data['incharge']."','".$data['advance_amount']."','".$data['balance_amount']."','".$data['product_type_id']."','".$data['delivery_permission_id']."','".$data['application_id']."','".$data['reference_id']."','".$data['is_customer_po']."','".$data['customer_po_no']."','".$data['customer_po_bill']."','".$data['supply_from']."','".$data['supply_to']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['remarks']."','".$data['eyelets']."','".$data['delivery_type']."','".$data['customer_billing_address_id']."','".$data['customer_shipping_address_id']."','".$data['dealer_id']."','".$data['advance_payment_mode']."','".$data['packing_instruction']."')");
    //$this->db->close();
    return $result;
  }

public function delete_order_product($oid)
  {
      //$this->db->reconnect();
      $query = $this->db->query("call delete_order_product('".$oid."')");
      //$this->db->close();
      return $query;
  }
  public function update_pstock_by_locid_prodid($locId,$prodId,$stk,$book,$np)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_pstock_by_locid_prodid('".$locId."','".$prodId."','".$stk."','".$book."','".$np."')");
    //$this->db->close();
    return $result;
  }
  public function add_pstock_by_locid_prodid($locId,$prodId,$stk,$book,$np,$con,$cby)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL add_pstock_by_locid_prodid('".$locId."','".$prodId."','".$stk."','".$book."','".$np."','".$con."','".$cby."')");
    //$this->db->close();
    return $result;
  }
  public function get_customer_phone_by_id($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_phone_by_id('".$cid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_new_order_msg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_order_msg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_new_order_whatsappmsg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_order_whatsappmsg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_terms_and_conditions()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_terms_and_conditions()")->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_work_order_count_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_order_by_order_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_issue_register_by_woid($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_issue_register_by_woid('".$woid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_work_log_by_woid($woid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_work_log_by_woid('".$woid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_delivery_challan_by_order_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_delivery_challan_by_order_id('".$oid."')")->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;
  }

// To get location based 
  public function location_based_order_count()
  {
  
    //$this->db->reconnect();
    $result = $this->db->query("call location_based_order_count()")->result();
    //$this->db->close();
    return $result;
  }
  public function dealer_phone_no_unique($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL dealer_phone_no_unique('".$punit."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_name($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_name('".$punit."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_by_name($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_name('".$punit."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_order_amount_value($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_order_amount_value('".$data['order_id']."','".$data['taxable_amount']."','".$data['total_tax']."','".$data['round_off']."','".$data['grand_total']."')");
    //$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_reference_by_id($appid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_reference_by_id('".$appid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_by_product_type_location_id($ptId,$locId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_product_type_location_id('".$ptId."','".$locId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_product_by_product_type_unit_location_id($ptId,$locId,$punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_product_type_unit_location_id('".$ptId."','".$locId."','".$punit."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_order_list($uid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_order_list('".$uid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_order_list($cid,$fdate,$tdate)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_order_list('".$cid."','".$fdate."','".$tdate."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_admin_user_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_admin_user_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_invoice_by_direct_so_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_invoice_by_direct_so_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_billing_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_billing_address_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_shipping_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_shipping_address_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_address_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_first_billing_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_first_billing_address_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_first_shipping_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_first_shipping_address_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_view_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_view_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_order_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_order_view_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_order_view_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_address_by_dealer_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_address_by_dealer_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_address_by_id($did)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_address_by_id('".$did."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_billing_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_billing_address_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_dealer_shipping_address_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dealer_shipping_address_by_id('".$oid."')")->result_array();
    //$this->db->close();
    return $result;
  }

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Order_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation