{"inputs":"timesheet","query":[{"map":{"language":"javascript","source":"
function(v) {
  var entry = JSON.parse(v.values[0].data);
  return [entry];
}
"}},{"reduce":{"language":"javascript","source":"
function(values, arg){
  var startDay = 1412139600000;
     var endDay = 1414817999000;
     var offset = -18000000;
     var dayInMilliseconds = 86400000;
     var userList = {}, projectList = {}, clientList = {}, months = {};
     var counter = 0;
  function getHours(entry) {

       var resultValue = 0;
       var weekValues = [entry.monTime, entry.tueTime, entry.wedTime, entry.thuTime, entry.friTime, entry.satTime, entry.sunTime];
       for(var i =0;i<7;i++){
         var currentDay = entry.dateWork + (dayInMilliseconds * (i+1)) + offset;
         if( currentDay >= startDay && currentDay <= endDay){
           resultValue += weekValues[i]
         }
       }

       return  resultValue
     }
  for (var i = 0; i < values.length; i++) {

       var entry = values[i];
       if (entry != null) {
         var hours = getHours(entry);
         userList[entry.userId] = (userList[entry.userId] || 0) + hours;
         projectList[entry.projectId] = (projectList[entry.projectId] || 0) + hours;
       }
     }



  return [values];
}
"}}]}