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/public_html/crm/application/modules/dm/models

Free Space:

4.04 TB

🔧 Quick Actions

✏️ Editing: Dm_model.php

<?php
Class Dm_model extends CI_Model {    
	private $menu_html;
	 public function __construct() {
        parent::__construct();
        $this->menu_html = '';
    }
    function getFieldItemExist($data,$table,$parent=0) {
		
		if($table == 'business_category'){
			$query = $this->db->query( "SELECT ".$table."_id AS id,".$table."_name AS name FROM ".$table." WHERE ".$table."_name = '".$data."' AND ".$table."_parent_id = '".$parent."'" );
		}
		else{
			$query = $this->db->query( "SELECT ".$table."_id AS id, ".$table."_name AS name FROM ".$table." WHERE ".$table."_name = '".$data."'" );
		}
        if ( $query->num_rows() >= 1 ) {
            return $query->num_rows();
        } else {
            return false;
        }
    }
    
     function getFieldItem($table) {
			$query = $this->db->query( "SELECT ".$table."_id AS id, ".$table."_name AS name FROM ".$table."" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
    }
        
    
    function addRecord($main_table, $data, $customer_id = 0)
    {

if(isset($data['tbl_client_product']) && !empty($data['tbl_client_product'])){
			if(!isset($data['tbl_client_product'][1]['ref_product_id']) && empty($data['tbl_client_product'][1]['ref_product_id'])){
				unset($data['tbl_client_product']);
			}
		}
		if(isset($data['tbl_client_website']) && !empty($data['tbl_client_website'])){
			if(empty($data['tbl_client_website'][1]['website_url'])){
				unset($data['tbl_client_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);
                }
            }
        }
       // exit;
        return $last_id;
    }
   
    function addRecord_old( $data,$client_id = 0 ) {
		//~ echo "<pre>";
			//~ print_r( $data);
			//~ echo "</pre>";
			//~ exit;
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$data_collection_date = date("Y-m-d H:i:s", strtotime($data['client_data_collection_date_and_time']));
		
		if(!empty($data['client_referred_date'])){
			$refered_date = date("Y-m-d H:i:s", strtotime($data['client_referred_date']));
		}else{
			$refered_date = '0000-00-00';
		}
		$date = date('Y-m-d H:i:s');
		if(isset($data['client_data_source_others'])){
			$data_source_others = $data['client_data_source_others'];
		}else{
			$data_source_others = '';
		}
		
		 $query = $this->db->query( "INSERT INTO client SET 
				client_data_collection_date_and_time = '".$data_collection_date."',
				ref_data_source_id = '".$data['ref_data_source_id']."',
				client_data_source_others = '".str_replace("'","",$data_source_others)."',
				client_data_source_link = '".str_replace("'","",$data['client_data_source_link'])."',
				ref_client_business_category_id = '".$data['ref_client_business_category_id']."',
				ref_client_business_sub_category_id = '".$data['ref_client_business_sub_category_id']."',
				ref_salutation_id = '".$data['ref_salutation_id']."',
				client_name = '".str_replace("'","",$data['client_name'])."',
				client_address_line1 = '".str_replace("'","",$data['client_address_line1'])."',
				client_address_line2 = '".str_replace("'","",$data['client_address_line2'])."',
				client_address_line3 = '".str_replace("'","",$data['client_address_line3'])."',
				ref_area_id = '".$data['ref_area_id']."',
				ref_state_id = '".$data['ref_state_id']."',
				ref_country_id = '".$data['ref_country_id']."',
				ref_district_id = '".$data['ref_district_id']."',
				client_pincode = '".str_replace("'","",$data['client_pincode'])."',
				client_referred_date = '".$refered_date."',
				client_referred_by = '".str_replace("'","",$data['client_referred_by'])."',
				ref_user_id = '".$user_id."',
				added_date = '".$date."'");
        $last_id = $this->db->insert_id();
        
        if(isset($data['tbl_client_contact_numbers'])){
			
			//$this->db->query( " DELETE FROM client_contact_numbers WHERE ref_client_id = '".$client_id."'" );
			$client_contact_numbers = array();
			$client_contact_numbers = $data['client_contact_numbers'];
			foreach( $client_contact_numbers as $key => $contact_number){
				if($key !='primary_contact'){
					if(isset($data['client_contact_numbers']['primary_contact']) && $key == $data['client_contact_numbers']['primary_contact']){
						$primary_contact = '1';
					}else{
						$primary_contact = '0';
					}
					
					$this->db->query( "INSERT INTO client_contact_numbers SET 
							ref_client_id = '".$last_id."',
							primary_contact = '".$primary_contact."',
							contact_person = '".str_replace("'","",$contact_number['contact_person'])."',
							ref_designation_id = '".$contact_number['ref_designation_id']."',
							mobile_or_phone_or_whatsapp = '".$contact_number['mobile_or_phone_or_whatsapp']."',
							std_code = '".str_replace("'","",$contact_number['std_code'])."',
							contact_number = '".str_replace(" ","",$contact_number['contact_number'])."',
							contact_extension = '".str_replace("'","",$contact_number['contact_extension'])."',
							contact_timing_from = '".str_replace("'","",$contact_number['contact_timing_from'])."',
							contact_timing_to = '".str_replace("'","",$contact_number['contact_timing_to'])."',
							ref_user_id = '".$user_id."',
							added_date = '".$date."'");
				}
			}
		}
	
		if(isset($data['tbl_client_email_ids'])){
			//$this->db->query( " DELETE FROM client_email_ids WHERE ref_client_id = '".$client_id."'" );
			foreach($data['client_email_ids'] as $key => $client_email_ids){
				if($key !='primary_contact'){
					if(isset($data['client_email_ids']['primary_contact']) &&$key == $data['client_email_ids']['primary_contact']){
							$primary_contact = '1';
					}else{
						$primary_contact = '0';
					}
					
					$this->db->query( "INSERT INTO  client_email_ids SET 
						ref_client_id = '".$last_id."',
						primary_contact = '".$primary_contact."',
						contact_person = '".str_replace("'","",$client_email_ids['contact_person'])."',
						ref_designation_id = '".$client_email_ids['ref_designation_id']."',
						email_id = '".str_replace("'","",$client_email_ids['email'])."',
						ref_user_id = '".$user_id."',
						added_date = '".$date."'");
				}
			}
		}
		
		if(isset($data['tbl_client_website'])){
			//$this->db->query( " DELETE FROM client_website WHERE ref_client_id = '".$client_id."'" );
			foreach($data['tbl_client_website'] as $key => $client_website){					
					$this->db->query( "INSERT INTO  client_website SET 
						ref_client_id = '".$last_id."',
						website_url = '".$client_website['website_url']."',
						responsive_status = '".$client_website['responsive_status']."',
						website_type = '".$client_website['website_type']."',
						admin_url = '".$client_website['admin_url']."',
						superadmin_password = '".$client_website['superadmin_password']."',
						webadmin_password = '".$client_website['webadmin_password']."',
						ref_user_id = '".$user_id."',
						added_date = '".$date."'");
				//}
			}
		}
		if(isset($data['tbl_client_product'])){
			
			//$this->db->query( " DELETE FROM client_website WHERE ref_client_id = '".$client_id."'" );
			foreach($data['tbl_client_product'] as $key => $client_product){					
					$this->db->query( "INSERT INTO  client_product SET 
						ref_client_id = '".$last_id."',
						ref_product_id = '".$client_product['ref_product_id']."',
						creation_date = '".date('Y-m-d',strtotime($client_product['creation_date']))."',
						valid_upto = '".date('Y-m-d',strtotime($client_product['valid_upto']))."',
						ref_user_id = '".$user_id."',
						added_date = '".$date."'");
				//}
			}
		}
        return $last_id;
    }
    
    function addClientCall( $data ) {
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		//$date_time = date("Y-m-d H:i:s");
		$call_duration = $data[2];
		$tot_sec = 0;
		if (strpos($call_duration,'min') !== false) {
			$min_sec = str_replace(' min','',$call_duration);
			$min = explode(':',$min_sec);
			$tot_sec = $min[0] * 60 + $min[1];
		}
		if (strpos($call_duration,'sec') !== false) {
			$tot_sec = str_replace(' sec','',$call_duration);
		}
		
		 $call_date = date("Y-m-d H:i:s", strtotime(" -$tot_sec seconds"));
		
		if(isset($data[7]) && !empty($data[7])){
			$reaminder_date = date("Y-m-d H:i:s", strtotime($data[7]));
		}else{
			$reaminder_date = '';
		}
		$date = date('Y-m-d H:i:s');	
        $query = $this->db->query( "INSERT INTO client_calls SET ref_client_id = '".$data[0]."',client_call_date_and_time = '".$call_date."',client_call_duration = '".$data[2]."',ref_client_call_not_connected_id = '".$data[3]."',ref_client_call_feedback_id = '".$data[4]."',client_call_comments = '".$data[5]."',client_call_reminder = '".$data[6]."',ref_client_call_purpose_id = '".$data[8]."',contact_number = '".$data[9]."',client_call_reminder_date = '".$reaminder_date."',delete_status = 0, ref_user_id = '".$user_id."',transaction_id = 0, added_date = '".$date."'" );
        return $this->db->insert_id();
    }
    
    function updateClientCall( $data ) {
/*
		$last_id = $this->addClientCall( $data );      
        $query = $this->db->query( "UPDATE client_calls SET transaction_id = '".$last_id."' WHERE client_call_id = '".$data[10]."'");
		return $last_id;
*/
			
		$main_data['ref_client_id'] = $data[0];
        $main_data['ref_client_call_purpose_id'] = $data[8];
        $main_data['ref_client_call_not_connected_id'] = $data[3];
        $main_data['ref_client_call_feedback_id'] = $data[4];
        $main_data['client_call_reminder'] = $data[6];
        if(isset($data[6]) && !empty($data[6])){
			$main_data['client_call_reminder_date'] = date('Y-m-d H:i:s',strtotime($data[7]));
		}else{
			$main_data['client_call_reminder_date'] = '';
		}
       
        $main_data['client_call_comments'] = $data[5];

$this->db->where( 'client_call_id', $data[10]);
        $this->db->update('client_calls', $main_data);
        return $data[10];
        
    }
   
   function addClientAppointment( $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 client_appointments SET ref_client_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_employee_id = '".$data[7]."',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 updateClientAppointment( $data ) {
		$last_id = $this->addClientAppointment($data);
		$query = $this->db->query( "UPDATE client_appointments SET transaction_id = '".$last_id."' WHERE client_appointment_id = '".$data[10]."'");
        return $last_id;
    }

function updateClient($main_table, $data, $id ) {

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

$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;
                }
            }
        }
		
        //update Current record 
        $this->db->where($main_table.'_id', $id);
        $this->db->update($main_table, $main_data);
		
		$this->Common_model->dataBackup('client_backup',$main_table,$id);
		
		// Sub table data insertion - Mobile number and Email ids
		if(isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $value) {
				$this->db->where('ref_'.$main_table.'_id', $id);
				$this->db->update($key, array('delete_status' => 1));
				$new_table = $key;
				foreach ($value as $key => $value) {
					$value['ref_'.$main_table.'_id'] = $id;
					//$value['table_name'] = $main_table;
					$value['ref_user_id'] = $user_id;
					$value['added_date'] = $date;
					$new_data = $value;
					if($new_table == 'client_product'){
						$new_data['creation_date'] = date("Y-m-d H:i:s", strtotime($new_data['creation_date']));
						$new_data['valid_upto'] = date("Y-m-d H:i:s", strtotime($new_data['valid_upto']));
					}
					$this->db->insert($new_table, $new_data);
					//echo $this->db->last_query();
				}
			}
		}
		//exit;
		// Ends here
		return $id;
        
    }
    
	function addFieldItem($data,$table,$parent){
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$date = date('Y-m-d H:i:s');
		if($table == 'business_category'){
			$query = $this->db->query( "INSERT INTO ".$table." set ".$table."_name = '".$data."' , ".$table."_parent_id ='".$parent."',ref_user_id = '".$user_id."', added_date = '".$date."'" );
		}
		else{
			$query = $this->db->query( "INSERT INTO ".$table." set ".$table."_name = '".$data."',ref_user_id = '".$user_id."', added_date = '".$date."'" );
		}
        return $this->db->insert_id();
	} 
	
	function parentCheck($cat_id){
		$sql = "select product_parent_id from product where product_id=$cat_id";
		$query = $this->db->query( $sql );
		if ( $query->num_rows() >= 1 ) {
			
			$res = $query->result();
			//echo $res[0]->product_parent_id;
			return $res[0]->product_parent_id;
		}else{
			return false;
		}
	}
	function hasParent($cat_id) {
		$rec_count = 1;
		do {
			$result = $this->parentCheck($cat_id);
			$rec_count++;
			$cat_id = $result;
		}while($result);
		return $rec_count;
	} 
	
	
	
	function render_menu($parent_id,$product_id){
		$sql = "select * from product where product_parent_id=$parent_id";
		$query = $this->db->query( $sql );
		if ( $query->num_rows() >= 1 ) {
			foreach( $query->result() as $key=> $val){
				if($parent_id == 0)
				$this->menu_html.="<option value='".$val->product_id."'>".$val->product_name."</option>";
			else {
				 $rec_count = $this->hasParent($val->product_id);
				$space = '';
				for($i = 0; $i < $rec_count; $i++ ) {
					$space .= '&nbsp;&nbsp;';
				}
				if($val->product_id == $product_id){
					$this->menu_html.="<option value='".$val->product_id."' selected>".$space."--".$val->product_name."</option>";
				}else{
					$this->menu_html.="<option value='".$val->product_id."'>".$space."--".$val->product_name."</option>";
				}
				$space = '';
			}	
			$this->render_menu($val->product_id,$product_id);
			$this->menu_html.="</option>";
			
			}
			
			return $this->menu_html;
		} else {
			return false;
		}				
		
	}
			
	function getProductList($product_id=0){
		$this->menu_html = "";
		$category = $this->render_menu(0,$product_id);
		return $category; 
		
	}
	function getClientCallsByDate($call_date,$client,$date,$type=''){		
		//echo $type;
		if($type == 'month'){
			$sql = "SELECT  cc.ref_client_id,client_call_duration As duration FROM client_calls AS cc
			WHERE DATE_FORMAT(cc.client_call_date_and_time, '%m-%Y') = '".$date."' AND cc.ref_client_id = '".$client."' AND cc.client_call_date_and_time = '".$call_date."' AND cc.delete_status = 0 AND cc.transaction_id = 0";
		}else{
			$sql = "SELECT  cc.ref_client_id,client_call_duration As duration FROM client_calls AS cc
			WHERE DATE_FORMAT(cc.client_call_date_and_time, '%m-%Y') = '".$date."' AND cc.ref_client_id = '".$client."' AND cc.client_call_date_and_time = '".$call_date."' AND cc.delete_status = 0 AND cc.transaction_id = 0";
		}
		//echo $sql;
		//exit;
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
			return $query->result();
		} else {
			return false;
		}
	}
	
	function getCallsDate($client,$date){		
		$sql = "SELECT cc.ref_client_id,cc.client_call_date_and_time FROM client_calls AS cc
		LEFT JOIN client As c ON c.client_id = cc.ref_client_id
		WHERE DATE_FORMAT(cc.client_call_date_and_time, '%m-%Y') = '".$date."' AND cc.ref_client_id ='".$client."' AND cc.delete_status = 0 AND cc.transaction_id = 0 ORDER BY cc.client_call_date_and_time DESC";
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
			return $query->result();
		} else {
			return false;
		}
	}
	
	function getMonthFromCallsReport($client){		
		$sql = "SELECT DATE_FORMAT(cc.client_call_date_and_time, '%M-%Y') as month FROM client_calls AS cc
		LEFT JOIN client As c ON c.client_id = cc.ref_client_id
		WHERE cc.ref_client_id ='".$client."' AND cc.delete_status = 0 AND cc.transaction_id = 0 GROUP BY DATE_FORMAT(cc.client_call_date_and_time, '%M-%Y') ORDER BY DATE_FORMAT(cc.client_call_date_and_time, '%Y') DESC";
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
			return $query->result();
		} else {
			return false;
		}
	}
	
	function getClientList(){
		$sql   = "SELECT client_id,client_name FROM client WHERE delete_status = 0 AND transaction_id = 0";
		$query = $this->db->query($sql);
		$client_list = array();
		if ($query->num_rows() >= 1) {
			foreach ($query->result() as $key => $val) {
				$client_list[] = '"'.$val->client_name.'"';
			}
		}
		return implode(',',$client_list);
	}
	
	function getClientIdByName($client_name){
		$sql   = "SELECT client_id,client_name FROM client WHERE client_name = '".trim($client_name)."' AND delete_status = 0 AND transaction_id = 0";
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
			return $query->result();
		} else {
			return false;
		}
	}

function getClientDetailsByName($client_name)
	{
	    $sql   = "SELECT c.client_id,cc.contact_number,cc.contact_person,cc.primary_contact FROM client as c
	    LEFT JOIN client_contact_numbers as cc on cc.ref_client_id = c.client_id
	    WHERE client_name = '".trim($client_name)."' AND c.delete_status = 0 AND c.transaction_id = 0 AND  cc.delete_status = 0 AND cc.transaction_id = 0 GROUP BY cc.contact_number"  ;
	    
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
			return $query->result();
		} else {
			return false;
		}

}

