<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
errorPage="error.jsp"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
boolean withError = false;
String strMainDB = "product_pgpClientInfoDB";
String strSubTitle = "", strCompanyName = "", strPrevBtn = "", strNextBtn = "";
String [] arrCPID, arrCPFName, arrCPLName, arrCPPos, arrCPDept, arrCPEMail;
String [] arrCPTArea, arrCPTNum, arrCPTLoc;
int intArrayLength = 5; // USE FOR DEFINING ARRAY LENGTH, SINCE ADD IS ALWAYS BY BATCH 5
int batchModifier = 2; // IF EQUAL TO UNITS OF LAST BATCH, IT'LL BE COMBINED WITH SECOND TO LAST BATCH
int batchMaxUnit = 5; // MAXIMUM NUMBER OF CONTACT PERSONS THAT WOULD BE DISPLAYED PER PAGE
int ctr = 0, total = 0; // USE FOR COUNTING TOTAL NUMBER CONTACT PERSONS
String strPageID = "memcpaddj"; // USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
String strCheckOut = "no"; // SWITCHES PAGE TO VIEW MODE AFTER DONE SUBMIT
String strTableName = "tmpTblBlankOCPs";
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
byte bytDeptID = Byte.parseByte(request.getParameter("did"));
int intBegPoint = Integer.parseInt(request.getParameter("p1"));
int intEndPoint = Integer.parseInt(request.getParameter("p2"));
int intP1 = intBegPoint;
int intP2 = intEndPoint;
/***** END OF VARIABLE DECLARATION *****/
String SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";";
users.connect(strMainDB);
ResultSet rs = users.listQuery(SQLstmt);
byte bytLogStatus = 0;
while (rs.next()) {
bytLogStatus = rs.getByte("LogOnStatus");
}
if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE
%>
<%
} else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE
SQLstmt = "SELECT Co_Name FROM tblCompanyInfo WHERE Co_ID=" + intCompanyID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) { // GET NAME OF COMPANY
strCompanyName = rs.getString("Co_Name");
}
SQLstmt = "SELECT * FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
" AND Page_ID='" + strPageID + "';";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
strSubTitle = rs.getString("Message");
ctr++;
}
if (ctr != 0) { // A MESSAGE INTENDED FOR THIS PAGE WAS FOUND ON tmpTblMessages
int intCoID = 0;
withError = true;
if (strSubTitle.equals("ok")) {
} else {
strTableName = "tmpTblAddOCPs";
intCoID = intCompanyID;
}
intBegPoint = 0;
intEndPoint = batchMaxUnit;
SQLstmt = "SELECT * FROM " + strTableName + " WHERE Co_ID=" + intCoID + " ORDER BY CPx_ID;";
} else {
SQLstmt = "SELECT * FROM " + strTableName + " WHERE Co_ID=0 ORDER BY CPx_ID;";
}
ctr = 0;
rs = users.listQuery(SQLstmt);
while (rs.next()) {
ctr++; // COUNTS TOTAL NUMBER OF CONTACT PERSONS
}
total = ctr;
arrCPID = new String[intArrayLength];
arrCPFName = new String[intArrayLength];
arrCPLName = new String[intArrayLength];
arrCPPos = new String[intArrayLength];
arrCPDept = new String[intArrayLength];
arrCPTArea = new String[intArrayLength];
arrCPTNum = new String[intArrayLength];
arrCPTLoc = new String[intArrayLength];
arrCPEMail = new String[intArrayLength];
if (intBegPoint==0) { // NO PREVIOUS DATA TO DISPLAY
strPrevBtn = "";
} else { // PREVIOUS BUTTON IS ACTIVATED
strPrevBtn = "";
}
if (intEndPoint >= (ctr-batchModifier)) { // NO REMAINING DATA CAN BE DISPLAYED
strNextBtn = "";
} else { // NEXT BUTTON IS ACTIVATED
strNextBtn = "";
}
if (intBegPoint==0) { // SINCE RESULTSET METHOD ABSOLUTE DOES NOT WORK WITH VALUE EQUAL TO ZERO
rs.beforeFirst();
} else {
rs.absolute(intBegPoint);
}
ctr = 0;
while (rs.next()) {
arrCPID[ctr] = rs.getString("CPx_ID");
arrCPFName[ctr] = rs.getString("CPx_FirstN");
arrCPLName[ctr] = rs.getString("CPx_LastN");
arrCPPos[ctr] = rs.getString("CPx_Position");
arrCPDept[ctr] = rs.getString("CPx_Dept");
arrCPTArea[ctr] = rs.getString("CPx_TelArea");
arrCPTNum[ctr] = rs.getString("CPx_TelNum");
arrCPTLoc[ctr] = rs.getString("CPx_TelLocal");
arrCPEMail[ctr] = rs.getString("CPx_EMail");
ctr++;
if (ctr==(arrCPFName.length)) {
break;
}
}
users.disconnect();
if (withError) { // RETAINS VALUE FROM tmpTblMessages AS INITIALIZE ABOVE
} else { // CONTACT PERSON COUNT IS ONE
strSubTitle = "ADD CONTACT PERSONS";
}
if (strSubTitle.equals("ok")) {
strCheckOut = "view";
strSubTitle = "Update Successful...";
}
/***** MERGING WITH MAIN HTML CODES STARTS HERE *****/
%>
Add Contact Persons