Untitled

<?php

if (!isset($_POST['cboVilla']))
{
	$villa_id = $_GET['villa_id'];
}
else
{
	$villa_id = $_POST['cboVilla'];
}

// selecteer villa uit de database
$sql_villa =	"SELECT v.villa_naam, v.villa_id,
							vb.beschikbaarheid, vb.week_nummer
							FROM villa_beschikbaarheid vb, villa v
							WHERE vb.villa_id = v.villa_id
						 ";
$result_villa = dbQuery($sql_villa);
//WHERE vb.villa_id = $villa_id
//AND vb.villa_id = v.villa_id
?>

<div id="add_afstandvilla">
<a href="<?php echo WEB_ROOT_ADMIN; ?>afstandvilla/index.php?view=toevoegen&amp;villa_id=<?php echo $villa_id; ?>">Afstand tot op deze villa toevoegen</a>
</div>

<div id="list_afstandvilla">
<?php
if (!isset($_GET['villa_id']))
{
	echo '<h2>Weergeven</h2>' . NEW_LINE;
}
?>
<table border="1">
<tr>
<td>weeknumber:</td>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
<td>13</td>
<td>14</td>
<td>15</td>
<td>16</td>
<td>17</td>
<td>18</td>
<td>19</td>
<td>20</td>
<td>21</td>
<td>22</td>
<td>23</td>
<td>24</td>
<td>25</td>
<td>26</td>
<td>27</td>
<td>28</td>
<td>29</td>
<td>30</td>
<td>31</td>
<td>32</td>
<td>33</td>
<td>34</td>
<td>35</td>
<td>36</td>
<td>37</td>
<td>38</td>
<td>39</td>
<td>40</td>
<td>41</td>
<td>42</td>
<td>43</td>
<td>44</td>
<td>45</td>
<td>46</td>
<td>47</td>
<td>48</td>
<td>49</td>
<td>50</td>
<td>51</td>
<td>52</td>
</tr>
</table>
<?php



while ($row_villa = dbFetchArray($result_villa))
{
 $arrAll_villas[] = $row_villa;
}


// $arrAll_ids heeft nu de voorkomende id's
// hierin gooien we alles weg wat niet uniek is
// dus 1,1,3,3,3 moet alleen 1,3 van over blijven

foreach($arrAll_villas as $ids){
  $arrAll_ids[] = $ids[1];
}
 
$arrAll_unique_ids = array_unique($arrAll_ids);
sort($arrAll_unique_ids);
 
// nu gaan we deze id's gebruiken om in de
// db resultaten van net de data te sorteren
 
$table = '';
$output = '';
 
// loop unique ID's
foreach($arrAll_unique_ids as $currentvilla)
{
  $tdrow = '';
  $villaname = '';

  // loop data DB rows
  for($i = 1; $i <= 52; $i++)
  {
    $newrow = '<td>-</td>';

    foreach($arrAll_villas as $villa_data)
    {
      if($villa_data[3] == $i && $villa_data[1] == $currentvilla)
      {
        $newrow.= '<td>'.$i.'(<b>'.$villa_data[2].')</b></td>';
      }
    }
  $tdrow .= $newrow;
  }

  $output = '<table border=1>
  <tr>
<td>weeknumber:</td>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
<td>13</td>
<td>14</td>
<td>15</td>
<td>16</td>
<td>17</td>
<td>18</td>
<td>19</td>
<td>20</td>
<td>21</td>
<td>22</td>
<td>23</td>
<td>24</td>
<td>25</td>
<td>26</td>
<td>27</td>
<td>28</td>
<td>29</td>
<td>30</td>
<td>31</td>
<td>32</td>
<td>33</td>
<td>34</td>
<td>35</td>
<td>36</td>
<td>37</td>
<td>38</td>
<td>39</td>
<td>40</td>
<td>41</td>
<td>42</td>
<td>43</td>
<td>44</td>
<td>45</td>
<td>46</td>
<td>47</td>
<td>48</td>
<td>49</td>
<td>50</td>
<td>51</td>
<td>52</td>
</tr>
  ';
  $output .= '<tr><td colspan="20">'.$villaname.'</td></tr>';
  $output .= '<tr>'.$tdrow.'</tr>';
  $output .= '</table><br><br>';
  $table .= $output;
}
echo $table; 
?>
</div>