Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --SELECT tipo_documento, SUM(vl_entrada) vl_entrada, SUM(vl_saida) vl_saida FROM (
- SELECT
- HISTORICO_COMPLETO,
- V.CONTROLE,
- CASE
- WHEN historico_COMPLETO LIKE '%CHEQUE%' THEN 'CHEQUE_AP'
- WHEN historico_COMPLETO LIKE '%DEPOSITO%' THEN 'DEPOSITO'
- WHEN historico_COMPLETO LIKE '%CARTAO%' THEN 'CARTAO'
- WHEN historico_COMPLETO LIKE '%VALE-PRESENTE%' THEN 'VALE-PRESENTE'
- WHEN historico_COMPLETO LIKE '%BOLETO%' THEN 'BOLETO'
- WHEN historico_COMPLETO LIKE '%CHEQUE%' AND historico_COMPLETO LIKE '%/00%' THEN 'CHEQUE_AV'
- WHEN historico_COMPLETO LIKE '%DUPLICATA%' THEN 'DUPLICATA'
- ELSE 'DINHEIRO' END TIPO_DOCUMENTO,
- CREDITO VL_ENTRADA, DEBITO VL_SAIDA
- FROM (
- SELECT * FROM MCAIXA
- WHERE (CAST(EMISSAO||' '||(CASE CHAR_LENGTH(hora) WHEN 5 THEN hora||':59' ELSE hora END) AS TIMESTAMP)
- BETWEEN '02/21/2018 16:27' AND '02/23/2018 11:14')
- AND STATUS<>'EXCLUIDO'
- AND USUARIO='CAIXA'
- ) M
- LEFT JOIN RECEBER R ON (R.CONTROLE=M.CONTROLE AND R.EMPRESA=M.EMPRESA AND R.DOCUMENTO=M.DOCUMENTO )
- LEFT JOIN VENDA V ON (R.CONTROLE=V.CONTROLE AND R.EMPRESA=V.EMPRESA) AND R.CNPJ_CPF=V.CNPJ_CPF
- --) GROUP BY tipo_documento
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement