<?php

require_once ('Plans.php');

require ("functions-main.php"); //load main functions

require ("syntax-classes.php"); //load display functions

$idcookie = User::id();

$userid = $idcookie;

$dbh = db_connect(); //connect to database

$thispage = new PlansPage('Utilities', 'poll', PLANSVNAME . ' - Polls', 'poll.php');

if (User::logged_in()) {

populate_page($thispage, $dbh, $idcookie);

} else {

populate_guest_page($thispage);

$denied = new AlertText('Please log in.', 'Access Denied');

$thispage->append($denied);

}

if (User::logged_in()) {

$poll_question_id = $_GET['poll_question_id'];

$submitted = $_GET['submitted'];

if (!$poll_question_id) {

$sql = "select max(poll_question_id) as max from poll_questions; ";

$res = mysqli_query($dbh,$sql);

$new_row = mysqli_fetch_array($res);

$poll_question_id = $new_row['max'];

}

$responses = array();

$sql = "select type, q.html as question from poll_questions q

where poll_question_id = $poll_question_id";

$res = mysqli_query($dbh,$sql);

$new_row = mysqli_fetch_array($res);

$question = $new_row['question'];

$type = $new_row['type'];

if ($submitted) {

$poll_choice_ids = array();

$poll_choice_id = $_GET['poll_choice_id'];

if (!isset($poll_choice_id)) {

$poll_choice_ids = array();

} else {

if ($type == 'single') {

if (is_array($poll_choice_id)) {

$poll_choice_ids[] = $poll_choice_id[0];

} else {

$poll_choice_ids[] = $poll_choice_id;

}

} else {

$poll_choice_ids = $poll_choice_id;

}

}

$sql = "delete poll_votes from poll_votes join poll_choices using (poll_choice_id)

where userid = $userid and poll_question_id = $poll_question_id ";

mysqli_query($dbh,$sql);

foreach($poll_choice_ids as $poll_choice_id) {

$sql = "insert into poll_votes set userid = $userid,

created = now(),

poll_choice_id = $poll_choice_id";

mysqli_query($dbh,$sql);

}

}

$heading = new HeadingText($question, 3);

$thispage->append($heading);

$votingform = new Form('pollform', true);

$votingform->method = 'GET';

$thispage->append($votingform);

$sql = "select c.html as html, c.poll_choice_id as poll_choice_id, v.userid as checked from poll_choices c left join poll_votes v on v.userid = $userid and v.poll_choice_id = c.poll_choice_id where c.poll_question_id = $poll_question_id order by c.html";

$html_res = mysqli_query($dbh,$sql);

while ($new_row = mysqli_fetch_array($html_res)) {

$html = $new_row['html'];

$checked = $new_row['checked'];

$poll_choice_id = $new_row['poll_choice_id'];

$html = $new_row['html'];

$set = new FormItemSet('polloption', false);

if ($type == 'single') {

$item = new RadioInput('poll_choice_id', $poll_choice_id);

} else {

$item = new CheckboxInput('poll_choice_id[]', $poll_choice_id);

}

$item->title = $html;

$item->checked = $checked;

$set->append($item);

$sql = "select count(*) as popularity from poll_votes v

where v.poll_choice_id = $poll_choice_id";

$res = mysqli_query($dbh,$sql);

$new_row = mysqli_fetch_array($res);

$popularity = $new_row['popularity'];

$votes = new RegularText($popularity, 'Popularity');

$set->append($votes);

$votingform->append($set);

}

$item = new HiddenInput('poll_question_id', $poll_question_id);

$votingform->append($item);

$item = new HiddenInput('submitted', 1);

$votingform->append($item);

$item = new SubmitInput('Vote!');

$votingform->append($item);

$sql = "select count(*) as voted from poll_votes v join poll_choices c using (poll_choice_id) where userid = $userid and poll_question_id = $poll_question_id";

$res = mysqli_query($dbh,$sql);

$new_row = mysqli_fetch_array($res);

$voted = $new_row['voted'];

if ($voted) {

$msg = new InfoText('You have voted in this poll, but you may change your mind.', 'Vote registered');

$thispage->append($msg);

}

}

$thispage->append(list_polls());

$ask = new RequestText('Poll ideas? <a href="mailto:grinnellplans@gmail.com">Email</a>.', 'Feedback?');

$thispage->append($ask);

function list_polls() {

}

interface_disp_page($thispage);

db_disconnect($dbh);

?>