def get_fullnames():
"""map of user fullnames"""
ret = frappe.db.sql("""select name,
concat(ifnull(first_name, ''),
if(ifnull(last_name, '')!='', ' ', ''), ifnull(last_name, '')) as fullname,
user_image as image, gender, email
from tabUser where ifnull(enabled, 0)=1 and user_type!="Website User" """, as_dict=1)
d = {}
for r in ret:
if not r.image:
r.image = get_gravatar()
d[r.name] = r
return d
def get_fullnames():
"""map of user fullnames"""
ret = frappe.db.sql("""select name,
concat(ifnull(first_name, ''),
if(ifnull(last_name, '')!='', ' ', ''), ifnull(last_name, '')) as fullname,
user_image as image, gender, email, username
from tabUser where enabled=1 and user_type!="Website User" """, as_dict=1)
d = {}
for r in ret:
if not r.image:
r.image = get_gravatar()
d[r.name] = r
return d
def update_lphr_barcode(path, profile_id):
cie = frappe.db.get_value("LinkedPHR Images", {"profile_id": profile_id},
"barcode")
uimage = get_gravatar(profile_id)
file_path = '/files/' + profile_id + '/' + profile_id + ".svg"
if cie:
frappe.db.sql("""update `tabLinkedPHR Images`
set barcode='%s',profile_image='%s' where profile_id='%s'""" %
(file_path, uimage, profile_id))
frappe.db.commit()
sub = "Barcode Uploaded Successfully " + path
make_log(profile_id, "profile", "Linked PHR Image Upload", sub)
return "Image Uploaded Successfully"
else:
lp = frappe.new_doc("LinkedPHR Images")
lp.profile_id = profile_id
lp.barcode = file_path
lp.save(ignore_permissions=True)
sub = "Barcode Uploaded Successfully " + file_path
make_log(profile_id, "profile", "Linked PHR Image Upload", sub)
return "Image Uploaded Successfully"
def update_gravatar(self):
if not self.user_image:
self.user_image = get_gravatar(self.name)
def update_gravatar(self): if not self.user_image: self.user_image = get_gravatar(self.name)
