{"created_at":"2020-01-17 09:39:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 09:46:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 09:54:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:00:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:00:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1010,"customer_code":"C181010","identity_type":"PERSONAL","identity_id":"G500520(4)","title":"Mr","lastname":"Chan","firstname":"Fuk Wah","companyname":"","email":"cchan112@gmail.com","tel":"62919693","address":"Flat B, 29\/F, Tower 30, South Horizons, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-29","renew_room_key":"0012400910","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 04, 2019. Storage deposit transferred from agreement A05-CT196107 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196293, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"111","order_discount":[],"order_room":[{"room_id":"1183","room_code":"A05-181","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-29","rent_from":"2019-11-29","rent_to":"2020-01-28","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A05-CT196293 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1930,"final_order_total":1930,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012400910","order_product":[],"pass":true}},"first_order_id":"4878","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-181 <\/td>\r\n\t\t\t\t\t	4X2X7 <\/td>\r\n\t\t\t\t\t	$965.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"965.00","deposit":"0.00","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1010,"NEW","A05-CT206986",965,965,0,0,"2","2",1930,1930,1930,"2020-01-17 10:02:59","0",null,null,null,"2019-11-29","2020-01-28","2 months contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A05-CT196293 to this agreement.\r\n","2019-11-29","8",0,null,0,"0","2","2020-01-17 10:02:59","2","2020-01-17 10:02:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012400910","C181010","PERSONAL","Mr","8cTgk2jy\/aiV7QPXwqRl2g==","U9yoE9KqV1v8YlRkf7Q2yg==","","ME\/crnyaSwYbzHUXDg5VgbqG3YRGAgmpek+CIuENvwO378zx8DHLpJPtpAOlvaBABhTQXEQlE6UDmibftOM7kg==","Cwvkc6m0KBl1nFcP0k2R7w==","2yUL+4w8e+Fou+Vm36tIxXwaH7cLtE320MBL9iViZIo=","TJRhkUGN7K07ZfxCx+O5Iw==",null,1,"4878"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6986","1183","965.0","965.00","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-29","2020-01-28","1183"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6986",1010,"SETTLED","A05-I207314","2020-01-17 10:02:59","2019-11-29","2","2020-01-17 10:02:59","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7314","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-01-17 10:02:59","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7314","RENT","\u9810\u7e73\u79df\u91d1",2,965,"MO","1",965,"2","2020-01-17 10:02:59","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1930,0,"7314"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1010,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206963","2020-01-17 10:02:59",1930,"2","2020-01-17 10:02:59","2","2020-01-17 10:02:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6963","DEPOSIT",null,"PAID","2020-01-17 10:02:59",0,"2","2020-01-17 10:02:59","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:02:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6963","INVOICE","7314","PAID","2020-01-17 10:02:59",1930,"2","2020-01-17 10:02:59","2","2020-01-17 10:02:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=722&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":722,"customer_code":"C180722","identity_type":"PERSONAL","identity_id":"A133698(6)","title":"Ms","lastname":"\u7f85","firstname":"\u9999","companyname":"","email":null,"tel":"93427793","address":"29A, Tower 17, South Horizons, Ap Lei Chau, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-15","renew_room_key":"054,55445","renew_remark":"6 months contract. Storage rental paid by cash deposit on July 12, 2019. Storage deposit transferred from agreement A18-CT194199 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195507, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"866","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"866","room_code":"T10","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-07-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash deposit on January 9, 2020. Storage deposit transferred from agreement A18-CT195507 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,55445","order_product":[],"pass":true}},"first_order_id":"4199","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> T10 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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",722,"NEW","A18-CT206987",1290,1162,0,0,"6","6",6972,6972,6972,"2020-01-17 10:14:08","0",null,null,null,"2020-01-15","2020-07-14","6 months contract. Storage rental paid by cash deposit on January 9, 2020. Storage deposit transferred from agreement A18-CT195507 to this agreement.\r\n","2020-01-15","16",0,null,0,"0","2","2020-01-17 10:14:07","2","2020-01-17 10:14:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,55445","C180722","PERSONAL","Ms","PTwslGSpub9wDSFuSfDB6A==","UIh\/PML63l06OHzCxAIM8w==","","HJc4s+et2VEvm7xD0O4s5L4OJsMTv2SBuq5RQgSw8Wyw5+nIvt6pAznrp72KoaD8eUBoTVF042xCTRJJwbbhAA==","U\/vSjw1DZoYdGaaDKTEQDA==",null,"nKB5JRkOMmzP6BzoYGlN8w==",null,1,"4199"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["6987","250","91","866","%","10.00",129,"2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["6987","866","1290.0",1161,"2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2020-07-14","866"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 10:14:08","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":["6987",722,"SETTLED","A18-I207315","2020-01-17 10:14:07","2020-01-15","2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["7315","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7315"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 10:14:08","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":[722,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206964","2020-01-17 10:14:07",6972,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["6964","DEPOSIT",null,"PAID","2020-01-17 10:14:07",0,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:14:08","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":["6964","INVOICE","7315","PAID","2020-01-17 10:14:07",6972,"2","2020-01-17 10:14:07","2","2020-01-17 10:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:15:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:29","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=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"543","master_room_id":"68","room_code":"L21"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":275,"customer_code":"C170275","identity_type":"PERSONAL","identity_id":"P935426(7)","title":"Ms","lastname":"Au","firstname":"Shing San","companyname":"","email":null,"tel":"68750303","address":"\u77f3\u6392\u7063\u90a8\u78a7\u8f1d\u6a13707\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1535.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-19","renew_room_key":"133,2756","renew_remark":"1 month contract. Storage rental paid by cash on December 20, 2019. Storage deposit transferred from agreement A12-CT196426 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196748, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"373","room_code":"G14","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1535,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1535,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-19","rent_from":"2020-01-19","rent_to":"2020-02-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on January 17, 2020. Storage deposit transferred from agreement A12-CT196748 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1535,"final_order_total":1535,"location_id":"1","branch_id":"1","company_id":"1","room_key":"133,2756","order_product":[],"pass":true}},"first_order_id":"4776","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> G14 <\/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> \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":"24","total_discounted_price":"1535.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","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",275,"NEW","A12-CT206988",1768,1535,0,0,"1","1",1535,1535,1535,"2020-01-17 10:44:30","0",null,null,null,"2020-01-19","2020-02-18","1 month contract. Storage rental paid by cash on January 17, 2020. Storage deposit transferred from agreement A12-CT196748 to this agreement.\r\n","2020-01-19","24",0,null,0,"0","2","2020-01-17 10:44:29","2","2020-01-17 10:44:29","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,2756","C170275","PERSONAL","Ms","EFxpJJXvWP6pxqsrB6e4rw==","egeOlBPCZ2i\/hzcvvQMisg==","","cfhLoHunuImSyfV\/aZ+b9adtcjA+s\/\/16tHC7+KYDRk=","rzzwlkWLr5BLkj5wjDqTZQ==",null,"djxx0GEU1zjEGX4LvLIgug==",null,1,"4776"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","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":["6988","373","1768.0","1768.00","2","2020-01-17 10:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-19","2020-02-18","373"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 10:44:30","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":["6988",275,"SETTLED","A12-I207316","2020-01-17 10:44:29","2020-01-19","2","2020-01-17 10:44:29","2","2020-01-17 10:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","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":["7316","RENT","\u9810\u7e73\u79df\u91d1",1,1535,"MO","1",1535,"2","2020-01-17 10:44:29","2","2020-01-17 10:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1535,0,"7316"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 10:44:30","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":[275,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206965","2020-01-17 10:44:29",1535,"2","2020-01-17 10:44:29","2","2020-01-17 10:44:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","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":["6965","DEPOSIT",null,"PAID","2020-01-17 10:44:29",0,"2","2020-01-17 10:44:29","2","2020-01-17 10:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 10:44:30","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":["6965","INVOICE","7316","PAID","2020-01-17 10:44:29",1535,"2","2020-01-17 10:44:29","2","2020-01-17 10:44:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:11:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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=1416","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1081","master_room_id":"110","room_code":"A05-079"}],"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> A05-079 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D134484(7)","title":"Mr","lastname":"Tsang","firstname":"Chiu Ming","companyname":"","email":"","tel":"91299919","address":"ROOM 8, 10\/F, BLOCK A, AP LEI CHAU CTR, 138 LEE CHI ROAD, AP LEI CHAU, H.K.","pass":true,"customer_id":"1416","customer_code":"C191416","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1081","room_code":"A05-079","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":7452,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"738.00","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-02-28","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and $200 termination coupon. Storage rental and deposit paid by EPS on Jan 17,2020. Smartcard and padlock provided on Jan 17,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":738,"order_total":8190,"final_order_total":7452,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0003649055","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1416","NEW","A05-CT206989",598,538,1196,0,"13","13",7452,8190,7452,"2020-01-17 11:12:56","0",null,null,null,"2020-02-01","2021-02-28","13 months contract. Special offer the 13th month free and $200 termination coupon. Storage rental and deposit paid by EPS on Jan 17,2020. Smartcard and padlock provided on Jan 17,2020.","2020-02-01","8",0,null,738,"738.00","2","2020-01-17 11:12:56","2","2020-01-17 11:12:56","EPS","","","","EPS","","","",null,0,"0003649055","C191416","PERSONAL","Mr","27olcbKRKSN+Ki1wttThrw==","SrBvL8bV9b3Cq\/EiAmR0Dg==","","q+Kyk7zBzydJJGxMSg36fxRRS4sf5z3YL6cIn9BtHhw4ISjkADi6uPrGSLEfQcBDMV3hLEIyHvc4LWgmwZHLquFhVgUT5PtloSAJ+GZD+2w=","hUCYZ1omXZk3WaDmyMZLdg==",null,"PkPsuwTLko0Q25j+7O3iNw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["6989","1081","598.0","598.00","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-02-28","1081"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 11:12:56","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":["6989","A05-D205256","PAID",1196,0,"2021-02-28","2020-01-17 11:12:56","2020-01-17 11:12:56","2","2020-01-17 11:12:56","2","2020-01-17 11:12:56","1416"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["6989","1416","SETTLED","A05-I207317","2020-01-17 11:12:56","2020-02-01","2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,338,"MO","1",338,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["7317","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6256,0,"7317"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 11:12:56","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":["1416","EPS","","","","EPS","","","","PAID","P206966","2020-01-17 11:12:56",7452,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["6966","DEPOSIT","5256","PAID","2020-01-17 11:12:56",1196,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:12:56","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":["6966","INVOICE","7317","PAID","2020-01-17 11:12:56",6256,"2","2020-01-17 11:12:56","2","2020-01-17 11:12:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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=722&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-13","renew_room_key":"072,48391","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT196357 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196652, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"633","room_code":"M44","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2020-02-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196652 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,48391","order_product":[],"pass":true}},"first_order_id":"4767","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> M44 <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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",431,"NEW","A14-CT206990",598,598,0,0,"1","1",598,598,598,"2020-01-17 11:13:13","0",null,null,null,"2020-01-13","2020-02-12","1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196652 to this agreement.\r\n","2020-01-13","12",0,null,0,"0","2","2020-01-17 11:13:12","2","2020-01-17 11:13:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"072,48391","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4767"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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":["6990","633","598.0","598.00","2","2020-01-17 11:13:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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-01-13","2020-02-12","633"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 11:13: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":["6990",431,"SETTLED","A14-I207318","2020-01-17 11:13:12","2020-01-13","2","2020-01-17 11:13:12","2","2020-01-17 11:13:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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":["7318","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-17 11:13:12","2","2020-01-17 11:13:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7318"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 11:13: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":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206967","2020-01-17 11:13:12",598,"2","2020-01-17 11:13:12","2","2020-01-17 11:13:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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":["6967","DEPOSIT",null,"PAID","2020-01-17 11:13:12",0,"2","2020-01-17 11:13:12","2","2020-01-17 11:13:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:13: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":["6967","INVOICE","7318","PAID","2020-01-17 11:13:12",598,"2","2020-01-17 11:13:12","2","2020-01-17 11:13:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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=722&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":431,"customer_code":"C170431","identity_type":"PERSONAL","identity_id":"D413337(5)","title":"Ms","lastname":"Wu","firstname":"Yuen Fong","companyname":"","email":null,"tel":"93139577","address":"\u7f6e\u5bcc\u82b1\u571210\u5ea718\u6a13A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-12","renew_room_key":"136,17013","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT196358 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196653, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"648","room_code":"M59","retail_price":"775.0","discounted_price":"775.00","location_id":"2"},{"room_id":"634","room_code":"M45","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1550,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-12","rent_from":"2020-01-12","rent_to":"2020-02-11","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196653 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,17013","order_product":[],"pass":true}},"first_order_id":"4768","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M59 <\/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> M45 <\/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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1550.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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",431,"NEW","A14-CT206991",1550,1198,0,0,"1","1",1198,1198,1198,"2020-01-17 11:14:08","0",null,null,null,"2020-01-12","2020-02-11","1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A14-CT196653 to this agreement.\r\n","2020-01-12","18",0,null,0,"0","2","2020-01-17 11:14:08","2","2020-01-17 11:14:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,17013","C170431","PERSONAL","Ms","UxlXQiCLdPwPautaCTB+Hw==","6BZ3jKM7u1vzGCs7Yb+Ugw==","","n4HXLIkQV7R3SmsiP7KfX4xGRy\/8rX+8EebxY4Sn+pQ=","\/5Bh87k0zl6kketxJ3ZvuA==",null,"eYnja6hmcz0ZXhSZIkdH7w==",null,1,"4768"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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":["6991","648","775.0","775.00","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-12","2020-02-11","648"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 11:14:08","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":["6991","634","775.0","775.00","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-12","2020-02-11","634"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 11:14:08","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":["6991",431,"SETTLED","A14-I207319","2020-01-17 11:14:08","2020-01-12","2","2020-01-17 11:14:08","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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":["7319","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-01-17 11:14:08","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"7319"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 11:14:08","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":[431,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206968","2020-01-17 11:14:08",1198,"2","2020-01-17 11:14:08","2","2020-01-17 11:14:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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":["6968","DEPOSIT",null,"PAID","2020-01-17 11:14:08",0,"2","2020-01-17 11:14:08","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:14:08","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":["6968","INVOICE","7319","PAID","2020-01-17 11:14:08",1198,"2","2020-01-17 11:14:08","2","2020-01-17 11:14:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 11:43:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:34:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=722&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":659,"customer_code":"C170659","identity_type":"PERSONAL","identity_id":"D396565(2)","title":"Ms","lastname":"Chan","firstname":"Po Fong","companyname":"","email":"pchj@netvigator.com","tel":"93534131","address":"Room 4, 18\/F, Block A, Yue Fai Court, 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":"6","renew_warehousing_date":"2020-01-03","renew_room_key":"055,33401","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 19, 2019. Storage deposit transferred from agreement A14-CT194080 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195515, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"632","room_code":"M43","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-01-03","rent_from":"2020-01-03","rent_to":"2020-07-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on January 15, 2020. Storage deposit transferred from agreement A14-CT195515 to this agreement.\r\n","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":"055,33401","order_product":[],"pass":true}},"first_order_id":"4080","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> M43 <\/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.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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",659,"NEW","A14-CT206992",598,538,0,0,"6","6",3228,3228,3228,"2020-01-17 12:36:53","0",null,null,null,"2020-01-03","2020-07-02","6 months contract. Storage rental paid by cheque on January 15, 2020. Storage deposit transferred from agreement A14-CT195515 to this agreement.\r\n","2020-01-03","12",0,null,0,"0","2","2020-01-17 12:36:53","2","2020-01-17 12:36:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,33401","C170659","PERSONAL","Ms","43jB2wq6E7xyvgYskyFI+w==","U9yoE9KqV1v8YlRkf7Q2yg==","","KygWCD+SKEmgHufp0Zm0\/lMF5yVVyPaUK5Jvwyf7emwhQW9B1RP1Gm3s9vzc1pXD4B0cVwdPuK20kI7izQyhfw==","JP5lFRiet1qBtzanek1MIQ==","wTTmfV4dBsHiBrfCXsZpvDrxcD382sdghaKHko78D1s=","RS4\/wVYbIEb0Gz91LPPKXg==",null,1,"4080"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["6992","632","598.0","598.00","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-03","2020-07-02","632"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 12:36:53","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":["6992",659,"SETTLED","A14-I207320","2020-01-17 12:36:53","2020-01-03","2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["7320","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7320"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 12:36:53","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":[659,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206969","2020-01-17 12:36:53",3228,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["6969","DEPOSIT",null,"PAID","2020-01-17 12:36:53",0,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 12:36:53","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":["6969","INVOICE","7320","PAID","2020-01-17 12:36:53",3228,"2","2020-01-17 12:36:53","2","2020-01-17 12:36:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1081","master_room_id":"110","room_code":"A05-079"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":933,"customer_code":"C180933","identity_type":"PERSONAL","identity_id":"A923795(2)","title":"Mr","lastname":"Tsui","firstname":"Yu Kin","companyname":"","email":null,"tel":"72720099","address":"Block A, 1\/F, Pak Tai Building, 3 Ma Hang Chung Road, To Kwa Wan, Kowloon","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"733.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-17","renew_room_key":"0012388389","renew_remark":"12 months contract. storage rental paid by Cash on Jan 22,2019, storage deposit transferred from A05 -CT182933\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194217, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1064","room_code":"A05-062","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":733,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8796,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2021-02-16","delivery_service":"0","remark":"12 months contract. Storage rental paid by cash on Jan 17,2020. Storage deposit transferred from A05-CT194217.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":8796,"final_order_total":8796,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012388389","order_product":[],"pass":true}},"first_order_id":4217,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-062 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"733.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",933,"NEW","A05-CT206993",1006,733,0,0,"12","12",8796,8796,8796,"2020-01-17 14:16:46","0",null,null,null,"2020-02-17","2021-02-16","12 months contract. Storage rental paid by cash on Jan 17,2020. Storage deposit transferred from A05-CT194217.","2020-02-17","9",0,null,0,"0","2","2020-01-17 14:16:46","2","2020-01-17 14:16:46","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0012388389","C180933","PERSONAL","Mr","0eDm0t4ABqMFaezRjGRQgA==","iFBOFA5ozF+SaoxW1fJyqg==","","5qLcjbdhuYK7y95BQaKmFnBQTHXN9hOadt7KMVihT+YpAwCKvXy02rGkkRV+1suFWEy3APbGCb2g1AfwIo2ItpLuxpixxkzfrxnM4aR9gYo=","CIPC11Q7GeANVa7acBGkDA==",null,"fs09uPEVd+wuEFFIZkMuag==",null,1,4217]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["6993","1064","1006.0","1006.00","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2021-02-16","1064"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 14:16:46","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":["6993",933,"SETTLED","A05-I207321","2020-01-17 14:16:46","2020-02-17","2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",1,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",2,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",3,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",4,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",5,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",6,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",7,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",8,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",9,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",10,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",11,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["7321","RENT","\u9810\u7e73\u79df\u91d1",12,733,"MO","1",733,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8796,0,"7321"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 14:16:46","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":[933,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206970","2020-01-17 14:16:46",8796,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["6970","DEPOSIT",null,"PAID","2020-01-17 14:16:46",0,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:16:46","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":["6970","INVOICE","7321","PAID","2020-01-17 14:16:46",8796,"2","2020-01-17 14:16:46","2","2020-01-17 14:16:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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=2&filter2=653&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"543","master_room_id":"68","room_code":"L21"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":341,"customer_code":"C170341","identity_type":"PERSONAL","identity_id":"c516304(6)","title":"Ms","lastname":"Wong","firstname":"Ka Wai Cynthia","companyname":"","email":null,"tel":"96403194","address":"29C , Block 36 Cityone, Sha Tin , NT","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-16","renew_room_key":"052,40338","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 16, 2019. Storage deposit transferred from agreement A14-CT195546 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196166, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"553","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"553","room_code":"L31","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-04-15","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 17, 2020. Storage deposit transferred from agreement A14-CT196166 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,40338","order_product":[],"pass":true}},"first_order_id":"4791","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> L31 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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",341,"NEW","A14-CT206994",1098,989,0,0,"3","3",2967,2967,2967,"2020-01-17 14:17:49","0",null,null,null,"2020-01-16","2020-04-15","3 months contract. Storage rental paid by bank transfer on January 17, 2020. Storage deposit transferred from agreement A14-CT196166 to this agreement.","2020-01-16","16",0,null,0,"0","2","2020-01-17 14:17:49","2","2020-01-17 14:17:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40338","C170341","PERSONAL","Ms","6eNP98nRTlNcfhhC+\/Bnlw==","hULSwM2MvFtpeV9\/z+er8Q==","","qXziVId6+9QcA24duU40ff\/2z0OXPDTPZK45xgzuoWYOPyntomVUO3aMeDMXWgxE","+7tj+NS1naX2NK3fSON\/0g==",null,"40QpgVYlR92s5bcLUNXVzA==",null,1,"4791"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17:49","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":["6994","434","35","553","%","4.97",54.5706,"2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["6994","553","1098.0",1043.4,"2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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-01-16","2020-04-15","553"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-17 14:17: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":["6994",341,"SETTLED","A14-I207322","2020-01-17 14:17:49","2020-01-16","2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["7322","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["7322","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["7322","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7322"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-17 14:17: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":[341,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206971","2020-01-17 14:17:49",2967,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["6971","DEPOSIT",null,"PAID","2020-01-17 14:17:49",0,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 14:17: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":["6971","INVOICE","7322","PAID","2020-01-17 14:17:49",2967,"2","2020-01-17 14:17:49","2","2020-01-17 14:17:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 15:14:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 15:15:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201489","PERSONAL","Mr","VWZUs9LfydOgVvGpEzQt\/+n7Yttm8uJE4MTUa\/IWrSs=","fwsebH2az17gKNdZ18K8Cg==","","i5UNF+hORtbrMSTxurSRnA==","5rIdeQMBXq2gB2IZv5pLzoZ4BwK+3uKPKuj3XjSW2gM=","v5egprKy0yBPcF4TjmPdku4Xad\/M78p2GOJoPkHfcFIUAbUfdDG83fhg17nWr+vLS4xwoQ21qZrkMPiBAzQsxw==","OS6XMnlF7T8Nc3uzK63XkQ==","","5rIdeQMBXq2gB2IZv5pLzoZ4BwK+3uKPKuj3XjSW2gM=","GhIqSWnr2Cjy9EV\/toMU+A==","2","2020-01-17 15:15:06","2","2020-01-17 15:15:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 15:24:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 15:26:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 15:55:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 16:17:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 16:17:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 16:17:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 16:29:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 17:00:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 18:08:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 18:11:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-17 18:54:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****