/** * Displays the GUI showing the data */ function display($pid) { global $root_path, $dbf_nodate, $newdata; $validdata = TRUE; if (!empty($pid)) { $this->pid = $pid; } # Load the language tables $lang_tables = $this->langfile; include $root_path . 'include/inc_load_lang_tables.php'; include_once $root_path . 'include/inc_date_format_functions.php'; include_once $root_path . 'include/care_api_classes/class_insurance.php'; $pinsure_obj = new PersonInsurance($this->pid); # Get the global config for person�s registration form include_once $root_path . 'include/care_api_classes/class_globalconfig.php'; $GLOBAL_CONFIG = array(); $glob_obj = new GlobalConfig($GLOBAL_CONFIG); $glob_obj->getConfig('person_%'); //extract($GLOBAL_CONFIG); if (empty($this->pid)) { $validdata = FALSE; } else { //if($data_obj=&$this->person_obj->getAllInfoObject()){ // $this->data=$data_obj->FetchRow(); if ($this->is_loaded) { extract($this->data); # Get related insurance data $p_insurance =& $pinsure_obj->getPersonInsuranceObject($this->pid); if ($p_insurance == FALSE) { $insurance_show = true; } else { if (!$p_insurance->RecordCount()) { $insurance_show = true; } elseif ($p_insurance->RecordCount() == 1) { $buffer = $p_insurance->FetchRow(); extract($buffer); $insurance_show = true; # Get insurace firm name $insurance_firm_name = $pinsure_obj->getFirmName($insurance_firm_id); } else { $insurance_show = FALSE; } } $insurance_class_info = $pinsure_obj->getInsuranceClassInfo($insurance_class_nr); # Check if person is currently admitted $this->current_encounter = $this->person_obj->CurrentEncounter($this->pid); # update the record�s history if (empty($newdata)) { @$this->person_obj->setHistorySeen($_SESSION['sess_user_name']); } # Check whether config foto path exists, else use default path $photo_path = is_dir($root_path . $GLOBAL_CONFIG['person_foto_path']) ? $GLOBAL_CONFIG['person_foto_path'] : $this->default_photo_path; } else { $validdata = FALSE; } } if ($validdata) { include_once $root_path . 'include/inc_photo_filename_resolve.php'; ############ Here starts the GUI output ################## # load config options include_once $root_path . 'include/care_api_classes/class_multi.php'; $multi = new multi(); ?> <table border=0 cellspacing=1 cellpadding=3> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDRegistryNr; ?> : </td> <td width="30%" bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#800000"> <?php if ($pid) { if (IS_TANZANIAN) { echo $this->showPID($pid); } else { echo $pid; } } ?> <br> <?php if (file_exists($root_path . 'cache/barcodes/pn_' . $pid . '.png')) { echo '<img src="' . $root_path . 'cache/barcodes/pn_' . $pid . '.png" border=0 width=180 height=35>'; } else { echo "<img src='" . $root_path . "classes/barcode/image.php?code=" . $pid . "&style=68&type=I25&width=180&height=50&xres=2&font=5&label=2&form_file=pn' border=0 width=0 height=0>"; echo "<img src='" . $root_path . "classes/barcode/image.php?code=" . $pid . "&style=68&type=I25&width=180&height=50&xres=2&font=5' border=0 width=180 height=35>"; } ?> </td> <td valign="top" rowspan=6 align="center" bgcolor="#ffffee" > <FONT SIZE=-1 FACE="Arial"><img <?php echo $img_source; ?> > </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDFileNr; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#800000"><b><?php echo $selian_pid; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDRegTime; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#800000"><b><?php echo convertTimeToLocal(formatDate2Local($date_reg, $date_format, 0, 1)); ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDRegDate; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#800000"> <b><?php echo formatDate2Local($date_reg, $date_format); ?> <input name="date_reg" type="hidden" value="<?php echo $date_reg; ?> "> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDTitle; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $title; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDLastName; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $name_last; ?> </b> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDFirstName; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $name_first; ?> </b> <?php # If person is dead show a black cross if ($death_date && $death_date != $dbf_nodate) { echo ' <img ' . createComIcon($root_path, 'blackcross_sm.gif', '0') . '>'; } ?> </td> </tr> <?php if (!$GLOBAL_CONFIG['person_name_2_hide'] && $name_2) { $this->createTR($LDName2, $name_2); } if (!$GLOBAL_CONFIG['person_name_3_hide'] && $name_3) { $this->createTR($LDName3, $name_3); } if (!$GLOBAL_CONFIG['person_name_middle_hide'] && $name_middle) { $this->createTR($LDNameMid, $name_middle); } if (!$GLOBAL_CONFIG['person_name_maiden_hide'] && $name_maiden) { $this->createTR($LDNameMaiden, $tribe_name); } if (!$GLOBAL_CONFIG['person_name_others_hide'] && $name_others) { $this->createTR($LDNameOthers, $name_others); } ?> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDBday; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo formatDate2Local($date_birth, $date_format); ?> </b> <?php # If person is dead show a black cross if ($death_date && $death_date != $dbf_nodate) { echo ' <img ' . createComIcon($root_path, 'blackcross_sm.gif', '0') . '> <font color="#000000">' . formatDate2Local($death_date, $date_format) . '</font>'; } ?> </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $LDSex; ?> : <?php if ($sex == "m") { echo $LDMale; } elseif ($sex == "f") { echo $LDFemale; } ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDBloodGroup; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php $buf = 'LD' . trim($blood_group); echo ${$buf}; ?> </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $LDRHfactor . $rh; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo 'Allergy'; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $allergy; ?> </b> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDCivilStatus; ?> : </td> <td colspan=2 bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php if ($civil_status == "single") { echo $LDSingle; } elseif ($civil_status == "married") { echo $LDMarried; } elseif ($civil_status == "divorced") { echo $LDDivorced; } elseif ($civil_status == "widowed") { echo $LDWidowed; } elseif ($civil_status == "separated") { echo $LDSeparated; } ?> </td> </tr> <?php global $db; $coreObj->sql = "SELECT name FROM care_tz_company WHERE id={$insurance_ID}"; if ($ergebnis = $db->Execute($coreObj->sql)) { $row = $ergebnis->FetchRow(); $insurance_name = $row['name']; } else { $insurance_name = ''; } ?> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDInsurance; ?> : </td> <td><FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $insurance_name; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDMembership_nr; ?> : </td> <td><FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $membership_nr; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDForm_nr; ?> : </td> <td><FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $form_nr; ?> </td> </tr> <tr> <td colspan=3> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDAddress; ?> : </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDTownCity; ?> : </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $citizenship; ?> <?php //echo $addr_citytown_name; //echo $addr_citytown_nr; ?> </td> <td bgcolor="#ffffee"> <FONT SIZE=-1 FACE="Arial" color="#990000"><b> <?php echo $LDZipCode; ?> : <?php echo $addr_zip; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo 'Region'; ?> : </td> <td bgcolor="#ffffee" colspan=2> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $region > 0 ? $multi->GetRegionName($region) : $region; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo 'District'; ?> : </td> <td bgcolor="#ffffee" colspan=2> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $district > 0 ? $multi->GetDistrictName($district) : $district; ?> </td> </tr> <tr> <td bgColor="#eeeeee"> <FONT SIZE=-1 FACE="Arial"> <?php echo 'Ward'; ?> : </td> <td bgcolor="#ffffee" colspan=2> <FONT SIZE=-1 FACE="Arial" color="#990000"> <b><?php echo $ward > 0 ? $multi->GetWardName($ward) : $ward; ?> </td> </tr> <?php if (!$GLOBAL_CONFIG['person_insurance_1_nr_hide'] && $insurance_show && $insurance_nr) { $this->createTR($LDInsuranceNr, $insurance_nr, 2); $buffer = $insurance_class_info['LD_var']; if (isset(${$buffer}) && !empty(${$buffer})) { $this->createTR($LDInsuranceClass, ${$buffer}, 2); } else { $this->createTR($LDInsuranceClass, $insurance_class_info['name'], 2); } $this->createTR($LDInsuranceCo . ' 1', $insurance_firm_name, 2); } if (!$GLOBAL_CONFIG['person_phone_1_nr_hide'] && $phone_1_nr) { $this->createTR($LDPhone . ' 1', $phone_1_nr, 2); } if (!$GLOBAL_CONFIG['person_phone_2_nr_hide'] && $phone_2_nr) { $this->createTR($LDPhone . ' 2', $phone_2_nr, 2); } if (!$GLOBAL_CONFIG['person_cellphone_1_nr_hide'] && $cellphone_1_nr) { $this->createTR($LDCellPhone . ' 1', $cellphone_1_nr, 2); } if (!$GLOBAL_CONFIG['person_cellphone_2_nr_hide'] && $cellphone_2_nr) { $this->createTR($LDCellPhone . ' 2', $cellphone_2_nr, 2); } if (!$GLOBAL_CONFIG['person_fax_hide'] && $fax) { $this->createTR($LDFax, $fax, 2); } if (!$GLOBAL_CONFIG['person_email_hide'] && $email) { } //if (!$GLOBAL_CONFIG['person_citizenship_hide']&&$citizenship){ //$this->createTR($LDCitizenship,$citizenship,2); //} if (!$GLOBAL_CONFIG['person_sss_nr_hide'] && $sss_nr) { $this->createTR('District', $district_name, 2); } if (!$GLOBAL_CONFIG['person_nat_id_nr_hide'] && $nat_id_nr) { // $this->createTR('Ward',$ward_name,2); } if (!$GLOBAL_CONFIG['person_religion_hide'] && $religion) { $this->createTR($LDReligion, $name, 2); } if (!$GLOBAL_CONFIG['person_insurance_hide'] && $insurance_ID) { // $this->createTR($LDInsurance,$insurance_ID,2); } if (!$GLOBAL_CONFIG['person_ethnic_orig_hide'] && $ethnic_orig) { $this->createTR($LDEthnicOrigin, $ethnic_orig_txt, 2); } $sql = 'SELECT modify_id, create_id FROM care_person where pid="' . $pid . '"'; $result = $db->Execute($sql); $row = $result->FetchRow(); if ($row['modify_id'] == '') { $modifyid = $row['create_id']; } else { $modifyid = $row['modify_id']; } ?> <tr> <td bgcolor="#eeeeee"> <nobr><FONT SIZE=2 FACE="Arial"><?php echo $LDRegBy; ?> :</nobr> </td> <td colspan=2 bgcolor="#ffffee"> <FONT SIZE=2 FACE="Arial" color="#990000"><b><?php echo $modifyid; ?> </b></FONT> </td> </tr> </table> <?php } else { echo 'Invalid PID number or the data is not available from the databank! Please report this to <a href="mailto:info@care2x.org">info@care2x.org</a>. Thank you.'; } }
/** * Displays the GUI input form */ function display() { global $db, $sid, $lang, $root_path, $pid, $insurance_show, $user_id, $mode, $dbtype, $no_tribe, $no_region, $update, $photo_filename; #, $_FILES $_POST, $_SESSION; extract($_POST); require_once $root_path . 'include/care_api_classes/class_advanced_search.php'; # Load the language tables $lang_tables = $this->langfiles; include $root_path . 'include/inc_load_lang_tables.php'; include_once $root_path . 'include/inc_date_format_functions.php'; include_once $root_path . 'include/care_api_classes/class_insurance.php'; include_once $root_path . 'include/care_api_classes/class_person.php'; $db->debug = FALSE; # Create the new person object $person_obj = new Person($pid); # Create a new person insurance object $pinsure_obj = new PersonInsurance($pid); if (!isset($insurance_show)) { $insurance_show = TRUE; } $newdata = 1; $error = 0; $dbtable = 'care_person'; if (!isset($photo_filename) || empty($photo_filename)) { $photo_filename = 'nopic'; } # Assume first that image is not uploaded $valid_image = FALSE; //* Get the global config for person's registration form*/ include_once $root_path . 'include/care_api_classes/class_globalconfig.php'; $glob_obj = new GlobalConfig($GLOBAL_CONFIG); $glob_obj->getConfig('person_%'); extract($GLOBAL_CONFIG); # Check whether config foto path exists, else use default path $photo_path = is_dir($root_path . $GLOBAL_CONFIG['person_foto_path']) ? $GLOBAL_CONFIG['person_foto_path'] : $this->default_photo_path; if ($mode == 'save' || $mode == 'forcesave') { $search_obj = new advanced_search(); if (is_array($result_array = $search_obj->get_equal_words("tribe_name", "care_tz_tribes", false, 65, 'tribe_id')) && $name_maiden && !$no_tribe) { $tribe_array = $result_array; } else { $tribe_array = $result_array; } if (is_array($result_array = $search_obj->get_equal_words("name", "care_tz_religion", false, 65, 'nr')) && $religion && !$person_religion_hide) { $religion_array = $result_array; } else { $religion_array = $result_array; } /* if (is_array($result_array=$search_obj->get_equal_words("region_name", "care_tz_region", false, 65, 'region_id')) && $email && !$person_email_hide ) { $region_array=$result_array; } else { $region_array=$result_array; } if (is_array($result_array=$search_obj->get_equal_words1("district_name", "care_tz_district", false, 65, 'district_id',$email)) && $sss_nr ) { $district_array=$result_array; } else { $district_array=$result_array; } if (is_array($result_array=$search_obj->get_equal_words1("ward_name", "care_tz_ward", false, 65, 'ward_id',$sss_nr)) && $nat_id_nr ) { $ward_array=$result_array; } else { $ward_array=$result_array; } */ # If saving is not forced, validate important elements if ($mode != 'forcesave') { # clean and check input data variables if (trim($encoder) == '') { $encoder = $aufnahme_user; } if (trim($name_last) == '') { $errornamelast = 1; $error++; } if (trim($selian_pid) == '' || !is_numeric($selian_pid) || !$update && $person_obj->SelianFileExists($selian_pid)) { $errorfilenr = 1; $error++; } if ($person_obj->IsHospitalFileNrMandatory()) { if (trim($selian_pid) == '' || !$update && $person_obj->SelianFileExists($selian_pid)) { $errorfilenr = 1; $error++; } } if (trim($name_first) == '') { $errornamefirst = 1; $error++; } if (trim($date_birth) == '') { $errordatebirth = 1; $error++; } if (mktime(0, 0, 0, substr($date_birth, 3, 2), substr($date_birth, 0, 2), substr($date_birth, 6, 4)) > time()) { $errordatebirth = 1; $error++; } //if (is_array($tribe_array) && !$no_tribe) {$errormaiden=1; $error++;} //if (is_array($town_array)) {$errortown=1; $error++;} //if (!$citizenship) { $errortown=1; $error++;} if ($sex == '') { $errorsex = 1; $error++; } } # If the validation produced no error, save the data if (!$error) { # Save the old filename for testing $old_fn = $photo_filename; # Create image object include_once $root_path . 'include/care_api_classes/class_image.php'; $img_obj =& new Image(); # Check the uploaded image file if exists and valid if ($img_obj->isValidUploadedImage($_FILES['photo_filename'])) { $valid_image = TRUE; # Get the file extension $picext = $img_obj->UploadedImageMimeType(); } //addr_citytown_nr='$addr_citytown_nr', if ($update) { //echo formatDate2STD($geburtsdatum,$date_format); $sql = "UPDATE {$dbtable} SET\n title='{$title}',\n selian_pid='{$selian_pid}',\n name_last='{$name_last}',\n name_first='{$name_first}',\n name_2='{$name_2}',\n name_3='{$name_3}',\n name_middle='{$name_middle}',\n name_maiden='{$name_maiden}',\n name_others='{$name_others}',\n date_birth='" . formatDate2STD($date_birth, $date_format) . "',\n blood_group='" . trim($blood_group) . "',\n rh='" . trim($rh) . "',\n sex='{$sex}',\n addr_str='{$addr_str}',\n addr_str_nr='{$addr_str_nr}',\n addr_zip='{$addr_zip}',\n addr_citytown_nr='{$addr_citytown_nr}',\n addr_citytown_name='{$addr_citytown_name}',\n phone_1_nr='{$phone_1_nr}',\n phone_2_nr='{$phone_2_nr}',\n cellphone_1_nr='{$cellphone_1_nr}',\n cellphone_2_nr='{$cellphone_2_nr}',\n fax='{$fax}',\n email='{$email}',\n citizenship ='{$citizenship}',\n civil_status='{$civil_status}',\n membership_nr='{$membership_nr}',\n\n\n sss_nr='',\n nat_id_nr='',\n religion='{$religion}',\n ethnic_orig='{$ethnic_orig}',\n\t\t\t\t\t\t\t insurance_ID='{$insurance_ID}',\n date_update='" . date('Y-m-d H:i:s') . "',"; if ($region != "-1" && $district != "-1" && $ward != "-1") { $sql .= "region='{$region}',\n\t\t\t\t\t\t\t district='{$district}',\n\t\t\t\t\t\t\t ward='{$ward}',"; } //if ($old_fn!=$photo_filename){ if ($valid_image) { # Compose the new filename $photo_filename = $pid . '.' . $picext; # Save the file $img_obj->saveUploadedImage($_FILES['photo_filename'], $root_path . $photo_path . '/', $photo_filename); # add to the sql query $sql .= " photo_filename='{$photo_filename}',"; } # complete the sql query $sql .= " history=" . $person_obj->ConcatHistory("Update " . date('Y-m-d H:i:s') . " " . $_SESSION['sess_user_name'] . " \n") . ", modify_id='" . $_SESSION['sess_user_name'] . "' WHERE pid={$pid}"; //$db->debug=true; $db->BeginTrans(); $ok = $db->Execute($sql); if ($ok) { $db->CommitTrans(); # Update the insurance data # Lets detect if the data is already existing if ($insurance_show) { if ($insurance_item_nr) { if (!empty($insurance_nr) && !empty($insurance_firm_name) && $insurance_firm_id) { $insure_data = array('insurance_nr' => $insurance_nr, 'firm_id' => $insurance_firm_id, 'class_nr' => $insurance_class_nr, 'history' => "Update " . date('Y-m-d H:i:s') . " " . $_SESSION['sess_user_name'] . " \n", 'modify_id' => $_SESSION['sess_user_name'], 'modify_time' => date('YmdHis')); $pinsure_obj->updateDataFromArray($insure_data, $insurance_item_nr); } } elseif ($insurance_nr && $insurance_firm_name && $insurance_class_nr) { $insure_data = array('insurance_nr' => $insurance_nr, 'firm_id' => $insurance_firm_id, 'pid' => $pid, 'class_nr' => $insurance_class_nr, 'history' => "Update " . date('Y-m-d H:i:s') . " " . $_SESSION['sess_user_name'] . " \n", 'create_id' => $_SESSION['sess_user_name'], 'create_time' => date('YmdHis')); $pinsure_obj->insertDataFromArray($insure_data); } } $newdata = 1; if (file_exists($this->displayfile)) { header("location: {$this->displayfile}" . URL_REDIRECT_APPEND . "&pid={$pid}&from={$from}&newdata=1&target=entry"); exit; } else { echo "Error! Target display file not defined!!"; } } else { $db->RollbackTrans(); } } else { $from = 'entry'; $_POST['date_birth'] = @formatDate2Std($date_birth, $date_format); $_POST['date_reg'] = date('Y-m-d H:i:s'); $_POST['blood_group'] = trim($_POST['blood_group']); $_POST['status'] = 'normal'; $_POST['history'] = "Init.reg. " . date('Y-m-d H:i:s') . " " . $_SESSION['sess_user_name'] . "\n"; //$_POST['modify_id']=$_SESSION['sess_user_name']; $_POST['create_id'] = $_SESSION['sess_user_name']; $_POST['create_time'] = date('YmdHis'); # Prepare internal data to be stored together with the user input data if (!$person_obj->InitPIDExists($GLOBAL_CONFIG['person_id_nr_init'])) { # If db is mysql, insert the initial pid value from global config # else let the dbms make an initial value via the sequence generator e.g. postgres # However, the sequence generator must be configured during db creation to start at # the initial value set in the global config if ($dbtype == 'mysql') { $_POST['pid'] = $GLOBAL_CONFIG['person_id_nr_init']; } } else { # Persons are existing. Check if duplicate might exist if (is_object($duperson = $person_obj->PIDbyData($_POST))) { $error_person_exists = TRUE; } } //echo $person_obj->getLastQuery(); if (!$error_person_exists || $mode == 'forcesave') { if ($person_obj->insertDataFromInternalArray()) { # If data was newly inserted, get the insert id if mysq, else get the pid number) if (!$update) { $oid = $db->Insert_ID(); $pid = $person_obj->LastInsertPK('pid', $oid); /* if($dbtype=='mysql'){ $pid=$db->Insert_ID(); }else{ $pid=$person_obj->postgre_Insert_ID($dbtable,'pid',$db->Insert_ID()); }*/ } //if(!$update) $pid=$db->Insert_ID(); # Save the valid uploaded photo if ($valid_image) { # Compose the new filename by joining the pid number and the file extension with "." $photo_filename = $pid . '.' . $picext; # Save the file if ($img_obj->saveUploadedImage($_FILES['photo_filename'], $root_path . $photo_path . '/', $photo_filename)) { # Update the filename to the databank $person_obj->setPhotoFilename($pid, $photo_filename); } } //echo $pid; //echo $citizenship; # Update the insurance data # Lets detect if the data is already existing if ($insurance_show) { if ($insurance_item_nr) { if (!empty($insurance_nr) && !empty($insurance_firm_name) && $insurance_firm_id) { $insure_data = array('insurance_nr' => $insurance_nr, 'firm_id' => $insurance_firm_id, 'class_nr' => $insurance_class_nr); $pinsure_obj->updateDataFromArray($insure_data, $insurance_item_nr); } } elseif ($insurance_nr && $insurance_firm_name && $insurance_class_nr) { $insure_data = array('insurance_nr' => $insurance_nr, 'firm_id' => $insurance_firm_id, 'pid' => $pid, 'class_nr' => $insurance_class_nr); $pinsure_obj->insertDataFromArray($insure_data); } } $newdata = 1; if (file_exists($this->displayfile)) { header("location: {$this->displayfile}" . URL_REDIRECT_APPEND . "&pid={$pid}&from={$from}&newdata=1&target=entry"); exit; } else { echo "Error! Target display file not defined!!"; } } else { echo "<p>{$db->ErrorMsg}()<p>{$LDDbNoSave}"; } } } } // end of if(!$error) } elseif (!empty($this->pid)) { # Get the person?s data if ($data_obj =& $person_obj->getAllInfoObject()) { $zeile = $data_obj->FetchRow(); extract($zeile); //print_r($zeile); # Get the related insurance data $p_insurance =& $pinsure_obj->getPersonInsuranceObject($pid); if ($p_insurance == FALSE) { $insurance_show = TRUE; } else { if (!$p_insurance->RecordCount()) { $insurance_show = TRUE; } elseif ($p_insurance->RecordCount() == 1) { $buffer = $p_insurance->FetchRow(); extract($buffer); $insurance_show = TRUE; $insurance_firm_name = $pinsure_obj->getFirmName($insurance_firm_id); } else { $insurance_show = FALSE; } } } } else { $date_reg = date('Y-m-d H:i:s'); } # Get the insurance classes $insurance_classes =& $pinsure_obj->getInsuranceClassInfoObject('class_nr,name,LD_var AS "LD_var"'); include_once $root_path . 'include/inc_photo_filename_resolve.php'; $search_obj =& new advanced_search(); if (!$update) { $tribe = $name_maiden; $town = $citizenship; } if (is_array($result_array = $search_obj->get_equal_words("tribe_name", "care_tz_tribes", false, 65, 'tribe_id')) && $name_maiden && !$no_tribe) { $tribe_array = $result_array; } else { $tribe_array = $result_array; } /* if (is_array($result_array=$search_obj->get_equal_words("village_name", "care_tz_village", false, 65, 'village_id',$ward)) && $addr_citytown_nr) { $town_array=$result_array; } else { $town_array=$result_array; }*/ if (is_array($result_array = $search_obj->get_equal_words("name", "care_tz_religion", false, 65, 'nr')) && $religion) { $religion_array = $result_array; } else { $religion_array = $result_array; } /* if (is_array($result_array=$search_obj->get_equal_words("region_name", "care_tz_region", false, 65, 'region_id')) && $email && !$person_email_hide ) { $region_array=$result_array; } else { $region_array=$result_array; } if (is_array($result_array=$search_obj->get_equal_words1("district_name", "care_tz_district", false, 65, 'district_id',$email)) && $sss_nr ) { $district_array=$result_array; } else { $district_array=$result_array; } if (is_array($result_array=$search_obj->get_equal_words1("ward_name", "care_tz_ward", false, 65, 'ward_id',$sss_nr)) && $nat_id_nr ) { $ward_array=$result_array; } else { $ward_array=$result_array; } */ ######## Here starts the GUI output ####################################################### $img_male = createComIcon($root_path, 'spm.gif', '0'); $img_female = createComIcon($root_path, 'spf.gif', '0'); $tbg = 'background="' . $root_path . 'gui/img/common/' . $theme_com_icon . '/tableHeader_gr.gif"'; # load config options include_once $root_path . 'include/care_api_classes/class_multi.php'; $cd_obj = new multi(); if (!empty($this->pretext)) { echo $this->pretext; } ?> <script language="javascript"> <!-- function test(){ document.aufnahmeform.action="<?php $_SERVER['PHP_SELF']; ?> "; document.aufnahmeform.submit(); } function forceSave(){ document.aufnahmeform.mode.value="forcesave"; document.aufnahmeform.submit(); } function showpic(d){ if(d.value) document.images.headpic.src=d.value; } function popSearchWin(target,obj_val,obj_name){ urlholder="./data_search.php<?php echo URL_REDIRECT_APPEND; ?> &target="+target+"&obj_val="+obj_val+"&obj_name="+obj_name; DSWIN<?php echo $sid; ?> =window.open(urlholder,"wblabel<?php echo $sid; ?> ","menubar=no,width=400,height=550,resizable=yes,scrollbars=yes"); } function list_popup(d,chosentype) { if(d.value=="notinlist") { urlholder="<?php echo $root_path; ?> modules/registration_admission/notinlist.php<?php echo URL_APPEND . '&chosentype=" + chosentype + "'; ?> "; notinlist=window.open(urlholder,"notinlist","width=500,height=450,menubar=no,resizable=yes,scrollbars=yes"); } } function chkform(d) { <?php if ($person_obj->IsHospitalFileNrMandatory()) { echo 'if(d.selian_pid.value==""){ alert("Please enter Hospital File Number"); d.selian_pid.focus(); return false; }else'; } ?> if(d.name_last.value==""){ alert("<?php echo $LDPlsEnterLastName; ?> "); d.name_last.focus(); return false; }else if(d.name_first.value==""){ alert("<?php echo $LDPlsEnterFirstName; ?> "); d.name_first.focus(); return false; }else if(d.name_2.value==""){ alert("<?php echo 'Please Enter Father Name'; ?> "); d.name_2.focus(); return false; }else if(d.insurance_ID.value=="-1"){ alert("<?php echo 'Please Enter Insurance Or Cash'; ?> "); d.insurance_ID.focus(); return false; }//else if(d.membership_nr.value==""){ // alert("<?php echo 'Please Enter Membership number OR zero for Cash'; ?> "); // d.membership_nr.focus(); // return false; //} else if(d.date_birth.value==""){ alert("<?php echo $LDPlsEnterDateBirth; ?> "); d.date_birth.focus(); return false; }else if(d.sex[0]&&d.sex[1]&&!d.sex[0].checked&&!d.sex[1].checked){ alert("<?php echo $LDPlsSelectSex; ?> "); return false; }else if(d.is_first_reg[0]&&d.is_first_reg[1]&&!d.is_first_reg[0].checked&&!d.is_first_reg[1].checked){ alert("<?php echo $LDPlsSelectIsFirst; ?> "); return false; <?php if ($update) { $sql = "SELECT * FROM care_person where pid=" . $pid; $ergebnis = $db->Execute($sql); while ($person = $ergebnis->FetchRow()) { $region = $person['region']; } } if (!$update or $region == '') { echo '}else if(d.region.value=="-1"){'; echo 'alert("Please select region");'; echo 'd.region.focus();'; echo 'return false;'; echo '}else if(d.district.value=="-1"){'; echo 'alert("Please select district");'; echo 'd.district.focus();'; echo 'return false;'; echo '}else if(d.ward.value=="-1"){'; echo ' alert("Please select Ward");'; echo ' d.ward.focus();'; echo ' return false;'; } else { echo '}else if(d.region.value!="-1"){'; echo 'if(d.district.value=="-1")'; echo '{'; echo 'alert("Please select district");'; echo 'd.district.focus();'; echo 'return false;'; echo '}'; echo 'if(d.ward.value=="-1")'; echo '{'; echo ' alert("Please select ward");'; echo ' d.ward.focus();'; echo ' return false;'; echo '}'; } ?> }else if(d.user_id.value==""){ alert("<?php echo $LDPlsEnterFullName; ?> "); d.user_id.focus(); return false; }else if(d.name_maiden.value=="-1"){ alert ("Select tribe!"); return false; }else if(d.religion.value=="-1"){ alert ("Select religion!"); return false; }else{ return true; } } function getDistricts(val,id){ xtarget = id; navigate('&id='+val+'&dir=district','<?php echo $root_path; ?> modules/registration_admission/get_params.php') clearSelect('ward'); appendThis('ward','<option value=""> --- Select District First --- </option>'); } function getWards(val,id){ xtarget = id; navigate('&id='+val+'&dir=ward','<?php echo $root_path; ?> modules/registration_admission/get_params.php') } function clearSelect(id){ $('#'+id).children().remove(); } function appendThis(id,st){ $('#'+id).append(st); } <?php require $root_path . 'include/inc_checkdate_lang.php'; ?> --> </script> <script language="javascript" src="<?php echo $root_path; ?> js/setdatetime.js"></script> <script language="javascript" src="<?php echo $root_path; ?> js/checkdate.js"></script> <script language="javascript" src="<?php echo $root_path; ?> js/dtpick_care2x.js"></script> <script src="<?php echo $root_path; ?> modules/dental/dental_filling_.js" language="javascript"></script> <script src="<?php echo $root_path; ?> modules/dental/JQ.js" language="javascript"></script> <FONT SIZE=-1 FACE="Arial"> <form method="post" action="<?php echo $thisfile; ?> " name="aufnahmeform" ENCTYPE="multipart/form-data" onSubmit="return chkform(this)"> <table border=0 cellspacing=0 cellpadding=0> <?php if ($error) { echo "<script language=\"Javascript\" type=\"text/javascript\"> </script>"; //alert('Information is missing in the input field marked red!') ; ?> <tr bgcolor=#ffffee> <td colspan=3> <center> <font face=arial color=#7700ff size=4> <img <?php echo createMascot($root_path, 'mascot1_r.gif', '0', 'bottom'); ?> align="absmiddle"> <?php if ($error > 1) { echo "<script language=\"Javascript\" type=\"text/javascript\"> </script>"; //alert('$LDErrorS') echo $LDErrorS; } else { /* echo "<script language=\"Javascript\" type=\"text/javascript\"> alert('Information is missing in the input field marked red!') </script>"; */ echo $LDError; } ?> </center> </td> </tr> <?php } elseif ($error_person_exists) { ?> <tr bgcolor=#ffffee> <td colspan=3> <center> <table border=0> <tr> <td><img <?php echo createMascot($root_path, 'mascot1_r.gif', '0', 'bottom'); ?> align="absmiddle"></td> <td><font face=arial color=#7700ff size=4> <?php echo $LDPersonDuplicate; if ($duperson->RecordCount() > 1) { echo " {$LDSimilarData2} {$LDPlsCheckFirst2}"; } else { echo "{$LDSimilarData} {$LDPlsCheckFirst}"; } echo "<script language=\"Javascript\" type=\"text/javascript\"> </script>"; // alert('$LDSimilarData $LDPlsCheckFirst') echo ' </td> </tr> </table> </center> </td> </tr> <tr> <td colspan=3> <table border=0 cellspacing=0 cellpadding=1 bgcolor="#000000" width=100%> <tr> <td> <table border=0 cellspacing=0 width=100% bgcolor="#ffffff">'; echo ' <tr bgcolor="#66ee66" background="' . $root_path . 'gui/img/common/default/tableHeaderbg.gif">'; echo "\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDRegistryNr}</b></td>\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDLastName}</b></td>\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDFirstName}</b></td>\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDBday}</b></td>\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDSex}</b></td>\n\t\t\t\t\t<td {$tbg}><FONT SIZE=-1 FACE=\"Arial\" color=\"#000066\"><b>\n\t\t\t\t\t\t{$LDOptions}</b></td>\n\t\t\t\t\t</tr>"; # Show the probable same person while ($dup = $duperson->FetchRow()) { echo ' <tr> <td><font face=arial color=#000000 size=2>' . $dup['pid'] . '</td> <td><font face=arial color=#000000 size=2>' . $dup['name_last'] . '</td> <td><font face=arial color=#000000 size=2>' . $dup['name_first'] . '</td> <td><font face=arial color=#000000 size=2>' . formatDate2Local($dup['date_birth'], $date_format) . '</td> <td>'; switch ($dup['sex']) { case 'f': echo '<img ' . $img_female . '>'; break; case 'm': echo '<img ' . $img_male . '>'; break; default: echo ' '; break; } echo ' </td> <td><font face=arial color=#000000 size=2>:: <a href="person_reg_showdetail.php' . URL_APPEND . '&pid=' . $dup['pid'] . '&from=$from&newdata=1&target=entry" target="_blank">' . $LDShowDetails . '</a> :: <a href="patient_register.php' . URL_APPEND . '&pid=' . $dup['pid'] . '&update=1">' . $LDUpdate . '</a> </td> </tr>'; } echo ' </table> </td> </tr> </table>'; } ?> </td> </tr> <tr> <td> <FONT SIZE=-1 FACE="Arial"><?php if ($pid) { echo $LDRegistryNr; } ?> </td> <td > <FONT SIZE=-1 FACE="Arial" color="#800000"> <?php if ($pid) { if (IS_TANZANIAN) { echo $this->showPID($pid); } else { echo $pid; } } ?> </td> <td rowspan=6 class="photo_id" > <FONT SIZE=-1 FACE="Arial"> <a href="#" onClick="showpic(document.aufnahmeform.photo_filename)"><img <?php echo $img_source; ?> id="headpic" name="headpic"></a> <br> <?php echo $LDPhoto; ?> <br><input name="photo_filename" type="file" size="15" onChange="showpic(this)" value="<?php if (isset($photo_filename)) { echo $photo_filename; } ?> "> </td> </tr> <tr> <td class="reg_item"> <?php echo $LDRegDate; ?> : </td> <td class="reg_input"> <FONT SIZE=-1 FACE="Arial" color="#800000"> <?php echo formatDate2Local($date_reg, $date_format, FALSE, FALSE, ''); ?> <input name="date_reg" type="hidden" value="<?php echo $date_reg; ?> "> </td> </tr> <tr> <td class="reg_item"> <?php echo $LDRegTime; ?> : </td> <td class="reg_input"> <FONT SIZE=-1 FACE="Arial" color="#800000"><?php echo convertTimeToLocal(formatDate2Local($date_reg, $date_format, 0, 1, '')); ?> </td> </tr> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php if ($person_obj->IsHospitalFileNrMandatory()) { $asterik = '*'; } else { $asterik = ' '; } if ($errorfilenr) { echo '<font color="#ff0000">*' . $LDFileNr . '</font><br> Try this one: ' . $person_obj->GetNewSelianFileNumber(); } else { echo $asterik . $LDFileNr; } ?> </td> <td class="reg_input"> <input type="text" name="selian_pid" size=14 maxlength=11 value="<?php echo $selian_pid; ?> " onFocus="this.select();"> </td> </tr> <?php $this->createTR($errornamefirst, 'name_first', ' *' . $LDFirstName, $name_first, '', '', FALSE); $this->createTR($errorname2, 'name_2', ' *' . $LDName2, $name_2, '', '', FALSE); $this->createTR($errornamelast, 'name_last', ' *' . $LDLastName, $name_last, '', '', FALSE); $this->createTR($errornamemid, 'name_middle', $LDNameMid, $name_middle, '', '', FALSE); // This is for balozi if (!$no_tribe) { ?> <tr> <td class="reg_item"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } echo '* ' . $LDNameMaiden; ?> </td> <td class="reg_input" colspan=1> <?php echo '<SELECT name="name_maiden" onChange="list_popup(this, \'tribe\');">'; echo '<OPTION value="-1" >' . $LDPleaseSelectTribe . '</OPTION>'; foreach ($tribe_array as $unit) { //if($update && (strtoupper($name_maiden) == strtoupper($unit[1]))) if (strtoupper($name_maiden) == strtoupper($unit[1])) { $check = 'selected'; } else { $check = ''; } echo '<OPTION value="' . $unit[1] . '" ' . $check . '>' . $unit[0] . '</OPTION>'; } // echo '<OPTION value="notinlist">NOT IN LIST</OPTION>'; echo '</SELECT>'; ?> </td> </tr> <?php } ?> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php if ($errordatebirth) { echo "<font color=red>"; } ?> * <?php echo $LDBday; ?> </font>: </td> <td class="reg_input"> <FONT SIZE=-1 FACE="Arial"> <input name="date_birth" type="text" size="15" maxlength=10 value="<?php if ($date_birth) { if ($mode == 'save' || $error || $error_person_exists) { echo $date_birth; } else { echo formatDate2Local($date_birth, $date_format); } } # Uncomment the following when the current date must be inserted # automatically at the start of each document /*else{ echo formatDate2Local(date('Y-m-d'),$date_format); }*/ ?> " onFocus="this.select();" onBlur="IsValidDate(this,'<?php echo $date_format; ?> ')" onKeyUp="setDate(this,'<?php echo $date_format; ?> ','<?php echo $lang; ?> ');"> <a href="javascript:show_calendar('aufnahmeform.date_birth','<?php echo $date_format; ?> ')"> <img <?php echo createComIcon($root_path, 'show-calendar.gif', '0', 'absmiddle'); ?> ></a> <font size=1>[ <?php $dfbuffer = "LD_" . strtr($date_format, ".-/", "phs"); echo ${$dfbuffer}; ?> ] </font><br> <input name="date_age" type="text" size="15" maxlength=10 value="" onKeyUp="setDatebyAge(this,this.form.date_birth,'<?php echo $date_format; ?> ','<?php echo $lang; ?> ')"> <font size=1> <?php echo $LDAge; ?> </font> </td> <td> </td> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"> <?php if ($errorsex) { echo "<font color=#ff0000>"; } echo '* ' . $LDSex . '</font>'; ?> :<td> <input name="sex" type="radio" value="m" <?php if ($sex == "m") { echo "checked"; } ?> ><?php echo $LDMale; ?> <input name="sex" type="radio" value="f" <?php if ($sex == "f") { echo "checked"; } ?> > <?php echo $LDFemale; if ($errorsex) { echo "</font>"; } # But patch 2004-03-10 # Clean blood group $blood_group = trim($blood_group); ?> </td> </tr> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php if ($errorreligion) { echo "<font color=red>"; } ?> * <?php echo $LDReligion; ?> : </td> <td class="reg_input"><?php echo '<SELECT name="religion" onChange="list_popup(this,\'religion\');">'; echo '<OPTION value="-1" >' . $LDSelectReligion . '</OPTION>'; foreach ($religion_array as $unit) { if (strtoupper($religion) == strtoupper($unit[1])) { $check = 'selected'; } else { $check = ''; } echo '<OPTION value="' . $unit[1] . '" ' . $check . '>' . $unit[0] . '</OPTION>'; } // echo '<OPTION value="notinlist">NOT IN LIST</OPTION>'; echo '</SELECT>'; ?> </td> </tr> <?php if (!$person_name_others_hide) { // $this->createTR($errornameothers, 'name_others', $LDNameOthers,$name_others); } ?> <!-- TODO: Kompletly not shown, or dependig on who is editing: Doctor, Lab? --> <!-- <tr> <td class="reg_item"> <?php echo $LDBloodGroup; ?> : </td> <td class="reg_input"> <FONT SIZE=-1 FACE="Arial"> <input name="blood_group" type="radio" value="A" <?php if ($blood_group == 'A') { echo 'checked'; } ?> ><?php echo $LDA; ?> <input name="blood_group" type="radio" value="B" <?php if ($blood_group == 'B') { echo 'checked'; } ?> ><?php echo $LDB; ?> <input name="blood_group" type="radio" value="AB" <?php if ($blood_group == 'AB') { echo 'checked'; } ?> ><?php echo $LDAB; ?> <input name="blood_group" type="radio" value="O" <?php if ($blood_group == 'O') { echo 'checked'; } ?> ><?php echo $LDO; ?> </td> <td> <?php echo $LDRHfactor; ?> <input name="rh" type="radio" value="pos" <?php if ($rh == 'pos') { echo 'checked'; } ?> ><?php echo $LDRHpos; ?> <input name="rh" type="radio" value="neg" <?php if ($rh == 'neg') { echo 'checked'; } ?> ><?php echo $LDRHneg; ?> </td> </tr> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php if ($errorcivil) { echo "<font color=red>"; } ?> <?php echo $LDCivilStatus; ?> </font>: </td> <td colspan=2 class="reg_input"> <FONT SIZE=-1 FACE="Arial"> <input name="civil_status" type="radio" value="single" <?php if ($civil_status == "single") { echo "checked"; } ?> ><?php echo $LDSingle; ?> <input name="civil_status" type="radio" value="married" <?php if ($civil_status == "married") { echo "checked"; } ?> ><?php echo $LDMarried; ?> <FONT SIZE=-1 FACE="Arial"> <input name="civil_status" type="radio" value="divorced" <?php if ($civil_status == "divorced") { echo "checked"; } ?> ><?php echo $LDDivorced; ?> <input name="civil_status" type="radio" value="widowed" <?php if ($civil_status == "widowed") { echo "checked"; } ?> ><?php echo $LDWidowed; ?> <FONT SIZE=-1 FACE="Arial"> <input name="civil_status" type="radio" value="separated" <?php if ($civil_status == "separated") { echo "checked"; } ?> ><?php echo $LDSeparated; ?> </td> </tr> --> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"> <?php echo $LDInsurance; ?> : </td> <td class="reg_input"> <?php // Create array of all insurances for GUI $coreObj->sql = "SELECT DISTINCT company_id,care_tz_company.name FROM care_tz_insurance\n\t\t\tINNER JOIN care_tz_company ON care_tz_insurance.company_id = care_tz_company.id\n\t\t\tWHERE cancel_flag='0'\n\t\t\tAND ( care_tz_insurance.start_date <= UNIX_TIMESTAMP() AND care_tz_insurance.end_date >= UNIX_TIMESTAMP())\n\t\t\t order by name asc "; $result = $db->Execute($coreObj->sql); $name_insurer_array = array(); while ($row = $result->FetchRow()) { $nr = $row['company_id']; if ($nr != -1) { $coreObj->sql = "SELECT name FROM care_tz_company WHERE ID={$nr}"; $ergebnis = $db->Execute($coreObj->sql); $row = $ergebnis->FetchRow(); $arrayTemp = array("name" => $row['name'], "id" => $nr); array_push($name_insurer_array, $arrayTemp); } } echo '<SELECT name="insurance_ID">'; echo '<OPTION value="-1" >--select insurance--</OPTION>'; foreach ($name_insurer_array as $row) { if ($insurance_ID == $row[id]) { $check = 'selected'; } else { $check = ''; } echo '<OPTION value="' . $row[id] . '" ' . $check . '>' . $row[name] . '</OPTION>'; } echo '</SELECT>'; ?> </td> </tr> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"> <?php echo '* ' . $LDFirstTimePat . '</font>'; ?> :</td> <td> <input name="is_first_reg" type="radio" value="1" <?php if ($is_first_reg == "1") { echo "checked"; } ?> ><?php echo $LDYes; ?> <input name="is_first_reg" type="radio" value="0" <?php if ($is_first_reg == "0") { echo "checked"; } ?> > <?php echo $LDNo; ?> </td> </tr> <?php $this->createTR($errormembership, 'membership_nr', $LDMembership_nr, $membership_nr, '', '', FALSE); ?> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDOccupation; ?> : </td> <td class="reg_input"> <input type="text" name="title" size=14 maxlength=25 value="<?php echo $title; ?> " onFocus="this.select();"> </td> </tr> <!--<tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php echo 'Allergy'; ?> : </td> <td class="reg_input"> <input type="text" name="allergy" size=14 maxlength=25 value="<?php echo $title; ?> " onFocus="this.select();"> </td> </tr> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDEducation; ?> : </td> <td class="reg_input"> <input type="text" name="name_others" size=14 maxlength=25 value="<?php echo $name_others; ?> " onFocus="this.select();"> </td> </tr> --> <!-- <tr> <td colspan=2> <FONT SIZE=-1 FACE="Arial"><?php if ($erroraddress) { echo "<font color=red>"; } echo $LDAddress; ?> </font>: </td> </tr> --> <?php if (!$person_email_hide) { //{ ?> <tr> <td class="reg_item"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } echo '* ' . 'Region'; $sql = "SELECT DISTINCT region_id, region_name FROM care_tz_region region INNER JOIN care_tz_district distrcit ON distrcit.is_additional=region.region_id INNER JOIN care_tz_ward ward ON distrcit.district_id=ward.is_additional ORDER BY region_name, district_name, ward_name"; //$sql="SELECT region_id,region_name FROM view_care_region_district_ward GROUP BY region_id order by region_name "; $catchment_area_obj = $db->Execute($sql); echo '</td> <td class="reg_input" colspan=1> <select name="region" size="1" onChange="getDistricts(this.value,\'dstr\');//redirect(this.options.selectedIndex)"> <option value="-1" id="-1">---select region--------</option>'; print ' <option value="27" id="27" style="background:yellow; font-weight:bold;">--Unknown--</option>'; while ($catchment_area_row = $catchment_area_obj->FetchRow()) { if ($catchment_area_row['region_id'] != 27) { echo '<option value="' . $catchment_area_row['region_id'] . '" >' . $catchment_area_row['region_name'] . '</option>'; } else { echo '<option value="' . $catchment_area_row['region_id'] . '" style="display:none;">' . $catchment_area_row['region_name'] . '</option>'; } } ?> </select> <?php } ?> </td> <?php if ($update) { ?> <td class="reg_input"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } $sql = "Select * from care_person where pid=" . $pid; $result = $db->Execute($sql); $region = $result->FetchRow(); echo '' . 'Region:<FONT SIZE=-1 FACE="Arial" color="#800000"> ' . ($region['region'] > 0 ? $cd_obj->GetRegionName($region['region']) : $region['region']) . '</FONT>'; ?> </td><?php } ?> </tr> <tr></tr> <tr> <td class="reg_item"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } echo '* ' . 'District'; ?> </td> <td class="reg_input" colspan=1 id="dstr"> <select name="district" size="1" id="district" onChange="redirect1(this.options.selectedIndex)"> <?php if (!isset($_POST['district'])) { ?> <option value="-1" >---select district--------</option> <?php } else { ?> <option value="<?php echo $_POST['district']; ?> " ><?php echo $_POST['district']; ?> </option> <?php } ?> </select> </td> <?php if ($update) { ?> <td class="reg_input"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } $sql = "Select district from care_person where pid=" . $pid; $result = $db->Execute($sql); $region = $result->FetchRow(); echo 'District: <FONT SIZE=-1 FACE="Arial" color="#800000">' . ($region['district'] > 0 ? $cd_obj->GetDistrictName($region['district']) : $region['district']) . '</FONT>'; ?> </td><?php } ?> </tr> <tr></tr> <tr> <td class="reg_item"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } echo '* ' . 'Ward'; ?> </td> <td class="reg_input" colspan=1 id="wrd"> <select name="ward" id="ward" size="1"> <?php if (!isset($_POST['ward'])) { ?> <option value="-1" >-select Ward-</option> <?php } else { ?> <option value="<?php echo $_POST['ward']; ?> " ><?php echo $_POST['ward']; ?> </option> <?php } ?> </select> <?php ?> <script language="javascript"> <?php // fill up all regions, districts and wards: $sql = "SELECT region_id, region_name, district_id, district_name, ward_id, ward_name FROM care_tz_region region INNER JOIN care_tz_district distrcit ON distrcit.is_additional=region.region_id INNER JOIN care_tz_ward ward ON distrcit.district_id=ward.is_additional ORDER BY region_name, district_name, ward_name"; $catchment_area_obj = $db->Execute($sql); $number_of_rows = $catchment_area_obj->RecordCount(); echo "var group=new Array(" . $number_of_rows . ")\n"; echo "for (i=0; i<" . $number_of_rows . "; i++)\n"; echo "group[i]=new Array()\n"; echo "group[0]= new Option(\"---select Region -----\");\n"; echo "group[0][0]=new Option(\"---select district--------\");\n"; echo "group[1][0]=new Option(\"now select this one\");\n"; echo "group[1][0][0]=new Option(\"-select Ward-\");\n"; // define some variables that eclipse will get no trouble by syntax error check... $previous_region_id = -1; $previous_district_id = -1; $region_id = 1; $district_id = 0; $ward_id = 0; // remember if it's the first row... $FIRST_ROW = TRUE; while ($catchment_area_row = $catchment_area_obj->FetchRow()) { // reading out all information of this row and store each to a variable $this_region_name = $catchment_area_row['region_name']; $this_district_name = $catchment_area_row['district_name']; $this_district_id = $catchment_area_row['district_id']; $this_ward_name = $catchment_area_row['ward_name']; $this_ward_id = $catchment_area_row['ward_id']; if ($FIRST_ROW == TRUE) { // it's the first row, the "this" is the same as the "previous" status $previous_region_id = $region_id; $previous_ward_id = $ward_id; $previous_district_id = $district_id; // if its the first row, so we can attach this line directly to the jscript-array: echo "group[" . $region_id . "][" . $district_id . "]=new Option(\"" . $this_district_name . "\");\n"; // "this" is no longer the first row, set it to FALSE $FIRST_ROW = FALSE; } else { // reading out all information of this row and store each to a variable $this_region_id = $catchment_area_row['region_id']; $this_region_name = $catchment_area_row['region_name']; $this_district_name = $catchment_area_row['district_name']; $this_district_id = $catchment_area_row['district_id']; // it is not the first row, so we have to be a bit more carefully if ($this_region_id == $previous_region_id) { // if its the same region ID like the previous one, so check if it's a new district as well: if ($this_district_id == $previous_district_id) { // if its the same district ID like the previous one, then we have a new ward echo "group[" . $region_id . "][" . $district_id . "][" . $ward_id . "]=new Option(\"" . $this_ward_name . "\"); // Ward_id=" . $this_ward_id . "\n"; $ward_id = $ward_id + 1; } else { $district_id = $district_id + 1; $previous_district_id = $this_district_id; $ward_id = 0; echo "group[" . $region_id . "][" . $district_id . "]=new Option(\"" . $this_district_name . "\"); //Region_id=" . $this_region_id . "\n"; } } else { // it's a new region, so reset the value of "this region" $district_id = 0; $region_id = $region_id + 1; echo "group[" . $region_id . "][" . $district_id . "]=new Option(\"" . $this_district_name . "\"); //Region_id=" . $this_region_id . "\n"; $previous_region_id = $this_region_id; } // end of if ($this_region_id==$previous_region_id) } // end of if ($FIRST_ROW==TRUE) } ?> var temp_district=document.aufnahmeform.district var temp_ward=document.aufnahmeform.ward <?php if (!empty($_POST['district'])) { echo "var MyDistrict='" . $_POST['district'] . "'\n"; } if (!empty($_POST['ward'])) { echo "var MyDistrict='" . $_POST['ward'] . "'\n"; } ?> function redirect(x){ // delete all previous entries for (m=temp_district.options.length-1;m>0;m--) temp_district.options[m]=null; // set the new ones to this option list for (i=1;i<group[x].length;i++){ temp_district.options[i]=new Option(group[x][i].text) // if (temp_district.options[i]==MyDistrict) { temp_district.options[i].selected=true // } } // if (len(MyDistrict)==0) temp_district.options[0].selected=true; temp_district.options[0].value=-1; redirect1(0) } function redirect1(y){ for (m=temp_ward.options.length-1;m>=0;m--) temp_ward.options[m]=null; var region_index = document.aufnahmeform.region.options.selectedIndex; var district_index = document.aufnahmeform.district.options.selectedIndex; var i = 0; for (i=0;i<100;i++){ temp_ward.options[i]=new Option(group[region_index][district_index][i].text) } temp_ward.options[0].selected=true temp_ward.options[0].value=-1; } </script> </td> <?php if ($update) { ?> <td class="reg_input"><FONT SIZE=-1 FACE="Arial,verdana,sans serif"> <?php if ($errormaiden) { echo '<font color="FF0000">'; } $sql = "Select * from care_person where pid=" . $pid; $result = $db->Execute($sql); $region = $result->FetchRow(); echo '' . 'Ward: <FONT SIZE=-1 FACE="Arial" color="#800000">' . ($region['ward'] > 0 ? $cd_obj->GetWardName($region['ward']) : $region['ward']) . '</FONT>'; ?> </td><?php } ?> <!--<tr> <td colspan=2> <FONT SIZE=-1 FACE="Arial"><?php if ($erroraddress) { echo "<font color=red>"; } echo $LDAddress; ?> </font>: </td> </tr>--> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php echo $LDTownCity; ?> : </td> <td class="reg_input"><input name="citizenship" type="text" value="<?php echo $citizenship; ?> " ></td> <!--<td class="reg_input"> <?php echo '<SELECT name="addr_citytown_nr" onChange="list_popup(this,\'city\');">'; echo '<OPTION value="-1" >-- select location --</OPTION>'; foreach ($town_array as $unit) { if (strtoupper($addr_citytown_nr) == strtoupper($unit[1])) { $check = 'selected'; } else { $check = ''; } echo '<OPTION value="' . $unit[1] . '" ' . $check . '>' . $unit[0] . '</OPTION>'; } // echo '<OPTION value="notinlist">NOT IN LIST</OPTION>'; echo '</SELECT>'; ?> </td> <td class="reg_input"> <FONT SIZE=-1 FACE="Arial"><?php if ($errorzip) { echo "<font color=red>"; } echo $LDPOBOX . " "; ?> <input name="addr_zip" type="text" size="10" value="<?php echo $addr_zip; ?> " > </td> </tr> --> <?php if ($insurance_show) { if (!$person_insurance_1_nr_hide) { ?> <!--<tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial"><?php if ($errorinsurancecoid) { echo '<font color="' . $error_fontcolor . '">'; } echo $LDInsuranceCo; ?> : </td> <td colspan=2 class="reg_input"><FONT SIZE=-1 FACE="Arial"><?php if ($errorinsuranceclass) { echo '<font color="' . $error_fontcolor . '">'; } ?> <input name="insurance_category" type="radio" value="silver" <?php if ($insurance_category == "silver") { echo 'checked'; } ?> > <?php echo $LDInsuranceSilver; ?> <input name="insurance_category" type="radio" value="gold" <?php if ($insurance_category == "gold") { echo 'checked'; } ?> > <?php echo $LDInsuranceGold; ?> <input name="insurance_category" type="radio" value="friedkin" <?php if ($insurance_category == "friedkin") { echo 'checked'; } ?> > <?php echo $LDInsuranceFriedkin; ?> <input name="insurance_category" type="radio" value="selian" <?php if ($insurance_category == "selian") { echo 'checked'; } ?> > <?php echo $LDInsuranceSelianstuff; ?> </td> </tr>--> <?php } } else { ?> <tr> <td colspan=2 class="reg_item"> <a><?php echo $LDSeveralInsurances; ?> <img <?php echo createComIcon($root_path, 'frage.gif', '0'); ?> ></a> </td> </tr> <?php } if (!$person_phone_1_nr_hide) { $this->createTR($errorphone1, 'phone_1_nr', $LDPhone, $phone_1_nr, 2); } /* if (!$person_cellphone_1_nr_hide){ $this->createTR($errorcell1, 'cellphone_1_nr', $LDCellPhone,$cellphone_1_nr,2); } if (!$person_cellphone_2_nr_hide){ $this->createTR($errorcell2, 'cellphone_2_nr', $LDCellPhone.' 2',$cellphone_2_nr,2); } if (!$person_religion_hide){ } */ ?> <!--<tr> <td class="reg_item" valign=top class="reg_input"> <?php echo $LDOtherHospitalNr; ?> </td> <td colspan=2 class="reg_input"> <?php /* $other_hosp_list = $person_obj->OtherHospNrList(); $sOtherNrBuffer=''; foreach( $other_hosp_list as $k=>$v ){ echo "<b>".$kb_other_his_array[$k].":</b> ".$v."<br />\n"; } echo '<SELECT name="other_his_org"> <OPTION value="">--</OPTION>'; foreach( $kb_other_his_array as $k=>$v ){ echo '<OPTION value="$k" $check>$v</OPTION>'; } echo '</SELECT> '.$LDNr.':<INPUT name="other_his_no" size=20><br>'; echo '('.$LDSelectOtherHospital.' - '.$LDNoNrNoDelete.')<br></TD></TR>'; */ ?> </td> </tr>--> <tr> <td class="reg_item"> <FONT SIZE=-1 FACE="Arial" ><FONT SIZE=2 FACE="Arial"><font color=#ff0000><?php echo $LDRegBy; ?> </font> </td> <td colspan=2 class="reg_input"> <FONT SIZE=-1 FACE="Arial"><nobr> <input name="user_id" type="text" value="<?php if (isset($user_id) && $user_id) { echo $user_id; } else { echo $_SESSION['sess_user_name']; } ?> " size="35" readonly> </nobr> </td> </tr> </table> <p> <INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000"> <input type="hidden" name="itemname" value="<?php echo $itemname; ?> "> <input type="hidden" name="sid" value="<?php echo $sid; ?> "> <input type="hidden" name="lang" value="<?php echo $lang; ?> "> <input type="hidden" name="linecount" value="<?php echo $linecount; ?> "> <input type="hidden" name="mode" value="save"> <input type="hidden" name="insurance_item_nr" value="<?php echo $insurance_item_nr; ?> "> <input type="hidden" name="insurance_firm_id" value="<?php echo $insurance_firm_id; ?> "> <input type="hidden" name="insurance_show" value="<?php echo $insurance_show; ?> "> <input type="hidden" name="ethnic_orig" value="<?php echo $ethnic_orig; ?> "> <?php if ($update) { echo '<input type="hidden" name="update" value=1>'; echo '<input type="hidden" name="pid" value="' . $pid . '">'; } ?> <input type="image" <?php echo createLDImgSrc($root_path, 'savedisc.gif', '0'); ?> alt="<?php echo $LDSaveData; ?> " align="absmiddle"> <a href="javascript:document.aufnahmeform.reset()"><img <?php echo createLDImgSrc($root_path, 'reset.gif', '0'); ?> alt="<?php echo $LDResetData; ?> " align="absmiddle"></a> <?php //if($error||$error_person_exists) echo '<input type="button" value="'.$LDForceSave.'" onClick="forceSave()">'; ?> </form> <?php if (!$newdata) { ?> <form action=<?php echo $thisfile; ?> method=post> <input type=hidden name=sid value=<?php echo $sid; ?> > <input type=hidden name=patnum value=""> <input type=hidden name="lang" value="<?php echo $lang; ?> "> <input type=hidden name="date_format" value="<?php echo $date_format; ?> "> <input type=submit value="<?php echo $LDNewForm; ?> " > </form> <?php } }