/src/beheer/beheer_aanmeldingen.php
PHP | 237 lines | 217 code | 20 blank | 0 comment | 9 complexity | a53d9b934dff58825fb79c85a629e687 MD5 | raw file
- <?php
- $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");
- }
-
- $offset = 0;
- if(isset($_POST["offset"])) {
- $offset = $_POST["offset"];
- }
-
- $sqlquery = "SELECT * FROM aanvragen
- WHERE deleted=0
- AND aanvraagdatum LIKE '".$_POST["aanvraagdatum"]."%'
- AND aktie LIKE '".$_POST["aktie"]."%'
- AND aanvraag_id LIKE '".$_POST["aanvraag_id"]."%'
- AND achternaam LIKE '".$_POST["achternaam"]."%'
- AND postcode LIKE '".$_POST["postcode"]."%'
- AND aantalclubs LIKE '".$_POST["aantalclubs"]."%'
- AND totaalbedrag LIKE '".$_POST["totaalbedrag"]."%'
- AND ((aankoopjaar*10000)+(aankoopmaand*100)+aankoopdag) >= '".$_POST["aankoopjaar"].$_POST["aankoopmaand"].$_POST["aankoopdag"]."'";
-
- if(strlen($_POST["aankoopjaar2"].$_POST["aankoopmaand2"].$_POST["aankoopdag2"]) == 8) {
- $sqlquery = $sqlquery." AND ((aankoopjaar*10000)+(aankoopmaand*100)+aankoopdag) <= '".$_POST["aankoopjaar2"].$_POST["aankoopmaand2"].$_POST["aankoopdag2"]."'";
- }
- $resultTellen = mysql_query( $sqlquery );
- $result = mysql_query( $sqlquery." ORDER BY aanvraag_id DESC LIMIT ".$offset.",20" );
- $aantal = mysql_num_rows($resultTellen);
-
- ?>
- <script>
- function export2Excel(){
- location.href='excellExport.php';
- }
-
- function openZoekFilter(){
- document.getElementById("searchPanel").style.visibility = 'visible';
- document.getElementById("searchPanel").style.height = '200px';
- document.getElementById("btnZoekSluiten").style.visibility = 'visible';
- document.getElementById("btnZoekSluiten").style.width = '150px';
- document.getElementById("btnZoekOpen").style.visibility = 'hidden';
- document.getElementById("btnZoekOpen").style.width = '0px';
- }
-
- function sluitZoekFilter(){
- document.getElementById("searchPanel").style.visibility = 'hidden';
- document.getElementById("searchPanel").style.height = '0px';
- document.getElementById("btnZoekSluiten").style.visibility = 'hidden';
- document.getElementById("btnZoekSluiten").style.width = '0px';
- document.getElementById("btnZoekOpen").style.visibility = 'visible';
- document.getElementById("btnZoekOpen").style.width = '150px';
- }
- </script>
- <input name="btnZoekOpen" id="btnZoekOpen" type="button" value="zoek filter openen" onclick="openZoekFilter()" style="position:absolute; width:150px;"/>
- <input name="btnZoekSluiten" id="btnZoekSluiten" type="button" value="zoek filter sluiten" onclick="sluitZoekFilter()" style="position:absolute; visibility:hidden; width:150px;"/>
- <br /><br />
- <div id="searchPanel" style="visibility:hidden; height:0px; background-color:#FFFFFF;">
- <form action="index.php?act=aanmeldingen" method="post">
- <table>
- <tr>
- <td>certnr</td>
- <td><input type="text" name="certnr"/></td>
- </tr>
- <tr>
- <td>aanvraagdatum</td>
- <td><input type="text" name="aanvraagdatum"/></td>
- <td> </td>
- <td>shopid</td>
- <td><input type="text" name="aktie"/></td>
- </tr>
- <tr>
- <td>achternaam</td>
- <td><input type="text" name="achternaam"/></td>
- <td> </td>
- <td>postcode</td>
- <td><input type="text" name="postcode" size="6"/></td>
- </tr>
- <tr>
- <td>aantalclubs</td>
- <td><input type="text" name="aantalclubs" size="4"/></td>
- <td> </td>
- <td>totaalbedrag</td>
- <td><input type="text" name="totaalbedrag" size="10"/></td>
- </tr>
- <tr>
- <td>aankoopdatum 1</td>
- <td><input type="text" name="aankoopdag" size="2"/> - <input type="text" name="aankoopmaand" size="2"/> - <input type="text" name="aankoopjaar" size="4"/></td>
- </tr>
- <tr>
- <td>aankoopdatum 2</td>
- <td><input type="text" name="aankoopdag2" size="2"/> - <input type="text" name="aankoopmaand2" size="2"/> - <input type="text" name="aankoopjaar2" size="4"/></td>
- </tr>
- <tr>
- <td colspan="5">
- <input type="submit" value="zoeken"/>
- </td>
- </tr>
- </table>
- </form>
- </div>
- <form name="frmMail" action="index.php?act=selectedaanmeldingen" method="post">
- <table width="1000" 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="14" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">gratisgolfpolis.nl | Aanmeldingen</td>
- </tr>
- <tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
- <td> </td>
- <td> </td>
- <td> </td>
- <td width="75"><b>REGDAT</b></td>
- <td width="75"><b>MAIL</b></td>
- <td width="100"><b>SHOPID</b></td>
- <td width="100"><b>CERTNR</b></td>
- <td><b>ACHTERNAAM</b></td>
- <td width="75"><b>POSTC</b></td>
- <td width="50"><b>AANT</b></td>
- <td width="75"><b>BEDRAG</b></td>
- <td width="50"><b>KPDG</b></td>
- <td width="50"><b>KPMD</b></td>
- <td width="50"><b>KPJR</b></td>
- </tr>
- <tr><td colspan="12" style="background-color:#FFFFFF"></td></tr>
- <?php
- $mailitems = "0";
- while($row = mysql_fetch_array($result))
- {
-
- $mailitems = $mailitems.",".$row["aanvraag_id"];
- $certnr = $row["aanvraag_id"] + 110000;
- ?>
- <tr><td colspan="14"><img src="/img/icon/greypixel.jpg" height="1" width="1000"/></td></tr>
- <tr style="background-color:#FFFFFF;" valign="middle">
- <td width="25" align="center"><input type="checkbox" name="mailitem<?=$row["aanvraag_id"]?>" value="mail"/></td>
- <td width="25" align="center"><input type="button" value="Schade" onclick="location.href='index.php?act=aanmeldingschade&id=<?=$row["aanvraag_id"]?>'"/></td>
- <td width="50" align="center"><img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/><a href="index.php?act=editAanmelding&id=<?=$row["aanvraag_id"]?>"><img src="/img/icon/edit.jpg" border="0" /></a> <a href="index.php?act=deleteAanmelding&id=<?=$row["aanvraag_id"]?>" onclick="return confirm('Weet u zeker dat u deze aanmelding wilt verwijderen?');"><img src="/img/icon/delete.jpg" border="0" /></a></td>
- <td><?=$row["aanvraagdatum"]?></td>
- <td><?=$row["datumgemaild"]?></td>
- <td><?=$row["aktie"]?></td>
- <td><?=$certnr?></td>
- <td><?=$row["achternaam"]?></td>
- <td><?=$row["postcode"]?></td>
- <td><?=$row["aantalclubs"]?></td>
- <td><?=$row["totaalbedrag"]?></td>
- <td><?=$row["aankoopdag"]?></td>
- <td><?=$row["aankoopmaand"]?></td>
- <td><?=$row["aankoopjaar"]?></td>
- </tr>
- <?php
- }
-
- $prevoffset = $offset - 20;
- $nextoffset = $offset + 20;
-
- $prevEnabled = "";
- $nextEnabled = "";
-
- if($offset==0){
- $prevEnabled = "disabled";
- }
-
- if(($offset+20)>$aantal){
- $nextEnabled = "disabled";
- }
- ?>
- <input type="hidden" name="mailitems" value="<?=$mailitems?>"/>
- </table>
- </form>
- <table>
- <tr>
- <td>
- <form action="index.php?act=aanmeldingen" method="post">
-
- <input type="hidden" name="certnr" value="<?=$_POST["certnr"]?>"/>
- <input type="hidden" name="aanvraagdatum" value="<?=$_POST["aanvraagdatum"]?>"/>
- <input type="hidden" name="aktie" value="<?=$_POST["aktie"]?>"/>
- <input type="hidden" name="achternaam" value="<?=$_POST["achternaam"]?>"/>
- <input type="hidden" name="postcode" value="<?=$_POST["postcode"]?>"/>
- <input type="hidden" name="aantalclubs" value="<?=$_POST["aantalclubs"]?>"/>
- <input type="hidden" name="totaalbedrag" value="<?=$_POST["totaalbedrag"]?>"/>
- <input type="hidden" name="aankoopdag" value="<?=$_POST["aankoopdag"]?>"/>
- <input type="hidden" name="aankoopmaand" value="<?=$_POST["aankoopmaand"]?>"/>
- <input type="hidden" name="aankoopjaar" value="<?=$_POST["aankoopjaar"]?>"/>
- <input type="hidden" name="offset" value="<?=$prevoffset?>"/>
-
- <input type="submit" value="vorige" <?=$prevEnabled?>/>
- </form>
- </td>
- <td>
- <form action="index.php?act=aanmeldingen" method="post">
-
- <input type="hidden" name="certnr" value="<?=$_POST["certnr"]?>"/>
- <input type="hidden" name="aanvraagdatum" value="<?=$_POST["aanvraagdatum"]?>"/>
- <input type="hidden" name="aktie" value="<?=$_POST["aktie"]?>"/>
- <input type="hidden" name="achternaam" value="<?=$_POST["achternaam"]?>"/>
- <input type="hidden" name="postcode" value="<?=$_POST["postcode"]?>"/>
- <input type="hidden" name="aantalclubs" value="<?=$_POST["aantalclubs"]?>"/>
- <input type="hidden" name="totaalbedrag" value="<?=$_POST["totaalbedrag"]?>"/>
- <input type="hidden" name="aankoopdag" value="<?=$_POST["aankoopdag"]?>"/>
- <input type="hidden" name="aankoopmaand" value="<?=$_POST["aankoopmaand"]?>"/>
- <input type="hidden" name="aankoopjaar" value="<?=$_POST["aankoopjaar"]?>"/>
- <input type="hidden" name="offset" value="<?=$nextoffset?>"/>
-
- <input type="submit" value="volgende" <?=$nextEnabled?>/>
- </form>
- </td>
- <td>
- ( totaal aantal: <?=$aantal?>, getoond <?= ($offset+1) ?> tot
- <?php
- if(($offset+20) > $aantal) {
- echo $aantal;
- } else {
- echo ($offset+20);
- }
- ?> )
- </td>
- </tr>
- </table>
- <br/>
- <table>
- <tr>
- <td><input type='button' value='Export naar Excel' onclick='export2Excel()'></td>
- <td><input type='button' value='Totaal overzicht' onclick='location.href="index.php?act=aanmeldingen"'></td>
- <td><input type="button" value='Naar mail-lijst' onclick="frmMail.submit()"></td>
- </tr>
- </table>