<%@ 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 withError = false, includeUser = false;
  String strMainDB = "product_pgpClientInfoDB";
  String strBDCPTbl = "tblBDCP";
  String strBDCPIndicatorTbl = "tblBDCPIndicator";
  String strType = "", strBDName = "";
  String strStreet = "", strBrgy = "", strCity = "", strProv = "", strZipCode = "";
  String strTelArea = "", strTelNum = "", strTelLocal = "";
  String strFaxArea = "", strFaxNum = "", strFaxLocal = "";
  String strWebsite = "", strEMail = "", strCompanyName = "", strCheckBox = "";
  String [] arrCPFName, arrCPLName, arrCPPos, arrCPTArea, arrCPTNum, arrCPTLoc, arrCPEMail;
  String strTblName = "", strTmpTbl = "", strPrefix = "", strPageTitle = "", strSubTitle = "", strPlural = "";
  String strPageID = ""; // USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
  String strCheckOut = "no"; // SWITCHES PAGE TO VIEW MODE AFTER SUBMIT IS OK, MEANING NO ERROR
  byte idx = 0, ctr = 0;

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

  switch (bytDeptID) {
    case 8:
      strTblName   = "tblBranches";
      strTmpTbl    = "tmpTblBranches"; 
      strPrefix    = "Br";
      strPageTitle = "Branch";
      strPlural    = "Branches";
      strSubTitle  = "BRANCH INFORMATION";
      strPageID    = "membdaddj8";
      break;
    case 9:
      strTblName   = "tblDownlines";
      strTmpTbl    = "tmpTblDownlines";
      strPrefix    = "DL";
      strPageTitle = "Downline";
      strPlural    = "Downlines";
      strSubTitle  = "DOWNLINE INFORMATION";
      strPageID    = "membdaddj9";
  }

  arrCPFName = new String[3]; // DEFINING ARRAY
  arrCPLName = new String[3];
  arrCPPos   = new String[3];
  arrCPTArea = new String[3];
  arrCPTNum  = new String[3];
  arrCPTLoc  = new String[3];
  arrCPEMail = new String[3];

  for (int i=0; i<3; i++) {
    arrCPFName[i] = ""; // INITIALIZING ARRAY AS EMPTY STRING
    arrCPLName[i] = "";
    arrCPPos[i]   = "";
    arrCPTArea[i] = "";
    arrCPTNum[i]  = "";
    arrCPTLoc[i]  = "";
    arrCPEMail[i] = "";
  }

  /***** 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
%>
    <jsp:include page="getindex.jsp" flush="true"/>
<%
  } 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) {
      withError = true;
      strTblName = strTmpTbl;
      strBDCPTbl = "tmpTblBDCP";
      strBDCPIndicatorTbl = "tmpTblBDCPIndicator";
      if (intBDID==0) {
        if (bytDeptID == 8) {
          SQLstmt = "SELECT MAX(BDCP_ID) AS BDCP_ID FROM tblBDCPIndicator WHERE " +
                    "BDCP_ID<900000 AND Co_ID = " + intCompanyID + ";";
        } else {
          SQLstmt = "SELECT MAX(BDCP_ID) AS BDCP_ID FROM tblBDCPIndicator WHERE " +
                    "BDCP_ID>=900000 AND Co_ID = " + intCompanyID + ";";
        }
        rs = users.listQuery(SQLstmt);
        while (rs.next()) {
          intBDID = rs.getInt("BDCP_ID");
          if (strSubTitle.equals("ok")) {
          } else {
            intBDID++;
          }
        }
        if (intBDID==0) {
          if (bytDeptID == 8) {
            intBDID = 800000;
          } else {
            intBDID = 900000;
          }
        }
      } // END OF if (intBDID==0)
    }
    SQLstmt = "DELETE FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
              " AND Page_ID='" + strPageID + "';";
    users.updateData(SQLstmt);
    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 BDCP_User, BDCP_Others FROM " + strBDCPIndicatorTbl + " WHERE Co_ID=" + intCompanyID +
              " AND BDCP_ID=" + intBDID + ";";
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      byte bytUserCP = rs.getByte("BDCP_User");
      if (bytUserCP == 1) { // USER IS ONE OF THE MAIN CONTACT PERSONS
        includeUser = true;
      }
    }

    if (includeUser) {
      strCheckBox = "checked";
    }

    SQLstmt = "SELECT * FROM " + strBDCPTbl + " WHERE Co_ID=" + intCompanyID +
              " AND BDCP_ID=" + intBDID + " ORDER BY CP_ID;";
    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");
      arrCPTArea[idx]   = rs.getString("BDCP_TelArea");
      arrCPTNum[idx]    = rs.getString("BDCP_TelNum");
      arrCPTLoc[idx]    = rs.getString("BDCP_TelLocal");
      arrCPEMail[idx]   = rs.getString("BDCP_EMail");

      idx++;
    }
    users.disconnect();
    if (strSubTitle.equals("ok")) {
      strCheckOut = "view";
      strSubTitle = "Update Successful...";
    }

  /***** MERGING WITH MAIN HTML CODES STARTS HERE *****/
