{"created_at":"2020-05-15 09:44:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:08:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":208,"customer_code":"C160208","identity_type":"PERSONAL","identity_id":"H404535(3)","title":"Mr","lastname":"Hui","firstname":"Chung Chi","companyname":"","email":"biggreenfish@gmail.com","tel":"92050127","address":"\u9999\u6e2f\u4ed4\u5927\u9053244\u865f\u6d77\u5cf0\u83ef\u8ed240\u6a13C\u5ea7","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"136,62560","renew_remark":"6 months contract. Storage rental paid by cash on November 19, 2019. Storage deposit transferred from agreement A12-CT195016 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196440, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"289","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"289","room_code":"E16","retail_price":"998.0","discounted_price":829.9,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2021-05-23","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's Voucher. And 2 renewal gift. Storage rental paid by cash on May 15, 2020. Storage deposit transferred from agreement A12-CT196440 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":10788,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"136,62560","order_product":[],"pass":true}},"first_order_id":"3508","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>
E16 <\/td>\r\n\t\t\t\t\t	4X3X8 <\/td>\r\n\t\t\t\t\t	$998.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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",208,"NEW","A12-CT207852",998,899,0,0,"12","12",10788,10788,10788,"2020-05-15 10:18:58","0",null,null,null,"2020-05-24","2021-05-23","12 months contract. Special offer $300 Maxim's Voucher. And 2 renewal gift. Storage rental paid by cash on May 15, 2020. Storage deposit transferred from agreement A12-CT196440 to this agreement.\r\n","2020-05-24","12",0,null,0,"0","2","2020-05-15 10:18:57","2","2020-05-15 10:18:57","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"136,62560","C160208","PERSONAL","Mr","GNeVHImG7wtZZ3WD\/EZhRw==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","+UJOG4CCqRbsW8fPhm6qoxhkwoX+Or5dcY3gJrcj\/HN3MLV65LknF9kDCj7l2ks7","7\/vBIKN7r1AG5hOfUUYOvg==","zEex90x0zrCn+0bTf534japrHU5Xi2rBdteCRjBl7uM=","9F7Dw9fpEZzjcRdMSPDdlg==",null,1,"3508"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["7852","71","6","289","%","16.84",168.0632,"2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["7852","289","998.0",829.9,"2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-24","2021-05-23","289"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 10:18:58","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":["7852",208,"SETTLED","A12-I208181","2020-05-15 10:18:57","2020-05-24","2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["8181","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8181"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 10:18:58","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":[208,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207826","2020-05-15 10:18:57",10788,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["7826","DEPOSIT",null,"PAID","2020-05-15 10:18:57",0,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:18:58","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":["7826","INVOICE","8181","PAID","2020-05-15 10:18:57",10788,"2","2020-05-15 10:18:57","2","2020-05-15 10:18:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":823,"customer_code":"C180823","identity_type":"BUSINESS","identity_id":"39661261","title":"Mr","lastname":"Milan Martinez","firstname":"Alejandro","companyname":"La Nao Group Limited","email":"a.milan@la-nao.com","tel":"90212010","address":"13A, Trust Tower, 68 Johnston Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-13","renew_room_key":"055,09251","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 16, 2020. Storage deposit transferred from agreement A14-CT207428 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207650, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"794","room_code":"K60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"515","room_code":"K52","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-13","rent_from":"2020-04-13","rent_to":"2020-05-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A14-CT207650 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,09251","order_product":[],"pass":true}},"first_order_id":"4785","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 \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> K60 <\/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> K52 <\/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>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","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",823,"NEW","A14-CT207853",2196,2318,0,0,"1","1",2318,2318,2318,"2020-05-15 10:42:55","0",null,null,null,"2020-04-13","2020-05-12","1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A14-CT207650 to this agreement.\r\n","2020-04-13","32",0,null,0,"0","2","2020-05-15 10:42:54","2","2020-05-15 10:42:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09251","C180823","BUSINESS","Mr","Ltuw0GNYtUHvg5xq\/qUHZw==","B0t4iVfZVAQdLpfngFJQ9g==","La Nao Group Limited","ogXiJSz6bxnQX1arPQzS4HtoujvXU7DtPI6iXMqgmibwYxgUDD+7IDSdp7zHKT1WsucqNnxkVRDDkoVXniYCDA==","oMTdQIHVXIpTgMmFZOwTlA==","toRvij1IyfmFV4d7mZnp4cg+UZM6Nv9c2C6kHmvTa8c=",null,"mWmgEjucdLaH5rglf7tExg==",1,"4785"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","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":["7853","794","1098.0","1098.00","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-13","2020-05-12","794"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 10:42:55","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":["7853","515","1098.0","1098.00","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-13","2020-05-12","515"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 10:42:55","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":["7853",823,"SETTLED","A14-I208182","2020-05-15 10:42:54","2020-04-13","2","2020-05-15 10:42:54","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","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":["8182","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-05-15 10:42:54","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"8182"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 10:42:55","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":[823,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207827","2020-05-15 10:42:54",2318,"2","2020-05-15 10:42:54","2","2020-05-15 10:42:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","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":["7827","DEPOSIT",null,"PAID","2020-05-15 10:42:54",0,"2","2020-05-15 10:42:54","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 10:42:55","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":["7827","INVOICE","8182","PAID","2020-05-15 10:42:54",2318,"2","2020-05-15 10:42:54","2","2020-05-15 10:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 11:44:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":394,"customer_code":"C170394","identity_type":"BUSINESS","identity_id":"51818278","title":"Mr","lastname":"Chow","firstname":"Hoi To","companyname":"HAPPY SEA LIMITED","email":"zexus.peter@gmail.com","tel":"90920331","address":"Flat 7,6\/F,SHAN ON HOUSE,YUE ON COURT,Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1430.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-03","renew_room_key":"136,64693","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 16, 2019. Storage deposit transferred from agreement A14-CT195013 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196705, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"49","order_discount":[],"order_room":[{"room_id":"518","room_code":"K55","retail_price":"1838.0","discounted_price":"1838.00","location_id":"2"}],"roughly_size":"25","total_retail_price":1838,"total_discounted_price":1430,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-03","rent_from":"2020-04-03","rent_to":"2020-10-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A14-CT196705 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8580,"final_order_total":8580,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,64693","order_product":[],"pass":true}},"first_order_id":"3375","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> K55 <\/td>\r\n\t\t\t\t\t 5X5X8 <\/td>\r\n\t\t\t\t\t $1838.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":"25","total_discounted_price":"1430.0","deposit":"0","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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",394,"NEW","A14-CT207854",1838,1430,0,0,"6","6",8580,8580,8580,"2020-05-15 13:18:39","0",null,null,null,"2020-04-03","2020-10-02","6 months contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A14-CT196705 to this agreement.\r\n","2020-04-03","25",0,null,0,"0","2","2020-05-15 13:18:38","2","2020-05-15 13:18:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,64693","C170394","BUSINESS","Mr","TSaR79pvORU4kE\/P0tLIiQ==","anq5M29vFb7FteUGD1jgrQ==","HAPPY SEA LIMITED","Wn1kKSAN2R5m07KytuN1sEbp8Vejf7Beyn6RtzMM\/zzet2zlD9sl8ilvegIHTohu","zD0OYnqDAgH70WX9EgQpdg==","t++\/F0ppVeNcnyUyobdt4GrrmtSr+Cd5wwzoNFCRaFQ=",null,"\/Jz7ODURtf6NgTCujJhfDw==",1,"3375"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["7854","518","1838.0","1838.00","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-03","2020-10-02","518"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 13:18:39","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":["7854",394,"SETTLED","A14-I208183","2020-05-15 13:18:38","2020-04-03","2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",1,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",2,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",3,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",4,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",5,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["8183","RENT","\u9810\u7e73\u79df\u91d1",6,1430,"MO","1",1430,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8580,0,"8183"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 13:18:39","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":[394,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207828","2020-05-15 13:18:38",8580,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["7828","DEPOSIT",null,"PAID","2020-05-15 13:18:38",0,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:18:39","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":["7828","INVOICE","8183","PAID","2020-05-15 13:18:38",8580,"2","2020-05-15 13:18:38","2","2020-05-15 13:18:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 13:22:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&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":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1539,"customer_code":"C201539","identity_type":"PERSONAL","identity_id":"Y064298(1)","title":"Ms","lastname":"TONG","firstname":"Ka Ming","companyname":"","email":"kaming.tong928@gmail.com","tel":"60266931","address":"\u5c07\u8ecd\u6fb3\u539a\u5fb7\u6751\u5fb7\u88d5\u6a1337\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3058.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-17","renew_room_key":"0005795970","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 12, 2020. Storage deposit $6116 transfered from agreement B01-CT207430 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207611, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1213","room_code":"B01-023","retail_price":"1838.0","discounted_price":"1838.00","location_id":"5"},{"room_id":"1214","room_code":"B01-024","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"54","total_retail_price":3326,"total_discounted_price":3058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-06-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207611 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3058,"final_order_total":3058,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005795970","order_product":[],"pass":true}},"first_order_id":"7430","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 \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-023 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $1838.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> B01-024 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"54","total_discounted_price":"3058.0","deposit":"0","total_retail_price":"3326.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1539,"NEW","B01-CT207855",3326,3058,0,0,"1","1",3058,3058,3058,"2020-05-15 14:13:21","0",null,null,null,"2020-05-17","2020-06-16","1 month contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit $6116 transfered from agreement B01-CT207611 to this agreement.\r\n","2020-05-17","54",0,null,0,"0","2","2020-05-15 14:13:21","2","2020-05-15 14:13:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005795970","C201539","PERSONAL","Ms","emjjkRBZVUSRLbEK77SFEw==","gXED7wniUUNHTT8LsF+fbg==","","bNlP7L7RLt8Fl8B\/yay2q\/dmX7vl9M\/ct23uQR74gJmaO+DCNAZgg0xupPoXF2Hi","rzzpVRFrFmmseYl9vvbFwA==","YSHrDxAftHtY\/YX7L1PEr5QDC4wwmDjJTX59NG9kGk0=","0ux6P2R1VhDModzCYtVS5A==",null,1,"7430"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7855","1213","1838.0","1838.00","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","1213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7855","1214","1488.0","1488.00","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","1214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7855",1539,"SETTLED","B01-I208184","2020-05-15 14:13:21","2020-05-17","2","2020-05-15 14:13:21","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8184","RENT","\u9810\u7e73\u79df\u91d1",1,3058,"MO","1",3058,"2","2020-05-15 14:13:21","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3058,0,"8184"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1539,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207829","2020-05-15 14:13:21",3058,"2","2020-05-15 14:13:21","2","2020-05-15 14:13:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7829","DEPOSIT",null,"PAID","2020-05-15 14:13:21",0,"2","2020-05-15 14:13:21","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:13:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7829","INVOICE","8184","PAID","2020-05-15 14:13:21",3058,"2","2020-05-15 14:13:21","2","2020-05-15 14:13:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&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":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":852,"customer_code":"C180852","identity_type":"BUSINESS","identity_id":"33657674-000-03-18-7","title":"Mr","lastname":"Lau","firstname":"Gerald","companyname":"Pacific Sky Holdings Limited","email":"phoenix@laufamilyoffice.com","tel":"98809440","address":"Flat 1604, Tai Tung Bldg., 8 Fleming Road, Wan Chai, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3931.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-17","renew_room_key":"190,39679 , 191 05287","renew_remark":"3 months contract. Storage rental paid by cheque deposit on February 21, 2020. Storage deposit transferred from agreement A14-CT196460 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207241, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"763","room_code":"O39","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"762","room_code":"O38","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"752","room_code":"O28","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"751","room_code":"O27","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":4138,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4138,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-06-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit transferred from agreement A14-CT207241 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4138,"final_order_total":4138,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39679 , 191 05287","order_product":[],"pass":true}},"first_order_id":"3672","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> O39 <\/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> O38 <\/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> O28 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\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> O27 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\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":"56","total_discounted_price":"4138.00","deposit":"0.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",852,"NEW","A14-CT207856",4192,4138,0,0,"1","1",4138,4138,4138,"2020-05-15 14:30:16","0",null,null,null,"2020-05-17","2020-06-16","1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit transferred from agreement A14-CT207241 to this agreement.\r\n","2020-05-17","56",0,null,0,"0","2","2020-05-15 14:30:16","2","2020-05-15 14:30:16","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,39679 , 191 05287","C180852","BUSINESS","Mr","8Sg5HEYOjjrQdMyK1+QWDA==","oe4emdjBwqJ3qUpOcI17hw==","Pacific Sky Holdings Limited","IIKRaaGPL2HpnfgJAUJhCj8+x0hKi5DNcx6YIYwtlZEVlqlzxdoWKu0w1522L4DfmIdFoJkBhGa6ZfmacJM6dg==","c1K4BLKclEz9E3nuvvIo3A==","\/nCaUx+Hqmx6yjXW1XYmc6GmvIbzzej1NbJ+mu4tneg=",null,"LrVQNy2nb4HilGXMHPXLx0dpSDyGUkQVOQmMveXzVow=",1,"3672"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7856","763","1098.0","1098.00","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","763"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7856","762","1098.0","1098.00","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","762"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7856","752","998.0","998.00","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","752"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7856","751","998.0","998.00","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","751"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7856",852,"SETTLED","A14-I208185","2020-05-15 14:30:16","2020-05-17","2","2020-05-15 14:30:16","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8185","RENT","\u9810\u7e73\u79df\u91d1",1,4138,"MO","1",4138,"2","2020-05-15 14:30:16","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4138,0,"8185"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[852,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207830","2020-05-15 14:30:16",4138,"2","2020-05-15 14:30:16","2","2020-05-15 14:30:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7830","DEPOSIT",null,"PAID","2020-05-15 14:30:16",0,"2","2020-05-15 14:30:16","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:30:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7830","INVOICE","8185","PAID","2020-05-15 14:30:16",4138,"2","2020-05-15 14:30:16","2","2020-05-15 14:30:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&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":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1369,"customer_code":"C191369","identity_type":"PERSONAL","identity_id":"K168595(3)","title":"Ms","lastname":"Lam","firstname":"Chak Yan Jessie Teresa","companyname":"","email":"jessielam98@yahoo.com","tel":"90249982","address":"Flat G, 39\/F, Block 10, Park Central, 9 Tong Tak St, Tseung Kwan O, New Territories","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1722.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-17","renew_room_key":"0012400828","renew_remark":"1 month contract. Storage rental paid by PPS on April 15, 2020. Storage deposit $3444 transferred from agreement B01-CT207446 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207655, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"144","order_discount":[],"order_room":[{"room_id":"1245","room_code":"B01-055","retail_price":"1722.0","discounted_price":"1722.00","location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1722,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1722,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-06-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit $3444 transferred from agreement B01-CT207655 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1722,"final_order_total":1722,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012400828","order_product":[],"pass":true}},"first_order_id":"5735","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-055 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $1722.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1722.0","deposit":"0","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1369,"NEW","B01-CT207857",1722,1722,0,0,"1","1",1722,1722,1722,"2020-05-15 14:32:38","0",null,null,null,"2020-05-17","2020-06-16","1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit $3444 transferred from agreement B01-CT207655 to this agreement. \r\n","2020-05-17","28",0,null,0,"0","2","2020-05-15 14:32:38","2","2020-05-15 14:32:38","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012400828","C191369","PERSONAL","Ms","jK0sLQIokMTYV3ZXRP7RRXDjgJo6nAphSESGZHss\/8U=","0JxYUqbNPOvgfMwVa0l0NA==","","pTmVYn+9+08jSfjkrAQ930uwUJzZ7GoK3+66lfew+t\/0fxR9nqTrYogXakd2cb9Sk2zdmyu\/qWeMNreBPl1p7XP\/HNblMsLwTfHvYfY+z2iPqem7sllCAATFp9Gnw3Iz","oV5+sNO0lE615GWj8tpo0Q==","kejhjXk8xC0HdcA9K5VT+zQSSUKUT3H1mkDxQhBuRjw=","VerPwfNhcgk\/G01dKO+a8A==",null,1,"5735"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","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":["7857","1245","1722.0","1722.00","2","2020-05-15 14:32:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","1245"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 14:32:38","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":["7857",1369,"SETTLED","B01-I208186","2020-05-15 14:32:38","2020-05-17","2","2020-05-15 14:32:38","2","2020-05-15 14:32:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","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":["8186","RENT","\u9810\u7e73\u79df\u91d1",1,1722,"MO","1",1722,"2","2020-05-15 14:32:38","2","2020-05-15 14:32:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1722,0,"8186"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 14:32:38","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":[1369,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207831","2020-05-15 14:32:38",1722,"2","2020-05-15 14:32:38","2","2020-05-15 14:32:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","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":["7831","DEPOSIT",null,"PAID","2020-05-15 14:32:38",0,"2","2020-05-15 14:32:38","2","2020-05-15 14:32:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:32:38","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":["7831","INVOICE","8186","PAID","2020-05-15 14:32:38",1722,"2","2020-05-15 14:32:38","2","2020-05-15 14:32:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 14:49:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16: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":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":396,"customer_code":"C170396","identity_type":"PERSONAL","identity_id":"D118288(A)","title":"Mr","lastname":"Ip","firstname":"Kwan Chak Robert","companyname":"","email":"robert.kc.ip@gmail.com","tel":"93039668","address":"Level 19,IFC 2,8 Finance Steet,Central,Hong Kong","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":"13","renew_warehousing_date":"2020-06-02","renew_room_key":"055,31254 054,42220","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on April 25, 2019. Storage deposit transferred from agreement A12-CT183190 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194830, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"169","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"157","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"158","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"168","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"169","room_code":"C45","retail_price":"1098.0","discounted_price":913,"location_id":"1"},{"room_id":"168","room_code":"C44","retail_price":"1098.0","discounted_price":913,"location_id":"1"},{"room_id":"158","room_code":"C34","retail_price":"1098.0","discounted_price":913,"location_id":"1"},{"room_id":"157","room_code":"C33","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"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":"2020-06-02","rent_from":"2020-06-02","rent_to":"2021-06-01","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A12-CT194830 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":41736,"final_order_total":41736,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,31254 054,42220","order_product":[],"pass":true}},"first_order_id":4830,"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> C45 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C44 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C34 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C33 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"64","total_discounted_price":"3478.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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",396,"NEW","A12-CT207858",4392,3478,0,0,"12","12",41736,41736,41736,"2020-05-15 16:55:35","0",null,null,null,"2020-06-02","2021-06-01","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A12-CT194830 to this agreement.\r\n","2020-06-02","64",0,null,0,"0","2","2020-05-15 16:55:34","2","2020-05-15 16:55:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,31254 054,42220","C170396","PERSONAL","Mr","x8CeprWZysqcYpxgLjWesyqaupoPDYvllxPJJPzGeQ4=","bXicfGTTHvCncWFCqwKkUQ==","","kXenyShHVJIBy0nJODcVP2bAt\/Sy48NOAqtif426b3ErmnDst7TJOh7roRGCfvAT5EPxepOq13KdaIVkY6W+pA==","PmiIv3X6c2FzP+hrtQJutA==","Kd\/M1orO0sg4maGXSphMfd8bje8T31yOfnTPa4Rkhdo=","X9kyhH\/uscdUsD+n3LywtQ==",null,1,4830]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","73","8","169","%","16.85",185.013,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","73","8","157","%","16.85",185.013,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","73","8","158","%","16.85",185.013,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","73","8","168","%","16.85",185.013,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","169","1098.0",913,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-02","2021-06-01","169"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","168","1098.0",913,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-02","2021-06-01","168"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","158","1098.0",913,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-02","2021-06-01","158"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 16:55:35","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":["7858","157","1098.0",913,"2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-02","2021-06-01","157"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 16:55:35","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":["7858",396,"SETTLED","A12-I208187","2020-05-15 16:55:34","2020-06-02","2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",7,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",8,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",9,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",10,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",11,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["8187","RENT","\u9810\u7e73\u79df\u91d1",12,3478,"MO","1",3478,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[41736,0,"8187"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 16:55:35","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":[396,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207832","2020-05-15 16:55:34",41736,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7832","DEPOSIT",null,"PAID","2020-05-15 16:55:34",0,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 16:55:35","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":["7832","INVOICE","8187","PAID","2020-05-15 16:55:34",41736,"2","2020-05-15 16:55:34","2","2020-05-15 16:55:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":851,"customer_code":"C180851","identity_type":"PERSONAL","identity_id":"P033059(4)","title":"Mr","lastname":"Kwok","firstname":"Chi Yeung","companyname":"","email":"god7eung@mail.com","tel":"63777237","address":"Room 312, 3\/F, Lei Yee House, Ap Lei Chau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-16","renew_room_key":"190,40466","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 13, 2019. Storage deposit transferred from agreement A14-CT194989 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196410, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"606","room_code":"M17","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-16","rent_from":"2020-05-16","rent_to":"2020-11-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A14-CT196410 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,40466","order_product":[],"pass":true}},"first_order_id":"3623","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> M17 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",851,"NEW","A14-CT207859",598,538,0,0,"6","6",3228,3228,3228,"2020-05-15 17:46:21","0",null,null,null,"2020-05-16","2020-11-15","6 months contract. Storage rental paid by bank transfer on May 15, 2020. Storage deposit transferred from agreement A14-CT196410 to this agreement.\r\n","2020-05-16","12",0,null,0,"0","2","2020-05-15 17:46:20","2","2020-05-15 17:46:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40466","C180851","PERSONAL","Mr","q7+8pGFchy5UIaxsB2syuA==","+pNULpsInm3siHASV0hIrg==","","hN8kcP0+I\/sY37kwIFkoufozVUHLTOd7OW0nydwRCJaAO+hD33wJBCKUOC+BBX7NK6OY8YG8ZnP4Qw2bXKWr\/ssh5+oEtdceFVbEVm2PBuo=","aS1vzUP\/M884bOyF1YOHtw==","qWmmaRe4+7gCaInnGaX5zc5SaS8RG7rSt7JWjJlWijA=","Z7hLIykoLq9XHINST0s8AQ==",null,1,"3623"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7859","606","598.0","598.00","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-16","2020-11-15","606"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7859",851,"SETTLED","A14-I208188","2020-05-15 17:46:20","2020-05-16","2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8188","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8188"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[851,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207833","2020-05-15 17:46:20",3228,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7833","DEPOSIT",null,"PAID","2020-05-15 17:46:20",0,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7833","INVOICE","8188","PAID","2020-05-15 17:46:20",3228,"2","2020-05-15 17:46:20","2","2020-05-15 17:46:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 17:54:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":708,"customer_code":"C180708","identity_type":"PERSONAL","identity_id":"P208633(A)","title":"Mr","lastname":"Lam","firstname":"Henry Hang Ling","companyname":"","email":"henrylam@email.com","tel":"62300702","address":"16D, Goldwin Heights, 2 Seymour Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2434.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-14","renew_room_key":"054,60414","renew_remark":"1 month contract. Storage rental $2434 paid by bank transfer on April 14, 2020. Remaining balance $66 will be transferred to next contract. Extra $32 from last contract will transfer to next contract. Storage deposit transferred from agreement A18-CT207362 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207622, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"868","room_code":"T12","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"867","room_code":"T11","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2434,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2434,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-14","rent_from":"2020-04-14","rent_to":"2020-05-13","delivery_service":"0","remark":"1 month contract. Storage rental $2400 paid by bank transfer on May 13, 2020. Remaining balance $34 transferred from agreement A18-CT207622. Storage deposit transferred from agreement A18-CT207622 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2434,"final_order_total":2434,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60414","order_product":[],"pass":true}},"first_order_id":"4723","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 \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> T12 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> T11 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2434.0","deposit":"0","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","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",708,"NEW","A18-CT207860",2580,2434,0,0,"1","1",2434,2434,2434,"2020-05-15 18:03:38","0",null,null,null,"2020-04-14","2020-05-13","1 month contract. Storage rental $2400 paid by bank transfer on May 13, 2020. Remaining balance $34 transferred from agreement A18-CT207622. Storage deposit transferred from agreement A18-CT207622 to this agreement.","2020-04-14","32",0,null,0,"0","2","2020-05-15 18:03:38","2","2020-05-15 18:03:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60414","C180708","PERSONAL","Mr","PTa9TkkuKfu4jwNnLRl7bA==","0JxYUqbNPOvgfMwVa0l0NA==","","FqEbl\/Vqia+apcWATmy0qI1jVSPGOQv+s8CLECBrdrOwYgMK2yudpo3PYRdJhmZi","NGbsOMu\/dtiprozEMsHWzw==","jy7Rom83Y2MCQ+LKg3+jO+YsY98Vm1g+iOp8lmmscAc=","ZEEfmQxu1lN8ppqH8XvTbg==",null,1,"4723"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","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":["7860","868","1290.0","1290.00","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-14","2020-05-13","868"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 18:03:38","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":["7860","867","1290.0","1290.00","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-14","2020-05-13","867"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 18:03:38","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":["7860",708,"SETTLED","A18-I208189","2020-05-15 18:03:38","2020-04-14","2","2020-05-15 18:03:38","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","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":["8189","RENT","\u9810\u7e73\u79df\u91d1",1,2434,"MO","1",2434,"2","2020-05-15 18:03:38","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2434,0,"8189"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 18:03:38","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":[708,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207834","2020-05-15 18:03:38",2434,"2","2020-05-15 18:03:38","2","2020-05-15 18:03:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","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":["7834","DEPOSIT",null,"PAID","2020-05-15 18:03:38",0,"2","2020-05-15 18:03:38","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:03:38","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":["7834","INVOICE","8189","PAID","2020-05-15 18:03:38",2434,"2","2020-05-15 18:03:38","2","2020-05-15 18:03:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:24:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29:35","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":"","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":564,"customer_code":"C170564","identity_type":"PERSONAL","identity_id":"K858586(5)","title":"Mrs","lastname":"Tsim","firstname":"Oi Ling Eva","companyname":"","email":"vava_822@yahoo.com.hk","tel":"96621261","address":"Room 3405,Tung Cheong House,Lei Tung Estate","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-16","renew_room_key":"054,44319","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on Apirl 11, 2019. Storage deposit transferred from agreement A12-CT183265 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194755, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"246","room_code":"D50","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.00","warehousing_date":"2020-05-16","rent_from":"2020-05-16","rent_to":"2021-06-15","delivery_service":"0","remark":"13 months contract. Special renewal offer, the 13th month free. Storage rental paid by PPS on May 15, 2020. Storage deposit transferred from agreement A12-CT194755 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,44319","order_product":[],"pass":true}},"first_order_id":4755,"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> D50 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",564,"NEW","A12-CT207861",998,899,0,0,"13","13",10788,11687,10788,"2020-05-15 18:29:36","0",null,null,null,"2020-05-16","2021-06-15","13 months contract. Special renewal offer, the 13th month free. Storage rental paid by PPS on May 15, 2020. Storage deposit transferred from agreement A12-CT194755 to this agreement.","2020-05-16","12",0,null,899,"899.00","2","2020-05-15 18:29:35","2","2020-05-15 18:29:35","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,44319","C170564","PERSONAL","Mrs","Z5EuoXqA6\/NVaWwxYy6qTw==","7ClxVYSMH+9BxulmlBMA0g==","","7DM07qlB1DhxsBccAB+tGBeFYXmnfiGlzJKRtOA+xAQc39RAt1iI5RvLFvAhKrgV","Qb1OUGZcjD7UCCNrHdybZQ==","r5exFATla+I8j\/ZFxt2QlZYiBPYvya6kf22GJ6UgCEU=","+yP2gVaTJEl+lobf57NMPQ==",null,1,4755]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["7861","246","998.0","998.00","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["2020-05-16","2021-06-15","246"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 18:29: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":["7861",564,"SETTLED","A12-I208190","2020-05-15 18:29:35","2020-05-16","2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["8190","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8190"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 18:29: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":[564,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207835","2020-05-15 18:29:35",10788,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["7835","DEPOSIT",null,"PAID","2020-05-15 18:29:35",0,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:29: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":["7835","INVOICE","8190","PAID","2020-05-15 18:29:35",10788,"2","2020-05-15 18:29:35","2","2020-05-15 18:29:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1064,"customer_code":"C181064","identity_type":"PERSONAL","identity_id":"D562505(0)","title":"Mr","lastname":"Wong","firstname":"Kwong Lui","companyname":"","email":"klwongsir@yahoo.com.hk","tel":"90523646","address":"22B, Tower 1, Euston Court, 6 Park Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2191.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"0012434793","renew_remark":"6 months contract. Storage rental paid by PPS on November 29, 2019. Storage deposit $4868 transferred from agreement A05-CT183561 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196566, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1117","room_code":"A05-115","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"},{"room_id":"1116","room_code":"A05-114","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2191,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":26292,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2191.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-06-30","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on May 15, 2020. Storage deposit $4868 transferred from agreement A05-CT196566 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":2191,"order_total":28483,"final_order_total":26292,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012434793","order_product":[],"pass":true}},"first_order_id":"3561","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 \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-115 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A05-114 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2191.00","deposit":"0.00","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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",1064,"NEW","A05-CT207862",2580,2191,0,0,"13","13",26292,28483,26292,"2020-05-15 18:34:43","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on May 15, 2020. Storage deposit $4868 transferred from agreement A05-CT196566 to this agreement. \r\n","2020-06-01","32",0,null,2191,"2191.00","2","2020-05-15 18:34:43","2","2020-05-15 18:34:43","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012434793","C181064","PERSONAL","Mr","BWIpx5jk+8iX1iiIfaHJ4Q==","hULSwM2MvFtpeV9\/z+er8Q==","","77cnAHKn\/Xd2qqgeE5QIneor+Gss8mOfWi59kOmP50aAHeacrsXTf8sxtLuJSzXPzi0N9kmLWWcdibx59r08Wg==","6LmyWoznF296dyX2RKUSRg==","iMpplbN6sO\/TERv6QU6cT+I3+wEL7Por8jbBS3Mp6vg=","wdHlUszaVb2ebJResGgf8Q==",null,1,"3561"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["7862","1117","1290.0","1290.00","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-06-30","1117"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 18:34:43","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":["7862","1116","1290.0","1290.00","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-06-30","1116"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-15 18:34:43","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":["7862",1064,"SETTLED","A05-I208191","2020-05-15 18:34:43","2020-06-01","2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",3,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",4,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",5,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",6,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",7,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",8,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",9,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",10,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",11,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",12,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["8191","RENT","\u9810\u7e73\u79df\u91d1",13,2191,"MO","1",2191,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26292,0,"8191"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-15 18:34:43","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":[1064,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207836","2020-05-15 18:34:43",26292,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["7836","DEPOSIT",null,"PAID","2020-05-15 18:34:43",0,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-15 18:34:43","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":["7836","INVOICE","8191","PAID","2020-05-15 18:34:43",26292,"2","2020-05-15 18:34:43","2","2020-05-15 18:34:43"]},"data_before":[],"data_after":[],"step":1} *****