From cc8ee8cf7817f188e6b189b35bdc63f98025ee2c Mon Sep 17 00:00:00 2001
From: yomguy <yomguy@parisson.com>
Date: Sun, 15 Apr 2012 22:48:09 +0200
Subject: [PATCH] fix XLS rows

---
 teleforma/htdocs/css/teleforma.css     |  1 -
 teleforma/templates/telemeta/base.html |  3 +--
 teleforma/views.py                     | 17 +++++++++--------
 3 files changed, 10 insertions(+), 11 deletions(-)

diff --git a/teleforma/htdocs/css/teleforma.css b/teleforma/htdocs/css/teleforma.css
index b416cc5d..6bfab122 100644
--- a/teleforma/htdocs/css/teleforma.css
+++ b/teleforma/htdocs/css/teleforma.css
@@ -109,7 +109,6 @@ a img { border: none; }
     margin:0px auto;
     padding-top: 0.6em;
     padding-bottom: 0.5em;
-
     }
 
 #logo a, #logo a:hover { border: none; background: transparent; }
diff --git a/teleforma/templates/telemeta/base.html b/teleforma/templates/telemeta/base.html
index e93fc18d..b5b929ef 100644
--- a/teleforma/templates/telemeta/base.html
+++ b/teleforma/templates/telemeta/base.html
@@ -39,8 +39,6 @@
 <script type='text/javascript'>var CURRENT_USER_NAME=undefined;</script>
 {% endif %}
 
-<script type='text/javascript'>window.scrollTo(0, 1);</script>
-
 {% endblock %}
 
 {% block extra_javascript %}{% endblock %}
@@ -176,4 +174,5 @@ alt="logo" />
 {% endblock analytics %}
 
 </body>
+<script type='text/javascript'>window.scrollTo(0, 1);</script>
 </html>
diff --git a/teleforma/views.py b/teleforma/views.py
index e7f3ad46..7212bae9 100755
--- a/teleforma/views.py
+++ b/teleforma/views.py
@@ -193,13 +193,13 @@ class UsersTrainingView(UsersView):
 
 class UsersXLSExport(object):
 
-    first_row = 2
+    first_row = 1
 
-    def export_user(self, count, user):
+    def export_user(self, counter, user):
         student = Student.objects.filter(user=user)
         if student:
             student = Student.objects.get(user=user)
-            row = self.sheet.row(count)
+            row = self.sheet.row(counter + self.first_row)
             row.write(0, user.last_name)
             row.write(1, user.first_name)
             row.write(9, user.email)
@@ -219,8 +219,10 @@ class UsersXLSExport(object):
                 row.write(12, profile.city)
                 row.write(13, profile.telephone)
                 row.write(14, profile.date_added.strftime("%d/%m/%Y"))
-
             print 'exported: ' + user.first_name + ' ' + user.last_name + ' ' + user.username
+            return counter + 1
+        else:
+            return counter
 
     @method_decorator(permission_required('is_superuser'))
     def export(self, request):
@@ -233,7 +235,7 @@ class UsersXLSExport(object):
         row.write(3, 'FORMATION')
         row.write(4, 'PROC')
         row.write(5, 'Ecrit Spe')
-        row.write(6, unicode('Oral Spe'))
+        row.write(6, 'Oral Spe')
         row.write(7, 'ORAL 1')
         row.write(8, 'ORAL 2')
         row.write(9, 'MAIL')
@@ -242,10 +244,9 @@ class UsersXLSExport(object):
         row.write(12, 'VILLE')
         row.write(13, 'TEL')
         row.write(14, "Date d'inscription")
-        count = self.first_row
+        counter = 1
         for user in self.users:
-            self.export_user(count, user)
-            count += 1
+            counter = self.export_user(counter, user)
         response = HttpResponse(mimetype="application/vnd.ms-excel")
         response['Content-Disposition'] = 'attachment; filename=users.xls'
         self.book.save(response)
-- 
2.39.5