meidu2021/daju/target/classes/cn/com/lzt/talentsubsidy/sql/UserTalentSubsidyMiniDao_getAllEntities.sql

select talent.id id,
		talent.user_id userid,
		du.id dutiesid,
		talent.description as description,
		if(talent.money < 0,talentStrategy.money, talent.money) as money,
		talent.talent_strategy_id talentStrategyId,
		talentStrategy.factor talentStrategyName,
		if(talent.money < 0, '1','0') as isDefaultMoney,
	u.realname as realname,sus.userNum as userNum, d.departname,d.id as departid,du.duties_name as dutiesname from t_bus_user_talent_subsidy talent
	left join t_s_base_user u on u.id = talent.user_id
	left join t_s_user sus on u.id= sus.id 
	LEFT JOIN t_s_user_org uo ON u.ID = uo.user_id and uo.ifpluralism = 0 and uo.status = 0
	left join t_s_depart d on uo.org_id = d.id 
	left join t_bus_user_personnel p on p.userid = u.id 
	left join t_bus_duties du on du.id = p.belong_dutiesid
	left join t_bus_talent_subsidy_strategy talentStrategy on talentStrategy.id = talent.talent_strategy_id
	where 1=1
		and talent.delete_flag != '1' and u.delete_flag != '1'
		<#if (userquery)?? && userquery ?length gt 0>
		    /* 员工 */
			and u.id = :userquery
		</#if>