Budgeted vs. spent hours, etc.

Finish update to v2.1.2. Here is the file list for WN Tweaks:

+ \activecollab\public\installer\templates
- mysql_initial_data.php -- added fields in db schema
- mysql_schema.php -- added fields in db schema

+ \activecollab\public\assets\themes\Access
- theme.css

+ \activecollab\public\assets\themes\Access\images
- wn_progressbar_blue.gif
- wn_progressbar_red.gif
- wn_progressbar_green.gif
- wn_progressbar_yellow.gif

+ \activecollab\public\assets\themes\default
- theme.css

+ \activecollab\public\assets\themes\default\images
- wn_progressbar_blue.gif
- wn_progressbar_red.gif
- wn_progressbar_green.gif
- wn_progressbar_yellow.gif

+ \activecollab\public\assets\stylesheets
- uni-form.css

+ \activecollab\public\projects_icons
- wn-trend-icons-blank.gif
- wn-trend-icons-green.gif
- wn-trend-icons-red.gif
- wn-trend-icons-yellow-down.gif
- wn-trend-icons-yellow-left.gif
- wn-trend-icons-yellow-up.gif

+ \activecollab\public\assets\modules\system\stylesheets
- main.css

+ \activecollab\activecollab\angie\classes\database
- DataObject.class.php -- added "FORCE NUMERIC"

+ \activecollab\activecollab\application
- init.php -- defined several custom constants

+ \activecollab\activecollab\application\modules\system\controllers
- CompaniesController.class.php -- custom fields
- ProjectController.class.php -- custom fields

+ \activecollab\activecollab\application\modules\system\helpers
- function.wn_budget_progress.php -- new helper function
- function.select_wn_trend.php -- new helper function
- function.select_wn_projtype.php -- new helper function
- function.select_wn_billable.php -- new helper function
- function.select_wn_activity.php -- new helper function

+ \activecollab\activecollab\application\modules\system\models\companies
- Company.class.php -- custom fields

+ \activecollab\activecollab\application\modules\system\models\projects
- Project.class.php
- BaseProject.class.php

+ \activecollab\activecollab\application\modules\system\models\project_objects
- BaseProjectObject.class.php
- ProjectObject.class.php

+ \activecollab\activecollab\application\modules\system\models\users
- User.class.php

+ \activecollab\activecollab\application\modules\system\views\companies
- view.tpl -- custom fields added
- _profile_form.tpl -- custom fields

+ \activecollab\activecollab\application\modules\system\views\project
- index.tpl -- custom fields added
- _project_form.tpl -- custom fields
- _card.tpl -- custom fields
- _wn_budget_progress.tpl -- new file

+ \activecollab\activecollab\application\modules\timetracking\models\timetracking
- TimeRecord.class.php

+ \activecollab\activecollab\application\modules\timetracking\models\time_reports
- TimeReports.class.php

+ \activecollab\activecollab\application\modules\timetracking\views
- _popup.tpl -- custom fields added

+ \activecollab\activecollab\application\modules\timetracking\views\global_timetracking
- report.tpl

+ \activecollab\activecollab\application\modules\timetracking\views\timetracking
- quick_add.tpl -- custom fields added
- index.tpl -- custom fields for activity
- _time_row.tpl -- custom fields for activity
- _time_add_form -- custom fields for activity

That's it for now.

-martin.

does it works on 2.2? :)

What happened to you? Would be very nice to have this feature..fairly standard stuff you see in things like MS Project.

Acknowledging Actual vs. Estimated time and dollars is critical for successful project management, especially IT!

Would love to see it out of the box in a future version..hint hint Ilijah ;-)

Understood..I look forward to seeing updates.

Thank you,

Michael

@retouch I guess I'll have to write something. I've made so many changes to the code and the db schema at this point that it's not a straight forward patch anymore.

To give you an idea, here is what I've added (but not yet uploaded):

-- "My Activities" tab for dashboard so users can filter the "recent Activities" down to just their own. We have have right 60+ concurrent projects and 30+ users that all are working one several projects. That means the "Recent Activities" pane just becomes a blur. "My Activities" acts as a filter. In addition I've added a setting on the user setting screen so each user can decide if they want "My Activities" or "Recent Activities" as default when they go the dashboard

-- many additional settings and attributes on user screen. We'll soon also add skill set so that PM can more easily determine who to assign to a project. Ultimately we want project assignment to be drag&drop onto a calendar, and project req's will be matched with user skill set attribs.

-- budgeted $ vs invoiced $. Technically the terms are incorrect, but here is the goal: for each project we have essentially 3 costs (to the client) - prof.serv (variable or fixed), travel, hardware/software licenses (fixed). When we create the project we put in what we think the totals are, and as we invoice the client we track the actuals.

-- timerecord summary widget on dashboard - this was a big request from our users. They wanted to see (in a widget on the dashboard) how many hour they have logged for a given week and month. My widget, which I placed above the "Favorite Projects" on the right side of the dashboard, starts in collapsed mode with a summary for week and month. When you click on week, it opens up and shows the hours the user has logged (across all projects) for each weekday, and for month it shows the hour for each day of the month. There is still lots more work to do on this, but so far its a hit.

-- upcoming stuff will include a time sheet report that our customers can approve online. Some of our contracts state that we can only invoice our clients the hours/time sheets that the client has approved. This special form will be generated based on the hours that our engineers log into the system. Also working on travel approval forms and expense forms. This will allow us to tie travel expenses directly to a project which makes invoicing significantly easier.

Anyway, as you can see, there is a lot happening, but it also means that I'm hacking the AC core quite a bit. I've had to create my own Smarty plug-ins, new .tpl files, added jQuery functions, extended the db schema, and so on. So needless to say, it's no longer a straight forward patch.

However, am thinking of ways to share this with the community. Just not quite sure how. Unfortunately, my "day-job" often limits how much time I can spend on this. You should know, though, we are using all this in a production environment, so the tweaks I've made do work, and are tested daily by our users who not necessarily love to track time :)

My next action items:
1) finish next patch
2) write up basic install instructions

Thanks ...
-martin.