function Patient($doc, $r, $pid) { global $msg; $patient_data = sqlQuery("select *, DATE_FORMAT(DOB,'%Y%m%d') AS date_of_birth from patient_data where pid=?", array($pid)); $b = $doc->createElement("Patient"); $b->setAttribute('ID', $patient_data['pid']); $PatientName = $doc->createElement("PatientName"); $patient_data['lname'] = stripSpecialCharacter($patient_data['lname']); $patient_data['lname'] = trimData($patient_data['lname'], 35); $msg = validation(xl('Patient Last name'), $patient_data['lname'], $msg); $last = $doc->createElement("last"); $last->appendChild($doc->createTextNode($patient_data['lname'])); $PatientName->appendChild($last); $patient_data['fname'] = stripSpecialCharacter($patient_data['fname']); $patient_data['fname'] = trimData($patient_data['fname'], 35); $msg = validation(xl('Patient First name'), $patient_data['fname'], $msg); $first = $doc->createElement("first"); $first->appendChild($doc->createTextNode($patient_data['fname'])); $PatientName->appendChild($first); $patient_data['mname'] = stripSpecialCharacter($patient_data['mname']); $patient_data['mname'] = trimData($patient_data['mname'], 35); $middle = $doc->createElement("middle"); $middle->appendChild($doc->createTextNode($patient_data['mname'])); $PatientName->appendChild($middle); $b->appendChild($PatientName); $PatientAddress = $doc->createElement("PatientAddress"); $patient_data['street'] = stripSpecialCharacter($patient_data['street']); $patient_data['street'] = trimData($patient_data['street'], 35); $address1 = $doc->createElement("address1"); $address1->appendChild($doc->createTextNode($patient_data['street'])); $PatientAddress->appendChild($address1); $msg = validation(xl('Patient City'), $patient_data['city'], $msg); $city = $doc->createElement("city"); $city->appendChild($doc->createTextNode($patient_data['city'])); $PatientAddress->appendChild($city); $msg = validation(xl('Patient State'), $patient_data['state'], $msg); $state = $doc->createElement("state"); $state->appendChild($doc->createTextNode($patient_data['state'])); $PatientAddress->appendChild($state); $msg = validation(xl('Patient Zip'), $patient_data['postal_code'], $msg); $zip = $doc->createElement("zip"); $zip->appendChild($doc->createTextNode($patient_data['postal_code'])); $PatientAddress->appendChild($zip); $msg = validation(xl('Patient Country'), $patient_data['country_code'], $msg); $county_code = substr($patient_data['country_code'], 0, 2); $country = $doc->createElement("country"); $country->appendChild($doc->createTextNode($county_code)); $PatientAddress->appendChild($country); $b->appendChild($PatientAddress); $PatientContact = $doc->createElement("PatientContact"); $patient_data['phone_home'] = stripPhoneSlashes($patient_data['phone_home']); $msg = validation(xl('Patient Home phone'), $patient_data['phone_home'], $msg); $homeTelephone = $doc->createElement("homeTelephone"); $homeTelephone->appendChild($doc->createTextNode($patient_data['phone_home'])); $PatientContact->appendChild($homeTelephone); $b->appendChild($PatientContact); $PatientCharacteristics = $doc->createElement("PatientCharacteristics"); $msg = validation(xl('Patient DOB'), $patient_data['date_of_birth'], $msg); $dob = $doc->createElement("dob"); $dob->appendChild($doc->createTextNode($patient_data['date_of_birth'])); $PatientCharacteristics->appendChild($dob); $msg = validation(xl('Patient Gender'), $patient_data['sex'], $msg); $gender_val = substr($patient_data['sex'], 0, 1); $gender = $doc->createElement("gender"); $gender->appendChild($doc->createTextNode($gender_val)); $PatientCharacteristics->appendChild($gender); $b->appendChild($PatientCharacteristics); PatientFreeformHealthplans($doc, $b, $pid); PatientFreeformAllergy($doc, $b, $pid); $r->appendChild($b); }
function PatientFreeformHealthplans($doc, $r, $pid) { $resource = sqlStatement('SELECT `ins`.`name` FROM ( SELECT `id`.`type`, `ic`.`name` FROM `insurance_data` AS `id` LEFT JOIN `insurance_companies` AS `ic` ON `ic`.`id` = `id`.`provider` WHERE `id`.`pid` = ? AND `id`.`subscriber_relationship` = \'self\' AND `id`.`provider` > 0 ORDER BY `id`.`date` DESC ) AS `ins` GROUP BY `ins`.`type`;', array($pid)); while ($row = sqlFetchArray($resource)) { $healthplanName = $doc->createElement('healthplanName'); $healthplanName->appendChild($doc->createTextNode(stripSpecialCharacter(trimData($row['name'], 35)))); $patientFreeformHealthplans = $doc->createElement('PatientFreeformHealthplans'); $patientFreeformHealthplans->appendChild($healthplanName); $r->appendChild($patientFreeformHealthplans); } }
function PatientFreeformHealthplans($doc, $r, $pid) { $res = sqlStatement("SELECT `name`,`type` FROM insurance_companies AS ic, insurance_data AS id\n WHERE ic.id=id.provider AND id.pid=?", array($pid)); while ($row = sqlFetchArray($res)) { $b = $doc->createElement("PatientFreeformHealthplans"); $allergyName = $doc->createElement("healthplanName"); $allergyName->appendChild($doc->createTextNode(stripSpecialCharacter(trimData($row['name'], 35)))); $b->appendChild($allergyName); $r->appendChild($b); } }