=head1 NAME Finance::Bank::IE::PermanentTSB - Perl Interface to the PermanentTSB Open24 homebanking on L =head1 DESCRIPTION This is a set of functions that can be used in your Perl code to perform some operations with a Permanent TSB homebanking account. Features: =over =item * B: retrieves the balance for all the accounts you have set up (current account, visa card, etc.) =item * B: retrieves the statement for a particular account, in a range of date. =item * B (to be implemented): top up your mobile phone! =item * B (to be implemented): transfer money between your accounts or third party accounts. =back =cut package Finance::Bank::IE::PermanentTSB; our $VERSION = '0.4'; use strict; use warnings; use Data::Dumper; use WWW::Mechanize; use HTML::TokeParser; use Carp qw(croak carp); use Date::Calc qw(check_date Delta_Days); use base 'Exporter'; # export by default the check_balance function and the constants our @EXPORT = qw(check_balance ALL WITHDRAWAL DEPOSIT VISA_ACCOUNT SWITCH_ACCOUNT); our @EXPORT_OK = qw(mobile_topup account_statement); my %cached_cfg; my $agent; my $lastop = 0; my $BASEURL = "https://www.open24.ie/"; my $error = 0; =head1 CONSTANTS The constants below are used with the account_statement() function: =over =item * C: shortcut for (WITHDRAWAL and DEPOSIT); =item * C: shows only the WITHDRAWALs; =item * C: shows only the DEPOSITs; =item * C: the account refers to a Visa Card; =item * C: the account is a normal Current Account; =back =cut # constant to be used with the account_statement() function use constant { # statement types ALL => 0, # prints all the transactions # (WITHDRAWAL and DEPOSIT) WITHDRAWAL => 1, # shows only the WITHDRAWALs DEPOSIT => 2, # shows only the DEPOSITs # account types VISA_ACCOUNT => 'Visa Card', # visa card account SWITCH_ACCOUNT => 'Switch Current A/C', # switch current account }; =head1 METHODS / FUNCTIONS Every function in this module requires, as the first argument, a reference to an hash which contains the configuration: my %config = ( "open24numba" => "your open24 number", "password" => "your internet password", "pan" => "your personal access number", "debug" => 1, ); =head2 C<$boolean = login($config_ref)> - B B This function performs the login. It takes just one required argument, which is an hash reference for the configuration. The function returns true (1) if success or undef for any other state. If debug => 1 then it will dump the html page on the current working directory. Please be aware that this has a security risk. The information will persist on your filesystem until you reboot your machine (and /var/tmp get clean at boot time). =cut sub login { my $self = shift; my $config_ref = shift; my $content; $config_ref ||= \%cached_cfg; my $croak = ($config_ref->{croak} || 1); for my $reqfield ("open24numba", "password", "pan") { if (! defined( $config_ref->{$reqfield})) { if ($croak) { carp("$reqfield not there!"); return undef; } else { carp("$reqfield not there!"); return undef; } } } if(!defined($agent)) { $agent = WWW::Mechanize->new( env_proxy => 1, autocheck => 1, keep_alive => 10); $agent->env_proxy; $agent->quiet(0); $agent->agent('Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.12) Gecko/20071126 Fedora/1.5.0.12-7.fc6 Firefox/1.5.0.12' ); my $jar = $agent->cookie_jar(); $jar->{hide_cookie2} = 1; $agent->add_header('Accept' => 'text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5'); $agent->add_header('Accept-Language' => 'en-US,en;q=0.5'); $agent->add_header( 'Accept-Charset' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' ); $agent->add_header( 'Accept-Encoding' => 'gzip,deflate' ); } else { # simple check to see if the login is live # this based on Waider Finance::Bank::IE::BankOfIreland.pm! if ( time - $lastop < 60 ) { carp "Last operation 60 seconds ago, reusing old session" if $config_ref->{debug}; $lastop = time; return 1; } my $res = $agent->get( $BASEURL . '/online/Account.aspx' ); if ( $res->is_success ) { $content = $agent->content; if($agent->content =~ /ACCOUNT SUMMARY/is) { $lastop = time; carp "Short-circuit: session still valid" if $config_ref->{debug}; return 1; } } carp "Session has timed out, redoing login" if $config_ref->{debug}; } # retrieve the login page my $res = $agent->get($BASEURL . '/online/login.aspx'); $agent->save_content('./loginpage.html') if $config_ref->{debug}; # something wrong? if(!$res->is_success) { carp("Unable to get page!"); return undef; } # 2nd agent->content call $content = $agent->content; if($content =~ /Interruption Page/is) { carp "Cannot authenticate on Open24.ie: site mantainance"; $error = 1; return undef; } # page not found? if($content =~ /Page Not Found/is) { carp("HTTP ERROR 404: Page Not Found"); return undef; } # Login - Step 1 of 2 $agent->field('txtLogin', $config_ref->{open24numba}); $agent->field('txtPassword', $config_ref->{password}); # PermanentTSB website sucks... # there's no normal submit button, the "continue" button is a # link # that launches a Javascript function. This function sets # the __EVENTTARGET to 'lbtnContinue'. Here we are simulating this # bypassing the Javascript code :) $agent->field('__EVENTTARGET', 'lbtnContinue'); $res = $agent->submit(); # something wrong? if(!$res->is_success) { carp("Unable to get page!"); return undef; } $agent->save_content("./step1_result.html") if $config_ref->{debug}; # 3rd agent->content call $content = $agent->content; # Login - Step 2 of 2 if($content !~ /LOGIN STEP 2 OF 2/is) { carp("Problem 1 while authenticating!\nPlease don't retry ". "this 3 times in a row or you account will be locked!"); return undef; } else { if($content !~ /txtDigit/is) { carp("Problem 2 while authenticating!\nPlease don't retry ". "this 3 times in a row or you account will be locked!"); return undef; } print $content if($config_ref->{debug}); set_pan_fields($agent, $config_ref); $res = $agent->submit(); $agent->save_content("./step2_pan_result.html") if $config_ref->{debug}; print $content if($config_ref->{debug}); } return 1; } =head2 C - B B This is used for the second step of the login process. The web interface ask you to insert 3 of the 6 digits that form the PAN code. The PAN is a secret code that only the PermanentTSB customer knows. If your PAN code is 123234 and the web interface is asking for this: =over =item Digit no. 2: =item Digit no. 5: =item Digit no. 6: =back The function will fill out the form providing 2,3,4 respectively. This function doesn't return anything. =cut sub set_pan_fields { my $agent = shift; my $config_ref = shift; # 4th agent->content call my $p = HTML::TokeParser->new(\$agent->content()); # convert the pan string into an array my @pan_digits = (); my @pan_arr = split('',$config_ref->{pan}); # look for with ids "lblDigit1", "lblDigit2" and "lblDigit3" # and build an array # the PAN, Personal Access Number is formed by 6 digits. while (my $tok = $p->get_tag("span")){ if(defined $tok->[1]{id}) { if($tok->[1]{id} =~ m/lblDigit[123]/) { my $text = $p->get_trimmed_text("/span"); # normally the webpage shows Digit No. x # where x is the position of the digit inside # the PAN number assigne by the bank to the owner of the # account # here we are building the @pan_digits array push @pan_digits, $pan_arr[substr($text,10)-1]; } } } $agent->field('txtDigitA', $pan_digits[0]); $agent->field('txtDigitB', $pan_digits[1]); $agent->field('txtDigitC', $pan_digits[2]); $agent->field('__EVENTTARGET', 'btnContinue'); } =head2 C<@accounts_balance = check_balance($config_ref)> - B This function require the configuration hash reference as argument. It returns an reference to an array of hashes, one hash for each account. In case of error it return undef; Each hash has these keys: =over =item * 'accname': account name, i.e. "Switch Current A/C". =item * 'accno': account number. An integer representing the last 4 digits of the account. =item * 'accbal': account balance. In EURO. =back Here is an example: $VAR1 = { 'availbal' => 'euro amount', 'accno' => '0223', 'accbal' => 'euro amount', 'accname' => 'Switch Current A/C' }; $VAR2 = { 'availbal' => 'euro amount', 'accno' => '2337', 'accbal' => 'euro amount', 'accname' => 'Visa Card' }; The array can be printed using, for example, a foreach loop like this one: foreach my $acc (@$balance) { printf ("%s ending with %s: %s\n", $acc->{'accname'}, $acc->{'accno'}, $acc->{'accbal'} ); } =cut sub check_balance { my $self = shift; my $config_ref = shift; my $res; $config_ref ||= \%cached_cfg; my $croak = ($config_ref->{croak} || 1); $self->login($config_ref) or return undef; my $p = HTML::TokeParser->new(\$agent->content()); my $i = 0; my @array; my $hash_ref = {}; while (my $tok = $p->get_tag("td")){ if(defined $tok->[1]{style}) { if($tok->[1]{style} eq 'width:25%;') { my $text = $p->get_trimmed_text("/td"); if($i == 0) { $hash_ref = {}; $hash_ref->{'accname'} = $text; } if($i == 1) { $hash_ref->{'accno'} = $text; } if($i == 2) { $hash_ref->{'accbal'} = $text; } if($i == 3) { $hash_ref->{'availbal'} = $text; } $i++; if($i == 4) { $i = 0; push @array, $hash_ref; } } } } return \@array; } =head2 C<@account_statement = account_statement($config_ref, $acc_type, $acc_no, $from, $to, [$type])> - B This function requires 4 mandatory arguments, the 5th is optional. =over =item 1. B<$config_ref>: the hash reference to the configuration =item 2. B<$acc_type>: this is a constant: can be VISA_ACCOUNT or SWITCH_ACCOUNT =item 3. B<$acc_no>: this is a 4 digits field representing the last 4 digits of the account number (or Visa card number) =item 4. B<$from>: from date, in format dd/mm/yyyy =item 5. B<$to>: to date, in format dd/mm/yyyy =item 6. B<$type> (optional): type of statement (optional). Default: ALL. It can be WITHDRAWAL, DEPOSIT or ALL. =back The function returns an reference to an array of hashes, one hash for each row of the statement. The array of hashes can be printed using, for example, a foreach loop like this one: foreach my $row (@$statement) { printf("%s | %s | %s | %s \n", $row->{date}, $row->{description}, $row->{euro_amount}, $row->{balance}); } Undef is returned in case of error; =cut sub account_statement { my ($self, $config_ref, $acc_type, $acc_no, $from, $to, $type) = @_; my ($res, @ret_array); $config_ref ||= \%cached_cfg; my $croak = ($config_ref->{croak} || 1); if(defined $acc_type) { if($acc_type ne SWITCH_ACCOUNT and $acc_type ne VISA_ACCOUNT) { carp("Account type is invalid"); return undef; } } else { carp("Account type not defined"); return undef; } if(not defined $acc_no) { carp("Account number not defined."); return undef; } my $account = $acc_type." - ".$acc_no; if(defined $from and defined $to) { # $from should be > of $to my @d_from = split "/", $from; my @d_to = split "/", $to; if (Delta_Days($d_from[0],$d_from[1],$d_from[2], $d_to[0],$d_to[1],$d_to[2]) <= 0) { carp("Date range $from -> $to invalid."); return undef; } # check date_from, date_to foreach my $date ($from, $to) { # date should be in format yyyy/mm/dd if(not $date =~ /^\d{4}\/\d{2}\/\d{2}$/) { carp("Date $date should be in format 'yyyy/mm/dd'"); return undef; } # date should be valid, this is using Date::Calc->check_date() my @d = split "/", $date; if (not check_date($d[0],$d[1],$d[2])) { carp("Date $date is not valid!"); return undef; } } } else { carp("Date range not defined"); return undef; } if(defined $account) { if(not $account =~ m/.+ - \d{4}$/) { carp("$account is invalid"); return undef; } } # verify if the account exists inside the homebanking my $acc = $self->check_balance($config_ref); if(not defined $acc) { return undef; } my $found = 0; foreach my $c (@$acc) { if($account eq $c->{'accname'}." - ".$c->{'accno'}) { $found = 1; last; } } if($found) { $self->login($config_ref) or return undef; # go to the Statement page $res = $agent->get($BASEURL . '/online/Statement.aspx'); $agent->save_content("./statement_page.html") if $config_ref->{debug}; $agent->field('ddlAccountName', $account); $agent->field('__EVENTTARGET', 'lbtnShow'); $res = $agent->submit(); # something wrong? if(!$res->is_success) { carp("Unable to get page!"); return undef; } $agent->save_content("./statement_page2.html") if $config_ref->{debug}; # fill out the "from" date my @d = split "/", $from; $agent->field('ddlFromDay', $d[2]); $agent->field('ddlFromMonth', $d[1]); $agent->field('ddlFromYear', $d[0]); # fill out the "to" date @d = split "/", $to; $agent->field('ddlToDay', $d[2]); $agent->field('ddlToMonth', $d[1]); $agent->field('ddlToYear', $d[0]); if(defined $type) { $agent->field('grpTransType', 'rbWithdrawal') if($type == WITHDRAWAL); $agent->field('grpTransType', 'rbDeposit') if($type == DEPOSIT); } $agent->field('__EVENTTARGET', 'lbtnShow'); $res = $agent->submit(); # something wrong? if(!$res->is_success) { carp("Unable to get page!"); return undef; } $agent->save_content("./statement_page1.html") if $config_ref->{debug}; my $content = $agent->content; # PermanentTSB doesn't support statements that include data # older than 6 months... in this case the interface will reset # to the default date range. We just need to print an warning # and submit the current form as is if($content =~ /YOU HAVE REQUESTED DATA OLDER THAN 6 MONTHS/is) { carp("PermanentTSB doesn't support queries older than 6". " months! Resetting to the default date."); $agent->field('__EVENTTARGET', 'lbtnShow'); $res = $agent->submit(); if(!$res->is_success) { carp("Unable to get page!"); return undef; } $agent->save_content("./statement_res_after_6months.html") if $config_ref->{debug}; } if($content =~ /INCORRECT DATE CRITERIA ENTERED: 'TO DATE' WAS IN THE FUTURE./is) { carp("Incorrect date criteria entered: 'to date' was in the". " future! Resetting to the default date. "); } # parse output page clicking "next" button until the # button "another statement" is present. all the data must # be inserted into an array of hashes. # the array should contain an hash per row. # every hash contains [date, description, euro_amount, balance] my $hash_ref = {}; my $visa = 0; my $page = 1; my $i = 1; while (1) { my $p = HTML::TokeParser->new(\$agent->content()); while (my $tok = $p->get_tag('table')) { if(defined $tok->[1]{id}) { if($tok->[1]{id} eq 'tblTransactions'){ while(my $tok2 = $p->get_tag('tr')) { $hash_ref = {}; my $text = $p->get_trimmed_text('/tr'); #TODO: improve regexp! # this matches the html row # dd/mm/yyyy description [-/+] amount balance [-/+] # example -> 29/09/2008 DUNNES STEPHEN 29/09 - 45.00 25000.00 + if($text =~ /^(\d{2}\/\d{2}\/\d{4}) (.+) ([-\+] [\d\.]+) ([\d\.]+ [-\+])$/) { # this is a normal current account # statement $hash_ref->{date} = $1; $hash_ref->{description} = $2; $hash_ref->{euro_amount} = $3; $hash_ref->{balance} = $4; $hash_ref->{euro_amount} =~ s/\s//g; if($hash_ref->{balance} =~ /^([\d\.]+) ([-\+])$/) { if($2 eq '+') { $hash_ref->{balance} = "+".$1; } if($2 eq '-') { $hash_ref->{balance} = "-".$1; } } push @ret_array, $hash_ref if(($i==1 and $page == 1) or ($i>1 and $page>=1)); $i++; } if($text =~ /^(\d{2}\/\d{2}\/\d{4}) (\d{2}\/\d{2}\/\d{4}) (.+) ([-\+] [\d\.]+)$/) { # this is a visa card statement $visa = 1; $hash_ref->{date} = $1; $hash_ref->{description} = $3; $hash_ref->{euro_amount} = $4; $hash_ref->{euro_amount} =~ s/\s//g; push @ret_array, $hash_ref; # if(($i==1 and $page == 1) or ($i>1 and $page>=1)); $i++; } } } } } # if we are at the last page we will find a button called # Another Statement, exit from the while loop if($agent->content =~ /Another Statement/is) { last; } else { # the "next" buttons have different target names # it depdends if we are watching a visa card or a normal # current account if($visa) { $agent->field('__EVENTTARGET', 'lBtnAnother1'); } else { $agent->field('__EVENTTARGET', 'lbtnShow'); } $page++; $i = 1; } $res = $agent->submit(); $agent->save_content("./statement_page".($page-1).".html") if $config_ref->{debug}; # something wrong? if(!$res->is_success) { carp("Unable to get page!"); return undef; } } } else { # account doesn't exist in the homebanking interface # return undef carp("Account $account not found!"); return undef; } return \@ret_array; } # TODO: implement this sub funds_transfer { } # TODO: implement this sub mobile_topup { } sub logoff { my $self = shift; my $config_ref = shift; if(defined $agent and not $error) { my $res = $agent->get($BASEURL . '/online/DoLogOff.aspx'); $agent->save_content("./logoff.html") if $config_ref->{debug}; $agent->field('__EVENTTARGET', 'lbtnContinue'); $agent->submit; } } END { logoff; } 1; __END__ =head1 INSTALLATION To install this module type the following: perl Makefile.PL make make test make install =head1 DEPENDENCIES This module requires these other modules and libraries: WWW::Mechanize HTML::TokeParser Date::Calc =head1 MODULE HOMEPAGES =over =item * Project homepage on Google code (with SVN repository): L =item * Project homepage on CPAN.org: L =back =head1 SYNOPSIS use Finance::Bank::IE::PermanentTSB; my %config = ( "open24numba" => "your open24 number", "password" => "your internet password", "pan" => "your personal access number", "debug" => 1, # <- enable debug messages ); my $balance = Finance::Bank::IE::PermanentTSB->check_balance(\%config); if(not defined $balance) { print "Error!\n" exit; } foreach my $acc (@$balance) { printf ("%s ending with %s: %s\n", $acc->{'accname'}, $acc->{'accno'}, $acc->{'accbal'} ); } my $statement = Finance::Bank::IE::PermanentTSB->account_statement( \%config, SWITCH_ACCOUNT, '2667','2008/12/01','2008/12/31'); if(not defined $statement) { print "Error!\n" exit; } foreach my $row (@$statement) { printf("%s | %s | %s | %s |\n", $row->{date}, $row->{description}, $row->{euro_amount}, $row->{balance} ); } =head1 SEE ALSO =over =item * B - CLI tool to interact with your home banking L =item * Ronan Waider's C - L =back =head1 AUTHOR Angelo "pallotron" Failla, Epallotron@freaknet.orgE - L - L =head1 COPYRIGHT AND LICENSE Copyright (C) 2009 by Angelo "pallotron" Failla This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available. =cut