{"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=443&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1136,"customer_code":"C181136","identity_type":"PERSONAL","identity_id":"K032253(9)","title":"Ms","lastname":"Lai","firstname":"Suk Fan Andy","companyname":"","email":"bionicandie@gmail.com","tel":"98538228","address":"Flat 801, 8\/F, Kong Hing Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-06","renew_room_key":"0007305419","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Paid $4500 deposit on November 20, 2018. Remaining Storage rental and deposit (ttl:$6978) paid by cash on December 5, 2018. Smartcard provided on December 5, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183837, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1930.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1090","room_code":"A05-088","retail_price":"598.0","discounted_price":"598.00","location_id":"4"},{"room_id":"1089","room_code":"A05-087","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1196,"total_discounted_price":917,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2751,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-03-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on February 13, 2020. Extra $49 will transfer to next contract. Storage deposit $1930 transferred from agreement A05-CT183837 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2751,"final_order_total":2751,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305419","order_product":[],"pass":true}},"first_order_id":3837,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-088 <\/td>\r\n\t\t\t\t\t	4X2X3.5 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\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>
A05-087 <\/td>\r\n\t\t\t\t\t	4X2X3.5 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\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":"16","total_discounted_price":"917.00","deposit":"0.00","total_retail_price":"1196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1136,"NEW","A05-CT207173",1196,917,0,0,"3","3",2751,2751,2751,"2020-02-13 11:44:00","0",null,null,null,"2019-12-06","2020-03-05","3 months contract. Storage rental paid by bank transfer on February 13, 2020. Extra $49 will transfer to next contract. Storage deposit $1930 transferred from agreement A05-CT183837 to this agreement. ","2019-12-06","16",0,null,0,"0","2","2020-02-13 11:44:00","2","2020-02-13 11:44:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305419","C181136","PERSONAL","Ms","c3yal7ndF0weKKnxE7u55g==","lzx0GiXnrd0waIhp6oozpQ==","","9xx975AxF3bBEdIxvR0GggIVvgR8rteFDZLYcoB1Xi1W+Ag1I2rkoY3DsBlAJRZqeYyECyi8m7DzVo3TZUhLPPBpPIV8JRkWDah5rRuO9ao=","dkKfrxcT6P2gD9cfnCMj9g==","zi0JZZw3vWEgQDqWm3e6j7iCApJuN6abpIpsorccaeM=","pVdq2UAS042qd4E3AoR1JQ==",null,1,3837]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7173","1090","598.0","598.00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-03-05","1090"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7173","1089","598.0","598.00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-03-05","1089"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7173",1136,"SETTLED","A05-I207501","2020-02-13 11:44:00","2019-12-06","2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7501","RENT","\u9810\u7e73\u79df\u91d1",1,917,"MO","1",917,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7501","RENT","\u9810\u7e73\u79df\u91d1",2,917,"MO","1",917,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7501","RENT","\u9810\u7e73\u79df\u91d1",3,917,"MO","1",917,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2751,0,"7501"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1136,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207149","2020-02-13 11:44:00",2751,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7149","DEPOSIT",null,"PAID","2020-02-13 11:44:00",0,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 11:44:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7149","INVOICE","7501","PAID","2020-02-13 11:44:00",2751,"2","2020-02-13 11:44:00","2","2020-02-13 11:44:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=443&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1169,"customer_code":"C191169","identity_type":"PERSONAL","identity_id":"A940893(5)","title":"Ms","lastname":"Ho","firstname":"Emily Siu Yee","companyname":"","email":null,"tel":"92899079","address":"Flat B, 1\/F, Seaview Court, 26 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2191.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-15","renew_room_key":"0012492388","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 8, 2019. Storage deposit $4868 transferred from agreement A05-CT194101 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195675, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"131","order_discount":[],"order_room":[{"room_id":"1137","room_code":"A05-135","retail_price":"2434.0","discounted_price":"2434.00","location_id":"4"}],"roughly_size":"32","total_retail_price":2434,"total_discounted_price":2434,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":4868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-15","rent_from":"2020-02-15","rent_to":"2020-04-14","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on February 13, 2020. Storage deposit $4868 transferred from agreement A05-CT195675 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":4868,"final_order_total":4868,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012492388","order_product":[],"pass":true}},"first_order_id":"4101","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-135 <\/td>\r\n\t\t\t\t\t 8X4X7 <\/td>\r\n\t\t\t\t\t $2434.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2434.00","deposit":"0.00","total_retail_price":"2434.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1169,"NEW","A05-CT207174",2434,2434,0,0,"2","2",4868,4868,4868,"2020-02-13 12:00:11","0",null,null,null,"2020-02-15","2020-04-14","2 months contract. Storage rental paid by cheque on February 13, 2020. Storage deposit $4868 transferred from agreement A05-CT195675 to this agreement.","2020-02-15","32",0,null,0,"0","2","2020-02-13 12:00:11","2","2020-02-13 12:00:11","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012492388","C191169","PERSONAL","Ms","Xu2ADsb1wS73d8AGH+\/WTg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","9FD5PzyZ1jqJvlUxI5j2ifPss1nzDLR\/XaKSNFsEotK4TehfR1JBK+O+UL2ob0Z+Jggf4RWVyIt8RTsjSd4JNTO\/fIiOalrdMRRp8JT+1os=","l6cxkQzaXPtplwz5jlBAcw==",null,"WyYJQDbA5P1MT+cdxWYplA==",null,1,"4101"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7174","1137","2434.0","2434.00","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-15","2020-04-14","1137"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7174",1169,"SETTLED","A05-I207502","2020-02-13 12:00:11","2020-02-15","2","2020-02-13 12:00:11","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7502","RENT","\u9810\u7e73\u79df\u91d1",1,2434,"MO","1",2434,"2","2020-02-13 12:00:11","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7502","RENT","\u9810\u7e73\u79df\u91d1",2,2434,"MO","1",2434,"2","2020-02-13 12:00:11","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4868,0,"7502"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1169,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207150","2020-02-13 12:00:11",4868,"2","2020-02-13 12:00:11","2","2020-02-13 12:00:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7150","DEPOSIT",null,"PAID","2020-02-13 12:00:11",0,"2","2020-02-13 12:00:11","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:00:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7150","INVOICE","7502","PAID","2020-02-13 12:00:11",4868,"2","2020-02-13 12:00:11","2","2020-02-13 12:00:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03: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":"filter1=2&filter2=443&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":270,"customer_code":"C170270","identity_type":"PERSONAL","identity_id":"K022619(A)","title":"Ms","lastname":"Liao","firstname":"Kar Bo","companyname":"","email":"karinaliao@hotmail.com","tel":"90980573","address":"20C,Canelot Heights,66 Kennedy Road,Wan Chai","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-12","renew_room_key":"133,53419","renew_remark":"12 months contract. Storage rental will be paid by bank transfer on February 2019. Storage deposit transferred from agreement A14-CT182915 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194408, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"727","room_code":"O03","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11976,"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":"2021-02-11","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on February 12,2019. Storage deposit transferred from agreement A14-CT194408 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11976,"final_order_total":11976,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,53419","order_product":[],"pass":true}},"first_order_id":4408,"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> O03 <\/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\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":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",270,"NEW","A14-CT207175",998,998,0,0,"12","12",11976,11976,11976,"2020-02-13 12:03:56","0",null,null,null,"2020-02-12","2021-02-11","12 months contract. Storage rental paid by bank transfer on February 12,2019. Storage deposit transferred from agreement A14-CT194408 to this agreement.","2020-02-12","12",0,null,0,"0","2","2020-02-13 12:03:55","2","2020-02-13 12:03:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,53419","C170270","PERSONAL","Ms","+98jcJGPtl2lJLBPMdtV8w==","hQGo413+XUqMU1Iz\/hWBbQ==","","ZDyijiMMfLbnZs19RGQYoFma9y1oMV397i1bEwUiBtaR9E9cNWTKLfHTyOYxDm27","avME6GecOCOZvqxLTeBtXg==","WZTkwRLp\/bIlcveacHFsRVp5gAO43p9Zmo4Q9c+znIg=","0kgkaqhCMy9wjrMCtSTQ1Q==",null,1,4408]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7175","727","998.0","998.00","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-12","2021-02-11","727"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7175",270,"SETTLED","A14-I207503","2020-02-13 12:03:55","2020-02-12","2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7503","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11976,0,"7503"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[270,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207151","2020-02-13 12:03:55",11976,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7151","DEPOSIT",null,"PAID","2020-02-13 12:03:55",0,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:03:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7151","INVOICE","7503","PAID","2020-02-13 12:03:55",11976,"2","2020-02-13 12:03:55","2","2020-02-13 12:03:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:04:22","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","133,53419","12 months contract. Storage rental paid by bank transfer on February 12,2019. Storage deposit transferred from agreement A14-CT194408 to this agreement.","2020-02-13 12:04:22","2","hQGo413+XUqMU1Iz\/hWBbQ==","+98jcJGPtl2lJLBPMdtV8w==","WZTkwRLp\/bIlcveacHFsRVp5gAO43p9Zmo4Q9c+znIg=","avME6GecOCOZvqxLTeBtXg==","ZDyijiMMfLbnZs19RGQYoFma9y1oMV397i1bEwUiBtaR9E9cNWTKLfHTyOYxDm27",7175]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","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":"","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"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> O03 <\/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\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K022619(A)","title":"Ms","lastname":"Liao","firstname":"Kar Bo","companyname":"","email":"karinaliao@hotmail.com","tel":"90980573","address":"20C,Canelot Heights,66 Kennedy Road,Wan Chai","pass":true,"customer_id":"270","customer_code":"C170270","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"727","room_code":"O03","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.00","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2021-03-11","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on February 12,2019. Storage deposit transferred from agreement A14-CT194408 to this agreement.","paymethod":"UNPAID","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,53419","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"899.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","270","NEW","A14-CT207176",998,899,0,0,"13","13",10788,11687,10788,"2020-02-13 12:07:56","0",null,null,null,"2020-02-12","2021-03-11","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on February 12,2019. Storage deposit transferred from agreement A14-CT194408 to this agreement.","2020-02-12","12",0,null,899,"899.00","2","2020-02-13 12:07:56","2","2020-02-13 12:07:56","UNPAID","","","","BANKIN","","","",null,0,"133,53419","C170270","PERSONAL","Ms","+98jcJGPtl2lJLBPMdtV8w==","hQGo413+XUqMU1Iz\/hWBbQ==","","ZDyijiMMfLbnZs19RGQYoFma9y1oMV397i1bEwUiBtaR9E9cNWTKLfHTyOYxDm27","avME6GecOCOZvqxLTeBtXg==","WZTkwRLp\/bIlcveacHFsRVp5gAO43p9Zmo4Q9c+znIg=","0kgkaqhCMy9wjrMCtSTQ1Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7176","727","998.0","998.00","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-12","2021-03-11","727"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7176","270","SETTLED","A14-I207504","2020-02-13 12:07:56","2020-02-12","2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7504","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"7504"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["270","UNPAID","","","","BANKIN","","","","PAID","P207152","2020-02-13 12:07:56",10788,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56","INVOICE"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:07:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7152","INVOICE","7504","PAID","2020-02-13 12:07:56",10788,"2","2020-02-13 12:07:56","2","2020-02-13 12:07:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":213,"customer_code":"C160213","identity_type":"PERSONAL","identity_id":"D213817(5)","title":"Ms","lastname":"Chiu","firstname":"Wai Yi, Wendy","companyname":"","email":"wai_waicheng@yahoo.com.hk","tel":"90753288","address":"Room 1032, Wah Ming House, Wah Fu Estate, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2328.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-07","renew_room_key":"137,03416,136,64224","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 21, 2019. Storage deposit transferred from agreement A12-CT195652 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT195652, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196191, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"88","room_code":"B36","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"87","room_code":"B35","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2328,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6984,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-07","rent_from":"2020-01-07","rent_to":"2020-04-06","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on February 12, 2020. Storage deposit transferred from agreement A12-CT196191 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6984,"final_order_total":6984,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,03416,136,64224","order_product":[],"pass":true}},"first_order_id":"4413","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B36 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> B35 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2328.0","deposit":"0","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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",213,"NEW","A12-CT207177",3056,2328,0,0,"3","3",6984,6984,6984,"2020-02-13 12:12:45","0",null,null,null,"2020-01-07","2020-04-06","3 months contract. Storage rental paid by bank transfer on February 12, 2020. Storage deposit transferred from agreement A12-CT196191 to this agreement.\r\n","2020-01-07","40",0,null,0,"0","2","2020-02-13 12:12:45","2","2020-02-13 12:12:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,03416,136,64224","C160213","PERSONAL","Ms","2S1nuKYxzBQN\/HErX3zc4Q==","sQFQFKDK2lCJDg4WUvEEAw==","","SoL2cPYh\/\/uwHaf\/Kd3Lts1Qx1oqh4qgYJTzV+EQU7ucSrBKZz2RDTb2Z7tA0RIwIcjHIINeEHw\/T+G3Mr5wAw==","t8OH+X7T0O\/zjHukl5kvww==","Bia8FXQfSDTjOo0FAQsdw+1lMAMS6o8AFLu5QNxWLYc=","qggRIpTbNDaCFQ\/oRJ948A==",null,1,"4413"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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":["7177","88","1528.0","1528.00","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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-07","2020-04-06","88"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:12:45","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":["7177","87","1528.0","1528.00","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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-07","2020-04-06","87"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:12:45","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":["7177",213,"SETTLED","A12-I207505","2020-02-13 12:12:45","2020-01-07","2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7505","RENT","\u9810\u7e73\u79df\u91d1",1,2328,"MO","1",2328,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7505","RENT","\u9810\u7e73\u79df\u91d1",2,2328,"MO","1",2328,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7505","RENT","\u9810\u7e73\u79df\u91d1",3,2328,"MO","1",2328,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6984,0,"7505"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:12:45","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":[213,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207153","2020-02-13 12:12:45",6984,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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":["7153","DEPOSIT",null,"PAID","2020-02-13 12:12:45",0,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:12:45","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":["7153","INVOICE","7505","PAID","2020-02-13 12:12:45",6984,"2","2020-02-13 12:12:45","2","2020-02-13 12:12:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, 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":"1195.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-02","renew_room_key":"052,40523","renew_remark":"2 months contract. Storage rental paid by bank transfer on November 29, 2019 and December 31, 2019. Storage deposit transferred from agreement A18-CT196250 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206830, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1195,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-02","rent_from":"2020-02-02","rent_to":"2020-03-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 12, 2020. Storage deposit transferred from agreement A18-CT206830 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1195,"final_order_total":1195,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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> Q12 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1195.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":"18","total_discounted_price":"1195.00","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",629,"NEW","A18-CT207178",1195,1195,0,0,"1","1",1195,1195,1195,"2020-02-13 12:17:07","0",null,null,null,"2020-02-02","2020-03-01","1 month contract. Storage rental paid by bank transfer on February 12, 2020. Storage deposit transferred from agreement A18-CT206830 to this agreement.\r\n","2020-02-02","18",0,null,0,"0","2","2020-02-13 12:17:07","2","2020-02-13 12:17:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7178","815","1195.0","1195.00","2","2020-02-13 12:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-02","2020-03-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7178",629,"SETTLED","A18-I207506","2020-02-13 12:17:07","2020-02-02","2","2020-02-13 12:17:07","2","2020-02-13 12:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7506","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-02-13 12:17:07","2","2020-02-13 12:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1195,0,"7506"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207154","2020-02-13 12:17:07",1195,"2","2020-02-13 12:17:07","2","2020-02-13 12:17:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7154","DEPOSIT",null,"PAID","2020-02-13 12:17:07",0,"2","2020-02-13 12:17:07","2","2020-02-13 12:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:17:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7154","INVOICE","7506","PAID","2020-02-13 12:17:07",1195,"2","2020-02-13 12:17:07","2","2020-02-13 12:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","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":"2","renew_warehousing_date":"2020-02-14","renew_room_key":"254,19454","renew_remark":"2 months contract. Storage rental paid by cash deposit on December 7, 2019 and January 8, 2020. Storage deposit transferred from agreement A12-CT196383 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206907, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","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-02-14","rent_from":"2020-02-14","rent_to":"2020-03-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash deposit on February 12, 2020. Storage deposit transferred from agreement A12-CT206907 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":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","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> D18 <\/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.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","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",62,"NEW","A12-CT207179",598,598,0,0,"1","1",598,598,598,"2020-02-13 12:18:58","0",null,null,null,"2020-02-14","2020-03-13","1 month contract. Storage rental paid by cash deposit on February 12, 2020. Storage deposit transferred from agreement A12-CT206907 to this agreement.\r\n","2020-02-14","12",0,null,0,"0","2","2020-02-13 12:18:58","2","2020-02-13 12:18:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","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":["7179","214","598.0","598.00","2","2020-02-13 12:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-14","2020-03-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:18:58","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":["7179",62,"SETTLED","A12-I207507","2020-02-13 12:18:58","2020-02-14","2","2020-02-13 12:18:58","2","2020-02-13 12:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7507","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-13 12:18:58","2","2020-02-13 12:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7507"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:18:58","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":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207155","2020-02-13 12:18:58",598,"2","2020-02-13 12:18:58","2","2020-02-13 12:18:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","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":["7155","DEPOSIT",null,"PAID","2020-02-13 12:18:58",0,"2","2020-02-13 12:18:58","2","2020-02-13 12:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:18:58","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":["7155","INVOICE","7507","PAID","2020-02-13 12:18:58",598,"2","2020-02-13 12:18:58","2","2020-02-13 12:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1255,"customer_code":"C191255","identity_type":"PERSONAL","identity_id":"R857926(0)","title":"Ms","lastname":"Mostashari","firstname":"Yas","companyname":"","email":"yass@mostashari.co.uk","tel":"96873290","address":"Flat A6, Guildford Court, 5 Guildford Road, The Peak, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3932.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-29","renew_room_key":"076,34807","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit $8276 transferred from agreement A14-CT194818 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196642, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"761","room_code":"O37","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"760","room_code":"O36","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"750","room_code":"O26","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"749","room_code":"O25","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3724,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":22344,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-29","rent_from":"2020-01-29","rent_to":"2020-07-28","delivery_service":"0","remark":"6 months contract. Storage rental paid $3724 by bank transfer on February 12, 2020. Remaining balance will pay by post-dated note. Storage deposit $8276 transferred from agreement A14-CT196642 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":22344,"final_order_total":22344,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,34807","order_product":[],"pass":true}},"first_order_id":"4818","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> O37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> O36 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> O26 <\/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\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> O25 <\/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\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":"56","total_discounted_price":"3724.00","deposit":"0.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1255,"NEW","A14-CT207180",4192,3724,0,0,"6","6",22344,22344,22344,"2020-02-13 12:21:43","0",null,null,null,"2020-01-29","2020-07-28","6 months contract. Storage rental paid $3724 by bank transfer on February 12, 2020. Remaining balance will pay by post-dated note. Storage deposit $8276 transferred from agreement A14-CT196642 to this agreement.","2020-01-29","56",0,null,0,"0","2","2020-02-13 12:21:43","2","2020-02-13 12:21:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,34807","C191255","PERSONAL","Ms","ATneOtMIe0LYAurw32wHyQ==","8fTzWS+7t1nmEnG1fQtiRw==","","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==","wLWBoYhI1qKia2rkJxrObg==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","qCm4RuBGDh5cFKNczNFPwQ==",null,1,"4818"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7180","761","1098.0","1098.00","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-29","2020-07-28","761"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7180","760","1098.0","1098.00","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-29","2020-07-28","760"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7180","750","998.0","998.00","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-29","2020-07-28","750"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7180","749","998.0","998.00","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-29","2020-07-28","749"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7180",1255,"SETTLED","A14-I207508","2020-02-13 12:21:43","2020-01-29","2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",1,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",2,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",3,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",4,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",5,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","RENT","\u9810\u7e73\u79df\u91d1",6,3724,"MO","1",3724,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[22344,0,"7508"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1255,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207156","2020-02-13 12:21:43",22344,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7156","DEPOSIT",null,"PAID","2020-02-13 12:21:43",0,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:21:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7156","INVOICE","7508","PAID","2020-02-13 12:21:43",22344,"2","2020-02-13 12:21:43","2","2020-02-13 12:21:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":541,"customer_code":"C170541","identity_type":"PERSONAL","identity_id":"D241258(7)","title":"Mr","lastname":"Chung","firstname":"Kai Hau","companyname":"","email":"amoschung@netvigator.com","tel":"94770337","address":"Flat 5, 24\/F, Block C, Yue On Court, Ap Lei Chau, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1169.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-01","renew_room_key":"137,10301,076,32319","renew_remark":"6 months contract. Storage rental paid by bank transfer on February 21, 2019. Storage deposit transferred from agreement \tA14-CT182984 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194421, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"470","room_code":"K07(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14496,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1208.00","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2021-03-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on February 13, 2020. Storage deposit transferred from agreement A14-CT194421 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":1208,"order_total":15704,"final_order_total":14496,"location_id":"2","branch_id":"1","company_id":"1","room_key":"137,10301,076,32319","order_product":[],"pass":true}},"first_order_id":4421,"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> K07(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.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":"16","total_discounted_price":"1208.00","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","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",541,"NEW","A14-CT207181",1342,1208,0,0,"13","13",14496,15704,14496,"2020-02-13 12:38:20","0",null,null,null,"2020-03-01","2021-03-31","13 months contract. Special offer the 13th month free. Storage rental paid by cash on February 13, 2020. Storage deposit transferred from agreement A14-CT194421 to this agreement.","2020-03-01","16",0,null,1208,"1208.00","2","2020-02-13 12:38:19","2","2020-02-13 12:38:19","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"137,10301,076,32319","C170541","PERSONAL","Mr","GZODW7ywcpMpK7lXzn01IQ==","ThKwrAIcvgN3JqAg+7\/isg==","","Nogikh9ZYmdjLKODrNyM4OE0vPV0fehKFtopUgIHTyR5ETWImts+lU+7kIPvyGtKjji6DpjjZT\/irfZJ09Klbg==","Cv3Qr3Hx8Lwwf\/wDC5eANQ==","xGM4xnwTkZ4a5\/\/82PqOzX7HmxXh1kouDZ8ibHk2Mb8=","zNO5TJ6+eHtO\/6DSDOfc\/g==",null,1,4421]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","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":["7181","470","1342.0","1342.00","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2021-03-31","470"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 12:38:20","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":["7181",541,"SETTLED","A14-I207509","2020-02-13 12:38:19","2020-03-01","2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",3,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",4,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",7,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",8,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",9,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",10,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",11,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",12,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","RENT","\u9810\u7e73\u79df\u91d1",13,1208,"MO","1",1208,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14496,0,"7509"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 12:38:20","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":[541,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207157","2020-02-13 12:38:19",14496,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","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":["7157","DEPOSIT",null,"PAID","2020-02-13 12:38:19",0,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:38:20","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":["7157","INVOICE","7509","PAID","2020-02-13 12:38:19",14496,"2","2020-02-13 12:38:19","2","2020-02-13 12:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 12:44:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1063,"customer_code":"C181063","identity_type":"PERSONAL","identity_id":"P150061(2)","title":"Ms","lastname":"HASKINS","firstname":"Eileen Mary","companyname":"","email":"eimart@netvigator.com","tel":"92769708","address":"House 20A Pok Kok Tsven","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-13","renew_room_key":"'0012435080","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 14, 2019. Storage deposit $2580 transferred from agreement A05-CT195411 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206955, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1126","room_code":"A05-124","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2020-02-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit $2580 transferred from agreement A05-CT206955 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012435080","order_product":[],"pass":true}},"first_order_id":"3560","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-124 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1063,"NEW","A05-CT207182",1290,1290,0,0,"1","1",1290,1290,1290,"2020-02-13 13:45:39","0",null,null,null,"2020-01-13","2020-02-12","1 month contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit $2580 transferred from agreement A05-CT206955 to this agreement.","2020-01-13","16",0,null,0,"0","2","2020-02-13 13:45:38","2","2020-02-13 13:45:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435080","C181063","PERSONAL","Ms","N2dL4uJnRUVt3pWxZbjoPA==","gBCfCDjxN1soEZ6ASSV8CQ==","","WxFMz3JMJw0zIWOLHcLgDzylG1NdowDT02leCzTzNHk=","9LmyvpD23mCmBchshNAO0w==","WMY4NPSZuxSFljp7Sz0XPINva+8MxbIjoBMZ02LKzdU=","UcXhFM2zM7eIpbzXOGUfvA==",null,1,"3560"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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":["7182","1126","1290.0","1290.00","2","2020-02-13 13:45:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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-13","2020-02-12","1126"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 13:45: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":["7182",1063,"SETTLED","A05-I207510","2020-02-13 13:45:38","2020-01-13","2","2020-02-13 13:45:38","2","2020-02-13 13:45:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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":["7510","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-02-13 13:45:38","2","2020-02-13 13:45:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7510"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 13:45: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":[1063,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207158","2020-02-13 13:45:38",1290,"2","2020-02-13 13:45:38","2","2020-02-13 13:45:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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":["7158","DEPOSIT",null,"PAID","2020-02-13 13:45:38",0,"2","2020-02-13 13:45:38","2","2020-02-13 13:45:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:45: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":["7158","INVOICE","7510","PAID","2020-02-13 13:45:38",1290,"2","2020-02-13 13:45:38","2","2020-02-13 13:45:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":621,"customer_code":"C170621","identity_type":"PERSONAL","identity_id":"Z083036(5)","title":"Mr","lastname":"Ng","firstname":"Wai Yip","companyname":"","email":"waiyip010@gmail.com","tel":"98388160","address":"Room 2, 22\/F, Kwun Chiu 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":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-28","renew_room_key":"054,54144","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 20\uff0c 2020. Storage deposit transferred from agreement A18-CT196714 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207014, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"849","room_code":"S08","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"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 bank transfer on February 13, 2020. Storage deposit transferred from agreement A18-CT207014 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,54144","order_product":[],"pass":true}},"first_order_id":"4764","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> S08 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",621,"NEW","A18-CT207183",1290,1290,0,0,"1","1",1290,1290,1290,"2020-02-13 13:59:15","0",null,null,null,"2020-01-28","2020-02-27","1 month contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit transferred from agreement A18-CT207014 to this agreement.","2020-01-28","16",0,null,0,"0","2","2020-02-13 13:59:15","2","2020-02-13 13:59:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,54144","C170621","PERSONAL","Mr","ih4aUrxtlcexLCp\/tdkvvw==","cxr02xsD1tXvJ4ihJHZKWw==","","yR95NWcy8orgfJiv4o8nUhldJm21pHQyPqtwASYolM1Kfk2Djou6qn5enXkBMxam3xy5zhVtYjz\/vUJqcjgCQwJJ6wImNgSpgm7xbtLd7UU=","484inTWWBLYNYwPtLecM3w==","eXhWO16jYYVtb51D98Y8hU3AEhjg0o6Un\/aNYSBOey4=","xt28FcrgbbbToDMexv\/cfg==",null,1,"4764"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7183","849","1290.0","1290.00","2","2020-02-13 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-28","2020-02-27","849"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7183",621,"SETTLED","A18-I207511","2020-02-13 13:59:15","2020-01-28","2","2020-02-13 13:59:15","2","2020-02-13 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7511","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-02-13 13:59:15","2","2020-02-13 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7511"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[621,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207159","2020-02-13 13:59:15",1290,"2","2020-02-13 13:59:15","2","2020-02-13 13:59:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7159","DEPOSIT",null,"PAID","2020-02-13 13:59:15",0,"2","2020-02-13 13:59:15","2","2020-02-13 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 13:59:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7159","INVOICE","7511","PAID","2020-02-13 13:59:15",1290,"2","2020-02-13 13:59:15","2","2020-02-13 13:59:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A14-CT206833 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207044, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2020-03-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A14-CT207044 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K59 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K56 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"72","total_discounted_price":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT207184",5062,4499,0,0,"1","1",4499,4499,4499,"2020-02-13 14:01:33","0",null,null,null,"2020-02-10","2020-03-09","1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A14-CT207044 to this agreement.","2020-02-10","72",0,null,0,"0","2","2020-02-13 14:01:33","2","2020-02-13 14:01:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7184","522","1098.0","1098.00","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2020-03-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7184","521","1098.0","1098.00","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2020-03-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7184","520","1098.0","1098.00","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2020-03-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7184","519","1768.0","1768.00","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-10","2020-03-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7184",423,"SETTLED","A14-I207512","2020-02-13 14:01:33","2020-02-10","2","2020-02-13 14:01:33","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7512","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-02-13 14:01:33","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"7512"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207160","2020-02-13 14:01:33",4499,"2","2020-02-13 14:01:33","2","2020-02-13 14:01:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7160","DEPOSIT",null,"PAID","2020-02-13 14:01:33",0,"2","2020-02-13 14:01:33","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:01:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7160","INVOICE","7512","PAID","2020-02-13 14:01:33",4499,"2","2020-02-13 14:01:33","2","2020-02-13 14:01:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:45:16","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0012412991","12 months contract. Special offer the 11th and 12th month free. 5% 'rent now' discount and $200 'switch to us' offer. $500 deposit paid by PayMe on Jan 13,2020. The balance of storage rental and deposit $11992 paid by bank transfer on Feb 12,2020. Smart card paid on the same day.","2020-02-13 14:45:16","2","yXKc2lCF323ApRADrjNaSg==","lHbtRFVQRe9C15Dfob48mQ==","xcKzcWrcugogw7f28wEntg==","pD1DwbpxsD6PibgUdeAO6WZmRwGbUK0zn\/Hon6+zWI4=",7172]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 14:59:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 15:25:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:19:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":800,"customer_code":"C180800","identity_type":"BUSINESS","identity_id":"65455195-000-11-17-9","title":"Ms","lastname":"Tang","firstname":"Yee Ting","companyname":"Long Ease Engineering Limited","email":"amyyt81@hotmail.com","tel":"93889887","address":"G\/F, 17 Tsui Fung St, Wong Tai Sin, Kowloon","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-20","renew_room_key":"056,08304","renew_remark":"6 months contract. Storage rental paid by PPS on July 29, 2019. Storage deposit transferred from agreement A12-CT194220 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195592, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"348","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"348","room_code":"F33","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":934,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5604,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2020-07-19","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A12-CT195592 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5604,"final_order_total":5604,"location_id":"1","branch_id":"1","company_id":"1","room_key":"056,08304","order_product":[],"pass":true}},"first_order_id":"4220","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> F33 <\/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":"934.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",800,"NEW","A12-CT207185",998,934,0,0,"6","6",5604,5604,5604,"2020-02-13 16:29:32","0",null,null,null,"2020-01-20","2020-07-19","6 months contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A12-CT195592 to this agreement.\r\n","2020-01-20","12",0,null,0,"0","2","2020-02-13 16:29:31","2","2020-02-13 16:29:31","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,08304","C180800","BUSINESS","Ms","GPsz8iWcbUBOzCHtD4XSwg==","M7CfcmE2OSMlZOkNgaoDmQ==","Long Ease Engineering Limited","nFo6rZgRhn8XpJ1t4ft2QLEJVuYpVTq2hsaRrGMDVyH+giyqStr8NG\/TKicOV\/U2","mokiKYnafyX066l5AG2vmw==","vXkY+HF93dqb5uaDMOaKVGeOqKFZkCLNPHGYCONKvGE=",null,"UzuNyVUc9Gw1dv3ZagOEoy5q+5FQ9BdmVfHvRvt+Vno=",1,"4220"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","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":["7185","70","6","348","%","9.96",99.4008,"2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7185","348","998.0",898.6,"2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-20","2020-07-19","348"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7185",800,"SETTLED","A12-I207513","2020-02-13 16:29:31","2020-01-20","2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",1,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",2,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",3,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",4,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",5,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","RENT","\u9810\u7e73\u79df\u91d1",6,934,"MO","1",934,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5604,0,"7513"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[800,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207161","2020-02-13 16:29:31",5604,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7161","DEPOSIT",null,"PAID","2020-02-13 16:29:31",0,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:29:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7161","INVOICE","7513","PAID","2020-02-13 16:29:31",5604,"2","2020-02-13 16:29:31","2","2020-02-13 16:29:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1930.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-13","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196686 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206901, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"104","order_discount":[],"order_room":[{"room_id":"921","room_code":"U22","retail_price":"1930.0","discounted_price":"1930.00","location_id":"3"}],"roughly_size":"25","total_retail_price":1930,"total_discounted_price":1930,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-13","rent_from":"2020-02-13","rent_to":"2020-03-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A18-CT206901 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1930,"final_order_total":1930,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4603","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> U22 <\/td>\r\n\t\t\t\t\t 5X5X7 <\/td>\r\n\t\t\t\t\t $1930.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\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":"25","total_discounted_price":"1930.0","deposit":"0","total_retail_price":"1930.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",645,"NEW","A18-CT207186",1930,1930,0,0,"1","1",1930,1930,1930,"2020-02-13 16:32:31","0",null,null,null,"2020-02-13","2020-03-12","1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A18-CT206901 to this agreement.\r\n","2020-02-13","25",0,null,0,"0","2","2020-02-13 16:32:30","2","2020-02-13 16:32:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4603"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7186","921","1930.0","1930.00","2","2020-02-13 16:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-13","2020-03-12","921"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7186",645,"SETTLED","A18-I207514","2020-02-13 16:32:30","2020-02-13","2","2020-02-13 16:32:30","2","2020-02-13 16:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7514","RENT","\u9810\u7e73\u79df\u91d1",1,1930,"MO","1",1930,"2","2020-02-13 16:32:30","2","2020-02-13 16:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1930,0,"7514"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207162","2020-02-13 16:32:30",1930,"2","2020-02-13 16:32:30","2","2020-02-13 16:32:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7162","DEPOSIT",null,"PAID","2020-02-13 16:32:30",0,"2","2020-02-13 16:32:30","2","2020-02-13 16:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:32:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7162","INVOICE","7514","PAID","2020-02-13 16:32:30",1930,"2","2020-02-13 16:32:30","2","2020-02-13 16:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":645,"customer_code":"C170645","identity_type":"PERSONAL","identity_id":"K758362(1)","title":"Ms","lastname":"Lo","firstname":"Chi Man","companyname":"","email":"genena22@hotmail.com","tel":"91944806","address":"Flat 414, Hoy Au Lau, 30 Aberdeen Reservoir Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-27","renew_room_key":"055,32901","renew_remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit transferred from agreement A18-CT196687 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206902, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"102","order_discount":[],"order_room":[{"room_id":"951","room_code":"V25","retail_price":"3180.0","discounted_price":"3180.00","location_id":"3"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-27","rent_from":"2020-02-27","rent_to":"2020-03-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A18-CT206902 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32901","order_product":[],"pass":true}},"first_order_id":"4604","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> V25 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3180.0","deposit":"0","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","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",645,"NEW","A18-CT207187",3180,3180,0,0,"1","1",3180,3180,3180,"2020-02-13 16:38:16","0",null,null,null,"2020-02-27","2020-03-26","1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit transferred from agreement A18-CT206902 to this agreement.\r\n","2020-02-27","42",0,null,0,"0","2","2020-02-13 16:38:15","2","2020-02-13 16:38:15","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,32901","C170645","PERSONAL","Ms","+C9tc1TdnI5EfCJwPTju+g==","4w4biS+jM\/Q3DAzxHdf3pA==","","QMkWrBFC2X6lmw9G0kXHhByvUdctN4xesGoioPV7sHj0ug\/2VE3Vu0hVGC54w69582+1x9K+zMchNd7qlRGsNg==","h+d\/rmx9gukw63otAze1Lw==","1z3NagnfII+6QFgwXezQPOKHlQj6cPA1M\/NudLu\/U1M=","qSA+xbsjXbCHJxgeqBksBQ==",null,1,"4604"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","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":["7187","951","3180.0","3180.00","2","2020-02-13 16:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","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-27","2020-03-26","951"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 16:38:16","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":["7187",645,"SETTLED","A18-I207515","2020-02-13 16:38:15","2020-02-27","2","2020-02-13 16:38:15","2","2020-02-13 16:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7515","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-02-13 16:38:15","2","2020-02-13 16:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"7515"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 16:38:16","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":[645,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207163","2020-02-13 16:38:15",3180,"2","2020-02-13 16:38:15","2","2020-02-13 16:38:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","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":["7163","DEPOSIT",null,"PAID","2020-02-13 16:38:15",0,"2","2020-02-13 16:38:15","2","2020-02-13 16:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:38:16","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":["7163","INVOICE","7515","PAID","2020-02-13 16:38:15",3180,"2","2020-02-13 16:38:15","2","2020-02-13 16:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1340,"customer_code":"C191340","identity_type":"PERSONAL","identity_id":"D804254(4)","title":"Ms","lastname":"Li","firstname":"Kam Ying","companyname":"","email":"kyli70@yahoo.com.hk","tel":"91846991","address":"21\/F, Cityplaza Three, 14 Taikoo Shing Road, Taikoo Shing, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1984.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-23","renew_room_key":"190,26383","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit $4176 transferred from agreement WC-CT196097 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: WC-CT196676, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"242","order_discount":[],"order_room":[{"room_id":"1726","room_code":"WC-43","retail_price":"2088.0","discounted_price":"2088.00","location_id":"8"}],"roughly_size":"21","total_retail_price":2088,"total_discounted_price":2088,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2088,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2020-02-22","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit $4176 transferred from agreement WC-CT196676 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2088,"final_order_total":2088,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190,26383","order_product":[],"pass":true}},"first_order_id":"5521","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> WC-43 <\/td>\r\n\t\t\t\t\t 3.5X6X8 <\/td>\r\n\t\t\t\t\t $2088.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":"21","total_discounted_price":"2088.00","deposit":"0.00","total_retail_price":"2088.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","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","8",1340,"NEW","WC-CT207188",2088,2088,0,0,"1","1",2088,2088,2088,"2020-02-13 16:40:45","0",null,null,null,"2020-01-23","2020-02-22","1 month contract. Storage rental paid by PPS on February 12, 2020. Storage deposit $4176 transferred from agreement WC-CT196676 to this agreement.","2020-01-23","21",0,null,0,"0","2","2020-02-13 16:40:45","2","2020-02-13 16:40:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26383","C191340","PERSONAL","Ms","JdQzQv+uksVt7YfqRkcs2g==","7KCehmxbvwRMb+U8lHGoVA==","","Hk9QjTXPPZugpENsJNJVRFjDshAXCfqBJdXMP\/Va7d3Z2K\/aCGuUUGkjQYrRlPUPOZljB3ovRTE6wx9XrkHxgBiZiPEw1x7TWdiJCF8+iP8=","u\/RO33AxBdDZLcxr\/eihQw==","rD9Syyb4nHCPJX+uzCXhPgdBRpQS4iLmKGxvb8tt99M=","pljIbpMDyGb8muJ6+q40Nw==",null,1,"5521"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","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":["7188","1726","2088.0","2088.00","2","2020-02-13 16:40:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","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-23","2020-02-22","1726"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-13 16:40:45","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":["7188",1340,"SETTLED","WC-I207516","2020-02-13 16:40:45","2020-01-23","2","2020-02-13 16:40:45","2","2020-02-13 16:40:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7516","RENT","\u9810\u7e73\u79df\u91d1",1,2088,"MO","1",2088,"2","2020-02-13 16:40:45","2","2020-02-13 16:40:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2088,0,"7516"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-13 16:40:45","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":[1340,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207164","2020-02-13 16:40:45",2088,"2","2020-02-13 16:40:45","2","2020-02-13 16:40:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","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":["7164","DEPOSIT",null,"PAID","2020-02-13 16:40:45",0,"2","2020-02-13 16:40:45","2","2020-02-13 16:40:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-13 16:40:45","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":["7164","INVOICE","7516","PAID","2020-02-13 16:40:45",2088,"2","2020-02-13 16:40:45","2","2020-02-13 16:40:45"]},"data_before":[],"data_after":[],"step":1} *****