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))