def CashAdvance(request,id):
data = Department.objects.prefetch_related('Id_Number').get(Id_Number= id)
employeeID = Employee.objects.get(Id_Number = id)
dateApprove = None
if(request.method == "POST"):
form = Form(Id_Number = employeeID, Type = 'Cash Advance' , Date_Requested = datetime.today(),Date_Approved = dateApprove ,Status = 'Pending')
form.save()
print(form.pk)
formPK = Form.objects.get(Form_ID = form.pk)
cash_advance = Cash_Advance(Id_Number = employeeID, Cash_Amount = request.POST["Amount"], Reason = request.POST["Reason"], FormID = formPK)
cash_advance.save()
if (data.Status_Dept == "Faculty"):
memo_cash_advance = Memo_Routing(Id_Number = employeeID, Type_Request = 'Cash Advance', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending')
if (data.Status_Dept == "Chairman"):
memo_cash_advance = Memo_Routing(Id_Number = employeeID, Type_Request = 'Cash Advance', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending',Date_Chairman_Approved=datetime.today())
if (data.Status_Dept == "Dean"):
memo_cash_advance = Memo_Routing(Id_Number = employeeID, Type_Request = 'Cash Advance', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending',Date_Chairman_Approved=datetime.today(),Date_Dean_Approved=datetime.today())
memo_cash_advance.save()
history = TransacHistory(Id_Number = employeeID, Transac_Type = 'Cash Advance', Type='Submitted', Date = datetime.today())
history.save()
historyback = TransacHistoryBackUp(Id_Number = employeeID, Transac_Type = 'Cash Advance', Type='Submitted', Date = datetime.today())
historyback.save()
return redirect("transachis", id = data.Id_Number.Id_Number)
else:
return render(request,"Cash Advance.html", {'data' : data})
def FileLeave(request,id):
data = Department.objects.prefetch_related('Id_Number').get(Id_Number= id)
employeeID = Employee.objects.get(Id_Number = id)
dateApprove = None
if request.method == 'POST':
form = Form(Id_Number = employeeID, Type = 'File Leave' , Date_Requested = datetime.today(),Date_Approved = dateApprove ,Status = 'Pending')
form.save()
formPK = Form.objects.get(Form_ID = form.pk)
tempStatus = request.POST.get('status')
tempLeave = request.POST.get('typeofLeave')
upload_file = request.FILES['document']
fileleave = Leave(Id_Number = employeeID, Employee_Status = tempStatus ,Typeof_Leave = tempLeave , Date_Start = request.POST["Date_Start"],Date_End = request.POST["Date_End"],Period_Days ='3',Reason = request.POST["Reasons"],Image = upload_file, FormID = formPK)
fileleave.save()
if (data.Status_Dept == "Faculty"):
memo_fileleave = Memo_Routing(Id_Number = employeeID, Type_Request = 'File Leave', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending')
if (data.Status_Dept == "Chairman"):
memo_fileleave = Memo_Routing(Id_Number = employeeID, Type_Request = 'File Leave', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending',Date_Chairman_Approved=datetime.today())
if (data.Status_Dept == "Dean"):
memo_fileleave = Memo_Routing(Id_Number = employeeID, Type_Request = 'File Leave', Date_Faculty_Submitted = datetime.today(), FormID = formPK, Status = 'Pending',Date_Chairman_Approved=datetime.today(),Date_Dean_Approved=datetime.today())
memo_fileleave.save()
history = TransacHistory(Id_Number = employeeID, Transac_Type = 'File Leave', Type='Submitted', Date = datetime.today())
history.save()
historyback = TransacHistoryBackUp(Id_Number = employeeID, Transac_Type = 'File Leave', Type='Submitted', Date = datetime.today())
historyback.save()
return redirect("transachis", id = data.Id_Number.Id_Number)
else:
return render(request,"File a Leave.html", {'data' : data})
def ViewRequestPao(request,id,idr):
dataEmployee = Department.objects.prefetch_related('Id_Number').get(Id_Number = id)
empID = Employee.objects.get(Id_Number=id)
data = Employee.objects.filter(form__Type='Risograph',form__Status='Pending',risograph__Risograph_ID=idr ,risograph__Price = None).distinct('risograph__Risograph_ID').values('risograph__Risograph_ID','risograph__Department','risograph__Paper_Type','risograph__No_of_Copies','risograph__Size','risograph__File','form__Status','form__Date_Approved','form__Date_Requested','form__Form_ID','First_Name','Last_Name','Id_Number')
if request.method == "POST":
if request.POST["buttonButton"] == 'approve':
updateRiso=risograph.objects.filter(Risograph_ID=request.POST["Riso_ID"]).update(Price=request.POST["price"])
FormPK = risograph.objects.filter(Risograph_ID=request.POST["Riso_ID"]).values('FormID')
for formID in FormPK:
formupdate = Form.objects.filter(Form_ID=formID['FormID']).update(Status="Approved")
update=Memo_Routing.objects.filter(FormID=formID['FormID']).update(Date_PAO_Approved=datetime.today(),Status='Approved')
history = TransacHistory(Id_Number= empID, Faculty_Id=request.POST["EmployeeNumber"], Faculty_Name=request.POST["EmployeeName"], Transac_Type='Risograph',Type='Approved',Date=datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number= empID, Faculty_Id=request.POST["EmployeeNumber"], Faculty_Name=request.POST["EmployeeName"], Transac_Type='Risograph', Type='Approved',Date=datetime.today())
historybackup.save()
elif request.POST["buttonButton"] == 'decline':
updateRiso=risograph.objects.filter(Risograph_ID=request.POST["Riso_ID"]).update(Price=None)
FormPK = risograph.objects.filter(Risograph_ID=request.POST["Riso_ID"]).values('FormID')
for formID in FormPK:
formupdate = Form.objects.filter(Form_ID=formID['FormID']).update(Status="Declined")
updateMemo=Memo_Routing.objects.filter(FormID=formID['FormID']).update(Status="Declined")
history = TransacHistory(Id_Number= empID, Faculty_Id=request.POST["EmployeeNumber"], Faculty_Name=request.POST["EmployeeName"], Transac_Type='Risograph', Type='Declined',Date=datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number= empID, Faculty_Id=request.POST["EmployeeNumber"], Faculty_Name=request.POST["EmployeeName"], Transac_Type='Risograph', Type='Declined',Date=datetime.today())
historybackup.save()
return redirect("transachis", id = id)
return render(request,"ViewRequestPAO.html", {'data' : data, 'dataEmployee': dataEmployee})
def ViewRequestDetails(request,id,idf,idm):
data = Department.objects.prefetch_related('Id_Number').get(Id_Number = id)
dataMemo = Memo_Routing.objects.get(id = idm)
if dataMemo.Type_Request == 'Cash Advance':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Cash_Advance.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'File Leave':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Leave.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'Make-up Class':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Makeup_Class.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'Risograph':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = risograph.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'Certificate':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Certifacate.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'RoomTransfer(Permanent)' or dataMemo.Type_Request == 'RoomTransfer(Temporary)':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Room_Transfer.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'ScheduleTransfer(Permanent)' or dataMemo.Type_Request == 'ScheduleTransfer(Temporary)':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = Schedule_Transfer.objects.get(FormID = idf)
elif dataMemo.Type_Request == 'Risograph':
dataEm = Department.objects.prefetch_related('Id_Number').get(Id_Number = dataMemo.Id_Number)
dataDetails = risograph.objects.get(FormID = idf)
if request.method == "POST":
if request.POST.get('Memo_ID') == idm:
updateMemo = Memo_Routing.objects.get(id = request.POST["Memo_ID"])
updateForm = Form.objects.get(Form_ID = idf)
if data.Status_Dept == 'Chairman':
updateMemo.Date_Chairman_Approved=datetime.today()
updateMemo.save(update_fields=['Date_Chairman_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
elif data.Status_Dept == 'Dean':
updateMemo.Date_Dean_Approved=datetime.today()
updateMemo.save(update_fields=['Date_Dean_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
elif data.Status_Dept == 'VP Academics':
if updateMemo.Type_Request == 'Cash Advance':
pass
elif updateMemo.Type_Request == 'File Leave':
pass
else:
updateMemo.Status = 'Approved'
updateForm.Status = 'Approved'
updateMemo.save(update_fields=['Status'])
updateForm.save(update_fields=['Status'])
updateMemo.Date_VP_Acad_Approved=datetime.today()
updateMemo.save(update_fields=['Date_VP_Acad_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
elif data.Status_Dept == 'President':
updateMemo.Date_President_Approved=datetime.today()
updateMemo.save(update_fields=['Date_President_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
elif data.Status_Dept == 'HR':
updateMemo.Date_HR_Approved=datetime.today()
updateMemo.save(update_fields=['Date_HR_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
elif data.Status_Dept == 'Accounting':
updateMemo.Status = 'Approved'
updateForm.Status = 'Approved'
updateMemo.save(update_fields=['Status'])
updateForm.save(update_fields=['Status'])
updateMemo.Date_Accounting_Approved=datetime.today()
updateMemo.save(update_fields=['Date_Accounting_Approved'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Approved', Date = datetime.today())
historybackup.save()
return redirect("transachis", id =data.Id_Number.Id_Number)
elif request.POST.get('Form_ID') == idf:
updateForm = Form.objects.get(Form_ID = request.POST["Form_ID"])
updateMemo = Memo_Routing.objects.get(FormID = request.POST["Form_ID"])
updateForm.Status = 'Declined'
updateMemo.Status = 'Declined'
if data.Status_Dept == 'President':
updateMemo.Date_President_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_President_Approved'])
elif data.Status_Dept == 'Chairman':
updateMemo.Date_Chairman_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_Chairman_Approved'])
elif data.Status_Dept == 'Dean':
updateMemo.Date_Dean_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_Dean_Approved'])
elif data.Status_Dept == 'VP Academics':
updateMemo.Date_VP_Acad_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_VP_Acad_Approved'])
elif data.Status_Dept == 'Accounting':
updateMemo.Date_Accounting_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_Accounting_Approved'])
elif data.Status_Dept == 'HR':
updateMemo.Date_HR_Approved=datetime.today()
updateMemo.save(update_fields=['Status','Date_HR_Approved'])
updateForm.save(update_fields=['Status'])
history = TransacHistory(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Declined', Date = datetime.today())
history.save()
historybackup = TransacHistoryBackUp(Id_Number = data.Id_Number, Faculty_Id = dataEm.Id_Number.Id_Number, Faculty_Name = dataEm.Id_Number.First_Name + " " + dataEm.Id_Number.Last_Name, Transac_Type = dataDetails.FormID.Type, Type='Declined', Date = datetime.today())
historybackup.save()
return redirect("transachis", id = data.Id_Number.Id_Number)
#updateForm = Form.objects.get(id = request.POST["Form_ID"])
#if data.Status_Dept == 'Chairman':
return render(request,"ViewRequestDetails.html",{'data' : data, 'dataDetails' : dataDetails, 'dataEm' : dataEm, 'dataMemo' : dataMemo})
def RoomTransferTemporary(request, id):
data = Department.objects.prefetch_related('Id_Number').get(Id_Number=id)
employeeID = Employee.objects.get(Id_Number=id)
if request.method == "POST":
form = Form(Id_Number=employeeID,
Type='RoomTransfer(Temporary)',
Date_Requested=datetime.today(),
Date_Approved=None,
Status='Pending')
form.save()
formPK = Form.objects.get(Form_ID=form.pk)
roomTransfer = Room_Transfer(
Id_Number=employeeID,
Type='RoomTransfer(Temporary)',
Date_Notify=datetime.today(),
Subject=request.POST["Subject"],
Offer_Code=request.POST["Offer_Code"],
Time_Day=request.POST["Time_Day"],
Room_From=request.POST["Room_From"],
Room_To=request.POST["Room_To"],
Date_Effective=request.POST["Date_Effective"],
Reason=request.POST["Reason"],
FormID=formPK)
roomTransfer.save()
if (data.Status_Dept == "Faculty"):
memo_roomTransfer = Memo_Routing(
Id_Number=employeeID,
Type_Request='RoomTransfer(Temporary)',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending')
if (data.Status_Dept == "Chairman"):
memo_roomTransfer = Memo_Routing(
Id_Number=employeeID,
Type_Request='RoomTransfer(Temporary)',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today())
if (data.Status_Dept == "Dean"):
memo_roomTransfer = Memo_Routing(
Id_Number=employeeID,
Type_Request='RoomTransfer(Temporary)',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today(),
Date_Dean_Approved=datetime.today())
memo_roomTransfer.save()
history = TransacHistory(Id_Number=employeeID,
Transac_Type='RoomTransfer(Temporary)',
Type='Submitted',
Date=datetime.today())
history.save()
historyback = TransacHistoryBackUp(
Id_Number=employeeID,
Transac_Type='RoomTransfer(Temporary)',
Type='Submitted',
Date=datetime.today())
historyback.save()
return redirect("transachis", id=data.Id_Number.Id_Number)
else:
return render(request, "Room Transfer - Temporary.html",
{'data': data})
def MakeupClass(request, id):
data = Department.objects.prefetch_related('Id_Number').get(Id_Number=id)
employeeID = Employee.objects.get(Id_Number=id)
dateApprove = None
if request.method == 'POST':
form = Form(Id_Number=employeeID,
Type='Make-up Class',
Date_Requested=datetime.today(),
Date_Approved=dateApprove,
Status='Pending')
form.save()
formPK = Form.objects.get(Form_ID=form.pk)
if (request.POST.get('options') == "others"):
makeupclass = Makeup_Class(Id_Number=employeeID,
College=request.POST["college"],
Reason=request.POST["Reason"],
OfferCode=request.POST["offercode"],
Date=datetime.today(),
Time=request.POST["time"],
Room=request.POST["room"],
Date_Of=request.POST["dateOf"],
FormID=formPK)
makeupclass.save()
if (data.Status_Dept == "Faculty"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending')
if (data.Status_Dept == "Chairman"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today())
if (data.Status_Dept == "Dean"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today(),
Date_Dean_Approved=datetime.today())
memo_makeupclass.save()
history = TransacHistory(Id_Number=employeeID,
Transac_Type='Make-up Class',
Type='Submitted',
Date=datetime.today())
history.save()
historyback = TransacHistoryBackUp(Id_Number=employeeID,
Transac_Type='Make-up Class',
Type='Submitted',
Date=datetime.today())
historyback.save()
return redirect("transachis", id=data.Id_Number.Id_Number)
else:
makeupclass = Makeup_Class(Id_Number=employeeID,
College=request.POST["college"],
Reason=request.POST.get('options'),
OfferCode=request.POST["offercode"],
Date=datetime.today(),
Time=request.POST["time"],
Room=request.POST["room"],
Date_Of=request.POST["dateOf"],
FormID=formPK)
makeupclass.save()
if (data.Status_Dept == "Faculty"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending')
if (data.Status_Dept == "Chairman"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today())
if (data.Status_Dept == "Dean"):
memo_makeupclass = Memo_Routing(
Id_Number=employeeID,
Type_Request='Make-up Class',
Date_Faculty_Submitted=datetime.today(),
FormID=formPK,
Status='Pending',
Date_Chairman_Approved=datetime.today(),
Date_Dean_Approved=datetime.today())
memo_makeupclass.save()
history = TransacHistory(Id_Number=employeeID,
Transac_Type='Make-up Class',
Type='Submitted',
Date=datetime.today())
history.save()
historyback = TransacHistoryBackUp(Id_Number=employeeID,
Transac_Type='Make-up Class',
Type='Submitted',
Date=datetime.today())
historyback.save()
return redirect("transachis", id=data.Id_Number.Id_Number)
else:
return render(request, "makeup-class.html", {'data': data})