| | |
|---|
| | | |
|---|
| | | |
|---|
| | | <select id="selectGdFlyerPage" resultMap="gdFlyerResultMap"> |
|---|
| | | select * from ja_gd_flyer where is_deleted = 0 |
|---|
| | | select * from ja_gd_flyer |
|---|
| | | <where> |
|---|
| | | <if test="param2.flyerName != null and param2.flyerName != ''"> |
|---|
| | | and flyer_name like concat('%',#{param2.flyerName},'%') |
|---|
| | | </if> |
|---|
| | | <if test="param2.flyerPhone != null and param2.flyerPhone != ''"> |
|---|
| | | and flyer_phone like concat('%',#{param2.flyerPhone},'%') |
|---|
| | | </if> |
|---|
| | | <if test="param2.technicalStrength != null and param2.technicalStrength != ''"> |
|---|
| | | and technical_strength = #{param2.technicalStrength} |
|---|
| | | </if> |
|---|
| | | <if test="param2.skilledUavType != null and param2.skilledUavType != ''"> |
|---|
| | | and skilled_uav_type = #{param2.skilledUavType} |
|---|
| | | </if> |
|---|
| | | <if test="param2.skilledTaskType != null and param2.skilledTaskType != ''"> |
|---|
| | | and skilled_task_type = #{param2.skilledTaskType} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | |
|---|
