InovacaoMediaBrasil/ProcessWorkflowsAndDatabaseScripts

<gadget>
    <prompt-parameters>
        <parameter id="CONTEM" description="Nome do kit contém:" metadata="text" required="false" keep-last="false" keep-date="false" order="0"/>
        <parameter id="NAOCONTEM" description="Nome do kit não contém:" metadata="text" required="false" keep-last="false" keep-date="false" order="1"/>
    </prompt-parameters>
    <level id="lvl_a7ulduh" description="Principal">
        <container orientacao="V" tamanhoRelativo="100">
            <grid id="grd_a7uldui">
                <expression type="sql" data-source="MGEDS">
                    <![CDATA[select icp.codprod, RTRIM(sankhya.FN_CONCATENANOMEPRODUTO(ICP.CODPROD)) AS NOME, min((ISNULL(EST.ESTOQUE,0)-ISNULL(EST.RESERVADO,0))/QTDMISTURA) AS SALDO  from sankhya.TGFICP ICP with(nolock)  inner join sankhya.TGFPRO KIT WITH(NOLOCK) ON KIT.CODPROD = ICP.CODPROD  INNER JOIN sankhya.TGFPRO PRO WITH(NOLOCK) ON PRO.CODPROD = ICP.CODMATPRIMA  LEFT join sankhya.TGFEST EST ON EST.CODPROD = ICP.CODMATPRIMA  where icp.codprod IN (select codprod from sankhya.TGFPRO WITH(NOLOCK) WHERE ATIVO = 'S' AND CODVOL = 'KT')  AND ((:NAOCONTEM IS NULL) OR (:NAOCONTEM IS NOT NULL AND sankhya.FN_CONCATENANOMEPRODUTO(ICP.CODPROD) NOT LIKE '%' + :NAOCONTEM + '%'))  AND ((:CONTEM IS NULL) OR (:CONTEM IS NOT NULL AND sankhya.FN_CONCATENANOMEPRODUTO(ICP.CODPROD) LIKE '%' + :CONTEM + '%'))  group by icp.codprod  order by SALDO DESC]]>
                </expression>
                <metadata>
                    <field name="codprod" label="Código do Produto" type="I" visible="true" useFooter="false"/>
                    <field name="NOME" label="Nome do Produto" type="S" visible="true" useFooter="false"/>
                    <field name="SALDO" label="Saldo Real" type="I" visible="true" useFooter="false"/>
                </metadata>
                <on-click navigate-to="lvl_aa4ggdq">
                    <param id="CODPROD">$codprod</param>
                    <param id="NOME">$NOME</param>
                </on-click>
            </grid>
        </container>
    </level>
    <level id="lvl_aa4ggdq" description="2o nivel">
        <args>
            <arg id="CODPROD" type="integer"/>
            <arg id="NOME" type="text"/>
        </args>
        <container orientacao="V" tamanhoRelativo="100">
            <grid id="grd_aa4ggds">
                <title>
                    <![CDATA[SALDO DO PRODUTO [:CODPROD] :NOME]]>
                </title>
                <expression type="sql" data-source="MGEDS">
                    <![CDATA[SELECT PRO.CODPROD,   RTRIM(PRO.DESCRPROD)+' '+ isnull(RTRIM(PRO.COMPLDESC),'') AS produto,   ICP.CODVOL,   ICP.QTDMISTURA AS QTDNOKIT,   ISNULL(PRO.AD_PESTNEG,'N') AS ESTOQUENEGATIVO,   ISNULL(EST.ESTOQUE,0) AS ESTOQUE,    ISNULL(EST.RESERVADO,0) AS RESERVADO,   ISNULL((EST.ESTOQUE-EST.RESERVADO), 0) AS SALDOTOTAL,   FLOOR(ISNULL((EST.ESTOQUE-EST.RESERVADO), 0) /QTDMISTURA) AS SALDOPARAOKIT FROM sankhya.TGFICP ICP WITH (NOLOCK)   INNER JOIN sankhya.TGFPRO PRO WITH (NOLOCK) ON ICP.CODMATPRIMA = PRO.CODPROD   LEFT JOIN sankhya.TGFEST EST WITH (NOLOCK) ON EST.CODPROD = PRO.CODPROD WHERE ICP.CODPROD = :CODPROD]]>
                </expression>
                <metadata>
                    <field name="CODPROD" label="CODPROD" type="I" visible="true" useFooter="false"/>
                    <field name="produto" label="produto" type="S" visible="true" useFooter="false"/>
                    <field name="CODVOL" label="CODVOL" type="S" visible="true" useFooter="false"/>
                    <field name="QTDNOKIT" label="QTDNOKIT" type="F" visible="true" useFooter="false"/>
                    <field name="ESTOQUENEGATIVO" label="ESTOQUENEGATIVO" type="S" visible="true" useFooter="false"/>
                    <field name="ESTOQUE" label="ESTOQUE" type="F" visible="true" useFooter="false"/>
                    <field name="RESERVADO" label="RESERVADO" type="F" visible="true" useFooter="false"/>
                    <field name="SALDOTOTAL" label="SALDOTOTAL" type="F" visible="true" useFooter="false"/>
                    <field name="SALDOPARAOKIT" label="SALDOPARAOKIT" type="F" visible="true" useFooter="false"/>
                </metadata>
            </grid>
        </container>
    </level>
</gadget>