aonestar.public

Parameters

Name	Type	Mode
form_type	text	IN
prop_id	integer	IN (DEFAULT NULL)
property_name	text	OUT
logo	bytea	OUT
logo_url	text	OUT
logo_type	text	OUT
address1	text	OUT
address2	text	OUT
address3	text	OUT
address4	text	OUT
email	text	OUT
telephone	text	OUT
fax	text	OUT
website	text	OUT
company	text	OUT
tax_id	text	OUT
branch_no	text	OUT
header_text	text	OUT
footer_text	text	OUT

Definition

with auth as (
        SELECT * 
        FROM dblink(fn_conn_authen(), format($$
                SELECT f.logo, f.logo_type, f.address1, f.address2, f.address3, f.address4, f.email, 
                       f.telephone, f.fax, f.website, f.company, f.header_text, f.footer_text 
                FROM print_form f
                WHERE f.prop_id = %L and f.form_type = %L 
                $$, 
                coalesce(prop_id, fn_prop_id()), form_type)
             ) 
        AS A(logo bytea,
             logo_type TEXT,
             address1 text,
             address2 text,
             address3 text,
             address4 text,
             email text,
             telephone text,
             fax text,
             website text,
             company text,
             header_text text,
             footer_text text
            )
    )
    Select p.name,
        coalesce(a.logo, p.logo), p.logo_url,
        coalesce(a.logo_type, p.logo_type),
        coalesce(a.address1, p.address1),
        coalesce(a.address2, p.address2),
        coalesce(a.address3, p.address3),
        coalesce(a.address4, p.address4),
        coalesce(a.email, p.email),
        coalesce(a.telephone, p.telephone),
        coalesce(a.fax, p.fax),
        coalesce(a.website, p.website),
        coalesce(a.company, p.company),
        p.tax_id,
        p.branch_no,
        a.header_text,
        a.footer_text
    from property_info P left join auth A on 1=1

sp_print_form_header

Parameters

Definition