Talk:Collins Foundation Final Report - Revision history

Rfs: database changes

2007-02-08T21:29:04Z

database changes

2007-02-07T23:33:31Z

2007-02-07T01:29:21Z

2007-02-02T02:33:17Z

2007-02-02T02:21:55Z

2007-02-01T02:27:54Z

2007-01-26T01:36:38Z

2007-01-26T01:05:41Z

2007-01-25T02:24:24Z

2007-01-25T02:23:27Z

← Older revision		Revision as of 21:29, 8 February 2007
Line 54:		Line 54:
	fgdb=# SELECT extract( year from created ) as year, count(*) FROM sales		fgdb=# SELECT extract( year from created ) as year, count(*) FROM sales
	GROUP BY 1 ORDER BY 1;		GROUP BY 1 ORDER BY 1;
		+
		+	== database changes ==
		+
		+	the database queries are from the old fgdb database. in the future they can be used as a guide to write new queries against the fgdb.rb database which has a different structure. most of these queries should be pretty easy to convert.
		+
		+	[[User:Rfs\|RfS]] 13:29, 8 February 2007 (PST)

← Older revision		Revision as of 23:33, 7 February 2007
Line 1:		Line 1:
		+	Note:
		+	I have placed an Open Office version of this (with minor spelling/grammar edits on ryukin at /usr/local/fgstaff/grantwriting)
		+
		+
	'''this is the formula used for generating numbers relating to volunteers & their hours'''		'''this is the formula used for generating numbers relating to volunteers & their hours'''

← Older revision		Revision as of 01:29, 7 February 2007
Line 43:		Line 43:
	http://www.tump.com/~lmoore/logs/freegeek/		http://www.tump.com/~lmoore/logs/freegeek/
	(only gathers for 1 year)		(only gathers for 1 year)
		+
		+	==Donors & Store Transactions==
		+	fgdb=# SELECT extract( year from created ) as year, count(*) FROM
		+	donation GROUP BY 1 ORDER BY 1;
		+
		+	fgdb=# SELECT extract( year from created ) as year, count(*) FROM sales
		+	GROUP BY 1 ORDER BY 1;

← Older revision		Revision as of 02:33, 2 February 2007
Line 39:		Line 39:
	*Operational Income = total income - c4k donations - online donations - grants - unsolicited grants - employee matching		*Operational Income = total income - c4k donations - online donations - grants - unsolicited grants - employee matching
	*Overall Income = total income		*Overall Income = total income
		+
		+	==Website Traffic==
		+	http://www.tump.com/~lmoore/logs/freegeek/
		+	(only gathers for 1 year)

@@ Line 1: / Line 1: @@
 '''this is the formula used for generating numbers relating to volunteers & their hours'''
@@ Line 25: / Line 22: @@
-''should I include any recycling data?  Is it really pertinent at all?  how abotu "no info for 2006"''
+: Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST)
-: Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST)

← Older revision		Revision as of 02:27, 1 February 2007
Line 1:		Line 1:
		+	TO DO
		+	-correlate $$ numbers to descriptions
		+
	'''this is the formula used for generating numbers relating to volunteers & their hours'''		'''this is the formula used for generating numbers relating to volunteers & their hours'''

@@ Line 16: / Line 16: @@
 ORDER BY 1;
+==Total hours by year:==
 ''should I include any recycling data?  Is it really pertinent at all?''
 : Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST)

@@ Line 1: / Line 1: @@
-* include here the criteria used for pulling numbers out of database
+'''this is the formula used for generating numbers relating to volunteers & their hours'''
-fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1;
+=="Build" volunteer count by year:==
-<pre>
+fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid )
-jobtype         | count
+FROM memberhour WHERE jobtype IN ('AdvancedTesting', 'Build',
-----------------+-------
+'Enterprise', 'Evaluation', 'Laptops', 'Quality', 'Repair', 'Sorting',
-Admin           |  1875
+'Teaching') GROUP BY 1 ORDER BY 1;
-'''I will use the following in reference to build:
+=="Adoption" volunteer count by year:==
-   (with note that a certain overlap exists with build for MISC)'''
-*AdvancedTesting
+fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid )
-*Build
+FROM memberhour WHERE jobtype IN ('DataEntry', 'FrontDesk', 'Misc',
-*Enterprise
+'Printers', 'Receiving', 'Recycling', 'Testing', 'Adoption') GROUP BY 1
-*Evaluation
+ORDER BY 1;
-*Laptops
-*Quality

@@ Line 3: / Line 3: @@
 fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1;
-jobtype     | count
+<pre>
------------------+-------
+jobtype         | count
 ----------------+-------
 Admin           |  1875
 Adoption        |  5191
@@ Line 34: / Line 34: @@
 Testing         |  4435
 (28 rows)
 '''I will use the following in reference to adoption: