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

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Event_model.php

<?php
Class Event_model extends CI_Model {
    function addEvent($main_table, $data, $member_id = 0)
    {	
    	unset($data['main']['save']);
		unset($data['main']['savecontinue']);
       $profile_img = '';
		
		if(isset($data['photo_image'])){
			$photo_image = $data['photo_image'];
		}
		
        
        $data = $data['main'];
  
        $user_id           = $this->session->userdata( SESSION_LOGIN . 'user_id');
        $ref_user_group_id = $this->session->userdata( SESSION_LOGIN . 'ref_user_group_id');
        $date              = date('Y-m-d H:i:s');
       $profile_image = '';
        
			//exit;
        foreach ($data as $key => $value) {
            if ($this->Common_model->startsWith($key, 'tbl_')) {
                $table_new         = str_replace('tbl_', '', $key);
                $data1[$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;
                }
            }
        }
        unset($main_data['old_photo_image']);
        // print_r($main_table."--".$main_data);exit;
        $this->db->insert($main_table, $main_data);
        // print_r($this->db->last_query());
        $last_id = $this->db->insert_id();
        // echo "<pre>"; 
    //    print_r($data1);
        if (isset($data1) && !empty($data1)) {
            foreach ($data1 as $key => $value) { // Loop For each table
                $new_table = $key;
                // print_r($new_table);die();
                 $i         = 0;
                foreach ($value as $key => $val) {
                        $val['ref_user_id']   = $user_id;
                        $val['added_date']    = $date;
                        $val['ref_event_id'] = $last_id;
                        if ($new_table == 'user') {
                            $val['ref_user_group_id'] = '18';
                            $val['status']            = '1';
                            $val['password']          = md5($value[1]['password']);
                        }
                        $new_data = $val;
                        
                         if ($new_table == 'tour_rates_dates_note' || $new_table == 'tour_rates_dates')
                         {
							foreach ($val as $key1 => $val1) {
								if (strpos($key1, '_date') !== false) {
									if($key1 == 'tour_rates_dates_batch_from_date'){
										$new_data['tour_rates_dates_batch_from_date'] = date("Y-m-d H:i:s", strtotime($val['tour_rates_dates_batch_from_date']));
									}elseif($key1 == 'tour_rates_dates_batch_to_date') {
										$new_data['tour_rates_dates_batch_to_date'] = date("Y-m-d H:i:s", strtotime($val['tour_rates_dates_batch_to_date']));
									}
									
								}
							}
							
                        
						}else {
							foreach ($val as $key1 => $val1) {
							   if (strpos($key1, '_date') !== false) {
									$date_field     = date("Y-m-d H:i:s", strtotime($val[$key1]));
									$new_data[$key1] = $date_field;
								} 
								
							}
						}
                        if ($new_table == 'event_gallery') {
                        	// print_r($new_table."--".$new_data);
                        	
                        	// print_r($val);exit;
							$photo_img = '';
							if(isset($photo_image['name'][$i]) && !empty($photo_image['name'][$i])){
								$photo_img = $this->Common_model->upload_file($photo_image['name'][$i],$photo_image['tmp_name'][$i],'event_image',$val['ref_event_id']);
							}
                            $new_data['image_link'] = $photo_img;
                        }
                       
						///echo "<pre>";
						// print_r($new_data);exit;
						
						$this->db->insert($new_table, $new_data);
						$i++;

// print_r('table name',$new_table);
                        // print_r($this->db->last_query());
                    }
                  
            }
        }
        return $last_id;
    }
    function updateEvent($main_table, $data, $id)
    {
    // print_r($data);exit;	
     	unset($data['main']['save']);
		unset($data['main']['savecontinue']);

//       if(isset($data['tour_image'])){
		// 	$tour_img = '';
		// 	$tour_image = $data['tour_image'];
		// 	if(!empty($tour_image['name'])){
		// 		$tour_img = $this->Common_model->upload_file($tour_image['name'],$tour_image['tmp_name'],'tour');
		// 	}
		// }
		if(isset($data['itinerary_image'])){
			$itinerary_image = $data['itinerary_image'];
		}
		if(isset($data['photo_image'])){
			$photo_image = $data['photo_image'];
		}
        
        $data             = $data['main'];
        if(isset($data['old_tour_image'])){
			$old_tour_image = $data['old_tour_image'];
		}
		if(isset($data['old_photo_image'])){
			$old_photo_image = $data['old_photo_image'];
		}
			
       if(isset($data['old_itinerary_image'])){
			$old_itinerary_image = $data['old_itinerary_image'];
		}
        unset($data['old_tour_image']);
        unset($data['old_photo_image']);
        unset($data['old_itinerary_image']);
        
/*
        echo $tour_img;
         echo "<pre>";
         print_r($data);
          echo"</pre>";
			exit;
*/
        
        $user_id = $this->session->userdata( SESSION_LOGIN . 'user_id');
        $date    = date('Y-m-d H:i:s');
        
        // Backup Record before update 
        $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 || strpos($key, '_dob') !== false) {
                //if ($val != '00-00-0000 00:00:00' && $val != '') {
                    $date_field               = date("Y-m-d", strtotime($val));
                    $audit_record_final[$key] = $date_field;
               // }
            }
        }
        //$audit_record_final['transaction_id'] = $id;
        //$this->addRecord($main_table, $audit_record_final, $id);
        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 || strpos($key, '_dob') !== false) {          
				  $date_field      = date("Y-m-d", 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;
                    if(!empty($tour_img)){
						//$main_data['tour_image'] = $tour_img;
					}elseif(!empty($old_tour_image)){
						//$main_data['tour_image'] = $old_tour_image;
					}else{
						//$main_data['tour_image'] = '';
					}
                }
            }
        }
   
        if(isset($main_data)){
			$this->db->where($main_table . '_id', $id);
			$this->db->update($main_table, $main_data);
		}
		
        if(isset($sub_table_data) && !empty($sub_table_data)) {
            foreach ($sub_table_data as $key => $value1) {
                //if($key != 'tour_group'){
					$this->db->where('ref_' . $main_table . '_id', $id);
					$this->db->update($key, array(
						'delete_status' => 1
					));
				//}
                $new_table = $key;
                $j=0;
                foreach ($value1 as $key => $value) {
					
		    // if(isset($value['ref_status_id']) && !empty($value['ref_status_id'])){
			   //  $value['ref_status_id'] = '1';
		    // }else {
			   //  $value['ref_status_id'] = '2';
		    // }
					
                    $value['ref_' . $main_table . '_id'] = $id;
                    $value['ref_user_id']                = $user_id;
                    $value['added_date']                 = $date;
                    $new_data                            = $value;
                    
                  // exit;        
if ($new_table == 'tour_group') {
foreach ($value as $key1 => $val1) {
if (strpos($key1, '_date') !== false) {
    
    if($key1 == 'tour_group_from_date'){
	    $new_data['tour_group_from_date'] = date("Y-m-d H:i:s", strtotime($value['tour_group_from_date']));
    }
    if($key1 == 'tour_group_to_date') {
	    $new_data['tour_group_to_date'] = date("Y-m-d H:i:s", strtotime($value['tour_group_to_date']));
    }
}

}
							
                        
}else {
	foreach ($value as $key1 => $val1) {
	   if (strpos($key1, '_date') !== false) {
			$date_field     = date("Y-m-d H:i:s", strtotime($value[$key1]));
			$new_data[$key1] = $date_field;
		} 	
	}
}
					
// 					if ($new_table == 'tour_itinerary') {
// if(isset($itinerary_image['name'][$j]) && !empty($itinerary_image['name'][$j])){
// 	$itinerary_img = '';
// 	$itinerary_img = $this->Common_model->upload_file($itinerary_image['name'][$j],$itinerary_image['tmp_name'][$j],'itinerary');
// 	$new_data['tour_itinerary_image'] = $itinerary_img;
// }elseif(!empty($old_itinerary_image[$j])){
// 	$new_data['tour_itinerary_image'] = $old_itinerary_image[$j];
	
// }else{
// 	$new_data['tour_itinerary_image'] = '';
// } 
// }

if ($new_table == 'event_gallery')
{
	// print_r("jan");exit;
if(isset($photo_image['name'][$j]) && !empty($photo_image['name'][$j])){
	// print_r($photo_image['name'][$j]);exit;
	$photo_img = '';
	$photo_img = $this->Common_model->upload_file($photo_image['name'][$j],$photo_image['tmp_name'][$j],'tour_photos');
	$new_data['image_link'] = $photo_img;
}elseif(!empty($old_photo_image[$j])){
	$new_data['image_link'] = $old_photo_image[$j];
}else{
	$new_data['image_link'] = ' ';
} 
}
					
/*
					echo "<pre>";
                    print_r($new_data);
                     echo"</pre>";
*/
                   
if ($new_table == 'tour_group') {
	    
	if(isset($new_data['tour_group_id']) && !empty($new_data['tour_group_id'])){
		$new_id = $new_data['tour_group_id'];
		unset($new_data['tour_group_id']);
		
		$this->db->where('tour_group_id', $new_id);
		$new_data['delete_status']= 0;
		$this->db->update($new_table, $new_data);
	}else{
		$this->db->insert($new_table, $new_data);	
	}

}else{
	$this->db->insert($new_table, $new_data);
}

$j++;
                }
            }
        }
       // exit;
        return $id;
    }
    function addRecord($main_table, $data, $event_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['transaction_id']  = $event_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['added_date']                 = $date;
                    $new_data                            = $value;
                    $this->db->insert($new_table, $new_data);
                }die();
            }
        }
        return $last_id;
    }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Event_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation