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/reminder/models

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Reminder_model.php

<?php
Class Reminder_model extends CI_Model {
       function getReminder($id) {
		$sql = "SELECT
						r.*,
						s.general_reminder_status_name,p.general_reminder_priority_name
					FROM
						general_reminder AS r
					JOIN general_reminder_status AS s ON 	s.general_reminder_status_id = r.general_reminder_status_id
					JOIN general_reminder_priority AS p ON p.general_reminder_priority_id = r.general_reminder_priority_id
					WHERE r.general_reminder_id = '".$id."'";
        $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="",$reminder_type) {
		$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();
		
		
		if(isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])){
			foreach($filter_data['filter_data'] as $data){
				if($data['value'] !=''){
					$filter_data_field[] = $data['field'];
					 if($this->Common_model->startsWith($data['field'], 'ref_')){
						$ref_field = $data['field'];
						$primary_field = str_replace('ref_','',$data['field']);
						$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($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(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->Common_model->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->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 == '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(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";
		}
			
		$sql .= " WHERE ";
			
		$sql .= " $main_table.transaction_id = 0 AND ";
		$sql .= " $main_table.delete_status = 0";
		$sql .=  $filter_sql;
		
		if($reminder_type){
			$sql .= " AND $main_table.ref_status_id = '".$reminder_type."' ";
		}
		
		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 ".$main_table.".".$sort_data['sort']." ".$sort_data['order']."";
		}
		
		if (isset($sort_data['start'])) {
			if(isset($sort_data['limit']) && !empty($sort_data['limit'])){
				if($sort_data['limit'] == 'All'){
					 $sql .= '';
				}else{
					$sql .= " LIMIT " . $sort_data['start'] . ",".$sort_data['limit']."";
				}
			}else{
				$sql .= " LIMIT " . $sort_data['start'] . "," . RPP . "";
			}
		}
		//echo $sql;
		$query = $this->db->query( $sql);
		if ( $query->num_rows() >= 1 ) {
			return $query->result();
		} else {
			return false;
		}
    }
    
    
    /**
         * Get List Count
         * 
         * Get Table record List Count
         * 
         * @param $main_table table name
         * @param $filter_Data filter the table record soptional
         * @param $distinct_field list only one row from multiple records optional
         */
         
    function getListCount( $table,$filter_data,$distinct_field="",$reminder_type) {
				//$main_table = 'lead';
				$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 = '';
				
				if(isset($filter_data['filter_data']) && !empty($filter_data['filter_data'])){
					foreach($filter_data['filter_data'] as $data){
						if($data['value'] !=''){
							if($this->Common_model->startsWith($data['field'], 'ref_')){
								$ref_field = $data['field'];
								$primary_field = str_replace('ref_','',$data['field']);
								$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($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(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(isset($join_query) && !empty($join_query)){
					$sql .= $join_query;
				}
				
				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;
				
				if($reminder_type){
					$sql .= " AND $main_table.ref_status_id = '".$reminder_type."' ";
				}
				
				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;				
				$query = $this->db->query( $sql);
				
				if ( $query->num_rows() >= 1 ) {
					return $query->num_rows();
				} 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);
	}
	
	function changeReminderStatus($status, $id){
		$this->db->query("UPDATE general_reminder set ref_status_id = '".$status."' WHERE general_reminder_id = '" . $id . "'");

return $id;
	}

function changeReminderPriority($priority, $id){
		$this->db->query("UPDATE general_reminder set ref_priority_id = '".$priority."' WHERE general_reminder_id = '" . $id . "'");
		return $id;
	}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Reminder_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation