\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-159 <\/td>\n\t\t\t\t\t	4X3X6.5 <\/td>\n\t\t\t\t\t	$900.00 <\/td>\n\t\t\t\t	- <\/td>	<\/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":"12","total_discounted_price":"810","deposit":"900","total_retail_price":"900.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["C191469","PERSONAL","Mr","FmB0yOaNyXZ7\/DzViZTBuXOlXnHpeBWGZwjs\/8Q6sFA=","8BEgNhGpCR8jGkzUtrIcXg==","","mi6wpxugU+tBPIImdl2KDQ==",null,"SKRCKDwszs\/m1VP\/gUSn+PT4HhH8i+9JpBjUOx6p66nofn2+o8c0QWTmLGWZOc5eQmrQWlxtx8zjZ2+QMbIyYg==","h\/kA4BTrnHU5t3g6ZU2ZlA==",null,null,"ehOx1wsRGz5uSDKZjznRGw==","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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",1469,"NEW","C15-CT196698",900,810,900,0,"12","12",8600,10740,8720,"2019-12-14 13:53:01","0",null,null,null,"2019-12-16","2020-12-15","12 months contract. Special offer the 11th and 12th months free. 5% discount. Storage rental and deposit paid by EPS on Dec 14,2019. Smartcard and padlock paid by EPS on Dec 14,2019","2019-12-16","12",0,null,2020,"2020.00","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59","EPS","","","","EPS","","","",null,0,"0012472674","C191469","PERSONAL","Mr","FmB0yOaNyXZ7\/DzViZTBuXOlXnHpeBWGZwjs\/8Q6sFA=","8BEgNhGpCR8jGkzUtrIcXg==","","SKRCKDwszs\/m1VP\/gUSn+PT4HhH8i+9JpBjUOx6p66nofn2+o8c0QWTmLGWZOc5eQmrQWlxtx8zjZ2+QMbIyYg==","mi6wpxugU+tBPIImdl2KDQ==",null,"h\/kA4BTrnHU5t3g6ZU2ZlA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["6698",1469,"11","1","60.0",60,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["6698",1469,"12","1","60.0",60,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[120,"6698"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2019-12-14 13:53:01","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":["6698","1465","900.0","900.00","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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-16","2020-12-15","1465"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-14 13:53:01","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":["6698","C15-D195218","PAID",900,0,"2020-12-15","2019-12-14 13:52:59","2019-12-14 13:52:59","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59",1469]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["6698",1469,"SETTLED","C15-I197026","2019-12-14 13:52:59","2019-12-16","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,410,"MO","1",410,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",4,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",5,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",6,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",7,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",8,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",9,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",10,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",11,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","RENT","\u9810\u7e73\u79df\u91d1",12,810,"MO","1",810,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["7026","ORDER_PRODUCT","60.0","PCS","1",60,"12","2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7820,0,"7026"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-14 13:53:01","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":[1469,"EPS","","","","EPS","","","","PAID","P196676","2019-12-14 13:52:59",8720,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["6676","DEPOSIT","5218","PAID","2019-12-14 13:52:59",900,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 13:53:01","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":["6676","INVOICE","7026","PAID","2019-12-14 13:52:59",7820,"2","2019-12-14 13:52:59","2","2019-12-14 13:52:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1389","master_room_id":"193","room_code":"C15-083"}],"_payment_type":"INVOICE","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-011 <\/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","warehousing":{"1":{"new_customer":0,"identity_type":"BUSINESS","identity_id":"provide later","title":"Mr","lastname":"Yu","firstname":"Tak Kei Ringo","companyname":"Bravo Creative Management Ltd.","email":"ringoyu@bcmhk.com","tel":"98319468","address":"Flat A, 15\/F, Vulcan House, 21-23 Leighton Road, Causeway Bay, Hong Kong","pass":true,"customer_id":1141,"customer_code":"C181141","customer_first_order":true},"2":{"order_discount":[],"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2019-10-08","renew_room_key":"0007310873","renew_remark":"3 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit transferred from agreement A05-CT195414 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195683, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_room":[{"room_id":"1013","room_code":"A05-011","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"4","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"4","prepaid_amount":4904,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-08","rent_from":"2019-10-08","rent_to":"2020-02-07","delivery_service":"0","remark":"4 months contract. Storage rental paid by bank transfer on December 14, 2019. Storage deposit transferred from agreement A05-CT195683 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4904,"final_order_total":4904,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007310873","order_product":[],"pass":true}},"renew":1,"first_order_id":"4707","roughly_size":"16","total_discounted_price":"1226.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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",1141,"NEW","A05-CT196699",1290,1226,0,0,"4","4",4904,4904,4904,"2019-12-14 15:10:40","0",null,null,null,"2019-10-08","2020-02-07","4 months contract. Storage rental paid by bank transfer on December 14, 2019. Storage deposit transferred from agreement A05-CT195683 to this agreement.","2019-10-08","16",0,null,0,"0","2","2019-12-14 15:10:39","2","2019-12-14 15:10:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007310873","C181141","BUSINESS","Mr","fPB5szRfhQDoFF8+NzJXtQ==","thtRZ5CDeQ9OOuodTdr1ng==","Bravo Creative Management Ltd.","zRpRHQsd21YbfDCyj7QmRR2rWUvgcz1ErepmgH\/IZuJV4UWK1YsDIzEgQ04zpuMx7hUgPpyvnTMu7YjPItiQRBRESa5DBBzR9k9gj2Xffyo=","2+bteiJtKwBy5oyidhRx8g==","cbLUhb9OxZTeK4XARdQo4RVP7SlgpymFj2VFLAjuUQg=",null,"ghkNgPwuN3BPyR+G706E0w==",1,"4707"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["6699","1013","1290.0","1290.00","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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-10-08","2020-02-07","1013"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-14 15:10:40","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":["6699",1141,"SETTLED","A05-I197027","2019-12-14 15:10:39","2019-10-08","2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["7027","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["7027","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["7027","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["7027","RENT","\u9810\u7e73\u79df\u91d1",4,1226,"MO","1",1226,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4904,0,"7027"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-14 15:10:40","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":[1141,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196677","2019-12-14 15:10:39",4904,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["6677","DEPOSIT",null,"PAID","2019-12-14 15:10:39",0,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:10:40","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":["6677","INVOICE","7027","PAID","2019-12-14 15:10:39",4904,"2","2019-12-14 15:10:39","2","2019-12-14 15:10:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1389","master_room_id":"193","room_code":"C15-083"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":636,"customer_code":"C170636","identity_type":"PERSONAL","identity_id":"D378660(A)","title":"Ms","lastname":"Yuen","firstname":"Che Sheung","companyname":"","email":"virginia01@netvigator.com","tel":"94178406","address":"Flat 2709, Block A, Hung Lai House, Hung Fuk Court, Tin Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4128.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-01","renew_room_key":"136,61470,137,07908","renew_remark":"12 months contract. Storage rental paid by cheque on December 22, 2018. Storage deposit transferred by agreement A18-CT182525 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT183975, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"892","room_code":"Y21","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"},{"room_id":"891","room_code":"Y20","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"},{"room_id":"890","room_code":"Y19","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"60","total_retail_price":4815,"total_discounted_price":4334,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":52008,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4334.00","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2021-01-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on December 14, 2019. Storage deposit transferred by agreement A18-CT183975 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":4334,"order_total":56342,"final_order_total":52008,"location_id":"3","branch_id":"1","company_id":"1","room_key":"136,61470,137,07908","order_product":[],"pass":true}},"first_order_id":3975,"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 \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> Y21 <\/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> Y20 <\/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> Y19 <\/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","roughly_size":"60","total_discounted_price":"4334.00","deposit":"0.00","total_retail_price":"4815.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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",636,"NEW","A18-CT196700",4815,4334,0,0,"13","13",52008,56342,52008,"2019-12-14 15:17:11","0",null,null,null,"2020-01-01","2021-01-31","12 months contract. Storage rental paid by cheque on December 14, 2019. Storage deposit transferred by agreement A18-CT183975 to this agreement.","2020-01-01","60",0,null,4334,"4334.00","2","2019-12-14 15:17:10","2","2019-12-14 15:17:10","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"136,61470,137,07908","C170636","PERSONAL","Ms","OdMlVtV2f2Rsbkbf4YB29w==","DtbrOSvE4C7BOu5x4dBFtg==","","YHuQkDTnKP\/P4EKYOHprQg1h1CZA6gPID5ZHZafLiFGmgdkMrX72P8mPXBZJjb7+a\/jMUYrVDb30g5HxZrk01KOILrEPcLktgSTVegxOQeU=","9izXZn5OqbZ+6pXy8wJyIw==","vwWGGaCTULCVLxMrknrcsrj78zbKUdb8I0xs\/0nhrWY=","tXU\/k+Lq75Ape3qOzfxulw==",null,1,3975]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["6700","892","1605.0","1605.00","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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-01","2021-01-31","892"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-14 15:17:11","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":["6700","891","1605.0","1605.00","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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-01","2021-01-31","891"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-14 15:17:11","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":["6700","890","1605.0","1605.00","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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-01","2021-01-31","890"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-14 15:17:11","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":["6700",636,"SETTLED","A18-I197028","2019-12-14 15:17:10","2020-01-01","2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",3,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",4,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",5,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",6,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",7,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",8,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",9,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",10,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",11,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",12,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["7028","RENT","\u9810\u7e73\u79df\u91d1",13,4334,"MO","1",4334,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[52008,0,"7028"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-14 15:17:11","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":[636,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196678","2019-12-14 15:17:10",52008,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["6678","DEPOSIT",null,"PAID","2019-12-14 15:17:10",0,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-14 15:17:11","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":["6678","INVOICE","7028","PAID","2019-12-14 15:17:10",52008,"2","2019-12-14 15:17:10","2","2019-12-14 15:17:10"]},"data_before":[],"data_after":[],"step":1} *****