34 lines
699 B
SQL
34 lines
699 B
SQL
DELIMITER $$
|
|
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`itemShelving_get`(
|
|
vShelvingCode VARCHAR(10)
|
|
)
|
|
BEGIN
|
|
/**
|
|
* Lista artículos de itemShelving.
|
|
*
|
|
* @param vShelvingCode Matrícula del carro
|
|
**/
|
|
SELECT ish.itemFk item,
|
|
i.name,
|
|
i.longName,
|
|
i.size,
|
|
ish.visible,
|
|
ish.packing,
|
|
ish.grouping,
|
|
p.code,
|
|
ish.id,
|
|
s.priority,
|
|
ish.isChecked,
|
|
ic.url,
|
|
ish.available,
|
|
ish.buyFk,
|
|
ish.shelvingFk
|
|
FROM itemShelving ish
|
|
JOIN item i ON i.id = ish.itemFk
|
|
JOIN shelving s ON s.id = ish.shelvingFk
|
|
LEFT JOIN parking p ON p.id = s.parkingFk
|
|
JOIN hedera.imageConfig ic
|
|
WHERE s.code COLLATE utf8_unicode_ci = vShelvingCode;
|
|
END$$
|
|
DELIMITER ;
|