Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 867b69c4

Von Hans Peter Schlaepfer vor mehr als 5 Jahren hinzugefügt

  • ID 867b69c47468635e46ed40f34d8907a97258fa7f
  • Vorgänger 5b8ff438
  • Nachfolger 3fb30e00

Neues kivitendo Design Aenderungen in templates/webpages/dbupgrade/..

Unterschiede anzeigen:

templates/webpages/dbupgrade/acc_trans_constraints.html
1 
[%- USE T8 %]
2 
[%- USE L %]
1 
[% USE T8 %]
2 
[% USE L %]
3 3 
[% USE HTML %]
4 4 
<h1>[% 'Invalid transactions' | $T8 %]</h1>
5 5 

  		




  ......




  13
  13
  
    
  <p>[% 'Transactions without account:' | $T8 %]</p>


  		




  14
  14
  
    
  <table>


  		




  15
  15
  
    
    <tr>


  		




  16
  
  
    
      <th class="listheading">[% 'Database ID' | $T8 %]</th>


  		




  17
  
  
    
      <th class="listheading">[% 'Gldate' | $T8 %]</th>


  		




  18
  
  
    
      <th class="listheading">[% 'Transdate' | $T8 %]</th>


  		




  19
  
  
    
      <th class="listheading">[% 'Amount' | $T8 %]</th>


  		




  20
  
  
    
      <th class="listheading">[% 'ID' | $T8 %]</th>


  		




  21
  
  
    
      <th class="listheading">[% 'Source' | $T8 %]</th>


  		




  22
  
  
    
      <th class="listheading">[% 'Reference / Invoice Number' | $T8 %]</th>


  		




  23
  
  
    
      <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  24
  
  
    
      <th class="listheading">[% 'Notes' | $T8 %]</th>


  		




  25
  
  
    
      <th class="listheading">[% 'Employee' | $T8 %]</th>


  		




  26
  
  
    
      <th class="listheading">[% 'User' | $T8 %]</th>


  		




  27
  
  
    
      <th class="listheading">[% 'Project Number' | $T8 %]</th>


  		




  28
  
  
    
      <th class="listheading">[% 'Project Description' | $T8 %]</th>


  		




  
  16
  
    
      <th>[% 'Database ID' | $T8 %]</th>


  		




  
  17
  
    
      <th>[% 'Gldate' | $T8 %]</th>


  		




  
  18
  
    
      <th>[% 'Transdate' | $T8 %]</th>


  		




  
  19
  
    
      <th>[% 'Amount' | $T8 %]</th>


  		




  
  20
  
    
      <th>[% 'ID' | $T8 %]</th>


  		




  
  21
  
    
      <th>[% 'Source' | $T8 %]</th>


  		




  
  22
  
    
      <th>[% 'Reference / Invoice Number' | $T8 %]</th>


  		




  
  23
  
    
      <th>[% 'Description' | $T8 %]</th>


  		




  
  24
  
    
      <th>[% 'Notes' | $T8 %]</th>


  		




  
  25
  
    
      <th>[% 'Employee' | $T8 %]</th>


  		




  
  26
  
    
      <th>[% 'User' | $T8 %]</th>


  		




  
  27
  
    
      <th>[% 'Project Number' | $T8 %]</th>


  		




  
  28
  
    
      <th>[% 'Project Description' | $T8 %]</th>


  		




  29
  29
  
    
    </tr>


  		




  30
  30
  
    

  		




  31
  31
  
    
    [% SET row_odd = '1' %][% FOREACH row = NO_CHART_ID %]


  		




  32
  32
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  33
  
  
    
      <td align="left">[% HTML.escape(row.acc_trans_id) %]</td>


  		




  34
  
  
    
      <td align="left">[% HTML.escape(row.gldate) %]</td>


  		




  35
  
  
    
      <td align="left">[% HTML.escape(row.transdate) %]</td>


  		




  36
  
  
    
      <td align="left">[% HTML.escape(row.amount) %]</td>


  		




  37
  
  
    
      <td align="left">[% HTML.escape(row.trans_id) %]</td>


  		




  38
  
  
    
      <td align="left">[% HTML.escape(row.source) %]</td>


  		




  39
  
  
    
      <td align="left">[% HTML.escape(row.reference) %]</td>


  		




  40
  
  
    
      <td align="left">[% HTML.escape(row.description) %]</td>


  		




  41
  
  
    
      <td align="left">[% HTML.escape(row.notes) %]</td>


  		




  42
  
  
    
      <td align="left">[% HTML.escape(row.name) %]</td>


  		




  43
  
  
    
      <td align="left">[% HTML.escape(row.user) %]</td>


  		




  44
  
  
    
      <td align="left">[% HTML.escape(row.projectnumber) %]</td>


  		




  45
  
  
    
      <td align="left">[% HTML.escape(row.projectdescription) %]</td>


  		




  
  33
  
    
      <td>[% HTML.escape(row.acc_trans_id) %]</td>


  		




  
  34
  
    
      <td>[% HTML.escape(row.gldate) %]</td>


  		




  
  35
  
    
      <td>[% HTML.escape(row.transdate) %]</td>


  		




  
  36
  
    
      <td>[% HTML.escape(row.amount) %]</td>


  		




  
  37
  
    
      <td>[% HTML.escape(row.trans_id) %]</td>


  		




  
  38
  
    
      <td>[% HTML.escape(row.source) %]</td>


  		




  
  39
  
    
      <td>[% HTML.escape(row.reference) %]</td>


  		




  
  40
  
    
      <td>[% HTML.escape(row.description) %]</td>


  		




  
  41
  
    
      <td>[% HTML.escape(row.notes) %]</td>


  		




  
  42
  
    
      <td>[% HTML.escape(row.name) %]</td>


  		




  
  43
  
    
      <td>[% HTML.escape(row.user) %]</td>


  		




  
  44
  
    
      <td>[% HTML.escape(row.projectnumber) %]</td>


  		




  
  45
  
    
      <td>[% HTML.escape(row.projectdescription) %]</td>


  		




  46
  46
  
    
    </tr>


  		




  47
  47
  
    
    [% END %]


  		




  48
  48
  
    
  </table>


  		




  ......




  53
  53
  
    
  <p>[% 'Transactions without reference:' | $T8 %]</p>


  		




  54
  54
  
    
  <table>


  		




  55
  55
  
    
    <tr>


  		




  56
  
  
    
      <th class="listheading">[% 'Database ID' | $T8 %]</th>


  		




  57
  
  
    
      <th class="listheading">[% 'Gldate' | $T8 %]</th>


  		




  58
  
  
    
      <th class="listheading">[% 'Transdate' | $T8 %]</th>


  		




  59
  
  
    
      <th class="listheading">[% 'Amount' | $T8 %]</th>


  		




  60
  
  
    
      <th class="listheading">[% 'Source' | $T8 %]</th>


  		




  61
  
  
    
      <th class="listheading">[% 'Account Number' | $T8 %]</th>


  		




  62
  
  
    
      <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  63
  
  
    
      <th class="listheading">[% 'Account Type' | $T8 %]</th>


  		




  64
  
  
    
      <th class="listheading">[% 'Project Number' | $T8 %]</th>


  		




  65
  
  
    
      <th class="listheading">[% 'Project Description' | $T8 %]</th>


  		




  
  56
  
    
      <th>[% 'Database ID' | $T8 %]</th>


  		




  
  57
  
    
      <th>[% 'Gldate' | $T8 %]</th>


  		




  
  58
  
    
      <th>[% 'Transdate' | $T8 %]</th>


  		




  
  59
  
    
      <th>[% 'Amount' | $T8 %]</th>


  		




  
  60
  
    
      <th>[% 'Source' | $T8 %]</th>


  		




  
  61
  
    
      <th>[% 'Account Number' | $T8 %]</th>


  		




  
  62
  
    
      <th>[% 'Description' | $T8 %]</th>


  		




  
  63
  
    
      <th>[% 'Account Type' | $T8 %]</th>


  		




  
  64
  
    
      <th>[% 'Project Number' | $T8 %]</th>


  		




  
  65
  
    
      <th>[% 'Project Description' | $T8 %]</th>


  		




  66
  66
  
    
    </tr>


  		




  67
  67
  
    

  		




  68
  68
  
    
    [% SET row_odd = '1' %][% FOREACH row = NO_TRANS_ID %]


  		




  69
  69
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  70
  
  
    
      <td align="left">[% HTML.escape(row.acc_trans_id) %]</td>


  		




  71
  
  
    
      <td align="left">[% HTML.escape(row.gldate) %]</td>


  		




  72
  
  
    
      <td align="left">[% HTML.escape(row.transdate) %]</td>


  		




  73
  
  
    
      <td align="left">[% HTML.escape(row.amount) %]</td>


  		




  74
  
  
    
      <td align="left">[% HTML.escape(row.source) %]</td>


  		




  75
  
  
    
      <td align="left">[% HTML.escape(row.accno) %]</td>


  		




  76
  
  
    
      <td align="left">[% HTML.escape(row.description) %]</td>


  		




  77
  
  
    
      <td align="left">[% HTML.escape(row.category) %]</td>


  		




  78
  
  
    
      <td align="left">[% HTML.escape(row.projectnumber) %]</td>


  		




  79
  
  
    
      <td align="left">[% HTML.escape(row.projectdescription) %]</td>


  		




  
  70
  
    
      <td>[% HTML.escape(row.acc_trans_id) %]</td>


  		




  
  71
  
    
      <td>[% HTML.escape(row.gldate) %]</td>


  		




  
  72
  
    
      <td>[% HTML.escape(row.transdate) %]</td>


  		




  
  73
  
    
      <td>[% HTML.escape(row.amount) %]</td>


  		




  
  74
  
    
      <td>[% HTML.escape(row.source) %]</td>


  		




  
  75
  
    
      <td>[% HTML.escape(row.accno) %]</td>


  		




  
  76
  
    
      <td>[% HTML.escape(row.description) %]</td>


  		




  
  77
  
    
      <td>[% HTML.escape(row.category) %]</td>


  		




  
  78
  
    
      <td>[% HTML.escape(row.projectnumber) %]</td>


  		




  
  79
  
    
      <td>[% HTML.escape(row.projectdescription) %]</td>


  		




  80
  80
  
    
    </tr>


  		




  81
  81
  
    
    [% END %]


  		




  82
  82
  
    
  </table>


  		












  

    
      templates/webpages/dbupgrade/default_bin_parts.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  2
  
  
    
