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/kumon/application/modules/lead/models

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: Lead_model.php

<?php
Class Lead_model extends CI_Model {        
    function addRecord($main_table, $data, $customer_id = 0)
    {
		if(isset($data['tbl_website']) && !empty($data['tbl_website'])){
			if(empty($data['tbl_website'][1]['website_url'])){
				unset($data['tbl_website']);
			}
		}
        $user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
        $date    = date('Y-m-d H:i:s');
        foreach ($data as $key => $value) {
            if ($this->Common_model->startsWith($key, 'tbl_')) {
                $table_new                  = str_replace('tbl_', '', $key);
                $sub_table_data[$table_new] = $value;
            } else {
                if (strpos($key, '_date') !== false ) {
                    $date_field      = date("Y-m-d H:i:s", strtotime($data[$key]));
                    $main_data[$key] = $date_field;
                } else {
                    $main_data[$key]         = $value;
                    $main_data['ref_user_id']    = $user_id;
                    $main_data['added_date'] = $date;
                }
            }
        }
        $this->db->insert($main_table, $main_data);
        $last_id = $this->db->insert_id();
        if (isset($sub_table_data) && !empty($sub_table_data)) {
            foreach ($sub_table_data as $key => $value1) {
                $new_table = $key;
                foreach ($value1 as $key => $value) {
                    $value['ref_'.$main_table.'_id'] = $last_id;
                    $value['ref_user_id']    = $user_id;
                    $value['added_date'] = $date;
                    //$value['table_name'] = $main_table;
                    $new_data            = $value;
                    //echo $value['valid_upto'];
                   // echo '<br>';
                    if($new_table == 'client_product'){
						$new_data['valid_upto'] = date("Y-m-d H:i:s", strtotime($value['valid_upto']));
						$new_data['creation_date'] = date("Y-m-d H:i:s", strtotime($value['creation_date']));
					}
                    $this->db->insert($new_table, $new_data);
                }
            }
        }
         //~ if($customer_id == 0){
			 //~ $user_activity_data = array();
			 //~ $user_activity_data['key'] = 'Lead';
			 //~ $user_activity_data['data'] = $last_id;
			 //~ $this->Common_model->addUserActivity($user_activity_data);
		 //~ }
         
       // exit;
        return $last_id;
    }
    
    function updateLead($main_table, $data, $id ) {

$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
        $date = date('Y-m-d H:i:s');
        foreach ($data as $key => $value) {
            if ($this->Common_model->startsWith($key, 'tbl_')) {
                $table_new                  = str_replace('tbl_', '', $key);
                $sub_table_data[$table_new] = $value;
            } else {
                if (strpos($key, '_date') !== false) {
                    $date_field      = date("Y-m-d H:i:s", strtotime($data[$key]));
                    $main_data[$key] = $date_field;
                } else {
                    $main_data[$key]         = $value;
                    $main_data['ref_user_id'] = $user_id;
                    $main_data['added_date'] = $date;
                }
            }
        }
                
        $this->Common_model->dataBackup('lead_backup',$main_table,$id);
        
        //update Current record 
        $this->db->where($main_table.'_id', $id);
        $this->db->update($main_table, $main_data);
		
		// Sub table data insertion - Mobile number and Email ids
		if(isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $value1) {
				$this->db->where('ref_'.$main_table.'_id', $id);
				$this->db->delete($key);
				$new_table = $key;
				foreach ($value1 as $key => $value) {
					$value['ref_'.$main_table.'_id'] = $id;
					$value['ref_user_id'] = $user_id;
					$value['added_date'] = $date;
					$new_data = $value;
					if($new_table == 'lead_website'){
						$new_data['website_domain_expiry_date'] = date("Y-m-d H:i:s", strtotime($value['website_domain_expiry_date']));
					}
					$this->db->insert($new_table, $new_data);
				}
			}
		}
		// Ends here
		return $id;
        
    }
    
    
    function LeadToClient($id){
		$sql = "INSERT INTO client(
									ref_data_source_id,
									client_data_source_link,
									ref_salutation_id,
									client_name,
									client_address_line1,
									client_address_line2,
									client_address_line3,
									ref_area_id,
									ref_district_id,
									ref_state_id,
									ref_country_id,
									client_pincode,
									client_referred_date,
									client_referred_by,
									ref_user_id
									) 
								SELECT 
									ref_data_source_id,
									lead_data_source_link,
									ref_salutation_id,
									lead_name,
									lead_address_line1,
									lead_address_line2,
									lead_address_line3,
									ref_area_id,
									ref_district_id,
									ref_state_id,
									ref_country_id,
									lead_pincode,
									lead_referred_date,
									lead_referred_by,
									ref_user_id
								FROM 
									lead 
								WHERE 
									lead_id = '".$id."' AND delete_status = 0 AND transaction_id = 0 ";
		$query = $this->db->query($sql);
		$last_id = $this->db->insert_id();
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		
		$date = date('Y-m-d H:i:s');
		
		// add client id in lead table
		$this->db->query("UPDATE lead SET ref_client_id = '".$last_id."', lead_data_collection_date_and_time = '".$date."', added_date = '".$date."',ref_user_id = '".$user_id."' WHERE  lead_id = '".$id."'");	
		
		// add lead id in client table
		$this->db->query("UPDATE client SET ref_lead_id = '".$id."', client_data_collection_date_and_time = '".$date."', added_date = '".$date."',ref_user_id = '".$user_id."' WHERE  client_id = '".$last_id."'");
		
		$sql = "INSERT INTO client_contact_numbers(
													ref_client_id,
													primary_contact,
													contact_person,
													ref_designation_id,
													ref_contact_number_type_id,
													std_code,
													contact_number,
													contact_extension,
													contact_timing_from,
													contact_timing_to
													)
											SELECT 
																																							
													ref_lead_id,										primary_contact,
													contact_person,
													ref_designation_id,
													ref_contact_number_type_id,
													std_code,
													contact_number,
													contact_extension,
													contact_timing_from,
													contact_timing_to
											FROM 
												contact_numbers 
											WHERE 
												ref_lead_id = '".$id."' AND delete_status = 0 AND transaction_id = 0 ";
		$query = $this->db->query($sql);
		$this->db->query("UPDATE client_contact_numbers SET ref_client_id = '".$last_id."' WHERE  ref_client_id = '".$id."'");							
		$sql = "INSERT INTO client_email_ids(
													ref_client_id,
													primary_contact,
													email_id,
													contact_person,
													ref_designation_id
													) 
											SELECT 
													ref_lead_id,										primary_contact,
													email_id,
													contact_person,
													ref_designation_id
											FROM 
												email_ids 
											WHERE 
												ref_lead_id = '".$id."' AND delete_status = 0 AND transaction_id = 0 ";
		$query = $this->db->query($sql);
		$this->db->query("UPDATE client_email_ids SET ref_client_id = '".$last_id."' WHERE  ref_client_id = '".$id."'");
		return $last_id;
	}

