Revision 9dfede04
Von Hans Peter Schlaepfer vor fast 6 Jahren hinzugefügt
| 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> <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
Neues kivitendo Design Aenderungen in templates/webpages/dbupgrade/..