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; }
//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>"; } } //save for map $date = date("m_d_Y"); download('csv', $date);
<body style="text-align: center; background-color: #F3E2A9"> <table><tr><td id="main"> <div class="sidebar"> <br> <h2>Choose Districts and Machines:</h2> <?php include "SaveElection.php"; connect(); $machineArray = getArrayOfMachines(); foreach ($machineArray as $machineInfo) { $d = $machineInfo[0]; $m = $machineInfo[1]; $districtMachineString = "{$d}.{$m}"; echo "<button class='link' onclick='showInfo({$districtMachineString})'>"; if (dataEntered($d, $m) == true) { echo "<div class='highlight'>"; } else { echo "<div class='lowlight'>"; } echo "District {$d}, Machine {$m}</div></button>"; } ?> <hr> <button class='link' onclick='showSpreadsheet()'>Spreadsheet Overview</button> <button class='link' onclick='saveAllForMap()'>Save All</button> <form action = './saveInputs.php' name='choices' method ='post'> <input type=submit class='input' name='output' value=' Download CSV '><br> <input type=submit class='input' name='output' value=' Download Json '> </form> <hr>