pbar.update(count)
count += 1
olddate_creation = str(date_creation)
newdate_creation = "%s-%s-%s %s:%s:%s" % (olddate_creation[0:4],olddate_creation[4:6],olddate_creation[6:8],olddate_creation[8:10],olddate_creation[10:12],olddate_creation[12:14])
# olddate_paiement = str(date_paiement)
# newdate_paiement = "%s-%s-%s %s:%s:%s" % (olddate_paiement[0:4],olddate_paiement[4:6],olddate_paiement[6:8],olddate_paiement[8:10],olddate_paiement[10:12],olddate_paiement[12:14])
if id_table:
table = Table_get(id=id_table)
# facture = Facture(id=id, date_creation=newdate_creation, date_paiement=newdate_paiement, montant_normal=ttc, montant_alcool=ttc_alcool, table=table, couverts=nb_couverts)
facture = Facture(id=id, date_creation=newdate_creation, montant_normal=convert_prix(ttc), montant_alcool=convert_prix(ttc_alcool), table=table, couverts=nb_couverts)
else:
# facture = Facture(id=id, date_creation=newdate_creation, date_paiement=newdate_paiement, montant_normal=ttc, montant_alcool=ttc_alcool, couverts=nb_couverts)
facture = Facture(id=id, date_creation=newdate_creation, montant_normal=convert_prix(ttc), montant_alcool=convert_prix(ttc_alcool), couverts=nb_couverts)
facture.save()
facture.date_creation = newdate_creation
cu.execute("select id,id_mode_paiement,valeur_unitaire,date,montant_ttc from paiements where id_facture=%d" % facture.id)
for id,id_mode_paiement,valeur_unitaire,date,montant_ttc in cu.fetchall():
olddate = str(date)
newdate = "%s-%s-%s %s:%s:%s" % (olddate[0:4],olddate[4:6],olddate[6:8],olddate[8:10],olddate[10:12],olddate[12:14])
type = PaiementType_get(id=id_mode_paiement)
paiement = Paiement(id=id, type=type, facture=facture, montant=convert_prix(montant_ttc), date=newdate)
paiement.save()
paiement.date = newdate
if paiement.type.fixed_value:
# on calcule le nombre de tickets
# print paiement.montant
# print paiement.valeur_unitaire
paiement.valeur_unitaire = valeur_unitaire=convert_prix(valeur_unitaire)
paiement.nb_tickets = int( Decimal(paiement.montant) / Decimal(paiement.valeur_unitaire) )
# facture = Facture(id=id, date_creation=newdate_creation, date_paiement=newdate_paiement, montant_normal=ttc, montant_alcool=ttc_alcool, table=table, couverts=nb_couverts)
facture = Facture(id=id,
date_creation=newdate_creation,
montant_normal=convert_prix(ttc),
montant_alcool=convert_prix(ttc_alcool),
table=table,
couverts=nb_couverts)
else:
# facture = Facture(id=id, date_creation=newdate_creation, date_paiement=newdate_paiement, montant_normal=ttc, montant_alcool=ttc_alcool, couverts=nb_couverts)
facture = Facture(id=id,
date_creation=newdate_creation,
montant_normal=convert_prix(ttc),
montant_alcool=convert_prix(ttc_alcool),
couverts=nb_couverts)
facture.save()
facture.date_creation = newdate_creation
cu.execute(
"select id,id_mode_paiement,valeur_unitaire,date,montant_ttc from paiements where id_facture=%d"
% facture.id)
for id, id_mode_paiement, valeur_unitaire, date, montant_ttc in cu.fetchall(
):
olddate = str(date)
newdate = "%s-%s-%s %s:%s:%s" % (olddate[0:4], olddate[4:6],
olddate[6:8], olddate[8:10],
olddate[10:12], olddate[12:14])
type = PaiementType_get(id=id_mode_paiement)
paiement = Paiement(id=id,
type=type,
facture=facture,
montant=convert_prix(montant_ttc),
