- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
<?php
class ModelExtensionModuleAridiusfastorder extends Model {
public function deleteOrder($order_id) {
$this->db->query("DELETE FROM " . DB_PREFIX . "aridiusfastorder WHERE order_id = '" . (int) $order_id . "'");
}
public function editOrder($order_id, $data) {
$this->db->query("UPDATE `" . DB_PREFIX . "aridiusfastorder` SET firstname = '" . $this->db->escape($data['firstname']) . "',status = '" . $this->db->escape($data['status']) . "',email = '" . $this->db->escape($data['email']) . "',comment_manager = '" . $this->db->escape($data['comment_manager']) . "',contact = '" . $data['contact'] . "' WHERE order_id = '" . (int)$order_id . "'");
}
public function getOrder($order_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "aridiusfastorder WHERE order_id = '" . (int)$order_id . "'");
return $query->row;
}
public function getOrders($data = array()) {
$sql = "SELECT * FROM " . DB_PREFIX . "aridiusfastorder";
if (isset($data['filter_order_id']) && !is_null($data['filter_order_id'])) {
$sql .= " WHERE order_id = '" . (int) $data['filter_order_id'] . "'";
} else {
$sql .= " WHERE order_id > '0'";
}
if (!empty($data['filter_contact'])) {
$sql .= " AND contact LIKE '%" . $this->db->escape($data['filter_contact']) . "%'";
}
if (!empty($data['filter_email'])) {
$sql .= " AND email LIKE '%" . $this->db->escape($data['filter_email']) . "%'";
}
if (!empty($data['filter_status'])) {
$sql .= " AND status LIKE '%" . $this->db->escape($data['filter_status']) . "%'";
}
if (!empty($data['filter_firstname'])) {
$sql .= " AND firstname LIKE '%" . $this->db->escape($data['filter_firstname']) . "%'";
}
if (!empty($data['filter_product_name'])) {
$sql .= " AND product_name LIKE '%" . $this->db->escape($data['filter_product_name']) . "%'";
}
if (!empty($data['filter_date_added'])) {
$sql .= " AND DATE(date_added) = DATE('" . $this->db->escape($data['filter_date_added']) . "')";
}
if (!empty($data['filter_total'])) {
$sql .= " AND total = '" . (float) $data['filter_total'] . "'";
}
$sort_data = array(
'order_id',
'status',
'email',
'contact',
'firstname',
'product_name',
'total',
'date_added'
);
if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
$sql .= " ORDER BY " . $data['sort'];
} else {
$sql .= " ORDER BY order_id";
}
if (isset($data['order']) && ($data['order'] == 'DESC')) {
$sql .= " DESC";
} else {
$sql .= " ASC";
}
if (isset($data['start']) || isset($data['limit'])) {
if ($data['start'] < 0) {
$data['start'] = 0;
}
if ($data['limit'] < 1) {
$data['limit'] = 20;
}
$sql .= " LIMIT " . (int) $data['start'] . "," . (int) $data['limit'];
}
$query = $this->db->query($sql);
return $query->rows;
}
public function getTotalOrders() {