return $this->db->insert_id();
    }
    
    
    function addInstantLeadCall( $data ) {
		
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$call_date = date("Y-m-d H:i:s", strtotime($data[1]));
		if(isset($data[7]) && !empty($data[7])){
			$reminder_date = date("Y-m-d H:i:s", strtotime($data[7]));
		}else{
			$reminder_date = '';
		}
		
		
		$date = date('Y-m-d H:i:s');	
		 // Add Instant Laad
		$query = $this->db->query( "INSERT INTO lead SET lead_name = '".$data[8]."',lead_data_collection_date_and_time = '".$date."', added_date = '".$date."',ref_user_id = '".$user_id."'");
		$last_id = $this->db->insert_id();
		
		$query = $this->db->query( "INSERT INTO contact_numbers SET ref_lead_id = '".$last_id."', contact_person = '".$data[8]."', contact_number = '".$data[9]."', added_date = '".$date."',ref_user_id = '".$user_id."'");
		
        $query = $this->db->query( "INSERT INTO lead_calls SET ref_lead_id = '".$last_id."',call_type = '1',lead_call_date_and_time = '".$call_date."',lead_call_duration = '".$data[2]."',ref_lead_call_not_connected_id = '".$data[3]."',ref_lead_call_feedback_id = '".$data[4]."',lead_call_comments = '".$data[5]."',lead_call_reminder = '".$data[6]."',lead_call_reminder_date = '".$reminder_date."',contact_number = '".$data[9]."',delete_status = 0, user_id = '".$user_id."',transaction_id = 0, added_date = '".$date."'" );
        return $this->db->insert_id();
    }
    
    
    function updateLeadCall( $data ) {
		
        $main_data['ref_lead_id'] = $data[0];
        $main_data['ref_lead_call_not_connected_id'] = $data[3];
        $main_data['ref_lead_call_feedback_id'] = $data[4];
        $main_data['lead_call_reminder'] = $data[6];
        if(isset($data[7]) && !empty($data[7])){
			$main_data['lead_call_reminder_date'] = date('Y-m-d H:i:s',strtotime($data[7]));
		}else{
			$main_data['lead_call_reminder_date'] = '';
		}

$main_data['lead_call_comments'] = $data[5];
        $this->db->where( 'lead_call_id', $data[10]);
        $this->db->update('lead_calls', $main_data);
        return $data[10];

}
   
   function addLeadAppointment( $data ) {
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$originalDate = "2010-03-21";
		$process_date = date("Y-m-d H:i:s");
		$visit_date = date("Y-m-d H:i:s", strtotime($data[2]));
		if(isset($data[6]) && !empty($data[6])){
			$confirm_date = date("Y-m-d H:i:s", strtotime($data[6]));
		}else{
			$confirm_date = '';
		}
		$date = date('Y-m-d H:i:s');	
        $query = $this->db->query( "INSERT INTO lead_appointments SET ref_lead_id = '".$data[0]."',appointment_process_date = '".$process_date."',appointment_visit_date = '".$visit_date."',appointment_address = '".$data[3]."',appointment_landmark = '".$data[4]."',appointment_to_confirm = '".$data[5]."',appointment_to_confirm_date = '".$confirm_date."',ref_appointment_feedback_id = '".$data[8]."',appointment_comments = '".$data[9]."', delete_status = 0, ref_user_id = '".$user_id."',added_date = '".$date."'" );
        
        return $this->db->insert_id();
    }
    
    function updateLeadAppointment( $data ) {
		//$last_id = $this->addLeadAppointment($data);
		//$query = $this->db->query( "UPDATE lead_appointments SET transaction_id = '".$last_id."' WHERE lead_appointment_id = '".$data[10]."'");
        //return $last_id;

/*
        echo '<pre>';
        print_r($data);
        echo '</pre>';
        exit;
*/

$main_data['ref_lead_id'] = $data[0];
        $main_data['appointment_visit_date'] = $data[2];
        $main_data['appointment_address'] = $data[3];
        $main_data['appointment_landmark'] = $data[4];
        $main_data['appointment_to_confirm'] = $data[5];
        if(isset($data[6]) && !empty($data[6])){
			$main_data['appointment_to_confirm_date'] = date('Y-m-d H:i:s',strtotime($data[6]));
		}else{
			$main_data['appointment_to_confirm_date'] = '';
		}
        
        $main_data['ref_user_id'] = $data[7];
        $main_data['ref_appointment_feedback_id'] = $data[8];
        $main_data['appointment_comments'] = $data[9];
        $this->db->where( 'lead_appointment_id', $data[10]);
        $this->db->update('lead_appointments', $main_data);
        return $data[10];
        
    }
    
  
	function getLeadCall($id){
		 $query = $this->db->query( "SELECT * FROM lead_calls WHERE lead_call_id = '".$id."'" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	
	function getLeadAppointment($id){
		 $query = $this->db->query( "SELECT * FROM lead_appointments WHERE lead_appointment_id = '".$id."'" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	 function getLeadAppointmentList(){
		  $query = $this->db->query( "SELECT 
										la.*,
										l.lead_name,
										e.employee_name,
										af.appointment_feedback_details 
									FROM lead_appointments as la 
									LEFT JOIN lead as l ON l.lead_id = la.lead_id
									LEFT JOIN employee AS e ON e.employee_id = la.employee_id
									LEFT JOIN appointment_feedback AS af ON af.appointment_feedback_id = la.appointment_feedback_id
									WHERE la.transaction_id = 0 AND la.delete_status = 0
									" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
    
    function removeRecord($main_table,$id_field,$id){
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where($id_field, $id);
		$this->db->update($main_table, $data);
		//$this->db->last_query();
		
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where('ref_lead_id', $id);
		$this->db->update('lead_appointments', $data);
		
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where('ref_lead_id', $id);
		$this->db->update('lead_calls', $data);
	}
	
	function removeLeadAppointment($id){
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where('lead_appointment_id', $id);
		$this->db->update('lead_appointments', $data);
	}
	
    
    function removelead($id){
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where('lead_id', $id);
		$this->db->update('lead', $data);
	}
	
	 function getLastLeadCall($id){
		 $query = $this->db->query( "SELECT m1.* FROM lead_calls m1 LEFT JOIN lead_calls m2 ON (m1.ref_lead_id = m2.ref_lead_id AND m1.lead_call_id < m2.lead_call_id) WHERE m1.ref_lead_id = '".$id."' AND m1.delete_status = 0 AND m1.transaction_id = 0 AND m2.lead_call_id IS NULL ");
		 
		 if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	function getFirstLeadCall($id){
		 $query = $this->db->query( "SELECT m1.*,lcf.lead_call_feedback_name,lcf.lead_call_feedback_id,lcn.lead_call_not_connected_name
											FROM lead_calls m1 
											LEFT JOIN lead_call_not_connected lcn ON m1.		ref_lead_call_not_connected_id = lcn.	lead_call_not_connected_id 
											LEFT JOIN lead_call_feedback lcf ON m1.	ref_lead_call_feedback_id = lcf.lead_call_feedback_id 
											LEFT JOIN lead_calls m2 ON (m1.ref_lead_id = m2.ref_lead_id 
											AND m1.lead_call_id > m2.lead_call_id) 
											WHERE m1.ref_lead_id = '".$id."' 
											AND m1.delete_status = 0 
											AND m1.transaction_id = 0 
											AND m2.lead_call_id IS NULL ");
		 
		 if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Lead_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation