def getHTML(self, info, selfInfo, event):
super(CommonRenderer, self).getHTML(info, selfInfo, event)
# build html for company name
comp = u""
if info["company_name"]:
if "company_detail_url" in info and info["company_detail_url"]:
comp += "<a href='%s'>%s</a>" % (
cgi.escape(mr(info["company_detail_url"])),
cgi.escape(mr(info["company_name"])),
)
else:
comp += cgi.escape(mr(info["company_name"]))
# build html for contact name
cont = u""
if info["contact_name"]:
if "contact_detail_url" in info and info["contact_detail_url"]:
cont += "<a href='%s'>%s</a>" % (
cgi.escape(mr(info["contact_detail_url"])),
cgi.escape(mr(info["contact_name"])),
)
else:
cont += cgi.escape(mr(info["contact_name"]))
# build actual html section
html = u"<b>%s:</b>\n" % cgi.escape(_("Attendee"))
if cont:
html += cont
if comp:
html += " (" + comp + ")"
elif comp:
html += comp
if "Duration" in event:
duration = int(float(event["Duration"]))
html += "\n\n<b>%s:</b> " % cgi.escape(_("Duration"))
html += "%d'%02d\"\n" % (duration / 60, duration % 60)
return html
def getHTML(self, particiantInfo, selfInfo, event):
super(GOForgeRenderer, self).getHTML(particiantInfo, selfInfo, event)
if not "company_id" in particiantInfo:
return ""
company_id = particiantInfo["company_id"]
if not company_id:
return ""
# prepare result
result = []
html = ""
# Connect to GOforge db
sess = self.env.getDatabaseSession("fetcher-goforge")
# obtain GOforge internal customer id
res = sess.execute(
select(
["customer_id"], Column(String(), name="customer_unique_ldap_attribute").__eq__(company_id), "customer"
)
)
if res.rowcount == 1:
row = res.fetchone()
# fetch tickets from database
m = MetaData()
bug = Table(
"bug",
m,
Column("bug_id", Integer),
Column("summary", String),
Column("group_id", String),
Column("status_id", Integer),
Column("assigned_to", Integer),
Column("customer_id", Integer),
)
user = Table("user", m, Column("user_name", String), Column("user_id", Integer))
rows = sess.execute(
select(
[bug.c.bug_id, bug.c.summary, bug.c.group_id, user.c.user_name],
and_(bug.c.status_id == 1, bug.c.assigned_to == user.c.user_id, bug.c.customer_id == row[0]),
[bug, user],
).limit(29)
).fetchall()
# put results into dictionary
for row in rows:
result.append({"id": row[0], "summary": row[1], "group_id": row[2], "assigned": row[3]})
if len(result) == 0:
sess.close()
return ""
html = u"<b>%s</b>" % _("GOForge tickets")
for row in result:
html += u"\n<a href='%s'>%s</a> %s" % (
self.forge_url
+ "/bugs/?func=detailbug"
+ "&bug_id="
+ str(row["id"])
+ "&group_id="
+ str(row["group_id"]),
row["id"],
cgi.escape(mr(row["summary"])),
)
sess.close()
return html
def getHTML(self, particiantInfo, selfInfo, event):
super(DoingReportRenderer, self).getHTML(particiantInfo, selfInfo, event)
if event['Type'] != "CallEnded":
return ""
if not "Duration" in event:
return ""
ldap_uid = selfInfo['ldap_uid'] if 'ldap_uid' in selfInfo else None
if not ldap_uid:
return ""
# Filter out white listed users
if self.whitelisted_users and not ldap_uid in self.whitelisted_users:
return ""
company_id = particiantInfo['company_id'] if 'company_id' in particiantInfo else None
contact_name = particiantInfo['contact_name'] if 'contact_name' in particiantInfo else None
contact_phone = particiantInfo['contact_phone'] if 'contact_phone' in particiantInfo else None
company_name = particiantInfo['company_name'] if 'company_name' in particiantInfo else None
company_phone = particiantInfo['company_phone'] if 'company_phone' in particiantInfo else None
if not (contact_name or company_name or company_phone or contact_phone):
return ""
# Connect to GOforge db
sess = self.env.getDatabaseSession("fetcher-goforge")
# Lookup GOforge user_id from ldap_uid
res = sess.execute(select(['user_id'], Column(String(), name='user_name').__eq__(ldap_uid), 'user')).fetchone()
if not res:
sess.close()
return ""
user_id = int(res[0])
# Lookup GOforge customer ID from sugar company_id
customer_id = None
if company_id:
res = sess.execute(select(['customer_id'], Column(String(),
name='customer_unique_ldap_attribute').__eq__(company_id), 'customer')).fetchone()
if res:
customer_id = int(res[0])
# Assemble new entry for TB
date = datetime.strftime(datetime.utcnow(), "%Y.%m.%d")
minutes = int(math.ceil(float(event["Duration"]) / 60))
details = "Please amend"
comment = "Phone call with %s" % contact_name or contact_phone or company_name or company_phone
if customer_id:
sess.execute("""
INSERT INTO doingreport (user_id, customer_id, date, minutes, details, comments, flag)
VALUES (:user_id, :customer_id, :date, :minutes, :details, :comments, '?')""",
dict(
user_id=user_id,
customer_id=customer_id,
date=date,
minutes=minutes,
details=mr(details).encode('ascii', 'xmlcharrefreplace'),
comment=mr(comment).encode('ascii', 'xmlcharrefreplace')))
else:
sess.execute("""
INSERT INTO doingreport (user_id, date, minutes, details, comments, flag)
VALUES (:user_id, :date, :minutes, :details, :comments, '?')""",
dict(
user_id=user_id,
date=date,
minutes=minutes,
details=mr(details).encode('ascii', 'xmlcharrefreplace'),
comments=mr(comment).encode('ascii', 'xmlcharrefreplace')))
# Eventually we need to create an entry in doing_account in order
# to make the TB editable.
res = sess.execute(select(['id'], and_(
Column(String(), name='date').__eq__(date),
Column(String(), name='user_id').__eq__(user_id)),
'doing_account')).fetchone()
if not res:
sess.execute("""
INSERT INTO doing_account (date, user_id, account_user, account_billing)
VALUES(:date, :user_id, 'no', 'no');
""", dict(date=date, user_id=user_id))
sess.close()
return ""