Update-Script für constraints in der acc_trans

[kivitendo-erp.git] / templates / webpages / dbupgrade / acc_trans_constraints.html

diff --git a/templates/webpages/dbupgrade/acc_trans_constraints.html b/templates/webpages/dbupgrade/acc_trans_constraints.html
new file mode 100644 (file)
index 0000000..389b1d0
--- /dev/null
+++ b/templates/webpages/dbupgrade/acc_trans_constraints.html
@@ -0,0 +1,89 @@
+[%- USE T8 %]
+[%- USE L %]
+[% USE HTML %]<div class="listtop">[% 'Invalid transactions' | $T8 %]</div>
+
+<form name="Form" method="post" action="login.pl">
+<input type="hidden" name="action" value="login">
+
+<p>[% 'There are invalid transactions in your database.' | $T8 %]</p>
+<p>[% 'The following transactions are concerned:' | $T8 %]</p>
+
+[% IF no_chart_id %]
+  <p>[% 'Transactions without account:' | $T8 %]</p>
+  <table>
+    <tr>
+      <th class="listheading">[% 'Database ID' | $T8 %]</th>
+      <th class="listheading">[% 'Booking Date' | $T8 %]</th>
+      <th class="listheading">[% 'Invoice Date' | $T8 %]</th>
+      <th class="listheading">[% 'Amount' | $T8 %]</th>
+      <th class="listheading">[% 'Buchungsnummer' | $T8 %]</th>
+      <th class="listheading">[% 'Source' | $T8 %]</th>
+      <th class="listheading">[% 'Reference / Invoice Number' | $T8 %]</th>
+      <th class="listheading">[% 'Description' | $T8 %]</th>
+      <th class="listheading">[% 'Notes' | $T8 %]</th>
+      <th class="listheading">[% 'Employee' | $T8 %]</th>
+      <th class="listheading">[% 'User' | $T8 %]</th>
+      <th class="listheading">[% 'Project Number' | $T8 %]</th>
+      <th class="listheading">[% 'Project Description' | $T8 %]</th>
+    </tr>
+
+    [% SET row_odd = '1' %][% FOREACH row = NO_CHART_ID %]
+    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">
+      <td align="left">[% HTML.escape(row.acc_trans_id) %]</td>
+      <td align="left">[% HTML.escape(row.gldate) %]</td>
+      <td align="left">[% HTML.escape(row.transdate) %]</td>
+      <td align="left">[% HTML.escape(row.amount) %]</td>
+      <td align="left">[% HTML.escape(row.trans_id) %]</td>
+      <td align="left">[% HTML.escape(row.source) %]</td>
+      <td align="left">[% HTML.escape(row.reference) %]</td>
+      <td align="left">[% HTML.escape(row.description) %]</td>
+      <td align="left">[% HTML.escape(row.notes) %]</td>
+      <td align="left">[% HTML.escape(row.name) %]</td>
+      <td align="left">[% HTML.escape(row.user) %]</td>
+      <td align="left">[% HTML.escape(row.projectnumber) %]</td>
+      <td align="left">[% HTML.escape(row.projectdescription) %]</td>
+    </tr>
+    [% END %]
+  </table>
+
+[% END %]
+
+[% IF no_trans_id %]
+  <p>[% 'Transactions without reference:' | $T8 %]</p>
+  <table>
+    <tr>
+      <th class="listheading">[% 'Database ID' | $T8 %]</th>
+      <th class="listheading">[% 'Booking Date' | $T8 %]</th>
+      <th class="listheading">[% 'Invoice Date' | $T8 %]</th>
+      <th class="listheading">[% 'Amount' | $T8 %]</th>
+      <th class="listheading">[% 'Source' | $T8 %]</th>
+      <th class="listheading">[% 'Account Number' | $T8 %]</th>
+      <th class="listheading">[% 'Description' | $T8 %]</th>
+      <th class="listheading">[% 'Account Type' | $T8 %]</th>
+      <th class="listheading">[% 'Project Number' | $T8 %]</th>
+      <th class="listheading">[% 'Project Description' | $T8 %]</th>
+    </tr>
+
+    [% SET row_odd = '1' %][% FOREACH row = NO_TRANS_ID %]
+    <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">
+      <td align="left">[% HTML.escape(row.acc_trans_id) %]</td>
+      <td align="left">[% HTML.escape(row.gldate) %]</td>
+      <td align="left">[% HTML.escape(row.transdate) %]</td>
+      <td align="left">[% HTML.escape(row.amount) %]</td>
+      <td align="left">[% HTML.escape(row.source) %]</td>
+      <td align="left">[% HTML.escape(row.accno) %]</td>
+      <td align="left">[% HTML.escape(row.description) %]</td>
+      <td align="left">[% HTML.escape(row.category) %]</td>
+      <td align="left">[% HTML.escape(row.projectnumber) %]</td>
+      <td align="left">[% HTML.escape(row.projectdescription) %]</td>
+    </tr>
+    [% END %]
+  </table>
+
+[% END %]
+
+<p>[% 'This is a very critical problem.' | $T8 %]</p>
+<p>[% 'Please contact your administrator or a service provider.' | $T8 %]</p>
+<p><a href="http://www.kivitendo.de/partner.html" target="_blank">[% 'Here' | $T8 %]</a> [% 'you can find professional help.' | $T8 %]</p>
+
+</form>