Timesheet

  • (2 Pages)
  • +
  • 1
  • 2

20 Replies - 832 Views - Last Post: 10 July 2019 - 05:09 AM

#16 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15215
  • View blog
  • Posts: 60,897
  • Joined: 12-June 08

Re: Timesheet

Posted 09 July 2019 - 11:20 AM

If this is a basic website then hop on top of the three parts needed: client side, server side, and DB.

Client is html, JS, CSS, and what ever pretty framework you think you need.
Server side is typically: ASP.NET, php, perl, ruby, python, etc. What ever can work with the POST from the client side to hit up the DB for queries, and get data spit back out.
DB can be any of the big, usual, three: MSSQL, MYSQL, Maria, etc.

As folk said - it's basic CRUD (create, read, update, delete) database functionality.

Login - take user name and password, compare against a table in the db, return if they are logged in or not. Session variables help once logged in. (SELECT)

Some fashion to enter time.. text boxes, numeric up/down boxes, text areas, date/time pickers, etc.

A save to write this information to another DB table (INSERT).

Figuring out your approval system.. so sending an email to a manager.. or having a 'manager dashboard' that would show for a manager to look at time.

A way for the manager to mark time as 'approved' (UPDATE)

A way for the user to remove time and start over. (DELETE)


Good luck.




Due 06/21 or due 07/12.. who knows..

View Postpython1, on 17 June 2019 - 12:08 PM, said:

[...] I need to finish this by Friday and I have been having trouble making one.

View Postpython1, on 09 July 2019 - 01:09 PM, said:

[...] It's due by the end of this week so basically I am screwed.

Was This Post Helpful? 2
  • +
  • -

#17 python1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 17-June 19

Re: Timesheet

Posted 09 July 2019 - 11:22 AM

View Postmodi123_1, on 09 July 2019 - 11:20 AM, said:

If this is a basic website then hop on top of the three parts needed: client side, server side, and DB.

Client is html, JS, CSS, and what ever pretty framework you think you need.
Server side is typically: ASP.NET, php, perl, ruby, python, etc. What ever can work with the POST from the client side to hit up the DB for queries, and get data spit back out.
DB can be any of the big, usual, three: MSSQL, MYSQL, Maria, etc.

As folk said - it's basic CRUD (create, read, update, delete) database functionality.

Login - take user name and password, compare against a table in the db, return if they are logged in or not. Session variables help once logged in. (SELECT)

Some fashion to enter time.. text boxes, numeric up/down boxes, text areas, date/time pickers, etc.

A save to write this information to another DB table (INSERT).

Figuring out your approval system.. so sending an email to a manager.. or having a 'manager dashboard' that would show for a manager to look at time.

A way for the manager to mark time as 'approved' (UPDATE)

A way for the user to remove time and start over. (DELETE)


Good luck.




Due 06/21 or due 07/12.. who knows..

View Postpython1, on 17 June 2019 - 12:08 PM, said:

[...] I need to finish this by Friday and I have been having trouble making one.

View Postpython1, on 09 July 2019 - 01:09 PM, said:

[...] It's due by the end of this week so basically I am screwed.

They moved it to 07/12.
Was This Post Helpful? 0
  • +
  • -

#18 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2915
  • View blog
  • Posts: 11,331
  • Joined: 03-December 12

Re: Timesheet

Posted 09 July 2019 - 11:29 AM

Do you have any of it completed or started?

For the non-manager, the simplest thing is just like systems like Kronos uses, enter your employee number, that's it. The back end will log the time submitted (that comes from the database request).

Were you clocked in?
-->No --> you are now
-->Yes --> now you are clocked out
sum the time for the hours.


Manager just needs a breakdown of what those times are and the total hours.
Was This Post Helpful? 1
  • +
  • -

#19 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15215
  • View blog
  • Posts: 60,897
  • Joined: 12-June 08

Re: Timesheet

Posted 09 July 2019 - 12:00 PM

Quote

They moved it to 07/12.

Still doable.. assuming you start now from nothing and plan on working a few long hours into the evening. A rudimentary version could be knocked out in an afternoon... but skillz to billz and such.
Was This Post Helpful? 0
  • +
  • -

#20 python1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 17-June 19

Re: Timesheet

Posted 09 July 2019 - 01:11 PM

View Postastonecipher, on 09 July 2019 - 11:29 AM, said:

Do you have any of it completed or started?

For the non-manager, the simplest thing is just like systems like Kronos uses, enter your employee number, that's it. The back end will log the time submitted (that comes from the database request).

Were you clocked in?
-->No --> you are now
-->Yes --> now you are clocked out
sum the time for the hours.


Manager just needs a breakdown of what those times are and the total hours.

I started but I kept getting many errors so I deleted the entire project. I asked my supervisors for help but they couldn't solve the errors.
Was This Post Helpful? 0
  • +
  • -

#21 DarenR   User is offline

  • D.I.C Lover

Reputation: 634
  • View blog
  • Posts: 4,201
  • Joined: 12-January 10

Re: Timesheet

Posted 10 July 2019 - 05:09 AM

show us the errors----
Was This Post Helpful? 1
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2