| | |
|---|
| | | StringBuilder sb=new StringBuilder(); |
|---|
| | | List<Object> param=new ArrayList<>(); |
|---|
| | | |
|---|
| | | sb.append(" SELECT a.punch_date,e.bk, "); |
|---|
| | | sb.append(" SELECT a.punch_date,e.bk,f.morning_work,f.morning_work_off,f.afternoon_work,f.afternoon_work_off, "); |
|---|
| | | |
|---|
| | | sb.append(" CONCAT(if(d.punch_range_one is not null and d.punch_range_one>f.distance,'超出打卡范围',0) "); |
|---|
| | | sb.append(" ,',',if(d.punch_range_two is not null and d.punch_range_two>f.distance,'超出打卡范围',0) "); |
|---|
| | |
|---|
| | | if (!bk.contains("1")){ |
|---|
| | | fs.setValue("result_one", "上午上班未打卡"); |
|---|
| | | } |
|---|
| | | if (!bk.contains("2")){ |
|---|
| | | if (!bk.contains("2")&&!StringUtils.isEmpty(fs.getString("morning_work_off"))){ |
|---|
| | | fs.setValue("result_two", "上午下班未打卡"); |
|---|
| | | } |
|---|
| | | if (!bk.contains("3")){ |
|---|
| | | if (!bk.contains("3")&&!StringUtils.isEmpty(fs.getString("afternoon_work"))){ |
|---|
| | | fs.setValue("result_three", "下午上班未打卡"); |
|---|
| | | } |
|---|
| | | if (!bk.contains("4")){ |
|---|
