aboutsummaryrefslogtreecommitdiffstats
path: root/public/admin/model/extension/report/activity.php
blob: 94612f76b50e23d2e984b3294c23c25be0a717a5 (plain)
1
2
3
4
5
6
7
8
<?php
class ModelExtensionReportActivity extends Model {
	public function getActivities() {
		$query = $this->db->query("SELECT a.key, a.data, a.date_added FROM ((SELECT CONCAT('customer_', ca.key) AS `key`, ca.data, ca.date_added FROM `" . DB_PREFIX . "customer_activity` ca) UNION (SELECT CONCAT('affiliate_', aa.key) AS `key`, aa.data, aa.date_added FROM `" . DB_PREFIX . "affiliate_activity` aa)) a ORDER BY a.date_added DESC LIMIT 0,5");

		return $query->rows;
	}
}