InovacaoMediaBrasil/ProcessWorkflowsAndDatabaseScripts

<gadget>
    <prompt-parameters>
        <parameter id="DATAINI" description="1. Data Inicial" metadata="date" required="true" keep-last="true"/>
        <parameter id="DATAFIM" description="2. Data Final" metadata="date" required="true" keep-last="true"/>
    </prompt-parameters>
    <level id="lvl_a1hha2h" description="Principal">
        <container orientacao="V" tamanhoRelativo="100">
            <grid id="grd_a1hha2i">
                <expression type="sql" data-source="MGEDS">
                    <![CDATA[SELECT TGFCAB.NUNOTA,   TGFCAB.DTNEG,   TGFITE.CODPROD,   DESCRPROD + ISNULL(' - ' + COMPLDESC, '')  AS DESCRPROD,   CAST(SUM(QTDNEG - QTDENTREGUE) AS VARCHAR) + ' ' + CAST(TGFPRO.CODVOL AS VARCHAR) AS qtdpendente,   SUM((QTDNEG - QTDENTREGUE) * CUSTO) as Custo FROM SANKHYA.TGFITE WITH (NOLOCK)   INNER JOIN SANKHYA.TGFCAB WITH (NOLOCK) ON TGFCAB.NUNOTA = TGFITE.NUNOTA   INNER JOIN SANKHYA.TGFPRO WITH (NOLOCK) ON TGFPRO.CODPROD = TGFITE.CODPROD WHERE TGFCAB.DTNEG BETWEEN :DATAINI AND :DATAFIM   AND TGFITE.QTDENTREGUE < TGFITE.QTDNEG   AND CODTIPOPER = 250   AND TGFCAB.CODVEND = :CODVEN_LOG   AND TGFCAB.STATUSNOTA = 'L'   AND TGFITE.USOPROD = 'R' GROUP BY TGFCAB.NUNOTA, TGFCAB.DTNEG, TGFPRO.CODVOL, TGFITE.CODPROD, TGFPRO.DESCRPROD, TGFPRO.COMPLDESC]]>
                </expression>
                <metadata>
                    <field name="NUNOTA" label="Nro. Unico" type="I" visible="true" useFooter="false"/>
                    <field name="DTNEG" label="Data de Negociação" type="D" visible="true" useFooter="false"/>
                    <field name="CODPROD" label="Código" type="I" visible="true" useFooter="false"/>
                    <field name="DESCRPROD" label="Produto" type="S" visible="true" useFooter="false"/>
                    <field name="qtdpendente" label="Quantidade Pendente" type="S" visible="true" useFooter="false"/>
                    <field name="Custo" label="Custo Total" type="I" visible="true" useFooter="true"/>
                </metadata>
                <on-click-launcher resource-id="br.com.sankhya.com.mov.CentralNotas">
                    <NUNOTA>$NUNOTA</NUNOTA>
                </on-click-launcher>
            </grid>
        </container>
    </level>
</gadget>