import express from "express";
var router = express.Router();

import { v4 } from "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: "available" }

/**
 * @api {post} /grant Grant Referral code
 * @apiName Grant
 * @apiGroup Referrals
 *
 *
 * @apiPermission member
 *
 * @apiParam {sponsor_id} user_id of member generating referral code.
 * @apiParam {expiry} optional expiry date for token.
 *
 * @apiSuccess {String} token referral token
 * @apiSuccess {Date} expiry optional expiry
 *
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *        "token": "*********",
 *        "status": "available",
 *        "expiry": null
 *     }
 */
router.post("/grant", auth, async (req, res) => {
  const { sponsor_id, expiry } = req.body;
  var token = v4();

  var ref = await knex.table("referrals").insert({
    sponsor_id: sponsor_id,
    token: token,
    status: "available"
  });

  return res.send({ token: token, status: "available", expiry: expiry });
});

/**
 * @api {get} /grant Grant Referral code (variation using get)
 * @apiName Grant
 * @apiGroup Referrals
 *
 * @apiPermission member
 *
 * @apiPermission member
 * @apiParam {sponsor_id} user_id of member generating referral code.
 * @apiParam {expiry} optional expiry date for token.
 *
 * @apiSuccess {String} token referral token
 * @apiSuccess {Status} status referral status
 * @apiSuccess {Date} expiry optional expiry
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *        "token": "*********",
 *        "status": "available",
 *        "expiry": null
 *     }
 */
router.get("/grant", auth, async (req, res) => {
  const { sponsor_id, expiry } = req.query;
  var token = v4();

  var ref = await knex.table("referrals").insert({
    sponsor_id: sponsor_id,
    token: token,
    status: "available"
  });

  return res.send({ token: token, status: "available", expiry: expiry });
});

/**
 * @api {get} /checkTokens/:sponsor_id Retrieve list of referral tokens generated by this user
 *
 * @apiName checkTokens
 * @apiGroup Referrals
 *
 *
 * @apiPermission member
 *
 * @apiParam {sponsor_id} user_id of member generating referral code.
 * @apiParam {status} optional token status.
 *
 * @apiSuccess tokens array of token objects
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *       "tokens": [
 *         {"token": "*********", "status": "available", "expiry": null}
 *       ]
 *     }
 */

// TO FIX - change sponsor_id so that it is retrieved from current payload (NOT FROM URL)

router.get("/checkTokens/:sponsor_id", auth, async (req, res) => {
  const { sponsor_id } = req.params;
  const { status } = req.query;

  var tokens = knex
    .select(
      "token",
      "created_at",
      knex.raw("LEFT(created_at,10) as created"),
      "username",
      "status"
    )
    .from("referrals")
    .leftJoin("users", "users.id", "referrals.user_id")
    .where("sponsor_id", "like", sponsor_id);

  if (status && status !== "all")
    tokens = tokens.where("status", "like", status);
  const found = await tokens;

  return res.send({ tokens: found });
});

/**
 * @api {get} /verify/:user_id  Verify token and apply to existing user
 *
 * @apiName verify
 * @apiGroup Referrals
 *
 * @apiPermission member
 *
 * @apiParam {user_id} Current user
 * @apiParam {token} Token to validate
 *
 * @apiSuccess verified = true
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *       "verified": true
 *     }
 *
 * @apiDescription referral token is updated from 'available' to 'used'
 * @apiDescription referral token is updated with existing user_id
 */
router.get("/verify/:user_id/:token", auth, async (req, res) => {
  const { user_id, token } = req.params;

  const found = await knex
    .select("status")
    .from("referrals")
    .where("token", "like", token)
    .whereNull("user_id");

  if (found && found.length) {
    if (found[0].status === "available") {
      await knex("referrals")
        .where("token", "like", token)
        .update({
          status: "used",
          user_id: user_id,
          updated_at: new Date().toISOString().substring(0, 10)
        });

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

/**
 * @api {post} /joinQueue  Join waiting list (track email & phone)
 * @apiName joinQueue
 * @apiGroup Referrals
 *
 * @apiParam {email} email address
 * @apiParam {phone} phone number
 *
 * @apiSuccess verified = true
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *       "success": true
 *       "message": 'Added to waiting list'
 *     }
 *
 * @apiDescription referral token is updated from 'available' to 'used'
 * @apiDescription referral token is updated with existing user_id
 */
router.post("/joinQueue", async (req, res) => {
  const { email, phone, user_id } = req.body;

  await knex.table("waiting_list").insert({
    email: email,
    phone: phone,
    user_id: user_id
  });

  res.send({
    success: true,
    message: "Added " + email + " to waiting list " + phone
  });
});

router.get("/joinQueue", async (req, res) => {
  const { email, phone, user_id } = req.query;

  await knex("waiting_list").insert({
    email: email,
    phone: phone,
    user_id: user_id
  });

  res.send({
    success: true,
    message: "Added " + email + " to waiting list " + phone
  });
});

/**
 * @api {get} /isReferred/:user_id  Check if user is referred
 * @apiName isReferred
 * @apiGroup Referrals
 *
 * @apiParam {user_id} user id
 *
 * @apiSuccessExample {json} Success-Response:
 *     HTTP/1.1 200 OK
 *     {
 *       true
 *     }
 *
 * @apiDescription returns boolean indicating if user is referred or not
 */
router.get("/isReferred/:user_id", async (req, res) => {
  const { user_id } = req.params;

  var referred = await knex("referrals")
    .select("referrals.id")
    .where("user_id", "like", user_id)
    .where("status", "like", "used");

  if (referred && referred.length) {
    res.send({ referred: true });
  } else {
    res.send({ referred: false });
  }
});

export default router;