$title

#!/usr/bin/perl -w # NAME: chkvisa.txt # AIM: VERY SPECIALISED - Read a visa account file, and show totals use strict; use warnings; use File::Basename; # split path ($name,$dir,$ext) = fileparse($file [, qr/\.[^.]*/] ) use Cwd; my $os = $^O; my $perl_dir = '/home/geoff/bin'; my $PATH_SEP = '/'; my $temp_dir = '/tmp'; if ($os =~ /win/i) { $perl_dir = 'C:\GTools\perl'; $temp_dir = $perl_dir; $PATH_SEP = "\\"; } unshift(@INC, $perl_dir); require 'lib_utils.pl' or die "Unable to load 'lib_utils.pl' Check paths in \@INC...\n"; # log file stuff our ($LF); my $pgmname = $0; if ($pgmname =~ /(\\|\/)/) { my @tmpsp = split(/(\\|\/)/,$pgmname); $pgmname = $tmpsp[-1]; } my $outfile = $temp_dir.$PATH_SEP."temp.$pgmname.txt"; open_log($outfile); # user variables my $VERS = "0.0.6 2018-07-09"; ##my $VERS = "0.0.5 2015-01-09"; my $load_log = 0; my $in_file = ''; my $verbosity = 0; my $out_file = $temp_dir.$PATH_SEP."tempvtable.html"; # my $out_file = ''; # 1 Hong Kong Dollar equals my $euro = 0.11; # Euro # ### DEBUG ### my $debug_on = 1; my $def_file = 'C:\Users\user\Documents\MISC\SCB\temp1.txt'; ###my $def_file = 'C:\Users\user\Documents\MISC\SCB\Acct-027-20151018.txt'; ### program variables my @warnings = (); my $cwd = cwd(); sub VERB1() { return $verbosity >= 1; } sub VERB2() { return $verbosity >= 2; } sub VERB5() { return $verbosity >= 5; } sub VERB9() { return $verbosity >= 9; } sub show_warnings($) { my ($val) = @_; if (@warnings) { prt( "\nGot ".scalar @warnings." WARNINGS...\n" ); foreach my $itm (@warnings) { prt("$itm\n"); } prt("\n"); } else { prt( "\nNo warnings issued.\n\n" ) if (VERB9()); } } sub pgm_exit($$) { my ($val,$msg) = @_; if (length($msg)) { $msg .= "\n" if (!($msg =~ /\n$/)); prt($msg); } show_warnings($val); close_log($outfile,$load_log); exit($val); } sub prtw($) { my ($tx) = shift; $tx =~ s/\n$//; prt("$tx\n"); push(@warnings,$tx); } sub get_html_head($) { my $title = shift; my $txt = < $title EOF return $txt; } sub get_table_head() { my $line = "Transaction Date"; my $line2 = "Particulars"; my $line3 = "HK\$"; my $col4 = "Euro ($euro)"; my $html = "\n"; $html .= "$line\n"; $html .= "$line2\n"; $html .= "$line3\n"; $html .= "$col4\n"; $html .= "\n"; return $html; } sub process_in_file($) { my ($inf) = @_; if (! open INF, "<$inf") { pgm_exit(1,"ERROR: Unable to open file [$inf]\n"); } my @lines = ; close INF; my $lncnt = scalar @lines; prt("Processing $lncnt lines, from [$inf]...\n"); my ($line,$inc,$lnn,$ln,$len,$cnt,$intable,$line2,$line3,$ln2,$ln3); my ($day,$month,$year,@arr,$amt); $lnn = 0; $intable = 0; my $total = 0; my $avbal = 0; my $outbal = 0; my $lastbal = 0; my $limit = 0; my @rows = (); for ($ln = 0; $ln < $lncnt; $ln++) { $lnn = $ln + 1; $ln2 = $ln + 1; $ln3 = $ln + 2; last if ( !($ln3 < $lncnt) ); $line = $lines[$ln]; chomp $line; $line = trim_all($line); $len = length($line); next if ($len == 0); if ($intable) { if ($line =~ /^(\d{2})\/(\d{2})\/(\d{4})/) { $day = $1; $month = $2; $year = $3; } else { next; } } else { if ($line =~ /Available Balance/) { # * : 2,892.05 @arr = split(":",$line); $cnt = scalar @arr; if ($cnt == 2) { $amt = trim_all($arr[1]); $amt =~ s/,//g; $avbal = $amt; prt("$lnn: Avail $avbal\n"); } } elsif ($line =~ /Outstanding Balance/) { # : 44,652.71 @arr = split(":",$line); $cnt = scalar @arr; if ($cnt == 2) { $amt = trim_all($arr[1]); $amt =~ s/,//g; $outbal = $amt; prt("$lnn: Out $outbal\n"); } } elsif ($line =~ /Last Statement Balance/) { # : 25,663.00 @arr = split(":",$line); $cnt = scalar @arr; if ($cnt == 2) { $amt = trim_all($arr[1]); $amt =~ s/,//g; $lastbal = $amt; prt("$lnn: Last $lastbal\n"); } } } $line2 = $lines[$ln2]; chomp $line2; $line2 = trim_all($line2); $line3 = $lines[$ln3]; chomp $line3; $line3 = trim_all($line3); if ($intable) { push(@rows, [ $line, $line2, $line3 ]); prt("$lnn: $line $line2 $line3\n"); $line3 =~ s/,//g; $total += $line3; $ln += 2; } else { if (($line =~ /^Transaction Date/)&&($line2 =~ /Particulars/)&&($line3 =~ /Amount/)) { prt("$lnn: $line $line2 $line3\n"); $intable = 1; $ln += 2; next; } } } $limit = $total + $lastbal + $avbal; prt("Got total $total $limit 50000\n"); $cnt = scalar @rows; my $html = ''; if ($cnt) { my ($ra,$hk,$eu); foreach $ra (@rows) { $line = ${$ra}[0]; $line2 = ${$ra}[1]; $line3 = ${$ra}[2]; $html .= "\n"; $html .= "$line\n"; $html .= "$line2\n"; $html .= "$line3\n"; $hk = $line3; $hk =~ s/,//g; $eu = $hk * $euro; $eu = int($eu * 100) / 100; $html .= "$eu\n"; $html .= "\n"; } my $h = get_html_head("$cnt Transactions"); $h .= "\n"; $h .= "

