shop.balmet.com

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

statistics.php (1089B)

      1 <?php
      2 class ModelReportStatistics extends Model {
      3 	public function getStatistics() {
      4 		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "statistics");
      5 
      6 		return $query->rows;
      7 	}
      8 	
      9 	public function getValue($code) {
     10 		$query = $this->db->query("SELECT value FROM " . DB_PREFIX . "statistics WHERE `code` = '" . $this->db->escape($code) . "'");
     11 
     12 		if ($query->num_rows) {
     13 			return $query->row['value'];
     14 		} else {
     15 			return null;	
     16 		}
     17 	}
     18 	
     19 	public function addValue($code, $value) {
     20 		$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` + '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
     21 	}
     22 	
     23 	public function editValue($code, $value) {
     24 		$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = '" . (float)$value . "' WHERE `code` = '" . $this->db->escape($code) . "'");
     25 	}
     26 		
     27 	public function removeValue($code, $value) {
     28 		$this->db->query("UPDATE " . DB_PREFIX . "statistics SET `value` = (`value` - '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
     29 	}	
     30 }