function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
$vId = @$vValues['id'];
$vRecord = array();
if (!empty($vId)) {
$vRecord['id'] = $vId;
} else {
$vRecord['create_time'] = $vDB->ConvertToDateTime(time());
$vRecord['next_visit_date'] = $vDB->ConvertToDate(time());
}
$vRecord['modify_time'] = $vDB->ConvertToDateTime(time());
CopyRecordStrValue($vRecord, $vValues, 'last_name');
CopyRecordStrValue($vRecord, $vValues, 'first_name');
CopyRecordStrValue($vRecord, $vValues, 'patr_name');
/* Здесь нужна проверка введенных данных в поле ПОЛИС СМО*/
$vResult = $vDB->InsertOrUpdateById('emst_cases', $vRecord);
// var_dump($vRecord);
// var_dump($vDB);
return $vResult;
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructSurgeriesQuery($vDB, $_GET);
$vShowDiagnosis = @$_GET['show_diagnosis'];
$vShowCure = @$_GET['show_cure'];
$vTab =& new TTable($vTable, 'emst_surgeries.*, ' . 'emst_cases.first_name, emst_cases.last_name, emst_cases.patr_name, emst_cases.born_date, emst_cases.is_male', $vFilter, $vOrder, 'case_id');
$vTab->AddColumn('case_id', '№', array('align' => 'right'));
$vTab->AddDateColumn('date', 'Дата и время приёма');
$vTab->AddColumn('user_id', 'Врач', array('align' => 'left', 'fmt' => 'tcfUserName'));
$vTab->AddColumn('id', 'Фамилия Имя Отчество', array('align' => 'left', 'fmt' => 'tcfName'));
// $vTab->AddColumn('date', 'Дата рождения, полных лет', array('align'=>'left', 'fmt'=>'tcfBornDate'));
// $vTab->AddColumn('is_male', 'Пол', array('align'=>'center', 'fmt'=>'tcfSex'));
$vTab->AddTextColumn('objective', 'Объективный статус');
if ($vShowDiagnosis) {
$vTab->AddTextColumn('diagnosis', 'Диагноз');
}
// $vTab->AddColumn('diagnosis_mkb', 'МКБ');
if ($vShowCure) {
$vTab->AddTextColumn('cure', 'Лечение');
}
$vTab->AddRowAction('изменение', 'case_edit.html?id=', '../images/edit_24x24.gif', 24, 24);
$vTab->AddRowAction('печать', '../reg/case.pdf?id=', '../images/print_24x24.gif', 24, 24);
$vFilter = array();
CopyRecordRefValue($vFilter, $_GET, 'case_id');
CopyRecordRefValue($vFilter, $_GET, 'doctor_id');
CopyRecordStrValue($vFilter, $_GET, 'first_name');
CopyRecordStrValue($vFilter, $_GET, 'last_name');
CopyRecordStrValue($vFilter, $_GET, 'patr_name');
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
// $vTab->AddTableAction('печать', CompoundURL('cases_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, GetPageIdxOrLast(), 20);
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
// $vId = $vValues['id'];
$vRecord = array();
if (!empty($vValues['id'])) {
$vRecord['id'] = $vValues['id'];
}
CopyRecordStrValue($vRecord, $vValues, 'name');
CopyRecordBoolValue($vRecord, $vValues, 'need_ill_doc');
$vResult = $vDB->InsertOrUpdateById('rb_employment_categories', $vRecord);
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
// $vId = $vValues['id'];
$vRecord = array();
if (!empty($vValues['id'])) {
$vRecord['id'] = $vValues['id'];
}
CopyRecordStrValue($vRecord, $vValues, 'name');
$vResult = $vDB->InsertOrUpdateById('rb_directions', $vRecord);
// var_dump($vRecord);
// var_dump($vDB);
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
$vRecord = array();
if (!empty($vValues['id'])) {
$vRecord['id'] = $vValues['id'];
}
CopyRecordStrValue($vRecord, $vValues, 'name');
CopyRecordBoolValue($vRecord, $vValues, 'can_skip_ill_doc_on_disability');
CopyRecordBoolValue($vRecord, $vValues, 'can_use_ill_doc_in_ability');
CopyRecordBoolValue($vRecord, $vValues, 'req_epicrisis');
$vResult = $vDB->InsertOrUpdateById('rb_clinical_outcomes', $vRecord);
return $vResult;
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TCasesTable($vTable, 'emst_cases.*,' . gCaseWithBadDoc . ' as is_bad_docs,' . gCaseHasIllDoc . ' as has_ill_doc', $vFilter, $vOrder);
$vTab->AddBoolColumn('has_ill_doc', 'С б/л');
$vTab->AddBoolColumn('is_bad_docs', 'Пробл. с док.');
$vTab->AddRowAction('приём', 'accept.html?id=', '../images/sugrery_24x24.gif', 24, 24);
$vTab->AddRowAction('изменение', 'case_edit.html?id=', '../images/edit_24x24.gif', 24, 24);
$vTab->AddRowAction('печать', '../reg/case.pdf?id=', '../images/print_24x24.gif', 24, 24);
// $vTab->AddRowAction('"заключение..."', '/info/conclusion.html?id=');
// $vTab->AddTableAction('новая', 'case_edit.html');
$vFilter = array();
CopyRecordRefValue($vFilter, $_GET, 'case_id');
CopyRecordStrValue($vFilter, $_GET, 'first_name');
CopyRecordStrValue($vFilter, $_GET, 'last_name');
CopyRecordStrValue($vFilter, $_GET, 'patr_name');
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
// $vTab->AddTableAction('печать', CompoundURL('cases_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, GetPageIdxOrLast(), 20);
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
// $vId = $vValues['id'];
$vRecord = array();
if (!empty($vValues['id'])) {
$vRecord['id'] = $vValues['id'];
}
CopyRecordStrValue($vRecord, $vValues, 'login');
CopyRecordStrValue($vRecord, $vValues, 'full_name');
CopyRecordStrValue($vRecord, $vValues, 'password');
CopyRecordStrValue($vRecord, $vValues, 'eisCode');
CopyRecordSelValue($vRecord, $vValues, 'roles');
CopyRecordBoolValue($vRecord, $vValues, 'retired');
$vResult = $vDB->InsertOrUpdateById('users', $vRecord);
// var_dump($vRecord);
// var_dump($vDB);
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return false;
}
$vDB = GetDB();
$vValues =& $this->getSubmitValues();
$vID = @$vValues['id'];
$vRecord = array();
if (!empty($vID)) {
$vRecord['id'] = $vID;
}
CopyRecordRefValue($vRecord, $vValues, 'user_id');
CopyRecordRefValue($vRecord, $vValues, 'case_id');
CopyRecordDateValue($vRecord, $vValues, 'date');
// CopyRecordStrValue($vRecord, $vValues, 'objective');
CopyRecordStrValue($vRecord, $vValues, 'area');
CopyRecordStrValue($vRecord, $vValues, 'diagnosis');
CopyRecordBoolValue($vRecord, $vValues, 'done');
CopyRecordStrValue($vRecord, $vValues, 'description');
$vResult = $vDB->InsertOrUpdateById('emst_rg', $vRecord);
if (empty($vID) && !empty($vResult)) {
$this->_submitValues['id'] = $vResult;
$this->getElement('id')->setValue($vResult);
$vRecord['id'] = $vResult;
$_SESSION['_rg_dir_backup'] = $vRecord;
}
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return false;
}
$vDB = GetDB();
$vValues =& $this->getSubmitValues();
$vID = @$vValues['id'];
$vRecord = array();
if (!empty($vID)) {
$vRecord['id'] = $vID;
}
CopyRecordRefValue($vRecord, $vValues, 'case_id');
CopyRecordDateValue($vRecord, $vValues, 'beg_date');
CopyRecordDateValue($vRecord, $vValues, 'end_date');
CopyRecordStrValue($vRecord, $vValues, 'name');
CopyRecordStrValue($vRecord, $vValues, 'diagnosis');
CopyRecordStrValue($vRecord, $vValues, 'operation');
CopyRecordStrValue($vRecord, $vValues, 'recommendation');
CopyRecordStrValue($vRecord, $vValues, 'notes');
//
// var_dump($this);
//
$vResult = $vDB->InsertOrUpdateById('emst_hospitals', $vRecord);
if (empty($vID) && $vResult) {
$this->_submitValues['id'] = $vResult;
}
return $vResult;
}
function &loadDefaults()
{
global $gAddTodaySugrery;
$vDB = GetDB();
$vID = @$_GET['id'];
if (!empty($vID)) {
$vBaseInfo = $vDB->GetById('emst_cases', $vID);
if (!is_array($vBaseInfo)) {
$vBaseInfo = array();
}
} else {
$vBaseInfo = array();
$vBaseInfo['create_time'] = $vDB->ConvertToDateTime(time());
$vBaseInfo['next_visit_date'] = $vDB->ConvertToDate(time());
CopyRecordStrValue($vBaseInfo, $_GET, 'first_name');
CopyRecordStrValue($vBaseInfo, $_GET, 'last_name');
CopyRecordStrValue($vBaseInfo, $_GET, 'patr_name');
}
$vResult = array();
$vResult['BaseInfo'] =& $vBaseInfo;
if (!empty($vID)) {
$vSurgeries =& $vDB->SelectList('emst_surgeries', '*', $vDB->CondEqual('case_id', $vID), 'date, id');
// order
} else {
$vSurgeries = array();
}
$vNow = $vDB->ConvertToDateTime(time());
$vToday = ExtractWord($vNow, ' ', 0);
$vCount = count($vSurgeries);
if ($gAddTodaySugrery && ($vCount == 0 || ExtractWord($vSurgeries[$vCount - 1]['date'], ' ', 0) != $vToday)) {
$vSurgeries[] = array('date' => $vNow);
if ($vCount == 0) {
if (@DateIsEmpty($vBaseInfo['accident_datetime'])) {
$vBaseInfo['accident_datetime'] = $vToday;
}
$vBaseInfo['disability_from_date'] = $vToday;
$vSurgeries[$vCount]['objective'] = 'Общее состояние удовлетворительное';
} else {
CopyValues($vSurgeries[$vCount], $vSurgeries[$vCount - 1], array('complaints', 'dynamic_id', 'diagnosis', 'diagnosis_mkb', 'disability', 'ill_refused', 'ill_sertificat', 'ill_doc', 'ill_doc_is_continue', 'ill_beg_date', 'ill_end_date', 'next_cec_date'));
if (!empty($vSurgeries[$vCount - 1]['ill_doc_new'])) {
$vSurgeries[$vCount]['ill_doc'] = $vSurgeries[$vCount - 1]['ill_doc_new'];
$vSurgeries[$vCount]['ill_doc_is_continue'] = true;
}
if ($vSurgeries[$vCount - 1]['ill_end_date'] == $vToday) {
$vSurgeries[$vCount]['ill_beg_date'] = DateAddDay($vSurgeries[$vCount - 1]['ill_end_date']);
$vSurgeries[$vCount]['ill_end_date'] = '';
}
$vObjectiveList = array();
$vClinicalOutcomeID = $vSurgeries[$vCount - 1]['clinical_outcome_id'];
if (!empty($vClinicalOutcomeID)) {
$vList = GetClinicalOutcomesList();
$vObjectiveList[] = 'На предыдущем приёме был установлен исход "' . $vList[$vClinicalOutcomeID] . '". явку объясняет тем, что ... ';
}
$vNextVisitDate = $vSurgeries[$vCount - 1]['next_visit_date'];
if ($vNextVisitDate != '0000-00-00' && $vNextVisitDate < $vToday) {
$vObjectiveList[] = 'На приём ' . Date2ReadableLong($vNextVisitDate) . " не явился, объясняет это тем, что ... ";
}
$vObjectiveList[] = 'Общее состояние удовлетворительное';
$vSurgeries[$vCount]['objective'] = implode(".\n", $vObjectiveList);
CopyValues($vSurgeries[$vCount], $vSurgeries[$vCount - 1], array('cure'));
/*
CopyValues($vSurgeries[$vCount],
$vSurgeries[$vCount-1],
array('objective', 'cure', 'notes'));
*/
for ($i = $vCount - 1; $i >= 0; $i--) {
if ($vSurgeries[$i]['is_cec']) {
$vSurgeries[$vCount]['next_cec_date'] = $vSurgeries[$i]['cec_cureup_date'];
break;
}
}
if ($vSurgeries[$vCount - 1]['next_cec_date'] == $vToday) {
$vSurgeries[$vCount]['is_cec'] = 1;
}
}
$vSurgeries[$vCount]['user_id'] = $_SESSION['User.ID'];
}
$vCount = count($vSurgeries);
$vResult['surgeries'] =& $vSurgeries;
for ($i = 0; $i < $vCount; $i++) {
$vResult[DatePageName($i)] =& $vSurgeries[$i];
}
// CopyValues($vSurgeries[0], $vBaseInfo, array('accident', 'accident_datetime', 'accident_place', 'antitetanus_id', 'antitetanus_series', 'phone_message_required', 'ice_trauma', 'animal_bite_trauma', 'ixodes_trauma', 'message_number', 'diagnosis', 'diagnosis_mkb', 'disability_from_date'));
if ($vCount > 0) {
CopyValues($vSurgeries[0], $vBaseInfo, array('accident', 'accident_datetime', 'accident_place', 'antitetanus_id', 'antitetanus_series', 'phone_message_required', 'ice_trauma', 'animal_bite_trauma', 'ixodes_trauma', 'message_number', 'disability_from_date'));
}
$vResult['MiscDocs']['studinfo_freed_beg_date'] = @$vBaseInfo['create_time'];
$vResult['MiscDocs']['studinfo_freed_end_date'] = $vToday;
$vResult['html_referer'] = $_SESSION['PrevPage'];
return $vResult;
}
function Save()
{
if (!$this->validate()) {
return FALSE;
}
$vDB = GetDB();
$vValues = $this->getSubmitValues(TRUE);
$vId = @$vValues['id'];
$vRecord = array();
if (!empty($vId)) {
$vRecord['id'] = $vId;
} else {
$vRecord['create_time'] = $vDB->ConvertToDateTime(time());
$vRecord['next_visit_date'] = $vDB->ConvertToDate(time());
}
$vRecord['modify_time'] = $vDB->ConvertToDateTime(time());
CopyRecordStrValue($vRecord, $vValues, 'last_name');
CopyRecordStrValue($vRecord, $vValues, 'first_name');
CopyRecordStrValue($vRecord, $vValues, 'patr_name');
CopyRecordBoolValue($vRecord, $vValues, 'is_male');
CopyRecordDateValue($vRecord, $vValues, 'born_date');
CopyRecordRefValue($vRecord, $vValues, 'doc_type_id');
CopyRecordStrValue($vRecord, $vValues, 'doc_series');
CopyRecordStrValue($vRecord, $vValues, 'doc_number');
CopyRecordRefValue($vRecord, $vValues, 'insurance_company_id');
CopyRecordStrValue($vRecord, $vValues, 'polis_series');
CopyRecordStrValue($vRecord, $vValues, 'polis_number');
CopyRecordDateValue($vRecord, $vValues, 'patient_polis_from');
CopyRecordDateValue($vRecord, $vValues, 'patient_polis_to');
CopyRecordStrValue($vRecord, $vValues, 'paytype');
CopyRecordStrValue($vRecord, $vValues, 'addr_reg_street');
CopyRecordStrValue($vRecord, $vValues, 'addr_reg_num');
CopyRecordStrValue($vRecord, $vValues, 'addr_reg_subnum');
CopyRecordStrValue($vRecord, $vValues, 'addr_reg_apartment');
CopyRecordStrValue($vRecord, $vValues, 'addr_phys_street');
CopyRecordStrValue($vRecord, $vValues, 'addr_phys_num');
CopyRecordStrValue($vRecord, $vValues, 'addr_phys_subnum');
CopyRecordStrValue($vRecord, $vValues, 'addr_phys_apartment');
CopyRecordStrValue($vRecord, $vValues, 'phone');
CopyRecordRefValue($vRecord, $vValues, 'employment_category_id');
CopyRecordStrValue($vRecord, $vValues, 'employment_place');
CopyRecordStrValue($vRecord, $vValues, 'profession');
CopyRecordRefValue($vRecord, $vValues, 'trauma_type_id');
CopyRecordStrValue($vRecord, $vValues, 'notes');
CopyRecordStrValue($vRecord, $vValues, 'accident');
CopyRecordDateTimeValue($vRecord, $vValues, 'accident_datetime');
CopyRecordStrValue($vRecord, $vValues, 'accident_place');
CopyRecordBoolValue($vRecord, $vValues, 'phone_message_required');
CopyRecordBoolValue($vRecord, $vValues, 'ice_trauma');
CopyRecordBoolValue($vRecord, $vValues, 'animal_bite_trauma');
CopyRecordBoolValue($vRecord, $vValues, 'ixodes_trauma');
CopyRecordStrValue($vRecord, $vValues, 'message_number');
/* Здесь нужна проверка введенных данных в поле ПОЛИС СМО*/
$vResult = $vDB->InsertOrUpdateById('emst_cases', $vRecord);
// var_dump($vRecord);
// var_dump($vDB);
return $vResult;
}
$vView =& new TBaseView();
$vView->form = $vRenderer->toObject();
$vValues =& $vForm->_submitValues;
$vParams = array();
$vParams['pdfpage'] = 'info/conclusion.pdf';
CopyRecordRefValue($vParams, $vValues, 'case_id');
CopyRecordRefValue($vParams, $vValues, 'doctor_id');
CopyRecordStrValue($vParams, $vValues, 'create_time');
CopyRecordStrValue($vParams, $vValues, 'last_name');
CopyRecordStrValue($vParams, $vValues, 'first_name');
CopyRecordStrValue($vParams, $vValues, 'patr_name');
CopyRecordDateValue($vParams, $vValues, 'born_date');
CopyRecordStrValue($vParams, $vValues, 'employment_place');
CopyRecordStrValue($vParams, $vValues, 'profession');
CopyRecordStrValue($vParams, $vValues, 'diagnosis');
CopyRecordStrValue($vParams, $vValues, 'diagnosis_mkb');
CopyRecordRefValue($vParams, $vValues, 'heavity');
$vView->popup_url = CompoundURL('produce_pdf.html', $vParams);
$vTemplate->compile('info/conclusion.html');
$vTemplate->outputObject($vView);
break;
default:
$vTemplate =& CreateTemplate();
$vRenderer =& CreateRenderer($vTemplate);
$vForm->accept($vRenderer);
$vView =& new TBaseView();
$vView->form = $vRenderer->toObject();
$vTemplate->compile('info/conclusion.html');
$vTemplate->outputObject($vView);
break;
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructSurgeriesQuery($vDB, $_GET);
$vTab =& new TTable($vTable, 'emst_surgeries.*, ' . 'emst_cases.first_name, emst_cases.last_name, emst_cases.patr_name, emst_cases.born_date, emst_cases.is_male,' . gSurgeryIsPrimary . ' as is_primary, ' . gCaseWithBadDoc . ' as is_bad_docs,' . gSurgeryWithBadIllDoc . ' as is_bad_illdoc,' . gLostOutcome . ' as is_lost_outcome', $vFilter, $vOrder, 'case_id');
$vTab->AddBoolColumn('is_primary', 'Перв.');
$vTab->AddColumn('case_id', '№', array('align' => 'right'));
$vTab->AddDateColumn('date', 'Дата и время приёма');
$vTab->AddColumn('user_id', 'Врач', array('align' => 'left', 'fmt' => 'tcfUserName'));
$vTab->AddColumn('id', 'Фамилия Имя Отчество', array('align' => 'left', 'fmt' => 'tcfName'));
$vTab->AddColumn('date', 'Дата рождения, полных лет', array('align' => 'left', 'fmt' => 'tcfBornDate'));
$vTab->AddColumn('is_male', 'Пол', array('align' => 'center', 'fmt' => 'tcfSex'));
$vTab->AddTextColumn('diagnosis', 'Диагноз');
$vTab->AddColumn('diagnosis_mkb', 'МКБ');
$vTab->AddBoolColumn('is_bad_docs', 'Пробл. с док.');
$vTab->AddBoolColumn('is_bad_illdoc', 'Пробл. с б/л');
$vTab->AddBoolColumn('is_lost_outcome', 'Исход не указан');
$vTab->AddColumn('id', 'ЕИС ОМС', array('align' => 'left', 'fmt' => 'tcfEISOMS'));
$vTab->AddRowAction('изменение', 'case_edit.html?id=', '../images/edit_24x24.gif', 24, 24);
$vTab->AddRowAction('печать', '../reg/case.pdf?id=', '../images/print_24x24.gif', 24, 24);
/*
$vTab->AddRowAction('приём', 'accept.html?id=', '../images/sugrery_24x24.gif', 24, 24);
$vTab->AddRowAction('изменение', 'case_edit.html?id=', '../images/edit_24x24.gif', 24, 24);
$vTab->AddRowAction('печать', '../reg/case.pdf?id=', '../images/print_24x24.gif', 24, 24);
*/
$vFilter = array();
CopyRecordRefValue($vFilter, $_GET, 'case_id');
CopyRecordRefValue($vFilter, $_GET, 'doctor_id');
CopyRecordStrValue($vFilter, $_GET, 'first_name');
CopyRecordStrValue($vFilter, $_GET, 'last_name');
CopyRecordStrValue($vFilter, $_GET, 'patr_name');
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
CopyRecordStrValue($vFilter, $_GET, 'empty_diagnosis_mkb');
CopyRecordStrValue($vFilter, $_GET, 'is_primary');
CopyRecordStrValue($vFilter, $_GET, 'is_bad_doc');
CopyRecordStrValue($vFilter, $_GET, 'is_bad_illdoc');
CopyRecordStrValue($vFilter, $_GET, 'eisoms_status');
CopyRecordBoolValue($vFilter, $_GET, 'is_lost_outcome');
// $vTab->AddTableAction('печать', CompoundURL('cases_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, GetPageIdxOrLast(), 20);
return $vResult;
}
