function allPoll()
{
if (!F3::get('SESSION.asid')) {
F3:
reroute('/admin');
}
$poll = new Axon("tbl_poll");
$poll->def('fullname', 'SELECT fullname FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('image', 'SELECT image FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('hits', 'SELECT COUNT(date) FROM tbl_vote WHERE tbl_poll.id=tbl_vote.poll_id');
$q = $poll->find();
$users = array();
foreach ($q as $qu) {
$polls[$qu->id] = array(strtoupper($qu->keyword), $qu->question, '<img src="' . $qu->image . '" width="20px" height="20px" />' . $qu->fullname, date_create("now") >= date_create($qu->expiry_date) ? "Yes" : "No", $qu->published_date ? "Yes" : "No", $qu->published_date && date_create("now") < date_create($qu->expiry_date) && $qu->is_archive == "n" ? "Yes" : "No", $qu->private == 'y' ? "Private" : "Public", $qu->hits);
if (!in_array($qu->fullname, $users)) {
$users[] = $qu->fullname;
}
}
F3::set('pollList', $polls);
F3::set('users', $users);
F3::set('template', 'poll');
echo Template::Serve('template/admin/layout.htm');
}
