{"created_at":"2020-01-11 10:01:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 10:44:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 10:56:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1499","master_room_id":"200","room_code":"A16-008"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A16-008 <\/td>\r\n\t\t\t\t\t	4X3X3.5 <\/td>\r\n\t\t\t\t\t	$668.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D800782(A)","title":"Ms","lastname":"LEUNG","firstname":"Pui Nin Karin","companyname":"","email":"","tel":"94816841","address":"Block G-1, 5\/F, Kong Cheung Court, Aberdeen Centre, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"474","master_room_id":"200","discount_type":"%","price":"668.00","disocunted_price":"600.90","discount":"10.04","monthly_deduct":67.0672,"room_id":"1499","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1499","room_code":"A16-008","retail_price":"668.0","discounted_price":600.9,"location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":602,"deposit":1336,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4698,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"250.00","warehousing_date":"2020-01-18","rent_from":"2020-01-18","rent_to":"2020-07-17","delivery_service":"0","remark":"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.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":250,"order_total":4948,"final_order_total":4698,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076, 32297","order_product":[],"pass":true}},"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-11 11:01:45","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":["C201487","PERSONAL","Ms","MnXcL0b4p+eE4SuxYrBPGQ==","yXKc2lCF323ApRADrjNaSg==","","\/Iz+moYOjhs1xBpKff8ytQ==",null,"5kixRt4Sm\/Mxyj3L\/f2YCOizAxjWbhd\/\/KvLYmyXAgU\/bclTaWWKXvZg4m4tmiuvpCz9DHywpa9N8HkS3+dPkw==","M66lCxhWGtPfzd4nHFxKmA==",null,null,"vVUVrUKq0Ls4flr5i2bqYg==","2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1487,"NEW","A16-CT206929",668,602,1336,0,"6","6",4698,4948,4698,"2020-01-11 11:01:45","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-11 11:01:43","2","2020-01-11 11:01:43","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-11 11:01:45","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":["6929","474","200","1499","%","10.04",67.0672,"2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6929","1499","668.0",600.9,"2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-18","2020-07-17","1499"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 11:01:45","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":["6929","A16-D205247","PAID",1336,0,"2020-07-17","2020-01-11 11:01:43","2020-01-11 11:01:43","2","2020-01-11 11:01:43","2","2020-01-11 11:01:43",1487]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6929",1487,"SETTLED","A16-I207257","2020-01-11 11:01:43","2020-01-18","2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,352,"MO","1",352,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u9810\u7e73\u79df\u91d1",2,602,"MO","1",602,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u9810\u7e73\u79df\u91d1",3,602,"MO","1",602,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u9810\u7e73\u79df\u91d1",4,602,"MO","1",602,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u9810\u7e73\u79df\u91d1",5,602,"MO","1",602,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7257","RENT","\u9810\u7e73\u79df\u91d1",6,602,"MO","1",602,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3362,0,"7257"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1487,"CHEQUE","","","","CHEQUE","","","","PAID","P206907","2020-01-11 11:01:43",4698,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6907","DEPOSIT","5247","PAID","2020-01-11 11:01:43",1336,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:01:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6907","INVOICE","7257","PAID","2020-01-11 11:01:43",3362,"2","2020-01-11 11:01:43","2","2020-01-11 11:01:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:06:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE","floor_plan_rent_room":[{"room_id":"1499","master_room_id":"200","room_code":"A16-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":568,"customer_code":"C170568","identity_type":"PERSONAL","identity_id":"Z717142(1)","title":"Ms","lastname":"Tsang","firstname":"Ho Chi Vanessa","companyname":"","email":"vanesstsang2004@yahoo.com.hk","tel":"98516603","address":"\u9d28\u4fd0\u6d32\u897f\u90a8\u6eff\u6a13\u9ad8\u5ea7713\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-23","renew_room_key":"055,30097","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 15, 2019. Storage deposit transferred from agreement A14-CT195541 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196147, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"605","room_code":"M16","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2020-04-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT196147 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,30097","order_product":[],"pass":true}},"first_order_id":"4841","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> M16 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",568,"NEW","A14-CT206930",598,598,0,0,"3","3",1794,1794,1794,"2020-01-11 11:26:29","0",null,null,null,"2020-01-23","2020-04-22","3 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT196147 to this agreement.\r\n\r\n","2020-01-23","12",0,null,0,"0","2","2020-01-11 11:26:29","2","2020-01-11 11:26:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,30097","C170568","PERSONAL","Ms","7MOqajdwYzHit6g2kTtD7A==","SrBvL8bV9b3Cq\/EiAmR0Dg==","","QBtluAbjs46o3pj2eYP82bksSj3KpKOUAFmYYMmiEw3pagWWSTNhpYQomkchhFfv","+Ors2BIWN5DgpaYofWiIVQ==","xKX8azyMAdrpn7VRqKS6W5fMsVLi+vBoaI6JB7mcre4=","bUN\/2CnRfQKHXu4h0SyBVg==",null,1,"4841"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6930","605","598.0","598.00","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-23","2020-04-22","605"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6930",568,"SETTLED","A14-I207258","2020-01-11 11:26:29","2020-01-23","2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,0,"7258"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[568,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206908","2020-01-11 11:26:29",1794,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6908","DEPOSIT",null,"PAID","2020-01-11 11:26:29",0,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:26:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6908","INVOICE","7258","PAID","2020-01-11 11:26:29",1794,"2","2020-01-11 11:26:29","2","2020-01-11 11:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:29:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE","floor_plan_rent_room":[{"room_id":"1499","master_room_id":"200","room_code":"A16-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":357,"customer_code":"C170357","identity_type":"PERSONAL","identity_id":"K200528(A)","title":"Ms","lastname":"So","firstname":"Bik Yan","companyname":"","email":"Bettyso2010@hotmail.com","tel":"61890200","address":"\u9999\u6e2f\u4ed4\u9d28\u8137\u6d32\u897f\u6751\u5229\u798f\u6a13\u9ad8\u5ea79\u6a1312\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-14","renew_room_key":"052,56559\/054,01889","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit transferred from agreement A14-CT196384 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196675, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"514","room_code":"K51","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-14","rent_from":"2020-01-14","rent_to":"2020-02-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT196675 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,56559\/054,01889","order_product":[],"pass":true}},"first_order_id":"3602","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> K51 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",357,"NEW","A14-CT206931",1098,1038,0,0,"1","1",1038,1038,1038,"2020-01-11 11:31:25","0",null,null,null,"2020-01-14","2020-02-13","1 month contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT196675 to this agreement.\r\n","2020-01-14","16",0,null,0,"0","2","2020-01-11 11:31:25","2","2020-01-11 11:31:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,56559\/054,01889","C170357","PERSONAL","Ms","Xm\/QexF8eZtTsSb8L38jDQ==","4x5vYEKSVRSuDm5I8YHOGA==","","iaMKHy8smhToDNlD2lpct7apbVifxmEzETQX4zzdkIWbv1n1\/bqXIgSPJ9SuXJYQpspqWP8NAGG1MTx8\/3lieQ==","+3tfr98clfpe3pm59uql3Q==","oYq5\/GECL57LsJqAl8dH7KilbaFGbc5z+OZxfLZDi7A=","LEynVVsVuI2leNikh3mN3A==",null,1,"3602"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6931","514","1098.0","1098.00","2","2020-01-11 11:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-14","2020-02-13","514"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6931",357,"SETTLED","A14-I207259","2020-01-11 11:31:25","2020-01-14","2","2020-01-11 11:31:25","2","2020-01-11 11:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7259","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-01-11 11:31:25","2","2020-01-11 11:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7259"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[357,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206909","2020-01-11 11:31:25",1038,"2","2020-01-11 11:31:25","2","2020-01-11 11:31:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6909","DEPOSIT",null,"PAID","2020-01-11 11:31:25",0,"2","2020-01-11 11:31:25","2","2020-01-11 11:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6909","INVOICE","7259","PAID","2020-01-11 11:31:25",1038,"2","2020-01-11 11:31:25","2","2020-01-11 11:31:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:40:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:41:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 11:53:11","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","056,19685","13 months contract. Special offer the 13 month free. Storage rental paid by bank transfer on December 13, 2019. Storage deposit transferred from agreement A18-CT183944 to this agreement.","2020-01-11 11:53:11","2","+pNULpsInm3siHASV0hIrg==","3JNLQh67h8IOVnWCv04Dcw==","95D\/+rP0lzM1D8dMQKphtJnYguSoTolubpuD2O1mRio=","n+iW+bT6CnzlBZxFRCyKuA==","ne5GVtxTRsc1\/DEl\/+jiLv1qq3vXkwaSOK\/BXcQ6qGFmxWhkJDMbN5q96HA8+Uc7j8u7LxssCoA+ewFo46uYxvwvP1QB1Cvm7Uk7NCkADVg=",6690]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"type=INVOICE","floor_plan_rent_room":[{"room_id":"1499","master_room_id":"200","room_code":"A16-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1365,"customer_code":"C191365","identity_type":"PERSONAL","identity_id":"H029496(0)","title":"Ms","lastname":"Wong","firstname":"Tin Wai","companyname":"","email":null,"tel":"62322149","address":"Flat 7, 7\/F, Yuet Chui Court, 9 Yan Tsui Street, Chai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2060.0","renew_rent_month":"5","renew_warehousing_date":"2020-01-16","renew_room_key":"0005887860","renew_remark":"5 months contract. Special offer, 5% off. Paid $1000 by cash on August 7, 2019. Remaining storage rental and deposit (ttl: $11013) and transportation fee ($2600) paid by bank transfer on August 15, 2019. Smartcard provided on August 16, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195725, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2168.0","renew_master_room_id":"191","order_discount":[],"order_room":[{"room_id":"1392","room_code":"C15-086","retail_price":"2168.0","discounted_price":"2168.00","location_id":"6"}],"roughly_size":"40.05","total_retail_price":2168,"total_discounted_price":2060,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2060,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-02-15","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on 10 January 2020. Storage deposit $2,168 tranferred from agreement C15-CT195725 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195725, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2168.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2060,"final_order_total":2060,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005887860","order_product":[],"pass":true}},"first_order_id":5725,"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-086 <\/td>\r\n\t\t\t\t\t 8.9X4.5X6.5 <\/td>\r\n\t\t\t\t\t $2168.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":"40.05","total_discounted_price":"2060.00","deposit":"0.00","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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","3","6",1365,"NEW","C15-CT206932",2168,2060,0,0,"1","1",2060,2060,2060,"2020-01-11 12:34:18","0",null,null,null,"2020-01-16","2020-02-15","1 months contract. Storage rental paid by bank transfer on 10 January 2020. Storage deposit $2,168 tranferred from agreement C15-CT195725 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195725, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2168.0","2020-01-16","40.05",0,null,0,"0","2","2020-01-11 12:34:18","2","2020-01-11 12:34:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005887860","C191365","PERSONAL","Ms","oT4iX+WW5Rj9tZBI4TD+IA==","hULSwM2MvFtpeV9\/z+er8Q==","","DnLAndlBJVpuzCb6Y1cbOSdOxHj1QCMhne6uk1RQxQxQRlCCh9FlbxGAztsLqDHfhqCFwlZfJsI4DBvK4NAYShd0YpmorprervefWdYB\/Dc=","HL7kEw3rkwBabVuarQElyw==",null,"2j789gSu5+fdMN+3dhnjww==",null,1,5725]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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":["6932","1392","2168.0","2168.00","2","2020-01-11 12:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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-16","2020-02-15","1392"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 12:34: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":["6932",1365,"SETTLED","C15-I207260","2020-01-11 12:34:18","2020-01-16","2","2020-01-11 12:34:18","2","2020-01-11 12:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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":["7260","RENT","\u9810\u7e73\u79df\u91d1",1,2060,"MO","1",2060,"2","2020-01-11 12:34:18","2","2020-01-11 12:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2060,0,"7260"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 12:34: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":[1365,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206910","2020-01-11 12:34:18",2060,"2","2020-01-11 12:34:18","2","2020-01-11 12:34:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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":["6910","DEPOSIT",null,"PAID","2020-01-11 12:34:18",0,"2","2020-01-11 12:34:18","2","2020-01-11 12:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:34: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":["6910","INVOICE","7260","PAID","2020-01-11 12:34:18",2060,"2","2020-01-11 12:34:18","2","2020-01-11 12:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:42:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=448&filter3=undefined","floor_plan_rent_room":[{"room_id":"1499","master_room_id":"200","room_code":"A16-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-15","renew_room_key":"053,46811","renew_remark":"1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A14-CT196475 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206863, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"549","room_code":"L27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"548","room_code":"L26","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-02-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 10, 2020. Storage deposit transferred from agreement A14-CT206863 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"4790","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L26 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",448,"NEW","A14-CT206933",2196,2022,0,0,"1","1",2022,2022,2022,"2020-01-11 12:44:07","0",null,null,null,"2020-01-15","2020-02-14","1 month contract. Storage rental paid by PPS on January 10, 2020. Storage deposit transferred from agreement A14-CT206863 to this agreement.\r\n","2020-01-15","32",0,null,0,"0","2","2020-01-11 12:44:06","2","2020-01-11 12:44:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6933","549","1098.0","1098.00","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2020-02-14","549"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6933","548","1098.0","1098.00","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-15","2020-02-14","548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6933",448,"SETTLED","A14-I207261","2020-01-11 12:44:06","2020-01-15","2","2020-01-11 12:44:06","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7261","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-01-11 12:44:06","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"7261"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206911","2020-01-11 12:44:06",2022,"2","2020-01-11 12:44:06","2","2020-01-11 12:44:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6911","DEPOSIT",null,"PAID","2020-01-11 12:44:06",0,"2","2020-01-11 12:44:06","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:44:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6911","INVOICE","7261","PAID","2020-01-11 12:44:06",2022,"2","2020-01-11 12:44:06","2","2020-01-11 12:44:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:45:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:50:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:50:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=1333&filter3=undefined","floor_plan_rent_room":[{"room_id":"1308","master_room_id":"164","room_code":"C15-002"}],"_payment_type":"INVOICE","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> U04 <\/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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1333,"customer_code":"C191333","identity_type":"PERSONAL","identity_id":"G697952(0)","title":"Mr","lastname":"Tong","firstname":"Cho Yiu","companyname":"","email":null,"tel":"98780701","address":"Flat 122, Shun Fung Lau, Yue Kwong Chuen, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-17","renew_room_key":"190,40473","renew_remark":"6 months contract. Storage rental and deposit paid by EPS on 17 July,2019. Smartcard and padlock provided on 17 July,2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195498, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"903","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"903","room_code":"U04","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-17","rent_from":"2020-01-17","rent_to":"2020-07-16","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 10, 2020. Storage deposit $3210 transferred from agreement A18-CT195498 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40473","order_product":[],"pass":true}},"first_order_id":5498,"roughly_size":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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",1333,"NEW","A18-CT206934",1605,1445,0,0,"6","6",8670,8670,8670,"2020-01-11 12:51:09","0",null,null,null,"2020-01-17","2020-07-16","6 months contract. Storage rental paid by PPS on January 10, 2020. Storage deposit $3210 transferred from agreement A18-CT195498 to this agreement. ","2020-01-17","20",0,null,0,"0","2","2020-01-11 12:51:08","2","2020-01-11 12:51:08","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,40473","C191333","PERSONAL","Mr","\/MbMIeNajULhOZB9Zv62eA==","Qp1TF1vpW8QLcMS5hgEDYQ==","","1hMv\/bIVpIeknjv4j5uWzs9Z8y4SqfnIkh2a2DlsHPZFIc7KrWbA5hZcrqiDOhYDaRFHcJ4PuVfDQMq97NvP1w==","Y9IYTyqVSXTdXDrNxkds0Q==",null,"cTPrDbBc72JAOZbcoUTOSg==",null,1,5498]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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":["6934","254","78","903","%","10.00",160.5,"2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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":["6934","903","1605.0",1444.5,"2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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-17","2020-07-16","903"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 12:51:09","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":["6934",1333,"SETTLED","A18-I207262","2020-01-11 12:51:08","2020-01-17","2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"7262"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 12:51:09","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":[1333,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206912","2020-01-11 12:51:08",8670,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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":["6912","DEPOSIT",null,"PAID","2020-01-11 12:51:08",0,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 12:51:09","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":["6912","INVOICE","7262","PAID","2020-01-11 12:51:08",8670,"2","2020-01-11 12:51:08","2","2020-01-11 12:51:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=1333&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1308","master_room_id":"164","room_code":"C15-002"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-002 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D160879(8)","title":"Ms","lastname":"CHEUNG","firstname":"Siu Ping","companyname":"","email":"","tel":"62972316","address":"11D, Jade Mansion, 32 Fort Street, North Point, HK","pass":true,"customer_id":"1281","customer_code":"C191281","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1308","room_code":"C15-002","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":696,"deposit":773,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3627,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1322.00","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-07-15","delivery_service":"0","remark":"6 months contract. Change unit from C15-171 to C15-002. Storage deposit $1322 transferred from agreement C15-CT196059 to this agreement. Remaining storage rental and deposit $3627 paid by PPS on January 10, 2020. ","paymethod":"PPS","paymethod2":"PPS","discount_deduct":1322,"order_total":4949,"final_order_total":3627,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012403592","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"696.00","deposit":"773","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1281","NEW","C15-CT206935",773,696,773,0,"6","6",3627,4949,3627,"2020-01-11 13:04:51","0",null,null,null,"2020-01-16","2020-07-15","6 months contract. Change unit from C15-171 to C15-002. Storage deposit $1322 transferred from agreement C15-CT196059 to this agreement. Remaining storage rental and deposit $3627 paid by PPS on January 10, 2020. ","2020-01-16","10",0,null,1322,"1322.00","2","2020-01-11 13:04:50","2","2020-01-11 13:04:50","PPS","","","","PPS","","","",null,0,"'0012403592","C191281","PERSONAL","Ms","cFmyi84\/8cOtadX9t1nKXw==","ts1WQ6NWxfSAyKGz8YWojw==","","kdQOvr8j79bTVFC2k099QhGoDdbVqdfB7IdO7w9Mg7XCBfIor8QoJTQf9AoLtxruBqhKWTCTsprAOPP3D9zSJA==","ylAWTIE8NhRZonZpT9ja\/A==",null,"Svyt2SHrEUr2dPbTw0rvaA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["6935","1308","773.0","773.00","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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-16","2020-07-15","1308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 13:04:51","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":["6935","C15-D205248","PAID",773,0,"2020-07-15","2020-01-11 13:04:50","2020-01-11 13:04:50","2","2020-01-11 13:04:50","2","2020-01-11 13:04:50","1281"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["6935","1281","SETTLED","C15-I207263","2020-01-11 13:04:50","2020-01-16","2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,70,"MO","1",70,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u9810\u7e73\u79df\u91d1",3,696,"MO","1",696,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u9810\u7e73\u79df\u91d1",4,696,"MO","1",696,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u9810\u7e73\u79df\u91d1",5,696,"MO","1",696,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["7263","RENT","\u9810\u7e73\u79df\u91d1",6,696,"MO","1",696,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2854,0,"7263"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 13:04: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":["1281","PPS","","","","PPS","","","","PAID","P206913","2020-01-11 13:04:50",3627,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["6913","DEPOSIT","5248","PAID","2020-01-11 13:04:50",773,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:04: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":["6913","INVOICE","7263","PAID","2020-01-11 13:04:50",2854,"2","2020-01-11 13:04:50","2","2020-01-11 13:04:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=1333&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1308","master_room_id":"164","room_code":"C15-002"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":98,"customer_code":"C160098","identity_type":"PERSONAL","identity_id":"D451776(9)","title":"Mr","lastname":"Tang","firstname":"Kin Chor","companyname":"","email":"candicetsui@hotmail.com","tel":"91551038","address":"Flat C ,13\/F ,Block 2 , Kwong Fung Terrace,163 Third Street , Sai Ying Pun , HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3318.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-01","renew_room_key":"055,04510","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 26, 2019. Storage deposit $8976 transferred from agreement A12-CT183988 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195325, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"339","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"338","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"350","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"349","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"339","room_code":"F24","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"338","room_code":"F23","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"349","room_code":"F34","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"350","room_code":"F35","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3318,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":19908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-06-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on December 27, 2019. Storage deposit $8976 transferred from agreement A12-CT195325 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":19908,"final_order_total":19908,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,04510","order_product":[],"pass":true}},"first_order_id":"3988","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> F24 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F23 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F34 <\/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> F35 <\/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":"56","total_discounted_price":"3318.0","deposit":"0","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",98,"NEW","A12-CT206936",4192,3318,0,0,"6","6",19908,19908,19908,"2020-01-11 13:17:11","0",null,null,null,"2020-01-01","2020-06-30","6 months contract. Storage rental paid by bank transfer on December 27, 2019. Storage deposit $8976 transferred from agreement A12-CT195325 to this agreement.\r\n","2020-01-01","56",0,null,0,"0","2","2020-01-11 13:17:10","2","2020-01-11 13:17:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,04510","C160098","PERSONAL","Mr","LVCjHjOMA6DXeqjD+hjzKg==","M7CfcmE2OSMlZOkNgaoDmQ==","","WccXyqQlkfkMVl0xfvKm2cV\/RDuzr8asW1LnfWSo6JGnQ5uqK\/oVn7e4DNUBMpe8qXmt0fapnVXtsmCSfROzf71LvMWzFnAiAvZiPY\/HLTk=","6vSowiyV+fvPLovUkHBLGw==","oxjSz78510uxC2GGCzUY5hc1bsdZtzHwSE6OEqWLXT0=","QEBgUIFDXQjignzLItQ10g==",null,1,"3988"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","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":["6936","70","6","339","%","9.96",99.4008,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","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":["6936","70","6","338","%","9.96",99.4008,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","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":["6936","72","8","350","%","9.93",109.0314,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","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":["6936","72","8","349","%","9.93",109.0314,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6936","339","998.0",898.6,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-06-30","339"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6936","338","998.0",898.6,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-06-30","338"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6936","349","1098.0",989,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-06-30","349"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6936","350","1098.0",989,"2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-06-30","350"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6936",98,"SETTLED","A12-I207264","2020-01-11 13:17:10","2020-01-01","2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",1,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",2,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",3,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",4,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",5,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7264","RENT","\u9810\u7e73\u79df\u91d1",6,3318,"MO","1",3318,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19908,0,"7264"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[98,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206914","2020-01-11 13:17:10",19908,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6914","DEPOSIT",null,"PAID","2020-01-11 13:17:10",0,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 13:17:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6914","INVOICE","7264","PAID","2020-01-11 13:17:10",19908,"2","2020-01-11 13:17:10","2","2020-01-11 13:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:51:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1162,"customer_code":"C191162","identity_type":"PERSONAL","identity_id":"M645881(0)","title":"Mr","lastname":"Zhang","firstname":"Zhao Zong","companyname":"","email":"jason.z.zhong@gmail.com","tel":"67000194","address":"15\/F Lincoin House, Taikoo Place, 979 King's Road, Quarry Bay, HK ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"580.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-05","renew_room_key":"0012438313","renew_remark":"12 month contract. Storage rental and deposit paid by Bank Transfer on 2 JAN 2019. Smart card provided on 2 JAN 2019.Free of smart card,Special 5% Off Discount,\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194037, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $810.0","renew_master_room_id":"167","order_discount":[{"master_room_discount_id":"407","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"608.80","discount":"24.84","monthly_deduct":201.204,"room_id":"1328","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1328","room_code":"C15-022","retail_price":"810.0","discounted_price":608.8,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4174,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"200.00","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2020-07-04","delivery_service":"0","remark":"6 months contract. $200 referral bonus. Storage rental paid by bank transfer on 10 Jan,2020. Deposit $810 transferred from agreement C15-CT194037 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":200,"order_total":4374,"final_order_total":4174,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012438313","order_product":[],"pass":true}},"first_order_id":4037,"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-022 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"729.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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",1162,"NEW","C15-CT206937",810,729,0,0,"6","6",4174,4374,4174,"2020-01-11 14:56:12","0",null,null,null,"2020-01-05","2020-07-04","6 months contract. $200 referral bonus. Storage rental paid by bank transfer on 10 Jan,2020. Deposit $810 transferred from agreement C15-CT194037 to this agreement.","2020-01-05","12",0,null,200,"200.00","2","2020-01-11 14:56:11","2","2020-01-11 14:56:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012438313","C191162","PERSONAL","Mr","kK6O4cvejURBlLFNL3cxRw==","S4G\/mAL7JqKp0fexKE1ZAw==","","COSStYu3nYWCt65bYByfnrR2qrG9KR9KDh0n095s0i0+e4fV9HaAeWsR7UiQ0n0euJbHoV8EOx1ZNWad\/yutiumoys3IOH4Klpamw8sgAD8=","dWYAfo0\/9cJKyEebDxEasA==","COEHnPHgj2oSvRI\/ZoDC5bXdm9rJigTklhy4ISop\/M4=","A7uY+uIowF\/PhYXYKPYjnw==",null,1,4037]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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":["6937","407","167","1328","%","24.84",201.204,"2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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":["6937","1328","810.0",608.8,"2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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-05","2020-07-04","1328"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 14:56:12","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":["6937",1162,"SETTLED","C15-I207265","2020-01-11 14:56:11","2020-01-05","2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,529,"MO","1",529,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7265","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4174,0,"7265"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 14:56:12","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":[1162,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206915","2020-01-11 14:56:11",4174,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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":["6915","DEPOSIT",null,"PAID","2020-01-11 14:56:11",0,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 14:56:12","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":["6915","INVOICE","7265","PAID","2020-01-11 14:56:11",4174,"2","2020-01-11 14:56:11","2","2020-01-11 14:56:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1318&filter3=undefined","floor_plan_rent_room":[{"room_id":"1304","master_room_id":"141","room_code":"B01-114"}],"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> B01-114 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1308.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":"0","identity_type":"PERSONAL","identity_id":"K811827(2)","title":"Mr","lastname":"WONG","firstname":"Yip Lung","companyname":"","email":"imjackal@gmail.com","tel":"98215201","address":"Room 3701, Hin Tsui House, Kai Tsui Court, SSW, HK","pass":true,"customer_id":"1318","customer_code":"C191318","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1304","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1304","room_code":"B01-114","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"20","total_retail_price":1308,"total_discounted_price":960,"deposit":2616,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5556.00","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2021-01-04","delivery_service":"0","remark":"12 months contract. Change unit from B01-115,116 to B01-114. Storage rental and deposit $5556 transferred from agreement B01-CT195367 to this agreement. Remaining balance (ttl:$8580) $5964 paid on Jan 06 and $2616 paid by bank transfer on Jan 09,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5556,"order_total":14136,"final_order_total":8580,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012414175, 0012436831","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"960.00","deposit":"2616.00","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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","2","5","1318","NEW","B01-CT206938",1308,960,2616,0,"12","12",8580,14136,8580,"2020-01-11 15:38:26","0",null,null,null,"2020-01-05","2021-01-04","12 months contract. Change unit from B01-115,116 to B01-114. Storage rental and deposit $5556 transferred from agreement B01-CT195367 to this agreement. Remaining balance (ttl:$8580) $5964 paid on Jan 06 and $2616 paid by bank transfer on Jan 09,2020.","2020-01-05","20",0,null,5556,"5556.00","2","2020-01-11 15:38:26","2","2020-01-11 15:38:26","BANKIN","","","","BANKIN","","","",null,0,"0012414175, 0012436831","C191318","PERSONAL","Mr","r95iKo1jZUhDkWAHXF6QvQ==","ddrfzAYTmkL\/QNu3psjONQ==","","VXx4H3sSa4\/J4vNnxKoVZksxI+SoNYzsnbEXYjnHP6Zm7GmaFeuQ7nYPDPleWzJ3zxHr8VTsqWAW4c2qkhhkRg==","xeIOiLVbtSDKP3VL2yn4VA==","mR4D9hLJGlk9\/T2i3p6jOb0TjGq5Qqr+WilWuBv7hqw=","mgThzUUlX\/KOEp6gjO343A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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":["6938","342","141","1304","%","34.94",457.0152,"2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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":["6938","1304","1308.0",851,"2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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-05","2021-01-04","1304"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-11 15:38:26","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":["6938","B01-D205249","PAID",2616,0,"2021-01-04","2020-01-11 15:38:26","2020-01-11 15:38:26","2","2020-01-11 15:38:26","2","2020-01-11 15:38:26","1318"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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":["6938","1318","SETTLED","B01-I207266","2020-01-11 15:38:26","2020-01-05","2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,0,"MO","1",0,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",6,204,"MO","1",204,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",7,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",8,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",9,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",10,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",11,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7266","RENT","\u9810\u7e73\u79df\u91d1",12,960,"MO","1",960,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5964,0,"7266"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-11 15:38:26","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":["1318","BANKIN","","","","BANKIN","","","","PAID","P206916","2020-01-11 15:38:26",8580,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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":["6916","DEPOSIT","5249","PAID","2020-01-11 15:38:26",2616,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 15:38:26","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":["6916","INVOICE","7266","PAID","2020-01-11 15:38:26",5964,"2","2020-01-11 15:38:26","2","2020-01-11 15:38:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-11 16:17:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****