Mercurial > getan
changeset 190:4f1c53bd8ba1
Remove whitespace
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Thu, 17 Jan 2013 11:39:52 +0100 |
parents | 737e69369873 |
children | 64624032611d |
files | getan/contrib/zeiterfassung.py |
diffstat | 1 files changed, 28 insertions(+), 28 deletions(-) [+] |
line wrap: on
line diff
--- a/getan/contrib/zeiterfassung.py Thu Dec 13 16:00:32 2012 +0100 +++ b/getan/contrib/zeiterfassung.py Thu Jan 17 11:39:52 2013 +0100 @@ -55,22 +55,22 @@ ''' WEEK_ENTRIES = ''' -SELECT - date(start_time) AS t, - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time) AS t, + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND (description IS NULL or length(description) = 0) -- trim() function is missing AND (strftime('%W', start_time) = :week OR strftime('%W', stop_time) = :week) GROUP BY round(julianday(start_time)) UNION SELECT date(start_time) AS s, strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND description IS NOT NULL AND length(description) > 0 AND (strftime('%W', start_time) = :week OR strftime('%W', stop_time) = :week) @@ -78,38 +78,38 @@ ''' ENTRIES = ''' -SELECT - date(start_time), - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time), + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (description IS NULL or length(description) = 0) -- trim() function is missing GROUP BY round(julianday(start_time)) UNION SELECT date(start_time), strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND description IS NOT NULL AND length(description) > 0 ''' ENTRIES_YEAR = ''' -SELECT - date(start_time), - sum(strftime('%s', stop_time) - strftime('%s', start_time)), +SELECT + date(start_time), + sum(strftime('%s', stop_time) - strftime('%s', start_time)), 'no description' AS description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (description IS NULL or length(description) = 0) -- trim() function is missing GROUP BY round(julianday(start_time)) UNION SELECT date(start_time), strftime('%s', stop_time) - strftime('%s', start_time), description -FROM entries -WHERE - project_id = :project_id AND +FROM entries +WHERE + project_id = :project_id AND (strftime('%Y', start_time) ) = :year AND description IS NOT NULL AND length(description) > 0 ''' @@ -242,7 +242,7 @@ if row or empty_proj: print "# project: %s (%s)" % (project, proj_desc) while row: - d = date(*map(int, row[0].split('-'))) + d = date(*map(int, row[0].split('-'))) t = max(60, row[1]) c = row[2] total_proj += t