/src/beheer/aanmelding_schade.php
PHP | 123 lines | 107 code | 16 blank | 0 comment | 2 complexity | 5288b126351517493a45db7d431eff59 MD5 | raw file
- <?php
- $sqlAanmelding = "SELECT * FROM aanvragen WHERE aanvraag_id = '".$_GET["id"]."'";
- $sqlSchade = "SELECT * FROM schademeldingen WHERE aanvraag_id = '".$_GET["id"]."'";
- $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
- mysql_select_db('gratisgolfpolis', $conn);
- $result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
- $aantal = mysql_num_rows($result);
- if($aantal==1){
- $row = mysql_fetch_array($result);
- $bid = $row["id"];
- $bname = $row['name'];
- } else {
- header("Location:login.html");
- }
-
-
- $resultAanmelding = mysql_query( $sqlAanmelding );
- $rowAanmelding = mysql_fetch_array($resultAanmelding);
- $certnr = $_GET["id"] + 110000;
-
-
- $resultSchade = mysql_query( $sqlSchade );
- ?>
- <table width="900" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
- <tr height="30">
- <td colspan="3" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">gratisgolfpolis.nl | Schades</td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Cerificaat nr.</b></td>
- <td></td>
- <td><?=$certnr?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Aanhef</b></td>
- <td></td>
- <td><?=$rowAanmelding["geslacht"]?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Voorl.</b></td>
- <td></td>
- <td><?=$rowAanmelding["voorletters"]?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Naam</b></td>
- <td></td>
- <td><?=$rowAanmelding["achternaam"]?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Adres</b></td>
- <td></td>
- <td><?=$rowAanmelding["adres"]." ".$rowAanmelding["huisnummer"]?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Postcode</b></td>
- <td></td>
- <td><?=$rowAanmelding["postcode"]?></td>
- </tr>
- <tr valign="top">
- <td width="150"><b>Woonplaats</b></td>
- <td></td>
- <td><?=$rowAanmelding["woonplaats"]?></td>
- </tr>
- </table>
- <table style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border-color:#CCCCCC;" border="1" cellpadding="1" cellspacing="0">
- <tr height="30">
- <td colspan="9" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">Schade meldingen</td>
- </tr>
- <tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
- <td width="25"> </td>
- <td width="100"><b>SCHADENR</b></td>
- <td width="100"><b>DATUM</b></td>
- <td width="200"><b>SCHADEOORZAAK</b></td>
- <td width="200"><b>SOORT</b></td>
- <td width="75"><b>RESERVE</b></td>
- <td width="75"><b>BETAALD</b></td>
- <td width="75"><b>NOTADATUM</b></td>
- <td width="50"><b>STATUS</b></td>
- </tr>
- <tr><td colspan="8" style="background-color:#FFFFFF"></td></tr>
- <?php
- while($row = mysql_fetch_array($resultSchade))
- {
- ?>
- <tr><td colspan="9"><img src="/img/icon/greypixel.jpg" height="1" width="900"/></td></tr>
- <tr style="background-color:#FFFFFF;" valign="middle">
- <td><a href="index.php?act=editSchade&schade_id=<?=$row["id"]?>"><img src="/img/icon/edit.jpg" border="0" /></a></td>
- <td><?=$row["id"]?></td>
- <td><?=$row["schadedatum"]?></td>
- <td><?=$row["oorzaak"]?></td>
- <td><?= str_replace("1","1: verlies clubs",
- str_replace("2","2: diefstal clubs (op GC)",
- str_replace("3","3: diefstal clubs (uit auto)",
- str_replace("4","4: diefstal clubs (inbraak)",
- str_replace("5","5: shaftbreuk clubs",
- str_replace("6","6: diefstal kleding",
- str_replace("7","7: hole-in-one",
- str_replace("8","8: brand",
- str_replace("9","9: overigen",
- $row["schadesoort"])))))))))?></td>
-
- <td align="right">€ <?=str_replace(".",",",$row["reserve"])?></td>
- <td align="right">€ <?=str_replace(".",",",$row["uitkering"])?></td>
- <td><?=$row["notadatum"]?></td>
- <td><?= str_replace("1","lopend",
- str_replace("2","afgehandeld",
- $row["status"]))?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- <input type="button" value="Toevoegen" onClick="location.href='index.php?act=schadeToevoegen&id=<?=$_GET['id']?>'" />