select case when fstatus ='提交' then '已提报'else '未提报' end as ftype,count(0)fcount  from tsubmitedit
where siteid=$siteid$ and tsubmiteditmodelid=$tsubmiteditmodelid$ group by case when fstatus ='提交' then '已提报'else '未提报' end