styles and translations ledgers

[confetti] / ledgers / account.sh

diff --git a/ledgers/account.sh b/ledgers/account.sh
index a92694ffee0cd9801a79001b413f5851a6d6ed00..9d3329936e08d25ee74c3248b7bff216bd913fb1 100755 (executable)
--- a/ledgers/account.sh
+++ b/ledgers/account.sh
@@ -1,25 +1,58 @@
 #!/bin/sh
 
-if [ "$REQUEST_METHOD" = POST ]; then
-  uid="$(POST uid)"
+credit() {
+  printf '%+04i\n' "$1" \
+  | sed -E 's;[0-9]{2}$;d&;; :0 s;([0-9])([0-9]{3}[dm]);\1m\2;; t0; y;dm;,.;'
+}
+
+if uid="$(POST uid)"; then
   cfile="$(grep -lxF "UID;:${uid}" "${_DATA}/vcard/"*.vcf || grep -lxF "UID:${uid}" "${_DATA}/vcard/"*.vcf)"
   REDIRECT "${_BASE}/ledgers/account.sh?card=${cfile##*/}"
 fi
 
+. "${_EXEC}/cgilite/storage.sh"
 . "${_EXEC}/pdiread.sh"
 . "${_EXEC}/cards/l10n.sh"
 . "${_EXEC}/cards/widgets.sh"
+. "${_EXEC}/datetime.sh"
 
-cardfile="${_DATA}/vcard/$(GET card |PATH)"
-if [ ! -f "$cardfile" ]; then
+cardfile="$(GET card |PATH)" cardfile="${cardfile##*/}"
+if [ ! -f "${_DATA}/vcard/$cardfile" ]; then
   SET_COOKIE 0 message="Invalid account: $cardfile"
   REDIRECT "${_BASE}/ledgers/"
 fi
 
