{"created_at":"2020-07-04 10:26:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","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","floor_plan_rent_room":[{"room_id":"879","master_room_id":"77","room_code":"Y08"}],"index_url_parameter":"filter1=2&filter2=665&filter3=undefined","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
Y08 <\/td>\r\n\t\t\t\t\t	3X4X7 <\/td>\r\n\t\t\t\t\t	$1090.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"G551711(6)","title":"Mr","lastname":"Tam","firstname":"King Chee","companyname":"","email":"tysktam3d@yahoo.com.hk","tel":"94539974","address":"Flat F, 7\/F, Tower 3, Marina Habitat, Ap Lei Chau Main St, Apleichau, Hong Kong","pass":true,"customer_id":"665","customer_code":"C170665","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"879","room_code":"Y08","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":2180,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13952,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-07-30","rent_from":"2020-07-30","rent_to":"2021-08-29","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and deposit paid by EPS on July 4, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":981,"order_total":14933,"final_order_total":13952,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,07681","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"981.00","deposit":"2180.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3","665","NEW","A18-CT208288",1090,981,2180,0,"13","13",13952,14933,13952,"2020-07-04 10:29:44","0",null,null,null,"2020-07-30","2021-08-29","13 months contract. Special offer the 13th month free. Storage rental and deposit paid by EPS on July 4, 2020. ","2020-07-30","12",0,null,981,"981.00","2","2020-07-04 10:29:44","2","2020-07-04 10:29:44","EPS","","","","EPS","","","",null,0,"054,07681","C170665","PERSONAL","Mr","SWWW5Igf3SLl\/mWFO9SLSg==","RAqogkelEKt1q5b\/6Neu\/g==","","BCWSWwf+ZsYgaX0hlBTZLWjMAIJNfEpf1OGa+mx5DC6Pt0yfHu+VOJyo5sxSbw6w8iqWx6FDcHGyJHahbwcTkpdBU1jCuBkSO3TdtHGTYUk=","nlhrxcwf5D6ONS9n8+oLkA==","KyTZ1\/V7J\/bwgpEVxdbpJFGsyguYOi21ByVZAB\/UM94=","SiNLEC6FseO3TE\/BS862cA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8288","879","1090.0","1090.00","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-30","2021-08-29","879"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8288","A18-D205520","PAID",2180,0,"2021-08-29","2020-07-04 10:29:44","2020-07-04 10:29:44","2","2020-07-04 10:29:44","2","2020-07-04 10:29:44","665"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","665","SETTLED","A18-I208617","2020-07-04 10:29:44","2020-07-30","2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8617","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8617"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["665","EPS","","","","EPS","","","","PAID","P208260","2020-07-04 10:29:44",13952,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8260","DEPOSIT","5520","PAID","2020-07-04 10:29:44",2180,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:29:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8260","INVOICE","8617","PAID","2020-07-04 10:29:44",11772,"2","2020-07-04 10:29:44","2","2020-07-04 10:29:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 10:43:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:07:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:08","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=2&filter2=1162&filter3=undefined","floor_plan_rent_room":[{"room_id":"1451","master_room_id":"158","room_code":"C15-145"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-145 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"M645881(0)","title":"Mr","lastname":"Zhang","firstname":"Zhao Zong","companyname":"","email":"jason.z.zhong@gmail.com","tel":"67000194","address":"15\/F Lincoin House, Taikoo Place, 979 King's Road, Quarry Bay, HK ","pass":true,"customer_id":"1162","customer_code":"C191162","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1451","room_code":"C15-145","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":510,"deposit":510,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":720,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"810.00","warehousing_date":"2020-07-05","rent_from":"2020-07-05","rent_to":"2020-09-04","delivery_service":"0","remark":"2 months ccontract. Changed unit from C15-022. Storage deposit $810 transferred from agreement C15-CT206937\t to this agreement. The balance of storage rental and deposit $720 paid by cash on Jul 04, 2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":810,"order_total":1530,"final_order_total":720,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012438313","order_product":[],"pass":true}},"roughly_size":"8.1","total_discounted_price":"510.00","deposit":"510.00","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1162","NEW","C15-CT208289",510,510,510,0,"2","2",720,1530,720,"2020-07-04 11:21:09","0",null,null,null,"2020-07-05","2020-09-04","2 months ccontract. Changed unit from C15-022. Storage deposit $810 transferred from agreement C15-CT206937\t to this agreement. The balance of storage rental and deposit $720 paid by cash on Jul 04, 2020.","2020-07-05","8.1",0,null,810,"810.00","2","2020-07-04 11:21:08","2","2020-07-04 11:21:08","CASH","","","","CASH","","","",null,0,"0012438313","C191162","PERSONAL","Mr","kK6O4cvejURBlLFNL3cxRw==","S4G\/mAL7JqKp0fexKE1ZAw==","","COSStYu3nYWCt65bYByfnrR2qrG9KR9KDh0n095s0i0+e4fV9HaAeWsR7UiQ0n0euJbHoV8EOx1ZNWad\/yutiumoys3IOH4Klpamw8sgAD8=","dWYAfo0\/9cJKyEebDxEasA==","COEHnPHgj2oSvRI\/ZoDC5bXdm9rJigTklhy4ISop\/M4=","A7uY+uIowF\/PhYXYKPYjnw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8289","1451","510.0","510.00","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-05","2020-09-04","1451"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8289","C15-D205521","PAID",510,0,"2020-09-04","2020-07-04 11:21:08","2020-07-04 11:21:08","2","2020-07-04 11:21:08","2","2020-07-04 11:21:08","1162"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8289","1162","SETTLED","C15-I208618","2020-07-04 11:21:08","2020-07-05","2","2020-07-04 11:21:08","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8618","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-04 11:21:08","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8618","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,210,"MO","1",210,"2","2020-07-04 11:21:08","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[210,0,"8618"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1162","CASH","","","","CASH","","","","PAID","P208261","2020-07-04 11:21:08",720,"2","2020-07-04 11:21:08","2","2020-07-04 11:21:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8261","DEPOSIT","5521","PAID","2020-07-04 11:21:08",510,"2","2020-07-04 11:21:08","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:21:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8261","INVOICE","8618","PAID","2020-07-04 11:21:08",210,"2","2020-07-04 11:21:08","2","2020-07-04 11:21:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","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=2&filter2=1162&filter3=undefined","floor_plan_rent_room":[{"room_id":"1451","master_room_id":"158","room_code":"C15-145"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":978,"customer_code":"C180978","identity_type":"PERSONAL","identity_id":"E408602(4)","title":"Mr","lastname":"Wong","firstname":"Kai Wai Martin","companyname":"","email":null,"tel":"63831437","address":"Flat G, 20\/F, Block 6, Greenwood TCE, Chai Wan","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1177.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-06","renew_room_key":"0005798792","renew_remark":"3 months contract. Storage rental paid by bank transfer on Apr 05,2020. Storage deposit $2476 transferred from agreement C15-CT206857 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207570, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"172","order_discount":[{"master_room_discount_id":"417","master_room_id":"172","discount_type":"%","price":"1115.00","disocunted_price":"1059.90","discount":"4.94","monthly_deduct":55.081,"room_id":"1342","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1342","room_code":"C15-036","retail_price":"1115.0","discounted_price":1059.9,"location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1177,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3531,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2020-10-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jul 03,2020. Storage deposit $2476 transferred from agreement C15-CT207570 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3531,"final_order_total":3531,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005798792","order_product":[],"pass":true}},"first_order_id":"4856","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-036 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1177.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",978,"NEW","C15-CT208290",1115,1177,0,0,"3","3",3531,3531,3531,"2020-07-04 11:44:20","0",null,null,null,"2020-07-06","2020-10-05","3 months contract. Storage rental paid by bank transfer on Jul 03,2020. Storage deposit $2476 transferred from agreement C15-CT207570 to this agreement. ","2020-07-06","20",0,null,0,"0","2","2020-07-04 11:44:20","2","2020-07-04 11:44:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005798792","C180978","PERSONAL","Mr","B4DvkaXR+2uW4nB0kNvBxw==","hULSwM2MvFtpeV9\/z+er8Q==","","0B8cLHOf6C\/Kvk83A2p19oDSz7o4mfYZd7BQKEzYdvyxARKYEv33Ku9dE3mmPEht","lK2kPobp9I3q15oR22TAYg==",null,"x6+djBnhvNr3E7FYmFG0Rw==",null,1,"4856"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8290","417","172","1342","%","4.94",55.081,"2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8290","1342","1115.0",1059.9,"2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2020-10-05","1342"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8290",978,"SETTLED","C15-I208619","2020-07-04 11:44:20","2020-07-06","2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8619","RENT","\u9810\u7e73\u79df\u91d1",1,1177,"MO","1",1177,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8619","RENT","\u9810\u7e73\u79df\u91d1",2,1177,"MO","1",1177,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8619","RENT","\u9810\u7e73\u79df\u91d1",3,1177,"MO","1",1177,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3531,0,"8619"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[978,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208262","2020-07-04 11:44:20",3531,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","DEPOSIT",null,"PAID","2020-07-04 11:44:20",0,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 11:44:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","INVOICE","8619","PAID","2020-07-04 11:44:20",3531,"2","2020-07-04 11:44:20","2","2020-07-04 11:44:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:05:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:18:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:07","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1447,"customer_code":"C191447","identity_type":"PERSONAL","identity_id":"E200086(9)","title":"Mr","lastname":"LEE","firstname":"Kwong Sang","companyname":"","email":"lksjardine@yahoo.com.hk","tel":"98386158","address":"Rm 1803, 18\/F, King Fai House, Yue Fai Cout, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"4","renew_warehousing_date":"2020-07-22","renew_room_key":"191,03201","renew_remark":"4 months contract. Storage rental paid by cash on March 7, 2020. Storage deposit $1196 transferred from agreement A14-CT196422 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A14-CT196422, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207345, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"609","room_code":"M20","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-22","rent_from":"2020-07-22","rent_to":"2020-09-21","delivery_service":"0","remark":"2 months contract. Storage rental paid by cash on Jul 4, 2020. Storage deposit $1196 transferred from agreement A14-CT207345 to this agreement.\r\n\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207345, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1,196.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03201","order_product":[],"pass":true}},"first_order_id":"6422","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M20 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1447,"NEW","A14-CT208291",598,598,0,0,"2","2",1196,1196,1196,"2020-07-04 12:19:08","0",null,null,null,"2020-07-22","2020-09-21","2 months contract. Storage rental paid by cash on Jul 4, 2020. Storage deposit $1196 transferred from agreement A14-CT207345 to this agreement.\r\n\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207345, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1,196.0","2020-07-22","12",0,null,0,"0","2","2020-07-04 12:19:07","2","2020-07-04 12:19:07","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"191,03201","C191447","PERSONAL","Mr","r7ZMw5+gvVPJEbOGvzW2eA==","brgGVGuPrfoSjI4k+kLGow==","","vwhP+yYU979j1IYrPaAewIRPS8ehlS1H96rdTWSLd7qM5Oal0cPlaQyzHMh9\/xwFb2hdzm8MH12mYhqzH\/mnjrpbzlu+e+Og146xkagM+R0=","9fB1C9GBClx2SST6Fs3MQA==","LzSRnclRfzwcqs62h9RfY8XSQVhof\/4Xatlmf9a\/HHg=","nCw6FUnPF7aVTQtKLG0isQ==",null,1,"6422"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8291","609","598.0","598.00","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2020-09-21","609"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8291",1447,"SETTLED","A14-I208620","2020-07-04 12:19:07","2020-07-22","2","2020-07-04 12:19:07","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8620","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-04 12:19:07","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8620","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-07-04 12:19:07","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"8620"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1447,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208263","2020-07-04 12:19:07",1196,"2","2020-07-04 12:19:07","2","2020-07-04 12:19:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8263","DEPOSIT",null,"PAID","2020-07-04 12:19:07",0,"2","2020-07-04 12:19:07","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8263","INVOICE","8620","PAID","2020-07-04 12:19:07",1196,"2","2020-07-04 12:19:07","2","2020-07-04 12:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:24","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":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"860","master_room_id":"81","room_code":"T04"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> T04 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K624932(9)","title":"Ms","lastname":"LO","firstname":"Lai Ming Christina","companyname":"","email":"christina_com@hotmial.com","tel":"92781107","address":"Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"268","master_room_id":"81","discount_type":"%","price":"2298.00","disocunted_price":"2182.90","discount":"5.01","monthly_deduct":115.1298,"room_id":"860","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"860","room_code":"T04","retail_price":"2298.0","discounted_price":2182.9,"location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":4596,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8043,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3447.00","warehousing_date":"2020-07-18","rent_from":"2020-07-18","rent_to":"2020-10-17","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 4, 2020. Smartcard provided on July 4, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3447,"order_total":11490,"final_order_total":8043,"location_id":"3","branch_id":"1","company_id":"1","room_key":"191, 03241","order_product":[],"pass":true}},"roughly_size":"30","total_discounted_price":"2298.00","deposit":"4596.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201656","PERSONAL","Ms","uCYI2d3\/agWnydECWPoSkWJLX7O65d4LaIx\/WbxeuWc=","DyZn7f2tPwMiXMp09gXvdg==","","PuiSNZRyy58m8ClIbwP+Yw==","vloJIz9ilNFSH4pnW3eLD7L9H4C5z\/HMOTKU0MmoVCc=","35SNWI\/2m\/cw2EOiTw2+TSr0bSvQR2jP7YMw8UeHhBY=","fTno80r6jWSUCINe5Ksacw==",null,"vloJIz9ilNFSH4pnW3eLD7L9H4C5z\/HMOTKU0MmoVCc=","G\/Ocmh+Voyk45UVMsEzV3Q==","2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1656,"NEW","A18-CT208292",2298,2298,4596,0,"3","3",8043,11490,8043,"2020-07-04 12:39:26","0",null,null,null,"2020-07-18","2020-10-17","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 4, 2020. Smartcard provided on July 4, 2020. ","2020-07-18","30",0,null,3447,"3447.00","2","2020-07-04 12:39:24","2","2020-07-04 12:39:24","EPS","","","","EPS","","","",null,0,"191, 03241","C201656","PERSONAL","Ms","uCYI2d3\/agWnydECWPoSkWJLX7O65d4LaIx\/WbxeuWc=","DyZn7f2tPwMiXMp09gXvdg==","","35SNWI\/2m\/cw2EOiTw2+TSr0bSvQR2jP7YMw8UeHhBY=","PuiSNZRyy58m8ClIbwP+Yw==","vloJIz9ilNFSH4pnW3eLD7L9H4C5z\/HMOTKU0MmoVCc=","fTno80r6jWSUCINe5Ksacw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8292","268","81","860","%","5.01",115.1298,"2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8292","860","2298.0",2182.9,"2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-18","2020-10-17","860"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8292","A18-D205522","PAID",4596,0,"2020-10-17","2020-07-04 12:39:24","2020-07-04 12:39:24","2","2020-07-04 12:39:24","2","2020-07-04 12:39:24",1656]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8292",1656,"SETTLED","A18-I208621","2020-07-04 12:39:24","2020-07-18","2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8621","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8621","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1149,"MO","1",1149,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8621","RENT","\u9810\u7e73\u79df\u91d1",3,2298,"MO","1",2298,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3447,0,"8621"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1656,"EPS","","","","EPS","","","","PAID","P208264","2020-07-04 12:39:24",8043,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8264","DEPOSIT","5522","PAID","2020-07-04 12:39:24",4596,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 12:39:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8264","INVOICE","8621","PAID","2020-07-04 12:39:24",3447,"2","2020-07-04 12:39:24","2","2020-07-04 12:39:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:16","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"655","master_room_id":"30","room_code":"M66"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M66 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z612413(6)","title":"Ms","lastname":"LEUNG","firstname":"Man Ching","companyname":"","email":"","tel":"61302194","address":"Flat 1611, 16\/F, Pik Long House, Shek Pei Wan Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"655","room_code":"M66","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":1550,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2287,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"38.00","warehousing_date":"2020-07-11","rent_from":"2020-07-11","rent_to":"2020-08-10","delivery_service":"0","remark":"1 month contract. Special \"Rent Now\" offer 5% off. Storage rental and deposit paid by EPS on July 4, 2020. Smartcard provided on July 4, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":38,"order_total":2325,"final_order_total":2287,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190, 26651","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201657","PERSONAL","Ms","0i9Q6pWm5uHfxFKiszl9yg==","yXKc2lCF323ApRADrjNaSg==","","Hok6i53WZXAwOvoCBi4nTg==",null,"kESStI1EtlJa5flB\/4HxXn9EQQbYX83dQHyM5h8eDO+3cEW2J2iNQIYeTu4UNsuRSvEWG6knFnINERUItzNWsYt4rEUdxpB7HtBxpjwFnb8=","fRq33T\/xoZ8X7mop6wrwwQ==",null,null,"QvPMZOKj4Q0QbkUD6FmZRQ==","2","2020-07-04 13:09:16","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1657,"NEW","A14-CT208293",775,775,1550,0,"1","1",2287,2325,2287,"2020-07-04 13:09:18","0",null,null,null,"2020-07-11","2020-08-10","1 month contract. Special \"Rent Now\" offer 5% off. Storage rental and deposit paid by EPS on July 4, 2020. Smartcard provided on July 4, 2020. ","2020-07-11","9",0,null,38,"38.00","2","2020-07-04 13:09:16","2","2020-07-04 13:09:16","EPS","","","","EPS","","","",null,0,"190, 26651","C201657","PERSONAL","Ms","0i9Q6pWm5uHfxFKiszl9yg==","yXKc2lCF323ApRADrjNaSg==","","kESStI1EtlJa5flB\/4HxXn9EQQbYX83dQHyM5h8eDO+3cEW2J2iNQIYeTu4UNsuRSvEWG6knFnINERUItzNWsYt4rEUdxpB7HtBxpjwFnb8=","Hok6i53WZXAwOvoCBi4nTg==",null,"fRq33T\/xoZ8X7mop6wrwwQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8293","655","775.0","775.00","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-11","2020-08-10","655"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8293","A14-D205523","PAID",1550,0,"2020-08-10","2020-07-04 13:09:16","2020-07-04 13:09:16","2","2020-07-04 13:09:16","2","2020-07-04 13:09:16",1657]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8293",1657,"SETTLED","A14-I208622","2020-07-04 13:09:16","2020-07-11","2","2020-07-04 13:09:16","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8622","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,737,"MO","1",737,"2","2020-07-04 13:09:16","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[737,0,"8622"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1657,"EPS","","","","EPS","","","","PAID","P208265","2020-07-04 13:09:16",2287,"2","2020-07-04 13:09:16","2","2020-07-04 13:09:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8265","DEPOSIT","5523","PAID","2020-07-04 13:09:16",1550,"2","2020-07-04 13:09:16","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8265","INVOICE","8622","PAID","2020-07-04 13:09:16",737,"2","2020-07-04 13:09:16","2","2020-07-04 13:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:25:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:25:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 13:28:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","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":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 05,2020. Storage deposit $1322 transferred from agreement C15-CT207745 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208058, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 04,2020. Storage deposit $1322 transferred from agreement C15-CT208058 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-115 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1185,"NEW","C15-CT208294",1322,1322,0,0,"1","1",1322,1322,1322,"2020-07-04 14:53:04","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by bank transfer on Jul 04,2020. Storage deposit $1322 transferred from agreement C15-CT208058 to this agreement.","2020-07-01","24",0,null,0,"0","2","2020-07-04 14:53:04","2","2020-07-04 14:53:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8294","1421","1322.0","1322.00","2","2020-07-04 14:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8294",1185,"SETTLED","C15-I208623","2020-07-04 14:53:04","2020-07-01","2","2020-07-04 14:53:04","2","2020-07-04 14:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8623","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-07-04 14:53:04","2","2020-07-04 14:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"8623"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208266","2020-07-04 14:53:04",1322,"2","2020-07-04 14:53:04","2","2020-07-04 14:53:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8266","DEPOSIT",null,"PAID","2020-07-04 14:53:04",0,"2","2020-07-04 14:53:04","2","2020-07-04 14:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 14:53:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8266","INVOICE","8623","PAID","2020-07-04 14:53:04",1322,"2","2020-07-04 14:53:04","2","2020-07-04 14:53:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 15:44:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-04 15:47:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****