index.js

var express = require('express');
var ejs = require('ejs');
var app = module.exports = express.createServer();
var sanitize = require('validator').sanitize;

var pg = require('pg').native;
var connectionString = process.env.DATABASE_URL || 'postgres://postgres@localhost:5432/beardspotter'

var client = new pg.Client(connectionString);
client.connect();

var imageXOffSet = 0;
var imageYOffSet = 0;
var imageWidth = 280;
var imageHeight = 280;
var YPixelsToRadiansRatio = (imageHeight) / (2 * Math.PI);

/* With help from:
   - http://stackoverflow.com/questions/2651099/convert-long-lat-to-pixel-x-y-on-a-given-picure
   - http://mathworld.wolfram.com/MercatorProjection.html
   - https://github.com/mapbox/node-sphericalmercator/blob/b900d1ea7a6ca656d3c85c3bfb4f0fe625bfd4bf/sphericalmercator.js#L43
*/
var latToPixels = function(lat) {
  var f = Math.sin(lat * (Math.PI / 180));
  return ((imageHeight / 2) + 0.5 * Math.log((1 + f) / (1 - f)) * -1 * YPixelsToRadiansRatio) + imageYOffSet
}

var lonToPixels = function(lon) {
  return (((lon + 180) / 360) * imageWidth) + imageXOffSet
}

app.set('view engine', 'ejs');

app.configure('production', function(){
  app.use(express.favicon(__dirname + '/public/favicon.ico'));
  app.use(express.static(__dirname + '/public', { maxAge: 31557600000 })); /* One year */
  app.use(express.bodyParser());
});

app.configure('development', function(){
  app.use(express.favicon(__dirname + '/public/favicon.ico'));
  app.use(express.static(__dirname + '/public', { maxAge: 31557600000 })); /* One year */
  app.use(express.bodyParser());
  app.use(express.errorHandler({ dumpExceptions: true, showStack: true }));
});

app.get('/', function(req, res){
  res.render('index');
});

app.get('/sighting', function(req, res) {
  var query = client.query('SELECT * FROM sighting ORDER BY posted DESC LIMIT 20');
  var sightings = [];
  query.on('row', function(row) {
    row.beards = JSON.parse(row.beards);
    // Dirty way to make sure we don't get empty rows.
    // Should clean this up on input.
    for (var i in row.beards) {
      if (row.beards.hasOwnProperty(i) && row.beards[i] > 0) {
        if (row.latitude != '' && row.longitude != '') {
          row.top = latToPixels(parseFloat(row.latitude));
          row.left = lonToPixels(parseFloat(row.longitude));
        }
        sightings.push(row);
        break;
      }
    }
  });
  query.on('end', function() {
    var humanReadable = {
      'old-goat': 'Old Goat',
      'full': 'Full',
      'van-dyke': 'Van Dyke',
      'van-winkle': 'Van Winkle',
      'goatee': 'Goatee',
      'chops': 'Chops',
      'dapper': 'Dapper',
      'chin-strap': 'Chin Strap',
      'dad': 'Dad'
    };
    res.render('sighting', {
      locals: {
        sightings: sightings,
        humanReadable: humanReadable
      }
    });
  });
});

app.post('/sighting', function(req, res) {
  var location = { latitude: null, longitude: null };
  var total = 0;
  var accepted = [
    'old-goat',
    'full',
    'van-dyke',
    'van-winkle',
    'goatee',
    'chops',
    'dapper',
    'chin-strap',
    'dad'
  ];
  var beards = {};

  for (var key in req.body.beard) {
    if (accepted.indexOf(key) >= 0 && parseInt(req.body.beard[key]) > 0) {
      total += parseInt(req.body.beard[key]);
      beards[key] = parseInt(req.body.beard[key]);
    }
  }
  if (req.body.location && req.body.location.latitude && req.body.location.longitude) {
    location.latitude = req.body.location.latitude;
    location.longitude = req.body.location.longitude;
  }
  if (total > 0) {
    var placename = ''; // Reverse geocode: http://maps.google.com/maps/api/geocode/json?latlng=49.5,-70.5&sensor=false
    client.query('INSERT INTO sighting (ip, posted, nickname, placename, latitude, longitude, beards) VALUES($1, $2, $3, $4, $5, $6, $7)', [req.connection.remoteAddress, new Date(), sanitize(req.body.nickname).xss(), sanitize(placename).xss(), sanitize(location.latitude).toFloat(), sanitize(location.longitude).toFloat(), beards]);
  }
  var query = client.query('SELECT * FROM sighting ORDER BY posted DESC');
  var sightings = [];
  query.on('row', function(row) {
    row.beards = JSON.parse(row.beards);
    // Dirty way to make sure we don't get empty rows.
    // Should clean this up on input.
    for (var i in row.beards) {
      if (row.beards.hasOwnProperty(i) && row.beards[i] > 0) {
        if (row.latitude != '' && row.longitude != '') {
          row.top = latToPixels(parseFloat(row.latitude));
          row.left = lonToPixels(parseFloat(row.longitude));
        }
        sightings.push(row);
        break;
      }
    }
  });
  query.on('end', function() {
    var humanReadable = {
      'old-goat': 'Old Goat',
      'full': 'Full',
      'van-dyke': 'Van Dyke',
      'van-winkle': 'Van Winkle',
      'goatee': 'Goatee',
      'chops': 'Chops',
      'dapper': 'Dapper',
      'chin-strap': 'Chin Strap',
      'dad': 'Dad'
    };
    res.render('sighting', {
      locals: {
        total: total,
        location: location,
        sightings: sightings,
        humanReadable: humanReadable
      }
    });
  });
});

// 404.
app.get('/*', function(req, res){
  res.render('404', {status: 404 });
});

var port = process.env.PORT || 4000;
app.listen(port, function() {
  console.log("Listening on " + port);
});