function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TTable($vTable, 'emst_cases.*, emst_surgeries.cec_number as cec_number, emst_surgeries.case_id as case_id, emst_surgeries.date as cec_date, emst_surgeries.user_id as doctor_id', $vFilter, $vOrder, 'case_id');
$vTab->AddColumn('cec_number', '№ ВК');
$vTab->AddDateColumn('cec_date', 'Дата');
$vTab->AddColumn('case_id', '№', array('align' => 'right'));
$vTab->AddColumn('doctor_id', 'Врач', array('align' => 'left', 'fmt' => 'tcfUserName'));
$vTab->AddColumn('id', 'Фамилия Имя Отчество', array('align' => 'left', 'fmt' => 'tcfName'));
$vTab->AddColumn('cec_date', 'Дата рождения, полных лет', array('align' => 'left', 'fmt' => 'tcfBornDate'));
$vTab->AddColumn('is_male', 'Пол', array('align' => 'center', 'fmt' => 'tcfSex'));
$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->AddTextColumn('diagnosis', 'Диагноз');
$vTab->AddColumn('diagnosis_mkb', 'МКБ');
// $vTab->AddColumn('antitetanus_series', 'Серия');
$vFilter = array();
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
$vTab->AddTableAction('печать', CompoundURL('cec_list.pdf', $vFilter));
// $vTab->AddTableAction('сводный отчет', CompoundURL('antitetanuses_report.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20);
return $vResult;
}
function ProduceTable($ABegDate, $AEndDate)
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, array('beg_date' => $ABegDate, 'end_date' => $AEndDate));
$vRecords = $vDB->Select($vTable, '*', $vFilter, $vOrder);
$vNo = 0;
while ($vRecord = $vRecords->Fetch()) {
DrawLine(++$vNo, $vRecord);
}
}
function Render($AParams)
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $AParams);
$this->BegDate = Date2ReadableLong(iconv('utf-8', 'cp1251', $AParams['beg_date']));
$this->EndDate = Date2ReadableLong(iconv('utf-8', 'cp1251', $AParams['end_date']));
$vRecords = $vDB->Select($vTable, '*', $vFilter, $vOrder);
$this->AddPage();
while ($vRecord = $vRecords->Fetch()) {
$this->DrawLine($vRecord);
}
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TCasesTableEx($vTable, 'emst_cases.*', $vFilter, $vOrder);
$vFilter = array();
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
$vTab->AddTableAction('печать', CompoundURL('dms_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20);
return $vResult;
}
function Render($AParams)
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $AParams);
$this->BegDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['beg_date']));
$this->EndDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['end_date']));
$vRecords = $vDB->Select($vTable, 'emst_cases.*, emst_surgeries.manipulation_text, rb_manipulations.name as manipulation_name', $vFilter, $vOrder);
$this->AddPage();
while ($vRecord = $vRecords->Fetch()) {
$this->DrawLine($vRecord);
}
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TCasesTableEx($vTable, 'emst_cases.*, emst_surgeries.manipulation_text, rb_manipulations.name as manipulation_name', $vFilter, $vOrder);
$vTab->AddColumn('manipulation_name', 'Манипуляция');
$vTab->AddColumn('manipulation_text', 'Описание');
$vFilter = array();
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
$vTab->AddTableAction('печать', CompoundURL('plasters_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20);
return $vResult;
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TCasesTableEx($vTable, 'emst_cases.*, rb_antitetanus.name as antitetanus_name', $vFilter, $vOrder);
$vTab->AddColumn('antitetanus_name', 'Прививка');
$vTab->AddColumn('antitetanus_series', 'Серия');
$vFilter = array();
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
$vTab->AddTableAction('печать', CompoundURL('antitetanuses_list.pdf', $vFilter));
$vTab->AddTableAction('сводный отчет', CompoundURL('antitetanuses_report.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20);
return $vResult;
}
function GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab =& new TCasesTable($vTable, 'emst_cases.*', $vFilter, $vOrder);
// $vTab->AddRowAction('изменить', 'case_edit.html?id=');
// $vTab->AddRowAction('печать', '/reg/case.pdf?id=');
// $vTab->AddRowAction('"заключение..."', '/info/conclusion.html?id=');
$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');
$vResult = $vTab->ProduceHTML($vDB, GetPageIdxOrLast(), 20);
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 GetTable()
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $_GET);
$vTab = new TTable($vTable, 'emst_cases.*', $vFilter, $vOrder, 'id');
$vTab->AddColumn('id', '№', array('align' => 'right'));
$vTab->AddDateColumn('create_time', 'Дата и время обращения');
$vTab->AddColumn('first_doctor_id', 'Врач', array('fmt' => 'tcfUserName'));
$vTab->AddColumn('id', 'Фамилия Имя Отчество', array('align' => 'left', 'fmt' => 'tcfName'));
$vTab->AddColumn('create_time', 'Дата рождения, полных лет', array('align' => 'left', 'fmt' => 'tcfBornDate'));
$vTab->AddColumn('is_male', 'Пол', array('align' => 'center', 'fmt' => 'tcfSex'));
$vTab->AddColumn('id', 'Адрес', array('align' => 'left', 'fmt' => 'tcfAddress'));
$vTab->AddColumn('phone', 'Телефон');
$vTab->AddTextColumn('accident', 'Происшествие');
$vTab->AddTextColumn('accident_datetime', 'Дата и время происшествия');
$vTab->AddTextColumn('diagnosis', 'Диагноз');
$vTab->AddColumn('message_number', 'Телефонограмма');
$vFilter = array();
CopyRecordDateValue($vFilter, $_GET, 'beg_date');
CopyRecordDateValue($vFilter, $_GET, 'end_date');
$vTab->AddTableAction('печать', CompoundURL('phone_messages_list.pdf', $vFilter));
$vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20);
return $vResult;
}
function Render($AParams)
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $AParams);
$this->BegDate = Date2ReadableLong($AParams['beg_date']);
$this->EndDate = Date2ReadableLong($AParams['end_date']);
$vRecords = $vDB->Select($vTable, '*', $vFilter, $vOrder);
$this->AddPage();
$vNo = 0;
while ($vRecord = $vRecords->Fetch()) {
$this->DrawLine($vDB, ++$vNo, $vRecord);
}
$this->SetFont('arial_rus', '', 1);
$this->ExactCell(1, 'Вечная слава Российской Прокуратуре -- самому законному сливальщику государственных денег!');
}
function Render($AParams)
{
$vDB = GetDB();
list($vTable, $vFilter, $vOrder) = ConstructCaseQuery($vDB, $AParams);
$this->BegDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['beg_date']));
$this->EndDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['end_date']));
$vRecords = $vDB->Select($vTable, 'emst_surgeries.*, emst_cases.first_name, emst_cases.last_name, emst_cases.patr_name, emst_cases.is_male, emst_cases.born_date, emst_cases.doc_type_id, emst_cases.doc_series, emst_cases.doc_number, emst_cases.polis_series, emst_cases.polis_number, emst_cases.addr_reg_street, emst_cases.addr_reg_num, emst_cases.addr_reg_subnum, emst_cases.addr_reg_apartment, emst_cases.phone, emst_cases.employment_category_id, emst_cases.employment_place, emst_cases.profession, emst_cases.disability_from_date', $vFilter, $vOrder);
$this->AddPage();
while ($vRecord = $vRecords->Fetch()) {
$this->DrawLine($vRecord);
}
}