def checkAdmin(self): db = CreateConnection()["users"] result = db.find_one({"user_role": {"$eq": "admin"}}) if result: self.clearForm() else: return None
def checkUsername(self): if self.username is not None: db = CreateConnection()["users"] res = db.find_one({"username": {"$eq": self.username}}) if res is not None: return True else: return False
def checkEmail(self): if self.email is not None: db = CreateConnection()["users"] res = db.find_one({"email": {"$eq": self.email}}) if res is not None: return True else: return False
def vardiya_degistir(yeniSorumlu, degisecek_vardiya): global x print(yeniSorumlu) print(type(yeniSorumlu)) print(degisecek_vardiya) user = CreateConnection()["users"] vardiya = CreateConnection()["vardiya"] eskiSorumlu = vardiya.find_one({ "vardiya_adi": degisecek_vardiya })["vardiya_sorumlu"] print(eskiSorumlu) if len(eskiSorumlu) > 20: x = user.update_one({ "_id": ObjectId(eskiSorumlu) }, { "$set": {"vardiya": "null"} }) print(x) y = user.update_one({ "_id": ObjectId(yeniSorumlu) }, { "$set": {"vardiya": degisecek_vardiya} }) print(y) z = vardiya.update_one({ "vardiya_adi": degisecek_vardiya }, { "$set": {"vardiya_sorumlu": yeniSorumlu} }) print(z)
def checkEmail(email): if email is not None: db = CreateConnection()["users"] result = db.find_one({ "email": { "$eq": email } }) print(f'checkEmail {result}') if result is not None: return True else: return False else: print("Username gelmedi")
def checkUserName(username): if username is not None: db = CreateConnection()["users"] result = db.find_one({ "username": { "$eq": username } }) print(f'checkUserName {result}') if result is not None: return True else: return False else: print("Username gelmedi")
def addUserToSuperVisorShift(self, data): from Controllers.SuperVisor import SuperVisor user = SuperVisor() # getSupervisor2(data[0]) shiftCollection = CreateConnection()["shift"] res = shiftCollection.find_one_and_update({"name": { "$eq": data[-1] }}, {'$set': { "supervisor": user._id }}) if res: return True else: return False
def save(self): collection = CreateConnection()["users"] self.user_role = "supervisor" print(self.user_role) response = collection.insert_one({ "full_name": self.full_name, "username": self.username, "password": self.password, "email": self.email, "user_role": self.user_role, "imagePath": self.imagePath + '/' }) if response is not None: return True else: return False
def getInformationShift(vardiya_adi): if not vardiya_adi: return False else: db = CreateConnection()["vardiya"].find_one({ "vardiya_adi": vardiya_adi }) return db
def getAllSuperVisor(): users = CreateConnection()["users"].find( {"user_role": { "$eq": "supervisor" }}) if users is not None: return list(users) else: return False
def Login(self, username, password, userType=False): db = CreateConnection()["users"] if userType: result = db.find_one({ "username": {"$eq": username}, "password": {"$eq": password}, "user_role": {"$eq": "admin"} }) if result: return result else: return False else: result = db.find_one({ "username": {"$eq": username}, "password": {"$eq": password} }) if result: return result else: return False
def editSupervisorShift(id, vardiya): user = CreateConnection()["users"].find_one_and_update( {"_id": { "$eq": id }}, {"$set": { 'vardiya': vardiya }}) if user is not None: return True else: return False
def getSupervisor(self): user = CreateConnection()["users"].find_one({ "username": { "$eq": self.username }, "password": { "$eq": self.password }, "user_role": { "$eq": "admin" } }) return user
def isciKontrol(self): isciler = CreateConnection()["isciler"].find_one( {'TcNo': { "$eq": self.ui.txt_TcNo.text() }}) if isciler is not None: return False else: tcNo = self.ui.txt_TcNo.text() self.imagePath = self.home + tcNo print(self.imagePath) self.createFolder(self.imagePath) return True
def getSupervisor(self): print(self.username) user = CreateConnection()["users"].find_one( {"username": { "$eq": self.username }}) print(user) print(user.get('user_role')) self.id = user.get('_id') self.full_name = user.get('full_name') self.user_role = user.get('user_role') self.phone = user.get('phone') self.email = user.get('email') self.vardiya = user.get('vardiya')
def addWorkerToShift(self, tcNo): db = CreateConnection()["vardiya"].find_one( {"vardiya_adi": self.ui.cmb_Vardiyas.currentText()})['vardiya_iscileri'] idx = CreateConnection()['isciler'].find_one({"TcNo": tcNo})["_id"] db.append(idx) CreateConnection()['vardiya'].update_one( {"vardiya_adi": self.ui.cmb_Vardiyas.currentText()}, {"$set": { "vardiya_iscileri": db }})
def addShift(self, eskiVardiya, YeniVardiya): # TODO: vardiyalar tablsounda eski vardiya durumunu sil # TODO: vardiyalar tablosuna işçiyi ekle # TODO: işçide vardiya durumunu güncelle print("Eski Vardiya ", eskiVardiya) print(f'Yeni Vardiya', YeniVardiya) print(self.id) db = CreateConnection()["vardiya"] isciler = db.find_one({"vardiya_adi": eskiVardiya})['vardiya_iscileri'] yeniVardiya = db.find_one({"vardiya_adi": YeniVardiya})['vardiya_iscileri'] # if eskiVardiya != YeniVardiya: if self.id in isciler: print("eski tablo güncelleme") isciler.remove(self.id) print("isciler") print("") db.update_one({"vardiya_adi": eskiVardiya}, {"$set": { "vardiya_iscileri": isciler }}) print("1x") if self.id not in yeniVardiya: print("yeni tablo güncelleme") yeniVardiya.append(self.id) db.update_one({"vardiya_adi": YeniVardiya}, {"$set": { "vardiya_iscileri": yeniVardiya }}) print("2x") if self.vardiya != YeniVardiya: print() self.vardiya = YeniVardiya self.collection.update_one({"_id": self.id}, {"$set": { "vardiya": self.vardiya }}) return True
def save(self): sql = { "full_name": self.full_name, "username": self.username, "password": self.password, "email": self.email, "phone": self.phone, "user_role": self.user_role } print(sql) try: db = CreateConnection() res = db["users"].insert_one(sql) if res: print(f'{self.full_name} user is created') return True else: return False except Exception as err: print(err)
def __init__(self, tcNo=None): super().__init__() self.collection = CreateConnection()["isciler"] if tcNo is not None: self.tcNo = tcNo self.getWorker()
class Worker(IWorker): def __init__(self, tcNo=None): super().__init__() self.collection = CreateConnection()["isciler"] if tcNo is not None: self.tcNo = tcNo self.getWorker() def save(self): # TODO: TCKNO - Adı Soyadı - Vardiyası print(self.full_name) print("test") res = self.collection.insert_one({ "TcNo": self.tcNo, "full_name": self.full_name, "vardiya": self.vardiya, "user_role": self.user_role, "imagePath": self.imagePath + "/" }) if res is not None: print(f'{self.full_name} user is created') return True else: return False def edit(self): res = self.collection.find_one_and_update({"_id": ObjectId(self.id)}, { '$set': { "TcNo": self.tcNo, "full_name": self.full_name, "vardiya": self.vardiya } }) if res: return True else: return False def addShift(self, eskiVardiya, YeniVardiya): # TODO: vardiyalar tablsounda eski vardiya durumunu sil # TODO: vardiyalar tablosuna işçiyi ekle # TODO: işçide vardiya durumunu güncelle print("Eski Vardiya ", eskiVardiya) print(f'Yeni Vardiya', YeniVardiya) print(self.id) db = CreateConnection()["vardiya"] isciler = db.find_one({"vardiya_adi": eskiVardiya})['vardiya_iscileri'] yeniVardiya = db.find_one({"vardiya_adi": YeniVardiya})['vardiya_iscileri'] # if eskiVardiya != YeniVardiya: if self.id in isciler: print("eski tablo güncelleme") isciler.remove(self.id) print("isciler") print("") db.update_one({"vardiya_adi": eskiVardiya}, {"$set": { "vardiya_iscileri": isciler }}) print("1x") if self.id not in yeniVardiya: print("yeni tablo güncelleme") yeniVardiya.append(self.id) db.update_one({"vardiya_adi": YeniVardiya}, {"$set": { "vardiya_iscileri": yeniVardiya }}) print("2x") if self.vardiya != YeniVardiya: print() self.vardiya = YeniVardiya self.collection.update_one({"_id": self.id}, {"$set": { "vardiya": self.vardiya }}) return True def delete(self): res = self.collection.find_one_and_delete({'_id': ObjectId(self.id)}) if res: return True else: return False def getWorker(self): isci = self.collection.find_one({"TcNo": self.tcNo}) print(isci) self.id = isci['_id'] self.tcNo = isci['TcNo'] self.full_name = isci['full_name'] self.vardiya = isci['vardiya'] self.user_role = isci['user_role'] self.imagePath = isci['imagePath'] def getAllWorker(self): return list(self.collection.find())
from bson import ObjectId from Controllers.Worker import Worker from Database.DataBaseConnection import CreateConnection from Controllers.CommonMethods import CommonMethods test = CreateConnection()["isciler"] def getWorker2(idNo): collection = CreateConnection()["isciler"] isci = collection.find_one({"_id": idNo}) return isci def getVardiya(vardiyaAdi): collection = CreateConnection()["vardiya"] vardiya = collection.find_one({"vardiya_adi": vardiyaAdi})['vardiya_iscileri'] return vardiya data = getVardiya("Sabah") isciler = [] for i in data: isciler.append(CommonMethods.getWorker(i)) print(isciler) print(type(isciler)) print(len(isciler)) # from datetime import date
def getSupervisor2(_id): user = CreateConnection()["users"].find_one( {"_id": { "$eq": ObjectId(_id) }}) return user
def getVardiya(vardiyaAdi): collection = CreateConnection()["vardiya"] vardiya = collection.find_one({"vardiya_adi": vardiyaAdi})['vardiya_iscileri'] return vardiya
def getWorker2(idNo): collection = CreateConnection()["isciler"] isci = collection.find_one({"_id": idNo}) return isci
def getWorker(idNo): return CreateConnection()["isciler"].find_one({"_id": idNo})