Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DEFINER=`root`@`localhost` PROCEDURE `pa_requerimiento_listar`(IN `idrequerimiento` int(11) , IN `idusuario` int(11) , IN `fecha` int(11) , IN `categoria` varchar(2) , IN `tipo` varchar(2), IN `id` INT, IN `pagina` INT(11))
- BEGIN
- DECLARE firstLimit INT(11) DEFAULT 42;
- DECLARE vstart INT(11) DEFAULT 0;
- set vstart = (pagina * firstLimit) - firstLimit;
- IF tipo = '1' THEN
- SELECT * FROM tm_requerimiento
- WHERE tm_idusuario = idusuario AND Activo = 1
- LIMIT vstart, firstLimit;
- ELSEIF tipo = '2' THEN
- SELECT * FROM tm_requerimiento
- WHERE tm_fecha = fecha AND Activo = 1
- LIMIT vstart, firstLimit;
- ELSEIF tipo = '3' THEN
- SELECT * FROM tm_requerimiento
- WHERE tm_categoria = categoria AND Activo = 1
- LIMIT vstart, firstLimit;
- ELSEIF tipo = '4' THEN
- SELECT * FROM tm_requerimiento
- WHERE tm_idrequerimiento = id;
- END IF;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement