wangyx0055 / crm-meansmixup

Mongo+Express+Angular+Node+Sails

MEANS

Mongo+Express+Angular+Node+Sails crm wedding planner example

===============

Demo Site

http://sample4.gtz.com:8001/

Slides

####https://docs.google.com/presentation/d/1HqhG2jtlsqNk3ozqesQctKLOycVpuWX8Vixy4qwp62o/edit?usp=sharing

Handout Documentation

####https://docs.google.com/document/d/1TIHCdm9PGrqLFlwZu3m1TJGZnSKb7Hk5Yic5M33gbp4/edit?usp=sharing

================================ Repos used in this project

https://github.com/DanWahlin/CustomerManagerStandard

https://github.com/fnakstad/angular-client-side-auth

https://github.com/irlnathan/activityoverlord

###Mongo Talk About Angular http://www.abington.psu.edu/about/campus-map

Additional repos and references

http://ryanlanciaux.github.io/blog/2013/06/04/learning-angularjs/

###The Sails portion of the app is structured using the following folders: ![crm-MEANS App Structure] (docs/crm-Means2.jpg))

###The AngularJS portion of the app is structured using the following folders: ![crm-MEANS App Structure] (docs/crm-Means1.jpg)

Requirements:

###You will be using Node.js/Sails Express/MongoDB...

If you don't already have Node.js on your machine install it from http://nodejs.org. You'll also need to install MongoDB from http://www.mongodb.org if you don't have it already and get it configured and running using the instructions on their site.

In the crm-MEANS directory execute 'npm install' which will all dependencies (package.json). Note: This project uses Passport and Bcrpt for Authentication and encryption. Bcrprt require Python 2.X and can be rather diffiult to install. Please follow the following wwebsites

https://npmjs.org/package/bcrypt Follow dependencies section carefully

https://github.com/TooTallNate/node-gyp/ Follow Installtion section carefully

Python (v2.7.3 recommended, v3.x.x is not supported) Windows XP/Vista/7: Microsoft Visual Studio C++ 2010 (Express version works well) For 64-bit builds of node and native modules you will also need the Windows 7 64-bit SDK If the install fails, try uninstalling any C++ 2010 x64&x86 Redistributable that you have installed first. If you get errors that the 64-bit compilers are not installed you may also need the compiler update for the Windows SDK 7.1

run npm install. If you dont have any errors your good to go

Load sample data into MongoDB by performing the following steps:

• Execute 'mongod' to start the MongoDB daemon
• Navigate to the CustomerManager directory (the one that has initMongoCustData.js in it) then execute 'mongo' to start the MongoDB shell
• Enter the following in the mongo shell to load the seed files:
• use crm
• load("initMongoUserData.js")
• load("initMongoSettingsData.js")
• load("initMongoStateData.js")

Start the Node/Express server:

• navigate to the CustomerManager/server directory then execute 'sails lift'

View the application at http://localhost:1337

Import and Convert

mongoimport --db dentalsave --collection dentoff --type csv --file Mongoexp.csv --headerline

db.dentoff.ensureIndex({Sid1:1})

Fix zipcodes after every run

Fix zipcodes 1x

db.dentoff.find().forEach( function(dentoff) { // printjson( '..'+dentoff.ZipCode + '..' + dentoff.ZipCode.length); dentoff.ZipCode= dentoff.ZipCode+'';

 if (dentoff.ZipCode.length == 4) {
   // printjson( dentoff.ZipCode + ' '+ dentoff.ZipCode.length   )
  dentoff.ZipCode='0'+dentoff.ZipCode;

  }
  if (dentoff.ZIPCODE.length == 3) {

  dentoff.ZipCode='00'+dentoff.ZipCode;    
  }
  db.dentoff.save(dentoff);

});

create geoLocation

db.dentoff.find().forEach( function(dentoff) { printjson( '..'+dentoff.ZipCode + '..' + dentoff.ZipCode.length+'====='+dentoff.LNG+','+ dentoff.LAT);

  dentoff.ziplocation= {'type': 'Point','coordinates':[dentoff.LNG,dentoff.LAT] };
 db.dentoff.save(dentoff);

});

create geoIndex

db.dentoff.ensureIndex( { "ziplocation" : "2dsphere" } )

Search geoLocation

(1 mile = 1609.04 meters. below gets all records for 3 miles) db.runCommand( { geoNear : 'dentoff' , near : { type : "Point" , coordinates: [ -73.98, 40.726 ] } , spherical : true, limit:1000, distanceMultiplier:1/1609.04, maxDistance: 1609.04*3, } )

Convert Detail Table as an embeded doc

db.po.find({PONumber : {$exists : true}}).forEach( function(obj) { db.podetail.find({PONumber: {$exists : true}}).forEach( function(objd); db.po.insert(objd); ; db.po.save(obj); } ); db.po.find({PONumber : {$exists : true}}).forEach( function(obj) { db.podetail.find({PONumber : obj.PONumber); db.po.insert(objd); ; db.po.save(obj); } );); db.po.find({PONumber : {$exists : true}}).forEach( function(obj) { db.podetail.find({PONumber : obj.PONumber)) {$exists : true}}).forEach( function(objd) db.po.insert(objd); db.po.save(obj); });

Angular Links

https://github.com/jmcunningham/AngularJS-Learning