class InventoryViewWidget(FWidget): def __init__(self, parent=0, *args, **kwargs): super(InventoryViewWidget, self).__init__( parent=parent, *args, **kwargs) self.parent = parent self.title = u"Inventaire des articles" self.parentWidget().setWindowTitle(Config.NAME_ORGA + " " + self.title) self.invent_table = InventoryTableWidget(parent=self) self.on_date = FormatDate(QtCore.QDate(date.today().year, 1, 1)) self.end_date = FormatDate(QtCore.QDate.currentDate()) self.btt_ok = BttSmall(u"Ok") self.btt_ok.clicked.connect(self.rapport_filter) self.btt_export = BttExportXLS(u"Exporter") self.btt_export.clicked.connect(self.export_xls) self.btt_export.setEnabled(False) vbox = QtGui.QVBoxLayout() # Grid gridbox = QtGui.QGridLayout() gridbox.addWidget(FormLabel(u"Date debut"), 0, 1) gridbox.addWidget(self.on_date, 0, 2) gridbox.addWidget(FormLabel(u"Date fin"), 1, 1) gridbox.addWidget(self.end_date, 1, 2) gridbox.addWidget(self.btt_ok, 1, 3) gridbox.setColumnStretch(4, 5) gridbox.addWidget(self.btt_export, 1, 6) vbox.addWidget(FPageTitle(self.title)) vbox.addLayout(gridbox) vbox.addWidget(self.invent_table) self.setLayout(vbox) def refresh(self): self.invent_table.refresh() def rapport_filter(self): self.btt_export.setEnabled(True) self.invent_table.refresh_(on=date_on_or_end(self.on_date.text()), end=date_on_or_end(self.end_date.text(), on=False)) def export_xls(self): dict_data = { 'file_name': "inventaire.xls", 'headers': self.invent_table.hheaders, 'data': self.invent_table.data, 'sheet': self.title, 'widths': self.invent_table.stretch_columns, "date": "Du " + self.on_date.text() + " au " + self.end_date.text() } export_dynamic_data(dict_data)
def __init__(self, parent=0, *args, **kwargs): super(InventoryViewWidget, self).__init__( parent=parent, *args, **kwargs) self.parent = parent self.title = u"Inventaire des articles" self.parentWidget().setWindowTitle(Config.NAME_ORGA + " " + self.title) self.invent_table = InventoryTableWidget(parent=self) self.on_date = FormatDate(QtCore.QDate(date.today().year, 1, 1)) self.end_date = FormatDate(QtCore.QDate.currentDate()) self.btt_ok = BttSmall(u"Ok") self.btt_ok.clicked.connect(self.rapport_filter) self.btt_export = BttExportXLS(u"Exporter") self.btt_export.clicked.connect(self.export_xls) self.btt_export.setEnabled(False) vbox = QtGui.QVBoxLayout() # Grid gridbox = QtGui.QGridLayout() gridbox.addWidget(FormLabel(u"Date debut"), 0, 1) gridbox.addWidget(self.on_date, 0, 2) gridbox.addWidget(FormLabel(u"Date fin"), 1, 1) gridbox.addWidget(self.end_date, 1, 2) gridbox.addWidget(self.btt_ok, 1, 3) gridbox.setColumnStretch(4, 5) gridbox.addWidget(self.btt_export, 1, 6) vbox.addWidget(FPageTitle(self.title)) vbox.addLayout(gridbox) vbox.addWidget(self.invent_table) self.setLayout(vbox)