#!/usr/bin/python
# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'studentpage.ui'
#
# Created: Tue Jul 28 15:14:11 2015
#      by: PyQt4 UI code generator 4.11.3
# Authors: Gaurav, Devashish Yadav Y13 Hall-2

from PyQt4 import QtCore, QtGui
import MySQLdb
import datetime
from openpyxl import Workbook
logs = open('juicecenter.log','a')
data = []
wb = Workbook()
global lastamount
lastamount =0
try:
	db = MySQLdb.connect("localhost","root","tiger","juicecenter")
	cursor = db.cursor()
except MySQLdb.Error as e:
	logs.write(time.asctime( time.localtime(time.time()) ) + " : "+str(e)+"\n")


try:
    _fromUtf8 = QtCore.QString.fromUtf8
except AttributeError:
    def _fromUtf8(s):
        return s

try:
    _encoding = QtGui.QApplication.UnicodeUTF8
    def _translate(context, text, disambig):
        return QtGui.QApplication.translate(context, text, disambig, _encoding)
except AttributeError:
    def _translate(context, text, disambig):
        return QtGui.QApplication.translate(context, text, disambig)

#########################################

class Ui_Admin_corner(object):
    def setupUi(self, Admin_corner):
        Admin_corner.setObjectName(_fromUtf8("Admin_corner"))
        Admin_corner.resize(800, 600)
        self.centralwidget = QtGui.QWidget(Admin_corner)
        self.centralwidget.setObjectName(_fromUtf8("centralwidget"))
        self.label = QtGui.QLabel(self.centralwidget)
        self.label.setGeometry(QtCore.QRect(160, 110, 41, 21))
        self.label.setObjectName(_fromUtf8("label"))
        self.label_2 = QtGui.QLabel(self.centralwidget)
        self.label_2.setGeometry(QtCore.QRect(380, 110, 67, 17))
        self.label_2.setObjectName(_fromUtf8("label_2"))