def GetSchoolFormById(school_id):
school = orm.School.query.get(int(school_id))
if school is None:
return None
schoolform = SchoolForm()
schoolform.id.data = school.id
schoolform.name.data = school.name
schoolform.area_id.data = school.area_id
schoolform.area_name = school.area.name
schoolform.teachdesc.data = school.teachdesc
schoolform.address.data = school.address
schoolform.schooltype_id.data = school.schooltype_id
schoolform.schooltype_name = school.schooltype.name
schoolform.website.data = school.website
schoolform.distinguish.data = school.distinguish
schoolform.leisure.data = school.leisure
schoolform.threashold.data = school.threashold
schoolform.partner.data = school.partner
schoolform.artsource.data = school.artsource
schoolform.feedesc.data = school.feedesc
schoolform.longitude.data = school.longitude
schoolform.latitude.data = school.latitude
schoolform.schoolimages = school.schoolimages
schoolform.feature_ids.data = [x.feature_id for x in school.schoolfeatures]
schoolform.area_id.choices = g_choices_area
schoolform.schooltype_id.choices = g_choices_schooltype
schoolform.feature_ids.choices = g_choices_feature
return schoolform
def GetSchoolFormById(school_id):
school = orm.School.query.get(int(school_id))
if school is None:
return None
schoolform = SchoolForm()
schoolform.id.data = school.id
schoolform.name.data = school.name
schoolform.area_id.data = school.area_id
schoolform.area_name = school.area.name
schoolform.teachdesc.data = school.teachdesc
schoolform.address.data = school.address
schoolform.schooltype_id.data = school.schooltype_id
schoolform.schooltype_name = school.schooltype.name
schoolform.website.data = school.website
schoolform.distinguish.data = school.distinguish
schoolform.leisure.data = school.leisure
schoolform.threashold.data = school.threashold
schoolform.partner.data = school.partner
schoolform.artsource.data = school.artsource
schoolform.feedesc.data = school.feedesc
schoolform.longitude.data = school.longitude
schoolform.latitude.data = school.latitude
schoolform.schoolimages = school.schoolimages
schoolform.feature_ids.data = [x.feature_id for x in school.schoolfeatures]
schoolform.area_id.choices = g_choices_area
schoolform.schooltype_id.choices = g_choices_schooltype
schoolform.feature_ids.choices = g_choices_feature
return schoolform
def view_school():
school_id = request.args.get('id')
q = request.args.get('q')
if q is not None:
return redirect(url_for('view_schools', page=1, q=q))
form = SchoolForm(request.form)
form.area_id.choices = logic.g_choices_area
form.schooltype_id.choices = logic.g_choices_schooltype
form.feature_ids.choices = logic.g_choices_feature
# form.message = form.data
if request.method == 'POST' and form.validate():
print "longitude:",form.longitude.data
if form.id.data:
school = orm.School.query.get(int(form.id.data))
school.name = form.name.data
school.area_id = form.area_id.data
school.teachdesc = form.teachdesc.data
school.address = form.address.data
school.schooltype_id = form.schooltype_id.data
school.website = form.website.data
school.distinguish = form.distinguish.data
school.leisure = form.leisure.data
school.threashold = form.threashold.data
school.partner = form.partner.data
school.artsource = form.artsource.data
school.feedesc = form.feedesc.data
school.longitude = form.longitude.data
school.latitude = form.latitude.data
orm.db.session.commit()
else:
school = orm.School(form.name.data, form.area_id.data, form.teachdesc.data, form.address.data, form.schooltype_id.data, form.website.data, form.distinguish.data, form.leisure.data, form.threashold.data, form.partner.data, form.artsource.data, form.feedesc.data, form.longitude.data, form.latitude.data)
orm.db.session.add(school)
orm.db.session.commit()
form.id.data = school.id
logic.SetSchoolFeatures(int(form.id.data),form.feature_ids.data)
if request.form.has_key('upload'):
file = request.files['image']
if file :
file_server = str(uuid.uuid1())+Util.file_extension(file.filename)
pathfile_server = os.path.join(UPLOAD_PATH, file_server)
file.save(pathfile_server)
if os.stat(pathfile_server).st_size <1*1024*1024:
schoolimage = orm.Schoolimage(school.id,file_server)
orm.db.session.merge(schoolimage)
orm.db.session.commit()
else:
os.remove(pathfile_server)
else:
return redirect(url_for('view_school'))
elif request.method =='GET' and school_id:
form = logic.GetSchoolFormById(school_id)
logic.LoadBasePageInfo('修改学校','输入并确定',form)
else:
logic.LoadBasePageInfo('新建学校','输入并确定',form)
if form.id.data:
school = orm.School.query.get(int(form.id.data))
form.school = school
if form.school:
form.schoolimages = form.school.schoolimages
return render_template('view_school.html',form = form)
def view_school():
school_id = request.args.get('id')
q = request.args.get('q')
if q is not None:
return redirect(url_for('view_schools', page=1, q=q))
form = SchoolForm(request.form)
form.area_id.choices = logic.g_choices_area
form.schooltype_id.choices = logic.g_choices_schooltype
form.feature_ids.choices = logic.g_choices_feature
# form.message = form.data
if request.method == 'POST' and form.validate():
print "longitude:", form.longitude.data
if form.id.data:
school = orm.School.query.get(int(form.id.data))
school.name = form.name.data
school.area_id = form.area_id.data
school.teachdesc = form.teachdesc.data
school.address = form.address.data
school.schooltype_id = form.schooltype_id.data
school.website = form.website.data
school.distinguish = form.distinguish.data
school.leisure = form.leisure.data
school.threashold = form.threashold.data
school.partner = form.partner.data
school.artsource = form.artsource.data
school.feedesc = form.feedesc.data
school.longitude = form.longitude.data
school.latitude = form.latitude.data
orm.db.session.commit()
else:
school = orm.School(form.name.data, form.area_id.data,
form.teachdesc.data, form.address.data,
form.schooltype_id.data, form.website.data,
form.distinguish.data, form.leisure.data,
form.threashold.data, form.partner.data,
form.artsource.data, form.feedesc.data,
form.longitude.data, form.latitude.data)
orm.db.session.add(school)
orm.db.session.commit()
form.id.data = school.id
logic.SetSchoolFeatures(int(form.id.data), form.feature_ids.data)
if request.form.has_key('upload'):
file = request.files['image']
if file:
file_server = str(uuid.uuid1()) + Util.file_extension(
file.filename)
pathfile_server = os.path.join(UPLOAD_PATH, file_server)
file.save(pathfile_server)
if os.stat(pathfile_server).st_size < 1 * 1024 * 1024:
schoolimage = orm.Schoolimage(school.id, file_server)
orm.db.session.merge(schoolimage)
orm.db.session.commit()
else:
os.remove(pathfile_server)
else:
return redirect(url_for('view_school'))
elif request.method == 'GET' and school_id:
form = logic.GetSchoolFormById(school_id)
logic.LoadBasePageInfo('修改学校', '输入并确定', form)
else:
logic.LoadBasePageInfo('新建学校', '输入并确定', form)
if form.id.data:
school = orm.School.query.get(int(form.id.data))
form.school = school
if form.school:
form.schoolimages = form.school.schoolimages
return render_template('view_school.html', form=form)
