Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- DECLARE firstLimit INT(11) DEFAULT 42;
- DECLARE vstart INT(11) DEFAULT 0;
- IF tipo = '1' THEN -- PAGINADO
- SELECT * FROM tp_seccionpack
- WHERE tp_nombre LIKE CONCAT('%', criterio, '%') AND Activo = 1
- LIMIT vstart, firstLimit;
- ELSEIF tipo = '2' THEN
- SELECT * FROM tp_seccionpack WHERE tp_idseccionpack = id;
- ELSEIF tipo = '3' THEN -- TODO
- SELECT * FROM tp_seccionpack WHERE Activo = 1;
- ELSEIF tipo = '4' THEN -- TODO
- SELECT COALESCE(b.td_idgruposeccion, 0) AS td_idgruposeccion, COALESCE(b.tp_idseccionpack, a.tp_idseccionpack) AS tp_idseccionpack, COALESCE(b.td_nombreseccion, a.tp_nombre) AS tp_nombre
- FROM tp_seccionpack AS a
- LEFT JOIN td_grupo_seccion AS b ON a.tp_idseccionpack = b.tp_idseccionpack AND b.tm_idgrupoarticulo = id AND a.Activo = 1 AND b.Activo = 1 ;
- END IF;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement