\r\n\t\t\t\t\tK38 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":"1167.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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",904,"NEW","A14-CT208460",1098,1167,0,0,"3","3",3501,3501,3501,"2020-07-25 10:15:15","0",null,null,null,"2020-05-28","2020-08-27","3 months contract. Storage rental paid by bank transfer on Jul 24, 2020. Storage deposit transferred from agreement A14-CT207535 to this agreement.","2020-05-28","16",0,null,0,"0","2","2020-07-25 10:15:15","2","2020-07-25 10:15:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40459,190,26677","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4261"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8460","434","35","501","%","4.97",54.5706,"2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8460","501","1098.0",1043.4,"2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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-28","2020-08-27","501"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 10:15:15","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":["8460",904,"SETTLED","A14-I208789","2020-07-25 10:15:15","2020-05-28","2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8789","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8789","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8789","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"8789"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 10:15:15","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208432","2020-07-25 10:15:15",3501,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8432","DEPOSIT",null,"PAID","2020-07-25 10:15:15",0,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:15:15","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":["8432","INVOICE","8789","PAID","2020-07-25 10:15:15",3501,"2","2020-07-25 10:15:15","2","2020-07-25 10:15:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:43","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=1&filter2=1685&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":904,"customer_code":"C180904","identity_type":"PERSONAL","identity_id":"D513677(7)","title":"Mr","lastname":"Lee","firstname":"Kim Hung","companyname":"","email":"luplus@hgcbroadband.com","tel":"98657033","address":"Flat C, 8\/F, Block 29, Fung King Court, South Horizon, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1167.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-01","renew_room_key":"076,28245","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 30, 2020. Deposit $2456 transferred from agreement A14-CT196818 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\tK42 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":"1167.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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",904,"NEW","A14-CT208461",1098,1167,0,0,"3","3",3501,3501,3501,"2020-07-25 10:17:44","0",null,null,null,"2020-06-01","2020-08-31","3 months contract. Storage rental paid by bank transfer on Jul 24, 2020. Deposit $2456 transferred from agreement A14-CT207536 to this agreement.","2020-06-01","16",0,null,0,"0","2","2020-07-25 10:17:43","2","2020-07-25 10:17:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,28245","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4262"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8461","434","35","505","%","4.97",54.5706,"2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8461","505","1098.0",1043.4,"2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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-06-01","2020-08-31","505"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 10:17:44","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":["8461",904,"SETTLED","A14-I208790","2020-07-25 10:17:43","2020-06-01","2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8790","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8790","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8790","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"8790"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 10:17:44","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208433","2020-07-25 10:17:43",3501,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8433","DEPOSIT",null,"PAID","2020-07-25 10:17:43",0,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:17:44","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":["8433","INVOICE","8790","PAID","2020-07-25 10:17:43",3501,"2","2020-07-25 10:17:43","2","2020-07-25 10:17:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:23:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:24:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:28:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54: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","index_url_parameter":"filter1=1&filter2=1685&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t\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>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \n\t\t\t\t\tL33 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tL45 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tL44 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D484790(4)","title":"Ms","lastname":"WONG","firstname":"Cheuk Man Mandy","companyname":"","email":"lemonnosugar@gmail.com","tel":"92028053","address":"6A, Portfield Bldg, 10-16 Yuk Sau Street, Happy Valley","pass":true,"customer_id":"1679","customer_code":"C201679","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"555","room_code":"L33","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"567","room_code":"L45","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"566","room_code":"L44","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"48","total_retail_price":3294,"total_discounted_price":3301,"deposit":7336,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":44718,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5531.00","warehousing_date":"2020-07-27","rent_from":"2020-07-27","rent_to":"2021-08-26","delivery_service":"0","remark":"13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, and Jul 25, 2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":5531,"order_total":50249,"final_order_total":44718,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,12131","order_product":[],"pass":true}},"roughly_size":"48","total_discounted_price":"3301.00","deposit":"7336.00","total_retail_price":"3294.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1679","NEW","A14-CT208462",3294,3301,7336,0,"13","13",44718,50249,44718,"2020-07-25 10:54:11","0",null,null,null,"2020-07-27","2021-08-26","13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, and Jul 25, 2020. Smart card provided on the same day.","2020-07-27","48",0,null,5531,"5531.00","2","2020-07-25 10:54:10","2","2020-07-25 10:54:10","CHEQUE","","","","CHEQUE","","","",null,0,"189,12131","C201679","PERSONAL","Ms","kwdSO7Ycb8PwoVKLWhZpYA==","ddrfzAYTmkL\/QNu3psjONQ==","","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==","a\/y2Qrzn0kao6T1xJXuB3g==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","pflhzOWnDf2jT37JrLakNQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8462","555","1098.0","1098.00","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","555"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 10:54:11","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":["8462","567","1098.0","1098.00","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","567"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 10:54:11","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":["8462","566","1098.0","1098.00","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","566"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 10:54:11","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":["8462","A14-D205564","PAID",7336,0,"2021-08-26","2020-07-25 10:54:10","2020-07-25 10:54:10","2","2020-07-25 10:54:10","2","2020-07-25 10:54:10","1679"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8462","1679","SETTLED","A14-I208791","2020-07-25 10:54:10","2020-07-27","2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1071,"MO","1",1071,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",3,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",4,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",5,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",6,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",7,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",8,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",9,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",10,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",11,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",12,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8791","RENT","\u9810\u7e73\u79df\u91d1",13,3301,"MO","1",3301,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[37382,0,"8791"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 10:54:11","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":["1679","CHEQUE","","","","CHEQUE","","","","PAID","P208434","2020-07-25 10:54:10",44718,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8434","DEPOSIT","5564","PAID","2020-07-25 10:54:10",7336,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 10:54:11","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":["8434","INVOICE","8791","PAID","2020-07-25 10:54:10",37382,"2","2020-07-25 10:54:10","2","2020-07-25 10:54:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:50:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:55:59","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&page=2","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1029,"customer_code":"C181029","identity_type":"PERSONAL","identity_id":"D669964(3)","title":"Mr","lastname":"Tseng","firstname":"Yee Paul","companyname":"","email":"paulyeetseng@gmail.com","tel":"91799340","address":"Flat 13D, Block 24, Baguio Villa, 555 Victoria Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2730.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-14","renew_room_key":"0005895098","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 20, 2019. Storage deposit $6066 transferred from agreement A05-CT183510 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\tA05-050 4X5X7 $1605.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tA05-049 4X5X7 $1605.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2881.00","deposit":"0.00","total_retail_price":"3210.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1029,"NEW","A05-CT208463",3210,2881,0,0,"3","3",8643,8643,8643,"2020-07-25 12:56:00","0",null,null,null,"2020-05-14","2020-08-13","3 months contract. Storage rental paid by bank transfer on Jul 25, 2020. Storage deposit $6066 transferred from agreement A05-CT196787 to this agreement.\r\n","2020-05-14","40",0,null,0,"0","2","2020-07-25 12:55:59","2","2020-07-25 12:55:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005895098","C181029","PERSONAL","Mr","rNrE6\/J+34UtCz7KeUh44w==","Cagh5lRxiLB35KyEOVWJ4A==","","sRfjpcKHaB3eYvJOTrZZgw8z43L4grn3ay9NgDZouJhp68ZQTMKw3qJAZqNeXOkNFic8pWQHmOINZQH+LnBdHPHHFQFkrtw\/HX\/lKdYT86E=","PKsjvUg8hiflcbYTv7YgXA==","qU5MfLTkutPuoeoR+ec+BqHsE9oi\/yOw8HB0EY8RbdI=","JPoFTcPKdOfgkXyqFxIDHQ==",null,1,"3510"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8463","253","116","1052","%","5.00",80.25,"2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8463","253","116","1051","%","5.00",80.25,"2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8463","1052","1605.0",1524.8,"2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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-14","2020-08-13","1052"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 12:56:00","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":["8463","1051","1605.0",1524.8,"2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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-14","2020-08-13","1051"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 12:56:00","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":["8463",1029,"SETTLED","A05-I208792","2020-07-25 12:55:59","2020-05-14","2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8792","RENT","\u9810\u7e73\u79df\u91d1",1,2881,"MO","1",2881,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8792","RENT","\u9810\u7e73\u79df\u91d1",2,2881,"MO","1",2881,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8792","RENT","\u9810\u7e73\u79df\u91d1",3,2881,"MO","1",2881,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8643,0,"8792"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 12:56:00","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":[1029,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208435","2020-07-25 12:55:59",8643,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8435","DEPOSIT",null,"PAID","2020-07-25 12:55:59",0,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 12:56:00","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":["8435","INVOICE","8792","PAID","2020-07-25 12:55:59",8643,"2","2020-07-25 12:55:59","2","2020-07-25 12:55:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:09:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:38:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:56:18","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","189,12131","13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, and Jul 25, 2020. Smart card provided on the same day.","2020-07-25 13:56:18","2","ddrfzAYTmkL\/QNu3psjONQ==","kwdSO7Ycb8PwoVKLWhZpYA==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","a\/y2Qrzn0kao6T1xJXuB3g==","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==",8462]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1345&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D484790(4)","title":"Ms","lastname":"WONG","firstname":"Cheuk Man Mandy","companyname":"","email":"lemonnosugar@gmail.com","tel":"92028053","address":"6A, Portfield Bldg, 10-16 Yuk Sau Street, Happy Valley","pass":true,"customer_id":"1679","customer_code":"C201679","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"566","room_code":"L44","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"556","room_code":"L34","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"555","room_code":"L33","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"48","total_retail_price":3294,"total_discounted_price":3301,"deposit":7336,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":44718,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5531.00","warehousing_date":"2020-07-27","rent_from":"2020-07-27","rent_to":"2021-08-26","delivery_service":"0","remark":"13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, and Jul 25, 2020. Smart card provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":5531,"order_total":50249,"final_order_total":44718,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,12131","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tL44 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tL34 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tL33 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"48","total_discounted_price":"3301.00","deposit":"7336.00","total_retail_price":"3294.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1679","NEW","A14-CT208464",3294,3301,7336,0,"13","13",44718,50249,44718,"2020-07-25 13:58:15","0",null,null,null,"2020-07-27","2021-08-26","13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, and Jul 25, 2020. Smart card provided on the same day.","2020-07-27","48",0,null,5531,"5531.00","2","2020-07-25 13:58:14","2","2020-07-25 13:58:14","CHEQUE","","","","CHEQUE","","","",null,0,"189,12131","C201679","PERSONAL","Ms","kwdSO7Ycb8PwoVKLWhZpYA==","ddrfzAYTmkL\/QNu3psjONQ==","","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==","a\/y2Qrzn0kao6T1xJXuB3g==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","pflhzOWnDf2jT37JrLakNQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8464","566","1098.0","1098.00","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","566"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 13:58:15","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":["8464","556","1098.0","1098.00","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","556"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 13:58:15","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":["8464","555","1098.0","1098.00","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-08-26","555"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 13:58:15","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":["8464","A14-D205565","PAID",7336,0,"2021-08-26","2020-07-25 13:58:14","2020-07-25 13:58:14","2","2020-07-25 13:58:14","2","2020-07-25 13:58:14","1679"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8464","1679","SETTLED","A14-I208793","2020-07-25 13:58:14","2020-07-27","2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1071,"MO","1",1071,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",3,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",4,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",5,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",6,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",7,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",8,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",9,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",10,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",11,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",12,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8793","RENT","\u9810\u7e73\u79df\u91d1",13,3301,"MO","1",3301,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[37382,0,"8793"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 13:58:15","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":["1679","CHEQUE","","","","CHEQUE","","","","PAID","P208436","2020-07-25 13:58:14",44718,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8436","DEPOSIT","5565","PAID","2020-07-25 13:58:14",7336,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:58:15","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":["8436","INVOICE","8793","PAID","2020-07-25 13:58:14",37382,"2","2020-07-25 13:58:14","2","2020-07-25 13:58:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 13:59:54","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","189,12131","13 months contract. Referral bouns -$250. Special offer the 13th month free and extra 5% rent now discount. Storage rental and deposit paid by cheque on Jul 20, 2020. Smart card provided on the same day.","2020-07-25 13:59:54","2","ddrfzAYTmkL\/QNu3psjONQ==","kwdSO7Ycb8PwoVKLWhZpYA==","ueYgCG4LhuKcGq\/NkZFOrUks9W+D2VEm4LiPJX4u06g=","a\/y2Qrzn0kao6T1xJXuB3g==","BHQ9hkHdRQGEjBqtlvqUCVY7Yq+vCPSiUJb+oMnt7bk1vuNyZJtS9G8xdeAHmfDgQcWK8DukQi8Gjmh8wsizjg==",8431]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:00:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:05:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:07:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:08:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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=1345&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true,"customer_id":"1008","customer_code":"C181008","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"412 available_room_list_input","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"720.00","discount":"9.90","monthly_deduct":71.28,"room_id":"1403","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"412 available_room_list_input","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"720.00","discount":"9.90","monthly_deduct":71.28,"room_id":"1395","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1395","room_code":"C15-089","retail_price":"720.0","discounted_price":648.7,"location_id":"6"},{"room_id":"1403","room_code":"C15-097","retail_price":"720.0","discounted_price":648.7,"location_id":"6"}],"roughly_size":"18","total_retail_price":1440,"total_discounted_price":998,"deposit":1108,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7096,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-01-31","delivery_service":"0","remark":"6 months contract. Customer will pay by PPS monthly. Storage rental and deposit of the first month paid by PPS on Jul 27, 2020.","paymethod":"PPS","paymethod2":"PPS","discount_deduct":0,"order_total":7096,"final_order_total":7096,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005796877","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tC15-089 3X3X6.5 $720.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tC15-097 3X3X6.5 $720.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"18","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1440.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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","1008","NEW","C15-CT208465",1440,998,1108,0,"6","6",7096,7096,7096,"2020-07-25 14:30:36","0",null,null,null,"2020-08-01","2021-01-31","6 months contract. Customer will pay by PPS monthly. Storage rental and deposit of the first month paid by PPS on Jul 27, 2020.","2020-08-01","18",0,null,0,"0","2","2020-07-25 14:30:36","2","2020-07-25 14:30:36","PPS","","","","PPS","","","",null,0,"'0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","412 available_room_list_input","159","1403","%","9.90",71.28,"2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","412 available_room_list_input","159","1395","%","9.90",71.28,"2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","1395","720.0",648.7,"2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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-08-01","2021-01-31","1395"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","1403","720.0",648.7,"2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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-08-01","2021-01-31","1403"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","C15-D205566","PAID",1108,0,"2021-01-31","2020-07-25 14:30:36","2020-07-25 14:30:36","2","2020-07-25 14:30:36","2","2020-07-25 14:30:36","1008"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8465","1008","SETTLED","C15-I208794","2020-07-25 14:30:36","2020-08-01","2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8794","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5988,0,"8794"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 14:30:36","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":["1008","PPS","","","","PPS","","","","PAID","P208437","2020-07-25 14:30:36",7096,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8437","DEPOSIT","5566","PAID","2020-07-25 14:30:36",1108,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:30:36","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":["8437","INVOICE","8794","PAID","2020-07-25 14:30:36",5988,"2","2020-07-25 14:30:36","2","2020-07-25 14:30:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:33:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:34:01","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0005796877","6 months contract. Customer will pay by PPS monthly. Storage rental and deposit of the first month paid by PPS on Jul 27, 2020.","2020-07-25 14:34:01","2","UCPBCXrBLI9U7KKsPqgmNA==","pyScVxHN1bAPGGa\/Bucd1Q==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","ODUJ\/sh5I9t4EANm7+m4qQ==","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=",8465]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:19","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true,"customer_id":"1008","customer_code":"C181008","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"412 available_room_list_input","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"648.70","discount":"9.90","monthly_deduct":71.28,"room_id":"1404","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"412 available_room_list_input","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"648.70","discount":"9.90","monthly_deduct":71.28,"room_id":"1403","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1403","room_code":"C15-097","retail_price":"720.0","discounted_price":648.7,"location_id":"6"},{"room_id":"1404","room_code":"C15-098","retail_price":"720.0","discounted_price":648.7,"location_id":"6"}],"roughly_size":"18","total_retail_price":1440,"total_discounted_price":998,"deposit":1108,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7096,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-01-31","delivery_service":"0","remark":"6 months contract. Customer will pay by PPS monthly. Storage rental and deposit of the first month paid by PPS on Jul 27, 2020.","paymethod":"PPS","paymethod2":"PPS","discount_deduct":0,"order_total":7096,"final_order_total":7096,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005796877","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tC15-097 3X3X6.5 $720.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tC15-098 3X3X6.5 $720.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"18","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1440.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1008","NEW","C15-CT208466",1440,998,1108,0,"6","6",7096,7096,7096,"2020-07-25 14:35:20","0",null,null,null,"2020-08-01","2021-01-31","6 months contract. Customer will pay by PPS monthly. Storage rental and deposit of the first month paid by PPS on Jul 27, 2020.","2020-08-01","18",0,null,0,"0","2","2020-07-25 14:35:19","2","2020-07-25 14:35:19","PPS","","","","PPS","","","",null,0,"'0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","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":["8466","412 available_room_list_input","159","1404","%","9.90",71.28,"2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","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":["8466","412 available_room_list_input","159","1403","%","9.90",71.28,"2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8466","1403","720.0",648.7,"2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2021-01-31","1403"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8466","1404","720.0",648.7,"2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2021-01-31","1404"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 14:35:20","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":["8466","C15-D205567","PAID",1108,0,"2021-01-31","2020-07-25 14:35:19","2020-07-25 14:35:19","2","2020-07-25 14:35:19","2","2020-07-25 14:35:19","1008"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8466","1008","SETTLED","C15-I208795","2020-07-25 14:35:19","2020-08-01","2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8795","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5988,0,"8795"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1008","PPS","","","","PPS","","","","PAID","P208438","2020-07-25 14:35:19",7096,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8438","DEPOSIT","5567","PAID","2020-07-25 14:35:19",1108,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:35:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8438","INVOICE","8795","PAID","2020-07-25 14:35:19",5988,"2","2020-07-25 14:35:19","2","2020-07-25 14:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:46:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:53:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 14:57:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:13:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1131","master_room_id":"114","room_code":"A05-129"}],"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\tA05-129 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R156586(8)","title":"Mr","lastname":"LEONG","firstname":"An Qiang Henley","companyname":"","email":"henley.leong@gmail.com","tel":"96148313","address":"A1, 9\/F, 33 South Bay Close, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1131","room_code":"A05-129","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":2580,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":15828,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1858.00","warehousing_date":"2020-08-07","rent_from":"2020-08-07","rent_to":"2021-09-06","delivery_service":"0","remark":"13 months contract. Special offer 5% off and the 13th month free. Storage rental and deposit paid by EPS on Jul 25, 2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1858,"order_total":17686,"final_order_total":15828,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0005023144","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1162","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201688","PERSONAL","Mr","Nnggl555+X3mK0BGlwwgGA==","uB9eAr4\/LgrRCFViYhTamg==","","c\/usV3y6EG9kMIaJ0SKW+w==","UpiS9W1VIgk8WeQ0nU0UFgbp5nZnVYbzInWNWAZSi0E=","r2U+DN1dwByps8YbQLDDttG0MeZGGACtnppXQ8sPOVm1gHkA2ypVQClbun+PUedQ","8Zy5yDEBJLW7pxBadyFKAA==",null,"UpiS9W1VIgk8WeQ0nU0UFgbp5nZnVYbzInWNWAZSi0E=","EP8fSquE5iM1KE6yEJ56Sg==","2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1688,"NEW","A05-CT208467",1290,1162,2580,0,"13","13",15828,17686,15828,"2020-07-25 15:18:50","0",null,null,null,"2020-08-07","2021-09-06","13 months contract. Special offer 5% off and the 13th month free. Storage rental and deposit paid by EPS on Jul 25, 2020. Smart card and padlock provided on the same day.","2020-08-07","16",0,null,1858,"1858.00","2","2020-07-25 15:18:49","2","2020-07-25 15:18:49","EPS","","","","EPS","","","",null,0,"'0005023144","C201688","PERSONAL","Mr","Nnggl555+X3mK0BGlwwgGA==","uB9eAr4\/LgrRCFViYhTamg==","","r2U+DN1dwByps8YbQLDDttG0MeZGGACtnppXQ8sPOVm1gHkA2ypVQClbun+PUedQ","c\/usV3y6EG9kMIaJ0SKW+w==","UpiS9W1VIgk8WeQ0nU0UFgbp5nZnVYbzInWNWAZSi0E=","8Zy5yDEBJLW7pxBadyFKAA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8467","1131","1290.0","1290.00","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-07","2021-09-06","1131"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8467","A05-D205568","PAID",2580,0,"2021-09-06","2020-07-25 15:18:49","2020-07-25 15:18:49","2","2020-07-25 15:18:49","2","2020-07-25 15:18:49",1688]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8467",1688,"SETTLED","A05-I208796","2020-07-25 15:18:49","2020-08-07","2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,466,"MO","1",466,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8796","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13248,0,"8796"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1688,"EPS","","","","EPS","","","","PAID","P208439","2020-07-25 15:18:49",15828,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8439","DEPOSIT","5568","PAID","2020-07-25 15:18:49",2580,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:18:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8439","INVOICE","8796","PAID","2020-07-25 15:18:49",13248,"2","2020-07-25 15:18:49","2","2020-07-25 15:18:49"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:21:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:31:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:46:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:56:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-25 15:56:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****