<%--
  -- Page:        revsumminc.jspf
  -- Included by: reviewRec.jsp
  -- Controller:  oracle.sysman.db.util.SqlAccessController
  --
  -- Description: Displays summary of task results
  --
  --  MODIFIED    (MM/DD/YY)
  --     misun     03/06/07 - fix SQL Access Advisor UI Exit Review bugs.
  --     misun     01/05/07 - XbranchMerge misun_bug-5675432 from main
  --     misun     12/14/06 - fix bug 5675432
  --     misun     11/20/06 - add the partitioned summary for tables
  --     misun     09/29/06 - fix bug 5485765
  --     misun     07/31/06 - Add new features: 17610 SQL Advisor - SAA
  --                          Enhancement 11gR1.
  --     mpawelko  05/16/05 - bug 4372883: show sql not associated with recs 
  --     mpawelko  03/28/05 - add PPR for Hide/Show headers 
  --     mpawelko  10/16/04 - don't hardcode url prefix in images 
  --     mpawelko  08/07/04 - use 2 bars on wkld io graph 
  --     mpawelko  07/31/04 - add latest server team adjustments 
  --     mpawelko  07/24/04 - impl new charts (after server review) 
  --     mpawelko  07/10/04 - make server team edits 
  --     mpawelko  07/05/04 - mpawelko_add_aa_summary_page
  --     mpawelko  05/24/04 - created 
  --%>

<uix:stackLayout>
  <uix:header textBinding= "SUMM_WKLDPERF@AAMsgs">
  <uix:spacer height="10"/>

  <%-- OVERALL WORKLOAD PERFORMANCE --%>
  <uix:rowLayout>

    <uix:switcher childNameBinding ="summStatusIndicator@objectBean@servletRequest" 
                  renderedBinding="isNotEvalOnly@objectBean@servletRequest" >
      <uix:case name="0" >   
        <uix:flowLayout>
          <uix:image id="icon0" shortDescBinding="SUMM_SUCCESS@AAMsgs"
                sourceBinding="successIcon@objectBean@servletRequest" />
          <uix:spacer width="5"/>
           <uix:styledText textBinding= "SUMM_WKLDGREEN@AAMsgs" styleClass="OraInstructionTextStrong" />
        </uix:flowLayout>
      </uix:case>

      <uix:case name="1" >   
        <uix:flowLayout>
          <uix:image id="icon1" shortDescBinding="SUMM_WARNING@AAMsgs"
                sourceBinding="infoIcon@objectBean@servletRequest" />
          <uix:spacer width="5"/>
          <uix:styledText textBinding= "SUMM_WKLDYELLOW@AAMsgs" styleClass="OraInstructionTextStrong" />
        </uix:flowLayout>
      </uix:case>

      <uix:case name="2" >   
        <uix:flowLayout>
          <uix:image id="icon2" shortDescBinding="SUMM_FAILURE@AAMsgs"
                sourceBinding="failureIcon@objectBean@servletRequest" />
          <uix:spacer width="5"/>
          <uix:styledText textBinding= "SUMM_WKLDRED@AAMsgs" styleClass="OraInstructionTextStrong" />
        </uix:flowLayout>
      </uix:case>
    </uix:switcher>

    <uix:messageStyledText styleClass="OraDataText"
                           messageType="info" 
                           textBinding="EVAL_ONLY_MODE@AAMsgs"
                           renderedBinding="isEvalOnly@objectBean@servletRequest" />

  </uix:rowLayout>
  </uix:header>

  <uix:spacer height="10" />

  <uix:tableLayout>
    <uix:rowLayout>
      <uix:cellFormat vAlign="top" hAlign="left" width="50%">
        <oem:chart titleBinding="SUMM_WKLD_IO_COST@AAMsgs"
                   shortDescBinding="SUMM_WKLD_IO_COST@AAMsgs"
                   chartType="barChart"
                   width="150"
                   height="150" 
                   showXAxisLabels="false"
                   shadowEffect="3d"
	           legendVisible="external"
                   externalLegendOrientation="vertical"
                   legendPosition="south" >
          <oem:boundChartDataSource chartDataSourceBinding="sqlBreakdownDataSource@objectBean@servletRequest" />
          <oem:imageMap defaultLabel="false" />

          <oem:chartColumn displayLabelBinding="origCostLabel@objectBean@servletRequest" 
                           sourceIndex="0" 
                           itemColor="red" />
          <oem:chartColumn displayLabelBinding="newCostLabel@objectBean@servletRequest" 
                           sourceIndex="1"
                           itemColor="blue" />
        </oem:chart>
      </uix:cellFormat>

      <uix:cellFormat vAlign="top"  hAlign="right" width="50%">
        <oem:chart  titleBinding="SUMM_QUERY_RESP_IMPR@AAMsgs"
                    chartType="barChart"
                    width="450"
                    height="150" 
                    axisMax="100"
                    shadowEffect="3d"
                    stacked="true"
                    legendVisible="external"
                    externalLegendOrientation="vertical"
                    legendPosition="south" 
                    xAxisLabelBinding="SUMM_QUERY_SPEEDUP@AAMsgs"
                    yAxisLabelBinding="SUMM_PERC_WORKLOAD@AAMsgs" >
          <oem:boundChartDataSource chartDataSourceBinding="sqlRangeDataSource@objectBean@servletRequest" />
          <oem:imageMap defaultLabel="true" />
          <oem:chartColumn isKey="true" 
                           displayLabelBinding="SUMM_QUERY_SPEEDUP@AAMsgs"
                           sourceIndex="0" />
          <oem:chartColumn displayLabelBinding="SUMM_SQLIMPR@AAMsgs"
                           sourceIndex="1"
                           itemColor="blue" />
          <oem:chartColumn displayLabelBinding="SUMM_NO_IMPR@AAMsgs"
                           sourceIndex="2"
                           itemColor="gray" />
        </oem:chart>
      </uix:cellFormat>
    </uix:rowLayout>
  </uix:tableLayout >

  <uix:tableLayout>
    <uix:rowLayout>
      <uix:cellFormat vAlign="top" hAlign="left" width="50%">

        <uix:header textBinding= "REVREC_REC@AAMsgs">
          <uix:labeledFieldLayout width="50%" labelWidth="25%">

            <uix:messagePrompt vAlign="top"
                               promptBinding="SUMM_RECTOTAL@AAMsgs" />
            <db:link textBinding="summRecCount@objectBean@servletRequest" 
                     shortDescBinding="SUMM_RECTOTAL@AAMsgs"
                     onClick="submitForm('review', true, {event:'recViewChange2'})"
                     copyParams="target,type,advisoryCentralURL,dbPageNum" />
