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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
C15-091 <\/td>\n\t\t\t\t\t	3X3X6.5 <\/td>\n\t\t\t\t\t	$720.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"9","total_discounted_price":"648.00","deposit":"720.00","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1559","NEW","C15-CT207746",720,648,720,0,"12","12",6880,8496,6880,"2020-04-29 14:30:04","0",null,null,null,"2020-04-29","2021-04-28","12 months contract. Special offer 5% discount and the 11th, 12th months free of charge. Storage rental and deposit paid by bank transfer on April 29,2020. ","2020-04-29","9",0,null,1616,"1616","2","2020-04-29 14:30:03","2","2020-04-29 14:30:03","UNPAID","","","","BANKIN","","","",null,0,"190,26650","C201559","PERSONAL","Ms","F8H1Hlk3LobqKcRLjVrCxg==","5SiBtHhK6HckOrH\/MZv9Sw==","","mo+KbGzXS+k2iPHMOiZNhW6ZaHW45edCafWWSZmGNqQypZqcrXtsbdLnjIDBltfg","5rtD6J2OPtEufCSD6\/WFGA==","mkRvBasLTuCBEl2lhLCkOkZoGWiAOUqAfCg5C3nYQZs=","lBqq4OxHnOwpeGhqVg3Ijg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["7746","1397","720.0","720.00","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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-29","2021-04-28","1397"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-29 14:30:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7746","C15-D205393","NEW",720,720,"2021-04-28","2020-04-29 14:30:03","2020-04-29 14:30:03","2","2020-04-29 14:30:03","2","2020-04-29 14:30:03","1559"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["7746","1559","SETTLED","C15-I208074","2020-04-29 14:30:03","2020-04-29","2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,328,"MO","1",328,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",4,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",5,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",6,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",7,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",8,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",9,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",10,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",11,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["8074","RENT","\u9810\u7e73\u79df\u91d1",12,648,"MO","1",648,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6160,0,"8074"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-29 14:30: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":["1559","UNPAID","","","","BANKIN","","","","PAID","P207720","2020-04-29 14:30:03",6160,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03","INVOICE"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 14:30: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":["7720","INVOICE","8074","PAID","2020-04-29 14:30:03",6160,"2","2020-04-29 14:30:03","2","2020-04-29 14:30:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:23:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `amount` = ?, `balance` = ?, `docdate` = ?, `duedate` = ?, `remark` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["",712,"SENT","A12-I208075",60,60,"2020-04-29 16:23:59","2020-04-29","Smart card no. 190,21996. $60 paid by cash.","2","2020-04-29 16:23:59","2","2020-04-29 16:23:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:23:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":[712,"11","1","60.0",60,"2","2020-04-29 16:23:59","2","2020-04-29 16:23:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:23:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8075","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-04-29 16:23:59","2","2020-04-29 16:23:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:17","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=999&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"132","master_room_id":"8","room_code":"C08"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C08 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"H154808(7)","title":"Ms","lastname":"YEUNG","firstname":"Chi Ying","companyname":"","email":"nakitaycy@yahoo.com","tel":"92820452","address":"Ground Floor, Hoi Chu Court, Aberdeen, ","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"132","room_code":"C08","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":2076,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12975,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2595.00","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-05-31","delivery_service":"0","remark":"13 months contract. Special offer 50% off for the first 3 months and the 13th month FREE. Storage deposit $500 paid by cheque on March 30, 2020. Remaining deposit and rental paid by cheque on April 29, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2595,"order_total":15570,"final_order_total":12975,"location_id":"1","branch_id":"1","company_id":"1","room_key":"088, 29682","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","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":["C201574","PERSONAL","Ms","BMcP0tQawpxJXumi0T\/zKg==","cehTPCv0LSZ1f3zKZGLhBA==","","0svGERrNI2kJfUHMDo0asg==","IRzomZukhKHAG9D6PiiugaBdPzBJd9bgNGiXNbD0k80=","Y5QFwd9iSt2FZhZoN1\/fQDlthdKWh\/UukHDjOjVJiINkDTFhZrEPyUs4J20J3TKQ","kcndrmicvdUjZ6dmZcqUvQ==",null,"IRzomZukhKHAG9D6PiiugaBdPzBJd9bgNGiXNbD0k80=","jOSWM5ryU1B23d+0HuHwdg==","2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1574,"NEW","A12-CT207747",1098,1038,2076,0,"13","13",12975,15570,12975,"2020-04-29 16:27:19","0",null,null,null,"2020-05-01","2021-05-31","13 months contract. Special offer 50% off for the first 3 months and the 13th month FREE. Storage deposit $500 paid by cheque on March 30, 2020. Remaining deposit and rental paid by cheque on April 29, 2020. ","2020-05-01","16",0,null,2595,"2595.00","2","2020-04-29 16:27:17","2","2020-04-29 16:27:17","CHEQUE","","","","CHEQUE","","","",null,0,"088, 29682","C201574","PERSONAL","Ms","BMcP0tQawpxJXumi0T\/zKg==","cehTPCv0LSZ1f3zKZGLhBA==","","Y5QFwd9iSt2FZhZoN1\/fQDlthdKWh\/UukHDjOjVJiINkDTFhZrEPyUs4J20J3TKQ","0svGERrNI2kJfUHMDo0asg==","IRzomZukhKHAG9D6PiiugaBdPzBJd9bgNGiXNbD0k80=","kcndrmicvdUjZ6dmZcqUvQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7747","132","1098.0","1098.00","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2021-05-31","132"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-29 16:27:19","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":["7747","A12-D205394","PAID",2076,0,"2021-05-31","2020-04-29 16:27:17","2020-04-29 16:27:17","2","2020-04-29 16:27:17","2","2020-04-29 16:27:17",1574]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7747",1574,"SETTLED","A12-I208076","2020-04-29 16:27:17","2020-05-01","2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,519,"MO","1",519,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",4,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",5,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",6,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",7,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",8,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",9,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",10,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",11,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",12,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8076","RENT","\u9810\u7e73\u79df\u91d1",13,1038,"MO","1",1038,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10899,0,"8076"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1574,"CHEQUE","","","","CHEQUE","","","","PAID","P207721","2020-04-29 16:27:17",12975,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7721","DEPOSIT","5394","PAID","2020-04-29 16:27:17",2076,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 16:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7721","INVOICE","8076","PAID","2020-04-29 16:27:17",10899,"2","2020-04-29 16:27:17","2","2020-04-29 16:27:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 17:31:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 18:31:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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=999&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"132","master_room_id":"8","room_code":"C08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":637,"customer_code":"C170637","identity_type":"PERSONAL","identity_id":"D706815(9)","title":"Mr","lastname":"Choy","firstname":"Yuk Ling Francis","companyname":"","email":"garyc2hk@yahoo.com.hk","tel":"94332403","address":"6E, 6\/F, Jing Hui Garden, 8 Aberdeen Main Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"055,14113","renew_remark":"1 month contract. Storage rental paid by PPS on March 31, 2020. Storage deposit $2456 transferred from agreement A18-CT207287 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207545, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"981","room_code":"X06","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-05-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 28, 2020. Storage deposit $2456 transferred from agreement A18-CT207545 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,14113","order_product":[],"pass":true}},"first_order_id":"4858","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> X06 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1228.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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",637,"NEW","A18-CT207748",1290,1228,0,0,"1","1",1228,1228,1228,"2020-04-29 19:17:43","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental paid by PPS on April 28, 2020. Storage deposit $2456 transferred from agreement A18-CT207545 to this agreement. \r\n","2020-05-01","16",0,null,0,"0","2","2020-04-29 19:17:43","2","2020-04-29 19:17:43","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,14113","C170637","PERSONAL","Mr","J+g+TeRBIdzsY6tyXdUL4DZdTF+kJBMmq07PxUuV2rQ=","UrsMAvfb5x9QBcnJ8435JA==","","IqhgG3xSMZDgzwxkBvRbXd3aZXF9S\/xKJDNT6bRp\/CaVT0KgEUyW3DMnqWGhAmYTEqUAiJDuiC0jx5487vY8cg==","46NXlqFaJugFX+V9A1awbQ==","j6foxYTVlm9b0h+GRpM4lraceSoVkydGqoE3S05vxDI=","zgahvSRYS8hsN+dhdAMC4A==",null,1,"4858"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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":["7748","981","1290.0","1290.00","2","2020-04-29 19:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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-05-31","981"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-29 19:17:43","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":["7748",637,"SETTLED","A18-I208077","2020-04-29 19:17:43","2020-05-01","2","2020-04-29 19:17:43","2","2020-04-29 19:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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":["8077","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-04-29 19:17:43","2","2020-04-29 19:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"8077"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-29 19:17:43","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":[637,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207722","2020-04-29 19:17:43",1228,"2","2020-04-29 19:17:43","2","2020-04-29 19:17:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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":["7722","DEPOSIT",null,"PAID","2020-04-29 19:17:43",0,"2","2020-04-29 19:17:43","2","2020-04-29 19:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:17:43","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":["7722","INVOICE","8077","PAID","2020-04-29 19:17:43",1228,"2","2020-04-29 19:17:43","2","2020-04-29 19:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:27","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=999&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"132","master_room_id":"8","room_code":"C08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":581,"customer_code":"C170581","identity_type":"PERSONAL","identity_id":"Z413372(3)","title":"Mr","lastname":"Tang","firstname":"Roy Chi Hang","companyname":"","email":"roytch@msn.com","tel":"91607386","address":"26D, Block 19, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3140.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-11","renew_room_key":"137,03135","renew_remark":"12 months contract. Storage rental paid by EPS on May 16, 2019. Storage deposit transferred from agreement A18-CT183459 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194964, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"955","room_code":"V29","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"},{"room_id":"954","room_code":"V28","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"56","total_retail_price":4322,"total_discounted_price":3140,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":37680,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2021-05-10","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on April 29, 2020. Storage deposit transferred from agreement A18-CT194964 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":37680,"final_order_total":37680,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,03135","order_product":[],"pass":true}},"first_order_id":"3459","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> V29 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> V28 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"56","total_discounted_price":"3140.0","deposit":"0","total_retail_price":"4322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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",581,"NEW","A18-CT207749",4322,3140,0,0,"12","12",37680,37680,37680,"2020-04-29 19:27:28","0",null,null,null,"2020-05-11","2021-05-10","12 months contract. Storage rental paid by bank transfer on April 29, 2020. Storage deposit transferred from agreement A18-CT194964 to this agreement.","2020-05-11","56",0,null,0,"0","2","2020-04-29 19:27:27","2","2020-04-29 19:27:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,03135","C170581","PERSONAL","Mr","sas7mvvQ98xG8l5tJvWCdg==","M7CfcmE2OSMlZOkNgaoDmQ==","","JWE2kuTnznPXZofCPh1BH3ulvBiAS7orXgGg5RVIwShtg6v8x7uC0jLSM+\/ga\/7Q2qkmStFYpZ1pwpk24a+x6g==","AqREJ4X9Z\/rK1YfBHhvvSw==","V8rlQoo\/HaiJBtJFf603\/w==","cbbqgAPTTX0tugXrJbNOvQ==",null,1,"3459"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["7749","955","2161.0","2161.00","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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-11","2021-05-10","955"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-29 19:27:28","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":["7749","954","2161.0","2161.00","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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-11","2021-05-10","954"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-29 19:27:28","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":["7749",581,"SETTLED","A18-I208078","2020-04-29 19:27:27","2020-05-11","2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",1,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",2,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",3,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",4,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",5,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",6,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",7,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",8,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",9,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",10,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",11,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["8078","RENT","\u9810\u7e73\u79df\u91d1",12,3140,"MO","1",3140,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[37680,0,"8078"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-29 19:27:28","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":[581,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207723","2020-04-29 19:27:27",37680,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["7723","DEPOSIT",null,"PAID","2020-04-29 19:27:27",0,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-29 19:27:28","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":["7723","INVOICE","8078","PAID","2020-04-29 19:27:27",37680,"2","2020-04-29 19:27:27","2","2020-04-29 19:27:27"]},"data_before":[],"data_after":[],"step":1} *****