Пример #1
0
def show_record(request, cliente_id, detail_type=None, impianto_id=None, sub_impianto_id=None, message_hdr='', message='', message_type=''):
    data, data_list = view_record(cliente_id, detail_type, impianto_id, sub_impianto_id)


    # Breadcrumb genarate from current url.
    b = ""
    r = re.compile("\w+\/\d+")
    #['anagrafe/33', 'impianto/33', 'verifica/33']
    l = r.findall(request.path)
    if l:
        url = "/"
        if len(l) > 1:
            for i in l[:-1]:
                url += i + "/"
                s = __breadcrumbName(i)
                b += BREADCRUMB_ELEMENT % (url, s, BREADCRUMB_DIVIDER)

        url += l[-1] + "/"
        s = __breadcrumbName(l[-1])
        b += BREADCRUMB_ELEMENT % (url, s, "")

    if data is None:
        return errors.server_error(request)

    return render(request, 'anagrafe.html', { 'data': data,
                           'data_list': data_list,
                           'notification': data_render.notification(message_hdr, message, message_type),
                           'scripts':scripts.ANAGRAFE_JS,
                           'breadcrumb': b,
                           })
Пример #2
0
def add_record(request, cliente_id=None, detail_type=None, impianto_id=None, sub_impianto_id=None):
    script = ""
    data = ""
    data_list = ""
    notification = ""
    if cliente_id is None:
        header_msg = "Aggiungi Nuovo Cliente"
        post_url = "add/"
    else:
        if detail_type == 'impianto':
            header_msg = "Aggiungi Nuovo Impianto"
            post_url = "%s/impianto/add/" % cliente_id

        if detail_type == 'verifica':
            header_msg = "Aggiungi Nuova Verifica e Manutenzione"
            post_url = "%s/impianto/%s/verifica/add/" % (cliente_id, impianto_id)

        if detail_type == 'intervento':
            header_msg = "Aggiungi Nuovo Intervento"
            post_url = "%s/impianto/%s/intervento/add/" % (cliente_id, impianto_id)

        if detail_type is None:
            return errors.server_error(request)

    if request.method == 'GET':
        if cliente_id is None:
            form = models.ClienteForm()
        else:
            if detail_type == 'impianto':
                form = models.ImpiantoForm(initial={'cliente_impianto': models.Cliente.objects.get(pk=cliente_id)})
                script = scripts.IMPIANTO_JS
                data, data_list = view_record(cliente_id, detail_type, impianto_id)

            if detail_type == 'verifica':
                form = models.VerificaForm(initial={'verifica_impianto': models.Impianto.objects.get(pk=impianto_id)})
                script = scripts.VERIFICA_JS
                data, data_list = view_record(cliente_id, detail_type, impianto_id)

            if detail_type == 'intervento':
                form = models.InterventoForm(initial={'intervento_impianto': models.Impianto.objects.get(pk=impianto_id)})
                script = scripts.INTERVENTO_JS
                data, data_list = view_record(cliente_id, detail_type, impianto_id)

    if request.method == 'POST':
        ret, d = __editAdd_record(cliente_id, impianto_id, sub_impianto_id, detail_type, request)
        if ret:
            return show_record(**d)
        else:
            request = d['request']
            form = d['form']
            notification = data_render.notification(d['message_hdr'], d['message'], d['message_type'])

    return render(request, 'anagrafe_form.html', {'notification': notification, 'header_msg': data_render.TITLE_STYLE_FORM % header_msg,
        'data_forms': form, 'data':data, 'scripts': script, 'post_url':post_url})
