{"created_at":"2020-03-09 10:14:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:15:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1401,"customer_code":"C191401","identity_type":"PERSONAL","identity_id":"Y005310(2)","title":"Mr","lastname":"Lam","firstname":"Ka Lok","companyname":"","email":"e032001@yahoo.com.hk","tel":"65531742","address":"Flat 1706, Sui Tai Hse, Siu Sai Wan Est","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"800.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-22","renew_room_key":"0012403568","renew_remark":"6 months contract. Special offer 1 month free. Storage rental and deposit paid by cash on 20 September, 2019. Smartcard paid on 20 September.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195984, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1816.0","renew_master_room_id":"136","order_discount":[],"order_room":[{"room_id":"1235","room_code":"B01-045","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":800,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4800,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2020-09-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Mar 08,2020. Storage deposit $1816 transferred from agreement B01-CT195984 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4800,"final_order_total":4800,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012403568","order_product":[],"pass":true}},"first_order_id":5984,"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>
B01-045 <\/td>\r\n\t\t\t\t\t	3X4X7 <\/td>\r\n\t\t\t\t\t	$908.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":"800.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1401,"NEW","B01-CT207350",908,800,0,0,"6","6",4800,4800,4800,"2020-03-09 10:17:04","0",null,null,null,"2020-03-22","2020-09-21","6 months contract. Storage rental paid by bank transfer on Mar 08,2020. Storage deposit $1816 transferred from agreement B01-CT195984 to this agreement.","2020-03-22","12",0,null,0,"0","2","2020-03-09 10:17:03","2","2020-03-09 10:17:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012403568","C191401","PERSONAL","Mr","qRd1JmPIQdUyn8QK3M2oyA==","0JxYUqbNPOvgfMwVa0l0NA==","","ruEQ89fw2wRP+snuh9PYz2HFXgVLt1UtEWnhxafrqVFR5guojHvZWlIHnatZPkjf","5tI8LvC4XWe6ctAN0njp7g==","dE+\/mrZDlpM97qmRi0omIv5P\/VjQTijOljf7\/yDLdX8=","YWOROan5R\/r3r\/bjKOnqjg==",null,1,5984]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7350","1235","908.0","908.00","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-22","2020-09-21","1235"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7350",1401,"SETTLED","B01-I207678","2020-03-09 10:17:03","2020-03-22","2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",1,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",2,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",3,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",4,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",5,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7678","RENT","\u9810\u7e73\u79df\u91d1",6,800,"MO","1",800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4800,0,"7678"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1401,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207326","2020-03-09 10:17:03",4800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7326","DEPOSIT",null,"PAID","2020-03-09 10:17:03",0,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:17:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7326","INVOICE","7678","PAID","2020-03-09 10:17:03",4800,"2","2020-03-09 10:17:03","2","2020-03-09 10:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1212,"customer_code":"C191212","identity_type":"PERSONAL","identity_id":"D225511(2)","title":"Mr","lastname":"TANG","firstname":"Micheal Chung Yin","companyname":"","email":"michealtang@netvigator.com","tel":"91080619","address":"Flat A, 30\/F, Fullview Court, 32 Fortress Hill Road, North Point, H.K.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1004.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-15","renew_room_key":"'0012403750","renew_remark":"12 month contract. Storage rental and deposit paid by EPS on March 7, 2019. Smartcard provided on March 7, 2019. Special offer 5% off and 2 months free. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194503, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1115.0","renew_master_room_id":"172","order_discount":[{"master_room_discount_id":"417","master_room_id":"172","discount_type":"%","price":"1115.00","disocunted_price":"1059.90","discount":"4.94","monthly_deduct":55.081,"room_id":"1482","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1482","room_code":"C15-176","retail_price":"1115.0","discounted_price":1059.9,"location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1060,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2020-06-14","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 08, 2020. Deposit $1115 transferred from agreement C15-CT194503 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012403750","order_product":[],"pass":true}},"first_order_id":4503,"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-176 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1060.00","deposit":"0.00","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","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",1212,"NEW","C15-CT207351",1115,1060,0,0,"3","3",3180,3180,3180,"2020-03-09 10:27:40","0",null,null,null,"2020-03-15","2020-06-14","3 months contract. Storage rental paid by bank transfer on March 08, 2020. Deposit $1115 transferred from agreement C15-CT194503 to this agreement.","2020-03-15","20",0,null,0,"0","2","2020-03-09 10:27:39","2","2020-03-09 10:27:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012403750","C191212","PERSONAL","Mr","IhrOOYbFlDuHl4ZLmD\/wOYAFlyFFM1ThvQ6Nl+i3D3w=","20knVHhKlM9kB5wugwP3yQ==","","wq8qRkfV0QWWLwgYjAE8cLOMW+4ceXo2GRCgR8w13bFDoLWmCBWYKyVijR\/DzjTrqOow5UJ\/26+FPGiYeTxtSrkLiKqevOlxDtvAW6t+\/tk=","5fz6vShr6JjYW6MHuzYpOg==","cxMPDYDvwBCobHma1J+cDvOOMtoonzuyr9VhOf0QuPw=","nK9AA9kgrYO0AyNObPBFrw==",null,1,4503]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","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":["7351","417","172","1482","%","4.94",55.081,"2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","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":["7351","1482","1115.0",1059.9,"2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-15","2020-06-14","1482"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 10:27:40","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":["7351",1212,"SETTLED","C15-I207679","2020-03-09 10:27:39","2020-03-15","2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7679","RENT","\u9810\u7e73\u79df\u91d1",1,1060,"MO","1",1060,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7679","RENT","\u9810\u7e73\u79df\u91d1",2,1060,"MO","1",1060,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7679","RENT","\u9810\u7e73\u79df\u91d1",3,1060,"MO","1",1060,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"7679"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 10:27:40","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":[1212,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207327","2020-03-09 10:27:39",3180,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","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":["7327","DEPOSIT",null,"PAID","2020-03-09 10:27:39",0,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:27:40","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":["7327","INVOICE","7679","PAID","2020-03-09 10:27:39",3180,"2","2020-03-09 10:27:39","2","2020-03-09 10:27:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:32:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:34:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:39","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=1007&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":958,"customer_code":"C180958","identity_type":"PERSONAL","identity_id":"E996131(7)","title":"Mr","lastname":"Lam","firstname":"Yau Wing Peter","companyname":"","email":"peterlam1000@gmail.com","tel":"93829730","address":"Flat A, 25\/F, Fu Yi Yuen, Block 7, Chi Fu Fa Yuen, 7 Chi Fu Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-11","renew_room_key":"189,28781","renew_remark":"6 months contract. Storage rental paid by cheque on Sep 9, 2019. Stroage deposit $2456 transferred from agreement A18-CT194535 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195911, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"946","room_code":"V20","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-03-11","rent_from":"2020-03-11","rent_to":"2021-04-10","delivery_service":"0","remark":"13 months contract. Special renewal offer, the 13th month free. Storage rental paid by cheque deposit on Mar 08,2020. Stroage deposit $2456 transferred from agreement A18-CT195911 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,28781","order_product":[],"pass":true}},"first_order_id":"4535","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> V20 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","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",958,"NEW","A18-CT207352",1290,1162,0,0,"13","13",13944,15106,13944,"2020-03-09 10:40:40","0",null,null,null,"2020-03-11","2021-04-10","13 months contract. Special renewal offer, the 13th month free. Storage rental paid by cheque deposit on Mar 08,2020. Stroage deposit $2456 transferred from agreement A18-CT195911 to this agreement. ","2020-03-11","16",0,null,1162,"1162.00","2","2020-03-09 10:40:39","2","2020-03-09 10:40:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,28781","C180958","PERSONAL","Mr","ACVU4T6xRxRUOq9lq0k7rw==","0JxYUqbNPOvgfMwVa0l0NA==","","Yv51Q112xCfSPRSH9D+yhjXH1cSZiuOivJ8oe9kvydSgIGmbQt1SWjtNUg1BGOATcQQYIwOtYfirzBEPiEzibDH3D3vwJHj5+4UE\/vExXtSAzL8ArAIxI+qqzEIyplJo","bfhdRpjqgQdpcpBbb0PZHw==","yGGObQizmY+TkG+9xp9U8Omk8lELKa7EaPV4fyz9dzk=","PqkPQJawxD+b6lt\/PgZVBg==",null,1,"4535"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","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":["7352","946","1290.0","1290.00","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-11","2021-04-10","946"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 10:40:40","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":["7352",958,"SETTLED","A18-I207680","2020-03-09 10:40:39","2020-03-11","2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7680","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7680"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 10:40:40","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":[958,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207328","2020-03-09 10:40:39",13944,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","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":["7328","DEPOSIT",null,"PAID","2020-03-09 10:40:39",0,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 10:40:40","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":["7328","INVOICE","7680","PAID","2020-03-09 10:40:39",13944,"2","2020-03-09 10:40:39","2","2020-03-09 10:40:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:00:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":619,"customer_code":"C170619","identity_type":"PERSONAL","identity_id":"K063939(7)","title":"Mr","lastname":"Kwok","firstname":"Siu Kai Chris","companyname":"","email":"chriskwok@hundredcity.com","tel":"51923422","address":"Room 2206, Wah Chui House, Wah Fu Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"137,01453","renew_remark":"1 month contract. Storage rental paid by PPS on March 2, 2020. Storage deposit transferred from agreement A18-CT207084 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207309, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"848","room_code":"S07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 5, 2020. Storage deposit transferred from agreement A18-CT207309 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,01453","order_product":[],"pass":true}},"first_order_id":"4713","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> S07 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","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",619,"NEW","A18-CT207353",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-09 12:46:30","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Storage rental paid by PPS on March 5, 2020. Storage deposit transferred from agreement A18-CT207309 to this agreement.\r\n","2020-04-01","16",0,null,0,"0","2","2020-03-09 12:46:30","2","2020-03-09 12:46:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"137,01453","C170619","PERSONAL","Mr","4CxzeWawe7YZzIDmhbEfuQ==","+pNULpsInm3siHASV0hIrg==","","NYkQtJJtV74MeVYTqgx0ztU\/N5b87j7Qp2UEsJ4OUX2W\/qfJLUUiDaAhXCDscVFsf696kppiP\/Svvt3NEV7dFw==","Y\/j3PHjWzTVUfnUyu6iRgg==","quK5iGTT3eQ2Z0bPiVPSOKKb9HSCQz7W9wX8cB2u8BQ=","0tB+oJUYD6OdlTawrAQuqw==",null,1,"4713"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","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":["7353","848","1290.0","1290.00","2","2020-03-09 12:46:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-04-30","848"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 12:46:30","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":["7353",619,"SETTLED","A18-I207681","2020-03-09 12:46:30","2020-04-01","2","2020-03-09 12:46:30","2","2020-03-09 12:46:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7681","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-09 12:46:30","2","2020-03-09 12:46:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7681"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 12:46:30","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":[619,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207329","2020-03-09 12:46:30",1290,"2","2020-03-09 12:46:30","2","2020-03-09 12:46:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","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":["7329","DEPOSIT",null,"PAID","2020-03-09 12:46:30",0,"2","2020-03-09 12:46:30","2","2020-03-09 12:46:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:46:30","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":["7329","INVOICE","7681","PAID","2020-03-09 12:46:30",1290,"2","2020-03-09 12:46:30","2","2020-03-09 12:46:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":212,"customer_code":"C160212","identity_type":"PERSONAL","identity_id":"D285534(9)","title":"Mr","lastname":"Mak","firstname":"Che Yan","companyname":"","email":"davidcy.mak@gmail.com","tel":"90435747","address":"13A, Block 23, Baguio Villa, 555 Victoria Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-10","renew_room_key":"054,43821","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A12-CT195908 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196645, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"220","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"220","room_code":"D24","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-10","rent_from":"2020-03-10","rent_to":"2020-06-09","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A12-CT196645 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43821","order_product":[],"pass":true}},"first_order_id":"4549","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> D24 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"949.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","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",212,"NEW","A12-CT207354",998,949,0,0,"3","3",2847,2847,2847,"2020-03-09 12:52:24","0",null,null,null,"2020-03-10","2020-06-09","3 months contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A12-CT196645 to this agreement.\r\n","2020-03-10","12",0,null,0,"0","2","2020-03-09 12:52:24","2","2020-03-09 12:52:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43821","C160212","PERSONAL","Mr","QMdo4NmpjqV\/3s1QKx1gOQ==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","81v4Ds3okvpkyWWGB85n4xU+OGL3XTVm52q2rAuaYfRkwNVWuNcSFXbV5+CxdL+5DkE0fx06BlYm2oRHyzW2QQ==","HYnJYtaUMZQPiLVK4mRPsw==","3d9EX5\/c7dA6NvE2V921JGQiwkORAbLjhJZwk0bpolI=","kimoPHeAaNKLapbOk2eYCQ==",null,1,"4549"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","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":["7354","469","6","220","%","4.91",49.0018,"2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","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":["7354","220","998.0",949,"2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-10","2020-06-09","220"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 12:52:24","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":["7354",212,"SETTLED","A12-I207682","2020-03-09 12:52:24","2020-03-10","2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7682","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7682","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7682","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"7682"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 12:52:24","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":[212,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207330","2020-03-09 12:52:24",2847,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","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":["7330","DEPOSIT",null,"PAID","2020-03-09 12:52:24",0,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 12:52:24","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":["7330","INVOICE","7682","PAID","2020-03-09 12:52:24",2847,"2","2020-03-09 12:52:24","2","2020-03-09 12:52:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:10:49","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","055,03673","12 months contract. $300 Maxim coupon provided. Storage rental paid by cheque on Mar 4, 2020. Storage deposit transferred from agreement A12-CT194455 to this agreement.\r\n","2020-03-09 14:10:49","2","PfVsMI23M5\/xFC1FQxJikg==","eYp7wkZVr\/ESATj9g0Yeww==","5H1ciwQuMFZsM3TYI47ILA==","kPp6q6TlAQRNluMi8NITvvYlNcl6YYecoPAE3kjt3\/CTYBga43+HFQ\/0+sFGgZpfeQYk2UhHKlzI+Ta0\/EX6kQ==",7320]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"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> B59 <\/td>\r\n\t\t\t\t\t 5X6X8 <\/td>\r\n\t\t\t\t\t $2188.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 \/ <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z261609(3)","title":"Ms","lastname":"Nagrani","firstname":"Dyana Chirag","companyname":"","email":"dyananagrani@gmail.com","tel":"97530656","address":"15D,Block 23,Upper Baguio Villa,555 Victoria Road","pass":true,"customer_id":"476","customer_code":"C170476","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"454","master_room_id":"23","discount_type":"%","price":"2188.00","disocunted_price":"2078.60","discount":"4.97","monthly_deduct":108.7436,"room_id":"111","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"111","room_code":"B59","retail_price":"2188.0","discounted_price":2079.3,"location_id":"1"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":2079,"deposit":4376,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10283,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"330.00","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2020-05-11","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on March. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":330,"order_total":10613,"final_order_total":10283,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"30","total_discounted_price":"2079.00","deposit":"4376.00","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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` = ?","parameters":["1","1","1","476","NEW","A12-CT207355",2188,2079,4376,0,"3","3",10283,10613,10283,"2020-03-09 14:19:12","0",null,null,null,"2020-02-12","2020-05-11","3 months contract. Storage rental and deposit paid by bank transfer on March. ","2020-02-12","30",0,null,330,"330.00","2","2020-03-09 14:19:12","2","2020-03-09 14:19:12","BANKIN","","","","BANKIN","","","",null,0,"","C170476","PERSONAL","Ms","uY1GOIr7ltXY31G7hQ1Lpw==","aJKgnyAdJr97nz4jfpV3sQ==","","1lJ4K+syeOSy\/iMz0AD2J1xPDznD6Og9NKPh1dqZhBdfuPpjXKo+Pfxml\/5AOdOZg\/o5qCMIqoVmECFdvjh4OQ==","yOfdSxJ\/ZUSdf+Zln3yzeQ==","nGVYsbC3icJGemDDP2LYnBkL+VDYEjjfs2MMvYaW\/PE=","ByPC9gVlx28UHvivmbpe3Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7355","454","23","111","%","4.97",108.7436,"2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7355","111","2188.0",2079.3,"2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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-02-12","2020-05-11","111"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 14:19:12","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":["7355","A12-D205314","PAID",4376,0,"2020-05-11","2020-03-09 14:19:12","2020-03-09 14:19:12","2","2020-03-09 14:19:12","2","2020-03-09 14:19:12","476"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7355","476","SETTLED","A12-I207683","2020-03-09 14:19:12","2020-02-12","2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7683","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1749,"MO","1",1749,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7683","RENT","\u9810\u7e73\u79df\u91d1",2,2079,"MO","1",2079,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7683","RENT","\u9810\u7e73\u79df\u91d1",3,2079,"MO","1",2079,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5907,0,"7683"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 14:19: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":["476","BANKIN","","","","BANKIN","","","","PAID","P207331","2020-03-09 14:19:12",10283,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7331","DEPOSIT","5314","PAID","2020-03-09 14:19:12",4376,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:19: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":["7331","INVOICE","7683","PAID","2020-03-09 14:19:12",5907,"2","2020-03-09 14:19:12","2","2020-03-09 14:19:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":982,"customer_code":"C180982","identity_type":"BUSINESS","identity_id":"09308671-000-10-17-2","title":"Ms","lastname":"Ip","firstname":"Man Hing","companyname":"Ching Ping Investment Co. Ltd.","email":"ipmanhing@netvigator.com","tel":"94899048","address":"14\/F AIE Building, 33 Connaught Road Central","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1247.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-01","renew_room_key":"0012385472","renew_remark":"12 months contract. Storage rental and deposit paid by cheque on February 1, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194285, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2768.0","renew_master_room_id":"134","order_discount":[],"order_room":[{"room_id":"1189","room_code":"A05-187","retail_price":"1384.0","discounted_price":"1384.00","location_id":"4"}],"roughly_size":"18","total_retail_price":1384,"total_discounted_price":1247,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14964,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1247.00","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-02-28","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by Cheque on March 9, 2020. Storage deposit $2768 transferred from agreement A05-CT194285 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1247,"order_total":16211,"final_order_total":14964,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385472","order_product":[],"pass":true}},"first_order_id":4285,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-187 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1384.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1247.00","deposit":"0.00","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",982,"NEW","A05-CT207356",1384,1247,0,0,"13","13",14964,16211,14964,"2020-03-09 14:22:58","0",null,null,null,"2020-02-01","2021-02-28","13 months contract. Special offer the 13th month free. Storage rental paid by Cheque on March 9, 2020. Storage deposit $2768 transferred from agreement A05-CT194285 to this agreement. ","2020-02-01","18",0,null,1247,"1247.00","2","2020-03-09 14:22:58","2","2020-03-09 14:22:58","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012385472","C180982","BUSINESS","Ms","bfESADT0mat0ZeyHOB0Y9w==","bXicfGTTHvCncWFCqwKkUQ==","Ching Ping Investment Co. Ltd.","yBeu2+3nQhSMpLylC1DMi1r9\/Jkv40R\/gNqor+9iE3Bb7R+82J8h8GxjMGjrCbm4","C+UdnbH9b+nGc043A1E1bQ==","5Y4GPJK5Bjm8imXTC3xshS29OlSJBabbaEcBzA+rOoA=",null,"HADgQ\/UX35Ceam8WH5lBof+4SD9yCsLrX6INdvBqUKI=",1,4285]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7356","1189","1384.0","1384.00","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-02-28","1189"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7356",982,"SETTLED","A05-I207684","2020-03-09 14:22:58","2020-02-01","2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",3,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",4,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",5,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",6,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",7,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",8,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",9,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",10,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",11,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",12,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7684","RENT","\u9810\u7e73\u79df\u91d1",13,1247,"MO","1",1247,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14964,0,"7684"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[982,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207332","2020-03-09 14:22:58",14964,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7332","DEPOSIT",null,"PAID","2020-03-09 14:22:58",0,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:22:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7332","INVOICE","7684","PAID","2020-03-09 14:22:58",14964,"2","2020-03-09 14:22:58","2","2020-03-09 14:22:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":982,"customer_code":"C180982","identity_type":"BUSINESS","identity_id":"09308671-000-10-17-2","title":"Ms","lastname":"Ip","firstname":"Man Hing","companyname":"Ching Ping Investment Co. Ltd.","email":"ipmanhing@netvigator.com","tel":"94899048","address":"14\/F AIE Building, 33 Connaught Road Central","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1076.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-01","renew_room_key":"0012435007,0012436757","renew_remark":"12 months contract. Storage rental $2150 and deposit $2580 transferred from agreement A05-CT183628 to this agreement. Storage rental $2697 and deposit $2820 transferred from agreement A05-CT183220 to this agreement. Remaining storage rental and deposit (ttl: $5055) and rental from 14\/3 to 31\/3 ($648) paid by cheque on March 14, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194568, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2390.0","renew_master_room_id":"109","order_discount":[],"order_room":[{"room_id":"1188","room_code":"A05-186","retail_price":"1195.0","discounted_price":"1195.00","location_id":"4"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1076,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12912,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1076.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-04-30","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on March 9, 2020. Storage deposit $2390 transferred from agreement A05-CT194568 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1076,"order_total":13988,"final_order_total":12912,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012435007,0012436757","order_product":[],"pass":true}},"first_order_id":4568,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-186 <\/td>\r\n\t\t\t\t\t 3X5X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/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":"15","total_discounted_price":"1076.00","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",982,"NEW","A05-CT207357",1195,1076,0,0,"13","13",12912,13988,12912,"2020-03-09 14:28:08","0",null,null,null,"2020-04-01","2021-04-30","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on March 9, 2020. Storage deposit $2390 transferred from agreement A05-CT194568 to this agreement. \r\n","2020-04-01","15",0,null,1076,"1076.00","2","2020-03-09 14:28:08","2","2020-03-09 14:28:08","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012435007,0012436757","C180982","BUSINESS","Ms","bfESADT0mat0ZeyHOB0Y9w==","bXicfGTTHvCncWFCqwKkUQ==","Ching Ping Investment Co. Ltd.","yBeu2+3nQhSMpLylC1DMi1r9\/Jkv40R\/gNqor+9iE3Bb7R+82J8h8GxjMGjrCbm4","C+UdnbH9b+nGc043A1E1bQ==","5Y4GPJK5Bjm8imXTC3xshS29OlSJBabbaEcBzA+rOoA=",null,"HADgQ\/UX35Ceam8WH5lBof+4SD9yCsLrX6INdvBqUKI=",1,4568]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7357","1188","1195.0","1195.00","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2021-04-30","1188"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7357",982,"SETTLED","A05-I207685","2020-03-09 14:28:08","2020-04-01","2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",3,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",4,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",5,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",6,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",7,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",8,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",9,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",10,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",11,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",12,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7685","RENT","\u9810\u7e73\u79df\u91d1",13,1076,"MO","1",1076,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12912,0,"7685"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[982,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207333","2020-03-09 14:28:08",12912,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","DEPOSIT",null,"PAID","2020-03-09 14:28:08",0,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:28:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7333","INVOICE","7685","PAID","2020-03-09 14:28:08",12912,"2","2020-03-09 14:28:08","2","2020-03-09 14:28:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:29:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1435,"customer_code":"C191435","identity_type":"PERSONAL","identity_id":"Z600823(3)","title":"Ms","lastname":"SO","firstname":"Ching Man","companyname":"","email":"manman_615@gmail.com","tel":"66857798","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a133209\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-05","renew_room_key":"190,25713","renew_remark":"3 months contract. Storage rental and deposit paid by EPS on Nov 04,2019. Smartcard provided on Nov 04,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196294, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"562","room_code":"L40","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-05","rent_from":"2020-02-05","rent_to":"2020-03-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 5,2020. Storage deposit $1996 transferred from agreement A14-CT196294 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,25713","order_product":[],"pass":true}},"first_order_id":6294,"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> L40 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1435,"NEW","A14-CT207358",998,998,0,0,"1","1",998,998,998,"2020-03-09 14:52:14","0",null,null,null,"2020-02-05","2020-03-04","1 month contract. Storage rental paid by bank transfer on February 5,2020. Storage deposit $1996 transferred from agreement A14-CT196294 to this agreement.\r\n","2020-02-05","12",0,null,0,"0","2","2020-03-09 14:52:14","2","2020-03-09 14:52:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,25713","C191435","PERSONAL","Ms","knZMm9GAZID7Lv+9MLc5ZA==","mOWsGT2TzOPDdjq14yV0zw==","","JP4Rs\/ygk7B5+4qY1O\/77mUgOqLhOV7RAed2ioH8C+7gkcorV\/Bk82G90L53vhh8","95CDSt30lRyCZEH4n270nw==","bE\/Jfb0PyFebKTBoaLQMLuSWgoH2ygJQ\/KlmIxPGGno=","v8f4b0Nv2Vl1ElMKQ09dDQ==",null,1,6294]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7358","562","998.0","998.00","2","2020-03-09 14:52:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-05","2020-03-04","562"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7358",1435,"SETTLED","A14-I207686","2020-03-09 14:52:14","2020-02-05","2","2020-03-09 14:52:14","2","2020-03-09 14:52:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7686","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-03-09 14:52:14","2","2020-03-09 14:52:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7686"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1435,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207334","2020-03-09 14:52:14",998,"2","2020-03-09 14:52:14","2","2020-03-09 14:52:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","DEPOSIT",null,"PAID","2020-03-09 14:52:14",0,"2","2020-03-09 14:52:14","2","2020-03-09 14:52:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:52:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7334","INVOICE","7686","PAID","2020-03-09 14:52:14",998,"2","2020-03-09 14:52:14","2","2020-03-09 14:52:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:55:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit transferred from agreement A05-CT206890 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206972, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-08","rent_from":"2020-02-08","rent_to":"2020-03-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 19, 2020. Storage deposit transferred from agreement A05-CT206972 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-085 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1137,"NEW","A05-CT207359",598,598,0,0,"1","1",598,598,598,"2020-03-09 14:58:46","0",null,null,null,"2020-02-08","2020-03-07","1 month contract. Storage rental paid by bank transfer on February 19, 2020. Storage deposit transferred from agreement A05-CT206972 to this agreement.\r\n","2020-02-08","8",0,null,0,"0","2","2020-03-09 14:58:45","2","2020-03-09 14:58:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7359","1087","598.0","598.00","2","2020-03-09 14:58:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-08","2020-03-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7359",1137,"SETTLED","A05-I207687","2020-03-09 14:58:45","2020-02-08","2","2020-03-09 14:58:45","2","2020-03-09 14:58:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7687","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-09 14:58:45","2","2020-03-09 14:58:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7687"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207335","2020-03-09 14:58:45",598,"2","2020-03-09 14:58:45","2","2020-03-09 14:58:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7335","DEPOSIT",null,"PAID","2020-03-09 14:58:45",0,"2","2020-03-09 14:58:45","2","2020-03-09 14:58:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 14:58:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7335","INVOICE","7687","PAID","2020-03-09 14:58:45",598,"2","2020-03-09 14:58:45","2","2020-03-09 14:58:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:07:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=833&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":891,"customer_code":"C180891","identity_type":"PERSONAL","identity_id":"Z359641(A)","title":"Ms","lastname":"Siu","firstname":"Ngai Ki","companyname":"","email":"suki.siu09@hotmail.com","tel":"90196358","address":"Flat 714, Sui Fat House, Siu Sai Wan Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"818.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-09","renew_room_key":"0005795980","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 23, 2019. Storage deposit $1816 transferred from agreement B01-CT194554 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196012, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"138","order_discount":[{"master_room_discount_id":"311","master_room_id":"138","discount_type":"%","price":"908.00","disocunted_price":"666.90","discount":"26.55","monthly_deduct":241.074,"room_id":"1224","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1224","room_code":"B01-034","retail_price":"908.0","discounted_price":666.9,"location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":818,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-09","rent_from":"2020-03-09","rent_to":"2020-09-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Mar 09,2020. Storage deposit $1816 transferred from agreement B01-CT196012 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4908,"final_order_total":4908,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005795980","order_product":[],"pass":true}},"first_order_id":"4554","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> B01-034 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $908.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","roughly_size":"12","total_discounted_price":"818.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",891,"NEW","B01-CT207360",908,818,0,0,"6","6",4908,4908,4908,"2020-03-09 15:53:57","0",null,null,null,"2020-03-09","2020-09-08","6 months contract. Storage rental paid by bank transfer on Mar 09,2020. Storage deposit $1816 transferred from agreement B01-CT196012 to this agreement.","2020-03-09","12",0,null,0,"0","2","2020-03-09 15:53:56","2","2020-03-09 15:53:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005795980","C180891","PERSONAL","Ms","k5wKYh5qZr7UPUx1SCyIsA==","5dV7LbaqJ\/qtoUd1tT+NjQ==","","igXNC4Or0zN6AvqGpDdLqvtSZU1\/HfHCg9gjgg+Bo6C7GUD55\/gExSTzM+b+OccVw7QREArTPm80nSQeI9S1Pw==","tC7RkscGmGyocxgy+3PY0Q==","M3xNuajT56uMZE6PQsQgDWwH\/4J+f9XN4iN2chR65SA=","p8XxN7tUXHgj5SM9hG1cwg==",null,1,"4554"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","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":["7360","311","138","1224","%","26.55",241.074,"2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7360","1224","908.0",666.9,"2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-09","2020-09-08","1224"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7360",891,"SETTLED","B01-I207688","2020-03-09 15:53:56","2020-03-09","2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",1,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",2,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",3,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",4,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",5,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7688","RENT","\u9810\u7e73\u79df\u91d1",6,818,"MO","1",818,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4908,0,"7688"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[891,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207336","2020-03-09 15:53:56",4908,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7336","DEPOSIT",null,"PAID","2020-03-09 15:53:56",0,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 15:53:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7336","INVOICE","7688","PAID","2020-03-09 15:53:56",4908,"2","2020-03-09 15:53:56","2","2020-03-09 15:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 16:20:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"111","master_room_id":"23","room_code":"B59"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":804,"customer_code":"C180804","identity_type":"PERSONAL","identity_id":"D666407(6)","title":"Mr","lastname":"Yip","firstname":"Yung Hon Aldous","companyname":"","email":"aldous.yip@gmail.com","tel":"92662507","address":"Room 3807, 38\/F, Pik Luk House, Shek Pai Wan Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-19","renew_room_key":"055,14139","renew_remark":"12 months contract. Storage rental paid by EPS on March 27, 2019. Storage deposit transferred from agreement \tA18-CT183135 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194655, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"874","room_code":"Y03","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-19","rent_from":"2020-03-19","rent_to":"2020-09-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT194655 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,14139","order_product":[],"pass":true}},"first_order_id":4655,"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> Y03 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",804,"NEW","A18-CT207361",1090,981,0,0,"6","6",5886,5886,5886,"2020-03-09 17:02:39","0",null,null,null,"2020-03-19","2020-09-18","6 months contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A18-CT194655 to this agreement.\r\n","2020-03-19","12",0,null,0,"0","2","2020-03-09 17:02:39","2","2020-03-09 17:02:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,14139","C180804","PERSONAL","Mr","K6ppWUXduKkIs\/HOBSJqmQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","rjV4NR9R8TA+8Wwh\/h4lyI3L5k7DPaDbO4V1JzrBMUvo\/DaFz4EAtueNzzeeaF9WbImnljTh\/4q3n4390cMy9w==","foiYjgE9DmbV07YybBrVZg==","VQwYDfOi2ZLASJdS1Lp+wUykws5VT3uc\/0PGGuV1IQ0=","f5dnb0PLcyr6xZz09KC0Nw==",null,1,4655]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7361","874","1090.0","1090.00","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-19","2020-09-18","874"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7361",804,"SETTLED","A18-I207689","2020-03-09 17:02:39","2020-03-19","2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7689"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[804,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207337","2020-03-09 17:02:39",5886,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","DEPOSIT",null,"PAID","2020-03-09 17:02:39",0,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:02:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","INVOICE","7689","PAID","2020-03-09 17:02:39",5886,"2","2020-03-09 17:02:39","2","2020-03-09 17:02:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:17:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 17:31:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 18:34:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-09 18:57:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****