MAth-Cloud-3.0.0/api.ipsocloud.com/api/v1/Models/DataInterface.class.php

<?php

namespace Models {

  require_once 'Config/Settings.class.php';
  require_once 'Config/Database.class.php';

  require_once 'External/PHPMailer/src/PHPMailer.php';
  require_once 'External/PHPMailer/src/SMTP.php';
  require_once 'External/PHPMailer/src/Exception.php';

  /*
  require_once 'Models/User.class.php';

  require_once 'Tools/FS.class.php';
  require_once 'Tools/UUID.class.php';
  require_once 'Tools/Random.class.php';
  require_once 'Tools/Crypto.class.php';

  require_once 'External/dompdf_0-8-6/autoload.inc.php';

  require_once 'Braintree.class.php';
  */

  class DataInterface {
    //
    public $Database;
    public $DatabaseConnection;

    /**
     * 
     */
    public function __construct() {
      $this->Database = new \Config\Database('iimt_mathcloud');
      try {
        $this->DatabaseConnection = $this->Database->getConnection();
      }
      catch (Exception $e) {
        throw $e;
      }
    }

    /**
     * Test.
     */
    public function test() {
      return array('result' => 'OK');
    }

    /**
     * Ray update.
     */
    public function rayUpdate($rayId, $userAgent, $apiKey, $ipData, $locationData) {
      $userAgent = addslashes($userAgent);
      $ipData = addslashes(json_encode($ipData));
      $locationData = addslashes(json_encode($locationData));

      $statement = $this->DatabaseConnection->prepare(
        "SELECT stamp FROM iimt_mathcloud_audit.ray WHERE ID = $rayId"
      );
      if(!$statement->execute()) {
        return array('result' => 'ERROR', 'reason' => 'internal_error', 'message' => 'Database error', 'data' => $statement->errorInfo());
      }

      $stamp = strtotime($statement->fetchAll(\PDO::FETCH_ASSOC)[0]['stamp']);
      $now = time();
      if($now - $stamp > 60 * 60 * 1) { // 1h
        $statement = $this->DatabaseConnection->prepare(
          "INSERT INTO iimt_mathcloud_audit.ray(userAgent, apiKey, ipData, locationData, userData) VALUES('$userAgent', '$apiKey', '$ipData', '$locationData', '{}')"
        );
        if(!$statement->execute()) {
          return array('result' => 'ERROR', 'reason' => 'internal_error', 'message' => 'Database error', 'data' => $statement->errorInfo());
        }
        $rayId = $this->DatabaseConnection->lastInsertId();
      }

      return array(
        'result' => 'OK',
        'rayId' => $rayId,
        'age' => $now - $stamp
      );
    }    

    /**
     * Ray create.
     */
    public function rayCreate($userAgent, $apiKey, $ipData, $locationData) {
      $userAgent = addslashes($userAgent);
      $ipData = addslashes(json_encode($ipData));
      $locationData = addslashes(json_encode($locationData));

      $statement = $this->DatabaseConnection->prepare(
        "INSERT INTO iimt_mathcloud_audit.ray(userAgent, apiKey, ipData, locationData, userData) VALUES('$userAgent', '$apiKey', '$ipData', '$locationData', '{}')"
      );
      if(!$statement->execute()) {
        return array('result' => 'ERROR', 'reason' => 'internal_error', 'message' => 'Database error', 'data' => $statement->errorInfo());
      }
      return array(
        'result' => 'OK',
        'rayId' => $this->DatabaseConnection->lastInsertId()
      );
    }    

    /**
     * Audit log.
     */
    public function auditLog($id_ray, $user_data, $activity_data) {
      $user_data = addslashes(json_encode($user_data));
      $activity_data = addslashes(json_encode($activity_data));

      $statement = $this->DatabaseConnection->prepare(
        "UPDATE iimt_mathcloud_audit.ray SET userData = '$user_data' WHERE ID = $id_ray"
      );
      if(!$statement->execute()) {
        return array('result' => 'ERROR', 'reason' => 'internal_error', 'message' => 'Database error', 'data' => $statement->errorInfo());
      }

      $statement = $this->DatabaseConnection->prepare(
        "INSERT INTO iimt_mathcloud_audit.activity(ID_ray, data) VALUES($id_ray, '$activity_data')"
      );
      if(!$statement->execute()) {
        return array('result' => 'ERROR', 'reason' => 'internal_error', 'message' => 'Database error', 'data' => $statement->errorInfo());
      }
    }

