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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Customer_model extends CI_Model 
{
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }
  // To get yesterday count
  public function customer_yesterday_count($yesterday)
  {
    
    //$this->db->reconnect();
    $result = $this->db->query("call customer_yesterday_count('".$yesterday."')")->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;
  }

// To get customer category based
  public function customer_category_based_list()
  {
  
    //$this->db->reconnect();
    $result = $this->db->query("call customer_category_based_list()")->result();
    //$this->db->close();
    return $result;
  }

// To get customer type based 
  public function customer_type_based_list()
  {
  
    //$this->db->reconnect();
    $result = $this->db->query("call customer_type_based_list()")->result();
    //$this->db->close();
    return $result;
  }
  public function last_id()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_last_id()")->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_state_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_state_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_type()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_type()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_category()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_category()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_payment_term()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payment_term()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_email_type()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_email_type()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_phone_type()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_phone_type()")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_address_type()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_address_type()")->result_array();
    //$this->db->close();
    return $result;
  }
  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 customer_unique_email($name)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_unique_email('".$name."')")->row();
    //$this->db->close();
    return $result;
  }
  public function customer_unique_email_edit($name,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_unique_email_edit('".$name."','".$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 customer_phone_no_unique_edit($name,$cid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_phone_no_unique_edit('".$name."','".$cid."')")->row();
    //$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 checkCustomerContactNoUnique($val)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkCustomerContactNoUnique('".$val."')")->row();
    //$this->db->close();
    return $result;
  }  
  public function checkCustomerEmailIdUnique($val)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkCustomerEmailIdUnique('".$val."')")->row();
    //$this->db->close();
    return $result;
  }
  public function checkCustomerContactNoUniqueEdit($val,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkCustomerContactNoUniqueEdit('".$val."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }  
  public function checkCustomerEmailIdUniqueEdit($val,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL checkCustomerEmailIdUniqueEdit('".$val."','".$lid."')")->row();
    //$this->db->close();
    return $result;
  }
  public function create_lead($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_lead('".$data['lead_name']."','".$data['occupation']."','".$data['contact_no']."','".$data['email_id']."','".$data['address']."','".$data['pincode']."','".$data['lead_source']."','".$data['lead_type']."','".$data['lead_status']."',".$data['followed_by'].",".$data['status'].",'".$data['created_on']."',".$data['created_by'].")");
    //$this->db->close();
    return $result;
  }
  public function create_lead_followups($data1)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_lead_followups('".$data1['follower_id']."','".$data1['followup_date']."','".$data1['followup_time']."','".$data1['purpose']."','".$data1['lead_id']."')");
    //$this->db->close();
    return $result;
  }
  public function get_customer_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_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_payment_term_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_payment_term_by_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_customer_email_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_email_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_phone_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_phone_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_address_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_address_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_contact_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_contact_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_lead_followups_by_pending_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_lead_followups_by_pending_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function get_intrested_products($id)
  {
    //$this->db->reconnect();
    //$result = $this->db->query("CALL get_intrested_products('".$id."')")->row();
    $result = $this->db->query("SELECT group_concat(product_name) as iprod FROM product WHERE product_id in (".$id.")")->row();
    //$this->db->close();
    return $result;
  }
  public function update_customer($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_customer('".$data['customer_code']."','".$data['customer_name']."','".$data['customer_type']."','".$data['customer_category']."','".$data['company_name']."','".$data['pan_no']."','".$data['gst_no']."','".$data['address']."','".$data['website']."','".$data['bank_name']."','".$data['branch_name']."','".$data['account_no']."','".$data['payment_term']."','".$data['customer_id']."','".$data['modified_on']."',".$data['modified_by'].",'".$data['intrested_products']."','".$data['is_self']."','".$data['state_id']."','".$data['pincode']."','".$data['discount_percentage']."','".$data['opening_balance']."','".$data['crdr']."','".$data['is_sister_concern']."','".$data['sister_concern_location_id']."','".$data['arjun_agri']."','".$data['arjun_tarpaulin']."','".$data['subhiksha_organics']."')");
    //$this->db->close();
    return $result;
  }
  public function delete_customer_email($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_customer_email('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function delete_customer_phone($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_customer_phone('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function delete_customer_address($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_customer_address('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function delete_customer_contact($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_customer_contact('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function update_lead_followups($data1)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_lead_followups('".$data1['follower_id']."','".$data1['followup_date']."','".$data1['followup_time']."','".$data1['purpose']."','".$data1['lead_id']."','".$data1['lead_followups_id']."')");
    //$this->db->close();
    return $result;
  }
  public function get_lead_followups_by_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_lead_followups_by_id('".$id."')")->result_array();
    //$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_lead_followups_by_fup_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_lead_followups_by_fup_id('".$id."')")->row();
    //$this->db->close();
    return $result;
  }
  public function update_lead_followups_by_id($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_lead_followups_by_id('".$data['lead_followups_id']."','".$data['follower_id']."','".$data['comment_status']."','".$data['comments']."','".$data['status']."')");
    //$this->db->close();
    return $result;
  }
  public function customer_active($id, $data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL customer_active(".$id.",".$data.")");
    //$this->db->close();
    return $result;
  }
  public function change_lead_to_cust_status($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL change_lead_to_cust_status(".$id.")");
    //$this->db->close();
    return $result;
  }
  public function create_customer($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer('".$data['customer_code']."','".$data['customer_name']."','".$data['customer_type']."','".$data['customer_category']."','".$data['company_name']."','".$data['pan_no']."','".$data['gst_no']."','".$data['address']."','".$data['website']."','".$data['bank_name']."','".$data['branch_name']."','".$data['account_no']."','".$data['payment_term']."','".$data['created_on']."',".$data['created_by'].",'".$data['intrested_products']."','".$data['lead_id']."','".$data['is_self']."','".$data['state_id']."','".$data['pincode']."','".$data['discount_percentage']."','".$data['opening_balance']."','".$data['crdr']."','".$data['is_sister_concern']."','".$data['sister_concern_location_id']."','".$data['arjun_agri']."','".$data['arjun_tarpaulin']."','".$data['subhiksha_organics']."')");
    //$this->db->close();
    return $result;
  }
  public function create_customer_email($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer_email('".$data['customer_id']."','".$data['email_type_id']."','".$data['email_id']."')");
    //$this->db->close();
    return $result;
  }
  public function create_customer_phone($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer_phone('".$data['customer_id']."','".$data['phone_type_id']."','".$data['phone_no']."')");
    //$this->db->close();
    return $result;
  }
  public function create_customer_address($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer_address('".$data['customer_id']."','".$data['address_type_id']."','".$data['address']."','".$data['address_state_id']."','".$data['address_pincode']."')");
    //$this->db->close();
    return $result;
  }
  public function create_customer_contact_details($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer_contact_details('".$data['customer_id']."','".$data['contact_person_name']."','".$data['contact_no']."','".$data['contact_email_id']."')");
    //$this->db->close();
    return $result;
  }
  public function general_setting_details()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL general_setting_details()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_new_customer_msg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_customer_msg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_new_customer_whatsappmsg()
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_new_customer_whatsappmsg()")->row();
    //$this->db->close();
    return $result;
  }
  public function get_quotation_list_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_quotation_list_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_order_list_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_order_list_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function update_customer_address($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_customer_address('".$data['customer_address_id']."','".$data['address_type_id']."','".$data['address']."','".$data['address_state_id']."','".$data['address_pincode']."')");
    //$this->db->close();
    return $result;
  }
  public function create_customer_opening_balance($data)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_customer_opening_balance('".$data['customer_id']."','".$data['location_id']."','".$data['opening_balance']."','".$data['crdr']."')");
    //$this->db->close();
    return $result;
  }
  public function delete_customer_opening_balance($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_customer_opening_balance('".$id."')");
    //$this->db->close();
    return $result;
  }
  public function get_customer_opening_balance_by_customer_id($id)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_opening_balance_by_customer_id('".$id."')")->result_array();
    //$this->db->close();
    return $result;
  }
  public function get_customer_opening_bal_by_cus_loc_id($cid,$lid)
  {
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_customer_opening_bal_by_cus_loc_id('".$cid."','".$lid."')")->row();
    //$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_count() {
        return $this->db->count_all('customer');
    }

public function get_authors($limit, $start) {
        $this->db->limit($limit, $start);
        $query = $this->db->get('customer');

return $query->result();
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Customer_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation