D-Net

package eu.dnetlib.organizations.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import eu.dnetlib.organizations.model.UserCountry;

import eu.dnetlib.organizations.model.UserCountryPK;

public interface UserCountryRepository extends JpaRepository<UserCountry, UserCountryPK> {

	void deleteByEmail(String email);

}

package eu.dnetlib.organizations.model;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.IdClass;

import javax.persistence.Table;

@Entity

@Table(name = "user_countries")

@IdClass(UserCountryPK.class)

public class UserCountry implements Serializable {

	/**

	 *

	 */

	private static final long serialVersionUID = 3493897777214583701L;

	@Id

	@Column(name = "email")

	private String email;

	@Id

	@Column(name = "country")

	private String country;

	public UserCountry() {}

	public UserCountry(final String email, final String country) {

		this.email = email;

		this.country = country;

	}

	public String getEmail() {

		return email;

	}

	public void setEmail(final String email) {

		this.email = email;

	}

	public String getCountry() {

		return country;

	}

	public void setCountry(final String country) {

		this.country = country;

	}

}

package eu.dnetlib.organizations.model;

import java.io.Serializable;

import java.util.Objects;

public class UserCountryPK implements Serializable {

	/**

	 *

	 */

	private static final long serialVersionUID = 2003686130380208901L;

	private String email;

	private String country;

	public String getEmail() {

		return email;

	}

	public void setEmail(final String email) {

		this.email = email;

	}

	public String getCountry() {

		return country;

	}

	public void setCountry(final String country) {

		this.country = country;

	}

	@Override

	public int hashCode() {

		return Objects.hash(country, email);

	}

	@Override

	public boolean equals(final Object obj) {

		if (this == obj) { return true; }

		if (obj == null) { return false; }

		if (!(obj instanceof UserCountryPK)) { return false; }

		final UserCountryPK other = (UserCountryPK) obj;

		return Objects.equals(country, other.country) && Objects.equals(email, other.email);

	}

	@Override

	public String toString() {

		return String.format("UserCountryPK [email=%s, country=%s]", email, country);

	}

}

import org.springframework.web.bind.annotation.RequestBody;

import eu.dnetlib.organizations.model.User;

import eu.dnetlib.organizations.model.UserCountry;

import eu.dnetlib.organizations.model.view.UserView;

import eu.dnetlib.organizations.repository.UserCountryRepository;

import eu.dnetlib.organizations.repository.UserRepository;

	@Autowired

	private UserRepository userRepository;

	@Autowired

	private UserCountryRepository userCountryRepository;

	@Transactional

	public void saveUser(@RequestBody final UserView userView) {

		final User user = userRepository.findById(userView.getEmail()).orElseThrow(() -> new RuntimeException("User not found"));

		user.setRole(userView.getRole());

		user.setValid(userView.isValid());

		userRepository.save(user);

		userCountryRepository.deleteByEmail(userView.getEmail());

		for (final String country : userView.getCountries()) {

			userCountryRepository.save(new UserCountry(userView.getEmail(), country));

		}

	}

	@Transactional

	public void deleteUser(final String email) {

		userCountryRepository.deleteByEmail(email);

		userRepository.deleteById(email);

	}

import org.springframework.security.core.Authentication;

import org.springframework.web.bind.annotation.DeleteMapping;

import org.springframework.web.bind.annotation.RequestBody;

import eu.dnetlib.organizations.utils.DatabaseUtils;

	@Autowired

	private DatabaseUtils dbUtils;

	@PostMapping("/api/users")

	public Iterable<UserView> save(@RequestBody final UserView userView, final Authentication authentication) {

		if (authentication.getName().equals(userView.getEmail())) { throw new RuntimeException("You can't edit your own user"); }

		dbUtils.saveUser(userView);

		return users();

	}

	@DeleteMapping("/api/users")

	public Iterable<UserView> delete(final @RequestParam String email, final Authentication authentication) {

		if (authentication.getName().equals(email)) { throw new RuntimeException("You can't delete your own user"); }

		dbUtils.deleteUser(email);

		return users();

	}

	array_agg(uc.country) FILTER (WHERE uc.country IS NOT NULL) AS countries

			<th class="col-5">User</th>

			<th class="col-1 text-center">Enabled</th>

			<th class="col-1 text-center">Is admin</th>

			<th class="col-2"></th>

		<tr ng-repeat="u in users" class="d-flex" ng-class="{'table-danger' : u.role == 'PENDING'}">

			<th class="col-5" ng-class="{'text-secondary': !u.valid}">{{u.email}}</th>

			<td class="col-1 text-center text-success">

				<i class="fa fa-check-circle" ng-if="u.valid"></i>

			</td>

			<td class="col-1 text-center">

				<i class="fa fa-check-circle" ng-if="u.role == 'SUPERUSER'"></i>

				<span class="text-warning" ng-if="u.role == 'PENDING'">not configured</span>

			</td>

			<td class="col-3">

				<span ng-if="u.role == 'USER'">

					<img ng-src="resources/images/flags/{{c}}.gif" title="{{c}}" class="mr-1" ng-repeat="c in u.countries" />

					<span class="text-warning" ng-if="u.countries.length == 0"><i class="fa fa-exclamation-triangle"></i> no countries</span>

				</span>

				<span class="text-muted" ng-if="u.role == 'SUPERUSER'">All countries</span>

				<span class="text-warning" ng-if="u.role == 'PENDING'">not configured</span>

			</td>

			<td class="col-2 text-right">

				<a href="mailto:{{u.email}}" class="btn btn-sm  btn-outline-info"><i class="fa fa-at"></i></a>

				<button type="button" class="btn btn-sm  btn-outline-info" data-toggle="modal" data-target="#editUserModal" ng-click="setCurrentUser(u)"><i class="fa fa-edit"></i></button>

				<button type="button" class="btn btn-sm  btn-outline-danger" ng-click="deleteUser(u.email)"><i class="fa fa-trash"></i></button>

			</td>

