def __init__(self, parent, controller, Cliente, Venda): tk.Frame.__init__(self, parent) self.controller = controller self.bd = db.Database() self.SomaQuant = tk.StringVar() self.fechaTela = tk.FALSE self.resetValues() self.FazTela() self.Cliente = Cliente self.Venda = Venda self.vpm = vpm.Application()
def raw_backup(): bd = db.Database() bd.exportSQL() # bd.importSQL() bd.close()
def FazTela(self): """ # Menu de fluxo entre telas toolbar1 = tk.Frame(self, bg="white") menu = tk.Button(toolbar1, text=" Menu Inicial ", bg="white", relief=tk.FLAT, command=lambda: self.controller.show_frame("menuInicial")) menu["font"] = ("Arial", "10") menu.pack(side=tk.LEFT) espaco1 = tk.Label(toolbar1, text=" | ", bg="white") espaco1["font"] = ("Arial", "12") espaco1.pack(side=tk.LEFT) cadastrarcliente = tk.Button(toolbar1, text="Clientes e Vendas", bg="light grey", relief=tk.FLAT) cadastrarcliente["font"] = ("Arial", "10") cadastrarcliente.pack(side=tk.LEFT, padx=1, pady=1) espaco3 = tk.Label(toolbar1, text=" | ", bg="white") espaco3["font"] = ("Arial", "12") espaco3.pack(side=tk.LEFT) historicovenda = tk.Button(toolbar1, text="Historico de Vendas", bg="white", relief=tk.FLAT, command=lambda: self.controller.show_frame("vendHist")) historicovenda["font"] = ("Arial", "10") historicovenda.pack(side=tk.LEFT, padx=1, pady=1) espaco4 = tk.Label(toolbar1, text=" | ", bg="white") espaco4["font"] = ("Arial", "12") espaco4.pack(side=tk.LEFT) inserirproduto = tk.Button(toolbar1, text="Inserir Produto", bg="white", relief=tk.FLAT, command=lambda: self.controller.show_frame("cadProdMaior")) inserirproduto["font"] = ("Arial", "10") inserirproduto.pack(side=tk.LEFT, padx=1, pady=1) toolbar1.pack(side=tk.TOP, fill=tk.X) """ # fim # abas de opcoes cor1 = '#D32F2F' v = "valor" toolbar2 = tk.Frame(self, bg=cor1) clientes = tk.Label(toolbar2, text=" Clientes Cadastrados:", bg=cor1, font="bold", fg="white") clientes.pack(side=tk.LEFT, pady=10) valor = tk.Label(toolbar2, text=v, bg=cor1, font="bold", fg="white") valor.pack(side=tk.LEFT) toolbar2.pack(side=tk.TOP, fill=tk.X) # fim # barra de 'status' status = tk.Label(self, text="Estado: Rodando", bg="white", bd=1, relief=tk.SUNKEN, anchor=tk.W) status.pack(side=tk.BOTTOM, fill=tk.X) # fim self.bd = db.Database() # banco de dados cor3 = '#E6E6E6' info = 53 #Criação da classe de tela menor de cadastro de cliente self.container1 = tk.Frame(self) self.container2 = tk.Frame(self, bg=cor3) self.container3 = tk.Frame(self, bg=cor3) self.container4 = tk.Frame(self, bg=cor3) self.container1.pack(fill=tk.X) self.container2.pack(side=tk.BOTTOM, fill=tk.X) self.container3.pack(side=tk.BOTTOM, fill=tk.X) self.container4.pack(side=tk.BOTTOM, fill=tk.X) self.cliente = tk.Label(self.container1, text="Clientes:") self.cliente["font"] = ["bold"] self.cliente.pack(side=tk.LEFT) t = " " for i in range(0, 2): tk.Label(self.container1, text=t).pack(side=tk.LEFT) self.dados = tk.Label(self.container1, text="Dados:") self.dados["font"] = ["bold"] self.dados.pack(side=tk.LEFT) # espaco com "salvar docx", "excluir" e "pesquisar" self.salto1 = tk.Label(self.container2, text="", bg=cor3) self.salto1.pack(side=tk.LEFT) self.espaco0 = tk.Label(self.container3, text=" ", bg=cor3) self.espaco0.pack(side=tk.LEFT) self.voltar = tk.Button(self.container3, text="Voltar", command=lambda: self.controller.terminate(), bg=cor3) self.voltar["font"] = ['bold'] self.voltar["padx"] = 1 self.voltar["pady"] = 1 self.voltar.pack(side=tk.LEFT) self.espaco1 = tk.Label(self.container3, text=" ", bg=cor3) self.espaco1.pack(side=tk.LEFT) #self.formCadastro = tk.Toplevel() self.cadastro = tk.Button(self.container3, text="Cadastrar Cliente", command=lambda: self.cadastraClin(), bg=cor3) self.cadastro["font"] = ['bold'] self.cadastro['padx'] = 1 self.cadastro['pady'] = 1 self.cadastro.pack(side=tk.LEFT) self.espaco2 = tk.Label(self.container3, text=" ", bg=cor3) self.espaco2.pack(side=tk.LEFT) self.pesquisar1 = tk.Label(self.container3, text="Pesquisar: ", bg=cor3) self.pesquisar1["font"] = ['bold'] self.pesquisar1.pack(side=tk.LEFT) self.pesquisar2 = tk.Entry(self.container3) self.pesquisar2["width"] = 40 self.pesquisar2["font"] = ("Arial", "10") self.pesquisar2.pack(side=tk.LEFT) self.espaco3 = tk.Label(self.container3, text=" ", bg=cor3) self.espaco3.pack(side=tk.LEFT) self.ok = tk.Button(self.container3, text="Ok", command=lambda: self.pesquisando(), bg=cor3) self.ok["font"] = ['bold'] self.ok['padx'] = 1 self.ok['pady'] = 1 self.ok.pack(side=tk.LEFT) self.espaco4 = tk.Label(self.container3, text=" ", bg=cor3) self.espaco4.pack(side=tk.LEFT) self.cadastrarEvento = tk.Button( self.container3, text="Cadastrar Evento", command=lambda: self.controller.show_frame('vendEvent'), bg=cor3) self.cadastrarEvento["font"] = ['bold'] self.cadastrarEvento['padx'] = 1 self.cadastrarEvento['pady'] = 1 self.cadastrarEvento.pack(side=tk.LEFT) self.salto2 = tk.Label(self.container4, text="", bg=cor3) self.salto2.pack(side=tk.LEFT) # fim # tabela dos itens #Frame.__init__(self, self.root) self.canvas1 = tk.Canvas(self, borderwidth=0, background="#ffffff") self.frame1 = tk.Frame(self.canvas1, background="#f0f0f0") self.vsb1 = tk.Scrollbar(self, orient="vertical", command=self.canvas1.yview) self.canvas1.configure(yscrollcommand=self.vsb1.set) self.canvas1.pack(side="left", fill="both", expand=True) self.vsb1.pack(side="left", fill="y") self.canvas1.create_window((4, 4), window=self.frame1, anchor="nw", tags="self.frame1") self.frame1.bind("<Configure>", self.onFrameConfigure1) self.pacote1 = [ self.canvas1, self.frame1, self.vsb1, "self.frame1", self.onFrameConfigure1 ] self.populate1(self.bd.selectCliente()) #Frame.__init__(self, self.root) self.canvas2 = tk.Canvas(self, borderwidth=0, background="#fafafa") self.frame2 = tk.Frame(self.canvas2, background="#fafafa") self.vsb2 = tk.Scrollbar(self, orient="vertical", command=self.canvas2.yview) self.canvas2.configure(yscrollcommand=self.vsb2.set) self.canvas2.pack(side="left", fill="both", expand=True) self.vsb2.pack(side="left", fill="y") self.canvas2.create_window((4, 4), window=self.frame2, anchor="nw", tags="self.frame2") self.frame2.bind("<Configure>", self.onFrameConfigure2) self.pacote2 = [ self.canvas2, self.frame2, self.vsb2, "self.frame2", self.onFrameConfigure2 ] self.populate2(self.bd.selectCliente())
def __init__(self): self.top = None self.bd = db.Database()
def FazTela(self): """ if (os.OS == "ce"): path = system.sys.path[0] else: path = system.os.curdir """ #dir1 = os.getcwd() + "\images\pencil.gif" self.photo1 = Tkin.PhotoImage( file=os.path.join(os.getcwd(), 'source', 'images', 'pencil.gif')) self.photo2 = Tkin.PhotoImage( file=os.path.join(os.getcwd(), "source", 'images', 'trash.gif')) ### self.toolbar1 = Tkin.Frame(self, bg="white") self.menu = Tkin.Button( self.toolbar1, text=" Menu Inicial ", bg="white", relief=Tkin.FLAT, command=lambda: self.controller.show_frame("menuInicial")) self.menu["font"] = ("Arial", "10") self.menu.pack(side=Tkin.LEFT) self.espaco1 = Tkin.Label(self.toolbar1, text=" | ", bg="white") self.espaco1["font"] = ("Arial", "12") self.espaco1.pack(side=Tkin.LEFT) """ self.novavenda = Tkin.Button(self.toolbar1, text="Nova Venda", bg="white", relief=Tkin.FLAT, command=lambda: self.controller.show_frame("vendProd")) self.novavenda["font"] = ("Arial", "10") self.novavenda.pack(side=Tkin.LEFT, padx=1, pady=1) self.espaco2 = Tkin.Label(self.toolbar1, text=" | ", bg="white") self.espaco2["font"] = ("Arial", "12") self.espaco2.pack(side=Tkin.LEFT) """ self.cadastrarcliente = Tkin.Button( self.toolbar1, text="Cadastrar Cliente", bg="white", relief=Tkin.FLAT, command=lambda: self.controller.show_frame("cadClientMaior")) self.cadastrarcliente["font"] = ("Arial", "10") self.cadastrarcliente.pack(side=Tkin.LEFT, padx=1, pady=1) self.espaco3 = Tkin.Label(self.toolbar1, text=" | ", bg="white") self.espaco3["font"] = ("Arial", "12") self.espaco3.pack(side=Tkin.LEFT) self.historicovenda = Tkin.Button( self.toolbar1, text="Historico de Vendas", bg="white", relief=Tkin.FLAT, command=lambda: self.controller.show_frame("vendHist")) self.historicovenda["font"] = ("Arial", "10") self.historicovenda.pack(side=Tkin.LEFT, padx=1, pady=1) self.espaco4 = Tkin.Label(self.toolbar1, text=" | ", bg="white") self.espaco4["font"] = ("Arial", "12") self.espaco4.pack(side=Tkin.LEFT) self.inserirproduto = Tkin.Button(self.toolbar1, text="Inserir Produto", bg="light grey", relief=Tkin.FLAT) self.inserirproduto["font"] = ("Arial", "10") self.inserirproduto.pack(side=Tkin.LEFT, padx=1, pady=1) """ self.espaco5 = Tkin.Label(self.toolbar1, text=" | ", bg="white") self.espaco5["font"] = ("Arial", "12") self.espaco5.pack(side=Tkin.LEFT) self.inserirtipo = Tkin.Button(self.toolbar1, text="Inserir Tipo", bg="white", relief=Tkin.FLAT, command=lambda: Teste()) self.inserirtipo["font"] = ("Arial", "10") self.inserirtipo.pack(side=Tkin.LEFT, padx=1, pady=1) """ self.toolbar1.pack(side=Tkin.TOP, fill=Tkin.X) # fim # barra de 'status' status = Tkin.Label(self, text="Estado: Rodando", bg="white", bd=1, relief=Tkin.SUNKEN, anchor=Tkin.W) status.pack(side=Tkin.BOTTOM, fill=Tkin.X) # self.bd = db.Database() # banco de dados self.tm = cpm.TelaMenor() # inserir self.td = cpd.TelaMenorDel() # deletar self.te = cpe.TelaMenorEdit1() # editar self.cor1 = '#D32F2F' self.cor2 = '#E94545' self.cor3 = '#E6E6E6' self.toolbar2 = Tkin.Frame(self, bg=self.cor1) self.todos = Tkin.Button(self.toolbar2, text=" Todos ", bg=self.cor1, command=self.todos_apertado) self.todos['font'] = ('bold') self.todos['fg'] = 'white' self.todos.pack(side=Tkin.LEFT, padx=1, pady=6) self.doces = Tkin.Button(self.toolbar2, text=" Doces ", bg=self.cor1, command=self.doces_apertado) self.doces['font'] = ('bold') self.doces['fg'] = 'white' self.doces.pack(side=Tkin.LEFT, padx=1, pady=6) self.salgados = Tkin.Button(self.toolbar2, text="Salgados", bg=self.cor1, command=self.salgados_apertado) self.salgados['font'] = ('bold') self.salgados['fg'] = 'white' self.salgados.pack(side=Tkin.LEFT, padx=1, pady=6) self.massas = Tkin.Button(self.toolbar2, text=" Massas ", bg=self.cor1, command=self.massas_apertado) self.massas['font'] = ('bold') self.massas['fg'] = 'white' self.massas.pack(side=Tkin.LEFT, padx=1, pady=6) self.bebidas = Tkin.Button(self.toolbar2, text=" Bebidas ", bg=self.cor1, command=self.bebidas_apertado) self.bebidas['font'] = ('bold') self.bebidas['fg'] = 'white' self.bebidas.pack(side=Tkin.LEFT, padx=1, pady=6) self.outros = Tkin.Button(self.toolbar2, text=" Outros ", bg=self.cor1, command=self.outros_apertado) self.outros['font'] = ('bold') self.outros['fg'] = 'white' self.outros.pack(side=Tkin.LEFT, padx=1, pady=6) self.toolbar2.pack(side=Tkin.TOP, fill=Tkin.X) self.container1 = Tkin.Frame(self) self.container2 = Tkin.Frame(self, bg=self.cor3) self.container3 = Tkin.Frame(self, bg=self.cor3) self.container4 = Tkin.Frame(self, bg=self.cor3) self.container1.pack(fill=Tkin.X) self.container2.pack(side=Tkin.BOTTOM, fill=Tkin.X) self.container3.pack(side=Tkin.BOTTOM, fill=Tkin.X) self.container4.pack(side=Tkin.BOTTOM, fill=Tkin.X) self.objeto1 = Tkin.Label(self.container1, text="Codigo:") self.objeto1["font"] = ["bold"] self.objeto1.pack(side=Tkin.LEFT) self.objeto2 = Tkin.Label( self.container1, text=" ") self.objeto2["font"] = ["bold"] self.objeto2.pack(side=Tkin.LEFT) self.objeto3 = Tkin.Label(self.container1, text="Nome:") self.objeto3["font"] = ["bold"] self.objeto3.pack(side=Tkin.LEFT) self.objeto4 = Tkin.Label( self.container1, text= " " ) self.objeto4["font"] = ["bold"] self.objeto4.pack(side=Tkin.LEFT) self.objeto5 = Tkin.Label(self.container1, text="Valor:") self.objeto5["font"] = ["bold"] self.objeto5.pack(side=Tkin.LEFT) self.objeto6 = Tkin.Label( self.container1, text=" ") self.objeto6["font"] = ["bold"] self.objeto6.pack(side=Tkin.LEFT) # fim # espaco com "inserir", "editar", "excluir" e "pesquisar" self.salto1 = Tkin.Label(self.container2, text="", bg=self.cor3) self.salto1.pack(side=Tkin.LEFT) self.espaco1 = Tkin.Label( self.container3, text= " ", bg=self.cor3) self.espaco1.pack(side=Tkin.LEFT) self.inserir = Tkin.Button(self.container3, text="Inserir", command=lambda: self.inserindo(), bg=self.cor3) self.inserir["font"] = ['bold'] self.inserir['padx'] = 1 self.inserir['pady'] = 1 self.inserir.pack(side=Tkin.LEFT) self.espaco2 = Tkin.Label(self.container3, text=" ", bg=self.cor3) self.espaco2.pack(side=Tkin.LEFT) self.pesquisar1 = Tkin.Label(self.container3, text="Pesquisar: ", bg=self.cor3) self.pesquisar1["font"] = ['bold'] self.pesquisar1.pack(side=Tkin.LEFT) self.pesquisar2 = Tkin.Entry(self.container3) self.pesquisar2["width"] = 25 self.pesquisar2["font"] = ("Arial", "10") self.pesquisar2.pack(side=Tkin.LEFT) pesquisado = self.pesquisar2.get( ) # pesquisado = o que foi escrito no "Entry / barra de pesquisa" self.espaco4 = Tkin.Label(self.container3, text=" ", bg=self.cor3) self.espaco4.pack(side=Tkin.LEFT) self.ok = Tkin.Button( self.container3, text="Ok", command=lambda: self.pesquisando(self.pesquisar2.get()), bg=self.cor3) self.ok["font"] = ['bold'] self.ok['padx'] = 1 self.ok['pady'] = 1 self.ok.pack(side=Tkin.LEFT) self.salto2 = Tkin.Label(self.container4, text="", bg=self.cor3) self.salto2.pack(side=Tkin.LEFT) # fim self.canvas = None # tabela dos itens self.todos_apertado()