Powerful and easy to use cms to build websites, blogs or ecommerce stores.
HTML backendblogblog-engineblog-platformbloggingcmscontent-managementcontent-management-systemecommerceecommerce-platformno-codepage-builderphpphp-cmsphp7php8self-hostedshopping-cartweb-applicationwebsite-builder
-- Carts
-- get all carts
CREATE PROCEDURE getAll(
IN cart_id ARRAY,
IN user_id CHAR,
IN start INT,
IN limit INT,
IN cursor INT, -- current cursor (cart_id) for cursor pagination
OUT fetch_all,
OUT fetch_one
)
BEGIN
-- cart
SELECT *
FROM cart WHERE 1 = 1
@IF isset(:cart_id) AND :cart_id
THEN
AND cart_id IN (:cart_id)
END @IF
@IF isset(:user_id) AND :user_id
THEN
AND user_id IN (:user_id)
END @IF
-- cursor pagination
@IF isset(:cursor)
THEN
AND cart.cart_id > :cursor
END @IF
ORDER BY status DESC, cart_id
@IF !empty(:limit)
THEN
LIMIT :limit OFFSET :start
END @IF
;
SELECT count(*) FROM (
@SQL_COUNT(cart.cart_id, cart) -- this takes previous query removes limit and replaces select columns with parameter product_id
) as count;
END
-- get cart
CREATE PROCEDURE get(
IN cart_id INT,
IN user_id INT,
OUT fetch_row
)
BEGIN
-- cart
SELECT *
FROM cart as _ WHERE 1 = 1
@IF isset(:cart_id) AND :cart_id
THEN
AND cart_id = :cart_id
END @IF
@IF isset(:user_id) AND :user_id
THEN
AND user_id = :user_id
END @IF
;
END
-- add cart
CREATE PROCEDURE add(
IN cart ROW,
OUT insert_id
)
BEGIN
-- allow only table fields and set defaults for missing values
:cart_data = @FILTER(:cart, cart)
INSERT INTO cart
( @KEYS(:cart_data) )
VALUES ( :cart_data );
END
-- edit cart
CREATE PROCEDURE edit(
IN cart ROW,
IN cart_id INT,
OUT affected_rows
)
BEGIN
-- allow only table fields and set defaults for missing values
@FILTER(:cart, cart)
UPDATE cart
SET @LIST(:cart)
WHERE cart_id = :cart_id
END
-- edit cart
CREATE PROCEDURE update(
IN cart ROW,
OUT affected_rows
)
BEGIN
-- allow only table fields and set defaults for missing values
@FILTER(:cart, cart)
INSERT INTO cart
( @KEYS(:cart))
VALUES ( :cart )
ON CONFLICT(`cart_id`,`user_id`) DO UPDATE SET @LIST(:each);
END
-- delete cart
CREATE PROCEDURE delete(
IN cart_id ARRAY,
IN user_id ARRAY,
OUT affected_rows
)
BEGIN
-- cart
DELETE FROM cart WHERE 1 = 1
@IF isset(:cart_id) AND :cart_id
THEN
AND cart_id IN (:cart_id)
END @IF
@IF isset(:user_id) AND :user_id
THEN
AND user_id IN (:user_id)
END @IF;
END