{"created_at":"2020-01-06 09:58:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 10:22:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":60,"customer_code":"C160060","identity_type":"PERSONAL","identity_id":"G180394(7)","title":"Mr","lastname":"Cheung","firstname":"Hui Wah","companyname":"","email":"alfredcheung3@gmail.com","tel":"90833311","address":"Flat G ,18\/F.,Tower 13A, South Horizons Apleichau HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1887.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-01","renew_room_key":"054,09131","renew_remark":"3 months contract. Storage rental paid by bank transfer on August 28, 2019. Storage deposit transferred from agreement A12-CT194525 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195818, \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":"137","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"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":"151","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"151","room_code":"C27","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"137","room_code":"C13","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-05-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on January 6, 2020. Storage deposit transferred from agreement A12-CT195818 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,09131","order_product":[],"pass":true}},"first_order_id":"4525","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>
C27 <\/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>
C13 <\/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":"32","total_discounted_price":"1788.00","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",60,"NEW","A12-CT206868",2196,1788,0,0,"6","6",10728,10728,10728,"2020-01-06 11:08:46","0",null,null,null,"2019-12-01","2020-05-31","6 months contract. Storage rental paid by EPS on January 6, 2020. Storage deposit transferred from agreement A12-CT195818 to this agreement.\r\n","2019-12-01","32",0,null,0,"0","2","2020-01-06 11:08:46","2","2020-01-06 11:08:46","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,09131","C160060","PERSONAL","Mr","\/81wQS3F2mq9tQdVdXB8cQ==","vCxOlXQuvOQaoL822H2o\/Q==","","\/ICHAfZJhtwhZA5reMeSD7Ws2wsSqn7PzAEiwMxgA6y0DiFZX4g\/0Hi97UBJg2b4PjRzZPL1+T0YPglHNUw4Tw==","8I7V5dQ3eccEOtZs3Vnu5g==","efc4ViIfxHNHVNeT8zMlq9zbhu2jG2\/nwizbHi8huYU=","O+jz4fRqyC29a5UiODe3sA==",null,1,"4525"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","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":["6868","72","8","137","%","9.93",109.0314,"2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","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":["6868","72","8","151","%","9.93",109.0314,"2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6868","151","1098.0",989,"2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-05-31","151"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6868","137","1098.0",989,"2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-05-31","137"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6868",60,"SETTLED","A12-I207196","2020-01-06 11:08:46","2019-12-01","2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7196","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"7196"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[60,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P206846","2020-01-06 11:08:46",10728,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6846","DEPOSIT",null,"PAID","2020-01-06 11:08:46",0,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 11:08:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6846","INVOICE","7196","PAID","2020-01-06 11:08:46",10728,"2","2020-01-06 11:08:46","2","2020-01-06 11:08:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:25:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":467,"customer_code":"C170467","identity_type":"PERSONAL","identity_id":"K228968(7)","title":"Ms","lastname":"Tang","firstname":"Hok Wan Wendy","companyname":"","email":null,"tel":"93887546","address":"Flat H,1\/F , Tower 11,South Horizons, Apleichau ,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-24","renew_room_key":"054,28050","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 2, 2019. Storage deposit transferred from agreement A14-CT183819 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195136, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"631","room_code":"M42","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":"2019-11-24","rent_from":"2019-11-24","rent_to":"2020-05-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A14-CT195136 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,28050","order_product":[],"pass":true}},"first_order_id":"3819","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> M42 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",467,"NEW","A14-CT206869",598,538,0,0,"6","6",3228,3228,3228,"2020-01-06 12:40:24","0",null,null,null,"2019-11-24","2020-05-23","6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A14-CT195136 to this agreement.\r\n","2019-11-24","12",0,null,0,"0","2","2020-01-06 12:40:24","2","2020-01-06 12:40:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,28050","C170467","PERSONAL","Ms","rp+CRHd3q27YBSGVkpKFJw==","M7CfcmE2OSMlZOkNgaoDmQ==","","WwdsUaXJdCyQS4zYpdyuOVjUNMKmyKrdBODcznhrf+t5NpCofkZQBw1Qjazwv\/2U+jo6JWKS1nWqDh\/KyHmMPQ==","oQPnXzlgWqYAR5qCetSjIg==",null,"2KF8ygyfFTr1R1qVr4x5gA==",null,1,"3819"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6869","631","598.0","598.00","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-24","2020-05-23","631"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6869",467,"SETTLED","A14-I207197","2020-01-06 12:40:24","2019-11-24","2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7197","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7197"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[467,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206847","2020-01-06 12:40:24",3228,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6847","DEPOSIT",null,"PAID","2020-01-06 12:40:24",0,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:40:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6847","INVOICE","7197","PAID","2020-01-06 12:40:24",3228,"2","2020-01-06 12:40:24","2","2020-01-06 12:40:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":702,"customer_code":"C180702","identity_type":"PERSONAL","identity_id":"G034567(8)","title":"Mr","lastname":"Chum","firstname":"Kwok Leung Clement","companyname":"","email":"clementklchum@gmail.com","tel":"93332460","address":"Room 1403, Wah Shun House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-06","renew_room_key":"136,62564","renew_remark":"6 months contract. Storage rental paid by cheque deposit on July 2, 2019. Storage deposit transferred from agreement A18-CT194058 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195385, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"910","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"910","room_code":"U11","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-07-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195385 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"136,62564","order_product":[],"pass":true}},"first_order_id":"4058","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> U11 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",702,"NEW","A18-CT206870",1605,1445,0,0,"6","6",8670,8670,8670,"2020-01-06 12:50:16","0",null,null,null,"2020-01-06","2020-07-05","6 months contract. Storage rental paid by cheque deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195385 to this agreement.","2020-01-06","20",0,null,0,"0","2","2020-01-06 12:50:16","2","2020-01-06 12:50:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,62564","C180702","PERSONAL","Mr","qOBeY8pBdnZK7Wfi37j1Vc+wBUyTRpMiJdxfTxspOeY=","njl5Lx5qDFHpqhsximKa\/w==","","GcLlLlLemvn8j\/urkh17rLlKoLqySTMMvt2M953LUhlQjowYkpYdIVbx16A6\/eX60IIcmfvltSPsesv1T4L89g==","6xdSyD3MgYfUvphJ2qbRaw==","HU\/zNv3mqeyoHam1BSGa6KVCyrmviBCLA7MPth8wD2o=","uZhy+woih1UP5YA7yyH2Mg==",null,1,"4058"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","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":["6870","254","78","910","%","10.00",160.5,"2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","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":["6870","910","1605.0",1444.5,"2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-07-05","910"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 12:50:16","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":["6870",702,"SETTLED","A18-I207198","2020-01-06 12:50:16","2020-01-06","2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7198","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"7198"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 12:50:16","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":[702,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206848","2020-01-06 12:50:16",8670,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","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":["6848","DEPOSIT",null,"PAID","2020-01-06 12:50:16",0,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:50:16","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":["6848","INVOICE","7198","PAID","2020-01-06 12:50:16",8670,"2","2020-01-06 12:50:16","2","2020-01-06 12:50:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":123,"customer_code":"C160123","identity_type":"PERSONAL","identity_id":"K985797(4)","title":"Mr","lastname":"Wong","firstname":"Chun Wa","companyname":"","email":"da_shi_xing@yahoo.com.hk","tel":"97211092","address":"\u9999\u6e2f\u4ed4\u820a\u5927\u885764-70\u6d77\u6d0b\u5927\u53a611\/F A\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1205.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-28","renew_room_key":"056,14935","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 11, 2019. Storage deposit transferred from agreement A12-CT195478 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196284, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"203","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1451.60","discount":"5.00","monthly_deduct":76.4,"room_id":"74","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"74","room_code":"B22","retail_price":"1528.0","discounted_price":1451.6,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-28","rent_from":"2019-12-28","rent_to":"2020-03-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 4, 2019. Storage deposit transferred from agreement A12-CT196284 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"056,14935","order_product":[],"pass":true}},"first_order_id":"4045","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> B22 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/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":"20","total_discounted_price":"1205.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",123,"NEW","A12-CT206871",1528,1205,0,0,"3","3",3615,3615,3615,"2020-01-06 12:55:07","0",null,null,null,"2019-12-28","2020-03-27","3 months contract. Storage rental paid by bank transfer on January 4, 2019. Storage deposit transferred from agreement A12-CT196284 to this agreement.\r\n","2019-12-28","20",0,null,0,"0","2","2020-01-06 12:55:07","2","2020-01-06 12:55:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,14935","C160123","PERSONAL","Mr","2y\/HW6zO6jcyaFY9OjJ4UQ==","hULSwM2MvFtpeV9\/z+er8Q==","","+97LJ6GdzfH7z6EWZQAAnM4Lhk\/TgoCRtSl1aUoVVK0H0sjfTZlurNOGa+FyRArG","ZUeDOVCZoXbgLNrFtMnPKg==","5EuU+O7hnAW9FT9B2P\/TVwfEumzGSzhL3ZP3b7X2X\/M=","0yz9ajAoJI7BeuloG4V3sw==",null,1,"4045"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","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":["6871","203","10","74","%","5.00",76.4,"2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6871","74","1528.0",1451.6,"2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-28","2020-03-27","74"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6871",123,"SETTLED","A12-I207199","2020-01-06 12:55:07","2019-12-28","2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7199","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7199","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7199","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"7199"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[123,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206849","2020-01-06 12:55:07",3615,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6849","DEPOSIT",null,"PAID","2020-01-06 12:55:07",0,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:55:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6849","INVOICE","7199","PAID","2020-01-06 12:55:07",3615,"2","2020-01-06 12:55:07","2","2020-01-06 12:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","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=1171&filter3=undefined&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":"1314","master_room_id":"164","room_code":"C15-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1115,"customer_code":"C181115","identity_type":"PERSONAL","identity_id":"D703803(9)","title":"Ms","lastname":"Au","firstname":"Chui Ming","companyname":"","email":"au.chuiming@gmail.com","tel":"92728030","address":"Room 1724, Lei Chak House, Ap Lei Chau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"0012436805","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by cheque on November 24, 2018. Smartcard provided on November 24, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183725, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2180.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1044","room_code":"A05-042","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-11-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on Jan 06,2020. Deposit $2180 transferred from agreement A05-CT183725 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":11772,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012436805","order_product":[],"pass":true}},"first_order_id":3725,"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-042 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1115,"NEW","A05-CT206872",1090,981,0,0,"12","12",11772,11772,11772,"2020-01-06 12:56:02","0",null,null,null,"2019-12-01","2020-11-30","12 months contract. Storage rental paid by cheque on Jan 06,2020. Deposit $2180 transferred from agreement A05-CT183725 to this agreement.","2019-12-01","12",0,null,0,"0","2","2020-01-06 12:56:02","2","2020-01-06 12:56:02","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012436805","C181115","PERSONAL","Ms","Q56B9QGYKLXdJgfqtvtaeg==","egeOlBPCZ2i\/hzcvvQMisg==","","782q6JFVlZSPZTSBV\/KL\/2bFyWuNEfWtOrnG\/Mtsu5sKsG3eO1YnxjcpcJWA2HTv8p7jgjk929PKOgk3XC8WqQg6O4+vikSJBfkTy4I+He8=","7JbCLZGsY28AGQcUyxilRA==","Adq0zogh6RqPTu1\/kTGqllaVZlhwi9WOVJhPajkI7Fo=","rZshLOc9DRWA+CohKERmdg==",null,1,3725]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6872","1044","1090.0","1090.00","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-11-30","1044"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6872",1115,"SETTLED","A05-I207200","2020-01-06 12:56:02","2019-12-01","2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7200","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"7200"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1115,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206850","2020-01-06 12:56:02",11772,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6850","DEPOSIT",null,"PAID","2020-01-06 12:56:02",0,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 12:56:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6850","INVOICE","7200","PAID","2020-01-06 12:56:02",11772,"2","2020-01-06 12:56:02","2","2020-01-06 12:56:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:02:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1163,"customer_code":"C191163","identity_type":"PERSONAL","identity_id":"Z617971(2)","title":"Mr","lastname":"HO","firstname":"Man Ho","companyname":"","email":"manho383@gmail.com","tel":"97074298","address":"FLAT 3, 8\/F, Yue Fai Court, No.45 Yue Kwong Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-06","renew_room_key":"189,17269","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 2, 2019. Storage deposit $2196 transferred from agreement A14-CT194056 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195386, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"802","room_code":"O44","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5934,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-07-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit $2196 transferred from agreement A14-CT195386 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5934,"final_order_total":5934,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,17269","order_product":[],"pass":true}},"first_order_id":"4056","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> O44 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1163,"NEW","A14-CT206873",1098,989,0,0,"6","6",5934,5934,5934,"2020-01-06 13:10:04","0",null,null,null,"2020-01-06","2020-07-05","6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit $2196 transferred from agreement A14-CT195386 to this agreement.\r\n","2020-01-06","16",0,null,0,"0","2","2020-01-06 13:10:04","2","2020-01-06 13:10:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,17269","C191163","PERSONAL","Mr","jGP6SPxDvmecJxk7lZKF\/A==","Zzv1eRCimQisUlUlw\/fpjg==","","Ly3PZr1n1jAQyEhbbHD1NG91iga2LYXE0gATMhTWnDNNTQJ\/ARSfmejcjq3P4z\/P7o9WNYVGvbEfVa5Ipn4yPQ==","YiYkhEDogUjw4lSPiAwK8A==","8fl49sEqeC44EDUeu5feODh32gxqw1d3AdTg6R3PzaQ=","1fE39w0CxriahoXCUDTOwA==",null,1,"4056"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6873","802","1098.0","1098.00","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-07-05","802"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6873",1163,"SETTLED","A14-I207201","2020-01-06 13:10:04","2020-01-06","2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7201","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5934,0,"7201"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1163,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206851","2020-01-06 13:10:04",5934,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6851","DEPOSIT",null,"PAID","2020-01-06 13:10:04",0,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:10:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6851","INVOICE","7201","PAID","2020-01-06 13:10:04",5934,"2","2020-01-06 13:10:04","2","2020-01-06 13:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":693,"customer_code":"C180693","identity_type":"PERSONAL","identity_id":"D565129(9)","title":"Ms","lastname":"Leung","firstname":"Kwai Fong","companyname":"","email":"jessicakfleung@hotmail.com","tel":"96728663","address":"Flat C, 1\/F, Tower 15, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1737.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-05","renew_room_key":"054,48522","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 3, 2019. Storage deposit transferred from agreement A18-CT194071 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195397, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[{"master_room_discount_id":"471","master_room_id":"104","discount_type":"%","price":"1930.00","disocunted_price":"1737.00","discount":"10.00","monthly_deduct":193,"room_id":"924","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"924","room_code":"U25","retail_price":"1930.0","discounted_price":1737,"location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1737,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10422,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2020-07-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A18-CT195397 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10422,"final_order_total":10422,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,48522","order_product":[],"pass":true}},"first_order_id":"4071","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> U25 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"25","total_discounted_price":"1737.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",693,"NEW","A18-CT206874",1930,1737,0,0,"6","6",10422,10422,10422,"2020-01-06 13:12:10","0",null,null,null,"2020-01-05","2020-07-04","6 months contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A18-CT195397 to this agreement.\r\n","2020-01-05","25",0,null,0,"0","2","2020-01-06 13:12:09","2","2020-01-06 13:12:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,48522","C180693","PERSONAL","Ms","ZDrpquwkwPpy9nQ\/hoLvWg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","lRcsKhHA4vEMmQFs8Z1xVl14ZyKY7zea3KIuIvH2+8tOR0ubeSGQy4fGa4Mn6UEeJiaB1uB\/ralIZd0z2dtCwQ==","Cr1sInxdrsZ\/KrsFTopt5g==","gk9EaWdpCIuN4GRKj6ECgMCv+1T9s97pJxDpLsccXGw=","KQG6Ym4ctwdq+9V9SC\/\/Rg==",null,1,"4071"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","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":["6874","471","104","924","%","10.00",193,"2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6874","924","1930.0",1737,"2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2020-07-04","924"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6874",693,"SETTLED","A18-I207202","2020-01-06 13:12:09","2020-01-05","2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",1,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",2,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",3,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",4,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",5,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7202","RENT","\u9810\u7e73\u79df\u91d1",6,1737,"MO","1",1737,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10422,0,"7202"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[693,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206852","2020-01-06 13:12:09",10422,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6852","DEPOSIT",null,"PAID","2020-01-06 13:12:09",0,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:12:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6852","INVOICE","7202","PAID","2020-01-06 13:12:09",10422,"2","2020-01-06 13:12:09","2","2020-01-06 13:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on Dec 06,2019. Storage deposit transferred from agreement A12-CT196350 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196620, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-08","rent_from":"2020-01-08","rent_to":"2020-02-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A12-CT196620 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A09 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",197,"NEW","A12-CT206875",1098,1038,0,0,"1","1",1038,1038,1038,"2020-01-06 13:14:05","0",null,null,null,"2020-01-08","2020-02-07","1 month contract. Storage rental paid by bank transfer on January 5, 2020. Storage deposit transferred from agreement A12-CT196620 to this agreement.\r\n","2020-01-08","16",0,null,0,"0","2","2020-01-06 13:14:05","2","2020-01-06 13:14:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","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":["6875","9","1098.0","1098.00","2","2020-01-06 13:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2020-02-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:14:05","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":["6875",197,"SETTLED","A12-I207203","2020-01-06 13:14:05","2020-01-08","2","2020-01-06 13:14:05","2","2020-01-06 13:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7203","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-01-06 13:14:05","2","2020-01-06 13:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7203"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:14:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206853","2020-01-06 13:14:05",1038,"2","2020-01-06 13:14:05","2","2020-01-06 13:14:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","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":["6853","DEPOSIT",null,"PAID","2020-01-06 13:14:05",0,"2","2020-01-06 13:14:05","2","2020-01-06 13:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:14:05","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":["6853","INVOICE","7203","PAID","2020-01-06 13:14:05",1038,"2","2020-01-06 13:14:05","2","2020-01-06 13:14:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":755,"customer_code":"C180755","identity_type":"PERSONAL","identity_id":"D674816(4)","title":"Ms","lastname":"Lee","firstname":"Kam Mui","companyname":"","email":null,"tel":"54998807","address":"Flat F, 25\/F, Kam Fat Building, 145 Lee Chi Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 1, 2019. Storage deposit transferred from agreement A14-CT196266 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196604, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"628","room_code":"M39","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-02-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A14-CT196604 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,32469","order_product":[],"pass":true}},"first_order_id":"4693","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> M39 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",755,"NEW","A14-CT206876",598,598,0,0,"1","1",598,598,598,"2020-01-06 13:18:39","0",null,null,null,"2020-01-06","2020-02-05","1 month contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A14-CT196604 to this agreement.\r\n","2020-01-06","12",0,null,0,"0","2","2020-01-06 13:18:39","2","2020-01-06 13:18:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,32469","C180755","PERSONAL","Ms","Bz\/rX4ASIpNafqhGM12E+g==","kiriEIqhcx866RNZiMXdKQ==","","J+qxNwNZZDybuSy0bJS1H3QTc7\/evdtOLUtQc4ivvsWPxn+cqVkhkN\/TohPrTXWpxmb7Nhoov\/XjNXxhd0djX6hEDvZ74IuDZYu9myZVwCs=","uTqJ0Kzbi8lcDPgXUMT73Q==",null,"fFKAofifZnWz0Rnx1R5aUA==",null,1,"4693"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6876","628","598.0","598.00","2","2020-01-06 13:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-02-05","628"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6876",755,"SETTLED","A14-I207204","2020-01-06 13:18:39","2020-01-06","2","2020-01-06 13:18:39","2","2020-01-06 13:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7204","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-06 13:18:39","2","2020-01-06 13:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7204"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206854","2020-01-06 13:18:39",598,"2","2020-01-06 13:18:39","2","2020-01-06 13:18:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6854","DEPOSIT",null,"PAID","2020-01-06 13:18:39",0,"2","2020-01-06 13:18:39","2","2020-01-06 13:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:18:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6854","INVOICE","7204","PAID","2020-01-06 13:18:39",598,"2","2020-01-06 13:18:39","2","2020-01-06 13:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":672,"customer_code":"C170672","identity_type":"PERSONAL","identity_id":"D057260(9)","title":"Ms","lastname":"O'hoy","firstname":"Kit Ying Katherine Mary","companyname":"","email":"katherine.ohoy@gmail.com","tel":"93247800","address":"Room 2507, Hang Lung Centre, 2-20 Paterson St, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"UNPAID","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2455.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-06","renew_room_key":"054,43458","renew_remark":"12 months contract. Storage rental paid by cheque deposit on January 2, 2019. Storage deposit transferred from agreement A18-CT182613 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194062, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"844","room_code":"S03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2455,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":29460,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2455.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2021-02-05","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT194062 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2455,"order_total":31915,"final_order_total":29460,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,43458","order_product":[],"pass":true}},"first_order_id":4062,"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> S03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"36","total_discounted_price":"2455.00","deposit":"0.00","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",672,"NEW","A18-CT206877",2728,2455,0,0,"13","13",29460,31915,29460,"2020-01-06 13:22:39","0",null,null,null,"2020-01-06","2021-02-05","13 months contract. Special offer the 13th month free. Storage rental paid by cheque deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT194062 to this agreement.\r\n","2020-01-06","36",0,null,2455,"2455.00","2","2020-01-06 13:22:38","2","2020-01-06 13:22:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43458","C170672","PERSONAL","Ms","hIv56Obgyz7qNz1bieAZ1y0pvZWdxuxdKSp50V2Hb6c=","ZOPrCFhx82Mtq8DYmdzxOg==","","6f7pEi9wx4oqJbxXF3DuwQEPD3lcC08a8nuk3rtiKxF7HRYAHk5PoUj7jkZKAjBm2mNfQM7RBtDVmx1vltkNmzVe8Xqs3ND\/MrbHikiq2lM=","6i0oXu5R0lOAE5TqgFwjrQ==","Ck6+1lIO0SHa1bS8aisOxvBFl60cBzBPvB2K43leP4E=","FISojAu38difdtSR8ylQvQ==",null,1,4062]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6877","844","2728.0","2728.00","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2021-02-05","844"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6877",672,"SETTLED","A18-I207205","2020-01-06 13:22:38","2020-01-06","2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",3,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",4,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",5,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",6,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",7,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",8,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",9,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",10,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",11,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",12,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7205","RENT","\u9810\u7e73\u79df\u91d1",13,2455,"MO","1",2455,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[29460,0,"7205"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[672,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206855","2020-01-06 13:22:38",29460,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6855","DEPOSIT",null,"PAID","2020-01-06 13:22:38",0,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:22:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6855","INVOICE","7205","PAID","2020-01-06 13:22:38",29460,"2","2020-01-06 13:22:38","2","2020-01-06 13:22:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":883,"customer_code":"C180883","identity_type":"PERSONAL","identity_id":"R967164(0)","title":"Ms","lastname":"Lin","firstname":"Yashuang","companyname":"","email":"ablinynli@126.com","tel":"51715885","address":"Flat B, 9\/F, Tower 8, Marinella, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4175.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-05","renew_room_key":"0005947986","renew_remark":"6 months contract. Storage rental paid by cheque on July 2, 2019. Storage deposit transferred from agreement A05-CT194064 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195366, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"130","order_discount":[],"order_room":[{"room_id":"1022","room_code":"A05-020","retail_price":"1.0","discounted_price":"1.00","location_id":"4"}],"roughly_size":"60","total_retail_price":1,"total_discounted_price":4175,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":50100,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4175.00","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2021-02-04","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash deposit on January 6, 2020. Storage deposit transferred from agreement A05-CT195366 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4175,"order_total":54275,"final_order_total":50100,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005947986","order_product":[],"pass":true}},"first_order_id":"4064","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-020 <\/td>\r\n\t\t\t\t\t 6X10X7 <\/td>\r\n\t\t\t\t\t $1.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":"60","total_discounted_price":"4175.00","deposit":"0.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",883,"NEW","A05-CT206878",1,4175,0,0,"13","13",50100,54275,50100,"2020-01-06 13:25:54","0",null,null,null,"2020-01-05","2021-02-04","13 months contract. Special offer the 13th month free. Storage rental paid by cash deposit on January 6, 2020. Storage deposit transferred from agreement A05-CT195366 to this agreement. \r\n","2020-01-05","60",0,null,4175,"4175.00","2","2020-01-06 13:25:53","2","2020-01-06 13:25:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005947986","C180883","PERSONAL","Ms","e4Y+AG3LnjXjVZ32Dy9nQQ==","s1MZEdj4MvHwsNVbwPTudg==","","R5KRLaKaGDNs1jmCb6YE7pcH6LyMqEYootCCg0mQqaHIaSzMSq7oqg8PgI5jKpUVky0wLHYa1SSjX9tvsQtOjw==","7Jz9rxXPu\/iiZ\/j4QpkQxw==","wAjI4fLDUWpawIr8fDa9M3PYE983TSuodKLGy9VNZ5s=","WSopF3vyzdcpGUIFkROUCQ==",null,1,"4064"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6878","1022","1.0","1.00","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2021-02-04","1022"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6878",883,"SETTLED","A05-I207206","2020-01-06 13:25:53","2020-01-05","2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",3,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",4,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",5,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",6,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",7,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",8,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",9,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",10,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",11,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",12,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7206","RENT","\u9810\u7e73\u79df\u91d1",13,4175,"MO","1",4175,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[50100,0,"7206"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[883,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206856","2020-01-06 13:25:53",50100,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6856","DEPOSIT",null,"PAID","2020-01-06 13:25:53",0,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 13:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6856","INVOICE","7206","PAID","2020-01-06 13:25:53",50100,"2","2020-01-06 13:25:53","2","2020-01-06 13:25:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:22:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"401","master_room_id":"11","room_code":"H11"}],"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> H11 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z412240(3)","title":"Mr","lastname":"Yip","firstname":"Chun Yin, Christopher","companyname":"","email":"ycyt2011@gmail.com","tel":"97310791","address":"Flat A, 11\/F, Block 5, Chi Fu Fa Yuen, Poklulam, HK","pass":true,"customer_id":"116","customer_code":"C160116","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"401","room_code":"H11","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1680,"deposit":3536,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8324,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"252.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-04-05","delivery_service":"0","remark":"3 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on January 6, 2019. Smartcard and padlock provided on January 6, 2019. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":252,"order_total":8576,"final_order_total":8324,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 28869","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1680.00","deposit":"3536.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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` = ?","parameters":["1","1","1","116","NEW","A12-CT206879",1768,1680,3536,0,"3","3",8324,8576,8324,"2020-01-06 14:33:58","0",null,null,null,"2020-01-06","2020-04-05","3 months contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on January 6, 2019. Smartcard and padlock provided on January 6, 2019. ","2020-01-06","24",0,null,252,"252.00","2","2020-01-06 14:33:57","2","2020-01-06 14:33:57","EPS","","","","EPS","","","",null,0,"189, 28869","C160116","PERSONAL","Mr","yBFqv3yedRm2dETwD480TsPV5T10uYontNxIrtMH+RQ=","H9gmHz05\/Te4s1\/V+q8XVg==","","fxfvZGmYkWyEb2\/fmXzVldmSmfr3OShFZUvCpaWMGYKDRsp\/i1TISueLKkEc\/7oK7y7MgPbVf5txYIAa1gDoFQ==","YwB44nyrK\/Fvoj4xrTDqSg==","lqpOAiJW76MOGoDiZdB+W5b5+A4TRBjkBjXXuYGKu4c=","dHU4XMO25fV5vF8UUQ0A0w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["6879","401","1768.0","1768.00","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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-01-06","2020-04-05","401"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 14:33:58","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":["6879","A12-D205239","PAID",3536,0,"2020-04-05","2020-01-06 14:33:57","2020-01-06 14:33:57","2","2020-01-06 14:33:57","2","2020-01-06 14:33:57","116"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["6879","116","SETTLED","A12-I207207","2020-01-06 14:33:57","2020-01-06","2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["7207","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1428,"MO","1",1428,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["7207","RENT","\u9810\u7e73\u79df\u91d1",2,1680,"MO","1",1680,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["7207","RENT","\u9810\u7e73\u79df\u91d1",3,1680,"MO","1",1680,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4788,0,"7207"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 14:33: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":["116","EPS","","","","EPS","","","","PAID","P206857","2020-01-06 14:33:57",8324,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["6857","DEPOSIT","5239","PAID","2020-01-06 14:33:57",3536,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:33: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":["6857","INVOICE","7207","PAID","2020-01-06 14:33:57",4788,"2","2020-01-06 14:33:57","2","2020-01-06 14:33:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1171&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1314","master_room_id":"164","room_code":"C15-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1134,"customer_code":"C181134","identity_type":"PERSONAL","identity_id":"Z017853(6)","title":"Mr","lastname":"Leung","firstname":"Wai Tat","companyname":"","email":"victorleung345@gmail.com","tel":"52255418","address":"Flat 06, 2\/F Yuet Chui Court 9, Yan Tsui St, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"356.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-10","renew_room_key":"0012472672","renew_remark":"1 months contract. Storage rental paid by PayMe on December 11, 2019. Storage deposit transferred from agreement C15-CT196342 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196677, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1452","room_code":"C15-146","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":356,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":356,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2020-02-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PayMe on Jan 05,2020. Storage deposit transferred from agreement C15-CT196677 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"OTHER","paymethod_other2":"PayMe","discount_deduct":0,"order_total":356,"final_order_total":356,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012472672","order_product":[],"pass":true}},"first_order_id":"4805","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-146 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.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":"8.1","total_discounted_price":"356.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","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",1134,"NEW","C15-CT206880",510,356,0,0,"1","1",356,356,356,"2020-01-06 14:44:51","0",null,null,null,"2020-01-10","2020-02-09","1 month contract. Storage rental paid by PayMe on Jan 05,2020. Storage deposit transferred from agreement C15-CT196677 to this agreement.","2020-01-10","8.1",0,null,0,"0","2","2020-01-06 14:44:51","2","2020-01-06 14:44:51","NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe",null,0,"0012472672","C181134","PERSONAL","Mr","S1eQwXaAsUdtzc1Ymck8Jg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","596Kcg0kSfbD85GNFxMa7h8CY7zKszjQ7hj4A6ucjRZeYl+TO11xTTCVesXiaJ\/pTZeIYxCHmr9rgYiIkihiFg==","50+huvkYI7Tn4ZAWxVwcPw==","FRHJOJDYd5XByaT89nynmQawjlXgI0AS4R5zIEqR4E0=","XQVqohimdZ7JoGvCaH2ATQ==",null,1,"4805"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","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":["6880","1452","510.0","510.00","2","2020-01-06 14:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","1452"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 14:44:51","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":["6880",1134,"SETTLED","C15-I207208","2020-01-06 14:44:51","2020-01-10","2","2020-01-06 14:44:51","2","2020-01-06 14:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7208","RENT","\u9810\u7e73\u79df\u91d1",1,356,"MO","1",356,"2","2020-01-06 14:44:51","2","2020-01-06 14:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[356,0,"7208"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 14:44:51","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":[1134,"NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe","PAID","P206858","2020-01-06 14:44:51",356,"2","2020-01-06 14:44:51","2","2020-01-06 14:44:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","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":["6858","DEPOSIT",null,"PAID","2020-01-06 14:44:51",0,"2","2020-01-06 14:44:51","2","2020-01-06 14:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 14:44:51","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":["6858","INVOICE","7208","PAID","2020-01-06 14:44:51",356,"2","2020-01-06 14:44:51","2","2020-01-06 14:44:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 15:59:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=640&filter3=undefined","floor_plan_rent_room":[{"room_id":"401","master_room_id":"11","room_code":"H11"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 03, 2019. Storage deposit transferred from agreement A18-CT196299 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196600, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"989","room_code":"X14","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-01-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit transferred from agreement A18-CT196600 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"4345","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> X14 <\/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":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",663,"NEW","A18-CT206881",1290,1290,0,0,"1","1",1290,1290,1290,"2020-01-06 16:08:09","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit transferred from agreement A18-CT196600 to this agreement.","2020-01-01","16",0,null,0,"0","2","2020-01-06 16:08:08","2","2020-01-06 16:08:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"4345"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","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":["6881","989","1290.0","1290.00","2","2020-01-06 16:08:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","989"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 16:08:09","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":["6881",663,"SETTLED","A18-I207209","2020-01-06 16:08:08","2020-01-01","2","2020-01-06 16:08:08","2","2020-01-06 16:08:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7209","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-01-06 16:08:08","2","2020-01-06 16:08:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7209"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 16:08:09","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":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206859","2020-01-06 16:08:08",1290,"2","2020-01-06 16:08:08","2","2020-01-06 16:08:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","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":["6859","DEPOSIT",null,"PAID","2020-01-06 16:08:08",0,"2","2020-01-06 16:08:08","2","2020-01-06 16:08:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:09","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":["6859","INVOICE","7209","PAID","2020-01-06 16:08:08",1290,"2","2020-01-06 16:08:08","2","2020-01-06 16:08:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:08:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:14:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 16:25:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=640&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"401","master_room_id":"11","room_code":"H11"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1375,"customer_code":"C191375","identity_type":"PERSONAL","identity_id":"Z921640(6)","title":"Mr","lastname":"Cheung","firstname":"Kit Yu","companyname":"","email":null,"tel":"55445761","address":"Flat 206, 2\/F, Pik Luk House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-01","renew_room_key":"076,49779","renew_remark":"1\u500b\u6708\u5408\u7d04. \u79df\u91d1\u57282019\u5e7410\u67083\u65e5\u4ee5\u73fe\u91d1\u7e73\u4ed8.\u820a\u5408\u7d04\u7de8\u865f: A14-CT195778, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0 1 month contract. Storage rental paid by cash on October 3, 2019. Storage deposit $4376 transferred from agreement A14-CT195778 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196056, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"53","order_discount":[{"master_room_discount_id":"463","master_room_id":"53","discount_type":"%","price":"2188.00","disocunted_price":"2078.60","discount":"5.00","monthly_deduct":109.4,"room_id":"461","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"461","room_code":"J43","retail_price":"2188.0","discounted_price":2078.6,"location_id":"2"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":2079,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6237,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-01","rent_from":"2019-11-01","rent_to":"2020-01-31","delivery_service":"0","remark":"3\u500b\u6708\u5408\u7d04. \u79df\u91d1\u57282020\u5e741\u67086\u65e5\u4ee5\u73fe\u91d1\u7e73\u4ed8.\u820a\u5408\u7d04\u7de8\u865f: A14-CT196056, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0\r\n3 months contract. Storage rental paid by cash on January 6, 2020. Storage deposit $4376 transferred from agreement A14-CT195778 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6237,"final_order_total":6237,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,49779","order_product":[],"pass":true}},"first_order_id":"5778","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> J43 <\/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\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":"2079.00","deposit":"0.00","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","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",1375,"NEW","A14-CT206882",2188,2079,0,0,"3","3",6237,6237,6237,"2020-01-06 17:29:05","0",null,null,null,"2019-11-01","2020-01-31","3\u500b\u6708\u5408\u7d04. \u79df\u91d1\u57282020\u5e741\u67086\u65e5\u4ee5\u73fe\u91d1\u7e73\u4ed8.\u820a\u5408\u7d04\u7de8\u865f: A14-CT196056, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0\r\n3 months contract. Storage rental paid by cash on January 6, 2020. Storage deposit $4376 transferred from agreement A14-CT195778 to this agreement.","2019-11-01","30",0,null,0,"0","2","2020-01-06 17:29:04","2","2020-01-06 17:29:04","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,49779","C191375","PERSONAL","Mr","ksGbPh21wXxn8OkaY6lLfw==","vCxOlXQuvOQaoL822H2o\/Q==","","5LxpXhLiPD2WSK4Uthz9ZguOwD3uISNO\/bHbCtYORGGqf+NrT1VVRVXl3hOjxM0EWwptox0+0GANo7EzFCARudS+BCU3VcsM6kJM+VZKL0U=","xymPZ9tGDPharD71TGnWbw==",null,"EP5UJl7gfXqJy9lL5gT2jQ==",null,1,"5778"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","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":["6882","463","53","461","%","5.00",109.4,"2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","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":["6882","461","2188.0",2078.6,"2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-01","2020-01-31","461"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 17:29:05","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":["6882",1375,"SETTLED","A14-I207210","2020-01-06 17:29:04","2019-11-01","2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7210","RENT","\u9810\u7e73\u79df\u91d1",1,2079,"MO","1",2079,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7210","RENT","\u9810\u7e73\u79df\u91d1",2,2079,"MO","1",2079,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7210","RENT","\u9810\u7e73\u79df\u91d1",3,2079,"MO","1",2079,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6237,0,"7210"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 17:29:05","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":[1375,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206860","2020-01-06 17:29:04",6237,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","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":["6860","DEPOSIT",null,"PAID","2020-01-06 17:29:04",0,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:29:05","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":["6860","INVOICE","7210","PAID","2020-01-06 17:29:04",6237,"2","2020-01-06 17:29:04","2","2020-01-06 17:29:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:10","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=1430&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Dec 05, 2019. Storage deposit $1322 transferred from agreement C15-CT196313 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196614, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-01-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jan 06,2020. Storage deposit $1322 transferred from agreement C15-CT196614 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","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-115 <\/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 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","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",1185,"NEW","C15-CT206883",1322,1322,0,0,"1","1",1322,1322,1322,"2020-01-06 17:40:11","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental paid by bank transfer on Jan 06,2020. Storage deposit $1322 transferred from agreement C15-CT196614 to this agreement.","2020-01-01","24",0,null,0,"0","2","2020-01-06 17:40:10","2","2020-01-06 17:40:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","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":["6883","1421","1322.0","1322.00","2","2020-01-06 17:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-06 17:40:11","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":["6883",1185,"SETTLED","C15-I207211","2020-01-06 17:40:10","2020-01-01","2","2020-01-06 17:40:10","2","2020-01-06 17:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7211","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-01-06 17:40:10","2","2020-01-06 17:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"7211"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-06 17:40:11","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":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206861","2020-01-06 17:40:10",1322,"2","2020-01-06 17:40:10","2","2020-01-06 17:40:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","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":["6861","DEPOSIT",null,"PAID","2020-01-06 17:40:10",0,"2","2020-01-06 17:40:10","2","2020-01-06 17:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 17:40:11","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":["6861","INVOICE","7211","PAID","2020-01-06 17:40:10",1322,"2","2020-01-06 17:40:10","2","2020-01-06 17:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 18:46:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-06 18:47:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****