public static function RemoveExisting($upload_id) { $DB = GetDB(); $upload = $DB->Row('SELECT * FROM `tbx_upload` WHERE `upload_id`=?', array($upload_id)); if (!empty($upload)) { $path = Config::Get('document_root') . $upload['uri']; if (file_exists($path)) { @unlink($path); } $DB->Update('DELETE FROM `tbx_upload` WHERE `upload_id`=?', array($upload_id)); } }
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; }
public static function GenerateFromCustom($type) { $DB = GetDB(); $schema = GetDBSchema(); $xtable = $schema->el('//table[naming/type="' . $type . '"]'); $primary_key = $xtable->columns->primaryKey->val(); $custom_schema_table = $xtable->custom->val() . '_schema'; $html = ''; $result = $DB->Query('SELECT * FROM # ORDER BY `field_id`', array($custom_schema_table)); while ($field = $DB->NextRow($result)) { switch ($field['type']) { case self::TEXT: $html .= '<div class="field">' . ' <label>' . $field['label'] . ':</label>' . ' <span class="field-container">' . ' <input type="text" size="60" name="' . $field['name'] . '" value="' . Request::Get($field['name']) . '" />' . ' </span>' . '</div>'; break; case self::TEXTAREA: $html .= '<div class="field">' . ' <label>' . $field['label'] . ':</label>' . ' <span class="field-container">' . ' <textarea name="' . $field['name'] . '" rows="5" cols="80">' . Request::Get($field['name']) . '</textarea>' . ' </span>' . '</div>'; break; case self::SELECT: $html .= '<div class="field">' . ' <label>' . $field['label'] . ':</label>' . ' <span class="field-container">' . ' <select name="' . $field['name'] . '">' . self::OptionsSimple($field['options'], Request::Get($field['name'])) . ' </select>' . ' </span>' . '</div>'; break; case self::CHECKBOX: $html .= '<div class="field">' . ' <label></label>' . ' <span class="field-container">' . ' <div class="checkbox">' . ' <input type="hidden" name="' . $field['name'] . '" value="' . Request::Get($field['name']) . '" />' . ' ' . $field['label'] . ' </div>' . ' </span>' . '</div>'; break; } } $DB->Free($result); if (empty($html)) { $html = '<div class="message-warning text-center">No Custom Fields Have Been Defined</div>'; } return $html; }
public static function FilterSearchTerms() { $DB = GetDB(); $words = $DB->FetchAll('SELECT `regex`,`value` FROM `tbx_blacklist` WHERE `type`=?', array(self::TYPE_WORD)); $result = $DB->Query('SELECT * FROM `tbx_search_term_new`'); while ($term = $DB->NextRow($result)) { $blacklisted = false; foreach ($words as $w) { if (!$w['regex']) { $w['value'] = preg_quote($w['value'], '~'); } if (preg_match('~(' . $w['value'] . ')~i', $term['term'])) { $blacklisted = true; break; } } if (!$blacklisted) { if ($DB->Update('UPDATE `tbx_search_term` SET `frequency`=`frequency`+? WHERE `term`=?', array($term['frequency'], $term['term'])) == 0) { $DB->Update('INSERT INTO `tbx_search_term` VALUES (?,?,?)', array(null, $term['term'], 1)); } } $DB->Update('DELETE FROM `tbx_search_term_new` WHERE `term_id`=?', array($term['term_id'])); } $DB->Free($result); }
public function PostProcessSuccess($video_id) { // Adjust permissions and move directory $old_directory = $this->video_dir->GetBaseDir(); @chmod($old_directory, 0777); $directory = Video_Dir::DirNameFromId($video_id); $this->video_dir->MoveTo($directory); // Add the embed code to the database DatabaseAdd('tbx_video_clip', array('video_id' => $video_id, 'clip' => $this->source[Video_Source::FIELD_EMBED], 'type' => 'Embed')); // Get the relative URL for each thumb and add to database $thumb_ids = array(); foreach ($this->thumbs as $thumb) { $thumb = str_replace(array($old_directory, Config::Get('document_root')), array($directory, ''), $thumb); $thumb_ids[] = DatabaseAdd('tbx_video_thumbnail', array('video_id' => $video_id, 'thumbnail' => $thumb)); } // Determine number of thumbnails and select random display thumbnail $num_thumbnails = count($this->thumbs); $display_thumbnail = null; if ($num_thumbnails > 0) { // Select display thumbnail randomly from the first 40% $display_thumbnail = $thumb_ids[rand(0, floor(0.4 * $num_thumbnails))]; } $update = array('video_id' => $video_id, 'num_thumbnails' => $num_thumbnails, 'display_thumbnail' => $display_thumbnail, 'duration' => $this->duration); $DB = GetDB(); $DB->Update('DELETE FROM `tbx_conversion_queue` WHERE `video_id`=?', array($video_id)); DatabaseUpdate('tbx_video', $update); }
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; }
public static function &GetDiffs($username, $since) { $db = GetDB(); $sql = 'select followers.follower_id, followers.followed_at, followers.unfollowed_at, twitterusers.* from followers left join twitterusers on followers.follower_id = twitterusers.id where followers.username = "******" and (followers.followed_at > ' . $since . ' or followers.unfollowed_at > ' . $since . ') order by followers.unfollowed_at asc, followers.followed_at asc'; $retval = mysql_query($sql, $db); return $retval; }
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 Render(&$AConclusion) { $vDB = GetDB(); $vHeavitiesList = $vDB->GetRBList('rb_trauma_heavity', 'id', 'name', true); $this->SetMargins(20, 20, 20); $this->SetAutoPageBreak(true, 30); $vBranchInfo = GetBranchInfo(); $this->AddPage(); $this->SetFont('arial_rus', '', 10); $vWidth = $this->GetAreaWidth(); $vHeight = $this->FontSize * 1.5; $vX = $this->GetX(); $vY = $this->GetY(); $this->SetXY($vX, $vY); $this->Cell($vWidth, $vHeight, iconv("utf8", "windows-1251", @$vBranchInfo['name']), 'B', 0, 'L'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'Медицинская документация', '', 0, 'R'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'Учетная форма № 315/у', '', 0, 'R'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'УТВЕРЖДЕНА', '', 0, 'R'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'Приказом Минздравсоцразвития России', '', 0, 'R'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'От 15 апреля 2005 г. №275', '', 0, 'R'); $this->Ln($vHeight); $this->Ln($vHeight); $this->SetFont('arial_rus', '', 14); $vHeight = $this->FontSize * 1.5; $this->Cell($vWidth, $vHeight, 'МЕДИЦИНСКОЕ ЗАКЛЮЧЕНИЕ', '', 0, 'C'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'о характере полученных повреждений здоровья в результате несчастного', '', 0, 'C'); $this->Ln($vHeight); $this->Cell($vWidth, $vHeight, 'случая на производстве и степени их тяжести', '', 0, 'C'); $this->Ln($vHeight); $this->Ln($vHeight); $this->SetFont('arial_rus', '', 10); $vHeight = $this->FontSize * 1.5; $vBlock = array(); $vBlock[] = array('title' => 'Выдано', 'text' => iconv("utf8", "windows-1251", @$AConclusion['employment_place'])); $vBlock[] = array('title' => 'О том, что пострадавший', 'text' => iconv("utf8", "windows-1251", FormatNameEx($AConclusion))); $vBlock[] = array('title' => 'дата рождения', 'text' => iconv("utf8", "windows-1251", Date2ReadableLong(@$AConclusion['born_date']))); $vBlock[] = array('title' => 'должность (профессия)', 'text' => iconv("utf8", "windows-1251", @$AConclusion['profession'])); $vBlock[] = array('title' => 'поступил в', 'text' => iconv("utf8", "windows-1251", @$vBranchInfo['name'])); $vBlock[] = array('title' => 'дата и время обращения', 'text' => iconv("utf8", "windows-1251", Date2ReadableLong(@$AConclusion['create_time']))); $vBlock[] = array('title' => 'Диагноз', 'text' => iconv("utf8", "windows-1251", @$AConclusion['diagnosis'])); $vBlock[] = array('title' => 'Код диагноза по МКБ', 'text' => iconv("utf8", "windows-1251", @$AConclusion['diagnosis_mkb'])); $this->BlockNotes($vBlock, $vWidth); $this->Cell($vWidth, $vHeight, 'Согласно схеме определения степени тяжести повреждения здоровья при несчастных случаях', '', 0, 'L'); $this->Ln($vHeight); $vBlock = array(); $vBlock[] = array('title' => 'на производстве указанное повреждение относится к категории', 'text' => iconv("utf8", "windows-1251", @$vHeavitiesList[$AConclusion['heavity']])); $this->BlockNotes($vBlock, $vWidth); $this->Ln($vHeight); $vBlock = array(); $vBlock[] = array('title' => 'Врач', 'text' => iconv("utf8", "windows-1251", FormatUserName(@$AConclusion['doctor_id']))); $vBlock[] = array('title' => 'Дата', 'text' => iconv("utf8", "windows-1251", Date2ReadableLong($vDB->ConvertToDate(time())))); $this->BlockNotes($vBlock, $vWidth); $this->Ln($vHeight); }
function CheckLoginName() { if ($this->validate()) { $vValues = $this->getSubmitValues(TRUE); $vName = $vValues['Name']; $vPassword = $vValues['Password']; $vDB = GetDB(); $vUserRecord = $vDB->Get('users', '*', $vDB->CondAnd($vDB->CondEqual('login', $vName), $vDB->CondEqual('password', $vPassword), $vDB->CondEqual('retired', 0))); // unset($vDB); $vRoles = $vUserRecord['roles']; list($vMenu, $vFirstPage) = GetMenuAndFirstPage($vRoles); if ($vFirstPage != '') { $_SESSION['User.ID'] = $vUserRecord['id']; $_SESSION['User.Login'] = $vName; $_SESSION['User.Name'] = $vUserRecord['full_name']; $_SESSION['User.Roles'] = $vRoles; $_SESSION['User.FirstPage'] = $vFirstPage; $_SESSION['User.Menu'] = $vMenu; setcookie('LoginName', $vName, time() + 9999999); //var_dump($vFirstPage); //exit(); Redirect($vFirstPage); } } return FALSE; }
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; }
function getUserEisCode($AUserId) { $vDB = GetDB(); $vRecord = $vDB->GetById('users', $AUserId, 'eisCode'); $vResult = $vRecord ? $vRecord['eisCode'] : NULL; $vResult = $vResult ? $vResult : '0'; # print_r( array( $AUserId, $vRecord, $vResult) ); 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 GetTable() { $vDB = GetDB(); $vTab =& new TTable('rb_vistit_targets', '*', '', 'name', 'id'); $vTab->AddColumn('name', 'Наименование'); $vTab->AddRowAction('изменить', 'vistit_target_edit.html?id='); $vTab->AddTableAction('новая запись', 'vistit_target_edit.html'); $vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20); return $vResult; }
function GetTable() { $vDB = GetDB(); $vTab =& new TTable('rb_employment_categories', '*', '', 'name', 'id'); $vTab->AddColumn('name', 'Наименование'); $vTab->AddBoolColumn('need_ill_doc', 'Нужен б/л или справка'); $vTab->AddRowAction('изменить', 'employment_category_edit.html?id='); $vTab->AddTableAction('новая запись', 'employment_category_edit.html'); $vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20); return $vResult; }
public static function Add($id) { $retval = false; $db = GetDB(); $sql = 'insert into twitterusers set id = "' . mysql_real_escape_string($id, $db) . '" on duplicate key update id = "' . mysql_real_escape_string($id, $db) . '"'; $retval = mysql_query($sql, $db); if (!$retval) { echo 'TwitterUsers::Add(' . $id . '): ' . mysql_error($db) . "\n\n"; } return $retval; }
public static function &Get($username) { $retval = array(); $db = GetDB(); $sql = 'select data from queue where username = "******" order by sent_at asc'; $query = mysql_query($sql, $db); while ($row = mysql_fetch_array($query)) { $retval[] = unserialize($row[0]); } return $retval; }
function GetTable() { $vDB = GetDB(); $vTab =& new TTable('rb_manipulations', '*', '', 'name', 'id'); $vTab->AddColumn('name', 'Наименование'); $vTab->AddBoolColumn('is_plaster', 'В журнал гипс'); $vTab->AddRowAction('изменить', 'manipulation_edit.html?id='); $vTab->AddTableAction('новая запись', 'manipulation_edit.html'); $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(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 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.*', $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; }
public static function RemoveFromFrequency($tags) { if (String::IsEmpty($tags)) { return; } $DB = GetDB(); foreach (explode(' ', $tags) as $tag) { $tag = trim($tag); $DB->Update('UPDATE `tbx_video_tag` SET `frequency`=`frequency`-1 WHERE `tag`=?', array($tag)); } $DB->Update('DELETE FROM `tbx_video_tag` WHERE `frequency` < 1'); }
function GetTable() { $vDB = GetDB(); $vTab =& new TTable('rb_clinical_outcomes', '*', '', 'name', 'id'); $vTab->AddColumn('name', 'Наименование'); $vTab->AddBoolColumn('can_skip_ill_doc_on_disability', "В случае указания\nнетрудоспособности\nможет быть опущен б/л"); $vTab->AddBoolColumn('can_use_ill_doc_in_ability', "Б/л может быть\nуказан при сохранении\nтрудоспособности"); $vTab->AddBoolColumn('req_epicrisis', "Требуется указание\nэпикриза при печати\nистории болезни"); $vTab->AddRowAction('изменить', 'clinical_outcome_edit.html?id='); $vTab->AddTableAction('новая запись', 'clinical_outcome_edit.html'); $vResult = $vTab->ProduceHTML($vDB, $_GET['PageIdx'] + 0, 20); return $vResult; }
function Render($AParams) { $vDB = GetDB(); list($vTable, $vFilter, $vOrder) = ConstructQuery($vDB, $AParams); $this->BegDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['beg_date'])); $this->EndDate = iconv('utf-8', 'cp1251', Date2ReadableLong($AParams['end_date'])); $vFields = 'emst_rg.*, emst_cases.last_name, emst_cases.first_name, emst_cases.patr_name, emst_cases.born_date, emst_cases.is_male,' . 'emst_cases.addr_reg_street, emst_cases.addr_reg_num, emst_cases.addr_reg_subnum, emst_cases.addr_reg_apartment,' . 'emst_cases.addr_phys_street, emst_cases.addr_phys_num, emst_cases.addr_phys_subnum, emst_cases.addr_phys_apartment,' . 'emst_cases.phone'; $vRecords = $vDB->Select($vTable, $vFields, $vFilter, $vOrder); $this->AddPage(); while ($vRecord = $vRecords->Fetch()) { $this->DrawLine($vRecord); } }
function GetTable() { $vDB = GetDB(); $vTab =& new TTable('users', '*', '', 'login', 'id'); $vTab->AddColumn('login', 'Логин'); $vTab->AddColumn('full_name', 'ФИО'); $vTab->AddColumn('eisCode', 'Код ЕИС ОМС'); $vTab->AddColumn('roles', 'Роли', array('fmt' => 'tcfRoles')); $vTab->AddColumn('retired', 'Запрещён', array('align' => 'center', 'fmt' => 'tcfBoolean')); $vTab->AddRowAction('изменить', 'user_edit.html?id='); $vTab->AddTableAction('новый', 'user_edit.html'); $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.*, 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; }
public static function Verify() { // Retrieve $DB = GetDB(); $captcha = $DB->Row('SELECT * FROM # WHERE `session`=?', array(self::TABLE, $_COOKIE[self::COOKIE])); // Validate $v = Validator::Create(); $v->Register(!empty($captcha) && strtoupper($captcha['code']) == strtoupper(Request::Get('captcha')), Validator_Type::IS_TRUE, _T('Validation:Invalid Captcha')); // Remove $DB->Update('DELETE FROM # WHERE `session`=?', array(self::TABLE, $_COOKIE[self::COOKIE])); setcookie(self::COOKIE, null, time() - self::EXPIRES, Config::Get('cookie_path'), Config::Get('cookie_domain')); }
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); } }