def advcompanies(request):
cmd = CoordManaged.objects.filter(coord__id = request.user.id)
try:
cmds = cmd.get(semester__current = True)
except :
cmds = CoordManaged()
cmds.semester = Semester.objects.get(current = True)
cmds.coord = BitsCoordinator.objects.get(pk = request.user.id)
cmds.save()
if request.user.has_perm('coordinator.can_add_companies'):
form = CompanyForm(instance=cmds)
else:
form = ''
coms = cmd
if request.POST:
form = CompanyForm(request.POST,instance=cmds)
if form.is_valid():
if request.user.has_perm('coordinator.can_add_companies'):
form.save()
message = 'Companies have been saved'
else:
message = 'You do not have permissions to edit.'
return render_to_response('companies.html',{'form':form,'companies':coms,'message':message},context_instance=RequestContext(request))
#coms = Company.objects.select_related().filter(coordmanaged__coord__id = request.user.id)
return render_to_response('companies.html',{'form':form,'companies':coms},context_instance=RequestContext(request))
def imports(request):
form = ImportForm()
if request.method == "POST":
if request.POST["type"] == "bitscoords":
import xlrd
i = Import()
i.file = request.FILES["file"]
i.save()
print i
from wilp.settings import MEDIA_ROOT
path = MEDIA_ROOT + i.file.name
book = xlrd.open_workbook(path)
sh = book.sheet_by_index(0)
for rx in range(sh.nrows):
c = BitsCoordinator()
c.username = sh.cell_value(rx, 0)
c.first_name = "".join(str(sh.cell_value(rx, 1)).rsplit(" ", 1)[:-1])
c.last_name = "".join(str(sh.cell_value(rx, 1)).rsplit(" ", 1)[-1:])
c.email = sh.cell_value(rx, 2)
c.address = sh.cell_value(rx, 3)
c.fax = sh.cell_value(rx, 4)
c.gender = "F" if str(sh.cell_value(rx, 5)) == "Female" else "M"
c.mobile = sh.cell_value(rx, 6)
c.phone = sh.cell_value(rx, 7)
c.previous_experience = sh.cell_value(rx, 8)
c.qualification = sh.cell_value(rx, 9)
c.set_password(str(c.username))
try:
c.save()
except:
pass
messages.success(request, "Successfuly imported " + str(sh.nrows) + " BITS Coordinators")
return render_to_response("imports.html", {"form": form}, context_instance=RequestContext(request))
if request.POST["type"] == "companies":
import xlrd
i = Import()
i.file = request.FILES["file"]
i.save()
print i
from wilp.settings import MEDIA_ROOT
path = MEDIA_ROOT + i.file.name
book = xlrd.open_workbook(path)
sh = book.sheet_by_index(0)
for rx in range(sh.nrows):
place = sh.cell_value(rx, 0)
cname = sh.cell_value(rx, 1)
try:
p = Place.objects.get(place=place)
c = Company()
c.name = cname
c.place = p
try:
c.save()
except:
pass
except:
p = Place()
p.place = place
p.save()
c = Company()
c.name = cname
c.place = p
try:
c.save()
except:
pass
c = Company.objects.get(name=cname, place=p)
s = Semester.objects.get(current=True)
s.companies.add(c)
s.save()
try:
co = BitsCoordinator.objects.get(username=sh.cell_value(rx, 2))
try:
cm = CoordManaged.objects.get(coord=co, semester=s)
cm.companies.add(c)
except:
cm = CoordManaged()
cm.semester = s
cm.coord = co
cm.save()
cm.companies.add(c)
cm.save()
except:
pass
messages.success(request, "Successfuly imported " + str(sh.nrows) + " companies")
return render_to_response("imports.html", {"form": form}, context_instance=RequestContext(request))
if request.POST["type"] == "faculty":
import xlrd
i = Import()
i.file = request.FILES["file"]
i.save()
from wilp.settings import MEDIA_ROOT
path = MEDIA_ROOT + i.file.name
book = xlrd.open_workbook(path)
sh = book.sheet_by_index(0)
for rx in range(sh.nrows):
fac = Faculty()
fac.fac_name = sh.cell_value(rx, 0)
programme = sh.cell_value(rx, 1)
try:
prog = Programme.objects.get(name__exact=programme)
except:
prog = Programme()
prog.name = programme
prog.save()
company = str(sh.cell_value(rx, 2)).split("-")
print company
c = get_company(company)
print c
if company != None:
try:
ps = ProrammeSem.objects.get(programme=prog)
ps.company.add(c)
ps.save()
except:
ps = ProrammeSem()
ps.programme = prog
ps.semester = Semester.objects.get(current=True)
ps.save()
if c:
ps.company.add(c)
ps.save()
corse = str(sh.cell_value(rx, 3)).split(" ", 3)
print corse
try:
course = Course.objects.get(code=corse[2])
try:
pcs = prog.courses.all()
if course not in pcs:
prog.courses.add(course)
prog.save()
except:
prog.courses.add(course)
except:
course = Course()
course.name = corse[3]
course.code = corse[2]
course.cat = corse[1]
course.save()
prog.courses.add(course)
prog.save()
fac.email = sh.cell_value(rx, 5)
fac.phone = sh.cell_value(rx, 15)
fac.mobile = sh.cell_value(rx, 11)
fac.pan_no = sh.cell_value(rx, 14)
fac.gender = sh.cell_value(rx, 9)
fac.highest_degree = sh.cell_value(rx, 10)
fac.expertise_area = sh.cell_value(rx, 7)
fac.indus_exp = sh.cell_value(rx, 17)
fac.teach_exp = sh.cell_value(rx, 19)
fac.curr_aff = sh.cell_value(rx, 4)
fac.hrs = 0
fac.bank_acc = sh.cell_value(rx, 18)
fac.dd = sh.cell_value(rx, 20)
fac.save()
fs = FacultySem()
fs.faculty = fac
if c:
fs.company = c
fs.programme = prog
fs.semester = Semester.objects.get(current=True)
fs.course = course
fs.batch_no = sh.cell_value(rx, 6)
fs.section_no = sh.cell_value(rx, 16)
fs.no_of_students = sh.cell_value(rx, 13)
fs.hrs_expected = sh.cell_value(rx, 12)
fs.honorarium = 100
fs.honorarium_final = 100
fs.save()
messages.success(request, "Successfuly imported " + str(sh.nrows) + " facultys")
return render_to_response("imports.html", {"form": form}, context_instance=RequestContext(request))
if request.POST["type"] == "companycoord":
import xlrd
i = Import()
i.file = request.FILES["file"]
i.save()
from wilp.settings import MEDIA_ROOT
path = MEDIA_ROOT + i.file.name
book = xlrd.open_workbook(path)
sh = book.sheet_by_index(0)
for rx in range(sh.nrows):
c = CompanyCoordinator()
company = str(sh.cell_value(rx, 1)).split("-")
c.name = str(sh.cell_value(rx, 0))
c.address = str(sh.cell_value(rx, 2))
c.email = str(sh.cell_value(rx, 3))
c.phone = str(sh.cell_value(rx, 4))
c.company = get_company(company)
bc = CoordManaged.objects.get(companies=get_company(company))
c.author = bc.coord
c.save()
c.semester.add(Semester.objects.get(current=True))
c.save()
messages.success(request, "Successfuly imported " + str(sh.nrows) + " company coordinators")
return render_to_response("imports.html", {"form": form}, context_instance=RequestContext(request))
else:
return render_to_response("imports.html", {"form": form}, context_instance=RequestContext(request))
