You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
59 lines
2.5 KiB
59 lines
2.5 KiB
2 years ago
|
<?php
|
||
|
|
|
||
|
|
/**
|
||
|
|
* library/immunization_helper.php Upgrading and patching functions of database.
|
||
|
|
*
|
||
|
|
* Copyright (C) 2013 Jan Jajalla <jansta23@gmail.com>
|
||
|
|
*
|
||
|
|
* LICENSE: This program is free software; you can redistribute it and/or
|
||
|
|
* modify it under the terms of the GNU General Public License
|
||
|
|
* as published by the Free Software Foundation; either version 3
|
||
|
|
* of the License, or (at your option) any later version.
|
||
|
|
* This program is distributed in the hope that it will be useful,
|
||
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
|
|
* GNU General Public License for more details.
|
||
|
|
* You should have received a copy of the GNU General Public License
|
||
|
|
* along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
|
||
|
|
*
|
||
|
|
* @package OpenEMR
|
||
|
|
* @author Jan Jajalla <jansta23@gmail.com>
|
||
|
|
* @link https://www.open-emr.org
|
||
|
|
*/
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Return listing of immunizations for a patient.
|
||
|
|
*
|
||
|
|
* @param string $pid person id
|
||
|
|
* @param string $sortby sorting field ('vacc' sorts by name, otherwise will sort by date)
|
||
|
|
* @param boolean $showError indicator whether to retrieve the records that were added erroneously
|
||
|
|
* @return recordset listing of immunizations for a patient
|
||
|
|
*/
|
||
|
|
function getImmunizationList($pid, $sortby, $showError)
|
||
|
|
{
|
||
|
|
$sql = "select i1.id ,i1.immunization_id, i1.cvx_code, i1.administered_date, c.code_text_short, c.code" .
|
||
|
|
",i1.manufacturer ,i1.lot_number, i1.completion_status " .
|
||
|
|
",ifnull(concat(u.lname,', ',u.fname),'Other') as administered_by " .
|
||
|
|
",i1.education_date ,i1.note " . ",i1.expiration_date " .
|
||
|
|
",i1.amount_administered, i1.amount_administered_unit, i1.route, i1.administration_site, i1.added_erroneously" .
|
||
|
|
" from immunizations i1 " .
|
||
|
|
" left join users u on i1.administered_by_id = u.id " .
|
||
|
|
" left join code_types ct on ct.ct_key = 'CVX' " .
|
||
|
|
" left join codes c on c.code_type = ct.ct_id AND i1.cvx_code = c.code " .
|
||
|
|
" where i1.patient_id = ? ";
|
||
|
|
if (!$showError) {
|
||
|
|
$sql .= "and i1.added_erroneously = 0 ";
|
||
|
|
}
|
||
|
|
|
||
|
|
$sql .= " order by ";
|
||
|
|
|
||
|
|
if ($sortby == "vacc") {
|
||
|
|
$sql .= " c.code_text_short, i1.immunization_id, i1.administered_date DESC";
|
||
|
|
} else {
|
||
|
|
$sql .= " administered_date desc";
|
||
|
|
}
|
||
|
|
|
||
|
|
$results = sqlStatement($sql, array($pid));
|
||
|
|
return $results;
|
||
|
|
}
|