line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package Data::BT::PhoneBill; |
2
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
$VERSION = '1.00'; |
4
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
=head1 NAME |
6
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
Data::BT::PhoneBill - Parse a BT Phone Bill from their web site |
8
|
|
|
|
|
|
|
|
9
|
|
|
|
|
|
|
=head1 SYNOPSIS |
10
|
|
|
|
|
|
|
|
11
|
|
|
|
|
|
|
my $bill = Data::BT::PhoneBill->new($filename); |
12
|
|
|
|
|
|
|
|
13
|
|
|
|
|
|
|
while (my $call = $bill->next_call) { |
14
|
|
|
|
|
|
|
print $call->date, $call->time, $call->destination, |
15
|
|
|
|
|
|
|
$call->number, $call->duration, $call->type, $call->cost; |
16
|
|
|
|
|
|
|
} |
17
|
|
|
|
|
|
|
} |
18
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
=head1 DESCRIPTION |
20
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
This module provides an interface for querying your BT phone bill, |
22
|
|
|
|
|
|
|
as produced from their "View My Bill" service at http://www.bt.com/ |
23
|
|
|
|
|
|
|
|
24
|
|
|
|
|
|
|
You should use their "Download Calls" option to save your bill as a CSV |
25
|
|
|
|
|
|
|
file, and then feed it to this module. |
26
|
|
|
|
|
|
|
|
27
|
|
|
|
|
|
|
=head1 CONSTRUCTOR |
28
|
|
|
|
|
|
|
|
29
|
|
|
|
|
|
|
=head2 new |
30
|
|
|
|
|
|
|
|
31
|
|
|
|
|
|
|
my $bill = Data::BT::PhoneBill->new($filename); |
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
Parses the bill stored in $filename. |
34
|
|
|
|
|
|
|
|
35
|
|
|
|
|
|
|
=head1 FETCHING DATA |
36
|
|
|
|
|
|
|
|
37
|
|
|
|
|
|
|
=head2 next_call |
38
|
|
|
|
|
|
|
|
39
|
|
|
|
|
|
|
while (my $call = $bill->next_call) { |
40
|
|
|
|
|
|
|
print $call->date, $call->time, $call->destination, |
41
|
|
|
|
|
|
|
$call->number, $call->duration, $call->type, $call->cost; |
42
|
|
|
|
|
|
|
} |
43
|
|
|
|
|
|
|
} |
44
|
|
|
|
|
|
|
|
45
|
|
|
|
|
|
|
Each time you call $bill->next_call it will return a |
46
|
|
|
|
|
|
|
Data::BT::PhoneBill::_Call object representing a telephone call (or false |
47
|
|
|
|
|
|
|
when there are no more to read) |
48
|
|
|
|
|
|
|
|
49
|
|
|
|
|
|
|
Each Call object has the following methods defined: |
50
|
|
|
|
|
|
|
|
51
|
|
|
|
|
|
|
=head2 date |
52
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
A Date::Simple object represeting the date of the call. |
54
|
|
|
|
|
|
|
|
55
|
|
|
|
|
|
|
=head2 time |
56
|
|
|
|
|
|
|
|
57
|
|
|
|
|
|
|
A string representing the time of the call in the 24-hr format 'hh:mm'. |
58
|
|
|
|
|
|
|
|
59
|
|
|
|
|
|
|
=head2 destination |
60
|
|
|
|
|
|
|
|
61
|
|
|
|
|
|
|
A string that for local and national calls will usually be the |
62
|
|
|
|
|
|
|
town. However this can also contain things like "Premium Rate", "Local |
63
|
|
|
|
|
|
|
Rate" etc for 'non-geographic' calls. |
64
|
|
|
|
|
|
|
|
65
|
|
|
|
|
|
|
=head2 number |
66
|
|
|
|
|
|
|
|
67
|
|
|
|
|
|
|
A string representing the telephone number dialled, formatted as it |
68
|
|
|
|
|
|
|
appears on the bill. |
69
|
|
|
|
|
|
|
|
70
|
|
|
|
|
|
|
=head2 duration |
71
|
|
|
|
|
|
|
|
72
|
|
|
|
|
|
|
The length of the call in seconds. |
73
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
=head2 type |
75
|
|
|
|
|
|
|
|
76
|
|
|
|
|
|
|
The 'type' of call - e.g. "DD Local", "DD International". |
77
|
|
|
|
|
|
|
|
78
|
|
|
|
|
|
|
=head2 cost |
79
|
|
|
|
|
|
|
|
80
|
|
|
|
|
|
|
The cost of the call, before any discounts are applied, in pence. |
81
|
|
|
|
|
|
|
|
82
|
|
|
|
|
|
|
=head2 chargecard |
83
|
|
|
|
|
|
|
|
84
|
|
|
|
|
|
|
Any chargecard number used make the call. |
85
|
|
|
|
|
|
|
|
86
|
|
|
|
|
|
|
=head2 installation |
87
|
|
|
|
|
|
|
|
88
|
|
|
|
|
|
|
The phone number from which the call was placed. |
89
|
|
|
|
|
|
|
|
90
|
|
|
|
|
|
|
=head2 line |
91
|
|
|
|
|
|
|
|
92
|
|
|
|
|
|
|
The line from which the call was placed (if a secondary line with the |
93
|
|
|
|
|
|
|
same number is installed). |
94
|
|
|
|
|
|
|
|
95
|
|
|
|
|
|
|
=head2 rebate |
96
|
|
|
|
|
|
|
|
97
|
|
|
|
|
|
|
Any rebates applied to the call. |
98
|
|
|
|
|
|
|
|
99
|
|
|
|
|
|
|
=cut |
100
|
|
|
|
|
|
|
|
101
|
1
|
|
|
1
|
|
21443
|
use strict; |
|
1
|
|
|
|
|
4
|
|
|
1
|
|
|
|
|
45
|
|
102
|
1
|
|
|
1
|
|
1326
|
use Text::CSV_XS; |
|
1
|
|
|
|
|
12316
|
|
|
1
|
|
|
|
|
405
|
|
103
|
1
|
|
|
1
|
|
1750
|
use IO::File; |
|
1
|
|
|
|
|
21885
|
|
|
1
|
|
|
|
|
219
|
|
104
|
|
|
|
|
|
|
|
105
|
|
|
|
|
|
|
use overload |
106
|
1
|
|
|
|
|
10
|
'<>' => \&next_call, |
107
|
1
|
|
|
1
|
|
2319
|
fallback => 1; |
|
1
|
|
|
|
|
1863
|
|
108
|
|
|
|
|
|
|
|
109
|
|
|
|
|
|
|
sub new { |
110
|
1
|
|
|
1
|
1
|
18
|
my ($class, $file) = @_; |
111
|
1
|
50
|
|
|
|
11
|
my $fh = new IO::File $file, "r" or die "Can't read $file: $!\n"; |
112
|
1
|
|
|
|
|
141
|
my $headers; |
113
|
|
|
|
|
|
|
# Downloads now have blank lines at the top |
114
|
1
|
|
|
|
|
30
|
while (($headers = <$fh>) !~ /Date/) { |
115
|
3
|
50
|
|
|
|
15
|
die "Couldn't find header line" if eof($fh); |
116
|
|
|
|
|
|
|
} |
117
|
|
|
|
|
|
|
bless { |
118
|
1
|
|
|
|
|
10
|
_fh => $fh, |
119
|
|
|
|
|
|
|
_parser => Text::CSV_XS->new, |
120
|
|
|
|
|
|
|
}, $class; |
121
|
|
|
|
|
|
|
} |
122
|
|
|
|
|
|
|
|
123
|
4
|
|
|
4
|
|
13
|
sub _fh { shift->{_fh} } |
124
|
6
|
|
|
6
|
|
35
|
sub _csv { shift->{_parser} } |
125
|
|
|
|
|
|
|
|
126
|
|
|
|
|
|
|
sub next_call { |
127
|
4
|
|
|
4
|
1
|
12125
|
my $self = shift; |
128
|
4
|
|
|
|
|
14
|
my $fh = $self->_fh; |
129
|
4
|
|
|
|
|
26
|
my $line = <$fh>; |
130
|
4
|
100
|
|
|
|
23
|
return unless defined $line; |
131
|
3
|
50
|
|
|
|
12
|
if ($self->_csv->parse($line)) { |
132
|
3
|
|
|
|
|
146
|
return Data::BT::PhoneBill::_Call->new($self->_csv->fields) |
133
|
|
|
|
|
|
|
} else { |
134
|
0
|
|
|
|
|
0
|
warn "Cannot parse: " . $self->_csv->error_input . "\n"; |
135
|
0
|
|
|
|
|
0
|
return; |
136
|
|
|
|
|
|
|
} |
137
|
|
|
|
|
|
|
} |
138
|
|
|
|
|
|
|
|
139
|
|
|
|
|
|
|
# ==================================================================== # |
140
|
|
|
|
|
|
|
|
141
|
|
|
|
|
|
|
package Data::BT::PhoneBill::_Call; |
142
|
|
|
|
|
|
|
|
143
|
1
|
|
|
1
|
|
1580
|
use Date::Simple; |
|
1
|
|
|
|
|
7952
|
|
|
1
|
|
|
|
|
71
|
|
144
|
|
|
|
|
|
|
|
145
|
|
|
|
|
|
|
#ChargeCode,InstallationNo,LineNo,ChargeCardNo,Date,Time,Destination,CalledNo,Duration,TxtDirectRebate,Cost |
146
|
|
|
|
|
|
|
our @fields = qw(type installation line chargecard _date time destination |
147
|
|
|
|
|
|
|
_number _duration rebate _cost); |
148
|
|
|
|
|
|
|
|
149
|
|
|
|
|
|
|
for my $f (@fields) { |
150
|
1
|
|
|
1
|
|
8
|
no strict 'refs'; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
521
|
|
151
|
22
|
|
|
22
|
|
1303
|
*{$f} = sub { shift->{$f} }; |
152
|
|
|
|
|
|
|
} |
153
|
|
|
|
|
|
|
|
154
|
|
|
|
|
|
|
sub new { |
155
|
3
|
|
|
3
|
|
51
|
my ($class, @data) = @_; |
156
|
3
|
|
|
|
|
12
|
bless { map { $fields[$_] => $data[$_] } 0..$#fields } => $class; |
|
33
|
|
|
|
|
130
|
|
157
|
|
|
|
|
|
|
} |
158
|
|
|
|
|
|
|
|
159
|
|
|
|
|
|
|
sub date { |
160
|
4
|
|
|
4
|
|
594
|
my @parts = split /\//, shift->_date; |
161
|
4
|
|
|
|
|
29
|
return Date::Simple->new(@parts[2,1,0]); |
162
|
|
|
|
|
|
|
} |
163
|
|
|
|
|
|
|
|
164
|
|
|
|
|
|
|
sub number { |
165
|
3
|
|
|
3
|
|
13
|
my $num = shift->_number; |
166
|
3
|
|
|
|
|
21
|
$num =~ s/\s+$//; $num; |
|
3
|
|
|
|
|
14
|
|
167
|
|
|
|
|
|
|
} |
168
|
|
|
|
|
|
|
|
169
|
|
|
|
|
|
|
sub duration { |
170
|
3
|
|
|
3
|
|
13
|
my ($h, $m, $s) = split /:/, shift->_duration; |
171
|
3
|
|
|
|
|
22
|
return ($h * 60 * 60) + ($m * 60) + $s; |
172
|
|
|
|
|
|
|
} |
173
|
|
|
|
|
|
|
|
174
|
3
|
|
|
3
|
|
13
|
sub cost { shift->_cost * 100 } |
175
|
|
|
|
|
|
|
|
176
|
|
|
|
|
|
|
1; |
177
|
|
|
|
|
|
|
|
178
|
|
|
|
|
|
|
=head1 AUTHOR |
179
|
|
|
|
|
|
|
|
180
|
|
|
|
|
|
|
Tony Bowden, with improvements from Simon Cozens |
181
|
|
|
|
|
|
|
|
182
|
|
|
|
|
|
|
=head1 BUGS and QUERIES |
183
|
|
|
|
|
|
|
|
184
|
|
|
|
|
|
|
Please direct all correspondence regarding this module to: |
185
|
|
|
|
|
|
|
bug-Data-BT-PhoneBill@rt.cpan.org |
186
|
|
|
|
|
|
|
|
187
|
|
|
|
|
|
|
=head1 COPYRIGHT AND LICENSE |
188
|
|
|
|
|
|
|
|
189
|
|
|
|
|
|
|
Copyright (C) 2001-2005 Tony Bowden. |
190
|
|
|
|
|
|
|
|
191
|
|
|
|
|
|
|
This program is free software; you can redistribute it and/or modify |
192
|
|
|
|
|
|
|
it under the terms of the GNU General Public License; either version |
193
|
|
|
|
|
|
|
2 of the License, or (at your option) any later version. |
194
|
|
|
|
|
|
|
|
195
|
|
|
|
|
|
|
This program is distributed in the hope that it will be useful, |
196
|
|
|
|
|
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of |
197
|
|
|
|
|
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
198
|
|
|
|
|
|
|
|
199
|
|
|
|
|
|
|
=head1 SEE ALSO |
200
|
|
|
|
|
|
|
|
201
|
|
|
|
|
|
|
The Perl.com article on Class::DBI is based around Data::BT::PhoneBill - |
202
|
|
|
|
|
|
|
http://www.perl.com/pub/a/2002/11/27/classdbi.html |
203
|
|
|
|
|
|
|
|
204
|
|
|
|
|
|
|
=cut |