# -*- coding: utf-8 -*-
import os
import sys
import random
import webbrowser
from PyQt5.QtCore import Qt
from PyQt5 import QtGui, QtWidgets
from jinja2 import Environment, FileSystemLoader
from Crud.core import Conexao
from login import MainLogin
from Crud.Models import Empresa
from Crud.CrudEmpresa import CrudEmpresa
from Funcoes.categoriaAPagar import CategoriaAPagar
from Funcoes.categoriaAReceber import CategoriaAReceber
from Funcoes.Clientes import Clientes
from Funcoes.comercial import Comercial
from Funcoes.data import DataAtual
from Funcoes.financeiro import Financeiro
from Funcoes.FormaPagamento import FormaPagamento
from Funcoes.Fornecedor import Fornecedor
from Funcoes.Funcoes import Funcao
from home import MainHome
from mainclientes import MainClientes
from maincompras import MainCompras
from mainconfig import MainConfig
from mainfinanceiro import MainFinanceiro
from mainfornecedor import MainFornecedor
from mainprodutos import MainProdutos
from mainvendas import MainVendas
from Views.main import Ui_MainWindow
# Icons
import Images
class Main(QtWidgets.QMainWindow, Ui_MainWindow, MainHome, MainProdutos,
Funcao, MainVendas, MainClientes, MainCompras, MainFinanceiro,
MainFornecedor, MainConfig, Financeiro, Comercial, Fornecedor,
Clientes, FormaPagamento, CategoriaAPagar, CategoriaAReceber, MainLogin):
def __init__(self, parent=None):
super(Main, self).__init__(parent)
self.setupUi(self)
self.centralizar() # Centrelizando na tela
# Background
palete = QtGui.QPalette()
image = QtGui.QPixmap(self.resourcepath('Images/bg.png'))
brush = QtGui.QBrush(image)
palete.setBrush(QtGui.QPalette.Background, brush)
self.setPalette(palete)
# Caminho Absoluto
self.caminho = os.path.abspath(os.path.dirname(sys.argv[0]))
# Icone dos botoes Topo
self.IconeBotaoTopo(self.bt_Home, self.resourcepath(
'Images/home.png')) # HOme
self.IconeBotaoTopo(self.bt_Exit, self.resourcepath(
'Images/exit.png')) # Sair
# Icone botoes menu
self.IconeBotaoMenu(self.bt_Clientes, self.resourcepath(
'Images/tag-new.png')) # Clientes
self.IconeBotaoMenu(self.bt_Vendas, self.resourcepath(
'Images/vendas.png')) # Vendas
self.IconeBotaoMenu(self.bt_Fornecedor, self.resourcepath(
'Images/iconFornecedor.png')) # Fornecedor
self.IconeBotaoMenu(self.bt_MainProdutos, self.resourcepath(
'Images/estoque.png')) # Produtos
self.IconeBotaoMenu(self.bt_Compras, self.resourcepath(
'Images/ico-compras.png')) # Compras
self.IconeBotaoMenu(self.bt_Financeiro, self.resourcepath(
'Images/financeiro.png')) # Financeiro
self.IconeBotaoMenu(self.bt_Conf, self.resourcepath(
'Images/conf.png')) # Configuracao
"""Ação dos Botões Botoes"""
# Home
self.bt_Home.clicked.connect(self.janelaHome)
# Produtos
self.bt_MainProdutos.clicked.connect(self.janelaProdutos)
# Vendas
self.bt_Vendas.clicked.connect(self.janelaVendas)
# Clientes
self.bt_Clientes.clicked.connect(self.janelaClientes)
# Compras
self.bt_Compras.clicked.connect(self.janelaCompras)
# Fornecedor
self.bt_Fornecedor.clicked.connect(self.janelaFornecedor)
# Financeiro
self.bt_Financeiro.clicked.connect(self.janelaFinanceiro)
# Config
self.bt_Conf.clicked.connect(self.janelaConfig)
# Meus dados
self.bt_alterSenha.clicked.connect(self.editarUser)
# Logout
self.bt_logout.clicked.connect(self.janelaLogin)
""" Fim Botoes """
# Setando data no Header
data = DataAtual()
data.diaAtual()
self.lb_Data.setText(data.diames)
self.lb_DiaSemana.setText(data.diasemana)
# Abrindo tela Login
self.janelaLogin()
# Checando conexao com banco de dados
self.DbCheck() # Checando banco de dados
# Caminho absoluto
def resourcepath(self, relative_path):
base_path = getattr(sys, '_MEIPASS', os.path.dirname(
os.path.abspath(__file__)))
return os.path.join(base_path, relative_path)
# Centralizar Janela na Tela
def centralizar(self):
# geometry of the main window
qr = self.frameGeometry()
# center point of screen
cp = QtWidgets.QDesktopWidget().availableGeometry().center()
# move rectangle's center point to screen's center point
qr.moveCenter(cp)
# top left of rectangle becomes top left of window centering it
self.move(qr.topLeft())
# Verificando Banco de Dados
def DbCheck(self):
conecta = Conexao()
try:
busca = CrudEmpresa()
busca.SelectEmpresaId()
self.lb_NomeFantasia.setText(busca.titulo)
self.lb_NomeFantasia2.setText(busca.subtitulo)
self.setWindowTitle(busca.titulo + " " + busca.subtitulo)
except:
pass
try:
conecta.engine.connect()
except:
self.janelaConfig()
self.janelaDbConf()
for filho in self.fr_menuConfig.findChildren(QtWidgets.QPushButton):
filho.setDisabled(True)
for botao in self.wd_menu.findChildren(QtWidgets.QPushButton):
botao.setDisabled(True)
self.bt_Home.setDisabled(True)
"""Abrindo Janelas externas"""
# Login
def janelaLogin(self):
self.LimpaFrame(self.ct_conteudo)
# Limpando nome de usuário logado
self.lb_userName.clear()
# Desabilitando Botao Meus Dados e Logout
self.bt_alterSenha.setDisabled(True)
self.bt_logout.setDisabled(True)
self.bt_Home.setDisabled(True)
# Ocultando botoes
for filho in self.wd_menu.findChildren(QtWidgets.QPushButton):
filho.setHidden(True)
# Desabilitando botao Home
# self.bt_Home.setDisabled(True)
self.mainlogin(self.ct_conteudo)
# Home
def janelaHome(self):
self.LimpaFrame(self.ct_conteudo)
self.ativaBotoes(self.wd_menu)
self.main_home(self.ct_conteudo)
# Main Produtos
def janelaProdutos(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_MainProdutos)
self.mainprodutos(self.ct_conteudo)
# Main Vendas
def janelaVendas(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Vendas)
self.mainvendas(self.ct_conteudo)
# Main Cliente
def janelaClientes(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Clientes)
self.mainclientes(self.ct_conteudo)
# Main Fornecedor
def janelaFornecedor(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Fornecedor)
self.mainfornecedor(self.ct_conteudo)
# Main Compras
def janelaCompras(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Compras)
self.maincompras(self.ct_conteudo)
# Main Financeiro
def janelaFinanceiro(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Financeiro)
self.mainfinanceiro(self.ct_conteudo)
# Main Configuração
def janelaConfig(self):
self.LimpaFrame(self.ct_conteudo)
self.DesativaBotao(self.wd_menu, self.bt_Conf)
self.mainconfig(self.ct_conteudo)
def editarUser(self):
self.janelaConfig()
self.selectUsuario(self.idUser)
for filho in self.fr_menuConfig.findChildren(QtWidgets.QPushButton):
filho.setDisabled(True)
self.cb_nivel.setDisabled(True)
self.cb_ativo.setDisabled(True)
self.bt_Voltar.setHidden(True)
""" Fim conteudos Externos """
""" Conteudos tabelas """
# Conteudo Tabela Centralizdo fonte padrao
def conteudoTabela(self, tabela, row, col, data):
item = QtWidgets.QTableWidgetItem()
item.setTextAlignment(Qt.AlignJustify |
Qt.AlignHCenter | Qt.AlignVCenter)
item.setFlags(Qt.NoItemFlags)
item.setText(data)
tabela.setItem(row, col, item)
# Conteudo tabela alinhado a esquerda
def conteudoTabelaLeft(self, tabela, row, col, data):
item = QtWidgets.QTableWidgetItem()
item.setTextAlignment(Qt.AlignJustify |
Qt.AlignLeft | Qt.AlignVCenter)
item.setFlags(Qt.NoItemFlags)
item.setText(data)
tabela.setItem(row, col, item)
# Botão Tabela
def botaoTabela(self, tabela, row, col, funcao, bg):
item = QtWidgets.QPushButton()
# item.setFixedWidth(30)
# item.setFixedHeight(30)
item.setCursor(QtGui.QCursor(Qt.PointingHandCursor))
item.setFocusPolicy(Qt.NoFocus)
item.setFlat(Qt.NoItemFlags)
item.setStyleSheet("QPushButton{\n"
"background-color: #1E87F0;\n"
"border-radius: 2px;\n"
"padding: 2px;\n"
"color: #FFF;\n"
"font: 10px \"Tahoma\" Bold\n"
"}\n"
"QPushButton:hover{\n"
"background-color: #40a286\n"
"}")
item.setText("EDITAR")
icon1 = QtGui.QIcon()
icon1.addPixmap(QtGui.QPixmap(
self.resourcepath('Images/editar.png')),
QtGui.QIcon.Normal, QtGui.QIcon.Off)
item.setIcon(icon1)
tabela.setCellWidget(row, col, item)
item.clicked.connect(funcao)
# Botão Remove Item
def botaoRemoveItem(self, tabela, row, col, funcao, bg):
item = QtWidgets.QPushButton()
# item.setFixedWidth(30)
# item.setFixedHeight(30)
item.setCursor(QtGui.QCursor(Qt.PointingHandCursor))
item.setFocusPolicy(Qt.NoFocus)
item.setFlat(Qt.NoItemFlags)
item.setStyleSheet("QPushButton{\n"
"background-color: " + bg + ";\n"
"border-radius: 2px;\n"
"padding: 2px;\n"
"}\n"
"QPushButton:hover{\n"
"background-color: #40a286\n"
"}")
item.setText("")
icon1 = QtGui.QIcon()
icon1.addPixmap(QtGui.QPixmap(
self.resourcepath('Images/edit-delete.png')),
QtGui.QIcon.Normal, QtGui.QIcon.Off)
item.setIcon(icon1)
tabela.setCellWidget(row, col, item)
item.clicked.connect(funcao)
# data e Status entrega tabela compra / venda
def TabelaEntrega(self, tabela, row, col, data, cor, status):
item = QtWidgets.QLabel()
item.setAlignment(Qt.AlignLeading|Qt.AlignHCenter|
Qt.AlignVCenter)
item.setIndent(3)
item.setMargin(0)
item.setStyleSheet("background: #FFF")
html = ("""
<strong style="font-family:Arial; font-size: 13px;">{}<br/>
<span style="color:{}; font-size: 12px">{}</span></strong>"""
).format(data, cor, status)
item.setText(html)
tabela.setCellWidget(row, col, item)
# Texto Tabela Valor Produtos
def ValorProduto(self, tabela, row, col, valor):
item = QtWidgets.QLabel()
item.setAlignment(
Qt.AlignLeading|Qt.AlignHCenter|Qt.AlignVCenter)
item.setMargin(0)
item.setStyleSheet('background: #FFF')
html = ("""
<span style="font-family:'Arial'; font-size:30px;
font-weight: bold;"> <span style="font-size: 12px">R$</span> {}</span><br/>
""").format(valor)
item.setText(html)
tabela.setCellWidget(row, col, item)
# Status Operação coluna 1 tabela Compra/Venda
def TabelaStatus(self, tabela, row, col, cor):
item = QtWidgets.QLabel()
item.setMargin(0)
item.setStyleSheet("background: {}".format(cor))
tabela.setCellWidget(row, col, item)
# Nome e Telefone tabela cliente/fornecedor e compra/venda
def TabelaNomeTelefone(self, tabela, row, col, nome, telefone):
item = QtWidgets.QLabel()
item.setAlignment(Qt.AlignLeading|Qt.AlignLeft|
Qt.AlignVCenter)
item.setIndent(3)
item.setMargin(0)
item.setStyleSheet('background: #FFF')
html = (("""
<span style="font-family:Arial; font-size:13px; ">{}</span><br/>
<span style="font-family:Arial; font-size:10px;">{}</span>"""
)).format(nome, telefone)
item.setText(html)
tabela.setCellWidget(row, col, item)
# texto quantidade e status produtos tabela Produto
def TabelaQtdeStatus(self, tabela, row, col, qtde, cor):
item = QtWidgets.QLabel()
item.setAlignment(
Qt.AlignLeading|Qt.AlignHCenter|Qt.AlignVCenter)
item.setMargin(0)
item.setStyleSheet('background: #FFF')
html = ("""
<span style="font-family:'Arial'; font-size:30px;
font-weight: bold;color:{} ">{}</span><br/>
""").format(cor, qtde)
item.setText(html)
tabela.setCellWidget(row, col, item)
# Texto ID tabelas
def TabelaID(self, tabela, row, col, id):
item = QtWidgets.QLabel()
item.setAlignment(
Qt.AlignLeading|Qt.AlignHCenter|Qt.AlignVCenter)
item.setMargin(0)
item.setStyleSheet('background: #FFF;')
html = ("""
<span style="font-family:'Arial'; font-size:30px;
font-weight: bold;color:#7AB32E ">{}</span><br/>
""").format(id)
item.setText(html)
tabela.setCellWidget(row, col, item)
#Botao Receber/ Pagar Parcela
def botaoReceberParcela(self, tabela, row, col, funcao, texto, status):
item = QtWidgets.QPushButton()
# item.setFixedWidth(70)
# item.setFixedHeight(30)
item.setCursor(QtGui.QCursor(Qt.PointingHandCursor))
if status == 1:
item.setDisabled(True)
item.setFocusPolicy(Qt.NoFocus)
item.setFlat(Qt.NoItemFlags)
item.setStyleSheet("QPushButton{\n"
"background-color: #7AB32E;\n"
"border-radius: 2px;\n"
"padding: 2px;\n"
"border: none;\n"
"text-transform: uppercase;\n"
"font: 10px \"Arial\";\n"
"}\n"
"QPushButton:hover{\n"
"background-color: #40a286\n"
"}"
)
item.setText(texto)
font = QtGui.QFont()
font.setFamily("Tahoma")
font.setPointSize(10)
item.setFont(font)
icon1 = QtGui.QIcon()
icon1.addPixmap(QtGui.QPixmap(
self.resourcepath('Images/money.png')),
QtGui.QIcon.Normal, QtGui.QIcon.Off)
item.setIcon(icon1)
tabela.setCellWidget(row, col, item)
item.clicked.connect(funcao)
# Input receber/pagar parcela compra e venda
def tx_tabelaReceber(self, tabela, row, col, status, valor):
item = QtWidgets.QLineEdit()
# item.setGeometry(QRect(310, 360, 80, 30))
# item.setFixedWidth(60)
if status == 1:
item.setReadOnly(True)
item.setText(valor)
item.setFocusPolicy(Qt.WheelFocus)
item.setStyleSheet("QLineEdit{\n"
"background: #F1F1F1;\n"
"border: 2px solid #CFCFCF;\n"
"color: #000;\n"
"font: 12px \"Arial\" ;\n"
"text-transform: uppercase;\n"
"font-weight: bold\n"
"}\n"
"QLineEdit:Focus {\n"
"border: 1px solid red;\n"
"}")
item.setAlignment(
Qt.AlignRight | Qt.AlignTrailing | Qt.AlignVCenter)
item.setObjectName("tx_ValorPago")
item.setPlaceholderText("R$ 0.00")
tabela.setCellWidget(row, col, item)
#Input data tabela parcelas
def dt_tabela(self, tabela, row, col, data, status):
item = QtWidgets.QDateEdit()
# item.setGeometry(QRect(120, 18, 140, 18))
item.setFixedWidth(90)
if status == 1:
item.setReadOnly(True)
item.setStyleSheet("QDateEdit {\n"
"background: #FFF;\n"
"border: none;\n"
"font-family: \"Arial\";\n"
"font-size: 12px;\n"
"font-weight: bold;\n"
"color: rgb(80,79,79)\n"
"}\n"
" QDateEdit::drop-down {\n"
" subcontrol-origin: padding;\n"
" subcontrol-position: top right;\n"
" width: 20px;\n"
" border-left-width: 1px;\n"
" border-left-color: darkgray;\n"
" border-left-style: solid; /* just a single line */\n"
" border-top-right-radius: 3px; /* same radius as the QComboBox */\n"
" border-bottom-right-radius: 3px;\n"
" }\n"
"QDateEdit::down-arrow {\n"
" image: url(" +
self.resourcepath('Images/down.png')+");\n"
" }\n"
"QCalendarWidget QAbstractItemView:enabled \n"
" {\n"
"border: none;\n"
" font-size:13px; \n"
" color: #000; \n"
" background-color: #F1F1F1; \n"
" selection-background-color: rgb(64, 64, 64); \n"
" selection-color: rgb(0, 255, 0); \n"
" }\n"
"QCalendarWidget QToolButton {\n"
" border: none;\n"
" color: #000\n"
" }\n"
"\n"
" QCalendarWidget QMenu {\n"
" width: 150px;\n"
" left: 20px;\n"
" color: white;\n"
" font-size: 18px;\n"
" background-color: rgb(100, 100, 100);\n"
" }\n"
"QCalendarWidget QWidget#qt_calendar_navigationbar\n"
"{ \n"
"border: none;\n"
"}")
item.setCalendarPopup(True)
item.setDate(data)
tabela.setCellWidget(row, col, item)
#Retorna cor status para quantidade abaixo do minimo
def StatusStoque(self, qtde, minimo):
if qtde > minimo:
cor = "#7AB32E"
elif qtde <= minimo:
cor = "#e69822"
else:
cor = "red"
return cor
# Retorna Cor status Pagamento e Entrega
def StatusEntrega(self, *args):
if len(args) > 1:
if args[0] == 1 and args[1] == 1:
cor = "#7AB32E"
else:
cor = "#e69822"
else:
if args[0] == 1:
cor = "#7AB32E"
elif args[0] == 2:
cor = "#e69822"
else:
cor = "red"
return cor
# Imprimindo em pdf
def previaImpressao(self, arg):
self.documento.page().printToPdf(self.resourcepath('report.pdf'))
self.documento.page().pdfPrintingFinished.connect(self.okPrinter)
# Função executada após a impresso em pdf concluida
def okPrinter(self, sucess):
webbrowser.open_new_tab(self.resourcepath('report.pdf'))
pass
def renderTemplate(self, template_file, **kwargs):
template_loader = FileSystemLoader(
searchpath=self.resourcepath('Template/'))
# Jinja2 template environment
env = Environment(loader=template_loader)
template = env.get_template(template_file)
busca = CrudEmpresa()
busca.idEmpresa = 1
busca.SelectEmpresaId()
base = {'logo': str(busca.logo, encoding='utf-8'),
'nomeFantasia': busca.nomeFantasia,
'razaoSocial': busca.razaoSocial,
'cnpj': busca.cnpj,
'endereco': busca.endereco,
'numero': busca.numero,
'bairro': busca.bairro,
'cep': busca.cep,
'cidade': busca.cidade,
'estado': busca.estado,
'telefone': self.formatoNumTelefone(busca.telefone)}
html = template.render(base, **kwargs)
with open(self.resourcepath('report.html'), 'w', encoding='utf-8') as f:
f.write(html)
return html
if __name__ == "__main__":
app = QtWidgets.QApplication(sys.argv)
main_window = Main()
main_window.show()
app.exec_()
