def zprint(request):
dt = request.POST.get("start_date", "")
dtv = dt.split(".")
p = []
for slot in order_scheduled:
tdelta = datetime.timedelta(minutes=slot.mp_type.duration)
entry = dict()
entry["PATIENT"] = slot.order.patient.fio()
mp = OrderMedicalProcedure.objects.filter(order=slot.order, mp_type=slot.mp_type)
if len(mp) > 0:
t = datetime.datetime.combine(slot.p_date, slot.mp_type.start_time)
time = t + (slot.slot - 1) * tdelta
entry["TIME"] = time.strftime("%H:%M")
add_info = mp[0].add_info
else:
add_info = ""
entry["NAME"] = slot.mp_type.name + " " + add_info
p.append(entry)
tel = {
"P": p,
"DATE": p_date.strftime("%d.%m.%Y"),
"FILENAME": "procedures-" + str(mp_type_id) + "-" + p_date.strftime("%d-%m-%Y"),
}
template_filename = "mps.xls"
return fill_excel_template(template_filename, tel, request)
def generateNakl(order, order_date, order_price, request, t):
template_filename = 'torg12_0.xls'
fullname = str('ООО санаторий "Хопровские зори"')
vendor = str('КПП 581701001 ') + fullname + str(' Пензенская обл., п.Колышлей, ул.Лесная 1а')
if order.patient.address is None:
client = order.patient.fio()
else:
client = order.patient.fio() + ',' + order.patient.address
dir = gavnetso.getEmployerByRoleNameAndDate('Директор', order.start_date).__unicode__()
gb = gavnetso.getEmployerByRoleNameAndDate('Главный бухгалтер', order.start_date).__unicode__()
kassir = gavnetso.getEmployerByRoleNameAndDate('Кассир', order.start_date).__unicode__()
rub = numeral.rubles(float(order_price), True)
tel = {'PORTRAIT': False, 'NUMPAGES': 1, 'PIZDEZ': fullname, 'NUMBER': order.code,
'FILENAME': 'nakladnaya-' + str(order.code),
'CLIENT': client, 'VENDOR': vendor,
'DIRECTOR': dir,
'GBUH': gb,
'KASSIR': kassir,
'SP': rub,
'DATE': order_date,
'QTYSUM': 1,
'AMOUNTSUM': order_price,
'AMOUNTNDSSUM': order_price, 'ALLAMOUNTSUM': order_price,
'TOVAR': t}
return fill_excel_template(template_filename, tel, request)
def processreport(request, tp):
report_metadata = report_map[tp]
form = report_metadata[1](request.POST)
if form.is_valid():
md = report_metadata[3].process(form)
tel = {"TITLE": report_metadata[0], "T": md[1]}
for (key, value) in md[0].items():
tel[key] = str(value)
if request.POST.has_key("s2") and report_metadata[4] != "":
return render_to_response(report_metadata[4], MenuRequestContext(request, tel))
else:
return fill_excel_template(report_metadata[2], tel, request)
else:
values = {"tp": tp, "metadata": report_metadata}
return render_to_response("pansionat/report.html", MenuRequestContext(request, values))
def generate_pko(request, client, code, ed, price, putevka, sd):
template_filename = 'prih_order1.xls'
fullname = 'ООО санаторий "Хопровские зори"'
gb = gavnetso.getEmployerByRoleNameAndDate('Главный бухгалтер', sd).__unicode__()
kassir = gavnetso.getEmployerByRoleNameAndDate('Кассир', sd).__unicode__()
delt = ed - sd
days = delt.days + 1
tovar = 'Пут. сан.-кур. на ' + str(days) + ' дней c ' + str(sd) + ' по ' + str(ed) + '№ ' + str(putevka)
tel = {'NUMPAGES': 1, 'FULLNAME': fullname, 'NUMBER': code,
'FILENAME': 'pko-' + str(code),
'CLIENT': client,
'GBUH': gb,
'KASSIR': kassir,
'PRICE': price,
'DATE': sd.strftime('%d.%m.%Y'),
'DESCRIPTION': tovar}
return fill_excel_template(template_filename, tel, request)
