def GetInstitutionFormById(institution_id): institution = orm.Institution.query.get(int(institution_id)) if institution is None: return None institutionform = InstitutionForm() institutionform.id.data = institution.id institutionform.name.data = institution.name institutionform.agespan_id.data = institution.agespan_id institutionform.agespan_name = institution.agespan.name institutionform.area_id.data = institution.area_id institutionform.area_name = institution.area.name institutionform.address.data = institution.address institutionform.location.data = institution.location institutionform.website.data = institution.website institutionform.telephone.data = institution.telephone institutionform.feedesc.data = institution.feedesc institutionform.timeopen.data = institution.timeopen institutionform.timeclose.data = institution.timeclose institutionform.feetype_id.data = institution.feetype_id institutionform.feetype_name = institution.feetype.name institutionform.longitude.data = institution.longitude institutionform.latitude.data = institution.latitude institutionform.institutionimages = institution.institutionimages institutionform.feature_ids.data = [x.feature_id for x in institution.institutionfeatures] institutionform.area_id.choices = g_choices_area institutionform.feature_ids.choices = g_choices_feature institutionform.agespan_id.choices = g_choices_agespan institutionform.feetype_id.choices = g_choices_feetype return institutionform
def GetInstitutionFormById(institution_id): institution = orm.Institution.query.get(int(institution_id)) if institution is None: return None institutionform = InstitutionForm() institutionform.id.data = institution.id institutionform.name.data = institution.name institutionform.agespan_id.data = institution.agespan_id institutionform.agespan_name = institution.agespan.name institutionform.area_id.data = institution.area_id institutionform.area_name = institution.area.name institutionform.address.data = institution.address institutionform.location.data = institution.location institutionform.website.data = institution.website institutionform.telephone.data = institution.telephone institutionform.feedesc.data = institution.feedesc institutionform.timeopen.data = institution.timeopen institutionform.timeclose.data = institution.timeclose institutionform.feetype_id.data = institution.feetype_id institutionform.feetype_name = institution.feetype.name institutionform.longitude.data = institution.longitude institutionform.latitude.data = institution.latitude institutionform.institutionimages = institution.institutionimages institutionform.feature_ids.data = [ x.feature_id for x in institution.institutionfeatures ] institutionform.area_id.choices = g_choices_area institutionform.feature_ids.choices = g_choices_feature institutionform.agespan_id.choices = g_choices_agespan institutionform.feetype_id.choices = g_choices_feetype return institutionform
def view_institution(): institution_id = request.args.get('id') q = request.args.get('q') if q is not None: return redirect(url_for('view_institutions', page=1, q=q)) form = InstitutionForm(request.form) form.area_id.choices = logic.g_choices_area form.feature_ids.choices = logic.g_choices_feature form.agespan_id.choices = logic.g_choices_agespan form.feetype_id.choices = logic.g_choices_feetype form.timeopen.data = datetime.time(8,30) form.timeclose.data = datetime.time(22,00) # form.message = form.data if request.method == 'POST' and form.validate(): if form.id.data: institution = orm.Institution.query.get(int(form.id.data)) institution.name = form.name.data institution.agespan_id = form.agespan_id.data institution.area_id = form.area_id.data institution.address = form.address.data institution.location = form.location.data institution.website = form.website.data institution.telephone = form.telephone.data institution.feedesc = form.feedesc.data institution.timeopen = form.timeopen.data institution.timeclose = form.timeclose.data institution.feetype_id = form.feetype_id.data institution.longitude = form.longitude.data institution.latitude = form.latitude.data orm.db.session.commit() else: institution = orm.Institution(form.name.data, form.agespan_id.data, form.area_id.data, form.address.data, form.location.data, form.website.data, form.telephone.data, form.feedesc.data, form.timeopen.data, form.timeclose.data, form.feetype_id.data, form.longitude.data, form.latitude.data, None) orm.db.session.add(institution) orm.db.session.commit() form.id.data = institution.id logic.SetInstitutionFeatures(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: institutionimage = orm.Institutionimage(institution.id,file_server) orm.db.session.merge(institutionimage) orm.db.session.commit() else: os.remove(pathfile_server) else: return redirect(url_for('view_institution')) elif request.method =='GET' and institution_id: form = logic.GetInstitutionFormById(institution_id) logic.LoadBasePageInfo('修改培训机构','输入并确定',form) else: logic.LoadBasePageInfo('新建培训机构','输入并确定',form) if form.id.data: institution = orm.Institution.query.get(int(form.id.data)) form.institution = institution if form.institution: form.institutionimages = form.institution.institutionimages return render_template('view_institution.html',form = form)
def view_institution(): institution_id = request.args.get('id') q = request.args.get('q') if q is not None: return redirect(url_for('view_institutions', page=1, q=q)) form = InstitutionForm(request.form) form.area_id.choices = logic.g_choices_area form.feature_ids.choices = logic.g_choices_feature form.agespan_id.choices = logic.g_choices_agespan form.feetype_id.choices = logic.g_choices_feetype form.timeopen.data = datetime.time(8, 30) form.timeclose.data = datetime.time(22, 00) # form.message = form.data if request.method == 'POST' and form.validate(): if form.id.data: institution = orm.Institution.query.get(int(form.id.data)) institution.name = form.name.data institution.agespan_id = form.agespan_id.data institution.area_id = form.area_id.data institution.address = form.address.data institution.location = form.location.data institution.website = form.website.data institution.telephone = form.telephone.data institution.feedesc = form.feedesc.data institution.timeopen = form.timeopen.data institution.timeclose = form.timeclose.data institution.feetype_id = form.feetype_id.data institution.longitude = form.longitude.data institution.latitude = form.latitude.data orm.db.session.commit() else: institution = orm.Institution( form.name.data, form.agespan_id.data, form.area_id.data, form.address.data, form.location.data, form.website.data, form.telephone.data, form.feedesc.data, form.timeopen.data, form.timeclose.data, form.feetype_id.data, form.longitude.data, form.latitude.data, None) orm.db.session.add(institution) orm.db.session.commit() form.id.data = institution.id logic.SetInstitutionFeatures(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: institutionimage = orm.Institutionimage( institution.id, file_server) orm.db.session.merge(institutionimage) orm.db.session.commit() else: os.remove(pathfile_server) else: return redirect(url_for('view_institution')) elif request.method == 'GET' and institution_id: form = logic.GetInstitutionFormById(institution_id) logic.LoadBasePageInfo('修改培训机构', '输入并确定', form) else: logic.LoadBasePageInfo('新建培训机构', '输入并确定', form) if form.id.data: institution = orm.Institution.query.get(int(form.id.data)) form.institution = institution if form.institution: form.institutionimages = form.institution.institutionimages return render_template('view_institution.html', form=form)