def delete_instansi_tkj(request,id_instansi):
if request.POST:
InstansiTKJ.objects.filter(id=id_instansi).delete()
msg = pesan().delete()
get_instansi = InstansiTKJ.objects.all()
else:
return redirect('/master-instansi/tkj')
return render(request, 'master-instansi-tkj.html', {'msg':msg, 'master':get_instansi})
def add_instansi_tkj(request):
if request.POST:
InstansiTKJ(
nama = request.POST['nama'],
alamat = request.POST['alamat'],
).save()
msg = pesan().add()
return render(request, 'add-instansi-tkj.html', {'msg':msg})
return render(request, 'add-instansi-tkj.html')
def ubah_tkj_4(request,id_siswa):
if request.POST:
Siswa.objects.filter(id=id_siswa).update(
nama = request.POST['nama'],
kelas = request.POST['kelas'],
)
msg = pesan().update()
siswa_update = Siswa.objects.get(id=id_siswa)
return render(request, 'ubah-tkj-4.html', {'msg':msg, 'siswa':siswa_update})
else:
siswa_update = Siswa.objects.get(id=id_siswa)
return render(request, 'ubah-tkj-4.html', {'siswa':siswa_update})
def ubah_pembimbing(request,id_p):
if request.POST:
Pembimbing.objects.filter(id=id_p).update(
nama = request.POST['nama'],
jurusan = request.POST['jurusan'],
)
msg = pesan().update()
pembimbing = Pembimbing.objects.get(id=id_p)
return render(request, 'sunting-pembimbing.html', {'msg':msg, 'pembimbing': pembimbing})
else:
pembimbing = Pembimbing.objects.get(id=id_p)
return render(request, 'sunting-pembimbing.html', {'pembimbing':pembimbing})
def ubah_instansi_tkj(request,id_instansi):
if request.POST:
InstansiTKJ.objects.filter(id=id_instansi).update(
nama = request.POST['nama'],
alamat = request.POST['alamat'],
)
msg = pesan().update()
instansi = InstansiTKJ.objects.get(id=id_instansi)
return render(request, 'ubah-instansi-tkj.html', {'msg':msg, 'instansi':instansi})
else:
instansi = InstansiTKJ.objects.get(id=id_instansi)
return render(request, 'ubah-instansi-tkj.html', {'instansi':instansi})
def hapus_surat_rpl(request, id_surat):
if request.POST:
id_siswa = Permohonan.objects.get(id=id_surat)
Siswa.objects.filter(id=id_siswa.nama_siswa.id).update(pkl=False)
Permohonan.objects.filter(id=id_surat).delete()
msg = pesan().delete()
get_surat = Permohonan.objects.filter(
nama_siswa__program_ahli='Rekayasa Perangkat Lunak').order_by(
'nama_instansi')
else:
return redirect('/surat-rpl/')
return render(request, 'surat-rpl.html', {'msg': msg, 'surat': get_surat})
def add_pembimbing(request):
if request.POST:
form = FormPembimbing(request.POST)
if form.is_valid():
Pembimbing(
nama = request.POST['nama'],
jurusan = request.POST['jurusan'],
).save()
msg = pesan().add()
form = FormPembimbing()
return render(request, 'add-pembimbing.html', {'msg':msg, 'form':form})
else:
form = FormPembimbing()
return render(request, 'add-pembimbing.html', {'form':form})
def hapus_surat_tkj(request, id_surat):
if request.POST:
# ambil dulu ID Siswa dari model Permohonan
id_siswa = PermohonanTKJ.objects.get(id=id_surat)
Siswa.objects.filter(id=id_siswa.nama_siswa.id).update(pkl=False)
# lalu hapus data surat permohonannya
PermohonanTKJ.objects.filter(id=id_surat).delete()
msg = pesan().delete()
get_surat = PermohonanTKJ.objects.filter(
nama_siswa__program_ahli='Rekayasa Perangkat Lunak').order_by(
'nama_instansi')
else:
return redirect('/surat-tkj/')
return render(request, 'surat-tkj.html', {'msg': msg, 'surat': get_surat})
def sunting_karil_tkj(request,id_karil):
if request.POST:
KaryaIlmiah.objects.filter(id=id_karil).update(
judul = request.POST['judul'],
)
msg = pesan().update()
karil = KaryaIlmiah.objects.get(id=id_karil)
return render(request, 'sunting-karil-tkj.html',
{
'msg':msg,
'karil':karil
})
else:
karil = KaryaIlmiah.objects.get(id=id_karil)
return render(request, 'sunting-karil-tkj.html', {'karil': karil})
def add_master_tkj(request):
if request.POST:
form = FormTKJ(request.POST)
if form.is_valid():
add_siswa = Siswa(
NIS = request.POST['NIS'],
nama = request.POST['nama'],
kelas = request.POST['kelas'],
program_ahli = 'Teknik Komputer dan Jaringan',
).save()
msg = pesan().add()
form = FormTKJ()
return render(request, 'add-master-tkj.html', {'msg':msg, 'form':form})
else:
form = FormTKJ()
return render(request, 'add-master-tkj.html', {'form':form})
def add_master_rpl(request):
if request.POST:
form = FormRPL(request.POST)
if form.is_valid():
add_siswa = Siswa(
NIS = request.POST['NIS'],
nama = request.POST['nama'],
kelas = request.POST['kelas'],
program_ahli = 'Rekayasa Perangkat Lunak',
).save()
msg = pesan().add()
form = FormRPL()
return render(request, 'add-master-rpl.html', {'msg':msg, 'form':form})
else:
form = FormRPL()
return render(request, 'add-master-rpl.html', {'form':form})
def ubah_surat_tkj(request, id_surat):
if request.POST:
s = Siswa.objects.get(id=request.POST['nama_siswa'])
i = InstansiTKJ.objects.get(id=request.POST['nama_instansi'])
PermohonanTKJ.objects.filter(id=id_surat).update(
nama_siswa=s,
nama_instansi=i,
)
msg = pesan().update()
siswa1 = Siswa.objects.filter(kelas='XII.TKJ-1')
siswa2 = Siswa.objects.filter(kelas='XII.TKJ-2')
siswa3 = Siswa.objects.filter(kelas='XII.TKJ-3')
siswa4 = Siswa.objects.filter(kelas='XII.TKJ-4')
instansis = InstansiTKJ.objects.all()
surat = PermohonanTKJ.objects.get(id=id_surat)
return render(
request, 'ubah-surat-tkj.html', {
'msg': msg,
'surat': surat,
'siswa1': siswa1,
'siswa2': siswa2,
'siswa3': siswa3,
'siswa4': siswa4,
'instansis': instansis,
})
else:
surat = PermohonanTKJ.objects.get(id=id_surat)
siswa1 = Siswa.objects.filter(kelas='XII.TKJ-1')
siswa2 = Siswa.objects.filter(kelas='XII.TKJ-2')
siswa3 = Siswa.objects.filter(kelas='XII.TKJ-3')
siswa4 = Siswa.objects.filter(kelas='XII.TKJ-4')
instansis = InstansiTKJ.objects.all()
return render(
request, 'ubah-surat-tkj.html', {
'surat': surat,
'siswa1': siswa1,
'siswa2': siswa2,
'siswa3': siswa3,
'siswa4': siswa4,
'instansis': instansis,
})
def add_karil(request):
if request.POST:
form = Form_Karil_TKJ(request.POST)
if form.is_valid():
siswa = Siswa.objects.get(id=request.POST['nama'])
pembimbing = Pembimbing.objects.get(id=request.POST['pembimbing'])
KaryaIlmiah(
nama = siswa,
judul = request.POST['judul'],
tanggal_acc = request.POST['tanggal_acc'],
pembimbing = pembimbing,
).save()
# ubah status_judul jadi True
# agar mudah mengelompokkan yg sudah dapet judul :D
Siswa.objects.filter(id=request.POST['nama']).update(status_judul=True)
msg = pesan().add()
form = Form_Karil_TKJ() # buat form kosong
# ambil siswa per jurusan yang statusnya belum punya JUDUL.
# data ini akan dimasukkan kedalam form input select
tkj = Siswa.objects.filter(kelas__contains='XII.TKJ', status_judul=False).order_by('kelas', 'nama')
rpl = Siswa.objects.filter(kelas__contains='XII.RPL', status_judul=False).order_by('kelas', 'nama')
return render(request, 'add-karil.html', {
'msg': msg,
'form': form,
'tkj': tkj,
'rpl': rpl,
})
else:
form = Form_Karil_TKJ()
tkj = Siswa.objects.filter(kelas__contains='XII.TKJ', status_judul=False).order_by('kelas', 'nama')
rpl = Siswa.objects.filter(kelas__contains='XII.RPL', status_judul=False).order_by('kelas', 'nama')
return render(request, 'add-karil.html', {
'form': form,
'tkj': tkj,
'rpl': rpl,
})
