\n\t\t\t\t\tA45 4X4X8 $1098.00 - <\/td> \u9810\u4ed86\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","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":["C201517","BUSINESS","Mr","2JEUlLxH7a34axPfIUze9Q==","sNENHA64udukswpNOWZRBw==","GRANDTEC LIMITED","TSA\/YUqwhb4MEGNFt83TlQ==",null,"ReNDa+miwJG2jEgnU0NdGr3v64tdr9R60\/j35lAUeqJ1stTE3mi+ICV6B6PYCHVd6b0g1\/3uOYHvlKF62r0Oeg==",null,"gNjYAvUwuNYneIT27Pp1svzdhRPdsyQYDwFGL9rcvJY=",null,"mrW4Kh+L99DiNLfXifoIyg==","2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1517,"NEW","A12-CT207245",1098,989,2196,0,"12","12",13276,14064,13276,"2020-02-22 12:11:58","0",null,null,null,"2020-02-25","2021-02-24","12 months contract. Special offer 5% discount and $200 termination coupon. Storage rental and deposit paid by EPS on Feb 22,2020. Smartcard and padlock provided on Feb 22,2020.","2020-02-25","16",0,null,788,"788.00","2","2020-02-22 12:11:56","2","2020-02-22 12:11:56","EPS","","","","EPS","","","",null,0,"055,35996 (605)","C201517","BUSINESS","Mr","2JEUlLxH7a34axPfIUze9Q==","sNENHA64udukswpNOWZRBw==","GRANDTEC LIMITED","ReNDa+miwJG2jEgnU0NdGr3v64tdr9R60\/j35lAUeqJ1stTE3mi+ICV6B6PYCHVd6b0g1\/3uOYHvlKF62r0Oeg==","TSA\/YUqwhb4MEGNFt83TlQ==",null,null,"gNjYAvUwuNYneIT27Pp1svzdhRPdsyQYDwFGL9rcvJY="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7245","73 available_room_list_input","8","45","%","16.85",185.013,"2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7245","45","1098.0",913,"2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-25","2021-02-24","45"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 12:11:58","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":["7245","A12-D205295","PAID",2196,0,"2021-02-24","2020-02-22 12:11:56","2020-02-22 12:11:56","2","2020-02-22 12:11:56","2","2020-02-22 12:11:56",1517]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7245",1517,"SETTLED","A12-I207573","2020-02-22 12:11:56","2020-02-25","2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,201,"MO","1",201,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11080,0,"7573"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1517,"EPS","","","","EPS","","","","PAID","P207221","2020-02-22 12:11:56",13276,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7221","DEPOSIT","5295","PAID","2020-02-22 12:11:56",2196,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:11:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7221","INVOICE","7573","PAID","2020-02-22 12:11:56",11080,"2","2020-02-22 12:11:56","2","2020-02-22 12:11:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:27","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=1242&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"57","master_room_id":"10","room_code":"B05"}],"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\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\tB05 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"BUSINESS","identity_id":"11719733-000-02-19-5","title":"Ms","lastname":"Lai","firstname":"Wing Yee, Eva","companyname":"Leo Engineering Limited","email":"leoengltd@gmail.com","tel":"28577258","address":"Flat B, 17\/F, Block 2, Kingley Industrial Building, 33 Yip Kan Street, Wong Chuk Hang, Hong Kong","pass":true,"customer_id":"1242","customer_code":"C191242","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"57","room_code":"B05","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1452,"deposit":3056,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7412,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-22","rent_from":"2020-02-22","rent_to":"2020-05-21","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cheque on February 22, 2020. Smartcard provided on February 22, 2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7412,"final_order_total":7412,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 29074","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1452.00","deposit":"3056.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1242","NEW","A12-CT207246",1528,1452,3056,0,"3","3",7412,7412,7412,"2020-02-22 12:18:28","0",null,null,null,"2020-02-22","2020-05-21","3 months contract. Storage rental and deposit paid by cheque on February 22, 2020. Smartcard provided on February 22, 2020.","2020-02-22","20",0,null,0,"0","2","2020-02-22 12:18:27","2","2020-02-22 12:18:27","CHEQUE","","","","CHEQUE","","","",null,0,"189, 29074","C191242","BUSINESS","Ms","Vt1s1tKyVHGE6ijWGp3g+w==","lzx0GiXnrd0waIhp6oozpQ==","Leo Engineering Limited","V+9pyaXSanw3cB\/uChDsBTU8VHLSHKXXirjbf4HhHeq9AoCbEpifZIM2PfmHZywVHfLZTWCD1znFfMbte52A1RhZSEU+HET7Az2teqxNOuRGZkraXDsV9xeBIB00Zu2rVMXsYNEgpgQC\/e2XnwBFGg==","LmRjdENAVEeS\/ql+Q5bRgw==","Xqh5H+LlZ+ZbGgv+\/6hg8Kl\/yJkr2MjdyVAG\/2Pn7H4=",null,"T4TaIH0rG3Elgf1srlSVcOW0IsKlbN0iAi9GLAKqHkc="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7246","57","1528.0","1528.00","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-22","2020-05-21","57"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 12:18:28","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":["7246","A12-D205296","PAID",3056,0,"2020-05-21","2020-02-22 12:18:27","2020-02-22 12:18:27","2","2020-02-22 12:18:27","2","2020-02-22 12:18:27","1242"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7246","1242","SETTLED","A12-I207574","2020-02-22 12:18:27","2020-02-22","2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574","RENT","\u9810\u7e73\u79df\u91d1",1,1452,"MO","1",1452,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574","RENT","\u9810\u7e73\u79df\u91d1",2,1452,"MO","1",1452,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574","RENT","\u9810\u7e73\u79df\u91d1",3,1452,"MO","1",1452,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4356,0,"7574"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1242","CHEQUE","","","","CHEQUE","","","","PAID","P207222","2020-02-22 12:18:27",7412,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7222","DEPOSIT","5296","PAID","2020-02-22 12:18:27",3056,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:18:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7222","INVOICE","7574","PAID","2020-02-22 12:18:27",4356,"2","2020-02-22 12:18:27","2","2020-02-22 12:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:40","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":"","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1174","master_room_id":"117","room_code":"A05-172"}],"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\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\tA05-172 4X6X7 $1857.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"Y003710(7)","title":"Mr","lastname":"LEUNG","firstname":"Ka Lun","companyname":"","email":"","tel":"92870169","address":"Room 1, 18\/F, Ka Wo Building, Block B, Ka Wo Street, Tin Wan","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1174","room_code":"A05-172","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":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":5572,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1856.00","warehousing_date":"2020-02-24","rent_from":"2020-02-24","rent_to":"2020-04-23","delivery_service":"0","remark":"2 months contract. Storage rental and deposit paid by EPS on February 22, 2020. Smartcard and padlock provided on February 22, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1856,"order_total":7428,"final_order_total":5572,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415174","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-02-22 12:26:41","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":["C201518","PERSONAL","Mr","0z7jLpDe8x0IjuGUlN\/nsg==","yXKc2lCF323ApRADrjNaSg==","","CNLzBhhkWq2HowtqHSJq8w==",null,"BhmV\/aipu40rQOzlUmaalWHk4fgI1ZJxF0owdwv117n0eERs9UReYpb6ts\/lph+Rdc2T7EesExUWcjLYezs9Uw==","nxjV6XcaviDJ2024AkFjcA==",null,null,"w0Rk3N5qYITADuQBtCxGug==","2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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",1518,"NEW","A05-CT207247",1857,1857,3714,0,"2","2",5572,7428,5572,"2020-02-22 12:26:41","0",null,null,null,"2020-02-24","2020-04-23","2 months contract. Storage rental and deposit paid by EPS on February 22, 2020. Smartcard and padlock provided on February 22, 2020.","2020-02-24","24",0,null,1856,"1856.00","2","2020-02-22 12:26:40","2","2020-02-22 12:26:40","EPS","","","","EPS","","","",null,0,"'0012415174","C201518","PERSONAL","Mr","0z7jLpDe8x0IjuGUlN\/nsg==","yXKc2lCF323ApRADrjNaSg==","","BhmV\/aipu40rQOzlUmaalWHk4fgI1ZJxF0owdwv117n0eERs9UReYpb6ts\/lph+Rdc2T7EesExUWcjLYezs9Uw==","CNLzBhhkWq2HowtqHSJq8w==",null,"nxjV6XcaviDJ2024AkFjcA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7247","1174","1857.0","1857.00","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-24","2020-04-23","1174"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 12:26:41","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":["7247","A05-D205297","PAID",3714,0,"2020-04-23","2020-02-22 12:26:40","2020-02-22 12:26:40","2","2020-02-22 12:26:40","2","2020-02-22 12:26:40",1518]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7247",1518,"SETTLED","A05-I207575","2020-02-22 12:26:40","2020-02-24","2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7575","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1,"MO","1",1,"2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7575","RENT","\u9810\u7e73\u79df\u91d1",2,1857,"MO","1",1857,"2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1858,0,"7575"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 12:26:41","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":[1518,"EPS","","","","EPS","","","","PAID","P207223","2020-02-22 12:26:40",5572,"2","2020-02-22 12:26:40","2","2020-02-22 12:26:40","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7223","DEPOSIT","5297","PAID","2020-02-22 12:26:40",3714,"2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 12:26:41","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":["7223","INVOICE","7575","PAID","2020-02-22 12:26:40",1858,"2","2020-02-22 12:26:40","2","2020-02-22 12:26:40"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:24:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:48","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=1340&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1767","master_room_id":"228","room_code":"WC-25"}],"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\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\tWC-25 5X4X8 $0.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"D804254(4)","title":"Ms","lastname":"Li","firstname":"Kam Ying","companyname":"","email":"kyli70@yahoo.com.hk","tel":"91846991","address":"21\/F, Cityplaza Three, 14 Taikoo Shing Road, Taikoo Shing, Hong Kong","pass":true,"customer_id":"1340","customer_code":"C191340","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1767","room_code":"WC-25","retail_price":"0.0","discounted_price":"0.00","location_id":"8"}],"roughly_size":"20","total_retail_price":0,"total_discounted_price":1605,"deposit":3210,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":639,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4176.00","warehousing_date":"2020-02-23","rent_from":"2020-02-23","rent_to":"2020-03-22","delivery_service":"0","remark":"1 month contract. Change unit from WC-43 to WC-25. Storage deposit $4176 transferred from agreement WC-CT207188 to this agreement. Remaining balance $639 paid by PPS on February 22, 2020. ","paymethod":"PPS","paymethod2":"PPS","discount_deduct":4176,"order_total":4815,"final_order_total":639,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190,26383","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1605.00","deposit":"3210.00","total_retail_price":"0.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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","8","1340","NEW","WC-CT207248",0,1605,3210,0,"1","1",639,4815,639,"2020-02-22 13:29:49","0",null,null,null,"2020-02-23","2020-03-22","1 month contract. Change unit from WC-43 to WC-25. Storage deposit $4176 transferred from agreement WC-CT207188 to this agreement. Remaining balance $639 paid by PPS on February 22, 2020. ","2020-02-23","20",0,null,4176,"4176.00","2","2020-02-22 13:29:48","2","2020-02-22 13:29:48","PPS","","","","PPS","","","",null,0,"190,26383","C191340","PERSONAL","Ms","JdQzQv+uksVt7YfqRkcs2g==","7KCehmxbvwRMb+U8lHGoVA==","","Hk9QjTXPPZugpENsJNJVRFjDshAXCfqBJdXMP\/Va7d3Z2K\/aCGuUUGkjQYrRlPUPOZljB3ovRTE6wx9XrkHxgBiZiPEw1x7TWdiJCF8+iP8=","u\/RO33AxBdDZLcxr\/eihQw==","rD9Syyb4nHCPJX+uzCXhPgdBRpQS4iLmKGxvb8tt99M=","pljIbpMDyGb8muJ6+q40Nw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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":["7248","1767","0.0","0.00","2","2020-02-22 13:29:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-23","2020-03-22","1767"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 13:29:49","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":["7248","WC-D205298","PAID",3210,0,"2020-03-22","2020-02-22 13:29:48","2020-02-22 13:29:48","2","2020-02-22 13:29:48","2","2020-02-22 13:29:48","1340"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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":["7248","1340","SETTLED","WC-I207576","2020-02-22 13:29:48","2020-02-23","2","2020-02-22 13:29:48","2","2020-02-22 13:29:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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":["7576","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-22 13:29:48","2","2020-02-22 13:29:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7576"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 13:29:49","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":["1340","PPS","","","","PPS","","","","PAID","P207224","2020-02-22 13:29:48",3210,"2","2020-02-22 13:29:48","2","2020-02-22 13:29:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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":["7224","DEPOSIT","5298","PAID","2020-02-22 13:29:48",3210,"2","2020-02-22 13:29:48","2","2020-02-22 13:29:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 13:29:49","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":["7224","INVOICE","7576","PAID","2020-02-22 13:29:48",0,"2","2020-02-22 13:29:48","2","2020-02-22 13:29:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1242&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K460218(8)","title":"Ms","lastname":"CHAN","firstname":"Hoi Sze Rita","companyname":"","email":"Ritapchan@yahoo.com.hk","tel":"61008406","address":"Flat D, 29\/F, South View Garden, 80 Shek Pei Wan Rd, Aberdeen, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1677","room_code":"A16-186","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":2580,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":15828,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1858.00","warehousing_date":"2020-02-23","rent_from":"2020-02-23","rent_to":"2021-03-22","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% discount. Storage rental and deposit paid by cheque on Feb 22,2020. Smartcard provided on Feb 22,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1858,"order_total":17686,"final_order_total":15828,"location_id":"7","branch_id":"1","company_id":"1","room_key":"090,51002","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tA16-186 4X4X7 $1290.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1162.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:09","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":["C201519","PERSONAL","Ms","ieogbeLfdwMaXKAqcFcWgw==","8BEgNhGpCR8jGkzUtrIcXg==","","P\/CiLErbv9IcBHSwfQ3Xog==","\/uICnjHBeQOsUj8Pqq9YAi0mK3bYQ05Hg2ORdgeZoSc=","SavJ1ncLcyhrXUskSXHrIqfiHd5v+tHgLSr5ZVtVv8HWYcghcjnHhOrp\/IM6CZWrDak95uVJ2UGig5cr4PpvgZ5FNqDWAylmUmuNpc5mWg8=","piGbR2adg+nHGXgp7Za85w==",null,"\/uICnjHBeQOsUj8Pqq9YAi0mK3bYQ05Hg2ORdgeZoSc=","e9jvjyyNRVvWzsfZdJmEpw==","2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1519,"NEW","A16-CT207249",1290,1162,2580,0,"13","13",15828,17686,15828,"2020-02-22 14:32:10","0",null,null,null,"2020-02-23","2021-03-22","13 months contract. Special offer the 13th month free and 5% discount. Storage rental and deposit paid by cheque on Feb 22,2020. Smartcard provided on Feb 22,2020.","2020-02-23","16",0,null,1858,"1858.00","2","2020-02-22 14:32:07","2","2020-02-22 14:32:07","CHEQUE","","","","CHEQUE","","","",null,0,"090,51002","C201519","PERSONAL","Ms","ieogbeLfdwMaXKAqcFcWgw==","8BEgNhGpCR8jGkzUtrIcXg==","","SavJ1ncLcyhrXUskSXHrIqfiHd5v+tHgLSr5ZVtVv8HWYcghcjnHhOrp\/IM6CZWrDak95uVJ2UGig5cr4PpvgZ5FNqDWAylmUmuNpc5mWg8=","P\/CiLErbv9IcBHSwfQ3Xog==","\/uICnjHBeQOsUj8Pqq9YAi0mK3bYQ05Hg2ORdgeZoSc=","piGbR2adg+nHGXgp7Za85w==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7249","1677","1290.0","1290.00","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-23","2021-03-22","1677"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 14:32:10","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":["7249","A16-D205299","PAID",2580,0,"2021-03-22","2020-02-22 14:32:07","2020-02-22 14:32:07","2","2020-02-22 14:32:07","2","2020-02-22 14:32:07",1519]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7249",1519,"SETTLED","A16-I207577","2020-02-22 14:32:07","2020-02-23","2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,466,"MO","1",466,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7577","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13248,0,"7577"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1519,"CHEQUE","","","","CHEQUE","","","","PAID","P207225","2020-02-22 14:32:07",15828,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7225","DEPOSIT","5299","PAID","2020-02-22 14:32:07",2580,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:32:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7225","INVOICE","7577","PAID","2020-02-22 14:32:07",13248,"2","2020-02-22 14:32:07","2","2020-02-22 14:32:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","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=1340&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1767","master_room_id":"228","room_code":"WC-25"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1440,"customer_code":"C191440","identity_type":"PERSONAL","identity_id":"G185553(A)","title":"Ms","lastname":"CHEUNG","firstname":"Wai Kuen","companyname":"","email":"maseotcheung@yahoo.com.hk","tel":"91246112","address":"\u9999\u6e2f\u4ed4\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5b89\u6a133523\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1043.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-15","renew_room_key":"189,63764","renew_remark":"3 months contract. Special offer 5% 'rent now' discount. Storage rental and deposit paid by cheque on Nov 11,2019. Smartcard and padlock provided on Nov 11,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196362, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"142","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"142","room_code":"C18","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5934,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-15","rent_from":"2020-02-15","rent_to":"2020-08-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on February 22, 2020. Storage deposit $2196 transferred from agreement A12-CT196362 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196362, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5934,"final_order_total":5934,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,63764","order_product":[],"pass":true}},"first_order_id":6362,"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\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\tC18 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1440,"NEW","A12-CT207250",1098,989,0,0,"6","6",5934,5934,5934,"2020-02-22 14:33:27","0",null,null,null,"2020-02-15","2020-08-14","6 months contract. Storage rental paid by cash on February 22, 2020. Storage deposit $2196 transferred from agreement A12-CT196362 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196362, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","2020-02-15","16",0,null,0,"0","2","2020-02-22 14:33:27","2","2020-02-22 14:33:27","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189,63764","C191440","PERSONAL","Ms","5aOxCxukxb0+7NooBdnwuw==","ts1WQ6NWxfSAyKGz8YWojw==","","iaMKHy8smhToDNlD2lpct0nolea1MflWl0KXk9BFfSFtP15\/BFok5b4iKnKn7CoA","urCzmPSeTFWDKKNcPdYkrA==","Z3twgPPW9Kp3ipuMAgEtH8BBwUivizNoCIJOA\/mTlC8=","4ZPeZS09mPopO\/GjT3yZWw==",null,1,6362]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","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":["7250","72","8","142","%","9.93",109.0314,"2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7250","142","1098.0",989,"2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-15","2020-08-14","142"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7250",1440,"SETTLED","A12-I207578","2020-02-22 14:33:27","2020-02-15","2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7578","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5934,0,"7578"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1440,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207226","2020-02-22 14:33:27",5934,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7226","DEPOSIT",null,"PAID","2020-02-22 14:33:27",0,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:33:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7226","INVOICE","7578","PAID","2020-02-22 14:33:27",5934,"2","2020-02-22 14:33:27","2","2020-02-22 14:33:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-22 14:44:30","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","090,51002","13 months contract. Special offer the 13th month free and 5% discount. $500 deposit paid on Jan 04. The balance of storage rental and deposit paid by cheque on Feb 22,2020. Smartcard provided on Feb 22,2020.","2020-02-22 14:44:30","2","8BEgNhGpCR8jGkzUtrIcXg==","ieogbeLfdwMaXKAqcFcWgw==","\/uICnjHBeQOsUj8Pqq9YAi0mK3bYQ05Hg2ORdgeZoSc=","P\/CiLErbv9IcBHSwfQ3Xog==","SavJ1ncLcyhrXUskSXHrIqfiHd5v+tHgLSr5ZVtVv8HWYcghcjnHhOrp\/IM6CZWrDak95uVJ2UGig5cr4PpvgZ5FNqDWAylmUmuNpc5mWg8=",7249]},"data_before":[],"data_after":[],"step":1}
*****