\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\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>
A04 <\/td>\n\t\t\t\t\t	4X5X8 <\/td>\n\t\t\t\t\t	$1528.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","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-03-21 10:10:13","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":["C201542","PERSONAL","Ms","O83HOPioQNjXAGW\/eMFZ4g==","BvPqeOM4V79b5HJQ7Cm1Gg==","","5U98QmSIOp1g5+ePLoBCqQ==","TdePixtfMM5E\/fanbbX2ZGz3V5U+PhOnBvdswERRPWA=","vRtovc3VlnDgaQsC\/UrBBd1QnOK7TmBTPzDzTsWeuXM2CB5sPiTaX8L1isvDTwJImTzOLBZDQihW3bz0flMaiQ==","hAJ7OfX68VASuzcouC6Czg==",null,"TdePixtfMM5E\/fanbbX2ZGz3V5U+PhOnBvdswERRPWA=","XPVIyeOvWU+oTuHmOc3ZGw==","2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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` = ?","parameters":["1","1","1",1542,"NEW","A12-CT207463",1528,1452,3056,0,"3","3",5348,7412,5348,"2020-03-21 10:10:14","0",null,null,null,"2020-05-05","2020-08-04","3 months contract. Special offer first 3 month 50% off. Storage deposit $500 paid by cash on March 10, 2020. remaining balance paid by EPS on March 21, 2020. Smartcard provided on March 21, 2020. ","2020-05-05","20",0,null,2064,"2064.00","2","2020-03-21 10:10:12","2","2020-03-21 10:10:12","EPS","","","","EPS","","","",null,0,"189, 28819","C201542","PERSONAL","Ms","O83HOPioQNjXAGW\/eMFZ4g==","BvPqeOM4V79b5HJQ7Cm1Gg==","","vRtovc3VlnDgaQsC\/UrBBd1QnOK7TmBTPzDzTsWeuXM2CB5sPiTaX8L1isvDTwJImTzOLBZDQihW3bz0flMaiQ==","5U98QmSIOp1g5+ePLoBCqQ==","TdePixtfMM5E\/fanbbX2ZGz3V5U+PhOnBvdswERRPWA=","hAJ7OfX68VASuzcouC6Czg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7463","4","1528.0","1528.00","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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-05-05","2020-08-04","4"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 10:10:14","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":["7463","A12-D205332","PAID",3056,0,"2020-08-04","2020-03-21 10:10:12","2020-03-21 10:10:12","2","2020-03-21 10:10:12","2","2020-03-21 10:10:12",1542]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7463",1542,"SETTLED","A12-I207791","2020-03-21 10:10:12","2020-05-05","2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7791","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7791","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,840,"MO","1",840,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7791","RENT","\u9810\u7e73\u79df\u91d1",3,1452,"MO","1",1452,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2292,0,"7791"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 10:10: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":[1542,"EPS","","","","EPS","","","","PAID","P207439","2020-03-21 10:10:12",5348,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7439","DEPOSIT","5332","PAID","2020-03-21 10:10:12",3056,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 10:10: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":["7439","INVOICE","7791","PAID","2020-03-21 10:10:12",2292,"2","2020-03-21 10:10:12","2","2020-03-21 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"458","master_room_id":"38","room_code":"J40"}],"_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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> J40 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"D198734(9)","title":"Mr","lastname":"Mak","firstname":"Kwok Kee","companyname":"","email":"mak1689@hotmail.com","tel":"98800001","address":"3B, Block 7, Yar Chee Villa,1A Chi Fu Road, Pokfulam, HK","pass":true,"customer_id":"382","customer_code":"C170382","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"458","room_code":"J40","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"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-04-16","rent_from":"2020-04-16","rent_to":"2020-07-15","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cheque on March 21, 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":"2","branch_id":"1","company_id":"1","room_key":"056,16081","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-03-21 12:07:09","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","2","382","NEW","A14-CT207464",1528,1452,3056,0,"3","3",7412,7412,7412,"2020-03-21 12:07:09","0",null,null,null,"2020-04-16","2020-07-15","3 months contract. Storage rental and deposit paid by cheque on March 21, 2020. ","2020-04-16","20",0,null,0,"0","2","2020-03-21 12:07:08","2","2020-03-21 12:07:08","CHEQUE","","","","CHEQUE","","","",null,0,"056,16081","C170382","PERSONAL","Mr","eBJBjFY7uKjwde5uLS4BHw==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","+2fk6hajVk5Okk\/mh4hTuMHY5p4mROtqlAkyJDDNq0\/vAZgaiHCZOi4aVnkr4gH6EzXGDLlnTURaSkRIrtFTCA==","7kaxy1wgl\/5Qqg+bBrakQg==","1NOBLk3RKWOO5Vakfhj9G0vWIcoMTuEqPiVJAfYGcSw=","dLdYENBkJnucZpAoABTrhA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7464","458","1528.0","1528.00","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-16","2020-07-15","458"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 12:07:09","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":["7464","A14-D205333","PAID",3056,0,"2020-07-15","2020-03-21 12:07:08","2020-03-21 12:07:08","2","2020-03-21 12:07:08","2","2020-03-21 12:07:08","382"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7464","382","SETTLED","A14-I207792","2020-03-21 12:07:08","2020-04-16","2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7792","RENT","\u9810\u7e73\u79df\u91d1",1,1452,"MO","1",1452,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7792","RENT","\u9810\u7e73\u79df\u91d1",2,1452,"MO","1",1452,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7792","RENT","\u9810\u7e73\u79df\u91d1",3,1452,"MO","1",1452,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4356,0,"7792"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 12:07:09","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":["382","CHEQUE","","","","CHEQUE","","","","PAID","P207440","2020-03-21 12:07:08",7412,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7440","DEPOSIT","5333","PAID","2020-03-21 12:07:08",3056,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:07:09","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":["7440","INVOICE","7792","PAID","2020-03-21 12:07:08",4356,"2","2020-03-21 12:07:08","2","2020-03-21 12:07:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"458","master_room_id":"38","room_code":"J40"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":357,"customer_code":"C170357","identity_type":"PERSONAL","identity_id":"K200528(A)","title":"Ms","lastname":"So","firstname":"Bik Yan","companyname":"","email":"Bettyso2010@hotmail.com","tel":"61890200","address":"\u9999\u6e2f\u4ed4\u9d28\u8137\u6d32\u897f\u6751\u5229\u798f\u6a13\u9ad8\u5ea79\u6a1312\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-14","renew_room_key":"052,56559\/054,01889","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT196675 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206931, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"514","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"514","room_code":"K51","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-14","rent_from":"2020-02-14","rent_to":"2020-05-13","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A14-CT206931 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,56559\/054,01889","order_product":[],"pass":true}},"first_order_id":"3602","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K51 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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",357,"NEW","A14-CT207465",1098,989,0,0,"3","3",2967,2967,2967,"2020-03-21 12:13:34","0",null,null,null,"2020-02-14","2020-05-13","3 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A14-CT206931 to this agreement.\r\n","2020-02-14","16",0,null,0,"0","2","2020-03-21 12:13:34","2","2020-03-21 12:13:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,56559\/054,01889","C170357","PERSONAL","Ms","Xm\/QexF8eZtTsSb8L38jDQ==","4x5vYEKSVRSuDm5I8YHOGA==","","iaMKHy8smhToDNlD2lpct7apbVifxmEzETQX4zzdkIWbv1n1\/bqXIgSPJ9SuXJYQpspqWP8NAGG1MTx8\/3lieQ==","+3tfr98clfpe3pm59uql3Q==","oYq5\/GECL57LsJqAl8dH7KilbaFGbc5z+OZxfLZDi7A=","LEynVVsVuI2leNikh3mN3A==",null,1,"3602"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7465","434","35","514","%","4.97",54.5706,"2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7465","514","1098.0",1043.4,"2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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-14","2020-05-13","514"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 12:13:34","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":["7465",357,"SETTLED","A14-I207793","2020-03-21 12:13:34","2020-02-14","2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7793","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7793","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7793","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7793"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 12:13:34","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":[357,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207441","2020-03-21 12:13:34",2967,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7441","DEPOSIT",null,"PAID","2020-03-21 12:13:34",0,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:13:34","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":["7441","INVOICE","7793","PAID","2020-03-21 12:13:34",2967,"2","2020-03-21 12:13:34","2","2020-03-21 12:13:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:16:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":"458","master_room_id":"38","room_code":"J40"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":603,"customer_code":"C170603","identity_type":"BUSINESS","identity_id":"52365844","title":"Mr","lastname":"Au Yeung","firstname":"Man Kei","companyname":"J & M Merchandising Ltd.","email":"jasonay0115@gmail.com","tel":"94939341","address":"Unit A, 14\/F, Vulcan House, 21-23 Leighton Road, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1205.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-14","renew_room_key":"055,48768","renew_remark":"3 months contract. Storage rental paid by cheque deposit on December 16, 2019. Storage deposit transferred from agreement A12-CT196007 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196728, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-14","rent_from":"2020-03-14","rent_to":"2020-04-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT196728 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,48768","order_product":[],"pass":true}},"first_order_id":"4410","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B09 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",603,"NEW","A12-CT207466",1528,1286,0,0,"1","1",1286,1286,1286,"2020-03-21 12:46:21","0",null,null,null,"2020-03-14","2020-04-13","1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT196728 to this agreement.\r\n","2020-03-14","20",0,null,0,"0","2","2020-03-21 12:46:21","2","2020-03-21 12:46:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,48768","C170603","BUSINESS","Mr","L8PefY4fO30Q8ah3IheR+A==","1uwueeCdnD7fsnq6HEHgPQ==","J & M Merchandising Ltd.","9\/RudMZtO+RooA3vr9b\/NCCHzAVNDStvj4j4iJD1YxTKOQ8r86iecTt50cG6gGCEy1loSGY7rt4TIYTAuK5A+nlO3Rw4ijsB2Ng4+H8BOOc=","Y4ETi6Z203ojuSPCkql+LA==","yGnTFVSy5GDdTFH1KsCbH8P3tH23+LqlW1MadmJKF9s=",null,"Eh88SdBYpie0ITfpOcXYnw==",1,"4410"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7466","61","1528.0","1528.00","2","2020-03-21 12:46:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-14","2020-04-13","61"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7466",603,"SETTLED","A12-I207794","2020-03-21 12:46:21","2020-03-14","2","2020-03-21 12:46:21","2","2020-03-21 12:46:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7794","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-03-21 12:46:21","2","2020-03-21 12:46:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7794"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[603,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207442","2020-03-21 12:46:21",1286,"2","2020-03-21 12:46:21","2","2020-03-21 12:46:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7442","DEPOSIT",null,"PAID","2020-03-21 12:46:21",0,"2","2020-03-21 12:46:21","2","2020-03-21 12:46:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:46:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7442","INVOICE","7794","PAID","2020-03-21 12:46:21",1286,"2","2020-03-21 12:46:21","2","2020-03-21 12:46:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 12:50:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":"458","master_room_id":"38","room_code":"J40"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1057,"customer_code":"C181057","identity_type":"PERSONAL","identity_id":"D308847(3)","title":"Ms","lastname":"Lam ","firstname":"Shun Wai, Annie","companyname":"","email":"annielam2009@gmail.com","tel":"96813840","address":"Flat 5, 4\/F, Kong Fu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4106.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-16","renew_room_key":"0006005603","renew_remark":"3 months contract. Storage rental paid by Bank Transfer on December 22, 2019. Storage deposit transferred from agreement A05-CT195884 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196767, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"118","order_discount":[{"master_room_discount_id":"258","master_room_id":"118","discount_type":"%","price":"2161.00","disocunted_price":"2053.00","discount":"5.00","monthly_deduct":108.05,"room_id":"1156","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"258","master_room_id":"118","discount_type":"%","price":"2161.00","disocunted_price":"2053.00","discount":"5.00","monthly_deduct":108.05,"room_id":"1155","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1156","room_code":"A05-154","retail_price":"2161.0","discounted_price":2053,"location_id":"4"},{"room_id":"1155","room_code":"A05-153","retail_price":"2161.0","discounted_price":2053,"location_id":"4"}],"roughly_size":"56","total_retail_price":4322,"total_discounted_price":4106,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":12318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-16","rent_from":"2020-02-16","rent_to":"2020-05-15","delivery_service":"0","remark":"3 months contract. Storage rental paid by Bank Transfer on March 21, 2020. Storage deposit transferred from agreement A05-CT196767 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12318,"final_order_total":12318,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0006005603","order_product":[],"pass":true}},"first_order_id":"3553","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A05-153 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"56","total_discounted_price":"4106.0","deposit":"0","total_retail_price":"4322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1057,"NEW","A05-CT207467",4322,4106,0,0,"3","3",12318,12318,12318,"2020-03-21 13:03:55","0",null,null,null,"2020-02-16","2020-05-15","3 months contract. Storage rental paid by Bank Transfer on March 21, 2020. Storage deposit transferred from agreement A05-CT196767 to this agreement.","2020-02-16","56",0,null,0,"0","2","2020-03-21 13:03:54","2","2020-03-21 13:03:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0006005603","C181057","PERSONAL","Ms","1j\/EaXCwy81\/xtzbEcCIFg==","QW3H3bgt0C82y0s8QGTa0Q==","","f1Otee2exetSDY63KBCMB5p99mgzhZTcsXOUKcOm9HaGtL064AfZdfe5l6eIALO\/p8OTtANqNTg0DUdmmdQX\/I8owGh\/TPajPJqQ7N4t7i4=","g0N0c22b7twgi3MLXRIFsA==","M7r\/KEoRB4HilLKSFse6TNWqfcF7SJDkKhW++\/2WmZg=","TkzecISdNbJR\/TrRV20KnA==",null,1,"3553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","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":["7467","258","118","1156","%","5.00",108.05,"2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","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":["7467","258","118","1155","%","5.00",108.05,"2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7467","1156","2161.0",2053,"2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-16","2020-05-15","1156"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7467","1155","2161.0",2053,"2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-16","2020-05-15","1155"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7467",1057,"SETTLED","A05-I207795","2020-03-21 13:03:54","2020-02-16","2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7795","RENT","\u9810\u7e73\u79df\u91d1",1,4106,"MO","1",4106,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7795","RENT","\u9810\u7e73\u79df\u91d1",2,4106,"MO","1",4106,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7795","RENT","\u9810\u7e73\u79df\u91d1",3,4106,"MO","1",4106,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12318,0,"7795"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1057,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207443","2020-03-21 13:03:54",12318,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7443","DEPOSIT",null,"PAID","2020-03-21 13:03:54",0,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:03:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7443","INVOICE","7795","PAID","2020-03-21 13:03:54",12318,"2","2020-03-21 13:03:54","2","2020-03-21 13:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","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=975&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1407,"customer_code":"C191407","identity_type":"PERSONAL","identity_id":"K832783(1)","title":"Mr","lastname":"MAK","firstname":"Kwok Kin","companyname":"","email":"kinmak78@gmail.com","tel":"61086045","address":"Room 1502, Tung Cheong House, Lei Tung Estate","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-28","renew_room_key":"190,36626","renew_remark":"3 months contract. Storage rental paid by cash on December 14, 2019. Storage rental $2580 transferred from agreement A16-CT196033 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196695, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1675","room_code":"A16-184","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-28","rent_from":"2020-03-28","rent_to":"2020-06-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on Mar 21,2020. Storage rental $2580 transferred from agreement A16-CT196695 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,36626","order_product":[],"pass":true}},"first_order_id":"4790","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-184 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1407,"NEW","A16-CT207468",1290,1226,0,0,"3","3",3678,3678,3678,"2020-03-21 13:54:39","0",null,null,null,"2020-03-28","2020-06-27","3 months contract. Storage rental paid by cash on Mar 21,2020. Storage rental $2580 transferred from agreement A16-CT196695 to this agreement.","2020-03-28","16",0,null,0,"0","2","2020-03-21 13:54:39","2","2020-03-21 13:54:39","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,36626","C191407","PERSONAL","Mr","xtUUq7hHomPSgb0b1ApOww==","22KPgW1C3CU66tb5kESLdQ==","","0rjSs8WGoS7vuxPMpCuEyBBtI4hm53pl17OGNH+6SjGZTuBNXmUvO\/uZVcRLEom0","bBagOZVlfi7Vx5iHJfXB6Q==","kI2TPQxBZH97bJ7jJa5AnUEPA9betkNktVAFnwKYqoE=","mWsM69a\/kcUwVU02RZTj+Q==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7468","1675","1290.0","1290.00","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-28","2020-06-27","1675"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7468",1407,"SETTLED","A16-I207796","2020-03-21 13:54:39","2020-03-28","2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7796","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7796","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7796","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7796"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1407,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207444","2020-03-21 13:54:39",3678,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7444","DEPOSIT",null,"PAID","2020-03-21 13:54:39",0,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 13:54:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7444","INVOICE","7796","PAID","2020-03-21 13:54:39",3678,"2","2020-03-21 13:54:39","2","2020-03-21 13:54:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 14:26:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 14:43:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:10:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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=759&filter3=undefined","floor_plan_rent_room":[{"room_id":"1492","master_room_id":"200","room_code":"A16-001"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-001 <\/td>\r\n\t\t\t\t\t 4X3X3.5 <\/td>\r\n\t\t\t\t\t $668.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"E725787(6)","title":"Mr","lastname":"Li","firstname":"Wai Chung","companyname":"","email":"yuppiedad@gmail.com","tel":"51683460","address":"Room D, 9\/F, Block 13, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true,"customer_id":"759","customer_code":"C180759","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"474","master_room_id":"200","discount_type":"%","price":"668.00","disocunted_price":"600.90","discount":"10.04","monthly_deduct":67.0672,"room_id":"1492","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1492","room_code":"A16-001","retail_price":"668.0","discounted_price":600.9,"location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":602,"deposit":1336,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":2759,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2189.00","warehousing_date":"2020-03-21","rent_from":"2020-03-21","rent_to":"2020-09-20","delivery_service":"0","remark":"6 months contract. Change unit from L20 to A16-001. Storage deposit $2189 transferred from agreement A14-CT207223 to this agreement. Storage rental and deposit for A16-001 $2759 paid by EPS on Mar 21,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2189,"order_total":4948,"final_order_total":2759,"location_id":"7","branch_id":"1","company_id":"1","room_key":"055,40339","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"602.00","deposit":"1336.00","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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","759","NEW","A16-CT207469",668,602,1336,0,"6","6",2759,4948,2759,"2020-03-21 15:13:59","0",null,null,null,"2020-03-21","2020-09-20","6 months contract. Change unit from L20 to A16-001. Storage deposit $2189 transferred from agreement A14-CT207223 to this agreement. Storage rental and deposit for A16-001 $2759 paid by EPS on Mar 21,2020.","2020-03-21","12",0,null,2189,"2189.00","2","2020-03-21 15:13:59","2","2020-03-21 15:13:59","BANKIN","","","","BANKIN","","","",null,0,"055,40339","C180759","PERSONAL","Mr","Ynjpl8I3tZ++XpAECdNy8Q==","7KCehmxbvwRMb+U8lHGoVA==","","66cskWYypQHv60+\/GQVlPuizWjoPvnqEwr8r8zomaCnCOjNREiGJJVVi4LjSgRITum\/JHx+8NpKFYWoAXqB4Eg==","RF9EjEdNBYBpC0Mdx651WQ==","8y9PMGv35tRYLfkOJq8L7FsIMQZvnspgSxtWXml67uY=","EUPrhGL\/9mPduz3bVVEfqQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7469","474","200","1492","%","10.04",67.0672,"2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7469","1492","668.0",600.9,"2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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-03-21","2020-09-20","1492"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-21 15:13:59","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":["7469","A16-D205334","PAID",1336,0,"2020-09-20","2020-03-21 15:13:59","2020-03-21 15:13:59","2","2020-03-21 15:13:59","2","2020-03-21 15:13:59","759"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7469","759","SETTLED","A16-I207797","2020-03-21 15:13:59","2020-03-21","2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,219,"MO","1",219,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u9810\u7e73\u79df\u91d1",5,602,"MO","1",602,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7797","RENT","\u9810\u7e73\u79df\u91d1",6,602,"MO","1",602,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1423,0,"7797"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-21 15:13:59","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":["759","BANKIN","","","","BANKIN","","","","PAID","P207445","2020-03-21 15:13:59",2759,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7445","DEPOSIT","5334","PAID","2020-03-21 15:13:59",1336,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-21 15:13:59","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":["7445","INVOICE","7797","PAID","2020-03-21 15:13:59",1423,"2","2020-03-21 15:13:59","2","2020-03-21 15:13:59"]},"data_before":[],"data_after":[],"step":1} *****