<%@ 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 strType = "", strBDName = "", strCompanyName ="";
  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 = "", strBtnName = "";
  String [] arrCPFName, arrCPLName, arrCPPos, arrCPTel, arrCPEMail;
  String strTblName = "", strTypeTbl = "", strPrefix = "", strPageTitle = "", strSubTitle = "";
  byte bytLogStatus = 0, bytTotalCP = 0, idx = 0;
  int intID = 0; // USE TO INDICATE IF TABLE IS EMPTY OF BRANCH/DOWNLINE OF A PARTICULAR COMPANY

  int intUserID    = Integer.parseInt(request.getParameter("uid"));
  int intCompanyID = Integer.parseInt(request.getParameter("cid"));
  int intBDID      = Integer.parseInt(request.getParameter("bid"));
  byte bytDeptID   = Byte.parseByte(request.getParameter("did"));

  /***** END OF VARIABLE DECLARATION *****/

  switch (bytDeptID) {
    case 8:
      strTblName    = "tblBranches";
      strTypeTbl    = "tblBrTypeDefn";
      strPrefix     = "Br";
      strPageTitle  = "Branch";
      strSubTitle   = "BRANCH"; 
      strBtnName    = "Add Branch";
      break;
    case 9:
      strTblName    = "tblDownlines";
      strTypeTbl    = "tblDLTypeDefn";
      strPrefix     = "DL";
      strPageTitle  = "Downline";
      strSubTitle   = "DOWNLINE";
      strBtnName    = "Add Downline";
  }


  String SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";";
  users.connect(strMainDB);
  ResultSet rs = users.listQuery(SQLstmt);
  while (rs.next()) {
    bytLogStatus = rs.getByte("LogOnStatus");
  }
  SQLstmt = "SELECT * FROM " + strTblName + " WHERE Co_ID=" + intCompanyID + ";";
  rs = users.listQuery(SQLstmt);
  while (rs.next()) {
    intID = rs.getInt(strPrefix + "_ID");
  }

  if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE
%>
    <jsp:include page="getindex.jsp" flush="true"/>
<%
  } else if (intID==0) {
%>
    <jsp:forward page="ofcmain.jsp" />
<%
  } else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE


    SQLstmt = "SELECT * FROM " + strTblName + " WHERE Co_ID=" + intCompanyID + " AND " + strPrefix +
              "_ID=" + intBDID + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      strType = rs.getString(strPrefix + "_Type");
      strBDName = rs.getString(strPrefix + "_Name");
      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 TypeDefn FROM " + strTypeTbl + " WHERE Type_ID=" + strType + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      strType = rs.getString("TypeDefn");
    }
    SQLstmt = "SELECT BDCP_User, BDCP_Others FROM tblBDCPIndicator WHERE Co_ID=" + intCompanyID +
              " AND BDCP_ID=" + intBDID + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      byte bytUserCP = rs.getByte("BDCP_User");
      bytTotalCP = rs.getByte("BDCP_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 BDCP_FirstN, BDCP_LastN, BDCP_Position, BDCP_TelArea, BDCP_TelNum, " +
              "BDCP_TelLocal, BDCP_EMail FROM tblBDCP WHERE Co_ID=" + intCompanyID +
              " AND BDCP_ID=" + intBDID + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      arrCPFName[idx]   = rs.getString("BDCP_FirstN");
      arrCPLName[idx]   = rs.getString("BDCP_LastN");
      arrCPPos[idx]     = rs.getString("BDCP_Position");
      String strCPTArea = rs.getString("BDCP_TelArea");
      String strCPTNum  = rs.getString("BDCP_TelNum");
      String strCPTLoc  = rs.getString("BDCP_TelLocal");
      arrCPEMail[idx]   = rs.getString("BDCP_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()">

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

    function veriDel(bdid, bdname) {
      ans = confirm("All info about\n" + bdname + "\nwould be deleted!! \nContinue?");
      if (ans==true) {
        location='delbd.jsp?uid=<%= intUserID %>&bid=' + bdid +
                 '&cid=<%= intCompanyID %>&did=<%= bytDeptID %>&ctr=100';
      } else {
      }
    }

    -->
    </script>

    <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><%= strSubTitle %> PROFILE</b>
      <br><b><%= strPageTitle %>:</b> <%= strBDName %>
      <br><b>Type:</b> <%= strType %>
      </p><br>
      <p><b><%= strSubTitle %> OFFICE ADDRESS</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('bdedit.jsp?uid=<%=
          intUserID %>&bid=<%= intBDID %>&cid=<%= intCompanyID %>&did=<%= bytDeptID %>')">
      <input type="button" name="btDel" value="Delete" onClick="veriDel('<%= intBDID %>','<%= strBDName %>')">
      <input type="button" name="btAdd" value="<%= strBtnName %>" onClick="javascript:location.replace('bdadd.jsp?uid=<%=
          intUserID %>&bid=0&cid=<%= intCompanyID %>&did=<%= bytDeptID %>')">
      <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 %>