<%@ page language="java"
    import="java.sql.*, java.io.*, java.util.*, users.databases.*"
    errorPage="error.jsp"
%>
  <jsp:useBean id="users" class="users.databases.tmpDataList" />
<%
  /***** VARIABLE DECLARATION and INITIALIZATION *****/

  boolean includeUser = false;
  String strMainDB = "product_pgpClientInfoDB";
  String strStreet = "", strBrgy = "", strCity = "", strProv = "", strZipCode = "";
  String strTel = "", strTelArea = "0", strTelNum = "0", strTelLocal = "0";
  String strFax = "", strFaxArea = "0", strFaxNum = "0", strFaxLocal = "0";
  String strWebsite = "", strEMail = "", strCPTitle = "", strCompanyName = "";
  String [] arrCPFName, arrCPLName, arrCPPos, arrCPTel, arrCPEMail;
  String strTblName = "", strPrefix = "", strPageTitle = "", strSubTitle = "";
  byte bytLogStatus = 0, bytTotalCP = 0, idx = 0;
  byte bytForeignStat = 0, bytSalesStat = 0, bytShowRmStat = 0, bytPWHseStat = 0, bytTSvcStat = 0;

  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 *****/

  String SQLstmt = "SELECT ForeignOfc, SalesOfc, ShowRm, PlantAndWHse, TechlSvc FROM tblCoInfoIndicator" +
                   " WHERE Co_ID=" + intCompanyID + ";";
  users.connect(strMainDB);
  ResultSet rs = users.listQuery(SQLstmt);
  while (rs.next()) {
    bytForeignStat = rs.getByte("ForeignOfc");
    bytSalesStat = rs.getByte("SalesOfc"); 
    bytShowRmStat = rs.getByte("ShowRm");
    bytPWHseStat = rs.getByte("PlantAndWHse");
    bytTSvcStat = rs.getByte("TechlSvc");
  }

  if (bytDeptID==2) {
    if (bytSalesStat==0) {
      bytDeptID = 1;
    }
  } else if (bytDeptID==3) {
    if (bytShowRmStat==0) {
      bytDeptID = 1;
    }
  } else if (bytDeptID==4) {
    if (bytPWHseStat==0) {
      bytDeptID = 1;
    }
  } else if (bytDeptID==5) {
    if (bytTSvcStat==0) {
      bytDeptID = 1;
    }
  } else {
    if (bytForeignStat==0) {
      bytDeptID = 1;
    }
  }

  switch (bytDeptID) {
    case 1:
      strTblName   = "tblCoHeadOfc";
      strPrefix    = "CoHO";
      strPageTitle = "Head Office";
      strSubTitle  = "HEAD OFFICE ADDRESS";
      break;
    case 2:
      strTblName   = "tblSalesOfc";
      strPrefix    = "SOfc";
      strPageTitle = "Sales Office";
      strSubTitle  = "SALES OFFICE ADDRESS";
      break;
    case 3:
      strTblName   = "tblShowRm";
      strPrefix    = "SRm";
      strPageTitle = "Showroom";
      strSubTitle  = "SHOWROOM ADDRESS";
      break;
    case 4:
      strTblName   = "tblWareHse";
      strPrefix    = "WHse";
      strPageTitle = "Plant/Warehouse";
      strSubTitle  = "PLANT OR WAREHOUSE ADDRESS";
      break;
    case 5:
      strTblName   = "tblTechSvc";
      strPrefix    = "TSvc";
      strPageTitle = "Technical Services Office";
      strSubTitle  = "TECHNICAL SERVICES OFFICE ADDRESS";
      break;
    case 10:
      strTblName   = "tblForeignOfc";
      strPrefix    = "FOfc";
      strPageTitle = "Foreign Office";
      strSubTitle  = "FOREIGN OFFICE ADDRESS";
  }


  SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";";
  users.connect(strMainDB);
  rs = users.listQuery(SQLstmt);
  while (rs.next()) {
    bytLogStatus = rs.getByte("LogOnStatus");
  }
  if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE
%>
    <jsp:include page="getindex.jsp" flush="true"/>
