\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-108 <\/td>\n\t\t\t\t\t	4X3X6.5 <\/td>\n\t\t\t\t\t	$900.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":"12","total_discounted_price":"855.00","deposit":"900.00","total_retail_price":"900.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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","3","6","1220","NEW","C15-CT196707",900,855,900,0,"3","3",2405,3465,2405,"2019-12-16 18:15:31","0",null,null,null,"2019-12-16","2020-03-15","3 months contract. Change unit from C15-143 to C15-108. Storage rental $1060 transferred from agreement C15-CT196173 to thid agreement. Remaining balance $2405 paid by bank transfer on December 16, 2019. ","2019-12-16","12",0,null,1060,"1060.00","2","2019-12-16 18:15:30","2","2019-12-16 18:15:30","BANKIN","","","","BANKIN","","","",null,0,"'0012403775","C191220","PERSONAL","Mr","ovFd6oXHMscYazWfsL42IQ==","CQSkiYI47zpAX0jM\/inYfQ==","","tNsYAtswVgIwRrnefohYHwqW0\/qT7EFi\/n034QAND88omd7DZqoDYRrjLqyU8SiOBPBLrQHBbi3iORo8Yd6vjw==","oAlpDeafBj+l77mjY6qR2A==",null,"Z\/Uc2OSsjoza5npRKlVrJw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["6707","1414","900.0","900.00","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["2019-12-16","2020-03-15","1414"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:15: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":["6707","C15-D195219","PAID",900,0,"2020-03-15","2019-12-16 18:15:30","2019-12-16 18:15:30","2","2019-12-16 18:15:30","2","2019-12-16 18:15:30","1220"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["6707","1220","SETTLED","C15-I197035","2019-12-16 18:15:30","2019-12-16","2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["7035","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["7035","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,650,"MO","1",650,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["7035","RENT","\u9810\u7e73\u79df\u91d1",3,855,"MO","1",855,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1505,0,"7035"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-16 18:15: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":["1220","BANKIN","","","","BANKIN","","","","PAID","P196685","2019-12-16 18:15:30",2405,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["6685","DEPOSIT","5219","PAID","2019-12-16 18:15:30",900,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:15: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":["6685","INVOICE","7035","PAID","2019-12-16 18:15:30",1505,"2","2019-12-16 18:15:30","2","2019-12-16 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":"1347","master_room_id":"171","room_code":"C15-041"},{"room_id":"1348","master_room_id":"170","room_code":"C15-042"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-041 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C15-042 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\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":"Z024485(7)","title":"Mr","lastname":"TSANG","firstname":"Wai Hang","companyname":"","email":"","tel":"63937108","address":"Room K, 1\/F, Blk 2, Harmony Garden, Siu Sai Wan, Hong Kong","pass":true,"customer_id":"1220","customer_code":"C191220","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"415","master_room_id":"170","discount_type":"%","price":"1108.00","disocunted_price":"1052.90","discount":"4.97","monthly_deduct":55.0676,"room_id":"1348","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"415","master_room_id":"170","discount_type":"%","price":"1108.00","disocunted_price":"1052.90","discount":"4.97","monthly_deduct":55.0676,"room_id":"1347","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1347","room_code":"C15-041","retail_price":"1108.0","discounted_price":1052.9,"location_id":"6"},{"room_id":"1348","room_code":"C15-042","retail_price":"1108.0","discounted_price":1052.9,"location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1709,"deposit":1798,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6925,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-03-15","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on December 16, 2019. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6925,"final_order_total":6925,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012403775","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"1709.00","deposit":"1798.00","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1220","NEW","C15-CT196708",2216,1709,1798,0,"3","3",6925,6925,6925,"2019-12-16 18:24:20","0",null,null,null,"2019-12-16","2020-03-15","3 months contract. Storage rental and deposit paid by bank transfer on December 16, 2019. ","2019-12-16","32",0,null,0,"0","2","2019-12-16 18:24:20","2","2019-12-16 18:24:20","BANKIN","","","","BANKIN","","","",null,0,"'0012403775","C191220","PERSONAL","Mr","ovFd6oXHMscYazWfsL42IQ==","CQSkiYI47zpAX0jM\/inYfQ==","","tNsYAtswVgIwRrnefohYHwqW0\/qT7EFi\/n034QAND88omd7DZqoDYRrjLqyU8SiOBPBLrQHBbi3iORo8Yd6vjw==","oAlpDeafBj+l77mjY6qR2A==",null,"Z\/Uc2OSsjoza5npRKlVrJw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","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":["6708","415","170","1348","%","4.97",55.0676,"2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","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":["6708","415","170","1347","%","4.97",55.0676,"2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6708","1347","1108.0",1052.9,"2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-16","2020-03-15","1347"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6708","1348","1108.0",1052.9,"2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-16","2020-03-15","1348"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6708","C15-D195220","PAID",1798,0,"2020-03-15","2019-12-16 18:24:20","2019-12-16 18:24:20","2","2019-12-16 18:24:20","2","2019-12-16 18:24:20","1220"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6708","1220","SETTLED","C15-I197036","2019-12-16 18:24:20","2019-12-16","2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7036","RENT","\u9810\u7e73\u79df\u91d1",1,1709,"MO","1",1709,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7036","RENT","\u9810\u7e73\u79df\u91d1",2,1709,"MO","1",1709,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7036","RENT","\u9810\u7e73\u79df\u91d1",3,1709,"MO","1",1709,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5127,0,"7036"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-16 18:24:20","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":["1220","BANKIN","","","","BANKIN","","","","PAID","P196686","2019-12-16 18:24:20",6925,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","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":["6686","DEPOSIT","5220","PAID","2019-12-16 18:24:20",1798,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:20","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":["6686","INVOICE","7036","PAID","2019-12-16 18:24:20",5127,"2","2019-12-16 18:24:20","2","2019-12-16 18:24:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":922,"customer_code":"C180922","identity_type":"PERSONAL","identity_id":"R093780(A)","title":"Mr","lastname":"Lem","firstname":"Lester","companyname":"","email":null,"tel":"98341337","address":"33 Villase Road, Claymore Mansion 8C Happy Volley","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1468.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-06","renew_room_key":"0005832634","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 11, 2019. Storage deposit $2936 transferred from agreement C15-CT195695 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196368, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1425","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1425","room_code":"C15-119","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-06","rent_from":"2019-11-06","rent_to":"2020-02-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2936 transferred from agreement C15-CT196368 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"2855","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-119 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1395.00","deposit":"0.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",922,"NEW","C15-CT196709",1322,1395,0,0,"3","3",4185,4185,4185,"2019-12-16 18:24:48","0",null,null,null,"2019-11-06","2020-02-05","3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2936 transferred from agreement C15-CT196368 to this agreement.","2019-11-06","24",0,null,0,"0","2","2019-12-16 18:24:48","2","2019-12-16 18:24:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180922","PERSONAL","Mr","Dzha9dlScOIWPzjcGWfv0g==","GDfCku5DBU5ET7jsJQ4uSQ==","","bQCpfJ6yuCpVED58eFfu55EZKHMm0nCgt7IVHKzBwaIa51jlt0kQdafLHlY\/JF\/mKGWIu5GFpOyI4wUK5Tl5hg==","BsdtSBOUNtjWiYn3vo9VfQ==",null,"j6psOFF4hXAVFDu1lsSO7g==",null,1,"2855"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","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":["6709","419","173","1425","%","5.00",66.1,"2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","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":["6709","1425","1322.0",1255.9,"2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-06","2020-02-05","1425"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:24:48","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":["6709",922,"SETTLED","C15-I197037","2019-12-16 18:24:48","2019-11-06","2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7037","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7037","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7037","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"7037"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-16 18:24:48","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":[922,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196687","2019-12-16 18:24:48",4185,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","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":["6687","DEPOSIT",null,"PAID","2019-12-16 18:24:48",0,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:24:48","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":["6687","INVOICE","7037","PAID","2019-12-16 18:24:48",4185,"2","2019-12-16 18:24:48","2","2019-12-16 18:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":918,"customer_code":"C180918","identity_type":"PERSONAL","identity_id":"D675242(3)","title":"Mrs","lastname":"Ray","firstname":"Lily","companyname":"","email":"lilyrayhk@gmail.com","tel":"98341337","address":" B Floor, 38 Ventns Rd Comfort Mansion, Happy Valley Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1468.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-29","renew_room_key":"0005832634","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 09, 2019. Storage deposit $2936 transferred from agreement C15-CT195829 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196369, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1424","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1424","room_code":"C15-118","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-29","rent_from":"2019-11-29","rent_to":"2020-02-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2936 transferred from agreement C15-CT196369 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"2841","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-118 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1395.00","deposit":"0.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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","3","6",918,"NEW","C15-CT196710",1322,1395,0,0,"3","3",4185,4185,4185,"2019-12-16 18:27:03","0",null,null,null,"2019-11-29","2020-02-28","3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2936 transferred from agreement C15-CT196369 to this agreement.","2019-11-29","24",0,null,0,"0","2","2019-12-16 18:27:02","2","2019-12-16 18:27:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180918","PERSONAL","Mrs","HGSr\/4NUklUwNPOT6LyvzQ==","wJQSZpXGs\/iPthecZsEzXA==","","6qAFKsY2wYrSL+QlaUgJzlgFeq+4QM6\/PgzW\/EPwJEnwsvyfNBYGV0qIHs8X4rE8DnL7HsuO101d9UPTmYCtOA==","BsdtSBOUNtjWiYn3vo9VfQ==","SQ9wa28Pf0jr8etLawngCaTmhsZjMdvvkiOcKAKp2tc=","FzWr1978iA0B4TB8JWUNww==",null,1,"2841"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27:03","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":["6710","419","173","1424","%","5.00",66.1,"2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["6710","1424","1322.0",1255.9,"2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["2019-11-29","2020-02-28","1424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:27: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":["6710",918,"SETTLED","C15-I197038","2019-12-16 18:27:02","2019-11-29","2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["7038","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["7038","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["7038","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"7038"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-16 18:27: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":[918,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196688","2019-12-16 18:27:02",4185,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["6688","DEPOSIT",null,"PAID","2019-12-16 18:27:02",0,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:27: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":["6688","INVOICE","7038","PAID","2019-12-16 18:27:02",4185,"2","2019-12-16 18:27:02","2","2019-12-16 18:27:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:31:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:38:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":[],"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":918,"customer_code":"C180918","identity_type":"PERSONAL","identity_id":"D675242(3)","title":"Mrs","lastname":"Ray","firstname":"Lily","companyname":"","email":"lilyrayhk@gmail.com","tel":"98341337","address":" B Floor, 38 Ventns Rd Comfort Mansion, Happy Valley Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1468.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-11","renew_room_key":"0005832634","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 11, 2019. Storage deposit $2,936 transferred from agreement C15-CT196126 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196370, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1423","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1423","room_code":"C15-117","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-11","rent_from":"2019-12-11","rent_to":"2020-03-10","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2,936 transferred from agreement C15-CT196370 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"4280","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-117 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1395.00","deposit":"0.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",918,"NEW","C15-CT196711",1322,1395,0,0,"3","3",4185,4185,4185,"2019-12-16 18:48:15","0",null,null,null,"2019-12-11","2020-03-10","3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2,936 transferred from agreement C15-CT196370 to this agreement.","2019-12-11","24",0,null,0,"0","2","2019-12-16 18:48:14","2","2019-12-16 18:48:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180918","PERSONAL","Mrs","HGSr\/4NUklUwNPOT6LyvzQ==","wJQSZpXGs\/iPthecZsEzXA==","","6qAFKsY2wYrSL+QlaUgJzlgFeq+4QM6\/PgzW\/EPwJEnwsvyfNBYGV0qIHs8X4rE8DnL7HsuO101d9UPTmYCtOA==","BsdtSBOUNtjWiYn3vo9VfQ==","SQ9wa28Pf0jr8etLawngCaTmhsZjMdvvkiOcKAKp2tc=","FzWr1978iA0B4TB8JWUNww==",null,1,"4280"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6711","419","173","1423","%","5.00",66.1,"2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6711","1423","1322.0",1255.9,"2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-11","2020-03-10","1423"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6711",918,"SETTLED","C15-I197039","2019-12-16 18:48:14","2019-12-11","2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7039","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7039","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7039","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"7039"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[918,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196689","2019-12-16 18:48:14",4185,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6689","DEPOSIT",null,"PAID","2019-12-16 18:48:14",0,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 18:48:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6689","INVOICE","7039","PAID","2019-12-16 18:48:14",4185,"2","2019-12-16 18:48:14","2","2019-12-16 18:48:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 19:07:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-16 23:25:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****