1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<html>
<title>AVON</title>
<head>
<style>
td { vertical-align: top; }
tr.color_1 { background: #ccc; }
table { border: none; }
</style>
</head>
<body>
<form action="/" METHOD="POST">
{%- for field in range(1,5) -%}
<div class="search_entry">
<select name="search_{{ field }}_column">
{% set column_search = request.form.get('search_'+(field|string)+'_string', '') %}
{% if column_search | length %}
{% set column_val = request.form.get('search_'+(field|string)+'_column') %}
{% set operator_val = request.form.get('search_'+(field|string)+'_operator') %}
{% set any_val = request.form.get('search_'+(field|string)+'_any') %}
{% else %}
{% set column_val = ['nachname', 'vorname', 'ort', 'rufnummer'][field-1] %}
{% set operator_val = ['equals', 'contains', 'equals', 'contains'][field-1] %}
{% set any_val = ['', '', 'on', ''][field-1] %}
{% endif %}
{%- for column in [ ['vorname', 'Vorname'], ['nachname', 'Nachname'], ['zip', 'PLZ'], ['ort', 'Ort'], ['vorwahl', 'Vorwahl'], ['rufnummer', 'Rufnummer'], ['strasse', 'Straße'], ['hausnummer', 'Hausnummer'], ['zusaetze', 'Zusatz'], ['verweise', 'Verweise / Branche'], ['email', 'E-Mail'], ['web', 'Webseite'] ] -%}
<option value="{{ column[0] }}" {%- if column_val== column[0] -%}selected="selected"{%- endif -%}>{{ column[1] }}</option>
{%- endfor -%}
</select>
<select name="search_{{ field }}_operator">
{%- for operator in [ [ 'equals', 'equals'], ['beginswith', 'begins with'], ['contains', 'contains' ], ['equalsnot', 'equals not'], ['containsnot', 'contains not'] ] -%}
<option value="{{ operator[0] }}" {%- if operator_val == operator[0] -%}selected="selected"{%- endif -%}>{{ operator[1] }}</option>
{%- endfor -%}
</select>
<input type="checkbox" name="search_{{ field }}_any" {%- if any_val == 'on' -%}checked="{%- endif -%}">any</input>
<input type="text" name="search_{{ field }}_string" value="{{ request.form.get('search_'+(field|string)+'_string', '') }}">
</div>
{%- endfor -%}
<input type="submit" value="Search">
</form>
{% if rows | length > 0 -%}<h3>Found {{ rows | length }} matches.</h3>{% endif %}
{% set color = { 'value': 0 } %}
<table>
<thead><td>flags</td><td>zip</td></thead>
{%- for row in rows -%}
{% set span = row[3:16] | reject("none") | map('length') | max %}
{% for r in range (span) %}
{% if ( r == 0 ) and ( color.update({ 'value': 1 - color.value }) ) %} {% endif %}
<tr class="color_{{ color.value }}">
{%- if r == 0 -%}
<td rowspan="{{span}}">{{ convert.bits_to_years(row[0]|int) }} : {{ convert.bits_to_years(row[1]|int) }} : {{ convert.bits_to_years(row[2]|int) }}</td>
{%- endif -%}
{%- for c in range(3, 16) -%}
<td>{{ row[c][r] or '' }}</td>
{%- endfor -%}
</tr>
{%- endfor -%}
{%- endfor -%}
</table>
</body>
</html>
|
