Example #1
0
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)
Example #2
0
    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)