import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";

const Cafes = sequelize.define(
    "cafes",
    {
        id: {
            type: Sequelize.BIGINT,
            primaryKey: true,
            autoIncrement: true,
            allowNull: false,
        },
        cafe_name: {
            type: Sequelize.STRING,
        },
        phone: {
            type: Sequelize.STRING,
        },
        bio: {
            type: Sequelize.TEXT,
        },
        email: {
            type: Sequelize.STRING,
        },
        password: {
            type: Sequelize.STRING,
        },
        remember_token: {
            type: Sequelize.STRING,
        },
        banner_image: {
            type: Sequelize.STRING,
        },
        address: {
            type: Sequelize.STRING,
        },
        postcode: {
            type: Sequelize.STRING,
        },
        latitude: {
            type: Sequelize.STRING,
        },
        longitude: {
            type: Sequelize.STRING,
        },
        website: {
            type: Sequelize.STRING,
        },
        otp: {
            type: Sequelize.TINYINT,
        },
        cafe_type: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = mobile cart , 0 = cafe"
        },
        is_active: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = active, 0 = inactive"
        },
        approved: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = approved, 0 = rejected	"
        },
        signup_completed: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = completed, 0 = pending"
        },
        profile_completed: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = completed, 0 = pending"
        },
        menu_completed: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = completed, 0 = pending"
        },
        loyalty_completed: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = completed, 0 = pending"
        },
        is_listed: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = yes, 0 = no"
        },
        is_open: {
            type: Sequelize.TINYINT,
            defaultValue: 0,
            comment: "1 = open, 0 = close"
        },
        cafe_filter: {
            type: Sequelize.STRING,
            defaultValue: '',
            allowNull: false,
        },
        cafe_tax: {
            type: Sequelize.DOUBLE.UNSIGNED,
            defaultValue: 20,
            comment: 'in %',
        },
        deleted_at: {
            type: Sequelize.INTEGER,
            defaultValue: 0,
            comment: "1 = deleted, 0 = not deleted"
        },
        created_at: {
            type: Sequelize.INTEGER
        },
        updated_at: {
            type: Sequelize.INTEGER
        },
    },
    {
        tableName: 'cafes',
        timestamps: false,
    }
);
sequelizePaginate.paginate(Cafes);
export default Cafes;