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
-- Shipment
CREATE PROCEDURE getByOrder(
IN order_id INT,
OUT fetch_all
)
BEGIN
-- shipment
SELECT *
FROM order_shipment WHERE order_shipment.order_id = :order_id;
END
CREATE PROCEDURE add(
IN shipment ROW,
OUT insert_id
)
BEGIN
:shipment_data = @FILTER(:shipment, order_shipment)
INSERT INTO order_shipment
( @KEYS(:shipment_data) )
VALUES ( :shipment_data );
END