{"created_at":"2020-01-29 10:04:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:05:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":717,"customer_code":"C180717","identity_type":"PERSONAL","identity_id":"Y323150(8)","title":"Mr","lastname":"Amerine","firstname":"Julian Steven Anthony","companyname":"","email":"julian.amerine@gmail.com","tel":"97302001","address":"Flat 503, Wah Oi House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-14","renew_room_key":"055,16508","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 27, 2019. Storage deposit transferred from agreement A18-CT196236 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196530, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"904","room_code":"U05","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":3210,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-02-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A18-CT196530 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3210,"final_order_total":3210,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,16508","order_product":[],"pass":true}},"first_order_id":"4839","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>
U05 <\/td>\r\n\t\t\t\t\t	4X5X7 <\/td>\r\n\t\t\t\t\t	$1605.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1605.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",717,"NEW","A18-CT207049",1605,1605,0,0,"2","2",3210,3210,3210,"2020-01-29 10:16:13","0",null,null,null,"2019-12-14","2020-02-13","1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A18-CT196530 to this agreement.","2019-12-14","20",0,null,0,"0","2","2020-01-29 10:16:12","2","2020-01-29 10:16:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16508","C180717","PERSONAL","Mr","ilVMtNKmhMv6VE7c5KYxeztG+MwYykSvCMt0zdIzHQ8=","jMvdnb6vnm7OQ3LZeY9TvA==","","tbf9qMYQ0X2kmdqBrxFeo3U2\/AVNuE51tDZAfcqBDrxcDLMrKjPy\/OI6UJNDPcMlekQpWPiGcb3Vf3oPzlvW8g==","mgiBsvordu5SgovUygNEdQ==","oplb81J2vLHxZ4GCh7eLLYvnbYcLrPelLzmcVjcZCTA=","o+ttpCoGmWwr+zclHXAYFQ==",null,1,"4839"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7049","904","1605.0","1605.00","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-14","2020-02-13","904"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7049",717,"SETTLED","A18-I207377","2020-01-29 10:16:12","2019-12-14","2","2020-01-29 10:16:12","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7377","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-01-29 10:16:12","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7377","RENT","\u9810\u7e73\u79df\u91d1",2,1605,"MO","1",1605,"2","2020-01-29 10:16:12","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3210,0,"7377"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[717,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207026","2020-01-29 10:16:12",3210,"2","2020-01-29 10:16:12","2","2020-01-29 10:16:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7026","DEPOSIT",null,"PAID","2020-01-29 10:16:12",0,"2","2020-01-29 10:16:12","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:16:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7026","INVOICE","7377","PAID","2020-01-29 10:16:12",3210,"2","2020-01-29 10:16:12","2","2020-01-29 10:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:20:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 10:38:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:03","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":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-25","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 24, 2019. Storage deposit transferred from agreement A14-CT196750 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196776, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"449","room_code":"J31","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"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":"0","warehousing_date":"2020-01-25","rent_from":"2020-01-25","rent_to":"2020-02-24","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 26, 2020. Storage deposit transferred from agreement A14-CT196776 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4833","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> J31 <\/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\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":"20","total_discounted_price":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT207050",1528,1528,0,0,"1","1",1528,1528,1528,"2020-01-29 11:05:04","0",null,null,null,"2020-01-25","2020-02-24","1 month contract. Storage rental paid by bank transfer on January 26, 2020. Storage deposit transferred from agreement A14-CT196776 to this agreement.","2020-01-25","20",0,null,0,"0","2","2020-01-29 11:05:03","2","2020-01-29 11:05:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4833"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","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":["7050","449","1528.0","1528.00","2","2020-01-29 11:05:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2020-02-24","449"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 11:05:04","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":["7050",423,"SETTLED","A14-I207378","2020-01-29 11:05:03","2020-01-25","2","2020-01-29 11:05:03","2","2020-01-29 11:05:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","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":["7378","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-01-29 11:05:03","2","2020-01-29 11:05:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"7378"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 11:05:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207027","2020-01-29 11:05:03",1528,"2","2020-01-29 11:05:03","2","2020-01-29 11:05:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","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":["7027","DEPOSIT",null,"PAID","2020-01-29 11:05:03",0,"2","2020-01-29 11:05:03","2","2020-01-29 11:05:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:05:04","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":["7027","INVOICE","7378","PAID","2020-01-29 11:05:03",1528,"2","2020-01-29 11:05:03","2","2020-01-29 11:05:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":773,"customer_code":"C180773","identity_type":"PERSONAL","identity_id":"D373874(5)","title":"Ms","lastname":"Tung","firstname":"Wing Man Leon","companyname":"","email":"leontung3316@gmail.com","tel":"94519119","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u8302\u6a133316\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-12","renew_room_key":"055,48999","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 8, 2019. Storage deposit transferred from agreement A12-CT194321 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195693, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"176","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"176","room_code":"C52","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2020-08-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT195693 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6636,"final_order_total":6636,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,48999","order_product":[],"pass":true}},"first_order_id":"4321","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> C52 <\/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":"1106.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",773,"NEW","A12-CT207051",1098,1106,0,0,"6","6",6636,6636,6636,"2020-01-29 11:07:49","0",null,null,null,"2020-02-12","2020-08-11","6 months contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT195693 to this agreement.","2020-02-12","16",0,null,0,"0","2","2020-01-29 11:07:49","2","2020-01-29 11:07:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,48999","C180773","PERSONAL","Ms","nmwyYN7qyIuDF3uEG2nb+Q==","INIqO3p6N\/stXk+6gk8Omw==","","JP4Rs\/ygk7B5+4qY1O\/77r+Pkok3QgKRdcK1ujWYUCDF7Hm6br4NOIzZzbzk9QmS","Usn4HJwcx8OnBBfEeBjoig==","\/ak17E8PQ7Xm\/ov3TGy\/WQpItNrB0\/xsvpFV74jhn6I=","BcyXhXGePJg4Pz0Q8zP\/Uw==",null,1,"4321"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7051","72","8","176","%","9.93",109.0314,"2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7051","176","1098.0",989,"2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-12","2020-08-11","176"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7051",773,"SETTLED","A12-I207379","2020-01-29 11:07:49","2020-02-12","2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",1,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",2,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7379","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6636,0,"7379"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[773,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207028","2020-01-29 11:07:49",6636,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7028","DEPOSIT",null,"PAID","2020-01-29 11:07:49",0,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:07:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7028","INVOICE","7379","PAID","2020-01-29 11:07:49",6636,"2","2020-01-29 11:07:49","2","2020-01-29 11:07:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":826,"customer_code":"C180826","identity_type":"PERSONAL","identity_id":"V120085(2)","title":"Ms","lastname":"Wong","firstname":"Lai Wing","companyname":"","email":"aslinnlaiwing@gmail.com","tel":"60823501","address":"Flat B, 23\/F, Yee Wan Court, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-21","renew_room_key":"052,37309","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196507 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207046, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"207","room_code":"D11","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-21","rent_from":"2020-01-21","rent_to":"2020-02-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 26, 2020. Storage deposit transferred from agreement A12-CT207046 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,37309","order_product":[],"pass":true}},"first_order_id":"4840","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> D11 <\/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> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",826,"NEW","A12-CT207052",598,598,0,0,"1","1",598,598,598,"2020-01-29 11:20:39","0",null,null,null,"2020-01-21","2020-02-20","1 month contract. Storage rental paid by bank transfer on January 26, 2020. Storage deposit transferred from agreement A12-CT207046 to this agreement.","2020-01-21","12",0,null,0,"0","2","2020-01-29 11:20:38","2","2020-01-29 11:20:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,37309","C180826","PERSONAL","Ms","AVQEhVbkdf0QwgZhPqTuvQ==","hULSwM2MvFtpeV9\/z+er8Q==","","VYTecHlXsAq2HU\/SK2vg0HE0ESjbB0AIG1TtdkNrHvzSOFADaqlQfFPEOwNTSSdXg5YSZtYVVGLVGFZuRQfF9AxsFxu92jPjM0q+fUqGSyI=","M\/mMkpABptC23N0qOMtMOA==","I+DcTUTCSlvqwNtqcfOhWkdyXo7XLnfkUFX2VHxYh3c=","d\/8HRqfi7sBcCF03ucfekg==",null,1,"4840"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7052","207","598.0","598.00","2","2020-01-29 11:20:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-21","2020-02-20","207"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7052",826,"SETTLED","A12-I207380","2020-01-29 11:20:38","2020-01-21","2","2020-01-29 11:20:38","2","2020-01-29 11:20:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7380","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-29 11:20:38","2","2020-01-29 11:20:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7380"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[826,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207029","2020-01-29 11:20:38",598,"2","2020-01-29 11:20:38","2","2020-01-29 11:20:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7029","DEPOSIT",null,"PAID","2020-01-29 11:20:38",0,"2","2020-01-29 11:20:38","2","2020-01-29 11:20:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:20:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7029","INVOICE","7380","PAID","2020-01-29 11:20:38",598,"2","2020-01-29 11:20:38","2","2020-01-29 11:20:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:32:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:32:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:32:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-09","renew_room_key":"052,49830,076,49433","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT196655 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206914, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"602","room_code":"M13","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-09","rent_from":"2020-02-09","rent_to":"2020-03-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A14-CT206914 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,49830,076,49433","order_product":[],"pass":true}},"first_order_id":"4958","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M13 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",57,"NEW","A14-CT207053",598,598,0,0,"1","1",598,598,598,"2020-01-29 11:35:50","0",null,null,null,"2020-02-09","2020-03-08","1 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A14-CT206914 to this agreement.\r\n","2020-02-09","12",0,null,0,"0","2","2020-01-29 11:35:50","2","2020-01-29 11:35:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830,076,49433","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4958"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","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":["7053","602","598.0","598.00","2","2020-01-29 11:35:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-09","2020-03-08","602"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 11:35:50","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":["7053",57,"SETTLED","A14-I207381","2020-01-29 11:35:50","2020-02-09","2","2020-01-29 11:35:50","2","2020-01-29 11:35:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","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":["7381","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-29 11:35:50","2","2020-01-29 11:35:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7381"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 11:35:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207030","2020-01-29 11:35:50",598,"2","2020-01-29 11:35:50","2","2020-01-29 11:35:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","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":["7030","DEPOSIT",null,"PAID","2020-01-29 11:35:50",0,"2","2020-01-29 11:35:50","2","2020-01-29 11:35:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:35:50","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":["7030","INVOICE","7381","PAID","2020-01-29 11:35:50",598,"2","2020-01-29 11:35:50","2","2020-01-29 11:35:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=10&filter3=undefined&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"64","master_room_id":"10","room_code":"B12"}],"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> M36 <\/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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit transferred from agreement A14-CT196624 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207045, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-24","rent_from":"2020-01-24","rent_to":"2020-02-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A14-CT207045 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","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",469,"NEW","A14-CT207054",598,598,0,0,"1","1",598,598,598,"2020-01-29 11:51:29","0",null,null,null,"2020-01-24","2020-02-23","1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A14-CT207045 to this agreement.","2020-01-24","12",0,null,0,"0","2","2020-01-29 11:51:29","2","2020-01-29 11:51:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","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":["7054","625","598.0","598.00","2","2020-01-29 11:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-24","2020-02-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 11:51:29","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":["7054",469,"SETTLED","A14-I207382","2020-01-29 11:51:29","2020-01-24","2","2020-01-29 11:51:29","2","2020-01-29 11:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","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":["7382","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-29 11:51:29","2","2020-01-29 11:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7382"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 11:51:29","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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207031","2020-01-29 11:51:29",598,"2","2020-01-29 11:51:29","2","2020-01-29 11:51:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","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":["7031","DEPOSIT",null,"PAID","2020-01-29 11:51:29",0,"2","2020-01-29 11:51:29","2","2020-01-29 11:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:51:29","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":["7031","INVOICE","7382","PAID","2020-01-29 11:51:29",598,"2","2020-01-29 11:51:29","2","2020-01-29 11:51:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:56:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:57:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:57:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:57:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 11:58:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 12:05:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:14:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=10&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"64","master_room_id":"10","room_code":"B12"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":744,"customer_code":"C180744","identity_type":"PERSONAL","identity_id":"P048772(8)","title":"Ms","lastname":"Ho","firstname":"Mo Ching Cathy","companyname":"","email":"mchooo@gmail.com","tel":"93554406","address":"Flat C, 33\/F, Bayshore Apartment, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"781.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-27","renew_room_key":"055,17315","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 28, 2019. Storage deposit transferred from agreement A18-CT194189 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195572, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"928","room_code":"V02(\u670d\u88dd\u5009)","retail_price":"867.0","discounted_price":"867.00","location_id":"3"}],"roughly_size":"7.2","total_retail_price":867,"total_discounted_price":867,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":867,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-02-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A18-CT195572 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":867,"final_order_total":867,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,17315","order_product":[],"pass":true}},"first_order_id":"4189","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> V02(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 3X2.4X7 <\/td>\r\n\t\t\t\t\t $867.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":"7.2","total_discounted_price":"867.00","deposit":"0.00","total_retail_price":"867.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",744,"NEW","A18-CT207055",867,867,0,0,"1","1",867,867,867,"2020-01-29 13:19:51","0",null,null,null,"2020-01-27","2020-02-26","1 month contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A18-CT195572 to this agreement.\r\n","2020-01-27","7.2",0,null,0,"0","2","2020-01-29 13:19:51","2","2020-01-29 13:19:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,17315","C180744","PERSONAL","Ms","EUjkCpsubVvF1qfSw9fseg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","t3z\/tBJVx9zUBsPV2QLEKP\/AqBedWM1pqHTyFCmhZMxE9j81xPq6zAWG2opPZD62551Q3nqkNQ4SQQVLAi\/ebQ==","nLgH3bybWamCUHRAkIxQVw==","Uhq9I4m8wi2lpFRkgjzbiBcMCEEf9\/MkY3ZKL8CyO+Q=","wH9Lv4oBE\/XdyEdxYi0AIQ==",null,1,"4189"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7055","928","867.0","867.00","2","2020-01-29 13:19:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-27","2020-02-26","928"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7055",744,"SETTLED","A18-I207383","2020-01-29 13:19:51","2020-01-27","2","2020-01-29 13:19:51","2","2020-01-29 13:19:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7383","RENT","\u9810\u7e73\u79df\u91d1",1,867,"MO","1",867,"2","2020-01-29 13:19:51","2","2020-01-29 13:19:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[867,0,"7383"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[744,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207032","2020-01-29 13:19:51",867,"2","2020-01-29 13:19:51","2","2020-01-29 13:19:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7032","DEPOSIT",null,"PAID","2020-01-29 13:19:51",0,"2","2020-01-29 13:19:51","2","2020-01-29 13:19:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 13:19:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7032","INVOICE","7383","PAID","2020-01-29 13:19:51",867,"2","2020-01-29 13:19:51","2","2020-01-29 13:19:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:26:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":762,"customer_code":"C180762","identity_type":"PERSONAL","identity_id":"D395480(4)","title":"Ms","lastname":"Leung","firstname":"Yin Kwan","companyname":"","email":"kittyykl@yahoo.com.hk","tel":"90389997","address":"Flat 6, 25\/F, Hoi Wu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2275.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-11","renew_room_key":"055,60579,052,28880","renew_remark":"12 months contract. Storage rental paid by bank transfer on January 30, 2019. Storage deposit transferred from agreement \tA12-CT182809 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194310, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"9","order_discount":[{"master_room_discount_id":"93","master_room_id":"9","discount_type":"%","price":"2528.00","disocunted_price":"2099.80","discount":"16.94","monthly_deduct":428.2432,"room_id":"95","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"95","room_code":"B43","retail_price":"2528.0","discounted_price":2099.8,"location_id":"1"}],"roughly_size":"35","total_retail_price":2528,"total_discounted_price":2275,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":27300,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2021-02-10","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":27300,"final_order_total":27300,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,60579,052,28880","order_product":[],"pass":true}},"first_order_id":4310,"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> B43 <\/td>\r\n\t\t\t\t\t 5X7X8 <\/td>\r\n\t\t\t\t\t $2528.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":"35","total_discounted_price":"2275.0","deposit":"0","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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",762,"NEW","A12-CT207056",2528,2275,0,0,"12","12",27300,27300,27300,"2020-01-29 14:39:42","0",null,null,null,"2020-02-11","2021-02-10","12 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n","2020-02-11","35",0,null,0,"0","2","2020-01-29 14:39:42","2","2020-01-29 14:39:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,60579,052,28880","C180762","PERSONAL","Ms","ssTBnR3AFy3Uau4Z+eR04w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=","5840EFb2ImEI9pAVgEm9XA==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","VciKXQMV8Uq23+OUQSYSLQ==",null,1,4310]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7056","93","9","95","%","16.94",428.2432,"2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7056","95","2528.0",2099.8,"2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-11","2021-02-10","95"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 14:39:42","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":["7056",762,"SETTLED","A12-I207384","2020-01-29 14:39:42","2020-02-11","2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",1,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",2,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",3,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",4,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",5,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",6,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",7,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",8,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",9,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",10,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",11,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7384","RENT","\u9810\u7e73\u79df\u91d1",12,2275,"MO","1",2275,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27300,0,"7384"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 14:39:42","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":[762,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207033","2020-01-29 14:39:42",27300,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7033","DEPOSIT",null,"PAID","2020-01-29 14:39:42",0,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 14:39:42","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":["7033","INVOICE","7384","PAID","2020-01-29 14:39:42",27300,"2","2020-01-29 14:39:42","2","2020-01-29 14:39:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:08:28","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","055,60579,052,28880","12 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n","2020-01-29 15:08:28","2","xEf2h2aoyRQ71ZVgBH+9WQ==","ssTBnR3AFy3Uau4Z+eR04w==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","5840EFb2ImEI9pAVgEm9XA==","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=",7056]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10: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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":762,"customer_code":"C180762","identity_type":"PERSONAL","identity_id":"D395480(4)","title":"Ms","lastname":"Leung","firstname":"Yin Kwan","companyname":"","email":"kittyykl@yahoo.com.hk","tel":"90389997","address":"Flat 6, 25\/F, Hoi Wu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2275.0","renew_rent_month":"12","renew_warehousing_date":"2021-02-11","renew_room_key":"055,60579,052,28880","renew_remark":"12 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207056, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"9","order_discount":[],"order_room":[{"room_id":"95","room_code":"B43","retail_price":"2528.0","discounted_price":"2528.00","location_id":"1"}],"roughly_size":"35","total_retail_price":2528,"total_discounted_price":2275,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":27300,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2275","warehousing_date":"2021-02-11","rent_from":"2021-02-11","rent_to":"2022-03-10","delivery_service":"0","remark":"13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT207056 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2275,"order_total":29575,"final_order_total":27300,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,60579,052,28880","order_product":[],"pass":true}},"first_order_id":"4310","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> B43 <\/td>\r\n\t\t\t\t\t 5X7X8 <\/td>\r\n\t\t\t\t\t $2528.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":"35","total_discounted_price":"2275.00","deposit":"0","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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",762,"NEW","A12-CT207057",2528,2275,0,0,"13","13",27300,29575,27300,"2020-01-29 15:10:55","0",null,null,null,"2021-02-11","2022-03-10","13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT207056 to this agreement.\r\n\r\n","2021-02-11","35",0,null,2275,"2275","2","2020-01-29 15:10:55","2","2020-01-29 15:10:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,60579,052,28880","C180762","PERSONAL","Ms","ssTBnR3AFy3Uau4Z+eR04w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=","5840EFb2ImEI9pAVgEm9XA==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","VciKXQMV8Uq23+OUQSYSLQ==",null,1,"4310"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7057","95","2528.0","2528.00","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["2021-02-11","2022-03-10","95"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 15:10:55","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":["7057",762,"SETTLED","A12-I207385","2020-01-29 15:10:55","2021-02-11","2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",3,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",4,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",5,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",6,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",7,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",8,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",9,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",10,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",11,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",12,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7385","RENT","\u9810\u7e73\u79df\u91d1",13,2275,"MO","1",2275,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27300,0,"7385"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 15:10:55","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":[762,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207034","2020-01-29 15:10:55",27300,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7034","DEPOSIT",null,"PAID","2020-01-29 15:10:55",0,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:10:55","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":["7034","INVOICE","7385","PAID","2020-01-29 15:10:55",27300,"2","2020-01-29 15:10:55","2","2020-01-29 15:10:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 15:16:06","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":["NEW","055,60579,052,28880","13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n\r\n","2020-01-29 15:16:06","2","xEf2h2aoyRQ71ZVgBH+9WQ==","ssTBnR3AFy3Uau4Z+eR04w==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","5840EFb2ImEI9pAVgEm9XA==","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=",7057]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:14:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:15:09","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","055,60579,052,28880","13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n\r\n","2020-01-29 16:15:09","2","xEf2h2aoyRQ71ZVgBH+9WQ==","ssTBnR3AFy3Uau4Z+eR04w==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","5840EFb2ImEI9pAVgEm9XA==","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=",7057]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:16:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"95","master_room_id":"9","room_code":"B43"}],"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> B43 <\/td>\r\n\t\t\t\t\t 5X7X8 <\/td>\r\n\t\t\t\t\t $2528.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":"PERSONAL","identity_id":"D395480(4)","title":"Ms","lastname":"Leung","firstname":"Yin Kwan","companyname":"","email":"kittyykl@yahoo.com.hk","tel":"90389997","address":"Flat 6, 25\/F, Hoi Wu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_id":"762","customer_code":"C180762","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"95","room_code":"B43","retail_price":"2528.0","discounted_price":"2528.00","location_id":"1"}],"roughly_size":"35","total_retail_price":2528,"total_discounted_price":2275,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":27300,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2275.00","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2021-03-10","delivery_service":"0","remark":"13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2275,"order_total":29575,"final_order_total":27300,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,60579,052,28880","order_product":[],"pass":true}},"roughly_size":"35","total_discounted_price":"2275.00","deposit":"0.00","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","762","NEW","A12-CT207058",2528,2275,0,0,"13","13",27300,29575,27300,"2020-01-29 16:17:51","0",null,null,null,"2020-02-11","2021-03-10","13 months contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A12-CT194310 to this agreement.\r\n","2020-02-11","35",0,null,2275,"2275.00","2","2020-01-29 16:17:50","2","2020-01-29 16:17:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,60579,052,28880","C180762","PERSONAL","Ms","ssTBnR3AFy3Uau4Z+eR04w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","PgBhFDwHniI9mTC5FPe\/P0VTDACqnfnJdIAn1u9Akt+gED6U0W6QRZAUgVq27Y2uKQcPhE0ZkUdgmS5xl6iNxT4xJ5xqP3vZx0bUSKqko0w=","5840EFb2ImEI9pAVgEm9XA==","fvTF+m4vSeeXtKdQGYx+ToresPEPQUh\/May90\/w0i1I=","VciKXQMV8Uq23+OUQSYSLQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7058","95","2528.0","2528.00","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-11","2021-03-10","95"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","762","SETTLED","A12-I207386","2020-01-29 16:17:50","2020-02-11","2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",3,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",4,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",5,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",6,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",7,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",8,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",9,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",10,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",11,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",12,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7386","RENT","\u9810\u7e73\u79df\u91d1",13,2275,"MO","1",2275,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27300,0,"7386"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["762","NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207035","2020-01-29 16:17:50",27300,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7035","DEPOSIT",null,"PAID","2020-01-29 16:17:50",0,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:17:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7035","INVOICE","7386","PAID","2020-01-29 16:17:50",27300,"2","2020-01-29 16:17:50","2","2020-01-29 16:17:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"95","master_room_id":"9","room_code":"B43"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":999,"customer_code":"C180999","identity_type":"PERSONAL","identity_id":"K209079(1)","title":"Mr","lastname":"Ho","firstname":"Ka Man","companyname":"","email":"hokaman1973@gmail.com","tel":"93080512","address":"Rm517, Chak Tsui Hse, Wan Tsui Estate, Chai Wan","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1678.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-28","renew_room_key":"0005821195","renew_remark":"1 month contract. Storage rental paid by PPS on December 28, 2019. Storage deposit $1678 transferred from agreement C15-CT196546 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206840, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"161","order_discount":[],"order_room":[{"room_id":"1472","room_code":"C15-166","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"28","total_retail_price":1678,"total_discounted_price":1678,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-28","rent_from":"2020-01-28","rent_to":"2020-02-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 24, 2020. Storage deposit $1678 transferred from agreement C15-CT206840 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1678,"final_order_total":1678,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005821195","order_product":[],"pass":true}},"first_order_id":"5351","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-166 <\/td>\r\n\t\t\t\t\t 3.5X8X6.5 <\/td>\r\n\t\t\t\t\t $1678.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":"1678.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","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",999,"NEW","C15-CT207059",1678,1678,0,0,"1","1",1678,1678,1678,"2020-01-29 16:40:29","0",null,null,null,"2020-01-28","2020-02-27","1 month contract. Storage rental paid by PPS on January 24, 2020. Storage deposit $1678 transferred from agreement C15-CT206840 to this agreement. ","2020-01-28","28",0,null,0,"0","2","2020-01-29 16:40:29","2","2020-01-29 16:40:29","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005821195","C180999","PERSONAL","Mr","mpGDaYSZYMm5Nv4dlC\/AXA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","s+jJD+PTKIcV6TFUbKAjZeaR7whyPq\/zYSwZaQ3P71eVxgGVseccbnTawUyuMcS0","6hDDMUpiAw3i7Vyi+5LUuw==","O5CaJhqkZvhJIkWAmdNjem53qQvwEVnuhSQx55cm2I4=","lBWb6eJ9jDFkCCTNwsJ4wA==",null,1,"5351"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","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":["7059","1472","1678.0","1678.00","2","2020-01-29 16:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-28","2020-02-27","1472"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 16:40:29","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":["7059",999,"SETTLED","C15-I207387","2020-01-29 16:40:29","2020-01-28","2","2020-01-29 16:40:29","2","2020-01-29 16:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","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":["7387","RENT","\u9810\u7e73\u79df\u91d1",1,1678,"MO","1",1678,"2","2020-01-29 16:40:29","2","2020-01-29 16:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1678,0,"7387"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 16:40:29","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":[999,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207036","2020-01-29 16:40:29",1678,"2","2020-01-29 16:40:29","2","2020-01-29 16:40:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","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":["7036","DEPOSIT",null,"PAID","2020-01-29 16:40:29",0,"2","2020-01-29 16:40:29","2","2020-01-29 16:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 16:40:29","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":["7036","INVOICE","7387","PAID","2020-01-29 16:40:29",1678,"2","2020-01-29 16:40:29","2","2020-01-29 16:40:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=874&filter3=undefined","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"95","master_room_id":"9","room_code":"B43"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on December 24, 2019. Storage deposit transferred from agreement A12-CT196538 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196791, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"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-01-22","rent_from":"2020-01-22","rent_to":"2020-02-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 24, 2020. Storage deposit transferred from agreement A12-CT196791 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","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> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",874,"NEW","A12-CT207060",998,1038,0,0,"1","1",1038,1038,1038,"2020-01-29 17:06:19","0",null,null,null,"2020-01-22","2020-02-21","1 month contract. Storage rental paid by PPS on January 24, 2020. Storage deposit transferred from agreement A12-CT196791 to this agreement.\r\n","2020-01-22","12",0,null,0,"0","2","2020-01-29 17:06:18","2","2020-01-29 17:06:18","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06: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":["7060","241","998.0","998.00","2","2020-01-29 17:06:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06: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-01-22","2020-02-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 17:06: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":["7060",874,"SETTLED","A12-I207388","2020-01-29 17:06:18","2020-01-22","2","2020-01-29 17:06:18","2","2020-01-29 17:06:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06: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":["7388","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-01-29 17:06:18","2","2020-01-29 17:06:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7388"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 17:06:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207037","2020-01-29 17:06:18",1038,"2","2020-01-29 17:06:18","2","2020-01-29 17:06:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7037","DEPOSIT",null,"PAID","2020-01-29 17:06:18",0,"2","2020-01-29 17:06:18","2","2020-01-29 17:06:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:06:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7037","INVOICE","7388","PAID","2020-01-29 17:06:18",1038,"2","2020-01-29 17:06:18","2","2020-01-29 17:06:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:19:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:19:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1080&filter3=undefined","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1182","master_room_id":"111","room_code":"A05-180"}],"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-180 <\/td>\r\n\t\t\t\t\t 4X2X7 <\/td>\r\n\t\t\t\t\t $965.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":"0","identity_type":"PERSONAL","identity_id":"K372521(9)","title":"Mr","lastname":"Cheung ","firstname":"Nga Lun, Sandy","companyname":"","email":"snlcheung@hotmail.com","tel":"98600326","address":"Flat 106, 1\/F, Lung Chun House, Lung Yan Court, Stanley, Hong Kong","pass":true,"customer_id":"1080","customer_code":"C181080","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1182","room_code":"A05-180","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":868,"deposit":1930,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":9766,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3448.00","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-02-28","delivery_service":"0","remark":"13 months contract, Special offer the 13th month free. Change unit from A05-133 to A05-180. Storage depoist $2580 transferred from agreement A05-CT183583. Remaining rental paid by cheque on January 29, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3448,"order_total":13214,"final_order_total":9766,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005013058,0012422215","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"868.00","deposit":"1930.00","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1080","NEW","A05-CT207061",965,868,1930,0,"13","13",9766,13214,9766,"2020-01-29 17:56:08","0",null,null,null,"2020-02-01","2021-02-28","13 months contract, Special offer the 13th month free. Change unit from A05-133 to A05-180. Storage depoist $2580 transferred from agreement A05-CT183583. Remaining rental paid by cheque on January 29, 2020. ","2020-02-01","8",0,null,3448,"3448.00","2","2020-01-29 17:56:07","2","2020-01-29 17:56:07","CHEQUE","","","","CHEQUE","","","",null,0,"0005013058,0012422215","C181080","PERSONAL","Mr","imJ3bI7og25qypvnZK897Q==","C\/COjtUKg4YuLl3OW7iV0A==","","ZosyM\/3JnDf2Nd7WxWaJxafl3dOspX1PjBy8UPOAWppzdyy2mRwudjg+zIh3hDRBsH0kNYMIsx7OTqDtbbUNpkZRcJMvvWkBVd0QV23lSrw=","xFp6iGQAZ92fm1a1RjNazw==","lEc8j6jWI62jn62EOuTVsM4F7l59Txyg8yzzA+irur0=","+7G5DQvPa7GodvjbPA\/gtg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7061","1182","965.0","965.00","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-02-28","1182"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7061","A05-D205271","PAID",1930,0,"2021-02-28","2020-01-29 17:56:07","2020-01-29 17:56:07","2","2020-01-29 17:56:07","2","2020-01-29 17:56:07","1080"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7061","1080","SETTLED","A05-I207389","2020-01-29 17:56:07","2020-02-01","2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,24,"MO","1",24,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7389","RENT","\u9810\u7e73\u79df\u91d1",13,868,"MO","1",868,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7836,0,"7389"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1080","CHEQUE","","","","CHEQUE","","","","PAID","P207038","2020-01-29 17:56:07",9766,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7038","DEPOSIT","5271","PAID","2020-01-29 17:56:07",1930,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 17:56:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7038","INVOICE","7389","PAID","2020-01-29 17:56:07",7836,"2","2020-01-29 17:56:07","2","2020-01-29 17:56:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-29 22:18:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****