From 323b2f3159e0e5aa2ecea3b1ceae9efeecd6a00d Mon Sep 17 00:00:00 2001 From: Andrea Lepori Date: Tue, 28 Mar 2023 15:30:05 +0200 Subject: prototype for doclist table --- server/templates/server/doc_list_table.html | 424 ++++++++++++++++++++++++++++ server/urls.py | 1 + server/views.py | 137 +++++++++ templates/registration/base_admin.html | 2 + version.txt | 2 +- 5 files changed, 565 insertions(+), 1 deletion(-) create mode 100644 server/templates/server/doc_list_table.html diff --git a/server/templates/server/doc_list_table.html b/server/templates/server/doc_list_table.html new file mode 100644 index 0000000..9f9ed2a --- /dev/null +++ b/server/templates/server/doc_list_table.html @@ -0,0 +1,424 @@ +{% extends 'registration/base_admin.html' %} + +{% block title %}Admin - Lista Utenti{% endblock %} + +{% block breadcrumb %} + Admin + Documenti +{% endblock %} +{% block toolbar %} +
+ + +
+{% endblock %} + +{% block content %} +{% load app_filter %} +
+{% csrf_token %} + + + + + + +
+ +
+{% endblock %} + +{% block script %} + $(document).ready(function(){ + $('#modal1').modal(); + $('#modal2').modal(); + var elemsMapping = {}; + var rows = table.getRows(); + for (var i = 0; i < rows.length; i++) { + var cell = rows[i].getCell("username"); + if (cell.getValue() == "col_row") { + var group = rows[i].getCell("type").getValue(); + elemsMapping[group] = rows[i].getElement(); + } + } + + $(".tabulator-group").each(function() { + for (var i = 0; i < this.childNodes.length; i++) { + if (this.childNodes[i].nodeType === 3) { + this.appendChild(elemsMapping[this.childNodes[i].textContent]); + elemsMapping[this.childNodes[i].textContent].style = "background-color: #ccc; margin-left: -10px;"; + elemsMapping[this.childNodes[i].textContent].classList.add("embedded-row"); + } + } + }) + + $(".tabulator-col-resize-handle").css("margin-left", "-3px"); + }); + + var iconFormatter = function(cell) { + return '' + cell.getValue() + ''; + } + + var tabledata = [ + {% for doc in docs %} + { + {% if doc.status == "wait" %} + status: 'timelapse', + {% elif doc.status == "ok" %} + {% if doc.signed_doc %} + status: 'check_circle', + {% else %} + status: 'check', + {% endif %} + {% elif doc.status == "archive" %} + status: 'archive', + {% elif doc.status == "autosign" %} + status: 'assignment_turned_in', + {% endif %} + type: "{{doc.document_type.name}}", + code: {% if doc.status == "ok" or doc.status == "archive" %} "{{doc.code}}" {% else %} "???" {% endif %}, + compilation_date: "{{doc.compilation_date}}", + capo: {% if "capi" in doc.user|user_groups %}true{% else %}false{% endif %}, + username: "{{doc.user.username}}", + name: "{{doc.user.first_name}}", + last_name: "{{doc.user.last_name}}", + email: "{{doc.personal_data.email}}", + birth_date: "{{doc.personal_data.born_date}}", + branca: "{{ doc.user|user_primary_group }}", + parent_name: "{{doc.personal_data.parent_name}}", + avs_number: "{{doc.personal_data.avs_number}}", + via: "{{doc.personal_data.via}}", + cap: "{{doc.personal_data.cap}}", + country: "{{doc.personal_data.country}}", + nationality: "{{doc.personal_data.nationality}}", + phone: "{{doc.personal_data.phone}}", + home_phone: "{{doc.personal_data.home_phone}}", + school: "{{doc.personal_data.school}}", + year: "{{doc.personal_data.year}}", + emer_name: "{{doc.medical_data.emer_name}}", + emer_relative: "{{doc.medical_data.emer_relative}}", + cell_phone: "{{doc.medical_data.cell_phone}}", + emer_phone: "{{doc.medical_data.emer_phone}}", + emer_address: "{{doc.medical_data.address}}", + health_care: "{{doc.medical_data.health_care}}", + injuries: "{{doc.medical_data.injuries}}", + rc: "{{doc.medical_data.rc}}", + rega: "{{doc.medical_data.rega}}", + medic_name: "{{doc.medical_data.medic_name}}", + medic_phone: "{{doc.medical_data.medic_phone}}", + medic_address: "{{doc.medical_data.medic_address}}", + sickness: "{{doc.medical_data.sickness}}", + vaccine: "{{doc.medical_data.vaccine}}", + tetanus_date: "{{doc.medical_data.tetanus_date}}", + allergy: "{{doc.medical_data.allergy}}", + drugs: "{{doc.medical_data.drugs}}", + misc: "{{doc.medical_data.misc}}", + }, + {% endfor %} + ]; + + var columns = []; + + var col_categories = [ + {field: "base", name: "Informazioni base", cols: + [ + {title: "Username", field: "username"}, + {title: "Stato", field: "status", formatter: iconFormatter}, + {title: "Tipo", field: "type"}, + {title: "Codice", field: "code"}, + {title: "Nome", field: "name"}, + {title: "Cognome", field: "last_name"}, + {title: "Capo", field: "capo", formatter:"tickCross"}, + {title: "Data compilazione", field: "compilation_date"}, + {title: "Branca", field: "branca"}, + {title: "Email", field: "email", visible: false}, + {title: "Data di nascita", field: "birth_date", visible: false}, + ] + }, + {field: "personal", name: "Informazioni personali", cols: + [ + {title: "Nome genitore", field: "parent_name", visible: false}, + {title: "Numero AVS", field: "avs_number", visible: false}, + {title: "Via", field: "via", visible: false}, + {title: "CAP", field: "cap", visible: false}, + {title: "Paese", field: "country", visible: false}, + {title: "Nazionalita", field: "nationality", visible: false}, + {title: "Telefono", field: "phone", visible: false}, + {title: "Telefono casa", field: "home_phone", visible: false}, + {title: "Scuola", field: "school", visible: false}, + {title: "Anno", field: "year", visible: false}, + ] + }, + {field: "medical", name: "Informazioni mediche", cols: + [ + {title: "Nome emergenza", field: "emer_name", visible: false}, + {title: "Parentela emergenza", field: "emer_relative", visible: false}, + {title: "Cellulare emergenza", field: "cell_phone", visible: false}, + {title: "Telefono emergenza", field: "emer_phone", visible: false}, + {title: "Indirizzo emergenza", field: "emer_address", visible: false}, + {title: "Assicurazione sanitaria", field: "health_care", visible: false}, + {title: "Infortuni", field: "injuries", visible: false}, + {title: "RC", field: "rc", visible: false}, + {title: "REGA", field: "rega", visible: false}, + {title: "Nome medico", field: "medic_name", visible: false}, + {title: "Telefono medico", field: "medic_phone", visible: false}, + {title: "Indirizzo medico", field: "medic_address", visible: false}, + {title: "Malattie avute", field: "sickness", visible: false}, + {title: "Vaccinazioni", field: "vaccine", visible: false}, + {title: "Data vaccino tetano", field: "tetanus_date", visible: false}, + {title: "Allergie", field: "allergy", visible: false}, + {title: "Farmaci da assumere", field: "drugs", visible: false}, + {title: "Info particolari", field: "misc", visible: false}, + ] + }, + ] + + var docTypes = {}; + for (var i=0; i < tabledata.length; i++) { + if (!(tabledata[i].type in docTypes)) { + docTypes[tabledata[i].type] = true; + } + } + + for (var key in docTypes) { + tabledata.push({ + type: key, + username: "col_row", + }); + } + + var col_select = document.getElementById("column-select"); + for (var j = 0; j < col_categories.length; j++) { + col_select.innerHTML += '
'; + var all_visible = true; + for (var i = 0; i < col_categories[j].cols.length; i++) { + columns.push(col_categories[j].cols[i]); + if (columns[columns.length-1].visible == false) { + col_select.innerHTML += '
'; + all_visible = false; + } else { + col_select.innerHTML += '
'; + } + } + } + + for (var i = 0; i < col_categories.length; i++) { + verify_check(col_categories[i].field); + } + + var hasGroupSummary = {}; + + //initialize table + var table = new Tabulator("#example-table", { + movableColumns: true, + layout:"fitDataFill", + responsiveLayout: "hide", + groupBy: "type", + data:tabledata, + columns:columns, + groupHeader:function(value, count, data, group){ + return value + "(" + count + ")"; + }, + }); + + function update_cols() { + for (var i = 0; i < columns.length; i++) { + if (document.getElementById("filter_"+columns[i].field).checked) { + table.showColumn(columns[i].field); + } else { + table.hideColumn(columns[i].field); + } + } + } + + function check_all(cat) { + var ctr_elem = document.getElementById("category_"+cat); + if (ctr_elem.checked) { + $('.ctr_'+cat).prop('checked', 'checked'); + } else { + $('.ctr_'+cat).prop('checked', false); + } + } + + function verify_check(cat) { + var ctr_elem = document.getElementById("category_"+cat); + var all_checked = true; + $('.ctr_'+cat).each(function() { + if (!this.checked) { + all_checked = false; + } + }); + if (all_checked) { + ctr_elem.checked = true; + } else { + ctr_elem.checked = false; + } + } + +$('.chips').chips(); +$('#chips_type').chips({ + placeholder: 'Tipo', + secondaryPlaceholder: '+Altro tipo', + autocompleteOptions: { + data: { + {% for t in types %} + '{{t.name}}': null, + {% endfor %} + }, + limit: Infinity, + minLength: 0 + }, + data: [ + {% for d in chips_type %} + {tag: '{{d}}'}, + {% endfor %} + ] +}); +$('#chips_owner').chips({ + placeholder: 'Utente', + secondaryPlaceholder: '+Altro utente', + autocompleteOptions: { + data: { + {% for user in users %} + '{{user.user__username}} ({{user.user__first_name}} {{user.user__last_name}})': null, + {% endfor %} + }, + limit: Infinity, + minLength: 0 + }, + data: [ + {% for d in chips_owner %} + {tag: '{{d}}'}, + {% endfor %} + ] +}); +$('#chips_groups').chips({ + placeholder: 'Gruppo', + secondaryPlaceholder: '+Altro gruppo', + autocompleteOptions: { + data: { + {% for g in groups %} + '{{g}}': null, + {% endfor %} + }, + limit: Infinity, + minLength: 0 + }, + data: [ + {% for g in chips_groups %} + {tag: '{{g}}'}, + {% endfor %} + ] +}); + +function send(id) { + var form = document.getElementById('selection') + var action = document.getElementById('action') + var owner = document.getElementById('owner') + var type = document.getElementById('type') + var groups = document.getElementById('groups') + var chips_owner = M.Chips.getInstance(document.getElementById('chips_owner')); + var chips_type = M.Chips.getInstance(document.getElementById('chips_type')); + var chips_groups = M.Chips.getInstance(document.getElementById('chips_groups')); + var type_array = [] + var owner_array = [] + var groups_array = [] + + for (i=0; i < chips_owner.chipsData.length; i++) { + owner_array.push(chips_owner.chipsData[i].tag) + } + + for (i=0; i < chips_type.chipsData.length; i++) { + type_array.push(chips_type.chipsData[i].tag) + } + + for (i=0; i < chips_groups.chipsData.length; i++) { + groups_array.push(chips_groups.chipsData[i].tag) + } + + action.setAttribute('value', id); + owner.setAttribute('value', owner_array.join("^|")) + type.setAttribute('value', type_array.join("^|")) + groups.setAttribute('value', groups_array.join("^|")) + form.submit() +} + +{% endblock %} \ No newline at end of file diff --git a/server/urls.py b/server/urls.py index b49a027..9eced0f 100644 --- a/server/urls.py +++ b/server/urls.py @@ -12,6 +12,7 @@ urlpatterns = [ path('doccreate', views.doccreate, name='doccreate'), path('docedit', views.docedit, name='docedit'), path('doclist', views.doclist, name='doclist'), + path('doclist-table', views.doclist_table, name='doclist-table'), path('doclistro', views.doclist_readonly, name='doclistro'), path('docapprove', views.docapprove, name='docapprove'), path('docupload', views.upload_doc, name='docupload'), diff --git a/server/views.py b/server/views.py index 66fa1c7..dd9bcec 100644 --- a/server/views.py +++ b/server/views.py @@ -1274,6 +1274,143 @@ def doclist(request): return render(request, 'server/doc_list.html', context) +@user_passes_test(isStaff) +def doclist_table(request): + context = {} + + # group name and obj + parent_groups = getGroups(request) + + # create typezone + zurich = pytz.timezone('Europe/Zurich') + + # init error variables for users + error = False + error_text = "" + + # init checkboxes for filter + hidden = False + wait = True + selfsign = True + ok = True + signdoc = False + + hidden_check = 'checked="checked"' + wait_check = 'checked="checked"' + selfsign_check = 'checked="checked"' + ok_check = 'checked="checked"' + signdoc_check = 'checked="checked"' + + # set default dates for filters + newer = zurich.localize(dateparser.parse("1970-01-01")) + older = zurich.localize(datetime.now()) + + # init chips values + owner = [] + types = [] + groups = [] + chips_owner = [] + chips_types = [] + chips_groups = [] + + if request.method == "POST": + # get filter values + hidden = "filter_hidden" in request.POST + wait = "filter_wait" in request.POST + selfsign = "filter_selfsign" in request.POST + ok = "filter_ok" in request.POST + signdoc = "filter_signdoc" in request.POST + newer = zurich.localize(dateparser.parse(request.POST["newer"])) + older = zurich.localize(dateparser.parse( + request.POST["older"]) + timedelta(days=1)) + owner = request.POST["owner"].split("^|") + types = request.POST["type"].split("^|") + groups = request.POST["groups"].split("^|") + + # clear filters + if request.POST["action"] == 'clear': + hidden = False + wait = True + selfsign = True + ok = True + signdoc = False + newer = zurich.localize(dateparser.parse("1970-01-01")) + older = zurich.localize(datetime.now()) + owner = [] + types = [] + groups = [] + + # filter documents based on group of staff and date range + q_obj = Q(group__in=parent_groups) & Q(compilation_date__range=[newer, older]) + + # filter documents + if not hidden: + q_obj &= ~Q(status="archive") + hidden_check = "" + if not wait: + q_obj &= ~Q(status="wait") + wait_check = "" + if not selfsign: + q_obj &= ~Q(status="autosign") + selfsign_check = "" + if not ok: + q_obj &= ~Q(status="ok") + ok_check = "" + if signdoc: + q_obj &= ~Q(signed_doc="") + else: + signdoc_check = "" + + # filter types, owner, groups using chips + if len(types) > 0: + if types[0] != "": + q_obj &= Q(document_type__name__in=types) + chips_types += types + + if len(owner) > 0: + if owner[0] != "": + q_obj &= Q(user__username__in=list(map(lambda x: x.split("(")[0][:-1], owner))) + chips_owner += owner + + if len(groups) > 0: + if groups[0] != "": + q_obj &= Q(user__groups__name__in=groups) + chips_groups += groups + + # run query + documents = Document.objects.filter(q_obj).select_related("personal_data", "medical_data", "document_type", "user") + + users = documents.values("user__username", "user__first_name", "user__last_name") + + # get types and users for chips autocompletation + if request.user.is_staff: + auto_types = DocumentType.objects.filter( + Q(group_private=False) | Q(group=getGroups(request)[0])) + else: + auto_types = DocumentType.objects.filter(Q(group_private=False)) + + context = { + "types": auto_types, + "users": users, + "groups": Group.objects.all(), + "docs": documents, + "hidden_check": hidden_check, + "wait_check": wait_check, + "selfsign_check": selfsign_check, + "ok_check": ok_check, + "signdoc_check": signdoc_check, + "newer": newer, + "older": older, + "chips_owner": chips_owner, + "chips_type": chips_types, + "chips_groups": chips_groups, + 'error': error, + 'error_text': error_text, + 'settings': settings, + } + + return render(request, 'server/doc_list_table.html', context) + @user_passes_test(isCapi_enabled) def doclist_readonly(request): context = {} diff --git a/templates/registration/base_admin.html b/templates/registration/base_admin.html index d419dd2..9f78b43 100644 --- a/templates/registration/base_admin.html +++ b/templates/registration/base_admin.html @@ -79,6 +79,8 @@ max-height: 90% !important; } } + + .embedded-row:hover{ background-color: #e5e5e5 !important;} diff --git a/version.txt b/version.txt index 68a0f2d..e463c6e 100644 --- a/version.txt +++ b/version.txt @@ -1,2 +1,2 @@ version=0.6 -rev=20 +rev=21 -- cgit v1.2.1