From 323b2f3159e0e5aa2ecea3b1ceae9efeecd6a00d Mon Sep 17 00:00:00 2001
From: Andrea Lepori <aleporia@gmail.com>
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 %}
+ <a href="{% url 'server'%}" class="breadcrumb hide-on-med-and-down">Admin</a>
+ <a class="breadcrumb hide-on-med-and-down">Documenti</a>
+{% endblock %}
+{% block toolbar %}
+ <div class="nav-wrapper {{color}}">
+ <ul>
+ <li><a href="#modal1" data-target="modal1" class="modal-trigger tooltipped" data-position="top" data-tooltip="Seleziona colonne"><i class="material-icons">view_column</i></a></li>
+ </ul>
+ <ul class="right">
+ <li><a class="tooltipped" data-position="top" data-tooltip="Pulisci filtri" Onclick="send('clear')"><i class="material-icons">clear</i></a></li>
+ <li><a href="#modal2" data-target="modal2" class="modal-trigger tooltipped" data-position="top" data-tooltip="Filtri"><i class="material-icons">filter_list</i></a></li>
+ </ul>
+ </div>
+{% endblock %}
+
+{% block content %}
+{% load app_filter %}
+<form id="selection" action="{% url 'doclist-table' %}" method="post">
+{% csrf_token %}
+<div id="modal2" class="modal modal-fixed-footer">
+ <div class="modal-content">
+ <h5>Filtri</h5>
+ <div class="row">
+ <div class="input-field col l3 s12">
+ <label>
+ <input name="filter_hidden" type="checkbox" class="filled-in" {{hidden_check}}/>
+ <span style="color:black"><i class="material-icons left">archive</i>Archiviati</span>
+ </label>
+ </div>
+ <div class="input-field col l3 s12">
+ <label>
+ <input name="filter_wait" type="checkbox" class="filled-in" {{wait_check}}/>
+ <span style="color:black"><i class="material-icons left">timelapse</i>In Attesa</span>
+ </label>
+ </div>
+ <div class="input-field col l3 s12">
+ <label>
+ <input name="filter_selfsign" type="checkbox" class="filled-in" {{selfsign_check}}/>
+ <span style="color:black"><i class="material-icons left">assignment_turned_in</i>No firma</span>
+ </label>
+ </div>
+ <div class="input-field col l3 s12">
+ <label>
+ <input name="filter_ok" type="checkbox" class="filled-in" {{ok_check}}/>
+ <span style="color:black"><i class="material-icons left">check</i>Approvati</span>
+ </label>
+ </div>
+ </div>
+ <br>
+ <br>
+ <div class = "row">
+ <div class="input-field col l6 s12">
+ <label for="newer">Più recenti di</label>
+ <input value="{{newer}}" name="newer" id="newer" type="text" class="datepicker">
+ </div>
+ <div class="input-field col l6 s12">
+ <label for="older">Più vecchi di</label>
+ <input value="{{older}}" name="older" id="older" type="text" class="datepicker">
+ </div>
+ </div>
+ <div class = "row">
+ <div class="col s12">
+ <div id="chips_type" class="chips chips-placeholder chips-autocomplete"></div>
+ </div>
+ <div class="col s12">
+ <div id="chips_owner" class="chips chips-placeholder chips-autocomplete "></div>
+ </div>
+ <div class="col s12">
+ <div id="chips_groups" class="chips chips-placeholder chips-autocomplete "></div>
+ </div>
+ </div>
+ <div class="row">
+ <div class="input-field col s12">
+ <label>
+ <input name="filter_signdoc" type="checkbox" class="filled-in" {{signdoc_check}}/>
+ <span style="color:black"><i class="material-icons left">check_circle</i>Visualizza solo approvati con firma allegata</span>
+ </label>
+ </div>
+ </div>
+ </div>
+ <div class="modal-footer">
+ <a href="#!" onclick="send('filter')" class="modal-close waves-effect waves-green btn-flat">Applica</a>
+ </div>
+</div>
+<input type="hidden" name="action" id="action">
+<input type="hidden" name="owner" id="owner">
+<input type="hidden" name="type" id="type">
+<input type="hidden" name="groups" id="groups">
+<div id="modal1" class="modal modal-fixed-footer">
+ <div class="modal-content">
+ <h5>Colonne</h5>
+ <div class="row" id="column-select">
+ </div>
+ </div>
+ <div class="modal-footer">
+ <a href="#!" onclick="update_cols()" class="modal-close waves-effect waves-green btn-flat">Applica</a>
+ </div>
+</div>
+</form>
+
+<div id="example-table"></div>
+{% 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 '<i class="material-icons">' + cell.getValue() + '</i>';
+ }
+
+ 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 += '<div class="input-field col s12"><label><input onclick="check_all(\''+col_categories[j].field+'\')" id="category_'+col_categories[j].field+'" type="checkbox" class="filled-in"/><span style="color:black"><b>'+col_categories[j].name+'</b></span></label></div>';
+ 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 += '<div class="input-field col s12"><label> <input onclick="verify_check(\''+col_categories[j].field+'\')" id="filter_'+col_categories[j].cols[i].field+'" type="checkbox" class="filled-in ctr_'+col_categories[j].field+'"/><span style="color:black">'+col_categories[j].cols[i].title+'</span></label></div>';
+ all_visible = false;
+ } else {
+ col_select.innerHTML += '<div class="input-field col s12"><label> <input onclick="verify_check(\''+col_categories[j].field+'\')" id="filter_'+col_categories[j].cols[i].field+'" type="checkbox" class="filled-in ctr_'+col_categories[j].field+'" checked="checked"/><span style="color:black">'+col_categories[j].cols[i].title+'</span></label></div>';
+ }
+ }
+ }
+
+ 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 + "<span style='color:#d00; margin-left:10px;'>(" + count + ")</span>";
+ },
+ });
+
+ 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;}
</style>
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<meta charset="utf-8">
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