\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>
J45 <\/td>\n\t\t\t\t\t	5X5X8 <\/td>\n\t\t\t\t\t	$1838.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"25","total_discounted_price":"1746.00","deposit":"3676.00","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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","281","NEW","A14-CT208476",1838,1746,3676,0,"3","3",8653,8914,8653,"2020-07-27 13:52:31","0",null,null,null,"2020-08-10","2020-11-09","3 months contract. Special offer 5% \"rent now\" discount. Storage rental and deposit paid by cash on July 27, 2020. Smartcard provided on July 27, 2020. ","2020-08-10","25",0,null,261,"261.00","2","2020-07-27 13:52:30","2","2020-07-27 13:52:30","CASH","","","","CASH","","","",null,0,"189, 27926","C170281","PERSONAL","Mr","uB9sFpdG5i+5cUgdIIlOnw==","7KCehmxbvwRMb+U8lHGoVA==","","svs26+0y1LPqWe\/gH171E6P0QrRGU0IyAe\/sso7l1PE=","4Qg05wmbWd4NjKCZmlXvDQ==",null,"s7cYbtvvsWH7SD0LZNTpdw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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":["8476","463","1838.0","1838.00","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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-08-10","2020-11-09","463"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-27 13:52:31","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":["8476","A14-D205571","PAID",3676,0,"2020-11-09","2020-07-27 13:52:30","2020-07-27 13:52:30","2","2020-07-27 13:52:30","2","2020-07-27 13:52:30","281"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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":["8476","281","SETTLED","A14-I208805","2020-07-27 13:52:30","2020-08-10","2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8805","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1485,"MO","1",1485,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8805","RENT","\u9810\u7e73\u79df\u91d1",2,1746,"MO","1",1746,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8805","RENT","\u9810\u7e73\u79df\u91d1",3,1746,"MO","1",1746,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4977,0,"8805"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-27 13:52:31","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":["281","CASH","","","","CASH","","","","PAID","P208448","2020-07-27 13:52:30",8653,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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":["8448","DEPOSIT","5571","PAID","2020-07-27 13:52:30",3676,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:52:31","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":["8448","INVOICE","8805","PAID","2020-07-27 13:52:30",4977,"2","2020-07-27 13:52:30","2","2020-07-27 13:52:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 13:59:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:09:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:14:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201690","PERSONAL","Mr","J7AHnwLqFVSF7LcuxIPXIg==","wtXe3F1rqyx\/NkkNOLs7pg==","","4VNfXW1OTcgXpTBuOY6xiw==",null,"i42CEDRCEhp0JkCVUEGYa1xwLPXELkePqwRDElHywyKyz9PiD+7CjnIOcRcvXf55hS7A3ENHVuSduzRTrG4CkgfdAIq7EehHfN\/GWkUW34k=","FelF8PFA8AhUacLEOnUJJQ==","",null,"5iGb8E1\/g9dy1xWguzpJeQ==","2","2020-07-27 14:14:16","2","2020-07-27 14:14:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:19:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:38:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:52:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=1595","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1219","master_room_id":"138","room_code":"B01-029"}],"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> B01-029 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $908.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"B555032(2)","title":"Mr","lastname":"LIU","firstname":"Hong","companyname":"","email":"","tel":"52474645","address":"Room 9\/F, Cheong Ching Mansion, 33-39 Wing Hing Street, Tin Hau, H.K.","pass":true,"customer_id":"1690","customer_code":"C201690","customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"340","master_room_id":"138","discount_type":"%","price":"908.00","disocunted_price":"590.90","discount":"34.92","monthly_deduct":317.0736,"room_id":"1219","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1219","room_code":"B01-029","retail_price":"908.0","discounted_price":590.9,"location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":1816,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9904,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"420.00","warehousing_date":"2020-08-17","rent_from":"2020-08-17","rent_to":"2021-08-16","delivery_service":"0","remark":"12 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by bank transfer on July 27, 2020. Smartcard provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":420,"order_total":10324,"final_order_total":9904,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012414231","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"709.00","deposit":"1816.00","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5","1690","NEW","B01-CT208477",908,709,1816,0,"12","12",9904,10324,9904,"2020-07-27 14:54:07","0",null,null,null,"2020-08-17","2021-08-16","12 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by bank transfer on July 27, 2020. Smartcard provided on the same day.","2020-08-17","12",0,null,420,"420.00","2","2020-07-27 14:54:07","2","2020-07-27 14:54:07","BANKIN","","","","BANKIN","","","",null,0,"'0012414231","C201690","PERSONAL","Mr","J7AHnwLqFVSF7LcuxIPXIg==","wtXe3F1rqyx\/NkkNOLs7pg==","","i42CEDRCEhp0JkCVUEGYa1xwLPXELkePqwRDElHywyKyz9PiD+7CjnIOcRcvXf55hS7A3ENHVuSduzRTrG4CkgfdAIq7EehHfN\/GWkUW34k=","4VNfXW1OTcgXpTBuOY6xiw==",null,"FelF8PFA8AhUacLEOnUJJQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:07","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":["8477","340","138","1219","%","34.92",317.0736,"2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:07","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":["8477","1219","908.0",590.9,"2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:07","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-08-17","2021-08-16","1219"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-27 14:54:07","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":["8477","B01-D205572","PAID",1816,0,"2021-08-16","2020-07-27 14:54:07","2020-07-27 14:54:07","2","2020-07-27 14:54:07","2","2020-07-27 14:54:07","1690"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","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":["8477","1690","SETTLED","B01-I208806","2020-07-27 14:54:07","2020-08-17","2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,289,"MO","1",289,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",2,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",3,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8806","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8088,0,"8806"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-27 14:54:08","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":["1690","BANKIN","","","","BANKIN","","","","PAID","P208449","2020-07-27 14:54:07",9904,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","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":["8449","DEPOSIT","5572","PAID","2020-07-27 14:54:07",1816,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 14:54:08","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":["8449","INVOICE","8806","PAID","2020-07-27 14:54:07",8088,"2","2020-07-27 14:54:07","2","2020-07-27 14:54:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 15:05:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 15:30:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 15:34:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 15:34:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 15:36:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:11:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:20:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"820","master_room_id":"88","room_code":"Q17"}],"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> Q17 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"63626063-000-07-20-9","title":"Mr","lastname":"Cheung","firstname":"x","companyname":"Paws In Motion Limited","email":"","tel":"93577541","address":"1\/A, Mount Davis Garden, 5 Mount Davis Road, Pok Fu Lam, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"820","room_code":"Q17","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1218,"deposit":2436,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7554,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2190.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-01-31","delivery_service":"0","remark":"6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jul 27, 2020. Smart card and shelf provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2190,"order_total":10404,"final_order_total":8214,"location_id":"3","branch_id":"1","company_id":"1","room_key":"076, 41081; 189, 51993","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"},{"product_id":"14","product_name":"5\u5c64\u7f6e\u7269\u67b6(\u53ef\u8abf\u7bc0) - \u552e:$600\/\u500b","qty":"1","price":"600.0"}],"pass":true}},"roughly_size":"15","total_discounted_price":"1218.00","deposit":"2436.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:58","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":["C201691","BUSINESS","Mr","nH2DXUv5rc7oVOdCzQNVbQ==","vCxOlXQuvOQaoL822H2o\/Q==","Paws In Motion Limited","+a4BL6BJnXzK0NEhqXlQ5g==",null,"44HBu3nwUVCxftc5KOxmq8xRRTQXbth98B85gC8IohhtGYnbwkD265qkDnT4ofyj3f6YXFFd6Nzg0Gj5hyXsiQ==",null,"oFHkOK1Bs+V02iS9Ehw4zrcdADVqiGzCQ0rES0H\/aQg=",null,"EST42uylrYM\/XOXjtTI4BA==","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","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","3",1691,"NEW","A18-CT208478",1195,1218,2436,0,"6","6",7554,10404,8214,"2020-07-27 16:21:59","0",null,null,null,"2020-08-01","2021-01-31","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jul 27, 2020. Smart card and shelf provided on the same day.","2020-08-01","15",0,null,2190,"2190.00","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56","CHEQUE","","","","CHEQUE","","","",null,0,"076, 41081; 189, 51993","C201691","BUSINESS","Mr","nH2DXUv5rc7oVOdCzQNVbQ==","vCxOlXQuvOQaoL822H2o\/Q==","Paws In Motion Limited","44HBu3nwUVCxftc5KOxmq8xRRTQXbth98B85gC8IohhtGYnbwkD265qkDnT4ofyj3f6YXFFd6Nzg0Gj5hyXsiQ==","+a4BL6BJnXzK0NEhqXlQ5g==",null,null,"oFHkOK1Bs+V02iS9Ehw4zrcdADVqiGzCQ0rES0H\/aQg="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8478",1691,"11","1","60.0",60,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8478",1691,"14","1","600.0",600,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[660,"8478"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-07-27 16:21:59","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":["8478","820","1195.0","1195.00","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","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-08-01","2021-01-31","820"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-27 16:21:59","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":["8478","A18-D205573","PAID",2436,0,"2021-01-31","2020-07-27 16:21:56","2020-07-27 16:21:56","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56",1691]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","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":["8478",1691,"SETTLED","A18-I208807","2020-07-27 16:21:56","2020-08-01","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,246,"MO","1",246,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u9810\u7e73\u79df\u91d1",3,1218,"MO","1",1218,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u9810\u7e73\u79df\u91d1",4,1218,"MO","1",1218,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u9810\u7e73\u79df\u91d1",5,1218,"MO","1",1218,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","RENT","\u9810\u7e73\u79df\u91d1",6,1218,"MO","1",1218,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8807","ORDER_PRODUCT","600.0","PCS","1",600,"14","2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5778,0,"8807"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-27 16:21:59","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":[1691,"CHEQUE","","","","CHEQUE","","","","PAID","P208450","2020-07-27 16:21:56",8214,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","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":["8450","DEPOSIT","5573","PAID","2020-07-27 16:21:56",2436,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:21:59","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":["8450","INVOICE","8807","PAID","2020-07-27 16:21:56",5778,"2","2020-07-27 16:21:56","2","2020-07-27 16:21:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:27:58","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","076, 41081; 189, 51993","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cheque on Jul 27, 2020. Smart card and shelf provided on the same day.","2020-07-27 16:27:58","2","p8c4eRW5jX3SSRR5C1LgtA==","pMWsuwniUqinIZ7Rkxx2XA==","+a4BL6BJnXzK0NEhqXlQ5g==","44HBu3nwUVCxftc5KOxmq8xRRTQXbth98B85gC8IohhtGYnbwkD265qkDnT4ofyj3f6YXFFd6Nzg0Gj5hyXsiQ==","Paws In Motion Limited",8478]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 16:49:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 17:29:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:04:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:09:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:32:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K426537(8)","title":"Mr","lastname":"Leung","firstname":"Cheuk Kin Peter","companyname":"","email":"ckpleung@gmail.com","tel":"91956031","address":"Flat 415, Blk. D, Kornhill, 19 Hong Shing St, Hong Kong","pass":true,"customer_id":"1170","customer_code":"C191170","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"416 available_room_list_input","master_room_id":"170","discount_type":"%","price":"1108.00","disocunted_price":"831.90","discount":"24.92","monthly_deduct":276.1136,"room_id":"1318","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1318","room_code":"C15-012","retail_price":"1108.0","discounted_price":831.9,"location_id":"6"}],"roughly_size":"16","total_retail_price":1108,"total_discounted_price":998,"deposit":1108,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":2371,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4725.00","warehousing_date":"2020-07-26","rent_from":"2020-07-26","rent_to":"2021-01-25","delivery_service":"0","remark":"6 months contract. Change unit from C15-020. Storage rental($3915) and deposit($810) of C15-020 ttl:$4725 transferred from agreement C15-CT208426 to this agreement. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4725,"order_total":7096,"final_order_total":2371,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005796879","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> C15-012 <\/td>\n\t\t\t\t\t 4X4X6.5 <\/td>\n\t\t\t\t\t $1108.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1170","NEW","C15-CT208479",1108,998,1108,0,"6","6",2371,7096,2371,"2020-07-27 18:34:40","0",null,null,null,"2020-07-26","2021-01-25","6 months contract. Change unit from C15-020. Storage rental($3915) and deposit($810) of C15-020 ttl:$4725 transferred from agreement C15-CT208426 to this agreement. ","2020-07-26","16",0,null,4725,"4725.00","2","2020-07-27 18:34:39","2","2020-07-27 18:34:39","BANKIN","","","","BANKIN","","","",null,0,"'0005796879","C191170","PERSONAL","Mr","onFpygDlp7QMdiHELSDrtw==","xEf2h2aoyRQ71ZVgBH+9WQ==","","W6Cb+QcuqMkU1Lk8zZT9NEQwlFLuG+vNTTbabAvD1ZofvXgVxA4Xzl78kA4dHtXbL8Y4TANJaAebQFao8Ga\/Vg==","mdIZh4C4CIGu799lBnyElw==","1M\/dd65p5lwuK+EOCSCR+YmZ5bIukEhicMk+wYxfH00=","Xkrqdqh3gtr\/asAhkX26Ug==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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":["8479","416 available_room_list_input","170","1318","%","24.92",276.1136,"2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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":["8479","1318","1108.0",831.9,"2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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-07-26","2021-01-25","1318"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-27 18:34:40","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":["8479","C15-D205574","PAID",1108,0,"2021-01-25","2020-07-27 18:34:39","2020-07-27 18:34:39","2","2020-07-27 18:34:39","2","2020-07-27 18:34:39","1170"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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":["8479","1170","SETTLED","C15-I208808","2020-07-27 18:34:39","2020-07-26","2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,265,"MO","1",265,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8808","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1263,0,"8808"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-27 18:34:40","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":["1170","BANKIN","","","","BANKIN","","","","PAID","P208451","2020-07-27 18:34:39",2371,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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":["8451","DEPOSIT","5574","PAID","2020-07-27 18:34:39",1108,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:34:40","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":["8451","INVOICE","8808","PAID","2020-07-27 18:34:39",1263,"2","2020-07-27 18:34:39","2","2020-07-27 18:34:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:45:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-27 18:49:12","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":["NEW","'0005796879","6 months contract. Change unit from C15-020. Storage rental($3915) and deposit($810) of C15-020 ttl:$4725 transferred from agreement C15-CT208426 to this agreement. The balance of storage rental and deposit $2371 paid by bank transfer on Jul 28, 2020.","2020-07-27 18:49:12","2","xEf2h2aoyRQ71ZVgBH+9WQ==","onFpygDlp7QMdiHELSDrtw==","1M\/dd65p5lwuK+EOCSCR+YmZ5bIukEhicMk+wYxfH00=","mdIZh4C4CIGu799lBnyElw==","W6Cb+QcuqMkU1Lk8zZT9NEQwlFLuG+vNTTbabAvD1ZofvXgVxA4Xzl78kA4dHtXbL8Y4TANJaAebQFao8Ga\/Vg==",8479]},"data_before":[],"data_after":[],"step":1} *****