var express = require('express');
var cassandra = require('cassandra-driver');
var path = require('path');
var async = require('async');

var app = express();
//Connect to the cluster
var cassandraClient = new cassandra.Client({contactPoints: ['localhost'], keyspace: 'demo'});

var port = 8080;

var router = express.Router();

var stateDictionary = {
  "AL":"alabama",
  "AK":"alaska",
  "AS":"americanSamoa",
  "AZ":"arizona",
  "AR":"arkansas",
  "CA":"california",
  "CO":"colorado",
  "CT":"connecticut",
  "DE":"delaware",
  "DC":"districtOfColumbia",
  "FM":"federatedStatesOfMicronesia",
  "FL":"florida",
  "GA":"georgia",
  "GU":"guam",
  "HI":"hawaii",
  "ID":"idaho",
  "IL":"illinois",
  "IN":"indiana",
  "IA":"iowa",
  "KS":"kansas",
  "KY":"kentucky",
  "LA":"louisiana",
  "ME":"maine",
  "MH":"marshallIslands",
  "MD":"maryland",
  "MA":"massachusetts",
  "MI":"michigan",
  "MN":"minnesota",
  "MS":"mississippi",
  "MO":"missouri",
  "MT":"montana",
  "NE":"nebraska",
  "NV":"nevada",
  "NH":"newHampshire",
  "NJ":"newJersey",
  "NM":"newMexico",
  "NY":"newYork",
  "NC":"northCarolina",
  "ND":"northDakota",
  "MP":"northernMarianaIslands",
  "OH":"ohio",
  "OK":"oklahoma",
  "OR":"oregon",
  "PW":"palau",
  "PA":"pennsylvania",
  "PR":"puertoRico",
  "RI":"rhodeIsland",
  "SC":"southCarolina",
  "SD":"southDakota",
  "TN":"tennessee",
  "TX":"texas",
  "UT": "utah",
  "VT": "vermont",
  "VI": "virginIslands",
  "VA": "virginia",
  "WA": "washington",
  "WV": "westVirginia",
  "WI": "wisconsin",
  "WY": "wyoming"
};

