static function getRetour($idpatient, $idapp, $bdd = '') { global $session; $req = new clResultQuery(); $param['base'] = clListeRadios::getBaseFromIdApp($idapp); $okVal = 1; if ($bdd) { $base = $bdd; } else { $base = BDD; } if ($_REQUEST['validerRetourRadio'] == 'Valider') { $param['cw'] = "where r.idpatient=p.idpatient and (etat='d') and r.idpatient={$idpatient} and retour='' and idapplication={$idapp}"; $res = $req->Execute("Fichier", "getRadios", $param, "ResultQuery"); $rel = new clRequete($base, '', '', MYSQL_HOST, MYSQL_USER, MYSQL_PASS); $ras = $rel->exec_requete("select * from radios_enquetes where idradio=" . $res['idradio'][0], 'resultquery'); $erreurs = ''; if ($ras['INDIC_SVC'][2]) { if ($_POST['qualite'] == '#' or !$_POST['interpretable'] or !$_POST['impactdiag'] or !$_POST['impactthera'] or !$_POST['diagradio']) { $okVal = 0; $erreurs = '<font color="red">Tous les items (sauf commentaires) sont obligatoires.</font><br/><br/>'; } else { $okVal = 2; } } if (!$_POST['anomalie']) { $okVal = 0; $erreurs = '<font color="red">Tous les items (sauf commentaires) sont obligatoires.</font><br/><br/>'; } if ($okVal) { $idradio = $res['idradio'][0]; $data['retourid'] = $session->getUid(); $data['retour'] = $_POST['anomalie']; $data['commentaire'] = $_POST['commentaire']; $data['dt_retour'] = date('Y-m-d H:i:s'); $requete = new clRequete($base, "radios", $data); $requete->updRecord("idradio='" . $idradio . "'"); if ($okVal == 2) { unset($data); $data['qualite'] = $_POST['qualite']; $data['interpretable'] = $_POST['interpretable'] == 'oui' ? true : false; $data['impactdiag'] = $_POST['impactdiag'] == 'oui' ? true : false; $data['impactthera'] = $_POST['impactthera'] == 'oui' ? true : false; $data['diagradio'] = $_POST['diagradio']; $requete = new clRequete($base, "radios_enquetes", $data); $requete->updRecord("idradio='" . $idradio . "'"); } } } $param['cw'] = "where r.idpatient=p.idpatient and (etat='d') and r.idpatient={$idpatient} and retour='' and idapplication={$idapp}"; $res = $req->Execute("Fichier", "getRadios", $param, "ResultQuery"); if ($res['INDIC_SVC'][2]) { $mod = new ModeliXe("RadioRetour.html"); $mod->SetModeliXe(); if ($okVal) { $mod->MxText('display', 'none'); } $date = new clDate($res['dt_fin'][0]); $mod->MxText("date", $date->getDate('d/m/Y H:i')); $mod->MxText("detail", clListeRadios::getDetailRadio($res, 0)); $rel = new clRequete($base, '', '', MYSQL_HOST, MYSQL_USER, MYSQL_PASS); $ras = $rel->exec_requete("select * from radios_enquetes where idradio=" . $res['idradio'][0], 'resultquery'); if ($_POST['anomalie'] == 'Oui') { $mod->MxText('ro', 'checked'); } elseif ($_POST['anomalie'] == 'Non') { $mod->MxText('rn', 'checked'); } elseif ($_POST['anomalie'] == 'NR') { $mod->MxText('rr', 'checked'); } elseif ($_POST['anomalie'] == 'NI') { $mod->MxText('ri', 'checked'); } if ($ras['INDIC_SVC'][2]) { $mod->MxText('enquete.typeEnquete', $ras['enquete'][0]); $mod->MxText('enquete.indication', $ras['indication'][0]); $mod->MxText('enquete.recherche', $ras['recherche'][0]); $listeQ['#'] = '--'; $listeQ[0] = '0'; $listeQ[1] = '1'; $listeQ[2] = '2'; $listeQ[3] = '3'; $listeQ[4] = '4'; $listeQ[5] = '5'; $listeQ[6] = '6'; $listeQ[7] = '7'; $listeQ[8] = '8'; $listeQ[9] = '9'; $listeQ[10] = '10'; $mod->MxSelect("enquete.qualite", "qualite", $_POST['qualite'], $listeQ); if ($_POST['interpretable'] == 'oui') { $mod->MxText('enquete.ico', 'checked'); } elseif ($_POST['interpretable'] == 'non') { $mod->MxText('enquete.icn', 'checked'); } if ($_POST['impactdiag'] == 'oui') { $mod->MxText('enquete.idco', 'checked'); } elseif ($_POST['impactdiag'] == 'non') { $mod->MxText('enquete.idcn', 'checked'); } if ($_POST['impactthera'] == 'oui') { $mod->MxText('enquete.itco', 'checked'); } elseif ($_POST['impactthera'] == 'non') { $mod->MxText('enquete.itcn', 'checked'); } $mod->MxText('enquete.diagradio', $_POST['diagradio']); $mod->MxText("erreurs", $erreurs); } else { $mod->MxBloc('enquete', 'delete'); } $mod->MxText('commentaire', $_POST['commentaire']); $mod->MxText("erreurs", $erreurs); $mod->MxHidden("hidden", "navi=" . $session->genNavi($session->getNavi(0), $session->getNavi(1), $session->getNavi(2))); return $mod->MxWrite("1"); } else { return ''; } }