SELECT
pp.id,
pp.state,
(SELECT item_text FROM vw_dict_item WHERE dict_code = 'project_state' AND item_value = pp.state) stateName,
pp.project_code,
pp.project_name,
bc.company_name,
bpc.profit_center_name,
wpp.turnover,
wpp.gross_profit,
IFNULL((wpp.gross_profit_rate*100),'') as gross_profit_rate
FROM pmp_project AS pp
INNER JOIN work_project_sum_base AS wpp ON wpp.project_id = pp.id
LEFT JOIN bas_company AS bc ON pp.sys_company_id = bc.id
LEFT JOIN bas_profit_center AS bpc ON pp.sys_profit_center_id = bpc.id
order by case stateName when '执行中' then 1 else 2 end
stateName项目状态:1:未生效,2:执行中,3:锁定,4:终止,5:项目结束,7:关闭,8:取消,9:活动结束',
有九个值,其中执行中排第二个,需要优先显示执行中的数据。
具体语句如下:
select * from tb order by
case 字段名 when '值' then 1 else 2
end