\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-086 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1112.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":"16","total_discounted_price":"868.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["C201599","PERSONAL","Mr","5ZByCHJn42qX8xge9S5hhw==","BLxWt7e4owYJMFkn6\/eeMQ==","","YoQVZQCy5jPk+78fFBs+4g==",null,"jKv8A5eo7+1+qvt3m4QxftI6tmcqzXK2Lhhn8ESCUzk2LgmjWi7JAV24KokxCGfE","omWG8s7TUI9V\/Gt1IJsc4g==",null,null,"ZXMprGdet0DZJ+dhcHN5yQ==","2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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",1599,"NEW","B01-CT207994",1112,868,2224,0,"12","12",10904,12700,10964,"2020-05-30 10:22:31","0",null,null,null,"2020-07-01","2021-06-30","12 months contract. Special off 2 months free. Storage rental and deposit paid by cheque on May 30, 2020. Smartcart paid on May 30, 2020. ","2020-07-01","16",0,null,1736,"1736.00","2","2020-05-30 10:22:30","2","2020-05-30 10:22:30","CHEQUE","","","","CHEQUE","","","",null,0,"'0005010024","C201599","PERSONAL","Mr","5ZByCHJn42qX8xge9S5hhw==","BLxWt7e4owYJMFkn6\/eeMQ==","","jKv8A5eo7+1+qvt3m4QxftI6tmcqzXK2Lhhn8ESCUzk2LgmjWi7JAV24KokxCGfE","YoQVZQCy5jPk+78fFBs+4g==",null,"omWG8s7TUI9V\/Gt1IJsc4g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["7994","341 available_room_list_input","140","1276","%","34.90",388.088,"2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["7994",1599,"11","1","60.0",60,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7994"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-05-30 10:22:31","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":["7994","1276","1112.0",723.9,"2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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-07-01","2021-06-30","1276"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-30 10:22:31","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":["7994","B01-D205440","PAID",2224,0,"2021-06-30","2020-05-30 10:22:30","2020-05-30 10:22:30","2","2020-05-30 10:22:30","2","2020-05-30 10:22:30",1599]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["7994",1599,"SETTLED","B01-I208323","2020-05-30 10:22:30","2020-07-01","2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["8323","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8740,0,"8323"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-30 10:22:31","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":[1599,"CHEQUE","","","","CHEQUE","","","","PAID","P207967","2020-05-30 10:22:30",10964,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["7967","DEPOSIT","5440","PAID","2020-05-30 10:22:30",2224,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:22:31","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":["7967","INVOICE","8323","PAID","2020-05-30 10:22:30",8740,"2","2020-05-30 10:22:30","2","2020-05-30 10:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 10:51:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 11:42:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:52","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=2&filter2=1511&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":436,"customer_code":"C170436","identity_type":"PERSONAL","identity_id":"Z914788(9)","title":"Mr","lastname":"Koo ","firstname":"Man Ho","companyname":"","email":"donaldkoo1988@gmail.com","tel":"65078585","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6e2f\u6cf0\u95a37\u6a132\u865f","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-15","renew_room_key":"052,26173","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 14, 2019. Storage deposit transferred from agreement A12-CT194954 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196393, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"103","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"103","room_code":"B51","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-11-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 30, 2020. Storage deposit transferred from agreement A12-CT196393 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,26173","order_product":[],"pass":true}},"first_order_id":"3588","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> B51 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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",436,"NEW","A12-CT207995",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-30 13:07:53","0",null,null,null,"2020-05-15","2020-11-14","6 months contract. Storage rental paid by EPS on May 30, 2020. Storage deposit transferred from agreement A12-CT196393 to this agreement.\r\n","2020-05-15","20",0,null,0,"0","2","2020-05-30 13:07:52","2","2020-05-30 13:07:52","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"052,26173","C170436","PERSONAL","Mr","jGP6SPxDvmecJxk7lZKF\/A==","\/0h+Rn+46JN9gJzcPFgFQQ==","","hI6IrHjcy5pLAjEBRvfJ44Uqjsql3l6sWeYw2PGHIdgxLRurRscNFFquSOeznc5O","x\/Iaz+YXFKwYBaCj66x9pA==","rWFTM+NVB71wqj8I8tK28zfXt6foO4AAI7FLZsgT\/Bk=","wVMKxOmnQF48sbdwZ03BXA==",null,1,"3588"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["7995","76","10","103","%","9.95",152.036,"2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["7995","103","1528.0",1376,"2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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-05-15","2020-11-14","103"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-30 13:07:53","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":["7995",436,"SETTLED","A12-I208324","2020-05-30 13:07:52","2020-05-15","2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["8324","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8324"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-30 13:07:53","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":[436,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207968","2020-05-30 13:07:52",6834,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["7968","DEPOSIT",null,"PAID","2020-05-30 13:07:52",0,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 13:07:53","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":["7968","INVOICE","8324","PAID","2020-05-30 13:07:52",6834,"2","2020-05-30 13:07:52","2","2020-05-30 13:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 14:54:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 14:54:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 14:55:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 15:22:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 15:26:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:28","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=2&filter2=1511&filter3=undefined&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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1597","master_room_id":"202","room_code":"A16-106"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-106 <\/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> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"E276382(A)","title":"Mr","lastname":"WONG","firstname":"Shek Wan","companyname":"","email":"","tel":"96637807","address":"Room 506, Wah Ming House, Wah Fu Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1597","room_code":"A16-106","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1038,"deposit":2076,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6747,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-05-30","rent_from":"2020-05-30","rent_to":"2020-11-29","delivery_service":"0","remark":"6 months contract. Special offer renew price list and first 3 months 50% off. Storage rental paid by cash on May 30, 2020. Smartcard and padlock provided on May 30, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1557,"order_total":8304,"final_order_total":6747,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189, 63767","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["C201600","PERSONAL","Mr","OAUwavzXylc32qN4rF+DQg==","ddrfzAYTmkL\/QNu3psjONQ==","","pgmrarALokoARsPc1os1iQ==",null,"0hsaMxhXKIjCiPQu5jDCffEfzGhbqvUpVm7WFyE3kI26lxe4g1tAt1h+VcH7ld5pmep7y3glibNPNwzXCA892A==","2JxDzjbYdbaLm97VLn79zA==",null,null,"44Yk8jHUFrhfRwzJa8OM6Q==","2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1600,"NEW","A16-CT207996",1290,1038,2076,0,"6","6",6747,8304,6747,"2020-05-30 16:37:30","0",null,null,null,"2020-05-30","2020-11-29","6 months contract. Special offer renew price list and first 3 months 50% off. Storage rental paid by cash on May 30, 2020. Smartcard and padlock provided on May 30, 2020. ","2020-05-30","16",0,null,1557,"1557.00","2","2020-05-30 16:37:28","2","2020-05-30 16:37:28","CASH","","","","CASH","","","",null,0,"189, 63767","C201600","PERSONAL","Mr","OAUwavzXylc32qN4rF+DQg==","ddrfzAYTmkL\/QNu3psjONQ==","","0hsaMxhXKIjCiPQu5jDCffEfzGhbqvUpVm7WFyE3kI26lxe4g1tAt1h+VcH7ld5pmep7y3glibNPNwzXCA892A==","pgmrarALokoARsPc1os1iQ==",null,"2JxDzjbYdbaLm97VLn79zA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["7996","1597","1290.0","1290.00","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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-05-30","2020-11-29","1597"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-30 16:37:30","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":["7996","A16-D205441","PAID",2076,0,"2020-11-29","2020-05-30 16:37:28","2020-05-30 16:37:28","2","2020-05-30 16:37:28","2","2020-05-30 16:37:28",1600]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["7996",1600,"SETTLED","A16-I208325","2020-05-30 16:37:28","2020-05-30","2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u9810\u7e73\u79df\u91d1",4,1038,"MO","1",1038,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u9810\u7e73\u79df\u91d1",5,1038,"MO","1",1038,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["8325","RENT","\u9810\u7e73\u79df\u91d1",6,1038,"MO","1",1038,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4671,0,"8325"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-30 16:37:30","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":[1600,"CASH","","","","CASH","","","","PAID","P207969","2020-05-30 16:37:28",6747,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["7969","DEPOSIT","5441","PAID","2020-05-30 16:37:28",2076,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 16:37:30","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":["7969","INVOICE","8325","PAID","2020-05-30 16:37:28",4671,"2","2020-05-30 16:37:28","2","2020-05-30 16:37:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 17:13:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 18:43:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 18:43:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 18:55:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 18:59:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-30 23:52:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****