| | |
|---|
| | | @Override |
|---|
| | | public VisitDataVO visitSecurityData(){ |
|---|
| | | //待访问、已登记、已离开 |
|---|
| | | |
|---|
| | | VisitDataVO result = new VisitDataVO(); |
|---|
| | | result.setWaitVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() |
|---|
| | | .eq(Visits::getIsdeleted,Constants.ZERO) |
|---|
| | | .apply("to_days(create_date)=to_days(now())") |
|---|
| | | .apply(" now() > STARTTIME and now() < ENDTIME") |
|---|
| | | .in(Visits::getStatus,Constants.VisitStatus.pass,Constants.VisitStatus.xfSuccess )));//待访问 |
|---|
| | | result.setRegisterVisitNum(visitsJoinMapper.selectCount(new MPJLambdaWrapper<Visits>() |
|---|
| | | .eq(Visits::getIsdeleted,Constants.ZERO) |
|---|
