def find_pro_name_in_database(request):
if request.method == "POST":
check_pro_id = request.POST['check']
if AddProject.objects.filter(project_name=check_pro_id).exists():
data1 = AddProject.objects.filter(project_name=check_pro_id)
user = AddProjectSerializer(data1, many=True)
return JsonResponse({'check_pro_id': user.data})
def get_all_project_for_map_for_subadmin(request):
if UserRegistration.objects.filter(id=request.session['user_id']).exists():
user_info = UserRegistration.objects.get(id=request.session['user_id'])
get_project_map = ProjectMap.objects.filter(user_id=user_info.id)
if request.session["user_type"] == "Admin":
all_project = AddProject.objects.all()
else:
all_project = AddProject.objects.filter(
id__in=Subquery(get_project_map.values("project_id")))
get_data = AddProjectSerializer(all_project, many=True)
data_get_2 = get_data.data
else:
all_project = AddProject.objects.all()
get_data = AddProjectSerializer(all_project, many=True)
data_get_2 = get_data.data
return JsonResponse({"data": data_get_2})
def get_all_project_of_user(request):
if request.method == "POST":
user_id = request.POST['user_id']
map_project = ProjectMap.objects.filter(user_id=user_id)
project_info = AddProject.objects.filter(id__in=Subquery(map_project.values("project_id"))).order_by(
"project_name")
project_info_get = AddProjectSerializer(project_info, many=True)
return JsonResponse({"data":project_info_get.data})
def get_projectList(request):
project_data = AddProject.objects.all()
get_data = AddProjectSerializer(project_data, many=True)
data_get_2 = get_data.data
return JsonResponse({
"status": "1",
"data": data_get_2,
"message": "All project list"
})
def get_all_projects(request):
if request.session['user_type'] == "Admin":
get_all_projects = AddProject.objects.all()
else:
get_project_map = ProjectMap.objects.filter(
user_id=request.session['user_id'])
get_all_projects = AddProject.objects.filter(
id__in=Subquery(get_project_map.values("project_id")))
get_data = AddProjectSerializer(get_all_projects, many=True)
get_all_projects_json = get_data.data
return JsonResponse({"data": get_all_projects_json})
def get_project_info_and_users(request):
project_id = request.POST["project_id"]
user_type = request.POST["user_type"]
project_info = AddProject.objects.filter(id=project_id)
user = AddProjectSerializer(project_info, many=True)
project_info_get = user.data
map_user_info = ProjectMap.objects.filter(project_id=project_id)
usedata = UserRegistration.objects.filter(user_type=user_type).filter(~Q(
id__in=Subquery(map_user_info.values("user_id"))))
usedata_s = UserRegistrationSerializer(usedata, many=True)
user_data_in_s = usedata_s.data
return JsonResponse({
"project_info": project_info_get,
"user_data": user_data_in_s
})
def find_user_in_database(request):
if request.method == "POST":
check_map = request.POST['check']
data3 = UserRegistration.objects.filter(~Q(user_type='Admin'))
user = UserRegistrationSerializer(data3, many=True)
# if ProjectMap.objects.filter(project_id=check_map).exists():
# data1 = ProjectMap.objects.filter(project_id=check_map)
# data2 = ProjectMapSerializer(data1, many=True)
#
# got=data2.data
# else:
# got=""
got = ""
if AddProject.objects.filter(id=check_map).exists():
data6 = AddProject.objects.filter(id=check_map)
data7 = AddProjectSerializer(data6, many=True)
pro = data7.data
return JsonResponse({'check_project': got, 'val': pro, 'user': user.data})
def project_accroding_city(request):
allObj = json.loads(request.body)
# userid = "2"
userid = allObj['user_id']
if userid == "":
return JsonResponse({"status": "0", "message": "user_id is required"})
else:
if ProjectMap.objects.filter(user_id=userid).exists():
user_data = ProjectMap.objects.filter(user_id=userid)
#project_info = AddProject.objects.filter(id__in=Subquery(user_data.values("project_id"))).annotate(dcount=Count('project_city'))
project_info = AddProject.objects.values('project_city').filter(
id__in=Subquery(user_data.values("project_id"))).annotate(
dcount=Count('project_city'))
# project_info = AddProject.objects.raw('Select project_city from addproject')
get_data = CityProjectSerializer(project_info, many=True)
data_get_2 = get_data.data
# for orject
for city in data_get_2:
city_project = AddProject.objects.filter(
id__in=Subquery(user_data.values("project_id"))).filter(
project_city=city["project_city"])
city_project_s = AddProjectSerializer(city_project, many=True)
city["city_project"] = city_project_s.data
return JsonResponse({
"status": "1",
"data": data_get_2,
"message": "Project list according to id"
})
else:
return JsonResponse({
"status": "1",
"data": "",
"message": "No country available"
})
def getProjectListUserWise(request):
allObj = json.loads(request.body)
# userid = "2"
userid = allObj['user_id']
if userid == "":
return JsonResponse({"status": "0", "message": "user_id is required"})
else:
if ProjectMap.objects.filter(user_id=userid).exists():
user_data = ProjectMap.objects.filter(user_id=userid)
project_info = AddProject.objects.filter(
id__in=Subquery(user_data.values("project_id")))
get_data = AddProjectSerializer(project_info, many=True)
data_get = get_data.data
return JsonResponse({
"status": "1",
"data": data_get,
"message": "Project list according to id"
})
else:
return JsonResponse({
"status": "1",
"data": "",
"message": "No country available"
})