public function getOrderProducts()
{
$orderId = $this->session->get('completed_order_id');
$query = '
select
*
from
aca_order_product op
left join aca_product p on (op.product_id = p.product_id)
left join aca_cart c on (op.order_id = c.cart_id)
WHERE
order_id = "' . $orderId . '"';
return $this->db->fetchRowMany($query);
}
/**
* Create a cart record, and return the id if it doesn't exist
* If it does exist, just return the ID
* @return int
* @throws Exception
*/
public function getCartId()
{
// $db = $this->get('acadb');
$user_id = $this->session->get('user_id');
$query = '
select
*
from
aca_cart
WHERE
user_id = :userId';
$data = $this->db->fetchRow($query, array('userId' => $user_id));
if (empty($user_id)) {
throw new Exception('Please login first');
} else {
if (empty($data)) {
$cartId = $this->db->insert('aca_cart', array('user_id' => $user_id));
} else {
$cartId = $data['cart_id'];
}
$this->session->set('cart_id', $cartId);
$this->session->save();
return $cartId;
// return $this->getCartId();
}
}
