models.mjs

import { DataTypes, Model } from 'sequelize';
import sequelize from './sequelize.mjs';
//import logger from './logger.mjs';

//
// USER MODEL
//

class User extends Model {
    //Custom methods go here
}

User.init(
    { // FIELDS
        id: {
            type: DataTypes.INTEGER,
            autoIncrement: true,
            primaryKey: true,
        },
        firstName: {
            type: DataTypes.STRING(35),
            allowNull: false,
        },
        lastName: {
            type: DataTypes.STRING(70),
            allowNull: false,
        },
        email: {
            type: DataTypes.STRING,
            unique: true,
            allowNull: false,
            isEmail: true,
        },
        phone: {
            type: DataTypes.STRING(15),
        },
        role: {
            type: DataTypes.ENUM('Admin','Leader','Participant'),
            allowNull: false,
        },
        lotteryWeight: {
            type: DataTypes.FLOAT,
            allowNull: false,
            defaultValue: 1,
        },
        hasWaiver: {
            type: DataTypes.BOOLEAN,
            allowNull: false,
            defaultValue: false,
        },
        tripsLead: {
            type: DataTypes.INTEGER,
            allowNull: false,
            defaultValue: 0,
        },
        tripsParticipated: {
            type: DataTypes.INTEGER,
            allowNull: false,
            defaultValue: 0,
        },
        joinedListserv: {
            type: DataTypes.BOOLEAN,
            allowNull: false,
            defaultValue: false,
        }
    },
    { // OPTIONS
        sequelize,
        //Preserves snake_case notation
        tableName: 'users',
        underscored: true,
    }
);

//
// TRIP MODEL
//

class Trip extends Model {
    //Custom methods go here
}

//Create default planning checklist
const tasks = ['Add to Google Calendar', 'Event Registration Request', 'Event Plan', 'Trip Description/Blurb', 'Lottery', 'Acceptance/Rejectance Emails', 'Pre-Trip Email', 'SAO Pre-Trip Email', 'Grab Medkit', 'Attendance', 'Follow Up Email', 'SAO Post-Trip Email', 'Impact Tracker'];
const taskObj = {
    responsible: '',
    complete: false,
};
const defaultPlanningChecklist = tasks.reduce((pcList, task) => {
    pcList[task] = { ...taskObj };
    return pcList;
}, {});

Trip.init(
    { // FIELDS
        id: {
            type: DataTypes.INTEGER,
            autoIncrement: true,
            primaryKey: true,
        },
        tripName: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        category : {
            type: DataTypes.ENUM('Hiking', 'Camping', 'Backpacking', 'Biking', 'Climbing', 'Skiing', 'Water', 'Event', 'Running', 'Exploration', 'Local', 'Special'),
            allowNull: false,
            defaultValue: 'Special',
        },
        plannedDate: {
            type: DataTypes.DATEONLY,
            allowNull: false,
        },
        plannedEndDate : {
            type: DataTypes.DATEONLY,
        },
        maxSize: {
            type: DataTypes.INTEGER,
            allowNull: false,
        },
        class: {
            type: DataTypes.STRING(1),
            validate: { //Ensures only class or priceOverride is defined, not both
                classXorPriceOverride(val) {
                    if (!(!val ^ !this.priceOverride)) { //nots coerce to booleans lol
                        throw new Error('Either both class and priceOverride are null or both are not null');
                    }
                }
            }
        },
        priceOverride: {
            type: DataTypes.FLOAT,
        },
        sentenceDesc: {
            type: DataTypes.STRING(1000), //We might want to play with this number at some point
        },
        blurb: {
            type: DataTypes.TEXT,
        },
        image: {
            type: DataTypes.STRING(512), //No URL will be longer than this... right?
        },
        status: {
            type: DataTypes.ENUM('Staging','Open','Pre-Trip','Post-Trip','Complete'),
            allowNull: false,
            defaultValue: 'Staging',
        },
        planningChecklist: {
            type: DataTypes.JSON,
            allowNull: false,
            defaultValue: JSON.stringify(defaultPlanningChecklist),
        },
    },
    { // OPTIONS
        sequelize,
        indexes: [{ //Combination of trip_name and planned_date must be unique
            unique: true,
            fields: ['trip_name', 'planned_date'],
        }],
        //Preserves snake_case notation
        tableName: 'trips',
        underscored: true,
    }
);

//
// TRIP_USER_MAP MODEL
//

class TripSignUp extends Model {
    //Custom methods go here
}

TripSignUp.init(
    { // FIELDS
        tripId: {
            type: DataTypes.INTEGER,
            allowNull: false,
            primaryKey: true,
        },
        userId: {
            type: DataTypes.INTEGER,
            allowNull: false,
            primaryKey: true,
        },
        tripRole: {
            type: DataTypes.ENUM('Leader','Participant'),
            allowNull: false,
        },
        status: {
            type: DataTypes.ENUM('Signed Up','Selected','Waitlisted','Not Selected','Attended','No Show'),
            defaultValue: 'Signed Up',
        },
        needPaperwork: {
            type: DataTypes.BOOLEAN,
            defaultValue: false,
        },
        confirmed: {
            type: DataTypes.BOOLEAN,
            defaultValue: false,
        },
        paid: {
            type: DataTypes.BOOLEAN,
            defaultValue: false, 
        },
    },
    { // OPTIONS
        sequelize,
        //Preserves snake_case notation
        tableName: 'trip_signups',
        underscored: true,
    }
);

//Overrides default values of status, needPaperwork, confirmed, and paid to null for leaders
TripSignUp.beforeValidate((inst) => {
    if (inst.tripRole === 'Leader') {
        inst.status = null;
        inst.needPaperwork = null;
        inst.confirmed = null;
        inst.paid = null;
    }
});

//
// TRIP_CLASS MODEL
//

class TripClass extends Model {
    //Custom methods go here
}

TripClass.init(
    { // FIELDS
        tripClass: {
            type: DataTypes.STRING(1),
            allowNull: false,
            primaryKey: true,
        },
        link: {
            type: DataTypes.STRING,
        },
        price: {
            type: DataTypes.FLOAT,
            allowNull: false,
        },
    },
    { // OPTIONS
        sequelize,
        //Preserves snake_case notation
        tableName: 'trip_classes',
        underscored: true,
    }
);

//
// ASSOCIATIONS AND SYNCHRONIZATION
//

//trip_classes and trips association
TripClass.hasMany(Trip, { foreignKey: 'class' });
Trip.belongsTo(TripClass, { foreignKey: 'class' });

//users and trips association - special "Super Many-to-Many" association
User.belongsToMany(Trip, { through: TripSignUp, foreignKey: 'userId' });
Trip.belongsToMany(User, { through: TripSignUp, foreignKey: 'tripId' });
User.hasMany(TripSignUp, { foreignKey: 'userId' });
TripSignUp.belongsTo(User, { foreignKey: 'userId' });
Trip.hasMany(TripSignUp, { foreignKey: 'tripId' });
TripSignUp.belongsTo(Trip, { foreignKey: 'tripId' });

//Sync models with database
// await sequelize.sync({force: true});
//logger.log('Models successfully synced with database');

export default { User, Trip, TripSignUp, TripClass };