def filter_stream(self, req, method, filename, stream, data):
"""
filter the stream for the roadmap (/roadmap)
and milestones /milestone/<milestone>
"""
if filename in ('roadmap.html', 'milestone_view.html'):
trachours = TracHoursPlugin(self.env)
hours = {}
milestones = data.get('milestones')
this_milestone = None
if milestones is None:
# /milestone view : only one milestone
milestones = [ data['milestone'] ]
this_milestone = milestones[0].name
find_xpath = "//div[@class='milestone']//h1"
xpath = "//div[@class='milestone']//div[@class='info']"
else:
# /roadmap view
find_xpath = "//li[@class='milestone']//h2/a"
xpath = "//li[@class='milestone']//div[@class='info']"
for milestone in milestones:
hours[milestone.name] = dict(totalhours=0.,
estimatedhours=0.,)
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute("select id from ticket where milestone=%s", (milestone.name,))
tickets = [i[0] for i in cursor.fetchall()]
if tickets:
hours[milestone.name]['date'] = Ticket(self.env, tickets[0]).time_created
for ticket in tickets:
ticket = Ticket(self.env, ticket)
# estimated hours for the ticket
try:
estimatedhours = float(ticket['estimatedhours'])
except (ValueError, TypeError):
estimatedhours = 0.
hours[milestone.name]['estimatedhours'] += estimatedhours
# total hours for the ticket (seconds -> hours)
totalhours = trachours.get_total_hours(ticket.id) / 3600.0
hours[milestone.name]['totalhours'] += totalhours
# update date for oldest ticket
if ticket.time_created < hours[milestone.name]['date']:
hours[milestone.name]['date'] = ticket.time_created
b = StreamBuffer()
stream |= Transformer(find_xpath).copy(b).end().select(xpath).append(self.MilestoneMarkup(b, hours, req.href, this_milestone))
return stream
def add_hours_by_comment(self, comment, ticket, worker):
"""
add hours to a ticket via a comment string
* comment : the comment string
* ticket : the id of the ticket
* worker : who worked the hours
"""
trachours = TracHoursPlugin(self.env)
for match in re.finditer(self.hours_regex, comment):
hours = match.groups()[0]
if ':' in hours:
hours, minutes = hours.split(':')
seconds = 3600.0*float(hours) + 60.0*float(minutes)
else:
seconds = 3600.0*float(hours)
_comment = re.sub('\[/hours/[0-9]+ ' + self.hours_regex + '\]', match.group(), comment)
trachours.add_ticket_hours(ticket, worker, seconds, comments=_comment)
for match in re.finditer(self.singular_hour_regex, comment):
_comment = re.sub('\[/hours/[0-9]+ 1 hour\]', '1 hour', comment)
trachours.add_ticket_hours(ticket, worker, 3600.0, comments=_comment)
def add_hours_by_comment(self, comment, ticket, worker):
"""
add hours to a ticket via a comment string
* comment : the comment string
* ticket : the id of the ticket
* worker : who worked the hours
"""
trachours = TracHoursPlugin(self.env)
for match in re.finditer(self.hours_regex, comment):
hours = match.groups()[0]
if ':' in hours:
hours, minutes = hours.split(':')
seconds = 3600.0 * float(hours) + 60.0 * float(minutes)
else:
seconds = 3600.0 * float(hours)
_comment = re.sub('\[/hours/[0-9]+ ' + self.hours_regex + '\]',
match.group(), comment)
trachours.add_ticket_hours(ticket,
worker,
seconds,
comments=_comment)
for match in re.finditer(self.singular_hour_regex, comment):
_comment = re.sub('\[/hours/[0-9]+ 1 hour\]', '1 hour', comment)
trachours.add_ticket_hours(ticket,
worker,
3600.0,
comments=_comment)
def filter_stream(self, req, method, filename, stream, data):
"""
filter the stream for the roadmap (/roadmap)
and milestones /milestone/<milestone>
"""
if filename in ('roadmap.html', 'milestone_view.html') and \
'TICKET_VIEW_HOURS' in req.perm:
trac_hours = TracHoursPlugin(self.env)
hours = {}
milestones = data.get('milestones')
this_milestone = None
if milestones is None:
# /milestone view : only one milestone
milestones = [data['milestone']]
this_milestone = milestones[0].name
find_xpath = "//div[@class='milestone']/h1"
xpath = "//div[@class='milestone']/div[1]"
else:
# /roadmap view
find_xpath = "//*[@class='milestone']//h2/a"
xpath = "//*[@class='milestone']/div[1]"
for milestone in milestones:
hours[milestone.name] = dict(
totalhours=0.,
estimatedhours=0.,
)
tickets = [
tid for tid, in self.env.db_query(
"""
SELECT id FROM ticket WHERE milestone=%s
""", (milestone.name, ))
]
if tickets:
hours[milestone.name]['date'] = \
Ticket(self.env, tickets[0])['time']
for ticket in tickets:
ticket = Ticket(self.env, ticket)
# estimated hours for the ticket
try:
estimated_hours = float(ticket['estimatedhours'])
except (ValueError, TypeError):
estimated_hours = 0.
hours[milestone.name]['estimatedhours'] += estimated_hours
# total hours for the ticket (seconds -> hours)
total_hours = trac_hours.get_total_hours(
ticket.id) / 3600.0
hours[milestone.name]['totalhours'] += total_hours
# update date for oldest ticket
if ticket['time'] < hours[milestone.name]['date']:
hours[milestone.name]['date'] = ticket['time']
b = StreamBuffer()
stream |= Transformer(find_xpath).copy(b).end().select(xpath). \
append(
self.MilestoneMarkup(b, hours, req.href, this_milestone))
return stream
def ticket_deleted(self, ticket):
TracHoursPlugin(self.env).delete_ticket_hours(ticket.id)
def ticket_deleted(self, ticket):
"""Called when a ticket is deleted."""
TracHoursPlugin(self.env).delete_ticket_hours(ticket.id)
