Promo Codes

/create_promo

/list_promos

/delete_promo NEWYEAR2025

model PromoCode {
  id               String   @id
  code             String   @unique
  name             String?  // Display name
  
  // Plan configuration
  planType         String   // "basic", "premium", "biweekly", "monthly"
  durationDays     Int
  hasCopierAccess  Boolean  @default(false)
  
  // Pricing
  isFree           Boolean  @default(false)
  amountKobo       Int?     // If not free
  
  // Expiry
  expiresAt        DateTime
  
  // Usage limits
  usageLimit       Int?     // Max total uses (null = unlimited)
  usageCount       Int      @default(0)
  perUserLimit     Int      @default(1)
  
  // Metadata
  createdBy        String   @default("admin")
  isActive         Boolean  @default(true)
  
  createdAt        DateTime
  updatedAt        DateTime
}

await prisma.promoCode.create({
  data: {
    code: 'NEWYEAR2025',
    name: 'New Year Special 2025',
    planType: 'monthly',
    durationDays: 30,
    hasCopierAccess: false,
    isFree: false,
    amountKobo: 1000000, // ₦10,000
    expiresAt: new Date('2025-01-31'),
    usageLimit: 100,
    perUserLimit: 1,
    isActive: true
  }
})

/broadcast_promo

const promo = await prisma.promoCode.findUnique({
  where: { code: promoCode.toUpperCase() }
})

if (!promo) {
  return 'Code not found'
}

if (!promo.isActive) {
  return 'Code is inactive'
}

if (new Date(promo.expiresAt) < new Date()) {
  return 'Code has expired'
}

if (promo.usageLimit && promo.usageCount >= promo.usageLimit) {
  return 'Code usage limit reached'
}

const userUsageCount = await prisma.subscription.count({
  where: {
    telegramUserId: user.id,
    paystackRef: { equals: promoCode, mode: 'insensitive' }
  }
})

if (userUsageCount >= promo.perUserLimit) {
  return 'You already used this code'
}

const activeCodes = await prisma.promoCode.findMany({
  where: {
    isActive: true,
    expiresAt: { gt: new Date() }
  },
  orderBy: { createdAt: 'desc' }
})

console.log('Active Codes:', activeCodes)

await prisma.promoCode.update({
  where: { code: 'OLDPROMO' },
  data: { isActive: false }
})

await prisma.promoCode.update({
  where: { code: 'FLASH24' },
  data: {
    expiresAt: new Date('2025-12-31')
  }
})

const promo = await prisma.promoCode.findUnique({
  where: { code: 'NEWYEAR2025' }
})

const remaining = promo.usageLimit 
  ? promo.usageLimit - promo.usageCount 
  : 'Unlimited'

console.log(`
Promo: ${promo.name}
Used: ${promo.usageCount}
Remaining: ${remaining}
Expires: ${promo.expiresAt.toLocaleDateString()}
`)

const topCodes = await prisma.promoCode.findMany({
  orderBy: { usageCount: 'desc' },
  take: 10
})

topCodes.forEach((code, i) => {
  console.log(`${i+1}. ${code.code}: ${code.usageCount} uses`)
})