private boolean isUserAllowedToViewScOrders(User user) { boolean isTrue = false; try { PreparedStatement stmt = conn.prepareStatement("select canAddScOrder,canViewScOrder from users where idusers=?"); stmt.setInt(1, user.getUserID()); ResultSet res = stmt.executeQuery(); if (res.next()) { if (res.getBoolean("canViewScOrder")) { isTrue = true; } else { isTrue = false; } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return isTrue; }
private void displayIssuesDeps() { getDepartments(); for (int i = 0; i < deps.size(); i++) { out.println("<div class=\"col width-33 ui-sotable\">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">" + deps.get(i).getDepName() + "</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); out.println("<table cellspacing=\"0\" class=\"dataTable\">"); out.println("<thead>"); out.println("<tr>"); out.println("<th class=\"sortable first_label\" id=\"label\">"); out.println("<div id=\"thDiv\">Issues</div>"); out.println("</th>"); out.println("<th class=\"sortable columnSorted\" id=\"priority\">"); out.println("<div id=\"thDiv\">P</div>"); out.println("</th>"); out.println("<th class=\"sortable last\" id=\"satus\">"); out.println("<div id=\"thDiv\">Owner</div>"); out.println("</th>"); out.println("<th class=\"sortable last\" id=\"opentime\">"); out.println("<div id=\"thDiv\">Opened HH:MM</div>"); out.println("</th>"); out.println("</tr>"); out.println("</thead>"); out.println("<tbody>"); getOpenIssuesForDep(deps.get(i).getDepName()); for (int j = 0; j < openIssuesDep.size(); j++) { if (j % 2 != 0) { out.println("<tr>"); out.println("<td class=\"label labelodd\" tyle=\"min:width: 145px;\">"); out.println( "<span class=\"label\"><a href=\"ViewIssue.do?id=" + String.valueOf(openIssuesDep.get(j).getIssueID()) + "\">" + openIssuesDep.get(j).getIssueName() + "</a></span>"); out.println("</td>"); if (openIssuesDep.get(j).getPriority().equals("LOW")) { out.println( "<td class=\"columnodd\" style=\"background-color:#0F0\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } if (openIssuesDep.get(j).getPriority().equals("MED")) { out.println( "<td class=\"columnodd\" style=\"background-color:#FF0\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } if (openIssuesDep.get(j).getPriority().equals("HIGH")) { out.println( "<td class=\"columnodd\" style=\"background-color:#F00\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } out.println("<td class=\"columnodd\">" + openIssuesDep.get(j).getOpenByUser() + "</td>"); out.println( "<td class=\"columnodd\">" + openSince(openIssuesDep.get(j).getOpenedAt()) + "</td>"); out.println("</tr>"); } if (j % 2 == 0) { out.println("<tr>"); out.println("<td class=\"label labeleven\" tyle=\"min:width: 145px;\">"); out.println( "<span class=\"label\"><a href=\"ViewIssue.do?id=" + String.valueOf(openIssuesDep.get(j).getIssueID()) + "\">" + openIssuesDep.get(j).getIssueName() + "</a>"); out.println("</td>"); if (openIssuesDep.get(j).getPriority().equals("LOW")) { out.println( "<td class=\"columnodd\" style=\"background-color:#0F0\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } if (openIssuesDep.get(j).getPriority().equals("MED")) { out.println( "<td class=\"columnodd\" style=\"background-color:#FF0\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } if (openIssuesDep.get(j).getPriority().equals("HIGH")) { out.println( "<td class=\"columnodd\" style=\"background-color:#F00\">" /*+openIssuesDep.get(j).getPriority()*/ + "</td>"); } out.println("<td class=\"columneven\">" + openIssuesDep.get(j).getOpenByUser() + "</td>"); out.println( "<td class=\"columnodd\">" + openSince(openIssuesDep.get(j).getOpenedAt()) + "</td>"); out.println("</tr>"); } if ((j == openIssuesDep.size() - 1) && j == 4) { out.println("<tr>"); out.println("<td class=\"columneven\">"); out.println( "<span class=\"label\"><a href=\"MoreIssues.do?depid=" + deps.get(i).getDepID() + "\">All Issues</a>"); out.println("</td>"); out.println("</tr>"); } } openIssuesDep.clear(); out.println("<tbody>"); out.println("</table>"); // table ends // out.println("<div class=\"dataTableSpacer\"></div>"); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends // out.println("I value @ "+i); if (i == 2) { out.println("<div class=\"clear\"></div>"); } } deps.clear(); if (isUserAllowedtoAddNewOrders(loggedUser)) { out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Update Orders</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); out.println( "<form method=\"post\" action=\"addNewOrder.do\" onsubmit=\"return(validateForm());\">"); out.println("<input type=\"hidden\" value=\"" + loggedUser.getUserID() + "\"/>"); out.println("<input name=\"update\" type=\"submit\" value=\"Update Orders\" />"); out.println(" </form>"); out.println("<span>"); lastUpdatedOrders(); out.println("</span>"); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends } // if(isUserAllowedToViewNewOrders(loggedUser)){ out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Orders Last Updated</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); getNewOrdersView(); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends // } if (isUserAllowedtoAddScOrders(loggedUser)) { out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Update Schedules</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); out.println( "<form method=\"post\" action=\"AddSchedules.do\" onsubmit=\"return(validateForm());\">"); out.println("<input type=\"hidden\" value=\"" + loggedUser.getUserID() + "\"/>"); out.println("<input name=\"update\" type=\"submit\" value=\"Update Schedules\" />"); out.println(" </form>"); out.println("<span>"); lastUpdatedScOrders(); out.println("</span>"); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends } // if(isUserAllowedToViewScOrders(loggedUser)){ out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Schedules Last Updated</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); getScOrdersView(); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends // } if (isUserAllowedtoAddWorkOrders(loggedUser)) { out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Update Work Orders</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); out.println( "<form method=\"post\" action=\"AddWorkOrders.do\" onsubmit=\"return(validateForm());\">"); out.println("<input type=\"hidden\" value=\"" + loggedUser.getUserID() + "\"/>"); out.println("<input name=\"update\" type=\"submit\" value=\"Update Work Orders\" />"); out.println(" </form>"); out.println("<span>"); lastUpdatedWorkOrders(); out.println("</span>"); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends } // if(isUserAllowedToViewWorkOrders(loggedUser)){ out.println( "<div class=\"col width-100 ui-sotable\" style=\" margin-bottom: 1px; padding-bottom: 1px; height: 50px; \">"); out.println("<div class=\"sortable\" widgetid=\"widgetUserSettingsgetPlugun\">"); out.println("<div id=\"widgetUserSettingsgetPlugin\" class=\"widget\">"); out.println("<div class=\"widgetTop\">"); out.println("<div class=\"widgetName\">Work Orders Last Updated</div>"); out.println("</div>"); out.println("<div class=\"widgetContent\">"); out.println("<div class=\"dataTable\" id=\"dataTable_1\">"); out.println("<div class=\"dataTableWrapper\">"); getWorkOrdersView(); out.println("</div>"); // data table wrapper ends out.println("</div>"); // data table ends out.println("</div>"); // widget content ends out.println("</div>"); // widget ends out.println("</div>"); // get Plugin ends out.println("</div>"); // col width 33 ends // } }