<#-- 项目岗位总览表首页数据展示-->

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