4 $sanitize_all_escapes=true;
7 //STOP FAKE REGISTER GLOBALS
8 $fake_register_globals=false;
11 include_once("../../globals.php");
12 include_once("$srcdir/sql.inc");
13 include_once("$srcdir/options.inc.php");
14 include_once("$srcdir/immunization_helper.php");
16 //collect facility data
17 $res = sqlQuery("select concat(f.name,'\n',f.street,'\n',f.city,', ',f.state,' ',f.postal_code) as facility_address ".
18 " from facility f, users u ".
19 " where u.facility = f.name ".
20 " and u.id = ?", array($_SESSION['authId'])
23 //collect patient data
24 $res2 = sqlQuery("select concat(p.lname,', ',p.fname,' ',p.mname) patient_name ".
25 ",date_format(p.DOB,'%c/%e/%Y') as patient_DOB ".
26 ",concat(p.street,'\n',p.city,', ',p.state,' ',p.postal_code) as patient_address".
27 " from patient_data p where p.pid = ?", array($pid)
30 //collect immunizations
31 $res3 = getImmunizationList($pid, $_GET['sortby'], false);
32 $data_array = convertToDataArray($res3);
34 $title = xl('Shot Record as of:','','',' ') . date('m/d/Y h:i:s a');
36 if ($_GET['output'] == "html") {
37 printHTML($res, $res2, $data_array);
40 printPDF($res, $res2, $data_array);
44 function convertToDataArray($data_array) {
46 while ($row = sqlFetchArray($data_array)) {
48 $temp_date = new DateTime($row['administered_date']);
49 $data[$current][xl('Date') . "\n" . xl('Admin')] = $temp_date->format('Y-m-d H:i'); //->format('%Y-%m-%d %H:%i');
52 // Figure out which name to use (ie. from cvx list or from the custom list)
53 if ($GLOBALS['use_custom_immun_list']) {
54 $vaccine_display = generate_display_field(array('data_type'=>'1','list_id'=>'immunizations'), $row['immunization_id']);
57 if (!empty($row['code_text_short'])) {
58 $vaccine_display = htmlspecialchars( xl($row['code_text_short']), ENT_NOQUOTES
);
61 $vaccine_display = generate_display_field(array('data_type'=>'1','list_id'=>'immunizations'), $row['immunization_id']);
64 $data[$current][xl('Vaccine')] = $vaccine_display;
67 if ($row['amount_administered'] > 0) {
68 $data[$current][xl('Amount') . "\n" . xl('Admin')] = $row['amount_administered'] . " " .
69 generate_display_field(array('data_type'=>'1','list_id'=>'drug_units'), $row['amount_administered_unit']);
72 $data[$current][xl('Amount') . "\n" . xl('Admin')] = "";
76 $temp_date = new DateTime($row['expiration_date']);
77 $data[$current][xl('Expiration') . "\n" . xl('Date')] = $temp_date->format('Y-m-d');
80 $data[$current][xl('Manufacturer')] = $row['manufacturer'];
83 $data[$current][xl('Lot') . "\n" . xl('Number')] = $row['lot_number'];
86 $data[$current][xl('Admin') . "\n" . xl('By')] = $row['administered_by'];
89 $temp_date = new DateTime($row['education_date']);
90 $data[$current][xl('Patient') . "\n" . xl('Education') . "\n" . xl('Date')] = $temp_date->format('Y-m-d');
93 $data[$current][xl('Route')] = generate_display_field(array('data_type'=>'1','list_id'=>'drug_route'), $row['route']);
96 $data[$current][xl('Admin') . "\n" . xl('Site')] = generate_display_field(array('data_type'=>'1','list_id'=>'proc_body_site'), $row['administration_site']);
99 $data[$current][xl('Comments')] = $row['note'];
105 function printPDF($res, $res2, $data) {
106 require_once ($GLOBALS['fileroot'] . "/library/classes/class.ezpdf.php");
108 $pdf =& new Cezpdf("LETTER");
109 $pdf->ezSetMargins(72,30,50,30);
110 $pdf->selectFont($GLOBALS['fileroot'] . "/library/fonts/Helvetica.afm");
112 $opts = array('justification' => "center");
113 $pdf->ezText($res['facility_address'] ,"",$opts);
115 $pdf->ezText("\n" . $res2['patient_name'] . "\n" . xl('Date of Birth') . ": " . $res2['patient_DOB'] . "\n" . $res2['patient_address']);
118 $opts = array('maxWidth' => 550, 'fontSize' => 8);
120 $pdf->ezTable($data, "", $title, $opts);
121 $pdf->ezText("\n\n\n\n" . xl('Signature') . ":________________________________","",array('justification' => 'right'));
125 function printHTML($res, $res2, $data) {
128 //convert end of line characters to html (escape for html output first)
129 $patterns = array ('/\n/');
130 $replace = array ('<br>');
131 $res['facility_address'] = htmlspecialchars( $res['facility_address'], ENT_NOQUOTES
);
132 $res['facility_address'] = preg_replace($patterns, $replace, $res['facility_address']);
133 $res2['patient_address'] = htmlspecialchars( $res2['patient_address'], ENT_NOQUOTES
);
134 $res2['patient_address'] = preg_replace($patterns, $replace, $res2['patient_address']);
136 //deal with bug (last array index is empty)
145 font
-family
: sans
-serif
;
158 page
-break-after
: always
;
161 margin
: 20pt
0 10pt
0;
170 margin
: 30pt
0 0 20pt
;
178 margin
: 0 20pt
0 20pt
;
179 border
-collapse
: collapse
;
180 border
: 1pt solid black
;
184 padding
: 2pt
3pt
2pt
3pt
;
185 border
-right
: 1pt solid black
;
186 border
-left
: 1pt solid black
;
189 background
-color
: #D8D8D8;
193 border
: 1pt solid black
;
194 padding
: 2pt
3pt
2pt
3pt
;
203 <title
><?php
xl ('Shot Record','e'); ?
></title
>
208 //plan 15 lines per page
210 $countTotalPages = (ceil((count($data))/$linesPerPage));
211 for ($i=0;$i<$countTotalPages;$i++
) {
212 echo "<div class='paddingdiv'>\n";
214 //display facility information (Note it is already escaped)
215 echo "<div class='clinicAddress'>" . $res['facility_address'] . "</div>\n";
217 //display patient information (Note patient address is already escaped)
218 echo "<div class='patientAddress'>" . htmlspecialchars( $res2['patient_name'], ENT_NOQUOTES
) . "<br>" .
219 htmlspecialchars( xl('Date of Birth') . ": " . $res2['patient_DOB'], ENT_NOQUOTES
) . "<br>" .
220 $res2['patient_address'] . "</div>\n";
222 //display table title
223 echo "<div class='tabletitle'>" . htmlspecialchars( $title, ENT_NOQUOTES
) . "</div>\n";
225 echo "<table cellspacing='0' cellpadding='0'>\n";
229 foreach ($data[0] as $key => $value) {
231 //convert end of line characters to space
232 $patterns = array ('/\n/');
233 $replace = array (' ');
234 $key = preg_replace($patterns, $replace, $key);
235 echo "<th>".htmlspecialchars( $key, ENT_NOQUOTES
)."</th>\n";
240 for ($j=0;$j<$linesPerPage;$j++
) {
241 if ($rowData = array_shift($data)) {
243 foreach ($rowData as $key => $value) {
250 echo "<td class ='odd'>";
256 // output data of cell
257 echo ($value == "") ?
" " : htmlspecialchars($value, ENT_NOQUOTES
);
262 //done displaying shot data, so leave loop
269 //display signature line
270 echo "<div class='sign'>" . htmlspecialchars( xl('Signature'), ENT_NOQUOTES
) .
271 ":________________________________" . "</div>\n";
273 if ($countTotalPages > 1) {
274 //display page number if greater than one page
275 echo "<div class='pageNumber'>" .
276 htmlspecialchars( xl('Page') . " " . ($i+
1) . "/" . $countTotalPages, ENT_NOQUOTES
) .
285 <script language
='JavaScript'>