Hi Jan, sorry for the long delay. On Sat, Jan 18, 2003 at 09:42:57PM +0100, Jan Kneschke wrote:
Is there a good way to get accumulated time units per customer ?
That would ease writing invoices for each customer at the end of the month a lot.
If would do this: Accounted time per ticket: "SELECT tt.tn, tt.customer_id, sum(ta.time_unit) FROM ticket tt, time_accounting ta WHERE tt.id = ta.ticket_id AND ta.create_time >= '2003-01-01 00:00:01' and ta.create_time <= '2003-01-31 23:59:59' GROUP BY tt.id" Accounted time per customer: "SELECT tt.customer_id, sum(ta.time_unit) FROM ticket tt, time_accounting ta WHERE tt.id = ta.ticket_id AND ta.create_time >= '2003-01-01 00:00:01' and ta.create_time <= '2003-01-31 23:59:59' GROUP BY tt.customer_id" You need to write a little script which do this query with the write time stamps. Is it what you are looking for?
Jan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 233 Tage bis zum Gäubodenvolksfest! ;-)