/cont_issue.php

https://github.com/HBL/klassenboek · PHP · 81 lines · 69 code · 12 blank · 0 comment · 2 complexity · 6b4b74bc21bb2b7361ae84ef2de56b16 MD5 · raw file

  1. <? include("include/init.php");
  2. check_login();
  3. check_isset_array($_GET, 'notitie_id');
  4. check_isnonempty_array($_GET, 'notitie_id');
  5. $week_options = gen_week_select($_GET['week'], 0, &$week);
  6. $dag_options = gen_dag_select($_GET['dag'], 0, &$dag, 0, 0);
  7. $lesuur_options = gen_lesuur_select($_GET['lesuur'], 0, &$lesuur, 0);
  8. $notitie_id = mysql_escape_safe($_GET['notitie_id']);
  9. $result = mysql_query_safe(<<<EOQ
  10. SELECT tag, CONCAT(IFNULL(CONCAT(afkorting, ' '), ''), parents.text) text, CONCAT(agenda.week, CASE agenda.dag WHEN 1 THEN 'ma' WHEN 2 THEN 'di' WHEN 3 THEN 'wo' WHEN 4 THEN 'do' ELSE 'vr' END, agenda.lesuur) moment
  11. FROM notities
  12. JOIN tags2notities USING (notitie_id)
  13. JOIN agenda AS this ON notities.notitie_id = this.notitie_id
  14. JOIN ppl2agenda ON ppl2agenda.agenda_id = this.agenda_id
  15. JOIN tags USING (tag_id)
  16. JOIN notities AS parents ON notities.parent_id = parents.notitie_id
  17. JOIN agenda ON parents.notitie_id = agenda.notitie_id
  18. LEFT JOIN grp2vak2agenda ON agenda.agenda_id = grp2vak2agenda.agenda_id
  19. LEFT JOIN grp2vak USING (grp2vak_id)
  20. LEFT JOIN vak USING (vak_id)
  21. WHERE notities.notitie_id = '$notitie_id' AND notities.text IS NULL AND allow_edit = 1 AND ppl_id = {$_SESSION['ppl_id']}
  22. EOQ
  23. );
  24. $row = mysql_fetch_array($result);
  25. gen_html_header("Afspraak maken", '$("textarea:visible:first").focus();');
  26. status();
  27. switch ($row['tag']) {
  28. case 'repetitie gemist':
  29. case 'so gemist':
  30. $new_text = 'inhalen '.$row['text'].', lokaal 260';
  31. $head_text = 'Reden van afwezigheid op '.$row['moment'].'.';
  32. $briefje = 1; ?>
  33. <h3>Inhaaltoets plannen</h3>
  34. <? break;
  35. case 'afspraak niet voldaan':
  36. $new_text = $row['text'];
  37. $head_text = 'Reden van afwezigheid op '.$row['moment'].'.';
  38. $briefje = 1; ?>
  39. <h3>Nieuwe afspraak maken</h3>
  40. <? break;
  41. case 'hw niet in orde':
  42. $new_text = 'extra uurtje (hw niet in orde), lokaal ';
  43. $head_text = 'Waarom het huiswerk van '.$row['moment'].' niet in orde was.';
  44. $briefje = 0; ?>
  45. <h3>Uurtje inhalen vanwege hw</h3>
  46. <? break;
  47. default:
  48. throw new Exception('onbekend issue soort', 2);
  49. }
  50. ?>
  51. <form action="do_cont_issue.php" accept-charset="UTF-8" method="POST">
  52. <p><? echo($head_text) ?>
  53. <p><textarea rows="3" cols="40" name="text0">
  54. </textarea>
  55. <? if ($briefje) { ?><br><input type="checkbox" name="briefje" value="1"> briefje inleveren<? } ?>
  56. <p>Nieuwe afspraak week: <? echo($week_options) ?> dag: <? echo($dag_options) ?>
  57. lesuur: <? echo($lesuur_options) ?>
  58. lesgroep/vak: <? echo($grp2vak_options) ?>
  59. <p><textarea rows="3" cols="40" name="text1">
  60. <? echo(htmltobb($new_text)) ?>
  61. </textarea>
  62. <p><input type="submit" name="submit" value="Opslaan">
  63. <input type="hidden" name="lln" value="<? echo($_GET['lln']) ?>">
  64. <input type="hidden" name="view" value="<? echo($_GET['view']) ?>">
  65. <input type="hidden" name="doelgroep" value="<? echo($_GET['doelgroep']) ?>">
  66. <input type="hidden" name="notitie_id" value="<? echo($notitie_id) ?>">
  67. <input type="hidden" name="grp2vak_id" value="<? echo($_GET['grp2vak_id']) ?>">
  68. </form>
  69. <? gen_html_footer(); ?>