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/controllers

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Reminder.php

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Reminder extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model(array(
            'Reminder_model'
        ));
        $this->load->helper(array(
            'form'
        ));
        $session_data       = $this->session->userdata(SESSION_LOGIN . 'logged_in');
        $data['username']   = $session_data['username'];
        $data['permission'] = $this->session->userdata(SESSION_LOGIN . 'user_permission');
         $data['status']         = $this->Common_model->getDropdownlist('status');
        $data['priority']       = $this->Common_model->getDropdownlist('priority');
        $data['user']       = $this->Common_model->getDropdownlist('user');
        //$data['user']      = $this->Reminder_model->getUsers();
        $data['title'] = 'Reminder';
        $this->load->view('common/header', $data);
    }
    function hasPermission($page)
    {
        $res_permission = $this->session->userdata(SESSION_LOGIN . 'user_permission');
        if ($res_permission && !empty($res_permission)) {
            if (!in_array($page, $res_permission)) {
                redirect('access_denied', 'refresh');
            }
        } else {
            redirect('home');
        }
    }
    
    function index(){
		$this->getlist();
	}
	
    function getlist()
    {
        $this->hasPermission('reminder_view');
        $filter_data = '';
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $filter_data = $this->input->post();
            $reset_data  = $this->input->post('reset');
            if (isset($reset_data)) {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
            } else {
                $this->session->set_userdata('filter_data', $filter_data);
            }
        } else {
            $session_filter_data = $this->session->userdata('filter_data');
            if (isset($session_filter_data)) {
                $filter_data = $session_filter_data;
            } else {
                $filter_data = '';
            }
        }
        $data['filter_data'] = $filter_data;
        $segment_3 = $this->uri->segment(3);
        $segment_4 = $this->uri->segment(4);
        $segment_5 = $this->uri->segment(5);
        // If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'general_reminder_id';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        
        $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
        $filter_query_data      = array();
        $data['limit'] = '';
        if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
            $start                     = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit'] = '?limit='.$_REQUEST['limit'];
        }else{
            $start                     = (($page - 1) * RPP);
        }
        
        $data['start']             = $start; // Generate SNO in result table based on page number
        $filter_query_data['start']             = $start;
        $filter_query_data['sort']              = $sort;
        $filter_query_data['order']             = $order;
        
        
        $table                     = array();
        $table['tbl_main']         = 'general_reminder';
        $data['mainlist_count']    = $this->Common_model->getListCount($table, $filter_data);
        $lead_list = '';
        $data['mainlist']             = $this->Common_model->getList($table, $filter_query_data, $filter_data);

