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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
C15-067 <\/td>\n\t\t\t\t\t	4X2X6.5 <\/td>\n\t\t\t\t\t	$692.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"8","total_discounted_price":"623.00","deposit":"692.00","total_retail_price":"692.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:37","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":["C201507","PERSONAL","Ms","GTo3hJvywaMgj0KNx16d5Q==","20knVHhKlM9kB5wugwP3yQ==","","35uTxXdUvOI+\/FbShGQ98w==",null,"6F88GPSmmnGXsPk2ZyJKWg==","wglHzBR0tCk+qK+55m0MEA==",null,null,"GfYwF8B94PbHtqZ3YLdgfw==","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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",1507,"NEW","C15-CT207162",692,623,692,0,"13","13",7204,8971,7384,"2020-02-11 15:53:38","0",null,null,null,"2020-01-15","2021-02-14","13 months contract. Special offer the 12th and 13th month free, 5% 'rent now' discount. $500 deposit paid by cash on Jan 13,2020. The balance of storage rental and deposit paid by bank transfer on Jan 14 and Feb 05,2020. Smart card and padlock paid by bank transfer on Jan 13,2020.","2020-01-15","8",0,null,1587,"1587.00","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36","BANKIN","","","","BANKIN","","","",null,0,"","C201507","PERSONAL","Ms","GTo3hJvywaMgj0KNx16d5Q==","20knVHhKlM9kB5wugwP3yQ==","","6F88GPSmmnGXsPk2ZyJKWg==","35uTxXdUvOI+\/FbShGQ98w==",null,"wglHzBR0tCk+qK+55m0MEA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7162",1507,"11","2","60.0",120,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7162",1507,"12","1","60.0",60,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[180,"7162"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-02-11 15:53:38","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":["7162","1373","692.0","692.00","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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-15","2021-02-14","1373"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 15:53:38","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":["7162","C15-D205283","PAID",692,0,"2021-02-14","2020-02-11 15:53:36","2020-02-11 15:53:36","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36",1507]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7162",1507,"SETTLED","C15-I207490","2020-02-11 15:53:36","2020-01-15","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,282,"MO","1",282,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",4,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",5,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",6,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",7,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",8,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",9,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",10,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",11,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",12,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","RENT","\u9810\u7e73\u79df\u91d1",13,623,"MO","1",623,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","ORDER_PRODUCT","60.0","PCS","2",120,"11","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7490","ORDER_PRODUCT","60.0","PCS","1",60,"12","2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6692,0,"7490"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-11 15:53:38","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":[1507,"BANKIN","","","","BANKIN","","","","PAID","P207138","2020-02-11 15:53:36",7384,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7138","DEPOSIT","5283","PAID","2020-02-11 15:53:36",692,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 15:53:38","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":["7138","INVOICE","7490","PAID","2020-02-11 15:53:36",6692,"2","2020-02-11 15:53:36","2","2020-02-11 15:53:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36: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=1&filter2=1134&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":713,"customer_code":"C180713","identity_type":"PERSONAL","identity_id":"C572643(1)","title":"Ms","lastname":"Kwan","firstname":"Yuet Ying","companyname":"","email":"vivianyykwan@gmail.com","tel":"90909699","address":"5B Honey Court, 88 Pokfulam Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"6934.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-06","renew_room_key":"0007326515 111,52019","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by cheque on December 6, 2018. Smartcard provided on December 6, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183845, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $15408.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1145","room_code":"A05-143","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"},{"room_id":"1144","room_code":"A05-142","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"},{"room_id":"1143","room_code":"A05-141","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"},{"room_id":"1142","room_code":"A05-140","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"96","total_retail_price":7428,"total_discounted_price":6934,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":83208,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"6934.0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2021-01-05","delivery_service":"0","remark":"13 months contract. Special offer, the 13th month free. Storage rental EPS on February 11, 2020. Storage deposit $15408 transferred from agreement A05-CT183845 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":6934,"order_total":90142,"final_order_total":83208,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007326515 111,52019","order_product":[],"pass":true}},"first_order_id":3845,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-143 <\/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-142 <\/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-141 <\/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-140 <\/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":"96","total_discounted_price":"6934.00","deposit":"0.00","total_retail_price":"7428.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",713,"NEW","A05-CT207163",7428,6934,0,0,"13","13",83208,90142,83208,"2020-02-11 17:36:50","0",null,null,null,"2019-12-06","2021-01-05","13 months contract. Special offer, the 13th month free. Storage rental EPS on February 11, 2020. Storage deposit $15408 transferred from agreement A05-CT183845 to this agreement. ","2019-12-06","96",0,null,6934,"6934.0","2","2020-02-11 17:36:49","2","2020-02-11 17:36:49","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0007326515 111,52019","C180713","PERSONAL","Ms","58IhlrjFeQp8XTQfqZm0mQ==","iNwdG3Dj3OBaAQ6MRfBM1w==","","p0Af\/Y6AXAxEibMRfB1qrh9rXrg1\/GdZDJx+OsAs1QDET1mCkXNCbYe2A7WDWi9\/","bdO0rmK\/zuNCbJQMicVIaw==","qfec0qSC868QcikEpTPkCg8ehKMQx1UjTXfZmoY\/Muk=","mEQIFmhaNngVvo2qXiWw7w==",null,1,3845]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7163","1145","1857.0","1857.00","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2021-01-05","1145"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7163","1144","1857.0","1857.00","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2021-01-05","1144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7163","1143","1857.0","1857.00","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2021-01-05","1143"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7163","1142","1857.0","1857.00","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2021-01-05","1142"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7163",713,"SETTLED","A05-I207491","2020-02-11 17:36:49","2019-12-06","2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",3,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",4,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",5,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",6,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",7,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",8,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",9,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",10,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",11,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",12,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7491","RENT","\u9810\u7e73\u79df\u91d1",13,6934,"MO","1",6934,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[83208,0,"7491"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[713,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207139","2020-02-11 17:36:49",83208,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7139","DEPOSIT",null,"PAID","2020-02-11 17:36:49",0,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 17:36:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7139","INVOICE","7491","PAID","2020-02-11 17:36:49",83208,"2","2020-02-11 17:36:49","2","2020-02-11 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1134&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-04","renew_room_key":"076,48044","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 6, 2020. Storage deposit $4376 transferred from agreement A12-CT196467 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206889, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-04","rent_from":"2019-12-04","rent_to":"2020-01-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 11, 2020. Storage deposit $4376 transferred from agreement A12-CT206889 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","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> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/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> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"2188.0","deposit":"0","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1355,"NEW","A12-CT207164",2276,2188,0,0,"1","1",2188,2188,2188,"2020-02-11 18:35:44","0",null,null,null,"2019-12-04","2020-01-03","1 month contract. Storage rental paid by bank transfer on February 11, 2020. Storage deposit $4376 transferred from agreement A12-CT206889 to this agreement.\r\n","2019-12-04","30",0,null,0,"0","2","2020-02-11 18:35:44","2","2020-02-11 18:35:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["7164","297","1138.0","946.00","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["2019-12-04","2020-01-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 18:35:44","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":["7164","308","1138.0","946.00","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["2019-12-04","2020-01-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 18:35:44","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":["7164",1355,"SETTLED","A12-I207492","2020-02-11 18:35:44","2019-12-04","2","2020-02-11 18:35:44","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["7492","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-02-11 18:35:44","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"7492"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-11 18:35:44","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":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207140","2020-02-11 18:35:44",2188,"2","2020-02-11 18:35:44","2","2020-02-11 18:35:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["7140","DEPOSIT",null,"PAID","2020-02-11 18:35:44",0,"2","2020-02-11 18:35:44","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:35:44","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":["7140","INVOICE","7492","PAID","2020-02-11 18:35:44",2188,"2","2020-02-11 18:35:44","2","2020-02-11 18:35:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:11","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=1&filter2=1417&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","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y017537(2)","title":"Ms","lastname":"CHONG","firstname":"Siu Ching","companyname":"","email":"","tel":"95251305","address":"Flat 4 , 38\/F CHI LAI HSE YAU LAI EST YAU TONG KLN HONG KONG","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"345 available_room_list_input","master_room_id":"144","discount_type":"%","price":"1722.00","disocunted_price":"1120.00","discount":"34.96","monthly_deduct":602.0112,"room_id":"1244","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1244","room_code":"B01-054","retail_price":"1722.0","discounted_price":1120,"location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1344,"deposit":3444,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16214,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3358.00","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2021-02-28","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free, 5% 'rent now' discount. $500 deposit paid by cash on Jan 08,2020. The balance of storage rental and deposit $15774 paid by bank transfer on Feb 11,2020. Smart card mailed out on Feb 11,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3358,"order_total":19632,"final_order_total":16274,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012438298","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> B01-054 <\/td>\n\t\t\t\t\t 4X7X7 <\/td>\n\t\t\t\t\t $1722.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"28","total_discounted_price":"1344.00","deposit":"3444.00","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:13","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":["C201508","PERSONAL","Ms","R07YqqJMM8JDBGbOP8mJvA==","sFvIMVuF8ZsYisXFtwlNOg==","","0TVL3FOq39ec9waUz45Hqg==",null,"jF\/r0rFcq3zwA1\/0dWV4BArJZfo9FWHePp3scEs\/LpAi2kBLJoQLjB0ETvJRzUAdBgZ4\/VjKHt+W5HsUoKZoGw==","RHZZG7H3noQ8ychXAgTrgA==",null,null,"N014Zu2Fu5qLNdW5y+HP2A==","2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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","2","5",1508,"NEW","B01-CT207165",1722,1344,3444,0,"12","12",16214,19632,16274,"2020-02-11 18:45:14","0",null,null,null,"2020-03-01","2021-02-28","12 months contract. Special offer the 11th and 12th month free, 5% 'rent now' discount. $500 deposit paid by cash on Jan 08,2020. The balance of storage rental and deposit $15774 paid by bank transfer on Feb 11,2020. Smart card mailed out on Feb 11,2020.","2020-03-01","28",0,null,3358,"3358.00","2","2020-02-11 18:45:11","2","2020-02-11 18:45:11","BANKIN","","","","BANKIN","","","",null,0,"0012438298","C201508","PERSONAL","Ms","R07YqqJMM8JDBGbOP8mJvA==","sFvIMVuF8ZsYisXFtwlNOg==","","jF\/r0rFcq3zwA1\/0dWV4BArJZfo9FWHePp3scEs\/LpAi2kBLJoQLjB0ETvJRzUAdBgZ4\/VjKHt+W5HsUoKZoGw==","0TVL3FOq39ec9waUz45Hqg==",null,"RHZZG7H3noQ8ychXAgTrgA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7165","345 available_room_list_input","144","1244","%","34.96",602.0112,"2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7165",1508,"11","1","60.0",60,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7165"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-02-11 18:45:14","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":["7165","1244","1722.0",1120,"2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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","2021-02-28","1244"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-11 18:45:14","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":["7165","B01-D205284","PAID",3444,0,"2021-02-28","2020-02-11 18:45:11","2020-02-11 18:45:11","2","2020-02-11 18:45:11","2","2020-02-11 18:45:11",1508]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7165",1508,"SETTLED","B01-I207493","2020-02-11 18:45:11","2020-03-01","2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,674,"MO","1",674,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",4,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",5,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",6,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",7,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",8,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",9,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",10,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",11,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","RENT","\u9810\u7e73\u79df\u91d1",12,1344,"MO","1",1344,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7493","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12830,0,"7493"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-11 18:45:14","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":[1508,"BANKIN","","","","BANKIN","","","","PAID","P207141","2020-02-11 18:45:11",16274,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7141","DEPOSIT","5284","PAID","2020-02-11 18:45:11",3444,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:45:14","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":["7141","INVOICE","7493","PAID","2020-02-11 18:45:11",12830,"2","2020-02-11 18:45:11","2","2020-02-11 18:45:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-11 18:49:15","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","","13 months contract. Special offer the 12th and 13th month free, 5% 'rent now' discount. $500 deposit paid by cash on Jan 13,2020. The balance of storage rental and deposit paid by bank transfer on Jan 14 and Feb 05,2020. Smart card and padlock paid by bank transfer on Jan 13,2020.","2020-02-11 18:49:15","2","20knVHhKlM9kB5wugwP3yQ==","GTo3hJvywaMgj0KNx16d5Q==","35uTxXdUvOI+\/FbShGQ98w==","NcPYInmefkJuEUO1t5L\/Ppx\/sZlujGHIBs9e0n5Nnxm2lO3gyIP8Q+PU\/vBZ8rW+SxvL5OjpEfG42Z2CWcsqmw==",7162]},"data_before":[],"data_after":[],"step":1} *****