  <%@ include file="/sdk/oemTop.jspf" %>
  <%@ include file="/oemNoscript.jspf" %>  
  <%@ taglib uri="http://xmlns.oracle.com/uix/ui" prefix="uix"%>
  <%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag" prefix="oem"%>
  <%@ page import="oracle.sysman.emSDK.util.jdk.NLSUtil"%>
  <%@ page import="oracle.cabo.ui.data.BundleDataObject"%>
  <%@ page import="oracle.sysman.emSDK.util.jdk.NLSUtil"%>
  <%@ page import="oracle.sysman.db.rsc.sec.EUSMsg"%>
  <%@ page import="oracle.cabo.ui.data.BundleDataObject"%>
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSConstants"%>
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSSubComponentsDataSourceConstants"%> 
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSSubComponentsDataSource"%> 
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSComponent"%>
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSComponentType"%>  
  <%@ page import="oracle.sysman.emo.adm.security.eus.EUSSubComponentType"%>
  <%@ page import="java.util.ResourceBundle"%>
  <%@ page import="java.util.Map"%>
  <%@ page import="java.util.Set"%>
  <%@ page import="java.util.List"%>
  <%@ page import="java.util.HashMap"%>
  <%@ page import="java.util.Iterator"%>
  <%@ page import="oracle.sysman.emo.util.UIXDataSource"%>
  <%@ page import="oracle.sysman.db.adm.ParameterNames"%>  
            

  
  <%

    String sFormDestinationURL=(String)request.getAttribute(EUSConstants.EUS_BASE_URL_TO_COMPONENT);    
    String sEvent="";    
    if(request.getAttribute("SUB_COMPONENT_EVENT") != null)
        sEvent=EUSConstants.EUS_CREATE_SUB_COMPONENT;            
    else
        sEvent=EUSConstants.EUS_EDIT_SUB_COMPONENT ;           
    String sFinalUrl=request.getContextPath()+sFormDestinationURL+"&event="+sEvent+"&subevent=addDBUser";              
    String sAddUserJSFunction="submitMainForm('"+sFinalUrl+"')";
    
    String sSearchURL=request.getContextPath()+sFormDestinationURL+"&event="+sEvent+"&subevent=getDBUsers";              
    String sSearchJSFunction="submitCurrentForm('"+sSearchURL+"')";
    
  
    request.setAttribute("eusBundle", new BundleDataObject(NLSUtil.getBundle(EUSMsg.class.getName(), request)));
    String dbVersion = (String)request.getAttribute("DBVERSION");
    ResourceBundle eusBundle=NLSUtil.getBundle(EUSMsg.class.getName(), request);
    String sPageTitle=eusBundle.getString("SELECT_DB_USER_TEXT");
        EUSSubComponentType fromRequestSubComponentType=null;
        String sFRomRequestSubComponentTYpe="0";
        if(request.getAttribute(EUSConstants.SUB_COMPONENT_TYPE) != null)
        {
          fromRequestSubComponentType=(EUSSubComponentType) request.getAttribute(EUSConstants.SUB_COMPONENT_TYPE);
          sFRomRequestSubComponentTYpe=String.valueOf(fromRequestSubComponentType.getType());
          
        }
        EUSComponentType fromRequestComponentType=null;
        String sFRomRequestComponentTYpe="0";
        if(request.getAttribute(EUSConstants.EUS_COMPONENT_TYPE) != null)
        {
          fromRequestComponentType=(EUSComponentType) request.getAttribute(EUSConstants.EUS_COMPONENT_TYPE);
          sFRomRequestComponentTYpe=String.valueOf(fromRequestComponentType.getType());
        }
        
        
        String sCurrentJSP="/database/security/eus/eusdbuserslov";
  %>

  
  <uix:renderingContext id="renderingContext">
    <oem:setURLEncoder id="renderingContext"/>
      <uix:bundle name="dbMsgs" class="oracle.sysman.db.rsc.DBObjectMsg"/>
    <uix:bundle name="olsMsgs" class="oracle.sysman.db.rsc.sec.OLSOIDMsg"/>
    <uix:bundle name="eusMsgs" class="oracle.sysman.db.rsc.sec.EUSMsg"/>
      <uix:document>
          <%@ include file="/oemTitle.jspf" %>
          <uix:metaContainer>
              <uix:head title="<%=sPageTitle%>"/>
          </uix:metaContainer>
          <uix:body>
            <uix:form name="form0" method="POST" destination="<%=sFormDestinationURL%>">
                        <uix:formValue name="<%=EUSConstants.SUB_COMPONENT_TYPE%>" value="<%=sFRomRequestSubComponentTYpe%>" />
                        <uix:formValue name="<%=EUSConstants.EUS_COMPONENT_TYPE%>" value="<%=sFRomRequestComponentTYpe%>" />
                        <uix:formValue name="<%=ParameterNames.PAGE_NAME%>" value="<%=sCurrentJSP%>"/>
                        <uix:formValue name="SUB_COMPONENT_EVENT" value="<%=sEvent%>"/> 
                          <oem:messageBox messageType="error" 
                                errorTableBinding="errors@servletRequest"
                                titleTextKey="titleText" mainTextKey="mainText"/>
            
            
            <uix:script text="function cancel()
                                  {
                                    top.close();
                                  }
                                  
                                  
                              function submitMainForm(sFinalUrl)
                                  {
                                    var sRadioButtonName='eusdbusers:selected';
                                    for(var i=0;i<document.forms[0].elements.length;i++)
                                    {
                                      var sElemenetName=document.forms[0].elements[i].name;
                                      if(sRadioButtonName==sElemenetName)
                                      {
                                        if(document.forms[0].elements[i].checked)
                                        {
                                            sToBeAddedSubComponentsIndexes=document.forms[0].elements[i].value;  
                                        }                                          
                                      }
                                    }
                                    top.window.opener.document.forms[0].ToBeAddedUserGroupIndex.value=sToBeAddedSubComponentsIndexes;
                                    top.window.opener.document.forms[0].action=sFinalUrl;
                                    top.window.opener.document.forms[0].submit();
                                    top.close();
                                  }
                                  
                               function submitCurrentForm(sSearchUrl)
                               {
                                  document.forms[0].action=sSearchUrl;  
                                  document.forms[0].submit();
                               }" />

   
            
            <uix:pageLayout title="<%=sPageTitle%>">
             <uix:tableLayout width="100%" cellPadding="3" cellSpacing="3">
             
                <uix:rowLayout hAlign="right">
                    <uix:cellFormat columnSpan="2">
                      <uix:pageButtonBar>
                        <uix:contents>
                          <uix:button text="<%=eusBundle.getString(\"EUS_CANCEL_TEXT\")%>" 
                                      shortDesc="<%=eusBundle.getString(\"EUS_CANCEL_TEXT\")%>"   
                                        onClick="cancel()"/>
                          <uix:button text="<%=eusBundle.getString(\"EUS_SELECT_TEXT\")%>"
                                        shortDesc="<%=eusBundle.getString(\"EUS_SELECT_TEXT\")%>"
                                        onClick="<%=sAddUserJSFunction%>"/>
                        </uix:contents>
                      </uix:pageButtonBar>                       
                    </uix:cellFormat>  
                </uix:rowLayout>
                <%
                if(request.getAttribute("SELECTED_DB_NAME") != null)
                {
                %>
                  <uix:cellFormat>
                      <uix:styledText styleClass="OraInstructionText"
                            text="<%=eusBundle.getString(\"EUS_DATABASE_TEXT\")%>" 
                            shortDesc="<%=eusBundle.getString(\"EUS_DATABASE_TEXT\")%>"/>  
                  </uix:cellFormat>
                  <uix:cellFormat>
                        <uix:styledText textBinding="SELECTED_DB_NAME@servletRequest" 
                                    styleClass="OraDataText"/>                    
                  </uix:cellFormat>
                <%    
                }

                if(request.getAttribute("DB_USERS_SEARCH_PROPERTIES") != null)   
                {

                    Map additionalSearchProperties=(Map)request.getAttribute("DB_USERS_SEARCH_PROPERTIES");
                    Set keySet=additionalSearchProperties.keySet();
                    Iterator iterator=keySet.iterator();
                    while(iterator.hasNext())
                    {
                        
                        String sKey=(String)iterator.next();
                        Object obj=additionalSearchProperties.get(sKey);
                        if(obj instanceof java.util.List)
                        {
                %>
                          <uix:rowLayout>    
                          <uix:cellFormat>
                            <uix:styledText styleClass="OraInstructionText"
                                                text="<%=eusBundle.getString(sKey)%>" 
                                                labeledNodeId="<%=sKey%>"/> 
                          </uix:cellFormat>
                          <uix:cellFormat>
                          <uix:messageChoice name="<%=sKey%>"
                                                id="<%=sKey%>"
                                                shortDesc="<%=eusBundle.getString(sKey)%>">
                            <uix:contents>
                <%
                            List databases=(List)obj;  
                            for(int i=0;i<databases.size();i++)
                            {
                              String sDatabase=(String)databases.get(i);
                              String sSelected="false";
                              if(i==0)
                                  sSelected="true";
                %>
                              <uix:option text="<%=sDatabase%>" 
                                                value="<%=sDatabase%>" 
                                                selected="<%=sSelected%>"
                                                shortDesc="<%=sDatabase%>"/>
                <%
                            }
                %>
                            </uix:contents>
                          </uix:messageChoice>
                          </uix:cellFormat>                          
                          </uix:rowLayout>
                <%       
                        }
                        else if(obj instanceof java.lang.String && 
                                String.valueOf(obj).equals("PASSWORD"))
                        {
                %>
                          <uix:rowLayout >    
                          <uix:cellFormat>
                              <uix:styledText styleClass="OraInstructionText" 
                                                text="<%=eusBundle.getString(sKey)%>" 
                                                labeledNodeId="<%=sKey%>"/> 
                          </uix:cellFormat>
                          <uix:cellFormat>
                              <uix:textInput name="<%=sKey%>" 
                                                id="<%=sKey%>"
                                                required="uiOnly"  
                                                secret="true"
                                                noAutoComplete="true"
                                                shortDesc="<%=eusBundle.getString(sKey)%>"/>
                          </uix:cellFormat>
                          </uix:rowLayout>
                <%
                        }
                        else if(obj==null)
                        {
                %>
                          <uix:rowLayout >    
                          <uix:cellFormat>
                              <uix:styledText styleClass="OraInstructionText" 
                                                    text="<%=eusBundle.getString(sKey)%>"
                                                    labeledNodeId="<%=sKey%>"/> 
                          </uix:cellFormat>
                          <uix:cellFormat>
                              <uix:textInput name="<%=sKey%>" 
                                             id="<%=sKey%>"   
                                             shortDesc="<%=eusBundle.getString(sKey)%>"
                                                required="true"/>
                          </uix:cellFormat>
                          </uix:rowLayout>
                <%
                        }
                    }
                %>
                          <uix:rowLayout >    
                          <uix:cellFormat>
                              <uix:spacer /> 
                          </uix:cellFormat>
                          <uix:cellFormat>
                              <uix:button  onClick="<%=sSearchJSFunction%>" 
                                            text="<%=eusBundle.getString(\"EUS_SEARCH_TEXT\")%>" 
                                            shortDesc="<%=eusBundle.getString(\"EUS_SEARCH_TEXT\")%>"/>
                          </uix:cellFormat>
                          </uix:rowLayout>
                
                
                <%
                    
                }
                %>

            
             
               <uix:rowLayout>
                   <uix:cellFormat columnSpan="2">
                       <uix:dataScope currentDataBinding="EUS_USERS_GROUPS_DATASOURCE@servletRequest">
                         <uix:table name="eusdbusers" 
                                    alternateTextBinding="EUS_NO_ITEMS_FOUND_TEXT@eusMsgs"
                                    width="100%" 
                                     tableDataBinding="rowData" 
                                     minValue="1"
                                     formSubmitted="true"
                                      valueBinding="<%= UIXDataSource.S_START_INDEX_ATTR %>"
                                      blockSizeBinding="<%= UIXDataSource.S_BLOCK_SIZE_ATTR %>"
                                      maxValueBinding="<%= UIXDataSource.S_NUM_ROWS_ATTR %>"
                                      shortDesc=""
                                      summary="">
                                     <uix:tableFormat tableBanding="rowBanding"/>
                                       <%
                                               String sDisplayNameKey="USER_GROUP_NAME";
                                               //String sDisplayNameKey="SUBCOMP_106_COMP_3_COL0";
                                               String sDisplayName =   eusBundle.getString(sDisplayNameKey);
                                               //String sDisplayName = "Name";
                                       %>
                                               <uix:column>
                                                       <uix:columnHeader>
                                                               <uix:sortableHeader text="<%=sDisplayName%>" 
                                                                                    shortDesc="<%=sDisplayName%>" 
                                                                                    sortable="true"/>
                                                       </uix:columnHeader>
                                                       <uix:columnFormat columnDataFormat="textFormat" />
                                                       <uix:styledText textBinding="<%=sDisplayNameKey%>" />
                                               </uix:column>                      
                                 <uix:tableSelection>
                                    <uix:singleSelection selectedIndex="0" textBinding="EUS_SELECT_TEXT@eusMsgs" shortDescBinding="EUS_SELECT_TEXT@eusMsgs">
                                    </uix:singleSelection>
                                 </uix:tableSelection>
                                 
                           </uix:table>
                       </uix:dataScope>
	                 </uix:cellFormat>
	               </uix:rowLayout>
                 
                <uix:rowLayout hAlign="right">
                <uix:cellFormat columnSpan="2">
                      <uix:pageButtonBar>
                        <uix:contents>
                          <uix:button text="<%=eusBundle.getString(\"EUS_CANCEL_TEXT\")%>" 
                                        shortDesc="<%=eusBundle.getString(\"EUS_CANCEL_TEXT\")%>" 
                                        onClick="cancel()"/>
                           <uix:button text="<%=eusBundle.getString(\"EUS_SELECT_TEXT\")%>"
                                        shortDesc="<%=eusBundle.getString(\"EUS_SELECT_TEXT\")%>"
                                        onClick="<%=sAddUserJSFunction%>"/>
                        </uix:contents>
                      </uix:pageButtonBar>   
                 </uix:cellFormat>     
                </uix:rowLayout>
               
                 
                 
	            </uix:tableLayout>   
              </uix:pageLayout>
            </uix:form>
          </uix:body>
      </uix:document>
    </uix:renderingContext>