<?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 ""; } }