SELECT
   zs.title 需求名称,
	zs.pri 需求优先级,
	(
		CASE zs. STATUS
		WHEN 'draft' THEN
			'草稿'
		WHEN 'active' THEN
			'激活'
		WHEN 'closed' THEN
			'已关闭'
		WHEN 'changed' THEN
			'已变更'
		END
	) 当前状态,
	(
		CASE zs.stage
		WHEN 'wait' THEN
			'未开始'
		WHEN 'planned' THEN
			'已计划'
		WHEN 'projected' THEN
			'已立项'
		WHEN 'developing' THEN
			'研发中'
		WHEN 'developed' THEN
			'研发完毕'
		WHEN 'testing' THEN
			'测试中'
		WHEN 'tested' THEN
			'测试完毕'
		WHEN 'verified' THEN
			'已验收'
		WHEN 'released' THEN
			'已发布'
		WHEN 'closed' THEN
			'已关闭'
		END
	) 所处阶段
FROM
	zt_story zs