Example #1
0
//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)) {
            echo " Machine {$m}";
        } else {
            echo " {$name}";
        }
        echo " </div></button><br>";
function districtComplete($districtID)
{
    //get machines for district
    //$election_id = getCurrentElectionID();
    $election_district_id = getElectionDistrictID($districtID);
    $query = "SELECT machine_count FROM election_districts WHERE id = {$election_district_id}";
    //echo $query;
    $result = runQuery($query);
    $district = $result->fetch_assoc();
    //mysql_fetch_array($result);
    $m = $district['machine_count'];
    while ($m > 0) {
        $isDone = dataEntered($election_district_id, $m);
        if ($isDone == false) {
            return false;
        }
        $m--;
    }
    return true;
}