1 files changed, 30 insertions, 0 deletions
diff --git a/public/admin/model/report/statistics.php b/public/admin/model/report/statistics.php
new file mode 100644
index 0000000..9fe77d1
--- /dev/null
+++ b/public/admin/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 editValue($code, $value) {
+		$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `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) . "'");
+	}	
+}