{"created_at":"2020-08-06 09:42:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 09:55:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:09:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:11:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:14:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=679&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by PPS on July 3, 2020. Storage deposit transferred from agreement A18-CT208031 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208359, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-03","rent_from":"2020-08-03","rent_to":"2020-09-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A18-CT208359 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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>
T03 <\/td>\r\n\t\t\t\t\t	6X6X7 <\/td>\r\n\t\t\t\t\t	$2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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",679,"NEW","A18-CT208596",2728,2728,0,0,"1","1",2728,2728,2728,"2020-08-06 10:15:00","0",null,null,null,"2020-08-03","2020-09-02","1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A18-CT208359 to this agreement.\r\n\r\n","2020-08-03","36",0,null,0,"0","2","2020-08-06 10:14:59","2","2020-08-06 10:14:59","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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":["8596","859","2728.0","2728.00","2","2020-08-06 10:14:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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-08-03","2020-09-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 10:15:00","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":["8596",679,"SETTLED","A18-I208925","2020-08-06 10:14:59","2020-08-03","2","2020-08-06 10:14:59","2","2020-08-06 10:14:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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":["8925","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-08-06 10:14:59","2","2020-08-06 10:14:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"8925"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 10:15:00","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":[679,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208568","2020-08-06 10:14:59",2728,"2","2020-08-06 10:14:59","2","2020-08-06 10:14:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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":["8568","DEPOSIT",null,"PAID","2020-08-06 10:14:59",0,"2","2020-08-06 10:14:59","2","2020-08-06 10:14:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:15:00","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":["8568","INVOICE","8925","PAID","2020-08-06 10:14:59",2728,"2","2020-08-06 10:14:59","2","2020-08-06 10:14:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:17:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:25:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:26:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:32:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:38:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:06","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=1&filter2=1555&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1555,"customer_code":"C201555","identity_type":"PERSONAL","identity_id":"K701205","title":"Mr","lastname":"Chau","firstname":"Kin Lam","companyname":"","email":"ztazta8888@hotmail.com","tel":"91992027","address":"Room 621, Wah Sin House, Wah Kwai Est","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"4","renew_warehousing_date":"2020-08-15","renew_room_key":"190, 10773","renew_remark":"4 months contract, 50% off for the first 3 months. Storage rental and deposit paid by cash on April 14, 2020. Smart card provided on April 14, 2020.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207606, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2684.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"528","room_code":"L06(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1342,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-15","rent_from":"2020-08-15","rent_to":"2020-09-14","delivery_service":"0","remark":"1 month contract.Storage rental is paid by PPS on Aug 5, 2020. Smart card provided on April 14, 2020.\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207606, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2684.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1342,"final_order_total":1342,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190, 10773","order_product":[],"pass":true}},"first_order_id":7606,"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> L06(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1342.00","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1555,"NEW","A14-CT208597",1342,1342,0,0,"1","1",1342,1342,1342,"2020-08-06 10:43:07","0",null,null,null,"2020-08-15","2020-09-14","1 month contract.Storage rental is paid by PPS on Aug 5, 2020. Smart card provided on April 14, 2020.\r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207606, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2684.0","2020-08-15","16",0,null,0,"0","2","2020-08-06 10:43:06","2","2020-08-06 10:43:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190, 10773","C201555","PERSONAL","Mr","fYDKggz8obyvsd0TEBK5+w==","kOK3vHUlGE9qjoVnzYRDGA==","","BC5XeeE0cvhpgrhmZz\/woydrjc\/Sy2VTOVsMlj5T42GPfnIQRDwswpBnBA4a\/VoV","6MG6cjAx8MTkt7RtM2VhRA==","Li57sBQcEthi1e+1jTTU1euBwCfkGtuZkO4ybdPJg6A=","KDOs0a4ZYZ07a2i5CYX58w==",null,1,7606]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","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":["8597","528","1342.0","1342.00","2","2020-08-06 10:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","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-08-15","2020-09-14","528"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 10:43:07","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":["8597",1555,"SETTLED","A14-I208926","2020-08-06 10:43:06","2020-08-15","2","2020-08-06 10:43:06","2","2020-08-06 10:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","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":["8926","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-08-06 10:43:06","2","2020-08-06 10:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"8926"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 10:43:07","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":[1555,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208569","2020-08-06 10:43:06",1342,"2","2020-08-06 10:43:06","2","2020-08-06 10:43:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","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":["8569","DEPOSIT",null,"PAID","2020-08-06 10:43:06",0,"2","2020-08-06 10:43:06","2","2020-08-06 10:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:43:07","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":["8569","INVOICE","8926","PAID","2020-08-06 10:43:06",1342,"2","2020-08-06 10:43:06","2","2020-08-06 10:43:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47:33","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=1&filter2=506&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-17","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on July 8, 2020. Storage deposit transferred from agreement A12-CT208030 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208369, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2020-08-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A12-CT208370 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4179","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> B61 <\/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":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT208598",998,998,0,0,"1","1",998,998,998,"2020-08-06 10:47:34","0",null,null,null,"2020-07-15","2020-08-14","1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A12-CT208370 to this agreement.\r\n\r\n","2020-07-15","12",0,null,0,"0","2","2020-08-06 10:47:33","2","2020-08-06 10:47:33","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47: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":["8598","243","998.0","998.00","2","2020-08-06 10:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47: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-15","2020-08-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 10:47: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":["8598",506,"SETTLED","A12-I208927","2020-08-06 10:47:33","2020-07-15","2","2020-08-06 10:47:33","2","2020-08-06 10:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47: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":["8927","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-08-06 10:47:33","2","2020-08-06 10:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8927"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 10:47: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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208570","2020-08-06 10:47:33",998,"2","2020-08-06 10:47:33","2","2020-08-06 10:47:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47: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":["8570","DEPOSIT",null,"PAID","2020-08-06 10:47:33",0,"2","2020-08-06 10:47:33","2","2020-08-06 10:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:47: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":["8570","INVOICE","8927","PAID","2020-08-06 10:47:33",998,"2","2020-08-06 10:47:33","2","2020-08-06 10:47:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=506&filter3=undefined","warehousing":{"2":{"order_discount":[],"order_room":[{"room_id":"113","room_code":"B61","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-07-17","rent_from":"2020-07-17","rent_to":"2020-08-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A12-CT208369 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true,"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-17","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on July 8, 2020. Storage deposit transferred from agreement A12-CT208030 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208369, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10"},"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true}},"renew":1,"first_order_id":"4179","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> B61 <\/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-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT208599",1528,1286,0,0,"1","1",1286,1286,1286,"2020-08-06 10:49:50","0",null,null,null,"2020-07-17","2020-08-16","1 month contract. Storage rental paid by PPS on Aug 5, 2020. Storage deposit transferred from agreement A12-CT208369 to this agreement.\r\n\r\n","2020-07-17","20",0,null,0,"0","2","2020-08-06 10:49:49","2","2020-08-06 10:49:49","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8599","113","1528.0","1528.00","2","2020-08-06 10:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-08-16","113"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8599",506,"SETTLED","A12-I208928","2020-08-06 10:49:49","2020-07-17","2","2020-08-06 10:49:49","2","2020-08-06 10:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8928","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-08-06 10:49:49","2","2020-08-06 10:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8928"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208571","2020-08-06 10:49:49",1286,"2","2020-08-06 10:49:49","2","2020-08-06 10:49:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8571","DEPOSIT",null,"PAID","2020-08-06 10:49:49",0,"2","2020-08-06 10:49:49","2","2020-08-06 10:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 10:49:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8571","INVOICE","8928","PAID","2020-08-06 10:49:49",1286,"2","2020-08-06 10:49:49","2","2020-08-06 10:49:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:06:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:11:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:13:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:19:55","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190, 39747","3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. $438 paid by bank transfer on Aug 05, 2020. Smart card provided by mail on the same day.","2020-08-06 11:19:55","2","ch5RTqSd49z177L3nG78qg==","qCScY6UfjyMiGOl6hds7CA==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","GWFwLDpz\/r49PIuSeWz2Yw==","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn",8594]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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","index_url_parameter":"filter1=2&filter2=566&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 12, 2020. Storage deposit transferred from agreement A14-CT207848 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208164, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-08-09","delivery_service":"0","remark":"1 month contract. Storage rental $4999 paid by bank transfer on June 30, 2020. Outstanding $500 will be transferred to the next contract. Storage deposit transferred from agreement A14-CT208164 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","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\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> K59 <\/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> K58 <\/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> K57 <\/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> K56 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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":"72","total_discounted_price":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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","2",423,"NEW","A14-CT208600",5062,4499,0,0,"1","1",4499,4499,4499,"2020-08-06 11:20:33","0",null,null,null,"2020-07-10","2020-08-09","1 month contract. Storage rental $4999 paid by bank transfer on June 30, 2020. Outstanding $500 will be transferred to the next contract. Storage deposit transferred from agreement A14-CT208164 to this agreement.","2020-07-10","72",0,null,0,"0","2","2020-08-06 11:20:32","2","2020-08-06 11:20:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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":["8600","522","1098.0","1098.00","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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-07-10","2020-08-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 11:20: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":["8600","521","1098.0","1098.00","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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-07-10","2020-08-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 11:20: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":["8600","520","1098.0","1098.00","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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-07-10","2020-08-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 11:20: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":["8600","519","1768.0","1768.00","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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-07-10","2020-08-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 11:20: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":["8600",423,"SETTLED","A14-I208929","2020-08-06 11:20:32","2020-07-10","2","2020-08-06 11:20:32","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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":["8929","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-08-06 11:20:32","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"8929"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 11:20: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":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208572","2020-08-06 11:20:32",4499,"2","2020-08-06 11:20:32","2","2020-08-06 11:20:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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":["8572","DEPOSIT",null,"PAID","2020-08-06 11:20:32",0,"2","2020-08-06 11:20:32","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:20: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":["8572","INVOICE","8929","PAID","2020-08-06 11:20:32",4499,"2","2020-08-06 11:20:32","2","2020-08-06 11:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:27:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"822","master_room_id":"106","room_code":"Q19"}],"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> Q19 <\/td>\r\n\t\t\t\t\t 4X4.5X7 <\/td>\r\n\t\t\t\t\t $1.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"M258495(3)","title":"Mr","lastname":"YANG","firstname":"Diao","companyname":"","email":"skyd1933@aliyun.com","tel":"63129823","address":"Room 1805, 18\/F, Block C, Causeway Centre, No.28 Harbour Road, Wan Chai Hong Kong ","pass":true,"customer_id":"1700","customer_code":"C201700","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"822","room_code":"Q19","retail_price":"1.0","discounted_price":"1.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1,"total_discounted_price":654,"deposit":1376,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3338,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2020-11-03","delivery_service":"0","remark":"3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. $438 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3338,"final_order_total":3338,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,39747","order_product":[],"pass":true}},"roughly_size":"18","total_discounted_price":"654.00","deposit":"1376.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3","1700","NEW","A18-CT208601",1,654,1376,0,"3","3",3338,3338,3338,"2020-08-06 11:47:47","0",null,null,null,"2020-08-04","2020-11-03","3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. $438 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-08-04","18",0,null,0,"0.00","2","2020-08-06 11:47:47","2","2020-08-06 11:47:47","BANKIN","","","","BANKIN","","","",null,0,"190,39747","C201700","PERSONAL","Mr","qCScY6UfjyMiGOl6hds7CA==","ch5RTqSd49z177L3nG78qg==","","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn","GWFwLDpz\/r49PIuSeWz2Yw==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","NGVeC21ox\/nD+jsQrlO9zA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8601","822","1.0","1.00","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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-08-04","2020-11-03","822"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 11:47:47","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":["8601","A18-D205592","PAID",1376,0,"2020-11-03","2020-08-06 11:47:47","2020-08-06 11:47:47","2","2020-08-06 11:47:47","2","2020-08-06 11:47:47","1700"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8601","1700","SETTLED","A18-I208930","2020-08-06 11:47:47","2020-08-04","2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8930","RENT","\u9810\u7e73\u79df\u91d1",1,654,"MO","1",654,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8930","RENT","\u9810\u7e73\u79df\u91d1",2,654,"MO","1",654,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8930","RENT","\u9810\u7e73\u79df\u91d1",3,654,"MO","1",654,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1962,0,"8930"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 11:47:47","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":["1700","BANKIN","","","","BANKIN","","","","PAID","P208573","2020-08-06 11:47:47",3338,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8573","DEPOSIT","5592","PAID","2020-08-06 11:47:47",1376,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 11:47:47","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":["8573","INVOICE","8930","PAID","2020-08-06 11:47:47",1962,"2","2020-08-06 11:47:47","2","2020-08-06 11:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 12:04:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 12:10:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 12:42:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:09:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":520,"customer_code":"C170520","identity_type":"PERSONAL","identity_id":"Z821468(A)","title":"Ms","lastname":"Yim","firstname":"Po Kwan","companyname":"","email":"fire_zilia@yahoo.com.hk","tel":"92476466","address":"Room 407,4\/F, Wah Lim House, Wah Kwai Est ","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1234.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-23","renew_room_key":"054,59251","renew_remark":"3 months contract. Storage rental paid by EPS on May 6, 2020. Storage deposit transferred from agreement A14-CT207126 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207791, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"466","room_code":"K03(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1234,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3702,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-23","rent_from":"2020-07-23","rent_to":"2020-10-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on Aug 6, 2020. Storage deposit transferred from agreement A14-CT207791 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3702,"final_order_total":3702,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,59251","order_product":[],"pass":true}},"first_order_id":"4876","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> K03(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1234.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",520,"NEW","A14-CT208602",1342,1234,0,0,"3","3",3702,3702,3702,"2020-08-06 14:10:37","0",null,null,null,"2020-07-23","2020-10-22","3 months contract. Storage rental paid by EPS on Aug 6, 2020. Storage deposit transferred from agreement A14-CT207791 to this agreement.","2020-07-23","16",0,null,0,"0","2","2020-08-06 14:10:37","2","2020-08-06 14:10:37","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,59251","C170520","PERSONAL","Ms","+EYie6vniw1jBR9PN+A3cw==","D1lS+QYsXUkrz2nLRw\/QvA==","","jNRYdcVpwvcI+YZRXwePHevy0O7zp1xWIXXAEAhjt4W6ly2eAycj7nZo5LUyJDzm","awU72\/W1MrxjaSwCL0TzBA==","C0oT\/WZ07hy\/4HTZnKbNWCUaBi8RotOQQnTYZGNkyrw=","UkrIp5E2TfMSYxOMIphQGw==",null,1,"4876"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8602","466","1342.0","1342.00","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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-23","2020-10-22","466"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 14:10:37","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":["8602",520,"SETTLED","A14-I208931","2020-08-06 14:10:37","2020-07-23","2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8931","RENT","\u9810\u7e73\u79df\u91d1",1,1234,"MO","1",1234,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8931","RENT","\u9810\u7e73\u79df\u91d1",2,1234,"MO","1",1234,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8931","RENT","\u9810\u7e73\u79df\u91d1",3,1234,"MO","1",1234,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3702,0,"8931"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 14:10:37","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":[520,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208574","2020-08-06 14:10:37",3702,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8574","DEPOSIT",null,"PAID","2020-08-06 14:10:37",0,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:10:37","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":["8574","INVOICE","8931","PAID","2020-08-06 14:10:37",3702,"2","2020-08-06 14:10:37","2","2020-08-06 14:10:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:29:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:30:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:30:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:49:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:52:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 14:58:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=94&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":94,"customer_code":"C160094","identity_type":"PERSONAL","identity_id":"D206211(A)","title":"Ms","lastname":"Man","firstname":"Kam Ping","companyname":"","email":null,"tel":"91236797","address":"Room F,15\/FL,Tower 25,South Horizons,AP LEI CHAU ,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"338.0","renew_rent_month":"3","renew_warehousing_date":"2020-08-05","renew_room_key":"032,36140","renew_remark":"3 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT207125 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208093, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"26","order_discount":[{"master_room_discount_id":"56","master_room_id":"26","discount_type":"%","price":"268.00","disocunted_price":"268.00","discount":"5.00","monthly_deduct":13.4,"room_id":"298","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"298","room_code":"E25","retail_price":"268.0","discounted_price":254.6,"location_id":"1"}],"roughly_size":"4","total_retail_price":268,"total_discounted_price":320,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":1920,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-05","rent_from":"2020-08-05","rent_to":"2021-02-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred from agreement A12-CT208093 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1920,"final_order_total":1920,"location_id":"1","branch_id":"1","company_id":"1","room_key":"032,36140","order_product":[],"pass":true}},"first_order_id":"3669","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> E25 <\/td>\r\n\t\t\t\t\t 1X4X8 <\/td>\r\n\t\t\t\t\t $268.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":"4","total_discounted_price":"320.00","deposit":"0.00","total_retail_price":"268.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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",94,"NEW","A12-CT208603",268,320,0,0,"6","6",1920,1920,1920,"2020-08-06 15:04:40","0",null,null,null,"2020-08-05","2021-02-04","6 months contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred from agreement A12-CT208093 to this agreement.\r\n","2020-08-05","4",0,null,0,"0.00","2","2020-08-06 15:04:39","2","2020-08-06 15:04:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"032,36140","C160094","PERSONAL","Ms","92ETzwHeYMOYZxdoGpxA8A==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","pePfDJoMhvz2LcMCDENBlc7wGRh5AvJF3bXEYvrf9Ot4kNFvR\/krqOxYffey5CQ4l6W3\/9p0HQuoDJII5yNhtw==","xoV7Mm99UV+XnUNheCKUvw==",null,"eMMMOH6zPRoPG9zZWSgWxw==",null,1,"3669"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8603","56","26","298","%","5.00",13.4,"2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8603","298","268.0",254.6,"2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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-08-05","2021-02-04","298"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 15:04:40","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":["8603",94,"SETTLED","A12-I208932","2020-08-06 15:04:39","2020-08-05","2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",1,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",2,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",3,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",4,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",5,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8932","RENT","\u9810\u7e73\u79df\u91d1",6,320,"MO","1",320,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1920,0,"8932"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 15:04:40","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":[94,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208575","2020-08-06 15:04:39",1920,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8575","DEPOSIT",null,"PAID","2020-08-06 15:04:39",0,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:04:40","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":["8575","INVOICE","8932","PAID","2020-08-06 15:04:39",1920,"2","2020-08-06 15:04:39","2","2020-08-06 15:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:11:37","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0012421013","6 months contract. Special offer $1344\/month. Storage rental paid by PPS on February 25, 2020. Storage deposit $3444 transferred from agreement B01-CT195763 to this agreement.\r\n","2020-08-06 15:11:37","2","23wCRdcybxUEHt5OHLfIwQ==","StXCAUvh+VKwTp70Ji7HmQ==","eSBYJRSZcCtrEPof9Ilp84wmJrMVcapIxmc8hJxQDTc=","eVGtiJN9n9aEvzx6N4tEbg==","P5xcVShMtFk79EaAhZjxItx\/9UhMnrGwdlBxYhhtqUTFgqXpGxaMvMZSCpNbabybEp74gydZltkAT3Orjp9ZoBEiBPtikwfB0jTuPpQkK\/4=",7260]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=94&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":418,"customer_code":"C170418","identity_type":"PERSONAL","identity_id":"D254599(4)","title":"Ms","lastname":"Cheung","firstname":"Yee Man","companyname":"","email":null,"tel":"60159661","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6d77\u6676\u95a317\u6a131\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-09","renew_room_key":"054,47889","renew_remark":"1 month contract. Storage rental paid by bank transfer on July 03, 2020. Storage deposit transferred A14-CT208060 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208301, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"757","room_code":"O33","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-09","rent_from":"2020-08-09","rent_to":"2020-09-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred A14-CT208301 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,47889","order_product":[],"pass":true}},"first_order_id":"4700","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> O33 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",418,"NEW","A14-CT208604",998,998,0,0,"1","1",998,998,998,"2020-08-06 15:12:49","0",null,null,null,"2020-08-09","2020-09-08","1 month contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred A14-CT208301 to this agreement.\r\n","2020-08-09","12",0,null,0,"0.00","2","2020-08-06 15:12:48","2","2020-08-06 15:12:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,47889","C170418","PERSONAL","Ms","OSpwVZLaj11jKWHakE7sQg==","vCxOlXQuvOQaoL822H2o\/Q==","","hI6IrHjcy5pLAjEBRvfJ4609cWRuORlDVf1yu6P5hRnRjvCLtw+B8QJk\/h1VC39A","+X1wpo4tNWX3Q8nWqGEQTw==",null,"1j94IrN7Ua\/hHPZd+nL1Ig==",null,1,"4700"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8604","757","998.0","998.00","2","2020-08-06 15:12:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-09","2020-09-08","757"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8604",418,"SETTLED","A14-I208933","2020-08-06 15:12:48","2020-08-09","2","2020-08-06 15:12:48","2","2020-08-06 15:12:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8933","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-08-06 15:12:48","2","2020-08-06 15:12:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8933"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[418,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208576","2020-08-06 15:12:48",998,"2","2020-08-06 15:12:48","2","2020-08-06 15:12:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8576","DEPOSIT",null,"PAID","2020-08-06 15:12:48",0,"2","2020-08-06 15:12:48","2","2020-08-06 15:12:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:12:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8576","INVOICE","8933","PAID","2020-08-06 15:12:48",998,"2","2020-08-06 15:12:48","2","2020-08-06 15:12:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:14:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:18:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:26:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:26:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=566&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":566,"customer_code":"C170566","identity_type":"PERSONAL","identity_id":"D648246(6)","title":"Ms","lastname":"Chan","firstname":"Mary","companyname":"","email":"marychan@netvigator.com","tel":"90278318","address":"7B,59 South Bay Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3467.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-15","renew_room_key":"055,17728","renew_remark":"13 months contract. Special offer, one month free. Storage rental paid by bank transfer on June 15, 2019. Storage deposit transferred from agreement A18-CT194826 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195216, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"95","order_discount":[],"order_room":[{"room_id":"861","room_code":"T05","retail_price":"3852.0","discounted_price":"3852.00","location_id":"3"}],"roughly_size":"48","total_retail_price":3852,"total_discounted_price":3467,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":41604,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-06-15","rent_from":"2020-06-15","rent_to":"2021-06-14","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on August 06, 2019. Storage deposit transferred from agreement A18-CT195216 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":41604,"final_order_total":41604,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,17728","order_product":[],"pass":true}},"first_order_id":"4826","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> T05 <\/td>\r\n\t\t\t\t\t 8X6X7 <\/td>\r\n\t\t\t\t\t $3852.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":"48","total_discounted_price":"3467.00","deposit":"0.00","total_retail_price":"3852.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",566,"NEW","A18-CT208605",3852,3467,0,0,"12","12",41604,41604,41604,"2020-08-06 15:44:39","0",null,null,null,"2020-06-15","2021-06-14","12 months contract. Storage rental paid by bank transfer on August 06, 2019. Storage deposit transferred from agreement A18-CT195216 to this agreement.\r\n","2020-06-15","48",0,null,0,"0.00","2","2020-08-06 15:44:39","2","2020-08-06 15:44:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,17728","C170566","PERSONAL","Ms","1eNRpf5VC49KBDECC3uFqQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","38fvbQsHhSUOJ2MRHqpFgapNTzfYG\/FQmCOKas1CBDi4ZBLZ2SA\/xOpKVZEdnFQx","tgiIaZNce7oRcQFB8ejeHQ==","xxO7N7Un5rLMPV6V8xw0AvxMMNIkt9H9+QtDsOFwtWU=","gZP9Ao7aWDGvL\/HVF+cptg==",null,1,"4826"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8605","861","3852.0","3852.00","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-15","2021-06-14","861"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8605",566,"SETTLED","A18-I208934","2020-08-06 15:44:39","2020-06-15","2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",1,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",2,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",3,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",4,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",5,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",6,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",7,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",8,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",9,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",10,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",11,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8934","RENT","\u9810\u7e73\u79df\u91d1",12,3467,"MO","1",3467,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[41604,0,"8934"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[566,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208577","2020-08-06 15:44:39",41604,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8577","DEPOSIT",null,"PAID","2020-08-06 15:44:39",0,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:44:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8577","INVOICE","8934","PAID","2020-08-06 15:44:39",41604,"2","2020-08-06 15:44:39","2","2020-08-06 15:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 15:57:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 16:07:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 16:50:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:12","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=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1657,"customer_code":"C201657","identity_type":"PERSONAL","identity_id":"Z612413(6)","title":"Ms","lastname":"LEUNG","firstname":"Man Ching","companyname":"","email":null,"tel":"61302194","address":"Flat 1611, 16\/F, Pik Long House, Shek Pei Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"775.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-11","renew_room_key":"190, 26651","renew_remark":"1 month contract. Special "Rent Now" offer 5% off. Storage rental and deposit paid by EPS on July 4, 2020. Smartcard provided on July 4, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208293, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"655","room_code":"M66","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":775,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-11","rent_from":"2020-08-11","rent_to":"2020-09-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Aug 06, 2020. Storage deposit $1550 transferred from agreement A14-CT208293 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":775,"final_order_total":775,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190, 26651","order_product":[],"pass":true}},"first_order_id":8293,"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> M66 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"775.0","deposit":"0","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1657,"NEW","A14-CT208606",775,775,0,0,"1","1",775,775,775,"2020-08-06 17:20:13","0",null,null,null,"2020-08-11","2020-09-10","1 month contract. Storage rental paid by bank transfer on Aug 06, 2020. Storage deposit $1550 transferred from agreement A14-CT208293 to this agreement.","2020-08-11","9",0,null,0,"0","2","2020-08-06 17:20:12","2","2020-08-06 17:20:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190, 26651","C201657","PERSONAL","Ms","0i9Q6pWm5uHfxFKiszl9yg==","yXKc2lCF323ApRADrjNaSg==","","kESStI1EtlJa5flB\/4HxXn9EQQbYX83dQHyM5h8eDO+3cEW2J2iNQIYeTu4UNsuRSvEWG6knFnINERUItzNWsYt4rEUdxpB7HtBxpjwFnb8=","Hok6i53WZXAwOvoCBi4nTg==",null,"fRq33T\/xoZ8X7mop6wrwwQ==",null,1,8293]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","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":["8606","655","775.0","775.00","2","2020-08-06 17:20:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","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-08-11","2020-09-10","655"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 17:20:13","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":["8606",1657,"SETTLED","A14-I208935","2020-08-06 17:20:12","2020-08-11","2","2020-08-06 17:20:12","2","2020-08-06 17:20:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","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":["8935","RENT","\u9810\u7e73\u79df\u91d1",1,775,"MO","1",775,"2","2020-08-06 17:20:12","2","2020-08-06 17:20:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[775,0,"8935"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 17:20:13","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":[1657,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208578","2020-08-06 17:20:12",775,"2","2020-08-06 17:20:12","2","2020-08-06 17:20:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","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":["8578","DEPOSIT",null,"PAID","2020-08-06 17:20:12",0,"2","2020-08-06 17:20:12","2","2020-08-06 17:20:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:20:13","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":["8578","INVOICE","8935","PAID","2020-08-06 17:20:12",775,"2","2020-08-06 17:20:12","2","2020-08-06 17:20:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:42:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 17:43:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","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=1&filter2=727&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on July 06, 2020. Storage deposit transferred from agreement A12-CT208073 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208297, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-08","rent_from":"2020-08-08","rent_to":"2020-09-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred from agreement A12-CT208297 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","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> A09 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",197,"NEW","A12-CT208607",1098,1038,0,0,"1","1",1038,1038,1038,"2020-08-06 18:03:36","0",null,null,null,"2020-08-08","2020-09-07","1 month contract. Storage rental paid by bank transfer on August 06, 2020. Storage deposit transferred from agreement A12-CT208297 to this agreement.\r\n","2020-08-08","16",0,null,0,"0.00","2","2020-08-06 18:03:36","2","2020-08-06 18:03:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8607","9","1098.0","1098.00","2","2020-08-06 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-08","2020-09-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8607",197,"SETTLED","A12-I208936","2020-08-06 18:03:36","2020-08-08","2","2020-08-06 18:03:36","2","2020-08-06 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8936","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-08-06 18:03:36","2","2020-08-06 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8936"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208579","2020-08-06 18:03:36",1038,"2","2020-08-06 18:03:36","2","2020-08-06 18:03:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8579","DEPOSIT",null,"PAID","2020-08-06 18:03:36",0,"2","2020-08-06 18:03:36","2","2020-08-06 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:03:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8579","INVOICE","8936","PAID","2020-08-06 18:03:36",1038,"2","2020-08-06 18:03:36","2","2020-08-06 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:07:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:09:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:22:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:23:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:24:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:24:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:32:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:24","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=923&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1066,"customer_code":"C181066","identity_type":"PERSONAL","identity_id":"R127281(A)","title":"Ms","lastname":"PAN","firstname":"Xiang Zhen","companyname":"","email":"JANEPAN88@hotmail.com","tel":"62902980","address":"Flat A, 7\/F, South Tower 7, Residence Bel-Air, 38 Bel-Air Avenue, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-24","renew_room_key":"189,48705","renew_remark":"12 months contract. Special renewal offer, $300 Maxim's cake vouchers offered. Storage rental paid by bank transfer on August 18, 2019. Storage deposit $1196 transferred from agreement A14-CT194233 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195750, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"624","room_code":"M35","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-24","rent_from":"2020-07-24","rent_to":"2021-01-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit $1196 transferred from agreement A14-CT195750 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,48705","order_product":[],"pass":true}},"first_order_id":"4233","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> M35 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1066,"NEW","A14-CT208608",598,538,0,0,"6","6",3228,3228,3228,"2020-08-06 18:45:25","0",null,null,null,"2020-07-24","2021-01-23","6 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit $1196 transferred from agreement A14-CT195750 to this agreement.","2020-07-24","12",0,null,0,"0","2","2020-08-06 18:45:24","2","2020-08-06 18:45:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,48705","C181066","PERSONAL","Ms","hNqnWaJz6n77Y2WIvkv+DA==","Eh\/5gpi9GwbDYS\/9mpLqTw==","","sdyaIhZHKcCC4XVHExOeVDNdCqqoAkfDZ6I0YjvKmsIa+3cWYGFEZgZ8nKY8cr43taQ+f4YU0hMpKx32\/CE32MVaFuCPt54p2tzRAr35coivOC0jUiFEto5mJYHdIpVN","71qlb0Y4t6GCBpOgcwQ96g==","lxhqDU3jnCU\/UD9RHWTxPM+8ARuRXsDBZTHEDaK1Sz4=","NdoXOxPt7OD1yz9cYJIKkg==",null,1,"4233"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8608","624","598.0","598.00","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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-24","2021-01-23","624"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 18:45:25","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":["8608",1066,"SETTLED","A14-I208937","2020-08-06 18:45:24","2020-07-24","2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8937","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8937"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 18:45:25","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":[1066,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208580","2020-08-06 18:45:24",3228,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8580","DEPOSIT",null,"PAID","2020-08-06 18:45:24",0,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:45:25","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":["8580","INVOICE","8937","PAID","2020-08-06 18:45:24",3228,"2","2020-08-06 18:45:24","2","2020-08-06 18:45:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:48:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:51:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:55:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 18:58:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=923&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":726,"customer_code":"C180726","identity_type":"PERSONAL","identity_id":"Z710066(4)","title":"Mr","lastname":"Chau","firstname":"Chong Yu","companyname":"","email":"patrick1986yu@yahoo.com.hk","tel":"63236406","address":"Flat 920, 9\/F, Wah Ching House, Wah Fu Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-22","renew_room_key":"136,26121","renew_remark":"12 months contract. Special renewal offer, $300 Maxim's and Wellcome vouchers offered. Storage rental paid by bank transfer on July 13, 2019. Storage deposit transferred from agreement A14-CT194137 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195479, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"612","room_code":"M23","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-22","rent_from":"2020-07-22","rent_to":"2021-01-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit transferred from agreement A14-CT195479 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,26121","order_product":[],"pass":true}},"first_order_id":"4137","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> M23 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",726,"NEW","A14-CT208609",598,538,0,0,"6","6",3228,3228,3228,"2020-08-06 19:00:10","0",null,null,null,"2020-07-22","2021-01-21","6 months contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit transferred from agreement A14-CT195479 to this agreement.","2020-07-22","12",0,null,0,"0","2","2020-08-06 19:00:09","2","2020-08-06 19:00:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,26121","C180726","PERSONAL","Mr","isKk2Z41CEmYZnqIMR9d1Q==","kOK3vHUlGE9qjoVnzYRDGA==","","eOeOYy+nu2sGR3ov53KIZOh7BtoTWq5q677VscGy+4zTy8apoHTSzf0mOtpbAxPkXCS0IU7A0CvjJL8zTSU3NHldz1l6TIhuw4\/0NpwbAXo=","eZ6sT0K\/D2u\/o63pDngWlQ==","Y3KG67D+G7+na07C6UFUqKnzMQeBw+NXlRbs0y\/fAEQ=","gOVzZDgEI7FRR5fJeve9Gw==",null,1,"4137"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8609","612","598.0","598.00","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2021-01-21","612"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8609",726,"SETTLED","A14-I208938","2020-08-06 19:00:09","2020-07-22","2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8938","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8938"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[726,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208581","2020-08-06 19:00:09",3228,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8581","DEPOSIT",null,"PAID","2020-08-06 19:00:09",0,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-06 19:00:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8581","INVOICE","8938","PAID","2020-08-06 19:00:09",3228,"2","2020-08-06 19:00:09","2","2020-08-06 19:00:09"]},"data_before":[],"data_after":[],"step":1} *****