def save(self):
customers_csv = csv.reader(self.cleaned_data["file"])
Customer.objects.all().delete()
for customer_csv in customers_csv:
customer = Customer()
customer.customer_id = customer_csv[0]
customer.name = customer_csv[1]
customer.adress = customer_csv[2]
customer.phone_number = customer_csv[3]
customer.contact = customer_csv[4]
customer.save()
def cliente():
with open('/maladireta/database/clientes.csv') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
line_count = 0
for row in csv_reader:
if line_count == 0:
print(f'{", ".join(row)}')
line_count += 1
elif line_count == 1:
customer = Customer()
customer.name = row[0]
if row[1]:
customer.birth = to_datetime_inverted(row[1].split(' ')[0])
customer.nickname = row[2]
customer.reference = row[3]
customer.state = row[4]
customer.cep = row[5]
customer.old_id = row[10]
customer.note = row[11]
customer.cpf = row[12]
customer.rg = row[13]
customer.phone_home = row[14]
customer.phone_number = row[15]
customer.cellphone = row[16]
customer.complement = row[17]
customer.street = row[18]
customer.leadership = row[20]
customer.location_reference = row[21]
customer.number = row[26]
customer.email = row[27]
customer.profession = row[28]
customer.neighborhood = row[29]
customer.city = row[30]
customer.recurrence = row[32]
customer.subscription = row[38]
customer.zone = row[39]
customer.section = row[40]
customer.save()
else:
break
def form_valid(self, form):
try:
customer = Customer.objects.get(
phone_number=form.data['phone_number'])
except Customer.DoesNotExist:
customer = Customer()
customer.first_name = form.data['first_name']
customer.last_name = form.data['last_name']
customer.phone_number = form.data['phone_number']
customer.save()
cleaner = Cleaner.objects.filter(cities=form.data['city'])\
.exclude(booking__date=form.data['date'])\
.first()
booking = Booking.objects.create(customer=customer,
cleaner=cleaner,
date=form.data['date'])
template = render_to_string('booking/email_notification.txt',
{'booking': booking})
send_mail('New booking', template, settings.DEFAULT_FROM_EMAIL,
[cleaner.email])
return super(BookingCreateView, self).form_valid(form)
