def get_query(self, data):
''' The query we requested
'''
query = {
'sort_on': 'Date',
'sort_order': 'reverse',
'path': '/'.join(self.context.getPhysicalPath())
}
if data.get('text'):
query['SearchableText'] = quote_chars(data['text'].encode('utf8'))
if data.get('review_state'):
query['review_state'] = data['review_state']
if data.get('gate'):
query['Subject'] = "Gate: %s" % data['gate'].encode('utf8')
start = data['start']
end = data['end']
if start and end:
query['Date'] = {'query': [DateTime(start.__str__()), DateTime(end.__str__()) + 1],
'range': 'min:max'}
elif start:
query['Date'] = {'query': DateTime(start.__str__()), 'range': 'min'}
elif end:
query['Date'] = {'query': DateTime(end.__str__()) + 1, 'range': 'max'}
return query
def munge_search_term(self, q):
for char in BAD_CHARS:
q = q.replace(char, ' ')
r = q.split()
r = " AND ".join(r)
r = quote_chars(r) + '*'
return r
def munge_search_term(self, q):
for char in BAD_CHARS:
q = q.replace(char, ' ')
r = q.split()
r = " AND ".join(r)
r = quote_chars(r) + '*'
return r
def getLogosFirstpage(project):
""" Returns all the KPIs from project """
logos = []
# DONORS
if project.donors:
for donor in project.donors:
items = api.content.find(
portal_type=['Donor'],
Title=quote_chars(donor))
if items and items[0].getObject().image:
logos.append({'name': donor,
'url': items[0].getURL() + '/@@images/image'})
# PLATFOWMS OR PROGRAMS
if project.wop_platform:
items = api.content.find(
portal_type=['Platform'],
Title=quote_chars(project.wop_platform))
if items and items[0].getObject().image:
logos.append({'name': project.wop_platform,
'url': items[0].getURL() + '/@@images/image'})
if project.wop_program:
items = api.content.find(
portal_type=['Program'],
Title=quote_chars(project.wop_program))
if items and items[0].getObject().image:
logos.append({'name': project.wop_program,
'url': items[0].getURL() + '/@@images/image'})
# WATER OPERATORS
if project.partners:
for partner in project.partners:
items = api.content.find(
portal_type=['Partner'],
Title=quote_chars(partner))
if items and items[0].getObject().image:
logos.append({'name': partner,
'url': items[0].getURL() + '/@@images/image'})
return logos
def munge_search_term(self, q):
for char in BAD_CHARS:
q = q.replace(char, ' ')
r = map(quote, q.split())
phrase = '"%s"' % " ".join(r)
r = " AND ".join(r)
r = quote_chars(r) + '*'
return " OR ".join([phrase, r])
def sanitise_search_query(query):
if not rxGlob_U.findall(query):
return u""
for char in ENCODED_BAD_CHARS:
query = query.replace(char, " ")
clean_query = [quote(token) for token in query.split()]
clean_query = quote_chars(clean_query)
return u" ".join(clean_query)
def getData(self):
results = []
value = self.context.wop_program
result = api.content.find(portal_type="OutcomeCCItem", Title=quote_chars(value))[0]
results.append(dict(
icon=result.getObject().icon,
title=result.Title,
category=result.getObject().category,
))
return results[0]
def get_query(self, data):
""" The query we requested
"""
self.query_data = {}
query = {
"sort_on": "Date",
"sort_order": "reverse",
"path": "/".join(self.context.getPhysicalPath()),
}
if data.get("text"):
query["SearchableText"] = quote_chars(data["text"])
if data.get("review_state"):
query["review_state"] = data["review_state"]
if data.get("gate"):
factory = getUtility(IVocabularyFactory,
"redturtle.prenotazioni.gates")
vocabulary = factory(context=self.context)
try:
term = vocabulary.getTermByToken(data["gate"])
query["Subject"] = "Gate: {}".format(term.value)
except LookupError:
query["Subject"] = "Gate: {}".format(data["gate"])
start = data.get("start", None)
end = data.get("end", None)
if start and end:
query["Date"] = {
"query": [
DateTime(start.__str__()),
DateTime(end.__str__()) + 1,
],
"range": "min:max",
}
elif start:
query["Date"] = {
"query": DateTime(start.__str__()),
"range": "min",
}
elif end:
query["Date"] = {
"query": DateTime(end.__str__()) + 1,
"range": "max",
}
return query
def filter_query(self, query):
request = self.request
catalog = api.portal.get_tool(name='portal_catalog')
valid_indexes = tuple(catalog.indexes())
valid_keys = self.valid_keys + valid_indexes
text = query.get('SearchableText', None)
if text is None:
text = request.form.get('SearchableText', '')
if not text:
# Without text, must provide a meaningful non-empty search
valid = set(valid_indexes).intersection(request.form.keys()) or \
set(valid_indexes).intersection(query.keys())
if not valid:
return
for k, v in request.form.items():
if v and ((k in valid_keys) or k.startswith('facet.')):
query[k] = v
if text:
query['SearchableText'] = quote_chars(text) + '*'
# don't filter on created at all if we want all results
created = query.get('created')
if created:
if created.get('query'):
if created['query'][0] <= EVER:
del query['created']
# respect `types_not_searched` setting
types = query.get('portal_type', [])
if 'query' in types:
types = types['query']
query['portal_type'] = self.filter_types(types)
# respect effective/expiration date
query['show_inactive'] = False
# respect navigation root
if 'path' not in query:
query['path'] = getNavigationRoot(self.context)
return query
def get_query(self, data):
''' The query we requested
'''
query = {
'sort_on': 'Date',
'sort_order': 'reverse',
'path': '/'.join(self.context.getPhysicalPath())
}
if data.get('text'):
query['SearchableText'] = quote_chars(data['text'].encode('utf8'))
if data.get('review_state'):
query['review_state'] = data['review_state']
if data.get('gate'):
query['Subject'] = "Gate: %s" % data['gate'].encode('utf8')
start = data['start']
end = data['end']
if start and end:
query['Date'] = {'query': [DateTime(start), DateTime(end) + 1],
'range': 'min:max'}
elif start:
query['Date'] = {'query': DateTime(start), 'range': 'min'}
elif end:
query['Date'] = {'query': DateTime(end) + 1, 'range': 'max'}
return query
def improvementAreaModified(content, event):
item = api.content.find(portal_type="ItemArea", Title=quote_chars(content.title.encode('utf-8')))
if item:
content.title_es = item[0].title_es
content.title_fr = item[0].title_fr
content.reindexObject()
def improvementAreaAdded(content, event):
""" Project created handler to assign geolocation.
Copy value from behaviour fields to project fields.projectAnd create
current year
"""
api.content.create(
type='Folder',
id='events',
title='Events',
container=content)
logger.info('Create folder Events in working area {} project {} id {}'.format(content.title, content.__parent__.title, content.__parent__.id))
api.content.create(
type='Folder',
id='files',
title='Files',
container=content)
logger.info('Create folder Files in working area {} project {} id {}'.format(content.title, content.__parent__.title, content.__parent__.id))
api.content.create(
type='Folder',
id='topics',
title='Topics',
container=content)
logger.info('Create folder topics in working area {} project {} id {}'.format(content.title, content.__parent__.title, content.__parent__.id))
obj = api.content.create(
type='OutcomeCC',
id='outcomecc',
title='OutcomeCC',
container=content)
logger.info('Create OutcomeCC in working area {} project {} id {}'.format(content.title, content.__parent__.title, content.__parent__.id))
annotations = IAnnotations(obj)
for x in range(0, 11): # Create 10 annotations
generic = []
outcomeccgeneric_info = dict(
id_specific=obj.id,
description=obj.description,
baseline=obj.baseline,
baseline_date=obj.baseline_date,
objective=obj.objective,
objective_date=obj.objective_date,
stage='',
)
generic.append(outcomeccgeneric_info)
specifics = []
monitoring = []
items = api.content.find(
portal_type=['OutcomeCCS'],
context=content)
for item in items:
specific_obj = item.getObject()
result = api.content.find(portal_type="OutcomeCCItem", Title=quote_chars(specific_obj.title.encode('utf-8')))[0]
capacitychanges_obj = result.getObject()
category = capacitychanges_obj.short_category
outcomeccspecific_info = dict(
id_specific=specific_obj.id,
title_specific=specific_obj.title,
title_specific_es=specific_obj.title_es,
title_specific_fr=specific_obj.title_fr,
# description=specific_obj.description,
url='/'.join(specific_obj.getPhysicalPath()),
selected_specific='',
icon_url='++theme++gwopa.theme/assets/images/' + capacitychanges_obj.id + '.png',
icon_url_selected='++theme++gwopa.theme/assets/images/w-' + capacitychanges_obj.id + '.png',
short_category=category,
baseline=specific_obj.baseline,
baseline_date=specific_obj.baseline_date,
objective=specific_obj.objective,
objective_date=specific_obj.objective_date,
)
specifics.append(outcomeccspecific_info)
outcomeccmonitoring_info = dict(
id_specific=specific_obj.id,
title_specific=specific_obj.title,
title_specific_es=specific_obj.title_es,
title_specific_fr=specific_obj.title_fr,
# description=specific_obj.description,
url='/'.join(specific_obj.getPhysicalPath()),
selected_specific='',
icon_url='++theme++gwopa.theme/assets/images/' + capacitychanges_obj.id + '.png',
icon_url_selected='++theme++gwopa.theme/assets/images/w-' + capacitychanges_obj.id + '.png',
icon_basic='++theme++gwopa.theme/assets/images/g-' + capacitychanges_obj.id + '.png',
short_category=category,
baseline=specific_obj.baseline,
baseline_date=specific_obj.baseline_date,
objective=specific_obj.objective,
objective_date=specific_obj.objective_date,
degree_changes='',
contributed_project='',
contributing_factors='',
obstacles='',
consensus='',
explain='',
selected_monitoring='notset',
)
monitoring.append(outcomeccmonitoring_info)
data = dict(real='', planned='', monitoring=monitoring, generic=generic, specifics=specifics)
KEY = "GWOPA_TARGET_YEAR_" + str(x + 1)
annotations[KEY] = data
logger.info('Create annotations in working area {} project {} id {}'.format(content.title, content.__parent__.title, content.__parent__.id))
def projectAdded(content, event):
""" Project created handler to assign geolocation.
Copy value from behaviour fields to project fields.projectAnd create
current year
"""
logger.info('Create add project {} id {}'.format(content.title, content.id))
# Grant Editor/Reader role to members in project
if content.members:
for user in content.members:
api.user.grant_roles(username=user, obj=content, roles=['Reader'])
if content.project_manager:
for user in content.project_manager:
api.user.grant_roles(username=user, obj=content, roles=['Reader'])
if content.project_manager_admin:
api.user.grant_roles(username=content.project_manager_admin, obj=content, roles=['Contributor', 'Editor', 'Reader'])
logger.info('Permissions to members in project {} id {}'.format(content.title, content.id))
wop_partners = getUsersRegionalWOPPlatform(content.wop_platform)
if wop_partners:
for user in wop_partners:
api.user.grant_roles(username=user, obj=content, roles=['Editor', 'Reader'])
logger.info('Permissions to wop_partners in project {} id {}'.format(content.title, content.id))
wop_programs = getUsersWOPProgram(content.wop_program)
if wop_programs:
for user in wop_programs:
api.user.grant_roles(username=user, obj=content, roles=['Editor', 'Reader'])
logger.info('Permissions to wop_programs in project {} id {}'.format(content.title, content.id))
# Assign fases to internal field
content.gwopa_year_phases = int(
math.ceil(float((content.completionactual - content.startactual).days) / float(365)))
# Asign default image if not set
if content.image is None:
data = requests.get(api.portal.get().aq_parent.absolute_url(
) + '/++theme++gwopa.theme/assets/images/default_image.jpg', verify=False, timeout=10).content
default_image = NamedBlobImage(data=data,
filename=u'image.jpg',
contentType='image/jpeg')
content.image = default_image
# Assign values to fases
fases = int(math.ceil(float((content.completionactual - content.startactual).days) / float(365)))
date1 = content.startactual
date2 = content.completionactual
if date2.month < date1.month or (date2.month == date1.month and date2.day < date1.day):
rangeDates = range(date2.year - date1.year)
else:
rangeDates = range(date2.year - date1.year + 1)
datas = [(date1 + relativedelta(years=i)).strftime("%B %d, %Y")
for i in rangeDates] + [date2.strftime("%B %d, %Y")]
isodate = [(date1 + relativedelta(years=i)).strftime("%Y-%m-%d")
for i in rangeDates] + [date2.strftime("%Y-%m-%d")]
patterndate = [(date1 - dateutil.relativedelta.relativedelta(months=1) + relativedelta(years=i)).strftime(
"%Y %m %d").replace(' 0', ' ').replace(' ', ',') for i in rangeDates]
patterndate.append((date2 - dateutil.relativedelta.relativedelta(months=1)
).strftime("%Y %m %d").replace(' 0', ' ').replace(' ', ','))
results = []
if fases > 1:
count = 0
while count != fases:
results.append(dict(
start=datas[0 + count],
end=datas[1 + count],
start_iso=isodate[0 + count],
end_iso=isodate[1 + count],
pattern_start=patterndate[0 + count],
pattern_end=patterndate[1 + count],
fase=count + 1
))
count = count + 1
else:
count = 0
results.append(dict(
start=datas[0],
end=datas[1],
start_iso=isodate[0],
end_iso=isodate[1],
pattern_start=patterndate[0],
pattern_end=patterndate[1],
fase=1
))
content.gwopa_year_phases = results
logger.info('Fases project {} id {}'.format(content.title, content.id))
measuring_frequency = content.measuring_frequency
if measuring_frequency:
frequency = int(measuring_frequency[-1])
if frequency == 4:
N_MONTHS = 3
elif frequency == 2:
N_MONTHS = 6
elif frequency == 1:
N_MONTHS = 12
reports = []
N_DAYS_AGO = 15
if content.project_manager_admin:
user = api.user.get(content.project_manager_admin)
email = user.getProperty('email')
if fases > 1:
count = 0
while count != fases:
count = count + 1
date_start_year = datetime.strptime(results[count-1]['start'], "%B %d, %Y").date()
for i in range(frequency):
date_generate_report = date_start_year + relativedelta(months=N_MONTHS)
if date2 >= date_generate_report and date2 != date_start_year:
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
date_start_year = date_generate_report
elif date2 == date_start_year:
break
else:
date_generate_report = date2
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
break
else:
count = 0
for i in range(frequency):
date_generate_report = date1 + relativedelta(months=N_MONTHS)
if date2 > date_generate_report:
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count + 1,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
date1 = date_generate_report
elif date2 == date1:
break
else:
date_generate_report = date2
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count + 1,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
break
content.gwopa_reporting = reports
logger.info('Dates to reporting project {} id {}'.format(content.title, content.id))
# Create default needed folders in the new project
api.content.create(
type='Folder',
id='files',
title='Files',
container=content)
logger.info('Create folder files in project {} id {}'.format(content.title, content.id))
api.content.create(
type='Folder',
id='contribs',
title='Contributors',
container=content)
logger.info('Create folder contributors in project {} id {}'.format(content.title, content.id))
reports = api.content.create(
type='Folder',
id='reports',
title='Reports',
container=content)
logger.info('Create folder reports in project {} id {}'.format(content.title, content.id))
partnerships = api.content.create(
type='Folder',
id='partnerships',
title='Partnerships',
container=content)
logger.info('Create folder partnerships in project {} id {}'.format(content.title, content.id))
behavior = ISelectableConstrainTypes(reports)
behavior.setConstrainTypesMode(1)
behavior.setLocallyAllowedTypes(('File', 'Report'))
behavior.setImmediatelyAddableTypes(('File', 'Report'))
behaviorp = ISelectableConstrainTypes(partnerships)
behaviorp.setConstrainTypesMode(1)
behaviorp.setLocallyAllowedTypes(('PartnershipPractice', 'Folder'))
behaviorp.setImmediatelyAddableTypes(('PartnershipPractice', 'Folder'))
# Create Working Areas
areas = content.areas
if areas:
for area in areas:
data = api.content.find(portal_type="ItemArea", Title=quote_chars(area))[0]
obj = api.content.create(
type='ImprovementArea',
title=data.Title,
title_es=data.title_es,
title_fr=data.title_fr,
description=data.Description,
image=data.getObject().image,
container=content)
logger.info('Create working area {} in project {} id {}'.format(data.Title, content.title, content.id))
logger.info('Finish create working areas in project {} id {}'.format(content.title, content.id))
partners = content.partners
if partners:
for partner in partners:
obj = api.content.create(
type='ContribPartner',
title=partner,
container=content.contribs)
obj.incash = 0
obj.inkind = 0
logger.info('Create partner {} in project {} id {}'.format(partner, content.title, content.id))
content.total_budget = 0
donors = content.donors
if donors:
for donor in donors:
obj = api.content.create(
type='ContribDonor',
title=donor,
container=content.contribs)
obj.incash = 0
obj.inkind = 0
logger.info('Create donor {} in project {} id {}'.format(donor, content.title, content.id))
path_files = '/'.join(content.files.getPhysicalPath())
folder_files = api.content.find(portal_type="Folder", path=path_files)
obj_files = folder_files[0].getObject()
# Grant Contributor role to members in folder files project
if content.members:
for user in content.members:
api.user.grant_roles(username=user, obj=obj_files, roles=['Contributor'])
if content.project_manager:
for user in content.project_manager:
api.user.grant_roles(username=user, obj=obj_files, roles=['Contributor'])
# Create Partnership Practice
config_folder = api.content.find(type='Folder',id='partnershippractice')
config_folder = config_folder[0].getObject()
items = api.content.find(
portal_type=['PartnershipPractice'],
context=config_folder,
sort_on='getObjPositionInParent')
if items:
for item in items:
partnership = item.getObject()
obj = api.content.create(
type='PartnershipPractice',
title=partnership.title,
title_es=partnership.title_es,
title_fr=partnership.title_fr,
description=partnership.description,
description_es=partnership.description_es,
description_fr=partnership.description_fr,
container=content.partnerships)
logger.info('Create parthership practice {} in project {} id {}'.format(data.Title, content.title, content.id))
logger.info('Finish create parthership practice in project {} id {}'.format(content.title, content.id))
logger.info('Finish add project {} id {}'.format(content.title, content.id))
def projectModified(content, event):
""" Project modified handler.
Create new areas.newSometimes this code is executed and the project is not edited.
In example, changing permissions, this hook is executed.
We check the transition when edit, and seems to be:
zope.lifecycleevent.ObjectModifiedEvent
"""
# Really check if project is modified
if 'zope.lifecycleevent.ObjectModifiedEvent' in str(event):
# Grant Editor/Reader role to members in project
if content.members:
for user in content.members:
api.user.grant_roles(username=user, obj=content, roles=['Reader'])
if content.project_manager:
for user in content.project_manager:
api.user.grant_roles(username=user, obj=content, roles=['Reader'])
if content.project_manager_admin:
api.user.grant_roles(username=content.project_manager_admin, obj=content, roles=['Contributor', 'Editor', 'Reader'])
wop_partners = getUsersRegionalWOPPlatform(content.wop_platform)
if wop_partners:
for user in wop_partners:
api.user.grant_roles(username=user, obj=content, roles=['Editor', 'Reader'])
wop_programs = getUsersWOPProgram(content.wop_program)
if wop_programs:
for user in wop_programs:
api.user.grant_roles(username=user, obj=content, roles=['Editor', 'Reader'])
users = [perm[0] for perm in content.get_local_roles()]
for user in users:
members = [] if content.members == None else content.members
project_manager = [] if content.project_manager == None else content.project_manager
project_manager_admin = [] if content.project_manager_admin == None else content.project_manager_admin
if user not in members and user not in project_manager and user not in project_manager_admin and user not in wop_partners and user not in wop_programs:
api.user.revoke_roles(username=user, obj=content, roles=['Contributor', 'Editor', 'Reader'])
# Asign default image if not set
if content.image is None:
data = requests.get(api.portal.get().aq_parent.absolute_url(
) + '/++theme++gwopa.theme/assets/images/default_image.jpg', verify=False, timeout=10).content
default_image = NamedBlobImage(data=data,
filename=u'image.jpg',
contentType='image/jpeg')
content.image = default_image
# Assign values to fases
fases = int(math.ceil(float((content.completionactual - content.startactual).days) / float(365)))
date1 = content.startactual
date2 = content.completionactual
if date2.month < date1.month or (date2.month == date1.month and date2.day < date1.day):
rangeDates = range(date2.year - date1.year)
else:
rangeDates = range(date2.year - date1.year + 1)
datas = [(date1 + relativedelta(years=i)).strftime("%B %d, %Y")
for i in rangeDates] + [date2.strftime("%B %d, %Y")]
isodate = [(date1 + relativedelta(years=i)).strftime("%Y-%m-%d")
for i in rangeDates] + [date2.strftime("%Y-%m-%d")]
patterndate = [(date1 - dateutil.relativedelta.relativedelta(months=1) + relativedelta(years=i)).strftime(
"%Y %m %d").replace(' 0', ' ').replace(' ', ',') for i in rangeDates]
patterndate.append((date2 - dateutil.relativedelta.relativedelta(months=1)
).strftime("%Y %m %d").replace(' 0', ' ').replace(' ', ','))
results = []
if fases > 1:
count = 0
while count != fases:
results.append(dict(
start=datas[0 + count],
end=datas[1 + count],
start_iso=isodate[0 + count],
end_iso=isodate[1 + count],
pattern_start=patterndate[0 + count],
pattern_end=patterndate[1 + count],
fase=count + 1
))
count = count + 1
else:
count = 0
results.append(dict(
start=datas[0],
end=datas[1],
start_iso=isodate[0],
end_iso=isodate[1],
pattern_start=patterndate[0],
pattern_end=patterndate[1],
fase=1
))
content.gwopa_year_phases = results
measuring_frequency = content.measuring_frequency
if measuring_frequency:
frequency = int(measuring_frequency[-1])
if frequency == 4:
N_MONTHS = 3
elif frequency == 2:
N_MONTHS = 6
elif frequency == 1:
N_MONTHS = 12
reports = []
N_DAYS_AGO = 15
if content.project_manager_admin:
user = api.user.get(content.project_manager_admin)
email = user.getProperty('email')
if fases > 1:
count = 0
while count != fases:
count = count + 1
date_start_year = datetime.strptime(results[count-1]['start'], "%B %d, %Y").date()
# date_end_year = datetime.strptime(results[count-1]['end'], "%B %d, %Y").date()
for i in range(frequency):
date_generate_report = date_start_year + relativedelta(months=N_MONTHS)
if date2 >= date_generate_report and date2 != date_start_year:
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
date_start_year = date_generate_report
elif date2 == date_start_year:
break
else:
date_generate_report = date2
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
break
else:
count = 0
for i in range(frequency):
date_generate_report = date1 + relativedelta(months=N_MONTHS)
if date2 > date_generate_report:
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count + 1,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
date1 = date_generate_report
elif date2 == date1:
break
else:
date_generate_report = date2
data_email_report = date_generate_report - relativedelta(days=N_DAYS_AGO)
reports.append(dict(
date_generate_report=date_generate_report.strftime("%B %d, %Y"),
date_email_report=data_email_report.strftime("%B %d, %Y"),
num_report=i + 1,
project_year=count + 1,
project_url=content.absolute_url(),
project_title=content.title,
email=email,
frequency=measuring_frequency[:-2],
))
break
content.gwopa_reporting = reports
logger.info('Dates to reporting project {} id {}'.format(content.title.encode('utf-8'), content.id))
# Assign Areas
new_areas = content.areas
current = [a.id for a in api.content.find(
portal_type="ImprovementArea", context=content, depth=1)]
new_areas = content.areas
if new_areas is None:
return
else:
for area in new_areas:
if area not in current:
data = api.content.find(portal_type="ItemArea", id=quote_chars(area))[0]
if data.id not in content:
api.content.create(
type=u'ImprovementArea',
id=data.id,
title=data.Title.decode('utf-8'),
title_es=data.title_es,
title_fr=data.title_fr,
description=data.Description,
image=data.getObject().image,
container=content)
# Delete Areas
delete_areas = list(set(current) - set(new_areas))
for area in delete_areas:
item = api.content.find(portal_type="ImprovementArea", id=quote_chars(area), context=content)
if item:
api.content.delete(obj=item[0].getObject(), check_linkintegrity=False)
# Modify project_dates and currency
project_path = '/'.join(content.getPhysicalPath())
activities = api.content.find(portal_type="Activity", path=project_path)
for activity in activities:
item = activity.getObject()
project_dates = "The dates must be between the limits of this Project. Start: " + str(content.startactual) + " End: " + str(content.completionactual)
if item.project_dates != project_dates:
item.project_dates = project_dates
item.currency = project_currency(content)
item.reindexObject()
path = '/'.join(content.contribs.getPhysicalPath())
partners = content.partners
if partners:
for partner in partners:
item = api.content.find(
portal_type='ContribPartner',
Title=quote_chars(partner),
path=path)
if not item:
obj = api.content.create(
type='ContribPartner',
title=partner,
container=content.contribs)
obj.incash = 0
obj.inkind = 0
else:
partners = []
all_partners = []
items_partners = api.content.find(
portal_type='ContribPartner',
path=path)
for item_partner in items_partners:
item_partner_obj = item_partner.getObject()
all_partners.append(item_partner_obj.title)
for item in all_partners:
if item not in partners:
obj = api.content.find(
portal_type='ContribPartner',
Title=quote_chars(item),
path=path)
api.content.delete(obj=obj[0].getObject(), check_linkintegrity=False)
donors = content.donors
if donors:
for donor in donors:
item = api.content.find(
portal_type='ContribDonor',
Title=quote_chars(donor),
path=path)
if not item:
obj = api.content.create(
type='ContribDonor',
title=donor,
container=content.contribs)
obj.incash = 0
obj.inkind = 0
else:
donors = []
all_donors = []
items_donors = api.content.find(
portal_type='ContribDonor',
path=path)
for item_donor in items_donors:
item_donor_obj = item_donor.getObject()
all_donors.append(item_donor_obj.title)
for item in all_donors:
if item not in donors:
obj = api.content.find(
portal_type='ContribDonor',
Title=quote_chars(item),
path=path)
api.content.delete(obj=obj[0].getObject(), check_linkintegrity=False)
path_files = '/'.join(content.files.getPhysicalPath())
folder_files = api.content.find(portal_type="Folder", path=path_files)
obj_files = folder_files[0].getObject()
# Grant Contributor role to members in folder files project
if content.members:
for user in content.members:
api.user.grant_roles(username=user, obj=obj_files, roles=['Contributor'])
if content.project_manager:
for user in content.project_manager:
api.user.grant_roles(username=user, obj=obj_files, roles=['Contributor'])
# Partnership practice
try:
partnerships = content.partnerships
except:
partnerships = api.content.create(
type='Folder',
id='partnerships',
title='Partnerships',
container=content)
logger.info('Create folder partnerships in project {} id {}'.format(content.title, content.id))
behaviorp = ISelectableConstrainTypes(partnerships)
behaviorp.setConstrainTypesMode(1)
behaviorp.setLocallyAllowedTypes(('PartnershipPractice', 'Folder'))
behaviorp.setImmediatelyAddableTypes(('PartnershipPractice', 'Folder'))
current_partnerships = [a.id for a in api.content.find(
portal_type="PartnershipPractice", context=content.partnerships, depth=1)]
config_folder = api.content.find(type='Folder',id='partnershippractice')
config_folder = config_folder[0].getObject()
partnerships_default = api.content.find(
portal_type=['PartnershipPractice'],
context=config_folder,
sort_on='getObjPositionInParent')
for partnership in partnerships_default:
if partnership.id not in current_partnerships:
partnership = partnership.getObject()
obj = api.content.create(
type='PartnershipPractice',
title=partnership.title,
title_es=partnership.title_es,
title_fr=partnership.title_fr,
description=partnership.description,
description_es=partnership.description_es,
description_fr=partnership.description_fr,
container=content.partnerships)
def getTranslatedOutcomesFromTitle(title):
attr_lang = getTitleAttrLang()
outcome = api.content.find(portal_type=['Outcomedefaults'],
Title=quote_chars(title.encode('utf-8')))
return getattr(outcome[0], attr_lang) if outcome else title