Skip to content

Instantly share code, notes, and snippets.

@ffevotte

ffevotte/clocktable-by-tag.el

Created July 1, 2013 07:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ffevotte/5899058 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ffevotte/5899058 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ffevotte created this gist Jul 1, 2013.
    42 changes: 42 additions & 0 deletions clocktable-by-tag.el
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,42 @@
    (defun clocktable-by-tag/shift-cell (n)
    (let ((str ""))
    (dotimes (i n)
    (setq str (concat str "| ")))
    str))

    (defun clocktable-by-tag/insert-tag (params)
    (let ((tag (plist-get params :tags)))
    (insert "|--\n")
    (insert (format "| %s | *Tag time* |\n" tag))
    (let ((total 0))
    (mapcar
    (lambda (file)
    (let ((clock-data (with-current-buffer (find-file-noselect file)
    (org-clock-get-table-data (buffer-name) params))))
    (when (> (nth 1 clock-data) 0)
    (setq total (+ total (nth 1 clock-data)))
    (insert (format "| | File *%s* | %.2f |\n"
    (file-name-nondirectory file)
    (/ (nth 1 clock-data) 60.0)))
    (dolist (entry (nth 2 clock-data))
    (insert (format "| | . %s%s | %s %.2f |\n"
    (org-clocktable-indent-string (nth 0 entry))
    (nth 1 entry)
    (clocktable-by-tag/shift-cell (nth 0 entry))
    (/ (nth 3 entry) 60.0)))))))
    (org-agenda-files))
    (save-excursion
    (re-search-backward "*Tag time*")
    (org-table-next-field)
    (org-table-blank-field)
    (insert (format "*%.2f*" (/ total 60.0)))))
    (org-table-align)))

    (defun org-dblock-write:clocktable-by-tag (params)
    (insert "| Tag | Headline | Time (h) |\n")
    (insert "| | | <r> |\n")
    (let ((tags (plist-get params :tags)))
    (mapcar (lambda (tag)
    (setq params (plist-put params :tags tag))
    (clocktable-by-tag/insert-tag params))
    tags)))