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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Quotation_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  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 get_uom_by_id($oid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_uom_by_id('".$oid."')")->row();
    //$this->db->close();
    return $result;
  }
  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_active_bank_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_active_bank_list()")->result_array();
    //$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_quotation_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_location_by_id($punit)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_location_by_id('".$punit."')")->row();
    //$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_customer_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_lead_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_lead_list()")->result_array();
    //$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_category_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_category()")->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_product_by_category_id($catId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_category_id('".$catId."')")->result_array();
    //$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_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_bank_by_id($bid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_bank_by_id('".$bid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_quotation($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_quotation('".$data['customer_id']."','".$data['lead_id']."','".$data['quotation_date']."','".$data['validity_date']."','".$data['created_on']."',".$data['created_by'].",'".$data['quotation_code']."','".$data['revised']."','".$data['parent_quotation_id']."','".$data['taxable_amount']."','".$data['total_tax']."','".$data['round_off']."','".$data['grand_total']."','".$data['payment_term_id']."','".$data['delivery_term_id']."','".$data['application_id']."','".$data['reference_id']."','".$data['f_o_r']."','".$data['bank_ids']."','".$data['dealer_id']."','".$data['disc_percent']."','".$data['disc_amount']."','".$data['supply_from']."','".$data['supply_to']."','".$data['packing_charges']."','".$data['other_charges']."','".$data['remarks']."','".$data['company_id']."')");
    //$this->db->close();
    return $result;
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL quotation_last_id()")->row();
    //$this->db->close();
    return $result;
  }
  public function create_quotation_product($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_quotation_product('".$data['quotation_id']."','".$data['category_id']."','".$data['product_id']."','".$data['uom_id']."','".$data['uom']."','".$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_type_id']."','".$data['product_gst']."')");
    //$this->db->close();
    return $result;
  }
  public function get_quotation_view_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_view_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_view_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_view_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_lead_view_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_lead_view_by_id('".$id."')")->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_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_quotation_product_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_product_by_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function last_quotation_code()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL last_quotation_code()")->row();
    //$this->db->close();
    return $result;
  }
  public function update_quotation_parent($data2)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_quotation_parent('".$data2['parent']."','".$data2['quotation_id']."','".$data2['modified_on']."',".$data2['modified_by'].")");
    //$this->db->close();
    return $result;
  }
  public function getCheckRevQuotation($qno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL getCheckRevQuotation('".$qno."')")->result();
    //$this->db->close();
    return $result;
  }
  public function getViewRevQuotationList($qno,$rqno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL getViewRevQuotationList('".$qno."','".$rqno."')")->result();
    //$this->db->close();
    return $result;
  }
  public function getViewQuotationList($qno)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL getViewQuotationList('".$qno."')")->result();
    //$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 quotation_mail_template()
  {
      //$this->db->reconnect();
      $query = $this->db->query("call quotation_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_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_quotation_msg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_quotation_msg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_new_quotaion_whatsappmsg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_quotaion_whatsappmsg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_quotation_terms_and_conditions()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_terms_and_conditions()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_by_lead_id($lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_by_lead_id('".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_product_type_list()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_type_list()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_quotaion_product_by_ptype_id($ptid,$qid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotaion_product_by_ptype_id('".$ptid."','".$qid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_quotaion_order($data2)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_quotaion_order('".$data2['taxable_amount']."','".$data2['total_tax']."','".$data2['round_off']."','".$data2['grand_total']."','".$data2['balance_amount']."','".$data2['order_id']."')");
    //$this->db->close();
    return $result;
  }
  public function change_quotation_status($data2,$qid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL change_quotation_status('".$data2['status']."','".$qid."')");
    //$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_quotation_payment_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_payment_term()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_quotation_delivery_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_delivery_term()")->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_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 get_reference_by_id($refid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_reference_by_id('".$refid."')")->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_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_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_product_by_category_location_id($catId,$compId)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_product_by_category_location_id('".$catId."','".$compId."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_user_quotation_list($uid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_user_quotation_list('".$uid."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_super_user_quotation_list($cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_super_user_quotation_list('".$cid."')")->result_array();
    //$this->db->close();
    return $result;
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Quotation_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation