<%@ 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 strOfcCPTbl = "tblContactPersons";
  String strCPIndicatorTbl = "tblCPIndicator";
  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 = "", strCompanyName = "", strCheckBox = "";
  String [] arrCPFName, arrCPLName, arrCPPos, arrCPTArea, arrCPTNum, arrCPTLoc, arrCPEMail;
  String strTblName = "", strTmpTbl = "", strPrefix = "", strPageTitle = "", strSubTitle = "";
  String strPageID = ""; // USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
  String strCheckOut = "no"; // TRAFFIC ENFORCER OF THIS PAGE
  byte idx = 0, ctr = 0;

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

  switch (bytDeptID) {
    case 1:
      strTblName   = "tblCoHeadOfc";
      strTmpTbl    = "tmpTblCoHeadOfc"; 
      strPrefix    = "CoHO";
      strPageTitle = "Head Office";
      strSubTitle  = "HEAD OFFICE ADDRESS";
      strPageID    = "memofcedj1";
      break;
    case 2:
      strTblName   = "tblSalesOfc";
      strTmpTbl    = "tmpTblSalesOfc";
      strPrefix    = "SOfc";
      strPageTitle = "Sales Office";
      strSubTitle  = "SALES OFFICE ADDRESS";
      strPageID    = "memofcedj2";
      break;
    case 3:
      strTblName   = "tblShowRm";
      strTmpTbl    = "tmpTblShowRm";
      strPrefix    = "SRm";
      strPageTitle = "Showroom";
      strSubTitle  = "SHOWROOM ADDRESS";
      strPageID    = "memofcedj3";
      break;
    case 4:
      strTblName   = "tblWareHse";
      strTmpTbl    = "tmpTblWareHse";
      strPrefix    = "WHse";
      strPageTitle = "Plant/Warehouse";
      strSubTitle  = "PLANT OR WAREHOUSE ADDRESS";
      strPageID    = "memofcedj4";
      break;
    case 5:
      strTblName   = "tblTechSvc";
      strTmpTbl    = "tmpTblTechSvc";
      strPrefix    = "TSvc";
      strPageTitle = "Technical Services Office";
      strSubTitle  = "TECHNICAL SERVICES OFFICE ADDRESS";
      strPageID    = "memofcedj5";
      break;
    case 10:
      strTblName   = "tblForeignOfc";
      strTmpTbl    = "tmpTblForeignOfc";
      strPrefix    = "FOfc";
      strPageTitle = "Foreign Office Information";
      strSubTitle  = "FOREIGN OFFICE ADDRESS";
      strPageID    = "memofcedj0";
  }

  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;
      strOfcCPTbl = "tmpTblContactPersons";
      strCPIndicatorTbl = "tmpTblCPIndicator";
    }
    SQLstmt = "DELETE FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
              " AND Page_ID='" + strPageID + "';";
    users.updateData(SQLstmt);
    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");
    }

    if (strTelArea.equals("0")) {
      strTelArea = "";
    }
    if (strTelNum.equals("0")) {
      strTelNum = "";
    }
    if (strTelLocal.equals("0")) {
      strTelLocal = "";
    }
    if (strFaxArea.equals("0")) {
      strFaxArea = "";
    }
    if (strFaxNum.equals("0")) {
      strFaxNum = "";
    }
    if (strFaxLocal.equals("0")) {
      strFaxLocal = "";
    }

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

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

    SQLstmt = "SELECT * FROM " + strOfcCPTbl + " 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");
      arrCPTArea[idx]   = rs.getString("CP_TelArea");
      arrCPTNum[idx]    = rs.getString("CP_TelNum");
      arrCPTLoc[idx]    = rs.getString("CP_TelLocal");
      arrCPEMail[idx]   = rs.getString("CP_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 selectProv() {
      for (var i=0; i<fmOfcAdd.Prov.length; i++) {
        if (fmOfcAdd.Prov.options[i].text == '<%= strProv %>') {
          fmOfcAdd.Prov.options[i].selected = true;
          break;
        }
      }
    }
    function chkself() {
      if (fmReload.checkOut.value=='view') {
        location.replace('ofcmain.jsp?uid=<%= intUserID %>&cid=<%= intCompanyID %>&did=<%= bytDeptID %>');
      } else if (fmReload.checkOut.value=='yes') {
        location.reload();
      } else {
        fmReload.checkOut.value='yes';
        selectProv();
        fmOfcAdd.St.focus();
      }
    }
    function checkCode() {
      str1 = "" + fmOfcAdd.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 (fmOfcAdd.Prov.value=="000") {
        alert ("You have NOT selected a province.");
      } else {
        str2 = fmOfcAdd.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="fmOfcAdd" action="editofc.jsp" method="post">

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

        <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 <%= strPageTitle %>.</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="cid" value="<%= intCompanyID %>" >
      <input type="hidden" name="did" value="<%= bytDeptID %>" >

      <input type="submit" name="btSubmit" value="Submit Changes" onClick="">
    <% if (withError) { %>
      <input type="button" name="btCancel" value="Cancel Changes"
      onClick="javascript:location='ofcreset.jsp?uid=<%= intUserID %>&cid=<%=
      intCompanyID %>&did=<%= bytDeptID %>&ctr=100'">
    <% } %>
      <p><input type="button" name="btCancel" value="Cancel Add" onClick="javascript:
      location.replace('ofcmain.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 %>