/**
	 * Get List
	 * 
	 * Get Table record List
	 * 
	 * @param $main_table table name
	 * @param $sort_data for sorting the record(ASC,DESC) optional
	 * @param $filter_Data filter the table record soptional
	 * @param $distinct_field list only one row from multiple records optional
	 */ 
     function getList($table,$sort_data='',$filter_data='',$distinct_field="", $client_id) {
				$main_table = $table['tbl_main']; 
				if(isset($table['tbl_mobile'])){
					$mobile_table = $table['tbl_mobile']; 
				}
				if(isset($table['tbl_email'])){
					$email_table = $table['tbl_email']; 
				}
				$table_fields = $this->Common_model->getTableColumn($main_table);
				
				$filter_query = array();
				$sql = '';
				$filter_sql = '';
				$join_query = '';
				$select_fields = '';
				$filter_data_field = array();
				$join_table_name = array();
				if(isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])){
					foreach($filter_data['filter_data'] as $data){
						 if(empty($data['value'] )){
							$data['value']  = '';
						 }
						 if(empty($data['value_from'] )){
							$data['value_from']  = '';
						 }
						 if(empty($data['value_to'] )){
							$data['value_to']  = '';
						 }
						if ($data['value'] != '' || $data['value_from'] != '' || $data['value_to'] != '') {
							$data['value'] = str_replace("'",'',trim($data['value']));
							if($data['field'] == 'lead_call_reminder' || $data['field'] == 'appointment_to_confirm' || $data['field'] == 'client_call_reminder' ){
								if(strtolower($data['value']) == 'yes'){
									$data['value'] = '1';
								}else{
									$data['value'] = '0';
								}
							}
							
							if($data['field'] == 'call_type'){
								if(strtolower($data['value']) == 'incoming'){
									$data['value'] = '2';
								}else{
									$data['value'] = '1';
								}
							}
							 if (strpos($data['field'], '_date') !== false) {
								 $data['value'] = date('Y-m-d',strtotime($data['value']));
								// $data['field'] = 'date('.$data['field'].')';
							 }
							$filter_data_field[] = $data['field'];
							 if($this->startsWith($data['field'], 'ref_')){
								$ref_field = $data['field'];
								$primary_field = str_replace('ref_','',$data['field']);
								$table_name = str_replace('_id','',$primary_field);
							
								// Restrict duplication of Join Same table
								if(!in_array($table_name,$join_table_name)){
									$ref_data_field = $table_name."_name";
									$join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
									$select_fields .= " , $table_name.$ref_data_field";
									$join_table_name[] = $table_name; 
								}
								
								if($data['operation'] == 'LIKE %...%'){
									if(isset($data['filter_type'])){
										$filter_query[] = $data['filter_type']." ".$ref_data_field." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
									}else{
										$filter_query[] = $ref_data_field." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
									}
								}else{
									if(isset($data['filter_type'])){
										$filter_query[] = $data['filter_type']." ".$ref_data_field." ".$data['operation']." '".$data['value']."'"; 
									}else{
										$filter_query[] = $ref_data_field." ".$data['operation']." '".$data['value']."'"; 
									}
								}
							 }else{
								if($data['operation'] == 'LIKE %...%'){
									if(isset($data['filter_type'])){
										$filter_query[] = $data['filter_type']." ".$data['field']." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
									}else{
										$filter_query[] = $data['field']." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation'])."";
									}
								}else if($data['operation'] == 'BETWEEN'){
									if (isset($data['filter_type'])) {
										$filter_query[] = $data['filter_type'] . " date(" . $main_table.'.'.date($data['field']) . ") " . $data['operation'] . " '" . date('Y-m-d',strtotime($data['value_from'])) . "' AND '" . date('Y-m-d',strtotime($data['value_to'] )). "'";
									} else {
										$filter_query[] = "date(".$main_table.'.'.$data['field'] . ") " . $data['operation'] . " '" . date('Y-m-d',strtotime($data['value_from'])) . "' AND '" . date('Y-m-d',strtotime($data['value_to'] )). "'";
									}
								}else{
									if(isset($data['filter_type'])){
										$filter_query[] = $data['filter_type']." ".$data['field']." ".$data['operation']." '".$data['value']."'"; 
									}else{
										$filter_query[] = $data['field']." ".$data['operation']." '".$data['value']."'"; 
									}
								}
							}
						}
					}				
					if(isset($filter_query) && !empty($filter_query)){
						$filter_sql .= " AND (";
						$filter_sql .= implode(" ",$filter_query);
						$filter_sql .= " )";
					}
					// Set Search data in cookie
					//$this->setCookie($filter_data);
				}
				
			if(isset($table_fields) && !empty($table_fields)){
				foreach($table_fields as $data){
						if($this->startsWith($data, 'ref_')){
							if(isset($filter_data_field) && !empty($filter_data_field)){
								if(!in_array($data,$filter_data_field)){
									$ref_field = $data;
									$primary_field = str_replace('ref_','',$data);
									$table_name = str_replace('_id','',$primary_field);
									$ref_data_field = $table_name."_name";
									$join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
									$select_fields .= " , $table_name.$ref_data_field";
								}
							}
							else
							{
								if($this->startsWith($data, 'ref_')){
									$ref_field = $data;
									$primary_field = str_replace('ref_','',$data);
									$table_name = str_replace('_id','',$primary_field);
									$ref_data_field = $table_name."_name";
									$join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
									$select_fields .= " , $table_name.$ref_data_field";										
								}
							}
						}
					}
				}
				
				
				 //~ if($main_table == 'product' || $main_table == 'business_category'){
					//~ echo $join_query .= " LEFT JOIN $table_name ON $table_name.'_parent_id' = $main_table.'_id' ";
					//~ //$select_fields .= " , $table_name.$ref_data_field";
				//~ }
				
				
				$primary_field = $main_table."_id";
				if($main_table == 'lead' || $main_table == 'client'){
					$sql .= "SELECT DISTINCT $main_table.$primary_field, $main_table.*";
				}else{
					$sql .= "SELECT $main_table.*";
				}
				if(isset($select_fields) && !empty($select_fields)){
					$sql .= " $select_fields ";
				}
				$sql .= " FROM $main_table ";
				if(isset($join_query) && !empty($join_query)){
					$sql .= $join_query;
				}
				if ($main_table != 'approved_services') {
					if (isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])) {
						if(isset($mobile_table) && !empty($mobile_table)){
							$main_table_key_filed = $main_table."_id";
							$ref_table_key_filed = "ref_".$main_table."_id";	
							$sql .= " LEFT JOIN $mobile_table ON $mobile_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
						}
						
						if(isset($email_table) && !empty($email_table)){
							$main_table_key_filed = $main_table."_id";
							$ref_table_key_filed = "ref_".$main_table."_id";	
							$sql .= " LEFT JOIN $email_table ON $email_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
						}
					}
				}
				else
				{
					$sql .= " LEFT JOIN area ON client.ref_area_id = area.area_id";
				}
					
				$sql .= " WHERE ";
					
				$sql .= " $main_table.transaction_id = 0 AND ";
				$sql .= " $main_table.delete_status = 0";
				$sql .=  $filter_sql;
				
				$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');	
				if($main_table == 'general_reminder'){
					if($user_id != '1'){
						$sql .= " AND $main_table.ref_status_id != '4' ";
						$sql .= " AND ($main_table.ref_user_id = '".$user_id."'";
						$sql .= " OR $main_table.assigned_user_id = '".$user_id."')";
					}
				}
				
				if($main_table == 'fbpost' ){
					if($this->logged_in['id'] != '1'){
						if($this->user_group == '25'){ // if Client logged in list only Post related to that client
							$sql .= " AND $main_table.ref_client_id = '".$this->logged_in['ref_client_id']."' ";
						}
						if(in_array(SMM_USER_GROUP,$this->user_group)){
							$sql .= " AND $main_table.submit_to_client = '1' ";
						}
					}
					$client_page_id = $this->session->userdata('client_page_id');
					if($client_page_id){
						$sql .= " AND $main_table.ref_client_facebook_page_id = '".$client_page_id."' ";
					}					
				}
				
				if($main_table == 'user' || $main_table == 'user_group'){
					if($user_id != '1'){
						$sql .= " AND $main_table.user_id NOT IN (".HIDE_USER.") AND $main_table.".$main_table."_id != '1' ";
					}else {
						$sql .= " AND $main_table.user_id NOT IN (".HIDE_USER.") ";
					}
				}
				if(isset($distinct_field) && !empty($distinct_field)){
					$primary_field = str_replace('ref_','',$distinct_field);
					$table_name = str_replace('_id','',$primary_field);
					$sql .= " GROUP BY $table_name.$primary_field ";
				}
				if(isset($sort_data['sort']) && !empty($sort_data['sort'])){
					$sql .= " ORDER BY ".$sort_data['sort']." ".$sort_data['order']."";
				}
				
				if (isset($sort_data['start'])) {
                    if(isset($sort_data['limit']) && !empty($sort_data['limit'])){
                        if($sort_data['limit'] == 'View All'){
                             $sql .= '';
                        }else{
                            $sql .= " LIMIT " . $sort_data['start'] . ",".$sort_data['limit']."";
                        }
                    }else{
                        $sql .= " LIMIT " . $sort_data['start'] . "," . RPP . "";
                    }
                }
				//echo $sql;
				//exit;
				$query = $this->db->query( $sql);
				if ( $query->num_rows() >= 1 ) {
					return $query->result();
				} else {
					return false;
				}
    }
    
    function filterRecord($filter_data, $main_table)
    {
        $filter_sql      = '';
        $join_table_name = array();
        $join_query      = '';
        $select_fields   = '';
        if (isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])) {
            foreach ($filter_data['filter_data'] as $data) {
                if (empty($data['value'])) {
                    $data['value'] = '';
                }
                if (empty($data['value_from'])) {
                    $data['value_from'] = '';
                }
                if (empty($data['value_to'])) {
                    $data['value_to'] = '';
                }
                if ($data['value'] != '' || $data['value_from'] != '' || $data['value_to'] != '') {
                    $data['value'] = str_replace("'", '', trim($data['value']));
                    if ($data['field'] == 'lead_call_reminder' || $data['field'] == 'appointment_to_confirm' || $data['field'] == 'client_call_reminder') {
                        if (strtolower($data['value']) == 'yes') {
                            $data['value'] = '1';
                        } else {
                            $data['value'] = '0';
                        }
                    }
                    if ($data['field'] == 'call_type') {
                        if (strtolower($data['value']) == 'incoming') {
                            $data['value'] = '2';
                        } else {
                            $data['value'] = '1';
                        }
                    }
                    if (strpos($data['field'], '_date') !== false) {
                        $data['value'] = date('Y-m-d', strtotime($data['value']));
                        // $data['field'] = 'date('.$data['field'].')';
                    }
                    $filter_data_field[] = $data['field'];
                    if ($this->startsWith($data['field'], 'ref_')) {
                        $ref_field     = $data['field'];
                        $primary_field = str_replace('ref_', '', $data['field']);
                        $table_name    = str_replace('_id', '', $primary_field);
                        // Restrict duplication of Join Same table
                        if (!in_array($table_name, $join_table_name)) {
                            $ref_data_field = $table_name . "_name";
                            $join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
                            $select_fields .= " , $table_name.$ref_data_field";
                            $join_table_name[] = $table_name;
                        }
                        if ($data['operation'] == 'LIKE %...%') {
                            if (isset($data['filter_type'])) {
                                $filter_query[] = $data['filter_type'] . " " . $ref_data_field . " " . str_replace('%...%', "'%" . $data['value'] . "%'", $data['operation']) . "";
                            } else {
                                $filter_query[] = $ref_data_field . " " . str_replace('%...%', "'%" . $data['value'] . "%'", $data['operation']) . "";
                            }
                        } else {
                            if (isset($data['filter_type'])) {
                                $filter_query[] = $data['filter_type'] . " " . $ref_data_field . " " . $data['operation'] . " '" . $data['value'] . "'";
                            } else {
                                $filter_query[] = $ref_data_field . " " . $data['operation'] . " '" . $data['value'] . "'";
                            }
                        }
                    } else {
                        if ($data['operation'] == 'LIKE %...%') {
                            if (isset($data['filter_type'])) {
                                $filter_query[] = $data['filter_type'] . " " . $data['field'] . " " . str_replace('%...%', "'%" . $data['value'] . "%'", $data['operation']) . "";
                            } else {
                                $filter_query[] = $data['field'] . " " . str_replace('%...%', "'%" . $data['value'] . "%'", $data['operation']) . "";
                            }
                           
                        } else if ($data['operation'] == 'BETWEEN') {
                            if (isset($data['filter_type'])) {
                                $filter_query[] = $data['filter_type'] . " date(" . $main_table . '.' . date($data['field']) . ") " . $data['operation'] . " '" . date('Y-m-d', strtotime($data['value_from'])) . "' AND '" . date('Y-m-d', strtotime($data['value_to'])) . "'";
                            } else {
                                $filter_query[] = "date(" . $main_table . '.' . $data['field'] . ") " . $data['operation'] . " '" . date('Y-m-d', strtotime($data['value_from'])) . "' AND '" . date('Y-m-d', strtotime($data['value_to'])) . "'";
                            }
                        } else {
                            if (isset($data['filter_type'])) {
                                $filter_query[] = $data['filter_type'] . " " . $data['field'] . " " . $data['operation'] . " '" . $data['value'] . "'";
                            } else {
                                $filter_query[] = $data['field'] . " " . $data['operation'] . " '" . $data['value'] . "'";
                            }
                        }
                    }
                }
            }
            if (isset($filter_query) && !empty($filter_query)) {
                $filter_sql .= " AND (";
                $filter_sql .= implode(" ", $filter_query);
                $filter_sql .= " )";
            }
        }
        return $filter_sql;
    }
    
    
  function getListCount( $table,$filter_data,$distinct_field="", $client_id) {
		$main_table = $table['tbl_main']; 
		if(isset($table['tbl_mobile'])){
			$mobile_table = $table['tbl_mobile']; 
		}
		if(isset($table['tbl_email'])){
			$email_table = $table['tbl_email']; 
		} 
		$filter_query = array();
		$sql = '';
		$filter_sql = '';
		$join_query = '';
		$select_fields = '';
		$join_table_name = array();
		
		if(isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])){
			foreach($filter_data['filter_data'] as $data){
				 if(empty($data['value'] )){
					$data['value']  = '';
				 }
				 if(empty($data['value_from'] )){
					$data['value_from']  = '';
				 }
				 if(empty($data['value_to'] )){
					$data['value_to']  = '';
				 }
				if ($data['value'] != '' || $data['value_from'] != '' || $data['value_to'] != '') {
					$data['value'] = str_replace("'",'',trim($data['value']));
					if($data['field'] == 'lead_call_reminder' || $data['field'] == 'appointment_to_confirm' || $data['field'] == 'client_call_reminder' ){
						if(strtolower($data['value']) == 'yes'){
							$data['value'] = '1';
						}else{
							$data['value'] = '0';
						}
					}
					
					if($data['field'] == 'call_type'){
						if(strtolower($data['value']) == 'incoming'){
							$data['value'] = '2';
						}else{
							$data['value'] = '1';
						}
					}
					 if (strpos($data['field'], '_date') !== false) {
						 $data['value'] = date('Y-m-d',strtotime($data['value']));
						// $data['field'] = 'date('.$data['field'].')';
					 }
					 
					if($this->startsWith($data['field'], 'ref_')){
						$ref_field = $data['field'];
						$primary_field = str_replace('ref_','',$data['field']);
						$table_name = str_replace('_id','',$primary_field);
						
						// Restrict duplication of Join Same table
						if(!in_array($table_name,$join_table_name)){
							$ref_data_field = $table_name."_name";
							$join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
							$select_fields .= " , $table_name.$ref_data_field";
							$join_table_name[] = $table_name; 
						}
						
						if($data['operation'] == 'LIKE %...%'){
							if(isset($data['filter_type'])){
								$filter_query[] = $data['filter_type']." ".$ref_data_field." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
							}else{
								$filter_query[] = $ref_data_field." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
							}
						}else{
							if(isset($data['filter_type'])){
								$filter_query[] = $data['filter_type']." ".$ref_data_field." ".$data['operation']." '".$data['value']."'"; 
							}else{
								$filter_query[] = $ref_data_field." ".$data['operation']." '".$data['value']."'"; 
							}
						}
					 }else{
						if($data['operation'] == 'LIKE %...%'){
							if(isset($data['filter_type'])){
								$filter_query[] = $data['filter_type']." ".$data['field']." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation']).""; 
							}else{
								$filter_query[] = $data['field']." ".str_replace('%...%',"'%".$data['value']."%'",$data['operation'])."";
							}
						}else if($data['operation'] == 'BETWEEN'){
							if (isset($data['filter_type'])) {
								$filter_query[] = $data['filter_type'] . " date(" . $main_table.'.'.date($data['field']) . ") " . $data['operation'] . " '" . date('Y-m-d',strtotime($data['value_from'])) . "' AND '" . date('Y-m-d',strtotime($data['value_to'] )). "'";
							} else {
								$filter_query[] = "date(".$main_table.'.'.$data['field'] . ") " . $data['operation'] . " '" . date('Y-m-d',strtotime($data['value_from'])) . "' AND '" . date('Y-m-d',strtotime($data['value_to'] )). "'";
							}	
						}else{
							if(isset($data['filter_type'])){
								$filter_query[] = $data['filter_type']." ".$data['field']." ".$data['operation']." '".$data['value']."'"; 
							}else{
								$filter_query[] = $data['field']." ".$data['operation']." '".$data['value']."'"; 
							}
						}
					}
				}
			}
			
		
			if(isset($filter_query) && !empty($filter_query)){
				$filter_sql .= " AND (";
				$filter_sql .= implode(" ",$filter_query);
				$filter_sql .= " ) ";
			}
			
		}
		
		
		
		/****** Select Query starts Here *****/
		
		// Select main table Fields

