| 1234567891011121314151617181920212223242526 |
- select
- rating.id as id,
- rating.years as years,
- rating.bonus as bonus,
- rating.projectWage as projectWage,
- rating.mark as mark,
- rating.description as description,
- prj.jianguan_leader as jianguanLeader,
- prj.xianchang_leader as xianchangLeader,
- prj.code as projectCode,
- prj.id as projectId,
- prj.name as projectName,
- prj.jianguan_weight as jianguanWeight,
- IF(rating.mark is null,"否","是") as isSet
-
- from t_b_project prj
-
- left join t_bus_project_rating rating on rating.projectId=prj.id
- <#if (projectRatingDto.years )?? && projectRatingDto.years ?length gt 0>
- /* years */
- and rating.years = :projectRatingDto.years
- </#if>
- where 1=1
-
- order by CONVERT(prj.name USING gbk)
-
|
