\r\n\t\t\t\t\tD40 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\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\tD41 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\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\tD51 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\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\tD52 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\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":"48","total_discounted_price":"2816.0","deposit":"0","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",162,"NEW","A12-CT196610",3992,2816,0,0,"3","3",8448,8448,8448,"2019-12-05 10:08:41","0",null,null,null,"2019-12-02","2020-03-01","3 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement A12-CT195919 to this agreement.\r\n","2019-12-02","48",0,null,0,"0","2","2019-12-05 10:08:41","2","2019-12-05 10:08:41","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,61655","C160162","PERSONAL","Ms","YifzXbU+Tso7u3G8dA0+\/w==","FCR6QC\/fbGlFc4Ue7KSDKg==","","VxDGIaW+Tts\/erSvg688Tr+jQOK8Je5hLPxu+us+Qxu4955Sr5Puz6KJkTsgb8iZizqSsm6TSqzvoBnuHlGc7Q==","a1\/cqdabRUt6Xwh\/BNn3OQ==","aWrneRBtbnsS6HlNbgn\/IZYPtB7OX4ILDIHW4OhCN6o=","Mol5xcxQm0WH1w+rd6sRsQ==",null,1,"4669"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","469","6","248","%","4.91",49.0018,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","469","6","247","%","4.91",49.0018,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","469","6","237","%","4.91",49.0018,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","469","6","236","%","4.91",49.0018,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","236","998.0",949,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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-02","2020-03-01","236"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","237","998.0",949,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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-02","2020-03-01","237"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","247","998.0",949,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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-02","2020-03-01","247"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610","248","998.0",949,"2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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-02","2020-03-01","248"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 10:08:41","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":["6610",162,"SETTLED","A12-I196938","2019-12-05 10:08:41","2019-12-02","2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6938","RENT","\u9810\u7e73\u79df\u91d1",1,2816,"MO","1",2816,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6938","RENT","\u9810\u7e73\u79df\u91d1",2,2816,"MO","1",2816,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6938","RENT","\u9810\u7e73\u79df\u91d1",3,2816,"MO","1",2816,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8448,0,"6938"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 10:08:41","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":[162,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196588","2019-12-05 10:08:41",8448,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6588","DEPOSIT",null,"PAID","2019-12-05 10:08:41",0,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:08:41","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":["6588","INVOICE","6938","PAID","2019-12-05 10:08:41",8448,"2","2019-12-05 10:08:41","2","2019-12-05 10:08:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 10:18:13","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":["NEW","055,61655","3 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement A12-CT195919 to this agreement.\r\n","2019-12-05 10:18:13","2","FCR6QC\/fbGlFc4Ue7KSDKg==","YifzXbU+Tso7u3G8dA0+\/w==","aWrneRBtbnsS6HlNbgn\/IZYPtB7OX4ILDIHW4OhCN6o=","a1\/cqdabRUt6Xwh\/BNn3OQ==","BKhzOsYr8uo8yQkA7\/t4jVkZu8nBEPivsIPnsyqXw6uUcDOOGOa0SBJXkSub\/OTnMCFZPgGQObwG8nzIVStdTxIL8EdNZ9zfvqRTuN4XzL4=",6610]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 11:50:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 11:51:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1097,"customer_code":"C181097","identity_type":"PERSONAL","identity_id":"K230699(9)","title":"Mr","lastname":"LOO","firstname":"Pui Kwan","companyname":"","email":null,"tel":"92290973","address":"Flat 2311, 23\/F HIGH BLOCK, LEI MOON HOUSE, AP LEI CHAU ESTATE","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-06","renew_room_key":"189,17513","renew_remark":"12 months contract, storage rental and deposit paid by Cash on Nov 16,2018; Smart Card provided on Nov 16, 2018\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183629, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2456.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"532","room_code":"L10","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-06-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on Dec 05,2019. Deposit $2456 transferred from agreement A14-CT183629 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6636,"final_order_total":6636,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,17513","order_product":[],"pass":true}},"first_order_id":3629,"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\tL10 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","roughly_size":"16","total_discounted_price":"1106","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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",1097,"NEW","A14-CT196611",1098,1106,0,0,"6","6",6636,6636,6636,"2019-12-05 12:03:49","0",null,null,null,"2019-12-06","2020-06-05","6 months contract. Storage rental paid by cash on Dec 05,2019. Deposit $2456 transferred from agreement A14-CT183629 to this agreement.","2019-12-06","16",0,null,0,"0","2","2019-12-05 12:03:48","2","2019-12-05 12:03:48","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189,17513","C181097","PERSONAL","Mr","WMZx5nTjG3dMmVCu8eWedQ==","uTPM9OmyggUE6uhHJ2aO1A==","","t49grVhR\/ph+uL6wFejhtgmnF5zcDlMnfxvubzH\/jCQ3VxqZ3m2lgv3ixWjPg\/WmViaGOpLKwAt2hP8T1qcXPQ==","u8gTNN2do4y5QrmNtiSijA==",null,"VifbjjZp3muxsew8JLSmXg==",null,1,3629]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6611","532","1098.0","1098.00","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-06-05","532"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 12:03:49","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":["6611",1097,"SETTLED","A14-I196939","2019-12-05 12:03:48","2019-12-06","2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",1,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",2,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6939","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6636,0,"6939"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 12:03:49","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":[1097,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196589","2019-12-05 12:03:48",6636,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6589","DEPOSIT",null,"PAID","2019-12-05 12:03:48",0,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:03:49","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":["6589","INVOICE","6939","PAID","2019-12-05 12:03:48",6636,"2","2019-12-05 12:03:48","2","2019-12-05 12:03:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 12:45:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 13:04:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 13:05:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 13:05:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 14:22:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:08:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":254,"customer_code":"C160254","identity_type":"PERSONAL","identity_id":"D278564(2)","title":"Ms","lastname":"Mok","firstname":"Chui Ling Grace","companyname":"","email":"gracemok2011@gmail.com","tel":"91207972","address":"23D,Tower 4,South Horizons,Ap Lei Chau,Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-21","renew_room_key":"055,06737","renew_remark":"6 months contract. Storage rental paid by EPS on May 21, 2019. Storage deposit transferred from agreement \tA12-CT194405 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195027, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"80","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1592.10","discount":"9.95","monthly_deduct":175.916,"room_id":"370","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"370","room_code":"G11","retail_price":"1768.0","discounted_price":1592.1,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-21","rent_from":"2019-11-21","rent_to":"2020-05-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement \tA12-CT195027 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":8148,"final_order_total":8148,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06737","order_product":[],"pass":true}},"first_order_id":"4405","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\tG11 4X6X8 $1768.00 N\/A <\/td> \u9810\u4ed86\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":"24","total_discounted_price":"1358.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",254,"NEW","A12-CT196612",1768,1358,0,0,"6","6",8148,8148,8148,"2019-12-05 15:36:32","0",null,null,null,"2019-11-21","2020-05-20","6 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement \tA12-CT195027 to this agreement.\r\n","2019-11-21","24",0,null,0,"0","2","2019-12-05 15:36:32","2","2019-12-05 15:36:32","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,06737","C160254","PERSONAL","Ms","E9yLbHbvUbaKvKbn2VOUrg==","ELGiy8l3QksCSVYDm2XBjg==","","VA+KhjDIaiSimAryPmW8lg6CikfhN+knH6xDLzQ9T7HlBEfHxsB6VsGzQhOoup\/rA+9oIFAIeedkQQnfWRA4oA==","BSgqDazfObIr2RH3Js3gUw==","gVOr3ZQ5k2Pr7Xy88sFPHIHXgZFX895640X4\/Lor25U=","M0T75rBnlqFfw0+9iFl60A==",null,1,"4405"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6612","80","11","370","%","9.95",175.916,"2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6612","370","1768.0",1592.1,"2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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-21","2020-05-20","370"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 15:36:32","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":["6612",254,"SETTLED","A12-I196940","2019-12-05 15:36:32","2019-11-21","2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6940","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8148,0,"6940"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 15:36:32","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":[254,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196590","2019-12-05 15:36:32",8148,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6590","DEPOSIT",null,"PAID","2019-12-05 15:36:32",0,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:36:32","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":["6590","INVOICE","6940","PAID","2019-12-05 15:36:32",8148,"2","2019-12-05 15:36:32","2","2019-12-05 15:36:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":254,"customer_code":"C160254","identity_type":"PERSONAL","identity_id":"D278564(2)","title":"Ms","lastname":"Mok","firstname":"Chui Ling Grace","companyname":"","email":"gracemok2011@gmail.com","tel":"91207972","address":"23D,Tower 4,South Horizons,Ap Lei Chau,Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1607.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-24","renew_room_key":"055,06737","renew_remark":"6 months contract. Storage rental paid by EPS on May 21, 2019. Storage deposit transferred from agreement A12-CT194406 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195026, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"340","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"351","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"351","room_code":"F36","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"340","room_code":"F25","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1607,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9642,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-24","rent_from":"2019-11-24","rent_to":"2020-05-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement A12-CT195026 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":9642,"final_order_total":9642,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06737","order_product":[],"pass":true}},"first_order_id":"4406","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\tF36 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\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\tF25 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\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":"28","total_discounted_price":"1607.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",254,"NEW","A12-CT196613",2096,1607,0,0,"6","6",9642,9642,9642,"2019-12-05 15:38:05","0",null,null,null,"2019-11-24","2020-05-23","6 months contract. Storage rental paid by EPS on Dec 5, 2019. Storage deposit transferred from agreement A12-CT195026 to this agreement.\r\n","2019-11-24","28",0,null,0,"0","2","2019-12-05 15:38:05","2","2019-12-05 15:38:05","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,06737","C160254","PERSONAL","Ms","E9yLbHbvUbaKvKbn2VOUrg==","ELGiy8l3QksCSVYDm2XBjg==","","VA+KhjDIaiSimAryPmW8lg6CikfhN+knH6xDLzQ9T7HlBEfHxsB6VsGzQhOoup\/rA+9oIFAIeedkQQnfWRA4oA==","BSgqDazfObIr2RH3Js3gUw==","gVOr3ZQ5k2Pr7Xy88sFPHIHXgZFX895640X4\/Lor25U=","M0T75rBnlqFfw0+9iFl60A==",null,1,"4406"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6613","70","6","340","%","9.96",99.4008,"2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6613","72","8","351","%","9.93",109.0314,"2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6613","351","1098.0",989,"2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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-24","2020-05-23","351"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 15:38:06","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":["6613","340","998.0",898.6,"2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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-24","2020-05-23","340"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 15:38:06","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":["6613",254,"SETTLED","A12-I196941","2019-12-05 15:38:05","2019-11-24","2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",1,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",2,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",3,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",4,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",5,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6941","RENT","\u9810\u7e73\u79df\u91d1",6,1607,"MO","1",1607,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9642,0,"6941"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 15:38:06","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":[254,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196591","2019-12-05 15:38:05",9642,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6591","DEPOSIT",null,"PAID","2019-12-05 15:38:05",0,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 15:38:06","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":["6591","INVOICE","6941","PAID","2019-12-05 15:38:05",9642,"2","2019-12-05 15:38:05","2","2019-12-05 15:38:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:18","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=932&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 5, 2019. Storage deposit $1322 transferred from agreement C15-CT196172 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196313, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2019-12-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 05, 2019. Storage deposit $1322 transferred from agreement C15-CT196313 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","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\tC15-115 4X6X6.5 $1322.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":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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","3","6",1185,"NEW","C15-CT196614",1322,1322,0,0,"1","1",1322,1322,1322,"2019-12-05 16:51:19","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Storage rental paid by bank transfer on Dec 05, 2019. Storage deposit $1322 transferred from agreement C15-CT196313 to this agreement.","2019-12-01","24",0,null,0,"0","2","2019-12-05 16:51:18","2","2019-12-05 16:51:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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":["6614","1421","1322.0","1322.00","2","2019-12-05 16:51:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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-01","2019-12-31","1421"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 16:51:19","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":["6614",1185,"SETTLED","C15-I196942","2019-12-05 16:51:18","2019-12-01","2","2019-12-05 16:51:18","2","2019-12-05 16:51:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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":["6942","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2019-12-05 16:51:18","2","2019-12-05 16:51:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"6942"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 16:51:19","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":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196592","2019-12-05 16:51:18",1322,"2","2019-12-05 16:51:18","2","2019-12-05 16:51:18","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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":["6592","DEPOSIT",null,"PAID","2019-12-05 16:51:18",0,"2","2019-12-05 16:51:18","2","2019-12-05 16:51:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:51:19","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":["6592","INVOICE","6942","PAID","2019-12-05 16:51:18",1322,"2","2019-12-05 16:51:18","2","2019-12-05 16:51:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:34","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=932&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1191,"customer_code":"C191191","identity_type":"PERSONAL","identity_id":"M738692(9)","title":"Mr","lastname":"MAI","firstname":"Bosco Khoi","companyname":"","email":"bosco.mai@gmail.com","tel":"67614440","address":"Block A, Flat 15, Wah Lee Building, Tsung Man St. Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"089,00345","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 2, 2019. Storage deposit transferred from agreement A12-CT196090 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196285, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"5","room_code":"A05","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1098,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2019-12-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 05, 2019. Storage deposit transferred from agreement A12-CT196285 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1098,"final_order_total":1098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"089,00345","order_product":[],"pass":true}},"first_order_id":"4686","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 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\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":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1191,"NEW","A12-CT196615",1098,1098,0,0,"1","1",1098,1098,1098,"2019-12-05 16:53:35","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Storage rental paid by bank transfer on Dec 05, 2019. Storage deposit transferred from agreement A12-CT196285 to this agreement.","2019-12-01","16",0,null,0,"0","2","2019-12-05 16:53:34","2","2019-12-05 16:53:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"089,00345","C191191","PERSONAL","Mr","0soiKCD7NjJcZw48G3GvfA==","MvdRz7N0iNyy9YO2DdpHMA==","","NcpK5OrfF8\/ElyhXm5yH2xQ9zY+h9560LUlyXGmaKZfQ1gIMmhqC+OiOd\/MDfL7LWoyplf\/sWugxqiR3ggITpg==","1y6MGBuYIscSst\/RcREtDQ==","xaZ\/yoblidF8zejY4KpifA94CHlEn27CqR\/97lOoGjk=","wcyFUD6Pm8bwB7ut4Ratqg==",null,1,"4686"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","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":["6615","5","1098.0","1098.00","2","2019-12-05 16:53:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","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-01","2019-12-31","5"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 16:53:35","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":["6615",1191,"SETTLED","A12-I196943","2019-12-05 16:53:34","2019-12-01","2","2019-12-05 16:53:34","2","2019-12-05 16:53:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","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":["6943","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2019-12-05 16:53:34","2","2019-12-05 16:53:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"6943"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 16:53:35","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":[1191,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196593","2019-12-05 16:53:34",1098,"2","2019-12-05 16:53:34","2","2019-12-05 16:53:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","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":["6593","DEPOSIT",null,"PAID","2019-12-05 16:53:34",0,"2","2019-12-05 16:53:34","2","2019-12-05 16:53:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 16:53:35","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":["6593","INVOICE","6943","PAID","2019-12-05 16:53:34",1098,"2","2019-12-05 16:53:34","2","2019-12-05 16:53:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 17:28:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":837,"customer_code":"C180837","identity_type":"PERSONAL","identity_id":"Z460933(7)","title":"Mr","lastname":"Lee","firstname":"Chi Kin","companyname":"","email":"thomas@armadainter.com","tel":"61230370","address":"No.4, 13\/F, Block A, ABBA House, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"775.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"092,18442","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 13, 2019. Storage deposit $1550 transferred from agreement A14-CT183402 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196385, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"644","room_code":"M55","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":775,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":775,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2019-12-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec,05, 2019. Storage deposit $1550 transferred from agreement A14-CT196385 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":775,"final_order_total":775,"location_id":"2","branch_id":"1","company_id":"1","room_key":"092,18442","order_product":[],"pass":true}},"first_order_id":"3402","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\tM55 3X3X8 $775.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":"9","total_discounted_price":"775.0","deposit":"0","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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",837,"NEW","A14-CT196616",775,775,0,0,"1","1",775,775,775,"2019-12-05 19:01:39","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Storage rental paid by bank transfer on Dec,05, 2019. Storage deposit $1550 transferred from agreement A14-CT196385 to this agreement.","2019-12-01","9",0,null,0,"0","2","2019-12-05 19:01:39","2","2019-12-05 19:01:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"092,18442","C180837","PERSONAL","Mr","7TEFsJJFNtsKtO69A+gKMQ==","kiriEIqhcx866RNZiMXdKQ==","","ssoRs4L4\/BzxHdCgmKhhf6mahamdoSABcmX9S7sgO8uszak3bwrrHXyfezWjFKNjkXrqOmPPRwq8vv+8j0xAHA==","8Goa5BQekEofVdJhf1L5Iw==","MFn257\/58IRcv6QiZHMPgHWlxdStZCT+sgRf\/7dpBto=","V+\/0ugFLwrebLPrp8zVesw==",null,1,"3402"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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":["6616","644","775.0","775.00","2","2019-12-05 19:01:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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-01","2019-12-31","644"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2019-12-05 19:01:39","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":["6616",837,"SETTLED","A14-I196944","2019-12-05 19:01:39","2019-12-01","2","2019-12-05 19:01:39","2","2019-12-05 19:01:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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":["6944","RENT","\u9810\u7e73\u79df\u91d1",1,775,"MO","1",775,"2","2019-12-05 19:01:39","2","2019-12-05 19:01:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[775,0,"6944"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2019-12-05 19:01:39","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":[837,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196594","2019-12-05 19:01:39",775,"2","2019-12-05 19:01:39","2","2019-12-05 19:01:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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":["6594","DEPOSIT",null,"PAID","2019-12-05 19:01:39",0,"2","2019-12-05 19:01:39","2","2019-12-05 19:01:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2019-12-05 19:01:39","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":["6594","INVOICE","6944","PAID","2019-12-05 19:01:39",775,"2","2019-12-05 19:01:39","2","2019-12-05 19:01:39"]},"data_before":[],"data_after":[],"step":1}
*****