
It seems as though if I comment out the following line (3209) in /opt/otrs/Kernel/System/Ticket.pm that the full value of the ticket gets stored. I'll have to do some testing to see what happens if I enter a value with too many decimal places etc. The line commented out is: # $TimeUnit = int{$TimeUnit}; Might this break something else that I might not be aware of? - Pete McDonnell Manager, Technical Services Hip Interactive
-----Original Message----- From: Gerold Gruber [mailto:Gerold.Gruber@edv2g.de] Sent: Friday, February 04, 2005 11:11 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Time Accounting
In the installation I'm involved in we also use minutes (integer) as time units. At the end of the month a aggregate my units per ticket into a list and add this as appendix to my invoice, 'cause I get paid for handling tickets in this case.
So I'm also 'raw' on the database: select tn, customer_id, sum (time_unit) from time_accounting ta , ticket t where ta.ticket_id = t.id and ta.create_by = 5 and (ta.create_time >= '2005-01-01 00:00:00') and (ta.create_time < '2005-02-01 00:00:00') group by tn, customer_id order by tn;
5 is just my user id
Hth
Gerold
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
participants (1)
-
Pete McDonnell