[%- USE HTML %]


  		




  3
  
  
    
[%- USE LxERP %]


  		




  4
  
  
    
[%- USE JavaScript %]


  		




  
  1
  
    
[% USE T8 %]


  		




  
  2
  
    
[% USE HTML %]


  		




  
  3
  
    
[% USE LxERP %]


  		




  
  4
  
    
[% USE JavaScript %]


  		




  5
  5
  
    
<h1>[% '<b>Default Bins Migration !READ CAREFULLY!</b>' | $T8 %]</h1>


  		




  6
  6
  
    

  		




  7
  7
  
    
 <script type="text/javascript" src="js/common.js"></script>


  		




  8
  8
  
    
 <script type="text/javascript">


  		




  9
  9
  
    
  <!--


  		




  10
  10
  
    
     warehouses = new Array();


  		




  11
  
  
    
     [%- USE WAREHOUSES_it = Iterator(WAREHOUSES) %][%- FOREACH warehouse = WAREHOUSES_it %]


  		




  
  11
  
    
     [% USE WAREHOUSES_it = Iterator(WAREHOUSES) %][% FOREACH warehouse = WAREHOUSES_it %]


  		




  12
  12
  
    
      warehouses[[% WAREHOUSES_it.count - 1 %]] = new Array();


  		




  13
  13
  
    
      warehouses[[% WAREHOUSES_it.count - 1 %]]['id'] = [% warehouse.id %];


  		




  14
  14
  
    
      warehouses[[% WAREHOUSES_it.count - 1 %]]['bins'] = new Array();


  		




  ......




  92
  92
  
    

  		




  93
  93
  
    

  		




  94
  94
  
    
<form name="Form" method="post" action="login.pl">


  		




  95
  
  
    
<input type="hidden" name="action" value="login">


  		




  96
  
  
    
<input type="hidden" name="continued" value="1">


  		




  
  95
  
    
  <input type="hidden" name="action" value="login">


  		




  
  96
  
    
  <input type="hidden" name="continued" value="1">


  		




  97
  97
  
    

  		




  98
  
  
    

  		




  99
  
  
    

  		




  100
  
  
    
<p>[% 'There are Bins defined in your Inventory.' | $T8 %]</p>


  		




  101
  
  
    
<p>[% 'The Bins in Inventory were only a information text field.' | $T8 %]</p>


  		




  102
  
  
    
<p>[% 'This has been changed in this version, therefore please change the "old" bins to some real warehouse bins.' | $T8 %]</p>


  		




  103
  
  
    
<p>[% 'If your old bins match exactly Bins in the Warehouse CLICK on <b>AUTOMATICALLY MATCH BINS</b>.' | $T8 %]</p>


  		




  104
  
  
    
<p>[% 'Otherwise you can simply check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue'  | $T8 %]</p>


  		




  105
  
  
    
<p>[% 'Empty selection for warehouse will not be added, even if the old bin is still visible (use back and forth to edit again).'  | $T8 %]</p>


  		




  
  98
  
    
  <p>[% 'There are Bins defined in your Inventory.' | $T8 %]</p>


  		




  
  99
  
    
  <p>[% 'The Bins in Inventory were only a information text field.' | $T8 %]</p>


  		




  
  100
  
    
  <p>[% 'This has been changed in this version, therefore please change the "old" bins to some real warehouse bins.' | $T8 %]</p>


  		




  
  101
  
    
  <p>[% 'If your old bins match exactly Bins in the Warehouse CLICK on <b>AUTOMATICALLY MATCH BINS</b>.' | $T8 %]</p>


  		




  
  102
  
    
  <p>[% 'Otherwise you can simply check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue'  | $T8 %]</p>


  		




  
  103
  
    
  <p>[% 'Empty selection for warehouse will not be added, even if the old bin is still visible (use back and forth to edit again).'  | $T8 %]</p>


  		




  106
  104
  
    

  		




  107
  105
  
    
<table>


  		




  
  106
  
    
