srcs/phpmyadmin/templates/database/tracking/tables.twig


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
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161

{# Tracked tables exists#}
{% if head_version_exists %}
    <div id="tracked_tables">
        <h3>{% trans 'Tracked tables' %}</h3>

        <form method="post" action="db_tracking.php" name="trackedForm"
            id="trackedForm" class="ajax">
            {{ get_hidden_inputs(db) }}
            <table id="versions" class="data">
                <thead>
                    <tr>
                        <th></th>
                        <th>{% trans 'Table' %}</th>
                        <th>{% trans 'Last 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_tbl[]"
                                    class="checkall" id="selected_tbl_{{ version.table_name }}"
                                    value="{{ version.table_name }}">
                            </td>
                            <th>
                                <label for="selected_tbl_{{ version.table_name }}">
                                    {{ version.table_name }}
                                </label>
                            </th>
                            <td class="right">
                                {{ version.version }}
                            </td>
                            <td>
                                {{ version.date_created }}
                            </td>
                            <td>
                                {{ version.date_updated }}
                            </td>
                            <td>
                                {{ version.status_button|raw }}
                            </td>
                            <td>
                                <a class="delete_tracking_anchor ajax" href="db_tracking.php" data-post="
                                    {{- get_common({
                                        'db': db,
                                        'goto': 'tbl_tracking.php',
                                        'back': 'db_tracking.php',
                                        'table': version.table_name,
                                        'delete_tracking': true
                                    }, '') }}">
                                    {{ get_icon('b_drop', 'Delete tracking'|trans) }}
                                </a>
                            </td>
                            <td>
                                <a href="tbl_tracking.php" data-post="
                                    {{- get_common({
                                        'db': db,
                                        'goto': 'tbl_tracking.php',
                                        'back': 'db_tracking.php',
                                        'table': version.table_name
                                    }, '') }}">
                                    {{ get_icon('b_versions', 'Versions'|trans) }}
                                </a>
                                <a href="tbl_tracking.php" data-post="
                                    {{- get_common({
                                        'db': db,
                                        'goto': 'tbl_tracking.php',
                                        'back': 'db_tracking.php',
                                        'table': version.table_name,
                                        'report': true,
                                        'version': version.version
                                    }, '') }}">
                                    {{ get_icon('b_report', 'Tracking report'|trans) }}
                                </a>
                                <a href="tbl_tracking.php" data-post="
                                    {{- get_common({
                                        'db': db,
                                        'goto': 'tbl_tracking.php',
                                        'back': 'db_tracking.php',
                                        'table': version.table_name,
                                        'snapshot': true,
                                        'version': version.version
                                    }, '') }}">
                                    {{ get_icon('b_props', 'Structure snapshot'|trans) }}
                                </a>
                            </td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
            {% include 'select_all.twig' with {
                'pma_theme_image': pma_theme_image,
                'text_dir': text_dir,
                'form_name': 'trackedForm'
            } only %}
            {{ get_button_or_image(
                'submit_mult',
                'mult_submit',
                'Delete tracking'|trans,
                'b_drop',
                'delete_tracking'
            ) }}
        </form>
    </div>
{% endif %}
{% if untracked_tables_exists %}
    <h3>{% trans 'Untracked tables' %}</h3>
    <form method="post" action="db_tracking.php" name="untrackedForm"
        id="untrackedForm" class="ajax">
        {{ get_hidden_inputs(db) }}
        <table id="noversions" class="data">
            <thead>
                <tr>
                    <th></th>
                    <th>{% trans 'Table' %}</th>
                    <th>{% trans 'Action' %}</th>
                </tr>
            </thead>
            <tbody>
                {% for table_name in untracked_tables %}
                  {% if get_tracker_version(db, table_name) == -1 %}
                    <tr>
                        <td class="center">
                            <input type="checkbox" name="selected_tbl[]"
                                class="checkall" id="selected_tbl_{{ table_name }}"
                                value="{{ table_name }}">
                        </td>
                        <th>
                            <label for="selected_tbl_{{ table_name }}">
                                {{ table_name }}
                            </label>
                        </th>
                        <td>
                            <a href="tbl_tracking.php{{ url_query|raw }}&amp;table={{ table_name }}">
                                {{ get_icon('eye', 'Track table'|trans) }}
                            </a>
                        </td>
                    </tr>
                  {% endif %}
                {% endfor %}
            </tbody>
        </table>
        {% include 'select_all.twig' with {
            'pma_theme_image': pma_theme_image,
            'text_dir': text_dir,
            'form_name': 'untrackedForm'
        } only %}
        {{ get_button_or_image(
            'submit_mult',
            'mult_submit',
            'Track table'|trans,
            'eye',
            'track'
        ) }}
    </form>
{% endif %}