User Manual - Lovell Felix
Contents
1. 1 Bidg ID int 11 ContactLastName varchar 30 MiscID int 11 StelD int 1 9 BldgName varchar 30 ContactMidName varchar 25 UWEmplID int 11 ContactStreetAddress varchar 50 ConID int 11 ContactCity varchar 25 3 ContactState varchar 15 ContactZip int 11 ContactHomePhone int int 11 ContactWorkPhone Integer int 11 8 UWEmplD int 11 UWYear int 11 UWType varchar 10 4 UWAmount int 11 EmplD varchar 255 8 EuDbID 9 cpsq 322 8 nA wv wonur ur TT MALLADE Sucpsu TO Viewing Referential Integrity Rules l Select one of the tables in the database 2 Click the structure tab 3 Select Relational View as indicated in the following diagram Page 18 of 23 phpMyAdmin g Sever localhost y B Database systems y Table building 4 Browse K Structure ASAL Search jelnsert FEExport flmport f Operations fEmpty X Drop Field Type Collation Attributes Null Default Extra Action Database BldglD int 11 No None auto increment E YX ADET ene d p BidgName varcha 30 uff general ci Yes NULL f X T systems 13 t CheckAll Uncheck All With selected E 2 X Building Print view da Relation view G Propose table structure 4 System redirects to Link view with the referential integrity Example User Table LINKS tO Internal relations FOREIGN KEY INNODB EmplD v systems employee EmplD H ON DE2. HR FUNCTIONS Manage USER Employees View Employees Add Employee HELP User Manual rc m Dir O REPORT MENU QUICK LINKS Home mpio uction Employee Search Maxim Hour P Hour vorker Control Pane List of Employee recieving Annual Salary Page 14 of 23 Home Employee Directory Management Figure 1 12 Shows the Employee Deduction Report HR Function Logout REPORT MENU Deductions First Name Last Name Request Date Deduction Type Amount Lovell Felix 2009 11 03 United way 20 00 Bill Right 2010 05 21 Parking 30 00 Jonas Hope 2010 04 13 extra life Insurance 30 00 John Doe 2010 05 02 pre tax medical 25 00 Daleyann Alexander 2010 04 04 Pension 55 00 Sally May 1998 01 10 parking 10 00 Otus Primus 1998 02 02 extra life insurance 85 00 Billy John 1998 04 05 pre tax medication 345 00 Grant Steven 1998 04 05 pension 90 00 Steven Grant 1998 01 05 pension 123 00 Majak Mireck 2009 11 03 Parking 10 00 Frant Alexander 2010 05 21 extra life Insurance 90 00 Julia Steven 2010 04 13 pre tax medical 125 00 Frank Jack 2010 05 02 Pension 185 00 Jane James 2010 04 04 parking 20 00 1 2 Next B Management Reports l Click on Management link on links menu Requires a Manager level credential login to view 2 Click on View United Way Contribution 3 System display report page as illustrated in figure 1 13 Page 15 of 23 Figure 1 13 Shows the Employee Deduction Report REPORT MENU United Way Contributi
3. A 1 Information Systems Local Intranet User Manual VI VII VIII Xl XII XIII Table of Contents INTRODUC HON m 3 ACCE ICS 5S INIRANE c 4 LOGIN TO THE SS S29 EM T s UPDATING U ER PROFEE cosie A E E EMPLOYEE SEARG acd asec ceca RQ 8 VIE VTS Ve I 10 ADDING NEW rE ocr 12 DELENG USER PROHLE sergio Tnn e E TE EEES OEE A 13 VIE WINGO REFOR To susci naea a E E E E seems 14 ACCESSING ES99S DATABASE subsedit I A E E ANE 17 DATABASE BACKUP AND RECOVERY ccccccssssssssrseccsssssrvennsrsccsssssssssenerscesssssorssarenses 19 AREPA e E 2 Page 2 of 23 Introduction This User Manual provides a graphical guide about how to use the Employee Self Serving System Local Intranet After examine tutorial provided in the User Manual A1 Information System employees will be able to e Seamlessly Navigate through Local Intranet e Successfully logon to the website e Update User Profile e Search and locate employees in the employee directory e View User Profile e Adding New Employee e Delete Employee e View Reports e Access the database e MySQL Perform Backup and recovery ESSS database Page 3 of 23 ll Accessing ESSS Intranet l cli
4. 2 System redirect user to search form as illustrated in figure 1 5 3 Enter the first and last name of the employee in the corresponding text boxes 4 Click on find now 5 System compares data enter in the text box search fields and display results if matches are found This is Shown in figure 1 6 Figure 1 6 Show Search Result Page Home Employee Directory Management HR Function Login Monday May 03 2010 Your search results for charles john First Name Last Name Job Title Profile Charles Johnston manager VIEW Page 9 of 23 VI Viewing Employee Profile l Repeat steps V Employee Search and click on view Profile 2 System redirects to employee profile as illustrated in figure 1 8 Alternative 3 A Click on the Employee Directory Link in the menu bar 3 B System redirects user to Employees Report shown in figure 1 7 3 C Click on the Next and Previous link to Navigate through listing to find desired employee 3 D Click on view profile to view profile figure 1 7 Figure 1 7 Shows list of employee Employee Directo Home Employee Directory Management HR Function Logout Thursday Apri 29 2010 List of Employees First Name Last Name Job Title Contact Number Profile Bill Right Sales Clerk 2147483647 VIEW Bily John Human Resource Manager 2147483647 VIEW Chuck Johnston manager 2147483647 VIEW Chuck James manager 2147483647 VIEW Daleyann Alexander Receptionist 2147483647 VIEW Frank JAck Manager 2147483647 VI
5. EW frant Alexander Receptionist 2147483647 VIEW Grace Choice Manager 2147483647 VIEW Grace Zhange Manager 2147483647 VIEW Grant Steven Sales Clerk 2147483647 VIEW Jack Primus receptionist 1147483647 VIEW James Bond Security 2147483647 VIEW John Doe Supervisor 2147483647 VIEW John Vilage Manager 2147483647 VIEW Jonas Hope Receptionist 2147483647 VIEW Julia steven Security 2147483647 VIEW Lovell Felix Human Resource Manager 2147483647 VIEW Majak Mireck Supervisor 2147483647 VIEW Otus Primus receptionist 2147483647 VIEW Sally May mananger 2147483647 VIEW 1 2 Next Page 10 of 23 Figure 1 8 Showing Employee Profile ADMIN amp Profile Owner View e Displays all information about the employee including sensitive data such as Social Security Number Added to that only Administrator can delete user profile Page 11 of 23 Figure 1 9 Showing Employee Profile Limited VIEW Home Employee Directory Management HR Function Logout Monday May 03 2010 Bill Right Profile Nickname Billy Job Title Sales Clerk Supervisor John Villa Contact Information Address 1084 Wilmohr Brooklyn NY 11212 Telephone Work 2147483647 Home 5558909876 Return to Employee Directory Edit Delete e If the user viewing profile is not an administrator or the owner of the profile limited information about the employee is displayed Vil Adding New Employee l Select HR Functions from the links menu bar 2 f User is Admin systems redir
6. LETE CASCADE H ON UPDATE CASCADE UserName Iv No index defined Password No index defined Role l No index defined XII Database Backup and Recovery A Backup 1 Select the Export Tab 2 Under the export click on select all and the desired file tyoe 3 Check the save as file box 4 Enter a file name text box Page 19 of 23 5 Click on go 6 Save file on storage device A Recovery C1 I Select the Import Tab Click Choose File Browse to File Location Click open Click go Page 20 of 23 XIII Appendix Sample Codes used Index page lt php session start page title ESSS Client System Home include inc header html 2 I primary content start gt lt div class post gt div class header div class date div lt div gt lt div class content gt I p lt font color FFOOOO size 3 gt Security feature on site Removed All pages can be viewed lt font gt lt p gt gt lt epohp include inc feature index html e lt div gt lt strong gt lt center gt Welcome to ESSS Client Service System lt center gt lt strong gt lt div gt lt img src images index png width 500 height 300 gt lt div gt lt div gt lt div class post gt lt div class header gt lt div class date div lt div gt lt div class content gt p p div div lt div class post gt lt div class header di
7. SS Intranet CONTROL PANEL Update My Profile View Employee Directory mployee Looku HELP User Manual ADMIN MENU ICK LINKS Human Resource Management Home Employee Search Control Panel Updating User Profile l As illustrated in figure 1 3 click on update profile 2 System redirects user to Update profile form link as shown in figure 1 4 3 Add or modify data in text box field 4 Click update to submit changes to the database If update System is successful system display confirmation message The user Profile has been edited Page 7 of 23 Figure 1 4 shows Update User Profile Form Home Employee Directory Management HR Function Thursday Apri 29 2010 Update User Profile Personal Information First Name Lovell Last Name Felix Nick Name juicy Maritial Status Single Date of Birth 1983 10 04 00 00 Social Security 940130022 Home Phone 5556452222 Street Address 4700 taft blvd apt 84 State TX Zip 76308 Company Information Job Title Human Resource Manager Office Phonee 2147483647 Supervisor Kim Colli Department Human resource User Name lovell felix Password V Employee Search Figure 1 5 Shows Employee Search Form a Employee Directory Management HR Function Login Monday May 03 2010 Directory Search Enter First Name and Last name First Name charles Last Name john Page 8 of 23 1 Click on employee lookup link in user control panel figure 1 3
8. ck on start button on the task bar 2 click on all programs 3 Click on internet Explorer 4 Then enter http www lovellfelix getmyip com system designs and then browse to webpage Accessing Working prototype Hosted on a remote server Figure 1 0 Show s the location of Internet Explorer in the Task Bar Menu Items Adobe Designer 7 0 Internet Explorer MSN Location C Proc Remote Assistance Windows Defender Windows Live Messenger ixplorer Windows Media Player Windows Messenger Office Outl Windows Movie Maker BusinessObjects XI Crystal Reports XI Adobe Adobe Bridge Adobe Help Center Adobe ImageReady CS2 Adobe Photoshop CS2 Macromedia WinRAR WinZip Microsoft Visual C 2005 Express Edition Lavasoft REAUp REA 9 DbaMGR2k Microsoft SQL Server 2005 Assumption All workstations are Windows XP Page 4 of 23 ESSS Client System Home Windows Internet Explorer QO http localhost my yy Favorites 5s Suggested Sites v Get More Add ons v ESSS Client System Home n v E de v Pager Safetyv Toolsv Q9 o Bing py website projects systems designs index php gt Home Employee Directory Management HR Function Tuesday May 04 2010 Welcome to ESSS Client Service System ESSS Intranet Done Ep Internet Protected Mode On fa v 100 v m HELP User Manual QUICK LINKS Home
9. ction dedname miscdeduction dedfrequency CONCAT FORMAT miscdeduction dedamount 2 As amount employee empid employee empfirstname employee emplastname FROM miscdeduction employee WHERE employee empid miscdeduction empid Employee directory Query q SELECT empfirstname emplastname empjobtitle empid empofficephone FROM employee ORDER BY order by LIMIT start display salary Query q SELECT salaryemployee empid CONCAT FORMAT salaryemployee empannualsalary 2 As salary employee empid employee empfirstname employee emplastname FROM salaryemployee employee WHERE employee empid salaryemployee empid Update Profile q UPDATE employee INNER JOIN user USING empid SET empfirstname fn emplastname in empnickname nn empdob dob empssn sn User Username un WHERE empid id Page 23 of 23
10. ects user to HR Function control panel 3 Select Add Employee 4 System redirect to Add New Employee page as illustrated in Figure 1 10 5 Enter New Employee Data 6 Click the register button Systems validates data and display confirmation page 8 If unsuccessful make the necessary changes to data and resubmit by clicking on the registration button Page 12 of 23 Figure 1 10 shows the Add New Employee Page Home Employee Directory Management HR Function Login Thursday Apri 29 2010 Add New Employee Personal Information First Name Last Name Nick Name Maritial Status Date of Birth Social Security Home Phone Street Address State Zip Company Information Job Title Office Phonee Supervisor Department User Name Password Vill Deleting User Profile 1 Repeat steps outline in VI 2 Click on delete 3 System display confirmation message Are you sure you want to delete USER 4 Click on YES to confirm delete Page 13 of 23 IX Viewing Reports A Human Resource Reports 1 In User Control Panel as outlined in Figure 1 3 click on Human Resource link located in the AMIN Menu 2 System redirects and display figure 1 11 3 Click on Employee Deductions Report as outlined under the Report menu 4 The system will redirect and display figure 1 12 Figure 1 11 Shows the Employee Deduction Report Employee Directory Management HR Function Logout Tuesday May 04 2010
11. m rch Control Pane Figure 1 1 shows the Home Page of the ESSS Local Intranet Website Il Login to the ESSS System l Click on login Link on the upper left corner on the link menu bar as outlined in figure 1 1 2 Enter username and password in the login form which is illustrated in figure 1 2 3 Click on the login button Page 5 of 23 Figure 1 2 Shows the ESSS login form Home Employee Directory Management HR Function Login Thursday Apri 29 2010 Login Enter your Username and Password UserName llovell felix Password Login credential is authenticated and if it validates then user is redirected to the user control panel Control panel is illustrated in figure 1 3 However if login fails then error message is displayed and user is required to re enter a valid username and password in order to proceed to user control panel error screen is illustrated in figure 1 2 Figure 1 2 illustrate login authentication failure error message Home Employee Directory Management HR Function Login Monday May 03 2010 Error The following error s occurred The username and password entered do not match those on file Please try again Login Enter your Username and Password UserName Password Page 6 of 23 Figure 1 3 illustrate User Control Panel nnn Home Employee Directory Management HR Function Logout Monday May 03 2010 Hi Lovell You are now logged in ESSS Local Intranet FS
12. mmy A o rm room E m E c m z a Leurs amom Lms amm Username chuck Password johnston Select database name systems on the top right corner on the webpage phpMyAdmin cg Server localhost 4 Database systems Page 17 of 23 Viewing relationships 1 Click on the Designer tab on the upper left corner phpMyAdmin gj Server localhost Database systems Anag py Structure 2 System redirects page to the Relationship View Designer Mode phpMyAdmin ZOrO000 eo 00 89 A 8 EmpID int 11 EmpAnnualSalary int 11 EmpID int 11 EmpHourlyRate int 11 EmpMaxHours int 11 BO soem f DeDRequestDate date DedName varchar 50 GO ecemplyee june i S qm f EmpID int 11 8 EmpNickname varchar 25 e EmpSSN int 11 EmplD int 11 2 EmpHomePhone varchar 11 UserName varchar 255 B EnpStrestAddress verha 9 Password varchar 255 MailStop int 11 D EmpCly varchar 25 Role varchar 255 t BidgID int 11 EmpID int 11 EmpState varchar 15 RoomNum int 11 t EmpContractHourlty Wage int 11 8 EmpZip int 11 ums EmpPermEmployer varchar 10 f EmpDOB datetime EmpMaritalStatus varchar 10 8 int 1 EmplobTitle varchar S0 V EmplD int 11 EmpSup varchar 10 RoomNum int 11 751 be H erate c varchar 25 H Netshop mae E dos PP BidgID int 11
13. on by Employees First Name Last Name Lovel Bil Jonas Grace John John James Daleyann Chuck Steven Frank Otus Jack Felx Right Hope Choice Doe Vilage Bond Alexander Johnston Grant JAck Primus Primus Steven Alexander Johnston Johnston Mireck Alexander steven James JAck 1998 1995 2000 2005 2006 2005 1998 1999 1999 Year Contribution Amount 25 000 00 2 000 00 12 000 00 1 000 00 12 000 00 12 000 00 2 300 00 2 300 00 2 300 00 2 300 00 2 600 00 25 000 00 2 000 00 12 000 00 1 000 00 12 000 00 12 000 00 2 300 00 2 300 00 2 300 00 2 300 00 2 600 00 Page 16 of 23 Xl Accessing ESSS Database l Using internet explorer enter http lovellfelix getmyip com phpmyadmin in URL filed and press the enter key phpMyAdmin Welcome to phpMyAdmin Language English Log in Username Password 2 Use the following Credential to login to phpMyAdmin A gg structure ASAL Search Query aExport almport Table a Action Records 1 Database eS Tn 13 FI building BEI mp X 20 tems 1 contractemployee E amp E m 17 ms 13 department fs Oe m x uilding emergency contact ij se m o ntact employee al m E eC 22 Es ACCLCHEEN CE G4 E mergency contact hourlyemployee BEI apc im s is mplayee z lt E CRT maildrop jE 3x mp x 1 wildrop NET um p 4c qm ende miscdeduction iE Loe
14. v class date div lt div gt lt div class content gt p p lt div gt lt div gt Page 21 of 23 I primary content end gt lt div gt lt php include inc sidebar html include inc footer html Login Page ephp Script 11 9 loggedin php 2 The user is redirected here from login php session start Start the session f no session value is present redirect the user if lisset SESSION C id require once includes login_functions inc ohp url absolute url header Location url exit page title You are Logged Inl include includes header htmYl function greet name msg balance due if isset SESSION c id amp amp lstrpos SERVER PHP SELF logout php name SESSION fname SESSION Iname Y balance _SESSION curr_bal due _SESSION due_date echo lt p gt Hi name msg balance and it s due on due lt p gt greet name balance due msg include includes footer html 2 Page 22 of 23 SQL Syntax Sample United Way Query q SELECT unitedway UWEmplD unitedway UWYear employee empid CONCAT FORMAT unitedway UWAmount 2 AS UWAmount employee empfirstname employee emplastname FROM unitedway employee WHERE employee empid unitedway empid Deduction Query q SELECT miscdeduction empid miscdeduction DeDRequestDate miscdedu
Download Pdf Manuals
Related Search