def datisw(request, id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
datis_w = models.Datisweekly.objects.all()
datis_w = datis_w.values('p_id', 'date', 'time', 'status',
'serveraorb', 'ups_ip', 'ups_op',
'dust_free', 'lan_status', 'remarks')
datis_w = datis_w.filter(emp_id=id)
datisw = datis_w.order_by('-p_id')
datis_w = datis_w.filter(date=date.today())
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name', 'contact',
'email').filter(dept='C')
datiswlogs = models.Datiswlogs.objects.all()
datiswlogs = datiswlogs.filter(
date=date.today()).order_by('-log_id')
if datis_w:
return render(
request, 'engineer/datis/datisweeklyrep.html', {
'datiswlogs': datiswlogs,
'supdetails': supdetails,
'datis_w': datis_w,
'id': id,
'datisw': datisw
})
else:
return routebackdatisd(request, id)
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def homew(request, id, p_id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
datis_w = models.Datisweekly.objects.all().filter(emp_id=id)
datisw = datis_w.order_by('-p_id')
datis_w = datis_w.filter(p_id=p_id)
status = datis_w.values('status')[0]['status']
f = 0
if status == "COMPLETED WITH ERRORS" or status == "PENDING":
f = 1
supdetails = models.Supervisor.objects.all().values(
'name', 'contact', 'email').filter(dept='C')
datiswlogs = models.Datiswlogs.objects.all().filter(
p_id=p_id).order_by('-log_id')
if datis_w:
return render(
request, 'engineer/datis/datisweeklyrep.html', {
'datiswlogs': datiswlogs,
'supdetails': supdetails,
'datis_w': datis_w,
'id': id,
'datisw': datisw,
'f': f
})
else:
return routebackdatisd(request, id)
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def dscndrep(request, id):
cursor = connection.cursor()
if request.session.has_key('uid'):
temp = cursor.execute("select date from dscndaily where date = %s",
[date.today()])
uid = request.session['uid']
if int(uid) == int(id) and temp == 0:
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name', 'contact',
'email').filter(dept='C')
dscn_d = models.Dscndaily.objects.all()
dscn_d = dscn_d.values('p_id', 'date', 'time', 'sat_led',
'odu_led', 'io_led', 'alarm_led',
'power_led', 'v35_led', 'ip_voltage',
'op_voltage', 'battery_voltage',
'coro_function', 'remarks')
dscn_d = dscn_d.filter(emp_id=id).order_by('-p_id')
return render(request, 'engineer/dscn/dscnrepsub.html', {
'id': id,
'dscn_d': dscn_d,
'supdetails': supdetails
})
else:
messages.add_message(request, 30, 'Unauthorized Access')
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def repsubwerrors(request,p_id,id):
if request.session.has_key('uid'):
uid=request.session['uid']
if int(uid) == int(id):
cursor = connection.cursor()
datisw = models.Datisweekly.objects.all()
datisw = datisw.values('p_id','date','time','status','emp_id','serveraorb','ups_ip','ups_op','dust_free','lan_status','remarks')
datisw = datisw.filter(p_id=p_id)
return render(request,'engineer/datis/datiswfinalrep.html',{'datisw':datisw,'p_id':p_id,'id':id})
else :
return routebackdatisd(request, uid)
else :
return render(request,'login/login.html')
def datisweeklyrec(request, id):
if request.session.has_key('uid'):
uid=request.session['uid']
if int(uid) == int(id):
cursor = connection.cursor()
datis_w = models.Datisweekly.objects.all()
datis_w = datis_w.values('p_id','date','time','status','serveraorb','ups_ip','ups_op','dust_free','lan_status','unit_incharge_approval','approval_date','approval_time')
datis_w = datis_w.filter(emp_id=id).order_by('-p_id')
return render(request,'engineer/datis/datiswrecords.html',{'datis_w':datis_w,'id':id})
else :
messages.add_message(request,30, 'You cannot make changes to pending report!')
return routebackdatisd(request, uid)
else :
return render(request,'login/login.html')
def dscnd(request, id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
currdate = date.today()
cursor = connection.cursor()
dscn_d = models.Dscndaily.objects.all()
dscn_d = dscn_d.values('p_id', 'date', 'time', 'status', 'sat_led',
'odu_led', 'io_led', 'alarm_led',
'power_led', 'v35_led', 'ip_voltage',
'op_voltage', 'battery_voltage',
'coro_function', 'remarks')
dscn_d = dscn_d.filter(emp_id=id)
dscnd = dscn_d.order_by('-p_id')
dscn_d = dscn_d.filter(date=currdate)
dscndlogs = models.Dscndlogs.objects.all()
dscndlogs = dscndlogs.filter(date=date.today()).order_by('-log_id')
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name', 'contact',
'email').filter(dept='C')
if dscn_d:
return render(
request, 'engineer/dscn/dscndailyrep.html', {
'supdetails': supdetails,
'dscn_d': dscn_d,
'id': id,
'dscnd': dscnd,
'dscndlogs': dscndlogs
})
else:
messages.add_message(
request, 30, 'You cannot make changes to pending report!')
return routebackdatisd(request, uid)
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def homedsd(request, id, p_id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
cursor = connection.cursor()
currdate = date.today()
dscn_d = models.Dscndaily.objects.all().filter(emp_id=id)
dscnd = dscn_d.order_by('-p_id')
dscn_d = dscn_d.filter(p_id=p_id)
status = dscn_d.values('status')[0]['status']
f = 0
if status == "COMPLETED WITH ERRORS" or status == "PENDING":
f = 1
if dscn_d:
dscndlogs = models.Dscndlogs.objects.all().filter(
p_id=p_id).order_by('-log_id')
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name', 'contact',
'email').filter(dept='C')
return render(
request, 'engineer/dscn/dscndailyrep.html', {
'supdetails': supdetails,
'dscn_d': dscn_d,
'id': id,
'dscnd': dscnd,
'dscndlogs': dscndlogs,
'f': f
})
else:
messages.add_message(
request, 30, 'You cannot make changes to pending report!')
return routebackdatisd(request, id)
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def datiswrep(request, id) :
cursor = connection.cursor()
if request.session.has_key('uid'):
temp = cursor.execute("select date from datisweekly where date = %s",[date.today()])
uid=request.session['uid']
if int(uid) == int(id) and temp == 0:
datis_w = models.Datisweekly.objects.all()
datis_w = datis_w.values('p_id','date','time','serveraorb','ups_ip','ups_op','dust_free','lan_status','remarks')
datis_w = datis_w.filter(emp_id=id).order_by('-p_id')
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name','contact','email').filter(dept='C')
return render(request,'engineer/datis/datiswrepsub.html',{'datis_w':datis_w,'id':id,'supdetails':supdetails})
else :
return routebackdatisd(request, uid)
else :
return render(request,'login/login.html')
def repsubdsderrors(request, p_id, id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
cursor = connection.cursor()
dscnd = models.Dscndaily.objects.all()
dscnd = dscnd.values('p_id', 'date', 'time', 'status', 'sat_led',
'odu_led', 'io_led', 'alarm_led', 'power_led',
'v35_led', 'ip_voltage', 'op_voltage',
'battery_voltage', 'coro_function')
dscnd = dscnd.filter(p_id=p_id)
return render(request, 'engineer/dscn/dscnfinalrep.html', {
'dscnd': dscnd,
'p_id': p_id,
'id': id
})
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def dscndailyrec(request, id):
if request.session.has_key('uid'):
uid = request.session['uid']
if int(uid) == int(id):
cursor = connection.cursor()
dscn_d = models.Dscndaily.objects.all()
dscn_d = dscn_d.values('p_id', 'date', 'time', 'status', 'sat_led',
'odu_led', 'io_led', 'alarm_led',
'power_led', 'v35_led', 'ip_voltage',
'op_voltage', 'battery_voltage',
'coro_function', 'unit_incharge_approval',
'approval_date', 'approval_time')
dscn_d = dscn_d.filter(emp_id=id).order_by('-p_id')
return render(request, 'engineer/dscn/dscndrecords.html', {
'dscn_d': dscn_d,
'id': id
})
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def editdatisweekly(request, p_id) :
if request.session.has_key('uid'):
temp = models.Datisweekly.objects.all().values('status').order_by('-date').filter(date=date.today())[0]['status']
emp_id = models.Datisweekly.objects.all().values('emp_id').filter(p_id=p_id)[0]['emp_id']
uid=request.session['uid']
if int(uid) == int(emp_id) and temp == "PENDING" :
cursor = connection.cursor()
emp_id = models.Datisweekly.objects.all()
emp_id = emp_id.values('emp_id').filter(p_id=p_id)[0]['emp_id']
datisw = models.Datisweekly.objects.all()
datisw = datisw.values('p_id','date','time','status','emp_id','serveraorb','ups_ip','ups_op','dust_free','lan_status','remarks')
datis_w = datisw.filter(emp_id=emp_id).order_by('-p_id')
datisw = datisw.filter(p_id=p_id)
datis_id = datisw.values('p_id').filter(p_id=p_id)[0]['p_id']
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name','contact','email').filter(dept='C')
datiswlogs = models.Datiswlogs.objects.all()
datiswlogs = datiswlogs.filter(date=date.today()).order_by('-log_id')
return render(request,'engineer/datis/editdatiswrepsub.html',{'datiswlogs':datiswlogs,'datisw':datisw,'id':datis_id,'datis_w':datis_w,'supdetails':supdetails})
else :
return routebackdatisd(request, uid)
else :
return render(request,'login/login.html')
def editdscndaily(request, p_id):
if request.session.has_key('uid'):
uid = request.session['uid']
temp = models.Dscndaily.objects.all().values('status').order_by(
'-date').filter(date=date.today())[0]['status']
emp_id = models.Dscndaily.objects.all().values('emp_id').filter(
p_id=p_id)[0]['emp_id']
uid = request.session['uid']
if int(uid) == int(emp_id) and temp == "PENDING":
emp_id = models.Dscndaily.objects.all()
emp_id = emp_id.values('emp_id').filter(p_id=p_id)[0]['emp_id']
dscnd = models.Dscndaily.objects.all()
dscnd = dscnd.values('p_id', 'date', 'time', 'status', 'emp_id',
'sat_led', 'odu_led', 'io_led', 'alarm_led',
'power_led', 'v35_led', 'ip_voltage',
'op_voltage', 'battery_voltage',
'coro_function', 'remarks',
'unit_incharge_approval', 'remarks')
dscn_d = dscnd.filter(emp_id=emp_id).order_by('-p_id')
dscnd = dscnd.filter(p_id=p_id)
dscndlogs = models.Dscndlogs.objects.all()
dscndlogs = dscndlogs.filter(date=date.today()).order_by('-log_id')
supdetails = models.Supervisor.objects.all()
supdetails = supdetails.values('name', 'contact',
'email').filter(dept='C')
return render(
request, 'engineer/dscn/editdscnrepsub.html', {
'supdetails': supdetails,
'dscnd': dscnd,
'id': p_id,
'dscn_d': dscn_d,
'dscndlogs': dscndlogs
})
else:
return routebackdatisd(request, uid)
else:
return render(request, 'login/login.html')
def routebackvhfd(request , id): return routebackdatisd(request,id)
