1: | <?php
|
2: | namespace Opencart\Catalog\Model\Report;
|
3: | |
4: | |
5: | |
6: | |
7: |
|
8: | class Statistics extends \Opencart\System\Engine\Model {
|
9: | |
10: | |
11: | |
12: | |
13: |
|
14: | public function getStatistics(): array {
|
15: | $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "statistics`");
|
16: |
|
17: | return $query->rows;
|
18: | }
|
19: |
|
20: | |
21: | |
22: | |
23: | |
24: | |
25: | |
26: |
|
27: | public function getValue(string $code): float {
|
28: | $query = $this->db->query("SELECT `value` FROM `" . DB_PREFIX . "statistics` WHERE `code` = '" . $this->db->escape($code) . "'");
|
29: |
|
30: | if ($query->num_rows) {
|
31: | return $query->row['value'];
|
32: | } else {
|
33: | return 0;
|
34: | }
|
35: | }
|
36: |
|
37: | |
38: | |
39: | |
40: | |
41: | |
42: | |
43: | |
44: |
|
45: | public function addValue(string $code, float $value): void {
|
46: | $this->db->query("UPDATE `" . DB_PREFIX . "statistics` SET `value` = (`value` + '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
|
47: | }
|
48: |
|
49: | |
50: | |
51: | |
52: | |
53: | |
54: | |
55: | |
56: |
|
57: | public function removeValue(string $code, float $value): void {
|
58: | $this->db->query("UPDATE `" . DB_PREFIX . "statistics` SET `value` = (`value` - '" . (float)$value . "') WHERE `code` = '" . $this->db->escape($code) . "'");
|
59: | }
|
60: |
|
61: | |
62: | |
63: | |
64: | |
65: | |
66: | |
67: | |
68: |
|
69: | public function editValue(string $code, float $value): void {
|
70: | $this->db->query("UPDATE `" . DB_PREFIX . "statistics` SET `value` = '" . (float)$value . "' WHERE `code` = '" . $this->db->escape($code) . "'");
|
71: | }
|
72: | }
|
73: | |