[%- USE HTML %][%- USE LxERP -%][%- USE T8 -%][%- USE L -%]

[% INCLUDE 'common/flash.html' %]

<h1>[% HTML.escape(title) %]</h1>

<form method="post" action="controller.pl">
 <p>
  [% LxERP.t8('You can either create a new database or chose an existing database.') %]
  [% LxERP.t8('In the latter case the tables needed by kivitendo will be created in that database.') %]
 </p>

 [% IF !superuser.have_privileges %]
  <p>
   [% LxERP.t8("Database superuser privileges are required for parts of the database modifications.") %]
   [% LxERP.t8("Please provide corresponding credentials.") %]
  </p>
 [% END %]

 <table border="0">
  <tr>
   <th valign="top" align="right" nowrap>[% LxERP.t8('Existing Datasets') %]</th>
   <td valign="top">[% FOREACH db = SELF.all_dbsources %][% UNLESS loop.first %] [% END %][[% HTML.escape(db) %]][% END %]</td>
  </tr>

  <tr>
   <th align="right" nowrap>[% LxERP.t8('Create Dataset') %]</th>
   <td>[% L.input_tag('db', FORM.db, class="initial_focus") %]</td>
  </tr>

  [% IF !superuser.have_privileges %]
   <tr>
    <th align="right" nowrap>[% LxERP.t8("Database Superuser") %]</th>
    <td>[% L.input_tag("database_superuser_user", superuser.username) %]</td>
   </tr>

   <tr>
    <th align="right" nowrap>[% LxERP.t8("Password") %]</th>
    <td>[% L.input_tag("database_superuser_password", superuser.password, type="password") %]</td>
   </tr>
  [% END %]

  <tr>
   <td colspan="1"> </td>
   <td><hr size="1" noshade></td>
  </tr>

  <tr>
   <th align="right" nowrap>[% LxERP.t8('Default currency') %]</th>
   <td>[% L.input_tag('defaultcurrency', FORM.defaultcurrency) %]</td>
  </tr>

  <tr>
   <th align="right" nowrap>[% LxERP.t8('Precision') %]</th>
   <td>[% L.input_tag('precision_as_number', LxERP.format_amount(FORM.precision, 2)) %] [% LxERP.t8('Precision Note') %]</td>
  </tr>

  <tr>
   <th valign="top" align="right" nowrap>[% LxERP.t8('Create Chart of Accounts') %]</th>
   <td>[% L.select_tag('chart', SELF.all_charts, default=(FORM.chart), onchange='comment_selected_chart(this.value)') %]</td>
  </tr>

  <tr>
   <th valign="top" align="right" nowrap>[% LxERP.t8('Accounting method') %]</th>
   <td>[% L.select_tag('accounting_method', SELF.all_accounting_methods, title_key='name', default=(FORM.accounting_method)) %]</td>
  </tr>

  <tr>
   <th valign="top" align="right" nowrap>[% LxERP.t8('Inventory system') %]</th>
   <td>[% L.select_tag('inventory_system', SELF.all_inventory_systems, title_key='name', default=(FORM.inventory_system)) %]</td>
  </tr>

  <tr>
   <th valign="top" align="right" nowrap>[% LxERP.t8('Profit determination') %]</th>
   <td>[% L.select_tag('profit_determination', SELF.all_profit_determinations, title_key='name', default=(FORM.profit_determination)) %]</td>
  </tr>
 </table>

 [% L.hidden_tag("dbhost", FORM.dbhost) %]
 [% L.hidden_tag("dbport", FORM.dbport) %]
 [% L.hidden_tag("dbuser", FORM.dbuser) %]
 [% L.hidden_tag("dbpasswd", FORM.dbpasswd) %]
 [% L.hidden_tag("dbdefault", FORM.dbdefault) %]
 [% L.hidden_tag("action", "Admin/do_create_dataset") %]
 [% L.hidden_tag("feature_balance", FORM.feature_balance) %]
 [% L.hidden_tag("feature_datev", FORM.feature_datev) %]
 [% L.hidden_tag("feature_erfolgsrechnung", FORM.feature_erfolgsrechnung) %]
 [% L.hidden_tag("feature_eurechnung", FORM.feature_eurechnung) %]
 [% L.hidden_tag("feature_ustva", FORM.feature_ustva) %]


 <hr size="3" noshade>

 <div>
  [% L.submit_tag('dummy', LxERP.t8('Create Dataset')) %]
 </div>

</form>

<script type="text/javascript">
 <!--

function comment_selected_chart(s) {
  if (s == 'Austria') {
    alert("SKR07 Austria ist noch Stand 2002." +
         "\n" +
         "Die Buchungsgruppen sind nicht korrekt vorkonfiguriert" +
         "\n" +
         "fuer Kunden im Ausland." +
         "\n" +
         "Hinweis vom 20.09.2011");
  }
  return true;
}

function select_country_defaults(country) {
  if (/^CH/.test(country)) {
    document.getElementById('defaultcurrency').value='CHF';
    document.getElementById('precision').value='0.05';
    document.getElementById('chart').value='Switzerland-deutsch-MWST-2014';
    document.getElementById('accounting_method').value='accrual';
    document.getElementById('inventory_system').value='periodic';
    document.getElementById('profit_determination').value='balance';
  } else {
    document.getElementById('defaultcurrency').value='EUR';
    document.getElementById('precision').value='0.01';
    document.getElementById('chart').value='Germany-DATEV-SKR03EU';
    document.getElementById('accounting_method').value='cash';
    document.getElementById('inventory_system').value='periodic';
    document.getElementById('profit_determination').value='income';
  }
  return true;
}

   -->
</script>