{"created_at":"2020-01-07 11:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&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":392,"customer_code":"C170392","identity_type":"PERSONAL","identity_id":"P988279(4)","title":"Mr","lastname":"Lee","firstname":"Kenneth Pak Lok","companyname":"","email":"kenneth_P_Lee@yahoo.com","tel":"69712837","address":"Flat B,22\/F,Tower 2,Sham Wan Towers 3 Ap Lei Chau Drive, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4412.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-01","renew_room_key":"138,17024","renew_remark":"12 months contract. combine to 4 units. Storage rental $33674 and deposit transferred from agreement A12-CT183594 to this agreement. Remaining storage rental $19270 paid by bank transfer on December 10, 2018. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183904, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"115","room_code":"B63","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"114","room_code":"B62","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"106","room_code":"B54","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"105","room_code":"B53","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"80","total_retail_price":6112,"total_discounted_price":5098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":5098,"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 cheque on January 7, 2020. Storage deposit transferred from agreement A12-CT183904 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5098,"final_order_total":5098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,17024","order_product":[],"pass":true}},"first_order_id":3904,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
B63 <\/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>
B62 <\/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>
B54 <\/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>
B53 <\/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":"80","total_discounted_price":"5098.00","deposit":"0.00","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",392,"NEW","A12-CT206884",6112,5098,0,0,"1","1",5098,5098,5098,"2020-01-07 11:16:49","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental paid by cheque on January 7, 2020. Storage deposit transferred from agreement A12-CT183904 to this agreement. \r\n","2020-01-01","80",0,null,0,"0","2","2020-01-07 11:16:48","2","2020-01-07 11:16:48","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"138,17024","C170392","PERSONAL","Mr","BEeVus+G60XJp0DLlFrw5Q==","kiriEIqhcx866RNZiMXdKQ==","","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=","u2w9koTKJQGsIdFvv8jAeA==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","1A9B3kdXJoFpDPdlSZGM4g==",null,1,3904]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6884","115","1528.0","1528.00","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","115"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6884","114","1528.0","1528.00","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","114"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6884","106","1528.0","1528.00","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","106"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6884","105","1528.0","1528.00","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","105"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6884",392,"SETTLED","A12-I207212","2020-01-07 11:16:48","2020-01-01","2","2020-01-07 11:16:48","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7212","RENT","\u9810\u7e73\u79df\u91d1",1,5098,"MO","1",5098,"2","2020-01-07 11:16:48","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5098,0,"7212"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[392,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206862","2020-01-07 11:16:48",5098,"2","2020-01-07 11:16:48","2","2020-01-07 11:16:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6862","DEPOSIT",null,"PAID","2020-01-07 11:16:48",0,"2","2020-01-07 11:16:48","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:16:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6862","INVOICE","7212","PAID","2020-01-07 11:16:48",5098,"2","2020-01-07 11:16:48","2","2020-01-07 11:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:42:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 11:54:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:19","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":"all=1&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":443,"customer_code":"C170443","identity_type":"PERSONAL","identity_id":"P459858(3)","title":"Ms","lastname":"Kong","firstname":"Shunmin","companyname":"","email":"drowland88@yahoo.com","tel":"96575869","address":"Unit A-C,16\/F,Tak Lee Comm Bldg 113-117 Wan Chan Road","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-18","renew_room_key":"055,47082","renew_remark":"6 months contract. Storage rental paid by cheque on May 22, 2019. Storage deposit transferred from agreement A12-CT183509 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195044, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"10","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"10","room_code":"A10","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-18","rent_from":"2019-11-18","rent_to":"2020-02-17","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on January 7, 2020. Storage deposit transferred from agreement A12-CT195044 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,47082","order_product":[],"pass":true}},"first_order_id":"3509","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> A10 <\/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":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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",443,"NEW","A12-CT206885",1098,989,0,0,"3","3",2967,2967,2967,"2020-01-07 12:12:20","0",null,null,null,"2019-11-18","2020-02-17","3 months contract. Storage rental paid by cheque on January 7, 2020. Storage deposit transferred from agreement A12-CT195044 to this agreement.\r\n","2019-11-18","16",0,null,0,"0","2","2020-01-07 12:12:19","2","2020-01-07 12:12:19","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,47082","C170443","PERSONAL","Ms","qMYMatzodheOtUi0uFAQ1Q==","F5uIWSqx2McFcjiJ4bOqSw==","","tyJOEBWl4+4Zy\/N5r51frmmt546FuT+Ndut5mpuXG2DjXGYJAHLHFnkbGWPpMx9moySN8g3nNTSBiBLrJAfU\/g==","xV0olbURvv5pRBton5ts0A==","naYQ5kjd+Ede6SeZIZWDqEm4FvOwe+uG08I0+TlTDfU=","mr2sAUu0v+3Ol6Qja3hLiw==",null,1,"3509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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":["6885","433","8","10","%","4.97",54.5706,"2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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":["6885","10","1098.0",1043.4,"2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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-18","2020-02-17","10"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 12:12:20","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":["6885",443,"SETTLED","A12-I207213","2020-01-07 12:12:19","2019-11-18","2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7213","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7213","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7213","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7213"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 12:12:20","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":[443,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206863","2020-01-07 12:12:19",2967,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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":["6863","DEPOSIT",null,"PAID","2020-01-07 12:12:19",0,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:12:20","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":["6863","INVOICE","7213","PAID","2020-01-07 12:12:19",2967,"2","2020-01-07 12:12:19","2","2020-01-07 12:12:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:19:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:19:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1310&filter3=undefined&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":650,"customer_code":"C170650","identity_type":"PERSONAL","identity_id":"Z603985(6)","title":"Mr","lastname":"Li","firstname":"Ka Man Carmen ","companyname":"","email":"licarmen120@outlook.com","tel":"60866005","address":"Flat 11D, Block 7, Chi Fu Fa Yuen, Pok Fu Lam ","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"053,30656","renew_remark":"1 month contract. Storage rental paid by PayMe on December 3, 2019. Storage deposit transferred from agreement A18-CT196287 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196582, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"79","order_discount":[],"order_room":[{"room_id":"832","room_code":"R06","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1857,"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 PayMe on January 6, 2020. Storage deposit transferred from agreement A18-CT196582 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"OTHER","paymethod_other2":"PayMe","discount_deduct":0,"order_total":1857,"final_order_total":1857,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,30656","order_product":[],"pass":true}},"first_order_id":"4117","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> R06 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\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":"1857.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",650,"NEW","A18-CT206886",1857,1857,0,0,"1","1",1857,1857,1857,"2020-01-07 12:39:27","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental paid by PayMe on January 6, 2020. Storage deposit transferred from agreement A18-CT196582 to this agreement.\r\n","2020-01-01","24",0,null,0,"0","2","2020-01-07 12:39:27","2","2020-01-07 12:39:27","NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe",null,0,"053,30656","C170650","PERSONAL","Mr","mqlU7HwzD2KcOzmXS2v+sA==","7KCehmxbvwRMb+U8lHGoVA==","","N1UMvJRIlBDaipk\/6myaA2yvOWbLAlcHBaBFvhn3ndwzx9gjypD9HQoLkbHY903D","j9uSn7lfecYNB\/L0v79ywg==","D\/P9IXVUbziIb70tKXH1egvc8mQBlMIAFVy1O5krGx4=","qJTrGPQQj78pb5tx0e8DHg==",null,1,"4117"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6886","832","1857.0","1857.00","2","2020-01-07 12:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","832"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6886",650,"SETTLED","A18-I207214","2020-01-07 12:39:27","2020-01-01","2","2020-01-07 12:39:27","2","2020-01-07 12:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7214","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-01-07 12:39:27","2","2020-01-07 12:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"7214"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[650,"NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe","PAID","P206864","2020-01-07 12:39:27",1857,"2","2020-01-07 12:39:27","2","2020-01-07 12:39:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6864","DEPOSIT",null,"PAID","2020-01-07 12:39:27",0,"2","2020-01-07 12:39:27","2","2020-01-07 12:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 12:39:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6864","INVOICE","7214","PAID","2020-01-07 12:39:27",1857,"2","2020-01-07 12:39:27","2","2020-01-07 12:39:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:05:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1310&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":1237,"customer_code":"C191237","identity_type":"PERSONAL","identity_id":"P559566(9)","title":"Ms","lastname":"Leung","firstname":"Fung Sin","companyname":"","email":"ann6811608@gmail.com","tel":"97780111","address":"DD 129 Lot Fu Cho Deep Bay Road, Lau Fo Shan, Yuen Long, New Territories","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":"2019-12-30","renew_room_key":"076,34910","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 28, 2019. Deposit $1638 transferred from agreement A14-CT196249 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196529, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"690","room_code":"N07","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":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-01-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by Cash on January 7, 2020. Deposit $1638 transferred from agreement A14-CT196529 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,34910","order_product":[],"pass":true}},"first_order_id":"6047","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> N07 <\/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-07 13:30:14","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",1237,"NEW","A14-CT206887",598,598,0,0,"1","1",598,598,598,"2020-01-07 13:30:14","0",null,null,null,"2019-12-30","2020-01-29","1 month contract. Storage rental paid by Cash on January 7, 2020. Deposit $1638 transferred from agreement A14-CT196529 to this agreement. \r\n","2019-12-30","12",0,null,0,"0","2","2020-01-07 13:30:13","2","2020-01-07 13:30:13","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,34910","C191237","PERSONAL","Ms","Mp1uQYBOKjCa3MjeNTcq3A==","xEf2h2aoyRQ71ZVgBH+9WQ==","","iW47FVp7s8TaEAMIorm0fGFj9skS6ydpaz9yZj+INMKJBmGfo988uGIjotbmyMfP2KQgH8yFjAojrqrHAGBn6MgcYUYvWbTLv+DzFp74hsI=","PTohJuR+UgjG7jslfxI4rw==","cH16fP4YQ5zYD3D2dgGxK3fdRCDVqpQpUvgIFEG73lQ=","8oqTJK9vVVGqI+5lGb64IA==",null,1,"6047"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","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":["6887","690","598.0","598.00","2","2020-01-07 13:30:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","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-30","2020-01-29","690"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 13:30:14","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":["6887",1237,"SETTLED","A14-I207215","2020-01-07 13:30:13","2019-12-30","2","2020-01-07 13:30:13","2","2020-01-07 13:30:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7215","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-07 13:30:13","2","2020-01-07 13:30:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7215"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 13:30:14","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":[1237,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206865","2020-01-07 13:30:13",598,"2","2020-01-07 13:30:13","2","2020-01-07 13:30:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","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":["6865","DEPOSIT",null,"PAID","2020-01-07 13:30:13",0,"2","2020-01-07 13:30:13","2","2020-01-07 13:30:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 13:30:14","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":["6865","INVOICE","7215","PAID","2020-01-07 13:30:13",598,"2","2020-01-07 13:30:13","2","2020-01-07 13:30:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 14:10:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 14:35:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1437&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1167,"customer_code":"C191167","identity_type":"PERSONAL","identity_id":"G808973(5)","title":"Mr","lastname":"NG","firstname":"Kwok Cheung Eric","companyname":"","email":"erickcng@gmail.com","tel":"94628251","address":"13B Yee Hoi Mansion, 33 Tai Hong Street, Lei King Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"702.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-08","renew_room_key":"0005832998","renew_remark":"12 month contract. Storage rental and deposit paid by Cheque on 4 JAN 2019. Smart card provided on 4 JAN 2019.Free of smart card\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194086, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $935.0","renew_master_room_id":"170","order_discount":[{"master_room_discount_id":"440","master_room_id":"170","discount_type":"%","price":"1108.00","disocunted_price":"832.00","discount":"24.91","monthly_deduct":276.0028,"room_id":"1463","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1463","room_code":"C15-157","retail_price":"1108.0","discounted_price":832,"location_id":"6"}],"roughly_size":"16","total_retail_price":1108,"total_discounted_price":998,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11976,"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":"2021-01-07","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Jan 07,2020. Deposit $935 transferred from agreement C15-CT194086 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11976,"final_order_total":11976,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832998","order_product":[],"pass":true}},"first_order_id":4086,"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-157 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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":"16","total_discounted_price":"998.00","deposit":"0","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1167,"NEW","C15-CT206888",1108,998,0,0,"12","12",11976,11976,11976,"2020-01-07 15:20:06","0",null,null,null,"2020-01-08","2021-01-07","12 months contract. Storage rental paid by bank transfer on Jan 07,2020. Deposit $935 transferred from agreement C15-CT194086 to this agreement.","2020-01-08","16",0,null,0,"0","2","2020-01-07 15:20:06","2","2020-01-07 15:20:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832998","C191167","PERSONAL","Mr","rWnV50j8lnMapacNt8i++0\/6UmihC3bW\/rI19xWF8Lg=","yXKLXTtbNpECaRVTZxF\/Rw==","","zn+21N0Ot\/Nro8OfhNxx9D8sYDFa0I4WQN+0Ha71QNQOk3rslBrpD\/4wuSeCxajmvZ0GsR4YEIaxHRu3EgwPBXo\/bysMUTBJt4TTKXqGy3M=","qzo6UzeOzbnMGUNsuJ07CA==","HzHhgJIIJh+bLf\/SIamngPiSCmyYWiXsVfKnNQcZ0ZE=","93BcQuzY1WcISoeMPFfylw==",null,1,4086]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6888","440","170","1463","%","24.91",276.0028,"2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6888","1463","1108.0",832,"2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2021-01-07","1463"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6888",1167,"SETTLED","C15-I207216","2020-01-07 15:20:06","2020-01-08","2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11976,0,"7216"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1167,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206866","2020-01-07 15:20:06",11976,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6866","DEPOSIT",null,"PAID","2020-01-07 15:20:06",0,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:20:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6866","INVOICE","7216","PAID","2020-01-07 15:20:06",11976,"2","2020-01-07 15:20:06","2","2020-01-07 15:20:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 15:53:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:36:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=640&filter3=undefined&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":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","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-04","renew_room_key":"076,48044","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit $4376 transferred from agreement A12-CT195874 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196467, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-04","rent_from":"2019-11-04","rent_to":"2019-12-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit $4376 transferred from agreement A12-CT196467 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","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> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/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> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"2188.0","deposit":"0","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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","1","1",1355,"NEW","A12-CT206889",2276,2188,0,0,"1","1",2188,2188,2188,"2020-01-07 16:46:11","0",null,null,null,"2019-11-04","2019-12-03","1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit $4376 transferred from agreement A12-CT196467 to this agreement.\r\n","2019-11-04","30",0,null,0,"0","2","2020-01-07 16:46:11","2","2020-01-07 16:46:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["6889","297","1138.0","946.00","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["2019-11-04","2019-12-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 16:46: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":["6889","308","1138.0","946.00","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["2019-11-04","2019-12-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 16:46: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":["6889",1355,"SETTLED","A12-I207217","2020-01-07 16:46:11","2019-11-04","2","2020-01-07 16:46:11","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["7217","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-01-07 16:46:11","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"7217"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 16:46: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":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206867","2020-01-07 16:46:11",2188,"2","2020-01-07 16:46:11","2","2020-01-07 16:46:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["6867","DEPOSIT",null,"PAID","2020-01-07 16:46:11",0,"2","2020-01-07 16:46:11","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 16:46: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":["6867","INVOICE","7217","PAID","2020-01-07 16:46:11",2188,"2","2020-01-07 16:46:11","2","2020-01-07 16:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:00:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, 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":"2019-12-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 12, 2019. Storage deposit transferred from agreement A05-CT196309 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196382, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","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":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-01-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196382 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","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-085 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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",1137,"NEW","A05-CT206890",598,598,0,0,"1","1",598,598,598,"2020-01-07 17:27:19","0",null,null,null,"2019-12-08","2020-01-07","1 month contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit transferred from agreement A05-CT196382 to this agreement.","2019-12-08","8",0,null,0,"0","2","2020-01-07 17:27:19","2","2020-01-07 17:27:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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":["6890","1087","598.0","598.00","2","2020-01-07 17:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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-08","2020-01-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 17:27:19","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":["6890",1137,"SETTLED","A05-I207218","2020-01-07 17:27:19","2019-12-08","2","2020-01-07 17:27:19","2","2020-01-07 17:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7218","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-07 17:27:19","2","2020-01-07 17:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7218"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 17:27:19","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":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206868","2020-01-07 17:27:19",598,"2","2020-01-07 17:27:19","2","2020-01-07 17:27:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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":["6868","DEPOSIT",null,"PAID","2020-01-07 17:27:19",0,"2","2020-01-07 17:27:19","2","2020-01-07 17:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:27:19","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":["6868","INVOICE","7218","PAID","2020-01-07 17:27:19",598,"2","2020-01-07 17:27:19","2","2020-01-07 17:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:21","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":610,"customer_code":"C170610","identity_type":"PERSONAL","identity_id":"Z082137(4)","title":"Mr","lastname":"Yuen","firstname":"Chi Wai","companyname":"","email":"waijeff@yahoo.com","tel":"91775726","address":"Room 2010, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-16","renew_room_key":"055,37967","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 12, 2019. Storage deposit transferred from agreement A14-CT183936 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195474, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"642","room_code":"M53","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1396,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-02-15","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT195474 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1396,"final_order_total":1396,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,37967","order_product":[],"pass":true}},"first_order_id":"3936","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> M53 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"698.00","deposit":"0.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","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",610,"NEW","A14-CT206891",775,698,0,0,"2","2",1396,1396,1396,"2020-01-07 17:44:22","0",null,null,null,"2019-12-16","2020-02-15","2 months contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT195474 to this agreement.","2019-12-16","9",0,null,0,"0","2","2020-01-07 17:44:21","2","2020-01-07 17:44:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,37967","C170610","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","DtbrOSvE4C7BOu5x4dBFtg==","","7OBn1YtfKbtu\/m30fJWXHKa2ex+ax1hlgO7w1bfVyVziN7HN621Vte0mJS4BimBLi29JbHIlOu0YL\/eGNB5eJg==","t3Y91fzQTOQ0zfQ1Vf7lYw==","ZS42Yo\/u\/2uwsXWxVcCwKvxJcoRgo91JieW4VtkBUqY=","g7Of79kzCCBYM1LLpZVVHA==",null,1,"3936"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","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":["6891","642","775.0","775.00","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","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-16","2020-02-15","642"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 17:44:22","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":["6891",610,"SETTLED","A14-I207219","2020-01-07 17:44:21","2019-12-16","2","2020-01-07 17:44:21","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7219","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-01-07 17:44:21","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7219","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-01-07 17:44:21","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1396,0,"7219"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 17:44:22","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":[610,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206869","2020-01-07 17:44:21",1396,"2","2020-01-07 17:44:21","2","2020-01-07 17:44:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","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":["6869","DEPOSIT",null,"PAID","2020-01-07 17:44:21",0,"2","2020-01-07 17:44:21","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:44:22","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":["6869","INVOICE","7219","PAID","2020-01-07 17:44:21",1396,"2","2020-01-07 17:44:21","2","2020-01-07 17:44:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:46:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:47:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:47:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:51:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 07, 2019. Storage deposit transferred from agreement A14-CT196324 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196627, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2020-02-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT196627 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","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> N39 <\/td>\r\n\t\t\t\t\t 3X6X8 <\/td>\r\n\t\t\t\t\t $1318.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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",445,"NEW","A14-CT206892",1318,1198,0,0,"1","1",1198,1198,1198,"2020-01-07 17:57:26","0",null,null,null,"2020-01-10","2020-02-09","1 month contract. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A14-CT196627 to this agreement.","2020-01-10","18",0,null,0,"0","2","2020-01-07 17:57:25","2","2020-01-07 17:57:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6892","722","1318.0","1318.00","2","2020-01-07 17:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6892",445,"SETTLED","A14-I207220","2020-01-07 17:57:25","2020-01-10","2","2020-01-07 17:57:25","2","2020-01-07 17:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7220","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-01-07 17:57:25","2","2020-01-07 17:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"7220"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206870","2020-01-07 17:57:25",1198,"2","2020-01-07 17:57:25","2","2020-01-07 17:57:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6870","DEPOSIT",null,"PAID","2020-01-07 17:57:25",0,"2","2020-01-07 17:57:25","2","2020-01-07 17:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:57:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6870","INVOICE","7220","PAID","2020-01-07 17:57:25",1198,"2","2020-01-07 17:57:25","2","2020-01-07 17:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1190&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":691,"customer_code":"C180691","identity_type":"PERSONAL","identity_id":"K178542(7)","title":"Mr","lastname":"Wan","firstname":"Shing","companyname":"","email":"wilson58949@yahoo.com.hk","tel":"61788116","address":"\u9999\u6e2f\u4ed4\u6d77\u6021\u534a\u5cf6\u6d77\u6689\u95a32\u5ea72\u6a13C\u5ba4","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-10","renew_room_key":"133,47571,054,57487","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 8, 2019. Storage deposit transferred from agreement A18-CT194054 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195429, \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":"925","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"925","room_code":"U26","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.00","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2020-07-09","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit transferred from agreement A18-CT195429 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":"133,47571,054,57487","order_product":[],"pass":true}},"first_order_id":"4054","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> U26 <\/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.00","deposit":"0.00","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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",691,"NEW","A18-CT206893",1930,1737,0,0,"6","6",10422,10422,10422,"2020-01-07 17:59:09","0",null,null,null,"2020-01-10","2020-07-09","6 months contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit transferred from agreement A18-CT195429 to this agreement.\r\n","2020-01-10","25",0,null,0,"0.00","2","2020-01-07 17:59:08","2","2020-01-07 17:59:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,47571,054,57487","C180691","PERSONAL","Mr","YFp5NrMuSlJMMnwgtzuXSA==","z17wsQG+fTJRBQLSLM755Q==","","gR+pZapd8T1sdKqboAHmFjMQNm3EpKDqFg40ljtC6HyS5SpEdP\/D6cnkGNvqgOSN","GP9KPM\/53HclbUoa4afvBA==","0Gq4hTEUZVvFXM5xN+exCwHcv4LbMS91kujj4kCVXwY=","ML+D491QKBwA\/I9KMO9K+w==",null,1,"4054"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59:09","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":["6893","471","104","925","%","10.00",193,"2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["6893","925","1930.0",1737,"2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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-10","2020-07-09","925"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 17:59: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":["6893",691,"SETTLED","A18-I207221","2020-01-07 17:59:08","2020-01-10","2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",1,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",2,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",3,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",4,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",5,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["7221","RENT","\u9810\u7e73\u79df\u91d1",6,1737,"MO","1",1737,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10422,0,"7221"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 17:59: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":[691,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206871","2020-01-07 17:59:08",10422,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["6871","DEPOSIT",null,"PAID","2020-01-07 17:59:08",0,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 17:59: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":["6871","INVOICE","7221","PAID","2020-01-07 17:59:08",10422,"2","2020-01-07 17:59:08","2","2020-01-07 17:59:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1190&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":790,"customer_code":"C180790","identity_type":"BUSINESS","identity_id":"65842037-000-03-18-6","title":"Ms","lastname":"Liu","firstname":"Kate","companyname":"Festive Victory Limited","email":"sales@cosmedejardin.com","tel":"56204755","address":"4\/F, Cheung Hing Industrial Building, 12p Smithfield Rd, Kennedy Town, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"2","renew_warehousing_date":"2019-11-17","renew_room_key":"054,60455,056,03070","renew_remark":"3 months contract. Storage rental paid by cheque deposit on November 15, 2019. Storage deposit transferred from agreement A14-CT195372 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196399, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"564","room_code":"L42","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1228,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-17","rent_from":"2019-11-17","rent_to":"2020-01-16","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on January 06, 2020. Storage deposit transferred from agreement A14-CT196399 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2456,"final_order_total":2456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60455,056,03070","order_product":[],"pass":true}},"first_order_id":"4307","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> L42 <\/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":"1228.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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",790,"NEW","A14-CT206894",1098,1228,0,0,"2","2",2456,2456,2456,"2020-01-07 18:04:39","0",null,null,null,"2019-11-17","2020-01-16","2 months contract. Storage rental paid by bank transfer on January 06, 2020. Storage deposit transferred from agreement A14-CT196399 to this agreement.\r\n","2019-11-17","16",0,null,0,"0","2","2020-01-07 18:04:39","2","2020-01-07 18:04:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60455,056,03070","C180790","BUSINESS","Ms","eYwEbK6d3n\/OjgVF1RHpPA==","B4ox+DY3LBt2sD1CdZabMw==","Festive Victory Limited","ahr6cynsygG1x7GQk+5r8qu3uiHn2G553gWmTpm1V\/Newq8nfGEfSW4GkfbTB3iRpfwsgJhmYcfj64JotBYElRYoVJs8OOSFCJvBLjVthulIQpGS93a4B5Uaj6mbiUlp","NpWrlO1NXWBgwpWzy\/K\/7g==","S9KDyhPN0EA3tMP\/TMZUoW+OgJcS3qtkcmhpThvz6C4=",null,"eNEKSYl4rvZAEOcbcVhZgX9Wz7KDT4qUt9vS431b+58=",1,"4307"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["6894","564","1098.0","1098.00","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["2019-11-17","2020-01-16","564"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 18:04: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":["6894",790,"SETTLED","A14-I207222","2020-01-07 18:04:39","2019-11-17","2","2020-01-07 18:04:39","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["7222","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-01-07 18:04:39","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["7222","RENT","\u9810\u7e73\u79df\u91d1",2,1228,"MO","1",1228,"2","2020-01-07 18:04:39","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2456,0,"7222"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 18:04: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":[790,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206872","2020-01-07 18:04:39",2456,"2","2020-01-07 18:04:39","2","2020-01-07 18:04:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["6872","DEPOSIT",null,"PAID","2020-01-07 18:04:39",0,"2","2020-01-07 18:04:39","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:04: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":["6872","INVOICE","7222","PAID","2020-01-07 18:04:39",2456,"2","2020-01-07 18:04:39","2","2020-01-07 18:04:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":715,"customer_code":"C180715","identity_type":"PERSONAL","identity_id":"R917457(4)","title":"Ms","lastname":"Sam Ang","firstname":"Kanika","companyname":"","email":"kanikatandijono@gmail.com","tel":"91775576","address":"Unit 3, The Peak, 51 Barker Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2599.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-15","renew_room_key":"134,30287","renew_remark":"12 months contract. Storage rental paid by cheque on January 8, 2019. Storage deposot transferred from agreement A12-CT182661 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194122, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"97","room_code":"B45","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"96","room_code":"B44","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2599,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":31188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2599.00","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2021-02-14","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A12-CT194122 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2599,"order_total":33787,"final_order_total":31188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"134,30287","order_product":[],"pass":true}},"first_order_id":4122,"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> B45 <\/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> B44 <\/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":"40","total_discounted_price":"2599.00","deposit":"0.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","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",715,"NEW","A12-CT206895",3056,2599,0,0,"13","13",31188,33787,31188,"2020-01-07 18:05:32","0",null,null,null,"2020-01-15","2021-02-14","13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Jan 07,2020. Storage deposit transferred from agreement A12-CT194122 to this agreement.","2020-01-15","40",0,null,2599,"2599.00","2","2020-01-07 18:05:31","2","2020-01-07 18:05:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,30287","C180715","PERSONAL","Ms","6Aly4WKRNjT4Uva9gImZOw==","TnMyeuQxYB65L9ZOxt2Tcg==","","s7kYishEsfZw1aAmKH4wrPmxMsVI4gah\/EsjbYpUvXtqGR05oYzJFTf5LqHmjfBH","3K5Y17oONDK0UgD\/Ec5oDw==","bArWut0vE2AalBPVjzVPQBZ0zHe6SgPAkhj8hcE+r7I=","jzcz6GSPvgYTwPVCM9PjlQ==",null,1,4122]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","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":["6895","97","1528.0","1528.00","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2021-02-14","97"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 18:05:32","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":["6895","96","1528.0","1528.00","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2021-02-14","96"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 18:05:32","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":["6895",715,"SETTLED","A12-I207223","2020-01-07 18:05:31","2020-01-15","2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",3,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",4,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",5,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",6,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",7,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",8,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",9,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",10,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",11,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",12,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7223","RENT","\u9810\u7e73\u79df\u91d1",13,2599,"MO","1",2599,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[31188,0,"7223"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 18:05:32","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":[715,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206873","2020-01-07 18:05:31",31188,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","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":["6873","DEPOSIT",null,"PAID","2020-01-07 18:05:31",0,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:05:32","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":["6873","INVOICE","7223","PAID","2020-01-07 18:05:31",31188,"2","2020-01-07 18:05:31","2","2020-01-07 18:05:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:30:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:33:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=89&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":815,"customer_code":"C180815","identity_type":"PERSONAL","identity_id":"V028301(0)","title":"Mr","lastname":"Wong","firstname":"Hon","companyname":"","email":"alfredwh@gmail.com","tel":"64106266","address":"Flat E, 31\/F, 48 Lyttelton Road, Mid Levels, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-07","renew_room_key":"055,47785","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 11, 2019. Storage deposit transferred from agreement A12-CT184023 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195444, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"223","room_code":"D27","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":934,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11208,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"934.00","warehousing_date":"2020-01-07","rent_from":"2020-01-07","rent_to":"2021-02-06","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Jan 06,2020. Storage deposit transferred from agreement A12-CT195444 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":934,"order_total":12142,"final_order_total":11208,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,47785","order_product":[],"pass":true}},"first_order_id":"4023","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> D27 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"934.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",815,"NEW","A12-CT206896",998,934,0,0,"13","13",11208,12142,11208,"2020-01-07 18:39:37","0",null,null,null,"2020-01-07","2021-02-06","13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Jan 06,2020. Storage deposit transferred from agreement A12-CT195444 to this agreement.","2020-01-07","12",0,null,934,"934.00","2","2020-01-07 18:39:37","2","2020-01-07 18:39:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,47785","C180815","PERSONAL","Mr","EoaUEoejMbsPJ+HqYaK40Q==","hULSwM2MvFtpeV9\/z+er8Q==","","l1wojcg+b+DT81bvAAiz+1kNBwOGvtIf2Apq\/pQUdQ3u1FJHekZ0VpRLmNxa+jCTpuTCFWbrU0oYsV43ZB7tdQ==","PcX4K4vL6InOwKCHLRFGnA==","SRnPzvgHbeGG+0s\/cdcptzzvfyjQQOdv4Bg18aQ0XrM=","99Kwrf\/\/QL2BxUxoQTcakg==",null,1,"4023"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6896","223","998.0","998.00","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-07","2021-02-06","223"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6896",815,"SETTLED","A12-I207224","2020-01-07 18:39:37","2020-01-07","2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",3,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",4,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",5,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",6,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",7,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",8,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",9,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",10,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",11,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",12,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7224","RENT","\u9810\u7e73\u79df\u91d1",13,934,"MO","1",934,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11208,0,"7224"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[815,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206874","2020-01-07 18:39:37",11208,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6874","DEPOSIT",null,"PAID","2020-01-07 18:39:37",0,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 18:39:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6874","INVOICE","7224","PAID","2020-01-07 18:39:37",11208,"2","2020-01-07 18:39:37","2","2020-01-07 18:39:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-07 19:11:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****