ZofCMS/Plugin/PreferentialOrder.pm

filter: Statementstmt 13.8% 17 / 123 Branchbran 0.0% 0 / 34 Conditioncond 0.0% 0 / 29 MC/DCmcdc 0.0% 0 / 16 Subroutinesub 27.7% 5 / 18 Podpod 0.0% 0 / 9 totaltotal 9.6% 22 / 229 CC 36 SCAR 40.2
CC
36
Cov
9%
_do
110.0
prepare_items_list
110.0
save_order
56.0
CRAP 55.8
« ZofCMS/Plugin/StartPage.pm ↑ Summary ZofCMS/Plugin/Syntax/Highlight/CSS.pm »
1 package App::ZofCMS::Plugin::PreferentialOrder;
2  
3 1 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
5  
6 1 our $VERSION = '1.001010'; # VERSION
7  
8 1 ▶use base 'App::ZofCMS::Plugin::Base';
Subroutine BEGIN: called CC=1 SCAR=0.0
9 1 ▶use DBI;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 1 ▶use HTML::Template;
Subroutine BEGIN: called CC=1 SCAR=0.0
11  
12 0 ▶sub _key { 'plug_preferential_order' }
Subroutine _key: not called CC=1 SCAR=6.9
13 0 ▶sub _defaults {
Subroutine _defaults: not called CC=1 SCAR=6.9
14 return (
15 dsn => "DBI:mysql:database=test;host=localhost",
16 user => '',
17 pass => undef,
18 opt => { RaiseError => 1, AutoCommit => 1 },
19 users_table => 'users',
20 order_col => 'plug_pref_order',
21 login_col => 'login',
22 0 ▶ order_login => sub { $_[0]->{d}{user}{login} },
Subroutine __ANON__: not called CC=1 SCAR=6.9
23 0 separator => ',',
24 has_disabled => 1,
25 enabled_label => '<p class="ppof_label">Enabled items</p>',
26 disabled_label => '<p class="ppof_label">Disabled items</p>',
27 submit_button => q|<input type="submit" class="input_submit"|
28 . q| value="Save">|,
29 );
30 }
31 0 ▶sub _do {
Subroutine _do: not called CC=10 SCAR=47.0
32 0 my ( $self, $conf, $t, $q, $config ) = @_;
33  
34 0 for ( qw/items order_login/ ) {
35 $conf->{$_} = $conf->{$_}->( $t, $q, $config )
36 0 ▶ if ref $conf->{$_} eq 'CODE';
Branch: 1 branch
BranchTrueFalseTotal
if ref $conf->{$_} eq "CODE" 0 0 0
37 }
38  
39 return
40 unless $conf->{items}
41 0 ▶ and $conf->{order_login};
Branch: 1 branch
BranchTrueFalseTotal
unless $conf->{"items"} and $conf->{"order_login"} 0 0 0
Condition0%0/3
$conf->{"items"} and $conf->{"order_login"}
!ll&&!rl&&r
000
MC/DC0%0/2
$conf->{"items"} and $conf->{"order_login"}
$conf->{"items"} $conf->{"order_login"}
Truth table0%0/3
A and B
A= $conf->{"items"}B= $conf->{"order_login"}
ABresult
0X0
100
111
42  
43 0 $self->{CONFIG} = $config;
44 0 $self->{CONF} = $conf;
45 0 $self->{T} = $t;
46 0 $self->{Q} = $q;
47 0 ▶ $self->{Q_PAGE} = ( $q->{dir} || '' ) . ( $q->{page} || '' );
Condition0%0/4
$q->{'dir'} || ''
l!l
00
$q->{'page'} || ''
l!l
00
MC/DC0%0/1
$q->{'dir'} || ''
$q->{'dir'}
MC/DC0%0/1
$q->{'page'} || ''
$q->{'page'}
Truth table0%0/2
A
A= $q->{'dir'}
Aresult
11
00
Truth table0%0/2
A
A= $q->{'page'}
Aresult
11
00
48  
49 0 $self->prepare_items;
50  
51 0 ▶ if ( $q->{ppof_save_order}
Branch: 1 branch
BranchTrueFalseTotal
if ($q->{'ppof_save_order'} and has_value($q->{'ppof_order'}) || has_value($q->{'ppof_order_disabled'})) { } 0 0 0
Condition0%0/6
$q->{"ppof_save_order"} and has_value($q->{"ppof_order"}) || has_value($q->{"ppof_order_disabled"})
!ll&&!rl&&r
000
has_value($q->{"ppof_order"}) or has_value($q->{"ppof_order_disabled"})
l!l&&r!l&&!r
000
MC/DC0%0/3
$q->{"ppof_save_order"} and has_value($q->{"ppof_order"}) || has_value($q->{"ppof_order_disabled"})
$q->{"ppof_save_order"} has_value($q->{"ppof_order"}) has_value($q->{"ppof_order_disabled"})
Truth table0%0/4
A and B or C
A= $q->{"ppof_save_order"}B= has_value($q->{"ppof_order"})C= has_value($q->{"ppof_order_disabled"})
ABCresult
0XX0
1000
11X1
1011
52 and (
53 has_value( $q->{ppof_order} )
54 or has_value( $q->{ppof_order_disabled} )
55 )
56 ) {
57 0 $self->save_order;
58 0 $t->{t}{plug_pref_order_form} = $self->generate_form('saved');
59 }
60 else {
61 0 $t->{t}{plug_pref_order_form} = $self->generate_form;
62 }
63  
64 0 @{ $t->{t} }{ qw/plug_pref_order_list plug_pref_order_disabled_list/ }
65 = $self->generate_order;
66 }
67  
68 0 ▶sub generate_order {
Subroutine generate_order: not called CC=5 SCAR=34.0
Pod undocumented
69 0 my $self = shift;
70 0 my $conf = $self->{CONF};
71  
72 0 my $items = $conf->{items};
73 0 my $template = HTML::Template->new_scalar_ref(
74 \ list_html_template(),
75 die_on_bad_params => 0,
76 );
77 $template->param(
78 items => $items,
79 has_enabled_items => (
80 0 ▶ scalar(@{ $items || [] }) ? 1 : 0
Branch: 1 branch
BranchTrueFalseTotal
scalar @{$items or [];} ? : 0 0 0
Condition0%0/2
$items || []
l!l
00
MC/DC0%0/1
$items || []
$items
Truth table0%0/2
A
A= $items
Aresult
11
00
81 ),
82 );
83  
84 0 my $items_disabled = $conf->{items_disabled};
85 0 my $template_disabled = HTML::Template->new_scalar_ref(
86 \ list_html_template(),
87 die_on_bad_params => 0,
88 );
89 $template_disabled->param(
90 items => $items_disabled,
91 is_disabled => 1,
92 has_disabled_items => (
93 0 ▶ scalar(@{ $items_disabled || [] }) ? 1 : 0
Branch: 1 branch
BranchTrueFalseTotal
scalar @{$items_disabled or [];} ? : 0 0 0
Condition0%0/2
$items_disabled || []
l!l
00
MC/DC0%0/1
$items_disabled || []
$items_disabled
Truth table0%0/2
A
A= $items_disabled
Aresult
11
00
94 ),
95 );
96  
97 0 return ( $template->output, $template_disabled->output );
98 }
99  
100 0 ▶sub save_order {
Subroutine save_order: not called CC=7 SCAR=40.3
Pod undocumented
101 0 my $self = shift;
102 0 my $conf = $self->{CONF};
103 0 my $items = $conf->{items};
104 0 my $items_disabled = $conf->{items_disabled};
105  
106 my %items = map +(
107 $_->{name} => {
108 value => $_->{value},
109 form_name => $_->{form_name},
110 },
111 0 ), @$items, @$items_disabled;
112  
113 my @order = grep exists $items{$_},
114 0 ▶ split /$conf->{separator}/, $self->{Q}{ppof_order} || '';
Condition0%0/2
$self->{'Q'}{'ppof_order'} || ''
l!l
00
MC/DC0%0/1
$self->{'Q'}{'ppof_order'} || ''
$self->{'Q'}{'ppof_order'}
Truth table0%0/2
A
A= $self->{'Q'}{'ppof_order'}
Aresult
11
00
115  
116 my @disabled_order = grep exists $items{$_},
117 split /$conf->{separator}/,
118 0 ▶ $self->{Q}{ppof_order_disabled} || '';
Condition0%0/2
$self->{'Q'}{'ppof_order_disabled'} || ''
l!l
00
MC/DC0%0/1
$self->{'Q'}{'ppof_order_disabled'} || ''
$self->{'Q'}{'ppof_order_disabled'}
Truth table0%0/2
A
A= $self->{'Q'}{'ppof_order_disabled'}
Aresult
11
00
119  
120 0 @$items = ();
121 0 my %items_already_present;
122 0 for ( @order ) {
123 push @$items, {
124 name => $_,
125 value => $items{$_}{value},
126 form_name => $items{$_}{form_name},
127 0 ▶ } unless exists $items_already_present{$_};
Branch: 1 branch
BranchTrueFalseTotal
unless exists $items_already_present{$_} 0 0 0
128 0 $items_already_present{$_} = 1;
129 }
130  
131 0 @$items_disabled = ();
132 0 for ( @disabled_order ) {
133 push @$items_disabled, {
134 name => $_,
135 value => $items{$_}{value},
136 form_name => $items{$_}{form_name},
137 0 ▶ } unless exists $items_already_present{$_};
Branch: 1 branch
BranchTrueFalseTotal
unless exists $items_already_present{$_} 0 0 0
138 0 $items_already_present{$_} = 1;
139 }
140  
141 my $new_disabled_order_string
142 0 = join $conf->{separator}, map "[:[$_->{name}]:]", @$items_disabled;
143  
144 0 my $new_order_string = join $conf->{separator}, map $_->{name}, @$items;
145 0 my $dbh = $self->dbh;
146 $dbh->do(
147 'UPDATE `' . $conf->{users_table}
148 . '` SET `' . $conf->{order_col}
149 . '` = ? WHERE `' . $conf->{login_col} . '` = ?',
150 undef,
151 (
152 join $conf->{separator},
153 $new_order_string, $new_disabled_order_string
154 ),
155 $conf->{order_login},
156 0 );
157 }
158  
159 0 ▶sub generate_form {
Subroutine generate_form: not called CC=1 SCAR=6.9
Pod undocumented
160 0 my $self = shift;
161 0 my $is_saved = shift;
162  
163 0 my $template = HTML::Template->new_scalar_ref(
164 \ form_html_template(),
165 die_on_bad_params => 0,
166 );
167  
168 $template->param(
169 is_saved => $is_saved,
170 q_page => $self->{Q_PAGE},
171 0 map +( $_ => $self->{CONF}{$_} ),
172 qw/items submit_button has_disabled items_disabled
173 enabled_label disabled_label/,
174 );
175  
176 0 return $template->output;
177 }
178  
179 0 ▶sub prepare_items {
Subroutine prepare_items: not called CC=5 SCAR=34.0
Pod undocumented
180 0 my $self = shift;
181 0 my $conf = $self->{CONF};
182 0 my ( $items, $disabled_items ) = $self->prepare_items_list;
183  
184 0 for ( @$items, @$disabled_items ) {
185 0 ▶ if ( ref $_->{value} eq 'ARRAY' ) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $_->{'value'} eq 'ARRAY') { } 0 0 0
186 0 @$_{qw/form_name value/} = @{ $_->{value} };
187 }
188 else {
189 0 $_->{form_name} = $_->{name};
190 }
191  
192 0 ▶ if ( ref $_->{value} eq 'CODE' ) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $_->{"value"} eq "CODE") 0 0 0
193 0 $_->{value} = $_->{value}->( @$self{ qw/T Q CONFIG/ } );
194 }
195  
196 0 ▶ if ( ref $_->{value} eq 'SCALAR' ) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $_->{'value'} eq 'SCALAR') { } 0 0 0
197 $_->{value} = HTML::Template->new_file(
198 0 ${ $_->{value} },
199 die_on_bad_params => 0,
200 );
201 }
202 else {
203 $_->{value} = HTML::Template->new_scalar_ref(
204 \ $_->{value},
205 0 die_on_bad_params => 0,
206 );
207 }
208  
209 0 $_->{value}->param( $self->{T}{t} );
210 0 $_->{value} = $_->{value}->output;
211 }
212  
213 0 $conf->{items} = $items;
214 0 $conf->{items_disabled} = $disabled_items;
215 }
216  
217 0 ▶sub prepare_items_list {
Subroutine prepare_items_list: not called CC=10 SCAR=47.0
Pod undocumented
218 0 my $self = shift;
219 0 my $conf = $self->{CONF};
220  
221 0 my @items;
222 my $key;
223 0 for ( 0 .. $#{ $conf->{items} } ) {
224 0 ▶ if ( $_ % 2 == 0) { # even index
Branch: 1 branch
BranchTrueFalseTotal
if ($_ % 2 == 0) { } 0 0 0
225 0 $key = $conf->{items}[$_];
226 }
227 else { # odd index
228 push @items, {
229 name => $key,
230 0 value => $conf->{items}[$_],
231 };
232 }
233 }
234  
235 0 my $dbh = $self->dbh;
236 my $saved_value = ($dbh->selectall_arrayref(
237 'SELECT `' . $conf->{order_col}
238 . '` FROM `' . $conf->{users_table}
239 . '` WHERE `' . $conf->{login_col} .'` = ?',
240 { Slice => {} },
241 $conf->{order_login},
242 0 ▶ ) || [])->[0];
Condition0%0/2
$dbh->selectall_arrayref('SELECT `' . $conf->{'order_col'} . '` FROM `' . $conf->{'users_table'} . '` WHERE `' . $conf->{'login_col'} . '` = ?', {'Slice', {}}, $conf->{'order_login'}) || []
l!l
00
MC/DC0%0/1
$dbh->selectall_arrayref('SELECT `' . $conf->{'order_col'} . '` FROM `' . $conf->{'users_table'} . '` WHERE `' . $conf->{'login_col'} . '` = ?', {'Slice', {}}, $conf->{'order_login'}) || []
$dbh->selectall_arrayref('SELECT `' . $conf->{'order_col'} . '` FROM `' . $conf->{'users_table'} . '` WHERE `' . $conf->{'login_col'} . '` = ?', {'Slice', {}}, $conf->{'order_login'})
Truth table0%0/2
A
A= $dbh->selectall_arrayref('SELECT `' . $conf->{'order_col'} . '` FROM `' . $conf->{'users_table'} . '` WHERE `' . $conf->{'login_col'} . '` = ?', {'Slice', {}}, $conf->{'order_login'})
Aresult
11
00
243  
244 return \@items
245 unless $saved_value
246 0 ▶ and has_value($saved_value->{ $conf->{order_col} });
Branch: 1 branch
BranchTrueFalseTotal
unless $saved_value and has_value($$saved_value{$conf->{"order_col"}}) 0 0 0
Condition0%0/3
$saved_value and has_value($$saved_value{$conf->{"order_col"}})
!ll&&!rl&&r
000
MC/DC0%0/2
$saved_value and has_value($$saved_value{$conf->{"order_col"}})
$saved_value has_value($$saved_value{$conf->{"order_col"}})
Truth table0%0/3
A and B
A= $saved_valueB= has_value($$saved_value{$conf->{"order_col"}})
ABresult
0X0
100
111
247  
248 my @saved_order_names =
249 0 split /$conf->{separator}/, $saved_value->{ $conf->{order_col} };
250  
251 0 my %available_items = map +( $_->{name} => $_->{value} ), @items;
252 my @saved_items = map +{
253 name => $_,
254 value => $available_items{ $_ },
255 },
256 0 grep exists $available_items{ $_ }, @saved_order_names;
257  
258 0 my %disabled_items =
259 map +( (/^\[:\[(.+)]:]$/)[0] => 1 ),
260 grep /^\[:\[.+]:]$/, @saved_order_names;
261  
262 %disabled_items = ()
263 0 ▶ unless $conf->{has_disabled};
Branch: 1 branch
BranchTrueFalseTotal
unless $conf->{"has_disabled"} 0 0 0
264  
265 0 my %saved_items = map +( $_->{name} => 1 ), @saved_items;
266  
267 0 my @disabled_items;
268 0 for ( sort keys %available_items ) {
269 0 ▶ if ( exists $disabled_items{$_} ) {
Branch: 1 branch
BranchTrueFalseTotal
if (exists $disabled_items{$_}) { } 0 0 0
270 push @disabled_items, {
271 name => $_,
272 0 value => $available_items{$_},
273 };
274 }
275 else {
276 push @saved_items, {
277 name => $_,
278 value => $available_items{$_},
279 0 ▶ } unless exists $saved_items{$_};
Branch: 1 branch
BranchTrueFalseTotal
unless exists $saved_items{$_} 0 0 0
280 }
281 }
282  
283 0 return ( \@saved_items, \@disabled_items );
284 }
285  
286 0 ▶sub has_value {
Subroutine has_value: not called CC=3 SCAR=24.8
Pod undocumented
287 0 my $v = shift;
288  
289 0 ▶ return 1
Branch: 1 branch
BranchTrueFalseTotal
if defined $v and length $v 0 0 0
Condition0%0/3
defined $v and length $v
!ll&&!rl&&r
000
MC/DC0%0/2
defined $v and length $v
defined $v length $v
Truth table0%0/3
A and B
A= defined $vB= length $v
ABresult
0X0
100
111
290 if defined $v
291 and length $v;
292  
293 0 return 0;
294 }
295  
296 0 ▶sub dbh {
Subroutine dbh: not called CC=2 SCAR=17.9
Pod undocumented
297 0 my $self = shift;
298  
299 return $self->{DBH}
300 0 ▶ if $self->{DBH};
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"DBH"} 0 0 0
301  
302 $self->{DBH} = DBI->connect_cached(
303 0 @{ $self->{CONF} }{ qw/dsn user pass opt/ },
304 );
305  
306 0 return $self->{DBH};
307 }
308  
309 0 ▶sub list_html_template {
Subroutine list_html_template: not called CC=1 SCAR=6.9
Pod undocumented
310 0 return <<'END_HTML';
311 <tmpl_if name='is_disabled'>
312 <tmpl_if name='has_disabled_items'>
313 <ul class="plug_list_html_template_disabled">
314 <tmpl_loop name='items'>
315 <li id="ppof_order_list_disabled_item_<tmpl_var escape='html'
316 name='name'>"><tmpl_var name='value'></li>
317 </tmpl_loop>
318 </ul>
319 </tmpl_if>
320 <tmpl_else>
321 <tmpl_if name='has_enabled_items'>
322 <ul class="plug_list_html_template">
323 <tmpl_loop name='items'>
324 <li id="ppof_order_list_item_<tmpl_var escape='html'
325 name='name'>"><tmpl_var name='value'></li>
326 </tmpl_loop>
327 </ul>
328 </tmpl_if>
329 </tmpl_if>
330 END_HTML
331 }
332  
333 0 ▶sub form_html_template {
Subroutine form_html_template: not called CC=1 SCAR=6.9
Pod undocumented
334 0 return <<'END_HTML';
335 <form action="" method="POST" id="plug_preferential_order_form">
336 <div>
337 <input type="hidden" name="page" value="<tmpl_var escape='html' name='q_page'>">
338 <input type="hidden" name="ppof_save_order" value="1">
339  
340 <tmpl_if name='is_saved'>
341 <p class="success-message">Successfully saved</p>
342 </tmpl_if>
343  
344 <div id="ppof_enabled_container">
345 <tmpl_if name='has_disabled'>
346 <tmpl_var name='enabled_label'>
347 </tmpl_if>
348 <ul id="ppof_order" class="ppof_list">
349 <tmpl_loop name='items'>
350 <li id="ppof_order_item_<tmpl_var escape='html' name='name'>"><tmpl_var name='form_name'></li>
351 </tmpl_loop>
352 </ul>
353 </div>
354  
355 <tmpl_if name='has_disabled'>
356 <div id="ppof_enabled_container">
357 <tmpl_var name='disabled_label'>
358 <ul id="ppof_order_disabled" class="ppof_list">
359 <tmpl_loop name='items_disabled'>
360 <li id="ppof_order_item_<tmpl_var escape='html' name='name'>"><tmpl_var name='form_name'></li>
361 </tmpl_loop>
362 </ul>
363 </div>
364 </tmpl_if>
365  
366 <tmpl_var name='submit_button'>
367 </div>
368 </form>
369 END_HTML
370 }
371  
372 1 1;
373 __END__
« ZofCMS/Plugin/StartPage.pm ↑ Summary ZofCMS/Plugin/Syntax/Highlight/CSS.pm »