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

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Page_model.php

<?php
Class Page_model extends CI_Model {    
  
    function addRecord(  $main_table, $data, $lead_id = 0 ) {
	
		$user_id = $this->session->userdata('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 {
					//echo $main_data[$key] = $key_new;
					$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 => $value) {
			$new_table = $key;
			foreach ($value 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);
				//~ echo "<pre>";
				//~ print_r($new_data);
				//~ exit;
			}
		}
	}
        return $last_id;
    }
    
    function addFormdata(  $main_table, $data ) {
		$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 {
					//echo $main_data[$key] = $key_new;
					$main_data[$key] = $value;
					$main_data['added_date'] = $date;
				}
			}
		}
		$this->db->insert($main_table, $main_data);
		$last_id = $this->db->insert_id();
        return $last_id;
    }
    
	
    function updateRecord( $main_table,$data, $id ) {
		//~ echo "<pre>";
		//~ print_r($data);
		//~ echo "</pre>";
		//~ exit;
		//~ $last_id = $this->addPage('page',$data,$id);
		//~ $this->db->where('page_id', $id);
		//~ $this->db->update('page', array('transaction_id'=>$last_id));
		
        //~ return $last_id;
        
        
         $user_id = $this->session->userdata('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;
                }
            }
        }
        $primary_field = $main_table.'_id';
        $res_record   = $this->Common_model->getRecord($main_table, $primary_field, $id);
        $audit_record = $res_record[0];
        unset($audit_record->$primary_field);
        $audit_record_final = array();
        foreach ($audit_record as $key => $val) {
            $audit_record_final[$key] = $val;
            if (strpos($key, '_date') !== false) {
                if ($val != '00-00-0000 00:00:00' && $val != '') {
                    $date_field               = date("Y-m-d H:i:s", strtotime($val));
                    $audit_record_final[$key] = $date_field;
                }
            }
        }
		//$audit_record_final['ref_user_id']    = $user_id;
        $audit_record_final['transaction_id'] = $id;
        $audit_record_final['added_date']     = date("Y-m-d H:i:s");
        $last_id                              = $this->addRecord($main_table,$audit_record_final);
        //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 => $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) {
					if(isset($value['required'])){
						$value['required'] = 1;
					}
					$value['ref_'.$main_table.'_id'] = $id;
					//$value['table_name'] = $main_table;
					$value['ref_user_id'] = $user_id;
					$value['added_date'] = $date;
					$new_data = $value;
					$this->db->insert($new_table, $new_data);
				}
			}
		}
		// Ends here
		return $last_id;
		
    }
    
    /**
     * 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 = "")
    {
		$user_group = $this->session->userdata('user_group');
		$profile_id = $this->session->userdata('profile_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();
       
        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 .= " )";
            }
        }
        
        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";
                    }
                }
            }
        }
                
        //$sql .= "SELECT $main_table.*";
        $primary_field = $main_table."_id";
		if($main_table == 'builder' || $main_table == 'property'){
			$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  = "details_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  = "details_id";
            $sql .= " LEFT JOIN $email_table ON $email_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
        }
        
        
        $sql .= " WHERE ";
        if($user_group != '23'){
			if($main_table == 'enquiry_message' || $main_table == 'business_profile_testimonial' || $main_table == 'announcement' ){
				$sql .= " $main_table.ref_user_id = '".$profile_id."' AND ";
			}
			if($main_table == 'referral' || $main_table == 'enquiry_message_profile' || $main_table == 'thankyou_note' ){
				$sql .= " $main_table.ref_profile_id = '".$profile_id."' AND ";
			}
				
		}
        //~ if($main_table == 'customer' || $main_table == 'supplier' ){
			//~ $sql .= " $mobile_table.table_name = '".$main_table."' AND ";
		//~ }
		//~ if($main_table == 'customer' || $main_table == 'supplier'){
			//~ $sql .= " $email_table.table_name = '".$main_table."' AND ";
		//~ }
		
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0";
        $sql .= $filter_sql;
        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['rows']) && !empty($sort_data['rows'])){
				$sql .= " LIMIT " . $sort_data['start'] . ",".$sort_data['rows']."";
			}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 = "")
    {
		$user_group = $this->session->userdata('user_group');
		$profile_id = $this->session->userdata('profile_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();
       
        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 .= " )";
            }
        }
        
        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";
                    }
                }
            }
        }
        
        
        //$sql .= "SELECT $main_table.*";
        $primary_field = $main_table."_id";
		if($main_table == 'customer' || $main_table == 'employee' || $main_table == 'vendor'){
			$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  = "details_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  = "details_id";
            $sql .= " LEFT JOIN $email_table ON $email_table.$ref_table_key_filed = $main_table.$main_table_key_filed";
        }
        
        
        $sql .= " WHERE ";
       if($user_group != '23'){
			if($main_table == 'enquiry_message' || $main_table == 'business_profile_testimonial' || $main_table == 'announcement' || $main_table == 'thankyou_note' ){
				$sql .= " $main_table.ref_user_id = '".$profile_id."' AND ";
			}
			if($main_table == 'referral' || $main_table == 'enquiry_message_profile'){
				$sql .= " $main_table.ref_profile_id = '".$profile_id."' AND ";
			}
				
		}
        //~ if($main_table == 'customer' || $main_table == 'supplier' ){
			//~ $sql .= " $mobile_table.table_name = '".$main_table."' AND ";
		//~ }
		//~ if($main_table == 'customer' || $main_table == 'supplier'){
			//~ $sql .= " $email_table.table_name = '".$main_table."' AND ";
		//~ }
		//$profile_id = $this->session->userdata('profile_id');
		
			//$sql .= " $main_table.ref_profile_id = '".$profile_id."' AND ";
		//}
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0";
        $sql .= $filter_sql;
        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 ";
        }
        //echo $sql;				
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->num_rows();
        } else {
            return false;
        }
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Page_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation