1 [%- USE HTML %][%- USE LxERP -%][%- USE L -%][%- USE JavaScript -%]
3 [% INCLUDE 'common/flash.html' %]
5 <h1>[% HTML.escape(title) %]</h1>
8 [% LxERP.t8('You can only delete datasets that are not in use.') %]
9 [% LxERP.t8('If you want to delete such a dataset you have to edit the client(s) that are using the dataset in question and have them use another dataset.') %]
12 [% IF SELF.all_dbsources.size %]
14 <form method="post" action="controller.pl">
16 [% LxERP.t8('Please select the dataset you want to delete:') %]
17 [% L.select_tag('db', SELF.all_dbsources, class="initial_focus") %]
20 [% L.hidden_tag("dbhost", FORM.dbhost) %]
21 [% L.hidden_tag("dbport", FORM.dbport) %]
22 [% L.hidden_tag("dbuser", FORM.dbuser) %]
23 [% L.hidden_tag("dbpasswd", FORM.dbpasswd) %]
24 [% L.hidden_tag("dbdefault", FORM.dbdefault) %]
25 [% L.hidden_tag("action", "Admin/do_delete_dataset") %]
28 [% L.submit_tag('dummy', LxERP.t8('Delete Dataset'), id='submit') %]
33 <script type="text/javascript">
36 var used_dbsources = {[% FOREACH client = SELF.all_clients %]
37 "[% JavaScript.escape(client.dbhost || 'localhost') %]:[% JavaScript.escape(client.dbport || '5432') %]:[% JavaScript.escape(client.dbname || 'localhost') %]": "[% JavaScript.escape(client.name) %]"[% UNLESS loop.last %],[% END %][% END %]
41 $('#submit').click(function() {
42 var client = used_dbsources[$('#dbhost').val() + ':' + $('#dbport').val() + ':' + $('#db').val()];
43 var question = !client ? kivi.t8('Are you sure?') : kivi.t8('The selected database is still configured for client "#1". If you delete the database that client will stop working until you re-configure it. Do you still want to delete the database?', [ client ]);
45 return confirm(question);