<%--
            <uix:messageStyledText styleClass="OraDataText" 
                                   promptBinding="SUMM_AVG_COST_REC@AAMsgs"
                                   vAlign="top"
                                   textBinding="summRecImprovement@objectBean@servletRequest" />
            <uix:messageStyledText styleClass="OraDataText" 
                                   promptBinding="SUMM_AVG_COST_WKLD@AAMsgs"
                                   vAlign="top"
                                   textBinding="summWorkloadImprovement@objectBean@servletRequest" />
--%>
            <uix:messageStyledText styleClass="OraDataText" 
                                   promptBinding="summStorageChangeLabel@objectBean@servletRequest"
                                   vAlign="top"
                                   textBinding="summStorageChange@objectBean@servletRequest" />

            <uix:styledText textBinding="SUMM_USER_SPACE_REQ@AAMsgs" 
                            renderedBinding="isNotEvalOnly@objectBean@servletRequest" 
                            styleClass="OraInlineInfoText"  />
            <uix:styledText textBinding="storageSizeMsg@objectBean@servletRequest"  
                            renderedBinding="isNotEvalOnly@objectBean@servletRequest" 
                            styleClass="OraInlineInfoText"  />

          </uix:labeledFieldLayout>

          <uix:hideShow id="recCountHideShow"
                        undisclosedTextBinding="SUMM_SHOW_REC_BKDWN@AAMsgs"
                        disclosedTextBinding="SUMM_HIDE_REC_BKDWN@AAMsgs"
                        disclosedBinding="showRecBreakdown@objectBean@servletRequest"
                        formName="review"
                        partialRenderMode="self"
                        formSubmitted="true" >

            <uix:labeledFieldLayout width="50%" labelWidth="20%" columns="4">
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="ACTION_TYPES_INDEX@AAMsgs"
                                     text=":" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_CREATE@AAMsgs"
                                     textBinding="summICreates@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_DROP@AAMsgs"
                                     textBinding="summIDrops@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_RETAIN@AAMsgs"
                                     textBinding="summIRetains@objectBean@servletRequest" />
              <%--uix:messageStyledText styleClass="OraDataText" 
                                     prompt=""
                                     text="" /--%>

              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="ACTION_TYPES_MVS@AAMsgs"
                                     text=":" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_CREATE@AAMsgs"
                                     textBinding="summMVCreates@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_DROP@AAMsgs"
                                     textBinding="summMVDrops@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_RETAIN@AAMsgs"
                                     textBinding="summMVRetains@objectBean@servletRequest" />
              <%--uix:messageStyledText styleClass="OraDataText" 
                                     prompt=""
                                     text="" /--%>

              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="ACTION_TYPES_MV_LOGS@AAMsgs"
                                     text=":" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_CREATE@AAMsgs"
                                     textBinding="summMVLCreates@objectBean@servletRequest" />
              <%--uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_DROP@AAMsgs"
                                     textBinding="summMVLDrops@objectBean@servletRequest" /--%>
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_RETAIN@AAMsgs"
                                     textBinding="summMVLRetains@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_ALTER@AAMsgs"
                                     textBinding="summMVLAlters@objectBean@servletRequest" />

              <%--uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_REPARTITION@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     text=":" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_TABLES@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summRepartitionTables@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_INDEXES@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summRepartitionIndexes@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_MVS@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summRepartitionMVs@objectBean@servletRequest" /--%>

              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_PARTITIONS@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     text=":" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_TABLES@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summRepartitionTables@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_INDEXES@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summPartitionedIndexes@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     promptBinding="SUMM_MVS@AAMsgs"
                                     renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest"
                                     textBinding="summPartitionedMVs@objectBean@servletRequest" />
              <uix:messageStyledText styleClass="OraDataText" 
                                     prompt=""
                                     text="" />
            </uix:labeledFieldLayout>
          </uix:hideShow>
        </uix:header>
      </uix:cellFormat>

      <uix:cellFormat vAlign="top"  hAlign="right" width="35%">
        <uix:header textBinding= "REVREC_VIEWSQL@AAMsgs">

          <%-- SQL STATEMENT BREAKDOWN --%>
          <uix:stackLayout>
            <uix:flowLayout>
            <uix:messagePrompt vAlign="top"
                               promptBinding="REVREC_VIEWSQL@AAMsgs" />
              <uix:spacer width="10" height="0" />
            <db:link textBinding="summStmtTotal@objectBean@servletRequest" 
                     shortDescBinding="REVREC_VIEWSQL@AAMsgs"
                     onClick="submitForm('review', true, {event:'recViewChange3AllSQL'})"
                     copyParams="target,type,advisoryCentralURL,dbPageNum" />
            </uix:flowLayout>
            <uix:flowLayout>
              <uix:spacer width="8" height="0" />
              <uix:styledText textBinding="SUMM_SQLPROCTIP@AAMsgs" styleClass="OraInlineInfoText" />
            </uix:flowLayout>

            <uix:hideShow id="stmtHideShow"
                          undisclosedTextBinding="SUMM_SHOW_STMT_BKDWN@AAMsgs"
                          disclosedTextBinding="SUMM_HIDE_STMT_BKDWN@AAMsgs"
                          disclosedBinding="showStmtBreakdown@objectBean@servletRequest"
                          formName="review"
                          partialRenderMode="self"
                          formSubmitted="true" >

              <uix:labeledFieldLayout width="75%" labelWidth="20%">
                <uix:messageStyledText styleClass="OraDataText" 
                                       promptBinding="SUMM_INSERT@AAMsgs"
                                       textBinding="summStmtInsert@objectBean@servletRequest" />
                <uix:messageStyledText styleClass="OraDataText" 
                                       promptBinding="SUMM_SELECT@AAMsgs"
                                       textBinding="summStmtSelect@objectBean@servletRequest" />
                <uix:messageStyledText styleClass="OraDataText" 
                                       promptBinding="SUMM_UPDATE@AAMsgs"
                                       textBinding="summStmtUpdate@objectBean@servletRequest" />
                <uix:messageStyledText styleClass="OraDataText" 
                                       promptBinding="SUMM_DELETE@AAMsgs"
                                       textBinding="summStmtDelete@objectBean@servletRequest" />
                <uix:messageStyledText styleClass="OraDataText" 
                                       promptBinding="SUMM_MERGE@AAMsgs"
                                       textBinding="summStmtMerge@objectBean@servletRequest" />
                <%--uix:messageStyledText styleClass="OraDataText" 
                                       renderedBinding="is10gR2OrHigher@objectBean@servletRequest"
                                       promptBinding="SUMM_SKIP_NO_STATS@AAMsgs"
                                       textBinding="summStmtSkipStats@objectBean@servletRequest" /--%>
                <uix:messageStyledText styleClass="OraDataText" 
                                       renderedBinding="is10gR2OrHigher@objectBean@servletRequest"
                                       promptBinding="SUMM_SKIP_NO_PRIVS@AAMsgs"
                                      textBinding="summStmtSkipPrivs@objectBean@servletRequest" />
              </uix:labeledFieldLayout>
            </uix:hideShow>
          </uix:stackLayout>
        </uix:header>
      </uix:cellFormat>
    </uix:rowLayout>
  </uix:tableLayout >
</uix:stackLayout>