{"created_at":"2020-06-08 10:23:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 10:58:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 11:36:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 11:41:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 11:56:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 11:57:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 11:58:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:01","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":488,"customer_code":"C170488","identity_type":"PERSONAL","identity_id":"D517675(2)","title":"Ms","lastname":"Lau","firstname":"Wing Yi","companyname":"","email":"jinnyslau@gmail.com","tel":"91921743","address":"Block 22,11\/F,Flat B,South Horizons,Apleichau,H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4074.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-13","renew_room_key":"054,13342,136,62583,054,57704","renew_remark":"6 months contract. Storage rental $24282 paid by bank transfer on December 10, 2019. Remaining balance $162 will be paid by next contract or deducted from deposit. Storage Deposit transferred from A14-CT195185 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196670, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"783","room_code":"P17","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"782","room_code":"P16","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"781","room_code":"P15","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5304,"total_discounted_price":4074,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":24444,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-12-12","delivery_service":"0","remark":"6 months contract. Storage rental $24444 paid by bank transfer on June 8, 2020. Remaining balance $162 from last contract will be paid by next contract or deducted from deposit. Storage Deposit transferred from A14-CT196670 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24444,"final_order_total":24444,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,13342,136,62583,054,57704","order_product":[],"pass":true}},"first_order_id":"3861","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

