def get(self): Guser = users.get_current_user() from church import UserRights,Branches if Guser: findRequest = UserRights.query(UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequest.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() if thisUserRight.strAdminUser: URL = self.request.url URLlist = URL.split("/") vstrIDNumber = URLlist[len(URLlist) - 1] findRequest = Employees.query(Employees.strIDNumber == vstrIDNumber) thisEmployeeList = findRequest.fetch() if len(thisEmployeeList) > 0: thisEmployee = thisEmployeeList[0] else: thisEmployee = Employees() findRequest = Branches.query(Branches.strChurchID == thisEmployee.strChurchID) thisBranchList = findRequest.fetch() template = template_env.get_template('templates/admin/churches/employees/employees.html') context = {'thisEmployee':thisEmployee,'thisBranchList':thisBranchList} self.response.write(template.render(context))
def post(self): Guser = users.get_current_user() from church import ChurchMember, UserRights if Guser: findRequest = UserRights.query( UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequest.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() findRequest = ChurchMember.query( ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() if thisUserRight.strAdminUser or thisUserRight.strSuperUser: vstrChoice = self.request.get('vstrChoice') if vstrChoice == "0": vstrNames = self.request.get('vstrNames') vstrSurname = self.request.get('vstrSurname') vstrOccasion = self.request.get('vstrOccasion') vstrTextTestament = self.request.get('vstrTextTestament') thisTestament = Testimony() thisTestament.writeChurchBranchID( strinput=thisChurchMember.strChurchBranchID) thisTestament.writeChurchID( strinput=thisChurchMember.strChurchID) thisTestament.writeNames(strinput=vstrNames) thisTestament.writeSurname(strinput=vstrSurname) thisTestament.writeOccasion(strinput=vstrOccasion) thisTestament.writeTestament(strinput=vstrTextTestament) thisTestament.put() self.response.write("Testament successfully uploaded")
def get(self): Guser = users.get_current_user() from church import ChurchMember, UserRights if Guser: findRequests = ChurchMember.query( ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequests.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() findRequests = UserRights.query( UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequests.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() if thisUserRight.strAdminUser or thisUserRight.strSuperUser: URL = self.request.url URLlist = URL.split("/") vstrCell = URLlist[len(URLlist) - 1] findRequest = Contacts.query( Contacts.strCell == vstrCell, Contacts.strChurchID == thisChurchMember.strChurchID) thisContactList = findRequest.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() template = template_env.get_template( 'templates/contacts/thisContact.html') context = {'thisContact': thisContact} self.response.write(template.render(context))
def get(self): Guser = users.get_current_user() from church import ChurchMember, UserRights if Guser: findRequest = UserRights.query( UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequest.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() findRequest = ChurchMember.query( ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() if thisUserRight.strAdminUser or thisUserRight.strSuperUser: findRequest = Testimony.query( Testimony.strChurchID == thisChurchMember.strChurchID, Testimony.strChurchBranchID == thisChurchMember.strChurchBranchID) thisTestimonyList = findRequest.fetch() template = template_env.get_template( 'templates/testimony/testimony.html') context = {'thisTestimonyList': thisTestimonyList} self.response.write(template.render(context)) else: template = template_env.get_template( 'templates/subRestricted.html') context = {'thisChurchMember': thisChurchMember} self.response.write(template.render(context))
def get(self): Guser = users.get_current_user() from church import ChurchMember,UserRights if Guser: URL = self.request.url vstrURLlist = URL.split("/") vstrListID = vstrURLlist[len(vstrURLlist) - 1] findRequest = UserRights.query(UserRights.strMemberID == Guser.user_id()) thisUserRightList = findRequest.fetch() if len(thisUserRightList) > 0: thisUserRight = thisUserRightList[0] else: thisUserRight = UserRights() findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() if thisUserRight.strSuperUser or thisUserRight.strAdminUser: findRequest = MailingList.query(MailingList.strListID == vstrListID,MailingList.strChurchID == thisChurchMember.strChurchID) thisMailingList = findRequest.fetch() if len(thisMailingList) > 0: thisNewsLetter = thisMailingList[0] else: thisNewsLetter = MailingList() template = template_env.get_template('templates/newsletter/thisNewsletter.html') context = {'thisNewsLetter':thisNewsLetter} self.response.write(template.render(context))
def post(self): Guser = users.get_current_user() from church import UserRights,ChurchMember,Branches if Guser: findRequest = UserRights.query(UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequest.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() if thisUserRight.strAdminUser: vstrChoice = self.request.get('vstrChoice') if vstrChoice == "0": URL = self.request.url URLlist = URL.split("/") vstrIDNumber = URLlist[len(URLlist) - 1] findRequest = Employees.query(Employees.strIDNumber == vstrIDNumber) thisEmployeeList = findRequest.fetch() if len(thisEmployeeList) > 0: thisEmployee = thisEmployeeList[0] else: thisEmployee = Employees() findRequest = Branches.query(Branches.strChurchID == thisEmployee.strChurchID) thisBranchList = findRequest.fetch() template = template_env.get_template('templates/admin/churches/employees/personal.html') context = {'thisEmployee':thisEmployee,'thisBranchList':thisBranchList} self.response.write(template.render(context)) elif vstrChoice == "1": URL = self.request.url URLlist = URL.split("/") vstrIDNumber = URLlist[len(URLlist) - 1] findRequest = Salaries.query(Salaries.strIDNumber == vstrIDNumber) thisSalariesList = findRequest.fetch() try: thisSalary = thisSalariesList[0] except: thisSalary = Salaries() template = template_env.get_template('templates/admin/churches/employees/SalariesPayslips.html') context = {'thisSalariesList':thisSalariesList,'vstrIDNumber':vstrIDNumber,'vstrEmployeeID':thisSalary.strEmployeeID} self.response.write(template.render(context)) elif vstrChoice == "2": findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() vstrIDNumber = self.request.get('vstrIDNumber') vstrOverTimeRate = self.request.get('vstrOverTimeRate') vstrNormalRate = self.request.get('vstrNormalRate') vstrUIF = self.request.get('vstrUIF') vstrPaye = self.request.get('vstrPaye') vstrOtherDeductions = self.request.get('vstrOtherDeductions') vstrThisDate = self.request.get('vstrThisDate') vstrEmployeeID = self.request.get('vstrEmployeeID') try: vstrThisDateList = vstrThisDate.split("-") strYear = int(vstrThisDateList[0]) strMonth = int(vstrThisDateList[1]) strDay = int(vstrThisDateList[2]) vstrThisDate = datetime.date(year=strYear,month=strMonth,day=strDay) except: vstrThisDate = datetime.datetime.now() vstrThisDate = vstrThisDate.date() strYear = vstrThisDate.year strMonth = vstrThisDate.month findRequest = Salaries.query(Salaries.strIDNumber == vstrIDNumber,Salaries.strYear == str(strYear),Salaries.strMonth == str(strMonth)) thisSalaryList = findRequest.fetch(1) if len(thisSalaryList) > 0: thisSalary = thisSalaryList[0] else: thisSalary = Salaries() thisSalary.writeChurchID(strinput=thisChurchMember.strChurchID) thisSalary.writeChurchBranchID(strinput=thisChurchMember.strChurchBranchID) thisSalary.writeEmployeeID(strinput=vstrEmployeeID) thisSalary.writeIDNumber(strinput=vstrIDNumber) thisSalary.writeOvertimeRate(strinput=vstrOverTimeRate) thisSalary.writeNormalRate(strinput=vstrNormalRate) thisSalary.writeUIF(strinput=vstrUIF) thisSalary.writePaye(strinput=vstrPaye) thisSalary.writeOtherDeductions(strinput=vstrOtherDeductions) thisSalary.put() self.response.write("Salary Successfully updated") elif vstrChoice == "3": vstrIDNumber = self.request.get('vstrIDNumber') findRequest = BankingDetails.query(BankingDetails.strIDNumber == vstrIDNumber) thisBankingDetailsList = findRequest.fetch() if len(thisBankingDetailsList) > 0: thisBankingDetails = thisBankingDetailsList[0] else: thisBankingDetails = BankingDetails() template = template_env.get_template('templates/admin/churches/employees/BankDetails.html') context = {'thisBankDetails':thisBankingDetails} self.response.write(template.render(context)) elif vstrChoice == "4": vstrIDNumber = self.request.get('vstrIDNumber') vstrAccountOwner = self.request.get('vstrAccountOwner') vstrAccountNumber = self.request.get('vstrAccountNumber') vstrBankName = self.request.get('vstrBankName') vstrBranchName = self.request.get('vstrBranchName') vstrBranchCode = self.request.get('vstrBranchCode') vstrAccountType = self.request.get('vstrAccountType') findRequest = BankingDetails.query(BankingDetails.strIDNumber == vstrIDNumber) thisBankingDetailsList = findRequest.fetch() if len(thisBankingDetailsList) > 0: thisBankingDetails = thisBankingDetailsList[0] else: thisBankingDetails = BankingDetails() thisBankingDetails.writeIDNumber(strinput=vstrIDNumber) thisBankingDetails.writeAccountOwner(strinput=vstrAccountOwner) thisBankingDetails.writeAccountNumber(strinput=vstrAccountNumber) thisBankingDetails.writeBankName(strinput=vstrBankName) thisBankingDetails.writeBranchName(strinput=vstrBranchName) thisBankingDetails.writeBranchCode(strinput=vstrBranchCode) thisBankingDetails.writeAccountType(strinput=vstrAccountType) thisBankingDetails.put() self.response.write("Banking Details Successfully updated") elif vstrChoice == "5": vstrIDNumber = self.request.get('vstrIDNumber') findRequest = AttendanceRegister.query(AttendanceRegister.strIDNumber == vstrIDNumber) thisAttendanceRegisterList = findRequest.fetch() if len(thisAttendanceRegisterList) > 0: thisAttendance = thisAttendanceRegisterList[0] else: thisAttendance = AttendanceRegister() template = template_env.get_template('templates/admin/churches/employees/AttendanceRegister.html') context = {'thisAttendanceRegisterList':thisAttendanceRegisterList,'thisAttendance':thisAttendance,'vstrIDNumber':vstrIDNumber} self.response.write(template.render(context)) elif vstrChoice == "6": vstrNames = self.request.get('vstrNames') vstrSurname = self.request.get('vstrSurname') vstrIDNumber = self.request.get('vstrIDNumber') vstrPosition = self.request.get('vstrPosition') vstrContract = self.request.get('vstrContract') vstrPhyStandNumber = self.request.get('vstrPhyStandNumber') vstrPhyStreetName = self.request.get('vstrPhyStreetName') vstrPhyCityTown = self.request.get('vstrPhyCityTown') vstrPhyProvince = self.request.get('vstrPhyProvince') vstrPhyCountry = self.request.get('vstrPhyCountry') vstrPhyPostalCode = self.request.get('vstrPhyPostalCode') vstrBoxNumber = self.request.get('vstrBoxNumber') vstrCityTown = self.request.get('vstrCityTown') vstrProvince = self.request.get('vstrProvince') vstrCountry = self.request.get('vstrCountry') vstrPostalCode = self.request.get('vstrPostalCode') vstrSelectBranch = self.request.get('vstrSelectBranch') findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisAdminList = findRequest.fetch() if len(thisAdminList) > 0: thisAdmin = thisAdminList[0] else: thisAdmin = ChurchMember() findRequest = Employees.query(Employees.strChurchID == thisAdmin.strChurchID,Employees.strIDNumber == vstrIDNumber) thisEmployeeList = findRequest.fetch() if len(thisEmployeeList) > 0: thisEmployee = thisEmployeeList[0] else: thisEmployee = Employees() thisEmployee.writeNames(strinput=vstrNames) thisEmployee.writeSurname(strinput=vstrSurname) thisEmployee.writeIDNumber(strinput=vstrIDNumber) thisEmployee.writePosition(strinput=vstrPosition) thisEmployee.writeContract(strinput=vstrContract) thisEmployee.writePhyStandNumber(strinput=vstrPhyStandNumber) thisEmployee.writePhyStreetName(strinput=vstrPhyStreetName) thisEmployee.writePhyCityTown(strinput=vstrPhyCityTown) thisEmployee.writePhyProvince(strinput=vstrPhyProvince) thisEmployee.writePhyCountry(strinput=vstrPhyCountry) thisEmployee.writePhyCountry(strinput=vstrPhyCountry) thisEmployee.writePhyPostalCode(strinput=vstrPhyPostalCode) thisEmployee.writeBoxNumber(strinput=vstrBoxNumber) thisEmployee.writeCityTown(strinput=vstrCityTown) thisEmployee.writeProvince(strinput=vstrProvince) thisEmployee.writeCountry(strinput=vstrCountry) thisEmployee.writePostalCode(strinput=vstrPostalCode) thisEmployee.writeChurchBranchID(strinput=vstrSelectBranch) thisEmployee.writeChurchID(strinput=thisAdmin.strChurchID) thisEmployee.put()
def post(self): Guser = users.get_current_user() from church import ChurchMember,UserRights if Guser: vstrChoice = self.request.get('vstrChoice') findRequest = UserRights.query(UserRights.strMemberID == Guser.user_id()) thisUserRightList = findRequest.fetch() if len(thisUserRightList) > 0: thisUserRight = thisUserRightList[0] else: thisUserRight = UserRights() findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() vstrDateTime = datetime.datetime.now() strDate = vstrDateTime.date() strTime = datetime.time(hour=vstrDateTime.hour,minute=vstrDateTime.minute,second=vstrDateTime.second) if thisUserRight.strAdminUser or thisUserRight.strSuperUser: if vstrChoice == "0": vstrListID = self.request.get('vstrListID') findRequest = Letters.query(Letters.strListID == vstrListID) thisLettersList = findRequest.fetch() template = template_env.get_template('templates/newsletter/sub/letters.html') context = {'thisLettersList':thisLettersList,'vstrListID':vstrListID} self.response.write(template.render(context)) elif vstrChoice == "1": vstrLetterHeading = self.request.get('vstrLetterHeading') vstrLetterBody = self.request.get('vstrLetterBody') vstrListID = self.request.get('vstrListID') findRequest = Letters.query(Letters.strLetterHeading == vstrLetterHeading) thisLettersList = findRequest.fetch() if len(thisLettersList) > 0: thisLetter = thisLettersList[0] else: thisLetter = Letters() thisLetter.writeArticlesID(strinput=thisLetter.CreateArticleID()) thisLetter.writeIndex(strinput=thisLetter.AdvanceIndex(strinput=vstrListID)) thisLetter.writeHostedLink(strinput=thisLetter.CreateHostedLink()) thisLetter.writeDateCreated(strinput=strDate) thisLetter.writeTimeCreated(strinput=strTime) thisLetter.writeMemberID(strinput=Guser.user_id()) thisLetter.writeChurchID(strinput=thisChurchMember.strChurchID) thisLetter.writeLetterHeading(strinput=vstrLetterHeading) thisLetter.writeLetterBody(strinput=vstrLetterBody) thisLetter.writeListID(strinput=vstrListID) thisLetter.put() self.response.write("Article successfully updated") elif vstrChoice == "2": vstrListID = self.request.get('vstrListID') findRequest = ContactList.query(ContactList.strListID == vstrListID) thisContactList = findRequest.fetch() template = template_env.get_template('templates/newsletter/sub/contact.html') context = {'thisContactList':thisContactList,'vstrListID':vstrListID} self.response.write(template.render(context)) elif vstrChoice == "3": vstrListID = self.request.get('vstrListID') vstrContacts = self.request.get('vstrContacts') findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() strContactList = vstrContacts.split("|") for thisContact in strContactList: thisContactList = thisContact.split(",") if len(thisContactList) == 4: findRequest = ContactList.query(ContactList.strListID == vstrListID,ContactList.strEmail == thisContactList[1]) strthisContactList = findRequest.fetch() if len(strthisContactList) > 0: strContact = strthisContactList[0] else: strContact = ContactList() strContact.writeListID(strinput=vstrListID) strContact.writeCell(strinput=thisContactList[0]) strContact.writeEmail(strinput=thisContactList[1]) strContact.writeNames(strinput=thisContactList[2]) strContact.writeSurname(strinput=thisContactList[3]) strContact.writeChurchID(strinput=thisChurchMember.strChurchID) strContact.put() self.response.write("Contact list updated successfully") elif vstrChoice == "4": vstrListID = self.request.get('vstrListID') vstrNames = self.request.get('vstrNames') vstrSurname = self.request.get('vstrSurname') vstrCellNumber = self.request.get('vstrCellNumber') vstrEmail = self.request.get('vstrEmail') findRequest = ChurchMember.query(ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequest.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() findRequest = ContactList.query(ContactList.strListID == vstrListID,ContactList.strEmail == vstrEmail) thisContactList = findRequest.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = ContactList() thisContact.writeChurchID(strinput=thisChurchMember.strChurchID) thisContact.writeListID(strinput=vstrListID) thisContact.writeNames(strinput=vstrNames) thisContact.writeSurname(strinput=vstrSurname) thisContact.writeCell(strinput=vstrCellNumber) thisContact.writeEmail(strinput=vstrEmail) thisContact.put() self.response.write("Successfully uploaded contact") elif vstrChoice == "5": vstrListID = self.request.get('vstrListID') vstrListID = vstrListID.strip() vstrRemoveEmail = self.request.get('vstrRemoveEmail') vstrRemoveEmail = vstrRemoveEmail.strip() findRequest = ContactList.query(ContactList.strEmail == vstrRemoveEmail,ContactList.strListID == vstrListID) thisContactList = findRequest.fetch() contactRemoved = False for thisContact in thisContactList: thisContact.key.delete() contactRemoved = True if contactRemoved: self.response.write("Successfully removed email") else: self.response.write("Contact not removed : " + vstrRemoveEmail) elif vstrChoice == "6": vstrListID = self.request.get('vstrListID') vstrListID = vstrListID.strip() findRequest = MailingList.query(MailingList.strListID == vstrListID) thisMailingList = findRequest.fetch() template = template_env.get_template('templates/newsletter/sub/schedule.html') context = {'thisMailingList':thisMailingList,'vstrListID':vstrListID} self.response.write(template.render(context)) elif vstrChoice == "7": vstrListID = self.request.get('vstrListID') vstrDate = self.request.get('vstrDate') strDateList = vstrDate.split("/") strMonth = strDateList[0] strDay = strDateList[1] strYear = strDateList[2] vstrTime = self.request.get('vstrTime') if "AM" in vstrTime: vstrTime = vstrTime.replace("AM","") vstrTime = vstrTime.strip() strTimeList = vstrTime.split(":") strHour = strTimeList[0] strMinute = strTimeList[1] elif "PM" in vstrTime: vstrTime = vstrTime.replace("PM","") vstrTime = vstrTime.strip() strTimeList = vstrTime.split(":") strHour = strTimeList[0] strHour = int(strHour) strHour += 12 strMinute = strTimeList[1] else: vstrTime = vstrTime.strip() strTimeList = vstrTime.split(":") strHour = strTimeList[0] strMinute = strTimeList[1] vstrThisDate = datetime.date(year=int(strYear),month=int(strMonth),day=int(strDay)) vstrTime = datetime.time(hour=int(strHour),minute=int(strMinute)) findRequest = MailingList.query(MailingList.strListID == vstrListID) thisMailingList = findRequest.fetch() if len(thisMailingList) > 0: thisMailing = thisMailingList[0] thisMailing.writeStartSendingDate(strinput=vstrThisDate) thisMailing.writeStartSendingTime(strinput=vstrTime) thisMailing.put() self.response.write("Successfully updated Scheduled date and time") else: self.response.write("Error updating scheduled date and time")
def post(self): Guser = users.get_current_user() from church import ChurchMember, UserRights if Guser: findRequests = ChurchMember.query( ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequests.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() findRequests = UserRights.query( UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequests.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() if thisUserRight.strAdminUser or thisUserRight.strSuperUser: vstrChoice = self.request.get('vstrChoice') if vstrChoice == "0": vstrCell = self.request.get('vstrCell') findRequests = Contacts.query( Contacts.strCell == vstrCell, Contacts.strChurchID == thisChurchMember.strChurchID) thisContactList = findRequests.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() findRequests = Notes.query( Notes.strContactID == thisContact.strContactID) thisNotesList = findRequests.fetch() findRequests = PostalAddress.query( PostalAddress.strContactID == thisContact.strContactID) thisPostalAddressList = findRequests.fetch() if len(thisPostalAddressList) > 0: thisPostalAddress = thisPostalAddressList[0] else: thisPostalAddress = PostalAddress() thisPostalAddress.writeContactID( strinput=thisContact.strContactID) thisPostalAddress.writeChurchID( strinput=thisContact.strChurchID) thisPostalAddress.put() findRequests = PhysicalAddress.query( PhysicalAddress.strContactID == thisContact.strContactID) thisPhysicalAddressList = findRequests.fetch() if len(thisPhysicalAddressList) > 0: thisPhysicalAddress = thisPhysicalAddressList[0] else: thisPhysicalAddress = PhysicalAddress() thisPhysicalAddress.writeContactID( strinput=thisContact.strContactID) thisPhysicalAddress.writeChurchID( strinput=thisContact.strChurchID) thisPhysicalAddress.put() template = template_env.get_template( 'templates/contacts/sub/manage.html') context = { 'thisContact': thisContact, 'thisNotesList': thisNotesList, 'thisPostalAddress': thisPostalAddress, 'thisPhysicalAddress': thisPhysicalAddress } self.response.write(template.render(context)) elif vstrChoice == "1": vstrContactID = self.request.get('vstrContactID') vstrPostalCode = self.request.get('vstrPostalCode') vstrCountry = self.request.get('vstrCountry') vstrProvince = self.request.get('vstrProvince') vstrCityTown = self.request.get('vstrCityTown') vstrBox = self.request.get('vstrBox') findRequests = PostalAddress.query( PostalAddress.strContactID == vstrContactID) thisPostalAddressList = findRequests.fetch() if len(thisPostalAddressList) > 0: thisPostalAddress = thisPostalAddressList[0] else: thisPostalAddress = PostalAddress() thisPostalAddress.writeChurchID( strinput=thisChurchMember.strChurchID) thisPostalAddress.writeContactID(strinput=vstrContactID) thisPostalAddress.writeBox(strinput=vstrBox) thisPostalAddress.writeCityTown(strinput=vstrCityTown) thisPostalAddress.writeProvince(strinput=vstrProvince) thisPostalAddress.writeCountry(strinput=vstrCountry) thisPostalAddress.writePostalCode(strinput=vstrPostalCode) thisPostalAddress.put() self.response.write("Postal Address updated successfully") elif vstrChoice == "2": vstrSubject = self.request.get('vstrSubject') vstrNotes = self.request.get('vstrNotes') vstrContactID = self.request.get('vstrContactID') findRequests = Notes.query( Notes.strContactID == vstrContactID, Notes.strSubject == vstrSubject, Notes.strNotes == vstrNotes) thisNotesList = findRequests.fetch() if len(thisNotesList) > 0: thisNote = thisNotesList[0] else: thisNote = Notes() thisNote.writeContactID(strinput=vstrContactID) thisNote.writeChurchID( strinput=thisChurchMember.strChurchID) thisDate = datetime.datetime.now() thisDate = thisDate.date() thisNote.writeDateTaken(strinput=thisDate) thisTime = datetime.datetime.now() thisTime = thisTime.time() thisTime = datetime.time(hour=thisTime.hour, minute=thisTime.minute, second=thisTime.second) thisNote.writeTimeTaken(strinput=thisTime) thisNote.writeSubject(strinput=vstrSubject) thisNote.writeNotes(strinput=vstrNotes) thisNote.put() self.response.write("Note successfully uploaded") elif vstrChoice == "3": vstrContactID = self.request.get('vstrContactID') vstrStandNumber = self.request.get('vstrStandNumber') vstrStreetName = self.request.get('vstrStreetName') vstrPhyCityTown = self.request.get('vstrPhyCityTown') vstrPhyProvince = self.request.get('vstrPhyProvince') vstrPhyCountry = self.request.get('vstrPhyCountry') vstrPhyPostalCode = self.request.get('vstrPhyPostalCode') findRequests = PhysicalAddress.query( PhysicalAddress.strContactID == vstrContactID) thisPhysicalAddressList = findRequests.fetch() if len(thisPhysicalAddressList) > 0: thisPhysicalAddress = thisPhysicalAddressList[0] else: thisPhysicalAddress = PhysicalAddress() thisPhysicalAddress.writeContactID(strinput=vstrContactID) thisPhysicalAddress.writeChurchID( strinput=thisChurchMember.strChurchID) thisPhysicalAddress.writeStandNumber( strinput=vstrStandNumber) thisPhysicalAddress.writeStreetName( strinput=vstrStreetName) thisPhysicalAddress.writeCityTown(strinput=vstrPhyCityTown) thisPhysicalAddress.writeProvince(strinput=vstrPhyProvince) thisPhysicalAddress.writeCountry(strinput=vstrPhyCountry) thisPhysicalAddress.writePostalCode( strinput=vstrPhyPostalCode) thisPhysicalAddress.put() self.response.write( "Physical Address successfully updated") elif vstrChoice == "4": vstrCell = self.request.get('vstrCell') findRequests = Contacts.query( Contacts.strChurchID == thisChurchMember.strChurchID, Contacts.strCell == vstrCell) thisContactList = findRequests.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() findRequests = SMSInBox.query( SMSInBox.strContactID == thisContact.strContactID) thisInBoxMessagesList = findRequests.fetch() findRequests = SMSOutBox.query( SMSOutBox.strContactID == thisContact.strContactID) thisSMSOutBoxList = findRequests.fetch() template = template_env.get_template( 'templates/contacts/sub/sms.html') context = { 'thisInBoxMessagesList': thisInBoxMessagesList, 'thisSMSOutBoxList': thisSMSOutBoxList, 'thisContact': thisContact } self.response.write(template.render(context)) elif vstrChoice == "5": from mysms import SMSAccount, SMSPortalVodacom, SMSPortalBudget, DeliveryReport vstrMessage = self.request.get('vstrMessage') vstrContactID = self.request.get('vstrContactID') vstrCell = self.request.get('vstrCell') findRequest = SMSAccount.query( SMSAccount.strChurchID == thisChurchMember.strChurchID) thisSMSAccountList = findRequest.fetch() if len(thisSMSAccountList) > 0: thisSMSAccount = thisSMSAccountList[0] else: thisSMSAccount = SMSAccount() if thisSMSAccount.strUsePortal == "Vodacom": findRequest = SMSPortalVodacom.query() thisPortalList = findRequest.fetch() if len(thisPortalList) > 0: thisPortal = thisPortalList[0] else: thisPortal = SMSPortalVodacom() i = 0 message = mail.EmailMessage() message.sender = thisPortal.strSenderAddress message.to = thisPortal.strEmailAddress message.subject = vstrCell message.body = vstrMessage message.send() thisPortal.strAvailableCredit = thisPortal.strAvailableCredit - 1 thisDeliveryReport = DeliveryReport() thisDeliveryReport.writeGroupID(vstrContactID) thisDeliveryReport.writeCell(vstrCell) thisDeliveryReport.writeDelivered(strinput=True) thisDate = datetime.datetime.now() strThisDate = thisDate.date() strThisTime = thisDate.time() strThisTime = datetime.time(hour=strThisTime.hour, minute=strThisTime.minute, second=strThisTime.second) thisDeliveryReport.writeDate(strinput=strThisDate) thisDeliveryReport.writeTime(strinput=strThisTime) thisDeliveryReport.writeMessageID(strinput=vstrMessage) thisDeliveryReport.put() thisPortal.put() thisSMSAccount.strTotalSMS = thisSMSAccount.strTotalSMS - 1 thisSMSAccount.put() thisOutBox = SMSOutBox() thisOutBox.writeMessage(strinput=vstrMessage) thisOutBox.writeContactID(strinput=vstrContactID) thisOutBox.writeMessageID( strinput=thisOutBox.CreateMessageID()) thisOutBox.writeDateSent(strinput=strThisDate) thisOutBox.writeTimeSent(strinput=strThisTime) thisOutBox.put() self.response.write("SMS Successfully sent") elif vstrChoice == "6": vstrCell = self.request.get('vstrCell') findRequest = Contacts.query(Contacts.strCell == vstrCell) thisContactList = findRequest.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() findRequest = EmailInBox.query( EmailInBox.strContactID == thisContact.strContactID) thisEmailInboxList = findRequest.fetch() findRequest = EmailOutBox.query( EmailOutBox.strContactID == thisContact.strContactID) thisEmailOutBoxList = findRequest.fetch() template = template_env.get_template( 'templates/contacts/sub/email.html') context = { 'vstrCell': vstrCell, 'thisEmailInboxList': thisEmailInboxList, 'thisEmailOutBoxList': thisEmailOutBoxList } self.response.write(template.render(context)) elif vstrChoice == "7": vstrCell = self.request.get('vstrCell') vstrSubject = self.request.get('vstrSubject') vstrMessage = self.request.get('vstrMessage') findRequest = Contacts.query(Contacts.strCell == vstrCell) thisContactList = findRequest.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() findRequest = EmailOutBox.query( EmailOutBox.strSubject == vstrSubject, EmailOutBox.strMessage == vstrMessage) thisEmailOutBoxList = findRequest.fetch() if len(thisEmailOutBoxList) > 0: thisEmailOutBox = thisEmailOutBoxList[0] else: thisEmailOutBox = EmailOutBox() thisEmailOutBox.writeContactID( strinput=thisContact.strContactID) thisEmailOutBox.writeMessageID( strinput=thisEmailOutBox.CreateMessageID()) thisEmailOutBox.writeMessage(strinput=vstrMessage) thisDate = datetime.datetime.now() thisDate = thisDate.date() thisTime = datetime.datetime.now() thisTime = datetime.time(hour=thisTime.hour, minute=thisTime.minute, second=thisTime.second) if thisEmailOutBox.sendEmail(): thisEmailOutBox.writeIsSent(strinput=True) thisEmailOutBox.writeTimeSent(strinput=thisTime) thisEmailOutBox.writeDateSent(strinput=thisDate) thisEmailOutBox.put() self.response.write("Successfully sent an Email") else: self.response.write("Error Sending Email")
def post(self): Guser = users.get_current_user() from church import ChurchMember, UserRights if Guser: findRequests = ChurchMember.query( ChurchMember.strMemberID == Guser.user_id()) thisChurchMemberList = findRequests.fetch() if len(thisChurchMemberList) > 0: thisChurchMember = thisChurchMemberList[0] else: thisChurchMember = ChurchMember() findRequests = UserRights.query( UserRights.strMemberID == Guser.user_id()) thisUserRightsList = findRequests.fetch() if len(thisUserRightsList) > 0: thisUserRight = thisUserRightsList[0] else: thisUserRight = UserRights() if thisUserRight.strAdminUser or thisUserRight.strSuperUser: vstrChoice = self.request.get('vstrChoice') if vstrChoice == "0": vstrNames = self.request.get('vstrNames') vstrSurname = self.request.get('vstrSurname') vstrCell = self.request.get('vstrCell') vstrTel = self.request.get('vstrTel') vstrFax = self.request.get('vstrFax') vstrEmail = self.request.get('vstrEmail') vstrWebsite = self.request.get('vstrWebsite') vstrDateCreated = self.request.get('vstrDateCreated') vstrTitle = self.request.get('vstrTitle') findRequests = Contacts.query( Contacts.strCell == vstrCell, Contacts.strChurchID == thisChurchMember.strChurchID, Contacts.strChurchBranchID == thisChurchMember.strChurchBranchID) thisContactList = findRequests.fetch() if len(thisContactList) > 0: thisContact = thisContactList[0] else: thisContact = Contacts() thisContact.writeContactID( strinput=thisContact.CreateContactID()) thisContact.writeChurchID( strinput=thisChurchMember.strChurchID) thisContact.writeChurchBranchID( strinput=thisChurchMember.strChurchBranchID) thisContact.writeNames(strinput=vstrNames) thisContact.writeSurname(strinput=vstrSurname) thisContact.writeCell(strinput=vstrCell) thisContact.writeTel(strinput=vstrTel) thisContact.writeFax(strinput=vstrFax) thisContact.writeEmail(strinput=vstrEmail) thisContact.writeWebsite(strinput=vstrWebsite) thisContact.writeDateCreated(strinput=vstrDateCreated) thisContact.writeTitle(strinput=vstrTitle) thisContact.put() self.response.write("Contact successfully uploaded") else: template = template_env.get_template( 'templates/subRestricted.html') context = {'thisChurchMember': thisChurchMember} self.response.write(template.render(context))