Please or Register to create posts and topics.

Asking for timesheet period of timesheet for new user

When a new user clicks on the 'New Timesheet' button, the application by default creates a 'Weekly' timesheet for him. Instead of this, the timesheet should ask once before setting the default as 'Weekly'. General users can't change time sheet period and they have to work with 'Weekly' time sheet till it is changed by admin.

In order to do this effectively, what you need to do is to create a new role that you want user to be a member of. You can create this role using the OfficeClip Setup. Now go to the database and list the content of the roles table. Note the value of the role_id (which is a unique key).

Now go to the stored procedure InsInviteMemberSP (in file Sql\Queries\invitemember.sql) and at the bottom of the stored procedure add the following code:

Code:

 EXECUTE GetUserPayrollInfoSP @userId 

A more robust way of doing is to add a group property that will allow this selection by the administrator