\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>
P17 <\/td>\r\n\t\t\t\t\t	4X6X8 <\/td>\r\n\t\t\t\t\t	$1768.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
P16 <\/td>\r\n\t\t\t\t\t	4X6X8 <\/td>\r\n\t\t\t\t\t	$1768.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
P15 <\/td>\r\n\t\t\t\t\t	4X6X8 <\/td>\r\n\t\t\t\t\t	$1768.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"72","total_discounted_price":"4074.0","deposit":"0","total_retail_price":"5304.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",488,"NEW","A14-CT208071",5304,4074,0,0,"6","6",24444,24444,24444,"2020-06-08 12:02:02","0",null,null,null,"2020-06-13","2020-12-12","6 months contract. Storage rental $24444 paid by bank transfer on June 8, 2020. Remaining balance $162 from last contract will be paid by next contract or deducted from deposit. Storage Deposit transferred from A14-CT196670 to this agreement. \r\n","2020-06-13","72",0,null,0,"0","2","2020-06-08 12:02:01","2","2020-06-08 12:02:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,13342,136,62583,054,57704","C170488","PERSONAL","Ms","opzZOgkRjypyoX+pYMFoUg==","oe4emdjBwqJ3qUpOcI17hw==","","5AFD0BgDnfntmAGfFM1WzcfF4M\/IwcroqKsAfGpekz6KNB76xa4J7oefAQXqxPKi5pZz+ZEEGZlpVwQlcLUSjg==","tHfCDsB+dYIdqt7OpQA6PA==","EOIulWnRvAl3RsbWX0zWUolYv+dzseEMH0pWXTJtr+I=","o\/WxdQRLzRO4zD5PM+qtjw==",null,1,"3861"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8071","783","1768.0","1768.00","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-12-12","783"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8071","782","1768.0","1768.00","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-12-12","782"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8071","781","1768.0","1768.00","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-12-12","781"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8071",488,"SETTLED","A14-I208400","2020-06-08 12:02:01","2020-06-13","2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",1,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",2,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",3,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",4,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",5,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8400","RENT","\u9810\u7e73\u79df\u91d1",6,4074,"MO","1",4074,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24444,0,"8400"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[488,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208043","2020-06-08 12:02:01",24444,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","DEPOSIT",null,"PAID","2020-06-08 12:02:01",0,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","INVOICE","8400","PAID","2020-06-08 12:02:01",24444,"2","2020-06-08 12:02:01","2","2020-06-08 12:02:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:05:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:05:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 19, 2020. Storage deposit transferred from agreement A12-CT207595 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207681, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-03","rent_from":"2020-05-03","rent_to":"2020-06-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207681 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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",574,"NEW","A12-CT208072",1098,1038,0,0,"1","1",1038,1038,1038,"2020-06-08 12:14:32","0",null,null,null,"2020-05-03","2020-06-02","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207681 to this agreement.\r\n","2020-05-03","16",0,null,0,"0","2","2020-06-08 12:14:31","2","2020-06-08 12:14:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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":["8072","144","1098.0","1098.00","2","2020-06-08 12:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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-05-03","2020-06-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:14: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":["8072",574,"SETTLED","A12-I208401","2020-06-08 12:14:31","2020-05-03","2","2020-06-08 12:14:31","2","2020-06-08 12:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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":["8401","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-06-08 12:14:31","2","2020-06-08 12:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8401"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 12:14: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":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208044","2020-06-08 12:14:31",1038,"2","2020-06-08 12:14:31","2","2020-06-08 12:14:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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":["8044","DEPOSIT",null,"PAID","2020-06-08 12:14:31",0,"2","2020-06-08 12:14:31","2","2020-06-08 12:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:14: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":["8044","INVOICE","8401","PAID","2020-06-08 12:14:31",1038,"2","2020-06-08 12:14:31","2","2020-06-08 12:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 07, 2020. Storage deposit transferred from agreement A12-CT207573 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207800, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2020-07-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 07, 2020. Storage deposit transferred from agreement A12-CT207800 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A09 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",197,"NEW","A12-CT208073",1098,1038,0,0,"1","1",1038,1038,1038,"2020-06-08 12:17:34","0",null,null,null,"2020-06-08","2020-07-07","1 month contract. Storage rental paid by bank transfer on June 07, 2020. Storage deposit transferred from agreement A12-CT207800 to this agreement.\r\n","2020-06-08","16",0,null,0,"0","2","2020-06-08 12:17:33","2","2020-06-08 12:17:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8073","9","1098.0","1098.00","2","2020-06-08 12:17:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-08","2020-07-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8073",197,"SETTLED","A12-I208402","2020-06-08 12:17:33","2020-06-08","2","2020-06-08 12:17:33","2","2020-06-08 12:17:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8402","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-06-08 12:17:33","2","2020-06-08 12:17:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8402"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208045","2020-06-08 12:17:33",1038,"2","2020-06-08 12:17:33","2","2020-06-08 12:17:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8045","DEPOSIT",null,"PAID","2020-06-08 12:17:33",0,"2","2020-06-08 12:17:33","2","2020-06-08 12:17:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:17:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8045","INVOICE","8402","PAID","2020-06-08 12:17:33",1038,"2","2020-06-08 12:17:33","2","2020-06-08 12:17:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":570,"customer_code":"C170570","identity_type":"PERSONAL","identity_id":"K817823(2)","title":"Ms","lastname":"Yuen","firstname":"Sze Wan Cewan","companyname":"","email":"cewanyuen@yahoo.com.hk","tel":"93190159","address":"Flat E, 8\/F, Blk 8, Chi Fu Fa Yuen, Pok Fu Lam, Hong kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"137,17359","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 3, 2020. Storage deposit transferred from agreement A12-CT207304 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207826, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"235","room_code":"D39","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1198,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2396,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 8 and June 7, 2020. Storage deposit transferred from agreement A12-CT207826 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2396,"final_order_total":2396,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,17359","order_product":[],"pass":true}},"first_order_id":"3800","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> D39 <\/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":"1198.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",570,"NEW","A12-CT208074",998,1198,0,0,"2","2",2396,2396,2396,"2020-06-08 12:21:51","0",null,null,null,"2020-05-01","2020-06-30","1 month contract. Storage rental paid by bank transfer on May 8 and June 7, 2020. Storage deposit transferred from agreement A12-CT207826 to this agreement.\r\n","2020-05-01","12",0,null,0,"0","2","2020-06-08 12:21:51","2","2020-06-08 12:21:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,17359","C170570","PERSONAL","Ms","cOVHZvoCSVf6Uh6Fd\/Oh2w==","DtbrOSvE4C7BOu5x4dBFtg==","","Av+ADiyvjVRBgUo03h3p6hpp6mcXgDaDJDvSxXwfQQosUJ1or1G3FIymGt9ddzamhEKDZyddjvFbjz9Eecftvg==","1l5cJvjJNKc2QtotYjeiiQ==","Lg+q8UB1y8C7eQ5vqzRcDiz\/WuEjcTUgxi3gM++AjHw=","CDRdPp1CIDhlh0eK\/Rafuw==",null,1,"3800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8074","235","998.0","998.00","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-06-30","235"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8074",570,"SETTLED","A12-I208403","2020-06-08 12:21:51","2020-05-01","2","2020-06-08 12:21:51","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8403","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-06-08 12:21:51","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8403","RENT","\u9810\u7e73\u79df\u91d1",2,1198,"MO","1",1198,"2","2020-06-08 12:21:51","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2396,0,"8403"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[570,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208046","2020-06-08 12:21:51",2396,"2","2020-06-08 12:21:51","2","2020-06-08 12:21:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","DEPOSIT",null,"PAID","2020-06-08 12:21:51",0,"2","2020-06-08 12:21:51","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:21:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","INVOICE","8403","PAID","2020-06-08 12:21:51",2396,"2","2020-06-08 12:21:51","2","2020-06-08 12:21:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:27:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 12:30:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 13:56:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 15:01:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 15:59:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:08:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:15:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1548","master_room_id":"194","room_code":"A16-057"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-057 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K144531(6)","title":"Mr","lastname":"HO","firstname":"Chung Fai","companyname":"","email":"ianchungfai@yahoo.com.hk","tel":"97870304","address":"Flat F, 15\/F, Comfort Centre, 108 Old Main Street, Aberdeen, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1548","room_code":"A16-057","retail_price":"1006.0","discounted_price":"1006.00","location_id":"7"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":906,"deposit":2012,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11675,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2115.00","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2021-07-13","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by credit card on June 8, 2020. Smart card and padlock provided on June 8, 2020. 3% credit card additional charge $350. ","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":2115,"order_total":13790,"final_order_total":11675,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'0012398480","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"906.00","deposit":"2012.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201612","PERSONAL","Mr","8+otsFWBUC8WFepvKI7Dew==","Zzv1eRCimQisUlUlw\/fpjg==","","rllNUQXT049sFETPjtczjg==","nqjeqHyjBPEEd7fl6wU+2dSytG3d90gvrOVoAbw\/FeA=","05bGvfHWxhV0Sfxkrse5cyVZsIQE4QqgD\/BNPqipwE\/dKgGjCBtbzaHU6PQel8dOzEESIL0I9R3vWFxI4HbszKNEM9scPUKzcffZwX3Q0nQ=","LfX6ES4t9QoR33w0SR5pBA==",null,"nqjeqHyjBPEEd7fl6wU+2dSytG3d90gvrOVoAbw\/FeA=","ZaKaS1iOVYbrLQZoO74PGw==","2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1612,"NEW","A16-CT208075",1006,906,2012,0,"13","13",11675,13790,11675,"2020-06-08 16:35:08","0",null,null,null,"2020-06-14","2021-07-13","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit paid by credit card on June 8, 2020. Smart card and padlock provided on June 8, 2020. 3% credit card additional charge $350. ","2020-06-14","9",0,null,2115,"2115.00","2","2020-06-08 16:35:06","2","2020-06-08 16:35:06","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"'0012398480","C201612","PERSONAL","Mr","8+otsFWBUC8WFepvKI7Dew==","Zzv1eRCimQisUlUlw\/fpjg==","","05bGvfHWxhV0Sfxkrse5cyVZsIQE4QqgD\/BNPqipwE\/dKgGjCBtbzaHU6PQel8dOzEESIL0I9R3vWFxI4HbszKNEM9scPUKzcffZwX3Q0nQ=","rllNUQXT049sFETPjtczjg==","nqjeqHyjBPEEd7fl6wU+2dSytG3d90gvrOVoAbw\/FeA=","LfX6ES4t9QoR33w0SR5pBA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8075","1548","1006.0","1006.00","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2021-07-13","1548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8075","A16-D205457","PAID",2012,0,"2021-07-13","2020-06-08 16:35:06","2020-06-08 16:35:06","2","2020-06-08 16:35:06","2","2020-06-08 16:35:06",1612]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8075",1612,"SETTLED","A16-I208404","2020-06-08 16:35:06","2020-06-14","2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,603,"MO","1",603,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",4,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",5,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",6,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",7,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",8,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",9,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",10,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",11,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",12,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404","RENT","\u9810\u7e73\u79df\u91d1",13,906,"MO","1",906,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9663,0,"8404"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1612,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P208047","2020-06-08 16:35:06",11675,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8047","DEPOSIT","5457","PAID","2020-06-08 16:35:06",2012,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:35:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8047","INVOICE","8404","PAID","2020-06-08 16:35:06",9663,"2","2020-06-08 16:35:06","2","2020-06-08 16:35:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 16:51:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:15:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:16:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:18:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:20:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:21:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1279,"customer_code":"C191279","identity_type":"PERSONAL","identity_id":"G465588(4)","title":"Mr","lastname":"CHOW","firstname":"Hing Wah","companyname":"","email":"vchowhk@gmail.com","tel":"94197624","address":"23H, Tower 9, Island Resort, 28 Siu Sai Wan Road, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1161.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-01","renew_room_key":"'0012436794","renew_remark":"12 months contract. Special "Rent Now" offer 5% off, and $400 discount. Storage rental and deposit paid by cheque on May 28, 2019. Smartcard provided on May 28, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195089, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2976.0","renew_master_room_id":"143","order_discount":[{"master_room_discount_id":"344","master_room_id":"143","discount_type":"%","price":"1488.00","disocunted_price":"967.90","discount":"34.95","monthly_deduct":520.056,"room_id":"1242","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1242","room_code":"B01-052","retail_price":"1488.0","discounted_price":967.9,"location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1161,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13932,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-05-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on June 07,2020. Storage deposit $2976 transferred from agreement B01-CT195089 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13932,"final_order_total":13932,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012436794","order_product":[],"pass":true}},"first_order_id":5089,"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> B01-052 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1161.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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","2","5",1279,"NEW","B01-CT208076",1488,1161,0,0,"12","12",13932,13932,13932,"2020-06-08 17:23:06","0",null,null,null,"2020-06-01","2021-05-31","12 months contract. Storage rental paid by bank transfer on June 07,2020. Storage deposit $2976 transferred from agreement B01-CT195089 to this agreement.","2020-06-01","24",0,null,0,"0","2","2020-06-08 17:23:05","2","2020-06-08 17:23:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012436794","C191279","PERSONAL","Mr","cDc83zIse2CoiGtBFAFvMQ==","3093ZJqm0DslwzntIOZxaw==","","VfAr8ToRkX+xAABk7\/xVwJoR4DrNL9bBVUDozkQMmItFiHoGY1WbWt2sCSAhLF0PKzI8MWKWWpORjk4WmZlQzA==","An1i71Fv78M8SnvpWsKDDA==","FH\/0GvCjp7L2rtx\/3+tK3x9UQA8GBc48fgO8W65nbzE=","Gp1LMheuq9E5al2O+XGFcA==",null,1,5089]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8076","344","143","1242","%","34.95",520.056,"2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8076","1242","1488.0",967.9,"2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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-06-01","2021-05-31","1242"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 17:23: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":["8076",1279,"SETTLED","B01-I208405","2020-06-08 17:23:05","2020-06-01","2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",1,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",2,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",3,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",4,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",5,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",6,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",7,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",8,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",9,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",10,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",11,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8405","RENT","\u9810\u7e73\u79df\u91d1",12,1161,"MO","1",1161,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13932,0,"8405"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 17:23: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":[1279,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208048","2020-06-08 17:23:05",13932,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8048","DEPOSIT",null,"PAID","2020-06-08 17:23:05",0,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:23: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":["8048","INVOICE","8405","PAID","2020-06-08 17:23:05",13932,"2","2020-06-08 17:23:05","2","2020-06-08 17:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27: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":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1289,"customer_code":"C191289","identity_type":"PERSONAL","identity_id":"D801511(3)","title":"Mr","lastname":"WONG","firstname":"Ming Fui","companyname":"","email":"rogerwongmf@yahoo.com.hk","tel":"90581288","address":"10D, Block 1, Roca Centre, Shu Kuk Street, North Point, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1190.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-08","renew_room_key":"'0012403604","renew_remark":"12 months contract. Special offer 2 months off. Storage rental and deposit paid by EPS on May 8, 2019. Smartcard provided on May 8, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195178, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1322.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1426","room_code":"C15-120","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1190,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":14280,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2021-06-07","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on June 08,2020. Storage deposit $1322 transferred from agreement C15-CT195178 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":14280,"final_order_total":14280,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012403604","order_product":[],"pass":true}},"first_order_id":5178,"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-120 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1190.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1289,"NEW","C15-CT208077",1322,1190,0,0,"12","12",14280,14280,14280,"2020-06-08 17:27:08","0",null,null,null,"2020-06-08","2021-06-07","12 months contract. Storage rental paid by bank transfer on June 08,2020. Storage deposit $1322 transferred from agreement C15-CT195178 to this agreement.","2020-06-08","24",0,null,0,"0","2","2020-06-08 17:27:08","2","2020-06-08 17:27:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012403604","C191289","PERSONAL","Mr","8VFOXyTU\/6X\/mHhfqOKacQ==","ddrfzAYTmkL\/QNu3psjONQ==","","gZm+K0MYbYWsUnl84x14HyB0kjazs2NgSE3laeA1G2xLN4r2fAE19+9xBrireVE6XL95kICuQm5VlNjUHnaQLcLk1wwj85yfMAs\/EUebDYQ=","qlz6qASAwcDIqdXrQCyE5Q==","duKZUfDw1GCGSBvc4qQLQHW4Brkuqk8z9Q2hR9jHA4s=","itFHMbx7pMjCWevlNwnDUA==",null,1,5178]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8077","1426","1322.0","1322.00","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-08","2021-06-07","1426"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8077",1289,"SETTLED","C15-I208406","2020-06-08 17:27:08","2020-06-08","2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",1,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",2,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",3,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",4,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",5,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",6,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",7,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",8,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",9,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",10,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",11,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8406","RENT","\u9810\u7e73\u79df\u91d1",12,1190,"MO","1",1190,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14280,0,"8406"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1289,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208049","2020-06-08 17:27:08",14280,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049","DEPOSIT",null,"PAID","2020-06-08 17:27:08",0,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 17:27:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049","INVOICE","8406","PAID","2020-06-08 17:27:08",14280,"2","2020-06-08 17:27:08","2","2020-06-08 17:27:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 18:08:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 18:34:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 18:36:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 21:51:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-08 22:07:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****