MAth-Cloud-3.0.0/www.ipsocloud.com/intimamedia.com/www.intimamedia.com/services/PhysicianStats.php

<?php
require_once('vo/com/imt/intimamedia/vo/UserVo.php');
require_once('vo/com/imt/intimamedia/vo/PersonVo.php');
require_once('vo/com/imt/intimamedia/vo/PatientVo.php');
require_once('vo/com/imt/intimamedia/vo/HospitalVo.php');
require_once('vo/com/imt/intimamedia/vo/UltraSoundScannerVo.php');
require_once('vo/com/imt/intimamedia/vo/ProbeVo.php');
require_once('vo/com/imt/intimamedia/vo/MailVo.php');
require_once('vo/com/imt/intimamedia/vo/TermsVo.php');
require_once('vo/com/imt/intimamedia/vo/MeasuresVo.php');
require_once('vo/com/imt/intimamedia/vo/MessageVo.php');
require_once('vo/com/imt/intimamedia/vo/AppointmentVo.php');
require_once('vo/com/imt/intimamedia/vo/TobaccoVo.php');
require_once('vo/com/imt/intimamedia/vo/AtsVo.php');
require_once('vo/com/imt/intimamedia/vo/ReturnObjectVo.php');
require_once('vo/com/imt/intimamedia/vo/PersonalHistoryVo.php');
require_once('vo/com/imt/intimamedia/vo/FamilyHistoryVo.php');
require_once('vo/com/imt/intimamedia/vo/CvExaminatorVo.php');
require_once('vo/com/imt/intimamedia/vo/TreatmentVo.php');
require_once('common/SQLServerManager.php');
require_once('common/SecurityManager.php');
require_once('common/ImtMail.php');
require_once('PatientService.php');
require_once('AcquisitionService.php');
require_once('MeasureService.php');
require_once('backoffice/Physician.php');

