コード例 #1
0
ファイル: aufnahme_list.php プロジェクト: patmark/care2x-tz
                 $where .= " AND p.pid=e.pid AND f.encounter_nr=e.encounter_nr";
             }
         }
     }
     $sql = "{$select}{$from} WHERE {$where} AND e.encounter_status <> 'cancelled' AND e.status NOT IN ('void','inactive','hidden','deleted') ORDER by ";
     $_SESSION['sess_searchkey'] = $sql;
 }
 if (!empty($where)) {
     # Filter the encounter nr:
     if ($oitem == 'encounter_nr' || $oitem == 'encounter_date') {
         $tab = 'e';
     } else {
         $tab = 'p';
     }
     //echo "$sql $tab.$oitem $odir";
     if ($ergebnis = $db->SelectLimit("{$sql} {$tab}.{$oitem} {$odir}", $pagen->MaxCount(), $pagen->BlockStartIndex())) {
         $rows = $ergebnis->RecordCount();
         if (AUTOSHOW_ONERESULT) {
             if ($rows == 1) {
                 # If result is single item, display the data immediately
                 $result = $ergebnis->FetchRow();
                 header("location:aufnahme_daten_zeigen.php" . URL_REDIRECT_APPEND . "&target=archiv&origin=archiv&encounter_nr=" . $result['encounter_nr']);
                 exit;
             }
         }
         $pagen->setTotalBlockCount($rows);
         # If more than one count all available
         if (isset($totalcount) && $totalcount) {
             $pagen->setTotalDataCount($totalcount);
         } else {
             # Count total available data
コード例 #2
0
if (empty($GLOBAL_CONFIG['pagin_patient_search_max_block_rows'])) {
    $pagen->setMaxCount(MAX_BLOCK_ROWS);
} else {
    $pagen->setMaxCount($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']);
}
if (($mode == 'search' || $mode == 'paginate') && !empty($searchkey)) {
    # Convert other wildcards
    $searchkey = strtr($searchkey, '*?', '%_');
    # Save the search keyword for eventual pagination routines
    if ($mode == 'search') {
        $_SESSION['sess_searchkey'] = $searchkey;
    }
    include_once $root_path . 'include/inc_date_format_functions.php';
    include_once $root_path . 'include/care_api_classes/class_encounter.php';
    $enc_obj = new Encounter();
    $encounter =& $enc_obj->searchLimitEncounterBasicInfo($searchkey, $pagen->MaxCount(), $pgx, $oitem, $odir);
    //echo $enc_obj->getLastQuery();
    # Get the resulting record count
    $linecount = $enc_obj->LastRecordCount();
    if ($linecount == 1 && $mode == 'search') {
        $row = $encounter->FetchRow();
        header("location:" . $root_path . "modules/nursing/nursing-station-patientdaten-doconsil-" . $target . ".php" . URL_REDIRECT_APPEND . "&pn=" . $row['encounter_nr'] . "&edit=1&status=" . $status . "&target=" . $target . "&user_origin=" . $user_origin . "&noresize=1&mode=");
        exit;
    }
    //$linecount=$address_obj->LastRecordCount();
    $pagen->setTotalBlockCount($linecount);
    # Count total available data
    if (isset($totalcount) && $totalcount) {
        $pagen->setTotalDataCount($totalcount);
    } else {
        @$enc_obj->searchEncounterBasicInfo($searchkey);
コード例 #3
0
    /**
     * Displaying the GUI
     */
    function display($skey = '')
    {
        global $db, $searchkey, $root_path, $firstname_too, $HTTP_POST_VARS, $HTTP_GET_VARS, $sid, $lang, $mode, $totalcount, $pgx, $odir, $oitem, $HTTP_SESSION_VARS, $dbf_nodate, $user_origin, $parent_admit, $status, $target, $origin;
        $this->thisfile = $filename;
        $this->searchkey = $skey;
        $this->mode = $mode;
        if (empty($this->targetfile)) {
            $withtarget = FALSE;
            $navcolspan = 5;
        } else {
            $withtarget = TRUE;
            $navcolspan = 6;
        }
        if (!empty($skey)) {
            $searchkey = $skey;
        }
        # Load the language tables
        $lang_tables = $this->langfile;
        include $root_path . 'include/inc_load_lang_tables.php';
        # Initialize pages control variables
        if ($mode == 'paginate') {
            $searchkey = $HTTP_SESSION_VARS['sess_searchkey'];
            //$searchkey='USE_SESSION_SEARCHKEY';
            //$mode='search';
        } else {
            # Reset paginator variables
            $pgx = 0;
            $totalcount = 0;
            $odir = '';
            $oitem = '';
        }
        # Create an array to hold the config values
        $GLOBAL_CONFIG = array();
        #Load and create paginator object
        include_once $root_path . 'include/care_api_classes/class_paginator.php';
        $pagen = new Paginator($pgx, $this->thisfile, $HTTP_SESSION_VARS['sess_searchkey'], $root_path);
        include_once $root_path . 'include/care_api_classes/class_globalconfig.php';
        $glob_obj = new GlobalConfig($GLOBAL_CONFIG);
        $glob_obj->getConfig('person_id_%');
        # Get the max nr of rows from global config
        $glob_obj->getConfig('pagin_person_search_max_block_rows');
        if (empty($GLOBAL_CONFIG['pagin_person_search_max_block_rows'])) {
            # Last resort, use the default defined at the start of this page
            $pagen->setMaxCount($max_block_rows);
        } else {
            $pagen->setMaxCount($GLOBAL_CONFIG['pagin_person_search_max_block_rows']);
        }
        //$db->debug=true;
        if (!defined('SHOW_FIRSTNAME_CONTROLLER')) {
            define('SHOW_FIRSTNAME_CONTROLLER', $this->show_firstname_controller);
        }
        if (SHOW_FIRSTNAME_CONTROLLER) {
            if (isset($HTTP_POST_VARS['firstname_too'])) {
                if ($HTTP_POST_VARS['firstname_too']) {
                    $firstname_too = 1;
                } elseif ($mode == 'paginate' && isset($HTTP_GET_VARS['firstname_too']) && $HTTP_GET_VARS['firstname_too']) {
                    $firstname_too = 1;
                }
            } elseif ($mode != 'search') {
                $firstname_too = TRUE;
            }
        }
        if (($this->mode == 'search' || $this->mode == 'paginate') && !empty($searchkey)) {
            # Translate *? wildcards
            $searchkey = strtr($searchkey, '*?', '%_');
            include_once $root_path . 'include/inc_date_format_functions.php';
            include_once $root_path . 'include/care_api_classes/class_person.php';
            $person =& new Person();
            # Set the sorting directive
            if (isset($oitem) && !empty($oitem)) {
                $sql3 = " ORDER BY {$oitem} {$odir}";
            }
            //$sql='SELECT * FROM '.$dbtable.$sql2;
            if ($mode == 'paginate') {
                $fromwhere = $HTTP_SESSION_VARS['sess_searchkey'];
                $sql = 'SELECT pid, name_last, name_first, date_birth, addr_zip, sex, death_date, status FROM ' . $fromwhere . $sql3;
                $ergebnis = $db->SelectLimit($sql, $pagen->MaxCount(), $pagen->BlockStartIndex());
                $linecount = $ergebnis->RecordCount();
            } else {
                $ergebnis = $person->SearchSelect($searchkey, $pagen->MaxCount(), $pagen->BlockStartIndex(), $oitem, $odir, $firstname_too);
                #Retrieve the sql fromwhere portion
                $fromwhere = $person->buffer;
                $HTTP_SESSION_VARS['sess_searchkey'] = $fromwhere;
                $sql = $person->getLastQuery();
                $linecount = $person->LastRecordCount();
            }
            if ($ergebnis) {
                if ($linecount == 1) {
                    if ($this->auto_show_bynumeric && $person->is_nr || $this->auto_show_byalphanumeric) {
                        $zeile = $ergebnis->FetchRow();
                        header("location:" . $this->targetfile . "?sid=" . $sid . "&lang=" . $lang . "&pid=" . $zeile['pid'] . "&edit=1&status=" . $status . "&user_origin=" . $user_origin . "&noresize=1&mode=");
                        exit;
                    }
                }
                $pagen->setTotalBlockCount($linecount);
                # If more than one count all available
                if (isset($totalcount) && $totalcount) {
                    $pagen->setTotalDataCount($totalcount);
                } else {
                    # Count total available data
                    $sql = 'SELECT COUNT(pid) AS maxnr FROM ' . $fromwhere;
                    if ($result = $db->Execute($sql)) {
                        if ($result->RecordCount()) {
                            $rescount = $result->FetchRow();
                            $totalcount = $rescount['maxnr'];
                        }
                    }
                    $pagen->setTotalDataCount($totalcount);
                }
                # Set the sort parameters
                $pagen->setSortItem($oitem);
                $pagen->setSortDirection($odir);
            } else {
                if ($show_sqlquery) {
                    echo $sql;
                }
            }
        } else {
            $mode = '';
        }
        $entry_block_bgcolor = $this->entry_block_bgcolor;
        $entry_border_bgcolor = $this->entry_border_bgcolor;
        $entry_body_bgcolor = $this->entry_body_bgcolor;
        $searchmask_bgcolor = $this->searchmask_bgcolor;
        ##############  Here starts the html output
        # Start Smarty templating here
        # Create smarty object without initiliazing the GUI (2nd param = FALSE)
        include_once $root_path . 'gui/smarty_template/smarty_care.class.php';
        $this->smarty = new smarty_care('common', FALSE);
        # Output any existing text before the search block
        if (!empty($this->pretext)) {
            $this->smarty->assign('sPretext', $this->pretext);
        }
        # Show tips and tricks link and the javascript
        if ($this->showtips) {
            ob_start();
            include_once $root_path . 'include/inc_js_gethelp.php';
            $sTemp = ob_get_contents();
            $this->smarty->assign('sJSGetHelp', $sTemp);
            ob_end_clean();
            $this->smarty->assign('LDTipsTricks', '<a href="javascript:gethelp(\'person_search_tips.php\')">' . $LDTipsTricks . '</a>');
        }
        #
        # Prepare the javascript validator
        #
        if (!isset($searchform_count) || !$searchform_count) {
            $this->smarty->assign('sJSFormCheck', '<script language="javascript">
			<!--
				function chkSearch(d){
					if((d.searchkey.value=="") || (d.searchkey.value==" ")){
						d.searchkey.focus();
						return false;
					}else	{
						return true;
					}
				}
			// -->
			</script>');
        }
        #
        # Prepare the search file
        #
        if (empty($this->searchfile)) {
            $search_script = $this->thisfile;
        } else {
            $search_script = $this->searchfile;
        }
        #
        # Prepare the form params
        #
        $sTemp = 'method="post" name="searchform';
        if ($searchform_count) {
            $sTemp = $sTemp . "_" . $searchform_count;
        }
        $sTemp = $sTemp . '" onSubmit="return chkSearch(this)"';
        if (isset($search_script) && $search_script != '') {
            $sTemp = $sTemp . ' action="' . $search_script . '"';
        }
        $this->smarty->assign('sFormParams', $sTemp);
        if (empty($this->prompt)) {
            $searchprompt = $LDEntryPrompt;
        } else {
            $searchprompt = $this->prompt;
        }
        //$searchprompt=$LDEnterEmployeeSearchKey;
        $this->smarty->assign('searchprompt', $searchprompt);
        #
        # Prepare the checkbox input
        #
        if (defined('SHOW_FIRSTNAME_CONTROLLER') && SHOW_FIRSTNAME_CONTROLLER) {
            if (isset($firstname_too) && $firstname_too) {
                $sTemp = 'checked';
            }
            $this->smarty->assign('sCheckBoxFirstName', '<input type="checkbox" name="firstname_too" ' . $sTemp . '>');
            $this->smarty->assign('LDIncludeFirstName', $LDIncludeFirstName);
        }
        #
        # Prepare the hidden inputs
        #
        $this->smarty->assign('sHiddenInputs', '<input type="image" ' . createLDImgSrc($root_path, 'searchlamp.gif', '0', 'absmiddle') . '>
				<input type="hidden" name="sid" value="' . $sid . '">
				<input type="hidden" name="lang" value="' . $lang . '">
				<input type="hidden" name="noresize" value="' . $noresize . '">
				<input type="hidden" name="target" value="' . $target . '">
				<input type="hidden" name="user_origin" value="' . $user_origin . '">
				<input type="hidden" name="origin" value="' . $origin . '">
				<input type="hidden" name="retpath" value="' . $retpath . '">
				<input type="hidden" name="aux1" value="' . $aux1 . '">
				<input type="hidden" name="ipath" value="' . $ipath . '">
				<input type="hidden" name="mode" value="search">');
        $this->smarty->assign('sCancelButton', '<a href="' . $this->cancelfile . URL_APPEND . '"><img ' . createLDImgSrc($root_path, 'cancel.gif', '0') . '></a>');
        //include($root_path.'include/inc_patient_searchmask.php');
        #
        # Create append data for previous and next page links
        #
        $this->targetappend .= "&firstname_too={$firstname_too}&origin={$origin}";
        //echo $mode;
        if ($parent_admit) {
            $bgimg = 'tableHeaderbg3.gif';
        } else {
            $bgimg = 'tableHeader_gr.gif';
        }
        $tbg = 'background="' . $root_path . 'gui/img/common/' . $theme_com_icon . '/' . $bgimg . '"';
        if ($mode == 'search' || $mode == 'paginate') {
            if ($linecount) {
                $this->smarty->assign('LDSearchFound', str_replace("~nr~", $totalcount, $LDSearchFound) . ' ' . $LDShowing . ' ' . $pagen->BlockStartNr() . ' ' . $LDTo . ' ' . $pagen->BlockEndNr() . '.');
            } else {
                $this->smarty->assign('LDSearchFound', str_replace('~nr~', '0', $LDSearchFound));
            }
        }
        if ($linecount) {
            $this->smarty->assign('bShowResult', TRUE);
            $img_male = createComIcon($root_path, 'spm.gif', '0');
            $img_female = createComIcon($root_path, 'spf.gif', '0');
            $this->smarty->assign('LDRegistryNr', $pagen->makeSortLink($LDRegistryNr, 'pid', $oitem, $odir, $this->targetappend));
            $this->smarty->assign('LDSex', $pagen->makeSortLink($LDSex, 'sex', $oitem, $odir, $this->targetappend));
            $this->smarty->assign('LDLastName', $pagen->makeSortLink($LDLastName, 'name_last', $oitem, $odir, $this->targetappend));
            $this->smarty->assign('LDFirstName', $pagen->makeSortLink($LDFirstName, 'name_first', $oitem, $odir, $this->targetappend));
            $this->smarty->assign('LDBday', $pagen->makeSortLink($LDBday, 'date_birth', $oitem, $odir, $this->targetappend));
            $this->smarty->assign('LDZipCode', $pagen->makeSortLink($LDZipCode, 'addr_zip', $oitem, $odir, $this->targetappend));
            if (!empty($this->targetfile)) {
                $this->smarty->assign('LDOptions', $LDOptions);
            }
            #
            # Generate the resulting list rows using the reg_search_list_row.tpl template
            #
            $sTemp = '';
            $toggle = 0;
            while ($zeile = $ergebnis->FetchRow()) {
                if ($zeile['status'] == '' || $zeile['status'] == 'normal') {
                    $this->smarty->assign('toggle', $toggle);
                    $toggle = !$toggle;
                    $this->smarty->assign('sRegistryNr', $zeile['pid']);
                    switch (strtolower($zeile['sex'])) {
                        case 'f':
                            $this->smarty->assign('sSex', '<img ' . $img_female . '>');
                            break;
                        case 'm':
                            $this->smarty->assign('sSex', '<img ' . $img_male . '>');
                            break;
                        default:
                            $this->smarty->assign('sSex', '&nbsp;');
                            break;
                    }
                    $this->smarty->assign('sLastName', ucfirst($zeile['name_last']));
                    $this->smarty->assign('sFirstName', ucfirst($zeile['name_first']));
                    #
                    # If person is dead show a black cross
                    #
                    if ($zeile['death_date'] && $zeile['death_date'] != $dbf_nodate) {
                        $this->smarty->assign('sCrossIcon', '<img ' . createComIcon($root_path, 'blackcross_sm.gif', '0', 'absmiddle') . '>');
                    } else {
                        $this->smarty->assign('sCrossIcon', '');
                    }
                    $this->smarty->assign('sBday', formatDate2Local($zeile['date_birth'], $date_format));
                    $this->smarty->assign('sZipCode', $zeile['addr_zip']);
                    if ($withtarget) {
                        $sTarget = "<a href=\"{$this->targetfile}" . URL_APPEND . "&pid=" . $zeile['pid'] . "&edit=1&status=" . $status . "&target=" . $target . "&user_origin=" . $user_origin . "&noresize=1&mode=\">";
                        $sTarget = $sTarget . '<img ' . createLDImgSrc($root_path, 'ok_small.gif', '0') . ' title="' . $LDShowDetails . '"></a>';
                        $this->smarty->assign('sOptions', $sTarget);
                    }
                    if (!file_exists($root_path . 'cache/barcodes/pn_' . $zeile['pid'] . '.png')) {
                        $this->smarty->assign('sHiddenBarcode', "<img src='" . $root_path . "classes/barcode/image.php?code=" . $zeile['pid'] . "&style=68&type=I25&width=180&height=50&xres=2&font=5&label=2' border=0 width=0 height=0>");
                    }
                    #
                    # Generate the row in buffer and append as string
                    #
                    ob_start();
                    $this->smarty->display('registration_admission/reg_search_list_row.tpl');
                    $sTemp = $sTemp . ob_get_contents();
                    ob_end_clean();
                }
            }
            #
            # Assign the rows string to template
            #
            $this->smarty->assign('sResultListRows', $sTemp);
            $this->smarty->assign('sPreviousPage', $pagen->makePrevLink($LDPrevious, $this->targetappend));
            $this->smarty->assign('sNextPage', $pagen->makeNextLink($LDNext, $this->targetappend));
        }
        #
        # Add eventual appending text block
        #
        if (!empty($this->posttext)) {
            $this->smarty->assign('sPostText', $this->posttext);
        }
        #
        # Displays the search page
        #
        if ($this->bReturnOnly) {
            ob_start();
            $this->smarty->display('registration_admission/reg_search_main.tpl');
            $sTemp = ob_get_contents();
            ob_end_clean();
            return $sTemp;
        } else {
            # show Template
            $this->smarty->display('registration_admission/reg_search_main.tpl');
        }
    }
コード例 #4
0
if (empty($GLOBAL_CONFIG['pagin_personell_search_max_block_rows'])) {
    $pagen->setMaxCount(MAX_BLOCK_ROWS);
} else {
    $pagen->setMaxCount($GLOBAL_CONFIG['pagin_personell_search_max_block_rows']);
}
# Load date formatter
require_once $root_path . 'include/inc_date_format_functions.php';
# Check mode
if ($mode == 'search' || $mode == 'paginate') {
    # Convert other wildcards
    $searchkey = strtr($searchkey, '*?', '%_');
    # Save the search keyword for eventual pagination routines
    if ($mode == 'search') {
        $_SESSION['sess_searchkey'] = $searchkey;
    }
    $search_result =& $pers_obj->searchLimitPersonellBasicInfo($searchkey, $pagen->MaxCount(), $pgx, $oitem, $odir);
    //echo $pers_obj->getLastQuery();
    # Get the resulting record count
    $linecount = $pers_obj->LastRecordCount();
    //$linecount=$address_obj->LastRecordCount();
    $pagen->setTotalBlockCount($linecount);
    # Count total available data
    if (isset($totalcount) && $totalcount) {
        $pagen->setTotalDataCount($totalcount);
    } else {
        @$pers_obj->searchPersonellBasicInfo($searchkey, '');
        # The second param is empty to prevent sorting
        $totalcount = $pers_obj->LastRecordCount();
        $pagen->setTotalDataCount($totalcount);
    }
    $pagen->setSortItem($oitem);
コード例 #5
0
 include_once $root_path . 'include/care_api_classes/class_lab.php';
 $lab_obj = new Lab();
 #Load and create paginator object
 include_once $root_path . 'include/care_api_classes/class_paginator.php';
 $pagen = new Paginator($pgx, $thisfile, $_SESSION['sess_searchkey'], $root_path);
 $GLOBAL_CONFIG = array();
 include_once $root_path . 'include/care_api_classes/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);
 } else {
     $pagen->setMaxCount($GLOBAL_CONFIG['pagin_patient_search_max_block_rows']);
 }
 $encounter =& $lab_obj->searchPatientWithPendingLabResults($keyword, $pagen->MaxCount(), $pgx, $oitem, $odir);
 //echo $lab_obj->getLastQuery()."<p>";
 # Get the resulting record count
 if ($linecount = $lab_obj->LastRecordCount()) {
     if ($mode != 'paginate') {
         $_SESSION['sess_searchkey'] = $keyword;
     }
     $pagen->setTotalBlockCount($linecount);
     # Count total available data
     if (isset($totalcount) && $totalcount) {
         $pagen->setTotalDataCount($totalcount);
     } else {
         if ($editmode) {
             @$lab_obj->searchEncounterLaboratoryInfo($keyword);
         } else {
             @$lab_obj->searchEncounterLabResults($keyword);
コード例 #6
0
            }
            # default, ascending alphabetic
        }
    }
    $sql2 .= " AND enc.pid=reg.pid\n\t\t\t\t\t  AND enc.encounter_status <> 'cancelled'\n\t\t\t\t\t  AND (enc.is_discharged = '' OR enc.is_discharged=0)\n\t\t\t\t\t  AND enc.status NOT IN ('void','hidden','inactive','deleted')  ORDER BY ";
    # Filter if it is personnel nr
    if ($oitem == 'encounter_nr') {
        $sql2 .= 'enc.' . $oitem . ' ' . $odir;
    } else {
        $sql2 .= 'reg.' . $oitem . ' ' . $odir;
    }
    $dbtable = 'FROM care_encounter as enc,care_person as reg ';
    $sql = 'SELECT enc.encounter_nr, enc.encounter_class_nr, enc.is_discharged,
								reg.pid, reg.name_2, reg.name_last, reg.name_first, reg.date_birth, reg.selian_pid,reg.sex, reg.selian_pid ' . $dbtable . $sql2;
    // echo $sql;
    if ($ergebnis = $db->SelectLimit($sql, $pagen->MaxCount(), $pagen->BlockStartIndex())) {
        if ($linecount = $ergebnis->RecordCount()) {
            // $pharmacy is delivered searching patients from pharmacy-module (cross link)
            // This is empty when it is not defined.
            if ($linecount == 1 && $numeric && $mode == 'search') {
                $zeile = $ergebnis->FetchRow();
                if (!empty($pharmacy)) {
                    $_SESSION['sess_pid'] = $zeile['pid'];
                    //echo 'Location:../registration_admission/show_prescription.php'.URL_REDIRECT_APPEND.'&pid='.$zeile['pid'].'&back_path='.$back_path.'&externalcall=true';
                    header('Location:../registration_admission/show_prescription.php' . URL_REDIRECT_APPEND . '&pid=' . $zeile['pid'] . '&back_path=' . $back_path . '&externalcall=true');
                    exit;
                } else {
                    //echo 'Location:aufnahme_daten_zeigen.php'.URL_REDIRECT_APPEND.'&from=such&encounter_nr='.$zeile['encounter_nr'].'&target=search';
                    header('Location:aufnahme_daten_zeigen.php' . URL_REDIRECT_APPEND . '&from=such&encounter_nr=' . $zeile['encounter_nr'] . '&target=search');
                    exit;
                }
コード例 #7
0
ファイル: search.php プロジェクト: patmark/care2x-tz
 if (is_numeric($suchwort)) {
     $suchwort = (int) $suchwort;
     $numeric = 1;
     $sqlwhere1 = " WHERE enc.encounter_nr='{$suchwort}' ";
 } else {
     $sqlwhere1 = "WHERE (\n\t\t\t            \treg.name_last {$sql_LIKE} '" . addslashes($suchwort) . "%' \n\t\t\t\t\t\t\tOR reg.name_first {$sql_LIKE} '" . addslashes($suchwort) . "%'";
     # Try converting the keyword to a proper date format
     $DOB = formatDate2Std($suchwort, $date_format);
     if (!empty($DOB) && $DOB != '--') {
         $sqlwhere1 .= "\tOR reg.date_birth {$sql_LIKE} '{$DOB}' ";
     }
     $sqlwhere1 .= ")";
 }
 # Compose final sql query
 $sql = $sqlselect . $sqlfrom . $sqlwhere1 . $sqlwhere2 . $orderby;
 if ($ergebnis = $db->SelectLimit($sql, $pagen->MaxCount(), $pgx)) {
     if (defined('SHOW_SQLQUERY') && SHOW_SQLQUERY) {
         echo $sql;
     }
     if ($linecount = $ergebnis->RecordCount()) {
         if ($linecount == 1 && $numeric && (!defined('SHOW_SQLQUERY') || !SHOW_SQLQUERY)) {
             $zeile = $ergebnis->FetchRow();
             header('location:patientbill.php' . URL_REDIRECT_APPEND . '&patnum=' . $zeile['encounter_nr'] . '&update=1&mode=' . $mode . '&full_en=' . $zeile['encounter_nr']);
             exit;
         }
     }
     $pagen->setTotalBlockCount($linecount);
     # Count total available data
     if (isset($totalcount) && $totalcount) {
         $pagen->setTotalDataCount($totalcount);
     } else {
コード例 #8
0
 			              OR enc.encounter_nr LIKE "'.addslashes($suchbuffer).'"
 					  )
 					  AND enc.pid=reg.pid  
 					  AND enc.encounter_status<>"cancelled"
 					  AND NOT enc.is_discharged
 					  AND (enc.in_ward OR enc.in_dept)
 					  AND enc.status NOT IN ("void","hidden","deleted","inactive")
 			          ORDER BY ';
 */
 if ($oitem == 'encounter_nr') {
     $sql3 = " ORDER BY enc.{$oitem} {$odir}";
 } else {
     $sql3 = " ORDER BY reg.{$oitem} {$odir}";
 }
 //echo $sql.$dbtable.$sql2;
 if ($ergebnis = $db->SelectLimit($sql . $dbtable . $sql2 . $sql3, $pagen->MaxCount(), $pagen->BlockStartIndex())) {
     if ($linecount = $ergebnis->RecordCount()) {
         if ($linecount == 1 && $numeric && $mode == 'search') {
             $zeile = $ergebnis->FetchRow();
             header("location:aufnahme_daten_zeigen.php" . URL_REDIRECT_APPEND . "&from=such&target=search&pid=" . $zeile['pid'] . "&encounter_nr=" . $zeile['encounter_nr'] . "&sem=" . !$zeile['is_discharged']);
             exit;
         }
         $pagen->setTotalBlockCount($linecount);
         # If more than one count all available
         if (isset($totalcount) && $totalcount) {
             $pagen->setTotalDataCount($totalcount);
         } else {
             # Count total available data
             $sql = 'SELECT COUNT(enc.encounter_nr) AS maxnr ' . $dbtable . $sql2;
             //$sql='SELECT enc.encounter_nr '.$dbtable.$sql2;
             //echo $sql;
コード例 #9
0
ファイル: oploginput.php プロジェクト: patmark/care2x-tz
             if (empty($enc_nr)) {
             } else {
                 $sk = $enc_nr;
             }
         } else {
             $sk = $pname;
         }
     } else {
         $sk = $gebdatum;
     }
     # Save searchkey to sessin for subsequent paginations
     $_SESSION['sess_searchkey'] = $sk;
 }
 # Convert other wildcards
 $sk = strtr($sk, '*?', '%_');
 $result =& $enc_obj->searchLimitEncounterBasicInfo($sk, $pagen->MaxCount(), $pgx, $oitem, $odir);
 //echo $enc_obj->getLastQuery();
 # Get the resulting record count
 $linecount = $enc_obj->LastRecordCount();
 if ($linecount == 1 && $mode == 'search' && REDIRECT_SINGLERESULT) {
     $pdata = $result->FetchRow();
     header("location:oploginput.php" . URL_REDIRECT_APPEND . "&mode=get&enc_nr=" . $pdata['encounter_nr'] . "&dept_nr={$dept_nr}&saal={$saal}&op_nr={$op_nr}&pday={$pday}&pmonth={$pmonth}&pyear={$pyear}");
     exit;
 }
 //$linecount=$address_obj->LastRecordCount();
 $pagen->setTotalBlockCount($linecount);
 # Count total available data
 if (isset($totalcount) && $totalcount) {
     $pagen->setTotalDataCount($totalcount);
 } else {
     @$enc_obj->searchEncounterBasicInfo($sk);