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 + 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 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 + 1)
self.setItem(nb_rows, 3, TotalsWidget(u"Totaux: "))
v_amount_tt_item = TotalsWidget(formatted_number(self.v_amount_tt))
self.setItem(nb_rows, 4, v_amount_tt_item)
self.setItem(nb_rows, 6, TotalsWidget(formatted_number(self.b_f_tt)))
# self.cancelbutton = DeletedBtt(u"Annuler l'achat")
# self.cancelbutton.released.connect(self.parent.cancellation)
self.setSpan(nb_rows, 0, 1, 3)
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 extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 1)
self.setSpan(nb_rows, 0, 1, 2)
self.setItem(nb_rows, 3, TotalsWidget(u"Montant"))
self.setItem(nb_rows, 6, TotalsWidget(formatted_number(u"%d" % 0)))
nb_rows += 1
self.setRowCount(nb_rows + 1)
self.setSpan(nb_rows, 0, 1, 6)
bicon = QIcon.fromTheme('', QIcon(u"{}".format(Config.img_cmedia)))
self.button = QPushButton(bicon, u"Enregistrer")
self.button.released.connect(self.parent.save_b)
self.setCellWidget(nb_rows, 6, self.button)
def _item_for_data(self, row, column, data, context=None):
if column == 1:
return TotalsWidget(
QIcon(u"{img_media}{img}".format(img_media=Config.img_cmedia,
img="go-next.png")), "")
return super(ResultatTableWidget,
self)._item_for_data(row, column, data, context)
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):
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 extend_rows(self):
nb_rows = self.rowCount()
self.setRowCount(nb_rows + 3)
self.setItem(nb_rows, 2, TotalsWidget(u"Montant"))
monttc = TotalsWidget(formatted_number(u"%d" % 0))
self.setItem(nb_rows, 3, monttc)
nb_rows += 1
bicon = QIcon.fromTheme('',
QIcon(u"{}save.png".format(Config.img_media)))
self.button = QPushButton(bicon, u"Enregistrer")
self.button.released.connect(self.parent.save_b)
self.button.setEnabled(False)
self.setItem(nb_rows, 2, TotalsWidget(u"Reste à payer"))
self.paid_amount_field = IntLineEdit()
self.setCellWidget(nb_rows, 3, self.paid_amount_field)
self.setCellWidget(nb_rows + 1, 3, self.button)
self.setSpan(nb_rows - 1, 0, 3, 2)
pw = self.parent.parent.page_width() / 7
self.setColumnWidth(0, pw * 2)
self.setColumnWidth(1, pw)
self.setColumnWidth(2, pw)
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.nb_rows = self.rowCount()
self.setRowCount(self.nb_rows + 1)
self.setItem(self.nb_rows, 0, TotalsWidget(u"Totaux: "))
self.setItem(
self.nb_rows, 7, TotalsWidget(formatted_number(self.totals)))
self.setItem(
self.nb_rows, 1, TotalsWidget(formatted_number(self.total_sum_d1)))
self.setItem(
self.nb_rows, 2, TotalsWidget(formatted_number(self.total_sum_d2)))
self.setItem(
self.nb_rows, 3, TotalsWidget(formatted_number(self.total_sum_d3)))
self.setItem(
self.nb_rows, 4, TotalsWidget(formatted_number(self.total_sum_d4)))
self.setItem(
self.nb_rows, 5, TotalsWidget(formatted_number(self.total_sum_d5)))
self.setItem(
self.nb_rows, 6, TotalsWidget(formatted_number(self.total_sum_d6)))