define ('INTIMAMEDIA_APPLICATION', 'INTIMA');

  function getPhysiciansStats()
  {     
    $token = time() + 1000;
    $patientNumber = 0;
    $imtf = 0;
    $imtn = 0;
    $distance = 0;
    $area = 0;
    $area2 = 0;
    $appointmentNumber = 0;
    // valeurs prises en compte Damour anciennes valeurs de ref perdues lors de manip par JD, et prise en compte nouvelles valeurs cr��es par PJT le 26/06/2012  //
    $Ameans = array('0.5107231011','0.5042054049','0.5550256430','0.6296659975','0.7842889045','0.7382287744','0.6338284859');
    $Adistance = array('3.6142263811025','3.6548746526851','3.7622849048009','4.1618385180629','4.5708662011987','4.7332259254944','7.2769521912992','19.985023064405');
    $Aarea = array('61.985178608019');
    //---------------------------------------------------------------------------------------------------------------------------------//
    $physicianArray = getPhysicians();
    
    foreach ($physicianArray as $physician)
    { 
      $patientArray = getPatients($physician->personId);
      $patientNumber = 0;
          
        $imtf = 0;
        $imtn = 0;
        $distance = 0;
        $area = 0;
        $area2 = 0;
        $appointmentNumber = 0;
     
        
      foreach ($patientArray as $patient)
      {
        $patientNumber++;
       
           
        $appointmentArray = getAppointments($patient->id);
        
       
        foreach ($appointmentArray as $appointment)
        {
          $appointmentNumber++;
        
          $measuresArray = getMeasures($appointment->id);
     
          foreach ($measuresArray as $measure)
          {
            if ($measure->fwImt && !in_array($measure->fwImt->mean, $Ameans))
            {  
               $imtf++; 
               
            }
            if ($measure->nwImt && !in_array($measure->nwImt->mean, $Ameans))
            {  
               $imtn++;
               
            }
            if ($measure->distance && !in_array($measure->distance->value, $Adistance))
              {   
                $distance++;
                  
              }
            if ($measure->area && !in_array($measure->area->value, $Aarea)) 
            { 
              $area++;
               
            }
          }                
        }
      }                    
      $res='';
      $css='';
       if ($appointmentNumber > 0 && !$imtf && !$imtn && !$distance && !$area)
       { $res='<div id="measures">Aucune Mesure</div>';   
          $css='';
       }
       else 
       { $res= '<div id="measures">IMT Far Wall = ' . $imtf . ', IMT Near Wall = ' . $imtn . ', distance = ' . $distance . ', surface = ' . $area.'</div>';
          $css='haveMeasure';
         } 
       
      echo '<div id="physician" class="'.$css.'"><div id="login">'.$physician->login.'</div>';
      echo '<div id="patient">'.$patientNumber.' patient(s), '.$appointmentNumber.'appointment(s)</div>';
      echo $res; 
      echo "</div><hr />"; 
      $css="";        
    }
  }
 
  function getPhysicians()
  {
    $query 			 = "SELECT u.[id] as userId, u.[login], u.[last_connection], ".
                  "p.[id] as personId, p.[first_name], p.[last_name], p.[creation] ".
                  "FROM [evolucare].[dbo].[tj_user] u ".
                  "LEFT JOIN [evolucare].[dbo].[t_person] p on p.id = u.fk_person ".      
                  "WHERE u.[login] not like 'pjt%@%' and u.[login] not like 'rogerdunyk%' ". 
	                "and u.[login] not like '%evolucare%' and u.[login] not like '%@iimt.fr' ".
	                "and u.[login] not like 'chjac%' and u.[login] not like '%rbb%' and u.[login] not like '%rb2conseil%' ".
                  "and u.[last_connection] <> '';";                       
    
		$results 			 = SQLServerManager::queryOnDatabase( $query );
    
    $physicianArray = array();
    foreach( $results as $value ) 
		{
      $physician = new Physician();
      
      $physician->userId = $value->userId;
      $physician->personId = $value->personId;
      $physician->login = trim($value->login);
      $physician->first_name = trim($value->first_name);
      $physician->last_name = trim($value->last_name);
      $physician->creation = $value->creation;
      $physician->last_connection = $value->last_connection;
      
      array_push( $physicianArray, $physician );   
    } 
    
    return $physicianArray;  
  }
  
  function getPatients($personId)
  {
    $query 			 = "SELECT * FROM [evolucare].[dbo].[t_patient] ".
                   "WHERE fk_physician = ". $personId . ";";                       
    
		$results 			 = SQLServerManager::queryOnDatabase( $query );
    
    $patientArray = array();
    foreach( $results as $value ) 
    {
      $patientVo = new PatientVo();
      
      $patientVo->id = $value->id;
      $patientVo->uid = $value->uid;
      
      array_push($patientArray, $patientVo);
    }
    
    return $patientArray;
  }

  function getAppointments($patientId)
  {
    $query 			 = "SELECT * FROM [intimamedia_physician].[dbo].[tj_appointment] ".
                   "WHERE fk_patient = ". $patientId . ";";                       
    
		$results 			 = SQLServerManager::queryOnDatabase( $query );
    
    $appointmentArray = array();
    foreach( $results as $value ) 
    {
      $appointmentVo = new AppointmentVo();
      
      $appointmentVo->id = $value->id;
      $appointmentVo->number = $value->number;
      $appointmentVo->date = $value->date;
      
      array_push($appointmentArray, $appointmentVo);
    }
    
    return $appointmentArray;
  }
  
