Lazy/Widget.pm

filter: Statementstmt 8.8% 28 / 318 Branchbran 0.0% 0 / 100 Conditioncond 0.0% 0 / 9 MC/DCmcdc 0.0% 0 / 5 Subroutinesub 20.0% 9 / 45 Podpod 18.1% 6 / 33 totaltotal 8.4% 43 / 510 CC 78 SCAR 40.7
CC
78
Cov
7%
select
240.0
dbwrite
90.0
deletes
72.0
CRAP 58.8
« Lazy/Widget/Controller.pm ↑ Summary Lazy/Session/Data.pm »
1 package CGI::Lazy::Widget;
2  
3 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4  
5 1 ▶use JSON;
Subroutine BEGIN: called CC=1 SCAR=0.0
6 1 ▶use Tie::IxHash;
Subroutine BEGIN: called CC=1 SCAR=0.0
7 1 ▶use CGI::Lazy::Globals;
Subroutine BEGIN: called CC=1 SCAR=0.0
8 1 ▶use CGI::Lazy::Widget::Dataset;
Subroutine BEGIN: called CC=1 SCAR=0.0
9 1 ▶use CGI::Lazy::Widget::DomLoader;
Subroutine BEGIN: called CC=1 SCAR=0.0
10 1 ▶use CGI::Lazy::Widget::Composite;
Subroutine BEGIN: called CC=1 SCAR=0.0
11 1 ▶use CGI::Lazy::Widget::Controller;
Subroutine BEGIN: called CC=1 SCAR=0.0
12  
13 #----------------------------------------------------------------------------------------
14 0 ▶sub ajaxBlank {
Subroutine ajaxBlank: not called CC=1 SCAR=6.9
Pod documented
15 0 my $self = shift;
16 0 my %args = @_;
17  
18 0 $args{mode} = 'blank';
19  
20 0 return $self->rawContents(%args);
21 }
22  
23 #----------------------------------------------------------------------------------------
24 0 ▶sub ajaxReturn {
Subroutine ajaxReturn: not called CC=5 SCAR=34.0
Pod documented
25 0 my $self = shift;
26 0 my $widgets = shift;
27 0 my $data = shift;
28  
29 0 ▶ my @widgetlist = ref $widgets eq 'ARRAY' ? @$widgets : ($widgets);
Branch: 1 branch
BranchTrueFalseTotal
ref $widgets eq 'ARRAY' ? : 0 0 0
30 0 ▶ my @datalist = ref $data eq 'ARRAY' ? @$data : ($data);
Branch: 1 branch
BranchTrueFalseTotal
ref $data eq 'ARRAY' ? : 0 0 0
31  
32 0 my $outgoingdata;
33 0 $outgoingdata .= $_ for @datalist;
34  
35 0 my $validator = {};
36  
37 0 $validator->{$_->widgetID} = $_->validator for @widgetlist;
38  
39 0 my $json = to_json($validator);
40  
41 0 return '{"validator" : '.$json.', "html" : "'.$outgoingdata .'"}';
42  
43 }
44  
45 #----------------------------------------------------------------------------------------
46 0 ▶sub ajaxSelect {
Subroutine ajaxSelect: not called CC=1 SCAR=6.9
Pod documented
47 0 my $self = shift;
48 0 my %args = @_;
49  
50 0 my $output = $self->select(%args);
51  
52 0 return $self->ajaxReturn($self, $output);
53 }
54  
55 #----------------------------------------------------------------------------------------
56 0 ▶sub composite {
Subroutine composite: not called CC=1 SCAR=6.9
Pod undocumented
57 0 my $self = shift;
58 0 my $vars = shift;
59
60 0 return CGI::Lazy::Widget::Composite->new($self->q, $vars);
61 }
62  
63 #----------------------------------------------------------------------------------------
64 0 ▶sub config {
Subroutine config: not called CC=1 SCAR=6.9
Pod undocumented
65 0 my $self = shift;
66  
67 0 return $self->q->config;
68 }
69  
70 #----------------------------------------------------------------------------------------
71 0 ▶sub controller {
Subroutine controller: not called CC=1 SCAR=6.9
Pod undocumented
72 0 my $self = shift;
73 0 my $vars = shift;
74  
75 0 return CGI::Lazy::Widget::Controller->new($self->q, $vars);
76 }
77  
78 #----------------------------------------------------------------------------------------
79 0 ▶sub dataset {
Subroutine dataset: not called CC=1 SCAR=6.9
Pod undocumented
80 0 my $self = shift;
81 0 my $vars = shift;
82  
83 0 return CGI::Lazy::Widget::Dataset->new($self->q, $vars);
84 }
85  
86 #----------------------------------------------------------------------------------------
87 0 ▶sub db {
Subroutine db: not called CC=1 SCAR=6.9
Pod undocumented
88 0 my $self = shift;
89  
90 0 return $self->q->db;
91 }
92  
93 #----------------------------------------------------------------------------------------
94 0 ▶sub dbwrite {
Subroutine dbwrite: not called CC=9 SCAR=45.0
Pod undocumented
95 0 my $self = shift;
96 0 my %args = @_;
97  
98 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
99 0 foreach (@{$self->memberarray}) {
100 0 $_->dbwrite;
101 }
102 0 return;
103 }
104  
105 0 ▶ my %deleteargs = %{$args{delete}} if $args{delete};
Branch: 1 branch
BranchTrueFalseTotal
if $args{"delete"} 0 0 0
106 0 delete $args{delete};
107 0 ▶ my %updateargs = %{$args{update}} if $args{update};
Branch: 1 branch
BranchTrueFalseTotal
if $args{"update"} 0 0 0
108 0 delete $args{update};
109 0 ▶ my %insertargs = %{$args{insert}} if $args{insert};
Branch: 1 branch
BranchTrueFalseTotal
if $args{"insert"} 0 0 0
110 0 delete $args{insert};
111  
112 0 $deleteargs{$_} = $args{$_} for keys %args;
113 0 $updateargs{$_} = $args{$_} for keys %args;
114 0 $insertargs{$_} = $args{$_} for keys %args;
115  
116 0 $self->rundelete(%deleteargs);
117 0 $self->update(%updateargs);
118 0 $self->insert(%insertargs);
119  
120  
121 0 return;
122 }
123  
124 #----------------------------------------------------------------------------------------
125 0 ▶sub displaySelect {
Subroutine displaySelect: not called CC=5 SCAR=34.0
Pod undocumented
126 0 my $self = shift;
127 0 my %args = @_;
128  
129 0 my $vars = $args{vars};
130  
131 0 my @fields;
132 0 my $binds = [];
133  
134 # $self->q->util->debug->edump($incoming);
135  
136 0 foreach my $field (grep {!/vars/} keys %args) {
137 0 ▶ unless ($field =~ /['"&;]/) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($field =~ /['"&;]/) 0 0 0
138 0 ▶ if ($args{$field}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($args{$field}) 0 0 0
139 0 push @fields, $field." = ? ";
140 0 ▶ if (ref $args{$field}) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $args{$field}) { } 0 0 0
141 0 push @$binds, ${$args{$field}};
142 } else {
143 0 push @$binds, $args{$field};
144 }
145 }
146 }
147 }
148
149 0 my $bindstring = join ' and ', @fields;
150
151 0 $self->recordset->where($bindstring);
152  
153 # $self->q->util->debug->edump("bindstring: $bindstring binds: @$binds");
154  
155 0 return $self->display(mode => 'select', binds => $binds, vars => $vars );
156 }
157  
158 #----------------------------------------------------------------------------------------
159 0 ▶sub deletes {
Subroutine deletes: not called CC=8 SCAR=42.8
Pod undocumented
160 0 my $self = shift;
161  
162 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
163 0 foreach (@{$self->memberarray}) {
164 0 $_->deletes;
165 }
166 0 return;
167 }
168  
169 0 my $data;
170 0 my $widgetID = $self->vars->{id};
171  
172 0 foreach my $key (grep {/^$widgetID-:DELETE:/} $self->q->param) {
173 0 ▶ if ($key =~ /^($widgetID-:DELETE:)(.+)-:-(.+)::(\d+)$/) {
Branch: 2 branches
BranchTrueFalseTotal
if ($key =~ /^($widgetID-:DELETE:)(.+)-:-(.+)::(\d+)$/) { } 0 0 0
elsif ($key =~ /^($widgetID-:DELETE:)(.+)-:-(.+)$/) { } 0 0 0
174 0 my ($pre, $fieldname, $ID, $row) = ($1, $2, $3, $4);
175 0 ▶ $data->{$ID}->{$fieldname} = $self->q->param($key) if $self->q->param($key);
Branch: 1 branch
BranchTrueFalseTotal
if $self->q->param($key) 0 0 0
176 } elsif ($key =~ /^($widgetID-:DELETE:)(.+)-:-(.+)$/) {
177 0 my ($pre, $fieldname, $ID) = ($1, $2, $3);
178 0 ▶ $data->{$ID}->{$fieldname} = $self->q->param($key) if $self->q->param($key);
Branch: 1 branch
BranchTrueFalseTotal
if $self->q->param($key) 0 0 0
179 }
180 }
181 0 return $data;
182 }
183  
184 #----------------------------------------------------------------------------------------
185 0 ▶sub deleteIds {
Subroutine deleteIds: not called CC=2 SCAR=17.9
Pod undocumented
186 0 my $self = shift;
187  
188 0 my @deletes = sort keys %{$self->deletes};
189  
190 0 ▶ if (wantarray) {
Branch: 1 branch
BranchTrueFalseTotal
if (wantarray) { } 0 0 0
191 0 return @deletes;
192 } else {
193 0 return \@deletes;
194 }
195 }
196  
197 #----------------------------------------------------------------------------------------
198 0 ▶sub displayblank {
Subroutine displayblank: not called CC=1 SCAR=6.9
Pod undocumented
199 0 my $self = shift;
200  
201 0 return $self->display(mode => 'blank'); #run display function with blank argument
202 }
203  
204 #----------------------------------------------------------------------------------------
205 0 ▶sub domload {
Subroutine domload: not called CC=3 SCAR=24.8
Pod undocumented
206 0 my $self = shift;
207  
208 0 my $objectJs;
209  
210 0 foreach my $object (keys %{$self->vars->{objects};}) {
211 0 $objectJs .= "var $object = JSON.parse('".to_json($self->vars->{objects}->{$object})."');\n";
212 }
213  
214 0 ▶ $objectJs = $self->q->jswrap($objectJs) if $objectJs;
Branch: 1 branch
BranchTrueFalseTotal
if $objectJs 0 0 0
215  
216 0 return $objectJs;
217 }
218  
219 #----------------------------------------------------------------------------------------
220 0 ▶sub domloader {
Subroutine domloader: not called CC=1 SCAR=6.9
Pod undocumented
221 0 my $self = shift;
222 0 my $vars = shift;
223  
224 0 return CGI::Lazy::Widget::DomLoader->new($self->q, $vars);
225 }
226  
227 #----------------------------------------------------------------------------------------
228 0 ▶sub insert {
Subroutine insert: not called CC=3 SCAR=24.8
Pod undocumented
229 0 my $self = shift;
230 0 my %vars = @_;
231  
232 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
233 0 foreach (@{$self->memberarray}) {
234 0 $_->insert(%vars);
235 }
236 0 return;
237 }
238  
239 0 $self->recordset->insert($self->inserts, \%vars);
240 0 return;
241 }
242  
243 #----------------------------------------------------------------------------------------
244 0 ▶sub inserts {
Subroutine inserts: not called CC=8 SCAR=42.8
Pod undocumented
245 0 my $self = shift;
246  
247 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
248 0 foreach (@{$self->memberarray}) {
249 0 $_->inserts;
250 }
251 0 return;
252 }
253  
254 0 my $data = {};
255 0 tie %{$data}, 'Tie::IxHash';
256  
257 0 my $widgetID = $self->vars->{id};
258  
259 0 foreach my $key (sort _byWidgetRow grep {/^$widgetID-:INSERT:/} $self->q->param) {
260 0 ▶ if ($key =~ /^($widgetID-:INSERT:)(.+)--$/) {
Branch: 2 branches
BranchTrueFalseTotal
if ($key =~ /^($widgetID-:INSERT:)(.+)--$/) { } 0 0 0
elsif ($key =~ /^($widgetID-:INSERT:)(.+)--(\d+)$/) { } 0 0 0
261 # $self->q->util->debug->edump($key);
262 0 my ($pre, $field) = ($1, $2);
263 0 ▶ $data->{1}->{$field} = $self->q->param($key) if $self->q->param($key);
Branch: 1 branch
BranchTrueFalseTotal
if $self->q->param($key) 0 0 0
264 } elsif ($key =~ /^($widgetID-:INSERT:)(.+)--(\d+)$/) {
265 0 my ($pre, $field, $row) = ($1, $2, $3);
266 0 ▶ $data->{$row}->{$field} = $self->q->param($key) if $self->q->param($key);
Branch: 1 branch
BranchTrueFalseTotal
if $self->q->param($key) 0 0 0
267 # $self->q->util->debug->edump($field, $self->q->param($key)) if $self->q->param($key);
268 }
269 }
270  
271 # $self->q->util->debug->edump($data);
272 0 return $data;
273 }
274  
275 #----------------------------------------------------------------------------------------
276 0 ▶sub _byWidgetRow {
Subroutine _byWidgetRow: not called CC=3 SCAR=24.8
277  
278 0 my $rowa;
279 my $rowb;
280  
281 0 ▶ if ($a =~ /^(.+-:INSERT:)(.+)--(\d+)$/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($a =~ /^(.+-:INSERT:)(.+)--(\d+)$/) 0 0 0
282 0 $rowa = $3;
283 }
284  
285 0 ▶ if ($b =~ /^(.+-:INSERT:)(.+)--(\d+)$/) {
Branch: 1 branch
BranchTrueFalseTotal
if ($b =~ /^(.+-:INSERT:)(.+)--(\d+)$/) 0 0 0
286 0 $rowb = $3;
287 }
288
289 0 return $rowa <=> $rowb;
290 }
291  
292 #----------------------------------------------------------------------------------------
293 0 ▶sub insertIds {
Subroutine insertIds: not called CC=2 SCAR=17.9
Pod undocumented
294 0 my $self = shift;
295  
296 0 my @inserts = sort keys %{$self->inserts};
297  
298 0 ▶ if (wantarray) {
Branch: 1 branch
BranchTrueFalseTotal
if (wantarray) { } 0 0 0
299 0 return @inserts;
300 } else {
301 0 return \@inserts;
302 }
303 }
304  
305 #----------------------------------------------------------------------------------------
306 0 ▶sub jsonescape {
Subroutine jsonescape: not called CC=6 SCAR=37.4
Pod documented
307 0 my $self = shift;
308 0 my $target = shift;
309  
310 0 ▶ if (ref $target eq 'HASH') {
Branch: 2 branches
BranchTrueFalseTotal
if (ref $target eq 'HASH') { } 0 0 0
elsif (ref $target eq 'ARRAY') { } 0 0 0
311 0 foreach (keys %$target) {
312 0 foreach (values %{$target->{$_}}) {
313 0 s/'//g;
314 }
315 }
316  
317 } elsif (ref $target eq 'ARRAY') { #finish this
318 0 foreach (@$target) {
319
320 }
321  
322 } else {
323  
324 }
325 }
326  
327 #----------------------------------------------------------------------------------------
328 0 ▶sub q {
Subroutine q: not called CC=1 SCAR=6.9
Pod undocumented
329 0 my $self = shift;
330  
331 0 return $self->{_q};
332 }
333  
334 #----------------------------------------------------------------------------------------
335 1 ▶sub new {
Subroutine new: called CC=1 SCAR=0.0
Pod undocumented
336 1 my $class = shift;
337 1 my $q = shift;
338  
339 1 return bless {_q => $q }, $class;
340 }
341  
342 #----------------------------------------------------------------------------------------
343 0 ▶sub postdata {
Subroutine postdata: not called CC=5 SCAR=34.0
Pod undocumented
344 0 my $self = shift;
345  
346 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
347 0 foreach (@{$self->memberarray}) {
348 0 $_->postdata;
349 }
350 0 return;
351 }
352  
353 0 my $data;
354 0 my $widgetID = $self->vars->{id};
355  
356 0 foreach my $key (grep {/^$widgetID/} $self->q->param) {
357 0 $key =~ /^($widgetID-)(.+)(\d*)$/;
358 0 my ($pre, $field, $row) = ($1, $2, $3);
359 0 ▶ $data->{$row}->{$field} = $self->q->param($key) if $self->q->param($key);
Branch: 1 branch
BranchTrueFalseTotal
if $self->q->param($key) 0 0 0
360 }
361  
362 0 return $data;
363 }
364  
365 #----------------------------------------------------------------------------------------
366 0 ▶sub preloadLookup {
Subroutine preloadLookup: not called CC=7 SCAR=40.3
Pod documented
367 0 my $self = shift;
368  
369 0 my $preloadLookupJs;
370 0 my $lookups = $self->vars->{lookups};
371 0 my %lookuptype = (
372 hash => 'gethash',
373 hashlist => 'gethashlist',
374 array => 'getarray',
375 );
376  
377 0 foreach my $queryname (keys %$lookups) {
378 0 ▶ if ($lookups->{$queryname}->{preload}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($lookups->{$queryname}{"preload"}) 0 0 0
379 0 my $query = $lookups->{$queryname}->{sql};
380 0 my $binds = $lookups->{$queryname}->{binds};
381 0 my $output = $lookups->{$queryname}->{output};
382  
383 0 my $orderby = $lookups->{$queryname}->{orderby};
384  
385 0 ▶ if ($orderby) {
Branch: 1 branch
BranchTrueFalseTotal
if ($orderby) 0 0 0
386 0 $query .= " order by ". join ',', @$orderby;
387 }
388  
389 0 my $results;
390  
391 0 ▶ if ($lookuptype{$output} eq 'gethash') {
Branch: 1 branch
BranchTrueFalseTotal
if ($lookuptype{$output} eq 'gethash') { } 0 0 0
392 0 $results = $self->db->gethash($query, $lookups->{$queryname}->{primarykey}, @$binds);
393 } else {
394 0 my $type = $lookuptype{$output};
395 0 $results = $self->db->$type($query, @$binds);
396 }
397  
398 0 ▶ $results = [] unless ref $results;
Branch: 1 branch
BranchTrueFalseTotal
unless ref $results 0 0 0
399 0 $self->jsonescape($results);
400  
401 0 $preloadLookupJs .= "var $queryname = JSON.parse('".to_json($results)."');\n";
402 }
403 }
404 0 ▶ $preloadLookupJs = $self->q->jswrap($preloadLookupJs) if $preloadLookupJs;
Branch: 1 branch
BranchTrueFalseTotal
if $preloadLookupJs 0 0 0
405  
406 0 return $preloadLookupJs;
407 }
408  
409 #----------------------------------------------------------------------------------------
410 0 ▶sub rawContents {
Subroutine rawContents: not called CC=1 SCAR=6.9
Pod undocumented
411 0 my $self = shift;
412 0 my %args = @_;
413  
414 0 my $output = $self->contents(%args);
415 0 $output =~ s/\\/\\\\/g;
416 0 $output =~ s/"/\\"/g;
417 0 $output =~ s/[\t\n]//g;
418  
419 0 return $output;
420 }
421  
422 #----------------------------------------------------------------------------------------
423 0 ▶sub recordset {
Subroutine recordset: not called CC=1 SCAR=6.9
Pod undocumented
424 0 my $self = shift;
425  
426 0 return $self->{_recordset};
427 }
428  
429 #----------------------------------------------------------------------------------------
430 0 ▶sub rundelete {
Subroutine rundelete: not called CC=3 SCAR=24.8
Pod undocumented
431 0 my $self = shift;
432 0 my %vars = @_;
433  
434 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
435 0 foreach (@{$self->memberarray}) {
436 0 $_->rundelete(%vars);
437 }
438 0 return;
439 }
440  
441 0 $self->recordset->delete($self->deletes);
442  
443 0 return;
444 }
445  
446 #----------------------------------------------------------------------------------------
447 0 ▶sub select {
Subroutine select: not called CC=15 SCAR=54.8
Pod documented
448 0 my $self = shift;
449 0 my %args = @_;
450  
451 0 ▶ $args{searchLike} = $self->vars->{searchLike} if $self->vars->{searchLike};
Branch: 1 branch
BranchTrueFalseTotal
if $self->vars->{"searchLike"} 0 0 0
452 0 ▶ $args{searchLikeVars} = $self->vars->{searchLikeVars} if $self->vars->{searchLikeVars};
Branch: 1 branch
BranchTrueFalseTotal
if $self->vars->{"searchLikeVars"} 0 0 0
453  
454 0 ▶ my $incoming = $args{incoming} || from_json(($self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')));
Condition0%0/9
$args{'incoming'} || &from_json(scalar($self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')))
l!l&&r!l&&!r
000
$self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')
l!l&&r!l&&!r
000
$self->q->param("POSTDATA") or $self->q->param("keywords")
l!l&&r!l&&!r
000
MC/DC0%0/2
$args{'incoming'} || &from_json(scalar($self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')))
$args{'incoming'} &from_json(scalar($self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')))
MC/DC0%0/3
$self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')
$self->q->param("POSTDATA") $self->q->param("keywords") $self->q->param('XForms:Model')
Truth table0%0/3
A || B
A= $args{'incoming'}B= &from_json(scalar($self->q->param('POSTDATA') || $self->q->param('keywords') || $self->q->param('XForms:Model')))
ABresult
1X1
011
000
Truth table0%0/4
A or B || C
A= $self->q->param("POSTDATA")B= $self->q->param("keywords")C= $self->q->param('XForms:Model')
ABCresult
1XX1
01X1
0011
0000
455 0 my $div = $args{div};
456 0 my $vars = $args{vars};
457 0 my $like = $args{searchLike};
458 0 my $likevars = $args{searchLikeVars};
459  
460  
461 0 my $widgetID = $self->widgetID;
462 0 my @fields;
463 my $bind;
464 0 my $binds = [];
465  
466 # $self->q->util->debug->edump($incoming);
467  
468 0 ▶ if ($incoming->{noSearchLike}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($incoming->{"noSearchLike"}) 0 0 0
469 0 $like = undef;
470 0 delete $incoming->{noSearchLike};
471 }
472  
473 0 delete $incoming->{CGILazyID}; #key/value pair only used at cgi level, will cause problems here (set automatically by Dataset with name of widget)
474  
475 0 ▶ if ($like) {
Branch: 1 branch
BranchTrueFalseTotal
if ($like) { } 0 0 0
476 0 $bind = " like ? ";
477  
478 } else {
479 0 $bind = " = ? ";
480 }
481  
482 my %likemap = (
483 0 ▶ '%?%' => sub {return '%'.$_[0].'%';},
Subroutine __ANON__: not called CC=1 SCAR=6.9
484 0 ▶ '?%' => sub {return $_[0].'%';},
Subroutine __ANON__: not called CC=1 SCAR=6.9
485 0 ▶ '%?' => sub {return '%'.$_[0];},
Subroutine __ANON__: not called CC=1 SCAR=6.9
486  
487 0 );
488  
489 0 foreach my $field (keys %$incoming) {
490 0 ▶ unless ($field =~ /['"&;]\(\)/) {
Branch: 1 branch
BranchTrueFalseTotal
unless ($field =~ /['"&;]\(\)/) 0 0 0
491 0 ▶ if ($incoming->{$field}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($incoming->{$field}) 0 0 0
492 0 (my $fieldname = $field) =~ s/^$widgetID-//;
493 0 push @fields, $fieldname.$bind;
494 0 ▶ if (ref $incoming->{$field}) {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $incoming->{$field}) { } 0 0 0
495 0 ▶ if ($likevars) {
Branch: 1 branch
BranchTrueFalseTotal
if ($likevars) { } 0 0 0
496 0 my $value = $likemap{$likevars}->(${$incoming->{$field}});
497 0 push @$binds, $value;
498 } else {
499 0 push @$binds, ${$incoming->{$field}};
500 }
501 } else {
502 0 ▶ if ($like) {
Branch: 1 branch
BranchTrueFalseTotal
if ($like) { } 0 0 0
503 0 my $value = $likemap{$like}->($incoming->{$field});
504 0 push @$binds, $value;
505 } else {
506 0 push @$binds, $incoming->{$field};
507 }
508 }
509 }
510 }
511 }
512
513 0 my $bindstring = join ' and ', @fields;
514
515 0 $self->recordset->where($bindstring);
516  
517 # $self->q->util->debug->edump("bindstring: $bindstring binds: @$binds");
518  
519 0 my %parameters = (
520 mode => 'select',
521 binds => $binds,
522 vars => $vars,
523 );
524  
525 0 ▶ $parameters{nodiv} = 1 unless $div; #pass the div tag if we prefer
Branch: 1 branch
BranchTrueFalseTotal
unless $div 0 0 0
526  
527 0 return $self->rawContents(%parameters);
528 }
529  
530 #----------------------------------------------------------------------------------------
531 0 ▶sub update {
Subroutine update: not called CC=3 SCAR=24.8
Pod undocumented
532 0 my $self = shift;
533 0 my %vars = @_;
534  
535 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
536 0 foreach (@{$self->memberarray}) {
537 0 $_->update(%vars);
538 }
539 0 return;
540 }
541  
542 # $self->q->util->debug->edump('fromupdate', $self->updates, \%vars);
543 0 $self->recordset->update($self->updates, \%vars);
544  
545 0 return;
546 }
547  
548 #----------------------------------------------------------------------------------------
549 0 ▶sub updates {
Subroutine updates: not called CC=6 SCAR=37.4
Pod undocumented
550 0 my $self = shift;
551  
552 0 ▶ if (ref $self eq 'CGI::Lazy::Widget::Composite') {
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self eq "CGI::Lazy::Widget::Composite") 0 0 0
553 0 foreach (@{$self->memberarray}) {
554 0 $_->updates;
555 }
556 0 return;
557 }
558  
559 0 my $data;
560 0 my $widgetID = $self->widgetID;
561  
562 0 foreach my $key (grep {/^$widgetID-:UPDATE:/} $self->q->param) {
563 0 ▶ if ($key =~ /^($widgetID-:UPDATE:)(.+)-:-(.+)::(\d+)$/) {
Branch: 2 branches
BranchTrueFalseTotal
if ($key =~ /^($widgetID-:UPDATE:)(.+)-:-(.+)::(\d+)$/) { } 0 0 0
elsif ($key =~ /^($widgetID-:UPDATE:)(.+)-:-(.+)$/) { } 0 0 0
564 0 my ($pre, $fieldname, $ID, $row) = ($1, $2, $3, $4);
565 0 $data->{$ID}->{$fieldname} = $self->q->param($key);# if $self->q->param($key); #if this is set, won't blank fields deliberately left blank
566 } elsif ($key =~ /^($widgetID-:UPDATE:)(.+)-:-(.+)$/) {
567 0 my ($pre, $fieldname, $ID) = ($1, $2, $3);
568 0 $data->{$ID}->{$fieldname} = $self->q->param($key);# if $self->q->param($key);
569 }
570 }
571 # $self->q->util->debug->edump($data);
572 0 return $data;
573 }
574  
575 #----------------------------------------------------------------------------------------
576 0 ▶sub updateIds {
Subroutine updateIds: not called CC=2 SCAR=17.9
Pod undocumented
577 0 my $self = shift;
578  
579 0 my @updates = sort keys %{$self->updates};
580  
581 0 ▶ if (wantarray) {
Branch: 1 branch
BranchTrueFalseTotal
if (wantarray) { } 0 0 0
582 0 return @updates;
583 } else {
584 0 return \@updates;
585 }
586 }
587  
588 #----------------------------------------------------------------------------------------
589 0 ▶sub validator {
Subroutine validator: not called CC=1 SCAR=6.9
Pod undocumented
590 0 my $self = shift;
591  
592 0 return $self->{_validator};
593 }
594  
595 #----------------------------------------------------------------------------------------
596 0 ▶sub vars {
Subroutine vars: not called CC=1 SCAR=6.9
Pod undocumented
597 0 my $self = shift;
598  
599 0 return $self->{_vars};
600 }
601  
602 #----------------------------------------------------------------------------------------
603 0 ▶sub widgetID {
Subroutine widgetID: not called CC=1 SCAR=6.9
Pod undocumented
604 0 my $self = shift;
605  
606 0 return $self->{_widgetID};
607 }
608  
609 1 1
610  
611 __END__
« Lazy/Widget/Controller.pm ↑ Summary Lazy/Session/Data.pm »