aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_transaction_codes_js
Description
List all transaction codes according to guest’s folio pattern
Parameters
Name
Type
Mode
folio_id
integer
IN
Definition
WITH list AS ( SELECT dp.id, dp.code, dp.name, dp.group_id, dg."name" AS group_name, dp.post_type, dept_type, require_info, tax_code, fd.folio_seq FROM department AS dp LEFT JOIN department_group AS dg ON dg.id = dp.group_id LEFT JOIN folio_details AS fd ON fd.folio_id = $1 AND dp.id = fd.dept_id WHERE dp.post_type = 'P' AND dp.enabled ORDER BY code ) SELECT json_agg(list) FROM list