{"created_at":"2020-03-20 10:04:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":986,"customer_code":"C180986","identity_type":"PERSONAL","identity_id":"R950235(0)","title":"Mr","lastname":"Mok ","firstname":"Wai Keung","companyname":"","email":"a2488729950@gmail.com","tel":"68457227","address":"Rm2307 ,Sui Ming Hse, Siu Sai Wan Est, Siu Sai Wan, Chai Wan , H.K","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"908.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-11","renew_room_key":"'0012435026","renew_remark":"1 month contract. Storage rental $903 paid by bank transfer on Feb 14,2020. Outstanding $5 will pay in next contract. Deposit $1816 transferred from agreement B01-CT206968 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207191, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"138","order_discount":[],"order_room":[{"room_id":"1219","room_code":"B01-029","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":908,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-11","rent_from":"2020-03-11","rent_to":"2020-04-10","delivery_service":"0","remark":"1 month contract. Storage rental $903 paid by bank transfer on Mar 19,2020. Extra $5 is for agreement B01-CT206968. Deposit $1816 transferred from agreement B01-CT207191 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":908,"final_order_total":908,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012435026","order_product":[],"pass":true}},"first_order_id":"3247","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-029 <\/td>\r\n\t\t\t\t\t	4X3X7 <\/td>\r\n\t\t\t\t\t	$908.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"908.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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",986,"NEW","B01-CT207453",908,908,0,0,"1","1",908,908,908,"2020-03-20 10:17:21","0",null,null,null,"2020-03-11","2020-04-10","1 month contract. Storage rental $903 paid by bank transfer on Mar 19,2020. Extra $5 is for agreement B01-CT206968. Deposit $1816 transferred from agreement B01-CT207191 to this agreement.","2020-03-11","12",0,null,0,"0","2","2020-03-20 10:17:20","2","2020-03-20 10:17:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435026","C180986","PERSONAL","Mr","31Y0XoaFobtCMxnm6mvlFA==","ytgkiE+Fm0DVDP\/K9BuKZg==","","\/xjwgidCRjbnJPBKCuo\/12pqSl6LNrA3NlsIMUsH9BNKaKZYzR6Q54z4PxEVPTW2DvAjTp5DGzVXkPgWrYcHBUDozThZzReTLDf\/mHLbaeQ=","AU0eLXU29TAY\/BkeJ1YrcA==","ngNTmQ\/HB0cYMtP4VGLH4jDsPYe75zJZad7lIY9miHQ=","g+ya6MKmjABbrezVh9RtHw==",null,1,"3247"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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":["7453","1219","908.0","908.00","2","2020-03-20 10:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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-03-11","2020-04-10","1219"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 10:17:21","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":["7453",986,"SETTLED","B01-I207781","2020-03-20 10:17:20","2020-03-11","2","2020-03-20 10:17:20","2","2020-03-20 10:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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":["7781","RENT","\u9810\u7e73\u79df\u91d1",1,908,"MO","1",908,"2","2020-03-20 10:17:20","2","2020-03-20 10:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[908,0,"7781"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 10:17:21","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":[986,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207429","2020-03-20 10:17:20",908,"2","2020-03-20 10:17:20","2","2020-03-20 10:17:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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":["7429","DEPOSIT",null,"PAID","2020-03-20 10:17:20",0,"2","2020-03-20 10:17:20","2","2020-03-20 10:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 10:17:21","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":["7429","INVOICE","7781","PAID","2020-03-20 10:17:20",908,"2","2020-03-20 10:17:20","2","2020-03-20 10:17:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on Feb 20, 2020. Storage deposit transferred from agreement A12-CT207234 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207237, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-21","rent_from":"2020-03-21","rent_to":"2020-04-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT207237 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,32980","order_product":[],"pass":true}},"first_order_id":"4789","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> E06 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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",798,"NEW","A12-CT207454",998,1038,0,0,"1","1",1038,1038,1038,"2020-03-20 11:11:27","0",null,null,null,"2020-03-21","2020-04-20","1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT207237 to this agreement.","2020-03-21","12",0,null,0,"0","2","2020-03-20 11:11:26","2","2020-03-20 11:11:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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":["7454","279","998.0","998.00","2","2020-03-20 11:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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-03-21","2020-04-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 11:11:27","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":["7454",798,"SETTLED","A12-I207782","2020-03-20 11:11:26","2020-03-21","2","2020-03-20 11:11:26","2","2020-03-20 11:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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":["7782","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-03-20 11:11:26","2","2020-03-20 11:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7782"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 11:11:27","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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207430","2020-03-20 11:11:26",1038,"2","2020-03-20 11:11:26","2","2020-03-20 11:11:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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":["7430","DEPOSIT",null,"PAID","2020-03-20 11:11:26",0,"2","2020-03-20 11:11:26","2","2020-03-20 11:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:11:27","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":["7430","INVOICE","7782","PAID","2020-03-20 11:11:26",1038,"2","2020-03-20 11:11:26","2","2020-03-20 11:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1000,"customer_code":"C181000","identity_type":"BUSINESS","identity_id":"69808784","title":"Mr","lastname":"Halliday","firstname":"David Jeffrey","companyname":"Lancashire Decorating Limited","email":"hallid@hotmail.com","tel":"63247121","address":"Unit 305-7, 3\/F, Laford Centre, 838 Lai Chi Kok Road, Cheung Sha Wan, Kowloon","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-22","renew_room_key":"0012385366","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT206943 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207235, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1032","room_code":"A05-030","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1857,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2020-04-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT207235 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1857,"final_order_total":1857,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385366","order_product":[],"pass":true}},"first_order_id":"6943","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-030 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1857.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1000,"NEW","A05-CT207455",1857,1857,0,0,"1","1",1857,1857,1857,"2020-03-20 11:14:10","0",null,null,null,"2020-03-22","2020-04-21","1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT207235 to this agreement. ","2020-03-22","24",0,null,0,"0","2","2020-03-20 11:14:10","2","2020-03-20 11:14:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA==",1,"6943"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7455","1032","1857.0","1857.00","2","2020-03-20 11:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-22","2020-04-21","1032"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7455",1000,"SETTLED","A05-I207783","2020-03-20 11:14:10","2020-03-22","2","2020-03-20 11:14:10","2","2020-03-20 11:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7783","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-03-20 11:14:10","2","2020-03-20 11:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"7783"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1000,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207431","2020-03-20 11:14:10",1857,"2","2020-03-20 11:14:10","2","2020-03-20 11:14:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","DEPOSIT",null,"PAID","2020-03-20 11:14:10",0,"2","2020-03-20 11:14:10","2","2020-03-20 11:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:14:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","INVOICE","7783","PAID","2020-03-20 11:14:10",1857,"2","2020-03-20 11:14:10","2","2020-03-20 11:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:28:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 11:40:44","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:01:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:01:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&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":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":232,"customer_code":"C160232","identity_type":"PERSONAL","identity_id":"D704006(8)","title":"Mr","lastname":"Lam","firstname":"Shing Choi ,Anthony","companyname":"","email":"lamasc@yahoo.com","tel":"91751399","address":"Flat 2,19\/F, Mei Fai House Yue Fai Court Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-14","renew_room_key":"055,06042","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 21, 2019. Storage deposit transferred from agreement A12-CT195475 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT195475, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196195, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"35","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"35","room_code":"A35","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-14","rent_from":"2020-03-14","rent_to":"2020-09-13","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT196195 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06042","order_product":[],"pass":true}},"first_order_id":"4666","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> A35 <\/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":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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",232,"NEW","A12-CT207456",1098,935,0,0,"6","6",5610,5610,5610,"2020-03-20 12:02:00","0",null,null,null,"2020-03-14","2020-09-13","6 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT196195 to this agreement.\r\n","2020-03-14","16",0,null,0,"0","2","2020-03-20 12:01:59","2","2020-03-20 12:01:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06042","C160232","PERSONAL","Mr","vx\/tKEBWrTS+pL3haObGzqkvPbGo9UOWin9bux125Dk=","0JxYUqbNPOvgfMwVa0l0NA==","","5UxcrrCzeNY834KWMDntRSD9ScjBNUNI+1C8iKGNCjqLcso0ViFpLdu06AFQcki5Ra8S66NDqnQDyDBuHllCvg==","QHSu4f\/\/at1IMzYtvWGaHQ==","gaMfvgXLpsEcJ99LiaFm35uCdy0qwtIhSrcN+nzNNiI=","Rum5+18WWTrqEE7KmdnGrg==",null,1,"4666"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7456","72","8","35","%","9.93",109.0314,"2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7456","35","1098.0",989,"2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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-03-14","2020-09-13","35"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 12:02:00","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":["7456",232,"SETTLED","A12-I207784","2020-03-20 12:01:59","2020-03-14","2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7784","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7784"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 12:02:00","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":[232,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207432","2020-03-20 12:01:59",5610,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7432","DEPOSIT",null,"PAID","2020-03-20 12:01:59",0,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 12:02:00","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":["7432","INVOICE","7784","PAID","2020-03-20 12:01:59",5610,"2","2020-03-20 12:01:59","2","2020-03-20 12:01:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:23:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&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":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":621,"customer_code":"C170621","identity_type":"PERSONAL","identity_id":"Z083036(5)","title":"Mr","lastname":"Ng","firstname":"Wai Yip","companyname":"","email":"waiyip010@gmail.com","tel":"98388160","address":"Room 2, 22\/F, Kwun Chiu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-28","renew_room_key":"054,54144","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit transferred from agreement A18-CT207014 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207183, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"849","room_code":"S08","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-28","rent_from":"2020-02-28","rent_to":"2020-03-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A18-CT207183 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,54144","order_product":[],"pass":true}},"first_order_id":"4764","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> S08 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","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",621,"NEW","A18-CT207457",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-20 14:34:08","0",null,null,null,"2020-02-28","2020-03-27","1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A18-CT207183 to this agreement.","2020-02-28","16",0,null,0,"0","2","2020-03-20 14:34:07","2","2020-03-20 14:34:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,54144","C170621","PERSONAL","Mr","ih4aUrxtlcexLCp\/tdkvvw==","cxr02xsD1tXvJ4ihJHZKWw==","","yR95NWcy8orgfJiv4o8nUhldJm21pHQyPqtwASYolM1Kfk2Djou6qn5enXkBMxam3xy5zhVtYjz\/vUJqcjgCQwJJ6wImNgSpgm7xbtLd7UU=","484inTWWBLYNYwPtLecM3w==","eXhWO16jYYVtb51D98Y8hU3AEhjg0o6Un\/aNYSBOey4=","xt28FcrgbbbToDMexv\/cfg==",null,1,"4764"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","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":["7457","849","1290.0","1290.00","2","2020-03-20 14:34:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-28","2020-03-27","849"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7457",621,"SETTLED","A18-I207785","2020-03-20 14:34:07","2020-02-28","2","2020-03-20 14:34:07","2","2020-03-20 14:34:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7785","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-20 14:34:07","2","2020-03-20 14:34:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7785"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[621,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207433","2020-03-20 14:34:07",1290,"2","2020-03-20 14:34:07","2","2020-03-20 14:34:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7433","DEPOSIT",null,"PAID","2020-03-20 14:34:07",0,"2","2020-03-20 14:34:07","2","2020-03-20 14:34:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 14:34:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7433","INVOICE","7785","PAID","2020-03-20 14:34:07",1290,"2","2020-03-20 14:34:07","2","2020-03-20 14:34:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&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":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":550,"customer_code":"C170550","identity_type":"PERSONAL","identity_id":"D703955(8)","title":"Mr","lastname":"Cheng","firstname":"Ming Fai","companyname":"","email":"wilkencheng@yahoo.com","tel":"91702025","address":"Flat \/Rm B, Port Centre,38 Chength Road,Aberdeen ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-19","renew_room_key":"054,19790","renew_remark":"3 months contract. Storage rental paid by PPS on December 19, 2019. Storage deposit transferred from agreement A14-CT195987 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196752, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"603","room_code":"M14","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-19","rent_from":"2020-03-19","rent_to":"2020-06-18","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on March 19, 2020. Storage deposit transferred from agreement A14-CT196752 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,19790","order_product":[],"pass":true}},"first_order_id":"4715","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> M14 <\/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":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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",550,"NEW","A14-CT207458",598,568,0,0,"3","3",1704,1704,1704,"2020-03-20 15:01:27","0",null,null,null,"2020-03-19","2020-06-18","3 months contract. Storage rental paid by PPS on March 19, 2020. Storage deposit transferred from agreement A14-CT196752 to this agreement.","2020-03-19","12",0,null,0,"0","2","2020-03-20 15:01:26","2","2020-03-20 15:01:26","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,19790","C170550","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","UCPBCXrBLI9U7KKsPqgmNA==","","qHa7kQtdphHngo6GIUc8vMRL2hQTJzY5xRW8sweni0ym3gDQFWl3QJd+ivZN5GvsOoEh8tJhpsL55ryTWcEgAg==","\/0JTPSKr2ND2GvxtuABawQ==","CaF+JgbveygWKEgCnzczUIoa61uqMqQtfY2IocaSJuM=","ggKB4vMm7RYdspOrqrvfqA==",null,1,"4715"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7458","603","598.0","598.00","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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-03-19","2020-06-18","603"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 15:01:27","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":["7458",550,"SETTLED","A14-I207786","2020-03-20 15:01:26","2020-03-19","2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7786","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7786","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7786","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7786"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 15:01:27","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":[550,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207434","2020-03-20 15:01:26",1704,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7434","DEPOSIT",null,"PAID","2020-03-20 15:01:26",0,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:01:27","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":["7434","INVOICE","7786","PAID","2020-03-20 15:01:26",1704,"2","2020-03-20 15:01:26","2","2020-03-20 15:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&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":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-17","renew_room_key":"0012450069","renew_remark":"1 month contract. Storage rental paid by PPS on February 17, 2020. Storage deposit $1196 transferred from agreement A12-CT196723 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207217, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-17","rent_from":"2020-03-17","rent_to":"2020-04-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207217 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","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> D17 <\/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.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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",1425,"NEW","A12-CT207459",598,598,0,0,"1","1",598,598,598,"2020-03-20 15:06:16","0",null,null,null,"2020-03-17","2020-04-16","1 month contract. Storage rental paid by PPS on March 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207217 to this agreement. \r\n","2020-03-17","12",0,null,0,"0","2","2020-03-20 15:06:16","2","2020-03-20 15:06:16","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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":["7459","213","598.0","598.00","2","2020-03-20 15:06:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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-03-17","2020-04-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 15:06:16","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":["7459",1425,"SETTLED","A12-I207787","2020-03-20 15:06:16","2020-03-17","2","2020-03-20 15:06:16","2","2020-03-20 15:06:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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":["7787","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-20 15:06:16","2","2020-03-20 15:06:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7787"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 15:06:16","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":[1425,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207435","2020-03-20 15:06:16",598,"2","2020-03-20 15:06:16","2","2020-03-20 15:06:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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":["7435","DEPOSIT",null,"PAID","2020-03-20 15:06:16",0,"2","2020-03-20 15:06:16","2","2020-03-20 15:06:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:06:16","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":["7435","INVOICE","7787","PAID","2020-03-20 15:06:16",598,"2","2020-03-20 15:06:16","2","2020-03-20 15:06:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:12:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"379","master_room_id":"11","room_code":"G20"}],"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> G20 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"R067540(6)","title":"Ms","lastname":"CHENG","firstname":"Oi Ying Andrea","companyname":"","email":"andrea@senreve.com","tel":"63834224","address":"10\/F, WeWork, 33 Lockhart Road, Wan Chai, HK.","pass":true,"customer_id":"1541","customer_code":"C201541","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"379","room_code":"G20","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1768,"deposit":3536,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":5216,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"88.00","warehousing_date":"2020-03-23","rent_from":"2020-03-23","rent_to":"2020-04-22","delivery_service":"0","remark":"1 month contract. Special offer 5% discount. Storage rental and deposit paid by bank transfer on Mar 20,2020. Smart card mailed out on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":88,"order_total":5304,"final_order_total":5216,"location_id":"1","branch_id":"1","company_id":"1","room_key":"'0012415266","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1768.00","deposit":"3536.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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","1541","NEW","A12-CT207460",1768,1768,3536,0,"1","1",5216,5304,5216,"2020-03-20 15:19:32","0",null,null,null,"2020-03-23","2020-04-22","1 month contract. Special offer 5% discount. Storage rental and deposit paid by bank transfer on Mar 20,2020. Smart card mailed out on the same day.","2020-03-23","24",0,null,88,"88.00","2","2020-03-20 15:19:31","2","2020-03-20 15:19:31","BANKIN","","","","BANKIN","","","",null,0,"'0012415266","C201541","PERSONAL","Ms","tC7uPunajh0MRBsyfcX7gw==","+DIqoIiVKYgoYtcxzTTCmw==","","eyxC82qUseKWnLp4mebzuglMoPDApORAHfh7k9cbwIPiP1NTghgf25md1+thXRh5","28+P2\/aXUQjCETOiwFwJGg==","ymnNl12u9uxxHzvQb5vAeAeyQ6RAYV6r6UCAdCjC10I=","6B+IEP7FH0F6giORvS3q+Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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":["7460","379","1768.0","1768.00","2","2020-03-20 15:19:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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-03-23","2020-04-22","379"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 15:19:32","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":["7460","A12-D205331","PAID",3536,0,"2020-04-22","2020-03-20 15:19:31","2020-03-20 15:19:31","2","2020-03-20 15:19:31","2","2020-03-20 15:19:31","1541"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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":["7460","1541","SETTLED","A12-I207788","2020-03-20 15:19:31","2020-03-23","2","2020-03-20 15:19:31","2","2020-03-20 15:19:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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":["7788","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1680,"MO","1",1680,"2","2020-03-20 15:19:31","2","2020-03-20 15:19:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1680,0,"7788"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 15:19:32","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":["1541","BANKIN","","","","BANKIN","","","","PAID","P207436","2020-03-20 15:19:31",5216,"2","2020-03-20 15:19:31","2","2020-03-20 15:19:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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":["7436","DEPOSIT","5331","PAID","2020-03-20 15:19:31",3536,"2","2020-03-20 15:19:31","2","2020-03-20 15:19:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:19:32","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":["7436","INVOICE","7788","PAID","2020-03-20 15:19:31",1680,"2","2020-03-20 15:19:31","2","2020-03-20 15:19:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:46:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":805,"customer_code":"C180805","identity_type":"PERSONAL","identity_id":"D048456(4)","title":"Mr","lastname":"Ip","firstname":"Wai Man Peter","companyname":"","email":"peterip_123@yahoo.com.hk","tel":"90490309","address":"Flat B, 33\/F, Kam Fung Building, 171 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1081.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-24","renew_room_key":"054,49726","renew_remark":"3 months contract. Storage rental paid by cheque on Dec 21, 2019. Storage deposit transferred from agreement A12-CT196008 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196759, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"47","room_code":"A47","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"15","total_retail_price":1138,"total_discounted_price":1081,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3243,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-24","rent_from":"2020-03-24","rent_to":"2020-06-23","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on Mar 20, 2020. Storage deposit transferred from agreement A12-CT196759 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3243,"final_order_total":3243,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,49726","order_product":[],"pass":true}},"first_order_id":"4593","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> A47 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/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":"15","total_discounted_price":"1081.0","deposit":"0","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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",805,"NEW","A12-CT207461",1138,1081,0,0,"3","3",3243,3243,3243,"2020-03-20 15:48:50","0",null,null,null,"2020-03-24","2020-06-23","3 months contract. Storage rental paid by cheque on Mar 20, 2020. Storage deposit transferred from agreement A12-CT196759 to this agreement.\r\n","2020-03-24","15",0,null,0,"0","2","2020-03-20 15:48:49","2","2020-03-20 15:48:49","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,49726","C180805","PERSONAL","Mr","KMW2WNS4\/2Ou1fiLVvP7rg==","bXicfGTTHvCncWFCqwKkUQ==","","2+TfOoy+5c7k+G5pAXlGhKviKQlQ6JMlJ23T5fHsKxBTgK45VYPwAcfHn7dYoNoQRM9cbLQN5++IWilHFxyTiUAmneE4Sfm5Ij8ZN2RhbSo=","vr\/AdzwKQbtT0jM33r1WTQ==","z\/nGCny6I9XIiNief2Hoy+Tox243fC9WIAZtWgdy2Cw=","DNNeq\/sh\/XOOePWAsw2neQ==",null,1,"4593"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7461","47","1138.0","946.00","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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-03-24","2020-06-23","47"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 15:48:50","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":["7461",805,"SETTLED","A12-I207789","2020-03-20 15:48:49","2020-03-24","2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7789","RENT","\u9810\u7e73\u79df\u91d1",1,1081,"MO","1",1081,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7789","RENT","\u9810\u7e73\u79df\u91d1",2,1081,"MO","1",1081,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7789","RENT","\u9810\u7e73\u79df\u91d1",3,1081,"MO","1",1081,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3243,0,"7789"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 15:48:50","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":[805,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207437","2020-03-20 15:48:49",3243,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7437","DEPOSIT",null,"PAID","2020-03-20 15:48:49",0,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 15:48:50","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":["7437","INVOICE","7789","PAID","2020-03-20 15:48:49",3243,"2","2020-03-20 15:48:49","2","2020-03-20 15:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 16:05:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 16:09:22","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 16:17:17","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 16:17:22","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1169,"customer_code":"C191169","identity_type":"PERSONAL","identity_id":"A940893(5)","title":"Ms","lastname":"Ho","firstname":"Emily Siu Yee","companyname":"","email":null,"tel":"92899079","address":"Flat B, 1\/F, Seaview Court, 26 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-25","renew_room_key":"0012492388","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 17, 2019. Storage deposit $2580 transferred from agreement A05-CT195284 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195969, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1150","room_code":"A05-148","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-25","rent_from":"2020-03-25","rent_to":"2020-04-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit $2580 transferred from agreement A05-CT195969 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012492388","order_product":[],"pass":true}},"first_order_id":"4624","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-148 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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",1169,"NEW","A05-CT207462",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-20 17:19:25","0",null,null,null,"2020-03-25","2020-04-24","6 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit $2580 transferred from agreement A05-CT195969 to this agreement.\r\n","2020-03-25","16",0,null,0,"0","2","2020-03-20 17:19:25","2","2020-03-20 17:19:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012492388","C191169","PERSONAL","Ms","Xu2ADsb1wS73d8AGH+\/WTg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","9FD5PzyZ1jqJvlUxI5j2ifPss1nzDLR\/XaKSNFsEotK4TehfR1JBK+O+UL2ob0Z+Jggf4RWVyIt8RTsjSd4JNTO\/fIiOalrdMRRp8JT+1os=","l6cxkQzaXPtplwz5jlBAcw==",null,"WyYJQDbA5P1MT+cdxWYplA==",null,1,"4624"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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":["7462","1150","1290.0","1290.00","2","2020-03-20 17:19:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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-03-25","2020-04-24","1150"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-20 17:19:25","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":["7462",1169,"SETTLED","A05-I207790","2020-03-20 17:19:25","2020-03-25","2","2020-03-20 17:19:25","2","2020-03-20 17:19:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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":["7790","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-20 17:19:25","2","2020-03-20 17:19:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7790"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-20 17:19:25","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":[1169,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207438","2020-03-20 17:19:25",1290,"2","2020-03-20 17:19:25","2","2020-03-20 17:19:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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":["7438","DEPOSIT",null,"PAID","2020-03-20 17:19:25",0,"2","2020-03-20 17:19:25","2","2020-03-20 17:19:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-20 17:19:25","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":["7438","INVOICE","7790","PAID","2020-03-20 17:19:25",1290,"2","2020-03-20 17:19:25","2","2020-03-20 17:19:25"]},"data_before":[],"data_after":[],"step":1} *****