def send_open_order(permanence_id):
from repanier.apps import REPANIER_SETTINGS_GROUP_NAME, REPANIER_SETTINGS_CONFIG
cur_language = translation.get_language()
for language in settings.PARLER_LANGUAGES[settings.SITE_ID]:
language_code = language["code"]
translation.activate(language_code)
permanence = Permanence.objects.get(id=permanence_id)
config = REPANIER_SETTINGS_CONFIG
order_responsible = Staff.get_or_create_order_responsible()
to_email = []
for customer in Customer.objects.filter(
represent_this_buyinggroup=False,
may_order=True,
language=language_code).order_by('?'):
to_email.append(customer.user.email)
if customer.email2:
to_email.append(customer.email2)
offer_description = permanence.safe_translation_getter(
'offer_description', any_language=True, default=EMPTY_STRING)
offer_customer_mail = config.safe_translation_getter(
'offer_customer_mail', any_language=True, default=EMPTY_STRING)
offer_customer_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
offer_producer = ', '.join(
[p.short_profile_name for p in permanence.producers.all()])
qs = OfferItemWoReceiver.objects.filter(
permanence_id=permanence_id,
is_active=True,
order_unit__lt=
PRODUCT_ORDER_UNIT_DEPOSIT, # Don't display technical products.
translations__language_code=language_code).order_by(
"translations__order_sort_order")
offer_detail = "<ul>{}</ul>".format(
"".join("<li>{}, {}, {}</li>".format(
o.get_long_name(),
o.producer.short_profile_name,
o.email_offer_price_with_vat,
) for o in qs), )
template = Template(offer_customer_mail)
context = TemplateContext({
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('order_view', args=(permanence.id, )), permanence)),
'offer_description':
mark_safe(offer_description),
'offer_detail':
mark_safe(offer_detail),
'offer_recent_detail':
mark_safe(permanence.get_new_products),
'offer_producer':
offer_producer,
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
to_email = list(
set(to_email + order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(subject=offer_customer_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
reply_to=order_responsible.get_reply_to_email,
to=to_email,
show_customer_may_unsubscribe=True)
email.send_email()
translation.activate(cur_language)
def send_pre_open_order(permanence_id):
from repanier.apps import REPANIER_SETTINGS_GROUP_NAME, REPANIER_SETTINGS_CONFIG
cur_language = translation.get_language()
for language in settings.PARLER_LANGUAGES[settings.SITE_ID]:
language_code = language["code"]
translation.activate(language_code)
permanence = Permanence.objects.get(id=permanence_id)
config = REPANIER_SETTINGS_CONFIG
offer_producer_mail = config.safe_translation_getter(
'offer_producer_mail', any_language=True, default=EMPTY_STRING)
order_responsible = Staff.get_or_create_order_responsible()
offer_description = permanence.safe_translation_getter(
'offer_description', any_language=True, default=EMPTY_STRING)
offer_producer_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
template = Template(offer_producer_mail)
producer_set = Producer.objects.filter(
permanence=permanence_id,
producer_pre_opening=True,
language=language_code).order_by('?')
for producer in producer_set:
long_profile_name = producer.long_profile_name \
if producer.long_profile_name is not None else producer.short_profile_name
context = TemplateContext({
'name':
long_profile_name,
'long_profile_name':
long_profile_name,
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('pre_order_uuid_view',
args=(producer.offer_uuid, )), _("Offers"))),
'offer_description':
mark_safe(offer_description),
'offer_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('pre_order_uuid_view',
args=(producer.offer_uuid, )), _("Offers"))),
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
to_email = []
if producer.email:
to_email.append(producer.email)
if producer.email2:
to_email.append(producer.email2)
if producer.email3:
to_email.append(producer.email3)
to_email = list(
set(to_email + order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(
subject=offer_producer_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
reply_to=order_responsible.get_reply_to_email,
to=to_email)
email.send_email()
send_sms(sms_nr=producer.phone1,
sms_msg="{} : {} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence,
_("Pre-opening of orders")))
translation.activate(cur_language)
def export_order_2_1_group(config, delivery_id, filename, permanence,
order_responsible):
delivery_board = DeliveryBoard.objects.filter(id=delivery_id).exclude(
delivery_point__customer_responsible=None).order_by('?').first()
if delivery_board is None:
return
from repanier.apps import REPANIER_SETTINGS_GROUP_NAME
delivery_point = delivery_board.delivery_point
customer_responsible = delivery_point.customer_responsible
wb = generate_customer_xlsx(permanence=permanence,
deliveries_id=[delivery_id],
group=True)[0]
if wb is not None:
order_customer_mail = config.safe_translation_getter(
'order_customer_mail', any_language=True, default=EMPTY_STRING)
order_customer_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
long_basket_name = customer_responsible.long_basket_name or str(
customer_responsible)
template = Template(order_customer_mail)
context = TemplateContext({
'name':
long_basket_name,
'long_basket_name':
long_basket_name, # deprecated
'basket_name':
str(customer_responsible),
'short_basket_name':
str(customer_responsible), # deprecated
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('order_view', args=(permanence.id, )), permanence)),
'last_balance_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('customer_invoice_view', args=(0, )),
_("Group invoices"))),
'last_balance':
EMPTY_STRING,
'order_amount':
EMPTY_STRING,
'on_hold_movement':
EMPTY_STRING,
'payment_needed':
EMPTY_STRING,
'delivery_point':
delivery_point,
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
to_email = [customer_responsible.user.email]
if customer_responsible.email2:
to_email.append(customer_responsible.email2)
to_email = list(
set(to_email + order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(subject=order_customer_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
to=to_email,
reply_to=order_responsible.get_reply_to)
email.attach(
filename, save_virtual_workbook(wb),
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)
email.send_email()
def export_order_2_1_customer(customer,
filename,
permanence,
order_responsible=None,
abstract_ws=None,
cancel_order=False):
from repanier.apps import \
REPANIER_SETTINGS_GROUP_NAME, \
REPANIER_SETTINGS_SEND_ABSTRACT_ORDER_MAIL_TO_CUSTOMER, \
REPANIER_SETTINGS_CONFIG
config = REPANIER_SETTINGS_CONFIG
customer_invoice = CustomerInvoice.objects.filter(
permanence_id=permanence.id,
customer_id=customer.id).order_by('?').first()
if customer_invoice is not None:
if order_responsible is None:
order_responsible = Staff.get_or_create_order_responsible()
wb = generate_customer_xlsx(permanence=permanence,
customer=customer)[0]
if wb is not None:
to_email = [customer.user.email]
if customer.email2:
to_email.append(customer.email2)
if customer_invoice.delivery is not None:
delivery_point = customer_invoice.delivery
if delivery_point.delivery_point.inform_customer_responsible and delivery_point.delivery_point.customer_responsible is not None:
customer_responsible = delivery_point.delivery_point.customer_responsible
if customer_responsible.id != customer.id:
to_email.append(customer_responsible.user.email)
if customer_responsible.email2:
to_email.append(customer_responsible.email2)
else:
delivery_point = EMPTY_STRING
customer_last_balance, customer_on_hold_movement, customer_payment_needed, customer_order_amount = payment_message(
customer, permanence)
long_basket_name = customer.long_basket_name if customer.long_basket_name is not None else customer.short_basket_name
if cancel_order:
order_customer_mail = config.safe_translation_getter(
'cancel_order_customer_mail',
any_language=True,
default=EMPTY_STRING)
order_customer_mail_subject = "{} - {} - {}".format(
_('⚠ Order cancelled'), REPANIER_SETTINGS_GROUP_NAME,
permanence)
else:
order_customer_mail = config.safe_translation_getter(
'order_customer_mail',
any_language=True,
default=EMPTY_STRING)
order_customer_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
template = Template(order_customer_mail)
context = TemplateContext({
'name':
long_basket_name,
'long_basket_name':
long_basket_name,
'basket_name':
customer.short_basket_name,
'short_basket_name':
customer.short_basket_name,
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('order_view', args=(permanence.id, )),
permanence)),
'last_balance_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('customer_invoice_view', args=(0, )),
customer_last_balance)),
'last_balance':
mark_safe(customer_last_balance),
'order_amount':
mark_safe(customer_order_amount),
'on_hold_movement':
customer_on_hold_movement,
'payment_needed':
mark_safe(customer_payment_needed),
'delivery_point':
delivery_point,
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
if cancel_order or settings.REPANIER_SETTINGS_CUSTOMER_MUST_CONFIRM_ORDER:
to_email.append(order_responsible.get_to_email)
to_email = list(
set(to_email + order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(
subject=order_customer_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
to=to_email,
reply_to=order_responsible.get_reply_to_email,
show_customer_may_unsubscribe=False,
send_even_if_unsubscribed=True)
if not cancel_order and REPANIER_SETTINGS_SEND_ABSTRACT_ORDER_MAIL_TO_CUSTOMER:
if abstract_ws is not None:
wb.add_sheet(abstract_ws, index=0)
email.attach(
filename, save_virtual_workbook(wb),
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)
email.send_email()
def email_order(permanence_id,
everything=True,
producers_id=(),
deliveries_id=()):
from repanier.apps import REPANIER_SETTINGS_SEND_ORDER_MAIL_TO_BOARD, \
REPANIER_SETTINGS_GROUP_NAME, \
REPANIER_SETTINGS_CONFIG
cur_language = translation.get_language()
for language in settings.PARLER_LANGUAGES[settings.SITE_ID]:
language_code = language["code"]
translation.activate(language_code)
permanence = Permanence.objects.get(id=permanence_id)
config = REPANIER_SETTINGS_CONFIG
filename = "{}-{}.xlsx".format(_("Order"), permanence)
order_responsible = Staff.get_or_create_order_responsible()
if len(deliveries_id) > 0:
# if closed deliveries_id is not empty list and not "None" then all_producers should be True
everything = True
for delivery_id in deliveries_id:
# Send a recap of the orders to the responsible
export_order_2_1_group(config, delivery_id, filename,
permanence, order_responsible)
if not everything:
abstract_ws = None
else:
# Orders send to the preparation team, to the order_responsible and the staff.is_order_copy
wb, abstract_ws = generate_customer_xlsx(
permanence, deliveries_id=deliveries_id)
if wb is not None:
# At least one order
order_staff_mail = config.safe_translation_getter(
'order_staff_mail',
any_language=True,
default=EMPTY_STRING)
order_staff_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
board_composition, board_composition_and_description = get_board_composition(
permanence.id)
template = Template(order_staff_mail)
context = TemplateContext({
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('order_view', args=(permanence.id, )),
permanence)),
'board_composition':
mark_safe(board_composition),
'board_composition_and_description':
mark_safe(board_composition_and_description),
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
to_email = []
if REPANIER_SETTINGS_SEND_ORDER_MAIL_TO_BOARD:
for permanence_board in PermanenceBoard.objects.filter(
permanence_id=permanence.id).order_by('?'):
if permanence_board.customer:
to_email.append(
permanence_board.customer.user.email)
to_email = list(
set(to_email) | set(order_responsible.get_to_email)
| set(Staff.get_to_order_copy()))
else:
to_email = list(
set(order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(
subject=order_staff_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
to=to_email,
reply_to=order_responsible.get_reply_to_email)
email.attach(
filename, save_virtual_workbook(wb),
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)
email.send_email()
# Orders send to our producers
producer_set = Producer.objects.filter(
permanence=permanence,
language=language_code,
).order_by('?')
if len(producers_id) > 0:
producer_set = producer_set.filter(id__in=producers_id)
for producer in producer_set:
long_profile_name = producer.long_profile_name if producer.long_profile_name is not None else producer.short_profile_name
wb = generate_producer_xlsx(permanence=permanence,
producer=producer,
wb=None)
order_producer_mail = config.safe_translation_getter(
'order_producer_mail', any_language=True, default=EMPTY_STRING)
order_producer_mail_subject = "{} - {}".format(
REPANIER_SETTINGS_GROUP_NAME, permanence)
template = Template(order_producer_mail)
context = TemplateContext({
'name':
long_profile_name,
'long_profile_name':
long_profile_name,
'order_empty':
wb is None,
'duplicate':
not (wb is None or producer.manage_replenishment),
'permanence_link':
mark_safe("<a href=\"https://{}{}\">{}</a>".format(
settings.ALLOWED_HOSTS[0],
reverse('order_view', args=(permanence.id, )),
permanence)),
'signature':
order_responsible.get_html_signature
})
html_body = template.render(context)
producer_invoice = ProducerInvoice.objects.filter(
producer_id=producer.id, permanence_id=permanence.id).only(
"total_price_with_tax").order_by('?').first()
to_email = []
if producer_invoice is not None \
and producer_invoice.total_price_with_tax < producer.minimum_order_value:
html_body = "{}<br><br>{}".format(order_producer_mail_subject,
html_body)
order_producer_mail_subject = _(
'⚠ Mail not send to our producer {} because the minimum order value has not been reached.'
).format(long_profile_name)
else:
if producer.email:
to_email.append(producer.email)
if producer.email2:
to_email.append(producer.email2)
if producer.email3:
to_email.append(producer.email3)
to_email = list(
set(to_email + order_responsible.get_to_email +
Staff.get_to_order_copy()))
email = RepanierEmail(
subject=order_producer_mail_subject,
html_body=html_body,
from_email=order_responsible.get_from_email,
to=to_email,
reply_to=order_responsible.get_reply_to_email)
if wb is not None:
if producer.represent_this_buyinggroup:
if abstract_ws is not None:
wb.add_sheet(abstract_ws, index=0)
email.attach(
filename, save_virtual_workbook(wb),
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)
email.send_email()
if everything:
# Orders send to our customers only if they don't have already received it
# ==> customerinvoice__is_order_confirm_send=False
# customerinvoice__permanence_id=permanence.id
if not settings.REPANIER_SETTINGS_CUSTOMER_MUST_CONFIRM_ORDER:
# -> Do not send cancelled orders
customer_set = Customer.objects.filter(
represent_this_buyinggroup=False,
customerinvoice__is_order_confirm_send=False,
customerinvoice__permanence_id=permanence.id,
language=language_code).order_by('?')
if len(deliveries_id) > 0:
customer_set = customer_set.filter(
customerinvoice__delivery_id__in=deliveries_id, )
for customer in customer_set:
export_order_2_1_customer(customer, filename, permanence,
order_responsible, abstract_ws)
# confirm_customer_invoice(permanence_id, customer.id)
customer_invoice = CustomerInvoice.objects.filter(
customer_id=customer.id,
permanence_id=permanence_id).order_by('?').first()
customer_invoice.confirm_order()
customer_invoice.save()
translation.activate(cur_language)
