"use strict";

const request = require("request");
const db = require("../app/db");
const logger = require("../app/logger");

var stats = {
  checkActiveJobs(clientData) {
    console.log(" ==== YES TESTING FOR CLIENT   === >", clientData);

    let Qstring1 =
      "SELECT count(id) AS total_active_jobs FROM members_jobs_contract  " +
      " WHERE client_id = " +
      clientData.client_id +
      " AND status =1 AND delivery_date > now() ";
    logger.info(Qstring1);
    db.query(Qstring1, function (err, result) {
      try {
        if (err) throw err;
        return result.rows[0]["total_active_jobs"];
      } catch (e) {
        logger.info("Error on Active Jobs =>", e.message);
        return 0;
      }
    });
    return -1;
  },
  checkPastDueJobs(clientData) {
    console.log(" ==== YES PAST DUE FOR CLIENT   === >", clientData);
    let Qstring1 =
      " SELECT count(id) AS total_past_due FROM members_jobs_contract  " +
      " WHERE client_id = " +
      clientData.client_id +
      " AND status =1 AND delivery_date < now() ";
    logger.info(Qstring1);
    db.query(Qstring1, function (err, result) {
      try {
        if (err) throw err;
        return result.rows[0]["total_past_due"];
      } catch (e) {
        logger.info("Error on past due =>", e.message);
        return 0;
      }
    });
    return -1;
  },
  checkPendingOffer(clientData) {
    console.log(" ==== YES PENDING OFFER FOR CLIENT   === >", clientData);
    let Qstring1 =
      " SELECT count(id) AS total_offers FROM members_jobs_offer  " +
      " WHERE client_id = " +
      clientData.client_id +
      " AND status =1 AND expire > now() ";
    logger.info(Qstring1);
    db.query(Qstring1, function (err, result) {
      try {
        if (err) throw err;
        return result.rows[0]["total_offers"];
      } catch (e) {
        logger.info("Error on past due =>", e.message);
        return 0;
      }
    });
    return -1;
  },
};
module.exports = stats;


// RecoCheckFamilyLogin : function (req, res, next) {},
// RecoCheckFamilyCount : function (req, res, next) {},
// RecoCheckCoupons : function (req, res, next) {},
// RecoCheckTaskDue : function (req, res, next) {},
// RecoCheckTaskReview : function (req, res, next) {},
// RecoCheckBlog : function (req, res, next) {},
// RecoOffersInterest : function (req, res, next) {},
// RecoReferAFreind : function (req, res, next) {},
// RecoPendingInterestCount : function (req, res, next) {},