{"created_at":"2020-07-17 00:12:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 09:40:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 09:53:41","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 09:56:35","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:01:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:03:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:08:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:09:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":1341,"customer_code":"C191341","identity_type":"PERSONAL","identity_id":"P729305(8)","title":"Ms","lastname":"LUONG","firstname":"Vanessa","companyname":"","email":"vanessaluongvl@gmail.com","tel":"60439018","address":"Rm 904, Heng Fa Chuen, Block 11, 100 Shing Tai Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1021.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-21","renew_room_key":"","renew_remark":"12 months contract. Special offer 2 months free and 5% "rent now" discount. $1000 deposit paid by EPS on June 27, 2019. Remaining storage rental and deposit paid by bank transfer on July 19, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195532, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2616.0","renew_master_room_id":"141","order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1199","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1199","room_code":"B01-009","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"20","total_retail_price":1308,"total_discounted_price":1021,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12252,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-21","rent_from":"2020-07-21","rent_to":"2021-07-20","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit $2616 transferred from agreement B01-CT195532 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12252,"final_order_total":12252,"location_id":"5","branch_id":"2","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":5532,"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>
B01-009 <\/td>\r\n\t\t\t\t\t	4X5X7 <\/td>\r\n\t\t\t\t\t	$1308.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\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":"1021.0","deposit":"0","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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","2","5",1341,"NEW","B01-CT208411",1308,1021,0,0,"12","12",12252,12252,12252,"2020-07-17 10:10:36","0",null,null,null,"2020-07-21","2021-07-20","12 months contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit $2616 transferred from agreement B01-CT195532 to this agreement.\r\n","2020-07-21","20",0,null,0,"0","2","2020-07-17 10:10:36","2","2020-07-17 10:10:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"","C191341","PERSONAL","Ms","tL80OgDCowCaDe5cHAFTkA==","qWxEEhxqmk2b3ZGR\/COk0g==","","4t7Tv3M3ei5ESyE2fto2dnSsaN1bSZuCSiuxxGzV6Uw3AsR4rH8XneeyzMtwkSo6kba+ynJVEfHNwfRvurgU7A==","7lwuujbEfoDrdx0AbWp8Ug==","hNF9fo5FVjAkS6OtJr+itDt+sNBhYqyxlpFXALbn0JQ=","4YZBAgkVsWQmkgk2Z0FCyQ==",null,1,5532]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8411","342","141","1199","%","34.94",457.0152,"2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8411","1199","1308.0",851,"2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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-21","2021-07-20","1199"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 10:10:36","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":["8411",1341,"SETTLED","B01-I208740","2020-07-17 10:10:36","2020-07-21","2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",1,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",2,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",3,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",4,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",5,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",6,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",7,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",8,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",9,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",10,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",11,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8740","RENT","\u9810\u7e73\u79df\u91d1",12,1021,"MO","1",1021,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12252,0,"8740"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 10:10:36","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":[1341,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208383","2020-07-17 10:10:36",12252,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8383","DEPOSIT",null,"PAID","2020-07-17 10:10:36",0,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:10:36","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":["8383","INVOICE","8740","PAID","2020-07-17 10:10:36",12252,"2","2020-07-17 10:10:36","2","2020-07-17 10:10:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:11:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:15:37","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","","12 months contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $2616 transferred from agreement B01-CT195532 to this agreement.\r\n","2020-07-17 10:15:37","2","qWxEEhxqmk2b3ZGR\/COk0g==","tL80OgDCowCaDe5cHAFTkA==","hNF9fo5FVjAkS6OtJr+itDt+sNBhYqyxlpFXALbn0JQ=","7lwuujbEfoDrdx0AbWp8Ug==","4t7Tv3M3ei5ESyE2fto2dnSsaN1bSZuCSiuxxGzV6Uw3AsR4rH8XneeyzMtwkSo6kba+ynJVEfHNwfRvurgU7A==",8411]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:30:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:30:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:38:05","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","","12 months contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $2616 transferred from agreement B01-CT195532 to this agreement.\r\n","2020-07-17 10:38:05","2","qWxEEhxqmk2b3ZGR\/COk0g==","tL80OgDCowCaDe5cHAFTkA==","hNF9fo5FVjAkS6OtJr+itDt+sNBhYqyxlpFXALbn0JQ=","7lwuujbEfoDrdx0AbWp8Ug==","dI+geWgq1470tllYk3iJPQ7T1SXRM5HMEdthJzEbaau5NZvpadcfrex2140+SIo9PJgZy8oSiMcDvd1b3xXFWGqPlPnBLzNjWHVE8jtX\/oY=",8411]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:39:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 10:47:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12:26","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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-18","renew_room_key":"055,34812","renew_remark":"1 month contract. Storage rental paid by cheque on June 18, 2020. Storage deposit transferred from agreement A12-CT207879 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208168, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"13","order_discount":[],"order_room":[{"room_id":"2","room_code":"A02","retail_price":"2058.0","discounted_price":"2058.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-18","rent_from":"2020-07-18","rent_to":"2020-08-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on July 17, 2020. Storage deposit transferred from agreement A12-CT208168 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> A02 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\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":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",18,"NEW","A12-CT208412",2058,1860,0,0,"1","1",1860,1860,1860,"2020-07-17 11:12:26","0",null,null,null,"2020-07-18","2020-08-17","1 month contract. Storage rental paid by cheque on July 17, 2020. Storage deposit transferred from agreement A12-CT208168 to this agreement.\r\n","2020-07-18","28",0,null,0,"0","2","2020-07-17 11:12:26","2","2020-07-17 11:12:26","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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":["8412","2","2058.0","2058.00","2","2020-07-17 11:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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-08-17","2"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 11:12: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":["8412",18,"SETTLED","A12-I208741","2020-07-17 11:12:26","2020-07-18","2","2020-07-17 11:12:26","2","2020-07-17 11:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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":["8741","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-07-17 11:12:26","2","2020-07-17 11:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"8741"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 11:12: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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208384","2020-07-17 11:12:26",1860,"2","2020-07-17 11:12:26","2","2020-07-17 11:12:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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":["8384","DEPOSIT",null,"PAID","2020-07-17 11:12:26",0,"2","2020-07-17 11:12:26","2","2020-07-17 11:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:12: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":["8384","INVOICE","8741","PAID","2020-07-17 11:12:26",1860,"2","2020-07-17 11:12:26","2","2020-07-17 11:12:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-02","renew_room_key":"053,34812","renew_remark":"1 month contract. Storage rental paid by cheque on June 18, 2020. Storage deposit transferred from agreement A12-CT207880 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208169, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"141","room_code":"C17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-02","rent_from":"2020-07-02","rent_to":"2020-08-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on July 17, 2020. Storage deposit transferred from agreement A12-CT208169 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> C17 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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","1",18,"NEW","A12-CT208413",1098,1038,0,0,"1","1",1038,1038,1038,"2020-07-17 11:13:53","0",null,null,null,"2020-07-02","2020-08-01","1 month contract. Storage rental paid by cheque on July 17, 2020. Storage deposit transferred from agreement A12-CT208169 to this agreement.\r\n","2020-07-02","16",0,null,0,"0","2","2020-07-17 11:13:53","2","2020-07-17 11:13:53","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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":["8413","141","1098.0","1098.00","2","2020-07-17 11:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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-02","2020-08-01","141"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 11:13:53","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":["8413",18,"SETTLED","A12-I208742","2020-07-17 11:13:53","2020-07-02","2","2020-07-17 11:13:53","2","2020-07-17 11:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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":["8742","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-17 11:13:53","2","2020-07-17 11:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8742"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 11:13:53","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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208385","2020-07-17 11:13:53",1038,"2","2020-07-17 11:13:53","2","2020-07-17 11:13:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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":["8385","DEPOSIT",null,"PAID","2020-07-17 11:13:53",0,"2","2020-07-17 11:13:53","2","2020-07-17 11:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:13:53","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":["8385","INVOICE","8742","PAID","2020-07-17 11:13:53",1038,"2","2020-07-17 11:13:53","2","2020-07-17 11:13:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:21:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:57:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:05","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":382,"customer_code":"C170382","identity_type":"PERSONAL","identity_id":"D198734(9)","title":"Mr","lastname":"Mak","firstname":"Kwok Kee","companyname":"","email":"mak1689@hotmail.com","tel":"98800001","address":"3B, Block 7, Yar Chee Villa,1A Chi Fu Road, Pokfulam, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1452.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-16","renew_room_key":"056,16081","renew_remark":"3 months contract. Storage rental and deposit paid by cheque on March 21, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207464, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3056.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"458","room_code":"J40","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1452,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4356,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-16","rent_from":"2020-07-16","rent_to":"2020-10-15","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Storage deposit $3056 transferred from agreement A14-CT207464 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4356,"final_order_total":4356,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,16081","order_product":[],"pass":true}},"first_order_id":7464,"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> J40 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1452.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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",382,"NEW","A14-CT208414",1528,1452,0,0,"3","3",4356,4356,4356,"2020-07-17 11:59:06","0",null,null,null,"2020-07-16","2020-10-15","3 months contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Storage deposit $3056 transferred from agreement A14-CT207464 to this agreement.\r\n","2020-07-16","20",0,null,0,"0","2","2020-07-17 11:59:05","2","2020-07-17 11:59:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,16081","C170382","PERSONAL","Mr","eBJBjFY7uKjwde5uLS4BHw==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","+2fk6hajVk5Okk\/mh4hTuMHY5p4mROtqlAkyJDDNq0\/vAZgaiHCZOi4aVnkr4gH6EzXGDLlnTURaSkRIrtFTCA==","7kaxy1wgl\/5Qqg+bBrakQg==","1NOBLk3RKWOO5Vakfhj9G0vWIcoMTuEqPiVJAfYGcSw=","dLdYENBkJnucZpAoABTrhA==",null,1,7464]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8414","458","1528.0","1528.00","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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-16","2020-10-15","458"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 11:59:06","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":["8414",382,"SETTLED","A14-I208743","2020-07-17 11:59:05","2020-07-16","2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8743","RENT","\u9810\u7e73\u79df\u91d1",1,1452,"MO","1",1452,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8743","RENT","\u9810\u7e73\u79df\u91d1",2,1452,"MO","1",1452,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8743","RENT","\u9810\u7e73\u79df\u91d1",3,1452,"MO","1",1452,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4356,0,"8743"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 11:59:06","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":[382,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208386","2020-07-17 11:59:05",4356,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8386","DEPOSIT",null,"PAID","2020-07-17 11:59:05",0,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 11:59:06","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":["8386","INVOICE","8743","PAID","2020-07-17 11:59:05",4356,"2","2020-07-17 11:59:05","2","2020-07-17 11:59:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1595,"customer_code":"C201595","identity_type":"BUSINESS","identity_id":"65680342","title":"Ms","lastname":"KWOK","firstname":"Pik Shan","companyname":"H AND H WORKS LIMITED","email":"handhworks.hk@gmail.com","tel":"61633563","address":"Shop 1B, G\/F, Kai Wong Commercial Building, 49-51A Cough Street Central, H.K.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-29","renew_room_key":"","renew_remark":"1 month contract. Storage rental and deposit paid by EPS on May 28, 2020. Smartcard and password lock provided on May 28, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: WC-CT207982, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"236","order_discount":[],"order_room":[{"room_id":"1738","room_code":"WC-31","retail_price":"1888.0","discounted_price":"1888.00","location_id":"8"}],"roughly_size":"16","total_retail_price":1888,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-29","rent_from":"2020-06-29","rent_to":"2020-07-28","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by EPS on Jul 17, 2020. Smartcard and password lock provided on May 28, 2020. Storage deposit $3210 transferred from agreement WC-CT207982 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"8","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":7982,"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> WC-31 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1888.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":"16","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1888.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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","8",1595,"NEW","WC-CT208415",1888,1605,0,0,"1","1",1605,1605,1605,"2020-07-17 13:07:11","0",null,null,null,"2020-06-29","2020-07-28","1 month contract. Storage rental and deposit paid by EPS on Jul 17, 2020. Smartcard and password lock provided on May 28, 2020. Storage deposit $3210 transferred from agreement WC-CT207982 to this agreement.\r\n","2020-06-29","16",0,null,0,"0","2","2020-07-17 13:07:11","2","2020-07-17 13:07:11","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"","C201595","BUSINESS","Ms","q40Jz7KgXsE+y74j2rZ59Q==","bGWftO7QHB1VrLc6D5WiAA==","H AND H WORKS LIMITED","J4k4jtzM79uSoozLNGzaVKZYBr7Y+ewm1DBCj3LplyiBc99nz\/6YZ0+Q2v9TfdQUAtyLdzowUVHupMzWMOf\/90Ku7UX3cB0pz70YKeUjIBE=","U3G+JVqoAbCGIWWCAWYkCw==","0zkW7P37hijyDT9vbr6yOrS+xolTu1sgR2Ib8R9oXa8=",null,"F19SjGwo1T71+np8dW8Fww==",1,7982]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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":["8415","1738","1888.0","1888.00","2","2020-07-17 13:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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-06-29","2020-07-28","1738"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 13:07:11","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":["8415",1595,"SETTLED","WC-I208744","2020-07-17 13:07:11","2020-06-29","2","2020-07-17 13:07:11","2","2020-07-17 13:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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":["8744","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-07-17 13:07:11","2","2020-07-17 13:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8744"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 13:07:11","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":[1595,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208387","2020-07-17 13:07:11",1605,"2","2020-07-17 13:07:11","2","2020-07-17 13:07:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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":["8387","DEPOSIT",null,"PAID","2020-07-17 13:07:11",0,"2","2020-07-17 13:07:11","2","2020-07-17 13:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:07:11","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":["8387","INVOICE","8744","PAID","2020-07-17 13:07:11",1605,"2","2020-07-17 13:07:11","2","2020-07-17 13:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:18:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"2","renew_warehousing_date":"2020-07-24","renew_room_key":"133,33462","renew_remark":"2 months contract. Storage rental paid by bank transfer on May 18, 2020 and June 25, 2020. Storage deposit transferred from agreement A14-CT207709 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208223, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-24","rent_from":"2020-07-24","rent_to":"2020-08-23","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on Jul 17, 2020. Storage deposit transferred from agreement A14-CT208223 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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> M36 <\/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-17 13:20:35","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",469,"NEW","A14-CT208416",598,598,0,0,"1","1",598,598,598,"2020-07-17 13:20:35","0",null,null,null,"2020-07-24","2020-08-23","1 months contract. Storage rental paid by bank transfer on Jul 17, 2020. Storage deposit transferred from agreement A14-CT208223 to this agreement.\r\n","2020-07-24","12",0,null,0,"0","2","2020-07-17 13:20:35","2","2020-07-17 13:20:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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":["8416","625","598.0","598.00","2","2020-07-17 13:20:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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-24","2020-08-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 13:20:35","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":["8416",469,"SETTLED","A14-I208745","2020-07-17 13:20:35","2020-07-24","2","2020-07-17 13:20:35","2","2020-07-17 13:20:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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":["8745","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-17 13:20:35","2","2020-07-17 13:20:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8745"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 13:20:35","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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208388","2020-07-17 13:20:35",598,"2","2020-07-17 13:20:35","2","2020-07-17 13:20:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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":["8388","DEPOSIT",null,"PAID","2020-07-17 13:20:35",0,"2","2020-07-17 13:20:35","2","2020-07-17 13:20:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:20:35","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":["8388","INVOICE","8745","PAID","2020-07-17 13:20:35",598,"2","2020-07-17 13:20:35","2","2020-07-17 13:20:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:28:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:46:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:46:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 13:48:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 15:54:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 15:54:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 15:55:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 15:58:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 16:59:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 17:24:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 17:25:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:50","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":708,"customer_code":"C180708","identity_type":"PERSONAL","identity_id":"P208633(A)","title":"Mr","lastname":"Lam","firstname":"Henry Hang Ling","companyname":"","email":"henrylam@email.com","tel":"62300702","address":"16D, Goldwin Heights, 2 Seymour Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2434.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-14","renew_room_key":"054,60414","renew_remark":"1 month contract. Storage rental $2400 paid by bank transfer on JUNE 16, 2020. Remaining balance $32 transferred from agreement A18-CT207622. Storage deposit $2 deducted from deposit. Deposit transferred from agreement A18-CT207860 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208182, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"868","room_code":"T12","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"867","room_code":"T11","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2434,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2434,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-07-13","delivery_service":"0","remark":"1 month contract. Storage rental $2500 paid by bank transfer on July 16, 2020. Storage deposit deducted from deposit. Deposit transferred from agreement A18-CT208182 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2434,"final_order_total":2434,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60414","order_product":[],"pass":true}},"first_order_id":"4723","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\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> T12 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.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> T11 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.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":"32","total_discounted_price":"2434.0","deposit":"0","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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","3",708,"NEW","A18-CT208417",2580,2434,0,0,"1","1",2434,2434,2434,"2020-07-17 19:01:51","0",null,null,null,"2020-06-14","2020-07-13","1 month contract. Storage rental $2500 paid by bank transfer on July 16, 2020. Storage deposit deducted from deposit. Deposit transferred from agreement A18-CT208182 to this agreement.\r\n","2020-06-14","32",0,null,0,"0","2","2020-07-17 19:01:50","2","2020-07-17 19:01:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60414","C180708","PERSONAL","Mr","PTa9TkkuKfu4jwNnLRl7bA==","0JxYUqbNPOvgfMwVa0l0NA==","","FqEbl\/Vqia+apcWATmy0qI1jVSPGOQv+s8CLECBrdrOwYgMK2yudpo3PYRdJhmZi","NGbsOMu\/dtiprozEMsHWzw==","jy7Rom83Y2MCQ+LKg3+jO+YsY98Vm1g+iOp8lmmscAc=","ZEEfmQxu1lN8ppqH8XvTbg==",null,1,"4723"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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":["8417","868","1290.0","1290.00","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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-06-14","2020-07-13","868"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 19:01:51","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":["8417","867","1290.0","1290.00","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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-06-14","2020-07-13","867"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 19:01:51","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":["8417",708,"SETTLED","A18-I208746","2020-07-17 19:01:50","2020-06-14","2","2020-07-17 19:01:50","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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":["8746","RENT","\u9810\u7e73\u79df\u91d1",1,2434,"MO","1",2434,"2","2020-07-17 19:01:50","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2434,0,"8746"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 19:01:51","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":[708,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208389","2020-07-17 19:01:50",2434,"2","2020-07-17 19:01:50","2","2020-07-17 19:01:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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":["8389","DEPOSIT",null,"PAID","2020-07-17 19:01:50",0,"2","2020-07-17 19:01:50","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:01:51","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":["8389","INVOICE","8746","PAID","2020-07-17 19:01:50",2434,"2","2020-07-17 19:01:50","2","2020-07-17 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1195.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-02","renew_room_key":"052,40523","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A18-CT207583 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208056, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1195,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-02","rent_from":"2020-06-02","rent_to":"2020-07-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit transferred from agreement A18-CT208056 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1195,"final_order_total":1195,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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> Q12 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1195.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":"18","total_discounted_price":"1195.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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","3",629,"NEW","A18-CT208418",1195,1195,0,0,"1","1",1195,1195,1195,"2020-07-17 19:03:02","0",null,null,null,"2020-06-02","2020-07-01","1 month contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit transferred from agreement A18-CT208056 to this agreement.\r\n","2020-06-02","18",0,null,0,"0","2","2020-07-17 19:03:02","2","2020-07-17 19:03:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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":["8418","815","1195.0","1195.00","2","2020-07-17 19:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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-06-02","2020-07-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 19:03:02","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":["8418",629,"SETTLED","A18-I208747","2020-07-17 19:03:02","2020-06-02","2","2020-07-17 19:03:02","2","2020-07-17 19:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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":["8747","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-07-17 19:03:02","2","2020-07-17 19:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1195,0,"8747"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 19:03:02","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":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208390","2020-07-17 19:03:02",1195,"2","2020-07-17 19:03:02","2","2020-07-17 19:03:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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":["8390","DEPOSIT",null,"PAID","2020-07-17 19:03:02",0,"2","2020-07-17 19:03:02","2","2020-07-17 19:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:03:02","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":["8390","INVOICE","8747","PAID","2020-07-17 19:03:02",1195,"2","2020-07-17 19:03:02","2","2020-07-17 19:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:18","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&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1057,"customer_code":"C181057","identity_type":"PERSONAL","identity_id":"D308847(3)","title":"Ms","lastname":"Lam ","firstname":"Shun Wai, Annie","companyname":"","email":"annielam2009@gmail.com","tel":"96813840","address":"Flat 5, 4\/F, Kong Fu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2161.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-16","renew_room_key":"\u20190006005603","renew_remark":"1 month contract. Storage rental paid by bank transfer on JUNE 19, 2020. Storage deposit $8644 transferred from agreement A05-CT207877 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT208180, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"118","order_discount":[],"order_room":[{"room_id":"1156","room_code":"A05-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"4"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-16","rent_from":"2020-07-16","rent_to":"2020-08-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $8644 transferred from agreement A05-CT208180 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"4","branch_id":"1","company_id":"1","room_key":"\u20190006005603","order_product":[],"pass":true}},"first_order_id":"3553","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> A05-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"2161.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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","4",1057,"NEW","A05-CT208419",2161,2161,0,0,"1","1",2161,2161,2161,"2020-07-17 19:04:19","0",null,null,null,"2020-07-16","2020-08-15","1 month contract. Storage rental paid by bank transfer on July 16, 2020. Storage deposit $8644 transferred from agreement A05-CT208180 to this agreement. \r\n","2020-07-16","28",0,null,0,"0","2","2020-07-17 19:04:18","2","2020-07-17 19:04:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"\u20190006005603","C181057","PERSONAL","Ms","1j\/EaXCwy81\/xtzbEcCIFg==","QW3H3bgt0C82y0s8QGTa0Q==","","f1Otee2exetSDY63KBCMB5p99mgzhZTcsXOUKcOm9HaGtL064AfZdfe5l6eIALO\/p8OTtANqNTg0DUdmmdQX\/I8owGh\/TPajPJqQ7N4t7i4=","g0N0c22b7twgi3MLXRIFsA==","M7r\/KEoRB4HilLKSFse6TNWqfcF7SJDkKhW++\/2WmZg=","TkzecISdNbJR\/TrRV20KnA==",null,1,"3553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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":["8419","1156","2161.0","2161.00","2","2020-07-17 19:04:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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-16","2020-08-15","1156"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-17 19:04:19","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":["8419",1057,"SETTLED","A05-I208748","2020-07-17 19:04:18","2020-07-16","2","2020-07-17 19:04:18","2","2020-07-17 19:04:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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":["8748","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-07-17 19:04:18","2","2020-07-17 19:04:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"8748"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-17 19:04:19","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":[1057,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208391","2020-07-17 19:04:18",2161,"2","2020-07-17 19:04:18","2","2020-07-17 19:04:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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":["8391","DEPOSIT",null,"PAID","2020-07-17 19:04:18",0,"2","2020-07-17 19:04:18","2","2020-07-17 19:04:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:04:19","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":["8391","INVOICE","8748","PAID","2020-07-17 19:04:18",2161,"2","2020-07-17 19:04:18","2","2020-07-17 19:04:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-17 19:17:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****