$primary_field = $main_table."_id";
		if($main_table == 'lead' || $main_table == 'client'){
			$sql .= "SELECT DISTINCT $main_table.$primary_field,$main_table.*";
		}else{
			$sql .= "SELECT $main_table.*";
		}
		
		// Select Joined table Fileds If available
		if(isset($select_fields) && !empty($select_fields)){
			$sql .= " $select_fields ";
		}
		
		// From Main table
		$sql .= " FROM $main_table ";
		
		// Join query if available
		if ($main_table == 'approved_services') {
			$sql .=	'LEFT JOIN client ON client.client_id = approved_services.ref_client_id';
		}
		else
		{
			if(isset($join_query) && !empty($join_query)){
				$sql .= $join_query;
			}
			if (isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])) {
				if(isset($mobile_table) && !empty($mobile_table)){
					$main_table_key_filed = $main_table."_id";
					$ref_table_key_filed = "ref_".$main_table."_id";	
					$sql .= " LEFT JOIN $mobile_table ON $mobile_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
				}
				
				if(isset($email_table) && !empty($email_table)){
					$main_table_key_filed = $main_table."_id";
					$ref_table_key_filed = "ref_".$main_table."_id";	
					$sql .= " LEFT JOIN $email_table ON $email_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
				}
			}
		}
		
		// Where condition 
		$sql .= " WHERE ";
		$sql .= " $main_table.transaction_id = 0 AND ";
		$sql .= " $main_table.delete_status = 0";
		$sql .=  $filter_sql;
		
		// echo $sql;
		// exit;
		
		$user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');	
		if($main_table == 'general_reminder'){
			if($user_id != '1'){
				$sql .= " AND $main_table.ref_status_id != '4' ";
				$sql .= " AND ($main_table.ref_user_id = '".$user_id."'";
				$sql .= " OR $main_table.assigned_user_id = '".$user_id."')";
			}
		}
		
		if($main_table == 'user' || $main_table == 'user_group'){
			if($user_id != '1'){
				$sql .= " AND $main_table.user_id NOT IN (".HIDE_USER.") AND $main_table.".$main_table."_id != '1' ";
			}else {
				$sql .= " AND $main_table.user_id NOT IN (".HIDE_USER.") ";
			}
		}
		
		if($main_table == 'fbpost' ){
			if($this->logged_in['id'] != '1'){
				if($this->user_group == '25'){ // if Client logged in list only Post related to that client
					$sql .= " AND $main_table.ref_client_id = '".$this->logged_in['ref_client_id']."' ";
				}
				if(in_array(SMM_USER_GROUP,$this->user_group)){
					$sql .= " AND $main_table.submit_to_client = '1' ";
				}
				$client_page_id = $this->session->userdata('client_page_id');
				if($client_page_id){
					$sql .= " AND $main_table.ref_client_facebook_page_id = '".$client_page_id."' ";
				}
			}
		}
		
		if(isset($distinct_field) && !empty($distinct_field)){
			$primary_field = str_replace('ref_','',$distinct_field);
			$table_name = str_replace('_id','',$primary_field);
			$sql .= " GROUP BY $main_table.$distinct_field ";
		}
		// echo $sql;	
		// exit;
		$query = $this->db->query( $sql);
		
		if ( $query->num_rows() >= 1 ) {
			return $query->num_rows();
		} else {
			return false;
		}
    }
    
    function startsWith($string, $key)
    {
        // search backwards starting from haystack length characters from the end
        return $key === "" || strrpos($string, $key, -strlen($string)) !== FALSE;
    }
   
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Dm_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation