Форум программистов [Powered by Invision Power Board]

Код

DELIMITER $$

DROP PROCEDURE IF EXISTS `LOCARUS`.`Get_DATA` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Get_DATA`(
IN _IMEI nvarchar(50),
IN _SERIAL_COMPUTER_NUMBER nvarchar(50),
OUT _Ret bigint,
IN _StartID bigint
)
BEGIN
    declare _MyMax bigint;

    SELECT max(DATA.ID_DATA) INTO _Ret FROM DATA
    INNER JOIN DEVICES ON DEVICES.ID_DEVICE = DATA.ID_DEVICE
    WHERE IMEI_NAME = _IMEI;

       SELECT _Ret;
    

    SELECT MAX(POINTER)  INTO _MyMax FROM SERIALS 
    INNER JOIN DEVICES ON DEVICES.ID_DEVICE = SERIALS.ID_DEVICE
    INNER JOIN SERIAL_LIST ON SERIAL_LIST.ID_SERIAL_LIST = SERIALS.ID_SERIAL_LIST
    WHERE IMEI_NAME = _IMEI
    AND SERIAL = _SERIAL_COMPUTER_NUMBER;
    
    

        IF EXISTS
            ( 
            SELECT DEVICES.ID_DEVICE FROM DEVICES
                    INNER JOIN SERIALS ON SERIALS.ID_DEVICE = DEVICES.ID_DEVICE
                    INNER JOIN SERIAL_LIST ON SERIAL_LIST.ID_SERIAL_LIST = SERIALS.ID_SERIAL_LIST
            WHERE SERIAL = _SERIAL_COMPUTER_NUMBER 
            AND IMEI_NAME = _IMEI 
            LIMIT 1
            )        
            THEN
                SELECT DATA_SIZE,DATA, ID_DATA
                FROM DATA
                INNER JOIN DEVICES ON DATA.ID_DEVICE = DEVICES.ID_DEVICE 
                INNER JOIN SERIALS ON SERIALS.ID_DEVICE = DEVICES.ID_DEVICE
                INNER JOIN SERIAL_LIST ON SERIAL_LIST.ID_SERIAL_LIST = SERIALS.ID_SERIAL_LIST
                WHERE
                    (
                    DATA.ID_DATA > _MyMax
                    )
                AND SERIAL = _SERIAL_COMPUTER_NUMBER 
                AND IMEI_NAME = _IMEI
                AND DATA.ID_DATA <= _Ret
                AND DATA.ID_DATA > _StartID
                ORDER BY ID_DATA
                LIMIT 1000
                ;
            ELSE
                SELECT DATA_SIZE,DATA, ID_DATA
                FROM DATA 
                INNER JOIN DEVICES ON DATA.ID_DEVICE = DEVICES.ID_DEVICE 
                AND IMEI_NAME = _IMEI
                AND DATA.ID_DATA <= _Ret
                AND DATA.ID_DATA > _StartID
                ORDER BY ID_DATA
                LIMIT 1000
                ;
            END IF;

END $$

DELIMITER ;