123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175 |
- <?php
- $language_file = 'exercice';
- require_once '../inc/global.inc.php';
- require_once 'exercise.class.php';
- require_once 'question.class.php';
- require_once 'answer.class.php';
- $debug=0;
- $my_course_code = $_GET['cid'];
- if(!empty($_REQUEST['exe'])){
- $my_exe = $_REQUEST['exe'];
- }else{
- $my_exe = null;
- }
- if(!empty($_REQUEST['qst'])){
- $my_qst = $_REQUEST['qst'];
- }else{
- $my_qst = null;
- }
- if(!empty($_REQUEST['usr'])){
- $my_usr = $_REQUEST['usr'];
- }else{
- $my_usr = null;
- }
- if(!empty($_REQUEST['cidReq'])){
- $my_cid = $_REQUEST['cidReq'];
- }else{
- $my_cid = null;
- }
- if(!empty($_POST['action'])){
- $action = $_POST['action'];
- }else{
- $action = '';
- }
- if (empty($my_qst) or empty($my_usr) or empty($my_cid) or empty($my_exe)){
- header('Location: exercice.php');
- exit();
- }
- if(!$is_courseTutor)
- {
- api_not_allowed();
- }
- $obj_question = Question :: read($my_qst);
- if (isset($_SESSION['gradebook'])){
- $gradebook= $_SESSION['gradebook'];
- }
- if (!empty($gradebook) && $gradebook=='view') {
- $interbreadcrumb[]= array (
- 'url' => '../gradebook/'.$_SESSION['gradebook_dest'],
- 'name' => get_lang('ToolGradebook')
- );
- }
- $nameTools=get_lang('Exercice');
- $interbreadcrumb[]=array("url" => "exercice.php","name" => get_lang('Exercices'));
- $my_msg = 'No change.';
- $courseId = api_get_course_int_id();
- if ($action == 'mark') {
- if (!empty($_POST['score']) AND $_POST['score'] < $obj_question->selectWeighting() AND $_POST['score'] >= 0) {
-
- $exercise_table = Database::get_main_table('track_e_exercices');
-
- $sql = "SELECT * FROM $exercise_table
- WHERE exe_user_id = '".Database::escape_string($my_usr)."' AND
- c_id = '".$courseId."' AND
- exe_exo_id = '".Database::escape_string($my_exe)."'
- ORDER BY exe_date DESC";
-
- $res = Database::query($sql);
- if (Database::num_rows($res)>0){
- $row = Database::fetch_array($res);
-
-
- $my_score = $row['exe_result'] + $_POST['score'];
- $sql = "UPDATE $exercise_table SET exe_result = '$my_score'
- WHERE exe_id = '".$row['exe_id']."'";
-
- $res = Database::query($sql);
- $my_msg = get_lang('MarkIsUpdated');
- } else {
- $my_score = $_POST['score'];
- $reallyNow = api_get_utc_datetime();
- $sql = "INSERT INTO $exercise_table (
- exe_user_id,
- c_id,
- exe_exo_id,
- exe_result,
- exe_weighting,
- exe_date
- ) VALUES (
- '".Database::escape_string($my_usr)."',
- '".$courseId."',
- '".Database::escape_string($my_exe)."',
- '".Database::escape_string($my_score)."',
- '".Database::escape_string($obj_question->selectWeighting())."',
- ".$reallyNow."
- )";
-
-
-
-
-
-
-
-
-
- $res = Database::query($sql);
- $my_msg = get_lang('MarkInserted');
- }
-
-
- } else {
- $my_msg .= get_lang('TotalScoreTooBig');
- }
- }
- Display::display_header($nameTools,"Exercise");
- $objAnswerTmp = new Answer();
- $objAnswerTmp->selectAnswer($answerId);
- if($action == 'mark'){
- echo $my_msg.'<br />
- <a href="exercice.php?cidReq='.$cidReq.'">'.get_lang('Back').'</a>';
- } else {
- echo '<h2>'.$obj_question->question .':</h2>
- '.$obj_question->selectTitle().'<br /><br />
- '.get_lang('PleaseGiveAMark').
- "<form action='' method='POST'>\n"
- ."<input type='hidden' name='exe' value='$my_exe'>\n"
- ."<input type='hidden' name='usr' value='$my_usr'>\n"
- ."<input type='hidden' name='cidReq' value='$my_cid'>\n"
- ."<input type='hidden' name='action' value='mark'>\n"
- ."<select name='score'>\n";
- for($i=0 ; $i<$obj_question->selectWeighting() ; $i++){
- echo '<option>'.$i.'</option>';
- }
- echo "</select>".
- "<input type='submit' name='submit' value='".get_lang('Ok')."'>\n"
- ."</form>";
- }
- Display::display_footer();
|