{"created_at":"2020-09-24 10:01:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:01:42","OPEN_FOR_INTERNAL","2020-09-24 10:01:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:01:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:01:44","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:01:44","OPEN_FOR_INTERNAL","2020-09-24 10:01:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:01:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:01:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:01:46","OPEN_FOR_INTERNAL","2020-09-24 10:01:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:01:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:07:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:07:47","OPEN_FOR_INTERNAL","2020-09-24 10:07:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:10:45","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:10:45","OPEN_FOR_INTERNAL","2020-09-24 10:10:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:10:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:10:52","OPEN_FOR_INTERNAL","2020-09-24 10:10:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:12","OPEN_FOR_INTERNAL","2020-09-24 10:14:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:14","OPEN_FOR_INTERNAL","2020-09-24 10:14:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:22","OPEN_FOR_INTERNAL","2020-09-24 10:14:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:22","OPEN_FOR_INTERNAL","2020-09-24 10:14:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:32","OPEN_FOR_INTERNAL","2020-09-24 10:14:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:35","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:35","OPEN_FOR_INTERNAL","2020-09-24 10:14:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:35","OPEN_FOR_INTERNAL","2020-09-24 10:14:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:36","OPEN_FOR_INTERNAL","2020-09-24 10:14:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:37","OPEN_FOR_INTERNAL","2020-09-24 10:14:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:38","OPEN_FOR_INTERNAL","2020-09-24 10:14:38"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:38","OPEN_FOR_INTERNAL","2020-09-24 10:14:38"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:14:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:14:39","OPEN_FOR_INTERNAL","2020-09-24 10:14:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:16","OPEN_FOR_INTERNAL","2020-09-24 10:15:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:17","OPEN_FOR_INTERNAL","2020-09-24 10:15:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:17","OPEN_FOR_INTERNAL","2020-09-24 10:15:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:17","OPEN_FOR_INTERNAL","2020-09-24 10:15:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:18","OPEN_FOR_INTERNAL","2020-09-24 10:15:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:18","OPEN_FOR_INTERNAL","2020-09-24 10:15:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:38","OPEN_FOR_INTERNAL","2020-09-24 10:15:38"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:38","OPEN_FOR_INTERNAL","2020-09-24 10:15:38"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:39","OPEN_FOR_INTERNAL","2020-09-24 10:15:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-24 10:15:43","OPEN_FOR_INTERNAL","2020-09-24 10:15:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-09-24 10:15:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=145&filter3=undefined","floor_plan_rent_room":[{"room_id":"602","master_room_id":"28","room_code":"M13"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1029,"customer_code":"C181029","identity_type":"PERSONAL","identity_id":"D669964(3)","title":"Mr","lastname":"Tseng","firstname":"Yee Paul","companyname":"","email":"paulyeetseng@gmail.com","tel":"91799340","address":"Flat 13D, Block 24, Baguio Villa, 555 Victoria Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2881.0","renew_rent_month":"3","renew_warehousing_date":"2020-08-14","renew_room_key":"0005895098","renew_remark":"3 months contract. Storage rental paid by bank transfer on Jul 25, 2020. Storage deposit $6066 transferred from agreement A05-CT196787 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT208463, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"116","order_discount":[{"master_room_discount_id":"253","master_room_id":"116","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"1052","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"253","master_room_id":"116","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"1051","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1052","room_code":"A05-050","retail_price":"1605.0","discounted_price":1524.8,"location_id":"4"},{"room_id":"1051","room_code":"A05-049","retail_price":"1605.0","discounted_price":1524.8,"location_id":"4"}],"roughly_size":"40","total_retail_price":3210,"total_discounted_price":2881,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8643,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-14","rent_from":"2020-08-14","rent_to":"2020-11-13","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on 24 Sep 2020. Storage deposit $6066 transferred from agreement A05-CT208463 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8643,"final_order_total":8643,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005895098","order_product":[],"pass":true}},"first_order_id":"3510","selected_room_tr":"