Kevin H.A Tan kevintanhongann

## Grails: createCriteria query, group by day, on a single date field
DOMAIN CLASS (Post):
String timeDay
Date date
static mapping = {
    timeDay formula: "FORMATDATETIME(date, 'yyyy-MM-dd')" // h2 sql
    //timeMonth formula: "DATE_FORMAT(time, '%Y-%m-%d')"   // mysql sql
}

CONTROLLER:
def c = Post.createCriteria()

## share-twitter.js
// Opens a pop-up with twitter sharing dialog

var url = "http://google.com";
var text = "Replace this with your text";
window.open('http://twitter.com/share?url='+encodeURIComponent(url)+'&text='+encodeURIComponent(text), '', 'left=0,top=0,width=550,height=450,personalbar=0,toolbar=0,scrollbars=0,resizable=0');
	DOMAIN CLASS (Post):
	String timeDay
	Date date
	static mapping = {
	timeDay formula: "FORMATDATETIME(date, 'yyyy-MM-dd')" // h2 sql
	//timeMonth formula: "DATE_FORMAT(time, '%Y-%m-%d')" // mysql sql
	}

	CONTROLLER:
	def c = Post.createCriteria()
	// Opens a pop-up with twitter sharing dialog

	var url = "http://google.com";
	var text = "Replace this with your text";
	window.open('http://twitter.com/share?url='+encodeURIComponent(url)+'&text='+encodeURIComponent(text), '', 'left=0,top=0,width=550,height=450,personalbar=0,toolbar=0,scrollbars=0,resizable=0');