\r\n\t\t\t\t\tP21 3.5X6X8 $1368.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","roughly_size":"92","total_discounted_price":"8304.0","deposit":"0","total_retail_price":"6154.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","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",1470,"NEW","A14-CT207902",6154,8304,0,0,"1","1",8304,8304,8304,"2020-05-20 11:19:23","0",null,null,null,"2020-05-13","2020-06-12","1 month contract. Storage rental will pay by cheque on May 20, 2020. Storage deposit $16608 transferred from agreement A14-CT207819 to this agreement. \r\n","2020-05-13","92",0,null,0,"0","2","2020-05-20 11:19:23","2","2020-05-20 11:19:23","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg==",1,7819]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","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":["7902","769","2188.0","2188.00","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-13","2020-06-12","769"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 11:19:23","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":["7902","778","2598.0","2598.00","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-13","2020-06-12","778"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 11:19:23","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":["7902","787","1368.0","1368.00","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-13","2020-06-12","787"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 11:19:23","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":["7902",1470,"SETTLED","A14-I208231","2020-05-20 11:19:23","2020-05-13","2","2020-05-20 11:19:23","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","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":["8231","RENT","\u9810\u7e73\u79df\u91d1",1,8304,"MO","1",8304,"2","2020-05-20 11:19:23","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8304,0,"8231"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 11:19:23","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":[1470,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207875","2020-05-20 11:19:23",8304,"2","2020-05-20 11:19:23","2","2020-05-20 11:19:23","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","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":["7875","DEPOSIT",null,"PAID","2020-05-20 11:19:23",0,"2","2020-05-20 11:19:23","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:19:23","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":["7875","INVOICE","8231","PAID","2020-05-20 11:19:23",8304,"2","2020-05-20 11:19:23","2","2020-05-20 11:19:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27: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=1470&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1244,"customer_code":"C191244","identity_type":"PERSONAL","identity_id":"E928641(5)","title":"Ms","lastname":"Rita","firstname":"Li","companyname":"","email":"lirita826@gmail.com","tel":"90193638","address":"Flat E, 33\/F, Block 22, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-26","renew_room_key":"111,41132","renew_remark":"1 month contract. Storage rental paid by cheque on April 15, 2020. Storage deposit $3056 transferred from agreement A12-CT207412 to this agreement.\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\tB32 4X5X8 $1528.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":"20","total_discounted_price":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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",1244,"NEW","A12-CT207903",1528,1528,0,0,"1","1",1528,1528,1528,"2020-05-20 11:27:34","0",null,null,null,"2020-04-26","2020-05-25","1 month contract. Storage rental paid by cheque on May 20, 2020. Storage deposit $3056 transferred from agreement A12-CT207629 to this agreement.\r\n\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207629, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2020-04-26","20",0,null,0,"0","2","2020-05-20 11:27:34","2","2020-05-20 11:27:34","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"111,41132","C191244","PERSONAL","Ms","7KCehmxbvwRMb+U8lHGoVA==","7pARLQpir8xN2i5gKtcUnA==","","Z5GlDhUn5j6Sl5tJu4OT2EJuraXC1l\/yNyJxswCPcFbWgMA1SHnsiuFyuKEqEVBuce98fM9hJIlGzBlrWRE\/Fw==","Mvs6ipJlHIfY+haMHCbc+A==","YnPhq\/0aL9f7zvnjRGMxCi9keRR0Q4\/DU5\/EdDPbYVA=","VyUMJBG3pFTIcqzAH4T+\/w==",null,1,"4814"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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":["7903","84","1528.0","1528.00","2","2020-05-20 11:27:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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-04-26","2020-05-25","84"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 11:27:34","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":["7903",1244,"SETTLED","A12-I208232","2020-05-20 11:27:34","2020-04-26","2","2020-05-20 11:27:34","2","2020-05-20 11:27:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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":["8232","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-05-20 11:27:34","2","2020-05-20 11:27:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"8232"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 11:27:34","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":[1244,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207876","2020-05-20 11:27:34",1528,"2","2020-05-20 11:27:34","2","2020-05-20 11:27:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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":["7876","DEPOSIT",null,"PAID","2020-05-20 11:27:34",0,"2","2020-05-20 11:27:34","2","2020-05-20 11:27:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:27:34","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":["7876","INVOICE","8232","PAID","2020-05-20 11:27:34",1528,"2","2020-05-20 11:27:34","2","2020-05-20 11:27:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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=1470&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1564,"customer_code":"C201564","identity_type":"PERSONAL","identity_id":"D231595(6)","title":"Ms","lastname":"LIU","firstname":"Pui Yee","companyname":"","email":"tammgliu888@yahoo.com","tel":"94016895","address":"Flat 914, Wah Kin House, Wah Fu Est, Pok Fu Lam, South District.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-20","renew_room_key":"190,26664","renew_remark":"1 month contract. Storage rental and deposit paid by cash on Apr 18,2020. Smart card and padlock provided on the same day.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207668, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2572.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2020-06-19","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on May 20, 2020. Storage deposit $2572 transferred from agreement A12-CT207668 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26664","order_product":[],"pass":true}},"first_order_id":7668,"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\tB09 4X5X8 $1528.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":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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",1564,"NEW","A12-CT207904",1528,1286,0,0,"1","1",1286,1286,1286,"2020-05-20 11:35:03","0",null,null,null,"2020-05-20","2020-06-19","1 month contract. Storage rental and deposit paid by bank transfer on May 20, 2020. Storage deposit $2572 transferred from agreement A12-CT207668 to this agreement. \r\n","2020-05-20","20",0,null,0,"0","2","2020-05-20 11:35:03","2","2020-05-20 11:35:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26664","C201564","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","wtXe3F1rqyx\/NkkNOLs7pg==","","BgslglUH0r+MGDNMVR4ODLjLIekcdNYutpHNMKcJTdrat5CTYwp+Fhe5w6yhrvR0cHFxKswLh535kpcAoSEfSvDIf7aqVNHnYcIjpS7j\/kY=","5MBoUUrP0SuSZ8JjZjyPvw==","VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","5e+N+acflaaaW7mYFvh\/JQ==",null,1,7668]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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":["7904","61","1528.0","1528.00","2","2020-05-20 11:35:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-20","2020-06-19","61"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 11:35:03","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":["7904",1564,"SETTLED","A12-I208233","2020-05-20 11:35:03","2020-05-20","2","2020-05-20 11:35:03","2","2020-05-20 11:35:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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":["8233","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-05-20 11:35:03","2","2020-05-20 11:35:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8233"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 11:35:03","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":[1564,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207877","2020-05-20 11:35:03",1286,"2","2020-05-20 11:35:03","2","2020-05-20 11:35:03","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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":["7877","DEPOSIT",null,"PAID","2020-05-20 11:35:03",0,"2","2020-05-20 11:35:03","2","2020-05-20 11:35:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:35:03","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":["7877","INVOICE","8233","PAID","2020-05-20 11:35:03",1286,"2","2020-05-20 11:35:03","2","2020-05-20 11:35:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:55:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 11:55:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 12:18:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:00:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1428","master_room_id":"172","room_code":"C15-122"}],"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\tC15-122 4X5X6.5 $1115.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":"BUSINESS","identity_id":"32676788","title":"Mr","lastname":"LEUNG","firstname":"Louis","companyname":"Bonanza Interior Products Limited","email":"bonanza.interior@gmail.com","tel":"90906006","address":"Flat 1803-5, Hang Seng North Point Building 335-341 King's Rd, North Point, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1428","room_code":"C15-122","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1004,"deposit":1115,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10955,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2208.00","warehousing_date":"2020-05-21","rent_from":"2020-05-21","rent_to":"2021-05-20","delivery_service":"0","remark":"12 months contract. Special offer the 11th & 12th months free and $200 'rent now' discount. Deposit $500 paid by cash on May 11,2020. The balance of storage rental, deposit and 2 access card $10575 paid by bank transfer on May 19,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2208,"order_total":13283,"final_order_total":11075,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005796799","order_product":[{"product_id":"12","product_name":"\u5009\u9396\u5319","qty":"2","price":"60.0"}],"pass":true}},"roughly_size":"20","total_discounted_price":"1004.00","deposit":"1115.00","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:11","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":["C201586","BUSINESS","Mr","UVjrCP4Ux0XGx\/NzXvnkmQ==","yXKc2lCF323ApRADrjNaSg==","Bonanza Interior Products Limited","smG3fSRJ66n9dtGIZ+0hng==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=","djHiHXMolmT13wVdf6TQPT6gi\/lqypjeVCbA4PUDsIzMdXoxzF9W1d767uZrMM9UR8Ko7TPQkrFu78V0zh1J2eoxzomoqGcKm\/7h+RFaKPw=",null,"tR+EFMxmviDjsG6ERopa1g==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=","z5FKZ2J8xcnPUSggyKbWkg==","2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1586,"NEW","C15-CT207905",1115,1004,1115,0,"12","12",10955,13283,11075,"2020-05-20 13:08:12","0",null,null,null,"2020-05-21","2021-05-20","12 months contract. Special offer the 11th & 12th months free and $200 'rent now' discount. Deposit $500 paid by cash on May 11,2020. The balance of storage rental, deposit and 2 access card $10575 paid by bank transfer on May 19,2020.","2020-05-21","20",0,null,2208,"2208.00","2","2020-05-20 13:08:10","2","2020-05-20 13:08:10","BANKIN","","","","BANKIN","","","",null,0,"'0005796799","C201586","BUSINESS","Mr","UVjrCP4Ux0XGx\/NzXvnkmQ==","yXKc2lCF323ApRADrjNaSg==","Bonanza Interior Products Limited","djHiHXMolmT13wVdf6TQPT6gi\/lqypjeVCbA4PUDsIzMdXoxzF9W1d767uZrMM9UR8Ko7TPQkrFu78V0zh1J2eoxzomoqGcKm\/7h+RFaKPw=","smG3fSRJ66n9dtGIZ+0hng==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=",null,"tR+EFMxmviDjsG6ERopa1g=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7905",1586,"12","2","60.0",120,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[120,"7905"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-05-20 13:08:12","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":["7905","1428","1115.0","1115.00","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-21","2021-05-20","1428"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 13:08:12","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":["7905","C15-D205418","PAID",1115,0,"2021-05-20","2020-05-20 13:08:10","2020-05-20 13:08:10","2","2020-05-20 13:08:10","2","2020-05-20 13:08:10",1586]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["7905",1586,"SETTLED","C15-I208234","2020-05-20 13:08:10","2020-05-21","2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,804,"MO","1",804,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",4,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",5,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",6,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",7,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",8,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",9,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",10,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",11,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["8234","RENT","\u9810\u7e73\u79df\u91d1",12,1004,"MO","1",1004,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8234","ORDER_PRODUCT","60.0","PCS","2",120,"12","2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9960,0,"8234"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 13:08:12","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":[1586,"BANKIN","","","","BANKIN","","","","PAID","P207878","2020-05-20 13:08:10",11075,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["7878","DEPOSIT","5418","PAID","2020-05-20 13:08:10",1115,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:08:12","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":["7878","INVOICE","8234","PAID","2020-05-20 13:08:10",9960,"2","2020-05-20 13:08:10","2","2020-05-20 13:08:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:17","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=1470&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":350,"customer_code":"C170350","identity_type":"PERSONAL","identity_id":"D451878(1)","title":"Mr","lastname":"Chiu","firstname":"Raymond Chiu Fat","companyname":"","email":"raycfchiu@gmail.com","tel":"94991707","address":"401D, 3\/F, Guildford Rd. , Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-18","renew_room_key":"056,06597","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cheque on April 15, 2019. Storage deposit transferred from agreement A14-CT183278 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194748, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"57","order_discount":[],"order_room":[{"room_id":"786","room_code":"P20","retail_price":"2598.0","discounted_price":"2598.00","location_id":"2"}],"roughly_size":"36","total_retail_price":2598,"total_discounted_price":2018,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":23016,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1200.00","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2021-05-17","delivery_service":"0","remark":"12 months contract. Special price $1918\/month. And $300 Maxim's voucher. Storage rental paid by EPS on May 20, 2020. Storage deposit transferred from agreement A14-CT194748 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1200,"order_total":24216,"final_order_total":23016,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,06597","order_product":[],"pass":true}},"first_order_id":4748,"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\tP20 6X6X8 $2598.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","roughly_size":"36","total_discounted_price":"2018.00","deposit":"0.00","total_retail_price":"2598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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",350,"NEW","A14-CT207906",2598,2018,0,0,"12","12",23016,24216,23016,"2020-05-20 13:38:18","0",null,null,null,"2020-05-18","2021-05-17","12 months contract. Special price $1918\/month. And $300 Maxim's voucher. Storage rental paid by EPS on May 20, 2020. Storage deposit transferred from agreement A14-CT194748 to this agreement.\r\n","2020-05-18","36",0,null,1200,"1200.00","2","2020-05-20 13:38:17","2","2020-05-20 13:38:17","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"056,06597","C170350","PERSONAL","Mr","hh\/H699c00GxByIAiQ9SMuNE8UjtctZFOJcx\/MrdgP8=","sQFQFKDK2lCJDg4WUvEEAw==","","RIeWKdZNqFEIPpCGI0WNxNDLTGVKIAOLc4IfJTWK1iJB2tLy68KOYNc9CR8NKo\/Q","5JFUNVwFjDC4VdxWAHU5pQ==","JB3QY8sbNvPxVdi6W+fSI12OOZvCGCmkQN4mC8c8m\/I=","G+b9ISwo+\/Lztks6\/eD+2g==",null,1,4748]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["7906","786","2598.0","2598.00","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-18","2021-05-17","786"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 13:38:18","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":["7906",350,"SETTLED","A14-I208235","2020-05-20 13:38:17","2020-05-18","2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,818,"MO","1",818,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",7,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",8,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",9,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",10,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",11,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["8235","RENT","\u9810\u7e73\u79df\u91d1",12,2018,"MO","1",2018,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23016,0,"8235"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 13:38:18","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":[350,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207879","2020-05-20 13:38:17",23016,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["7879","DEPOSIT",null,"PAID","2020-05-20 13:38:17",0,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 13:38:18","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":["7879","INVOICE","8235","PAID","2020-05-20 13:38:17",23016,"2","2020-05-20 13:38:17","2","2020-05-20 13:38:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:30:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33: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":"filter1=2&filter2=1470&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":621,"customer_code":"C170621","identity_type":"PERSONAL","identity_id":"Z083036(5)","title":"Mr","lastname":"Ng","firstname":"Wai Yip","companyname":"","email":"waiyip010@gmail.com","tel":"98388160","address":"Room 2, 22\/F, Kwun Chiu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-28","renew_room_key":"054,54144","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 21, 2020. Storage deposit transferred from agreement A18-CT207457 to this agreement.\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\tS08 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","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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",621,"NEW","A18-CT207907",1290,1290,0,0,"1","1",1290,1290,1290,"2020-05-20 14:33:05","0",null,null,null,"2020-04-28","2020-05-27","1 month contract. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A18-CT207691 to this agreement.\r\n","2020-04-28","16",0,null,0,"0","2","2020-05-20 14:33:05","2","2020-05-20 14:33:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,54144","C170621","PERSONAL","Mr","ih4aUrxtlcexLCp\/tdkvvw==","cxr02xsD1tXvJ4ihJHZKWw==","","yR95NWcy8orgfJiv4o8nUhldJm21pHQyPqtwASYolM1Kfk2Djou6qn5enXkBMxam3xy5zhVtYjz\/vUJqcjgCQwJJ6wImNgSpgm7xbtLd7UU=","484inTWWBLYNYwPtLecM3w==","eXhWO16jYYVtb51D98Y8hU3AEhjg0o6Un\/aNYSBOey4=","xt28FcrgbbbToDMexv\/cfg==",null,1,"4764"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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":["7907","849","1290.0","1290.00","2","2020-05-20 14:33:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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-04-28","2020-05-27","849"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 14:33:05","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":["7907",621,"SETTLED","A18-I208236","2020-05-20 14:33:05","2020-04-28","2","2020-05-20 14:33:05","2","2020-05-20 14:33:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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":["8236","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-05-20 14:33:05","2","2020-05-20 14:33:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8236"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 14:33:05","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":[621,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207880","2020-05-20 14:33:05",1290,"2","2020-05-20 14:33:05","2","2020-05-20 14:33:05","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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":["7880","DEPOSIT",null,"PAID","2020-05-20 14:33:05",0,"2","2020-05-20 14:33:05","2","2020-05-20 14:33:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 14:33:05","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":["7880","INVOICE","8236","PAID","2020-05-20 14:33:05",1290,"2","2020-05-20 14:33:05","2","2020-05-20 14:33:05"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:57","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":"1428","master_room_id":"172","room_code":"C15-122"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":140,"customer_code":"C160140","identity_type":"PERSONAL","identity_id":"G305444(5)","title":"Mr","lastname":"Lau","firstname":"Wing Kwong","companyname":"","email":null,"tel":"97889868","address":"Flat A, 13\/F, Block 5, Pokfulam Garden, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-25","renew_room_key":"137,06998","renew_remark":"12 month contract. Special renewal offer, $100 wellcome coupon offered. Storage rental paid by EPS on May 14, 2019. Storage deposit transferred from agreement A12-CT183574 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194955, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"334","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"334","room_code":"F19","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2021-05-24","delivery_service":"0","remark":"12 months contract. Special renewal offer, $300 coupon offered. Storage rental paid by EPS on May 20, 2020. Storage deposit transferred from agreement A12-CT194955 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,06998","order_product":[],"pass":true}},"first_order_id":"3574","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\tF19 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":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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",140,"NEW","A12-CT207908",1098,935,0,0,"12","12",11220,11220,11220,"2020-05-20 15:37:58","0",null,null,null,"2020-05-25","2021-05-24","12 months contract. Special renewal offer, $300 coupon offered. Storage rental paid by EPS on May 20, 2020. Storage deposit transferred from agreement A12-CT194955 to this agreement.","2020-05-25","16",0,null,0,"0","2","2020-05-20 15:37:57","2","2020-05-20 15:37:57","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"137,06998","C160140","PERSONAL","Mr","HWeBxSjwdZ3+zdu64vLxww==","oe4emdjBwqJ3qUpOcI17hw==","","oEzr1213z4l9dk8n968at+i+mzK1N0IXphhQUO3q5mb5RptAb9\/\/xP9b2hoa8Wb3EEHIBDYPi4qjjCVSvolKKA==","FPArUPOPniFfTlqCf4lhgw==",null,"Y26V3+8aiO6eChqe2TRGBA==",null,1,"3574"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["7908","73","8","334","%","16.85",185.013,"2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["7908","334","1098.0",913,"2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-25","2021-05-24","334"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-20 15:37:58","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":["7908",140,"SETTLED","A12-I208237","2020-05-20 15:37:57","2020-05-25","2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["8237","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"8237"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-20 15:37:58","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":[140,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207881","2020-05-20 15:37:57",11220,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["7881","DEPOSIT",null,"PAID","2020-05-20 15:37:57",0,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 15:37:58","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":["7881","INVOICE","8237","PAID","2020-05-20 15:37:57",11220,"2","2020-05-20 15:37:57","2","2020-05-20 15:37:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-20 16:50:24","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":["NEW","'0005796799; '0005019599","12 months contract. Special offer the 11th & 12th months free and $200 'rent now' discount. Deposit $500 paid by cash on May 11,2020. The balance of storage rental, deposit and 2 access card $10575 paid by bank transfer on May 19,2020.","2020-05-20 16:50:24","2","yXKc2lCF323ApRADrjNaSg==","UVjrCP4Ux0XGx\/NzXvnkmQ==","FOOO3aO2hhdQRAXW6Va0cOJSidlswlLbbwc1PAfAGd4=","smG3fSRJ66n9dtGIZ+0hng==","djHiHXMolmT13wVdf6TQPT6gi\/lqypjeVCbA4PUDsIzMdXoxzF9W1d767uZrMM9UR8Ko7TPQkrFu78V0zh1J2eoxzomoqGcKm\/7h+RFaKPw=","Bonanza Interior Products Limited",7905]},"data_before":[],"data_after":[],"step":1}
*****