| 1234567891011121314151617181920212223242526272829 |
- <#-- 项目岗位总览表首页数据展示-->
- select
- ad.id,
- ad.pid AS pid,
- ad.overall_situation AS overallSituation,
- ad.setter_id AS setterId,
- ad.create_name AS createName,
- ad.create_by AS createBy,
- ad.create_date AS createDate,
- ad.update_name AS updateName,
- ad.update_by AS updateBy,
- ad.update_date AS updateDate,
- ad.sys_org_code AS sysOrgCode,
- ad.sys_company_code AS sysCompanyCode,
- ad.delete_flag AS deleteFlag
- from t_bus_project_post_general ad
- left join t_s_depart tsd on tsd.id=ad.pid
- where 1 = 1
-
- <#if (projectPostGeneralDto.pid )?? && projectPostGeneralDto.pid ?length gt 0>
- and ad.pid like CONCAT('%', :projectPostGeneralDto.pid ,'%')
- </#if>
-
- and tsd.status='0'
- and ad.delete_flag='0'
-
- order by ad.create_date desc
-
|
