function Query($query)
{
global $link;
if (!($result = mysql_query($query, $link))) {
$ErrMsg = "Bad query to database {$DBName}: Error Number " . mysql_errno() . "<br>" . mysql_error();
DisplayErrMsg($ErrMsg);
echo "The bad query is {$query}\n";
exit;
}
return $result;
}
require "../globals.php";
require "./common.php";
require "./php/includes/setup.php";
$table_selector_category = 'selector_categorie';
$category_Stmt = "SELECT * from {$table_selector_category}\n order by {$table_selector_category}.omschrijving";
// Connect to the Database
$link = new mysqli($hostName, $userName, $password, $databaseName);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
if (!($result_category = $link->query($category_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $category_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
$table_category = '';
$j = 0;
while ($field_category = $result_category->fetch_object()) {
$b = $j % 2;
$bgcolor = '';
if ($b == 0) {
$bgcolor = '#B8E7FF';
}
$table_data = new Smarty_NM();
if ($j == 0) {
$table_category = $table_data->fetch("category_header.tpl");
}
$action = sprintf("new_category.php?pk=%d&t=%d", $field_category->pk, time());
//Instance
if ($constraint == 'Add_Instance' || $constraint == 'Modify_Instance') {
$instance = new Smarty_NM();
if ($selector_instance_fk <= 0) {
$table_instance = $instance->fetch("constraint_instance.tpl");
}
if ($selector_instance_fk > 0) {
$table_instance = 'selector_instance';
$instance_Stmt = "SELECT * from {$table_instance} where\n {$table_instance}.pk='{$selector_instance_fk}'";
if (!($result_instance = $link->query($instance_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $student_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
if (!($field_instance = $result_instance->fetch_object())) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
//personal_instance
$table_instance = '';
$instance->assign("default_sop_iuid", $field_instance->sop_iuid);
$instance->assign("default_sop_cuid", $field_instance->sop_cuid);
$instance->assign("default_inst_no", $field_instance->inst_no);
$instance->assign("default_content_datetime", $field_instance->content_datetime);
$instance->assign("default_sr_complete", $field_instance->sr_complete);
$instance->assign("default_sr_verified", $field_instance->sr_verified);
$instance->assign("default_inst_custom1", $field_instance->inst_custom1);
$instance->assign("default_inst_custom2", $field_instance->inst_custom2);
$instance->assign("default_inst_custom3", $field_instance->inst_custom3);
$instance->assign("default_ext_retr_aet", $field_instance->ext_retr_aet);
$instance->assign("default_retrieve_aets", $field_instance->retrieve_aets);
$updateStmt = "Update {$tableName} set NAME='{$cn}', EMAIL='{$mail}', CITY='{$locality}',\nDESCRIPTION='{$description}', TELEPHONE='{$telephonenumber}' WHERE ROWID='{$rowid}'";
//echo "updatstmt= $updateStmt";
// open a pesistent connection with database server
if (!($link = mysql_pconnect($hostName, $userName, $password))) {
DisplayErrMsg(sprintf("error connecting to host %s, by user %s", $hostName, $userName));
exit;
}
//select the database
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error in selecting %s database", $databaseName));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
if (!mysql_query($updateStmt, $link)) {
DisplayErrMsg(sprintf("error in executing %s stmt", $updateStmt));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
//echo "failed";
exit;
}
GenerateHTMLHeader("The Entry was modified successfully");
ReturnToMain();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
function check_qc_frequency($link, $gewenste_processen_array)
{
if (empty($gewenste_processen_array)) {
return -1;
}
$gewenste_processen = implode(",", $gewenste_processen_array);
$query = "SELECT creation_time,qc_frequentie from gewenste_processen \n inner join selector on gewenste_processen.selector_fk=selector.pk\n where gewenste_processen.pk in ({$gewenste_processen})";
if (!($result = $link->query($query))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $query));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
$qc_freq_status = true;
while ($field = $result->fetch_object()) {
if ((strtotime(date("Y-m-d H:i:s")) - strtotime($field->creation_time)) / (60 * 60 * 24) > $field->qc_frequentie) {
$qc_freq_status = false;
}
}
return $qc_freq_status;
}
function selector_function_pssi($pk, $selector_patient_pk, $selector_study_pk, $selector_series_pk, $selector_instance_pk, &$table_pssi)
{
require "../globals.php";
//require("./php/includes/setup.php");
// Connect to the Database
$link = new mysqli($hostName, $userName, $password, $databaseName);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
$patient_header = "";
$study_header = "";
$series_header = "";
$instance_header = "";
if ($selector_patient_pk > 0) {
$patient_header = "Patient";
$patient = new Smarty_NM();
$table_patient = 'selector_patient';
$patient_Stmt = "SELECT * from {$table_patient} where\n {$table_patient}.pk='{$selector_patient_pk}'";
if (!($result_patient = $link->query($patient_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $student_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
if (!($field_patient = $result_patient->fetch_object())) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
//personal_patient
$table_patient = '';
$patient->assign("default_pat_id", $field_patient->pat_id);
$patient->assign("default_pat_id_issuer", $field_patient->pat_id_issuer);
$patient->assign("default_pat_name", $field_patient->pat_name);
$patient->assign("default_pat_fn_sx", $field_patient->pat_fn_sx);
$patient->assign("default_pat_gn_sx", $field_patient->pat_gn_sx);
$patient->assign("default_pat_i_name", $field_patient->pat_i_name);
$patient->assign("default_pat_p_name", $field_patient->pat_p_name);
$patient->assign("default_pat_birthdate", $field_patient->pat_birthdate);
$patient->assign("default_pat_sex", $field_patient->pat_sex);
$patient->assign("default_pat_custom1", $field_patient->pat_custom1);
$patient->assign("default_pat_custom2", $field_patient->pat_custom2);
$patient->assign("default_pat_custom3", $field_patient->pat_custom3);
$result_patient->close();
$table_patient = $patient->fetch("selector_patient.tpl");
}
// end patient_ref
if ($selector_study_pk > 0) {
$study_header = "Study";
$study = new Smarty_NM();
$table_study = 'selector_study';
$study_Stmt = "SELECT * from {$table_study} where\n {$table_study}.pk='{$selector_study_pk}'";
if (!($result_study = $link->query($study_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $student_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
if (!($field_study = $result_study->fetch_object())) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
//personal_study
$table_study = '';
$study->assign("default_study_iuid", $field_study->study_iuid);
$study->assign("default_study_id", $field_study->study_id);
$study->assign("default_study_datetime", $field_study->study_datetime);
$study->assign("default_accession_no", $field_study->accession_no);
$study->assign("default_ref_physician", $field_study->ref_physician);
$study->assign("default_ref_phys_fn_sx", $field_study->ref_phys_fn_sx);
$study->assign("default_ref_phys_gn_sx", $field_study->ref_phys_gn_sx);
$study->assign("default_ref_phys_i_name", $field_study->ref_phys_i_name);
$study->assign("default_ref_phys_p_name", $field_study->ref_phys_p_name);
$study->assign("default_study_desc", $field_study->study_desc);
$study->assign("default_study_custom1", $field_study->study_custom1);
$study->assign("default_study_custom2", $field_study->study_custom2);
$study->assign("default_study_custom3", $field_study->study_custom3);
$study->assign("default_study_status_id", $field_study->study_status_id);
$study->assign("default_mods_in_study", $field_study->mods_in_study);
$study->assign("default_cuids_in_study", $field_study->cuids_in_study);
$study->assign("default_num_series", $field_study->num_series);
$study->assign("default_num_instances", $field_study->num_instances);
$study->assign("default_ext_retr_aet", $field_study->ext_retr_aet);
$study->assign("default_retrieve_aets", $field_study->retrieve_aets);
$study->assign("default_fileset_iuid", $field_study->fileset_iuid);
$study->assign("default_fileset_id", $field_study->fileset_id);
$study->assign("default_availability", $field_study->availability);
$study->assign("default_study_status", $field_study->study_status);
$study->assign("default_checked_time", $field_study->checked_time);
$study->assign("default_updated_time", $field_study->updated_time);
$study->assign("default_created_time", $field_study->created_time);
$study->assign("default_updated_time", $field_study->updated_time);
$study->assign("default_study_attrs", $field_study->study_attrs);
$result_study->close();
$table_study = $study->fetch("selector_study.tpl");
}
// end study_ref
if ($selector_series_pk > 0) {
$series_header = "Series";
$series = new Smarty_NM();
$table_series = 'selector_series';
$series_Stmt = "SELECT * from {$table_series} where\n {$table_series}.pk='{$selector_series_pk}'";
if (!($result_series = $link->query($series_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $student_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
if (!($field_series = $result_series->fetch_object())) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
//personal_series
$table_series = '';
$series->assign("default_series_iuid", $field_series->series_iuid);
$series->assign("default_series_no", $field_series->series_no);
$series->assign("default_modality", $field_series->modality);
$series->assign("default_body_part", $field_series->body_part);
$series->assign("default_laterality", $field_series->laterality);
$series->assign("default_series_desc", $field_series->series_desc);
$series->assign("default_institution", $field_series->institution);
$series->assign("default_station_name", $field_series->station_name);
$series->assign("default_department", $field_series->department);
$series->assign("default_perf_physician", $field_series->perf_physician);
$series->assign("default_perf_phys_fn_sx", $field_series->perf_phys_fn_sx);
$series->assign("default_perf_phys_gn_sx", $field_series->perf_phys_gn_sx);
$series->assign("default_perf_phys_i_name", $field_series->perf_phys_i_name);
$series->assign("default_perf_phys_p_name", $field_series->perf_phys_p_name);
$series->assign("default_pps_start", $field_series->pps_start);
$series->assign("default_pps_iuid", $field_series->pps_iuid);
$series->assign("default_series_custom1", $field_series->series_custom1);
$series->assign("default_series_custom2", $field_series->series_custom2);
$series->assign("default_series_custom3", $field_series->series_custom3);
$series->assign("default_num_instances", $field_series->num_instances);
$series->assign("default_src_aet", $field_series->src_aet);
$series->assign("default_ext_retr_aet", $field_series->ext_retr_aet);
$series->assign("default_retrieve_aets", $field_series->retrieve_aets);
$series->assign("default_fileset_iuid", $field_series->fileset_iuid);
$series->assign("default_fileset_id", $field_series->fileset_id);
$series->assign("default_availability", $field_series->availability);
$series->assign("default_series_status", $field_series->series_status);
$series->assign("default_created_time", $field_series->created_time);
$series->assign("default_updated_time", $field_series->updated_time);
$series->assign("default_series_attrs", $field_series->series_attrs);
$table_series = $series->fetch("selector_series.tpl");
}
// end series_ref
if ($selector_instance_pk > 0) {
$instance_header = "Instance";
$instance = new Smarty_NM();
$table_instance = 'selector_instance';
$instance_Stmt = "SELECT * from {$table_instance} where\n {$table_instance}.pk='{$selector_instance_pk}'";
if (!($result_instance = $link->query($instance_Stmt))) {
DisplayErrMsg(sprintf("Error in executing %s stmt", $student_Stmt));
DisplayErrMsg(sprintf("error: %s", $link->error));
exit;
}
if (!($field_instance = $result_instance->fetch_object())) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
//personal_instance
$table_instance = '';
$instance->assign("default_sop_iuid", $field_instance->sop_iuid);
$instance->assign("default_sop_cuid", $field_instance->sop_cuid);
$instance->assign("default_inst_no", $field_instance->inst_no);
$instance->assign("default_content_datetime", $field_instance->content_datetime);
$instance->assign("default_sr_complete", $field_instance->sr_complete);
$instance->assign("default_sr_verified", $field_instance->sr_verified);
$instance->assign("default_inst_custom1", $field_instance->inst_custom1);
$instance->assign("default_inst_custom2", $field_instance->inst_custom2);
$instance->assign("default_inst_custom3", $field_instance->inst_custom3);
$instance->assign("default_ext_retr_aet", $field_instance->ext_retr_aet);
$instance->assign("default_retrieve_aets", $field_instance->retrieve_aets);
$instance->assign("default_availability", $field_instance->availability);
$instance->assign("default_inst_status", $field_instance->inst_status);
$instance->assign("default_all_attrs", $field_instance->all_attrs);
$instance->assign("default_commitment", $field_instance->commitment);
$instance->assign("default_archived", $field_instance->archived);
$instance->assign("default_updated_time", $field_instance->updated_time);
$instance->assign("default_created_time", $field_instance->created_time);
$instance->assign("default_inst_attrs", $field_instance->inst_attrs);
$result_instance->close();
$table_instance = $instance->fetch("selector_instance.tpl");
}
// end instance_ref
$selector_pssi = new Smarty_NM();
$selector_pssi->assign("patient_header", $patient_header);
$selector_pssi->assign("study_header", $study_header);
$selector_pssi->assign("series_header", $series_header);
$selector_pssi->assign("instance_header", $instance_header);
$selector_pssi->assign("table_patient", $table_patient);
$selector_pssi->assign("table_series", $table_series);
$selector_pssi->assign("table_study", $table_study);
$selector_pssi->assign("table_instance", $table_instance);
$table_pssi = $selector_pssi->fetch("constraints_pssi.tpl");
}
