{"created_at":"2020-03-14 09:58:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 10:06:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 11:26:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 11:41:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1135","master_room_id":"114","room_code":"A05-133"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1465,"customer_code":"C191465","identity_type":"PERSONAL","identity_id":"D220013(A)","title":"Ms","lastname":"LI","firstname":"Siu Wai","companyname":"","email":null,"tel":"96519538","address":"Room 1711, Lei Fook House, Ap Lei Chau Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-16","renew_room_key":"191,03202","renew_remark":"3 months contract. Storage deposit $1196 paid by cash on December 9, 2019. Storage rental will be paid by cash by December 13, 2019. Smartcard provided on December 9, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196644, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"691","room_code":"N08","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-03-16","rent_from":"2020-03-16","rent_to":"2021-03-15","delivery_service":"0","remark":"12 months contract. Storage rental paid by cash on March 14, 2020. Storage deposit $1196 transferred from agreement A14-CT196644 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03202","order_product":[],"pass":true}},"first_order_id":6644,"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>
N08 <\/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-03-14 12:20:25","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",1465,"NEW","A14-CT207406",598,538,0,0,"12","12",6456,6456,6456,"2020-03-14 12:20:25","0",null,null,null,"2020-03-16","2021-03-15","12 months contract. Storage rental paid by cash on March 14, 2020. Storage deposit $1196 transferred from agreement A14-CT196644 to this agreement. \r\n","2020-03-16","12",0,null,0,"0","2","2020-03-14 12:20:24","2","2020-03-14 12:20:24","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"191,03202","C191465","PERSONAL","Ms","mMV5J7Rfft6JJpDQA9XypQ==","hbkan9PC5SCnBxQh2lhA4w==","","ndrMXaztbuQP7T8uCyHRnOyurfT2y4sf\/jx2AIc7bGspwBCrXx+4YbHXJCUaZk7XLaiiTnUMrBBH2FuyQijETw==","i\/BmJzfAYHQhqO729B169g==",null,"35L1qgja4P8n9h9z15n1ZQ==",null,1,6644]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7406","691","598.0","598.00","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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-03-16","2021-03-15","691"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-14 12:20:25","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":["7406",1465,"SETTLED","A14-I207734","2020-03-14 12:20:24","2020-03-16","2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7734","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7734"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-14 12:20:25","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":[1465,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207382","2020-03-14 12:20:24",6456,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7382","DEPOSIT",null,"PAID","2020-03-14 12:20:24",0,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 12:20:25","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":["7382","INVOICE","7734","PAID","2020-03-14 12:20:24",6456,"2","2020-03-14 12:20:24","2","2020-03-14 12:20:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 14:45:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 14:47:09","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":["C201535","PERSONAL","Mr","85IYGmU7T42vA2xjCNQ\/9g==","hbkan9PC5SCnBxQh2lhA4w==","","Mv0z3K4f6C4VF\/G+LY\/SZw==","qv8f\/krFGh99P\/FudbY1Y1UeNKw8VGZpMdle2zbrzMo=","v1uaESv8HAaPqw\/8Ej72t\/Rzj64\/i21NAf+DjL\/Qh4lDDFFaYQ3iMIzh4\/N909DY","qSnufjHixqmeW9K\/8kA31A==","","qv8f\/krFGh99P\/FudbY1Y1UeNKw8VGZpMdle2zbrzMo=","AiekKNRFtkinFspfGhf+yA==","2","2020-03-14 14:47:07","2","2020-03-14 14:47:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:31:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:38","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=1&filter2=1535","floor_plan_rent_room":[{"room_id":"1337","master_room_id":"188","room_code":"C15-031"}],"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-031 <\/td>\r\n\t\t\t\t\t 7X5X6.5 <\/td>\r\n\t\t\t\t\t $1938.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K436363(9)","title":"Ms","lastname":"WONG","firstname":"Ngar Yan","companyname":"","email":"genevewong811@gmail.com","tel":"90420124","address":"Rm 560, Tai On Building, 57-87 Shau Kei Wan Rd, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1337","room_code":"C15-031","retail_price":"1938.0","discounted_price":"1938.00","location_id":"6"}],"roughly_size":"35","total_retail_price":1938,"total_discounted_price":1631,"deposit":2090,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":17590,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4072.00","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2021-03-14","delivery_service":"0","remark":"12 months contract. Special offer 5% 'rent now' discount. Deposit $500 paid by cash on Mar 11,2020. The balance of storage rental and deposit $17150 paid by bank transfer on Mar 14,2020. Smart card paid on the same day and provided on Mar 11,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4072,"order_total":21722,"final_order_total":17650,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012490550","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"35","total_discounted_price":"1631.00","deposit":"2090.00","total_retail_price":"1938.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["C201536","PERSONAL","Ms","sv4DsLdaxX9bS2j3xQT\/yw==","ddrfzAYTmkL\/QNu3psjONQ==","","TcJDX\/VCGluFTysFoL0VXQ==","4BEzPqYdgneltd8BsHrbT4wOAl6NJpQTeYhDaKdWGPg=","HpCrqNFXBJyq9gpogE3bXYS+BpPvESXfyrrZEfGs4SUontlGRrTAwTUmJJG2CgyBX5m4qL+wGeC34840BCls3g==","0Hm+MxqwbgMBj1EKcaCjkg==",null,"4BEzPqYdgneltd8BsHrbT4wOAl6NJpQTeYhDaKdWGPg=","rw6fRrTLQZeUkYoYVwIDlQ==","2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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",1536,"NEW","C15-CT207407",1938,1631,2090,0,"12","12",17590,21722,17650,"2020-03-14 15:38:39","0",null,null,null,"2020-03-15","2021-03-14","12 months contract. Special offer 5% 'rent now' discount. Deposit $500 paid by cash on Mar 11,2020. The balance of storage rental and deposit $17150 paid by bank transfer on Mar 14,2020. Smart card paid on the same day and provided on Mar 11,2020.","2020-03-15","35",0,null,4072,"4072.00","2","2020-03-14 15:38:38","2","2020-03-14 15:38:38","BANKIN","","","","BANKIN","","","",null,0,"0012490550","C201536","PERSONAL","Ms","sv4DsLdaxX9bS2j3xQT\/yw==","ddrfzAYTmkL\/QNu3psjONQ==","","HpCrqNFXBJyq9gpogE3bXYS+BpPvESXfyrrZEfGs4SUontlGRrTAwTUmJJG2CgyBX5m4qL+wGeC34840BCls3g==","TcJDX\/VCGluFTysFoL0VXQ==","4BEzPqYdgneltd8BsHrbT4wOAl6NJpQTeYhDaKdWGPg=","0Hm+MxqwbgMBj1EKcaCjkg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7407",1536,"11","1","60.0",60,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7407"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-03-14 15:38:39","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":["7407","1337","1938.0","1938.00","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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-03-15","2021-03-14","1337"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-14 15:38:39","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":["7407","C15-D205319","PAID",2090,0,"2021-03-14","2020-03-14 15:38:38","2020-03-14 15:38:38","2","2020-03-14 15:38:38","2","2020-03-14 15:38:38",1536]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7407",1536,"SETTLED","C15-I207735","2020-03-14 15:38:38","2020-03-15","2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,821,"MO","1",821,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",4,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",5,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",6,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",7,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",8,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",9,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",10,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",11,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7735","RENT","\u9810\u7e73\u79df\u91d1",12,1631,"MO","1",1631,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7735","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15560,0,"7735"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-14 15:38:39","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":[1536,"BANKIN","","","","BANKIN","","","","PAID","P207383","2020-03-14 15:38:38",17650,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7383","DEPOSIT","5319","PAID","2020-03-14 15:38:38",2090,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:38:39","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":["7383","INVOICE","7735","PAID","2020-03-14 15:38:38",15560,"2","2020-03-14 15:38:38","2","2020-03-14 15:38:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 15:46:10","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":["VOID","0012490550","12 months contract. Special offer 5% 'rent now' discount. Deposit $500 paid by cash on Mar 11,2020. The balance of storage rental and deposit $17150 paid by bank transfer on Mar 14,2020. Smart card paid on the same day and provided on Mar 11,2020.","2020-03-14 15:46:10","2","ddrfzAYTmkL\/QNu3psjONQ==","sv4DsLdaxX9bS2j3xQT\/yw==","4BEzPqYdgneltd8BsHrbT4wOAl6NJpQTeYhDaKdWGPg=","TcJDX\/VCGluFTysFoL0VXQ==","HpCrqNFXBJyq9gpogE3bXYS+BpPvESXfyrrZEfGs4SUontlGRrTAwTUmJJG2CgyBX5m4qL+wGeC34840BCls3g==",7407]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 16:20:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-14 16:23: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":["C201537","PERSONAL","Mr","UN8Rlw1AH+XtceAfN57SNQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","SFUm48Pv+1xueGZZxXyoHg==",null,"bCJBJyI51eyfhcB\/qWwF5CSWziEP7Ish62P5O7cxq3EI+5w9g6D0vl\/HvvePKB6I","iEVqjAB0YLP\/4TwQBmh7Nw==","",null,"U2QJLsAtm9iP8liOKqs4pw==","2","2020-03-14 16:23:45","2","2020-03-14 16:23:45"]},"data_before":[],"data_after":[],"step":1} *****