/*
 * Generated by the Jasper component of Apache Tomcat
 * Version: JspC/ApacheTomcat9
 * Generated at: 2026-07-20 06:54:02 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 selectColumns_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.LinkedHashMap<java.lang.String,java.lang.Long>(3);
    _jspx_dependants.put("/dataWarning/jsp/checkDataWarning.jsp", Long.valueOf(1781083279734L));
    _jspx_dependants.put("uri:http://www.silverpeas.com/tld/viewGenerator", Long.valueOf(1784527154979L));
    _jspx_dependants.put("uri:http://www.silverpeas.com/tld/viewGenerator!/META-INF/viewGenerator.tld", Long.valueOf(1784527132000L));
  }

  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("org.silverpeas.core.persistence.jdbc.DBUtil");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.DataWarningDBDriver");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarning");
    _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.components.datawarning.model.DataWarningQueryResult");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.model.DataWarningQuery");
    _jspx_imports_classes.add("org.silverpeas.kernel.bundle.ResourceLocator");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.frame.Frame");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.buttonpanes.ButtonPane");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.operationpanes.OperationPane");
    _jspx_imports_classes.add("org.silverpeas.components.datawarning.control.DataWarningSessionController");
    _jspx_imports_classes.add("org.silverpeas.core.util.MultiSilverpeasBundle");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.GraphicElementFactory");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.window.Window");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.tabs.TabbedPane");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.browsebars.BrowseBar");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.buttons.Button");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayPane");
    _jspx_imports_classes.add("org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayLine");
    _jspx_imports_classes.add("java.util.Iterator");
    _jspx_imports_classes.add("java.util.ArrayList");
    _jspx_imports_classes.add("java.util.Collection");
    _jspx_imports_classes.add("java.text.SimpleDateFormat");
    _jspx_imports_classes.add("java.util.Date");
  }

  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[] nselectedColumns = (String[])request.getAttribute("nselectedColumns");
	DataWarning data = (DataWarning)request.getAttribute("data");
	DataWarningQuery query = (DataWarningQuery)request.getAttribute("dataQuery");

      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	var isTriggerQuery = ");
      out.print(((query.getType() == DataWarningQuery.QUERY_TYPE_TRIGGER)?"true":"false"));
      out.write(";\n	function getAgregas()\n	{\n		if(isTriggerQuery && document.editForm.sColumns.length == 0)\n			alert('");
      out.print(resource.getString("selectColonne"));
      out.write("');\n		else\n		{\n			if(document.editForm.sColumns.length == 0)\n				for(var i=0; i<document.editForm.columns.length; i++)\n					document.editForm.sColumns.options[document.editForm.sColumns.length] = new Option(\"\", document.editForm.columns.options[i].value);\n			for (j=0;j<document.editForm.sColumns.length;j++)\n				document.editForm.sColumns[j].selected = true;\n			document.editForm.action = \"SelectAgrega\";\n			document.editForm.submit();\n		}\n	}\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 = \"\";\n		var selectedTable = \"");
      out.print(table);
      out.write("\";\n		var cpt = 0;\n		nbr = document.editForm.sColumns.length;\n		if(nbr > 0)\n		{\n			var Cols = document.editForm.sColumns[0].value;\n			cpt = 1;\n			while(cpt < nbr)\n			{\n				Cols = Cols + \",\" + document.editForm.sColumns[cpt].value;\n				cpt++;\n			}\n			req = \"select \" + Cols + \" from ");
      out.print(table);
      out.write("\";\n		}\n		else\n			req = \"select * from ");
      out.print(table);
      out.write("\";\n		return req;\n	}\n\n	function validateColumns()\n	{\n		if(isTriggerQuery && document.editForm.sColumns.length == 0)\n			alert('");
      out.print(resource.getString("selectColonne"));
      out.write("');\n		else\n		{\n			document.editForm.SQLReq.value = buildRequete();\n			document.editForm.action = \"SaveSelectColumns\";\n			document.editForm.submit();\n		}\n	}\n\n	function SelectionColonne(obj, obj1, element)\n	{\n		var selectionne = false;\n		for(var i=0; i<eval(\"document.editForm.\" + element).length; i++)\n			if(eval(\"document.editForm.\" + element).options[i].selected == true)\n				selectionne = true;\n		if(!selectionne)\n			alert('");
      out.print(resource.getString("selectColonnes"));
      out.write("');\n		else if(isTriggerQuery)\n		{\n			obj.style.display = 'none';\n			obj1.style.display = 'block';\n		}\n		else\n		{\n			obj.style.display = 'block';\n			obj1.style.display = 'block';\n		}\n	}\n\n	function move_groups(btn)\n	{\n	   var z = 0;                       //used to index indexArray\n	   var indexArray = new Array();    //used to keep track of values in multiple selection case\n\n	   if(btn == \">\")     //check which button\n	   {\n		  var listObj = document.editForm.columns;\n		  var targetObj = document.editForm.sColumns;\n	   }\n	   else\n	   {\n		  var listObj = document.editForm.sColumns;\n		  var targetObj = document.editForm.columns;\n	   }\n\n	   for(var i=0; i<listObj.length; i++)   //loop through list to find selected items\n	   {\n		  if(listObj.options[i].selected)          //only do something if item is selected\n		  {\n			 var selectedItem = listObj.options[i].text;\n			 var selectedItem2 = listObj.options[i].value;\n			 targetObj.options[targetObj.length] = new Option( selectedItem, selectedItem2 );   //create new items in target select box\n");
      out.write("\n			 indexArray[z] = i;             //keep track of indices of selected items\n			 z++;                           //indexArray only gets a value if the item is selected and the 'if' statement is entered\n		  }\n	   }\n\n	   for(var i=listObj.length-1; i>=0; i--)			//cycle backwards through items and clear all selected items\n	   {                                                //must cycle backwards so the loop does not miss any items when list size changes...\n		  listObj.options[indexArray[i]] = null;        //...and index of selected item changes\n	   }                                                //ex. when loop begins, items 1 and 2 are selected, if 1 is deleted first...\n	}\n\n	function moveall_groups(btn)\n	{\n	   if(btn == \">>\")     //check which button\n	   {\n		  var listObj = document.editForm.columns;\n		  var targetObj = document.editForm.sColumns;\n	   }\n	   else\n	   {\n		  var listObj = document.editForm.sColumns;\n		  var targetObj = document.editForm.columns;\n	   }\n\n	   for(var i=0; i<listObj.length; i++)        //loop through list\n");
      out.write("	   {\n		  var selectedItem = listObj.options[i].text;\n		  var selectedItem2 = listObj.options[i].value;\n		  targetObj.options[targetObj.length] = new Option( selectedItem, selectedItem2 );\n	   }\n\n	   for(var i=listObj.length-1; i>=0; i--)   //loop backwards through list clearing every item\n		  listObj.options[i] = null;\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=\"table\" value=\"");
      out.print(table);
      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\" nowrap>\n									<span class=\"txtlibform\">");
      out.print(resource.getString("popupChamp1"));
      out.write(" :</span>\n								</td>\n								<td>&nbsp;</td>\n								<td valign=\"top\">\n									<input type=\"text\" name=\"Name\" size=\"50\" maxlength=\"20\" VALUE=\"");
      out.print(table);
      out.write("\" readonly>\n									<br><br>\n								</td>\n							</tr>\n							<tr>\n								<td colspan=\"3\" align=\"center\" class=\"intfdcolor\"  height=\"1\">\n									<img src=\"");
      out.print(m_context);
      out.write("/util/icons/colorPix/1px.gif\"></td>\n							</tr>\n							<tr>\n								<td colspan=3 align=\"center\">\n									<table cellpadding=0 cellspacing=0 border=0 width=\"100%\">\n										<tr>\n											<td valign=\"top\" nowrap align=\"center\" width=\"50%\">\n												<br>\n												<span class=\"txtlibform\">");
      out.print(resource.getString("popupAvailableColumns"));
      out.write(" : </span>\n												<br><br>\n											</td>\n											<td valign=\"top\" nowrap width=\"1\">\n												<br>&nbsp;<br><br>\n											</td>\n											<td valign=\"top\" nowrap align=\"center\" width=\"50%\">\n												<br>\n												<span class=\"txtlibform\">");
      out.print(resource.getString("popupSelected"));
      out.write(" : </span>\n												<br><br>\n											</td>\n										</tr>\n									</table>\n								</td>\n							</tr>\n							<tr>\n								<td colspan=3 align=\"center\">\n									<table cellpadding=0 cellspacing=0 border=0 width=\"100%\">\n										<tr>\n											<td valign=\"top\" align=\"center\" width=\"50%\">\n");

												if(query.getType() == DataWarningQuery.QUERY_TYPE_TRIGGER)
													out.println("<select name='columns' size='10'>");
												else
													out.println("<select name='columns' multiple size='10'>");

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

      out.write("\n												</select>\n											</td>\n											<td width=\"1\" valign=\"middle\" align=\"center\">\n												<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"37\">\n													<tr>\n														<td width=\"37\">\n															<a id=\"aRight\" class=\"intfdcolor\" onclick=\"javascript:SelectionColonne(this, document.getElementById('aLeft'), 'columns');\" href=\"javascript:move_groups('>');\" style=\"display:block\"><img src=\"");
      out.print(m_context);
      out.write("/util/icons/formButtons/arrowRight.gif\" width=\"37\" height=\"24\" border=\"0\"></a>\n															");
if(query.getType() != DataWarningQuery.QUERY_TYPE_TRIGGER){
      out.write("\n																<a class=\"intfdcolor\" href=\"javascript:moveall_groups('>>');\"><img src=\"");
      out.print(m_context);
      out.write("/util/icons/formButtons/arrowDoubleRight.gif\" width=\"37\" height=\"24\" border=\"0\"></a>\n															");
}
      out.write("\n															<a id=\"aLeft\" class=\"intfdcolor\" onclick=\"javascript:SelectionColonne(this, document.getElementById('aRight'), 'sColumns');\" href=\"javascript:move_groups('<');\" style=\"display:none\"><img src=\"");
      out.print(m_context);
      out.write("/util/icons/formButtons/arrowLeft.gif\" width=\"37\" height=\"24\" border=\"0\"></a>\n															");
if(query.getType() != DataWarningQuery.QUERY_TYPE_TRIGGER){
      out.write("\n																<a class=\"intfdcolor\" href=\"javascript:moveall_groups('<<');\"><img src=\"");
      out.print(m_context);
      out.write("/util/icons/formButtons/arrowDoubleLeft.gif\" width=\"37\" height=\"24\" border=\"0\"></a>\n															");
}
      out.write("\n														</td>\n													</tr>\n												</table>\n											</td>\n											<td valign=\"top\" align=\"center\" width=\"50%\">\n												<select name=\"sColumns\" multiple size=\"10\">\n												</select>\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("boutonSuivant"), "javascript:onClick=getAgregas()", false));
	buttonPane.addButton((Button) gef.getFormButton(resource.getString("boutonTerminer"), "javascript:onClick=validateColumns();", 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());

	if(query.getType() != DataWarningQuery.QUERY_TYPE_TRIGGER)
	{

      out.write("\n<script language=javascript>\n	document.getElementById('aLeft').style.display = 'block';\n	document.getElementById('aRight').style.display = 'block';\n</script>\n");

	}

      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);
    try {
      _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;
      }
    } finally {
      org.apache.jasper.runtime.JspRuntimeLibrary.releaseTag(_jspx_th_view_005flooknfeel_005f0, _jsp_getInstanceManager());    }
    return false;
  }
}