<thead>


  		




  108
  107
  
    
  <tr>


  		




  109
  
  
    
    <th class="listheading">[% 'Partnumber' | $T8 %]</th>


  		




  110
  
  
    
    <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  111
  
  
    
    <th class="listheading">[% 'Bin' | $T8 %]</th>


  		




  112
  
  
    
    <th class="listheading">[% 'Default Warehouse' | $T8 %]</th>


  		




  113
  
  
    
    <th class="listheading">[% 'Default Bin' | $T8 %]</th>


  		




  114
  
  
    
  </tr>


  		




  115
  
  
    

  		




  116
  
  
    
  [% SET row_odd = '1' %][% FOREACH row = PARTS %]


  		




  117
  
  
    
  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  118
  
  
    
   <td align="left"> [% HTML.escape(row.partnumber) %]</a></td>


  		




  119
  
  
    
    <td align="left"> [% HTML.escape(row.description) %]</a></td>


  		




  120
  
  
    
    <td align="right">[% HTML.escape(row.bin) %]


  		




  121
  
  
    
    <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">


  		




  122
  
  
    
    </td>


  		




  123
  
  
    
    <td>


  		




  124
  
  
    
    <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>


  		




  125
  
  
    
     <select id="warehouse_id_[% loop.count %]" name="warehouse_id_[% loop.count %]" onchange="warehouse_selected(warehouses[this.selectedIndex]['id'], 0, [% loop.count %])">


  		




  126
  
  
    
             [%- FOREACH warehouse = WAREHOUSES %]


  		




  127
  
  
    
               <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id  == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>


  		




  128
  
  
    
             [%- END %]


  		




  129
  
  
    
                <option value=""  [% IF warehouse_id  == 0 %] selected[% END %] ></option>


  		




  130
  
  
    
     </select>


  		




  131
  
  
    
    </td>


  		




  132
  
  
    
    <td><select id="bin_id_[% loop.count %]" name="bin_id_[% loop.count %]"></select></td>


  		




  
  108
  
    
    <th>[% 'Partnumber' | $T8 %]</th>


  		




  
  109
  
    
    <th>[% 'Description' | $T8 %]</th>


  		




  
  110
  
    
    <th>[% 'Bin' | $T8 %]</th>


  		




  
  111
  
    
    <th>[% 'Default Warehouse' | $T8 %]</th>


  		




  
  112
  
    
    <th>[% 'Default Bin' | $T8 %]</th>


  		




  133
  113
  
    
  </tr>


  		




  134
  
  
    
  [% SET rowcount = loop.count %]


  		




  
  114
  
    
</thead>


  		




  
  115
  
    

  		




  
  116
  
    
  [% SET row_odd = '1' %]


  		




  
  117
  
    
  [% FOREACH row = PARTS %]


  		




  
  118
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  
  119
  
    
      <td> [% HTML.escape(row.partnumber) %]</a></td>


  		




  
  120
  
    
      <td> [% HTML.escape(row.description) %]</a></td>


  		




  
  121
  
    
      <td>


  		




  
  122
  
    
        [% HTML.escape(row.bin) %]


  		




  
  123
  
    
        <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">


  		




  
  124
  
    
      </td>


  		




  
  125
  
    
      <td>


  		




  
  126
  
    
        <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>


  		




  
  127
  
    
        <select id="warehouse_id_[% loop.count %]" name="warehouse_id_[% loop.count %]" onchange="warehouse_selected(warehouses[this.selectedIndex]['id'], 0, [% loop.count %])">


  		




  
  128
  
    
        [% FOREACH warehouse = WAREHOUSES %]


  		




  
  129
  
    
          <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id==warehouse.id %] selected[% END %]>[% warehouse.description %]</option>


  		




  
  130
  
    
        [% END %]


  		




  
  131
  
    
        <option value=""[% IF warehouse_id==0 %] selected[% END %]></option>


  		




  
  132
  
    
        </select>


  		




  
  133
  
    
      </td>


  		




  
  134
  
    
      <td><select id="bin_id_[% loop.count %]" name="bin_id_[% loop.count %]"></select></td>


  		




  
  135
  
    
    </tr>


  		




  
  136
  
    
    [% SET rowcount = loop.count %]


  		




  135
  137
  
    
  [% END %]


  		




  136
  
  
    
  <input type="hidden" name="rowcount" value="[% rowcount %]">


  		




  137
  
  
    
  <tr><td colspan="5"><hr/></td></tr>


  		




  138
  
  
    
  <tr><td colspan="5">


  		




  139
  
  
    
         <input type="checkbox" name="create_new_bins"> [% '<b>Automatically create new bins</b> in the following warehouse if not selected in the list above' | $T8 %]


  		




  140
  
  
    
          <select id="warehouse_id_default" name="warehouse_id_default">


  		




  141
  
  
    
             [%- FOREACH warehouse = WAREHOUSES %]


  		




  142
  
  
    
               <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id  == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>


  		




  143
  
  
    
             [%- END %]


  		




  144
  
  
    
                <option value=""  [% IF warehouse_id  == 0 %] selected[% END %] ></option>


  		




  145
  
  
    
         </select>


  		




  
  138
  
    
</table>


  		




  
  139
  
    
<input type="hidden" name="rowcount" value="[% rowcount %]">


  		




  
  140
  
    

  		




  
  141
  
    
<table class="tbl-horizontal">


  		




  
  142
  
    
  <caption>[% '' | $T8 %]</caption>


  		




  
  143
  
    
  <colgroup> <col class="wi-small"><col class="wi-lightwide"> </colgroup>


  		




  
  144
  
    
  <tbody>


  		




  
  145
  
    
    <tr>


  		




  
  146
  
    
      <th>[% '<b>Automatically create new bins</b> in the following warehouse if not selected in the list above' | $T8 %]</th>


  		




  
  147
  
    
      <td><<input type="checkbox" name="create_new_bins">/td>


  		




  
  148
  
    
    </tr>


  		




  
  149
  
    
    <tr>


  		




  
  150
  
    
      <th>[% '<b>Automatically create new bins</b> in the following warehouse if not selected in the list above' | $T8 %]</th>


  		




  
  151
  
    
      <td>


  		




  
  152
  
    
        <select id="warehouse_id_default" name="warehouse_id_default">


  		




  
  153
  
    
        [% FOREACH warehouse = WAREHOUSES %]


  		




  
  154
  
    
          <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id  == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>


  		




  
  155
  
    
        [% END %]


  		




  
  156
  
    
        <option value=""[% IF warehouse_id  == 0 %] selected[% END %] ></option>


  		




  
  157
  
    
        </select>


  		




  146
  158
  
    
      </td>


  		




  147
  
  
    
  </tr>


  		




  148
  
  
    

  		




  149
  
  
    
  <tr><td colspan="5"><hr/></td></tr>


  		




  150
  
  
    
 <tr><td><input type="button" class="submit" onclick="history.back()" value="[% 'Back' | $T8 %]"> </td><td colspan="3" align="center"><b><input style="background-color:#FFEE66" type="button" value="[% 'AUTOMATICALLY MATCH BINS' | $T8 %]"  onclick="bin_match([% rowcount %])"></b> </td><td><input type="submit" value="[% 'Continue' | $T8 %]"></td></tr>


  		




  
  159
  
    
    </tr>


  		




  
  160
  
    
  </tbody>


  		




  151
  161
  
    
</table>


  		




  
  162
  
    

  		




  
  163
  
    
<div class="buttons">


  		




  
  164
  
    
  <input type="button" onclick="history.back()" value="[% 'Back' | $T8 %]">


  		




  
  165
  
    
  <input style="background-color:#FFEE66" type="button" value="[% 'AUTOMATICALLY MATCH BINS' | $T8 %]" onclick="bin_match([% rowcount %])">


  		




  
  166
  
    
  <input type="submit" value="[% 'Continue' | $T8 %]">


  		




  
  167
  
    
</div>


  		




  
  168
  
    

  		




  152
  169
  
    
</form>


  		












  

    
      templates/webpages/dbupgrade/default_bin_parts_no_warehouse.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  2
  
  
    
