Receitas Mensais

Código Tirado em: https://github.com/rafael-rfzorzi/receitas_mensais/blob/master/receitas_manuais.py


from tkinter import *
from tkinter import ttk
import sqlite3
from datetime import *

root = Tk()
class Funcs():
    def conectabd(self):
        self.conn = sqlite3.connect("receita_manual.db")
        self.cursor = self.conn.cursor()
    def desconectabd(self):
        self.conn.close()
    def montaTabelas(self):
        self.conectabd();
        print("Conectando ao banco de dados")
        ### Cria tabela servprod
        self.cursor.execute("""
            CREATE TABLE IF NOT EXISTS receitas (
                cod INTEGER PRIMARY KEY,
                obs CHAR(200),
                entrada FLOAT(2,2),
                saida FLOAT(2,2),
                dia INTEGER(4),
                mes INTEGER(4) NOT NULL,
                ano INTEGER(6) NOT NULL
             );
         """)
        self.conn.commit();
        print("banco de dados ja criado")
        self.desconectabd();
        print("desconectando ao banco de dados")
    def limpa_tela(self):
        self.input_ano.delete(0, END)
        self.inp_dia.delete(0, END)
        self.inp_mes.delete(0, END)
        self.inp_obs.delete(0, END)
        self.inp_saida.delete(0, END)
        self.inp_entrada.delete(0, END)

        self.input_ano.insert(END, self.hj.year)
        self.inp_dia.insert(END, self.hj.day)
        self.inp_mes.insert(END, self.hj.month)
        self.inp_obs.insert(END, "")
        self.inp_saida.insert(END, "00.00")
        self.inp_entrada.insert(END, "00.00")

    def variaveis(self):
        self.ano = self.input_ano.get()
        self.dia = self.inp_dia.get()
        self.mes = self.inp_mes.get()
        self.obs = self.inp_obs.get()
        self.entrada = self.inp_entrada.get()
        self.saida = self.inp_saida.get()
    def add_mov(self):
        self.conectabd()
        self.variaveis()

        self.cursor.execute("""
             INSERT INTO receitas ( obs, entrada, saida, dia, mes, ano)
             VALUES ( ?, ?, ?, ?, ?, ?)""",
                            (self.obs, self.entrada, self.saida, self.dia, self.mes, self.ano))
        self.conn.commit()

        self.desconectabd()
        self.select_lista()
        self.limpa_tela()
    def select_lista(self):
        mes_lista = self.inp_mes_selecionar.get()
        ano_lista = self.inp_ano_selecionar.get()

        self.lista.delete(*self.lista.get_children())
        self.conectabd()
        lista = self.cursor.execute("""SELECT  entrada, saida, dia, mes , ano, obs FROM receitas
            WHERE mes = '%s' and ano = '%s' ORDER BY dia ASC; """ % (mes_lista, ano_lista))

        for i in lista:
            self.lista.insert("", END, values=i)

        self.entradas_totais.delete(0, END)
        lista2 = self.cursor.execute("""SELECT  SUM(entrada) FROM receitas
                    WHERE mes = '%s' and ano = '%s' ORDER BY dia ASC; """ % (mes_lista, ano_lista))


        for i in lista2:
            self.entradas_totais.insert(END, i)

            self.saidas_totais.delete(0, END)
            lista3 = self.cursor.execute("""SELECT  SUM(saida) FROM receitas
                            WHERE mes = '%s' and ano = '%s' ORDER BY dia ASC; """ % (mes_lista, ano_lista))

        for i in lista3:
           self.saidas_totais.insert(END, i)

        self.saldo_total.delete(0, END)
        lista3 = self.cursor.execute("""SELECT  (SUM(entrada) - SUM(saida)) FROM receitas
                                    WHERE mes = '%s' and ano = '%s' ORDER BY dia ASC; """ % (mes_lista, ano_lista))
        for i in lista3:
          self.saldo_total.insert(END, i)
          self.desconectabd()
    def deletaItem(self, event):
        self.lista.selection()
        for n in self.lista.selection():
            col1, col2, col3, col4, col5, col6 = self.lista.item(n, 'values')
            self.conectabd()
            self.cursor.execute("""DELETE FROM receitas WHERE entrada = ? AND saida = ? 
                AND dia = ? AND mes = ? AND ano = ? AND obs = ?""", (col1, col2, col3, col4, col5, col6))

            self.conn.commit()
            self.desconectabd()
            self.select_lista()

