def activity_new_activity(): activityform = ActivityForm(request.form) if not activityform.validate(): print("Validointi ei onnistunut") return render_template("subjects/list.html", action="FixNewActivity", targetactivity=-1, targetdomain=-1, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), fixnewactivityform=activityform, newactivityform=ActivityForm(), newdomainform=DomainForm()) print("Yritetään tallentaa tietokantaan") a = Activity(activityform.orderer.data, activityform.code.data, activityform.name.data, activityform.description.data, activityform.inuse.data, current_user.get_entity_id()) try: db.session().add(a) db.session().commit() print("Tallennus onnistui") except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY print("Tapahtui virhe lisättäessä toimintoa tietokantaan") pass return redirect(url_for("subjects_index"))
def activity_new_domain(activity_id): domainform = DomainForm(request.form) print("Yritetään lisätä uutta kustannuspaikkaa toimintoon " + str(domainform.activity_id.data)) if not domainform.validate(): return render_template("subjects/list.html", action="FixNewDomain", targetactivity=activity_id, targetdomain=-1, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), fixnewdomainform=domainform, newdomainform=DomainForm()) a = Domain(domainform.orderer.data, domainform.code.data, domainform.name.data, domainform.description.data, domainform.inuse.data, activity_id, current_user.get_entity_id()) try: db.session().add(a) db.session().commit() except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY print("Tapahtui virhe lisätessä uutta kustannuspaikkaa tietokantaan") pass return redirect(url_for("subjects_index"))
def subjects_index(): print("*** subjects_index ***") return render_template("subjects/list.html", action="NoAction", targetactivity=-1, targetdomain=-1, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), newdomainform=DomainForm())
def activity_edit_domain(domain_id): print("Tehdään kustannuspaikalle jotain") editdomainform = DomainForm(request.form) print("id:", editdomainform.id.data) print("activity_id:", editdomainform.activity_id.data) if not editdomainform.validate(): print("Kustannuspaikan validointi editoidessa ei onnistunut") return render_template("subjects/list.html", action="EditDomain", targetactivity=editdomainform.activity_id.data, targetdomain=domain_id, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), newdomainform=DomainForm(), editdomainform=editdomainform) if "action_update" in request.form: print("Yritetään tallentaa muutettua kustannuspaikkaa") domain = Domain.query.filter( Domain.entity_id == current_user.get_entity_id(), Domain.id == domain_id).first() domain.name = editdomainform.name.data domain.description = editdomainform.description.data domain.inuse = editdomainform.inuse.data try: db.session().commit() except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY pass elif "action_delete" in request.form: print("Yritetään poistaa kustannuspaikkaa") obsolete = Domain.query.filter( Domain.entity_id == current_user.get_entity_id(), Domain.id == domain_id).first() try: db.session().delete(obsolete) db.session.commit() except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY pass return redirect(url_for("subjects_index"))
def activity_edit_activity(activity_id): print("Tehdään tiliryhmälle " + activity_id + " jotain") editactivityform = ActivityForm(request.form) print("activityid on " + str(editactivityform.id.data)) editactivityform.id.data = activity_id if not editactivityform.validate(): return render_template("subjects/list.html", action="EditActivity", targetactivity=activity_id, targetdomain=-1, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), editactivityform=editactivityform, newdomainform=DomainForm()) if "action_update" in request.form: print("Yritetään tallentaa muutettua toimintoa") activity = Activity.query.filter( Activity.entity_id == current_user.get_entity_id(), Activity.id == activity_id).first() activity.name = editactivityform.name.data activity.description = editactivityform.description.data activity.inuse = editactivityform.inuse.data try: db.session().commit() except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY pass elif "action_delete" in request.form: print("Yritetään poistaa toimintoa") obsolete = Activity.query.filter( Activity.entity_id == current_user.get_entity_id(), Activity.id == activity_id).first() try: db.session().delete(obsolete) db.session.commit() except: ## TÄHÄN VIRHETILANTEEN KÄSITTELY pass return redirect(url_for("subjects_index"))
def activity_select_activity(activity_id): print("Valittu editoitavaksi toiminto id = " + activity_id) editactivityform = ActivityForm(request.form) activity = Activity.query.filter( Activity.entity_id == current_user.get_entity_id(), Activity.id == activity_id).first() editactivityform.id.data = activity.id editactivityform.orderer.data = activity.orderer editactivityform.code.data = activity.code editactivityform.name.data = activity.name editactivityform.description.data = activity.description editactivityform.inuse.data = activity.inuse return render_template("subjects/list.html", action="EditActivity", targetactivity=activity_id, targetdomain=-1, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), editactivityform=editactivityform, newdomainform=DomainForm())
def activity_select_domain(domain_id): print("Valittu editoitavaksi kustannuspaikka id = " + domain_id) editdomainform = DomainForm(request.form) domain = Domain.query.filter( Domain.entity_id == current_user.get_entity_id(), Domain.id == domain_id).first() editdomainform.id.data = domain_id editdomainform.orderer.data = domain.orderer editdomainform.code.data = domain.code editdomainform.name.data = domain.name editdomainform.description.data = domain.description editdomainform.inuse.data = domain.inuse return render_template("subjects/list.html", action="EditDomain", targetactivity=domain.activity_id, targetdomain=domain_id, subjects=Activity.findAllActivitiesAndDomains( current_user.get_entity_id()), newactivityform=ActivityForm(), newdomainform=DomainForm(), editdomainform=editdomainform)