| | |
|---|
| | | .selectAs(DispatchUnit::getName,Member::getDuName) |
|---|
| | | .selectAs(Worktype::getName,Member::getWorkTypeName) |
|---|
| | | .selectAs(Solutions::getName,Member::getSolutionName) |
|---|
| | | .select(" case when now() between t.start_time and t.end_time then 1 else 0 end solutionsStatus ") |
|---|
| | | .select(" case when now() between t.start_time and t.end_time then 1 else 2 end solutionsStatus ") |
|---|
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,Member::getApplyId) |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .leftJoin(DispatchUnit.class,DispatchUnit::getId,Member::getDuId) |
|---|
