aonestar.public

Parameters

Name	Type	Mode
form_type	text	IN
prop_id	integer	IN (DEFAULT NULL)
print_form_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
custom_text1	text	OUT
custom_text2	text	OUT
custom_text3	text	OUT
custom_text4	text	OUT
property_name2	text	OUT
company2	text	OUT

Definition

SELECT p.name,
           p.logo,
           coalesce(f.logo_url, p.logo_url),
           p.logo_type,
           coalesce(f.address1, p.address1),
           coalesce(f.address2, p.address2),
           coalesce(f.address3, p.address3),
           coalesce(f.address4, p.address4),
           coalesce(f.email, p.email),
           coalesce(f.telephone, p.telephone),
           coalesce(f.fax, p.fax),
           coalesce(f.website, p.website),
           coalesce(f.company, p.company),
           p.tax_id,
           p.branch_no,
           f.header_text,
           f.footer_text,
           f.custom_text1,
           f.custom_text2,
           f.custom_text3,
           f.custom_text4,
           p.name2,
           coalesce(f.company2, p.company2)
    FROM public.property_info p
    LEFT JOIN LATERAL (
        SELECT pf.*
        FROM public.print_form pf
        WHERE ($3 IS NOT NULL AND pf.id = $3)
           OR ($3 IS NULL AND pf.form_type = $1)
        ORDER BY pf.is_default DESC, pf.id
        LIMIT 1
    ) f ON true

sp_print_form_header

Parameters

Definition