schema.js

'use strict';

const gql = require('graphql-sync');

const db = require('@arangodb').db;

const hrSystem = db._collection('HRSystem');

let hrtype;

const queryHRType = new gql.GraphQLObjectType({
    name: 'Query',
    fields() {
        return {
            person: {
                type: hrtype,
                args: {
                    id: {
                        description: 'id of the person',
                        type: new gql.GraphQLNonNull(gql.GraphQLInt)
                    }
                },
                resolve(root, args) {
                    return hrSystem.firstExample({
                        _key: args.id.toString()
                    });
                }
            }
        };
    }
});

hrtype = new gql.GraphQLObjectType({
    name: 'person',
    fields() {
        return {
            id: {
                type: new gql.GraphQLNonNull(gql.GraphQLInt),
                resolve(hrSystem) {
                    return parseInt(hrSystem._key);
                }
            },
            name: {
                type: gql.GraphQLString,
                resolve(person) {
                    return person.name.concat(" ", person.surname);
                }
            },
            department: {
                type: gql.GraphQLString,
            },
            mail: {
                type: gql.GraphQLString,
                resolve(person) {
                    return person.official_mail;
                }
            },
            devices_number: {
                type: new gql.GraphQLNonNull(gql.GraphQLString),
                resolve(person) {
                    return db._query(aqlQuery`
                        FOR person IN ${hrSystem}
                        FILTER person._key == ${person._key}
                        LET phonesNumber = person.devices.phone[* FILTER 
                           CURRENT.end_date == null
                        ]
                        
                        LET computerNumber = person.devices.computer[* FILTER 
                           CURRENT.end_date == null
                        ]
                        LET number = COUNT(phonesNumber)+COUNT(computerNumber)
                        RETURN number
                  `).toArray();
                }
            },
            roles: {
                type: new gql.GraphQLNonNull(gql.GraphQLString),
                resolve(person) {
                    return db._query(aqlQuery`
                        FOR person IN ${hrSystem}
                        FILTER person._key == ${person._key}
                        RETURN person.roles[*].title
                  `).toArray();
                }
            }
        };
    }
});


module.exports = new gql.GraphQLSchema({
    query: queryHRType
});