Esempio n. 1
0
 def updateDatabase(self, firstBoot=False):
     if firstBoot:
         root = Tk()
         root.withdraw()
         tkMessageBox.showinfo(
             "Veritabani guncellemesi", "Veritabani simdi guncellenecek. Bu islem yaklasik 1-2 dakika surecektir."
         )
     else:
         ans = tkMessageBox.askquestion(
             "Veritabani guncellemesi",
             "Veritabanini simdi guncellemek istiyor musunuz?. Bu islem yaklasik 1 dakika surecektir.",
         )
         if ans == "no":
             return
     self.db.close()
     updater = ITUSIS_Parser()
     updater.getClasses()
     self.conn = sqlite3.connect("classdb.sqlite")
     self.db = self.conn.cursor()
     if not firstBoot:
         depCodeList = [""]
         for code in self.db.execute("select distinct Depcode from classes"):
             depCodeList.append(code[0])
         for i in range(0, 10):
             self.depCodeSpinner[i]["values"] = depCodeList
Esempio n. 2
0
 def updateDatabase(self):
     self.clearAndChangeStateOfComboBoxes()
     self.updateThread = ITUSIS_Parser()
     self.updateThread.updateStatusBarSignal.connect(self.updateStatusBar)
     self.updateThread.start()
Esempio n. 3
0
class ITU_Programci():
    def __init__(self):
        self.app = QtWidgets.QApplication(sys.argv)
        self.ui = ui.Ui_MainWindow()
        self.ui.show()
        self.finalizeWidgets()
        self.initDbConnection()
        self.connectHandlers()
        self.cache = {}
        self.count=0
        sys.exit(self.app.exec_())
        return

    def initDbConnection(self):
        if not os.path.isfile('classdb.sqlite'):
            self.updateDatabase()
            self.conn=sqlite3.connect('classdb.sqlite',check_same_thread=False)
            self.db=self.conn.cursor()
        else:
            self.conn=sqlite3.connect('classdb.sqlite',check_same_thread=False)
            self.db=self.conn.cursor()
            self.initDepCodeComboBoxes()

    def updateDatabase(self):
        self.clearAndChangeStateOfComboBoxes()
        self.updateThread = ITUSIS_Parser()
        self.updateThread.updateStatusBarSignal.connect(self.updateStatusBar)
        self.updateThread.start()

    def updateStatusBar(self,depCode):
        if depCode == 'end':
            self.ui.statusbar.showMessage('Guncelleme bitti.')
            self.clearAndChangeStateOfComboBoxes()
            self.initDepCodeComboBoxes()
        else:
            self.ui.statusbar.showMessage('%s guncelleniyor.' % depCode)

    def initDepCodeComboBoxes(self):
        depCodeList=['']
        for code in self.db.execute('select distinct Depcode from classes'):
            depCodeList.append(code[0])
        for i in range(0,10):
            obj = self.ui.findChild(QtWidgets.QComboBox,'depCodeComboBox_%d' % i)
            obj.clear()
            obj.addItems(depCodeList)

    def connectHandlers(self):
        name = ['depCodeComboBox_%d','classCodeComboBox_%d','availClassComboBox_%d']
        handlers = [self.depCodeSelectedHandler,self.classCodeSelectedHandler,self.classSelectedHandler]
        for i in range(0,10):
            for j in range(0,3):
                obj = self.ui.findChild(QtWidgets.QComboBox, name[j] % i)
                obj.currentIndexChanged.connect(handlers[j])

        self.ui.action_Reset.triggered.connect(self.reset)
        self.ui.action_Update_database.triggered.connect(self.updateDatabase)
        self.ui.action_Save.triggered.connect(self.save)
        self.ui.action_Load.triggered.connect(self.load)
        self.ui.actionJS_kodunu_kopyala.triggered.connect(self.generateJS)
        self.ui.createSchedulesButton.clicked.connect(self.createPossibleSchedules)
        self.ui.scheduleCombobox.currentIndexChanged.connect(self.scheduleSelectedHandler)

    def depCodeSelectedHandler(self):
        senderComboBox = self.ui.sender()
        index = senderComboBox.objectName().split('_')[1]
        depCode = senderComboBox.currentText()
        nextComboBox = self.ui.findChild(QtWidgets.QComboBox,'classCodeComboBox_%s' % index)

        if depCode == '':
            nextComboBox.clear()
            return

        self.db.execute('select distinct Code from classes where Depcode=\'%s\'' % depCode)
        classCodeList = ['']
        for elem in self.db.fetchall():
            classCodeList.append(elem[0])

        nextComboBox.clear()
        nextComboBox.addItems(classCodeList)

    def classCodeSelectedHandler(self):
        senderComboBox = self.ui.sender()
        index = senderComboBox.objectName().split('_')[1]
        classCode = senderComboBox.currentText()
        nextComboBox = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%s' % index)

        if classCode == '':
            nextComboBox.clear()
            return

        self.db.execute('select CRN , Title , Inst  ,Build , Day ,Time, Restr,ClassTime  from classes where Code=\'%s\'' % classCode)
        availClassList =['']
        for elem in self.db.fetchall():
            if not self.checkIfMeetsCriteria(elem):
                continue
            availClassList.append('%s :: %s :: %s :: %s :: %s :: %s' % (elem[0],elem[1],elem[2],elem[4],elem[5],elem[3]))

        nextComboBox.clear()
        if availClassList == ['']:
            availClassList = ['Kriterlerinize uygun grup yok']
        nextComboBox.addItems(availClassList)

    def checkIfMeetsCriteria(self,classInfo):
        studentDepCode = self.ui.depCodeInput.text()
        if self.ui.useDepCodeCheckbox.isChecked() and studentDepCode not in classInfo[6]:
            return False
        classTime = classInfo[7]
        freeDays=[]
        for i in range(0,5):
            obj = self.ui.findChild(QtWidgets.QCheckBox,'freeDaysCheckbox_%s' % i)
            if obj.isChecked():
                freeDays.append(i)
        for block in classTime.split(','):
            if block == 'Undefined':
                continue
            start_end = block.split('-')
            start = int(start_end[0])
            end = int(start_end[1])
            if math.floor(start/28) in freeDays:
                return False
            if self.ui.hourStartInput.text() != '' and self.ui.hourEndInput.text() != '' :
                if (start%28)/2+8 < int(self.ui.hourStartInput.text()) or  (end%28)/2+8 >= int(self.ui.hourEndInput.text()):
                    return False

        unwantedBuildList = self.ui.unwantedBuildInput.text()
        for building in classInfo[3].split(','):
            if building in unwantedBuildList:
                return False

        return True

    def classSelectedHandler(self):
        senderComboBox = self.ui.sender()
        crnList = []
        for i in range(0,10):
            availClassComboBox = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%d' % i)
            classInfo = availClassComboBox.currentText()
            if classInfo == '' or classInfo == 'Kriterlerinize uygun grup yok':
                continue
            CRN = classInfo[:5]
            crnList.append(CRN)

        response = self.isValidSchedule(crnList)
        if response[0]:
            self.fillSchedule(response[1],response[2])
        else:
            senderComboBox.setCurrentIndex(0)
            msgbox = QtWidgets.QMessageBox(self.ui)
            msgbox.setText('Sectiginiz ders baska bir dersinizle cakismaktadir!')
            msgbox.setWindowTitle('Hata!')
            msgbox.show()
            senderComboBox.setCurrentIndex(0)

    def scheduleSelectedHandler(self):
        index = self.ui.scheduleCombobox.currentIndex()
        if index <=0:
            return
        self.fillClassInfo(self.scheduleList[index-1])

    def isValidSchedule(self,crnList):
        timeSlots=['' for x in range(0,140)]
        colorArr=['' for x in range(0,140)]
        i=0
        for CRN in crnList:
            if CRN in self.cache:
                query = self.cache[CRN]
            else:
                self.db.execute(('select ClassTime,Code from classes where CRN=\'%s\'' % CRN))
                query = self.db.fetchone()
                self.cache[CRN] = query

            for block in query[0].split(','):
                if block == 'Undefined':
                    continue
                start_end = block.split('-')
                for j in range(int(start_end[0]),int(start_end[1])):
                    if timeSlots[j] == '':
                        timeSlots[j] = query[1]
                        colorArr[j] = rand_col[i]
                    else:
                        return (False,None,None)
            i+=1
        return (True,timeSlots,colorArr)

    def fillSchedule(self,timeSlots,colorArr):
        for i in range(0,70):
            item = self.ui.schedule.item(i%14,math.floor(i/14))
            item.setText('')
            item.setBackground(QtGui.QColor('white'))

        for i in range(0,140):
            item = self.ui.schedule.item(math.floor(i/2)%14,math.floor(i/28))
            if timeSlots[i] !='':
                if item.text() != '' :
                    if item.text() != timeSlots[i]:
                        item.setText(item.text()+' / '+timeSlots[i])
                else:
                    item.setText(timeSlots[i])
                item.setBackground(colorArr[i])

    def save(self):
        classList=[]
        fileName = QtWidgets.QFileDialog.getSaveFileName(self.ui,'Kayıt dosyasını sec');
        if fileName[0] == '':
            return
        saveFile = open(fileName[0],'w')
        for i in range(0,10):
            classEntry = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%d' % i).currentText()
            if classEntry != '':
                classList.append(classEntry[:5])
        saveFile.write(','.join(classList))
        saveFile.close()

    def load(self):
        fileName = QtWidgets.QFileDialog.getOpenFileName(self.ui,'Kayıt dosyasını sec');
        if fileName[0] == '':
            return
        saveFile = open(fileName[0],'r')
        crnList = saveFile.read().replace('\n','').split(',')
        self.fillClassInfo(crnList)

    def generateJS(self):
        jsTemplate = "javascript:var crn=[%s];for(var i=0;i<crn.length;i++){var d=document.getElementById(\"crn_id\"+(i+1));d.value=crn[i];}void(0);"
        classList=[]
        for i in range(0,10):
            classEntry = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%d' % i).currentText()
            if classEntry != '':
                classList.append(classEntry[:5])
        cb = QtWidgets.QApplication.clipboard()
        cb.clear(mode=cb.Clipboard )
        cb.setText(jsTemplate % ",".join(classList), mode=cb.Clipboard)

    def fillClassInfo(self,crnList):
        for i in range(0,10):
            obj = self.ui.findChild(QtWidgets.QComboBox,'depCodeComboBox_%d' % i)
            obj.setCurrentIndex(0)

        i=0
        for CRN in crnList:
            self.db.execute('select Depcode,Code from classes where CRN=%s' % CRN)
            query = self.db.fetchone()
            if query == None:
                continue
            obj = self.ui.findChild(QtWidgets.QComboBox,'depCodeComboBox_%d' % i)
            obj.setCurrentText(query[0])
            obj = self.ui.findChild(QtWidgets.QComboBox,'classCodeComboBox_%d' % i)
            obj.setCurrentText(query[1])
            obj = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%d' % i)
            obj.setCurrentIndex(obj.findText(CRN,flags=QtCore.Qt.MatchStartsWith))
            i+=1

    def reset(self):
        name = ['depCodeComboBox_%d','classCodeComboBox_%d','availClassComboBox_%d']
        for i in range(0,10):
            for j in range(0,3):
                obj = self.ui.findChild(QtWidgets.QComboBox, name[j] % i)
                if j == 0:
                    obj.setCurrentIndex(0)
                else:
                    obj.clear()

    def clearAndChangeStateOfComboBoxes(self):
        name = ['depCodeComboBox_%d','classCodeComboBox_%d','availClassComboBox_%d']
        for i in range(0,10):
            for j in range(0,3):
                obj = self.ui.findChild(QtWidgets.QComboBox, name[j] % i)
                obj.clear()
                obj.setEnabled(not obj.isEnabled())

    def finalizeWidgets(self):
        #TableWidget
        width = 0
        for i in range(self.ui.schedule.columnCount()):
            width += self.ui.schedule.columnWidth(i)
        width += self.ui.schedule.verticalHeader().sizeHint().width()
        width += self.ui.schedule.verticalScrollBar().sizeHint().width()/6
        height=0
        for i in range(self.ui.schedule.rowCount()):
            height += self.ui.schedule.rowHeight(i)
        height += self.ui.schedule.horizontalHeader().sizeHint().height()
        height += self.ui.schedule.horizontalScrollBar().sizeHint().height()/6
        self.ui.schedule.resize(width,height)

        #Otomatik program olusturma bolumu
        self.ui.depCodeInput.setText('BLGE')
        self.ui.hourStartInput.setText('8')
        self.ui.hourEndInput.setText('19')
        self.ui.unwantedBuildInput.setText('MKB,ISB,MMB,GDB')
        #MainWindow
        #self.ui.setHeight(self.ui.schedule.geometry().bottom()+40)

    def createPossibleSchedules(self,checked,crnList=[],timeSlots=[0 for x in range(0,70)],index=0):
        if index==10:
            self.scheduleList.append(crnList)
            self.ui.scheduleCombobox.addItem('%d. opsiyon' % self.ui.scheduleCombobox.count())
            return
        elif index==0:
            self.scheduleList = []
            self.ui.scheduleCombobox.clear()
            self.ui.scheduleCombobox.addItem('')
        comboBox = self.ui.findChild(QtWidgets.QComboBox,'availClassComboBox_%d' % index)
        if comboBox.count() <= 1:
            self.createPossibleSchedules(checked,crnList,timeSlots,index+1)
        else:
            if comboBox.currentIndex() > 0:
                CRN = comboBox.currentText()[:5]
                if not self.isValidSchedule(crnList+[CRN])[0]:
                    return
                self.createPossibleSchedules(checked,crnList+[CRN],timeSlots,index+1)
            else:
                for i in range(1,comboBox.count()):
                    CRN = comboBox.itemText(i)[:5]
                    if not self.isValidSchedule(crnList+[CRN])[0]:
                        continue
                    self.createPossibleSchedules(checked,crnList+[CRN],timeSlots,index+1)