{"created_at":"2019-12-21 10:21:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","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":"1580","master_room_id":"204","room_code":"A16-089"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":805,"customer_code":"C180805","identity_type":"PERSONAL","identity_id":"D048456(4)","title":"Mr","lastname":"Ip","firstname":"Wai Man Peter","companyname":"","email":"peterip_123@yahoo.com.hk","tel":"90490309","address":"Flat B, 33\/F, Kam Fung Building, 171 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"HANG SENG BANK","renew_cheque_num2":"201166","renew_paymethod_order2":null,"renew_total_discounted_price":"1081.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-24","renew_room_key":"054,49726","renew_remark":"3 months contract. Storage rental paid by cheque on September 23, 2019. Storage deposit transferred from agreement A12-CT195299 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196008, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"47","room_code":"A47","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"15","total_retail_price":1138,"total_discounted_price":1081,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3243,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-24","rent_from":"2019-12-24","rent_to":"2020-03-23","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on Dec 21, 2019. Storage deposit transferred from agreement A12-CT196008 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3243,"final_order_total":3243,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,49726","order_product":[],"pass":true}},"first_order_id":"4593","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>
A47 <\/td>\r\n\t\t\t\t\t	3X5X8 <\/td>\r\n\t\t\t\t\t	$1138.00 <\/td>\r\n\t\t\t\t	$946.0 <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"15","total_discounted_price":"1081.0","deposit":"0","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","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",805,"NEW","A12-CT196759",1138,1081,0,0,"3","3",3243,3243,3243,"2019-12-21 12:02:02","0",null,null,null,"2019-12-24","2020-03-23","3 months contract. Storage rental paid by cheque on Dec 21, 2019. Storage deposit transferred from agreement A12-CT196008 to this agreement.","2019-12-24","15",0,null,0,"0","2","2019-12-21 12:02:02","2","2019-12-21 12:02:02","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,49726","C180805","PERSONAL","Mr","KMW2WNS4\/2Ou1fiLVvP7rg==","bXicfGTTHvCncWFCqwKkUQ==","","2+TfOoy+5c7k+G5pAXlGhKviKQlQ6JMlJ23T5fHsKxBTgK45VYPwAcfHn7dYoNoQRM9cbLQN5++IWilHFxyTiUAmneE4Sfm5Ij8ZN2RhbSo=","vr\/AdzwKQbtT0jM33r1WTQ==","z\/nGCny6I9XIiNief2Hoy+Tox243fC9WIAZtWgdy2Cw=","DNNeq\/sh\/XOOePWAsw2neQ==",null,1,"4593"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","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":["6759","47","1138.0","946.00","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-24","2020-03-23","47"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-21 12:02:02","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":["6759",805,"SETTLED","A12-I197087","2019-12-21 12:02:02","2019-12-24","2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7087","RENT","\u9810\u7e73\u79df\u91d1",1,1081,"MO","1",1081,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7087","RENT","\u9810\u7e73\u79df\u91d1",2,1081,"MO","1",1081,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7087","RENT","\u9810\u7e73\u79df\u91d1",3,1081,"MO","1",1081,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3243,0,"7087"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-21 12:02:02","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":[805,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196737","2019-12-21 12:02:02",3243,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","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":["6737","DEPOSIT",null,"PAID","2019-12-21 12:02:02",0,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:02:02","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":["6737","INVOICE","7087","PAID","2019-12-21 12:02:02",3243,"2","2019-12-21 12:02:02","2","2019-12-21 12:02:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 12:19:56","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","076,32348","13 months contract. Special offer the 13th month free and 5% discount. Storage rental and deposit paid by cheque on Dec 20,2019. Smartcard and padlock provided on Dec 12,2019.","2019-12-21 12:19:56","2","hbkan9PC5SCnBxQh2lhA4w==","8prF7nhsVTNe17dAh1fxaQ==","9O4jDXDmgsvAbwHaGsZr9ZsPYV0gf2SClE1cZWOjqo4=","yx7tYEMwbhoAb5+hWhpbtQ==","1MKFndNSyX14rbajFwvnAUcjbutwvZZaYypNuvSjkWaJl5\/0ts0\/9gC26Hhr7IYJO1UNi2orWkuO0GAA9xdXAQ==",6758]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 14:50:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-21 15:52:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****