def refresh_(self, provid_clt=None):
""" Rafraichir la liste des provid_cltes"""
self.clear()
self.addItem(ProviderOrClientQListWidgetItem(ALL_CONTACTS))
qs = ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT)
if provid_clt:
qs = qs.where(ProviderOrClient.name.contains(provid_clt))
for provid_clt in qs:
self.addItem(ProviderOrClientQListWidgetItem(provid_clt))
def refresh_(self, provid_clt=None):
""" Rafraichir la liste des provid_cltes"""
self.clear()
self.addItem(ProviderOrClientQListWidgetItem(ALL_CONTACTS))
qs = ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT)
if provid_clt:
qs = qs.where(ProviderOrClient.name.contains(provid_clt))
for provid_clt in qs:
self.addItem(ProviderOrClientQListWidgetItem(provid_clt))
def __init__(self, parent=0, *args, **kwargs):
super(ProvidersViewWidget, self).__init__(parent=parent,
*args,
**kwargs)
self.parent = parent
self.title = u"Movements"
self.on_date = FormatDate(QDate(date.today().year, 1, 1))
self.end_date = FormatDate(QDate.currentDate())
# self.now = datetime.now().strftime("%x")
self.soldeField = FormLabel("{}".format(device_amount(0)))
balanceBox = QGridLayout()
balanceBox.addWidget(self.soldeField, 0, 3)
balanceBox.setColumnStretch(0, 1)
self.string_list = [""] + [
"{},{}".format(clt.name, clt.phone)
for clt in ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT).order_by(
ProviderOrClient.name.desc())
]
self.name_client_field = ExtendedComboBox()
self.name_client_field.addItems(self.string_list)
self.name_client_field.setMaximumSize(
200,
self.name_client_field.maximumSize().height())
self.name_client_field.setToolTip("Nom, numero du client")
self.table = RapportTableWidget(parent=self)
self.button = Button(u"Ok")
self.button.clicked.connect(self.refresh_prov_clt)
self.btt_export = BttExportXLSX(u"Exporter")
self.btt_export.clicked.connect(self.export_xls)
editbox = QGridLayout()
editbox.addWidget(FormLabel(u"Date debut"), 0, 1)
editbox.addWidget(self.on_date, 0, 2)
editbox.addWidget(FormLabel(u"Date fin"), 1, 1)
editbox.addWidget(self.end_date, 1, 2)
editbox.addWidget(self.name_client_field, 0, 3)
editbox.addWidget(self.button, 1, 3)
editbox.addWidget(self.btt_export, 1, 7)
editbox.setColumnStretch(4, 2)
vbox = QVBoxLayout()
vbox.addWidget(FPageTitle(self.title))
vbox.addLayout(editbox)
vbox.addWidget(self.table)
vbox.addLayout(balanceBox)
self.setLayout(vbox)
def set_data_for(self, value):
if value:
value = str(value)
if is_int(value):
qs = ((Invoice.number == int(value)))
invoices = Invoice.select().where(qs)
else:
invoices = []
for clt in ProviderOrClient.select().where(
ProviderOrClient.name.contains(value)).iterator():
for invoice in clt.invoices().iterator():
invoices.append(invoice)
else:
invoices = Invoice.select()[:100]
try:
self.data = [(invoice.number, invoice.date, invoice.client, "")
for invoice in invoices]
except Exception as e:
print("Exception ", e)
def set_data_for(self, provid_clt_id=None, search=None):
self.provid_clt_id = provid_clt_id
qs = Refund.select().where(Refund.status == False).order_by(
Refund.date.desc())
self.remaining = 0
if isinstance(provid_clt_id, int):
qs = qs.select().where(
Refund.provider_client == ProviderOrClient.get(
id=provid_clt_id))
else:
for prov in ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT):
self.remaining += prov.last_remaining()
self.parent.remaining_box.setText(
self.display_remaining(formatted_number(self.remaining)))
self.data = [(ref.id, ref.type_, ref.date, ref.invoice.number,
ref.amount, ref.remaining) for ref in qs.iterator()]
def __init__(self, product="", parent=0, *args, **kwargs):
super(InvoiceViewWidget, self).__init__(parent=parent, *args, **kwargs)
self.parentWidget().setWindowTitle(
Config.APP_NAME + u" Ventes")
self.parent = parent
vbox = QVBoxLayout(self)
# hbox = QHBoxLayout(self)
editbox = QGridLayout(self)
try:
next_number = int(
Invoice.select().order_by(Invoice.number.desc()).get().number) + 1
except:
next_number = 1
self.num_invoice = IntLineEdit(str(next_number))
self.num_invoice.setToolTip(u"Le numéro")
self.num_invoice.setMaximumSize(
40, self.num_invoice.maximumSize().height())
self.invoice_date = FormatDate(QDate.currentDate())
# self.name_client_field = LineEdit()
self.string_list = [""] + ["{},{}".format(clt.name, clt.phone)
for clt in ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT).order_by(ProviderOrClient.name.desc())]
# self.name_client_field_new = ""
self.name_client_field = ExtendedComboBox()
self.name_client_field.addItems(self.string_list)
self.name_client_field.setMaximumSize(
200, self.name_client_field.maximumSize().height())
self.name_client_field.setToolTip("Nom, numero du client")
self.add_clt_btt = BttSmall(u"+")
self.add_clt_btt.clicked.connect(self.add_clt)
self.add_clt_btt.setFixedWidth(50)
# Combobox widget for add store
self.liste_type_invoice = [Invoice.TYPE_FACT, Invoice.TYPE_BON]
self.box_type_inv = QComboBox()
for index in range(0, len(self.liste_type_invoice)):
op = self.liste_type_invoice[index]
sentence = u"%(name)s" % {'name': op}
self.box_type_inv.addItem(sentence, op)
self.search_field = LineEdit()
self.search_field.setPlaceholderText("Rechercher un article")
self.search_field.textChanged.connect(self.finder)
# self.search_field.setFixedWidth(250)
self.table_invoice = InvoiceTableWidget(parent=self)
self.table_resultat = ResultatTableWidget(parent=self)
self.table_info = InfoTableWidget(parent=self)
self.table_resultat.refresh_("")
editbox.addWidget(self.box_type_inv, 0, 2)
editbox.addWidget(self.num_invoice, 0, 3)
editbox.addWidget(FLabel(u"Doit :"), 1, 2)
editbox.addWidget(self.name_client_field, 1, 3)
# editbox.addWidget(self.add_clt_btt, 1, 4)
editbox.addWidget(self.invoice_date, 0, 6)
editbox.setColumnStretch(0, 1)
editbox.setColumnStretch(5, 1)
splitter = QSplitter(Qt.Horizontal)
splitter_left = QSplitter(Qt.Vertical)
splitter_left.addWidget(self.search_field)
splitter_left.addWidget(self.table_resultat)
# splitter_down.resize(15, 20)
splitter_down = QSplitter(Qt.Vertical)
splitter_down.addWidget(self.table_info)
splitter_rigth = QSplitter(Qt.Vertical)
# splitter_rigth.setLayout(editbox)
splitter_rigth.addWidget(self.table_invoice)
splitter_rigth.resize(800, 900)
splitter_left.addWidget(splitter_down)
splitter.addWidget(splitter_left)
splitter.addWidget(splitter_rigth)
vbox.addLayout(editbox)
vbox.addWidget(splitter)
self.setLayout(vbox)
def __init__(self, product="", parent=0, *args, **kwargs):
super(InvoiceViewWidget, self).__init__(parent=parent, *args, **kwargs)
self.parentWidget().setWindowTitle(Config.APP_NAME + u" Ventes")
self.parent = parent
vbox = QVBoxLayout()
# hbox = QHBoxLayout(self)
editbox = QGridLayout()
try:
next_number = int(Invoice.select().order_by(
Invoice.number.desc()).get().number) + 1
except:
next_number = 1
self.num_invoice = IntLineEdit(str(next_number))
self.num_invoice.setToolTip(u"Le numéro")
self.num_invoice.setMaximumSize(
40,
self.num_invoice.maximumSize().height())
self.invoice_date = FormatDate(QDate.currentDate())
# self.name_client_field = LineEdit()
self.string_list = [""] + [
"{},{}".format(clt.name, clt.phone)
for clt in ProviderOrClient.select().where(
ProviderOrClient.type_ == ProviderOrClient.CLT).order_by(
ProviderOrClient.name.desc())
]
# self.name_client_field_new = ""
self.name_client_field = ExtendedComboBox()
self.name_client_field.addItems(self.string_list)
self.name_client_field.setMaximumSize(
200,
self.name_client_field.maximumSize().height())
self.name_client_field.setToolTip("Nom, numero du client")
self.add_clt_btt = BttSmall(u"+")
self.add_clt_btt.clicked.connect(self.add_clt)
self.add_clt_btt.setFixedWidth(50)
# Combobox widget for add store
self.liste_type_invoice = [
Invoice.TYPE_FACT, Invoice.TYPE_BON, Invoice.TYPE_PROF
]
self.box_type_inv = QComboBox()
for index in range(0, len(self.liste_type_invoice)):
op = self.liste_type_invoice[index]
sentence = u"%(name)s" % {'name': op}
self.box_type_inv.addItem(sentence, op)
self.search_field = LineEdit()
self.search_field.setPlaceholderText("Rechercher un article")
self.search_field.textChanged.connect(self.finder)
# self.search_field.setFixedWidth(250)
self.search_field.setMaximumHeight(40)
self.table_invoice = InvoiceTableWidget(parent=self)
self.table_resultat = ResultatTableWidget(parent=self)
self.table_info = InfoTableWidget(parent=self)
self.table_resultat.refresh_("")
editbox.addWidget(self.box_type_inv, 0, 2)
editbox.addWidget(self.num_invoice, 0, 3)
editbox.addWidget(FLabel(u"Doit :"), 1, 2)
editbox.addWidget(self.name_client_field, 1, 3)
# editbox.addWidget(self.add_clt_btt, 1, 4)
editbox.addWidget(self.invoice_date, 0, 6)
editbox.setColumnStretch(0, 1)
editbox.setColumnStretch(5, 1)
splitter = QSplitter(Qt.Horizontal)
splitter_left = QSplitter(Qt.Vertical)
splitter_left.addWidget(self.search_field)
splitter_left.addWidget(self.table_resultat)
# splitter_down.resize(15, 20)
splitter_down = QSplitter(Qt.Vertical)
splitter_down.addWidget(self.table_info)
splitter_rigth = QSplitter(Qt.Vertical)
# splitter_rigth.setLayout(editbox)
splitter_rigth.addWidget(self.table_invoice)
splitter_rigth.resize(800, 900)
splitter_left.addWidget(splitter_down)
splitter.addWidget(splitter_left)
splitter.addWidget(splitter_rigth)
vbox.addLayout(editbox)
vbox.addWidget(splitter)
self.setLayout(vbox)
