| | |
|---|
| | | |
|---|
| | | <select id="selectLastNext" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO"> |
|---|
| | | select(select min(id) from com_act_acid_record where id > #{id} and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like |
|---|
| | | concat('%',#{localCity},'%')</if>) next_id, |
|---|
| | | concat('%',#{localCity},'%')</if>) last_id, |
|---|
| | | (select max(id) as next_id from com_act_acid_record where #{id} > id and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like |
|---|
| | | concat('%',#{localCity},'%')</if>) last_id |
|---|
| | | concat('%',#{localCity},'%')</if>) next_id |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="selectAcidCount" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidChartsVO"> |
|---|
