def User_Index():
menu='recording'
submenu='user'
agency_user = None
if current_user.has_roles('manager_agency'):
agency_user = AgencyModel.get_by_id(int(session.get('agence_id_local')))
admin_role = RoleModel.query(
RoleModel.name == 'admin'
).get()
super_admin_role = RoleModel.query(
RoleModel.name == 'super_admin'
).get()
user_admin = []
if admin_role:
user_admin = UserRoleModel.query(
ndb.OR(
UserRoleModel.role_id == super_admin_role.key,
UserRoleModel.role_id == admin_role.key
)
)
user_admins = [users.user_id for users in user_admin]
user = UserRoleModel.query(
projection=[UserRoleModel.user_id],
group_by=[UserRoleModel.user_id]
)
return render_template('/user/index-user.html', **locals())
def Super_Admin_Create():
form = FormRegisterUserAdmin(request.form)
if form.validate_on_submit():
User = UserModel()
role = RoleModel.query(RoleModel.name == 'super_admin').get()
if not role:
role = RoleModel()
role.name = 'super_admin'
role.visible = False
role = role.put()
role = RoleModel.get_by_id(role.id())
UserRole = UserRoleModel()
currency = CurrencyModel.query(
CurrencyModel.code == "XAF"
).get()
if not currency:
CurrencyCreate = CurrencyModel()
CurrencyCreate.code = form.currency.data
CurrencyCreate.name = 'Franc CFA'
currencyCreate = CurrencyCreate.put()
currencyCreate = CurrencyModel.get_by_id(currencyCreate.id())
else:
currencyCreate = currency
if role:
User.first_name = form.first_name.data
User.last_name = form.last_name.data
User.email = form.email.data
User.currency = currencyCreate.key
password = hashlib.sha224(form.password.data).hexdigest()
User.password = password
UserCreate = User.put()
UserCreate = UserModel.get_by_id(UserCreate.id())
UserRole.role_id = role.key
UserRole.user_id = UserCreate.key
UserRole.put()
return redirect(url_for('Home'))
return render_template('user/edit-super-admin.html', **locals())
def User_Admin_Index():
menu='settings'
submenu ='user_admin'
from ..activity.models_activity import ActivityModel
feed = ActivityModel.query(
ndb.OR(
ActivityModel.object == 'UserModel',
# ActivityModel.object == 'UserLogin'
)
).order(
-ActivityModel.time
)
feed_tab = []
count = 0
for feed in feed:
vess = UserModel.get_by_id(feed.identity)
if vess and vess.has_roles('admin') and current_user.has_roles('admin'):
feed_list = {}
feed_list['user'] = feed.user_modify
feed_list['data'] = vess.last_name+" "+vess.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if vess and vess.has_roles(('admin','super_admin')) and current_user.has_roles('super_admin'):
feed_list = {}
feed_list['user'] = feed.user_modify
feed_list['data'] = vess.last_name+" "+vess.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if count > 5 and not request.args.get('modal'):
count += 1
break
if request.args.get('modal'):
return render_template('/user/all_feed.html', **locals())
User = UserRoleModel.query()
user_admin = []
for user in User:
if (user.role_id.get().name == "admin" or user.role_id.get().name == "super_admin") and current_user.has_roles('super_admin'):
user_admin.append(user)
if user.role_id.get().name == "admin" and not current_user.has_roles('super_admin'):
user_admin.append(user)
return render_template('/user/index.html', **locals())
def User_Edit(user_id=None):
menu = 'recording'
submenu = 'user'
from ..activity.models_activity import ActivityModel
time_zones = pytz.timezone('Africa/Douala')
date_auto_nows = datetime.datetime.now(time_zones).strftime("%Y-%m-%d %H:%M:%S")
activity = ActivityModel()
activity.user_modify = current_user.key
activity.object = "UserModel"
activity.time = function.datetime_convert(date_auto_nows)
number_list = global_dial_code_custom
# recuperation du role admin
role = RoleModel.query(
RoleModel.name == 'admin'
).get()
profil_admin = ProfilRoleModel.query(
ProfilRoleModel.role_id == role.key
).get()
if not profil_admin:
flash('you do not create admin profiles', 'danger')
return redirect(url_for('User_Index'))
profils = ProfilRoleModel.query(
ProfilRoleModel.profil_id != profil_admin.profil_id,
projection=[ProfilRoleModel.profil_id],
group_by=[ProfilRoleModel.profil_id]
)
#liste des agences dans l'application
agency = AgencyModel.query(
AgencyModel.is_achouka == True
)
if current_user.has_roles('manager_agency') and not current_user.has_roles('admin'):
agency_user = AgencyModel.get_by_id(int(session.get('agence_id')))
feed_tab = []
if user_id:
User = UserModel.get_by_id(user_id)
form = FormEditUser(obj=User)
feeds = ActivityModel.query(
ActivityModel.object == 'UserModel',
ActivityModel.identity == User.key.id()
).order(
-ActivityModel.time
)
count = 0
for feed in feeds:
feed_list = {}
feed_list['user'] = feed.user_modify
vess = UserModel.get_by_id(feed.identity)
feed_list['data'] = vess.last_name+" "+vess.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if count > 5:
count += 1
break
else:
form = FormRegisterUser(request.form)
User = UserModel()
if form.validate_on_submit():
profil = ProfilModel.get_by_id(int(form.profil.data))
agency = AgencyModel.get_by_id(int(form.agency.data))
# supprimer les roles lors de la modification du profil
if User.profil and User.profil != profil.key and user_id:
role_del = ProfilRoleModel.query(
ProfilRoleModel.profil_id == User.profil
)
for role_del in role_del:
remove_role = UserRoleModel.query(
UserRoleModel.role_id == role_del.role_id,
UserRoleModel.user_id == User.key
).get()
remove_role.key.delete()
User.first_name = form.first_name.data
User.last_name = form.last_name.data
User.phone = form.phone.data
User.dial_code = form.dial_code.data
User.profil = profil.key
if agency:
User.agency = agency.key
if not user_id:
User.email = form.email.data
password = hashlib.sha224(form.password.data).hexdigest()
User.password = password
try:
if not user_id:
token_mail = str(hashlib.sha224(form.email.data).hexdigest())
server_url = app_identity.get_default_version_hostname()
confirm_url = "http://"+server_url+""+url_for('email_confirm', token=token_mail)
send_mail(sender="*****@*****.**",
to=str(form.email.data),
subject="Achouka : Confirm your email address",
body="""
Thank you for creating an account! Please confirm your email address by clicking on the link below:
%s
""" % confirm_url)
User.confirmed_token = token_mail
UserCreate = User.put()
#recuperation de chaque role appartenant au profil choisie
all_role = ProfilRoleModel.query(
ProfilRoleModel.profil_id == profil.key
)
# insertion de chaque role a l'utilisateur cree
this_user = UserCreate = UserModel.get_by_id(UserCreate.id())
for role in all_role:
UserRole = UserRoleModel()
UserRole.role_id = role.role_id
UserRole.user_id = UserCreate.key
UserRole.put()
if user_id:
activity.identity = user_id
activity.nature = 4
activity.put()
flash('User Updated', 'success')
else:
activity.identity = this_user.key.id()
activity.nature = 1
activity.put()
flash('User Created', 'success')
return redirect(url_for('User_Index'))
except InvalidEmailError:
flash('Your email address is not valid or does not exist', 'danger')
return render_template('/user/edit-user.html', **locals())
def User_Index():
menu='recording'
submenu='user'
agency_user = None
if current_user.has_roles('manager_agency') and not current_user.has_roles(('admin', 'super_admin')):
agency_user = AgencyModel.get_by_id(int(session.get('agence_id')))
from ..activity.models_activity import ActivityModel
feed = ActivityModel.query(
ndb.OR(
ActivityModel.object == 'UserModel',
# ActivityModel.object == 'UserLogin'
)
).order(
-ActivityModel.time
)
feed_tab = []
count = 0
for feed in feed:
user = UserModel.get_by_id(feed.identity)
if user and not current_user.has_roles(('admin', 'super_admin')) and agency_user and user.agency == agency_user.key and user.agency:
feed_list = {}
feed_list['user'] = feed.user_modify
feed_list['data'] = user.last_name+" "+user.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if user and current_user.has_roles(('admin', 'super_admin')):
feed_list = {}
feed_list['user'] = feed.user_modify
feed_list['data'] = user.last_name+" "+user.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if count > 5 and not request.args.get('modal'):
count += 1
break
if request.args.get('modal'):
return render_template('/user/all_feed.html', **locals())
admin_role = RoleModel.query(
RoleModel.name == 'admin'
).get()
super_admin_role = RoleModel.query(
RoleModel.name == 'super_admin'
).get()
user_admin = []
if admin_role:
user_admin = UserRoleModel.query(
ndb.OR(
UserRoleModel.role_id == super_admin_role.key,
UserRoleModel.role_id == admin_role.key
)
)
user_admins = [users.user_id for users in user_admin]
user = UserRoleModel.query(
projection=[UserRoleModel.user_id],
group_by=[UserRoleModel.user_id]
)
return render_template('/user/index-user.html', **locals())
def User_Admin_Edit(user_id=None):
menu='settings'
submenu ='user_admin'
from ..activity.models_activity import ActivityModel
time_zones = pytz.timezone('Africa/Douala')
date_auto_nows = datetime.datetime.now(time_zones).strftime("%Y-%m-%d %H:%M:%S")
number_list = global_dial_code_custom
# recuperation du role admin
role = RoleModel.query(
RoleModel.name == 'admin'
).get()
if not role:
flash('you do not create admin role', 'danger')
return redirect(url_for('User_Admin_Index'))
#liste des devises pour les administrateurs
currency = CurrencyModel.query()
#liste des agences dans l'application
agency = AgencyModel.query(
AgencyModel.is_achouka == True
)
feed_tab = []
if user_id:
User = UserModel.get_by_id(user_id)
form = FormEditUserAdmin(obj=User)
feed = ActivityModel.query(
ActivityModel.object == 'UserModel',
ActivityModel.identity == User.key.id()
).order(
-ActivityModel.time
)
count = 0
for feed in feed:
feed_list = {}
feed_list['user'] = feed.user_modify
vess = UserModel.get_by_id(feed.identity)
feed_list['data'] = vess.last_name+" "+vess.first_name
feed_list['time'] = feed.time
feed_list['nature'] = feed.nature
feed_list['id'] = feed.identity
feed_tab.append(feed_list)
count += 1
if count > 5:
count += 1
break
else:
form = FormRegisterUserAdmin(request.form)
User = UserModel()
activity = ActivityModel()
activity.user_modify = current_user.key
activity.object = "UserModel"
activity.time = function.datetime_convert(date_auto_nows)
if form.validate_on_submit():
ProfilRole = ProfilRoleModel.query(
ProfilRoleModel.role_id == role.key
).count()
if ProfilRole == 1:
profil = ProfilRoleModel.query(
ProfilRoleModel.role_id == role.key
).get()
User.first_name = form.first_name.data
User.last_name = form.last_name.data
User.phone = form.phone.data
User.dial_code = form.dial_code.data
User.agency = None
if not user_id:
User.email = form.email.data
password = hashlib.sha224(form.password.data).hexdigest()
User.password = password
try:
if not user_id: # si c'est une creation, Envoie l'email de confirmation
token_mail = str(hashlib.sha224(form.email.data).hexdigest())
server_url = app_identity.get_default_version_hostname()
confirm_url = "http://"+server_url+""+url_for('email_confirm', token=token_mail)
send_mail(sender="*****@*****.**",
to=str(form.email.data),
subject="Achouka : Confirm your email address",
body="""
Thank you for creating an account! Please confirm your email address by clicking on the link below:
%s
""" % confirm_url)
User.confirmed_token = token_mail
UserCreate = User.put()
if not user_id:
#recuperation de chaque role appartenant au profil ayant le role admin
all_role = ProfilRoleModel.query(
ProfilRoleModel.profil_id == profil.profil_id
)
# insertion de chaque role a l'utilisateur cree
UserCreate = UserModel.get_by_id(UserCreate.id())
for role in all_role:
UserRole = UserRoleModel()
UserRole.role_id = role.role_id
UserRole.user_id = UserCreate.key
UserRole.put()
UserCreate.profil = profil.profil_id #profil pour les comptes admins
UserCreate.put()
if user_id:
activity.identity = user_id
activity.nature = 4
activity.put()
flash('User Updated', 'success')
else:
activity.identity = UserCreate.key.id()
activity.nature = 1
activity.put()
flash('User Created', 'success')
return redirect(url_for('User_Admin_Index'))
except InvalidEmailError:
flash('Your email address is not valid or does not exist', 'danger')
else:
flash('Create before profil admin with role "Admin" for this user or you have two profil have a role "Admin"', 'danger')
return render_template('/user/edit.html', **locals())
def Super_Admin_Create():
form = FormRegisterUserAdmin(request.form)
if form.validate_on_submit():
try:
token_mail = str(hashlib.sha224(form.email.data).hexdigest())
server_url = app_identity.get_default_version_hostname()
confirm_url = "http://"+server_url+""+url_for('email_confirm', token=token_mail)
send_mail(sender="*****@*****.**",
to=str(form.email.data),
subject="Achouka : Confirm your email address",
body="""
Thank you for creating an account! Please confirm your email address by clicking on the link below:
%s
""" % confirm_url)
User = UserModel()
User.confirmed_token = token_mail
role = RoleModel.query(RoleModel.name == 'super_admin').get()
if not role:
role = RoleModel()
role.name = 'super_admin'
role.visible = False
role = role.put()
role = RoleModel.get_by_id(role.id())
UserRole = UserRoleModel()
currency = CurrencyModel.query(
CurrencyModel.code == "XAF"
).get()
if not currency:
CurrencyCreate = CurrencyModel()
CurrencyCreate.code = "XAF"
CurrencyCreate.name = 'Franc CFA'
currencyCreate = CurrencyCreate.put()
currencyCreate = CurrencyModel.get_by_id(currencyCreate.id())
else:
currencyCreate = currency
if role:
User.first_name = form.first_name.data
User.last_name = form.last_name.data
User.email = form.email.data
User.currency = currencyCreate.key
password = hashlib.sha224(form.password.data).hexdigest()
User.password = password
UserCreate = User.put()
UserCreate = UserModel.get_by_id(UserCreate.id())
UserRole.role_id = role.key
UserRole.user_id = UserCreate.key
UserRole.put()
return redirect(url_for('Home'))
except InvalidEmailError:
flash('Your email address is not valid or does not exist', 'danger')
return render_template('user/edit-super-admin.html', **locals())
