commit 6146df4df74290f5dee3bd7c47ddb36550a9beea
author Xia Kaixiang <kaixiang.xia@supwisdom.com> 周五 4月 24 17:15:35 2020 +0800
committer Xia Kaixiang <kaixiang.xia@supwisdom.com> 周五 4月 24 17:15:35 2020 +0800
tree 83b8aebf4419e835ac9619a00b7f361b6d86685e
parent 5166a232e62a211cde84ea4e44c378ef7c044473

部署sql纠正和无用任务注释

sql/restarant_create_table.sql

diff --git a/sql/restarant_create_table.sql b/sql/restarant_create_table.sql
index 266e161..9110688 100644
--- a/sql/restarant_create_table.sql
+++ b/sql/restarant_create_table.sql
@@ -109,8 +109,7 @@
   download_ok bool NOT NULL,
   lastsaved timestamp(6),
   remark varchar(1000),
-  startdate varchar(8),
-  statdate varchar(8) NOT NULL
+  startdate varchar(8)
 );
 ALTER TABLE tb_check_ctl ADD CONSTRAINT tb_check_ctl_pkey PRIMARY KEY (id);
 
@@ -169,7 +168,9 @@
   operid varchar(100),
   phone varchar(11),
   status varchar(10),
-  deptcode varchar(32) 
+  deptcode varchar(32),
+  deptno varchar(32),
+  inputdate varchar(8)
 );
 ALTER TABLE tb_customer ADD CONSTRAINT tb_customer_pkey PRIMARY KEY (custid);
 CREATE INDEX customer_custid_idx ON tb_customer(custid);

src/main/java/com/supwisdom/dlpay/restaurant/task/RestaurantTask.java

diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/task/RestaurantTask.java b/src/main/java/com/supwisdom/dlpay/restaurant/task/RestaurantTask.java
index 0208f54..ae8cb33 100644
--- a/src/main/java/com/supwisdom/dlpay/restaurant/task/RestaurantTask.java
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/task/RestaurantTask.java
@@ -102,11 +102,11 @@
     }
   }
 
-    //TODO 
-    @Scheduled(cron = "0 0/1 * * * ? ")
-    private void deleteExpiredWhitelist(){
-        List<TCustomer> expiredCustomer=customerDao.findAll();
-
-    }
+//    //TODO
+//    @Scheduled(cron = "0 0/1 * * * ? ")
+//    private void deleteExpiredWhitelist(){
+//        List<TCustomer> expiredCustomer=customerDao.findAll();
+//
+//    }
 
 }