示例#1
0
文件: cec_list.php 项目: uisluu/emst
 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;
 }
示例#2
0
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);
    }
}
示例#3
0
 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);
     }
 }
示例#4
0
文件: dms_list.php 项目: uisluu/emst
 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;
 }
示例#5
0
 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);
     }
 }
示例#6
0
 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;
 }
示例#7
0
 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;
 }
示例#8
0
文件: cases.php 项目: uisluu/emst
 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;
 }
示例#9
0
文件: queue.php 项目: uisluu/emst
 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;
 }
示例#10
0
 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;
 }
示例#11
0
 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, 'Вечная слава Российской Прокуратуре -- самому законному сливальщику государственных денег!');
 }
示例#12
-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);
     }
 }