{"created_at":"2020-06-26 10:20:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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=2&filter2=1277&filter3=undefined","floor_plan_rent_room":[{"room_id":"1095","master_room_id":"117","room_code":"A05-093"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t
\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\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
\r\n\t\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>
\r\n\t\t\t\t\t
A05-093
<\/td>\r\n\t\t\t\t\t
4X6X7
<\/td>\r\n\t\t\t\t\t
$1857.00
<\/td>\r\n\t\t\t\t
N\/A <\/td>
\u9810\u4ed83\u500b\u6708
% \u6298\u6263 <\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"C561384(A)","title":"Ms","lastname":"WAN","firstname":"Yuk Yee","companyname":"","email":"wanyy@netvigator.com","tel":"91029225","address":"Room 6, 9\/F, Block D, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1095","room_code":"A05-093","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":3714,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":22782,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2668.00","warehousing_date":"2020-07-11","rent_from":"2020-07-11","rent_to":"2021-08-10","delivery_service":"0","remark":"13 months contract. Special rent now offer 5% discount. Storage rental and deposit paid by EPS on June 26, 2020. Smartcard provided on June 26, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2668,"order_total":25450,"final_order_total":22782,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012388447","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1672.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201642","PERSONAL","Ms","qCaCoaZxbXs6wrNp+i3+hA==","2+HhFlKBGl3L\/0uDqNi5+g==","","mNfh0iYHPn1hyIF722pSOQ==","P7T3vCPPJTJb9xODBIuA8yD8DJ2TDIRfKy1DZ+o1nVk=","Vfx1vJP45FbbWD11yno8ST8G9OT1A9GwNaABnQzFItDs8d2YIh\/kRYn33YL0bGbMyHUiZXjWwJH5apJBAnodFg==","ON8KdzSwT6Jsn1csLG+FPw==",null,"P7T3vCPPJTJb9xODBIuA8yD8DJ2TDIRfKy1DZ+o1nVk=","GROif+oR0\/ynFQ+FKpx+ag==","2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1642,"NEW","A05-CT208220",1857,1672,3714,0,"13","13",22782,25450,22782,"2020-06-26 10:30:36","0",null,null,null,"2020-07-11","2021-08-10","13 months contract. Special rent now offer 5% discount. Storage rental and deposit paid by EPS on June 26, 2020. Smartcard provided on June 26, 2020. ","2020-07-11","24",0,null,2668,"2668.00","2","2020-06-26 10:30:35","2","2020-06-26 10:30:35","EPS","","","","EPS","","","",null,0,"0012388447","C201642","PERSONAL","Ms","qCaCoaZxbXs6wrNp+i3+hA==","2+HhFlKBGl3L\/0uDqNi5+g==","","Vfx1vJP45FbbWD11yno8ST8G9OT1A9GwNaABnQzFItDs8d2YIh\/kRYn33YL0bGbMyHUiZXjWwJH5apJBAnodFg==","mNfh0iYHPn1hyIF722pSOQ==","P7T3vCPPJTJb9xODBIuA8yD8DJ2TDIRfKy1DZ+o1nVk=","ON8KdzSwT6Jsn1csLG+FPw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8220","1095","1857.0","1857.00","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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-07-11","2021-08-10","1095"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 10:30:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8220","A05-D205502","PAID",3714,0,"2021-08-10","2020-06-26 10:30:35","2020-06-26 10:30:35","2","2020-06-26 10:30:35","2","2020-06-26 10:30:35",1642]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8220",1642,"SETTLED","A05-I208549","2020-06-26 10:30:35","2020-07-11","2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,676,"MO","1",676,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8549","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19068,0,"8549"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 10:30: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":[1642,"EPS","","","","EPS","","","","PAID","P208192","2020-06-26 10:30:35",22782,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8192","DEPOSIT","5502","PAID","2020-06-26 10:30:35",3714,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:30: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":["8192","INVOICE","8549","PAID","2020-06-26 10:30:35",19068,"2","2020-06-26 10:30:35","2","2020-06-26 10:30:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 10:48:22","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0012388447","13 months contract. Special offer the 13th month free. Special rent now offer 5% discount . Storage rental and deposit paid by EPS on June 26, 2020. Smartcard provided on June 26, 2020. ","2020-06-26 10:48:22","2","2+HhFlKBGl3L\/0uDqNi5+g==","qCaCoaZxbXs6wrNp+i3+hA==","P7T3vCPPJTJb9xODBIuA8yD8DJ2TDIRfKy1DZ+o1nVk=","mNfh0iYHPn1hyIF722pSOQ==","Vfx1vJP45FbbWD11yno8ST8G9OT1A9GwNaABnQzFItDs8d2YIh\/kRYn33YL0bGbMyHUiZXjWwJH5apJBAnodFg==",8220]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 13:44:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 14:40:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t
\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\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
\r\n\t\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>
\r\n\t\t\t\t\t
A05-170
<\/td>\r\n\t\t\t\t\t
4X6X7
<\/td>\r\n\t\t\t\t\t
$1857.00
<\/td>\r\n\t\t\t\t
N\/A <\/td>
\u9810\u4ed83\u500b\u6708
% \u6298\u6263 <\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"P030927(7)","title":"Ms","lastname":"Chia","firstname":"Jacqueline Brigitte","companyname":"","email":"jackie_tjia@hotmail.com","tel":"97552210","address":"G\/F, Flat A, Albany Court, 5`1-53 Bisney Rd, Pok Fu Lam","pass":true,"customer_id":"780","customer_code":"C180780","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1172","room_code":"A05-170","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":3714,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11518,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3338.00","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-12-31","delivery_service":"0","remark":"6 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by EPS on June 26, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3338,"order_total":14856,"final_order_total":11518,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012488908","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1857.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","780","NEW","A05-CT208221",1857,1857,3714,0,"6","6",11518,14856,11518,"2020-06-26 15:18:08","0",null,null,null,"2020-07-01","2020-12-31","6 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by EPS on June 26, 2020. ","2020-07-01","24",0,null,3338,"3338.00","2","2020-06-26 15:18:08","2","2020-06-26 15:18:08","EPS","","","","EPS","","","",null,0,"'0012488908","C180780","PERSONAL","Ms","1p7bDYDtTmM07v7ySaTkXOrEUVbL32JckPPqsCIbv\/w=","gqpBPhMXyxdjxQDjxaJzUw==","","vHATtF\/CIkXJXwV7irRZIMik8cgv4FFFjnDOP9GLR95qpvw7qcrDzBySpWQmcW5kAPLAacaoCktKa2J57XXg+A==","\/cSBTdAZw3bbIY7dhadNDA==","EBpA6lMjhOOSeSc7CI4FDz7o0RRi+YJRUiB6C6GSE\/M=","2VksV5Z1w1U+T3QEB+uYFQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8221","1172","1857.0","1857.00","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","1172"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 15:18:08","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":["8221","A05-D205503","PAID",3714,0,"2020-12-31","2020-06-26 15:18:08","2020-06-26 15:18:08","2","2020-06-26 15:18:08","2","2020-06-26 15:18:08","780"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8221","780","SETTLED","A05-I208550","2020-06-26 15:18:08","2020-07-01","2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,376,"MO","1",376,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u9810\u7e73\u79df\u91d1",3,1857,"MO","1",1857,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u9810\u7e73\u79df\u91d1",4,1857,"MO","1",1857,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u9810\u7e73\u79df\u91d1",5,1857,"MO","1",1857,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8550","RENT","\u9810\u7e73\u79df\u91d1",6,1857,"MO","1",1857,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7804,0,"8550"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["780","EPS","","","","EPS","","","","PAID","P208193","2020-06-26 15:18:08",11518,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8193","DEPOSIT","5503","PAID","2020-06-26 15:18:08",3714,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:18:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8193","INVOICE","8550","PAID","2020-06-26 15:18:08",7804,"2","2020-06-26 15:18:08","2","2020-06-26 15:18:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:38:59","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","191,03248; 191,05539","13 months contract. Special offer renewal price list 50% off for the first 3 months and the 13th month free. Deposit $500 paid by PayMe on June 09,2020. The balance of storage rental and deposit $11548 paid by cash on 11JUNE2020. Smart card will provide later. Padlock provided on 11JUNE2020.","2020-06-26 15:38:59","2","iAKb9Y+6DFOZKg+8+iuRrA==","tnBXsw2iRVZmC7agW3nxRw==","f0RgO2mVVUDM\/nLFDmD8xA==","WAeDQGyJs5GONb+7AH7S389l4t3nQQAFJhSqtMlAokLkA1xUmzwWL8iGIgTylkbpu5+sxqehDBmtQ82GdRXG0A==",8106]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:42:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 15:43:06","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":["C201643","PERSONAL","Mr","ufXvNRUeTRljqgACPZsDTw==","NX9r7kCwACTU3C1ZLG97rA==","","Bhl\/F5xZjTsc+rNTJiCLhA==",null,"6F88GPSmmnGXsPk2ZyJKWg==","GdyuY9yXus+qmbYp1EHImQ==","",null,"9+RGbnlqqAXQ\/oLBxjS51w==","2","2020-06-26 15:43:03","2","2020-06-26 15:43:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 18:13:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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=3&filter2=1643","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"337","master_room_id":"8","room_code":"F22"},{"room_id":"326","master_room_id":"6","room_code":"F11"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t
\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\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
\r\n\t\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>
\r\n\t\t\t\t\t
F22
<\/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
F11
<\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z035461(A)","title":"Mr","lastname":"WONG","firstname":"Chung Hang","companyname":"","email":"fred.ch.wong@gmail.com","tel":"96462673","address":"5\/F, Block F, 3 Robinson Road, Mid-Levels, Hong Kong","pass":true,"customer_id":"1640","customer_code":"C201640","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"326","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"1098.00","disocunted_price":"988.60","discount":"9.96","monthly_deduct":109.3608,"room_id":"337","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"337","room_code":"F22","retail_price":"1098.0","discounted_price":988.6,"location_id":"1"},{"room_id":"326","room_code":"F11","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":4116,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12759,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3705.00","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2020-12-25","delivery_service":"0","remark":"6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $10964 paid by bank transfer on June 24, 2020. Remaining balance $1795paid by cash on June 26, 2020. Smart card and padlock will be provided before move in.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3705,"order_total":16464,"final_order_total":12759,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26625","order_product":[],"pass":true}},"roughly_size":"28","total_discounted_price":"2058.00","deposit":"4116.00","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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` = ?","parameters":["1","1","1","1640","NEW","A12-CT208222",2096,2058,4116,0,"6","6",12759,16464,12759,"2020-06-26 19:12:35","0",null,null,null,"2020-06-26","2020-12-25","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $10964 paid by bank transfer on June 24, 2020. Remaining balance $1795paid by cash on June 26, 2020. Smart card and padlock will be provided before move in.","2020-06-26","28",0,null,3705,"3705.00","2","2020-06-26 19:12:34","2","2020-06-26 19:12:34","EPS","","","","EPS","","","",null,0,"190,26625","C201640","PERSONAL","Mr","npiHMr\/Z9wXMUADks\/OtaA==","ddrfzAYTmkL\/QNu3psjONQ==","","739VEtzXtsJL\/wX6LudeCPNg\/zB5HH6CRmjt\/TJOwoC7\/7AShl1K\/kmn22gVYvnwUozDNgZ6lDR6IsYcT7NYbw==","eY\/pJrM0jQu7tDmE3HqRBg==","kRXc4GFTsqnGJH4ZDDy4UXEciEAv+opBB\/DLhhQaunY=","Ebir7AnKDvQ\/BwoiivnURA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8222","70","6","326","%","9.96",99.4008,"2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8222","70","6","337","%","9.96",109.3608,"2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8222","337","1098.0",988.6,"2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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-26","2020-12-25","337"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:12: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":["8222","326","998.0",898.6,"2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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-26","2020-12-25","326"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:12:35","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":["8222","A12-D205504","PAID",4116,0,"2020-12-25","2020-06-26 19:12:34","2020-06-26 19:12:34","2","2020-06-26 19:12:34","2","2020-06-26 19:12:34","1640"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8222","1640","SETTLED","A12-I208551","2020-06-26 19:12:34","2020-06-26","2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,411,"MO","1",411,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u9810\u7e73\u79df\u91d1",3,2058,"MO","1",2058,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u9810\u7e73\u79df\u91d1",4,2058,"MO","1",2058,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u9810\u7e73\u79df\u91d1",5,2058,"MO","1",2058,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8551","RENT","\u9810\u7e73\u79df\u91d1",6,2058,"MO","1",2058,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8643,0,"8551"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:12: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":["1640","EPS","","","","EPS","","","","PAID","P208194","2020-06-26 19:12:34",12759,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8194","DEPOSIT","5504","PAID","2020-06-26 19:12:34",4116,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:12: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":["8194","INVOICE","8551","PAID","2020-06-26 19:12:34",8643,"2","2020-06-26 19:12:34","2","2020-06-26 19:12:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:27:33","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190,26625","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by bank transfer on June 24, 2020. Smart card and padlock will be provided before move in.","2020-06-26 19:27:32","2","ddrfzAYTmkL\/QNu3psjONQ==","npiHMr\/Z9wXMUADks\/OtaA==","kRXc4GFTsqnGJH4ZDDy4UXEciEAv+opBB\/DLhhQaunY=","eY\/pJrM0jQu7tDmE3HqRBg==","739VEtzXtsJL\/wX6LudeCPNg\/zB5HH6CRmjt\/TJOwoC7\/7AShl1K\/kmn22gVYvnwUozDNgZ6lDR6IsYcT7NYbw==",8215]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:29:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:41","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 23, 2020. Storage deposit transferred from agreement A14-CT207476 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207709, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-07-23","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on May 18, 2020 and June 25, 2020. Storage deposit transferred from agreement A14-CT207709 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
M36
<\/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":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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",469,"NEW","A14-CT208223",598,598,0,0,"2","2",1196,1196,1196,"2020-06-26 19:30:42","0",null,null,null,"2020-05-24","2020-07-23","2 months contract. Storage rental paid by bank transfer on May 18, 2020 and June 25, 2020. Storage deposit transferred from agreement A14-CT207709 to this agreement.\r\n","2020-05-24","12",0,null,0,"0","2","2020-06-26 19:30:41","2","2020-06-26 19:30:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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":["8223","625","598.0","598.00","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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","2020-07-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:30:42","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":["8223",469,"SETTLED","A14-I208552","2020-06-26 19:30:41","2020-05-24","2","2020-06-26 19:30:41","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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":["8552","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-26 19:30:41","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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":["8552","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-06-26 19:30:41","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"8552"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:30:42","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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208195","2020-06-26 19:30:41",1196,"2","2020-06-26 19:30:41","2","2020-06-26 19:30:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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":["8195","DEPOSIT",null,"PAID","2020-06-26 19:30:41",0,"2","2020-06-26 19:30:41","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:30:42","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":["8195","INVOICE","8552","PAID","2020-06-26 19:30:41",1196,"2","2020-06-26 19:30:41","2","2020-06-26 19:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:02","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","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-06-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207574 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208063, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"32","room_code":"A32","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"31","room_code":"A31","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"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-06-06","rent_from":"2020-06-06","rent_to":"2020-07-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A12-CT208063 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":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4781","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
A32
<\/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
A31
<\/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":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",263,"NEW","A12-CT208224",2196,2318,0,0,"1","1",2318,2318,2318,"2020-06-26 19:33:03","0",null,null,null,"2020-06-06","2020-07-05","1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A12-CT208063 to this agreement.\r\n","2020-06-06","32",0,null,0,"0","2","2020-06-26 19:33:02","2","2020-06-26 19:33:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4781"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8224","32","1098.0","1098.00","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-06","2020-07-05","32"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8224","31","1098.0","1098.00","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-06","2020-07-05","31"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8224",263,"SETTLED","A12-I208553","2020-06-26 19:33:02","2020-06-06","2","2020-06-26 19:33:02","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8553","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-06-26 19:33:02","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"8553"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208196","2020-06-26 19:33:02",2318,"2","2020-06-26 19:33:02","2","2020-06-26 19:33:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8196","DEPOSIT",null,"PAID","2020-06-26 19:33:02",0,"2","2020-06-26 19:33:02","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:33:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8196","INVOICE","8553","PAID","2020-06-26 19:33:02",2318,"2","2020-06-26 19:33:02","2","2020-06-26 19:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1220,"customer_code":"C191220","identity_type":"PERSONAL","identity_id":"R119900(4)","title":"Mr","lastname":"LEUNG","firstname":"Wai Hung","companyname":"","email":null,"tel":"59386116","address":"\u65b0\u754c\u5c6f\u9580\u5927\u8208\u82b1\u57121\u671f2\u5ea79\u6a13G\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207575 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208064, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"149","room_code":"C25","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-06","rent_from":"2020-06-06","rent_to":"2020-07-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A12-CT208064 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4572","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
C25
<\/td>\r\n\t\t\t\t\t
4X4X8
<\/td>\r\n\t\t\t\t\t
$1098.00
<\/td>\r\n\t\t\t\t
N\/A <\/td>
\u9810\u4ed86\u500b\u6708
% \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708
% \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708
% \u6298\u6263 <\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1228.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1220,"NEW","A12-CT208225",1098,1228,0,0,"1","1",1228,1228,1228,"2020-06-26 19:34:16","0",null,null,null,"2020-06-06","2020-07-05","1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A12-CT208064 to this agreement.\r\n","2020-06-06","16",0,null,0,"0","2","2020-06-26 19:34:16","2","2020-06-26 19:34:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C191220","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","yXKc2lCF323ApRADrjNaSg==","","kB3ZkLOEsqrfGlmYGehYoS1RHUa4+htDrEhnq1OyQOZf8ydcmD1ve7Z29T4bDE82","UuUIwTJb9gH2x8g8+PEtTA==",null,"dhuboonMisA+jeGDyP70SA==",null,1,"4572"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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":["8225","149","1098.0","1098.00","2","2020-06-26 19:34:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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-06-06","2020-07-05","149"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:34: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":["8225",1220,"SETTLED","A12-I208554","2020-06-26 19:34:16","2020-06-06","2","2020-06-26 19:34:16","2","2020-06-26 19:34:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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":["8554","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-06-26 19:34:16","2","2020-06-26 19:34:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"8554"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:34: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":[1220,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208197","2020-06-26 19:34:16",1228,"2","2020-06-26 19:34:16","2","2020-06-26 19:34:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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":["8197","DEPOSIT",null,"PAID","2020-06-26 19:34:16",0,"2","2020-06-26 19:34:16","2","2020-06-26 19:34:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:34: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":["8197","INVOICE","8554","PAID","2020-06-26 19:34:16",1228,"2","2020-06-26 19:34:16","2","2020-06-26 19:34:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:14","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-04","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207576 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208067, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"688","room_code":"N05","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-04","rent_from":"2020-06-04","rent_to":"2020-07-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A14-CT208067 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4783","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
N05
<\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",263,"NEW","A14-CT208226",598,598,0,0,"1","1",598,598,598,"2020-06-26 19:35:15","0",null,null,null,"2020-06-04","2020-07-03","1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A14-CT208067 to this agreement.\r\n","2020-06-04","12",0,null,0,"0","2","2020-06-26 19:35:14","2","2020-06-26 19:35:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4783"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8226","688","598.0","598.00","2","2020-06-26 19:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-04","2020-07-03","688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8226",263,"SETTLED","A14-I208555","2020-06-26 19:35:14","2020-06-04","2","2020-06-26 19:35:14","2","2020-06-26 19:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8555","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-26 19:35:14","2","2020-06-26 19:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8555"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208198","2020-06-26 19:35:14",598,"2","2020-06-26 19:35:14","2","2020-06-26 19:35:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8198","DEPOSIT",null,"PAID","2020-06-26 19:35:14",0,"2","2020-06-26 19:35:14","2","2020-06-26 19:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:35:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8198","INVOICE","8555","PAID","2020-06-26 19:35:14",598,"2","2020-06-26 19:35:14","2","2020-06-26 19:35:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-08","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207577 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208066, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"736","room_code":"O12","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2020-07-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A14-CT208066 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4784","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
O12
<\/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":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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",263,"NEW","A14-CT208227",998,998,0,0,"1","1",998,998,998,"2020-06-26 19:36:14","0",null,null,null,"2020-06-08","2020-07-07","1 month contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit transferred from agreement A14-CT208066 to this agreement. \r\n","2020-06-08","12",0,null,0,"0","2","2020-06-26 19:36:14","2","2020-06-26 19:36:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4784"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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":["8227","736","998.0","998.00","2","2020-06-26 19:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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-08","2020-07-07","736"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-26 19:36:14","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":["8227",263,"SETTLED","A14-I208556","2020-06-26 19:36:14","2020-06-08","2","2020-06-26 19:36:14","2","2020-06-26 19:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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":["8556","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-26 19:36:14","2","2020-06-26 19:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8556"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-26 19:36:14","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208199","2020-06-26 19:36:14",998,"2","2020-06-26 19:36:14","2","2020-06-26 19:36:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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":["8199","DEPOSIT",null,"PAID","2020-06-26 19:36:14",0,"2","2020-06-26 19:36:14","2","2020-06-26 19:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-26 19:36:14","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":["8199","INVOICE","8556","PAID","2020-06-26 19:36:14",998,"2","2020-06-26 19:36:14","2","2020-06-26 19:36:14"]},"data_before":[],"data_after":[],"step":1} *****