/src/beheer/beheer_editAanbieder.php
PHP | 414 lines | 377 code | 20 blank | 17 comment | 14 complexity | 7bde642f78e1f75cc61cf5f4e238f39d 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");
- }
-
-
- $result = mysql_query("SELECT * FROM aanbieders WHERE id='".$_GET["id"]."'");
- $aantal = mysql_num_rows($result);
- $row = mysql_fetch_array($result);
- ?>
- <script type="text/javascript">
- <?php
- if($row["entrycode"]!=6){
- ?>
- WYSIWYG.attach('detailtext', full);
- <?php
- }
- ?>
- WYSIWYG.attach('intro', full);
- WYSIWYG.attach('aanvraagtext', full);
- WYSIWYG.attach('bedanktext', full);
- WYSIWYG.attach('hioinfotext', full);
- </script>
- <form action="index.php?act=updateAanbieder&id=<?=$row["id"]?>" method="post" enctype="multipart/form-data">
- <table width="1000" 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 | Beheer sponsor: <?=$row["name"]?></td>
- </tr>
- <tr valign="top"><td><b>Statutaire naam</b></td><td></td><td><input type="text" name="bedrijfsnaam" size="35" value="<?=$row["bedrijfsnaam"]?>" /></td></tr>
- <tr valign="top"><td><b>KvK</b></td><td></td><td><input type="text" name="kvk" size="10" value="<?=$row["kvk"]?>" /></td></tr>
- <tr valign="top"><td><b>Adres</b></td><td></td><td><input type="text" name="adres" size="35" value="<?=$row["adres"]?>" /></td></tr>
- <tr valign="top"><td><b>Huisnummer</b></td><td></td><td><input type="text" name="huisnr" size="6" value="<?=$row["huisnr"]?>" /></td></tr>
- <tr valign="top"><td><b>Postcode</b></td><td></td><td><input type="text" name="postcode" size="8" value="<?=$row["postcode"]?>" /></td></tr>
- <tr valign="top"><td><b>Woonplaats</b></td><td></td><td><input type="text" name="plaats" size="35" value="<?=$row["plaats"]?>" /></td></tr>
- <tr valign="top"><td><b>Telefoon</b></td><td></td><td><input type="text" name="telefoon" size="12" value="<?=$row["telefoon"]?>" /></td></tr>
- <tr valign="top"><td><b>Fax</b></td><td></td><td><input type="text" name="fax" size="12" value="<?=$row["fax"]?>" /></td></tr>
- <tr valign="top"><td><b>Email</b></td><td></td><td><input type="text" name="email" size="35" value="<?=$row["email"]?>" /></td></tr>
- <tr valign="top"><td><b>Homepage</b></td><td></td><td><input type="text" name="homepage" size="35" value="<?=$row["homepage"]?>" /></td></tr>
- <tr valign="top"><td><b>Kontaktpersoon</b></td><td></td><td><input type="text" name="kontaktpersoon" size="35" value="<?=$row["kontaktpersoon"]?>" /></td></tr>
- <tr><td colspan="3"><hr /></td></tr>
- <input type="hidden" name="urlname" value="<?=$row["urlname"]?>"/>
- >
- <!--
- <tr valign="top">
- <td width="250"><b>Logo linksboven</b></td>
- <td></td>
- <td>
- <table>
- <tr><img src="/img/aanbieders/<?=$row["logolinks"]?>" width="150"/></tr>
- <tr>
- <td><input type="checkbox" name="vvlogolinks" value="ja" onclick="document.forms[0].logolinks.disabled=!this.checked;"/><input type="file" name="logolinks" size="35" disabled/></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Logo rechtsboven</b></td>
- <td></td>
- <td>
- <table>
- <tr><img src="/img/aanbieders/<?=$row["logorechts"]?>" width="150"/></tr>
- <tr>
- <td><input type="checkbox" name="vvlogorechts" value="ja" onclick="document.forms[0].logorechts.disabled=!this.checked;"/><input type="file" name="logorechts" size="35" disabled/></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Plaats op sponsor pagina</b></td>
- <td></td>
- <td><input type="checkbox" name="sponsorpagina" value="ja" <?php if($row["sponsorpagina"]==1) echo 'checked'; ?> /></td>
- </tr>
-
- <tr valign="top">
- <td width="250"></td>
- <td></td>
- <td><input type="checkbox" name="entrycode" value="ja" <?php if($row["entrycode"]==1) echo 'checked'; ?> /> <b>Gebruik entrycode</b></td>
- </tr>
- <tr valign="top">
- <td width="250"></td>
- <td></td>
- <td><input type="checkbox" name="algemeenaktie" value="ja" <?php if($row["algemeenaktie"]==1) echo 'checked'; ?> /> <b>Algemene aktie</b></td>
- </tr>
- -->
- <tr valign="top">
- <td width="250"><b>HIO bedrag</b></td>
- <td></td>
- <td>
- <input type="text" id="hiobedrag" name="hiobedrag" value="<?= $row["hiobedrag"] ?>" /> ( __,__ )
- </td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Intro tekst</b></td>
- <td></td>
- <td>
- <textarea id="intro" name="intro" style="width:820px;height:150px;"><?=$row["intro"]?></textarea>
- </td>
- </tr>
-
- <tr valign="top">
- <td><b>Detail tekst</b></td>
- <td></td>
- <td>
- <textarea id="detailtext" name="detailtext" style="width:820px;height:150px;"><?= $row["detail"] ?></textarea>
- </td>
- </tr>
-
- <tr valign="top">
- <td><b>Tekst aanvraag formulier</b></td>
- <td></td>
- <td>
- <textarea id="aanvraagtext" name="aanvraagtext" style="width:820px;height:150px;"><?= $row["aanvraag"] ?></textarea>
- </td>
- </tr>
- <tr valign="top">
- <td><b>Tekst bedankpagina</b></td>
- <td></td>
- <td>
- <textarea id="bedanktext" name="bedanktext" style="width:820px;height:150px;"><?= $row["bedankpagina"] ?></textarea>
- </td>
- </tr>
- <tr valign="top">
- <td><b>HIO Info</b></td>
- <td></td>
- <td>
- <textarea id="hioinfotext" name="hioinfotext" style="width:820px;height:150px;"><?= $row["hioinfo"] ?></textarea>
- </td>
- </tr>
- <!--
- <tr valign="top">
- <td><b>Exit link</b></td>
- <td></td>
- <td>
- -->
- <input type="hidden" name="exitlink" size="120" value="<?=$row["exitlink"]?>" />
- <!--
- </td>
- </tr>
- -->
- </table>
- <input type="submit" value="Opslaan" />
- </form>
- <BR /><BR /><BR />
- <?php
- if($_GET["subact"] == "newentrycode") {
- ?>
- <script type="text/javascript">
- //WYSIWYG.attach('detailaktienew', full);
- </script>
- <a name="entry"/>
- <form action="index.php?act=editAanbieder&subact=saveentry&id=<?=$row["id"]?>" method="post">
- <table width="1000" 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;">Nieuwe entrycode</td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Shopid</b></td>
- <td></td>
- <td><input type="text" name="name" size="35"/></td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Aktiecode</b></td>
- <td></td>
- <td><input type="text" name="entrycode" size="35"/></td>
- </tr>
- <input type="hidden" name="detailaktienew"/>
- <input type="hidden" name="exitlink"/>
- <?php
- /*
- <tr valign="top">
- <td><b>Detail tekst Aktie</b></td>
- <td></td>
- <td>
- <textarea id="detailaktienew" name="detailaktienew" style="width:820px;height:350px;"></textarea>
- </td>
- </tr>
- <tr valign="top">
- <td><b>Exit link</b></td>
- <td></td>
- <td>
- <input type="text" name="exitlink" size="120" value="" />
- </td>
- </tr>
- */
- ?>
- <tr>
- <td colspan="2"></td>
- <td><input type="submit" value="Opslaan" />
- </tr>
- </table>
- </form>
- <?php
- } elseif($_GET["subact"] == "saveentry") {
- $sql = "INSERT INTO akties (aanbieder, entrycode, name, intro, exitlink)
- VALUES (".$row["id"].",'".$_POST["entrycode"]."','".$_POST["name"]."','".str_replace("'","\'",$_POST["detailaktienew"])."','".$_POST['exitlink']."')";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]);
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>";
- </script>
- <?php
- } elseif($_GET["subact"] == "deleteentry") {
- $sql = "DELETE FROM akties
- WHERE id = '".$_GET["entry"]."'";
- mysql_query($sql);
- header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
- </script>
- <?php
-
- } elseif($_GET["subact"] == "lockentry") {
- $sql = "UPDATE akties
- SET locked=1
- WHERE id = '".$_GET["entry"]."'";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
- </script>
- <?php
- } elseif($_GET["subact"] == "activateaktie") {
- $sql = "UPDATE akties
- SET active=1
- WHERE id = '".$_GET["entry"]."'";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
- </script>
- <?php
- } elseif($_GET["subact"] == "deactivateaktie") {
- $sql = "UPDATE akties
- SET active=0
- WHERE id = '".$_GET["entry"]."'";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
- </script>
- <?php
- } elseif($_GET["subact"] == "unlockentry") {
- $sql = "UPDATE akties
- SET locked=0
- WHERE id = '".$_GET["entry"]."'";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
- </script>
- <?php
-
- } elseif($_GET["subact"] == "editentry") {
-
- $sql = "SELECT id, aanbieder, entrycode, name, intro, exitlink
- FROM akties
- WHERE id = '".$_GET["entry"]."'";
-
- $result = mysql_query($sql);
- $aktie = mysql_fetch_array($result)
- ?>
- <script type="text/javascript">
- //WYSIWYG.attach('detailaktieedit', full);
- </script>
- <a name="entry"/>
- <form action="index.php?act=editAanbieder&subact=updateentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>" method="post">
- <input type="hidden" name="entry" value="<?=$aktie["id"]?>" />
- <table width="1000" 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;">Entrycode bewerken | <?= $aktie["name"] ?></td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Shopid</b></td>
- <td></td>
- <td><input type="text" name="name" size="35" value="<?=$aktie["name"]?>"/></td>
- </tr>
- <tr valign="top">
- <td width="250"><b>Aktiecode</b></td>
- <td></td>
- <td><input type="text" name="entrycode" size="35" value="<?=$aktie["entrycode"]?>"/></td>
- </tr>
- <input type="hidden" name="detailaktieedit"/>
- <input type="hidden" name="exitlink"/>
- <?php
- /*
- <tr valign="top">
- <td><b>Detail tekst Aktie</b></td>
- <td></td>
- <td>
- <textarea id="detailaktieedit" name="detailaktieedit" style="width:820px;height:150px;"><?=$aktie["intro"]?></textarea>
- </td>
- </tr>
- <!--
- <tr valign="top">
- <td><b>Exit link</b></td>
- <td></td>
- <td>-->
- <input type="hidden" name="exitlink" size="120" value="<?=$aktie["exitlink"]?>" />
- <!--
- </td>
- </tr>
- -->
- */
- ?>
- <tr>
- <td colspan="2"></td>
- <td><input type="submit" value="Opslaan" />
- </tr>
- </table>
- </form>
- <?php
- } elseif($_GET["subact"] == "updateentry") {
- $sql = "UPDATE akties SET
- entrycode = '".$_POST["entrycode"]."'
- , name = '".$_POST["name"]."'
- , intro = '".str_replace("'","\'",$_POST["detailaktieedit"])."'
- , exitlink = '".$_POST['exitlink']."'
- WHERE id='".$_POST["entry"]."'";
- mysql_query($sql);
-
- header("Location:index.php?act=editAanbieder&id=".$row["id"]);
- ?>
- <script>
- location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>";
- </script>
-
- <?php
- } else {
- $sql = "SELECT id, aanbieder, entrycode, name, intro, exitlink, locked, active
- FROM akties
- WHERE aanbieder = '".$row["id"]."'";
-
- $result = mysql_query($sql);
- ?>
- <table width="550" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
- <tr height="30">
- <td colspan="4" align="center" style="background-color:#137601; color:#f0b300; font-family:Arial, Helvetica, sans-serif; font-size:14px; font-weight:bold;">Entrycodes</td>
- </tr>
- <tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
- <td> </td>
- <td><b>Id</b></td>
- <td><b>Shopid</b></td>
- <td><b>Actiecode</b></td>
- </tr>
- <tr><td colspan="4" style="background-color:#FFFFFF"></td></tr>
- <?php
- while($aktie = mysql_fetch_array($result))
- {
- ?>
- <tr style="background-color:#FFFFFF;">
- <?php
- if($aktie["active"]==0) {
- $activeicon = "/img/icon/lightoff.jpg";
- $activeaxtion = "activateaktie";
- } else {
- $activeicon = "/img/icon/lighton.jpg";
- $activeaxtion = "deactivateaktie";
- }
- if($aktie["locked"]==0) {
- ?>
- <td width="150"><a href="index.php?act=editAanbieder&subact=<?=$activeaxtion?>&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="<?= $activeicon ?>" border="0" /></a> <img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/> <a href="index.php?act=editAanbieder&subact=lockentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/unlocked.jpg" border="0" /></a> <a href="index.php?act=editAanbieder&subact=editentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/edit.jpg" border="0" /></a> <a href="index.php?act=editAanbieder&subact=deleteentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry" onclick="return confirm('Weet u zeker dat u deze aktie wilt verwijderen?');"><img src="/img/icon/delete.jpg" border="0" /></a> <img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/></td>
- <?php
- } else {
- ?>
- <td width="150"><a href="index.php?act=editAanbieder&subact=<?=$activeaxtion?>&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="<?= $activeicon ?>" border="0" /></a> <img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/> <a href="index.php?act=editAanbieder&subact=unlockentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/locked.jpg" border="0" /></a> <img src="/img/icon/editoff.jpg" border="0" /> <img src="/img/icon/deleteoff.jpg" border="0" /> <img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/></td>
- <?php
- }
- ?>
- <td width="50"><?=$aktie["id"]?></td>
- <td><?=$aktie["name"]?></td>
- <td><?=$aktie["entrycode"]?></td>
- </tr>
- <?php
- }
- ?>
- <tr><td colspan="4"><input type="button" value="Nieuwe entrycode" onClick="location.href='index.php?act=editAanbieder&subact=newentrycode&id=<?=$row["id"]?>#entry'"/></td>
- </table>
- <?php
- }
- ?>
- <BR /><BR /><BR />