Create New Item
×
Item Type
File
Folder
Item Name
×
Search file in folder and subfolders...
File Manager
/
admin
/
model
/
extension
/
dashboard
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php class ModelExtensionDashboardOnline extends Model { public function getTotalOnline($data = array()) { $sql = "SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "customer_online` co LEFT JOIN " . DB_PREFIX . "customer c ON (co.customer_id = c.customer_id)"; $implode = array(); if (!empty($data['filter_ip'])) { $implode[] = "co.ip LIKE '" . $this->db->escape($data['filter_ip']) . "'"; } if (!empty($data['filter_customer'])) { $implode[] = "co.customer_id > 0 AND CONCAT(c.firstname, ' ', c.lastname) LIKE '" . $this->db->escape($data['filter_customer']) . "'"; } if ($implode) { $sql .= " WHERE " . implode(" AND ", $implode); } $query = $this->db->query($sql); return $query->row['total']; } }