ALTER PROCEDURE "DBA"."sp_Report_Dates_Ditail"
(
    @uid BIGINT
)
RESULT
(
    @id BIGINT,
    @login VARCHAR( 50 ),
    @size_g NUMERIC( 10 , 4 ),
    @size NUMERIC( 10 , 4 ),
    @size_l NUMERIC( 10 , 4 )
)
BEGIN
    DECLARE LOCAL TEMPORARY TABLE tmp_Jurnal
    (
        uid BIGINT,
        "login" VARCHAR( 50 ),
        size_g NUMERIC( 10 , 4 ),
        size NUMERIC( 10 , 4 ),
        size_l NUMERIC( 10 , 4 )
    ) ON COMMIT DELETE ROWS;

    DECLARE @l_id BIGINT;
    DECLARE @l_login VARCHAR( 50 );
    DECLARE @l_size NUMERIC( 10 , 4 );
    DECLARE @l_size_l NUMERIC( 10 , 4 );

    DECLARE @sql LONG VARCHAR;
    SET @sql = 'SELECT DISTINCT(uid_user) as uid_user FROM Jurnal as j WHERE j.uid_date = ' || string(@uid) || ' ORDER BY uid_user';
    
    FOR loop_name AS DYNAMIC SCROLL CURSOR USING @sql
    DO
        SELECT name INTO @l_login
        FROM DirectoryUsers
        WHERE uid = uid_user;

        SELECT (SUM(size) /  1048576 ) size INTO @l_size
        FROM Jurnal AS j
        LEFT JOIN DirectoryDomains AS dd ON (j.uid_domain = dd.uid AND dd.isLocal =  0 )
        WHERE uid_date = @uid AND uid_user = uid_user;

        SELECT (SUM(size) /  1048576 ) size INTO @l_size_l
        FROM Jurnal AS j
        LEFT JOIN DirectoryDomains AS dd ON (j.uid_domain = dd.uid AND dd.isLocal =  1 )
        WHERE uid_date = @uid AND uid_user = uid_user;

        INSERT INTO tmp_Jurnal VALUES (@uid, @l_login, @l_size + @l_size_l, @l_size, @l_size_l);
    END FOR;
    
    SELECT uid AS @id, "login" AS @login, size_g AS @size_g, size AS @size, size_l as @size_l
    FROM tmp_Jurnal
    ORDER BY size_g;
END

SELECT
(SUM(if dd.isLocal =  0  then size else  0  endif) /  1048576 ),
(SUM(if dd.isLocal =  1  then size else  0  endif) /  1048576 ) 
INTO @l_size,@l_size_l
FROM Jurnal AS j
LEFT JOIN DirectoryDomains AS dd ON (j.uid_domain = dd.uid)
WHERE uid_date = @uid AND uid_user = uid_user;