/*
 * Generated by the Jasper component of Apache Tomcat
 * Version: JspC/ApacheTomcat9
 * Generated at: 2025-11-03 13:08:24 UTC
 * Note: The last modified time of this file was set to
 *       the last modified time of the source file after
 *       generation to assist with modification tracking.
 */
package org.apache.jsp.dataWarning.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.silverpeas.core.persistence.jdbc.DBUtil;
import org.silverpeas.components.datawarning.DataWarningDBDriver;
import org.silverpeas.components.datawarning.model.DataWarning;
import org.silverpeas.components.datawarning.model.DataWarningScheduler;
import org.silverpeas.components.datawarning.model.DataWarningResult;
import org.silverpeas.components.datawarning.model.DataWarningQueryResult;
import org.silverpeas.components.datawarning.model.DataWarningQuery;
import org.silverpeas.kernel.bundle.ResourceLocator;
import org.silverpeas.core.web.util.viewgenerator.html.frame.Frame;
import org.silverpeas.core.web.util.viewgenerator.html.buttonpanes.ButtonPane;
import org.silverpeas.core.web.util.viewgenerator.html.operationpanes.OperationPane;
import org.silverpeas.components.datawarning.control.DataWarningSessionController;
import org.silverpeas.core.util.MultiSilverpeasBundle;
import org.silverpeas.core.web.util.viewgenerator.html.GraphicElementFactory;
import org.silverpeas.core.web.util.viewgenerator.html.window.Window;
import org.silverpeas.core.web.util.viewgenerator.html.tabs.TabbedPane;
import org.silverpeas.core.web.util.viewgenerator.html.browsebars.BrowseBar;
import org.silverpeas.core.web.util.viewgenerator.html.buttons.Button;
import org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayPane;
import org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayLine;
import java.util.Iterator;
import java.util.ArrayList;
import java.util.Collection;
import java.text.SimpleDateFormat;
import java.util.Date;

