home/skymarketplace/public_html/models/Order.php 0000644 00000002605 15003700211 0016054 0 ustar 00 db = (new Database())->connect();
}
public function changeStatus($id) {
$stmt = $this->db->prepare("UPDATE orders SET status = 'changed' WHERE id = ?");
return $stmt->execute([$id]);
}
public function cancel($id) {
$stmt = $this->db->prepare("UPDATE orders SET status = 'cancelled' WHERE id = ?");
return $stmt->execute([$id]);
}
public function deleteComplete($id) {
$stmt = $this->db->prepare("DELETE FROM complete_orders WHERE id = ?");
return $stmt->execute([$id]);
}
public function deletePending($id) {
$stmt = $this->db->prepare("DELETE FROM pending_orders WHERE id = ?");
return $stmt->execute([$id]);
}
public function deleteFromView($id) {
$stmt = $this->db->prepare("DELETE FROM orders WHERE id = ?");
return $stmt->execute([$id]);
}
public function place($uid, $address, $price, $payment, $location_id, $note) {
$stmt = $this->db->prepare("INSERT INTO orders (user_id, shipping_address, total_price, payment_method, delivery_location_id, order_note) VALUES (?, ?, ?, ?, ?, ?)");
return $stmt->execute([$uid, $address, $price, $payment, $location_id, $note]);
}
}