def user():
if request.args(0)=='profile':
#uporabnikov Id
uid = auth.user_id
#preberem podatke za tega userja iz obeh tabel
#Skrijem nepotrebna polja
fields_to_hide_org = ['id', 'o_usern', 'o_useru', 'o_daten','o_dateu', 'o_status', 'o_code', 'o_faxnumber',\
'o_rootid', 'o_parentid', 'o_levelid', 'o_positionx','o_positiony' ]
for fieldname in fields_to_hide_org:
field = db.organizations[fieldname]
field.readable = field.writable = False
fields_to_hide_user = ['email', 'password', 'organization']
for fieldname in fields_to_hide_user:
field = db.auth_user[fieldname]
field.readable = field.writable = False
#org_name = db(
db.organization.id == record["organization"]).select(db.organization.o_name).as_list()[0]["o_name"]
#nastavim vrednsoti polj, ki so ze v bazi
authfields = [field for field in db.auth_user if
field.name != 'id']
#print record
for field in authfields:
#print field
orgfields = [field for field in db.organizations if
field.name != 'id']
for field in orgfields:
# db.auth_user.first_name.default = record["auth_user"]["first_name"]
# db.auth_user.last_name.default = record["auth_user"]["last_name"]
# db.organization.o_name.default = record["organization"]["o_name"]
form=SQLFORM.factory(db.auth_user,db.organizations, keepvalues = True)
orgid = record["organizations"]['id']
#print orgid
if form.process().accepted:
#Updatam polja v bazi
org_forma = db.organizations._filter_fields(form.vars)
for key, value in org_forma.iteritems():
#print key, value
db(db.organizations._id==orgid).update(**{key:value})
user_forma = db.auth_user._filter_fields(form.vars)
for key, value in user_forma.iteritems():
db(db.auth_user._id==orgid).update(**{key:value})
response.flash=T('Thanks for filling the form')
redirect(URL('index'))
return dict(form=form)
form = auth()
"""
Tole je sedaj tukaj ker ni delal foreing kej na auth_user.organization
"""
if request.args(0) == 'register':
if form.process().accepted:
database = str(db).rpartition('/')[-1].replace('">', '')
host = request.http_host
port = request.http_port
app = request.application
if host:
name = '%s/%s' % (host, app)
else:
name = app
email = form.vars.email
add_organization(form, userid)
formFile = os.path.join(request.folder, 'private', 'formular_woshi_2016-02-01.rtf')
regKey = db(
db.auth_user.id == userid).select(db.auth_user.registration_key).first()
key = regKey.registration_key
message_content = T('Click on the link ') + '
http://shift.workerscheduling.com' + URL(r=request,c='default',f='user',args=['verify_email']) + '/%s ' % (key) + T('to verify your email')
mail.send(to=[email],
subject='Woshi confirm registration',
message=message_content,
attachments = mail.Attachment(formFile, content_id='file')
)
mail.send(to = dddd',
subject= 'New user registered in WoShi',
message = 'A new user with e-mail address ' + email + ' has registered to Woshi with url address ' + name + ' in database ' + database
)
session.flash= "Please check your e-mail to confirm registration"
redirect(URL('index'))
return dict(form = form)