'use strict';

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

var resourcecategory = {
    getfamilybanners: function (req, res, next) {

        //console.log("REQ---->",req.body.uid);
        var data = {
            "uid": req.body.uid,
            "member_id": req.body.member_id,
            "limit": (req.body.limit != null && req.body.limit !== "") ? req.body.limit : 20,
            "sessionid": req.body.sessionid,
            "page": req.body.page
        };
        let Qstring =""; // "SELECT uid,id,username FROM members LIMIT 10";
        let QextraString  ="";
        if ( req.body.uid != null && req.body.uid !== ""){
            QextraString=  " AND j.country IN  (SELECT c.country FROM members_wallet w " +
                " LEFT JOIN currency c ON c.code =w.currency " +
                " LEFT JOIN members m ON m.id = w.member_id " +
                " WHERE m.uid = '"+req.body.uid+"' )";
        }

        Qstring =   " SELECT j.title,j.description,m.id AS job_id,m.expire,m.job_description,j.price, " +
            " m.offer_code,j.timeline_days, to_char(m.expire, 'Dy Mon dd, yyyy HH:MI AM') AS expire2," +
            " m.uid AS offer_uid,j.uid AS job_uid,m.added::date AS offer_added,j.country AS job_country, " +
            " c.code AS currency_code, c.description AS currency_description,j.country, j.category " +
            " FROM members_jobs_offer m " +
            " LEFT JOIN members_jobs j ON j.id=m.job_id " +
            " LEFT JOIN currency c ON c.country=j.country " +
            " WHERE m.status = 1 AND m.client_id=0 " +
            " AND m.expire IS NOT NULL " +
            " AND  m.public_view = 1 AND m.expire> now() AND j.status = 1 " + QextraString +
            " ORDER BY m.expire DESC LIMIT "+ data.limit;

        //    // logger.info(Qstring);
        //     db.query(Qstring, function (err, result) {
        //         try {
        //             if (err) throw err;
        //             let resultItem ={
        //                     "result": result.rows,
        //                     "total_record":  result.rowCount
        //             }
        //            // logger.info(result);
        //             next(null, resultItem); // pass control to the next handler
        //            // next(null, result.rows); // pass control to the next handler
        //         } catch (e) {
        //             next(e.message, null); // pass control to the next handler
        //         }


        //    });
        var bannerArray = {
            "tab_categories": {
                "data": [
                    {
                        "uid": "f1b99eee-607b-42f5-ad2f-d4f95065ccb9",
                        "name": "blog",
                        "content": "Blog",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners//kid-res/blog.jpg",
                        "enabled": 1,
                        "action" : "fam-blog"
                    },
                    {
                        "uid": "8208c72d-c5e1-43b2-bbe3-de285845427c",
                        "name": "questions",
                        "content": "Questions?",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners/kid-res/questions.jpg",
                        "enabled": 1,
                        "action" : "ai-question"
                    },
                    {
                        "uid": "3428c6db-af5f-49bf-b879-4a533d6b98bf",
                        "name": "interesting",
                        "content": "Interesting",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners/family-login.jpg",
                        "enabled": 1,
                        "action" : "work-in-progress"
                    },
                    {
                        "uid": "3b0ff711-dd42-4488-a7f4-a5fffd364701",
                        "name": "library",
                        "content": "Library",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners/kid-res/library.jpg",
                        "enabled": 1,
                        "action" : "myfiles"
                    },
                    {
                        "uid": "f50eb4ca-37b3-45f0-93e9-e2b33b8b93d7",
                        "name": "games",
                        "content": "Games",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners/kid-res/games.jpg",
                        "enabled": 1,
                        "action" : "work-in-progress"
                    },
                    {
                        "uid": "5751a446-7d52-498a-a0a2-06c926cdd5c4",
                        "name": "ai-lab",
                        "content": "AI Lab",
                        "description" : "Short description for this item",
                        "banner": "https://www.wrenchboard.com/assets/images/apps/banners/kid-res/ai.jpg",
                        "enabled": 1,
                        "action" : "ai-lab"
                    },

                ]
            }
        };

        // "another1task": {
        //     "banner": {
        //         "image": "https://www.wrenchboard.com/assets/images/apps/banners/recommend-banner.jpg",
        //         "icon": "bannerimage.icon",
        //         "style": "style4",
        //         "text": "Dummy for now",
        //         "description": "dummy dummy dummy",
        //         "action": "thisaction"
        //     }
        // },

        let resultItem ={
            "result": bannerArray,
            "total_record": 4
        }
        next(null,  resultItem ); // pass control to the next handler

    },
    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": "banner-coupons.jpg",
                "banner_location": "LOCAL",
                "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
            }
        });

    },
    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) {}
};
module.exports = resourcecategory;