-- ## 15: Tickets in progress ## --

SELECT DISTINCT 'background: #99FF66;' as __style__, t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
   FROM ticket t, ticket_custom p
WHERE 
p.ticket = t.id and 
(
(t.status = 's1a_analysis_started' and ((p.name = 'analysis_owners' and p.value LIKE '%$USER%'))) 
or (t.status = 's2a_design_started' and ((p.name = 'design_owners' and p.value LIKE '%$USER%'))) 
or (t.status = 's3a_implementation_started' and ((p.name = 'implementation_owners' and p.value LIKE '%$USER%')))
or (t.status = 's4a_test_started' and ((p.name = 'test_owners' and p.value LIKE '%$USER%'))))
UNION
SELECT DISTINCT 'background: #FF6666;' as __style__, t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
   FROM ticket t, ticket_custom p
INNER JOIN ticket_custom p2
ON p.ticket=p2.ticket
WHERE 
p.ticket = t.id 
and ((p.name LIKE '%owners' and p.value LIKE '%$USER%')
and (p2.name LIKE '%score' and p2.value < '3' and p2.value > '0'))
UNION 
SELECT DISTINCT 'background: #FFCC33;' as __style__, t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
   FROM ticket t
WHERE 
t.cc LIKE '%$USER%'
UNION
SELECT DISTINCT 'background: #33CCFF;' as __style__, t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
FROM ticket t, ticket_custom p
WHERE 
p.ticket = t.id and 
t.status = 's2c_design_ok' and ((p.name = 'design_owners' and p.value LIKE '%$USER%'))