Changeset 213 for trunk/lib/Vote/DB/Poll/Results.pm

Timestamp:

04/16/09 20:47:17 (15 years ago)

Author:

nanardon

Message:

• more tests and the fix need to have it passing

File:

• trunk/lib/Vote/DB/Poll/Results.pm (modified) (2 diffs)

trunk/lib/Vote/DB/Poll/Results.pm

@@ -81 +81 @@
         q{
         select count(ballot.id), value from
-        (select ballot.id, coalesce(corrected, ballot_map.to, value) as "value" from ballot
+        (
+        select NULL as id, label as value from choice where poll = ?
+        union
+        select ballot.id, coalesce(corrected, ballot_map.to, value) as "value" from ballot
         } . ($nonull ? '' : ' left ') . q{
         join ballot_item
         on ballot.id = ballot_item.id 
         left join ballot_map on ballot.poll = ballot_map.poll and ballot_map.from = ballot_item.value
-        where ballot.poll = ? and (invalid = 'false' or invalid is null)
+        where ballot.poll = ? and (invalid = 'false' or invalid is null
+        )
         group by ballot.id, coalesce(corrected, ballot_map.to, value)) as ballot
         group by value
@@ -92 +96 @@
         }
     );
-    $sth->execute($self->voteid);
+    $sth->execute($self->voteid, $self->voteid);
     my @results;
     while (my $res = $sth->fetchrow_hashref) {