//~ echo '<pre>';
        //~ print_r($data['mainlist'] );
        //~ exit;
		///$data['mainlist']          = $lead_list;
        $data['tablefields']      = $this->Common_model->getTableFields('general_reminder');
        $data['operations']        = $this->Common_model->getFilterOperation();
        $data['init_listing_page'] = 'reminder/getlist/';
        $data['listing_page']      = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
        $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
       
        $data['filter_action'] = site_url('reminder/getlist');
        $this->load->view('common/menu');
        $this->load->view('reminder/reminder_list_view', $data);
        $this->load->view('common/footer');
    }
    
    
    function export_reminder_excel()
    {
        $this->hasPermission('reminder_view');
        $lead_id = $this->uri->segment(3);
		$filter_data         = '';
		$session_filter_data = $this->session->userdata('filter_data');
		if (isset($session_filter_data)) {
			$filter_data = $session_filter_data;
		} else {
			$filter_data = '';
		}
		$data          = array();
		$data['sort']  = 'general_reminder_id';
		$data['order'] = 'ASC';
		$table['tbl_main']         = 'general_reminder';
	   
		$mainlist      = $this->Common_model->getList($table, $data, $filter_data);
       
        
        foreach ($mainlist as $key => $val) {
			$user_name = '';
			$user = $this->Common_model->getDetails('user','user_id',$val->assigned_user_id);
			if(isset($user[0]->user_name) && !empty($user[0]->user_name)){
				$user_name = $user[0]->full_name;
			}				
           
			$file_update_status = '';
			if($val->file_update_status == '1'){
				$file_update_status ='To Update';
			}else if($val->file_update_status == '2'){
				$file_update_status = 'Updated';
			}
											
            $export_list[] = array(
				//$val->lead_call_id,
				$val->general_reminder_details,
				$user_name,
				$this->Common_model->getDateTimeFormat($val->assigned_date),
				$this->Common_model->getDateTimeFormat($val->completed_date),
				$val->priority_name,
				$val->status_name,
				$val->reference_link,
				$val->reference_file
				
			
            );
        }
        $export        = array();
        $export_column = array(
           // 'Lead Call Id',
            'Reminder',
            'Assigned To',
            'Assign Date',
            'Due Date',
            'Priority',
            'Status',
            'Reference Link',
            'Reference File'            
        );
        $export[0]     = $export_column;
        foreach ($export_list as $export_row) {
            $export[] = $export_row;
        }
        $this->Common_model->generateExcel($export,'Reminder_List_' . date('d-m-Y_H:i:s'));
    }
    
    function export_reminder_pdf(){
		$this->hasPermission('reminder_view');
        $lead_id = $this->uri->segment(3);
		$filter_data         = '';
		$session_filter_data = $this->session->userdata('filter_data');
		if (isset($session_filter_data)) {
			$filter_data = $session_filter_data;
		} else {
			$filter_data = '';
		}
		$data          = array();
		$data['sort']  = 'general_reminder_id';
		$data['order'] = 'ASC';
		$table['tbl_main']         = 'general_reminder';
	   
		$mainlist      = $this->Common_model->getList($table, $data, $filter_data);
		
        
        $data['title'] = 'Reminder List';
        
        // Row Header
        $data['row_header'] = array();
        $data['row_header'][] = array(
			'name'		=> 'S No',
			'width'		=> '8%',
			'align'		=> 'center'
        );
        
        $data['row_header'][] = array(
			'name'		=> 'Reminder',
			'width'		=> '27%',
			'align'		=> 'left'
        );
        
         $data['row_header'][] = array(
			'name'		=> 'Assigned To',
			'width'		=> '17%',
			'align'		=> 'left'
        );
        
         $data['row_header'][] = array(
			'name'		=> 'Assign Date',
			'width'		=> '13%',
			'align'		=> 'left'
        );
        
         $data['row_header'][] = array(
			'name'		=> 'Due Date',
			'width'		=> '13%',
			'align'		=> 'left'
        );
        
        $data['row_header'][] = array(
			'name'		=> 'Priority',
			'width'		=> '10%',
			'align'		=> 'left'
        );
        
        $data['row_header'][] = array(
			'name'		=> 'Status',
			'width'		=> '10%',
			'align'		=> 'left'
        );
               
        // Row Data
        $data['row_data'] = array();
        if(isset($mainlist) && !empty($mainlist)){
			$i = 1;
			foreach($mainlist as $key => $val){
				$user_name = '';
				$user = $this->Common_model->getDetails('user','user_id',$val->assigned_user_id);
				if(isset($user[0]->user_name) && !empty($user[0]->user_name)){
					$user_name = $user[0]->full_name;
				}
				 $data['row_data'][] = array(
					$i,
					$val->general_reminder_details,
					$user_name,
					$this->Common_model->getDateFormat($val->assigned_date),
					$this->Common_model->getDateFormat($val->completed_date),
					$val->priority_name,
					$val->status_name
				);
			$i++;
			}	
		}
       
        $this->load->library('parser');
        
         $header_html = $this->parser->parse('template/pdf/pdf_header', $data);
        $footer_html = $this->parser->parse('template/pdf/pdf_footer', $data);
        $html        = $this->parser->parse('template/pdf/list_tmp', $data);
        $file_name = 'Reminder_list_' . date('d-m-Y_H:i:s') . '.pdf';
        $this->Common_model->exportPdf($header_html, $footer_html, $html, $file_name, 'P', 'I');
	}
    
    
    function pending()
    {
        $this->hasPermission('reminder_view');
        $filter_data = '';
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $filter_data = $this->input->post();
            $reset_data  = $this->input->post('reset');
            if (isset($reset_data)) {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
            } else {
                $this->session->set_userdata('filter_data', $filter_data);
            }
        } else {
            $session_filter_data = $this->session->userdata('filter_data');
            if (isset($session_filter_data)) {
                $filter_data = $session_filter_data;
            } else {
                $filter_data = '';
            }
        }
        $data['filter_data'] = $filter_data;
        $segment_3 = $this->uri->segment(3);
        $segment_4 = $this->uri->segment(4);
        $segment_5 = $this->uri->segment(5);
        // If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'general_reminder_id';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        
        $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
        $filter_query_data      = array();
        $data['limit'] = '';
        if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
            $start                     = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit'] = '?limit='.$_REQUEST['limit'];
        }else{
            $start                     = (($page - 1) * RPP);
        }
        
        $data['start']             = $start; // Generate SNO in result table based on page number
        $filter_query_data['start']             = $start;
        $filter_query_data['sort']              = $sort;
        $filter_query_data['order']             = $order;
        
        
        $table                     = array();
        $table['tbl_main']         = 'general_reminder';
        $data['mainlist_count']    = $this->Reminder_model->getListCount($table, $filter_data,'','1');
        $lead_list = '';
        $data['mainlist']             = $this->Reminder_model->getList($table, $filter_query_data, $filter_data,'','1');

