\n \n \n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A16-059 <\/td>\n\t\t\t\t\t	3X3X7 <\/td>\n\t\t\t\t\t	$1006.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201561","PERSONAL","Mr","nuN6gj2LPp9ur5A8a\/Hgyg==","8BEgNhGpCR8jGkzUtrIcXg==","","wiKnJxVAFbPY+gydfcr9cw==","i91Qy60Js+N4AFT4S3iSC9O2Z1QjXXsBLpL7rN0116Y=","wqM1+ACvLj6g1tX0wtWlyCT3KOwn0Ad9yp6YuxSWDPCTAQUZROgh2KKrb35EzWN9bw0296fHB\/ZHJVpM4dc9G6+jmRS3I77cgvoRats0c0I=","taCX4\/5xBNoFoJRxNIQJaQ==",null,"i91Qy60Js+N4AFT4S3iSC9O2Z1QjXXsBLpL7rN0116Y=","v1usvKr8sFF\/6vBf5TTY3Q==","2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1561,"NEW","A16-CT207642",1006,775,1550,0,"13","13",9689,11625,9689,"2020-04-16 16:00:52","0",null,null,null,"2020-05-01","2021-05-31","13 months contract. Special offer renew price $775\/month. First 3 months 50% off and the 13th month free. Storage rental and deposit paid by EPS on April 16, 2020. Smartcard provided on April 16, 2020. ","2020-05-01","9",0,null,1936,"1936.00","2","2020-04-16 16:00:49","2","2020-04-16 16:00:49","EPS","","","","EPS","","","",null,0,"189, 02113","C201561","PERSONAL","Mr","nuN6gj2LPp9ur5A8a\/Hgyg==","8BEgNhGpCR8jGkzUtrIcXg==","","wqM1+ACvLj6g1tX0wtWlyCT3KOwn0Ad9yp6YuxSWDPCTAQUZROgh2KKrb35EzWN9bw0296fHB\/ZHJVpM4dc9G6+jmRS3I77cgvoRats0c0I=","wiKnJxVAFbPY+gydfcr9cw==","i91Qy60Js+N4AFT4S3iSC9O2Z1QjXXsBLpL7rN0116Y=","taCX4\/5xBNoFoJRxNIQJaQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7642","1550","1006.0","1006.00","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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-05-01","2021-05-31","1550"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-16 16:00:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7642","A16-D205370","PAID",1550,0,"2021-05-31","2020-04-16 16:00:49","2020-04-16 16:00:49","2","2020-04-16 16:00:49","2","2020-04-16 16:00:49",1561]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7642",1561,"SETTLED","A16-I207970","2020-04-16 16:00:49","2020-05-01","2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,389,"MO","1",389,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",4,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",5,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",6,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",7,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",8,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",9,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",10,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",11,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",12,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7970","RENT","\u9810\u7e73\u79df\u91d1",13,775,"MO","1",775,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8139,0,"7970"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-16 16:00:52","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":[1561,"EPS","","","","EPS","","","","PAID","P207617","2020-04-16 16:00:49",9689,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7617","DEPOSIT","5370","PAID","2020-04-16 16:00:49",1550,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:00:52","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":["7617","INVOICE","7970","PAID","2020-04-16 16:00:49",8139,"2","2020-04-16 16:00:49","2","2020-04-16 16:00:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11:25","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":454,"customer_code":"C170454","identity_type":"PERSONAL","identity_id":"A914369(9)","title":"Ms","lastname":"Lee","firstname":"So Ngor","companyname":"","email":null,"tel":"52125128","address":"Flat 2903,29\/F,Tung Hing Hse,Lei Tung Est,Ap Lei Chau,Hong Kong ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-15","renew_room_key":"052,21409","renew_remark":"6 months contract. Storage rental paid by cash on Oct 15, 2019. Storage deposit transferred from agreement A14-CT194752 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196145, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"598","room_code":"M09","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":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3588,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-15","rent_from":"2020-04-15","rent_to":"2020-10-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT196145 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3588,"final_order_total":3588,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,21409","order_product":[],"pass":true}},"first_order_id":"4752","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> M09 <\/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-04-16 16:11: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","2",454,"NEW","A14-CT207643",598,598,0,0,"6","6",3588,3588,3588,"2020-04-16 16:11:26","0",null,null,null,"2020-04-15","2020-10-14","6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT196145 to this agreement.\r\n","2020-04-15","12",0,null,0,"0","2","2020-04-16 16:11:25","2","2020-04-16 16:11:25","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,21409","C170454","PERSONAL","Ms","4I9Ho\/CYp0XRqSDUPoIrdQ==","kiriEIqhcx866RNZiMXdKQ==","","amES1vZiVrt9V6KWzRYS0JHr\/lO2HNvTD2TqKjVzvHgaEMvq\/3UMzbrGhX+h8rNxL9KKS9px0GaMywnh2qotkFBsXqDu1q6i1YOyWzfsLC0=","mgimlQ5WBwkpvOIWS7cpuQ==",null,"\/STHpl5zn2\/QZA61EtoJ6Q==",null,1,"4752"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7643","598","598.0","598.00","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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-04-15","2020-10-14","598"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-16 16:11: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":["7643",454,"SETTLED","A14-I207971","2020-04-16 16:11:25","2020-04-15","2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",4,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",5,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7971","RENT","\u9810\u7e73\u79df\u91d1",6,598,"MO","1",598,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3588,0,"7971"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-16 16:11: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":[454,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207618","2020-04-16 16:11:25",3588,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7618","DEPOSIT",null,"PAID","2020-04-16 16:11:25",0,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:11: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":["7618","INVOICE","7971","PAID","2020-04-16 16:11:25",3588,"2","2020-04-16 16:11:25","2","2020-04-16 16:11:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16:10","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":454,"customer_code":"C170454","identity_type":"PERSONAL","identity_id":"A914369(9)","title":"Ms","lastname":"Lee","firstname":"So Ngor","companyname":"","email":null,"tel":"52125128","address":"Flat 2903,29\/F,Tung Hing Hse,Lei Tung Est,Ap Lei Chau,Hong Kong ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"6","renew_warehousing_date":"2020-10-15","renew_room_key":"052,21409","renew_remark":"6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT196145 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207643, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"598","room_code":"M09","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-15","rent_from":"2020-04-15","rent_to":"2020-10-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT20764 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,21409","order_product":[],"pass":true}},"first_order_id":"4752","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> M09 <\/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":"538.00","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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","2",454,"NEW","A14-CT207644",598,538,0,0,"6","6",3228,3228,3228,"2020-04-16 16:16:11","0",null,null,null,"2020-04-15","2020-10-14","6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT20764 to this agreement.\r\n","2020-04-15","12",0,null,0,"0","2","2020-04-16 16:16:10","2","2020-04-16 16:16:10","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,21409","C170454","PERSONAL","Ms","4I9Ho\/CYp0XRqSDUPoIrdQ==","kiriEIqhcx866RNZiMXdKQ==","","amES1vZiVrt9V6KWzRYS0JHr\/lO2HNvTD2TqKjVzvHgaEMvq\/3UMzbrGhX+h8rNxL9KKS9px0GaMywnh2qotkFBsXqDu1q6i1YOyWzfsLC0=","mgimlQ5WBwkpvOIWS7cpuQ==",null,"\/STHpl5zn2\/QZA61EtoJ6Q==",null,1,"4752"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7644","598","598.0","598.00","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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-04-15","2020-10-14","598"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-16 16:16: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":["7644",454,"SETTLED","A14-I207972","2020-04-16 16:16:10","2020-04-15","2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7972","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7972"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-16 16:16: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":[454,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207619","2020-04-16 16:16:10",3228,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7619","DEPOSIT",null,"PAID","2020-04-16 16:16:10",0,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 16:16: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":["7619","INVOICE","7972","PAID","2020-04-16 16:16:10",3228,"2","2020-04-16 16:16:10","2","2020-04-16 16:16:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:27:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58:32","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1025","master_room_id":"117","room_code":"A05-023"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-023 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D633739(3)","title":"Ms","lastname":"YEUNG","firstname":"Wai Fun","companyname":"","email":"","tel":"97780268","address":"Room 1409, Wah Hau House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1025","room_code":"A05-023","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":3714,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":21548,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3902.00","warehousing_date":"2020-04-28","rent_from":"2020-04-28","rent_to":"2021-05-27","delivery_service":"0","remark":"13 months contract. Special offer first 3 months 50% off and the 13th month free. Storage rental and deposit paid by EPS on April 16, 2020. Smartcard and padlock provided on April 16, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3902,"order_total":25450,"final_order_total":21548,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012398455","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1672.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201562","PERSONAL","Ms","eiXVxstn1ihge9Rn0gSXag==","cehTPCv0LSZ1f3zKZGLhBA==","","jtDBcveOpU27VSQTDr92VA==",null,"iEW10Iy62LxPVzV6Z94mjtv7sc9I8WSzxL5\/Dy3qiGhUrn5jMIjk2NpsulYAo3ajdv5xCJnkehyZBGXg2XpChQ==","QBxNtz7bmw7JvpZvBqBanQ==",null,null,"T\/WTT20nevn31nKtj4X6eg==","2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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` = ?","parameters":["1","1","4",1562,"NEW","A05-CT207645",1857,1672,3714,0,"13","13",21548,25450,21548,"2020-04-16 17:58:35","0",null,null,null,"2020-04-28","2021-05-27","13 months contract. Special offer first 3 months 50% off and the 13th month free. Storage rental and deposit paid by EPS on April 16, 2020. Smartcard and padlock provided on April 16, 2020.","2020-04-28","24",0,null,3902,"3902.00","2","2020-04-16 17:58:32","2","2020-04-16 17:58:32","EPS","","","","EPS","","","",null,0,"'0012398455","C201562","PERSONAL","Ms","eiXVxstn1ihge9Rn0gSXag==","cehTPCv0LSZ1f3zKZGLhBA==","","iEW10Iy62LxPVzV6Z94mjtv7sc9I8WSzxL5\/Dy3qiGhUrn5jMIjk2NpsulYAo3ajdv5xCJnkehyZBGXg2XpChQ==","jtDBcveOpU27VSQTDr92VA==",null,"QBxNtz7bmw7JvpZvBqBanQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7645","1025","1857.0","1857.00","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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-04-28","2021-05-27","1025"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-16 17:58:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7645","A05-D205371","PAID",3714,0,"2021-05-27","2020-04-16 17:58:32","2020-04-16 17:58:32","2","2020-04-16 17:58:32","2","2020-04-16 17:58:32",1562]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7645",1562,"SETTLED","A05-I207973","2020-04-16 17:58:32","2020-04-28","2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1114,"MO","1",1114,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7973","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17834,0,"7973"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-16 17:58: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":[1562,"EPS","","","","EPS","","","","PAID","P207620","2020-04-16 17:58:32",21548,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7620","DEPOSIT","5371","PAID","2020-04-16 17:58:32",3714,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 17:58: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":["7620","INVOICE","7973","PAID","2020-04-16 17:58:32",17834,"2","2020-04-16 17:58:32","2","2020-04-16 17:58:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 18:12:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 18:28:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 18:53:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:00:16","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","052,21409","6 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A14-CT196145 to this agreement.\r\n","2020-04-16 19:00:16","2","kiriEIqhcx866RNZiMXdKQ==","4I9Ho\/CYp0XRqSDUPoIrdQ==","mgimlQ5WBwkpvOIWS7cpuQ==","amES1vZiVrt9V6KWzRYS0JHr\/lO2HNvTD2TqKjVzvHgaEMvq\/3UMzbrGhX+h8rNxL9KKS9px0GaMywnh2qotkFBsXqDu1q6i1YOyWzfsLC0=",7643]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1025","master_room_id":"117","room_code":"A05-023"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":540,"customer_code":"C170540","identity_type":"PERSONAL","identity_id":"D488992(5)","title":"Mr","lastname":"Hui","firstname":"Chong Hee","companyname":"","email":null,"tel":"98682757","address":"FT F,8\/F BLK 18,108 Route Twisk, The Cairnhill,Tsuen Wan,New Territories","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1430.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-26","renew_room_key":"136,61406","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 29, 2019. Storage deposit transferred from agreement A14-CT194708 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196043, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"49","order_discount":[],"order_room":[{"room_id":"443","room_code":"J25","retail_price":"1838.0","discounted_price":"1838.00","location_id":"2"}],"roughly_size":"25","total_retail_price":1838,"total_discounted_price":1430,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-26","rent_from":"2020-02-26","rent_to":"2020-08-25","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 16, 2020. Storage deposit transferred from agreement A14-CT196043 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8580,"final_order_total":8580,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,61406","order_product":[],"pass":true}},"first_order_id":"4708","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> J25 <\/td>\r\n\t\t\t\t\t 5X5X8 <\/td>\r\n\t\t\t\t\t $1838.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":"25","total_discounted_price":"1430.0","deposit":"0","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",540,"NEW","A14-CT207646",1838,1430,0,0,"6","6",8580,8580,8580,"2020-04-16 19:03:08","0",null,null,null,"2020-02-26","2020-08-25","6 months contract. Storage rental paid by bank transfer on April 16, 2020. Storage deposit transferred from agreement A14-CT196043 to this agreement.\r\n","2020-02-26","25",0,null,0,"0","2","2020-04-16 19:03:07","2","2020-04-16 19:03:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,61406","C170540","PERSONAL","Mr","+h90LKWn6E+89nv\/FPY9dw==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","Rr924RY7s1fwRRrhpBfarvIYdNCuVH51Kf9tIkw9LaGqRoIrlap5y90nPnKikaUfsnhnwov7CHtjJCVldr5eiQEELOUNz\/9I37Dp0xjPcok=","2v7z2LgExEJGOpCjx67NLQ==",null,"8lW+ZvQ1YaISNAT\/PwhDew==",null,1,"4708"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7646","443","1838.0","1838.00","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-26","2020-08-25","443"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7646",540,"SETTLED","A14-I207974","2020-04-16 19:03:07","2020-02-26","2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",1,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",2,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",3,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",4,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",5,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7974","RENT","\u9810\u7e73\u79df\u91d1",6,1430,"MO","1",1430,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8580,0,"7974"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[540,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207621","2020-04-16 19:03:07",8580,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7621","DEPOSIT",null,"PAID","2020-04-16 19:03:07",0,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:03:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7621","INVOICE","7974","PAID","2020-04-16 19:03:07",8580,"2","2020-04-16 19:03:07","2","2020-04-16 19:03:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:12:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:30:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-16 19:34:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****