24 lines
580 B
SQL
24 lines
580 B
SQL
-- DELIMITER $$
|
|
-- CREATE OR REPLACE DEFINER=`vn`@`localhost` FUNCTION vn.client_getCurrency(vSelf INT)
|
|
-- RETURNS INT(3)
|
|
-- DETERMINISTIC
|
|
-- BEGIN
|
|
-- /**
|
|
-- * Devuelve la moneda por defecto del cliente dado
|
|
-- *
|
|
-- * @param vSelf id del cliente
|
|
-- * @return devuelve id del tipo de moneda
|
|
-- */
|
|
-- DECLARE vCurrencyFk INT;
|
|
|
|
-- SELECT co.currencyFk INTO vCurrencyFk
|
|
-- FROM client c
|
|
-- JOIN vn.province p ON p.id = c.provinceFk
|
|
-- JOIN vn.country co ON co.id = p.countryFk
|
|
-- WHERE c.id = vSelf
|
|
-- LIMIT 1;
|
|
|
|
-- RETURN vCurrencyFk;
|
|
-- END$$
|
|
-- DELIMITER ;
|