'use strict'; const request = require('request'); const db = require('../app/db') const logger = require('../app/logger'); const stats = require('../funct/stats'); const bannerList = require('../funct/bannerarray'); var banners = { getfamilybanners: function (req, res, next) { //console.log("REQ---->",req.body.uid); var data = { "uid": req.query.uid, "member_id": req.query.member_id, "limit": (req.query.limit != null && req.query.limit !== "") ? req.query.limit : 20, "sessionid": req.query.sessionid, "page": req.query.page }; console.log("REQ req.body.uid ---->",data); let Qstring =""; let Qstring1 =""; let Qstring2 =""; let QextraString =""; let bannerArray = bannerList; // WHO IS THIS let client_id = 0 ; Qstring = "SELECT id AS client_id FROM members WHERE uid::text = '"+data.uid+"'::text AND id = " + data.member_id; logger.info(Qstring); db.query(Qstring, function (err, result) { try { if (err) throw err; logger.info("client_id result.rows ==> ",result.rows); client_id = result.rows[0]["client_id"]; logger.info("client_id AAA ==> ",client_id); var reqClinet = { "uid": data.uid, "client_id": client_id, }; bannerArray.current.banner.status = stats.checkActiveJobs(reqClinet); bannerArray.pastdue.banner.status = stats.checkPastDueJobs(reqClinet); bannerArray.pending.banner.status = stats.checkPendingOffer(reqClinet); bannerArray.recommend.banner.status = 100; bannerArray.suggested.banner.status = 10; let resultItem ={ "result": bannerArray, "total_record": 4 } next(null, resultItem ); // pass control to the next handler // end of we have client id } catch (e) { logger.info("Error on Client Id =>", e.message); } }); //logger.info("client_id ==> ",client_id); }, homebanners: function (req, res, next) { var result=[]; this.RecoCheckOffers(req, res, function(err, result){ logger.info("************************ aaaa"); logger.info(result); logger.info("************************ bbbb"); }); var result_list =[ { "title": "Some family accounts are yet to log in.", "contract": null, "card_type": "FAMILY_NOLOGIN", "card_style": null, "description": "Some family members have not logged in - a little nudge might help.", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "https://www.wrenchboard.com/assets/images/apps/banners/family-login.jpg", "banner_location": "URL", "link_path": "acc-family", "button_text": "Continue", "short_button_text": "View Now", "short_title": "Some family accounts are yet to log in", "short_description": "Help your family member get started.", "short_style": "short_style" }, { "title": "Yo man , you have Coupons to play with", "contract": null, "card_type": "COUPONS", "card_style": null, "description": "You have received some cash coupons waiting to be redeemed.", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "https://www.wrenchboard.com/assets/images/apps/banners/banner-coupons.jpg", "banner_location": "URL", "link_path": "my-coupon", "button_text": "Continue", "short_button_text": "Redeem", "short_title": "Redeem your Cash Coupons!", "short_description": "You have received some cash coupons waiting to be redeemed.", "short_style": "short_style lg" }, { "title": "Some of your task as owner Need Review now ", "contract": null, "card_type": "REVIEWJOB", "card_style": null, "description": "Some of your task as owner Need Review now,Some of your task as owner Need Review now, S Need Review now", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "banner-job-due.jpg", "banner_location": "LOCAL", "link_path": "my-review-jobs", "button_text": "View Tasks", "short_button_text": "Start Review", "short_title": "Review Ready Tasks", "short_description": "Some of your jobs are waiting for approval ", "short_style": "short_style lr" }, { "title": "Some of your task as owner of the tasks are due ", "contract": null, "card_type": "PASTDUEJOB", "card_style": null, "description": "Some of your task as owner of the tasks are due, Some of your task as owner of the tasks are due", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "https://www.wrenchboard.com/assets/images/apps/banners/past-due.jpg", "banner_location": "URL", "link_path": "my-pastdue-jobs", "button_text": "View Tasks", "short_button_text": "View", "short_title": "Past Due Tasks", "short_description": "Some of you task are now past due", "short_style": "short_style lr" }, { "title": "Share WrenchBoard with a friend.", "contract": null, "card_type": "INVITE", "card_style": null, "description": "Show WrenchBoard to a friend and earn free coupons. Get started.", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "banner-refer.jpg", "banner_location": "LOCAL", "link_path": "referral", "button_text": "Continue", "short_button_text": "View now", "short_title": "Invite a Friend - get Rewards", "short_description": "Share WrenchBoard with a friend.", "short_style": "short_style by" } ]; let resultItem ={ "result": result_list, "total_record": 5 } next(null, resultItem ); // pass control to the next handler }, RecoCheckOffers : function (req, res, next) { let Qstring ="SELECT * FROM members_jobs_offer WHERE expire > now() "+ "AND status = 1 AND client_id > 0 AND client_id =" +req.body.member_id; logger.info(Qstring); db.query(Qstring, function (err, result) { try { if (err) throw err; let resultItem ={ "result": [ { "title": "Share RecoCheckOffers with a friend.", "contract": null, "card_type": "INVITE", "card_style": null, "description": "Show WrenchBoard to a friend and earn free coupons. Get started.", "blog_id": "0", "card_icon": "icon1", "offer_id": "0", "banner": "banner-refer.jpg", "banner_location": "LOCAL", "link_path": "referral", "button_text": "Continue", "short_button_text": "View now", "short_title": "Invite a Friend - get Rewards", "short_description": "Share WrenchBoard with a friend.", "short_style": "short_style by" } ] , "total_record": result.rowCount }; logger.info(result); next(null, resultItem); // pass control to the next handler } catch (e) { next(e.message, null); // pass control to the next handler } }); }, async RecoCheckActive (req, res, next) { let total_active_client_job=0; let Qstring = " SELECT count(id) AS total_active_jobs FROM members_jobs_contract " + " WHERE client_id = "+req.client_id+" AND status =1 AND delivery_date > now() "; logger.info(Qstring); db.query(Qstring, function (err, result) { try { if (err) throw err; total_active_client_job = result.rows[0]["total_active_jobs"]; logger.info("total_active_client_job** ==> ",total_active_client_job); let resultItem ={ "total_active_client_job": total_active_client_job } next(null, resultItem); // pass control to the next handler } catch (e) { logger.info("Error on Active Jobs =>", e.message); } }); logger.info("total_active_client_job ==> ",total_active_client_job); }, }; module.exports = banners;