PHP Layout::highlight方法代码示例

 public function gettimeperiodslistTask()
 {
     //read input data (table parameters and filter)
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem'));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $filter_text = Get::req('filter_text', DOTY_STRING, '');
     $searchFilter = array('text' => $filter_text);
     //calculate total records to display
     $total = $this->model->getTimePeriodsTotal($searchFilter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     //get records from DB and format data
     $list = $this->model->getTimePeriodsList($startIndex, $results, $sort, $dir, $searchFilter);
     $output_records = array();
     if (is_array($list) && count($list) > 0) {
         foreach ($list as $record) {
             $output_records[] = array('id' => (int) $record->id_period, 'title' => Layout::highlight($record->title, $filter_text), 'label' => Layout::highlight($record->label, $filter_text), 'start_date' => Format::date($record->start_date, "date"), 'end_date' => Format::date($record->end_date, "date"), 'mod' => 'ajax.adm_server.php?r=alms/timeperiods/mod&id=' . (int) $record->id_period, 'del' => 'ajax.adm_server.php?r=alms/timeperiods/del&id=' . (int) $record->id_period);
         }
     }
     //prepare the output for the datatable
     $output = array('totalRecords' => $total, 'startIndex' => $startIndex, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $rowsPerPage, 'results' => count($output_records), 'records' => $output_records);
     echo $this->json->encode($output);
 }

 public function getusertabledataTask()
 {
     $op = Get::req('op', DOTY_MIXED, false);
     switch ($op) {
         case "selectall":
             $this->_selectAllUsers();
             return;
             break;
     }
     $idOrg = 0;
     //Get::req('id_org', DOTY_INT, 0);
     $descendants = false;
     //(Get::req('descendants', DOTY_INT, 0) > 0 ? true : false);
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $learning_filter = Get::req('learning_filter', DOTY_STRING, 'none');
     $var_fields = Get::req('_dyn_field', DOTY_MIXED, array());
     if (stristr($sort, '_dyn_field_') !== false) {
         $index = str_replace('_dyn_field_', '', $sort);
         $sort = $var_fields[(int) $index];
     }
     $filter_text = Get::req('filter_text', DOTY_STRING, '');
     $searchFilter = array('text' => $filter_text, 'suspended' => Get::req('suspended', DOTY_INT, 1) > 0 ? true : false);
     $dyn_filter = $this->_getDynamicFilter(Get::req('dyn_filter', DOTY_STRING, ''));
     if ($dyn_filter !== false) {
         $searchFilter['dyn_filter'] = $dyn_filter;
     }
     $total = $this->user_model->getTotalUsers($idOrg, $descendants, $searchFilter, true, $learning_filter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     $list = $this->user_model->getUsersList($idOrg, $descendants, $pagination, $searchFilter, true, $learning_filter);
     //prepare the data for sending
     require_once _adm_ . '/lib/lib.field.php';
     $fman = new FieldList();
     $date_fields = $fman->getFieldsByType("date");
     $acl_man = Docebo::user()->getAclManager();
     $idst_org = $acl_man->getGroupST('/oc_' . (int) $idOrg);
     $output_results = array();
     if (is_array($list) && count($list) > 0) {
         foreach ($list as $idst => $record) {
             $record_row = array('id' => (int) $record['idst'], 'userid' => Layout::highlight($acl_man->relativeId($record['userid']), $filter_text), 'firstname' => Layout::highlight($record['firstname'], $filter_text), 'lastname' => Layout::highlight($record['lastname'], $filter_text), 'email' => Layout::highlight($record['email'], $filter_text), 'register_date' => Format::date($record['register_date'], "datetime"), 'lastenter' => Format::date($record['lastenter'], "datetime"), 'unassoc' => $idOrg > 0 ? $record['is_descendant'] ? 0 : 1 : -1, 'valid' => $record['valid'], 'mod' => 'ajax.adm_server.php?r=adm/usermanagement/moduser&id=' . (int) $idst, 'del' => 'ajax.adm_server.php?r=adm/usermanagement/deluser&id=' . (int) $idst);
             foreach ($var_fields as $i => $value) {
                 if (is_numeric($value)) {
                     $name = '_custom_' . $value;
                 } else {
                     $name = $value;
                 }
                 //check if we must perform some post-format on retrieved field values
                 $content = isset($record[$name]) ? $record[$name] : '';
                 if ($name == 'register_date') {
                     $content = Format::date($content, 'datetime');
                 }
                 if ($name == 'lastenter') {
                     $content = Format::date($content, 'datetime');
                 }
                 if ($name == 'level' && $content != '') {
                     $content = Lang::t('_DIRECTORY_' . $content, 'admin_directory');
                 }
                 if (!empty($date_fields) && in_array($value, $date_fields)) {
                     $content = Format::date(substr($content, 0, 10), 'date');
                 }
                 $record_row['_dyn_field_' . $i] = $content;
             }
             $output_results[] = $record_row;
         }
     }
     $output = array('totalRecords' => $total, 'startIndex' => $startIndex, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $rowsPerPage, 'results' => count($output_results), 'records' => $output_results);
     echo $this->json->encode($output);
 }

 require_once _lms_ . '/lib/lib.edition.php';
 require_once _lms_ . '/lib/lib.date.php';
 require_once _base_ . '/lib/lib.json.php';
 $ed_man = new EditionManager();
 $dt_man = new DateManager();
 $json = new Services_JSON();
 $output = array('courses' => array());
 $filter = Get::req('query', DOTY_STRING, "");
 $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
 if ($filter != "") {
     $query = "SELECT idCourse, code, name, course_type, course_edition FROM %lms_course " . " WHERE code LIKE '%" . $filter . "%' OR name LIKE '%" . $filter . "%' ORDER BY code, name " . ($results > 0 ? " LIMIT 0, " . (int) $results : "");
     $res = sql_query($query);
     if ($res) {
         while (list($id_course, $code, $name, $course_type, $course_edition) = sql_fetch_row($res)) {
             //construct record for course instance
             $record = array('cname' => ($code != "" ? '[' . $code . '] ' : '') . $name, 'id_course' => $id_course, 'code' => $code, 'name' => $name, 'code_highlight' => Layout::highlight($code, $filter), 'name_highlight' => Layout::highlight($name, $filter));
             //detect if the course is of type classroom or has editions
             //TO DO: optimization, do not put queries in iterations
             if ($course_type == 'elearning' && $course_edition > 0) {
                 $record['has_editions'] = true;
                 $_arr = array();
                 $_editions = $ed_man->getEdition($id_course);
                 foreach ($_editions as $_edition) {
                     $_arr[] = array('id' => $_edition['id_edition'], 'code' => $_edition['code'], 'name' => $_edition['name'], 'date_begin' => $_edition['date_begin'], 'date_end' => $_edition['date_end'], 'display_name' => '[' . $_edition['code'] . '] ' . $_edition['name'] . ' (' . Format::date($_edition['date_begin'], 'date') . ' - ' . Format::date($_edition['date_end'], 'date') . ')');
                 }
                 $record['editions'] = $_arr;
             }
             if ($course_type == 'classroom') {
                 $record['has_classrooms'] = true;
                 $_arr = array();
                 $_dates = $dt_man->getCourseDate($id_course);

 public function functionalroles_autocompleteTask()
 {
     $query = Get::req('query', DOTY_STRING, '');
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $output = array('fncroles' => array());
     if ($query != "") {
         $fncroles = $this->model->searchFunctionalRolesByName($query, $results, false, true);
         foreach ($fncroles as $fncrole) {
             $output['fncroles'][] = array('id_fncrole' => $fncrole->id_fncrole, 'name' => $fncrole->name, 'name_highlight' => Layout::highlight($fncrole->name, $query));
         }
     }
     echo $this->json->encode($output);
 }

 public function gettabledataTask()
 {
     //read from input and prepare filter and pagination variables
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $filter_text = Get::req('filter_text', DOTY_STRING, '');
     $searchFilter = array('text' => $filter_text);
     //get total from database and validate the results count
     $total = $this->model->getQuestCategoriesTotal($searchFilter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $rowsPerPage;
         }
     }
     //set pagination argument
     $pagination = array('startIndex' => $startIndex, 'results' => $rowsPerPage, 'sort' => $sort, 'dir' => $dir);
     //read records from database
     $list = $this->model->getQuestCategoriesList($pagination, $searchFilter);
     //prepare the data for sending
     $output_results = array();
     if (is_array($list) && count($list) > 0) {
         //check if categories are used in any test or poll
         $id_list = array();
         foreach ($list as $record) {
             $id_list[] = $record->idCategory;
         }
         $used_test_arr = $this->model->getUsedInTests($id_list);
         $used_poll_arr = $this->model->getUsedInPolls($id_list);
         foreach ($list as $record) {
             //format description field
             $description = strip_tags($record->description);
             if (strlen($description) > 100) {
                 $description = substr($description, 0, 97) . '...';
             }
             $used_test = isset($used_test_arr[$record->idCategory]) ? $used_test_arr[$record->idCategory] : 0;
             $used_poll = isset($used_poll_arr[$record->idCategory]) ? $used_poll_arr[$record->idCategory] : 0;
             $can_mod = $this->permissions['mod'];
             $can_del = $used_test <= 0 && $used_poll <= 0 && $this->permissions['del'];
             //prepare output record
             $output_results[] = array('id' => $record->idCategory, 'name' => Layout::highlight($record->name, $filter_text), 'description' => Layout::highlight($description, $filter_text), 'used_test' => (int) $used_test, 'used_poll' => (int) $used_poll, 'mod' => $can_mod ? 'ajax.adm_server.php?r=alms/questcategory/edit&id=' . (int) $record->idCategory : false, 'del' => $can_del ? 'ajax.adm_server.php?r=alms/questcategory/delete&id=' . (int) $record->idCategory : false);
         }
     }
     $output = array('totalRecords' => $total, 'startIndex' => $startIndex, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $rowsPerPage, 'results' => count($list), 'records' => $output_results);
     echo $this->json->encode($output);
 }

 public function getAdmin()
 {
     //read input data
     $start_index = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_MIXED, Get::sett('visuItem', 25));
     $sort = Get::req('sort', DOTY_MIXED, 'userid');
     $dir = Get::req('dir', DOTY_MIXED, 'asc');
     $filter_text = Get::req('filter_text', DOTY_STRING, $this->_getSessionValue('filter', ""));
     $this->_setSessionValue('filter', $filter_text);
     //retrieve records from model
     $total_group = $this->model->totalAdmin($filter_text);
     $array_group = $this->model->loadAdmin($start_index, $results, $sort, $dir, $filter_text);
     //extract admin info for data formatting
     $idst_list = $this->model->acl_man->getGroupMembers($this->model->idst_admin_group);
     $users_info = $this->model->preference->getMultipleAdminTree($idst_list);
     $courses_info = $this->model->preference->getMultipleAdminCourse($idst_list);
     $classlocations_info = $this->model->preference->getMultipleAdminClasslocation($idst_list);
     //format data retrieved from model
     $output_list = array();
     foreach ($array_group as $value) {
         $id_user = $value['id_user'];
         $has_users = isset($users_info[$id_user]) && count($users_info[$id_user]) > 0;
         $has_courses = isset($courses_info[$id_user]) && (count($courses_info[$id_user]['course']) > 0 || count($courses_info[$id_user]['coursepath']) > 0 || count($courses_info[$id_user]['catalogue']) > 0 || count($courses_info[$id_user]['category']) > 0);
         $has_classlocations = isset($classlocations_info[$id_user]['classlocation']) && count($classlocations_info[$id_user]['classlocation']) > 0;
         $userid = $this->acl_man->relativeId($value['userid']);
         $output_list[] = array('id_user' => $id_user, 'userid' => Layout::highlight($userid, $filter_text), 'firstname' => Layout::highlight($value['firstname'], $filter_text), 'lastname' => Layout::highlight($value['lastname'], $filter_text), 'idst_profile' => $value['idst_profile'], 'user_profile' => $value['user_profile'] ? str_replace('/framework/adminrules/', '', $value['user_profile']) : false, 'has_users' => $has_users ? 1 : 0, 'has_courses' => $has_courses ? 1 : 0, 'has_classlocations' => $has_classlocations ? 1 : 0);
     }
     //produce output for datatable
     $output = array('totalRecords' => $total_group, 'startIndex' => $start_index, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $results, 'results' => count($output_list), 'records' => $output_list);
     echo $this->json->encode($output);
 }

//.........这里部分代码省略.........
        $_SESSION['report_admin_filter']['author'] = 0;
        $_SESSION['report_admin_filter']['name'] = '';
        $_SESSION['report_admin_filter']['type'] = 0;
    }
    $dropdown_onclick = 'onchange="javascript:setReportFilter();"';
    $output .= Form::openForm('report_searchbox_form', 'index.php?modname=report&op=reportlist&of_platform=lms', false, 'POST');
    $output .= Form::getHidden('op', 'op', 'reportlist');
    $output .= Form::getHidden('modname', 'modname', 'report');
    $output .= '<div class="quick_search_form">
			<div>
				<div class="simple_search_box" id="report_searchbox_simple_filter_options" style="display: block;">' . Form::getInputDropdown('dropdown', 'report_searchbox_filter_author', 'filter_author', $authors, $_SESSION['report_admin_filter']['author'], $dropdown_onclick) . "&nbsp;&nbsp;&nbsp;" . Form::getInputTextfield("search_t", "report_searchbox_filter_name", "filter_name", $_SESSION['report_admin_filter']['name'], '', 255, '') . Form::getButton("report_searchbox_filter_set", "search", Lang::t('_SEARCH', 'standard'), "search_b") . Form::getButton("report_searchbox_filter_reset", "reset", Lang::t('_RESET', 'standard'), "reset_b") . '</div>
			</div>
		</div>';
    $output .= Form::closeForm();
    //end filter
    //compose search query
    $qconds = array();
    $query = "SELECT t1.*, t2.userid FROM %lms_report_filter as t1 LEFT JOIN %adm_user as t2 ON t1.author=t2.idst ";
    switch ($level) {
        case ADMIN_GROUP_GODADMIN:
            if ($_SESSION['report_admin_filter']['author'] > 0) {
                $qconds[] = " t1.author = " . $_SESSION['report_admin_filter']['author'] . " ";
            }
            break;
        case ADMIN_GROUP_ADMIN:
        case ADMIN_GROUP_PUBLICADMIN:
        case ADMIN_GROUP_USER:
        default:
            if ($_SESSION['report_admin_filter']['author'] > 0) {
                $qconds[] = " ( t1.author = " . $_SESSION['report_admin_filter']['author'] . " AND t1.is_public = 1 ) ";
            } else {
                $qconds[] = " ( t1.author = " . Docebo::user()->getIdst() . " OR t1.is_public = 1 ) ";
            }
            break;
    }
    if (trim($_SESSION['report_admin_filter']['name']) != "") {
        $qconds[] = " t1.filter_name LIKE '%" . $_SESSION['report_admin_filter']['name'] . "%' ";
    }
    if (trim($_SESSION['report_admin_filter']['type']) > 0) {
        //$qconds[] = " t1.filter_name LIKE '".$_SESSION['report_admin_filter']['name']."' ";
    }
    if (!empty($qconds)) {
        $query .= " WHERE " . implode(" AND ", $qconds);
    }
    //$_SESSION['report_admin_filter']['type']
    //end query
    $tb = new Table(Get::sett('visu_course'));
    $tb->initNavBar('ini', 'button');
    $col_type = array('', '', 'align_center', 'image', 'image', 'img-cell', 'img-cell', 'image');
    //,'image','image');
    $col_content = array($lang->def('_NAME'), $lang->def('_TAB_REP_CREATOR'), $lang->def('_CREATION_DATE'), $lang->def('_TAB_REP_PUBLIC'), '<img src="' . getPathImage() . 'standard/view.png" alt="' . $lang->def('_VIEW') . '" title="' . $lang->def('_VIEW') . '" />', '<span class="ico-sprite subs_csv"><span>' . Lang::t('_EXPORT_CSV', 'report') . '</span></span>', '<span class="ico-sprite subs_xls"><span>' . Lang::t('_EXPORT_XLS', 'report') . '</span></span>', '<img src="' . getPathImage() . 'standard/wait_alarm.png" alt="' . $lang->def('_SCHEDULE') . '" title="' . $lang->def('_SCHEDULE') . '" />');
    if ($is_admin || $can_mod) {
        $col_type[] = 'image';
        $col_type[] = 'image';
        $col_content[] = '<img src="' . getPathImage() . 'standard/edit.png" alt="' . $lang->def('_MOD') . '" title="' . $lang->def('_MOD') . '" />';
        $col_content[] = '<img src="' . getPathImage() . 'standard/delete.png" alt="' . $lang->def('_DEL') . '" title="' . $lang->def('_DEL') . '" />';
    }
    $tb->setColsStyle($col_type);
    $tb->addHead($col_content);
    if ($res = sql_query($query)) {
        while ($row = sql_fetch_assoc($res)) {
            $id = $row['id_filter'];
            $opn_link = '<a href="index.php?modname=report&amp;op=show_results&amp;idrep=' . $id . '" ' . ' title="' . $lang->def('_VIEW') . '">' . '<img src="' . getPathImage() . 'standard/view.png" alt="' . $lang->def('_VIEW') . '" />' . '</a>';
            $sch_link = '<a href="index.php?modname=report&amp;op=schedulelist&amp;idrep=' . $id . '" ' . ' title="' . $lang->def('_SCHEDULE') . '">' . '<img src="' . getPathImage() . 'standard/wait_alarm.png" alt="' . $lang->def('_SCHEDULE') . '" />' . '</a>';
            $mod_link = '<a href="' . $url . '&amp;action=modify&amp;idrep=' . $id . '" ' . ' title="' . $lang->def('_MOD') . '">' . '<img src="' . getPathImage() . 'standard/edit.png" alt="' . $lang->def('_MOD') . '" />' . '</a>';
            $rem_link = '<a href="' . $url . '&amp;action=delete&amp;idrep=' . $id . '" ' . ' title="' . $lang->def('_DEL') . ' : ' . ($row['author'] == 0 ? $lang->def($row['filter_name']) : $row['filter_name']) . '">' . '<img src="' . getPathImage() . 'standard/delete.png" alt="' . $lang->def('_DEL') . '" />';
            //.
            '</a>';
            $can_public = $can_mod ? true : ($is_admin && $row['author'] == Docebo::user()->getIdst() ? true : false);
            $public = '<image ' . ($can_public ? 'class="handover"' : '') . ' src="' . getPathImage('lms') . 'standard/' . ($row['is_public'] == 1 ? '' : 'un') . 'publish.png' . '" ' . ($is_admin || $can_mod ? 'onclick="public_report(this, ' . $row['id_filter'] . ');" ' : '') . ' />' . '<input type="hidden" id="enable_value_' . $row['id_filter'] . '" ' . 'value="' . ($row['is_public'] == 1 ? '0' : '1') . '" />';
            $export_url = 'index.php?modname=report&op=show_results&idrep=' . (int) $id;
            $export_link_csv = '<a class="ico-sprite subs_csv" href="' . $export_url . '&dl=csv" title="' . Lang::t('_EXPORT_CSV', 'report') . '"><span></span>' . Lang::t('_EXPORT_CSV', 'report') . '</a>';
            $export_link_xls = '<a class="ico-sprite subs_xls" href="' . $export_url . '&dl=xls" title="' . Lang::t('_EXPORT_XLS', 'report') . '"><span></span>' . Lang::t('_EXPORT_XLS', 'report') . '</a>';
            $_name = $row['author'] == 0 ? $lang->def($row['filter_name']) : $row['filter_name'];
            if (trim($_SESSION['report_admin_filter']['name']) != "") {
                $_name = Layout::highlight($_name, $_SESSION['report_admin_filter']['name']);
            }
            $tb_content = array(_REP_KEY_NAME => $_name, _REP_KEY_CREATOR => $row['author'] == 0 ? '<div class="align_center">-</div>' : $acl_man->relativeId($row['userid']), _REP_KEY_CREATION => Format::date($row['creation_date']), _REP_KEY_PUBLIC => $public, _REP_KEY_OPEN => $opn_link, $export_link_csv, $export_link_xls, _REP_KEY_SCHED => $sch_link);
            if ($is_admin || $can_mod) {
                if ($row['author'] == Docebo::user()->getIdst() || $can_mod) {
                    $tb_content[_REP_KEY_MOD] = $mod_link;
                    $tb_content[_REP_KEY_REM] = $rem_link;
                } else {
                    $tb_content[_REP_KEY_MOD] = '&nbsp;';
                    $tb_content[_REP_KEY_REM] = '&nbsp;';
                }
            }
            $tb->addBody($tb_content);
        }
    }
    if ($is_admin || $can_mod) {
        //if ($can_mod) {
        $tb->addActionAdd('
			<a href="index.php?modname=report&amp;op=report_category">' . '<img src="' . getPathImage() . 'standard/add.png" ' . 'title="' . $lang->def('_NEW') . '" /> ' . $lang->def('_NEW') . '</a>');
    }
    $output .= $tb->getTable();
    require_once _base_ . '/lib/lib.dialog.php';
    setupHrefDialogBox('a[href*=delete]');
    return $output;
}

 public function getusertabledataTask()
 {
     //read from input and prepare filter and pagination variables
     $id_group = Get::req('id_group', DOTY_INT, 0);
     //TO DO: if $id_group <= 0 ...
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $filter_text = Get::req('filter_text', DOTY_STRING, '');
     $searchFilter = array('text' => $filter_text);
     //get total from database and validate the results count
     $total = $this->model->getGroupUsersTotal($id_group, $searchFilter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     //set pagination argument
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     //read records from database
     $list = $this->model->getGroupUsersList($id_group, $pagination, $searchFilter);
     //prepare the data for sending
     $acl_man = Docebo::user()->getAclManager();
     $output_results = array();
     if (is_array($list) && count($list) > 0) {
         foreach ($list as $idst => $record) {
             //prepare output record
             $output_results[] = array('id' => $record->idst, 'userid' => Layout::highlight($acl_man->relativeId($record->userid), $filter_text), 'lastname' => Layout::highlight($record->lastname, $filter_text), 'firstname' => Layout::highlight($record->firstname, $filter_text), 'del' => 'ajax.adm_server.php?r=' . $this->link . '/del_user&id_user=' . (int) $record->idst . '&id_group=' . (int) $id_group, 'is_group' => $record->is_group);
         }
     }
     $output = array('totalRecords' => $total, 'startIndex' => $startIndex, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $rowsPerPage, 'results' => count($list), 'records' => $output_results);
     echo $this->json->encode($output);
 }

 public function getunsubscribetabledataTask()
 {
     $op = Get::req('op', DOTY_STRING, "");
     if ($op == 'selectall') {
         $this->_getUnsubscribeSelectAll();
         return;
     }
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_MIXED, Get::sett('visuItem', 25));
     $sort = Get::req('sort', DOTY_MIXED, 'userid');
     $dir = Get::req('dir', DOTY_MIXED, 'asc');
     $filter_text = Get::req('filter_text', DOTY_STRING, "");
     $filter_course = Get::req('filter_course', DOTY_INT, 0);
     $filter = array();
     if ($filter_text != "") {
         $filter['text'] = $filter_text;
     }
     $courses_filter = FALSE;
     $ulevel = Docebo::user()->getUserLevelId();
     if ($ulevel != ADMIN_GROUP_GODADMIN) {
         require_once _base_ . '/lib/lib.preference.php';
         $preference = new AdminPreference();
         $view = $preference->getAdminCourse(Docebo::user()->idst);
         $all_courses = false;
         if (isset($view['course'][0])) {
             $all_courses = true;
         } elseif (isset($view['course'][-1])) {
             require_once _lms_ . '/lib/lib.catalogue.php';
             $cat_man = new Catalogue_Manager();
             $user_catalogue = $cat_man->getUserAllCatalogueId(Docebo::user()->getIdSt());
             if (count($user_catalogue) > 0) {
                 $courses = array(0);
                 foreach ($user_catalogue as $id_cat) {
                     $catalogue_course =& $cat_man->getCatalogueCourse($id_cat, true);
                     $courses = array_merge($courses, $catalogue_course);
                 }
                 foreach ($courses as $id_course) {
                     if ($id_course != 0) {
                         $view['course'][$id_course] = $id_course;
                     }
                 }
             } elseif (Get::sett('on_catalogue_empty', 'off') == 'on') {
                 $all_courses = true;
             }
         } else {
             $array_courses = array();
             $array_courses = array_merge($array_courses, $view['course']);
             if (!empty($view['coursepath'])) {
                 require_once _lms_ . '/lib/lib.coursepath.php';
                 $path_man = new Catalogue_Manager();
                 $coursepath_course =& $path_man->getAllCourses($view['coursepath']);
                 $array_courses = array_merge($array_courses, $coursepath_course);
             }
             if (!empty($view['catalogue'])) {
                 require_once _lms_ . '/lib/lib.catalogue.php';
                 $cat_man = new Catalogue_Manager();
                 foreach ($view['catalogue'] as $id_cat) {
                     $catalogue_course =& $cat_man->getCatalogueCourse($id_cat, true);
                     $array_courses = array_merge($array_courses, $catalogue_course);
                 }
             }
             $view['course'] = array_merge($view['course'], $array_courses);
         }
         if (!$all_courses) {
             $courses_filter = $view['course'];
         }
         $filter['user_q'] = $preference->getAdminUsersQuery(Docebo::user()->getIdst(), 'user_id');
     }
     if ($filter_course > 0) {
         if ($courses_filter === FALSE) {
             $courses_filter = (int) $filter_course;
         } else {
             if (!in_array($filter_course, $courses_filter)) {
                 $courses_filter = array();
             } else {
                 $courses_filter = (int) $filter_course;
             }
         }
     }
     if (is_array($courses_filter)) {
         $filter['course'] = $courses_filter;
     }
     $total = $this->model->getUnsubscribeRequestsTotal($filter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     $list = $this->model->getUnsubscribeRequestsList($pagination, $filter);
     //format models' data
     $records = array();
     if (is_array($list)) {
         foreach ($list as $record) {
             $id_unsub = (int) $record->user_id . '_' . $record->idCourse . '_' . $record->res_id . '_' . $record->r_type;
             $record->id = $id_unsub;
             $record->userid = Layout::highlight($this->acl_man->relativeId($record->userid), $filter_text);
             $record->firstname = Layout::highlight($record->firstname, $filter_text);
//.........这里部分代码省略.........

 function gettabledataTask()
 {
     //read from input and prepare filter and pagination variables
     $id_category = Get::req('id_category', DOTY_INT, 0);
     $descendants = Get::req('descendants', DOTY_INT, 0) > 0 ? true : false;
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $filter_text = Get::req('filter_text', DOTY_STRING, '');
     $searchFilter = array('text' => $filter_text);
     //get total from database and validate the results count
     $total = $this->competences_model->getCompetencesTotal($id_category, $descendants, $searchFilter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     //set pagination argument
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     //read records from database
     $list = $this->competences_model->getCompetencesList($id_category, $descendants, $pagination, $searchFilter);
     //prepare the data for sending
     $output_results = array();
     if (is_array($list) && count($list) > 0) {
         foreach ($list as $idst => $record) {
             //format description field
             $description = strip_tags($record->description);
             if (strlen($description) > 200) {
                 $description = substr($description, 0, 197) . '...';
             }
             //prepare output record
             $output_results[] = array('id' => $record->id_competence, 'name' => Layout::highlight($record->name, $filter_text), 'description' => Layout::highlight($description, $filter_text), 'typology' => $record->typology, 'type' => $record->type);
         }
     }
     $output = array('totalRecords' => $total, 'startIndex' => $startIndex, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $rowsPerPage, 'results' => count($list), 'records' => $output_results);
     echo $this->json->encode($output);
 }

 public function getwaitinguserstabledataTask()
 {
     //check permissions
     if (!$this->permissions['approve_waiting_user']) {
         $output = array('success' => false, 'message' => $this->_getErrorMessage('no permission'));
         echo $this->json->encode($output);
         return;
     }
     $op = Get::req('op', DOTY_STRING, "");
     if ($op == 'selectall') {
         $filter = Get::req('filter', DOTY_STRING, "");
         $output = $this->model->getWaitingUsersIds($filter);
         echo $this->json->encode($output);
         return;
     }
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem', 25));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $filter = Get::req('filter', DOTY_STRING, "");
     $total = $this->model->getWaitingUsersTotal($filter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     $list = $this->model->getWaitingUsersList($pagination, $filter);
     //format models' data
     $records = array();
     $acl_man = Docebo::user()->getAclManager();
     if (is_array($list)) {
         foreach ($list as $record) {
             $_userid = $acl_man->relativeId($record->userid);
             $_inserted_by = $record->inserted_by != "" ? $acl_man->relativeId($record->inserted_by) : "";
             $records[] = array('id' => (int) $record->idst, 'userid' => Layout::highlight($_userid, $filter), 'firstname' => Layout::highlight($record->firstname, $filter), 'lastname' => Layout::highlight($record->lastname, $filter), 'email' => Layout::highlight($record->email, $filter), 'insert_date' => Format::date($record->insert_date, 'datetime'), 'inserted_by' => $_inserted_by, 'del' => 'ajax.adm_server.php?r=' . $this->link . '/delete_waiting&id_user=' . (int) $record->idst);
         }
     }
     $output = array('startIndex' => $startIndex, 'recordsReturned' => count($records), 'sort' => $sort, 'dir' => $dir, 'totalRecords' => $total, 'pageSize' => $rowsPerPage, 'records' => $records);
     echo $this->json->encode($output);
 }

        ?>
            <p class="course_support_info">
                <?php 
        echo Lang::t('_EXPIRED', 'course');
        ?>
            </p>
        <?php 
    }
    ?>
    				
		<p class="course_support_info">
			<?php 
    if ($course['code']) {
        ?>
<i style="font-size:.88em">[<?php 
        echo $keyword != "" ? Layout::highlight($course['code'], $keyword) : $course['code'];
        ?>
]</i><?php 
    }
    ?>
		</p>
		<?php 
    $smodel = new SubscriptionAlms();
    if ($smodel->isUserWaitingForSelfUnsubscribe(Docebo::user()->idst, $course['idCourse'])) {
        echo '<p style="padding:.4em">' . Lang::t('_UNSUBSCRIBE_REQUEST_WAITING_FOR_MODERATION', 'course') . '</p>';
    } else {
        //auto unsubscribe management: create a link for the user in the course block
        $_can_unsubscribe = $course['auto_unsubscribe'] == 1 || $course['auto_unsubscribe'] == 2;
        $_date_limit = $course['unsubscribe_date_limit'] != "" && $course['unsubscribe_date_limit'] != "0000-00-00 00:00:00" ? $course['unsubscribe_date_limit'] : FALSE;
        if ($_can_unsubscribe) {
            ?>

 public function competences_autocompleteTask()
 {
     $query = Get::req('query', DOTY_STRING, '');
     $results = Get::Req('results', DOTY_INT, Get::sett('visuItem', 25));
     $output = array('competences' => array());
     if ($query != "") {
         $competences = $this->model->searchCompetencesByName($query, $results, true);
         foreach ($competences as $competence) {
             $output['competences'][] = array('id_competence' => $competence->id_competence, 'name' => $competence->name, 'name_highlight' => Layout::highlight($competence->name, $query), 'type' => $competence->type, 'typology' => $competence->typology);
         }
     }
     echo $this->json->encode($output);
 }

 public function gettabledataTask()
 {
     $startIndex = Get::req('startIndex', DOTY_INT, 0);
     $results = Get::req('results', DOTY_INT, Get::sett('visuItem'));
     $rowsPerPage = Get::req('rowsPerPage', DOTY_INT, $results);
     $sort = Get::req('sort', DOTY_STRING, "");
     $dir = Get::req('dir', DOTY_STRING, "asc");
     $id_course = Get::req('id_course', DOTY_INT, $_SESSION['idCourse']);
     $filter_text = Get::req('filter_text', DOTY_STRING, "");
     $filter_selection = Get::req('filter_selection', DOTY_INT, 0);
     $filter_orgchart = Get::req('filter_orgchart', DOTY_INT, 0);
     $filter_groups = Get::req('filter_groups', DOTY_INT, 0);
     $filter_descendants = Get::req('filter_descendants', DOTY_INT, 0) > 0;
     $filter = array('text' => $filter_text, 'selection' => $filter_selection, 'orgchart' => $filter_orgchart, 'groups' => $filter_groups, 'descendants' => $filter_descendants);
     //get total from database and validate the results count
     $total = $this->model->getCourseStatsTotal($id_course, $filter);
     if ($startIndex >= $total) {
         if ($total < $results) {
             $startIndex = 0;
         } else {
             $startIndex = $total - $results;
         }
     }
     $pagination = array('startIndex' => $startIndex, 'results' => $results, 'sort' => $sort, 'dir' => $dir);
     $list = $this->model->getCourseStatsList($pagination, $id_course, $filter);
     require_once _lms_ . '/lib/lib.subscribe.php';
     $cman = new CourseSubscribe_Manager();
     $arr_status = $cman->getUserStatus();
     $arr_level = $cman->getUserLevel();
     //format models' data
     $records = array();
     $acl_man = Docebo::user()->getAclManager();
     if (is_array($list)) {
         $lo_list = $this->model->getCourseLOs($id_course);
         foreach ($list as $record) {
             $_userid = $acl_man->relativeId($record->userid);
             $row = array('id' => (int) $record->idst, 'userid' => Layout::highlight($_userid, $filter_text), 'firstname' => Layout::highlight($record->firstname, $filter_text), 'lastname' => Layout::highlight($record->lastname, $filter_text), 'status' => isset($arr_status[$record->status]) ? $arr_status[$record->status] : "", 'status_id' => $record->status, 'level' => isset($arr_level[$record->level]) ? $arr_level[$record->level] : "");
             //get LO data
             $completed = 0;
             foreach ($lo_list as $idOrg => $lo) {
                 if (isset($record->lo_status[$idOrg])) {
                     $row['lo_' . $idOrg] = $record->lo_status[$idOrg];
                     if ($record->lo_status[$idOrg] == 'completed' || $record->lo_status[$idOrg] == 'passed') {
                         $completed++;
                     }
                 } else {
                     $row['lo_' . $idOrg] = "";
                 }
             }
             $row['completed'] = $completed;
             $records[] = $row;
         }
     }
     $output = array('startIndex' => $startIndex, 'recordsReturned' => count($records), 'sort' => $sort, 'dir' => $dir, 'totalRecords' => $total, 'pageSize' => $rowsPerPage, 'records' => $records);
     echo $this->json->encode($output);
 }

        ?>
			<a href="index.php?modname=course&amp;op=aula&amp;idCourse=<?php 
        echo $course['idCourse'];
        ?>
">
				<?php 
        echo $course['lang_code'] != 'none' ? Get::img('language/' . strtolower($course['lang_code']) . '.png', $course['lang_code']) : '';
        ?>
				<?php 
        echo $keyword != "" ? Layout::highlight($course['name'], $keyword) : $course['name'];
        ?>
			</a>
			<?php 
    } else {
        echo Get::img('standard/locked.png', Lang::t('_' . strtoupper($course['can_enter']['reason']), 'standard'));
        echo ' ' . ($keyword != "" ? Layout::highlight($course['name'], $keyword) : $course['name']);
    }
    ?>
		</h2>
		<p class="course_support_info">
			<?php 
    echo Lang::t($this->ustatus[$course['user_status']], 'course') . '' . Lang::t('_USER_LVL', 'course', array('[level]' => '<b>' . $this->levels[$course['level']] . '</b>'));
    ?>
		</p>
		<!-- p class="course_support_info" -->
			<?php 
    /* echo Lang::t('_COURSE_INTRO', 'course', array(
    				'[course_type]'		=> $course['course_type'],
    				'[create_date]'		=> $course['create_date'],
    				'[enrolled]'		=> $course['enrolled'],
    				'[course_status]'	=> Lang::t($this->cstatus[$course['course_status']], 'course')