<?php
include "SaveElection.php";
session_start();
$election_id = getCurrentElectionID();
//get all districts
$query = "Select * from election_districts JOIN districts where election_districts.election_id = {$election_id} and ";
$query .= "election_districts.district_id = districts.id";
$result = runQuery($query);
while ($district = $result->fetch_assoc()) {
//mysql_fetch_array($result)){
$machineCount = $district['machine_count'];
$name = $district['name'];
$district_id = $district['id'];
if (districtComplete($district_id) == true) {
echo "<br><div class='highlight'>";
} else {
echo "<br><div class='lowlight'>";
}
echo "District {$name}</div>";
$election_district_id = getElectionDistrictID($district_id);
for ($m = 1; $m <= $machineCount; $m++) {
$districtMachineString = "{$district_id}.{$m}";
//echo "$districtMachineString <br>";
echo "<button class='link' onclick='showInfo({$districtMachineString})'>";
if (dataEntered($election_district_id, $m) == true) {
echo "<div class='highlight'>";
} else {
echo "<div class='lowlight'>";
}
if (is_numeric($name)) {
function getJoinQuery()
{
//only include districts completed
//get all districts
$election_id = getCurrentElectionID();
$result = getAllDistricts($election_id);
$completedDistricts = "";
while ($district = $result->fetch_assoc()) {
//mysql_fetch_array($result)){ *
if (districtComplete($district['id']) == true) {
$completedDistricts .= $district['id'] . ",";
}
}
$completedDistricts = substr($completedDistricts, 0, -1);
if (strlen($completedDistricts) > 0) {
$query = "SELECT responses.response, questions.question, district_id, machine_number, tally, election_districts.reg_voters";
$query .= " FROM questions,responses, results, election_districts WHERE results.response_id=responses.id AND responses.question_id=questions.id ";
$query .= " AND election_districts.id = results.election_district_id AND election_districts.election_id = {$election_id}";
if (strlen($completedDistricts) > 0) {
$query .= " AND election_districts.id IN ({$completedDistricts})";
}
$query .= " ORDER BY questions.question, responses.response";
return $query;
} else {
return "";
}
}
