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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
WC-14 <\/td>\n\t\t\t\t\t	2.5X2.5X4 <\/td>\n\t\t\t\t\t	$798.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"6.25","total_discounted_price":"798.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201499","BUSINESS","Mr","ZGBHXOclIM+UlBOBu7+VHw==","J7AHnwLqFVSF7LcuxIPXIg==","Shanghai Legend Limited","sKBSHRtWCOMXc4pt3XKKxg==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=","Y6Y64684LEAASRCic9igdNR4yxR3hXmGHq6J96GBEKprn0KLnzLI7m6m984WCFvcrderYHqQo1+X52PIW+nuSw==",null,"0Bbp6r4fIjN1S+fUK3wJCw==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=","A+vQIu5MJqwpa9Au2KGJEA==","2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","8",1499,"NEW","WC-CT207062",798,798,1596,0,"14","14",11172,12768,11172,"2020-01-30 15:22:20","0",null,null,null,"2020-02-06","2021-04-05","13 months contract. Storage rental and storage deposit paid by EPS on January 30, 2020. Smartcard provided on January 30, 2020. ","2020-02-06","6.25",0,null,1596,"1596.00","2","2020-01-30 15:22:17","2","2020-01-30 15:22:17","UNPAID","","","","UNPAID","","","",null,0,"20","C201499","BUSINESS","Mr","ZGBHXOclIM+UlBOBu7+VHw==","J7AHnwLqFVSF7LcuxIPXIg==","Shanghai Legend Limited","Y6Y64684LEAASRCic9igdNR4yxR3hXmGHq6J96GBEKprn0KLnzLI7m6m984WCFvcrderYHqQo1+X52PIW+nuSw==","sKBSHRtWCOMXc4pt3XKKxg==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=",null,"0Bbp6r4fIjN1S+fUK3wJCw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7062","1755","798.0","798.00","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-06","2021-04-05","1755"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:22:20","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":["7062","WC-D205272","NEW",1596,1596,"2021-04-05","2020-01-30 15:22:17","2020-01-30 15:22:17","2","2020-01-30 15:22:17","2","2020-01-30 15:22:17",1499]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062",1499,"NEW","WC-I207390","2020-01-30 15:22:17","2020-02-06","2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",4,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7390","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-01-30 15:22:17","2","2020-01-30 15:22:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:22:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9576,7980,"7390"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-30 15:25:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"P655683(7)","title":"Mr","lastname":"Hong","firstname":"Phu","companyname":"Shanghai Legend Limited","email":"dphu@hotmail.com","tel":"67627538","address":"12\/F, Block 44, Baguio Villa, 550 Victoria Road, Hong Kong","pass":true,"customer_id":"1499","customer_code":"C201499","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1678","room_code":"A16-187","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":2580,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":16524,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2324.00","warehousing_date":"2020-01-30","rent_from":"2020-01-30","rent_to":"2021-03-29","delivery_service":"0","remark":"14 months contract. 2 months free. Storage rental and deposit paid by EPS on January 30,2020. Smartcard provided on January 30, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2324,"order_total":18848,"final_order_total":16524,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111, 41205","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \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> A16-187 <\/td>\n\t\t\t\t\t 4X4X7 <\/td>\n\t\t\t\t\t $1290.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1162.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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","1499","NEW","A16-CT207063",1290,1162,2580,0,"14","14",16524,18848,16524,"2020-01-30 15:25:34","0",null,null,null,"2020-01-30","2021-03-29","14 months contract. 2 months free. Storage rental and deposit paid by EPS on January 30,2020. Smartcard provided on January 30, 2020. ","2020-01-30","16",0,null,2324,"2324.00","2","2020-01-30 15:25:34","2","2020-01-30 15:25:34","EPS","","","","EPS","","","",null,0,"111, 41205","C201499","BUSINESS","Mr","ZGBHXOclIM+UlBOBu7+VHw==","J7AHnwLqFVSF7LcuxIPXIg==","Shanghai Legend Limited","Y6Y64684LEAASRCic9igdNR4yxR3hXmGHq6J96GBEKprn0KLnzLI7m6m984WCFvcrderYHqQo1+X52PIW+nuSw==","sKBSHRtWCOMXc4pt3XKKxg==","WZYWUzzptL48Wb1xUe1CA8S7v\/YytLwKMKRM+bSYjDQ=",null,"0Bbp6r4fIjN1S+fUK3wJCw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7063","1678","1290.0","1290.00","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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-30","2021-03-29","1678"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:25:34","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":["7063","A16-D205273","PAID",2580,0,"2021-03-29","2020-01-30 15:25:34","2020-01-30 15:25:34","2","2020-01-30 15:25:34","2","2020-01-30 15:25:34","1499"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7063","1499","SETTLED","A16-I207391","2020-01-30 15:25:34","2020-01-30","2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7391","RENT","\u9810\u7e73\u79df\u91d1",14,1162,"MO","1",1162,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7391"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-30 15:25:34","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":["1499","EPS","","","","EPS","","","","PAID","P207039","2020-01-30 15:25:34",16524,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7039","DEPOSIT","5273","PAID","2020-01-30 15:25:34",2580,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:25:34","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":["7039","INVOICE","7391","PAID","2020-01-30 15:25:34",13944,"2","2020-01-30 15:25:34","2","2020-01-30 15:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1101,"customer_code":"C181101","identity_type":"BUSINESS","identity_id":"63953971-000-10-17-6","title":"Ms","lastname":"Yau ","firstname":"Yuk Yan","companyname":"Alive Yoga Alliance Ltd","email":"amyyoga@ymail.com","tel":"92530001","address":"Flat C & D, 1\/F Fook Ying Building, 379-381 King\u2019s Rd, North Point, H.K","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1709.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-19","renew_room_key":"\u20180012415083","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 08,2019. Deposit $4532 transferred from agreement from C15-CT183638 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196327, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"171","order_discount":[],"order_room":[{"room_id":"1460","room_code":"C15-154","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1461","room_code":"C15-155","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-19","rent_from":"2020-02-19","rent_to":"2020-03-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jan 30,2020. Deposit $4532 transferred from agreement from C15-CT196327 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"\u20180012415083","order_product":[],"pass":true}},"first_order_id":"3638","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-154 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C15-155 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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","index_url_parameter":"filter1=2&filter2=984&filter3=undefined&msg=%E5%8F%96%E6%B6%88","roughly_size":"32","total_discounted_price":"1798.00","deposit":"0.00","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1101,"NEW","C15-CT207064",2216,1798,0,0,"1","1",1798,1798,1798,"2020-01-30 15:39:02","0",null,null,null,"2020-02-19","2020-03-18","1 month contract. Storage rental paid by bank transfer on Jan 30,2020. Deposit $4532 transferred from agreement from C15-CT196327 to this agreement.","2020-02-19","32",0,null,0,"0","2","2020-01-30 15:39:02","2","2020-01-30 15:39:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"\u20180012415083","C181101","BUSINESS","Ms","RlKt34vcZvRZ1B47nY\/fgQ==","eg6mnYsOn64SOpH7hwzmzw==","Alive Yoga Alliance Ltd","J4gN8qCnHYBqifDoM\/w3B4pMnK9R3SOmOekdx0aWx8wFimkFSq\/ovz+SLDRz0JHP0zuDSTMzbkaxg9fQx26Whny0nYhF6eJVpEH5UtgLSVs=","tjARpijmRPN33ts7XMesgw==","26iudEKydkbSBd6ePqD2yTnY4IH4Yvw\/VHV7dVhQ8Rw=",null,"4sVsRnjmji+akrTf224OtJHLnqERjelObNdOANDjidM=",1,"3638"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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":["7064","1460","1108.0","1108.00","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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-02-19","2020-03-18","1460"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:39:02","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":["7064","1461","1108.0","1108.00","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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-02-19","2020-03-18","1461"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:39:02","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":["7064",1101,"SETTLED","C15-I207392","2020-01-30 15:39:02","2020-02-19","2","2020-01-30 15:39:02","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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":["7392","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-01-30 15:39:02","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"7392"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-30 15:39:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1101,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207040","2020-01-30 15:39:02",1798,"2","2020-01-30 15:39:02","2","2020-01-30 15:39:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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":["7040","DEPOSIT",null,"PAID","2020-01-30 15:39:02",0,"2","2020-01-30 15:39:02","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:39:02","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":["7040","INVOICE","7392","PAID","2020-01-30 15:39:02",1798,"2","2020-01-30 15:39:02","2","2020-01-30 15:39:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47:15","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":"type=INVOICE","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":743,"customer_code":"C180743","identity_type":"PERSONAL","identity_id":"D453360(8)","title":"Ms","lastname":"Au","firstname":"Yee Wan Josephine","companyname":"","email":"jojoqueen18@hotmail.com","tel":"64117878","address":"P.O. Box 24683, Aberdeen Post Office, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2599.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-27","renew_room_key":"055,31724","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 25, 2019. Storage deposit transferred from agreement A12-CT194215 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195575, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"51","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"50","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"50","room_code":"A50","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"51","room_code":"A51","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2599,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":15594,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-07-26","delivery_service":"0","remark":"6 months contract. Storage rental $15994 paid by bank transfer on Jan 30,2020. Extra $400 will count into the next contract. Storage deposit transferred from agreement A12-CT195575 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":15594,"final_order_total":15594,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,31724","order_product":[],"pass":true}},"first_order_id":"4215","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A50 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/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> A51 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/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":"40","total_discounted_price":"2599.0","deposit":"0","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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","1",743,"NEW","A12-CT207065",3056,2599,0,0,"6","6",15594,15594,15594,"2020-01-30 15:47:15","0",null,null,null,"2020-01-27","2020-07-26","6 months contract. Storage rental $15994 paid by bank transfer on Jan 30,2020. Extra $400 will count into the next contract. Storage deposit transferred from agreement A12-CT195575 to this agreement.","2020-01-27","40",0,null,0,"0","2","2020-01-30 15:47:15","2","2020-01-30 15:47:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,31724","C180743","PERSONAL","Ms","xl8YzARxqobFgu5qdGYK\/UKKy9YMjmZPHfDbg0Whf0Q=","egeOlBPCZ2i\/hzcvvQMisg==","","zOiUQ1zuE2bBEwRXqfGyNTtJD61RCK8YTYzoqLJdXJYfgcSMVA1w\/e4XTVfDnXV+","R0Ztz7XeRUrQ\/mTdU5vTSA==","\/ytZWViSG2AayMUuWpEVv8idOg4tboq\/mmpHpGZTXno=","Fcrb5K\/Y0MOVHHe1zXw\/Mg==",null,1,"4215"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47:15","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":["7065","76","10","51","%","9.95",152.036,"2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47:15","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":["7065","76","10","50","%","9.95",152.036,"2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7065","50","1528.0",1376,"2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["2020-01-27","2020-07-26","50"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:47: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":["7065","51","1528.0",1376,"2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["2020-01-27","2020-07-26","51"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:47: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":["7065",743,"SETTLED","A12-I207393","2020-01-30 15:47:15","2020-01-27","2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",1,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",2,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",3,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",4,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",5,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7393","RENT","\u9810\u7e73\u79df\u91d1",6,2599,"MO","1",2599,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15594,0,"7393"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-30 15:47: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":[743,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207041","2020-01-30 15:47:15",15594,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7041","DEPOSIT",null,"PAID","2020-01-30 15:47:15",0,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:47: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":["7041","INVOICE","7393","PAID","2020-01-30 15:47:15",15594,"2","2020-01-30 15:47:15","2","2020-01-30 15:47:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58:55","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":728,"customer_code":"C180728","identity_type":"PERSONAL","identity_id":"G480505(3)","title":"Mr","lastname":"Woo","firstname":"Sik On","companyname":"","email":"william.woo@gmail.com","tel":"60868966","address":"Flat A, 19\/F, Sun View Court, 31 Village Rd, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-23","renew_room_key":"052,54060","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 26, 2019. Storage deposit transferred from agreement A18-CT194228 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195563, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"949","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"949","room_code":"V23","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2020-07-22","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jan 30,2020. Storage deposit transferred from agreement A18-CT195563 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,54060","order_product":[],"pass":true}},"first_order_id":"4228","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> V23 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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","3",728,"NEW","A18-CT207066",1290,1162,0,0,"6","6",6972,6972,6972,"2020-01-30 15:58:56","0",null,null,null,"2020-01-23","2020-07-22","6 months contract. Storage rental paid by bank transfer on Jan 30,2020. Storage deposit transferred from agreement A18-CT195563 to this agreement.","2020-01-23","16",0,null,0,"0","2","2020-01-30 15:58:55","2","2020-01-30 15:58:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,54060","C180728","PERSONAL","Mr","lL3Mrx30VGtczqeVmDQFDg==","Jt2QeWOua6BF8QzHyb+5aQ==","","HYuN6K4ExTP+i9dVIq2KimEfS\/Ie7JXqyfoGOpTKoqqEwWLDDSiVZm+vjB8Kz3FqbDE+ln8yDoFJaSvva9\/JHJKR2M6GvLtfdvWvK4I8VWs=","ZoZJDloultxsXDnWTArLUg==","aNlyKDXGhJkXrgHMhUlqax+uH32wpOO+JIxyXXLtlBo=","YB8iJ7QJCdF75fO7tSHgyQ==",null,1,"4228"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7066","250","91","949","%","10.00",129,"2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7066","949","1290.0",1161,"2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["2020-01-23","2020-07-22","949"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-30 15:58: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":["7066",728,"SETTLED","A18-I207394","2020-01-30 15:58:55","2020-01-23","2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7394","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7394"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-30 15:58: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":[728,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207042","2020-01-30 15:58:55",6972,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7042","DEPOSIT",null,"PAID","2020-01-30 15:58:55",0,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:58: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":["7042","INVOICE","7394","PAID","2020-01-30 15:58:55",6972,"2","2020-01-30 15:58:55","2","2020-01-30 15:58:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 15:59:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 16:55:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-30 18:12:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****