Cart detail 2

INSERT INTO ta_tabla (ta_campo, ta_codigo, ta_denominacion, ta_colorleyenda, ta_orden, Activo, IdUsuarioReg, FechaReg, IdUsuarioAct, FechaAct)
VALUES ('StateCart', '01', 'Pending', '#FCDE01', 1, 1, 1, NOW(), 1, NOW());

INSERT INTO ta_tabla (ta_campo, ta_codigo, ta_denominacion, ta_colorleyenda, ta_orden, Activo, IdUsuarioReg, FechaReg, IdUsuarioAct, FechaAct)
VALUES ('StateCart', '02', 'Completed', '#5BDE73', 1, 1, 1, NOW(), 1, NOW());

INSERT INTO ta_tabla (ta_campo, ta_codigo, ta_denominacion, ta_colorleyenda, ta_orden, Activo, IdUsuarioReg, FechaReg, IdUsuarioAct, FechaAct)
VALUES ('StateCart', '03', 'Aborted', '#FF6A42', 1, 1, 1, NOW(), 1, NOW());



DROP PROCEDURE IF EXISTS pa_cartDetail_register_once;
DELIMITER //
CREATE PROCEDURE pa_cartDetail_register_once
(
    IN userId INT,
    IN createDateAt DATETIME,
    IN productId INT,
    IN price DECIMAL(10,2),
    IN quantity INT,
    IN amount DECIMAL(10, 2)
)
BEGIN
    DECLARE cartId INT;

    SET cartId = 0;

    SELECT COALESCE(CartId, 0) INTO cartId FROM Cart WHERE UserId = userId AND StateCart = '01' AND Active = 1;

    IF cartId > 0 THEN
        UPDATE Cart SET TotalAmount = TotalAmount + amount, UpdatedAt = NOW() WHERE CartId = cartId;
        SET cartId = LAST_INSERT_ID();
    ELSE
        INSERT INTO Cart (UserId, CreatedAt, StateCart, TotalAmount, UpdatedAt, Active) VALUES (userId, createdAt, '01', amount, NOW(), 1);
        SET cartId = LAST_INSERT_ID();
    END IF;

    INSERT INTO DetailsCart (CartId, ProductId, Price, Quantity, Amount, UpdatedAt, Active) VALUES (cartId, productId, price, quantity, amount, NOW(), 1);
END//
DELIMITER ;