{"created_at":"2020-05-11 10:06:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 10:22:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 10:22:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 11:03:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 11:37:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:02:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:47","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":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":353,"customer_code":"C170353","identity_type":"PERSONAL","identity_id":"E711771(3)","title":"Mrs","lastname":"Chan","firstname":"Lai Fan Josephine","companyname":"","email":"lfchan02@yahoo.com.hk","tel":"92512613","address":"Flat A, 11\/F,Block 10, Provident Centre,Wharf Road,North Point","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-13","renew_room_key":"055,39931","renew_remark":"12 months contract. Storage rental paid by cheque on April 11, 2019. Storage deposit transferred from agreement A14-CT183232 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194737, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"601","room_code":"M12","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-13","rent_from":"2020-05-13","rent_to":"2021-05-12","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A14-CT194737 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,39931","order_product":[],"pass":true}},"first_order_id":4737,"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>
M12 <\/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":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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",353,"NEW","A14-CT207811",598,538,0,0,"12","12",6456,6456,6456,"2020-05-11 12:17:48","0",null,null,null,"2020-05-13","2021-05-12","12 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A14-CT194737 to this agreement.","2020-05-13","12",0,null,0,"0","2","2020-05-11 12:17:47","2","2020-05-11 12:17:47","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,39931","C170353","PERSONAL","Mrs","ArDhWk0MpI6H05TlSdSY4Bp16ne7yBFEbNY\/ZPI6zKo=","U9yoE9KqV1v8YlRkf7Q2yg==","","qzNWsHuHm09BWQ9jJW7TpqOrTLbQqeJBbgG0SQGK+ZQ+mgHeT4EyPUBbTAkMfSx+LF466ittIO\/YB1xLUm+xzw==","2fAAs3EEPHHgJKf8bKrrCg==","y4maMiWjxXLGw+itRL6LV3kfXKb3SIG7cScXf6ggwho=","4TRe+zEQ2RFDsQPfmwxy7w==",null,1,4737]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["7811","601","598.0","598.00","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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-13","2021-05-12","601"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 12:17:48","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":["7811",353,"SETTLED","A14-I208140","2020-05-11 12:17:47","2020-05-13","2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["8140","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"8140"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 12:17:48","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":[353,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207785","2020-05-11 12:17:47",6456,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["7785","DEPOSIT",null,"PAID","2020-05-11 12:17:47",0,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:17:48","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":["7785","INVOICE","8140","PAID","2020-05-11 12:17:47",6456,"2","2020-05-11 12:17:47","2","2020-05-11 12:17:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":441,"customer_code":"C170441","identity_type":"PERSONAL","identity_id":"K187210(9)","title":"Mr","lastname":"Leung","firstname":"Kwong Chi","companyname":"","email":"kckelvin@gmail.com","tel":"94625268","address":"Flat 3113,Pik Yuet House,Shek Pai Wan Estate","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-17","renew_room_key":"053,48941","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT207288 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207529, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"101","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"101","room_code":"B49","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-11-16","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT207529 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,48941","order_product":[],"pass":true}},"first_order_id":"4848","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> B49 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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",441,"NEW","A12-CT207812",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-11 12:27:54","0",null,null,null,"2020-05-17","2020-11-16","6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT207529 to this agreement.\r\n","2020-05-17","20",0,null,0,"0","2","2020-05-11 12:27:54","2","2020-05-11 12:27:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,48941","C170441","PERSONAL","Mr","+dEjQsGfUIM77pS0ke1UNg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","WXAxv4MtPIFgHWZXkMsPE5BEGcBZNXBFpYp6GbukVe41gB3Im3As7f4Wn1yvLqKB","3XEnDPIYj\/Bc8Nw\/mL4YlA==","HqPua0wMa9D6F9q3F52tnLhm3HWWBu1s1N0CWtgara4=","n8KZV65hrsIsZlgzHveC2A==",null,1,"4848"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["7812","76","10","101","%","9.95",152.036,"2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["7812","101","1528.0",1376,"2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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-17","2020-11-16","101"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 12:27:54","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":["7812",441,"SETTLED","A12-I208141","2020-05-11 12:27:54","2020-05-17","2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["8141","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8141"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 12:27:54","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":[441,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207786","2020-05-11 12:27:54",6834,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["7786","DEPOSIT",null,"PAID","2020-05-11 12:27:54",0,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:27:54","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":["7786","INVOICE","8141","PAID","2020-05-11 12:27:54",6834,"2","2020-05-11 12:27:54","2","2020-05-11 12:27:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 9, 2020. Storage deposit transferred from agreement A05-CT207322 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207596, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-14","rent_from":"2020-05-14","rent_to":"2020-06-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 9, 2020. Storage deposit transferred from agreement A05-CT207596 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","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-008 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1217,"NEW","A05-CT207813",1290,1290,0,0,"1","1",1290,1290,1290,"2020-05-11 12:32:31","0",null,null,null,"2020-05-14","2020-06-13","1 month contract. Storage rental paid by bank transfer on May 9, 2020. Storage deposit transferred from agreement A05-CT207596 to this agreement.\r\n","2020-05-14","16",0,null,0,"0","2","2020-05-11 12:32:31","2","2020-05-11 12:32:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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":["7813","1010","1290.0","1290.00","2","2020-05-11 12:32:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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-05-14","2020-06-13","1010"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 12:32: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":["7813",1217,"SETTLED","A05-I208142","2020-05-11 12:32:31","2020-05-14","2","2020-05-11 12:32:31","2","2020-05-11 12:32:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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":["8142","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-05-11 12:32:31","2","2020-05-11 12:32:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8142"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 12:32: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":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207787","2020-05-11 12:32:31",1290,"2","2020-05-11 12:32:31","2","2020-05-11 12:32:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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":["7787","DEPOSIT",null,"PAID","2020-05-11 12:32:31",0,"2","2020-05-11 12:32:31","2","2020-05-11 12:32:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:32: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":["7787","INVOICE","8142","PAID","2020-05-11 12:32:31",1290,"2","2020-05-11 12:32:31","2","2020-05-11 12:32:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 12:41:39","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","0005763963; '0005028703","12 month contract. Storage rental paid by PPS on 4 Oct 2019. Storage deposit $3036 transferred from agreement C15-CT183215 to this agreement.","2020-05-11 12:41:39","2","RAqogkelEKt1q5b\/6Neu\/g==","JIyMGPipnWhpmYnV5VCDKw==","u7DOgz6kpnw2uSTKMfdAng==","EOIkCtCxUNAUQHdi2UFtu7TOnz9Bh65lpb4I3J5KSiV5TjM3gv3e5xj602VdMaCguIyOlIYZitxGnQaMTkDU6A==",6095]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12: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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1219,"customer_code":"C191219","identity_type":"PERSONAL","identity_id":"P313406(0)","title":"Ms","lastname":"DEWAN","firstname":"Binita","companyname":"","email":"daya@netvigator.com","tel":"66825915","address":"Flat 43 C, Tower 1, Marina Habitat, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1654.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-10","renew_room_key":"66825915","renew_remark":"6 months contract. Storage rental and deposit paid by cheque on Nov 02,2019. Smartcard provided on Nov, 02.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196290, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3676.0","renew_master_room_id":"49","order_discount":[],"order_room":[{"room_id":"441","room_code":"J23","retail_price":"1838.0","discounted_price":"1838.00","location_id":"2"}],"roughly_size":"25","total_retail_price":1838,"total_discounted_price":1654,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":19848,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1654.00","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2021-06-09","delivery_service":"0","remark":"12 months contract. Special offer the 13th month free and 2 Renewal gifts. Storage rental paid by EPS on May 11, 2020. Storage deposit $3676 transferred from agreement A14-CT196290 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1654,"order_total":21502,"final_order_total":19848,"location_id":"2","branch_id":"1","company_id":"1","room_key":"66825915","order_product":[],"pass":true}},"first_order_id":6290,"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> J23 <\/td>\r\n\t\t\t\t\t 5X5X8 <\/td>\r\n\t\t\t\t\t $1838.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":"25","total_discounted_price":"1654.00","deposit":"0.00","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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",1219,"NEW","A14-CT207814",1838,1654,0,0,"13","13",19848,21502,19848,"2020-05-11 13:12:05","0",null,null,null,"2020-05-10","2021-06-09","12 months contract. Special offer the 13th month free and 2 Renewal gifts. Storage rental paid by EPS on May 11, 2020. Storage deposit $3676 transferred from agreement A14-CT196290 to this agreement. ","2020-05-10","25",0,null,1654,"1654.00","2","2020-05-11 13:12:04","2","2020-05-11 13:12:04","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"66825915","C191219","PERSONAL","Ms","crqpxFtvP1tp34HAZitPmQ==","zqoY9ngbDL96G+yvYCVKfQ==","","otTt+ZAJCCh+m3w6K7AnkfIdx8B58VmpWBJqFyVLu6B05LxpUrov\/iMrXscq8V\/xwZGfjl4k8C1yY\/hXFsl\/zA==","a6F7RZ9H9C5+6IFhnNkSmw==","vRI7FgyNt6f4VfgrbA2vjLNMb6p5kQuwSrGNfBiZYkc=","a473MsGJj2BktJIholbAUA==",null,1,6290]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["7814","441","1838.0","1838.00","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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-10","2021-06-09","441"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 13:12:05","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":["7814",1219,"SETTLED","A14-I208143","2020-05-11 13:12:04","2020-05-10","2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",3,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",4,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",5,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",6,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",7,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",8,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",9,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",10,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",11,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",12,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["8143","RENT","\u9810\u7e73\u79df\u91d1",13,1654,"MO","1",1654,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19848,0,"8143"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 13:12:05","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":[1219,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207788","2020-05-11 13:12:04",19848,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["7788","DEPOSIT",null,"PAID","2020-05-11 13:12:04",0,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:12:05","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":["7788","INVOICE","8143","PAID","2020-05-11 13:12:04",19848,"2","2020-05-11 13:12:04","2","2020-05-11 13:12:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 13:24:19","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","66825915, 076,34769","12 months contract. Special offer the 13th month free and 2 Renewal gifts. Storage rental paid by EPS on May 11, 2020. Storage deposit $3676 transferred from agreement A14-CT196290 to this agreement. ","2020-05-11 13:24:19","2","zqoY9ngbDL96G+yvYCVKfQ==","crqpxFtvP1tp34HAZitPmQ==","vRI7FgyNt6f4VfgrbA2vjLNMb6p5kQuwSrGNfBiZYkc=","a6F7RZ9H9C5+6IFhnNkSmw==","otTt+ZAJCCh+m3w6K7AnkfIdx8B58VmpWBJqFyVLu6B05LxpUrov\/iMrXscq8V\/xwZGfjl4k8C1yY\/hXFsl\/zA==",7814]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:21:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:36:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1440","master_room_id":"166","room_code":"C15-134"}],"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-134 <\/td>\r\n\t\t\t\t\t 4X3X3 <\/td>\r\n\t\t\t\t\t $566.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y453882(8)","title":"Mr","lastname":"NG","firstname":"Long Yee","companyname":"","email":"","tel":"63125766","address":"tbc","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1440","room_code":"C15-134","retail_price":"566.0","discounted_price":"566.00","location_id":"6"}],"roughly_size":"12","total_retail_price":566,"total_discounted_price":566,"deposit":566,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1642,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"56.00","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-07-07","delivery_service":"0","remark":"2 months contract. Special offer 5% discount. Storage rental and deposit paid by cash on May 11,2020. Smart card provided on the same day.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":56,"order_total":1698,"final_order_total":1642,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012453396","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"566.00","deposit":"566.00","total_retail_price":"566.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["C201579","PERSONAL","Mr","DB+5Bb9Dh7qGS15ZnnuSpQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","TQ2h8yUYZxs3A5xNGVsmAw==",null,"L\/L04tL1KwAXTf\/XIAPmWg==","oVwJ52WqrM8f8kOBwcByvg==",null,null,"Emajcac+QTga6Js4GdPPmw==","2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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",1579,"NEW","C15-CT207815",566,566,566,0,"2","2",1642,1698,1642,"2020-05-11 15:49:47","0",null,null,null,"2020-05-08","2020-07-07","2 months contract. Special offer 5% discount. Storage rental and deposit paid by cash on May 11,2020. Smart card provided on the same day.","2020-05-08","12",0,null,56,"56.00","2","2020-05-11 15:49:45","2","2020-05-11 15:49:45","CASH","","","","CASH","","","",null,0,"'0012453396","C201579","PERSONAL","Mr","DB+5Bb9Dh7qGS15ZnnuSpQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","L\/L04tL1KwAXTf\/XIAPmWg==","TQ2h8yUYZxs3A5xNGVsmAw==",null,"oVwJ52WqrM8f8kOBwcByvg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["7815","1440","566.0","566.00","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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-07-07","1440"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 15:49:47","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":["7815","C15-D205402","PAID",566,0,"2020-07-07","2020-05-11 15:49:45","2020-05-11 15:49:45","2","2020-05-11 15:49:45","2","2020-05-11 15:49:45",1579]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["7815",1579,"SETTLED","C15-I208144","2020-05-11 15:49:45","2020-05-08","2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["8144","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,510,"MO","1",510,"2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["8144","RENT","\u9810\u7e73\u79df\u91d1",2,566,"MO","1",566,"2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1076,0,"8144"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 15:49:47","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":[1579,"CASH","","","","CASH","","","","PAID","P207789","2020-05-11 15:49:45",1642,"2","2020-05-11 15:49:45","2","2020-05-11 15:49:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["7789","DEPOSIT","5402","PAID","2020-05-11 15:49:45",566,"2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 15:49:47","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":["7789","INVOICE","8144","PAID","2020-05-11 15:49:45",1076,"2","2020-05-11 15:49:45","2","2020-05-11 15:49:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:42:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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=437&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":10,"customer_code":"C150010","identity_type":"PERSONAL","identity_id":"D220717(7)","title":"Ms","lastname":"Chan","firstname":"Emily ","companyname":"","email":"eealeung@netvigator.com","tel":"93152268","address":"3D Repulse Bay Towers, 119A Repulse Bay Road","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3478.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-17","renew_room_key":"055,13955","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on April 13, 2019. Storage deposit transferred from agreement A12-CT183139 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194757, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"172","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"171","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"160","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"161","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"172","room_code":"C48","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"171","room_code":"C47","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"161","room_code":"C37","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"160","room_code":"C36","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3478,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":20868,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-11-16","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT194757 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":20868,"final_order_total":20868,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,13955","order_product":[],"pass":true}},"first_order_id":4757,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C48 <\/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> C47 <\/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> C37 <\/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> C36 <\/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":"64","total_discounted_price":"3478.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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","1","1",10,"NEW","A12-CT207816",4392,3478,0,0,"6","6",20868,20868,20868,"2020-05-11 16:47:34","0",null,null,null,"2020-05-17","2020-11-16","6 months contract. Storage rental paid by bank transfer on May 11, 2020. Storage deposit transferred from agreement A12-CT194757 to this agreement.","2020-05-17","64",0,null,0,"0","2","2020-05-11 16:47:34","2","2020-05-11 16:47:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,13955","C150010","PERSONAL","Ms","bXMLP3OnV0672U17jwhPdw==","U9yoE9KqV1v8YlRkf7Q2yg==","","00rEebM8orz\/+KdpvT7yNR0QxgAQdTRJTXgZc\/+ZpyYdStrWeBskleFqjgzjgAtr","GFveguBJK5a2rT25vDw5nQ==","qjpSwYidjKuHBGed5BXW3fI6PvZb9kUGR9Ihk3DD3C4=","68mGzdZhpLR4Gm\/gihWXAw==",null,1,4757]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7816","72","8","172","%","9.93",109.0314,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7816","72","8","171","%","9.93",109.0314,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7816","72","8","160","%","9.93",109.0314,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7816","72","8","161","%","9.93",109.0314,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7816","172","1098.0",989,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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-05-17","2020-11-16","172"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 16:47: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":["7816","171","1098.0",989,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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-05-17","2020-11-16","171"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 16:47: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":["7816","161","1098.0",989,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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-05-17","2020-11-16","161"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 16:47: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":["7816","160","1098.0",989,"2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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-05-17","2020-11-16","160"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 16:47: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":["7816",10,"SETTLED","A12-I208145","2020-05-11 16:47:34","2020-05-17","2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["8145","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20868,0,"8145"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 16:47: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":[10,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207790","2020-05-11 16:47:34",20868,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7790","DEPOSIT",null,"PAID","2020-05-11 16:47:34",0,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 16:47: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":["7790","INVOICE","8145","PAID","2020-05-11 16:47:34",20868,"2","2020-05-11 16:47:34","2","2020-05-11 16:47:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:32","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=437&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1044,"customer_code":"C181044","identity_type":"PERSONAL","identity_id":"D546942(3)","title":"Mr","lastname":"Tang","firstname":"Chi Hin","companyname":"","email":"ctang5@me.com","tel":"63402382","address":"Flat 2, 13\/F, Hoi Shan Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2191.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-11","renew_room_key":"0005763999","renew_remark":"6 months contract. Storage rental paid by PPS on November 11, 2019. Storage deposit $4868 transferred from agreement A05-CT183534 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196377, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"119","order_discount":[],"order_room":[{"room_id":"1163","room_code":"A05-161","retail_price":"2434.0","discounted_price":"2434.00","location_id":"4"}],"roughly_size":"32","total_retail_price":2434,"total_discounted_price":2191,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":26292,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2191.00","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2021-06-10","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on May 8, 2020. Storage deposit $4868 transferred from agreement A05-CT196377 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":2191,"order_total":28483,"final_order_total":26292,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005763999","order_product":[],"pass":true}},"first_order_id":"3534","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-161 <\/td>\r\n\t\t\t\t\t 4X8X7 <\/td>\r\n\t\t\t\t\t $2434.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":"32","total_discounted_price":"2191.00","deposit":"0.00","total_retail_price":"2434.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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",1044,"NEW","A05-CT207817",2434,2191,0,0,"13","13",26292,28483,26292,"2020-05-11 17:18:33","0",null,null,null,"2020-05-11","2021-06-10","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on May 8, 2020. Storage deposit $4868 transferred from agreement A05-CT196377 to this agreement. \r\n","2020-05-11","32",0,null,2191,"2191.00","2","2020-05-11 17:18:32","2","2020-05-11 17:18:32","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763999","C181044","PERSONAL","Mr","dShQm\/fpQY8l6wcUPvjXvg==","M7CfcmE2OSMlZOkNgaoDmQ==","","cfrA4NKkFA9dbJComGGCWJAVJD51G57L4zs4xVlHxA\/1ULPKajwJMIVBFaKm+nleuzw6Xy3t6IIXUVQyvMAibfiLdqs9T7F09WefpH\/KYC0=","6PBsja79dGCpSCZlUfaEww==","6jOjPLG9ChovJwY3CG7Slw==","sLC9IzBnNJHhTLc9zCbI3A==",null,1,"3534"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["7817","1163","2434.0","2434.00","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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-11","2021-06-10","1163"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 17:18:33","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":["7817",1044,"SETTLED","A05-I208146","2020-05-11 17:18:32","2020-05-11","2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",3,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",4,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",5,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",6,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",7,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",8,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",9,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",10,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",11,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",12,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["8146","RENT","\u9810\u7e73\u79df\u91d1",13,2191,"MO","1",2191,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26292,0,"8146"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 17:18:33","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":[1044,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207791","2020-05-11 17:18:32",26292,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["7791","DEPOSIT",null,"PAID","2020-05-11 17:18:32",0,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:18:33","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":["7791","INVOICE","8146","PAID","2020-05-11 17:18:32",26292,"2","2020-05-11 17:18:32","2","2020-05-11 17:18:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28: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=976&filter3=undefined","floor_plan_rent_room":[{"room_id":"872","master_room_id":"77","room_code":"Y01"}],"_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> Y01 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D462588(A)","title":"Ms","lastname":"Ip","firstname":"Ching Yee Eliza","companyname":"","email":"ip.eliza@yahoo.com.hk","tel":"94273111","address":"7C, Block 2, Marina Habitat, Apleichau, Hong Kong","pass":true,"customer_id":"976","customer_code":"C180976","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"872","room_code":"Y01","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3711,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1479.00","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-08-07","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by PPS on May 8, 2020. Smartcard provided on May 11, 2020. ","paymethod":"PPS","paymethod2":"PPS","discount_deduct":1479,"order_total":5190,"final_order_total":3711,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,02181","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3","976","NEW","A18-CT207818",1090,1038,2076,0,"3","3",3711,5190,3711,"2020-05-11 17:28:16","0",null,null,null,"2020-05-08","2020-08-07","3 months contract. Special offer 50% off. Storage rental and deposit paid by PPS on May 8, 2020. Smartcard provided on May 11, 2020. ","2020-05-08","12",0,null,1479,"1479.00","2","2020-05-11 17:28:15","2","2020-05-11 17:28:15","PPS","","","","PPS","","","",null,0,"189,02181","C180976","PERSONAL","Ms","uYf1tJDXviWCGrKTI8BYvA==","bXicfGTTHvCncWFCqwKkUQ==","","ytfFLThqnKQkZAkGJc2mifeO\/Nt3Zqd7QzAA+X3YnkvPgoY1GC+BfegDqN5jr8MnA87xEDvG2jxgwAMHN7ZVIw==","It2XmJGKnPyTA25bAlyLXA==","EwD\/dTfxAEjwqR6ZKxCgLYmQlHMT7bfcLiohSKFIIlA=","UtQIlu05i8fW6azH\/6TfOw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7818","872","1090.0","1090.00","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-08","2020-08-07","872"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 17:28:16","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":["7818","A18-D205403","PAID",2076,0,"2020-08-07","2020-05-11 17:28:15","2020-05-11 17:28:15","2","2020-05-11 17:28:15","2","2020-05-11 17:28:15","976"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7818","976","SETTLED","A18-I208147","2020-05-11 17:28:15","2020-05-08","2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8147","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8147","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,597,"MO","1",597,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8147","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1635,0,"8147"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["976","PPS","","","","PPS","","","","PAID","P207792","2020-05-11 17:28:15",3711,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7792","DEPOSIT","5403","PAID","2020-05-11 17:28:15",2076,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7792","INVOICE","8147","PAID","2020-05-11 17:28:15",1635,"2","2020-05-11 17:28:15","2","2020-05-11 17:28:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 17:41:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:01:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":"filter1=2&filter2=1470&filter3=undefined","floor_plan_rent_room":[{"room_id":"769","master_room_id":"52","room_code":"P03"},{"room_id":"778","master_room_id":"57","room_code":"P12"},{"room_id":"787","master_room_id":"63","room_code":"P21"}],"_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\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> P03 <\/td>\r\n\t\t\t\t\t 5X7X8 <\/td>\r\n\t\t\t\t\t $2188.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> P12 <\/td>\r\n\t\t\t\t\t 6X6X8 <\/td>\r\n\t\t\t\t\t $2598.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> P21 <\/td>\r\n\t\t\t\t\t 3.5X6X8 <\/td>\r\n\t\t\t\t\t $1368.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":"0","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":"","tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true,"customer_id":"1470","customer_code":"C191470","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"769","room_code":"P03","retail_price":"2188.0","discounted_price":"2188.00","location_id":"2"},{"room_id":"778","room_code":"P12","retail_price":"2598.0","discounted_price":"2598.00","location_id":"2"},{"room_id":"787","room_code":"P21","retail_price":"1368.0","discounted_price":"1368.00","location_id":"2"}],"roughly_size":"92","total_retail_price":6154,"total_discounted_price":8304,"deposit":16608,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":8304,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"16608.00","warehousing_date":"2020-04-13","rent_from":"2020-04-13","rent_to":"2020-05-12","delivery_service":"0","remark":"1 month contract. Storage rental will pay by cheque on May 15, 2020. Storage deposit $1996 transferred from agreement A14-CT207472. Storage deposit $14612 transferred from agreement A14-CT207471. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":16608,"order_total":24912,"final_order_total":8304,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"roughly_size":"92","total_discounted_price":"8304.00","deposit":"16608.00","total_retail_price":"6154.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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` = ?","parameters":["1","1","2","1470","NEW","A14-CT207819",6154,8304,16608,0,"1","1",8304,24912,8304,"2020-05-11 18:47:24","0",null,null,null,"2020-04-13","2020-05-12","1 month contract. Storage rental will pay by cheque on May 15, 2020. Storage deposit $1996 transferred from agreement A14-CT207472. Storage deposit $14612 transferred from agreement A14-CT207471. ","2020-04-13","92",0,null,16608,"16608.00","2","2020-05-11 18:47:23","2","2020-05-11 18:47:23","CHEQUE","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":["7819","769","2188.0","2188.00","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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-13","2020-05-12","769"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 18:47: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":["7819","778","2598.0","2598.00","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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-13","2020-05-12","778"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 18:47: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":["7819","787","1368.0","1368.00","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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-13","2020-05-12","787"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-11 18:47:24","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":["7819","A14-D205404","PAID",16608,0,"2020-05-12","2020-05-11 18:47:23","2020-05-11 18:47:23","2","2020-05-11 18:47:23","2","2020-05-11 18:47:23","1470"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":["7819","1470","SETTLED","A14-I208148","2020-05-11 18:47:23","2020-04-13","2","2020-05-11 18:47:23","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":["8148","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-11 18:47:23","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"8148"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-11 18:47: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":["1470","CHEQUE","","","","CHEQUE","","","","PAID","P207793","2020-05-11 18:47:23",16608,"2","2020-05-11 18:47:23","2","2020-05-11 18:47:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":["7793","DEPOSIT","5404","PAID","2020-05-11 18:47:23",16608,"2","2020-05-11 18:47:23","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:47: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":["7793","INVOICE","8148","PAID","2020-05-11 18:47:23",0,"2","2020-05-11 18:47:23","2","2020-05-11 18:47:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 18:54:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 19:05:37","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["I01","OPEN_FOR_BK_INTERNAL","34","STORAGE","2","2020-05-11 19:05:37","410"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-11 19:05:37","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["I02","OPEN_FOR_BK_INTERNAL","34","STORAGE","2","2020-05-11 19:05:37","411"]},"data_before":[],"data_after":[],"step":1} *****