Exemplo n.º 1
0
/**
 * Insert users for contacts group into database
 *
 * @param integer/string Group ID or 'new'
 * @param string Users IDs separated with comma
 * @param string Name of input element with new group name
 * @return array/boolean Array( 'count_users', 'group_name' ) if success, else false
 */
function create_contacts_group_users($group, $users, $new_group_field_name = 'group_combo')
{
    global $DB, $current_User, $Messages;
    $users_IDs = explode(',', $users);
    if (count($users_IDs) == 0 || strlen($users) == 0) {
        // No selected users
        $Messages->add(T_('Please select at least one user.'), 'error');
        return false;
    }
    if ($group == 'new' || (int) $group < 0) {
        // Add new group
        if ((int) $group < 0) {
            // Default group
            $default_groups = get_contacts_groups_default();
            if (isset($default_groups[$group])) {
                // Get group name
                $group_name = $default_groups[$group];
            } else {
                // Error
                $Messages->add('No found this group.', 'error');
                return false;
            }
        } else {
            // New entered group
            $group_name = param($new_group_field_name, 'string', true);
            param_check_not_empty($new_group_field_name, T_('Please enter name for new group.'));
        }
        if ($group_ID = create_contacts_group($group_name)) {
            // Create group
            $Messages->add(T_('New contacts group has been created.'), 'success');
        } else {
            // Errors
            return false;
        }
    } else {
        // Existing group
        $group_ID = (int) $group;
        if ($group_ID == 0) {
            // No defined group ID
            return false;
        }
        $SQL = new SQL();
        $SQL->SELECT('cgr_name AS name');
        $SQL->FROM('T_messaging__contact_groups');
        $SQL->WHERE('cgr_user_ID = ' . $current_User->ID);
        $SQL->WHERE_and('cgr_ID = ' . $DB->quote($group_ID));
        $group = $DB->get_row($SQL->get());
        if (is_null($group)) {
            // User try use a group of another user
            return false;
        }
        $group_name = $group->name;
    }
    // Get all Users IDs of selected group in order to exclude duplicates
    $SQL = new SQL();
    $SQL->SELECT('cgu_user_ID, cgu_cgr_ID');
    $SQL->FROM('T_messaging__contact_groupusers');
    $SQL->WHERE_and('cgu_cgr_ID = ' . $DB->quote($group_ID));
    $users_already_grouped = $DB->get_assoc($SQL->get());
    $sql = 'INSERT INTO T_messaging__contact_groupusers ( cgu_user_ID, cgu_cgr_ID ) VALUES ';
    $records = array();
    foreach ($users_IDs as $user_ID) {
        $user_ID = (int) trim($user_ID);
        if ($user_ID == 0) {
            // User ID is empty
            continue;
        } else {
            if (isset($users_already_grouped[$user_ID])) {
                if ($users_already_grouped[$user_ID] == $group_ID) {
                    // This user already is added in selected group
                    continue;
                }
            }
        }
        $records[] = '( ' . $user_ID . ', ' . $DB->quote($group_ID) . ' )';
    }
    $sql .= implode(', ', $records);
    if (count($records) == 0) {
        // No data to add
        return false;
    }
    if ($DB->query($sql, 'Insert users for contacts group')) {
        // Success query
        return array('count_users' => count($records), 'group_name' => $group_name);
    } else {
        // Failed query
        return false;
    }
}
Exemplo n.º 2
0
/**
 * Update contact groups for user in database
 *
 * @param string Users ID
 * @param array Group IDs
 * @param boolean TRUE to block the contact, FALSE to unblock, NULL to don't touch the contact block status
 * @return boolean TRUE if success, else FALSE
 */
function update_contacts_groups_user($user_ID, $groups, $blocked = NULL)
{
    global $DB, $current_User, $Messages;
    if (empty($user_ID)) {
        // No selected user
        return false;
    }
    if ($blocked !== NULL) {
        // Update the contact block status
        set_contact_blocked($user_ID, intval($blocked));
    }
    $insert_sql = 'REPLACE INTO T_messaging__contact_groupusers ( cgu_user_ID, cgu_cgr_ID ) VALUES ';
    $records = array();
    foreach ($groups as $group) {
        if ($group == 'new' || intval($group) < 0) {
            // Add new group
            if (intval($group) < 0) {
                // Default group
                $default_groups = get_contacts_groups_default();
                if (isset($default_groups[$group])) {
                    // Get group name
                    $group_name = $default_groups[$group];
                }
            } else {
                // New entered group
                $group_name = param('contact_group_new', 'string');
                if (empty($group_name)) {
                    $Messages->add(T_('Please enter name for new group.'), 'error');
                }
            }
            if ($group_ID = create_contacts_group($group_name)) {
                // Create new group
                $Messages->add(T_('New contacts group has been created.'), 'success');
            }
        } else {
            // Existing group
            $group_ID = intval($group);
        }
        if (empty($group_ID)) {
            // No defined group ID
            continue;
        }
        $records[] = '( ' . $user_ID . ', ' . $DB->quote($group_ID) . ' )';
    }
    $current_user_groups = get_contacts_groups_array(false);
    if (count($current_user_groups) > 0) {
        // Clear previous selected groups for the user before new updating, in order to delete the user from the unchecked groups
        $DB->query('DELETE FROM T_messaging__contact_groupusers
			WHERE cgu_user_ID = ' . $DB->quote($user_ID) . '
			  AND cgu_cgr_ID IN ( ' . $DB->quote(array_keys($current_user_groups)) . ' )');
    }
    if (count($records) == 0) {
        // No data to add
        return true;
    }
    $insert_sql .= implode(', ', $records);
    if ($DB->query($insert_sql, 'Insert user for contact groups')) {
        // Success query
        return true;
    } else {
        // Failed query
        return false;
    }
}