class ContactNewViewWidget(QDialog, FWidget):
def __init__(self, parent, *args, **kwargs):
QDialog.__init__(self, parent, *args, **kwargs)
vbox = QVBoxLayout()
vbox.addWidget(FBoxTitle(u"<h3>Ajout de contact </h3>"))
self.combo_grp = QComboBox()
groups = Group()
groups.name = "Aucun"
self.list_grp = Group.all()
self.list_grp.append(groups)
self.list_grp.reverse()
for index in self.list_grp:
sentence = u"%(name)s" % {'name': index.name}
self.combo_grp.addItem(sentence)
self.full_name = LineEdit()
self.msg_e_or_c = FLabel("")
self.full_name.setFont(QFont("Arial", 16))
self.phone_number = IntLineEdit()
self.phone_number.setInputMask("D9.99.99.99")
self.phone_number.setAlignment(Qt.AlignCenter)
self.phone_number.setFont(QFont("Arial", 16))
send_butt = Button(u"Enregistrer")
send_butt.clicked.connect(self.save_form)
cancel_but = Button(u"Fermer")
cancel_but.clicked.connect(self.cancel)
formbox = QGridLayout()
formbox.addWidget(FLabel(u"Groupes:"), 0, 0)
formbox.addWidget(self.combo_grp, 1, 0)
formbox.addWidget(FLabel(u"Nom complèt: "), 0, 1)
formbox.addWidget(self.full_name, 1, 1)
formbox.addWidget(FLabel(u"Numéro: "), 0, 2)
formbox.addWidget(self.phone_number, 1, 2)
formbox.addWidget(send_butt, 2, 1)
formbox.addWidget(cancel_but, 2, 0)
formbox.addWidget(self.msg_e_or_c, 3, 0, 3, 2)
vbox.addLayout(formbox)
self.setLayout(vbox)
def cancel(self):
self.close()
def iscomplet(self):
self.phone_number.setStyleSheet("")
self.msg_e_or_c.setText("")
self.msg_e_or_c.setStyleSheet("")
try:
int(self.phone_number.text().replace('.', ''))
except:
self.phone_number.setStyleSheet("border-bottom: 3px solid red;"
"background-color:#AFAFAF;")
self.phone_number.setToolTip(u"Ce champ est obligatoire.")
return False
return True
def save_form(self):
if not self.iscomplet():
return
full_name = unicode(self.full_name.text())
phone_number = int(self.phone_number.text().replace('.', ''))
try:
Contact(number=phone_number, name=full_name).save()
except:
self.msg_e_or_c.setText(u"Ce numéro existe déjà")
self.msg_e_or_c.setStyleSheet("color: red")
return
grp = unicode(self.list_grp[self.combo_grp.currentIndex()])
if not grp == "Aucun":
grp = Group.select().where(Group.name == grp).get()
contact = Contact.select().where(Contact.number == phone_number).get()
ContactGroup(group=grp.id, contact=contact).save()
self.full_name.setText("")
self.phone_number.setText("")
self.msg_e_or_c.setText(u"Le numéro (<b>{}</b>) à éte bien enregistré"
.format(phone_number))
class ContactNewViewWidget(QDialog, FWidget):
def __init__(self, parent, *args, **kwargs):
QDialog.__init__(self, parent, *args, **kwargs)
vbox = QVBoxLayout()
vbox.addWidget(FBoxTitle(u"<h3>Ajout de contact </h3>"))
self.combo_grp = QComboBox()
groups = Group()
groups.name = "Aucun"
self.list_grp = Group.all()
self.list_grp.append(groups)
self.list_grp.reverse()
for index in self.list_grp:
sentence = u"%(name)s" % {'name': index.name}
self.combo_grp.addItem(sentence)
self.full_name = LineEdit()
self.msg_e_or_c = FLabel("")
self.full_name.setFont(QFont("Arial", 16))
self.phone_number = IntLineEdit()
self.phone_number.setInputMask("D9.99.99.99")
self.phone_number.setAlignment(Qt.AlignCenter)
self.phone_number.setFont(QFont("Arial", 16))
send_butt = Button(u"Enregistrer")
send_butt.clicked.connect(self.save_form)
cancel_but = Button(u"Fermer")
cancel_but.clicked.connect(self.cancel)
formbox = QGridLayout()
formbox.addWidget(FLabel(u"Groupes:"), 0, 0)
formbox.addWidget(self.combo_grp, 1, 0)
formbox.addWidget(FLabel(u"Nom complèt: "), 0, 1)
formbox.addWidget(self.full_name, 1, 1)
formbox.addWidget(FLabel(u"Numéro: "), 0, 2)
formbox.addWidget(self.phone_number, 1, 2)
formbox.addWidget(send_butt, 2, 1)
formbox.addWidget(cancel_but, 2, 0)
formbox.addWidget(self.msg_e_or_c, 3, 0, 3, 2)
vbox.addLayout(formbox)
self.setLayout(vbox)
def cancel(self):
self.close()
def iscomplet(self):
self.phone_number.setStyleSheet("")
self.msg_e_or_c.setText("")
self.msg_e_or_c.setStyleSheet("")
try:
int(self.phone_number.text().replace('.', ''))
except:
self.phone_number.setStyleSheet("border-bottom: 3px solid red;"
"background-color:#AFAFAF;")
self.phone_number.setToolTip(u"Ce champ est obligatoire.")
return False
return True
def save_form(self):
if not self.iscomplet():
return
full_name = unicode(self.full_name.text())
phone_number = int(self.phone_number.text().replace('.', ''))
try:
Contact(number=phone_number, name=full_name).save()
except:
self.msg_e_or_c.setText(u"Ce numéro existe déjà")
self.msg_e_or_c.setStyleSheet("color: red")
return
grp = unicode(self.list_grp[self.combo_grp.currentIndex()])
if not grp == "Aucun":
grp = Group.select().where(Group.name == grp).get()
contact = Contact.select().where(
Contact.number == phone_number).get()
ContactGroup(group=grp.id, contact=contact).save()
self.full_name.setText("")
self.phone_number.setText("")
self.msg_e_or_c.setText(
u"Le numéro (<b>{}</b>) à éte bien enregistré".format(
phone_number))
class InvoiceViewWidget(FWidget):
def __init__(self, product="", parent=0, *args, **kwargs):
super(InvoiceViewWidget, self).__init__(parent=parent, *args, **kwargs)
self.parentWidget().setWindowTitle(Config.NAME_ORGA + u" FACTURATION")
self.parent = parent
vbox = QVBoxLayout(self)
hbox = QHBoxLayout(self)
editbox = QGridLayout()
self.num_invoice = IntLineEdit("%d" % (Invoice.select().count() + 1))
self.num_invoice.setToolTip(u"Le numéro de la facture")
self.num_invoice.setMaximumSize(40, self.num_invoice.maximumSize().height())
self.num_invoice_error = ErrorLabel("")
self.invoice_date = FormatDate(QDate.currentDate())
self.name_client = QLineEdit()
self.name_client.setMaximumSize(200, self.name_client.maximumSize().height())
self.name_client.setToolTip("Taper le nom du client")
self.name_client_error = ErrorLabel("")
self.search_field = QLineEdit()
self.search_field.setMaximumSize(200, self.search_field.maximumSize().height())
self.search_field.textChanged.connect(self.finder)
self.vline = QFrame()
self.vline.setFrameShape(QFrame.VLine)
self.vline.setFrameShadow(QFrame.Sunken)
self.table_invoice = OrderTableWidget(parent=self)
self.table_resultat = ResultatTableWidget(parent=self)
self.table_info = InfoTableWidget(parent=self)
self.table_resultat.refresh_("")
editbox.addWidget(FormLabel(u"Recherche:"), 0, 0)
editbox.addWidget(self.search_field, 1, 0)
editbox.addWidget(self.vline, 0, 1, 2, 5)
editbox.addWidget(FormLabel(u"Facture N°:"), 0, 2)
editbox.addWidget(self.num_invoice, 0, 3)
editbox.addWidget(self.num_invoice_error, 0, 4)
editbox.addWidget(FormLabel(u"Doit:"), 1, 2)
editbox.addWidget(self.name_client, 1, 3)
editbox.addWidget(self.name_client_error, 1, 4)
editbox.addWidget(FormLabel(u"Date:"), 0, 5)
editbox.addWidget(self.invoice_date, 0, 6)
splitter = QSplitter(Qt.Horizontal)
splitter_left = QSplitter(Qt.Vertical)
splitter_down = QSplitter(Qt.Vertical)
splitter_left.addWidget(FBoxTitle(u"Les resultats"))
splitter_left.addWidget(self.table_resultat)
splitter_down.resize(15, 20)
splitter_down.addWidget(self.table_info)
splitter_rigth = QSplitter(Qt.Vertical)
splitter_rigth.addWidget(FBoxTitle(u"Les produits vendus"))
splitter_rigth.addWidget(self.table_invoice)
splitter_rigth.resize(500, 900)
splitter_left.addWidget(splitter_down)
splitter.addWidget(splitter_left)
splitter.addWidget(splitter_rigth)
hbox.addWidget(splitter)
vbox.addLayout(editbox)
vbox.addLayout(hbox)
self.setLayout(vbox)
def finder(self):
completion_values = []
search_term = self.search_field.text()
# try:
# products = Product.select().where(Product.name.icontains(search_term))
# except ValueError:
# pass
# for product in products:
# last_r = product.last_report_by_prod()
# try:
# completion_values.append(last_r.product.__str__())
# except:
# pass
# completer = QCompleter(completion_values, parent=self)
# completer.setCaseSensitivity(Qt.CaseInsensitive)
# completer.setCompletionMode(QCompleter.UnfilteredPopupCompletion)
# self.search_field.setCompleter(completer)
self.table_resultat.refresh_(search_term)
def save_b(self):
''' add operation '''
# entete de la facture
if not self.table_invoice.isvalid:
return False
try:
num_invoice = int(self.num_invoice.text())
self.num_invoice_error.setText(u"")
except:
self.pixmap = QPixmap(u"{img_media}{img}".format(img_media=Config.img_media,
img="warning.png"))
self.num_invoice.setStyleSheet("background-color: rgb(255, 235, 235);")
self.num_invoice_error.setToolTip(u"Le numero de facture est obligatoire.")
self.num_invoice_error.setPixmap(self.pixmap)
invoice_date = str(self.invoice_date.text())
name_client = str(self.name_client.text())
datetime_ = date_to_datetime(invoice_date)
values_t = self.table_invoice.get_table_items()
if name_client == "":
self.name_client.setStyleSheet("background-color: rgb(255, 235, 235);")
self.pixmap = QPixmap(u"{img_media}{img}".format(img_media=Config.img_media,
img="decline.png"))
self.name_client_error.setToolTip(u"Nom du client est obligatoire.")
self.name_client_error.setPixmap(self.pixmap)
return False
# if num_invoice > Config.credit:
# raise_error(("Avertisement"), u"<h2>Veuillez payer la reste de la licence</h2>")
# return False
invoice = Invoice()
try:
invoice.owner = Owner.get(islog=True)
except:
if Config.DEBUG:
invoice.owner = Owner.get(username='******')
else:
return False
invoice.number = num_invoice
invoice.date_ord = datetime_
invoice.client = name_client.capitalize()
invoice.location = "Bamako"
invoice.type_ = "Facture"
invoice.subject = ""
invoice.tax = False
invoice.otax_rate = 18
try:
invoice.save()
except:
raise_error("Erreur", u"Impossible d'enregistrer l'entête de la facture")
return False
# Save orderitems
try:
order = Invoice.get(number=num_invoice)
except:
return False
for i in values_t:
qty, name, price = i
description = Product.filter(name=name).get()
item = InvoiceItem()
item.invoices = invoice.id
item.quantity = int(i[0])
item.description = description
item.price = int(i[2])
try:
item.save()
self.name_client.clear()
self.num_invoice.clear()
except Exception as e:
print(e)
invoice.delete_instance()
raise_error("Erreur", u"Ce mouvement n'a pas pu etre "
u"enregistré dans les rapports")
return False
self.change_main_context(ShowInvoiceViewWidget,
invoice=invoice)
class InvoiceViewWidget(FWidget):
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 add_clt(self):
from GCommon.ui.provider_client_edit_add import EditOrAddClientOrProviderDialog
self.open_dialog(EditOrAddClientOrProviderDialog, modal=True,
prov_clt=None, table_p=self)
def finder(self):
search_term = self.search_field.text()
value = unicode(search_term)
self.table_resultat.refresh_(value)
def is_valide(self):
print("is_valide")
try:
self.name_client, self.phone = self.name_client_field.lineEdit().text().split(
",")
except Exception as e:
# print(e)
field_error(
self.name_client_field, "Nom, numéro de téléphone du client")
return False
return True
def save_b(self):
''' add operation '''
# entete de la facture
print("save")
if not self.is_valide():
return
invoice_date = unicode(self.invoice_date.text())
num_invoice = int(self.num_invoice.text())
invoice_type = self.liste_type_invoice[
self.box_type_inv.currentIndex()]
lis_error = []
invoice = Invoice()
try:
self.owner = Owner.get(Owner.islog == True)
except:
lis_error.append("Aucun utilisateur est connecté <br/>")
paid_amount = int(self.table_invoice.paid_amount_field.text())
try:
clt = ProviderOrClient.get_or_create(
self.name_client, int(self.phone.replace(" ", "")), ProviderOrClient.CLT)
except ValueError:
field_error(
self.name_client_field, "Nom, numéro de téléphone du client")
invoice.number = num_invoice
invoice.owner = self.owner
invoice.client = clt
invoice.location = "Bamako"
invoice.type_ = invoice_type
invoice.subject = ""
invoice.paid_amount = paid_amount
invoice.tax = False
try:
invoice.save()
if int(paid_amount) != 0 or invoice_type == Invoice.TYPE_BON:
Refund(type_=Refund.DT, owner=self.owner, amount=paid_amount,
date=date_to_datetime(invoice_date), provider_client=clt,
invoice=Invoice.get(number=num_invoice)).save()
except Exception as e:
invoice.deletes_data()
lis_error.append(
"Erreur sur l'enregistrement d'entête de facture<br/>")
return False
# Save invoiceitems
invoice = Invoice.get(Invoice.number == num_invoice)
for name, qty, price in self.table_invoice.get_table_items():
rep = Report()
product = Product.get(Product.name == name)
rep.store = 1
rep.product = product
rep.invoice = invoice
rep.type_ = Report.S
rep.cost_buying = int(product.last_report.cost_buying)
rep.date = date_to_datetime(invoice_date)
rep.qty = int(qty)
rep.selling_price = int(price)
try:
rep.save()
except Exception as e:
lis_error.append(e)
if lis_error != []:
invoice.delete_instance()
self.parent.Notify(lis_error, "error")
return False
else:
self.parent.Notify("Facture Enregistrée avec succès", "success")
self.change_main_context(ShowInvoiceViewWidget,
invoice_num=invoice.number)
class InvoiceViewWidget(FWidget):
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)
def add_clt(self):
from GCommon.ui.provider_client_edit_add import EditOrAddClientOrProviderDialog
self.open_dialog(EditOrAddClientOrProviderDialog,
modal=True,
prov_clt=None,
table_p=self)
def finder(self):
search_term = self.search_field.text()
value = unicode(search_term)
self.table_resultat.refresh_(value)
def is_valide(self):
print("is_valide")
try:
self.name_client, self.phone = self.name_client_field.lineEdit(
).text().split(",")
except Exception as e:
# print(e)
field_error(self.name_client_field,
"Nom, numéro de téléphone du client")
return False
return True
def refresh_(self):
pass
def save_b(self):
''' add operation '''
# entete de la facture
print("save")
if not self.is_valide():
return
invoice_date = unicode(self.invoice_date.text())
num_invoice = int(self.num_invoice.text())
invoice_type = self.liste_type_invoice[
self.box_type_inv.currentIndex()]
lis_error = []
invoice = Invoice()
try:
self.owner = Owner.get(Owner.islog == True)
except:
lis_error.append("Aucun utilisateur est connecté <br/>")
paid_amount = int(self.table_invoice.paid_amount_field.text())
try:
clt = ProviderOrClient.get_or_create(
self.name_client, int(self.phone.replace(" ", "")),
ProviderOrClient.CLT)
except ValueError:
field_error(self.name_client_field,
"Nom, numéro de téléphone du client")
invoice.number = num_invoice
invoice.owner = self.owner
invoice.client = clt
invoice.location = "Bamako"
invoice.type_ = invoice_type
invoice.subject = ""
invoice.paid_amount = paid_amount
invoice.tax = False
try:
invoice.save()
if int(paid_amount) != 0 or invoice_type == Invoice.TYPE_BON:
Refund(type_=Refund.DT,
owner=self.owner,
amount=paid_amount,
date=date_to_datetime(invoice_date),
provider_client=clt,
invoice=Invoice.get(number=num_invoice)).save()
except Exception as e:
invoice.deletes_data()
lis_error.append(
"Erreur sur l'enregistrement d'entête de facture<br/>")
return False
# Save invoiceitems
invoice = Invoice.get(Invoice.number == num_invoice)
for name, qty, price in self.table_invoice.get_table_items():
rep = Report()
product = Product.get(Product.name == name)
rep.store = 1
rep.product = product
rep.invoice = invoice
rep.type_ = Report.S
rep.cost_buying = int(product.last_report.cost_buying)
rep.date = date_to_datetime(invoice_date)
rep.qty = int(qty)
rep.selling_price = int(price)
try:
rep.save()
except Exception as e:
lis_error.append(e)
if lis_error != []:
invoice.delete_instance()
self.parent.Notify(lis_error, "error")
return False
else:
self.parent.Notify("Facture Enregistrée avec succès", "success")
self.table_invoice._reset()
try:
self.parent.open_dialog(ShowInvoiceViewWidget,
modal=True,
opacity=100,
table_p=self,
invoice_num=invoice.number)
except Exception as e:
print(e)
