authen.public

Parameters

Name	Type	Mode
prop_code	text	IN
reference_type	text	IN
reference_id	text	IN
description	text	IN
amount	numeric	IN
currency	text	IN
redirecturl	text	IN
note	text	IN
expires_at	timestamp with time zone	IN (DEFAULT NULL)

Definition

DECLARE 
    api_url text = 'https://pay.newsoft.co.th/api/v1/rpc/paymentlinks'; --'https://pay.newsoft.co.th/api/v1/rpc/paymentlinks';
    service_token text = 'eyJhbGciOiAiSFMyNTYiLCAidHlwIjogIkpXVCJ9.eyJpZCI6IDY0LCAiaWF0IjogMTc2Mzk2NzgwMSwgImp0aSI6ICJjOTJhM2YxOC1lNjA5LTRkN2MtYjZiZi02ZjUyMThmZjI0Y2MiLCAicGlkIjogMSwgInVndCI6ICJYIiwgInVpZCI6IDksICJuYW1lIjogIlBBWU1FTlQiLCAicGdpZCI6IG51bGwsICJwY29kZSI6ICJuZXdzb2Z0In0.gU59--S7xyVK7SBLzbnkE1vb1eun0HiH0St4AMSZOBk';
    params jsonb;
    v_result record;
BEGIN 
    params := jsonb_build_object(
        'merchant', prop_code,
        'reference_type', reference_type,
        'expiresAt', expires_at,
        'order', jsonb_build_object(
            'currency', currency,
            'description', description,
            'internalNote', note,
            'netAmount', (amount*100)::int,
            'referenceId', reference_id,
            'redirectUrl', redirectUrl 
        )
    ); 

    SELECT * FROM sys.call_rpc(api_url, service_token, params) INTO v_result; 

    raise notice 'success: %, msg_code: %, msg_text: %, data: %', 
            v_result.success, v_result.msg_code, v_result.msg_text, v_result.result_data;

    IF v_result.success THEN
        RETURN v_result.result_data->>'url';
    --ELSIF v_result.msg_text = 'Success' THEN
    --    RETURN json(v_result.msg_code)->>'url';
    ELSE 
        raise notice E'Code: %\nMessage:%', v_result.msg_code, v_result.msg_text;
        PERFORM sp_raise_error(v_result.msg_code, 'Create payment link error, '||v_result.msg_text);
    END IF;
END

sp_create_payment_link

Parameters

Definition