class Application(Funcs):
    def __init__(self):
        self.hj = date.today()
        self.root = root
        self.tela()
        self.frames()
        self.widgets()
        self.lista_receitas()
        self.montaTabelas()
        self.limpa_tela()
#        self.select_lista()
        self.root.mainloop()
    def tela(self):
        self.root.title("Receitas manuais - RfZorzi")
        self.root.configure(background= "lightgray");
        self.root.geometry("1000x600")
        self.root.resizable(TRUE, TRUE);
        self.root.minsize(width=800, height=500)

    def frames(self):
        ###     Primeiro Container da janela
        top = Frame(self.root, bd=2, bg="#383847", highlightbackground='gray65', highlightthickness=1, relief = 'ridge')
        top.place(relx=0.02, rely=0.02, relwidth=0.96, relheight=0.1)
        self.top = top
        ###     Segundo Container da janela
        top2 = Frame(self.root, bd=2, bg='#383847', highlightbackground='gray65', highlightthickness=1, relief = 'ridge')
        top2.place(relx=0.15, rely=0.16, relwidth=0.83, relheight=0.1)
        self.top2 = top2
        ###     Terceiro Container da janela
        top3 = Frame(self.root, bd=2, bg='white', highlightbackground='gray65', highlightthickness=1, relief = 'ridge')
        top3.place(relx=0.02, rely=0.26, relwidth=0.96, relheight=0.5)
        self.top3 = top3
        ###     Quarto Container da janela
        top4 = Frame(self.root, bd=2, bg='#383847', highlightbackground='gray65', highlightthickness=1, relief = 'ridge')
        top4.place(relx=0.02, rely=0.78, relwidth=0.96, relheight=0.2)
        self.top4 = top4
    def widgets(self):
        self.lb_entrada = Label(self.top, text='Entrada', bg='#383847', fg='white', font=('dyuthi', 10, 'bold'))
        self.lb_entrada.place(relx= 0.05, rely=0.15, relwidth= 0.07)

        self.inp_entrada = Entry(self.top, fg='gray35')
        self.inp_entrada.place(relx=0.05, rely=0.5, relwidth= 0.07)

        self.lb_saida = Label(self.top, text='Saida', bg='#383847', fg='white', font=('dyuthi', 10, 'bold'))
        self.lb_saida.place(relx=0.15, rely=0.15, relwidth= 0.07)

        self.inp_saida = Entry(self.top, fg='gray35')
        self.inp_saida.place(relx=0.15, rely=0.5, relwidth=0.07)

        self.lb_dia = Label(self.top, text = 'Dia', bg='#383847', fg='lightgray',
                            font=('verdana', 9, 'bold')).place(relx=0.35, rely=0.15, relwidth= 0.04)
        self.inp_dia = Entry(self.top, fg='gray35')
        self.inp_dia.place(relx=0.35, rely=0.5, relwidth=0.04)

        self.lb_mes = Label(self.top, text = 'Mês', bg='#383847', fg='lightgray',
                            font=('verdana', 9, 'bold')).place(relx=0.4, rely=0.15, relwidth= 0.04)
        self.inp_mes = Entry(self.top, fg='gray35')
        self.inp_mes.place(relx=0.4, rely=0.5, relwidth=0.04)

        self.lb_ano = Label(self.top, text = 'Ano', bg='#383847', fg='lightgray',
                            font=('verdana', 10, 'bold')).place(relx=0.45, rely=0.15, relwidth= 0.04)
        self.input_ano = Entry(self.top, fg='gray35')
        self.input_ano.place(relx=0.45, rely=0.5, relwidth=0.07)

        self.lb_obs = Label(self.top, text = 'Obs:', bg='#0e76a8', fg='lightgray',
                            font=('dyuthi', 10, 'bold')).place(relx=0.55, rely=0.15, relwidth= 0.07)
        self.inp_obs = Entry(self.top, fg='gray35')
        self.inp_obs.place(relx=0.55, rely=0.5, relwidth=0.3)

        self.bt_inserir = Button(self.top, text= 'Inserir', bg= "#0e76a8",bd = 1, highlightbackground='lightgray',
                    highlightthickness=1, fg="lightgray", font=('verdana', 12, 'bold'),
                    activebackground="#108ecb", activeforeground= "white", command= self.add_mov)
        self.bt_inserir.place(relx=0.9, rely=0.2, relwidth=0.09, relheight=0.6)
        #####

        self.mes_listaLb = Label(self.top2, text= 'Mês', bg= 'gray', fg= 'lightgray',
                                 font=('Verdana', '7', 'bold'))
        self.mes_listaLb.place(relx=0.05, rely=0.19, relwidth=0.05, relheight=0.62)
        self.inp_mes_selecionar = Entry(self.top2, fg='gray35',)
        self.inp_mes_selecionar.place(relx=0.13, rely=0.2, relwidth=0.05,relheight =0.6)



        self.ano_listaLb = Label(self.top2, text='Ano', bg='gray', fg='lightgray',
                                 font=('Verdana', '7', 'bold'))
        self.ano_listaLb.place(relx=0.2, rely=0.19, relwidth=0.05, relheight=0.62)

        self.inp_ano_selecionar = Entry(self.top2, fg='gray35',)
        self.inp_ano_selecionar.place(relx=0.28, rely=0.2, relwidth=0.05,relheight =0.6)


        #command = self.select_lista
        self.bt_select_month = Button(self.top2, text='Seleciona', bg="#0e76a8", bd=1, highlightbackground='lightgray',
                highlightthickness=1, fg="lightgray", font=('verdana', 12, 'bold'), activebackground="#108ecb",
                activeforeground="white")
        self.bt_select_month.place(relx=0.65, rely=0.2, relwidth=0.3, relheight=0.6)

        self.entradas_totaisLb = Label(self.top4, text= 'Total Entrada')
        self.entradas_totaisLb.place(relx=0.08, rely=0.1, relwidth=0.12)
        self.entradas_totais = Entry(self.top4)
        self.entradas_totais.place(relx=0.08, rely=0.3, relwidth= 0.12)

        self.saidas_totaisLb = Label(self.top4, text = 'Total Saida')
        self.saidas_totaisLb.place(relx=0.23, rely=0.1, relwidth=0.12)
        self.saidas_totais = Entry(self.top4)
        self.saidas_totais.place(relx=0.23, rely=0.3, relwidth=0.12)

        self.saldo_totalLb = Label(self.top4, text= 'Saldo')
        self.saldo_totalLb.place(relx=0.68, rely=0.1, relwidth=0.12)
        self.saldo_total = Entry(self.top4)
        self.saldo_total.place(relx=0.68, rely=0.3, relwidth=0.12)
    def lista_receitas(self):
        self.barra = Scrollbar(self.top3, orient='vertical')#, command=self.OnVsb_Orc2)
        self.barra.place(relx=0.98, rely=0.01, relwidth=0.02, relheight=0.97)

        self.lista = ttk.Treeview(self.top3, height=10, yscrollcommand=self.barra.set,
                                           column=("col1", "col2", "col3", "col4", "col5", "col6"))

        self.lista.heading("#0", text="")
        self.lista.heading("#1", text="Entrada")
        self.lista.heading("#2", text="Saida")
        self.lista.heading("#3", text="Dia")
        self.lista.heading("#4", text="Mes")
        self.lista.heading("#5", text="Ano")
        self.lista.heading("#6", text="Obs")
        self.lista.column("#0", width=1)
        self.lista.column("#1", width=100)
        self.lista.column("#2", width=100)
        self.lista.column("#3", width=40)
        self.lista.column("#4", width=40)
        self.lista.column("#5", width=60)
        self.lista.column("#6", width=210)
        self.lista.place(relx=0.0, rely=0.01, relwidth=0.98, relheight=0.94)
        self.lista.configure(yscroll=self.barra.set)
        self.lista.bind('<Delete>', self.deletaItem)
