\r\n\t\t\t\t\tC15-121 4X6X6.5 $1322.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1128.00","deposit":"0.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1101,"NEW","C15-CT207725",1322,1128,0,0,"6","6",6768,6768,6768,"2020-04-27 12:08:17","0",null,null,null,"2020-04-24","2020-10-23","6 months contract. Storage rental paid by bank transfer on April 27, 2020. Storage deposit transferred from agreement C15-CT207047 to this agreement.\r\n","2020-04-24","24",0,null,0,"0","2","2020-04-27 12:08:16","2","2020-04-27 12:08:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"\u20180012415083","C181101","BUSINESS","Ms","RlKt34vcZvRZ1B47nY\/fgQ==","eg6mnYsOn64SOpH7hwzmzw==","Alive Yoga Alliance Ltd","J4gN8qCnHYBqifDoM\/w3B4pMnK9R3SOmOekdx0aWx8wFimkFSq\/ovz+SLDRz0JHP0zuDSTMzbkaxg9fQx26Whny0nYhF6eJVpEH5UtgLSVs=","tjARpijmRPN33ts7XMesgw==","26iudEKydkbSBd6ePqD2yTnY4IH4Yvw\/VHV7dVhQ8Rw=",null,"4sVsRnjmji+akrTf224OtJHLnqERjelObNdOANDjidM=",1,7047]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["7725","420","173","1427","%","24.94",329.7068,"2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["7725","1427","1322.0",992.3,"2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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-24","2020-10-23","1427"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:08:17","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":["7725",1101,"SETTLED","C15-I208053","2020-04-27 12:08:16","2020-04-24","2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",1,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",2,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",3,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",4,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",5,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["8053","RENT","\u9810\u7e73\u79df\u91d1",6,1128,"MO","1",1128,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6768,0,"8053"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 12:08:17","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":[1101,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207699","2020-04-27 12:08:16",6768,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["7699","DEPOSIT",null,"PAID","2020-04-27 12:08:16",0,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:08:17","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":["7699","INVOICE","8053","PAID","2020-04-27 12:08:16",6768,"2","2020-04-27 12:08:16","2","2020-04-27 12:08:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":116,"customer_code":"C160116","identity_type":"PERSONAL","identity_id":"Z412240(3)","title":"Mr","lastname":"Yip","firstname":"Chun Yin, Christopher","companyname":"","email":"ycyt2011@gmail.com","tel":"97310791","address":"Flat A, 11\/F, Block 5, Chi Fu Fa Yuen, Poklulam, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1680.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-06","renew_room_key":"189, 28869","renew_remark":"3 months contract. Special offer 5% "Rent Now" discount. Storage rental and deposit paid by EPS on January 6, 2019. Smartcard and padlock provided on January 6, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206879, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3536.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"80","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1592.10","discount":"9.95","monthly_deduct":175.916,"room_id":"401","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"401","room_code":"H11","retail_price":"1768.0","discounted_price":1592.1,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1592.1,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9552.6,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-06","rent_from":"2020-04-06","rent_to":"2020-10-05","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A12-CT20687 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":9552.6,"final_order_total":9552.6,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 28869","order_product":[],"pass":true}},"first_order_id":6879,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tH11 4X6X8 $1768.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1592.10","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",116,"NEW","A12-CT207726",1768,1592.1,0,0,"6","6",9552.6,9552.6,9552.6,"2020-04-27 12:15:04","0",null,null,null,"2020-04-06","2020-10-05","6 months contract. Storage rental and deposit paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A12-CT20687 to this agreement.\r\n","2020-04-06","24",0,null,0,"0","2","2020-04-27 12:15:04","2","2020-04-27 12:15:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189, 28869","C160116","PERSONAL","Mr","yBFqv3yedRm2dETwD480TsPV5T10uYontNxIrtMH+RQ=","H9gmHz05\/Te4s1\/V+q8XVg==","","fxfvZGmYkWyEb2\/fmXzVldmSmfr3OShFZUvCpaWMGYKDRsp\/i1TISueLKkEc\/7oK7y7MgPbVf5txYIAa1gDoFQ==","YwB44nyrK\/Fvoj4xrTDqSg==","lqpOAiJW76MOGoDiZdB+W5b5+A4TRBjkBjXXuYGKu4c=","dHU4XMO25fV5vF8UUQ0A0w==",null,1,6879]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15:04","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":["7726","80","11","401","%","9.95",175.916,"2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["7726","401","1768.0",1592.1,"2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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-04-06","2020-10-05","401"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:15: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":["7726",116,"SETTLED","A12-I208054","2020-04-27 12:15:04","2020-04-06","2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",1,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",2,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",3,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",4,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",5,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["8054","RENT","\u9810\u7e73\u79df\u91d1",6,1592.1,"MO","1",1592.1,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9552.6,0,"8054"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 12:15: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":[116,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207700","2020-04-27 12:15:04",9552.6,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["7700","DEPOSIT",null,"PAID","2020-04-27 12:15:04",0,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:15: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":["7700","INVOICE","8054","PAID","2020-04-27 12:15:04",9552.6,"2","2020-04-27 12:15:04","2","2020-04-27 12:15:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":717,"customer_code":"C180717","identity_type":"PERSONAL","identity_id":"Y323150(8)","title":"Mr","lastname":"Amerine","firstname":"Julian Steven Anthony","companyname":"","email":"julian.amerine@gmail.com","tel":"97302001","address":"Flat 503, Wah Oi House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-14","renew_room_key":"055,16508","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 28, 2020. Storage deposit transferred from agreement A18-CT207286 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tU05 4X5X7 $1605.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"1605.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",717,"NEW","A18-CT207727",1605,1605,0,0,"1","1",1605,1605,1605,"2020-04-27 12:18:36","0",null,null,null,"2020-04-14","2020-05-13","1 month contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A18-CT207516 to this agreement.\r\n\r\n","2020-04-14","20",0,null,0,"0","2","2020-04-27 12:18:35","2","2020-04-27 12:18:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16508","C180717","PERSONAL","Mr","ilVMtNKmhMv6VE7c5KYxeztG+MwYykSvCMt0zdIzHQ8=","jMvdnb6vnm7OQ3LZeY9TvA==","","tbf9qMYQ0X2kmdqBrxFeo3U2\/AVNuE51tDZAfcqBDrxcDLMrKjPy\/OI6UJNDPcMlekQpWPiGcb3Vf3oPzlvW8g==","mgiBsvordu5SgovUygNEdQ==","oplb81J2vLHxZ4GCh7eLLYvnbYcLrPelLzmcVjcZCTA=","o+ttpCoGmWwr+zclHXAYFQ==",null,1,"4839"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7727","904","1605.0","1605.00","2","2020-04-27 12:18:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-14","2020-05-13","904"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7727",717,"SETTLED","A18-I208055","2020-04-27 12:18:35","2020-04-14","2","2020-04-27 12:18:35","2","2020-04-27 12:18:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8055","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-04-27 12:18:35","2","2020-04-27 12:18:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8055"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[717,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207701","2020-04-27 12:18:35",1605,"2","2020-04-27 12:18:35","2","2020-04-27 12:18:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7701","DEPOSIT",null,"PAID","2020-04-27 12:18:35",0,"2","2020-04-27 12:18:35","2","2020-04-27 12:18:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7701","INVOICE","8055","PAID","2020-04-27 12:18:35",1605,"2","2020-04-27 12:18:35","2","2020-04-27 12:18:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20: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":"&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":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":826,"customer_code":"C180826","identity_type":"PERSONAL","identity_id":"V120085(2)","title":"Ms","lastname":"Wong","firstname":"Lai Wing","companyname":"","email":"aslinnlaiwing@gmail.com","tel":"60823501","address":"Flat B, 23\/F, Yee Wan Court, 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":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-21","renew_room_key":"052,37309","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 27, 2020. Storage deposit transferred from agreement A12-CT207252 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tD11 4X3X4 $598.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",826,"NEW","A12-CT207728",598,598,0,0,"1","1",598,598,598,"2020-04-27 12:20:19","0",null,null,null,"2020-04-21","2020-05-20","1 month contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A12-CT207501 to this agreement.\r\n\r\n","2020-04-21","12",0,null,0,"0","2","2020-04-27 12:20:19","2","2020-04-27 12:20:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,37309","C180826","PERSONAL","Ms","AVQEhVbkdf0QwgZhPqTuvQ==","hULSwM2MvFtpeV9\/z+er8Q==","","VYTecHlXsAq2HU\/SK2vg0HE0ESjbB0AIG1TtdkNrHvzSOFADaqlQfFPEOwNTSSdXg5YSZtYVVGLVGFZuRQfF9AxsFxu92jPjM0q+fUqGSyI=","M\/mMkpABptC23N0qOMtMOA==","I+DcTUTCSlvqwNtqcfOhWkdyXo7XLnfkUFX2VHxYh3c=","d\/8HRqfi7sBcCF03ucfekg==",null,1,"4840"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7728","207","598.0","598.00","2","2020-04-27 12:20:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-21","2020-05-20","207"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7728",826,"SETTLED","A12-I208056","2020-04-27 12:20:19","2020-04-21","2","2020-04-27 12:20:19","2","2020-04-27 12:20:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8056","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-27 12:20:19","2","2020-04-27 12:20:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8056"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[826,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207702","2020-04-27 12:20:19",598,"2","2020-04-27 12:20:19","2","2020-04-27 12:20:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7702","DEPOSIT",null,"PAID","2020-04-27 12:20:19",0,"2","2020-04-27 12:20:19","2","2020-04-27 12:20:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:20:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7702","INVOICE","8056","PAID","2020-04-27 12:20:19",598,"2","2020-04-27 12:20:19","2","2020-04-27 12:20:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:33:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:33:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:57:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":213,"customer_code":"C160213","identity_type":"PERSONAL","identity_id":"D213817(5)","title":"Ms","lastname":"Chiu","firstname":"Wai Yi, Wendy","companyname":"","email":"wai_waicheng@yahoo.com.hk","tel":"90753288","address":"Room 1032, Wah Ming House, Wah Fu Estate, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2328.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-07","renew_room_key":"137,03416,136,64224","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 12, 2020. Storage deposit transferred from agreement A12-CT196191 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tB36 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tB35 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"40","total_discounted_price":"2328.00","deposit":"0.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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",213,"NEW","A12-CT207729",3056,2328,0,0,"3","3",6984,6984,6984,"2020-04-27 12:59:21","0",null,null,null,"2020-04-07","2020-07-06","3 months contract. Storage rental paid by bank transfer on April 27, 2020. Storage deposit transferred from agreement A12-CT207177 to this agreement.\r\n\r\n","2020-04-07","40",0,null,0,"0","2","2020-04-27 12:59:21","2","2020-04-27 12:59:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,03416,136,64224","C160213","PERSONAL","Ms","2S1nuKYxzBQN\/HErX3zc4Q==","sQFQFKDK2lCJDg4WUvEEAw==","","SoL2cPYh\/\/uwHaf\/Kd3Lts1Qx1oqh4qgYJTzV+EQU7ucSrBKZz2RDTb2Z7tA0RIwIcjHIINeEHw\/T+G3Mr5wAw==","t8OH+X7T0O\/zjHukl5kvww==","Bia8FXQfSDTjOo0FAQsdw+1lMAMS6o8AFLu5QNxWLYc=","qggRIpTbNDaCFQ\/oRJ948A==",null,1,"4413"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["7729","88","1528.0","1528.00","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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-07","2020-07-06","88"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:59:21","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":["7729","87","1528.0","1528.00","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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-07","2020-07-06","87"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 12:59:21","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":["7729",213,"SETTLED","A12-I208057","2020-04-27 12:59:21","2020-04-07","2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["8057","RENT","\u9810\u7e73\u79df\u91d1",1,2328,"MO","1",2328,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["8057","RENT","\u9810\u7e73\u79df\u91d1",2,2328,"MO","1",2328,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["8057","RENT","\u9810\u7e73\u79df\u91d1",3,2328,"MO","1",2328,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6984,0,"8057"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 12:59:21","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":[213,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207703","2020-04-27 12:59:21",6984,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["7703","DEPOSIT",null,"PAID","2020-04-27 12:59:21",0,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 12:59:21","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":["7703","INVOICE","8057","PAID","2020-04-27 12:59:21",6984,"2","2020-04-27 12:59:21","2","2020-04-27 12:59:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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=%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":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":52,"customer_code":"C160052","identity_type":"PERSONAL","identity_id":"K962314(0)","title":"Mr","lastname":"Lai","firstname":"Lai Man","companyname":"","email":"lailaiman@gmail.com","tel":"62528660","address":"11B \u5146\u7fa4\u5927\u53a6 , \u9999\u6e2f\u4ed4\u820a\u5927\u8857120\u53f7","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-01","renew_room_key":"055,40643","renew_remark":"13 months contract, special renewal offer, one month free. Storage rental paid by bank transfer on April 3, 2019. Storage deposit transferred from agreement A12-CT183184 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194714, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"405","room_code":"H15","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-05-31","delivery_service":"0","remark":"13 months contract, Storage rental paid by bank transfer on April 25, 2020. Storage deposit transferred from agreement A12-CT194714 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,40643","order_product":[],"pass":true}},"first_order_id":4714,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tH15 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"899.0","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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","1",52,"NEW","A12-CT207730",998,899,0,0,"13","13",10788,11687,10788,"2020-04-27 13:05:11","0",null,null,null,"2020-05-01","2021-05-31","13 months contract, Storage rental paid by bank transfer on April 25, 2020. Storage deposit transferred from agreement A12-CT194714 to this agreement.\r\n","2020-05-01","12",0,null,899,"899.0","2","2020-04-27 13:05:10","2","2020-04-27 13:05:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,40643","C160052","PERSONAL","Mr","ccXxwL+X\/60i5jaOJxJ4vw==","lzx0GiXnrd0waIhp6oozpQ==","","dffhvHC4fLsfT+ovkkdjtIABXG52GP0ZO62F9LaNcQeAggdY2Q3M64UHkGVDyehs","X4PPecNQlbcusZ9USOY5dw==","n9WlT236e39wzEct3ye51xbRwlsmxVBbPr1WTaiy\/nc=","fotCf40jGzvJ0Id200Q4wQ==",null,1,4714]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["7730","405","998.0","998.00","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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-01","2021-05-31","405"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 13:05: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":["7730",52,"SETTLED","A12-I208058","2020-04-27 13:05:10","2020-05-01","2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["8058","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8058"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 13:05: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":[52,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207704","2020-04-27 13:05:10",10788,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["7704","DEPOSIT",null,"PAID","2020-04-27 13:05:10",0,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 13:05: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":["7704","INVOICE","8058","PAID","2020-04-27 13:05:10",10788,"2","2020-04-27 13:05:10","2","2020-04-27 13:05:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined&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":"496","master_room_id":"35","room_code":"K33"},{"room_id":"497","master_room_id":"35","room_code":"K34"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":402,"customer_code":"C170402","identity_type":"PERSONAL","identity_id":"K779668(4)","title":"Ms","lastname":"Tam","firstname":"Pui Yee","companyname":"","email":"ptjj@yahoo.com.hk","tel":"95220457","address":"\u9999\u6e2f\u4e2d\u5fc3\u6e2f\u6cf0\u95a35\/F 2 \u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-04","renew_room_key":"054,62045","renew_remark":"6 months contract. Storage rental paid by cash on Nov 02, 2019. Storage deposit transferred from agreement A14-CT194861 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196286, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"653","room_code":"M64","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"652","room_code":"M63","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"639","room_code":"M50","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"638","room_code":"M49","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"36","total_retail_price":3100,"total_discounted_price":2018,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2020-11-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on April 27, 2020. Storage deposit transferred from agreement A14-CT196286 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":12108,"final_order_total":12108,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,62045","order_product":[],"pass":true}},"first_order_id":"4861","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tM64 3X3X8 $775.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM63 3X3X8 $775.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM50 3X3X8 $775.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM49 3X3X8 $775.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"36","total_discounted_price":"2018.0","deposit":"0","total_retail_price":"3100.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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",402,"NEW","A14-CT207731",3100,2018,0,0,"6","6",12108,12108,12108,"2020-04-27 14:32:05","0",null,null,null,"2020-05-04","2020-11-03","6 months contract. Storage rental paid by cash on April 27, 2020. Storage deposit transferred from agreement A14-CT196286 to this agreement.\r\n","2020-05-04","36",0,null,0,"0","2","2020-04-27 14:32:04","2","2020-04-27 14:32:04","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"054,62045","C170402","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","RAqogkelEKt1q5b\/6Neu\/g==","","ngBuy8OQqro6+H4mFm4Klb3E5nKmqJDpQPYOU+XMsoM=","miutNh8ttt2lwXl3bqYwqA==","t2MjVIWdE7LmMJbBi1h8JInhg5l5DfqkONHAbJxvB3Q=","dgDJvzXQPGbMBUYthj6l+g==",null,1,"4861"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["7731","653","775.0","775.00","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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-04","2020-11-03","653"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 14:32:05","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":["7731","652","775.0","775.00","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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-04","2020-11-03","652"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 14:32:05","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":["7731","639","775.0","775.00","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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-04","2020-11-03","639"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 14:32:05","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":["7731","638","775.0","775.00","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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-04","2020-11-03","638"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 14:32:05","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":["7731",402,"SETTLED","A14-I208059","2020-04-27 14:32:04","2020-05-04","2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["8059","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12108,0,"8059"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 14:32:05","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":[402,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207705","2020-04-27 14:32:04",12108,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["7705","DEPOSIT",null,"PAID","2020-04-27 14:32:04",0,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 14:32:05","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":["7705","INVOICE","8059","PAID","2020-04-27 14:32:04",12108,"2","2020-04-27 14:32:04","2","2020-04-27 14:32:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 15:27:56","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","054,62045","6 months contract. Storage rental paid by cash on April 27, 2020. Storage deposit transferred from agreement A14-CT196286 to this agreement.\r\n","2020-04-27 15:27:56","2","RAqogkelEKt1q5b\/6Neu\/g==","pW1T\/bCpncDmYxmrSj5N3Q==","5NwITZMppixuKFTVKV\/zRtJ3nI0nC4XD\/3xU\/TeiZ14=","miutNh8ttt2lwXl3bqYwqA==","ngBuy8OQqro6+H4mFm4Klb3E5nKmqJDpQPYOU+XMsoM=",7731]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 15:30:08","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","054,62045","6 months contract. Storage rental paid by cash on April 27, 2020. Storage deposit transferred from agreement A14-CT196286 to this agreement.\r\n","2020-04-27 15:30:08","2","RAqogkelEKt1q5b\/6Neu\/g==","pW1T\/bCpncDmYxmrSj5N3Q==","5NwITZMppixuKFTVKV\/zRtJ3nI0nC4XD\/3xU\/TeiZ14=","miutNh8ttt2lwXl3bqYwqA==","MbXLo1aMX5l37uwz55QEmVb6LXpcbgPXoSXyX52loew=",7731]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00:42","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":"","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":386,"customer_code":"C170386","identity_type":"PERSONAL","identity_id":"D602129(9)","title":"Mr","lastname":"Leung","firstname":"Yue Chau","companyname":"","email":null,"tel":"90522403","address":"Room 1, 5\/F,Block G,Kong Cheung Court,Aberdeen Centre,Aberdeen Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-29","renew_room_key":"055,43592","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 15, 2019. Storage deposit transferred from agreement A14-CT194807 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196701, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"725","room_code":"O01","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-29","rent_from":"2020-04-29","rent_to":"2020-10-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A14-CT196701 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4188,"final_order_total":4188,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,43592","order_product":[],"pass":true}},"first_order_id":"4807","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tO01 3X3X8 $775.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"9","total_discounted_price":"698.0","deposit":"0.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",386,"NEW","A14-CT207732",775,698,0,0,"6","6",4188,4188,4188,"2020-04-27 17:00:42","0",null,null,null,"2020-04-29","2020-10-28","6 months contract. Storage rental paid by bank transfer on April 26, 2020. Storage deposit transferred from agreement A14-CT196701 to this agreement.\r\n","2020-04-29","9",0,null,0,"0","2","2020-04-27 17:00:42","2","2020-04-27 17:00:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,43592","C170386","PERSONAL","Mr","EKZGYkq9Fgc2MgExx80L8A==","xEf2h2aoyRQ71ZVgBH+9WQ==","","7uTYAvo5\/f5ZghMIb5PeXhYcDwMB6lueWG0cuSUYBXS6gP0u5y7jr\/ex9I6rrX57z4fZ\/clwo3dPMgjCd0PPHZ6xkIZkgcGhucwYuLecEH8=","kIQB1hHMXJ+NvVQ3Hcc51g==",null,"wVFrC1hBOBVwIVXzd9wRHg==",null,1,"4807"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["7732","725","775.0","775.00","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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-04-29","2020-10-28","725"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 17:00: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":["7732",386,"SETTLED","A14-I208060","2020-04-27 17:00:42","2020-04-29","2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["8060","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4188,0,"8060"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 17:00: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":[386,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207706","2020-04-27 17:00:42",4188,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["7706","DEPOSIT",null,"PAID","2020-04-27 17:00:42",0,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:00: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":["7706","INVOICE","8060","PAID","2020-04-27 17:00:42",4188,"2","2020-04-27 17:00:42","2","2020-04-27 17:00:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:16:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z114327 (2)","title":"Ms","lastname":"Chan","firstname":"Sze Man","companyname":"","email":"kerrychan8@hotmail.com","tel":"95596963","address":"Flat 5, 16\/F, Hoi Tin Court, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"68 available_room_list_input","master_room_id":"1","discount_type":"%","price":"598.00","disocunted_price":"538.20","discount":"10.00","monthly_deduct":59.8,"room_id":"198","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"198","room_code":"D02","retail_price":"598.0","discounted_price":538.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4062,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"362","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-10-31","delivery_service":"0","remark":"6 months contract. Special offer $200 \"switch to us\" discount and 5% \"Rent Now\" discount. Storage deposit $500 paid by cash on April 20, 2020. Remaining deposit and rental $3562 paid by EPS on April 27, 2020. Smartcard provided on April 27, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":362,"order_total":4424,"final_order_total":4062,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 26395","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tD02 4X3X4 $598.00 - <\/td> \u9810\u4ed86\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201573","PERSONAL","Ms","ekzf7Q7fqvVwKitxvrhu+Q==","U9yoE9KqV1v8YlRkf7Q2yg==","","V0mo8agpjMl3lrZeZ9\/BFg==","KD1wRP+X9+jggiZoqdV660zYOGmgpYocKih9\/hdU4h4=","vXFbud71YE0O88CPXq7NxUvIyNGkylLlzo7xnn8CwIl4+VKl1jqu85u8OkIWEfM4","De1AW6C3HpeXKRET5v2brQ==",null,"KD1wRP+X9+jggiZoqdV660zYOGmgpYocKih9\/hdU4h4=","1qdAgStqY+4Q4nAGObo41w==","2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1573,"NEW","A12-CT207733",598,538,1196,0,"6","6",4062,4424,4062,"2020-04-27 17:32:51","0",null,null,null,"2020-05-01","2020-10-31","6 months contract. Special offer $200 \"switch to us\" discount and 5% \"Rent Now\" discount. Storage deposit $500 paid by cash on April 20, 2020. Remaining deposit and rental $3562 paid by EPS on April 27, 2020. Smartcard provided on April 27, 2020. ","2020-05-01","12",0,null,362,"362","2","2020-04-27 17:32:50","2","2020-04-27 17:32:50","EPS","","","","EPS","","","",null,0,"190, 26395","C201573","PERSONAL","Ms","ekzf7Q7fqvVwKitxvrhu+Q==","U9yoE9KqV1v8YlRkf7Q2yg==","","vXFbud71YE0O88CPXq7NxUvIyNGkylLlzo7xnn8CwIl4+VKl1jqu85u8OkIWEfM4","V0mo8agpjMl3lrZeZ9\/BFg==","KD1wRP+X9+jggiZoqdV660zYOGmgpYocKih9\/hdU4h4=","De1AW6C3HpeXKRET5v2brQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","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":["7733","68 available_room_list_input","1","198","%","10.00",59.8,"2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7733","198","598.0",538.2,"2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-10-31","198"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-27 17:32:51","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":["7733","A12-D205392","PAID",1196,0,"2020-10-31","2020-04-27 17:32:50","2020-04-27 17:32:50","2","2020-04-27 17:32:50","2","2020-04-27 17:32:50",1573]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7733",1573,"SETTLED","A12-I208061","2020-04-27 17:32:50","2020-05-01","2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,176,"MO","1",176,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8061","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2866,0,"8061"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1573,"EPS","","","","EPS","","","","PAID","P207707","2020-04-27 17:32:50",4062,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7707","DEPOSIT","5392","PAID","2020-04-27 17:32:50",1196,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:32:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7707","INVOICE","8061","PAID","2020-04-27 17:32:50",2866,"2","2020-04-27 17:32:50","2","2020-04-27 17:32:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 17:44:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 18:34:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-27 18:38:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****