<%
  } else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE

    if (bytDeptID==1) {
      SQLstmt = "SELECT * FROM " + strTblName + " WHERE CoHO_ID=" + intCompanyID + ";";
    } else {
      SQLstmt = "SELECT * FROM " + strTblName + " WHERE Co_ID=" + intCompanyID + ";";
    }
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      strStreet = rs.getString(strPrefix + "_StreetAdd");
      strBrgy = rs.getString(strPrefix + "_BrgyAdd");
      strCity = rs.getString(strPrefix + "_CityAdd");
      strProv = rs.getString(strPrefix + "_ProvAdd");
      strZipCode = rs.getString(strPrefix + "_ZipCode");
      strTelArea = rs.getString(strPrefix + "_TelArea");
      strTelNum = rs.getString(strPrefix + "_TelNum");
      strTelLocal = rs.getString(strPrefix + "_TelLocal");
      strFaxArea = rs.getString(strPrefix + "_FaxArea");
      strFaxNum = rs.getString(strPrefix + "_FaxNum");
      strFaxLocal = rs.getString(strPrefix + "_FaxLocal");
      strEMail = rs.getString(strPrefix + "_EMail");
      strWebsite = rs.getString(strPrefix + "_Website");
    }

    SQLstmt = "SELECT CP_User, CP_Others FROM tblCPIndicator WHERE Co_ID=" + intCompanyID +
              " AND Dept_ID=" + bytDeptID  + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      byte bytUserCP = rs.getByte("CP_User");
      bytTotalCP = rs.getByte("CP_Others");
      if (bytUserCP == 1) { // USER IS ONE OF THE MAIN CONTACT PERSONS
        includeUser = true;
      }
    }

    if (includeUser) {
      arrCPFName = new String[bytTotalCP + 1]; // DEFINING ARRAY
      arrCPLName = new String[bytTotalCP + 1];
      arrCPPos   = new String[bytTotalCP + 1];
      arrCPTel   = new String[bytTotalCP + 1];
      arrCPEMail = new String[bytTotalCP + 1];
      SQLstmt = "SELECT Usr_FName, Usr_LName, Usr_TelArea, Usr_TelNum, Usr_TelLocal, " +
                "Usr_EMail FROM tblUserInfo WHERE Usr_ID=" + intUserID + ";";
      rs = users.listQuery(SQLstmt);
      while (rs.next()) {
        arrCPFName[0] = rs.getString("Usr_FName");
        arrCPLName[0] = rs.getString("Usr_LName");
        String strCPTArea = rs.getString("Usr_TelArea");
        String strCPTNum = rs.getString("Usr_TelNum");
        String strCPTLoc = rs.getString("Usr_TelLocal");
        arrCPEMail[0] = rs.getString("Usr_EMail");
        if (strCPTLoc.equals("")) { // FORMATS TEXT OUTPUT OF CONTACT PERSON'S PHONE NUMBER DEPENDING ON DATA
          arrCPTel[0] = "(+63" + strCPTArea + ")" + " " + strCPTNum;
        } else {
          arrCPTel[0] = "(+63" + strCPTArea + ")" + " " + strCPTNum + " loc. " + strCPTLoc;
        }
      }
      idx = 1;
    } else { // USER IS NOT ONE OF THE MAIN CONTACT PERSONS
      arrCPFName = new String[bytTotalCP]; // DEFINING ARRAY
      arrCPLName = new String[bytTotalCP];
      arrCPPos   = new String[bytTotalCP];
      arrCPTel   = new String[bytTotalCP];
      arrCPEMail = new String[bytTotalCP];
    }

    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
      arrCPPos[0]   = rs.getString("Usr_Position");
      strCompanyName = rs.getString("Co_Name");
    }

    SQLstmt = "SELECT * FROM tblContactPersons WHERE Co_ID=" + intCompanyID +
              " AND Dept_ID=" + bytDeptID  + " ORDER BY CP_ID;";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      arrCPFName[idx]   = rs.getString("CP_FirstName");
      arrCPLName[idx]   = rs.getString("CP_LastName");
      arrCPPos[idx]     = rs.getString("CP_Position");
      String strCPTArea = rs.getString("CP_TelArea");
      String strCPTNum  = rs.getString("CP_TelNum");
      String strCPTLoc  = rs.getString("CP_TelLocal");
      arrCPEMail[idx]   = rs.getString("CP_EMail");
      if (strCPTLoc.equals("")) { // FORMATS TEXT OUTPUT OF CONTACT PERSON'S PHONE NUMBER DEPENDING ON DATA
        arrCPTel[idx] = "(+63" + strCPTArea + ")" + " " + strCPTNum;
      } else {
        arrCPTel[idx] = "(+63" + strCPTArea + ")" + " " + strCPTNum + " loc. " + strCPTLoc;
      }
      if (arrCPEMail[idx].equals("")) {
        arrCPEMail[idx] = "none";
      }
      idx++;
    }
    users.disconnect();

    if (arrCPFName.length>1) { // THERE ARE MORE THAN ONE CONTACT PERSON ENTRY
      strCPTitle = "CONTACT PERSONS";
    } else { // CONTACT PERSON COUNT IS ONE
      strCPTitle = "CONTACT PERSON";
    }

    if (strBrgy.equals("")) {
      strBrgy = "none";
    }
    if (strTelLocal.equals("")) { // FORMATS TEXT OUTPUT OF THE COMPANY'S PHONE NUMBER
      strTel = "(+63" + strTelArea + ")" + " " + strTelNum;
    } else {
      strTel = "(+63" + strTelArea + ")" + " " + strTelNum + " loc. " + strTelLocal;
    }
    if (strFaxArea.equals("")) { // FORMATS TEXT OUTPUT OF THE COMPANY'S FAX NUMBER
      strFax = "none";
    } else if (strFaxLocal.equals("")) {
      strFax = "(+63" + strFaxArea + ")" + " " + strFaxNum;
    } else {
      strFax = "(+63" + strFaxArea + ")" + " " + strFaxNum + " loc. " + strFaxLocal;
    }
    if (strEMail.equals("")) {
      strEMail = "none";
    }
    if (strWebsite.equals("")) {
      strWebsite = "none";
    }
    /***** MERGING WITH MAIN HTML CODES STARTS HERE *****/

