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)