PageRenderTime 57ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/src/beheer/schade_overzicht.php

https://bitbucket.org/jwubs/gratisgolfpolis.nl
PHP | 185 lines | 165 code | 20 blank | 0 comment | 8 complexity | f999982c5e8794246a9575810e7d1506 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. 	$sqlSchade = "SELECT * FROM schademeldingen WHERE 1=1";
    4. 

  4. 	$sqlTotal = "SELECT SUM(reserve) reserve, SUM(uitkering) uitkering FROM schademeldingen WHERE 1=1";
    5. 

  5. 

  6. 	if( isset($_POST["schadesoort"]) && $_POST["schadesoort"] > 0){
    7. 

  7. 		$sqlSchade = $sqlSchade." AND schadesoort='". $_POST["schadesoort"]."'";
    8. 

  8. 		$sqlTotal = $sqlTotal." AND schadesoort='". $_POST["schadesoort"]."'";
    9. 

  9. 	}
    10. 

  10. 	
    11. 

  11. 	if( isset($_POST["status"]) && $_POST["status"] > 0){
    12. 

  12. 		$sqlSchade = $sqlSchade." AND status='". $_POST["status"]."'";
    13. 

  13. 		$sqlTotal = $sqlTotal." AND status='". $_POST["status"]."'";
    14. 

  14. 	}
    15. 

  15. 

  16. 	$sqlSchade = $sqlSchade." ORDER BY id DESC";
    17. 

  17. 

  18. 	$conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
    19. 

  19. 	mysql_select_db('gratisgolfpolis', $conn);
    20. 

  20. 

  21. 	$result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
    22. 

  22. 	$aantal = mysql_num_rows($result);
    23. 

  23. 

  24. 	if($aantal==1){
    25. 

  25. 		$row = mysql_fetch_array($result);
    26. 

  26. 		$bid = $row["id"];
    27. 

  27. 		$bname = $row['name'];
    28. 

  28. 

  29. 	} else {
    30. 

  30. 		header("Location:login.html");
    31. 

  31. 	}
    32. 

  32. 	
    33. 

  33. 	$resultSchade = mysql_query( $sqlSchade );
    34. 

  34. 	$reservetotal = 0;
    35. 

  35. 	$uitkeringtotal = 0;
    36. 

  36. ?>
    37. 

  37. 

  38. <script>
    39. 

  39. 	function export2Excel(){
    40. 

  40. 		location.href='excellExport.php';
    41. 

  41. 	}
    42. 

  42. 	
    43. 

  43. 	function openZoekFilter(){
    44. 

  44. 		document.getElementById("searchPanel").style.visibility = 'visible';
    45. 

  45. 		document.getElementById("searchPanel").style.height = '200px';
    46. 

  46. 		document.getElementById("btnZoekSluiten").style.visibility = 'visible';
    47. 

  47. 		document.getElementById("btnZoekSluiten").style.width = '150px';
    48. 

  48. 		document.getElementById("btnZoekOpen").style.visibility = 'hidden';
    49. 

  49. 		document.getElementById("btnZoekOpen").style.width = '0px';	
    50. 

  50. 	}
    51. 

  51. 	
    52. 

  52. 	function sluitZoekFilter(){
    53. 

  53. 		document.getElementById("searchPanel").style.visibility = 'hidden';
    54. 

  54. 		document.getElementById("searchPanel").style.height = '0px';
    55. 

  55. 		document.getElementById("btnZoekSluiten").style.visibility = 'hidden';
    56. 

  56. 		document.getElementById("btnZoekSluiten").style.width = '0px';
    57. 

  57. 		document.getElementById("btnZoekOpen").style.visibility = 'visible';
    58. 

  58. 		document.getElementById("btnZoekOpen").style.width = '150px';		
    59. 

  59. 	}
    60. 

  60. 	
    61. 

  61. 	function export2Excel(){
    62. 

  62. 		location.href='excellSchades.php';
    63. 

  63. 	}
    64. 

  64. </script>
    65. 

  65. 

  66. <input name="btnZoekOpen" id="btnZoekOpen" type="button" value="zoek filter openen" onclick="openZoekFilter()" style="position:absolute; width:150px;"/>
    67. 

  67. <input name="btnZoekSluiten" id="btnZoekSluiten" type="button" value="zoek filter sluiten" onclick="sluitZoekFilter()" style="position:absolute; visibility:hidden; width:150px;"/>     
    68. 

  68. <br /><br />
    69. 

  69. <div id="searchPanel" style="visibility:hidden; height:0px; background-color:#FFFFFF;">
    70. 

  70. 	<form action="index.php?act=schadeoverzicht" method="post">
    71. 

  71. 	<table>
    72. 

  72.         <tr>
    73. 

  73.         	<td>certnr</td>
    74. 

  74.             <td><input type="text" name="certnr"/></td>
    75. 

  75.         </tr>
    76. 

  76.     	<tr>
    77. 

  77.         	<td>schadenr</td>
    78. 

  78.             <td><input type="text" name="schadenr"/></td>
    79. 

  79.         </tr>
    80. 

  80.         <tr>
    81. 

  81.         	<td>achternaam</td>
    82. 

  82.             <td><input type="text" name="achternaam"/></td>
    83. 

  83. 			<td>&nbsp;</td>
    84. 

  84.         </tr>
    85. 

  85.         <tr>
    86. 

  86.         	<td>soort</td>
    87. 

  87.             <td>
    88. 

  88. 				<select name="schadesoort">
    89. 

  89.                 	<option value="0">alle
    90. 

  90.                 	<option value="1">verlies clubs
    91. 

  91.                 	<option value="2">diefstal clubs (op GC)
    92. 

  92.                 	<option value="3">diefstal clubs (uit auto)
    93. 

  93.                 	<option value="4">diefstal clubs (inbraak)
    94. 

  94.                 	<option value="5">shaftbreuk clubs
    95. 

  95.                 	<option value="6">diefstal kleding
    96. 

  96.                 	<option value="7">hole-in-one
    97. 

  97.                 	<option value="8">brand
    98. 

  98.                 	<option value="9">overigen                  
    99. 

  99.                 </select>
    100. 

  100.             </td>
    101. 

  101.         </tr>
    102. 

  102.     	<tr>
    103. 

  103.         	<td>status</td>
    104. 

  104.             <td>
    105. 

  105.                 <select name="status">
    106. 

  106.                 	<option value="0">alle
    107. 

  107.                 	<option value="1">lopend
    108. 

  108.                 	<option value="2">afgehandeld                 
    109. 

  109.                 </select>
    110. 

  110.         	</td>
    111. 

  111.         </tr>
    112. 

  112.         <tr>
    113. 

  113.         	<td colspan="5">
    114. 

  114.             	<input type="submit" value="zoeken"/>
    115. 

  115.             </td>
    116. 

  116.         </tr>
    117. 

  117.     </table>
    118. 

  118.     </form>
    119. 

  119. </div>
    120. 

  120. 

  121. <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">
    122. 

  122. 	<tr height="30">
    123. 

  123.     	<td colspan="10" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">gratisgolfpolis.nl | Schades</td>
    124. 

  124.     </tr>
    125. 

  125. 	<tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
    126. 

  126.     	<td width="25">&nbsp;</td>
    127. 

  127.         <td width="100"><b>SCHADENR</b></td>
    128. 

  128.         <td width="100"><b>CERTIFICAATNR</b></td>
    129. 

  129.     	<td width="100"><b>DATUM</b></td>
    130. 

  130.     	<td width="200"><b>SCHADEOORZAAK</b></td>
    131. 

  131.     	<td width="200"><b>SOORT</b></td>
    132. 

  132.     	<td width="75"><b>RESERVE</b></td>
    133. 

  133.     	<td width="75"><b>BETAALD</b></td>
    134. 

  134.     	<td width="75"><b>NOTADATUM</b></td>
    135. 

  135.         <td width="50"><b>STATUS</b></td>
    136. 

  136. 	</tr>
    137. 

  137.     <tr><td colspan="8" style="background-color:#FFFFFF"></td></tr>
    138. 

  138. 

  139. <?php
    140. 

  140. 

  141. 	while($row = mysql_fetch_array($resultSchade))
    142. 

  142. 	{
    143. 

  143. ?>
    144. 

  144. 	<tr><td colspan="10"><img src="/img/icon/greypixel.jpg" height="1" width="1000"/></td></tr>
    145. 

  145. 	<tr style="background-color:#FFFFFF;" valign="middle">
    146. 

  146.     	<td><a href="index.php?act=editSchade&schade_id=<?=$row["id"]?>"><img src="/img/icon/edit.jpg" border="0" /></a></td>
    147. 

  147.         <td><?=$row["id"]?></td>
    148. 

  148.         <td><?=($row["aanvraag_id"]+110000)?></td>
    149. 

  149.         <td><?=$row["schadedatum"]?></td>
    150. 

  150.         <td><?=$row["oorzaak"]?></td>
    151. 

  151.         <td><?=    	str_replace("1","1: verlies clubs",
    152. 

  152.                 	str_replace("2","2: diefstal clubs (op GC)",
    153. 

  153.                 	str_replace("3","3: diefstal clubs (uit auto)",
    154. 

  154.                 	str_replace("4","4: diefstal clubs (inbraak)",
    155. 

  155.                 	str_replace("5","5: shaftbreuk clubs",
    156. 

  156.                 	str_replace("6","6: diefstal kleding",
    157. 

  157.                 	str_replace("7","7: hole-in-one",
    158. 

  158.                 	str_replace("8","8: brand",
    159. 

  159.                 	str_replace("9","9: overigen",
    160. 

  160.                     $row["schadesoort"])))))))))?></td>
    161. 

  161.         
    162. 

  162.         <td align="right">&euro; <?=str_replace(".",",",$row["reserve"])?></td>
    163. 

  163.         <td align="right">&euro; <?=str_replace(".",",",$row["uitkering"])?></td>
    164. 

  164.         <td><?=$row["notadatum"]?></td>
    165. 

  165.         <td><?=	str_replace("1","lopend",
    166. 

  166. 		        str_replace("2","afgehandeld",
    167. 

  167. 		        $row["status"]))?></td>
    168. 

  168.     </tr>
    169. 

  169. <?php
    170. 

  170. 	$reservetotal = $reservetotal + $row["reserve"];
    171. 

  171. 	$uitkeringtotal = $uitkeringtotal + $row["uitkering"];
    172. 

  172. 

  173. 	}
    174. 

  174. 	
    175. 

  175. 	if($reservetotal==0) $reservetotal = "0.00";
    176. 

  176. 	if($uitkeringtotal==0) $uitkeringtotal = "0.00";
    177. 

  177. ?>
    178. 

  178.     <tr>
    179. 

  179.     	<td colspan="6"><b>TOTALEN:</b></td>
    180. 

  180.         <td align="right"><b>&euro; <?=str_replace(".",",",$reservetotal)?></b></td>
    181. 

  181.         <td align="right"><b>&euro; <?=str_replace(".",",",$uitkeringtotal)?></b></td>
    182. 

  182.     </tr>
    183. 

  183. </table>
    184. 

  184. <br />
    185. 

  185. <input type='button' value='Export naar Excel' onclick='export2Excel()'>
    186.