const mongoose = require('mongoose');

const platformSaleSchema = new mongoose.Schema(
  {
    platform: { type: String, default: 'Foodpanda', trim: true }, // e.g. 'Foodpanda', 'Cheetay', etc.
    date: { type: Date, required: true },
    amount: { type: Number, required: true, min: 0 },
    note: { type: String, default: '' },
    createdBy: { type: mongoose.Schema.Types.ObjectId, ref: 'User', required: true },
  },
  { timestamps: true }
);

platformSaleSchema.index({ date: -1 });
platformSaleSchema.index({ platform: 1, date: -1 });

module.exports = mongoose.model('PlatformSale', platformSaleSchema);