PageRenderTime 44ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/src/beheer/aanmelding_schade.php

https://bitbucket.org/jwubs/gratisgolfpolis.nl
PHP | 123 lines | 107 code | 16 blank | 0 comment | 2 complexity | 5288b126351517493a45db7d431eff59 MD5 | raw file
  1. <?php
  2. $sqlAanmelding = "SELECT * FROM aanvragen WHERE aanvraag_id = '".$_GET["id"]."'";
  3. $sqlSchade = "SELECT * FROM schademeldingen WHERE aanvraag_id = '".$_GET["id"]."'";
  4. $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
  5. mysql_select_db('gratisgolfpolis', $conn);
  6. $result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
  7. $aantal = mysql_num_rows($result);
  8. if($aantal==1){
  9. $row = mysql_fetch_array($result);
  10. $bid = $row["id"];
  11. $bname = $row['name'];
  12. } else {
  13. header("Location:login.html");
  14. }
  15. $resultAanmelding = mysql_query( $sqlAanmelding );
  16. $rowAanmelding = mysql_fetch_array($resultAanmelding);
  17. $certnr = $_GET["id"] + 110000;
  18. $resultSchade = mysql_query( $sqlSchade );
  19. ?>
  20. <table width="900" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
  21. <tr height="30">
  22. <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>
  23. </tr>
  24. <tr valign="top">
  25. <td width="150"><b>Cerificaat nr.</b></td>
  26. <td></td>
  27. <td><?=$certnr?></td>
  28. </tr>
  29. <tr valign="top">
  30. <td width="150"><b>Aanhef</b></td>
  31. <td></td>
  32. <td><?=$rowAanmelding["geslacht"]?></td>
  33. </tr>
  34. <tr valign="top">
  35. <td width="150"><b>Voorl.</b></td>
  36. <td></td>
  37. <td><?=$rowAanmelding["voorletters"]?></td>
  38. </tr>
  39. <tr valign="top">
  40. <td width="150"><b>Naam</b></td>
  41. <td></td>
  42. <td><?=$rowAanmelding["achternaam"]?></td>
  43. </tr>
  44. <tr valign="top">
  45. <td width="150"><b>Adres</b></td>
  46. <td></td>
  47. <td><?=$rowAanmelding["adres"]." ".$rowAanmelding["huisnummer"]?></td>
  48. </tr>
  49. <tr valign="top">
  50. <td width="150"><b>Postcode</b></td>
  51. <td></td>
  52. <td><?=$rowAanmelding["postcode"]?></td>
  53. </tr>
  54. <tr valign="top">
  55. <td width="150"><b>Woonplaats</b></td>
  56. <td></td>
  57. <td><?=$rowAanmelding["woonplaats"]?></td>
  58. </tr>
  59. </table>
  60. <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">
  61. <tr height="30">
  62. <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>
  63. </tr>
  64. <tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
  65. <td width="25">&nbsp;</td>
  66. <td width="100"><b>SCHADENR</b></td>
  67. <td width="100"><b>DATUM</b></td>
  68. <td width="200"><b>SCHADEOORZAAK</b></td>
  69. <td width="200"><b>SOORT</b></td>
  70. <td width="75"><b>RESERVE</b></td>
  71. <td width="75"><b>BETAALD</b></td>
  72. <td width="75"><b>NOTADATUM</b></td>
  73. <td width="50"><b>STATUS</b></td>
  74. </tr>
  75. <tr><td colspan="8" style="background-color:#FFFFFF"></td></tr>
  76. <?php
  77. while($row = mysql_fetch_array($resultSchade))
  78. {
  79. ?>
  80. <tr><td colspan="9"><img src="/img/icon/greypixel.jpg" height="1" width="900"/></td></tr>
  81. <tr style="background-color:#FFFFFF;" valign="middle">
  82. <td><a href="index.php?act=editSchade&schade_id=<?=$row["id"]?>"><img src="/img/icon/edit.jpg" border="0" /></a></td>
  83. <td><?=$row["id"]?></td>
  84. <td><?=$row["schadedatum"]?></td>
  85. <td><?=$row["oorzaak"]?></td>
  86. <td><?= str_replace("1","1: verlies clubs",
  87. str_replace("2","2: diefstal clubs (op GC)",
  88. str_replace("3","3: diefstal clubs (uit auto)",
  89. str_replace("4","4: diefstal clubs (inbraak)",
  90. str_replace("5","5: shaftbreuk clubs",
  91. str_replace("6","6: diefstal kleding",
  92. str_replace("7","7: hole-in-one",
  93. str_replace("8","8: brand",
  94. str_replace("9","9: overigen",
  95. $row["schadesoort"])))))))))?></td>
  96. <td align="right">&euro; <?=str_replace(".",",",$row["reserve"])?></td>
  97. <td align="right">&euro; <?=str_replace(".",",",$row["uitkering"])?></td>
  98. <td><?=$row["notadatum"]?></td>
  99. <td><?= str_replace("1","lopend",
  100. str_replace("2","afgehandeld",
  101. $row["status"]))?></td>
  102. </tr>
  103. <?php
  104. }
  105. ?>
  106. </table>
  107. <input type="button" value="Toevoegen" onClick="location.href='index.php?act=schadeToevoegen&id=<?=$_GET['id']?>'" />