InovacaoMediaBrasil/ProcessWorkflowsAndDatabaseScripts

<gadget>
    <prompt-parameters>
        <parameter id="DATA_INICIAL" description="Data Inicial" metadata="date" required="true" keep-last="true"/>
        <parameter id="DATA_FINAL" description="Data Final" metadata="date" required="true" keep-last="true"/>
    </prompt-parameters>
    <level id="lvl_b3npnt" description="Principal">
        <args>
            <arg id="STATUSNOTA" type="text"/>
        </args>
        <chart id="cht_b3npnu" type="pizza">
            <title>
                <![CDATA[FATURAMENTO NFE]]>
            </title>
            <expression type="sql" data-source="MGEDS">
                <![CDATA[SELECT nfe.STATUSNOTA, SUM(nfe.VLRNOTA) AS VLRNOTA FROM (select DISTINCT GTT.DESCRGRUPOTIPTIT as 'TIPO_DE_TITULO', CAB.NUNOTA, CAB.VLRNOTA, CASE WHEN CAB.STATUSNFE = 'A' THEN 'APROVADO' ELSE 'ERRO' END AS STATUSNOTA, cab.VLRFRETE from TGFCAB cab inner join TGFFIN fin on (fin.nunota = cab.AD_PEDORIGINAL) inner join TGFTPV tpv on (cab.CODTIPVENDA = tpv.CODTIPVENDA) inner join TGFTIT tit on (tit.CODTIPTIT = fin.CODTIPTIT) INNER JOIN TGFGTT GTT ON (TIT.CODGRUPOTIPTIT = GTT.CODGRUPOTIPTIT) where cab.CODTIPOPER = 550 AND CAB.DTNEG >= :DATA_INICIAL AND CAB.DTNEG <= :DATA_FINAL) as nfe group by nfe.STATUSNOTA]]>
            </expression>
            <metadata>
                <field name="STATUSNOTA" label="STATUSNOTA" type="S" visible="true" useFooter="false"/>
                <field name="VLRNOTA" label="VLRNOTA" type="F" visible="true" useFooter="false" mask="R$ #.##0,00"/>
            </metadata>
            <series>
                <serie type="pizza">
                    <field>VLRNOTA</field>
                    <nameField>STATUSNOTA</nameField>
                    <on-click navigate-to="lvl_b3npnw">
                        <param id="STATUSNOTA">$STATUSNOTA</param>
                    </on-click>
                </serie>
            </series>
        </chart>
    </level>
    <level id="lvl_b3npnw" description="TÍTULO">
        <args>
            <arg id="STATUSNOTA" type="text"/>
        </args>
        <chart id="cht_b3npn2" type="pizza">
            <title>
                <![CDATA[TIPO DE TÍTULO]]>
            </title>
            <expression type="sql" data-source="MGEDS">
                <![CDATA[SELECT nfe.TIPO_DE_titulo, SUM(nfe.VLRNOTA) AS VLRNOTA FROM (select DISTINCT GTT.DESCRGRUPOTIPTIT as 'TIPO_DE_TITULO', CAB.NUNOTA, CAB.VLRNOTA, CASE WHEN CAB.STATUSNFE = 'A' THEN 'APROVADO' ELSE 'ERRO' END AS STATUSNOTA, cab.VLRFRETE from TGFCAB cab inner join TGFFIN fin on (fin.nunota = cab.AD_PEDORIGINAL) inner join TGFTPV tpv on (cab.CODTIPVENDA = tpv.CODTIPVENDA) inner join TGFTIT tit on (tit.CODTIPTIT = fin.CODTIPTIT) INNER JOIN TGFGTT GTT ON (TIT.CODGRUPOTIPTIT = GTT.CODGRUPOTIPTIT) where cab.CODTIPOPER = 550 AND CAB.DTNEG >= :DATA_INICIAL AND CAB.DTNEG <= :DATA_FINAL) as nfe WHERE NFE.STATUSNOTA = :STATUSNOTA group by nfe.TIPO_DE_TITULO]]>
            </expression>
            <metadata>
                <field name="TIPO_DE_titulo" label="TIPO_DE_titulo" type="S" visible="true" useFooter="false"/>
                <field name="VLRNOTA" label="VLRNOTA" type="F" visible="true" useFooter="false" mask="R$ #.##0,00"/>
            </metadata>
            <series>
                <serie type="pizza">
                    <field>VLRNOTA</field>
                    <nameField>TIPO_DE_titulo</nameField>
                </serie>
            </series>
        </chart>
    </level>
</gadget>