{"created_at":"2020-05-18 10:10:00","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1033","master_room_id":"108","room_code":"A05-031"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-031 <\/td>\r\n\t\t\t\t\t	3X3X7 <\/td>\r\n\t\t\t\t\t	$1006.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y396135(2)","title":"Ms","lastname":"IP","firstname":"Ka Ping","companyname":"","email":"pingip5457@gmail.com","tel":"59850743","address":"Flat 1303, Pik Shan House, Shek Pai Wan Estate, Aberdeen, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1033","room_code":"A05-031","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":775,"deposit":1550,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2287,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"38.00","warehousing_date":"2020-05-19","rent_from":"2020-05-19","rent_to":"2020-06-18","delivery_service":"0","remark":"1 month contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 18, 2020. Smart card provided on May 18, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":38,"order_total":2325,"final_order_total":2287,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012398380","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:01","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":["C201585","PERSONAL","Ms","opViPjJB\/cnXbh7QfyIK6w==","BxzCT5OGas7BCbwmbXAF7w==","","xKj3kPLMpMt6yhvw4E8OSA==","WvL2ocHgvxJ9LzM2J6LLB5\/WS0\/XCXr9WN0bSQU2E8w=","rwIMu2gkd9xCqzckSeNBaWXv0BVGsbnqDyzzcjV5XoHxaqjSB2UWvleKraWZqRNT5agkgOP3IKpTSe0sHKIYnw==","oKSW0xqPeu1R4tWGorYS\/Q==",null,"WvL2ocHgvxJ9LzM2J6LLB5\/WS0\/XCXr9WN0bSQU2E8w=","XhEDImfCLfnwxNkrpxZX\/A==","2","2020-05-18 10:10:00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1585,"NEW","A05-CT207876",1006,775,1550,0,"1","1",2287,2325,2287,"2020-05-18 10:10:02","0",null,null,null,"2020-05-19","2020-06-18","1 month contract. Special offer 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on May 18, 2020. Smart card provided on May 18, 2020. ","2020-05-19","9",0,null,38,"38.00","2","2020-05-18 10:10:00","2","2020-05-18 10:10:00","EPS","","","","EPS","","","",null,0,"'0012398380","C201585","PERSONAL","Ms","opViPjJB\/cnXbh7QfyIK6w==","BxzCT5OGas7BCbwmbXAF7w==","","rwIMu2gkd9xCqzckSeNBaWXv0BVGsbnqDyzzcjV5XoHxaqjSB2UWvleKraWZqRNT5agkgOP3IKpTSe0sHKIYnw==","xKj3kPLMpMt6yhvw4E8OSA==","WvL2ocHgvxJ9LzM2J6LLB5\/WS0\/XCXr9WN0bSQU2E8w=","oKSW0xqPeu1R4tWGorYS\/Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7876","1033","1006.0","1006.00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-19","2020-06-18","1033"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 10:10:02","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":["7876","A05-D205415","PAID",1550,0,"2020-06-18","2020-05-18 10:10:00","2020-05-18 10:10:00","2","2020-05-18 10:10:00","2","2020-05-18 10:10:00",1585]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7876",1585,"SETTLED","A05-I208205","2020-05-18 10:10:00","2020-05-19","2","2020-05-18 10:10:00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8205","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,737,"MO","1",737,"2","2020-05-18 10:10:00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[737,0,"8205"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1585,"EPS","","","","EPS","","","","PAID","P207850","2020-05-18 10:10:00",2287,"2","2020-05-18 10:10:00","2","2020-05-18 10:10:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7850","DEPOSIT","5415","PAID","2020-05-18 10:10:00",1550,"2","2020-05-18 10:10:00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:10:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7850","INVOICE","8205","PAID","2020-05-18 10:10:00",737,"2","2020-05-18 10:10:00","2","2020-05-18 10:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:33:13","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["A05-153","OPEN","118","STORAGE","2","2020-05-18 10:33:13","1155"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:34:06","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["A05-154","OPEN","118","STORAGE","2","2020-05-18 10:34:06","1156"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39: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":"filter1=2&filter2=1057&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"1057","customer_code":"C181057","identity_type":"PERSONAL","identity_id":"D308847(3)","title":"Ms","lastname":"Lam ","firstname":"Shun Wai, Annie","companyname":"","email":"annielam2009@gmail.com","tel":"96813840","address":"Flat 5, 4\/F, Kong Fu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4106.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-16","renew_room_key":"0006005603","renew_remark":"3 months contract. Storage rental paid by Bank Transfer on March 21, 2020. Storage deposit transferred from agreement A05-CT196767 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207467, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"118","order_discount":[],"order_room":[{"room_id":"1156","room_code":"A05-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"4"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-16","rent_from":"2020-05-16","rent_to":"2020-06-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $8644 transferred from agreement A05-CT207467 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"4","branch_id":"1","company_id":"1","room_key":"\u20190006005603","order_product":[],"pass":true}},"first_order_id":"3553","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t	\n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-154 <\/td>\n\t\t\t\t\t 4X7X7 <\/td>\n\t\t\t\t\t $2161.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2161.00","deposit":"0.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","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","1057","NEW","A05-CT207877",2161,2161,0,0,"1","1",2161,2161,2161,"2020-05-18 10:39:31","0",null,null,null,"2020-05-16","2020-06-15","1 month contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $8644 transferred from agreement A05-CT207467 to this agreement. ","2020-05-16","28",0,null,0,"0","2","2020-05-18 10:39:31","2","2020-05-18 10:39:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"\u20190006005603","C181057","PERSONAL","Ms","1j\/EaXCwy81\/xtzbEcCIFg==","QW3H3bgt0C82y0s8QGTa0Q==","","f1Otee2exetSDY63KBCMB5p99mgzhZTcsXOUKcOm9HaGtL064AfZdfe5l6eIALO\/p8OTtANqNTg0DUdmmdQX\/I8owGh\/TPajPJqQ7N4t7i4=","g0N0c22b7twgi3MLXRIFsA==","M7r\/KEoRB4HilLKSFse6TNWqfcF7SJDkKhW++\/2WmZg=","TkzecISdNbJR\/TrRV20KnA==",null,1,"3553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","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":["7877","1156","2161.0","2161.00","2","2020-05-18 10:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-16","2020-06-15","1156"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 10:39:31","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":["7877","1057","SETTLED","A05-I208206","2020-05-18 10:39:31","2020-05-16","2","2020-05-18 10:39:31","2","2020-05-18 10:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8206","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-05-18 10:39:31","2","2020-05-18 10:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"8206"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 10:39:31","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":["1057","NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207851","2020-05-18 10:39:31",2161,"2","2020-05-18 10:39:31","2","2020-05-18 10:39:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","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":["7851","DEPOSIT",null,"PAID","2020-05-18 10:39:31",0,"2","2020-05-18 10:39:31","2","2020-05-18 10:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:39:31","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":["7851","INVOICE","8206","PAID","2020-05-18 10:39:31",2161,"2","2020-05-18 10:39:31","2","2020-05-18 10:39:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1057&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1103,"customer_code":"C181103","identity_type":"PERSONAL","identity_id":"z821439(6)","title":"Mr","lastname":"NG","firstname":"HING WAH","companyname":"","email":"cloud6286@yahoo.com.hk","tel":"63406783","address":"\u9999\u6e2f\u4ed4\u6f01\u5149\u6751\u6d77\u6e2f\u6a13306\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-17","renew_room_key":"12420775","renew_remark":"6 months contract. Storage rental paid by bank transfer on Dec 30,2019. Storage deposit $2180 transferred from agreement A05-CT183643 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196800, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1073","room_code":"A05-071","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2021-06-16","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. And 2 renewal gifts. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $2180 transferred from agreement A05-CT196800 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12420775","order_product":[],"pass":true}},"first_order_id":"3643","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-071 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","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",1103,"NEW","A05-CT207878",1090,981,0,0,"13","13",11772,12753,11772,"2020-05-18 10:52:33","0",null,null,null,"2020-05-17","2021-06-16","13 months contract. Special offer the 13th month free. And 2 renewal gifts. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $2180 transferred from agreement A05-CT196800 to this agreement.\r\n","2020-05-17","12",0,null,981,"981.00","2","2020-05-18 10:52:32","2","2020-05-18 10:52:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"12420775","C181103","PERSONAL","Mr","rmWpUwz501SsIjDtG3a\/uA==","yXKLXTtbNpECaRVTZxF\/Rw==","","bgQ3rHTQlnlWETsabtZaGitxR7Bx5zUMDKIu8NSQeXntXsTg8QVltc75Oe\/rxELE","v5odhu6gi\/jZbz5qGH26gg==","QwreDjC9DHEFhhUZTxfirfscdQE2HPZr0cZJlLU3A2g=","8FOX6xAprIl6Dd96Y2XL2w==",null,1,"3643"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","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":["7878","1073","1090.0","1090.00","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2021-06-16","1073"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 10:52:33","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":["7878",1103,"SETTLED","A05-I208207","2020-05-18 10:52:32","2020-05-17","2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8207","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8207"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 10:52:33","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":[1103,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207852","2020-05-18 10:52:32",11772,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","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":["7852","DEPOSIT",null,"PAID","2020-05-18 10:52:32",0,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 10:52:33","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":["7852","INVOICE","8207","PAID","2020-05-18 10:52:32",11772,"2","2020-05-18 10:52:32","2","2020-05-18 10:52:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06:55","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":"page=2","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-18","renew_room_key":"055,34812","renew_remark":"1 month contract. Storage rental paid by cheque on Apr 17,2020. Storage deposit transferred from agreement A12-CT207434 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207647, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"13","order_discount":[],"order_room":[{"room_id":"2","room_code":"A02","retail_price":"2058.0","discounted_price":"2058.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2020-06-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on May 18, 2020. Storage deposit transferred from agreement A12-CT207647 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> A02 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",18,"NEW","A12-CT207879",2058,1860,0,0,"1","1",1860,1860,1860,"2020-05-18 11:06:56","0",null,null,null,"2020-05-18","2020-06-17","1 month contract. Storage rental paid by cheque on May 18, 2020. Storage deposit transferred from agreement A12-CT207647 to this agreement.\r\n","2020-05-18","28",0,null,0,"0","2","2020-05-18 11:06:55","2","2020-05-18 11:06:55","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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":["7879","2","2058.0","2058.00","2","2020-05-18 11:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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-05-18","2020-06-17","2"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 11:06: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":["7879",18,"SETTLED","A12-I208208","2020-05-18 11:06:55","2020-05-18","2","2020-05-18 11:06:55","2","2020-05-18 11:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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":["8208","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-05-18 11:06:55","2","2020-05-18 11:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"8208"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 11:06: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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207853","2020-05-18 11:06:55",1860,"2","2020-05-18 11:06:55","2","2020-05-18 11:06:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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":["7853","DEPOSIT",null,"PAID","2020-05-18 11:06:55",0,"2","2020-05-18 11:06:55","2","2020-05-18 11:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:06: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":["7853","INVOICE","8208","PAID","2020-05-18 11:06:55",1860,"2","2020-05-18 11:06:55","2","2020-05-18 11:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"page=2&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-02","renew_room_key":"053,34812","renew_remark":"1 month contract. Storage rental paid by cheque on Apr 17, 2020. Storage deposit transferred from agreement A12-CT207433 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207648, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"141","room_code":"C17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-02","rent_from":"2020-05-02","rent_to":"2020-06-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on May 18, 2020. Storage deposit transferred from agreement A12-CT207648 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> C17 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",18,"NEW","A12-CT207880",1098,1038,0,0,"1","1",1038,1038,1038,"2020-05-18 11:11:06","0",null,null,null,"2020-05-02","2020-06-01","1 month contract. Storage rental paid by cheque on May 18, 2020. Storage deposit transferred from agreement A12-CT207648 to this agreement.\r\n","2020-05-02","16",0,null,0,"0","2","2020-05-18 11:11:05","2","2020-05-18 11:11:05","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7880","141","1098.0","1098.00","2","2020-05-18 11:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-02","2020-06-01","141"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7880",18,"SETTLED","A12-I208209","2020-05-18 11:11:05","2020-05-02","2","2020-05-18 11:11:05","2","2020-05-18 11:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8209","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-18 11:11:05","2","2020-05-18 11:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8209"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207854","2020-05-18 11:11:05",1038,"2","2020-05-18 11:11:05","2","2020-05-18 11:11:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7854","DEPOSIT",null,"PAID","2020-05-18 11:11:05",0,"2","2020-05-18 11:11:05","2","2020-05-18 11:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:11:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7854","INVOICE","8209","PAID","2020-05-18 11:11:05",1038,"2","2020-05-18 11:11:05","2","2020-05-18 11:11:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:20:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","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":"page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1141,"customer_code":"C181141","identity_type":"BUSINESS","identity_id":"provide later","title":"Mr","lastname":"Yu","firstname":"Tak Kei Ringo","companyname":"Bravo Creative Management Ltd.","email":"ringoyu@bcmhk.com","tel":"98319468","address":"Flat A, 15\/F, Vulcan House, 21-23 Leighton Road, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"2","renew_warehousing_date":"2020-04-08","renew_room_key":"0007310873","renew_remark":"2 months contract. Storage rental paid by bank transfer on March 2, 2020. Storage deposit transferred from agreement A05-CT196699 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207293, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1013","room_code":"A05-011","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-08","rent_from":"2020-04-08","rent_to":"2020-06-07","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on May 18, 2020. Storage deposit transferred from agreement A05-CT207293 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2580,"final_order_total":2580,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007310873","order_product":[],"pass":true}},"first_order_id":"4707","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-011 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1141,"NEW","A05-CT207881",1290,1290,0,0,"2","2",2580,2580,2580,"2020-05-18 11:22:22","0",null,null,null,"2020-04-08","2020-06-07","2 months contract. Storage rental paid by bank transfer on May 18, 2020. Storage deposit transferred from agreement A05-CT207293 to this agreement.\r\n","2020-04-08","16",0,null,0,"0","2","2020-05-18 11:22:22","2","2020-05-18 11:22:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007310873","C181141","BUSINESS","Mr","fPB5szRfhQDoFF8+NzJXtQ==","thtRZ5CDeQ9OOuodTdr1ng==","Bravo Creative Management Ltd.","zRpRHQsd21YbfDCyj7QmRR2rWUvgcz1ErepmgH\/IZuJV4UWK1YsDIzEgQ04zpuMx7hUgPpyvnTMu7YjPItiQRBRESa5DBBzR9k9gj2Xffyo=","2+bteiJtKwBy5oyidhRx8g==","cbLUhb9OxZTeK4XARdQo4RVP7SlgpymFj2VFLAjuUQg=",null,"ghkNgPwuN3BPyR+G706E0w==",1,"4707"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7881","1013","1290.0","1290.00","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-08","2020-06-07","1013"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7881",1141,"SETTLED","A05-I208210","2020-05-18 11:22:22","2020-04-08","2","2020-05-18 11:22:22","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8210","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-05-18 11:22:22","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8210","RENT","\u9810\u7e73\u79df\u91d1",2,1290,"MO","1",1290,"2","2020-05-18 11:22:22","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2580,0,"8210"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1141,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207855","2020-05-18 11:22:22",2580,"2","2020-05-18 11:22:22","2","2020-05-18 11:22:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7855","DEPOSIT",null,"PAID","2020-05-18 11:22:22",0,"2","2020-05-18 11:22:22","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:22:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7855","INVOICE","8210","PAID","2020-05-18 11:22:22",2580,"2","2020-05-18 11:22:22","2","2020-05-18 11:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:58:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":351,"customer_code":"C170351","identity_type":"PERSONAL","identity_id":"D001546(7)","title":"Mrs","lastname":"MAK YAM","firstname":"Po Ling Pauline","companyname":"","email":null,"tel":"91048984","address":"1105 Tin Fai House, Yue Fai Court, Aberdeen ","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-22","renew_room_key":"054,07636\/052,19263","renew_remark":"6 months contract. Storage rental paid by cheque on Nov 19, 2019. Storage deposit transferred from agreement A14-CT194890 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196437, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"765","room_code":"O41","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"764","room_code":"O40","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-11-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on May 18,2020. Storage deposit transferred from agreement A14-CT196437 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,07636\/052,19263","order_product":[],"pass":true}},"first_order_id":"3649","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> O41 <\/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> O40 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","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",351,"NEW","A14-CT207882",2196,1788,0,0,"6","6",10728,10728,10728,"2020-05-18 11:59:33","0",null,null,null,"2020-05-22","2020-11-21","6 months contract. Storage rental paid by cheque on May 18,2020. Storage deposit transferred from agreement A14-CT196437 to this agreement.","2020-05-22","32",0,null,0,"0","2","2020-05-18 11:59:33","2","2020-05-18 11:59:33","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,07636\/052,19263","C170351","PERSONAL","Mrs","D7Q6qjzz4yxUKiEh2tS2OQ==","WDve7t3kDtE+3Dqp\/f\/EkA==","","CyeAXJA5+dwLVTFglRVzeZAdCg2deiRbv0mA1yTISR0uyXomf0H6+NhnOW0SGfxl","HmleCcfCB\/Vx6uDs68C1ZA==",null,"K8xf3U+vLExnDdK6xp5bnQ==",null,1,"3649"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","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":["7882","765","1098.0","1098.00","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-22","2020-11-21","765"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 11:59:33","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":["7882","764","1098.0","1098.00","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-22","2020-11-21","764"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 11:59:33","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":["7882",351,"SETTLED","A14-I208211","2020-05-18 11:59:33","2020-05-22","2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"8211"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 11:59:33","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":[351,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207856","2020-05-18 11:59:33",10728,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","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":["7856","DEPOSIT",null,"PAID","2020-05-18 11:59:33",0,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 11:59:33","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":["7856","INVOICE","8211","PAID","2020-05-18 11:59:33",10728,"2","2020-05-18 11:59:33","2","2020-05-18 11:59:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:22: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":"page=2&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":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":584,"customer_code":"C170584","identity_type":"PERSONAL","identity_id":"A484996(8)","title":"Mr","lastname":"Leung","firstname":"Yuk Lun","companyname":"","email":null,"tel":"91054937","address":"Flat 403, 4\/F, Wah Hing House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-20","renew_room_key":"055,05313","renew_remark":"6 months contract. Storage rental paid by cash on Nov 22, 2019. Storage deposit transferred from agreement A14-CT195025 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196471, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"452","room_code":"J34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2020-11-19","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 18, 2020. Storage deposit transferred from agreement A14-CT196471 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,05313","order_product":[],"pass":true}},"first_order_id":"3639","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> J34 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","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",584,"NEW","A14-CT207883",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-18 12:23:00","0",null,null,null,"2020-05-20","2020-11-19","6 months contract. Storage rental paid by cash on May 18, 2020. Storage deposit transferred from agreement A14-CT196471 to this agreement.\r\n","2020-05-20","20",0,null,0,"0","2","2020-05-18 12:22:59","2","2020-05-18 12:22:59","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,05313","C170584","PERSONAL","Mr","3Hy9inFozmBHJhsTlEv3Ag==","xEf2h2aoyRQ71ZVgBH+9WQ==","","hLXsBVqRzh9w7QCehCBcj\/wsfLSL43DFfgA3jCtDIS\/p5a\/H3aCcle\/Ap4Wo9RdVU0dxQ2tlRANuZnXvMJTlWw==","zBcUT6MIEJHrVa\/ayGTf7A==",null,"LH7UUX\/9WSD3SYS9dqIE4A==",null,1,"3639"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","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":["7883","452","1528.0","1528.00","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-20","2020-11-19","452"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 12:23:00","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":["7883",584,"SETTLED","A14-I208212","2020-05-18 12:22:59","2020-05-20","2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8212","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8212"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 12:23:00","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":[584,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207857","2020-05-18 12:22:59",6834,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","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":["7857","DEPOSIT",null,"PAID","2020-05-18 12:22:59",0,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:00","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":["7857","INVOICE","8212","PAID","2020-05-18 12:22:59",6834,"2","2020-05-18 12:22:59","2","2020-05-18 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1541,"customer_code":"C201541","identity_type":"PERSONAL","identity_id":"R067540(6)","title":"Ms","lastname":"CHENG","firstname":"Oi Ying Andrea","companyname":"","email":"andrea@senreve.com","tel":"63834224","address":"10\/F, WeWork, 33 Lockhart Road, Wan Chai, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1768.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-23","renew_room_key":"191,03188","renew_remark":"1 month contract. Storage rental and deposit paid by bank transfer on April 22,2020.Storage deposit transferred from agreement A12-CT207460 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207704, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"379","room_code":"G20","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1768,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1768,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2020-06-22","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on May 15,2020.Storage deposit transferred from agreement A12-CT207704 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1768,"final_order_total":1768,"location_id":"1","branch_id":"1","company_id":"1","room_key":"191,03188","order_product":[],"pass":true}},"first_order_id":"7460","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> G20 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1768.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","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",1541,"NEW","A12-CT207884",1768,1768,0,0,"1","1",1768,1768,1768,"2020-05-18 12:23:25","0",null,null,null,"2020-05-23","2020-06-22","1 month contract. Storage rental and deposit paid by bank transfer on May 15,2020.Storage deposit transferred from agreement A12-CT207704 to this agreement.","2020-05-23","24",0,null,0,"0","2","2020-05-18 12:23:24","2","2020-05-18 12:23:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03188","C201541","PERSONAL","Ms","tC7uPunajh0MRBsyfcX7gw==","+DIqoIiVKYgoYtcxzTTCmw==","","eyxC82qUseKWnLp4mebzuglMoPDApORAHfh7k9cbwIPiP1NTghgf25md1+thXRh5","28+P2\/aXUQjCETOiwFwJGg==","ymnNl12u9uxxHzvQb5vAeAeyQ6RAYV6r6UCAdCjC10I=","6B+IEP7FH0F6giORvS3q+Q==",null,1,"7460"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","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":["7884","379","1768.0","1768.00","2","2020-05-18 12:23:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-23","2020-06-22","379"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 12:23:25","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":["7884",1541,"SETTLED","A12-I208213","2020-05-18 12:23:24","2020-05-23","2","2020-05-18 12:23:24","2","2020-05-18 12:23:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8213","RENT","\u9810\u7e73\u79df\u91d1",1,1768,"MO","1",1768,"2","2020-05-18 12:23:24","2","2020-05-18 12:23:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1768,0,"8213"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 12:23:25","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":[1541,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207858","2020-05-18 12:23:24",1768,"2","2020-05-18 12:23:24","2","2020-05-18 12:23:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","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":["7858","DEPOSIT",null,"PAID","2020-05-18 12:23:24",0,"2","2020-05-18 12:23:24","2","2020-05-18 12:23:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 12:23:25","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":["7858","INVOICE","8213","PAID","2020-05-18 12:23:24",1768,"2","2020-05-18 12:23:24","2","2020-05-18 12:23:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1267,"customer_code":"C191267","identity_type":"PERSONAL","identity_id":"D651948(3)","title":"Mr","lastname":"HO","firstname":"Fu Tak","companyname":"","email":"hofutak@gmail.com","tel":"90262951","address":"Flat 804, BLK M, Kornhill, Quarry Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1134.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-18","renew_room_key":"0005795993","renew_remark":"12 months contracts. Special offer 2 months free and $400 for change storage. Storage rental and deposit paid by EPS on May 11, 2019. Smartcard provided on May 11, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194953, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1260.0","renew_master_room_id":"181","order_discount":[],"order_room":[{"room_id":"1458","room_code":"C15-152","retail_price":"1260.0","discounted_price":"1260.00","location_id":"6"}],"roughly_size":"22.5","total_retail_price":1260,"total_discounted_price":1134,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13608,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2021-05-17","delivery_service":"0","remark":"12 months contracts. Storage rental paid by bank transfer on May 18,2020. Storage deposit $1260 transferred from agreement C15-CT194953 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13608,"final_order_total":13608,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005795993","order_product":[],"pass":true}},"first_order_id":4953,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-152 <\/td>\r\n\t\t\t\t\t 5X4.5X6.5 <\/td>\r\n\t\t\t\t\t $1260.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":"22.5","total_discounted_price":"1134.0","deposit":"0","total_retail_price":"1260.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1267,"NEW","C15-CT207885",1260,1134,0,0,"12","12",13608,13608,13608,"2020-05-18 13:09:14","0",null,null,null,"2020-05-18","2021-05-17","12 months contracts. Storage rental paid by bank transfer on May 18,2020. Storage deposit $1260 transferred from agreement C15-CT194953 to this agreement.","2020-05-18","22.5",0,null,0,"0","2","2020-05-18 13:09:14","2","2020-05-18 13:09:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005795993","C191267","PERSONAL","Mr","hrf74OM27DUPsJJUru68xw==","Zzv1eRCimQisUlUlw\/fpjg==","","j4PGnQQIBsivUF7FOiRVcvdR9yzYxHQDxPJEWYRVOtgo4FRar8E8JP8hsWEjf4\/QLDzzHnNBKdFnkyFwkwFiWQ==","ZCcZMvTjxRk2NnQuXoKN9Q==","NdDzt\/YvXBzrnwKGdhstzBa30RCugRGfpxO0M+SxagQ=","soE6NG7I5hlIIeBClBBOwg==",null,1,4953]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7885","1458","1260.0","1260.00","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-18","2021-05-17","1458"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7885",1267,"SETTLED","C15-I208214","2020-05-18 13:09:14","2020-05-18","2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",1,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",2,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",3,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",4,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",5,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",6,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",7,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",8,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",9,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",10,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",11,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214","RENT","\u9810\u7e73\u79df\u91d1",12,1134,"MO","1",1134,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13608,0,"8214"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1267,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207859","2020-05-18 13:09:14",13608,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7859","DEPOSIT",null,"PAID","2020-05-18 13:09:14",0,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 13:09:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7859","INVOICE","8214","PAID","2020-05-18 13:09:14",13608,"2","2020-05-18 13:09:14","2","2020-05-18 13:09:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"page=2&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":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1035,"customer_code":"C181035","identity_type":"PERSONAL","identity_id":"D241151(3)","title":"Mr","lastname":"Chan","firstname":"Chi Lai Kelvin","companyname":"","email":"k35846@gmail.com","tel":"98600482","address":"Flat G, 12\/F, Block 7, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-26","renew_room_key":"0005832997","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit $2580 transferred from agreement A05-CT183739 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196462, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1020","room_code":"A05-018","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"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-05-26","rent_from":"2020-05-26","rent_to":"2021-06-25","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 2 renewal gifts. Storage rental paid by bank transfer on May 18, 2020. Storage deposit $2580 transferred from agreement A05-CT196462 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005832997","order_product":[],"pass":true}},"first_order_id":"3739","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-018 <\/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-05-18 15:51:57","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",1035,"NEW","A05-CT207886",1290,1162,0,0,"13","13",13944,15106,13944,"2020-05-18 15:51:57","0",null,null,null,"2020-05-26","2021-06-25","13 months contract. Special offer the 13th month free and 2 renewal gifts. Storage rental paid by bank transfer on May 18, 2020. Storage deposit $2580 transferred from agreement A05-CT196462 to this agreement. \r\n","2020-05-26","16",0,null,1162,"1162.00","2","2020-05-18 15:51:57","2","2020-05-18 15:51:57","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005832997","C181035","PERSONAL","Mr","vtFJc3wFz4nnAqKGgYHI5w==","U9yoE9KqV1v8YlRkf7Q2yg==","","YsY46cPcUDrUpyCtwz9ZFWmU5XWp0fbNRcT0uJdMwScbkWbByeoim1jbMMfkKlMjUE3eUiUXByG3sC7I8IGCDA==","gR7lEzQKJLPyxGJQnA\/cuQ==","2xkOWAF44N8XeZR0m9MsOL24\/Vh88FHC6OYy4o3DjyU=","p3MQFQn\/x6kx0sJxpRNrjQ==",null,1,"3739"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","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":["7886","1020","1290.0","1290.00","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-26","2021-06-25","1020"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 15:51:57","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":["7886",1035,"SETTLED","A05-I208215","2020-05-18 15:51:57","2020-05-26","2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8215","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8215"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 15:51:57","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":[1035,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207860","2020-05-18 15:51:57",13944,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","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":["7860","DEPOSIT",null,"PAID","2020-05-18 15:51:57",0,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:51:57","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":["7860","INVOICE","8215","PAID","2020-05-18 15:51:57",13944,"2","2020-05-18 15:51:57","2","2020-05-18 15:51:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 15:59:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:01","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":454,"customer_code":"C170454","identity_type":"PERSONAL","identity_id":"A914369(9)","title":"Ms","lastname":"Lee","firstname":"So Ngor","companyname":"","email":null,"tel":"52125128","address":"Flat 2903,29\/F,Tung Hing Hse,Lei Tung Est,Ap Lei Chau,Hong Kong ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-16","renew_room_key":"052,21409","renew_remark":"6 months contract. Storage rental paid by cash on November 15, 2019. Storage deposit transferred from agreement A14-CT194956 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196403, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"596","room_code":"M07","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-16","rent_from":"2020-05-16","rent_to":"2020-11-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 18,2020. Storage deposit transferred from agreement A14-CT196403 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,21409","order_product":[],"pass":true}},"first_order_id":"3611","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> M07 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",454,"NEW","A14-CT207887",598,538,0,0,"6","6",3228,3228,3228,"2020-05-18 16:12:02","0",null,null,null,"2020-05-16","2020-11-15","6 months contract. Storage rental paid by cash on May 18,2020. Storage deposit transferred from agreement A14-CT196403 to this agreement.","2020-05-16","12",0,null,0,"0","2","2020-05-18 16:12:01","2","2020-05-18 16:12:01","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,21409","C170454","PERSONAL","Ms","4I9Ho\/CYp0XRqSDUPoIrdQ==","kiriEIqhcx866RNZiMXdKQ==","","amES1vZiVrt9V6KWzRYS0JHr\/lO2HNvTD2TqKjVzvHgaEMvq\/3UMzbrGhX+h8rNxL9KKS9px0GaMywnh2qotkFBsXqDu1q6i1YOyWzfsLC0=","mgimlQ5WBwkpvOIWS7cpuQ==",null,"\/STHpl5zn2\/QZA61EtoJ6Q==",null,1,"3611"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7887","596","598.0","598.00","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-16","2020-11-15","596"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887",454,"SETTLED","A14-I208216","2020-05-18 16:12:01","2020-05-16","2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8216","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8216"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[454,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207861","2020-05-18 16:12:01",3228,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7861","DEPOSIT",null,"PAID","2020-05-18 16:12:01",0,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7861","INVOICE","8216","PAID","2020-05-18 16:12:01",3228,"2","2020-05-18 16:12:01","2","2020-05-18 16:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 16:44:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45:42","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=394&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"64","master_room_id":"10","room_code":"B12"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B12 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"11719733-000-02-19-5","title":"Ms","lastname":"Lai","firstname":"Wing Yee, Eva","companyname":"Leo Engineering Limited","email":"leoengltd@gmail.com","tel":"28577258","address":"Flat B, 17\/F, Block 2, Kingley Industrial Building, 33 Yip Kan Street, Wong Chuk Hang, Hong Kong","pass":true,"customer_id":"1242","customer_code":"C191242","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"64","room_code":"B12","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":3056,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3056.00","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2020-06-22","delivery_service":"0","remark":"1 month contract. Change unit from B05 to B12. Storage deposit $3056 transferred from agreement A12-CT207246 to this agreement. Storage rental paid by bank transfer on May 18, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3056,"order_total":4584,"final_order_total":1528,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 29074","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1528.00","deposit":"3056.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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` = ?","parameters":["1","1","1","1242","NEW","A12-CT207888",1528,1528,3056,0,"1","1",1528,4584,1528,"2020-05-18 17:45:43","0",null,null,null,"2020-05-23","2020-06-22","1 month contract. Change unit from B05 to B12. Storage deposit $3056 transferred from agreement A12-CT207246 to this agreement. Storage rental paid by bank transfer on May 18, 2020. ","2020-05-23","20",0,null,3056,"3056.00","2","2020-05-18 17:45:42","2","2020-05-18 17:45:42","BANKIN","","","","BANKIN","","","",null,0,"189, 29074","C191242","BUSINESS","Ms","Vt1s1tKyVHGE6ijWGp3g+w==","lzx0GiXnrd0waIhp6oozpQ==","Leo Engineering Limited","V+9pyaXSanw3cB\/uChDsBTU8VHLSHKXXirjbf4HhHeq9AoCbEpifZIM2PfmHZywVHfLZTWCD1znFfMbte52A1RhZSEU+HET7Az2teqxNOuRGZkraXDsV9xeBIB00Zu2rVMXsYNEgpgQC\/e2XnwBFGg==","LmRjdENAVEeS\/ql+Q5bRgw==","Xqh5H+LlZ+ZbGgv+\/6hg8Kl\/yJkr2MjdyVAG\/2Pn7H4=",null,"T4TaIH0rG3Elgf1srlSVcOW0IsKlbN0iAi9GLAKqHkc="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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":["7888","64","1528.0","1528.00","2","2020-05-18 17:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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-05-23","2020-06-22","64"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 17:45:43","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":["7888","A12-D205416","PAID",3056,0,"2020-06-22","2020-05-18 17:45:42","2020-05-18 17:45:42","2","2020-05-18 17:45:42","2","2020-05-18 17:45:42","1242"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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":["7888","1242","SETTLED","A12-I208217","2020-05-18 17:45:42","2020-05-23","2","2020-05-18 17:45:42","2","2020-05-18 17:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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":["8217","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-18 17:45:42","2","2020-05-18 17:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"8217"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 17:45: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":["1242","BANKIN","","","","BANKIN","","","","PAID","P207862","2020-05-18 17:45:42",3056,"2","2020-05-18 17:45:42","2","2020-05-18 17:45:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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":["7862","DEPOSIT","5416","PAID","2020-05-18 17:45:42",3056,"2","2020-05-18 17:45:42","2","2020-05-18 17:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:45: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":["7862","INVOICE","8217","PAID","2020-05-18 17:45:42",0,"2","2020-05-18 17:45:42","2","2020-05-18 17:45:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48: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=394&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"64","master_room_id":"10","room_code":"B12"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1276,"customer_code":"C191276","identity_type":"BUSINESS","identity_id":"67226140-002-02-19-5","title":"Ms","lastname":"Kwok","firstname":"Wancie","companyname":"Happy Concepts Asia Limited","email":"wancie@happy-concepts.com","tel":"92420692","address":"Room 2107, 21\/F, Fullagar Ind Building, 234 Aberdeen Main Road, Aberdeen, HK","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":"1","renew_warehousing_date":"2020-04-27","renew_room_key":"076,47844","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 10, 2020. Storage deposit $4322 transferred form agreement A16-CT207520 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207612, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"206","order_discount":[],"order_room":[{"room_id":"1645","room_code":"A16-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-27","rent_from":"2020-04-27","rent_to":"2020-05-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207612 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,47844","order_product":[],"pass":true}},"first_order_id":"5067","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> A16-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/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":"2161.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1276,"NEW","A16-CT207889",2161,2161,0,0,"1","1",2161,2161,2161,"2020-05-18 17:48:46","0",null,null,null,"2020-04-27","2020-05-26","1 month contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207612 to this agreement. \r\n","2020-04-27","28",0,null,0,"0","2","2020-05-18 17:48:46","2","2020-05-18 17:48:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47844","C191276","BUSINESS","Ms","UnAuVv7vF8jhvFzl3xSCmg==","+pNULpsInm3siHASV0hIrg==","Happy Concepts Asia Limited","Vz2ejyARH5zcH5e4QlFSq51bZp23xF3kJ5RJpCNl57lAk8+AWULPwqnFcIQcG5ZBdUxERR9syaCIcEtZgd+HqAaztaF6lZ3cM+VjkllU2B0=","Gfho0rh19G9JYZxq3cLhUw==","YWYp2e5RTnHURnlliiVCoZfRQjqOlQ4Jschx6rAjv1w=",null,"emH+RX7ttsZFOmRnXIxwP9GHFJD2VTz2ibaI3AjX2ZU=",1,"5067"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7889","1645","2161.0","2161.00","2","2020-05-18 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2020-05-26","1645"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7889",1276,"SETTLED","A16-I208218","2020-05-18 17:48:46","2020-04-27","2","2020-05-18 17:48:46","2","2020-05-18 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8218","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-05-18 17:48:46","2","2020-05-18 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"8218"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1276,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207863","2020-05-18 17:48:46",2161,"2","2020-05-18 17:48:46","2","2020-05-18 17:48:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7863","DEPOSIT",null,"PAID","2020-05-18 17:48:46",0,"2","2020-05-18 17:48:46","2","2020-05-18 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 17:48:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7863","INVOICE","8218","PAID","2020-05-18 17:48:46",2161,"2","2020-05-18 17:48:46","2","2020-05-18 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:18:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:18","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":"","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> WC-32 <\/td>\r\n\t\t\t\t\t 5X7.5X8 <\/td>\r\n\t\t\t\t\t $3838.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":"0","identity_type":"PERSONAL","identity_id":"Z087494(A)","title":"Mr","lastname":"HO","firstname":"Chung Tak","companyname":"","email":"sspd.aho@gmail.com","tel":"98426238","address":"House 7, Royal Crest, 68 Pat Heung Road, Yuen Long","pass":true,"customer_id":"1581","customer_code":"C201581","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1725","room_code":"WC-32","retail_price":"3838.0","discounted_price":"3838.00","location_id":"8"}],"roughly_size":"37.5","total_retail_price":3838,"total_discounted_price":2937,"deposit":6526,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":20236,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3912.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by EPS on May 14, 2020 and May 18, 2020. Access card and padlock provided on May 14, 2020. ","paymethod":"UNPAID","paymethod2":"UNPAID","discount_deduct":3912,"order_total":24148,"final_order_total":20236,"location_id":"8","branch_id":"1","company_id":"1","room_key":"189, 28768","order_product":[],"pass":true}},"roughly_size":"37.5","total_discounted_price":"2937.00","deposit":"6526.00","total_retail_price":"3838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","8","1581","NEW","WC-CT207890",3838,2937,6526,0,"6","6",20236,24148,20236,"2020-05-18 18:29:19","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental and deposit paid by EPS on May 14, 2020 and May 18, 2020. Access card and padlock provided on May 14, 2020. ","2020-06-01","37.5",0,null,3912,"3912.00","2","2020-05-18 18:29:18","2","2020-05-18 18:29:18","UNPAID","","","","UNPAID","","","",null,0,"189, 28768","C201581","PERSONAL","Mr","A6RIF+RBo5M9aDs5qRVB0g==","Zzv1eRCimQisUlUlw\/fpjg==","","8U2H3JzwKSp7CZrd6vxU9No2Ev19TB6Zd2P8+J4lkeW60r2A62EXvo+OLqu6jra0Sv0W9tEFtYCBm8qffkr6BA==","\/Wqzp\/4VdDO8aAQmmcUWCw==","1IddmdWmHHB+jh9UbRVdVfSka8uh2IDc0\/aKcDHrCkk=","heVoSg4mQyhUFI\/6IXahng==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7890","1725","3838.0","3838.00","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","1725"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-18 18:29:19","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":["7890","WC-D205417","NEW",6526,6526,"2020-11-30","2020-05-18 18:29:18","2020-05-18 18:29:18","2","2020-05-18 18:29:18","2","2020-05-18 18:29:18","1581"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","1581","NEW","WC-I208219","2020-05-18 18:29:18","2020-06-01","2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1962,"MO","1",1962,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u9810\u7e73\u79df\u91d1",3,2937,"MO","1",2937,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u9810\u7e73\u79df\u91d1",4,2937,"MO","1",2937,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u9810\u7e73\u79df\u91d1",5,2937,"MO","1",2937,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8219","RENT","\u9810\u7e73\u79df\u91d1",6,2937,"MO","1",2937,"2","2020-05-18 18:29:18","2","2020-05-18 18:29:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-18 18:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13710,9798,"8219"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-18 18:36:31","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","189, 28768","6 months contract. Storage rental and deposit paid by EPS on May 14, 2020. Access card and padlock provided on May 13, 2020. ","2020-05-18 18:36:31","2","Zzv1eRCimQisUlUlw\/fpjg==","A6RIF+RBo5M9aDs5qRVB0g==","1IddmdWmHHB+jh9UbRVdVfSka8uh2IDc0\/aKcDHrCkk=","\/Wqzp\/4VdDO8aAQmmcUWCw==","8U2H3JzwKSp7CZrd6vxU9No2Ev19TB6Zd2P8+J4lkeW60r2A62EXvo+OLqu6jra0Sv0W9tEFtYCBm8qffkr6BA==",7849]},"data_before":[],"data_after":[],"step":1} *****