\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>
O43 <\/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>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1098.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1467","NEW","A14-CT207956",1098,1098,2196,0,"6","6",7234,8784,7234,"2020-05-26 11:43:46","0",null,null,null,"2020-05-26","2020-11-25","6 months contract. Change unit from M67 to O43. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. Storage rental and deposit $5340 paid by EPS on May 22,2020. Remaining balance $1394 paid by EPS on May 26, 2020. ","2020-05-26","16",0,null,1550,"1550.00","2","2020-05-26 11:43:46","2","2020-05-26 11:43:46","EPS","","","","EPS","","","",null,0,"","C191467","PERSONAL","Mr","kTcsgy8ZGSq2a5ruB8dG1w==","4yTQcEBZNABiF4rq79LzLQ==","","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0","BDiTf1k0\/ZAxx7WVrZVfJA==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","Bq1rNXbKgBuNwBVb0TwBNQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7956","801","1098.0","1098.00","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-26","2020-11-25","801"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7956","A14-D205430","PAID",2196,0,"2020-11-25","2020-05-26 11:43:46","2020-05-26 11:43:46","2","2020-05-26 11:43:46","2","2020-05-26 11:43:46","1467"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7956","1467","SETTLED","A14-I208285","2020-05-26 11:43:46","2020-05-26","2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,646,"MO","1",646,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u9810\u7e73\u79df\u91d1",4,1098,"MO","1",1098,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u9810\u7e73\u79df\u91d1",5,1098,"MO","1",1098,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8285","RENT","\u9810\u7e73\u79df\u91d1",6,1098,"MO","1",1098,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5038,0,"8285"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1467","EPS","","","","EPS","","","","PAID","P207929","2020-05-26 11:43:46",7234,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7929","DEPOSIT","5430","PAID","2020-05-26 11:43:46",2196,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:43:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7929","INVOICE","8285","PAID","2020-05-26 11:43:46",5038,"2","2020-05-26 11:43:46","2","2020-05-26 11:43:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:46:26","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","","6 months contract. Change unit from M67 to O43. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. Storage rental and deposit $5340 paid by EPS on May 22,2020. Remaining balance $1394 paid by EPS on May 26, 2020. ","2020-05-26 11:46:26","2","4yTQcEBZNABiF4rq79LzLQ==","kTcsgy8ZGSq2a5ruB8dG1w==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","BDiTf1k0\/ZAxx7WVrZVfJA==","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0",7956]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1467&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"801","master_room_id":"35","room_code":"O43"}],"_payment_type":"INVOICE","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> O43 <\/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\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K494506(9)","title":"Mr","lastname":"YUE","firstname":"Kin Hang","companyname":"","email":"yokenkoyo@gmail.com","tel":"57918881","address":"Flat H, 8\/F, Block 5, New Jade Garden, Chai Wan","pass":true,"customer_id":"1467","customer_code":"C191467","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"801","room_code":"O43","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":2196,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1550.00","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-12-13","delivery_service":"0","remark":"6 months contract. Change unit from M67 to O43. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. Storage rental and deposit $5340 paid by EPS on May 22,2020. Remaining balance $1240 paid by EPS on May 26, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1550,"order_total":8130,"final_order_total":6580,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191, 05288","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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","1467","NEW","A14-CT207957",1098,989,2196,0,"6","6",6580,8130,6580,"2020-05-26 11:48:45","0",null,null,null,"2020-06-14","2020-12-13","6 months contract. Change unit from M67 to O43. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. Storage rental and deposit $5340 paid by EPS on May 22,2020. Remaining balance $1240 paid by EPS on May 26, 2020. ","2020-06-14","16",0,null,1550,"1550.00","2","2020-05-26 11:48:44","2","2020-05-26 11:48:44","EPS","","","","EPS","","","",null,0,"191, 05288","C191467","PERSONAL","Mr","kTcsgy8ZGSq2a5ruB8dG1w==","4yTQcEBZNABiF4rq79LzLQ==","","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0","BDiTf1k0\/ZAxx7WVrZVfJA==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","Bq1rNXbKgBuNwBVb0TwBNQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["7957","801","1098.0","1098.00","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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-06-14","2020-12-13","801"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 11:48:45","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":["7957","A14-D205431","PAID",2196,0,"2020-12-13","2020-05-26 11:48:44","2020-05-26 11:48:44","2","2020-05-26 11:48:44","2","2020-05-26 11:48:44","1467"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["7957","1467","SETTLED","A14-I208286","2020-05-26 11:48:44","2020-06-14","2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,428,"MO","1",428,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["8286","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4384,0,"8286"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 11:48:45","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":["1467","EPS","","","","EPS","","","","PAID","P207930","2020-05-26 11:48:44",6580,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["7930","DEPOSIT","5431","PAID","2020-05-26 11:48:44",2196,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 11:48:45","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":["7930","INVOICE","8286","PAID","2020-05-26 11:48:44",4384,"2","2020-05-26 11:48:44","2","2020-05-26 11:48:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:27:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:27:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&filter3=undefined","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","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> A05-060 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D512676(3)","title":"Mr","lastname":"CHAN","firstname":"Sing Cheong","companyname":"","email":"","tel":"65754976","address":"Room 5, 1\/F, Wang Shing House, Wang Fuk Court, Tai Po, N.T.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"230","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"955.70","discount":"5.00","monthly_deduct":50.3,"room_id":"1062","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1062","room_code":"A05-060","retail_price":"1006.0","discounted_price":955.7,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":1006,"deposit":2012,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3446,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1584.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-08-31","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. and 5% \"Rent Now\" discount. Storage rental and deposit paid by cash on February 19, 2020. Smartcard provided on February 19, 2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1584,"order_total":5030,"final_order_total":3446,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012438277","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"1006.00","deposit":"2012.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["C201594","PERSONAL","Mr","7VrDwziJ+bF6BiQ1b1UMTQ==","8BEgNhGpCR8jGkzUtrIcXg==","","l0xvmNRy7oDOtbMzTuwmkw==",null,"82fWqZhZcRDMEYj0HQR5iEb06S\/\/TG8eHXYDL4jWW3vqKytT0jpE5B6KFcg2mZwDLm1\/eNuPtBuIH+6h0j\/paw==","SXdyIV5lf0Z05VDssfmjlA==",null,null,"07T8VnvUAnuWP8wGhCJG6w==","2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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",1594,"NEW","A05-CT207958",1006,1006,2012,0,"3","3",3446,5030,3446,"2020-05-26 15:31:13","0",null,null,null,"2020-06-01","2020-08-31","3 months contract. Special offer 50% off for the first 3 months. and 5% \"Rent Now\" discount. Storage rental and deposit paid by cash on February 19, 2020. Smartcard provided on February 19, 2020.","2020-06-01","9",0,null,1584,"1584.00","2","2020-05-26 15:31:11","2","2020-05-26 15:31:11","CASH","","","","CASH","","","",null,0,"'0012438277","C201594","PERSONAL","Mr","7VrDwziJ+bF6BiQ1b1UMTQ==","8BEgNhGpCR8jGkzUtrIcXg==","","82fWqZhZcRDMEYj0HQR5iEb06S\/\/TG8eHXYDL4jWW3vqKytT0jpE5B6KFcg2mZwDLm1\/eNuPtBuIH+6h0j\/paw==","l0xvmNRy7oDOtbMzTuwmkw==",null,"SXdyIV5lf0Z05VDssfmjlA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["7958","230","108","1062","%","5.00",50.3,"2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["7958","1062","1006.0",955.7,"2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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-06-01","2020-08-31","1062"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:31:13","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":["7958","A05-D205432","PAID",2012,0,"2020-08-31","2020-05-26 15:31:11","2020-05-26 15:31:11","2","2020-05-26 15:31:11","2","2020-05-26 15:31:11",1594]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["7958",1594,"SETTLED","A05-I208287","2020-05-26 15:31:11","2020-06-01","2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["8287","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["8287","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,428,"MO","1",428,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["8287","RENT","\u9810\u7e73\u79df\u91d1",3,1006,"MO","1",1006,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1434,0,"8287"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 15:31:13","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":[1594,"CASH","","","","CASH","","","","PAID","P207931","2020-05-26 15:31:11",3446,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["7931","DEPOSIT","5432","PAID","2020-05-26 15:31:11",2012,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:31:13","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":["7931","INVOICE","8287","PAID","2020-05-26 15:31:11",1434,"2","2020-05-26 15:31:11","2","2020-05-26 15:31:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":306,"customer_code":"C170306","identity_type":"PERSONAL","identity_id":"A870682(7)","title":"Mr","lastname":"Chung","firstname":"Shek Kwong","companyname":"","email":null,"tel":"68022573","address":"Flat 06,25 Floor Ka Chun House Ka Lung Court,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3140.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"053,45743","renew_remark":"6 months contract, storage rental paid by Cheque on October 28, 2019; Deposit transfer from agreement A12-CT183721 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196231, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"356","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"355","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"344","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"345","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"356","room_code":"F41","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"355","room_code":"F40","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"345","room_code":"F30","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"344","room_code":"F29","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3140,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":18840,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract, storage rental paid by Cheque on May 26, 2020. Deposit transfer from agreement A12-CT196231 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":18840,"final_order_total":18840,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,45743","order_product":[],"pass":true}},"first_order_id":"3721","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> F41 <\/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> F40 <\/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> F30 <\/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> F29 <\/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":"56","total_discounted_price":"3140.0","deposit":"0","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",306,"NEW","A12-CT207959",4192,3140,0,0,"6","6",18840,18840,18840,"2020-05-26 15:42:42","0",null,null,null,"2020-06-01","2020-11-30","6 months contract, storage rental paid by Cheque on May 26, 2020. Deposit transfer from agreement A12-CT196231 to this agreement.\r\n","2020-06-01","56",0,null,0,"0","2","2020-05-26 15:42:42","2","2020-05-26 15:42:42","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,45743","C170306","PERSONAL","Mr","vVFoGRCFzdVwB415BWSDCw==","ThKwrAIcvgN3JqAg+7\/isg==","","X2cGdurHu+3T9\/GdGmf8x4S8nA03oVl7ok2s77d7l+\/aNP9gVcAWUWhxWx6eLNA3SKr3e8Ul8mOOVbFNP0NAgA==","PVAWX4uHmeDg9h+uAbwn+Q==",null,"41CFwyBqhCj8iVhY\/Q9Yhw==",null,1,"3721"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","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":["7959","72","8","356","%","9.93",109.0314,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","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":["7959","72","8","355","%","9.93",109.0314,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","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":["7959","70","6","344","%","9.96",99.4008,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","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":["7959","70","6","345","%","9.96",99.4008,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7959","356","1098.0",989,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","356"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7959","355","1098.0",989,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","355"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7959","345","998.0",898.6,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","345"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7959","344","998.0",898.6,"2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","344"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7959",306,"SETTLED","A12-I208288","2020-05-26 15:42:42","2020-06-01","2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",1,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",2,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",3,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",4,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",5,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8288","RENT","\u9810\u7e73\u79df\u91d1",6,3140,"MO","1",3140,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[18840,0,"8288"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[306,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207932","2020-05-26 15:42:42",18840,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7932","DEPOSIT",null,"PAID","2020-05-26 15:42:42",0,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:42:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7932","INVOICE","8288","PAID","2020-05-26 15:42:42",18840,"2","2020-05-26 15:42:42","2","2020-05-26 15:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":988,"customer_code":"C180988","identity_type":"PERSONAL","identity_id":"D485713(6)","title":"Ms","lastname":"Lau","firstname":"Yuen Man Joyce","companyname":"","email":"joyceymlau@yahoo.com.hk","tel":"94791023","address":"Flat 2505, Ka Chun House, Ka Lung Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-01","renew_room_key":"189,63719","renew_remark":"12 months contract. Special offer, one month free. Storage rental and deposit paid by cheque on April 26, 2019. Storage deposit $2076 transferred from agreement A18-CT183268 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194812, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"836","room_code":"R10","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-06-30","delivery_service":"0","remark":"13 months contract. Special offer, one month free. Storage rental paid by cheque on May 26, 2020.. Storage deposit $2076 transferred from agreement A18-CT194812 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,63719","order_product":[],"pass":true}},"first_order_id":4812,"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> R10 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",988,"NEW","A18-CT207960",1090,981,0,0,"13","13",11772,12753,11772,"2020-05-26 15:50:53","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer, one month free. Storage rental paid by cheque on May 26, 2020.. Storage deposit $2076 transferred from agreement A18-CT194812 to this agreement.\r\n","2020-06-01","12",0,null,981,"981.00","2","2020-05-26 15:50:53","2","2020-05-26 15:50:53","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"189,63719","C180988","PERSONAL","Ms","l\/5CoY8vPQSm5RBMH2EzhA==","oe4emdjBwqJ3qUpOcI17hw==","","\/kTuLQCxMFMtRP60kozHTv0h4oFD\/7WRrjcOe+2zD5EVU0FtWZVSeDS9YwZ5SctaeuP4Dd20Cp3Kn5LkJNL2oQ==","QxjC0ezfuRy5C0GlNNwcMw==","y8KwqMfxrijaDNGRtv4FiUi4nXRHdcT9NFKFwlc\/bW0=","DUGK22uSOv0bdiNMjf1qPA==",null,1,4812]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["7960","836","1090.0","1090.00","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["2020-06-01","2021-06-30","836"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 15:50: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":["7960",988,"SETTLED","A18-I208289","2020-05-26 15:50:53","2020-06-01","2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50: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":["8289","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8289"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 15:50:53","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":[988,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207933","2020-05-26 15:50:53",11772,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50:53","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":["7933","DEPOSIT",null,"PAID","2020-05-26 15:50:53",0,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 15:50:53","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":["7933","INVOICE","8289","PAID","2020-05-26 15:50:53",11772,"2","2020-05-26 15:50:53","2","2020-05-26 15:50:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 16:11:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 16:30:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&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":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":459,"customer_code":"C170459","identity_type":"PERSONAL","identity_id":"E562760(9)","title":"Ms","lastname":"Lee","firstname":"Ching Han Cecilia","companyname":"","email":null,"tel":"96530474","address":"23G ,Tower 33,South Horizons, Ap Lei Chau","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":"2020-05-26","renew_room_key":"054,27082","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 27, 2019. Storage deposit transferred from agreement A14-CT195101 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196531, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"547","room_code":"L25","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"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":"2020-05-26","rent_from":"2020-05-26","rent_to":"2021-05-25","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher and 2 renewal gifts. Storage rental paid by PPS on May 26, 2020. Storage deposit transferred from agreement A14-CT196531 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,27082","order_product":[],"pass":true}},"first_order_id":"3745","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> L25 <\/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\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":"2020-05-26 18:06: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",459,"NEW","A14-CT207961",1098,935,0,0,"12","12",11220,11220,11220,"2020-05-26 18:06:10","0",null,null,null,"2020-05-26","2021-05-25","12 months contract. Special offer $300 Maxim's voucher and 2 renewal gifts. Storage rental paid by PPS on May 26, 2020. Storage deposit transferred from agreement A14-CT196531 to this agreement.","2020-05-26","16",0,null,0,"0","2","2020-05-26 18:06:09","2","2020-05-26 18:06:09","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,27082","C170459","PERSONAL","Ms","lKXPqnmExhB3swyPzVOFg2TFu7B18q4TKMOXcEhC+os=","kiriEIqhcx866RNZiMXdKQ==","","7PEO8SG39jZDM3+mpqcxi607Lnb7BWHiox9pSl6TfOmOnjcOoe5RM2Fcrsng6D0e","LYrfgWuHtROKu+aiVP1EUA==",null,"WDw2XJutZnAQTZ\/w\/TX4Aw==",null,1,"3745"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["7961","547","1098.0","1098.00","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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-05-26","2021-05-25","547"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:06: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":["7961",459,"SETTLED","A14-I208290","2020-05-26 18:06:09","2020-05-26","2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["8290","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"8290"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 18:06: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":[459,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207934","2020-05-26 18:06:09",11220,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["7934","DEPOSIT",null,"PAID","2020-05-26 18:06:09",0,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:06: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":["7934","INVOICE","8290","PAID","2020-05-26 18:06:09",11220,"2","2020-05-26 18:06:09","2","2020-05-26 18:06:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&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":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-13","renew_room_key":"072,48391","renew_remark":"1 month contract. Storage rental paid by cheque on April 7, 2020. Storage deposit transferred from agreement A14-CT207395 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207674, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"633","room_code":"M44","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-13","rent_from":"2020-05-13","rent_to":"2020-06-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207674 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,48391","order_product":[],"pass":true}},"first_order_id":"4767","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> M44 <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","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",431,"NEW","A14-CT207962",598,598,0,0,"1","1",598,598,598,"2020-05-26 18:38:03","0",null,null,null,"2020-05-13","2020-06-12","1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207674 to this agreement.\r\n","2020-05-13","12",0,null,0,"0","2","2020-05-26 18:38:03","2","2020-05-26 18:38:03","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"072,48391","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4767"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","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":["7962","633","598.0","598.00","2","2020-05-26 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-13","2020-06-12","633"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:38:03","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":["7962",431,"SETTLED","A14-I208291","2020-05-26 18:38:03","2020-05-13","2","2020-05-26 18:38:03","2","2020-05-26 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","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":["8291","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-26 18:38:03","2","2020-05-26 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8291"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 18:38:03","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":[431,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207935","2020-05-26 18:38:03",598,"2","2020-05-26 18:38:03","2","2020-05-26 18:38:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","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":["7935","DEPOSIT",null,"PAID","2020-05-26 18:38:03",0,"2","2020-05-26 18:38:03","2","2020-05-26 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:38:03","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":["7935","INVOICE","8291","PAID","2020-05-26 18:38:03",598,"2","2020-05-26 18:38:03","2","2020-05-26 18:38:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1515&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":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-12","renew_room_key":"136,17013","renew_remark":"1 month contract. Storage rental paid by cheque on April 7, 2020. Storage deposit transferred from agreement A14-CT207396 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207673, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"648","room_code":"M59","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"634","room_code":"M45","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1550,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-12","rent_from":"2020-05-12","rent_to":"2020-06-11","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207673 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,17013","order_product":[],"pass":true}},"first_order_id":"4768","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> M59 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.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> M45 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1550.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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",431,"NEW","A14-CT207963",1550,1198,0,0,"1","1",1198,1198,1198,"2020-05-26 18:40:10","0",null,null,null,"2020-05-12","2020-06-11","1 month contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A14-CT207673 to this agreement.\r\n","2020-05-12","18",0,null,0,"0","2","2020-05-26 18:40:09","2","2020-05-26 18:40:09","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"136,17013","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4768"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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":["7963","648","775.0","775.00","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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-05-12","2020-06-11","648"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:40: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":["7963","634","775.0","775.00","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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-05-12","2020-06-11","634"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:40: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":["7963",431,"SETTLED","A14-I208292","2020-05-26 18:40:09","2020-05-12","2","2020-05-26 18:40:09","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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":["8292","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-05-26 18:40:09","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"8292"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 18:40: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":[431,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207936","2020-05-26 18:40:09",1198,"2","2020-05-26 18:40:09","2","2020-05-26 18:40:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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":["7936","DEPOSIT",null,"PAID","2020-05-26 18:40:09",0,"2","2020-05-26 18:40:09","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:40: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":["7936","INVOICE","8292","PAID","2020-05-26 18:40:09",1198,"2","2020-05-26 18:40:09","2","2020-05-26 18:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=378&filter3=undefined","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":378,"customer_code":"C170378","identity_type":"PERSONAL","identity_id":"D542588(4)","title":"Ms","lastname":"Tang","firstname":"Wai Man","companyname":"","email":null,"tel":"92679299","address":"7\/F Central Block,Sanatorium,2 Village Road,Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"6618.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-01","renew_room_key":"054,59069","renew_remark":"12 months contract. Storage rental paid by cheque on May 23, 2019. Storage deposit $11388 transferred from agreement A14-CT183125 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195048, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"680","room_code":"M91","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"679","room_code":"M90","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"678","room_code":"M89","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"677","room_code":"M88","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"676","room_code":"M87","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"669","room_code":"M80","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"668","room_code":"M79","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"667","room_code":"M78","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"666","room_code":"M77","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"665","room_code":"M76","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"120","total_retail_price":9980,"total_discounted_price":6618,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":79416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-04-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on May 26, 2020. Storage deposit $11388 transferred from agreement A14-CT195048 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":79416,"final_order_total":79416,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,59069","order_product":[],"pass":true}},"first_order_id":"3125","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\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\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> M91 <\/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\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> M90 <\/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\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> M89 <\/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\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> M88 <\/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\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> M87 <\/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\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> M80 <\/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\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> M79 <\/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\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> M78 <\/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\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> M77 <\/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\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> M76 <\/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\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":"120","total_discounted_price":"6618.0","deposit":"0","total_retail_price":"9980.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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",378,"NEW","A14-CT207964",9980,6618,0,0,"12","12",79416,79416,79416,"2020-05-26 18:45:10","0",null,null,null,"2020-05-01","2021-04-30","12 months contract. Storage rental paid by cheque on May 26, 2020. Storage deposit $11388 transferred from agreement A14-CT195048 to this agreement.\r\n","2020-05-01","120",0,null,0,"0","2","2020-05-26 18:45:10","2","2020-05-26 18:45:10","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,59069","C170378","PERSONAL","Ms","fVWUbMaE2hC6HYSPwkdCdQ==","M7CfcmE2OSMlZOkNgaoDmQ==","","pRzFp\/QUQSTvrRIeJ21Ap3CtrbLcfTOFaGLajHaoPUqGAc59GNpGOZ8i8gabv2cUuKsxZnbO115tw\/\/rW6EweA==","wtMz6jx1ean5bkUHsgW8SA==",null,"MmSIvmjUxWjrRim++F08QA==",null,1,"3125"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["7964","680","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","680"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","679","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","679"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","678","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","678"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","677","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","677"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","676","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","676"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","669","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","669"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","668","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","668"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","667","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","667"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","666","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","666"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964","665","998.0","998.00","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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-05-01","2021-04-30","665"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:45: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":["7964",378,"SETTLED","A14-I208293","2020-05-26 18:45:10","2020-05-01","2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",1,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",2,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",3,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",4,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",5,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",6,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",7,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",8,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",9,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",10,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",11,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["8293","RENT","\u9810\u7e73\u79df\u91d1",12,6618,"MO","1",6618,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[79416,0,"8293"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 18:45: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":[378,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207937","2020-05-26 18:45:10",79416,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["7937","DEPOSIT",null,"PAID","2020-05-26 18:45:10",0,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:45: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":["7937","INVOICE","8293","PAID","2020-05-26 18:45:10",79416,"2","2020-05-26 18:45:10","2","2020-05-26 18:45:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=378&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1062","master_room_id":"108","room_code":"A05-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":485,"customer_code":"C170485","identity_type":"BUSINESS","identity_id":"05770131","title":"Mr","lastname":"Cheung","firstname":"Tsun Hin Nicholas","companyname":"Hong Kong Ten Pin Bowling Congress Ltd","email":"hktbc@netvigator.com","tel":"28919786","address":"Rm 2004,Olympic House,1 Stadium Path,So Kon Po,Causeway Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3792.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-10","renew_room_key":"054,46461","renew_remark":"1 month contract. Storage rental paid by cheque on April 2, 2020. Storage deposit transferred from agreement A12-CT207263 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207552, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"194","room_code":"C70","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"193","room_code":"C69","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"183","room_code":"C59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"182","room_code":"C58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3792,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":7584,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-10","rent_from":"2020-04-10","rent_to":"2020-06-09","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A12-CT207552 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7584,"final_order_total":7584,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46461","order_product":[],"pass":true}},"first_order_id":"4867","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> C70 <\/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> C69 <\/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> C59 <\/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> C58 <\/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":"64","total_discounted_price":"3792.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",485,"NEW","A12-CT207965",4392,3792,0,0,"2","2",7584,7584,7584,"2020-05-26 18:47:42","0",null,null,null,"2020-04-10","2020-06-09","2 months contract. Storage rental paid by cheque on May 26, 2020. Storage deposit transferred from agreement A12-CT207552 to this agreement.\r\n","2020-04-10","64",0,null,0,"0","2","2020-05-26 18:47:41","2","2020-05-26 18:47:41","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,46461","C170485","BUSINESS","Mr","qVM+uTcKf4Y9E8s+eih0BbUwgmcs8Dolhv8i5LsTMY4=","vCxOlXQuvOQaoL822H2o\/Q==","Hong Kong Ten Pin Bowling Congress Ltd","R44stv6Dyr9kiU5+jHXzVDEMmdwWNMFGMGD1lN3Z8BcE3\/gfhLYqETOPf5gC7n6eD58k\/jkIWG2yqeoObII72Q==","bk3wscMyfpIXu3yUbW0Avw==","BnxhYhAuTFtuOn0lnUjJwAs5l\/FZMq2vjXv1muEvLVM=",null,"Sd\/ri5Dfmc9LZnNS5Qw5OQ==",1,"4867"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7965","194","1098.0","1098.00","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-06-09","194"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7965","193","1098.0","1098.00","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-06-09","193"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7965","183","1098.0","1098.00","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-06-09","183"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7965","182","1098.0","1098.00","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-06-09","182"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7965",485,"SETTLED","A12-I208294","2020-05-26 18:47:41","2020-04-10","2","2020-05-26 18:47:41","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8294","RENT","\u9810\u7e73\u79df\u91d1",1,3792,"MO","1",3792,"2","2020-05-26 18:47:41","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8294","RENT","\u9810\u7e73\u79df\u91d1",2,3792,"MO","1",3792,"2","2020-05-26 18:47:41","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7584,0,"8294"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[485,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207938","2020-05-26 18:47:41",7584,"2","2020-05-26 18:47:41","2","2020-05-26 18:47:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7938","DEPOSIT",null,"PAID","2020-05-26 18:47:41",0,"2","2020-05-26 18:47:41","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-26 18:47:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7938","INVOICE","8294","PAID","2020-05-26 18:47:41",7584,"2","2020-05-26 18:47:41","2","2020-05-26 18:47:41"]},"data_before":[],"data_after":[],"step":1} *****