{"created_at":"2020-02-04 10:15:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:15:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1010&filter3=undefined&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":241,"customer_code":"C160241","identity_type":"PERSONAL","identity_id":"C359949(1)","title":"Ms","lastname":"Lau","firstname":"Wan Hung","companyname":"","email":"estelle@worldasialtd.com","tel":"92622670","address":"Room 2507, Tse On House, Yue On Court, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-27","renew_room_key":"054,61922","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 10, 2019. Storage deposit transferred from agreement A12-CT194443 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195692, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"346","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"346","room_code":"F31","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-07-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT195692 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,61922","order_product":[],"pass":true}},"first_order_id":"4443","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>
F31 <\/td>\r\n\t\t\t\t\t	4X3X8 <\/td>\r\n\t\t\t\t\t	$998.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",241,"NEW","A12-CT207100",998,899,0,0,"6","6",5394,5394,5394,"2020-02-04 10:40:01","0",null,null,null,"2020-01-27","2020-07-26","6 months contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT195692 to this agreement.","2020-01-27","12",0,null,0,"0","2","2020-02-04 10:40:00","2","2020-02-04 10:40:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,61922","C160241","PERSONAL","Ms","OrOqXUH5H18MQ62AdIeXBQ==","oe4emdjBwqJ3qUpOcI17hw==","","kublxbXEwH3ivEZQeiuBZKQ1LEhn9N+yjgc2vG6T28WlQtlF28YOCsj4uOSzjnceD1+T3fReIzrljbd37w5Qig==","j\/HO1nnuHWh4dIcKDor8\/g==","P7e1bYbJIL9N5ToOPce1UgHHDYEfPGzGcRAhRPHgy0w=","OFmVhEqyvneCrILBLqoV4w==",null,1,"4443"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7100","70","6","346","%","9.96",99.4008,"2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7100","346","998.0",898.6,"2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-27","2020-07-26","346"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7100",241,"SETTLED","A12-I207428","2020-02-04 10:40:00","2020-01-27","2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7428","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7428"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[241,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207076","2020-02-04 10:40:00",5394,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7076","DEPOSIT",null,"PAID","2020-02-04 10:40:00",0,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 10:40:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7076","INVOICE","7428","PAID","2020-02-04 10:40:00",5394,"2","2020-02-04 10:40:00","2","2020-02-04 10:40:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1010&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1041","master_room_id":"113","room_code":"A05-039"}],"_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> A05-039 <\/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> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D291415(9)","title":"Mr","lastname":"LAM","firstname":"Kin Kong","companyname":"","email":"kin_18c@hotmail.com","tel":"93080003","address":"Rm 4, 15\/F, Hoi Wu Court, Aberdeen Centre, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1041","room_code":"A05-039","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":2180,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13364,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1569.00","warehousing_date":"2020-02-05","rent_from":"2020-02-05","rent_to":"2021-03-04","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% rent now offer. Storage rental and deposit paid by EPS on February 4, 2020. Smartcard provided on February 4, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1569,"order_total":14933,"final_order_total":13364,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012462722","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-02-04 11:36:19","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":["C201502","PERSONAL","Mr","DY3CHM0+YgjZqpfnHnkk7Q==","BLxWt7e4owYJMFkn6\/eeMQ==","","3w5xzvAJZAYXoWJr5Opt5w==","Ao8C4SxKX0i692MarxMD+ybuxZyGR3uDeui+clLTtfI=","3N7zkcBHMzh7uzBjX7CFcZsVojVbzR\/wKXTffzsEarGjs+jyPmJeXTTHo71vZaQYNGw4ljGPxjbGvRFPW25DnA==","fEgTGG\/NgxCYJgw227jWvA==",null,"Ao8C4SxKX0i692MarxMD+ybuxZyGR3uDeui+clLTtfI=","fdaEVmsJE8BZ1NqJCzaH9A==","2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1502,"NEW","A05-CT207101",1090,981,2180,0,"13","13",13364,14933,13364,"2020-02-04 11:36:20","0",null,null,null,"2020-02-05","2021-03-04","13 months contract. Special offer the 13th month free and 5% rent now offer. Storage rental and deposit paid by EPS on February 4, 2020. Smartcard provided on February 4, 2020. ","2020-02-05","12",0,null,1569,"1569.00","2","2020-02-04 11:36:18","2","2020-02-04 11:36:18","EPS","","","","EPS","","","",null,0,"'0012462722","C201502","PERSONAL","Mr","DY3CHM0+YgjZqpfnHnkk7Q==","BLxWt7e4owYJMFkn6\/eeMQ==","","3N7zkcBHMzh7uzBjX7CFcZsVojVbzR\/wKXTffzsEarGjs+jyPmJeXTTHo71vZaQYNGw4ljGPxjbGvRFPW25DnA==","3w5xzvAJZAYXoWJr5Opt5w==","Ao8C4SxKX0i692MarxMD+ybuxZyGR3uDeui+clLTtfI=","fEgTGG\/NgxCYJgw227jWvA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7101","1041","1090.0","1090.00","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-05","2021-03-04","1041"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 11:36:20","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":["7101","A05-D205277","PAID",2180,0,"2021-03-04","2020-02-04 11:36:18","2020-02-04 11:36:18","2","2020-02-04 11:36:18","2","2020-02-04 11:36:18",1502]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7101",1502,"SETTLED","A05-I207429","2020-02-04 11:36:18","2020-02-05","2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,393,"MO","1",393,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7429","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11184,0,"7429"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1502,"EPS","","","","EPS","","","","PAID","P207077","2020-02-04 11:36:18",13364,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7077","DEPOSIT","5277","PAID","2020-02-04 11:36:18",2180,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 11:36:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7077","INVOICE","7429","PAID","2020-02-04 11:36:18",11184,"2","2020-02-04 11:36:18","2","2020-02-04 11:36:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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=1272&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1424,"customer_code":"C191424","identity_type":"PERSONAL","identity_id":"D148997(7)","title":"Ms","lastname":"SHEUNG","firstname":"Tsang Mui","companyname":"","email":null,"tel":"96102707","address":"Flat A, 13\/F, No 19 Greig Crescent, Quarry Bay, Hong Kong.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"735.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-04","renew_room_key":"'0012489016","renew_remark":"3 months contract. Special offer 5% discount. Storage rental and deposit paid by cheque on October 16, 2016. Smartcard paid on October 16, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196150, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $773.0","renew_master_room_id":"164","order_discount":[],"order_room":[{"room_id":"1312","room_code":"C15-006","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":735,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2205,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2020-05-03","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $773 transferred from agreement C15-CT196150 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2205,"final_order_total":2205,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012489016","order_product":[],"pass":true}},"first_order_id":6150,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-006 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"10","total_discounted_price":"735.0","deposit":"0","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1424,"NEW","C15-CT207102",773,735,0,0,"3","3",2205,2205,2205,"2020-02-04 13:33:28","0",null,null,null,"2020-02-04","2020-05-03","3 months contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $773 transferred from agreement C15-CT196150 to this agreement.","2020-02-04","10",0,null,0,"0","2","2020-02-04 13:33:28","2","2020-02-04 13:33:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012489016","C191424","PERSONAL","Ms","AAX9PhWQNYbujKJ0Pa5iWQ==","JKNOKuxB8y\/wxkNzxEIjjQ==","","8WYXZRvXIf\/ZXNnXiEVMrtm8XrHbFzF\/WqhOXIomMWGV8NDtfsTiZAwuDfasGmus+IPaMXgBboAgbQM2EkkEJw==","+EAg0QD+zYfhd+1wDAP9eA==",null,"ry2sS1VYP3hAQBXXwRrxmg==",null,1,6150]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7102","1312","773.0","773.00","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-04","2020-05-03","1312"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:33:28","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":["7102",1424,"SETTLED","C15-I207430","2020-02-04 13:33:28","2020-02-04","2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7430","RENT","\u9810\u7e73\u79df\u91d1",1,735,"MO","1",735,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7430","RENT","\u9810\u7e73\u79df\u91d1",2,735,"MO","1",735,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7430","RENT","\u9810\u7e73\u79df\u91d1",3,735,"MO","1",735,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2205,0,"7430"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 13:33:28","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":[1424,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207078","2020-02-04 13:33:28",2205,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7078","DEPOSIT",null,"PAID","2020-02-04 13:33:28",0,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:33:28","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":["7078","INVOICE","7430","PAID","2020-02-04 13:33:28",2205,"2","2020-02-04 13:33:28","2","2020-02-04 13:33:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1272&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1172,"customer_code":"C191172","identity_type":"PERSONAL","identity_id":"D664942(5)","title":"Mr","lastname":"CHAN","firstname":"Kai Man","companyname":"","email":"manckm@gmail.com","tel":"93607941","address":"Flat 2, 7\/F, Hung Lai House, Hung Fuk Court, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1373.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-10","renew_room_key":"0012492282","renew_remark":"12 months Contract. Storage Rental and Deposit paid by EPS on January 09, 2019. Smartcard and padlock on January 09, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194138, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"116","order_discount":[],"order_room":[{"room_id":"1110","room_code":"A05-108","retail_price":"1605.0","discounted_price":"1605.00","location_id":"4"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":17340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1445.00","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2021-02-09","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Feb 04,2020. Deposit $3210 transferred from A05-CT194138 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1445,"order_total":18785,"final_order_total":17340,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012492282","order_product":[],"pass":true}},"first_order_id":4138,"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-108 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1172,"NEW","A05-CT207103",1605,1445,0,0,"13","13",17340,18785,17340,"2020-02-04 13:48:12","0",null,null,null,"2020-01-10","2021-02-09","13 months contract. Special renewal offer the 13th month free. Storage rental paid by bank transfer on Feb 04,2020. Deposit $3210 transferred from A05-CT194138 to this agreement.","2020-01-10","20",0,null,1445,"1445.00","2","2020-02-04 13:48:12","2","2020-02-04 13:48:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012492282","C191172","PERSONAL","Mr","SfaGKfUgxHLgyzjhNWNEyA==","8BEgNhGpCR8jGkzUtrIcXg==","","zqeqUKwRaPAaoGKR0FXr4pcz2wP0uszNZH71Qsh6mpU+b4iUJuFYD5\/pXKdNSr83","zPlpWewgDjY5ST59Ej26rw==","VaZaQYK8N\/DrK8Q7vOxSBPQXO0fPKMRdzbT71RA\/7ZU=","Vw5nnM71SISxuDiDqsQAxA==",null,1,4138]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7103","1110","1605.0","1605.00","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2021-02-09","1110"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7103",1172,"SETTLED","A05-I207431","2020-02-04 13:48:12","2020-01-10","2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7431","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17340,0,"7431"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1172,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207079","2020-02-04 13:48:12",17340,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","DEPOSIT",null,"PAID","2020-02-04 13:48:12",0,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:48:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7079","INVOICE","7431","PAID","2020-02-04 13:48:12",17340,"2","2020-02-04 13:48:12","2","2020-02-04 13:48:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:57:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":392,"customer_code":"C170392","identity_type":"PERSONAL","identity_id":"P988279(4)","title":"Mr","lastname":"Lee","firstname":"Kenneth Pak Lok","companyname":"","email":"kenneth_P_Lee@yahoo.com","tel":"69712837","address":"Flat B,22\/F,Tower 2,Sham Wan Towers 3 Ap Lei Chau Drive, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5098.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"138,17024","renew_remark":"1 month contract. Storage rental paid by cheque on January 7, 2020. Storage deposit transferred from agreement A12-CT183904 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206884, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"115","room_code":"B63","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"114","room_code":"B62","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"106","room_code":"B54","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"105","room_code":"B53","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"80","total_retail_price":6112,"total_discounted_price":5098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":5098,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206884 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5098,"final_order_total":5098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,17024","order_product":[],"pass":true}},"first_order_id":"3904","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B63 <\/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> \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> B62 <\/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> \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> B54 <\/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> \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> B53 <\/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> \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":"80","total_discounted_price":"5098.0","deposit":"0","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",392,"NEW","A12-CT207104",6112,5098,0,0,"1","1",5098,5098,5098,"2020-02-04 13:58:11","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206884 to this agreement. \r\n","2020-02-01","80",0,null,0,"0","2","2020-02-04 13:58:10","2","2020-02-04 13:58:10","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,17024","C170392","PERSONAL","Mr","BEeVus+G60XJp0DLlFrw5Q==","kiriEIqhcx866RNZiMXdKQ==","","VBX\/XdmRdgqhOmFZK5ALSyxeI8iku\/iH07d+anuZyhubwt\/HaXR\/HjzcA3Wmmw6VBgIGznHH4FxYZNbCfAjNaYs6u2AtWPKHmRXPxCIWvd4=","u2w9koTKJQGsIdFvv8jAeA==","L4egO5Mnnt0ETYeC+58eDoCS0BetZV+b23ZS6nqWBBs=","1A9B3kdXJoFpDPdlSZGM4g==",null,1,"3904"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7104","115","1528.0","1528.00","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","115"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7104","114","1528.0","1528.00","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","114"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7104","106","1528.0","1528.00","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","106"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7104","105","1528.0","1528.00","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","105"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7104",392,"SETTLED","A12-I207432","2020-02-04 13:58:10","2020-02-01","2","2020-02-04 13:58:10","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7432","RENT","\u9810\u7e73\u79df\u91d1",1,5098,"MO","1",5098,"2","2020-02-04 13:58:10","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5098,0,"7432"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[392,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207080","2020-02-04 13:58:10",5098,"2","2020-02-04 13:58:10","2","2020-02-04 13:58:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7080","DEPOSIT",null,"PAID","2020-02-04 13:58:10",0,"2","2020-02-04 13:58:10","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 13:58:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7080","INVOICE","7432","PAID","2020-02-04 13:58:10",5098,"2","2020-02-04 13:58:10","2","2020-02-04 13:58:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":772,"customer_code":"C180772","identity_type":"PERSONAL","identity_id":"D003504(2)","title":"Ms","lastname":"Ho","firstname":"Sau Ling Pauline","companyname":"","email":"paulinechee38@hotmail.com","tel":"92858272","address":"Rm 2601 Mei Fung Court, Aberdeen Centre, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-12","renew_room_key":"055,14472","renew_remark":"6 months contract. Storage rental paid by PPS on August 2, 2019. Storage deposit transferred from agreement A18-CT194362 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195643, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"808","room_code":"Q05","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":17340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1445.00","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2021-03-11","delivery_service":"0","remark":"12 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A18-CT195643 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":1445,"order_total":18785,"final_order_total":17340,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,14472","order_product":[],"pass":true}},"first_order_id":"4362","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> Q05 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1445.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",772,"NEW","A18-CT207105",1605,1445,0,0,"13","13",17340,18785,17340,"2020-02-04 14:02:43","0",null,null,null,"2020-02-12","2021-03-11","12 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A18-CT195643 to this agreement.","2020-02-12","20",0,null,1445,"1445.00","2","2020-02-04 14:02:42","2","2020-02-04 14:02:42","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,14472","C180772","PERSONAL","Ms","wltMcia7CmwNIEHVK6TuRQGwaNwOLoaBBm3TIqeI5Q8=","D\/skxQ5s\/L5yyRWaDK\/iSg==","","x3K4JVqJ\/81cpLqaVJ8RuuoVeMZxR9efFebd2WNgMXL4T9B8bIDU0+UXi6jnWbZr","oJaz4mjvJV8QjtzOLnlbRA==","f1SWoq8dOoiEUlaHX6Cqv3pLljezSjz8csM9DDGLG\/4=","JF6lR2pcQuCoaeLvDVS40Q==",null,1,"4362"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7105","808","1605.0","1605.00","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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-02-12","2021-03-11","808"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 14:02: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":["7105",772,"SETTLED","A18-I207433","2020-02-04 14:02:42","2020-02-12","2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7433","RENT","\u9810\u7e73\u79df\u91d1",13,1445,"MO","1",1445,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17340,0,"7433"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 14:02: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":[772,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207081","2020-02-04 14:02:42",17340,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7081","DEPOSIT",null,"PAID","2020-02-04 14:02:42",0,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:02: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":["7081","INVOICE","7433","PAID","2020-02-04 14:02:42",17340,"2","2020-02-04 14:02:42","2","2020-02-04 14:02:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:22:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 14:26:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-27","renew_room_key":"052,49830","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit transferred from agreement A12-CT196248 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196572, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"362","room_code":"G03","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2572,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-27","rent_from":"2019-12-27","rent_to":"2020-02-26","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196572 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2572,"final_order_total":2572,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,49830","order_product":[],"pass":true}},"first_order_id":"4668","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> G03 <\/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> \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":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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",57,"NEW","A12-CT207106",1528,1286,0,0,"2","2",2572,2572,2572,"2020-02-04 15:01:38","0",null,null,null,"2019-12-27","2020-02-26","2 months contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196572 to this agreement.\r\n","2019-12-27","20",0,null,0,"0","2","2020-02-04 15:01:37","2","2020-02-04 15:01:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4668"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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":["7106","362","1528.0","1528.00","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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-27","2020-02-26","362"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 15:01:38","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":["7106",57,"SETTLED","A12-I207434","2020-02-04 15:01:37","2019-12-27","2","2020-02-04 15:01:37","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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":["7434","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-02-04 15:01:37","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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":["7434","RENT","\u9810\u7e73\u79df\u91d1",2,1286,"MO","1",1286,"2","2020-02-04 15:01:37","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2572,0,"7434"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 15:01:38","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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207082","2020-02-04 15:01:37",2572,"2","2020-02-04 15:01:37","2","2020-02-04 15:01:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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":["7082","DEPOSIT",null,"PAID","2020-02-04 15:01:37",0,"2","2020-02-04 15:01:37","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:01:38","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":["7082","INVOICE","7434","PAID","2020-02-04 15:01:37",2572,"2","2020-02-04 15:01:37","2","2020-02-04 15:01:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1120,"customer_code":"C181120","identity_type":"PERSONAL","identity_id":"K990796(3)","title":"Ms","lastname":"Lim","firstname":"Ngai Ying","companyname":"","email":"tclimny@yahoo.com.hk","tel":"98653330","address":"20A, Block A, Monticello, 48 Kennedy Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"CREDIT_CARD","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-29","renew_room_key":"0012401482","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit (including 3% charge $461) paid by credit card on November 26, 2018. Smartcard provided on November 26, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183734, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"249","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"1019","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1019","room_code":"A05-017","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-29","rent_from":"2019-11-29","rent_to":"2020-02-28","delivery_service":"0","remark":"3 months contract. Storage rental paid bank transfer on February 1, 2020. Storage deposit $2580 transferred from agreement A05-CT183734 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401482","order_product":[],"pass":true}},"first_order_id":3734,"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-017 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1226.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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",1120,"NEW","A05-CT207107",1290,1226,0,0,"3","3",3678,3678,3678,"2020-02-04 15:18:16","0",null,null,null,"2019-11-29","2020-02-28","3 months contract. Storage rental paid bank transfer on February 1, 2020. Storage deposit $2580 transferred from agreement A05-CT183734 to this agreement. ","2019-11-29","16",0,null,0,"0","2","2020-02-04 15:18:15","2","2020-02-04 15:18:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012401482","C181120","PERSONAL","Ms","nJGhBNHWOLtL64ual1FhFA==","WCEL8nEjkO0P1E7kTUoqkQ==","","Qr1SRqR2X49jk0j2hOhWiFEhOjiP14+1A6nt0Q0YK90cJMi6SRuNinj4hXfIri5qKfbQkbzl6w8BEFYfdt7b2g==","EgxkBPCBSIsAmJIjePUbYw==","Q7UrH7ZgViNFwAsZWBfCI\/D5dHSSButouyQRgnceP3w=","8JmQh3i8+8LWkp6AFiAV7A==",null,1,3734]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7107","249","114","1019","%","4.97",64.113,"2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7107","1019","1290.0",1225.9,"2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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-11-29","2020-02-28","1019"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 15:18:16","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":["7107",1120,"SETTLED","A05-I207435","2020-02-04 15:18:15","2019-11-29","2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7435","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7435","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7435","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7435"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 15:18:16","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":[1120,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207083","2020-02-04 15:18:15",3678,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7083","DEPOSIT",null,"PAID","2020-02-04 15:18:15",0,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:18:16","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":["7083","INVOICE","7435","PAID","2020-02-04 15:18:15",3678,"2","2020-02-04 15:18:15","2","2020-02-04 15:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:46:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1130,"customer_code":"C181130","identity_type":"PERSONAL","identity_id":"Z070788(1)","title":"Ms","lastname":"Lau","firstname":"Li Sze Cecilia","companyname":"","email":null,"tel":"96688344","address":"Room 3202, 32\/F, Pik Ngan House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"730.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-02","renew_room_key":"0012474143","renew_remark":"3 months contract.Storage rental paid by PayMe on November 7, 2019. Storage deposit $1536 transferred from agreement A05-CT195918 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196310, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"227","order_discount":[],"order_room":[{"room_id":"1715","room_code":"A05-189","retail_price":"768.0","discounted_price":"768.00","location_id":"4"}],"roughly_size":"10","total_retail_price":768,"total_discounted_price":730,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2190,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-02","rent_from":"2020-01-02","rent_to":"2020-04-01","delivery_service":"0","remark":"3 months contract.Storage rental paid by PayMe on February 4, 2020. Storage deposit $1536 transferred from agreement A05-CT196310 to this agreement. $33 handling charge for PayMe. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"OTHER","paymethod_other2":"PayMe","discount_deduct":0,"order_total":2190,"final_order_total":2190,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012474143","order_product":[],"pass":true}},"first_order_id":"5553","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-189 <\/td>\r\n\t\t\t\t\t 5X2X7 <\/td>\r\n\t\t\t\t\t $768.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":"10","total_discounted_price":"730.0","deposit":"0","total_retail_price":"768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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",1130,"NEW","A05-CT207108",768,730,0,0,"3","3",2190,2190,2190,"2020-02-04 15:47:00","0",null,null,null,"2020-01-02","2020-04-01","3 months contract.Storage rental paid by PayMe on February 4, 2020. Storage deposit $1536 transferred from agreement A05-CT196310 to this agreement. $33 handling charge for PayMe. \r\n","2020-01-02","10",0,null,0,"0","2","2020-02-04 15:46:59","2","2020-02-04 15:46:59","NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe",null,0,"0012474143","C181130","PERSONAL","Ms","Q7dddLoh0EPGaZDKbwv\/jg==","oe4emdjBwqJ3qUpOcI17hw==","","\/QfijdScWhkQWfsmkPMljZ9P+5UUKT0THdSHVa9QeuyLTiEQOKp04v8JakW3KcvglDwzO3ygDTfk48CK+LAID5xp3SASfODgqkpIuHxLDoM=","wKSrUc0OEnw6GepIGxdVoA==",null,"Y5uwS77UN+eKOlIguG0Geg==",null,1,"5553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7108","1715","768.0","768.00","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-02","2020-04-01","1715"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 15:47:00","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":["7108",1130,"SETTLED","A05-I207436","2020-02-04 15:46:59","2020-01-02","2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7436","RENT","\u9810\u7e73\u79df\u91d1",1,730,"MO","1",730,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7436","RENT","\u9810\u7e73\u79df\u91d1",2,730,"MO","1",730,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7436","RENT","\u9810\u7e73\u79df\u91d1",3,730,"MO","1",730,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2190,0,"7436"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 15:47:00","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":[1130,"NO_NEED_PAID_RENEW","","","","OTHER","","","PayMe","PAID","P207084","2020-02-04 15:46:59",2190,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7084","DEPOSIT",null,"PAID","2020-02-04 15:46:59",0,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 15:47:00","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":["7084","INVOICE","7436","PAID","2020-02-04 15:46:59",2190,"2","2020-02-04 15:46:59","2","2020-02-04 15:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 16:05:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 16:12:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 16:27:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:01:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:42","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":"","floor_plan_rent_room":[{"room_id":"1088","master_room_id":"110","room_code":"A05-086"}],"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> A05-086 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M427706(1)","title":"Mr","lastname":"CHESTER","firstname":"Andrew","companyname":"","email":"pesterchestor@hotmail.com","tel":"90942135","address":"BishopLei International, 4 Robinson Road, Mid-Level, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1088","room_code":"A05-086","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2020-03-03","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by Visa on February 4, 2020. Smartcard and padlock provided on February 4, 2020. \r\n$54 Visa additional fee.","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012462724","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:43","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":["C201503","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","BT4zDXNaxIuFMxsBZh9eFw==","","0WZ1OLwKgm6LsW4Cii\/cPg==","VF5nqgbgWsnjRzNN8wKg+LC3+J1g64a3n+\/rh0Eu+Kk=","o3omKroPlI3S4mwPuKGWRtI1LxiSqi7Bj6U1bq5vV4gng3SWdbWBN8eTOBvMCnT+VIr46pMlTrVRWylgO3130Q==","iHLkhzrqTwdz65g+nqADVg==",null,"VF5nqgbgWsnjRzNN8wKg+LC3+J1g64a3n+\/rh0Eu+Kk=","rviBZakY9PbfyojA0iaGRQ==","2","2020-02-04 18:16:42","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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","4",1503,"NEW","A05-CT207109",598,598,1196,0,"1","1",1794,1794,1794,"2020-02-04 18:16:44","0",null,null,null,"2020-02-04","2020-03-03","1 month contract. Storage rental and deposit paid by Visa on February 4, 2020. Smartcard and padlock provided on February 4, 2020. \r\n$54 Visa additional fee.","2020-02-04","8",0,null,0,"0","2","2020-02-04 18:16:42","2","2020-02-04 18:16:42","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"0012462724","C201503","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","BT4zDXNaxIuFMxsBZh9eFw==","","o3omKroPlI3S4mwPuKGWRtI1LxiSqi7Bj6U1bq5vV4gng3SWdbWBN8eTOBvMCnT+VIr46pMlTrVRWylgO3130Q==","0WZ1OLwKgm6LsW4Cii\/cPg==","VF5nqgbgWsnjRzNN8wKg+LC3+J1g64a3n+\/rh0Eu+Kk=","iHLkhzrqTwdz65g+nqADVg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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":["7109","1088","598.0","598.00","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-04","2020-03-03","1088"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-04 18:16:44","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":["7109","A05-D205278","PAID",1196,0,"2020-03-03","2020-02-04 18:16:42","2020-02-04 18:16:42","2","2020-02-04 18:16:42","2","2020-02-04 18:16:42",1503]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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":["7109",1503,"SETTLED","A05-I207437","2020-02-04 18:16:42","2020-02-04","2","2020-02-04 18:16:42","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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":["7437","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-04 18:16:42","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7437"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-04 18:16:44","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":[1503,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P207085","2020-02-04 18:16:42",1794,"2","2020-02-04 18:16:42","2","2020-02-04 18:16:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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":["7085","DEPOSIT","5278","PAID","2020-02-04 18:16:42",1196,"2","2020-02-04 18:16:42","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-04 18:16:44","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":["7085","INVOICE","7437","PAID","2020-02-04 18:16:42",598,"2","2020-02-04 18:16:42","2","2020-02-04 18:16:42"]},"data_before":[],"data_after":[],"step":1} *****