<%--
  -- Page:        revrecinc.jspf
  -- Included by: reviewRec.jsp
  -- Controller:  oracle.sysman.db.util.SqlAccessController
  --
  -- Description: Displays task recommendations
  --
  --  MODIFIED    (MM/DD/YY)
  --     misun     10/02/06 - fix bug 5485765
  --     misun     08/04/06 - add action types
  --     mpawelko  05/16/05 - bug 4372883: show wkld sql not associated with 
  --                          recs
  --     mpawelko  05/13/05 - fix oac violations 
  --     mpawelko  03/28/05 - final 10.2 gui review changes 
  --     mpawelko  10/16/04 - don't hardcode url prefix in images 
  --     mpawelko  10/12/04 - convert rec table to uix:table 
  --     mpawelko  10/09/04 - fix copyParams 
  --     mpawelko  09/30/04 - change SHOWSCRIPT to SHOWSQL 
  --     mpawelko  09/07/04 - add icon legend for status column 
  --     mpawelko  08/18/04 - add View Actions event 
  --     mpawelko  08/10/04 - add descriptions in shortDesc 
  --     mpawelko  08/07/04 - fix destination 
  --     mpawelko  07/26/04 - add include retains suppport 
  --     mpawelko  07/10/04 - work on selection 
  --     mpawelko  07/05/04 - fix charts and titles 
  --     mpawelko  01/01/03 - created 
  --%>

<uix:stackLayout>
  <uix:spacer height="10"/>

  <uix:formValue name="resTab" value="rec" />

  <uix:stackLayout renderedBinding="isEvalOnly@objectBean@servletRequest" >
    <uix:spacer height="10"/>
    <uix:messageStyledText styleClass="OraDataText"
                           messageType="info" 
                           textBinding="EVAL_ONLY_MODE@AAMsgs"/>
    <uix:spacer height="10"/>
  </uix:stackLayout>

  <uix:stackLayout renderedBinding="isNotEvalOnly@objectBean@servletRequest" >

  <uix:styledText textBinding="REVREC_RECDESC@AAMsgs" 
                  styleClass="OraFieldText" />

  <%-- Given two queries A and B, where A is executed 100 times and takes 
       30 seconds, and B is executed once and takes 5 seconds.  If R1 
       improves A by 1 second and R2 improves B by 1 second, R1 will be the
       top recommendation in first chart, R2 will be the top recommendation 
       in second chart. --%>
  <oem:chart titleBinding="REVREC_BARTITLE@AAMsgs"
             chartType="barChart"
             width="700"
             height="200" 
             orientation="vertical"
             shadowEffect="3d"
             legendVisible="external"
             legendPosition="south" 
             xAxisLabelBinding ="ID@AAMsgs"
             yAxisLabelBinding ="COST_IMPR@AAMsgs">
    <oem:boundChartDataSource chartDataSourceBinding="recBarDataSource@objectBean@servletRequest" />
    <oem:imageMap defaultLabel="true" />
    <oem:chartColumn isKey="true" 
                     displayLabelBinding="ID@AAMsgs"
                     sourceIndex="0" />
    <oem:chartColumn displayLabelBinding="COST_IMPR@AAMsgs"
                     sourceIndex="1" />
  </oem:chart>