Пример #3
0
def home(request, d={}):
    form = myforms.RangeDataSelect()
    data = ''
    notification = ''

    # Use default at first time when the home page is never loaded
    form_dict = {
            'search_keys' : "",
            'filter_type' : None,
            'ref_month' : None,
            'ref_year' : None,
            'order_by_field' : "",
            'ordering' : "",
    }

    if request.method == 'POST':
        selected_rows = request.POST.getlist('row_select', [])
        action = request.POST.get('button_action', '')
        if action == 'Lettera':
            ids = __getIds(selected_rows, data_render.CLIENTE_ID)
            data_to_render = database_manager.search_ids('main_cliente.id', ids)
            return generate_report(data_to_render)
        elif action == 'Scarica Tabella':
            ids = __getIds(selected_rows, data_render.CLIENTE_ID)
            data_to_render = database_manager.search_ids('main_cliente.id', ids)
            return __export_xls(data_to_render, "Elenco")
        else:
            for i in selected_rows:
                ids = i.split(',')
                verifica_id = ids[data_render.VERIFICA_ID]
                if verifica_id != 'None':
                    _id = int(verifica_id)
                    if action == 'Apri':
                        models.Verifica.objects.filter(id=_id).update(stato_verifica='A')
                    if action == 'Chiudi':
                        models.Verifica.objects.filter(id=_id).update(stato_verifica='C')
                    if action == 'Sospendi':
                        models.Verifica.objects.filter(id=_id).update(stato_verifica='S')


    if request.method == 'GET' and request.GET != {}:
        form = myforms.RangeDataSelect(request.GET)
        if form.is_valid():
            form_dict['search_keys'] = form.cleaned_data['search_keys']
            form_dict['filter_type'] = form.cleaned_data['filter_type']
            form_dict['ref_month'] = form.cleaned_data['ref_month']
            form_dict['ref_year'] = form.cleaned_data['ref_year']
            form_dict['order_by_field'] = form.cleaned_data['order_by_field']
            form_dict['ordering'] = form.cleaned_data['ordering']

    data_to_render = database_manager.search_inMonth(**form_dict)
    dr = data_render.DataRender(data_to_render)

    dr.selectColums(user_settings.settings_columView('home_view'))
    tb_top = [
            "<button class=\"btn btn-info dropdown-toggle\" data-toggle=\"dropdown\">Seleziona \
            <span class=\"caret\"></span></button> \
            <ul class=\"dropdown-menu\"> \
            <li><a id=\"action\" href=\"#\">Aperti</a></li> \
            <li><a id=\"action\" href=\"#\">Sospesi</a></li> \
            <li><a id=\"action\" href=\"#\">Chiusi</a></li> \
            <li class=\"divider\"></li> \
            <li><a id=\"action\" href=\"#\">Tutti</a></li> \
            <li><a id=\"action\" href=\"#\">Nessuno</a></li> \
            </ul>",
            "<input class=\"btn btn-info\" type=\"submit\" name=\"button_action\" value=\"Apri\">",
            "<input class=\"btn btn-info\" type=\"submit\" name=\"button_action\" value=\"Chiudi\">",
            "<input class=\"btn btn-info\" type=\"submit\" name=\"button_action\" value=\"Sospendi\">",
            "<input class=\"btn btn-info\" type=\"submit\" name=\"button_action\" value=\"Lettera\">",
            "<input class=\"btn btn-info\" type=\"submit\" name=\"button_action\" value=\"Scarica Tabella\">",
    ]

    tb_left = [
            "<input type=\"checkbox\" name=\"row_select\" id=\"{stato_verifica}\" value=\"{cliente_id},{impianto_id},{verifica_id},{intervento_id}\">"
    ]
    dr.toolbar(top=tb_top, left=tb_left)

    dr.msgItemsEmpty("<br><h3>La ricerca non ha prodotto risultati.</h3>")
    dr.msgStatistics(("<br><h2>Nel mese di %s " % myforms.monthStr(form_dict['ref_month'])) + "COUNT interventi in scadenza.</h2><br>")
    dr.showStatistics()

    dr.orderUrl('home', form_dict)
    data += dr.toTable()


    form_dict['status'] = True
    data_to_render = database_manager.search_inMonth(**form_dict)
    dr = data_render.DataRender(data_to_render)
    dr.selectColums(user_settings.settings_columView('home_view'))
    dr.toolbar(top=tb_top, left=tb_left)
    dr.msgItemsEmpty("")
    dr.msgStatistics(("<br><h2>N.COUNT interventi chiusi nel mese di %s" % myforms.monthStr(form_dict['ref_month'])) + ".</h2><br>")
    dr.showStatistics()
    data += dr.toTable()


    if d:
       notification = data_render.notification(d['message_hdr'], d['message'], d['message_type'])

    return render(request, 'home.html',{'query_path':request.get_full_path(),
                                       'notification': notification,
                                       'data': data,
                                       'data_form': form,
                                       'scripts': scripts.HOME_ADD_JS,
                                       })