Lists of $cnt transactions from $inf

\n"; $h .= "\n"; $h .= get_table_head(); $h .= $html; $h .= "

\n"; $h .= "

Total $total, of $cnt transactions, from $inf

\n"; $h .= "\n"; $h .= "\n"; $h .= "\n"; if (length($out_file)) { write2file($h,$out_file); prt("Table written to '$out_file'\n"); } else { prt($h); } } } ######################################### ### MAIN ### parse_args(@ARGV); process_in_file($in_file); pgm_exit(0,""); ######################################## sub need_arg { my ($arg,@av) = @_; pgm_exit(1,"ERROR: [$arg] must have a following argument!\n") if (!@av); } sub parse_args { my (@av) = @_; my ($arg,$sarg); my $verb = VERB2(); while (@av) { $arg = $av[0]; if ($arg =~ /^-/) { $sarg = substr($arg,1); $sarg = substr($sarg,1) while ($sarg =~ /^-/); if (($sarg =~ /^h/i)||($sarg eq '?')) { give_help(); pgm_exit(0,"Help exit(0)"); } elsif ($sarg =~ /^v/) { if ($sarg =~ /^v.*(\d+)$/) { $verbosity = $1; } else { while ($sarg =~ /^v/) { $verbosity++; $sarg = substr($sarg,1); } } $verb = VERB2(); prt("Verbosity = $verbosity\n") if ($verb); } elsif ($sarg =~ /^l/) { if ($sarg =~ /^ll/) { $load_log = 2; } else { $load_log = 1; } prt("Set to load log at end. ($load_log)\n") if ($verb); } elsif ($sarg =~ /^o/) { need_arg(@av); shift @av; $sarg = $av[0]; $out_file = $sarg; prt("Set out file to [$out_file].\n") if ($verb); } else { pgm_exit(1,"ERROR: Invalid argument [$arg]! Try -?\n"); } } else { $in_file = $arg; prt("Set input to [$in_file]\n") if ($verb); } shift @av; } if ($debug_on) { prtw("WARNING: DEBUG is ON!\n"); if (length($in_file) == 0) { $in_file = $def_file; prt("Set DEFAULT input to [$in_file]\n"); #$load_log = 1; } } if (length($in_file) == 0) { pgm_exit(1,"ERROR: No input files found in command!\n"); } if (! -f $in_file) { pgm_exit(1,"ERROR: Unable to find in file [$in_file]! Check name, location...\n"); } } sub give_help { prt("$pgmname: version $VERS\n"); prt("Usage: $pgmname [options] in-file\n"); prt("Options:\n"); prt(" --help (-h or -?) = This help, and exit 0.\n"); prt(" --verb[n] (-v) = Bump [or set] verbosity. def=$verbosity\n"); prt(" --load (-l) = Load LOG at end. ($outfile)\n"); prt(" --out (-o) = Write output to this file.\n"); } # eof - template.pl