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>
