{"created_at":"2020-03-10 10:13:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":708,"customer_code":"C180708","identity_type":"PERSONAL","identity_id":"P208633(A)","title":"Mr","lastname":"Lam","firstname":"Henry Hang Ling","companyname":"","email":"henrylam@email.com","tel":"62300702","address":"16D, Goldwin Heights, 2 Seymour Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2434.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-14","renew_room_key":"054,60414","renew_remark":"2 months contract. Storage rental $4900 paid by bank transfer on January 15, 2020. Outstanding $32 will transfer to next contract. Storage deposit transferred from agreement A18-CT196386 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206974, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"868","room_code":"T12","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"867","room_code":"T11","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2434,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2434,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-14","rent_from":"2020-02-14","rent_to":"2020-03-13","delivery_service":"0","remark":"1 months contract. Storage rental $2434 paid by bank transfer on March 9, 2020. Extra $32 from last contract will transfer to next contract. Storage deposit transferred from agreement A18-CT206974 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2434,"final_order_total":2434,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,60414","order_product":[],"pass":true}},"first_order_id":"4723","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
T12 <\/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>
T11 <\/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":"32","total_discounted_price":"2434.00","deposit":"0.00","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",708,"NEW","A18-CT207362",2580,2434,0,0,"1","1",2434,2434,2434,"2020-03-10 10:13:18","0",null,null,null,"2020-02-14","2020-03-13","1 months contract. Storage rental $2434 paid by bank transfer on March 9, 2020. Extra $32 from last contract will transfer to next contract. Storage deposit transferred from agreement A18-CT206974 to this agreement.\r\n","2020-02-14","32",0,null,0,"0","2","2020-03-10 10:13:17","2","2020-03-10 10:13:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60414","C180708","PERSONAL","Mr","PTa9TkkuKfu4jwNnLRl7bA==","0JxYUqbNPOvgfMwVa0l0NA==","","FqEbl\/Vqia+apcWATmy0qI1jVSPGOQv+s8CLECBrdrOwYgMK2yudpo3PYRdJhmZi","NGbsOMu\/dtiprozEMsHWzw==","jy7Rom83Y2MCQ+LKg3+jO+YsY98Vm1g+iOp8lmmscAc=","ZEEfmQxu1lN8ppqH8XvTbg==",null,1,"4723"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7362","868","1290.0","1290.00","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-14","2020-03-13","868"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7362","867","1290.0","1290.00","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-14","2020-03-13","867"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7362",708,"SETTLED","A18-I207690","2020-03-10 10:13:17","2020-02-14","2","2020-03-10 10:13:17","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7690","RENT","\u9810\u7e73\u79df\u91d1",1,2434,"MO","1",2434,"2","2020-03-10 10:13:17","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2434,0,"7690"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[708,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207338","2020-03-10 10:13:17",2434,"2","2020-03-10 10:13:17","2","2020-03-10 10:13:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7338","DEPOSIT",null,"PAID","2020-03-10 10:13:17",0,"2","2020-03-10 10:13:17","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:13:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7338","INVOICE","7690","PAID","2020-03-10 10:13:17",2434,"2","2020-03-10 10:13:17","2","2020-03-10 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":687,"customer_code":"C180687","identity_type":"PERSONAL","identity_id":"D675603(5)","title":"Ms","lastname":"Wong","firstname":"Lok Yi Candy","companyname":"","email":null,"tel":"90268152","address":"Flat C, 20\/F, Tower 1, Sham Wan Towers, Ap Lei Chau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1036.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-08","renew_room_key":"134,16041","renew_remark":"3 months contract. Storage rental paid by bank transferred on December 20, 2019. Storage deposit $2180 transferred from agreement A18-CT195977 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196756, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"882","room_code":"Y11","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1036,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-08","rent_from":"2020-03-08","rent_to":"2020-06-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transferred on March 9, 2020. Storage deposit $2180 transferred from agreement A18-CT196756 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3108,"final_order_total":3108,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134,16041","order_product":[],"pass":true}},"first_order_id":"4800","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> Y11 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1036.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",687,"NEW","A18-CT207363",1090,1036,0,0,"3","3",3108,3108,3108,"2020-03-10 10:20:41","0",null,null,null,"2020-03-08","2020-06-07","3 months contract. Storage rental paid by bank transferred on March 9, 2020. Storage deposit $2180 transferred from agreement A18-CT196756 to this agreement.\r\n","2020-03-08","12",0,null,0,"0","2","2020-03-10 10:20:41","2","2020-03-10 10:20:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,16041","C180687","PERSONAL","Ms","yV\/SioaJMiWMQj9QbjvBQw==","hULSwM2MvFtpeV9\/z+er8Q==","","gZZjKoytf7\/aMjBy24riG3+7FKQXKWQeN4c5ayDE3FZzZykIuMJePBDOg97SQO1Yv1Kx0L1KbejhBRZVd4rB7g==","6SPyQv\/GcjNiW8cG9Kb1XQ==",null,"h69NujE8OrYG3xO38t2f7w==",null,1,"4800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7363","882","1090.0","1090.00","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-08","2020-06-07","882"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7363",687,"SETTLED","A18-I207691","2020-03-10 10:20:41","2020-03-08","2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7691","RENT","\u9810\u7e73\u79df\u91d1",1,1036,"MO","1",1036,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7691","RENT","\u9810\u7e73\u79df\u91d1",2,1036,"MO","1",1036,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7691","RENT","\u9810\u7e73\u79df\u91d1",3,1036,"MO","1",1036,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3108,0,"7691"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[687,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207339","2020-03-10 10:20:41",3108,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","DEPOSIT",null,"PAID","2020-03-10 10:20:41",0,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","INVOICE","7691","PAID","2020-03-10 10:20:41",3108,"2","2020-03-10 10:20:41","2","2020-03-10 10:20:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":544,"customer_code":"C170544","identity_type":"PERSONAL","identity_id":"K417807(6)","title":"Ms","lastname":"Tai","firstname":"Lai Shan","companyname":"","email":null,"tel":"90928656","address":"Flat A,24\/F,BK 2,Elegant Garden,409 Queen's Rd West ,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-12","renew_room_key":"055,32406","renew_remark":"6 months contract. Storage rental paid by bank transfer on March 2, 2019. Storage deposit transferred from agreement A18-CT182939 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194492, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"853","room_code":"S12","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-03-12","rent_from":"2020-03-12","rent_to":"2021-04-11","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT194492 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32406","order_product":[],"pass":true}},"first_order_id":4492,"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> S12 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","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",544,"NEW","A18-CT207364",1290,1162,0,0,"13","13",13944,15106,13944,"2020-03-10 10:30:43","0",null,null,null,"2020-03-12","2021-04-11","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT194492 to this agreement.","2020-03-12","16",0,null,1162,"1162.00","2","2020-03-10 10:30:43","2","2020-03-10 10:30:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32406","C170544","PERSONAL","Ms","\/SicBmKhYUXEgI3tetO2QA==","lQHp\/TjpLAQuEgkkrCqckQ==","","k7G+\/0K2hk4resVDQpBv7p4thtS1OzgYGgSOkCm6\/aWWco4asqganT7weYlCTm0RssStPaql7LHPhNmW5fZABg==","h1YLiQlZMqahbbDZpBOXjA==",null,"qBYAqu\/hWEu61h0pjLSAfw==",null,1,4492]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","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":["7364","853","1290.0","1290.00","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","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-03-12","2021-04-11","853"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:30:43","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":["7364",544,"SETTLED","A18-I207692","2020-03-10 10:30:43","2020-03-12","2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7692"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 10:30:43","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":[544,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207340","2020-03-10 10:30:43",13944,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","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":["7340","DEPOSIT",null,"PAID","2020-03-10 10:30:43",0,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:30:43","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":["7340","INVOICE","7692","PAID","2020-03-10 10:30:43",13944,"2","2020-03-10 10:30:43","2","2020-03-10 10:30:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:31:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":547,"customer_code":"C170547","identity_type":"PERSONAL","identity_id":"K396653(4)","title":"Ms","lastname":"Li","firstname":"Mei Hing","companyname":"","email":null,"tel":"61601428","address":"9\/F,Rear Portion,425N Queen's Rd W, Western District, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-15","renew_room_key":"0003454688, 0003588254","renew_remark":"12 months contract. L21 to A05-019. Storage deposit($2036) transferred from agreement A14-CT183058. Remaining deposit and storage rental ($18514) paid by cheque on February 28, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194458, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"120","order_discount":[],"order_room":[{"room_id":"1021","room_code":"A05-019","retail_price":"1605.0","discounted_price":"1605.00","location_id":"4"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":17340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1445.00","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2021-04-14","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on March 10, 2020. Storage deposit $3210 transferred from agreement A05-CT194458 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1445,"order_total":18785,"final_order_total":17340,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0003454688, 0003588254","order_product":[],"pass":true}},"first_order_id":4458,"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-019 <\/td>\r\n\t\t\t\t\t 5X4X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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","4",547,"NEW","A05-CT207365",1605,1445,0,0,"13","13",17340,18785,17340,"2020-03-10 10:35:32","0",null,null,null,"2020-03-15","2021-04-14","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on March 10, 2020. Storage deposit $3210 transferred from agreement A05-CT194458 to this agreement. ","2020-03-15","20",0,null,1445,"1445.00","2","2020-03-10 10:35:31","2","2020-03-10 10:35:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0003454688, 0003588254","C170547","PERSONAL","Ms","v72zlkzt6RawYG46PxxBEg==","7KCehmxbvwRMb+U8lHGoVA==","","pwvAgR7QDST0eBElv+F3rZNoFf8naX10sT0NJ2JOCkY1wk\/eJtuXxDZZTc5gXnI4cOo2aWME\/2pCfSQvMY28hA==","uvW+nJabncTQn2X+y7xlSw==",null,"u8QhdgIlwLsrqbe2wDwrqg==",null,1,4458]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7365","1021","1605.0","1605.00","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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-03-15","2021-04-14","1021"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:35: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":["7365",547,"SETTLED","A05-I207693","2020-03-10 10:35:31","2020-03-15","2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7693","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17340,0,"7693"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 10:35: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":[547,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207341","2020-03-10 10:35:31",17340,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7341","DEPOSIT",null,"PAID","2020-03-10 10:35:31",0,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:35: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":["7341","INVOICE","7693","PAID","2020-03-10 10:35:31",17340,"2","2020-03-10 10:35:31","2","2020-03-10 10:35:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"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-03-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A14-CT207044 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207184, \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-03-10","rent_from":"2020-03-10","rent_to":"2020-04-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A14-CT207184 to this agreement.","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-03-10 10:40:59","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-CT207366",5062,4499,0,0,"1","1",4499,4499,4499,"2020-03-10 10:40:59","0",null,null,null,"2020-03-10","2020-04-09","1 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A14-CT207184 to this agreement.","2020-03-10","72",0,null,0,"0","2","2020-03-10 10:40:59","2","2020-03-10 10:40:59","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-03-10 10:40:59","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":["7366","522","1098.0","1098.00","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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-03-10","2020-04-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:40:59","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":["7366","521","1098.0","1098.00","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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-03-10","2020-04-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:40:59","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":["7366","520","1098.0","1098.00","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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-03-10","2020-04-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:40:59","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":["7366","519","1768.0","1768.00","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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-03-10","2020-04-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 10:40:59","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":["7366",423,"SETTLED","A14-I207694","2020-03-10 10:40:59","2020-03-10","2","2020-03-10 10:40:59","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7694","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-03-10 10:40:59","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"7694"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 10:40:59","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","P207342","2020-03-10 10:40:59",4499,"2","2020-03-10 10:40:59","2","2020-03-10 10:40:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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":["7342","DEPOSIT",null,"PAID","2020-03-10 10:40:59",0,"2","2020-03-10 10:40:59","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:40:59","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":["7342","INVOICE","7694","PAID","2020-03-10 10:40:59",4499,"2","2020-03-10 10:40:59","2","2020-03-10 10:40:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 10:50:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":957,"customer_code":"C180957","identity_type":"PERSONAL","identity_id":"D524263(1)","title":"Ms","lastname":"Man","firstname":"Tze Hung","companyname":"","email":"tzehungm@yahoo.com.hk","tel":"93717175","address":"Flat 1, 7\/F, Mei Fung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2730.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-15","renew_room_key":"0012449901","renew_remark":"6 months contract. Storage rental paid by bank transfer on Sep 9, 2019. Storage deposit transferred from agreement A05-CT194558 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195907, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"124","order_discount":[],"order_room":[{"room_id":"1059","room_code":"A05-057","retail_price":"3033.0","discounted_price":"3033.00","location_id":"4"}],"roughly_size":"40","total_retail_price":3033,"total_discounted_price":2730,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":32760,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2730.00","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2021-04-14","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque deposit on Mar 10,2020. Storage deposit transferred from agreement A05-CT195907 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2730,"order_total":35490,"final_order_total":32760,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012449901","order_product":[],"pass":true}},"first_order_id":"4558","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-057 <\/td>\r\n\t\t\t\t\t 5X8X7 <\/td>\r\n\t\t\t\t\t $3033.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":"2730.00","deposit":"0.00","total_retail_price":"3033.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",957,"NEW","A05-CT207367",3033,2730,0,0,"13","13",32760,35490,32760,"2020-03-10 12:11:39","0",null,null,null,"2020-03-15","2021-04-14","13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque deposit on Mar 10,2020. Storage deposit transferred from agreement A05-CT195907 to this agreement.","2020-03-15","40",0,null,2730,"2730.00","2","2020-03-10 12:11:39","2","2020-03-10 12:11:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012449901","C180957","PERSONAL","Ms","gBGad+T6pDJbcwpiAXULCw==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","NQihSLya6c2ppQR8fZ\/wPyNNUC9gb1Z13FFOyPQH+0Pt0LTXLn\/9aoMEqDDV3TW3xQAO5dK9NaOz7GQn2vCABydg9mY9f80czzQCJVoip\/Q=","bIGGdbG3CHad5JyleGifEA==","5qYn8oli3ubv5MEbfLgCuUvWBwBtR8ZFEVc70p2xyYE=","nuplFbIeMKy8QVH+\/4CjYA==",null,1,"4558"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7367","1059","3033.0","3033.00","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-15","2021-04-14","1059"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7367",957,"SETTLED","A05-I207695","2020-03-10 12:11:39","2020-03-15","2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",3,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",4,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",5,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",6,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",7,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",8,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",9,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",10,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",11,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",12,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","RENT","\u9810\u7e73\u79df\u91d1",13,2730,"MO","1",2730,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[32760,0,"7695"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[957,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207343","2020-03-10 12:11:39",32760,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7343","DEPOSIT",null,"PAID","2020-03-10 12:11:39",0,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 12:11:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7343","INVOICE","7695","PAID","2020-03-10 12:11:39",32760,"2","2020-03-10 12:11:39","2","2020-03-10 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=598&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-04","renew_room_key":"076,48044","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 11, 2020. Storage deposit $4376 transferred from agreement A12-CT206889 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207164, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-04","rent_from":"2020-01-04","rent_to":"2020-02-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $4376 transferred from agreement A12-CT207164 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"2188.0","deposit":"0","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1355,"NEW","A12-CT207368",2276,2188,0,0,"1","1",2188,2188,2188,"2020-03-10 14:55:47","0",null,null,null,"2020-01-04","2020-02-03","1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $4376 transferred from agreement A12-CT207164 to this agreement.\r\n","2020-01-04","30",0,null,0,"0","2","2020-03-10 14:55:46","2","2020-03-10 14:55:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","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":["7368","297","1138.0","946.00","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-04","2020-02-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 14:55:47","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":["7368","308","1138.0","946.00","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-04","2020-02-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 14:55:47","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":["7368",1355,"SETTLED","A12-I207696","2020-03-10 14:55:46","2020-01-04","2","2020-03-10 14:55:46","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7696","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-03-10 14:55:46","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"7696"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 14:55:47","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207344","2020-03-10 14:55:46",2188,"2","2020-03-10 14:55:46","2","2020-03-10 14:55:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","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":["7344","DEPOSIT",null,"PAID","2020-03-10 14:55:46",0,"2","2020-03-10 14:55:46","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 14:55:47","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":["7344","INVOICE","7696","PAID","2020-03-10 14:55:46",2188,"2","2020-03-10 14:55:46","2","2020-03-10 14:55:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:07:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:07:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=598&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":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":707,"customer_code":"C180707","identity_type":"PERSONAL","identity_id":"XD664200(A)","title":"Mr","lastname":"Figueiras","firstname":"Julio Alberto","companyname":"","email":"scaljf@yahoo.com","tel":"90490864","address":"24B, Block 25, Baguio Villa, 555 Victoria Road, 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":"2161.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-08","renew_room_key":"055,02407","renew_remark":"3 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A18-CT196144 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207152, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"897","room_code":"Y26","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2053,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6159,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-08","rent_from":"2020-02-08","rent_to":"2020-05-07","delivery_service":"0","remark":"3 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT207152 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6159,"final_order_total":6159,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,02407","order_product":[],"pass":true}},"first_order_id":"4758","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> Y26 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"2053.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",707,"NEW","A18-CT207369",2161,2053,0,0,"3","3",6159,6159,6159,"2020-03-10 15:40:07","0",null,null,null,"2020-02-08","2020-05-07","3 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT207152 to this agreement.","2020-02-08","28",0,null,0,"0","2","2020-03-10 15:40:07","2","2020-03-10 15:40:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,02407","C180707","PERSONAL","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","","K5\/5N+Bn0vBxmk8zM4MdOaD5g\/ggASRq4gDh8rMA\/2x+pfaHe8CKVVwOGqDLCKD7DoW+N1f1zYdDvubF4CXfuQ6ylZO+RwDnmiiRHP0oIxI=","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","WhxmmwJ+NlhISvFFctqMCA==",null,1,"4758"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7369","897","2161.0","2161.00","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-08","2020-05-07","897"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7369",707,"SETTLED","A18-I207697","2020-03-10 15:40:07","2020-02-08","2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7697","RENT","\u9810\u7e73\u79df\u91d1",1,2053,"MO","1",2053,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7697","RENT","\u9810\u7e73\u79df\u91d1",2,2053,"MO","1",2053,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7697","RENT","\u9810\u7e73\u79df\u91d1",3,2053,"MO","1",2053,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6159,0,"7697"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[707,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207345","2020-03-10 15:40:07",6159,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7345","DEPOSIT",null,"PAID","2020-03-10 15:40:07",0,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:40:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7345","INVOICE","7697","PAID","2020-03-10 15:40:07",6159,"2","2020-03-10 15:40:07","2","2020-03-10 15:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=598&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-09","renew_room_key":"052,49830,076,49433","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A14-CT206914 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207053, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"602","room_code":"M13","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-09","rent_from":"2020-03-09","rent_to":"2020-04-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 10, 2020. Storage deposit transferred from agreement A14-CT207053 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,49830,076,49433","order_product":[],"pass":true}},"first_order_id":"4958","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> M13 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",57,"NEW","A14-CT207370",598,598,0,0,"1","1",598,598,598,"2020-03-10 15:43:13","0",null,null,null,"2020-03-09","2020-04-08","1 month contract. Storage rental paid by bank transfer on March 10, 2020. Storage deposit transferred from agreement A14-CT207053 to this agreement.\r\n","2020-03-09","12",0,null,0,"0","2","2020-03-10 15:43:13","2","2020-03-10 15:43:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830,076,49433","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4958"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43: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":["7370","602","598.0","598.00","2","2020-03-10 15:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43: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-03-09","2020-04-08","602"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 15:43: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":["7370",57,"SETTLED","A14-I207698","2020-03-10 15:43:13","2020-03-09","2","2020-03-10 15:43:13","2","2020-03-10 15:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43: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":["7698","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-10 15:43:13","2","2020-03-10 15:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7698"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 15:43: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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207346","2020-03-10 15:43:13",598,"2","2020-03-10 15:43:13","2","2020-03-10 15:43:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43: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":["7346","DEPOSIT",null,"PAID","2020-03-10 15:43:13",0,"2","2020-03-10 15:43:13","2","2020-03-10 15:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:43: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":["7346","INVOICE","7698","PAID","2020-03-10 15:43:13",598,"2","2020-03-10 15:43:13","2","2020-03-10 15:43:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":"filter1=2&filter2=598&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":921,"customer_code":"C180921","identity_type":"PERSONAL","identity_id":"K417766(5)","title":"Mr","lastname":"Ng","firstname":"Chi Fai","companyname":"","email":null,"tel":"91249410","address":"Flat 2113, Tung Sing House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-06","renew_room_key":"190,01480","renew_remark":"3 months contract. Storage rental $3700 paid by cash deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195872 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206867, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"899","room_code":"T16","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"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-01-06","rent_from":"2020-01-06","rent_to":"2020-04-05","delivery_service":"0","remark":"3 months contract. Storage rental $3700 paid by cash deposit on March 10, 2020. Storage deposit transferred from agreement A18-CT206867 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":"3","branch_id":"1","company_id":"1","room_key":"190,01480","order_product":[],"pass":true}},"first_order_id":"4788","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> T16 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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","3",921,"NEW","A18-CT207371",2161,1226,0,0,"3","3",3678,3678,3678,"2020-03-10 15:50:40","0",null,null,null,"2020-01-06","2020-04-05","3 months contract. Storage rental $3700 paid by cash deposit on March 10, 2020. Storage deposit transferred from agreement A18-CT206867 to this agreement.\r\n","2020-01-06","28",0,null,0,"0","2","2020-03-10 15:50:40","2","2020-03-10 15:50:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,01480","C180921","PERSONAL","Mr","T6CMUvuyn65mo6INgFCWzA==","cxr02xsD1tXvJ4ihJHZKWw==","","4znSbYd2s1aZ81dZq578PUvuG6t5gn7Wvo046vo69wOr5+Yn\/UcwqGGNnSqQuRprN3f78Ab6nHhpSMoUNGAeNlkoMcu03jx6nUdtx5r4eL0=","vaRRqw3IbVZCu9ZmNJ74hQ==",null,"CKUOunaeCUaWfDSGC807sg==",null,1,"4788"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7371","899","2161.0","2161.00","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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-01-06","2020-04-05","899"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 15:50: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":["7371",921,"SETTLED","A18-I207699","2020-03-10 15:50:40","2020-01-06","2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7699","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7699","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7699","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7699"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 15:50: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":[921,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207347","2020-03-10 15:50:40",3678,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7347","DEPOSIT",null,"PAID","2020-03-10 15:50:40",0,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 15:50: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":["7347","INVOICE","7699","PAID","2020-03-10 15:50:40",3678,"2","2020-03-10 15:50:40","2","2020-03-10 15:50:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:02:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1579","master_room_id":"204","room_code":"A16-088"}],"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-088 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"K282024(2)","title":"Mr","lastname":"LEUNG","firstname":"Kwong Hung","companyname":"","email":"dogdogconstance@yahoo.com.hk","tel":"96585369","address":"Rm 2404, Block I, Kwong Wing Court, Aberdeen Center, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1579","room_code":"A16-088","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":3210,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":19686,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2309.00","warehousing_date":"2020-03-11","rent_from":"2020-03-11","rent_to":"2021-04-10","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% discount. $100 transportation fee claimed. Storage rental and deposit paid by EPS on Mar 10,2020. Smartcard and padlock provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"EPS","discount_deduct":2309,"order_total":21995,"final_order_total":19686,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,63602","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1445.00","deposit":"3210.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201531","PERSONAL","Mr","DYDvnYsK6vvFjmKo45HeLg==","yXKc2lCF323ApRADrjNaSg==","","gyZ4inZdH6kzjZtS7s5c5Q==","oLZv2N2v64y1VVKU802KdFDa7pp1MdgZrKicfsjK\/P0=","hmmrmOoHFxHO3VRHGvtvwq7fMtuYjJ5yQLgLGcNf9bIn1UmHcBiRUzFo69qMNRCJzkVXJjU74RTgkNTYf68Xkw==","+5llGv\/ZWYH1xXlnVNAa6w==",null,"oLZv2N2v64y1VVKU802KdFDa7pp1MdgZrKicfsjK\/P0=","wW31deq29HW0uFfVhLVQwA==","2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1531,"NEW","A16-CT207372",1605,1445,3210,0,"13","13",19686,21995,19686,"2020-03-10 16:07:56","0",null,null,null,"2020-03-11","2021-04-10","13 months contract. Special offer the 13th month free and 5% discount. $100 transportation fee claimed. Storage rental and deposit paid by EPS on Mar 10,2020. Smartcard and padlock provided on the same day.","2020-03-11","20",0,null,2309,"2309.00","2","2020-03-10 16:07:54","2","2020-03-10 16:07:54","BANKIN","","","","EPS","","","",null,0,"189,63602","C201531","PERSONAL","Mr","DYDvnYsK6vvFjmKo45HeLg==","yXKc2lCF323ApRADrjNaSg==","","hmmrmOoHFxHO3VRHGvtvwq7fMtuYjJ5yQLgLGcNf9bIn1UmHcBiRUzFo69qMNRCJzkVXJjU74RTgkNTYf68Xkw==","gyZ4inZdH6kzjZtS7s5c5Q==","oLZv2N2v64y1VVKU802KdFDa7pp1MdgZrKicfsjK\/P0=","+5llGv\/ZWYH1xXlnVNAa6w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7372","1579","1605.0","1605.00","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-11","2021-04-10","1579"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7372","A16-D205315","PAID",3210,0,"2021-04-10","2020-03-10 16:07:54","2020-03-10 16:07:54","2","2020-03-10 16:07:54","2","2020-03-10 16:07:54",1531]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7372",1531,"SETTLED","A16-I207700","2020-03-10 16:07:54","2020-03-11","2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,581,"MO","1",581,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7700","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16476,0,"7700"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1531,"BANKIN","","","","EPS","","","","PAID","P207348","2020-03-10 16:07:54",19686,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","DEPOSIT","5315","PAID","2020-03-10 16:07:54",3210,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","INVOICE","7700","PAID","2020-03-10 16:07:54",16476,"2","2020-03-10 16:07:54","2","2020-03-10 16:07:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:11:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:25:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:33:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 16:49:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 17:00:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 17:42:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-10 18:18:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****