| Server IP : 165.22.154.248 / Your IP : 216.73.217.167 [ Web Server : Apache/2.4.29 (Ubuntu) System : Linux droplet-integra 4.15.0-197-generic #208-Ubuntu SMP Tue Nov 1 17:23:37 UTC 2022 x86_64 User : www-data ( 33) PHP Version : 7.2.24-0ubuntu0.18.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, Domains : 1 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /proc/9427/cwd/avanza-lms.old.bak9874115/api/ |
Upload File : |
<?php
require_once(dirname(__FILE__) . '/../config.php');
session_start();
//variables globales
global $CFG, $USER, $DB;
$arrayRespuesta = array(
'estado' => '0',
'mensaje' => 'Nota no existe',
'data' => $_REQUEST
);
if(isloggedin()) {
if($_SERVER['REQUEST_METHOD'] === 'GET') {
if(isset($_REQUEST['courseid']) && isset($_REQUEST['moduleid'])&& isset($_REQUEST['userid'])) {
$moduleid = $_REQUEST['moduleid'];
$userid = $_REQUEST['userid'];
$courseid = $_REQUEST['courseid'];
$sql = "
SELECT g.finalgrade, i.gradepass
FROM mdl_grade_items i
JOIN mdl_course_modules m ON(i.iteminstance = m.instance)
JOIN mdl_grade_grades g ON ( i.id = g.itemid)
WHERE g.userid =".$userid."
AND m.id =".$moduleid."
AND i.courseid =".$courseid."
";
$result = $DB-> get_record_sql($sql);
if($result) {
$arrayRespuesta = array(
'estado' => '1',
'mensaje' => 'Nota existente',
'data' => $result
);
}
} else {
$arrayRespuesta=array(
'estado'=>'-2',
'mensaje'=>'Parametros incompletos',
'data'=>$_REQUEST
);
}
} else {
$arrayRespuesta = array(
'estado'=>'-5',
'mensaje'=>'Método HTTP incorrecto',
'data'=>$_REQUEST
);
}
}
header('Content-type: application/json');
echo json_encode($arrayRespuesta);
?>