{"created_at":"2020-06-04 12:04:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:04:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":486,"customer_code":"C170486","identity_type":"PERSONAL","identity_id":"E794310(9)","title":"Mr","lastname":"Kam","firstname":"Shuk Fan","companyname":"","email":null,"tel":"95207230","address":"73 Waterloo Road 6\/F Kowloon H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-03","renew_room_key":"056,12123","renew_remark":"12 months contract. Special renewal offer, $200 wellcome coupon offered. Storage rental paid by cheque deposit on June 4 and June 5, 2019. Storage deposit transferred from agreement A14-CT183832 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195147, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"448","room_code":"J30","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13668,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-03","rent_from":"2020-06-03","rent_to":"2021-06-02","delivery_service":"0","remark":"12 months contract. Special renewal offer, $300 Maxim's voucher offered. Storage rental paid by bank transfer on June 3, 2020. Storage deposit transferred from agreement A14-CT195147 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13668,"final_order_total":13668,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,12123","order_product":[],"pass":true}},"first_order_id":"3832","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>
J30 <\/td>\r\n\t\t\t\t\t	4X5X8 <\/td>\r\n\t\t\t\t\t	$1528.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/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":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",486,"NEW","A14-CT208049",1528,1139,0,0,"12","12",13668,13668,13668,"2020-06-04 12:12:06","0",null,null,null,"2020-06-03","2021-06-02","12 months contract. Special renewal offer, $300 Maxim's voucher offered. Storage rental paid by bank transfer on June 3, 2020. Storage deposit transferred from agreement A14-CT195147 to this agreement.","2020-06-03","20",0,null,0,"0","2","2020-06-04 12:12:05","2","2020-06-04 12:12:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,12123","C170486","PERSONAL","Mr","FNkXDjpCtAd08vZ3FTqiQw==","23wCRdcybxUEHt5OHLfIwQ==","","XkHgtI2aJn6ay26pld2+NaDo6stJXE\/SosJv+N19OZL+p4r0fiduHm+vuh2w2ROZ","eDkFkOw+a3rqWAZzmZ6klg==",null,"VFP5G3gVB22HM6hiM8oFXA==",null,1,"3832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8049","448","1528.0","1528.00","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-03","2021-06-02","448"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049",486,"SETTLED","A14-I208378","2020-06-04 12:12:05","2020-06-03","2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8378","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"8378"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[486,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208021","2020-06-04 12:12:05",13668,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8021","DEPOSIT",null,"PAID","2020-06-04 12:12:05",0,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:12:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8021","INVOICE","8378","PAID","2020-06-04 12:12:05",13668,"2","2020-06-04 12:12:05","2","2020-06-04 12:12:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:13:41","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","0012491767, 0012453323","12 months contract. Storage rental paid by bank transfer on Sep 20, 2019. Storage deposit $810 transferred from agreement C15-CT194579 to this agreement.\r\n","2020-06-04 12:13:41","2","kkRnMtk38aHWXhpdNaJ24Q==","YWZImkC2t5z2Ges+rSGvIg==","ndnjSQ1Nvz+AfUIdJhPxKYnsK73OI0+3b1bq9nECeOA=","29P8K9aW7j0pkpjdJEH96Q==","npyWlO9u2L70jC8puXBKvTUPt5uZoDXViYlrdzxUcqBm00b73JL5Mx5eN0fL2amIYAtm42kocZWF993f90qdl8AQ2Z843ESbn\/jo0clS72U=",6011]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:15:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:17:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:31:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 12:31:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:04:17","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` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","'0012492375","12 months contract. Special offer 5% 'rent now' discount and the 11th & 12th months free for the first contract. Storage rental and 1 month deposit paid by bank transfer on Jun 02,2020. Smart card mailed out on Jun 03,2020.","2020-06-04 14:04:17","2","ddrfzAYTmkL\/QNu3psjONQ==","VEr4RtjrPyCEI5wmpFKxTA==","T38ux9tVoBcPpsL1ss6dhL+yW0JF1s9l1wQtsfOhtkE=","6vVhnNE9a+WnP+kudBnf9Q==","tIB0p3kqu0cxirOY4SYbOohAN5sWtQAI7kNtytbFdGxBc5ppKLFHPaaLJ45knemndo1jLs88m9rf322LOoQCDsYmpwZVJoBRP5IrvN668QxXnLGwKHj4CbDQOVncCXPs","Loyal Wealthy International Limited",8039]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:06:25","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","0012403776","'12 month contract. special offer \" free 2 month\". storage rental and deposit paid by cheque on 13 June, 2019. smartcard provided on 13 June, 2019.","2020-06-04 14:06:24","2","kkRnMtk38aHWXhpdNaJ24Q==","YWZImkC2t5z2Ges+rSGvIg==","ndnjSQ1Nvz+AfUIdJhPxKYnsK73OI0+3b1bq9nECeOA=","29P8K9aW7j0pkpjdJEH96Q==","npyWlO9u2L70jC8puXBKvTUPt5uZoDXViYlrdzxUcqBm00b73JL5Mx5eN0fL2amIYAtm42kocZWF993f90qdl8AQ2Z843ESbn\/jo0clS72U=",5211]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:49","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A12-CT207564 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207785, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"321","room_code":"F06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"332","room_code":"F17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-05","rent_from":"2020-06-05","rent_to":"2020-07-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A12-CT207785 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,32853","order_product":[],"pass":true}},"first_order_id":"4888","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> F06 <\/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> F17 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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",724,"NEW","A12-CT208050",2096,2058,0,0,"1","1",2058,2058,2058,"2020-06-04 14:44:50","0",null,null,null,"2020-06-05","2020-07-04","1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A12-CT207785 to this agreement.\r\n","2020-06-05","28",0,null,0,"0","2","2020-06-04 14:44:49","2","2020-06-04 14:44:49","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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":["8050","321","998.0","998.00","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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-06-05","2020-07-04","321"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 14:44:50","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":["8050","332","1098.0","1098.00","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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-06-05","2020-07-04","332"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 14:44:50","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":["8050",724,"SETTLED","A12-I208379","2020-06-04 14:44:49","2020-06-05","2","2020-06-04 14:44:49","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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":["8379","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-06-04 14:44:49","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"8379"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 14:44:50","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":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208022","2020-06-04 14:44:49",2058,"2","2020-06-04 14:44:49","2","2020-06-04 14:44:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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":["8022","DEPOSIT",null,"PAID","2020-06-04 14:44:49",0,"2","2020-06-04 14:44:49","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:44:50","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":["8022","INVOICE","8379","PAID","2020-06-04 14:44:49",2058,"2","2020-06-04 14:44:49","2","2020-06-04 14:44:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":21,"customer_code":"C150021","identity_type":"PERSONAL","identity_id":"K072676(1)","title":"Mr","lastname":"Cheng","firstname":"Wai Kin","companyname":"","email":"cwkroy@yahoo.com.hk","tel":"93033492","address":"Flat 2B, Block 14, Chi Fu Fa Yuen, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-22","renew_room_key":"054,59552","renew_remark":"3 months contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT206855 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207265, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"211","room_code":"D15","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-22","rent_from":"2020-04-22","rent_to":"2020-05-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A12-CT207265 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,59552","order_product":[],"pass":true}},"first_order_id":"5130","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> D15 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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",21,"NEW","A12-CT208051",598,598,0,0,"1","1",598,598,598,"2020-06-04 14:47:36","0",null,null,null,"2020-04-22","2020-05-21","1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A12-CT207265 to this agreement.\r\n","2020-04-22","12",0,null,0,"0","2","2020-06-04 14:47:36","2","2020-06-04 14:47:36","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,59552","C150021","PERSONAL","Mr","MLCe5vmZDmd8r2fUbVc13A==","UCPBCXrBLI9U7KKsPqgmNA==","","6e\/BP2gUBkTAY5yPTvoK7RwdSoD67HISilZb2LuPrHeikacP8o2utC4vDnnnhvni","YemE6fp9WuJaRz9GK0KgKA==","EGeNYE9J78gEvzgbENBQeL\/9UQajTXO7AoyiNhVjolY=","6OwZ\/TwaT9UKVnq5GjUg9w==",null,1,"5130"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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":["8051","211","598.0","598.00","2","2020-06-04 14:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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-22","2020-05-21","211"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 14:47:36","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":["8051",21,"SETTLED","A12-I208380","2020-06-04 14:47:36","2020-04-22","2","2020-06-04 14:47:36","2","2020-06-04 14:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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":["8380","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-04 14:47:36","2","2020-06-04 14:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8380"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 14:47:36","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":[21,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208023","2020-06-04 14:47:36",598,"2","2020-06-04 14:47:36","2","2020-06-04 14:47:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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":["8023","DEPOSIT",null,"PAID","2020-06-04 14:47:36",0,"2","2020-06-04 14:47:36","2","2020-06-04 14:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:47:36","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":["8023","INVOICE","8380","PAID","2020-06-04 14:47:36",598,"2","2020-06-04 14:47:36","2","2020-06-04 14:47:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1131,"customer_code":"C181131","identity_type":"PERSONAL","identity_id":"Z345376(7)","title":"Mr","lastname":"Chan","firstname":"Siu Cheung","companyname":"","email":"siucheung2004@yahoo.com.hk","tel":"98251393","address":"Room 2204, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-03","renew_room_key":"0005012995","renew_remark":"1 month contract. Storage rental paid by PPS on May 4, 2020. Storage deposit transferred from agreement A05-CT207585 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207781, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1077","room_code":"A05-075","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-06-03","rent_from":"2020-06-03","rent_to":"2020-07-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A05-CT207781 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005012995","order_product":[],"pass":true}},"first_order_id":"4845","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-075 <\/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-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1131,"NEW","A05-CT208052",598,598,0,0,"1","1",598,598,598,"2020-06-04 14:49:15","0",null,null,null,"2020-06-03","2020-07-02","1 month contract. Storage rental paid by PPS on June 3, 2020. Storage deposit transferred from agreement A05-CT207781 to this agreement.\r\n","2020-06-03","8",0,null,0,"0","2","2020-06-04 14:49:14","2","2020-06-04 14:49:14","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005012995","C181131","PERSONAL","Mr","fGcZizJCatuKFWu4ZRrKSA==","U9yoE9KqV1v8YlRkf7Q2yg==","","CQCYoAe3GOoadJVRzLyv+sNtTDGIle0HVMeR83McsJynyrP8tFX204cW64FCZ5NA5j\/z2cPdugPvlnA2Si9a8Q==","9k5P13X5Z+o0UYFE5+2bdg==","ApBLMJPz\/Z49uwpRoZz00ngQMrV7EI2jJmIQp3ku3DM=","EdsRFjojZ1QPZDY\/kWek4g==",null,1,"4845"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8052","1077","598.0","598.00","2","2020-06-04 14:49:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-03","2020-07-02","1077"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052",1131,"SETTLED","A05-I208381","2020-06-04 14:49:14","2020-06-03","2","2020-06-04 14:49:14","2","2020-06-04 14:49:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8381","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-04 14:49:14","2","2020-06-04 14:49:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8381"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1131,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208024","2020-06-04 14:49:14",598,"2","2020-06-04 14:49:14","2","2020-06-04 14:49:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8024","DEPOSIT",null,"PAID","2020-06-04 14:49:14",0,"2","2020-06-04 14:49:14","2","2020-06-04 14:49:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 14:49:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8024","INVOICE","8381","PAID","2020-06-04 14:49:14",598,"2","2020-06-04 14:49:14","2","2020-06-04 14:49:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 15:21:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 15:30:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 15:51:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1035&filter3=undefined","floor_plan_rent_room":[{"room_id":"1133","master_room_id":"114","room_code":"A05-131"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":55,"customer_code":"C160055","identity_type":"BUSINESS","identity_id":"39578785","title":"Mr","lastname":"Tang ","firstname":"Chih Hao , Wilson","companyname":"GARDENS COMPANY","email":"wilson@gardens-co.com","tel":"90931502","address":"Rm 1501 , 15\/F Chung Ying Bldg , 20 Connaught Rd West","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2288.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-22","renew_room_key":"137,03369","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 26, 2019. Storage deposit transferred from agreement A12-CT195032 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196510, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"25","order_discount":[{"master_room_discount_id":"98","master_room_id":"25","discount_type":"%","price":"2068.00","disocunted_price":"1655.60","discount":"19.94","monthly_deduct":412.3592,"room_id":"364","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"364","room_code":"G05","retail_price":"2068.0","discounted_price":1655.6,"location_id":"1"}],"roughly_size":"45","total_retail_price":2068,"total_discounted_price":2288,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":13728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-11-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 4, 2020. Storage deposit transferred from agreement A12-CT196510 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13728,"final_order_total":13728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,03369","order_product":[],"pass":true}},"first_order_id":"3953","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> G05 <\/td>\r\n\t\t\t\t\t 5X9X8 <\/td>\r\n\t\t\t\t\t $2068.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"45","total_discounted_price":"2288.0","deposit":"0","total_retail_price":"2068.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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",55,"NEW","A12-CT208053",2068,2288,0,0,"6","6",13728,13728,13728,"2020-06-04 16:37:55","0",null,null,null,"2020-05-22","2020-11-21","6 months contract. Storage rental paid by bank transfer on June 4, 2020. Storage deposit transferred from agreement A12-CT196510 to this agreement.\r\n","2020-05-22","45",0,null,0,"0","2","2020-06-04 16:37:55","2","2020-06-04 16:37:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,03369","C160055","BUSINESS","Mr","DmUV1f9Om+ciD9QBW0pkI4GzsHj46gV9MjbteVkipDE=","D2u5F1t2Ua28czFdD4B98Q==","GARDENS COMPANY","NyRzOCZIoNBlrnSZFhQdhLamAZM71NFNKVGwEkm+C1iZ02\/Hydadov4aZe7GRm7qGwo08BHLAAQpH5QsmXB8UA==","rM3Fk\/3GC8GznRYpHrVR8g==","ay5ntNme1V2Ka3VE2CeVPmpC1Ifx49Obtju6Y9bBYWk=",null,"C9Kt08YDth67eW\/PvK2aYw==",1,"3953"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8053","98","25","364","%","19.94",412.3592,"2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8053","364","2068.0",1655.6,"2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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-05-22","2020-11-21","364"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 16:37:55","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":["8053",55,"SETTLED","A12-I208382","2020-06-04 16:37:55","2020-05-22","2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",1,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",2,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",3,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",4,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",5,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8382","RENT","\u9810\u7e73\u79df\u91d1",6,2288,"MO","1",2288,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13728,0,"8382"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 16:37:55","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":[55,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208025","2020-06-04 16:37:55",13728,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8025","DEPOSIT",null,"PAID","2020-06-04 16:37:55",0,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 16:37:55","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":["8025","INVOICE","8382","PAID","2020-06-04 16:37:55",13728,"2","2020-06-04 16:37:55","2","2020-06-04 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:20:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:26:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1063&filter3=undefined","floor_plan_rent_room":[{"room_id":"1545","master_room_id":"201","room_code":"A16-054"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-054 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M542946(9)","title":"Ms","lastname":"WOOLCOCK","firstname":"Andrea","companyname":"","email":"andreawoolcock@yahoo.com.au","tel":"63471091","address":"20\/F, 20 Belleview Drive, Repulse Bay, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1545","room_code":"A16-054","retail_price":"1090.0","discounted_price":"1090.00","location_id":"7"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":2180,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7572,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"494.00","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2020-11-22","delivery_service":"0","remark":"6 months contract. Special offer 5% \"rent now\" discount. Customer is referred by Ms Eileen Haskins. $200 referral bonus for both of them. Storage rental and deposit paid by bank transfer on May 23, 2020. Smartcard and padlock provided. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":494,"order_total":8066,"final_order_total":7572,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'0005014267","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"981.00","deposit":"2180.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201607","PERSONAL","Ms","iKuo0HdiXnf9KqTYdVj+2Q==","uCaU4t8PGhwdgcfxaKUYgQ==","","018RLBZhP7ZF3VG41hgq7Q==","cG4Y4DG7VsHMew5Pzsf5mMeV2TG+LOVLtXq3+Y+EzVA=","FsHx4RxxdMWo8lZK4ABaa4dIt2ZBYm9fz2TeXMsbOYkOmW5mVvmbITceRuY9Ocpd1ui3TXRR5uZxPnNTt8A1Vg==","ZH8ltwZAwcKcpdugvQX7iQ==",null,"cG4Y4DG7VsHMew5Pzsf5mMeV2TG+LOVLtXq3+Y+EzVA=","FDyB5f6o7H+Xeg9GCTv1XQ==","2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1607,"NEW","A16-CT208054",1090,981,2180,0,"6","6",7572,8066,7572,"2020-06-04 17:44:42","0",null,null,null,"2020-05-23","2020-11-22","6 months contract. Special offer 5% \"rent now\" discount. Customer is referred by Ms Eileen Haskins. $200 referral bonus for both of them. Storage rental and deposit paid by bank transfer on May 23, 2020. Smartcard and padlock provided. ","2020-05-23","12",0,null,494,"494.00","2","2020-06-04 17:44:40","2","2020-06-04 17:44:40","BANKIN","","","","BANKIN","","","",null,0,"'0005014267","C201607","PERSONAL","Ms","iKuo0HdiXnf9KqTYdVj+2Q==","uCaU4t8PGhwdgcfxaKUYgQ==","","FsHx4RxxdMWo8lZK4ABaa4dIt2ZBYm9fz2TeXMsbOYkOmW5mVvmbITceRuY9Ocpd1ui3TXRR5uZxPnNTt8A1Vg==","018RLBZhP7ZF3VG41hgq7Q==","cG4Y4DG7VsHMew5Pzsf5mMeV2TG+LOVLtXq3+Y+EzVA=","ZH8ltwZAwcKcpdugvQX7iQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8054","1545","1090.0","1090.00","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-23","2020-11-22","1545"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8054","A16-D205452","PAID",2180,0,"2020-11-22","2020-06-04 17:44:40","2020-06-04 17:44:40","2","2020-06-04 17:44:40","2","2020-06-04 17:44:40",1607]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8054",1607,"SETTLED","A16-I208383","2020-06-04 17:44:40","2020-05-23","2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,487,"MO","1",487,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8383","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5392,0,"8383"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1607,"BANKIN","","","","BANKIN","","","","PAID","P208026","2020-06-04 17:44:40",7572,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8026","DEPOSIT","5452","PAID","2020-06-04 17:44:40",2180,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8026","INVOICE","8383","PAID","2020-06-04 17:44:40",5392,"2","2020-06-04 17:44:40","2","2020-06-04 17:44:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1063&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1706","master_room_id":"205","room_code":"A16-215"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-215 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"V445371(9)","title":"Mr","lastname":"HO","firstname":"Mun Ho","companyname":"","email":"BBBOP0521@yahoo.com.hk","tel":"53180707","address":"5C, Pokfulam Village, Pokfulam, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1706","room_code":"A16-215","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-09-12","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cash on June 4, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":2900,"final_order_total":2900,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'076, 32844","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201608","PERSONAL","Mr","kWwUlpkIQr5yXKVkgfVYbA==","Zzv1eRCimQisUlUlw\/fpjg==","","V9Q\/Y+AqsqflbZatI92naQ==","vA8JXxNfQ1EzISo0bVCR\/4KbyV5bISjoZO2McsmB0J0=","b78GrPqy5wyoLoFw6t2ofCjYP25F0N2pWu41cxrQL5v4HTT39eUKOPulDzyfMfqp","fyxOVoMsFAp4KySAtceJzg==",null,"vA8JXxNfQ1EzISo0bVCR\/4KbyV5bISjoZO2McsmB0J0=","lq5\/akA5e6ooUfKjZ0IKzQ==","2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1608,"NEW","A16-CT208055",1857,568,1196,0,"3","3",2900,2900,2900,"2020-06-04 18:30:43","0",null,null,null,"2020-06-13","2020-09-12","3 months contract. Storage rental and deposit paid by cash on June 4, 2020. ","2020-06-13","24",0,null,0,"0","2","2020-06-04 18:30:41","2","2020-06-04 18:30:41","CASH","","","","CASH","","","",null,0,"'076, 32844","C201608","PERSONAL","Mr","kWwUlpkIQr5yXKVkgfVYbA==","Zzv1eRCimQisUlUlw\/fpjg==","","b78GrPqy5wyoLoFw6t2ofCjYP25F0N2pWu41cxrQL5v4HTT39eUKOPulDzyfMfqp","V9Q\/Y+AqsqflbZatI92naQ==","vA8JXxNfQ1EzISo0bVCR\/4KbyV5bISjoZO2McsmB0J0=","fyxOVoMsFAp4KySAtceJzg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8055","1706","1857.0","1857.00","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-09-12","1706"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-04 18:30:43","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":["8055","A16-D205453","PAID",1196,0,"2020-09-12","2020-06-04 18:30:41","2020-06-04 18:30:41","2","2020-06-04 18:30:41","2","2020-06-04 18:30:41",1608]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8055",1608,"SETTLED","A16-I208384","2020-06-04 18:30:41","2020-06-13","2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8384","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8384","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8384","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8384"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1608,"CASH","","","","CASH","","","","PAID","P208027","2020-06-04 18:30:41",2900,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8027","DEPOSIT","5453","PAID","2020-06-04 18:30:41",1196,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-04 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8027","INVOICE","8384","PAID","2020-06-04 18:30:41",1704,"2","2020-06-04 18:30:41","2","2020-06-04 18:30:41"]},"data_before":[],"data_after":[],"step":1} *****