| | |
|---|
| | | left join sjzt_md."att_ad_base" ad on ad."ad_code" = arb."interior_ad_guid" |
|---|
| | | left join sjzt_md."att_ad_base" ad2 on ad2."ad_code" = ad."p_ad_code" |
|---|
| | | left join sjzt_md."att_ad_base" ad3 on ad3."ad_code" = ad2."p_ad_code" |
|---|
| | | <if test="attWmstBaseVO.adCode != null and attWmstBaseVO.adCode !=''"> |
|---|
| | | where concat(ad."ad_code",ad2."ad_code",ad3."ad_code") like concat(#{attWmstBaseVO.adCode},'%') |
|---|
| | | </if> |
|---|
| | | <where> |
|---|
| | | <if test="attWmstBaseVO.adCode != null and attWmstBaseVO.adCode !=''"> |
|---|
| | | and concat(ad."ad_code",ad2."ad_code",ad3."ad_code") like concat('%',#{attWmstBaseVO.adCode},'%') |
|---|
| | | </if> |
|---|
| | | <if test="attWmstBaseVO.online != null and attWmstBaseVO.online !=''"> |
|---|
| | | and awb."online" = #{attWmstBaseVO.online} |
|---|
| | | </if> |
|---|
| | | <if test="attWmstBaseVO.sysResource != null and attWmstBaseVO.sysResource !=''"> |
|---|
| | | and awb."sys_resource" = #{attWmstBaseVO.sysResource} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | |
|---|
| | | </select> |
|---|
| | | </mapper> |
|---|