<div class="modal fade" id="editUserModal" tabindex="-1" role="dialog">

	<div class="modal-dialog modal-xl" role="document">

		<div class="modal-content">

			<div class="modal-header">

				<h5 class="modal-title">Edit user</h5>

				<button type="button" class="close" data-dismiss="modal">&times;</button>

			</div>

			<div class="modal-body" style="min-height: 300px; max-height: 500px; overflow-y: auto;">

				<form>

					<div class="form-group row">

						<label class="col-sm-2 col-form-label">Email</label>

						<div class="col-sm-10"><a href="mailto:{{currentUser.email}}">{{currentUser.email}}</a></div>

					</div>

					<div class="form-group row">

						<label class="col-sm-2 col-form-label">Enabled</label>

						<div class="col-sm-10">

							<div class="form-check">

								<input class="form-check-input" type="checkbox" ng-model="currentUser.valid" />

							</div>

						</div>

					</div>

					<div class="form-group row" ng-if="currentUser.valid">

						<label class="col-sm-2 col-form-label">Role</label>

						<div class="col-sm-10">

							<div class="form-check form-check-inline">

								<input class="form-check-input" type="radio" value="USER" ng-model="currentUser.role">

								<label class="form-check-label">USER</label>

							</div>

							<div class="form-check form-check-inline">

								<input class="form-check-input" type="radio" value="SUPERUSER" ng-model="currentUser.role">

								<label class="form-check-label">SUPERUSER</label>

							</div>

						</div>

					</div>

					<div class="card mb-3"  ng-if="currentUser.valid && currentUser.role == 'USER'">

						<div class="card-header bg-primary text-white py-1">Countries</div>

						<div class="card-body">

							<div class="form-group row">

								<div class="col-sm-2" ng-repeat="c in vocs.countries">

									<div class="form-check form-check-inline">

										<input class="form-check-input" type="checkbox" checklist-model="currentUser.countries" checklist-value="c"/>

										<label class="form-check-label">{{c}}</label>

									</div>

								</div>

							</div>

						</div>

					</div>

				</form>

			</div>

			<div class="modal-footer">

				<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>

				<button type="button" class="btn btn-primary" data-dismiss="modal" ng-click="saveUser(currentUser)">Save changes</button>

			</div>

		</div>

	</div>

</div>

var orgsModule = angular.module('orgs', ['ngRoute', 'checklist-model']);

