def accountgroup_new_account(accountgroup_id):
accountform = AccountForm(request.form)
print("Yritetään lisätä uutta tiliä ryhmään " +
str(accountform.accountgroup_id.data))
if not accountform.validate():
return render_template(
"accountgroups/list.html",
action="FixNewAccount",
targetgroup=accountgroup_id,
targetaccount=-1,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
newaccountgroupform=AccountGroupForm(),
fixnewaccountform=accountform,
newaccountform=AccountForm())
a = Account(accountform.number.data, accountform.name.data,
accountform.description.data, accountform.inuse.data,
accountgroup_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 tiliä tietokantaan")
pass
return redirect(url_for("accountgroups_index"))
def accounts_create():
form = AccountForm(request.form)
if not form.validate():
return render_template("accounts/account_form.html", form = form)
account = Account.query.filter_by(username=form.username.data).first()
if account:
return render_template("accounts/account_form.html",
form = form,
error = "Username is taken, please select another one"
)
account = Account(
form.name.data,
form.username.data,
sha256_crypt.encrypt(form.password.data),
form.email.data
)
db.session.add(account)
db.session.commit()
return redirect(url_for("login"))
def accountgroup_edit_account(account_id):
print("Tehdään tilille jotain")
editaccountform = AccountForm(request.form)
print("id:", editaccountform.id.data)
print("group_id:", editaccountform.accountgroup_id.data)
if not editaccountform.validate():
print("Tilin validointi editoidessa ei onnistunut")
return render_template(
"accountgroups/list.html",
action="EditAccount",
targetgroup=editaccountform.accountgroup_id.data,
targetaccount=account_id,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
newaccountgroupform=AccountGroupForm(),
newaccountform=AccountForm(),
editaccountform=editaccountform)
if "action_update" in request.form:
print("Yritetään tallentaa")
account = Account.query.filter(
Account.entity_id == current_user.get_entity_id(),
Account.id == account_id).first()
account.name = editaccountform.name.data
account.description = editaccountform.description.data
account.inuse = editaccountform.inuse.data
try:
db.session().commit()
except:
## TÄHÄN VIRHETILANTEEN KÄSITTELY
pass
elif "action_delete" in request.form:
print("Yritetään poistaa")
obsolete = Account.query.filter(
Account.entity_id == current_user.get_entity_id(),
Account.id == account_id).first()
try:
db.session().delete(obsolete)
db.session.commit()
except:
## TÄHÄN VIRHETILANTEEN KÄSITTELY
pass
return redirect(url_for("accountgroups_index"))
def accountgroup_new_group():
accountgroupform = AccountGroupForm(request.form)
if not accountgroupform.validate():
print("Validointi ei onnistunut")
return render_template(
"accountgroups/list.html",
action="FixNewAccountGroup",
targetgroup=-1,
targetaccount=-1,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
fixnewaccountgroupform=accountgroupform,
newaccountgroupform=AccountGroupForm(),
newaccountform=AccountForm())
print("Yritetään tallentaa tietokantaan")
a = AccountGroup(accountgroupform.number.data, accountgroupform.name.data,
accountgroupform.description.data,
accountgroupform.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ä tiliryhmää tietokantaan")
pass
return redirect(url_for("accountgroups_index"))
def accounts_profile(account_id):
account = Account.query.get(account_id)
form = AccountForm(obj=account)
return render_template("accounts/account_profile.html",
form = form,
account = account
)
def accountgroups_index():
print("*** accountgroups_index ***")
return render_template("accountgroups/list.html",
action="NoAction",
targetgroup=-1,
targetaccount=-1,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
newaccountgroupform=AccountGroupForm(),
newaccountform=AccountForm())
def accountgroup_select_account(account_id):
print("Valittu editoitavaksi tili id = " + account_id)
editaccountform = AccountForm(request.form)
account = Account.query.filter(
Account.entity_id == current_user.get_entity_id(),
Account.id == account_id).first()
editaccountform.id.data = account_id
editaccountform.number.data = account.number
editaccountform.name.data = account.name
editaccountform.description.data = account.description
editaccountform.inuse.data = account.inuse
return render_template("accountgroups/list.html",
action="EditAccount",
targetgroup=account.accountgroup_id,
targetaccount=account_id,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
newaccountgroupform=AccountGroupForm(),
newaccountform=AccountForm(),
editaccountform=editaccountform)
def accountgroup_edit_group(accountgroup_id):
print("Tehdään tiliryhmälle " + accountgroup_id + " jotain")
editaccountgroupform = AccountGroupForm(request.form)
print("groupid on " + str(editaccountgroupform.id.data))
editaccountgroupform.id.data = accountgroup_id
if not editaccountgroupform.validate():
return render_template(
"accountgroups/list.html",
action="EditAccountGroup",
targetgroup=accountgroup_id,
targetaccount=-1,
accountgroups=AccountGroup.findAllGroupsAndAccounts(
current_user.get_entity_id()),
newaccountgroupform=AccountGroupForm(),
editaccountgroupform=editaccountgroupform,
newaccountform=AccountForm())
if "action_update" in request.form:
print("Yritetään tallentaa")
accountgroup = AccountGroup.query.filter(
AccountGroup.entity_id == current_user.get_entity_id(),
AccountGroup.id == accountgroup_id).first()
accountgroup.name = editaccountgroupform.name.data
accountgroup.description = editaccountgroupform.description.data
accountgroup.inuse = editaccountgroupform.inuse.data
try:
db.session().commit()
except:
## TÄHÄN VIRHETILANTEEN KÄSITTELY
pass
elif "action_delete" in request.form:
print("Yritetään poistaa")
obsolete = AccountGroup.query.filter(
AccountGroup.entity_id == current_user.get_entity_id(),
AccountGroup.id == accountgroup_id).first()
try:
db.session().delete(obsolete)
db.session.commit()
except:
## TÄHÄN VIRHETILANTEEN KÄSITTELY
pass
return redirect(url_for("accountgroups_index"))
def accounts_form():
return render_template("accounts/account_form.html",
form = AccountForm()
)