<%--
  -- Page:        revsqlinc.jspf
  -- Included by: reviewRec.jsp
  -- Controller:  oracle.sysman.db.util.SqlAccessController
  --
  -- Description: Displays SQL statements improved by task recommendations
  --
  --  MODIFIED    (MM/DD/YY)
  --     mpawelko  05/20/05 - don't render buttons if 0 recs 
  --     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/13/04 - convert wkld table to uix:table 
  --     mpawelko  09/30/04 - change SHOWSCRIPT to SHOWSQL 
  --     mpawelko  08/07/04 - fix destination 
  --     mpawelko  07/26/04 - disable stuff if eval only 
  --     mpawelko  07/10/04 - chart by cost improvement 
  --     mpawelko  07/05/04 - fix charts and titles 
  --     mpawelko  01/01/03 - created 
  --%>

<uix:stackLayout>
  <uix:spacer height="10"/>

  <uix:formValue name="resTab" value="sql" />

  <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="REVSQL_CHARTDESC@AAMsgs" 
                  styleClass="OraFieldText" />
  <oem:chart titleBinding="REVSQL_IMPROVE_PERC@AAMsgs"
             chartType="barChart"
             width="800"
             height="200" 
             orientation="vertical"
             shadowEffect="3d"
             legendVisible="external"
             legendPosition="south" 
             xAxisLabelBinding ="STMT_ID@AAMsgs"
             yAxisLabelBinding ="COST_IMPR@AAMsgs">
    <oem:boundChartDataSource chartDataSourceBinding="sqlBarDataSource@objectBean@servletRequest" />
    <oem:imageMap defaultLabel="true" />
    <oem:chartColumn isKey="true" 
                     displayLabelBinding="STMT_ID@AAMsgs"
                     sourceIndex="0" />
    <oem:chartColumn displayLabelBinding="COST_IMPR@AAMsgs"
                     sourceIndex="1" />
  </oem:chart>
</uix:stackLayout>

  <uix:header textBinding="stmtHeader@objectBean@servletRequest" >

    <uix:checkBox name="showAffectedSQL"
                  checkedBinding="showAffectedSQL@objectBean@servletRequest" 
                  onClick="submitForm('review', true, {'event':'changeShowAffectedSQL'})"
                  shortDescBinding="SQL_STMTS@AAMsgs"
                  textBinding="SQL_STMTS@AAMsgs" />

   <uix:dataScope currentDataBinding="accessWorkloadTableUI@objectBean@servletRequest"> 
      <%-- NOTE: Can't use PPR because chart on page also needs to be updated  --%>
      <uix:table name="accessWorkloadTableUI"
                 formSubmitted="true"
                 width="100%"
                 tableDataBinding="<%= UIXDataSource.S_ROW_DATA_ATTR %>"
                 summaryBinding="REVSQL_CHARTDESC@AAMsgs"
                 minValue="1"
                 valueBinding="<%= UIXDataSource.S_START_INDEX_ATTR %>"
                 maxValueBinding="<%= UIXDataSource.S_NUM_ROWS_ATTR %>"
                 showAll="yes"
                 alternateTextBinding="NO_RECOMMENDATIONS@AAMsgs"
                 blockSizeBinding="<%= UIXDataSource.S_BLOCK_SIZE_ATTR %>" >

         <uix:tableFormat tableBanding="rowBanding"/>

         <%-- Statement ID column (link to full SQL text) --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="STMT_ID@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_SQLID %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="textFormat"/>
           <uix:link textBinding="<%= AccessParameterConstants.S_SQLID_COL %>"	
                     onClickBinding="<%= AccessParameterConstants.S_SQLID_CLICK %>" />
         </uix:column>

         <%-- SQL Statement column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="STATEMENT@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_SQL_TEXT %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="textFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_SQL_TEXT_COL %>" /> 
         </uix:column>

         <%-- Recommendation ID column (link to Actions drilldown) --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="REC_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>

         <%-- Orignal Cost column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="ORIG_COST@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_ORIG_COST %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_ORIG_COST_COL %>" /> 
         </uix:column>

        <%-- New Cost column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="NEW_COST@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_NEW_COST %>"/>

           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_NEW_COST_COL %>" /> 
         </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>

         <%-- Execution Count column --%>
         <uix:column>
           <uix:columnHeader>
             <uix:sortableHeader textBinding="EXEC_COUNT@AAMsgs"
                  sortableBinding="<%= AccessParameterConstants.S_SORT_EXEC %>"/>
           </uix:columnHeader> 
           <uix:columnFormat columnDataFormat="numberFormat"/>
           <uix:styledText textBinding="<%= AccessParameterConstants.S_EXEC_COL %>" /> 
         </uix:column>

         <uix:tableSelection>
           <uix:multipleSelection selectionBinding="sqlSelection@objectBean@servletRequest" 
                                  selectedBinding = "selected" 
                                  disabledBinding = "disabled" 
                                  shortDescBinding="SELECT@AAMsgs" >
             <uix:submitButton textBinding= "IMPLEMENT@AAMsgs" 
                               shortDescBinding="IMPLEMENT@AAMsgs"
                               name="event"
                               renderedBinding="haveAnyRecs@objectBean@servletRequest"
                               disabledBinding="isNotOwnerOrIsEvalOnly@objectBean@servletRequest"
                               value="implement" />
             <uix:spacer width="5"/>
             <uix:submitButton textBinding= "SHOWSQL@AAMsgs" 
                               shortDescBinding="SHOWSQL@AAMsgs"
                               renderedBinding="haveAnyRecs@objectBean@servletRequest"
                               name="event"
                               value="SHOW_SQL" />
           </uix:multipleSelection>
         </uix:tableSelection>
       </uix:table>
    </uix:dataScope>
  </uix:header>

</uix:stackLayout>