function DisplayArchivedBillHeadlines($no) { global $db; $enc_obj = new Encounter(); $this->debug = FALSE; $this->debug ? $db->debug = TRUE : ($db->debug = FALSE); if ($this->debug) { echo "<br><b>class_tz_billing::DisplayArchivedBillHeadlines</b><br>"; } $this->sql_pid = "SELECT `pid` FROM care_person where selian_pid like '%{$no}%' OR name_first like '%{$no}%' OR name_last like '%{$no}%' "; $this->request_pid = $db->Execute($this->sql_pid); $color_change = FALSE; while ($this->res_pid = $this->request_pid->FetchRow()) { $pid = $this->res_pid['pid']; $this->sql_enr = "SELECT `encounter_nr` FROM care_encounter where pid= '{$pid}' "; $this->request_enr = $db->Execute($this->sql_enr); $color_change = FALSE; while ($this->res_enr = $this->request_enr->FetchRow()) { $enr = $this->res_enr['encounter_nr']; $this->sql = "SELECT `nr`, `encounter_nr`, `first_date` FROM care_tz_billing_archive where encounter_nr='{$enr}' order by nr DESC"; $this->request = $db->Execute($this->sql); $color_change = FALSE; while ($this->res = $this->request->FetchRow()) { if ($color_change) { $BGCOLOR = 'bgcolor="#ffffdd"'; $color_change = FALSE; } else { $BGCOLOR = 'bgcolor="#ffffaa"'; $color_change = TRUE; } //$encoded_batch_number = $enc_obj->ShowPID($batch_nr); $enc_number = $enc_obj->GetEncounterFromBatchNumber($batch_nr); $this->bill_number = $this->res['nr']; $this->encounter_number = $this->res['encounter_nr']; $this->batch_number = $enc_obj->GetBatchFromEncounterNumber($this->encounter_number); $this->date = $this->res['first_date']; $enc_data = $enc_obj->loadEncounterData($this->encounter_number); echo '<script language="javascript" > <!-- function printOut_' . $this->bill_number . '() { urlholder="show_bill.php?bill_number=' . $this->bill_number . '&batch_nr=' . $this->batch_number . '&printout=TRUE&show_archived_bill=TRUE"; testprintout=window.open(urlholder,"printout","width=800,height=600,menubar=no,resizable=yes,scrollbars=yes"); } // --> </script> '; echo '<tr> <td ' . $BGCOLOR . '><div align="center"><a href="javascript:printOut_' . $this->bill_number . '()">' . $this->bill_number . '</a></div></td> <td ' . $BGCOLOR . '><div align="center">' . date("d.m.Y", $this->date) . '</div></td> <td ' . $BGCOLOR . '><div align="center">' . $enc_obj->ShowPID($this->batch_number) . '</div></td> <td ' . $BGCOLOR . '><div align="center">' . $this->encounter_number . '</div></td> <td ' . $BGCOLOR . '><div align="center">' . $enc_obj->FirstName($enc_data) . ' ' . $enc_obj->LastName($enc_data) . ' </div></td> </tr> '; } } // } // }
function DisplayArchivedBillHeadline($bill_nr, $batch_nr) { global $LDBatchFileNr, $LDFileNo, $LDEncounterNr, $LDLastName, $LDFirstName, $LDBday, $LDSex, $LDBillNumber, $LDWard, $LDdepartment, $db; // Maybe optional parameter given to this funciton: Is it a print-out-page or not (For table resize) if (func_num_args() > 2) { $printout = func_get_arg(2); } $enc_obj = new Encounter(); $encoded_batch_number = $enc_obj->ShowPID($batch_nr); $enc_number = $enc_obj->GetEncounterFromBatchNumber($batch_nr); $bill_address = $enc_obj->GetHospitalAddress(); $bill_logo = $enc_obj->GetHospitalLogo(); $bill_name = $enc_obj->GetHospitalName(); $address_line = explode(",", $bill_address); $hosp_name = $address_line[0]; $hosp_address = $address_line[1]; $hosp_address_city = $address_line[2]; $bill_date_sql = "SELECT FROM_UNIXTIME(date_change) AS tarehe FROM care_tz_billing_archive_elem WHERE nr=" . $bill_nr; $bill_date_result = $db->Execute($bill_date_sql); if ($bill_date_row = $bill_date_result->FetchRow()) { $bill_date_archived = $bill_date_row['tarehe']; } if ($enc_obj->EncounterExists($enc_number)) { // Load the encounter data: $enc_data = $enc_obj->loadEncounterData($enc_number); $file_no = $enc_obj->SelianPID($enc_number); echo $printout ? '<table width="100%" border="0" cellspacing=0 cellpadding=0 align="center" >' : '<table width="100%" border="0" cellspacing=1 cellpadding=0 >'; echo '<tr><td align="center">' . $hosp_name . '<br>' . $hosp_address . '<br>' . $hosp_address_city . '</td></tr> <tr><td align="right"><img src="../../' . $bill_logo . '" border=0 align="absmiddle" alt=""></td></tr></table>'; echo $printout ? '<table width="100%" border="0" cellspacing=0 cellpadding=0 >' : '<table width="100%" border="0" cellspacing=1 cellpadding=0 >'; echo ' <tr><td></td></tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3"><b>' . $LDBatchFileNr . '</b></font></span></span></td> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">' . $encoded_batch_number . '</font></span></span></b></td> </tr> <tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">Admission-Nr.:</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="3">' . $enc_number . '</font></span></span></b></td> </tr> <tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">File No.:</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="3">' . $file_no . '</font></span></span></b></td> </tr> <tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">Names:</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="3">' . $enc_obj->LastName($enc_number) . ', ' . $enc_obj->FirstName($enc_number) . '</font></span></span></b></td> </tr>'; /* if ($enc_data['in_dept']==0) echo '<tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="4">'.$LDWard.'</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="4">'.$enc_obj->CurrentWardName($enc_number).'</font></span></span></b></td> </tr>'; else echo '<tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="4">'.$LDdepartment.'</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="4">'.$enc_obj->CurrentDeptName($enc_number).'</font></span></span></b></td> </tr>'; */ /* <tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="4">First name:</font></span></span></td> <td bgcolor="#ffffee" class="vi_data"><span style="font-family:"20 cpi""><font size="4">'.$enc_obj->FirstName($enc_number).'</font></span></span></td> </tr> */ echo '<tr> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">RECEIPT DATE</font></span></span></td> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">' . $bill_date_archived . '</font></span></span></td> </tr> <tr> <td class="headline"><b><span class=SpellE><span style="font-family:"20 cpi""><font size="3">' . $LDBillNumber . '</font></span></span></b></td> <td class="headline"><span class=SpellE><span style="font-family:"20 cpi""><font size="3">' . $bill_nr . '</font></span></span></b></td> </tr> <tr> </table>'; return TRUE; } return FALSE; }
</td> <td> <?php echo '<font color="#000099"><b>' . $enc_obj->LastName() . '</b>'; ?> </td> </tr> <tr bgcolor="#ffffff"> <td><?php echo $LDName; ?> : </td> <td> <?php echo '<font color="#000099"><b>' . $enc_obj->FirstName() . '</b>'; ?> </td> </tr> <tr bgcolor="#ffffff"> <td><?php echo $LDBday; ?> : </td> <td> <?php echo '<font color="#000099">' . formatDate2Local($enc_obj->BirthDate(), $date_format); ?> </td> </tr>