    /**
     * 
     */
    public function sendMail($from, $to, $subject, $message, $attachment) {
      //Create a new PHPMailer instance
      $mail = new \PHPMailer\PHPMailer\PHPMailer;
      //Server settings
      $mail->isSMTP();
      //$mail->Timeout = 60;
      //$mail->SMTPDebug = 2;
      $mail->SMTPDebug = 0;
      $mail->CharSet = 'UTF-8';
      $mail->Host = 'pf-1002.whm.fr-par.scw.cloud';
      $mail->Port = 465;
      //$mail->SMTPSecure = 'tls';
      //$mail->Host = 'smtp.mailtrap.io';
      //$mail->Port = 587;
      $mail->SMTPSecure = 'ssl';
      $mail->SMTPAuth = true;
      $mail->Username = "postmaster@ipsocloud.com";//"support@ipsocloud.com";
      $mail->Password = "m,R7Cs0Vb~Gt";//"0;XusXr)5-J6";
      //$mail->Username = "24fde75e8c314d";
      //$mail->Password = "d9a75cea3ba2cf";
      // Recipients
      $mail->setFrom($from, '');
      $mail->addReplyTo($from, '');
      $mail->addAddress($to, '');
      // Content
      $mail->Subject = $subject;
      $mail->isHTML(true);
      $mail->msgHTML($message);
      $mail->AltBody = strip_tags($message);
      if($attachment) {
        $mail->addAttachment($attachment, basename($attachment));
      }
      // Send the message, check for errors
      if (!$mail->send()) {
        return ['result' => 'ERROR', 'message' => $mail->ErrorInfo];
      }
      return ['result' => 'OK'];      
    }

