line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package Gantry::Utils::CRUDHelp; |
2
|
8
|
|
|
8
|
|
24348
|
use strict; |
|
8
|
|
|
|
|
16
|
|
|
8
|
|
|
|
|
297
|
|
3
|
|
|
|
|
|
|
|
4
|
8
|
|
|
8
|
|
43
|
use base 'Exporter'; |
|
8
|
|
|
|
|
15
|
|
|
8
|
|
|
|
|
10984
|
|
5
|
|
|
|
|
|
|
|
6
|
|
|
|
|
|
|
our @EXPORT = qw( |
7
|
|
|
|
|
|
|
clean_dates |
8
|
|
|
|
|
|
|
form_profile |
9
|
|
|
|
|
|
|
clean_params |
10
|
|
|
|
|
|
|
write_file |
11
|
|
|
|
|
|
|
verify_permission |
12
|
|
|
|
|
|
|
); |
13
|
|
|
|
|
|
|
|
14
|
|
|
|
|
|
|
sub write_file { |
15
|
0
|
|
|
0
|
1
|
0
|
my( $self, $field, $archive, $extra_dir, $forced_file_name ) = @_; |
16
|
|
|
|
|
|
|
|
17
|
0
|
|
|
|
|
0
|
my $upload = $self->file_upload( $field ); |
18
|
|
|
|
|
|
|
|
19
|
0
|
|
|
|
|
0
|
my $id = $upload->{unique_key}; |
20
|
|
|
|
|
|
|
|
21
|
0
|
0
|
|
|
|
0
|
if ( $forced_file_name ) { |
22
|
0
|
|
|
|
|
0
|
$upload->{ident} = $forced_file_name . $upload->{suffix}; |
23
|
|
|
|
|
|
|
} |
24
|
|
|
|
|
|
|
else { |
25
|
0
|
|
|
|
|
0
|
$upload->{ident} = $id . $upload->{suffix}; |
26
|
|
|
|
|
|
|
} |
27
|
|
|
|
|
|
|
|
28
|
0
|
|
|
|
|
0
|
my $file = File::Spec->catfile( $archive, $extra_dir, $upload->{ident} ); |
29
|
|
|
|
|
|
|
|
30
|
0
|
|
|
|
|
0
|
my $dir = File::Spec->catfile( $archive, $extra_dir ); |
31
|
0
|
|
|
|
|
0
|
File::Path::mkpath( $dir ); |
32
|
|
|
|
|
|
|
|
33
|
0
|
0
|
|
|
|
0
|
open( FH, ">", $file ) or die "Error unable to open $file: $!"; |
34
|
0
|
|
|
|
|
0
|
binmode FH; |
35
|
|
|
|
|
|
|
|
36
|
0
|
|
|
|
|
0
|
my( $buffer, $buffer_size ) = ( '', 14096 ); |
37
|
0
|
|
|
|
|
0
|
while ( read( $upload->{filehandle}, $buffer, $buffer_size ) ) { |
38
|
0
|
|
|
|
|
0
|
print FH $buffer; |
39
|
|
|
|
|
|
|
} |
40
|
0
|
|
|
|
|
0
|
close FH; |
41
|
|
|
|
|
|
|
|
42
|
0
|
|
|
|
|
0
|
my $h = { |
43
|
|
|
|
|
|
|
"$field" => $file, |
44
|
|
|
|
|
|
|
"${field}_ident" => $upload->{ident}, |
45
|
|
|
|
|
|
|
"${field}_suffix" => $upload->{suffix}, |
46
|
|
|
|
|
|
|
"${field}_mime" => $upload->{mime}, |
47
|
|
|
|
|
|
|
"${field}_name" => $upload->{name}, |
48
|
|
|
|
|
|
|
"${field}_size" => $upload->{size}, |
49
|
|
|
|
|
|
|
}; |
50
|
|
|
|
|
|
|
|
51
|
0
|
0
|
|
|
|
0
|
$h->{"${field}_directory"} = $extra_dir if $extra_dir; |
52
|
|
|
|
|
|
|
|
53
|
0
|
|
|
|
|
0
|
return( $h ); |
54
|
|
|
|
|
|
|
|
55
|
|
|
|
|
|
|
} |
56
|
|
|
|
|
|
|
|
57
|
|
|
|
|
|
|
# If a field is a date and its value is false, make it undef. |
58
|
|
|
|
|
|
|
sub clean_dates { |
59
|
0
|
|
|
0
|
1
|
0
|
my ( $params, $fields ) = @_; |
60
|
|
|
|
|
|
|
|
61
|
0
|
|
|
|
|
0
|
foreach my $field ( @{ $fields } ) { |
|
0
|
|
|
|
|
0
|
|
62
|
0
|
|
|
|
|
0
|
my $name = $field->{name}; |
63
|
|
|
|
|
|
|
|
64
|
0
|
0
|
0
|
|
|
0
|
if ( ( $field->{is} eq 'date' ) |
65
|
|
|
|
|
|
|
and |
66
|
|
|
|
|
|
|
( not $params->{ $name } ) |
67
|
|
|
|
|
|
|
) |
68
|
|
|
|
|
|
|
{ |
69
|
0
|
|
|
|
|
0
|
$params->{ $name } = undef; |
70
|
|
|
|
|
|
|
} |
71
|
|
|
|
|
|
|
} |
72
|
|
|
|
|
|
|
} |
73
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
# build the profile that Data::FormValidator wants |
75
|
|
|
|
|
|
|
sub form_profile { |
76
|
2
|
|
|
2
|
1
|
1636
|
my ( $form_fields ) = @_; |
77
|
2
|
|
|
|
|
4
|
my @required; |
78
|
|
|
|
|
|
|
my @optional; |
79
|
0
|
|
|
|
|
0
|
my %constraints; |
80
|
|
|
|
|
|
|
|
81
|
2
|
|
|
|
|
3
|
foreach my $item ( @{ $form_fields } ) { |
|
2
|
|
|
|
|
8
|
|
82
|
6
|
100
|
66
|
|
|
36
|
if ( defined $$item{optional} and $$item{optional} ) { |
|
|
50
|
33
|
|
|
|
|
83
|
2
|
|
|
|
|
5
|
push @optional, $$item{name}; |
84
|
|
|
|
|
|
|
} |
85
|
|
|
|
|
|
|
elsif ( defined $$item{type} and $$item{type} eq 'display' ) { |
86
|
0
|
|
|
|
|
0
|
push @optional, $$item{name}; |
87
|
|
|
|
|
|
|
} |
88
|
|
|
|
|
|
|
else { |
89
|
4
|
|
|
|
|
8
|
push @required, $$item{name}; |
90
|
|
|
|
|
|
|
} |
91
|
|
|
|
|
|
|
|
92
|
6
|
100
|
66
|
|
|
31
|
if ( defined $$item{constraint} and $$item{constraint} ) { |
93
|
1
|
|
|
|
|
5
|
$constraints{ $$item{name} } = $$item{constraint}; |
94
|
|
|
|
|
|
|
} |
95
|
|
|
|
|
|
|
} |
96
|
|
|
|
|
|
|
|
97
|
2
|
|
|
|
|
4
|
my %retval; |
98
|
|
|
|
|
|
|
|
99
|
2
|
50
|
|
|
|
10
|
$retval{required} = \@required if @required; |
100
|
2
|
100
|
|
|
|
7
|
$retval{optional} = \@optional if @optional; |
101
|
2
|
100
|
|
|
|
8
|
$retval{constraint_methods} = \%constraints if ( keys %constraints ); |
102
|
|
|
|
|
|
|
|
103
|
2
|
|
|
|
|
10
|
return \%retval; |
104
|
|
|
|
|
|
|
} |
105
|
|
|
|
|
|
|
|
106
|
|
|
|
|
|
|
# If a field's type is not boolean, and its value is false, make that |
107
|
|
|
|
|
|
|
# value undef. |
108
|
|
|
|
|
|
|
sub clean_params { |
109
|
0
|
|
|
0
|
1
|
|
my ( $params, $fields ) = @_; |
110
|
|
|
|
|
|
|
|
111
|
0
|
|
|
|
|
|
foreach my $p ( keys %{ $params } ) { |
|
0
|
|
|
|
|
|
|
112
|
0
|
0
|
|
|
|
|
delete( $params->{$p} ) if $p =~ /^\./; |
113
|
|
|
|
|
|
|
} |
114
|
|
|
|
|
|
|
|
115
|
|
|
|
|
|
|
FIELD: |
116
|
0
|
|
|
|
|
|
foreach my $field ( @{ $fields } ) { |
|
0
|
|
|
|
|
|
|
117
|
0
|
|
|
|
|
|
my $name = $field->{name}; |
118
|
|
|
|
|
|
|
|
119
|
0
|
0
|
|
|
|
|
next FIELD unless ( defined $field->{ is } ); |
120
|
0
|
0
|
|
|
|
|
next FIELD unless ( defined $field->{ name } ); |
121
|
0
|
0
|
|
|
|
|
next FIELD unless ( defined $params->{ $name } ); |
122
|
|
|
|
|
|
|
|
123
|
0
|
0
|
0
|
|
|
|
if ( $field->{ is } =~ /^varchar/i and $params->{ $name } eq '' ) { |
|
|
0
|
0
|
|
|
|
|
|
|
0
|
0
|
|
|
|
|
124
|
0
|
|
|
|
|
|
$params->{ $name } = undef; |
125
|
|
|
|
|
|
|
} |
126
|
|
|
|
|
|
|
elsif ( $field->{ is } =~ /^int/i and $params->{ $name } eq '' ) { |
127
|
0
|
|
|
|
|
|
$params->{ $name } = undef; |
128
|
|
|
|
|
|
|
} |
129
|
|
|
|
|
|
|
elsif ( ( $field->{is} !~ /^bool/i and $field->{is} !~ /^int/i ) |
130
|
|
|
|
|
|
|
and |
131
|
|
|
|
|
|
|
( not $params->{ $name } ) |
132
|
|
|
|
|
|
|
) |
133
|
|
|
|
|
|
|
{ |
134
|
0
|
|
|
|
|
|
$params->{ $name } = undef; |
135
|
|
|
|
|
|
|
} |
136
|
|
|
|
|
|
|
} |
137
|
|
|
|
|
|
|
} |
138
|
|
|
|
|
|
|
|
139
|
|
|
|
|
|
|
my %action_offset = ( |
140
|
|
|
|
|
|
|
add => 0, |
141
|
|
|
|
|
|
|
retrieve => 1, |
142
|
|
|
|
|
|
|
edit => 2, |
143
|
|
|
|
|
|
|
delete => 3, |
144
|
|
|
|
|
|
|
); |
145
|
|
|
|
|
|
|
|
146
|
|
|
|
|
|
|
# Full permissions bits: |
147
|
|
|
|
|
|
|
# 123456789 1 |
148
|
|
|
|
|
|
|
# crudcrudcrud |
149
|
|
|
|
|
|
|
|
150
|
|
|
|
|
|
|
sub verify_permission { |
151
|
0
|
|
|
0
|
1
|
|
my $opts = shift; |
152
|
|
|
|
|
|
|
|
153
|
0
|
|
|
|
|
|
my $site = $opts->{ site }; |
154
|
0
|
|
|
|
|
|
my $row = $opts->{ row }; |
155
|
0
|
|
|
|
|
|
my $permissions = $opts->{ permissions }; |
156
|
0
|
|
|
|
|
|
my $action = $opts->{ action }; |
157
|
0
|
|
0
|
|
|
|
my $params = $opts->{ params } || {}; # default for delete |
158
|
|
|
|
|
|
|
|
159
|
0
|
0
|
|
|
|
|
if ( not defined $action ) { |
160
|
0
|
|
|
|
|
|
$action = $site->action(); |
161
|
0
|
|
|
|
|
|
$action =~ s/^do_//; |
162
|
|
|
|
|
|
|
} |
163
|
|
|
|
|
|
|
|
164
|
0
|
|
0
|
|
|
|
$permissions ||= $site->controller_config->{ permissions }; |
165
|
0
|
0
|
|
|
|
|
return if ( not defined $permissions ); # no permissions => every body in |
166
|
|
|
|
|
|
|
|
167
|
0
|
|
|
|
|
|
my $offset = $action_offset{ $action }; |
168
|
0
|
|
|
|
|
|
my $action_bit = substr 'crud', $offset, 1; |
169
|
|
|
|
|
|
|
|
170
|
0
|
|
|
|
|
|
my $owner_bit = substr $permissions->{ bits }, $offset, 1; |
171
|
0
|
|
|
|
|
|
my $group_bit = substr $permissions->{ bits }, $offset + 4, 1; |
172
|
0
|
|
|
|
|
|
my $other_bit = substr $permissions->{ bits }, $offset + 8, 1; |
173
|
|
|
|
|
|
|
|
174
|
|
|
|
|
|
|
# there are three ways you could be allowed to add, if permissions |
175
|
|
|
|
|
|
|
# are in use |
176
|
|
|
|
|
|
|
# 1. You are not logged in, but the other block has perm bit |
177
|
|
|
|
|
|
|
# 2. You are logged in and the user block has perm bit |
178
|
|
|
|
|
|
|
# 3. You are logged in and belong to the tables group which has perm bit |
179
|
|
|
|
|
|
|
|
180
|
0
|
|
|
|
|
|
my $user_row = $site->auth_user_row; |
181
|
0
|
|
|
|
|
|
my $user_id = $user_row->id; |
182
|
|
|
|
|
|
|
|
183
|
0
|
0
|
0
|
|
|
|
if ( $action eq 'add' ) { |
|
|
0
|
|
|
|
|
|
184
|
|
|
|
|
|
|
# For add, set the id in case we need it. Anonymous users get id 0. |
185
|
0
|
|
0
|
|
|
|
$params->{ user_id } = $user_id || 0; |
186
|
|
|
|
|
|
|
|
187
|
|
|
|
|
|
|
# is user logged in? if so an owner_bit will work |
188
|
0
|
0
|
0
|
|
|
|
return if ( $user_id |
189
|
|
|
|
|
|
|
and |
190
|
|
|
|
|
|
|
$owner_bit eq $action_bit |
191
|
|
|
|
|
|
|
); |
192
|
|
|
|
|
|
|
} |
193
|
|
|
|
|
|
|
elsif ( $action eq 'edit' or $action eq 'delete' ) { |
194
|
0
|
|
|
|
|
|
delete $params->{ user_id }; # no form spoofing to change owner |
195
|
|
|
|
|
|
|
|
196
|
0
|
0
|
0
|
|
|
|
return if ( $user_id and $user_id eq $row->user_id |
|
|
|
0
|
|
|
|
|
197
|
|
|
|
|
|
|
and |
198
|
|
|
|
|
|
|
$owner_bit eq $action_bit |
199
|
|
|
|
|
|
|
); |
200
|
|
|
|
|
|
|
} |
201
|
|
|
|
|
|
|
|
202
|
|
|
|
|
|
|
# group work here |
203
|
0
|
|
|
|
|
|
my $member_of = $site->auth_user_groups; |
204
|
|
|
|
|
|
|
|
205
|
|
|
|
|
|
|
return if ( $permissions->{ group } |
206
|
|
|
|
|
|
|
and |
207
|
|
|
|
|
|
|
$member_of->{ $permissions->{ group } } |
208
|
|
|
|
|
|
|
and |
209
|
0
|
0
|
0
|
|
|
|
$group_bit eq $action_bit |
|
|
|
0
|
|
|
|
|
210
|
|
|
|
|
|
|
); |
211
|
|
|
|
|
|
|
|
212
|
|
|
|
|
|
|
# last chance, is it open to all? |
213
|
0
|
0
|
|
|
|
|
return if $other_bit eq $action_bit; |
214
|
|
|
|
|
|
|
|
215
|
0
|
0
|
|
|
|
|
if ( $action eq 'add' ) { |
|
|
0
|
|
|
|
|
|
|
|
0
|
|
|
|
|
|
216
|
0
|
|
|
|
|
|
die "You are not authorized to add records here.\n"; |
217
|
|
|
|
|
|
|
} |
218
|
|
|
|
|
|
|
elsif ( $action eq 'edit' ) { |
219
|
0
|
|
|
|
|
|
die "You are not authorized to edit this record.\n"; |
220
|
|
|
|
|
|
|
} |
221
|
|
|
|
|
|
|
elsif ( $action eq 'delete' ) { |
222
|
0
|
|
|
|
|
|
die "You are not authorzied to delete this record.\n"; |
223
|
|
|
|
|
|
|
} |
224
|
|
|
|
|
|
|
} # end of verify_permissions |
225
|
|
|
|
|
|
|
|
226
|
|
|
|
|
|
|
1; |
227
|
|
|
|
|
|
|
|
228
|
|
|
|
|
|
|
__END__ |