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)