PageRenderTime 241ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/src/beheer/beheer_editAanbieder.php

https://bitbucket.org/jwubs/gratisgolfpolis.nl
PHP | 414 lines | 377 code | 20 blank | 17 comment | 14 complexity | 7bde642f78e1f75cc61cf5f4e238f39d MD5 | raw file
  1. <?php
  2. $conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
  3. mysql_select_db('gratisgolfpolis', $conn);
  4. $result = mysql_query("SELECT * FROM user WHERE id='".$_COOKIE["bid"]."'");
  5. $aantal = mysql_num_rows($result);
  6. if($aantal==1){
  7. $row = mysql_fetch_array($result);
  8. $bid = $row["id"];
  9. $bname = $row['name'];
  10. } else {
  11. header("Location:login.html");
  12. }
  13. $result = mysql_query("SELECT * FROM aanbieders WHERE id='".$_GET["id"]."'");
  14. $aantal = mysql_num_rows($result);
  15. $row = mysql_fetch_array($result);
  16. ?>
  17. <script type="text/javascript">
  18. <?php
  19. if($row["entrycode"]!=6){
  20. ?>
  21. WYSIWYG.attach('detailtext', full);
  22. <?php
  23. }
  24. ?>
  25. WYSIWYG.attach('intro', full);
  26. WYSIWYG.attach('aanvraagtext', full);
  27. WYSIWYG.attach('bedanktext', full);
  28. WYSIWYG.attach('hioinfotext', full);
  29. </script>
  30. <form action="index.php?act=updateAanbieder&id=<?=$row["id"]?>" method="post" enctype="multipart/form-data">
  31. <table width="1000" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
  32. <tr height="30">
  33. <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>
  34. </tr>
  35. <tr valign="top"><td><b>Statutaire naam</b></td><td></td><td><input type="text" name="bedrijfsnaam" size="35" value="<?=$row["bedrijfsnaam"]?>" /></td></tr>
  36. <tr valign="top"><td><b>KvK</b></td><td></td><td><input type="text" name="kvk" size="10" value="<?=$row["kvk"]?>" /></td></tr>
  37. <tr valign="top"><td><b>Adres</b></td><td></td><td><input type="text" name="adres" size="35" value="<?=$row["adres"]?>" /></td></tr>
  38. <tr valign="top"><td><b>Huisnummer</b></td><td></td><td><input type="text" name="huisnr" size="6" value="<?=$row["huisnr"]?>" /></td></tr>
  39. <tr valign="top"><td><b>Postcode</b></td><td></td><td><input type="text" name="postcode" size="8" value="<?=$row["postcode"]?>" /></td></tr>
  40. <tr valign="top"><td><b>Woonplaats</b></td><td></td><td><input type="text" name="plaats" size="35" value="<?=$row["plaats"]?>" /></td></tr>
  41. <tr valign="top"><td><b>Telefoon</b></td><td></td><td><input type="text" name="telefoon" size="12" value="<?=$row["telefoon"]?>" /></td></tr>
  42. <tr valign="top"><td><b>Fax</b></td><td></td><td><input type="text" name="fax" size="12" value="<?=$row["fax"]?>" /></td></tr>
  43. <tr valign="top"><td><b>Email</b></td><td></td><td><input type="text" name="email" size="35" value="<?=$row["email"]?>" /></td></tr>
  44. <tr valign="top"><td><b>Homepage</b></td><td></td><td><input type="text" name="homepage" size="35" value="<?=$row["homepage"]?>" /></td></tr>
  45. <tr valign="top"><td><b>Kontaktpersoon</b></td><td></td><td><input type="text" name="kontaktpersoon" size="35" value="<?=$row["kontaktpersoon"]?>" /></td></tr>
  46. <tr><td colspan="3"><hr /></td></tr>
  47. <input type="hidden" name="urlname" value="<?=$row["urlname"]?>"/>
  48. >
  49. <!--
  50. <tr valign="top">
  51. <td width="250"><b>Logo linksboven</b></td>
  52. <td></td>
  53. <td>
  54. <table>
  55. <tr><img src="/img/aanbieders/<?=$row["logolinks"]?>" width="150"/></tr>
  56. <tr>
  57. <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>
  58. </tr>
  59. </table>
  60. </td>
  61. </tr>
  62. <tr valign="top">
  63. <td width="250"><b>Logo rechtsboven</b></td>
  64. <td></td>
  65. <td>
  66. <table>
  67. <tr><img src="/img/aanbieders/<?=$row["logorechts"]?>" width="150"/></tr>
  68. <tr>
  69. <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>
  70. </tr>
  71. </table>
  72. </td>
  73. </tr>
  74. <tr valign="top">
  75. <td width="250"><b>Plaats op sponsor pagina</b></td>
  76. <td></td>
  77. <td><input type="checkbox" name="sponsorpagina" value="ja" <?php if($row["sponsorpagina"]==1) echo 'checked'; ?> /></td>
  78. </tr>
  79. <tr valign="top">
  80. <td width="250"></td>
  81. <td></td>
  82. <td><input type="checkbox" name="entrycode" value="ja" <?php if($row["entrycode"]==1) echo 'checked'; ?> />&nbsp;<b>Gebruik entrycode</b></td>
  83. </tr>
  84. <tr valign="top">
  85. <td width="250"></td>
  86. <td></td>
  87. <td><input type="checkbox" name="algemeenaktie" value="ja" <?php if($row["algemeenaktie"]==1) echo 'checked'; ?> />&nbsp;<b>Algemene aktie</b></td>
  88. </tr>
  89. -->
  90. <tr valign="top">
  91. <td width="250"><b>HIO bedrag</b></td>
  92. <td></td>
  93. <td>
  94. <input type="text" id="hiobedrag" name="hiobedrag" value="<?= $row["hiobedrag"] ?>" /> ( __,__ )
  95. </td>
  96. </tr>
  97. <tr valign="top">
  98. <td width="250"><b>Intro tekst</b></td>
  99. <td></td>
  100. <td>
  101. <textarea id="intro" name="intro" style="width:820px;height:150px;"><?=$row["intro"]?></textarea>
  102. </td>
  103. </tr>
  104. <tr valign="top">
  105. <td><b>Detail tekst</b></td>
  106. <td></td>
  107. <td>
  108. <textarea id="detailtext" name="detailtext" style="width:820px;height:150px;"><?= $row["detail"] ?></textarea>
  109. </td>
  110. </tr>
  111. <tr valign="top">
  112. <td><b>Tekst aanvraag formulier</b></td>
  113. <td></td>
  114. <td>
  115. <textarea id="aanvraagtext" name="aanvraagtext" style="width:820px;height:150px;"><?= $row["aanvraag"] ?></textarea>
  116. </td>
  117. </tr>
  118. <tr valign="top">
  119. <td><b>Tekst bedankpagina</b></td>
  120. <td></td>
  121. <td>
  122. <textarea id="bedanktext" name="bedanktext" style="width:820px;height:150px;"><?= $row["bedankpagina"] ?></textarea>
  123. </td>
  124. </tr>
  125. <tr valign="top">
  126. <td><b>HIO Info</b></td>
  127. <td></td>
  128. <td>
  129. <textarea id="hioinfotext" name="hioinfotext" style="width:820px;height:150px;"><?= $row["hioinfo"] ?></textarea>
  130. </td>
  131. </tr>
  132. <!--
  133. <tr valign="top">
  134. <td><b>Exit link</b></td>
  135. <td></td>
  136. <td>
  137. -->
  138. <input type="hidden" name="exitlink" size="120" value="<?=$row["exitlink"]?>" />
  139. <!--
  140. </td>
  141. </tr>
  142. -->
  143. </table>
  144. <input type="submit" value="Opslaan" />
  145. </form>
  146. <BR /><BR /><BR />
  147. <?php
  148. if($_GET["subact"] == "newentrycode") {
  149. ?>
  150. <script type="text/javascript">
  151. //WYSIWYG.attach('detailaktienew', full);
  152. </script>
  153. <a name="entry"/>
  154. <form action="index.php?act=editAanbieder&subact=saveentry&id=<?=$row["id"]?>" method="post">
  155. <table width="1000" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
  156. <tr height="30">
  157. <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>
  158. </tr>
  159. <tr valign="top">
  160. <td width="250"><b>Shopid</b></td>
  161. <td></td>
  162. <td><input type="text" name="name" size="35"/></td>
  163. </tr>
  164. <tr valign="top">
  165. <td width="250"><b>Aktiecode</b></td>
  166. <td></td>
  167. <td><input type="text" name="entrycode" size="35"/></td>
  168. </tr>
  169. <input type="hidden" name="detailaktienew"/>
  170. <input type="hidden" name="exitlink"/>
  171. <?php
  172. /*
  173. <tr valign="top">
  174. <td><b>Detail tekst Aktie</b></td>
  175. <td></td>
  176. <td>
  177. <textarea id="detailaktienew" name="detailaktienew" style="width:820px;height:350px;"></textarea>
  178. </td>
  179. </tr>
  180. <tr valign="top">
  181. <td><b>Exit link</b></td>
  182. <td></td>
  183. <td>
  184. <input type="text" name="exitlink" size="120" value="" />
  185. </td>
  186. </tr>
  187. */
  188. ?>
  189. <tr>
  190. <td colspan="2"></td>
  191. <td><input type="submit" value="Opslaan" />
  192. </tr>
  193. </table>
  194. </form>
  195. <?php
  196. } elseif($_GET["subact"] == "saveentry") {
  197. $sql = "INSERT INTO akties (aanbieder, entrycode, name, intro, exitlink)
  198. VALUES (".$row["id"].",'".$_POST["entrycode"]."','".$_POST["name"]."','".str_replace("'","\'",$_POST["detailaktienew"])."','".$_POST['exitlink']."')";
  199. mysql_query($sql);
  200. header("Location:index.php?act=editAanbieder&id=".$row["id"]);
  201. ?>
  202. <script>
  203. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>";
  204. </script>
  205. <?php
  206. } elseif($_GET["subact"] == "deleteentry") {
  207. $sql = "DELETE FROM akties
  208. WHERE id = '".$_GET["entry"]."'";
  209. mysql_query($sql);
  210. header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
  211. ?>
  212. <script>
  213. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
  214. </script>
  215. <?php
  216. } elseif($_GET["subact"] == "lockentry") {
  217. $sql = "UPDATE akties
  218. SET locked=1
  219. WHERE id = '".$_GET["entry"]."'";
  220. mysql_query($sql);
  221. header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
  222. ?>
  223. <script>
  224. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
  225. </script>
  226. <?php
  227. } elseif($_GET["subact"] == "activateaktie") {
  228. $sql = "UPDATE akties
  229. SET active=1
  230. WHERE id = '".$_GET["entry"]."'";
  231. mysql_query($sql);
  232. header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
  233. ?>
  234. <script>
  235. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
  236. </script>
  237. <?php
  238. } elseif($_GET["subact"] == "deactivateaktie") {
  239. $sql = "UPDATE akties
  240. SET active=0
  241. WHERE id = '".$_GET["entry"]."'";
  242. mysql_query($sql);
  243. header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
  244. ?>
  245. <script>
  246. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
  247. </script>
  248. <?php
  249. } elseif($_GET["subact"] == "unlockentry") {
  250. $sql = "UPDATE akties
  251. SET locked=0
  252. WHERE id = '".$_GET["entry"]."'";
  253. mysql_query($sql);
  254. header("Location:index.php?act=editAanbieder&id=".$row["id"]."#entry");
  255. ?>
  256. <script>
  257. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>#entry";
  258. </script>
  259. <?php
  260. } elseif($_GET["subact"] == "editentry") {
  261. $sql = "SELECT id, aanbieder, entrycode, name, intro, exitlink
  262. FROM akties
  263. WHERE id = '".$_GET["entry"]."'";
  264. $result = mysql_query($sql);
  265. $aktie = mysql_fetch_array($result)
  266. ?>
  267. <script type="text/javascript">
  268. //WYSIWYG.attach('detailaktieedit', full);
  269. </script>
  270. <a name="entry"/>
  271. <form action="index.php?act=editAanbieder&subact=updateentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>" method="post">
  272. <input type="hidden" name="entry" value="<?=$aktie["id"]?>" />
  273. <table width="1000" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
  274. <tr height="30">
  275. <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>
  276. </tr>
  277. <tr valign="top">
  278. <td width="250"><b>Shopid</b></td>
  279. <td></td>
  280. <td><input type="text" name="name" size="35" value="<?=$aktie["name"]?>"/></td>
  281. </tr>
  282. <tr valign="top">
  283. <td width="250"><b>Aktiecode</b></td>
  284. <td></td>
  285. <td><input type="text" name="entrycode" size="35" value="<?=$aktie["entrycode"]?>"/></td>
  286. </tr>
  287. <input type="hidden" name="detailaktieedit"/>
  288. <input type="hidden" name="exitlink"/>
  289. <?php
  290. /*
  291. <tr valign="top">
  292. <td><b>Detail tekst Aktie</b></td>
  293. <td></td>
  294. <td>
  295. <textarea id="detailaktieedit" name="detailaktieedit" style="width:820px;height:150px;"><?=$aktie["intro"]?></textarea>
  296. </td>
  297. </tr>
  298. <!--
  299. <tr valign="top">
  300. <td><b>Exit link</b></td>
  301. <td></td>
  302. <td>-->
  303. <input type="hidden" name="exitlink" size="120" value="<?=$aktie["exitlink"]?>" />
  304. <!--
  305. </td>
  306. </tr>
  307. -->
  308. */
  309. ?>
  310. <tr>
  311. <td colspan="2"></td>
  312. <td><input type="submit" value="Opslaan" />
  313. </tr>
  314. </table>
  315. </form>
  316. <?php
  317. } elseif($_GET["subact"] == "updateentry") {
  318. $sql = "UPDATE akties SET
  319. entrycode = '".$_POST["entrycode"]."'
  320. , name = '".$_POST["name"]."'
  321. , intro = '".str_replace("'","\'",$_POST["detailaktieedit"])."'
  322. , exitlink = '".$_POST['exitlink']."'
  323. WHERE id='".$_POST["entry"]."'";
  324. mysql_query($sql);
  325. header("Location:index.php?act=editAanbieder&id=".$row["id"]);
  326. ?>
  327. <script>
  328. location.href="index.php?act=editAanbieder&id=<?=$row["id"]?>";
  329. </script>
  330. <?php
  331. } else {
  332. $sql = "SELECT id, aanbieder, entrycode, name, intro, exitlink, locked, active
  333. FROM akties
  334. WHERE aanbieder = '".$row["id"]."'";
  335. $result = mysql_query($sql);
  336. ?>
  337. <table width="550" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal;">
  338. <tr height="30">
  339. <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>
  340. </tr>
  341. <tr style="background-color:#FFFFFF; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold;">
  342. <td>&nbsp;</td>
  343. <td><b>Id</b></td>
  344. <td><b>Shopid</b></td>
  345. <td><b>Actiecode</b></td>
  346. </tr>
  347. <tr><td colspan="4" style="background-color:#FFFFFF"></td></tr>
  348. <?php
  349. while($aktie = mysql_fetch_array($result))
  350. {
  351. ?>
  352. <tr style="background-color:#FFFFFF;">
  353. <?php
  354. if($aktie["active"]==0) {
  355. $activeicon = "/img/icon/lightoff.jpg";
  356. $activeaxtion = "activateaktie";
  357. } else {
  358. $activeicon = "/img/icon/lighton.jpg";
  359. $activeaxtion = "deactivateaktie";
  360. }
  361. if($aktie["locked"]==0) {
  362. ?>
  363. <td width="150"><a href="index.php?act=editAanbieder&subact=<?=$activeaxtion?>&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="<?= $activeicon ?>" border="0" /></a>&nbsp;<img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/>&nbsp;&nbsp;<a href="index.php?act=editAanbieder&subact=lockentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/unlocked.jpg" border="0" /></a>&nbsp;<a href="index.php?act=editAanbieder&subact=editentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/edit.jpg" border="0" /></a>&nbsp;<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>&nbsp;&nbsp;<img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/></td>
  364. <?php
  365. } else {
  366. ?>
  367. <td width="150"><a href="index.php?act=editAanbieder&subact=<?=$activeaxtion?>&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="<?= $activeicon ?>" border="0" /></a>&nbsp;<img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/>&nbsp;&nbsp;<a href="index.php?act=editAanbieder&subact=unlockentry&entry=<?=$aktie["id"]?>&id=<?=$row["id"]?>#entry"><img src="/img/icon/locked.jpg" border="0" /></a>&nbsp;<img src="/img/icon/editoff.jpg" border="0" />&nbsp;<img src="/img/icon/deleteoff.jpg" border="0" />&nbsp;&nbsp;<img src="/img/icon/greypixel.jpg" height="12" width="1" border="0"/></td>
  368. <?php
  369. }
  370. ?>
  371. <td width="50"><?=$aktie["id"]?></td>
  372. <td><?=$aktie["name"]?></td>
  373. <td><?=$aktie["entrycode"]?></td>
  374. </tr>
  375. <?php
  376. }
  377. ?>
  378. <tr><td colspan="4"><input type="button" value="Nieuwe entrycode" onClick="location.href='index.php?act=editAanbieder&subact=newentrycode&id=<?=$row["id"]?>#entry'"/></td>
  379. </table>
  380. <?php
  381. }
  382. ?>
  383. <BR /><BR /><BR />