aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_registration_save_log
Parameters
Name
Type
Mode
Definition
DECLARE log_text text; BEGIN IF is_log_started() IS NOT NULL THEN log_text := fn_format_log('Guest', OLD.guest_id, NEW.guest_id, 'guest', lookup_name=>'full_name') --|| fn_format_log('Arrival', OLD.arrival, NEW.arrival) --|| fn_format_log('Departure', OLD.departure, NEW.departure) --|| fn_format_log('Rate Plan', OLD.rateplan_id, NEW.rateplan_id, 'rate_plan') || fn_format_log('PAX', OLD.pax, NEW.pax) || fn_format_log('Channel', OLD.channel_id, NEW.channel_id, 'channel') || fn_format_log('Voucher#', OLD.voucher_no, NEW.voucher_no) || fn_format_log('Reservation Type', OLD.rsvtype_id, NEW.rsvtype_id, 'reservation_type') || fn_format_log('Origin', OLD.origin_id, NEW.origin_id, 'origin') || fn_format_log('Market', OLD.market_id, NEW.market_id, 'market') || fn_format_log('Sale Staff', OLD.sales_id, NEW.sales_id, 'sales_staff') || fn_format_log('Folio Pattern', OLD.folio_pattern_id, NEW.folio_pattern_id, 'folio_pattern') || fn_format_log('Credit Limit', OLD.credit_limit, NEW.credit_limit) || fn_format_log('Promo Code', OLD.promo_code, NEW.promo_code) || fn_format_log('Payment Method', OLD.payment_method, NEW.payment_method)--, map_keys=>'{DRB,COA,COD}'::bpchar[], map_texts=>'{Direct Bill,COA,COD}') || fn_format_log('Arrive By', OLD.arrive_by, NEW.arrive_by) || fn_format_log('Arrive From', OLD.arrive_from, NEW.arrive_from) || fn_format_log('Departure Time', OLD.departure_time, NEW.departure_time) || fn_format_log('Depart By', OLD.depart_by, NEW.depart_by) || fn_format_log('Depart To', OLD.depart_to, NEW.depart_to) || fn_format_log('Stay Type', OLD.stay_type, NEW.stay_type)--, map_keys=>'{D,W,M}'::bpchar[], map_texts=>'{Daily,Weekly,Monthly}'); || fn_format_log('Note', trim(OLD.note), trim(NEW.note), single_line=>FALSE); PERFORM sp_append_log(log_text); END IF; RETURN NULL; END