# -*- coding: utf-8 -*-
from PySide import QtCore, QtGui
import sqlite3, time, sys, os

class Login(QtGui.QDialog):
    def __init__(self):
        super(Login, self).__init__(None)
        self.resize(194, 156)
        self.verticalLayout = QtGui.QVBoxLayout(self)
        self.verticalLayout.setSizeConstraint(QtGui.QLayout.SetFixedSize)
        self.lblogo = QtGui.QLabel(self)
        #self.lblogo.setText("")
        self.lblogo.setPixmap(QtGui.QPixmap("IMG/logohl2.png"))
        self.lblogo.setScaledContents(False)
        self.lblogo.setAlignment(QtCore.Qt.AlignCenter)
        self.verticalLayout.addWidget(self.lblogo)
        self.horizontalLayout = QtGui.QHBoxLayout()
        self.lbuser = QtGui.QLabel(self)
        self.lbuser.setMinimumSize(QtCore.QSize(0, 0))
        self.lbuser.setMaximumSize(QtCore.QSize(16777215, 16777215))
        self.lbuser.setScaledContents(True)
        self.lbuser.setOpenExternalLinks(False)
        self.horizontalLayout.addWidget(self.lbuser)
        self.leuser = QtGui.QLineEdit(self)
        self.horizontalLayout.addWidget(self.leuser)
        self.verticalLayout.addLayout(self.horizontalLayout)
        self.horizontalLayout_2 = QtGui.QHBoxLayout()
        self.lbpass = QtGui.QLabel(self)
        self.horizontalLayout_2.addWidget(self.lbpass)
        self.lepass = QtGui.QLineEdit(self)
        self.lepass.setEchoMode(QtGui.QLineEdit.Password)
        self.horizontalLayout_2.addWidget(self.lepass)
        self.verticalLayout.addLayout(self.horizontalLayout_2)
        self.buttonBox = QtGui.QDialogButtonBox(self)
        self.buttonBox.setOrientation(QtCore.Qt.Horizontal)
        self.buttonBox.setStandardButtons(QtGui.QDialogButtonBox.Cancel|QtGui.QDialogButtonBox.Ok)
        self.verticalLayout.addWidget(self.buttonBox)
        QtCore.QObject.connect(self.buttonBox, QtCore.SIGNAL("accepted()"), self.loginCheck)
        QtCore.QObject.connect(self.buttonBox, QtCore.SIGNAL("rejected()"), self.reject)
        QtCore.QMetaObject.connectSlotsByName(self)
        self.setTabOrder(self.leuser, self.lepass)
        self.setTabOrder(self.lepass, self.buttonBox)
        self.setWindowTitle("Tela de Login")
        self.lbuser.setText("Usuário:")
        self.lbpass.setText("Senha:")
        self.creatDb()
    def openHome(self):
        h = Home(self)
        h.show()

    def creatDb(self):
        self.conn = sqlite3.connect('database.db')
        self.cursor = self.conn.cursor()
        self.cursor.execute('''CREATE TABLE IF NOT EXISTS users (
            id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
            name TEXT NOT NULL,
            login TEXT NOT NULL,
            passwd TEXT);
        ''')
        self.cursor.execute('SELECT * FROM users WHERE login = ? AND passwd = ?;', ("admin", "12345"))
        result = self.cursor.fetchall()
        if len(result ) < 1:
            self.cursor.execute('''INSERT INTO users (name, login, passwd)
            VALUES ("Admininstrator", "admin", "12345")''')
            self.conn.commit()
        else:
            pass

    def loginCheck(self):
        user = self.leuser.text()
        password = self.lepass.text()
        self.cursor.execute('SELECT * FROM users WHERE login = ? AND passwd = ?;', (user, password))
        if len(self.cursor.fetchall()) > 0:
            self.close()
            self.openHome()
            print('Logado como ', user)
        else:
            msgBox = QtGui.QMessageBox()
            msgBox.setIcon(QtGui.QMessageBox.Warning)
            msgBox.setWindowTitle('Erro!')
            msgBox.setText('Usuário e/ou Senha incorretos!')
            msgBox.setStandardButtons(QtGui.QMessageBox.Ok)
            msgBox.exec_()
            print('Deu ruim cachoeira!')

