server.js

const express = require('express');
const app = express();
const bodyParser= require('body-parser');
const MongoClient = require('mongodb').MongoClient 
const passport = require('passport');
const session = require('cookie-session');
const GoogleStrategy = require('passport-google-oauth20').Strategy;



app.set('view engine', 'ejs')
app.use(bodyParser.urlencoded({ extended: true }));
app.use(express.static('public'));
app.use(session({
  secret : "Our little Secret Here",
  resave : false,
  saveUninitialized : false
}));
app.use(passport.initialize());
app.use(passport.session());
app.listen(process.env.PORT || 3000, function(){
  console.log("Express server listening on port %d in %s mode", this.address().port, app.settings.env);
});

MongoClient.connect('mongodb+srv://ja123:ja123@cluster0.k3ytz.mongodb.net/ja-articles?retryWrites=true&w=majority'
,{
  useUnifiedTopology: true
}).then(client => {
    console.log('Connected to Database');
    const db = client.db('ja-articles');
    const articlesCollection = db.collection('article');
    const authorCollection = db.collection('author');
    const commentCollection = db.collection('comment')
  // app.listen(5000, ()=>{
  //       console.log("server's up")
  // }); 

  passport.serializeUser(function(user, done) {
    done(null, user);
  });

  passport.deserializeUser(function(user, done) {
    done(null, user);
  });

  passport.use(new GoogleStrategy({
    clientID        : '986762757676-2pq35rlfhh2t1u17gcgliquuuq6vgfn9.apps.googleusercontent.com',
    clientSecret    : '3Os8QiwahxzJsJNk7VhrFB4F',
    callbackURL     : 'https://journalismbody-iitbbs.herokuapp.com/auth/google/callback',
    userProfileURL  : 'https://www.googleapis.com/oauth2/v3/userinfo'
    },
    function(token, refreshToken, profile, done) {
      console.log('HI');
      db.collection('users').findOne({ googleid : profile.id } , function(err, user) { 
          if (err)
              return done(err);
          else if (user) {
              console.log('user');
              return done(null, user);
          } 
          else {
              console.log('ELSE');
              db.collection('users').insertOne({
              "googleid" : profile.id,
              "token" : token,
              "name"  : profile.displayName,
              "email" : profile.emails[0].value,
              "photo" : profile.photos[0].value
              })
              console.log(profile.emails[0].value);
              return done(null, user);
          }
      })
    }
  ));  

  app.get('/', (req,res)=>{
    db.collection('author').find().toArray() 
    .then(result3=>{
      db.collection('article').find().toArray()
      .then(result2=>{res.render('index',{article:result2, author:result3, user: req.user, isLogged : req.isAuthenticated()})})
      .catch(error=>console.log(error+"1"));
    }).catch(error=>console.log(error+"2"));
   
  });
  

  app.get('/studentlife', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results => {
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Student Life", author:result2, query : "studentlife", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  });

  app.get('/career', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results => {
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Career", author:result2, query : "career", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  });

  app.get('/alumni', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results=>{
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Alumni", author:result2, query : "alumni", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  });

  app.get('/scitech', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results=>{
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Science and Technology", author:result2, query : "scitech", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  });

  app.get('/cult', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results=>{
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Cultural", author:result2, query : "cult", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  });

  app.get('/sports', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results=>{
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"Sports", author:result2, query : "sports", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  }); 

  app.get('/generalchampionship', (req,res)=>{
    db.collection('article').find().toArray()
    .then(results=>{
      db.collection('author').find().toArray() 
      .then(result2=>{
        res.render('category',{article:results, cat:"General Championship", author:result2, query : "GC", user: req.user, isLogged: req.isAuthenticated()})
      })
    })
    .catch(error => console.error(error))  
  }); 
 
  app.get('/articles/:id', (req,res)=>{
   
    db.collection('comment').find().toArray()
    .then(result1=> { db.collection('author').find().toArray() 
      .then(result3=>{
        db.collection('article').findOne({id:req.params.id.toString()})
        .then(result2=>{
          db.collection('article').find().toArray()
          .then(result=>{
            res.render('articles',{article:result, result:result2, id:req.params.id , comment:result1 , author:result3, user: req.user, isLogged : req.isAuthenticated()})
          })
          console.log(result1)
        })
        .catch(error=>console.log(error+"1"));
      }).catch(error=>console.log(error+"2"));

    }
    )
    .catch(error=>console.log(error+"3"));
    
    
    
 
  })

  

app.get('/auth/google', passport.authenticate('google', { scope: ['profile', 'email'] }));

app.get('/auth/google/callback', passport.authenticate('google', { failureRedirect: '/auth/google' }),
  function(req, res) {
    res.redirect('/');
  }
);
  
 
  
  app.get('/logout', function(req, res){
    req.logout();
    res.redirect('/');
  });

  app.get('/contact', (req,res)=>{
    db.collection('author').find().toArray() 
    .then(result3=>{
      db.collection('article').find().toArray()
      .then(result2=>{res.render('contact',{article:result2, author:result3, user: req.user, isLogged : req.isAuthenticated()})})
      .catch(error=>console.log(error+"1"));
    }).catch(error=>console.log(error+"2"));
   
  });

  app.get('/aboutus', (req,res)=>{
    db.collection('author').find().toArray() 
    .then(result3=>{
      db.collection('article').find().toArray()
      .then(result2=>{res.render('about',{article:result2, author:result3, user: req.user, isLogged : req.isAuthenticated()})})
      .catch(error=>console.log(error+"1"));
    }).catch(error=>console.log(error+"2"));
   
  });
  
  // //to add an article
  app.get('/articles',(req,res)=>{
    //     db.collection('article').find().toArray()
    // .then(results => {
      //res.render('index')
      res.sendFile(__dirname + '/index.html');
      //})
    //.catch(error => console.error(error))
  });

  //to add an author
  app.get('/authors',(req,res)=>{
    //     db.collection('article').find().toArray()
    // .then(results => {
      //res.render('index')
      res.sendFile(__dirname + '/addAuthor.html');
      //})
    //.catch(error => console.error(error))
  });
  

//   app.post('/articles', (req,res)=>{ 
//       articlesCollection.insertOne(req.body)
//           .then(result=>res.redirect('/'))
//           .catch(error=>console.log(error)); 
//   })
//   app.post('/authors', (req,res)=>{ 
//     authorCollection.insertOne(req.body)
//         .then(result=>res.redirect('/'))
//         .catch(error=>console.log(error));
//   });

  
    app.post('/comments/:id',(req,res)=>{
      commentCollection.insertOne({comment: req.body.comment,_id: req.body._id, name:req.user.name, article_id:req.params.id, date:req.body.startdate, photo:req.user.photo })
        .then(result=>{console.log(req.user);res.redirect('/articles/'+req.params.id)})
        .catch(error=>console.log(error));

    })
    app.get('/author/:id',(req,res)=>{
      db.collection('article').find().toArray()
      .then(result2=>{
        res.render('author.ejs',{ article: result2, user: req.user, isLogged : req.isAuthenticated()});
      })
    })

  })
  .catch(error => console.error(error));