\n \n \n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A16-004 <\/td>\n\t\t\t\t\t	4X3X3.5 <\/td>\n\t\t\t\t\t	$668.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"602.00","deposit":"1336.00","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1487","NEW","A16-CT206999",668,602,1336,0,"6","6",4698,4948,4698,"2020-01-18 10:48:01","0",null,null,null,"2020-01-18","2020-07-17","6 months contract. Special referral bonus $250. Referred by O01 Mr Leung Yue Chau. Storage rental and deposit paid by cheque on January 11, 2020. Smartcard and padlock provided on January 11, 2020.","2020-01-18","12",0,null,250,"250.00","2","2020-01-18 10:48:01","2","2020-01-18 10:48:01","CHEQUE","","","","CHEQUE","","","",null,0,"076, 32297","C201487","PERSONAL","Ms","MnXcL0b4p+eE4SuxYrBPGQ==","yXKc2lCF323ApRADrjNaSg==","","5kixRt4Sm\/Mxyj3L\/f2YCOizAxjWbhd\/\/KvLYmyXAgU\/bclTaWWKXvZg4m4tmiuvpCz9DHywpa9N8HkS3+dPkw==","\/Iz+moYOjhs1xBpKff8ytQ==",null,"M66lCxhWGtPfzd4nHFxKmA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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":["6999","474 available_room_list_input","200","1495","%","10.04",67.0672,"2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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":["6999","1495","668.0",600.9,"2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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-18","2020-07-17","1495"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6999","A16-D205257","PAID",1336,0,"2020-07-17","2020-01-18 10:48:01","2020-01-18 10:48:01","2","2020-01-18 10:48:01","2","2020-01-18 10:48:01","1487"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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":["6999","1487","SETTLED","A16-I207327","2020-01-18 10:48:01","2020-01-18","2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,352,"MO","1",352,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u9810\u7e73\u79df\u91d1",2,602,"MO","1",602,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u9810\u7e73\u79df\u91d1",3,602,"MO","1",602,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u9810\u7e73\u79df\u91d1",4,602,"MO","1",602,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u9810\u7e73\u79df\u91d1",5,602,"MO","1",602,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7327","RENT","\u9810\u7e73\u79df\u91d1",6,602,"MO","1",602,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3362,0,"7327"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 10:48:01","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":["1487","CHEQUE","","","","CHEQUE","","","","PAID","P206976","2020-01-18 10:48:01",4698,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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":["6976","DEPOSIT","5257","PAID","2020-01-18 10:48:01",1336,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:48:01","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":["6976","INVOICE","7327","PAID","2020-01-18 10:48:01",3362,"2","2020-01-18 10:48:01","2","2020-01-18 10:48:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:50:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1182,"customer_code":"C191182","identity_type":"PERSONAL","identity_id":"D643405(4)","title":"Mr","lastname":"Cheung","firstname":"Yat Wah Louis","companyname":"","email":null,"tel":"97322829","address":"Flat C, 35\/F, Blk 4, Cheerful Gdn, Siu Sai Wan Rd, Siu Sai Wan, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"810.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-01","renew_room_key":"0012516867","renew_remark":"12 months contract. Special promotion offered, 2 months free of charge. Storage rental and deposit paid by Cash on 24 JAN 2019. Smartcard provided on 24 JAN 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194232, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $900.0","renew_master_room_id":"168","order_discount":[],"order_room":[{"room_id":"1399","room_code":"C15-093","retail_price":"900.0","discounted_price":"900.00","location_id":"6"}],"roughly_size":"12","total_retail_price":900,"total_discounted_price":900,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by Cash on Jan 18,2020. Deposit $900 transferred from agreement C15-CT194232 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":900,"final_order_total":900,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516867","order_product":[],"pass":true}},"first_order_id":4232,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-093 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $900.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"900.00","deposit":"0.00","total_retail_price":"900.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1182,"NEW","C15-CT207000",900,900,0,0,"1","1",900,900,900,"2020-01-18 10:52:51","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by Cash on Jan 18,2020. Deposit $900 transferred from agreement C15-CT194232 to this agreement.","2020-02-01","12",0,null,0,"0","2","2020-01-18 10:52:51","2","2020-01-18 10:52:51","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0012516867","C191182","PERSONAL","Mr","Vl+0Q\/2FKd5MshbAFrV6zA==","vCxOlXQuvOQaoL822H2o\/Q==","","nSjJXaYYpDuyhic12E34JihAdNIyVMmd8MiyzSQns+dN8RLxFZHkNrwHJClib1zR24i9wmhDq\/7QXH8VtfXQgZJx3tyTbEowf\/qEFX3HXEs=","hGZMTt58YQXyMflEYYzpBw==",null,"7IDa1L0fwLI6nkMvlvGl9w==",null,1,4232]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7000","1399","900.0","900.00","2","2020-01-18 10:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","1399"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7000",1182,"SETTLED","C15-I207328","2020-01-18 10:52:51","2020-02-01","2","2020-01-18 10:52:51","2","2020-01-18 10:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7328","RENT","\u9810\u7e73\u79df\u91d1",1,900,"MO","1",900,"2","2020-01-18 10:52:51","2","2020-01-18 10:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[900,0,"7328"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1182,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206977","2020-01-18 10:52:51",900,"2","2020-01-18 10:52:51","2","2020-01-18 10:52:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6977","DEPOSIT",null,"PAID","2020-01-18 10:52:51",0,"2","2020-01-18 10:52:51","2","2020-01-18 10:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 10:52:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6977","INVOICE","7328","PAID","2020-01-18 10:52:51",900,"2","2020-01-18 10:52:51","2","2020-01-18 10:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:07:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:09:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1067,"customer_code":"C181067","identity_type":"PERSONAL","identity_id":"Z805762(2)","title":"Mr","lastname":"Yip","firstname":"Lai Yin","companyname":"","email":"gu01380413@hotmail.com","tel":"60396126","address":"Room 214, Pik Long House, Shek Pai Wan Estate, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-12","renew_room_key":"0012436759","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit $3210 transferred from agreement A05-CT196525 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196659, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"116","order_discount":[],"order_room":[{"room_id":"1111","room_code":"A05-109","retail_price":"1605.0","discounted_price":"1605.00","location_id":"4"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-12","rent_from":"2020-01-12","rent_to":"2020-02-11","delivery_service":"0","remark":"1 month contract. Storage rental $1605 paid by bank transfer on January 18, 2020. Outstanding $95 will transfer to next contract. Storage deposit $3210 transferred from agreement A05-CT196659 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012436759","order_product":[],"pass":true}},"first_order_id":"3564","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-109 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1067,"NEW","A05-CT207001",1605,1605,0,0,"1","1",1605,1605,1605,"2020-01-18 11:45:42","0",null,null,null,"2020-01-12","2020-02-11","1 month contract. Storage rental $1605 paid by bank transfer on January 18, 2020. Outstanding $95 will transfer to next contract. Storage deposit $3210 transferred from agreement A05-CT196659 to this agreement. \r\n","2020-01-12","20",0,null,0,"0","2","2020-01-18 11:45:41","2","2020-01-18 11:45:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012436759","C181067","PERSONAL","Mr","DslEpAGTlvzwRhXWzd3GTQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","m4rpeseyC+3XbEZyki2sZe8nBXUNRhxQsygvVPRrHuh9JuMqbXLWzl\/BfY8qGZS6DRiHyjvCbg\/6kE8K2OncZQ==","fywBBIIwzINfMGd5TWlOxw==","WwudnjXvrdBb2Ykc6EFFLev8id0sdCyvkKSmhESkEzs=","e7I4cjG99z4ybwV1aES9ng==",null,1,"3564"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7001","1111","1605.0","1605.00","2","2020-01-18 11:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-12","2020-02-11","1111"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7001",1067,"SETTLED","A05-I207329","2020-01-18 11:45:41","2020-01-12","2","2020-01-18 11:45:41","2","2020-01-18 11:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7329","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-01-18 11:45:41","2","2020-01-18 11:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"7329"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1067,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206978","2020-01-18 11:45:41",1605,"2","2020-01-18 11:45:41","2","2020-01-18 11:45:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6978","DEPOSIT",null,"PAID","2020-01-18 11:45:41",0,"2","2020-01-18 11:45:41","2","2020-01-18 11:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:45:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6978","INVOICE","7329","PAID","2020-01-18 11:45:41",1605,"2","2020-01-18 11:45:41","2","2020-01-18 11:45:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1253,"customer_code":"C191253","identity_type":"PERSONAL","identity_id":"H458006(2)","title":"Ms","lastname":"Shek","firstname":"Yu Yum","companyname":"","email":"reginashek@yahoo.com.hk","tel":"96831737","address":"No.1, 3\/F, Block P, Mei Kwong 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":"737.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-19","renew_room_key":"076,47747","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 18, 2019. Storage deposit $1550 transferred from agreement A14-CT194775 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196179, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"654","room_code":"M65","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-19","rent_from":"2020-01-19","rent_to":"2020-07-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 17, 2020. Storage deposit $1550 transferred from agreement A14-CT196179 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4188,"final_order_total":4188,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,47747","order_product":[],"pass":true}},"first_order_id":"4775","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> M65 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.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":"9","total_discounted_price":"698","deposit":"0.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1253,"NEW","A14-CT207002",775,698,0,0,"6","6",4188,4188,4188,"2020-01-18 11:52:18","0",null,null,null,"2020-01-19","2020-07-18","6 months contract. Storage rental paid by bank transfer on January 17, 2020. Storage deposit $1550 transferred from agreement A14-CT196179 to this agreement. \r\n","2020-01-19","9",0,null,0,"0","2","2020-01-18 11:52:18","2","2020-01-18 11:52:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47747","C191253","PERSONAL","Ms","hwOB76TP6UwYOmgcOzKxRA==","FMg\/v\/AExrp7na7g12DvHA==","","qxutNsGy+G0Ht\/opgjGZ+\/+r5pB2QW0JW5UTA2CKeBAvEfHv9M4RGPLjb19krVr+BYdaxWNMV1S8p\/BsuoxhITzU4uyuAfGWWqmEQVttlwo=","3IJRukeSCJhUm5A\/uSkbAg==","pgxdeFnriaUj3gYrdV8y5Oo1JlhZbbPY0YBOVFDikxc=","GDb\/zcKDoU\/+wWIPzAbFDg==",null,1,"4775"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7002","654","775.0","775.00","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-19","2020-07-18","654"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002",1253,"SETTLED","A14-I207330","2020-01-18 11:52:18","2020-01-19","2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7330","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4188,0,"7330"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1253,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206979","2020-01-18 11:52:18",4188,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6979","DEPOSIT",null,"PAID","2020-01-18 11:52:18",0,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 11:52:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6979","INVOICE","7330","PAID","2020-01-18 11:52:18",4188,"2","2020-01-18 11:52:18","2","2020-01-18 11:52:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:27:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1100,"customer_code":"C181100","identity_type":"PERSONAL","identity_id":"D251011(2)","title":"Mr","lastname":"Chan","firstname":"Fook Hoi","companyname":"","email":null,"tel":"61984048","address":"Flat C, 14\/F, Block 6, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-21","renew_room_key":"088, 40016","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 1, 2019. Storage deposit $2196 transferred from agreement A12-CT194201 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195606, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"27","room_code":"A27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"989.00","warehousing_date":"2020-01-21","rent_from":"2020-01-21","rent_to":"2021-02-20","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by Cheque on January 18, 2020. Storage deposit $2196 transferred from agreement A12-CT195606 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":989,"order_total":12857,"final_order_total":11868,"location_id":"1","branch_id":"1","company_id":"1","room_key":"088, 40016","order_product":[],"pass":true}},"first_order_id":"4201","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> A27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1100,"NEW","A12-CT207003",1098,989,0,0,"13","13",11868,12857,11868,"2020-01-18 12:31:51","0",null,null,null,"2020-01-21","2021-02-20","13 months contract. Special offer the 13th month free. Storage rental paid by Cheque on January 18, 2020. Storage deposit $2196 transferred from agreement A12-CT195606 to this agreement.","2020-01-21","16",0,null,989,"989.00","2","2020-01-18 12:31:50","2","2020-01-18 12:31:50","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"088, 40016","C181100","PERSONAL","Mr","g8MCjwABjOifj96TIeJptw==","U9yoE9KqV1v8YlRkf7Q2yg==","","aAbcMlljyKkkYL9O\/COoHVJ5lrZQxTKtOnN0FEsPoLKePZfw6R7x\/4AkzsTaW2udQjpMAKtRbZ7xe6vZ7OmEkg==","UC4yJ4ClXODkAfsnn0\/l7w==",null,"rD0rSKurl6yYo998uuGFNw==",null,1,"4201"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7003","27","1098.0","1098.00","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-21","2021-02-20","27"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7003",1100,"SETTLED","A12-I207331","2020-01-18 12:31:50","2020-01-21","2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7331","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11868,0,"7331"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1100,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206980","2020-01-18 12:31:50",11868,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6980","DEPOSIT",null,"PAID","2020-01-18 12:31:50",0,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 12:31:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6980","INVOICE","7331","PAID","2020-01-18 12:31:50",11868,"2","2020-01-18 12:31:50","2","2020-01-18 12:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:00:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":680,"customer_code":"C180680","identity_type":"PERSONAL","identity_id":"D022670(0)","title":"Ms","lastname":"Fong","firstname":"Lai Kuen","companyname":"","email":"tammy35c18@yahoo.com.hk","tel":"96311545","address":"Flat C, 35\/F, Block 19, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3598.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-20","renew_room_key":"134, 32840","renew_remark":"12 months contract. Storage rental paid by cheque on Jan 21, 2018. Storage deposit transferred from agreement SD18-CT182319 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194207, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[],"order_room":[{"room_id":"895","room_code":"Y24","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"},{"room_id":"896","room_code":"Y25","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"},{"room_id":"938","room_code":"V12(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"3"}],"roughly_size":"45.6","total_retail_price":3953,"total_discounted_price":3598,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":43176,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3598","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2021-02-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on Jan 18, 2020. Storage deposit transferred from agreement A18-CT194207 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194207, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3598,"order_total":46774,"final_order_total":43176,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134, 32840","order_product":[],"pass":true}},"first_order_id":4207,"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 \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> Y24 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> Y25 <\/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> V12(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.4X7 <\/td>\r\n\t\t\t\t\t $1058.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":"45.6","total_discounted_price":"3598","deposit":"0.00","total_retail_price":"3953.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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","3",680,"NEW","A18-CT207004",3953,3598,0,0,"13","13",43176,46774,43176,"2020-01-18 13:10:20","0",null,null,null,"2020-01-20","2021-02-19","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on Jan 18, 2020. Storage deposit transferred from agreement A18-CT194207 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194207, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2020-01-20","45.6",0,null,3598,"3598","2","2020-01-18 13:10:19","2","2020-01-18 13:10:19","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"134, 32840","C180680","PERSONAL","Ms","JphGS\/brYQPKm9VXMi77qA==","0Nayu53KnmOkfvcFcxRq7g==","","nSjJXaYYpDuyhic12E34JtKmH014cmWwG3ZZ+nOOovqxF6ebgfJG7cL04IinvlFC2y7E3MCdjG93x\/vqySdiPQ==","SE9FKKXoXa49DWEk0MnYmw==","caLmAhUQebfZJG06R\/8t213lro3850Jc5aQBNpnsU8k=","MmnMyxQkVOKHd2JNSjpztA==",null,1,4207]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7004","895","1605.0","1605.00","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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-01-20","2021-02-19","895"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 13:10: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":["7004","896","1290.0","1290.00","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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-01-20","2021-02-19","896"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 13:10: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":["7004","938","1058.0","1058.00","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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-01-20","2021-02-19","938"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 13:10: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":["7004",680,"SETTLED","A18-I207332","2020-01-18 13:10:19","2020-01-20","2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",3,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",4,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",5,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",6,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",7,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",8,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",9,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",10,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",11,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",12,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["7332","RENT","\u9810\u7e73\u79df\u91d1",13,3598,"MO","1",3598,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[43176,0,"7332"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 13:10: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":[680,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206981","2020-01-18 13:10:19",43176,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["6981","DEPOSIT",null,"PAID","2020-01-18 13:10:19",0,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:10: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":["6981","INVOICE","7332","PAID","2020-01-18 13:10:19",43176,"2","2020-01-18 13:10:19","2","2020-01-18 13:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:26:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1335","master_room_id":"175","room_code":"C15-029"}],"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> C15-029 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z915532(6)","title":"Mr","lastname":"YIU","firstname":"Kai Chung","companyname":"","email":"yco712@gmail.com","tel":"92342848","address":"Flat A, 12\/F, Tw 7, Greenwood Terrace, Chai Wan","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"446","master_room_id":"175","discount_type":"%","price":"1798.00","disocunted_price":"1349.90","discount":"24.92","monthly_deduct":448.0616,"room_id":"1335","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1335","room_code":"C15-029","retail_price":"1798.0","discounted_price":1349.9,"location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1619,"deposit":1798,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16478,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4748.00","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-01-31","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free and 5% discount, $200 switch to us offer. Storage rental and deposit paid by PayMe on Jan 18,2020. Extra 1.5%($248) charge. Smartcard paid on Jan 18,2020.","paymethod":"OTHER","paymethod_other":"PayMe","paymethod2":"OTHER","paymethod_other2":"PayMe","discount_deduct":4748,"order_total":21286,"final_order_total":16538,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005921001","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"32","total_discounted_price":"1619.00","deposit":"1798.00","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201490","PERSONAL","Mr","aMcpa76RY8Rd+iqdpB0SUA==","XuluTrV8xQvzReSYkiOPMw==","","M85BTtMvOJW9kuRXegoR4w==","JP4VVQfQuhK0cuJlUx3a4ZtGFyTkgP1XCSyX25tCoNY=","4eC9vxq4FmPcR6ulA3MuqF\/uGWZtUNcidKNCvqwZKPzklrG98FNMv95YyZmlm2cP","74mSiL\/amKdkPJ191lcccA==",null,"JP4VVQfQuhK0cuJlUx3a4ZtGFyTkgP1XCSyX25tCoNY=","0q8Rw+TpwDYba7M14eUxbw==","2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1490,"NEW","C15-CT207005",1798,1619,1798,0,"12","12",16478,21286,16538,"2020-01-18 13:54:42","0",null,null,null,"2020-02-01","2021-01-31","12 months contract. Special offer the 11th and 12th month free and 5% discount, $200 switch to us offer. Storage rental and deposit paid by PayMe on Jan 18,2020. Extra 1.5%($248) charge. Smartcard paid on Jan 18,2020.","2020-02-01","32",0,null,4748,"4748.00","2","2020-01-18 13:54:40","2","2020-01-18 13:54:40","OTHER","","","PayMe","OTHER","","","PayMe",null,0,"0005921001","C201490","PERSONAL","Mr","aMcpa76RY8Rd+iqdpB0SUA==","XuluTrV8xQvzReSYkiOPMw==","","4eC9vxq4FmPcR6ulA3MuqF\/uGWZtUNcidKNCvqwZKPzklrG98FNMv95YyZmlm2cP","M85BTtMvOJW9kuRXegoR4w==","JP4VVQfQuhK0cuJlUx3a4ZtGFyTkgP1XCSyX25tCoNY=","74mSiL\/amKdkPJ191lcccA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7005","446","175","1335","%","24.92",448.0616,"2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7005",1490,"11","1","60.0",60,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7005"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7005","1335","1798.0",1349.9,"2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-01-31","1335"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7005","C15-D205258","PAID",1798,0,"2021-01-31","2020-01-18 13:54:40","2020-01-18 13:54:40","2","2020-01-18 13:54:40","2","2020-01-18 13:54:40",1490]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7005",1490,"SETTLED","C15-I207333","2020-01-18 13:54:40","2020-02-01","2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,109,"MO","1",109,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",4,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",5,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",6,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",7,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",8,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",9,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",10,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",11,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","RENT","\u9810\u7e73\u79df\u91d1",12,1619,"MO","1",1619,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14740,0,"7333"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1490,"OTHER","","","PayMe","OTHER","","","PayMe","PAID","P206982","2020-01-18 13:54:40",16538,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6982","DEPOSIT","5258","PAID","2020-01-18 13:54:40",1798,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 13:54:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6982","INVOICE","7333","PAID","2020-01-18 13:54:40",14740,"2","2020-01-18 13:54:40","2","2020-01-18 13:54:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:04:38","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0005921001","12 months contract. Special offer the 11th and 12th month free and 5% discount, $200 switch to us offer and $500 deposit paid. Storage rental and deposit paid by PayMe on Jan 18,2020. Extra 1.5%($248) charge. Smartcard paid on Jan 18,2020.","2020-01-18 14:04:38","2","XuluTrV8xQvzReSYkiOPMw==","aMcpa76RY8Rd+iqdpB0SUA==","JP4VVQfQuhK0cuJlUx3a4ZtGFyTkgP1XCSyX25tCoNY=","M85BTtMvOJW9kuRXegoR4w==","4eC9vxq4FmPcR6ulA3MuqF\/uGWZtUNcidKNCvqwZKPzklrG98FNMv95YyZmlm2cP",7005]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:15:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":740,"customer_code":"C180740","identity_type":"PERSONAL","identity_id":"D655955(8)","title":"Ms","lastname":"Fong","firstname":"Yuk Kuen","companyname":"","email":"fongyk1129@gmail.com","tel":"93015403","address":"Flat H, 20\/F, Nan Shan Mansion, Kao Shan Terrace, Taikoo, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-27","renew_room_key":"053,40672","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 22, 2019. Storage deposit transferred from agreement A18-CT194211 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195529, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"948","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"948","room_code":"V22","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-07-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 18, 2020. Storage deposit transferred from agreement A18-CT195529 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,40672","order_product":[],"pass":true}},"first_order_id":"4211","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> V22 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",740,"NEW","A18-CT207006",1290,1162,0,0,"6","6",6972,6972,6972,"2020-01-18 14:24:06","0",null,null,null,"2020-01-27","2020-07-26","6 months contract. Storage rental paid by bank transfer on January 18, 2020. Storage deposit transferred from agreement A18-CT195529 to this agreement.","2020-01-27","16",0,null,0,"0","2","2020-01-18 14:24:05","2","2020-01-18 14:24:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,40672","C180740","PERSONAL","Ms","ETiIi++\/aBBTbM0Z0+7ATw==","0Nayu53KnmOkfvcFcxRq7g==","","+pVl+6Y5ofoxKd9dtyfxjBoMrGffHtdRf\/a\/vqxjMoM84\/jnEdTqAtwDVqCBtGS5LqlzdcNIvpWSwhjabVD0rH\/sfWuouc7e0UrlzbHEp30=","R6VxrMZRqH\/0c9shtTmFww==","piSM0YPBpkHL0i43yyxPSWPqIih1a3Ae8qBWcPIoZLg=","xJsP2busfkT7hAiJ10ZKXw==",null,1,"4211"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","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":["7006","250","91","948","%","10.00",129,"2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7006","948","1290.0",1161,"2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-27","2020-07-26","948"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7006",740,"SETTLED","A18-I207334","2020-01-18 14:24:05","2020-01-27","2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7334"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[740,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206983","2020-01-18 14:24:05",6972,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6983","DEPOSIT",null,"PAID","2020-01-18 14:24:05",0,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:24:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6983","INVOICE","7334","PAID","2020-01-18 14:24:05",6972,"2","2020-01-18 14:24:05","2","2020-01-18 14:24:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 14:33:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:48:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"type=INVOICE&filter1=0&filter2=1180&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"56368804","title":"Ms","lastname":"WONG","firstname":"Ms","companyname":"Bricks N Stones Company","email":"","tel":"92239650","address":"Rm 1003, 10\/F, Keen Hung Commercial Building, 80 Queen's Road East, Wan Chai, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1489","room_code":"C15-183","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"16.25","total_retail_price":1108,"total_discounted_price":998,"deposit":1108,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2896.00","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2021-01-19","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free, 5% rent now discount and $200 referral bonus, $200 switch to us offer. Storage rental and deposit paid by cheque on Jan 18,2020. Smartcard paid on Jan 18,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2896,"order_total":13144,"final_order_total":10248,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012473835","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> C15-183 <\/td>\n\t\t\t\t\t 6.5X2.5X6.5 <\/td>\n\t\t\t\t\t $1108.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16.25","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201491","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","ddrfzAYTmkL\/QNu3psjONQ==","Bricks N Stones Company","0qx8PcZUOMA+vYzzfy0gqg==",null,"MKMvc4DwQ+RxeJaIJL9dGQhXrA79nbsKGGo2JDiIXAJ6AjEZO\/e5xU2UhOYt94Egb38isI+LnItuFzDm7WoYbO5RezjbIYvBJRCzIoWTu1XyeL9cwhO+u4kvuwaCvHe1",null,"mzBkUIO3g4FsIDzPJlFUVw==",null,"5Fl9DnyrGc9cL9bBPwQQew==","2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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","3","6",1491,"NEW","C15-CT207007",1108,998,1108,0,"12","12",10188,13144,10248,"2020-01-18 15:49:56","0",null,null,null,"2020-01-20","2021-01-19","12 months contract. Special offer the 11th and 12th month free, 5% rent now discount and $200 referral bonus, $200 switch to us offer. Storage rental and deposit paid by cheque on Jan 18,2020. Smartcard paid on Jan 18,2020.","2020-01-20","16.25",0,null,2896,"2896.00","2","2020-01-18 15:49:53","2","2020-01-18 15:49:53","CHEQUE","","","","CHEQUE","","","",null,0,"0012473835","C201491","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","ddrfzAYTmkL\/QNu3psjONQ==","Bricks N Stones Company","MKMvc4DwQ+RxeJaIJL9dGQhXrA79nbsKGGo2JDiIXAJ6AjEZO\/e5xU2UhOYt94Egb38isI+LnItuFzDm7WoYbO5RezjbIYvBJRCzIoWTu1XyeL9cwhO+u4kvuwaCvHe1","0qx8PcZUOMA+vYzzfy0gqg==",null,null,"mzBkUIO3g4FsIDzPJlFUVw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7007",1491,"11","1","60.0",60,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7007"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-01-18 15:49: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":["7007","1489","1108.0","1108.00","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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-01-20","2021-01-19","1489"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7007","C15-D205259","PAID",1108,0,"2021-01-19","2020-01-18 15:49:53","2020-01-18 15:49:53","2","2020-01-18 15:49:53","2","2020-01-18 15:49:53",1491]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7007",1491,"SETTLED","C15-I207335","2020-01-18 15:49:53","2020-01-20","2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,98,"MO","1",98,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["7335","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7335","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9140,0,"7335"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-18 15:49: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":[1491,"CHEQUE","","","","CHEQUE","","","","PAID","P206984","2020-01-18 15:49:53",10248,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["6984","DEPOSIT","5259","PAID","2020-01-18 15:49:53",1108,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-18 15:49: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":["6984","INVOICE","7335","PAID","2020-01-18 15:49:53",9140,"2","2020-01-18 15:49:53","2","2020-01-18 15:49:53"]},"data_before":[],"data_after":[],"step":1} *****