Patient Picture

luisuriarte · September 25, 2024, 6:09pm

Hi friends.
Please, I am trying to make a modal form for patient information. Could someone help me (where to look in the code) how to get the patient picture if I have the patient_id?.
Thank so much.
Luis

mdsupport · September 25, 2024, 9:14pm

github.com

openemr/openemr/blob/f9e3158455f3f755b4bfabd724a67380d53e3d16/src/Services/PatientService.php#L625

      
        
                    'limit' => 1,
                    'data' => [$pid]
                ]);
            
            
    return $patientRow;
            }
            
            
/**
             * @return number
             */
            public function getPatientPictureDocumentId($pid)
            {
                $sql = "SELECT doc.id AS id
                         FROM documents doc
                         JOIN categories_to_documents cate_to_doc
                           ON doc.id = cate_to_doc.document_id
                         JOIN categories cate
                           ON cate.id = cate_to_doc.category_id
                        WHERE cate.name LIKE ? and doc.foreign_id = ?";
            
            
    $result = sqlQuery($sql, array($GLOBALS['patient_photo_category_name'], $pid));

luisuriarte · September 25, 2024, 9:48pm

Thank you, thank you very much…

luisuriarte · September 26, 2024, 1:57am

I couldn’t use the function. But I found out by searching between browser console and grep, I used this code:

<img data-bind="attr: {src: patient_picture}"
class="img-thumbnail"
width="80"
height="80"
onerror="this.src = '../images/default_patient.svg'"
src="/controller.php?document&amp;retrieve&amp;patient_id=<?php echo $bedPatient['bed_patient_id']; ?>&amp;document_id=-1&amp;as_file=false&amp;original_file=true&amp;disable_exit=false&amp;show_original=true&amp;context=patient_picture">

Finally I was able to add the patient picture. Thanks a lot anyway.

<?php echo $bedPatient['bed_patient_id']; ?> is my variable.