看板字体颜色需求 --计划本色，mo_start_time小于半个小时而且状态是计划为红色；缺料为黄色；备料和配送为绿色；；完结的只显示当天为本色

SQL我这边可以提供，初步框架 select mo_start_time,mo_lot,omes_stock_prepartion1.part_no,opur_pur2.sheet_qty, '留样数',device_no,stock_sta,user_no,'终端客户',omes_stock_prepartion1.rem,omes_stock_prepartion1.audit_date, omes_stock_prepartion1.stock_qty,dc,pro_start_time,pro_qty,'2表备注' from omes_stock_prepartion1 left join opur_pur2 on omes_stock_prepartion1.mo_lot=opur_pur2.sheet_lot left join omes_stock_prepartion2 on omes_stock_prepartion1.id=omes_stock_prepartion2.sheet_id where omes_stock_prepartion1.mo_start_time=getdate() or (omes_stock_prepartion1.mo_start_time<>GETDATE() and stock_sta<>'4')