src

sauce
got clone ssh://anon@src.dalliard.ch/src
log | files | refs

genreport.sh (875B)

      1 #!/bin/sh
      2 file=~/prv/txs
      3 
      4 cur_year=$(date +%Y)
      5 cur_inc=$(grep -E "$cur_year.*business.*inc" "$file" | awk -F ',' '{sum+=$2} END {print sum}')
      6 cur_exp=$(grep -E "$cur_year.*business.*exp" "$file" | awk -F ',' '{sum+=$2} END {print sum}')
      7 cur_tot=$(echo "$cur_inc" + "$cur_exp" | bc -l)
      8 
      9 prev_year=$(echo "$cur_year" - 1 | bc)
     10 prev_inc=$(grep -E "$prev_year.*business.*inc" "$file" | awk -F ',' '{sum+=$2} END {print sum}')
     11 prev_exp=$(grep -E "$prev_year.*business.*exp" "$file" | awk -F ',' '{sum+=$2} END {print sum}')
     12 prev_tot=$(echo "$prev_inc" + "$prev_exp" | bc -l)
     13 
     14 echo '{
     15   "prev": {
     16     "prev_inc": "'$prev_inc'",
     17     "prev_exp": "'$prev_exp'",
     18     "prev_tot": "'$prev_tot'",
     19     "prev_year": "'$prev_year'"
     20   },
     21   "cur": {
     22     "cur_inc": "'$cur_inc'",
     23     "cur_exp": "'$cur_exp'",
     24     "cur_tot": "'$cur_tot'",
     25     "cur_year": "'$cur_year'"
     26   }
     27 }' > data/report.json