public static function deleteUserGroupBySID($user_group_sid)
{
$user_profile_fields_info = SJB_UserProfileFieldManager::getFieldsInfoByUserGroupSID($user_group_sid);
foreach ($user_profile_fields_info as $user_profile_field_info) {
SJB_UserProfileFieldManager::deleteUserProfileFieldBySID($user_profile_field_info['sid']);
}
SJB_DB::query('DELETE FROM `products` WHERE `user_group_sid` = ?n', $user_group_sid);
return SJB_UserGroupDBManager::deleteUserGroupInfo($user_group_sid);
}
public function execute()
{
$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);
SJB_UserProfileFieldManager::deleteUserProfileFieldBySID($user_profile_field_sid);
$user_group_sid = $user_profile_field_info['user_group_sid'];
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/edit-user-profile/?user_group_sid=' . $user_group_sid);
} else {
echo 'The system cannot proceed as User Group SID is not set';
}
}
