<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strPageID = ""; // USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
String strTmpTbl = "";
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
byte bytDeptID = Byte.parseByte(request.getParameter("did"));
int counter = Integer.parseInt(request.getParameter("ctr"));
switch (bytDeptID) {
case 1:
strTmpTbl = "tmpTblCoHeadOfc";
strPageID = "memofcedj1";
break;
case 2:
strTmpTbl = "tmpTblSalesOfc";
strPageID = "memofcedj2";
break;
case 3:
strTmpTbl = "tmpTblShowRm";
strPageID = "memofcedj3";
break;
case 4:
strTmpTbl = "tmpTblWareHse";
strPageID = "memofcedj4";
break;
case 5:
strTmpTbl = "tmpTblTechSvc";
strPageID = "memofcedj5";
break;
case 10:
strTmpTbl = "tmpTblForeignOfc";
strPageID = "memofcedj0";
}
/***** 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 = "DELETE FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
" AND Page_ID='" + strPageID + "';";
users.updateData(SQLstmt);
if (bytDeptID==1) {
SQLstmt = "DELETE FROM " + strTmpTbl + " WHERE CoHO_ID=" + intCompanyID + ";";
} else {
SQLstmt = "DELETE FROM " + strTmpTbl + " WHERE Co_ID=" + intCompanyID + ";";
}
users.updateData(SQLstmt);
SQLstmt = "DELETE FROM tmpTblCPIndicator WHERE Co_ID=" + intCompanyID +
" AND Dept_ID=" + bytDeptID + ";";
users.updateData(SQLstmt);
SQLstmt = "DELETE FROM tmpTblContactPersons WHERE Co_ID=" + intCompanyID +
" AND Dept_ID=" + bytDeptID + ";";
users.updateData(SQLstmt);
users.disconnect();
%>
Infinity
<% } // END OF LOG CHECK %>