blob: 4e6f585b32a43d523a66b01a799d86658f6c1c9d (
plain)
1
2
3
4
5
6
7
8
9
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
|
<?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)
-- */
|