///$data['mainlist']          = $lead_list;
        $data['tablefields']      = $this->Common_model->getTableFields('general_reminder');
        $data['operations']        = $this->Common_model->getFilterOperation();
        $data['init_listing_page'] = 'reminder/getlist/';
        $data['listing_page']      = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
        $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
        
        $data['filter_action'] = site_url('reminder/pending');
        $this->load->view('common/menu');
        $this->load->view('reminder/reminder_list_view', $data);
        $this->load->view('common/footer');
    }
    
    
    function processing()
    {
        $this->hasPermission('reminder_view');
        $filter_data = '';
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $filter_data = $this->input->post();
            $reset_data  = $this->input->post('reset');
            if (isset($reset_data)) {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
            } else {
                $this->session->set_userdata('filter_data', $filter_data);
            }
        } else {
            $session_filter_data = $this->session->userdata('filter_data');
            if (isset($session_filter_data)) {
                $filter_data = $session_filter_data;
            } else {
                $filter_data = '';
            }
        }
        $data['filter_data'] = $filter_data;
        $segment_3 = $this->uri->segment(3);
        $segment_4 = $this->uri->segment(4);
        $segment_5 = $this->uri->segment(5);
        // If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'general_reminder_id';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        
        $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
        $filter_query_data      = array();
        $data['limit'] = '';
        if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
            $start                     = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit'] = '?limit='.$_REQUEST['limit'];
        }else{
            $start                     = (($page - 1) * RPP);
        }
        
        $data['start']             = $start; // Generate SNO in result table based on page number
        $filter_query_data['start']             = $start;
        $filter_query_data['sort']              = $sort;
        $filter_query_data['order']             = $order;
        
        
        $table                     = array();
        $table['tbl_main']         = 'general_reminder';
        $data['mainlist_count']    = $this->Reminder_model->getListCount($table, $filter_data,'','2');
        $lead_list = '';
        $data['mainlist']             = $this->Reminder_model->getList($table, $filter_query_data, $filter_data,'','2');

///$data['mainlist']          = $lead_list;
        $data['tablefields']      = $this->Common_model->getTableFields('general_reminder');
        $data['operations']        = $this->Common_model->getFilterOperation();
        $data['init_listing_page'] = 'reminder/getlist/';
        $data['listing_page']      = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
        $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
       
        $data['filter_action'] = site_url('reminder/processing');
        $this->load->view('common/menu');
        $this->load->view('reminder/reminder_list_view', $data);
        $this->load->view('common/footer');
    }
    
    
    function completed()
    {
        $this->hasPermission('reminder_view');
        $filter_data = '';
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $filter_data = $this->input->post();
            $reset_data  = $this->input->post('reset');
            if (isset($reset_data)) {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
            } else {
                $this->session->set_userdata('filter_data', $filter_data);
            }
        } else {
            $session_filter_data = $this->session->userdata('filter_data');
            if (isset($session_filter_data)) {
                $filter_data = $session_filter_data;
            } else {
                $filter_data = '';
            }
        }
        $data['filter_data'] = $filter_data;
        $segment_3 = $this->uri->segment(3);
        $segment_4 = $this->uri->segment(4);
        $segment_5 = $this->uri->segment(5);
        // If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'general_reminder_id';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        
        $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
        $filter_query_data      = array();
        $data['limit'] = '';
        if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
            $start                     = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit'] = '?limit='.$_REQUEST['limit'];
        }else{
            $start                     = (($page - 1) * RPP);
        }
        
        $data['start']             = $start; // Generate SNO in result table based on page number
        $filter_query_data['start']             = $start;
        $filter_query_data['sort']              = $sort;
        $filter_query_data['order']             = $order;
        
        
        $table                     = array();
        $table['tbl_main']         = 'general_reminder';
        $data['mainlist_count']    = $this->Reminder_model->getListCount($table, $filter_data,'','3');
        $lead_list = '';
        $data['mainlist']             = $this->Reminder_model->getList($table, $filter_query_data, $filter_data,'','3');

