salix/modules/worker/back/methods/worker-time-control/getClockIn.js

module.exports = Self => {
    Self.remoteMethod('getClockIn', {
        description: 'Shows the clockings for each day, in columns per day',
        accessType: 'READ',
        accepts: [
            {
                arg: 'workerFk',
                type: 'number',
                required: true,
            },

        ],
        http: {
            path: `/getClockIn`,
            verb: 'GET'
        },
        returns: {
            type: ['Object'],
            root: true
        },
    });

    Self.getClockIn = async(workerFk, options) => {
        const myOptions = {};
        if (typeof options == 'object')
            Object.assign(myOptions, options);

        const query = `CALL vn.workerTimeControl_getClockIn(?, ?)`;
        const [result] = await Self.rawSql(query, [workerFk, Date.vnNew()], myOptions);
        return result;
    };
};