\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>
X01 <\/td>\n\t\t\t\t\t	3X4X7 <\/td>\n\t\t\t\t\t	$1090.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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` = ?","parameters":["1","1","3","677","NEW","A18-CT206826",1090,981,0,0,"6","6",5886,5886,5886,"2020-01-02 15:39:27","0",null,null,null,"2020-01-03","2020-07-02","6 months contract. Storage rental paid by cash on January 2, 2020. Storage deposit transferred from agreement A18-CT195374 to this agreement.","2020-01-03","12",0,null,0,"0","2","2020-01-02 15:39:26","2","2020-01-02 15:39:26","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,10258","C180677","PERSONAL","Mr","bdbvURXhDzGec5LyFz5qZg==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","K0Ap1tpRFk8d92PQMlS6iCIwlUU8OUp63O6yHT3BNM61oJlgYkNF1tEIEtGoGcVBZPgBYYDJg\/5d+BweDGu0i9DyslPfH+5qpRdFgJ+lI9E=","zH1u9g1iPEwvZeiniQTHgg==",null,"I21g9y1hVBZcy2tQN8KK\/A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["6826","976","1090.0","1090.00","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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-01-03","2020-07-02","976"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 15:39: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":["6826","677","SETTLED","A18-I207154","2020-01-02 15:39:26","2020-01-03","2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["7154","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7154"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 15:39: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":["677","NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206804","2020-01-02 15:39:26",5886,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["6804","DEPOSIT",null,"PAID","2020-01-02 15:39:26",0,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:39: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":["6804","INVOICE","7154","PAID","2020-01-02 15:39:26",5886,"2","2020-01-02 15:39:26","2","2020-01-02 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:47:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:51:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:56:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:57:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:57:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 15:58:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:06:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:08:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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=837&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":733,"customer_code":"C180733","identity_type":"PERSONAL","identity_id":"G011129(4)","title":"Ms","lastname":"Kan","firstname":"Yim Ngan","companyname":"","email":"nellykan1128@yahoo.com.hk","tel":"94324063","address":"Rm 1613, Pik Long House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1058.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-20","renew_room_key":"054,42661","renew_remark":"1 months contract. Storage rental $1058 paid by bank transfer on December 10, 2019. Outstanding $2 for agreement A18-CT196424. Storage deposit $2096 transferred from agreement A18-CT196424 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196678, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[],"order_room":[{"room_id":"935","room_code":"V09(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"3"}],"roughly_size":"9.6","total_retail_price":1058,"total_discounted_price":1058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-20","rent_from":"2019-11-20","rent_to":"2019-12-19","delivery_service":"0","remark":"1 months contract. Storage rental $1058 paid by bank transfer on Jan 02,2020. Outstanding $2 for agreement A18-CT196424. Storage deposit $2096 transferred from agreement A18-CT196678 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1058,"final_order_total":1058,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,42661","order_product":[],"pass":true}},"first_order_id":"4514","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> V09(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.4X7 <\/td>\r\n\t\t\t\t\t $1058.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":"9.6","total_discounted_price":"1058.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",733,"NEW","A18-CT206827",1058,1058,0,0,"1","1",1058,1058,1058,"2020-01-02 16:15:59","0",null,null,null,"2019-11-20","2019-12-19","1 months contract. Storage rental $1058 paid by bank transfer on Jan 02,2020. Outstanding $2 for agreement A18-CT196424. Storage deposit $2096 transferred from agreement A18-CT196678 to this agreement.","2019-11-20","9.6",0,null,0,"0","2","2020-01-02 16:15:59","2","2020-01-02 16:15:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,42661","C180733","PERSONAL","Ms","LuCmhx4vLIS+I2VRpkOJLw==","Oy7M11y4AYbqdsYthumGaw==","","pRevwfLH+V5p27KCzHhjJiFoLF+7KutuihUJaWarNVLL+Cfse1AKI58Qyx0LsGyvf51+AcKXq58wG9PBXHPRg8q+MOpswflvPznmtJYPHOM=","j+g19UGqLxVDE6Ev1Ki78g==","0QRC7C\/A8YfDBYxJnv35JgsmKRHtg1WHgToRbTKF+0Q=","\/4aTFzkJ3TQsDPebIexQkQ==",null,1,"4514"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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":["6827","935","1058.0","1058.00","2","2020-01-02 16:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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":["2019-11-20","2019-12-19","935"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 16:15: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":["6827",733,"SETTLED","A18-I207155","2020-01-02 16:15:59","2019-11-20","2","2020-01-02 16:15:59","2","2020-01-02 16:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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":["7155","RENT","\u9810\u7e73\u79df\u91d1",1,1058,"MO","1",1058,"2","2020-01-02 16:15:59","2","2020-01-02 16:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1058,0,"7155"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 16:15: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":[733,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206805","2020-01-02 16:15:59",1058,"2","2020-01-02 16:15:59","2","2020-01-02 16:15:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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":["6805","DEPOSIT",null,"PAID","2020-01-02 16:15:59",0,"2","2020-01-02 16:15:59","2","2020-01-02 16:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:15: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":["6805","INVOICE","7155","PAID","2020-01-02 16:15:59",1058,"2","2020-01-02 16:15:59","2","2020-01-02 16:15:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:53","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=837&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by bank transfer on December 02, 2019. Storage deposit transferred from agreement A18-CT196278 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196579, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2298,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-01-31","delivery_service":"0","remark":"1 month contract. Storage rental $2300 paid by bank transfer on Jan 02,2020. Storage deposit transferred from agreement A18-CT196579 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2298,"final_order_total":2298,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2298.0","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT206828",2298,2298,0,0,"1","1",2298,2298,2298,"2020-01-02 16:19:54","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental $2300 paid by bank transfer on Jan 02,2020. Storage deposit transferred from agreement A18-CT196579 to this agreement.","2020-01-01","30",0,null,0,"0","2","2020-01-02 16:19:53","2","2020-01-02 16:19:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","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":["6828","857","2298.0","2298.00","2","2020-01-02 16:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","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-01-01","2020-01-31","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 16:19:54","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":["6828",685,"SETTLED","A18-I207156","2020-01-02 16:19:53","2020-01-01","2","2020-01-02 16:19:53","2","2020-01-02 16:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","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":["7156","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-01-02 16:19:53","2","2020-01-02 16:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"7156"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 16:19:54","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":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206806","2020-01-02 16:19:53",2298,"2","2020-01-02 16:19:53","2","2020-01-02 16:19:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","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":["6806","DEPOSIT",null,"PAID","2020-01-02 16:19:53",0,"2","2020-01-02 16:19:53","2","2020-01-02 16:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:19:54","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":["6806","INVOICE","7156","PAID","2020-01-02 16:19:53",2298,"2","2020-01-02 16:19:53","2","2020-01-02 16:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:36:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 16:39:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 17:20:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:49","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","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"filter1=2&filter2=265&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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":950,"customer_code":"C180950","identity_type":"PERSONAL","identity_id":"M096081(6)","title":"Mr","lastname":"Vincelli","firstname":"Stefano","companyname":"","email":"sabiobra@hotmail.com","tel":"95652114","address":"35 Happy View Terrace, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4116.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 31, 2019. Storage deposit transferred from agreement A14-CT196159 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196549, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"58","order_discount":[],"order_room":[{"room_id":"417","room_code":"I08","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"424","room_code":"J06","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"56","total_retail_price":3986,"total_discounted_price":4116,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4116,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-03","rent_from":"2019-12-03","rent_to":"2020-01-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on November 27, 2019. Storage deposit transferred from agreement A14-CT196549 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4116,"final_order_total":4116,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29154","order_product":[],"pass":true}},"first_order_id":"4680","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> I08 <\/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> J06 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.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":"56","total_discounted_price":"4116.0","deposit":"0","total_retail_price":"3986.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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",950,"NEW","A14-CT206829",3986,4116,0,0,"1","1",4116,4116,4116,"2020-01-02 18:08:50","0",null,null,null,"2019-12-03","2020-01-02","1 month contract. Storage rental paid by bank transfer on November 27, 2019. Storage deposit transferred from agreement A14-CT196549 to this agreement.\r\n","2019-12-03","56",0,null,0,"0","2","2020-01-02 18:08:49","2","2020-01-02 18:08:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29154","C180950","PERSONAL","Mr","kBtwICYFFgkwWiGlHlA7Vg==","J9AQQ+eusxRuMi9Uwswx2w==","","xpCmz6ayhnKM9CeubIeX46ST4OH8jL8leoh\/7rF5LKq0NI4lQzsUw3z+sKEaA2Q2","HMxniP6OLhRLykg\/y72g1w==","G2oqjsMfynuJ5hF7HR+cYPuapiwUrw6QQkLUvHZtFiE=","LjEwev8Vn2pWAe0zRvbXAw==",null,1,"4680"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["6829","417","1098.0","1098.00","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["2019-12-03","2020-01-02","417"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 18:08:50","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":["6829","424","2888.0","2888.00","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["2019-12-03","2020-01-02","424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 18:08:50","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":["6829",950,"SETTLED","A14-I207157","2020-01-02 18:08:49","2019-12-03","2","2020-01-02 18:08:49","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["7157","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-01-02 18:08:49","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"7157"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 18:08:50","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":[950,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206807","2020-01-02 18:08:49",4116,"2","2020-01-02 18:08:49","2","2020-01-02 18:08:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["6807","DEPOSIT",null,"PAID","2020-01-02 18:08:49",0,"2","2020-01-02 18:08:49","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:08:50","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":["6807","INVOICE","7157","PAID","2020-01-02 18:08:49",4116,"2","2020-01-02 18:08:49","2","2020-01-02 18:08:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:30","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","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"filter1=2&filter2=265&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1195.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-02","renew_room_key":"052,40523","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 29, 2019. Storage deposit transferred from agreement A18-CT196046 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196250, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2390,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-02","rent_from":"2019-12-02","rent_to":"2020-02-01","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on November 29, 2019 and December 31, 2019. Storage deposit transferred from agreement A18-CT196250 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2390,"final_order_total":2390,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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> Q12 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1195.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":"18","total_discounted_price":"1195.00","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",629,"NEW","A18-CT206830",1195,1195,0,0,"2","2",2390,2390,2390,"2020-01-02 18:15:31","0",null,null,null,"2019-12-02","2020-02-01","2 months contract. Storage rental paid by bank transfer on November 29, 2019 and December 31, 2019. Storage deposit transferred from agreement A18-CT196250 to this agreement.","2019-12-02","18",0,null,0,"0","2","2020-01-02 18:15:30","2","2020-01-02 18:15:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["6830","815","1195.0","1195.00","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["2019-12-02","2020-02-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 18:15:31","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":["6830",629,"SETTLED","A18-I207158","2020-01-02 18:15:30","2019-12-02","2","2020-01-02 18:15:30","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["7158","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-01-02 18:15:30","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["7158","RENT","\u9810\u7e73\u79df\u91d1",2,1195,"MO","1",1195,"2","2020-01-02 18:15:30","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2390,0,"7158"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 18:15:31","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":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206808","2020-01-02 18:15:30",2390,"2","2020-01-02 18:15:30","2","2020-01-02 18:15:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["6808","DEPOSIT",null,"PAID","2020-01-02 18:15:30",0,"2","2020-01-02 18:15:30","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:15:31","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":["6808","INVOICE","7158","PAID","2020-01-02 18:15:30",2390,"2","2020-01-02 18:15:30","2","2020-01-02 18:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:49:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1314","master_room_id":"164","room_code":"C15-008"}],"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> C15-008 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.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":"D545463(9)","title":"Mr","lastname":"FUNG","firstname":"San Wa","companyname":"","email":"","tel":"67688797","address":"Room D, 39\/F, Block 4, Boardview Court, 11 Sham Wan Road, Hong Kong","pass":true,"customer_id":"1358","customer_code":"C191358","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1314","room_code":"C15-008","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":773,"deposit":773,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1789,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"530.00","warehousing_date":"2019-12-02","rent_from":"2019-12-02","rent_to":"2020-02-01","delivery_service":"0","remark":"2 months contract. Change unit from C15-137 to C15-008. Deposit $530 transferred from agreement C15-CT196515 to this agreement. Remaining storage rental and deposit paid by EPS on Jan 02,2020. Smartcard provided on Jan 02,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":530,"order_total":2319,"final_order_total":1789,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012491558","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"773.00","deposit":"773.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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` = ?","parameters":["1","3","6","1358","NEW","C15-CT206831",773,773,773,0,"2","2",1789,2319,1789,"2020-01-02 18:52:21","0",null,null,null,"2019-12-02","2020-02-01","2 months contract. Change unit from C15-137 to C15-008. Deposit $530 transferred from agreement C15-CT196515 to this agreement. Remaining storage rental and deposit paid by EPS on Jan 02,2020. Smartcard provided on Jan 02,2020.","2019-12-02","10",0,null,530,"530.00","2","2020-01-02 18:52:20","2","2020-01-02 18:52:20","EPS","","","","EPS","","","",null,0,"0012491558","C191358","PERSONAL","Mr","WlalgTrrPcjA8Gp112S\/Kg==","cyZbjLKMtXmsqxQPpU0UpA==","","fe9iCk1tQ1lAm3PjbJ6V+OcyRyIUyWQKGswsQvEp2AW4XMR2lHSRsQlP8RHp1WU2o5SV8smkoy3jxlR42qpFlCAZwCkDgtdv0NJkZDJeMD0=","Fu4byQTCTJLHh9jc8AHLPw==",null,"CX+Y57S\/WdhXAqCDsjxY3Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["6831","1314","773.0","773.00","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["2019-12-02","2020-02-01","1314"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 18:52:21","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":["6831","C15-D205237","PAID",773,0,"2020-02-01","2020-01-02 18:52:20","2020-01-02 18:52:20","2","2020-01-02 18:52:20","2","2020-01-02 18:52:20","1358"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["6831","1358","SETTLED","C15-I207159","2020-01-02 18:52:20","2019-12-02","2","2020-01-02 18:52:20","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["7159","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,243,"MO","1",243,"2","2020-01-02 18:52:20","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["7159","RENT","\u9810\u7e73\u79df\u91d1",2,773,"MO","1",773,"2","2020-01-02 18:52:20","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1016,0,"7159"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 18:52: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":["1358","EPS","","","","EPS","","","","PAID","P206809","2020-01-02 18:52:20",1789,"2","2020-01-02 18:52:20","2","2020-01-02 18:52:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["6809","DEPOSIT","5237","PAID","2020-01-02 18:52:20",773,"2","2020-01-02 18:52:20","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:52: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":["6809","INVOICE","7159","PAID","2020-01-02 18:52:20",1016,"2","2020-01-02 18:52:20","2","2020-01-02 18:52:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 18:54:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:00:22","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0012491558","2 months contract. Change unit from C15-137 to C15-008. Deposit $530 transferred from agreement C15-CT196515 to this agreement. Remaining storage rental and deposit paid by bank transfer on Jan 02,2020. Smartcard provided on Jan 02,2020.","2020-01-02 19:00:22","2","cyZbjLKMtXmsqxQPpU0UpA==","WlalgTrrPcjA8Gp112S\/Kg==","Fu4byQTCTJLHh9jc8AHLPw==","fe9iCk1tQ1lAm3PjbJ6V+OcyRyIUyWQKGswsQvEp2AW4XMR2lHSRsQlP8RHp1WU2o5SV8smkoy3jxlR42qpFlCAZwCkDgtdv0NJkZDJeMD0=",6831]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"filter1=2&filter2=246&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":674,"customer_code":"C170674","identity_type":"PERSONAL","identity_id":"E760420(7)","title":"Ms","lastname":"Sie ","firstname":"Ki","companyname":"","email":"alberta@cpalay.com.hk","tel":"92626390","address":"Flat A, 5\/F, Block 9, South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2191.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-07","renew_room_key":"055,31715,134,31243","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 5, 2019. Storage deposit transferred from agreement A18-CT194075 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195406, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"957","room_code":"W02","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"956","room_code":"W01","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2191,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":26292,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2191.00","warehousing_date":"2020-01-07","rent_from":"2020-01-07","rent_to":"2021-02-06","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 2, 2020. Storage deposit transferred from agreement A18-CT195406 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2191,"order_total":28483,"final_order_total":26292,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,31715,134,31243","order_product":[],"pass":true}},"first_order_id":"4075","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> W02 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> W01 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2191.00","deposit":"0.00","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",674,"NEW","A18-CT206832",2580,2191,0,0,"13","13",26292,28483,26292,"2020-01-02 19:01:45","0",null,null,null,"2020-01-07","2021-02-06","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 2, 2020. Storage deposit transferred from agreement A18-CT195406 to this agreement.","2020-01-07","32",0,null,2191,"2191.00","2","2020-01-02 19:01:45","2","2020-01-02 19:01:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,31715,134,31243","C170674","PERSONAL","Ms","XsUtDjYUZgiaBvuCOxTkfw==","AowcmClxO0WRN6q5wtqFYg==","","toT5bzKu53XlqYEF09SLx9HwD6Icy015+wpQyF6klSehhmtkSKMV4Bw3\/xbUUR3IB67O51oRK2gT1pmlWaJq2Q==","QKAk39UlcDNarV3KbWl\/uQ==","u82P1V8wirdTyhXMCDj\/JXYFSjxwvrQNr3ytvrOQ3Eo=","7pjiQVbuXPQbHks+4CexJw==",null,1,"4075"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["6832","957","1290.0","1290.00","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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-01-07","2021-02-06","957"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 19:01:45","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":["6832","956","1290.0","1290.00","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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-01-07","2021-02-06","956"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-02 19:01:45","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":["6832",674,"SETTLED","A18-I207160","2020-01-02 19:01:45","2020-01-07","2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",3,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",4,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",5,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",6,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",7,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",8,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",9,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",10,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",11,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",12,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["7160","RENT","\u9810\u7e73\u79df\u91d1",13,2191,"MO","1",2191,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26292,0,"7160"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-02 19:01:45","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":[674,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206810","2020-01-02 19:01:45",26292,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["6810","DEPOSIT",null,"PAID","2020-01-02 19:01:45",0,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-02 19:01:45","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":["6810","INVOICE","7160","PAID","2020-01-02 19:01:45",26292,"2","2020-01-02 19:01:45","2","2020-01-02 19:01:45"]},"data_before":[],"data_after":[],"step":1} *****