CnPack Forum


 
Subject: 自己的任务单
laney
普通灌水员
Rank: 2



UID 40677
Digest Posts 0
Credits 54
Posts 16
点点分 54
Reading Access 10
Registered 2008-7-22
Status Offline
Post at 2008-7-22 11:30  Profile | Blog | P.M. 
自己的任务单

今天浏览官方网站,刚好看到一个自己需要的功能,贴出来与大家共享


SELECT
  CASE WHEN t.status='new' THEN '#ffaa99'
       WHEN t.status='active' THEN '#f2dcdc'
       WHEN t.status='review' THEN '#e8e8bd'
       WHEN t.status='tested' THEN '#bde5d6'
       ELSE '#cacae5' END as 'bgcolor',
  t.tn AS '#',
  e.value AS '类型',
  t.status AS '状态',
  sdate(t.origtime) AS '创建时间',
  t.owner AS '创建人',
  t.subsystem AS '子系统',
  sdate(t.changetime) AS '更新时间',
  t.assignedto AS '分配给',
  t.severity AS '严重',
  t.priority AS '优先',
  t.title AS '标题'
FROM enums e, ticket t
WHERE e.type='type'
  AND e.name=t.type
  AND t.status NOT IN ('fixed','closed')
  AND t.assignedto=user()
ORDER BY t.priority, t.severity, t.origtime


Image Attachment: [效果图] {480C0345-5099-44DF-9BD3-E1EDDCB095C7}.bmp (2008-7-22 11:30, 492.26 K)

Top
 




All times are GMT++8, the time now is 2024-10-10 19:41

    本论坛支付平台由支付宝提供
携手打造安全诚信的交易社区 Powered by Discuz! 5.0.0  © 2001-2006 Comsenz Inc.
Processed in 0.009448 second(s), 9 queries , Gzip enabled

Clear Cookies - Contact Us - CnPack Website - Archiver - WAP