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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
{% if selectable_tables_num_rows > 0 %}
<form method="post" action="tbl_tracking.php{{ url_query|raw }}">
{{ get_hidden_inputs(db, table) }}
<select name="table" class="autosubmit">
{% for entry in selectable_tables_entries %}
<option value="{{ entry.table_name }}"
{{- entry.table_name == selected_table ? ' selected' }}>
{{ entry.db_name }}.{{ entry.table_name }}
{% if entry.is_tracked %}
({% trans 'active' %})
{% else %}
({% trans 'not active' %})
{% endif %}
</option>
{% endfor %}
</select>
<input type="hidden" name="show_versions_submit" value="1">
</form>
{% endif %}
<br>
{% if last_version > 0 %}
<form method="post" action="tbl_tracking.php" name="versionsForm" id="versionsForm" class="ajax">
{{ get_hidden_inputs(db, table) }}
<table id="versions" class="data">
<thead>
<tr>
<th></th>
<th>{% trans 'Version' %}</th>
<th>{% trans 'Created' %}</th>
<th>{% trans 'Updated' %}</th>
<th>{% trans 'Status' %}</th>
<th>{% trans 'Action' %}</th>
<th>{% trans 'Show' %}</th>
</tr>
</thead>
<tbody>
{% for version in versions %}
<tr>
<td class="center">
<input type="checkbox" name="selected_versions[]"
class="checkall" id="selected_versions_{{- version['version']|escape }}"
value="{{- version['version']|escape }}">
</td>
<td class="floatright">
<label for="selected_versions_{{- version['version']|escape }}">
<b>{{ version['version']|escape }}</b>
</label>
</td>
<td>{{ version['date_created']|escape }}</td>
<td>{{ version['date_updated']|escape }}</td>
{% if version['tracking_active'] == 1 %}
{% set last_version_status = 1 %}
<td>{% trans 'active' %}</td>
{% else %}
{% set last_version_status = 0 %}
<td>{% trans 'not active' %}</td>
{% endif %}
<td>
<a class="delete_version_anchor ajax" href="tbl_tracking.php" data-post="
{{- get_common(url_params|merge({
'version': version['version'],
'submit_delete_version': true
}), '') }}">
{{ get_icon('b_drop', 'Delete version'|trans) }}
</a>
</td>
<td>
<a href="tbl_tracking.php" data-post="
{{- get_common(url_params|merge({
'version': version['version'],
'report': 'true'
}), '') }}">
{{ get_icon('b_report', 'Tracking report'|trans) }}
</a>
<a href="tbl_tracking.php" data-post="
{{- get_common(url_params|merge({
'version': version['version'],
'snapshot': 'true'
}), '') }}">
{{ get_icon('b_props', 'Structure snapshot'|trans) }}
</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
{% include 'select_all.twig' with {
'pma_theme_image': pmaThemeImage,
'text_dir': text_dir,
'form_name': 'versionsForm',
} only %}
{{ get_button_or_image(
'submit_mult',
'mult_submit',
'Delete version'|trans,
'b_drop',
'delete_version'
) }}
</form>
{% set last_version_element = versions|first %}
<div>
<form method="post" action="tbl_tracking.php{{ url_query|raw }}">
{{ get_hidden_inputs(db, table) }}
<fieldset>
<legend>
{% if last_version_element['tracking_active'] == 0 %}
{% set legend = 'Activate tracking for %s'|trans %}
{% set value = 'activate_now' %}
{% set button = 'Activate now'|trans %}
{% else %}
{% set legend = 'Deactivate tracking for %s'|trans %}
{% set value = 'deactivate_now' %}
{% set button = 'Deactivate now'|trans %}
{% endif %}
{{ legend|format(db ~ '.' ~ table) }}
</legend>
<input type="hidden" name="version" value="{{ last_version }}">
<input type="hidden" name="toggle_activation" value="{{ value }}">
<input class="btn btn-secondary" type="submit" value="{{ button }}">
</fieldset>
</form>
</div>
{% endif %}
{% include 'create_tracking_version.twig' with {
'url_query': url_query,
'last_version': last_version,
'db': db,
'selected': [table],
'type': type,
'default_statements': default_statements,
} only %}
|