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

  String strMainDB = "product_pgpClientInfoDB";
  String strTblName = ""; // DETERMINES WHICH TABLE TO USE DEPENDING ON VALUE OF bytBtnID
  String strPageTitle = "", strSubTitle = "", strIDName = "", strFieldName = "";
  String strCompanyName = "", strSQLSort = "", strSortBtn = "", strPrevBtn = "", strNextBtn = "";
  String [] arrBPName, arrBPID; // CONTAINER FOR BRANDS/PRODUCTS NAMES AND ID'S
  int ctr = 0, total = 0; // USE FOR COUNTING TOTAL NUMBER OF BRANDS/PRODUCTS
  int batchModifier = 5; // IF EQUAL TO UNITS OF LAST BATCH, IT'LL BE COMBINED WITH SECOND TO LAST BATCH
  int batchMaxUnit = 20; // MAXIMUM NUMBER OF BRANDS/PRODUCTS THAT WOULD BE DISPLAYED PER PAGE

  int intUserID    = Integer.parseInt(request.getParameter("uid"));
  int intCompanyID = Integer.parseInt(request.getParameter("cid"));
  byte bytBtnID    = Byte.parseByte(request.getParameter("did"));
  String strSort   = request.getParameter("srt");
  int intBegPoint  = Integer.parseInt(request.getParameter("p1"));
  int intEndPoint  = Integer.parseInt(request.getParameter("p2"));

  /***** 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");
    }
    switch (bytBtnID) {
      case 6:
        strTblName   = "tblBrands";
        strIDName    = "Brand_ID";
        strFieldName = "BrandName";
        strPageTitle = "Delete - Brands";
        strSubTitle  = "SELECT BRAND NAME TO BE DELETED";
        break;
      case 7:
        strTblName   = "tblProducts";
        strIDName    = "Prod_ID";
        strFieldName = "Product";
        strPageTitle = "Delete - Products";
        strSubTitle  = "SELECT PRODUCT NAME TO BE DELETED";
    }
    strSort = "0"; // DEACTIVATES ALPHABETICAL SORTING
    if (strSort.equals("a")) {
      strSQLSort = " ORDER BY " + strFieldName + ";";
      strSortBtn = "<input type=\"button\" name=\"btSrt\" value=\"Sort\" " +
                   "onClick=\"javascript:location.replace('bpdel.jsp?uid=" + intUserID +
                   "&cid=" + intCompanyID + "&did=" + bytBtnID + "&srt=0&p1=0&p2=" + batchMaxUnit + "')\">";
    } else {
      if (bytBtnID==6) {
        strSQLSort = " ORDER BY Brand_ID;";
      } else {
        strSQLSort = " ORDER BY Prod_ID;";
      }
      strSortBtn = "<input type=\"button\" name=\"btSrt\" value=\"Sort\" " +
                   "onClick=\"javascript:location.replace('bpdel.jsp?uid=" + intUserID +
                   "&cid=" + intCompanyID + "&did=" + bytBtnID + "&srt=a&p1=0&p2=" + batchMaxUnit + "')\">";
    }
    SQLstmt = "SELECT " + strIDName + ", " + strFieldName + " FROM " + strTblName +
              " WHERE Co_ID=" + intCompanyID + strSQLSort;
    rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      ctr++; // COUNTS TOTAL NUMBER OF BRANDS/PRODUCTS
    }
    total = ctr;
    if (intEndPoint > ctr) { // TOTAL BRANDS/PRODUCTS TO BE DISPLAYED IS LESS THAN MAXIMUM
      arrBPName = new String[(ctr-intBegPoint)];
      arrBPID   = new String[(ctr-intBegPoint)];
    } else {
      if ((ctr-intEndPoint) <= batchModifier) {
        arrBPName = new String[ctr-intBegPoint];
        arrBPID   = new String[ctr-intBegPoint];
      } else {
        arrBPName = new String[(intEndPoint-intBegPoint)];
        arrBPID   = new String[(intEndPoint-intBegPoint)];
      }
    }
    if (intBegPoint==0) { // NO PREVIOUS DATA TO DISPLAY
      strPrevBtn = "<input type=\"button\" name=\"btPrev\" value=\"Previous\" disabled onClick=\"\">";
    } else { // PREVIOUS BUTTON IS ACTIVATED
      strPrevBtn = "<input type=\"button\" name=\"btPrev\" value=\"Previous\" onClick=\"javascript:location." +
                   "replace('bpdel.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=" + bytBtnID +
                   "&srt=" + strSort + "&p1=" + (intBegPoint - batchMaxUnit) + "&p2=" +
                   (intEndPoint - batchMaxUnit) + "')\">";
    }
    if (intEndPoint > (ctr-batchModifier)) { // NO REMAINING DATA CAN BE DISPLAYED
      strNextBtn = "<input type=\"button\" name=\"btNext\" value=\"Next\" disabled onClick=\"\">";
    } else { // NEXT BUTTON IS ACTIVATED
      strNextBtn = "<input type=\"button\" name=\"btNext\" value=\"Next\" onClick=\"javascript:location." +
                   "replace('bpdel.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=" + bytBtnID +
                   "&srt=" + strSort + "&p1=" + (intBegPoint + batchMaxUnit) + "&p2=" +
                   (intEndPoint + batchMaxUnit) + "')\">";
    }
    if (intBegPoint==0) { // SINCE RESULTSET METHOD ABSOLUTE DOES NOT WORK WITH VALUE EQUAL TO ZERO
      rs.beforeFirst();
    } else {
      rs.absolute(intBegPoint);
    }
    ctr = 0;
    while (rs.next()) {
      arrBPName[ctr] = rs.getString(strFieldName);
      arrBPID[ctr]   = rs.getString(strIDName);
      ctr++;
      if (ctr==(arrBPName.length)) {
        break;
      }
    }

  /***** MERGING WITH MAIN HTML CODES STARTS HERE *****/
