{"created_at":"2020-06-06 10:38:34","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1232,"customer_code":"C191232","identity_type":"PERSONAL","identity_id":"Z016602(3)","title":"Mr","lastname":"SO","firstname":"Kam Chung Kelvin","companyname":"","email":"Gp05@hotmail.com","tel":"67319572","address":"13C, 1 Baremar Terrace, Quarry Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-14","renew_room_key":"'0012465595","renew_remark":"12 months contract. Special offer 2 months off and 5% off. Storage rental and deposit paid by EPS on March 26, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194651, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2224.0","renew_master_room_id":"140","order_discount":[{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1275","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1275","room_code":"B01-085","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":868,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2021-06-13","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on June 6, 2020. Storage deposit $2224 transferred from agreement B01-CT194651 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":10416,"final_order_total":10416,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012465595","order_product":[],"pass":true}},"first_order_id":4651,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
B01-085 <\/td>\r\n\t\t\t\t\t	4X4X7 <\/td>\r\n\t\t\t\t\t	$1112.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"868.0","deposit":"0","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1232,"NEW","B01-CT208061",1112,868,0,0,"12","12",10416,10416,10416,"2020-06-06 10:38:34","0",null,null,null,"2020-06-14","2021-06-13","12 months contract. Storage rental paid by cheque on June 6, 2020. Storage deposit $2224 transferred from agreement B01-CT194651 to this agreement. ","2020-06-14","16",0,null,0,"0","2","2020-06-06 10:38:34","2","2020-06-06 10:38:34","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"'0012465595","C191232","PERSONAL","Mr","fJvJg5nLxJMC2nhumT5+uuctnXnCTA2fPfktSfyxq20=","mOWsGT2TzOPDdjq14yV0zw==","","GKG6lTcmsanz5REMtLn42Z2EM8YtSMCsN1WTCHb3UGxaIJN\/x\/tkls1ejor4MiVB","eTQeNQhu1IXcqLWmWFAH5Q==","0k53tWFL\/MC0GOPmHTJFr+VxL7P05tmAuMzsPlQIn+Q=","Y9Y8fxfA7yvrJOCM4D4dSw==",null,1,4651]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8061","341","140","1275","%","34.90",388.088,"2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8061","1275","1112.0",723.9,"2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2021-06-13","1275"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 10:38:34","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":["8061",1232,"SETTLED","B01-I208390","2020-06-06 10:38:34","2020-06-14","2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",1,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",2,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8390","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10416,0,"8390"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 10:38:34","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":[1232,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208033","2020-06-06 10:38:34",10416,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8033","DEPOSIT",null,"PAID","2020-06-06 10:38:34",0,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:38:34","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":["8033","INVOICE","8390","PAID","2020-06-06 10:38:34",10416,"2","2020-06-06 10:38:34","2","2020-06-06 10:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:40:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:40:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 10:59:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":881,"customer_code":"C180881","identity_type":"PERSONAL","identity_id":"K531352(A)","title":"Ms","lastname":"CHOY","firstname":"EUPHEMIA","companyname":"","email":"euphem@yahoo.com","tel":"92022175","address":"27\/F, Flat D, Block 16, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"814.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-27","renew_room_key":"0005921000","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 29, 2020. Storage deposit transferred from agreement A05-CT207613 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207742, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1034","room_code":"A05-032","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":814,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":814,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-06-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A05-CT207742 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":814,"final_order_total":814,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005921000","order_product":[],"pass":true}},"first_order_id":"4882","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-032 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.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":"9","total_discounted_price":"814.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",881,"NEW","A05-CT208062",1006,814,0,0,"1","1",814,814,814,"2020-06-06 11:27:04","0",null,null,null,"2020-05-27","2020-06-26","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A05-CT207742 to this agreement.\r\n","2020-05-27","9",0,null,0,"0","2","2020-06-06 11:27:04","2","2020-06-06 11:27:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005921000","C180881","PERSONAL","Ms","cgxXGJI\/ZTnh+WLA7hfGwg==","KHX1V\/o61A5lYN2Th2Ak\/Q==","","U8wra+WSnJl5LR7S5iiWZnnh338ln2lsz3xMjaQzmzZP4BCRoLcPkHMf26rmrqVZKqHoyISkO4JAVUv4wniBZg==","JgGxc0OPptFMBUC8eZGB8A==","cCZv0x8iMqg8yBlgEfmg12iFWmQM8Gc1m7ERyq86bXs=","uZ7Ygw5sLpeeqN2M2YKoJA==",null,1,"4882"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8062","1034","1006.0","1006.00","2","2020-06-06 11:27:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-27","2020-06-26","1034"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8062",881,"SETTLED","A05-I208391","2020-06-06 11:27:04","2020-05-27","2","2020-06-06 11:27:04","2","2020-06-06 11:27:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8391","RENT","\u9810\u7e73\u79df\u91d1",1,814,"MO","1",814,"2","2020-06-06 11:27:04","2","2020-06-06 11:27:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[814,0,"8391"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[881,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208034","2020-06-06 11:27:04",814,"2","2020-06-06 11:27:04","2","2020-06-06 11:27:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8034","DEPOSIT",null,"PAID","2020-06-06 11:27:04",0,"2","2020-06-06 11:27:04","2","2020-06-06 11:27:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:27:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8034","INVOICE","8391","PAID","2020-06-06 11:27:04",814,"2","2020-06-06 11:27:04","2","2020-06-06 11:27:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:50","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"2","renew_warehousing_date":"2020-05-06","renew_room_key":"054,00997","renew_remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207373 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207574, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"32","room_code":"A32","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"31","room_code":"A31","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2020-06-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207574 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4781","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A32 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A31 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2318.00","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",263,"NEW","A12-CT208063",2196,2318,0,0,"1","1",2318,2318,2318,"2020-06-06 11:41:51","0",null,null,null,"2020-05-06","2020-06-05","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207574 to this agreement.\r\n","2020-05-06","32",0,null,0,"0","2","2020-06-06 11:41:50","2","2020-06-06 11:41:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4781"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8063","32","1098.0","1098.00","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-06-05","32"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8063","31","1098.0","1098.00","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-06-05","31"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8063",263,"SETTLED","A12-I208392","2020-06-06 11:41:50","2020-05-06","2","2020-06-06 11:41:50","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8392","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-06-06 11:41:50","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"8392"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208035","2020-06-06 11:41:50",2318,"2","2020-06-06 11:41:50","2","2020-06-06 11:41:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8035","DEPOSIT",null,"PAID","2020-06-06 11:41:50",0,"2","2020-06-06 11:41:50","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8035","INVOICE","8392","PAID","2020-06-06 11:41:50",2318,"2","2020-06-06 11:41:50","2","2020-06-06 11:41:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:34","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1220,"customer_code":"C191220","identity_type":"PERSONAL","identity_id":"R119900(4)","title":"Mr","lastname":"LEUNG","firstname":"Wai Hung","companyname":"","email":null,"tel":"59386116","address":"\u65b0\u754c\u5c6f\u9580\u5927\u8208\u82b1\u57121\u671f2\u5ea79\u6a13G\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"2","renew_warehousing_date":"2020-05-06","renew_room_key":"054,00997","renew_remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207374 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207575, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"149","room_code":"C25","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-06","rent_from":"2020-05-06","rent_to":"2020-06-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207575 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4572","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> C25 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1228.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","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",1220,"NEW","A12-CT208064",1098,1228,0,0,"1","1",1228,1228,1228,"2020-06-06 11:49:35","0",null,null,null,"2020-05-06","2020-06-05","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A12-CT207575 to this agreement.\r\n","2020-05-06","16",0,null,0,"0","2","2020-06-06 11:49:34","2","2020-06-06 11:49:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C191220","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","yXKc2lCF323ApRADrjNaSg==","","kB3ZkLOEsqrfGlmYGehYoS1RHUa4+htDrEhnq1OyQOZf8ydcmD1ve7Z29T4bDE82","UuUIwTJb9gH2x8g8+PEtTA==",null,"dhuboonMisA+jeGDyP70SA==",null,1,"4572"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","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":["8064","149","1098.0","1098.00","2","2020-06-06 11:49:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-06","2020-06-05","149"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 11:49:35","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":["8064",1220,"SETTLED","A12-I208393","2020-06-06 11:49:34","2020-05-06","2","2020-06-06 11:49:34","2","2020-06-06 11:49:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","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":["8393","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-06-06 11:49:34","2","2020-06-06 11:49:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"8393"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 11:49:35","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":[1220,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208036","2020-06-06 11:49:34",1228,"2","2020-06-06 11:49:34","2","2020-06-06 11:49:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","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":["8036","DEPOSIT",null,"PAID","2020-06-06 11:49:34",0,"2","2020-06-06 11:49:34","2","2020-06-06 11:49:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 11:49:35","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":["8036","INVOICE","8393","PAID","2020-06-06 11:49:34",1228,"2","2020-06-06 11:49:34","2","2020-06-06 11:49:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17: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":"filter1=2&filter2=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1172","master_room_id":"117","room_code":"A05-170"}],"_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-170 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G582181(8)","title":"Ms","lastname":"TAM","firstname":"Lai Wan","companyname":"","email":"wendy.tam2007@gmail.com","tel":"98762997","address":"Flat C, 14\/F, Blk 18, Chi Fu Fa Yuen, Pokfulam, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1172","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1172","room_code":"A05-170","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1535,"deposit":3070,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5374,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2301.00","warehousing_date":"2020-06-22","rent_from":"2020-06-22","rent_to":"2020-09-21","delivery_service":"0","remark":"3 months contact. Spacial offer first 3 months 50% off. Storage rental and deposit paid by Cheque on June 6, 2020. Smartcard and padlock provided on June 6, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2301,"order_total":7675,"final_order_total":5374,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012488465","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1535.00","deposit":"3070.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:16","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":["C201609","PERSONAL","Ms","9\/jLrb\/MMpMkHpLdRpj37g==","+j7vCaw\/WO5pkzxDeuw+5w==","","wppwN386GvkXsIaI5l+gAw==","RBO24wKjgw+7igoxn1EScAgALC+NRY74PzPCmYJdq+g=","aAbcMlljyKkkYL9O\/COoHSKJSqqRxzoHBwP88ZhTseK0AyErRRN9mo3h3npDr0QDkmTbCcmeASNKm4vBGFLgSg==","8MeCNwz6dlyu48e+fLtVTA==",null,"RBO24wKjgw+7igoxn1EScAgALC+NRY74PzPCmYJdq+g=","vfPvY3yTUz268Yyqo6Y7UQ==","2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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",1609,"NEW","A05-CT208065",1857,1535,3070,0,"3","3",5374,7675,5374,"2020-06-06 12:17:17","0",null,null,null,"2020-06-22","2020-09-21","3 months contact. Spacial offer first 3 months 50% off. Storage rental and deposit paid by Cheque on June 6, 2020. Smartcard and padlock provided on June 6, 2020. ","2020-06-22","24",0,null,2301,"2301.00","2","2020-06-06 12:17:15","2","2020-06-06 12:17:15","CHEQUE","","","","CHEQUE","","","",null,0,"'0012488465","C201609","PERSONAL","Ms","9\/jLrb\/MMpMkHpLdRpj37g==","+j7vCaw\/WO5pkzxDeuw+5w==","","aAbcMlljyKkkYL9O\/COoHSKJSqqRxzoHBwP88ZhTseK0AyErRRN9mo3h3npDr0QDkmTbCcmeASNKm4vBGFLgSg==","wppwN386GvkXsIaI5l+gAw==","RBO24wKjgw+7igoxn1EScAgALC+NRY74PzPCmYJdq+g=","8MeCNwz6dlyu48e+fLtVTA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8065","257","117","1172","%","5.00",92.85,"2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8065","1172","1857.0",1764.2,"2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-22","2020-09-21","1172"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 12:17:17","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":["8065","A05-D205454","PAID",3070,0,"2020-09-21","2020-06-06 12:17:15","2020-06-06 12:17:15","2","2020-06-06 12:17:15","2","2020-06-06 12:17:15",1609]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8065",1609,"SETTLED","A05-I208394","2020-06-06 12:17:15","2020-06-22","2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8394","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8394","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,769,"MO","1",769,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8394","RENT","\u9810\u7e73\u79df\u91d1",3,1535,"MO","1",1535,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2304,0,"8394"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 12:17:17","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":[1609,"CHEQUE","","","","CHEQUE","","","","PAID","P208037","2020-06-06 12:17:15",5374,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8037","DEPOSIT","5454","PAID","2020-06-06 12:17:15",3070,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 12:17:17","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":["8037","INVOICE","8394","PAID","2020-06-06 12:17:15",2304,"2","2020-06-06 12:17:15","2","2020-06-06 12:17:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:22","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"2","renew_warehousing_date":"2020-05-08","renew_room_key":"054,00997","renew_remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207376 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207577, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"736","room_code":"O12","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-06-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207577 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4784","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> O12 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",263,"NEW","A14-CT208066",998,998,0,0,"1","1",998,998,998,"2020-06-06 13:16:23","0",null,null,null,"2020-05-08","2020-06-07","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207577 to this agreement. \r\n","2020-05-08","12",0,null,0,"0","2","2020-06-06 13:16:22","2","2020-06-06 13:16:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4784"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","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":["8066","736","998.0","998.00","2","2020-06-06 13:16:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-08","2020-06-07","736"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 13:16:23","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":["8066",263,"SETTLED","A14-I208395","2020-06-06 13:16:22","2020-05-08","2","2020-06-06 13:16:22","2","2020-06-06 13:16:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","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":["8395","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-06 13:16:22","2","2020-06-06 13:16:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8395"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 13:16:23","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208038","2020-06-06 13:16:22",998,"2","2020-06-06 13:16:22","2","2020-06-06 13:16:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","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":["8038","DEPOSIT",null,"PAID","2020-06-06 13:16:22",0,"2","2020-06-06 13:16:22","2","2020-06-06 13:16:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:16:23","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":["8038","INVOICE","8395","PAID","2020-06-06 13:16:22",998,"2","2020-06-06 13:16:22","2","2020-06-06 13:16:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:52","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1172","master_room_id":"117","room_code":"A05-170"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"2","renew_warehousing_date":"2020-05-04","renew_room_key":"054,00997","renew_remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207375 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207576, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"688","room_code":"N05","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2020-06-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207576 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4783","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> N05 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",263,"NEW","A14-CT208067",598,598,0,0,"1","1",598,598,598,"2020-06-06 13:19:53","0",null,null,null,"2020-05-04","2020-06-03","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A14-CT207576 to this agreement.\r\n","2020-05-04","12",0,null,0,"0","2","2020-06-06 13:19:52","2","2020-06-06 13:19:52","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4783"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","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":["8067","688","598.0","598.00","2","2020-06-06 13:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2020-06-03","688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 13:19:53","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":["8067",263,"SETTLED","A14-I208396","2020-06-06 13:19:52","2020-05-04","2","2020-06-06 13:19:52","2","2020-06-06 13:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","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":["8396","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-06 13:19:52","2","2020-06-06 13:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8396"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 13:19:53","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208039","2020-06-06 13:19:52",598,"2","2020-06-06 13:19:52","2","2020-06-06 13:19:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","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":["8039","DEPOSIT",null,"PAID","2020-06-06 13:19:52",0,"2","2020-06-06 13:19:52","2","2020-06-06 13:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:19:53","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":["8039","INVOICE","8396","PAID","2020-06-06 13:19:52",598,"2","2020-06-06 13:19:52","2","2020-06-06 13:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 13:43:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:06:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:29","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1134","master_room_id":"114","room_code":"A05-132"}],"_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-132 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K373726(8)","title":"Mr","lastname":"TANG","firstname":" Tsz Tung","companyname":"","email":"ptttang@gmail.com","tel":"94193308","address":"18F, Fung House, 19-20 Connaught Road C., H.K.","pass":true,"customer_first_order":true},"2":{"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":"1134","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1134","room_code":"A05-132","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3633,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-06-07","rent_from":"2020-06-07","rent_to":"2020-09-06","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on June , 2020. Smart card and padlock provided on June 6, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1557,"order_total":5250,"final_order_total":3693,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012478493","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["C201610","PERSONAL","Mr","FMA55hFdrlTZRmTF9+1nXQ==","20knVHhKlM9kB5wugwP3yQ==","","u5wdGnuBiKZL4fQQTT3Nhw==","8k0Xdg+h1Tz0wXhWH3U5SJTjEkW2EMd\/wYFxWQrp8xI=","exoD5Q3MDywQa5SQ0At+TqbSpQwhR1IaPqvia\/\/zBCycupCvFNKK1JHJsam317uH","F97uxk03nRIJ3JLnayccdQ==",null,"8k0Xdg+h1Tz0wXhWH3U5SJTjEkW2EMd\/wYFxWQrp8xI=","bta+gIi15gEUYg\/a8lX0sQ==","2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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",1610,"NEW","A05-CT208068",1290,1038,2076,0,"3","3",3633,5250,3693,"2020-06-06 14:31:31","0",null,null,null,"2020-06-07","2020-09-06","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on June , 2020. Smart card and padlock provided on June 6, 2020. ","2020-06-07","16",0,null,1557,"1557.00","2","2020-06-06 14:31:29","2","2020-06-06 14:31:29","EPS","","","","EPS","","","",null,0,"'0012478493","C201610","PERSONAL","Mr","FMA55hFdrlTZRmTF9+1nXQ==","20knVHhKlM9kB5wugwP3yQ==","","exoD5Q3MDywQa5SQ0At+TqbSpQwhR1IaPqvia\/\/zBCycupCvFNKK1JHJsam317uH","u5wdGnuBiKZL4fQQTT3Nhw==","8k0Xdg+h1Tz0wXhWH3U5SJTjEkW2EMd\/wYFxWQrp8xI=","F97uxk03nRIJ3JLnayccdQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8068","249","114","1134","%","4.97",64.113,"2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8068",1610,"11","1","60.0",60,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8068"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-06 14:31:31","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":["8068","1134","1290.0",1225.9,"2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-07","2020-09-06","1134"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 14:31:31","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":["8068","A05-D205455","PAID",2076,0,"2020-09-06","2020-06-06 14:31:29","2020-06-06 14:31:29","2","2020-06-06 14:31:29","2","2020-06-06 14:31:29",1610]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8068",1610,"SETTLED","A05-I208397","2020-06-06 14:31:29","2020-06-07","2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8397","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8397","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8397","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8397","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1617,0,"8397"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 14:31:31","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":[1610,"EPS","","","","EPS","","","","PAID","P208040","2020-06-06 14:31:29",3693,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8040","DEPOSIT","5455","PAID","2020-06-06 14:31:29",2076,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:31:31","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":["8040","INVOICE","8397","PAID","2020-06-06 14:31:29",1617,"2","2020-06-06 14:31:29","2","2020-06-06 14:31:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 14:34:34","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0012478493, 0012398715","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on June , 2020. Smart card and padlock provided on June 6, 2020. ","2020-06-06 14:34:34","2","20knVHhKlM9kB5wugwP3yQ==","FMA55hFdrlTZRmTF9+1nXQ==","8k0Xdg+h1Tz0wXhWH3U5SJTjEkW2EMd\/wYFxWQrp8xI=","u5wdGnuBiKZL4fQQTT3Nhw==","exoD5Q3MDywQa5SQ0At+TqbSpQwhR1IaPqvia\/\/zBCycupCvFNKK1JHJsam317uH",8068]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1134","master_room_id":"114","room_code":"A05-132"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1238,"customer_code":"C191238","identity_type":"BUSINESS","identity_id":"CR#869699","title":"Mr","lastname":"CHUNG","firstname":"Ka Hung Mike","companyname":"Talent Hues Management Limited","email":"mchungkh@netvigator.com","tel":"91418888","address":"Flat C, 5\/F, Block 19, Baguio Villa, 555 Victoria Road, Pofulam, H.K.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-25","renew_room_key":"0005951161, 0006005395","renew_remark":"6 months contract. Storage rental paid by cheque on December 27, 2019. Storage deposit $3714 transferred from agreement A05-CT194819 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196790, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1173","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1173","room_code":"A05-171","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1764,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5292,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-25","rent_from":"2020-04-25","rent_to":"2020-07-24","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque on June 6, 2020. Storage deposit $3714 transferred from agreement A05-CT196790 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5292,"final_order_total":5292,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005951161, 0006005395","order_product":[],"pass":true}},"first_order_id":"4819","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-171 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"24","total_discounted_price":"1764.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1238,"NEW","A05-CT208069",1857,1764,0,0,"3","3",5292,5292,5292,"2020-06-06 15:22:24","0",null,null,null,"2020-04-25","2020-07-24","3 months contract. Storage rental paid by cheque on June 6, 2020. Storage deposit $3714 transferred from agreement A05-CT196790 to this agreement.\r\n","2020-04-25","24",0,null,0,"0","2","2020-06-06 15:22:23","2","2020-06-06 15:22:23","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005951161, 0006005395","C191238","BUSINESS","Mr","LDd+YpLwC09g0O05qBNHow==","7t8bqgcU0SGVnDs8IIr2pQ==","Talent Hues Management Limited","wPhdA\/XS00zJNwlbX9dqA6RLVIooO6aB5r2BGCPTa4yhiAljyHOceLUGC6C8fI6lm4+0hA6DczBgrwVBvwvaZ2HTUHA2Qf\/H5bnxnn7vouo=","yyRfyQXdQ2mo5Fg4V\/\/bHg==","uEqMnrg4z0d3f35bnlWw7bL1NIrYXXfHlvY7fhOdv90=",null,"IJZGX3uEfBFD5HF8Iviu\/A==",1,"4819"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8069","257","117","1173","%","5.00",92.85,"2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8069","1173","1857.0",1764.2,"2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-25","2020-07-24","1173"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8069",1238,"SETTLED","A05-I208398","2020-06-06 15:22:23","2020-04-25","2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8398","RENT","\u9810\u7e73\u79df\u91d1",1,1764,"MO","1",1764,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8398","RENT","\u9810\u7e73\u79df\u91d1",2,1764,"MO","1",1764,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8398","RENT","\u9810\u7e73\u79df\u91d1",3,1764,"MO","1",1764,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5292,0,"8398"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1238,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208041","2020-06-06 15:22:23",5292,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8041","DEPOSIT",null,"PAID","2020-06-06 15:22:23",0,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 15:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8041","INVOICE","8398","PAID","2020-06-06 15:22:23",5292,"2","2020-06-06 15:22:23","2","2020-06-06 15:22:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:32:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16: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","floor_plan_rent_room":[{"room_id":"1313","master_room_id":"164","room_code":"C15-007"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-007 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D616901(6)","title":"Ms","lastname":"MAN","firstname":"Wing Yin Cornelia","companyname":"","email":"Cornelia.man@gmail.com","tel":"90318315","address":"Room A3, 6\/F, Fortune Terrace, 4 Tak Shing Street, Jordan, Kowloon","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1313","room_code":"C15-007","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":773,"deposit":780,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6812,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3244.00","warehousing_date":"2020-06-10","rent_from":"2020-06-10","rent_to":"2021-06-09","delivery_service":"0","remark":"12 months contract. Special offer 50% off for the first 3 months and the 11th & 12th months free for the first contract. Storage rental and deposit paid by bank transfer on June 05,2020. Smart card and padlock paid on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3244,"order_total":10236,"final_order_total":6992,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012522650","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"2","price":"60.0"},{"product_id":"12","product_name":"\u5009\u9396\u5319","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"10","total_discounted_price":"773.00","deposit":"780.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:00","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":["C201611","PERSONAL","Ms","hyN5\/h7JzFo++OquXZzInSASxbDCbJ\/SZO9VOLcd8pQ=","BfbwRFgXcXfr1bciP\/Bldg==","","NYLur5T\/CFerDStJz2L3pg==","Eki+iigq3c9VG5CQCQZveTGUIr6nmS+92nDwmmOxpY8=","SdKDHVV80KEKdMraxsG12aBFsdLVTpUihFJYoCcZ5XqOWg6fDAtO6pZINnapCEdRPkXiiHFep1AMP2DL0rL9RZTCryRzQRX094UzieyxZK0=","mnKI8ylsDBjKjrIxm+ku5w==",null,"Eki+iigq3c9VG5CQCQZveTGUIr6nmS+92nDwmmOxpY8=","bZer5zdtTx+VWtf982upMQ==","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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` = ?","parameters":["1","3","6",1611,"NEW","C15-CT208070",773,773,780,0,"12","12",6812,10236,6992,"2020-06-06 16:47:01","0",null,null,null,"2020-06-10","2021-06-09","12 months contract. Special offer 50% off for the first 3 months and the 11th & 12th months free for the first contract. Storage rental and deposit paid by bank transfer on June 05,2020. Smart card and padlock paid on the same day.","2020-06-10","10",0,null,3244,"3244.00","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59","BANKIN","","","","BANKIN","","","",null,0,"'0012522650","C201611","PERSONAL","Ms","hyN5\/h7JzFo++OquXZzInSASxbDCbJ\/SZO9VOLcd8pQ=","BfbwRFgXcXfr1bciP\/Bldg==","","SdKDHVV80KEKdMraxsG12aBFsdLVTpUihFJYoCcZ5XqOWg6fDAtO6pZINnapCEdRPkXiiHFep1AMP2DL0rL9RZTCryRzQRX094UzieyxZK0=","NYLur5T\/CFerDStJz2L3pg==","Eki+iigq3c9VG5CQCQZveTGUIr6nmS+92nDwmmOxpY8=","mnKI8ylsDBjKjrIxm+ku5w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8070",1611,"11","2","60.0",120,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8070",1611,"12","1","60.0",60,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[180,"8070"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-06 16:47: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":["8070","1313","773.0","773.00","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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-06-10","2021-06-09","1313"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-06 16:47:01","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":["8070","C15-D205456","PAID",780,0,"2021-06-09","2020-06-06 16:46:59","2020-06-06 16:46:59","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59",1611]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8070",1611,"SETTLED","C15-I208399","2020-06-06 16:46:59","2020-06-10","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,621,"MO","1",621,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",6,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",7,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",8,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",9,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",10,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",11,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8399","RENT","\u9810\u7e73\u79df\u91d1",12,773,"MO","1",773,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8399","ORDER_PRODUCT","60.0","PCS","2",120,"11","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8399","ORDER_PRODUCT","60.0","PCS","1",60,"12","2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6212,0,"8399"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-06 16:47: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":[1611,"BANKIN","","","","BANKIN","","","","PAID","P208042","2020-06-06 16:46:59",6992,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8042","DEPOSIT","5456","PAID","2020-06-06 16:46:59",780,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-06 16:47: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":["8042","INVOICE","8399","PAID","2020-06-06 16:46:59",6212,"2","2020-06-06 16:46:59","2","2020-06-06 16:46:59"]},"data_before":[],"data_after":[],"step":1} *****