lilka
Uploaded by
7 SLIDES
205 VUES
70LIKES

Automated OT Calculation System for Non-Academic Staff at University of Ruhuna

DESCRIPTION

This project presents an automated system for calculating overtime (OT) for non-academic staff at the University of Ruhuna, based on daily attendance records captured via a fingerprint machine. Key features include automatic data transfer from an MS Access database to MySQL, real-time OT hour calculation, and online submissions for OT vouchers, pre-request OT, and leave forms. Department heads can manage requests and view attendance, facilitating streamlined communication and documentation. The system aims to enhance efficiency and accuracy in overtime management.

1 / 7

Télécharger la présentation

Automated OT Calculation System for Non-Academic Staff at University of Ruhuna

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automated OT calculation for Non Academic staff based on the daily attendance obtained from finger print machine Group 06 Department of Computer Science University of Ruhuna Matara

  2. Objectives • Implement Automated OT calculation system for non-academic staff based on the daily attendance. Main Functions • Automatically copy Finger print records from MS Access Database to Our MySQL database every one minute by using Linux Cron job. • System can calculate OT hours of each day, according to employee’s finger print records. • Employee can view their worked OT hours & they can submit their OT voucher by online. • Employees can submit pre request OT form online. • Employees can submit leave form online. • Department head can accept or reject employee’s OT forms or leaves who is in his/her department. • Department head can view daily attendance of each employee who works in his/her department. • Officer of in charge who handle the OT can check the OT forms of every non academic employee & submit it to finance branch through this system. General Objective

  3. Database Structure • EER Diagram • Database name: cs2012g6 • Tables • attend_tb • cron_service • department • group_tb • leave_type • monthly_leave • month_ot • ot_days • permission • role • role_infor • user_group • year_leave

  4. Used Software PHP 5.3.5 My SQL 5.5.8 Apache 2.2.1.7 Notepad++ Adobe PhotoShop CS 3 Adobe Flash CS3 Professional CorelDRAW 12

  5. Time Line Procedure Time

  6. Task List • Cordinate project tasks as a team leader. • Design the database & software architecture. • Design OT hours calculation method in the system. G.K.D.D. Jayasinghe.(SC/2009/7216) • Analyze system requirements. • Design OT pre-request procedure & interface. W.H.J. Jinasena.(SC/2009/7247) • Design leave form procedure & interface. • Design employee profile view form. A.M.N.S. Attanayaka. (SC/2009/7272) • Design OT form interface. • Design Employee data entering page to database. D.N.P. Athukorala. (SC/2009/7195) • Design employee notice panel. • Design footer part of the web page. J.R.K. Jayasiri. (SC/2009/7218) • Design login form user status panel. • Design Contact page. B.M.K.L. Bandara.(SC/2009/7316)

  7. Thank You!

More Related