function getHome()
{
$poll = new Axon('tbl_poll');
$latest_polls = $poll->find('published_date is not null and is_archive="n" and expiry_date > now() and private="n" ', 'created_date desc limit 5');
$latest = $recent = $top = array();
foreach ($latest_polls as $latestPolls) {
$latest[$latestPolls->id] = $latestPolls->question;
}
// var_dump($latest_polls );die;
$this->set('polls', $latest);
//recent activity
$poll->def('date', 'select date from tbl_vote where tbl_poll.id=tbl_vote.poll_id order by date desc limit 1');
$recent_activity = $poll->find('published_date is not null and is_archive="n" and expiry_date>now() and private="n"', 'date desc limit 3');
foreach ($recent_activity as $recentActivity) {
$recent[$recentActivity->id] = $recentActivity->question;
}
$this->set('recent', $recent);
$poll->def('hits', 'SELECT COUNT(date) FROM tbl_vote WHERE tbl_poll.id=tbl_vote.poll_id');
$top_polls = $poll->find('published_date is not null and is_archive="n" and expiry_date >now() and private="n"', 'hits desc limit 2');
foreach ($top_polls as $topPolls) {
$top[$topPolls->id] = $topPolls->question;
}
$this->set('top', $top);
$this->set('title', 'home');
$this->set('template', 'home');
echo Template::serve("template/layout.htm");
}
function all()
{
$poll = new Axon('tbl_poll');
// echo 123;die;
// $this->set('title', 'Quizzes');
$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('published_date IS NOT NULL AND is_archive="n" AND expiry_date>now() AND private="n"');
$polls = array();
foreach ($q as $qu) {
$polls[$qu->id] = array(strtoupper($qu->keyword), $qu->question, '<img src="' . $qu->image . '" width="20px" height="20px" /> ' . $qu->fullname);
}
$this->set('title', 'All polls');
$this->set('pollList', $polls);
$this->set('template', 'all');
echo Template::serve("template/layout.htm");
}
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');
}
function lst()
{
$user = new Axon('tbl_user');
$report = array();
$user->def("hits", "SELECT COUNT(date) FROM tbl_vote, tbl_poll WHERE date between '" . F3::get("POST.from") . "' and '" . F3::get("POST.to") . "'" . (F3::get("POST.telco") ? " and telco='" . F3::get("POST.telco") . "'" : "") . " and tbl_poll.id=tbl_vote.poll_id and tbl_poll.user_id=tbl_user.id group by tbl_user.id");
if ($user->found() > 0) {
$report_list = $user->find();
foreach ($report_list as $rl) {
$report[] = array('<img src="' . $rl->image . '" width="20px" height="20px" /> ' . $rl->fullname, $rl->hits ? $rl->hits : 0);
}
}
$this->set('report', $report);
echo Template::serve("template/admin/report_list.htm");
}
