Revision: 6446
http://care2002.svn.sourceforge.net/care2002/?rev=6446&view=rev
Author: mizuko
Date: 2010-06-30 09:34:14 +0000 (Wed, 30 Jun 2010)
Log Message:
-----------
see #54
Added Paths:
-----------
care2x/branches/gettext/modules/nursing/nursing-patient-search-start.php
Removed Paths:
-------------
care2x/branches/gettext/modules/nursing/nursing-patient-such-start.php
Copied:
care2x/branches/gettext/modules/nursing/nursing-patient-search-start.php (from
rev 6445,
care2x/branches/gettext/modules/nursing/nursing-patient-such-start.php)
===================================================================
--- care2x/branches/gettext/modules/nursing/nursing-patient-search-start.php
(rev 0)
+++ care2x/branches/gettext/modules/nursing/nursing-patient-search-start.php
2010-06-30 09:34:14 UTC (rev 6446)
@@ -0,0 +1,491 @@
+<?php
+error_reporting(E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR);
+require('./roots.php');
+require($root_path.'include/helpers/inc_environment_global.php');
+/**
+* CARE2X Integrated Hospital Information System Deployment 2.1 - 2004-10-02
+* GNU General Public License
+* Copyright 2002,2003,2004,2005 Elpidio Latorilla
+* [email protected],
+*
+* See the file "copy_notice.txt" for the licence notice
+*/
+///$db->debug=1;
+$lang_tables[]='search.php';
+define('LANG_FILE','nursing.php');
+define('NO_2LEVEL_CHK',1);
+require_once($root_path.'include/helpers/inc_front_chain_lang.php');
+
+$breakfile='nursing.php'.URL_APPEND;
+
+/* Load the date formatter */
+require_once($root_path.'include/helpers/inc_date_format_functions.php');
+include_once($root_path.'include/core/class_globalconfig.php');
+$GLOBAL_CONFIG;
+$glob_obj=new GlobalConfig($GLOBAL_CONFIG);
+$glob_obj->getConfig('patient_%');
+
+if($mode=='such'||$mode=='paginate')
+{
+ $tb_person='care_person';
+ $tb_encounter='care_encounter';
+ $tb_location='care_encounter_location';
+ $tb_ward='care_ward';
+
+ # Initialize page's control variables
+ if($mode=='paginate'){
+ $searchkey=$_SESSION['sess_searchkey'];
+ }else{
+ # Reset paginator variables
+ $pgx=0;
+ $totalcount=0;
+ $_SESSION['sess_searchkey']=$searchkey;
+ $oitem='';
+ $odir='';
+ }
+
+ # convert * and ? to % and &
+ $searchkey=strtr($searchkey,'*?','%_');
+
+ #Load and create paginator object
+ include_once($root_path.'include/core/class_paginator.php');
+ $pagen=new
Paginator($pgx,$thisfile,$_SESSION['sess_searchkey'],$root_path);
+
+ $GLOBAL_CONFIG=array();
+ include_once($root_path.'include/core/class_globalconfig.php');
+ $glob_obj=new GlobalConfig($GLOBAL_CONFIG);
+
+ # Get the max nr of rows from global config
+ $glob_obj->getConfig('pagin_patient_search_max_block_rows');
+ if(empty($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']))
$pagen->setMaxCount(MAX_BLOCK_ROWS); # Last resort, use the default defined at
the start of this page
+ else
$pagen->setMaxCount($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']);
+
+ # Work around
+ //$searchkey=$searchkey;
+ $srcword=trim($searchkey);
+ //prepare the seach word detect several types
+ if(is_numeric($srcword)){
+ $usenum=true;
+
+ if($srcword>$GLOBAL_CONFIG['patient_inpatient_nr_adder']){
+ $cond.="e.encounter_nr $sql_LIKE
'%".(int)substr($srcword,2)."'"; // set the offset here
+ }else{
+ $cond.="e.encounter_nr $sql_LIKE '%".(int)$srcword."'";
+ }
+ }else{
+ $usenum=false;
+ $buf=strtr($srcword,","," ");//echo $buf;
+ $wx=explode(' ',$buf); // explode to array
+ $cond='';
+ for($i=0;$i<sizeof($wx);$i++){
+ if(!empty($cond)){
+ $cond.=' OR ';
+ }
+ $cond.="p.name_last $sql_LIKE '".$wx[$i]."%' OR
p.name_first $sql_LIKE '".$wx[$i]."%' OR p.date_birth $sql_LIKE '".$wx[$i]."%'";
+ }
+ $cond="($cond)";
+
+ }
+
+ $cond.=" AND l.encounter_nr=e.encounter_nr";
+ //gjergji - hide patient info of other departements
+ if(isset($_SESSION['department_nr']) && $_SESSION['department_nr'] !=
'0' ) {
+ $cond.=" AND ( ";
+ while (list($key, $val) = each($_SESSION['department_nr'])) {
+ $tmp .= "w.dept_nr = " . $val . " OR ";
+
+ }
+ $cond .= substr($tmp,0,-4) ;
+ $cond .= " ) " ;
+ }
+ if(!$arch) $cond.=" AND e.is_discharged IN ('',0) AND p.pid=e.pid ";
+
+ $gbuf="l.location_nr,p.name_last, p.name_first,p.date_birth,
+ e.encounter_nr,
e.encounter_class_nr,e.in_ward,
+ w.name,w.roomprefix,
+ l.date_from,
+ r.location_nr";
+
+//if($usenum) $cond.=" GROUP BY $gbuf";
+ //else $cond.=" AND p.pid=e.pid GROUP BY $gbuf";
+// if($usenum) $cond.=' GROUP BY r.location_nr';
+// else $cond.=' AND p.pid=e.pid GROUP BY r.location_nr';
+
+ //$db->debug=1;
+
+
if(!isset($db)||!$db)include($root_path.'include/helpers/inc_db_makelink.php');
+ if($dblink_ok){
+ $sqlselect="SELECT r.location_nr AS room_nr, p.name_last,
p.name_first,p.date_birth,
+ e.encounter_nr,
e.encounter_class_nr,e.in_ward,
+ w.name AS ward_name,w.roomprefix,
+ l.location_nr AS ward_nr,l.date_from
AS ward_date";
+
+ if($usenum){
+ $sqlfrom=" FROM $tb_encounter as e LEFT JOIN $tb_person
AS p ON p.pid=e.pid";
+ }else{
+ $sqlfrom=" FROM $tb_person as p LEFT JOIN $tb_encounter
AS e ON p.pid=e.pid";
+ }
+ $sqlfrom.=" LEFT JOIN $tb_location AS l ON
l.encounter_nr=e.encounter_nr AND l.type_nr=2
+ LEFT JOIN $tb_location AS r ON
r.encounter_nr=l.encounter_nr AND r.type_nr=4 AND r.group_nr=l.location_nr
+ LEFT JOIN $tb_ward AS w ON
w.nr=l.location_nr
+ WHERE $cond";
+
+ if(!empty($oitem)){
+
+ #Filter the sort item
+ switch($oitem){
+ case 'ward_nr':
+ {
+ $itembuf='location_nr';
+ $prep='l';
+ break;
+ }
+ case 'ward_date':
+ {
+ $itembuf='date_from';
+ $prep='l';
+ break;
+ }
+ case 'room_nr':
+ {
+ $itembuf='location_nr';
+ $prep='r';
+ break;
+ }
+ case 'encounter_nr':
+ {
+ $itembuf='encounter_nr';
+ $prep='e';
+ break;
+ }
+ default:
+ $itembuf=$oitem;
+ $prep='p';
+ }
+ $sql=$sqlselect.$sqlfrom." ORDER BY $prep.$itembuf
$odir";
+ }else{
+ $sql=$sqlselect.$sqlfrom;
+ }
+ //echo $sql."<p>mode==such";
+
+
if($ergebnis=$db->SelectLimit($sql,$pagen->MaxCount(),$pagen->BlockStartIndex())){
+ $rows=$ergebnis->RecordCount();
+/* if($rows==1){
+ $result=$ergebnis->FetchRow();
+
header("location:nursing-station.php?sid=$sid&lang=$lang&ward_nr=".$result['ward_nr']."&station=".$result['ward_name']);
+ exit;
+ }
+*/
+ $pagen->setTotalBlockCount($rows);
+
+ # If more than one count all available
+ if(isset($totalcount)&&$totalcount){
+
$pagen->setTotalDataCount($totalcount);
+ }else{
+ # Count total available data
+ $sql='SELECT e.encounter_nr
'.$sqlfrom;
+ //echo $sql;
+ $totalcount=0;
+ if($result=$db->Execute($sql)){
+
$totalcount=$result->RecordCount();
+ }
+
$pagen->setTotalDataCount($totalcount);
+ }
+ # Set the sort parameters
+ $pagen->setSortItem($oitem);
+ $pagen->setSortDirection($odir);
+
+ }else{echo "$sql<br>$LDDbNoRead";}
+ }else { echo "$LDDbNoLink<br>"; }
+}
+
+# Start Smarty templating here
+ /**
+ * LOAD Smarty
+ */
+
+ # Note: it is advisable to load this after the inc_front_chain_lang.php so
+ # that the smarty script can use the user configured template theme
+
+ require_once($root_path.'gui/smarty_template/smarty_care.class.php');
+ $smarty = new smarty_care('nursing');
+
+# Title in toolbar
+ $smarty->assign('sToolbarTitle', "$LDNursing - $LDSearchPatient");
+
+ # href for help button
+
$smarty->assign('pbHelp',"javascript:gethelp('nursing_how2search.php','$mode','$rows','search')");
+
+ # href for close button
+ $smarty->assign('breakfile',$breakfile);
+
+ # OnLoad Javascript code
+ $smarty->assign('sOnLoadJs','onLoad="if (window.focus) window.focus();
document.suchlogbuch.searchkey.select();"');
+
+ # Window bar title
+ $smarty->assign('title',"$LDNursing - $LDSearchPatient");
+
+ # Collect extra javascript code
+
+ ob_start();
+?>
+
+<script language="javascript">
+<!--
+var urlholder;
+
+ function gotoWard(ward_nr,st,y,m,d){
+<?php
+ if($cfg['dhtml'])
+ {
+ echo 'w=window.parent.screen.width; h=window.parent.screen.height;';
+ }
+ else echo 'w=800;
+ h=600;';
+?>
+ winspecs="menubar=no,resizable=yes,scrollbars=yes,width=" + (w-15) + ",
height=" + (h-60);
+
+ urlholder="nursing-station-pass.php?rt=pflege&sid=<?php echo
"$sid&lang=$lang";
?>&pday="+d+"&pmonth="+m+"&pyear="+y+"&edit=1&retpath=search_patient&ward_nr="+ward_nr+"&station="+st;
+ window.location.href=urlholder;
+}
+
+// -->
+</script>
+
+<?php
+
+$sTemp = ob_get_contents();
+
+ob_end_clean();
+
+$smarty->append('JavaScript',$sTemp);
+
+ob_start();
+
+?>
+
+<ul>
+
+<?php
+
+if($rows){
+
+?>
+ <table border=0>
+ <tr>
+ <td><img <?php echo
createMascot($root_path,'mascot1_r.gif','0','bottom') ?> align="absmiddle"></td>
+ <td class="prompt">
+ <?php echo "$LDSearchKeyword <font
color=#0000ff>\"$searchkey\"</font>
".str_replace("~rows~",$totalcount,$LDWasFound).' '.$LDShowing.'
'.$pagen->BlockStartNr().' '.$LDTo.' '.$pagen->BlockEndNr().'.'; ?> <br>
+ <?php echo $LDPlsClk ?>
+ </td>
+ </tr>
+ </table>
+
+ <table border=0 cellpadding=0 cellspacing=0>
+ <tr class="adm_item">
+
+<?php
+
+ $bgimg='tableHeaderbg3.gif';
+ //$bgimg='tableHeader_gr.gif';
+ $tbg=
'background="'.$root_path.'gui/img/common/'.$theme_com_icon.'/'.$bgimg.'"';
+
+ $append="&usenum=$usenum&arch=$arch";
+
+ if($usenum){
+
+?>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDAdm_Nr,'encounter_nr',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+<?php
+ }
+?>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDLastName,'name_last',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDName,'name_first',$oitem,$odir,$append);
+?> </b>
+ </td>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDBirthDate,'date_birth',$oitem,$odir,$append);
+ ?>
+ </b>
+ </td>
+
+<?php
+ if(!$usenum){
+?>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDAdm_Nr,'encounter_nr',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+<?php
+ }
+?>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDStation,'ward_nr',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDRoom,'room_nr',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+ <td><b>
+<?php
+ echo
$pagen->makeSortLink($LDDate,'ward_date',$oitem,$odir,$append);
+?>
+ </b>
+ </td>
+
+ <td><b> <?php echo $LDStatus ?></b></td>
+ </tr>
+
+<?php
+
+ $toggle=0;
+ while($result=$ergebnis->FetchRow()){
+
+/* if($result['encounter_class_nr']==2)
$full_enr=$result['encounter_nr']+$GLOBAL_CONFIG['patient_outpatient_nr_adder'];
+ else
$full_enr=$result['encounter_nr']+$GLOBAL_CONFIG['patient_inpatient_nr_adder'];
+*/
+ $full_enr=$result['encounter_nr'];
+ echo'
+ <tr ';
+ if($toggle){
+ echo "bgcolor=#efefef";
+ $toggle=0;
+ }else{
+ echo "bgcolor=#ffffff";
+ $toggle=1;
+ }
+
+ if($result['in_ward']) $result['ward_date']=date('Y-m-d');
+
+ list($pyear,$pmonth,$pday)=explode('-',$result['ward_date']);
+
+
//$buf="nursing-station.php".URL_APPEND."&station=".$result['ward_name']."&ward_nr=".$result['ward_nr'];
+
//$buf="nursing-station.php".URL_APPEND."&ward_nr=".$result['ward_nr']."&pyear=$pyear&pmonth=$pmonth&pday=$pday";
+
$buf="javascript:gotoWard('".$result['ward_nr']."','".addslashes($result['ward_name'])."','$pyear','$pmonth','$pday')";
+
+ echo '>';
+/* echo '
+ <td> <a href="'.$buf.'" title="'.$LDClk2Show.'">';
+ if($result['s_date'] <> (date('Y-m-d'))) echo '<img
'.createComIcon($root_path,'bul_arrowblusm.gif','0').'>';
+ else echo '<img
'.createComIcon($root_path,'r_arrowgrnsm.gif','0').'>';
+ echo'
+ </a></td>';
+*/ if($usenum){
+ echo '
+ <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$full_enr.'</a> </td>';
+ }
+ echo '
+ <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['name_last'].'</a> </td>
+ <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['name_first'].'</a> </td>
+ <td> '.formatDate2Local($result['date_birth'],$date_format).'</td>';
+ if(!$usenum){
+ echo '
+ <td> '.$full_enr.' </td>';
+ }
+
+ echo '
+ <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['ward_name'].'</a> </td>
+ <td> ';
+ if($result['room_nr']) echo $result['roomprefix'].'
'.$result['room_nr'];
+ echo ' </td>
+ <td> '.formatDate2Local($result['ward_date'],$date_format).'</td>
+ <td> ';
+ if($result['in_ward']) echo $LDInWard;
+ echo '</td>
+ </tr>
+ <tr bgcolor=#0000ff>
+ <td colspan=8 height=1><img
'.createComIcon($root_path,'pixel.gif','0','absmiddle').'></td>
+ </tr>';
+ }
+
+ echo '
+ <tr><td
colspan=7>'.$pagen->makePrevLink($LDPrevious,$append).'</td>
+ <td align=right>'.$pagen->makeNextLink($LDNext,$append).'</td>
+ </tr>';
+ ?>
+</table>
+<p>
+<hr>
+<?php
+}else{
+ if($mode=='such') echo str_replace('~nr~','0',$LDSearchFound);
+}
+?>
+
+<?php echo $LDSearchPrompt ?>
+
+<form action="nursing-patient-search-start.php" method="get"
name="suchlogbuch" >
+<table border=0 cellspacing=0 cellpadding=1 bgcolor="#999999">
+ <tr>
+ <td>
+ <table border=0 cellspacing=0 cellpadding=5
bgcolor="#eeeeee">
+ <tr>
+ <td class="prompt"><?php echo $LDSrcKeyword
?>:<br>
+ <input type="text" name="searchkey"
size=40 maxlength=100 value="<?php if ($srcword!='') echo $srcword; ?>">
+ <input type="hidden" name="sid"
value="<?php echo $sid; ?>">
+ <input type="hidden" name="lang"
value="<?php echo $lang; ?>">
+ <input type="hidden" name="mode"
value="such"><br>
+ <font size=2>
+ <input type="checkbox" name="arch"
value="1" <?php if($arch) echo "checked"; ?>> <?php echo $LDSearchArchive ?>
+ </font>
+ </td>
+ </tr>
+ <tr>
+ <td align=right>
+ <input type="submit" value="<?php echo
$LDSearch ?>" align="right">
+ </td>
+ </tr>
+ </table>
+ </td>
+ </tr>
+</table>
+</form>
+
+</ul>
+
+<p>
+<ul>
+
+<b><?php echo $LDMoreFunctions ?>:</b><br>
+<img <?php echo createComIcon($root_path,'varrow.gif','0') ?>> <a
href="nursing-station-archiv.php?sid=<?php echo "$sid&lang=$lang";?>&user=<?php
echo str_replace(" ","+",$user);?>"><?php echo $LDArchive ?></a><br>
+<img <?php echo createComIcon($root_path,'varrow.gif','0') ?>> <a
href="javascript:gethelp('nursing_how2search.php','<?php echo $mode ?>','<?php
echo $rows ?>','search')"><?php echo $LDHow2Search ?></a><br>
+
+<p>
+<a href="nursing.php<?php echo URL_APPEND; ?>"><img <?php echo
createLDImgSrc($root_path,'cancel.gif','0') ?> alt="<?php echo $LDCancel
?>"></a>
+</ul>
+
+<?php
+
+$sTemp = ob_get_contents();
+ob_end_clean();
+
+# Assign the page output to the mainframe center block
+
+ $smarty->assign('sMainFrameBlockData',$sTemp);
+
+ /**
+ * show Template
+ */
+ $smarty->display('common/mainframe.tpl');
+
+ ?>
\ No newline at end of file
Deleted: care2x/branches/gettext/modules/nursing/nursing-patient-such-start.php
===================================================================
--- care2x/branches/gettext/modules/nursing/nursing-patient-such-start.php
2010-06-30 09:33:50 UTC (rev 6445)
+++ care2x/branches/gettext/modules/nursing/nursing-patient-such-start.php
2010-06-30 09:34:14 UTC (rev 6446)
@@ -1,491 +0,0 @@
-<?php
-error_reporting(E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR);
-require('./roots.php');
-require($root_path.'include/helpers/inc_environment_global.php');
-/**
-* CARE2X Integrated Hospital Information System Deployment 2.1 - 2004-10-02
-* GNU General Public License
-* Copyright 2002,2003,2004,2005 Elpidio Latorilla
-* [email protected],
-*
-* See the file "copy_notice.txt" for the licence notice
-*/
-///$db->debug=1;
-$lang_tables[]='search.php';
-define('LANG_FILE','nursing.php');
-define('NO_2LEVEL_CHK',1);
-require_once($root_path.'include/helpers/inc_front_chain_lang.php');
-
-$breakfile='nursing.php'.URL_APPEND;
-
-/* Load the date formatter */
-require_once($root_path.'include/helpers/inc_date_format_functions.php');
-include_once($root_path.'include/core/class_globalconfig.php');
-$GLOBAL_CONFIG;
-$glob_obj=new GlobalConfig($GLOBAL_CONFIG);
-$glob_obj->getConfig('patient_%');
-
-if($mode=='such'||$mode=='paginate')
-{
- $tb_person='care_person';
- $tb_encounter='care_encounter';
- $tb_location='care_encounter_location';
- $tb_ward='care_ward';
-
- # Initialize page's control variables
- if($mode=='paginate'){
- $searchkey=$_SESSION['sess_searchkey'];
- }else{
- # Reset paginator variables
- $pgx=0;
- $totalcount=0;
- $_SESSION['sess_searchkey']=$searchkey;
- $oitem='';
- $odir='';
- }
-
- # convert * and ? to % and &
- $searchkey=strtr($searchkey,'*?','%_');
-
- #Load and create paginator object
- include_once($root_path.'include/core/class_paginator.php');
- $pagen=new
Paginator($pgx,$thisfile,$_SESSION['sess_searchkey'],$root_path);
-
- $GLOBAL_CONFIG=array();
- include_once($root_path.'include/core/class_globalconfig.php');
- $glob_obj=new GlobalConfig($GLOBAL_CONFIG);
-
- # Get the max nr of rows from global config
- $glob_obj->getConfig('pagin_patient_search_max_block_rows');
- if(empty($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']))
$pagen->setMaxCount(MAX_BLOCK_ROWS); # Last resort, use the default defined at
the start of this page
- else
$pagen->setMaxCount($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']);
-
- # Work around
- //$searchkey=$searchkey;
- $srcword=trim($searchkey);
- //prepare the seach word detect several types
- if(is_numeric($srcword)){
- $usenum=true;
-
- if($srcword>$GLOBAL_CONFIG['patient_inpatient_nr_adder']){
- $cond.="e.encounter_nr $sql_LIKE
'%".(int)substr($srcword,2)."'"; // set the offset here
- }else{
- $cond.="e.encounter_nr $sql_LIKE '%".(int)$srcword."'";
- }
- }else{
- $usenum=false;
- $buf=strtr($srcword,","," ");//echo $buf;
- $wx=explode(' ',$buf); // explode to array
- $cond='';
- for($i=0;$i<sizeof($wx);$i++){
- if(!empty($cond)){
- $cond.=' OR ';
- }
- $cond.="p.name_last $sql_LIKE '".$wx[$i]."%' OR
p.name_first $sql_LIKE '".$wx[$i]."%' OR p.date_birth $sql_LIKE '".$wx[$i]."%'";
- }
- $cond="($cond)";
-
- }
-
- $cond.=" AND l.encounter_nr=e.encounter_nr";
- //gjergji - hide patient info of other departements
- if(isset($_SESSION['department_nr']) && $_SESSION['department_nr'] !=
'0' ) {
- $cond.=" AND ( ";
- while (list($key, $val) = each($_SESSION['department_nr'])) {
- $tmp .= "w.dept_nr = " . $val . " OR ";
-
- }
- $cond .= substr($tmp,0,-4) ;
- $cond .= " ) " ;
- }
- if(!$arch) $cond.=" AND e.is_discharged IN ('',0) AND p.pid=e.pid ";
-
- $gbuf="l.location_nr,p.name_last, p.name_first,p.date_birth,
- e.encounter_nr,
e.encounter_class_nr,e.in_ward,
- w.name,w.roomprefix,
- l.date_from,
- r.location_nr";
-
-//if($usenum) $cond.=" GROUP BY $gbuf";
- //else $cond.=" AND p.pid=e.pid GROUP BY $gbuf";
-// if($usenum) $cond.=' GROUP BY r.location_nr';
-// else $cond.=' AND p.pid=e.pid GROUP BY r.location_nr';
-
- //$db->debug=1;
-
-
if(!isset($db)||!$db)include($root_path.'include/helpers/inc_db_makelink.php');
- if($dblink_ok){
- $sqlselect="SELECT r.location_nr AS room_nr, p.name_last,
p.name_first,p.date_birth,
- e.encounter_nr,
e.encounter_class_nr,e.in_ward,
- w.name AS ward_name,w.roomprefix,
- l.location_nr AS ward_nr,l.date_from
AS ward_date";
-
- if($usenum){
- $sqlfrom=" FROM $tb_encounter as e LEFT JOIN $tb_person
AS p ON p.pid=e.pid";
- }else{
- $sqlfrom=" FROM $tb_person as p LEFT JOIN $tb_encounter
AS e ON p.pid=e.pid";
- }
- $sqlfrom.=" LEFT JOIN $tb_location AS l ON
l.encounter_nr=e.encounter_nr AND l.type_nr=2
- LEFT JOIN $tb_location AS r ON
r.encounter_nr=l.encounter_nr AND r.type_nr=4 AND r.group_nr=l.location_nr
- LEFT JOIN $tb_ward AS w ON
w.nr=l.location_nr
- WHERE $cond";
-
- if(!empty($oitem)){
-
- #Filter the sort item
- switch($oitem){
- case 'ward_nr':
- {
- $itembuf='location_nr';
- $prep='l';
- break;
- }
- case 'ward_date':
- {
- $itembuf='date_from';
- $prep='l';
- break;
- }
- case 'room_nr':
- {
- $itembuf='location_nr';
- $prep='r';
- break;
- }
- case 'encounter_nr':
- {
- $itembuf='encounter_nr';
- $prep='e';
- break;
- }
- default:
- $itembuf=$oitem;
- $prep='p';
- }
- $sql=$sqlselect.$sqlfrom." ORDER BY $prep.$itembuf
$odir";
- }else{
- $sql=$sqlselect.$sqlfrom;
- }
- //echo $sql."<p>mode==such";
-
-
if($ergebnis=$db->SelectLimit($sql,$pagen->MaxCount(),$pagen->BlockStartIndex())){
- $rows=$ergebnis->RecordCount();
-/* if($rows==1){
- $result=$ergebnis->FetchRow();
-
header("location:nursing-station.php?sid=$sid&lang=$lang&ward_nr=".$result['ward_nr']."&station=".$result['ward_name']);
- exit;
- }
-*/
- $pagen->setTotalBlockCount($rows);
-
- # If more than one count all available
- if(isset($totalcount)&&$totalcount){
-
$pagen->setTotalDataCount($totalcount);
- }else{
- # Count total available data
- $sql='SELECT e.encounter_nr
'.$sqlfrom;
- //echo $sql;
- $totalcount=0;
- if($result=$db->Execute($sql)){
-
$totalcount=$result->RecordCount();
- }
-
$pagen->setTotalDataCount($totalcount);
- }
- # Set the sort parameters
- $pagen->setSortItem($oitem);
- $pagen->setSortDirection($odir);
-
- }else{echo "$sql<br>$LDDbNoRead";}
- }else { echo "$LDDbNoLink<br>"; }
-}
-
-# Start Smarty templating here
- /**
- * LOAD Smarty
- */
-
- # Note: it is advisable to load this after the inc_front_chain_lang.php so
- # that the smarty script can use the user configured template theme
-
- require_once($root_path.'gui/smarty_template/smarty_care.class.php');
- $smarty = new smarty_care('nursing');
-
-# Title in toolbar
- $smarty->assign('sToolbarTitle', "$LDNursing - $LDSearchPatient");
-
- # href for help button
-
$smarty->assign('pbHelp',"javascript:gethelp('nursing_how2search.php','$mode','$rows','search')");
-
- # href for close button
- $smarty->assign('breakfile',$breakfile);
-
- # OnLoad Javascript code
- $smarty->assign('sOnLoadJs','onLoad="if (window.focus) window.focus();
document.suchlogbuch.searchkey.select();"');
-
- # Window bar title
- $smarty->assign('title',"$LDNursing - $LDSearchPatient");
-
- # Collect extra javascript code
-
- ob_start();
-?>
-
-<script language="javascript">
-<!--
-var urlholder;
-
- function gotoWard(ward_nr,st,y,m,d){
-<?php
- if($cfg['dhtml'])
- {
- echo 'w=window.parent.screen.width; h=window.parent.screen.height;';
- }
- else echo 'w=800;
- h=600;';
-?>
- winspecs="menubar=no,resizable=yes,scrollbars=yes,width=" + (w-15) + ",
height=" + (h-60);
-
- urlholder="nursing-station-pass.php?rt=pflege&sid=<?php echo
"$sid&lang=$lang";
?>&pday="+d+"&pmonth="+m+"&pyear="+y+"&edit=1&retpath=search_patient&ward_nr="+ward_nr+"&station="+st;
- window.location.href=urlholder;
-}
-
-// -->
-</script>
-
-<?php
-
-$sTemp = ob_get_contents();
-
-ob_end_clean();
-
-$smarty->append('JavaScript',$sTemp);
-
-ob_start();
-
-?>
-
-<ul>
-
-<?php
-
-if($rows){
-
-?>
- <table border=0>
- <tr>
- <td><img <?php echo
createMascot($root_path,'mascot1_r.gif','0','bottom') ?> align="absmiddle"></td>
- <td class="prompt">
- <?php echo "$LDSearchKeyword <font
color=#0000ff>\"$searchkey\"</font>
".str_replace("~rows~",$totalcount,$LDWasFound).' '.$LDShowing.'
'.$pagen->BlockStartNr().' '.$LDTo.' '.$pagen->BlockEndNr().'.'; ?> <br>
- <?php echo $LDPlsClk ?>
- </td>
- </tr>
- </table>
-
- <table border=0 cellpadding=0 cellspacing=0>
- <tr class="adm_item">
-
-<?php
-
- $bgimg='tableHeaderbg3.gif';
- //$bgimg='tableHeader_gr.gif';
- $tbg=
'background="'.$root_path.'gui/img/common/'.$theme_com_icon.'/'.$bgimg.'"';
-
- $append="&usenum=$usenum&arch=$arch";
-
- if($usenum){
-
-?>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDAdm_Nr,'encounter_nr',$oitem,$odir,$append);
-?>
- </b>
- </td>
-<?php
- }
-?>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDLastName,'name_last',$oitem,$odir,$append);
-?>
- </b>
- </td>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDName,'name_first',$oitem,$odir,$append);
-?> </b>
- </td>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDBirthDate,'date_birth',$oitem,$odir,$append);
- ?>
- </b>
- </td>
-
-<?php
- if(!$usenum){
-?>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDAdm_Nr,'encounter_nr',$oitem,$odir,$append);
-?>
- </b>
- </td>
-<?php
- }
-?>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDStation,'ward_nr',$oitem,$odir,$append);
-?>
- </b>
- </td>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDRoom,'room_nr',$oitem,$odir,$append);
-?>
- </b>
- </td>
- <td><b>
-<?php
- echo
$pagen->makeSortLink($LDDate,'ward_date',$oitem,$odir,$append);
-?>
- </b>
- </td>
-
- <td><b> <?php echo $LDStatus ?></b></td>
- </tr>
-
-<?php
-
- $toggle=0;
- while($result=$ergebnis->FetchRow()){
-
-/* if($result['encounter_class_nr']==2)
$full_enr=$result['encounter_nr']+$GLOBAL_CONFIG['patient_outpatient_nr_adder'];
- else
$full_enr=$result['encounter_nr']+$GLOBAL_CONFIG['patient_inpatient_nr_adder'];
-*/
- $full_enr=$result['encounter_nr'];
- echo'
- <tr ';
- if($toggle){
- echo "bgcolor=#efefef";
- $toggle=0;
- }else{
- echo "bgcolor=#ffffff";
- $toggle=1;
- }
-
- if($result['in_ward']) $result['ward_date']=date('Y-m-d');
-
- list($pyear,$pmonth,$pday)=explode('-',$result['ward_date']);
-
-
//$buf="nursing-station.php".URL_APPEND."&station=".$result['ward_name']."&ward_nr=".$result['ward_nr'];
-
//$buf="nursing-station.php".URL_APPEND."&ward_nr=".$result['ward_nr']."&pyear=$pyear&pmonth=$pmonth&pday=$pday";
-
$buf="javascript:gotoWard('".$result['ward_nr']."','".addslashes($result['ward_name'])."','$pyear','$pmonth','$pday')";
-
- echo '>';
-/* echo '
- <td> <a href="'.$buf.'" title="'.$LDClk2Show.'">';
- if($result['s_date'] <> (date('Y-m-d'))) echo '<img
'.createComIcon($root_path,'bul_arrowblusm.gif','0').'>';
- else echo '<img
'.createComIcon($root_path,'r_arrowgrnsm.gif','0').'>';
- echo'
- </a></td>';
-*/ if($usenum){
- echo '
- <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$full_enr.'</a> </td>';
- }
- echo '
- <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['name_last'].'</a> </td>
- <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['name_first'].'</a> </td>
- <td> '.formatDate2Local($result['date_birth'],$date_format).'</td>';
- if(!$usenum){
- echo '
- <td> '.$full_enr.' </td>';
- }
-
- echo '
- <td> <a href="'.$buf.'"
title="'.$LDClk2Show.'">'.$result['ward_name'].'</a> </td>
- <td> ';
- if($result['room_nr']) echo $result['roomprefix'].'
'.$result['room_nr'];
- echo ' </td>
- <td> '.formatDate2Local($result['ward_date'],$date_format).'</td>
- <td> ';
- if($result['in_ward']) echo $LDInWard;
- echo '</td>
- </tr>
- <tr bgcolor=#0000ff>
- <td colspan=8 height=1><img
'.createComIcon($root_path,'pixel.gif','0','absmiddle').'></td>
- </tr>';
- }
-
- echo '
- <tr><td
colspan=7>'.$pagen->makePrevLink($LDPrevious,$append).'</td>
- <td align=right>'.$pagen->makeNextLink($LDNext,$append).'</td>
- </tr>';
- ?>
-</table>
-<p>
-<hr>
-<?php
-}else{
- if($mode=='such') echo str_replace('~nr~','0',$LDSearchFound);
-}
-?>
-
-<?php echo $LDSearchPrompt ?>
-
-<form action="nursing-patient-search-start.php" method="get"
name="suchlogbuch" >
-<table border=0 cellspacing=0 cellpadding=1 bgcolor="#999999">
- <tr>
- <td>
- <table border=0 cellspacing=0 cellpadding=5
bgcolor="#eeeeee">
- <tr>
- <td class="prompt"><?php echo $LDSrcKeyword
?>:<br>
- <input type="text" name="searchkey"
size=40 maxlength=100 value="<?php if ($srcword!='') echo $srcword; ?>">
- <input type="hidden" name="sid"
value="<?php echo $sid; ?>">
- <input type="hidden" name="lang"
value="<?php echo $lang; ?>">
- <input type="hidden" name="mode"
value="such"><br>
- <font size=2>
- <input type="checkbox" name="arch"
value="1" <?php if($arch) echo "checked"; ?>> <?php echo $LDSearchArchive ?>
- </font>
- </td>
- </tr>
- <tr>
- <td align=right>
- <input type="submit" value="<?php echo
$LDSearch ?>" align="right">
- </td>
- </tr>
- </table>
- </td>
- </tr>
-</table>
-</form>
-
-</ul>
-
-<p>
-<ul>
-
-<b><?php echo $LDMoreFunctions ?>:</b><br>
-<img <?php echo createComIcon($root_path,'varrow.gif','0') ?>> <a
href="nursing-station-archiv.php?sid=<?php echo "$sid&lang=$lang";?>&user=<?php
echo str_replace(" ","+",$user);?>"><?php echo $LDArchive ?></a><br>
-<img <?php echo createComIcon($root_path,'varrow.gif','0') ?>> <a
href="javascript:gethelp('nursing_how2search.php','<?php echo $mode ?>','<?php
echo $rows ?>','search')"><?php echo $LDHow2Search ?></a><br>
-
-<p>
-<a href="nursing.php<?php echo URL_APPEND; ?>"><img <?php echo
createLDImgSrc($root_path,'cancel.gif','0') ?> alt="<?php echo $LDCancel
?>"></a>
-</ul>
-
-<?php
-
-$sTemp = ob_get_contents();
-ob_end_clean();
-
-# Assign the page output to the mainframe center block
-
- $smarty->assign('sMainFrameBlockData',$sTemp);
-
- /**
- * show Template
- */
- $smarty->display('common/mainframe.tpl');
-
- ?>
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Care2002-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/care2002-developers
