Merge pull request #1 from prashantsinalkar/master

Added Python workshop stats

2 files changed, 64 insertions, 13 deletions

diff --git a/website/models.py b/website/models.py
index b0776e6..7afce12 100644
--- a/website/models.py
+++ b/website/models.py
@@ -67,3 +67,29 @@ class TextBox(models.Model):
 
 	def __unicode__(self):
 		return self.textbox_name
+"""
+Models from fossee_new Database created using inspectdb
+Use it with the "fossee_in" database eg:using("fossee_in")
+These models are used only for django orm reference.
+"""
+class FOSSEEStats(models.Model):
+	w_id = models.IntegerField(unique=True, primary_key=True)
+	foss_name = models.CharField(max_length=500)
+	type = models.CharField(max_length=50)
+	w_name = models.CharField(max_length=500)
+	body = models.TextField()
+	no_of_participant	 = models.IntegerField(max_length=5)
+	event_link = models.TextField()
+	startdate = models.DateTimeField()
+	starttime = models.TimeField()
+	enddate = models.DateTimeField()
+	endtime = models.TimeField()
+	venue = models.CharField(max_length=500)
+	street = models.CharField(max_length=500)
+	country = models.CharField(max_length=100)
+	state = models.CharField(max_length=100)
+	city = models.CharField(max_length=100)
+	pincode = models.IntegerField(default=0)
+	class Meta:
+		db_table = 'workshop'
+
diff --git a/website/views.py b/website/views.py
index 5bf6790..c0a61e1 100644
--- a/website/views.py
+++ b/website/views.py
@@ -1,5 +1,6 @@
 from django.http import HttpResponse
 from django.shortcuts import render, render_to_response, get_object_or_404
+from website.models import FOSSEEStats
 
 from website.models import Nav, Page, Block
 
@@ -29,16 +30,40 @@ def get_blocks():
     return blocks
 
 def dispatcher(request, permalink=''):
-    if permalink == '':
-        permalink = 'home'
-
-    page = get_object_or_404(Page, permalink=permalink)
-    blocks = get_blocks()
-    context = {
-		'page': page,
-		'navs': blocks['navs'],
-		'sidebar': blocks['sidebar'],
-		'footer': blocks['footer'],
-		'permalink': permalink
-	}
-    return render(request, 'website/templates/page.html', context)
+	if permalink == 'python-workshops':
+		blocks = get_blocks()
+		rows = FOSSEEStats.objects.using('fossee_in').filter(foss_name='Python', type ='Workshop').order_by('-w_id')
+		python_wokshop_page_content = Page.objects.get(permalink='python-workshops-page')
+
+		context = {
+			'page' : python_wokshop_page_content,
+			'navs': blocks['navs'],
+			'sidebar': blocks['sidebar'],
+			'footer': blocks['footer'],
+			'permalink': permalink,
+			'obj' : rows,
+		}
+
+	if permalink == '' or permalink == 'home' :
+		permalink = 'home'
+		page = get_object_or_404(Page, permalink=permalink)
+		blocks = get_blocks()
+		context = {
+			'page': page,
+			'navs': blocks['navs'],
+			'sidebar': blocks['sidebar'],
+			'footer': blocks['footer'],
+			'permalink': permalink
+		}
+
+	if permalink != 'home' and permalink != 'python-workshops':
+		page = get_object_or_404(Page, permalink=permalink)
+		blocks = get_blocks()
+		context = {
+			'page': page,
+			'navs': blocks['navs'],
+			'sidebar': blocks['sidebar'],
+			'footer': blocks['footer'],
+			'permalink': permalink
+		}
+	return render(request, 'website/templates/page.html', context)