{"created_at":"2020-05-14 09:57:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":696,"customer_code":"C180696","identity_type":"PERSONAL","identity_id":"A885242(4)","title":"Ms","lastname":"Lee","firstname":"Sheung King Susanna","companyname":"","email":"smartyleehk@yahoo.com","tel":"61078166","address":"Flat 1, G\/F, Tin Fai House, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1135.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-07","renew_room_key":"054,20651","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 7, 2020. Storage deposit transferred from agreement A18-CT196367 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207144, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"88","order_discount":[],"order_room":[{"room_id":"926","room_code":"U27","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1135,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"177.00","warehousing_date":"2020-05-07","rent_from":"2020-05-07","rent_to":"2020-08-06","delivery_service":"0","remark":"3 months contract. Special offer $1076\/month. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A18-CT207144 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":177,"order_total":3405,"final_order_total":3228,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,20651","order_product":[],"pass":true}},"first_order_id":"4426","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>
U27 <\/td>\r\n\t\t\t\t\t	5X3X7 <\/td>\r\n\t\t\t\t\t	$1195.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":"15","total_discounted_price":"1135.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",696,"NEW","A18-CT207845",1195,1135,0,0,"3","3",3228,3405,3228,"2020-05-14 09:57:38","0",null,null,null,"2020-05-07","2020-08-06","3 months contract. Special offer $1076\/month. Storage rental paid by bank transfer on May 12, 2020. Storage deposit transferred from agreement A18-CT207144 to this agreement.\r\n","2020-05-07","15",0,null,177,"177.00","2","2020-05-14 09:57:37","2","2020-05-14 09:57:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,20651","C180696","PERSONAL","Ms","lUUgSqiO+3UfkBqsAoZcOIMXrzpK0Yrf\/\/Tskggn5OY=","kiriEIqhcx866RNZiMXdKQ==","","wbDuUqfTidJv1h01201xU8gFUWgLug2G5kn12AU51ASLzDUuPdgGwRE7nJizRWNsgxWjbU12WRi\/SWy+If7DTQ==","n++DQL9\/RTIOCwM9RgoxHg==","FSzM\/bOuWmiXsTeEFVthPnIVOHnDgw5qifiOLfY8cmU=","3\/z4\/6NRZprrf5\/EjtdVNQ==",null,1,"4426"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","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":["7845","926","1195.0","1195.00","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","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-07","2020-08-06","926"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 09:57:38","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":["7845",696,"SETTLED","A18-I208174","2020-05-14 09:57:37","2020-05-07","2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8174","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,958,"MO","1",958,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8174","RENT","\u9810\u7e73\u79df\u91d1",2,1135,"MO","1",1135,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8174","RENT","\u9810\u7e73\u79df\u91d1",3,1135,"MO","1",1135,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8174"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 09:57:38","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":[696,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207819","2020-05-14 09:57:37",3228,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","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":["7819","DEPOSIT",null,"PAID","2020-05-14 09:57:37",0,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 09:57:38","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":["7819","INVOICE","8174","PAID","2020-05-14 09:57:37",3228,"2","2020-05-14 09:57:37","2","2020-05-14 09:57:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:01:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1072,"customer_code":"C181072","identity_type":"BUSINESS","identity_id":"37318171-000","title":"Mr","lastname":"Kwan","firstname":"Troy","companyname":"Jonics Company Limited","email":"market@jonics.com.hk","tel":"98698211","address":"Unit 701, Kin Tak Fung, Commercial Bldg, 467-473 Hennessy Road, Causeway Bay, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1952.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-15","renew_room_key":"0012470114","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit $4336 transferred from agreement C15-CT183569 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196423, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"184","order_discount":[{"master_room_discount_id":"430","master_room_id":"184","discount_type":"%","price":"2168.00","disocunted_price":"1626.90","discount":"24.96","monthly_deduct":541.1328,"room_id":"1331","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1331","room_code":"C15-025","retail_price":"2168.0","discounted_price":1626.9,"location_id":"6"}],"roughly_size":"40","total_retail_price":2168,"total_discounted_price":1952,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11712,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-11-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 13,2020. Storage deposit $4336 transferred from agreement C15-CT196423 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11712,"final_order_total":11712,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012470114","order_product":[],"pass":true}},"first_order_id":"3569","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-025 <\/td>\r\n\t\t\t\t\t 5X8X6.5 <\/td>\r\n\t\t\t\t\t $2168.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":"40","total_discounted_price":"1952.0","deposit":"0","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1072,"NEW","C15-CT207846",2168,1952,0,0,"6","6",11712,11712,11712,"2020-05-14 10:06:13","0",null,null,null,"2020-05-15","2020-11-14","6 months contract. Storage rental paid by bank transfer on May 13,2020. Storage deposit $4336 transferred from agreement C15-CT196423 to this agreement.","2020-05-15","40",0,null,0,"0","2","2020-05-14 10:06:12","2","2020-05-14 10:06:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012470114","C181072","BUSINESS","Mr","GgJJcvoXyWqaMfoSQ7YOIg==","iNwdG3Dj3OBaAQ6MRfBM1w==","Jonics Company Limited","0jjLB\/lKiVbreDxDWcuDTgUEgq3CeWJVjLJW6XeIE+dTKGlRXS08jydvKnWhUQayGmUq8Drbp2WbMLbw0R\/XLS5O52sajGLm9nj0t8QF3YrO3Q7DOdNEJB9qiTBtbrO5","TUJjaDG7Us5ojXezujsHUw==","vp\/uySsdv\/Lqz24frGU9\/iikx6vkoUcfh5oabpHVhMI=",null,"3jSQdnbBLYDw1Do9kBBCpQ==",1,"3569"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","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":["7846","430","184","1331","%","24.96",541.1328,"2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7846","1331","2168.0",1626.9,"2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-15","2020-11-14","1331"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7846",1072,"SETTLED","C15-I208175","2020-05-14 10:06:12","2020-05-15","2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",1,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",2,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",3,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",4,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",5,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8175","RENT","\u9810\u7e73\u79df\u91d1",6,1952,"MO","1",1952,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11712,0,"8175"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1072,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207820","2020-05-14 10:06:12",11712,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7820","DEPOSIT",null,"PAID","2020-05-14 10:06:12",0,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:06:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7820","INVOICE","8175","PAID","2020-05-14 10:06:12",11712,"2","2020-05-14 10:06:12","2","2020-05-14 10:06:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1063,"customer_code":"C181063","identity_type":"PERSONAL","identity_id":"P150061(2)","title":"Ms","lastname":"HASKINS","firstname":"Eileen Mary","companyname":"","email":"eimart@netvigator.com","tel":"92769708","address":"House 20A Pok Kok Tsven","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-13","renew_room_key":"'0012435080","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit $2580 transferred from agreement A05-CT207317 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207432, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"249","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"1126","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1126","room_code":"A05-124","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-13","rent_from":"2020-04-13","rent_to":"2020-07-12","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 14, 2020. Storage deposit $2580 transferred from agreement A05-CT207432 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012435080","order_product":[],"pass":true}},"first_order_id":"3560","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-124 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1226.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1063,"NEW","A05-CT207847",1290,1226,0,0,"3","3",3678,3678,3678,"2020-05-14 10:11:15","0",null,null,null,"2020-04-13","2020-07-12","3 months contract. Storage rental paid by bank transfer on May 14, 2020. Storage deposit $2580 transferred from agreement A05-CT207432 to this agreement.\r\n","2020-04-13","16",0,null,0,"0","2","2020-05-14 10:11:14","2","2020-05-14 10:11:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435080","C181063","PERSONAL","Ms","N2dL4uJnRUVt3pWxZbjoPA==","gBCfCDjxN1soEZ6ASSV8CQ==","","WxFMz3JMJw0zIWOLHcLgDzylG1NdowDT02leCzTzNHk=","9LmyvpD23mCmBchshNAO0w==","WMY4NPSZuxSFljp7Sz0XPINva+8MxbIjoBMZ02LKzdU=","UcXhFM2zM7eIpbzXOGUfvA==",null,1,"3560"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","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":["7847","249","114","1126","%","4.97",64.113,"2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","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":["7847","1126","1290.0",1225.9,"2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","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-04-13","2020-07-12","1126"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:11:15","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":["7847",1063,"SETTLED","A05-I208176","2020-05-14 10:11:14","2020-04-13","2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8176","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8176","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8176","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"8176"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 10:11:15","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":[1063,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207821","2020-05-14 10:11:14",3678,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","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":["7821","DEPOSIT",null,"PAID","2020-05-14 10:11:14",0,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:11:15","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":["7821","INVOICE","8176","PAID","2020-05-14 10:11:14",3678,"2","2020-05-14 10:11:14","2","2020-05-14 10:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"759","master_room_id":"35","room_code":"O35"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A14-CT207366 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207597, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2020-06-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 9, 2020. Storage deposit transferred from agreement A14-CT207597 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K59 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K56 <\/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":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT207848",5062,4499,0,0,"1","1",4499,4499,4499,"2020-05-14 10:14:40","0",null,null,null,"2020-05-10","2020-06-09","1 month contract. Storage rental paid by bank transfer on May 9, 2020. Storage deposit transferred from agreement A14-CT207597 to this agreement.\r\n","2020-05-10","72",0,null,0,"0","2","2020-05-14 10:14:40","2","2020-05-14 10:14:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7848","522","1098.0","1098.00","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7848","521","1098.0","1098.00","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7848","520","1098.0","1098.00","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7848","519","1768.0","1768.00","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2020-06-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7848",423,"SETTLED","A14-I208177","2020-05-14 10:14:40","2020-05-10","2","2020-05-14 10:14:40","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8177","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-05-14 10:14:40","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"8177"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207822","2020-05-14 10:14:40",4499,"2","2020-05-14 10:14:40","2","2020-05-14 10:14:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7822","DEPOSIT",null,"PAID","2020-05-14 10:14:40",0,"2","2020-05-14 10:14:40","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:14:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7822","INVOICE","8177","PAID","2020-05-14 10:14:40",4499,"2","2020-05-14 10:14:40","2","2020-05-14 10:14:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:23:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:28:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:28:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:28:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 10:46:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 11:54:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 11:58:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"246","room_code":"WC-06"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> WC-06 <\/td>\r\n\t\t\t\t\t 3.5X4X8 <\/td>\r\n\t\t\t\t\t $0.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":"Z087494(A)","title":"Mr","lastname":"HO","firstname":"Chung Tak","companyname":"","email":"sspd.aho@gmail.com","tel":"98426238","address":"House 7, Royal Crest, 68 Pat Heung Road, Yuen Long","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1763","room_code":"WC-06","retail_price":"0.0","discounted_price":"0.00","location_id":"8"}],"roughly_size":"14","total_retail_price":0,"total_discounted_price":1429,"deposit":3176,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11750,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by EPS on May 14, 2020. Access card and padlock provided on May 13, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":11750,"final_order_total":11750,"location_id":"8","branch_id":"1","company_id":"1","room_key":"189, 28768","order_product":[],"pass":true}},"roughly_size":"14","total_discounted_price":"1429.00","deposit":"3176.00","total_retail_price":"0.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:10","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":["C201581","PERSONAL","Mr","A6RIF+RBo5M9aDs5qRVB0g==","Zzv1eRCimQisUlUlw\/fpjg==","","\/Wqzp\/4VdDO8aAQmmcUWCw==","1IddmdWmHHB+jh9UbRVdVfSka8uh2IDc0\/aKcDHrCkk=","8U2H3JzwKSp7CZrd6vxU9No2Ev19TB6Zd2P8+J4lkeW60r2A62EXvo+OLqu6jra0Sv0W9tEFtYCBm8qffkr6BA==","heVoSg4mQyhUFI\/6IXahng==",null,"1IddmdWmHHB+jh9UbRVdVfSka8uh2IDc0\/aKcDHrCkk=","wxl0OOvcRRFI+e1Y6PBaqw==","2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","8",1581,"NEW","WC-CT207849",0,1429,3176,0,"6","6",11750,11750,11750,"2020-05-14 12:12:11","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental and deposit paid by EPS on May 14, 2020. Access card and padlock provided on May 13, 2020. ","2020-06-01","14",0,null,0,"0","2","2020-05-14 12:12:09","2","2020-05-14 12:12:09","EPS","","","","EPS","","","",null,0,"189, 28768","C201581","PERSONAL","Mr","A6RIF+RBo5M9aDs5qRVB0g==","Zzv1eRCimQisUlUlw\/fpjg==","","8U2H3JzwKSp7CZrd6vxU9No2Ev19TB6Zd2P8+J4lkeW60r2A62EXvo+OLqu6jra0Sv0W9tEFtYCBm8qffkr6BA==","\/Wqzp\/4VdDO8aAQmmcUWCw==","1IddmdWmHHB+jh9UbRVdVfSka8uh2IDc0\/aKcDHrCkk=","heVoSg4mQyhUFI\/6IXahng==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7849","1763","0.0","0.00","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","1763"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 12:12:11","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":["7849","WC-D205409","PAID",3176,0,"2020-11-30","2020-05-14 12:12:09","2020-05-14 12:12:09","2","2020-05-14 12:12:09","2","2020-05-14 12:12:09",1581]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7849",1581,"SETTLED","WC-I208178","2020-05-14 12:12:09","2020-06-01","2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",1,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",2,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",3,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",4,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",5,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8178","RENT","\u9810\u7e73\u79df\u91d1",6,1429,"MO","1",1429,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8574,0,"8178"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1581,"EPS","","","","EPS","","","","PAID","P207823","2020-05-14 12:12:09",11750,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7823","DEPOSIT","5409","PAID","2020-05-14 12:12:09",3176,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 12:12:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7823","INVOICE","8178","PAID","2020-05-14 12:12:09",8574,"2","2020-05-14 12:12:09","2","2020-05-14 12:12:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 13:44:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1302&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> H08 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"55958022","title":"Ms","lastname":"NG","firstname":"Hau Yee Natalie","companyname":"Shine Kids","email":"","tel":"53006299","address":"Rm 2202, 22\/F, Causeway Bay Plaza Phase 1, 489 Hennessy Road, Causeway Bay, HK.","pass":true,"customer_id":"1446","customer_code":"C191446","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"398","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"398","room_code":"H08","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3421,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1422.00","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-08-16","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on Feb 17,2020. Padlock provided on Feb 17,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1422,"order_total":4843,"final_order_total":3421,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,1654,190,40496","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"949.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1446","NEW","A12-CT207850",998,949,1996,0,"3","3",3421,4843,3421,"2020-05-14 14:59:48","0",null,null,null,"2020-05-17","2020-08-16","3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on Feb 17,2020. Padlock provided on Feb 17,2020.","2020-05-17","12",0,null,1422,"1422.00","2","2020-05-14 14:59:47","2","2020-05-14 14:59:47","CHEQUE","","","","CHEQUE","","","",null,0,"190,1654,190,40496","C191446","BUSINESS","Ms","bzI2ymAqRhND+s7nIvjOTg==","yXKLXTtbNpECaRVTZxF\/Rw==","Shine Kids","QhZP0MNFsAlLqPyLUc7juoQm3sL0T8Zrc2Zi0Xhq4pc49sAp6m6yAWMSCDy30oluo0FycS4gFJwppF6UCisHRRMeaEuvScTPl99rdx1zSoY=","Og6U0dK51G6\/ReO9I+LIoA==",null,null,"DRoqlBum4+C1qjLKGD19zA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","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":["7850","469","6","398","%","4.91",49.0018,"2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","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":["7850","398","998.0",949,"2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-08-16","398"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 14:59:48","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":["7850","A12-D205410","PAID",1996,0,"2020-08-16","2020-05-14 14:59:47","2020-05-14 14:59:47","2","2020-05-14 14:59:47","2","2020-05-14 14:59:47","1446"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","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":["7850","1446","SETTLED","A12-I208179","2020-05-14 14:59:47","2020-05-17","2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8179","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8179","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,476,"MO","1",476,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8179","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1425,0,"8179"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 14:59:48","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":["1446","CHEQUE","","","","CHEQUE","","","","PAID","P207824","2020-05-14 14:59:47",3421,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","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":["7824","DEPOSIT","5410","PAID","2020-05-14 14:59:47",1996,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 14:59:48","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":["7824","INVOICE","8179","PAID","2020-05-14 14:59:47",1425,"2","2020-05-14 14:59:47","2","2020-05-14 14:59:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 17:10:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 17:18:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 18:04:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:14","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":986,"customer_code":"C180986","identity_type":"PERSONAL","identity_id":"R950235(0)","title":"Mr","lastname":"Mok ","firstname":"Wai Keung","companyname":"","email":"a2488729950@gmail.com","tel":"68457227","address":"Rm2307 ,Sui Ming Hse, Siu Sai Wan Est, Siu Sai Wan, Chai Wan , H.K","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"908.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-11","renew_room_key":"'0012435026","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 17,2020. Deposit $1816 transferred from agreement B01-CT207453 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207656, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"138","order_discount":[],"order_room":[{"room_id":"1219","room_code":"B01-029","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":908,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2020-06-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 14,2020. Deposit $1816 transferred from agreement B01-CT207656 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":908,"final_order_total":908,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012435026","order_product":[],"pass":true}},"first_order_id":"3247","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-029 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $908.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":"12","total_discounted_price":"908.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","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",986,"NEW","B01-CT207851",908,908,0,0,"1","1",908,908,908,"2020-05-14 19:11:15","0",null,null,null,"2020-05-11","2020-06-10","1 month contract. Storage rental paid by bank transfer on May 14,2020. Deposit $1816 transferred from agreement B01-CT207656 to this agreement.","2020-05-11","12",0,null,0,"0","2","2020-05-14 19:11:14","2","2020-05-14 19:11:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435026","C180986","PERSONAL","Mr","31Y0XoaFobtCMxnm6mvlFA==","ytgkiE+Fm0DVDP\/K9BuKZg==","","\/xjwgidCRjbnJPBKCuo\/12pqSl6LNrA3NlsIMUsH9BNKaKZYzR6Q54z4PxEVPTW2DvAjTp5DGzVXkPgWrYcHBUDozThZzReTLDf\/mHLbaeQ=","AU0eLXU29TAY\/BkeJ1YrcA==","ngNTmQ\/HB0cYMtP4VGLH4jDsPYe75zJZad7lIY9miHQ=","g+ya6MKmjABbrezVh9RtHw==",null,1,"3247"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","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":["7851","1219","908.0","908.00","2","2020-05-14 19:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","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-11","2020-06-10","1219"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-14 19:11:15","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":["7851",986,"SETTLED","B01-I208180","2020-05-14 19:11:14","2020-05-11","2","2020-05-14 19:11:14","2","2020-05-14 19:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8180","RENT","\u9810\u7e73\u79df\u91d1",1,908,"MO","1",908,"2","2020-05-14 19:11:14","2","2020-05-14 19:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[908,0,"8180"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-14 19:11:15","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":[986,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207825","2020-05-14 19:11:14",908,"2","2020-05-14 19:11:14","2","2020-05-14 19:11:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","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":["7825","DEPOSIT",null,"PAID","2020-05-14 19:11:14",0,"2","2020-05-14 19:11:14","2","2020-05-14 19:11:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-14 19:11:15","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":["7825","INVOICE","8180","PAID","2020-05-14 19:11:14",908,"2","2020-05-14 19:11:14","2","2020-05-14 19:11:14"]},"data_before":[],"data_after":[],"step":1} *****