class Home(QtGui.QMainWindow):
    def __init__(self, parent = None):
        super(Home, self).__init__(parent)
        self.resize(635, 396)
        self.setAutoFillBackground(False)
        self.centralwidget = QtGui.QWidget(self)
        self.verticalLayout_2 = QtGui.QVBoxLayout(self.centralwidget)
        self.verticalLayout = QtGui.QVBoxLayout()
        self.horizontalLayout_3 = QtGui.QHBoxLayout()
        spacerItem = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum)
        self.horizontalLayout_3.addItem(spacerItem)
        self.leSearch = QtGui.QLineEdit(self.centralwidget)
        self.leSearch.setText("")
        self.horizontalLayout_3.addWidget(self.leSearch)
        self.lbSearch = QtGui.QLabel(self.centralwidget)
        self.lbSearch.setMaximumSize(QtCore.QSize(29, 29))
        self.lbSearch.setText("")
        self.lbSearch.setPixmap(QtGui.QPixmap("../../Imagens/Icones/123368-color-startups-and-new-business/png/magnifying-glass.png"))
        self.lbSearch.setScaledContents(True)
        self.horizontalLayout_3.addWidget(self.lbSearch)
        spacerItem1 = QtGui.QSpacerItem(40, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum)
        self.horizontalLayout_3.addItem(spacerItem1)
        self.verticalLayout.addLayout(self.horizontalLayout_3)
        self.horizontalLayout_4 = QtGui.QHBoxLayout()
        spacerItem2 = QtGui.QSpacerItem(20, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum)
        self.horizontalLayout_4.addItem(spacerItem2)
        self.cbSearch = QtGui.QComboBox(self.centralwidget)
        self.cbSearch.addItem("")
        self.cbSearch.addItem("")
        self.cbSearch.addItem("")
        self.cbSearch.addItem("")
        self.cbSearch.addItem("")
        self.cbSearch.addItem("")
        self.horizontalLayout_4.addWidget(self.cbSearch)
        spacerItem3 = QtGui.QSpacerItem(30, 20, QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Minimum)
        self.horizontalLayout_4.addItem(spacerItem3)
        self.verticalLayout.addLayout(self.horizontalLayout_4)
        self.verticalLayout_2.addLayout(self.verticalLayout)
        self.horizontalLayout_2 = QtGui.QHBoxLayout()
        self.pbClient = QtGui.QPushButton(self.centralwidget)
        icon = QtGui.QIcon()
        icon.addPixmap(QtGui.QPixmap("IMG/team.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbClient.setIcon(icon)
        self.pbClient.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout_2.addWidget(self.pbClient)
        self.pbSo = QtGui.QPushButton(self.centralwidget)
        icon1 = QtGui.QIcon()
        icon1.addPixmap(QtGui.QPixmap("IMG/documentation.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbSo.setIcon(icon1)
        self.pbSo.setIconSize(QtCore.QSize(32, 32))
        self.pbSo.setCheckable(False)
        self.horizontalLayout_2.addWidget(self.pbSo)
        self.pbStock = QtGui.QPushButton(self.centralwidget)
        icon2 = QtGui.QIcon()
        icon2.addPixmap(QtGui.QPixmap("IMG/store.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbStock.setIcon(icon2)
        self.pbStock.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout_2.addWidget(self.pbStock)
        self.pbFinancial = QtGui.QPushButton(self.centralwidget)
        icon3 = QtGui.QIcon()
        icon3.addPixmap(QtGui.QPixmap("IMG/diagram-1.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbFinancial.setIcon(icon3)
        self.pbFinancial.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout_2.addWidget(self.pbFinancial)
        self.verticalLayout_2.addLayout(self.horizontalLayout_2)
        self.horizontalLayout = QtGui.QHBoxLayout()
        self.horizontalLayout.setObjectName("horizontalLayout")
        self.pbSales = QtGui.QPushButton(self.centralwidget)
        icon4 = QtGui.QIcon()
        icon4.addPixmap(QtGui.QPixmap("IMG/website.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbSales.setIcon(icon4)
        self.pbSales.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout.addWidget(self.pbSales)
        self.pbTeam = QtGui.QPushButton(self.centralwidget)
        icon5 = QtGui.QIcon()
        icon5.addPixmap(QtGui.QPixmap("IMG/employees.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbTeam.setIcon(icon5)
        self.pbTeam.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout.addWidget(self.pbTeam)
        self.pbProvider = QtGui.QPushButton(self.centralwidget)
        icon6 = QtGui.QIcon()
        icon6.addPixmap(QtGui.QPixmap("IMG/truck-1.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbProvider.setIcon(icon6)
        self.pbProvider.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout.addWidget(self.pbProvider)
        self.pbSettings = QtGui.QPushButton(self.centralwidget)
        icon7 = QtGui.QIcon()
        icon7.addPixmap(QtGui.QPixmap("IMG/cogwheel.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.pbSettings.setIcon(icon7)
        self.pbSettings.setIconSize(QtCore.QSize(32, 32))
        self.horizontalLayout.addWidget(self.pbSettings)
        self.verticalLayout_2.addLayout(self.horizontalLayout)
        self.setCentralWidget(self.centralwidget)
        self.menubar = QtGui.QMenuBar(self)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 635, 26))
        self.menuFile = QtGui.QMenu(self.menubar)
        self.menuNew = QtGui.QMenu(self.menuFile)
        self.menuPesquisar = QtGui.QMenu(self.menuFile)
        self.menuHelp = QtGui.QMenu(self.menubar)
        self.menuExit = QtGui.QMenu(self.menubar)
        self.setMenuBar(self.menubar)
        self.statusbar = QtGui.QStatusBar(self)
        self.setStatusBar(self.statusbar)
        self.actionManual = QtGui.QAction(self)
        self.actionSupport = QtGui.QAction(self)
        self.actionAbout = QtGui.QAction(self)
        self.actionClient = QtGui.QAction(self)
        self.actionSo = QtGui.QAction(self)
        self.actionProduct = QtGui.QAction(self)
        self.actionProvider = QtGui.QAction(self)
        self.actionClient_2 = QtGui.QAction(self)
        self.actionSo_2 = QtGui.QAction(self)
        self.actionProduct_2 = QtGui.QAction(self)
        self.actionProvider_2 = QtGui.QAction(self)
        self.menuNew.addAction(self.actionClient)
        self.menuNew.addAction(self.actionSo)
        self.menuNew.addAction(self.actionProduct)
        self.menuNew.addAction(self.actionProvider)
        self.menuPesquisar.addAction(self.actionClient_2)
        self.menuPesquisar.addAction(self.actionSo_2)
        self.menuPesquisar.addAction(self.actionProduct_2)
        self.menuPesquisar.addAction(self.actionProvider_2)
        self.menuFile.addAction(self.menuNew.menuAction())
        self.menuFile.addAction(self.menuPesquisar.menuAction())
        self.menuHelp.addAction(self.actionManual)
        self.menuHelp.addAction(self.actionSupport)
        self.menuHelp.addAction(self.actionAbout)
        self.menubar.addAction(self.menuFile.menuAction())
        self.menubar.addAction(self.menuHelp.menuAction())
        self.menubar.addAction(self.menuExit.menuAction())

        QtCore.QMetaObject.connectSlotsByName(self)

        self.setWindowTitle("HL INFORMÁTICA")
        self.leSearch.setPlaceholderText(" Pesquisar...")
        self.cbSearch.setItemText(0, "Ordem de Serviço")
        self.cbSearch.setItemText(1, "Cliente")
        self.cbSearch.setItemText(2, "Produto")
        self.cbSearch.setItemText(3, "CPF")
        self.cbSearch.setItemText(4, "Marca")
        self.cbSearch.setItemText(5, "Modelo")
        self.pbClient.setText("Clientes")
        self.pbSo.setText("Ordem de Serviço")
        self.pbStock.setText("Estoque")
        self.pbFinancial.setText("Financeiro")
        self.pbSales.setText("Ponto de Vendas")
        self.pbTeam.setText("Equipe")
        self.pbProvider.setText("Fornecedores")
        self.pbSettings.setText("Ajustes")
        self.menuFile.setTitle("Arquivo")
        self.menuNew.setTitle("Novo")
        self.menuPesquisar.setTitle("Pesquisar")
        self.menuHelp.setTitle("Ajuda")
        self.menuExit.setTitle("Sair")
        self.actionManual.setText("Manual")
        self.actionSupport.setText("Suporte")
        self.actionAbout.setText("Sobre")
        self.actionClient.setText("Cliente")
        self.actionSo.setText("Ordem Serviço")
        self.actionProduct.setText("Produto")
        self.actionProvider.setText("Fornecedor")
        self.actionClient_2.setText("Cliente")
        self.actionSo_2.setText("Ordem Serviço")
        self.actionProduct_2.setText("Produto")
        self.actionProvider_2.setText("Fornecedor")
        self.pbClient.clicked.connect(self.openCli)

    def openCli(self):
        from clients import ClientUi
        import viacep
        c = ClientUi(self)
        c.show()



if __name__=='__main__':
    root = QtGui.QApplication(sys.argv)
    app = Login()
    app.show()
    root.exec_()