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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
WC-15 <\/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\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"6.25","total_discounted_price":"719.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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","1451","NEW","WC-CT207805",798,719,1596,0,"6","6",5910,5910,5910,"2020-05-08 15:19:29","0",null,null,null,"2020-05-09","2020-11-08","6 months contract. Storage rental and deposit paid by EPS on May 08,2020. Padlock provided on the same day.","2020-05-09","6.25",0,null,0,"0","2","2020-05-08 15:19:29","2","2020-05-08 15:19:29","EPS","","","","EPS","","","",null,0,"8","C191451","BUSINESS","Mr","3KCUISe7qN3kqh71Of0bJw==","sf417CHQvgLOIkQ2jy8s9Q==","Suitzerlexe Limited","C3WOMyGxS4lieXpfalQS7zxjgYErZAO+YPJqdr92Fxr7bJfSou8k3DLoR98BByQgB+b5qSm9udeym+N9wcYOJg==","T3K0eUUk0VCpYUzgW73wuw==","R9outzFAUxgrbXfnWtqw\/v7oM4vo9f3ym5xiXphbqnI=",null,"X2I+CWnddctNCCj2\/j8oWQ=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["7805","1754","798.0","798.00","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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-09","2020-11-08","1754"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-08 15:19:29","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":["7805","WC-D205401","PAID",1596,0,"2020-11-08","2020-05-08 15:19:29","2020-05-08 15:19:29","2","2020-05-08 15:19:29","2","2020-05-08 15:19:29","1451"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["7805","1451","SETTLED","WC-I208134","2020-05-08 15:19:29","2020-05-09","2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",1,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",2,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",3,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",4,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",5,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["8134","RENT","\u9810\u7e73\u79df\u91d1",6,719,"MO","1",719,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4314,0,"8134"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-08 15:19:29","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":["1451","EPS","","","","EPS","","","","PAID","P207779","2020-05-08 15:19:29",5910,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["7779","DEPOSIT","5401","PAID","2020-05-08 15:19:29",1596,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 15:19:29","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":["7779","INVOICE","8134","PAID","2020-05-08 15:19:29",4314,"2","2020-05-08 15:19:29","2","2020-05-08 15:19:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","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=206&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 7,2020. Storage deposit transferred from agreement A14-CT207347 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207580, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-06-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 8, 2020. Storage deposit transferred from agreement A14-CT207580 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","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> N39 <\/td>\r\n\t\t\t\t\t 3X6X8 <\/td>\r\n\t\t\t\t\t $1318.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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",445,"NEW","A14-CT207806",1318,1198,0,0,"1","1",1198,1198,1198,"2020-05-08 16:33:06","0",null,null,null,"2020-05-10","2020-06-09","1 month contract. Storage rental paid by bank transfer on May 8, 2020. Storage deposit transferred from agreement A14-CT207580 to this agreement.","2020-05-10","18",0,null,0,"0","2","2020-05-08 16:33:06","2","2020-05-08 16:33:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7806","722","1318.0","1318.00","2","2020-05-08 16:33:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7806",445,"SETTLED","A14-I208135","2020-05-08 16:33:06","2020-05-10","2","2020-05-08 16:33:06","2","2020-05-08 16:33:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8135","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-05-08 16:33:06","2","2020-05-08 16:33:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"8135"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207780","2020-05-08 16:33:06",1198,"2","2020-05-08 16:33:06","2","2020-05-08 16:33:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7780","DEPOSIT",null,"PAID","2020-05-08 16:33:06",0,"2","2020-05-08 16:33:06","2","2020-05-08 16:33:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 16:33:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7780","INVOICE","8135","PAID","2020-05-08 16:33:06",1198,"2","2020-05-08 16:33:06","2","2020-05-08 16:33:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:38","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=206&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":417,"customer_code":"C170417","identity_type":"PERSONAL","identity_id":"D069364(3)","title":"Mr","lastname":"Cheung","firstname":"Wing","companyname":"","email":"8610wingc@gmail.com","tel":"91623119","address":"155\u865f\u5e72\u8afe\u9053\u897f\u9ad8\u6a02\u82b1\u5712\u4e09\u671f12\u5b57A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-09","renew_room_key":"052,56054,190,58565","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 13, 2019. Storage deposit transferred from agreement A14-CT194983 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196394, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"795","room_code":"L68","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"580","room_code":"L58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-09","rent_from":"2020-05-09","rent_to":"2020-11-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 8, 2020. Storage deposit transferred from agreement A14-CT196394 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,56054,190,58565","order_product":[],"pass":true}},"first_order_id":"3482","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> L68 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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",417,"NEW","A14-CT207807",2196,1788,0,0,"6","6",10728,10728,10728,"2020-05-08 17:47:39","0",null,null,null,"2020-05-09","2020-11-08","6 months contract. Storage rental paid by bank transfer on May 8, 2020. Storage deposit transferred from agreement A14-CT196394 to this agreement.\r\n","2020-05-09","32",0,null,0,"0","2","2020-05-08 17:47:38","2","2020-05-08 17:47:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,56054,190,58565","C170417","PERSONAL","Mr","fLvb1VSL7T2bqIKMcZ+0UA==","vCxOlXQuvOQaoL822H2o\/Q==","","8iDQpB\/F7cvxcm9X5l3CGdzC\/HGYjf27OVPmzcQpcfjZA0kXKF6NCOZASvzqHRZS","E0ddPEA6Cni5+9myDyrrhA==","vKQ6meD+baUZpZpypkRYTQjGGPAUzBkflkCyc4BIJqg=","eLY+61boKoFziH5EoOaAJQ==",null,1,"3482"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["7807","795","1098.0","1098.00","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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-09","2020-11-08","795"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-08 17:47:39","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":["7807","580","1098.0","1098.00","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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-09","2020-11-08","580"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-08 17:47:39","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":["7807",417,"SETTLED","A14-I208136","2020-05-08 17:47:38","2020-05-09","2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["8136","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"8136"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-08 17:47:39","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":[417,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207781","2020-05-08 17:47:38",10728,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["7781","DEPOSIT",null,"PAID","2020-05-08 17:47:38",0,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 17:47:39","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":["7781","INVOICE","8136","PAID","2020-05-08 17:47:38",10728,"2","2020-05-08 17:47:38","2","2020-05-08 17:47:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:49","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=413&filter3=undefined","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":243,"customer_code":"C160243","identity_type":"PERSONAL","identity_id":"YB361992","title":"Ms","lastname":"SUN","firstname":"EMMA","companyname":"","email":"emmasun333@gmail.com","tel":"60274377","address":"Apartment 2336, 8 Finance Street, Central, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-03","renew_room_key":"054,03414","renew_remark":"12 months contract. Storage rental paid by EPS on May 2, 2019. Storage deposit transferred from agreement A12-CT183470 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194862, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"68","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"68","room_code":"B16","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-03","rent_from":"2020-05-03","rent_to":"2020-11-02","delivery_service":"0","remark":"12 months contract. Storage rental $6819 paid by bank transfer on May 4, 2020. Outstanding balance $15 will be deducted from deposit. Storage deposit transferred from agreement A12-CT194862 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,03414","order_product":[],"pass":true}},"first_order_id":4862,"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> B16 <\/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":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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",243,"NEW","A12-CT207808",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-08 18:10:50","0",null,null,null,"2020-05-03","2020-11-02","12 months contract. Storage rental $6819 paid by bank transfer on May 4, 2020. Outstanding balance $15 will be deducted from deposit. Storage deposit transferred from agreement A12-CT194862 to this agreement.\r\n","2020-05-03","20",0,null,0,"0","2","2020-05-08 18:10:49","2","2020-05-08 18:10:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,03414","C160243","PERSONAL","Ms","Q3Yq5LpZUCJyPjQwxlgYsA==","KQFRNa2i9\/MYxWP9oxfpBQ==","","4q1ao+Fkm6tZTLtWkCM+dTDYXcmMIXrd0d0fufHA2kFtWeowrOzmJ9WYk3Ew7eIOrYmsCLp1rE38Js2kn3Rl3w==","H\/2MSwwjCevV0A+91nCmEw==","cfDs9AmAbSDaNbVlTefBW4Mk1Xq3spYjvYwX776mxzc=","mGpOfdajP89bMAv59YRAdQ==",null,1,4862]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["7808","76","10","68","%","9.95",152.036,"2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["7808","68","1528.0",1376,"2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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-03","2020-11-02","68"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-08 18:10:50","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":["7808",243,"SETTLED","A12-I208137","2020-05-08 18:10:49","2020-05-03","2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["8137","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8137"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-08 18:10:50","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":[243,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207782","2020-05-08 18:10:49",6834,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["7782","DEPOSIT",null,"PAID","2020-05-08 18:10:49",0,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:10:50","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":["7782","INVOICE","8137","PAID","2020-05-08 18:10:49",6834,"2","2020-05-08 18:10:49","2","2020-05-08 18:10:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-08 18:57:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****