\r\n\t\t\t\t\tA05-071 4X3X7 $1090.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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",1103,"NEW","A05-CT196800",1090,981,0,0,"6","6",5886,5886,5886,"2019-12-30 11:08:40","0",null,null,null,"2019-11-17","2020-05-16","6 months contract. Storage rental paid by bank transfer on Dec 30,2019. Storage deposit $2180 transferred from agreement A05-CT183643 to this agreement.","2019-11-17","12",0,null,0,"0","2","2019-12-30 11:08:39","2","2019-12-30 11:08:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"12420775","C181103","PERSONAL","Mr","rmWpUwz501SsIjDtG3a\/uA==","yXKLXTtbNpECaRVTZxF\/Rw==","","bgQ3rHTQlnlWETsabtZaGitxR7Bx5zUMDKIu8NSQeXntXsTg8QVltc75Oe\/rxELE","v5odhu6gi\/jZbz5qGH26gg==","QwreDjC9DHEFhhUZTxfirfscdQE2HPZr0cZJlLU3A2g=","8FOX6xAprIl6Dd96Y2XL2w==",null,1,3643]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08:40","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":["6800","245","113","1073","%","10.00",109,"2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["6800","1073","1090.0",981,"2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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-11-17","2020-05-16","1073"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 11:08: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":["6800",1103,"SETTLED","A05-I197128","2019-12-30 11:08:39","2019-11-17","2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["7128","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7128"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 11:08: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":[1103,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196778","2019-12-30 11:08:39",5886,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["6778","DEPOSIT",null,"PAID","2019-12-30 11:08:39",0,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:08: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":["6778","INVOICE","7128","PAID","2019-12-30 11:08:39",5886,"2","2019-12-30 11:08:39","2","2019-12-30 11:08:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:51:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:52:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:53:14","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","053,60186","6 months contract. Storage rental paid by EPS on December 27, 2019. Storage deposit transferred from agreement A18-CT195318 to this agreement.\r\n","2019-12-30 11:53:14","2","DGNg\/pKHJ\/mTaSVRFTWCKw==","0NwLI\/8QHhL7VcLoftFR1Q==","jeu3hzXqUDKZ98DwfdDYTni84K0Esxx\/wrq\/fCqpj4s=","utyi9k+CT0DGTDCt0\/C\/CQ==","xEDEKUui0NEliiFxfwqAAfPPr+iKSiEJx8tIu6MpkeXHRYLfN2esb5n6s7\/w8YdWGSicP5xSheFZATRbtBhLnQ==",6789]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:54:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:58","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=655&filter3=undefined","floor_plan_rent_room":[{"room_id":"984","master_room_id":"91","room_code":"X09"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tX09 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D332597(1)","title":"Ms","lastname":"Mak","firstname":"Po Chu Ellen","companyname":"","email":"polungto2@netvigator.com","tel":"90700870","address":"Flat 1414, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true,"customer_id":"655","customer_code":"C170655","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"984","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"984","room_code":"X09","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-06-29","delivery_service":"0","remark":"6 months contract. Storage rental by EPS on Dec 27,2019. Storage deposit transferred from agreement A18-CT195318 to this agreement.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,60186","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3","655","NEW","A18-CT196801",1290,1162,0,0,"6","6",6972,6972,6972,"2019-12-30 11:56:59","0",null,null,null,"2019-12-30","2020-06-29","6 months contract. Storage rental by EPS on Dec 27,2019. Storage deposit transferred from agreement A18-CT195318 to this agreement.","2019-12-30","16",0,null,0,"0","2","2019-12-30 11:56:58","2","2019-12-30 11:56:58","EPS","","","","EPS","","","",null,0,"053,60186","C170655","PERSONAL","Ms","0NwLI\/8QHhL7VcLoftFR1Q==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","xEDEKUui0NEliiFxfwqAAfPPr+iKSiEJx8tIu6MpkeXHRYLfN2esb5n6s7\/w8YdWGSicP5xSheFZATRbtBhLnQ==","utyi9k+CT0DGTDCt0\/C\/CQ==","jeu3hzXqUDKZ98DwfdDYTni84K0Esxx\/wrq\/fCqpj4s=","i+Rgl1m46wHpwigjAPWLaQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["6801","250","91","984","%","10.00",129,"2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["6801","984","1290.0",1161,"2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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-30","2020-06-29","984"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 11:56:59","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":["6801","655","SETTLED","A18-I197129","2019-12-30 11:56:58","2019-12-30","2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["7129","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7129"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 11:56:59","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":["655","EPS","","","","EPS","","","","PAID","P196779","2019-12-30 11:56:58",6972,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["6779","DEPOSIT",null,"PAID","2019-12-30 11:56:58",0,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 11:56:59","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":["6779","INVOICE","7129","PAID","2019-12-30 11:56:58",6972,"2","2019-12-30 11:56:58","2","2019-12-30 11:56:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 12:27:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 12:32:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 12:35:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 12:44:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":"1","customer_id":982,"customer_code":"C180982","identity_type":"PERSONAL","identity_id":"V016050(4)","title":"Ms","lastname":"WONG","firstname":"Shui Hung","companyname":"","email":"fionashsia@yahoo.com","tel":"67066726","address":"Room 709, Pik Wai House, Shek Pei Wan Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"HSBC","renew_cheque_num2":"949439","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"13","renew_warehousing_date":"2020-12-12","renew_room_key":"0012403797","renew_remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on December 10, 2019. Storage deposit $1544 transferred from agreement A05-CT183446 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196658, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"126","order_discount":[],"order_room":[{"room_id":"738","room_code":"O14","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":2196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13476,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1577.00","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2021-01-31","delivery_service":"0","remark":"13 months contract. Special offer 13th month free and 5% \"Rent Now\" Discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1577,"order_total":15053,"final_order_total":13476,"location_id":"2","branch_id":"1","company_id":"1","room_key":"'0012492289, 190, 40449","order_product":[],"pass":true}},"first_order_id":"3446","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tO14 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"738","master_room_id":"35","room_code":"O14"}],"roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","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":["C191479","PERSONAL","Ms","5zcqrlnTNiSeD+tLA2xwAA==","ddrfzAYTmkL\/QNu3psjONQ==","","W9KIelU\/AwBhB\/M7YqzwOg==","xKthqwMKFExvflFdBtGMIVpiORd1L7fhsTt7yLUwJjQ=","N\/P+WhNW9ONoN2IquDEGCooiFG3dhrRFYyBjsDuzAdEGmkupbdt\/UVJ+5ZKI29pTZoFwmTXz\/7t7kkZAi4tVpF9T6IBNFjmzd+ItD68UI0s=","0x+0I0Jb03fAm73uoYpu9g==",null,"xKthqwMKFExvflFdBtGMIVpiORd1L7fhsTt7yLUwJjQ=","IMd5R\/VAEv1kAdvGmz5HkQ==","2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1479,"NEW","A14-CT196802",1098,989,2196,0,"13","13",13476,15053,13476,"2019-12-30 13:33:50","0",null,null,null,"2020-01-01","2021-01-31","13 months contract. Special offer 13th month free and 5% \"Rent Now\" Discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. ","2020-01-01","16",0,null,1577,"1577.00","2","2019-12-30 13:33:49","2","2019-12-30 13:33:49","EPS","","","","EPS","","","",null,0,"'0012492289, 190, 40449","C191479","PERSONAL","Ms","5zcqrlnTNiSeD+tLA2xwAA==","ddrfzAYTmkL\/QNu3psjONQ==","","N\/P+WhNW9ONoN2IquDEGCooiFG3dhrRFYyBjsDuzAdEGmkupbdt\/UVJ+5ZKI29pTZoFwmTXz\/7t7kkZAi4tVpF9T6IBNFjmzd+ItD68UI0s=","W9KIelU\/AwBhB\/M7YqzwOg==","xKthqwMKFExvflFdBtGMIVpiORd1L7fhsTt7yLUwJjQ=","0x+0I0Jb03fAm73uoYpu9g==",null,1,"3446"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6802","738","1098.0","1098.00","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2021-01-31","738"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 13:33:50","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":["6802","A14-D195232","PAID",2196,0,"2021-01-31","2019-12-30 13:33:49","2019-12-30 13:33:49","2","2019-12-30 13:33:49","2","2019-12-30 13:33:49",1479]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6802",1479,"SETTLED","A14-I197130","2019-12-30 13:33:49","2020-01-01","2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,401,"MO","1",401,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11280,0,"7130"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1479,"EPS","","","","EPS","","","","PAID","P196780","2019-12-30 13:33:49",13476,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6780","DEPOSIT","5232","PAID","2019-12-30 13:33:49",2196,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 13:33:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6780","INVOICE","7130","PAID","2019-12-30 13:33:49",11280,"2","2019-12-30 13:33:49","2","2019-12-30 13:33:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:16","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=1222&filter3=undefined","floor_plan_rent_room":[{"room_id":"984","master_room_id":"91","room_code":"X09"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":647,"customer_code":"C170647","identity_type":"PERSONAL","identity_id":"D327863(9)","title":"Mr","lastname":"Yiu","firstname":"King Hang ","companyname":"","email":"tonykhyiu@i-cable.com","tel":"96209102","address":"Flat 1, 25\/f, Ngan On House, Yue On Court, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-01","renew_room_key":"053,39842","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 30, 2019. Storage deposit transferred from agreement A18-CT194039 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195355, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"975","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"975","room_code":"W20","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-06-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT195355 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,39842","order_product":[],"pass":true}},"first_order_id":"4039","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tW20 4X5X7 $1605.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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",647,"NEW","A18-CT196803",1605,1445,0,0,"6","6",8670,8670,8670,"2019-12-30 14:09:17","0",null,null,null,"2020-01-01","2020-06-30","6 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT195355 to this agreement.","2020-01-01","20",0,null,0,"0","2","2019-12-30 14:09:16","2","2019-12-30 14:09:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,39842","C170647","PERSONAL","Mr","6qA50jnnvqzzU9rA8ad9Eg==","izJVo3RcQVJ02PBMypGKnQ==","","E1F7\/N\/w4HTkeV+XNpwX\/PTp9puGQVhCZvZ9Z8KrdOTs9IVcXjJPq6IgyWLuHev8","yjsUam6Kc6HoAmxK8aBR5w==","PlH1zU7FqAQzI3K0Uv78IJupc9ttgHGNzSJaIH+r\/PA=","BlXQq0pDW5o0+DtLM4Bc\/Q==",null,1,"4039"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["6803","254","78","975","%","10.00",160.5,"2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["6803","975","1605.0",1444.5,"2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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","2020-06-30","975"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 14:09:17","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":["6803",647,"SETTLED","A18-I197131","2019-12-30 14:09:16","2020-01-01","2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["7131","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"7131"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 14:09:17","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":[647,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196781","2019-12-30 14:09:16",8670,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["6781","DEPOSIT",null,"PAID","2019-12-30 14:09:16",0,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:09:17","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":["6781","INVOICE","7131","PAID","2019-12-30 14:09:16",8670,"2","2019-12-30 14:09:16","2","2019-12-30 14:09:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:26:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:40:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 14:56:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 15:45:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"845","master_room_id":"81","room_code":"S04"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tS04 5X6X7 $2298.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"K310924(0)","title":"Ms","lastname":"U","firstname":"Ingrid","companyname":"","email":"ingridu99@ymail.com","tel":"92522288","address":"Room H, 15\/F, Tower 13A, South Horizons, ApLeiChau, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"845","room_code":"S04","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2068,"deposit":4596,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":28176,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3304.00","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2021-01-31","delivery_service":"0","remark":"13 months contact. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by post-dated Cheque on December 30, 2019. Smartcard and padlock are provided on December 30, 2019.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3304,"order_total":31480,"final_order_total":28176,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,52007","order_product":[],"pass":true}},"roughly_size":"30","total_discounted_price":"2068.00","deposit":"4596.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","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":["C191480","PERSONAL","Ms","BGpbrIr\/0bC4MDkMkbJGBw==","MAgIpqopWf7gxtkbo5\/joA==","","crFASaXkSU8yh+D8bnCqwA==","iDy\/FnUbQNFtDw\/+sIYa0bydSKCfed3GUDHOLRv23Nc=","G9tcjP0pznXAV6ZKriWLVluRuZcsTaqjVRPvGRlxhoOov0SvvDv5EIHYuW43csyLiGtbkr8doAvBKrgT30i7Ew==","OA3Wg83EzrC9+tiBssShOg==",null,"iDy\/FnUbQNFtDw\/+sIYa0bydSKCfed3GUDHOLRv23Nc=","OWMAPMT3v91NxzhcTBy\/1Q==","2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","3",1480,"NEW","A18-CT196804",2298,2068,4596,0,"13","13",28176,31480,28176,"2019-12-30 16:04:48","0",null,null,null,"2020-01-01","2021-01-31","13 months contact. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by post-dated Cheque on December 30, 2019. Smartcard and padlock are provided on December 30, 2019.","2020-01-01","30",0,null,3304,"3304.00","2","2019-12-30 16:04:46","2","2019-12-30 16:04:46","CHEQUE","","","","CHEQUE","","","",null,0,"189,52007","C191480","PERSONAL","Ms","BGpbrIr\/0bC4MDkMkbJGBw==","MAgIpqopWf7gxtkbo5\/joA==","","G9tcjP0pznXAV6ZKriWLVluRuZcsTaqjVRPvGRlxhoOov0SvvDv5EIHYuW43csyLiGtbkr8doAvBKrgT30i7Ew==","crFASaXkSU8yh+D8bnCqwA==","iDy\/FnUbQNFtDw\/+sIYa0bydSKCfed3GUDHOLRv23Nc=","OA3Wg83EzrC9+tiBssShOg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6804","845","2298.0","2298.00","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2021-01-31","845"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6804","A18-D195233","PAID",4596,0,"2021-01-31","2019-12-30 16:04:46","2019-12-30 16:04:46","2","2019-12-30 16:04:46","2","2019-12-30 16:04:46",1480]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6804",1480,"SETTLED","A18-I197132","2019-12-30 16:04:46","2020-01-01","2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,832,"MO","1",832,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",3,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",4,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",5,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",6,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",7,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",8,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",9,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",10,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",11,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",12,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7132","RENT","\u9810\u7e73\u79df\u91d1",13,2068,"MO","1",2068,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23580,0,"7132"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1480,"CHEQUE","","","","CHEQUE","","","","PAID","P196782","2019-12-30 16:04:46",28176,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6782","DEPOSIT","5233","PAID","2019-12-30 16:04:46",4596,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:04:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6782","INVOICE","7132","PAID","2019-12-30 16:04:46",23580,"2","2019-12-30 16:04:46","2","2019-12-30 16:04:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"845","master_room_id":"81","room_code":"S04"}],"index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1159,"customer_code":"C181159","identity_type":"BUSINESS","identity_id":"6515779300008153","title":"Mr","lastname":"LO","firstname":"Kwok Hung","companyname":"Good Servant Family Ministry Limited","email":"info@gsfml.org","tel":"92718964","address":"16\/f, Rm2, Kwun King Court, Aberdeen Ctr, Aberdeen","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1269.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-01","renew_room_key":"12491541","renew_remark":"12 months contract, storage rental and deposit paid by Cheque on Dec 24, 2018. Smart Card and padlock provided on Dec 24,2018\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183982, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2820.0","renew_master_room_id":"115","order_discount":[],"order_room":[{"room_id":"1160","room_code":"A05-158(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":"1410.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1269,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":15228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-12-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":15228,"final_order_total":15228,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12491541","order_product":[],"pass":true}},"first_order_id":3982,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA05-158(\u670d\u88dd\u5009) 4X4X7 $1410.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1269.0","deposit":"0","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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",1159,"NEW","A05-CT196805",1410,1269,0,0,"12","12",15228,15228,15228,"2019-12-30 16:22:20","0",null,null,null,"2020-01-01","2020-12-31","12 months contract. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","2020-01-01","16",0,null,0,"0","2","2019-12-30 16:22:20","2","2019-12-30 16:22:20","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"12491541","C181159","BUSINESS","Mr","DoW4hDPdUAaMpZ9A8BCrvg==","DyZn7f2tPwMiXMp09gXvdg==","Good Servant Family Ministry Limited","\/7uLopuvJpB0ID7ZlzSM23ThPaysPgmglXYxp5sEf9xEfDpTPB1n1aXHioQWY\/u53324Ttgx0kKRo41u0rW7bQ==","xmIGqnVLd42SrsnVtLS66g==","TF2nylR560R\/C5xpa4S4Bw==",null,"7\/3pdNtoMUDnkvDghShMil\/Ecpg894mo\/WmbmEY0vWQ=",1,3982]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["6805","1160","1410.0","1410.00","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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","2020-12-31","1160"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 16:22:20","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":["6805",1159,"SETTLED","A05-I197133","2019-12-30 16:22:20","2020-01-01","2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",1,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",2,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",7,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",8,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",9,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",10,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",11,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["7133","RENT","\u9810\u7e73\u79df\u91d1",12,1269,"MO","1",1269,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15228,0,"7133"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 16:22:20","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":[1159,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196783","2019-12-30 16:22:20",15228,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["6783","DEPOSIT",null,"PAID","2019-12-30 16:22:20",0,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:22:20","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":["6783","INVOICE","7133","PAID","2019-12-30 16:22:20",15228,"2","2019-12-30 16:22:20","2","2019-12-30 16:22:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:26:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:26:41","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","12491541","12 months contract. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","2019-12-30 16:26:41","2","DyZn7f2tPwMiXMp09gXvdg==","DoW4hDPdUAaMpZ9A8BCrvg==","TF2nylR560R\/C5xpa4S4Bw==","xmIGqnVLd42SrsnVtLS66g==","\/7uLopuvJpB0ID7ZlzSM23ThPaysPgmglXYxp5sEf9xEfDpTPB1n1aXHioQWY\/u53324Ttgx0kKRo41u0rW7bQ==","Good Servant Family Ministry Limited",6805]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"6515779300008153","title":"Mr","lastname":"LO","firstname":"Kwok Hung","companyname":"Good Servant Family Ministry Limited","email":"info@gsfml.org","tel":"92718964","address":"16\/f, Rm2, Kwun King Court, Aberdeen Ctr, Aberdeen","pass":true,"customer_id":"1159","customer_code":"C181159","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1160","room_code":"A05-158","retail_price":"1410.0","discounted_price":"1410.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1269,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":15228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1269.00","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-01-29","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1269,"order_total":16497,"final_order_total":15228,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12491541","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tA05-158 4X4X7 $1410.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1269.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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","4","1159","NEW","A05-CT196806",1410,1269,0,0,"13","13",15228,16497,15228,"2019-12-30 16:29:26","0",null,null,null,"2019-12-30","2020-01-29","13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","2019-12-30","16",0,null,1269,"1269.00","2","2019-12-30 16:29:25","2","2019-12-30 16:29:25","CHEQUE","","","","CHEQUE","","","",null,0,"12491541","C181159","BUSINESS","Mr","DoW4hDPdUAaMpZ9A8BCrvg==","DyZn7f2tPwMiXMp09gXvdg==","Good Servant Family Ministry Limited","\/7uLopuvJpB0ID7ZlzSM23ThPaysPgmglXYxp5sEf9xEfDpTPB1n1aXHioQWY\/u53324Ttgx0kKRo41u0rW7bQ==","xmIGqnVLd42SrsnVtLS66g==","TF2nylR560R\/C5xpa4S4Bw==",null,"7\/3pdNtoMUDnkvDghShMil\/Ecpg894mo\/WmbmEY0vWQ="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["6806","1160","1410.0","1410.00","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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-30","2020-01-29","1160"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 16:29:26","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":["6806","1159","SETTLED","A05-I197134","2019-12-30 16:29:25","2019-12-30","2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",7,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",8,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",9,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",10,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",11,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",12,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["7134","RENT","\u9810\u7e73\u79df\u91d1",13,1269,"MO","1",1269,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15228,0,"7134"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 16:29:26","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":["1159","CHEQUE","","","","CHEQUE","","","","PAID","P196784","2019-12-30 16:29:25",15228,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["6784","DEPOSIT",null,"PAID","2019-12-30 16:29:25",0,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 16:29:26","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":["6784","INVOICE","7134","PAID","2019-12-30 16:29:25",15228,"2","2019-12-30 16:29:25","2","2019-12-30 16:29:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:07:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:22:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:22:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:53:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:53:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:54:06","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","12491541","13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","2019-12-30 17:54:06","2","DyZn7f2tPwMiXMp09gXvdg==","DoW4hDPdUAaMpZ9A8BCrvg==","TF2nylR560R\/C5xpa4S4Bw==","xmIGqnVLd42SrsnVtLS66g==","\/7uLopuvJpB0ID7ZlzSM23ThPaysPgmglXYxp5sEf9xEfDpTPB1n1aXHioQWY\/u53324Ttgx0kKRo41u0rW7bQ==","Good Servant Family Ministry Limited",6806]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:55:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"6515779300008153","title":"Mr","lastname":"LO","firstname":"Kwok Hung","companyname":"Good Servant Family Ministry Limited","email":"info@gsfml.org","tel":"92718964","address":"16\/f, Rm2, Kwun King Court, Aberdeen Ctr, Aberdeen","pass":true,"customer_id":"1159","customer_code":"C181159","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1160","room_code":"A05-158","retail_price":"1410.0","discounted_price":"1410.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1269,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":15228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1269.00","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2021-01-31","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1269,"order_total":16497,"final_order_total":15228,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12491541","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tA05-158 4X4X7 $1410.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1269.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","1159","NEW","A05-CT196807",1410,1269,0,0,"13","13",15228,16497,15228,"2019-12-30 17:57:56","0",null,null,null,"2020-01-01","2021-01-31","13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Dec 30,2019. Deposit $2820 transferred from agreement A05-CT183982 to this agreement.","2020-01-01","16",0,null,1269,"1269.00","2","2019-12-30 17:57:55","2","2019-12-30 17:57:55","CHEQUE","","","","CHEQUE","","","",null,0,"12491541","C181159","BUSINESS","Mr","DoW4hDPdUAaMpZ9A8BCrvg==","DyZn7f2tPwMiXMp09gXvdg==","Good Servant Family Ministry Limited","\/7uLopuvJpB0ID7ZlzSM23ThPaysPgmglXYxp5sEf9xEfDpTPB1n1aXHioQWY\/u53324Ttgx0kKRo41u0rW7bQ==","xmIGqnVLd42SrsnVtLS66g==","TF2nylR560R\/C5xpa4S4Bw==",null,"7\/3pdNtoMUDnkvDghShMil\/Ecpg894mo\/WmbmEY0vWQ="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6807","1160","1410.0","1410.00","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2021-01-31","1160"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6807","1159","SETTLED","A05-I197135","2019-12-30 17:57:55","2020-01-01","2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",7,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",8,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",9,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",10,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",11,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",12,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7135","RENT","\u9810\u7e73\u79df\u91d1",13,1269,"MO","1",1269,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15228,0,"7135"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1159","CHEQUE","","","","CHEQUE","","","","PAID","P196785","2019-12-30 17:57:55",15228,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6785","DEPOSIT",null,"PAID","2019-12-30 17:57:55",0,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:57:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6785","INVOICE","7135","PAID","2019-12-30 17:57:55",15228,"2","2019-12-30 17:57:55","2","2019-12-30 17:57:55"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1753","master_room_id":"232","room_code":"WC-16"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tWC-16 2.5X2.5X4 $798.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"K332829(5)","title":"Ms","lastname":"POON","firstname":"Wai Fong","companyname":"","email":"vanessalamwy@hotmail.com","tel":"67126261","address":"Room 5, 15\/F, Kong Cheung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1753","room_code":"WC-16","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":798,"deposit":1596,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"798.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-03-05","delivery_service":"0","remark":"2 months contract. Special offer 1 month free. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and password lock provided on December 30, 2019.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":798,"order_total":3192,"final_order_total":2394,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190, 39700","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"798.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58:29","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":["C191481","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","nQ0P3urF7MQlYHXgjzt5kA==","","F22NhsX0kJs0Lq\/6E61WEQ==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","yxS3w8ydgZH0MWUcw0HMqoJCtRPPlhXlEKRtNR7F1r1PLmJ4\/ebuwJvX17ubYKoICaFjR99rfrmzd8DDq47z0kNveYzH4BEwVPzFM7tlzEw=","5geghcdcQB0F29vF5+CGiA==",null,"w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","wks+B2y6cvSU\/Tc6w2gl1A==","2","2019-12-30 17:58:27","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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","8",1481,"NEW","WC-CT196808",798,798,1596,0,"2","2",2394,3192,2394,"2019-12-30 17:58:30","0",null,null,null,"2020-01-06","2020-03-05","2 months contract. Special offer 1 month free. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and password lock provided on December 30, 2019.","2020-01-06","6.25",0,null,798,"798.00","2","2019-12-30 17:58:27","2","2019-12-30 17:58:27","EPS","","","","EPS","","","",null,0,"190, 39700","C191481","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","nQ0P3urF7MQlYHXgjzt5kA==","","yxS3w8ydgZH0MWUcw0HMqoJCtRPPlhXlEKRtNR7F1r1PLmJ4\/ebuwJvX17ubYKoICaFjR99rfrmzd8DDq47z0kNveYzH4BEwVPzFM7tlzEw=","F22NhsX0kJs0Lq\/6E61WEQ==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","5geghcdcQB0F29vF5+CGiA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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":["6808","1753","798.0","798.00","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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-01-06","2020-03-05","1753"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 17:58: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":["6808","WC-D195234","PAID",1596,0,"2020-03-05","2019-12-30 17:58:27","2019-12-30 17:58:27","2","2019-12-30 17:58:27","2","2019-12-30 17:58:27",1481]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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":["6808",1481,"SETTLED","WC-I197136","2019-12-30 17:58:27","2020-01-06","2","2019-12-30 17:58:27","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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":["7136","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,798,"MO","1",798,"2","2019-12-30 17:58:27","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[798,0,"7136"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 17:58: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":[1481,"EPS","","","","EPS","","","","PAID","P196786","2019-12-30 17:58:27",2394,"2","2019-12-30 17:58:27","2","2019-12-30 17:58:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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":["6786","DEPOSIT","5234","PAID","2019-12-30 17:58:27",1596,"2","2019-12-30 17:58:27","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 17:58: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":["6786","INVOICE","7136","PAID","2019-12-30 17:58:27",798,"2","2019-12-30 17:58:27","2","2019-12-30 17:58:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tK10(\u670d\u88dd\u5009) 4X4X8 $1342.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K332829(5)","title":"Ms","lastname":"POON","firstname":"Wai Fong","companyname":"","email":"vanessalamwy@hotmail.com","tel":"67126261","address":"Room 5, 15\/F, Kong Cheung Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_id":"1481","customer_code":"C191481","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"473","room_code":"K10(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":2684,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":16460,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1928.00","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2021-02-05","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1928,"order_total":18388,"final_order_total":16460,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,28747","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1208.00","deposit":"2684.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1481","NEW","A14-CT196809",1342,1208,2684,0,"13","13",16460,18388,16460,"2019-12-30 18:04:14","0",null,null,null,"2020-01-06","2021-02-05","13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. ","2020-01-06","16",0,null,1928,"1928.00","2","2019-12-30 18:04:14","2","2019-12-30 18:04:14","EPS","","","","EPS","","","",null,0,"189,28747","C191481","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","nQ0P3urF7MQlYHXgjzt5kA==","","yxS3w8ydgZH0MWUcw0HMqoJCtRPPlhXlEKRtNR7F1r1PLmJ4\/ebuwJvX17ubYKoICaFjR99rfrmzd8DDq47z0kNveYzH4BEwVPzFM7tlzEw=","F22NhsX0kJs0Lq\/6E61WEQ==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","5geghcdcQB0F29vF5+CGiA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6809","473","1342.0","1342.00","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2021-02-05","473"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6809","A14-D195235","PAID",2684,0,"2021-02-05","2019-12-30 18:04:14","2019-12-30 18:04:14","2","2019-12-30 18:04:14","2","2019-12-30 18:04:14","1481"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6809","1481","SETTLED","A14-I197137","2019-12-30 18:04:14","2020-01-06","2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,488,"MO","1",488,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",3,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",4,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",7,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",8,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",9,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",10,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",11,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",12,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7137","RENT","\u9810\u7e73\u79df\u91d1",13,1208,"MO","1",1208,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13776,0,"7137"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1481","EPS","","","","EPS","","","","PAID","P196787","2019-12-30 18:04:14",16460,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6787","DEPOSIT","5235","PAID","2019-12-30 18:04:14",2684,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:04:14","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6787","INVOICE","7137","PAID","2019-12-30 18:04:14",13776,"2","2019-12-30 18:04:14","2","2019-12-30 18:04:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:18:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:45:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 18:52:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-30 19:17:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****