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 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 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})