{"created_at":"2020-03-19 09:50:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:07:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":"1399","master_room_id":"168","room_code":"C15-093"}],"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-093 <\/td>\r\n\t\t\t\t\t	4X3X6.5 <\/td>\r\n\t\t\t\t\t	$900.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":"E839145(2)","title":"Mr","lastname":"LI","firstname":"Chi Ming","companyname":"","email":"Icm839@yahoo.com.hk","tel":"90896946","address":"Rm 2006, Sheung Lai Hse, Sheung Tak Est, TKO.","pass":true,"customer_id":"1535","customer_code":"C201535","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1399","room_code":"C15-093","retail_price":"900.0","discounted_price":"900.00","location_id":"6"}],"roughly_size":"12","total_retail_price":900,"total_discounted_price":810,"deposit":900,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9000,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1620.00","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2021-03-21","delivery_service":"0","remark":"12 months contract. Deposit $500 paid by cash on Mar 14,2020. The balance of storage rental and deposit $8560 paid by bank transfer on Mar 18,2020. Smart card paid on the same day and provided on Mar 14,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1620,"order_total":10680,"final_order_total":9060,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449907","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"12","total_discounted_price":"810.00","deposit":"900.00","total_retail_price":"900.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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","1535","NEW","C15-CT207441",900,810,900,0,"12","12",9000,10680,9060,"2020-03-19 10:13:57","0",null,null,null,"2020-03-22","2021-03-21","12 months contract. Deposit $500 paid by cash on Mar 14,2020. The balance of storage rental and deposit $8560 paid by bank transfer on Mar 18,2020. Smart card paid on the same day and provided on Mar 14,2020.","2020-03-22","12",0,null,1620,"1620.00","2","2020-03-19 10:13:56","2","2020-03-19 10:13:56","BANKIN","","","","BANKIN","","","",null,0,"'0012449907","C201535","PERSONAL","Mr","85IYGmU7T42vA2xjCNQ\/9g==","hbkan9PC5SCnBxQh2lhA4w==","","v1uaESv8HAaPqw\/8Ej72t\/Rzj64\/i21NAf+DjL\/Qh4lDDFFaYQ3iMIzh4\/N909DY","Mv0z3K4f6C4VF\/G+LY\/SZw==","qv8f\/krFGh99P\/FudbY1Y1UeNKw8VGZpMdle2zbrzMo=","qSnufjHixqmeW9K\/8kA31A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7441","1535","11","1","60.0",60,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7441"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-03-19 10:13:57","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":["7441","1399","900.0","900.00","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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-22","2021-03-21","1399"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 10:13:57","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":["7441","C15-D205326","PAID",900,0,"2021-03-21","2020-03-19 10:13:56","2020-03-19 10:13:56","2","2020-03-19 10:13:56","2","2020-03-19 10:13:56","1535"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7441","1535","SETTLED","C15-I207769","2020-03-19 10:13:56","2020-03-22","2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",4,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",5,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",6,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",7,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",8,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",9,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",10,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",11,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","RENT","\u9810\u7e73\u79df\u91d1",12,810,"MO","1",810,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7769","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8160,0,"7769"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 10:13:57","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":["1535","BANKIN","","","","BANKIN","","","","PAID","P207417","2020-03-19 10:13:56",9060,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7417","DEPOSIT","5326","PAID","2020-03-19 10:13:56",900,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:13:57","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":["7417","INVOICE","7769","PAID","2020-03-19 10:13:56",8160,"2","2020-03-19 10:13:56","2","2020-03-19 10:13:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:15:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:15:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:16:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:01","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":"581","master_room_id":"35","room_code":"L59"},{"room_id":"582","master_room_id":"35","room_code":"L60"},{"room_id":"796","master_room_id":"35","room_code":"L69"},{"room_id":"797","master_room_id":"35","room_code":"L70"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1158,"customer_code":"C181158","identity_type":"BUSINESS","identity_id":"62754867","title":"Ms","lastname":"Huang","firstname":"Bobo","companyname":"Smiley APAC Limited","email":"bobo.huang@praxisIFM.com","tel":"31251225","address":"20\/F, 88 Gloucester Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-22","renew_room_key":"0012438299","renew_remark":"6 months contract. Storage rental $6695.83 paid by bank transfer on November 19, 2019. Remaining balance $276.2 will add to next contract. Storage deposit transferred from agreement A05-CT195480 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196522, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1004","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1004","room_code":"A05-002","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-07-21","delivery_service":"0","remark":"6 months contract. Storage rental $6972 paid by bank transfer on March 11, 2020. Extra $276.2 for agreement A05-CT196522. Storage deposit transferred from agreement A05-CT196522 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012438299","order_product":[],"pass":true}},"first_order_id":"4842","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-002 <\/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":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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",1158,"NEW","A05-CT207442",1290,1162,0,0,"6","6",6972,6972,6972,"2020-03-19 10:20:02","0",null,null,null,"2020-01-22","2020-07-21","6 months contract. Storage rental $6972 paid by bank transfer on March 11, 2020. Extra $276.2 for agreement A05-CT196522. Storage deposit transferred from agreement A05-CT196522 to this agreement.","2020-01-22","16",0,null,0,"0","2","2020-03-19 10:20:01","2","2020-03-19 10:20:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012438299","C181158","BUSINESS","Ms","BwMzW1CaiEBOI0sLOAXC3A==","olN5\/Q5aAg1whjEZQduEyg==","Smiley APAC Limited","0pqragv3w+r75IDnQ7c6qxTu+iPrIFZPsCQHwQID996MP50hYhUyYuN656X039Ab","GZye1tNhcqO+\/ho\/T\/MS\/w==","+rm7+x1NKVNvV7vBo3lUfSTITWjaFLqkA8JMF+walCg=",null,"j5C7xd1J5ZOGD+E5pTaOAg==",1,"4842"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7442","251","114","1004","%","10.00",129,"2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7442","1004","1290.0",1161,"2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-07-21","1004"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 10:20:02","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":["7442",1158,"SETTLED","A05-I207770","2020-03-19 10:20:01","2020-01-22","2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7770","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7770"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 10:20:02","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":[1158,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207418","2020-03-19 10:20:01",6972,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7418","DEPOSIT",null,"PAID","2020-03-19 10:20:01",0,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 10:20:02","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":["7418","INVOICE","7770","PAID","2020-03-19 10:20:01",6972,"2","2020-03-19 10:20:01","2","2020-03-19 10:20:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:17:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"581","master_room_id":"35","room_code":"L59"},{"room_id":"582","master_room_id":"35","room_code":"L60"},{"room_id":"796","master_room_id":"35","room_code":"L69"},{"room_id":"797","master_room_id":"35","room_code":"L70"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1405,"customer_code":"C191405","identity_type":"PERSONAL","identity_id":"K364971(7)","title":"Mr","lastname":"CHUNG","firstname":"Chi Wang","companyname":"","email":null,"tel":"96238152","address":"4\/10, Mei Fung Court, Aberdeen Centre, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-05","renew_room_key":"'0012398447","renew_remark":"6 months contract. Special offer 5% "rent now" discount. Storage rental and deposit paid by EPS on September 26, 2019. Smartcard and padlock provided on September 26, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196069, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"205","order_discount":[],"order_room":[{"room_id":"1523","room_code":"A16-032","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1672.00","warehousing_date":"2020-04-05","rent_from":"2020-04-05","rent_to":"2021-05-04","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on March 18, 2020. Storage deposit $3714 transferred from agreement A16-CT196069 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":1672,"order_total":21736,"final_order_total":20064,"location_id":"7","branch_id":"1","company_id":"1","room_key":"'0012398447","order_product":[],"pass":true}},"first_order_id":6069,"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> A16-032 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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","7",1405,"NEW","A16-CT207443",1857,1672,0,0,"13","13",20064,21736,20064,"2020-03-19 11:59:56","0",null,null,null,"2020-04-05","2021-05-04","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on March 18, 2020. Storage deposit $3714 transferred from agreement A16-CT196069 to this agreement. \r\n","2020-04-05","24",0,null,1672,"1672.00","2","2020-03-19 11:59:55","2","2020-03-19 11:59:55","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012398447","C191405","PERSONAL","Mr","RhKpC0RY+fgJSMkkP8eBew==","7t8bqgcU0SGVnDs8IIr2pQ==","","epVeoQVKJFYWIGT8m\/TwIeBX9bGxrDbf3GztjMZdZkGVQaIwmy\/9Zu7xrd9nqXELr4rpDMF8VazXXeoeD\/9W1A==","aiof6vQDp9r0bQyPTKeg1Q==",null,"S6nMEBhxuEmWOkOpyHikkg==",null,1,6069]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7443","1523","1857.0","1857.00","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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-05","2021-05-04","1523"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 11:59:56","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":["7443",1405,"SETTLED","A16-I207771","2020-03-19 11:59:55","2020-04-05","2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7771","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"7771"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 11:59:56","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":[1405,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207419","2020-03-19 11:59:55",20064,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7419","DEPOSIT",null,"PAID","2020-03-19 11:59:55",0,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 11:59:56","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":["7419","INVOICE","7771","PAID","2020-03-19 11:59:55",20064,"2","2020-03-19 11:59:55","2","2020-03-19 11:59:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"581","master_room_id":"35","room_code":"L59"},{"room_id":"582","master_room_id":"35","room_code":"L60"},{"room_id":"796","master_room_id":"35","room_code":"L69"},{"room_id":"797","master_room_id":"35","room_code":"L70"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1209,"customer_code":"C191209","identity_type":"BUSINESS","identity_id":"64526999-000-03-18-5","title":"Mr","lastname":"Leung","firstname":"Ka Lau","companyname":"Best View Medical Development Company","email":null,"tel":"90186205","address":"Unit 1902, Euro Trade Centre, 21-23 Des Voeus, Road, Central, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3659.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-01","renew_room_key":"'0005885043","renew_remark":"3 months contract. Storage rental paid by PPS on December 9, 2019. Storage deposit $7704 transferred from agreement A05-CT195982 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196662, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1138","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"257","master_room_id":"117","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"1139","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1139","room_code":"A05-137","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"},{"room_id":"1138","room_code":"A05-136","retail_price":"1857.0","discounted_price":1764.2,"location_id":"4"}],"roughly_size":"48","total_retail_price":3714,"total_discounted_price":3659,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10977,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2020-05-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on March 18, 2020. Storage deposit $7704 transferred from agreement A05-CT196662 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10977,"final_order_total":10977,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005885043","order_product":[],"pass":true}},"first_order_id":"4454","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> A05-137 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A05-136 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"48","total_discounted_price":"3659.0","deposit":"0","total_retail_price":"3714.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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",1209,"NEW","A05-CT207444",3714,3659,0,0,"3","3",10977,10977,10977,"2020-03-19 12:03:06","0",null,null,null,"2020-03-01","2020-05-31","3 months contract. Storage rental paid by PPS on March 18, 2020. Storage deposit $7704 transferred from agreement A05-CT196662 to this agreement.","2020-03-01","48",0,null,0,"0","2","2020-03-19 12:03:06","2","2020-03-19 12:03:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0005885043","C191209","BUSINESS","Mr","Ebe2Xk+ChWnDzqCWd6WBrw==","xEf2h2aoyRQ71ZVgBH+9WQ==","Best View Medical Development Company","fZP1EBYNZvAW0ckQSQ+CdZw5ZQNC6hOEs48GPHpGBdC5fkviQ2Xu7h5J6K8vTswvwZ7NYdBXj845+Fyi9MjI566mseupS8qSW\/Bo2+hrIq0=","5ERXd0gNQCH11R5GxrK3jw==",null,null,"Lq0JO0e7hNkl7CgT1wQOOZSm7SXwfr1rJZbv25RiWLU=",1,"4454"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7444","257","117","1138","%","5.00",92.85,"2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7444","257","117","1139","%","5.00",92.85,"2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7444","1139","1857.0",1764.2,"2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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-05-31","1139"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 12:03:06","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":["7444","1138","1857.0",1764.2,"2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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-05-31","1138"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 12:03:06","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":["7444",1209,"SETTLED","A05-I207772","2020-03-19 12:03:06","2020-03-01","2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7772","RENT","\u9810\u7e73\u79df\u91d1",1,3659,"MO","1",3659,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7772","RENT","\u9810\u7e73\u79df\u91d1",2,3659,"MO","1",3659,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7772","RENT","\u9810\u7e73\u79df\u91d1",3,3659,"MO","1",3659,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10977,0,"7772"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 12:03:06","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":[1209,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207420","2020-03-19 12:03:06",10977,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7420","DEPOSIT",null,"PAID","2020-03-19 12:03:06",0,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:03:06","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":["7420","INVOICE","7772","PAID","2020-03-19 12:03:06",10977,"2","2020-03-19 12:03:06","2","2020-03-19 12:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"432","master_room_id":"38","room_code":"J14"},{"room_id":"433","master_room_id":"38","room_code":"J15"}],"_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 \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> J14 <\/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> <\/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> J15 <\/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> <\/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":"K025697(8)","title":"Mr","lastname":"NG","firstname":"Tsz Hung Philip","companyname":"","email":"","tel":"98711189","address":"30 Black's Link, Aberdeen, Hong Kong","pass":true,"customer_id":"1537","customer_code":"C201537","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"432","room_code":"J14","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"},{"room_id":"433","room_code":"J15","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2599,"deposit":5776,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":31836,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"7727.00","warehousing_date":"2020-03-25","rent_from":"2020-03-25","rent_to":"2021-04-24","delivery_service":"0","remark":"13 months contract. Special offer first 3 months 50% off and extra 6% off. Storage rental and deposit paid by PPS on March 18, 2020. Smartcard provided on March 25, 2020.","paymethod":"PPS","paymethod2":"PPS","discount_deduct":7727,"order_total":39563,"final_order_total":31836,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,33523","order_product":[],"pass":true}},"roughly_size":"40","total_discounted_price":"2599.00","deposit":"5776.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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","1537","NEW","A14-CT207445",3056,2599,5776,0,"13","13",31836,39563,31836,"2020-03-19 12:11:08","0",null,null,null,"2020-03-25","2021-04-24","13 months contract. Special offer first 3 months 50% off and extra 6% off. Storage rental and deposit paid by PPS on March 18, 2020. Smartcard provided on March 25, 2020.","2020-03-25","40",0,null,7727,"7727.00","2","2020-03-19 12:11:08","2","2020-03-19 12:11:08","PPS","","","","PPS","","","",null,0,"076,33523","C201537","PERSONAL","Mr","UN8Rlw1AH+XtceAfN57SNQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","bCJBJyI51eyfhcB\/qWwF5CSWziEP7Ish62P5O7cxq3EI+5w9g6D0vl\/HvvePKB6I","SFUm48Pv+1xueGZZxXyoHg==",null,"iEVqjAB0YLP\/4TwQBmh7Nw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7445","432","1528.0","1528.00","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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-25","2021-04-24","432"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 12:11:08","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":["7445","433","1528.0","1528.00","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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-25","2021-04-24","433"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 12:11:08","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":["7445","A14-D205327","PAID",5776,0,"2021-04-24","2020-03-19 12:11:08","2020-03-19 12:11:08","2","2020-03-19 12:11:08","2","2020-03-19 12:11:08","1537"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7445","1537","SETTLED","A14-I207773","2020-03-19 12:11:08","2020-03-25","2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,70,"MO","1",70,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",4,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",5,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",6,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",7,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",8,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",9,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",10,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",11,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",12,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7773","RENT","\u9810\u7e73\u79df\u91d1",13,2599,"MO","1",2599,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26060,0,"7773"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 12:11:08","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":["1537","PPS","","","","PPS","","","","PAID","P207421","2020-03-19 12:11:08",31836,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7421","DEPOSIT","5327","PAID","2020-03-19 12:11:08",5776,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:11:08","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":["7421","INVOICE","7773","PAID","2020-03-19 12:11:08",26060,"2","2020-03-19 12:11:08","2","2020-03-19 12:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&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":"432","master_room_id":"38","room_code":"J14"},{"room_id":"433","master_room_id":"38","room_code":"J15"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1369,"customer_code":"C191369","identity_type":"PERSONAL","identity_id":"K168595(3)","title":"Ms","lastname":"Lam","firstname":"Chak Yan Jessie Teresa","companyname":"","email":"jessielam98@yahoo.com","tel":"90249982","address":"Flat G, 39\/F, Block 10, Park Central, 9 Tong Tak St, Tseung Kwan O, New Territories","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1722.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-17","renew_room_key":"0012400828","renew_remark":"1 month contract. Storage rental paid by PPS on February 19, 2020. Storage deposit $3444 transferred from agreement B01-CT206923 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207231, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"144","order_discount":[],"order_room":[{"room_id":"1245","room_code":"B01-055","retail_price":"1722.0","discounted_price":"1722.00","location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1722,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1722,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-17","rent_from":"2020-03-17","rent_to":"2020-04-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 18, 2020. Storage deposit $3444 transferred from agreement B01-CT207231 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1722,"final_order_total":1722,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012400828","order_product":[],"pass":true}},"first_order_id":"5735","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-055 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $1722.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1722.0","deposit":"0","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1369,"NEW","B01-CT207446",1722,1722,0,0,"1","1",1722,1722,1722,"2020-03-19 12:14:42","0",null,null,null,"2020-03-17","2020-04-16","1 month contract. Storage rental paid by PPS on March 18, 2020. Storage deposit $3444 transferred from agreement B01-CT207231 to this agreement. \r\n","2020-03-17","28",0,null,0,"0","2","2020-03-19 12:14:42","2","2020-03-19 12:14:42","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012400828","C191369","PERSONAL","Ms","jK0sLQIokMTYV3ZXRP7RRXDjgJo6nAphSESGZHss\/8U=","0JxYUqbNPOvgfMwVa0l0NA==","","pTmVYn+9+08jSfjkrAQ930uwUJzZ7GoK3+66lfew+t\/0fxR9nqTrYogXakd2cb9Sk2zdmyu\/qWeMNreBPl1p7XP\/HNblMsLwTfHvYfY+z2iPqem7sllCAATFp9Gnw3Iz","oV5+sNO0lE615GWj8tpo0Q==","kejhjXk8xC0HdcA9K5VT+zQSSUKUT3H1mkDxQhBuRjw=","VerPwfNhcgk\/G01dKO+a8A==",null,1,"5735"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","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":["7446","1245","1722.0","1722.00","2","2020-03-19 12:14:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","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-17","2020-04-16","1245"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 12:14:42","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":["7446",1369,"SETTLED","B01-I207774","2020-03-19 12:14:42","2020-03-17","2","2020-03-19 12:14:42","2","2020-03-19 12:14:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","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":["7774","RENT","\u9810\u7e73\u79df\u91d1",1,1722,"MO","1",1722,"2","2020-03-19 12:14:42","2","2020-03-19 12:14:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1722,0,"7774"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 12:14:42","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":[1369,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207422","2020-03-19 12:14:42",1722,"2","2020-03-19 12:14:42","2","2020-03-19 12:14:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","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":["7422","DEPOSIT",null,"PAID","2020-03-19 12:14:42",0,"2","2020-03-19 12:14:42","2","2020-03-19 12:14:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 12:14:42","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":["7422","INVOICE","7774","PAID","2020-03-19 12:14:42",1722,"2","2020-03-19 12:14:42","2","2020-03-19 12:14:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 13:59:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:13:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1399","master_room_id":"168","room_code":"C15-093"}],"index_url_parameter":"filter1=2&filter2=1272&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1399,"customer_code":"C191399","identity_type":"PERSONAL","identity_id":"E575975(0)","title":"Ms","lastname":"Chan","firstname":"Hay Lin Helina","companyname":"","email":null,"tel":"63338303","address":"Flat A, 5\/F, Lee Loy Building, 208-214 Jaffe Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1709.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-23","renew_room_key":"0012492259","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit $1798 transferred from agreement C15-CT195970 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196732, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"175","order_discount":[{"master_room_discount_id":"425","master_room_id":"175","discount_type":"%","price":"1798.00","disocunted_price":"1709.00","discount":"4.95","monthly_deduct":89.001,"room_id":"1336","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1336","room_code":"C15-030","retail_price":"1798.0","discounted_price":1709,"location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1709,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5127,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-23","rent_from":"2020-03-23","rent_to":"2020-06-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Mar 19,2020. Storage deposit $1798 transferred from agreement C15-CT196732 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5127,"final_order_total":5127,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012492259","order_product":[],"pass":true}},"first_order_id":"5970","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-030 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.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":"1709.0","deposit":"0","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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",1399,"NEW","C15-CT207447",1798,1709,0,0,"3","3",5127,5127,5127,"2020-03-19 14:24:42","0",null,null,null,"2020-03-23","2020-06-22","3 months contract. Storage rental paid by bank transfer on Mar 19,2020. Storage deposit $1798 transferred from agreement C15-CT196732 to this agreement. ","2020-03-23","32",0,null,0,"0","2","2020-03-19 14:24:42","2","2020-03-19 14:24:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012492259","C191399","PERSONAL","Ms","dgnQEcVZi1EZLjTWX+ppYw==","U9yoE9KqV1v8YlRkf7Q2yg==","","ywVxvk05TgD8Wb2m2UZRlq8FoT4im6LKUpPN8M3pTRVWzNO4mytYaNOMiLvHGM88TQIeUSx1LClBwD6L8rsOsrj7AvphN89zrg0I0JpT6Vg=","ReWy0y\/qiou4+0w7t2ORWQ==",null,"3qRHtmtirKwYMExOWh5yCg==",null,1,"5970"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7447","425","175","1336","%","4.95",89.001,"2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7447","1336","1798.0",1709,"2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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-23","2020-06-22","1336"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 14:24:42","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":["7447",1399,"SETTLED","C15-I207775","2020-03-19 14:24:42","2020-03-23","2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7775","RENT","\u9810\u7e73\u79df\u91d1",1,1709,"MO","1",1709,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7775","RENT","\u9810\u7e73\u79df\u91d1",2,1709,"MO","1",1709,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7775","RENT","\u9810\u7e73\u79df\u91d1",3,1709,"MO","1",1709,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5127,0,"7775"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 14:24:42","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":[1399,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207423","2020-03-19 14:24:42",5127,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7423","DEPOSIT",null,"PAID","2020-03-19 14:24:42",0,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 14:24:42","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":["7423","INVOICE","7775","PAID","2020-03-19 14:24:42",5127,"2","2020-03-19 14:24:42","2","2020-03-19 14:24:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:00:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:05:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06: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":"filter1=2&filter2=1272&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":963,"customer_code":"C180963","identity_type":"BUSINESS","identity_id":"33061221-000-10-17-1","title":"Mrs","lastname":"Wong","firstname":"Yuk Ping","companyname":"IBIS CREATIVITY WORKSHOP LIMITED","email":"ibis@ibis-hk.com","tel":"94680068","address":"Rm916 Flat 9F , Lee Garden One, 33 Hysan Avenue, Causeway Bay, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1619.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-21","renew_room_key":"0012510408","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 17, 2019. Storage deposit $3596 transferred from agreement C15-CT183144 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195971, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"175","order_discount":[],"order_room":[{"room_id":"1333","room_code":"C15-027","retail_price":"1798.0","discounted_price":"1798.00","location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"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-03-21","rent_from":"2020-03-21","rent_to":"2020-04-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Mar 19,2020. Storage deposit $3596 transferred from agreement C15-CT195971 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012510408","order_product":[],"pass":true}},"first_order_id":"3144","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-027 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.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":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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",963,"NEW","C15-CT207448",1798,1798,0,0,"1","1",1798,1798,1798,"2020-03-19 15:06:49","0",null,null,null,"2020-03-21","2020-04-20","1 month contract. Storage rental paid by bank transfer on Mar 19,2020. Storage deposit $3596 transferred from agreement C15-CT195971 to this agreement.","2020-03-21","32",0,null,0,"0","2","2020-03-19 15:06:49","2","2020-03-19 15:06:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012510408","C180963","BUSINESS","Mrs","5nWz0f9irq1mpSYEPzhFkQ==","hULSwM2MvFtpeV9\/z+er8Q==","IBIS CREATIVITY WORKSHOP LIMITED","z3qzqcx8u5FtQ9tZnC4dKVWBMCZgMMCCjXpl3U4kS765RGyxUIAd8PBmzXGu49kfwVk0wWi4p0m2EElX\/6IMrt8n2hz1AInta5acetygPpc=","X\/NJ4\/2zOtRicy10n7PStw==","YQLw1ZRbgqZl12kT9Jc6fH+M\/Tt\/yTMJFLocdz5Xf7k=",null,"\/qqCpNSZEmuq3Spj6s\/hFOzl7b7lV8fIzJFSkvNfkcs=",1,"3144"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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":["7448","1333","1798.0","1798.00","2","2020-03-19 15:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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-21","2020-04-20","1333"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 15:06:49","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":["7448",963,"SETTLED","C15-I207776","2020-03-19 15:06:49","2020-03-21","2","2020-03-19 15:06:49","2","2020-03-19 15:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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":["7776","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-03-19 15:06:49","2","2020-03-19 15:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"7776"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 15:06:49","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":[963,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207424","2020-03-19 15:06:49",1798,"2","2020-03-19 15:06:49","2","2020-03-19 15:06:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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":["7424","DEPOSIT",null,"PAID","2020-03-19 15:06:49",0,"2","2020-03-19 15:06:49","2","2020-03-19 15:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:06:49","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":["7424","INVOICE","7776","PAID","2020-03-19 15:06:49",1798,"2","2020-03-19 15:06:49","2","2020-03-19 15:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 15:55:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32: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","index_url_parameter":"filter1=0&filter2=4202&filter3=undefined","floor_plan_rent_room":[{"room_id":"469","master_room_id":"67","room_code":"K06"}],"_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> K06(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $1118.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":"D438955(8)","title":"Mr","lastname":"Choy","firstname":"Tak Yee","companyname":"","email":"","tel":"62036420","address":"\u9999\u6e2f\u4ed4\u5927\u9053171\u865fU\u5730\u4e0b","pass":true,"customer_id":"40","customer_code":"C150040","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"469","room_code":"K06(\u670d\u88dd\u5009)","retail_price":"1118.0","discounted_price":"1118.00","location_id":"2"}],"roughly_size":"12","total_retail_price":1118,"total_discounted_price":1118,"deposit":2236,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3550.00","warehousing_date":"2020-03-19","rent_from":"2020-03-19","rent_to":"2021-04-18","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% discount. Storage deposit $500 paid by cash on March 16, 2020. Remaining balance $13220 paid by cheque on March 19, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3550,"order_total":16770,"final_order_total":13220,"location_id":"2","branch_id":"1","company_id":"1","room_key":"'076, 30957","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1118.00","deposit":"2236.00","total_retail_price":"1118.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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","40","NEW","A14-CT207449",1118,1118,2236,0,"13","13",13220,16770,13220,"2020-03-19 16:32:49","0",null,null,null,"2020-03-19","2021-04-18","13 months contract. Special offer the 13th month free and 5% discount. Storage deposit $500 paid by cash on March 16, 2020. Remaining balance $13220 paid by cheque on March 19, 2020. ","2020-03-19","12",0,null,3550,"3550.00","2","2020-03-19 16:32:48","2","2020-03-19 16:32:48","CHEQUE","","","","CHEQUE","","","",null,0,"'076, 30957","C150040","PERSONAL","Mr","98FIRe8cUg6hLN0Mrr4E1g==","UrsMAvfb5x9QBcnJ8435JA==","","QRSxyx1iECrO4a\/qSgoPG2efz+PX2ZoQrGAOf\/1+4\/A=","72B8qN2540Aw9KknS9gsgw==",null,"qlS+DAiM3kE+yN0G763ijg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7449","469","1118.0","1118.00","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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-19","2021-04-18","469"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 16:32:49","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":["7449","A14-D205328","PAID",2236,0,"2021-04-18","2020-03-19 16:32:48","2020-03-19 16:32:48","2","2020-03-19 16:32:48","2","2020-03-19 16:32:48","40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7449","40","SETTLED","A14-I207777","2020-03-19 16:32:48","2020-03-19","2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,922,"MO","1",922,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",5,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",6,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",7,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",8,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",9,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",10,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",11,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",12,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7777","RENT","\u9810\u7e73\u79df\u91d1",13,1118,"MO","1",1118,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10984,0,"7777"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 16:32:49","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":["40","CHEQUE","","","","CHEQUE","","","","PAID","P207425","2020-03-19 16:32:48",13220,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7425","DEPOSIT","5328","PAID","2020-03-19 16:32:48",2236,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:32:49","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":["7425","INVOICE","7777","PAID","2020-03-19 16:32:48",10984,"2","2020-03-19 16:32:48","2","2020-03-19 16:32:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 16:51:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=4202&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"469","master_room_id":"67","room_code":"K06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":660,"customer_code":"C170660","identity_type":"PERSONAL","identity_id":"D354297(2)","title":"Mr","lastname":"Low","firstname":"Hon Keet Stephen","companyname":"","email":"aequinox@ymail.com","tel":"64638416","address":"GPO Box 1688, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2334.0","renew_rent_month":"3","renew_warehousing_date":"2021-03-29","renew_room_key":"055,15470","renew_remark":"3 months contract. Storage rental paid by cash on Dec 12, 2019. Storage deposit transferred from agreement A18-CT195959 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196664, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"987","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"986","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"987","room_code":"X12","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"},{"room_id":"986","room_code":"X11","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2334,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7002,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2021-03-29","rent_from":"2021-03-29","rent_to":"2021-06-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on March 19, 2020. Storage deposit transferred from agreement A18-CT196664 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":7002,"final_order_total":7002,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,15470","order_product":[],"pass":true}},"first_order_id":"4650","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> X12 <\/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> X11 <\/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":"32","total_discounted_price":"2334.0","deposit":"0","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",660,"NEW","A18-CT207450",2580,2334,0,0,"3","3",7002,7002,7002,"2020-03-19 17:23:04","0",null,null,null,"2021-03-29","2021-06-28","3 months contract. Storage rental paid by cash on March 19, 2020. Storage deposit transferred from agreement A18-CT196664 to this agreement.","2021-03-29","32",0,null,0,"0","2","2020-03-19 17:23:04","2","2020-03-19 17:23:04","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,15470","C170660","PERSONAL","Mr","8WARjcd6zFu40\/HzPdJPfN1ULF7Z3rO82+vQIx5x\/SM=","hXEebd6SlV7J+4vJgo12Ig==","","VBq6cRnFyG95IonRizJi+lwCL6Oe\/bdLOb6ELHGGPWo=","EMRlE0\/B9grUj7uTzS0zfA==","GKb98Vl5nys8iXuEjTSvUjIQSI4LYfAqndGeMATNE\/I=","e9TAobvjjMmIxa53EKWduA==",null,1,"4650"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","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":["7450","248","91","987","%","4.97",64.113,"2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","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":["7450","248","91","986","%","4.97",64.113,"2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7450","987","1290.0",1225.9,"2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-03-29","2021-06-28","987"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7450","986","1290.0",1225.9,"2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-03-29","2021-06-28","986"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7450",660,"SETTLED","A18-I207778","2020-03-19 17:23:04","2021-03-29","2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7778","RENT","\u9810\u7e73\u79df\u91d1",1,2334,"MO","1",2334,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7778","RENT","\u9810\u7e73\u79df\u91d1",2,2334,"MO","1",2334,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7778","RENT","\u9810\u7e73\u79df\u91d1",3,2334,"MO","1",2334,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7002,0,"7778"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[660,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207426","2020-03-19 17:23:04",7002,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7426","DEPOSIT",null,"PAID","2020-03-19 17:23:04",0,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:23:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7426","INVOICE","7778","PAID","2020-03-19 17:23:04",7002,"2","2020-03-19 17:23:04","2","2020-03-19 17:23:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43: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","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"942","master_room_id":"78","room_code":"V16"}],"_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> V16 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K086615(6)","title":"Ms","lastname":"Yung","firstname":"Chi Han","companyname":"","email":"SandyPui9@yahoo.com.hk","tel":"97393288","address":"Rm 526, Yi Tak House, Lung Tak Court, Stanley ","pass":true,"customer_id":"662","customer_code":"C170662","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"942","room_code":"V16","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":3210,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4815,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-19","rent_from":"2020-03-19","rent_to":"2020-04-18","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on March 19, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4815,"final_order_total":4815,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,45426","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1605.00","deposit":"3210.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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","662","NEW","A18-CT207451",1605,1605,3210,0,"1","1",4815,4815,4815,"2020-03-19 17:43:46","0",null,null,null,"2020-03-19","2020-04-18","1 month contract. Storage rental and deposit paid by bank transfer on March 19, 2020. ","2020-03-19","20",0,null,0,"0","2","2020-03-19 17:43:45","2","2020-03-19 17:43:45","BANKIN","","","","BANKIN","","","",null,0,"054,45426","C170662","PERSONAL","Ms","mzl9wJ\/hSEhLPzoiI6h6Zg==","Gx5wC5plnNkrLawNtCgpAA==","","QSN9WoJ9HAqQmHqFLp+5omeZP9\/Zep834Gc0bVH0YIcNuUxGnWi98jx1KNX3AiIE","wYbP0yGhFCXVgrI69fweHw==","xlNbTqyqiOnpFGCRI0oDYYLdYgJaoXlL\/aEXLgLIm2E=","\/r1IszNScVIFPiHhdPS6PA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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":["7451","942","1605.0","1605.00","2","2020-03-19 17:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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-19","2020-04-18","942"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 17:43:46","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":["7451","A18-D205329","PAID",3210,0,"2020-04-18","2020-03-19 17:43:45","2020-03-19 17:43:45","2","2020-03-19 17:43:45","2","2020-03-19 17:43:45","662"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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":["7451","662","SETTLED","A18-I207779","2020-03-19 17:43:45","2020-03-19","2","2020-03-19 17:43:45","2","2020-03-19 17:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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":["7779","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-03-19 17:43:45","2","2020-03-19 17:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"7779"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 17:43:46","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":["662","BANKIN","","","","BANKIN","","","","PAID","P207427","2020-03-19 17:43:45",4815,"2","2020-03-19 17:43:45","2","2020-03-19 17:43:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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":["7427","DEPOSIT","5329","PAID","2020-03-19 17:43:45",3210,"2","2020-03-19 17:43:45","2","2020-03-19 17:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:43:46","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":["7427","INVOICE","7779","PAID","2020-03-19 17:43:45",1605,"2","2020-03-19 17:43:45","2","2020-03-19 17:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:44:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:47:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 17:58:27","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:02:24","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:06:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:23:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:24:55","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":["C201541","PERSONAL","Ms","tC7uPunajh0MRBsyfcX7gw==","+DIqoIiVKYgoYtcxzTTCmw==","","28+P2\/aXUQjCETOiwFwJGg==","ymnNl12u9uxxHzvQb5vAeAeyQ6RAYV6r6UCAdCjC10I=","eyxC82qUseKWnLp4mebzuglMoPDApORAHfh7k9cbwIPiP1NTghgf25md1+thXRh5","6B+IEP7FH0F6giORvS3q+Q==","","ymnNl12u9uxxHzvQb5vAeAeyQ6RAYV6r6UCAdCjC10I=","i0VaTtIGAKmfUjIogrCIGw==","2","2020-03-19 18:24:52","2","2020-03-19 18:24:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:33:29","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"55","master_room_id":"10","room_code":"B03"},{"room_id":"69","master_room_id":"10","room_code":"B17"}],"_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 \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> B03 <\/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> B17 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D125298(5)","title":"Mr","lastname":"TSUI","firstname":"Kam Lun","companyname":"","email":"alantsui0620@gmail.com","tel":"93258253","address":"Room 906, Wah Yin House, Wah Kwai Estate, Aberdeen, H.K.","pass":true,"customer_id":"1538","customer_code":"C201538","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"55","room_code":"B03","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"},{"room_id":"69","room_code":"B17","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2744,"deposit":5776,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3900.00","warehousing_date":"2020-03-25","rent_from":"2020-03-25","rent_to":"2020-06-24","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on March 19, 2020. Smartcard and padlock provided on March 18, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3900,"order_total":14008,"final_order_total":10108,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 39669","order_product":[],"pass":true}},"roughly_size":"40","total_discounted_price":"2744.00","deposit":"5776.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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` = ?","parameters":["1","1","1","1538","NEW","A12-CT207452",3056,2744,5776,0,"3","3",10108,14008,10108,"2020-03-19 18:43:48","0",null,null,null,"2020-03-25","2020-06-24","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by cash on March 19, 2020. Smartcard and padlock provided on March 18, 2020. ","2020-03-25","40",0,null,3900,"3900.00","2","2020-03-19 18:43:48","2","2020-03-19 18:43:48","CASH","","","","CASH","","","",null,0,"190, 39669","C201538","PERSONAL","Mr","pEbcaHC\/pfkOb62ZmXi\/xg==","4zek2V6v+muRHEsNI7xEHw==","","X4JJcZ3sWI5XTJc7AfbY4JMHQCqXJ0AUevjgcL3lt2LsRwZUiBp22Cu7iQT+WBYlMvlBfY6C6OUXw8RFvQIk8g==","jD8m5+oNvPK+rounbt\/1YA==","kEYaF0oS4wB5ZGnrK8ZGHyxa2HqcDeHeRYnpppRJodU=","hVkoyO4f5Aj6YCior\/LFvg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7452","55","1528.0","1528.00","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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-03-25","2020-06-24","55"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 18:43: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":["7452","69","1528.0","1528.00","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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-03-25","2020-06-24","69"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-19 18:43:48","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":["7452","A12-D205330","PAID",5776,0,"2020-06-24","2020-03-19 18:43:48","2020-03-19 18:43:48","2","2020-03-19 18:43:48","2","2020-03-19 18:43:48","1538"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7452","1538","SETTLED","A12-I207780","2020-03-19 18:43:48","2020-03-25","2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7780","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7780","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1588,"MO","1",1588,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7780","RENT","\u9810\u7e73\u79df\u91d1",3,2744,"MO","1",2744,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4332,0,"7780"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-19 18:43: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":["1538","CASH","","","","CASH","","","","PAID","P207428","2020-03-19 18:43:48",10108,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7428","DEPOSIT","5330","PAID","2020-03-19 18:43:48",5776,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-19 18:43: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":["7428","INVOICE","7780","PAID","2020-03-19 18:43:48",4332,"2","2020-03-19 18:43:48","2","2020-03-19 18:43:48"]},"data_before":[],"data_after":[],"step":1} *****