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` DATE, IN `categoria` varchar(2) , IN `tipo` varchar(2), IN `listid` VARCHAR(4000), IN `pagina` INT(11))
- LANGUAGE SQL
- NOT DETERMINISTIC
- CONTAINS SQL
- SQL SECURITY DEFINER
- COMMENT ''
- 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 = idrequerimiento;
- ELSEIF tipo = '6' THEN
- SELECT * FROM tm_requerimiento
- WHERE FIND_IN_SET(tm_idrequerimiento, listid)
- ORDER BY tm_fecha DESC
- LIMIT pagina;
- ELSEIF tipo = '7' THEN
- SELECT * FROM tm_requerimiento
- WHERE FIND_IN_SET(tm_idrequerimiento, listid)
- ORDER BY tm_fecha DESC
- LIMIT vstart, firstLimit;
- END IF;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement