# https://www.youtube.com/watch?v=RtrZcoVD1WM&list=PLqx8fDb-FZDFznZcXb_u_NyiQ7Nai674-
# sudo apt install python3-tk
# se nomear o file como tkinter.py (erro NameError: name 'Tk' is not defined)
# T do Tk() e L do Label(win... maisculos.
from tkinter import *
from tkinter import ttk
import sqlite3
from reportlab.pdfgen import canvas
from reportlab.lib.pagesizes import letter, A4
from reportlab.pdfbase import pdfmetrics
from reportlab.pdfbase.ttfonts import TTFont
from reportlab.platypus import SimpleDocTemplate, Image
import webbrowser
from PIL import Image #sudo apt install python3-pil.imagetk
from PIL import ImageTk
root = Tk()
#label = Label(root, text="Hello, World!")
#label.place(x=1, y=1)
class Relatorios():
def printCliente(self):
webbrowser.open("cliente.pdf")
def geraRelatCliente(self):
self.c = canvas.Canvas("cliente.pdf")
self.codigoRel = self.codigo_entry.get()
self.nomeRel = self.nome_entry.get()
self.foneRel = self.fone_entry.get()
self.cidadeRel = self.cidade_entry.get()
self.c.setFont("Helvetica-Bold", 20)
self.c.drawString(200, 800, 'Ficha do cliente')
self.c.setFont("Helvetica-Bold", 10)
self.c.drawString(50, 770, 'Codigo:')
self.c.drawString(50, 750, 'Nome:')
self.c.drawString(50, 730, 'Telefone:')
self.c.drawString(50, 710, 'Cidade:')
self.c.setFont("Helvetica", 10)
self.c.drawString(100, 770, self.codigoRel)
self.c.drawString(100, 750, self.nomeRel)
self.c.drawString(100, 730, self.foneRel)
self.c.drawString(100, 710, self.cidadeRel)
self.c.rect(20, 700, 560, 90, fill=False, stroke=True)
self.c.showPage()
self.c.save()
self.printCliente()
class Funcs():
def limpa_cliente(self):
self.codigo_entry.delete(0, END)
self.nome_entry.delete(0, END)
self.fone_entry.delete(0, END)
self.cidade_entry.delete(0, END)
def conecta_bd(self):
self.conn = sqlite3.connect("clientes.bd")
self.cursor = self.conn.cursor(); print("Conectando banco de dados")
def desconecta_bd(self):
self.conn.close(); print("Desconectando banco de dados")
def montaTabelas(self):
self.conecta_bd()
### Criar tabela
self.cursor.execute("""
CREATE TABLE IF NOT EXISTS clientes (
cod INTEGER PRIMARY KEY,
nome_cliente CHAR(40) NOT NULL,
telefone INTEGER(20),
cidade CHAR(40)
);
""")
self.conn.commit(); print("Banco de dados criado")
self.desconecta_bd()
def var(self):
self.codigo = self.codigo_entry.get()
self.nome = self.nome_entry.get()
self.fone = self.fone_entry.get()
self.cidade = self.cidade_entry.get()
def add_cliente(self):
self.var()
self.conecta_bd()
self.cursor.execute(""" INSERT INTO clientes (nome_cliente, telefone, cidade)
VALUES (?, ?, ?)""", (self.nome, self.fone, self.cidade))
self.conn.commit()
self.desconecta_bd()
self.select_lista()
self.limpa_cliente()
def select_lista(self):
self.listaCli.delete(*self.listaCli.get_children())
self.conecta_bd()
lista = self.cursor.execute(""" SELECT cod, nome_cliente, telefone, cidade FROM clientes
ORDER BY nome_cliente ASC; """)
for i in lista:
self.listaCli.insert("", END, values=i)
self.desconecta_bd()
def OnDoubleClick(self, event):
self.limpa_cliente()
self.listaCli.selection()
for n in self.listaCli.selection():
col1, col2, col3, col4 = self.listaCli.item(n, 'values')
self.codigo_entry.insert(END, col1)
self.nome_entry.insert(END, col2)
self.fone_entry.insert(END, col3)
self.cidade_entry.insert(END, col4)
def deleta_cliente(self):
self.var()
self.conecta_bd()
self.cursor.execute(""" DELETE FROM clientes WHERE cod = ? """, (self.codigo,))
self.conn.commit()
self.desconecta_bd()
self.limpa_cliente()
self.select_lista()
def altera_cliente(self):
self.var()
self.conecta_bd()
self.cursor.execute(""" UPDATE clientes SET nome_cliente = ?, telefone = ?, cidade = ?
WHERE cod = ? """, (self.nome, self.fone, self.cidade, self.codigo))
self.conn.commit()
self.desconecta_bd()
self.select_lista()
self.limpa_cliente()
def busca_cliente(self):
self.conecta_bd()
self.listaCli.delete(*self.listaCli.get_children())
self.nome_entry.insert(END, '%')
nome = self.nome_entry.get()
self.cursor.execute(
""" SELECT cod, nome_cliente, telefone, cidade FROM clientes
WHERE nome_cliente LIKE '%s' ORDER BY nome_cliente ASC""" % nome)
buscanomeCli = self.cursor.fetchall()
for i in buscanomeCli:
self.listaCli.insert("", END, values=i)
self.limpa_cliente()
self.desconecta_bd()
class Application(Funcs, Relatorios):
def __init__(self):
self.root = root
self.tela()
self.frames_da_tela()
self.widgets_frame1()
self.lista_frame2()
self.montaTabelas()
self.select_lista()
self.Menus()
root.mainloop()
def tela(self):
self.root.title("Cadastro de Clientes") # titulo da janela
self.root.configure(background= '#1e3743')
self.root.geometry("700x500+0+0")
self.root.resizable(True, True)
self.root.maxsize(width= 900, height= 700)
self.root.minsize(width= 500, height= 400)
def frames_da_tela(self):
self.frame_1 = Frame(self.root, bd = 4, bg= '#dfe3ee', highlightbackground= '#bcc8d8', highlightthickness= 3)
self.frame_1.place(relx= 0.02, rely= 0.02, relwidth= 0.96, relheight= 0.46)
self.frame_2 = Frame(self.root, bd = 4, bg= '#dfe3ee', highlightbackground= '#bcc8d8', highlightthickness= 3)
self.frame_2.place(relx= 0.02, rely= 0.5, relwidth= 0.96, relheight= 0.46)
def widgets_frame1(self):
self.canvas_bt = Canvas(self.frame_1, bd=0, bg='#1e3743', highlightbackground = '#bcc8d8', highlightthickness= 3)
self.canvas_bt.place(relx= 0.19, rely= 0.081, relwidth= 0.22, relheight= 0.19)
self.bt_limpar = Button(self.frame_1, text= 'Limpar', bd= 2, bg= '#e4e4e4', fg= '#024c2c', font = ('times', 10, 'bold'), command= self.limpa_cliente)
self.bt_limpar.place(relx= 0.2, rely= 0.1, relwidth= 0.1, relheight= 0.15)
self.bt_buscar = Button(self.frame_1, text= 'Buscar', bd= 2, bg= '#e4e4e4', fg= '#024c2c', font = ('times', 10, 'bold'), command = self.busca_cliente)
self.bt_buscar.place(relx= 0.3, rely= 0.1, relwidth= 0.1, relheight= 0.15)
self.imgNovo = PhotoImage(file = "novo.png")
self.imgNovo = self.imgNovo.subsample(3, 2)
self.style = ttk.Style()
self.style.configure("BW.TButton", relwidth=1, relheight=1, borderwidth=-5, bodercolor= '#bcc8d8', background= 'gray', image= self.imgNovo)
self.bt_novo = ttk.Button(self.frame_1, style = "BW.TButton", command= self.add_cliente)
self.bt_novo.place(relx= 0.6, rely= 0.1, relwidth= 0.1, relheight= 0.15)
self.bt_novo.config(image= self.imgNovo)
self.bt_alterar = Button(self.frame_1, text= 'Alterar', bd= 2, bg= '#e4e4e4', fg= '#024c2c', font = ('times', 10, 'bold'), command= self.altera_cliente)
self.bt_alterar.place(relx= 0.7, rely= 0.1, relwidth= 0.1, relheight= 0.15)
self.bt_apagar = Button(self.frame_1, text= 'Apagar', bd= 2, bg= '#e4e4e4', fg= '#024c2c', activebackground= '#bcc8d8', activeforeground='green', font = ('times', 10, 'bold'), command= self.deleta_cliente)
self.bt_apagar.place(relx= 0.8, rely= 0.1, relwidth= 0.1, relheight= 0.15)
self.lb_codigo = Label(self.frame_1, text= 'Codigo', bg= '#dfe3ee', fg= '#024c2c')
self.lb_codigo.place(relx= 0.05, rely= 0.05)
self.codigo_entry = Entry(self.frame_1, fg= '#024c2c')
self.codigo_entry.place(relx= 0.05, rely= 0.15, relwidth= 0.08)
self.lb_nome = Label(self.frame_1, text= 'Nome', bg= '#dfe3ee', fg= '#024c2c')
self.lb_nome.place(relx= 0.05, rely= 0.35)
self.nome_entry = Entry(self.frame_1, fg= '#024c2c')
self.nome_entry.place(relx= 0.05, rely= 0.45, relwidth= 0.8)
self.lb_fone = Label(self.frame_1, text= 'Telefone', bg= '#dfe3ee', fg= '#024c2c')
self.lb_fone.place(relx= 0.05, rely= 0.6)
self.fone_entry = Entry(self.frame_1, fg= '#024c2c')
self.fone_entry.place(relx= 0.05, rely= 0.7, relwidth= 0.3)
self.lb_cidade = Label(self.frame_1, text= 'Cidade', bg= '#dfe3ee', fg= '#024c2c')
self.lb_cidade.place(relx= 0.4, rely= 0.6)
self.cidade_entry = Entry(self.frame_1, fg= '#024c2c')
self.cidade_entry.place(relx= 0.4, rely= 0.7, relwidth= 0.5)
def lista_frame2(self):
self.listaCli = ttk.Treeview(self.frame_2, height= 3, column=('col1, col2, col3, col4'))
self.listaCli.heading('#0', text= '')
self.listaCli.heading('#1', text= 'Codigo')
self.listaCli.heading('#2', text= 'Nome')
self.listaCli.heading('#3', text= 'Telefone')
self.listaCli.heading('#4', text= 'Cidade')
self.listaCli.column('#0', width=1)
self.listaCli.column('#1', width=50)
self.listaCli.column('#2', width=200)
self.listaCli.column('#3', width=125)
self.listaCli.column('#4', width=125)
self.listaCli.place(relx=0.01, rely=0.1, relwidth=0.95, relheight=0.85)
self.scroolLista = Scrollbar(self.frame_2, orient='vertical')
self.listaCli.configure(yscroll=self.scroolLista.set)
self.scroolLista.place(relx=0.96, rely=0.1, relwidth=0.04, relheight=0.85)
self.listaCli.bind("<Double-1>", self.OnDoubleClick)
def Menus(self):
menubar = Menu(self.root)
self.root.config(menu=menubar)
filemenu = Menu(menubar)
filemenu2 = Menu(menubar)
def Quit(): self.root.destroy()
menubar.add_cascade(label="Opções", menu= filemenu)
menubar.add_cascade(label="Sobre", menu= filemenu2)
filemenu.add_command(label="Sair", command= Quit)
filemenu2.add_command(label="Limpa Cliente", command= self.limpa_cliente)
filemenu2.add_command(label="Ficha do Cliente", command= self.geraRelatCliente)
Application()
