def __init__(self, parent=None):
super(MainWindowLib, self).__init__(parent)
self.setupUi(self)
initDB()
self.session = Session()
self.header = [
'Code', 'Designation', 'Famille', 'Auteur', 'Editeur',
'Prix d\'achat (F CFA)', 'Prix de vente (F CFA)', 'Date d\'ajout'
]
self.articles = self.session.query(Article).all()
self.article_table_model = ArticleTableModel(articles=self.articles,
header=self.header)
# self.model = QStandardItemModel()
# self.model.setHorizontalHeaderLabels(['Name', 'Age', 'Sex', 'Add'])
# self.article_table_model.setHorizontalHeaderLabels(self.header)
self.tableView.setModel(self.article_table_model)
self.tableView.resizeColumnsToContents()
# self.tableView.setHorizontalHeader()
# self.toolBar.addAction(
# QAction(QIcon('img/interface.png'), 'Add', self))
# self.showFullScreen()
self.lineEditSearch.textChanged.connect(self.handleTextChanged)
self.showMaximized()
screen = QDesktopWidget().screenGeometry()
width, height = screen.width(), screen.height()
def __init__(self, articles, parent=None):
super(AddCommandArticleView, self).__init__(parent)
self.setupUi(self)
self.session = Session()
self.articles = self.session.query(Article).all()
self.article = {}
for _article in self.articles:
self.comboBoxArticle.addItem(_article.designation)
def __init__(self, parent=None):
super(ArticleListView, self).__init__(parent)
self.setupUi(self)
self.session = Session()
self.articles = self.session.query(Article).all()
self.header = [
'ID Article', 'Code', 'Designation', 'Famille', 'Auteur',
'Editeur', 'Prix d\'achat (F CFA)', 'Prix de vente (F CFA)',
'Date d\'ajout', 'Quantité en Stock'
]
self.model = ArticleTableModel(self.header, self.articles)
self.tableView.setModel(self.model)
self.tableView.resizeColumnsToContents()
self.lineEditSearchQuery.textChanged.connect(self.handleTextChanged)
def __init__(self, parent=None):
super(ArticleCommandListView, self).__init__(parent)
self.setupUi(self)
self.session = Session()
self.model = QStandardItemModel()
self.model.setHorizontalHeaderLabels(
['Article', 'Quantité', 'Prix U.', 'Cout total'])
self.tableView.setModel(self.model)
self.cmd_articles = []
# self.comboBoxFilter.currentTextChanged.connect(self.filterCurrentTextChanged)
self.entries = self.session.query(CommandEntry).all()
# print("Entries : ", self.entries)
qtes = []
for entry in self.entries:
article = entry.article
qte = entry.cmd_qte
if article is not None:
if article not in self.cmd_articles:
qtes.append(qte)
self.cmd_articles.append(article)
else:
index = self.cmd_articles.index(article)
qtes[index] += qte
i = 0
for article in self.cmd_articles:
selling_price = article.selling_price
qte = qtes[i]
item_designation = QStandardItem(article.designation)
item_qte = QStandardItem(str(qte))
item_price = QStandardItem(selling_price)
item_total_price = QStandardItem(
str(int(float(selling_price)) * int(qte)))
self.model.setItem(i, 0, item_designation)
self.model.setItem(i, 1, item_qte)
self.model.setItem(i, 2, item_price)
self.model.setItem(i, 3, item_total_price)
i += 1
self.labelTotalArticle.setText(str(len(self.cmd_articles)))
self.session.close()
def __init__(self, parent=None):
super(CommandListView, self).__init__(parent)
self.setupUi(self)
self.session = Session()
self.model = QStandardItemModel()
self.tableView.setModel(self.model)
self.comboBoxFilter.currentTextChanged.connect(
self.comboBoxFilter_currentTextChanged)
self.model.setHorizontalHeaderLabels([
'No', 'Nb articles', 'Cout total', 'Motif', 'Fournisseur',
'Date de Reception'
])
self._filter_text = self.comboBoxFilter.currentText()
self._filter = self.format_filter(self._filter_text)
# self.commands = self.get_filtered_commands(self._filter)
self.commands = self.session.query(Command).order_by(
desc(Command.created_at)).all()
self.populate_data_to_tableView(self.commands)