    public static $translation = [
      'fr' => [
        // page 1
        'title2' => "Rapport échographique EIMC",
        'title6' => "Rapport échographique 6 images",
        'patientID' => "Identifiant",
        'patientName' => "Nom patient",
        'patientBirth' => "Date de naissance",
        'visitID' => "Numéro de visite",
        'institution' => "Etablissement",
        'physician' => "Praticien",
        'imt_avg' => "EIM moy",
        'imt_max' => "EIM max",
        'plaque' => "Plaque",
        'thk_max' => "Epaisseur max",
        'surface' => "Surface",
        'thk' => "Epaisseur",
        'thk_plaque' => "Epaisseur de plaque",
        'diameter' => "Diamètre",
        'left' => "Gauche",
        'right' => "Droite",
          // carotid
          'carotid_left_biffurcation' => "Bifurcation Carotide Gauche",
          'carotid_left_commune' => "A.Carotide Commune Gauche",
          'carotid_left_interne' => "A.Carotide Interne Gauche",
          'carotid_left_subclaviere' => "A.Subclavière Gauche",
          'carotid_left_tronc' => "Tronc Artériel Brachio Céphalique",
          'carotid_left_v0' => "A.Vertèbrale Gauche: V0",
          'carotid_left_v1' => "A.Vertèbrale Gauche: V1",
          'carotid_left_v2' => "A.Vertèbrale Gauche: V2",
          'carotid_left_externe' => "A.Carotide Externe Gauche",
          'carotid_left_linguale' => "A.Faciale Gauche",
          'carotid_left_thyroide' => "A.Temporale Superficielle Gauche",
          'carotid_right_biffurcation' => "Bifurcation Carotide Droite",
          'carotid_right_commune' => "A.Carotide Commune Droite",
          'carotid_right_interne' => "A.Carotide Interne Droite",
          'carotid_right_subclaviere' => "A.Subclavière Droite",
          'carotid_right_tronc' => "Tronc Artériel Brachio Céphalique",
          'carotid_right_v0' => "A.Vertèbrale Droite: V0",
          'carotid_right_v1' => "A.Vertèbrale Droite: V1",
          'carotid_right_v2' => "A.Vertèbrale Droite: V2",
          'carotid_right_externe' => "A.Carotide Externe Droite",
          'carotid_right_linguale' => "A.Faciale Droite",
          'carotid_right_thyroide' => "A.Temporale Superficielle Droite",
          // mbsup
          'mbsup_left_aradiale' => "A.Radiale Gauche",
          'mbsup_left_ahumerale' => "A.Brachiale Gauche",
          'mbsup_left_acubitale' => "A.Cubitale Gauche",
          'mbsup_left_aaxillaire' => "A.Axilaire Gauche",
          'mbsup_left_asubclav' => "A.Subclavière Gauche",
          'mbsup_right_aradiale' => "A.Radiale Droite",
          'mbsup_right_ahumerale' => "A.Brachiale Droite",
          'mbsup_right_acubitale' => "A.Cubitale Droite",
          'mbsup_right_aaxillaire' => "A.Axilaire Droite",
          'mbsup_right_asubclav' => "A.Subclavière Droite",
          // mbinf
          'mbinf_left_aorteabdo' => "Aorte abdominale",
          'mbinf_left_ailiaque' => "A.Iliaque Gauche",
          'mbinf_left_afemoralesup' => "A.Iliaque Externe Gauche",
          'mbinf_left_afemoralesups' => "A.Fémorale Profonde Gauche",
          'mbinf_left_afemoralepro' => "A.Iliaque Commune Gauche",
          'mbinf_left_apoplitee' => "A.Poplitée Gauche",
          'mbinf_left_apoplitees' => "A.Fémorale Commune Gauche",
          'mbinf_left_atibialepost' => "A.Tibiale Postérieure Gauche",
          'mbinf_right_aorteabdo' => "Aorte abdominale",
          'mbinf_right_ailiaque' => "A.Iliaque Droite",
          'mbinf_right_afemoralesup' => "A.Iliaque Externe Droite",
          'mbinf_right_afemoralesups' => "A.Fémorale Profonde Droite",
          'mbinf_right_afemoralepro' => "A.Iliaque Commune Droite",
          'mbinf_right_apoplitee' => "A.Poplitée Droite",
          'mbinf_right_apoplitees' => "A.Fémorale Commune Droite",
          'mbinf_right_atibialepost' => "A.Tibiale Postérieure Droite",
          // abdo
          'abdo__hepatic' => "A.Hépatique",
          'abdo__splenic' => "A.Splénique",
          'abdo__hepaticpropre' => "A.Hépatique propre",
          'abdo__renaledroite' => "A.Rénale droite",
          'abdo__renalegauche' => "A.Rénale gauche",
          'abdo__mesentericsup' => "A.Mésentérique supérieure",
          'abdo__mesentericinf' => "A.Mésentérique inférieure",
          'abdo__aorte' => "Aorte",
          // incidence
          'anterior' => "Antérieure",
          'lateral' => "Latérale",
          'posterior' => "Postérieure",
        // page 2
        'p2_title' => "Valeurs de référence",
        'M' => 'Homme',
        'F' => 'Femme',
        'age' => "Age",
        '25percent' => "25ème pctle",
        '50percent' => "50ème pctle",
        '75percent' => "75ème pctle",
        'imt_mean_distal' => "EIM Moyen Distale (mm)",
        'indications' => "Indications",
        'clinical' => "Signes clinique",
        'report' => "Rapport",
        'conclusion' => "Conclusion",
        'PARC' => "Europe, France, 30-79 ans, PARC 2009 (Moyenne)",
        'ARIC_CAUCASIAN' => "USA, 35-85 ans, Caucasien, ARIC 1993 (D+G). Valeurs extrapolés < à 45 et > à 65",
        'ARIC_AFRICAN' => "USA, 35-85 ans, Afro Americain, ARIC 1993 (D+G). Valeurs extrapolés < à 45 et > à 65",
        'disclaimer' => "Les informations et/ou les résultats fournis ici ne doivent pas être utilisés lors d'une urgence médicale ou pour le diagnostic ou le traitement de toute condition médicale. Un médecin agréé doit être consulté pour établir le diagnostic et le traitement éventuel. Votre médecin doit interpréter les résultats de cette mesure en conjonction avec vos autres facteurs de risque. Le traitement de vos éventuels facteurs de risque doit être prescription par votre médecin.",
        // page 3
        'p3_title' => "La mesure de l'épaisseur intima média (EIM) : considérations générales",
        'p3_subtitle1' => "Qu'est-ce que l'épaisseur intima média ?",
        'p3_text1' => "Anatomiquement, comme son nom le dit, l'épaisseur intima média concerne les 2 premières couches formant la paroi artérielle : l'intima, formée d'une seule couche de cellules et la média couche formée de cellules musculaires lisses susceptibles de se multiplier sous l'effet de stimulations mécaniques telle que l'augmentation de la pression artérielle.<br>Sur l'image échographique on différencie l'EIM de la plaque :<br>L'épaisseur Intima média est une structure caractéristique des parois de l'artère carotide commune visualisée par échographie et formant un liseré bien délimité. La plaque est un décrochage observé dans la lumière artérielle du à un dépôt d'une épaisseur au moins égale à 0.5 mm.",
        'p3_subtitle2' => "Pourquoi est ce important ?",
        'p3_text2' => "Les travaux menés par de nombreuses équipes à travers le monde ont largement démontré la valeur de ce marqueur pour prédire le risque de survenue d'un infarctus du myocarde ou d'une attaque cérébrale.<br>L'épaisseur intima média est également associée de façon significative aux principaux facteurs de risque d'athérosclérose au premier rang desquels l'hypertension artérielle. Celle ci participe pour plus de 50% à l'augmentation de l'EIM et reste le facteur modifiable le plus important après l'âge. Elle contribue à l'évaluation du risque cardio-vasculaire chez un individu.",
        'p3_subtitle3' => "Comment la mesure t-on ?",
        'p3_text3' => "Les conclusions d'un consensus d'experts internationaux initié en 2004 et repris en 2006 ont permis de définir précisément l'EIM et la plaque carotides. Ce même consensus recommande de mesurer l'EIM au niveau de la partie basse de l'artère.<br>En pratique l'examen échographique de l'artère carotide permet de figer une image de cette artère et de pratiquer sa mesure automatiquement à l'aide d'un logiciel",
        'p3_subtitle4' => "Quand pratiquer une mesure de l'épaisseur intima média ?",
        'p3_text4' => "La présence de facteurs de risque d'athérosclérose c'est à dire principalement de l'hypertension artérielle, d'une dyslipidémie, d'un diabète, d'une consommation de tabac ou d'une surcharge pondérale s'accompagne d'une augmentation de l'EIM dans bon nombre de cas et ce d'autant qu'ils sont associés.<br>Cette mesure procure une information pertinente chez des sujets présentant un ou plusieurs facteurs de risque, car elle met en évidence lorsqu'elle est augmentée l'atteinte d'un organe cible et permet de mieux évaluer le risque cardio vasculaire individuel. Il n'y a toutefois aucun intérêt pour le patient à surveiller son évolution en dehors d'une étude épidémiologique ou médicamenteuse.",
        'p3_subtitle5' => "Suggestions pour maintenir votre système vasculaire en bonne santé :",
        'p3_text5' => "- Arrêter de fumer<br>- Manger une nourriture saine et pauvre en graisse<br>- Si vous êtes en surpoids, parlez-en à votre médecin afin de traiter votre surcharge pondérale<br>- Faites surveiller votre pression artérielle et votre cholestérol<br>- Pratiquez une activité physique régulière",
      ],
      'en' => [
        // page 1
        'title2' => "CIMT ultrasound report",
        'title6' => "Six images report",
        'patientID' => "Patient ID",
        'patientName' => "Patient name",
        'patientBirth' => "Date of birth",
        'visitID' => "Visit number",
        'institution' => "Organization",
        'physician' => "Physician",
        'imt_avg' => "IMT avg",
        'imt_max' => "IMT max",
        'plaque' => "Plaque",
        'thk_max' => "Thickness max",
        'surface' => "Surface",
        'thk' => "Thickness",
        'thk_plaque' => "Plaque thickness",
        'diameter' => "Diameter",
        'left' => "Left",
        'right' => "Right",
          // carotid
          'carotid_left_biffurcation' => "Left Carotid Bifurcation",
          'carotid_left_commune' => "Left Common Carotid Artery",
          'carotid_left_interne' => "Left Internal Carotid Artery",
          'carotid_left_subclaviere' => "Left Subclavian Artery",
          'carotid_left_tronc' => "Brachio Cephalic Arterial Trunk",
          'carotid_left_v0' => "Left V0 Vertebral Segment",
          'carotid_left_v1' => "Left V1 Vertebral Segment",
          'carotid_left_v2' => "Left V2 Vertebral Segment",
          'carotid_left_externe' => "Left External Carotid Artery",
          'carotid_left_linguale' => "Left Facial Artery",
          'carotid_left_thyroide' => "Left Superficial Temporal Artery",
          'carotid_right_biffurcation' => "Right Carotid Bifurcation",
          'carotid_right_commune' => "Right Common Carotid Artery",
          'carotid_right_interne' => "Right Internal Carotid Artery",
          'carotid_right_subclaviere' => "Right Subclavian Artery",
          'carotid_right_tronc' => "Brachio Cephalic Arterial Trunk",
          'carotid_right_v0' => "Right V0 Vertebral Segment",
          'carotid_right_v1' => "Right V1 Vertebral Segment",
          'carotid_right_v2' => "Right V2 Vertebral Segment",
          'carotid_right_externe' => "Right External Carotid Artery",
          'carotid_right_linguale' => "Right Facial Artery",
          'carotid_right_thyroide' => "Right Superficial Temporal Artery",
          // mbsup
          'mbsup_left_aradiale' => "Left Radial Artery",
          'mbsup_left_ahumerale' => "Left Brachial Artery",
          'mbsup_left_acubitale' => "Left Cubital Artery",
          'mbsup_left_aaxillaire' => "Left Axillary Artery",
          'mbsup_left_asubclav' => "Left Subclavian Artery",
          'mbsup_right_aradiale' => "Right Radial Artery",
          'mbsup_right_ahumerale' => "Right Brachial Artery",
          'mbsup_right_acubitale' => "Right Cubital Artery",
          'mbsup_right_aaxillaire' => "Right Axillary Artery",
          'mbsup_right_asubclav' => "Right Subclavian Artery",
          // mbinf
          'mbinf_left_aorteabdo' => "Abdominal Aorta",
          'mbinf_left_ailiaque' => "Left Iliac Artery",
          'mbinf_left_afemoralesup' => "Left External Iliac Artery",
          'mbinf_left_afemoralesups' => "Left Deep Femoral Artery",
          'mbinf_left_afemoralepro' => "Left Common Iliac Artery",
          'mbinf_left_apoplitee' => "Left Popliteal Artery",
          'mbinf_left_apoplitees' => "Left Common Femoral Artery",
          'mbinf_left_atibialepost' => "Left Posterior Tibial Artery",
          'mbinf_right_aorteabdo' => "Abdominal Aorta",
          'mbinf_right_ailiaque' => "Right Iliac Artery",
          'mbinf_right_afemoralesup' => "Right External Iliac Artery",
          'mbinf_right_afemoralesups' => "Right Deep Femoral Artery",
          'mbinf_right_afemoralepro' => "Right Common Iliac Artery",
          'mbinf_right_apoplitee' => "Right Popliteal Artery",
          'mbinf_right_apoplitees' => "Right Common Femoral Artery",
          'mbinf_right_atibialepost' => "Right Posterior Tibial Artery",
          // abdo
          'abdo__hepatic' => "Hepatic Artery",
          'abdo__splenic' => "Splenic Artery",
          'abdo__hepaticpropre' => "Hepatic Artery Proper",
          'abdo__renaledroite' => "Right renal Artery",
          'abdo__renalegauche' => "Left renal Artery",
          'abdo__mesentericsup' => "Superior Mesenteric Artery",
          'abdo__mesentericinf' => "Inferior Mesenteric artery",
          'abdo__aorte' => "Aorta",
          // incidence
          'anterior' => "Anterior",
          'lateral' => "Lateral",
          'posterior' => "Posterior",
        // page 2
        'p2_title' => "Reference values",
        'M' => 'Male',
        'F' => 'Female',
        'age' => "Age",
        '25percent' => "25th pctle",
        '50percent' => "50th pctle",
        '75percent' => "75th pctle",
        'imt_mean_distal' => "Distal Mean IMT (mm)",
        'indications' => "Indications",
        'clinical' => "Clinical signs",
        'report' => "Report",
        'conclusion' => "Conclusion",
        'PARC' => "Europe, France, 30-79 years, PARC 2009 (Mean)",
        'ARIC_CAUCASIAN' => "USA, 35-85 years, Caucasian, ARIC 1993 (R+L). Extrapolated values below 45 and over 65",
        'ARIC_AFRICAN' => "USA, 35-85 years, African American, ARIC 1993 (R+L). Extrapolated values below 45 and over 65",
        'disclaimer' => "The information and or results provided herein should not be used during any medical emergency or for the diagnosis or treatment of any medical condition. A licensed physician should be consulted for diagnosis and treatment of any and all medical conditions. Your Doctor should interpret this IMT results in conjunction with your other risk factors. Risk factor modifications should be made with the consultation of your Doctor. Call 911 for all medical emergencies.",
        // page 3
        'p3_title' => "Intima media thickness measurement (IMT)",
        'p3_subtitle1' => "What is IMT ?",
        'p3_text1' => "Intima media thickness is made of the 2 first internal layers of the arterial wall: the intima, very thin layer which protects the artery from local deposits of blood components and the media composed of muscle cells which increase their number with high blood pressure. Its representation on ultrasound image a regular double line pattern well seen on the far wall of the common carotid artery.<br>Plaque is a focal encroachment into the arterial lumen.",
        'p3_subtitle2' => "Why is it important ?",
        'p3_text2' => "The non modifiable risk factors that may influence IMT values are age sex and genetics, High blood pressure, lipids, diabetes and smoking are the modifiable factors on which life style modifications and drugs can be recommended.<br>Increased IMT can predict clinical outcomes as myocardial infarction and stroke. This has been validated by many prospective studies.",
        'p3_subtitle3' => "How is it measured ?",
        'p3_text3' => "The conclusions of an international consensus of experts initiated in 2004 and revised in 2006 have precisely defined carotid IMT and plaque. This consensus recommends measuring IMT at the lower level of the carotid artery called common carotid.<br>In practice, the ultrasound examination of the carotid artery consists in freezing an image of this artery and automatically measuring it with a software. The results are expressed as the mean value over a 10mm segment of common carotid artery",
        'p3_subtitle4' => "When to measure Intima Media Thickness ?",
        'p3_text4' => "The presence of atherosclerosis risk factors, that is mainly arterial hypertension, dyslipemia, diabetes, smoking or overweight, comes with an increase of IMT in many cases and even more if they are associated.<br>This measurement shows great information on subjects who have one or more risk factors as it reveals when increased a target organ damage and facilitates the individual cardio-vascular risk evaluation. However, there is no need to watch its evolution outside of epidemiological or interventional studies.",
        'p3_subtitle5' => "Suggestions for maintaining a healthy vascular system.",
        'p3_text5' => "- Stop smoking.<br>- Eat a healthy, low fat diet.<br>- Talk to your doctor if you are overweight to plan the best weight loss strategy for you.<br>- Maintain good cholesterol levels.<br>- Maintain blood pressure in a normal range<br>- Exercise regularly - even a moderate walking program can be effective.",
      ]
    ];    

  }

}

?>