def create_tables():
# Tables
z = Zone(nom='Bar', surtaxe=False)
z.save()
Table(nom="T--", zone=z).save()
z = Zone(nom='Rez de chaussee', surtaxe=False)
z.save()
for i in range(1, 15):
Table(nom="T%02d" % i, zone=z).save()
z = Zone(nom='Terrasse', surtaxe=True)
z.save()
for i in range(15, 26):
Table(nom="T%02d" % i, zone=z).save()
def tables_zone_new(request):
'''
:param HttpRequest request:
:return rtype: HttpResponse
'''
zone = Zone()
zone.save()
return redirect('tables_zone', zone.id)
PaiementType(nom='Tic. Resto.', fixed_value=True).save()
# Type de paiements par défaut pour les remboursements lorsque
# le paiement dépasse le montant de la facture
id_type_paiement = PaiementType.objects.get(nom="Espece").id
Config(key="payment_for_refunds", value=id_type_paiement).save()
# Default PaymentType to select by default on the payment page
id_type_paiement = PaiementType.objects.get(nom="Espece").id
Config(key="default_type_payment", value=id_type_paiement).save()
# Montant de la surtaxe
Config(key="price_surcharge", value="0.20").save()
# Tables
z = Zone(nom='Bar', surtaxe=False)
z.save()
Table(nom="T--", zone=z).save()
z = Zone(nom='Rez de chaussee', surtaxe=False)
z.save()
for i in xrange(1, 15):
Table(nom="T%02d" % i, zone=z).save()
z = Zone(nom='Terrasse', surtaxe=True)
z.save()
for i in xrange(15, 26):
Table(nom="T%02d" % i, zone=z).save()
# TVA
vat_alcool = VAT(name="alcool")
vat_alcool.set_tax("20")
vat_alcool.save()
cu.execute("select id,date from logs where id_log_type=%s" % logtype.id)
for id, date 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])
log = Log(id=id, date=newdate, type=logtype)
log.save()
log.date = newdate
log.save()
pbar.finish()
print "> creation des etages et des tables"
cu.execute("select id,nom,surtaxe from etages")
for id, nom, surtaxe in cu.fetchall():
zone = Zone(id=id, nom=nom, surtaxe=surtaxe, prix_surtaxe=convert_prix(20))
zone.save()
cu.execute("select id,nom from tables where id_etage=%s" % zone.id)
for id, nom in cu.fetchall():
table = Table(id=id, nom=nom, zone=zone)
table.save()
print "> creation des etats"
etat = Etat(nom="apero", priorite=10)
etat.save()
etat = Etat(nom="entree", priorite=15)
etat.save()
etat = Etat(nom="plat", priorite=20)
etat.save()
etat = Etat(nom="dessert", priorite=25)
def tables_zone_new(request):
zone = Zone()
zone.save()
return redirect('tables_zone', zone.id)
