\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>
A05-080 <\/td>\n\t\t\t\t\t	4X2X3.5 <\/td>\n\t\t\t\t\t	$598.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 <\/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":"8","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","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":["C191474","PERSONAL","Mr","k1h0f5XTlQG7m3zcIpzvS7issCCNyj+\/anxudTLo00s=","au77VsKeCuxoC11dqhuZxg==","","hDR1eKIExoVHJCvd2P3obg==","nmm9ZXQN\/nKr7FykbjwFulFtnAJBZHboaARS1az09mc=","aYZ1I\/xruxzHYcTRYgqMFaiChjp0ZP6apB8Cgl7uri1rl\/\/n\/06Xs4ZynxRvUNAogMxNYptYf+\/jeDJAav3TiZ0Hp3KXwH\/HdGhdMhliVaU=","c24SDs570vB9WL1QHQGOQg==",null,"nmm9ZXQN\/nKr7FykbjwFulFtnAJBZHboaARS1az09mc=","GO4g4vUAZJtlfmB2X6ZoLA==","2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1474,"NEW","A05-CT196735",598,538,1196,0,"13","13",7340,8190,7340,"2019-12-19 11:07:21","0",null,null,null,"2019-12-19","2021-01-18","13 months contract. Special offer the 13th month free and 5% 'rent now' discount. Storage rental and deposit paid by Visa on December 19, 2019. Smartcard and padlock provided on December 19, 2019. \r\n**$221 for visa additional fee.","2019-12-19","8",0,null,850,"850.00","2","2019-12-19 11:07:20","2","2019-12-19 11:07:20","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"'0012438275","C191474","PERSONAL","Mr","k1h0f5XTlQG7m3zcIpzvS7issCCNyj+\/anxudTLo00s=","au77VsKeCuxoC11dqhuZxg==","","aYZ1I\/xruxzHYcTRYgqMFaiChjp0ZP6apB8Cgl7uri1rl\/\/n\/06Xs4ZynxRvUNAogMxNYptYf+\/jeDJAav3TiZ0Hp3KXwH\/HdGhdMhliVaU=","hDR1eKIExoVHJCvd2P3obg==","nmm9ZXQN\/nKr7FykbjwFulFtnAJBZHboaARS1az09mc=","c24SDs570vB9WL1QHQGOQg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6735","1082","598.0","598.00","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-19","2021-01-18","1082"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 11:07:21","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":["6735","A05-D195227","PAID",1196,0,"2021-01-18","2019-12-19 11:07:20","2019-12-19 11:07:20","2","2019-12-19 11:07:20","2","2019-12-19 11:07:20",1474]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6735",1474,"SETTLED","A05-I197063","2019-12-19 11:07:20","2019-12-19","2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,226,"MO","1",226,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7063","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6144,0,"7063"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1474,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P196713","2019-12-19 11:07:20",7340,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6713","DEPOSIT","5227","PAID","2019-12-19 11:07:20",1196,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:07:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6713","INVOICE","7063","PAID","2019-12-19 11:07:20",6144,"2","2019-12-19 11:07:20","2","2019-12-19 11:07:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=18&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-18","renew_room_key":"055,34812","renew_remark":"1 month contract. Storage rental paid by cheque on November 19, 2019. Storage deposit transferred from agreement A12-CT196183 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196435, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"13","order_discount":[],"order_room":[{"room_id":"2","room_code":"A02","retail_price":"2058.0","discounted_price":"2058.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-18","rent_from":"2019-12-18","rent_to":"2020-01-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on December 19, 2019. Storage deposit transferred from agreement A12-CT196435 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> A02 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",18,"NEW","A12-CT196736",2058,1860,0,0,"1","1",1860,1860,1860,"2019-12-19 11:24:39","0",null,null,null,"2019-12-18","2020-01-17","1 month contract. Storage rental paid by cheque on December 19, 2019. Storage deposit transferred from agreement A12-CT196435 to this agreement.\r\n","2019-12-18","28",0,null,0,"0","2","2019-12-19 11:24:38","2","2019-12-19 11:24:38","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6736","2","2058.0","2058.00","2","2019-12-19 11:24:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-18","2020-01-17","2"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6736",18,"SETTLED","A12-I197064","2019-12-19 11:24:38","2019-12-18","2","2019-12-19 11:24:38","2","2019-12-19 11:24:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7064","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2019-12-19 11:24:38","2","2019-12-19 11:24:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7064"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196714","2019-12-19 11:24:38",1860,"2","2019-12-19 11:24:38","2","2019-12-19 11:24:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6714","DEPOSIT",null,"PAID","2019-12-19 11:24:38",0,"2","2019-12-19 11:24:38","2","2019-12-19 11:24:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6714","INVOICE","7064","PAID","2019-12-19 11:24:38",1860,"2","2019-12-19 11:24:38","2","2019-12-19 11:24:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","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-02","renew_room_key":"053,34812","renew_remark":"1 month contract. Storage rental paid by cheque on November 19, 2019. Storage deposit transferred from agreement A12-CT196184 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196436, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"141","room_code":"C17","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-02","rent_from":"2019-12-02","rent_to":"2020-01-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on Dec 19, 2019. Storage deposit transferred from agreement A12-CT196436 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> C17 <\/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-19 11:24:49","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",18,"NEW","A12-CT196737",1098,1038,0,0,"1","1",1038,1038,1038,"2019-12-19 11:24:49","0",null,null,null,"2019-12-02","2020-01-01","1 month contract. Storage rental paid by cheque on Dec 19, 2019. Storage deposit transferred from agreement A12-CT196436 to this agreement.","2019-12-02","16",0,null,0,"0","2","2019-12-19 11:24:48","2","2019-12-19 11:24:48","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","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":["6737","141","1098.0","1098.00","2","2019-12-19 11:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","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-02","2020-01-01","141"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 11:24:49","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":["6737",18,"SETTLED","A12-I197065","2019-12-19 11:24:48","2019-12-02","2","2019-12-19 11:24:48","2","2019-12-19 11:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","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":["7065","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-19 11:24:48","2","2019-12-19 11:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7065"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 11:24:49","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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196715","2019-12-19 11:24:48",1038,"2","2019-12-19 11:24:48","2","2019-12-19 11:24:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","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":["6715","DEPOSIT",null,"PAID","2019-12-19 11:24:48",0,"2","2019-12-19 11:24:48","2","2019-12-19 11:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 11:24:49","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":["6715","INVOICE","7065","PAID","2019-12-19 11:24:48",1038,"2","2019-12-19 11:24:48","2","2019-12-19 11:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 14:17:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 14:17:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 14:40:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined","floor_plan_rent_room":[{"room_id":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","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> L02(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K519811(9)","title":"Mr","lastname":"LEE","firstname":"Tsz Man","companyname":"","email":"yoseflee@gmail.com","tel":"67721023","address":"Flat 1, 12\/F, Hoi Tin Court, 8 Nam Ning Street, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"524","room_code":"L02(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":304,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":3648,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-18","rent_from":"2019-12-18","rent_to":"2020-12-17","delivery_service":"0","remark":"12 months contract. Storage rental and deposit paid by EPS on December 18, 2019. \r\n$400 transportation fee paid by EPS on December 18, 2019. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":3648,"final_order_total":3648,"location_id":"2","branch_id":"1","company_id":"1","room_key":"-","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"304.00","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["C191475","PERSONAL","Mr","HHuc3NE3u3Loqij\/Fr3HSQ==","brgGVGuPrfoSjI4k+kLGow==","","EHWIRmXPMGyLMg0n2cqDDQ==","CfhQ+iD9uScP2NxtkRA5p\/LJTKS3I3lBE7dHX6I1j0w=","Z9RU5eFNjXUj192+ToOlpV+Vs+NIqAHatdDBJ4ctG49L+FRN8jatx6BAr6MMXMkLaoYYwNo75OxlVQK+HKpBl3wDjvsfwrLoak0\/GHLG6z4=","6KIbSWKVxvXMbpJk5Ak5xA==",null,"CfhQ+iD9uScP2NxtkRA5p\/LJTKS3I3lBE7dHX6I1j0w=","lJMWr36etLOKaGFwFhUCNg==","2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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","2",1475,"NEW","A14-CT196738",1342,304,0,0,"12","12",3648,3648,3648,"2019-12-19 15:44:55","0",null,null,null,"2019-12-18","2020-12-17","12 months contract. Storage rental and deposit paid by EPS on December 18, 2019. \r\n$400 transportation fee paid by EPS on December 18, 2019. ","2019-12-18","16",0,null,0,"0","2","2019-12-19 15:44:54","2","2019-12-19 15:44:54","EPS","","","","EPS","","","",null,0,"-","C191475","PERSONAL","Mr","HHuc3NE3u3Loqij\/Fr3HSQ==","brgGVGuPrfoSjI4k+kLGow==","","Z9RU5eFNjXUj192+ToOlpV+Vs+NIqAHatdDBJ4ctG49L+FRN8jatx6BAr6MMXMkLaoYYwNo75OxlVQK+HKpBl3wDjvsfwrLoak0\/GHLG6z4=","EHWIRmXPMGyLMg0n2cqDDQ==","CfhQ+iD9uScP2NxtkRA5p\/LJTKS3I3lBE7dHX6I1j0w=","6KIbSWKVxvXMbpJk5Ak5xA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["6738","524","1342.0","1342.00","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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-18","2020-12-17","524"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 15:44:55","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":["6738",1475,"SETTLED","A14-I197066","2019-12-19 15:44:54","2019-12-18","2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",1,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",2,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",3,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",4,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",5,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",6,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",7,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",8,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",9,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",10,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",11,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["7066","RENT","\u9810\u7e73\u79df\u91d1",12,304,"MO","1",304,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3648,0,"7066"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 15:44:55","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":[1475,"EPS","","","","EPS","","","","PAID","P196716","2019-12-19 15:44:54",3648,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["6716","DEPOSIT",null,"PAID","2019-12-19 15:44:54",0,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:44:55","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":["6716","INVOICE","7066","PAID","2019-12-19 15:44:54",3648,"2","2019-12-19 15:44:54","2","2019-12-19 15:44:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":783,"customer_code":"C180783","identity_type":"PERSONAL","identity_id":"D459443(7)","title":"Ms","lastname":"Leung","firstname":"So King","companyname":"","email":null,"tel":"93399270","address":"Room 909, Pik Shan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-21","renew_room_key":"055,03045,055,15637","renew_remark":"6 months contract. Storage rental paid by Cash on June 8, 2019. Storage deposit transferred from agreement A14-CT183932 to this agreement\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195173, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"689","room_code":"N06","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-06-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by Cash on December 19, 2019. Storage deposit transferred from agreement A14-CT195173 to this agreement","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,03045,055,15637","order_product":[],"pass":true}},"first_order_id":"3932","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> N06 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",783,"NEW","A14-CT196739",598,538,0,0,"6","6",3228,3228,3228,"2019-12-19 15:50:19","0",null,null,null,"2019-12-21","2020-06-20","6 months contract. Storage rental paid by Cash on December 19, 2019. Storage deposit transferred from agreement A14-CT195173 to this agreement","2019-12-21","12",0,null,0,"0","2","2019-12-19 15:50:19","2","2019-12-19 15:50:19","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,03045,055,15637","C180783","PERSONAL","Ms","1wvt7j9sKAXiKrAYEESBEA==","xEf2h2aoyRQ71ZVgBH+9WQ==","","5jrEey1TOOmPRMsdqiHNYDwg8vYXpIrxGXu+rSzTfXmiTH3INRdWQrPdUIQSzqG8Nw\/HOJFcV+btpwSi5Vg6+elG4MKGYkptWB8s1frXrZ0=","1WHiqOSyl49pEAJJlNcK0Q==",null,"\/fE4fuk5bWTWsVOJX65UQg==",null,1,"3932"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["6739","689","598.0","598.00","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["2019-12-21","2020-06-20","689"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 15:50: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":["6739",783,"SETTLED","A14-I197067","2019-12-19 15:50:19","2019-12-21","2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["7067","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7067"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 15:50: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":[783,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196717","2019-12-19 15:50:19",3228,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["6717","DEPOSIT",null,"PAID","2019-12-19 15:50:19",0,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 15:50: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":["6717","INVOICE","7067","PAID","2019-12-19 15:50:19",3228,"2","2019-12-19 15:50:19","2","2019-12-19 15:50:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":604,"customer_code":"C170604","identity_type":"PERSONAL","identity_id":"A956295(0)","title":"Mr","lastname":"Lau","firstname":"Sak Yuk","companyname":"","email":"andy@starlight.com.hk","tel":"34711300","address":"Flat B, 24\/F, South Bay Tower, 59 South Bay Road, South Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3301.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-15","renew_room_key":"053,60602","renew_remark":"6 months contract. Storage rental paid by cheque on July 12, 2019. Storage deposit transferred from agreement A12-CT194131 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195459, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"294","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"283","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"284","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"293","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"294","room_code":"E21","retail_price":"998.0","discounted_price":829.9,"location_id":"1"},{"room_id":"293","room_code":"E20","retail_price":"998.0","discounted_price":829.9,"location_id":"1"},{"room_id":"284","room_code":"E11","retail_price":"998.0","discounted_price":829.9,"location_id":"1"},{"room_id":"283","room_code":"E10","retail_price":"998.0","discounted_price":829.9,"location_id":"1"}],"roughly_size":"48","total_retail_price":3992,"total_discounted_price":3301,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":39612,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-15","rent_from":"2019-12-15","rent_to":"2020-12-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on December 19, 2019. Storage deposit transferred from agreement A12-CT195459 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":39612,"final_order_total":39612,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,60602","order_product":[],"pass":true}},"first_order_id":"4131","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\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> E21 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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> E20 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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> E11 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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> E10 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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":"48","total_discounted_price":"3301.00","deposit":"0.00","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",604,"NEW","A12-CT196740",3992,3301,0,0,"12","12",39612,39612,39612,"2019-12-19 16:12:04","0",null,null,null,"2019-12-15","2020-12-14","6 months contract. Storage rental paid by cheque on December 19, 2019. Storage deposit transferred from agreement A12-CT195459 to this agreement.","2019-12-15","48",0,null,0,"0","2","2019-12-19 16:12:04","2","2019-12-19 16:12:04","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,60602","C170604","PERSONAL","Mr","ez8khiMB005yh345L7jtww==","oe4emdjBwqJ3qUpOcI17hw==","","P2cWfuBqMeFzq0cQ7lLAVlrijlU5OLpg5Ygw9I6wgavH6nSV7FssYi4QucoX\/bguIfFdhM4jkY3zP7JLRTqahZnCOCSTXOF3F426UGRTvbY=","Lq1kqa+c2QQMMxioXQEarQ==","mt67mLdWtCd7OfAiMFsZ4iFjo\/jk73Nm92ra+UO+kfU=","1E\/H13BvJ8xge9YjGuU87A==",null,1,"4131"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6740","71","6","294","%","16.84",168.0632,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6740","71","6","283","%","16.84",168.0632,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6740","71","6","284","%","16.84",168.0632,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6740","71","6","293","%","16.84",168.0632,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["6740","294","998.0",829.9,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["2019-12-15","2020-12-14","294"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:12: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":["6740","293","998.0",829.9,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["2019-12-15","2020-12-14","293"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:12: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":["6740","284","998.0",829.9,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["2019-12-15","2020-12-14","284"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:12: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":["6740","283","998.0",829.9,"2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["2019-12-15","2020-12-14","283"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:12: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":["6740",604,"SETTLED","A12-I197068","2019-12-19 16:12:04","2019-12-15","2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",1,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",2,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",3,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",4,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",5,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",6,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",7,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",8,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",9,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",10,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",11,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["7068","RENT","\u9810\u7e73\u79df\u91d1",12,3301,"MO","1",3301,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[39612,0,"7068"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:12: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":[604,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196718","2019-12-19 16:12:04",39612,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["6718","DEPOSIT",null,"PAID","2019-12-19 16:12:04",0,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:12: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":["6718","INVOICE","7068","PAID","2019-12-19 16:12:04",39612,"2","2019-12-19 16:12:04","2","2019-12-19 16:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&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":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":499,"customer_code":"C170499","identity_type":"BUSINESS","identity_id":"P046801(4)","title":"Mr","lastname":"Leong","firstname":"Mun Hoong ","companyname":"Spurbidge Limited","email":"aishah@netvigator.com","tel":"90928584","address":"Room 1405, 14\/F, 135 Bonham Strand Trade Centre ,135 Bonham Strand ,Sheung Wan","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-24","renew_room_key":"056,14447","renew_remark":"12 months contract. Storage rental paid by bank transfer on December13, 2018. Storage deposit transferred from agreement SD14-CT182427 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183898, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"455","room_code":"J37","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13668,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-24","rent_from":"2019-12-24","rent_to":"2020-12-23","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on December 19, 2018. Storage deposit transferred from agreement A14-CT183898 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13668,"final_order_total":13668,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,14447","order_product":[],"pass":true}},"first_order_id":3898,"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> J37 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\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":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",499,"NEW","A14-CT196741",1528,1139,0,0,"12","12",13668,13668,13668,"2019-12-19 16:21:15","0",null,null,null,"2019-12-24","2020-12-23","12 months contract. Storage rental paid by bank transfer on December 19, 2018. Storage deposit transferred from agreement A14-CT183898 to this agreement.","2019-12-24","20",0,null,0,"0","2","2019-12-19 16:21:15","2","2019-12-19 16:21:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,14447","C170499","BUSINESS","Mr","3EaM+VKHYjmINzfGcVN0TQ==","isv8tlCKrmXkILYTwCZxFg==","Spurbidge Limited","goPtDRP4fzuYCa73WsJqV7FC7bBc5S\/HsiVOc86KGWaCPbpVpiQNC9RNLRyQ4oO6iymArrT8Z56uEwnezw5740wINLmtr2c0LGEBzNA6eCk=","X45icNJ49g3wCrj0DiTIrA==","OiBEn\/yJN6wkEaX5wOZSuEopAQzwVxSBStSChQWLAAo=",null,"kjwVWXXq15CNklOX92zbYg==",1,3898]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["6741","455","1528.0","1528.00","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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-24","2020-12-23","455"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:21:15","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":["6741",499,"SETTLED","A14-I197069","2019-12-19 16:21:15","2019-12-24","2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["7069","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"7069"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:21:15","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":[499,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196719","2019-12-19 16:21:15",13668,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["6719","DEPOSIT",null,"PAID","2019-12-19 16:21:15",0,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:21:15","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":["6719","INVOICE","7069","PAID","2019-12-19 16:21:15",13668,"2","2019-12-19 16:21:15","2","2019-12-19 16:21:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&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":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":854,"customer_code":"C180854","identity_type":"PERSONAL","identity_id":"K279485(3)","title":"Ms","lastname":"Wu","firstname":"Lo Ming Michelle","companyname":"","email":null,"tel":"55949979","address":"Flat 2, 15\/F, Block E, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1167.0","renew_rent_month":"3","renew_warehousing_date":"2019-11-26","renew_room_key":"190,40540","renew_remark":"3 months contract. Storage rental paid by PPS on September 2, 2019. Storage deposit transferred from agreement A12-CT195208 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195869, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"13","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"13","room_code":"A13","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1167,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3501,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-26","rent_from":"2019-11-26","rent_to":"2020-02-25","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on December 17, 2019. Storage deposit transferred from agreement A12-CT195869 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3501,"final_order_total":3501,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,40540","order_product":[],"pass":true}},"first_order_id":"4445","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> A13 <\/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":"1167.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",854,"NEW","A12-CT196742",1098,1167,0,0,"3","3",3501,3501,3501,"2019-12-19 16:26:56","0",null,null,null,"2019-11-26","2020-02-25","3 months contract. Storage rental paid by PPS on December 17, 2019. Storage deposit transferred from agreement A12-CT195869 to this agreement.","2019-11-26","16",0,null,0,"0","2","2019-12-19 16:26:55","2","2019-12-19 16:26:55","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,40540","C180854","PERSONAL","Ms","psCzE42oOUIBaGJL20z5+RKMHonq2oSmn6ARZwoxVCc=","6BZ3jKM7u1vzGCs7Yb+Ugw==","","IFz6cM92WYlr9HuTCBnClnHE7nIqMHxnVaWldT46uNACZW0r1+RtgduvFayj6p1ql2Ss007rMANRg0YsEth\/Ug==","KdWsa5d4gfIGyb8L+vzniw==",null,"cLX3VK5NGjk4Jenw3oMBLA==",null,1,"4445"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","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":["6742","433","8","13","%","4.97",54.5706,"2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6742","13","1098.0",1043.4,"2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-26","2020-02-25","13"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6742",854,"SETTLED","A12-I197070","2019-12-19 16:26:55","2019-11-26","2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"7070"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[854,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196720","2019-12-19 16:26:55",3501,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6720","DEPOSIT",null,"PAID","2019-12-19 16:26:55",0,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:26:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6720","INVOICE","7070","PAID","2019-12-19 16:26:55",3501,"2","2019-12-19 16:26:55","2","2019-12-19 16:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&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":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":344,"customer_code":"C170344","identity_type":"PERSONAL","identity_id":"G411106(A)","title":"Ms","lastname":"Chung","firstname":"Fung Ming","companyname":"","email":"emaily338@nrtvigator.com","tel":"93537602","address":"\u9999\u6e2f\u4ed4\u83ef\u8cb4\u90a8\u83ef\u8ce2\u6a132606\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2206.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-01","renew_room_key":"052,47504","renew_remark":"12 months contract. Storage rental paid by cheque deposit on December 28, 2018. Storage deposit transferred from agreement SD14-CT182470 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194040, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"58","order_discount":[{"master_room_discount_id":"486","master_room_id":"58","discount_type":"%","price":"2888.00","disocunted_price":"2399.40","discount":"16.92","monthly_deduct":488.6496,"room_id":"453","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"453","room_code":"J35","retail_price":"2888.0","discounted_price":2399.4,"location_id":"2"}],"roughly_size":"40","total_retail_price":2888,"total_discounted_price":2206,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":26472,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-12-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by PPS on December 18, 2018. Storage deposit transferred from agreement A14-CT194040 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":26472,"final_order_total":26472,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,47504","order_product":[],"pass":true}},"first_order_id":4040,"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> J35 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\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":"40","total_discounted_price":"2206.0","deposit":"0","total_retail_price":"2888.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",344,"NEW","A14-CT196743",2888,2206,0,0,"12","12",26472,26472,26472,"2019-12-19 16:32:10","0",null,null,null,"2020-01-01","2020-12-31","12 months contract. Storage rental paid by PPS on December 18, 2018. Storage deposit transferred from agreement A14-CT194040 to this agreement.","2020-01-01","40",0,null,0,"0","2","2019-12-19 16:32:10","2","2019-12-19 16:32:10","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,47504","C170344","PERSONAL","Ms","8sIOLvslW9WC7NqX1zdO+A==","ThKwrAIcvgN3JqAg+7\/isg==","","ncDBNiaejmDiRJn51l8rt+Rwuy2ezmYtqVH\/axGd+6oaT2KC81rryMcsHangtHMG","grw1V4eno\/pSEtire3ylfw==","peCeq+cN8Ycwf5GD1mu\/IKUOIg6ozvzHEbtHkPjVx8Y=","OfnZ3iy4rVv46O1CVPaBXQ==",null,1,4040]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["6743","486","58","453","%","16.92",488.6496,"2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["6743","453","2888.0",2399.4,"2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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-01-01","2020-12-31","453"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:32:10","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":["6743",344,"SETTLED","A14-I197071","2019-12-19 16:32:10","2020-01-01","2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",1,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",2,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",3,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",4,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",5,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",6,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",7,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",8,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",9,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",10,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",11,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["7071","RENT","\u9810\u7e73\u79df\u91d1",12,2206,"MO","1",2206,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26472,0,"7071"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:32:10","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":[344,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196721","2019-12-19 16:32:10",26472,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["6721","DEPOSIT",null,"PAID","2019-12-19 16:32:10",0,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:32:10","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":["6721","INVOICE","7071","PAID","2019-12-19 16:32:10",26472,"2","2019-12-19 16:32:10","2","2019-12-19 16:32:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&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":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-15","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on November 18, 2019. Storage deposit transferred from agreement A12-CT196155 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196446, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-15","rent_from":"2019-12-15","rent_to":"2020-01-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on December 18, 2019. Storage deposit transferred from agreement A12-CT196446 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4192","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> D47 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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",506,"NEW","A12-CT196744",998,998,0,0,"1","1",998,998,998,"2019-12-19 16:36:58","0",null,null,null,"2019-12-15","2020-01-14","1 month contract. Storage rental paid by PPS on December 18, 2019. Storage deposit transferred from agreement A12-CT196446 to this agreement.","2019-12-15","12",0,null,0,"0","2","2019-12-19 16:36:58","2","2019-12-19 16:36:58","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4192"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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":["6744","243","998.0","998.00","2","2019-12-19 16:36:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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-15","2020-01-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:36:58","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":["6744",506,"SETTLED","A12-I197072","2019-12-19 16:36:58","2019-12-15","2","2019-12-19 16:36:58","2","2019-12-19 16:36:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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":["7072","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2019-12-19 16:36:58","2","2019-12-19 16:36:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7072"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:36:58","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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196722","2019-12-19 16:36:58",998,"2","2019-12-19 16:36:58","2","2019-12-19 16:36:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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":["6722","DEPOSIT",null,"PAID","2019-12-19 16:36:58",0,"2","2019-12-19 16:36:58","2","2019-12-19 16:36:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:36:58","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":["6722","INVOICE","7072","PAID","2019-12-19 16:36:58",998,"2","2019-12-19 16:36:58","2","2019-12-19 16:36:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"524","master_room_id":"68","room_code":"L02"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":605,"customer_code":"C170605","identity_type":"BUSINESS","identity_id":"55497175-000-01-17-6","title":"Mr","lastname":"Kwok","firstname":"Chin Hang","companyname":"Hang Fung Engineering & Trading Co.","email":null,"tel":"96244575","address":"Flat 2206, Block D, Kam Lei House, Kam Fung Court, Ma On Shan, New Territories","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-21","renew_room_key":"055,20870,054,62603","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 26, 2019. Storage deposit transferred from agreement A12-CT183961 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195337, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"19","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"19","room_code":"A19","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-12-20","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit transferred from agreement A12-CT195337 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,20870,054,62603","order_product":[],"pass":true}},"first_order_id":"3961","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> A19 <\/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":"935.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",605,"NEW","A12-CT196745",1098,935,0,0,"12","12",11220,11220,11220,"2019-12-19 16:47:56","0",null,null,null,"2019-12-21","2020-12-20","12 months contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit transferred from agreement A12-CT195337 to this agreement.","2019-12-21","16",0,null,0,"0","2","2019-12-19 16:47:55","2","2019-12-19 16:47:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,20870,054,62603","C170605","BUSINESS","Mr","2fBMcYLyyRV1ct\/oVUpa1Q==","+pNULpsInm3siHASV0hIrg==","Hang Fung Engineering & Trading Co.","N8y22ZdBCT9rHKNtsessiJE4Jczkb\/Nq07raMwRTHQ2XF0Nv\/lBHtYtJgH13rQzjYz8ow7AS+ArEHGPk3Pyky+oCeaiBXQY1PyyzX7uoBvU=","4\/yk9EwyTfq5DCnVv9JuHQ==",null,null,"cVYANZGzu0bO8R2uRCzh7ROIPGdxBRmqUnBMx+iDbS0=",1,"3961"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","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":["6745","73","8","19","%","16.85",185.013,"2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6745","19","1098.0",913,"2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-21","2020-12-20","19"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6745",605,"SETTLED","A12-I197073","2019-12-19 16:47:55","2019-12-21","2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"7073"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[605,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196723","2019-12-19 16:47:55",11220,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6723","DEPOSIT",null,"PAID","2019-12-19 16:47:55",0,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 16:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6723","INVOICE","7073","PAID","2019-12-19 16:47:55",11220,"2","2019-12-19 16:47:55","2","2019-12-19 16:47:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:09:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:37","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","floor_plan_rent_room":[{"room_id":"556","master_room_id":"35","room_code":"L34"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L45 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\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> L44 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\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> L33 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\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> L34 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\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\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K017174(3)","title":"Ms","lastname":"CHAN","firstname":"Ngar Ming","companyname":"","email":"Amychan.gf@gmail.com","tel":"98821786","address":"Rm1503, 15\/F, Guangdong Finance Bldg, 88 Connaught Kd West, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"567","room_code":"L45","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"566","room_code":"L44","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"555","room_code":"L33","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"556","room_code":"L34","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":4318,"deposit":9596,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":33708,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1796","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2020-06-19","delivery_service":"0","remark":"6 months contract. 5% discount and $500 coupon. Storage rental and deposit paid by cheque on Dec 19,2019. Smartcard and padlock provided on Dec 19,2019.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1796,"order_total":35504,"final_order_total":33708,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38861","order_product":[],"pass":true}},"roughly_size":"64","total_discounted_price":"4318","deposit":"9596.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["C191476","PERSONAL","Ms","O7fkGb5ZKMnmXKz11qF9LQ==","8BEgNhGpCR8jGkzUtrIcXg==","","ISVy\/jidl+TdBjZaRqHsjw==","VUAtoBgWgjD4W1A10P5G0v4vf\/xHtdbNKGb\/BV45bLk=","EJ5zMIyadu5\/+ZGKJ0OOQANh0T3NEtiJqFoz0QUrJ839Ys\/ixHrK\/BjP679VBBodGZHYWTKjwpmZ44S3TTB0wQ==","3uVFvDTVJhTUK+fCSl3u7g==",null,"VUAtoBgWgjD4W1A10P5G0v4vf\/xHtdbNKGb\/BV45bLk=","2oTbOMg+A12ciR2po1HQ1Q==","2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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","2",1476,"NEW","A14-CT196746",4392,4318,9596,0,"6","6",33708,35504,33708,"2019-12-19 18:15:38","0",null,null,null,"2019-12-20","2020-06-19","6 months contract. 5% discount and $500 coupon. Storage rental and deposit paid by cheque on Dec 19,2019. Smartcard and padlock provided on Dec 19,2019.","2019-12-20","64",0,null,1796,"1796","2","2019-12-19 18:15:37","2","2019-12-19 18:15:37","CHEQUE","","","","CHEQUE","","","",null,0,"190,38861","C191476","PERSONAL","Ms","O7fkGb5ZKMnmXKz11qF9LQ==","8BEgNhGpCR8jGkzUtrIcXg==","","EJ5zMIyadu5\/+ZGKJ0OOQANh0T3NEtiJqFoz0QUrJ839Ys\/ixHrK\/BjP679VBBodGZHYWTKjwpmZ44S3TTB0wQ==","ISVy\/jidl+TdBjZaRqHsjw==","VUAtoBgWgjD4W1A10P5G0v4vf\/xHtdbNKGb\/BV45bLk=","3uVFvDTVJhTUK+fCSl3u7g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["6746","567","1098.0","1098.00","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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-20","2020-06-19","567"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 18:15:38","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":["6746","566","1098.0","1098.00","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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-20","2020-06-19","566"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 18:15:38","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":["6746","555","1098.0","1098.00","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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-20","2020-06-19","555"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 18:15:38","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":["6746","556","1098.0","1098.00","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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-20","2020-06-19","556"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 18:15:38","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":["6746","A14-D195228","PAID",9596,0,"2020-06-19","2019-12-19 18:15:37","2019-12-19 18:15:37","2","2019-12-19 18:15:37","2","2019-12-19 18:15:37",1476]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["6746",1476,"SETTLED","A14-I197074","2019-12-19 18:15:37","2019-12-20","2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2522,"MO","1",2522,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u9810\u7e73\u79df\u91d1",2,4318,"MO","1",4318,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u9810\u7e73\u79df\u91d1",3,4318,"MO","1",4318,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u9810\u7e73\u79df\u91d1",4,4318,"MO","1",4318,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u9810\u7e73\u79df\u91d1",5,4318,"MO","1",4318,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["7074","RENT","\u9810\u7e73\u79df\u91d1",6,4318,"MO","1",4318,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24112,0,"7074"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 18:15:38","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":[1476,"CHEQUE","","","","CHEQUE","","","","PAID","P196724","2019-12-19 18:15:37",33708,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["6724","DEPOSIT","5228","PAID","2019-12-19 18:15:37",9596,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:15:38","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":["6724","INVOICE","7074","PAID","2019-12-19 18:15:37",24112,"2","2019-12-19 18:15:37","2","2019-12-19 18:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:47:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:52","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","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> A16-083(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1410.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G154012(1)","title":"Mr","lastname":"IP","firstname":"Shu Kai","companyname":"","email":"sip@cis.edu.hk","tel":"90804138","address":"No.1, Hau Yuen Path, Braemar Hill, North Point, Hong Kong.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1574","room_code":"A16-083(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":"1410.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1269,"deposit":2820,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":18048,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1269.00","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2021-01-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by Visa on December 19, 2019. Storage depodit paid by EPS on December 19, 2019.","paymethod":"EPS","paymethod2":"CREDIT_CARD","discount_deduct":1269,"order_total":19317,"final_order_total":18048,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190, 40497","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1269.00","deposit":"2820.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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":["C191477","PERSONAL","Mr","HAcOhg5\/5yotRZTHUh\/xFA==","BxzCT5OGas7BCbwmbXAF7w==","","x1smQMirO\/LeNjPdKLGJSw==","Rd0ZOsAynBi2d1P1SSa85Q==","Fl7Emd22RlU8N28yTKxEWYQByOP+AYXsAAKI\/bnMahMEQXNBs4ajXo\/u\/vmwNUenlkGlFBE1C6QaKpSN1pI3zA==","+nFXoxJIDqIXoId9PD2Rzw==",null,"Rd0ZOsAynBi2d1P1SSa85Q==","cR13rrEZ4kn84y65\/lxCMg==","2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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","7",1477,"NEW","A16-CT196747",1410,1269,2820,0,"13","13",18048,19317,18048,"2019-12-19 18:57:53","0",null,null,null,"2019-12-20","2021-01-19","13 months contract. Special offer the 13th month free. Storage rental paid by Visa on December 19, 2019. Storage depodit paid by EPS on December 19, 2019.","2019-12-20","16",0,null,1269,"1269.00","2","2019-12-19 18:57:52","2","2019-12-19 18:57:52","EPS","","","","CREDIT_CARD","","","",null,0,"190, 40497","C191477","PERSONAL","Mr","HAcOhg5\/5yotRZTHUh\/xFA==","BxzCT5OGas7BCbwmbXAF7w==","","Fl7Emd22RlU8N28yTKxEWYQByOP+AYXsAAKI\/bnMahMEQXNBs4ajXo\/u\/vmwNUenlkGlFBE1C6QaKpSN1pI3zA==","x1smQMirO\/LeNjPdKLGJSw==","Rd0ZOsAynBi2d1P1SSa85Q==","+nFXoxJIDqIXoId9PD2Rzw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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":["6747","1574","1410.0","1410.00","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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-20","2021-01-19","1574"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-19 18:57:53","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":["6747","A16-D195229","PAID",2820,0,"2021-01-19","2019-12-19 18:57:52","2019-12-19 18:57:52","2","2019-12-19 18:57:52","2","2019-12-19 18:57:52",1477]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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":["6747",1477,"SETTLED","A16-I197075","2019-12-19 18:57:52","2019-12-20","2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:53","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":["7075","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",7,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",8,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",9,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",10,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",11,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",12,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["7075","RENT","\u9810\u7e73\u79df\u91d1",13,1269,"MO","1",1269,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15228,0,"7075"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-19 18:57:54","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":[1477,"EPS","","","","CREDIT_CARD","","","","PAID","P196725","2019-12-19 18:57:52",18048,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["6725","DEPOSIT","5229","PAID","2019-12-19 18:57:52",2820,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-19 18:57:54","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":["6725","INVOICE","7075","PAID","2019-12-19 18:57:52",15228,"2","2019-12-19 18:57:52","2","2019-12-19 18:57:52"]},"data_before":[],"data_after":[],"step":1} *****