payRollHub.jsp

<%--Called from payRollEntry. Creates a table for the employees chosen in payRollEntry
through which payroll data can be added --%>
<html>
<head>
<title>untitled - document</title>
</head>
<body bgcolor = AAB6EC>
<%@ page import= "javax.swing.*" %>
<%@ page import= "java.sql.*" %>
<%@ page import= "java.util.*" %>
<%@ page import= "com.EmployeeObject4"%>

<%@ page import= "com.*"%>
<%@ page import= "java.io.*"%>
<h2>Enter the employees payroll details</h2>
<%
String[] tick = request.getParameterValues("tick");
String periodFor = request.getParameter("periodFor");
if (tick.length == 0)
    {
   %>  <jsp:forward page="NoDataError.jsp"/><%
    }
ArrayList blist = new ArrayList();
double currentperiod = (double)Double.parseDouble(periodFor);
//CompanyName taken from the session object cast to a String and placed
//in a String.
String companyName = (String)session.getAttribute("company");
int u =0;
//Loop as many times as there are NIC values in the tick array.
while(u < tick.length)
    {
    Statement statement;
    ResultSet resultSet;
//Select statement sent retrieve all data on the employees required for the payroll process.
    String query = "Select Perseweekly.periodNum, perse3.FirstName, perse3.Surname, perseweekly.NIC, perse3.WageHour, Perse3.MonthWeek, Perse3.WageHoursOver1, Perse3.PAYEcode, Perseweekly.paySoFar, Perseweekly.TaxSoFar, Perseweekly.Column8, perse3.NICtable, perse3.AccountNumber, perse3.SortCode, perse3.WMbasis, Perse3.WageHoursOver2, Perse3.WageHoursOver3, Perse3.WMbasis FROM perse3 INNER JOIN perseweekly ON perse3.NIC like perseweekly.NIC WHERE perse3.employed = 1 AND perse3.NIC like '"+tick[u]+"' AND perse3.CompanyName like '"+(String)session.getAttribute("company")+"' ORDER BY perseweekly.periodNum DESC";
    Connection connection = ConnectionPool2.getConnection();
    statement = connection.createStatement();
    resultSet = statement.executeQuery( query );
    System.out.println(resultSet);
    EmployeeObject4 employee;
    resultSet.next();
//New EmployeeObject instantiated.
    employee = new EmployeeObject4();
//Data from the the result set is placed in the employeeObject
    employee.setLastPeriod(resultSet.getInt(1));
    employee.setFirstName(resultSet.getString(2));
    employee.setSurname(resultSet.getString(3));
    employee.setNIC(resultSet.getString(4));
    employee.setWageHour(resultSet.getDouble(5));
    employee.setMonthWeek(resultSet.getString(6));
    employee.setWageHourOver(resultSet.getDouble(7));
    employee.setPAYEcode(resultSet.getString(8));
    employee.setLastPayToDate(resultSet.getDouble(9));
    employee.setLastTaxToDate(resultSet.getDouble(10));
    employee.setColumn8(resultSet.getDouble(11));
    employee.setNICtable(resultSet.getString(12));
    employee.setAccountNumber(resultSet.getString(13));
    employee.setSortCode(resultSet.getString(14));
    employee.setWageHourOver2(resultSet.getDouble(16));
    employee.setWageHourOver3(resultSet.getDouble(17));
    employee.setCumulative(resultSet.getBoolean(18));
    employee.setCurrentPeriod(currentperiod);
    System.out.println("PayRollHub -"+employee.getNIC());
//The period entered for which the payroll is to be carried out is converted to
//a double and placed in the EmployeeObject instance.
    String peri = request.getParameter("periodFor");
    double per = Double.parseDouble(peri);
    employee.setCurrentPeriod(per);
    statement.close();
//The EmployeeObject instance is added to the ArrayList instance.
    blist.add(employee);
    u++;
    }
//EmployeeObject declaration
EmployeeObject4 employee2;
//Below a table and form are created into which the hours worked or amount of pay
//can be entered.

%>
<%--The table header is created--%>
<form action="payRollAxis.jsp" method="post">
<TABLE BORDER="1" WIDTH="100%">
<th><font size="2">First Name </th>
<th bgcolor = "90ee90" ><font size="2">NIC number</th>
<th><font size="2">Enter Wage<br> as<br> Lump Sum </th>
<th bgcolor = "90ee90"><font size="2">Bonus </th>
<th><font size="2">Hours worked
<th bgcolor = "90ee90"><font size="2">Overtime1<br> Hours <br>Overtime1</th>
<th><font size="2">Overtime2<br> Hours <br>Overtime2</th>
<th bgcolor = "90ee90"><font size="2">Overtime3<br> Hours <br>Overtime3</th>
<th><font size="2">SSP</th>
<th bgcolor = "90ee90"><font size="2">SMP</th>
<th><font size="2">Pay <br>Alterations</th>
<%
//Loop through all the employeeObjects held in the ArrayList.
for(int g = 0; g < blist.size();g++)
    {
    employee2 = (com.EmployeeObject4)blist.get(g);
    %>
<%--Lays a row in the table through which payroll
information on individual employees  is entered --%>
    <TR>
    <TD><%=employee2.getFirstName()%></TD>
    <TD><%= employee2.getNIC()%></TD>
    <TD><input type="text" size="10" name = "lump" value ="0"></TD>
    <TD><input type="text" size="10"name = "bonus" value ="0"></TD>
    <TD><input type="text" size="10"name = "hours" value ="0"></TD>
    <TD><input type="text" size="10"name = "overHours" value ="0"></TD>
    <TD><input type="text" size="10"name = "overHours2" value ="0"></TD>
    <TD><input type="text" size="10"name = "overHours3" value ="0"></TD>
    <TD><input type="text" size="10"name = "ssp" value ="0"></TD>
    <TD><input type="text" size="10"name = "smp" value ="0"></TD>
    <TD><input type="text" size="10"name = "alteration" value ="0"></TD>
    </TR>
    <%
    }
//The ArrayList is set as an attribute in the session object.
session.setAttribute("hubArrayList", blist);
%>
</TABLE>
<input type="submit">
</form>
</body>
</html>