/** * Метод, предназначенный для получения и вывода списка Запросов * * @param boolean $pagination признак формирования постраничного списка */ function _requestListGet($pagination = true) { global $AVE_DB, $AVE_Template; $limit = ''; // Если используется постраничная навигация if ($pagination) { // Определяем лимит записей на страницу и начало диапазона выборки $limit = $this->_limit; $start = get_current_page() * $limit - $limit; // Получаем общее количество запросов $num = $AVE_DB->Query("SELECT COUNT(*) FROM " . PREFIX . "_request")->GetCell(); // Если количество больше, чем установленный лимит, тогда формируем постраничную навигацию if ($num > $limit) { $page_nav = " <a class=\"pnav\" href=\"index.php?do=request&page={s}&cp=" . SESSION . "\">{t}</a> "; $page_nav = get_pagination(ceil($num / $limit), 'page', $page_nav); $AVE_Template->assign('page_nav', $page_nav); } $limit = $pagination ? "LIMIT " . $start . "," . $limit : ''; } // Выполняем запрос к БД на получение списка запросов с учетом лимита вывода на страницу (если необходимо) $items = array(); $sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_request\r\n\t\t\tORDER BY Id ASC\r\n\t\t\t" . $limit . "\r\n\t\t"); // Формируем массив из полученных данных while ($row = $sql->FetchRow()) { $row->request_author = get_username_by_id($row->request_author_id); array_push($items, $row); } // Возвращаем массив return $items; }
/** * Вывод списка системных блоков * */ function sys_blockList() { global $AVE_DB, $AVE_Template; $sys_blocks = array(); $sql = $AVE_DB->Query("SELECT * FROM " . PREFIX . "_sysblocks"); // Формируем массив из полученных данных while ($result = $sql->FetchRow()) { $result->sysblock_author_id = get_username_by_id($result->sysblock_author_id); array_push($sys_blocks, $result); } $AVE_Template->assign('sys_blocks', $sys_blocks); $AVE_Template->assign('content', $AVE_Template->fetch('sysblocks/list.tpl')); }
/** * Метод, предназначенный для просмотра и добавления Заметок к Документу * * @param int $reply признак ответа на Заметку */ function documentRemarkNew($document_id = 0, $reply = 0) { global $AVE_DB, $AVE_Template; // Если id документа не число или 0, прерываем выполнение if (!(is_numeric($document_id) && $document_id > 0)) { exit; } // Если в запросе пришел параметр на Сохранение if (isset($_REQUEST['sub']) && $_REQUEST['sub'] == 'save') { // Если пользователь оставил комментарий и у него имеются права и это не ответ, а новая заметка, тогда if (!empty($_REQUEST['remark_text']) && check_permission('remarks') && empty($_REQUEST['reply'])) { // Выполняем запрос к БД на добавление новой заметки для документа $AVE_DB->Query("\n\t\t\t\t\tINSERT " . PREFIX . "_document_remarks\n\t\t\t\t\tSET\n\t\t\t\t\t\tdocument_id = '" . $document_id . "',\n\t\t\t\t\t\tremark_title = '" . clean_no_print_char($_REQUEST['remark_title']) . "',\n\t\t\t\t\t\tremark_text = '" . substr(clean_no_print_char($_REQUEST['remark_text']), 0, $this->_max_remark_length) . "',\n\t\t\t\t\t\tremark_author_id = '" . $_SESSION['user_id'] . "',\n\t\t\t\t\t\tremark_published = '" . time() . "',\n\t\t\t\t\t\tremark_first = '1',\n\t\t\t\t\t\tremark_author_email = '" . $_SESSION['user_email'] . "'\n\t\t\t\t"); } // Выполняем обновление страницы header('Location:index.php?do=docs&action=remark_reply&Id=' . $document_id . '&pop=1&cp=' . SESSION); } // Если это ответ на уже существующую заметку if ($reply == 1) { if (isset($_REQUEST['sub']) && $_REQUEST['sub'] == 'save') { // Если пользователь оставил ответ и имеет на это права if (!empty($_REQUEST['remark_text']) && check_permission('remarks')) { // Выполняем запрос на получение e-mail адреса автора заметки $remark_author_email = $AVE_DB->Query("\n\t\t\t\t\t\tSELECT remark_author_email\n\t\t\t\t\t\tFROM " . PREFIX . "_document_remarks\n\t\t\t\t\t\tWHERE remark_first = '1'\n\t\t\t\t\t\tAND document_id = '" . $document_id . "'\n\t\t\t\t\t")->GetCell(); // Выполняем запрос к БД на добавление заметки в БД $AVE_DB->Query("\n\t\t\t\t\t\tINSERT " . PREFIX . "_document_remarks\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tdocument_id = '" . $document_id . "',\n\t\t\t\t\t\t\tremark_title = '" . clean_no_print_char($_REQUEST['remark_title']) . "',\n\t\t\t\t\t\t\tremark_text = '" . substr(clean_no_print_char($_REQUEST['remark_text']), 0, $this->_max_remark_length) . "',\n\t\t\t\t\t\t\tremark_author_id = '" . $_SESSION['user_id'] . "',\n\t\t\t\t\t\t\tremark_published = '" . time() . "',\n\t\t\t\t\t\t\tremark_first = '0',\n\t\t\t\t\t\t\tremark_author_email = '" . $_SESSION['user_email'] . "'\n\t\t\t\t\t"); } // Формируем сообщение и отправляем письмо автору, с информацией о том, что на его заметку есть ответ $system_mail = get_settings('mail_from'); $system_mail_name = get_settings('mail_from_name'); $link = get_home_link() . 'index.php?do=docs&doc_id=' . $document_id; $body_to_admin = $AVE_Template->get_config_vars('DOC_MAIL_BODY_NOTICE'); $body_to_admin = str_replace('%N%', "\n", $body_to_admin); $body_to_admin = str_replace('%TITLE%', stripslashes($_POST['remark_title']), $body_to_admin); $body_to_admin = str_replace('%USER%', get_username_by_id($_SESSION['user_id']), $body_to_admin); $body_to_admin = str_replace('%LINK%', $link, $body_to_admin); send_mail($remark_author_email, $body_to_admin, $AVE_Template->get_config_vars('DOC_MAIL_SUBJECT_NOTICE'), $system_mail, $system_mail_name, 'text'); // Выполняем обновление страницы header('Location:index.php?do=docs&action=remark_reply&Id=' . $document_id . '&pop=1&cp=' . SESSION); } // Получаем общее количество заметок для документа $num = $AVE_DB->Query("\n\t\t\t\tSELECT COUNT(*)\n\t\t\t\tFROM " . PREFIX . "_document_remarks\n\t\t\t\tWHERE document_id = '" . $document_id . "'\n\t\t\t")->GetCell(); // Определяыем лимит заметок на 1 странице и подсчитываем количество страниц $limit = 10; $seiten = ceil($num / $limit); $start = get_current_page() * $limit - $limit; $answers = array(); // Выполняем запрос к БД на получение заметок с учетом количества на 1 странцу $sql = $AVE_DB->Query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM " . PREFIX . "_document_remarks\n\t\t\t\tWHERE document_id = '" . $document_id . "'\n\t\t\t\tORDER BY Id DESC\n\t\t\t\tLIMIT " . $start . "," . $limit); while ($row = $sql->FetchAssocArray()) { $row['remark_author'] = get_username_by_id($row['remark_author_id']); $row['remark_text'] = nl2br($row['remark_text']); array_push($answers, $row); } $remark_status = $AVE_DB->Query("\n\t\t\t\tSELECT remark_status\n\t\t\t\tFROM " . PREFIX . "_document_remarks\n\t\t\t\tWHERE document_id = '" . $document_id . "'\n\t\t\t\tAND remark_first = '1'\n\t\t\t")->GetCell(); // Если количество заметок превышает допустимое значение, определенное в переменной $limit, тогда // формируем постраничную навигацию if ($num > $limit) { $page_nav = " <a class=\"pnav\" href=\"index.php?do=docs&action=remark_reply&Id=" . $document_id . "&page={s}&pop=1&cp=" . SESSION . "\">{t}</a> "; $page_nav = get_pagination($seiten, 'page', $page_nav); $AVE_Template->assign('page_nav', $page_nav); } // Передаем данные в шаблон и отображаем страницу со списком заметок $AVE_Template->assign('remark_status', $remark_status); $AVE_Template->assign('answers', $answers); $AVE_Template->assign('reply', 1); $AVE_Template->assign('formaction', 'index.php?do=docs&action=remark_reply&sub=save&Id=' . $document_id . '&reply=1&cp=' . SESSION); $AVE_Template->assign('content', $AVE_Template->fetch('documents/newremark.tpl')); } else { // В противном случае, если заметок еще нет, открываем форму для добавление заметки $AVE_Template->assign('reply', 1); $AVE_Template->assign('new', 1); $AVE_Template->assign('formaction', 'index.php?do=docs&action=remark&sub=save&Id=' . $document_id . '&cp=' . SESSION); $AVE_Template->assign('content', $AVE_Template->fetch('documents/newremark.tpl')); } }
/** * Обработка тега запроса. * Возвращает список документов удовлетворяющих параметрам запроса * оформленный с использованием шаблона * * @param int $id идентификатор запроса * @return string */ function request_parse($id) { global $AVE_Core, $AVE_DB, $request_documents; $return = ''; if (is_array($id)) { $id = $id[1]; } $row_ab = $AVE_DB->Query("\r\n\t\tSELECT *\r\n\t\tFROM " . PREFIX . "_request\r\n\t\tWHERE Id = '" . $id . "'\r\n\t")->FetchRow(); if (is_object($row_ab)) { $ttl = (int) $row_ab->request_cache_lifetime; $limit = $row_ab->request_items_per_page < 1 ? 1 : $row_ab->request_items_per_page; $main_template = $row_ab->request_template_main; $item_template = $row_ab->request_template_item; $request_order_by = $row_ab->request_order_by; $request_asc_desc = $row_ab->request_asc_desc; $request_order = $request_order_by . " " . $request_asc_desc; $request_order_fields = ''; $request_order_tables = ''; if ($row_ab->request_order_by_nat) { $request_order_tables = "LEFT JOIN " . PREFIX . "_document_fields AS s" . $row_ab->request_order_by_nat . "\r\n\t\t\t ON (s" . $row_ab->request_order_by_nat . ".document_id = a.Id and s" . $row_ab->request_order_by_nat . ".rubric_field_id=" . $row_ab->request_order_by_nat . ")"; $request_order_fields = "s" . $row_ab->request_order_by_nat . ".field_value, "; $request_order = "s" . $row_ab->request_order_by_nat . ".field_value " . $row_ab->request_asc_desc; } $doctime = get_settings('use_doctime') ? "AND a.document_published <= UNIX_TIMESTAMP() AND\r\n \t\t \t(a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())" : ''; $where_cond = empty($_POST['req_' . $id]) && empty($_SESSION['doc_' . $AVE_Core->curentdoc->Id]['req_' . $id]) ? unserialize($row_ab->request_where_cond) : unserialize(request_get_condition_sql_string($row_ab->Id)); $where_cond['from'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['from']); $where_cond['where'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['where']); if ($row_ab->request_show_pagination == 1) { if (!empty($AVE_Core->install_modules['comment']->Status)) { $num = $AVE_DB->Query(eval2var(" ?> \r\n\t\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\ta.Id != '1'\r\n\t\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t\t" . $doctime . "\r\n\t\t\t\t<?php "), $ttl, 'rub_' . $row_ab->rubric_id)->GetCell(); } else { $num = $AVE_DB->Query(eval2var(" ?>\r\n\t\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\ta.Id != '1'\r\n\t\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t\t" . $doctime . "\r\n\t\t\t\t<?php "), $ttl, 'rub_' . $row_ab->rubric_id)->GetCell(); } $seiten = ceil($num / $limit); if (isset($_REQUEST['apage']) && is_numeric($_REQUEST['apage']) && $_REQUEST['apage'] > $seiten) { $redirect_link = rewrite_link('index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : '')); header('Location:' . $redirect_link); exit; } $start = get_current_page('apage') * $limit - $limit; } else { $start = 0; } if ($row_ab->request_items_per_page != 0) { $filter_limit = "LIMIT " . $start . "," . $limit; } if (!empty($AVE_Core->install_modules['comment']->Status)) { $q = " ?>\r\n\t\t\t\tSELECT\r\n\t\t\t\t\t" . $request_order_fields . "\r\n\t\t\t\t\ta.Id,\r\n\t\t\t\t\ta.document_title,\r\n\t\t\t\t\ta.document_alias,\r\n\t\t\t\t\ta.document_author_id,\r\n\t\t\t\t\ta.document_count_view,\r\n\t\t\t\t\ta.document_published,\r\n\t\t\t\t\tCOUNT(b.document_id) AS nums\r\n\t\t\t\tFROM\r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t" . PREFIX . "_modul_comment_info AS b\r\n\t\t\t\t\t\tON b.document_id = a.Id\r\n\t\t\t\t " . ($request_order_tables > '' ? $request_order_tables : '') . "\t\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ta.Id != '1'\r\n\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t" . $doctime . "\r\n\t\t\t\tGROUP BY a.Id\r\n\t\t\t\tORDER BY " . $request_order . "\r\n\t\t\t\t" . $filter_limit . " <?php "; } else { $q = " ?>\r\n\t\t\t\tSELECT\r\n\t\t\t\t\t" . $request_order_fields . "\r\n\t\t\t\t\ta.Id,\r\n\t\t\t\t\ta.document_title,\r\n\t\t\t\t\ta.document_alias,\r\n\t\t\t\t\ta.document_author_id,\r\n\t\t\t\t\ta.document_count_view,\r\n\t\t\t\t\ta.document_published\r\n\t\t\t\tFROM\r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\t" . ($request_order_tables > '' ? $request_order_tables : "") . "\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ta.Id != '1'\r\n\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t" . $doctime . "\r\n\t\t\t\tORDER BY " . $request_order . "\r\n\t\t\t\t" . $filter_limit . " <?php "; } $q = eval2var($q); $q = $AVE_DB->Query($q, $ttl, 'rub_' . $row_ab->rubric_id); if ($q->NumRows() > 0) { $main_template = preg_replace('/\\[tag:if_empty](.*?)\\[\\/tag:if_empty]/si', '', $main_template); $main_template = str_replace(array('[tag:if_notempty]', '[/tag:if_notempty]'), '', $main_template); } else { $main_template = preg_replace('/\\[tag:if_notempty](.*?)\\[\\/tag:if_notempty]/si', '', $main_template); $main_template = str_replace(array('[tag:if_empty]', '[/tag:if_empty]'), '', $main_template); } $page_nav = ''; if ($row_ab->request_show_pagination == 1 && $seiten > 1 && $row_ab->request_items_per_page != 0) { $page_nav = ' <a class="pnav" href="index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . '&apage={s}' . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : '') . '">{t}</a> '; $page_nav = get_pagination($seiten, 'apage', $page_nav, get_settings('navi_box')); $page_nav = rewrite_link($page_nav); } $rows = array(); $request_documents = array(); while ($row = $q->FetchRow()) { array_push($request_documents, $row->Id); array_push($rows, $row); } $items = ''; foreach ($rows as $row) { $cachefile_docid = BASE_DIR . '/cache/sql/doc_' . $row->Id . '/request-' . $id . '.cache'; if (!file_exists($cachefile_docid)) { $item = preg_replace('/\\[tag:rfld:(\\d+)]\\[(more|esc|[0-9-]+)]/e', "request_get_document_field(\"\$1\", {$row->Id}, \"\$2\")", $item_template); //if(!file_exists(dirname($cachefile_docid)))mkdir(dirname($cachefile_docid),0777,true); //file_put_contents($cachefile_docid,$item); } else { $item = file_get_contents($cachefile_docid); } $link = rewrite_link('index.php?id=' . $row->Id . '&doc=' . (empty($row->document_alias) ? prepare_url($row->document_title) : $row->document_alias)); $item = str_replace('[tag:link]', $link, $item); $item = str_replace('[tag:docid]', $row->Id, $item); $item = str_replace('[tag:doctitle]', $row->document_title, $item); $item = str_replace('[tag:docparent]', $row->document_parent, $item); $item = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $row->document_published)), $item); $item = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $row->document_published)), $item); $item = str_replace('[tag:docauthor]', get_username_by_id($row->document_author_id), $item); $item = str_replace('[tag:docviews]', $row->document_count_view, $item); $item = str_replace('[tag:doccomments]', isset($row->nums) ? $row->nums : '', $item); $items .= $item; } $main_template = str_replace('[tag:pages]', $page_nav, $main_template); $main_template = str_replace('[tag:doctotal]', $seiten * $q->NumRows(), $main_template); $main_template = str_replace('[tag:pagetitle]', $AVE_DB->Query("SELECT document_title FROM " . PREFIX . "_documents WHERE Id = '" . $AVE_Core->curentdoc->Id . "' ")->GetCell(), $main_template); $main_template = str_replace('[tag:docid]', $AVE_Core->curentdoc->Id, $main_template); $main_template = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template); $main_template = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template); $main_template = str_replace('[tag:docauthor]', get_username_by_id($AVE_Core->curentdoc->document_author_id), $main_template); $main_template = preg_replace('/\\[tag:dropdown:([,0-9]+)\\]/e', "request_get_dropdown(\"\$1\", " . $row_ab->rubric_id . ", " . $row_ab->Id . ");", $main_template); $return = str_replace('[tag:content]', $items, $main_template); $return = str_replace('[tag:path]', ABS_PATH, $return); $return = str_replace('[tag:mediapath]', ABS_PATH . 'templates/' . THEME_FOLDER . '/', $return); $return = $AVE_Core->coreModuleTagParse($return); } return $return; }
$patient = get_patient_by_id($specimen->patientId); if ($patient != null && trim($patient->addlId) != "") { //echo " (Addl ID: $patient->addlId )"; } ?> </td> <td> <?php $patient = get_patient_by_id($specimen->patientId); echo $patient->getName(); ?> </td> <td><?php echo DateLib::mysqlToString($specimen->dateCollected); ?> </td> <td><?php echo get_username_by_id($specimen->userId); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } # TODO: Add paging to the above table } include "includes/footer.php";
echo '<table class="admin_log">'; echo ' <tr>'; echo ' <td class="event" >Händelse</td>'; echo ' <td class="comment" >Info</td>'; echo ' <td class="time" >Tidpunkt</td>'; echo ' <td class="admin" >Admin</td>'; echo ' <td class="user" >Användare</td>'; echo ' <td class="item" >Item id</td>'; echo ' </tr>'; while ($data = mysql_fetch_assoc($result)) { echo '<tr>'; echo ' <td class="event" >' . $data['event'] . '</td>'; echo ' <td class="comment" >' . $data['value'] . '</td>'; echo ' <td>' . fix_time($data['timestamp']) . '</td>'; echo ' <td>' . ($numeric ? $data['admin_id'] : get_username_by_id($data['admin_id'])) . '</td>'; echo ' <td>' . ($numeric ? $data['user_id'] : get_username_by_id($data['user_id'])) . '</td>'; echo ' <td>' . $data['item_id'] . '</td>'; echo '</tr>'; } echo '</table>'; echo rounded_corners_bottom(); ui_bottom(); //functions used in this script function get_userid_by_name($username) { //hämta användarid $query = 'SELECT id FROM login WHERE username = "******"'; $result = mysql_query($query) or die(report_sql_error($query)); if ($data = mysql_fetch_assoc($result)) { $user_id = $data['id']; } else {
echo $row->posttype != 'upload' && $row->posttype != 'url' ? $row->posttype : 'photo'; ?> </td> <td data-title="Type" class="numeric"> <a href="<?php echo site_url('admin/users/detail/' . $row->created_by); ?> "> <?php echo get_username_by_id($row->created_by); ?> </a> </td> <td data-title="Email" class="numeric"><?php echo $row->featured == 1 ? '<div class="alert alert-success" style="margin-top:5px;">Featured</div>' : '<div class="alert alert-info" style="margin-top:5px;">Not Featured</div>'; ?> </td>
?> <tr> <td><?php echo "User"; ?> </td> <td> <select name='user_id' id='user_id' class='uniform_width'> <?php foreach ($user_ids as $uid) { ?> <option value='<?php echo $uid; ?> '><?php echo get_username_by_id($uid); ?> </option> <?php } ?> </select> </td> </tr> <?php } else { ?> <tr> <td><?php echo LangUtil::$generalTerms['FACILITY']; ?>
break; } while ($data = mysql_fetch_assoc($result)) { switch ($format) { case 'styled': $output .= '<tr>'; $output .= ' <td class="event" >' . $data['event'] . '</td>'; $output .= ' <td class="comment" >' . $data['value'] . '</td>'; $output .= ' <td>' . fix_time($data['timestamp']) . '</td>'; $output .= ' <td>' . ($numeric ? $data['admin_id'] : get_username_by_id($data['admin_id'])) . '</td>'; $output .= ' <td>' . ($numeric ? $data['user_id'] : get_username_by_id($data['user_id'])) . '</td>'; $output .= ' <td>' . $data['item_id'] . '</td>'; $output .= '</tr>'; break; case 'csv': $row = array('event' => $data['event'], 'comment' => $data['value'], 'timestamp' => date('Y-m-d H:i', $data['timestamp']), 'admin' => $numeric ? $data['admin_id'] : get_username_by_id($data['admin_id']), 'user' => $numeric ? $data['user_id'] : get_username_by_id($data['user_id']), 'item_id' => $data['item_id']); //$row = array_map('md5', $row); $output .= '' . implode("\t", $row) . '' . "\n"; break; } } if ($format == 'styled') { $output .= '</table>'; $output .= rounded_corners_bottom(); } switch ($format) { case 'styled': ui_top($ui_options); echo $output; ui_bottom(); break;
function DisplayMainDocuments() { global $AVE_DB, $AVE_Template; $doc_start = array(); $sql = $AVE_DB->Query("\n\t\tSELECT \n\t\t\tdoc.*,\n\t\t\trub.rubric_admin_teaser_template\n\t\tFROM " . PREFIX . "_documents doc\n\t\tLEFT JOIN " . PREFIX . "_rubrics AS rub ON rub.Id = doc.rubric_id\n\t\tORDER BY doc.document_published DESC LIMIT 0,10"); while ($row = $sql->fetchrow()) { $row->rubric_title = showrubricName($row->rubric_id); $row->document_author = get_username_by_id($row->document_author_id); // Получаем имя пользователя (Автора) $row->cantEdit = 0; $row->canDelete = 0; $row->canEndDel = 0; $row->canOpenClose = 0; $row->rubric_admin_teaser_template = @eval2var('?>' . ($row->rubric_admin_teaser_template > '' ? @showrequestelement($row, $row->rubric_admin_teaser_template) : '') . '<?'); // разрешаем редактирование и удаление // если автор имеет право изменять свои документы в рубрике // или пользователю разрешено изменять все документы в рубрике if ($row->document_author_id == @$_SESSION['user_id'] && isset($_SESSION[$row->rubric_id . '_editown']) && @$_SESSION[$row->rubric_id . '_editown'] == 1 || isset($_SESSION[$row->rubric_id . '_editall']) && $_SESSION[$row->rubric_id . '_editall'] == 1) { $row->cantEdit = 1; $row->canDelete = 1; } // запрещаем редактирование главной страницы и страницу ошибки 404 если требуется одобрение Администратора if (($row->Id == 1 || $row->Id == PAGE_NOT_FOUND_ID) && isset($_SESSION[$row->rubric_id . '_newnow']) && @$_SESSION[$row->rubric_id . '_newnow'] != 1) { $row->cantEdit = 0; } // разрешаем автору блокировать и разблокировать свои документы если не требуется одобрение Администратора if ($row->document_author_id == @$_SESSION['user_id'] && isset($_SESSION[$row->rubric_id . '_newnow']) && @$_SESSION[$row->rubric_id . '_newnow'] == 1) { $row->canOpenClose = 1; } // разрешаем всё, если пользователь принадлежит группе Администраторов или имеет все права на рубрику if (UGROUP == 1 || @$_SESSION[$row->rubric_id . '_alles'] == 1) { $row->cantEdit = 1; $row->canDelete = 1; $row->canEndDel = 1; $row->canOpenClose = 1; } // Запрещаем удаление Главной страницы и страницы с 404 ошибкой if ($row->Id == 1 || $row->Id == PAGE_NOT_FOUND_ID) { $row->canDelete = 0; $row->canEndDel = 0; } array_push($doc_start, $row); } $AVE_Template->assign('doc_start', $doc_start); }
/** * Метод, предназанченный для сборки всей страницы в единое целое. * * @param int $id идентификатор документа * @param int $rub_id идентификатор рубрики */ function coreSiteFetch($id, $rub_id = '') { global $AVE_DB; // Если происходит вызов модуля, получаем соответствующие мета-теги и получаем шаблон модуля if (!empty($_REQUEST['module'])) { $out = $this->_coreModuleMetatagsFetch(); $out = $this->_coreDocumentTemplateGet('', '', $this->_coreModuleTemplateGet()); } else { if (!isset($this->curentdoc->Id) && !$this->_coreCurrentDocumentFetch($id, UGROUP)) { // Определяем документ с 404 ошиюкой, в случае, если документ не найден if ($this->_corePageNotFoundFetch(PAGE_NOT_FOUND_ID, UGROUP)) { $_REQUEST['id'] = $_GET['id'] = $id = PAGE_NOT_FOUND_ID; } } // проверяем параметры публикации документа if (!$this->_coreDocumentIsPublished()) { $this->_coreErrorPage404(); } // Определяем права доступа к документам рубрики define('RUB_ID', !empty($rub_id) ? $rub_id : $this->curentdoc->rubric_id); $this->_coreRubricPermissionFetch(RUB_ID); if (!(isset($_SESSION[RUB_ID . '_docread']) && $_SESSION[RUB_ID . '_docread'] == 1 || isset($_SESSION[RUB_ID . '_alles']) && $_SESSION[RUB_ID . '_alles'] == 1)) { // читать запрещено - извлекаем ругательство и отдаём вместо контента $main_content = get_settings('message_forbidden'); } else { if (isset($_REQUEST['print']) && $_REQUEST['print'] == 1) { // увеличиваем счетчик версий для печати $AVE_DB->Query("\r\n\t\t\t\t\t\tUPDATE " . PREFIX . "_documents\r\n\t\t\t\t\t\tSET document_count_print = document_count_print+1\r\n\t\t\t\t\t\tWHERE Id = '" . $id . "'\r\n\t\t\t\t\t"); } else { if (!isset($_SESSION['doc_view[' . $id . ']'])) { // увеличиваем счетчик просмотров (1 раз в пределах сессии) $AVE_DB->Query("\r\n\t\t\t\t\t\t\tUPDATE " . PREFIX . "_documents\r\n\t\t\t\t\t\t\tSET document_count_view = document_count_view+1\r\n\t\t\t\t\t\t\tWHERE Id = '" . $id . "'\r\n\t\t\t\t\t\t"); $_SESSION['doc_view[' . $id . ']'] = 1; } } if (CACHE_DOC_TPL && empty($_POST) && !(isset($_SESSION['user_adminmode']) && $_SESSION['user_adminmode'] == 1)) { // кэширование разрешено // извлекаем скомпилированный шаблон документа из кэша $main_content = $AVE_DB->Query("\r\n\t\t\t\t\t\tSELECT compiled\r\n\t\t\t\t\t\tFROM " . PREFIX . "_rubric_template_cache\r\n\t\t\t\t\t\tWHERE hash = '" . $this->_get_cache_hash() . "'\r\n\t\t\t\t\t\tLIMIT 1\r\n\t\t\t\t\t")->GetCell(); } else { // кэширование запрещено $main_content = false; } if (empty($main_content)) { // кэш пустой или отключен, извлекаем и компилируем шаблон if (!empty($this->curentdoc->rubric_template)) { $rubTmpl = $this->curentdoc->rubric_template; } else { $rubTmpl = $AVE_DB->Query("\r\n\t\t\t\t\t\t\tSELECT rubric_template\r\n\t\t\t\t\t\t\tFROM " . PREFIX . "_rubrics\r\n\t\t\t\t\t\t\tWHERE Id = '" . RUB_ID . "'\r\n\t\t\t\t\t\t\tLIMIT 1\r\n\t\t\t\t\t\t")->GetCell(); } $rubTmpl = trim($rubTmpl); if (empty($rubTmpl)) { // не задан шаблон рубрики $main_content = $this->_rubric_template_empty; } else { // парсим теги полей в шаблоне документа $main_content = preg_replace_callback('/\\[tag:fld:(\\d+)\\]/', 'document_get_field', $rubTmpl); // удаляем ошибочные теги полей $main_content = preg_replace('/\\[tag:fld:\\d*\\]/', '', $main_content); if (CACHE_DOC_TPL && empty($_POST) && !(isset($_SESSION['user_adminmode']) && $_SESSION['user_adminmode'] == 1)) { // кэширование разрешено // сохраняем скомпилированный шаблон в кэш $AVE_DB->Query("\r\n\t\t\t\t\t\t\t\tINSERT " . PREFIX . "_rubric_template_cache\r\n\t\t\t\t\t\t\t\tSET\r\n\t\t\t\t\t\t\t\t\thash = '" . $this->_get_cache_hash() . "',\r\n\t\t\t\t\t\t\t\t\trub_id = '" . RUB_ID . "',\r\n\t\t\t\t\t\t\t\t\tgrp_id = '" . UGROUP . "',\r\n\t\t\t\t\t\t\t\t\tdoc_id = '" . $id . "',\r\n\t\t\t\t\t\t\t\t\tcompiled = '" . addslashes($main_content) . "'\r\n\t\t\t\t\t\t\t"); } } } $main_content = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $this->curentdoc->document_published)), $main_content); $main_content = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $this->curentdoc->document_published)), $main_content); $main_content = str_replace('[tag:docauthor]', get_username_by_id($this->curentdoc->document_author_id), $main_content); } $out = str_replace('[tag:maincontent]', $main_content, $this->_coreDocumentTemplateGet(RUB_ID)); } // /вывод документа // Если в запросе пришел параметр print, т.е. страница для печати, парсим контент, который обрамлен // тегами только для печати if (isset($_REQUEST['print']) && $_REQUEST['print'] == 1) { $out = str_replace(array('[tag:if_print]', '[/tag:if_print]'), '', $out); $out = preg_replace('/\\[tag:if_notprint\\](.*?)\\[\\/tag:if_notprint\\]/si', '', $out); } else { // В противном случае наоборот, парсим только тот контент, который предназначен НЕ для печати $out = preg_replace('/\\[tag:if_print\\](.*?)\\[\\/tag:if_print\\]/si', '', $out); $out = str_replace(array('[tag:if_notprint]', '[/tag:if_notprint]'), '', $out); } // получаем из шаблона системный тег, определяющий название темы дизайна $match = ''; preg_match('/\\[tag:theme:(\\w+)]/', $out, $match); define('THEME_FOLDER', empty($match[1]) ? DEFAULT_THEME_FOLDER : $match[1]); $out = preg_replace('/\\[tag:theme:(.*?)]/', '', $out); // парсим теги модулей $out = $this->coreModuleTagParse($out); if (isset($_REQUEST['module']) && !(isset($this->install_modules[$_REQUEST['module']]) && '1' == $this->install_modules[$_REQUEST['module']]->Status)) { display_notice($this->_module_error); } // парсим теги системы внутренних запросов $out = preg_replace_callback('/\\[tag:request:(\\d+)\\]/', 'request_parse', $out); // парсим теги скрытого текста $out = parse_hide($out); // парсим остальные теги основного шаблона $search = array('[tag:mediapath]', '[tag:path]', '[tag:sitename]', '[tag:document]', '[tag:home]', '[tag:robots]', '[tag:docid]', '[tag:breadcrumb]'); $replace = array(ABS_PATH . 'templates/' . THEME_FOLDER . '/', ABS_PATH, htmlspecialchars(get_settings('site_name'), ENT_QUOTES), get_redirect_link('print'), get_home_link(), isset($this->curentdoc->document_meta_robots) ? $this->curentdoc->document_meta_robots : '', isset($this->curentdoc->Id) ? $this->curentdoc->Id : '', get_breadcrumb()); if (defined('MODULE_CONTENT')) { // парсинг тегов при выводе из модуля $search[] = '[tag:maincontent]'; $replace[] = MODULE_CONTENT; $search[] = '[tag:title]'; $replace[] = htmlspecialchars(defined('MODULE_SITE') ? MODULE_SITE : '', ENT_QUOTES); $search[] = '[tag:description]'; $replace[] = htmlspecialchars(defined('MODULE_DESCRIPTION') ? MODULE_DESCRIPTION : '', ENT_QUOTES); $search[] = '[tag:keywords]'; $replace[] = htmlspecialchars(defined('MODULE_KEYWORDS') ? MODULE_KEYWORDS : '', ENT_QUOTES); } else { $search[] = '[tag:keywords]'; $replace[] = isset($this->curentdoc->document_meta_keywords) ? htmlspecialchars($this->curentdoc->document_meta_keywords, ENT_QUOTES) : ''; $search[] = '[tag:description]'; $replace[] = isset($this->curentdoc->document_meta_description) ? htmlspecialchars($this->curentdoc->document_meta_description, ENT_QUOTES) : ''; $search[] = '[tag:title]'; $replace[] = htmlspecialchars(pretty_chars($this->curentdoc->document_title), ENT_QUOTES); } $search[] = '[tag:maincontent]'; $replace[] = ''; $search[] = '[tag:printlink]'; $replace[] = get_print_link(); $search[] = '[tag:version]'; $replace[] = APP_INFO; $search[] = '[tag:docviews]'; $replace[] = isset($this->curentdoc->document_count_view) ? $this->curentdoc->document_count_view : ''; $out = str_replace($search, $replace, $out); unset($search, $replace); // /парсим остальные теги основного шаблона // ЧПУ $out = rewrite_link($out); echo $out; }
# # Searches for lab configurations by search term # Called via Ajax from lab_configs.php # session_start(); include "../includes/db_lib.php"; include "../includes/user_lib.php"; include "../includes/page_elems.php"; $page_elems = new PageElems(); $search_term = trim($_REQUEST['q']); $admin_user_id = $_SESSION['user_id']; $lab_config_list = get_lab_configs($admin_user_id); if ($search_term == "") { # Return all entries $page_elems->getLabConfigTable($lab_config_list); return; } # Narrow down to matched configurations $matched_lab_config_list = array(); foreach ($lab_config_list as $lab_config) { if (stripos($lab_config->getSiteName(), $search_term) !== false) { $matched_lab_config_list[] = $lab_config; } else { $username = get_username_by_id($lab_config->adminUserId); if (stripos($username, $search_term) !== false) { $matched_lab_config_list[] = $lab_config; } } } $page_elems->getLabConfigTable($matched_lab_config_list);
/** * Метод, предназначенный для смены автора документа * * @param int $doc_id идентификатор документа * @param int $user_id идентификатор пользователя */ function changeAutorSave() { global $AVE_DB; // Если id документа число и оно больше 0, тогда if (is_numeric($_REQUEST['doc_id']) && $_REQUEST['doc_id'] > 0) { // Выполняем запрос к БД на обновление статуса у заметок $AVE_DB->Query("\n\t\t\t\tUPDATE " . PREFIX . "_documents\n\t\t\t\tSET document_author_id = '" . $_REQUEST['user_id'] . "'\n\t\t\t\tWHERE Id = '" . $_REQUEST['doc_id'] . "'\n\t\t\t"); $username = get_username_by_id($_REQUEST['user_id']); echo "\n\t\t\t\t<script>\n\t\t\t\t\twindow.opener.document.getElementById('doc_id_" . $_REQUEST['doc_id'] . "').textContent = '{$username}';\n\t\t\t\t\twindow.close();\n\t\t\t\t</script>\n\t\t\t"; } exit; }
public function getTestInfoRow($test) { # Returns HTML table row containing specimen info # Called by getSpecimenTestsTable() function ?> <tr valign='top'> <td> <?php echo get_test_name_by_id($test->testTypeId); ?> </td> <td> <?php if($test->isPending()) echo LangUtil::$generalTerms['PENDING_RESULTS']; else echo $test->decodeResult(); ?> </td> <td> <?php echo $test->getComments(); ?> </td> <td> <?php echo get_username_by_id($test->userId); ?> </td> <td> <?php echo $test->getVerifiedBy(); ?> </td> <td> <?php if(check_removal_record($_SESSION['lab_config_id'], $test->testId) && is_admin(get_user_by_id($_SESSION['user_id']))!=1){ echo "Test removed. Contact Lab admin"; } else if(check_removal_record($_SESSION['lab_config_id'], $test->testId) && is_admin(get_user_by_id($_SESSION['user_id']))==1){ ?> <a href='javascript:retrieve_deleted(<?php echo $test->testId;?>, "test")' title='Click to retrieve deleted Test'>Retrieve Test</a> <?php } else { ?> <a href="javascript:delete_test(<?php echo $test->testId ;?>)">Delete</a> <?php } ?> </td> <?php $specimen_object=Specimen::getById($test->specimenId); $pid=$specimen_object->patientId; $sid=$test->specimenId; ?> <!--<td><a href="javascript:get_report(<?php echo $pid;?>,<?php echo $sid;?> )">Report</a> </td>--> </tr> <?php }
/** * Обработка тега запроса. * Возвращает список документов удовлетворяющих параметрам запроса * оформленный с использованием шаблона * * @param int $id идентификатор запроса * @return string */ function request_parse($id, $params = array()) { global $AVE_Core, $AVE_DB, $request_documents; //Доберусь - надо сделать фишку чтобы если афтар не активен или удален то документы его в реквесте не выводятся //по идее это бы надстройкой к рекесту сделать чтобы новости не побить и т.д. $gen_time = microtime(); $return = ''; if (is_array($id)) { $id = $id[1]; } $row_ab = $AVE_DB->Query("\n\t\tSELECT *\n\t\tFROM " . PREFIX . "_request\n\t\tWHERE Id = '" . $id . "'\n\t")->FetchRow(); if (is_object($row_ab)) { $ttl = (int) $row_ab->request_cache_lifetime; $limit = isset($params['LIMIT']) && intval($params['LIMIT']) > 0 ? intval($params['LIMIT']) : ($row_ab->request_items_per_page > 0 ? $row_ab->request_items_per_page : 0); $main_template = $row_ab->request_template_main; $item_template = $row_ab->request_template_item; $request_order_by = $row_ab->request_order_by; $request_asc_desc = $row_ab->request_asc_desc; //строим списки подключаемых полей для сортировки $request_order = $request_order_by . " " . $request_asc_desc; $request_order_fields = ''; $request_order_tables = ''; $request_order1 = ''; if ($row_ab->request_order_by_nat) { $request_order_tables = "LEFT JOIN " . PREFIX . "_document_fields AS s" . $row_ab->request_order_by_nat . "\n\t\t\t ON (s" . $row_ab->request_order_by_nat . ".document_id = a.Id and s" . $row_ab->request_order_by_nat . ".rubric_field_id=" . $row_ab->request_order_by_nat . ")"; $request_order_fields = "s" . $row_ab->request_order_by_nat . ".field_value, "; $request_order = "s" . $row_ab->request_order_by_nat . ".field_value " . $row_ab->request_asc_desc; } $x = 0; if (!empty($params['SORT']) && is_array($params['SORT'])) { foreach ($params['SORT'] as $k => $v) { if (intval($k) > 0) { $x++; $request_order_tables .= "LEFT JOIN " . PREFIX . "_document_fields AS s" . $k . "\n\t\t\t\t\t\tON (s" . $k . ".document_id = a.Id and s" . $k . ".rubric_field_id=" . $k . ")"; if (strpos($v, 'INT') === false) { $request_order_fields .= "s" . $k . ".field_value, "; } else { $request_order_fields .= "s" . $k . ".field_number_value, "; $v = str_replace('INT', '', $v); } $request_order1 .= $x . ' ' . $v . ', '; } } } /* ----------- */ $request_order = addslashes($request_order1 . $request_order); $request_order2 = ''; /* ----------- */ //Этот кусок для того чтобы можно было параметрами попросить произвольный статус досумента //- например в личном кабинете попросить архивные документы $docstatus = "AND a.document_status != '0'"; $docstatus = "AND a.document_status = '1'"; if (isset($params['STATUS'])) { $docstatus = "AND a.document_status = '" . intval($params['STATUS']) . "'"; } $doctime = get_settings('use_doctime') ? "AND a.document_published <= UNIX_TIMESTAMP() AND\n \t\t \t(a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())" : ''; $where_cond = empty($_POST['req_' . $id]) && empty($_SESSION['doc_' . $AVE_Core->curentdoc->Id]['req_' . $id]) ? unserialize($row_ab->request_where_cond) : unserialize(request_get_condition_sql_string($row_ab->Id)); $where_cond['from'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['from']); @($where_cond['where'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['where'])); $whFromUser = (isset($params['USER_ID']) && intval($params['USER_ID']) > 0 ? ' AND a.document_author_id=' . intval($params['USER_ID']) : '') . (isset($params['USER_WHERE']) && $params['USER_WHERE'] > '' ? ' AND ' . $params['USER_WHERE'] : '') . (isset($params['PARENT']) && intval($params['PARENT']) > 0 ? ' AND a.document_parent=' . intval($params['PARENT']) : ''); $other_fields = ''; $other_tables = ''; $other_fields .= $request_order_fields; $other_tables .= $request_order_tables; if (isset($params['VIEWS'])) { $other_fields .= "(SELECT sum(v1.`count`) FROM " . PREFIX . "_view_count AS v1 WHERE v1.document_id=a.Id AND v1.day_id>" . strtotime($params['VIEWS'] ? $params['VIEWS'] : '-30 years') . ") AS dayviews,\n\t\t\t\t"; if ($params['VIEWS_ORDER'] > '') { $request_order1 = count(explode(',', $other_fields)) - 1 . ' ' . $params['VIEWS_ORDER'] . ','; } } if (isset($params['VOTE'])) { $other_fields .= "(SELECT " . $params['VOTE'] . "(v2.`vote`) FROM " . PREFIX . "_module_vote AS v2 WHERE type_of_doc='document' and v2.document_id=a.Id) AS votes,\n\t\t\t\t"; if ($params['VOTE_ORDER'] > '') { $request_order2 = count(explode(',', $other_fields)) - 1 . ' ' . $params['VOTE_ORDER']; } } if (!empty($AVE_Core->install_modules['comment']->ModuleStatus)) { $other_tables .= "\n\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\t" . PREFIX . "_module_comment_info AS b\n\t\t\t\t\t\t\tON b.document_id = a.Id " . (!empty($params['COMMENT']) ? " and b.comment_published>" . strtotime($params['COMMENT']) : '') . "\n\t\t\t\t\t"; $other_fields .= "COUNT(b.document_id) AS nums,\n\t\t\t\t"; if (!empty($params['COMMENT_ORDER'])) { $request_order1 = count(explode(',', $other_fields)) - 1 . ' ' . $params['COMMENT_ORDER'] . ','; } } $request_order = addslashes($request_order1 . ($request_order2 > '' ? $request_order1 ? $request_order2 . ',' : $request_order2 : '') . $request_order); $num = $AVE_DB->Query(eval2var(" ?>\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM\n\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\n\t\t\t" . PREFIX . "_documents AS a\n\t\t\tWHERE\n\t\t\t\ta.Id != '1'\n\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\n\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\n\t\t\tAND a.document_deleted != '1'\n\t\t\t" . $docstatus . "\n\t\t\t" . $whFromUser . "\n\t\t\t" . $where_cond['where'] . "\n\t\t\t" . ($row_ab->request_lang ? "AND a.document_lang='" . $_SESSION['user_language'] . "'" : "") . "\n\t\t\t" . $doctime . "\n\t\t<?php "), $ttl, 'rub_' . $row_ab->rubric_id)->GetCell(); if ($row_ab->request_show_pagination == 1) { $num_pages = $limit > 0 ? ceil($num / $limit) : 0; @($GLOBALS['page_id'][$_REQUEST['id']]['apage'] = @$GLOBALS['page_id'][$_REQUEST['id']]['apage'] > $num_pages ? $GLOBALS['page_id'][$_REQUEST['id']]['apage'] : $num_pages); if (isset($_REQUEST['apage']) && is_numeric($_REQUEST['apage']) && $_REQUEST['apage'] > $num_pages) { $redirect_link = rewrite_link('index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : '')); header('Location:' . $redirect_link); exit; } $start = get_current_page('apage') * $limit - $limit; } else { $start = 0; } $q = " ?>\n\t\t\tSELECT\n\t\t\t\t" . $other_fields . "\n\t\t\t\ta.Id,\n\t\t\t\ta.document_parent,\n\t\t\t\ta.document_title,\n\t\t\t\ta.document_alias,\n\t\t\t\ta.document_author_id,\n\t\t\t\ta.document_count_view,\n\t\t\t\ta.document_published,\n\t\t\t\ta.document_meta_keywords\n\t\t\tFROM\n\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\n\t\t\t\t" . PREFIX . "_documents AS a\n\t\t\t" . ($other_tables > '' ? $other_tables : '') . "\n\t\t\tWHERE\n\t\t\t\ta.Id != '1'\n\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\n\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\n\t\t\tAND a.document_deleted != '1'\n\t\t\t" . ($row_ab->request_lang ? "AND a.document_lang='" . $_SESSION['user_language'] . "'" : "") . "\n\t\t\t" . $whFromUser . "\n\t\t\t" . $docstatus . "\n\t\t\t" . $where_cond['where'] . "\n\t\t\t" . $doctime . "\n\t\t\tGROUP BY a.Id\n\t\t\tORDER BY " . $request_order . "\n\t\t\t" . ($limit > 0 ? "LIMIT " . $start . "," . $limit : '') . " <?php "; $q = eval2var($q); $q = $AVE_DB->Query($q, $ttl, 'rub_' . $row_ab->rubric_id); if ($q->NumRows() > 0) { $main_template = preg_replace('/\\[tag:if_empty](.*?)\\[\\/tag:if_empty]/si', '', $main_template); $main_template = str_replace(array('[tag:if_notempty]', '[/tag:if_notempty]'), '', $main_template); } else { $main_template = preg_replace('/\\[tag:if_notempty](.*?)\\[\\/tag:if_notempty]/si', '', $main_template); $main_template = str_replace(array('[tag:if_empty]', '[/tag:if_empty]'), '', $main_template); } $page_nav = ''; if ($row_ab->request_show_pagination == 1 && $num_pages > 1) { $page_nav = ' <a class="pnav" href="index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . '&apage={s}' . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : '') . '">{t}</a> '; $page_nav = get_pagination($num_pages, 'apage', $page_nav, get_settings('navi_box')); //$page_nav = rewrite_link($page_nav); // Костыль $page_nav = str_ireplace('"//"', '"/"', str_ireplace('///', '/', rewrite_link($page_nav))); } $rows = array(); $request_documents = array(); while ($row = $q->FetchRow()) { array_push($request_documents, $row->Id); array_push($rows, $row); } $items = ''; $x = 0; $items_count = count($rows); foreach ($rows as $row) { $x++; $item = showrequestelement($row, $item_template, $x, $x == $items_count ? true : false); $items .= $item; } // $items = preg_replace_callback('/\[tag:teaser:(\d+)\]/', "showteaser", $items); $main_template = preg_replace_callback('/\\[tag:sysblock:([0-9-]+)\\]/', 'parse_sysblock', $main_template); $main_template = str_replace('[tag:pages]', $page_nav, $main_template); $main_template = preg_replace('/\\[tag:date:([a-zA-Z0-9-]+)\\]/e', "RusDate(date('\$1', " . $AVE_Core->curentdoc->document_published . "))", $main_template); $main_template = str_replace('[tag:docid]', $AVE_Core->curentdoc->Id, $main_template); $main_template = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template); $main_template = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template); $main_template = str_replace('[tag:docauthor]', get_username_by_id($AVE_Core->curentdoc->document_author_id), $main_template); $main_template = str_replace('[tag:doctotal]', $num, $main_template); $main_template = str_replace('[tag:pagetitle]', $AVE_Core->curentdoc->document_title, $main_template); $main_template = preg_replace('/\\[tag:dropdown:([,0-9]+)\\]/e', "request_get_dropdown(\"\$1\", " . $row_ab->rubric_id . ", " . $row_ab->Id . ");", $main_template); $return = str_replace('[tag:content]', $items, $main_template); // парсим тизер документа //$return = preg_replace_callback('/\[tag:teaser:(\d+)\]/e', "showteaser", $return); $return = str_replace('[tag:path]', ABS_PATH, $return); $return = str_replace('[tag:mediapath]', ABS_PATH . 'templates/' . THEME_FOLDER . '/', $return); $return = $AVE_Core->coreModuleTagParse($return); } $gen_time = microtime() - $gen_time; $GLOBALS['block_generate'][] = array('REQUEST_' . $id => $gen_time); return $return; }
/** * Вывод списка галерей * * @param string $tpl_dir - путь к папке с шаблонами модуля */ function galleryListShow($tpl_dir) { global $AVE_DB, $AVE_Template; if (!empty($_POST['create'])) { foreach ($_POST['create'] as $gallery_id) { $this->_galleryImageMove((int) $gallery_id); } } $limit = $this->_limit_galleries; $start = get_current_page() * $limit - $limit; $galleries = array(); $sql = $AVE_DB->Query("\r\n\t\t\tSELECT SQL_CALC_FOUND_ROWS\r\n\t\t\t\tgal.*,\r\n\t\t\t\tCOUNT(img.id) AS image_count\r\n\t\t\tFROM\r\n\t\t\t\t" . PREFIX . "_modul_gallery AS gal\r\n\t\t\tLEFT JOIN\r\n\t\t\t\t" . PREFIX . "_modul_gallery_images AS img\r\n\t\t\t\t\tON img.gallery_id = gal.id\r\n\t\t\tGROUP BY gal.id\r\n\t\t\tORDER BY gal.gallery_created DESC\r\n\t\t\tLIMIT " . $start . "," . $limit . "\r\n\t\t"); $num = $AVE_DB->Query("SELECT FOUND_ROWS()")->GetCell(); while ($row = $sql->FetchAssocArray()) { $row['username'] = get_username_by_id($row['gallery_author_id']); array_push($galleries, $row); } if ($num > $limit) { $page_nav = ' <a class="pnav" href="index.php?do=modules&action=modedit&mod=gallery&moduleaction=1&cp=' . SESSION . '&page={s}">{t}</a> '; $page_nav = get_pagination(ceil($num / $limit), 'page', $page_nav); $AVE_Template->assign('page_nav', $page_nav); } if (!empty($_REQUEST['alert'])) { $AVE_Template->assign('alert', htmlspecialchars(stripslashes($_REQUEST['alert']))); } $AVE_Template->assign('galleries', $galleries); $AVE_Template->assign('formaction', 'index.php?do=modules&action=modedit&mod=gallery&moduleaction=new&sub=save&cp=' . SESSION); $AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_gallery_list.tpl')); }
public function getLogsByID($id, $datefrom = NULL, $dateto = NULL) { $csvdata = apc_fetch('csvdata'); $log = array(); foreach ($csvdata as $data) { if ($data[1] == $id) { $level = get_level_by_id($data[4]); $uname = get_username_by_id($data[4]); $data[4] = $uname . "(" . $level . ")"; $labconfig_obj = get_lab_config_by_id($data[5]); $data[5] = $labconfig_obj->name; array_push($log, $data); } } return $log; }
</tr> <tr> <td><?php echo "Country"; $page_elems->getAsterisk(); ?> </td> <!--<td><select name='country' id='country'> <?php foreach ($labIdArray as $key => $value) { echo "<option value='{$key}'>{$key}</option>"; } ?> </select></td>--> <td><?php $usr_c = get_username_by_id($_SESSION['user_id']); $usr_c = strtolower($usr_c); $usr_c = ucfirst($usr_c); $usr_cs = substr($usr_c, 0, strpos($usr_c, "_")); echo $usr_cs; ?> <input type="hidden" name="country" value="<?php echo $usr_cs; ?> "> </td> </tr> <?php //If user is superadmin if (true) { ?>
/** * Метод, предназанченный для сборки всей страницы в единое целое. * * @param int $id идентификатор документа * @param int $rub_id идентификатор рубрики */ function coreSiteFetch($id, $rub_id = '') { global $AVE_DB; // Если происходит вызов модуля, получаем соответствующие мета-теги и получаем шаблон модуля if (!empty($_REQUEST['module'])) { $out = $this->_coreModuleMetatagsFetch(); $out = $this->_coreDocumentTemplateGet('', '', $this->_coreModuleTemplateGet()); } else { if (!isset($this->curentdoc->Id) && !$this->_coreCurrentDocumentFetch($id, UGROUP)) { // Определяем документ с 404 ошиюкой, в случае, если документ не найден if ($this->_corePageNotFoundFetch(PAGE_NOT_FOUND_ID, UGROUP)) { $_REQUEST['id'] = $_GET['id'] = $id = PAGE_NOT_FOUND_ID; } } // проверяем параметры публикации документа if (!$this->_coreDocumentIsPublished()) { $this->_coreErrorPage404(); } // Определяем права доступа к документам рубрики define('RUB_ID', !empty($rub_id) ? $rub_id : $this->curentdoc->rubric_id); $this->_coreRubricPermissionFetch(RUB_ID); if (!(isset($_SESSION[RUB_ID . '_docread']) && $_SESSION[RUB_ID . '_docread'] == 1 || isset($_SESSION[RUB_ID . '_alles']) && $_SESSION[RUB_ID . '_alles'] == 1)) { // читать запрещено - извлекаем ругательство и отдаём вместо контента $main_content = get_settings('message_forbidden'); } else { if (isset($_REQUEST['print']) && $_REQUEST['print'] == 1) { // увеличиваем счетчик версий для печати $AVE_DB->Query("\n\t\t\t\t\t\tUPDATE " . PREFIX . "_documents\n\t\t\t\t\t\tSET document_count_print = document_count_print+1\n\t\t\t\t\t\tWHERE Id = '" . $id . "'\n\t\t\t\t\t"); } else { if (!isset($_SESSION['doc_view'][$id])) { // увеличиваем счетчик просмотров (1 раз в пределах сессии) $AVE_DB->Query("\n\t\t\t\t\t\t\tUPDATE " . PREFIX . "_documents\n\t\t\t\t\t\t\tSET document_count_view = document_count_view+1\n\t\t\t\t\t\t\tWHERE Id = '" . $id . "'\n\t\t\t\t\t\t"); $_SESSION['doc_view'][$id] = time(); } $curdate = mktime(0, 0, 0, date("m"), date("d"), date("Y")); if (!isset($_SESSION['doc_view_dayly[' . $curdate . '][' . $id . ']'])) { // и подневный счетчик просмотров тоже увеличиваем $curdate = mktime(0, 0, 0, date("m"), date("d"), date("Y")); $AVE_DB->Query("\n UPDATE\n " . PREFIX . "_view_count\n SET\n count = count + 1\n WHERE\n document_id = '" . $id . "' AND\n day_id = '" . $curdate . "'\n "); if (!$AVE_DB->_handle->affected_rows) { $AVE_DB->Query("\n INSERT INTO " . PREFIX . "_view_count (\n document_id,\n day_id,\n count\n )\n VALUES (\n '" . $id . "', '" . $curdate . "', '1'\n )\n "); } $_SESSION['doc_view_dayly[' . $curdate . '][' . $id . ']'] = time(); } } if (CACHE_DOC_TPL && empty($_POST) && !(isset($_SESSION['user_adminmode']) && $_SESSION['user_adminmode'] == 1)) { // кэширование разрешено // извлекаем скомпилированный шаблон документа из кэша $main_content = $AVE_DB->Query("\n\t\t\t\t\t\tSELECT compiled\n\t\t\t\t\t\tFROM " . PREFIX . "_rubric_template_cache\n\t\t\t\t\t\tWHERE hash = '" . $this->_get_cache_hash() . "'\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t")->GetCell(); } else { // кэширование запрещено $main_content = false; } if (empty($main_content)) { // кэш пустой или отключен, извлекаем и компилируем шаблон if (!empty($this->curentdoc->rubric_template)) { $rubTmpl = $this->curentdoc->rubric_template; } else { $rubTmpl = $AVE_DB->Query("\n\t\t\t\t\t\t\tSELECT rubric_template\n\t\t\t\t\t\t\tFROM " . PREFIX . "_rubrics\n\t\t\t\t\t\t\tWHERE Id = '" . RUB_ID . "'\n\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t")->GetCell(); } $rubTmpl = trim($rubTmpl); if (empty($rubTmpl)) { // не задан шаблон рубрики $main_content = $this->_rubric_template_empty; } else { // парсим теги полей в шаблоне документа $main_content = preg_replace_callback('/\\[tag:fld:([a-zA-Z0-9-_]+)\\]/', 'document_get_field', $rubTmpl); $main_content = preg_replace_callback('/\\[tag:([r|c|f|t]\\d+x\\d+r*):(.+?)]/', 'callback_make_thumbnail', $main_content); // удаляем ошибочные теги полей $main_content = preg_replace('/\\[tag:fld:\\d*\\]/', '', $main_content); if (CACHE_DOC_TPL && empty($_POST) && !(isset($_SESSION['user_adminmode']) && $_SESSION['user_adminmode'] == 1)) { // кэширование разрешено // сохраняем скомпилированный шаблон в кэш $AVE_DB->Query("\n\t\t\t\t\t\t\t\tINSERT " . PREFIX . "_rubric_template_cache\n\t\t\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t\t\thash = '" . $this->_get_cache_hash() . "',\n\t\t\t\t\t\t\t\t\trub_id = '" . RUB_ID . "',\n\t\t\t\t\t\t\t\t\tgrp_id = '" . UGROUP . "',\n\t\t\t\t\t\t\t\t\tdoc_id = '" . $id . "',\n\t\t\t\t\t\t\t\t\tcompiled = '" . addslashes($main_content) . "'\n\t\t\t\t\t\t\t"); } } } $main_content = preg_replace('/\\[tag:date:([a-zA-Z0-9-]+)\\]/e', "RusDate(date('\$1', " . $this->curentdoc->document_published . "))", $main_content); $main_content = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $this->curentdoc->document_published)), $main_content); $main_content = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $this->curentdoc->document_published)), $main_content); $main_content = str_replace('[tag:docauthorid]', $this->curentdoc->document_author_id, $main_content); $main_content = str_replace('[tag:docauthor]', get_username_by_id($this->curentdoc->document_author_id), $main_content); } $out = str_replace('[tag:maincontent]', $main_content, $this->_coreDocumentTemplateGet(RUB_ID)); } // /вывод документа //Работа с условиями /* $out = preg_replace('/\[tag:if_exp:?(.*)\]/u', '<?php $my_exp000=true; $my_exp0001=\'$my_exp000=\'. str_replace(\'#var#\',\'$\',<<<BLOCK $1; BLOCK ); @eval($my_exp0001); if($my_exp000==true) { ?>', $out); $out = str_replace('[tag:if_exp_else]', '<?php }else{ ?>', $out); $out = str_replace('[tag:/if_exp]', '<?php } ?>', $out); */ // Тут мы вводим в хеадер иньекцию скриптов. if (defined('RUB_ID')) { $rubheader = $AVE_DB->Query("\n\t\t\t\t\t\t\tSELECT rubric_header_template\n\t\t\t\t\t\t\tFROM " . PREFIX . "_rubrics\n\t\t\t\t\t\t\tWHERE Id = '" . RUB_ID . "'\n\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t", CACHE_LIFETIME)->GetCell(); $out = str_replace('[tag:rubheader]', $rubheader . '[tag:rubheader]', $out); } $out = preg_replace('/\\[tag:rfld:([a-zA-Z0-9-_]+)]\\[(more|esc|img|[0-9-]+)]/e', "request_get_document_field(\"\$1\", {$id}, \"\$2\")", $out); // Если в запросе пришел параметр print, т.е. страница для печати, парсим контент, который обрамлен // тегами только для печати if (isset($_REQUEST['print']) && $_REQUEST['print'] == 1) { $out = str_replace(array('[tag:if_print]', '[/tag:if_print]'), '', $out); $out = preg_replace('/\\[tag:if_notprint\\](.*?)\\[\\/tag:if_notprint\\]/si', '', $out); } else { // В противном случае наоборот, парсим только тот контент, который предназначен НЕ для печати $out = preg_replace('/\\[tag:if_print\\](.*?)\\[\\/tag:if_print\\]/si', '', $out); $out = str_replace(array('[tag:if_notprint]', '[/tag:if_notprint]'), '', $out); } // получаем из шаблона системный тег, определяющий название темы дизайна $match = ''; preg_match('/\\[tag:theme:(\\w+)]/', $out, $match); define('THEME_FOLDER', empty($match[1]) ? DEFAULT_THEME_FOLDER : $match[1]); $out = preg_replace('/\\[tag:theme:(.*?)]/', '', $out); // парсим теги модулей $out = $this->coreModuleTagParse($out); if (isset($_REQUEST['module']) && !(isset($this->install_modules[$_REQUEST['module']]) && '1' == $this->install_modules[$_REQUEST['module']]->ModuleStatus)) { display_notice($this->_module_error); } // парсим теги системных блоков $out = preg_replace_callback('/\\[tag:sysblock:([0-9-]+)\\]/', 'parse_sysblock', $out); // парсим теги системы внутренних запросов $out = preg_replace_callback('/\\[tag:request:(\\d+)\\]/', 'request_parse', $out); // парсим теги навигации $out = preg_replace_callback('/\\[tag:navigation:(\\d+):?([0-9,]*)\\]/', 'parse_navigation', $out); // парсим теги скрытого текста $out = parse_hide($out); // парсим остальные теги основного шаблона $search = array('[tag:mediapath]', '[tag:path]', '[tag:sitename]', '[tag:document]', '[tag:alias]', '[tag:home]', '[tag:robots]', '[tag:canonical]', '[tag:docid]', '[tag:breadcrumb]'); $replace = array(ABS_PATH . 'templates/' . THEME_FOLDER . '/', ABS_PATH, htmlspecialchars(get_settings('site_name'), ENT_QUOTES), get_redirect_link('print'), @$this->curentdoc->document_alias, get_home_link(), isset($this->curentdoc->document_meta_robots) ? $this->curentdoc->document_meta_robots : '', canonical($_SERVER['REQUEST_URI']), isset($this->curentdoc->Id) ? $this->curentdoc->Id : '', get_breadcrumb()); if (defined('MODULE_CONTENT')) { // парсинг тегов при выводе из модуля $search[] = '[tag:maincontent]'; $replace[] = MODULE_CONTENT; $search[] = '[tag:title]'; $replace[] = htmlspecialchars(defined('MODULE_SITE') ? MODULE_SITE : '', ENT_QUOTES); $search[] = '[tag:description]'; $replace[] = htmlspecialchars(defined('MODULE_DESCRIPTION') ? MODULE_DESCRIPTION : '', ENT_QUOTES); $search[] = '[tag:keywords]'; $replace[] = htmlspecialchars(defined('MODULE_KEYWORDS') ? MODULE_KEYWORDS : '', ENT_QUOTES); } else { $search[] = '[tag:keywords]'; $replace[] = isset($this->curentdoc->document_meta_keywords) ? htmlspecialchars($this->curentdoc->document_meta_keywords, ENT_QUOTES) : ''; $search[] = '[tag:description]'; $replace[] = isset($this->curentdoc->document_meta_description) ? htmlspecialchars($this->curentdoc->document_meta_description, ENT_QUOTES) : ''; $search[] = '[tag:title]'; $replace[] = htmlspecialchars(pretty_chars($this->curentdoc->document_title), ENT_QUOTES); } $search[] = '[tag:maincontent]'; $replace[] = ''; $search[] = '[tag:printlink]'; $replace[] = get_print_link(); $search[] = '[tag:version]'; $replace[] = APP_INFO; $search[] = '[tag:docviews]'; $replace[] = isset($this->curentdoc->document_count_view) ? $this->curentdoc->document_count_view : ''; // парсим тизер документа $out = preg_replace('/\\[tag:teaser:(\\d+)\\]/e', "showteaser(\$1)", $out); if (defined('RUB_ID')) { $out = preg_replace('/\\[tag:docauthoravatar:(\\d+)\\]/e', "getAvatar(" . intval($this->curentdoc->document_author_id) . ",\"\$1\")", $out); } if (defined('RUB_ID')) { $out = preg_replace('/\\[tag:lang:([a-zA-Z0-9-_]+)\\]/', '<?php if($AVE_Core->curentdoc->document_lang=="$1") { ?>', $out); } else { $out = preg_replace('/\\[tag:lang:([a-zA-Z0-9-_]+)\\]/', '<?php if($_SESSION["user_language"]=="$1") { ?>', $out); } $out = str_replace('[tag:/lang]', '<?php } ?>', $out); // парсим остальные теги основного шаблона $out = str_replace($search, $replace, $out); unset($search, $replace); // парсим теги для combine.php $out = preg_replace_callback('/\\[tag:(css|js):([^ :\\/]+):?(\\S+)*\\]/', array($this, '_parse_combine'), $out); // ЧПУ $out = rewrite_link($out); echo $out; }
echo LangUtil::$generalTerms['TESTS']; ?> </b>: <br> <?php $test_list = get_tests_by_specimen_id($specimen_id); foreach ($test_list as $test) { echo get_test_name_by_id($test->testTypeId) . " :- <br>"; if ($test->isPending()) { echo " " . LangUtil::$generalTerms['PENDING_RESULTS']; } else { echo " " . LangUtil::$generalTerms['ENTERED_BY'] . ": " . get_username_by_id($test->userId) . " on: " . $test->timestamp; } echo "<br>"; if ($test->isVerified()) { echo " " . LangUtil::$generalTerms['VERIFIED_BY'] . ": " . get_username_by_id($test->verifiedBy) . " on: " . $test->getDateVerified(); } else { echo " " . LangUtil::$generalTerms['PENDING_VER']; } echo "<br>"; if ($specimen->isReported()) { echo " " . LangUtil::$generalTerms['REPORTED'] . ": " . $specimen->getDateReported(); echo "<br>"; echo " " . LangUtil::$generalTerms['REPORT_TO'] . ": " . $specimen->getReportTo(); } else { echo " " . LangUtil::$generalTerms['REPORTED_NOT']; } echo "<br>"; } ?> </div>
function roadmapTaskShow($tpl_dir, $project_id, $status) { global $AVE_DB, $AVE_Template; $project_id = (int) $project_id; $status = (int) $status; $items = array(); $sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_modul_roadmap_tasks\r\n\t\t\tWHERE pid = '" . $project_id . "'\r\n\t\t\tAND task_status = '" . $status . "'\r\n\t\t\tORDER BY priority\r\n\t\t"); while ($row = $sql->FetchRow()) { $row->username = get_username_by_id($row->uid); switch ($row->priority) { case '1': $row->priority = $AVE_Template->get_config_vars('ROADMAP_TASK_HIGHEST'); $row->prio = 1; break; case '2': $row->priority = $AVE_Template->get_config_vars('ROADMAP_TASK_HIGH'); $row->prio = 2; break; case '3': $row->priority = $AVE_Template->get_config_vars('ROADMAP_TASK_NORMAL'); $row->prio = 3; break; case '4': $row->priority = $AVE_Template->get_config_vars('ROADMAP_TASK_LOW'); $row->prio = 4; break; case '5': $row->priority = $AVE_Template->get_config_vars('ROADMAP_TASK_LOWEST'); $row->prio = 5; break; } array_push($items, $row); } $row_r = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_modul_roadmap\r\n\t\t\tWHERE id = '" . $project_id . "'\r\n\t\t")->FetchRow(); $AVE_Template->assign('row', $row_r); $AVE_Template->assign('items', $items); define('MODULE_CONTENT', $AVE_Template->fetch($tpl_dir . 'tasks.tpl')); }
public function getTestInfoRow($test) { # Returns HTML table row containing specimen info # Called by getSpecimenTestsTable() function ?> <tr valign='top'> <td> <?php echo get_test_name_by_id($test->testTypeId); ?> </td> <td> <?php if($test->isPending()) echo LangUtil::$generalTerms['PENDING_RESULTS']; else echo $test->decodeResult(); ?> </td> <td> <?php echo $test->getComments(); ?> </td> <td> <?php echo get_username_by_id($test->userId); ?> </td> <td> <?php echo $test->getVerifiedBy(); ?> </td> <?php $specimen_object=Specimen::getById($test->specimenId); $pid=$specimen_object->patientId; $sid=$test->specimenId; ?> <!--<td><a href="javascript:get_report(<?php echo $pid;?>,<?php echo $sid;?> )">Report</a> </td>--> </tr> <?php }
--> </style> <body bgcolor="#000000" text="#DDDDDD" background="/gfx/bg_stars1.gif"> <table class="style_outer" width="550" align="center" border="0" cellpadding="2" cellspacing="2"> <tr> <td> <table class="style_inner" width="550" align="center" border="0" cellpadding="2" cellspacing="2"> '; if (isset($_GET['user'])) { $user_id = (int) $_GET['user']; echo '<td> </td><td><font size="3"><b>' . constant($game->sprache("TEXT1")) . '</b></font></td><td><font size="3"><b>' . get_username_by_id($user_id) . '</b></font></td></tr><tr><td> </td></tr><tr><td></td><td width="235"><b>' . constant($game->sprache("TEXT2")) . '</b></td><td width="200"><b>' . constant($game->sprache("TEXT3")) . '</b></td><td width="70"><b>' . constant($game->sprache("TEXT4")) . '</b></td></tr>'; $config = $db->queryrow('SELECT * FROM config'); $sql = 'SELECT * FROM ship_trade WHERE user = '******' AND end_time > ' . $config['tick_id'] . ''; if (!($q_tradedata = $db->query($sql))) { message(DATABASE_ERROR, 'Could not query tradedata'); } while ($tradedata = $db->fetchrow($q_tradedata)) { echo '<tr><td width="55" align="center">[<a onclick="opener.window.location=this.href;self.close();return false" href="/game/index.php?a=trade&view=view_bidding_detail&id=' . $tradedata['id'] . '">' . constant($game->sprache("TEXT5")) . '</a>]</td><td>' . $tradedata['header'] . '</td><td><img src="' . PROXY_GFX_PATH . '/skin1/menu_metal_small.gif"> ' . $tradedata['resource_1'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_mineral_small.gif"> ' . $tradedata['resource_2'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_latinum_small.gif"> ' . $tradedata['resource_3'] . ' <br><img src="' . PROXY_GFX_PATH . '/skin1/menu_unit1_small.gif"> ' . $tradedata['unit_1'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_unit2_small.gif"> ' . $tradedata['unit_2'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_unit3_small.gif"> ' . $tradedata['unit_3'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_unit4_small.gif"> ' . $tradedata['unit_4'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_unit5_small.gif"> ' . $tradedata['unit_5'] . ' <img src="' . PROXY_GFX_PATH . '/skin1/menu_unit6_small.gif"> ' . $tradedata['unit_6'] . '</td><td>' . Zeit(TICK_DURATION * ($tradedata['end_time'] - $config['tick_id'])) . '</td></tr>'; } } else { echo constant($game->sprache("TEXT6")); } echo '</table></td></tr></table></body> </html>'; $db->close();
public function getVerifiedBy() { # Returns username of the technician who verified results # Or, "Not verified" if results are pending verification if ($this->isVerified()) { return get_username_by_id($this->verifiedBy); } return LangUtil::$generalTerms['PENDING_VER']; }
$num_tpl = $AVE_DB->Query("\r\n\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\tFROM " . PREFIX . "_templates\r\n\t\t\t")->GetCell(); $page_limit = isset($_REQUEST['set']) && is_numeric($_REQUEST['set']) ? (int) $_REQUEST['set'] : 30; $seiten = ceil($num_tpl / $page_limit); $set_start = get_current_page() * $page_limit - $page_limit; if ($num_tpl > $page_limit) { $page_nav = " <a class=\"pnav\" href=\"index.php?do=templates&page={s}&cp=" . SESSION . "\">{t}</a> "; $page_nav = get_pagination($seiten, 'page', $page_nav); $AVE_Template->assign('page_nav', $page_nav); } $sql = $AVE_DB->Query("\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM " . PREFIX . "_templates\r\n\t\t\t\tLIMIT " . $set_start . "," . $page_limit . "\r\n\t\t\t"); while ($row = $sql->FetchRow()) { $inuse = $AVE_DB->Query("\r\n\t\t\t\t\tSELECT 1\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\t" . PREFIX . "_rubrics AS rubric,\r\n\t\t\t\t\t\t" . PREFIX . "_module AS module\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\trubric.rubric_template_id = '" . $row->Id . "' OR\r\n\t\t\t\t\t\tmodule.ModuleTemplate = '" . $row->Id . "'\r\n\t\t\t\t\tLIMIT 1\r\n\t\t\t\t")->NumRows(); if (!$inuse) { $row->can_deleted = 1; } $row->template_author = get_username_by_id($row->template_author_id); array_push($items, $row); unset($row); } $AVE_Template->assign('items', $items); $AVE_Template->assign('content', $AVE_Template->fetch('templates/templates.tpl')); } break; case 'new': if (check_permission_acp('template_new')) { $_REQUEST['sub'] = isset($_REQUEST['sub']) ? $_REQUEST['sub'] : ''; switch ($_REQUEST['sub']) { case 'savenew': $save = true; $row->template_text = pretty_chars($_REQUEST['template_text']); $row->template_text = stripslashes($row->template_text);
/** * Метод управления комментариями к опросам * * @param string $tpl_dir путь к папке с шаблонами модуля * @param string $lang_file путь к языковому файлу модуля * @param int $pid идентификатор опроса */ function pollCommentEdit($tpl_dir, $lang_file, $pid) { global $AVE_DB, $AVE_Template; $AVE_Template->config_load($lang_file, 'showcomments'); switch ($_REQUEST['sub']) { case '': $items = array(); $sql = $AVE_DB->Query("\r\n\t\t\t\t\tSELECT *\r\n\t\t\t\t\tFROM " . PREFIX . "_modul_poll_comments\r\n\t\t\t\t\tWHERE poll_id = '" . $pid . "'\r\n\t\t\t\t"); while ($row = $sql->FetchRow()) { $row->poll_comment_author = get_username_by_id($row->poll_comment_author_id); array_push($items, $row); } $AVE_Template->assign('items', $items); $AVE_Template->assign('tpl_dir', $tpl_dir); $AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_comments.tpl')); break; case 'save': if (!empty($_POST['del'])) { foreach ($_POST['del'] as $id => $val) { $AVE_DB->Query("\r\n\t\t\t\t\t\t\tDELETE\r\n\t\t\t\t\t\t\tFROM " . PREFIX . "_modul_poll_comments\r\n\t\t\t\t\t\t\tWHERE id = '" . $id . "'\r\n\t\t\t\t\t\t"); } } foreach ($_POST['comment_text'] as $id => $comment) { if (!empty($comment)) { $AVE_DB->Query("\r\n\t\t\t\t\t\t\tUPDATE " . PREFIX . "_modul_poll_comments\r\n\t\t\t\t\t\t\tSET\r\n\t\t\t\t\t\t\t\tpoll_comment_title = '" . $_POST['comment_title'][$id] . "',\r\n\t\t\t\t\t\t\t\tpoll_comment_text = '" . $comment . "'\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tid = '" . $id . "'\r\n\t\t\t\t\t\t"); } } header('Location:index.php?do=modules&action=modedit&mod=poll&moduleaction=comments&id=' . $pid . '&pop=1&cp=' . SESSION); exit; } }
} ?> </select> </td> <?php } } $measure_count++; } ?> <td><input name='comments[]' type='text' value='<?php echo $test_entry->comments; ?> '></input></td> <td><?php echo get_username_by_id($test_entry->userId); ?> </td> <td> <center> <input type='checkbox' class='verify_flag' name='verify_flag_<?php echo $i; ?> ' onchange='javascript:toggle_verify(<?php echo $i; ?> );' checked></input> </center> </td> </tr> <?php
echo LangUtil::$generalTerms['G_DATE']; ?> : <?php echo date($_SESSION['dformat']); ?> </h3> <h3><?php echo $report_config->titleText; ?> </h3> <br> <?php echo LangUtil::$generalTerms['TECHNICIAN']; ?> : <?php echo get_username_by_id($_SESSION['user_id']); if ($cat_code != 0) { echo " | " . LangUtil::$generalTerms['LAB_SECTION'] . ": " . get_test_category_name_by_id($cat_code); } ?> <br><br> <?php # Build list of test types to handle $test_type_list = array(); if ($test_type_id != 0) { # Only one test type selected $test_type_list[] = TestType::getById($test_type_id); } else { # Fetch all test types belonging to this lab section $test_type_list = get_test_types_by_site_category($_SESSION['lab_config_id'], $cat_code); }
function check_special_fields($field_name, $source_object, $use_past_array = false, $context = null) { global $locale; // FIXME: Special cases for known non-db but allowed fields if ($field_name == 'full_name') { if ($use_past_array == false) { //use the future value return $locale->formatName($source_object); } else { //use the past value return $locale->formatName($source_object, $source_object->fetched_row); } } elseif ($field_name == 'modified_by_name' && $use_past_array) { return $source_object->old_modified_by_name; } elseif ($field_name == 'assigned_user_name') { //load the user for either the current value or past value. // We have to load the user here since fetched_row only has the ID, not the name if ($use_past_array) { //return previous assigned user from fetched row return get_username_by_id($source_object->fetched_row['assigned_user_id']); } //return current assigned user in source object return get_username_by_id($source_object->assigned_user_id); } elseif ($field_name == 'team_name') { require_once 'modules/Teams/TeamSetManager.php'; if ($use_past_array == false) { if (empty($source_object->team_set_id)) { if (!empty($source_object->teams)) { $source_object->teams->save(); } } $team_set_id = $source_object->team_set_id; $team_id = $source_object->team_id; } else { $team_set_id = $source_object->fetched_row['team_set_id']; $team_id = $source_object->fetched_row['team_id']; } return TeamSetManager::getCommaDelimitedTeams($team_set_id, $team_id, true); } else { /*One off exception for if we are getting future date_created value. Use the fetched row for it. - jgreen */ if ($use_past_array == false && $field_name != "date_entered") { //use the future value return get_display_text($source_object, $field_name, $source_object->{$field_name}, null, null, $context); } else { //use the past value return get_display_text($source_object, $field_name, $source_object->fetched_row[$field_name], null, null, $context); } } //In future, check for maybe currency type //end function check_special_fields }