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/crm_2020_11_03/application/modules/bugfix/models

Free Space:

4.03 TB

🔧 Quick Actions

✏️ Editing: Bugfix_model.php

<?php
Class Bugfix_model extends CI_Model
{
    private $menu_html;
    public function __construct()
    {
        parent::__construct();
    }
       
    function updateRecord($main_table, $data, $id ) { 
		
        $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;
                }elseif (strpos($key, '_time') !== false) {
                    $date_field      = date("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;
                }
            }
        }
/*
        
		 echo "<pre>";
		 print_r($data);
		 echo "</pre>";
		 exit;
*/
        
        //update Current record 
        $this->db->where($main_table.'_id', $id);
        $this->db->update($main_table, $main_data);
		//exit;
		// Sub table data insertion - Mobile number and Email ids
		if(isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $value1) {
				$this->db->where('ref_'.$main_table.'_id', $id);
				$this->db->update($key, array('delete_status' => 1));
				$new_table = $key;
				foreach ($value1 as $key => $value) {
					$value['ref_'.$main_table.'_id'] = $id;
					$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;
        
    }
        
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Bugfix_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation