{"created_at":"2020-05-16 10:16:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:16:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1122,"customer_code":"C181122","identity_type":"PERSONAL","identity_id":"K775192(3)","title":"Mr","lastname":"Kwan","firstname":"Ka Wai","companyname":"","email":"kwan_andy@hotmail.com","tel":"96338841","address":"Flat G, 22\/F, World Fair Court, 4 Wah Lok Path, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-27","renew_room_key":"0012401498","renew_remark":"6 months contract. Storage rental paid by PPS on November 26, 2019. Storage deposit $2580 transferred from agreement A05-CT183737 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196543, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1118","room_code":"A05-116","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2021-06-26","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on May 16, 2020. Storage deposit $2580 transferred from agreement A05-CT196543 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401498","order_product":[],"pass":true}},"first_order_id":"3737","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-116 <\/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.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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",1122,"NEW","A05-CT207863",1290,1162,0,0,"13","13",13944,15106,13944,"2020-05-16 10:44:26","0",null,null,null,"2020-05-27","2021-06-26","13 months contract. Special offer the 13th month free. Storage rental paid by cash on May 16, 2020. Storage deposit $2580 transferred from agreement A05-CT196543 to this agreement. \r\n","2020-05-27","16",0,null,1162,"1162.00","2","2020-05-16 10:44:25","2","2020-05-16 10:44:25","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0012401498","C181122","PERSONAL","Mr","JEtcjPW\/TaM5kXVZ2mzpoQ==","iNwdG3Dj3OBaAQ6MRfBM1w==","","hFCjlOG1xWULAJ\/BcSPxayPY5afmUp2hnv3jtkMgGaqUp2lKNHkHAAlpKdX4jqS4zTLsNpQmN1qWpACrnHTHyQ==","17489h+jIp1CeYOQlncJfw==","i+eSALD4vxxmBxAoUMM3QnqBezAb\/8VSL9uYFIpjs\/E=","OIIqjfZlO\/d2YEjipO2jCg==",null,1,"3737"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["7863","1118","1290.0","1290.00","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-27","2021-06-26","1118"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 10:44:26","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":["7863",1122,"SETTLED","A05-I208192","2020-05-16 10:44:25","2020-05-27","2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["8192","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8192"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 10:44:26","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":[1122,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207837","2020-05-16 10:44:25",13944,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["7837","DEPOSIT",null,"PAID","2020-05-16 10:44:25",0,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:44:26","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":["7837","INVOICE","8192","PAID","2020-05-16 10:44:25",13944,"2","2020-05-16 10:44:25","2","2020-05-16 10:44:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 10:57:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 12:52:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:56:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":922,"customer_code":"C180922","identity_type":"PERSONAL","identity_id":"R093780(A)","title":"Mr","lastname":"Lem","firstname":"Lester","companyname":"","email":null,"tel":"98341337","address":"33 Villase Road, Claymore Mansion 8C Happy Volley","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1395.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-06","renew_room_key":"0005832634","renew_remark":"3 months contract. Storage rental paid by bank transfer on Feb 14,2020. Storage deposit $2936 transferred from agreement C15-CT196709 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207194, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1425","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1425","room_code":"C15-119","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2020-08-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2936 transferred from agreement C15-CT207194 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"2855","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-119 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"24","total_discounted_price":"1395.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",922,"NEW","C15-CT207864",1322,1395,0,0,"3","3",4185,4185,4185,"2020-05-16 13:58:18","0",null,null,null,"2020-05-06","2020-08-05","3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2936 transferred from agreement C15-CT207194 to this agreement.","2020-05-06","24",0,null,0,"0","2","2020-05-16 13:58:17","2","2020-05-16 13:58:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180922","PERSONAL","Mr","Dzha9dlScOIWPzjcGWfv0g==","GDfCku5DBU5ET7jsJQ4uSQ==","","bQCpfJ6yuCpVED58eFfu55EZKHMm0nCgt7IVHKzBwaIa51jlt0kQdafLHlY\/JF\/mKGWIu5GFpOyI4wUK5Tl5hg==","BsdtSBOUNtjWiYn3vo9VfQ==",null,"j6psOFF4hXAVFDu1lsSO7g==",null,1,"2855"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7864","419","173","1425","%","5.00",66.1,"2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7864","1425","1322.0",1255.9,"2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-08-05","1425"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7864",922,"SETTLED","C15-I208193","2020-05-16 13:58:17","2020-05-06","2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8193","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8193","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8193","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"8193"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[922,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207838","2020-05-16 13:58:17",4185,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7838","DEPOSIT",null,"PAID","2020-05-16 13:58:17",0,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:58:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7838","INVOICE","8193","PAID","2020-05-16 13:58:17",4185,"2","2020-05-16 13:58:17","2","2020-05-16 13:58:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":918,"customer_code":"C180918","identity_type":"PERSONAL","identity_id":"D675242(3)","title":"Mrs","lastname":"Ray","firstname":"Lily","companyname":"","email":"lilyrayhk@gmail.com","tel":"98341337","address":" B Floor, 38 Ventns Rd Comfort Mansion, Happy Valley Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1395.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-29","renew_room_key":"0005832634","renew_remark":"3 months contract. Storage rental paid by bank transfer on Mar 06,2020. Storage deposit $2936 transferred from agreement C15-CT196710 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207343, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1424","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1424","room_code":"C15-118","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-29","rent_from":"2020-05-29","rent_to":"2020-08-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2936 transferred from agreement C15-CT207343 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"2841","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-118 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"24","total_discounted_price":"1395.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",918,"NEW","C15-CT207865",1322,1395,0,0,"3","3",4185,4185,4185,"2020-05-16 13:59:58","0",null,null,null,"2020-05-29","2020-08-28","3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2936 transferred from agreement C15-CT207343 to this agreement.","2020-05-29","24",0,null,0,"0","2","2020-05-16 13:59:58","2","2020-05-16 13:59:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180918","PERSONAL","Mrs","HGSr\/4NUklUwNPOT6LyvzQ==","wJQSZpXGs\/iPthecZsEzXA==","","6qAFKsY2wYrSL+QlaUgJzlgFeq+4QM6\/PgzW\/EPwJEnwsvyfNBYGV0qIHs8X4rE8DnL7HsuO101d9UPTmYCtOA==","BsdtSBOUNtjWiYn3vo9VfQ==","SQ9wa28Pf0jr8etLawngCaTmhsZjMdvvkiOcKAKp2tc=","FzWr1978iA0B4TB8JWUNww==",null,1,"2841"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["7865","419","173","1424","%","5.00",66.1,"2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["7865","1424","1322.0",1255.9,"2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-29","2020-08-28","1424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 13:59:58","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":["7865",918,"SETTLED","C15-I208194","2020-05-16 13:59:58","2020-05-29","2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["8194","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["8194","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["8194","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"8194"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 13:59:58","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":[918,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207839","2020-05-16 13:59:58",4185,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["7839","DEPOSIT",null,"PAID","2020-05-16 13:59:58",0,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 13:59:58","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":["7839","INVOICE","8194","PAID","2020-05-16 13:59:58",4185,"2","2020-05-16 13:59:58","2","2020-05-16 13:59:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":918,"customer_code":"C180918","identity_type":"PERSONAL","identity_id":"D675242(3)","title":"Mrs","lastname":"Ray","firstname":"Lily","companyname":"","email":"lilyrayhk@gmail.com","tel":"98341337","address":" B Floor, 38 Ventns Rd Comfort Mansion, Happy Valley Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1395.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-11","renew_room_key":"0005832634","renew_remark":"3 months contract. Storage rental paid by bank transfer on Mar 06,2020. Storage deposit $2,936 transferred from agreement C15-CT196711 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207344, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1423","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1423","room_code":"C15-117","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2020-09-10","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2,936 transferred from agreement C15-CT207344 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"4280","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-117 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"24","total_discounted_price":"1395.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",918,"NEW","C15-CT207866",1322,1395,0,0,"3","3",4185,4185,4185,"2020-05-16 14:01:31","0",null,null,null,"2020-06-11","2020-09-10","3 months contract. Storage rental paid by bank transfer on May 16,2020. Storage deposit $2,936 transferred from agreement C15-CT207344 to this agreement.","2020-06-11","24",0,null,0,"0","2","2020-05-16 14:01:30","2","2020-05-16 14:01:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180918","PERSONAL","Mrs","HGSr\/4NUklUwNPOT6LyvzQ==","wJQSZpXGs\/iPthecZsEzXA==","","6qAFKsY2wYrSL+QlaUgJzlgFeq+4QM6\/PgzW\/EPwJEnwsvyfNBYGV0qIHs8X4rE8DnL7HsuO101d9UPTmYCtOA==","BsdtSBOUNtjWiYn3vo9VfQ==","SQ9wa28Pf0jr8etLawngCaTmhsZjMdvvkiOcKAKp2tc=","FzWr1978iA0B4TB8JWUNww==",null,1,"4280"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","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":["7866","419","173","1423","%","5.00",66.1,"2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7866","1423","1322.0",1255.9,"2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2020-09-10","1423"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866",918,"SETTLED","C15-I208195","2020-05-16 14:01:30","2020-06-11","2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8195","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8195","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8195","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"8195"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[918,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207840","2020-05-16 14:01:30",4185,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7840","DEPOSIT",null,"PAID","2020-05-16 14:01:30",0,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:01:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7840","INVOICE","8195","PAID","2020-05-16 14:01:30",4185,"2","2020-05-16 14:01:30","2","2020-05-16 14:01:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":319,"customer_code":"C170319","identity_type":"PERSONAL","identity_id":"D666363(0)","title":"Mr","lastname":"Chau","firstname":"Johnny","companyname":"","email":"yochau@gmail.com","tel":"91220103","address":"F6,9\/F,Block A, Hoi Chun Court ,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"054,20556","renew_remark":"6 months contract. Storage rental paid by PPS on December 04, 2019. Storage deposit transferred from agreement A14-CT195085 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196631, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"57","order_discount":[],"order_room":[{"room_id":"771","room_code":"P05","retail_price":"2598.0","discounted_price":"2598.00","location_id":"2"}],"roughly_size":"36","total_retail_price":2598,"total_discounted_price":2018,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 16, 2020. Storage deposit transferred from agreement A14-CT196631 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":12108,"final_order_total":12108,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,20556","order_product":[],"pass":true}},"first_order_id":"3746","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> P05 <\/td>\r\n\t\t\t\t\t 6X6X8 <\/td>\r\n\t\t\t\t\t $2598.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":"36","total_discounted_price":"2018.0","deposit":"0","total_retail_price":"2598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",319,"NEW","A14-CT207867",2598,2018,0,0,"6","6",12108,12108,12108,"2020-05-16 14:55:56","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental paid by EPS on May 16, 2020. Storage deposit transferred from agreement A14-CT196631 to this agreement.\r\n","2020-06-01","36",0,null,0,"0","2","2020-05-16 14:55:56","2","2020-05-16 14:55:56","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,20556","C170319","PERSONAL","Mr","gB3lOIKGw08oQZ3wGQ6W1A==","kOK3vHUlGE9qjoVnzYRDGA==","","+LY9jXB08\/ROlmf4tzd27P8Mkuaz0h1tHAIFO8mmunmtAR9jFk\/vMM7p017YOl0w","mnS\/3SejyDp+HtKK62q4bg==","6Z6kRGeB+1Bh1yVv\/7xDR221AjEyh33x40NlFt8RDPo=","n49aoPqb+ZhlfDpx0SZV3Q==",null,1,"3746"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["7867","771","2598.0","2598.00","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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-06-01","2020-11-30","771"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 14:55: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":["7867",319,"SETTLED","A14-I208196","2020-05-16 14:55:56","2020-06-01","2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["8196","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12108,0,"8196"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 14:55: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":[319,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207841","2020-05-16 14:55:56",12108,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["7841","DEPOSIT",null,"PAID","2020-05-16 14:55:56",0,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 14:55: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":["7841","INVOICE","8196","PAID","2020-05-16 14:55:56",12108,"2","2020-05-16 14:55:56","2","2020-05-16 14:55:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1372&filter3=undefined","floor_plan_rent_room":[{"room_id":"25","master_room_id":"8","room_code":"A25"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A25 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G545824(1)","title":"Mr","lastname":"CHAN","firstname":"Kin Yu","companyname":"","email":"","tel":"97322022","address":"21A, Blk 19, Baguio Villa, Pok Fu Lam, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"25","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"25","room_code":"A25","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3633,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-08-16","delivery_service":"0","remark":"3 months contract. Special offer the first 3 months 50% off. Storage rental and deposit paid by cash on May 16, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1557,"order_total":5190,"final_order_total":3633,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26402","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03:55","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":["C201582","PERSONAL","Mr","XK4ndW\/siPJFtMWBlThLuQ==","8BEgNhGpCR8jGkzUtrIcXg==","","c9hr8RExvDgQbM4JQF9aNQ==",null,"eaCsIt29tsfdQDSwplutdrDr2yJIaAhwKwxlabEicTOmocg9bGRYraxSEQjIgY1IBGlf9hs869pzll5n8Jfz7w==","IfSHt3obNdhOr51klLh4AQ==",null,null,"tP61iT1uXiGhTtFo0PJf3Q==","2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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","1",1582,"NEW","A12-CT207868",1098,1038,2076,0,"3","3",3633,5190,3633,"2020-05-16 15:03:56","0",null,null,null,"2020-05-17","2020-08-16","3 months contract. Special offer the first 3 months 50% off. Storage rental and deposit paid by cash on May 16, 2020. ","2020-05-17","16",0,null,1557,"1557.00","2","2020-05-16 15:03:54","2","2020-05-16 15:03:54","CASH","","","","CASH","","","",null,0,"190,26402","C201582","PERSONAL","Mr","XK4ndW\/siPJFtMWBlThLuQ==","8BEgNhGpCR8jGkzUtrIcXg==","","eaCsIt29tsfdQDSwplutdrDr2yJIaAhwKwxlabEicTOmocg9bGRYraxSEQjIgY1IBGlf9hs869pzll5n8Jfz7w==","c9hr8RExvDgQbM4JQF9aNQ==",null,"IfSHt3obNdhOr51klLh4AQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03:56","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":["7868","433","8","25","%","4.97",54.5706,"2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["7868","25","1098.0",1043.4,"2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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-05-17","2020-08-16","25"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:03: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":["7868","A12-D205411","PAID",2076,0,"2020-08-16","2020-05-16 15:03:54","2020-05-16 15:03:54","2","2020-05-16 15:03:54","2","2020-05-16 15:03:54",1582]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["7868",1582,"SETTLED","A12-I208197","2020-05-16 15:03:54","2020-05-17","2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["8197","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["8197","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["8197","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1557,0,"8197"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:03: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":[1582,"CASH","","","","CASH","","","","PAID","P207842","2020-05-16 15:03:54",3633,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["7842","DEPOSIT","5411","PAID","2020-05-16 15:03:54",2076,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:03: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":["7842","INVOICE","8197","PAID","2020-05-16 15:03:54",1557,"2","2020-05-16 15:03:54","2","2020-05-16 15:03:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1372&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-060 <\/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> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D653159(9)","title":"Ms","lastname":"KWONG","firstname":"Po Yee","companyname":"","email":"hidikwong@yahoo.com","tel":"98550930","address":"Flat A, 31\/F, Tower 7, South Horizons, Apleichau, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1551","room_code":"A16-060","retail_price":"1006.0","discounted_price":"1006.00","location_id":"7"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":775,"deposit":1550,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":9689,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1936.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-06-30","delivery_service":"0","remark":"13 months contract. Special offer the first 3 months 50% off and the 13th month free. Storage deposit $500 paid by cash on April 18, 2020. remaining balance paid by cheque on May 16, 2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1936,"order_total":11625,"final_order_total":9689,"location_id":"7","branch_id":"1","company_id":"1","room_key":"0005013299","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["C201583","PERSONAL","Ms","KJ\/4rvfsBjfYlDcSJVrz7Q==","A56wv0bn2sxwj32M4vQv7w==","","VA8Xf6suF77N1vYZJyoLoA==","bzafhMBAhN+77X7MsLNZtgzwUfRTVhdkGX3VMmc1j1Q=","\/sgorcLfZxA6V2zEhL99PfFcmStZLf7hUpNbpB9rnOUZVT+7hTvXBHD3muVt5cQdN1XK5JtRePpY4sztbsstUg==","OBz5jhg6WXXnbtrkuRJZ7g==",null,"bzafhMBAhN+77X7MsLNZtgzwUfRTVhdkGX3VMmc1j1Q=","DE8kp\/i0R4I7RLGmQHIf+w==","2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1583,"NEW","A16-CT207869",1006,775,1550,0,"13","13",9689,11625,9689,"2020-05-16 15:16:41","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer the first 3 months 50% off and the 13th month free. Storage deposit $500 paid by cash on April 18, 2020. remaining balance paid by cheque on May 16, 2020.","2020-06-01","9",0,null,1936,"1936.00","2","2020-05-16 15:16:39","2","2020-05-16 15:16:39","CHEQUE","","","","CHEQUE","","","",null,0,"0005013299","C201583","PERSONAL","Ms","KJ\/4rvfsBjfYlDcSJVrz7Q==","A56wv0bn2sxwj32M4vQv7w==","","\/sgorcLfZxA6V2zEhL99PfFcmStZLf7hUpNbpB9rnOUZVT+7hTvXBHD3muVt5cQdN1XK5JtRePpY4sztbsstUg==","VA8Xf6suF77N1vYZJyoLoA==","bzafhMBAhN+77X7MsLNZtgzwUfRTVhdkGX3VMmc1j1Q=","OBz5jhg6WXXnbtrkuRJZ7g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["7869","1551","1006.0","1006.00","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-06-30","1551"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:16:41","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":["7869","A16-D205412","PAID",1550,0,"2021-06-30","2020-05-16 15:16:39","2020-05-16 15:16:39","2","2020-05-16 15:16:39","2","2020-05-16 15:16:39",1583]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["7869",1583,"SETTLED","A16-I208198","2020-05-16 15:16:39","2020-06-01","2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,389,"MO","1",389,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",4,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",5,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",6,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",7,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",8,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",9,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",10,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",11,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",12,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["8198","RENT","\u9810\u7e73\u79df\u91d1",13,775,"MO","1",775,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8139,0,"8198"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:16:41","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":[1583,"CHEQUE","","","","CHEQUE","","","","PAID","P207843","2020-05-16 15:16:39",9689,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["7843","DEPOSIT","5412","PAID","2020-05-16 15:16:39",1550,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:16:41","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":["7843","INVOICE","8198","PAID","2020-05-16 15:16:39",8139,"2","2020-05-16 15:16:39","2","2020-05-16 15:16:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:27:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1372&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":450,"customer_code":"C170450","identity_type":"PERSONAL","identity_id":"D506976(A)","title":"Mr","lastname":"Pong","firstname":"Tze Kin","companyname":"","email":"simontkpong@gmail.com","tel":"93615951","address":"Rm1202 ,Kai Tak Commerical Building , 66 Stanley Street ,Central ,HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-19","renew_room_key":"054,46056,190,65019","renew_remark":"6 months contract. Storage rental paid by cheque on Nov 23, 2019. Storage deposit transferred from agreement A14-CT195000 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196487, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"619","room_code":"M30","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-05-19","rent_from":"2020-05-19","rent_to":"2020-11-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 16, 2020. Storage deposit transferred from agreement A14-CT196487 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,46056,190,65019","order_product":[],"pass":true}},"first_order_id":"3641","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> M30 <\/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-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",450,"NEW","A14-CT207870",598,538,0,0,"6","6",3228,3228,3228,"2020-05-16 15:34:55","0",null,null,null,"2020-05-19","2020-11-18","6 months contract. Storage rental paid by cash on May 16, 2020. Storage deposit transferred from agreement A14-CT196487 to this agreement.","2020-05-19","12",0,null,0,"0","2","2020-05-16 15:34:54","2","2020-05-16 15:34:54","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"054,46056,190,65019","C170450","PERSONAL","Mr","TDX6zYL9UKHyHL2dX6SwYg==","8iBhWi93S6DvaSaCpDmcag==","","DSqavAwdVHtQ+ki55oreEa46bY6sJ8Qv4H6BdLhytdGZAFng+bGFFcK\/O\/b0cDdGQGYZDjlUPU\/xqL7faSQsUZCE08l18h7xiC7iOnO2yzE=","8VQaprheDsfoDofRAdSQuA==","uAPWWask0LTCNrtlYfGhBOE5ijoiAxbCkAS9W9Mzq8M=","R6\/I2QlHFZ+n9Mq3crfEBg==",null,1,"3641"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7870","619","598.0","598.00","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-19","2020-11-18","619"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7870",450,"SETTLED","A14-I208199","2020-05-16 15:34:54","2020-05-19","2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8199"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[450,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207844","2020-05-16 15:34:54",3228,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7844","DEPOSIT",null,"PAID","2020-05-16 15:34:54",0,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:34:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7844","INVOICE","8199","PAID","2020-05-16 15:34:54",3228,"2","2020-05-16 15:34:54","2","2020-05-16 15:34:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:41:22","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","0005013299","13 months contract. Special offer the first 3 months 50% off and the 13th month free. Storage deposit $500 paid by cash on April 18, 2020. remaining balance paid by cheque on May 16, 2020.","2020-05-16 15:41:22","2","A56wv0bn2sxwj32M4vQv7w==","KJ\/4rvfsBjfYlDcSJVrz7Q==","bzafhMBAhN+77X7MsLNZtgzwUfRTVhdkGX3VMmc1j1Q=","VA8Xf6suF77N1vYZJyoLoA==","\/sgorcLfZxA6V2zEhL99PfFcmStZLf7hUpNbpB9rnOUZVT+7hTvXBHD3muVt5cQdN1XK5JtRePpY4sztbsstUg==",7869]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-060 <\/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> <\/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":"D653159(9)","title":"Ms","lastname":"KWONG","firstname":"Po Yee","companyname":"","email":"hidikwong@yahoo.com","tel":"98550930","address":"Flat A, 31\/F, Tower 7, South Horizons, Apleichau, Hong Kong","pass":true,"customer_id":"1583","customer_code":"C201583","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1551","room_code":"A16-060","retail_price":"1006.0","discounted_price":"1006.00","location_id":"7"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":698,"deposit":1550,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":9518,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1106.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-06-30","delivery_service":"0","remark":"13 months contract. Special offer 5% \"Rent Now\" discount and the 13th month free. Storage deposit and rental paid by cheque on May 16, 2020. Smartcard provided on May 16, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1106,"order_total":10624,"final_order_total":9518,"location_id":"7","branch_id":"1","company_id":"1","room_key":"0005012399","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"698.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1583","NEW","A16-CT207871",1006,698,1550,0,"13","13",9518,10624,9518,"2020-05-16 15:44:40","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer 5% \"Rent Now\" discount and the 13th month free. Storage deposit and rental paid by cheque on May 16, 2020. Smartcard provided on May 16, 2020. ","2020-06-01","9",0,null,1106,"1106.00","2","2020-05-16 15:44:40","2","2020-05-16 15:44:40","CHEQUE","","","","CHEQUE","","","",null,0,"0005012399","C201583","PERSONAL","Ms","KJ\/4rvfsBjfYlDcSJVrz7Q==","A56wv0bn2sxwj32M4vQv7w==","","\/sgorcLfZxA6V2zEhL99PfFcmStZLf7hUpNbpB9rnOUZVT+7hTvXBHD3muVt5cQdN1XK5JtRePpY4sztbsstUg==","VA8Xf6suF77N1vYZJyoLoA==","bzafhMBAhN+77X7MsLNZtgzwUfRTVhdkGX3VMmc1j1Q=","OBz5jhg6WXXnbtrkuRJZ7g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7871","1551","1006.0","1006.00","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-06-30","1551"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:44:40","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":["7871","A16-D205413","PAID",1550,0,"2021-06-30","2020-05-16 15:44:40","2020-05-16 15:44:40","2","2020-05-16 15:44:40","2","2020-05-16 15:44:40","1583"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7871","1583","SETTLED","A16-I208200","2020-05-16 15:44:40","2020-06-01","2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,290,"MO","1",290,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",7,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",8,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",9,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",10,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",11,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",12,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8200","RENT","\u9810\u7e73\u79df\u91d1",13,698,"MO","1",698,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7968,0,"8200"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1583","CHEQUE","","","","CHEQUE","","","","PAID","P207845","2020-05-16 15:44:40",9518,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7845","DEPOSIT","5413","PAID","2020-05-16 15:44:40",1550,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:44:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7845","INVOICE","8200","PAID","2020-05-16 15:44:40",7968,"2","2020-05-16 15:44:40","2","2020-05-16 15:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":368,"customer_code":"C170368","identity_type":"PERSONAL","identity_id":"D636636(9)","title":"Mr","lastname":"Fung","firstname":"Chi Wai","companyname":"","email":"ericfung0901@yahoo.com.hk","tel":"90986315","address":"Rm2 , 3\/F, Tin Fai House , Yue Fai Court ,Aberdeen ","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1679.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-23","renew_room_key":"055,49004","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on April 23, 2019. Storage deposit transferred from agreement A12-CT183310 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194802, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"23","order_discount":[{"master_room_discount_id":"89","master_room_id":"23","discount_type":"%","price":"2188.00","disocunted_price":"1817.60","discount":"16.93","monthly_deduct":370.4284,"room_id":"76","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"76","room_code":"B24","retail_price":"2188.0","discounted_price":1817.6,"location_id":"1"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":1679,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":20148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2021-05-22","delivery_service":"0","remark":"12 months contract. Special renewal $300 Maxim's voucher.. Storage rental paid by cheque on May 16, 2020. Storage deposit transferred from agreement A12-CT194802 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":20148,"final_order_total":20148,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49004","order_product":[],"pass":true}},"first_order_id":4802,"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> B24 <\/td>\r\n\t\t\t\t\t 5X6X8 <\/td>\r\n\t\t\t\t\t $2188.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"1679.00","deposit":"0.00","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",368,"NEW","A12-CT207872",2188,1679,0,0,"12","12",20148,20148,20148,"2020-05-16 15:47:06","0",null,null,null,"2020-05-23","2021-05-22","12 months contract. Special renewal $300 Maxim's voucher.. Storage rental paid by cheque on May 16, 2020. Storage deposit transferred from agreement A12-CT194802 to this agreement.","2020-05-23","30",0,null,0,"0","2","2020-05-16 15:47:05","2","2020-05-16 15:47:05","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,49004","C170368","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","fw9NU0t2sgJqYX3ZpxPMlA==","","OcbuIjZFL4IbmusAQn6GJb4NgZ6iBZ6xZOMBLs40vmrrGy\/0laiG\/R9AqeyLt1bEjnkOKG3aEbYpUKEbVRSNFA==","wQ01lEGPZ0SJWZtG\/pWmJA==","7p65zX25VBG1qK5WSf7S7K+uF0bXMVVZGfvjufm\/3xo=","X4mkxv7\/bvO+fLtnuJsx7g==",null,1,4802]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","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":["7872","89","23","76","%","16.93",370.4284,"2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7872","76","2188.0",1817.6,"2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-23","2021-05-22","76"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7872",368,"SETTLED","A12-I208201","2020-05-16 15:47:05","2020-05-23","2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",1,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",2,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",3,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",4,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",5,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",6,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",7,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",8,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",9,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",10,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",11,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8201","RENT","\u9810\u7e73\u79df\u91d1",12,1679,"MO","1",1679,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20148,0,"8201"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[368,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207846","2020-05-16 15:47:05",20148,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7846","DEPOSIT",null,"PAID","2020-05-16 15:47:05",0,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:47:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7846","INVOICE","8201","PAID","2020-05-16 15:47:05",20148,"2","2020-05-16 15:47:05","2","2020-05-16 15:47:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49:13","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":368,"customer_code":"C170368","identity_type":"PERSONAL","identity_id":"D636636(9)","title":"Mr","lastname":"Fung","firstname":"Chi Wai","companyname":"","email":"ericfung0901@yahoo.com.hk","tel":"90986315","address":"Rm2 , 3\/F, Tin Fai House , Yue Fai Court ,Aberdeen ","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-23","renew_room_key":"055,54092","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on April 23, 2019. Storage deposit transferred from agreement A14-CT183311 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194803, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"509","room_code":"K46","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"508","room_code":"K45","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2021-05-22","delivery_service":"0","remark":"12 months contract. Special renewal offer $300 Maxim's voucher. Storage rental paid by cheque on May 16, 2020. Storage deposit transferred from agreement A14-CT194803 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":21456,"final_order_total":21456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,54092","order_product":[],"pass":true}},"first_order_id":4803,"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> K46 <\/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> K45 <\/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":"32","total_discounted_price":"1788.00","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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",368,"NEW","A14-CT207873",2196,1788,0,0,"12","12",21456,21456,21456,"2020-05-16 15:49:13","0",null,null,null,"2020-05-23","2021-05-22","12 months contract. Special renewal offer $300 Maxim's voucher. Storage rental paid by cheque on May 16, 2020. Storage deposit transferred from agreement A14-CT194803 to this agreement.\r\n","2020-05-23","32",0,null,0,"0","2","2020-05-16 15:49:13","2","2020-05-16 15:49:13","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,54092","C170368","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","fw9NU0t2sgJqYX3ZpxPMlA==","","OcbuIjZFL4IbmusAQn6GJb4NgZ6iBZ6xZOMBLs40vmrrGy\/0laiG\/R9AqeyLt1bEjnkOKG3aEbYpUKEbVRSNFA==","wQ01lEGPZ0SJWZtG\/pWmJA==","7p65zX25VBG1qK5WSf7S7K+uF0bXMVVZGfvjufm\/3xo=","X4mkxv7\/bvO+fLtnuJsx7g==",null,1,4803]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["7873","509","1098.0","1098.00","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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-05-23","2021-05-22","509"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:49: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":["7873","508","1098.0","1098.00","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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-05-23","2021-05-22","508"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:49: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":["7873",368,"SETTLED","A14-I208202","2020-05-16 15:49:13","2020-05-23","2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["8202","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[21456,0,"8202"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:49: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":[368,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207847","2020-05-16 15:49:13",21456,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["7847","DEPOSIT",null,"PAID","2020-05-16 15:49:13",0,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:49: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":["7847","INVOICE","8202","PAID","2020-05-16 15:49:13",21456,"2","2020-05-16 15:49:13","2","2020-05-16 15:49:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-061 <\/td>\n\t\t\t\t\t 3X3X7 <\/td>\n\t\t\t\t\t $1006.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z033417(1)","title":"Ms","lastname":"YAM","firstname":"Hei Ngan Chermaine","companyname":"","email":"yamcher210@yahoo.com.hk","tel":"96768506","address":"Flat B, 9\/F, Tower 17, Mei Fai Court, South Horizons, Ap Lei Chau, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1552","room_code":"A16-061","retail_price":"1006.0","discounted_price":"1006.00","location_id":"7"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":775,"deposit":1550,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":9689,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1936.00","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2021-06-16","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by EPS on May 16,2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1936,"order_total":11625,"final_order_total":9689,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,51828","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","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":["C201584","PERSONAL","Ms","zT7xeVokVVX0NfBA26\/3nxjTvOd3JMSXwxv0\/mZI3io=","le6KIxBgjHuOC2ioCtSI0w==","","lS1JJaE\/+MqOqsaqoB9Uxw==","fP4nbmQ0x7odWXVz5lRhfCkF2NLzJma4g2wUaDopoTg=","R5KRLaKaGDNs1jmCb6YE7vKozlEzlOdphvN0MTcQVGQgqLHFoTl1jz7k5B7JZsGFhLh4lj5D1VcmotY4gC4KU9MU\/7tbKjvljKtyQ9eqEBU=","YRYVcEiO+9wg+k1Yz0FjXA==",null,"fP4nbmQ0x7odWXVz5lRhfCkF2NLzJma4g2wUaDopoTg=","tmy7JB3Z28tCQ9XG9+Gv1w==","2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1584,"NEW","A16-CT207874",1006,775,1550,0,"13","13",9689,11625,9689,"2020-05-16 15:57:36","0",null,null,null,"2020-05-17","2021-06-16","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by EPS on May 16,2020. Smart card provided on the same day.","2020-05-17","9",0,null,1936,"1936.00","2","2020-05-16 15:57:34","2","2020-05-16 15:57:34","EPS","","","","EPS","","","",null,0,"189,51828","C201584","PERSONAL","Ms","zT7xeVokVVX0NfBA26\/3nxjTvOd3JMSXwxv0\/mZI3io=","le6KIxBgjHuOC2ioCtSI0w==","","R5KRLaKaGDNs1jmCb6YE7vKozlEzlOdphvN0MTcQVGQgqLHFoTl1jz7k5B7JZsGFhLh4lj5D1VcmotY4gC4KU9MU\/7tbKjvljKtyQ9eqEBU=","lS1JJaE\/+MqOqsaqoB9Uxw==","fP4nbmQ0x7odWXVz5lRhfCkF2NLzJma4g2wUaDopoTg=","YRYVcEiO+9wg+k1Yz0FjXA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7874","1552","1006.0","1006.00","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2021-06-16","1552"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 15:57:36","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":["7874","A16-D205414","PAID",1550,0,"2021-06-16","2020-05-16 15:57:34","2020-05-16 15:57:34","2","2020-05-16 15:57:34","2","2020-05-16 15:57:34",1584]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7874",1584,"SETTLED","A16-I208203","2020-05-16 15:57:34","2020-05-17","2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,389,"MO","1",389,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",4,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",5,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",6,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",7,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",8,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",9,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",10,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",11,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",12,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8203","RENT","\u9810\u7e73\u79df\u91d1",13,775,"MO","1",775,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8139,0,"8203"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1584,"EPS","","","","EPS","","","","PAID","P207848","2020-05-16 15:57:34",9689,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7848","DEPOSIT","5414","PAID","2020-05-16 15:57:34",1550,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 15:57:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7848","INVOICE","8203","PAID","2020-05-16 15:57:34",8139,"2","2020-05-16 15:57:34","2","2020-05-16 15:57:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22:55","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1551","master_room_id":"194","room_code":"A16-060"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":64,"customer_code":"C160064","identity_type":"PERSONAL","identity_id":"D441033(6)","title":"Mr","lastname":"Wong ","firstname":"Chi Yee, Stephen","companyname":"","email":"stephen_wong88@yahoo.com.hk","tel":"92785095","address":"Flat 21\/F, Port Centre, 38 Chengtu Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-30","renew_room_key":"053,60784","renew_remark":"6 months contract. Storage rental paid by cash on Nov 28, 2019. Storage deposit transferred from agreement A12-CT195079 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196519, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"18","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"18","room_code":"A18","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-30","rent_from":"2020-05-30","rent_to":"2020-11-29","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A12-CT196519 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,60784","order_product":[],"pass":true}},"first_order_id":"3689","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> A18 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",64,"NEW","A12-CT207875",1098,935,0,0,"6","6",5610,5610,5610,"2020-05-16 16:22:56","0",null,null,null,"2020-05-30","2020-11-29","6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A12-CT196519 to this agreement.\r\n","2020-05-30","16",0,null,0,"0","2","2020-05-16 16:22:55","2","2020-05-16 16:22:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,60784","C160064","PERSONAL","Mr","uAYTiWLb3rhAHTjO1T7T4QvN3ZAgod6mvDkI5dvUZ7w=","DgLsCGM4faTvgwjKBW9M0A==","","RZT5dUAei5RbsYGeq7HiJtIN8iikWbIx7b0twBRbdSECpLVroSnhPQxSABVI9KwGBUSmEaQoeiW1yt5+ZENrQg==","STnENrBUqKPeYBPscNLQDw==","3XECO0M19qnNFuqkvzhALNa3Ra34dDWf1DSnS8Jxy9g=","rnTzOc31Qb5Y\/vtsMnyf9A==",null,1,"3689"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22:56","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":["7875","72","8","18","%","9.93",109.0314,"2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["7875","18","1098.0",989,"2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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-05-30","2020-11-29","18"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-16 16:22: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":["7875",64,"SETTLED","A12-I208204","2020-05-16 16:22:55","2020-05-30","2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["8204","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8204"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-16 16:22: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":[64,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207849","2020-05-16 16:22:55",5610,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["7849","DEPOSIT",null,"PAID","2020-05-16 16:22:55",0,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 16:22: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":["7849","INVOICE","8204","PAID","2020-05-16 16:22:55",5610,"2","2020-05-16 16:22:55","2","2020-05-16 16:22:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-16 19:50:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****