orgsModule.controller('usersCtrl', function ($scope, $http, $timeout, $route) {

	$scope.vocs = {};

	$scope.currentUser = {};

		$scope.vocs = res.data;

	$scope.setCurrentUser = function(user) {

		angular.copy(user, $scope.currentUser);

	}

	$scope.saveUser = function(user) {

		$http.defaults.headers.post["Content-Type"] = "application/json;charset=UTF-8";

		$http.post('api/users', user).then(function successCallback(res) {

			$scope.users = res.data;

		}, function errorCallback(res) {

			alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		});

	}

	$scope.deleteUser = function(email) {

		if (confirm("Are you sure ?")) {

			$http.delete('api/users?email=' + email).then(function successCallback(res) {

				$scope.users = res.data;

			}, function errorCallback(res) {

				alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

			});

		}

	}

/**

 * Checklist-model

 * AngularJS directive for list of checkboxes

 * https://github.com/vitalets/checklist-model

 * License: MIT http://opensource.org/licenses/MIT

 */

 /* commonjs package manager support (eg componentjs) */

 if (typeof module !== "undefined" && typeof exports !== "undefined" && module.exports === exports){

   module.exports = 'checklist-model';

 }

angular.module('checklist-model', [])

.directive('checklistModel', ['$parse', '$compile', function($parse, $compile) {

  // contains

  function contains(arr, item, comparator) {

    if (angular.isArray(arr)) {

      for (var i = arr.length; i--;) {

        if (comparator(arr[i], item)) {

          return true;

        }

      }

    }

    return false;

  }

  // add

  function add(arr, item, comparator) {

    arr = angular.isArray(arr) ? arr : [];

      if(!contains(arr, item, comparator)) {

          arr.push(item);

      }

    return arr;

  }

  // remove

  function remove(arr, item, comparator) {

    if (angular.isArray(arr)) {

      for (var i = arr.length; i--;) {

        if (comparator(arr[i], item)) {

          arr.splice(i, 1);

          break;

        }

      }

    }

    return arr;

  }

  // http://stackoverflow.com/a/19228302/1458162

  function postLinkFn(scope, elem, attrs) {

     // exclude recursion, but still keep the model

    var checklistModel = attrs.checklistModel;

    attrs.$set("checklistModel", null);

    // compile with `ng-model` pointing to `checked`

    $compile(elem)(scope);

    attrs.$set("checklistModel", checklistModel);

    // getter for original model

    var checklistModelGetter = $parse(checklistModel);

    var checklistChange = $parse(attrs.checklistChange);

    var checklistBeforeChange = $parse(attrs.checklistBeforeChange);

    var ngModelGetter = $parse(attrs.ngModel);

    var comparator = function (a, b) {

      if(!isNaN(a) && !isNaN(b)) {

        return String(a) === String(b);

      } else {

        return angular.equals(a,b);

      }

    };

    if (attrs.hasOwnProperty('checklistComparator')){

      if (attrs.checklistComparator[0] == '.') {

        var comparatorExpression = attrs.checklistComparator.substring(1);

        comparator = function (a, b) {

          return a[comparatorExpression] === b[comparatorExpression];

        };

      } else {

        comparator = $parse(attrs.checklistComparator)(scope.$parent);

      }

    }

    // watch UI checked change

    var unbindModel = scope.$watch(attrs.ngModel, function(newValue, oldValue) {

      if (newValue === oldValue) {

        return;

      }

      if (checklistBeforeChange && (checklistBeforeChange(scope) === false)) {

        ngModelGetter.assign(scope, contains(checklistModelGetter(scope.$parent), getChecklistValue(), comparator));

        return;

      }

      setValueInChecklistModel(getChecklistValue(), newValue);

      if (checklistChange) {

        checklistChange(scope);

      }

    });

    // watches for value change of checklistValue

    var unbindCheckListValue = scope.$watch(getChecklistValue, function(newValue, oldValue) {

      if( newValue != oldValue && angular.isDefined(oldValue) && scope[attrs.ngModel] === true ) {

        var current = checklistModelGetter(scope.$parent);

        checklistModelGetter.assign(scope.$parent, remove(current, oldValue, comparator));

        checklistModelGetter.assign(scope.$parent, add(current, newValue, comparator));

      }

    }, true);

    var unbindDestroy = scope.$on('$destroy', destroy);

    function destroy() {

      unbindModel();

      unbindCheckListValue();

      unbindDestroy();

    }

    function getChecklistValue() {

      return attrs.checklistValue ? $parse(attrs.checklistValue)(scope.$parent) : attrs.value;

    }

    function setValueInChecklistModel(value, checked) {

      var current = checklistModelGetter(scope.$parent);

      if (angular.isFunction(checklistModelGetter.assign)) {

        if (checked === true) {

          checklistModelGetter.assign(scope.$parent, add(current, value, comparator));

        } else {

          checklistModelGetter.assign(scope.$parent, remove(current, value, comparator));

        }

      }

    }

    // declare one function to be used for both $watch functions

    function setChecked(newArr, oldArr) {

      if (checklistBeforeChange && (checklistBeforeChange(scope) === false)) {

        setValueInChecklistModel(getChecklistValue(), ngModelGetter(scope));

        return;

      }

      ngModelGetter.assign(scope, contains(newArr, getChecklistValue(), comparator));

    }

    // watch original model change

    // use the faster $watchCollection method if it's available

    if (angular.isFunction(scope.$parent.$watchCollection)) {

        scope.$parent.$watchCollection(checklistModel, setChecked);

    } else {

        scope.$parent.$watch(checklistModel, setChecked, true);

    }

  }

  return {

    restrict: 'A',

    priority: 1000,

    terminal: true,

    scope: true,

    compile: function(tElement, tAttrs) {

      if (!tAttrs.checklistValue && !tAttrs.value) {

        throw 'You should provide `value` or `checklist-value`.';

      }

      // by default ngModel is 'checked', so we set it if not specified

      if (!tAttrs.ngModel) {

        // local scope var storing individual checkbox model

        tAttrs.$set("ngModel", "checked");

      }

      return postLinkFn;

    }

  };

}]);

	<script src='resources/js/checklist-model.js'></script>