///$data['mainlist']          = $lead_list;
        $data['tablefields']      = $this->Common_model->getTableFields('general_reminder');
        $data['operations']        = $this->Common_model->getFilterOperation();
        $data['init_listing_page'] = 'reminder/getlist/';
        $data['listing_page']      = $data['init_listing_page'] . $page . '/';
		//$data['page'] = $page;
        $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
       
        $data['filter_action'] = site_url('reminder/completed');
        $this->load->view('common/menu');
        $this->load->view('reminder/reminder_list_view', $data);
        $this->load->view('common/footer');
    }
    
    
    function getForm()
    {
/*
        $data['user']     = $this->Reminder_model->getUsers();
        $data['status']   = $this->Reminder_model->getStatus();
        $data['priority'] = $this->Reminder_model->getPriority();
*/
        $this->load->view('common/menu');
        $this->load->view('reminder/reminder_form_view');
        $this->load->view('common/footer');
    }
    function add()
    {
        $this->hasPermission('reminder_add');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $data = array();
            $data = $this->input->post();
            // Begin Transaction
			$this->Common_model->TxnBegin();
            if (!isset($data['file_update_status'])) {
                $data['file_update_status'] = '';
            }
            if (!empty($_FILES["reference_file"]['name'])) {
                $config['upload_path']   = './uploads/references';
                $config['allowed_types'] = '*';
                $config['max_size']      = '1000';
                $new_name                = date('d-m-Y') . '_' . $_FILES["reference_file"]['name'];
                $config['file_name']     = $new_name;
                $this->load->library('upload', $config);
                if (!$this->upload->do_upload('reference_file')) {
                    $upload_error = array(
                        'error' => $this->upload->display_errors()
                    );
                    $this->load->view('reminder_form_view', $upload_error);
                } else {
                    $upload_data      = $this->upload->data();
                    $file_name        = $upload_data['file_name'];
                    $data['reference_file'] = $file_name;
                }
            } else {
                $data['reference_file'] = '';
            }
            $data['reference_link'] = str_replace('https://','',$data['reference_link']);
            $data['reference_link'] = str_replace('http://','',$data['reference_link']);
            
            $res = $this->Reminder_model->addRecord('general_reminder',$data);
            $this->Common_model->addUserActivity('reminder',$res); // Record User Activity

if($res){
				$this->Common_model->TxnCommit();
				$this->Common_model->addUserActivity('reminder',$res); // Record User Activity
                $_SESSION['success_msg'] = 'Reminder successfully added ...';
            }else{
                $this->Common_model->TxnRollBack();
                $_SESSION['error_msg'] = 'Error occurred please try again...';
            }            
            redirect('reminder');
      
        } else {
            $this->getForm();
        }
    }
    function edit()
    {
        $this->hasPermission('reminder_edit');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {

$id                      = $this->uri->segment(3);
             $data = array();
            $data = $this->input->post();
            $redirect_to = $data['redirect_to'];
            unset($data['redirect_to']);
            if (!isset($data['file_update_status'])) {
                $data['file_update_status'] = '';
            }
            if (!empty($_FILES["reference_file"]['name'])) {
                $config['upload_path']   = './uploads/references';
                $config['allowed_types'] = '*';
                $config['max_size']      = '';
                $new_name                = date('d-m-Y') . '_' . $_FILES["reference_file"]['name'];
                $config['file_name']     = $new_name;
                $this->load->library('upload', $config);
                if (!$this->upload->do_upload('reference_file')) {
                    $upload_error = array(
                        'error' => $this->upload->display_errors()
                    );
                    $this->load->view('reminder_form_view', $upload_error);
                } else {
                    $upload_data      = $this->upload->data();
                    $file_name        = $upload_data['file_name'];
                    $data['reference_file'] = $file_name;
                }
            } else {
                $data['reference_file'] = '';
            }
            $res = $this->Reminder_model->updateRecord('general_reminder',$data, $id);
           
            if($res){
				 $this->Common_model->TxnCommit();
				 $this->Common_model->addUserActivity('reminder_edit',$res); // Record User Activity
                $_SESSION['success_msg'] = 'Reminder successfully updated ...';
            }else{
                $this->Common_model->TxnRollBack();
                $_SESSION['error_msg'] = 'Error occurred please try again...';
            } 
            redirect('reminder');    
            
           
        } else {
            $id                = $this->uri->segment(3);
           // $data['reminder']  = $this->Reminder_model->getReminder($id);
            $data['reminder'] = $this->Common_model->getDetails('general_reminder','general_reminder_id',$id);

$this->load->view('common/menu');
            $this->load->view('reminder/reminder_edit_view', $data);
            $this->load->view('common/footer');
        }
    }
    function reply()
    {
        $this->hasPermission('reminder_edit');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $id               = $this->uri->segment(3);
            $data             = array();
            $data['filename'] = '';
            // Begin Transaction
			$this->Common_model->TxnBegin();
            $data             = $this->input->post();
            $reference_file = '';
            if (!empty($_FILES["reference_file"]['name'])) {
                $config['upload_path']   = './uploads/references';
                $config['allowed_types'] = '*';
                $config['max_size']      = '';
                $new_name                = date('d-m-Y') . '_' . $_FILES["reference_file"]['name'];
                $config['file_name']     = $new_name;
                $this->load->library('upload', $config);
                if (!$this->upload->do_upload('reference_file')) {
                    $upload_error = array(
                        'error' => $this->upload->display_errors()
                    );
                   
                    $this->load->view('reminder_reply_form_view', $upload_error);
                } else {
                    $upload_data      = $this->upload->data();
                    $file_name        = $upload_data['file_name'];
                    $reference_file = $file_name;
                }
            } 
            $data['reference_file'] = $reference_file;
            $data['reference_link'] = str_replace('https://','',$data['reference_link']);
            $data['reference_link'] = str_replace('http://','',$data['reference_link']);
            
            $data['ref_general_reminder_id'] = $id;
            
/*
            $_SESSION['time_end']   = date("Y-m-d H:i:s");
            $et                    = date('H:i:s', strtotime($_SESSION['time_end']));
            $st                    = date('H:i:s', strtotime($_SESSION['time_start']));
            $total_time            = (strtotime($et) - strtotime($st)) / 60;
            $total                 = explode('.', $total_time);
            $data['start_time']    = $_SESSION['time_start'];
            $data['stop_time']     = $_SESSION['time_end'];
            $data['total_minutes'] = $total[0];
*/
            $res                   = $this->Common_model->addRecord('reminder_history',$data);
          
            if($res){
				$this->Common_model->TxnCommit();
                $_SESSION['success_msg'] = 'Record successfully added ...';
            }else{
                $this->Common_model->TxnRollBack();
                $_SESSION['error_msg'] = 'Error occurred please try again...';
            }            
            redirect('reminder/view/'.$id);
            
            
        } else {
            $data['id'] = $this->uri->segment(3);
            $this->load->view('common/menu');
            $this->load->view('reminder/reminder_reply_form_view', $data);
            $this->load->view('common/footer');
        }
    }
    function delete()
    {
        $this->hasPermission('reminder_delete');
        // Begin Transaction
		$this->Common_model->TxnBegin();
        $delete_id = $this->input->post('checkbox'); 
		if(!empty($delete_id)){
			 foreach($delete_id as $key => $id){
				$res = $this->Common_model->removeRecord('general_reminder','general_reminder_id',$id);
			 }
		}
		if($res){
			$this->Common_model->TxnCommit();
			$this->Common_model->addUserActivity('reminder',$res); // Record User Activity
			$_SESSION['success_msg'] = 'Reminder successfully deleted ...';
		}else{
			$this->Common_model->TxnRollBack();
			$_SESSION['error_msg'] = 'Error occurred please try again...';
		}            
        redirect('reminder');
    }
    function view()
    {
        $this->hasPermission('reminder_view');
        $id              = $this->uri->segment(3);
        $data['reminder'] = $this->Common_model->getDetails('general_reminder','general_reminder_id',$id);
        $data['history'] = $this->Common_model->getDetails('reminder_history','ref_general_reminder_id',$id);
        
        $update_record = array();
        $update_record['view_status'] =	1;
        $this->Common_model->updateRecord('general_reminder',$update_record,$id);

$this->load->view('common/menu');
        $this->load->view('reminder/reminder_history_list', $data);
        $this->load->view('common/footer');
    }
    
    function calendarview(){
		$this->hasPermission('reminder_view');
		//$data['event_data'] = '';
			$filter_data = '';
			$where = '';
		 if ($this->input->server('REQUEST_METHOD') == 'POST') {
			 $filter_data = $this->input->post();
			 $from_date = date('Y-m-d',strtotime($filter_data['event_start_date_from']));
			 $to_date = date('Y-m-d',strtotime($filter_data['event_start_date_to']));
			 $where = " assigned_date BETWEEN '$from_date' AND '$to_date'";
		
		 }
		$res_reminder = $this->Common_model->getRecords('general_reminder',$where);
		
		$json = array();
		if(isset($res_reminder) && !empty($res_reminder)){
			foreach($res_reminder as $key => $val){
				$json[] = array(
					'id' => $val->general_reminder_id,
					'start' => $val->assigned_date,
					'end' => $val->completed_date,
					'title' => $val->general_reminder_details,
					'description' => $val->general_reminder_details,
					'link' => $val->reference_link,
					'event_link' => 'view/'.$val->general_reminder_id,
					'textColor' => '#fff',
                    'color' => '#1f91f3' 
					//'image' => base_url().str_replace('event/','event/thumb/',$val->event_image)
				);
			}
			$data['reminder'] = json_encode($json);
		}
		
		//~ echo '<pre>';
		//~ print_r($res_reminder);
		//~ print_r($data['reminder']);
		//~ echo '</pre>';
		//~ exit;

$this->load->view('common/menu');
		$this->load->view('reminder/calendar_view',$data);
        $this->load->view('common/footer');
	}
	
    function startTime()
    {
        $_SESSION['total_time']      = '';
        $id                          = $this->uri->segment(3);
        $_SESSION['start_time']      = '1';
        $_SESSION['start_time_date'] = date("Y,m,d,H,i,s");
        $_SESSION['time_start']      = date("Y-m-d H:i:s");
        redirect('reminder/reply/' . $id);
    }
    function endTime()
    {
        $id                     = $this->uri->segment(3);
        $_SESSION['start_time'] = '0';
        $_SESSION['end_time']   = '1';
        $_SESSION['time_end']   = date("Y-m-d H:i:s");
        $et                     = date('H:i:s', strtotime($_SESSION['time_end']));
        $st                     = date('H:i:s', strtotime($_SESSION['time_start']));
        $total_time             = (strtotime($et) - strtotime($st)) / 60;
        $total                  = explode('.', $total_time);
        $_SESSION['total_time'] = $total[0];
        redirect('reminder/reply/' . $id);
    }
	
	 
	 
    function changeStatus()
    {
        $status = $_POST['status'];
        $id     = $_POST['id'];
        $res    = $this->Reminder_model->changeReminderStatus($status, $id);
        if ($res) {
            $res = 'success';
        }
        echo json_encode($res);
        exit;
    }
    function changePriority()
    {
        $priority = $_POST['priority'];
        $id       = $_POST['id'];
        $res      = $this->Reminder_model->changeReminderPriority($priority, $id);
        if ($res) {
            $res = 'success';
        }
        echo json_encode($res);
        exit;
    }
}

//~ echo '<pre>';
//~ print_r($data['reminder']);
//~ echo '</pre>';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Reminder.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation