PHP HtmlTable::disableDatatablesColumnsSort 예제들

예제 #1

파일: inventory.php 프로젝트: martinbrylski/admidio

        ', true);
// get module menu
$itemsAdministrationMenu = $page->getMenu();
$itemsAdministrationMenu->addItem('menu_item_create_user', $g_root_path . '/adm_program/modules/inventory/item_new.php', $gL10n->get('INV_CREATE_ITEM'), 'add.png');
// show link to room management
$itemsAdministrationMenu->addItem('menu_item_manage_rooms', $g_root_path . '/adm_program/modules/rooms/rooms.php', $gL10n->get('DAT_SWITCH_TO_ROOM_ADMINISTRATION'), 'home.png');
if ($gCurrentUser->isWebmaster()) {
    // show link to maintain profile fields
    $itemsAdministrationMenu->addItem('menu_item_maintain_inventory_fields', $g_root_path . '/adm_program/modules/inventory/fields.php', $gL10n->get('PRO_MAINTAIN_ITEM_FIELDS'), 'application_form_edit.png');
}
// Create table object
$itemsTable = new HtmlTable('tbl_invent', $page, true, true, 'table table-condensed');
// create array with all column heading values
$columnHeading = array($gL10n->get('SYS_ABR_NO'), $gL10n->get('SYS_NAME'), $gL10n->get('SYS_ROOM'), $gL10n->get('MEM_UPDATED_ON'), ' ');
$itemsTable->setColumnAlignByArray(array('left', 'left', 'left', 'left', 'right'));
$itemsTable->disableDatatablesColumnsSort(5);
$itemsTable->addRowHeadingByArray($columnHeading);
$itemsTable->setDatatablesRowsPerPage($gPreferences['members_users_per_page']);
$itemsTable->setMessageIfNoRowsFound('SYS_NO_ENTRIES');
$irow = 1;
// count for line in table
while ($row = $mglStatement->fetch()) {
    $timestampChange = new DateTimeExtended($row['timestamp'], 'Y-m-d H:i:s');
    $room = new TableRooms($gDb, $row['room_id']);
    $roomLink = $g_root_path . '/adm_program/system/msg_window.php?message_id=room_detail&message_title=DAT_ROOM_INFORMATIONS&message_var1=' . $row['room_id'] . '&inline=true';
    // create array with all column values
    $columnValues = array($irow, '<a href="' . $g_root_path . '/adm_program/modules/inventory/item.php?item_id=' . $row['inv_id'] . '">' . $row['item_name'] . '</a>', '<a class="admidio-icon-link-popup" href="' . $roomLink . '">' . $room->getValue('room_name') . '</a>');
    $columnValues[] = $timestampChange->format($gPreferences['system_date'] . ' ' . $gPreferences['system_time']);
    $itemAdministration = '';
    // Link to modify Item
    $itemAdministration .= '<a class="admidio-icon-link" href="' . $g_root_path . '/adm_program/modules/inventory/item_new.php?item_id=' . $row['inv_id'] . '"><img

예제 #2

파일: dates.php 프로젝트: martinbrylski/admidio

if ($datesTotalCount == 0) {
    // No events found
    if ($getId > 0) {
        $page->addHtml('<p>' . $gL10n->get('SYS_NO_ENTRY') . '</p>');
    } else {
        $page->addHtml('<p>' . $gL10n->get('SYS_NO_ENTRIES') . '</p>');
    }
} else {
    // Output table header for compact view
    if ($getView === 'compact' || $getView === 'room' || $getView === 'participants' || $getView === 'description') {
        $compactTable = new HtmlTable('events_compact_table', $page, $hoverRows, $datatable, $classTable);
        switch ($getView) {
            case 'compact':
                $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('DAT_DATE'), $gL10n->get('SYS_PARTICIPANTS'), $gL10n->get('DAT_LOCATION'));
                $columnAlign = array('center', 'left', 'left', 'left', 'left');
                $compactTable->disableDatatablesColumnsSort(6);
                break;
            case 'room':
                $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('DAT_DATE'), $gL10n->get('SYS_ROOM'), $gL10n->get('SYS_LEADERS'), $gL10n->get('SYS_PARTICIPANTS'));
                $columnAlign = array('center', 'left', 'left', 'left', 'left', 'left');
                $compactTable->disableDatatablesColumnsSort(7);
                break;
            case 'participants':
                $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('DAT_DATE'), $gL10n->get('SYS_PARTICIPANTS'));
                $columnAlign = array('center', 'left', 'left', 'left');
                $compactTable->disableDatatablesColumnsSort(5);
                $compactTable->setColumnWidth(4, '35%');
                break;
            case 'description':
                $columnHeading = array('&nbsp;', $gL10n->get('SYS_PERIOD'), $gL10n->get('DAT_DATE'), $gL10n->get('SYS_DESCRIPTION'));
                $columnAlign = array('center', 'left', 'left', 'left');

예제 #3

파일: members_assignment.php 프로젝트: sistlind/admidio

         alt="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" />';
 }
 // show icon with assign role right if leader has this right
 if ($role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN || $role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN_EDIT) {
     $htmlLeaderColumn .= '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/roles.png"
         alt="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" />';
 }
 // create array with all column heading values
 $columnHeading = array('<img class="admidio-icon-info"
         src="' . THEME_PATH . '/icons/profile.png" alt="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '"
         title="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '" />', $gL10n->get('SYS_MEMBER'), $gL10n->get('SYS_LASTNAME'), $gL10n->get('SYS_FIRSTNAME'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/map.png"
         alt="' . $gL10n->get('SYS_ADDRESS') . '" title="' . $gL10n->get('SYS_ADDRESS') . '" />', $gL10n->get('SYS_BIRTHDAY'), $htmlLeaderColumn);
 $table->setColumnAlignByArray(array('left', 'center', 'left', 'left', 'left', 'left', 'left', 'center'));
 $table->setDatatablesOrderColumns(array(3, 4));
 $table->addRowHeadingByArray($columnHeading);
 $table->disableDatatablesColumnsSort(array(2, 7));
 // show rows with all organization users
 while ($user = $userStatement->fetch()) {
     $addressText = ' ';
     $htmlAddress = '&nbsp;';
     $htmlBirthday = '&nbsp;';
     if ($user['member_this_orga'] > 0) {
         $memberOfThisOrganization = '1';
     } else {
         $memberOfThisOrganization = '0';
     }
     // create string with user address
     if (strlen($user['country']) > 0) {
         $addressText .= $gL10n->getCountryByCode($user['country']);
     }
     if (strlen($user['zip_code']) > 0 || strlen($user['city']) > 0) {

예제 #4

파일: messages.php 프로젝트: sxwid/admidio3.1_scoutversion

// @ptabaden: hide chat!
// if ($gPreferences['enable_chat_module'] == 1)
// {
//    $EmailMenu->addItem('admMenuItemNewChat', $g_root_path.'/adm_program/modules/messages/messages_chat.php', $gL10n->get('MSG_CHAT'), '/chat.png');
// }
if ($gCurrentUser->isWebmaster()) {
    // @ptabaden: Changed Icon & renamed to menu_item_preferences
    $EmailMenu->addItem('admMenuItemPreferences', $g_root_path . '/adm_program/modules/preferences/preferences.php?show_option=messages', '<i class="fa fa-cog" alt="' . $gL10n->get('SYS_MODULE_PREFERENCES') . '" title="' . $gL10n->get('SYS_MODULE_PREFERENCES') . '"></i><div class="iconDescription">' . $gL10n->get('SYS_MODULE_PREFERENCES') . '</div>', '', 'right');
}
$table = new HtmlTable('adm_lists_table', $page, true, true);
// @ptabaden deleted two cols #possibleError delete one left more?
$table->setColumnAlignByArray(array('left', 'left', 'right'));
// @ptabaden: deleted category row and changed order
// @ptabaden: deleted two cols
$table->addRowHeadingByArray(array($gL10n->get('MSG_OPPOSITE'), $gL10n->get('MAI_SUBJECT'), ''));
$table->disableDatatablesColumnsSort(5);
$key = 0;
$part1 = '<a class="admidio-icon-link" data-toggle="modal" data-target="#admidio_modal" href="' . $g_root_path . '/adm_program/system/popup_message.php?type=msg&amp;element_id=row_message_';
// @ptabaden: Changed Icon
$part2 = '"><i class="fa fa-times" alt="' . $gL10n->get('MSG_REMOVE') . '" title="' . $gL10n->get('MSG_REMOVE') . '" /></a>';
$href = 'href="' . $g_root_path . '/adm_program/modules/messages/messages_write.php?msg_id=';
// open some additonal functions for messages
$modulemessages = new ModuleMessages();
// find all own Email messages
$statement = $modulemessages->msgGetUserEmails($gCurrentUser->getValue('usr_id'));
if (isset($statement)) {
    while ($row = $statement->fetch()) {
        $receiverName = '';
        if (strpos($row['user'], '|') > 0) {
            $reciversplit = explode('|', $row['user']);
            foreach ($reciversplit as $value) {

예제 #5

파일: downloads.php 프로젝트: bash-t/admidio

        $DownloadsMenu->addItem('admMenuItemCreateFolder', $g_root_path . '/adm_program/modules/downloads/folder_new.php?folder_id=' . $getFolderId, $gL10n->get('DOW_CREATE_FOLDER'), 'folder_create.png');
        $DownloadsMenu->addItem('admMenuItemAddFile', $g_root_path . '/adm_program/modules/downloads/upload.php?folder_id=' . $getFolderId, $gL10n->get('DOW_UPLOAD_FILE'), 'page_white_upload.png');
    }
    $DownloadsMenu->addItem('admMenuItemConfigFolder', $g_root_path . '/adm_program/modules/downloads/folder_config.php?folder_id=' . $getFolderId, $gL10n->get('SYS_AUTHORIZATION'), 'lock.png');
}
if ($gCurrentUser->isWebmaster()) {
    // show link to system preferences of weblinks
    $DownloadsMenu->addItem('admMenuItemPreferencesLinks', $g_root_path . '/adm_program/modules/preferences/preferences.php?show_option=downloads', $gL10n->get('SYS_MODULE_PREFERENCES'), 'options.png', 'right');
}
//Create table object
$downloadOverview = new HtmlTable('tbl_downloads', $page, true, true);
// create array with all column heading values
$columnHeading = array($gL10n->get('SYS_TYPE'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/download.png" alt="' . $gL10n->get('SYS_FOLDER') . ' / ' . $gL10n->get('DOW_FILE_TYPE') . '" title="' . $gL10n->get('SYS_FOLDER') . ' / ' . $gL10n->get('DOW_FILE_TYPE') . '" />', $gL10n->get('SYS_NAME'), $gL10n->get('SYS_DATE_MODIFIED'), $gL10n->get('SYS_SIZE'), $gL10n->get('DOW_COUNTER'));
if ($gCurrentUser->editDownloadRight()) {
    $columnHeading[] = $gL10n->get('SYS_FEATURES');
    $downloadOverview->disableDatatablesColumnsSort(7);
}
$downloadOverview->setColumnAlignByArray(array('left', 'left', 'left', 'left', 'right', 'right', 'right'));
$downloadOverview->addRowHeadingByArray($columnHeading);
$downloadOverview->setMessageIfNoRowsFound('DOW_FOLDER_NO_FILES', 'warning');
// Get folder content
if (isset($folderContent['folders'])) {
    // First get possible sub folders
    for ($i = 0; $i < count($folderContent['folders']); $i++) {
        $nextFolder = $folderContent['folders'][$i];
        $folderDescription = '';
        if ($nextFolder['fol_description'] != '') {
            $folderDescription = '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/info.png" alt="' . $nextFolder['fol_description'] . '" title="' . $nextFolder['fol_description'] . '" />';
        }
        // create array with all column values
        $columnValues = array(1, '<a class="admidio-icon-link" href="' . $g_root_path . '/adm_program/modules/downloads/downloads.php?folder_id=' . $nextFolder['fol_id'] . '">

예제 #6

파일: members_assignment.php 프로젝트: bash-t/admidio

         alt="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" />';
 }
 // show icon with assign role right if leader has this right
 if ($role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN || $role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN_EDIT) {
     $htmlLeaderColumn .= '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/roles.png"
         alt="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" />';
 }
 // create array with all column heading values
 $columnHeading = array('<img class="admidio-icon-info"
         src="' . THEME_PATH . '/icons/profile.png" alt="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '"
         title="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '" />', $gL10n->get('SYS_STATUS'), $gL10n->get('SYS_MEMBER'), $gL10n->get('SYS_LASTNAME'), $gL10n->get('SYS_FIRSTNAME'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/map.png"
         alt="' . $gL10n->get('SYS_ADDRESS') . '" title="' . $gL10n->get('SYS_ADDRESS') . '" />', $gL10n->get('SYS_ADDRESS'), $gL10n->get('SYS_BIRTHDAY'), $htmlLeaderColumn);
 $table->setColumnAlignByArray(array('left', 'left', 'center', 'left', 'left', 'left', 'left', 'left', 'center'));
 $table->setDatatablesOrderColumns(array(4, 5));
 $table->addRowHeadingByArray($columnHeading);
 $table->disableDatatablesColumnsSort(array(3, 9));
 // set alternative order column for member status icons
 $table->setDatatablesAlternativOrderColumns(1, 2);
 $table->setDatatablesColumnsHide(2);
 // set alternative order column for address icons
 $table->setDatatablesAlternativOrderColumns(6, 7);
 $table->setDatatablesColumnsHide(7);
 // show rows with all organization users
 while ($user = $gDb->fetch_array($resultUser)) {
     $addressText = ' ';
     $htmlAddress = '&nbsp;';
     $htmlBirthday = '&nbsp;';
     if ($user['member_this_orga'] > 0) {
         $memberOfThisOrganization = '1';
     } else {
         $memberOfThisOrganization = '0';

예제 #7

파일: members_assignment.php 프로젝트: sxwid/admidio3.1_scoutversion

     $htmlLeaderColumn .= '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/profile_edit.png"
         alt="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_EDIT_MEMBERS') . '" />';
 }
 // show icon with assign role right if leader has this right
 if ($role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN || $role->getValue('rol_leader_rights') == ROLE_LEADER_MEMBERS_ASSIGN_EDIT) {
     $htmlLeaderColumn .= '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/roles.png"
         alt="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" title="' . $gL10n->get('ROL_LEADER_ASSIGN_MEMBERS') . '" />';
 }
 // create array with all column heading values
 // @ptabaden: removed first row, removed firstname, moved both checkboxes to end, added pfadiname, added sys_participant value
 $columnHeading = array('', $gL10n->get('SYS_LASTNAME'), $gL10n->get('SYS_VULGO'), $gL10n->get('SYS_BIRTHDAY'), $gL10n->get('SYS_PARTICIPANT'), $htmlLeaderColumn);
 // @ptabaden: removed first row, and firstname, changed sortvalue and disable sort
 $table->setColumnAlignByArray(array('left', 'left', 'left', 'left', 'center', 'center'));
 $table->setDatatablesOrderColumns(array(2, 3));
 $table->addRowHeadingByArray($columnHeading);
 $table->disableDatatablesColumnsSort(array(5, 6));
 $irow = 1;
 // @ptabaden: Zahler fuer die jeweilige Zeile
 // show rows with all organization users
 while ($user = $userStatement->fetch()) {
     $addressText = ' ';
     $htmlAddress = '&nbsp;';
     $htmlBirthday = '&nbsp;';
     // @ptabaden: Added htmlpfadiname
     $htmlPfadiname = '&nbsp;';
     if ($user['member_this_orga'] > 0) {
         $memberOfThisOrganization = '1';
     } else {
         $memberOfThisOrganization = '0';
     }
     // create string with user address

예제 #8

파일: members.php 프로젝트: sistlind/admidio

// show link to import users
$membersAdministrationMenu->addItem('menu_item_import_users', $g_root_path . '/adm_program/modules/members/import.php', $gL10n->get('MEM_IMPORT_USERS'), 'database_in.png', 'right', 'menu_item_extras');
if ($gCurrentUser->isWebmaster()) {
    // show link to maintain profile fields
    $membersAdministrationMenu->addItem('menu_item_maintain_profile_fields', $g_root_path . '/adm_program/modules/preferences/fields.php', $gL10n->get('PRO_MAINTAIN_PROFILE_FIELDS'), 'application_form_edit.png', 'right', 'menu_item_extras');
    // show link to system preferences of weblinks
    $membersAdministrationMenu->addItem('menu_item_preferences_links', $g_root_path . '/adm_program/modules/preferences/preferences.php?show_option=user_management', $gL10n->get('SYS_MODULE_PREFERENCES'), 'options.png', 'right', 'menu_item_extras');
}
// Create table object
$membersTable = new HtmlTable('tbl_members', $page, true, true, 'table table-condensed');
// create array with all column heading values
$columnHeading = array($gL10n->get('SYS_ABR_NO'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/profile.png"
        alt="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '"
        title="' . $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname')) . '" />', $gL10n->get('SYS_NAME'), $gL10n->get('SYS_USER'), '<img class="admidio-icon-info" alt="' . $gL10n->get('SYS_GENDER') . '" title="" src="' . THEME_PATH . '/icons/gender.png" data-original-title="' . $gL10n->get('SYS_GENDER') . '">', $gL10n->get('SYS_BIRTHDAY'), $gL10n->get('MEM_UPDATED_ON'), '&nbsp;');
$membersTable->setColumnAlignByArray(array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right'));
$membersTable->disableDatatablesColumnsSort(8);
$membersTable->addRowHeadingByArray($columnHeading);
$membersTable->setDatatablesRowsPerPage($gPreferences['members_users_per_page']);
$membersTable->setMessageIfNoRowsFound('SYS_NO_ENTRIES');
$irow = 1;
// Zahler fuer die jeweilige Zeile
while ($row = $mglStatement->fetch()) {
    $timestampChange = new DateTimeExtended($row['timestamp'], 'Y-m-d H:i:s');
    // Icon fuer Orgamitglied und Nichtmitglied auswaehlen
    if ($row['member_this_orga'] > 0) {
        $icon = 'profile.png';
        $iconText = $gL10n->get('SYS_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname'));
    } else {
        $icon = 'no_profile.png';
        $iconText = $gL10n->get('SYS_NOT_MEMBER_OF_ORGANIZATION', $gCurrentOrganization->getValue('org_longname'));
    }