aonestar.public

Parameters

Name	Type	Mode
i_booking_id	integer	IN
i_register_id	integer	IN
i_files	jsonb	IN
i_max_files	integer	IN (DEFAULT NULL)
i_max_file_mb	integer	IN (DEFAULT NULL)
i_quota_mb	integer	IN (DEFAULT NULL)

Definition

DECLARE
    v_max_files   int;
    v_max_file_mb int;
    v_quota_mb    int;
    v_new_count   int;
    v_new_bytes   bigint;
    v_cur_count   int;
    v_used_bytes  bigint;
    v_bad_file    text;
BEGIN
    v_max_files   := COALESCE(i_max_files,   fn_prop_config('ATTACHMENT_MAX_FILES', '20')::int);
    v_max_file_mb := COALESCE(i_max_file_mb, fn_prop_config('ATTACHMENT_MAX_FILE_SIZE_MB', '10')::int);
    v_quota_mb    := COALESCE(i_quota_mb,    fn_prop_config('ATTACHMENT_STORAGE_QUOTA_MB', '1024')::int);

SELECT count(*), COALESCE(sum(COALESCE((f->>'file_size')::bigint, 0)), 0)
    INTO v_new_count, v_new_bytes
    FROM jsonb_array_elements(i_files) f;

-- จำนวนไฟล์ต่อ booking/registration
    SELECT count(*) INTO v_cur_count
    FROM attachment
    WHERE (i_booking_id IS NOT NULL AND booking_id = i_booking_id)
       OR (i_register_id IS NOT NULL AND register_id = i_register_id);

IF v_cur_count + v_new_count > v_max_files THEN
        RETURN fn_result_error('41002', 'Maximum %s attachments per booking/registration exceeded',
            v_max_files::text);
    END IF;

-- ขนาดต่อไฟล์
    SELECT f->>'file_name' INTO v_bad_file
    FROM jsonb_array_elements(i_files) f
    WHERE COALESCE((f->>'file_size')::bigint, 0) > v_max_file_mb::bigint * 1024 * 1024
    LIMIT 1;

IF v_bad_file IS NOT NULL THEN
        RETURN fn_result_error('41003', 'File %s exceeds the maximum size of %s MB',
            v_bad_file, v_max_file_mb::text);
    END IF;

-- พื้นที่รวมของโรงแรม (SUM ทั้งตาราง — DB แยกต่อโรงแรมอยู่แล้ว)
    SELECT COALESCE(sum(file_size), 0) INTO v_used_bytes FROM attachment;

IF v_used_bytes + v_new_bytes > v_quota_mb::bigint * 1024 * 1024 THEN
        RETURN fn_result_error('41004', 'Storage quota exceeded (%s MB of %s MB used)',
            round((v_used_bytes + v_new_bytes) / 1048576.0, 1)::text, v_quota_mb::text);
    END IF;

RETURN NULL;
END

fn_attachment_check_limits

Parameters

Definition