diff options
Diffstat (limited to 'public/catalog/model/report/statistics.php')
| -rw-r--r-- | public/catalog/model/report/statistics.php | 30 |
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 |