function getNewInfoFormat(OldStateInfoFormat)
{
  var citymap = {
    alabama: {
      center: {lat: 32.806671, lng: -86.791130},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    alaska: {
      center: {lat: 61.370716, lng: -152.404419},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    arizona: {
      center: {lat: 33.729759, lng: -111.431221},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    arkansas: {
      center: {lat: 34.969704, lng: -92.373123},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    california: {
      center: {lat: 36.116203, lng: -119.681564},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    colorado: {
      center: {lat: 39.059811, lng: -105.311104},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    connecticut: {
      center: {lat: 41.597782, lng: -72.755371},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    delaware: {
      center: {lat: 39.318523, lng: -75.507141},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    districtOfColumbia: {
      center: {lat: 38.897438, lng:   -77.026817},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    florida: {
      center: {lat: 27.766279, lng: -81.686783},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    georgia: {
      center: {lat: 33.040619, lng: -83.643074},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    hawaii: {
      center: {lat: 21.094318, lng: -157.498337},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    idaho: {
      center: {lat: 44.240459, lng: -114.478828},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    illinois: {
      center: {lat: 40.349457, lng: -88.986137},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    indiana: {
      center: {lat: 39.849426, lng: -86.258278},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    iowa: {
      center: {lat: 42.011539, lng: -93.210526},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    kansas: {
      center: {lat: 38.526600, lng: -96.726486},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    kentucky: {
      center: {lat: 37.668140, lng: -84.670067},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    louisiana: {
      center: {lat: 31.169546, lng: -91.867805},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    maine: {
      center: {lat: 44.693947, lng: -69.381927},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    maryland: {
      center: {lat: 39.063946, lng: -76.802101},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    massachusetts: {
      center: {lat: 42.230171, lng: -71.530106},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    michigan: {
      center: {lat: 43.326618, lng: -84.536095},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    minnesota: {
      center: {lat: 45.694454, lng: -93.900192},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    mississippi: {
      center: {lat: 32.741646, lng: -89.678696},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    missouri: {
      center: {lat: 38.456085, lng: -92.288368},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    montana: {
      center: {lat: 46.921925, lng: -110.454353},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    nebraska: {
      center: {lat: 41.125370, lng: -98.268082},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    nevada: {
      center: {lat: 38.313515, lng: -117.055374},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    newHampshire: {
      center: {lat: 43.452492, lng: -71.563896},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    newJersey: {
      center: {lat: 40.298904, lng: -74.521011},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    newMexico: {
      center: {lat: 34.840515, lng: -106.248482},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    newYork: {
      center: {lat: 42.165726, lng: -74.948051},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    northCarolina: {
      center: {lat: 35.630066, lng: -79.806419},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    northDakota: {
      center: {lat: 47.528912, lng: -99.784012},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    ohio: {
      center: {lat: 40.388783, lng: -82.764915},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    oklahoma: {
      center: {lat: 35.565342, lng: -96.928917},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    oregon: {
      center: {lat: 44.572021, lng: -122.070938},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    pennsylvania: {
      center: {lat: 40.590752, lng: -77.209755},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    rhodeIsland: {
      center: {lat: 41.680893, lng: -71.511780},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    southCarolina: {
      center: {lat: 33.856892, lng: -80.945007},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    southDakota: {
      center: {lat: 44.299782, lng: -99.438828},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    tennessee: {
      center: {lat: 35.747845, lng: -86.692345},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    texas: {
      center: {lat: 31.054487, lng: -97.563461},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    utah: {
      center: {lat: 40.150032, lng: -111.862434},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    vermont: {
      center: {lat: 44.045876, lng: -72.710686},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    virginia: {
      center: {lat: 37.769337, lng: -78.169968},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    washington: {
      center: {lat: 47.400902, lng: -121.490494},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    westVirginia: {
      center: {lat: 38.491226, lng: -80.954453},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    wisconsin: {
      center: {lat: 44.268543, lng: -89.616508},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    },
    wyoming: {
      center: {lat: 42.755966, lng: -107.302490},
      codeSt: OldStateInfoFormat["state_code"],
      errors: OldStateInfoFormat["error_count"],
      session: OldStateInfoFormat["session_count"]
    }
  };
  var stateName = stateDictionary[OldStateInfoFormat["state_code"]];
  return citymap[stateName];
}

function getNewCityFormat(OldCityFormat)
{
	console.log(OldCityFormat["city_name"]);
	console.log(OldCityFormat);
	console.log(OldCityFormat.city_name);
	console.log(OldCityFormat["state_code"]);
  var geocoder =  new google.maps.Geocoder();
  var cityLat = 0;
  var cityLng = 0;
  geocoder.geocode( { 'address': OldCityFormat["city_name"] + ', us'}, function(results, status) {
    cityLat = results[0].geometry.location.lat();
    cityLng = results[0].geometry.location.lng();
console.log("lat" + cityLat);
console.log("lng"+ cityLng); 
  });

  return {
          country: OldCityFormat["city_name"],
          center: {lat:  cityLat, lng: cityLng},
          errors: OldCityFormat["error_count"],
          session: OldCityFormat["session_count"]
        }
}

router.get('/api/allData', function(req, res) {
    var query = "select * from state_network_statistic";
    cassandraClient.execute(query, function(err, result) {
        var models = {};

        for(var i = 0; i<result.rows.length; i++) {
            var model = {};
            var row = result.rows[i];
            models[stateDictionary[row["state_code"]]] =  getNewInfoFormat(row);

}
        res.setHeader('Access-Control-Allow-Origin','*');
        res.json(models);
    });
});

router.get('/api/getCitiesForState', function(req, res) {
	var stCode  =  req.query["stCode"];
   	cassandraClient.execute("select * from state_network_statistic where state_code = ?",[req.query["stCode"]], function(err, result) {
        var models = [];
        for(var i = 0; i < result.rows.length; i++) {
            var row = result.rows[i];
console.log(result.rows[i]);
console.log(row);        
models[i] =  getNewCityFormat(row);
        }

        res.setHeader('Access-Control-Allow-Origin','*');
        res.json(models);
    });
});

router.get('/', function(req, res) {
    res.setHeader('Access-Control-Allow-Origin','*');
    res.sendFile(path.join(__dirname + '/index4.html'));
});

app.use(router);
app.listen(port);