Here is the list of the most complex expressions used in the code. A complex expression is an expression that requires more than 20 tokens to be build.
Literal arrays are omitted.
File | Count | Expression |
---|---|---|
/class/msAgenda.php:776 | 1 | serialize(array('start' => $oldEventData['start'], 'end' => $oldEventData['end'], 'type' => $oldEventData['type'], 'statut' => $oldEventData['statut'], 'absente' => $oldEventData['absente'], 'attente' => $oldEventData['attente'], 'motif' => $oldEventData['motif'])) |
/public_html/install.php:151 | 1 | exec('mysql -u ' . escapeshellarg($p['config']['sqlUser']) . ' -p' . escapeshellarg($p['config']['sqlPass']) . ' -h' . escapeshellarg($p['config']['sqlServeur']) . ' --default-character-set=utf8 ' . escapeshellarg($p['config']['sqlBase']) . ' < ' . $homepath . 'upgrade/base/sqlInstall.sql') |
/cron/baseBackup.php:59 | 2 | exec('mysqldump -u ' . escapeshellarg($p['config']['sqlUser']) . ' -p' . escapeshellarg($p['config']['sqlPass']) . ' ' . escapeshellarg($p['config']['sqlBase']) . ' > ' . escapeshellarg($p['config']['backupLocation'] . $p['config']['sqlBase'] . '_' . $today . '.sql')) |
/cron/baseGzipBackup.php:59 | 2 | exec('mysqldump -u ' . escapeshellarg($p['config']['sqlUser']) . ' -p' . escapeshellarg($p['config']['sqlPass']) . ' ' . escapeshellarg($p['config']['sqlBase']) . ' > ' . escapeshellarg($p['config']['backupLocation'] . $p['config']['sqlBase'] . '_' . $today . '.sql')) |
/controlers/patient/actions/inc-ajax-prepareEcho.php:72 | 1 | exec("dump2dcm " . $p['config']['workingDirectory'] . $p['user']['id'] . "/workList" . $p['user']['id'] . ".txt " . $p['config']['dicomWorkListDirectory'] . "workList" . $p['user']['id'] . ".wl") |
/public_html/install.php:170 | 1 | exec('mysql -u ' . escapeshellarg($p['config']['sqlUser']) . ' -p' . escapeshellarg($p['config']['sqlPass']) . ' -h' . escapeshellarg($p['config']['sqlServeur']) . ' --default-character-set=utf8 ' . escapeshellarg($p['config']['sqlBase']) . ' < ' . $homepath . 'upgrade/' . $module . '/sqlInstall.sql') |
/controlers/configuration/actions/inc-action-configApplyUpdates.php:78 | 1 | exec('mysqldump -u ' . escapeshellarg($p['config']['sqlUser']) . ' -p' . escapeshellarg($p['config']['sqlPass']) . ' ' . escapeshellarg($p['config']['sqlBase']) . ' > ' . escapeshellarg($p['config']['backupLocation'] . $p['config']['sqlBase'] . '_' . date('Y-m-d_H:i:s') . '-avant_update.sql')) |
/class/msLapPatient.php:306 | 2 | $rd = array('statut' => 'ok', 'date' => $creatinineMgL['updateDate'], 'from' => $creatinineMgL['prenom'] . ' ' . $creatinineMgL['nom'], 'fromID' => $creatinineMgL['fromID'], 'value' => $creatinineMgL['value'], 'units' => 'mg/L') |
/class/msLapPatient.php:317 | 2 | $rd = array('statut' => 'ok', 'date' => $creatinineMicroMolL['updateDate'], 'from' => $creatinineMicroMolL['prenom'] . ' ' . $creatinineMicroMolL['nom'], 'fromID' => $creatinineMicroMolL['fromID'], 'value' => $creatinineMicroMolL['value'], 'units' => 'µmol/L') |
/class/msLapPatient.php:283 | 2 | $rd = array('statut' => 'ok', 'date' => $creatinineMgL['updateDate'], 'from' => $creatinineMgL['prenom'] . ' ' . $creatinineMgL['nom'], 'fromID' => $creatinineMgL['fromID'], 'value' => $creatinineMgL['value'], 'units' => 'mg/L') |
/class/msLapPatient.php:294 | 2 | $rd = array('statut' => 'ok', 'date' => $creatinineMicroMolL['updateDate'], 'from' => $creatinineMicroMolL['prenom'] . ' ' . $creatinineMicroMolL['nom'], 'fromID' => $creatinineMicroMolL['fromID'], 'value' => $creatinineMicroMolL['value'], 'units' => 'µmol/L') |
/class/msForm.php:418 | 1 | $f['structure'][][1] = array('size' => 'col-12', 'elements' => array('0' => array('type' => 'form', 'value' => array('id' => '0', 'name' => '0', 'label' => $label, 'formType' => 'submit', 'class' => $class), ), ), ) |
/class/msForm.php:1001 | 1 | $cleanform[] = str_pad($match[1] . '- ' . $type['name'] . trim($match[3]), 50) . " \t\t#" . str_pad($type['id'], 4) . ' ' . str_replace("'", " ", $type['label']) |
/class/msClicRDV.php:166 | 1 | $eventClic['vevent'] = array('start' => $event['start'], 'end' => $event['end'], 'calendar_id' => $this->_calID, 'text' => $text, 'intervention_id' => $event['type'] == '[off]' ? 0 : $interventions[$event['type']][0], 'taker' => 'MedShakeEHR', 'comments' => $event['motif'], 'from_web' => 0) |
/class/msClicRDV.php:379 | 1 | $eventClic['vevent'] = array('start' => $vlocal['start'], 'end' => $vlocal['end'], 'calendar_id' => $this->_calID, 'text' => $text, 'intervention_id' => $vlocal['type'] == '[off]' ? 0 : $interventions[0][$vlocal['type']][0], 'taker' => 'MedShakeEHR', 'comments' => $vlocal['motif'], 'from_web' => 0) |
/class/msPeopleSearch.php:208 | 1 | $sp['where'][0] = "(concat(d" . $name2typeID['birthname'] . ".value, ' ', d" . $name2typeID['firstname'] . ".value) like '%" . msSQL::cleanVar($this->_criteresRecherche['birthname']) . "%' or concat(d" . $name2typeID['lastname'] . ".value, ' ', d" . $name2typeID['firstname'] . ".value) like '%" . msSQL::cleanVar($this->_criteresRecherche['birthname']) . "%') " |
/class/msPeopleSearch.php:211 | 1 | $sp['where'][0] = "((d" . $name2typeID['lastname'] . ".value like '" . msSQL::cleanVar($this->_criteresRecherche['lastname']) . "%' and d" . $name2typeID['lastname'] . ".outdated='') or (d" . $name2typeID['birthname'] . ".value like '" . msSQL::cleanVar($this->_criteresRecherche['birthname']) . "%' and d" . $name2typeID['birthname'] . ".outdated='') ) " |
/class/msPeopleSearch.php:121 | 1 | $sql = 'select p.type, p.id as peopleID, CASE WHEN LENGTH(TRIM(p.name)) > 0 and LENGTH(TRIM(p.pass)) > 0 THEN "isUser" ELSE "isNotUser" END as isUser, ' . implode(', ', $this->_makeSqlSelect( )) . ' from people as p ' . implode(' ', $this->_makeSqlJoin( )) . ' where p.type in ("' . implode('", "', $this->_peopleType) . '") and ' . implode(' and ', $this->_makeSqlWhere( )) . ' ' . implode(' ', $this->_whereClauses) . ' ' . $restrictionUser . ' order by trim(identite) limit ' . $this->_limitStart . ',' . $this->_limitNumber |
/class/msPeopleSearch.php:149 | 1 | $sp[0] = 'CASE WHEN d' . $name2typeID['lastname'] . '.value !="" and d' . $name2typeID['birthname'] . '.value !="" THEN concat(COALESCE(d' . $name2typeID['lastname'] . '.value,""), " ", COALESCE(d' . $name2typeID['firstname'] . '.value,""), " (", COALESCE(d' . $name2typeID['birthname'] . '.value,"") ,")") WHEN d' . $name2typeID['birthname'] . '.value !="" THEN concat(COALESCE(d' . $name2typeID['birthname'] . '.value,""), " ", COALESCE(d' . $name2typeID['firstname'] . '.value,"")) WHEN d' . $name2typeID['lastname'] . '.value !="" THEN concat(COALESCE(d' . $name2typeID['lastname'] . '.value,""), " ", COALESCE(d' . $name2typeID['firstname'] . '.value,"")) ELSE concat("(inconnu) ", COALESCE(d' . $name2typeID['firstname'] . '.value,"")) END as identite' |
/class/msCcamNgapApi.php:229 | 1 | $tabup = array('id' => $code['id'], 'code' => $data['acteCode'], 'activite' => $data['activiteCode'], 'phase' => $data['phaseCode'], 'codeProf' => $code['codeProf'], 'type' => $code['type'], 'label' => $data['acteLabel'], 'dataYaml' => $data['yaml'], 'tarifUnit' => $data['tarifUnite'], ) |
/class/msApicrypt.php:98 | 1 | $apicrypt = $p['config']['apicryptCheminVersBinaires'] . 'apicryptpj -s ' . escapeshellarg($file) . ' -o ' . escapeshellarg($destinationC) . ' -u ' . $p['config']['apicryptUtilisateur'] . ' -k ' . $p['config']['apicryptCheminVersClefs'] . ' -d ' . escapeshellarg($to) . ' -v' |
/class/msCcamNgapApi.php:146 | 1 | $data = Spyc::YAMLDump(array('tarifParZone' => array('metro' => $scrap['tarifMetro'], '971' => $scrap['tarif971'], '972' => $scrap['tarif972'], '973' => $scrap['tarif973'], '974' => $scrap['tarif974'], '976' => $scrap['tarif976'])), false, 0, TRUE) |
/class/msCcamNgapApi.php:159 | 1 | $data2return = array('acteCode' => $this->_acteCode, 'acteLabel' => $scrap['label'], 'activiteCode' => $this->_activiteCode, 'phaseCode' => $this->_phaseCode, 'codeProf' => $this->_acteCodeProf, 'yaml' => $data, 'tarifUnite' => 'euro') |
/class/msPeopleDestroy.php:159 | 1 | $objets = msSQL::sql2tabSimple("select p.id from objets_data as p left join data_types as t on p.typeID=t.id where (t.groupe in ('typeCS', 'courrier') or (t.groupe = 'doc' and t.id='" . $name2typeID['docPorteur'] . "') or (t.groupe = 'ordo' and t.id in ('" . implode("','", $porteursOrdoIds) . "')) or (t.groupe = 'ordo' and t.id='" . $name2typeID['lapOrdonnance'] . "') or (t.groupe = 'reglement' and t.id in ('" . implode("','", $porteursReglementIds) . "')) or (t.groupe='mail' and t.id='" . $name2typeID['mailPorteur'] . "' and p.instance='0')) and p.toID='" . $this->_toID . "'") |
/class/msLapOrdo.php:315 | 1 | $lignesPres = msSQL::sql2tabKey("select lp.id, lp.value, dfe.value as dfe, lp.instance as ordonnanceID from objets_data as lp left join objets_data as dd on dd.instance=lp.id and dd.typeID='" . $name2typeID['lapLignePrescriptionDatePriseDebut'] . "' left join objets_data as df on df.instance=lp.id and df.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinAvecRenouv'] . "' left join objets_data as dfe on dfe.instance=lp.id and dfe.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinEffective'] . "' where lp.typeID='" . $name2typeID['lapLignePrescription'] . "' and lp.toID='" . $this->_toID . "' and lp.outdated='' and lp.deleted='' and (YEAR(STR_TO_DATE(dd.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "' or YEAR(STR_TO_DATE(df.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "' or YEAR(STR_TO_DATE(dfe.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "') ", 'id') |
/class/msLapOrdo.php:234 | 1 | $lignesPresTTponct = msSQL::sql2tab("select lp.id, lp.value from objets_data as lp left join objets_data as dd on dd.instance=lp.id and dd.typeID='" . $name2typeID['lapLignePrescriptionDatePriseDebut'] . "' left join objets_data as df on df.instance=lp.id and df.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinAvecRenouv'] . "' left join objets_data as dfe on dfe.instance=lp.id and dfe.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinEffective'] . "' left join objets_data as re on re.value=lp.id and re.typeID='" . $name2typeID['lapLignePrescriptionRenouvelle'] . "' where lp.typeID='" . $name2typeID['lapLignePrescription'] . "' and lp.toID='" . $this->_toID . "' and lp.outdated='' and lp.deleted='' and re.value is null " . $whereExclu . " and STR_TO_DATE(dd.value, '%d/%m/%Y') <= CURDATE() and STR_TO_DATE(df.value, '%d/%m/%Y') >= CURDATE() and (STR_TO_DATE(dfe.value, '%d/%m/%Y') > CURDATE() or dfe.value is null) ") |
/class/msDicomSR.php:195 | 2 | $data[$i] = array('CodeValue' => (string) $mesure->concept->value, 'CodeMeaning' => (string) $mesure->concept->meaning, 'NumericValue' => (string) $mesure->value, 'MeasurementUnits' => (string) $mesure->unit->value, 'FoetusID' => (string) $foetusID) |
/class/msDicomSR.php:152 | 2 | $data[$i] = array('CodeValue' => (string) $mesure->concept->value, 'CodeMeaning' => (string) $mesure->concept->meaning, 'NumericValue' => (string) $mesure->value, 'MeasurementUnits' => (string) $mesure->unit->value, 'FoetusID' => (string) $foetusID) |
/class/msLapPrescription.php:1275 | 1 | $retour['dureeTotaleMachineMinutes'] = $duree['i'] + ($duree['h'] * 60) + ($duree['j'] * 60 * 24) + ($duree['s'] * 60 * 24 * 7) + ($duree['m'] * 60 * 24 * 28) |
/class/msLapPrescription.php:455 | 1 | $tab['medicData'] = array('speThe' => $this->_speThe, 'presThe' => $this->_presThe, 'nomSpe' => $this->_nomSpe, 'nomDC' => $this->_nomDC, 'medicVirtuel' => $this->_medicVirtuel, 'divisibleEn' => $this->_divisibleEn, 'unitesPossibles' => $this->_unitesPossibles, 'unitesConversion' => $dataSpeUnite[0], 'nomUtileFinal' => $this->determineNomUtileFinal( ), 'voiesPossibles' => $dataSpeVoiesAdmin, 'prescriptibleEnDC' => $this->_prescriptibleEnDC, 'codeATC' => $dataSpe[0]['sp_catc_code_fk'], 'codeCIS' => $dataSpe[0]['sp_nl'], 'codeCIP7' => $this->_presThe, 'codeCIP13' => $dataPres[0]['pre_ean_ref'], 'codeUCD' => $dataSpe[0]['sp_cipucd'], 'codeUCD13' => $dataSpe[0]['sp_cipucd13'], 'conducteur' => array('reco' => $dataConducteur[0]['reco'], 'niveau' => $dataConducteur[0]['niv'], 'libelle_niv' => $dataConducteur[0]['libelle_niv']), 'dopage' => $dataDopage[0]['niveau'], 'substancesActives' => $dataSubActives, 'prixucd' => $this->_prixucd, 'tauxrbt' => $this->_tauxrbt, 'ald' => $dataAld, 'stup' => $infosDispensation['stupefiant'], 'reservHopital' => $reservHopital, 'sams' => $sams) |
/class/msReglement.php:480 | 1 | $data = msSQL::sql2tab("select * from actes_base where (code like '" . msSQL::cleanVar($search) . "' or label like '%" . msSQL::cleanVar($search) . "') and ((type='NGAP' and codeProf='" . msSQL::cleanVar($this->_secteurTarifaireNgap) . "') or type in ('CCAM', 'Libre')) order by code = '" . msSQL::cleanVar($searcho) . "' desc, code like '" . msSQL::cleanVar($search) . "' desc limit 25") |
/class/msReglement.php:339 | 1 | $add = array('porteur' => $this->_porteur, 'reglementForm' => $this->_reglementForm, 'module' => $this->_module, 'asUserID' => $this->_asUserID, 'patientID' => $this->_patientID, 'acteID' => $this->_factureTypeID, 'regleDetailsActes' => '', 'regleSecteurGeoTarifaire' => $this->_secteurTarifaireGeo, 'regleSecteurHonoraires' => $this->_secteurTarifaire, 'regleSecteurHonorairesNgap' => $this->_secteurTarifaireNgap, 'regleSecteurIK' => $this->_secteurIK, ) |
/class/msAgenda.php:852 | 1 | $events = msSQL::sql2tab("select a.id, a.type, a.patientid, CASE WHEN n.value != '' THEN concat(n.value, ' ', p.value) ELSE concat(bn.value, ' ', p.value) END as name, DATE_FORMAT(a.start, '%H:%i') as heure, YEAR(a.start) as annee, WEEKOFYEAR(a.start) as semaine, DAYOFWEEK(a.start) as joursemaine, DATE_FORMAT(a.end, '%d/%m/%Y') as datejour, tel.value as homePhone, mob.value as mobilePhone from agenda as a left join objets_data as n on n.toID=a.patientid and n.outdated='' and n.deleted='' and n.typeID='" . $name2typeID['lastname'] . "' left join objets_data as bn on bn.toID=a.patientid and bn.outdated='' and bn.deleted='' and bn.typeID='" . $name2typeID['birthname'] . "' left join objets_data as p on p.toID=a.patientid and p.outdated='' and p.deleted='' and p.typeID='" . $name2typeID['firstname'] . "' left join objets_data as tel on tel.toID=a.patientid and tel.outdated='' and tel.deleted='' and tel.typeID='" . $name2typeID['homePhone'] . "' left join objets_data as mob on mob.toID=a.patientid and mob.outdated='' and mob.deleted='' and mob.typeID='" . $name2typeID['mobilePhone'] . "' where a.userid='" . $this->_userID . "' and a.statut = 'actif' and a.start >= '" . msSQL::cleanVar($this->_startDate) . "' and a.end <= '" . msSQL::cleanVar($this->_endDate) . "' group by a.id, bn.value, n.value, p.value, tel.value, mob.value order by a.start asc") |
/class/msAgenda.php:776 | 1 | $data['olddata'] = serialize(array('start' => $oldEventData['start'], 'end' => $oldEventData['end'], 'type' => $oldEventData['type'], 'statut' => $oldEventData['statut'], 'absente' => $oldEventData['absente'], 'attente' => $oldEventData['attente'], 'motif' => $oldEventData['motif'])) |
/class/msAgenda.php:657 | 1 | $tab[] = array("id" => $v['patientid'], "identite" => $v['title'], "type" => $v['type'], "heure" => date("H:i", strtotime($v['start'])), "attente" => $v['attente'], "absent" => $v['absent'], ) |
/class/msAgenda.php:456 | 1 | $re = @array('id' => $e['id'], 'title' => $e['name'], 'allDay' => false, 'start' => $e['start'], 'end' => $e['end'], 'editable' => true, 'backgroundColor' => $this->_tabTypeRdv[$e['type']]['backgroundColor'], 'borderColor' => $this->_tabTypeRdv[$e['type']]['borderColor'], 'textColor' => $textColor, 'className' => $class, 'motif' => $e['motif'], 'type' => $e['type'], 'statut' => $e['statut'], 'fromID' => $e['fromID'], 'lastModified' => $e['lastModified'], 'patientid' => $e['patientid'], 'externid' => $e['externid'], 'absent' => $e['absente'], 'attente' => $e['attente']) |
/class/msAgenda.php:437 | 1 | $re = @array('id' => $e['id'], 'title' => 'Fermé', 'allDay' => false, 'start' => $e['start'], 'end' => $e['end'], 'editable' => true, 'className' => 'fc-nonbusiness', 'motif' => $e['motif'], 'type' => $e['type'], 'statut' => $e['statut'], 'lastModified' => $e['lastModified'], 'fromID' => $e['fromID'], 'patientid' => $e['patientid'], 'externid' => $e['externid']) |
/class/msAgenda.php:274 | 1 | $events = msSQL::sql2tab("select a.id, a.start, a.end, a.lastModified, a.type, a.patientid, a.externid, a.statut, a.absente, a.attente, a.motif, a.fromID, CASE WHEN n.value != '' THEN concat(n.value, ' ', p.value) ELSE concat(bn.value, ' ', p.value) END as name from agenda as a left join objets_data as n on n.toID=a.patientid and n.outdated='' and n.deleted='' and n.typeID='" . $name2typeID['lastname'] . "' left join objets_data as bn on bn.toID=a.patientid and bn.outdated='' and bn.deleted='' and bn.typeID='" . $name2typeID['birthname'] . "' left join objets_data as p on p.toID=a.patientid and p.outdated='' and p.deleted='' and p.typeID='" . $name2typeID['firstname'] . "' where a.userid='" . $this->_userID . "' and a.statut in ('" . implode("','", msSQL::cleanArray($statut)) . "') and a.start >= '" . msSQL::cleanVar($this->_startDate) . "' and a.end <= '" . msSQL::cleanVar($this->_endDate) . "' group by a.id, bn.value, n.value, p.value order by a.start asc") |
/class/msAgenda.php:227 | 1 | $data = array('userid' => $this->_userID, 'start' => $this->_startDate, 'end' => $this->_endDate, 'type' => $this->_type, 'patientid' => $this->_patientID, 'motif' => $this->_motif) |
/controlers/patient/actions/inc-ajax-getGraphData.php:110 | 1 | $data[$k] = array('poids' => array('value' => $d['poids'], 'reel' => true), 'taille' => array('value' => $mesureAnt['taille'], 'reel' => false), 'imc' => array('value' => $imc, 'reel' => true), 'date' => $d['date']) |
/controlers/patient/actions/inc-ajax-getGraphData.php:121 | 1 | $data[$k] = array('poids' => array('value' => $d['poids'], 'reel' => true), 'taille' => array('value' => $d['taillePatient'], 'reel' => true), 'imc' => array('value' => $imc, 'reel' => true), 'date' => $d['date']) |
/controlers/patient/actions/inc-ajax-getGraphData.php:140 | 1 | $data['bornes'] = array('Xmin' => $Xmin, 'Xmax' => $Xmax, 'Ymin' => array('poids' => $Pmin, 'taille' => $Tmin, 'imc' => $Imin), 'Ymax' => array('poids' => $Pmax, 'taille' => $Tmax, 'imc' => $Imax)) |
/controlers/patient/actions/inc-ajax-getFseData.php:75 | 1 | $msehrJsonData = array('actes' => $actes, 'returnUrl' => $p['config']['protocol'] . $p['config']['host'] . $p['config']['urlHostSuffixe'] . '/rest/callbackFse/', 'returnData' => array('objetID' => $_GET['objetID'], 'validationHash' => md5($dataPaiem['regleDetailsActes']['registerDate'] . $_GET['objetID'] . $dataPaiem['regleDetailsActes']['typeID']), 'data' => '')) |
/controlers/patient/actions/inc-ajax-getGraphData.php:73 | 1 | $data[$k] = array('poids' => array('value' => $mesureAnt['poids'], 'reel' => false), 'taille' => array('value' => $mesureAnt['taille'], 'reel' => false), 'imc' => array('value' => round($mesureAnt['poids'] * 10000 / ($mesureAnt['taille'] * $mesureAnt['taille']), 1), 'reel' => false), 'date' => $d['date'], 'mesure' => false) |
/controlers/patient/actions/inc-ajax-getGraphData.php:79 | 1 | $data[$k] = array('poids' => array('value' => '', 'reel' => false), 'taille' => array('value' => $d['taillePatient'], 'reel' => true), 'imc' => array('value' => '', 'reel' => false), 'date' => $d['date'], 'mesure' => false) |
/controlers/patient/actions/inc-ajax-getGraphData.php:88 | 1 | $data[$k] = array('poids' => array('value' => $mesureAnt['poids'], 'reel' => false), 'taille' => array('value' => $d['taillePatient'], 'reel' => true), 'imc' => array('value' => $imc, 'reel' => false), 'date' => $d['date']) |
/controlers/patient/actions/inc-ajax-getGraphData.php:101 | 1 | $data[$k] = array('poids' => array('value' => $d['poids'], 'reel' => true), 'taille' => array('value' => '', 'reel' => false), 'imc' => array('value' => '', 'reel' => false), 'date' => $d['date'], 'mesure' => false) |
/controlers/logs/historiqueMailSendGeneral.php:79 | 1 | $p['page']['mailListe'][] = @array('mailid' => $k, 'patient' => $patientData, 'date' => $v[$name2typeID['mailTo']]['creationDate'], 'to' => $v[$name2typeID['mailTo']]['value'], 'toID' => $v[$name2typeID['mailTo']]['toID'], 'fromID' => $v[$name2typeID['mailTo']]['fromID'], 'from' => $v[$name2typeID['mailFrom']]['value'], 'sujet' => $v[$name2typeID['mailSujet']]['value'], 'mailTrackingID' => $v[$name2typeID['mailTrackingID']]['value'], ) |
/controlers/people/peopleListDeleted.php:42 | 1 | $p['page']['users'] = msSQL::sql2tab("select p.id, m.value as mvalue, m.creationDate as dateDeleted, m.value as typeDossier, CASE WHEN o.value != '' and bn1.value != '' THEN concat(o.value, ' (', bn1.value, ') ', o2.value) WHEN o.value != '' THEN concat(o.value, ' ', o2.value) ELSE concat(bn1.value, ' ', o2.value) END as identiteDossier, CASE WHEN o3.value != '' THEN concat(o4.value, ' ', o3.value) ELSE concat(o4.value, ' ', bn2.value) END as identiteUser from people as p left join objets_data as o on o.toID=p.id and o.typeID='" . $name2typeID['lastname'] . "' and o.outdated='' left join objets_data as o2 on o2.toID=p.id and o2.typeID='" . $name2typeID['firstname'] . "' and o2.outdated='' left join objets_data as bn1 on bn1.toID=p.id and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' left join objets_data as m on m.toID=p.id and m.typeID='" . $name2typeID['administratifMarqueurSuppression'] . "' and m.outdated='' and m.deleted='' left join objets_data as o3 on o3.toID=m.fromID and o3.typeID='" . $name2typeID['lastname'] . "' and o3.outdated='' left join objets_data as o4 on o4.toID=m.fromID and o4.typeID='" . $name2typeID['firstname'] . "' and o4.outdated='' left join objets_data as bn2 on bn2.toID=m.fromID and bn2.typeID='" . $name2typeID['birthname'] . "' and bn2.outdated='' where p.type='deleted' " . $where . " group by p.id, bn1.id, o.id, o2.id, m.id, bn2.id, o3.id, o4.id order by p.id") |
/controlers/rechercher/actions/inc-ajax-patientsSendSign.php:41 | 1 | $tab = array('patientID' => (int) $_POST['patientID'], 'fromID' => (int) $p['user']['id'], 'typeID' => (int) $data['id'], 'template' => (string) $data['template'], 'label' => (string) $data['label'], 'signPeriphName' => (string) $signPeriphName, ) |
/controlers/patient/patient.php:81 | 1 | $candidats['phone'] = msSQL::sql2tabSimple("SELECT od.toID FROM objets_data AS od left join people AS p ON od.toID=p.id AND p.type!='externe' AND od.outdated='' AND od.deleted='' WHERE (od.typeID IN ('" . $name2typeID['mobilePhone'] . "', '" . $name2typeID['homePhone'] . "', '" . $name2typeID['telPro'] . "') AND od.value LIKE '" . $data['mobilePhone']['value'] . "') OR (od.typeID IN ('" . $name2typeID['mobilePhone'] . "', '" . $name2typeID['homePhone'] . "', '" . $name2typeID['telPro'] . "') AND od.value LIKE '" . $data['homePhone']['value'] . "')") |
/controlers/actions/inc-ajax-makeClick2Call.php:39 | 1 | $result = $ovh->post('/telephony/' . $p['config']['ovhTelecomBillingAccount'] . '/line/' . $p['config']['ovhTelecomServiceName'] . '/click2Call', array('calledNumber' => (string) $number2call, 'callingNumber' => $p['config']['ovhTelecomCallingNumber'], 'intercom' => false, )) |
/controlers/actions/inc-ajax-getAutocompleteLinkType.php:63 | 1 | $data = msSQL::sql2tab("select trim(concat(" . implode(', " ",', $concatValue) . ")) as value, trim(concat(" . implode(', " ",', $concatLabel) . ")) as label, " . implode(",", $sel) . " from objets_data as do " . implode(" ", $joinleft) . " where do.typeID in ('" . implode("','", msSQL::cleanArray($searchTypes)) . "') and trim(concat(" . implode(', " ",', $concatLabel) . ")) like '%" . msSQL::cleanVar($_GET['term']) . "%' and d" . msSQL::cleanVar($type) . ".value is not null group by " . implode(",", $groupby) . " limit 25") |
/controlers/logs/logsAgenda.php:63 | 1 | $lastAdd = msSQL::sql2tab("select a.id as eventID, a.userid as agendaID, a.start, a.end, a.type, a.dateAdd as date, a.patientid as patientID, a.fromID, a.statut, a.absente, a.motif, TIMESTAMPDIFF(MINUTE,a.start,a.end) as duree, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as patientNom, p.value as patientPrenom, CASE WHEN n1.value != '' THEN n1.value ELSE bn1.value END as auteurNom, p1.value as auteurPrenom from agenda as a left join objets_data as bn on bn.toID=a.patientid and bn.typeID='" . $name2typeID['birthname'] . "' and bn.deleted = '' and bn.outdated = '' left join objets_data as n on n.toID=a.patientid and n.typeID='" . $name2typeID['lastname'] . "' and n.deleted = '' and n.outdated = '' left join objets_data as p on p.toID=a.patientid and p.typeID='" . $name2typeID['firstname'] . "' and p.deleted = '' and p.outdated = '' left join objets_data as bn1 on bn1.toID=a.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.deleted = '' and bn1.outdated = '' left join objets_data as n1 on n1.toID=a.fromID and n1.typeID='" . $name2typeID['lastname'] . "' and n1.deleted = '' and n1.outdated = '' left join objets_data as p1 on p1.toID=a.fromID and p1.typeID='" . $name2typeID['firstname'] . "' and p1.deleted = '' and p1.outdated = '' where " . implode(' and ', $whereLA) . " group by a.id, n.value, p.value, n1.value, p1.value, bn.value, bn1.value order by a.id desc limit 2000") |
/controlers/logs/logsAgenda.php:82 | 1 | $lastUpdate = msSQL::sql2tab("select l.eventID, l.userID as agendaID, l.date, l.operation, l.olddata, l.fromID, a.patientid as patientID, a.type as type, a.start, a.end, TIMESTAMPDIFF(MINUTE,a.start,a.end) as duree, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as patientNom, p.value as patientPrenom, CASE WHEN n1.value != '' THEN n1.value ELSE bn1.value END as auteurNom, p1.value as auteurPrenom from agenda_changelog as l left join agenda as a on a.id=l.eventID left join objets_data as bn on bn.toID=a.patientid and bn.typeID='" . $name2typeID['birthname'] . "' and bn.deleted = '' and bn.outdated = '' left join objets_data as n on n.toID=a.patientid and n.typeID='" . $name2typeID['lastname'] . "' and n.deleted = '' and n.outdated = '' left join objets_data as p on p.toID=a.patientid and p.typeID='" . $name2typeID['firstname'] . "' and p.deleted = '' and p.outdated = '' left join objets_data as bn1 on bn1.toID=l.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.deleted = '' and bn1.outdated = '' left join objets_data as n1 on n1.toID=l.fromID and n1.typeID='" . $name2typeID['lastname'] . "' and n1.deleted = '' and n1.outdated = '' left join objets_data as p1 on p1.toID=l.fromID and p1.typeID='" . $name2typeID['firstname'] . "' and p1.deleted = '' and p1.outdated = '' where " . implode(' and ', $whereLU) . " group by l.id, n.value, p.value, n1.value, p1.value, bn.value, bn1.value order by l.id desc limit 2000") |
/controlers/configuration/configDefaultParams.php:39 | 1 | $p['page']['params'] = array(array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'protocol', 'value' => $p['config']['protocol'], 'readonly' => true), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'host', 'value' => $p['configInYml']['host'], 'readonly' => true), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'urlHostSuffixe', 'value' => $p['config']['urlHostSuffixe'], 'readonly' => true), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'webDirectory', 'value' => $p['config']['webDirectory'], 'readonly' => true), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'stockageLocation', 'value' => $p['config']['stockageLocation']), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'backupLocation', 'value' => $p['config']['backupLocation']), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'workingDirectory', 'value' => $p['config']['workingDirectory']), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'cookieDomain', 'value' => $p['configInYml']['cookieDomain']), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'cookieDuration', 'value' => $p['config']['cookieDuration']), array('cat' => 'Serveur', 'type' => 'texte', 'name' => 'fingerprint', 'value' => $p['config']['fingerprint'], 'readonly' => true), array('cat' => 'Serveur MySQL', 'type' => 'texte', 'name' => 'sqlServeur', 'value' => $p['config']['sqlServeur'], 'readonly' => true), array('cat' => 'Serveur MySQL', 'type' => 'texte', 'name' => 'sqlBase', 'value' => $p['config']['sqlBase'], 'readonly' => true), array('cat' => 'Serveur MySQL', 'type' => 'texte', 'name' => 'sqlUser', 'value' => $p['config']['sqlUser'], 'readonly' => true), array('cat' => 'Serveur MySQL', 'type' => 'texte', 'name' => 'sqlPass', 'value' => $p['config']['sqlPass'], 'readonly' => true), array('cat' => 'Serveur MySQL', 'type' => 'texte', 'name' => 'sqlVarPassword', 'value' => $p['config']['sqlVarPassword'], 'readonly' => true), array('cat' => 'Service d\'affichage', 'name' => 'templatesFolder', 'value' => $p['config']['templatesFolder'], 'type' => 'texte'), array('cat' => 'Service d\'affichage', 'name' => 'twigEnvironnementCache', 'value' => $p['config']['twigEnvironnementCache'] ?: 'false', 'type' => 'false/dossier', 'description' => 'ex: /tmp/templates_cache/'), array('cat' => 'Service d\'affichage', 'name' => 'twigEnvironnementAutoescape', 'value' => $p['config']['twigEnvironnementAutoescape'] ?: 'false', 'type' => 'false/texte'), ) |
/controlers/dropbox/actions/inc-ajax-getPatients.php:53 | 2 | $a_json[] = array('label' => trim($v['identite']) . ' - ' . $v['birthdate'], 'value' => trim($v['identite']), 'id' => $v['peopleID'], 'firstname' => $v['firstname'], 'birthname' => $v['birthname'], 'lastname' => $v['lastname'], 'birthdate' => $v['birthdate'], 'streetNumber' => $v['streetNumber'], 'street' => $v['street'], 'postalCodePerso' => $v['postalCodePerso'], 'city' => $v['city'], 'nss' => $v['nss'], ) |
/controlers/inbox/actions/inc-ajax-getPatients.php:53 | 2 | $a_json[] = array('label' => trim($v['identite']) . ' - ' . $v['birthdate'], 'value' => trim($v['identite']), 'id' => $v['peopleID'], 'firstname' => $v['firstname'], 'birthname' => $v['birthname'], 'lastname' => $v['lastname'], 'birthdate' => $v['birthdate'], 'streetNumber' => $v['streetNumber'], 'street' => $v['street'], 'postalCodePerso' => $v['postalCodePerso'], 'city' => $v['city'], 'nss' => $v['nss'], ) |
/controlers/configuration/actions/inc-ajax-configFormEdit.php:37 | 1 | $data = array('id' => $_POST['id'], 'module' => $_POST['module'], 'internalName' => $_POST['internalName'], 'name' => $_POST['name'], 'description' => $_POST['description'], 'cat' => $_POST['cat'], 'yamlStructure' => $cleanForm, 'formAction' => $_POST['formAction'], 'printModel' => $_POST['printModel'], 'cda' => $_POST['cda'], 'javascript' => $_POST['javascript'], 'options' => $_POST['options'], ) |
/controlers/lap/actions/inc-ajax-lapOutilsSearchPres.php:94 | 1 | $patientsList = msSQL::sql2tab("SELECT w.fromID, w.toID, w.registerDate, GROUP_CONCAT(DISTINCT allea.value SEPARATOR ' ') AS allergies, GROUP_CONCAT(DISTINCT cimg.value SEPARATOR ' ') AS atcd, CASE WHEN TIMESTAMPDIFF(YEAR,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) >= 2 THEN TIMESTAMPDIFF(YEAR,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) WHEN TIMESTAMPDIFF(MONTH,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) >= 1 THEN TIMESTAMPDIFF(MONTH,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) ELSE TIMESTAMPDIFF(DAY,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) END as ageALaPresc, CASE WHEN TIMESTAMPDIFF(YEAR,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) >= 2 THEN 'ans' WHEN TIMESTAMPDIFF(MONTH,STR_TO_DATE(bd.value, '%d/%m/%Y'),w.registerDate) >= 1 THEN 'mois' ELSE 'jours' END as ageALaPrescUnite, CASE WHEN o.value != '' and bn1.value != '' THEN concat(o.value, ' (', bn1.value, ') ', o2.value) WHEN o.value != '' THEN concat(o.value, ' ', o2.value) ELSE concat(bn1.value, ' ', o2.value) END as identiteDossier, spe.value as specialite, dc.value as dci, bd.value as birthdate FROM objets_data as w $leftJoinSexe $leftJoinAllergie $leftJoinCIM left join objets_data as spe on spe.instance=w.instance and spe.typeID='" . $name2typeID['lapMedicamentSpecialiteNom'] . "' left join objets_data as dc on dc.instance=w.instance and dc.typeID='" . $name2typeID['lapMedicamentDC'] . "' left join objets_data as o on o.toID=w.toID and o.typeID='" . $name2typeID['lastname'] . "' and o.outdated='' and o.deleted='' left join objets_data as o2 on o2.toID=w.toID and o2.typeID='" . $name2typeID['firstname'] . "' and o2.outdated='' and o2.deleted='' left join objets_data as bn1 on bn1.toID=w.toID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' and bn1.deleted='' left join objets_data as bd on bd.toID=w.toID and bd.typeID='" . $name2typeID['birthdate'] . "' and bd.outdated='' and bd.deleted='' left join objets_data as allea on allea.toID=w.toID and allea.typeID='" . $name2typeID['allergieCodeTheriaque'] . "' and allea.outdated='' and allea.deleted='' left join objets_data as cimg on cimg.toID=w.toID and cimg.typeID='" . $name2typeID['atcdStrucCIM10'] . "' and cimg.outdated='' and cimg.deleted='' where w.outdated ='' and w.deleted='' $whereCode $wherePatientID $whereBeginPeriode $whereEndPeriode $whereSexe $whereAllergie $whereCIM group by w.id, spe.id, dc.id, o.id, o2.id, bn1.id, bd.id $groubySexe $groupbyAllergie $groupbyCIM order by w.registerDate desc ") |
/controlers/lap/actions/inc-ajax-lapSamAlerteForNew.php:44 | 1 | $html = '<img class="float-right" src="data:' . $data['logoMediaType'] . ';base64, ' . $data['logo'] . '" alt="logo" style="margin-left : 10px;"/> <h4>' . $data['titre'] . '</h4> <p>' . nl2br($data['liste_medicaments']) . '</p> <p>' . str_replace(array('html:', 'href='), array('', 'target="_blank" href='), $data['messageLAPV']) . '</p> <p>Référence : ' . str_replace(array('html:', 'href='), array('', 'target="_blank" href='), $data['reference']) . '</p> <label>Commentaire pour ce patient concernant ce SAM</label> <textarea data-samID="' . $_POST['samID'] . '" class="form-control samCommentObserv" rows="3" placeholder="Commentaire pour ce patient"' |
/controlers/lap/actions/inc-ajax-modalLapPresPreSaveDo.php:30 | 1 | $data = array('cat' => $_POST['cat'], 'label' => $_POST['label'], 'description' => json_encode($_POST['ordo']), 'fromID' => $p['user']['id'], 'toID' => $p['user']['id'], ) |
/controlers/lap/actions/inc-ajax-lapOrdoAnalyse.php:48 | 1 | $retour = array('html' => $lapOrdo->getHtmlAnalysesResults( ), 'correspondanceLignes' => $lapOrdo->getCorrespondanceLignes( ), 'lignesRisqueAllergique' => $lapOrdo->getLignesRisqueAllergique( ), 'versionTheriaque' => $dataTheriaque[0]['vers'] . ' ' . $dataTheriaque[0]['date_ext'], ) |
/class/msPeople.php:727 | 1 | $this->_ageFormats = array('birthdate' => $birthdate, 'ageDisplay' => $ageDisplay, 'ageTotalDays' => $interval->format('%a'), 'ageTotalYears' => $interval->format('%y'), 'ageTotalMonths' => $interval->m + 12 * $interval->y, 'ageComposantes' => array('y' => $interval->format('%y'), 'm' => $interval->format('%m'), 'd' => $interval->format('%d'))) |
/class/msPeople.php:667 | 1 | $this->_deathAgeFormats = array('birthdate' => $birthdate, 'ageDisplay' => $ageDisplay, 'ageTotalDays' => $interval->format('%a'), 'ageTotalYears' => $interval->format('%y'), 'ageTotalMonths' => $interval->m + 12 * $interval->y, 'ageComposantes' => array('y' => $interval->format('%y'), 'm' => $interval->format('%m'), 'd' => $interval->format('%d'))) |
/public_html/install.php:101 | 1 | $conf = array('protocol' => 'http' . ($_SERVER['HTTPS'] ? 's' : '') . '://', 'host' => $_SERVER['SERVER_NAME'] . (in_array($_SERVER['SERVER_PORT'], ['80', '443']) ? '' : ':' . $_SERVER['SERVER_PORT']), 'urlHostSuffixe' => substr($_SERVER['REQUEST_URI'], 0, strpos($_SERVER['REQUEST_URI'], '/install.php')), 'webDirectory' => $webdir . '/', 'stockageLocation' => $_POST['stockageLocation'], 'backupLocation' => $_POST['backupLocation'], 'workingDirectory' => $webdir . '/workingDirectory/', 'cookieDomain' => $_SERVER['SERVER_NAME'], 'cookieDuration' => 31104000, 'fingerprint' => $_POST['fingerprint'], 'sqlServeur' => $_POST['sqlServeur'], 'sqlBase' => $_POST['sqlBase'], 'sqlUser' => $_POST['sqlUser'], 'sqlPass' => $_POST['sqlPass'], 'sqlVarPassword' => $_POST['sqlVarPassword'], 'templatesFolder' => $homepath . 'templates/', 'twigEnvironnementCache' => false, 'twigEnvironnementAutoescape' => false) |
/class/msVitale.php:40 | 1 | $file = $p['config']['protocol'] . $p['config']['host'] . $p['config']['urlHostSuffixe'] . '/modulesExternes/' . $p['config']['vitaleService'] . '/lireCpsEtVitale.php?hoteLecteurIp=' . $p['config']['vitaleHoteLecteurIP'] . '&nomRessourcePS=' . $p['config']['vitaleNomRessourcePS'] . '&nomRessourceLecteur=' . $p['config']['vitaleNomRessourceLecteur'] |
/class/msPeople.php:410 | 1 | if($csAldID = msSQL::sql2tabKey("select p.id, n1.value as prenom, CASE WHEN n2.value != '' THEN n2.value ELSE bn.value END as nom from objets_data as p left join objets_data as n1 on n1.toID=p.fromID and n1.typeID='" . $name2typeID['firstname'] . "' and n1.outdated='' and n1.deleted='' left join objets_data as n2 on n2.toID=p.fromID and n2.typeID='" . $name2typeID['lastname'] . "' and n2.outdated='' and n2.deleted='' left join objets_data as bn on bn.toID=p.fromID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where p.toID='" . $this->_toID . "' and p.typeID='" . $name2typeID['csAtcdStrucDeclaration'] . "' and p.deleted='' and p.outdated='' and p.instance='" . $name2typeID[$parentTypeName] . "' ", 'id')) { /**/ } |
/class/msCourrier.php:305 | 1 | if($factureID = msSQL::sqlUniqueChamp("select count(id) from objets_data where typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(creationDate) = DATE('" . $this->_objetData['creationDate'] . "') and id <= '" . $this->_objetData['id'] . "' and fromID = '" . $this->_objetData['fromID'] . "'")) { /**/ } |
/class/msLapOrdo.php:315 | 1 | if($lignesPres = msSQL::sql2tabKey("select lp.id, lp.value, dfe.value as dfe, lp.instance as ordonnanceID from objets_data as lp left join objets_data as dd on dd.instance=lp.id and dd.typeID='" . $name2typeID['lapLignePrescriptionDatePriseDebut'] . "' left join objets_data as df on df.instance=lp.id and df.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinAvecRenouv'] . "' left join objets_data as dfe on dfe.instance=lp.id and dfe.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinEffective'] . "' where lp.typeID='" . $name2typeID['lapLignePrescription'] . "' and lp.toID='" . $this->_toID . "' and lp.outdated='' and lp.deleted='' and (YEAR(STR_TO_DATE(dd.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "' or YEAR(STR_TO_DATE(df.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "' or YEAR(STR_TO_DATE(dfe.value, '%d/%m/%Y')) = '" . msSQL::cleanVar($year) . "') ", 'id')) { /**/ } |
/class/msPeopleDestroy.php:159 | 1 | if($objets = msSQL::sql2tabSimple("select p.id from objets_data as p left join data_types as t on p.typeID=t.id where (t.groupe in ('typeCS', 'courrier') or (t.groupe = 'doc' and t.id='" . $name2typeID['docPorteur'] . "') or (t.groupe = 'ordo' and t.id in ('" . implode("','", $porteursOrdoIds) . "')) or (t.groupe = 'ordo' and t.id='" . $name2typeID['lapOrdonnance'] . "') or (t.groupe = 'reglement' and t.id in ('" . implode("','", $porteursReglementIds) . "')) or (t.groupe='mail' and t.id='" . $name2typeID['mailPorteur'] . "' and p.instance='0')) and p.toID='" . $this->_toID . "'")) { /**/ } |
/class/msReglement.php:480 | 1 | if($data = msSQL::sql2tab("select * from actes_base where (code like '" . msSQL::cleanVar($search) . "' or label like '%" . msSQL::cleanVar($search) . "') and ((type='NGAP' and codeProf='" . msSQL::cleanVar($this->_secteurTarifaireNgap) . "') or type in ('CCAM', 'Libre')) order by code = '" . msSQL::cleanVar($searcho) . "' desc, code like '" . msSQL::cleanVar($search) . "' desc limit 25")) { /**/ } |
/class/msLapOrdo.php:234 | 1 | if($lignesPresTTponct = msSQL::sql2tab("select lp.id, lp.value from objets_data as lp left join objets_data as dd on dd.instance=lp.id and dd.typeID='" . $name2typeID['lapLignePrescriptionDatePriseDebut'] . "' left join objets_data as df on df.instance=lp.id and df.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinAvecRenouv'] . "' left join objets_data as dfe on dfe.instance=lp.id and dfe.typeID='" . $name2typeID['lapLignePrescriptionDatePriseFinEffective'] . "' left join objets_data as re on re.value=lp.id and re.typeID='" . $name2typeID['lapLignePrescriptionRenouvelle'] . "' where lp.typeID='" . $name2typeID['lapLignePrescription'] . "' and lp.toID='" . $this->_toID . "' and lp.outdated='' and lp.deleted='' and re.value is null " . $whereExclu . " and STR_TO_DATE(dd.value, '%d/%m/%Y') <= CURDATE() and STR_TO_DATE(df.value, '%d/%m/%Y') >= CURDATE() and (STR_TO_DATE(dfe.value, '%d/%m/%Y') > CURDATE() or dfe.value is null) ")) { /**/ } |
/class/msAgenda.php:274 | 1 | if($events = msSQL::sql2tab("select a.id, a.start, a.end, a.lastModified, a.type, a.patientid, a.externid, a.statut, a.absente, a.attente, a.motif, a.fromID, CASE WHEN n.value != '' THEN concat(n.value, ' ', p.value) ELSE concat(bn.value, ' ', p.value) END as name from agenda as a left join objets_data as n on n.toID=a.patientid and n.outdated='' and n.deleted='' and n.typeID='" . $name2typeID['lastname'] . "' left join objets_data as bn on bn.toID=a.patientid and bn.outdated='' and bn.deleted='' and bn.typeID='" . $name2typeID['birthname'] . "' left join objets_data as p on p.toID=a.patientid and p.outdated='' and p.deleted='' and p.typeID='" . $name2typeID['firstname'] . "' where a.userid='" . $this->_userID . "' and a.statut in ('" . implode("','", msSQL::cleanArray($statut)) . "') and a.start >= '" . msSQL::cleanVar($this->_startDate) . "' and a.end <= '" . msSQL::cleanVar($this->_endDate) . "' group by a.id, bn.value, n.value, p.value order by a.start asc")) { /**/ } |
/class/msAgenda.php:852 | 1 | if($events = msSQL::sql2tab("select a.id, a.type, a.patientid, CASE WHEN n.value != '' THEN concat(n.value, ' ', p.value) ELSE concat(bn.value, ' ', p.value) END as name, DATE_FORMAT(a.start, '%H:%i') as heure, YEAR(a.start) as annee, WEEKOFYEAR(a.start) as semaine, DAYOFWEEK(a.start) as joursemaine, DATE_FORMAT(a.end, '%d/%m/%Y') as datejour, tel.value as homePhone, mob.value as mobilePhone from agenda as a left join objets_data as n on n.toID=a.patientid and n.outdated='' and n.deleted='' and n.typeID='" . $name2typeID['lastname'] . "' left join objets_data as bn on bn.toID=a.patientid and bn.outdated='' and bn.deleted='' and bn.typeID='" . $name2typeID['birthname'] . "' left join objets_data as p on p.toID=a.patientid and p.outdated='' and p.deleted='' and p.typeID='" . $name2typeID['firstname'] . "' left join objets_data as tel on tel.toID=a.patientid and tel.outdated='' and tel.deleted='' and tel.typeID='" . $name2typeID['homePhone'] . "' left join objets_data as mob on mob.toID=a.patientid and mob.outdated='' and mob.deleted='' and mob.typeID='" . $name2typeID['mobilePhone'] . "' where a.userid='" . $this->_userID . "' and a.statut = 'actif' and a.start >= '" . msSQL::cleanVar($this->_startDate) . "' and a.end <= '" . msSQL::cleanVar($this->_endDate) . "' group by a.id, bn.value, n.value, p.value, tel.value, mob.value order by a.start asc")) { /**/ } |
/controlers/patient/patient.php:91 | 1 | if((($candidats['phone'] and ($c1 = count($candidats['phone'])) == 1) or ($candidats['email'] and ($c2 = count($candidats['email'])) == 1)) and (!isset($c1) or !isset($c2) or $candidats['phone'][0] == $candidats['email'][0])) { /**/ } else { /**/ } |
/controlers/compta/compta.php:115 | 1 | if($lr = msSQL::sql2tab("select pd.toID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.id in ( select pd1.id from objets_data as pd1 where pd1.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd1.creationDate) >= '" . $beginPeriode->format("Y-m-d") . "' and DATE(pd1.creationDate) <= '" . $endPeriode->format("Y-m-d") . "' and pd1.deleted='' and pd1.fromID in ('" . implode("','", $p['page']['pratsSelect']) . "')" . ($impayes ? "and important='y'" : "") . " ) union select pd.toID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.instance in ( select pd2.id from objets_data as pd2 where pd2.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd2.creationDate) >= '" . $beginPeriode->format("Y-m-d") . "' and DATE(pd2.creationDate) <= '" . $endPeriode->format("Y-m-d") . "' and pd2.deleted='' and pd2.fromID in ('" . implode("','", $p['page']['pratsSelect']) . "')" . ($impayes ? "and important='y'" : "") . " ) order&n |
/controlers/logs/logsAgenda.php:82 | 1 | if($lastUpdate = msSQL::sql2tab("select l.eventID, l.userID as agendaID, l.date, l.operation, l.olddata, l.fromID, a.patientid as patientID, a.type as type, a.start, a.end, TIMESTAMPDIFF(MINUTE,a.start,a.end) as duree, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as patientNom, p.value as patientPrenom, CASE WHEN n1.value != '' THEN n1.value ELSE bn1.value END as auteurNom, p1.value as auteurPrenom from agenda_changelog as l left join agenda as a on a.id=l.eventID left join objets_data as bn on bn.toID=a.patientid and bn.typeID='" . $name2typeID['birthname'] . "' and bn.deleted = '' and bn.outdated = '' left join objets_data as n on n.toID=a.patientid and n.typeID='" . $name2typeID['lastname'] . "' and n.deleted = '' and n.outdated = '' left join objets_data as p on p.toID=a.patientid and p.typeID='" . $name2typeID['firstname'] . "' and p.deleted = '' and p.outdated = '' left join objets_data as bn1 on bn1.toID=l.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.deleted = '' and bn1.outdated = '' left join objets_data as n1 on n1.toID=l.fromID and n1.typeID='" . $name2typeID['lastname'] . "' and n1.deleted = '' and n1.outdated = '' left join objets_data as p1 on p1.toID=l.fromID and p1.typeID='" . $name2typeID['firstname'] . "' and p1.deleted = '' and p1.outdated = '' where " . implode(' and ', $whereLU) . " group by l.id, n.value, p.value, n1.value, p1.value, bn.value, bn1.value order by l.id desc limit 2000")) { /**/ } |
/controlers/people/peopleListDeleted.php:42 | 1 | if($p['page']['users'] = msSQL::sql2tab("select p.id, m.value as mvalue, m.creationDate as dateDeleted, m.value as typeDossier, CASE WHEN o.value != '' and bn1.value != '' THEN concat(o.value, ' (', bn1.value, ') ', o2.value) WHEN o.value != '' THEN concat(o.value, ' ', o2.value) ELSE concat(bn1.value, ' ', o2.value) END as identiteDossier, CASE WHEN o3.value != '' THEN concat(o4.value, ' ', o3.value) ELSE concat(o4.value, ' ', bn2.value) END as identiteUser from people as p left join objets_data as o on o.toID=p.id and o.typeID='" . $name2typeID['lastname'] . "' and o.outdated='' left join objets_data as o2 on o2.toID=p.id and o2.typeID='" . $name2typeID['firstname'] . "' and o2.outdated='' left join objets_data as bn1 on bn1.toID=p.id and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' left join objets_data as m on m.toID=p.id and m.typeID='" . $name2typeID['administratifMarqueurSuppression'] . "' and m.outdated='' and m.deleted='' left join objets_data as o3 on o3.toID=m.fromID and o3.typeID='" . $name2typeID['lastname'] . "' and o3.outdated='' left join objets_data as o4 on o4.toID=m.fromID and o4.typeID='" . $name2typeID['firstname'] . "' and o4.outdated='' left join objets_data as bn2 on bn2.toID=m.fromID and bn2.typeID='" . $name2typeID['birthname'] . "' and bn2.outdated='' where p.type='deleted' " . $where . " group by p.id, bn1.id, o.id, o2.id, m.id, bn2.id, o3.id, o4.id order by p.id")) { /**/ } |
/controlers/dicom/viewStudy.php:56 | 1 | if($d = msSQL::sqlUniqueChamp("select instance from objets_data where typeID='" . msData::getTypeIDFromName('dicomStudyID') . "' and toID='" . $p['page']['patient']['id'] . "' and value='" . msSQL::cleanVar($match['params']['dcStudyID']) . "' ")) { /**/ } |
/controlers/logs/logsAgenda.php:63 | 1 | if($lastAdd = msSQL::sql2tab("select a.id as eventID, a.userid as agendaID, a.start, a.end, a.type, a.dateAdd as date, a.patientid as patientID, a.fromID, a.statut, a.absente, a.motif, TIMESTAMPDIFF(MINUTE,a.start,a.end) as duree, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as patientNom, p.value as patientPrenom, CASE WHEN n1.value != '' THEN n1.value ELSE bn1.value END as auteurNom, p1.value as auteurPrenom from agenda as a left join objets_data as bn on bn.toID=a.patientid and bn.typeID='" . $name2typeID['birthname'] . "' and bn.deleted = '' and bn.outdated = '' left join objets_data as n on n.toID=a.patientid and n.typeID='" . $name2typeID['lastname'] . "' and n.deleted = '' and n.outdated = '' left join objets_data as p on p.toID=a.patientid and p.typeID='" . $name2typeID['firstname'] . "' and p.deleted = '' and p.outdated = '' left join objets_data as bn1 on bn1.toID=a.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.deleted = '' and bn1.outdated = '' left join objets_data as n1 on n1.toID=a.fromID and n1.typeID='" . $name2typeID['lastname'] . "' and n1.deleted = '' and n1.outdated = '' left join objets_data as p1 on p1.toID=a.fromID and p1.typeID='" . $name2typeID['firstname'] . "' and p1.deleted = '' and p1.outdated = '' where " . implode(' and ', $whereLA) . " group by a.id, n.value, p.value, n1.value, p1.value, bn.value, bn1.value order by a.id desc limit 2000")) { /**/ } |
/public_html/index.php:105 | 1 | if($p['config']['optionGeLogin2FA'] == 'true' and !$iUser->check2faValidKey( ) and $match['target'] != 'login/logIn' and $match['target'] != 'login/logInDo' and $match['target'] != 'rest/rest' and $match['target'] != 'login/logInSet2fa') { /**/ } |
/controlers/user/actions/inc-ajax-userParametersClicRdv.php:50 | 1 | if(empty($p['config']['clicRdvPassword']) or $_POST['p_clicRdvPassword'] != str_repeat('*', strlen(msConfiguration::getParameterValue('clicRdvPassword', array('id' => $p['user']['id'], 'module' => ''))))) { /**/ } |
/cron/baseGzipBackup.php:76 | 2 | if((($matches[1] . '-' . $matches[2] . '-' . $matches[3]) < $lastWeek and $matches[3] != '01') or (($matches[1] . '-' . $matches[2] . '-' . $matches[3]) < $firstOfLastYear and $matches[2] != '01')) { /**/ } |
/cron/baseBackup.php:74 | 2 | if((($matches[1] . '-' . $matches[2] . '-' . $matches[3]) < $lastWeek and $matches[3] != '01') or (($matches[1] . '-' . $matches[2] . '-' . $matches[3]) < $firstOfLastYear and $matches[2] != '01')) { /**/ } |
/controlers/compta/today.php:55 | 1 | if($lr = msSQL::sql2tab("select pd.toID, pd.fromID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, dc.module, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.id in ( select pd1.id from objets_data as pd1 where pd1.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd1.creationDate) = CURDATE() and pd1.deleted='' and pd1.fromID in ('" . implode("','", array_keys($p['page']['pratsAuto'])) . "')) union select pd.toID, pd.fromID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, dc.module, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.instance in ( select pd2.id from objets_data as pd2 where pd2.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd2.creationDate) = CURDATE() and pd2.deleted='' and pd2.fromID in ('" . implode("','", array_keys($p['page']['pratsAuto'])) . "')) order by creationDate asc ")) { /**/ } |
/class/msTheriaquePG.php:466 | 1 | elseif($v['id_type_alerte'] == 'L' or $v['id_type_alerte'] == 'K' or $v['id_type_alerte'] == 'D' or $v['id_type_alerte'] == 'C' or $v['id_type_alerte'] == 'B' or $v['id_type_alerte'] == 'A') { /**/ } elseif($v['id_type_alerte'] == 'H' or $v['id_type_alerte'] == 'J' or $v['id_type_alerte'] == 'I' or $v['id_type_alerte'] == 'F') { /**/ } |
/class/msTransmissions.php:306 | 1 | if($trans = msSQL::sqlUnique("select t.id, t.fromID, t.sujet, t.aboutID, t.priorite, t.updateDate, t.registerDate, t.texte, t.statut, CASE WHEN ln.value != '' and bn.value != '' THEN concat(COALESCE(ln.value,'') , ' (' , COALESCE(bn.value,'') , ') ',COALESCE(fn.value,'')) WHEN bn.value != '' THEN concat(COALESCE(bn.value,'') , ' ' ,COALESCE(fn.value,'')) ELSE concat(COALESCE(ln.value,'') , ' ' , COALESCE(fn.value,'')) END as identiteAbout, CASE WHEN ln1.value != '' THEN concat(COALESCE(ln1.value,'') , ' ' , COALESCE(fn1.value,'')) ELSE concat(COALESCE(bn1.value,'') , ' ' , COALESCE(fn1.value,'')) END as identiteAuteur from transmissions as t left join transmissions_to as trto on t.id = trto.sujetID and trto.toID = '" . $this->_userID . "' left join objets_data as ln on ln.toID=t.aboutID and ln.typeID='" . $name2typeID['lastname'] . "' and ln.outdated='' and ln.deleted='' left join objets_data as bn on bn.toID=t.aboutID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as fn on fn.toID=t.aboutID and fn.typeID='" . $name2typeID['firstname'] . "' and fn.outdated='' and fn.deleted='' left join objets_data as ln1 on ln1.toID=t.fromID and ln1.typeID='" . $name2typeID['lastname'] . "' and ln1.outdated='' and ln1.deleted='' left join objets_data as bn1 on bn1.toID=t.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' and bn1.deleted='' left join objets_data as fn1 on fn1.toID=t.fromID and fn1.typeID='" . $name2typeID['firstname'] . "' and fn1.outdated='' and fn1.deleted='' where t.id='" . $this->_id . "' limit 1")) { /**/ } |
/class/msReglementActe.php:209 | 1 | if($d = msSQL::sqlUnique("select " . implode(', ', msSQL::cleanArray($cols)) . " from actes_base where code='" . msSQL::cleanVar($this->_acteCode) . "' and type='NGAP' and codeProf='" . msSQL::cleanVar($this->_secteurTarifaireNgap) . "' limit 1")) { /**/ } elseif($strict == FALSE and $d = msSQL::sqlUnique("select " . implode(', ', msSQL::cleanArray($cols)) . " from actes_base where code='" . msSQL::cleanVar($this->_acteCode) . "' and type='NGAP' limit 1")) { /**/ } else { /**/ } |
/class/msReglementActe.php:181 | 1 | if($d = msSQL::sqlUnique("select " . implode(', ', msSQL::cleanArray($cols)) . " from actes_base where code='" . msSQL::cleanVar($this->_acteCode) . "' and type='CCAM' and activite='" . $this->_acteActivite . "' and phase='" . $this->_actePhase . "' limit 1")) { /**/ } else { /**/ } |
/class/msPeopleRelations.php:68 | 1 | if($relations = msSQL::sql2tab("select o.value as pratID, c.value as typeRelation, p.value as prenom, t.value as titre, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as nom " . implode(" ", $champsSql) . " from objets_data as o inner join objets_data as c on c.instance=o.id and c.typeID='" . $name2typeID['relationPatientPraticien'] . "' and c.value != 'patient' left join objets_data as n on n.toID=o.value and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=o.value and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as p on p.toID=o.value and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as t on t.toID=o.value and t.typeID='" . $name2typeID['titre'] . "' and t.outdated='' and t.deleted='' " . implode(" ", $tablesSql) . " where o.toID='" . $this->_toID . "' and o.typeID='" . $name2typeID['relationID'] . "' and o.deleted='' and o.outdated='' " . implode("", $notEmpty) . " group by o.value, c.id, bn.id, n.id, p.id, t.id" . implode("", $groupBy) . " order by typeRelation = 'MT' desc, nom asc")) { /**/ } |
/class/msObjet.php:502 | 1 | if($data = msSQL::sqlUnique("select pd.* , t.label, t.groupe, t.formValues, p.value as prenom, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as t on t.id=pd.typeID left join objets_data as n on n.toID=pd.fromID and n.outdated='' and n.deleted='' and n.typeID='" . $name2typeID['lastname'] . "' left join objets_data as p on p.toID=pd.fromID and p.outdated='' and p.deleted='' and p.typeID='" . $name2typeID['firstname'] . "' left join objets_data as bn on bn.toID=pd.fromID and bn.outdated='' and bn.deleted='' and bn.typeID='" . $name2typeID['birthname'] . "' where pd.toID='" . $this->_toID . "' and pd.typeID = '" . $name2typeID[$name] . "' and pd.deleted='' and pd.outdated='' $where order by updateDate desc limit 1")) { /**/ } else { /**/ } |
/class/msTransmissions.php:237 | 1 | if($listeSujets = msSQL::sql2tab("select t.id, t.sujet, t.aboutID, t.priorite, t.updateDate, t.registerDate, CASE WHEN ln.value != '' and bn.value != '' THEN concat(COALESCE(ln.value,'') , ' (' , COALESCE(bn.value,'') , ') ',COALESCE(fn.value,'')) WHEN bn.value != '' THEN concat(COALESCE(bn.value,'') , ' ' ,COALESCE(fn.value,'')) ELSE concat(COALESCE(ln.value,'') , ' ' , COALESCE(fn.value,'')) END as identiteAbout, CASE WHEN ln1.value != '' THEN concat(COALESCE(ln1.value,'') , ' ' , COALESCE(fn1.value,'')) ELSE concat(COALESCE(bn1.value,'') , ' ' , COALESCE(fn1.value,'')) END as identiteAuteur from transmissions as t " . $lj . " left join objets_data as ln on ln.toID=t.aboutID and ln.typeID='" . $name2typeID['lastname'] . "' and ln.outdated='' and ln.deleted='' left join objets_data as bn on bn.toID=t.aboutID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as fn on fn.toID=t.aboutID and fn.typeID='" . $name2typeID['firstname'] . "' and fn.outdated='' and fn.deleted='' left join objets_data as ln1 on ln1.toID=t.fromID and ln1.typeID='" . $name2typeID['lastname'] . "' and ln1.outdated='' and ln1.deleted='' left join objets_data as bn1 on bn1.toID=t.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' and bn1.deleted='' left join objets_data as fn1 on fn1.toID=t.fromID and fn1.typeID='" . $name2typeID['firstname'] . "' and fn1.outdated='' and fn1.deleted='' where " . $where . " t.statut = 'open' and t.sujetID is NULL " . $groupby . " order by t.updateDate desc limit $limitStart,$limitNumber")) { /**/ } |
/class/msPeopleRelations.php:145 | 1 | if($data = msSQL::sql2tab("select o.value as patientID, c.value as typeRelation, p.value as prenom, d.value as ddn, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as nom, TIMESTAMPDIFF(YEAR, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageAnnees, TIMESTAMPDIFF(MONTH, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageMois, TIMESTAMPDIFF(DAY, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageJours from objets_data as o inner join objets_data as c on c.instance=o.id and c.typeID='" . $name2typeID['relationPatientPatient'] . "' left join objets_data as n on n.toID=o.value and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=o.value and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as p on p.toID=o.value and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as d on d.toID=o.value and d.typeID='" . $name2typeID['birthdate'] . "' and d.outdated='' and d.deleted='' where o.toID='" . $this->_toID . "' and o.typeID='" . $name2typeID['relationID'] . "' and o.deleted='' and o.outdated='' group by o.value, c.id, bn.id, n.id, p.id, d.id order by STR_TO_DATE(d.value, '%d/%m/%Y') desc, nom asc")) { /**/ } else { /**/ } |
/class/msPeopleRelations.php:145 | 1 | $data = msSQL::sql2tab("select o.value as patientID, c.value as typeRelation, p.value as prenom, d.value as ddn, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as nom, TIMESTAMPDIFF(YEAR, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageAnnees, TIMESTAMPDIFF(MONTH, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageMois, TIMESTAMPDIFF(DAY, STR_TO_DATE(d.value, '%d/%m/%Y'), CURDATE()) AS ageJours from objets_data as o inner join objets_data as c on c.instance=o.id and c.typeID='" . $name2typeID['relationPatientPatient'] . "' left join objets_data as n on n.toID=o.value and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=o.value and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as p on p.toID=o.value and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as d on d.toID=o.value and d.typeID='" . $name2typeID['birthdate'] . "' and d.outdated='' and d.deleted='' where o.toID='" . $this->_toID . "' and o.typeID='" . $name2typeID['relationID'] . "' and o.deleted='' and o.outdated='' group by o.value, c.id, bn.id, n.id, p.id, d.id order by STR_TO_DATE(d.value, '%d/%m/%Y') desc, nom asc") |
/class/msPeopleRelations.php:68 | 1 | $relations = msSQL::sql2tab("select o.value as pratID, c.value as typeRelation, p.value as prenom, t.value as titre, CASE WHEN n.value != '' THEN n.value ELSE bn.value END as nom " . implode(" ", $champsSql) . " from objets_data as o inner join objets_data as c on c.instance=o.id and c.typeID='" . $name2typeID['relationPatientPraticien'] . "' and c.value != 'patient' left join objets_data as n on n.toID=o.value and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=o.value and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as p on p.toID=o.value and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as t on t.toID=o.value and t.typeID='" . $name2typeID['titre'] . "' and t.outdated='' and t.deleted='' " . implode(" ", $tablesSql) . " where o.toID='" . $this->_toID . "' and o.typeID='" . $name2typeID['relationID'] . "' and o.deleted='' and o.outdated='' " . implode("", $notEmpty) . " group by o.value, c.id, bn.id, n.id, p.id, t.id" . implode("", $groupBy) . " order by typeRelation = 'MT' desc, nom asc") |
/class/msObjet.php:599 | 1 | $data = msSQL::sql2tab("select p.id, p.fromID, p.toID, p.instance as parentID, p.important, p.titre, p.registerDate, t.formValues as formName, n1.value as pratPrenom, CASE WHEN n2.value != '' THEN n2.value ELSE bn.value END as pratNom, n1b.value as patientPrenom, CASE WHEN n2b.value != '' and bnb.value != '' THEN CONCAT(n2b.value, ' (', bnb.value , ')') WHEN n2b.value != '' THEN n2b.value ELSE bnb.value END as patientNom from objets_data as p left join data_types as t on p.typeID=t.id left join objets_data as n1 on n1.toID=p.fromID and n1.typeID='" . $name2typeID['firstname'] . "' and n1.outdated='' and n1.deleted='' left join objets_data as n2 on n2.toID=p.fromID and n2.typeID='" . $name2typeID['lastname'] . "' and n2.outdated='' and n2.deleted='' left join objets_data as bn on bn.toID=p.fromID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as n1b on n1b.toID=p.toID and n1b.typeID='" . $name2typeID['firstname'] . "' and n1b.outdated='' and n1b.deleted='' left join objets_data as n2b on n2b.toID=p.toID and n2b.typeID='" . $name2typeID['lastname'] . "' and n2b.outdated='' and n2b.deleted='' left join objets_data as bnb on bnb.toID=p.toID and bnb.typeID='" . $name2typeID['birthname'] . "' and bnb.outdated='' and bnb.deleted='' where p.typeID ='" . $name2typeID[$name] . "' and p.outdated='' and p.deleted='' group by p.id, bn.value, n1.value, n2.value, bnb.value, n1b.value, n2b.value order by p.creationDate desc limit " . $start . "," . $limit) |
/cron/rappelsMails-Mailjet.php:146 | 2 | $detinataire = array('praticien' => $value, 'id' => $patient['id'], 'typeCs' => $patient['type'], 'jourRdv' => $date_sms, 'heureRdv' => $patient['heure'], 'identite' => $patient['identite'], 'email' => $listeEmail[$patient['id']]) |
/cron/rappelsMails-Mailjet.php:73 | 1 | $mailParams = array("FromEmail" => $p['config']['smtpFrom'], "FromName" => $p['config']['smtpFromName'], "Subject" => 'Rappel rendez-vous Dr ' . $pa['praticien'] . ' le ' . $pa['jourRdv'] . ' à ' . $pa['heureRdv'], "Text-part" => $msgRappel, "Html-part" => nl2br($msgRappel), "Recipients" => [["Email" => $pa['email'], "Name" => $pa['identite']]], ) |
/cron/rappelsMails.php:139 | 2 | $detinataire = array('praticien' => $value, 'id' => $patient['id'], 'typeCs' => $patient['type'], 'jourRdv' => $date_sms, 'heureRdv' => $patient['heure'], 'identite' => $patient['identite'], 'email' => $listeEmail[$patient['id']]) |
/cron/inbox.php:129 | 1 | $data = array('txtFileName' => $filename . '.txt', 'mailForUserID' => $userID, 'mailHeaderInfos' => serialize(msTools::utf8_converter($msgV)), 'txtDatetime' => date("Y-m-d H:i:s", $msgV['udate']), 'txtNumOrdre' => $msgV['uid'], 'hprimIdentite' => $hprim['prenom'] . ' ' . $hprim['nom'], 'hprimExpediteur' => $hprim['expediteur'], 'hprimCodePatient' => $hprim['codePatient'], 'hprimDateDossier' => $hprim['dateDossier'], 'hprimAllSerialize' => serialize($hprim), 'pjNombre' => count($pj), 'pjSerializeName' => serialize($pj)) |
/class/msHprim.php:55 | 1 | $r[] = array('label' => $l[1], 'labelStandard' => $l[2], 'typeResultat' => $l[3], 'resultat' => $l[4], 'unite' => $l[5], 'normaleInf' => $l[6], 'normaleSup' => $l[7], 'indicateurAnormal' => $l[8], 'statutRes' => $l[9], 'resAutreU' => $l[10], 'normaleInfAutreU' => $l[11], 'normalSupAutreU' => $l[12]) |
/class/msModBaseObjetPreview.php:221 | 1 | $html = '<object data="' . $p['page']['pj']['href'] . '" width="' . $p['page']['doc']['displayParams']['width'] . '" height="' . $p['page']['doc']['displayParams']['height'] . '" style="border: 15px solid #DDD" type="' . $p['page']['doc']['mime'] . '"> </object>' |
/class/msReglementActe.php:209 | 1 | $d = msSQL::sqlUnique("select " . implode(', ', msSQL::cleanArray($cols)) . " from actes_base where code='" . msSQL::cleanVar($this->_acteCode) . "' and type='NGAP' and codeProf='" . msSQL::cleanVar($this->_secteurTarifaireNgap) . "' limit 1") |
/class/msReglementActe.php:181 | 1 | $d = msSQL::sqlUnique("select " . implode(', ', msSQL::cleanArray($cols)) . " from actes_base where code='" . msSQL::cleanVar($this->_acteCode) . "' and type='CCAM' and activite='" . $this->_acteActivite . "' and phase='" . $this->_actePhase . "' limit 1") |
/class/msDropbox.php:103 | 1 | $this->_boxesContents[$box][$item->getFilename( )] = array('filename' => $item->getFilename( ), 'date' => $item->getATime( ), 'size' => msTools::readabledSize($item->getSize( ), 1), 'ext' => $item->getExtension( ), ) |
/class/msSMSallMySMS.php:473 | 1 | $campaignReturnTab = @array('status' => $data['status'], 'statusText' => $data['statusText'], 'invalidNumbers' => $data['invalidNumbers'], 'campaignId' => $data['campaignId'], 'creditsUsed' => $data['creditsUsed'], 'nbContacts' => $data['nbContacts'], 'nbSms' => $data['nbSms'], 'credits' => $data['credits'], ) |
/class/msTransmissions.php:306 | 1 | $trans = msSQL::sqlUnique("select t.id, t.fromID, t.sujet, t.aboutID, t.priorite, t.updateDate, t.registerDate, t.texte, t.statut, CASE WHEN ln.value != '' and bn.value != '' THEN concat(COALESCE(ln.value,'') , ' (' , COALESCE(bn.value,'') , ') ',COALESCE(fn.value,'')) WHEN bn.value != '' THEN concat(COALESCE(bn.value,'') , ' ' ,COALESCE(fn.value,'')) ELSE concat(COALESCE(ln.value,'') , ' ' , COALESCE(fn.value,'')) END as identiteAbout, CASE WHEN ln1.value != '' THEN concat(COALESCE(ln1.value,'') , ' ' , COALESCE(fn1.value,'')) ELSE concat(COALESCE(bn1.value,'') , ' ' , COALESCE(fn1.value,'')) END as identiteAuteur from transmissions as t left join transmissions_to as trto on t.id = trto.sujetID and trto.toID = '" . $this->_userID . "' left join objets_data as ln on ln.toID=t.aboutID and ln.typeID='" . $name2typeID['lastname'] . "' and ln.outdated='' and ln.deleted='' left join objets_data as bn on bn.toID=t.aboutID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as fn on fn.toID=t.aboutID and fn.typeID='" . $name2typeID['firstname'] . "' and fn.outdated='' and fn.deleted='' left join objets_data as ln1 on ln1.toID=t.fromID and ln1.typeID='" . $name2typeID['lastname'] . "' and ln1.outdated='' and ln1.deleted='' left join objets_data as bn1 on bn1.toID=t.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' and bn1.deleted='' left join objets_data as fn1 on fn1.toID=t.fromID and fn1.typeID='" . $name2typeID['firstname'] . "' and fn1.outdated='' and fn1.deleted='' where t.id='" . $this->_id . "' limit 1") |
/class/msTransmissions.php:237 | 1 | $listeSujets = msSQL::sql2tab("select t.id, t.sujet, t.aboutID, t.priorite, t.updateDate, t.registerDate, CASE WHEN ln.value != '' and bn.value != '' THEN concat(COALESCE(ln.value,'') , ' (' , COALESCE(bn.value,'') , ') ',COALESCE(fn.value,'')) WHEN bn.value != '' THEN concat(COALESCE(bn.value,'') , ' ' ,COALESCE(fn.value,'')) ELSE concat(COALESCE(ln.value,'') , ' ' , COALESCE(fn.value,'')) END as identiteAbout, CASE WHEN ln1.value != '' THEN concat(COALESCE(ln1.value,'') , ' ' , COALESCE(fn1.value,'')) ELSE concat(COALESCE(bn1.value,'') , ' ' , COALESCE(fn1.value,'')) END as identiteAuteur from transmissions as t " . $lj . " left join objets_data as ln on ln.toID=t.aboutID and ln.typeID='" . $name2typeID['lastname'] . "' and ln.outdated='' and ln.deleted='' left join objets_data as bn on bn.toID=t.aboutID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' left join objets_data as fn on fn.toID=t.aboutID and fn.typeID='" . $name2typeID['firstname'] . "' and fn.outdated='' and fn.deleted='' left join objets_data as ln1 on ln1.toID=t.fromID and ln1.typeID='" . $name2typeID['lastname'] . "' and ln1.outdated='' and ln1.deleted='' left join objets_data as bn1 on bn1.toID=t.fromID and bn1.typeID='" . $name2typeID['birthname'] . "' and bn1.outdated='' and bn1.deleted='' left join objets_data as fn1 on fn1.toID=t.fromID and fn1.typeID='" . $name2typeID['firstname'] . "' and fn1.outdated='' and fn1.deleted='' where " . $where . " t.statut = 'open' and t.sujetID is NULL " . $groupby . " order by t.updateDate desc limit $limitStart,$limitNumber") |
/controlers/patient/actions/inc-action-sendMail-ns-Mailjet.php:30 | 1 | $mailParams = array("FromEmail" => $_POST['mailFrom'], "FromName" => $p['config']['smtpFromName'], "Subject" => $_POST['mailSujet'], "Text-part" => $_POST['mailBody'], "Html-part" => nl2br($_POST['mailBody']), "Recipients" => [["Email" => $_POST['mailTo']]], ) |
/controlers/patient/actions/inc-ajax-getFseData.php:95 | 1 | $data = array('formFields' => array('ips' => $ips, 'numero_rpps' => $pratData['rpps'], 'medecin_traitant_declare' => $medecin_traitant_declare, 'prenom_1180' => $prenom_1180, 'nom_1180' => $nom_1180, 'msehrParams' => json_encode($msehrJsonData)), 'actes' => $actes, 'jsonMsehrParams' => $msehrJsonData) |
/controlers/compta/today.php:55 | 1 | $lr = msSQL::sql2tab("select pd.toID, pd.fromID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, dc.module, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.id in ( select pd1.id from objets_data as pd1 where pd1.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd1.creationDate) = CURDATE() and pd1.deleted='' and pd1.fromID in ('" . implode("','", array_keys($p['page']['pratsAuto'])) . "')) union select pd.toID, pd.fromID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, dc.module, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.instance in ( select pd2.id from objets_data as pd2 where pd2.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd2.creationDate) = CURDATE() and pd2.deleted='' and pd2.fromID in ('" . implode("','", array_keys($p['page']['pratsAuto'])) . "')) order by creationDate asc ") |
/controlers/compta/compta.php:115 | 1 | $lr = msSQL::sql2tab("select pd.toID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.id in ( select pd1.id from objets_data as pd1 where pd1.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd1.creationDate) >= '" . $beginPeriode->format("Y-m-d") . "' and DATE(pd1.creationDate) <= '" . $endPeriode->format("Y-m-d") . "' and pd1.deleted='' and pd1.fromID in ('" . implode("','", $p['page']['pratsSelect']) . "')" . ($impayes ? "and important='y'" : "") . " ) union select pd.toID, pd.id, pd.typeID, pd.value, pd.creationDate, pd.registerDate, pd.instance, p.value as prenom , a.label, dc.name, CASE WHEN n.value != '' and bn.value !='' THEN concat(n.value, ' (', bn.value,')') WHEN n.value != '' THEN n.value ELSE bn.value END as nom from objets_data as pd left join data_types as dc on dc.id=pd.typeID left join actes as a on pd.parentTypeID=a.id left join objets_data as p on p.toID=pd.toID and p.typeID='" . $name2typeID['firstname'] . "' and p.outdated='' and p.deleted='' left join objets_data as n on n.toID=pd.toID and n.typeID='" . $name2typeID['lastname'] . "' and n.outdated='' and n.deleted='' left join objets_data as bn on bn.toID=pd.toID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where pd.instance in ( select pd2.id from objets_data as pd2 where pd2.typeID in ('" . implode("','", $porteursReglementIds) . "') and DATE(pd2.creationDate) >= '" . $beginPeriode->format("Y-m-d") . "' and DATE(pd2.creationDate) <= '" . $endPeriode->format("Y-m-d") . "' and pd2.deleted='' and pd2.fromID in ('" . implode("','", $p['page']['pratsSelect']) . "')" . ($impayes ? "and important='y'" : "") . " ) order by creationDate asc ") |
/class/msPeople.php:410 | 1 | $csAldID = msSQL::sql2tabKey("select p.id, n1.value as prenom, CASE WHEN n2.value != '' THEN n2.value ELSE bn.value END as nom from objets_data as p left join objets_data as n1 on n1.toID=p.fromID and n1.typeID='" . $name2typeID['firstname'] . "' and n1.outdated='' and n1.deleted='' left join objets_data as n2 on n2.toID=p.fromID and n2.typeID='" . $name2typeID['lastname'] . "' and n2.outdated='' and n2.deleted='' left join objets_data as bn on bn.toID=p.fromID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where p.toID='" . $this->_toID . "' and p.typeID='" . $name2typeID['csAtcdStrucDeclaration'] . "' and p.deleted='' and p.outdated='' and p.instance='" . $name2typeID[$parentTypeName] . "' ", 'id') |
/class/msPeople.php:476 | 1 | $rd['allergiesData'] = msSQL::sql2tabKey("select p.*, CASE WHEN n2.value != '' THEN concat(n1.value, ' ',n2.value) ELSE concat(n1.value, ' ', bn.value) END as fromName, p1.value as libelle from objets_data as p left join objets_data as p1 on p1.instance=p.id and p1.typeID='" . $name2typeID['allergieLibelleTheriaque'] . "' and p1.outdated='' and p1.deleted='' left join objets_data as n1 on n1.toID=p.fromID and n1.typeID='" . $name2typeID['firstname'] . "' and n1.outdated='' and n1.deleted='' left join objets_data as n2 on n2.toID=p.fromID and n2.typeID='" . $name2typeID['lastname'] . "' and n2.outdated='' and n2.deleted='' left join objets_data as bn on bn.toID=p.fromID and bn.typeID='" . $name2typeID['birthname'] . "' and bn.outdated='' and bn.deleted='' where p.toID='" . $this->_toID . "' and p.typeID='" . $name2typeID['allergieCodeTheriaque'] . "' and p.deleted='' and p.outdated='' and p.instance='" . $name2typeID[$parentTypeName] . "' ", 'id') |
/class/msTools.php:345 | 1 | $texte = str_replace(array('à', 'â', 'ä', 'á', 'ã', 'å', 'î', 'ï', 'ì', 'í', 'ô', 'ö', 'ò', 'ó', 'õ', 'ø', 'ù', 'û', 'ü', 'ú', 'é', 'è', 'ê', 'ë', 'ç', 'ÿ', 'ñ', 'À', 'Â', 'Ä', 'Á', 'Ã', 'Å', 'Î', 'Ï', 'Ì', 'Í', 'Ô', 'Ö', 'Ò', 'Ó', 'Õ', 'Ø', 'Ù', 'Û', 'Ü', 'Ú', 'É', 'È', 'Ê', 'Ë', 'Ç', 'Ÿ', 'Ñ', 'œ', 'Œ'), array('a', 'a', 'a', 'a', 'a', 'a', 'i', 'i', 'i', 'i', 'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'e', 'e', 'e', 'e', 'c', 'y', 'n', 'A', 'A', 'A', 'A', 'A', 'A', 'I', 'I', 'I', 'I', 'O', 'O', 'O', 'O', 'O', 'O', 'U', 'U', 'U', 'U', 'E', 'E', 'E', 'E', 'C', 'Y', 'N', 'oe', 'OE'), $texte) |
/class/msLapAnalysePres.php:238 | 1 | $data = array('aredondances' => $this->getAlertesRedondances( ), 'aposologies' => $this->getAlertesPosologies( ), 'aallergies' => $this->getAlertesAllergies( ), 'acipemg' => $this->getAlertesCIPEMG( ), 'agrossesse' => $this->getAlertesGrossesse( ), 'ainteractions' => $this->getAlertesInteractions( ), 'aincompatibilites' => $this->getAlertesIncompatibilites( ), 'adopageconduc' => $this->getAlertesDopageEtConducteur( ), 'apatient' => $this->_patientPhysioControleData, 'corLi' => $this->_correspondanceLignes, 'ordo' => $this->_ordonnanceContenu) |