136 lines
3.0 KiB
PHP
136 lines
3.0 KiB
PHP
|
<?php
|
||
|
|
error_reporting(0);
|
||
|
|
require_once "../config.php";
|
||
|
|
|
||
|
|
$idencuesta = $_POST['idencuesta'];
|
||
|
|
$numempl = $_POST['numempl'];
|
||
|
|
|
||
|
|
|
||
|
|
$sql="SELECT
|
||
|
|
e.idencuesta,
|
||
|
|
e.titulo,
|
||
|
|
e.descripcion,
|
||
|
|
e.estilo
|
||
|
|
FROM
|
||
|
|
encuestas as e
|
||
|
|
WHERE
|
||
|
|
e.idencuesta = $idencuesta";
|
||
|
|
|
||
|
|
$sqlCompleted = "SELECT
|
||
|
|
est.estado
|
||
|
|
FROM
|
||
|
|
encuesta_estado as est
|
||
|
|
WHERE
|
||
|
|
est.numempl = '$numempl' AND idencuesta = $idencuesta";
|
||
|
|
|
||
|
|
$sqlQ="SELECT
|
||
|
|
ep.idpregunta,
|
||
|
|
ep.titulo,ep.descripcion_p,
|
||
|
|
ep.orden_p
|
||
|
|
FROM
|
||
|
|
encuestas_preguntas as ep
|
||
|
|
WHERE
|
||
|
|
ep.idencuesta = $idencuesta
|
||
|
|
ORDER BY ep.orden_p asc";
|
||
|
|
|
||
|
|
|
||
|
|
global $link;
|
||
|
|
dbConnect();
|
||
|
|
$return = new stdClass();
|
||
|
|
$return->questions = [];
|
||
|
|
$return->estado = '';
|
||
|
|
|
||
|
|
if($result = mysqli_query($link, $sql)){
|
||
|
|
if ( mysqli_num_rows($result) <= 0) {
|
||
|
|
$return->code = "300";
|
||
|
|
$return->icon = "warning";
|
||
|
|
$return->msg="Sin encuestas";
|
||
|
|
}else{
|
||
|
|
while ($row = mysqli_fetch_assoc($result)){
|
||
|
|
$return->datos = $row;
|
||
|
|
}
|
||
|
|
if($resultQ = mysqli_query($link, $sqlQ)){
|
||
|
|
if ( mysqli_num_rows($result) <= 0) {
|
||
|
|
$return->code = "300";
|
||
|
|
$return->icon = "warning";
|
||
|
|
$return->msg="Sin preguntas";
|
||
|
|
}else{
|
||
|
|
while ($row = mysqli_fetch_assoc($resultQ)){
|
||
|
|
$questions[] = $row;
|
||
|
|
}
|
||
|
|
|
||
|
|
$alerts = [];
|
||
|
|
$totalPreguntasRespuestas = 0;
|
||
|
|
|
||
|
|
foreach ($questions as $key => $q) {
|
||
|
|
$answers = [];
|
||
|
|
$sqlAns = "SELECT
|
||
|
|
*
|
||
|
|
FROM
|
||
|
|
encuestas_respuestas as er
|
||
|
|
WHERE
|
||
|
|
er.idpregunta = ".$q['idpregunta']."";
|
||
|
|
|
||
|
|
if($resultAns = mysqli_query($link, $sqlAns)){
|
||
|
|
if ( mysqli_num_rows($resultAns) <= 0) {
|
||
|
|
array_push($alerts, "Sin respuestas");
|
||
|
|
$answers = [];
|
||
|
|
}else{
|
||
|
|
$totalPreguntasRespuestas++;
|
||
|
|
while ($row = mysqli_fetch_assoc($resultAns)){
|
||
|
|
$answers[] = $row;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$questions[$key]['respuestas'] = $answers;
|
||
|
|
}else{
|
||
|
|
$return->code = "300";
|
||
|
|
$return->icon = "warning";
|
||
|
|
$return->msg="Sin respuestas";
|
||
|
|
array_push($alerts, "Consulta fallo! SQL: ".$sqlAns."<br><br> Error: ".mysqli_error($link));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($totalPreguntasRespuestas == sizeof($questions)) {
|
||
|
|
$return->code = "200";
|
||
|
|
$return->icon = "success";
|
||
|
|
$return->msg="Encuestas";
|
||
|
|
}else{
|
||
|
|
$return->code = "300";
|
||
|
|
$return->icon = "error";
|
||
|
|
$return->msg="Ocurrio un error al recuperar las respuestas";
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
}else{
|
||
|
|
$return->code = "300";
|
||
|
|
$return->icon = "warning";
|
||
|
|
$return->msg="Sin preguntas";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}else{
|
||
|
|
$return->code = "400";
|
||
|
|
$return->icon = "error";
|
||
|
|
$return->msg="No se pudieron cargar los datos de la encuesta intenta más tarde.";
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if($resultCompleted = mysqli_query($link, $sqlCompleted)){
|
||
|
|
if ( mysqli_num_rows($resultCompleted) <= 0) {
|
||
|
|
$return->estado = 'no completado';
|
||
|
|
}else{
|
||
|
|
while ($row = mysqli_fetch_assoc($resultCompleted)){
|
||
|
|
$return->estado = $row['estado'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}else{
|
||
|
|
$return->estado = 'no completado';
|
||
|
|
}
|
||
|
|
|
||
|
|
$return->questions = $questions;
|
||
|
|
|
||
|
|
echo json_encode($return, JSON_UNESCAPED_UNICODE);
|
||
|
|
exit;
|
||
|
|
|
||
|
|
?>
|