%>
    <html>
    <head><title> <%= strPageTitle %> </title>
    <script language="javascript">
    <!--
    function chkself() {
      if (fmReload.checkOut.value=='yes') {
        location.reload();
      } else {
        fmReload.checkOut.value='yes';
      }
    }
    function logOut() {
      fmReload.checkOut.value='yes';
      location='logout.jsp?uid=<%= intUserID %>&ctr=100';
    }
    -->
    </script>
    </head>
    <body onLoad="chkself()">

    <table border="0">
    <tr>
    <td width="0%" valign="top">
    <td width="100%">
      <p><b>COMPANY PROFILE</b>
      <br><b>Company:</b> <%= strCompanyName %>
      </p><br>
      <p><b><%= strSubTitle %></b>
      </p>
    <form name="fmBPDel" action="sumdelbp.jsp" method="post">
    <% for (int i=0; i<ctr; i++) { %>
      <% if (ctr == 1) { %>

        <input type="checkbox" name="id" value="<%= arrBPID[i] %>"> <%= arrBPName[i] %>

      <% } else { %>

        <input type="checkbox" name="id" value="<%= arrBPID[i] %>"> <%= arrBPName[i] %>

      <% } %>
      <% if ((i+1)==ctr && ctr != 1) { %>

        <p>showing <%= intBegPoint + 1 %>-<%= intBegPoint + ctr %> of <%= total %>
        </p>

      <% } else { %>

        <br>

      <% } %>
    <% } %>
      <input type="hidden" name="id" value="0" >
      <input type="hidden" name="uid" value="<%= intUserID %>" >
      <input type="hidden" name="cid" value="<%= intCompanyID %>" >
      <input type="hidden" name="did" value="<%= bytBtnID %>" >
      <p><% // strSortBtn - WILL CONTAIN SORT BUTTON IF DECIDED TO INCLUDE %>
    <% if (intBegPoint == 0 && intEndPoint >= (total-batchModifier)) { %>
    <% } else { %>
      <%= strPrevBtn %>
      <%= strNextBtn %>
    <% } %>
      <input type="submit" name="btSubmit" value="Delete Checked Items" onClick="">
    </form>
      <input type="button" name="btView" value="Cancel Delete" onClick="javascript:location.replace('bpmain.jsp?uid=<%= intUserID %>&cid=<%= intCompanyID %>&did=<%= bytBtnID %>&srt=0&p1=0&p2=40')">
      <input type="button" name="btOut" value="Log Out" onClick="logOut()">
      </p>
    </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 %>