blib/lib/Finance/Bank/BR/Santander/Spreadsheet.pm untested

filter: Statementstmt 0.0% 0 / 50 Branchbran 0.0% 0 / 8 Subroutinesub 0.0% 0 / 10 Podpod 0.0% 0 / 6 totaltotal 0.0% 0 / 74 CC 5 SCAR 16.7
CC
5
Cov
0%
load
12.0
new
6.0
_parse
6.0
CRAP 5.3
1 package Finance::Bank::BR::Santander::Spreadsheet;
2  
3 use strict;
4 use warnings;
5  
6 use Spreadsheet::ParseExcel::Simple;
7  
8 use DateTime::Format::Strptime qw(strptime);
9  
10 our $VERSION = '0.01';
11  
12 sub new {
13 my $class = shift;
14 my $self = {};
15 bless $self, $class;
16 $self->_init;
17 if ($self->load(@_)) {
18 return undef;
19 }
20 return $self;
21 }
22  
23 sub _init {
24 my $self = shift;
25 $self->{balance} = 0;
26 $self->{statement} = [];
27 }
28  
29 sub _parse {
30 my $self = shift;
31 my $xls = shift;
32 my @sheets = $xls->sheets;
33 my $sheet = $sheets[0];
34 if ($sheet->has_data) {
35 my @header = $sheet->next_row;
36 }
37 while ($sheet->has_data) {
38 my @line = $sheet->next_row;
39 my $obj = {
40 'date' => strptime("%d/%m/%Y", $line[0]),
41 'name' => $line[2],
42 'extra' => $line[3],
43 'value' => $line[4],
44 'balance' => $line[5],
45 };
46 push @{$self->{statement}}, $obj;
47 $self->{balance} = $line[5];
48 }
49 }
50  
51 sub load {
52 my $self = shift;
53 my $filename = shift;
54 if (defined($filename)) {
55 my $xls = Spreadsheet::ParseExcel::Simple->read($filename);
56 if (!defined($xls)) {
57 return 1;
58 }
59 $self->_parse($xls);
60 }
61 return 0;
62 }
63  
64 sub balance {
65 my $self = shift;
66 return $self->{balance};
67 }
68  
69 sub statement {
70 my $self = shift;
71 return @{$self->{statement}};
72 }
73  
74 1;
75  
76 __END__