aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_endday_increment_system_date
Parameters
Name
Type
Mode
user_name
text
IN
status
text
INOUT
msg
text
INOUT
Definition
BEGIN PERFORM sp_set_param('SYSTEM','SYSTEM_DATE', fn_system_date()+1); -- endday ไม่ post ค่าห้องแล้ว (post ผ่านหน้าจอ Auto Post) → reset flag ให้วันใหม่ post ได้ UPDATE registration r SET room_posted = false WHERE r.status = 'I'; PERFORM sp_reset_roomavail(); status = 'success'; msg = 'System date changed to ' || to_char(fn_system_date(), 'DD-MM-YYYY'); END