1 files changed, 0 insertions, 223 deletions
diff --git a/invoice/graph/graphs.py b/invoice/graph/graphs.py
deleted file mode 100755
index b59b7e1..0000000
--- a/invoice/graph/graphs.py
+++ /dev/null
@@ -1,223 +0,0 @@
-#!/usr/bin/python
-# -*- coding: utf-8 -*-
-import cairoplot, datetime, sqlite3, time
-
-def TortendiagramUser():
-	data = {}
-	now = int(time.time())
-
-	query = "SELECT users.id, SUM(memberprice) FROM users, purchases purch, prices \
-			WHERE users.id = purch.user AND purch.product = prices.product AND \
-			purch.timestamp > ? AND purch.timestamp < ? AND prices.valid_from = \
-			(SELECT valid_from FROM prices WHERE product = purch.product AND \
-			valid_from < purch.timestamp ORDER BY valid_from DESC LIMIT 1) \
-			GROUP BY users.id"
-
-	connection = sqlite3.connect('shop.db')
-	c = connection.cursor()
-	c.execute(query, (0, now))
-	for row in c:
-		data["%d (%d.%d Euro)" %(row[0], row[1] / 100, row[1] % 100)] = row[1]
-	c.close()
-
-	cairoplot.pie_plot("tortendiagram", data, 640, 480)
-
-def BalkendiagramUserRanking():
-	data = {}
-	names = []
-	now = int(time.time())
-
-	query = "SELECT firstname, lastname, SUM(memberprice) FROM users, purchases purch, prices \
-			WHERE users.id = purch.user AND purch.product = prices.product AND \
-			purch.timestamp > ? AND purch.timestamp < ? AND prices.valid_from = \
-			(SELECT valid_from FROM prices WHERE product = purch.product AND \
-			valid_from < purch.timestamp ORDER BY valid_from DESC LIMIT 1) \
-			GROUP BY users.id"
-
-	connection = sqlite3.connect('shop.db')
-	c = connection.cursor()
-	c.execute(query, (0, now))
-	for row in c:
-		data["%s %s (%d.%d Euro)" % (row[0], row[1], row[2] / 100, row[2] % 100)] = row[2]
-	c.close()
-
-	count=0
-	sorted_data = []
-	for key, value in sorted(data.iteritems(), key=lambda (k,v): (v,k), reverse=True):
-		sorted_data.append(value)
-		names.append(key)
-		count+=1
-		if count >= 10:
-			break
-
-	cairoplot.horizontal_bar_plot("ranking", sorted_data, 640, 480, y_labels = names, rounded_corners = True, grid = True)
-
-def TortendiagramProduct():
-	data = {}
-
-	connection = sqlite3.connect('shop.db')
-	c = connection.cursor()
-	c.execute("SELECT products.name, SUM(1) FROM products, purchases " +
-			  "WHERE products.id = purchases.product GROUP BY products.id")
-	for row in c:
-		data[row[0]] = row[1]
-	c.close()
-
-	cairoplot.pie_plot("tortendiagram2", data, 640, 480)
-
-def Lagerbestand(category):
-	data = {}
-
-	day = 24 * 60 * 60
-	interval = 21
-	now = int(time.time())
-
-	dates = []
-	dt = datetime.datetime.fromtimestamp(now)
-	dates.append("%04d-%02d-%02d" % (dt.year, dt.month, dt.day))
-
-	colors = [
-		"black",
-		"red",
-		"green",
-		"blue",
-		"orange",
-		(117/255.0, 255/255.0, 20/255.0),
-		(216/255.0, 20/255.0, 255/255.0),
-		(204/255.0, 153/255.0, 0/255.0),
-		(0/255.0, 204/255.0, 255/255.0),
-		(153/255.0, 77/255.0, 0/255.0),
-		(128/255.0, 0/255.0, 128/255.0),
-		(204/255.0, 0/255.0, 0/255.0),
-		(0/255.0, 0/255.0, 102/255.0),
-		"yellow",
-	]
-
-	connection = sqlite3.connect('shop.db')
-	c = connection.cursor()
-	query = ""
-	name = ""
-	numbers = []
-
-	if category == "getraenke":
-		query = "name LIKE '%Mate%'  OR name LIKE '%Apfelsaft%' OR name LIKE '%Fritz%' OR name LIKE '%Coca Cola%' OR name LIKE '%Vilsa%' OR name = 'Fanta' OR name = 'Sprite'"
-	elif category == "haribo":
-		query = "name LIKE '%Haribo%'"
-	elif category == "haribo_total":
-		query = "name LIKE '%Haribo%'"
-		name = "Haribo"
-		interval = 4*7
-	elif category == "riegel":
-		query = "name LIKE '%KitKat%' OR name = 'Lion' OR name LIKE '%Snickers%' OR name = 'Mars' OR name = 'Twix' OR name = 'Duplo'"
-	elif category == "other":
-		query = "name LIKE '%Gouda%' OR name LIKE '%Chipsfrisch%' OR name LIKE '%Sesamsticks%'"
-	elif category == "schoko":
-		query = "name = 'Ü-Ei' OR name LIKE '%Tender%' OR name = 'Knoppers' OR name LIKE '%m&m%'"
-	elif category == "balisto":
-		query = "name LIKE '%Balisto%'"
-	else:
-		return
-
-	c.execute("SELECT name, amount FROM products WHERE (%s) AND amount > 0" % query);
-	for row in c:
-		data[row[0]] = [int(row[1])]
-
-	current = now
-	currentid = 1
-	while current > (now - interval * day):
-		for k, v in data.iteritems():
-			data[k].append(v[-1])
-
-		dt = datetime.datetime.fromtimestamp(current - day)
-		dates.append("%04d-%02d-%02d" % (dt.year, dt.month, dt.day))
-
-		c.execute("SELECT name, SUM(restock.amount) FROM products, restock WHERE products.id = restock.product AND timestamp > ? AND timestamp < ? GROUP BY name", (current - day, current));
-		for row in c:
-			if row[0] in data:
-				data[row[0]][currentid] -= row[1]
-		c.execute("SELECT name, SUM(1) FROM products, purchases WHERE products.id = purchases.product AND timestamp > ? AND timestamp < ? GROUP BY name", (current - day, current));
-		for row in c:
-			if row[0] in data:
-				data[row[0]][currentid] += row[1]
-
-		current -= day
-		currentid += 1
-
-	for k, v in data.iteritems():
-		data[k].reverse()
-	dates.reverse()
-
-	c.close()
-
-	result = {}
-	if name == "":
-		result = data
-	else:
-		result[name] = [0]*interval;
-		for product in data:
-			for i in range(0,interval):
-				result[name][i] += data[product][i]
-
-	cairoplot.dot_line_plot("lagerbestand_%s" % category, result, 640, 480, series_colors = colors, x_labels = dates, y_title = "Anzahl", axis=True, grid=True, series_legend = True)
-
-def TotalPurchasesPerDay():
-	day = 24 * 60 * 60
-	now = int(time.time())
-
-	colors = [
-		"black",
-	]
-
-	dates = []
-	dt = datetime.datetime.fromtimestamp(now)
-	dates.append("%04d-%02d-%02d" % (dt.year, dt.month, dt.day))
-
-	connection = sqlite3.connect('shop.db')
-	c = connection.cursor()
-	query = "SELECT SUM(memberprice) FROM purchases purch, prices WHERE purch.product = prices.product AND purch.user > 0 AND purch.timestamp > ? AND purch.timestamp < ? AND prices.valid_from = (SELECT valid_from FROM prices WHERE product = purch.product AND valid_from < purch.timestamp ORDER BY valid_from DESC LIMIT 1)"
-
-	current = now
-	data = []
-	while current > (now - 42 * day):
-		c.execute(query, (current-day, current))
-
-		dt = datetime.datetime.fromtimestamp(current - day)
-		dates.append("%04d-%02d-%02d" % (dt.year, dt.month, dt.day))
-
-		for row in c:
-			amount = row[0] or 0
-			data.append(int(amount)/100.0)
-
-		current -= day
-
-	data.reverse()
-	dates.reverse()
-
-	c.execute(query, (0, now))
-	total = c.fetchone()[0]
-
-	dt = datetime.datetime.fromtimestamp(now)
-	start = dt.replace(hour = 8, minute = 0, second = 0, day = 16)
-	if start > dt:
-		start = start.replace(month = start.month - 1)
-	c.execute(query, (start.strftime("%s"), now))
-	month = c.fetchone()[0]
-
-	c.close()
-
-	print "Total sales: %.2f€" % (total / 100.0)
-	print "Total sales this month: %.2f€" % (month / 100.0)
-	print "Average per day (last 42 days): %.2f€" % (sum(data)/len(data))
-
-	cairoplot.dot_line_plot("total_sales_per_day", data, 640, 480, series_colors = colors, x_labels = dates, y_title = "Euro", axis=True, grid=True)
-
-TortendiagramUser()
-BalkendiagramUserRanking()
-
-TortendiagramProduct()
-
-data = [ "getraenke", "haribo", "haribo_total", "riegel", "other", "schoko", "balisto" ]
-for x in data:
-	Lagerbestand(x)
-
-TotalPurchasesPerDay()