-{ card="$(pdi_load "$cardfile")"
+cledger="${_DATA}/ledgers/vcf.${cardfile%.vcf}.account"
+
+if tid="$(POST tid)"; then
+  if [ "$tid" != "$(transid "$cledger")" ]; then
+    SET_COOKIE 0 message="Ledger was changed since last edit"
+    REDIRECT "$REQUEST_URI"
+  fi
+  tdate="$(isdate "$(POST tdate)")"
+  tref="$(POST tref |grep -m1 -xE '.+')"
+  tamount="$(POST tamount \
+             | sed -E '
+             s;^([\+-]?[0-9]+)[\.,]([0-9][0-9])$;\1\2;;
+             s;^([\+-]?[0-9]+)$;&00;;
+           ' | grep -m1 -xE '[\+-]?[0-9]+')"
+  # debug "TDATE: $tdate TREF: $tref AMOUNT: $tamount"
+  if ! [ "$tdate" -a "$tref" -a "$tamount" ]; then
+    SET_COOKIE 0 message="Transaction info invalid"
+    REDIRECT "$REQUEST_URI"
+  fi
+  tdtstamp="$(date -ud "$tdate" +%s)"
+  printf '%s   %i      %s      \       %s      %i\n' \
+         "${tdate}" "${tdtstamp}" "$(STRING "${cardfile%.vcf}")" \
+         "$(STRING "$tref")" "${tamount}" \
+         >>"${cledger}"
+  REDIRECT "$REQUEST_URI"
+fi
+
+{ card="$(pdi_load "${_DATA}/vcard/$cardfile")"
   cat <<-EOF
        [h1 $(l10n Payments)]
-       [div .card #${cardfile##*/}
+       [div .card #${cardfile}
          [div .section .basic . $(
            card_item "$card" FN GENDER NICKNAME BDAY X-ZACK-JOINDATE X-ZACK-LEAVEDATE SOUND PHOTO LOGO
          )]
@@ -28,7 +61,7 @@ fi
          [div .section .address . $(card_item "$card" ADR X-IBAN)]
          [div .section .note    . $(card_item "$card" NOTE)]
          [div .section .attendance [h3 $(l10n course_attendance) ] [ul
-           $(grep -F "     ${cardfile##*/}" "$_DATA/mappings/attendance" |while read each discard; do
+           $(grep -F " ${cardfile}" "$_DATA/mappings/attendance" |while read each discard; do
              printf '[li [a .item .attendance href="%s/courses#%s" . %s]]' \
                     "${_BASE}" "$each" \
                     "$(pdi_value "$(pdi_load "$_DATA/ical/$each")" SUMMARY || l10n "(unnamed course)" |unescape |HTML)"
@@ -36,19 +69,58 @@ fi
            $(card_item "$card" CATEGORIES)
          ]
        ]
-       [ul .transactions
-       $(cnt="$(pdi_count "$card" X-IBAN)"
-         while [ "$cnt" -gt 0 ]; do
-           pdi_value X-IBAN "$cnt" |RXLITERAL
-           cnt=$((cnt - 1))
-         done \
-         | while read -r iban; do
-            printf '[li . '
-            grep -E "^[^\t]+   [^\t]+  ${iban} " |HTML
-            printf ']'
-         done
-       )]
        EOF
-  
+  cat <<-EOF
+       [form method=POST
+         [hidden "tid" "$(transid "${cledger}")"]
+         [table .transactions
+           [thead [tr
+             [th .date . $(l10n Date)][th .orig . $(l10n Originator)]
+             [th .reference . $(l10n "Reference Text")]
+             [th .amount . $(l10n Amount)][th .balance . $(l10n Balance)]
+           ]]
+           [tbody
+       EOF
+  cnt="$(pdi_count "$card" X-IBAN)"
+  { while [ "$cnt" -gt 0 ]; do
+      pdi_value "$card" X-IBAN "$cnt" |RXLITERAL
+      cnt=$((cnt - 1))
+    done
+    RXLITERAL "${cardfile%.vcf}"; echo
+  } |debug \
+  | while read -r iban; do
+    grep -hE "^[^\t]+  [^\t]+  ${iban} " "${_DATA}/ledgers/"*
+  done \
+  | sort -n -k2 \
+  | { total=0
+    while read -r date dtstamp iban accname reftext amount; do
+      total=$((total + amount))
+      if [ "$iban" = "${cardfile%.vcf}" ]; then
+        printf '[tr [td .date . %s][td .orig [span . %s][span . %s]][td .reference . %s]
+                [td .amount . %s][td .balance . %s]]' \
+               "$date" "$(l10n "Credit Account")" \
+               "$(UNSTRING "$accname" |HTML)" "$(UNSTRING "$reftext" |HTML)" \
+               "$(credit "$amount")" "$(credit "$total")"
+      else
+        printf '[tr [td .date . %s][td .orig [span . %s][span . %s]][td .reference . %s]
+                [td .amount . %s][td .balance . %s]]' \
+               "$date" "$(HTML "$iban")" \
+               "$(UNSTRING "$accname" |HTML)" "$(UNSTRING "$reftext" |HTML)" \
+               "$(credit "$amount")" "$(credit "$total")"
+      fi
+    done
+  }
+  cat <<-EOF
+       [tr [th colspan=5 . $(l10n 'Manual Record')]]
+       [tr [td .date
+              [input type=date placeholder="$(l10n Date)" name=tdate value="$(date +%F)"]
+             [input type=checkbox id=rr_month name=recur value=monthly]
+             [label for=rr_month $(l10n Recur Monthly)]
+           ][td .orig ]
+           [td .reference . [textarea placeholder="$(l10n "Reference Text")" name=tref]]
+           [td .amount [input type=number placeholder="$(l10n Amount)" name=tamount value=0.00 step=.01]]
+           [td .balance [button type=submit . $(l10n Submit)]]
+       ]]]]
+       EOF
 } \
 | yield_page ledgers