salix/db/routines/vn/procedures/saleGroup_setParking.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`saleGroup_setParking`(
	vSaleGroupFk VARCHAR(8),
	vParkingFk INT
)
BEGIN
/**
 * Aparca una preparación previa en un parking.
 *
 * @param vSaleGroupFk id de la preparación previa
 * @param vParkingFk id del parking
 */
	UPDATE saleGroup sg
		SET sg.parkingFk = vParkingFk
		WHERE sg.id = vSaleGroupFk
			AND sg.created >= util.VN_CURDATE() - INTERVAL 1 WEEK;

	CALL ticket_setNextState(ticket_get(vSaleGroupFk));
END$$
DELIMITER ;