求助，我想让图例按照一定顺序排列，并且周数（例如‘2024-11’）同时也要排序怎么实现呢，我现在的周数是乱的。select * from(SELECT distinct si_cReason 体系, concat(YEAR(bi_cTime) ,'-',bi_cWeek) 日期 ,bi_nQuantity 数量, YEAR(bi_cTime) 年 ,WEEK(bi_cTime) 周,si_cDepartment 部门,si_cFillnoFROM t_system_info systemleft join t_basic_info basic on basic.bi_cFillno = system.si_cFillnoright join (SELECT num,类别 from (SELECT 1 as num,'体系不合理' as 类别 union all SELECT 2,'体系未执行' union all select 3,'无体系' union all SELECT 4,'待确认') numbers)a on a.类别 = system.si_cReasonwhere 1=1${if(len(starttime)=0,""," and DATE_FORMAT(bi_cTime,'%Y-%m')>='"+starttime+"'")}${if(len(endtime)=0,""," and DATE_FORMAT(bi_cTime,'%Y-%m') <='"+endtime+"'")}${if(fine_username="Alice","and basic.bi_cType in ('原材料','半成品','成品') ",if(fine_username="Mike","and basic.bi_cType in ('客户','成品') ",""))}ORDER BY concat(YEAR(bi_cTime) ,'-',WEEK(bi_cTime)))bright join (SELECT num,类别 from (SELECT 1 as num,'体系不合理' as 类别 union all SELECT 2,'体系未执行' union all select 3,'无体系' union all SELECT 4,'待确认') numbers)a on a.类别 = b.体系
