| 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__ |