EVOLUTION-MANAGER

Edit File: eRxXMLBuilder.php

<?php

/**
 * interface/eRxXMLBuilder.php Functions for building NewCrop XML.
 *
 * Copyright (C) 2015 Sam Likins <sam.likins@wsi-services.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
 * @subpackage NewCrop
 * @author     Sam Likins <sam.likins@wsi-services.com>
 * @link       http://www.open-emr.org
 */

class eRxXMLBuilder
{

private $globals;
    private $store;

private $document;
    private $ncScript;

private $sentAllergyIds = array();
    private $sentMedicationIds = array();
    private $sentPrescriptionIds = array();

private $fieldEmptyMessages = array();
    private $demographicsCheckMessages = array();
    private $warningMessages = array();

public function __construct($globals = null, $store = null)
    {
        if ($globals) {
            $this->setGlobals($globals);
        }

if ($store) {
            $this->setStore($store);
        }
    }

/**
     * Set Globals for retrieving eRx global configurations
     * @param  object  $globals The eRx Globals object to use for processing
     * @return eRxPage          This object is returned for method chaining
     */
    public function setGlobals($globals)
    {
        $this->globals = $globals;

return $this;
    }

/**
     * Get Globals for retrieving eRx global configurations
     * @return object The eRx Globals object to use for processing
     */
    public function getGlobals()
    {
        return $this->globals;
    }

/**
     * Set Store to handle eRx cashed data
     * @param  object  $store The eRx Store object to use for processing
     * @return eRxPage        This object is returned for method chaining
     */
    public function setStore($store)
    {
        $this->store = $store;

return $this;
    }

/**
     * Get Store for handling eRx cashed data
     * @return object The eRx Store object to use for processing
     */
    public function getStore()
    {
        return $this->store;
    }

protected function trimData($string, $length)
    {
        return substr($string, 0, $length - 1);
    }

protected function stripSpecialCharacter($string)
    {
        return preg_replace('/[^a-zA-Z0-9 \'().,#:\/\-@_%]/', '', $string);
    }

public function checkError($xml)
    {
        $curlHandler = curl_init($xml);
        $sitePath = $this->getGlobals()->getOpenEMRSiteDirectory();
        $data = array('RxInput' => $xml);

curl_setopt($curlHandler, CURLOPT_URL, $this->getGlobals()->getPath());
        curl_setopt($curlHandler, CURLOPT_POST, 1);
        curl_setopt($curlHandler, CURLOPT_POSTFIELDS, 'RxInput='.$xml);
        curl_setopt($curlHandler, CURLOPT_SSL_VERIFYPEER, 0);
        curl_setopt($curlHandler, CURLOPT_FOLLOWLOCATION, 1);
        curl_setopt($curlHandler, CURLOPT_COOKIESESSION, true);
        curl_setopt($curlHandler, CURLOPT_COOKIEFILE, $sitePath.'/newcrop-cookiefile');
        curl_setopt($curlHandler, CURLOPT_COOKIEJAR, $sitePath.'/newcrop-cookiefile');
        curl_setopt($curlHandler, CURLOPT_COOKIE, session_name().'='.session_id());
        curl_setopt($curlHandler, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)');
        curl_setopt($curlHandler, CURLOPT_RETURNTRANSFER, true);

$result = curl_exec($curlHandler) or die(curl_error($curlHandler));

curl_close($curlHandler);

return $result;
    }

public function addSentAllergyIds($allergyIds)
    {
        if (is_array($allergyIds)) {
            foreach ($allergyIds as $allergyId) {
                $this->sentAllergyIds[] = $allergyId;
            }
        } else {
            $this->sentAllergyIds[] = $allergyIds;
        }
    }

public function getSentAllergyIds()
    {
        return $this->sentAllergyIds;
    }

public function addSentMedicationIds($medicationIds)
    {
        if (is_array($medicationIds)) {
            foreach ($medicationIds as $medicationId) {
                $this->sentMedicationIds[] = $medicationId;
            }
        } else {
            $this->sentMedicationIds[] = $medicationIds;
        }
    }

public function getSentMedicationIds()
    {
        return $this->sentMedicationIds;
    }

public function addSentPrescriptionId($prescriptionIds)
    {
        if (is_array($prescriptionIds)) {
            foreach ($prescriptionIds as $prescriptionId) {
                $this->sentPrescriptionIds[] = $prescriptionId;
            }
        } else {
            $this->sentPrescriptionIds[] = $prescriptionIds;
        }
    }

public function getSentPrescriptionIds()
    {
        return $this->sentPrescriptionIds;
    }

public function fieldEmpty($value, $message)
    {
        if (empty($value)) {
            $this->fieldEmptyMessages[] = $message;
        }
    }

public function getFieldEmptyMessages()
    {
        return $this->fieldEmptyMessages;
    }

public function demographicsCheck($value, $message)
    {
        if (empty($value)) {
            $this->demographicsCheckMessages[] = $message;
        }
    }

public function getDemographicsCheckMessages()
    {
        return $this->demographicsCheckMessages;
    }

public function warningMessage($value, $message)
    {
        if (empty($value)) {
            $this->warningMessages[] = $message;
        }
    }

public function getWarningMessages()
    {
        return $this->warningMessages;
    }

public function createElementText($name, $value)
    {
        $element = $this->getDocument()->createElement($name);
        $element->appendChild($this->getDocument()->createTextNode($value));

return $element;
    }

public function createElementTextFieldEmpty($name, $value, $validationText)
    {
        $this->fieldEmpty($value, $validationText);

return $this->createElementText($name, $value);
    }

public function createElementTextDemographicsCheck($name, $value, $validationText)
    {
        $this->demographicsCheck($value, $validationText);

return $this->createElementText($name, $value);
    }

public function appendChildren($element, &$children)
    {
        if (is_a($element, 'DOMNode') && is_array($children) && count($children)) {
            foreach ($children as $child) {
                // if(is_array($child)) {
                // 	$this->appendChildren($element, $child);
                // }
                $element->appendChild($child);
            }
        }
    }

public function getDocument()
    {
        if ($this->document === null) {
            $this->document = new DOMDocument();
            $this->document->formatOutput = true;
        }

return $this->document;
    }

public function getNCScript()
    {
        if ($this->ncScript === null) {
            $document = $this->getDocument();

$this->ncScript = $document->createElement('NCScript');
            $this->ncScript->setAttribute('xmlns', 'http://secure.newcropaccounts.com/interfaceV7');
            $this->ncScript->setAttribute('xmlns:NCStandard', 'http://secure.newcropaccounts.com/interfaceV7:NCStandard');
            $this->ncScript->setAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');

$document->appendChild($this->ncScript);
        }

return $this->ncScript;
    }

public function getCredentials()
    {
        $eRxCredentials = $this->getGlobals()
            ->getCredentials();

$elemenet = $this->getDocument()->createElement('Credentials');
        $elemenet->appendChild($this->createElementTextFieldEmpty('partnerName', $eRxCredentials['0'], xl('NewCrop eRx Partner Name')));
        $elemenet->appendChild($this->createElementTextFieldEmpty('name', $eRxCredentials['1'], xl('NewCrop eRx Account Name')));
        $elemenet->appendChild($this->createElementTextFieldEmpty('password', $eRxCredentials['2'], xl('NewCrop eRx Password')));
        $elemenet->appendChild($this->createElementText('productName', 'OpenEMR'));
        $elemenet->appendChild($this->createElementText('productVersion', $this->getGlobals()->getOpenEMRVersion()));

return $elemenet;
    }

public function getUserRole($authUserId)
    {
        $eRxUserRole = $this->getStore()
            ->getUserById($authUserId);

$eRxUserRole = $eRxUserRole['newcrop_user_role'];

$this->fieldEmpty($eRxUserRole, xl('NewCrop eRx User Role'));
        if (!$eRxUserRole) {
            echo xlt('Unauthorized access to ePrescription');
            die;
        }

$eRxUserRole = preg_replace('/erx/', '', $eRxUserRole);

switch ($eRxUserRole) {
            case 'admin':
            case 'manager':
            case 'nurse':
                $newCropUser = 'Staff';
                break;
            case 'doctor':
                $newCropUser = 'LicensedPrescriber';
                break;
            case 'supervisingDoctor':
                $newCropUser = 'SupervisingDoctor';
                break;
            case 'midlevelPrescriber':
                $newCropUser = 'MidlevelPrescriber';
                break;
            default:
                $newCropUser = '';
        }

$element = $this->getDocument()->createElement('UserRole');
        $element->appendChild($this->createElementTextFieldEmpty('user', $newCropUser, xl('NewCrop eRx User Role * invalid selection *')));
        $element->appendChild($this->createElementText('role', $eRxUserRole));

return $element;
    }

public function getDestination($authUserId, $page = null)
    {
        $eRxUserRole = $this->getStore()
            ->getUserById($authUserId);

$eRxUserRole = $eRxUserRole['newcrop_user_role'];

$eRxUserRole = preg_replace('/erx/', '', $eRxUserRole);

if (!$page) {
            if ($eRxUserRole == 'admin') {
                $page = 'admin';
            } elseif ($eRxUserRole == 'manager') {
                $page = 'manager';
            } else {
                $page = 'compose';
            }
        }

$element = $this->getDocument()->createElement('Destination');
        $element->appendChild($this->createElementText('requestedPage', $page));

return $element;
    }

public function getAccountAddress($facility)
    {
        $postalCode = preg_replace('/[^0-9]/', '', $facility['postal_code']);
        $postalCodePostfix = substr($postalCode, 5, 4);
        $postalCode = substr($postalCode, 0, 5);

if (strlen($postalCode) < 5) {
            $this->fieldEmpty('', xl('Primary Facility Zip Code'));
        }

$element = $this->getDocument()->createElement('AccountAddress');
        $element->appendChild($this->createElementTextFieldEmpty('address1', $this->trimData($this->stripSpecialCharacter($facility['street']), 35), xl('Primary Facility Street Address')));
        $element->appendChild($this->createElementTextFieldEmpty('city', $facility['city'], xl('Primary Facility City')));
        $element->appendChild($this->createElementTextFieldEmpty('state', $facility['state'], xl('Primary Facility State')));
        $element->appendChild($this->createElementText('zip', $postalCode));
        if (strlen($postalCodePostfix) == 4) {
            $element->appendChild($this->createElementText('zip4', $postalCodePostfix));
        }

$element->appendChild($this->createElementTextFieldEmpty('country', substr($facility['country_code'], 0, 2), xl('Primary Facility Country code')));

return $element;
    }

public function getAccount()
    {
        $facility = $this->getStore()
            ->getFacilityPrimary();

if (!$facility['federal_ein']) {
            echo xlt('Please select a Primary Business Entity facility with \'Tax ID\' as your facility Tax ID. If you are an individual practitioner, use your tax id. This is used for identifying you in the NewCrop system.');
            die;
        }

$element = $this->getDocument()->createElement('Account');
        $element->setAttribute('ID', $this->getGlobals()->getAccountId());
        $element->appendChild($this->createElementTextFieldEmpty('accountName', $this->trimData($this->stripSpecialCharacter($facility['name']), 35), xl('Facility Name')));
        $element->appendChild($this->createElementText('siteID', $facility['federal_ein'], 'Site ID'));
        $element->appendChild($this->getAccountAddress($facility));
        $element->appendChild($this->createElementTextFieldEmpty('accountPrimaryPhoneNumber', preg_replace('/[^0-9]/', '', $facility['phone']), xl('Facility Phone')));
        $element->appendChild($this->createElementTextFieldEmpty('accountPrimaryFaxNumber', preg_replace('/[^0-9]/', '', $facility['fax']), xl('Facility Fax')));

return $element;
    }

public function getLocationAddress($facility)
    {
        $postalCode = preg_replace('/[^0-9]/', '', $facility['postal_code']);
        $postalCodePostfix = substr($postalCode, 5, 4);
        $postalCode = substr($postalCode, 0, 5);

if (strlen($postalCode) < 5) {
            $this->fieldEmpty('', xl('Facility Zip Code'));
        }

$element = $this->getDocument()->createElement('LocationAddress');
        if ($facility['street']) {
            $element->appendChild($this->createElementText('address1', $this->trimData($this->stripSpecialCharacter($facility['street']), 35)));
        }

if ($facility['city']) {
            $element->appendChild($this->createElementText('city', $facility['city']));
        }

if ($facility['state']) {
            $element->appendChild($this->createElementText('state', $facility['state']));
        }

$element->appendChild($this->createElementText('zip', $postalCode));
        if (strlen($postalCodePostfix) == 4) {
            $element->appendChild($this->createElementText('zip4', $postalCodePostfix));
        }

if ($facility['country_code']) {
            $element->appendChild($this->createElementText('country', substr($facility['country_code'], 0, 2)));
        }

return $element;
    }

public function getLocation($authUserId)
    {
        $userFacility = $this->getStore()
            ->getUserFacility($authUserId);

$element = $this->getDocument()->createElement('Location');
        $element->setAttribute('ID', $userFacility['id']);
        $element->appendChild($this->createElementText('locationName', $this->trimData($this->stripSpecialCharacter($userFacility['name']), 35)));
        $element->appendChild($this->getLocationAddress($userFacility));
        if ($userFacility['phone']) {
            $element->appendChild($this->createElementText('primaryPhoneNumber', preg_replace('/[^0-9]/', '', $userFacility['phone'])));
        }

if ($userFacility['fax']) {
            $element->appendChild($this->createElementText('primaryFaxNumber', preg_replace('/[^0-9]/', '', $userFacility['fax'])));
        }

if ($userFacility['phone']) {
            $element->appendChild($this->createElementText('pharmacyContactNumber', preg_replace('/[^0-9]/', '', $userFacility['phone'])));
        }

return $element;
    }

public function getLicensedPrescriber($authUserId)
    {
        $userDetails = $this->getStore()
            ->getUserById($authUserId);

$element = $this->getDocument()->createElement('LicensedPrescriber');
        $element->setAttribute('ID', $userDetails['npi']);
        $element->appendChild($this->getLicensedPrescriberName($userDetails));
        $element->appendChild($this->createElementTextFieldEmpty('dea', $userDetails['federaldrugid'], 'Licensed Prescriber DEA'));
        if ($userDetails['upin']) {
            $element->appendChild($this->createElementText('upin', $userDetails['upin']));
        }

$element->appendChild($this->createElementText('licenseNumber', $userDetails['state_license_number']));
        $element->appendChild($this->createElementTextFieldEmpty('npi', $userDetails['npi'], xl('Licensed Prescriber NPI')));

return $element;
    }

public function getStaffName($user)
    {
        $element = $this->getDocument()->createElement('StaffName');
        $element->appendChild($this->createElementText('last', $this->stripSpecialCharacter($user['lname'])));
        $element->appendChild($this->createElementText('first', $this->stripSpecialCharacter($user['fname'])));
        $element->appendChild($this->createElementText('middle', $this->stripSpecialCharacter($user['mname'])));

return $element;
    }

public function getStaff($authUserId)
    {
        $userDetails = $this->getStore()
            ->getUserById($authUserId);

$element = $this->getDocument()->createElement('Staff');
        $element->setAttribute('ID', $userDetails['username']);
        $element->appendChild($this->getStaffName($userDetails));
        $element->appendChild($this->createElementText('license', $userDetails['state_license_number']));

return $element;
    }

public function getLicensedPrescriberName($user, $prescriberType, $prefix = false)
    {
        $element = $this->getDocument()->createElement('LicensedPrescriberName');
        $element->appendChild($this->createElementTextFieldEmpty('last', $this->stripSpecialCharacter($user['lname']), $prescriberType.' '.xl('Licensed Prescriber Last Name')));
        $element->appendChild($this->createElementTextFieldEmpty('first', $this->stripSpecialCharacter($user['fname']), $prescriberType.' '.xl('Licensed Prescriber First Name')));
        $element->appendChild($this->createElementText('middle', $this->stripSpecialCharacter($user['mname'])));
        if ($prefix && $user['title']) {
            $element->appendChild($this->createElementTextFieldEmpty('prefix', $user['title'], $prescriberType.' '.xl('Licensed Prescriber Title (Prefix)')));
        }

return $element;
    }

public function getSupervisingDoctor($authUserId)
    {
        $userDetails = $this->getStore()
            ->getUserById($authUserId);

$element = $this->getDocument()->createElement('SupervisingDoctor');
        $element->setAttribute('ID', $userDetails['npi']);
        $element->appendChild($this->getLicensedPrescriberName($userDetails, xl('Supervising Doctor')));
        $element->appendChild($this->createElementTextFieldEmpty('dea', $userDetails['federaldrugid'], xl('Supervising Doctor DEA')));
        if ($userDetails['upin']) {
            $element->appendChild($this->createElementText('upin', $userDetails['upin']));
        }

return $element;
    }

public function getMidlevelPrescriber($authUserId)
    {
        $userDetails = $this->getStore()
            ->getUserById($authUserId);

$element = $this->getDocument()->createElement('MidlevelPrescriber');
        $element->setAttribute('ID', $userDetails['npi']);
        $element->appendChild($this->getLicensedPrescriberName($userDetails, xl('Midlevel Prescriber'), true));
        $element->appendChild($this->createElementTextFieldEmpty('dea', $userDetails['federaldrugid'], xl('Midlevel Prescriber DEA')));
        if ($userDetails['upin']) {
            $element->appendChild($this->createElementText('upin', $userDetails['upin']));
        }

$element->appendChild($this->createElementText('licenseNumber', $userDetails['state_license_number']));

return $element;
    }

public function getStaffElements($authUserId, $destination)
    {
        $userRole = $this->getStore()->getUserById($authUserId);
        $userRole = preg_replace('/erx/', '', $userRole['newcrop_user_role']);

$elements = array();

if ($userRole != 'manager') {
            $elements[] = $this->getLocation($authUserId);
        }

if ($userRole == 'doctor' || $destination == 'renewal') {
            $elements[] = $this->getLicensedPrescriber($authUserId);
        }

if ($userRole == 'manager' || $userRole == 'admin' || $userRole == 'nurse') {
            $elements[] = $this->getStaff($authUserId);
        } elseif ($userRole == 'supervisingDoctor') {
            $elements[] = $this->getSupervisingDoctor($authUserId);
        } elseif ($userRole == 'midlevelPrescriber') {
            $elements[] = $this->getMidlevelPrescriber($authUserId);
        }

return $elements;
    }

public function getPatientName($patient)
    {
        $element = $this->getDocument()->createElement('PatientName');
        $element->appendChild($this->createElementTextDemographicsCheck('last', $this->trimData($this->stripSpecialCharacter($patient['lname']), 35), xl('Patient Last Name')));
        $element->appendChild($this->createElementTextDemographicsCheck('first', $this->trimData($this->stripSpecialCharacter($patient['fname']), 35), xl('Patient First Name')));
        $element->appendChild($this->createElementText('middle', $this->trimData($this->stripSpecialCharacter($patient['mname']), 35)));

return $element;
    }

public function getPatientAddress($patient)
    {
        $patient['street'] = $this->trimData($this->stripSpecialCharacter($patient['street']), 35);
        $this->warningMessage($patient['street'], xl('Patient Street Address'));

if (trim($patient['country_code']) == '') {
            $eRxDefaultPatientCountry = $this->getGlobals()->getDefaultPatientCountry();

if ($eRxDefaultPatientCountry == '') {
                $this->demographicsCheck('', xl('Global Default Patient Country'));
            } else {
                $patient['country_code'] = $eRxDefaultPatientCountry;
            }

$this->demographicsCheck('', xl('Patient Country'));
        }

$element = $this->getDocument()->createElement('PatientAddress');
        $element->appendChild($this->createElementTextFieldEmpty('address1', $patient['street'], xl('Patient Street Address')));
        $element->appendChild($this->createElementTextDemographicsCheck('city', $patient['city'], xl('Patient City')));
        if ($patient['state']) {
            $element->appendChild($this->createElementText('state', $patient['state']));
        }

if ($patient['postal_code']) {
            $element->appendChild($this->createElementText('zip', $patient['postal_code']));
        }

$element->appendChild($this->createElementText('country', substr($patient['country_code'], 0, 2)));

return $element;
    }

public function getPatientContact($patient)
    {
        $element = $this->getDocument()->createElement('PatientContact');
        if ($patient['phone_home']) {
            $element->appendChild($this->createElementText('homeTelephone', preg_replace('/-/', '', $patient['phone_home'])));
        }

return $element;
    }

public function getPatientCharacteristics($patient)
    {
        if (trim($patient['date_of_birth']) == '' || $patient['date_of_birth'] == '00000000') {
            $this->warningMessage('', xl('Patient Date Of Birth'));
        }

$this->warningMessage(trim($patient['sex']), xl('Patient Gender'));

$element = $this->getDocument()->createElement('PatientCharacteristics');
        if ($patient['date_of_birth'] && $patient['date_of_birth'] != '00000000') {
            $element->appendChild($this->createElementText('dob', $patient['date_of_birth']));
        }

if ($patient['sex']) {
            $element->appendChild($this->createElementText('gender', substr($patient['sex'], 0, 1)));
        }

return $element;
    }

public function getPatientFreeformHealthplans($patientId)
    {
        $healthplans = $this->getStore()
            ->getPatientHealthplansByPatientId($patientId);

$elements = array();

while ($healthplan = sqlFetchArray($healthplans)) {
            $element = $this->getDocument()->createElement('PatientFreeformHealthplans');
            $element->appendChild($this->createElementText('healthplanName', $this->trimData($this->stripSpecialCharacter($healthplan['name'], 35))));

$elements[] = $element;
        }

return $elements;
    }

public function getPatientFreeformAllergy($patientId)
    {
        $allergyData = $this->getStore()
            ->getPatientAllergiesByPatientId($patientId);

$elements = array();

while ($allergy = sqlFetchArray($allergyData)) {
            $element = $this->getDocument()->createElement('PatientFreeformAllergy');
            $element->setAttribute('ID', $allergy['id']);

if ($allergy['title1']) {
                $element->appendChild($this->createElementText('allergyName', $this->trimData($this->stripSpecialCharacter($allergy['title1']), 70)));
            }

if ($allergy['title2']=='Mild' || $allergy['title2']=='Moderate' || $allergy['title2']=='Severe') {
                $element->appendChild($this->createElementText('allergySeverityTypeID', $allergy['title2']));
            }

if ($allergy['comments']) {
                $element->appendChild($this->createElementText('allergyComment', $this->trimData($this->stripSpecialCharacter($allergy['comments']), 200)));
            }

$elements[] = $element;

$this->addSentAllergyIds($allergy['id']);
        }

return $elements;
    }

public function getPatient($patientId)
    {
        $patientData = $this->getStore()
            ->getPatientByPatientId($patientId);

$element = $this->getDocument()->createElement('Patient');
        $element->setAttribute('ID', $patientData['pid']);
        $element->appendChild($this->getPatientName($patientData));
        $element->appendChild($this->getPatientAddress($patientData));
        $element->appendChild($this->getPatientContact($patientData));
        $element->appendChild($this->getPatientCharacteristics($patientData));
        $this->appendChildren($element, $this->getPatientFreeformHealthplans($patientId));
        $this->appendChildren($element, $this->getPatientFreeformAllergy($patientId));

return $element;
    }

public function getOutsidePrescription($prescription)
    {
        $element = $this->getDocument()->createElement('OutsidePrescription');
        $element->appendChild($this->createElementText('externalId', $prescription['externalId']));
        $element->appendChild($this->createElementText('date', $prescription['date']));
        $element->appendChild($this->createElementText('doctorName', $prescription['doctorName']));
        $element->appendChild($this->createElementText('drug', $prescription['drug']));
        $element->appendChild($this->createElementText('dispenseNumber', $prescription['dispenseNumber']));
        $element->appendChild($this->createElementText('sig', $prescription['sig']));
        $element->appendChild($this->createElementText('refillCount', $prescription['refillCount']));
        $element->appendChild($this->createElementText('prescriptionType', $prescription['prescriptionType']));

return $element;
    }

public function getPatientPrescriptions($prescriptionIds)
    {
        $elements = array();

foreach ($prescriptionIds as $prescriptionId) {
            if ($prescriptionId) {
                $prescription = $this->getStore()
                    ->getPrescriptionById($prescriptionId);

$element = $this->getOutsidePrescription(array(
                    'externalId'        => $prescription['prescid'],
                    'date'              => $prescription['date_added'],
                    'doctorName'        => $prescription['docname'],
                    'drug'              => $this->trimData($this->stripSpecialCharacter($prescription['drug']), 80),
                    'dispenseNumber'    => intval($prescription['quantity']),
                    'sig'               => $this->trimData($this->stripSpecialCharacter($prescription['quantity'][1].$prescription['size'].' '.$prescription['title4'].' '.$prescription['dosage'].' In '.$prescription['title1'].' '.$prescription['title2'].' '.$prescription['title3'], 140)),
                    'refillCount'       => intval($prescription['per_refill']),
                    'prescriptionType'  => 'reconcile'
                ));

$this->addSentPrescriptionId($prescriptionId);

$elements[] = $element;
            }
        }

return $elements;
    }

public function getPatientMedication($patientId, $uploadActive, $count)
    {
        $medications = $this->getStore()
            ->selectMedicationsNotUploadedByPatientId($patientId, $uploadActive, $count);

$elements = array();

while ($medication = sqlFetchArray($medications)) {
            $elements[] = $this->getOutsidePrescription(array(
                'externalId'        => $medication['id'],
                'date'              => $medication['begdate'],
                'doctorName'        => '',
                'drug'              => $this->trimData($medication['title'], 80),
                'dispenseNumber'    => '',
                'sig'               => '',
                'refillCount'       => '',
                'prescriptionType'  => 'reconcile'
            ));

$this->addSentMedicationIds($medication['id']);
        }

return $elements;
    }

public function getPatientElements($patientId, $totalCount, $requestedPrescriptionIds)
    {
        $elements = array();

if ($patientId) {
            $uploadActive = $this->getGlobals()->getUploadActive();

$elements[] = $this->getPatient($patientId);

$selectPrescriptionIds = $this->getStore()
                ->selectPrescriptionIdsNotUploadedByPatientId(
                    $patientId,
                    $uploadActive,
                    $totalCount
                );

$selectPrescriptionIdsCount = sqlNumRows($selectPrescriptionIds);

$prescriptionIds = array();

while ($selectPrescriptionId = sqlFetchArray($selectPrescriptionIds)) {
                $prescriptionIds[] = $selectPrescriptionId['id'];
            }

if (count($requestedPrescriptionIds) > 0) {
                $elements = array_merge($elements, $this->getPatientPrescriptions($requestedPrescriptionIds));
            } elseif (count($prescriptionIds) > 0) {
                $elements = array_merge($elements, $this->getPatientPrescriptions($prescriptionIds));
            } else {
                $this->getPatientPrescriptions(array(0));
            }

if ($selectPrescriptionIdsCount < $totalCount) {
                $elements = array_merge($elements, $this->getPatientMedication($patientId, $uploadActive, $totalCount - $selectPrescriptionIdsCount));
            }
        }

return $elements;
    }
}