Export a full encounter as pdf

MerlinSilk · November 23, 2018, 7:16am

Hi,
I am trying to work my way though all the tables and how they are connected and I am getting to some results, but I thought maybe asking somebody who just KNOWS the structure of the database, gets me on the way without missing anything.
What I have to do is output an encounter for a patient as a pdf files which includes all the data in the encounter forms.
So, 1st what table do I use best to get all the encounters for a specific patient ID - the same info that I see when I look at the encounter history in a patients demographics?
Once I have the array of all the encounters, I use each of them (by data) to find all the data for this encounter. For this one, how do I find all the forms (and I have a lot of custom forms there) that were used in that encounter?

Thanks for any help you might be able to give me here.
Merlin

stephenwaite · November 23, 2018, 12:58pm

hi @MerlinSilk, have you tried Report from the pt summary screen? 57%20AM

MerlinSilk · November 23, 2018, 6:16pm

Hi Stephen,

thanks, but I guess I was not clear that I am trying to do this programmatically, not from the user interface. I have my customization function already written in php and now want to learn what SQL queries I have to write against the database to get the data I described in my initial message.

Cheers,
Merlin

stephenwaite · November 23, 2018, 8:27pm

well this script builds the custom report so it must step through the database to gather all of the relevant data

github.com

openemr/openemr/blob/master/interface/patient_file/report/patient_report.php

<?php
/**
 * Patient report
 *
 * @package   OpenEMR
 * @link      http://www.open-emr.org
 * @author    Brady Miller <brady.g.miller@gmail.com>
 * @copyright Copyright (c) 2017-2018 Brady Miller <brady.g.miller@gmail.com>
 * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
 */

require_once("../../globals.php");
require_once("$srcdir/lists.inc");
require_once("$srcdir/acl.inc");
require_once("$srcdir/forms.inc");
require_once("$srcdir/patient.inc");

use OpenEMR\Core\Header;
use OpenEMR\Menu\PatientMenuRole;

This file has been truncated. show original

MerlinSilk · November 23, 2018, 10:21pm

Excellent Stephen!
that helped me a lot already - digging myself through the code.
I might have a few follow up questions, but for now I am up and running.
Thanks - Merlin

sjpadgett · November 23, 2018, 11:33pm

This gets you nuts and bolts. Especially pdf,
openemr/interface/patient_file/report/custom_report.php