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

Free Space:

4.04 TB

🔧 Quick Actions

✏️ Editing: Reminder_model1.php

<?php
Class Reminder_model extends CI_Model {
    function getReminderlist() {
		$user_id = $this->session->userdata('user_id');
		$sql = "SELECT
						r.*,
						u.user_name, s.general_reminder_status_name,p.general_reminder_priority_name
					FROM
						general_reminder AS r
					LEFT JOIN general_reminder_status AS s ON 	s.general_reminder_status_id = r.general_reminder_status_id
					LEFT JOIN general_reminder_priority AS p ON p.general_reminder_priority_id = r.general_reminder_priority_id
					LEFT JOIN user AS u ON u.ref_user_id = r.assigned_user_id
					" ;

if($user_id != '1'){
			$sql .= " WHERE s.general_reminder_status_id != '4'";
			$sql .= " AND (r.ref_user_id = '".$user_id."'";
			$sql .= " OR r.assigned_user_id = '".$user_id."')";
		}
		$sql .= " AND r.delete_status = 0 AND r.transaction_id = 0";
		
		//echo $sql;
		$query = $this->db->query( $sql);

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

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

//~ function addReminder( $data ) {
		//~ $user_id = $this->session->userdata('user_id');
		//~ $date = date('Y-m-d H:i:s');
        //~ $query = $this->db->query( "INSERT INTO  general_reminder SET general_reminder_details = '" . $data[ 'general_reminder_details' ] . "',	assigned_user_id = '" . $data[ 'assigned_user_id' ] . "',general_reminder_priority_id = '" . $data[ 'general_reminder_priority_id' ] . "',general_reminder_status_id = '" . $data[ 'general_reminder_status_id' ] . "', 	assigned_date = '" . date('Y-m-d',strtotime($data[ 'assigned_date' ])) . "',completed_date ='" . date('Y-m-d',strtotime($data[ 'completed_date' ])) . "' ,reference_link =  '" . $data[ 'reference_link' ] . "',reference_file = '" . $data[ 'filename' ] . "',file_update_status = '" . $data[ 'file_update_status' ] . "', user_id = '".$user_id."', added_date = '".$date."'" );
        //~ return $this->db->insert_id();
    //~ }
		
	function addRecord($main_table, $data, $customer_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 {
                    $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 addReminderHistory( $data ,$id) {
		$user_id = $this->session->userdata('user_id');
		$date = date('Y-m-d H:i:s');
        $query = $this->db->query( "INSERT INTO  reminder_history SET ref_reminder_id = '" . $id . "',	start_time = '" . $data[ 'start_time' ] . "',stop_time = '" . $data[ 'stop_time' ] . "',total_minutes = '" . $data[ 'total_minutes' ] . "',details = '" . $data[ 'details' ] . "' ,reference_link =  '" . $data[ 'reference_link' ] . "',upload_file = '" . $data[ 'filename' ] . "' ,file_update_status = '" . $data[ 'file_update_status' ] . "', user_id = '".$user_id."', added_date = '".$date."'" );
        return $this->db->insert_id();
    }

//~ function updateReminder( $data ,$id) {
		//~ $user_id = $this->session->userdata('user_id');
        //~ $query = $this->db->query( "UPDATE  general_reminder SET general_reminder_details = '" . $data[ 'general_reminder_details' ] . "',	assigned_user_id = '" . $data[ 'assigned_user_id' ] . "',general_reminder_priority_id = '" . $data[ 'general_reminder_priority_id' ] . "',general_reminder_status_id = '" . $data[ 'general_reminder_status_id' ] . "', 	assigned_date = '" . date('Y-m-d',strtotime($data[ 'assigned_date' ])) . "',completed_date ='" . date('Y-m-d',strtotime($data[ 'completed_date' ])) . "' ,reference_link =  '" . $data[ 'reference_link' ] . "', user_id = '".$user_id."', file_update_status = '" . $data[ 'file_update_status' ] . "' WHERE general_reminder_id = '".$id."'" );
        //~ if(isset($data[ 'filename' ]) && !empty($data[ 'filename' ] )){
			//~ $query = $this->db->query( "UPDATE  general_reminder SET reference_file = '" . $data[ 'filename' ] . "' WHERE general_reminder_id = '".$id."'" );
		//~ }
        //~ return $id;
    //~ }
	
	function updateRecord($main_table, $data, $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) {
					$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 == 'website'){
						$new_data['website_domain_expiry_date'] = date("Y-m-d H:i:s", strtotime($value['website_domain_expiry_date']));
					}
					$this->db->insert($new_table, $new_data);
				}
			}
		}
		// Ends here
		return $last_id;
        
    }
    
    function getPriority() {
        $query = $this->db->query( "SELECT * FROM general_reminder_priority " );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
    }

//~ function removeReminder($id){
		//~ $this->db->query("DELETE FROM general_reminder WHERE general_reminder_id = '" . $id . "'");
	//~ }
	
	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 general_reminder_status_id = '".$status."' WHERE general_reminder_id = '" . $id . "'");

return $id;
	}

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Reminder_model1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation