\n \n \n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
W06 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1290.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53:23","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":["C201525","PERSONAL","Mr","vIS8IXZkRCz\/4DSJEmIinoenG6ZUfvhRmXtzZy6KRoQ=","U3iGX7U0CkjAKcdgZ04K6A==","","Qy93BhGnEO1KQrhkwq1v1A==","zHs7gYv08db9ZpNBd4xf+g==","20f7aMgpRV51FiOUQ6KXK6mkR6c4knVkEjw08eLXIZ9w9x4z60rU\/ZG\/wTtfSJoa","QaEoWHg\/xDsQ4hnCUpRbZg==",null,"zHs7gYv08db9ZpNBd4xf+g==","dza0VcNR+xqOy11jGRyrRw==","2","2020-02-27 18:53:21","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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","3",1525,"NEW","A18-CT207268",1290,1290,2580,0,"1","1",3806,3870,3806,"2020-02-27 18:53:24","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Special offer 5% discount. $500 deposit paid on Feb 26,2020. The balance of storage rental and deposit paid by cash on Feb 27,2020.","2020-03-01","16",0,null,64,"64.00","2","2020-02-27 18:53:21","2","2020-02-27 18:53:21","CASH","","","","CASH","","","",null,0,"189,29014","C201525","PERSONAL","Mr","vIS8IXZkRCz\/4DSJEmIinoenG6ZUfvhRmXtzZy6KRoQ=","U3iGX7U0CkjAKcdgZ04K6A==","","20f7aMgpRV51FiOUQ6KXK6mkR6c4knVkEjw08eLXIZ9w9x4z60rU\/ZG\/wTtfSJoa","Qy93BhGnEO1KQrhkwq1v1A==","zHs7gYv08db9ZpNBd4xf+g==","QaEoWHg\/xDsQ4hnCUpRbZg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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":["7268","961","1290.0","1290.00","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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-03-01","2020-03-31","961"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-27 18:53: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":["7268","A18-D205305","PAID",2580,0,"2020-03-31","2020-02-27 18:53:21","2020-02-27 18:53:21","2","2020-02-27 18:53:21","2","2020-02-27 18:53:21",1525]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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":["7268",1525,"SETTLED","A18-I207596","2020-02-27 18:53:21","2020-03-01","2","2020-02-27 18:53:21","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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":["7596","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1226,"MO","1",1226,"2","2020-02-27 18:53:21","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1226,0,"7596"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-27 18:53: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":[1525,"CASH","","","","CASH","","","","PAID","P207244","2020-02-27 18:53:21",3806,"2","2020-02-27 18:53:21","2","2020-02-27 18:53:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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":["7244","DEPOSIT","5305","PAID","2020-02-27 18:53:21",2580,"2","2020-02-27 18:53:21","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53: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":["7244","INVOICE","7596","PAID","2020-02-27 18:53:21",1226,"2","2020-02-27 18:53:21","2","2020-02-27 18:53:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:53:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:54:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 18:59:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":"","tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true,"customer_id":"663","customer_code":"C170663","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"863","room_code":"T07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":2580,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3870,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-27","rent_from":"2020-02-27","rent_to":"2020-03-26","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by cheque on Feb 27,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3870,"final_order_total":3870,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> T07 <\/td>\n\t\t\t\t\t 4X4X7 <\/td>\n\t\t\t\t\t $1290.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1290.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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` = ?","parameters":["1","1","3","663","NEW","A18-CT207269",1290,1290,2580,0,"1","1",3870,3870,3870,"2020-02-27 19:46:54","0",null,null,null,"2020-02-27","2020-03-26","1 month contract. Storage rental and deposit paid by cheque on Feb 27,2020.","2020-02-27","16",0,null,0,"0","2","2020-02-27 19:46:54","2","2020-02-27 19:46:54","CHEQUE","","","","CHEQUE","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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":["7269","863","1290.0","1290.00","2","2020-02-27 19:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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-02-27","2020-03-26","863"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-27 19:46:54","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":["7269","A18-D205306","PAID",2580,0,"2020-03-26","2020-02-27 19:46:54","2020-02-27 19:46:54","2","2020-02-27 19:46:54","2","2020-02-27 19:46:54","663"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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":["7269","663","SETTLED","A18-I207597","2020-02-27 19:46:54","2020-02-27","2","2020-02-27 19:46:54","2","2020-02-27 19:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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":["7597","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-02-27 19:46:54","2","2020-02-27 19:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7597"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-27 19:46: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":["663","CHEQUE","","","","CHEQUE","","","","PAID","P207245","2020-02-27 19:46:54",3870,"2","2020-02-27 19:46:54","2","2020-02-27 19:46:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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":["7245","DEPOSIT","5306","PAID","2020-02-27 19:46:54",2580,"2","2020-02-27 19:46:54","2","2020-02-27 19:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:46: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":["7245","INVOICE","7597","PAID","2020-02-27 19:46:54",1290,"2","2020-02-27 19:46:54","2","2020-02-27 19:46:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 19:47:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:07","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":[],"index_url_parameter":"type=INVOICE","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"648084963005171","title":"Mr","lastname":"PHILIPPE","firstname":"Amar","companyname":"Fiber And Smith Limited","email":"philippe@fiberandsmith.com","tel":"92182522","address":"18B, 3\/F, Tai Hang Road","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"410 available_room_list_input","master_room_id":"162","discount_type":"%","price":"692.00","disocunted_price":"623.50","discount":"9.90","monthly_deduct":68.508,"room_id":"1372","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1372","room_code":"C15-066","retail_price":"692.0","discounted_price":623.5,"location_id":"6"}],"roughly_size":"8","total_retail_price":692,"total_discounted_price":623,"deposit":692,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4430,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-28","rent_from":"2020-02-28","rent_to":"2020-08-27","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by bank transfer on Feb 27,2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4490,"final_order_total":4490,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012438340","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> C15-066 <\/td>\n\t\t\t\t\t 4X2X6.5 <\/td>\n\t\t\t\t\t $692.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"8","total_discounted_price":"623.00","deposit":"692.00","total_retail_price":"692.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09: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":["C201526","BUSINESS","Mr","JtR9AUW4ziKf5ztf4C5l0g==","aWQKEuZwC7ApqZYWjPwR\/g==","Fiber And Smith Limited","7yh+aSyzMUzsdQfRvxwgUQ==","ydcvVFXS5nHniT0MGwQuO8Th2cYvUE72Sap+rmaQFIw=","ly9TbVuu5vAc98ngpZWsRQygd4T9XQqKBf9Ck0T1\/p0=",null,"Ja3AmiQpm+ITdq8uwaJIxw==","ydcvVFXS5nHniT0MGwQuO8Th2cYvUE72Sap+rmaQFIw=","bgP3o7Fz+qrqvzMgNYfI6g==","2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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",1526,"NEW","C15-CT207270",692,623,692,0,"6","6",4430,4490,4490,"2020-02-27 20:09:10","0",null,null,null,"2020-02-28","2020-08-27","6 months contract. Storage rental and deposit paid by bank transfer on Feb 27,2020. ","2020-02-28","8",0,null,0,"0","2","2020-02-27 20:09:07","2","2020-02-27 20:09:07","BANKIN","","","","BANKIN","","","",null,0,"0012438340","C201526","BUSINESS","Mr","JtR9AUW4ziKf5ztf4C5l0g==","aWQKEuZwC7ApqZYWjPwR\/g==","Fiber And Smith Limited","ly9TbVuu5vAc98ngpZWsRQygd4T9XQqKBf9Ck0T1\/p0=","7yh+aSyzMUzsdQfRvxwgUQ==","ydcvVFXS5nHniT0MGwQuO8Th2cYvUE72Sap+rmaQFIw=",null,"Ja3AmiQpm+ITdq8uwaJIxw=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7270","410 available_room_list_input","162","1372","%","9.90",68.508,"2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7270",1526,"11","1","60.0",60,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7270"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-02-27 20:09:10","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":["7270","1372","692.0",623.5,"2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-28","2020-08-27","1372"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-27 20:09:10","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":["7270","C15-D205307","PAID",692,0,"2020-08-27","2020-02-27 20:09:07","2020-02-27 20:09:07","2","2020-02-27 20:09:07","2","2020-02-27 20:09:07",1526]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7270",1526,"SETTLED","C15-I207598","2020-02-27 20:09:07","2020-02-28","2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",1,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",2,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",3,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",4,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",5,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","RENT","\u9810\u7e73\u79df\u91d1",6,623,"MO","1",623,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7598","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3798,0,"7598"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-27 20:09:10","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":[1526,"BANKIN","","","","BANKIN","","","","PAID","P207246","2020-02-27 20:09:07",4490,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7246","DEPOSIT","5307","PAID","2020-02-27 20:09:07",692,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:09:10","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":["7246","INVOICE","7598","PAID","2020-02-27 20:09:07",3798,"2","2020-02-27 20:09:07","2","2020-02-27 20:09:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1146,"customer_code":"C181146","identity_type":"PERSONAL","identity_id":"D103036(2)","title":"Ms","lastname":"Leung ","firstname":"Lai Yee","companyname":"","email":null,"tel":"93069953","address":"28\/C , Block 10 , Nam Fung Sun Cheun, Quarry Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1619.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-11","renew_room_key":"0012403799","renew_remark":"12 months contract. change from unit C15-049 to C15-048 & 047. Storage rental $7235 and deposit $935 transferred from agreement C15-CT194188 to this agreement. Remaining storage rental (ttl: $11258) paid by Cheque on 04 FEB 2019. Additional fee $150\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194293, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1354","room_code":"C15-048","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1353","room_code":"C15-047","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2020-03-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on Feb 27,2020. Deposit transferred from agreement C15-CT194293 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403799","order_product":[],"pass":true}},"first_order_id":4293,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-048 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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> C15-047 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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":"1798.00","deposit":"0.00","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1146,"NEW","C15-CT207271",2216,1798,0,0,"1","1",1798,1798,1798,"2020-02-27 20:22:50","0",null,null,null,"2020-02-11","2020-03-10","1 month contract. Storage rental paid by cheque on Feb 27,2020. Deposit transferred from agreement C15-CT194293 to this agreement.","2020-02-11","32",0,null,0,"0","2","2020-02-27 20:22:49","2","2020-02-27 20:22:49","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012403799","C181146","PERSONAL","Ms","gjSpyhqyAa7WiwccZ+QVeQ==","EU9enA5\/vY58OMUDrd7sSw==","","dX+zJ458tDKiugVFVeBzNhNApFHtw42VR0\/lPFKhmiYTCTEHyOZIjDuovvRjZrW6gZiRuj2LsbRWS9nBvW\/ZuQ==","iaEkitfo+RiWiRQ1VJ1bPg==",null,"S1RRDrlG6v7bZDT0Ztugpw==",null,1,4293]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7271","1354","1108.0","1108.00","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-11","2020-03-10","1354"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7271","1353","1108.0","1108.00","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-11","2020-03-10","1353"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7271",1146,"SETTLED","C15-I207599","2020-02-27 20:22:49","2020-02-11","2","2020-02-27 20:22:49","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7599","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-02-27 20:22:49","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"7599"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1146,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207247","2020-02-27 20:22:49",1798,"2","2020-02-27 20:22:49","2","2020-02-27 20:22:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7247","DEPOSIT",null,"PAID","2020-02-27 20:22:49",0,"2","2020-02-27 20:22:49","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-27 20:22:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7247","INVOICE","7599","PAID","2020-02-27 20:22:49",1798,"2","2020-02-27 20:22:49","2","2020-02-27 20:22:49"]},"data_before":[],"data_after":[],"step":1} *****