diff options
Diffstat (limited to '')
| -rw-r--r-- | server/templates/server/doc_list_table.html | 424 | ||||
| -rw-r--r-- | server/urls.py | 1 | ||||
| -rw-r--r-- | server/views.py | 137 |
3 files changed, 562 insertions, 0 deletions
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 = {}
|