payroll information system
TRANSCRIPT
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 1/180
PAYROLL INFORMATION SYSTEM
B.Tech Computer Science & Engineering, 8thsemester
SYNERGY INSTITUTE OF ENGINEERING & TECHNOLOGY
DHENKANAL-759001
AFFILATED TO BIJU PATNAIK UNIVERSITY OF TECHNOLOGY
ROURKELA
Guided By: Submitted By:
Mrs. Shradhanjali Rout (Asst. Professor) Dhiraj Kumar (!!"#!!#$)
Shi%endu Shah (!!"#!!&&)
Prin'e Roshan (!!"#!!#)
Md. SafaatAlli (!!"#!!*+)
Siddharth Kumar (!!"#!!&,)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 2/180
D-/ARA0123
4e hereby 'ertify that the the 5roje't entitled 6Payroll 1nformation System7 by Dhiraj Kumar
(!!"#!!#$)8 Prin'e Roshan (!!"#!!#)8 Shi%endu Shah (!!"#!!&&)8 Md. SafaatAlli
(!!"#!!*+)8 Siddharth Kumar (!!"#!!&,) in 5artial fulfilment of re9uirements for the
a%ard of deree of B.0e'h. (om5uter S'ien'e and -nineerin) submitted in the
De5artment of om5uter S'ien'e ;-nineerin at S<3-RG< 13S010=0- 2>
-3G13--R13G ; 0-?32/2G<8 D?-3KA3A/ under B1@= PA03A1K =31-RS10<
2> 0-?32/2G<8 R2=RK-/A is an authenti' re'ord of our o%n %or 'arried out under
the su5erision of Shradhanjali Rout (Asst. Professor). 0he matter 5resented has not been
submitted by me in any other =niersity C 1nstitute for the a%ard of B.0e'h. Deree.
Dhiraj Kumar Shiwendu Shah Prince
Roshan
(1001230038) (1001230066)(1001230053)
Siddharth Kumar Md Sa!a"at#$$i
(100123006%) (10012300&')
0his is to 'ertify that the aboe statement made by the 'andidate is 'orre't to the best of my
no%lede.
uides Si*nature +,D Si*nature
(-om.uter Science / n*ineerin*
De.artment)
terna$ aminer Si*nature
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 3/180
AK324/-DG-M-30
1t is a matter of reat 5leasure for us to submit this 5roje't on 6Payroll 1nformation system7
4e e5ress our dee5 sense of ratitude and indebtedness to our uide Mrs.Shradhanjali Rout8
for 'onsistently 5roidin us aluable en'ouraement8 hel5ful suestion8 moral su55ort and
affe'tion. 1n s5ite of his etremely busy s'hedules8 she %as al%ays aailable to share %ith me
his dee5 insihts8 %ide no%lede and etensie e5erien'e. ?er adi'es hae alue lastin
mu'h beyond this 5roje't. 4e 'onsider it a blessin to be asso'iated %ith him.
2ur sin'ere thans to Prof. Bis%ajit 0ri5athy8 ?ead of the De5artment8 S.1.-.08 Dhenanal8
for rantin 5ermission to use the fa'ilities aailable in the institute for this study.
4e also e5ress our thanfulness to the en'ouraement from fa'ulty and staff members of
om5uter S'ien'e -nineerin De5artment for their 'ontinuous en'ouraement and
suestions.
/ast8 but not least8 %e than all those %ho hae dire'tly or indire'tly assisted us for
'om5letion of this 5roje't.
Sinature
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 4/180
ABSTRACT
Pro!"# #$#%! P'(ro%% I)*or+'#$o) S(,#!+
0his is a small s'ale 5roje't for 5ayroll system .0he basi' idea is that the manaer of
the 'om5any maintains the details about the em5loyees8 the desination and salary. 1t 'onsists
of em5loyee details8 5ayroll system8 status and eits. 0he manaer 'an enter the name and
em5loyee 1D and et the salary details of that 5arti'ular em5loyee. 1n 5ayroll system %e 'an
'al'ulate the net salary of the em5loyee based on in5ut.0he Payroll 5ro'essin is 'riti'al to
businesses and other oraniEations be'ause of the sinifi'ant amounts of money inoled in
em5loyee remuneration and the 'om5leity of the leal re9uirements. 0his is a small s'ale
5roje't for 5ayroll 5ro'essin. 0he basi' idea is that the manaer of the 'om5any maintains
the information su'h as 'om5anyFs name8 its bran'hes all oer. 0he em5loyee details maintain
the em5loyee 1D8 3ame alon %ith 5ersonal information. 0he total salary details determine
the net 5ay of the em5loyee. 0his 5ay roll 5ro'essin inoles %ith t%o ty5es of users.
-MP/2<--
ADM131S0RA02R
1n the -m5loyee details module arious details lie em5loyee 1D8 3ame8 Desination8
Basi' 5ay are obtained from the user. 1n the Dis5lay module the total database is dis5layed. 1n
the salary Details module8 the indiidual database is dis5layed %hi'h sho%s the P>8 DA8
?RA and 3et salary of the 5arti'ular em5loyee. By usin the Modify module %e 'an modify
and u5date the em5loyee 5ersonal details on the database stored.0he P'(ro%% I)*or+'#$o)
S(,#!+ is based on the salary a'tiity for ea'h 'om5any staff de5endin on their attendan'e.
0he first a'tiity is based on sain the em5loyees details %here ea'h em5loyee %ill be ien
a uni9ue -m5loyee 1D.so that any em5loyee 'an 'he' their salary after dedu'tin different
taes.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 5/180
CONTENTS
C.'/#!r 1 I)#ro"#$o) 7
C.'/#!r2 Pro!"# S"o/! A) O3!"#$4! 10
C.'/#!r F!',$3$%$#( S#( 11
#. 0e'hni'al >easibility
#." -'onomi'al >easibility
#.# 25erational >easibility "
#.* S'heduled >easibility "
C.'/#!r 6 R!$r!+!)# A)'%(,$, ') S/!"$*$"'#$o) 1
*.?ard%are Re9uirements #
*." Soft%are Re9uirements #
C.'/#!r5 So*#8'r! R!$r!+!)# A)'%(,$, 16
. >un'tional Re9uirements *
." 3on >un'tional Re9uirements +
C.'/#!r U:L D$';r'+ 1<
&. =se ase Diaram $
&." lass Diaram "
&.# Se9uen'e Diaram ""
&.* A'tiity Diaram "+
C.'/#!r 7 :!#.oo%o;( 29
+. odin
+.. .html odes ",
+.." .js5 odes &&
+.* Proje't Sna5shot &$
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 6/180
C.'/#!r < T!,#$); 176
,. >undamental And 2bje'tie +*
,." =nit 0estin +
,.# 1nteration 0estin +
,.* System 0estin +
,. Bla' Bo 0estin +&
,.& 4hite Bo 0estin +&
C.'/#!r 9 A4')#';!, ') L$+$#'#$o) 177
C.'/#!r 10 :'$)#!)')"! 17<
C.'/#!r 11 Co)"%,$o) 179
C.'/#!r 12 B$3%$o;r'/.( 1<0
.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 7/180
1=INTRODUCTION
Payroll information system is an a55li'ation that enables Admin to 'reate and store em5loyee
salary re'ords. 0his a55li'ation also hel5s to enerate 5ay sli5 to em5loyees. 0his a55li'ation
is hel5ful to de5artments of the oraniEation %hi'h maintains data of em5loyees related to an
oraniEation.
0he Payroll 5ro'essin is 'riti'al to businesses and other oraniEations be'ause of the
sinifi'ant amounts of money inoled in em5loyee remuneration and the 'om5leity of the
leal re9uirements. 0his is a small s'ale 5roje't for 5ayroll 5ro'essin. 0he basi' idea is that
the manaer of the 'om5any maintains the information su'h as 'om5anyFs name8 its bran'hes
all oer. 0he em5loyee details maintain the em5loyee 1D8 3ame alon %ith 5ersonal
information. 0he total salary details determine the net 5ay of the em5loyee. 0his 5ay roll
5ro'essin inoles %ith t%o ty5es of users.
=S-R
ADM131S0RA02R
USER>S ROLE
0he users 'an loinCloout the database. ?eCShe 'an ie% hisCher 5ersonal details8 monthly
5ay details8 and 'om5any details. 0he user 'an just ie% the information %hereas heCshe
'ould not mae 'hanes in the database.
AD:INISTRATOR ROLE
0he administrator 5lays a ital role in the 5ayroll system. 0he administrator 'ontrols the
entire database. 0he net salary 'al'ulations are 'al'ulated by the administrator itself. 0he
main role of the administrator is to safeuard the database.
0he P'(ro%% I)*or+'#$o) S(,#!+ is based on the salary a'tiity for ea'h 'om5any staff
de5endin on their attendan'e. 0he first a'tiity is based on sain the em5loyees details
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 8/180
%here ea'h em5loyee %ill be ien a uni9ue -m5loyee 1D.so that any em5loyee 'an 'he'
their salary after dedu'tin different taes. Admin has the authority to add em5loyee details.
And he also has the riht to edit or delete em5loyee information toCfrom the list. Admin
5roides a uni9ue username and 5ass%ord for ea'h em5loyee throuh %hi'h he 'an loin and
'he' salary. All the informationFs are bein saed in the database.
:o%!,
A""o)# Co)*$;r'#$o)
E+/%o(!! 4hen a ne% em5loyee joins the 'om5any8 his re'ord is saed in the database.
S'%'r( C'%"%'#$o) ?ere salary is 'al'ulated for ea'h em5loyee based on their attendan'es
and different taes. As soon as the salary is 5aid to an em5loyee8 a salary sli5 %ill be
enerated.
S'%'r( R!/or# ?ere the user 'an loo throuh the salary ien to an em5loyee for a
5arti'ular month and year.
R!;$,#r'#$o) As soon as the em5loyee joins the 'om5any8 the admin 5roides uni9ue user
D$,/%'( A user 'an ie% information reardin em5loyees %orin in that 'om5any8 5ost8
and other information.
Lo;o# 0his module allo%s the user to Lo;o# the a55li'ation. >urther o5erations 'annot be
5erformed after user eits.
An em5loyer uses a 5ayroll system to 5ro'ess its 5ayroll. onse9uently8 5ayroll 'annot be
5ro'essed %ithout a 5ayroll system. A 5ayroll system allo%s the em5loyer to 5ay em5loyees
on time and a''urately8 5lus 'om5ly %ith other statutory reulations.
Small 'om5anies8 for eam5le8 'an use Hui'BoosI mediumJsiEed 'om5anies 'an use
=ltimate Soft%are and enter5rises %ith more 'om5le 5ayroll re9uirements 'an use ondata.
1f the em5loyer 'hooses the eternal system8 it 'an8 for eam5le8 'hoose an online 5ayroll
seri'e 5roider %ith the ability to manae em5loyee 5ayroll a''ounts and 5rint 5ayroll
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 9/180
re5orts online. 1f the em5loyer offers em5loyees dire't de5osit8 it should for%ard ban
a''ount information in'ludin a''ount and routin numbers to the 5ayroll seri'e 5roider.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 10/180
2=OBJECTIVE AND SCOPE
Proje't 2bje'tie:
0he obje'tie of the P'(ro%% I)*or+'#$o) S(,#!+ is to 5roide a system %hi'h manaes
the Payroll a'tiity i.e. the salary 5aid for ea'h em5loyee in a 'om5any de5endin u5on their
attendan'e and their different ta 5oli'ies of the 'om5any8 its 'al'ulation %hi'h is ery hue.
0he users %ill 'onsume less amount of time %hen 'om5ared to manual 5a5er %or throuh
the automated system. 0he system %ill tae 'are of all the 5ayroll a'tiities lie manain
ea'h em5loyeeFs attendan'e8 the number of leaes taen by that 5arti'ular em5loyee and the
different ty5e of taes 'al'ulation in a ery 9ui' manner and it aoids
Data storin is easier. Pa5er %or %ill be redu'ed and the 'om5any staffs s5end more time on
monitorin the 5roress. 0he system is user friendly and easy to use. All the im5ortant dataFs
%ill be stored in the database and it aoids any mis'al'ulation.
Proje't S'o5e:
0he su55lementary s5e'ifi'ation a55lies to 5ayroll 5ro'essin. 0his s5e'ifi'ation defines the
nonJfun'tional re9uirement of the system su'h as
>un'tionality:
Sin'e it stand alone a55li'ation8 a sinle user may use it at a time.
Reliability:
0he system is aailable at "* hours a day8 seen days a %ee.
Performan'e:
0he 5erforman'e de5ends on hard%are s5e'ifi'ation.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 11/180
=FEASIBILITY STUDY
>easibility study is an ealuation of the 5ro5osed system reardin its %orability8 im5a't on
the oraniEation8 ability to meet the user needs and effe'tie use of resour'es. 0hus %hen a
ne% a55li'ation is 5ro5osed it normally oes throuh a feasibility study before it is a55roed
for deelo5ment. >easibility and ris analysis are related in many %ays. Durin the
feasibility analysis8 this 5roje't has been dis'ussed belo% under the to5i's:
". 0e'hni'al >easibility
0he deelo5ment 5ro'ess of Salary 1nformation System %ould be adantaeous to the
oraniEation be'ause %e %ould mae use of only the 'urrently aailable resour'es of the
oraniEation. All the tools needed for the deelo5ment are already aailable %ith the
oraniEation and the oraniEation does not hae to a'9uire any ne% resour'es. 0he te'hni'al
feasibility is also attributed to the fa't that the system does not mae use of any additional or
eternal third 5arty 'om5onents %hi'h 'an lead to in'reased load on the system.
"." 25erational feasibility
0he Salary 1nformation SystemiEe intended to 5roide a ery userJfriendly and easy to use
interfa'e %hi'h is benefi'ial for both the isitors as %ell as the o5erators %ho hel5 in
5roidin su55ort for the system. 0his system %ould also be easily a''e5table amon the
isitor and administrator8 as there is no need of any s5e'ial sill set for usin the a55li'ation.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 12/180
0his system also benefits the users as they do not hae to do%nload anythin on their
terminals in'reasin their effi'ien'y and ease of use.
".#-'onomi' >easibility
0he Salary 1nformation System as a ery lo% deelo5ment ost. 0he lo% 'ost is
attributed to the usae of the eistin resour'es of the oraniEation. As the %ebsite is
ery user friendly and easy to use8 there is no need to 5roide s5e'ial trainin to the
users of the %ebsite8 thus sain aluable time and money
".* S'heduled feasibility
Proje'ts are al%ays ien deadlines. -ery 5roje't is 'om5leted in a s5e'ifi' duration. 1 %as
the only %orin on the 5roje't and 1 had the 5roje't duration of four months only. So i hae
tried our leel best to fulfill ea'h and eery re9uirement. 1 had to 'om5lete the 5roje't in time
and if it is not 5ossible to 'om5lete the soft%are in time then 1 %ould try our best to fulfill
'lient re9uirements.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 13/180
6=RE?UIRE:ENT ANALYSIS AND
SPECIFICATION
6=1H'r8'r! I)#!r*'"!,-
S!r4!r S$!
• 25eratin system:J %indo%s 5CistaC+
• Pro'essor:J Pentium #.! G?E or hiher
• RAM:J "& MB or hiher
• ?ard Drie :J ! GB or more
C%$!)# S$!• 25eratin system:J %indo%s 5CistaC+
• Pro'essor:J Pentium #.! G?E or hiher
• RAM:J "& MB or hiher
6=2So*#8'r! I)#!r*'"!,-
S!r4!r S$!
• ?0M/
• @aa s'ri5t.
• MS A''ess
A5a'he 0om'at serer.
C%$!)# S$!
0he 'ustomer must 'onne't to the internet to a''ess the %ebsite.
Dialu5 modem of "b5s.
Co++)$"'#$o), I)#!r*'"!,-
ommuni'ations interfa'es 'an be 5roided throuh eJmail8 %eb bro%ser8 net%or serer
'ommuni'ations 5roto'ols8 ele'troni' forms8 and so on.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 14/180
5=SOFT@ARE RE?UIRE:ENT SPECIFICATION
5=1F)"#$o)'% R!$r!+!)#,
1ntrodu'tion:
Re9uirements analysis is usually the first 5hase of lareJs'ale soft%are deelo5ment 5roje't.
1t is undertaen after a feasibility study has been 5erformed to define the 5re'ise 'osts and
benefits of a soft%are system. 0he 5ur5ose of this 5hase is to identify and do'ument the ea't
re9uirements for the system. 0he 'ustomer8 the deelo5er8 a maretin oraniEation or any
'ombination of the three may 5erform su'h study. 1n 'ases %here the re9uirements are not
'lear e..8 for a system that is neer been defined8 more intera'tion is re9uired bet%een the
user and the deelo5er. 0he re9uirements at this stae are in endJuser terms. 0he module used
in the 5roje't %ill be admin and em5loyee.
Administrator module:J
1= 0est 'ase: /oin
1n5ut: 1D8 Pass%ord.
Pro'ess: li' on the loin lin. 1f administrator enters 1D and 5ass%ord 'orre't it
oes to the admin seri'es other%ise dis5lays the same 5ae %ith an error messae.
2ut5ut: Dis5lays the admin seri'es 5ae.
2. 0est 'ase: Add ne% em5loyee
1n5ut: 3ame8 1d8 desination8 Date of joinin8 Mob. 3o.8 -mailJid8 Hualifi'ation8
D.2.B.8 ateory.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 15/180
Pro'ess: A ne% em5loyee 'an be added into the system and admin 'an u5date his
details.
2ut5ut: 0he em5loyee 'an be 'redited salary based u5on his details.
= 0est 'ase: Salary details
1n5ut: 1d8 desination8 basi' salary8 P>8 DA8 -P>8 ?RA8 2ther allo%an'es8
Professional 0a.
Pro'ess: 0he admin 'an u5date his salary details
2ut5ut: -m5loyee salary details %ill be u5dated to the database.
6=0est 'ase: Salary sli5
1n5ut: 1d8 Basi' salary8 Desination8 3et 5ay.
Pro'ess: Based on the leae8 loan8 and ta details the sli5 %ill be enerated
2ut5ut: Salary sli5 %ill be enerated.
5=0est 'ase: Ban details
1n5ut: 1d8 Desination8 salary
Pro'ess: 0he em5loyeeFs salary is 'redited to ban.
2ut5ut: -m5loyee 'an ie% and re'eie the salary.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 16/180
-m5loyeeFs module:
1=0est 'ase: /oin
1n5ut: 1D8 Pass%ord.
Pro'ess: li' on the loin lin. 1f -m5loyee enters 1D and 5ass%ord 'orre't it oes
to the other 5ae other%ise dis5lays the same 5ae %ith an error messae.
2ut5ut: Dis5lays the 1nformation to be ie%ed by an em5loyee.
2=0est 'ase: hane 5ass%ord
1n5ut: 1d8 2ld 5ass%ord8 ne% 5ass%ord
Pro'ess: -m5loyee 'an be able to 'hane his 5ass%ord by usin this test 'ase.
2ut5ut: -m5loyee ne% 5ass%ord %ill be u5dated
=0est 'ase: ie% earnins
1n5ut: 1D8 Month8 <ear.
Pro'ess: 0he earnins 'an be dis5layed by this test 'ase
2ut5ut: 0he total earnins of an em5loyee for the s5e'ified month and year 'an be
ie%ed
6=0est 'ase: ie% salary sli5
1n5ut: 1d8 Month8 <ear.
Pro'ess: 0he em5loyee 'an ie% the salary sli5.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 17/180
2ut5ut: 0he salary sli5 of an em5loyee for the s5e'ified month and year 'an be
ie%ed.
5=2No) F)"#$o)'% R!$r!+!)#,
Se'urity: System loin: >or em5loyee to loin it re9uires the alid loin and 5ass%ord before
rantin further a''ess.
Data en'ry5tion: 0he 5ayroll system en'ry5ts all information before %ritin it into the
database.
Maimum loin attem5ts: 0his system allo%s the maimum of three 'onse'utie
attem5ts.
0ransa'tion re'ordins: 0his system shall ee5 a re'ord of all failure loin attem5ts
%ith user loin8 terminal loin and time.
Maintainability:
Problem redu'tion: 0he major 5roblem in the 5ayroll system shall be either resole in
t%o hours maintenan'e %indo%.
Automati' ba'u5s: 0he 5ayroll system shall 5erform automati' ba'u5s on'e 5er
bat'h.
Portability:
0he 5ayroll system is 5roided to different users 5roided they meet the s5e'ified
re9uirements.
A''essibility: it 'an be a''ess from eery system.
-ffi'ien'y: J 1t %ill %or fast and in5ut ien is 'orre'tly s5e'ified.
Reliability: J
=sers e5e't the 5ayroll system to be reliable8 a 'ommon nonJfun'tional re9uirement for
most systems. 1nformation entered yesterday in the system should be there today. A''ura'y is
5art of the sense of reliability JJ 5ayroll 'he's and re5orts must be mathemati'ally 'orre't8
in'ludin 'al'ulations inolin 'ents.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 18/180
=U:L DIAGRA:
6.1USECASE
0he 5ayroll use 'ases in our system are:
./oin
".Reistration
#. Add em5loyee
*. =5date em5loyee details
.=5date 5ass%ord
&. Delete em5loyee
+. al'ulate salary
$. ie% Pay sli5
,.=5date salary
!.1nbo
.Re5ort
"/oout
A'tors inoled
.Admin
". -m5loyee
=se 'ase name: /oinJ
0he user enters the username and 5ass%ord and 'hooses if the user is em5loyee or
administrator. 1f entered details are alid8 the userFs a''ount be'omes aailable. 1f it is
inalid8 an a55ro5riate messae is dis5layed to the user.
=seJ'ase name: Add em5loyee
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 19/180
2nly the manaer has a''ess to this useJ'ase. 0he manaer has to 5roide the details of the
em5loyee to 'reate an a''ount for a ne% em5loyee. 1f the em5loyee added already eits an
a55ro5riate messae is dis5layed.
=seJ'ase name: =5date em5loyee details
0his useJ'ase 'an be a''essed only by the manaer and not by the em5loyee. 0he desired
em5loyee is sear'hed for and the details of the em5loyee are u5dated %ith ne% entries. 1f the
em5loyee sear'hed for is not aailable an a55ro5riate messae is dis5layed.
=seJ'ase name: Delete em5loyee
0his useJ'ase 'an also be used only by the manaer. 1t is used to delete the re'ord of an
em5loyee if it is not ne'essary. 0he em5loyee identity is 5roided by the manaer %hi'h is
sear'hed for and if it is found8 it is deleted. 1f it is not found an a55ro5riate messae is
dis5layed.
=seJ'ase: 'al'ulate salary
0his useJ'ase is used to 'al'ulate the salary of the em5loyee after addin allo%an'es and
dedu'tin as ne'essary. 0he net salary is dis5layed. 0his useJ'ase 'an
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 20/180
U,! "',! $';r'+
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 21/180
=2= C%',,!,
0he 'lass diaram is a ra5hi'al re5resentation of all the 'lasses used in the system and their
o5erations8 attributes and relationshi5s. 0he 5ayroll system maes use of the follo%in
'lasses
. loin
". -m5loyee 5ersonal details
#. -m5loyee salary
) Salary transa'tion
1t 'onsists of t%o attributes and t%o o5erations. 0he attributes are username and 5ass%ord.
0he o5erations used are loin () and loout ().
") -m5loyee 5ersonal details
1t is used to store the 5ersonal details of the em5loyee8 su'h as name8 em5loyee id8 ender
and ae. 0he o5erations aailable in this 'lass are ie% ()8 add em5loyee ()8 edit em5loyee
details ()8 ie% em5loyee details ()8 delete em5loyee details ().
#) -m5loyee salary
1t is used to store the salary details of the em5loyee su'h as basi' 5ay8 house rent allo%an'e8
dearness allo%an'e8 5roident fund and insuran'e. 0he o5erations aailable are 'al'ulate net
salary ()8 ie% salarydetails ()8 u5date salary details () and dedu'e fine () o5erations aailable
are 'al'ulate net salary ()8 ie% salary details ()8 u5date salary details () and dedu'e fine ().
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 22/180
C%',, $';r'+
== S!!)"! $';r'+
A se9uen'e diaram re5resents the se9uen'e and intera'tions of a ien useJ'ase or s'enario.
Se9uen'e diarams 'an 'a5ture most of the information about the system. Most obje'tJtoJ
obje't intera'tions and o5erations are 'onsidered eents and eents in'lude sinals8 in5uts8
de'isions8 interru5ts8 transitions and a'tions to or from users or eternal dei'es. An eent
also is 'onsidered to be any a'tion by an obje't that sends information. 0he eent line
re5resents a messae from one obje't to another8 in %hi'h the 6from7 obje't is re9uestin an
o5eration be 5erformed by the 6to7 obje't. 0he 6to 6obje't 5erforms the o5eration usin a
method that the 'lass 'ontains. 1t is also re5resented by the order in %hi'h thins o''ur and
ho% the obje'ts in the system send messae to one another. 0he se9uen'e diaram for ea'h
useJ'ase that eists %hen a user los in8 adds8 ie%s8 u5dates or deletes re'ords in the system.
An eent also is 'onsidered to be any a'tion by an obje't that sends.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 23/180
S!!)"! $';r'+
&.#.Admin loin
&.#." /oin em5loyee :J
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 24/180
#.# -m5loyee reistration:J
#.* ie% details:J
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 25/180
&.#.u5date details:J
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 26/180
&.#.& Delete details:J
&.#.+ -m5loyee loout:J
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 27/180
&.#.$ Admin loout:J
&.*. A'tiity diaram:J
0he a'tiity diaram fo'uses on re5resentin arious a'tiities or eery 'hun of 5ro'essin
and their of a'tiation. An a'tiity is the state %ith an internal a'tion and one or more
outoin transition %hi'h automati'ally follo% the termination of the internal a'tiity. 0his is
'arried out durin the initial staes of re9uirement analysis and s5e'ifi'ation. 0his diaram is
ery hel5ful in understandin the 'om5le 5ro'essin a'tiities inolin the roles 5layed by
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 28/180
many 'om5onents. ?ere %e hae sho%n the details about the %orin and the a'tiities that
are done in our 5roje't. -a'h and eery ste5 is sho%n here
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 29/180
7=:ETHODOLOGY
7.1CODING
7.1.1 .html codes
:'$)=.#+%
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5IC5L
5Lim sr'Nbanner.j5N %idthN+!N heihtN!NLC5L
5Lfont 'olorNO!!!!>>NLbLPA<R2//CbLCfontLbLim sr'Nbar.@PGN
%idthN+&&N heihtN#"NLCbLbrLC5L
5Lfont 'olorNO!!!!>>NL4e offer:brL
4eely8 Monthly ;am5I yearly 'al'ulationsbrL
Sour'e dedu'tion 'al'ulationbrL
Re'ord of -m5loymentCfontLC5L
5Lobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN!N heihtN##NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNbutton#.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNNL
embed sr'Nbutton#.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 30/180
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!N
heihtN##N b'olorNN baseN.NLCembedL
Cobje'tLobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN!N heihtN##NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNbutton"!.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNNL
embed sr'Nbutton"!.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'iPQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!N
heihtN##N b'olorNN baseN.NLCembedLCobje'tLbrLC5L
di idN/ayerN styleN5osition:absoluteI %idth:"#!5I heiht:*!5I EJinde:I left:
"#5I to5: "&5NLim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN$"N
heihtN*!NLCdiL5LDesin ;am5I Deelo5ed By: Dhiraj umar8Md Safaat Alli8Prin'e
roshan8Si%endu shah ;am5I SidhartumarC5LCbodyLChtmlL
Lo;$)=H#+%
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL%indo%.history.for%ard()ICs'ri5tL
s'ri5t lanuaeN@aaS'ri5tNLJJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)ICC JJLCs'ri5tL
s'ri5tL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 31/180
fun'tion alidate>orm()
ar do'ument.formsVNformNWVNtNW.alueI
if (null UU NN)
alert(N-nter alid user 1DN)I
return falseI
T
ar ydo'ument.formsVNformNWVNt"NW.alueI
if (ynull UU yNN)
alert(N-nter alid 5ass%ordN)I
return falseI
TT
Cs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!N onloadXdo'ument.form.t.fo'us()XL
hLfont 'olorNO>>>>>>NLim sr'N5ids.j5N %idthN&!N heihtN#NLCfontLChL
form nameNformN methodN5ostN onsubmitNreturn alidate>orm()N a'tionNloin.js5NL
5La hrefNmain.htmlNLBAKCaLC5L
table %idthN#"YN borderN!NL
tr b'olorNO!!##>>NL
td 'ols5anN"N b'olorNO>>>>!!NL
di alinN'enterNLbLfont 'olorNO!!!!>>NLADM13 /2G13
CfontLCbLCdiLCtdLCtrL
tr b'olorNO!!&&NLtdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLCbLCfontLCdiL
CtdLtdLbLfont 'olorNO######NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 32/180
in5ut ty5eNhiddenN nameNrN alueNAdministratorNL
CfontLCbLCtdLCtrL
tr b'olorNO!!&&NL
tdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLfont
'olorNO>>>>>>NL/2G13 1DCfontLCbLCfontLCdiLCtdL
tdLbLfont 'olorNO######NL
in5ut ty5eNtetN nameNtNL
CfontLCbLCtdLCtrL
tr b'olorNO!!&&NL
tdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLfont
'olorNO>>>>>>NLPASS42RDCfontLCbLCfontLCdiLCtdL
tdLbLfont 'olorNO######NL
in5ut ty5eN5ass%ordN nameNt"NL
CfontLCbLCtdLCtrL
tr b'olorNO!!&&NL
tdL;nbs5ICtdL
tdLbLfont 'olorNO######NL
in5ut ty5eNsubmitN nameNSubmitN alueN/2G13NL
in5ut ty5eNresetN nameNSubmit"N alueNR-S-0NL
CfontLCbLCtdLCtrL
tr b'olorNO!!##>>NL
td 'ols5anN"N b'olorNO>>>>!!NL;nbs5ICtdLCtrLCtableL
5L;nbs5I C5L
5L;nbs5I C5LCformL
hL;nbs5IChL
hL;nbs5IChL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 33/180
CbodyLChtmlL
Co+/o,! )o#$"!=.#+%
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNLJJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJLCs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!N alinNyello%N linN%hiteNL
form nameNformN methodN5ostN a'tionN'om5oseQnoti'e.js5NL
di idN/ayerN styleN5osition:absoluteI %idth:**5I heiht:*&"5I EJinde:I left:
,,5I to5: +&5NL
table %idthN#"YN borderNNLtr b'olorNO!!&&>>NLtd 'ols5anN"NL;nbs5ICtdL
CtrLtrL
td 'ols5anN"N b'olorNO>>>>!!NLdi alinN'enterNLbLfont fa'eNourier 3e%8
ourier8 monoN siEeNN 'olorNO!!!!>>NLP2S0 3201-CfontLCbLCdiL
CtdLCtrL
trLtd %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8 monoNL02CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNLin5ut ty5eNtetN
nameNtN siEeN*!NLCfontLCbLCtdLCtrL
trL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 34/180
td %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8 monoNLDA0-CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNdtN siEeN*!NL
CfontLCbLCtdLCtrL
trLtd %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8
monoNLS=B@-0CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNsubN siEeN*!NL
CfontLCbLCtdLCtrL
trLtd %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8
monoNLM-SSAG-CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNLtetarea nameNmsN
'olsN&!N ro%sN!NLCtetareaLCfontLCbLCtdLCtrL
tr b'olorNO>>>>!!NL
td 'ols5anN"NL
di alinN'enterNL
in5ut ty5eNsubmitN nameNSubmitN alueNSubmitNL
in5ut ty5eNresetN nameNSubmit"N alueNResetNL
CdiL
CtdL
CtrL
tr b'olorNO!!&&>>NL
td 'ols5anN"NL;nbs5ICtdL
CtrL
CtableL
CdiL
CformL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 35/180
di idN/ayerN styleN5osition:absoluteI %idth:&*5I heiht:*&!5I EJinde:I left: "*5I
to5: +*5I ba'roundJ'olor: O!!&&>>I layerJba'roundJ'olor: O!!&&>>I border: 5 none
O!!!!!!NL
5L;nbs5IC5L
5Lfont 'olorNO>>>>!!NLCfontLC5L
5LbLfont 'olorNO>>>>!!NLa hrefNnoti'eQboard.js5NL13B2ZCaLCfontLCbLC5L
5La hrefNadminQhome.js5NLbL230R2/ PA3-/CbLCaLC5L
5L;nbs5IC5L
5Lim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN&"N heihtN&NLC5L
CdiL
CbodyL
ChtmlL
E+/=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 36/180
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
h"LbLfont 'olorNO!!!!>>NL;nbs5ICfontLCbLbLfont
'olorNO!!!!>>NL;nbs5I23>1G=R-
-MP/2<--CfontLCbLCh"L
h alinNleftNLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
h"L;nbs5I;nbs5Iobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion*8!8"8!N %idthN!N heihtN#+NL
5aram namemoie alueNbutton$.s%fNL
5aram name9uality aluehihL
5aram nameNBAS-N alueN.NL
5aram nameNBG2/2RN alueNNL
embed sr'Nbutton$.s%fN baseN.N 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!N
heihtN#+N b'olorNNL
CembedL
Cobje'tLCh"L
di idN/ayerN styleN5osition:absoluteI %idth:*$5I heiht:#!!5I EJinde:I left:
#!*5I to5: ,+5NL
di alinNrihtNL
5La hrefNadminQhome.js5NLfont siEeN*NLBa' to ontrolPanelCfontLCaLC5L
5Lim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN"$$N heihtN"&$NLC5L
CdiL
CdiL
5La hrefNaddQem5.js5NLfont fa'eNourier 3e%8 ourier8 monoN siEeN*NLbLADD
-MP/2<--CbLCfontLCaLC5L
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 37/180
5LbLfont fa'eNourier 3e%8 ourier8 monoN siEeN*NLa
hrefNu5dateQem5.htmlNL=PDA0-
-MP/2<--CaLCfontLCbLC5L
bLfont fa'eNourier 3e%8 ourier8 monoN siEeN*NLahrefNadminQdeleteQem5.js5NLD-/-0-
-MP/2<--CaLCfontLCbL
h"L;nbs5ICh"L
CbodyL
ChtmlL
E+/ "o+/o,!=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tL
styleL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 38/180
in5ut
fontJfamily: erdanaI
fontJsiEe: 5I
border: OBBB 5 solidI
ba'roundJ'olor: O------I
T
.ttSmall
fontJfamily: erdanaI
fontJsiEe: ,5I
fontJ%eiht: normalI
'olor: O!!!!!!I
T
CstyleL
styleL
hfilter:shado%I
'olor:blueI
%idth:!!!5I
T
CstyleL
lin relXstylesheetX hrefX.C'alendar.'ssX titleX'alendarXL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 39/180
s'ri5t lanuaeNjaas'ri5tN sr'N'alendar.jsNLCs'ri5tL
s'ri5t lanuaeNjaas'ri5tNL
CC[[[[[ >un'tion formatin the Date for in5utbo [[[[[
fun'tion fnSetDate>ormat(oDate>ormat)
oDate>ormatVX>ull<earXWI CC-am5le "!!+
oDate>ormatVX<earXWI CC-am5le !+
oDate>ormatVX>ullMonth3ameXWI CC-am5le @anuary
oDate>ormatVXMonth3ameXWI CC-am5le @an
oDate>ormatVXMonthXWI CC-am5le !
oDate>ormatVXDateXWI CC-am5le !
oDate>ormatVX>ullDayXWI CC-am5le Sunday
oDate>ormatVXDayXWI CC-am5le Sun
oDate>ormatVX?oursXWI CC-am5le !
oDate>ormatVXMinutesXWI CC-am5le !
oDate>ormatVXSe'ondsXWI CC-am5le !
ar sDateStrinI
CC-am5le !C!C!! ddCmmCyy
CCsDateStrin oDate>ormatVXDateXW \NCN\ oDate>ormatVXMonthXW \NCN\
oDate>ormatVX<earXWI
CC-am5le !C!C!!!! ddCmmCyyyy
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 40/180
CCsDateStrin oDate>ormatVXDateXW \NCN\ oDate>ormatVXMonthXW \NCN\
oDate>ormatVX>ull<earXWI
CC-am5le !!!!J!J! yyyyCmmCdd
CCsDateStrin oDate>ormatVX>ull<earXW \NJN\ oDate>ormatVXMonthXW \NJN\
oDate>ormatVXDateXWI
CC-am5le @anJ!J!!!! MmmCddCyyyy
CCsDateStrin oDate>ormatVXMonth3ameXW \NJN\ oDate>ormatVXDateXW \NJN\
oDate>ormatVX>ull<earXWI
return sDateStrinI
T
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!N alinNyello%N linN%hiteNL
form nameNformN methodN5ostN a'tionNem5Q'om5ose.js5NL
di idN/ayerN styleN5osition:absoluteI %idth:**5I heiht:*&"5I EJinde:I left:
,,5I to5: +&5NL
table %idthN#"YN borderNNL
tr b'olorNO!!&&>>NL
td 'ols5anN"NL;nbs5ICtdL
CtrL
trL
td 'ols5anN"N b'olorNO>>>>!!NL
di alinN'enterNLbLfont fa'eNourier 3e%8 ourier8 monoN siEeNN
'olorNO!!!!>>NL2MP2S-
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 41/180
MA1/CfontLCbLCdiL
CtdL
CtrL
trL
td %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8 monoNL02CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNtN siEeN*!NL
CfontLCbLCtdL
CtrL
trL
td %idthN#$YN heihtN"&NLbLfont fa'eNourier 3e%8 ourier8
monoNLDA0-CfontLCbLCtdL
td %idthN&"YN heihtN"&NLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5etet nameXdtX idXttalendar>ourthX 'lassXin5utBoStyleX readonly siEeN#!NL
im sr'X'al.ifX onMouse2erNfn1nitalendar(this8 Xttalendar>ourthX8
Xstyle'alendarQblue.'ss8instan'esinleX)N alinXabsmiddleX %idthN*N heihtN$N L
CfontLCbLCtdL
CtrL
trL
td %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8
monoNLS=B@-0CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNsubN siEeN*!NL
CfontLCbLCtdL
CtrL
trL
td %idthN#$YNLbLfont fa'eNourier 3e%8 ourier8
monoNLM-SSAG-CfontLCbLCtdL
td %idthN&"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 42/180
tetarea nameNmsN 'olsN&!N ro%sN!NLCtetareaL
CfontLCbLCtdL
CtrL
tr b'olorNO>>>>!!NL
td 'ols5anN"NL
di alinN'enterNL
in5ut ty5eNsubmitN nameNSubmitN alueNSubmitNL
in5ut ty5eNresetN nameNSubmit"N alueNResetNL
CdiL
CtdL
CtrL
tr b'olorNO!!&&>>NL
td 'ols5anN"NL;nbs5ICtdL
CtrL
CtableL
CdiL
CformL
di idN/ayerN styleN5osition:absoluteI %idth:&*5I heiht:*&!5I EJinde:I left: "*5I
to5: +*5I ba'roundJ'olor: O!!&&>>I layerJba'roundJ'olor: O!!&&>>I border: 5 none
O!!!!!!NL
5L;nbs5IC5L
5Lfont 'olorNO>>>>!!NLCfontLC5L
5LbLfont 'olorNO>>>>!!NLa hrefNem5Qinbo.js5NL13B2ZCaLCfontLCbLC5L
5La hrefNem5Qhome.js5NLbL-MP ?2M-CbLCaLC5L
5L;nbs5IC5L
5Lim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN&"N heihtN&NLC5L
CdiL
CbodyL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 43/180
ChtmlL
E+/ %o;$)=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
%indo%.history.for%ard()I
Cs'ri5tL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tL
s'ri5tL
fun'tion alidate>orm()
ar do'ument.formsVNformNWVNtNW.alueI
if (null UU NN)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 44/180
alert(N-nter alid user 1DN)I
return falseI
T
ar ydo'ument.formsVNformNWVNt"NW.alueI
if (ynull UU yNN)
alert(N-nter alid 5ass%ordN)I
return falseI
T
T
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!N onloadXdo'ument.form.t.fo'us()XL
hLfont 'olorNO>>>>>>NLim sr'N5ids.j5N %idthN&!N heihtN#NLCfontLChL
5La hrefNmain.htmlNLBAKCaLC5L
form nameNformN methodN5ostN onsubmitNreturn alidate>orm()N
a'tionNem5Qloin.js5NL
table %idthN#"YN borderN!N heihtN##NL
tr b'olorNO!!##>>NL
td 'ols5anN"N b'olorNO>>>>!!NL
di alinN'enterNLbLfont 'olorNO!!!!>>NL-MP/2<-- /2G13
CfontLCbLCdiL
CtdL
CtrL
tr b'olorNO!!&&NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 45/180
tdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLCbLCfontLCdiL
CtdL
tdLbLfont 'olorNO######NL
in5ut ty5eNhiddenN nameNrN alueN-m5loyeeNL
CfontLCbLCtdL
CtrL
tr b'olorNO!!&&NL
tdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLfont
'olorNO>>>>>>NL/2G13
1DCfontLCbLCfontLCdiL
CtdL
tdLbLfont 'olorNO######NL
in5ut ty5eNtetN nameNtNL
CfontLCbLCtdL
CtrL
tr b'olorNO!!&&NL
tdL
di alinNleftNLfont fa'eNourier 3e%8 ourier8 monoNLbLfont
'olorNO>>>>>>NLPASS42RDCfontLCbLCfontLCdiL
CtdL
tdLbLfont 'olorNO######NL
in5ut ty5eN5ass%ordN nameNt"NL
CfontLCbLCtdL
CtrL
tr b'olorNO!!&&NL
tdL;nbs5ICtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 46/180
tdLbLfont 'olorNO######NL
in5ut ty5eNsubmitN nameNSubmitN alueN/2G13NL
in5ut ty5eNresetN nameNSubmit"N alueNR-S-0NL
CfontLCbLCtdL
CtrL
tr b'olorNO!!##>>NL
td 'ols5anN"N b'olorNO>>>>!!NL;nbs5ICtdL
CtrL
CtableL
5L;nbs5I C5L
5L;nbs5I C5L
CformL
hL;nbs5IChL
hL;nbs5IChL
CbodyL
ChtmlL
E+/ +o)#.%( ,'%'r( r!/or#=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionNem5QmonthlyQsalaryQre5ort.js5NL
5La hrefNem5Qhome.js5NLBAKCaLC5L
table %idthN+YN borderNNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 47/180
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNO>>>>!!NL M230?/< SA/AR<
R-P2R0CfontLCbLCtdL
CtrL
trL
td %idthN"&YNLS-/-0 -MP 0<P-CtdL
td %idthN+*YNL
sele't nameNe'NL
o5tionLA0JACo5tionL
o5tionLA0JBCo5tionL
o5tionLA0JCo5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNLS-/-0 M230? ;am5I <-ARCtdL
td %idthN+*YNL
sele't nameNmnNL
o5tionL@A3Co5tionL
o5tionL>-BCo5tionL
o5tionLMAR?Co5tionL
o5tionLAPR1/Co5tionL
o5tionLMA<Co5tionL
o5tionL@=3-Co5tionL
o5tionL@=/<Co5tionL
o5tionLA=GCo5tionL
o5tionLS-P0Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 48/180
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
sele't nameNyrNL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
in5ut ty5eNsubmitN nameNSubmitN alueNR-P2R0NL
CtdL
CtrL
trL
td 'ols5anN"N b'olorNO!!!!>>NL;nbs5ICtdL
CtrL
CtableL
CformL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 49/180
CbodyL
ChtmlL
E+/ /'(,%$/=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionNem5Q5ayQsli5.js5NL
5L;nbs5IC5L
table %idthN+YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNO>>>>!!NL M230?/< SA/AR< S/1PCfontLCbLCtdL
CtrL
trL
td %idthN"&YNLS-/-0 M230? ;am5I <-ARCtdL
td %idthN+*YNL
sele't nameNmnNL
o5tionL@A3Co5tionL
o5tionL>-BCo5tionL
o5tionLMAR?Co5tionL
o5tionLAPR1/Co5tionL
o5tionLMA<Co5tionL
o5tionL@=3-Co5tionL
o5tionL@=/<Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 50/180
o5tionLA=GCo5tionL
o5tionLS-P0Co5tionL
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
sele't nameNyrNL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
Csele'tL
CtdL
CtrL
tr b'olorNO>>>>!!NL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
in5ut ty5eNsubmitN nameNSubmitN alueN PA<S/1PNL
CtdL
CtrL
CtableL
CformL
CbodyL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 51/180
ChtmlL
I)!=.#+%
htmlL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tL
frameset ro%sN"Y8[N borderN!NL
frame sr'Nbann.htmlN nameNto5NL
frameset 'olsN$Y8+YN borderN!NL
frame sr'Nmenu.htmlN nameNmenuNL
frame sr'Nmain.htmlN nameNmainNL
CframesetL
CframesetL
noframesL
CnoframesL
ChtmlL
:o)#.%( ,'%'r(=.#+%
htmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 52/180
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionNmonthlyQsalary.js5NL
5L;nbs5IC5Ltable %idthN+YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNONLG-3-RA0- M230?/<
SA/AR<CfontLCbLCtdL
CtrL
trL
td %idthN"&YNLS-/-0 -MP/2<-- A0-G2R<CtdL
td %idthN+*YNL
sele't nameNe'NL
o5tionLA0JACo5tionL
o5tionLA0JBCo5tionL
o5tionLA0JCo5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNLS-/-0 M230? ;am5I <-ARCtdL
td %idthN+*YNL
sele't nameNmnNL
o5tionL@A3Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 53/180
o5tionL>-BCo5tionL
o5tionLMAR?Co5tionL
o5tionLAPR1/Co5tionL
o5tionLMA<Co5tionL
o5tionL@=3-Co5tionL
o5tionL@=/<Co5tionL
o5tionLA=GCo5tionL
o5tionLS-P0Co5tionL
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
sele't nameNyrNL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 54/180
in5ut ty5eNsubmitN nameNSubmitN alueNG-3-RA0- SA/AR<NL
CtdL
CtrL
CtableL
CformL
CbodyL
ChtmlL
:o)#.%( ,'%'r( r!/or#=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionNmonthlyQsalaryQre5ort.js5NL
5La hrefNre5ort.htmlNLBAKCaL UU a hrefNadminQhome.js5NLADM13
?2M-CaLC5L
table %idthN+YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNO>>>>!!NL M230?/< SA/AR<
R-P2R0CfontLCbLCtdL
CtrL
trL
td %idthN"&YNLS-/-0 -MP/2<-- A0-G2R<CtdL
td %idthN+*YNL
sele't nameNe'NL
o5tionLA0JACo5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 55/180
o5tionLA0JBCo5tionL
o5tionLA0JCo5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNLS-/-0 M230? ;am5I <-ARCtdL
td %idthN+*YNL
sele't nameNmnNL
o5tionL@A3Co5tionL
o5tionL>-BCo5tionL
o5tionLMAR?Co5tionL
o5tionLAPR1/Co5tionL
o5tionLMA<Co5tionL
o5tionL@=3-Co5tionL
o5tionL@=/<Co5tionL
o5tionLA=GCo5tionL
o5tionLS-P0Co5tionL
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
sele't nameNyrNL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 56/180
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
in5ut ty5eNsubmitN nameNSubmitN alueNR-P2R0NL
CtdL
CtrL
trL
td 'ols5anN"N b'olorNO!!!!>>NL;nbs5ICtdL
CtrL
CtableL
CformL
CbodyL
ChtmlL
P'(,%$/=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 57/180
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionN5ayQsli5.js5NL
5L;nbs5IC5Ltable %idthN+YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNO>>>>!!NLG-3-RA0- M230?/< SA/AR<
S/1PCfontLCbLCtdL
CtrL
trL
td %idthN"&YNLS-/-0 -MP/2<-- A0-G2R<CtdL
td %idthN+*YNL
sele't nameNe'NL
o5tionLA0JACo5tionL
o5tionLA0JBCo5tionL
o5tionLA0JCo5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNLS-/-0 M230? ;am5I <-ARCtdL
td %idthN+*YNL
sele't nameNmnNL
o5tionL@A3Co5tionL
o5tionL>-BCo5tionL
o5tionLMAR?Co5tionL
o5tionLAPR1/Co5tionL
o5tionLMA<Co5tionL
o5tionL@=3-Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 58/180
o5tionL@=/<Co5tionL
o5tionLA=GCo5tionL
o5tionLS-P0Co5tionL
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
sele't nameNyrNL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
in5ut ty5eNsubmitN nameNSubmitN alueNG-3-RA0- PA<S/1PNL
CtdL
CtrL
CtableL
CformL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 59/180
CbodyL
ChtmlL
R!/or#=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
table %idthN&!YN borderN!N heihtN$+NL
trL
td b'olorNO>>>>!!N heihtN*NL
h alinN'enterNLfont 'olorNO!!!!>>NLbLR-P2R0CbLCfontLChL
CtdL
CtrL
trL
td b'olorNO>>>>>>N heihtN++NL
di alinNrihtNL
5 alinNleftNLim sr'Nbanner.j5N %idthN+!N heihtN!NLC5L
5La hrefNadminQhome.js5NLBa' to ontrol PanelCaLC5L
CdiL
CtdL
CtrL
trL
tdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 60/180
di alinN'enterNLa hrefNsalaryQre5ort.js5NLfont fa'eNourier 3e%8 ourier8
monoNL-MP/2<--
GR2SS SA/AR< S0A0-M-30CfontLCaLCdiL
CtdL
CtrL
trL
tdL
di alinN'enterNLfont fa'eNourier 3e%8 ourier8 monoNLa
hrefNmonthlyQsalaryQre5ort.htmlNL-MP/2<--
M230?/< SA/AR< R-P2R0CaLCfontLCdiL
CtdL
CtrL
trL
tdL
di alinN'enterNLa hrefNallQem5QdetailQre5ort.js5NLfont fa'eNourier 3e%8 ourier8
monoNL-MP/2<--
D-0A1/ R-P2R0CfontLCaLCdiL
CtdL
CtrL
trL
tdL
di alinN'enterNLa hrefNallQem5QloinQinfo.js5NLfont fa'eNourier 3e%8 ourier8monoNL-MP/2<--
/2G13 R-P2R0CfontLCaLCdiL
CtdL
CtrL
CtableL
CbodyL
ChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 61/180
S'%'r(=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5IC5L
5La hrefNadminQhome.js5NLBa' to ontrol PanelCaLC5L
table %idthN*,YN borderNNL
trL
td b'olorNO!!!!>>NL
di alinN'enterNLfont 'olorNO>>>>>>NLbLfont siEeNN fa'eNourier 3e%8
ourier8 monoNLSA/AR<CfontLCbLCfontLCdiL
CtdL
CtrL
trL
tdLa hrefNmonthlyQsalary.htmlNLfont fa'eNourier 3e%8 ourier8 monoNLG-3-RA0-
M230?/< SA/AR<CfontLCaLCtdL
CtrL
trL
tdLfont fa'eNourier 3e%8 ourier8 monoNLa hrefNu5dateQsal.js5NLM2D1><
-MP/2<-- SA/AR<CaLCfontLCtdL
CtrL
trL
tdLfont fa'eNourier 3e%8 ourier8 monoNLa hrefN5ayQsli5.htmlNLG-3-RA0-
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 62/180
PA< S/1PCaLCfontLCtdL
CtrL
CtableL
CbodyL
ChtmlL
U/'#! !+/=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbL=PDA0- -MP/2<--CbLChL
h*LbLa hrefNem5.htmlNLBa' CaLCbLCh*L
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
5Lobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN$+N heihtN"#NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNtet.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNNL
5aram nameNSA/-N alueNea'tfitNL
embed sr'Ntet.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN s'aleNea'tfitN
%idthN$+N heihtN"#N b'olorNN baseN.NL
CembedL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 63/180
Cobje'tLC5L
5Lobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN*"N heihtN"#NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNtet+.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNNL
5aram nameNSA/-N alueNea'tfitNL
embed sr'Ntet+.s%fN 9ualityhih 5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN s'aleNea'tfitN
%idthN*"N heihtN"#N b'olorNN baseN.NL
CembedL
Cobje'tLC5L
CbodyL
ChtmlL
U/'#! ,'%'r(=.#+%
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
form nameNformN methodN5ostN a'tionNu5dateQsalary.js5NL
5L;nbs5IC5L
table %idthN+YN borderNNL
tr b'olorNO!!!!>>NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 64/180
td 'ols5anN"NLbLfont 'olorNONLM2D1>< -MP/2<--
SA/AR<CfontLCbLCtdL
CtrL
trL
td %idthN"&YNL-30-R -MP/2<-- 1DCtdL
td %idthN+*YNL
in5ut ty5eNtetN nameNidNL
CtdL
CtrL
trL
td %idthN"&YNL;nbs5ICtdL
td %idthN+*YNL
in5ut ty5eNsubmitN nameNSubmitN alueNG-3-RA0- SA/AR<NL
CtdL
CtrL
CtableL
CformL
CbodyL
ChtmlL
U,!r %o;$)=.#+%
htmlL
headL
titleLSubmission formCtitleL
CheadL
body b'olorNO,,##NL
im sr'N5ids.j5N alterNa'a'N %idth+$$ heihtN!NL
di alinN'enterNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 65/180
form method5ost a'tionfile:CCCUCProramY"!>ilesCA5a'heY"!Soft%are
Y"!>oundationC0om'atY"!&.!C%eba55sC1-1/Caliduser.js5 L
5LbLfont 'olorNO>>>>!!N siEeN*NL-m5loyee /oinCfontLCbLC5L
5LbLfont 'olorNO>>>>>>NL=S-R 1D CfontLCbLfont'olorNO>>>>>>NL;nbs5;nbs5;nbs5;nbs5;nbs5
in5ut ty5etet nameNnmN siEeN"!NL
brL
brL
brL
bL PASS42RD CbL
in5ut ty5e5ass%ord nameN5%dN siEeN"!NL
CfontLbrL
brL
brL
in5ut ty5esubmit nameloin styleN'olor: bla'I fontJ%eiht: boldI ba'roundJ'olor:
yello%NL
in5ut ty5eNresetN nameNResetN alueNResetN styleN'olor: bla'I fontJ%eiht: boldI
ba'roundJ'olor: yello%NL
C5L
CformL
CdiL
brLbrL
bLfont 'olorNO>>>>>>NL;'o5y o5yriht "!*8 Desined and Deelo5ed by
Dhiraj8Ali........
De5t of 'se8Dhenanal. CfontLCbLCbodyLChtmlL
7=1=2 =JSP CODES
A !+/=,/
htmlL
headL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 66/180
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tL
styleL
in5ut
fontJfamily: erdanaI
fontJsiEe: 5I
border: OBBB 5 solidI
ba'roundJ'olor: O------I
T
.ttSmall
fontJfamily: erdanaI
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 67/180
fontJsiEe: ,5I
fontJ%eiht: normalI
'olor: O!!!!!!I
T
CstyleL
styleL
hfilter:shado%I
'olor:blueI
%idth:!!!5I
T
CstyleL
lin relXstylesheetX hrefX.C'alendar.'ssX titleX'alendarXL
s'ri5t lanuaeNjaas'ri5tN sr'N'alendar.jsNLCs'ri5tL
s'ri5t lanuaeNjaas'ri5tNL
CC[[[[[ >un'tion formatin the Date for in5utbo [[[[[
fun'tion fnSetDate>ormat(oDate>ormat)
oDate>ormatVX>ull<earXWI CC-am5le "!!+
oDate>ormatVX<earXWI CC-am5le !+
oDate>ormatVX>ullMonth3ameXWI CC-am5le @anuary
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 68/180
oDate>ormatVXMonth3ameXWI CC-am5le @an
oDate>ormatVXMonthXWI CC-am5le !
oDate>ormatVXDateXWI CC-am5le !
oDate>ormatVX>ullDayXWI CC-am5le Sunday
oDate>ormatVXDayXWI CC-am5le Sun
oDate>ormatVX?oursXWI CC-am5le !
oDate>ormatVXMinutesXWI CC-am5le !
oDate>ormatVXSe'ondsXWI CC-am5le !
ar sDateStrinI
CC-am5le !C!C!! ddCmmCyy
CCsDateStrin oDate>ormatVXDateXW \NCN\ oDate>ormatVXMonthXW \NCN\
oDate>ormatVX<earXWI
CC-am5le !C!C!!!! ddCmmCyyyy
CCsDateStrin oDate>ormatVXDateXW \NCN\ oDate>ormatVXMonthXW \NCN\
oDate>ormatVX>ull<earXWI
CC-am5le !!!!J!J! yyyyCmmCdd
CCsDateStrin oDate>ormatVX>ull<earXW \NJN\ oDate>ormatVXMonthXW \NJN\
oDate>ormatVXDateXWI
CC-am5le @anJ!J!!!! MmmCddCyyyy
CCsDateStrin oDate>ormatVXMonth3ameXW \NJN\ oDate>ormatVXDateXW \NJN\
oDate>ormatVX>ull<earXWI
return sDateStrinI
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 69/180
Cs'ri5tL
s'ri5t ty5eNtetCjaas'ri5tNL
fun'tion alidate>orm()
ar enamedo'ument.formsVNformNWVNenNW.alueI
if (enamenull UU enameNN)
alert(N-nter -m5loyee nameN)I
return falseI
T
Cs'ri5tL
s'ri5t ty5eNtetCjaas'ri5tNL
fun'tion namealidate(tem5)
ar l tem5.alue.lenthI
for(ar i!I ilI i\\)
CCariable 'h %ill store as'ii 'ode for the strin 'hara'ter at inde i
ar 'h tem5.alue.'harodeAt(i)I
if((('hL& ;; 'h,!) UU ('hL,+ ;; 'h"") UU ('h#")))
alert(N-nter 'hara'ters onlyN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 70/180
tem5.alueNNI
eitI
T
T
T
fun'tion alidatePhone(tem5)
ar l tem5.alue.lenthI
CClert(heart)I
if((l!))
alert(NPhone number should be of ! diitN)I
tem5.alueNNI
T
else
for(ar i!I i,I i\\)
ar 'h tem5.alue.'harodeAt(i)I
if(('hL*$ ;; 'h+))
alert(NPhone 3umber should be diits onlyN)I
tem5.alueNNI
eitI
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 71/180
T
T
T
fun'tion alidateBlan(tem5)
ar l tem5.alue.lenthI
if (l null UU l NN)
alert(NData re9uired ...N)I
tem5.alueNNI
eitI
T
T
fun'tion alidateMail()
ar do'ument.formsVNformNWVNmdNW.alueI
ar at5os.inde2f(N]N)I
ar dot5os.last1nde2f(N.N)I
if (at5os UU dot5osat5os\" UU dot5os\"L.lenth)
alert(N3ot a alid eJmail addressN)I
return falseI
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 72/180
T
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!N onloadXdo'ument.form.en.fo'us()XL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
int 8"I
Strin sI
YL
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement(ResultSet.0<P-QSR2//QS-3S101-8ResultSet.23=RQR-A
DQ23/<)I
rsst.ee'uteHuery(Nsele't [ from em5Q5erN)I
if(rs.last())
srs.etStrin(NloinQidN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 73/180
1nteer.5arse1nt(s)I
"\I
YL
h"Lfont 'olorNO!!!!>>NLbLfont 'olorNO>>!!!!NLADD -MP/2<--
CfontLCbLCfontLCh"L
bLfont 'olorNO!!!!>>NLa hrefNem5.htmlNLBa'CaL UU font 'olorNO!!!!!!NLa
hrefNadminQhome.js5NLAdmin
?omeCaLCfontLCfontLCbL
form nameNformN methodN5ostN a'tionNaddQem5Qsubmit.js5NL
table %idthN&YN borderNN heihtN#NL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLbLfont 'olorNO>>>>>>NL-MP/2<-- P-RS23A/
D-0A1/CfontLCbLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNL/2G13
1DCfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNidN alueNY " YLN siEeN*!N readonlyL
CfontLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNL-MP/2<--
3AM-CfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNenN siEeN*!N re9uired onblurNnamealidate(this)N L
CfontLCtdL
CtrL
trL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 74/180
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8
monoNLH=A/1>1A0123CfontLCbLCtdL
td %idthN&,YNL
sele't nameN9uNL
o5tionLB.0-?.Co5tionL
o5tionLM.0-?Co5tionL
o5tionLM.S.Co5tionL
o5tionLP?DCo5tionL
o5tionLM.A.Co5tionL
o5tionLB.ACo5tionL
o5tionLB.S.Co5tionL
o5tionL1.A.Co5tionL
o5tionL1.S.Co5tionL
o5tionL?SCo5tionL
Csele'tL
CtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNLDA0- 2>
@21313GCfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5etet nameXdjX idXttalendar>ourthX 'lassXin5utBoStyleX readonly siEeN#!NL
im sr'X'al.ifX onMouse2erNfn1nitalendar(this8 Xttalendar>ourthX8
Xstyle'alendarQblue.'ss8instan'esinleX)N alinXabsmiddleX %idthN*N heihtN$N L
CfontLCtdL
CtrL
trL
td %idthN#YN heihtN+#NLbLfont fa'eNourier 3e%8 ourier8
monoNLADDR-SSCfontLCbLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 75/180
td %idthN&,YN heihtN+#NLfont fa'eNourier 3e%8 ourier8 monoNL
tetarea nameNadN 'olsN*!N re9uired onblurNalidateBlan(this)NLCtetareaL
CfontLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8
monoNLD-S1G3A0123CfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNdeN siEeN*!N re9uired onblurNnamealidate(this)NL
CfontLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8
monoNLD-PAR0M-30CfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
sele't nameNde5NL
o5tionLom5.S'. -nCo5tionL
o5tionL-le'tri'al -nCo5tionL
o5tionL-le'troni's ;am5I0ele'omm. -nCo5tionL
o5tionLMe'hani'al -nCo5tionL
o5tionLiil -nCo5tionL
o5tionLAdministratie StaffCo5tionL
o5tionL-am Se'tionCo5tionL
o5tionL/ibrary StaffCo5tionL
o5tionLSe'urity StaffCo5tionL
o5tionLlass 1 StaffCo5tionL
Csele'tL
CfontLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 76/180
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNL-MP/2<--
0<P-CfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
sele't nameNetNL
o5tionLA0JACo5tionL
o5tionLA0JBCo5tionL
o5tionLA0JCo5tionL
Csele'tL
CfontLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNLD2BCfontLCbLCtdL
td %idthN&,YNLbLfont fa'eNourier 3e%8 ourier8 monoNL Date
sele't nameNddNL
o5tionLCo5tionL
o5tionL"Co5tionL
o5tionL#Co5tionL
o5tionL*Co5tionL
o5tionLCo5tionL
o5tionL&Co5tionL
o5tionL+Co5tionL
o5tionL$Co5tionL
o5tionL,Co5tionL
o5tionL!Co5tionL
o5tionLCo5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 77/180
o5tionL"Co5tionL
o5tionL#Co5tionL
o5tionL*Co5tionL
o5tionLCo5tionL
o5tionL&Co5tionL
o5tionL+Co5tionL
o5tionL$Co5tionL
o5tionL,Co5tionL
o5tionL"!Co5tionL
o5tionL"Co5tionL
o5tionL""Co5tionL
o5tionL"#Co5tionL
o5tionL"*Co5tionL
o5tionL"Co5tionL
o5tionL"&Co5tionL
o5tionL"+Co5tionL
o5tionL"$Co5tionL
o5tionL",Co5tionL
o5tionL#!Co5tionL
o5tionL#Co5tionL
Csele'tL
Month
sele't nameNmmNL
o5tionL@A3Co5tionL
o5tionL>-BCo5tionL
o5tionLMARCo5tionL
o5tionLAPRCo5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 78/180
o5tionLMA<Co5tionL
o5tionL@=3Co5tionL
o5tionL@=/Co5tionL
o5tionLA=GCo5tionL
o5tionLS-PCo5tionL
o5tionL20Co5tionL
o5tionL32Co5tionL
o5tionLD-Co5tionL
Csele'tL
;nbs5I <-AR
sele't nameNyyNL
o5tionL,$!Co5tionL
o5tionL,$Co5tionL
o5tionL,$"Co5tionL
o5tionL,$#Co5tionL
o5tionL,$*Co5tionL
o5tionL,$Co5tionL
o5tionL,$&Co5tionL
o5tionL,$+Co5tionL
o5tionL,$,Co5tionL
o5tionL,,!Co5tionL
o5tionL,,Co5tionL
o5tionL,,"Co5tionL
o5tionL,,#Co5tionL
o5tionL,,*Co5tionL
o5tionL,,Co5tionL
o5tionL,,&Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 79/180
o5tionL,,+Co5tionL
o5tionL,,$Co5tionL
o5tionL,,,Co5tionL
o5tionL"!!!Co5tionL
o5tionL"!!Co5tionL
o5tionL"!!"Co5tionL
o5tionL"!!#Co5tionL
o5tionL"!!*Co5tionL
o5tionL"!!Co5tionL
o5tionL"!!&Co5tionL
o5tionL"!!+Co5tionL
o5tionL"!!$Co5tionL
o5tionL"!!,Co5tionL
o5tionL"!!Co5tionL
o5tionL"!Co5tionL
o5tionL"!"Co5tionL
o5tionL"!"Co5tionL
o5tionL"!#Co5tionL
o5tionL"!#Co5tionL
o5tionL"!*Co5tionL
o5tionL"!Co5tionL
o5tionL"!&Co5tionL
o5tionL"!+Co5tionL
o5tionL"!$Co5tionL
o5tionL"!,Co5tionL
o5tionL"!"!Co5tionL
o5tionL"!"Co5tionL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 80/180
o5tionL"!""Co5tionL
o5tionL"!"#Co5tionL
o5tionL"!"*Co5tionL
Csele'tL
CfontLCbLCtdL
CtrL
trL
td %idthN#YN heihtN"NLbLfont fa'eNourier 3e%8 ourier8
monoNLG-3D-RCfontLCbLCtdL
td %idthN&,YN heihtN"NLbLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNradioN nameNenN alueNMaleNL
Male
in5ut ty5eNradioN nameNenN alueN>emaleNL
>emaleCfontLCbLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNLM2B1/-
32CfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNmbN siEeN*!N re9uired onblurNalidatePhone(this)NL
CfontLCtdL
CtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoNLMA1/
1DCfontLCbLCtdL
td %idthN&,YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNmdN siEeN*!N re9uired onblurNalidateMail()NL
CfontLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 81/180
CtrL
tr b'olorNO!!!!>>NL
td 'ols5anN"NL
di alinN'enterNLfont fa'eNourier 3e%8 ourier8 monoNLCfontLfont fa'eNourier
3e%8 ourier8 monoNL
in5ut ty5eNsubmitN nameNSubmitN onli'Nalidate>orm()N alueNontinueNL
CfontLCdiL
CtdL
CtrL
CtableL
CformL
Y
T
T
'at'h(-'e5tion e)
T
YL
CbodyL
ChtmlL
A !+/ ,3+$#=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5tL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 82/180
fun'tion 5rint4indo%()
b 5arse1nt(naiator.a55ersion)
if (b L *) %indo%.5rint()
T
Cs'ri5tL
s'ri5tL
fun'tion alidateBlan(tem5)
ar l tem5.alue.lenthI
if (l null UU l NN)
alert(NData re9uired ... N)I
tem5.alueNNI
eitI
T
T
fun'tion alidate3umber()
ar numbers C^V!J,W\_CI
if(do'ument.form.ba.alue.mat'h(numbers))
return trueI
T
else
alert(X-nter only numeri' alueX)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 83/180
do'ument.form.ba.fo'us()I
return falseI
T
T
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5I
a hrefNjaas'ri5t:5rint4indo%()NLPR130CaLC5L
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
onne'tion 'onI
Pre5aredStatement stI
Strin s8s"8s#8s*8s8s&8s+8s$8s,8s!8s8s"8s#8s*I
int resI
YL
Y
`sre9uest.etParameter(NidN)I
s"re9uest.etParameter(NenN)I
s#re9uest.etParameter(N9uN)I
s*re9uest.etParameter(NdjN)I
sre9uest.etParameter(NadN)I
s&re9uest.etParameter(NdeN)I
s+re9uest.etParameter(Nde5N)I
s$re9uest.etParameter(NetN)I
s,re9uest.etParameter(NddN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 84/180
s!re9uest.etParameter(NmmN)I
sre9uest.etParameter(NyyN)I
s"re9uest.etParameter(NenN)I
s#re9uest.etParameter(NmbN)I
s*re9uest.etParameter(NmdN)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into em5Q5er alues(8888888888888)N)I
st.set1nt(81nteer.5arse1nt(s))I
st.setStrin("8s")I
st.setStrin(#8s#)I
st.setStrin(*8s*)I
st.setStrin(8s)I
st.setStrin(&8s&)I
st.setStrin(+8s+)I
st.setStrin($8s$)I
st.setStrin(,8s,)I
st.setStrin(!8s!)I
st.setStrin(8s)I
st.setStrin("8s")I
st.setStrin(#8s#)I
st.setStrin(*8s*)I
st.ee'ute=5date()I
T
'at'h(-'e5tion e)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 85/180
T
YL
form nameNformN methodN5ostN a'tionNaddQsalQsubmit.js5NL
table %idthN#+YN borderNN heihtN"NL
tr b'olorNO!!!!>>NL
td 'ols5anN"N heihtNNLdi alinN'enterNLfont
'olorNO>>>>>>NLbL-MP/2<-- SA/AR< D-0A1/CbLCfontLCdiL
CtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNL/2G13 1DCfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN alueNY s YLN nameNidN readonlyL
CfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNLA2=30
3=MB-RCfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNa'N re9uired onblurNalidateBlan(this)NL
font 'olorNO>>!!!!NL[CfontLCfontLCtdLCtrL
trL
td %idthN*YNLfont faJ'eNourier 3e%8 ourier8 monoNLBAS1
SA/AR<CfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNbaN re9uired onblurNalidate3umber()NL
font 'olorNO>>!!!!NL[CfontLCfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNL0ACfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 86/180
in5ut ty5eNtetN nameNtaN alueN!NL
CfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNLDACfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNdaN alueN!NL
CfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNL?RACfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNhrN alueN!NL
CfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNL20?-R
A//24A3-CfontLCtdL
td %idthN*&YNLfont fa'eNourier 3e%8 ourier8 monoNL
in5ut ty5eNtetN nameNoaN alueN!NL
CfontLCtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNL-P>CfontLCtdL
td %idthN*&YNL
in5ut ty5eNtetN nameNe5fN alueN!NL
CtdLCtrL
trL
td %idthN*YNLfont fa'eNourier 3e%8 ourier8 monoNLPR2>-SS123A/
0AZCfontLCtdL
td %idthN*&YNL
in5ut ty5eNtetN nameN5tN alueN!NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 87/180
CtdLCtrL
tr b'olorNO!!!!>>NL
td 'ols5anN"NL
di alinN'enterNL
in5ut ty5eNsubmitN nameNSubmitN alueN23013=-NL
in5ut ty5eNresetN nameNSubmit"N alueNR-S-0NL
CdiLCtdLCtrLCtableLCformL
5LbrL
C5LCbodyLChtmlL
A %o;$)=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5tL
fun'tion 5rint4indo%()
b 5arse1nt(naiator.a55ersion)
if (b L *) %indo%.5rint()
T
Cs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5I a hrefNjaas'ri5t:5rint4indo%()NLPR130CaL UUa hrefNadminQhome.js5NL
Admin ?omeCaLC5L
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
onne'tion 'onI
Pre5aredStatement stI
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 88/180
Strin s8s"8s#I
YL
Y
sN-m5loyeeNI
s"re9uest.etParameter(NidN)I
s#re9uest.etParameter(N5%dN)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into loin alues(88)N)I
st.setStrin(8s)I
st.set1nt("81nteer.5arse1nt(s"))I
st.setStrin(#8s#)I
st.ee'ute=5date()I
T
'at'h(-'e5tion e)
T
YL
5L;nbs5IC5Ltable %idthN+YN borderNNL
trL
tdL
di alinN'enterNL
h"LbL-m5loyee Reistration Sli5CbLCh"L
CdiLCtdLCtrL
trL
tdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 89/180
h# alinN'enterNL-m5loyee Data su''essfully 'reated %ith font 'olorNO>>!!!!NL/oin
1DCfontLYs" YL And font 'olorNO>>!!!!NLPass%ordCfontLYs# YL
Ch#LCtdLCtrLCtableL
h"L;nbs5ICh"L
h"L;nbs5ICh"L
CbodyLChtmlL
A,'% ,3+$#=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5tL
fun'tion 5rint4indo%()
b 5arse1nt(naiator.a55ersion)
if (b L *) %indo%.5rint()
T
Cs'ri5tL
s'ri5tL
fun'tion alidatePass(tem5)
ar l tem5.alue.lenthI
CClert(heart)I
if((l&))
alert(NPass%ord should be of & 'hara'terC diitN)I
tem5.alueNNI
TT
Cs'ri5tL
CheadL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 90/180
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5I
a hrefNjaas'ri5t:5rint4indo%()NLPR130CaLC5L
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
onne'tion 'onI
Pre5aredStatement stI
Strin s8s"8s#8s*8s8s&8s+8s$8s,I
int s!8resI
YL
Y
sre9uest.etParameter(NidN)I
s"re9uest.etParameter(Na'N)I
s#re9uest.etParameter(NbaN)I
s*re9uest.etParameter(NtaN)I
sre9uest.etParameter(NdaN)I
s&re9uest.etParameter(NhrN)I
s+re9uest.etParameter(NoaN)I
s$re9uest.etParameter(Ne5fN)I
s,re9uest.etParameter(N5tN)I
s!(1nteer.5arse1nt(s#)\1nteer.5arse1nt(s*)\1nteer.5arse1nt(s)\1nteer.5arse1nt(s&)\1nte
er.5arse1nt(s+))J(1nteer.5arse1nt(s$)\1nteer.5arse1nt(s,))I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into em5Qsal alues(888888888)N)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 91/180
st.set1nt(81nteer.5arse1nt(s))I
st.setStrin("8s")I
st.set1nt(#81nteer.5arse1nt(s#))I
st.set1nt(*81nteer.5arse1nt(s*))I
st.set1nt(81nteer.5arse1nt(s))I
st.set1nt(&81nteer.5arse1nt(s&))I
st.set1nt(+81nteer.5arse1nt(s+))I
st.set1nt($81nteer.5arse1nt(s$))I
st.set1nt(,81nteer.5arse1nt(s,))I
st.set1nt(!8s!)I
st.ee'ute=5date()I
T
'at'h(-'e5tion e)
T
YL
form nameNformN methodN5ostN a'tionNaddQloin.js5NL
table %idthN#+YN borderNN heihtN"$NL
tr b'olorNO!!!!>>NL
td 'ols5anN"N heihtNNL
di alinN'enterNLfont 'olorNO>>>>>>NLbL-MP/2<-- /2G13D-0A1/CbLCfontLCdiL
CtdLCtrL
trL
td %idthN#YN heihtN#NLfont fa'eNourier 3e%8 ourier8 monoNL/2G13
1DCfontLCtdL
td %idthN&YN heihtN#NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 92/180
in5ut ty5eNtetN alueNY s YLN readonly nameNidNL
CtdLCtrL
trL
td %idthN#YNLfont fa'eNourier 3e%8 ourier8 monoNLPASS42RDCfontLCtdL
td %idthN&YNLfont 'olorNO>>!!!!NL
in5ut ty5eNtetN nameN5%dN re9uired onblurNalidatePass(this)NL
[CfontL (-nter & 'har'aterC diit )CtdLCtrL
tr b'olorNO!!!!>>NL
td 'ols5anN"NL
di alinN'enterNL
in5ut ty5eNsubmitN nameNSubmitN alueNS=BM10NL
in5ut ty5eNresetN nameNSubmit"N alueNR-S-0NL
CdiLCtdLCtrLCtableLCformL
5LbrLC5LCbodyLChtmlL
A+$)!%!#! !+/=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
int 8"I
Strin sI
YL
Y
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 93/180
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5erN)I
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbLD-/-0- -MP/2<-- CbLChL
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNadminQdeleteQem5Qsubmit.js5NLS-/-0
-MP/2<-- 1D C /2G13 1D sele't nameNidNL
Y
%hile(rs.net())
YL
o5tionLY rs.et1nt(NloinQidN) YLCo5tionL
Y
T
YLCsele'tL
in5ut ty5eNsubmitN nameNSubmitN alueND-/-0- -MP/2<--NLCformL
hL;nbs5IChL
Y
T
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 94/180
A+$)!%!#!!+/,3+$#=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
int rsI
onne'tion 'onI
Statement st8stI
Strin sI
YL
Y
try
sre9uest.etParameter(NidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
st'on.'reateStatement()I
rsst.ee'ute=5date(Ndelete 'as'ade from em5Q5er %here loinQidN\s\NN)I
st.ee'ute=5date(Ndelete from em5Qsal %here loinQidN\s\NN)I
T
'at'h(-'e5tion e)
T
YL
js5:for%ard 5aeNdelQsu''ess.js5N CLCbodyLChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 95/180
A+$).o+!=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbLfont 'olorNO!!!!>>NL;nbs5I;nbs5I230R2/ PA3-/CfontLCbLChL
h alinNleftNLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
h"L;nbs5I;nbs5Iobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN!#N heihtN"*NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNbutton+.s%fNL
5aram name9uality aluehihL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 96/180
5aram nameNBG2/2RN alueNO>>>>>>NL
embed sr'Nbutton+.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!#N
heihtN"*N b'olorNO>>>>>>N baseN.NL
CembedL
Cobje'tLobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN!#N heihtN"*NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNbutton!.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNO>>>>>>NL
embed sr'Nbutton!.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!#N
heihtN"*N b'olorNO>>>>>>N baseN.NL
CembedL
Cobje'tLobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN!#N heihtN"*NL
5aram nameNBAS-N alueN.NL
5aram namemoie alueNbutton+.s%fNL
5aram name9uality aluehihL
5aram nameNBG2/2RN alueNNL
embed sr'Nbutton+.s%fN 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!#N
heihtN"*N b'olorNN baseN.NL
CembedL
Cobje'tLobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion*8!8"8!N %idthN!#N heihtN"*NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 97/180
5aram namemoie alueNbutton,.s%fNL
5aram name9uality aluehihL
5aram nameNBAS-N alueN.NL
5aram nameNBG2/2RN alueNNL
embed sr'Nbutton,.s%fN baseN.N 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN!#N
heihtN"*N b'olorNNL
CembedL
Cobje'tLfont
siEeNNL;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I
;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs
5I;nbs5I;nbs5I;nbs5I;nbs5Ia hrefNmain.htmlNL;nbs5I/o
out CaLCfontLCh"L
h"L;nbs5ICh"L
h" alinNrihtNL;nbs5ICh"L
di idN/ayerN styleN5osition:absoluteI %idth:&++5I heiht:I EJinde:I left: "!5I
to5: +$5NLim sr'Nbanner.j5N %idthN+!N heihtN!NLCdiL
CbodyL
ChtmlL
A+$) /'#! !+/ /!r=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 98/180
ResultSet rsI
onne'tion 'onI
Statement stI
int 8"I
Strin sI
YL
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5erN)I
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbL=PDA0- -MP/2<-- P-RS23A/ D-0A1/CbLChL
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNadminQu5dateQem5Q5er".js5NL
S-/-0 -MP/2<-- 1D C /2G13 1D
sele't nameNidNL
Y
%hile(rs.net())
YL
o5tionLY rs.et1nt(NloinQidN) YLCo5tionL
Y
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 99/180
YL
Csele'tL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0-NL
CformL
hL;nbs5IChL
Y
T
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
A+$) /'#! !+/ /!r2=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5tL
fun'tion alidatePhone(tem5)
ar l tem5.alue.lenthI
CClert(heart)I
if((l!))
alert(NPhone number should be of ! diitN)I
tem5.alueNNI
T
else
for(ar i!I i,I i\\)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 100/180
ar 'h tem5.alue.'harodeAt(i)I
if(('hL*$ ;; 'h+))
alert(NPhone 3umber should be diits onlyN)I
tem5.alueNNI
eitI
TT TT
fun'tion alidateMail()
ar do'ument.formsVNformNWVNmdNW.alueI
ar at5os.inde2f(N]N)I
ar dot5os.last1nde2f(N.N)I
if (at5os UU dot5osat5os\" UU dot5os\"L.lenth)
alert(N3ot a alid eJmail addressN)I
return falseI
TT
fun'tion namealidate(tem5)
ar l tem5.alue.lenthI
for(ar i!I ilI i\\)
CCariable 'h %ill store as'ii 'ode for the strin 'hara'ter at inde i
ar 'h tem5.alue.'harodeAt(i)I
if((('hL& ;; 'h,!) UU ('hL,+ ;; 'h"") UU ('h#")))
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 101/180
alert(N-nter 'hara'ters onlyN)I
tem5.alueNNI
eitI
TTT
Cs'ri5tL
s'ri5tL
ar ddo'ument.formsVNformNWVNdNW.alueI
alert(N-nter -m5loyee DesinationN)I
return falseI
T
ar 5honeno C^d!T_CI
if(do'ument.form.mn.alue.mat'h(5honeno))
do'ument.form.mn.fo'us()I
return trueI
T
else
alert(N3ot a alid Phone 3umberN)I
do'ument.form.mn.fo'us()I
return falseI
T
ar do'ument.formsVNformNWVNmdNW.alueI
ar at5os.inde2f(N]N)I
ar dot5os.last1nde2f(N.N)I
if (at5os UU dot5osat5os\" UU dot5os\"L.lenth)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 102/180
alert(N3ot a alid eJmail addressN)I
return falseI
T
if (null UU NN)
alert(N-nter alid email idN)I
return falseI
TT
Cs'ri5tLCheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin sI
YL
Y
try
sre9uest.etParameter(NidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5er %here loinQidN\s\NN)I
if(rs.net())
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 103/180
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
h"LbL=PDA0- -MP/2<-- P-RS23A/ D-0A1/CbLCh"L
h*LbLa hrefNem5.htmlNLBa' CaLCbLCh*L
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNadminQu5dateQem5Q5er#.js5NL
table %idthN+YN borderNNL
trL
td %idthN",YNL=PDA0- ADDR-SSCtdL
td %idthN+YNL
tetarea nameNadNLY rs.etStrin(NaddressN) YLCtetareaL
in5ut ty5eNhiddenN nameNidN alueNY s YLNL
CtdL
CtrL
trL
td %idthN",YNL=PDA0- D-S1G3A0123CtdL
td %idthN+YNL
in5ut ty5eNtetN nameNdNalueNY rs.etStrin(NdesN) YLN re9uired
onblurNnamealidate(this)N L
CtdL
CtrL
trL
td %idthN",YNLM2B1/- 32CtdL
td %idthN+YNL
in5ut ty5eNtetN nameNmnN alueNY rs.etStrin(NmobN) YLN re9uiredonblurNalidatePhone(this)N L
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 104/180
CtdL
CtrL
trL
td %idthN",YNLMA1/ 1DCtdL
td %idthN+YNL
in5ut ty5eNtetN nameNmdN alueNY rs.etStrin(NmailN) YLN re9uired
onblurNalidateMail()NL
CtdL
CtrL
trL
td %idthN",YNL;nbs5ICtdL
td %idthN+YNL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0-NL
CtdL
CtrL
CtableL
CformL
hL;nbs5IChL
Y
T
T
'at'h(-'e5tion e)
T
YL
CbodyL
ChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 105/180
A+$) /'#! !+/ /!r=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
int rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#8s*8sI
YL
Y
try
sre9uest.etParameter(NidN)I
s"re9uest.etParameter(NadN)I
s#re9uest.etParameter(NdN)I
s*re9uest.etParameter(NmnN)I
sre9uest.etParameter(NmdN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 106/180
st'on.'reateStatement()I
rsst.ee'ute=5date(N u5date em5Q5er set addressXN\s"\NX 8 desXN\s#\NX 8 mobXN\s*\NX 8
mailXN\s\NX %here loinQidN\s\NN)I
YL
5La hrefNem5.htmlNLAdmin ?omeCaLC5L
table %idthN##YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLfont 'olorNO>>>>>>NLbL=PDA0-D DA0ACbLCfontLCtdL
CtrL
trL
td %idthN*!YNL=PDA0- ADDR-SSCtdL
td %idthN&!YNLYs" YLCtdL
CtrL
trL
td %idthN*!YNL=PDA0- D-S1G3A0123CtdL
td %idthN&!YNLYs# YLCtdL
CtrL
trL
td %idthN*!YNL=PDA0- M2B1/- 32CtdL
td %idthN&!YNLYs* YLCtdL
CtrL
trL
td %idthN*!YNL=PDA0- MA1/ 1DCtdL
td %idthN&!YNLYs YLCtdL
CtrL
CtableL
Y
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 107/180
T
'at'h(-'e5tion e)
T
YL
CbodyL
ChtmlL
A+$) /'#! /',,8or=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
int 8"I
Strin sI
YL
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 108/180
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5erN)I
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbLfont 'olorNO!!,,NL=PDA0- PASS42RDCfontLCbLChL
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNadminQu5dateQ5ass%ord".js5NL
S-/-0 -MP/2<-- 1D C /2G13 1D
sele't nameNidNL
Y
%hile(rs.net())
YL
o5tionLY rs.et1nt(NloinQidN) YLCo5tionL
Y
T
YL
Csele'tL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0- PASS42RDNL
CformL
hL;nbs5IChL
Y
T
'at'h(-'e5tion e)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 109/180
T
YL
CbodyL
ChtmlL
A+$) /'#! /',,8or2=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin sI
YL
Y
try
sre9uest.etParameter(NidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from loin %here loinQidN\s\NN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 110/180
if(rs.net())
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
h"LbLfont 'olorNO!!,,NL=PDA0- -MP/2<-- PASS42RDCfontLCbLCh"L
h*LbLa hrefNem5.htmlNLBa' CaLCbLCh*L
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNadminQu5dateQ5ass%ord#.js5NL
table %idthN+YN borderNNL
tr b'olorNO!!,,NL
td %idthN",YNLfont 'olorNO>>!!!!NL2/D PASS42RDCfontLCtdL
td %idthN+YNLfont 'olorNO>>!!!!NL
in5ut ty5eNtetN nameN5%dN readonly alueNY rs.etStrin(N5ass%ordN) YLNL
in5ut ty5eNhiddenN nameNidN alueNYs YLNL
CfontLCtdL
CtrL
tr b'olorNO!!,,NL
td %idthN",YNL3-4 PASS42RDCtdL
td %idthN+YN b'olorNO!!,,NL
in5ut ty5eN5ass%ordN nameNn5NL
CtdL
CtrL
tr b'olorNO!!,,NL
td %idthN",YNL23>2RM PASS42RDCtdL
td %idthN+YNL
in5ut ty5eN5ass%ordN nameN'5N L
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 111/180
CtdL
CtrL
trL
td %idthN",YNL;nbs5ICtdL
td %idthN+YNL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0- PASS42RDNL
CtdL
CtrL
CtableL
CformL
hL;nbs5IChL
Y
T
T
'at'h(-'e5tion e)
T
YL
CbodyLChtmlL
A%% !+/ !#'$% r!/or#=,/
htmlL
headL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 112/180
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
YL
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Qre5ortQ9uery N)I
YL
5La hrefNre5ort.htmlNLBAKCaLC5L
table %idthN$YN borderNN heihtN$&NL
tr b'olorNO>>>>!!NL
td 'ols5anN"N heihtN"!N b'olorNO!!!!>>NL
di alinN'enterNLfont 'olorNO>>>>>>NLbLfont fa'eNourier 3e%8 ourier8
monoNL-MP/2<--
D-0A1/ R-P2R0CfontLCbLCfontLCdiL
CtdLCtrL
tr b'olorNO>>>>!!NL
td %idthN#"N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL-MP
1D CfontLCtdL
td %idthN+*N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL-MP
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 113/180
3AM- CfontLCtdL
td %idthN!*N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNLH=A/1>1A0123CfontLCtdL
td %idthN#"N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!NsiEeN"NLD-P0CfontLCtdL
td %idthN"&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLD2@CfontLCtdL
td %idthN&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLADDR-SSCfontLCtdL
td %idthN#&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLD-SGCfontLCtdL
td %idthN*+N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN siEeN"NL-MPJ
0<P-CfontLCtdL
td %idthN*+N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLD2BCfontLCtdL
td %idthN*$N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLG-3D-RCfontLCtdL
td %idthN&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLM2B1/-CfontLCtdL
td %idthN#&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN
siEeN"NLMA1/CfontLCtdL
td %idthN*N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLA
32CfontLCtdL
td %idthN*$N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8monoNLBAS1
CfontLCtdL
td %idthN"N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL0ACfontLCtdL
td %idthN"N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLDACfontLCtdL
td %idthN"&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!NsiEeN"NL?RACfontLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 114/180
td %idthN+&N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL20?-RJA//24CfontLCtdL
td %idthN**N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL-P>CfontLCtdL
td %idthN*,N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNLPR2>J0AZ
CfontLCtdL
td %idthN!,N heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLGR2SS
SA/AR<CfontLCtdLCtrL
Y
%hile(rs.net())
YL
trL
td %idthN#"N heihtN"NLY rs.etStrin(NloinQidN)YLCtdL
td %idthN+*N heihtN"NLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthN!*N heihtN"NLY rs.etStrin(N9ualiN)YLCtdL
td %idthN#"N heihtN"NLY rs.etStrin(Nde5tN)YLCtdL
td %idthN"&N heihtN"NLY rs.etStrin(NdojN)YLCtdL
td %idthN&N heihtN"NLY rs.etStrin(NaddressN)YLCtdL
td %idthN#&N heihtN"NLY rs.etStrin(NdesN)YLCtdL
td %idthN*+N heihtN"NLY rs.etStrin(Nem5Qty5eN)YLCtdL
td %idthN*+N heihtN"NLY rs.etStrin(NdateN)YLJY rs.etStrin(NmonthN)YLJ
Y rs.etStrin(NyearN)YLCtdL
td %idthN*$N heihtN"NLY rs.etStrin(NenderN)YLCtdL
td %idthN&N heihtN"NLY rs.etStrin(NmobN)YLCtdL
td %idthN#&N heihtN"NLY rs.etStrin(NmailN)YLCtdL
td %idthN*N heihtN"NLY rs.etStrin(Na''QnoN)YLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 115/180
td %idthN*$N heihtN"NLY rs.et1nt(Nbasi'N)YLCtdL
td %idthN"N heihtN"NLY rs.et1nt(NtaN)YLCtdL
td %idthN"N heihtN"NLY rs.et1nt(NdaN)YLCtdL
td %idthN"&N heihtN"NLY rs.et1nt(NhraN)YLCtdL
td %idthN+&N heihtN"NLY rs.et1nt(NotherQallo%N)YLCtdL
td %idthN**N heihtN"NLY rs.et1nt(Ne5fN)YLCtdL
td %idthN*,N heihtN"NLY rs.et1nt(N5rofQtaN)YLCtdL
td %idthN!,N heihtN"NLY rs.et1nt(NrossN)YLCtdL
CtrL
Y
TT
'at'h(-'e5tion e)
T
YL
CtableLCbodyLChtmlL
A%% !+/ %o;$) $)*o=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 116/180
YL
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from loinQ9uery N)I
YL
5La hrefNre5ort.htmlNLBAKCaLC5L
table %idthN$YN borderNN heihtN$&NL
tr b'olorNO>>>>!!NL
td 'ols5anN*N heihtN"!N b'olorNO!!!!>>NL
di alinN'enterNLfont 'olorNO>>>>>>NLbLfont fa'eNourier 3e%8 ourier8
monoNL-MP/2<--
/2G13 R-P2R0CfontLCbLCfontLCdiLCtdLCtrL
tr b'olorNO>>>>!!NL
td %idthN"!N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL/2G131D CfontLCtdL
td %idthN"!N heihtN"!NLfont siEeN"N 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL-MP 3AM- CfontLCtdL
td %idthN"!N heihtN"!NLfont fa'eNourier 3e%8 ourier8
monoNLPASS42RDCfontLCtdL
td heihtN"!N %idthN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLD-P0CfontLCtdLCtrL
Y
%hile(rs.net())
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 117/180
YL
trL
td %idthN"!N heihtN"NLY rs.etStrin(NloinQidN)YLCtdL
td %idthN"!N heihtN"NLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthN"!N heihtN"NLY rs.etStrin(N5ass%ordN)YLCtdL
td heihtN"N %idthN"!NLY rs.etStrin(Nde5tN)YLCtdL
CtrL
Y
TT
'at'h(-'e5tion e)
T
YL
CtableLCbodyLChtmlL
Co+/o,! )o#$"!=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
onne'tion 'onI
Pre5aredStatement stI
Strin s8s"8s#8s*8sI
int resI
YL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 118/180
Y
sre9uest.etParameter(NtN)I
s"(Strin)session.etAttribute(NsesidN)I
s#re9uest.etParameter(NdtN)I
s*re9uest.etParameter(NsubN)I
sre9uest.etParameter(NmsN)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into noti'e alues(8888)N)I
st.set1nt(81nteer.5arse1nt(s))I
st.set1nt("81nteer.5arse1nt(s"))I
st.setStrin(#8s#)I
st.setStrin(*8s*)I
st.setStrin(8s)I
resst.ee'ute=5date()I
if(res!)
res5onse.sendRedire't(Nnoti'eQboard.js5N)I
T
else
out.5rintln(NbrL>ailed to 1nsert DataN)I
TT
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 119/180
Cr!'#! '+$)=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
hLbLfont 'olorNO!!!!>>NLR-A0- S=P-R =S-RCfontLCbLChL
h alinNleftNLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionN'reateQadminQsubmit.js5NL
5LbL/2G13 1D ;nbs5I;nbs5I;nbs5I
in5ut ty5eNtetN nameNt"NL
in5ut ty5eNhiddenN nameNtN alueNAdministratorNLCbLC5L
5LbLPASS42RD
in5ut ty5eNtetN nameNt#NLCbLC5L
5L
in5ut ty5eNsubmitN nameNSubmitN alueNSubmitNL
in5ut ty5eNresetN nameNSubmit"N alueNResetNLC5L
5L;nbs5I C5LCformL
h alinNleftNL;nbs5IChLCbodyLChtmlL
Cr!'#! '+$) ,3+$#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLs'ri5tL
fun'tion 5rint4indo%()
b 5arse1nt(naiator.a55ersion)
if (b L *) %indo%.5rint()
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 120/180
Cs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5L;nbs5I a hrefNjaas'ri5t:5rint4indo%()NLPR130CaL UUa
hrefNadminQhome.js5NLAdmin ?omeCaLC5L
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
onne'tion 'onI
Pre5aredStatement stI
Strin s8s"8s#I
YL
Y
sre9uest.etParameter(NtN)I
s"re9uest.etParameter(Nt"N)I
s#re9uest.etParameter(Nt#N)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into loin alues(88)N)I
st.setStrin(8s)I
st.set1nt("81nteer.5arse1nt(s"))I
st.setStrin(#8s#)I
st.ee'ute=5date()I
T
'at'h(-'e5tion e)
T
YL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 121/180
5L;nbs5IC5Ltable %idthN+YN borderNNL
trL
tdL
di alinN'enterNL
h"LbLReistration Sli5CbLCh"L
CdiLCtdLCtrL
trLtdLh# alinN'enterNL1D 'reated %ith font 'olorNO>>!!!!NL/oin 1DCfontL
Ys" YL And font 'olorNO>>!!!!NLPass%ordCfontLYs# YL
Ch#LCtdLCtrLCtableL
h"L;nbs5ICh"L
h"L;nbs5ICh"L
CbodyLChtmlL
D!% ,""!,,=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO##,,>>N tetNO!!!!!!NL
5L;nbs5IC5L
h" alinN'enterNL;nbs5ICh"L
h alinNleftNLfont
'olorNO>>!!!!NL;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I
;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5Ifont 'olorNO>>>>>>NLData
deleted Su''essfully........CfontLCfontLChL
5
alinNleftNL;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5
I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nb
s5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5Iobje't
'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N
'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN#&N heihtN$!NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 122/180
5aram namemoie alueNbutton"".s%fNL
5aram name9uality aluehihL
5aram nameNBAS-N alueN.NL
5aram nameNBG2/2RN alueNO##,,>>NL
embed sr'Nbutton"".s%fN baseN.N 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN#&N
heihtN$!N b'olorNO##,,>>NL
CembedL
Cobje'tL;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;n
bs5I;nbs5I;nbs5Iobje't 'lassidN'lsid:D"+DB&-JA-&DJ'fJ,&B$J***#*!!!!N'odebaseNhtt5:CCdo%nload.ma'romedia.'omC5ubCsho'%aeC'absCflashCs%flash.'abOersion
*8!8"8!N %idthN#$N heihtN+,NL
5aram namemoie alueNbutton"#.s%fNL
5aram name9uality aluehihL
5aram nameNBAS-N alueN.NL
5aram nameNBG2/2RN alueNO##,,>>NL
embed sr'Nbutton"#.s%fN baseN.N 9ualityhih
5luins5aeNhtt5:CC%%%.ma'romedia.'omCsho'%aeCdo%nloadCinde.'i
PQProdQersionSho'%ae>lashN ty5eNa55li'ationCJsho'%aeJflashN %idthN#$N
heihtN+,N b'olorNO##,,>>NLCembedLCobje'tLC5L
5L;nbs5IC5L
CbodyLChtmlL
E+/ "o+/o,!=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[NerrorPaeNN YL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 123/180
Y
onne'tion 'onI
Pre5aredStatement stI
Strin s8s"8s#8s*8sI
int resI
YL
Y
sre9uest.etParameter(NtN)I
s"(Strin)session.etAttribute(NsesidN)I
s#re9uest.etParameter(NdtN)I
s*re9uest.etParameter(NsubN)I
sre9uest.etParameter(NmsN)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.5re5areStatement(Ninsert into noti'e alues(8888)N)I
st.setStrin(8s)I
st.setStrin("8s")I
st.setStrin(#8s#)I
st.setStrin(*8s*)I
st.setStrin(8s)I
resst.ee'ute=5date()I
if(res!)
res5onse.sendRedire't(Nem5Qinbo.js5N)I
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 124/180
else
out.5rintln(NbrL>ailed to 1nsert DataN)I
TT
'at'h(-'e5tion e)
T
YL
CbodyLChtmlL
E+/ .o+!=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I CC JJL
Cs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 125/180
onne'tion 'onI
Statement stI
Strin str8s8s"I
int I
YL
Y
try
str(Strin)session.etAttribute(NsesidN)I
1nteer.5arse1nt(str)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5er %here loinQidN\\NN)I
if(rs.net())
YL
di alinN'enterNLfont siEeNNL;nbs5I;nbs5Ia hrefNmain.htmlNL;nbs5I/o out
CaLCfontLCdiL
hLfont 'olorNO!!!!>>NL-MP/2<-- ?2M- CfontLChL
table %idthN*YN borderN!NL
trL
td %idthN$YNLbLfont 'olorNO!!!!>>N fa'eNourier 3e%8 ourier8 monoNL3AM-
:;nbs5ICfontLCbLCtdL
td %idthN"!YNLbLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoNLY
rs.etStrin(Nem5QnameN) YLCfontLCbLCtdL
td %idthN"*YNLbLfont 'olorNO!!!!>>N fa'eNourier 3e%8 ourier8monoNLD-S1G3A0123CfontLCbLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 126/180
td %idthN#$YNLbLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoNL
Y rs.etStrin(NdesN) YLCfontLCbLCtdLCtrL
trL
td %idthN$YNLbLfont 'olorNO!!!!>>N fa'eNourier 3e%8 ourier8 monoNL-MP
1D:CfontLCbLCtdL
td %idthN"!YNLbLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoNLY
YLCfontLCbLCtdL
td %idthN"*YNLbLfont 'olorNO!!!!>>N fa'eNourier 3e%8 ourier8
monoNLD-PAR0M-30CfontLCbLCtdL
td %idthN#$YNLbLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoNLYrs.etStrin(Nde5tN) YLCfontLCbLCtdLCtrLCtableL
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
5La hrefNem5Q5ayQsli5.htmlNLfont fa'eNourier 3e%8 ourier8 monoNLPA<
S/1PCfontLCaLC5L
5Lfont fa'eNourier 3e%8 ourier8 monoNLa hrefNu5dateQem5Q5er.js5NL=PDA0-
P-RS23A/ D-0A1/CaLCfontLC5L
5Lfont fa'eNourier 3e%8 ourier8 monoNLahrefNem5Qu5dateQ5ass%ord.js5NL=PDA0- PASS42RDCaLCfontLC5L
5Lfont fa'eNourier 3e%8 ourier8 monoNLa hrefNem5QsalaryQstatement.js5NL
SA/AR< S0A0-M-30CaLCfontLC5L
5Lfont fa'eNourier 3e%8 ourier8 monoNLa
hrefNem5Qinbo.js5NL13B2ZCaLCfontLC5L
5L;nbs5IC5L
di idN/ayerN styleN5osition:absoluteI %idth:"!!5I heiht:5I EJinde:I left:
",5I to5: "&5NLim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN"*#N
heihtN"#"NLCdiL
Y
TT
'at'h(-'e5tion e)
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 127/180
YL
CbodyL
ChtmlL
E+/ $)3o=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeN@aaS'ri5tNL
JJ
fun'tion MMQreloadPae(init) CCreloads the %indo% if 3a* resiEed
if (inittrue) %ith (naiator) if ((a553ameN3ets'a5eN);;(5arse1nt(a55ersion)*))
do'ument.MMQ54inner4idthI do'ument.MMQ5?inner?eihtI
onresiEeMMQreloadPaeI TT
else if (inner4idthdo'ument.MMQ54 UU inner?eihtdo'ument.MMQ5?)
lo'ation.reload()I
T
MMQreloadPae(true)I
CC JJL
Cs'ri5tLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[NerrorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#8s*8s8strI
int I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 128/180
YL
Y
try
str(Strin)session.etAttribute(NsesidN)I
1nteer.5arse1nt(str)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from Huery %here toN\\N or toXAllX N)I
YL
table %idthN+"YN borderN!N heihtN&+NL
trL
td b'olorNO>>>>!!N heihtN*NL
h alinN'enterNLfont 'olorNO!!!!>>NLbL-MP/2<-- 13B2ZCbLCfontLChL
CtdLCtrLtrL
td b'olorNO>>>>>>N heihtN"NL
di alinNrihtNL
5 alinNrihtNL;nbs5I C5LCdiLCtdLCtrLCtableL
di idN/ayerN styleN5osition:absoluteI %idth:&*5I heiht:#"&5I EJinde:I left: +5I
to5: !5I ba'roundJ'olor: O>>,,I layerJba'roundJ'olor: O>>,,I border: 5
none O!!!!!!NL
5L;nbs5IC5L
5Lfont 'olorNO>>>>!!NLbLa hrefNem5Q'om5ose.htmlNL2MP2S-
CaLCbLCfontLC5L
5LbLfont 'olorNO>>>>!!NLa hrefNem5Qhome.js5NL-MP
?2M-CaLCfontLCbLC5L
5Lim sr'NsmallJbusinessJ5ayrollJseri'e.j5N %idthN&"N heihtN&NLC5L
CdiL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 129/180
di idN/ayer"N styleN5osition:absoluteI %idth:++,5I heiht:5I EJinde:"I left:
$5I to5: !&5NL
table %idthN!"YN borderNN heihtN#$NL
tr b'olorNO>>>>!!NL
td %idthN&YNLbLfont fa'eNourier 3e%8 ourier8 monoNLDA0-CfontLCbLCtdL
td %idthN"!YNLbLfont fa'eNourier 3e%8 ourier8
monoNLS=B@-0CfontLCbLCtdL
td %idthN&YNLbLfont fa'eNourier 3e%8 ourier8 monoNL3AM-CfontLCbLCtdL
td %idthN"YNLbLfont fa'eNourier 3e%8 ourier8 monoNL-MP 1DCfontLCbLCtdL
td %idthN#&YNLbLfont fa'eNourier 3e%8 ourier8monoNLM-SSAG-CfontLCbLCtdL
CtrL
Y
%hile(rs.net())
YL
tr b'olorNO>>>>>>NL
td %idthN&YNLfont 'olorNO!!&&>>NLY rs.etStrin(NdateN)YLCfontLCtdL
td %idthN"!YNLfont 'olorNO!!&&>>NLY rs.etStrin(Nsubje'tN)YLCfontLCtdL
td %idthN&YNLfont 'olorNO!!&&>>NLY rs.etStrin(Nem5QnameN)YLCfontLCtdL
td %idthN"YNLfont 'olorNO!!&&>>NLY rs.etStrin(NfrmN)YLCfontLCtdL
td %idthN#&YNLfont 'olorNO!!&&>>NLY rs.etStrin(NmsN)YLCfontLCtdL
Y
TT
'at'h(-'e5tion e)
T
YL
CtrLCtableLCdiLCbodyLChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 130/180
E+/ %o;$)=,/
htmlLheadLtitleL=S-RCtitleLCheadL
body L
Y] 5ae im5ortNjaa.s9l.[NYL
Y] 5ae im5ortNjaa.io.[NYL
Y
onne'tion 'onI
Statement stI
ResultSet rsI
Strin s8s"8s#8s*I
CCint I
YL
Y
sre9uest.etParameter(NrN)I
s"re9uest.etParameter(NtN)I
s#re9uest.etParameter(Nt"N)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from loin %here loinQidN\s"\NN)I
%hile(rs.net())
session.setAttribute(NsesidN8rs.etStrin(NloinQidN))I
session.setAttribute(NsesnmN8rs.etStrin(NloinQty5eN))I
if(s.e9uals(N-m5loyeeN))
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 131/180
if(s#.e9uals(rs.etStrin(N5ass%ordN)))
res5onse.sendRedire't(Nem5Qhome.js5N)I
else
res5onse.sendRedire't(Nerror.js5N)I
TT
else
res5onse.sendRedire't(Nerror.js5N)I
TTT
'at'h(-'e5tion e)
T
finally
rsnullI
stnullI
'onnullI
T
YL
CbodyLChtmlL
E+/ +o)#.%( ,'%'r( r!/or#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 132/180
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#8s*I
int I
YL
Y
try
s(Strin)session.etAttribute(NsesidN)I
1nteer.5arse1nt(NsN)I
s"re9uest.etParameter(NmnN)I
s#re9uest.etParameter(NyrN)I
s*re9uest.etParameter(Ne'N)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9uery %here loinQidN\\N and
em5Qty5eXN\s*\NXand monthXN\s"\NX and yearXN\s#\NXN)I
YL
table %idthN++YN borderNN heihtN$&NL
tr b'olorNO!!!!>>NL
td 'ols5anN"N heihtN"!NLbLfont 'olorNO>>>>!!N fa'eNourier 3e%8 ourier8
monoNLSA/AR<
>2R 0?- M230? 2> CfontLfont 'olorNO>>>>>>N fa'eNourier 3e%8 ourier8
monoNL:
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 133/180
Y s" YL J Y s# YLfont 'olorNO>>>>!!NL;nbs5I;nbs5I-MP/2<-- 1DCfontL:
Y YLCfontLCbLCtdL
CtrL
tr b'olorNO>>>>!!NL
td heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8 ourier8
monoNL-MP
3AM-CfontLCfontLCtdL
td %idthN$YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLD-P0CfontLCtdL
td %idthN&YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLA
32CfontLCtdL
td %idthN&YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNLBAS1CfontL
CfontLCtdL
td %idthN#YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL0ACfontLCtdL
td %idthN*YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLDACfontLCtdL
td %idthN*YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL?RACfontLCtdL
td %idthN!YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL20?-RJA//24CfontLCtdL
td %idthN,YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL-P>CfontLCtdL
td %idthN!YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNLPR2>J0AZCfontL
CfontLCtdL
td %idthN$YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL20?-RJD-DCfontLCtdL
td %idthN"YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLGR2SS
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 134/180
SA/AR<CfontLCtdL
CtrL
Y
%hile(rs.net())
YL
trL
td heihtN"NLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthN$YN heihtN"NLY rs.etStrin(Nde5tN)YLCtdL
td %idthN&YN heihtN"NLY rs.etStrin(Na''QnoN)YLCtdL
td %idthN&YN heihtN"NLY rs.et1nt(Nbasi'N)YLCtdL
td %idthN#YN heihtN"NLY rs.et1nt(NtaN)YLCtdL
td %idthN*YN heihtN"NLY rs.et1nt(NdaN)YLCtdL
td %idthN*YN heihtN"NLY rs.et1nt(NhraN)YLCtdL
td %idthN!YN heihtN"NLY rs.et1nt(NotherQallo%N)YLCtdL
td %idthN,YN heihtN"NLY rs.et1nt(Ne5fN)YLCtdL
td %idthN!YN heihtN"NLY rs.et1nt(N5rofQtaN)YLCtdL
td %idthN$YN heihtN"NLY rs.et1nt(NotherQdedN)YLCtdL
td %idthN"YN heihtN"NLY rs.et1nt(NrossQsalN)YLCtdL
Y
TT
'at'h(-'e5tion e)
T
YL
CtrLCtableLCbodyLChtmlL
E+/ /'(,%$/=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 135/180
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#I
YL
Y
try
s(Strin)session.etAttribute(NsesidN)I
s"re9uest.etParameter(NmnN)I
s#re9uest.etParameter(NyrN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9uery %here loinQidN\s\N and
monthXN\s"\NX and yearXN\s#\NXN)I
if(rs.net())
YL
5La hrefNem5Qhome.js5NL-m5 ?omeCaLC5L
table %idthN&*YN borderNN heihtN"&NL
tr b'olorNO!!!!>>NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 136/180
td 'ols5anN&N heihtN#*NLbLfont 'olorNO>>>>!!N fa'eNourier 3e%8 ourier8
monoNLSA/AR<
>2R 0?- M230? 2> CfontLfont 'olorNO>>>>>>N fa'eNourier 3e%8 ourier8
monoNL:
Y s" YL J Y s# YLfont 'olorNO>>>>!!NL;nbs5I;nbs5I-MP/2<-- 1DCfontL:
Y s YLCfontLCbLCtdL
CtrL
tr b'olorNO>>>>!!NL
td 'ols5anN&NLbLCbLbLCbLbLCbLbLCbLbLCbLbLCbLCtdL
CtrLtrL
td %idthN&YN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL-MP
1DCfontLCbLCtdL
td %idthN+YN heihtN#NLY rs.etStrin(NloinQidN)YLCtdL
td %idthN,YN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLBAS1CfontLCbL
CtdL
td %idthN*YN heihtN#NLY rs.et1nt(Nbasi'N)YLCtdL
td %idthN+YN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL-P>CfontLCbL
CtdL
td %idthN+YN heihtN#NLY rs.et1nt(Ne5fN)YLCtdLCtrL
trL
td %idthN&YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NL-MP
3AM-CfontLCbLCtdL
td %idthN+YNLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthN,YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL0ACfontLCbLCtdL
td %idthN*YNLY rs.et1nt(NtaN)YLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 137/180
td %idthN+YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLPR2>J
0AZCfontLCbLCtdL
td %idthN+YNLY rs.et1nt(N5rofQtaN)YLCtdLCtrL
trL
td %idthN&YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLD-P0CfontLCbLCtdL
td %idthN+YNLY rs.etStrin(Nde5tN)YLCtdL
td %idthN,YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLDACfontLCbLCtdL
td %idthN*YNLY rs.et1nt(NdaN)YLCtdL
td %idthN+YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL20?-RJD-DCfontLCbLCtdL
td %idthN+YNLY rs.et1nt(NotherQdedN)YLCtdLCtrL
trL
td %idthN&YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLA
32CfontLCbLCtdL
td %idthN+YNLY rs.etStrin(Na''QnoN)YLCtdL
td %idthN,YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL?RACfontLCbLCtdL
td %idthN*YNLY rs.et1nt(NhraN)YLCtdL
td %idthN+YNL;nbs5ICtdL
td %idthN+YNL;nbs5ICtdLCtrL
trL
td %idthN&YN heihtN*NL;nbs5ICtdL
td %idthN+YN heihtN*NL;nbs5ICtdL
td %idthN,YN heihtN*NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL20?-RJA//24CfontLCbLCtdL
td %idthN*YN heihtN*NLY rs.et1nt(NotherQallo%N)YLCtdL
td %idthN+YN heihtN*NLfont fa'eNourier 3e%8 ourier8 monoN'olorNO!!!!>>NLbLGR2SS
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 138/180
SA/AR<CbLCfontLCtdL
td %idthN+YN heihtN*NLY rs.et1nt(NrossQsalN)YLCtdL
CtrL
tr b'olorNO>>>>!!NL
td 'ols5anN&N heihtNNL;nbs5ICtdLCtrLCtableL
Y
TT
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
E+/ ,'%'r( ,#'#!+!)#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin str8s8s"8s#8s*8s8s&I
YL
Y
try
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 139/180
str(Strin)session.etAttribute(NsesidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9uery %here loinQidN\str\NN)I
YL
5La hrefNem5Qhome.js5NLBAKCaLC5L
table %idthN+YN borderNNL
tr b'olorNO>>>>!!NL
td 'ols5anN!NL
di alinN'enterNLfont 'olorNO!!!!>>NLbLfont 'olorNO!!!!!!NL-MP/2<--
GR2SS SA/AR< S0A0-M-30 CfontLCbLCfontLCdiLCtdLCtrL
trL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8 monoNLM230?
;am5I<-ARCfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNLBAS1CfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL0ACfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNLDACfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8monoNL?RACfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8 monoNL20?-RJ
A//24CfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8
monoNL-P>CfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8 monoNLPR2>
0AZCfontLCbLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 140/180
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8 monoNL20?-R
D-DCfontLCbLCtdL
td %idthN*!NLbLfont 'olorNO!!!!!!N fa'eNourier 3e%8 ourier8 monoNLGR2SS
SA/AR<CfontLCbLCtdLCtrL
Y
%hile(rs.net())
YL
trL
td %idthN*!NLfont siEeN"NLY rs.etStrin(NmonthN) YLY rs.etStrin(NyearN)
YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(Nbasi'N) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NtaN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NdaN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NhraN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NotherQallo%N) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(Ne5fN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(N5rofQtaN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NotherQdedN) YLCfontLCtdL
td %idthN*!NLfont siEeN"NLY rs.et1nt(NrossQsalN) YLCfontLCtdLCtrL
Y
T
YL
CtableL
Y
T
'at'h(-'e5tion e)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 141/180
T
YL
5L;nbs5IC5LCbodyLChtmlL
E+/ /'#! /',,8or=,/
htmlLheadLtitleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5tL
fun'tion alidatePass(tem5)
ar l tem5.alue.lenthI
CClert(heart)I
if((l&))
alert(NPass%ord should be of & 'hara'terC diitN)I
tem5.alueNNI
TT
Cs'ri5tLCheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin sI
YL
Y
try
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 142/180
s(Strin)session.etAttribute(NsesidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from loin %here loinQidN\s\NN)I
if(rs.net())
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
h"LbLfont 'olorNO!!,,NL=PDA0- PASS42RDCfontLCbLCh"L
h*LbLa hrefNem5Qhome.js5NLBa' CaLCbLCh*L
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNem5Qu5dateQ5ass%ordQsubmit.js5NL
table %idthN+YN borderNNL
tr b'olorNO!!,,NL
td 'ols5anN"N b'olorNO>>>>!!NL
di alinN'enterNLbL=PDA0- PASS42RDCbLCdiLCtdLCtrL
tr b'olorNO!!,,NL
td %idthN",YNLfont 'olorNO>>!!!!NL2/D PASS42RDCfontLCtdL
td %idthN+YNLfont 'olorNO>>!!!!NL
in5ut ty5eNtetN nameN5%dN readonly alueNY rs.etStrin(N5ass%ordN) YLNL
in5ut ty5eNhiddenN nameNidN alueNYs YLNL
CfontLCtdLCtrL
tr b'olorNO!!,,NL
td %idthN",YNL3-4 PASS42RDCtdL
td %idthN+YN b'olorNO!!,,NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 143/180
in5ut ty5eN5ass%ordN nameNn5N re9uired onblurNalidatePass(this)NL
font 'olorNO>>!!!!NL[CfontL (-nter & 'har'aterC diit ) CtdLCtrL
tr b'olorNO!!,,NL
td %idthN",YNL23>2RM PASS42RDCtdL
td %idthN+YNL
in5ut ty5eN5ass%ordN nameN'5N re9uired onblurNalidatePass(this)N L
font 'olorNO>>!!!!NL[CfontL (-nter & 'har'aterC diit ) CtdLCtrL
trL
td %idthN",YNL;nbs5ICtdL
td %idthN+YNL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0- PASS42RDNL
CtdLCtrLCtableLCformL
hL;nbs5IChL
Y
TT
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
E+/ /'#! /',,8or ,3+$#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
CheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 144/180
ResultSet rsI
onne'tion 'onI
Statement st8stI
Strin s8s"8s#8s*8sI
int resI
YL
Y
try
sre9uest.etParameter(NidN)I
s"re9uest.etParameter(N5%dN)I
s#re9uest.etParameter(Nn5N)I
s*re9uest.etParameter(N'5N)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
st'on.'reateStatement()I
if(s#.e9uals(s*))
resst.ee'ute=5date(N u5date loin set 5ass%ordXN\s#\NX %here loinQidN\s\NN)I
T
else
out.5rintln(NPass%ord not mat'h ....re enterN)I
T
rsst.ee'uteHuery(Nsele't [ from loin %here loinQidN\s\NN)I
if(rs.net())
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 145/180
srs.etStrin(N5ass%ordN)I
YL
5La hrefNem5Qhome.js5NL-m5 ?omeCaLC5L
table %idthN##YN borderNNL
tr b'olorNO>>>>!!NL
td 'ols5anN"NLfont 'olorNO>>>>>>NLbLfont 'olorNO!!!!!!NL3-4
PASS42RDCfontLCbLCfontLCtdLCtrL
tr b'olorNO!!,,NL
td %idthN*!YNL-MP/2<-- 1D CtdL
td %idthN&!YNLYs YLCtdLCtrL
tr b'olorNO!!,,NL
td %idthN*!YNL3-4 PASS42RDCtdL
td %idthN&!YNLYs YLCtdLCtrLCtableL
Y
TT
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
Error=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
5 alinN'enterNL;nbs5IC5L
5 alinN'enterNL;nbs5IC5L
5 alinN'enterNLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoNsiEeNNL-rror in =S-R 1D or PASS42RD .............CfontLC5L
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 146/180
5 alinN'enterNLfont 'olorNO>>!!!!N fa'eNourier 3e%8 ourier8 monoN siEeNNLa
hrefNmain.htmlNL0ry Aain....CaLCfontLC5LCbodyLChtmlL
Lo;$)=,/
htmlLheadLtitleL=S-RCtitleLCheadL
body L
Y] 5ae im5ortNjaa.s9l.[NYL
Y] 5ae im5ortNjaa.io.[NYL
Y
onne'tion 'onI
Statement stI
ResultSet rsI
Strin s8s"8s#8s*I
CCint I
YL
Y
sre9uest.etParameter(NrN)I
s"re9uest.etParameter(NtN)I
s#re9uest.etParameter(Nt"N)I
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from loin %here loinQty5eXN\s\NXN)I
%hile(rs.net())
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 147/180
session.setAttribute(NsesidN8rs.etStrin(NloinQidN))I
session.setAttribute(NsesnmN8rs.etStrin(NloinQty5eN))I
if(s.e9uals(NAdministratorN))
if(s#.e9uals(rs.etStrin(N5ass%ordN)))
res5onse.sendRedire't(NadminQhome.js5N)I
else
res5onse.sendRedire't(Nerror.js5N)I
TT
else
res5onse.sendRedire't(Nerror.js5N)I
TTT
'at'h(-'e5tion e)
T
finally
rsnullI
stnullI
'onnullI
T
YLCbodyLChtmlL
:o)#.%( ,'%'r( r!/or#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 148/180
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#I
YL
Y
try
sre9uest.etParameter(Ne'N)I
s"re9uest.etParameter(NmnN)I
s#re9uest.etParameter(NyrN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9uery %here em5Qty5eXN\s\NX and
monthXN\s"\NX and yearXN\s#\NXN)I
YL
5La hrefNre5ort.htmlNLR-P2R0 PAG-CaL UU a
hrefNmonthlyQsalaryQre5ort.htmlNLBAKCaL
UU a hrefNadminQhome.js5NLADM13 ?2M-CaLC5L
table %idthN++YN borderNN heihtN$&NL
tr b'olorNO!!!!>>NL
td 'ols5anN#N heihtN"!NLbLfont 'olorNO>>>>!!N fa'eNourier 3e%8 ourier8
monoNLSA/AR<
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 149/180
>2R 0?- M230? 2> CfontLfont 'olorNO>>>>>>N fa'eNourier 3e%8 ourier8
monoNL:
Y s" YL J Y s# YLfont 'olorNO>>>>!!NL;nbs5I;nbs5I-MP/2<-- 0<P-
CfontL:Y s YLCfontLCbLCtdL
CtrL
tr b'olorNO>>>>!!NL
td %idthN#YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNL-MP
1DCfontLCfontLCtdL
td %idthN+YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNL-MP
3AM-CfontLCfontLCtdL
td %idthN+YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLD-P0CfontLCtdL
td %idthN"YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLA
32CfontLCtdL
td %idthN*YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNLBAS1CfontL
CfontLCtdL
td %idthNYN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL0ACfontLCtdL
td %idthNYN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NLDACfontLCtdL
td %idthN"YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL?RACfontLCtdL
td %idthN*YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL20?-RJA//24CfontLCtdL
td %idthNYN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL-P>CfontLCtdL
td %idthN#YN heihtN"!NLfont siEeN"N 'olorNO!!!!!!NLfont fa'eNourier 3e%8
ourier8 monoNLPR2>J0AZCfontL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 150/180
CfontLCtdL
td %idthN*YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!N
siEeN"NL20?-RJD-DCfontLCtdL
td %idthN+YN heihtN"!NLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!!!NsiEeN"NLGR2SS
SA/AR<CfontLCtdL
CtrL
Y
%hile(rs.net())
YL
trL
td %idthN#YN heihtN"NLY rs.etStrin(NloinQidN)YLCtdL
td %idthN+YN heihtN"NLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthN+YN heihtN"NLY rs.etStrin(Nde5tN)YLCtdL
td %idthN"YN heihtN"NLY rs.etStrin(Na''QnoN)YLCtdL
td %idthN*YN heihtN"NLY rs.et1nt(Nbasi'N)YLCtdL
td %idthNYN heihtN"NLY rs.et1nt(NtaN)YLCtdL
td %idthNYN heihtN"NLY rs.et1nt(NdaN)YLCtdL
td %idthN"YN heihtN"NLY rs.et1nt(NhraN)YLCtdL
td %idthN*YN heihtN"NLY rs.et1nt(NotherQallo%N)YLCtdL
td %idthNYN heihtN"NLY rs.et1nt(Ne5fN)YLCtdL
td %idthN#YN heihtN"NLY rs.et1nt(N5rofQtaN)YLCtdL
td %idthN*YN heihtN"NLY rs.et1nt(NotherQdedN)YLCtdL
td %idthN+YN heihtN"NLY rs.et1nt(NrossQsalN)YLCtdL
Y
TT
'at'h(-'e5tion e)
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 151/180
T
YLCtrLCtableLCbodyLChtmlL
:o)#.%( ,'%'r( ,3+$#=,/
Y] 5ae im5ortNjaa.s9l.[N YL
htmlL
bodyL
Y
Strin sVW8s"VW8s#VW8s*VW8sVW8s&VW8s+VW8s$VW8s,VW8s!VW8sVW8s"VWI
Strin strI
int s8allo%8ded8iI
ResultSet resI
YL
Y
sre9uest.etParameteralues(NidN)I
s"re9uest.etParameteralues(Na'N)I
s#re9uest.etParameteralues(NbaN)I
s*re9uest.etParameteralues(NtaN)I
sre9uest.etParameteralues(NdaN)I
s&re9uest.etParameteralues(NhraN)I
s+re9uest.etParameteralues(NoaN)I
s$re9uest.etParameteralues(Ne5fN)I
s,re9uest.etParameteralues(N5tN)I
s!re9uest.etParameteralues(NodN)I
sre9uest.etParameteralues(NmnN)I
s"re9uest.etParameteralues(NyrN)I
YL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 152/180
Y
try
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
onne'tion 'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
Statement st'on.'reateStatement()I
Pre5aredStatement 5s'on.5re5areStatement(Ninsert into salQtran
alues(888888888888)N)I
for(i!Ii!!Ii\\)
allo%1nteer.5arse1nt(s#ViW)\1nteer.5arse1nt(s*ViW)\1nteer.5arse1nt(sViW)
\1nteer.5arse1nt(s&ViW)\1nteer.5arse1nt(s+ViW)I
ded1nteer.5arse1nt(s$ViW)\1nteer.5arse1nt(s,ViW)\1nteer.5arse1nt(s!ViW)I
sallo%\dedI
5s.setStrin(8sViW)I
5s.setStrin("8s"ViW)I
5s.setStrin(#8s#ViW)I
5s.setStrin(*8s*ViW)I
5s.setStrin(8sViW)I
5s.setStrin(&8s&ViW)I
5s.setStrin(+8s+ViW)I
5s.setStrin($8s$ViW)I
5s.setStrin(,8s,ViW)I
5s.setStrin(!8s!ViW)I
5s.setStrin(8sViW)I
5s.setStrin("8s"ViW)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 153/180
5s.set1nt(#8s)I
5s.ee'ute=5date()I
T
YL
Y
T
'at'h(-'e5tion e)
T
YL
js5:for%ard 5aeNadminQhome.js5N CL
CbodyL
ChtmlL
P'(,%$/=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#I
YL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 154/180
Y
try
sre9uest.etParameter(Ne'N)I
s"re9uest.etParameter(NmnN)I
s#re9uest.etParameter(NyrN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9uery %here em5Qty5eXN\s\NX and
monthXN\s"\NX and yearXN\s#\NXN)I
%hile(rs.net())
YL
table %idthN&*YN borderNN heihtN"&NL
tr b'olorNO!!!!>>NL
td 'ols5anN&N heihtN#*NLbLfont 'olorNO>>>>!!N fa'eNourier 3e%8 ourier8
monoNLSA/AR<
>2R 0?- M230? 2> CfontLfont 'olorNO>>>>>>N fa'eNourier 3e%8 ourier8
monoNL:
Y s" YL J Y s# YLfont 'olorNO>>>>!!NL;nbs5I;nbs5I-MP/2<-- 0<P-
CfontL:Y s YLCfontLCbLCtdLCtrL
tr b'olorNO>>>>!!NL
td 'ols5anN&NLbLCbLbLCbLbLCbLbLCbLbLCbLbLCbLCtdLCtrL
trL
td %idthN#YN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL-MP
1DCfontLCbLCtdL
td %idthNYN heihtN#NLY rs.etStrin(NloinQidN)YLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 155/180
td %idthNYN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLBAS1CfontLCbLCtdL
td %idthN!YN heihtN#NLY rs.et1nt(Nbasi'N)YLCtdL
td %idthN"!YN heihtN#NLbLfont fa'eNourier 3e%8 ourier8 monoN'olorNO!!!!>>NL-P>CfontLCbLCtdL
td %idthN"+YN heihtN#NLY rs.et1nt(Ne5fN)YLCtdLCtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NL-MP
3AM-CfontLCbLCtdL
td %idthNYNLY rs.etStrin(Nem5QnameN)YLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL0ACfontLCbLCtdL
td %idthN!YNLY rs.et1nt(NtaN)YLCtdL
td %idthN"!YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLPR2>J
0AZCfontLCbLCtdL
td %idthN"+YNLY rs.et1nt(N5rofQtaN)YLCtdLCtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLD-P0CfontLCbLCtdL
td %idthNYNLY rs.etStrin(Nde5tN)YLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLDACfontLCbLCtdL
td %idthN!YNLY rs.et1nt(NdaN)YLCtdL
td %idthN"!YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL20?-RJD-DCfontLCbLCtdL
td %idthN"+YNLY rs.et1nt(NotherQdedN)YLCtdLCtrL
trL
td %idthN#YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLA
32CfontLCbLCtdL
td %idthNYNLY rs.etStrin(Na''QnoN)YLCtdL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 156/180
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL?RACfontLCbLCtdL
td %idthN!YNLY rs.et1nt(NhraN)YLCtdL
td %idthN"!YNL;nbs5ICtdL
td %idthN"+YNL;nbs5ICtdLCtrL
trL
td %idthN#YN heihtN*NL;nbs5ICtdL
td %idthNYN heihtN*NL;nbs5ICtdL
td %idthNYN heihtN*NLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL20?-RJA//24CfontLCbLCtdL
td %idthN!YN heihtN*NLY rs.et1nt(NotherQallo%N)YLCtdL
td %idthN"!YN heihtN*NLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLbLGR2SS SA/AR<CbLCfontLCtdL
td %idthN"+YN heihtN*NLY rs.et1nt(NrossQsalN)YLCtdLCtrL
tr b'olorNO>>>>!!NL
td 'ols5anN&N heihtNNL;nbs5ICtdLCtrL
tr b'olorNO>>>>>>NL
td 'ols5anN&NL
di alinN'enterNL.................................................'ut
here......................................................................CdiL
CtdLCtrLCtableL
Y
TT
'at'h(-'e5tion e)
T
YL
CbodyL
ChtmlL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 157/180
S'%'r( r!/or#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin str8s8s"8s#8s*8s8s&I
YL
Y
0ry
str(Strin)session.etAttribute(NsesidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5QsalQ9ueryN)I
YL
5La hrefNre5ort.htmlNLBAKCaL UU a hrefNadminQhome.js5NLADM13
?2M-CaLC5L
table %idthN$"YN borderNN heihtN$!NL
tr b'olorNO>>>>!!NL
td 'ols5anNNLfont 'olorNO!!!!>>NL-MP/2<-- GR2SS SA/AR< S0A0-M-30
CfontLCtdLCtrL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 158/180
tr b'olorNO!!!!>>NL
td %idthN#YNLbLfont 'olorNO>>>>!!NL-MP 1DCfontLCbLCtdL
td %idthN",YNLbLfont 'olorNO>>>>!!NL-MP 3AM-CfontLCbLCtdL
td %idthN""YNLbLfont 'olorNO>>>>!!NLD-P0CfontLCbLCtdL
td %idthN&YNLbLfont 'olorNO>>>>!!NLM230? ;am5I<-ARCfontLCbLCtdL
td %idthN"!YNLbLfont 'olorNO>>>>!!NLGR2SS SA/AR<CfontLCbLCtdLCtrL
Y
%hile(rs.net())
srs.etStrin(NloinQidN)I
s"rs.etStrin(Nem5QnameN)I
s#rs.etStrin(Nde5tN)I
s*rs.etStrin(NmonthN)I
srs.etStrin(NyearN)I
s&rs.etStrin(NrossQsalN)I
YL
trL
td %idthN#YNLfont siEeN"NLY s YLCfontLCtdL
td %idthN",YNLfont siEeN"NLY s" YLCfontLCtdL
td %idthN""YNLfont siEeN"NLY s# YLCfontLCtdL
td %idthN&YNLfont siEeN"NLY s* YLY s YLCfontLCtdL
td %idthN"!YNLfont siEeN"NLY s& YLCfontLCtdL
CtrL
Y
TT
'at'h(-'e5tion e)
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 159/180
YL
CtableLCbodyLChtmlL
U/'#! !+/ /!r=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNL
s'ri5t lanuaeNjaas'ri5tNL
fun'tion alidatePhone(tem5)
ar l tem5.alue.lenthI
CClert(heart)I
if((l!))
alert(NPhone number should be of ! diitN)I
tem5.alueNNI
T
else
for(ar i!I i,I i\\)
ar 'h tem5.alue.'harodeAt(i)I
if(('hL*$ ;; 'h+))
alert(NPhone 3umber should be diits onlyN)I
tem5.alueNNI
eitI
TTTT
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 160/180
fun'tion alidateMail()
ar do'ument.formsVNformNWVNmdNW.alueI
ar at5os.inde2f(N]N)I
ar dot5os.last1nde2f(N.N)I
if (at5os UU dot5osat5os\" UU dot5os\"L.lenth)
alert(N3ot a alid eJmail addressN)I
return falseI
TT
Cs'ri5tLCheadL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin sI
YL
Y
try
s(Strin)session.etAttribute(NsesidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q5er %here loinQidN\s\NN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 161/180
if(rs.net())
YL
body b'olorNO>>>>>>N tetNO!!!!!!NL
h"LbLfont 'olorNO!!!!>>NL=PDA0- -MP/2<-- P-RS23A/
D-0A1/CfontLCbLCh"L
h*LbLa hrefNem5Qhome.js5NLBa' CaLCbLCh*L
hLim sr'Nbar.@PGN %idthN+&&N heihtN#"NLChL
form nameNformN methodN5ostN a'tionNu5dateQem5Q5erQsubmit.js5NL
table %idthN+YN borderNNL
tr b'olorNO>>>>!!NL
td 'ols5anN"NL
h# alinN'enterNLbLfont 'olorNO!!!!>>NL=PDA0- P-RS23A/
D-0A1/CfontLCbLCh#LCtdLCtrL
trL
td %idthN",YNL=PDA0- ADDR-SSCtdL
td %idthN+YNL
tetarea nameNadNLY rs.etStrin(NaddressN) YLCtetareaL
in5ut ty5eNhiddenN nameNidN alueNY s YLNLCtdLCtrL
trL
td %idthN",YNLM2B1/- 32CtdL
td %idthN+YNL
in5ut ty5eNtetN nameNmnN alueNY rs.etStrin(NmobN) YLN re9uired
onblurNalidatePhone(this)NLCtdLCtrL
trL
td %idthN",YNLMA1/ 1DCtdL
td %idthN+YNL
in5ut ty5eNtetN nameNmdN alueNY rs.etStrin(NmailN) YLN re9uired
onblurNalidateMail()N LCtdLCtrL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 162/180
tr b'olorNO>>>>!!NL
td %idthN",YNL;nbs5ICtdL
td %idthN+YNL
in5ut ty5eNsubmitN nameNSubmitN alueN=PDA0-NLCtdLCtrLCtableLCformL
hL;nbs5IChL
Y
TT
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
U/'#! !+/ /!r ,3+$#=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
int rsI
onne'tion 'onI
Statement stI
Strin s8s"8s#8s*8sI
YL
Y
try
sre9uest.etParameter(NidN)I
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 163/180
s"re9uest.etParameter(NadN)I
CCs#re9uest.etParameter(NdN)I
s*re9uest.etParameter(NmnN)I
sre9uest.etParameter(NmdN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'ute=5date(N u5date em5Q5er set addressXN\s"\NX 8 mobXN\s*\NX 8 mailXN\s\NX
%here loinQidN\s\NN)I
YL
5La hrefNem5Qhome.js5NL-m5 ?omeCaLC5L
table %idthN##YN borderNNL
tr b'olorNO!!!!>>NL
td 'ols5anN"NLfont 'olorNO>>>>>>NLbL=PDA0-D DA0ACbLCfontLCtdLCtrL
trL
td %idthN*!YNL=PDA0- ADDR-SSCtdL
td %idthN&!YNLYs" YLCtdLCtrL
trL
td %idthN*!YNL=PDA0- M2B1/- 32CtdL
td %idthN&!YNLYs* YLCtdLCtrL
trL
td %idthN*!YNL=PDA0- MA1/ 1DCtdL
td %idthN&!YNLYs YLCtdL
CtrL
CtableL
Y
T
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 164/180
'at'h(-'e5tion e)
T
YLCbodyLChtmlL
U/'#! ,'%'r(=,/
htmlLheadL
titleL=ntitled Do'umentCtitleL
meta htt5Je9uiNontentJ0y5eN 'ontentNtetChtmlI 'harsetisoJ$$,JNLCheadL
body b'olorNO>>>>>>N tetNO!!!!!!NL
Y] 5ae 'ontent0y5eNtetChtmlI 'harsetutfJ$N lanuaeNjaaN im5ortNjaa.s9l.[N
errorPaeNN YL
Y
ResultSet rsI
onne'tion 'onI
Statement stI
Strin sI
YL
Y
try
sre9uest.etParameter(NidN)I
lass.for3ame(Nsun.jdb'.odb'.@db'2db'DrierN)I
'onDrierManaer.etonne'tion(Njdb':odb':5ayN)I
st'on.'reateStatement()I
rsst.ee'uteHuery(Nsele't [ from em5Q9uery %here loinQidN\s\NN)I
YL
form nameNformN methodN5ostN a'tionNu5dateQsalaryQsubmit.js5NL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 165/180
table %idthN$YN borderNN heihtN"#NL
tr b'olorNO!!!!>>NL
td 'ols5anNNLbLfont 'olorNO>>>>>>NLM2D1>< -MP/2<--
SA/AR<CfontLfont'olorNO>>>>>>NL;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I
;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs
5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;n
bs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5I;nbs5ICfontLCbLCtdLCtrL
tr b'olorNO>>>>!!NL
td %idthN$YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NL-MP
1DCfontLCbLCtdL
td %idthN,YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NL-MP
3AM-CfontLCbLCtdL
td %idthN$YNLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLA
32CfontLCbLCtdL
td %idthN$YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLBAS1CfontLCbLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL0ACfontLCbLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NLDACfontLCbLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL?RACfontLCbLCtdL
td %idthN!YNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL20?-RJA//24CfontLCbLCtdL
td %idthNYNLbLfont fa'eNourier 3e%8 ourier8 monoN
'olorNO!!!!>>NL-P>CfontLCbLCtdL
td 'ols5anN"NLbLfont fa'eNourier 3e%8 ourier8 monoN 'olorNO!!!!>>NLPR2>J
0AZCfontLCbLbLCbLCtdLCtrL
Y
%hile(rs.net())
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 166/180
YL
trL
td %idthN$YNL
in5ut ty5eNtetN nameNidN alue NY rs.et1nt(NloinQidN)YLNsiEeN!NL
CtdL
td %idthN,YNL
in5ut ty5eNtetN nameNnmN alueNY rs.etStrin(Nem5QnameN)YLN siEeN#!NL
CtdL
td %idthN$YNL
in5ut ty5eNtetN nameNa'N alueNY rs.etStrin(Na''QnoN)YLN siEeN!NL
CtdL
td %idthN$YNL
in5ut ty5eNtetN nameNbaN alueNY rs.et1nt(Nbasi'N)YLN siEeN!NL
CtdL
td %idthNYNL
in5ut ty5eNtetN nameNtaN alueNY rs.et1nt(NtaN)YLN siEeN&NL
CtdL
td %idthNYNL
in5ut ty5eNtetN nameNdaN alueNY rs.et1nt(NdaN)YLN siEeN&NL
CtdL
td %idthNYNL
in5ut ty5eNtetN nameNhraN alueNY rs.et1nt(NhraN)YLN siEeN&NL
CtdL
td %idthN!YNL
in5ut ty5eNtetN nameNoaN alueNY rs.et1nt(NotherQallo%N)YLN siEeN!NL
CtdL
td %idthNYNL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 167/180
in5ut ty5eNtetN nameNe5fN alueNY rs.et1nt(Ne5fN)YLN siEeN&NL
CtdL
td %idthNYNL
in5ut ty5eNtetN nameN5tN alueNY rs.et1nt(N5rofQtaN)YLN siEeN!NL
CtdL
td %idthN&YNL
in5ut ty5eNhiddenN nameNodN siEeN!N alueN!NL
CtdL
Y
TT
'at'h(-'e5tion e)
T
YLCtrL
trL
td 'ols5anNNL
in5ut ty5eNsubmitN nameNSubmitN alueNM2D1>< SA/AR<NL
in5ut ty5eNresetN nameNSubmit"N alueNR-S-0NL
CtdLCtrLCtableLCformLCbodyLChtmlL
7=2= SNAPSHOTS
1 HO:E
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 168/180
2=AD:IN LOGIN
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 169/180
=E:PLOYEE LOGIN
6=AD:IN CONTROL PANEL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 170/180
5=AD:IN E:PLOYEE CONFIGURE
=E:PLOYEE HO:E
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 171/180
7=UPDATE E:PLOYEE PERSONAL DETAIL
<= LOGIN TABLE DATABASE
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 172/180
9=E:PREPORT
10=E:PLOYEE PERSONAL DETAIL
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 173/180
11=REPORT
<=TESTING
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 174/180
Soft%are testin is a 'riti'al soft%are 9uality assuran'e and re5resents the ultimate reie% of
s5e'ifi'ation8 desin and 'odin. 0he soft%are testin 5ro'ess is the means by %hi'h 5eo5le8
methods8 measurement8 tools and e9ui5ments are interated to test a soft%are 5rodu't. 0he
in'reasin isibility of soft%are as a system element and the 'osts asso'iated %ith a soft%are
failure are motiatin for'es for %ell 5lannin and thorouh testin. 1t is not unusual for asoft%are for a soft%are deelo5ment oraniEation to e5and bet%een #! and *! 5er'ent of
total 5roje't effort on testin.
<=1TESTING FUNDA:ENTALS
0estin 5resent an interestin anomaly for the enineer. -arlier in the soft%are 5ro'ess8 the enineer attem5ts to build soft%are from an abstra't 'on'e5t to tanibleim5lementation. 0hen 'omes testin.
0he enineer 'reates a series of test 'ases that intended to demolish the soft%are that has been built. 1n fa't8 testin is one ste5 in the soft%are enineerin 5ro'ess that 'ould beie%ed(5sy'holoi'ally) as destru'tie rather than 'onstru'tie. Soft%are deelo5ers are bytheir nature 'onstru'tie 5eo5le. 0estin re9uires that the deelo5ers are by their nature'onstru'tie 5eo5le. 0estin re9uires that the deelo5er dis'ard 5re'on'eied notions of the6'orre'tness7 of the soft%are just deelo5ed and oer'ome a 'onfli't of interest that o''urs%hen error un'oered.
TESTING OBJECTIVES
0he soft%are testin obje'ties are as follo%s:
0estin is a 5ro'ess of ee'utin a 5roram %ith the intent of findin an error.
A ood test 'ase is one that has a hih 5robability of findin an asJyetJ
undis'oered error. A su''essful test is one that un'oers an asJyetJundis'oeredJerror.
0hese obje'ties im5ly a dramati' 'hane in ie%5oint. 0hey moe 'ounter to the'ommonly held ie% that a su''essful test is one in %hi'h no error are found.Different 'lasses of error and to do so %ith a minimum amount of time and effort.
<=1 UNIT TESTING -
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 175/180
1n unit testin8 ea'h and eery module is tested inde5endently %ith sam5le data
and it %as found that all modules are 5ro5erly fun'tionin. -a'h unit %as thorouhly tested to
'he' if it miht fall in any 5ossible situation. 0his testin %as 'arried out durin the
5rorammin itself. At the end of this testin 5hase8 ea'h unit %as found to be %orin
satisfa'tory8 as reard to the e5e'ted out5ut from the module.
<=2 INTEGRATION TESTING:J
All the modules8 %hen unit testin %ill %or 5ro5erly but after interfa'in the data 'an be lost
a'ross an interfa'e8 one module 'an hae an inadertent8 aderse effe't on other8 sub fun'tions
%hen 'ombined may not 5rodu'e the desired major fun'tion8 lobal data stru'tures 'an 'ause
5roblems8 et'. 1nteration testin is 5erformed by interatin all the indiidual modules and the
a'tiities of the user su'h as loadin layers8 retriein information from any fun'tions a55lyin
themes based on the re'ords 5resent in the database et'. and is found that it %ors ood to the
eamination of the end users. ?en'e8 the obje'tie of interation testin is to tae unit tested
modules and build a final 5roram stru'ture.
<= SYSTE: TESTING-
System tests are desined to alidate a fully deelo5ed system to assure that it meets its
re9uirements. 0here are essentially three inds of system testin:
• A%/.' #!,#$); refers to the system testin 'arried out by the test team %ithin the
deelo5in oraniEation.
• B!#' #!,#$); is the system testin 'arried out by a sele'ted rou5 of friendly
'ustomers.
• A""!/#')"! #!,#$); is the system testin 5erformed by the 'ustomer to determine
%hether to a''e5t or reje't the deliery of the system.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 176/180
<=6 BLACK BO TESTING-
Bla'Jbo testin is also no%n as fun'tional testin. A soft%are testin te'hni9ue %hereby
the internal %orins of the item bein tested are not no%n by the tester. >or eam5le8 in a bla' bo
test on a soft%are desin the tester only no%s the in5uts and %hat the e5e'ted out'omes should be
and not ho% the 5roram arries at those out5uts. 0he tester does not eer eamine the 5rorammin
'ode and does not need any further no%lede of the 5roram other than its s5e'ifi'ations.
<=5 @HITE -BO TESTING
4hiteJBo testin is also no%n as lass bo8 stru'tural8 'lear bo and o5en bo testin. A
soft%are testin te'hni9ue %hereby e5li'it no%lede of the internal %orins of the item bein
tested are used to sele't the test data. =nlie bla' bo testin8 %hite bo testin uses s5e'ifi'
no%lede of 5rorammin 'ode to eamine out5uts. 0he test is a''urate only if the tester no%s
%hat the 5roram is su55osed to do. ?e or she 'an then see if the 5roram dieres from its intended
oal. 4hite bo testin does not a''ount for errors 'aused by omission8 and all isible 'ode must also
be readable.
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 177/180
9=ADVANTAGES
>=30123: 1t allo%s to 'om5lete salary 'al'ulations in a fra'tion of time that %ould tae to
%or out manually. Also yearJend re5ortin is usually automated and both 5ay sli5s and
annual re5orts are ar'hied in 'ase 'o5ies are later needed.
01M- R-2RD13G: salary system 'an be lined to timesheet systems that re'ord em5loyee
attendan'e or time %ored. 1nformation about hours %ored 'an then be automati'ally
transferred into the salary system and used for 'al'ulation.
S02R13G P-RS23A/ R-2RDS: Most oraniEation %ill also ee5 other data about
em5loyees a''ordin to the re9uirement. By this salary system the additional dataFs 'an also
be simultaneously stored %ithout usin different soft %ares.
LI:ITATIONS
• Multi5ro'essin not allo%ed.
• -tensie hel5 is not 5roided.
• 3ot su55ort in the 2S lo%er than %indo%s
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 178/180
10=:AINTENANCE
Maintenan'e of a soft%are 5rodu't re9uires mu'h more effort than the effort ne'essary todeelo5 the 5rodu't itself. Maintenan'e inoles 5erformin anyone or more of the follo%inthree ind of a'tiities:J
o orre'tin errors that %ere not dis'oered durin the 5rodu't deelo5ment 5hase.0his is 'alled 'orre'tie maintenan'e.
o 1m5roin the im5lementation of the system and enhan'in the fun'tionality of thesystem a''ordin to the 'ustomerFs re9uirements. 0his is 'alled 5erfe'tiemaintenan'e.
o Portin the soft%are to %or in a ne% enironment. 0his is 'alled ada5tiemaintenan'e.
11=CONCLUSION
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 179/180
As the 'on'lusion8 the salary information system 'an be usin by many small and medium
s'ale industries. 1f the administrator did not hae the system to 'ontrol the 5ayroll then the
administrator %ill fa'e the 5roblem eery month %hen %ant to 'al'ulate the salary to
em5loyee. 0his %ill tae a lot of time for administrator to 'al'ulate it. 0herefore by deelo5
the system all of this 5roblem %ill be sole and administrator no need to 'al'ulate the salary
as manually be'ause all the salary %ill automati' 'al'ulate by the system.
12=BIBLIOGRAPHY
7/23/2019 Payroll Information System
http://slidepdf.com/reader/full/payroll-information-system 180/180
?ere are some of the referen'es from %hi'h %e hae 'olle'ted the information:
%%%.bull%ars.'om
%%%.freestudents5roje't.'om
%%%.te'hnoloyealuation.'om
%%%.%ii5edia.'om htt5:CC%%%.s'ribd.'omCdo'C###*&!*CPayrollJ5roje'tJre5ortJ%ithJSrs
htt5:CC%%%.freestudent5roje'ts.'omCstudent5roje'tre5ortC5roje'tJ
srsCem5loyeeJ5ayrollJmanaementC htt5:CC%%%.a''ountants%orld.'omC5o%erCPra'ti'eCSolutionsCPayrollReliefJ
>eatures.as5 htt5:CC%%%.55ay.'o.uC5ayrollJseri'eJte'hni'alJsystemC
C