aonestar.public

Parameters

Name	Type	Mode
shift	character varying	INOUT
use_online_shift	boolean	IN (DEFAULT false)
use_default_shift	boolean	IN (DEFAULT false)

Definition

DECLARE 
    messages jsonb = $${     
        "90001" : "Shift not specified",
        "90002" : "Online post is off", 
        "90003" : "Invalid shift (%s)"
    }$$;
    default_shift t_shift = 'D';
BEGIN   
	shift = coalesce(shift, fn_get_session('USER_SHIFT'));
	       
	IF (COALESCE(shift,'X') NOT IN ('A','B','C','D')) AND use_online_shift THEN 
		shift = fn_sys_param('ONLINE_SHIFT');
		shift = iif(shift IN ('A','B','C','D'), shift, default_shift);
	END IF;

IF (COALESCE(shift,'X') NOT IN ('A','B','C','D')) AND use_default_shift THEN 
		shift = default_shift;
	END IF;

CASE 	
		WHEN (shift IS NULL) THEN 
      		RAISE EXCEPTION SQLSTATE '99999' USING detail = fn_result_error('90001', messages->>'90001');
      	WHEN (shift = 'X') THEN
        	RAISE EXCEPTION SQLSTATE '99999' USING detail = fn_result_error('90002', messages->>'90002');	
        WHEN shift NOT IN ('A','B','C','D')  THEN        	
      		RAISE EXCEPTION SQLSTATE '99999' USING detail = fn_result_error('90003', messages->>'90003', shift);	
		ELSE 
    END CASE;  
END

sp_check_shift

Parameters

Definition