var express = require("express");
var router = express.Router();
var service=require('../../models/apis/service');
var periodSchedule=require('../../models/apis/periodSchedule');

var moment = require('moment');
var tz = require('moment-timezone');


router.get('/',periodSchedule.schedule(), function (req, res) {
    res.send(req.schedule)
 });

module.exports=router;

var db = require('../../dbconnection'); //reference of dbconnection.js
var service=require('../../models/apis/service');
var period=require('../../models/apis/period');

var functions = require('./functions/functions.js');

var moment = require('moment');
var tz = require('moment-timezone');


var periodSchedule={
    schedule:function(){
                // Declaring variables
                var periods, services, specifiedPeriod;

                //  Retrieve periods
                period.getAllperiods(function(err,rows){
                if(err)  periods = err; else  periods = rows;
                // console.log(periods)
                });


        return function(req,res,next){

             periods.some(function(val, i) {
                var isBetween = functions.timeIsBetween(/*now,*/ val.start, val.end,0);
                if(isBetween){
                    specifiedPeriod =val;
                    console.log(val)
                    return true;
                };
            });


            req.schedule =  [
                {specifiedPeriod:specifiedPeriod},
                {services:services },
            ]

        next()
        }
    },

    otherFunction:function(){
    },
}

module.exports=periodSchedule;

var db=require('../../dbconnection'); //reference of dbconnection.js

var period={

getAllperiods:function(callback){
     // return db.query("Select * from period",callback);
    return db.query(
        "select *  from periods order by id asc"
        ,callback);
    },

 getperiodById:function(id,callback){
     return db.query("select * from periods where Id=?",[id],callback);
     },

 addperiod:function(period,callback){
     return db.query("Insert into periods values(?,?,?)",[period.name,period.start,period.finish],callback);
     },

 deleteperiod:function(id,callback){
      return db.query("delete from period where Id=?",[id],callback);
     },

 updateperiod:function(id,period,callback){
      return db.query("update period set name=?,start=?,finish=? where Id=?",[period.name,period.start,period.finish,id],callback);
     }

    };
 module.exports=period;