function getMeasures($appointmentId) 
  {
		$query 		 = "SELECT * "
                ."FROM [intimamedia_physician].[dbo].[tj_measure] m "
                ."LEFT JOIN [intimamedia_physician].[dbo].[t_image] im on im.id = m.fk_image "
                ."WHERE im.fk_appointment = ".$appointmentId.";";
    
		$results 	 = SQLServerManager::queryOnDatabase( $query );

		if( count($results) == 0 )
		{
			//echo 'error 023 - resultats mesures vide';
		} 

    $resultArray = array();
		foreach( $results as $value ) 
		{				
		  $measuresVo = new MeasuresVo();
		  
      $measuresVo->id = $value->id;
      $measuresVo->imageId = $value->fk_image;
      $measuresVo->measureUnit = $value->fk_measure_unit;
      
      if ($value->fk_scale)
      {
          $scaleQuery 	= "SELECT * FROM [intimamedia_physician].[dbo].[t_scale]"
                        ." WHERE id = '" . $value->fk_scale . "'";
    
		      $scaleExecQuery 	 = SQLServerManager::queryOnDatabase( $scaleQuery );
        
          $scaleVo = new ScaleVo();
          foreach( $scaleExecQuery as $scaleResult ) 
		     {
            $scaleVo->id = $scaleResult->id;
            $scaleVo->value = $scaleResult->value;
            $scaleVo->length = $scaleResult->length;
            $scaleVo->xFirstPoint = $scaleResult->x_first_point;
            $scaleVo->yFirstPoint = $scaleResult->y_first_point;
            $scaleVo->xLastPoint = $scaleResult->x_last_point;
            $scaleVo->yLastPoint = $scaleResult->y_last_point;
          } 
          
          $measuresVo->scale = $scaleVo;
      }
      
      if ($value->fk_distance)
      {
           $distanceQuery 	= "SELECT id,value,type FROM [intimamedia_physician].[dbo].[t_distance]"
                        ." WHERE id = '" . $value->fk_distance . "'";
    
		      $distanceExecQuery 	 = SQLServerManager::queryOnDatabase( $distanceQuery );
        
          $distanceVo = new DistanceVo();
          foreach( $distanceExecQuery as $distanceResult ) 
		      {
            $distanceVo->id = $distanceResult->id;
            $distanceVo->value = $distanceResult->value;
            $distanceVo->type = $distanceResult->type;
          } 
          
          $measuresVo->distance = $distanceVo;
      }
      
      if ($value->fk_area)
      {
          $areaQuery 	= "SELECT * FROM [intimamedia_physician].[dbo].[t_area]"
                        ." WHERE id = '" . $value->fk_area . "'";
    
		      $areaExecQuery 	 = SQLServerManager::queryOnDatabase( $areaQuery );
        
          $areaVo = new AreaVo();
          foreach( $areaExecQuery as $areaResult ) 
		      {
            $areaVo->id = $areaResult->id;
            $areaVo->value = $areaResult->value;
            $areaVo->points = unserialize($areaResult->points);
          } 
          
          $measuresVo->area = $areaVo;
      }
      
      if ($value->fk_area2)
      {
          $area2Query   = "SELECT * FROM [intimamedia_physician].[dbo].[t_area]"
                        ." WHERE id = '" . $value->fk_area2 . "'";
    
          $area2ExecQuery    = SQLServerManager::queryOnDatabase( $area2Query );
        
          $area2Vo = new AreaVo();
          foreach( $area2ExecQuery as $areaResult ) 
          {
            $area2Vo->id = $areaResult->id;
            $area2Vo->value = $areaResult->value;
            $area2Vo->points = unserialize($areaResult->points);
          } 
          
          $measuresVo->area = $area2Vo;
      } 

      if ($value->fk_imtf)
      {
                               
         $imtfQuery 	= "SELECT *, CONVERT(varchar(max), intima) as intimaString, CONVERT(varchar(max), adventitia) as adventitiaString "
        ."FROM [intimamedia_physician].[dbo].[t_imt] "
        ."WHERE id = '" . $value->fk_imtf . "'";
                      
        
    
		    $imtfResults 	 = SQLServerManager::queryOnDatabase( $imtfQuery );
        
        foreach( $imtfResults as $imtfValue ) 
		    {
          $imtfResultVo = new ImtResultVo();
        //  $imtfResultVo->id = $imtfValue->id;
          $imtfResultVo->name = "F";
        //  $imtfResultVo->max = $imtfValue->max;
          $imtfResultVo->mean = $imtfValue->mean;
        /*  $imtfResultVo->standardDeviation = $imtfValue->standard_deviation;
          $imtfResultVo->qualityIndex = $imtfValue->iq;
          $imtfResultVo->distance = $imtfValue->distance;
          $imtfResultVo->numberOfPoints = $imtfValue->number_of_point;
          $imtfResultVo->iStartx = $imtfValue->i_startx;
          $imtfResultVo->iStarty = $imtfValue->i_starty;
          $imtfResultVo->iEndx = $imtfValue->i_endx;
          $imtfResultVo->iEndy = $imtfValue->i_endy;
          $imtfResultVo->aStartx = $imtfValue->a_startx;
          $imtfResultVo->aStarty = $imtfValue->a_starty;
          $imtfResultVo->aEndx = $imtfValue->a_endx;
          $imtfResultVo->aEndy = $imtfValue->a_endy;
          $imtfResultVo->intima = unserialize($imtfValue->intimaString);
          $imtfResultVo->adventitia = unserialize($imtfValue->adventitiaString);      */
        
        }		
        
        $measuresVo->fwImt = $imtfResultVo;
      }
      
      if ($value->fk_imtn)
      {
        $imtnQuery 	= "SELECT *, CONVERT(varchar(max), intima) as intimaString, CONVERT(varchar(max), adventitia) as adventitiaString "
                    ."FROM [intimamedia_physician].[dbo].[t_imt] "
                    ."WHERE id = '" . $value->fk_imtn . "'";
    
        
      
		    $imtnResults 	 = SQLServerManager::queryOnDatabase( $imtnQuery );
        
        foreach( $imtnResults as $imtnValue ) 
		    {
          $imtnResultVo = new ImtResultVo();
          $imtnResultVo->id = $imtnValue->id;
          $imtnResultVo->name = "N";
        //  $imtnResultVo->max = $imtnValue->max;
          $imtnResultVo->mean = $imtnValue->mean;
          /*$imtnResultVo->standardDeviation = $imtnValue->standard_deviation;
          $imtnResultVo->qualityIndex = $imtnValue->iq;
          $imtnResultVo->distance = $imtnValue->distance;
          $imtnResultVo->numberOfPoints = $imtnValue->number_of_point;
          $imtnResultVo->iStartx = $imtnValue->i_startx;
          $imtnResultVo->iStarty = $imtnValue->i_starty;
          $imtnResultVo->iEndx = $imtnValue->i_endx;
          $imtnResultVo->iEndy = $imtnValue->i_endy;
          $imtnResultVo->aStartx = $imtnValue->a_startx;
          $imtnResultVo->aStarty = $imtnValue->a_starty;
          $imtnResultVo->aEndx = $imtnValue->a_endx;
          $imtnResultVo->aEndy = $imtnValue->a_endy;
          $imtnResultVo->intima = unserialize($imtnValue->intimaString);
          $imtnResultVo->adventitia = unserialize($imtnValue->adventitiaString);  */
        }		
        
        $measuresVo->nwImt = $imtnResultVo;
      }
      
      array_push( $resultArray, $measuresVo );
		}                    
			
		return $resultArray;
	}

?>
<!doctype html>
<html>
<head>
  <link rel="stylesheet" href="backoffice/style.css" type="text/css">
</head>
<body>
      <div id="leftColumn">    
          <div id="intimamediaLogo"><img src="../images/general/intimamedia.png" /></div>
        </div>
        <div id="rightColumn">
          <div id="onlinePng"><img src="../images/general/online.png" /></div>
        </div>
            <div id="centerColumn">
               
              <div id="liststat">
                <h2 class="redIntima"> Stats </h2>
                <?php getPhysiciansStats(); ?>
              </div>
              
            </div>
  <div id="footer">&copy;2020 IntimaMedia.com - &reg;Tous droits r&eacute;serv&eacute;s</div>
  
</body>
</html>