public static function getUserProfileFieldInfoBySID($user_profile_field_sid)
{
$field_info = parent::getObjectInfo("user_profile_fields", $user_profile_field_sid);
if (in_array($field_info['type'], array('list', 'multilist'))) {
if (!empty($field_info['parent_sid'])) {
if ($field_info['id'] == 'Country') {
$displayAS = !empty($field_info['display_as']) ? $field_info['display_as'] : 'country_name';
$field_info['list_values'] = SJB_CountriesManager::getAllCountriesCodesAndNames(true, $displayAS);
}
} else {
$field_info['list_values'] = SJB_UserProfileFieldDBManager::getListValuesBySID($user_profile_field_sid);
}
} elseif ($field_info['type'] == 'tree') {
$field_info['tree_values'] = SJB_UserProfileFieldTreeManager::getTreeValuesBySID($user_profile_field_sid);
$field_info['tree_depth'] = SJB_UserProfileFieldTreeManager::getTreeDepthBySID($user_profile_field_sid);
} elseif ($field_info['type'] == 'monetary') {
$field_info['currency_values'] = SJB_CurrencyManager::getActiveCurrencyList();
} elseif ($field_info['type'] == 'location') {
$field_info['fields'] = SJB_UserProfileFieldManager::getUserProfileFieldsInfoByParentSID($user_profile_field_sid);
}
return $field_info;
}
public static function getTreeDisplayValueBySID($item_sid)
{
$item_info = SJB_UserProfileFieldTreeManager::getTreeItemInfoBySID($item_sid);
$values = array();
while (!is_null($item_info)) {
array_unshift($values, $item_info['caption']);
$item_info = SJB_UserProfileFieldTreeManager::getTreeItemInfoBySID($item_info['parent_sid']);
}
return $values;
}
public function execute()
{
$field_sid = isset($_REQUEST['field_sid']) ? $_REQUEST['field_sid'] : null;
$field_info = SJB_UserProfileFieldManager::getFieldInfoBySID($field_sid);
$node_sid = isset($_REQUEST['node_sid']) ? $_REQUEST['node_sid'] : 0;
$user_group_sid = isset($_REQUEST['user_group_sid']) ? $_REQUEST['user_group_sid'] : null;
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
if (empty($field_info)) {
$errors['INVALID_FIELD_SID'] = 1;
} else {
if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add') {
$tree_item_value = $_REQUEST['tree_item_value'];
$order = $_REQUEST['order'];
if ($tree_item_value == '') {
$field_errors['Value'] = 'EMPTY_VALUE';
} else {
if ($order == 'begin') {
SJB_UserProfileFieldManager::addTreeItemToBeginByParentSID($field_sid, $node_sid, $tree_item_value);
} elseif ($order == 'end') {
SJB_UserProfileFieldManager::addTreeItemToEndByParentSID($field_sid, $node_sid, $tree_item_value);
} elseif ($order == 'after') {
$after_tree_item_sid = $_REQUEST['after_tree_item_sid'];
SJB_UserProfileFieldManager::addTreeItemAfterByParentSID($field_sid, $node_sid, $tree_item_value, $after_tree_item_sid);
}
$treeLevelsNumber = SJB_UserProfileFieldTreeManager::getTreeDepthBySID($field_sid);
SJB_UserProfileFieldManager::addLevelField($treeLevelsNumber);
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'save') {
$tree_item_value = $_REQUEST['tree_item_value'];
if (empty($tree_item_value)) {
$field_errors['Value'] = 'EMPTY_VALUE';
} else {
SJB_UserProfileFieldManager::updateTreeItemBySID($node_sid, $tree_item_value);
$order = isset($_REQUEST['order']) ? $_REQUEST['order'] : null;
if ($order == 'begin') {
SJB_UserProfileFieldManager::moveTreeItemToBeginBySID($node_sid);
} elseif ($order == 'end') {
SJB_UserProfileFieldManager::moveTreeItemToEndBySID($node_sid);
} elseif ($order == 'after') {
$after_tree_item_sid = $_REQUEST['after_tree_item_sid'];
SJB_UserProfileFieldManager::moveTreeItemAfterBySID($node_sid, $after_tree_item_sid);
}
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'delete') {
$item_sid = isset($_REQUEST['item_sid']) ? $_REQUEST['item_sid'] : null;
SJB_UserProfileFieldManager::deleteTreeItemBySID($item_sid);
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'move_up') {
$item_sid = isset($_REQUEST['item_sid']) ? $_REQUEST['item_sid'] : null;
SJB_UserProfileFieldManager::moveUpTreeItem($item_sid);
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'move_down') {
$item_sid = isset($_REQUEST['item_sid']) ? $_REQUEST['item_sid'] : null;
SJB_UserProfileFieldManager::moveDownTreeItem($item_sid);
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add_multiple') {
$node_sid = isset($_REQUEST['node_sid']) ? SJB_Request::getInt('node_sid') : 0;
$item_sid = SJB_Request::getVar('field_sid');
$tree_item_value = SJB_Request::getVar('tree_multiItem_value', false);
$after_tree_item_sid = SJB_Request::getVar('after_tree_item_sid', 0);
$order = SJB_Request::getVar('order', false);
if ($tree_item_value == '') {
$field_errors['Value'] = 'EMPTY_VALUE';
}
SJB_UserProfileFieldTreeManager::addMultupleTreeItem($item_sid, $node_sid, $tree_item_value, $order, $after_tree_item_sid);
}
$tree_items = SJB_UserProfileFieldManager::getTreeValuesByParentSID($field_sid, $node_sid);
$parent_sid = SJB_UserProfileFieldManager::getTreeParentSID($node_sid);
$tree_parent_items = SJB_UserProfileFieldManager::getTreeValuesByParentSID($field_sid, $parent_sid);
}
$tp = SJB_System::getTemplateProcessor();
$tp->assign("field_sid", $field_sid);
$tp->assign("node_sid", $node_sid);
$tp->assign("user_group_sid", $user_group_sid);
$tp->assign("user_group_info", $user_group_info);
$tp->assign("field_info", $field_info);
$tp->assign("tree_parent_items", $tree_parent_items);
$tp->assign("tree_items", $tree_items);
$node_info = SJB_UserProfileFieldManager::getTreeItemInfoBySID($node_sid);
$node_path = SJB_UserProfileFieldManager::getTreeNodePath($node_sid);
$node_path[0] = array('caption' => 'Root', 'sid' => 0);
$node_info['node_path'] = $node_path;
$tp->assign("node_info", $node_info);
$current_level = isset($node_info['level']) ? $node_info['level'] : 0;
$tp->assign("current_level", $current_level);
$tp->assign("errors", isset($errors) ? $errors : null);
$tp->assign("field_errors", isset($field_errors) ? $field_errors : null);
$tp->display("edit_tree.tpl");
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$user_group_sid = SJB_Request::getVar('user_group_sid', null);
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
$user_profile_field_sid = SJB_Request::getVar('sid', null);
if (!is_null($user_profile_field_sid)) {
$user_profile_field_info = SJB_UserProfileFieldManager::getFieldInfoBySID($user_profile_field_sid);
$user_profile_field_old_id = $user_profile_field_info['id'];
$user_profile_field_info = array_merge($user_profile_field_info, $_REQUEST);
$user_profile_field = new SJB_UserProfileField($user_profile_field_info);
$user_profile_field->setSID($user_profile_field_sid);
$user_profile_field->setUserGroupSID($user_group_sid);
if (!in_array($user_profile_field->field_type, array('video', 'picture', 'logo', 'file', 'location'))) {
$default_value = array('id' => 'default_value', 'sid' => isset($user_profile_field_info['sid']) ? $user_profile_field_info['sid'] : '', 'caption' => 'Default Value', 'value' => isset($user_profile_field_info['default_value']) ? $user_profile_field_info['default_value'] : '', 'type' => $user_profile_field->field_type, 'length' => '', 'is_required' => false, 'is_system' => true);
$additionalParameters = array();
switch ($user_profile_field->field_type) {
case 'list':
if (isset($user_profile_field_info['list_values'])) {
$additionalParameters = array('list_values' => $user_profile_field_info['list_values']);
}
break;
case 'multilist':
if (isset($user_profile_field_info['list_values'])) {
$additionalParameters = array('list_values' => $user_profile_field_info['list_values']);
}
if (!is_array($default_value['value'])) {
if (strpos($default_value['value'], ',')) {
$default_value['value'] = explode(',', $default_value['value']);
} else {
$default_value['value'] = array($default_value['value']);
}
}
break;
case 'tree':
if (isset($user_profile_field_info['tree_values'])) {
$additionalParameters = array('tree_values' => $user_profile_field_info['tree_values']);
}
if (isset($user_profile_field_info['display_as_select_boxes'])) {
$additionalParameters['display_as_select_boxes'] = $user_profile_field_info['display_as_select_boxes'];
}
break;
}
$default_value = array_merge($default_value, $additionalParameters);
$user_profile_field->addProperty($default_value);
}
if (in_array($user_profile_field->field_type, array('tree', 'multilist', 'list'))) {
$sort_by_alphabet = array('id' => 'sort_by_alphabet', 'caption' => 'Sort Values By Alphabet', 'value' => isset($user_profile_field_info['sort_by_alphabet']) ? $user_profile_field_info['sort_by_alphabet'] : '', 'type' => 'boolean', 'lenght' => '', 'is_required' => false, 'is_system' => true);
$user_profile_field->addProperty($sort_by_alphabet);
}
$edit_form = new SJB_Form($user_profile_field);
$form_submitted = SJB_Request::getVar('action');
if (in_array($user_profile_field->field_type, array('multilist', 'list'))) {
$user_profile_field->addDisplayAsProperty($user_profile_field_info['display_as']);
}
// infill instructions should be the last element in form
// no instructions for tree field type
if (!in_array($user_profile_field->getFieldType(), array('complex', 'tree', 'location'))) {
if ($form_submitted) {
$user_profile_field->addInfillInstructions(SJB_Request::getVar('instructions'));
} else {
$user_profile_field->addInfillInstructions(isset($user_profile_field_info['instructions']) ? $user_profile_field_info['instructions'] : '');
}
}
/**
* "Display as" options for TREE TYPE
*/
if ('tree' == $user_profile_field->getFieldType()) {
$user_profile_field->addProperty(SJB_TreeType::getDisplayAsDetail(isset($user_profile_field_info['display_as_select_boxes']) ? $user_profile_field_info['display_as_select_boxes'] : ''));
$treeLevelsNumber = SJB_UserProfileFieldTreeManager::getTreeDepthBySID($user_profile_field_sid);
$tp->assign('tree_levels_number', $treeLevelsNumber);
// treee levels captions
for ($i = 1; $i <= $treeLevelsNumber; $i++) {
$levelID = 'level_' . $i;
$user_profile_field->addProperty(array('id' => $levelID, 'caption' => $i . ' Level Name', 'value' => isset($user_profile_field_info[$levelID]) ? $user_profile_field_info[$levelID] : '', 'type' => 'string', 'length' => '250', 'is_required' => false, 'is_system' => true));
}
}
// end of ""Display as" options for TREE TYPE"
$edit_form = new SJB_Form($user_profile_field);
$errors = array();
if ($form_submitted && $edit_form->isDataValid($errors)) {
SJB_UserProfileFieldManager::saveUserProfileField($user_profile_field);
$user_profile_field_new_id = $user_profile_field_info['id'];
if ($user_profile_field_old_id != $user_profile_field_new_id) {
SJB_UserProfileFieldManager::changeUserPropertyIDs($user_group_sid, $user_profile_field_old_id, $user_profile_field_new_id);
}
if ($form_submitted == 'save_info') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/edit-user-profile/?user_group_sid=' . $user_group_sid);
}
}
if ($user_profile_field_info['id'] == 'Location' && empty($errors['ID'])) {
$edit_form->makeDisabled('id');
}
$edit_form->registerTags($tp);
$edit_form->makeDisabled('type');
$tp->assign('user_group_sid', $user_group_sid);
$tp->assign('form_fields', $edit_form->getFormFieldsInfo());
$tp->assign('errors', $errors);
$tp->assign('field_type', $user_profile_field->getFieldType());
$tp->assign('userTree', true);
$tp->assign('user_profile_field_info', $user_profile_field_info);
$tp->assign('user_profile_field_sid', $user_profile_field_sid);
$tp->assign('user_group_info', $user_group_info);
$tp->display('edit_user_profile_field.tpl');
}
}
public static function importTreeItem($field_sid, $imported_row)
{
if (!is_array($imported_row)) {
return false;
}
$parent_sid = 0;
$inserted = false;
foreach ($imported_row as $item_caption) {
if (empty($item_caption)) {
break;
}
$item_sid = SJB_DB::queryValue("SELECT sid FROM user_profile_field_tree WHERE field_sid = ?n AND parent_sid = ?n AND caption = ?s", $field_sid, $parent_sid, $item_caption);
if (!empty($item_sid)) {
} elseif ($item_sid = SJB_UserProfileFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $parent_sid, $item_caption)) {
$inserted = true;
} else {
break;
}
$parent_sid = $item_sid;
}
return $inserted;
}