Application()

 

Comentários

Enviar um comentário

Mensagens populares deste blogue

Criar Cartões de Visita

import tkinter as tk from PIL import Image , ImageDraw , ImageFont def criar_cartao (): nome = nome_entry.get() cargo = cargo_entry.get() empresa = empresa_entry.get() telefone = telefone_entry.get() email = email_entry.get() cartao = Image.new( "RGB" , ( 300 , 200 ) , "white" ) draw = ImageDraw.Draw(cartao) texto = f"Nome: { nome }\n Cargo: { cargo }\n Empresa: { empresa }\n Telefone: { telefone }\n Email: { email } " draw.text(( 10 , 10 ) , texto , fill = "black" ) cartao.show() root = tk.Tk() root.title( "Criar Cartões de Visita" ) tk.Label(root , text = "Nome:" ).grid( row = 0 , column = 0 , padx = 5 , pady = 5 ) nome_entry = tk.Entry(root) nome_entry.grid( row = 0 , column = 1 , padx = 5 , pady = 5 ) tk.Label(root , text = "Cargo:" ).grid( row = 1 , column = 0 , padx = 5 , pady = 5 ) cargo_entry = tk.Entry(root) cargo_entry.grid( row = 1 , column = 1 , padx = 5 , pady = 5 ...
Ler mais

12 signos egípcios

from datetime import datetime from tkinter import * root = Tk() root.geometry( "700x400" ) root.resizable( 0 , 0 ) root.config( bg = "#103030" ) root.title( "12 signos egípcios" ) titulo = Label( text = "12 signos egípcios" , font =( "Arial" , 28 , "bold" ) , bg = "#103030" , fg = "#49e3e3" ) titulo.place( relx = 0.25 , rely = 0.05 ) texto_sub1 = Label( text = "Data de Nascimento (dd-mm-YYYY) :" , font =( "Arial" , 18 , "bold" ) , bg = "#103030" , fg = "#49e3e3" ) texto_sub1.place( relx = 0.05 , rely = 0.32 ) Data = StringVar() Data_entrada = Entry( textvariable =Data , font =( "Arial" , 12 , "bold" ) , bg = "white" , fg = "blue" , justify = 'center' ) Data_entrada.place( relx = 0.65 , rely = 0.33 , relwidth = 0.31 ) resultado_texto = L...
Ler mais

Calcular a percentagem de ocupação

from tkinter import * def apenas_numeros (texto): return texto.isdigit() or texto == "" def classificar_ocupacao (percentagem): if percentagem <= 25 : return "Muito baixa" , "#8B0000" elif percentagem <= 50 : return "Baixa" , "#FF6347" elif percentagem <= 75 : return "Média" , "#FFFACD" elif percentagem <= 90 : return "Alta" , "#90EE90" else : return "Muito alta" , "#006400" def limpar (): Numero_camas_ocupadas_entrada.delete( 0 , END) Numero_total_entrada.delete( 0 , END) resultado_texto.config( text = "" , bg = "#cfe2f3" ) Numero_total_entrada.focus() def app (): try : total = int (Numero_total.get()) ocupadas = int (Numero_camas_ocupadas.get()) if total <= 0 : mensagem = "O número total de camas deve ser maior que zer...
Ler mais