gradebook_edit_all.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Script
  5. * @package chamilo.gradebook
  6. */
  7. /**
  8. * Init
  9. */
  10. $language_file= 'gradebook';
  11. $cidReset= true;
  12. require_once '../inc/global.inc.php';
  13. $this_section = SECTION_COURSES;
  14. require_once 'lib/be.inc.php';
  15. require_once 'lib/scoredisplay.class.php';
  16. require_once 'lib/gradebook_functions.inc.php';
  17. require_once 'lib/fe/catform.class.php';
  18. require_once 'lib/fe/evalform.class.php';
  19. require_once 'lib/fe/linkform.class.php';
  20. require_once 'lib/gradebook_data_generator.class.php';
  21. require_once 'lib/fe/gradebooktable.class.php';
  22. require_once 'lib/fe/displaygradebook.php';
  23. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php';
  24. api_block_anonymous_users();
  25. if (!api_is_allowed_to_edit()) {
  26. header('Location: /index.php');
  27. exit;
  28. }
  29. $my_selectcat = isset($_GET['selectcat']) ? Security::remove_XSS($_GET['selectcat']) : '';
  30. if (empty($my_selectcat)) {
  31. api_not_allowed();
  32. }
  33. // DISPLAY HEADERS AND MESSAGES -
  34. if (!isset($_GET['exportpdf']) and !isset($_GET['export_certificate'])) {
  35. if (isset ($_GET['studentoverview'])) {
  36. $interbreadcrumb[]= array ('url' => Security::remove_XSS($_SESSION['gradebook_dest']).'?selectcat=' . Security::remove_XSS($_GET['selectcat']),'name' => get_lang('Gradebook'));
  37. Display :: display_header(get_lang('FlatView'));
  38. } elseif (isset ($_GET['search'])) {
  39. $interbreadcrumb[]= array ('url' => Security::remove_XSS($_SESSION['gradebook_dest']).'?selectcat=' . Security::remove_XSS($_GET['selectcat']),'name' => get_lang('Gradebook'));
  40. Display :: display_header(get_lang('SearchResults'));
  41. } else {
  42. $interbreadcrumb[] = array ('url' => Security::remove_XSS($_SESSION['gradebook_dest']).'?selectcat=1', 'name' => get_lang('Gradebook'));
  43. $interbreadcrumb[] = array ('url' => '#','name' => get_lang('EditAllWeights'));
  44. Display :: display_header('');
  45. }
  46. }
  47. $course_id = get_course_id_by_link_id($my_selectcat);
  48. $table_link = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
  49. $table_evaluation = Database::get_main_table(TABLE_MAIN_GRADEBOOK_EVALUATION);
  50. $tbl_forum_thread = Database :: get_course_table(TABLE_FORUM_THREAD);
  51. $tbl_work = Database :: get_course_table(TABLE_STUDENT_PUBLICATION);
  52. $tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
  53. $table_evaluated[LINK_EXERCISE] = array(TABLE_QUIZ_TEST, 'title', 'id', get_lang('Exercise'));
  54. $table_evaluated[LINK_DROPBOX] = array(TABLE_DROPBOX_FILE, 'name','id', get_lang('Dropbox'));
  55. $table_evaluated[LINK_STUDENTPUBLICATION] = array(TABLE_STUDENT_PUBLICATION, 'url','id', get_lang('Student_publication'));
  56. $table_evaluated[LINK_LEARNPATH] = array(TABLE_LP_MAIN, 'name','id', get_lang('Learnpath'));
  57. $table_evaluated[LINK_FORUM_THREAD] = array(TABLE_FORUM_THREAD, 'thread_title_qualify', 'thread_id', get_lang('Forum'));
  58. $table_evaluated[LINK_ATTENDANCE] = array(TABLE_ATTENDANCE, 'attendance_title_qualify', 'id', get_lang('Attendance'));
  59. $table_evaluated[LINK_SURVEY] = array(TABLE_SURVEY, 'code', 'survey_id', get_lang('Survey'));
  60. $submitted=isset($_POST['submitted'])?$_POST['submitted']:'';
  61. if($submitted==1) {
  62. Display :: display_confirmation_message(get_lang('GradebookWeightUpdated')) . '<br /><br />';
  63. if (isset($_POST['evaluation'])) {
  64. require_once 'lib/be/evaluation.class.php';
  65. $eval_log = new Evaluation();
  66. }
  67. if(isset($_POST['link'])){
  68. require_once 'lib/be/abstractlink.class.php';
  69. //$eval_link_log = new AbstractLink();
  70. }
  71. }
  72. $category_id = (int)$_GET['selectcat'];
  73. $output='';
  74. $sql='SELECT * FROM '.$table_link.' WHERE category_id = '.$category_id;
  75. $result = Database::query($sql);
  76. while($row = Database ::fetch_array($result)) {
  77. //update only if value changed
  78. if(isset($_POST['link'][$row['id']]) && $_POST['link'][$row['id']] != $row['weight']) {
  79. AbstractLink::add_link_log($row['id']);
  80. Database::query('UPDATE '.$table_link.' SET weight = '."'".Database::escape_string(trim($_POST['link'][$row['id']]))."'".' WHERE c_id = '.$course_id.' AND id = '.$row['id']);
  81. $row['weight'] = trim($_POST['link'][$row['id']]);
  82. //Update weight for attendance
  83. $sql = 'SELECT ref_id FROM '.$table_link.' WHERE c_id = '.$course_id.' AND id = '.intval($row['id']).' AND type='.LINK_ATTENDANCE;
  84. $rs_attendance = Database::query($sql);
  85. if (Database::num_rows($rs_attendance) > 0) {
  86. $row_attendance = Database::fetch_array($rs_attendance);
  87. $upd_attendance = 'UPDATE '.$tbl_attendance.' SET attendance_weight ='.floatval($_POST['link'][$row['id']]).'
  88. WHERE c_id = '.$course_id.' AND id = '.intval($row_attendance['ref_id']);
  89. Database::query($upd_attendance);
  90. }
  91. //Update weight into forum thread
  92. $sql_t = 'UPDATE '.$tbl_forum_thread.' SET thread_weight='.floatval($_POST['link'][$row['id']]).'
  93. WHERE c_id = '.$course_id.' AND thread_id = (SELECT ref_id FROM '.$table_link.' WHERE id='.intval($row['id']).' AND type='.LINK_FORUM_THREAD.' AND c_id = '.$course_id.') ';
  94. Database::query($sql_t);
  95. //Update weight into student publication(work)
  96. $sql_t='UPDATE '.$tbl_work.' SET weight='.floatval($_POST['link'][$row['id']]).'
  97. WHERE c_id = '.$course_id.' AND id = (SELECT ref_id FROM '.$table_link.' WHERE id='.intval($row['id']).' AND type = '.LINK_STUDENTPUBLICATION.' AND c_id = '.$course_id.' ) ';
  98. Database::query($sql_t);
  99. }
  100. $tempsql = Database::query('SELECT * FROM '.get_table_type_course($row['type'],$row['course_code']).' WHERE c_id = '.$course_id.' AND '.$table_evaluated[$row['type']][2].' = '.$row['ref_id']);
  101. $resource_name = Database ::fetch_array($tempsql);
  102. //var_dump($resource_name['lp_type']);
  103. if (isset($resource_name['lp_type'])) {
  104. $resource_name=$resource_name[2];
  105. } else {
  106. $resource_name=$resource_name[1];
  107. }
  108. $output.= '<tr><td>'.build_type_icon_tag($row['type']).'</td><td> [ '.$table_evaluated[$row['type']][3].' ] '.$resource_name.'</td><td><input type="hidden" name="link_'.$row['id'].'" value="'.$resource_name.'" /><input size="10" type="text" name="link['.$row['id'].']" value="'.$row['weight'].'"/></td></tr>';
  109. }
  110. $sql = Database::query('SELECT * FROM '.$table_evaluation.' WHERE category_id = '.$category_id);
  111. while($row = Database ::fetch_array($sql)) {
  112. //update only if value changed
  113. if(isset($_POST['evaluation'][$row['id']]) && $_POST['evaluation'][$row['id']] != $row['weight']) {
  114. Evaluation::add_evaluation_log($row['id']);
  115. Database::query('UPDATE '.$table_evaluation.' SET weight = '."'".Database::escape_string(trim($_POST['evaluation'][$row['id']]))."'".' WHERE id = '.$row['id']);
  116. $row['weight'] = trim($_POST['evaluation'][$row['id']]);
  117. }
  118. $type_evaluated = isset($row['type']) ? $table_evaluated[$type_evaluated][3] : null;
  119. $output.= '<tr><td>'.build_type_icon_tag('evalnotempty').'</td><td> [ '.get_lang('Evaluation').$type_evaluated.' ] '.$row['name'].'</td><td><input type="hidden" name="eval_'.$row['id'].'" value="'.$row['name'].'" /><input type="text" size="10" name="evaluation['.$row['id'].']" value="'.$row['weight'].'"/></td></tr>';
  120. }
  121. //by iflorespaz
  122. $my_category=array();
  123. $cat=new Category();
  124. $my_category = $cat->shows_all_information_an_category($my_selectcat);
  125. $my_api_cidreq = api_get_cidreq();
  126. if ($my_api_cidreq=='') {
  127. $my_api_cidreq='cidReq='.$my_category['course_code'];
  128. }
  129. ?>
  130. <div class="actions">
  131. <a href="<?php echo Security::remove_XSS($_SESSION['gradebook_dest']).'?id_session='.api_get_session_id().'&amp;'.$my_api_cidreq ?>&selectcat=<?php echo $category_id ?>"> <?php echo Display::return_icon('back.png',get_lang('FolderView'),'',ICON_SIZE_MEDIUM); ?></a>
  132. </div>
  133. <?php
  134. $warning_message = sprintf(get_lang('TotalWeightMustBeX'), $my_category['weight']);
  135. Display::display_normal_message($warning_message,false);
  136. ?>
  137. <form method="post" action="gradebook_edit_all.php?id_session=<?php echo $_SESSION['id_session'].'&amp;'.$my_api_cidreq ?>&selectcat=<?php echo $category_id?>">
  138. <table class="data_table">
  139. <tr class="row_odd">
  140. <th style="width: 35px;"><?php echo get_lang('Type'); ?></th>
  141. <th><?php echo get_lang('Resource'); ?></th>
  142. <th><?php echo get_lang('Weight'); ?></th>
  143. </tr>
  144. <?php echo $output; ?>
  145. </table>
  146. <input type="hidden" name="submitted" value="1" />
  147. <br />
  148. <button class="save" type="submit" name="name" value="<?php echo get_lang('Save') ?>"><?php echo get_lang('SaveScoringRules') ?></button>
  149. </form>
  150. <?php
  151. Display :: display_footer();