XD

DROP PROCEDURE `pa_notificacion_listar`;
CREATE DEFINER=`chivoonline`@`localhost` PROCEDURE `pa_notificacion_listar`(IN `tipo` VARCHAR(10), IN `idusuario` INT(11)) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER BEGIN
    IF tipo = '1' THEN
        SELECT `td_idnotificacion` AS id, `td_tipo_notificacion` AS typeNotification, `td_accion_notificacion` AS actionNotification, `td_idusuario_origen` AS idusuario_origen, `td_imagen` AS image, `td_titulo` AS title, `td_content` AS content, `td_urlredirect` AS urlredirect, `td_metadata` AS metadata
         FROM td_notificacion WHERE td_idusuario_destino = idusuario AND Activo = 1
         ORDER BY FechaReg DESC LIMIT 5;
    ELSEIF tipo = '2' THEN
        SELECT `td_idnotificacion` AS id, `td_tipo_notificacion` AS typeNotification, `td_accion_notificacion` AS actionNotification, `td_idusuario_origen` AS idusuario_origen, `td_imagen` AS image, `td_titulo` AS title, `td_content` AS content, `td_urlredirect` AS urlredirect, `td_metadata` AS metadata
         FROM td_notificacion WHERE td_idusuario_destino = idusuario AND Activo = 1;
    END IF;
END