summaryrefslogtreecommitdiff
path: root/locale
diff options
context:
space:
mode:
Diffstat (limited to 'locale')
-rwxr-xr-xlocale/html/splash.html1
-rwxr-xr-xlocale/splash.html1
2 files changed, 2 insertions, 0 deletions
diff --git a/locale/html/splash.html b/locale/html/splash.html
index 9ba76a09..5eed3837 100755
--- a/locale/html/splash.html
+++ b/locale/html/splash.html
@@ -6,6 +6,7 @@
<title>LedgerSMB Splash page</title>
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
+ <meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="../../favicon.ico" type="image/x-icon" />
<link rel="stylesheet" href="../../css/ledger-smb.css" type="text/css" title="LedgerSMB stylesheet" />
<meta name="robots" content="noindex,nofollow" />
diff --git a/locale/splash.html b/locale/splash.html
index 18719b5c..77ac2686 100755
--- a/locale/splash.html
+++ b/locale/splash.html
@@ -6,6 +6,7 @@
<title>LedgerSMB Splash page</title>
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
+ <meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="../../favicon.ico" type="image/x-icon" />
<link rel="stylesheet" href="../../css/ledger-smb.css" type="text/css" title="LedgerSMB stylesheet" />
<meta name="robots" content="noindex,nofollow" />
generated by cgit v1.2.3 (git 2.46.0) at 2025-06-02 09:48:51 +0000
ate,
  • batch_class text
  • );
  • CREATE OR REPLACE FUNCTION voucher_list (in_batch_id integer)
  • RETURNS SETOF voucher_list AS
  • $$
  • declare voucher_item record;
  • BEGIN
  • FOR voucher_item IN
  • SELECT v.id, a.invnumber, e.name,
  • v.batch_id, v.trans_id,
  • a.amount, a.transdate, 'Payable'
  • FROM voucher v
  • JOIN ap a ON (v.trans_id = a.id)
  • JOIN entity e ON (a.entity_id = e.id)
  • WHERE v.batch_id = in_batch_id
  • AND v.batch_class = (select id from batch_class
  • WHERE class = 'ap')
  • UNION
  • SELECT v.id, a.invnumber, e.name,
  • v.batch_id, v.trans_id,
  • a.amount, a.transdate, 'Receivable'
  • FROM voucher v
  • JOIN ar a ON (v.trans_id = a.id)
  • JOIN entity e ON (a.entity_id = e.id)
  • WHERE v.batch_id = in_batch_id
  • AND v.batch_class = (select id from batch_class
  • WHERE class = 'ar')
  • UNION ALL
  • -- TODO: Add the class labels to the class table.
  • SELECT v.id, a.source,
  • cr.meta_number || '--' || co.legal_name ,
  • v.batch_id, v.trans_id,
  • CASE WHEN bc.class LIKE 'payment%' THEN a.amount * -1
  • ELSE a.amount END, a.transdate,
  • CASE WHEN bc.class = 'payment' THEN 'Payment'
  • WHEN bc.class = 'payment_reversal'
  • THEN 'Payment Reversal'
  • END
  • FROM voucher v
  • JOIN acc_trans a ON (v.id = a.voucher_id)
  • JOIN batch_class bc ON (bc.id = v.batch_class)
  • JOIN chart c ON (a.chart_id = c.id)
  • JOIN ap ON (ap.id = a.trans_id)
  • JOIN entity_credit_account cr
  • ON (ap.entity_credit_account = cr.id)
  • JOIN company co ON (cr.entity_id = co.entity_id)
  • WHERE v.batch_id = in_batch_id
  • AND a.voucher_id = v.id
  • AND (bc.class like 'payment%' AND c.link = 'AP')
  • UNION ALL
  • SELECT v.id, a.source, a.memo,
  • v.batch_id, v.trans_id,
  • CASE WHEN bc.class LIKE 'receipt%' THEN a.amount * -1
  • ELSE a.amount END, a.transdate,
  • CASE WHEN bc.class = 'receipt' THEN 'Receipt'
  • WHEN bc.class = 'receipt_reversal'
  • THEN 'Receipt Reversal'
  • END
  • FROM voucher v
  • JOIN acc_trans a ON (v.trans_id = a.trans_id)