aboutsummaryrefslogtreecommitdiffstats
path: root/public/catalog/model/report/statistics.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/catalog/model/report/statistics.php')
-rw-r--r--public/catalog/model/report/statistics.php30
1 files changed, 30 insertions, 0 deletions
diff --git a/public/catalog/model/report/statistics.php b/public/catalog/model/report/statistics.php
new file mode 100644
index 0000000..6d2c0df
--- /dev/null
+++ b/public/catalog/model/report/statistics.php
@@ -0,0 +1,30 @@
+<?php
+class ModelReportStatistics extends Model {
+ public function getStatistics() {
+ $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "statistics");
+
+ return $query->rows;
+ }
+
+ public function getValue($code) {
+ $query = $this->db->query("SELECT value FROM " . DB_PREFIX . "statistics WHERE `code` = '" . $this->db->escape($code) . "'");
+
+ if ($query->num_rows) {
+ return $query->row['value'];
+ } else {
+ return null;
+ }
+ }
+
+ public function addValue($code, $value) {
+ $this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` + '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
+ }
+
+ public function removeValue($code, $value) {
+ $this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` - '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
+ }
+
+ public function editValue($code, $value) {
+ $this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = '" . (float)$value . "' WHERE `code` = '" . $this->db->escape($code) . "'");
+ }
+} \ No newline at end of file