validate() {
const heats = this.changes.heats;
if (heats) for(const id in heats) {
const cat = Category.findById(id);
Val.allowAccessIf(cat.org_id === this.org_id);
const format = heats[id];
if (format[0] !== cat.type || ! cat.heatFormatRegex.test(format.slice(1))) {
Val.addError(this, 'heats', 'is_invalid');
}
}
}
return Event =>{
ChangeLog.logChanges(Event);
Event.registerObserveField('org_id');
util.merge(Event.prototype, {
authorize(userId) {
const user = User.fetchAdminister(userId, this);
const {changes} = this;
Val.assertDocChanges(this, FIELD_SPEC, NEW_FIELD_SPEC);
if (! changes.hasOwnProperty('closed'))
Val.allowAccessIf(! this.closed);
this.changes.series_id && Val.allowAccessIf(this.series && user.canAdminister(this.series));
},
});
};
return model =>{
require(['models/change-log'], ChangeLog => {
ChangeLog.logChanges(model);
});
util.merge(model.prototype, {
authorize(userId) {
Val.assertDocChanges(this, FIELD_SPEC);
Val.allowAccessIf(Role.where({
user_id: userId, role: Model.User.ROLE.superUser}).count(1));
},
});
};
session.defineRpc('Reg.upload', function (eventId, data) {
Val.ensureString(eventId);
const {ROLE} = User;
const user = User.findById(this.userId);
Val.allowAccessIf(user);
const event = Event.findById(eventId);
Val.allowAccessIf(event && user.canAdminister(event));
const clubTeamType = TeamType.where({org_id: event.org_id, name: 'Club'}).fetchOne();
Val.allowAccessIf(clubTeamType, 'No Team type named Club found for this organization');
const future = new Future();
parse(Buffer.from(data).toString(), {
columns: function () {return ['Fee level', 'First Name', 'Last Name', 'Birth Date', 'Participant ID']}
}, function(err, rows){
if (err) return future.throw(err);
data = rows;
future.return();
});
future.wait();
const errors = [];
const climbers = {};
let row;
const get = (field)=>{
const val = row[field];
return val && val.trim();
};
if (data.length === 0)
throw new koru.Error(415, 'unsupported_import_format');
for(let i = 0; i < data.length; ++i) {
row = data[i];
var name = get('First Name') + ' ' + get('Last Name');
if (name in climbers)
++climbers[name];
else
climbers[name] = 1;
}
const importCompetitor = ()=>{
const name = get('First Name') + ' ' + get('Last Name');
if (climbers[name] > 1)
throw 'Name: "' + name + '" registered ' + climbers[name] + ' times';
const meta = get('Fee level');
const clubName = meta.split(',')[0].trim();
const club = Team.query.where({name: clubName, teamType_id: clubTeamType._id}).fetchOne();
if (club === undefined) throw "Can't find club '" + clubName + "'";
const mCodes = /\[(.+)\]/.exec(meta);
const codes = mCodes === null ? undefined : mCodes[1].trim().split(',');
let gender = (codes && codes[0][0]) || null;
gender = gender && gender.toLowerCase();
const climber = Climber.query.where({name: name, org_id: event.org_id}).fetchOne() ||
Climber.build({
name: name, org_id: event.org_id, team_ids: [club._id],
dateOfBirth: get('Birth Date').trim(),
gender,
uploadId: get('Participant ID'),
});
if (climber.dateOfBirth !== get('Birth Date').trim())
throw "Climber's date-of-birth does not match: " + climber.dateOfBirth;
if (! climber.$isValid())
throw "Climber: " + Val.inspectErrors(climber);
climber.$save();
if (! (codes && codes.length))
throw "Invalid or missing codes";
const category_ids = [];
codes.forEach(code =>{
code = code.trim();
var cat = Category.query.where({shortName: code, org_id: event.org_id}).fetchOne();
if (! cat) {
throw "Category not found: " + code;
}
category_ids.push(cat._id);
});
const competitor = Competitor.query
.where({event_id: event._id, climber_id: climber._id}).fetchOne() ||
Competitor.build({
event_id: event._id,
climber_id: climber._id,
number: climber.number,
team_ids: [club._id],
});
competitor.category_ids = category_ids.sort();
competitor.$$save();
};
for(let i = 0; i < data.length; ++i) {
try {
row = data[i];
importCompetitor();
} catch(ex) {
errors.push([i+1, data[i], ex.toString()]);
}
};
Event.query.onId(event._id).update({errors: errors});
});