\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>
H05 <\/td>\n\t\t\t\t\t	4X3X8 <\/td>\n\t\t\t\t\t	$998.00 <\/td>\n\t\t\t\t	- <\/td>	\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":"12","total_discounted_price":"919.20","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1","NEW","A12-CT200007",998,919.2,1996,0,"12","12",13026.4,13086.4,13086.4,"2020-08-03 12:51:48","0",null,null,null,"2020-08-03","2021-08-02","","2020-08-03","12",0,null,0,"0","1","2020-08-03 12:51:47","1","2020-08-03 12:51:47","CHEQUE","1","2","","CHEQUE","11","22","",null,0,"123","C190001","PERSONAL","Mr","R2CcUl2W3KeeuJDElw+rhQ==","xKWlp9g70GSlqj+oplNevg==","","qwlfuewjvDA0\/CwODTg06A==","yWnectsvmHIOhwvrZTufNA==","BhdWU5nkKaOUxIV9t4A\/AkuKmsLT+p3WWtLA2N6xIDQ=","f4hUQbUCY0VTDz0PbI0asw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["7","71 available_room_list_input","6","395","%","7.90",78.842,"1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["7","1","11","1","60.0",60,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7","395","998.0",919.2,"1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-03","2021-08-02","395"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["7","A12-D202838","PAID",1996,0,"2021-08-02","2020-08-03 12:51:47","2020-08-03 12:51:47","1","2020-08-03 12:51:47","1","2020-08-03 12:51:47","1"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7","1","SETTLED","A12-I200013","2020-08-03 12:51:47","2020-08-03","1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",1,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",2,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",3,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",4,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",5,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",6,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",7,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",8,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",9,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",10,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",11,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","RENT","\u9810\u7e73\u79df\u91d1",12,919.2,"MO","1",919.2,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["13","ORDER_PRODUCT","60.0","PCS","1",60,"11","1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11090.4,0,"13"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["1","CHEQUE","1","2","","CHEQUE","11","22","","PAID","P200004","2020-08-03 12:51:47",13086.4,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["4","DEPOSIT","2838","PAID","2020-08-03 12:51:47",1996,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 12:51:48","login_id":"1","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":["4","INVOICE","13","PAID","2020-08-03 12:51:47",11090.4,"1","2020-08-03 12:51:47","1","2020-08-03 12:51:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Y12345678","title":"Mr","lastname":"Demo","firstname":"Test","companyname":"","email":"nickcheung@onesolution.com.hk","tel":"12341234","address":"123","pass":true,"customer_id":"1","customer_code":"C190001","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"71 available_room_list_input","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"919.20","discount":"7.90","monthly_deduct":78.842,"room_id":"398","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"398","room_code":"H08","retail_price":"998.0","discounted_price":919.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":919.2,"deposit":1996,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13026.4,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-03","rent_from":"2020-08-03","rent_to":"2021-08-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":13086.4,"final_order_total":13086.4,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","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> H08 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \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":"12","total_discounted_price":"919.20","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1","NEW","A12-CT200008",998,919.2,1996,0,"12","12",13026.4,13086.4,13086.4,"2020-08-03 14:16:28","0",null,null,null,"2020-08-03","2021-08-02","","2020-08-03","12",0,null,0,"0","1","2020-08-03 14:16:28","1","2020-08-03 14:16:28","CASH","","","","CASH","","","",null,0,"","C190001","PERSONAL","Mr","R2CcUl2W3KeeuJDElw+rhQ==","xKWlp9g70GSlqj+oplNevg==","","qwlfuewjvDA0\/CwODTg06A==","yWnectsvmHIOhwvrZTufNA==","BhdWU5nkKaOUxIV9t4A\/AkuKmsLT+p3WWtLA2N6xIDQ=","f4hUQbUCY0VTDz0PbI0asw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["8","71 available_room_list_input","6","398","%","7.90",78.842,"1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["8","1","11","1","60.0",60,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8","398","998.0",919.2,"1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-03","2021-08-02","398"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["8","A12-D202839","PAID",1996,0,"2021-08-02","2020-08-03 14:16:28","2020-08-03 14:16:28","1","2020-08-03 14:16:28","1","2020-08-03 14:16:28","1"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8","1","SETTLED","A12-I200014","2020-08-03 14:16:28","2020-08-03","1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",1,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",2,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",3,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",4,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",5,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",6,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",7,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",8,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",9,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",10,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",11,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","RENT","\u9810\u7e73\u79df\u91d1",12,919.2,"MO","1",919.2,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["14","ORDER_PRODUCT","60.0","PCS","1",60,"11","1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11090.4,0,"14"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["1","CASH","","","","CASH","","","","PAID","P200005","2020-08-03 14:16:28",13086.4,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["5","DEPOSIT","2839","PAID","2020-08-03 14:16:28",1996,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:16:28","login_id":"1","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":["5","INVOICE","14","PAID","2020-08-03 14:16:28",11090.4,"1","2020-08-03 14:16:28","1","2020-08-03 14:16:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"skyadmin","cmsloginid":"1","loginid":"1","cmsrole":"super_admin","role":"super_admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Y12345678","title":"Mr","lastname":"Demo","firstname":"Test","companyname":"","email":"nickcheung@onesolution.com.hk","tel":"12341234","address":"123","pass":true,"customer_id":"1","customer_code":"C190001","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"71 available_room_list_input","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"919.20","discount":"7.90","monthly_deduct":78.842,"room_id":"406","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"406","room_code":"H16","retail_price":"998.0","discounted_price":919.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":919.2,"deposit":1996,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"total_order_product":60,"prepaid_month":"12","prepaid_amount":13086.4,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-03","rent_from":"2020-08-03","rent_to":"2021-08-02","delivery_service":"0","remark":"","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":13086.4,"final_order_total":13086.4,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","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> H16 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \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":"12","total_discounted_price":"919.20","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1","NEW","A12-CT200009",998,919.2,1996,0,"12","12",13086.4,13086.4,13086.4,"2020-08-03 14:18:35","0",null,null,null,"2020-08-03","2021-08-02","","2020-08-03","12",0,null,0,"0","1","2020-08-03 14:18:35","1","2020-08-03 14:18:35","CASH","","","","CASH","","","",null,0,"","C190001","PERSONAL","Mr","R2CcUl2W3KeeuJDElw+rhQ==","xKWlp9g70GSlqj+oplNevg==","","qwlfuewjvDA0\/CwODTg06A==","yWnectsvmHIOhwvrZTufNA==","BhdWU5nkKaOUxIV9t4A\/AkuKmsLT+p3WWtLA2N6xIDQ=","f4hUQbUCY0VTDz0PbI0asw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["9","71 available_room_list_input","6","406","%","7.90",78.842,"1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["9","1","11","1","60.0",60,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"9"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["9","406","998.0",919.2,"1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-03","2021-08-02","406"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["9","A12-D202840","PAID",1996,0,"2021-08-02","2020-08-03 14:18:35","2020-08-03 14:18:35","1","2020-08-03 14:18:35","1","2020-08-03 14:18:35","1"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["9","1","SETTLED","A12-I200015","2020-08-03 14:18:35","2020-08-03","1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",1,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",2,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",3,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",4,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",5,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",6,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",7,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",8,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",9,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",10,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",11,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","RENT","\u9810\u7e73\u79df\u91d1",12,919.2,"MO","1",919.2,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["15","ORDER_PRODUCT","60.0","PCS","1",60,"11","1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11090.4,0,"15"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["1","CASH","","","","CASH","","","","PAID","P200006","2020-08-03 14:18:35",13086.4,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["6","DEPOSIT","2840","PAID","2020-08-03 14:18:35",1996,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-03 14:18:35","login_id":"1","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":["6","INVOICE","15","PAID","2020-08-03 14:18:35",11090.4,"1","2020-08-03 14:18:35","1","2020-08-03 14:18:35"]},"data_before":[],"data_after":[],"step":1} *****