Пример #1
0
 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()
Пример #2
0
def raw_backup():
    bd = db.Database()
    bd.exportSQL()
    # bd.importSQL()
    bd.close()
Пример #3
0
    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())
Пример #4
0
 def __init__(self):
     self.top = None
     self.bd = db.Database()
Пример #5
0
    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()