Sharepoint 2007 web part / list calculation

  • Posted
  • Proposals 3
  • Remote
  • #18038
  • Expired
Nigel B.Amar G.6Sense T. have already sent a proposal.
  • 0

Description

Experience Level: Expert
We have a SharePoint list consisting of timecard submissions. Each line contains the staff members payroll number, name, date of shift, hours, hourly rate and department. A custom action/web part is required to:

A) Give manager ability to select each entry inline, eg by a check box on each line in the list view and then a custom action to Approve each selected entry (with approval date and who approved the entry). Only people with a custom permission should be able to approve entries. This permission can then be assigned to supervisors so they can approve entries but not manage the list.

B)A custom action that takes all entries in the list that are marked as approved but not marked as Submitted and then groups by payroll number column and hourly rate column and then totals the hours. A excel spreadsheet is then saved to a document library with the totalled information and all lines that were processed are marked as submitted (including the date they were submitted). The end result should be a line for each member of staff and each hourly rate they have worked at. Another excel spreadsheet is produced totalling the amount paid (hourly rate multiplied by hours) for each department using the same lines as the previous spreadsheet.

C) A web part that is for the user (staff that submits pay entries) to see what entries have been submitted eg last 10 entries, their approval and submission status and date of approval/submission. A simple list part designed to be displayed at the right side of a page.

If you need more details please contact us through the clarification board.

Thanks.

Clarification Board

    There are no clarification messages.