<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
errorPage="error.jsp"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strFileName = "", strLogName = "", strFName = "", strLName = "", strEMail = "";
String strTelArea = "", strTelNum = "", strTelLocal = "", strFaxArea = "", strFaxNum = "", strFaxLocal = "";
String strTel = "", strFax = "", strPos = "", strCompanyName = "";
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
byte bytDeptID = Byte.parseByte(request.getParameter("did"));
/***** END OF VARIABLE DECLARATION *****/
switch (bytDeptID) {
case 6:
strFileName = "bpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=6&srt=0&p1=0&p2=40";
break;
case 7:
strFileName = "bpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=7&srt=0&p1=0&p2=40";
break;
case 8:
strFileName = "bdmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=8";
break;
case 9:
strFileName = "bdmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=9";
break;
case 11:
strFileName = "cpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=11&p1=0&p2=5";
break;
default:
strFileName = "ofcmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=" + bytDeptID;
}
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 Usr_LogName FROM tblUserPwd WHERE Pwd_ID=" + intUserID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
strLogName = rs.getString("Usr_LogName");
}
SQLstmt = "SELECT * FROM tblUserInfo WHERE Usr_ID=" + intUserID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
strFName = rs.getString("Usr_FName");
strLName = rs.getString("Usr_LName");
strTelArea = rs.getString("Usr_TelArea");
strTelNum = rs.getString("Usr_TelNum");
strTelLocal = rs.getString("Usr_TelLocal");
strFaxArea = rs.getString("Usr_FaxArea");
strFaxNum = rs.getString("Usr_FaxNum");
strFaxLocal = rs.getString("Usr_FaxLocal");
strEMail = rs.getString("Usr_EMail");
}
if (strTelLocal.equals("")) {
strTel = "(+63" + strTelArea + ") " + strTelNum;
} else {
strTel = "(+63" + strTelArea + ") " + strTelNum + " loc. " + strTelLocal;
}
if (strFaxNum.equals("")) {
strFax = "none";
} else if (strFaxLocal.equals("")) {
strFax = "(+63" + strFaxArea + ") " + strFaxNum;
} else {
strFax = "(+63" + strFaxArea + ") " + strFaxNum + " loc. " + strFaxLocal;
}
SQLstmt = "SELECT Co_Name, Usr_Position FROM tblCompanyInfo WHERE Co_ID=" + intCompanyID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) { // GET POSITION OF USER IN THE COMPANY AND NAME OF COMPANY
strPos = rs.getString("Usr_Position");
strCompanyName = rs.getString("Co_Name");
}
/***** MERGING WITH MAIN HTML CODES STARTS HERE *****/
%>
User Profile
USER PROFILE
User: <%= strLogName %>
Name: <%= strFName %> <%= strLName %>
Phone: <%= strTel %>
Fax: <%= strFax %>
e-mail: <%= strEMail %>
Company (Current Active Page): <%= strCompanyName %>
Position: <%= strPos %>
<% } // END OF if (bytLogStatus != 1) %>