PHP TableUserField Examples

Example #1

File: fields_new.php Project: sistlind/admidio

require_once '../../system/login_valid.php';
// Initialize and check the parameters
$getUsfId = admFuncVariableIsValid($_GET, 'usf_id', 'numeric');
// nur berechtigte User duerfen die Profilfelder bearbeiten
if (!$gCurrentUser->isWebmaster()) {
    $gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// set headline of the script
if ($getUsfId > 0) {
    $headline = $gL10n->get('ORG_EDIT_PROFILE_FIELD');
} else {
    $headline = $gL10n->get('ORG_CREATE_PROFILE_FIELD');
}
$gNavigation->addUrl(CURRENT_URL, $headline);
// benutzerdefiniertes Feldobjekt anlegen
$userField = new TableUserField($gDb);
if ($getUsfId > 0) {
    $userField->readDataById($getUsfId);
    // hidden must be 0, if the flag should be set
    if ($userField->getValue('usf_hidden') == 1) {
        $userField->setValue('usf_hidden', 0);
    } else {
        $userField->setValue('usf_hidden', 1);
    }
    // Pruefung, ob das Feld zur aktuellen Organisation gehoert
    if ($userField->getValue('cat_org_id') > 0 && $userField->getValue('cat_org_id') != $gCurrentOrganization->getValue('org_id')) {
        $gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
    }
} else {
    // default values for a new field
    $userField->setValue('usf_hidden', 1);

Example #2

File: fields_function.php Project: martinbrylski/admidio

 *            4 - change sequence of profile field
 * sequence : new sequence für profile field
 *
 *****************************************************************************/
require_once '../../system/common.php';
require_once '../../system/login_valid.php';
// Initialize and check the parameters
$getUsfId = admFuncVariableIsValid($_GET, 'usf_id', 'int');
$getMode = admFuncVariableIsValid($_GET, 'mode', 'int', array('requireValue' => true));
$getSequence = admFuncVariableIsValid($_GET, 'sequence', 'string', array('validValues' => array('UP', 'DOWN')));
// nur berechtigte User duerfen die Profilfelder bearbeiten
if (!$gCurrentUser->isWebmaster()) {
    $gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// create user field object
$userField = new TableUserField($gDb);
if ($getUsfId > 0) {
    $userField->readDataById($getUsfId);
    // check if profile field belongs to actual organization
    if ($userField->getValue('cat_org_id') > 0 && $userField->getValue('cat_org_id') != $gCurrentOrganization->getValue('org_id')) {
        $gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
    }
    // if system profile field then set usf_type to default
    if ($userField->getValue('usf_system') == 1) {
        $_POST['usf_type'] = $userField->getValue('usf_type');
    }
}
if ($getMode === 1) {
    // Feld anlegen oder updaten
    $_SESSION['fields_request'] = $_POST;
    // pruefen, ob Pflichtfelder gefuellt sind

Example #3

File: fields.php Project: sistlind/admidio

$fieldsMenu->addItem('menu_item_maintain_category', $g_root_path . '/adm_program/modules/categories/categories.php?type=USF', $gL10n->get('SYS_MAINTAIN_CATEGORIES'), 'application_double.png');
$sql = 'SELECT * FROM ' . TBL_CATEGORIES . ', ' . TBL_USER_FIELDS . '
         WHERE cat_type   = \'USF\'
           AND usf_cat_id = cat_id
           AND (  cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
               OR cat_org_id IS NULL )
         ORDER BY cat_sequence ASC, usf_sequence ASC ';
$statement = $gDb->query($sql);
// Create table
$table = new HtmlTable('tbl_profile_fields', $page, true);
$table->setMessageIfNoRowsFound('ORG_NO_FIELD_CREATED');
// create array with all column heading values
$columnHeading = array($gL10n->get('SYS_FIELD') . HtmlForm::getHelpTextIcon('ORG_FIELD_DESCRIPTION'), '&nbsp;', $gL10n->get('SYS_DESCRIPTION'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/eye.png" alt="' . $gL10n->get('ORG_FIELD_NOT_HIDDEN') . '" title="' . $gL10n->get('ORG_FIELD_NOT_HIDDEN') . '" />', '<img class="admidio-icon-info" data-html="true" src="' . THEME_PATH . '/icons/textfield_key.png" alt="' . $gL10n->get('ORG_FIELD_DISABLED', $gL10n->get('ROL_RIGHT_EDIT_USER')) . '" title="' . $gL10n->get('ORG_FIELD_DISABLED', $gL10n->get('ROL_RIGHT_EDIT_USER')) . '" />', '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/asterisk_yellow.png" alt="' . $gL10n->get('ORG_FIELD_REQUIRED') . '" title="' . $gL10n->get('ORG_FIELD_REQUIRED') . '" />', $gL10n->get('ORG_DATATYPE'), '&nbsp;');
$table->addRowHeadingByArray($columnHeading);
$categoryId = 0;
$userField = new TableUserField($gDb);
// Intialize variables
$description = '';
$hidden = '';
$disable = '';
$mandatory = '';
$usfSystem = '';
while ($row = $statement->fetch()) {
    $userField->clear();
    $userField->setArray($row);
    if ($categoryId != $userField->getValue('cat_id')) {
        $block_id = 'admCategory' . $userField->getValue('usf_cat_id');
        $table->addTableBody();
        $table->addRow('', array('class' => 'admidio-group-heading'));
        $table->addColumn('<span id="caret_' . $block_id . '" class="caret"></span>' . $userField->getValue('cat_name'), array('id' => 'group_' . $block_id, 'colspan' => '8'), 'td');
        $table->addTableBody('id', $block_id);