{"id":1200,"date":"2010-12-31T17:07:40","date_gmt":"2010-12-31T16:07:40","guid":{"rendered":"http:\/\/blog.fh-kaernten.at\/wehr\/?p=1200"},"modified":"2010-12-31T17:26:27","modified_gmt":"2010-12-31T16:26:27","slug":"last-login-patch-for-trac-usermanager-plugin","status":"publish","type":"post","link":"https:\/\/blog.fh-kaernten.at\/wehr\/2010\/12\/31\/last-login-patch-for-trac-usermanager-plugin\/","title":{"rendered":"Last login patch for Trac UserManager plugin"},"content":{"rendered":"

\n

I just have added a visit motivation <\/em>feature to the Trac <\/a>Usermanager <\/a>plugin. With the included patch set you will get an additional column Last Login<\/strong> in the “UserProfilesList” macro.<\/p>\n

\"\"<\/a><\/p>\n

This patch applies to UserManager <\/a>plugin rev 5520\u00a0 \ud83d\ude42<\/p>\n

--- macros.py\t(revision 300)\r\n+++ macros.py\t(revision 301)\r\n@@ -10,6 +10,8 @@\r\n from trac.wiki.macros import WikiMacroBase\r\n from trac.wiki.formatter import wiki_to_html\r\n from trac.web.chrome import Chrome, add_stylesheet, add_script\r\n-from trac.util.datefmt import format_datetime\r\n+from trac.util.datefmt import format_datetime, to_datetime\r\n+from datetime import datetime\r\n\r\n from tracusermanager.api import UserManager, User\r\n from tracusermanager.profile.api import UserProfileManager, IUserProfilesListMacroCellContributor\r\n@@ -72,9 +73,29 @@\r\n             data['user_profiles'] = UserManager(self.env).search_users(user_profile_templates)\r\n         else:\r\n             data['user_profiles'] = UserManager(self.env).get_active_users()\r\n-\r\n+\r\n+        db = self.env.get_db_cnx()\r\n+        cursor = db.cursor()\r\n+        cursor.execute(\"SELECT sid,last_visit FROM session WHERE authenticated=1\")\r\n+        last_visits={}\r\n+        for username, last_visit in cursor:\r\n+          for user in  data['user_profiles']:\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 date_diff = datetime.now().date()\u00a0 - datetime.date(to_datetime(last_visit))\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if date_diff.days > 1:\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 user['last_visit'] = \"%d days ago\" % date_diff.days\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 elif date_diff.days == 1:\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 user['last_visit'] = \"%d day ago\" % date_diff.days\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 user['last_visit'] = \"today\"\r\n+\r\n+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 #user['last_visit'] = format_datetime(last_visit,\"%b %d.%m.%Y %H:%M:%S\")\r\n+\r\n+\r\n         data['cells']=list(self._get_cells(data['user_profiles']))\r\n-\r\n+\r\n         # add stylesheet&script\r\n         add_stylesheet(formatter.req,'tracusermanager\/css\/macros_um_profile.css')\r\n         add_script(formatter.req,'tracusermanager\/js\/macros_um_profile.js')\r\n@@ -102,8 +113,9 @@\r\n         yield ('name', _('Name'),0)\r\n         yield ('email', _('Email'),1)\r\n         yield ('role', _('Role'),2)\r\n+        yield ('last_visit', _('Last login'),3)\r\n     def render_userlistmacro_cell(self, cell_name, user):\r\n-        \"\"\"Should render user cell\"\"\"\r\n+        \"\"\"Should render user cell\"\"\"\r\n         return user[cell_name]\r\n\r\n class TeamRosterMacro(UserProfilesListMacro):<\/pre>\n
have fun<\/p>\n","protected":false},"excerpt":{"rendered":"
I just have added a visit motivation feature to the Trac Usermanager plugin. With the included patch set you will get an additional column Last Login in the “UserProfilesList” macro. This patch applies to UserManager plugin rev 5520\u00a0 \ud83d\ude42 — macros.py (revision 300) +++ macros.py (revision 301) @@ -10,6 +10,8 @@ from trac.wiki.macros import WikiMacroBase … Continue reading Last login patch for Trac UserManager plugin<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"ngg_post_thumbnail":0,"footnotes":""},"categories":[7],"tags":[11],"class_list":["post-1200","post","type-post","status-publish","format-standard","hentry","category-cool-tools","tag-trac"],"_links":{"self":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/1200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/comments?post=1200"}],"version-history":[{"count":0,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/1200\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/media?parent=1200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/categories?post=1200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/tags?post=1200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}