Transcription
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018, Pp. 1-6Design and Development of Web Based EmployeePayroll Information System Using CodeigniterFramework and Extreme Programming MethodMaria Ulfah SiregarInformatics Department, Master Program, Faculty ofScience and Technology, Universitas Islam Negeri SunanKalijagaYogyakarta, Indonesia, [email protected] Eko Katon MahardikaStudent of Informatics Department, Faculty of Scienceand Technology, Universitas Islam Negeri Sunan KalijagaYogyakarta, Indonesia, [email protected] system, which is expected to help and facilitate thepayroll process of employees. The implementation of the payrollinformation system is very influential on companies or agenciesthat have a large number of workers. Furthermore, thecomponent of employee wages or salaries is not only the basicsalary, but also includes various allowances, incentives,deductions, overtime and other wages outside the basic salary[1,2,4,5,6]. The amount of salary for each workforce is alsodifferent. If the salary calculation process is still manual, it canbe detrimental to the company in terms of time efficiency, whichwill take a long time, so that it can result in delays in payment orpayment of salaries to employees.Abstract—Universitas Proklamasi 45 Yogyakarta is a privateuniversity which is supervised by a Foundation that hasimplemented various information systems in various fields ofwork. However, in the payroll process the employees are still donemanually and have not utilized a computerized system, such asattendance recap, wage recapitulation in addition to basic salary,as well as the sum of salary received by employees. This makes thepayroll process less effective and efficient. This study aims toestablish a proposed system that is a web-based employee payrollinformation system at the Universitas Proklamasi 45 Yogyakartawith the PHP programming language using CodeigniterFramework and MySQL as its database. The system developmentmethod used is the Extreme Programming method. This methodwas chosen because it promotes intense communication betweenthe client and the system developer so that when there are changesor errors in the system, the developer is always ready to fix it.Extreme Programming also has a simple stage, namely planning,design, coding, and testing. The results of this study are the resultof a web-based employee payroll information system that hasvarious actors involved in the management and processing of itsdata. With this information system, the employee payroll processbecomes more effective and efficient, because payroll data isprocessed and calculated by the system so that it has a high levelof data accuracy and does not require a long time in the calculationprocess.Web Application, InformationCodeigniter, Extreme ProgrammingI.System,PayrollUniversitas Proklamasi 45 Yogyakarta is a private universitywhose management is supervised by a Foundation. In every fieldof work, almost all have used information systems to facilitatetheir work and managerial governance. But in the employeepayroll process, it is not yet effective and efficient because theprocess is manual or does not utilize an information system, soit still has some shortcomings. These shortcomings includepayroll processes that take a long time, the accuracy of datacalculation and documentation of data is not well organized. Oneof the things that makes the payroll process take a long time isto recap data that affects the amount of salary nominal calculatedmanually, such as employee attendance recap, recap overtimedata, and recap of wages other than basic salary. Therefore, it isnecessary to have an effective, efficient and effective employeepayroll information system to be used in the employee salarycalculation process at the Yogyakarta Proclamation University45 Yogyakarta.System,INTRODUCTIONTechnological advances today are experiencing very rapiddevelopment in various fields. This is marked by theimplementation of a service system that has been computerizedin various agencies and various fields in order to provideconvenience both for the company and for users in order to findinformation quickly and accurately. Many companies arecompeting to implement a computerized system that suits theneeds of the company with the aim of improving and optimizingthe quality of their services. Not even a few companies thatinclude the application of a computerized system in their visionand mission.In designing information systems, there are problems thatoften occur, namely the request for changes in requirements andthe addition of features to the system desired by the client whenthe system design process is carried out [7,8,9]. Therefore, asimple system development method is needed and involvesclients in terms of communicating with system developers [3].Extreme Programming method is one of Agile methodologiesthat emphasizes good communication with clients, is fast in thedevelopment process, and is ready to accept changes andimprovements whenever there is an error. Therefore, theExtreme Programming method is used in designing thisemployee payroll information system.One system that is widely used in a company in order tooptimize their service quality is the application of a payroll1
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018II.PURPOSEsystem, UML is used because it places more emphasison developing object-oriented systems.The formulation of the problem raised from the backgroundabove is:1.Analyzing and designing a web-based Employee PayrollInformation System at the Yogyakarta ProclamationUniversity 452.Implementing the information system into the employeepayroll process at the Universitas Proklamasi 45Yogyakarta so that it becomes an effective informationsystemIII.3) CodingAt this stage is the stage where making the systembased on the design results that have been madepreviously. The design is implemented in the form ofcode that can be understood by computers withprogramming languages. As previously explainedabout Extreme Programming that this method involvesthe client in the system development process, theCoding process is carried out repeatedly if there is acorrection from the system user (refactoring).4) TestingAt this stage, each module that is being developed willfirst undergo testing. If it is still not in accordance withthe request, it will be repaired on the corrected part. Ifaccording to the request, the system can beimplemented.RESEARCH METHODSA. Data Collection MethodologyData were collected from various sources. Methodologythe data collection performed in this study are:1) Literature Study: Studying the theory / literature andscientific books and references related to PayrollSystem and Web-based technology applications.2) Interview: conduct interviews with the project ownerregarding the current employee payroll process.3) Observation: make direct observations when theemployee payroll process takes place.IV.SYSTEM DEVELOPMENT USING EXTREMEPROGRAMMINGIn developing the system using the Extreme Programmingmethod, this resulted in three development phases. Anexplanation of each of these phases can be seen below.B. Identification of ProblemsA. First PhaseIn this first cycle, it focuses on the main purpose andfunctionality of the system being developed.The main problems that occur in payroll processing aresuch as the calculation of attendance recap, payroll componentdata recap, making reports and salary slips that are donemanually. This requires a high level of accuracy considering thatsalary is a right of each employee to receive a valid salaryamount, so that it takes a long time in the process of calculatingand processing data. The problems contained in this research canbe developed with a web-based system, namely the PayrollInformation System. This system will help solve the problembecause it is computerized and automated so that the dataprocessing and salary calculation can be carried out validly andquickly.1) First Phase PlanningIn this first planning phase, the researcher analyzes therequirements of the developed system. The analysis iscarried out by means of interviews and discussions with theproject owner. The results obtained are anyone who willuse the system later, and how the system works. Usersinvolved in the system can be seen in the table 1.TABLE 1. LIST OF USERS WHO USE THE SYSTEMC. Application DevelopmentSystem development method used in this research isExtreme Programming methodology. Extreme Programmingsequential system consist of:1) PlanningAt this stage defines the scope during the research,analyzes the current system and the problems thatoccur. Then it continues by analyzing the requirementsof the system to be designed.2) DesignAt this stage, designing the system work process anddatabase design in accordance with the results of datacollection and the results of the analysis that has beencarried out. In designing the work process of thisNoUsers1.HR Staff2.Academic Staff3.Financial Staff4.The head of the company5.Head of Unit6.EmployeeThe next step is to define and analyze the systemfunctional requirements which aim to determine what canbe done by the developed system. Functional requirementsare:2
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018a. Master data management which includes employeedata, position, work unit, work period, and nominalpayroll components.to achieve the objectives of the Use Case that have beendescribed previously. The Sequence Diagram can be seenin Figure 4 and Figure 5.b. Payroll component data management whichincludes overtime data and meetings.c. Management of employee attendance data whichincludes employee attendance data uploads andprinting employee attendance recap data.d. Management of academic data which includesfaculty data, study programs, courses, studentexaminations, exam supervisors, and test resultscorrector.e. Management of payroll data that includesgenerating pay slips, printing pay slips, sendingpayroll slips, and seeing payroll reports.f. Providing operational incentives for employees bythe division heads of each division.FIGURE 2. ACTIVITY DIAGRAM OF EMPLOYEE ATTENDANTDATA UPLOADg. See payroll data that can be done by each employee.2) First Phase DesignIn this first phase design the researcher makes thedesign process in the form of a use case diagram based onthe results of the analysis that has been carried out. Thepurpose of making a use case diagram is to describe whatfeatures or functions the system has developed.FIGURE 3. ACTIVITY DIAGRAM OF GENERATE PAYSLIPFIGURE 1. USE CASE DIAGRAM FIRST PHASENext, the researcher makes an activity diagram todescribe the activities that occur in the system. There aremain activities, namely uploading employee attendancedata and generating employee pay slips. Activity diagramcan be seen in Figure 2 and Figure 3.FIGURE 4. SEQUENCE DIAGRAM OF EMPLOYEE ATTENDANTDATA UPLOADSequence Diagram design is also needed to explain indetail the sequence of processes carried out in the system3
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018FIGURE 5. SEQUENCE DIAGRAM OF GENERATE PAYSLIPFIGURE 7. GENERATE PAYSLIP PAGE3) First Phase Coding4) First Phase TestingIn this first phase coding, several implementations werecarried out which included database implementation andimplementation of the interface design that had beencreated. In the database, there are many tables used. A listof database tables can be seen in the table 2.In this first phase of testing researchers involve all usersof the system and focus on the functionality of the systembeing developed. During the testing process, researchersget requests for the addition of several new features,namely:TABLE 2. LIST OF TABLE ON DATABASE IN FIRST PHASENo.Table NameNo.Table Name1.Master bidang12.Data rapat peserta2.Master unit kerja13.Data upah rapat3.Master jabatan14.Data lembur4.Master periode15.Data upah lembur5.Master jam kerja16.Data ujian6.Master prodi17.Data ujian pengawas7.Master matakuliah18.Data ujian korektor8.Master nominal19.Data upah pengawas9.Data karyawan20.Data upah korektor10.Absensi data21.Data insentif operasional11.Data rapat22.Data slip gajia. Change behavior from each date input field, will bedisabled when the work period has not beenselected.b. Automatic attendance recap when the attendancedata upload process is done.c. Change employee attendance data.d. Employee overtime submission.e. Speed up the process of generating employee payslips.B. Second PhaseIn this second phase, there are fundamental differences withthe previous phase, which is more focused on improving systemperformance. It can be seen from the results of the first phasetesting.1) Second Phase Planning and DesignThe purpose of changing the way of working from theinput date field is, so that the date entered is no less or nomore than the initial limit and the deadline for the selectedwork period. So, before the work period is selected, theinput date field in the disable state. This is an effective stepso that the data entered into the system is more properlydocumented and neat based on its working period.Next, implementation results of the interface designcan be seen in Figure 6 and Figure 7.Furthermore, the purpose of adding automaticattendance recap functionality is when HR staff uploadattendance data, the system will read and store attendancedata into the attendance data table, while simultaneouslyrecording the attendance data which will then be stored inthe attendance recap table. This will have an impact onsystem performance when generating employee pay slips,because the process of generating payroll slips requiresmonthly attendance recap data from each employee. Whenthe process of generating pay slips, the system simply readsthe attendance recap data from the attendance recap table,FIGURE 6. LOGIN PAGE4
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018no longer need to do calculations or calculation of dailyattendance data from the attendance data table.In this phase, changes and additions are made to thesystem database structure, which is adding a table calledemployee attendance recap and changing employeeovertime table. The design of new pages is also done,namely the employee attendance data change page and theovertime request page by employees.daily work plans, pages for daily reports, monthlychecklist pages, and pages for monthly reports.2) Third Phase CodingBased on the results of the design in the third phasedesign, the researcher then implements the addition offeatures to the system developed. The first is to implementwork report management features for employee actors bycreating pages for daily work plans and reports, as well aspages for checklists and monthly reports.2) Second Phase CodingAfter analysis and redesign, researchers carried out theimplementation of the system developed. In this secondphase, the code structure changes or commonly referred toas refactoring.3) Third Phase Testing3) Second Phase TestingAfter implementing the feature additions in theprevious stage, the researchers tested the system againwith the Proclamation University 45 as the project owner.The results of this third phase testing are in accordancewith the planning that researchers have done before, andthe output produced is in accordance with the projectowner's request. Therefore the developed system is readyfor release.In the second phase of the testing, it was re-conductedwith the project owner. The results of this test are that thereare several requests for additional new features in thesystem, namely:a. Additional employee work report managementfeatures for employees, which can be used to createdaily work plans, daily work reports, monthlychecklists, and monthly work reports.b. The addition of employee performance appraisalfeatures by the unit head.V.RESULTThe previous employee payroll process requires work orsalary calculation activities manually. With this payrollinformation system, the manual calculation can be left behindand switch to using an information system. Payroll data iscalculated and presented neatly in the system. Payroll slipswhich are the final result of the payroll component calculationprocess can also be obtained by utilizing this payrollinformation system. Based on the explanation above, the payrollinformation system that was designed during this study waseffective to be used in the employee payroll process because interms of results it was in line with what was expected.C. Third PhaseIn this third phase, further development is carried out on thesystem by adding several new features based on the projectowner's request. This feature is considered effective by theproject owner when applied to the system because it is alsoincluded as one of the factors that influence the amount ofemployee payroll.1) Third Phase Planning and DesignThe reason for the addition of employee work reportmanagement features and employee performanceappraisal features is as a parameter and also the referenceused by the Head of Unit in providing operationalincentives to employees who are under him. In addition tothe current system, employees make work reports usingMicrosoft Excel which then sends it to the Head of the Unitvia email. The Unit Head must open one by one the workreport file sent to him when he wants to see and check whatthe employee's work report looks like. This will take a longtime.At this stage the researcher again designed the activitydiagram and sequence diagram for the management ofemployee work reports and employee performanceappraisal. It also creates a new table in the database,namely the daily work plan and report tables, detailedtables of daily work plans and reports, checklist tables andmonthly reports, detailed checklist and monthly reporttables, and employee performance appraisal tables. Thenit continues by designing the interface for the employeework report management page which includes pages forIn terms of time, the payroll information system that wasdesigned also succeeded in increasing efficiency in theemployee payroll process at the Universitas Proklamasi 45Yogyakarta. In the previous system, manual payroll calculationtook quite a long time considering the number of data and thenumber of employees was not small. The calculation must alsobe careful and accurate so that the results are accurate, sosometimes it is not enough if you only do calculations only onceand need to be reset. With this payroll information system, datais calculated and processed by a computerized system so thatthe level of data accuracy increases and does not take a longtime. Based on this explanation, an efficient payroll informationsystem for use in the employee payroll process.CONCLUSIONThe use of Extreme Programming methods in thedevelopment of this system resulted in three phases ofdevelopment. In each phase there is always a testing phase thatinvolves the project owner to find out whether the system is inaccordance with the needs or not. The system development phase5
(IJID) International Journal on Informatics for DevelopmentVol. 7, No. 2, 2018is declared complete when all planned system functionality issuccessfully implemented properly and does not get correctionfrom the project owner.Based on research that has been done on the development ofWeb-based Employee Payroll Information System usingExtreme Programming method (case study in UniversitasProklamasi 45 Yogyakarta), then the conclusions drawn asfollows:1) This study succeeded in analyzing and designingemployee payroll information systems in accordancewith the payroll flow in the Universitas Proklamasi 45Yogyakarta based on the results of the analysis that hasbeen carried out.2) This research succeeded in implementing the employeepayroll information system at the UniversitasProklamasi 45 Yogyakarta so that it became aneffective information , Sistem Informasi Penggajian dan Pengupahan KaryawanMenggunakan Arsitektur Hierarchial-Model-View-Controller FrameworkPHP Codeigniter (Studi Kasus di PT. Krakatau Wijatama Cilegon,Banten). Skripsi: UIN Sunan Kalijaga, 2013Ardhi, D. P., Pengembangan Sistem Absensi dan Penggajian Karyawan diPT. X. Skripsi, Yogyakarta: UIN Sunan Kalijaga, 2011.Daqiqil, I., Framework Codeigniter Panduan Terbaik dan Best 852207/frameworkcodeigniter diakses pada 21 Juni 2018.Dewanto, S. P., Perancangan dan Implementasi Sistem Informasi Cost ofProduction (COP) dan Pengajian Karyawan Penerbit Buku PendidikanDeepublish (CV Budi Utama) Yogyakarta. Skripsi, Yogyakarta: UINSunan Kalijaga, 2013.Firdaus, M., Rancang Bangun Sistem Informasi Penggajian Karyawan diCV. Sogan Jaya Abadi dengan Metode Prototyping. Skripsi, Yogyakarta:UIN Sunan Kalijaga, 2017.Hutama, P. W., Rancang Bangun Aplikasi Presensi Karyawan BerbasisAndroid dengan Metode Extreme Programming pada PT. GeschoolCerdas Mandiri. Skripsi, Yogyakarta: UIN Sunan Kalijaga, 2016.Jogiyanto, H. M., Analisis dan Desain Sistem Informasi. Yogyakarta:Penerbit Andi, 2005.Kadir, A., Pengenalan Sistem Informasi. Yogyakarta: Penerbit Andi,2003.Whitten, Bentley & Dittman, Metode Desain dan Analisis Sistem.Yogyakarta: Penerbit Andi, 2004.6
(IJID) International Journal on Informatics for Development Vol. 7, No. 2, 2018, Pp. 1-6 1 Design and Development of Web Based Employee
