def deleteRC(request, wsid, rcid):
page_id = 50
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
q = Accomodation.objects.raw(
'select * from accomodation where instituteid=%s and workshopid=%s',
[rcid, wsid])
for each in q:
if (each.participantid.status != 'Cancelled'):
context = {
"wsid": wsid,
}
context.update(globals.myList)
return render(request, 'deleteError.html', context)
cursor = connection.cursor()
cursor.execute(
"UPDATE remotecentercapacity SET is_active = 0 WHERE rcid = %s",
[rcid])
resultset = Workshops.objects.raw(
'select workshopid,workshopname from workshops limit 15')
context = {
"objects": resultset,
"wsid": wsid,
}
context.update(globals.myList)
return render(request, "deleteMessage.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def manageparticipants(request, rcid, wsid):
page_id = 54
#role_id=1
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
qacco = Accomodation.objects.filter(workshopid=wsid, instituteid=rcid)
wshop = Workshops.objects.get(workshopid=wsid)
invalidReasons = Lookups.objects.filter(category='INVALID_RC',
isactive=1)
qmain = []
for each in qacco:
if (each.participantid.status == 'Request Approved'):
each.firstname = each.participantid.personid.firstname
each.lastname = each.participantid.personid.lastname
each.email = each.participantid.contextid.email
qmain.append(each)
context = {
"object_list": qmain,
"wshop": wshop,
"listReasons": invalidReasons,
}
context.update(globals.myList)
return render(request, "manageParticipants.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def updateRC(request, wsId, rcId, availableSeats, availableAccomo, accoCost,
foodCost):
page_id = 57
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
qs = Workshops.objects.raw(
'SELECT * FROM workshops where workshopid=%s', [wsId])
context = {
"wsid": wsId,
"rcid": rcId,
"available_seats": availableSeats,
"available_accomo": availableAccomo,
"accoCost": accoCost,
"foodCost": foodCost,
"workshopname": qs[0].workshopname,
"startdate": qs[0].startdate,
"enddate": qs[0].enddate,
"workshop": qs[0],
}
context.update(globals.myList)
return render(request, "updateRCCapacity.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def rCCapacityDetails(request, workshopid, rcid):
page_id = 51
#role_id=1
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
qs = Remotecentercapacity.objects.filter(workshopid=workshopid,
rcid=rcid)
if (len(list(qs)) != 0):
qs1 = WorkshopCoordinator.objects.filter(workshopid=workshopid,
rcid=rcid)
context = {
"fcc": qs1[0].email,
"objects": qs[0],
"workshopid": workshopid,
"rcid": rcid,
}
context.update(globals.myList)
return render(request, "RCCapacityDetails.html", context)
else:
context = {
"objects": 0,
"workshopid": workshopid,
"rcid": rcid,
}
context.update(globals.myList)
return render(request, "RCCapacityDetails.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def addRC(request, workshopId):
page_id = 49
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
remotecentercap = Remotecentercapacity()
remotecentercap.rcid = request.POST.get('rcId')
#remotecentercap.workshopid = request.POST.get('workshopId')
remotecentercap.workshopid = workshopId
remotecentercap.available_seats = request.POST.get('seats')
remotecentercap.available_accomo = request.POST.get('acco')
remotecentercap.allotedrc = 0
if (request.POST.get('accoCost') != ''):
remotecentercap.acco_cost = request.POST.get('accoCost')
else:
remotecentercap.acco_cost = 'None'
if (request.POST.get('foodCost') != ''):
remotecentercap.food_cost = request.POST.get('foodCost')
else:
remotecentercap.food_cost = 'None'
queryset = Remotecentercapacity.objects.raw(
'SELECT * FROM remotecentercapacity where workshopid=%s and rcid=%s',
[workshopId, request.POST.get('rcId')])
q = Remotecenter.objects.raw(
'select * from remotecenter where remotecenterid=%s',
[request.POST.get('rcId')])
if (len(list(queryset)) == 0):
remotecentercap.save()
cursor = connection.cursor()
cursor.execute(
"UPDATE remotecentercapacity SET is_active = 1 WHERE rcid = %s ",
[request.POST.get('rcId')])
context = {
"wsid": workshopId,
}
context.update(globals.myList)
return render(request, "message.html", context)
else:
context = {
"wsid": workshopId,
}
context.update(globals.myList)
return render(request, "rcAlreadyPresent.html", context)
else:
return HttpResponseRedirect("/")
def updateMessage(request):
page_id = 56
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
context = {}
context.update(globals.myList)
return render(request, "updateMessage.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def viewProgramSchedule(request, wsid):
page_id = 59
#role_id=1
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
wshop = Workshops.objects.get(workshopid=wsid)
queryset = ProgramSchedule.objects.filter(workshopid=wsid)
context = {
"queryset": queryset,
"wshop": wshop,
}
context.update(globals.myList)
return render(request, "viewProgramSchedule.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def manage(request):
page_id = 52
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
d = datetime.date.today() - datetime.timedelta(days=90)
resultset = Workshops.objects.raw(
'select workshopid,workshopname from workshops where workshopid>0 and startdate>%s order by startdate',
[d])
context = {
"objects": resultset,
}
context.update(globals.myList)
return render(request, "manageRC.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def manageRC(request, workshopId=None):
page_id = 53
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
ws = Workshops.objects.get(workshopid=workshopId)
d = datetime.date.today() - datetime.timedelta(days=90)
resultset = Workshops.objects.raw(
'select workshopid,workshopname from workshops where workshopid>0 and startdate>%s order by startdate',
[d])
queryset = Remotecentercapacity.objects.raw(
'SELECT * FROM remotecentercapacity where workshopid=%s and is_active=1 order by rcid',
[workshopId])
queryset1 = []
for each in queryset:
#x=Remotecenter.objects.get(remotecenterid=each.rcid)
x = Remotecenter.objects.raw(
'select * from remotecenter where remotecenterid=%s',
[each.rcid])
for y in x:
each.rcname = y.remotecentername
queryset1.append(each)
context = {
"object_list": queryset1,
"objects": resultset,
"wsid": workshopId,
"wsname": ws.workshopname,
"workshop": ws,
}
context.update(globals.myList)
return render(request, "manageRCCapacity.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def rCCInterface(request):
page_id = 55
#role_id=1
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
remcenter = Remotecenter.objects.filter(email=request.session["email"])
qs = Workshops.objects.raw(
"select * from workshops where startdate > curdate() order by startdate"
)
qs1 = []
d = datetime.date.today() - datetime.timedelta(days=90)
i = 0
for each in qs:
x = Remotecentercapacity.objects.filter(
workshopid=each.workshopid, rcid=remcenter[0].remotecenterid)
if (len(list(x)) != 0):
each.is_declined = x[0].is_declined
qs1.append(each)
else:
each.is_declined = 0
qs1.append(each)
q = Workshops.objects.filter(startdate__gt=d,
categorycode=7).order_by('startdate')
context = {
"date": datetime.date.today(),
"objects": qs1,
"rcid": remcenter[0].remotecenterid,
"objectSet": q,
}
context.update(globals.myList)
return render(request, "RCCInterface.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def add(request, workshopId):
page_id = 48
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
queryset = Workshops.objects.raw(
'SELECT * FROM workshops where workshopid=%s', [workshopId])
context = {
"workshopId": workshopId,
"workshopname": queryset[0].workshopname,
"startdate": queryset[0].startdate,
"enddate": queryset[0].enddate,
"cc": queryset[0].categorycode,
}
context.update(globals.myList)
return render(request, "addNewRC.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def updateRCSuccess(request, wsid, rcId):
page_id = 58
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
#remotecentercap = Remotecentercapacity()
#remotecentercap.workshopid=wsid
#remotecentercap.rcid=rcId
available_seats = request.POST.get('seats')
available_accomo = request.POST.get('accomo')
acco_cost = request.POST.get('accoCost')
food_cost = request.POST.get('foodCost')
cursor = connection.cursor()
cursor.execute(
"UPDATE remotecentercapacity SET available_seats = %s WHERE rcid = %s and workshopid=%s",
[available_seats, rcId, wsid])
cursor.execute(
"UPDATE remotecentercapacity SET available_accomo = %s WHERE rcid = %s and workshopid=%s",
[available_accomo, rcId, wsid])
cursor.execute(
"UPDATE remotecentercapacity SET acco_cost = %s WHERE rcid = %s and workshopid=%s",
[acco_cost, rcId, wsid])
cursor.execute(
"UPDATE remotecentercapacity SET food_cost = %s WHERE rcid = %s and workshopid=%s",
[food_cost, rcId, wsid])
context = {
"wsid": wsid,
}
context.update(globals.myList)
return render(request, "updateMessage.html", context)
else:
return HttpResponseRedirect("/")
def viewRCParticipants(request, wsid, n, rcid):
page_id = 61
#role_id=1
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
state = State.objects.all()
wshop = Workshops.objects.get(workshopid=wsid)
rcname = Remotecenter.objects.get(remotecenterid=rcid).remotecentername
rr = 0
ri = 0
ra = 0
con = 0
com = 0
can = 0
acc = 0
accoQuerySet = Accomodation.objects.filter(workshopid=wsid,
instituteid=rcid)
al = len(accoQuerySet)
queryset = []
for each in accoQuerySet:
sta = each.participantid.status
if (sta == 'Request Registered'):
rr += 1
elif (sta == 'Registration Invalid'):
ri += 1
elif (sta == 'Request Approved'):
ra += 1
elif (sta == 'Confirmed'):
con += 1
elif (sta == 'Completed'):
com += 1
elif (sta == 'Cancelled'):
can += 1
elif (sta == 'Accepted'):
acc += 1
elif (sta == 'Completed'):
com += 1
qs = []
if (int(n) == 0):
for each in accoQuerySet:
qs.append(each)
elif (int(n) == 1):
for each in accoQuerySet:
if (each.participantid.status == 'Request Registered'):
qs.append(each)
elif (int(n) == 2):
for each in accoQuerySet:
if (each.participantid.status == 'Registration Invalid'):
qs.append(each)
elif (int(n) == 3):
for each in accoQuerySet:
if (each.participantid.status == 'Request Approved'):
qs.append(each)
elif (int(n) == 4):
for each in accoQuerySet:
if (each.participantid.status == 'Confirmed'):
qs.append(each)
elif (int(n) == 5):
for each in accoQuerySet:
if (each.participantid.status == 'Completed'):
qs.append(each)
elif (int(n) == 6):
for each in accoQuerySet:
if (each.participantid.status == 'Cancelled'):
qs.append(each)
elif (int(n) == 7):
for each in accoQuerySet:
if (each.participantid.status == 'Accepted'):
qs.append(each)
for each in qs:
each.firstname = each.participantid.personid.firstname
each.lastname = each.participantid.personid.lastname
each.gender = each.participantid.personid.genderinfo
each.desig = each.designation = (Lookups.objects.get(
category='designation',
code=each.participantid.personid.designation)).description
each.instituteid = Institute.objects.get(
idinstitute=each.participantid.personid.instituteid
).institutename
each.mobNo = each.participantid.contextid.mobile
each.email = each.participantid.contextid.email
each.state = State.objects.get(
stateid=each.participantid.contextid.state).state
each.status = each.participantid.status
queryset.append(each)
context = {
"wshop": wshop,
"queryset": queryset,
"rcid": rcid,
"rcname": rcname,
"rr": rr,
"ri": ri,
"ra": ra,
"con": con,
"com": com,
"can": can,
"all": al,
}
context.update(globals.myList)
return render(request, "viewRCParticipants.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
def viewRC(request, wsid, n):
page_id = 60
#role_id=5
try:
role_id = request.session['role_id']
except Exception:
role_id = 0
if (role_manage_models.check_page_permission(role_id, page_id)):
globals.init()
qs = Workshops.objects.get(workshopid=wsid)
rcc = Remotecentercapacity.objects.filter(workshopid=wsid)
ans = []
for each in rcc:
x = Remotecenter.objects.get(remotecenterid=each.rcid)
each.rcname = x.remotecentername
each.rcstate = x.state.state
seat = Accomodation.objects.filter(workshopid=wsid,
instituteid=each.rcid)
acco = Accomodation.objects.filter(workshopid=wsid,
accomodation='Yes',
instituteid=each.rcid)
i = 0
j = 0
for each1 in acco:
if (each1.participantid.status != 'Cancelled'):
i += 1
for each1 in seat:
if (each1.participantid.status != 'Cancelled'):
j += 1
each.acco_booked = i
each.seats_booked = j
each.seats_remain = each.available_seats - j
ans.append(each)
if (n == '0'):
context = {
"wsid": wsid,
"object_list": ans,
"workshopname": qs.workshopname,
"startdate": qs.startdate,
"enddate": qs.enddate,
}
elif (n == '1'):
ans1 = []
for each in ans:
if (each.seats_booked == 0):
ans1.append(each)
context = {
"wsid": wsid,
"object_list": ans1,
"workshopname": qs.workshopname,
"startdate": qs.startdate,
"enddate": qs.enddate,
}
elif (n == '2'):
ans2 = []
for each in ans:
if (each.seats_booked > 0 and each.seats_booked <= 5):
ans2.append(each)
context = {
"wsid": wsid,
"object_list": ans2,
"workshopname": qs.workshopname,
"startdate": qs.startdate,
"enddate": qs.enddate,
}
elif (n == '3'):
ans3 = []
for each in ans:
if (each.seats_remain >= 0 and each.seats_remain <= 5):
ans3.append(each)
context = {
"wsid": wsid,
"object_list": ans3,
"workshopname": qs.workshopname,
"startdate": qs.startdate,
"enddate": qs.enddate,
}
elif (n == '4'):
ans4 = []
for each in ans:
if (each.seats_remain < 0):
ans4.append(each)
context = {
"wsid": wsid,
"object_list": ans4,
"workshopname": qs.workshopname,
"startdate": qs.startdate,
"enddate": qs.enddate,
}
context.update(globals.myList)
return render(request, "viewRCCapacity.html", context)
else:
storePrevUrl(request, HttpRequest.build_absolute_uri(request))
return HttpResponseRedirect("/")