%>

    <html>
    <head><title> <%= strPageTitle %> </title>
    <jsp:include page="jsf.jsp" flush="true" />
    </head>
    <body onLoad="chkself()" onUnload="javascript:fmReload.checkOut.value='yes';return true;">

    <table border="0" width="100%" align="top">
    <tr>
    <td width="25%" valign="top">
      <jsp:include page="side.jsp" flush="true" />
    <td width="75%">
      <p><b>COMPANY PROFILE</b>
      <br><b>Company:</b> <%= strCompanyName %>
      </p><br>
      <p><b><%= strSubTitle %></b>
      <br><br><b>Street:</b> <%= strStreet %>
      <br><b>Barangay/District:</b> <%= strBrgy %>
      <br><b>Municipality/City:</b> <%= strCity %>
      <br><b>Province:</b> <%= strProv %>
      <br><b>Zip Code:</b> <%= strZipCode %>
      </p><br>
      <p><b>CONTACT NUMBERS</b>
      <br><br><b>Telephone:</b> <%= strTel %>
      <br><b>Facsimile:</b> <%= strFax %>
      <br><b>Company e-mail address:</b> <%= strEMail %>
      <br><b>Company website:</b> <%= strWebsite %>
      </p><br>
      <p><b><%= strCPTitle %></b>

    <% for (int i=0; i<arrCPFName.length; i++) { %>

      <br><br><b>Name:</b> <%= arrCPFName[i] + " " + arrCPLName[i] %>
      <br><b>Position:</b> <%= arrCPPos[i] %>
      <br><b>Telephone:</b> <%= arrCPTel[i] %>
      <br><b>e-mail:</b> <%= arrCPEMail[i] %>

    <% } %>

      </p>
      <p><input type="button" name="btEdit" value="Edit" onClick="javascript:location.replace('ofcedit.jsp?uid=<%=
          intUserID %>&cid=<%= intCompanyID %>&did=<%= bytDeptID %>')">

    <% if (bytDeptID != 1) { %>

      <script language="javascript">
      <!--

      function veriDel() {
        ans = confirm("All <%= strPageTitle %> details\nwould be deleted!! \nContinue?");
        if (ans==true) {
          location='delofc.jsp?uid=<%= intUserID %>&cid=<%= intCompanyID %>&did=<%= bytDeptID %>&ctr=100';
        } else {
        }
      }

      -->
      </script>
      <input type="button" name="btDel" value="Delete" onClick="veriDel()">

    <% } %>

      <input type="button" name="btOut" value="Log Out" onClick="logOut()">      </p>
      <jsp:include page="btn.jsp" flush="true" />
    </tr>
    </table>
    <form name="fmReload">
      <input type="hidden" name="checkOut" value="no">
      <input type="hidden" name="x" value="true">
    </form>

    </body>
    </html>

  <% } // END OF LOG CHECK %>