salix/db/routines/vn/functions/hasItemsInSector.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` FUNCTION `vn`.`hasItemsInSector`(vTicketFk INT, vSectorFk INT)
	RETURNS tinyint(1)
	DETERMINISTIC
BEGIN

	DECLARE vItemCount INT;
    
    SELECT count(*) INTO vItemCount
		FROM vn.sale s 
			JOIN vn.itemShelving ish ON ish.itemFk = s.itemFk
            JOIN vn.shelving sh ON sh.id = ish.shelvingFk
            JOIN vn.parking p ON p.id = sh.parkingFk
		WHERE s.ticketFk = vTicketFk
			AND p.sectorFk = vSectorFk;
            
	RETURN vItemCount;
    
END$$
DELIMITER ;