def teste():
    import pyodbc
    localip = '192.168.0.101'
    database = 'MultM3'
    username = 'sa'
    password = 'ABC*123'
    driver = '{SQL Server}'
    conex = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+localip+';PORT=1433;DATABASE='+database+';UID='+username+';PWD='+ password)
    cur = conex.cursor()
    cur.execute("""
           select   mac.Categoria as 'Categoria',  G.NOME as 'Fornecedor',
        CLA.NOME 'Tipo Fornecedor',A.VALSAL  as 'Valor Aberto',
        A.DATAVCTOSAL as 'Vencimento Prorrogado', D.DOCTODIGITADO as 'Número do Documento',
        H.CODTPDOCTO 'Cód.Tp.Docto',H.DESCRICAO 'Tp. Docto', A.NUMAP as 'Número da AP',
        A.DATAVCTOORI  as 'Dt.Venc.Original', A.VALORIMOE as 'Valor Original ',K.SIMBOLO as 'Moeda',
        A.HISTORICO as 'Histórico', AFC.CONTA AS 'Conta'

            from M3_PARCPA A (NOLOCK)
            INNER JOIN M3_MOVFIN B (NOLOCK) ON B.ID = A.IDA
            INNER JOIN M3_INTEGRA C (NOLOCK) ON C.ID = B.IDF_INTEGRA
            INNER JOIN M3_DOCTO D (NOLOCK) ON D.ID = C.IDF_DOCTO
            INNER JOIN M3_FILIAL E (NOLOCK) ON E.ID = D.IDF_FILIAL
            INNER JOIN MTMG_PAPELREL F (NOLOCK) ON F.ID = E.IDA
            INNER JOIN M3_INDFIN K (NOLOCK) ON K.ID = A.IDF_INDICEFINANC
            INNER JOIN M3_TIPPAG L (NOLOCK) ON L.ID = A.IDF_TIPPAG
            INNER JOIN M3_EMPRESA U (NOLOCK) ON U.ID = E.IDF_EMPRESA
            INNER JOIN MTMG_IDENT G (NOLOCK) ON G.ID = D.IDF_IDENT
            INNER JOIN M3_TIPDOC H (NOLOCK) ON H.ID = D.IDF_TPDOCTO
            left outer Join M3_AUX_CATEGORIA mac (NOLOCK) ON g.ID = mac.ID
            left outer join M3_AUX_FORNECEDOR_CONTA AFC (NOLOCK) ON G.ID = AFC.ID_IDENT
            INNER JOIN MTMG_PAPELREL PPR (NOLOCK) ON G.ID = PPR.IDF_IDENT
            LEFT OUTER JOIN M3_FORNEC FORN (NOLOCK) ON PPR.ID = FORN.IDA
            LEFT OUTER JOIN M3_CATEGORIA CAT (NOLOCK) ON FORN.IDF_CATEGORIA = CAT.ID
            LEFT OUTER JOIN MTMG_CLASSE CLA (NOLOCK) ON CAT.IDA= CLA.ID
            LEFT OUTER JOIN M3_PADRAODOC I (NOLOCK) ON I.ID = H.IDF_PADRAODOCTO
            LEFT OUTER JOIN MTMG_USUA J (NOLOCK) ON J.ID = D.IDF_USUARIO
            LEFT OUTER JOIN M3_AGEBAN M (NOLOCK) ON M.ID = A.IDF_AGEBAN
            LEFT OUTER JOIN MTMG_PAPELREL N (NOLOCK) ON N.ID = M.IDA
            LEFT OUTER JOIN M3_BANCO O (NOLOCK) ON O.ID = M.IDF_BANCO
            LEFT OUTER JOIN MTMG_PAPELREL P (NOLOCK) ON P.ID = O.IDA
            LEFT OUTER JOIN MTMG_IDENT Q (NOLOCK) ON Q.ID = P.IDF_IDENT
            LEFT OUTER JOIN M3_TPDESPUB R (NOLOCK) ON R.ID = A.IDF_TIPODESPESA
            LEFT OUTER JOIN M3_AUTODESEMB S (NOLOCK) ON S.ID = A.IDF_AUTORIZADESEMBOLSO
            LEFT OUTER JOIN M3_FORMAPAGTO T (NOLOCK) ON T.ID = A.IDF_FORMAPAGTO

            WHERE a.SITUACAO IN ('0','1')

          ORDER BY g.NOME
           """)

    Query = cur.fetchall()
    QueryList = [x for x in Query]
    rows = QueryList
    total_3 = sum([r[3] for r in rows])
    total_10 = sum([r[10] for r in rows])
    return dict(rows=rows, total_3=total_3, total_10=total_10)