%>

    <html>
    <head><title> ADD - <%= strPageTitle %> </title>
    <script language="javascript">
    <!--
    function selectDefault() {
      for (var i=0; i<fmBDAdd.Prov.length; i++) {
        if (fmBDAdd.Prov.options[i].text == '<%= strProv %>') {
          fmBDAdd.Prov.options[i].selected = true;
          break;
        }
      }
      for (var i=0; i<fmBDAdd.Type.length; i++) {
        if (fmBDAdd.Type.options[i].value == '<%= strType %>') {
          fmBDAdd.Type.options[i].selected = true;
          break;
        }
      }
    }
    function chkself() {
      if (fmReload.checkOut.value=='view') {
        location.replace('bdmain.jsp?uid=<%= intUserID %>&cid=<%= intCompanyID %>&did=<%= bytDeptID %>');
      } else if (fmReload.checkOut.value=='yes') {
        location.reload();
      } else {
        fmReload.checkOut.value='yes';
        selectDefault();
        fmBDAdd.BDName.focus();
      }
    }
    function checkCode() {
      str1 = "" + fmBDAdd.TArea.value;
      str = "0";
      ctr = 0;
      while (str=="0") {
        str = str1.substring(ctr,ctr+1);
        ctr++;
      }
      if (ctr==str1.length) {
        str1 = str1.substring(ctr-1,ctr);
      } else {
        str1 = str1.substring(ctr-1,ctr+1);
      }
      if (str1=="") {
      } else if (fmBDAdd.Prov.value=="000") {
        alert ("You have NOT selected a province.");
      } else {
        str2 = fmBDAdd.Prov.value;
        str3 = str2.substring(2,str2.length); // NAME OF PROVINCE
        str2 = str2.substring(0,2);
        if (str2.substring(0,1)=="0") {
          str2 = str2.substring(1,2);
          str1 = str1.substring(0,1);
        }
        if (str1!=str2) {
          alert("Telephone Area code for province " + str3 + " should be " + str2 +
                "\nor for exceptional areas of the province, start with this number.\n" +
                "\nIf you made a mistake, please correct it now.");
        }
      }
    }
    function logOut() {
      fmReload.checkOut.value='yes';
      location='logout.jsp?uid=<%= intUserID %>&ctr=100';
    }
    -->
    </script>
    </head>
    <body onLoad="chkself()">

    <form name="fmBDAdd" action="addbd.jsp" method="post">

      <p><b>COMPANY PROFILE</b>
      <br><b>Company:</b> <%= strCompanyName %>
      </p><br>
      <p><b><%= strSubTitle %></b><br>

      <% if (bytDeptID == 8) { %>

        <br><b>Branch Name or Title**:</b>
        <input type="text" name="BDName" maxlength="35" size="42"
          onMouseOver="window.status='Enter branch name up to 35 characters long.'"
          onMouseOut="window.status=''" value="<%= strBDName %>">
        <br><b>Type of Branch**:</b>
        <select name="Type"
          onMouseOver="window.status='Select type of branch from the list'"
          onMouseOut="window.status=''" >
          <option value="0"> - Please Select One - </option>
          <option value="1">Administration</option>
          <option value="2">Sales</option>
          <option value="3">Showroom</option>
          <option value="4">Plant/Warehouse</option>
          <option value="5">Technical Service</option>
          <option value="10">Others</option>
        </select>

      <% } else { %>

        <br><b>Downline/Company Name**:</b>
        <input type="text" name="BDName" maxlength="35" size="42"
          onMouseOver="window.status='Enter downline name up to 35 characters long.'"
          onMouseOut="window.status=''" value="<%= strBDName %>">
        <br><b>Type of Downline**:</b>
        <select name="Type"
          onMouseOver="window.status='Select type of downline from the list'"
          onMouseOut="window.status=''" >
          <option value="0"> - Please Select One - </option>
          <option value="1">Producer/Manufacturer</option>
          <option value="2">Licensee</option>
          <option value="3">Importer</option>
          <option value="4">Exporter</option>
          <option value="5">Distributor</option>
          <option value="6">Dealer</option>
          <option value="7">Wholesaler</option>
          <option value="8">Retailer</option>
        </select>

       <% } %>

        <br><b>Street**:</b>
        <input type="text" name="St" maxlength="25" size="30"
          onMouseOver="window.status='Enter street up to 25 characters long.'"
          onMouseOut="window.status=''" value="<%= strStreet %>">
        <b>Barangay/District:</b>
        <input type="text" name="Brgy" maxlength="25" size="30"
          onMouseOver="window.status='Enter barangay up to 25 characters long.'"
          onMouseOut="window.status=''" value="<%= strBrgy %>">
        <br><b>Municipality/City**:</b>
        <input type="text" name="City" maxlength="25" size="30"
          onMouseOver="window.status='Enter municipality/city up to 25 characters long.'"
          onMouseOut="window.status=''" value="<%= strCity %>">
        <b>Province**:</b>

        <select name="Prov"
          onMouseOver="window.status='Select province from the list'"
          onMouseOut="window.status=''" onChange="checkCode()">
          <option value="000"> - Please Select One - </option>
          <option value="02Metro Manila">Metro Manila</option>
          <option value="74Abra">Abra</option>
          <option value="85Agusan del Norte">Agusan del Norte</option>
          <option value="85Agusan del Sur">Agusan del Sur</option>
          <option value="36Aklan">Aklan</option>
          <option value="52Albay">Albay</option>
          <option value="36Antique">Antique</option>
          <option value="42Aurora">Aurora</option>
          <option value="62Basilan">Basilan</option>
          <option value="47Bataan">Bataan</option>
          <option value="78Batanes">Batanes</option>
          <option value="43Batangas">Batangas</option>
          <option value="74Benguet">Benguet</option>
          <option value="53Biliran">Biliran</option>
          <option value="38Bohol">Bohol</option>
          <option value="88Bukidnon">Bukidnon</option>
          <option value="44Bulacan">Bulacan</option>
          <option value="78Cagayan">Cagayan</option>
          <option value="54Camarines Norte">Camarines Norte</option>
          <option value="54Camarines Sur">Camarines Sur</option>
          <option value="88Camiguin">Camiguin</option>
          <option value="36Capiz">Capiz</option>
          <option value="52Catanduanes">Catanduanes</option>
          <option value="46Cavite">Cavite</option>
          <option value="32Cebu">Cebu</option>
          <option value="82Davao">Davao</option>
          <option value="84Davao del Norte">Davao del Norte</option>
          <option value="82Davao del Sur">Davao del Sur</option>
          <option value="87Davao Oriental">Davao Oriental</option>
          <option value="55Eastern Samar">Eastern Samar</option>
          <option value="33Guimaras">Guimaras</option>
          <option value="74Ifugao">Ifugao</option>
          <option value="77Ilocos Norte">Ilocos Norte</option>
          <option value="77Ilocos Sur">Ilocos Sur</option>
          <option value="33Iloilo">Iloilo</option>
          <option value="78Isabela">Isabela</option>
          <option value="74Kalinga-Apayao">Kalinga-Apayao</option>
          <option value="72La Union">La Union</option>
          <option value="49Laguna">Laguna</option>
          <option value="63Lanao del Norte">Lanao del Norte</option>
          <option value="63Lanao del Sur">Lanao del Sur</option>
          <option value="53Leyte">Leyte</option>
          <option value="64Maguindanao">Maguindanao</option>
          <option value="42Marinduque">Marinduque</option>
          <option value="56Masbate">Masbate</option>
          <option value="43Mindoro Occidental">Mindoro Occidental</option>
          <option value="43Mindoro Oriental">Mindoro Oriental</option>
          <option value="88Misamis Occidental">Misamis Occidental</option>
          <option value="88Misamis Oriental">Misamis Oriental</option>
          <option value="74Mountain Province">Mountain Province</option>
          <option value="02NCR">NCR</option>
          <option value="34Negros Occidental">Negros Occidental</option>
          <option value="35Negros Oriental">Negros Oriental</option>
          <option value="64North Cotabato">North Cotabato</option>
          <option value="44Nueva Ecija">Nueva Ecija</option>
          <option value="78Nueva Vizcaya">Nueva Vizcaya</option>
          <option value="48Palawan">Palawan</option>
          <option value="45Pampanga">Pampanga</option>
          <option value="75Pangasinan">Pangasinan</option>
          <option value="42Quezon">Quezon</option>
          <option value="78Quirino">Quirino</option>
          <option value="02Rizal">Rizal</option>
          <option value="42Romblon">Romblon</option>
          <option value="83Saranggani">Saranggani</option>
          <option value="35Siquijor">Siquijor</option>
          <option value="56Sorsogon">Sorsogon</option>
          <option value="83South Cotabato">South Cotabato</option>
          <option value="64Sultan Kudarat">Sultan Kudarat</option>
          <option value="86Surigao del Norte">Surigao del Norte</option>
          <option value="86Surigao del Sur">Surigao del Sur</option>
          <option value="45Tarlac">Tarlac</option>
          <option value="55Western Samar">Western Samar</option>
          <option value="47Zambales">Zambales</option>
          <option value="65Zamboanga del Norte">Zamboanga del Norte</option>
          <option value="62Zamboanga del Sur">Zamboanga del Sur</option>
        </select>

        <br><b>Zip Code**:</b>
        <input type="text" name="ZCode" maxlength="4" size="4"
          onMouseOver="window.status='Enter zip code.'"
          onMouseOut="window.status=''" value="<%= strZipCode %>">
        </p>

        <p><b>CONTACT NUMBERS</b><br>
        <br><b>Telephone: area code**</b>
        <input type="text" name="TArea" maxlength="5" size="4"
          onMouseOver="window.status='Enter phone\'s area code.'"
          onMouseOut="window.status=''" onChange="checkCode()" value="<%= strTelArea %>">
        <b>phone number**</b>
        <input type="text" name="TNum" maxlength="7" size="7"
          onMouseOver="window.status='Enter phone number.'"
          onMouseOut="window.status=''" value="<%= strTelNum %>">
        <b>local number</b>
        <input type="text" name="TLoc" maxlength="5" size="4"
          onMouseOver="window.status='Enter phone\'s local number.'"
          onMouseOut="window.status=''" value="<%= strTelLocal %>">
        <br><b>Facsimile: area code</b>
        <input type="text" name="FArea" maxlength="5" size="4"
          onMouseOver="window.status='Enter area code for fax.'"
          onMouseOut="window.status=''" value="<%= strFaxArea %>">
        <b>fax number</b>
        <input type="text" name="FNum" maxlength="7" size="7"
          onMouseOver="window.status='Enter fax number.'"
          onMouseOut="window.status=''" value="<%= strFaxNum %>">
        <b>fax local</b>
        <input type="text" name="FLoc" maxlength="5" size="4"
          onMouseOver="window.status='Enter local number if any.'"
          onMouseOut="window.status=''" value="<%= strFaxLocal %>">
        <br><b>Company email address:</b>
        <input type="text" name="EMail" maxlength="30" size="36"
          onMouseOver="window.status='Enter sales ofc e-mail address.'"
          onMouseOut="window.status=''" value="<%= strEMail %>">
        <br><b>Company website:</b>
        <input type="text" name="WSite" maxlength="30" size="36"
          onMouseOver="window.status='Enter sales ofc website address if any.'"
          onMouseOut="window.status=''" value="<%= strWebsite %>">
        </p>

        <p>
        <b>CONTACT PERSONS**</b>
        <br><i>(Please supply complete information to at least one contact person.)</i>
        </p>
        <p><input type="checkbox" name="cpUsr" value="Yes" <%= strCheckBox %>>
        <b>Check this box if you are one of the main contact persons for sales office.</b>
        </p>

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

        <p><b>Contact Person <%= (i+1) %>:</b>
        <br><b>First name*: </b>
        <input type="text" name="cp<%= (i+1) %>FN" maxlength="20" size="24"
          onMouseOver="window.status='Enter first name up to 20 characters long.'"
          onMouseOut="window.status=''" value="<%= arrCPFName[i] %>">
        <b>Last name*: </b>
        <input type="text" name="cp<%= (i+1) %>LN" maxlength="20" size="24"
          onMouseOver="window.status='Enter last name up to 20 characters long.'"
          onMouseOut="window.status=''" value="<%= arrCPLName[i] %>">
        <br><b>Position*: </b>
        <input type="text" name="cp<%= (i+1) %>Pos" maxlength="30" size="36"
          onMouseOver="window.status='Enter position in the company up to 30 characters long.'"
          onMouseOut="window.status=''" value="<%= arrCPPos[i] %>">
        <br><b>Telephone: </b>
        <b>area code* </b>
        <input type="text" name="cp<%= (i+1) %>TArea" maxlength="5" size="4"
          onMouseOver="window.status='Enter area code of phone number.'"
          onMouseOut="window.status=''" value="<%= arrCPTArea[i] %>">
        <b>phone number* </b>
        <input type="text" name="cp<%= (i+1) %>TNum" maxlength="7" size="7"
          onMouseOver="window.status='Enter phone number.'"
          onMouseOut="window.status=''" value="<%= arrCPTNum[i] %>">
        <b>local number </b>
        <input type="text" name="cp<%= (i+1) %>TLoc" maxlength="5" size="4"
          onMouseOver="window.status='Enter phone\'s local number.'"
          onMouseOut="window.status=''" value="<%= arrCPTLoc[i] %>">
        <br><b>e-mail address: </b>
        <input type="text" name="cp<%= (i+1) %>EMail" maxlength="30" size="36"
          onMouseOver="window.status='Enter e-mail address up to 30 characters long.'"
          onMouseOut="window.status=''" value="<%= arrCPEMail[i] %>">
        </p>
    <% } %>

      <input type="hidden" name="uid" value="<%= intUserID %>" >
      <input type="hidden" name="bid" value="<%= intBDID %>" >
      <input type="hidden" name="cid" value="<%= intCompanyID %>" >
      <input type="hidden" name="did" value="<%= bytDeptID %>" >
      <input type="hidden" name="view" value="no" >

      <input type="submit" name="btMore" value="Add More/Submit" onClick="">
      <input type="button" name="btDone" value="Done/Submit" onClick="javascript:fmBDAdd.view.value='go';fmBDAdd.submit()">
    <% if (withError) { %>
      <input type="button" name="btCancel" value="Cancel Changes"
      onClick="javascript:location='bdblank.jsp?uid=<%= intUserID %>&bid=<%= intBDID %>&cid=<%=
      intCompanyID %>&did=<%= bytDeptID %>&ctr=100'">
    <% } %>
      <p><input type="button" name="btCancel" value="Cancel/View All <%= strPlural %>" onClick="javascript:
      location.replace('bdmain.jsp?uid=<%= intUserID %>&cid=<%= intCompanyID %>&did=<%=
      bytDeptID %>')">
      <input type="button" name="btOut" value="Log Out" onClick="logOut()">
      </p>
    </form>
    <form name="fmReload">
      <input type="hidden" name="checkOut" value="<%= strCheckOut %>">
      <input type="hidden" name="x" value="true">
    </form>

    </body>
    </html>

  <% } // END OF LOG CHECK %>