if
@Select({"<script>",
"SELECT " +
" mu.id userId, " +
" eui.id userInfoId, " +
" mu.user_name userName, " +
" com.company_id AS comId, " +
" com.company_name comName, " +
" eui.talent_type talentType, " +
" eui.self_introduction selfIntroduction, " +
" eui.working_years workingYears, " +
" eui.education education, " +
" mu.icon_url iconUrl " +
" FROM " +
" mky_user mu, " +
" em_company c, " +
" em_company_record com, " +
" em_user_info eui, " +
" em_aptitude_maintain_approve ea " +
" WHERE 1=1 ",
" <when test=‘searchStr!=null‘> ",
" AND ( mu.user_name LIKE #{searchStr} OR com.company_name LIKE #{searchStr} ) ",
" </when> ",
" <when test=‘firstId!=null‘> ",
" AND ea.first_id = #{firstId} ",
" </when> ",
" <when test=‘secondId!=null‘> ",
" AND ea.second_id = #{secondId} ",
" </when> ",
" <when test=‘threeId!=null‘> ",
" AND ea.three_id = #{threeId} ",
" </when> ",
" <when test=‘startDate!=null‘> ",
" AND ea.end_date > #{startDate} ",
" </when> ",
" <when test=‘endDate!=null‘> ",
" AND ea.end_date < #{endDate} ",
" </when> ",
" AND c.id = com.company_id " +
" AND mu.com_id = c.id " +
" AND mu.id = eui.user_id " +
" AND eui.page_display_flag = 1 " +
" AND ea.user_info_id = eui.id " +
" AND ea.end_date > DATE_FORMAT( now( ), ‘%Y-%m-%d‘ ) " +
" AND mu.del_flag = 0 " +
" AND ea.del_flag = 0 " +
" AND eui.del_flag = 0 " +
" AND c.del_flag = 0 " +
" AND com.del_flag = 0 " +
" GROUP BY eui.id " +
" ORDER BY " +
" eui.update_date DESC " +
" </script> "})
List<TalentsResultVo> selectAllTalentsByParams(@Param("firstId") String firstId, @Param("secondId") String secondId, @Param("threeId") String threeId, @Param("startDate") String startDate, @Param("endDate") String endDate, @Param("searchStr") String searchStr);
循环
@Select({
" <script> ",
" select ",
" id ,stream_id ‘streamId‘ , project_id ‘projectId‘ ,push_stream_addr ‘pushStreamAddr‘ , rtmp_play_addr ‘rtmpPlayAddr‘ , flv_play_addr ‘flvPlayAddr‘ , hls_play_addr ‘hlsPlayAddr‘ , monitor_state ‘monitorState‘, monitor_name ‘monitorName‘ , note, state_reason ‘stateReason‘ , ip_addr ‘ipAddr‘ ",
" from bi_real_time_monitoring ",
" where project_id in ",
" <foreach collection=‘projectIds‘ item=‘id‘ open=‘(‘ separator=‘,‘ close=‘)‘> ",
" #{id} ",
" </foreach> ",
" and delFlag =0 and monitor_state != 2 ",
" </script> "
})
List<BiRealTimeMonitoring> selectBiRealTimeMonitoringByProjectIds(@Param("projectIds") List<String> projectIds);
注意一个报错
注意一个报错