[%- USE HTML %]


  		




  3
  
  
    
[%- USE LxERP %]


  		




  
  1
  
    
[% USE T8 %]


  		




  
  2
  
    
[% USE HTML %]


  		




  
  3
  
    
[% USE LxERP %]


  		




  4
  4
  
    
<h1>[% '<b>Default Bins Migration !READ CAREFULLY!</b>' | $T8 %]</h1>


  		




  5
  5
  
    

  		




  6
  6
  
    
<form name="Form" method="post" action="login.pl">


  		




  ......




  17
  17
  
    
<p>[% '<b> I DO CARE!</b> Please click back and cancel the update and come back after there has been at least one warehouse defined with bin(s).:' | $T8 %]</p>


  		




  18
  18
  
    
<p>[% '<b> I DO CARE!</b> Please check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue'  | $T8 %]</p>


  		




  19
  19
  
    

  		




  20
  
  
    
<table>


  		




  
  20
  
    
<table class="tbl-list">


  		




  
  21
  
    
<thead>


  		




  21
  22
  
    
  <tr>


  		




  22
  
  
    
    <th class="listheading">[% 'Partnumber' | $T8 %]</th>


  		




  23
  
  
    
    <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  24
  
  
    
    <th class="listheading">[% 'Master Data Bin Text Deleted' | $T8 %]</th>


  		




  
  23
  
    
    <th>[% 'Partnumber' | $T8 %]</th>


  		




  
  24
  
    
    <th>[% 'Description' | $T8 %]</th>


  		




  
  25
  
    
    <th>[% 'Master Data Bin Text Deleted' | $T8 %]</th>


  		




  25
  26
  
    
  </tr>


  		




  
  27
  
    
</thead>


  		




  26
  28
  
    

  		




  27
  
  
    
  [% SET row_odd = '1' %][% FOREACH row = PARTS %]


  		




  28
  
  
    
  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  29
  
  
    
   <td align="left"> [% HTML.escape(row.partnumber) %]</a></td>


  		




  30
  
  
    
    <td align="left"> [% HTML.escape(row.description) %]</a></td>


  		




  31
  
  
    
    <td align="right">[% HTML.escape(row.bin) %]


  		




  32
  
  
    
    <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>


  		




  33
  
  
    
    <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">


  		




  34
  
  
    
   </tr>


  		




  35
  
  
    
  [% SET rowcount = loop.count %]


  		




  
  29
  
    
<tbody>


  		




  
  30
  
    

  		




  
  31
  
    
  [% SET row_odd = '1' %]


  		




  
  32
  
    
  [% FOREACH row = PARTS %]


  		




  
  33
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  
  34
  
    
      <td>[% HTML.escape(row.partnumber) %]</a></td>


  		




  
  35
  
    
      <td>[% HTML.escape(row.description) %]</a></td>


  		




  
  36
  
    
      <td>


  		




  
  37
  
    
        [% HTML.escape(row.bin) %]


  		




  
  38
  
    
        <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>


  		




  
  39
  
    
        <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">


  		




  
  40
  
    
      </td>


  		




  
  41
  
    
    </tr>


  		




  
  42
  
    
    [% SET rowcount = loop.count %]


  		




  36
  43
  
    
  [% END %]


  		




  37
  44
  
    
  <input type="hidden" name="rowcount" value="[% rowcount %]">


  		




  38
  
  
    
<tr><td colspan="5"><hr/></td></tr>


  		




  39
  
  
    
<tr><td colspan="5"><input type="checkbox" name="create_new_bins"> [% '<b>Automatically create new bins</b> in the following new warehouse ' | $T8 %] <input type="text" name="new_warehouse"></td></tr>


  		




  40
  
  
    
<tr><td colspan="5"><hr/></td></tr>


  		




  41
  
  
    
<tr><td><input type="button" class="submit" onclick="history.back()" value="[% 'Back' | $T8 %]"> </td><td colspan="3" align="center"><td><input style="background-color:#FA1400" type="submit" value="[% 'Continue' | $T8 %]"></td></tr>


  		




  
  45
  
    

  		




  
  46
  
    
</tbody>


  		




  
  47
  
    
</table>


  		




  
  48
  
    

  		




  
  49
  
    
<table class="tbl-horizontal">


  		




  
  50
  
    
  <caption>[% 'New Bins' | $T8 %]</caption>


  		




  
  51
  
    
  <colgroup> <col class="wi-small"><col class="wi-lightwide"> </colgroup>


  		




  
  52
  
    
  <tbody>


  		




  
  53
  
    
    <tr>


  		




  
  54
  
    
      <th>[% 'Automatically create new bins' | $T8 %]</th>


  		




  
  55
  
    
      <td><input type="checkbox" name="create_new_bins"></td>


  		




  
  56
  
    
    </tr>


  		




  
  57
  
    
    <tr>


  		




  
  58
  
    
      <th>[% 'In the following new warehouse ' | $T8 %]</th>


  		




  
  59
  
    
      <td><input type="text" name="new_warehouse"></td>


  		




  
  60
  
    
    </tr>


  		




  
  61
  
    
  </tbody>


  		




  42
  62
  
    
</table>


  		




  
  63
  
    

  		




  
  64
  
    
<div class="buttons">


  		




  
  65
  
    
  <input type="button" onclick="history.back()" value="[% 'Back' | $T8 %]" class="neutral">


  		




  
  66
  
    
  <input type="submit" value="[% 'Continue' | $T8 %]">


  		




  
  67
  
    
</div>


  		




  
  68
  
    

  		




  43
  69
  
    
</form>


  		












  

    
      templates/webpages/dbupgrade/erzeugnisnummern.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  2
  
  
    
[% USE HTML %][%- USE LxERP -%]


  		




  
  1
  
    
[% USE T8 %]


  		




  
  2
  
    
[% USE HTML %]


  		




  
  3
  
    
[% USE LxERP %]


  		




  3
  4
  
    
<h1>[% 'Double partnumbers' | $T8 %]</h1>


  		




  4
  5
  
    

  		




  5
  6
  
    
<script type="text/javascript">


  		




  ......




  27
  28
  
    
<p>[% 'Please change the partnumber of the following parts and run the update again:' | $T8 %]</p>


  		




  28
  29
  
    
