src/Controller/DefaultController.php line 20

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use App\Entity\Users;
  5. use App\Entity\Questionari;
  6. use App\Entity\QuestionariIniziati;
  7. use Doctrine\ORM\EntityManagerInterface;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Doctrine\Persistence\ManagerRegistry;
  13. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  14. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  15. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  17. class DefaultController extends AbstractController
  18. {
  19.     #[Route('/', name: 'app_default_index')]
  20.     public function index(Request $request, ManagerRegistry $doctrine,$moodle_token = "", $uid = ""): Response
  21.     {
  22.         $this->denyAccessUnlessGranted('ROLE_USER');
  23.         $roles = $this->getUser()->getRoles();
  24.         if (in_array("ROLE_MANAGER", $roles)) {
  25.             $corsi = [];
  26.             $questionario_selected = 0;
  27.             $questionario = "";
  28.             $domande = [];
  29.             $thisQuestionario = "";
  30.             $contaCorsi = 0;
  31.             $corsiMoodle  = [];
  32.             $corsoMoodle  = 0;
  33.             $domande_ = [];
  34.             if ((int)$request->get("corsoMoodle") != 0) {
  35.                 $corsoMoodle = (int)$request->get("corsoMoodle");
  36.             }
  37.             if ($moodle_token == "") {
  38.                 $moodle_token = $request->get("moodle_token"); 
  39.             }
  40.             if ($uid == "") {
  41.                 $uid = $request->get("uid");
  42.             }
  43.             if ($moodle_token != "" && $uid != "") {
  44.                 $corsi = json_decode($this->getUser()->getCorsiMoodle());
  45.                 if ($corsi && count($corsi) != 0 && (int)$request->get("corsoMoodle") == 0) {
  46.                     $corsoMoodle = $corsi[0];
  47.                 } else {
  48.                     if ((int)$request->get("corsoMoodle") == 0) {
  49.                         return $this->render('default/errormanager.html.twig', [
  50.                             "errore" => "Non ci sono corsi collegati"
  51.                         ]);
  52.                     }
  53.                 }
  54.                 $i = 0;
  55.                 $options = [];
  56.                 foreach ($corsi as $c) {
  57.                     // recupero i titolo dei corsi a partire dall'id
  58.                     $options[] = "options[ids][".$i."]=".$c;
  59.                     $i++;
  60.                 }
  61.                 $x = exec('curl "https://www.partecipa.eu/webservice/rest/server.php?wstoken=' . $moodle_token . '&wsfunction=core_course_get_courses" -d "' . implode("&", $options) . '&moodlewsrestformat=json"');
  62.                 $corsiJson = json_decode($x);
  63.                 $questoCorso = "";
  64.                 foreach ($corsiJson as $cJ) {
  65.                     $corsiMoodle[$cJ->id] = $cJ->shortname;
  66.                     if ($request->get("corsoMoodle") != "" && $cJ->id == $request->get("corsoMoodle")) {
  67.                         $questoCorso = $cJ;
  68.                     }
  69.                 }
  70.                 //var_dump($corsi);
  71.                 $questionari = $doctrine->getRepository(Questionari::class)->findBy(["corso_id" => $corsi]);
  72.                 $quests = [];
  73.                 $qid = 0;
  74.                 foreach ($questionari as $q) {
  75.                     if (!isset($quests[$q->getQuestionario()->getId()])) {
  76.                         $quests[$q->getQuestionario()->getId()] = $q->getQuestionario()->getTitolo();
  77.                         if ($qid == 0) {
  78.                             $qid = $q->getQuestionario()->getId();
  79.                         }
  80.                     }
  81.                 }
  82.                 if (count($quests) == 1) {
  83.                     $questionario_selected = 1;
  84.                     if((int)$request->get("corsoMoodle") != 0) {
  85.                         $questionari = $doctrine->getRepository(Questionari::class)->findBy(["corso_id" => (int)$request->get("corsoMoodle")]);
  86.                     } else {
  87.                         $questionari = $doctrine->getRepository(Questionari::class)->findBy(["corso_id" => $corsi,"questionario" => $qid]);
  88.                     }
  89.                     foreach ($questionari as $q) {
  90.                         $contaCorsi++;
  91.                     }
  92.                     $thisQuestionario = $questionari[0]->getQuestionario();
  93.                 }
  94.                 if ((int)$request->get("questionario") != 0) {
  95.                     if ((int)$request->get("corsoMoodle") != 0) {
  96.                         $questionari = $doctrine->getRepository(Questionari::class)->findBy(["corso_id" => (int)$request->get("corsoMoodle"), "questionario" => (int)$request->get("questionario")]);
  97.                     } else {
  98.                         $questionari = $doctrine->getRepository(Questionari::class)->findBy(["corso_id" => $corsi, "questionario" => (int)$request->get("questionario")]);
  99.                     }
  100.                     $thisQuestionario = $questionari[0]->getQuestionario();
  101.                     $questionario_selected = 1;
  102.                     $questionario = (int)$request->get("questionario");
  103.                     foreach ($questionari as $q) {
  104.                         $contaCorsi++;
  105.                     }
  106.                 }
  107.                 if ($questionario_selected == 1) {
  108.                     // ho scelto il singolo questionario
  109.                     if ($corsoMoodle == 0) {
  110.                         // sono nell'aggregato multicorso
  111.                         // qui ci sono n questionari compilati che potrebbero avere sulla domanda "docente" un comportamento anomalo tra un questioanrio e l'altro ( 1 docente , 2 docenti .. n docenti a seconda del corso )
  112.                         // in questo caso costruisco il modello a partire dal "root model" e poi aggrego le risposte "docente" mediandole per renderle singole.
  113.                         $domande = $thisQuestionario->getDomandes();
  114.                         foreach ($domande as $d) {
  115.                             if ($d->getTipoRisposta() == "linkert5") {
  116.                                 $opt = $d->getOpzioniRisposta();
  117.                                 $opt = explode("\n",$opt);
  118.                                 $range = $opt[0];
  119.                                 $range = explode("#",$range);
  120.                                 $range = explode("|",$range[1]);
  121.                                 $argomenti = $opt[1];
  122.                                 $argomenti = explode("#",$argomenti);
  123.                                 $argomenti = explode("|",$argomenti[1]);
  124.                                 $domande_["d".$d->getPosizione()] = ["domanda" => $d->getDomanda(), "argomenti" => [], "range" => []];
  125.                                 foreach ($range as $r) {
  126.                                     $r2 = explode(":", $r);
  127.                                     $domande_["d" . $d->getPosizione()]["range"][$r2[0]] = $r2[1];
  128.                                 }
  129.                                 $i = 0;
  130.                                 foreach ($argomenti as $a) {
  131.                                     $domande_["d" . $d->getPosizione()]["argomenti"][] = ["domanda" => $a,"range" => []];
  132.                                     foreach ($range as $r) {
  133.                                         $r2 = explode(":", $r);
  134.                                         $domande_["d".$d->getPosizione()]["argomenti"][$i]["range"][$r2[0]] = 0;
  135.                                     }    
  136.                                     $i++;
  137.                                 }
  138.                             }
  139.                             if ($d->getTipoRisposta()=="docente") {
  140.                                 $opt = $d->getOpzioniRisposta();
  141.                                 $opt = explode("\n", $opt);
  142.                                 $range = $opt[0];
  143.                                 $range = explode("#", $range);
  144.                                 $range = explode("|", $range[1]);
  145.                                 $argomenti = $opt[1];
  146.                                 $argomenti = explode("#", $argomenti);
  147.                                 $argomenti = explode("|", $argomenti[1]);
  148.                                 $docente = "";
  149.                                 $domande_["d" . $d->getPosizione()] = ["domanda" => $d->getDomanda(), "argomenti" => [], "range" => [], "docente" => $docente];
  150.                                 foreach ($range as $r) {
  151.                                     $r2 = explode(":", $r);
  152.                                     $domande_["d" . $d->getPosizione()]["range"][$r2[0]] = $r2[1];
  153.                                 }
  154.                                 $i = 0;
  155.                                 foreach ($argomenti as $a) {
  156.                                     $domande_["d".$d->getPosizione()]["argomenti"][] = ["domanda" => $a, "range" => []];
  157.                                     foreach ($range as $r) {
  158.                                         $r2 = explode(":", $r);
  159.                                         $domande_["d" . $d->getPosizione()]["argomenti"][$i]["range"][$r2[0]] = 0;
  160.                                     }
  161.                                     $i++;
  162.                                 }
  163.                             }
  164.                         }
  165.                         foreach ($questionari as $q) {
  166.                             $listaquestionari[] = $q->getId();
  167.                         }
  168.                         $questionariIniziati = $doctrine->getRepository(QuestionariIniziati::class)->findBy(["questionario" => $listaquestionari, "status" => 1]);
  169.                         $risposteDocente = [];
  170.                         $quantiDocenti = 0;
  171.                         $giro = 0;
  172.                         foreach ($questionariIniziati as $qi) {
  173.                             $posizioneMenoUno = 0;
  174.                             $risposte = $qi->getRispostes();
  175.                             foreach ($risposte as $r) {
  176.                                 if ($r->getDomanda()->getTipoRisposta() == "linkert5") {
  177.                                     $risposta = $r->getRisposta();
  178.                                     if ($risposta != "") {
  179.                                         $ris = explode("|", $risposta);
  180.                                         foreach ($ris as $rr) {
  181.                                             $ris2 = explode(":", $rr);
  182.                                             $posizione = $r->getPosizione();
  183.                                             if ($posizioneMenoUno) {
  184.                                                 $posizione--;
  185.                                             }
  186.                                             if (!isset($domande_["d" . $posizione])) {
  187.                                             } else {
  188.                                                 $domande_["d" . $posizione]["argomenti"][($ris2[0] - 1)]["range"][$ris2[1]]++;
  189.                                             }
  190.                                         }
  191.                                     }
  192.                                 }
  193.                                 if ($r->getDomanda()->getTipoRisposta() == "docente") {
  194.                                     if ($quantiDocenti == 1) {
  195.                                         $risposteDocente["posizione"] = $r->getPosizione();
  196.                                     }
  197.                                     if ($quantiDocenti > 1) {
  198.                                         $posizioneMenoUno = 1;
  199.                                     }
  200.                                     $risposta = $r->getRisposta();
  201.                                     if ($risposta != "") {
  202.                                         $ris = explode("|", $risposta);
  203.                                         $opzioni =  $r->getOpzioniRisposta();
  204.                                         $opzioni = explode("\n", $opzioni);
  205.                                         $range = $opzioni[0];
  206.                                         $range= explode("#", $range);
  207.                                         $range = explode("|", $range[1]); 
  208.                                         $argomenti = $opzioni[1];
  209.                                         $argomenti= explode("#", $argomenti);
  210.                                         $argomenti = explode("|", $argomenti[1]); 
  211.                                         if (isset($opzioni[2])) {
  212.                                             $docente = $opzioni[2];
  213.                                             $docente = explode("Teacher:", $docente);
  214.                                             $docente = json_decode($docente[1]);
  215.                                             $docente = $docente->id;
  216.                                         } else {
  217.                                             $docente = 0;
  218.                                         }
  219.                                         if (!isset($risposteDocente["d" . $docente])) {
  220.                                             $risposteDocente["d" . $docente] = ["argomenti" => []]; 
  221.                                             $i = 0;
  222.                                             foreach ($argomenti as $a) {
  223.                                                 $risposteDocente["d" . $docente]["argomenti"][] = ["domanda" => $a, "range" => []];
  224.                                                 foreach ($range as $r) {
  225.                                                     $r2 = explode(":", $r);
  226.                                                     $risposteDocente["d" . $docente]["argomenti"][$i]["range"][$r2[0]] = 0;
  227.                                                 }
  228.                                                 $i++;
  229.                                             }
  230.                                         }
  231.                                         foreach ($ris as $rr) {
  232.                                             $ris2 = explode(":", $rr);
  233.                                             $risposteDocente["d" . $docente]["argomenti"][($ris2[0] - 1)]["range"][$ris2[1]]++;
  234.                                         }
  235.                                     }
  236.                                     $quantiDocenti++;
  237.                                 }
  238.                             }
  239.                             $giro++;
  240.                         }
  241.                         $nDocenti = count($risposteDocente) - 1;
  242.                         $finalRisposteDocente = [
  243.                             "domanda" => "<p><strong>2. Valutazione docente</strong></p>",
  244.                             "argomenti" => [],
  245.                             "range" => []
  246.                         ];
  247.                         foreach ($range as $rrr) {
  248.                             $r_ = explode(":", $rrr);
  249.                             $finalRisposteDocente["range"][$r_[0]] = $r_[1];
  250.                         }
  251.                         $giro = 1;
  252.                         foreach ($risposteDocente as $k=>$v) {
  253.                             if ($k == "posizione") {
  254.                                 continue;
  255.                             }
  256.                             foreach ($v as $k2 => $v2) {
  257.                                 foreach ($v2 as $v3 => $k3) {
  258.                                     if (!isset($finalRisposteDocente["argomenti"][$v3])) {
  259.                                         $finalRisposteDocente["argomenti"][$v3] = ["domanda" => $k3["domanda"], "range" => []];
  260.                                     }
  261.                                     foreach ($k3["range"] as $k4 => $v4) {
  262.                                         if (!isset($finalRisposteDocente["argomenti"][$v3]["range"])) {
  263.                                             $finalRisposteDocente["argomenti"][$v3]["range"] = [];
  264.                                         }
  265.                                         if (!isset($finalRisposteDocente["argomenti"][$v3]["range"][$k4])) {
  266.                                             $finalRisposteDocente["argomenti"][$v3]["range"][$k4] = 0;
  267.                                         }
  268.                                         $finalRisposteDocente["argomenti"][$v3]["range"][$k4] += $v4/$nDocenti;
  269.                                     }
  270.                                 }
  271.                             }
  272.                         }
  273.                         $domande_["d" . $risposteDocente["posizione"]] = $finalRisposteDocente;
  274.                     } else {
  275.                         // sono nel dettaglio singolo corso
  276.                         // qui ci sono n questionari compilati e come "modello" posso ricostruire a partire da domane
  277.                         $questionarioModello = $questionari[0];
  278.                         $domande = $questionarioModello->getDomandes();
  279.                         foreach ($domande as $d) {
  280.                             if ($d->getTipoRisposta() == "linkert5") {
  281.                                 $opt = $d->getOpzioniRisposta();
  282.                                 $opt = explode("\n", $opt);
  283.                                 $range = $opt[0];
  284.                                 $range = explode("#", $range);
  285.                                 $range = explode("|", $range[1]);
  286.                                 $argomenti = $opt[1];
  287.                                 $argomenti = explode("#", $argomenti);
  288.                                 $argomenti = explode("|", $argomenti[1]);
  289.                                 $domande_["d" . $d->getPosizione()] = ["domanda" => $d->getDomanda(), "argomenti" => [], "range" => []];
  290.                                 foreach ($range as $r) {
  291.                                     $r2 = explode(":", $r);
  292.                                     $domande_["d" . $d->getPosizione()]["range"][$r2[0]] = $r2[1];
  293.                                 }
  294.                                 $i = 0;
  295.                                 foreach ($argomenti as $a) {
  296.                                     $domande_["d" . $d->getPosizione()]["argomenti"][] = ["domanda" => $a,"range" => []];
  297.                                     foreach ($range as $r) {
  298.                                         $r2 = explode(":", $r);
  299.                                         $domande_["d" . $d->getPosizione()]["argomenti"][$i]["range"][$r2[0]] = 0;
  300.                                     } 
  301.                                     $i++;
  302.                                 }
  303.                             }
  304.                             if ($d->getTipoRisposta() == "docente") {
  305.                                 $opt = $d->getOpzioniRisposta();
  306.                                 $opt = explode("\n", $opt);
  307.                                 $range = $opt[0];
  308.                                 $range = explode("#", $range);
  309.                                 $range = explode("|", $range[1]);
  310.                                 $argomenti = $opt[1];
  311.                                 $argomenti = explode("#", $argomenti);
  312.                                 $argomenti = explode("|", $argomenti[1]);
  313.                                 $docente = "";
  314.                                 if (isset($opt[2])) {
  315.                                     $docente = explode("Teacher:", $opt[2]);
  316.                                     $docente = json_decode($docente[1]);
  317.                                     $docente = $docente->name;
  318.                                 }
  319.                                 $domande_["d" . $d->getPosizione()] = ["domanda" => $d->getDomanda(), "argomenti" => [], "range" => [], "docente" => $docente];
  320.                                 foreach ($range as $r) {
  321.                                     $r2 = explode(":", $r);
  322.                                     $domande_["d" . $d->getPosizione()]["range"][$r2[0]] = $r2[1];
  323.                                 }
  324.                                 $i = 0;
  325.                                 foreach ($argomenti as $a) {
  326.                                     $domande_["d" . $d->getPosizione()]["argomenti"][] = ["domanda" => $a,"range" => []];
  327.                                     foreach ($range as $r) {
  328.                                         $r2 = explode(":", $r);
  329.                                         $domande_["d" . $d->getPosizione()]["argomenti"][$i]["range"][$r2[0]] = 0;
  330.                                     }    
  331.                                     $i++;
  332.                                 }
  333.                             }
  334.                         }
  335.                         foreach ($questionari as $q) {
  336.                             $listaquestionari[] = $q->getId();
  337.                         }
  338.                         $questionariIniziati = $doctrine->getRepository(QuestionariIniziati::class)->findBy(["questionario" => $listaquestionari, "status" => 1]);
  339.                         foreach ($questionariIniziati as $qi) {
  340.                             $risposte = $qi->getRispostes();
  341.                             foreach ($risposte as $r) {
  342.                                 if ($r->getDomanda()->getTipoRisposta() == "linkert5") {
  343.                                     $risposta = $r->getRisposta();
  344.                                     if ($risposta != "") {
  345.                                         $ris = explode("|", $risposta);
  346.                                         foreach ($ris as $rr) {
  347.                                             $ris2 = explode(":", $rr);
  348.                                             if (isset($domande_["d" . $r->getPosizione()]["argomenti"][($ris2[0] - 1)]["range"][$ris2[1]])) {
  349.                                                 $domande_["d" . $r->getPosizione()]["argomenti"][($ris2[0] - 1)]["range"][$ris2[1]]++;
  350.                                             }
  351.                                         }
  352.                                     }
  353.                                 }
  354.                                 if ($r->getDomanda()->getTipoRisposta() == "docente") {
  355.                                     $risposta = $r->getRisposta();
  356.                                     if ($risposta != "") {
  357.                                         $ris = explode("|", $risposta);
  358.                                         foreach ($ris as $rr) {
  359.                                             $ris2 = explode(":", $rr);
  360.                                             if (isset($domande_["d" . $r->getPosizione()]["argomenti"][($ris2[0] - 1)]["range"][$ris2[1]])) {
  361.                                                 $domande_["d" . $r->getPosizione()]["argomenti"][($ris2[0]-1)]["range"][$ris2[1]]++;
  362.                                             }
  363.                                         }
  364.                                     }
  365.                                 }
  366.                             }
  367.                         }
  368.                     }
  369.                 } else {
  370.                     $questionariIniziati = [];
  371.                 }
  372.                 if ($request->get("xls") == 1) {
  373.                     $spreadsheet = new Spreadsheet();
  374.                     $sheet = $spreadsheet->getActiveSheet();
  375.                     $sheet->setTitle("Export");
  376.                     $sheet->setCellValue('A1', $thisQuestionario->getTitolo());
  377.                     if ($questoCorso != "") {
  378.                         $sheet->setCellValue('A2', $questoCorso->fullname);
  379.                         $sheet->setCellValue('C2', $questoCorso->idnumber);
  380.                         $sheet->setCellValue('D2', date("d/m/Y", $questoCorso->startdate));
  381.                         $sheet->setCellValue('E2', date("d/m/Y", $questoCorso->enddate));
  382.                     } 
  383.                     $sheet->setCellValue('A3', "questionari iniziati");
  384.                     $sheet->setCellValue('B3', count($questionariIniziati));
  385.                     $sheet->setCellValue('C4', "Insoddisfacente");
  386.                     $sheet->setCellValue('D4', "Poco Soddisfacente");
  387.                     $sheet->setCellValue('E4', "Neutrale");
  388.                     $sheet->setCellValue('F4', "Soddisfacente");
  389.                     $sheet->setCellValue('G4', "Molto Soddisfacente");
  390.                     $i = 5;
  391.                     foreach ($domande_ as $d) {
  392.                         $sheet->setCellValue('A' . $i, strip_tags($d["domanda"]));
  393.                         if (isset($d["docente"])) {
  394.                             $i++;
  395.                             $sheet->setCellValue('A' . $i, "Docente: " . strip_tags($d["docente"]));
  396.                         }
  397.                         foreach ($d["argomenti"] as $a) {
  398.                             $i++;
  399.                             $sheet->setCellValue('A' . $i, strip_tags($a["domanda"]));
  400.                             foreach ($a["range"] as $k => $v) {
  401.                                 if ($k == 1) {
  402.                                     $sheet->setCellValue('C' . $i, $v);
  403.                                 }
  404.                                 if ($k == 2) {
  405.                                     $sheet->setCellValue('D' . $i, $v);
  406.                                 }
  407.                                 if ($k == 3) {
  408.                                     $sheet->setCellValue('E' . $i, $v);
  409.                                 }
  410.                                 if ($k == 4) {
  411.                                     $sheet->setCellValue('F' . $i, $v);
  412.                                 }
  413.                                 if ($k == 5) {
  414.                                     $sheet->setCellValue('G' . $i, $v);
  415.                                 }
  416.                             }
  417.                         }
  418.                         $i++;
  419.                     }
  420.                     // Create your Office 2007 Excel (XLSX Format)
  421.                     $writer = new Xlsx($spreadsheet);
  422.                     // Create a Temporary file in the system
  423.                     $fileName = 'export_questionario.xlsx';
  424.                     $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  425.                     // Create the excel file in the tmp directory of the system
  426.                     $writer->save($temp_file);
  427.                     // Return the excel file as an attachment
  428.                     return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  429.                 }
  430.                 return $this->render('default/indexmanager.html.twig', [
  431.                     "corsi" => $corsi,
  432.                     "quests" => $quests,
  433.                     "questionari" => $questionari,
  434.                     "questionario" => $questionario,
  435.                     "questionariIniziati" => count($questionariIniziati),
  436.                     "thisQuestionario" => $thisQuestionario,
  437.                     "moodle_token" => $moodle_token,
  438.                     "domande" => $domande_,
  439.                     "corsiMoodle" => $corsiMoodle,
  440.                     "corsoMoodle" => $corsoMoodle,
  441.                     "uid" => $uid,
  442.                     "questionario_selected" => $questionario_selected,
  443.                 ]); 
  444.             } else {
  445.                 echo "49";
  446.                 echo "moodle_token: ".$moodle_token."<br />";
  447.                 echo "post moodle token: ".$request->get("moodle_token");
  448.                 exit();
  449.                 return $this->render('default/errormanager.html.twig', []);
  450.             }
  451.         } else {
  452.             $q = $doctrine->getRepository(Questionari::class)->findBy(["user" => $this->getUser(), "questionario" => null]);
  453.             return $this->render('default/index.html.twig', [
  454.                 "questionari" => $q
  455.             ]);
  456.         }
  457.     }
  458.     #[Route('/firewall', name: 'app_default_firewall')]
  459.     public function firewall(Request $request): Response
  460.     {
  461.         var_dump($_REQUEST);
  462.         exit();
  463.     }
  464. }