{"created_at":"2020-06-29 09:58:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 10:09:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 10:12:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 10:15:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 10:15:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 10:45:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 11:43:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 11:43:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 12:06:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 12:17:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 12:34:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 13:38:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":193,"customer_code":"C160193","identity_type":"PERSONAL","identity_id":"K727396(7)","title":"Mr","lastname":"Lau","firstname":"Wing Kan","companyname":"","email":null,"tel":"63488822","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13417\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-19","renew_room_key":"190,40484","renew_remark":"1 month contract. Storage rental paid by cash on Jun 02, 2020. Storage deposit transferred from agreement A12-CT207325 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208013, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"371","room_code":"G12","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-06-19","rent_from":"2020-06-19","rent_to":"2020-07-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on Jun 29, 2020. Storage deposit transferred from agreement A12-CT208013 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,40484","order_product":[],"pass":true}},"first_order_id":"4777","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>
G12 <\/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.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","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",193,"NEW","A12-CT208235",1528,1286,0,0,"1","1",1286,1286,1286,"2020-06-29 14:44:04","0",null,null,null,"2020-06-19","2020-07-18","1 month contract. Storage rental paid by cash on Jun 29, 2020. Storage deposit transferred from agreement A12-CT208013 to this agreement.","2020-06-19","20",0,null,0,"0","2","2020-06-29 14:44:03","2","2020-06-29 14:44:03","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,40484","C160193","PERSONAL","Mr","6PbxGXCeHIo\/MzWTc4fcRg==","oe4emdjBwqJ3qUpOcI17hw==","","JP4Rs\/ygk7B5+4qY1O\/77n4G4SUpGWQ1R+59le4zwir8onzHxmiKA5kLXAeJHhuO","3GH4gAMvtTCKkEWDOO\/eWw==",null,"m393lxqgH7t7KDeHWstXmg==",null,1,"4777"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","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":["8235","371","1528.0","1528.00","2","2020-06-29 14:44:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-19","2020-07-18","371"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 14:44:04","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":["8235",193,"SETTLED","A12-I208564","2020-06-29 14:44:03","2020-06-19","2","2020-06-29 14:44:03","2","2020-06-29 14:44:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","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":["8564","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-06-29 14:44:03","2","2020-06-29 14:44:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8564"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 14:44:04","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":[193,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208207","2020-06-29 14:44:03",1286,"2","2020-06-29 14:44:03","2","2020-06-29 14:44:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","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":["8207","DEPOSIT",null,"PAID","2020-06-29 14:44:03",0,"2","2020-06-29 14:44:03","2","2020-06-29 14:44:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 14:44:04","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":["8207","INVOICE","8564","PAID","2020-06-29 14:44:03",1286,"2","2020-06-29 14:44:03","2","2020-06-29 14:44:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:05","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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"512","master_room_id":"35","room_code":"K49"}],"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> K49 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D612256(7)","title":"Mr","lastname":"YU","firstname":"Chun Yip","companyname":"","email":"","tel":"98729311","address":"Flat E, 7\/F, Fu Hing Yuen, Block 20, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true,"customer_id":"1514","customer_code":"C201514","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"512","room_code":"K49","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":2196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3239,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"55.00","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-08-09","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by EPS on June 29, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":55,"order_total":3294,"final_order_total":3239,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076, 33825","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1098.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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","1514","NEW","A14-CT208236",1098,1098,2196,0,"1","1",3239,3294,3239,"2020-06-29 15:04:06","0",null,null,null,"2020-07-10","2020-08-09","1 month contract. Storage rental and deposit paid by EPS on June 29, 2020. ","2020-07-10","16",0,null,55,"55.00","2","2020-06-29 15:04:05","2","2020-06-29 15:04:05","EPS","","","","EPS","","","",null,0,"076, 33825","C201514","PERSONAL","Mr","hRdzpULvXqZc8yZLO430Jg==","4sZhlLfrmxrYN8eefiQ6Rg==","","hgKKZ\/pua0x41ySlpXfhxF1xcpxInmqku\/txM4dEpdZYc+7rYpScQcLYEwNCebrzd+4FGMTSE\/LYmonAI8aKgIGnZE+zk3nYoSwB7TFjl6Q=","TJG7aCKq7ZN5hCZlYEVwiw==",null,"bjZTHYGuzKcejIqUDuUGiw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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":["8236","512","1098.0","1098.00","2","2020-06-29 15:04:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-10","2020-08-09","512"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 15:04:06","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":["8236","A14-D205506","PAID",2196,0,"2020-08-09","2020-06-29 15:04:05","2020-06-29 15:04:05","2","2020-06-29 15:04:05","2","2020-06-29 15:04:05","1514"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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":["8236","1514","SETTLED","A14-I208565","2020-06-29 15:04:05","2020-07-10","2","2020-06-29 15:04:05","2","2020-06-29 15:04:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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":["8565","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1043,"MO","1",1043,"2","2020-06-29 15:04:05","2","2020-06-29 15:04:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1043,0,"8565"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 15:04:06","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":["1514","EPS","","","","EPS","","","","PAID","P208208","2020-06-29 15:04:05",3239,"2","2020-06-29 15:04:05","2","2020-06-29 15:04:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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":["8208","DEPOSIT","5506","PAID","2020-06-29 15:04:05",2196,"2","2020-06-29 15:04:05","2","2020-06-29 15:04:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:04:06","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":["8208","INVOICE","8565","PAID","2020-06-29 15:04:05",1043,"2","2020-06-29 15:04:05","2","2020-06-29 15:04:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 15:29:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"512","master_room_id":"35","room_code":"K49"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1244,"customer_code":"C191244","identity_type":"PERSONAL","identity_id":"E928641(5)","title":"Ms","lastname":"Rita","firstname":"Li","companyname":"","email":"lirita826@gmail.com","tel":"90193638","address":"Flat E, 33\/F, Block 22, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-26","renew_room_key":"111,41132","renew_remark":"1 month contract. Storage rental paid by cheque on May 20, 2020. Storage deposit $3056 transferred from agreement A12-CT207629 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT207629, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207903, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"84","room_code":"B32","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-26","rent_from":"2020-05-26","rent_to":"2020-06-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on June 29, 2020. Storage deposit $3056 transferred from agreement A12-CT207903 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"1","branch_id":"1","company_id":"1","room_key":"111,41132","order_product":[],"pass":true}},"first_order_id":"4814","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> B32 <\/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":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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",1244,"NEW","A12-CT208237",1528,1528,0,0,"1","1",1528,1528,1528,"2020-06-29 16:02:01","0",null,null,null,"2020-05-26","2020-06-25","1 month contract. Storage rental paid by cheque on June 29, 2020. Storage deposit $3056 transferred from agreement A12-CT207903 to this agreement.\r\n","2020-05-26","20",0,null,0,"0","2","2020-06-29 16:02:01","2","2020-06-29 16:02:01","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"111,41132","C191244","PERSONAL","Ms","7KCehmxbvwRMb+U8lHGoVA==","7pARLQpir8xN2i5gKtcUnA==","","Z5GlDhUn5j6Sl5tJu4OT2EJuraXC1l\/yNyJxswCPcFbWgMA1SHnsiuFyuKEqEVBuce98fM9hJIlGzBlrWRE\/Fw==","Mvs6ipJlHIfY+haMHCbc+A==","YnPhq\/0aL9f7zvnjRGMxCi9keRR0Q4\/DU5\/EdDPbYVA=","VyUMJBG3pFTIcqzAH4T+\/w==",null,1,"4814"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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":["8237","84","1528.0","1528.00","2","2020-06-29 16:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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-26","2020-06-25","84"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:02:01","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":["8237",1244,"SETTLED","A12-I208566","2020-06-29 16:02:01","2020-05-26","2","2020-06-29 16:02:01","2","2020-06-29 16:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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":["8566","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-06-29 16:02:01","2","2020-06-29 16:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"8566"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:02:01","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":[1244,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208209","2020-06-29 16:02:01",1528,"2","2020-06-29 16:02:01","2","2020-06-29 16:02:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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":["8209","DEPOSIT",null,"PAID","2020-06-29 16:02:01",0,"2","2020-06-29 16:02:01","2","2020-06-29 16:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:02:01","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":["8209","INVOICE","8566","PAID","2020-06-29 16:02:01",1528,"2","2020-06-29 16:02:01","2","2020-06-29 16:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"512","master_room_id":"35","room_code":"K49"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":982,"customer_code":"C180982","identity_type":"BUSINESS","identity_id":"09308671-000-10-17-2","title":"Ms","lastname":"Ip","firstname":"Man Hing","companyname":"Ching Ping Investment Co. Ltd.","email":"ipmanhing@netvigator.com","tel":"94899048","address":"14\/F AIE Building, 33 Connaught Road Central","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-16","renew_room_key":"0012385472,0012403797","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental will be paid by cheque on or before May 15, 2019. Storage deposit $1544 transferred from agreement A05-CT183630 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194909, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"111","order_discount":[],"order_room":[{"room_id":"1178","room_code":"A05-176","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":868,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"868.00","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2021-07-15","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194909 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":868,"order_total":11284,"final_order_total":10416,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385472,0012403797","order_product":[],"pass":true}},"first_order_id":"3630","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> A05-176 <\/td>\r\n\t\t\t\t\t 4X2X7 <\/td>\r\n\t\t\t\t\t $965.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":"8","total_discounted_price":"868.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",982,"NEW","A05-CT208238",965,868,0,0,"13","13",10416,11284,10416,"2020-06-29 16:05:15","0",null,null,null,"2020-06-16","2021-07-15","13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194909 to this agreement.","2020-06-16","8",0,null,868,"868.00","2","2020-06-29 16:05:14","2","2020-06-29 16:05:14","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012385472,0012403797","C180982","BUSINESS","Ms","bfESADT0mat0ZeyHOB0Y9w==","bXicfGTTHvCncWFCqwKkUQ==","Ching Ping Investment Co. Ltd.","yBeu2+3nQhSMpLylC1DMi1r9\/Jkv40R\/gNqor+9iE3Bb7R+82J8h8GxjMGjrCbm4","C+UdnbH9b+nGc043A1E1bQ==","5Y4GPJK5Bjm8imXTC3xshS29OlSJBabbaEcBzA+rOoA=",null,"HADgQ\/UX35Ceam8WH5lBof+4SD9yCsLrX6INdvBqUKI=",1,"3630"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8238","1178","965.0","965.00","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-16","2021-07-15","1178"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8238",982,"SETTLED","A05-I208567","2020-06-29 16:05:14","2020-06-16","2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8567","RENT","\u9810\u7e73\u79df\u91d1",13,868,"MO","1",868,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10416,0,"8567"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[982,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208210","2020-06-29 16:05:14",10416,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8210","DEPOSIT",null,"PAID","2020-06-29 16:05:14",0,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:05:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8210","INVOICE","8567","PAID","2020-06-29 16:05:14",10416,"2","2020-06-29 16:05:14","2","2020-06-29 16:05:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"512","master_room_id":"35","room_code":"K49"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":982,"customer_code":"C180982","identity_type":"BUSINESS","identity_id":"09308671-000-10-17-2","title":"Ms","lastname":"Ip","firstname":"Man Hing","companyname":"Ching Ping Investment Co. Ltd.","email":"ipmanhing@netvigator.com","tel":"94899048","address":"14\/F AIE Building, 33 Connaught Road Central","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-16","renew_room_key":"0012385472,0012403797","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental will be paid by cheque on or before May 15, 2019. Storage deposit $1544 transferred from agreement A05-CT183631 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194910, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"111","order_discount":[],"order_room":[{"room_id":"1179","room_code":"A05-177","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":868,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"868","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2021-07-15","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194910 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":868,"order_total":11284,"final_order_total":10416,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385472,0012403797","order_product":[],"pass":true}},"first_order_id":"3631","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> A05-177 <\/td>\r\n\t\t\t\t\t 4X2X7 <\/td>\r\n\t\t\t\t\t $965.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":"8","total_discounted_price":"868.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",982,"NEW","A05-CT208239",965,868,0,0,"13","13",10416,11284,10416,"2020-06-29 16:07:27","0",null,null,null,"2020-06-16","2021-07-15","13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194910 to this agreement.","2020-06-16","8",0,null,868,"868","2","2020-06-29 16:07:27","2","2020-06-29 16:07:27","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012385472,0012403797","C180982","BUSINESS","Ms","bfESADT0mat0ZeyHOB0Y9w==","bXicfGTTHvCncWFCqwKkUQ==","Ching Ping Investment Co. Ltd.","yBeu2+3nQhSMpLylC1DMi1r9\/Jkv40R\/gNqor+9iE3Bb7R+82J8h8GxjMGjrCbm4","C+UdnbH9b+nGc043A1E1bQ==","5Y4GPJK5Bjm8imXTC3xshS29OlSJBabbaEcBzA+rOoA=",null,"HADgQ\/UX35Ceam8WH5lBof+4SD9yCsLrX6INdvBqUKI=",1,"3631"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8239","1179","965.0","965.00","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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-06-16","2021-07-15","1179"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:07: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":["8239",982,"SETTLED","A05-I208568","2020-06-29 16:07:27","2020-06-16","2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8568","RENT","\u9810\u7e73\u79df\u91d1",13,868,"MO","1",868,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10416,0,"8568"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:07: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":[982,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208211","2020-06-29 16:07:27",10416,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8211","DEPOSIT",null,"PAID","2020-06-29 16:07:27",0,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:07: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":["8211","INVOICE","8568","PAID","2020-06-29 16:07:27",10416,"2","2020-06-29 16:07:27","2","2020-06-29 16:07:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:11","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&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"512","master_room_id":"35","room_code":"K49"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":982,"customer_code":"C180982","identity_type":"BUSINESS","identity_id":"09308671-000-10-17-2","title":"Ms","lastname":"Ip","firstname":"Man Hing","companyname":"Ching Ping Investment Co. Ltd.","email":"ipmanhing@netvigator.com","tel":"94899048","address":"14\/F AIE Building, 33 Connaught Road Central","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-16","renew_room_key":"0012385472,0012403797","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental will be paid by cheque on or before May 15, 2019. Storage deposit $1544 transferred from agreement A05-CT183632 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194912, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"111","order_discount":[],"order_room":[{"room_id":"1180","room_code":"A05-178","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":868,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"868.00","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2021-07-15","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194912 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":868,"order_total":11284,"final_order_total":10416,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385472,0012403797","order_product":[],"pass":true}},"first_order_id":"3632","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> A05-178 <\/td>\r\n\t\t\t\t\t 4X2X7 <\/td>\r\n\t\t\t\t\t $965.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":"8","total_discounted_price":"868.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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",982,"NEW","A05-CT208240",965,868,0,0,"13","13",10416,11284,10416,"2020-06-29 16:09:12","0",null,null,null,"2020-06-16","2021-07-15","13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on June 29, 2020. Storage deposit $1544 transferred from agreement A05-CT194912 to this agreement.\r\n","2020-06-16","8",0,null,868,"868.00","2","2020-06-29 16:09:11","2","2020-06-29 16:09:11","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012385472,0012403797","C180982","BUSINESS","Ms","bfESADT0mat0ZeyHOB0Y9w==","bXicfGTTHvCncWFCqwKkUQ==","Ching Ping Investment Co. Ltd.","yBeu2+3nQhSMpLylC1DMi1r9\/Jkv40R\/gNqor+9iE3Bb7R+82J8h8GxjMGjrCbm4","C+UdnbH9b+nGc043A1E1bQ==","5Y4GPJK5Bjm8imXTC3xshS29OlSJBabbaEcBzA+rOoA=",null,"HADgQ\/UX35Ceam8WH5lBof+4SD9yCsLrX6INdvBqUKI=",1,"3632"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8240","1180","965.0","965.00","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-16","2021-07-15","1180"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:09:12","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":["8240",982,"SETTLED","A05-I208569","2020-06-29 16:09:11","2020-06-16","2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8569","RENT","\u9810\u7e73\u79df\u91d1",13,868,"MO","1",868,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10416,0,"8569"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:09:12","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":[982,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208212","2020-06-29 16:09:11",10416,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8212","DEPOSIT",null,"PAID","2020-06-29 16:09:11",0,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:09:12","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":["8212","INVOICE","8569","PAID","2020-06-29 16:09:11",10416,"2","2020-06-29 16:09:11","2","2020-06-29 16:09:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1290,"customer_code":"C191290","identity_type":"PERSONAL","identity_id":"G199738(5)","title":"Ms","lastname":"WONG","firstname":"Lai Van Teresa","companyname":"","email":"teresalvwong@gmail.com","tel":"97620882","address":"Flat E, 3\/F Golden Maple Court, Full Wealth GDNS, 9-10 Kai Yuen Terrace, North Point.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1817.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-06","renew_room_key":"'0012403751","renew_remark":"12 months contract. Special offer 2 months free, $500 discount from coupon and $400 Discount for "change Storage". Storage rental and deposit paid by EPS on May 8, 2019. Smartcard provided on May 8, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195180, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2018.0","renew_master_room_id":"188","order_discount":[{"master_room_discount_id":"428","master_room_id":"188","discount_type":"%","price":"1938.00","disocunted_price":"1454.90","discount":"24.93","monthly_deduct":483.1434,"room_id":"1406","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1406","room_code":"C15-100","retail_price":"1938.0","discounted_price":1454.9,"location_id":"6"}],"roughly_size":"35","total_retail_price":1938,"total_discounted_price":1817,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10902,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-01-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $2018 transferred from agreement C15-CT195180 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10902,"final_order_total":10902,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012403751","order_product":[],"pass":true}},"first_order_id":5180,"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> C15-100 <\/td>\r\n\t\t\t\t\t 7X5X6.5 <\/td>\r\n\t\t\t\t\t $1938.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":"35","total_discounted_price":"1817.00","deposit":"0.00","total_retail_price":"1938.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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","3","6",1290,"NEW","C15-CT208241",1938,1817,0,0,"6","6",10902,10902,10902,"2020-06-29 16:15:18","0",null,null,null,"2020-07-06","2021-01-05","6 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $2018 transferred from agreement C15-CT195180 to this agreement.","2020-07-06","35",0,null,0,"0","2","2020-06-29 16:15:17","2","2020-06-29 16:15:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012403751","C191290","PERSONAL","Ms","EDpog\/U7lsLMwjFWJlA8pw==","ddrfzAYTmkL\/QNu3psjONQ==","","39D+7nslOZ+RJCm3oX45pucNEtBOKKummF6ys28TxG84fnPh9pJsxr8SXVzB4jNVFwPCxhTvsg08xoMBPG3i\/4pup\/kAsVnzFEfgJJULaIbgMYcpPXrHHx5tKSndOhRK","2RCVPT+fm9k++zUJ7svvHA==","9im9II9O0K67buPp0CRV5QSfb\/Rg6eDHYB4l8+6V1B0=","ozIIKZ\/q2GcsDzrceGqN8Q==",null,1,5180]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8241","428","188","1406","%","24.93",483.1434,"2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8241","1406","1938.0",1454.9,"2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2021-01-05","1406"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:15:18","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":["8241",1290,"SETTLED","C15-I208570","2020-06-29 16:15:17","2020-07-06","2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",1,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",2,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",3,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",4,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",5,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8570","RENT","\u9810\u7e73\u79df\u91d1",6,1817,"MO","1",1817,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10902,0,"8570"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:15:18","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":[1290,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208213","2020-06-29 16:15:17",10902,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8213","DEPOSIT",null,"PAID","2020-06-29 16:15:17",0,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:15:18","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":["8213","INVOICE","8570","PAID","2020-06-29 16:15:17",10902,"2","2020-06-29 16:15:17","2","2020-06-29 16:15:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:32:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:37:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:22","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1647","master_room_id":"206","room_code":"A16-156"}],"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-156 <\/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> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D566539(7)","title":"Mr","lastname":"LAI","firstname":"Siu Fai","companyname":"","email":"","tel":"90426501","address":"Room 301, Yat Fai House, Yue Fai Court, Shek Pei Wan, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1647","room_code":"A16-156","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":4322,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7565,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3240.00","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2020-10-14","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cash on June 29, 2020. Smartcard and padlock provided on June 29, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3240,"order_total":10805,"final_order_total":7565,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190, 61282","order_product":[],"pass":true}},"roughly_size":"28","total_discounted_price":"2161.00","deposit":"4322.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:23","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":["C201644","PERSONAL","Mr","oMVGeCm8WBCR2o0n0feOIA==","8hiEOuVVoOMleTEBdtujcw==","","Ow22AtMV71pcSq9U5jNZxg==",null,"0\/LmtDCb5zRcsMybbGzvk0wcQNq+6Krn\/dSoqQfNPjgNgmeuAqK8ij\/U2n19ZPQpAVBICctNFMj22HxU7nLyJA==","+7\/3mgEKcj7EDRzscECtJA==",null,null,"oQSB71b1dvz6uede\/XjOCw==","2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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",1644,"NEW","A16-CT208242",2161,2161,4322,0,"3","3",7565,10805,7565,"2020-06-29 16:52:24","0",null,null,null,"2020-07-15","2020-10-14","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cash on June 29, 2020. Smartcard and padlock provided on June 29, 2020. ","2020-07-15","28",0,null,3240,"3240.00","2","2020-06-29 16:52:22","2","2020-06-29 16:52:22","CASH","","","","CASH","","","",null,0,"190, 61282","C201644","PERSONAL","Mr","oMVGeCm8WBCR2o0n0feOIA==","8hiEOuVVoOMleTEBdtujcw==","","0\/LmtDCb5zRcsMybbGzvk0wcQNq+6Krn\/dSoqQfNPjgNgmeuAqK8ij\/U2n19ZPQpAVBICctNFMj22HxU7nLyJA==","Ow22AtMV71pcSq9U5jNZxg==",null,"+7\/3mgEKcj7EDRzscECtJA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8242","1647","2161.0","2161.00","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-15","2020-10-14","1647"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 16:52:24","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":["8242","A16-D205507","PAID",4322,0,"2020-10-14","2020-06-29 16:52:22","2020-06-29 16:52:22","2","2020-06-29 16:52:22","2","2020-06-29 16:52:22",1644]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8242",1644,"SETTLED","A16-I208571","2020-06-29 16:52:22","2020-07-15","2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8571","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8571","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1082,"MO","1",1082,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8571","RENT","\u9810\u7e73\u79df\u91d1",3,2161,"MO","1",2161,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3243,0,"8571"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 16:52:24","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":[1644,"CASH","","","","CASH","","","","PAID","P208214","2020-06-29 16:52:22",7565,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8214","DEPOSIT","5507","PAID","2020-06-29 16:52:22",4322,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 16:52:24","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":["8214","INVOICE","8571","PAID","2020-06-29 16:52:22",3243,"2","2020-06-29 16:52:22","2","2020-06-29 16:52:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:26:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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=1057&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1244,"customer_code":"C191244","identity_type":"PERSONAL","identity_id":"E928641(5)","title":"Ms","lastname":"Rita","firstname":"Li","companyname":"","email":"lirita826@gmail.com","tel":"90193638","address":"Flat E, 33\/F, Block 22, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-26","renew_room_key":"111,41132","renew_remark":"1 month contract. Storage rental paid by cheque on June 29, 2020. Storage deposit $3056 transferred from agreement A12-CT207903 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208237, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"84","room_code":"B32","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2020-07-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on June 29, 2020. Storage deposit $3056 transferred from agreement A12-CT208237 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"1","branch_id":"1","company_id":"1","room_key":"111,41132","order_product":[],"pass":true}},"first_order_id":"4814","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> B32 <\/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":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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","1",1244,"NEW","A12-CT208243",1528,1528,0,0,"1","1",1528,1528,1528,"2020-06-29 18:30:54","0",null,null,null,"2020-06-26","2020-07-25","1 month contract. Storage rental paid by cheque on June 29, 2020. Storage deposit $3056 transferred from agreement A12-CT208237 to this agreement.","2020-06-26","20",0,null,0,"0","2","2020-06-29 18:30:53","2","2020-06-29 18:30:53","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"111,41132","C191244","PERSONAL","Ms","7KCehmxbvwRMb+U8lHGoVA==","7pARLQpir8xN2i5gKtcUnA==","","Z5GlDhUn5j6Sl5tJu4OT2EJuraXC1l\/yNyJxswCPcFbWgMA1SHnsiuFyuKEqEVBuce98fM9hJIlGzBlrWRE\/Fw==","Mvs6ipJlHIfY+haMHCbc+A==","YnPhq\/0aL9f7zvnjRGMxCi9keRR0Q4\/DU5\/EdDPbYVA=","VyUMJBG3pFTIcqzAH4T+\/w==",null,1,"4814"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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":["8243","84","1528.0","1528.00","2","2020-06-29 18:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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-06-26","2020-07-25","84"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 18:30: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":["8243",1244,"SETTLED","A12-I208572","2020-06-29 18:30:53","2020-06-26","2","2020-06-29 18:30:53","2","2020-06-29 18:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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":["8572","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-06-29 18:30:53","2","2020-06-29 18:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"8572"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 18:30: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":[1244,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208215","2020-06-29 18:30:53",1528,"2","2020-06-29 18:30:53","2","2020-06-29 18:30:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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":["8215","DEPOSIT",null,"PAID","2020-06-29 18:30:53",0,"2","2020-06-29 18:30:53","2","2020-06-29 18:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:30: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":["8215","INVOICE","8572","PAID","2020-06-29 18:30:53",1528,"2","2020-06-29 18:30:53","2","2020-06-29 18:30:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:34:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:34:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:42:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1340,"customer_code":"C191340","identity_type":"PERSONAL","identity_id":"D804254(4)","title":"Ms","lastname":"Li","firstname":"Kam Ying","companyname":"","email":"kyli70@yahoo.com.hk","tel":"91846991","address":"21\/F, Cityplaza Three, 14 Taikoo Shing Road, Taikoo Shing, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-23","renew_room_key":"190,26383","renew_remark":"1 month contract. Storage rental $639 paid by PPS on March 31, 2020. Remaining balance $966 transferred from last agreement. Storage deposit $3210 transferred from agreement WC-CT207248 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: WC-CT207546, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"228","order_discount":[],"order_room":[{"room_id":"1767","room_code":"WC-25","retail_price":"0.0","discounted_price":"0.00","location_id":"8"}],"roughly_size":"20","total_retail_price":0,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-23","rent_from":"2020-04-23","rent_to":"2020-07-22","delivery_service":"0","remark":"3 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement WC-CT207546 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190,26383","order_product":[],"pass":true,"paymethod_other2":""}},"first_order_id":"7248","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> WC-25 <\/td>\r\n\t\t\t\t\t 5X4X8 <\/td>\r\n\t\t\t\t\t $0.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":"20","total_discounted_price":"1525.00","deposit":"0.00","total_retail_price":"0.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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","8",1340,"NEW","WC-CT208244",0,1525,0,0,"3","3",4575,4575,4575,"2020-06-29 18:47:33","0",null,null,null,"2020-04-23","2020-07-22","3 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement WC-CT207546 to this agreement. \r\n","2020-04-23","20",0,null,0,"0","2","2020-06-29 18:47:32","2","2020-06-29 18:47:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26383","C191340","PERSONAL","Ms","JdQzQv+uksVt7YfqRkcs2g==","7KCehmxbvwRMb+U8lHGoVA==","","Hk9QjTXPPZugpENsJNJVRFjDshAXCfqBJdXMP\/Va7d3Z2K\/aCGuUUGkjQYrRlPUPOZljB3ovRTE6wx9XrkHxgBiZiPEw1x7TWdiJCF8+iP8=","u\/RO33AxBdDZLcxr\/eihQw==","rD9Syyb4nHCPJX+uzCXhPgdBRpQS4iLmKGxvb8tt99M=","pljIbpMDyGb8muJ6+q40Nw==",null,1,"7248"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8244","1767","0.0","0.00","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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-23","2020-07-22","1767"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 18:47:33","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":["8244",1340,"SETTLED","WC-I208573","2020-06-29 18:47:32","2020-04-23","2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8573","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8573","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8573","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"8573"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 18:47:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1340,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208216","2020-06-29 18:47:32",4575,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8216","DEPOSIT",null,"PAID","2020-06-29 18:47:32",0,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:47:33","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":["8216","INVOICE","8573","PAID","2020-06-29 18:47:32",4575,"2","2020-06-29 18:47:32","2","2020-06-29 18:47:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:49:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:55:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:56:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:01","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":877,"customer_code":"C180877","identity_type":"PERSONAL","identity_id":"R938804(3)","title":"Ms","lastname":"Cameron","firstname":"Ekaterina","companyname":"","email":"info@nasonpearl.com","tel":"97337317","address":"Flat 2135, 21\/F, Tower 5, Hong Kong Parkview, 88 Tai Tam Reservoir Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3462.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"190,40465,189,29022","renew_remark":"1 months contract. Storage rental paid by bank transfer on June 2, 2020. Storage deposit transferred from agreement A18-CT207833 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208016, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"846","room_code":"S05","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"},{"room_id":"810","room_code":"Q07","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"44","total_retail_price":3462,"total_discounted_price":3462,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3462,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement A18-CT208016 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3462,"final_order_total":3462,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40465,189,29022","order_product":[],"pass":true}},"first_order_id":"4121","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> S05 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> Q07 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.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":"44","total_discounted_price":"3462.0","deposit":"0","total_retail_price":"3462.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","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",877,"NEW","A18-CT208245",3462,3462,0,0,"1","1",3462,3462,3462,"2020-06-29 18:58:02","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement A18-CT208016 to this agreement.\r\n","2020-06-01","44",0,null,0,"0","2","2020-06-29 18:58:01","2","2020-06-29 18:58:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40465,189,29022","C180877","PERSONAL","Ms","RPthaial2IFX5OTQVN1g+A==","5j4q6ReeucnDk5XYC2qhww==","","rRXmSas1C74UhCIMAl4XVBNkmNxuyBYhPciKj+xVXn2vQd37Gl4JOgs8HGkmy+xJFTDVdTpVVL4FPjZ3S+Pjo17HXHrjXmDiJKqKzjzyVmbMcgqz6jBEyLIHEHGxlwsr","c+0bwcSjwgphezD5fySi+g==","k2\/+w1ZaM4nSEX\/8U65t74fzkbo4RpcfhFOMFpzQU3M=","2SUKxPo6VxWobmWOngKfJg==",null,1,"4121"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","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":["8245","846","1857.0","1857.00","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","846"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 18:58:02","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":["8245","810","1605.0","1605.00","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","810"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 18:58:02","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":["8245",877,"SETTLED","A18-I208574","2020-06-29 18:58:01","2020-06-01","2","2020-06-29 18:58:01","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","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":["8574","RENT","\u9810\u7e73\u79df\u91d1",1,3462,"MO","1",3462,"2","2020-06-29 18:58:01","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3462,0,"8574"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 18:58:02","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":[877,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208217","2020-06-29 18:58:01",3462,"2","2020-06-29 18:58:01","2","2020-06-29 18:58:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","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":["8217","DEPOSIT",null,"PAID","2020-06-29 18:58:01",0,"2","2020-06-29 18:58:01","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 18:58:02","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":["8217","INVOICE","8574","PAID","2020-06-29 18:58:01",3462,"2","2020-06-29 18:58:01","2","2020-06-29 18:58:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:51","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-27","renew_room_key":"052,49830","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit transferred from agreement A12-CT207743 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207970, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"362","room_code":"G03","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-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement A12-CT207970 to this agreement.","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":"052,49830","order_product":[],"pass":true}},"first_order_id":"4668","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> G03 <\/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.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","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",57,"NEW","A12-CT208246",1528,1286,0,0,"1","1",1286,1286,1286,"2020-06-29 19:04:52","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement A12-CT207970 to this agreement.","2020-06-27","20",0,null,0,"0","2","2020-06-29 19:04:51","2","2020-06-29 19:04:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4668"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","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":["8246","362","1528.0","1528.00","2","2020-06-29 19:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-27","2020-07-26","362"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 19:04:52","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":["8246",57,"SETTLED","A12-I208575","2020-06-29 19:04:51","2020-06-27","2","2020-06-29 19:04:51","2","2020-06-29 19:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","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":["8575","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-06-29 19:04:51","2","2020-06-29 19:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8575"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 19:04:52","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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208218","2020-06-29 19:04:51",1286,"2","2020-06-29 19:04:51","2","2020-06-29 19:04:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","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":["8218","DEPOSIT",null,"PAID","2020-06-29 19:04:51",0,"2","2020-06-29 19:04:51","2","2020-06-29 19:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:04:52","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":["8218","INVOICE","8575","PAID","2020-06-29 19:04:51",1286,"2","2020-06-29 19:04:51","2","2020-06-29 19:04:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:07:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:08:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:10:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:10:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12:32","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":"286","master_room_id":"6","room_code":"E13"}],"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> E13 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R370487(3)","title":"Ms","lastname":"FUNG","firstname":"Man Yee","companyname":"","email":"fungmanyee2011@yahoo.com.hk","tel":"61295040","address":"Flat 218, 2F, Pik Yuen House, Shek Pik Wan Estate, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"286","room_code":"E13","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":1996,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2994,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by EPS on June 29, 2020. Smartcard and padlock provided on June 29, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":2994,"final_order_total":2994,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 38733","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12:34","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":["C201645","PERSONAL","Ms","7Wnb8ujWtKDLtFcJ1EFeBg==","cyZbjLKMtXmsqxQPpU0UpA==","","cNGNOLx1bVVNY42O+UqmGw==","Tr8mwvOlHr13HI80FCWvLgaT2saUpGsxG8RihNKjYKY=","Euxdmq8m1aidbLGmv+uJnDSdnO8E5RbiblHu7yqSOo9E+eUAd8kTSVitx6hR4Hn5aXzAT6FV10SBGM5LK38OFA==","HYRW+ZIZlfyXBV6Vvra3uw==",null,"Tr8mwvOlHr13HI80FCWvLgaT2saUpGsxG8RihNKjYKY=","1Q7tDb4hs8XRYCkBFULCgQ==","2","2020-06-29 19:12:32","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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` = ?","parameters":["1","1","1",1645,"NEW","A12-CT208247",998,998,1996,0,"1","1",2994,2994,2994,"2020-06-29 19:12:34","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental and deposit paid by EPS on June 29, 2020. Smartcard and padlock provided on June 29, 2020. ","2020-07-01","12",0,null,0,"0","2","2020-06-29 19:12:32","2","2020-06-29 19:12:32","EPS","","","","EPS","","","",null,0,"190, 38733","C201645","PERSONAL","Ms","7Wnb8ujWtKDLtFcJ1EFeBg==","cyZbjLKMtXmsqxQPpU0UpA==","","Euxdmq8m1aidbLGmv+uJnDSdnO8E5RbiblHu7yqSOo9E+eUAd8kTSVitx6hR4Hn5aXzAT6FV10SBGM5LK38OFA==","cNGNOLx1bVVNY42O+UqmGw==","Tr8mwvOlHr13HI80FCWvLgaT2saUpGsxG8RihNKjYKY=","HYRW+ZIZlfyXBV6Vvra3uw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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":["8247","286","998.0","998.00","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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-07-01","2020-07-31","286"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-29 19:12:34","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":["8247","A12-D205508","PAID",1996,0,"2020-07-31","2020-06-29 19:12:32","2020-06-29 19:12:32","2","2020-06-29 19:12:32","2","2020-06-29 19:12:32",1645]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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":["8247",1645,"SETTLED","A12-I208576","2020-06-29 19:12:32","2020-07-01","2","2020-06-29 19:12:32","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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":["8576","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-29 19:12:32","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8576"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-29 19:12: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":[1645,"EPS","","","","EPS","","","","PAID","P208219","2020-06-29 19:12:32",2994,"2","2020-06-29 19:12:32","2","2020-06-29 19:12:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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":["8219","DEPOSIT","5508","PAID","2020-06-29 19:12:32",1996,"2","2020-06-29 19:12:32","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-29 19:12: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":["8219","INVOICE","8576","PAID","2020-06-29 19:12:32",998,"2","2020-06-29 19:12:32","2","2020-06-29 19:12:32"]},"data_before":[],"data_after":[],"step":1} *****