| | |
|---|
| | | having current_process_type <>5 |
|---|
| | | </select> |
|---|
| | | <select id="expertRate" resultType="com.panzhihua.common.model.vos.sanshuo.EventRateVO"> |
|---|
| | | select count(t.id) as count,t1.level as type from com_sanshuo_event_info t |
|---|
| | | left join com_sanshuo_expert t1 on t.specialist_id=t1.id |
|---|
| | | where t.event_process_status not in(7,8,9) |
|---|
| | | group by t1.level |
|---|
| | | having type is not null |
|---|
| | | select count(id) as count,level as type from com_sanshuo_expert |
|---|
| | | group by level |
|---|
| | | </select> |
|---|
| | | <select id="mediateTypeRate" resultType="com.panzhihua.common.model.vos.sanshuo.EventRateVO"> |
|---|
| | | select count(t.id) as count,t1.name from com_sanshuo_event_info t |
|---|
