session_course_edit.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. <?php
  2. $langFile='admin';
  3. $cidReset=true;
  4. include('../inc/global.inc.php');
  5. api_protect_admin_script();
  6. $id_session=intval($_GET['id_session']);
  7. $course_code=trim(stripslashes($_GET['course_code']));
  8. $formSent=0;
  9. $errorMsg='';
  10. $tbl_user=Database::get_main_table(MAIN_USER_TABLE);
  11. $tbl_course=Database::get_main_table(MAIN_COURSE_TABLE);
  12. $tbl_session=Database::get_main_table(MAIN_SESSION_TABLE);
  13. $tbl_session_course=Database::get_main_table(MAIN_SESSION_COURSE_TABLE);
  14. $tool_name=get_lang('ModifySessionCourse');
  15. $result=api_sql_query("SELECT name,title FROM $tbl_session_course,$tbl_session,$tbl_course WHERE id_session=id AND course_code=code AND id_session='$id_session' AND course_code='".addslashes($course_code)."'",__FILE__,__LINE__);
  16. if(!list($session_name,$course_title)=mysql_fetch_row($result))
  17. {
  18. header('Location: session_course_list.php?id_session='.$id_session);
  19. exit();
  20. }
  21. $interbreadcrumb[]=array("url" => "index.php","name" => get_lang('AdministrationTools'));
  22. $interbreadcrumb[]=array("url" => "session_list.php","name" => get_lang("SessionList"));
  23. $interbreadcrumb[]=array("url" => "session_course_list.php?id_session=$id_session","name" => get_lang("CourseSessionList")." &quot;".htmlentities($session_name)."&quot;");
  24. if($_POST['formSent'])
  25. {
  26. $formSent=1;
  27. $id_coach=intval($_POST['id_coach']);
  28. if(!$id_coach) $errorMsg=gget_lang("SelectACoach");
  29. else
  30. {
  31. api_sql_query("UPDATE $tbl_session_course
  32. SET id_coach='$id_coach'
  33. WHERE id_session='$id_session' AND course_code='$course_code'",__FILE__,__LINE__);
  34. header('Location: '.$_GET['page'].'?id_session='.$id_session);
  35. exit();
  36. }
  37. }
  38. else
  39. {
  40. $result=api_sql_query("SELECT id_coach FROM $tbl_session_course WHERE id_session='$id_session' AND course_code='$course_code'",__FILE__,__LINE__);
  41. if(!$infos=mysql_fetch_array($result))
  42. {
  43. //header('Location: '.$_GET['page'].'?id_session='.$id_session);
  44. exit();
  45. }
  46. }
  47. $sql="SELECT user_id,lastname,firstname,username FROM $tbl_user WHERE status='1' ORDER BY lastname,firstname,username";
  48. $result=api_sql_query($sql,__FILE__,__LINE__);
  49. $Coaches=api_store_result($result);
  50. Display::display_header($tool_name);
  51. api_display_tool_title($tool_name);
  52. ?>
  53. <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $_GET['page'] ?>" style="margin:0px;">
  54. <input type="hidden" name="formSent" value="1">
  55. <table border="0" cellpadding="5" cellspacing="0" width="550">
  56. <?php
  57. if(!empty($errorMsg))
  58. {
  59. ?>
  60. <tr>
  61. <td colspan="2">
  62. <?php
  63. Display::display_normal_message($errorMsg);
  64. ?>
  65. </td>
  66. </tr>
  67. <?php
  68. }
  69. ?>
  70. <tr>
  71. <td width="30%"><?php echo get_lang("CoachName") ?>&nbsp;&nbsp;</td>
  72. <td width="70%"><select name="id_coach" style="width:250px;">
  73. <option value="0">----- <?php echo get_lang("Choose") ?> -----</option>
  74. <?php
  75. foreach($Coaches as $enreg)
  76. {
  77. ?>
  78. <option value="<?php echo $enreg['user_id']; ?>" <?php if((!$sent && $enreg['user_id'] == $infos['id_coach']) || ($sent && $enreg['user_id'] == $id_coach)) echo 'selected="selected"'; ?>><?php echo $enreg['lastname'].' '.$enreg['firstname'].' ('.$enreg['username'].')'; ?></option>
  79. <?php
  80. }
  81. unset($Coaches);
  82. ?>
  83. </select></td>
  84. </tr>
  85. <tr>
  86. <td>&nbsp;</td>
  87. <td><input type="submit" value="<?php echo get_lang('Ok'); ?>"></td>
  88. </tr>
  89. </table>
  90. </form>
  91. <?php
  92. Display::display_footer();
  93. ?>