aonestar.public

Parameters

Name	Type	Mode
i_folio_id	integer	IN
i_folio_name	text	IN
i_close_date	date	IN
i_address1	text	IN
i_address2	text	IN
i_company	text	IN
i_channel_id	integer	IN
i_note	text	IN
user_name	text	IN (DEFAULT NULL)

Definition

DECLARE 
    _sqlstate TEXT;
    _detail   TEXT;
    _hint     TEXT;
    _context  TEXT;
    _msg_text TEXT;
--    messages  jsonb = $json${    
--        "30121" : "Folio out of balance", 
--        "30106" : "Folio %s is already closed"
--    }$json$;
BEGIN 
    --CALL sp_check_endday_process();

    UPDATE cash_sale cs
    SET name = COALESCE(i_folio_name, name),
        address1 = i_address1,
        address2 = i_address2,
        company = i_company,
        channel_id = i_channel_id,
        note = i_note
    WHERE cs.folio_id = i_folio_id;

IF i_close_date IS NOT NULL THEN 
        UPDATE folio 
        SET close_date = i_close_date 
        WHERE id = i_folio_id;
    END IF;

   -- save cashier log

PERFORM sp_log_debug('sp_update_cashsale_folio', jsonb_pretty(jsonb_build_object(
        'folio_id', i_folio_id,
        'folio_name', i_folio_name,
        'close_date', i_close_date,
        'address1', i_address1,
        'address2', i_address2,
        'company', i_company,
        'channel_id', i_channel_id,
        'note', i_note
    )));

    RETURN fn_result_success();
EXCEPTION  
    WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        _sqlstate = RETURNED_SQLSTATE,
        _msg_text = MESSAGE_TEXT,
        _detail   = PG_EXCEPTION_DETAIL,
        _hint     = PG_EXCEPTION_HINT,
        _context  = PG_EXCEPTION_CONTEXT;    
    RETURN fn_handle_error(_sqlstate, _msg_text, _detail, _hint, _context, 'sp_update_cashsale_folio', 
        jsonb_build_object(
            'folio_id', i_folio_id,
            'folio_name', i_folio_name,
            'close_date', i_close_date,
            'address1', i_address1,
            'address2', i_address2,
            'company', i_company,
            'channel_id', i_channel_id,
            'note', i_note
        )
    );
END;