def hapus(id):
if 'username' in session:
alat = Alat.query.get_or_404(id)
if alat:
db.session.delete(alat)
aksi = f"hapus alat id:{alat.id}"
log = Loguser(session['username'], aksi)
db.session.add(log)
db.session.commit()
flash("Data berhaisl dihapus!!", "info")
return redirect(url_for('alat.index'))
return redirect(url_for('user.login'))
def hapus(id):
if 'username' in session:
f = Fasyankes.query.get_or_404(id)
if f:
db.session.delete(f)
aksi = f"fasyankes del:{f.nama}"
log = Loguser(session['username'], aksi)
db.session.add(log)
db.session.commit()
flash('Data telah terhapus !!','warning')
return redirect(url_for('fasyankes.index'))
return redirect(url_for('user.login'))
def add():
if 'username' in session:
data = {'title': 'Input Alat', 'header': 'Input Alat'}
form = Input()
if form.validate_on_submit():
alat = Alat.query.order_by(Alat.id.desc()).first()
if alat:
id_number = alat.id + 1
if len(str(id_number)) < 5:
urut = "0" * (5 - len(str(id_number))) + str(id_number)
kd = f"PK{urut}"
else:
id_number = 1
urut = "0" * (5 - 1) + str(id_number)
kd = f"PK{urut}"
kd_alat = kd
nm_alat = form.nm_alat.data
merk = form.merk.data
tipe = form.tipe.data
no_seri = form.no_seri.data
aksesoris = form.aksesoris.data
th_pengadaan = form.th_pengadaan.data
ket = form.ket.data
add_alat = Alat(kd_alat, nm_alat, merk, tipe, no_seri, aksesoris,
th_pengadaan, ket)
db.session.add(add_alat)
aksi = f"input alat:{kd_alat}"
catatan = Loguser(session['username'], aksi)
db.session.add(catatan)
db.session.commit()
flash('Data sudah disimpan!!', 'success')
return redirect(url_for('alat.index'))
return render_template('alat/tambah_alat.html', data=data, form=form)
else:
return redirect(url_for('user.login'))
def hapus(id):
if 'username' in session:
pinjam = Peminjam_alat.query.get(id)
if pinjam:
db.session.delete(pinjam)
logpinjam = Log_pinjam.query.filter_by(id_peminjam=id).all()
if logpinjam:
# hapus id diatas pada table Peminjaman_alat dan Log_pinjam
db.session.delete(logpinjam)
aksi = f"menghapus peminjaman alat id:{pinjam.id}"
log = Loguser(session['username'], aksi)
db.session.add(log)
db.session.commit()
flash("Data berhasil dihapus!!", "info")
return redirect(url_for('pinjam.index'))
return redirect(url_for('user.login'))
def edit(id):
if 'username' in session:
data = {'title':'Edit data',
'header':'Edit data'
}
cari = Fasyankes.query.get_or_404(id)
form = Edit()
if form.validate_on_submit():
cari.nama = form.nama.data
cari.status = form.status.data
cari.alamat = form.alamat.data
cari.kota = form.kota.data
cari.provinsi = form.provinsi.data
cari.email = form.email.data
cari.telepon = form.telepon.data
cari.fax = form.fax.data
aksi = f"fasyankes edit: {cari.id}"
log = Loguser(session['username'], aksi)
db.session.add(log)
db.session.commit()
flash('Data berhasil diupdate!!','success')
return redirect(url_for('fasyankes.index'))
form.nama.data = cari.nama
form.status.data = cari.status
form.alamat.data = cari.alamat
form.kota.data = cari.kota
form.provinsi.data = cari.provinsi
form.email.data = cari.email
form.telepon.data = cari.telepon
form.fax.data = cari.fax
return render_template('fasyankes/edit.html', data=data, form=form)
return redirect(url_for('user.login'))
def edit(id):
if 'username' in session:
data = {'title': 'Edit alat', 'header': 'Edit alat'}
alat = Alat.query.get_or_404(id)
if alat:
form = Edit()
if form.validate_on_submit():
alat.nm_alat = form.nm_alat.data
alat.merk = form.merk.data
alat.tipe = form.tipe.data
alat.no_seri = form.no_seri.data
alat.aksesoris = form.aksesoris.data
alat.th_pengadaan = form.th_pengadaan.data
alat.ket = form.ket.data
aksi = f"edit alat id:{alat.id}"
catatan = Loguser(session['username'], aksi)
db.session.add(catatan)
db.session.commit()
flash("Data berhasil diupdate!!", "info")
return redirect(url_for('alat.index'))
form.nm_alat.data = alat.nm_alat
form.merk.data = alat.merk
form.tipe.data = alat.tipe
form.no_seri.data = alat.no_seri
form.aksesoris.data = alat.aksesoris
form.th_pengadaan.data = alat.th_pengadaan
form.ket.data = alat.ket
return render_template('alat/edit_alat.html', data=data, form=form)
return redirect(url_for('user.login'))
def input():
if 'username' in session:
data = {'title':'Input Fasyankes',
'header':'Input Fasyankes'
}
form=Input()
if form.validate_on_submit():
nama = form.nama.data
status = form.status.data
alamat = form.alamat.data
kota = form.kota.data
provinsi = form.provinsi.data
email = form.email.data
telepon = form.telepon.data
fax = form.fax.data
# input data ke dalam table fasyankes
add_fasyankes = Fasyankes(nama, status, alamat, kota, provinsi, email, telepon, fax)
db.session.add(add_fasyankes)
# flush data fasyankes sebelum commit
db.session.flush()
aksi = f"add fasyankes: {add_fasyankes.id}"
log = Loguser(session['username'], aksi)
db.session.add(log)
# commit data add fasyankes dan loguser
db.session.commit()
flash('Data berhasil disimpan!!!','success')
return redirect(url_for('fasyankes.index'))
return render_template('fasyankes/input.html', data=data, form=form)
return redirect(url_for('user.login'))