{"created_at":"2020-06-11 00:00:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 09:55:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:08:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:55","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":268,"customer_code":"C170268","identity_type":"PERSONAL","identity_id":"D421709(9)","title":"Ms","lastname":"To","firstname":"Lai Na Linna","companyname":"","email":null,"tel":"67601866","address":"\u9999\u6e2f\u9285\u947c\u7063\u6d77\u90fd\u5927\u5ec81\/F,G Room","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-01","renew_room_key":"135,20949","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 28, 2020. Storage deposit $1196 transferred from agreement A14-CT206947 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207275, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"699","room_code":"N16","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-05-01","rent_from":"2020-05-01","rent_to":"2020-10-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on JUNE 11, 2020. Storage deposit $1196 transferred from agreement A14-CT207275 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"135,20949","order_product":[],"pass":true}},"first_order_id":"5841","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>
N16 <\/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.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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",268,"NEW","A14-CT208102",598,538,0,0,"6","6",3228,3228,3228,"2020-06-11 10:09:56","0",null,null,null,"2020-05-01","2020-10-31","6 months contract. Storage rental paid by EPS on JUNE 11, 2020. Storage deposit $1196 transferred from agreement A14-CT207275 to this agreement. ","2020-05-01","12",0,null,0,"0","2","2020-06-11 10:09:55","2","2020-06-11 10:09:55","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"135,20949","C170268","PERSONAL","Ms","tBQgDidK\/yVQr0lAqq5LPA==","ME1HgmDJnR5612zeAsjIHA==","","qpPAjyxsJ0n\/Kv7FGiRhvC+xFVuWjCcB9CtF7z1+Ool5R5f5x36ghU9yZVbmUHmP","G\/s3K1J7FjoHpr9g4onXlQ==",null,"AeHqveSHk3PK4RctlagJHg==",null,1,"5841"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8102","699","598.0","598.00","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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","2020-10-31","699"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 10:09:56","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":["8102",268,"SETTLED","A14-I208431","2020-06-11 10:09:55","2020-05-01","2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8431","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8431"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 10:09:56","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":[268,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208074","2020-06-11 10:09:55",3228,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8074","DEPOSIT",null,"PAID","2020-06-11 10:09:55",0,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:09:56","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":["8074","INVOICE","8431","PAID","2020-06-11 10:09:55",3228,"2","2020-06-11 10:09:55","2","2020-06-11 10:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:12:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:55","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":791,"customer_code":"C180791","identity_type":"PERSONAL","identity_id":"V016496(8)","title":"Mr","lastname":"Li","firstname":"Chin Chin","companyname":"","email":null,"tel":"90211965","address":"Flat B, 3\/F, Kam Fung Building,171 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-16","renew_room_key":"054,58848","renew_remark":"3 months contract. Storage rental paid by cash on Mar 02,2020. Storage deposit transferred from agreement A14-CT196657 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207296, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"693","room_code":"N10","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-06-16","rent_from":"2020-06-16","rent_to":"2020-12-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on JUNE 11,2020. Storage deposit transferred from agreement A14-CT207296 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,58848","order_product":[],"pass":true}},"first_order_id":7296,"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> N10 <\/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.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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",791,"NEW","A14-CT208103",598,538,0,0,"6","6",3228,3228,3228,"2020-06-11 10:13:56","0",null,null,null,"2020-06-16","2020-12-15","6 months contract. Storage rental paid by EPS on JUNE 11,2020. Storage deposit transferred from agreement A14-CT207296 to this agreement.\r\n","2020-06-16","12",0,null,0,"0","2","2020-06-11 10:13:55","2","2020-06-11 10:13:55","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,58848","C180791","PERSONAL","Mr","P+qxskvHUH4OJZ9H+Ork5g==","7KCehmxbvwRMb+U8lHGoVA==","","ma1BnXBxZAlZQ9n1jQ9gebwnAjgMDmdVLZtKi7a5mNC+mVcA3v9KGitvyZNrikYWIXcX6RVj3AwrtSLhFBSFHojwYg1dHJfhMm7Y8JuSohQ=","T7\/3p2HqBeXmQgImq4qEyA==",null,"adoNyfYYHqGuBZUsS3PDOQ==",null,1,7296]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8103","693","598.0","598.00","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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-16","2020-12-15","693"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 10:13:56","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":["8103",791,"SETTLED","A14-I208432","2020-06-11 10:13:55","2020-06-16","2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8432","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8432"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 10:13:56","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":[791,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208075","2020-06-11 10:13:55",3228,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8075","DEPOSIT",null,"PAID","2020-06-11 10:13:55",0,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:13:56","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":["8075","INVOICE","8432","PAID","2020-06-11 10:13:55",3228,"2","2020-06-11 10:13:55","2","2020-06-11 10:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:20:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:21:11","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","135,20949","6 months contract. Storage rental paid by EPS on JUNE 11, 2020. Storage deposit $1196 transferred from agreement A14-CT207275 to this agreement. ","2020-06-11 10:21:11","2","ME1HgmDJnR5612zeAsjIHA==","tBQgDidK\/yVQr0lAqq5LPA==","G\/s3K1J7FjoHpr9g4onXlQ==","qpPAjyxsJ0n\/Kv7FGiRhvC+xFVuWjCcB9CtF7z1+Ool5R5f5x36ghU9yZVbmUHmP",8102]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 10:38:08","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":["NEW","052,43303","13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on JUNE 10, 2020. Storage deposit transferred from agreement A14-CT194972 to this agreement.","2020-06-11 10:38:08","2","4w4biS+jM\/Q3DAzxHdf3pA==","MJBZLbrpqh3TT1VrfF137w==","nKIBk++ZEDPq15SH7LqGkw==","WpEiEaYtmccC0nYeGH2fs679aQz+I4ClG20E6\/t8hNNhIpAK6Tqdm5sLdfu6LaCX+Wg8pg1viohqKjNIGMzdG5WxR2wfcCxK7odC2AAKr8k=",8101]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:20:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":707,"customer_code":"C180707","identity_type":"PERSONAL","identity_id":"XD664200(A)","title":"Mr","lastname":"Figueiras","firstname":"Julio Alberto","companyname":"","email":"scaljf@yahoo.com","tel":"90490864","address":"24B, Block 25, Baguio Villa, 555 Victoria Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2053.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-08","renew_room_key":"055,02407","renew_remark":"3 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT207152 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207369, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"897","room_code":"Y26","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2053,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6159,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-08-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT207369 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6159,"final_order_total":6159,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,02407","order_product":[],"pass":true}},"first_order_id":"4758","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> Y26 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"2053.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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","3",707,"NEW","A18-CT208104",2161,2053,0,0,"3","3",6159,6159,6159,"2020-06-11 11:33:11","0",null,null,null,"2020-05-08","2020-08-07","3 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT207369 to this agreement.","2020-05-08","28",0,null,0,"0","2","2020-06-11 11:33:10","2","2020-06-11 11:33:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,02407","C180707","PERSONAL","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","","K5\/5N+Bn0vBxmk8zM4MdOaD5g\/ggASRq4gDh8rMA\/2x+pfaHe8CKVVwOGqDLCKD7DoW+N1f1zYdDvubF4CXfuQ6ylZO+RwDnmiiRHP0oIxI=","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","WhxmmwJ+NlhISvFFctqMCA==",null,1,"4758"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8104","897","2161.0","2161.00","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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-05-08","2020-08-07","897"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 11:33: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":["8104",707,"SETTLED","A18-I208433","2020-06-11 11:33:10","2020-05-08","2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8433","RENT","\u9810\u7e73\u79df\u91d1",1,2053,"MO","1",2053,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8433","RENT","\u9810\u7e73\u79df\u91d1",2,2053,"MO","1",2053,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8433","RENT","\u9810\u7e73\u79df\u91d1",3,2053,"MO","1",2053,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6159,0,"8433"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 11:33: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":[707,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208076","2020-06-11 11:33:10",6159,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8076","DEPOSIT",null,"PAID","2020-06-11 11:33:10",0,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:33: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":["8076","INVOICE","8433","PAID","2020-06-11 11:33:10",6159,"2","2020-06-11 11:33:10","2","2020-06-11 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:43:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 11:44:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:06:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:40","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"863","master_room_id":"91","room_code":"T07"}],"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> T07 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R763837(9)","title":"Ms","lastname":"Zhao","firstname":"yaru rya","companyname":"","email":"","tel":"61904030","address":"Flat A, 28\/f, Pol Fu Lam Terrace, no.8 Wah Fu Road","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"863","room_code":"T07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1038,"deposit":2076,"rent_month":"13","biggest_retail_price":"1290","biggest_discounted_price":"1290.00","prepaid_month":"13","prepaid_amount":12048,"free_first_month":1,"free_first_month_deduct":645,"free_2_month_deduct":null,"last_paid":"2877.00","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2021-07-10","delivery_service":"0","remark":"13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3522,"order_total":15570,"final_order_total":12048,"location_id":"3","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["C201615","PERSONAL","Ms","tnBXsw2iRVZmC7agW3nxRw==","iAKb9Y+6DFOZKg+8+iuRrA==","","f0RgO2mVVUDM\/nLFDmD8xA==",null,"WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==","PCjntCeNxYSbRGoWlh4wXA==",null,null,"d\/pvbxbWoYYriDnXTu\/qyg==","2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1615,"NEW","A18-CT208105",1290,1038,2076,0,"13","13",12048,15570,12048,"2020-06-11 12:39:42","0",null,null,null,"2020-06-11","2021-07-10","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-11","16",645,null,3522,"2877.00","2","2020-06-11 12:39:40","2","2020-06-11 12:39:40","CASH","","","","CASH","","","",null,0,"","C201615","PERSONAL","Ms","tnBXsw2iRVZmC7agW3nxRw==","iAKb9Y+6DFOZKg+8+iuRrA==","","WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==","f0RgO2mVVUDM\/nLFDmD8xA==",null,"PCjntCeNxYSbRGoWlh4wXA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `discount_type` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8105","45","MO",645,"2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8105","863","1290.0","1290.00","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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-11","2021-07-10","863"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 12:39:42","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":["8105","A18-D205460","PAID",2076,0,"2021-07-10","2020-06-11 12:39:40","2020-06-11 12:39:40","2","2020-06-11 12:39:40","2","2020-06-11 12:39:40",1615]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8105",1615,"SETTLED","A18-I208434","2020-06-11 12:39:40","2020-06-11","2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `remark` = ?, `month` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8434","RENT",393,"MO","1",393,"\u9996\u6708\u534a\u50f9",1,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,237,"MO","1",237,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",5,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",6,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",7,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",8,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",9,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",10,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",11,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",12,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8434","RENT","\u9810\u7e73\u79df\u91d1",13,1038,"MO","1",1038,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9972,0,"8434"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 12:39:42","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":[1615,"CASH","","","","CASH","","","","PAID","P208077","2020-06-11 12:39:40",12048,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8077","DEPOSIT","5460","PAID","2020-06-11 12:39:40",2076,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:39:42","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":["8077","INVOICE","8434","PAID","2020-06-11 12:39:40",9972,"2","2020-06-11 12:39:40","2","2020-06-11 12:39:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:41:28","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","","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-11 12:41:28","2","iAKb9Y+6DFOZKg+8+iuRrA==","tnBXsw2iRVZmC7agW3nxRw==","f0RgO2mVVUDM\/nLFDmD8xA==","WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==",8105]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:03","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":"863","master_room_id":"91","room_code":"T07"}],"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> T07 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"R763837(9)","title":"Ms","lastname":"Zhao","firstname":"yaru rya","companyname":"","email":"","tel":"61904030","address":"Flat A, 28\/f, Pol Fu Lam Terrace, no.8 Wah Fu Road","pass":true,"customer_id":"1615","customer_code":"C201615","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"863","room_code":"T07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1038,"deposit":2076,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12048,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3522.00","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2021-07-10","delivery_service":"0","remark":"13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3522,"order_total":15570,"final_order_total":12048,"location_id":"3","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3","1615","NEW","A18-CT208106",1290,1038,2076,0,"13","13",12048,15570,12048,"2020-06-11 12:43:04","0",null,null,null,"2020-06-11","2021-07-10","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-11","16",0,null,3522,"3522.00","2","2020-06-11 12:43:03","2","2020-06-11 12:43:03","CASH","","","","CASH","","","",null,0,"","C201615","PERSONAL","Ms","tnBXsw2iRVZmC7agW3nxRw==","iAKb9Y+6DFOZKg+8+iuRrA==","","WAeDQGyJs5GONb+7AH7S3+poCGWF1+fb+lVhrBHyBjm+j6zrUiqt3Wr6M+U+ocXuHAokHb5SnGVVm7hU6w8HTw==","f0RgO2mVVUDM\/nLFDmD8xA==",null,"PCjntCeNxYSbRGoWlh4wXA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8106","863","1290.0","1290.00","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2021-07-10","863"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 12:43:04","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":["8106","A18-D205461","PAID",2076,0,"2021-07-10","2020-06-11 12:43:03","2020-06-11 12:43:03","2","2020-06-11 12:43:03","2","2020-06-11 12:43:03","1615"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8106","1615","SETTLED","A18-I208435","2020-06-11 12:43:03","2020-06-11","2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,630,"MO","1",630,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",5,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",6,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",7,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",8,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",9,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",10,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",11,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",12,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8435","RENT","\u9810\u7e73\u79df\u91d1",13,1038,"MO","1",1038,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9972,0,"8435"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1615","CASH","","","","CASH","","","","PAID","P208078","2020-06-11 12:43:03",12048,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8078","DEPOSIT","5461","PAID","2020-06-11 12:43:03",2076,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 12:43:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8078","INVOICE","8435","PAID","2020-06-11 12:43:03",9972,"2","2020-06-11 12:43:03","2","2020-06-11 12:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 14:06:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 14:19:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 14:30:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 14:32:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 15:11:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 15:14:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 15:16:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 15:58:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=738&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> WC-21 <\/td>\n\t\t\t\t\t 2.5X2.5X4 <\/td>\n\t\t\t\t\t $798.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\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D242281(7)","title":"Mr","lastname":"CHU","firstname":"Kwok Leung","companyname":"","email":"chuivankl@gmail.com","tel":"93363776","address":"17D, Rome Court, Reality Gardens, 41 Conduit Road, HK","pass":true,"customer_id":"1470","customer_code":"C191470","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1748","room_code":"WC-21","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":798,"deposit":0,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":9576,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1596.00","warehousing_date":"2020-06-12","rent_from":"2020-06-12","rent_to":"2021-08-11","delivery_service":"0","remark":"14 months contract. Special offer the 13th and the 14th months free and no deposit. Storage rental paid by bank transfer on June 11,2020. Smart card and password lock provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1596,"order_total":11172,"final_order_total":9576,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190, 39677","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"798.00","deposit":"0.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:32","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":["C201616","PERSONAL","Mr","GliNjjLiECSrzOQuSsgyNQ==","BvPqeOM4V79b5HJQ7Cm1Gg==","","Qln2Tkg\/NIEBC8T9TVEtIw==","yMCjPFCG3Lu5rdLW2Z8Ojhlee8GCHQpKGldynxdB4bY=","v\/tE0MHuiW+V6EZqvB6\/N3Epnw6RZKZLJUxF9e3bGv0r+YEGY4ujAA+WjTrLX4UOEmxYe7dLyqHHeSpUA64qDw==","Cmax7TVg0N6p5M1O9zLMeg==",null,"yMCjPFCG3Lu5rdLW2Z8Ojhlee8GCHQpKGldynxdB4bY=","j6jeTalK2g5BTU8347v8Cg==","2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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","8",1616,"NEW","WC-CT208107",798,798,0,0,"14","14",9576,11172,9576,"2020-06-11 16:30:33","0",null,null,null,"2020-06-12","2021-08-11","14 months contract. Special offer the 13th and the 14th months free and no deposit. Storage rental paid by bank transfer on June 11,2020. Smart card and password lock provided on the same day.","2020-06-12","6.25",0,null,1596,"1596.00","2","2020-06-11 16:30:31","2","2020-06-11 16:30:31","BANKIN","","","","BANKIN","","","",null,0,"190, 39677","C201616","PERSONAL","Mr","GliNjjLiECSrzOQuSsgyNQ==","BvPqeOM4V79b5HJQ7Cm1Gg==","","v\/tE0MHuiW+V6EZqvB6\/N3Epnw6RZKZLJUxF9e3bGv0r+YEGY4ujAA+WjTrLX4UOEmxYe7dLyqHHeSpUA64qDw==","Qln2Tkg\/NIEBC8T9TVEtIw==","yMCjPFCG3Lu5rdLW2Z8Ojhlee8GCHQpKGldynxdB4bY=","Cmax7TVg0N6p5M1O9zLMeg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8107","1748","798.0","798.00","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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-12","2021-08-11","1748"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 16:30:33","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":["8107",1616,"SETTLED","WC-I208436","2020-06-11 16:30:31","2020-06-12","2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",4,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8436","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9576,0,"8436"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 16:30:33","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":[1616,"BANKIN","","","","BANKIN","","","","PAID","P208079","2020-06-11 16:30:31",9576,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8079","DEPOSIT",null,"PAID","2020-06-11 16:30:31",0,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 16:30:33","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":["8079","INVOICE","8436","PAID","2020-06-11 16:30:31",9576,"2","2020-06-11 16:30:31","2","2020-06-11 16:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:03:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:06:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:09:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=500","floor_plan_rent_room":[{"room_id":"863","master_room_id":"91","room_code":"T07"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":660,"customer_code":"C170660","identity_type":"PERSONAL","identity_id":"D354297(2)","title":"Mr","lastname":"Low","firstname":"Hon Keet Stephen","companyname":"","email":"aequinox@ymail.com","tel":"64638416","address":"GPO Box 1688, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2334.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-29","renew_room_key":"055,15470","renew_remark":"3 months contract. Storage rental paid by cash on March 19, 2020. Storage deposit transferred from agreement A18-CT196664 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207450, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"986","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"987","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"987","room_code":"X12","retail_price":"1290.0","discounted_price":1161,"location_id":"3"},{"room_id":"986","room_code":"X11","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"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-12-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT207450 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,15470","order_product":[],"pass":true}},"first_order_id":"4650","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> X12 <\/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> X11 <\/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":"1162.00","deposit":"0.00","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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",660,"NEW","A18-CT208108",2580,1162,0,0,"6","6",6972,6972,6972,"2020-06-11 17:21:34","0",null,null,null,"2020-06-29","2020-12-28","6 months contract. Storage rental paid by cash on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT207450 to this agreement.","2020-06-29","32",0,null,0,"0","2","2020-06-11 17:21:33","2","2020-06-11 17:21:33","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,15470","C170660","PERSONAL","Mr","8WARjcd6zFu40\/HzPdJPfN1ULF7Z3rO82+vQIx5x\/SM=","hXEebd6SlV7J+4vJgo12Ig==","","VBq6cRnFyG95IonRizJi+lwCL6Oe\/bdLOb6ELHGGPWo=","EMRlE0\/B9grUj7uTzS0zfA==","GKb98Vl5nys8iXuEjTSvUjIQSI4LYfAqndGeMATNE\/I=","e9TAobvjjMmIxa53EKWduA==",null,1,"4650"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8108","250","91","986","%","10.00",129,"2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8108","250","91","987","%","10.00",129,"2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8108","987","1290.0",1161,"2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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-12-28","987"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 17:21:34","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":["8108","986","1290.0",1161,"2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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-12-28","986"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 17:21:34","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":["8108",660,"SETTLED","A18-I208437","2020-06-11 17:21:33","2020-06-29","2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8437","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8437"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 17:21:34","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":[660,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208080","2020-06-11 17:21:33",6972,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8080","DEPOSIT",null,"PAID","2020-06-11 17:21:33",0,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:21:34","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":["8080","INVOICE","8437","PAID","2020-06-11 17:21:33",6972,"2","2020-06-11 17:21:33","2","2020-06-11 17:21:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=500","floor_plan_rent_room":[{"room_id":"863","master_room_id":"91","room_code":"T07"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1516,"customer_code":"C201516","identity_type":"PERSONAL","identity_id":"D202299(1)","title":"Ms","lastname":"TANG","firstname":"Yuen Yee","companyname":"","email":"Irsitang@yahoo.com","tel":"60506928","address":"3\/F, 27 Tsung Man St, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1036.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-28","renew_room_key":"189,51765","renew_remark":"3 months contract. Special offer 5% 'rent now' discount. Storage rental and deposit paid by EPS on Feb 21,2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207239, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2180.0","renew_master_room_id":"113","order_discount":[{"master_room_discount_id":"245","master_room_id":"113","discount_type":"%","price":"1090.00","disocunted_price":"981.00","discount":"10.00","monthly_deduct":109,"room_id":"1147","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1147","room_code":"A05-145","retail_price":"1090.0","discounted_price":981,"location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-11-27","delivery_service":"0","remark":"6 months contract. Storage deposit transferred from agreement A05-CT207239 to this agreement. Storage rental and deposit paid by EPS on JUNE 11,2020. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"4","branch_id":"1","company_id":"1","room_key":"189,51765","order_product":[],"pass":true}},"first_order_id":7239,"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-145 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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",1516,"NEW","A05-CT208109",1090,981,0,0,"6","6",5886,5886,5886,"2020-06-11 17:57:03","0",null,null,null,"2020-05-28","2020-11-27","6 months contract. Storage deposit transferred from agreement A05-CT207239 to this agreement. Storage rental and deposit paid by EPS on JUNE 11,2020. ","2020-05-28","12",0,null,0,"0","2","2020-06-11 17:57:03","2","2020-06-11 17:57:03","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"189,51765","C201516","PERSONAL","Ms","KrUWcmrrreWoFN9TjxoGzw==","20knVHhKlM9kB5wugwP3yQ==","","hpfUUMdffOkfcUNjfg9BTYMiC6L5Jagp3mi5Te5C4jZxAxOpIS8lj+YSUxl1DOjU","kgvNMTVjGcOPQJaDELmQMA==","mrVhJvnc6Edpn4QrNIijqpcpgtuNjOqgWuk3Z\/LOWhc=","a2ZqY5osJ94\/47L3WupKig==",null,1,7239]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8109","245","113","1147","%","10.00",109,"2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8109","1147","1090.0",981,"2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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-28","2020-11-27","1147"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 17:57:03","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":["8109",1516,"SETTLED","A05-I208438","2020-06-11 17:57:03","2020-05-28","2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8438","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8438"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 17:57:03","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":[1516,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208081","2020-06-11 17:57:03",5886,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8081","DEPOSIT",null,"PAID","2020-06-11 17:57:03",0,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 17:57:03","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":["8081","INVOICE","8438","PAID","2020-06-11 17:57:03",5886,"2","2020-06-11 17:57:03","2","2020-06-11 17:57:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:28:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=500","floor_plan_rent_room":[{"room_id":"863","master_room_id":"91","room_code":"T07"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":421,"customer_code":"C170421","identity_type":"PERSONAL","identity_id":"D707448(5)","title":"Ms","lastname":"Wong ","firstname":"Sin Ki","companyname":"","email":"christina@hosanna-logistics.com.hk","tel":"91416461","address":"Flat B, 7\/F, Block 13A, 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":"1205.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-10","renew_room_key":"055,19257","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 27, 2020. Storage deposit transferred from agreement A12-CT207227 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207500, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"104","room_code":"B52","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-10","rent_from":"2020-06-10","rent_to":"2020-07-09","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A12-CT207500 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,19257","order_product":[],"pass":true}},"first_order_id":"4375","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> B52 <\/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> \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":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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",421,"NEW","A12-CT208110",1528,1286,0,0,"1","1",1286,1286,1286,"2020-06-11 18:49:40","0",null,null,null,"2020-06-10","2020-07-09","1 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A12-CT207500 to this agreement.","2020-06-10","20",0,null,0,"0","2","2020-06-11 18:49:40","2","2020-06-11 18:49:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,19257","C170421","PERSONAL","Ms","Dk9bBvlTPdGIOfoj7ri85A==","DgLsCGM4faTvgwjKBW9M0A==","","IUtdGG37s++PUSJZlCWKuBwcM28OdF\/d0j1ZjFQeEmDgKryHJBNyu2CieqYiuU\/y+c+G1RIhRrB8umGMOsjJyQ==","7DiteIEa1DPNOaaxNkf4mA==","A8BZ7J\/yEFhvrC5fYB+XyBI8opG5QqCCAo9vuQjXgjk40k95i4FQnkejOoWjX3QX","dkR0lxZSK9Sd6ZEZ1+nFrA==",null,1,"4375"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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":["8110","104","1528.0","1528.00","2","2020-06-11 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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-10","2020-07-09","104"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 18:49:40","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":["8110",421,"SETTLED","A12-I208439","2020-06-11 18:49:40","2020-06-10","2","2020-06-11 18:49:40","2","2020-06-11 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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":["8439","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-06-11 18:49:40","2","2020-06-11 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8439"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 18:49:40","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":[421,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208082","2020-06-11 18:49:40",1286,"2","2020-06-11 18:49:40","2","2020-06-11 18:49:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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":["8082","DEPOSIT",null,"PAID","2020-06-11 18:49:40",0,"2","2020-06-11 18:49:40","2","2020-06-11 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:49:40","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":["8082","INVOICE","8439","PAID","2020-06-11 18:49:40",1286,"2","2020-06-11 18:49:40","2","2020-06-11 18:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 18:56:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=3&filter2=500","floor_plan_rent_room":[{"room_id":"863","master_room_id":"91","room_code":"T07"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":812,"customer_code":"C180812","identity_type":"PERSONAL","identity_id":"P591651(1)","title":"Ms","lastname":"Hwong","firstname":"Yil Nil","companyname":"","email":"hwongreb@netvigator.com","tel":"91557437","address":"Flat 9A, Block 1, Cavendish Heights, 33 Perkins Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4534.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-04","renew_room_key":"137,05391","renew_remark":"6 months contract. Storage rental paid by cheque on January 8, 2020. Storage deposit transferred from agreement A18-CT194997 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206905, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"93","order_discount":[{"master_room_discount_id":"306","master_room_id":"93","discount_type":"%","price":"5038.00","disocunted_price":"4533.70","discount":"10.01","monthly_deduct":504.3038,"room_id":"870","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"870","room_code":"T14","retail_price":"5038.0","discounted_price":4533.7,"location_id":"3"}],"roughly_size":"64","total_retail_price":5038,"total_discounted_price":4534,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":27204,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-04","rent_from":"2020-04-04","rent_to":"2020-10-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT206905 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":27204,"final_order_total":27204,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,05391","order_product":[],"pass":true}},"first_order_id":"3690","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> T14 <\/td>\r\n\t\t\t\t\t 8X8X7 <\/td>\r\n\t\t\t\t\t $5038.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":"64","total_discounted_price":"4534.0","deposit":"0","total_retail_price":"5038.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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","3",812,"NEW","A18-CT208111",5038,4534,0,0,"6","6",27204,27204,27204,"2020-06-11 19:01:19","0",null,null,null,"2020-04-04","2020-10-03","6 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A18-CT206905 to this agreement.","2020-04-04","64",0,null,0,"0","2","2020-06-11 19:01:19","2","2020-06-11 19:01:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,05391","C180812","PERSONAL","Ms","\/RT0ADSI+yZhVHlf06IjFA==","AgRQrmrTgqQTe7hemOAG9A==","","TSkRH\/30HlW5smbNZ\/B2Nsdlon8cl7a4zzywGbATDjtmaE3No\/ayBPFQ7BpKIikdthjxp59qBt+OvjjVWb++vA==","04E9w2VqoknTBiP8S3YG4g==","Mc3npIIaocXdZ1JeoaA215Z8kEsJrBDS\/deWyk7QKjE=","BKhOW34fKniMglg+JrLpoQ==",null,1,"3690"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01:19","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":["8111","306","93","870","%","10.01",504.3038,"2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8111","870","5038.0",4533.7,"2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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-04-04","2020-10-03","870"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 19:01: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":["8111",812,"SETTLED","A18-I208440","2020-06-11 19:01:19","2020-04-04","2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",1,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",2,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",3,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",4,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",5,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8440","RENT","\u9810\u7e73\u79df\u91d1",6,4534,"MO","1",4534,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27204,0,"8440"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 19:01: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":[812,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208083","2020-06-11 19:01:19",27204,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8083","DEPOSIT",null,"PAID","2020-06-11 19:01:19",0,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:01: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":["8083","INVOICE","8440","PAID","2020-06-11 19:01:19",27204,"2","2020-06-11 19:01:19","2","2020-06-11 19:01:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:32:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":611,"customer_code":"C170611","identity_type":"PERSONAL","identity_id":"G134295(8)","title":"Ms","lastname":"Lam","firstname":"Yi Wa Eva","companyname":"","email":"lam10bin@yahoo.com.hk","tel":"96770069","address":"Rm. 3, 28\/F, Kwun Chiu Court, Aberdeen Centre, 3 Nam Ning St, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5028.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-18","renew_room_key":"136,58225","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 15, 2019. Storage deposit transferred from agreement A18-CT195304 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196724, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"94","order_discount":[],"order_room":[{"room_id":"856","room_code":"S15","retail_price":"5442.0","discounted_price":"5442.00","location_id":"3"}],"roughly_size":"72","total_retail_price":5442,"total_discounted_price":5028,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":30168,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-18","rent_from":"2020-06-18","rent_to":"2020-12-17","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 11,2020. Storage deposit transferred from agreement A18-CT196724 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":30168,"final_order_total":30168,"location_id":"3","branch_id":"1","company_id":"1","room_key":"136,58225","order_product":[],"pass":true}},"first_order_id":"3918","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> S15 <\/td>\r\n\t\t\t\t\t 9X8X7 <\/td>\r\n\t\t\t\t\t $5442.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":"72","total_discounted_price":"5028.0","deposit":"0","total_retail_price":"5442.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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","3",611,"NEW","A18-CT208112",5442,5028,0,0,"6","6",30168,30168,30168,"2020-06-11 19:48:26","0",null,null,null,"2020-06-18","2020-12-17","6 months contract. Storage rental paid by bank transfer on June 11,2020. Storage deposit transferred from agreement A18-CT196724 to this agreement.","2020-06-18","72",0,null,0,"0","2","2020-06-11 19:48:26","2","2020-06-11 19:48:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58225","C170611","PERSONAL","Ms","k6KJ030A7zfFevzzPI1dtA==","0JxYUqbNPOvgfMwVa0l0NA==","","1AxWEBjVAlrF+cc3dFMqQhOUjyeR3BrT85QHP0YVRL4R8sghj8C57WASejsvdqmlmfGCulfc4XMvQ+32pJ+rv70HbkmgUk\/53YKu8Tj+rWA=","sDBEWc2c2gJA\/JUUiY2C7A==","\/FRzpvEdV5N09FgT\/FXZ7O0VeFhZryC3q7d3WjLoXeU=","qVaKW1QzXr5qSXIgHFwmWQ==",null,1,"3918"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8112","856","5442.0","5442.00","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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-06-18","2020-12-17","856"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-11 19:48: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":["8112",611,"SETTLED","A18-I208441","2020-06-11 19:48:26","2020-06-18","2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",1,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",2,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",3,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",4,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",5,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8441","RENT","\u9810\u7e73\u79df\u91d1",6,5028,"MO","1",5028,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[30168,0,"8441"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-11 19:48: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":[611,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208084","2020-06-11 19:48:26",30168,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8084","DEPOSIT",null,"PAID","2020-06-11 19:48:26",0,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-11 19:48: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":["8084","INVOICE","8441","PAID","2020-06-11 19:48:26",30168,"2","2020-06-11 19:48:26","2","2020-06-11 19:48:26"]},"data_before":[],"data_after":[],"step":1} *****