def __init__(self): super(RetrieveAvailableHospitalDoctors, self).__init__() self.dataStaffDemographics = model0.StaffDemographics() self.dataUsers = model0.Users() self.dataStaffDemographicsUsersRel = model0.StaffDemographicsUsersRel() self.dataStaffState = model0.StaffState() self.dataStaffLeaveStatus = model0.StaffLeaveStatus() self.dataStaffCurrentAccountState = model0.StaffCurrentAccountState() self.dataDepartmentStaffRel = model0.DepartmentStaffRel() self.dataDeparment = model0.Department() self.message = [] self.idPrefix = accountManagementHelper.GenerateIdPrefix() raw_data0 = [] raw_data00 = self.dataUsers.getAllUsers() for a, b, c, d, e in raw_data00: if d != "System Administrator" and d != "Laboratorist" and d != "Clinician" and d != "Pharmacist" and d != "Principle Nurse Officer" and d != "Head Pharmacy" and d != "Store Personnel" and d != "Head Clinic" and d != "Head Laboratory" and d != "Head Front Desk" and d != "Head Store" and d != "Senior Principle Nurse Officer" and d != "Human Resource" and d != "Nurse" and d != "This is list should be extended as development proceeds": raw_data11 = self.dataStaffDemographicsUsersRel.getStaffDemographicsUsersRelByUsername( username=a) for f, g in raw_data11: check0 = self.dataStaffState.getStaffState(staff_id=f) if len(check0) == 0: raw_data0.append([a, b, c, d, e]) for a, b, c, d, e in raw_data0: messageCrude = [] raw_data1 = self.dataStaffDemographicsUsersRel.getStaffDemographicsUsersRelByUsername( username=a) for f, g in raw_data1: raw_data2 = self.dataStaffDemographics.getStaffDemographicsByStaffId( staff_id=f) for h, i, j, k, l, m, n, o, p, q, r, s, t, u, v in raw_data2: messageCrude.append(self.idPrefix.idPrefix + "-" + h) messageCrude.append(i) messageCrude.append(v) raw_data3 = self.dataStaffLeaveStatus.getStaffLeaveStatus( staff_id=h) if len(raw_data3) == 0: messageCrude.append("Account Not Activated") else: for w, x in raw_data3: if x == 'on': messageCrude.append("On Leave") else: raw_data4 = self.dataStaffCurrentAccountState.getStaffCurrentAccountState( staff_id=h) for y, z, aa in raw_data4: messageCrude.append(z) raw_data5 = self.dataDepartmentStaffRel.getDepartmentStaffRelByStaffId( staff_id=h) if len(raw_data5) == 0: if d != "Head Padeatrics" and d != "Head Surgery": messageCrude.append("Not Assigned Yet") else: messageCrude.append(d) else: for bb, cc, dd in raw_data5: raw_data6 = self.dataDeparment.getDepartment( department_id=bb) for ee, ff in raw_data6: messageCrude.append(ff) self.message.append(messageCrude)
def __init__(self): super(RetrieveUnsignedHospitalNurses, self).__init__() self.dataStaffDemographics=model0.StaffDemographics() self.dataUsers=model0.Users() self.dataStaffDemographicsUsersRel=model0.StaffDemographicsUsersRel() self.dataStaffState=model0.StaffState() self.dataStaffLeaveStatus=model0.StaffLeaveStatus() self.dataStaffCurrentAccountState=model0.StaffCurrentAccountState() self.dataDepartmentStaffRel=model0.DepartmentStaffRel() self.dataDeparment=model0.Department() self.message=[] self.departments=[] self.idPrefix=accountManagementHelper.GenerateIdPrefix() raw_data0=[] raw_data00=self.dataUsers.getAllUsers() for a,b,c,d,e in raw_data00: if d!="Principle Nurse Officer" and d!="Head Padeatrics" and d!="Head Surgery" and d!="System Administrator" and d!="Store Personnel" and d!="Laboratorist" and d!="Clinician" and d!="Pharmacist" and d!="Head Pharmacy" and d!="Head Clinic" and d!="Head Laboratory" and d!="Head Front Desk"\ and d!="Head Store" and d!="Human Resource" and d!="Doctor" and d!="This is list should be extended as development proceeds": raw_data11=self.dataStaffDemographicsUsersRel.getStaffDemographicsUsersRelByUsername(username=a) for f,g in raw_data11: check0=self.dataDepartmentStaffRel.getDepartmentStaffRelByStaffId(staff_id=f) if len(check0)==0: raw_data0.append([a,b,c,d,e]) for a,b,c,d,e in raw_data0: messageCrude=[] raw_data1=self.dataStaffDemographicsUsersRel.getStaffDemographicsUsersRelByUsername(username=a) for f,g in raw_data1: raw_data2=self.dataStaffDemographics.getStaffDemographicsByStaffId(staff_id=f) for h,i,j,k,l,m,n,o,p,q,r,s,t,u,v in raw_data2: messageCrude.append(self.idPrefix.idPrefix+"-"+h) messageCrude.append(h) messageCrude.append(i) messageCrude.append(v) messageCrude.append(q) check1=self.dataStaffLeaveStatus.getStaffLeaveStatus(staff_id=h) for w,x,xx in check1: if x=="off": raw_data3=self.dataStaffCurrentAccountState.getStaffCurrentAccountState(staff_id=h) for y,z,zz in raw_data3: messageCrude.append([z,zz]) else: messageCrude.append([x,xx]) self.message.append(messageCrude) raw_data3=self.dataDeparment.getAllDepartment() for a,b in raw_data3: if a in NurseDepartments: self.departments.append([a,b]) self.dataDeparment.conn.close() self.dataStaffDemographics.conn.close() self.dataUsers.conn.close() self.dataStaffDemographicsUsersRel.conn.close() self.dataStaffState.conn.close() self.dataStaffLeaveStatus.conn.close() self.dataStaffCurrentAccountState.conn.close() self.dataDepartmentStaffRel.conn.close()
def __init__(self, **kwags): super(AddHospitalDoctor, self).__init__() self.message = [] kwags['marital_status'] = '' kwags['physical_address'] = '' kwags['user_type'] = "Doctor" kwags['full_name'] = "{} {}".format(kwags['first_name'], kwags['other_name']) self.message.append(kwags['full_name']) pref = accountManagementHelper.GenerateIdPrefix() self.prefix = pref.idPrefix init = accountManagementHelper.GenerateIdInitials(**kwags) initials = init.initials kwag = {"state": "staff_id", "initials": initials} staffId = accountManagementHelper.GenerateId(**kwag) staff_id = staffId.id kwags['staff_id'] = staff_id self.message.append(self.prefix + "-" + staff_id) usrName = accountManagementHelper.GenerateUserName(**kwags) if usrName.username == None: kwags['username'] = kwags['staff_id'] self.message.append(kwags['staff_id']) else: kwags['username'] = usrName.username self.message.append(kwags['appointment_id']) addStaff = accountManagementHelper.AddHighLevelStaff(**kwags) self.message.append(kwags['phone_number']) if addStaff.duplicateUserName == 1: self.mes0 = 0 else: self.mes0 = 1 self.message.append(self.mes0) if addStaff.tooMuchAdministrator == 1: self.mes1 = 0 else: self.mes1 = 1 self.message.append(self.mes1) self.message.append(addStaff.photo) self.message.append(addStaff.date_of_creation) self.message.append(kwags['user_type'])
def __init__(self, **kwags): super(AddNewPatient, self).__init__() self.dataPatientCurrentStatus = model0.PatientCurrentStatus() self.dataPatientStatus = model0.PatientStatus() self.dataPatientPhoto = model0.PatientPhoto() self.dataPatientDemographics = model0.PatientDemographics() self.dataPatientNextOfKeen = model0.PatientNextOfKeen() self.dataPatientCurrentNextOfKeen = model0.PatientCurrentNextOfKeen() self.dataPatientEmployer = model0.PatientEmployer() self.dataPatientCurrentEmployer = model0.PatientCurrentEmployer() self.dataPatientPhysicalAddress = model0.PatientPhysicalAddress() self.dataPatientEmailAddress = model0.PatientEmailAddress() self.dataPatientPhoneNumber = model0.PatientPhoneNumber() self.dataPatientSpouseDetail = model0.PatientSpouseDetail() self.dataPatientCurrentSpouseDetail = model0.PatientCurrentSpouseDetail( ) self.dataPatientDemographicsStaffRel = model0.PatientDemographicsStaffRel( ) self.message = [] tm = time.ctime() kwags['phone_number'] = "{}@{}@{}".format(kwags['home_phone'].strip(), kwags['work_phone'].strip(), kwags['cell_phone'].strip()) kwags['date_of_registration'] = tm kwags['date_of_record'] = tm kwags['email_address'] = kwags['email'] kwags['date_of_creation'] = tm kwags['date_of_status'] = tm kwagsEmmergency = dict() kwagsEmmergency['patient_id'] = kwags['patient_id'] kwagsEmmergency['fullname'] = kwags['emmergence_name'] kwagsEmmergency['physical_address'] = kwags['emmergency_address'] kwagsEmmergency['mobile_phone'] = kwags['emmergency_phone_number'] kwagsEmmergency['date_of_record'] = tm kwags['current_status'] = "float" kwags['patient_status'] = "out patient" kwags['fullname'] = "{} {}".format(kwags['first_name'].strip().lower(), kwags['other_name'].strip().lower()) if len(kwags['nid'].strip()) != 0: check0 = self.dataPatientDemographics.getPatientDemographicsByNID( **kwags) if len(check0) != 0: self.mes0 = 0 else: self.mes0 = 1 check1 = self.dataPatientDemographics.getPatientDemographicsBySocialSecurityNumber( **kwags) if len(check1) != 0: self.mes1 = 0 else: self.mes1 = 1 elif len(kwags['social_security_number'].strip()) != 0: check0 = self.dataPatientDemographics.getPatientDemographicsBySocialSecurityNumber( **kwags) if len(check0) != 0: self.mes1 = 0 else: self.mes1 = 1 check1 = self.dataPatientDemographics.getPatientDemographicsByNID( **kwags) if len(check1) != 0: self.mes0 = 0 else: self.mes0 = 1 else: self.mes0 = 1 self.mes1 = 1 if self.mes0 != 1 or self.mes1 != 1: self.mes = 0 else: self.mes = 1 self.message.append(kwags['fullname']) pref = accountManagementHelper.GenerateIdPrefix() self.prefix = pref.idPrefix init = accountManagementHelper.GenerateIdInitials(**kwags) initials = init.initials kwag = {"state": "patient_id", "initials": initials} patientId = accountManagementHelper.GenerateId(**kwag) patient_id = patientId.id kwags['patient_id'] = patient_id self.message.append(self.prefix + patient_id) self.dataPatientDemographics.addPatientDemographics(**kwags) self.dataPatientPhoto.addPatientPhoto(**kwags) self.dataPatientPhysicalAddress.addPatientPhysicalAddress(**kwags) self.dataPatientEmailAddress.addPatientEmailAddress(**kwags) self.dataPatientPhoneNumber.addPatientPhoneNumber(**kwags) self.dataPatientDemographicsStaffRel.addPatientDemographicsStaffRel( **kwags) self.dataPatientEmployer.addPatientEmployer(**kwags) self.dataPatientCurrentEmployer.addPatientCurrentEmployer(**kwags) self.dataPatientSpouseDetail.addPatientSpouseDetail(**kwags) self.dataPatientCurrentSpouseDetail.addPatientCurrentSpouseDetail( **kwags) self.dataPatientCurrentStatus.addPatientCurrentStatus(**kwags) self.dataPatientStatus.addPatientStatus(**kwags) self.dataPatientNextOfKeen.addPatientNextOfKeen(**kwagsEmmergency) self.dataPatientCurrentNextOfKeen.addPatientCurrentNextOfKeen( **kwagsEmmergency) self.dataPatientDemographics.conn.close() self.dataPatientPhoto.conn.close() self.dataPatientPhysicalAddress.conn.close() self.dataPatientEmailAddress.conn.close() self.dataPatientPhoneNumber.conn.close() self.dataPatientDemographicsStaffRel.conn.close() self.dataPatientEmployer.conn.close() self.dataPatientCurrentEmployer.conn.close() self.dataPatientSpouseDetail.conn.close() self.dataPatientCurrentSpouseDetail.conn.close() self.dataPatientCurrentStatus.conn.close() self.dataPatientStatus.conn.close() self.dataPatientNextOfKeen.conn.close() self.dataPatientCurrentNextOfKeen.conn.close()