public final class selectConstraints_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent,
                 org.apache.jasper.runtime.JspSourceImports {

  private static final javax.servlet.jsp.JspFactory _jspxFactory =
          javax.servlet.jsp.JspFactory.getDefaultFactory();

  private static java.util.Map<java.lang.String,java.lang.Long> _jspx_dependants;

  static {
    _jspx_dependants = new java.util.HashMap<java.lang.String,java.lang.Long>(3);
    _jspx_dependants.put("jar:file:/home/silverbuild/.m2/repository/org/silverpeas/core/silverpeas-core-web/6.5-build251103/silverpeas-core-web-6.5-build251103.jar!/META-INF/viewGenerator.tld", Long.valueOf(1762172094000L));
    _jspx_dependants.put("/dataWarning/jsp/checkDataWarning.jsp", Long.valueOf(1708603024664L));
    _jspx_dependants.put("file:/home/silverbuild/.m2/repository/org/silverpeas/core/silverpeas-core-web/6.5-build251103/silverpeas-core-web-6.5-build251103.jar", Long.valueOf(1762172117948L));
  }

  private static final java.util.Set<java.lang.String> _jspx_imports_packages;

  private static final java.util.Set<java.lang.String> _jspx_imports_classes;

  static {
    _jspx_imports_packages = new java.util.LinkedHashSet<>(4);
    _jspx_imports_packages.add("javax.servlet");
    _jspx_imports_packages.add("javax.servlet.http");
    _jspx_imports_packages.add("javax.servlet.jsp");
    _jspx_imports_classes = new java.util.LinkedHashSet<>(34);
    _jspx_imports_classes.add("java.util.Date");
    _jspx_imports_classes.add("java.text.SimpleDateFormat");
    _jspx_imports_classes.add("org.silverpeas.core.persistence.jdbc.DBUtil");
    _jspx_imports_classes.add("org.silverpeas.core.util.MultiSilverpeasBundle");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.window.Window");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarning");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayLine");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.DataWarningDBDriver");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarningQuery");
    _jspx_imports_classes.add("java.util.ArrayList");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.buttonpanes.ButtonPane");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarningQueryResult");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.tabs.TabbedPane");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.buttons.Button");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.operationpanes.OperationPane");
    _jspx_imports_classes.add("java.util.Iterator");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayPane");
    _jspx_imports_classes.add("java.util.Collection");
    _jspx_imports_classes.add("org.silverpeas.kernel.bundle.ResourceLocator");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.GraphicElementFactory");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.control.DataWarningSessionController");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.frame.Frame");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarningScheduler");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarningResult");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.browsebars.BrowseBar");
  }

  private volatile javax.el.ExpressionFactory _el_expressionfactory;
  private volatile org.apache.tomcat.InstanceManager _jsp_instancemanager;

  public java.util.Map<java.lang.String,java.lang.Long> getDependants() {
    return _jspx_dependants;
  }

  public java.util.Set<java.lang.String> getPackageImports() {
    return _jspx_imports_packages;
  }

  public java.util.Set<java.lang.String> getClassImports() {
    return _jspx_imports_classes;
  }

  public javax.el.ExpressionFactory _jsp_getExpressionFactory() {
    if (_el_expressionfactory == null) {
      synchronized (this) {
        if (_el_expressionfactory == null) {
          _el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
        }
      }
    }
    return _el_expressionfactory;
  }

  public org.apache.tomcat.InstanceManager _jsp_getInstanceManager() {
    if (_jsp_instancemanager == null) {
      synchronized (this) {
        if (_jsp_instancemanager == null) {
          _jsp_instancemanager = org.apache.jasper.runtime.InstanceManagerFactory.getInstanceManager(getServletConfig());
        }
      }
    }
    return _jsp_instancemanager;
  }

  public void _jspInit() {
  }

  public void _jspDestroy() {
  }

  public void _jspService(final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response)
      throws java.io.IOException, javax.servlet.ServletException {

    if (!javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) {
      final java.lang.String _jspx_method = request.getMethod();
      if ("OPTIONS".equals(_jspx_method)) {
        response.setHeader("Allow","GET, HEAD, POST, OPTIONS");
        return;
      }
      if (!"GET".equals(_jspx_method) && !"POST".equals(_jspx_method) && !"HEAD".equals(_jspx_method)) {
        response.setHeader("Allow","GET, HEAD, POST, OPTIONS");
        response.sendError(HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET, POST or HEAD. Jasper also permits OPTIONS");
        return;
      }
    }

    final javax.servlet.jsp.PageContext pageContext;
    javax.servlet.http.HttpSession session = null;
    final javax.servlet.ServletContext application;
    final javax.servlet.ServletConfig config;
    javax.servlet.jsp.JspWriter out = null;
    final java.lang.Object page = this;
    javax.servlet.jsp.JspWriter _jspx_out = null;
    javax.servlet.jsp.PageContext _jspx_page_context = null;


    try {
      response.setContentType("text/html; charset=UTF-8");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"../../admin/jsp/errorpage.jsp", true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write('\n');
      out.write('\n');
      out.write('\n');
      out.write('\n');
      out.write('\n');
      out.write('\n');

	response.setHeader("Cache-Control","no-store"); //HTTP 1.1
	response.setHeader("Pragma","no-cache"); //HTTP 1.0
	response.setDateHeader ("Expires",-1); //prevents caching at the proxy server

      out.write("\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n");

	GraphicElementFactory gef;
	Window window;
	TabbedPane tabbedPane;
	Frame frame;
	ButtonPane buttonPane;
	OperationPane operationPane;

	DataWarningSessionController dataWarningSC;
    MultiSilverpeasBundle resource;

	gef = (GraphicElementFactory) session.getAttribute("SessionGraphicElementFactory");

	String flag = (String)request.getAttribute("flag");
	if (flag == null)
		flag = "user";


	dataWarningSC = (DataWarningSessionController) request.getAttribute("DataWarningSC");

	if (dataWarningSC == null) {
		// No DataWarning session controller in the request -> security exception
		String sessionTimeout = ResourceLocator.getGeneralSettingBundle().getString("sessionTimeout");
		getServletConfig().getServletContext().getRequestDispatcher(sessionTimeout).forward(request, response);
		return;
	}

	//objet window
	window = gef.getWindow();
    //browse bar
	String space = dataWarningSC.getSpaceLabel();
	String component = dataWarningSC.getComponentLabel();
	BrowseBar browseBar = window.getBrowseBar();
	browseBar.setDomainName(space);
	browseBar.setComponentName(component, "Main.jsp");
	//frame
	frame = gef.getFrame();
	//buttons
	buttonPane = gef.getButtonPane();
	//operation pane
	operationPane = window.getOperationPane();

	String m_context = ResourceLocator.getGeneralSettingBundle().getString("ApplicationURL");
    resource = (MultiSilverpeasBundle)request.getAttribute("resources");

      out.write('\n');
      out.write('\n');

	String req = (String)request.getAttribute("req");
	String[] columns = (String[])request.getAttribute("columns");
	String[] constraints = (String[])request.getAttribute("constraints");

      out.write("\n<HTML>\n<Head>\n");
      if (_jspx_meth_view_005flooknfeel_005f0(_jspx_page_context))
        return;
      out.write("\n</head>\n<Script language=\"JavaScript\">\n	function viewRequete()\n	{\n		var req = buildRequete();\n		SP_openWindow(\"PreviewReq?SQLReq=\" + req, \"Previsu_Req\", \"800\", \"300\", \"scrollbars=1\");\n	}\n\n	function buildRequete()\n	{\n		var req = document.editForm.SQLReq.value;\n");

		if(constraints != null && constraints.length > 0)
		{

      out.write("\n			req += \" where \" + document.editForm.Contrainte0.value;\n");

			if(constraints.length > 1)
			{

      out.write("\n				for(var i=1; i< ");
      out.print(constraints.length);
      out.write("; i++)\n					req += \" and \" + eval(\"document.editForm.Contrainte\" + i).value;\n");

			}
		}

      out.write("\n		return req;\n	}\n\n	function addCriter()\n	{\n		var sCol;\n		var sOp;\n		for(var i=0; i<document.editForm.sColumn.length; i++)\n			if(document.editForm.sColumn[i].selected)\n				sCol = document.editForm.sColumn[i].value;\n		for(var i=0; i<document.editForm.operateur.length; i++)\n			if(document.editForm.operateur[i].selected)\n				sOp = document.editForm.operateur[i].value;\n		var crit = sCol + \" \" + sOp + \" \" + document.editForm.contrainteValeur.value;\n		document.editForm.critere.value = crit;\n");

		if(constraints != null)
		{

      out.write("\n			document.editForm.critereSize.value = ");
      out.print(constraints.length);
      out.write('\n');

		}

      out.write("\n		if(document.editForm.contrainteValeur.value == \"\")\n			alert('");
      out.print(resource.getString("erreurChampsVide"));
      out.write("');\n		else\n		{\n			document.editForm.action = \"AddCriter\";\n			document.editForm.submit();\n		}\n	}\n\n	function delCriter()\n	{\n		var select = false;\n		for(var i=0; i<document.editForm.elements.length; i++)\n			if(document.editForm.elements[i].type == 'checkbox' && document.editForm.elements[i].checked == true)\n			{\n				select = true;\n				break;\n			}\n");

		if(constraints != null)
		{

      out.write("\n			document.editForm.critereSize.value = ");
      out.print(constraints.length);
      out.write('\n');

		}

      out.write("\n		if(select == false)\n			alert('");
      out.print(resource.getString("selectCritere"));
      out.write("');\n		else\n		{\n			document.editForm.action = \"DelCriter\";\n			document.editForm.submit();\n		}\n	}\n\n	function validateConstraints()\n	{\n		document.editForm.SQLReq.value = buildRequete();\n		document.editForm.action = \"SaveSelectColumns\";\n		document.editForm.submit();\n\n	}\n\nvar selectAll = true;\n	function selection()\n	{\n		for(var i=0; i<document.editForm.elements.length; i++)\n			if(document.editForm.elements[i].type == 'checkbox')\n				if(selectAll)\n				{\n					document.editForm.elements[i].checked = true;\n					if(i == document.editForm.elements.length - 4)\n						selectAll = false;\n				}\n				else\n				{\n					document.editForm.elements[i].checked = false;\n					if(i == document.editForm.elements.length - 4)\n						selectAll = true;\n				}\n	}\n</Script>\n<BODY marginwidth=5 marginheight=5 leftmargin=5 topmargin=5 bgcolor=\"#FFFFFF\">\n");

	//operation Pane
	operationPane.addOperation(resource.getIcon("DataWarning.visuReq"), resource.getString("operationPaneReqVisu"), "javascript:onClick=viewRequete()");

	out.println(window.printBefore());
	out.println(frame.printBefore());

      out.write("\n<form name=\"editForm\" method=\"post\" action=\"\">\n<input type=\"hidden\" name=\"critere\">\n<input type=\"hidden\" name=\"critereSize\">\n<center>\n<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><!--tablcontour-->\n	<tr align=center>\n		<td nowrap>\n			<table border=\"0\" cellspacing=\"2\" cellpadding=\"5\" class=intfdcolor width=\"100%\"><!--tabl1-->\n				<tr align=center class=\"intfdcolor4\">\n					<td nowrap>\n						<table cellpadding=0 cellspacing=0 border=0 width=\"100%\">\n							<tr>\n								<td valign=\"top\" width=\"1%\">\n									<span class=\"txtlibform\">");
      out.print(resource.getString("tabbedPaneRequete"));
      out.write(" :&nbsp;</span>\n								</td>\n								<td valign=\"top\">\n									<input type=\"text\" name=\"SQLReq\" size=\"70\" VALUE=\"");
      out.print(req);
      out.write("\" readonly>\n									<br><br>\n								</td>\n							</tr>\n");

							if(constraints != null && constraints.length > 0)
							{

      out.write("\n							<tr>\n								<td class=\"txtlibform\" rowspan=\"");
      out.print(constraints.length + 2);
      out.write("\" valign=\"top\">\n									");
      out.print(resource.getString("criteres"));
      out.write(" :\n								</td>\n								<td valign=\"top\">\n");

								for(int i=0; i<constraints.length; i++)
								{

      out.write("\n									<tr>\n										<td>\n											<input type=\"text\" name=\"Contrainte");
      out.print(i);
      out.write("\" size=\"30\" maxlength=\"20\" VALUE=\"");
      out.print(constraints[i]);
      out.write("\" readonly>\n											<input type=\"checkbox\" name=\"ContrainteSupp");
      out.print(i);
      out.write("\">\n										</td>\n									</tr>\n");

								}

      out.write("\n									<tr>\n										<td>\n											<a href=\"javascript:selection();\" title='");
      out.print(resource.getString("selectAllCase"));
      out.write('\'');
      out.write('>');
      out.print(resource.getString("selectAll"));
      out.write("</a> - <a href=\"javascript:delCriter();\" title='");
      out.print(resource.getString("suppCritere"));
      out.write('\'');
      out.write('>');
      out.print(resource.getString("boutonSupprimer"));
      out.write("</a>\n										</td>\n									</tr>\n								</td>\n							</tr>\n");

							}

      out.write("\n							<tr>\n								<td valign=\"top\" align=\"left\" colspan=\"2\">\n									<br>\n									<span class=\"txtlibform\">");
      out.print(resource.getString("popupSelection3"));
      out.write(" :</span>\n								</td>\n							</tr>\n							<tr>\n								<td colspan=\"2\">\n									<br>\n									<table cellpadding=2 cellspacing=1 border=0 width=\"100%\" bgcolor=\"#000000\">\n										<tr>\n											<td class=intfdcolor align=center nowrap height=\"24\">\n												<span class=selectNS>\n													<select name=\"sColumn\">\n");

														for(int i=0; i<columns.length; i++)
															out.println("<option value='" + columns[i] + "'>" + columns[i] + "</option>");

      out.write("\n													</select>\n												</span>\n											</td>\n											<td class=intfdcolor align=center nowrap height=\"24\">\n												<span class=selectNS>\n													<select name=\"operateur\">\n														<option value=\">\">&#62;</option>\n														<option value=\">=\">&#62;&#61;</option>\n														<option value=\"<\">&#60;</option>\n														<option value=\"<=\">&#60;&#61;</option>\n														<option value=\"=\">&#61;</option>\n														<option value=\"!=\">&#33;&#61;</option>\n													</select>\n												</span>\n											</td>\n											<td class=intfdcolor align=center nowrap height=\"24\">\n												<span class=selectNS>\n													");
      out.print(resource.getString("champValeur"));
      out.write(" :\n												</span>\n											</td>\n											<td class=intfdcolor align=center nowrap height=\"24\">\n												<span class=selectNS>\n													<input type=\"text\" name=\"contrainteValeur\" value=\"\" size=\"30\">\n												</span>\n											</td>\n											<td class=intfdcolor align=center nowrap height=\"24\" width=\"1%\">\n												<span class=selectNS>\n");

													  ButtonPane buttonPane0 = gef.getButtonPane();
													  buttonPane0.addButton((Button) gef.getFormButton("Ok", "javascript:onClick=addCriter()", false));
													  out.println(buttonPane0.print());

      out.write("\n												</span>\n											</td>\n										</tr>\n									</table>\n								</td>\n							</tr>\n						</table>\n					</td>\n				</tr>\n			</table>\n		</td>\n	</tr>\n</table>\n<br>\n");

	buttonPane.addButton((Button) gef.getFormButton(resource.getString("boutonTerminer"), "javascript:onClick=validateConstraints();", false));
	buttonPane.addButton((Button) gef.getFormButton(resource.getString("boutonAnnuler"), "javascript:onClick=window.close()", false));

	out.println(buttonPane.print());

      out.write("\n</center>\n</form>\n");

	out.println(frame.printAfter());
	out.println(window.printAfter());

      out.write("\n</BODY>\n</HTML>");
    } catch (java.lang.Throwable t) {
      if (!(t instanceof javax.servlet.jsp.SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          try {
            if (response.isCommitted()) {
              out.flush();
            } else {
              out.clearBuffer();
            }
          } catch (java.io.IOException e) {}
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
        else throw new ServletException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }

  private boolean _jspx_meth_view_005flooknfeel_005f0(javax.servlet.jsp.PageContext _jspx_page_context)
          throws java.lang.Throwable {
    javax.servlet.jsp.PageContext pageContext = _jspx_page_context;
    javax.servlet.jsp.JspWriter out = _jspx_page_context.getOut();
    //  view:looknfeel
    org.silverpeas.core.web.util.viewgenerator.html.LookAndStyleTag _jspx_th_view_005flooknfeel_005f0 = new org.silverpeas.core.web.util.viewgenerator.html.LookAndStyleTag();
    _jsp_getInstanceManager().newInstance(_jspx_th_view_005flooknfeel_005f0);
    _jspx_th_view_005flooknfeel_005f0.setPageContext(_jspx_page_context);
    _jspx_th_view_005flooknfeel_005f0.setParent(null);
    int _jspx_eval_view_005flooknfeel_005f0 = _jspx_th_view_005flooknfeel_005f0.doStartTag();
    if (_jspx_th_view_005flooknfeel_005f0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
      return true;
    }
    org.apache.jasper.runtime.JspRuntimeLibrary.releaseTag(_jspx_th_view_005flooknfeel_005f0, _jsp_getInstanceManager());
    return false;
  }
}
