{"created_at":"2019-12-20 10:29:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":275,"customer_code":"C170275","identity_type":"PERSONAL","identity_id":"P935426(7)","title":"Ms","lastname":"Au","firstname":"Shing San","companyname":"","email":null,"tel":"68750303","address":"\u77f3\u6392\u7063\u90a8\u78a7\u8f1d\u6a13707\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1535.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-19","renew_room_key":"133,2756","renew_remark":"1 month contract. Storage rental paid by cash on Nov 18, 2019. Storage deposit transferred from agreement A12-CT196199 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196426, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"373","room_code":"G14","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1535,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1535,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-19","rent_from":"2019-12-19","rent_to":"2020-01-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on December 20, 2019. Storage deposit transferred from agreement A12-CT196426 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1535,"final_order_total":1535,"location_id":"1","branch_id":"1","company_id":"1","room_key":"133,2756","order_product":[],"pass":true}},"first_order_id":"4776","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>
G14 <\/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 \/ <\/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":"24","total_discounted_price":"1535.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",275,"NEW","A12-CT196748",1768,1535,0,0,"1","1",1535,1535,1535,"2019-12-20 10:29:48","0",null,null,null,"2019-12-19","2020-01-18","1 month contract. Storage rental paid by cash on December 20, 2019. Storage deposit transferred from agreement A12-CT196426 to this agreement.\r\n","2019-12-19","24",0,null,0,"0","2","2019-12-20 10:29:47","2","2019-12-20 10:29:47","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,2756","C170275","PERSONAL","Ms","EFxpJJXvWP6pxqsrB6e4rw==","egeOlBPCZ2i\/hzcvvQMisg==","","cfhLoHunuImSyfV\/aZ+b9adtcjA+s\/\/16tHC7+KYDRk=","rzzwlkWLr5BLkj5wjDqTZQ==",null,"djxx0GEU1zjEGX4LvLIgug==",null,1,"4776"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6748","373","1768.0","1768.00","2","2019-12-20 10:29:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-19","2020-01-18","373"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6748",275,"SETTLED","A12-I197076","2019-12-20 10:29:47","2019-12-19","2","2019-12-20 10:29:47","2","2019-12-20 10:29:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7076","RENT","\u9810\u7e73\u79df\u91d1",1,1535,"MO","1",1535,"2","2019-12-20 10:29:47","2","2019-12-20 10:29:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1535,0,"7076"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[275,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196726","2019-12-20 10:29:47",1535,"2","2019-12-20 10:29:47","2","2019-12-20 10:29:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6726","DEPOSIT",null,"PAID","2019-12-20 10:29:47",0,"2","2019-12-20 10:29:47","2","2019-12-20 10:29:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:29:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6726","INVOICE","7076","PAID","2019-12-20 10:29:47",1535,"2","2019-12-20 10:29:47","2","2019-12-20 10:29:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:37:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:53:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 10:53:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:23:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 2, 2019. Storage deposit transferred from agreement A14-CT195847 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196086, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-10","rent_from":"2019-11-10","rent_to":"2019-12-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT196086 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K59 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K56 <\/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\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":"72","total_discounted_price":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT196749",5062,4499,0,0,"1","1",4499,4499,4499,"2019-12-20 11:47:15","0",null,null,null,"2019-11-10","2019-12-09","1 month contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT196086 to this agreement.","2019-11-10","72",0,null,0,"0","2","2019-12-20 11:47:14","2","2019-12-20 11:47:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6749","522","1098.0","1098.00","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-10","2019-12-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6749","521","1098.0","1098.00","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-10","2019-12-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6749","520","1098.0","1098.00","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-10","2019-12-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6749","519","1768.0","1768.00","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-10","2019-12-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6749",423,"SETTLED","A14-I197077","2019-12-20 11:47:14","2019-11-10","2","2019-12-20 11:47:14","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7077","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2019-12-20 11:47:14","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"7077"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196727","2019-12-20 11:47:14",4499,"2","2019-12-20 11:47:14","2","2019-12-20 11:47:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6727","DEPOSIT",null,"PAID","2019-12-20 11:47:14",0,"2","2019-12-20 11:47:14","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6727","INVOICE","7077","PAID","2019-12-20 11:47:14",4499,"2","2019-12-20 11:47:14","2","2019-12-20 11:47:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:47:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:49:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-25","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 26, 2019. Storage deposit transferred from agreement A14-CT196013 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196233, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"449","room_code":"J31","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-25","rent_from":"2019-11-25","rent_to":"2019-12-24","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on November 25, 2019. Storage deposit transferred from agreement A14-CT196233 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4833","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> J31 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","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",423,"NEW","A14-CT196750",1528,1528,0,0,"1","1",1528,1528,1528,"2019-12-20 11:51:24","0",null,null,null,"2019-11-25","2019-12-24","1 month contract. Storage rental paid by bank transfer on November 25, 2019. Storage deposit transferred from agreement A14-CT196233 to this agreement.\r\n","2019-11-25","20",0,null,0,"0","2","2019-12-20 11:51:23","2","2019-12-20 11:51:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4833"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","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":["6750","449","1528.0","1528.00","2","2019-12-20 11:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-25","2019-12-24","449"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 11:51:24","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":["6750",423,"SETTLED","A14-I197078","2019-12-20 11:51:23","2019-11-25","2","2019-12-20 11:51:23","2","2019-12-20 11:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","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":["7078","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2019-12-20 11:51:23","2","2019-12-20 11:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"7078"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 11:51:24","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":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196728","2019-12-20 11:51:23",1528,"2","2019-12-20 11:51:23","2","2019-12-20 11:51:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","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":["6728","DEPOSIT",null,"PAID","2019-12-20 11:51:23",0,"2","2019-12-20 11:51:23","2","2019-12-20 11:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 11:51:24","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":["6728","INVOICE","7078","PAID","2019-12-20 11:51:23",1528,"2","2019-12-20 11:51:23","2","2019-12-20 11:51:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:00:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&filter3=undefined","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":337,"customer_code":"C170337","identity_type":"PERSONAL","identity_id":"D624947(8)","title":"Ms","lastname":"Chan","firstname":"Wan Yuk","companyname":"","email":"winnieey15@gmail.com","tel":"93439373","address":"Rm1,9\/F,Hoi Ying Court,Aberdeen Centre,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3478.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-28","renew_room_key":"133,37016,134,44616","renew_remark":"12 months contract. Storage rental paid by cheque deposit on December 22, 2018. Storage deposit $6384 transferred from agreement SD14-CT182444 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT184005, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"62","order_discount":[{"master_room_discount_id":"153","master_room_id":"62","discount_type":"%","price":"4798.00","disocunted_price":"3986.20","discount":"16.92","monthly_deduct":811.8216,"room_id":"507","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"507","room_code":"K44","retail_price":"4798.0","discounted_price":3986.2,"location_id":"2"}],"roughly_size":"64","total_retail_price":4798,"total_discounted_price":3478,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":41736,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-28","rent_from":"2019-12-28","rent_to":"2020-12-27","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's coupon. Storage rental paid by PPS on December 19, 2018. Storage deposit $6384 transferred from agreement A14-CT184005 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":41736,"final_order_total":41736,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,37016,134,44616","order_product":[],"pass":true}},"first_order_id":4005,"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> K44 <\/td>\r\n\t\t\t\t\t 8X8X8 <\/td>\r\n\t\t\t\t\t $4798.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"64","total_discounted_price":"3478.0","deposit":"0","total_retail_price":"4798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",337,"NEW","A14-CT196751",4798,3478,0,0,"12","12",41736,41736,41736,"2019-12-20 13:24:45","0",null,null,null,"2019-12-28","2020-12-27","12 months contract. Special offer $300 Maxim's coupon. Storage rental paid by PPS on December 19, 2018. Storage deposit $6384 transferred from agreement A14-CT184005 to this agreement.","2019-12-28","64",0,null,0,"0","2","2019-12-20 13:24:45","2","2019-12-20 13:24:45","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"133,37016,134,44616","C170337","PERSONAL","Ms","0WqxymbJWH9N6zlV8RZ3hQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","4GYu7ROxpfJlg2gK0unsfXbFZdsQa83ZT6TMFZwPC13ec+nS8jWCc9ZZHQyzOfl4","6zzIwXNgB8i9h401osIGMw==","b7EZfpJFtrW56Q7wxuqA9QECzBp0e5rBkkRKVMlqya8=","S2e3gk+KEm\/Jcp\/zjCGJ+Q==",null,1,4005]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","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":["6751","153","62","507","%","16.92",811.8216,"2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6751","507","4798.0",3986.2,"2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-28","2020-12-27","507"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6751",337,"SETTLED","A14-I197079","2019-12-20 13:24:45","2019-12-28","2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",7,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",8,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",9,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",10,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",11,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","RENT","\u9810\u7e73\u79df\u91d1",12,3478,"MO","1",3478,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[41736,0,"7079"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[337,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196729","2019-12-20 13:24:45",41736,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6729","DEPOSIT",null,"PAID","2019-12-20 13:24:45",0,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:24:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6729","INVOICE","7079","PAID","2019-12-20 13:24:45",41736,"2","2019-12-20 13:24:45","2","2019-12-20 13:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","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":"2019-12-19","renew_room_key":"054,19790","renew_remark":"3 months contract. Storage rental paid by PPS on September 18, 2019. Storage deposit transferred from agreement A14-CT195425 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195987, \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":"2019-12-19","rent_from":"2019-12-19","rent_to":"2020-03-18","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on December 19, 2019. Storage deposit transferred from agreement A14-CT195987 to this agreement.\r\n","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":"2019-12-20 13:28:51","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-CT196752",598,568,0,0,"3","3",1704,1704,1704,"2019-12-20 13:28:51","0",null,null,null,"2019-12-19","2020-03-18","3 months contract. Storage rental paid by PPS on December 19, 2019. Storage deposit transferred from agreement A14-CT195987 to this agreement.\r\n","2019-12-19","12",0,null,0,"0","2","2019-12-20 13:28:51","2","2019-12-20 13:28:51","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":"2019-12-20 13:28:51","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":["6752","603","598.0","598.00","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-19","2020-03-18","603"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 13:28:51","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":["6752",550,"SETTLED","A14-I197080","2019-12-20 13:28:51","2019-12-19","2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","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":["7080","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","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":["7080","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","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":["7080","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7080"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 13:28:51","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","P196730","2019-12-20 13:28:51",1704,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","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":["6730","DEPOSIT",null,"PAID","2019-12-20 13:28:51",0,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 13:28:51","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":["6730","INVOICE","7080","PAID","2019-12-20 13:28:51",1704,"2","2019-12-20 13:28:51","2","2019-12-20 13:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":607,"customer_code":"C170607","identity_type":"BUSINESS","identity_id":"34332225","title":"Mr","lastname":"Lam","firstname":"Jacky","companyname":"Taxwise Decoration Design Ltd.","email":null,"tel":"98833795","address":"Shop 516, 5\/F, Chi Fu Landmark, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"Chong Hong Bank Ltd","renew_cheque_num2":"001261","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-16","renew_room_key":"055,14232","renew_remark":"6 months contract. Storage rental paid by cheque on June 10, 2019. Storage deposit transferred from agreement SD14-CT183892 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195181, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"440","room_code":"J22","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-06-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on December 20, 2019. Storage deposit transferred from agreement A14-CT195181 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,14232","order_product":[],"pass":true}},"first_order_id":"3892","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> J22 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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",607,"NEW","A14-CT196753",1528,1139,0,0,"6","6",6834,6834,6834,"2019-12-20 14:25:01","0",null,null,null,"2019-12-16","2020-06-15","6 months contract. Storage rental paid by cheque on December 20, 2019. Storage deposit transferred from agreement A14-CT195181 to this agreement.\r\n","2019-12-16","20",0,null,0,"0","2","2019-12-20 14:25:01","2","2019-12-20 14:25:01","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,14232","C170607","BUSINESS","Mr","1v4orkqLQ4k85\/SuEwnhhQ==","0JxYUqbNPOvgfMwVa0l0NA==","Taxwise Decoration Design Ltd.","S5RHrnuCe+8YS9L8iJEQsDrKDQt1pytS\/4VtQh0gSBe9D5ble5nYMnlRBDkcv4h6","HA525dRqfwMp+WB6CjtY8Q==",null,null,"ms0\/PcHzoIpW4AUFDYli0A==",1,"3892"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["6753","440","1528.0","1528.00","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-16","2020-06-15","440"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 14:25:01","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":["6753",607,"SETTLED","A14-I197081","2019-12-20 14:25:01","2019-12-16","2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["7081","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"7081"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 14:25:01","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":[607,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196731","2019-12-20 14:25:01",6834,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["6731","DEPOSIT",null,"PAID","2019-12-20 14:25:01",0,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 14:25:01","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":["6731","INVOICE","7081","PAID","2019-12-20 14:25:01",6834,"2","2019-12-20 14:25:01","2","2019-12-20 14:25:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":738,"customer_code":"C180738","identity_type":"PERSONAL","identity_id":"D538027(9)","title":"Ms","lastname":"Kong","firstname":"Kit Sau Windmill","companyname":"","email":"windmill.chu@gmail.com","tel":"96220862","address":"Flat 1B, Honey Court, 88 Pokfulam Rd., H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"991.0","renew_rent_month":"6","renew_warehousing_date":"2019-10-06","renew_room_key":"054,51120","renew_remark":"6 months contract. Storage rental paid by bank transfer on May 7, 2019. Storage deposit transferred from agreement A18-CT183751 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194917, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[{"master_room_discount_id":"240","master_room_id":"101","discount_type":"%","price":"1058.00","disocunted_price":"1005.10","discount":"5.00","monthly_deduct":52.9,"room_id":"930","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"930","room_code":"V04(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":1005.1,"location_id":"3"}],"roughly_size":"9.6","total_retail_price":1058,"total_discounted_price":1046,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2982,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"156.00","warehousing_date":"2019-10-06","rent_from":"2019-10-06","rent_to":"2020-01-05","delivery_service":"0","remark":"3 months contract. Special offer 5% off. Storage rental paid by bank transfer on November 11, 2019. Storage deposit transferred from agreement A18-CT194917 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":156,"order_total":3138,"final_order_total":2982,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,51120","order_product":[],"pass":true}},"first_order_id":"3751","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> V04(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.4X7 <\/td>\r\n\t\t\t\t\t $1058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9.6","total_discounted_price":"1046.00","deposit":"0.00","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",738,"NEW","A18-CT196754",1058,1046,0,0,"3","3",2982,3138,2982,"2019-12-20 15:10:31","0",null,null,null,"2019-10-06","2020-01-05","3 months contract. Special offer 5% off. Storage rental paid by bank transfer on November 11, 2019. Storage deposit transferred from agreement A18-CT194917 to this agreement.","2019-10-06","9.6",0,null,156,"156.00","2","2019-12-20 15:10:30","2","2019-12-20 15:10:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,51120","C180738","PERSONAL","Ms","gP+\/\/W1SrQ5dYoeYqP1XvBM5lUEGOXL7DWT5DWpBfmc=","F5uIWSqx2McFcjiJ4bOqSw==","","2aYIPOH64af129RFwpNAYJaJjDU0wf2ZJI82wUXQra+IyIVJtlTju5M9iX5uEqcS","qMor+Bb0pdvymUPd2LXZ2g==","rgb96oX9vs4yMRU5SzBqe6TCC9M4Jqk+Oum8jFU\/RHM=","88Qgd5mbsLJBerPLGXWCGg==",null,1,"3751"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","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":["6754","240","101","930","%","5.00",52.9,"2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6754","930","1058.0",1005.1,"2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-06","2020-01-05","930"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6754",738,"SETTLED","A18-I197082","2019-12-20 15:10:30","2019-10-06","2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7082","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,890,"MO","1",890,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7082","RENT","\u9810\u7e73\u79df\u91d1",2,1046,"MO","1",1046,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7082","RENT","\u9810\u7e73\u79df\u91d1",3,1046,"MO","1",1046,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2982,0,"7082"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[738,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196732","2019-12-20 15:10:30",2982,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6732","DEPOSIT",null,"PAID","2019-12-20 15:10:30",0,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:10:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6732","INVOICE","7082","PAID","2019-12-20 15:10:30",2982,"2","2019-12-20 15:10:30","2","2019-12-20 15:10:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":881,"customer_code":"C180881","identity_type":"PERSONAL","identity_id":"K531352(A)","title":"Ms","lastname":"CHOY","firstname":"EUPHEMIA","companyname":"","email":"euphem@yahoo.com","tel":"92022175","address":"27\/F, Flat D, Block 16, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"814.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-27","renew_room_key":"0005921000","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 11, 2019. Storage deposit transferred from agreement A05-CT196194 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196375, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1034","room_code":"A05-032","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":814,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":814,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-27","rent_from":"2019-11-27","rent_to":"2019-12-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196375 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":814,"final_order_total":814,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005921000","order_product":[],"pass":true}},"first_order_id":"4882","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-032 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"814.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","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",881,"NEW","A05-CT196755",1006,814,0,0,"1","1",814,814,814,"2019-12-20 15:58:57","0",null,null,null,"2019-11-27","2019-12-26","1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196375 to this agreement.","2019-11-27","9",0,null,0,"0","2","2019-12-20 15:58:57","2","2019-12-20 15:58:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005921000","C180881","PERSONAL","Ms","cgxXGJI\/ZTnh+WLA7hfGwg==","KHX1V\/o61A5lYN2Th2Ak\/Q==","","U8wra+WSnJl5LR7S5iiWZnnh338ln2lsz3xMjaQzmzZP4BCRoLcPkHMf26rmrqVZKqHoyISkO4JAVUv4wniBZg==","JgGxc0OPptFMBUC8eZGB8A==","cCZv0x8iMqg8yBlgEfmg12iFWmQM8Gc1m7ERyq86bXs=","uZ7Ygw5sLpeeqN2M2YKoJA==",null,1,"4882"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","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":["6755","1034","1006.0","1006.00","2","2019-12-20 15:58:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-27","2019-12-26","1034"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 15:58:57","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":["6755",881,"SETTLED","A05-I197083","2019-12-20 15:58:57","2019-11-27","2","2019-12-20 15:58:57","2","2019-12-20 15:58:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","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":["7083","RENT","\u9810\u7e73\u79df\u91d1",1,814,"MO","1",814,"2","2019-12-20 15:58:57","2","2019-12-20 15:58:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[814,0,"7083"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 15:58:57","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":[881,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196733","2019-12-20 15:58:57",814,"2","2019-12-20 15:58:57","2","2019-12-20 15:58:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","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":["6733","DEPOSIT",null,"PAID","2019-12-20 15:58:57",0,"2","2019-12-20 15:58:57","2","2019-12-20 15:58:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 15:58:57","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":["6733","INVOICE","7083","PAID","2019-12-20 15:58:57",814,"2","2019-12-20 15:58:57","2","2019-12-20 15:58:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1408&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":687,"customer_code":"C180687","identity_type":"PERSONAL","identity_id":"D675603(5)","title":"Ms","lastname":"Wong","firstname":"Lok Yi Candy","companyname":"","email":null,"tel":"90268152","address":"Flat C, 20\/F, Tower 1, Sham Wan Towers, Ap Lei Chau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1036.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-08","renew_room_key":"134,16041","renew_remark":"3 months contract. Storage rental paid by bank transferred on September 18, 2019. Storage deposit $2180 transferred from agreement A18-CT195202 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195977, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"882","room_code":"Y11","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1036,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-03-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transferred on December 20, 2019. Storage deposit $2180 transferred from agreement A18-CT195977 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3108,"final_order_total":3108,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134,16041","order_product":[],"pass":true}},"first_order_id":"4800","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> Y11 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1036.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",687,"NEW","A18-CT196756",1090,1036,0,0,"3","3",3108,3108,3108,"2019-12-20 16:26:26","0",null,null,null,"2019-12-08","2020-03-07","3 months contract. Storage rental paid by bank transferred on December 20, 2019. Storage deposit $2180 transferred from agreement A18-CT195977 to this agreement.\r\n","2019-12-08","12",0,null,0,"0","2","2019-12-20 16:26:26","2","2019-12-20 16:26:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,16041","C180687","PERSONAL","Ms","yV\/SioaJMiWMQj9QbjvBQw==","hULSwM2MvFtpeV9\/z+er8Q==","","gZZjKoytf7\/aMjBy24riG3+7FKQXKWQeN4c5ayDE3FZzZykIuMJePBDOg97SQO1Yv1Kx0L1KbejhBRZVd4rB7g==","6SPyQv\/GcjNiW8cG9Kb1XQ==",null,"h69NujE8OrYG3xO38t2f7w==",null,1,"4800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6756","882","1090.0","1090.00","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-08","2020-03-07","882"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6756",687,"SETTLED","A18-I197084","2019-12-20 16:26:26","2019-12-08","2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7084","RENT","\u9810\u7e73\u79df\u91d1",1,1036,"MO","1",1036,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7084","RENT","\u9810\u7e73\u79df\u91d1",2,1036,"MO","1",1036,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7084","RENT","\u9810\u7e73\u79df\u91d1",3,1036,"MO","1",1036,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3108,0,"7084"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[687,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196734","2019-12-20 16:26:26",3108,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6734","DEPOSIT",null,"PAID","2019-12-20 16:26:26",0,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 16:26:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6734","INVOICE","7084","PAID","2019-12-20 16:26:26",3108,"2","2019-12-20 16:26:26","2","2019-12-20 16:26:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1240&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1055,"customer_code":"C181055","identity_type":"PERSONAL","identity_id":"D455723(A)","title":"Ms","lastname":"Lo","firstname":"Siu Wai, Mabel","companyname":"","email":"mabello@ymail.com","tel":"94717959","address":"Flat G, 17\/F, Block 1, 70 Robinson Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"0012401515","renew_remark":"12 months contract. 1 month free. Storage rental and deposit paid by EPS on November 10, 2018. Smartcard provided on November 10, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183549, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1026","room_code":"A05-024","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-11-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit $3714 transferred from agreement A05-CT183549 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":20064,"final_order_total":20064,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401515","order_product":[],"pass":true}},"first_order_id":3549,"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-024 <\/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":"1672.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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",1055,"NEW","A05-CT196757",1857,1672,0,0,"12","12",20064,20064,20064,"2019-12-20 18:02:28","0",null,null,null,"2019-12-01","2020-11-30","12 months contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit $3714 transferred from agreement A05-CT183549 to this agreement. \r\n","2019-12-01","24",0,null,0,"0","2","2019-12-20 18:02:28","2","2019-12-20 18:02:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012401515","C181055","PERSONAL","Ms","L7jgvzBDHd41s4zET7wG1w==","4w4biS+jM\/Q3DAzxHdf3pA==","","JyUyTcNjmjxoN4ABGAvDldXlzJ+YZNzacQjVOLOsQNqTYrFwznC8gMvmf8wXAslHfJxC3Gi4ppi6myZkv8a7mg==","EMwnkliWWBjS7N5FBRIh5A==","QCsldaeYv672hhrmMrZxGSEGGYzz\/6c\/VbItv7YK6j8=","yHnJmpWHpGABsOJVel9Vog==",null,1,3549]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["6757","1026","1857.0","1857.00","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-11-30","1026"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 18:02:28","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":["6757",1055,"SETTLED","A05-I197085","2019-12-20 18:02:28","2019-12-01","2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",1,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",2,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["7085","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"7085"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 18:02:28","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":[1055,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196735","2019-12-20 18:02:28",20064,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["6735","DEPOSIT",null,"PAID","2019-12-20 18:02:28",0,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:02:28","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":["6735","INVOICE","7085","PAID","2019-12-20 18:02:28",20064,"2","2019-12-20 18:02:28","2","2019-12-20 18:02:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:10:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:34","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":"1580","master_room_id":"204","room_code":"A16-089"}],"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> A16-089 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D523172(9)","title":"Ms","lastname":"LI","firstname":"Ching Lau","companyname":"","email":"evalici@yahoo.com.hk","tel":"90485338","address":"Flat 14C, 39 Tsung Man Street, Aberdeen, HongKong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1580","room_code":"A16-089","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":3210,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":19683,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2312","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2021-01-20","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% discount. Storage rental and deposit paid by cheque on Dec 20,2019.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2312,"order_total":21995,"final_order_total":19683,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32348","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1445.00","deposit":"3210","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C191478","PERSONAL","Ms","8prF7nhsVTNe17dAh1fxaQ==","hbkan9PC5SCnBxQh2lhA4w==","","yx7tYEMwbhoAb5+hWhpbtQ==","9O4jDXDmgsvAbwHaGsZr9ZsPYV0gf2SClE1cZWOjqo4=","1MKFndNSyX14rbajFwvnAUcjbutwvZZaYypNuvSjkWaJl5\/0ts0\/9gC26Hhr7IYJO1UNi2orWkuO0GAA9xdXAQ==","Lrc00im6goTOXEZftnhn+Q==",null,"9O4jDXDmgsvAbwHaGsZr9ZsPYV0gf2SClE1cZWOjqo4=","dFJLhoL2O+y78Ersp1\/zCQ==","2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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","7",1478,"NEW","A16-CT196758",1605,1445,3210,0,"13","13",19683,21995,19683,"2019-12-20 18:55:36","0",null,null,null,"2019-12-21","2021-01-20","13 months contract. Special offer the 13th month free and 5% discount. Storage rental and deposit paid by cheque on Dec 20,2019.","2019-12-21","20",0,null,2312,"2312","2","2019-12-20 18:55:34","2","2019-12-20 18:55:34","CHEQUE","","","","CHEQUE","","","",null,0,"076,32348","C191478","PERSONAL","Ms","8prF7nhsVTNe17dAh1fxaQ==","hbkan9PC5SCnBxQh2lhA4w==","","1MKFndNSyX14rbajFwvnAUcjbutwvZZaYypNuvSjkWaJl5\/0ts0\/9gC26Hhr7IYJO1UNi2orWkuO0GAA9xdXAQ==","yx7tYEMwbhoAb5+hWhpbtQ==","9O4jDXDmgsvAbwHaGsZr9ZsPYV0gf2SClE1cZWOjqo4=","Lrc00im6goTOXEZftnhn+Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["6758","1580","1605.0","1605.00","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-21","2021-01-20","1580"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-20 18:55:36","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":["6758","A16-D195230","PAID",3210,0,"2021-01-20","2019-12-20 18:55:34","2019-12-20 18:55:34","2","2019-12-20 18:55:34","2","2019-12-20 18:55:34",1478]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["6758",1478,"SETTLED","A16-I197086","2019-12-20 18:55:34","2019-12-21","2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,578,"MO","1",578,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["7086","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16473,0,"7086"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-20 18:55:36","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":[1478,"CHEQUE","","","","CHEQUE","","","","PAID","P196736","2019-12-20 18:55:34",19683,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["6736","DEPOSIT","5230","PAID","2019-12-20 18:55:34",3210,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:55:36","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":["6736","INVOICE","7086","PAID","2019-12-20 18:55:34",16473,"2","2019-12-20 18:55:34","2","2019-12-20 18:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-20 18:58:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****