def clickedadd(self): try: self.nextssn = db.child("nextssn").get().val() auth.create_user_with_email_and_password(self.eid2.text(), self.randomString(8)) data2 = { "email": self.eid2.text(), "name": self.name2.text(), "address": self.addr2.text(), "phone_no": self.phone2.text(), "mngr_ssn": self.eidf, "pen_req_made": 0, "pen_req_rec": 0, "casual_bl": 10, "priv_bl": 10, "sick_bl": 10, "wfh_bl": 10 } db.child("users").child(str(self.nextssn)).set(data2) self.n.append(str(self.nextssn)) self.comboBox.addItem(str(self.nextssn)) self.nextssn = self.nextssn + 1 auth.send_password_reset_email(self.eid2.text()) db.update({"nextssn": self.nextssn}) self.label_2.setText("add successful") self.defaulttxt() except Exception: self.label_2.setText("add failed")
def clickedsumbit(self) : try: self.nextlvid=db.child("nextlvid").get().val() self.start_datef1=self.sd_2.text() self.typef1=self.typelv_cbox.currentText() self.total_daysf1=int(self.td_2.text()) self.balance=self.switch(self.typef1)-self.total_daysf1 if(self.balance>=0): if(self.typef1=="Casual leave"): self.casual_bl=self.balance elif(self.typef1=="Privilege leave"): self.priv_bl=self.balance elif(self.typef1=="Work from home"): self.wfh_bl=self.balance elif(self.typef1=="Sick leave"): self.sick_bl=self.balance else: print("Error ") self.pen_req_made1=self.pen_req_made1+1 self.pen_req_rec1=db.child("users").child(self.mngridf).child("pen_req_rec").get().val() self.pen_req_rec1=self.pen_req_rec1+1 data1 = { "users/"+self.mngridf+"/pen_req_rec":self.pen_req_rec1, "users/"+self.eidf+"/pen_req_made":self.pen_req_made1, "users/"+self.eidf+"/casual_bl": self.casual_bl, "users/"+self.eidf+"/priv_bl": self.priv_bl, "users/"+self.eidf+"/wfh_bl": self.wfh_bl, "users/"+self.eidf+"/sick_bl": self.sick_bl } data2={ "mngr_ssn":self.mngridf, "ssn": self.eidf, "start_date":self.start_datef1, "status": "pending", "total_days":self.total_daysf1, "type": self.typef1 } db.child("leaves").child(str(self.nextlvid)).set(data2) self.lvid.addItem(str(self.nextlvid)) self.nextlvid=self.nextlvid+1 db.update({"nextlvid":self.nextlvid}) db.update(data1) self.submit_status.setText("leave request submitted") self.balv.setText("") if(self.ec==0): self.ec=1 self.select1.clicked.connect(self.clickedselect1) else: print("insufficient leave balance") self.submit_status.setText("insufficient leave balance") except Exception : self.submit_status.setText("leave request failed")
def clickedaccept(self): self.pen_lvm = db.child("users").child( self.ssnf).child("pen_req_made").get().val() self.pen_lvm = self.pen_lvm - 1 self.pen_lvr = db.child("users").child( self.eidf).child("pen_req_rec").get().val() self.pen_lvr = self.pen_lvr - 1 print("00000000000000000000000000000000000000000000000") data1 = { "leaves/" + self.lvids + "/status": "accepted", "users/" + self.ssnf + "/pen_req_made": self.pen_lvm, "users/" + self.eidf + "/pen_req_rec": self.pen_lvr } db.update(data1) self.sta.setText("Request Accepted") self.delitem(self.lvids)
def __init__(self, message1): self.eidf = message1 print("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa") self.leave_by_ssn = db.child("leaves").order_by_child( "mngr_ssn").equal_to(self.eidf).get() self.leave_by_pen = db.child("leaves").order_by_child( "status").equal_to("pending").get() try: self.a1 = self.leave_by_ssn.val() self.a2 = self.leave_by_pen.val() self.a = set(self.a1.keys()) & set(self.a2.keys()) print(self.a) self.ec = 1 except Exception: self.a = {} self.ec = 0 self.n1 = [key for key in self.a] print(self.n1)
def clickedselect1(self): if (self.count != 0): self.lvids = self.lvid_cbox.currentText() print(self.lvids) self.leave_by_id = db.child("leaves").child(self.lvids).get() self.v = self.leave_by_id.val() print(self.v) self.start_datef = self.v['start_date'] self.total_daysf = self.v['total_days'] self.typef = self.v['type'] self.ssnf = self.v['ssn'] self.enamef = db.child("users").child( self.ssnf).child("name").get().val() print("00000000000000000000000000000000000000") self.sd.setText(self.start_datef) self.td.setText(str(self.total_daysf)) self.ty.setText(self.typef) self.empname.setText(self.enamef) self.empid.setText(self.ssnf)
def __init__(self,message1,message2): self.eidf=message1 self.mngridf=message2 print("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa") self.leave_by_ssn=db.child("leaves").order_by_child("ssn").equal_to(self.eidf).get() try: self.a1=self.leave_by_ssn.val() self.ec=1 except Exception: self.a1={} self.ec=0 self.n=[key for key in self.a1.keys()] print(self.n) self.user_by_ssn=db.child("users").child(self.eidf).get() self.a2=self.user_by_ssn.val() self.priv_bl=self.a2['priv_bl'] self.sick_bl=self.a2['sick_bl'] self.wfh_bl=self.a2['wfh_bl'] self.casual_bl=self.a2['casual_bl'] self.pen_req_made1=self.a2['pen_req_made']
def __init__(self, message1): self.eidf = message1 print("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa") self.user_by_mngr_ssn = db.child("users").order_by_child( "mngr_ssn").equal_to(self.eidf).get() try: self.a1 = self.user_by_mngr_ssn.val() self.ec = 1 except Exception: self.a1 = {} self.ec = 0 print(self.a1) self.n = [key for key in self.a1.keys()]
def clickedselect(self): self.eids = self.comboBox.currentText() print(self.eids) self.users_by_key = db.child("users").child(self.eids).get() self.a = self.users_by_key.val() print(self.a) self.addf = self.a['address'] self.namef = self.a['name'] self.phonef = self.a['phone_no'] self.email = self.a['email'] self.name1.setText(self.namef) self.eid1.setText(self.email) self.phone1.setText(self.phonef) self.addr1.setText(self.addf) self.editstatus.setText("")
def clickedselect1(self): self.lvidf=self.lvid.currentText() print(self.lvidf) self.users_by_lvid=db.child("leaves").child(self.lvidf).get() self.a=self.users_by_lvid.val() print(self.a) self.start_datef=self.a['start_date'] self.statusf=self.a['status'] self.total_daysf=self.a['total_days'] self.typef=self.a['type'] print("000000000000000000000000000000000000") self.sd_1.setText(self.start_datef) self.status.setText(self.statusf) self.td_1.setText(str(self.total_daysf)) self.typelv.setText(self.typef)
def clickedreject(self): self.pen_lvm1 = db.child("users").child( self.ssnf).child("pen_req_made").get().val() self.pen_lvm1 = self.pen_lvm1 - 1 self.pen_lvr1 = db.child("users").child( self.eidf).child("pen_req_rec").get().val() self.pen_lvr1 = self.pen_lvr1 - 1 self.casual_bl = db.child("users").child( self.ssnf).child("casual_bl").get().val() self.priv_bl = db.child("users").child( self.ssnf).child("priv_bl").get().val() self.wfh_bl = db.child("users").child( self.ssnf).child("wfh_bl").get().val() self.sick_bl = db.child("users").child( self.ssnf).child("sick_bl").get().val() print("111111111111111111111111111111111111111111111111111") if (self.typef == "Casual leave"): self.casual_bl = self.casual_bl + self.total_daysf elif (self.typef == "Privilege leave"): self.priv_bl = self.priv_bl + self.total_daysf elif (self.typef == "Work from home"): self.wfh_bl = self.wfh_bl + self.total_daysf elif (self.typef == "Sick leave"): self.sick_bl = self.sick_bl + self.total_daysf else: print("Error ") data2 = { "users/" + self.eidf + "/pen_req_rec": self.pen_lvr1, "users/" + self.ssnf + "/pen_req_made": self.pen_lvm1, "users/" + self.ssnf + "/casual_bl": self.casual_bl, "users/" + self.ssnf + "/priv_bl": self.priv_bl, "users/" + self.ssnf + "/wfh_bl": self.wfh_bl, "users/" + self.ssnf + "/sick_bl": self.sick_bl, "leaves/" + self.lvids + "/status": "rejected", } db.update(data2) self.sta.setText("Request rejected") self.delitem(self.lvids)