</uix:stackLayout>

    <uix:header textBinding="recHeader@objectBean@servletRequest" >

    <uix:checkBox name="showRetains"
                  checkedBinding="showRetains@objectBean@servletRequest" 
                  onClick="submitForm('review', true, {'event':'changeRetains'})"
                  renderedBinding="isNotEvalOnly@objectBean@servletRequest" 
                  shortDescBinding="SHOW_RETAINS_DESC@AAMsgs"
                  textBinding="SHOW_RETAINS@AAMsgs" />

   <uix:dataScope currentDataBinding="accessRecTableUI@objectBean@servletRequest"> 
      <%-- NOTE: Can't use PPR because chart on page also needs to be updated  --%>
      <uix:table name="accessRecTableUI" 
                 formSubmitted="true"
                 width="100%"
                 tableDataBinding="<%= UIXDataSource.S_ROW_DATA_ATTR %>"
                 minValue="1"
                 valueBinding="<%= UIXDataSource.S_START_INDEX_ATTR %>"
                 maxValueBinding="<%= UIXDataSource.S_NUM_ROWS_ATTR %>"
                 showAll="yes"
                 summaryBinding="REVREC_RECDESC@AAMsgs"
                 alternateTextBinding="NO_RECOMMENDATIONS@AAMsgs"
                 blockSizeBinding="<%= UIXDataSource.S_BLOCK_SIZE_ATTR %>" >

         <uix:tableFormat tableBanding="rowBanding"/>

         <%-- Status column --%>
         <uix:column renderedBinding="is10gR2OrHigher@objectBean@servletRequest">
           <uix:columnHeader>
             <uix:sortableHeader textBinding="STATUS@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_STATUS %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="iconButtonFormat" width="5%"/>
           <uix:image sourceBinding="<%= AccessParameterConstants.S_STATUS_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_STATUS_DESC %>" /> 
         </uix:column>

         <%-- Recommendation ID column (link to Actions drilldown) --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="ID@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_RECID %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="textFormat"/>
           <uix:link textBinding="<%= AccessParameterConstants.S_RECID_COL %>"	
                     onClickBinding="<%= AccessParameterConstants.S_RECID_CLICK %>" />
         </uix:column>

         <%-- Actions column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="ACTIONS@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_ACTION %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_ACTION_COL %>" /> 
         </uix:column>

         <%-- Actions Types --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="ACTION_TYPES@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_ACTION_TYPES %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="iconButtonFormat" width="5%"/>
             <uix:flowLayout>
                <%-- now need to alignment the icons, --%>
                <%-- if there is no some type, it shows a transparent gif icon --%>
               <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_INDEX_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_ACTION_TYPES_INDEX_DESC %>" 
                      hAlign="left" /> 
                      <%-- renderedBinding="<%= AccessParameterConstants.S_HAVE_ACTION_TYPES_INDEX %>" --%>
               <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MVS_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MVS_DESC %>"
                      hAlign="left" /> 
                      <%-- renderedBinding="<%= AccessParameterConstants.S_HAVE_ACTION_TYPES_MVS %>" --%>
               <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MV_LOGS_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MV_LOGS_DESC %>"
                      hAlign="left" /> 
                      <%-- renderedBinding="<%= AccessParameterConstants.S_HAVE_ACTION_TYPES_MV_LOGS %>" --%>
               <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_PARTITIONS_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_ACTION_TYPES_PARTITIONS_DESC %>"
                      hAlign="left" /> 
                      <%-- renderedBinding="<%= AccessParameterConstants.S_HAVE_ACTION_TYPES_PARTITIONS %>" --%>
               <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_OTHERS_COL %>" 
                      shortDescBinding="<%= AccessParameterConstants.S_ACTION_TYPES_OTHERS_DESC %>"
                      hAlign="left" /> 
                      <%-- renderedBinding="<%= AccessParameterConstants.S_HAVE_ACTION_TYPES_OTHERS %>" --%>
             </uix:flowLayout>
        </uix:column>

         <%-- Cost Improvement column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="COST_IMPR@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_COST_IMPR %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_COST_IMPR_COL %>" /> 
         </uix:column>

         <%-- Cost Improvement (%) column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="COST_IMPR_PERC@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_COST_IMPR_PERC %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_COST_IMPR_PERC_COL %>" /> 
         </uix:column>

         <%-- Estimated Space Used column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="SPACE_USAGE@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_SPACE %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_SPACE_COL %>" /> 
         </uix:column>

       <%-- Affected SQL Statements column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="SQL_STMTS@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_STMT %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_STMT_COL %>" /> 
         </uix:column>

         <uix:tableSelection>
           <uix:multipleSelection selectionBinding ="recSelection@objectBean@servletRequest" 
                                  shortDescBinding="SELECT@AAMsgs"
                                  disabledBinding = "disabled" 
                                  selectedBinding = "selected" >
             <uix:submitButton textBinding = "VIEW_REC_DETAILS@AAMsgs" 
                               shortDescBinding="VIEW_REC_DETAILS@AAMsgs"
                               renderedBinding = "haveMultRecs@objectBean@servletRequest" 
                               name="event"
                               value="viewRecDetails" />
             <uix:spacer width="5"/>
             <uix:submitButton textBinding = "IMPLEMENT@AAMsgs" 
                               shortDescBinding="IMPLEMENT@AAMsgs"
                               name="event"
                               disabledBinding="isNotOwnerOrIsEvalOnly@objectBean@servletRequest"
                               value="implement" />
             <uix:spacer width="5"/> 
             <uix:submitButton textBinding = "SHOWSQL@AAMsgs" 
                               shortDescBinding="SHOWSQL@AAMsgs"
                               name="event"
                               value="SHOW_SQL" />
           </uix:multipleSelection>
         </uix:tableSelection>
       </uix:table>
       
        <uix:spacer height="10"/>
        <uix:tip>
            <uix:rowLayout vAlign="center">
                <uix:styledText textBinding="ACTION_TYPES_LEGEND@AAMsgs"  styleClass="OraHeaderSubSub"  />
                <uix:spacer width="5"/>
                
                <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_INDEX_TIP %>" 
                        shortDescBinding="ACTION_TYPES_INDEX@AAMsgs" /> 
                <uix:styledText textBinding="ACTION_TYPES_INDEX@AAMsgs"  styleClass="OraPromptText"  />
                <uix:spacer width="5"/>
                
                <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MVS_TIP %>" 
                        shortDescBinding="ACTION_TYPES_MVS@AAMsgs" /> 
                <uix:styledText textBinding="ACTION_TYPES_MVS@AAMsgs"  styleClass="OraPromptText"  />
                <uix:spacer width="5"/>
                
                <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_MV_LOGS_TIP %>" 
                        shortDescBinding="ACTION_TYPES_MV_LOGS@AAMsgs" /> 
                <uix:styledText textBinding="ACTION_TYPES_MV_LOGS@AAMsgs"  styleClass="OraPromptText"  />
                <uix:spacer width="5"/>

                <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_PARTITIONS_TIP %>" 
                        shortDescBinding="ACTION_TYPES_PARTITIONS@AAMsgs" /> 
                <uix:styledText textBinding="ACTION_TYPES_PARTITIONS@AAMsgs"  styleClass="OraPromptText"  />
                <uix:spacer width="5"/>

                <uix:image sourceBinding="<%= AccessParameterConstants.S_ACTION_TYPES_OTHERS_TIP %>" 
                        shortDescBinding="ACTION_TYPES_OTHERS@AAMsgs" /> 
                <uix:styledText textBinding="ACTION_TYPES_OTHERS@AAMsgs"  styleClass="OraPromptText"  />
            </uix:rowLayout>
        </uix:tip>
    </uix:dataScope>

  </uix:header>           
</uix:stackLayout>