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/salemmobilexpress.com/public_html/admin/model/localisation

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: service_center.php

<?php
class ModelLocalisationServiceCenter extends Model {
	public function addServiceCenter($data) {
		$area_name = $data['ref_area_id'];
		$areaSql = "SELECT area_id FROM area WHERE area_name = '".$area_name."' AND ref_district_id = '".$data['ref_city_id']."'";
		$result = $this->db->query($areaSql);

if($result->row['area_id']){
			$data['ref_area_id'] = $result->row['area_id'];
		}else{
			$this->db->query("INSERT INTO area SET area_name = '" . $area_name . "', ref_district_id = '" . (int)$data['ref_city_id'] . "'");
			$data['ref_area_id'] = $this->db->getLastId();
		}

$sql = "INSERT INTO si_service_center SET 
			service_center_name = '" . $this->db->escape($data['service_center_name']) . "', 
			ref_manufacturer_id = '". (int)$data['ref_manufacturer_id']."',
			ref_country_id = '". (int)$data['ref_country_id']."',
			ref_zone_id = '". (int)$data['ref_zone_id']."',
			ref_city_id = '". (int)$data['ref_city_id']."',
			ref_area_id = '". (int)$data['ref_area_id']."',
			address = '" . $this->db->escape($data['address']) . "', 
			telephone = '" . $this->db->escape($data['telephone']) . "', 
			mobile = '" . $this->db->escape($data['mobile']) . "', 
			email_id = '" . $this->db->escape($data['email_id']) . "', 
			latitude = '" . $this->db->escape($data['latitude']) . "',
			longitude = '" . $this->db->escape($data['longitude']) . "',
			image = '" . $this->db->escape($data['image']) . "',
			open = '" . $this->db->escape($data['open']) . "',
			comment = '" . $this->db->escape($data['comment']) . "', 
			date_added = NOW()";
		$this->db->query($sql);
	}

public function editServiceCenter($service_center_id, $data) {
		$area_name = $data['ref_area_id'];
		$areaSql = "SELECT area_id FROM area WHERE area_name = '".$area_name."' AND ref_district_id = '".$data['ref_city_id']."'";
		$result = $this->db->query($areaSql);

$this->db->query("UPDATE si_service_center SET 
			service_center_name = '" . $this->db->escape($data['service_center_name']) . "', 
			ref_manufacturer_id = '". (int)$data['ref_manufacturer_id']."',
			ref_country_id = '". (int)$data['ref_country_id']."',
			ref_zone_id = '". (int)$data['ref_zone_id']."',
			ref_city_id = '". (int)$data['ref_city_id']."',
			ref_area_id = '". (int)$data['ref_area_id']."',
			address = '" . $this->db->escape($data['address']) . "', 
			telephone = '" . $this->db->escape($data['telephone']) . "', 
			mobile = '" . $this->db->escape($data['mobile']) . "', 
			email_id = '" . $this->db->escape($data['email_id']) . "', 
			latitude = '" . $this->db->escape($data['latitude']) . "',
			longitude = '" . $this->db->escape($data['longitude']) . "',
			image = '" . $this->db->escape($data['image']) . "',
			open = '" . $this->db->escape($data['open']) . "',
			comment = '" . $this->db->escape($data['comment']) . "' 
			WHERE service_center_id = '" . (int)$service_center_id . "'
			");
	}

public function deleteServiceCenter($service_center_id) {
		$this->db->query("DELETE FROM si_service_center WHERE service_center_id = " . (int)$service_center_id);
	}

public function getServiceCenter($service_center_id) {
		$query = $this->db->query("SELECT DISTINCT * FROM si_service_center WHERE service_center_id = '" . (int)$service_center_id . "'");

return $query->row;
	}

public function getServiceCenters($data = array()) {
		$sql = "SELECT service_center_id, service_center_name, address FROM si_service_center";

$sort_data = array(
			'service_center_name',
			'address',
		);

if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];
		} else {
			$sql .= " ORDER BY service_center_name";
		}

if (isset($data['order']) && ($data['order'] == 'DESC')) {
			$sql .= " DESC";
		} else {
			$sql .= " ASC";
		}

if (isset($data['start']) || isset($data['limit'])) {
			if ($data['start'] < 0) {
				$data['start'] = 0;
			}

if ($data['limit'] < 1) {
				$data['limit'] = 20;
			}

$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
		}

$query = $this->db->query($sql);

return $query->rows;
	}

public function getTotalServiceCenters() {
		$query = $this->db->query("SELECT COUNT(*) AS total FROM si_service_center");

return $query->row['total'];
	}

public function getAreaName($area_id) {
		$query = $this->db->query("SELECT area_name FROM area WHERE area_id = '".$area_id."'");
		
		return $query->row['area_name'];
	}
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: service_center.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation