def insert():
if request.method == 'POST':
if request.form['birthdate']:
b_date = datetime.strptime(request.form['birthdate'], '%m/%d/%Y')
else:
b_date = None
p = PersonInfo(cn_name=request.form['cn_name'],
en_name=request.form['en_name'],
gender=request.form['gender'],
birthdate=b_date,
id_num=request.form['id_num'],
permit_num=request.form['permit_num'],
passport=request.form['passport'],
home_address=request.form['home_address'],
post_address=request.form['post_address'],
company_address=request.form['company_address'],
occupation=request.form['occupation'],
private_phone=request.form['private_phone'],
office_phone=request.form['company_phone'],
fax=request.form['fax'],
email=request.form['email'],
internet_account=request.form['internet_account'],
home_page=request.form['homepage'],
bank_account=request.form['bank_account'],
other_number=request.form['other_number'],
family=request.form['family'],
hobby=request.form['hobby'],
experience=request.form['experience'],
event=request.form['event'],
stain=request.form['stain'])
if request.form['party']:
tag_list = [
x.party_name
for x in PartyInfo.query.distinct(PartyInfo.party_name).all()
]
for item in request.form['party'].split('-'):
if item in tag_list:
tag = PartyInfo.query.filter_by(party_name=item).first()
else:
tag = PartyInfo(item)
p.partytag.append(tag)
else:
p.partytag = [PartyInfo('')]
if request.form['picture']:
for item in request.form['picture'].split('\n'):
avt = Avatar(item)
p.avatar.append(avt)
db.session.add(p)
db.session.commit()
return redirect(url_for('profile.detail', person_id=p.id))
else:
return render_template('insert.html')
def edit(person_id=0):
p = PersonInfo.query.get(person_id)
if request.method == 'POST':
if request.form['birthdate']:
b_date = datetime.strptime(request.form['birthdate'], '%m/%d/%Y')
else:
b_date = None
p.cn_name = request.form['cn_name']
p.en_name = request.form['en_name']
p.gender = request.form['gender']
p.birthdate = b_date
p.id_num = request.form['id_num']
p.permit_num = request.form['permit_num']
p.passport = request.form['passport']
p.home_address = request.form['home_address']
p.post_address = request.form['post_address']
p.company_address = request.form['company_address']
p.party_tag = request.form['party']
p.occupation = request.form['occupation']
p.private_phone = request.form['private_phone']
p.office_phone = request.form['company_phone']
p.fax = request.form['fax']
p.email = request.form['email']
p.internet_account = request.form['internet_account']
p.home_page = request.form['homepage']
p.bank_account = request.form['bank_account']
p.other_number = request.form['other_number']
p.family = request.form['family']
p.hobby = request.form['hobby']
p.experience = request.form['experience']
p.event = request.form['event']
p.stain = request.form['stain']
if request.form['picture']:
for item in request.form['picture'].split('\n'):
avt = Avatar(item)
p.avatar.append(avt)
db.session.add(p)
db.session.commit()
return redirect(url_for('profile.detail', person_id=person_id))
else:
if p.birthdate:
timestring = datetime.strftime(p.birthdate, '%m/%d/%Y')
else:
timestring = ''
return render_template('edit.html', t=timestring, p=p)
def avatar():
form = UploadAvatar()
if request.method == 'POST':
if form.validate():
avatar_f = Avatar(user=form.user.data,
filename=form.upload.data.filename
) #, avatar=form.author.data)
f_name = secure_filename(form.upload.data.filename)
form.upload.data.save('upload/avatar/' + f_name)
current_session.add(avatar_f)
current_session.commit()
flash('avatar uploaded!')
return redirect(url_for('avatar'))
else:
flash('Form is not valid!')
all_avatars = current_session.query(Avatar).all()
return render_template('avatar.html', form=form, avatars=all_avatars)
def edit(person_id=0):
p = PersonInfo.query.get(person_id)
if request.method == 'POST':
if request.form['birthdate']:
b_date = datetime.strptime(request.form['birthdate'], '%m/%d/%Y')
else:
b_date = None
p.cn_name = request.form['cn_name']
p.en_name = request.form['en_name']
p.gender = request.form['gender']
p.birthdate = b_date
p.id_num = request.form['id_num']
p.permit_num = request.form['permit_num']
p.passport = request.form['passport']
p.home_address = request.form['home_address']
p.post_address = request.form['post_address']
p.company_address = request.form['company_address']
p.occupation = request.form['occupation']
p.private_phone = request.form['private_phone']
p.office_phone = request.form['company_phone']
p.fax = request.form['fax']
p.email = request.form['email']
p.internet_account = request.form['internet_account']
p.home_page = request.form['homepage']
p.bank_account = request.form['bank_account']
p.other_number = request.form['other_number']
p.family = request.form['family']
p.hobby = request.form['hobby']
p.experience = request.form['experience']
p.event = request.form['event']
p.stain = request.form['stain']
if request.form['picture']:
for item in request.form['picture'].split('\n'):
avt = Avatar(item)
p.avatar.append(avt)
if request.form['party']:
tag_list = [
x.party_name
for x in PartyInfo.query.distinct(PartyInfo.party_name).all()
]
p.partytag = []
for item in request.form['party'].split('-'):
if item in tag_list:
tag = PartyInfo.query.filter_by(party_name=item).first()
else:
tag = PartyInfo(item)
p.partytag.append(tag)
else:
p.partytag = [
PartyInfo.query.filter_by(party_name='').first(),
]
db.session.add(p)
db.session.commit()
return redirect(url_for('profile.detail', person_id=person_id))
else:
if p.birthdate:
timestring = datetime.strftime(p.birthdate, '%m/%d/%Y')
else:
timestring = ''
partys = ('-'.join([x.party_name for x in p.partytag]))
print(partys)
return render_template('edit.html', t=timestring, p=p, party=partys)
