{"created_at":"2020-01-08 09:42:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:43:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:44:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:54:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:54:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:58:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 09:58:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":882,"customer_code":"C180882","identity_type":"PERSONAL","identity_id":"D530672(9)","title":"Mr","lastname":"Leung","firstname":"Chi Ming","companyname":"","email":null,"tel":"94351267","address":"Flat 5, 4\/F, Kong Cheung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"773.0","renew_rent_month":"3","renew_warehousing_date":"2020-12-30","renew_room_key":"0005966491","renew_remark":"3 months contract. Storage rental paid by cash on October 16, 2019. Storage deposit transferred from agreement A05-CT195436 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196151, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[{"master_room_discount_id":"230","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"955.70","discount":"5.00","monthly_deduct":50.3,"room_id":"1036","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1036","room_code":"A05-034","retail_price":"1006.0","discounted_price":955.7,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":773,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2319,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-03-29","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on January 8, 2020. Storage deposit transferred from agreement A05-CT196151 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":2319,"final_order_total":2319,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005966491","order_product":[],"pass":true}},"first_order_id":"4744","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>
A05-034 <\/td>\r\n\t\t\t\t\t	3X3X7 <\/td>\r\n\t\t\t\t\t	$1006.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"773.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",882,"NEW","A05-CT206897",1006,773,0,0,"3","3",2319,2319,2319,"2020-01-08 10:02:15","0",null,null,null,"2019-12-30","2020-03-29","3 months contract. Storage rental paid by cash on January 8, 2020. Storage deposit transferred from agreement A05-CT196151 to this agreement.\r\n","2019-12-30","9",0,null,0,"0","2","2020-01-08 10:02:14","2","2020-01-08 10:02:14","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0005966491","C180882","PERSONAL","Mr","85IYGmU7T42vA2xjCNQ\/9g==","xEf2h2aoyRQ71ZVgBH+9WQ==","","f1Otee2exetSDY63KBCMB4ClcKy31U58v2V1OrtndxPj08LyhdGf77sBw5jowtYY4lsUyc+8FvlHpTdPWV42rJ6os0pNryBExrCHolbe8Mc=","AtSf7pHCvGkS2KK+elUdjw==",null,"TC7RLtAv8Pah7q3bMROAPw==",null,1,"4744"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["6897","230","108","1036","%","5.00",50.3,"2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["6897","1036","1006.0",955.7,"2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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-30","2020-03-29","1036"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 10:02: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":["6897",882,"SETTLED","A05-I207225","2020-01-08 10:02:14","2019-12-30","2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["7225","RENT","\u9810\u7e73\u79df\u91d1",1,773,"MO","1",773,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["7225","RENT","\u9810\u7e73\u79df\u91d1",2,773,"MO","1",773,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["7225","RENT","\u9810\u7e73\u79df\u91d1",3,773,"MO","1",773,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2319,0,"7225"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 10:02: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":[882,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206875","2020-01-08 10:02:14",2319,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["6875","DEPOSIT",null,"PAID","2020-01-08 10:02:14",0,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:02: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":["6875","INVOICE","7225","PAID","2020-01-08 10:02:14",2319,"2","2020-01-08 10:02:14","2","2020-01-08 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:10:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:10:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:17:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:17:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1213,"customer_code":"C191213","identity_type":"PERSONAL","identity_id":"D675154(8)","title":"Mr","lastname":"Lai","firstname":"Chi Leung","companyname":"","email":"stncllai@gmail.com","tel":"90909262","address":"Flat F, 16\/F, Block 2, Marina Habitat, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-15","renew_room_key":"076,29311","renew_remark":"1 months contract. Storage rental paid by bank transfer on December 2, 2019. Storage deposit $4116 transferred from agreement A14-CT196275 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196577, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"47","order_discount":[],"order_room":[{"room_id":"421","room_code":"J03","retail_price":"2058.0","discounted_price":"2058.00","location_id":"2"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-15","rent_from":"2019-12-15","rent_to":"2020-01-14","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $2058 transferred from agreement A14-CT196577 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29311","order_product":[],"pass":true}},"first_order_id":"4505","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> J03 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1213,"NEW","A14-CT206898",2058,2058,0,0,"1","1",2058,2058,2058,"2020-01-08 10:42:45","0",null,null,null,"2019-12-15","2020-01-14","1 months contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $2058 transferred from agreement A14-CT196577 to this agreement.\r\n","2019-12-15","28",0,null,0,"0","2","2020-01-08 10:42:44","2","2020-01-08 10:42:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29311","C191213","PERSONAL","Mr","YHO9lR4lqOinRR0Xuvx6GQ==","lzx0GiXnrd0waIhp6oozpQ==","","epq2EMNVqnrSImwJRTcdnw2CHWw10ygMMBpAt77nlPddtfyEsXACwT2aMxYbyEJsCa3lf0v5S\/ALrV0zfovOLg==","5+ZDtxq474AT888WIcgBDQ==","DnhYj4sh2SVkNhDCs31R8YYc2LVQWdEbeyjdGnSC39g=","j4fRluAlfK8sfp67hqNgSw==",null,1,"4505"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6898","421","2058.0","2058.00","2","2020-01-08 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-15","2020-01-14","421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6898",1213,"SETTLED","A14-I207226","2020-01-08 10:42:44","2019-12-15","2","2020-01-08 10:42:44","2","2020-01-08 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7226","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-01-08 10:42:44","2","2020-01-08 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7226"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1213,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206876","2020-01-08 10:42:44",2058,"2","2020-01-08 10:42:44","2","2020-01-08 10:42:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6876","DEPOSIT",null,"PAID","2020-01-08 10:42:44",0,"2","2020-01-08 10:42:44","2","2020-01-08 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:42:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6876","INVOICE","7226","PAID","2020-01-08 10:42:44",2058,"2","2020-01-08 10:42:44","2","2020-01-08 10:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 10:51:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:11:24","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","190,40459,190,26677","3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Outstanding $366 will be deducted in next agreement. Deposit $2456 transferred from agreement A14-CT196428 to this agreement.","2020-01-08 11:11:24","2","kiriEIqhcx866RNZiMXdKQ==","GqH+t4D4XqDN5Gx3zJwoLQ==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","xblDSif\/OxScVYnZ8ntRGw==","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=",6817]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:24:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:25:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:29:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1165,"customer_code":"C191165","identity_type":"PERSONAL","identity_id":"D488336(6)","title":"Ms","lastname":"CHIU","firstname":"Man Kwan","companyname":"","email":"candichiu@hotmail.com","tel":"96512360","address":"Flat1003, 10\/F, Tai Hang Terrace, 5 Chu Fa RD, Tai Hang, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-03","renew_room_key":"189,17463","renew_remark":"6 months contact. Storage rental paid by bank transfer on June 30, 2019. Storage deposit $1196 transferred from agreement A14-CT194078 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195368, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"594","room_code":"M05","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2020-07-02","delivery_service":"0","remark":"6 months contact. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $1196 transferred from agreementA14-CT195368 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,17463","order_product":[],"pass":true}},"first_order_id":"4078","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> M05 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1165,"NEW","A14-CT206899",598,538,0,0,"6","6",3228,3228,3228,"2020-01-08 11:35:03","0",null,null,null,"2020-01-03","2020-07-02","6 months contact. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $1196 transferred from agreementA14-CT195368 to this agreement.\r\n","2020-01-03","12",0,null,0,"0","2","2020-01-08 11:35:03","2","2020-01-08 11:35:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,17463","C191165","PERSONAL","Ms","nc3fEXXJHnulVM\/GUMaHew==","+2U\/KB65ELBPajGnn0cBQw==","","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==","OmcRTHhYzrQ1CZc5esvItA==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","fs+3rtDIEM41Zps0NSod4Q==",null,1,"4078"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["6899","594","598.0","598.00","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-03","2020-07-02","594"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 11:35: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":["6899",1165,"SETTLED","A14-I207227","2020-01-08 11:35:03","2020-01-03","2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["7227","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7227"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 11:35: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":[1165,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206877","2020-01-08 11:35:03",3228,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["6877","DEPOSIT",null,"PAID","2020-01-08 11:35:03",0,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35: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":["6877","INVOICE","7227","PAID","2020-01-08 11:35:03",3228,"2","2020-01-08 11:35:03","2","2020-01-08 11:35:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=2&filter2=822&filter3=undefined","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"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> F18 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"P536999(5)","title":"Ms","lastname":"LEI","firstname":"IOK I","companyname":"","email":"ioki@netvigator.com","tel":"61027222","address":"Flat 15B, Twin Brook, 43 Repulse Bay Road, Hong Kong","pass":true,"customer_id":"822","customer_code":"C180822","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"333","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"333","room_code":"F18","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1043,"deposit":2196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":531,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4794.00","warehousing_date":"2020-01-09","rent_from":"2020-01-09","rent_to":"2020-04-08","delivery_service":"0","remark":"3 months contract. Change unit from F11 F22 to F18. Storage deposit $4794 transferred from agreement A12-CT196733 to this agreement. Remaining balance $531 paid by cash on January 8, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":4794,"order_total":5325,"final_order_total":531,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,50128","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1043.0","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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","1","822","NEW","A12-CT206900",1098,1043,2196,0,"3","3",531,5325,531,"2020-01-08 11:35:26","0",null,null,null,"2020-01-09","2020-04-08","3 months contract. Change unit from F11 F22 to F18. Storage deposit $4794 transferred from agreement A12-CT196733 to this agreement. Remaining balance $531 paid by cash on January 8, 2020. ","2020-01-09","16",0,null,4794,"4794.00","2","2020-01-08 11:35:26","2","2020-01-08 11:35:26","CASH","","","","CASH","","","",null,0,"053,50128","C180822","PERSONAL","Ms","ZARR3F9DLOjNhWXHL6JFWw==","T7yW\/GgDIBeB5D+4Gc1Low==","","hnzJCmTji9piYfzerefUu\/TJM7yQKQZ\/PbVcIOLxAT9UBe9irR\/dwTUmCzW2KngqC9NlM39pxcLMojd\/5VQoqA==","4crgvokPCzNQ8+tQ54dSnA==","CWE+zIdqCgJYA4ODEL3nC2Sl7MaIf8shJOmM5VxZrN8=","uk0qyjxHCwGFsgy\/rb\/L0g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["6900","433","8","333","%","4.97",54.5706,"2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["6900","333","1098.0",1043.4,"2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2020-04-08","333"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 11:35:26","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":["6900","A12-D205240","PAID",2196,0,"2020-04-08","2020-01-08 11:35:26","2020-01-08 11:35:26","2","2020-01-08 11:35:26","2","2020-01-08 11:35:26","822"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["6900","822","SETTLED","A12-I207228","2020-01-08 11:35:26","2020-01-09","2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["7228","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["7228","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["7228","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7228"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 11:35:26","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":["822","CASH","","","","CASH","","","","PAID","P206878","2020-01-08 11:35:26",2196,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["6878","DEPOSIT","5240","PAID","2020-01-08 11:35:26",2196,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:35:26","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":["6878","INVOICE","7228","PAID","2020-01-08 11:35:26",0,"2","2020-01-08 11:35:26","2","2020-01-08 11:35:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:46:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:46:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:47:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:50:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 11:51:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 12:52:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 13:09:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:14:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:21:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:22:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:33:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1930.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-13","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on December 12, 2019. Storage deposit transferred from agreement A18-CT196390 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196686, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[],"order_room":[{"room_id":"921","room_code":"U22","retail_price":"1930.0","discounted_price":"1930.00","location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1930,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2020-02-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196686 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1930,"final_order_total":1930,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4603","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> U22 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.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\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":"25","total_discounted_price":"1930.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",645,"NEW","A18-CT206901",1930,1930,0,0,"1","1",1930,1930,1930,"2020-01-08 14:35:31","0",null,null,null,"2020-01-13","2020-02-12","1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196686 to this agreement.","2020-01-13","25",0,null,0,"0","2","2020-01-08 14:35:31","2","2020-01-08 14:35:31","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4603"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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":["6901","921","1930.0","1930.00","2","2020-01-08 14:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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-01-13","2020-02-12","921"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 14:35: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":["6901",645,"SETTLED","A18-I207229","2020-01-08 14:35:31","2020-01-13","2","2020-01-08 14:35:31","2","2020-01-08 14:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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":["7229","RENT","\u9810\u7e73\u79df\u91d1",1,1930,"MO","1",1930,"2","2020-01-08 14:35:31","2","2020-01-08 14:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1930,0,"7229"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 14:35: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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206879","2020-01-08 14:35:31",1930,"2","2020-01-08 14:35:31","2","2020-01-08 14:35:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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":["6879","DEPOSIT",null,"PAID","2020-01-08 14:35:31",0,"2","2020-01-08 14:35:31","2","2020-01-08 14:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:35: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":["6879","INVOICE","7229","PAID","2020-01-08 14:35:31",1930,"2","2020-01-08 14:35:31","2","2020-01-08 14:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-27","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on December 12, 2019. Storage deposit transferred from agreement A18-CT196391 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196687, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"102","order_discount":[],"order_room":[{"room_id":"951","room_code":"V25","retail_price":"3180.0","discounted_price":"3180.00","location_id":"3"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-02-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196687 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4604","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> V25 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"42","total_discounted_price":"3180.0","deposit":"0","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",645,"NEW","A18-CT206902",3180,3180,0,0,"1","1",3180,3180,3180,"2020-01-08 14:40:03","0",null,null,null,"2020-01-27","2020-02-26","1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196687 to this agreement.\r\n","2020-01-27","42",0,null,0,"0","2","2020-01-08 14:40:02","2","2020-01-08 14:40:02","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4604"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40: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":["6902","951","3180.0","3180.00","2","2020-01-08 14:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-27","2020-02-26","951"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 14:40: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":["6902",645,"SETTLED","A18-I207230","2020-01-08 14:40:02","2020-01-27","2","2020-01-08 14:40:02","2","2020-01-08 14:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40: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":["7230","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-01-08 14:40:02","2","2020-01-08 14:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"7230"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 14:40: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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206880","2020-01-08 14:40:02",3180,"2","2020-01-08 14:40:02","2","2020-01-08 14:40:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40: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":["6880","DEPOSIT",null,"PAID","2020-01-08 14:40:02",0,"2","2020-01-08 14:40:02","2","2020-01-08 14:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:40: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":["6880","INVOICE","7230","PAID","2020-01-08 14:40:02",3180,"2","2020-01-08 14:40:02","2","2020-01-08 14:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on December 6, 2019. Storage deposit $2976 transferred from agreement B01-CT196331 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196633, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-02-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit $2976 transferred from agreement B01-CT196633 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","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> B01-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.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":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","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","2","5",888,"NEW","B01-CT206903",1488,1488,0,0,"1","1",1488,1488,1488,"2020-01-08 14:42:47","0",null,null,null,"2020-01-06","2020-02-05","1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit $2976 transferred from agreement B01-CT196633 to this agreement.","2020-01-06","24",0,null,0,"0","2","2020-01-08 14:42:47","2","2020-01-08 14:42:47","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","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":["6903","1274","1488.0","1488.00","2","2020-01-08 14:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-02-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 14:42:47","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":["6903",888,"SETTLED","B01-I207231","2020-01-08 14:42:47","2020-01-06","2","2020-01-08 14:42:47","2","2020-01-08 14:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","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":["7231","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-01-08 14:42:47","2","2020-01-08 14:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"7231"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 14:42:47","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":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206881","2020-01-08 14:42:47",1488,"2","2020-01-08 14:42:47","2","2020-01-08 14:42:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","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":["6881","DEPOSIT",null,"PAID","2020-01-08 14:42:47",0,"2","2020-01-08 14:42:47","2","2020-01-08 14:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:42:47","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":["6881","INVOICE","7231","PAID","2020-01-08 14:42:47",1488,"2","2020-01-08 14:42:47","2","2020-01-08 14:42:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":284,"customer_code":"C170284","identity_type":"PERSONAL","identity_id":"R589291(A)","title":"Ms","lastname":"Perkins","firstname":"Emma Archer ","companyname":"","email":"emmaarcherperkins@gmail.com","tel":"65016839","address":"11A Four Winds, 4 Mount Davis Rd, Pokfulam","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-07","renew_room_key":"055,37962","renew_remark":"3 months contract. Storage rental paid by bank transfer on September 16, 2019. Storage deposit transferred from agreement A12-CT1951563 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195952, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"372","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"372","room_code":"G13","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-07","rent_from":"2019-12-07","rent_to":"2020-03-06","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A12-CT195952 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,37962","order_product":[],"pass":true}},"first_order_id":"4414","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> G13 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",284,"NEW","A12-CT206904",1098,989,0,0,"3","3",2967,2967,2967,"2020-01-08 14:45:03","0",null,null,null,"2019-12-07","2020-03-06","3 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A12-CT195952 to this agreement.\r\n","2019-12-07","16",0,null,0,"0","2","2020-01-08 14:45:03","2","2020-01-08 14:45:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,37962","C170284","PERSONAL","Ms","UAfRQnWL2QeUohvM1+Pnag==","bJnB4wyZfyZ0dcp78AFERg==","","O68VSwRWrJAUG6yGXqfyEMxog9sNgTPqsQsoIw+2pyazFPCZK+YyWvzvzWWHdo+n","d8hmdnJ8jOPns+D4R3b6RA==","jqVImduaZ5H0FE2TEWpPBxgxBWX3bTcsWAbQMZ6\/ZlU=","WrsOcxmhiIiD44RY9MDcBQ==",null,1,"4414"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["6904","433","8","372","%","4.97",54.5706,"2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["6904","372","1098.0",1043.4,"2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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-12-07","2020-03-06","372"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 14:45: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":["6904",284,"SETTLED","A12-I207232","2020-01-08 14:45:03","2019-12-07","2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["7232","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["7232","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["7232","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7232"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 14:45: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":[284,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206882","2020-01-08 14:45:03",2967,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["6882","DEPOSIT",null,"PAID","2020-01-08 14:45:03",0,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:45: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":["6882","INVOICE","7232","PAID","2020-01-08 14:45:03",2967,"2","2020-01-08 14:45:03","2","2020-01-08 14:45:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:50:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 14:52:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:00:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:28:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:40:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":812,"customer_code":"C180812","identity_type":"PERSONAL","identity_id":"P591651(1)","title":"Ms","lastname":"Hwong","firstname":"Yil Nil","companyname":"","email":"hwongreb@netvigator.com","tel":"91557437","address":"Flat 9A, Block 1, Cavendish Heights, 33 Perkins Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4534.0","renew_rent_month":"6","renew_warehousing_date":"2019-10-04","renew_room_key":"137,05391","renew_remark":"6 months contract. Storage rental paid by cheque on May 17, 2019. Storage deposit transferred from agreement A18-CT183690 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194997, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"93","order_discount":[{"master_room_discount_id":"306","master_room_id":"93","discount_type":"%","price":"5038.00","disocunted_price":"4533.70","discount":"10.01","monthly_deduct":504.3038,"room_id":"870","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"870","room_code":"T14","retail_price":"5038.0","discounted_price":4533.7,"location_id":"3"}],"roughly_size":"64","total_retail_price":5038,"total_discounted_price":4534,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":27204,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-04","rent_from":"2019-10-04","rent_to":"2020-04-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on January 8, 2020. Storage deposit transferred from agreement A18-CT194997 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":27204,"final_order_total":27204,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,05391","order_product":[],"pass":true}},"first_order_id":"3690","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> T14 <\/td>\r\n\t\t\t\t\t 8X8X7 <\/td>\r\n\t\t\t\t\t $5038.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":"64","total_discounted_price":"4534.0","deposit":"0","total_retail_price":"5038.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",812,"NEW","A18-CT206905",5038,4534,0,0,"6","6",27204,27204,27204,"2020-01-08 15:50:52","0",null,null,null,"2019-10-04","2020-04-03","6 months contract. Storage rental paid by cheque on January 8, 2020. Storage deposit transferred from agreement A18-CT194997 to this agreement.","2019-10-04","64",0,null,0,"0","2","2020-01-08 15:50:51","2","2020-01-08 15:50:51","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"137,05391","C180812","PERSONAL","Ms","\/RT0ADSI+yZhVHlf06IjFA==","AgRQrmrTgqQTe7hemOAG9A==","","TSkRH\/30HlW5smbNZ\/B2Nsdlon8cl7a4zzywGbATDjtmaE3No\/ayBPFQ7BpKIikdthjxp59qBt+OvjjVWb++vA==","04E9w2VqoknTBiP8S3YG4g==","Mc3npIIaocXdZ1JeoaA215Z8kEsJrBDS\/deWyk7QKjE=","BKhOW34fKniMglg+JrLpoQ==",null,1,"3690"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["6905","306","93","870","%","10.01",504.3038,"2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["6905","870","5038.0",4533.7,"2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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-10-04","2020-04-03","870"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 15:50:52","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":["6905",812,"SETTLED","A18-I207233","2020-01-08 15:50:51","2019-10-04","2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",1,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",2,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",3,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",4,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",5,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["7233","RENT","\u9810\u7e73\u79df\u91d1",6,4534,"MO","1",4534,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27204,0,"7233"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 15:50:52","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":[812,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206883","2020-01-08 15:50:51",27204,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["6883","DEPOSIT",null,"PAID","2020-01-08 15:50:51",0,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 15:50:52","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":["6883","INVOICE","7233","PAID","2020-01-08 15:50:51",27204,"2","2020-01-08 15:50:51","2","2020-01-08 15:50:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 16:04:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 16:58:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":58,"customer_code":"C160058","identity_type":"PERSONAL","identity_id":"Z621585","title":"Mr","lastname":"Yip","firstname":"Wing Sum","companyname":"","email":"samyip666@hotmail.com","tel":"93030843","address":"\u9999\u6e2f\u4ed4\u5229\u6771\u90a8\u6771\u6607\u6a1337\u6a133702\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-06","renew_room_key":"19038642","renew_remark":"12 months contract, storage rental and deposit paid by Cheque on Dec 6, 2018, smart card provided on Dec 6,2018\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183840, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4044.0","renew_master_room_id":"14","order_discount":[{"master_room_discount_id":"85","master_room_id":"14","discount_type":"%","price":"2318.00","disocunted_price":"1926.50","discount":"16.89","monthly_deduct":391.5102,"room_id":"46","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"46","room_code":"A46","retail_price":"2318.0","discounted_price":1926.5,"location_id":"1"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":1788,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-12-05","delivery_service":"0","remark":"12 months contract. storage rental paid by Cheque on January 8, 2020. Storage deposit $4044 transferred from agreement A12-CT183840 to this agreement.\r\nSpecial offer $300 Maxim's voucher provided later.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":21456,"final_order_total":21456,"location_id":"1","branch_id":"1","company_id":"1","room_key":"19038642","order_product":[],"pass":true}},"first_order_id":3840,"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> A46 <\/td>\r\n\t\t\t\t\t 4X8X8 <\/td>\r\n\t\t\t\t\t $2318.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",58,"NEW","A12-CT206906",2318,1788,0,0,"12","12",21456,21456,21456,"2020-01-08 17:46:34","0",null,null,null,"2019-12-06","2020-12-05","12 months contract. storage rental paid by Cheque on January 8, 2020. Storage deposit $4044 transferred from agreement A12-CT183840 to this agreement.\r\nSpecial offer $300 Maxim's voucher provided later.\r\n","2019-12-06","32",0,null,0,"0","2","2020-01-08 17:46:34","2","2020-01-08 17:46:34","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"19038642","C160058","PERSONAL","Mr","9\/pW3J\/5rUjdIwN6XOAY2Q==","H9gmHz05\/Te4s1\/V+q8XVg==","","l0BMwZfFPk+IJugCkjiNrvEsAlaRtW1rF\/7r1cYfoez8K2Yanw2ocz1s7qeDU8ry","YgzjTFhwBFV3DRIw6KFG2g==","fN9rihfkdTSChND4OkGWR\/SQnu7UYvgkcbYXYt+FASw=","Jb5hZyNnzlbc5xSlX5aClg==",null,1,3840]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","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":["6906","85","14","46","%","16.89",391.5102,"2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6906","46","2318.0",1926.5,"2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-12-05","46"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6906",58,"SETTLED","A12-I207234","2020-01-08 17:46:34","2019-12-06","2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[21456,0,"7234"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[58,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206884","2020-01-08 17:46:34",21456,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6884","DEPOSIT",null,"PAID","2020-01-08 17:46:34",0,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 17:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6884","INVOICE","7234","PAID","2020-01-08 17:46:34",21456,"2","2020-01-08 17:46:34","2","2020-01-08 17:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:13:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=888&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"333","master_room_id":"8","room_code":"F18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental paid by cash deposit on November 11, 2019. Storage deposit transferred from agreement A12-CT196112 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196383, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-02-13","delivery_service":"0","remark":"2 months contract. Storage rental paid by cash deposit on December 7, 2019 and January 8, 2020. Storage deposit transferred from agreement A12-CT196383 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","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> D18 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",62,"NEW","A12-CT206907",598,598,0,0,"2","2",1196,1196,1196,"2020-01-08 18:23:44","0",null,null,null,"2019-12-14","2020-02-13","2 months contract. Storage rental paid by cash deposit on December 7, 2019 and January 8, 2020. Storage deposit transferred from agreement A12-CT196383 to this agreement.\r\n","2019-12-14","12",0,null,0,"0","2","2020-01-08 18:23:44","2","2020-01-08 18:23:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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":["6907","214","598.0","598.00","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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-14","2020-02-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-08 18:23:44","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":["6907",62,"SETTLED","A12-I207235","2020-01-08 18:23:44","2019-12-14","2","2020-01-08 18:23:44","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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":["7235","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-08 18:23:44","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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":["7235","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-01-08 18:23:44","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"7235"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-08 18:23:44","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":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206885","2020-01-08 18:23:44",1196,"2","2020-01-08 18:23:44","2","2020-01-08 18:23:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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":["6885","DEPOSIT",null,"PAID","2020-01-08 18:23:44",0,"2","2020-01-08 18:23:44","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-08 18:23:44","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":["6885","INVOICE","7235","PAID","2020-01-08 18:23:44",1196,"2","2020-01-08 18:23:44","2","2020-01-08 18:23:44"]},"data_before":[],"data_after":[],"step":1} *****