/*
 * Generated by the Jasper component of Apache Tomcat
 * Version: JspC/ApacheTomcat9
 * Generated at: 2026-03-17 12:52:36 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 selectAgrega_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("/dataWarning/jsp/checkDataWarning.jsp", Long.valueOf(1725461247800L));
    _jspx_dependants.put("file:/home/silverbuild/.m2/repository/org/silverpeas/core/silverpeas-core-web/6.4.7-build260317/silverpeas-core-web-6.4.7-build260317.jar", Long.valueOf(1773748501033L));
    _jspx_dependants.put("jar:file:/home/silverbuild/.m2/repository/org/silverpeas/core/silverpeas-core-web/6.4.7-build260317/silverpeas-core-web-6.4.7-build260317.jar!/META-INF/viewGenerator.tld", Long.valueOf(1773748476000L));
  }

  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 table = (String)request.getAttribute("tableName");
	String[] columns = (String[])request.getAttribute("columns");

      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		if(!isAllAgregaChoisi())\n			alert('");
      out.print(resource.getString("agregaColonne"));
      out.write("');\n		else\n		{\n			var req = buildRequete();\n			SP_openWindow(\"PreviewReq?SQLReq=\" + req, \"Previsu_Req\", \"800\", \"300\", \"scrollbars=1\");\n		}\n	}\n\n	function isAllAgregaChoisi()\n	{\n		var compteur = 0;\n		var valid = true;\n		for(x=0; x < ");
      out.print(columns.length);
      out.write("; x++)\n			for(y=0; y < eval(\"document.editForm.Operateur\" + x).options.length; y++)\n				if(eval(\"document.editForm.Operateur\" + x).options[y].value == \"\" && eval(\"document.editForm.Operateur\" + x).options[y].selected == true)\n				{\n					compteur++;\n					valid = false;\n				}\n		if((valid && compteur == 0) || (compteur == ");
      out.print(columns.length);
      out.write(" && !valid))\n			return true;\n		return false;\n	}\n\n	function buildRequete()\n	{\n		var req = \"\";\n		var selectedTable = \"");
      out.print(table);
      out.write("\";\n		var premierSelect;\n		for(w=0; w<document.editForm.Operateur0.options.length; w++)\n			if(document.editForm.Operateur0.options[w].selected == true)\n				premierSelect = document.editForm.Operateur0.options[w].value;\n		var col = premierSelect + \"(");
      out.print(columns[0]);
      out.write(")\";\n\n		if(");
      out.print(columns.length);
      out.write(" > 1)\n		{\n			for(z=1; z < ");
      out.print(columns.length);
      out.write("; z++)\n			{\n				var select = \"\";\n				for(w=0; w<eval(\"document.editForm.Operateur\" + z).options.length; w++)\n					if(eval(\"document.editForm.Operateur\" + z).options[w].selected == true)\n						select = eval(\"document.editForm.Operateur\" + z).options[w].value;\n				col = col + \", \" + select + \"(\" + eval(\"document.editForm.Colonne\" + z).value + \")\";\n			}\n		}\n		req = \"select \" + col + \" from ");
      out.print(table);
      out.write("\";\n		return req;\n	}\n\n	function validateAgrega()\n	{\n		if(!isAllAgregaChoisi())\n			alert('");
      out.print(resource.getString("agregaColonne"));
      out.write("');\n		else\n		{\n			document.editForm.SQLReq.value = buildRequete();\n			document.editForm.action = \"SaveSelectColumns\";\n			document.editForm.submit();\n		}\n	}\n	function getConstraints()\n	{\n		if(!isAllAgregaChoisi())\n			alert('");
      out.print(resource.getString("agregaColonne"));
      out.write("');\n		else\n		{\n			document.editForm.SQLReq.value = buildRequete();\n			document.editForm.action = \"SelectConstraints\";\n			document.editForm.submit();\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=\"SQLReq\">\n<input type=\"hidden\" name=\"columnsSize\" value=\"");
      out.print(columns.length);
      out.write("\">\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("popupChamp1"));
      out.write(" :&nbsp;</span>\n								</td>\n								<td valign=\"top\">\n									<input type=\"text\" name=\"Name\" size=\"30\" maxlength=\"20\" VALUE=\"");
      out.print(table);
      out.write("\" readonly>\n									<br><br>\n								</td>\n							</tr>\n");

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

      out.write("\n							<tr>\n								<td>\n									<span class=\"txtlibform\">");
      out.print(resource.getString("colonne"));
      out.write(" :&nbsp;</span>\n								</td>\n								<td>\n									<input type=\"text\" size=\"30\" name=\"Colonne");
      out.print(i);
      out.write("\" value=\"");
      out.print(columns[i]);
      out.write("\" readonly>\n								</td>\n								<td>\n									<span class=\"txtlibform\">");
      out.print(resource.getString("operateur"));
      out.write(" :&nbsp;</span>\n								</td>\n								<td>\n									<select name=\"Operateur");
      out.print(i);
      out.write("\">\n										<option value=\"\">pas d'op�rateur</option>\n										<option value=\"sum\">somme</option>\n										<option value=\"min\">min</option>\n										<option value=\"max\">max</option>\n										<option value=\"count\">count</option>\n										<option value=\"avg\">moyenne</option>\n									</select>\n								</td>\n							</tr>\n");

							}

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

	buttonPane.addButton((Button) gef.getFormButton(resource.getString("boutonSuivant"), "javascript:onClick=getConstraints()", false));
	buttonPane.addButton((Button) gef.getFormButton(resource.getString("boutonTerminer"), "javascript:onClick=validateAgrega();", 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;
  }
}
