By trickyricky26 on

Hello does anyone have any suggestions (or modules) on how I would go about using my freelance site as a portal where I can track my freelance hours and have the ability to show them on invoices (also clients paying online for hours spent would be amazing). any help would be appreciated!

⋅ Categories: Drupal 6.x

Comments

davidredshaw’s picture

davidredshaw commented

You should be able to start with a CCK content type for Client, Project and Time. Include a node reference in the Time node to link to the project and also include hours worked, date, invoice etc. Then you can use Views to view the hours worked and add arguments for client, project and date.

David

trickyricky26’s picture

trickyricky26 commented

Sorry if this is a newbie question but any idea how I would go about adding time sheets together to get total hours?

davidredshaw’s picture

davidredshaw commented

It's possible there's a "Views Summary" option or module although I can't find one. The only other way would be to output a table and then add the summary yourself using PHP in the template file.

David

trickyricky26’s picture

trickyricky26 commented

David,

I think I found what I was looking for. It uses the "computed field" cck module. The only downside is that you have to use custom php snippets to add the values together and my background is in design not php coding so it's a bit frustrating.

Thanks for your direction, I think I have all the right tools to get where I want to be.

-Rick

Ashford’s picture

Ashford commented

Add the Views_Calc module to your tool box.

You use the Views module to generate a Page. After selecting your Filters and Fields for the node data you want in your list, you select the page Style: ViewsCalc. You will have the option to perform various math functions, such as Total or Average, on the rows or columns that you select.