<table>


  		




  29
  30
  
    
  <tr>


  		




  30
  
  
    
    <th class="listheading">[% 'Partnumber' | $T8 %]</th>


  		




  31
  
  
    
    <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  32
  
  
    
    <th class="listheading">[% 'Unit' | $T8 %]</th>


  		




  33
  
  
    
    <th class="listheading">[% 'Notes' | $T8 %]</th>


  		




  34
  
  
    
    <th class="listheading">[% 'EAN' | $T8 %]</th>


  		




  35
  
  
    
    <th class="listheading">[% 'Service, assembly or part' | $T8 %]</th>


  		




  36
  
  
    
    <th class="listheading">[% 'Obsolete' | $T8 %]</th>


  		




  
  31
  
    
    <th>[% 'Partnumber' | $T8 %]</th>


  		




  
  32
  
    
    <th>[% 'Description' | $T8 %]</th>


  		




  
  33
  
    
    <th>[% 'Unit' | $T8 %]</th>


  		




  
  34
  
    
    <th>[% 'Notes' | $T8 %]</th>


  		




  
  35
  
    
    <th>[% 'EAN' | $T8 %]</th>


  		




  
  36
  
    
    <th>[% 'Service, assembly or part' | $T8 %]</th>


  		




  
  37
  
    
    <th>[% 'Obsolete' | $T8 %]</th>


  		




  37
  38
  
    
  </tr>


  		




  38
  39
  
    

  		




  39
  40
  
    
  [% SET row_odd = '1' %][% FOREACH row = PARTS %]


  		




  40
  41
  
    
  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  41
  
  
    
    <td align="right"><input name='partnumber_[% loop.count %]' value='[% HTML.escape(row.partnumber) %]'></td>


  		




  
  42
  
    
    <td><input type="text" name='partnumber_[% loop.count %]' value='[% HTML.escape(row.partnumber) %]'></td>


  		




  42
  43
  
    
    <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>


  		




  43
  
  
    
    <td align="left"> [% HTML.escape(row.description) %]</a></td>


  		




  44
  
  
    
    <td align="right">[% HTML.escape(row.unit) %]</td>


  		




  45
  
  
    
    <td align="right">[% HTML.escape(row.notes) %]</td>


  		




  46
  
  
    
    <td align="right">[% HTML.escape(row.ean) %]</td>


  		




  47
  
  
    
    <td align="right">[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' | $T8 %] [% END %] [% END %]</td>


  		




  48
  
  
    
    <td>[% IF row.obsolete %][%- LxERP.t8("Obsolete") %][%- ELSE %][%- LxERP.t8("Not obsolete") %][%- END %]</td>


  		




  
  44
  
    
    <td> [% HTML.escape(row.description) %]</a></td>


  		




  
  45
  
    
    <td>[% HTML.escape(row.unit) %]</td>


  		




  
  46
  
    
    <td>[% HTML.escape(row.notes) %]</td>


  		




  
  47
  
    
    <td>[% HTML.escape(row.ean) %]</td>


  		




  
  48
  
    
    <td>[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' | $T8 %] [% END %] [% END %]</td>


  		




  
  49
  
    
    <td>[% IF row.obsolete %][% LxERP.t8("Obsolete") %][% ELSE %][% LxERP.t8("Not obsolete") %][% END %]</td>


  		




  49
  50
  
    
  </tr>


  		




  50
  51
  
    
  [% SET rowcount = loop.count %]


  		




  51
  52
  
    
  [% END %]


  		












  

    
      templates/webpages/dbupgrade/footer.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  2
  
  
    
[% USE HTML %]<p>[% '...done' | $T8 %]</p>


  		




  
  1
  
    
[% USE T8 %]


  		




  
  2
  
    
[% USE HTML %]


  		




  3
  3
  
    

  		




  4
  
  
    
<form action="[% IF is_admin %]controller.pl[% ELSE %]login.pl[% END %]">


  		




  5
  
  
    

  		




  6
  
  
    
 <input type="hidden" name="action" value="[% IF is_admin %]Admin/apply_dbupgrade_scripts[% ELSE %]company_logo[% END %]">


  		




  
  4
  
    
<p>[% '...done' | $T8 %]</p>


  		




  7
  5
  
    

  		




  8
  
  
    
 <p><input type="submit" value="[% 'Continue' | $T8 %]"></p>


  		




  
  6
  
    
<form action="[% IF is_admin %]controller.pl[% ELSE %]login.pl[% END %]">


  		




  
  7
  
    
   <input type="hidden" name="action" value="[% IF is_admin %]Admin/apply_dbupgrade_scripts[% ELSE %]company_logo[% END %]">


  		




  
  8
  
    
   <div class="buttons"><input type="submit" value="[% 'Continue' | $T8 %]"></div>


  		




  9
  9
  
    
</form>


  		












  

    
      templates/webpages/dbupgrade/no_default_currency.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  
  1
  
    
[% USE T8 %]


  		




  2
  2
  
    
[% USE HTML %]


  		




  3
  3
  
    
<h1>[% 'No default currency' | $T8 %]</h1>


  		




  4
  4
  
    

  		












  

    
      templates/webpages/dbupgrade/orphaned_currencies.html
    
  





  10
  10
  
    
<p>[% 'There are undefined currencies in your system.' | $T8 %]</p>


  		




  11
  11
  
    
<p>[% 'The following currencies have been used, but they are not defined:' | $T8 %]</p>


  		




  12
  12
  
    
[% FOREACH row = ORPHANED_CURRENCIES %]


  		




  13
  
  
    
<input name="[% row.name %]" value="[% HTML.escape(row.curr) %]"><br>


  		




  
  13
  
    
<input type="text" name="[% row.name %]" value="[% HTML.escape(row.curr) %]"><br>


  		




  14
  14
  
    
<input type="hidden" name="old_[% row.name %]" value="[% HTML.escape(row.curr) %]">


  		




  15
  15
  
    
[% END %]


  		




  16
  16
  
    
<p>[% 'There are several options you can handle this problem, please select one:' | $T8 %]</p>


  		












  

    
      templates/webpages/dbupgrade/show_partlist.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  
  1
  
    
[% USE T8 %]


  		




  2
  2
  
    
[% USE L %]


  		




  3
  
  
    
[% USE HTML %][%- USE LxERP -%]


  		




  
  3
  
    
[% USE HTML %]


  		




  
  4
  
    
[% USE LxERP %]


  		




  4
  5
  
    
<h1>[% 'Show parts' | $T8 %]</h1>


  		




  5
  6
  
    

  		




  6
  7
  
    
<form method="post" action="controller.pl">


  		




  7
  
  
    
[% L.hidden_tag("action", "LoginScreen/login") %]


  		




  8
  
  
    
[% L.hidden_tag("upgrade_action", "filter_parts") %]


  		




  9
  
  
    
[% L.hidden_tag("no_layout", 1) %]


  		




  
  8
  
    
  [% L.hidden_tag("action", "LoginScreen/login") %]


  		




  
  9
  
    
  [% L.hidden_tag("upgrade_action", "filter_parts") %]


  		




  
  10
  
    
  [% L.hidden_tag("no_layout", 1) %]


  		




  10
  11
  
    

  		




  11
  
  
    
<table>


  		




  
  12
  
    
<table class="tbl-horizontal">


  		




  12
  13
  
    
  <tbody>


  		




  13
  14
  
    
    <tr>


  		




  14
  
  
    
      <th align="right">[% 'Partnumber' | $T8 %]</th>


  		




  
  15
  
    
      <th>[% 'Partnumber' | $T8 %]</th>


  		




  15
  16
  
    
      <td>[% L.input_tag("filter_partnumber", filter_partnumber, size=20) %]</td>


  		




  16
  17
  
    
    </tr>


  		




  17
  
  
    

  		




  18
  18
  
    
    <tr>


  		




  19
  
  
    
      <th align="right">[% 'Description' | $T8 %]</th>


  		




  
  19
  
    
      <th>[% 'Description' | $T8 %]</th>


  		




  20
  20
  
    
      <td>[% L.input_tag("filter_description", filter_description, size=20) %]</td>


  		




  21
  21
  
    
    </tr>


  		




  22
  
  
    

  		




  23
  22
  
    
    <tr>


  		




  24
  
  
    
      <th align="right">[% 'Notes' | $T8 %]</th>


  		




  
  23
  
    
      <th>[% 'Notes' | $T8 %]</th>


  		




  25
  24
  
    
      <td>[% L.input_tag("filter_notes", filter_notes, size=20) %]</td>


  		




  26
  25
  
    
    </tr>


  		




  27
  
  
    

  		




  28
  26
  
    
    <tr>


  		




  29
  
  
    
      <th align="right">[% 'EAN' | $T8 %]</th>


  		




  
  27
  
    
      <th>[% 'EAN' | $T8 %]</th>


  		




  30
  28
  
    
      <td>[% L.input_tag("filter_ean", filter_ean, size=20) %]</td>


  		




  31
  29
  
    
    </tr>


  		




  32
  
  
    

  		




  33
  30
  
    
    <tr>


  		




  34
  
  
    
      <th align="right">[% 'Service, assembly or part' | $T8 %]</th>


  		




  
  31
  
    
      <th>[% 'Service, assembly or part' | $T8 %]</th>


  		




  35
  32
  
    
      <td>


  		




  36
  33
  
    
        <select name="filter_type">


  		




  37
  34
  
    
          <option value=""></option>


  		




  ......




  41
  38
  
    
        </select>


  		




  42
  39
  
    
      </td>


  		




  43
  40
  
    
    </tr>


  		




  44
  
  
    

  		




  45
  41
  
    
    <tr>


  		




  46
  
  
    
      <th align="right">[% 'Valid/Obsolete' | $T8 %]</th>


  		




  
  42
  
    
      <th>[% 'Valid/Obsolete' | $T8 %]</th>


  		




  47
  43
  
    
      <td>


  		




  48
  44
  
    
        <select name="filter_obsolete">


  		




  49
  45
  
    
          <option value=""></option>


  		




  ......




  57
  53
  
    

  		




  58
  54
  
    
<input type="submit" value="[% 'Filter parts' | $T8 %]" onclick="submit()">


  		




  59
  55
  
    

  		




  60
  
  
    
<table>


  		




  
  56
  
    
<table class="tbl-list">


  		




  
  57
  
    
<thead>


  		




  61
  58
  
    
  <tr>


  		




  62
  
  
    
    <th class="listheading">[% 'Partnumber' | $T8 %]</th>


  		




  63
  
  
    
    <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  64
  
  
    
    <th class="listheading">[% 'Unit' | $T8 %]</th>


  		




  65
  
  
    
    <th class="listheading">[% 'Notes' | $T8 %]</th>


  		




  66
  
  
    
    <th class="listheading">[% 'EAN' | $T8 %]</th>


  		




  67
  
  
    
    <th class="listheading">[% 'Service, assembly or part' | $T8 %]</th>


  		




  68
  
  
    
    <th class="listheading">[% 'Obsolete' | $T8 %]</th>


  		




  
  59
  
    
    <th>[% 'Partnumber' | $T8 %]</th>


  		




  
  60
  
    
    <th>[% 'Description' | $T8 %]</th>


  		




  
  61
  
    
    <th>[% 'Unit' | $T8 %]</th>


  		




  
  62
  
    
    <th>[% 'Notes' | $T8 %]</th>


  		




  
  63
  
    
    <th>[% 'EAN' | $T8 %]</th>


  		




  
  64
  
    
    <th>[% 'Service, assembly or part' | $T8 %]</th>


  		




  
  65
  
    
    <th>[% 'Obsolete' | $T8 %]</th>


  		




  69
  66
  
    
  </tr>


  		




  70
  
  
    

  		




  71
  
  
    
  [% SET row_odd = '1' %][% FOREACH row = ALL_PARTS %]


  		




  72
  
  
    
  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  73
  
  
    
    <td align="right">[% HTML.escape(row.partnumber) %]</td>


  		




  74
  
  
    
    <td align="left"> [% HTML.escape(row.description) %]</a></td>


  		




  75
  
  
    
    <td align="right">[% HTML.escape(row.unit) %]</td>


  		




  76
  
  
    
    <td align="right">[% HTML.escape(row.notes) %]</td>


  		




  77
  
  
    
    <td align="right">[% HTML.escape(row.ean) %]</td>


  		




  78
  
  
    
    <td align="right">[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' | $T8 %] [% END %] [% END %]</td>


  		




  79
  
  
    
    <td>[% IF row.obsolete %][%- LxERP.t8("Obsolete") %][%- ELSE %][%- LxERP.t8("Not obsolete") %][%- END %]</td>


  		




  
  67
  
    
</thead>


  		




  
  68
  
    
<tbody>


  		




  
  69
  
    
  [% SET row_odd = '1' %]


  		




  
  70
  
    
  [% FOREACH row = ALL_PARTS %]


  		




  
  71
  
    
  <tr>


  		




  
  72
  
    
    <td>[% HTML.escape(row.partnumber) %]</td>


  		




  
  73
  
    
    <td> [% HTML.escape(row.description) %]</a></td>


  		




  
  74
  
    
    <td>[% HTML.escape(row.unit) %]</td>


  		




  
  75
  
    
    <td>[% HTML.escape(row.notes) %]</td>


  		




  
  76
  
    
    <td>[% HTML.escape(row.ean) %]</td>


  		




  
  77
  
    
    <td>[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' | $T8 %] [% END %] [% END %]</td>


  		




  
  78
  
    
    <td>[% IF row.obsolete %][% LxERP.t8("Obsolete") %][% ELSE %][% LxERP.t8("Not obsolete") %][% END %]</td>


  		




  80
  79
  
    
  </tr>


  		




  81
  80
  
    
  [% END %]


  		




  
  81
  
    
</tbody>


  		




  82
  82
  
    
</table>


  		




  83
  83
  
    

  		




  84
  
  
    
<input class="submit" type="button" value="[% 'Close window' | $T8 %]" onclick="window.close()">


  		




  
  84
  
    
<div class="buttons">


  		




  
  85
  
    
  <input type="button" value="[% 'Close window' | $T8 %]" onclick="window.close()">


  		




  
  86
  
    
</div>


  		




  85
  87
  
    

  		




  86
  88
  
    
</form>


  		












  

    
      templates/webpages/dbupgrade/steuerfilterung.html
    
  





  14
  14
  
    
<p>[% 'Please choose for which categories the taxes should be displayed (otherwise remove the ticks):' | $T8 %]</p>


  		




  15
  15
  
    
<table>


  		




  16
  16
  
    
  <tr>


  		




  17
  
  
    
    <th class="listheading">[% 'Taxkey' | $T8 %]</th>


  		




  18
  
  
    
    <th class="listheading">[% 'Description' | $T8 %]</th>


  		




  19
  
  
    
    <th class="listheading">[% 'Tax rate' | $T8 %]</th>


  		




  20
  
  
    
    <th class="listheading">[% 'Asset' | $T8 %] (A)</th>


  		




  21
  
  
    
    <th class="listheading">[% 'Liability' | $T8 %] (L)</th>


  		




  22
  
  
    
    <th class="listheading">[% 'Equity' | $T8 %] (Q)</th>


  		




  23
  
  
    
    <th class="listheading">[% 'Costs' | $T8 %] (C)</th>


  		




  24
  
  
    
    <th class="listheading">[% 'Revenue' | $T8 %] (I)</th>


  		




  25
  
  
    
    <th class="listheading">[% 'Expense' | $T8 %] (E)</th>


  		




  
  17
  
    
    <th>[% 'Taxkey' | $T8 %]</th>


  		




  
  18
  
    
    <th>[% 'Description' | $T8 %]</th>


  		




  
  19
  
    
    <th>[% 'Tax rate' | $T8 %]</th>


  		




  
  20
  
    
    <th>[% 'Asset' | $T8 %] (A)</th>


  		




  
  21
  
    
    <th>[% 'Liability' | $T8 %] (L)</th>


  		




  
  22
  
    
    <th>[% 'Equity' | $T8 %] (Q)</th>


  		




  
  23
  
    
    <th>[% 'Costs' | $T8 %] (C)</th>


  		




  
  24
  
    
    <th>[% 'Revenue' | $T8 %] (I)</th>


  		




  
  25
  
    
    <th>[% 'Expense' | $T8 %] (E)</th>


  		




  26
  26
  
    
  </tr>


  		




  27
  27
  
    

  		




  28
  28
  
    
  [% SET row_odd = '1' %][% FOREACH row = PARTS %]


  		




  29
  29
  
    
  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  30
  
  
    
    <td align="right">[% HTML.escape(row.taxkey) %]</td>


  		




  31
  
  
    
    <td align="left"> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  32
  
  
    
    <td align="right">[% HTML.escape(row.rate) %] %</td>


  		




  33
  
  
    
    <td align="center">[% L.checkbox_tag('asset_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  34
  
  
    
    <td align="center">[% L.checkbox_tag('liability_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  35
  
  
    
    <td align="center">[% L.checkbox_tag('equity_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  36
  
  
    
    <td align="center">[% L.checkbox_tag('costs_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  37
  
  
    
    <td align="center">[% L.checkbox_tag('revenue_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  38
  
  
    
    <td align="center">[% L.checkbox_tag('expense_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  30
  
    
    <td>[% HTML.escape(row.taxkey) %]</td>


  		




  
  31
  
    
    <td> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  
  32
  
    
    <td>[% HTML.escape(row.rate) %] %</td>


  		




  
  33
  
    
    <td>[% L.checkbox_tag('asset_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  34
  
    
    <td>[% L.checkbox_tag('liability_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  35
  
    
    <td>[% L.checkbox_tag('equity_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  36
  
    
    <td>[% L.checkbox_tag('costs_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  37
  
    
    <td>[% L.checkbox_tag('revenue_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  
  38
  
    
    <td>[% L.checkbox_tag('expense_' _ loop.count, value => 1, checked => 1, class => 'checkbox') %]</td>


  		




  39
  39
  
    
  </tr>


  		




  40
  40
  
    
  <input type="hidden" name="tax_id_[% loop.count %]" value="[% row.tax_id %]">


  		




  41
  41
  
    
  [% SET rowcount = loop.count %]


  		












  

    
      templates/webpages/dbupgrade/tax_constraints.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  
  1
  
    
[% USE T8 %]


  		




  2
  2
  
    
[% USE HTML %]


  		




  3
  3
  
    
<h1>[% 'Inconsistency in database' | $T8 %]</h1>


  		




  4
  4
  
    

  		




  ......




  13
  13
  
    
  <p>[% 'Please set another taxnumber for the following taxes and run the update again:' | $T8 %]</p>


  		




  14
  14
  
    
  <table>


  		




  15
  15
  
    
    <tr>


  		




  16
  
  
    
      <th class="listheading">[% 'tax_taxkey' | $T8 %]</th>


  		




  17
  
  
    
      <th class="listheading">[% 'tax_taxdescription' | $T8 %]</th>


  		




  18
  
  
    
      <th class="listheading">[% 'tax_rate' | $T8 %]</th>


  		




  
  16
  
    
      <th>[% 'tax_taxkey' | $T8 %]</th>


  		




  
  17
  
    
      <th>[% 'tax_taxdescription' | $T8 %]</th>


  		




  
  18
  
    
      <th>[% 'tax_rate' | $T8 %]</th>


  		




  19
  19
  
    
    </tr>


  		




  20
  20
  
    

  		




  21
  21
  
    
    [% SET row_odd = '1' %][% FOREACH row = TAX %]


  		




  22
  22
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  23
  
  
    
      <td align="right">[% HTML.escape(row.taxkey) %]</td>


  		




  24
  
  
    
      <td align="left"> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  25
  
  
    
      <td align="right">[% HTML.escape(row.rate) %] %</td>


  		




  
  23
  
    
      <td>[% HTML.escape(row.taxkey) %]</td>


  		




  
  24
  
    
      <td> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  
  25
  
    
      <td>[% HTML.escape(row.rate) %] %</td>


  		




  26
  26
  
    
    </tr>


  		




  27
  27
  
    
    [% END %]


  		




  28
  28
  
    
  </table>


  		




  ......




  34
  34
  
    
  <p>[% 'Please define a taxkey for the following taxes and run the update again:' | $T8 %]</p>


  		




  35
  35
  
    
  <table>


  		




  36
  36
  
    
    <tr>


  		




  37
  
  
    
      <th class="listheading">[% 'tax_taxdescription' | $T8 %]</th>


  		




  38
  
  
    
      <th class="listheading">[% 'tax_rate' | $T8 %]</th>


  		




  39
  
  
    
      <th class="listheading">[% 'taxnumber' | $T8 %]</th>


  		




  40
  
  
    
      <th class="listheading">[% 'account_description' | $T8 %]</th>


  		




  
  37
  
    
      <th>[% 'tax_taxdescription' | $T8 %]</th>


  		




  
  38
  
    
      <th>[% 'tax_rate' | $T8 %]</th>


  		




  
  39
  
    
      <th>[% 'taxnumber' | $T8 %]</th>


  		




  
  40
  
    
      <th>[% 'account_description' | $T8 %]</th>


  		




  41
  41
  
    
    </tr>


  		




  42
  42
  
    

  		




  43
  43
  
    
    [% SET row_odd = '1' %][% FOREACH row = TAX %]


  		




  44
  44
  
    
    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">


  		




  45
  
  
    
      <td align="left"> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  46
  
  
    
      <td align="right">[% HTML.escape(row.rate) %] %</td>


  		




  47
  
  
    
      <td align="right">[% HTML.escape(row.taxnumber) %]</td>


  		




  
  45
  
    
      <td> [% HTML.escape(row.taxdescription) %]</a></td>


  		




  
  46
  
    
      <td>[% HTML.escape(row.rate) %] %</td>


  		




  
  47
  
    
      <td>[% HTML.escape(row.taxnumber) %]</td>


  		




  48
  48
  
    
      <td>[% HTML.escape(row.account_description) %]</td>


  		




  49
  49
  
    
    </tr>


  		




  50
  50
  
    
    [% END %]


  		












  

    
      templates/webpages/dbupgrade/warehouse_form.html
    
  





  15
  15
  
    
 <input id="do_migrate_N" name="do_migrate" type="radio" value="N" checked>&nbsp;<label for="do_migrate_N">[% 'No' | $T8 %]</label>


  		




  16
  16
  
    

  		




  17
  17
  
    
 <p>[% 'Please specify a description for the warehouse designated for these goods.' | $T8 %]</p>


  		




  18
  
  
    
 <input name="import_warehouse" size="50">


  		




  
  18
  
    
 <input type="text" name="import_warehouse" size="50">


  		




  19
  19
  
    

  		




  20
  20
  
    
 <p>[% 'Since bin is not enforced in the parts data, please specify a bin where goods without a specified bin will be put.' | $T8 %]<p>


  		




  21
  21
  
    

  		




  22
  
  
    
  <input name="bin_default" size="50">


  		




  
  22
  
    
  <input type="text" name="bin_default" size="50">


  		




  23
  23
  
    

  		




  24
  24
  
    
 <p><input type="submit" value="[% 'Continue' | $T8 %]"></p>


  		




  25
  25
  
    
</form>


  		












  

    
      templates/webpages/dbupgrade/warning.html
    
  





  1
  
  
    
[%- USE T8 %]


  		




  2
  
  
    
[%- USE HTML %]


  		




  3
  
  
    
[%- USE LxERP %][%- USE L -%]


  		




  4
  
  
    
<form name="Form" method="post" action="controller.pl">


  		




  5
  
  
    

  		




  6
  
  
    
 <input type="hidden" name="action" value="LoginScreen/login">


  		




  7
  
  
    
 <p><input type="button" class="submit" onclick="history.back()" value="[% 'Back' | $T8 %]"></p>


  		




  8
  
  
    
 <p class="message_hint">


  		




  9
  
  
    
  [% LxERP.t8('kivitendo is about to update the database [ #1 ].', dbname) | html %]


  		




  10
  
  
    
 </p>


  		




  
  1
  
    
[% USE T8 %]


  		




  
  2
  
    
[% USE HTML %]


  		




  
  3
  
    
[% USE LxERP %]


  		




  
  4
  
    
[% USE L %]


  		




  11
  5
  
    

  		




  12
  
  
    
 [% IF superuser.need_privileges && !superuser.have_privileges %]


  		




  13
  
  
    
  <p>


  		




  14
  
  
    
   [% LxERP.t8("Database superuser privileges are required for the update.") %]


  		




  15
  
  
    
   [% LxERP.t8("Please provide corresponding credentials.") %]


  		




  16
  
  
    
  </p>


  		




  
  6
  
    
<form name="Form" method="post" action="controller.pl">


  		




  17
  7
  
    

  		




  18
  
  
    
  [% IF superuser.error %]


  		




  19
  
  
    
   <p>[% LxERP.t8("Error: #1", superuser.error) %]</p>


  		




  
  8
  
    
  <input type="hidden" name="action" value="LoginScreen/login">


  		




  
  9
  
    

  		




  
  10
  
    
  <div class="buttons"><input type="button" onclick="history.back()" value="[% 'Back' | $T8 %]" class="neutral"></div>


  		




  
  11
  
    
  <p class="message message_hint"> [% LxERP.t8('kivitendo is about to update the database [ #1 ].', dbname) | html %] </p>


  		




  
  12
  
    

  		




  
  13
  
    
  [% IF superuser.need_privileges && !superuser.have_privileges %]


  		




  
  14
  
    
    <p>


  		




  
  15
  
    
     [% LxERP.t8("Database superuser privileges are required for the update.") %]


  		




  
  16
  
    
     [% LxERP.t8("Please provide corresponding credentials.") %]


  		




  
  17
  
    
    </p>


  		




  
  18
  
    

  		




  
  19
  
    
    [% IF superuser.error %]


  		




  
  20
  
    
      <p>[% LxERP.t8("Error: #1", superuser.error) %]</p>


  		




  
  21
  
    
    [% END %]


  		




  
  22
  
    

  		




  
  23
  
    
    <table class="tbl-horizontal">


  		




  
  24
  
    
      <tbody>


  		




  
  25
  
    
        <tr>


  		




  
  26
  
    
           <th>[% LxERP.t8("User name") %]:</th>


  		




  
  27
  
    
           <td>[% L.input_tag("database_superuser_username", superuser.username) %]</td>


  		




  
  28
  
    
        </tr>


  		




  
  29
  
    
        <tr>


  		




  
  30
  
    
           <th>[% LxERP.t8("Password") %]:</th>


  		




  
  31
  
    
           <td>[% L.input_tag("database_superuser_password", superuser.password, type="password") %]</td>


  		




  
  32
  
    
        </tr>


  		




  
  33
  
    
      </tbody>


  		




  
  34
  
    
    </table>


  		




  20
  35
  
    
  [% END %]


  		




  21
  36
  
    

  		




  22
  
  
    
  <table border="0">


  		




  23
  
  
    
   <tr>


  		




  24
  
  
    
    <td>[% LxERP.t8("User name") %]:</td>


  		




  25
  
  
    
    <td>[% L.input_tag("database_superuser_username", superuser.username) %]</td>


  		




  26
  
  
    
   </tr>


  		




  
  37
  
    
  <p>[% 'You should create a backup of the database before proceeding because the backup might not be reversible.' | $T8 %] </p>


  		




  
  38
  
    
  <div class="buttons"><input type="submit" name="dummy" value="[% 'Continue' | $T8 %]"></div>


  		




  27
  39
  
    

  		




  28
  
  
    
   <tr>


  		




  29
  
  
    
    <td>[% LxERP.t8("Password") %]:</td>


  		




  30
  
  
    
    <td>[% L.input_tag("database_superuser_password", superuser.password, type="password") %]</td>


  		




  31
  
  
    
   </tr>


  		




  32
  
  
    
  </table>


  		




  33
  
  
    
 [% END %]


  		




  34
  
  
    

  		




  35
  
  
    
 <p>


  		




  36
  
  
    
  [% 'You should create a backup of the database before proceeding because the backup might not be reversible.' | $T8 %]


  		




  37
  
  
    
 </p>


  		




  38
  
  
    

  		




  39
  
  
    
 <input type="submit" name="dummy" value="[% 'Continue' | $T8 %]">


  		




  40
  40
  
    
</form>


  		




  41
  41
  
    

  		




  42
  
  
    
<p id="nodetails">


  		




  43
  
  
    
 <a href="#" onclick="$('#details,#nodetails').toggle();">[% LxERP.t8('Show details') %]</a>


  		




  44
  
  
    
</p>


  		




  45
  
  
    

  		




  46
  
  
    
<div id="details" style="display: none;">


  		




  47
  
  
    
 <p>


  		




  48
  
  
    
  <a href="#" onclick="$('#details,#nodetails').toggle();">[% LxERP.t8('Hide details') %]</a>


  		




  49
  
  
    
 </p>


  		




  50
  
  
    

  		




  51
  
  
    
 <p>


  		




  52
  
  
    
  [% LxERP.t8("List of database upgrades to be applied:") %]


  		




  53
  
  
    
 </p>


  		




  54
  
  
    

  		




  55
  
  
    
 <ul>


  		




  56
  
  
    
  [% FOREACH upgrade_script = unapplied_scripts %]


  		




  57
  
  
    
   <li>[% HTML.escape(upgrade_script.tag) %]: [% HTML.escape(upgrade_script.description) %]</li>


  		




  58
  
  
    
  [% END %]


  		




  59
  
  
    
 </ul>


  		




  
  42
  
    
<div id="nodetails" class="filter_toggle">


  		




  
  43
  
    
  <a href="#" onclick="$('#details,#nodetails').toggle();" class="button toggle off neutral">[% LxERP.t8('Show details') %]</a>


  		




  60
  44
  
    
</div>


  		




  
  45
  
    
<div id="details" style="display: none;" class="filter_toggle">


  		




  
  46
  
    
  <a href="#" onclick="$('#details,#nodetails').toggle();" class="button toggle on neutral with-panel">[% LxERP.t8('Hide details') %]</a> </p>


  		




  
  47
  
    
  <div class="filter-toggle-panel">


  		




  
  48
  
    
    <p> [% LxERP.t8("List of database upgrades to be applied:") %] </p>


  		




  
  49
  
    
    <ul>


  		




  
  50
  
    
      [% FOREACH upgrade_script = unapplied_scripts %]


  		




  
  51
  
    
        <li>[% HTML.escape(upgrade_script.tag) %]: [% HTML.escape(upgrade_script.description) %]</li>


  		




  
  52
  
    
      [% END %]


  		




  
  53
  
    
    </ul>


  		




  
  54
  
    
  </div><!-- /.filter-toggle-panel -->


  		




  
  55
  
    
</div>


  		




  
  56
  
    

  		












Auch abrufbar als:  Unified diff