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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`saleTracking_sectorCollectionAddPrevOK`(
	vSectorCollectionFk INT
)
BEGIN
/**
 * Inserta los registros de sectorCollection con el estado PREVIA OK si la reserva está picked
 *
 * @param vSectorCollectionFk Identificador de vn.sectorCollection
 */
	REPLACE saleTracking(saleFk, isChecked, workerFk, stateFk)
		SELECT sgd.saleFk, TRUE, sc.userFk, s.id
			FROM sectorCollection sc
				JOIN sectorCollectionSaleGroup scsg ON scsg.sectorCollectionFk = sc.id
				JOIN saleGroupDetail sgd ON sgd.saleGroupFk = scsg.saleGroupFk
				JOIN state s ON s.code = 'OK PREVIOUS'
				JOIN itemShelvingSale iss ON iss.saleFk = sgd.saleFk
			WHERE sc.id = vSectorCollectionFk AND iss.isPicked;
END$$
DELIMITER ;