From 059e0d95d0c28bc5060e87e146eaf7411f51bf90 Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Thu, 27 Apr 2023 03:47:30 +0300
Subject: skeleton commit; based on an anom project

---
 core/classes/Cart.php | 71 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 71 insertions(+)
 create mode 100644 core/classes/Cart.php

(limited to 'core/classes/Cart.php')

diff --git a/core/classes/Cart.php b/core/classes/Cart.php
new file mode 100644
index 0000000..4e6f585
--- /dev/null
+++ b/core/classes/Cart.php
@@ -0,0 +1,71 @@
+<?php
+
+class Cart
+{
+
+    public function checkout()
+    {
+
+    }
+
+    public function addOrder()
+    {
+        // get cart from cookie
+        // VITAL: validate + sanitize
+        //
+        // then
+        //
+        // get address and contact details from post
+    }
+
+
+    /** history
+     * get the last $limit cart-orders
+     * @param $limit (int)
+     */
+    public function history($limit)
+    {
+        // SELECT O.* , OP.* , P.*
+        // FROM orders O
+        // lEFT JOIN order_products OP ON OP.oid = O.id
+        // LEFT JOIN products P ON P.id = OP.pid
+        // WHERE uid = :uid
+        // AND O.id IN (
+        //    SELECT id FROM orders WHERE uid = :uid
+        //    ORDER BY id DESC
+        // )
+        //
+        // $items = runLimitQuery(sql, [uid = $this->uid], 10)
+        // 
+        // oranize in results = [ 
+        //    { 
+        //        oid,
+        //        prods: [ 
+        //            { 
+        //                pid,
+        //                prodlabel,
+        //                count 
+        //            },
+        //            ...
+        //        ] 
+        //    },
+        //    ...,
+        //    ]
+        //
+        // return $results
+
+    }
+}
+
+
+
+/* ---
+orders:
+ : id
+ : uid (user id)
+
+order_products
+ : id
+ : oid (order id)
+ : pid (product id)
+ -- */
\ No newline at end of file
-- 
cgit v1.2.3