def extend_rows(self):
pw = (self.parentWidget().width()) / (len(self.hheaders) + 2)
# if pw == 14:
# pw = 125
self.setColumnWidth(0, pw * 3)
self.setColumnWidth(1, pw)
self.setColumnWidth(2, pw)
self.setColumnWidth(3, pw)
self.setColumnWidth(4, pw)
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows, 0, 2, 2)
mtt_ttc = QTableWidgetItem(u"TOTAUX: ")
mtt_ttc.setTextAlignment(Qt.AlignRight)
self.setItem(nb_rows + 1, 2, mtt_ttc)
self.montant_ht = 0
self.montant_b = 0
for row_num in xrange(0, self.data.__len__()):
mtt = is_int(self.item(row_num, 3).text())
mttb = is_int(self.item(row_num, 4).text())
self.montant_ht += mtt
self.montant_b += mttb
# Montant TTC
montant_t = QTableWidgetItem(formatted_number(self.montant_ht))
montant_t.setTextAlignment(Qt.AlignRight)
montant_tb = QTableWidgetItem(formatted_number(self.montant_b))
montant_tb.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 2, 3, montant_t)
self.setItem(row_num + 2, 4, montant_tb)
def extend_rows(self):
pw = (self.parentWidget().width()) / (len(self.hheaders) + 2)
# if pw == 14:
# pw = 125
self.setColumnWidth(0, pw * 3)
self.setColumnWidth(1, pw)
self.setColumnWidth(2, pw)
self.setColumnWidth(3, pw)
self.setColumnWidth(4, pw)
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows, 0, 2, 2)
mtt_ttc = QTableWidgetItem(u"TOTAUX: ")
mtt_ttc.setTextAlignment(Qt.AlignRight)
self.setItem(nb_rows + 1, 2, mtt_ttc)
self.montant_ht = 0
self.montant_b = 0
for row_num in xrange(0, self.data.__len__()):
mtt = is_int(self.item(row_num, 3).text())
mttb = is_int(self.item(row_num, 4).text())
self.montant_ht += mtt
self.montant_b += mttb
# Montant TTC
montant_t = QTableWidgetItem(formatted_number(self.montant_ht))
montant_t.setTextAlignment(Qt.AlignRight)
montant_tb = QTableWidgetItem(formatted_number(self.montant_b))
montant_tb.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 2, 3, montant_t)
self.setItem(row_num + 2, 4, montant_tb)
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows + 2, 2, 2, 4)
self.totals_debit = 0
self.totals_credit = 0
self.balance_tt = 0
cp = 0
for row_num in range(0, self.data.__len__()):
mtt_debit = is_int(unicode(self.item(row_num, 2).text()))
mtt_credit = is_int(unicode(self.item(row_num, 3).text()))
if cp == 0:
last_balance = is_int(unicode(self.item(row_num, 4).text()))
self.totals_debit += mtt_debit
self.totals_credit += mtt_credit
cp += 1
self.balance_tt = last_balance
# self.balance_tt = self.totals_debit - self.totals_credit
self.label_mov_tt = u"Totals mouvements: "
self.setItem(nb_rows, 1, TotalsWidget(self.label_mov_tt))
self.setItem(nb_rows, 2,
TotalsWidget(formatted_number(self.totals_debit)))
self.setItem(nb_rows, 3,
TotalsWidget(formatted_number(self.totals_credit)))
self.parent.soldeField.setText(formatted_number(self.balance_tt))
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 1)
# self.setSpan(nb_rows, 0, 1, 1)
mtt_ttc = QTableWidgetItem(u"TOTAUX: ")
mtt_ttc.setTextAlignment(Qt.AlignRight)
self.setItem(nb_rows, 0, mtt_ttc)
ttl_remainig = 0
tall_in = 0
tall_out = 0
for row_num in xrange(0, self.data.__len__()):
all_in = is_int(unicode(self.item(row_num, 1).text()))
tall_in += all_in
all_out = is_int(unicode(self.item(row_num, 2).text()))
tall_out += all_out
remaining = is_int(unicode(self.item(row_num, 3).text()))
ttl_remainig += remaining
# Montant TTC
tall_in = QTableWidgetItem(formatted_number(tall_in))
tall_in.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 1, tall_in)
tall_out = QTableWidgetItem(formatted_number(tall_out))
tall_out.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 2, tall_out)
ttl_remainig = QTableWidgetItem(formatted_number(ttl_remainig))
ttl_remainig.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 3, ttl_remainig)
def changed_value(self, refresh=False):
""" Calcule les Resultat """
self.mtt_ht = 0
# self.button.setEnabled(False)
for row_num in xrange(0, self.data.__len__()):
product = Product.get(
Product.name == unicode(self.item(row_num, 0).text()))
last_report = product.last_report
last_price = product.last_price()
qtremaining = last_report.remaining
selling_price = last_price
invoice_date = unicode(self.parent.invoice_date.text())
qtsaisi = is_int(self.cellWidget(row_num, 1).text())
pusaisi = is_int(self.cellWidget(row_num, 2).text())
if check_is_empty(self.parent.num_invoice):
return
if check_is_empty(self.parent.name_client_field.lineEdit()):
return
# if check_field(self.parent.invoice_date,
# "Le {} est Inférieure à la date de la dernière rapport (<b>{}</b>)".format(date_to_datetime(invoice_date), last_report.date), (last_report.date > date_to_datetime(invoice_date))):
# return
if (pusaisi and check_is_empty(self.cellWidget(row_num, 1))):
return
if (pusaisi and check_is_empty(self.cellWidget(row_num, 2))):
return
if check_field(
self.cellWidget(row_num, 1),
u"<b>{}</b> est supérieur à la quantité restante (<b>{}</b>)"
.format(qtsaisi, qtremaining), qtremaining < qtsaisi):
return
if check_field(
self.cellWidget(row_num, 2),
u"<b>{}</b> est inférieure au prix minimum de vente<b> {} CFA</b>"
.format(pusaisi, selling_price), pusaisi < selling_price):
print("E")
# return
montant = (qtsaisi * pusaisi)
self.mtt_ht += montant
self.setItem(row_num, 3, TotalsWidget(formatted_number(montant)))
self._update_data(row_num, [qtsaisi, pusaisi, self.mtt_ht])
self.setItem(row_num + 1, 3,
TotalsWidget(formatted_number(self.mtt_ht)))
typ = self.parent.liste_type_invoice[
self.parent.box_type_inv.currentIndex()]
self.paid_amount_field.setText(
str(self.mtt_ht) if typ == Invoice.TYPE_BON else "0")
self.button.setEnabled(True)
def changed_value(self, refresh=False):
""" Calcule les Resultat """
mtt_ht = 0
for row_num in xrange(0, self.data.__len__()):
last_report = Product.filter(name=str(self.item(row_num, 1)
.text())).get().last_report
try:
qtremaining = last_report.remaining
except AttributeError:
qtremaining = 0
qtsaisi = is_int(self.cellWidget(row_num, 0).text())
pu = is_int(self.cellWidget(row_num, 2).text())
self.isvalid = True
viderreur_qtsaisi = ""
viderreur_pu = ""
stylerreur = "background-color: rgb(255, 235, 235);" + \
"border: 3px double SeaGreen"
if qtsaisi == 0:
viderreur_qtsaisi = stylerreur
self.cellWidget(row_num, 0).setToolTip(u"obligatoire")
self.isvalid = False
if pu == 0:
viderreur_pu = stylerreur
self.cellWidget(row_num, 0).setToolTip(u"obligatoire")
self.isvalid = False
self.cellWidget(row_num, 0).setStyleSheet(viderreur_qtsaisi)
self.cellWidget(row_num, 2).setStyleSheet(viderreur_pu)
self.cellWidget(row_num, 0).setToolTip("")
if qtremaining < qtsaisi:
self.cellWidget(row_num, 0).setStyleSheet("font-size:20px;"
" color: red")
self.cellWidget(row_num,
0).setToolTip(u"%s est > %s (stock"
u" remaining)" % (qtsaisi, qtremaining))
# self.isvalid = False
# return False
ui_item = (qtsaisi * pu)
mtt_ht += ui_item
montt = QTableWidgetItem(formatted_number(ui_item))
montt.setTextAlignment(Qt.AlignRight)
self.setItem(row_num, 3, montt)
monttc = QTableWidgetItem(formatted_number(mtt_ht))
monttc.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 3, monttc)
def get_table_items(self):
""" """
list_order = []
for i in range(self.rowCount() - 1):
liste_item = []
try:
liste_item.append(str(self.item(i, 0).text()))
liste_item.append(is_int(self.item(i, 1).text()))
liste_item.append(is_int(self.cellWidget(i, 2).text()))
liste_item.append(is_int(self.item(i, 3).text()))
list_order.append(liste_item)
except:
liste_item.append("")
return list_order
def get_table_items(self):
""" """
list_invoice = []
for i in range(self.rowCount() - 1):
liste_item = []
try:
liste_item.append(unicode(self.item(i, 0).text()))
liste_item.append(is_int(self.item(i, 1).text()))
liste_item.append(is_int(self.item(i, 2).text()))
liste_item.append(is_int(self.item(i, 3).text()))
list_invoice.append(liste_item)
except:
liste_item.append("")
return list_invoice
def changed_value(self, refresh=False):
some = 0
for row_num in xrange(0, self.data.__len__()):
ui_item = (is_int(self.item(row_num, 1).text()) *
is_int(self.cellWidget(row_num, 2).text()))
some += ui_item
ui_item_ = QTableWidgetItem(formatted_number(ui_item))
ui_item_.setTextAlignment(Qt.AlignRight)
self.setItem(row_num, 3, ui_item_)
row_num += 1
som_val = QTableWidgetItem(formatted_number(some))
som_val.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 2, QTableWidgetItem(u"%s" % u"TOTAUX"))
self.setItem(row_num + 1, 3, som_val)
def get_table_items(self):
""" Recupère les elements du tableau """
list_invoice = []
for i in range(self.rowCount() - 1):
liste_item = []
try:
liste_item.append(is_int(self.item(i, 0).text()))
liste_item.append(unicode(self.item(i, 1).text()))
liste_item.append(is_int(self.item(i, 2).text()))
liste_item.append(is_int(self.item(i, 3).text()))
list_invoice.append(liste_item)
except Exception as e:
print(e)
liste_item.append("")
return list_invoice
def changed_value(self, refresh=False):
some = 0
for row_num in xrange(0, self.data.__len__()):
ui_item = (is_int(self.item(row_num, 1).text()) *
is_int(self.cellWidget(row_num, 2).text()))
some += ui_item
ui_item_ = QTableWidgetItem(formatted_number(ui_item))
ui_item_.setTextAlignment(Qt.AlignRight)
self.setItem(row_num, 3, ui_item_)
row_num += 1
som_val = QTableWidgetItem(formatted_number(some))
som_val.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 1, 2, QTableWidgetItem(u"%s" % u"TOTAUX"))
self.setItem(row_num + 1, 3, som_val)
def get_table_items(self):
""" """
list_invoice = []
for i in range(self.rowCount() - 1):
liste_item = []
try:
liste_item.append(unicode(self.item(i, 0).text()))
liste_item.append(is_int(self.item(i, 1).text()))
liste_item.append(is_int(self.item(i, 2).text()))
liste_item.append(is_int(self.item(i, 3).text()))
list_invoice.append(liste_item)
except:
liste_item.append("")
return list_invoice
def changed_value(self, refresh=False):
""" Calcule les Resultat """
self.mtt_ht = 0
# self.button.setEnabled(False)
for row_num in xrange(0, self.data.__len__()):
product = Product.get(
Product.name == unicode(self.item(row_num, 0).text()))
last_report = product.last_report
last_price = product.last_price()
qtremaining = last_report.remaining
selling_price = last_price
invoice_date = unicode(self.parent.invoice_date.text())
qtsaisi = is_int(self.cellWidget(row_num, 1).text())
pusaisi = is_int(self.cellWidget(row_num, 2).text())
if check_is_empty(self.parent.num_invoice):
return
if check_is_empty(self.parent.name_client_field.lineEdit()):
return
# if check_field(self.parent.invoice_date,
# "Le {} est Inférieure à la date de la dernière rapport (<b>{}</b>)".format(date_to_datetime(invoice_date), last_report.date), (last_report.date > date_to_datetime(invoice_date))):
# return
if (pusaisi and check_is_empty(self.cellWidget(row_num, 1))):
return
if (pusaisi and check_is_empty(self.cellWidget(row_num, 2))):
return
if check_field(self.cellWidget(row_num, 1),
u"<b>{}</b> est supérieur à la quantité restante (<b>{}</b>)".format(
qtsaisi, qtremaining), qtremaining < qtsaisi):
return
if check_field(self.cellWidget(row_num, 2),
u"<b>{}</b> est inférieure au prix minimum de vente<b> {} CFA</b>".format(
pusaisi, selling_price), pusaisi < selling_price):
print("E")
# return
montant = (qtsaisi * pusaisi)
self.mtt_ht += montant
self.setItem(row_num, 3, TotalsWidget(formatted_number(montant)))
self._update_data(row_num, [qtsaisi, pusaisi, self.mtt_ht])
self.setItem(
row_num + 1, 3, TotalsWidget(formatted_number(self.mtt_ht)))
typ = self.parent.liste_type_invoice[
self.parent.box_type_inv.currentIndex()]
self.paid_amount_field.setText(
str(self.mtt_ht) if typ == Invoice.TYPE_BON else "0")
self.button.setEnabled(True)
def save_edit(self):
''' add operation '''
if not self.is_valide():
return
print("Save")
self.member.scoop = self.scoop
self.member.full_name = self.full_name_field.text()
self.member.sex = self.sex_box.itemData(self.sex_box.currentIndex())
self.member.ddn = self.ddn_field.text()
self.member.addres = self.addres_field.toPlainText()
self.member.nationality = self.nationality_field.text()
phone = self.phone_field.text()
self.member.phone = is_int(phone)
self.member.poste = self.poste_box.itemData(
self.poste_box.currentIndex())
try:
self.member.save_()
self.close()
self.table_p.refresh_()
self.parent.Notify(
u"Le membre {} ({}) a été mise à jour".format(
self.member.full_name, self.member.poste), "success")
except peewee.IntegrityError:
field_error(self.full_name_field,
"Ce nom existe dans la basse de donnée.")
def get_table_items(self):
""" Recupère les elements du tableau """
list_invoice = []
for i in range(self.rowCount() - 1):
liste_item = []
try:
liste_item.append(is_int(self.item(i, 0).text()))
liste_item.append(unicode(self.item(i, 1).text()))
liste_item.append(is_int(self.item(i, 2).text()))
liste_item.append(is_int(self.item(i, 3).text()))
list_invoice.append(liste_item)
except Exception as e:
print(e)
liste_item.append("")
print(list_invoice)
return list_invoice
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.montant_ht = 0
for row_num in xrange(0, self.data.__len__()):
self.montant_ht += (is_int(self.item(row_num, 0).text())
* is_int(self.item(row_num, 2).text()))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Totaux : "))
self.setItem(
row_num, 3, TotalsWidget(formatted_number(self.montant_ht)))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Montant payé : "))
self.setItem(row_num, 3, TotalsWidget(
formatted_number(self.montant_ht - self.parent.invoice.paid_amount)))
self.setSpan(nb_rows, 0, 2, 2)
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.montant_ht = 0
for row_num in xrange(0, self.data.__len__()):
self.montant_ht += (is_int(self.item(row_num, 0).text())
* is_int(self.item(row_num, 2).text()))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Totaux : "))
self.setItem(
row_num, 3, TotalsWidget(formatted_number(self.montant_ht)))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Montant payé : "))
self.setItem(row_num, 3, TotalsWidget(
formatted_number(self.montant_ht - self.parent.invoice.paid_amount)))
self.setSpan(nb_rows, 0, 2, 2)
def save(self):
if not self.is_valide():
return
self.scoop = CooperativeCompanie()
self.scoop.office = self.office
self.scoop.created_date = str(self.created_date_field.text())
self.scoop.denomination = str(self.denomination_field.text())
self.scoop.commercial_name = str(self.commercial_name_field.text())
self.scoop.activity = self.activites_box.itemData(
self.activites_box.currentIndex())
self.scoop.spinneret = self.spinneret_box.itemData(
self.spinneret_box.currentIndex())
self.scoop.forme = self.formes_box.itemData(
self.formes_box.currentIndex())
self.scoop.amount_part_social = is_int(
self.amount_part_social_field.text())
self.scoop.apports_numeraire = is_int(
self.apports_numeraire_field.text())
self.scoop.apports_nature = is_int(self.apports_nature_field.text())
self.scoop.apports_industrie = is_int(
self.apports_industrie_field.text())
self.scoop.region = self.office.slug_region
self.scoop.cercle = self.office.slug_cercle
self.scoop.commune = self.commune_box.itemData(
self.commune_box.currentIndex())
self.scoop.vfq = self.vfq_box.itemData(self.vfq_box.currentIndex())
self.scoop.rue = is_int(self.rue_field.text())
self.scoop.porte = is_int(self.porte_field.text())
self.scoop.tel = is_int(self.tel_field.text())
self.scoop.tel2 = is_int(self.tel2_field.text())
self.scoop.bp = is_int(self.bp_field.text())
self.scoop.email = self.email_field.text()
self.scoop.duree_statutaire = is_int(
self.duree_statutaire_field.text())
self.scoop.save_()
check_list = CheckList()
check_list.save_()
self.dmd = Demande()
self.dmd.check_list = check_list
self.dmd.declaration_date = str(self.declaration_date_field.text())
self.dmd.scoop = self.scoop
self.dmd.status = self.dmd.ADDMEMBER
self.dmd.save_()
return True
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows, 0, 2, 2)
self.setItem(nb_rows + 1, 2, TotalsWidget(u"TOTAUX: "))
self.sum_totals = 0
for row_num in xrange(0, self.data.__len__()):
self.sum_totals += is_int(self.item(row_num, 3).text())
self.setItem(row_num + 2, 3,
TotalsWidget(formatted_number(self.sum_totals)))
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows, 0, 2, 2)
self.setItem(nb_rows + 1, 2, TotalsWidget(u"TOTAUX: "))
self.sum_totals = 0
for row_num in xrange(0, self.data.__len__()):
self.sum_totals += is_int(self.item(row_num, 3).text())
self.setItem(
row_num + 2, 3, TotalsWidget(formatted_number(self.sum_totals)))
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows + 2, 2, 2, 4)
cp = 0
self.balance_tt = sum([
is_int(unicode(self.item(row_num, 3).text()))
for row_num in range(0, self.data.__len__())
])
self.label_mov_tt = u"Totals "
self.setItem(nb_rows, 2, TotalsWidget(self.label_mov_tt))
self.setItem(nb_rows, 3, TotalsWidget(device_amount(self.balance_tt)))
def changed_value(self, refresh=False):
""" Calcule les Resultat """
current_store = self.parent.liste_store[
self.parent.box_store.currentIndex()]
for row_num in xrange(0, self.data.__len__()):
self.isvalid = True
try:
last_report = Reports.filter(store=current_store,
product__name=str(self.item(row_num, 1)
.text())).order_by(Reports.date.desc()).get()
qtremaining = last_report.remaining
date_out = str(self.parent.date_out.text())
if last_report.date > date_on_or_end(date_out, on=False):
self.parent.date_out.setStyleSheet("font-size:15px;"
"color:red")
self.parent.date_out.setToolTip(u"Cette date est "
u"Inférieure à la date "
u"de la dernière rapport"
u" (%s) " %
last_report.date)
self.isvalid = False
return False
except Exception as e:
print(e)
qtremaining = 0
qtsaisi = is_int(self.cellWidget(row_num, 0).text())
self._update_data(row_num, [qtsaisi])
viderreur_qtsaisi = ""
stylerreur = "background-color: rgb(255, 235, 235);" + \
"border: 3px double SeaGreen"
if qtsaisi == 0:
viderreur_qtsaisi = stylerreur
self.cellWidget(row_num, 0).setToolTip(u"obligatoire")
self.isvalid = False
self.cellWidget(row_num, 0).setStyleSheet(viderreur_qtsaisi)
self.cellWidget(row_num, 0).setToolTip("")
if qtremaining < qtsaisi:
self.cellWidget(row_num, 0).setStyleSheet("font-size:20px;"
" color: red")
self.cellWidget(row_num, 0).setToolTip(u"%s est > %s (stock"
u" remaining)" % (qtsaisi,
qtremaining))
self.isvalid = False
return False
def changed_value(self, refresh=False):
""" Calcule les Resultat """
b_f_tt = 0
v_amount_tt = 0
for row_num in xrange(0, self.data.__len__()):
qtsaisi = is_int(self.cellWidget(row_num, 1).text()) or 1
cost_buying = is_int(self.cellWidget(row_num, 2).text())
selling_price = is_int(self.cellWidget(row_num, 3).text())
self.isvalid = True
# if not selling_price:
# return
if (selling_price and check_is_empty(self.cellWidget(row_num, 1))):
self.isvalid = False
if (selling_price and check_is_empty(self.cellWidget(row_num, 2))):
self.isvalid = False
if (check_is_empty(self.cellWidget(row_num, 3))):
self.isvalid = False
r_amount = qtsaisi * cost_buying
v_amount = qtsaisi * selling_price
b_f = v_amount - r_amount
b_f_u = b_f / qtsaisi
b_f_tt += b_f
v_amount_tt += v_amount
# montt.setTextAlignment(Qt.AlignRight)
self.setItem(row_num, 4, TotalsWidget(formatted_number(v_amount)))
self.setItem(row_num, 5, TotalsWidget(formatted_number(b_f_u)))
self.setItem(row_num, 6, TotalsWidget(formatted_number(b_f)))
# Mise à jour
self._update_data(
row_num,
[qtsaisi, cost_buying, selling_price, v_amount, b_f_u, b_f])
row_num += 1
self.setItem(row_num, 4, TotalsWidget(formatted_number(v_amount_tt)))
self.setItem(row_num, 6, TotalsWidget(formatted_number(b_f_tt)))
def extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 3)
self.setSpan(nb_rows, 0, 3, 2)
mtt_ttc = QTableWidgetItem(u"Total: ")
mtt_ttc.setTextAlignment(Qt.AlignRight)
self.setItem(nb_rows + 1, 2, mtt_ttc)
montant_ht = 0
for row_num in xrange(0, self.data.__len__()):
quantity = is_int(self.item(row_num, 0).text())
pu = is_int(self.item(row_num, 2).text())
montant_ht += (quantity * pu)
# Montant TTC
montant_ttc = QTableWidgetItem(formatted_number(montant_ht))
montant_ttc.setTextAlignment(Qt.AlignRight)
self.setItem(row_num + 2, 3, montant_ttc)
# bicon = QIcon.fromTheme('', QIcon(u"{}del.png".format(Config.img_media)))
# self.button = QPushButton(bicon, u"Annuler la facture")
self.button = Deleted_btt(u"Annuler la facture")
self.button.released.connect(self.parent.annulation)
def changed_value(self, refresh=False):
""" Calcule les Resultat """
b_f_tt = 0
v_amount_tt = 0
for row_num in xrange(0, self.data.__len__()):
qtsaisi = is_int(self.cellWidget(row_num, 1).text()) or 1
cost_buying = is_int(self.cellWidget(row_num, 2).text())
selling_price = is_int(self.cellWidget(row_num, 3).text())
self.isvalid = True
# if not selling_price:
# return
if (selling_price and check_is_empty(self.cellWidget(row_num, 1))):
self.isvalid = False
if (selling_price and check_is_empty(self.cellWidget(row_num, 2))):
self.isvalid = False
if (check_is_empty(self.cellWidget(row_num, 3))):
self.isvalid = False
r_amount = qtsaisi * cost_buying
v_amount = qtsaisi * selling_price
b_f = v_amount - r_amount
b_f_u = b_f / qtsaisi
b_f_tt += b_f
v_amount_tt += v_amount
# montt.setTextAlignment(Qt.AlignRight)
self.setItem(row_num, 4, TotalsWidget(formatted_number(v_amount)))
self.setItem(row_num, 5, TotalsWidget(formatted_number(b_f_u)))
self.setItem(row_num, 6, TotalsWidget(formatted_number(b_f)))
# Mise à jour
self._update_data(
row_num, [qtsaisi, cost_buying, selling_price, v_amount, b_f_u, b_f])
row_num += 1
self.setItem(row_num, 4, TotalsWidget(formatted_number(v_amount_tt)))
self.setItem(row_num, 6, TotalsWidget(formatted_number(b_f_tt)))
def extend_rows(self):
self.parent.btt_export.setEnabled(True)
nb_rows = self.rowCount()
date = self.parent.date_.text()
self.setRowCount(nb_rows + 4)
self.amount_ht = 0
for row_num in xrange(0, self.data.__len__()):
mtt = is_int(self.item(row_num, 3).text())
self.amount_ht += mtt
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Total vente : "))
self.amount_apricot = self.amount_ht
self.setItem(
row_num, 3,
TotalsWidget(formatted_number(formatted_number(self.amount_ht))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Dette du jour : "))
self.total_debt = Refund.select(fn.SUM(Refund.amount)).where(
Refund.type_ == Refund.DT,
Refund.date < date_on_or_end(date, on=False),
Refund.date > date_on_or_end(date)).scalar() or 0
if self.total_debt:
self.amount_apricot -= self.total_debt
self.setItem(
row_num, 3,
TotalsWidget(formatted_number(formatted_number(self.total_debt))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Dette reglée : "))
self.total_refund = Refund.select(fn.SUM(Refund.amount)).where(
Refund.type_ == Refund.RB,
Refund.date < date_on_or_end(date, on=False),
Refund.date > date_on_or_end(date)).scalar() or 0
if self.total_refund:
self.amount_apricot += self.total_refund
self.setItem(
row_num, 3,
TotalsWidget(formatted_number(formatted_number(
self.total_refund))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Caise : "))
self.setItem(
row_num, 3,
TotalsWidget(
formatted_number(formatted_number(self.amount_apricot))))
self.setSpan(nb_rows, 0, 4, 2)
def save_edit(self):
''' add operation '''
if not self.is_valide():
return
office = Office()
office.slug = self.office_box.itemData(self.office_box.currentIndex())
office.slug_region = self.r_select
office.slug_cercle = self.c_select
office.phone = is_int(self.phone_field.text())
office.email_org = str(self.email_org.text())
office.bp = str(self.bp.text())
office.adress_org = str(self.adress_org.toPlainText())
office.save_()
self.accept()
def changed_value(self, refresh=False):
""" Calcule les Resultat """
for row_num in xrange(0, self.data.__len__()):
qtsaisi = is_int(self.cellWidget(row_num, 0).text())
self.isvalid = True
viderreur_qtsaisi = ""
stylerreur = "background-color: rgb(255, 235, 235);border: 3px double SeaGreen"
if qtsaisi == 0:
viderreur_qtsaisi = stylerreur
self.cellWidget(row_num, 0).setToolTip(
u"La quantité est obligatoire")
self.isvalid = False
self.cellWidget(row_num, 0).setStyleSheet(viderreur_qtsaisi)
self.cellWidget(row_num, 0).setToolTip("")
self._update_data(row_num, [qtsaisi])
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 extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
nb_rows += 1
self.setItem(nb_rows, 3, TotalsWidget(u"Dette restante: "))
if isinstance(self.provid_clt_id, int):
self.remaining = is_int(
self.item(self.data.__len__() - 1, 5).text())
else:
self.remaining = 0
# for prov in ProviderOrClient.select().where(
# ProviderOrClient.type_ == ProviderOrClient.CLT):
# rmaing = Refund.select(Refund.provider_client == prov).order_by(
# Refund.date.desc()).get()
# self.remaining += rmaing.remaining if rmaing else 0
self.setItem(
nb_rows, 4, TotalsWidget(formatted_number(self.remaining)))
self.btt_refund = QPushButton(u"Reglement")
self.setSpan(nb_rows - 1, 0, 2, 3)
def extend_rows(self):
nb_rows = self.rowCount()
date = self.parent.date_.text()
self.setRowCount(nb_rows + 4)
self.amount_ht = 0
for row_num in xrange(0, self.data.__len__()):
mtt = is_int(self.item(row_num, 3).text())
self.amount_ht += mtt
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Total vente : "))
self.amount_apricot = self.amount_ht
self.setItem(row_num, 3, TotalsWidget(
formatted_number(formatted_number(self.amount_ht))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Dette du jour : "))
self.total_debt = Refund.select(fn.SUM(Refund.amount)).where(
Refund.type_ == Refund.DT, Refund.date < date_on_or_end(
date, on=False), Refund.date > date_on_or_end(date)).scalar() or 0
if self.total_debt:
self.amount_apricot -= self.total_debt
self.setItem(row_num, 3, TotalsWidget(
formatted_number(formatted_number(self.total_debt))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Dette reglée : "))
self.total_refund = Refund.select(fn.SUM(Refund.amount)).where(
Refund.type_ == Refund.RB, Refund.date < date_on_or_end(
date, on=False), Refund.date > date_on_or_end(date)).scalar() or 0
if self.total_refund:
self.amount_apricot += self.total_refund
self.setItem(row_num, 3, TotalsWidget(
formatted_number(formatted_number(self.total_refund))))
row_num += 1
self.setItem(row_num, 2, TotalsWidget(u"Caise : "))
self.setItem(row_num, 3, TotalsWidget(
formatted_number(formatted_number(self.amount_apricot))))
self.setSpan(nb_rows, 0, 4, 2)
def extend_rows(self):
pw = (self.parentWidget().width()) / 4
self.setColumnWidth(0, pw)
self.setColumnWidth(1, pw)
self.setColumnWidth(2, pw)
self.setColumnWidth(3, pw)
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 2)
self.setSpan(nb_rows, 0, 2, 2)
mtt_ttc = QtGui.QTableWidgetItem(u"TOTAUX: ")
mtt_ttc.setTextAlignment(QtCore.Qt.AlignRight)
self.setItem(nb_rows + 1, 2, mtt_ttc)
self.montant_ht = 0
for row_num in xrange(0, self.data.__len__()):
mtt = is_int(self.item(row_num, 3).text())
self.montant_ht += mtt
# Montant TTC
montant_ttc = QtGui.QTableWidgetItem(formatted_number(self.montant_ht))
montant_ttc.setTextAlignment(QtCore.Qt.AlignRight)
self.setItem(row_num + 2, 3, montant_ttc)
def extend_rows(self):
if isinstance(self.provid_clt_id, int):
self.remaining = is_int(self.item(0, 5).text())
self.parent.remaining_box.setText(
self.display_remaining(formatted_number(self.remaining)))
def cal_total(self):
total = is_int(self.apports_numeraire_field.text() or 0) + is_int(
self.apports_nature_field.text() or 0) + is_int(
self.apports_industrie_field.text() or 0)
self.capitalSGroupBox.setTitle("7. {} : {}".format(
MONTANT_CAPITAL_SI, device_amount(total)))
