lib/Finance/Bank/DE/NetBank.pm

filter: Statementstmt 20.3% 32 / 157 Branchbran 0.0% 0 / 46 Conditioncond 4.7% 2 / 42 MC/DCmcdc 0.0% 0 / 23 Subroutinesub 53.3% 8 / 15 Podpod 100% 8 / 8 totaltotal 17.1% 50 / 291 CC 40 SCAR 51.8
CC
40
Cov
14%
transfer
420.0
_parse_csv
90.0
statement
42.0
CRAP 177.1
↑ Summary
1 package Finance::Bank::DE::NetBank;
2  
3 5 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 5 ▶use vars qw($VERSION $DEBUG);
Subroutine BEGIN: called CC=1 SCAR=0.0
5 5 ▶use base qw(Class::Accessor);
Subroutine BEGIN: called CC=1 SCAR=0.0
6 5 Finance::Bank::DE::NetBank->mk_accessors(
7 qw(BASE_URL BLZ CUSTOMER_ID PASSWORD AGENT_TYPE AGENT ACCOUNT Debug));
8  
9 5 ▶use WWW::Mechanize;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 5 ▶use Text::CSV_XS;
Subroutine BEGIN: called CC=1 SCAR=0.0
11 5 ▶use Data::Dumper;
Subroutine BEGIN: called CC=1 SCAR=0.0
12  
13 5 $| = 1;
14  
15 5 $VERSION = "1.05";
16  
17 1 ▶sub Version {
Subroutine Version: called CC=1 SCAR=0.0
Pod documented
18 1 return $VERSION;
19 }
20  
21 4 ▶sub new {
Subroutine new: called CC=4 SCAR=14.6
Pod documented
22 4 my $proto = shift;
23 4 my %values = (
24 AGENT_TYPE => "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)",
25 BASE_URL =>
26 'https://www.netbank-money.de/netbank-barrierefrei-banking/view/',
27 BLZ => '20090500', # NetBank BLZ
28 CUSTOMER_ID => '',
29 PASSWORD => '',
30 ACCOUNT => '',
31 @_
32 );
33  
34 4 ▶ my $class = ref($proto) || $proto;
Condition33%1/3
ref $proto || $proto
l!l&&r!l&&!r
040
MC/DC0%0/2
ref $proto || $proto
ref $proto $proto
Truth table33%1/3
A || B
A= ref $protoB= $proto
ABresult
1X1
011
000
35 4 ▶ my $parent = ref($proto) && $proto;
Condition33%1/3
ref $proto && $proto
!ll&&!rl&&r
400
MC/DC0%0/2
ref $proto && $proto
ref $proto $proto
Truth table33%1/3
A && B
A= ref $protoB= $proto
ABresult
0X0
100
111
36  
37 4 my $self = {};
38 4 bless( $self, $class );
39  
40 4 foreach my $key ( keys %values ) {
41 24 $self->$key("$values{$key}");
42 }
43  
44 #$self->Debug(1);
45 4 return $self;
46 }
47  
48 0 ▶sub connect {
Subroutine connect: not called CC=1 SCAR=6.9
Pod documented
49 0 my $self = shift;
50 0 print STDERR "Method connect() is deprecated. Use only login() instead!\n";
51 0 return $self->login(@_);
52 }
53  
54 0 ▶sub login {
Subroutine login: not called CC=3 SCAR=24.8
Pod documented
55 0 my $self = shift;
56 0 my %values = (
57 CUSTOMER_ID => $self->CUSTOMER_ID(),
58 PASSWORD => $self->PASSWORD(),
59 @_
60 );
61
62 0 my $url = $self->BASE_URL() . "index.jsp?blz=" . $self->BLZ() . "&graphics=false";
63 0 my $agent = WWW::Mechanize->new( agent => $self->AGENT_TYPE(), );
64 0 $agent->{agent} = "";
65 0 $agent->get($url);
66 0 $self->AGENT($agent);
67  
68 0 $agent->field( "kundennummer", $values{'CUSTOMER_ID'} );
69 0 $agent->field( "pin", $values{'PASSWORD'} );
70 0 $agent->click();
71  
72 0 ▶ print STDERR Dumper( $agent->content ) if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
73
74 0 ▶ if ($agent->content =~ /fieldtableerrorred/ig) {
Branch: 1 branch
BranchTrueFalseTotal
if ($agent->content =~ /fieldtableerrorred/gi) 0 0 0
75 0 return undef;
76 }
77  
78 0 return 1;
79
80 }
81  
82 0 ▶sub saldo {
Subroutine saldo: not called CC=3 SCAR=24.8
Pod documented
83 0 my $self = shift;
84 0 my $data = $self->statement(@_);
85
86 0 ▶ if ($data) {
Branch: 1 branch
BranchTrueFalseTotal
if ($data) { } 0 0 0
87 0 ▶ print STDERR Dumper($data) if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
88 0 return $data->{'STATEMENT'}{'SALDO'};
89 } else {
90 0 return undef;
91 }
92 }
93  
94 0 ▶sub statement {
Subroutine statement: not called CC=6 SCAR=37.4
Pod documented
95 0 my $self = shift;
96 0 my %values = (
97 TIMEFRAME => "30"
98 , # 1 or 30 days || "alle" = ALL || "variabel" = between START_DATE and END_DATE only
99 START_DATE => 0, # dd.mm.yyyy
100 END_DATE => 0, # dd.mm.yyyy
101 ACCOUNT => $self->ACCOUNT(),
102 @_
103 );
104  
105 # get mainpage
106 0 my $login_status = $self->login();
107 0 ▶ return undef unless $login_status;
Branch: 1 branch
BranchTrueFalseTotal
unless $login_status 0 0 0
108
109 0 my $agent = $self->AGENT();
110  
111 # If you've problems with your environmet settings activate this and "use encodings"
112 # binmode(STDOUT, ":encoding(iso-8859-15)");
113  
114 0 $agent->field( "kontonummer", $values{'ACCOUNT'} );
115 0 $agent->field( "zeitraum", $values{'TIMEFRAME'} );
116  
117 0 ▶ if ( $values{'TIMEFRAME'} eq "variabel"
Branch: 1 branch
BranchTrueFalseTotal
if ($values{"TIMEFRAME"} eq "variabel" and $values{"START_DATE"} and $values{"END_DATE"}) 0 0 0
Condition0%0/6
$values{"TIMEFRAME"} eq "variabel" and $values{"START_DATE"} and $values{"END_DATE"}
!ll&&!rl&&r
000
$values{"TIMEFRAME"} eq "variabel" and $values{"START_DATE"}
!ll&&!rl&&r
000
MC/DC0%0/3
$values{"TIMEFRAME"} eq "variabel" and $values{"START_DATE"} and $values{"END_DATE"}
$values{"TIMEFRAME"} eq "variabel" $values{"START_DATE"} $values{"END_DATE"}
Truth table0%0/4
A and B and C
A= $values{"TIMEFRAME"} eq "variabel"B= $values{"START_DATE"}C= $values{"END_DATE"}
ABCresult
0XX0
10X0
1100
1111
118 && $values{'START_DATE'}
119 && $values{'END_DATE'} )
120 {
121 0 $agent->field( "startdatum", $values{'START_DATE'} );
122 0 $agent->field( "enddatum", $values{'END_DATE'} );
123 }
124  
125 0 $agent->click();
126 0 $agent->get( $self->BASE_URL() . "umsatzdownload.do" );
127  
128 0 my $content = $agent->content();
129 0 ▶ print STDERR Dumper($content) if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
130  
131 0 my $csv_content = $self->_parse_csv($content);
132 0 return $csv_content;
133 }
134  
135 0 ▶sub transfer {
Subroutine transfer: not called CC=20 SCAR=60.4
Pod documented
136 0 my $self = shift;
137 0 my %values = (
138 SENDER_ACCOUNT => $self->ACCOUNT(),
139 RECEIVER_NAME => "",
140 RECEIVER_ACCOUNT => "",
141 RECEIVER_BLZ => "",
142 RECEIVER_SAVE => "false",
143 COMMENT_1 => "",
144 COMMENT_2 => "",
145 AMOUNT => "0.00",
146 TAN => "",
147 @_
148 );
149
150 # get mainpage
151 0 my $login_status = $self->login();
152 0 ▶ return undef unless $login_status;
Branch: 1 branch
BranchTrueFalseTotal
unless $login_status 0 0 0
153  
154 0 my $agent = $self->AGENT();
155 0 my $url = $self->BASE_URL();
156  
157 0 $agent->get($url . "ueberweisung_per_heute_neu.do");
158  
159 ( $values{'AMOUNT_EURO'}, $values{'AMOUNT_CENT'} ) =
160 0 split( /\.|,/, $values{'AMOUNT'} );
161
162 0 $values{'AMOUNT_CENT'} = sprintf("%02d", $values{'AMOUNT_CENT'});
163  
164 0 $agent->field("auftraggeberKontonummer", $values{'SENDER_ACCOUNT'});
165 0 $agent->field("empfaengerName", $values{'RECEIVER_NAME'});
166 0 $agent->field("empfaengerBankleitzahl", $values{'RECEIVER_BLZ'});
167 0 $agent->field("empfaengerKontonummer", $values{'RECEIVER_ACCOUNT'});
168 0 $agent->field("betragEuro", $values{'AMOUNT_EURO'});
169 0 $agent->field("betragCent", $values{'AMOUNT_CENT'});
170 0 $agent->field("verwendungszweck1", $values{'COMMENT_1'});
171 0 $agent->field("verwendungszweck2", $values{'COMMENT_2'});
172 0 $agent->click("btnNeuSpeichern");
173  
174 # get TAN fieldname, index
175 0 my $tan_field;
176 my $tan_index;
177 0 my $tan;
178
179 0 $agent->content =~ /<label\s*for=["']*(.*?)["']\s*>(?:Tr|TAN)(?:[a-z].*?)\s?(\d+)/gmix;
180
181 0 $tan_field = $1;
182 0 $tan_index = $2;
183
184 0 ▶ print STDERR "tan_field: $tan_field, tan_index: $tan_index\n" if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
185
186 0 ▶ if ($tan_field && $tan_index && ref($values{'TAN'}) eq "HASH" && $values{'TAN'}->{$tan_index}) {
Branch: 3 branches
BranchTrueFalseTotal
if ($tan_field and $tan_index and ref $values{'TAN'} eq 'HASH' and $values{'TAN'}{$tan_index}) { } 0 0 0
elsif ($tan_field and $tan_index and ref $values{'TAN'} eq 'ARRAY') { } 0 0 0
elsif ($tan_field and $tan_index and ref $values{'TAN'} eq 'CODE') { } 0 0 0
Condition0%0/9
$tan_field and $tan_index and ref $values{"TAN"} eq "HASH" and $values{"TAN"}{$tan_index}
!ll&&!rl&&r
000
$tan_field and $tan_index and ref $values{"TAN"} eq "HASH"
!ll&&!rl&&r
000
$tan_field and $tan_index
!ll&&!rl&&r
000
MC/DC0%0/4
$tan_field and $tan_index and ref $values{"TAN"} eq "HASH" and $values{"TAN"}{$tan_index}
$tan_field $tan_index ref $values{"TAN"} eq "HASH" $values{"TAN"}{$tan_index}
Truth table0%0/5
A and B and C and D
A= $tan_fieldB= $tan_indexC= ref $values{"TAN"} eq "HASH"D= $values{"TAN"}{$tan_index}
ABCDresult
0XXX0
10XX0
110X0
11100
11111
187 0 ▶ print STDERR "METHOD: TAN HASH" if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
188 0 $tan = $values{'TAN'}->{$tan_index};
189 ▶ } elsif ($tan_field && $tan_index && ref($values{'TAN'}) eq "ARRAY") {
Condition0%0/6
$tan_field and $tan_index and ref $values{"TAN"} eq "ARRAY"
!ll&&!rl&&r
000
$tan_field and $tan_index
!ll&&!rl&&r
000
MC/DC0%0/3
$tan_field and $tan_index and ref $values{"TAN"} eq "ARRAY"
$tan_field $tan_index ref $values{"TAN"} eq "ARRAY"
Truth table0%0/4
A and B and C
A= $tan_fieldB= $tan_indexC= ref $values{"TAN"} eq "ARRAY"
ABCresult
0XX0
10X0
1100
1111
190 0 ▶ print STDERR "METHOD: Object/Method" if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
191 0 my $obj = $values{'TAN'}[0];
192 0 my $method = $values{'TAN'}[1];
193 0 eval ( $tan = $obj->$method() );
194 0 ▶ if ($@) {
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
195 0 print "ERROR: Could not execute TAN method: $method";
196 0 return undef;
197 }
198 ▶ } elsif ($tan_field && $tan_index && ref($values{'TAN'}) eq "CODE") {
Condition0%0/6
$tan_field and $tan_index and ref $values{"TAN"} eq "CODE"
!ll&&!rl&&r
000
$tan_field and $tan_index
!ll&&!rl&&r
000
MC/DC0%0/3
$tan_field and $tan_index and ref $values{"TAN"} eq "CODE"
$tan_field $tan_index ref $values{"TAN"} eq "CODE"
Truth table0%0/4
A and B and C
A= $tan_fieldB= $tan_indexC= ref $values{"TAN"} eq "CODE"
ABCresult
0XX0
10X0
1100
1111
199 0 ▶ print STDERR "METHOD: CALLBACK" if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
200 0 $tan = &{$values{'TAN'}}($tan_index);
201 }
202  
203 0 ▶ print STDERR " TAN: [$tan]\n" if $self->Debug();
Branch: 1 branch
BranchTrueFalseTotal
if $self->Debug 0 0 0
204
205 0 ▶ if ($tan) {
Branch: 1 branch
BranchTrueFalseTotal
if ($tan) { } 0 0 0
206 0 $agent->field($tan_field, $tan_index);
207 0 $agent->click("btnBestaetigen");
208  
209 # lazy error checking
210 0 ▶ if ( $agent->content() =~ m|<span class="error">(.*)30017(.*)</span>| ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($agent->content =~ m[<span class="error">(.*)30017(.*)</span>]) { } 0 0 0
211 0 $agent->content() =~ m|<span class="error">(.*?)</span>|;
212 0 my $error = $1;
213 0 print "ERROR: $error";
214 0 return;
215 } else {
216 0 my $content = $agent->content();
217 0 return $agent->content();
218 }
219 } else {
220 0 print "ERROR: Could not identify requested TAN Index #";
221 0 return;
222 }
223 }
224  
225 0 ▶sub logout {
Subroutine logout: not called CC=1 SCAR=6.9
Pod documented
226 0 my $self = shift;
227 0 my $agent = $self->AGENT();
228 0 my $url = $self->BASE_URL();
229 0 $agent->get( $url . "logout.do" );
230 }
231  
232 0 ▶sub _parse_csv {
Subroutine _parse_csv: not called CC=9 SCAR=45.0
233 0 my $self = shift;
234 0 my $csv_content = shift;
235 0 $csv_content =~ s/\r//gmi;
236 0 $csv_content =~ s/\f//gmi;
237 0 my @lines = split( "\n", $csv_content );
238 0 my %data;
239  
240 0 my $csv = Text::CSV_XS->new(
241 {
242 sep_char => "\t",
243 binary => 1, ### german umlauts...
244 }
245 );
246  
247 0 my $line_count = 0;
248  
249 0 foreach my $line (@lines) {
250 0 my $status = $csv->parse($line);
251 0 my @columns = $csv->fields();
252 0 $line_count++;
253  
254 ### Account Details ########################
255 0 ▶ if ( $line_count > 3 && $line_count < 6 ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($line_count > 3 and $line_count < 6) 0 0 0
Condition0%0/3
$line_count > 3 and $line_count < 6
!ll&&!rl&&r
000
MC/DC0%0/2
$line_count > 3 and $line_count < 6
$line_count > 3 $line_count < 6
Truth table0%0/3
A and B
A= $line_count > 3B= $line_count < 6
ABresult
0X0
100
111
256 0 $columns[0] =~ s/://;
257 0 $data{"ACCOUNT"}{ uc( $columns[0] ) } = $columns[1];
258 }
259  
260 ### Statement Details ######################
261 0 ▶ if ( $line_count == 9 ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($line_count == 9) 0 0 0
262 0 $data{"STATEMENT"}{"START_DATE"} = $columns[0];
263 0 $data{"STATEMENT"}{"END_DATE"} = $columns[1];
264 0 $data{"STATEMENT"}{"ACCOUNT_ID"} = $columns[2];
265 0 $data{"STATEMENT"}{"SALDO"} = $columns[3];
266 0 $data{"STATEMENT"}{"WAEHRUNG"} = $columns[4];
267 }
268  
269 ### Transactions ###########################
270 0 ▶ if ( $line_count > 12 && $line_count <= $#lines ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($line_count > 12 and $line_count <= $#lines) 0 0 0
Condition0%0/3
$line_count > 12 and $line_count <= $#lines
!ll&&!rl&&r
000
MC/DC0%0/2
$line_count > 12 and $line_count <= $#lines
$line_count > 12 $line_count <= $#lines
Truth table0%0/3
A and B
A= $line_count > 12B= $line_count <= $#lines
ABresult
0X0
100
111
271 0 my $row = $line_count - 13;
272 0 $data{"TRANSACTION"}[$row]{"BUCHUNGSTAG"} = $columns[0];
273 0 $data{"TRANSACTION"}[$row]{"WERTSTELLUNGSTAG"} = $columns[1];
274 0 $data{"TRANSACTION"}[$row]{"VERWENDUNGSZWECK"} = $columns[2];
275  
276 0 $columns[3] =~ s/\.//;
277 0 $columns[3] =~ s/,/\./;
278  
279 0 $data{"TRANSACTION"}[$row]{"UMSATZ"} = $columns[3];
280 0 $data{"TRANSACTION"}[$row]{"WAEHRUNG"} = $columns[4];
281 0 ▶ $data{"TRANSACTION"}[$row]{"NOT_YET_FINISHED"} = $columns[5]
Branch: 1 branch
BranchTrueFalseTotal
if defined $columns[5] and $columns[5] =~ /^[^\s]$/gi 0 0 0
Condition0%0/3
defined $columns[5] and $columns[5] =~ /^[^\s]$/gi
!ll&&!rl&&r
000
MC/DC0%0/2
defined $columns[5] and $columns[5] =~ /^[^\s]$/gi
defined $columns[5] $columns[5] =~ /^[^\s]$/gi
Truth table0%0/3
A and B
A= defined $columns[5]B= $columns[5] =~ /^[^\s]$/gi
ABresult
0X0
100
111
282 if ( defined( $columns[5] ) && $columns[5] =~ m/^[^\s]$/ig );
283 }
284 }
285  
286 0 return \%data;
287 }
288  
289 5 1;
290 __END__
↑ Summary