1 / 7

Group 06

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. Objectives.

lilka
Download Presentation

Group 06

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