var express = require('express');
var router = express.Router();
var debug = require('debug')('referral')

const { v4: uuidv4 } = require('uuid')

router.get('/', function(req, res, next) {
  res.send('list of referrals...');
});

// Grant & Retrieve Referral tokens for existing user

// usage:  GET '/grant?sponsor_id=N&expiry=2021-09-01'
//
// Required: 
//   sponsor_id (= user.id)
// Changes to DB: 
//    adds record to referrals table:
//      { token: <uuid>, sponsor_id: <user.id>, status: "pending" }
router.post(
  "/grant",
  auth,
  ah(async (req, res) => {
    const {sponsor_id, expiry} = req.body
    debug('grant token..')
    var token = uuidv4()
    debug('generated token: ' + token + ' sponsored by ' + sponsor_id)

    var ref = await db.Referral.create({
      sponsor_id: sponsor_id, 
      token: token, 
      status: 'pending'
    })

    debug('generated referral: ' + JSON.stringify(ref))
    return res.send({token: token, expiry: expiry})
  })
);

router.get(
  "/grant",
  // auth,
  ah(async (req, res) => {
    const {sponsor_id, expiry} = req.query
    debug('grant token..')
    var token = uuidv4()
    debug('generated token: ' + token + ' sponsored by ' + sponsor_id)

    var ref = await db.Referral.create({
      sponsor_id: sponsor_id, 
      token: token, 
      status: 'pending'
    })

    debug('generated referral: ' + JSON.stringify(ref))
    return res.send({token: token, status: 'pending', expiry: expiry})
  })
);


// usage:  GET '/checkTokens/<user_id>'
//
// Required: 
//   sponsor_id (= user.id)
// Returns: 
//    { tokens: <list of tokens>}
// TO FIX - change sponsor_id so that it is retrieved from current payload (NOT FROM URL)
router.get(
  "/checkTokens/:sponsor_id",
  // auth,
  ah(async (req, res) => {
    const {sponsor_id} = req.params

    var tokens = await db.Referral.findAll({
      // attributes: ['token', 'created_at', 'user_id', 'status'],
      include: [
        { model: db.User, as: 'user', attributes: ['username']}
      ],
      where: { sponsor_id: sponsor_id }
    })

    debug('my tokens: ' + JSON.stringify(tokens))
    return res.send({tokens: tokens})
  })
);

// Verify token and apply to existing user
// usage:  GET '/verify/<user_id>/<token>'
//
// Required: 
//   current user_id (= user.id)
//   token
// Changes to DB (on success): 
//    referral token is updated from 'pending' to 'active'
//    referral token is updated with existing user_id
router.get(
  "/verify/:user_id/:token",
  auth,
  ah(async (req, res) => {
    const { user_id, token } = req.params;

    debug('verify token: ' + token)
      
    const found = await db.Referral.findAll({
      attributes: ['status'],
      where: {
        token: token,
        user_id: null
      }
    })

    if (found && found.length) {
      debug('found referral: ' + JSON.stringify(found))
      if (found[0].status === 'pending') {

        await db.Referral.update(
          { 
            status: 'active',
            user_id: user_id,
            updated_at: new Date().toISOString().substring(0,10)
          },
          {
            where: { token: token }
          }
        )

        return res.send({ verified: true });
      } else {
        res.status(500).send({ verified: false, message: 'Referral already ' + found[0].status })
      }
    } else {
      res.status(500).send('Invalid referral token')
    }
  })
);

// Add email / sms to waiting list 
// usage:  POST '/joinQueue'  { email: , sms: }
//
// Required: 
//   either email or sms
// Changes to DB (on success): 
//    adds record to waiting_list:
//       { email: <email>, sms: <sms> }
// Returns: { success: true, message: <message>} 
router.post(
  "/joinQueue",
  ah(async (req, res) => {
    const { email, sms } = req.query;

    debug('email: ' + email)
    debug('sms: ' + sms)

    await db.WaitingList.create({
      email: email,
      sms: sms    
    })

    res.send({success: true, message: 'Added to waiting list'})
  })
);

module.exports = router;