{"created_at":"2020-04-22 09:32:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 10:08:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 10:12:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 10:23:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 10:27:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":"filter1=0&filter2=7673&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":475,"customer_code":"C170475","identity_type":"PERSONAL","identity_id":"P780082(0)","title":"Ms","lastname":"Shaw","firstname":"Alison Prudence","companyname":"","email":"APSHAW29@gmail.com","tel":"98342184","address":"2\/F, No. 7, Mo TaT New Village, Sok Kwo Wan ,Lamma sland","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":"6","renew_warehousing_date":"2020-04-26","renew_room_key":"136,45736","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 8, 2019. Storage deposit transferred from agreement A14-CT195539 to this agreement.
\u820a\u5408\u7d04\u7de8\u865f: A14-CT195539, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196326, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"647","room_code":"M58","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-26","rent_from":"2020-04-26","rent_to":"2020-10-25","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 22, 2020. Storage deposit transferred from agreement A14-CT196326 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,45736","order_product":[],"pass":true}},"first_order_id":"4268","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>
M58 <\/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":"12","total_discounted_price":"899.0","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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","2",475,"NEW","A14-CT207697",998,899,0,0,"6","6",5394,5394,5394,"2020-04-22 11:00:36","0",null,null,null,"2020-04-26","2020-10-25","6 months contract. Storage rental paid by bank transfer on April 22, 2020. Storage deposit transferred from agreement A14-CT196326 to this agreement.\r\n\r\n","2020-04-26","12",0,null,0,"0","2","2020-04-22 11:00:35","2","2020-04-22 11:00:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,45736","C170475","PERSONAL","Ms","rhwI88t2piURgxgvkDCXDw==","zxtkDYAKMKQyZOZ+rDMH9w==","","IiNHMsYeE2ruFky2vbzd2ly2AHF3MwfKSR6lEXxAtthI11oGYW6Q4c\/ew0GPtTYkke1vxEwNikZEk0H17jWgAg==","xPZU7GHyadIL6UqeWZ+SuA==","9T6lMttC\/KPb9JhmOdhxsXd3eIgv+PxTRH+PJXuWupY=","\/HucciQpcLX9Sg1HfZXfHQ==",null,1,"4268"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["7697","647","998.0","998.00","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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-04-26","2020-10-25","647"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 11:00: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":["7697",475,"SETTLED","A14-I208025","2020-04-22 11:00:35","2020-04-26","2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["8025","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"8025"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-22 11:00: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":[475,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207671","2020-04-22 11:00:35",5394,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["7671","DEPOSIT",null,"PAID","2020-04-22 11:00:35",0,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:00: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":["7671","INVOICE","8025","PAID","2020-04-22 11:00:35",5394,"2","2020-04-22 11:00:35","2","2020-04-22 11:00:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:42:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 11:50:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:01:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:19:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:12","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=0&filter2=7673&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":364,"customer_code":"C170364","identity_type":"PERSONAL","identity_id":"D349803(5)","title":"Ms","lastname":"Ng","firstname":"Po Ling Nora","companyname":"","email":"nora5688@gmail.com","tel":"51841487","address":"Flat 4, 23\/F, On Fai Hse, Yue Fai Crt, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1607.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-19","renew_room_key":"052,45617","renew_remark":"6 months contract. Storage rental paid by EPS on October 16, 2019. Storage deposit transferred from agreement A14-CT194810 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196157, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"746","room_code":"O22","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"735","room_code":"O11","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1607,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9642,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-19","rent_from":"2020-04-19","rent_to":"2020-10-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 20, 2020. Storage deposit transferred from agreement A14-CT196157 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":9642,"final_order_total":9642,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,45617","order_product":[],"pass":true}},"first_order_id":"4810","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> O22 <\/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> O11 <\/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":"28","total_discounted_price":"1607.0","deposit":"0.00","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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",364,"NEW","A14-CT207698",2096,1607,0,0,"6","6",9642,9642,9642,"2020-04-22 12:27:13","0",null,null,null,"2020-04-19","2020-10-18","6 months contract. Storage rental paid by bank transfer on April 20, 2020. Storage deposit transferred from agreement A14-CT196157 to this agreement.\r\n\r\n","2020-04-19","28",0,null,0,"0","2","2020-04-22 12:27:12","2","2020-04-22 12:27:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,45617","C170364","PERSONAL","Ms","SG3XlvKRJhqTWbtPrgNG2Q==","cxr02xsD1tXvJ4ihJHZKWw==","","uSFABjPw5cLvIn5z\/di4YfU5AU7rXVNPD+PGBHB87\/5JzgQOjkJxHEQzQVRgnl7Fr47upOwJwFUgIllhOSLh9A==","kNgebGQzCww9aYPl0UnnZA==","DnaEq2t9UobD+C7JAiKNGzvfRBXOpSTbMu4EvrJaBYg=","KJla056HAbub872wB4L85Q==",null,1,"4810"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["7698","746","1098.0","1098.00","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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-19","2020-10-18","746"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:27:13","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":["7698","735","998.0","998.00","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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-19","2020-10-18","735"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:27:13","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":["7698",364,"SETTLED","A14-I208026","2020-04-22 12:27:12","2020-04-19","2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",1,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",2,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",3,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",4,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",5,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["8026","RENT","\u9810\u7e73\u79df\u91d1",6,1607,"MO","1",1607,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9642,0,"8026"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-22 12:27:13","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":[364,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207672","2020-04-22 12:27:12",9642,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["7672","DEPOSIT",null,"PAID","2020-04-22 12:27:12",0,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:27:13","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":["7672","INVOICE","8026","PAID","2020-04-22 12:27:12",9642,"2","2020-04-22 12:27:12","2","2020-04-22 12:27:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:34:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:47:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201567","PERSONAL","Mr","o2EIBQ5L0V+W9LA6gIA5vw==","6iEwAEulQQ5kKFL3ldVmmg==","","ySu6obc\/oEYd7heM0CBoIA==","KWdojZtS16kg4xegG9NKSLpWrDnAbg3eJaBRSO9EugI=","oA+\/aueZVHwRAIN\/ukTH4SJLXrUROhNys\/4gQU+gJ32FyAEexhxXbeSRVMwSPKs8xYctnucrNg8zSRNGwYxJkUQ\/70NP3Z+Sf2EFlrlf188\/L0xi9AR8cQTTYmuUkekq","4UGQDkj4M+VEFo9bu7iH1Q==","","KWdojZtS16kg4xegG9NKSLpWrDnAbg3eJaBRSO9EugI=","yrZEuteRAPjAq2E4FTabEw==","2","2020-04-22 12:47:44","2","2020-04-22 12:47:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:36","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=%E6%96%B0%E5%A2%9E%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1377","master_room_id":"169","room_code":"C15-071"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-082 <\/td>\n\t\t\t\t\t 4X3X6.5 <\/td>\n\t\t\t\t\t $810.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-081 <\/td>\n\t\t\t\t\t 4X3X6.5 <\/td>\n\t\t\t\t\t $810.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-080 <\/td>\n\t\t\t\t\t 4X3X6.5 <\/td>\n\t\t\t\t\t $810.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-079 <\/td>\n\t\t\t\t\t 4X3X6.5 <\/td>\n\t\t\t\t\t $810.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-074 <\/td>\n\t\t\t\t\t 4X3.7X6.5 <\/td>\n\t\t\t\t\t $938.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-073 <\/td>\n\t\t\t\t\t 4X3.7X6.5 <\/td>\n\t\t\t\t\t $938.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-072 <\/td>\n\t\t\t\t\t 4X3.7X6.5 <\/td>\n\t\t\t\t\t $938.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-071 <\/td>\n\t\t\t\t\t 4X3.7X6.5 <\/td>\n\t\t\t\t\t $938.00 <\/td>\n\t\t\t\t N\/A <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"E527486(2)","title":"Mr","lastname":"WANG","firstname":"Joseph Gregory","companyname":"","email":"Josephgwang@gmail.com","tel":"90280002","address":"Flat C, 10\/F Clear View, 15 Middle Lane Midvale Village, Discovery Bay, Lantau Island, HK","pass":true,"customer_id":"1567","customer_code":"C201567","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1388","room_code":"C15-082","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1387","room_code":"C15-081","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1386","room_code":"C15-080","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1385","room_code":"C15-079","retail_price":"810.0","discounted_price":"810.00","location_id":"6"},{"room_id":"1380","room_code":"C15-074","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1379","room_code":"C15-073","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1378","room_code":"C15-072","retail_price":"938.0","discounted_price":"938.00","location_id":"6"},{"room_id":"1377","room_code":"C15-071","retail_price":"938.0","discounted_price":"938.00","location_id":"6"}],"roughly_size":"104.00","total_retail_price":6992,"total_discounted_price":4715,"deposit":5238,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":50038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"11780.00","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-04-30","delivery_service":"0","remark":"12 months contract. Special offer the 11th & 12th months free and extra 5% discount. Storage rental and deposit paid by bank transfer on Apr 21,2020. Smart card was given on Apr 22,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":11780,"order_total":61818,"final_order_total":50038,"location_id":"6","branch_id":"3","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"104.00","total_discounted_price":"4715.00","deposit":"5238.00","total_retail_price":"6992.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1567","NEW","C15-CT207699",6992,4715,5238,0,"12","12",50038,61818,50038,"2020-04-22 12:59:37","0",null,null,null,"2020-05-01","2021-04-30","12 months contract. Special offer the 11th & 12th months free and extra 5% discount. Storage rental and deposit paid by bank transfer on Apr 21,2020. Smart card was given on Apr 22,2020.","2020-05-01","104.00",0,null,11780,"11780.00","2","2020-04-22 12:59:36","2","2020-04-22 12:59:36","BANKIN","","","","BANKIN","","","",null,0,"","C201567","PERSONAL","Mr","o2EIBQ5L0V+W9LA6gIA5vw==","6iEwAEulQQ5kKFL3ldVmmg==","","oA+\/aueZVHwRAIN\/ukTH4SJLXrUROhNys\/4gQU+gJ32FyAEexhxXbeSRVMwSPKs8xYctnucrNg8zSRNGwYxJkUQ\/70NP3Z+Sf2EFlrlf188\/L0xi9AR8cQTTYmuUkekq","ySu6obc\/oEYd7heM0CBoIA==","KWdojZtS16kg4xegG9NKSLpWrDnAbg3eJaBRSO9EugI=","4UGQDkj4M+VEFo9bu7iH1Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1388","810.0","810.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1388"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1387","810.0","810.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1387"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1386","810.0","810.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1386"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1385","810.0","810.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1385"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1380","938.0","938.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1380"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1379","938.0","938.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1379"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1378","938.0","938.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1378"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1377","938.0","938.00","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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-01","2021-04-30","1377"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 12:59:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7699","C15-D205382","PAID",5238,0,"2021-04-30","2020-04-22 12:59:36","2020-04-22 12:59:36","2","2020-04-22 12:59:36","2","2020-04-22 12:59:36","1567"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["7699","1567","SETTLED","C15-I208027","2020-04-22 12:59:36","2020-05-01","2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,2365,"MO","1",2365,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",4,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",5,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",6,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",7,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",8,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",9,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",10,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",11,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["8027","RENT","\u9810\u7e73\u79df\u91d1",12,4715,"MO","1",4715,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[44800,0,"8027"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-22 12:59:37","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":["1567","BANKIN","","","","BANKIN","","","","PAID","P207673","2020-04-22 12:59:36",50038,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["7673","DEPOSIT","5382","PAID","2020-04-22 12:59:36",5238,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 12:59:37","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":["7673","INVOICE","8027","PAID","2020-04-22 12:59:36",44800,"2","2020-04-22 12:59:36","2","2020-04-22 12:59:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 13:29:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 13:56:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":375,"customer_code":"C170375","identity_type":"PERSONAL","identity_id":"G461201(8)","title":"Ms","lastname":"Ng","firstname":"Yuk Mui Shirley","companyname":"","email":"shirleymng@yahoo.com.hk","tel":"97016313","address":"Flat 11,7\/F,CHI TAK HOUSE,LUNG TAK COURT,STANLEY ","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-26","renew_room_key":"055,32428","renew_remark":"6 months contract. Storage rental paid by EPS on October 22, 2019. Storage deposit transferred from agreement A14-CT194808 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196209, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"504","room_code":"K41","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16296,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-26","rent_from":"2020-04-26","rent_to":"2021-04-25","delivery_service":"0","remark":"12 months contract. Storage rental paid by EPS on April 22, 2020. Storage deposit transferred from agreement A14-CT196209 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":16296,"final_order_total":16296,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32428","order_product":[],"pass":true}},"first_order_id":"4808","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> K41 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1358.00","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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",375,"NEW","A14-CT207700",1768,1358,0,0,"12","12",16296,16296,16296,"2020-04-22 15:02:07","0",null,null,null,"2020-04-26","2021-04-25","12 months contract. Storage rental paid by EPS on April 22, 2020. Storage deposit transferred from agreement A14-CT196209 to this agreement.","2020-04-26","24",0,null,0,"0","2","2020-04-22 15:02:07","2","2020-04-22 15:02:07","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,32428","C170375","PERSONAL","Ms","22FY\/7bwwZwxQt4rgpbZrQ==","cxr02xsD1tXvJ4ihJHZKWw==","","FB7ObNwASQyD7xGprnK9C+oagM8a5jWGa\/ydUkx0OURMyz+JxqZ+t9ViN+rVW5LXqKECvtMWiYisoObYxTwtiw==","sKBrnpu1ddMg4GsEei7IeQ==","L+lTOAH4d+Oyc6XKLKULeE3jjdA\/LSy1jpcZwgEO12o=","T5v\/56gYcqN\/Qp\/1KI0fDg==",null,1,"4808"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["7700","504","1768.0","1768.00","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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-26","2021-04-25","504"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-22 15:02:07","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":["7700",375,"SETTLED","A14-I208028","2020-04-22 15:02:07","2020-04-26","2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",7,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",8,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",9,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",10,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",11,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["8028","RENT","\u9810\u7e73\u79df\u91d1",12,1358,"MO","1",1358,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16296,0,"8028"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-22 15:02:07","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":[375,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207674","2020-04-22 15:02:07",16296,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["7674","DEPOSIT",null,"PAID","2020-04-22 15:02:07",0,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 15:02:07","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":["7674","INVOICE","8028","PAID","2020-04-22 15:02:07",16296,"2","2020-04-22 15:02:07","2","2020-04-22 15:02:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 16:18:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 16:43:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 19:03:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 19:06:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-22 19:15:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****