\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>
B01-070 <\/td>\n\t\t\t\t\t	5X7X7 <\/td>\n\t\t\t\t\t	$2090.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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":"35","total_discounted_price":"1275.00","deposit":"4180.00","total_retail_price":"2090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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","2","5","1400","NEW","B01-CT196689",2090,1275,4180,0,"12","12",5158,19480,5158,"2019-12-13 15:49:46","0",null,null,null,"2019-11-23","2020-11-22","12 months contract. Changed unit from B01-077 to B01-070. Storage rental $10366 and deposit $3956 (ttl:$14322) transferred from agreement B01-CT195974 to this agreement. Remaining balance $5158 paid by bank transfer on Nov 27,2019. Smartcard provided on September 18, 2019.","2019-11-23","35",0,null,14322,"14322","2","2019-12-13 15:49:45","2","2019-12-13 15:49:45","BANKIN","","","","BANKIN","","","",null,0,"12385453","C191400","PERSONAL","Ms","+D+KKHs3prwjkM6D4LeIqA==","xEf2h2aoyRQ71ZVgBH+9WQ==","","raL9mQIdPGGwWsIuGBAHNjJCy2SXF93aWAxZIBd2vC3Mm8iUJvMi5gkGZD7Ol2keUmH7xv+jsL9gX+xkq\/iUVA==","r47LDNPVnTTyng8Tsh1cJA==",null,"c68BS71QZ9Lo9rWwNcnDxw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["6689","484 available_room_list_input","150","1260","%","16.88",352.792,"2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["6689","1260","2090.0",1737.2,"2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["2019-11-23","2020-11-22","1260"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-13 15:49:46","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":["6689","B01-D195214","PAID",4180,0,"2020-11-22","2019-12-13 15:49:45","2019-12-13 15:49:45","2","2019-12-13 15:49:45","2","2019-12-13 15:49:45","1400"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["6689","1400","SETTLED","B01-I197017","2019-12-13 15:49:45","2019-11-23","2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",6,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",7,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",8,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",9,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",10,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",11,0,"MO","1",0,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["7017","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",12,978,"MO","1",978,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[978,0,"7017"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-13 15:49:46","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":["1400","BANKIN","","","","BANKIN","","","","PAID","P196667","2019-12-13 15:49:45",5158,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["6667","DEPOSIT","5214","PAID","2019-12-13 15:49:45",4180,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:49:46","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":["6667","INVOICE","7017","PAID","2019-12-13 15:49:45",978,"2","2019-12-13 15:49:45","2","2019-12-13 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 15:51:26","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0012385453","12 months contract. Changed unit from B01-077 to B01-070. Storage rental $10366 and deposit $3956 (ttl:$14322) transferred from agreement B01-CT195974 to this agreement. Remaining balance $5158 paid by bank transfer on Nov 27,2019. Smartcard provided on September 18, 2019.","2019-12-13 15:51:26","2","xEf2h2aoyRQ71ZVgBH+9WQ==","+D+KKHs3prwjkM6D4LeIqA==","r47LDNPVnTTyng8Tsh1cJA==","raL9mQIdPGGwWsIuGBAHNjJCy2SXF93aWAxZIBd2vC3Mm8iUJvMi5gkGZD7Ol2keUmH7xv+jsL9gX+xkq\/iUVA==",6689]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15: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":"filter1=2&filter2=1007&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":661,"customer_code":"C170661","identity_type":"PERSONAL","identity_id":"Z031541(A)","title":"Mr","lastname":"Kwok","firstname":"Siu Wah","companyname":"","email":"siuwah914@gmail.com","tel":"94148658","address":"Room 1, 21\/F, Tin Fai House, Yue Fai Court, Aberdeen Main Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-30","renew_room_key":"056,19685","renew_remark":"12 months contract. Storage rental paid by bank transfer on December 18, 2018. Storage deposit transferred from agreement A18-CT182551 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT183944, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"990","room_code":"X15","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-01-29","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit transferred from agreement A18-CT183944 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"3","branch_id":"1","company_id":"1","room_key":"056,19685","order_product":[],"pass":true}},"first_order_id":3944,"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> X15 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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",661,"NEW","A18-CT196690",1090,981,0,0,"13","13",11772,12753,11772,"2019-12-13 17:15:22","0",null,null,null,"2019-12-30","2020-01-29","12 months contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit transferred from agreement A18-CT183944 to this agreement.","2019-12-30","12",0,null,981,"981.00","2","2019-12-13 17:15:21","2","2019-12-13 17:15:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,19685","C170661","PERSONAL","Mr","3JNLQh67h8IOVnWCv04Dcw==","+pNULpsInm3siHASV0hIrg==","","ne5GVtxTRsc1\/DEl\/+jiLv1qq3vXkwaSOK\/BXcQ6qGFmxWhkJDMbN5q96HA8+Uc7j8u7LxssCoA+ewFo46uYxvwvP1QB1Cvm7Uk7NCkADVg=","n+iW+bT6CnzlBZxFRCyKuA==","95D\/+rP0lzM1D8dMQKphtJnYguSoTolubpuD2O1mRio=","pIdgwpgHr7WgJKvXHiCOwQ==",null,1,3944]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["6690","990","1090.0","1090.00","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["2019-12-30","2020-01-29","990"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-13 17:15:22","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":["6690",661,"SETTLED","A18-I197018","2019-12-13 17:15:21","2019-12-30","2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["7018","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"7018"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-13 17:15:22","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":[661,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196668","2019-12-13 17:15:21",11772,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["6668","DEPOSIT",null,"PAID","2019-12-13 17:15:21",0,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:15:22","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":["6668","INVOICE","7018","PAID","2019-12-13 17:15:21",11772,"2","2019-12-13 17:15:21","2","2019-12-13 17:15:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:08","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=1007&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A12-CT196220 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196668, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-03","rent_from":"2019-12-03","rent_to":"2020-01-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A12-CT196668 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/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","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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",574,"NEW","A12-CT196691",1098,1038,0,0,"1","1",1038,1038,1038,"2019-12-13 17:18:09","0",null,null,null,"2019-12-03","2020-01-02","1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A12-CT196668 to this agreement.","2019-12-03","16",0,null,0,"0","2","2019-12-13 17:18:08","2","2019-12-13 17:18:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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":["6691","144","1098.0","1098.00","2","2019-12-13 17:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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":["2019-12-03","2020-01-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-13 17:18:09","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":["6691",574,"SETTLED","A12-I197019","2019-12-13 17:18:08","2019-12-03","2","2019-12-13 17:18:08","2","2019-12-13 17:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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":["7019","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-13 17:18:08","2","2019-12-13 17:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7019"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-13 17:18:09","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":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196669","2019-12-13 17:18:08",1038,"2","2019-12-13 17:18:08","2","2019-12-13 17:18:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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":["6669","DEPOSIT",null,"PAID","2019-12-13 17:18:08",0,"2","2019-12-13 17:18:08","2","2019-12-13 17:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 17:18:09","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":["6669","INVOICE","7019","PAID","2019-12-13 17:18:08",1038,"2","2019-12-13 17:18:08","2","2019-12-13 17:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1007&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":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1143,"customer_code":"C181143","identity_type":"PERSONAL","identity_id":"P043956(1)","title":"Mr","lastname":"NG","firstname":"Chi On","companyname":"","email":"redteac668@gmail.com","tel":"91507763","address":"Flat\/Rm 24 Floor 14, Yick Fat Building, 1048 King's Road, Quarry Bay ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"684.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-10","renew_room_key":"0012513902","renew_remark":"3 month contract. Storage rental paid by bank transfer on September 10, 2019. Storage deposit $720 transferred from agreement C15-CT195226 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195926, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"159","order_discount":[{"master_room_discount_id":"411","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"684.00","discount":"5.00","monthly_deduct":36,"room_id":"1411","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1411","room_code":"C15-105","retail_price":"720.0","discounted_price":684,"location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":684,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2052,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-10","rent_from":"2019-12-10","rent_to":"2020-03-09","delivery_service":"0","remark":"3 month contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit $720 transferred from agreement C15-CT195926 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2052,"final_order_total":2052,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012513902","order_product":[],"pass":true}},"first_order_id":"4483","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> C15-105 <\/td>\r\n\t\t\t\t\t 3X3X6.5 <\/td>\r\n\t\t\t\t\t $720.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"684.0","deposit":"0","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1143,"NEW","C15-CT196692",720,684,0,0,"3","3",2052,2052,2052,"2019-12-13 18:16:26","0",null,null,null,"2019-12-10","2020-03-09","3 month contract. Storage rental paid by bank transfer on December 13, 2019. Storage deposit $720 transferred from agreement C15-CT195926 to this agreement. ","2019-12-10","9",0,null,0,"0","2","2019-12-13 18:16:25","2","2019-12-13 18:16:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012513902","C181143","PERSONAL","Mr","ETH7g0aOUlCOcIBTrcksAg==","yXKLXTtbNpECaRVTZxF\/Rw==","","VjDVb2N8oiZpjUQsB\/cddbJHhr9V8Zd4p25chSG3fxpxsQZR8lucCLOj6lqzRee9QzuSxYEuexIJrOELyDG0KPWzu9u9TxeWHP7fFA29UVs=","fssRUCbxqvAzfOn5pnVlOQ==","POeCSRn6MWcpcIRlMd8N09FFm\/GO+XIGr7W6nDVr5fQ=","nNAYzEQ4gSbpq8L0\/sugEw==",null,1,"4483"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","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":["6692","411","159","1411","%","5.00",36,"2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6692","1411","720.0",684,"2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-03-09","1411"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6692",1143,"SETTLED","C15-I197020","2019-12-13 18:16:25","2019-12-10","2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7020","RENT","\u9810\u7e73\u79df\u91d1",1,684,"MO","1",684,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7020","RENT","\u9810\u7e73\u79df\u91d1",2,684,"MO","1",684,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7020","RENT","\u9810\u7e73\u79df\u91d1",3,684,"MO","1",684,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2052,0,"7020"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1143,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196670","2019-12-13 18:16:25",2052,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6670","DEPOSIT",null,"PAID","2019-12-13 18:16:25",0,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 18:16:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6670","INVOICE","7020","PAID","2019-12-13 18:16:25",2052,"2","2019-12-13 18:16:25","2","2019-12-13 18:16:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-13 21:47:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****