def checkuser(self, username): try: user_exists = User.objects.get(username=username) response = getResponse("success", "successfully got the user") except: response = getResponse("failure", "nith does not exist") return response
def post(self,request): body_unicode=request.body.decode('utf-8') data=json.loads(body_unicode) print(data) final_array=[] try: comp_tg_inst=ProjectComponentsTags.objects.raw("select a.id,d.name, a.tag_id,b.component_name,c.tag_type_id,e.project_name,b.created_at,b.updated_at from project_components_tags as a INNER JOIN project_component as b on a.project_id =" +str(data["project_id"])+"&& a.is_active=1 = b.id && b.user_id="+str(request.user.id) +" INNER JOIN tags as c on a.tag_id=c.id INNER JOIN tagtype as d on c.tag_type_id=d.id INNER JOIN project as e on e.id=a.project_id") except ProjectComponentsTags.DoesNotExist: return getResponse('failure','failed to do this operation',"data not found") # comp_tg_inst.columns //['id','component_name','tag_id' etc.,] # paginator=Paginator(comp_tg_inst,count) # use=paginator.page(page) # for obj in use: for obj in comp_tg_inst: data={} data['id']=obj.id data['component_name']=obj.component_name data['tag_id']=obj.tag_id data['tag_type']=obj.name data["project_name"]=obj.project_name # data["created_at"]=obj.created_at # data["updated_at"]=obj.updated_at final_array.append(data) if final_array: response=getResponse('success','successfully got component list',final_array) else: response=getResponse('failure',"data not found") return response
def password_reset(request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) token = data['token'] password1 = data['password1'] password2 = data['password2'] try: pwd_rst = PasswordReset.objects.get(token=token, status=1) print(pwd_rst) except PasswordReset.DoesNotExist: raise Http404 print(pwd_rst.user_id) try: user_info = User.objects.get(id=pwd_rst.user_id) except PasswordReset.DoesNotExist: raise Http404 if password1 == password2: user_info.password = make_password(password2) user_info.save() pwd_rst.status = 0 pwd_rst.save() response = getResponse('success', 'successfully resetted password') else: response = getResponse('failure', 'password mismatch') return response
def post(self, request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) print(data) # cursor = connection.cursor() # cursor.execute('''INSERT INTO auth_group_permissions (group_id,permission_id) Values(data["group_id"],data["permission_id"])''') # cursor.execute(''' SELECT * FROM auth_group_permissions''') group_instance = Group.objects.get(id=data["role_id"]) print("group ", group_instance) try: group_instance.permissions.clear() except: response = None if group_instance: c = [] for i in data["selectedpermission"]: data = {} per = Permission.objects.get(id=i) group_instance.permissions.add(per) response = getResponse("success", "successfully created") else: response = getResponse("failure", "failed to do this operation") return response
def post(self, request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) arr = [] final_array = [] try: unassign_tag = TagDetails.objects.exclude(pk__in=[ i.tag_id for i in ProjectComponentsTags.objects.filter(is_active=1) ]) for i in unassign_tag: arr.append(i.id) try: v = TagDetails.objects.get(pk__in=[ i.tag_id for i in ProjectComponentsTags.objects.filter( component_id=data["component_id"], is_active=1) ]) arr.append(v.id) except TagDetails.DoesNotExist: arr = arr except TagDetails.DoesNotExist: raise Http404 for i in arr: data = {} data['tag_id'] = i final_array.append(data) if final_array: response = getResponse('success', 'successfully got the unassigned tag', final_array) else: response = getResponse('failure', 'failed to do this operation') return response
def post(self,request): if 'id' in request.data: library_inst =self.get_or_object(request.data['id']) try: notify_inst =CompLibDigitalNotify.objects.get(Component_library=request.data['id']) except CompLibDigitalNotify.DoesNotExist: return None # serializers=ComponentsLibrarySerializers(Comp_tag_instance,data=data) response=getResponse('success','successfully updated') else: library_inst = ComponentsLibrary() notify_inst = CompLibDigitalNotify() response=getResponse('success','successfully created') # serializers=ComponentsLibrarySerializers(data=data) # try: # component_inst = TagType.objects.get(id=request["component_type_id"]) # except TagType.DoesNotExist: # raise Http404 if library_inst: library_inst.name = request.data["name"] library_inst.user_id = request.user.id library_inst.component_type_id = request.data["component_type_id"] library_inst.save() file1 = request.FILES["default_image"] file2 = request.FILES["status_on"] file3 = request.FILES["status_off"] if file1: path = 'static/media/'+str(library_inst.id) fs = FileSystemStorage(path) filename = fs.save(file1.name,file1) library_inst.default_image = path+'/'+filename if file2: path = 'static/media/'+str(library_inst.id) fs = FileSystemStorage(path) filename = fs.save(file2.name,file2) library_inst.status_on = path+'/'+filename if file3: path = 'static/media/'+str(library_inst.id) fs = FileSystemStorage(path) filename = fs.save(file3.name,file3) library_inst.status_off = path+'/'+filename library_inst.save() if notify_inst: notify_inst.status_on_email =request.data["status_on_email"] notify_inst.status_off_email =request.data["status_off_email"] notify_inst.status_on_sms =request.data["status_on_sms"] notify_inst.status_off_sms =request.data["status_off_sms"] notify_inst.Component_library_id =library_inst.id notify_inst.save() else: response=getResponse('failure','failed to do this operation') return response
def get(self, request): tag_list = TagDetails.objects.all().order_by('-id') # if 'page' in request.GET and 'count' in request.GET: if set(('page', 'count')) <= request.GET.keys(): page = request.GET.get("page") count = request.GET.get("count") paginator = Paginator(tag_list, count) tags = paginator.page(page) previous_page = "" next_page = "" if tags.has_previous(): previous_page = str(tags.previous_page_number()) if tags.has_next(): next_page = str(tags.next_page_number()) num_pages = paginator.num_pages serializers = TagSerializers(tags, many=True) if serializers: response = getResponse('success', 'successfully got the tag details', serializers.data, previous_page, next_page, num_pages) else: response = getResponse('failure', 'failed to do this operation') else: serializers = TagSerializers(tag_list, many=True) if serializers: response = getResponse('success', 'successfully got the tag details', serializers.data) else: response = getResponse('failure', 'failed to do this operation') return response
def get(self,request): Project_list=ProjectDetails.objects.all().order_by('-id') serializers=ProjectSerializers(Project_list,many=True) if serializers: response=getResponse('success','successfully got the Project details',serializers.data) else: response=getResponse('failure','failed to do this operation') return response
def get(self,request): Comp_tag_list=ProjectComponentsTags.objects.all().order_by('-id') serializers=ComponentsTagSerializers(Comp_tag_list,many=True) if serializers: response=getResponse('success','successfully got the Project Component',serializers.data) else: response=getResponse('failure','failed to do this operation') return response
def post(self,request): body_unicode=request.body.decode('utf-8') data=json.loads(body_unicode) try: proj_instance=ProjectDetails.objects.get(project_name=data["project_name"]) response=getResponse("success","successfully got the project_name") except ProjectDetails.DoesNotExist: response=getResponse("failure","failed to get the project_name") return response
def post(self, request): try: group_value = Group.objects.get(id=request.data['id']) serializers = RoleSerializers(group_value) response = getResponse('success', 'successfully got the details', serializers.data) except Group.DoesNotExist: response = getResponse('failure', 'failed to get the user') return response
def put(self,request): body_unicode=request.body.decode('utf-8') data=json.loads(body_unicode) get_Project=self.get_or_object(data['id']) serializers=ProjectSerializers(get_Project) if serializers: response=getResponse('success','successfully got the Project',serializers.data) else: response=getResponse('failure','failed to do this operation') return response
def get(self, request): data = request.data group_instance = Group.objects.all() serializers = RoleSerializers(group_instance, many=True) if group_instance: response = getResponse('success', 'successfully got it', serializers.data) else: response = getResponse('failure', 'failed to do this operation') return response
def get(self, request): tag_list = TagType.objects.all().order_by('-id') serializers = TagTypeSerializers(tag_list, many=True) if serializers: response = getResponse('success', 'successfully got the tag details', serializers.data) else: response = getResponse('failure', 'failed to do this operation') return response
def get(self, request): data = request.data permission_instance = Permission.objects.filter(content_type_id=str(7)) serializers = ModuleSerializers(permission_instance, many=True) if serializers: response = getResponse('success', 'successfully got the details', serializers.data) else: response = getResponse('failure', 'failed to do this operation') return response
def delete(self, request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) delete_permission = self.get_or_object(data['id']) if delete_permission: delete_permission.delete() response = getResponse('success', 'successfully deleted') else: response = getResponse('failure', 'failed to do this operation') return response
def get(self,request): final=[] Library_list=ComponentsLibrary.objects.all().order_by('-id') # for i in Library_list: # k=CompLibDigitalNotify.objects.get(Component_library=i.id) serializers=ComponentsLibrarySerializers(Library_list,many=True) if serializers: response=getResponse('success','successfully got the Project Component',serializers.data) else: response=getResponse('failure','failed to do this operation') return response
def post(self, request): data = request.data if 'id' in data: group_instance = self.get_or_object(data['id']) serializers = RoleSerializers(group_instance, data=data) else: serializers = RoleSerializers(data=data) if serializers.is_valid(): serializers.save() response = getResponse('success', 'successfully created') else: response = getResponse('failure', 'failed to do this operation') return response
def get(self,request): page=request.GET.get('page') count=request.GET.get('count') data={} final_array=[] try: # comp_tg_inst=ProjectComponentsTags.objects.raw("select a.id,a.project_id,a.component_id,d.name, a.tag_id,b.component_name,c.tag_type_id,e.project_name,b.created_at,b.updated_at from project_components_tags as a INNER JOIN project_component as b on a.component_id && a.is_active=1 = b.id && b.user_id="+str(request.user.id) +" INNER JOIN tags as c on a.tag_id=c.id INNER JOIN tagtype as d on c.tag_type_id=d.id INNER JOIN project as e on e.id=a.project_id") comp_tg_inst= ProjectComponentsTags.objects.raw("select a.id,a.tag_name,e.name,b.component_id,c.component_name,d.project_name from tags as a left join project_components_tags as b on a.id = b.tag_id && is_active=1 left join project_component as c on b.component_id = c.id left join project as d on d.id=b.project_id left join tagtype as e on e.id=a.tag_type_id") except ProjectComponentsTags.DoesNotExist: response=getResponse('failure','failed to do this operation',"data not found") # comp_tg_inst.columns //['id','component_name','tag_id' etc.,] paginator=Paginator(comp_tg_inst,count) use=paginator.page(page) for obj in use: # for obj in comp_tg_inst: data={} data['id']=obj.id if obj.component_name: data["component_name"]=obj.component_name else: data["component_name"]="-" data['tag_id'] =obj.id data['tag_name'] =obj.tag_name data['tag_type'] =obj.name if obj.project_name: data["project_name"] =obj.project_name else: data["project_name"] ="-" data["component_id"] =obj.component_id # data["created_at"]=obj.created_at # data["updated_at"]=obj.updated_at final_array.append(data) if use.has_previous(): previous_page =use.previous_page_number() else: previous_page ="" if use.has_next(): next_page =use.next_page_number() else: next_page ="" num_of_pages =paginator.num_pages if final_array: response=getResponse('success','successfully got component list',final_array,previous_page,next_page,num_of_pages) else: response=getResponse('failure','failed to do this operation') return response
def createUser(data): print(data) if 'id' not in data: user_details = User() else: try: user_details = User.objects.get(id=data['id']) assign_project = UserProject.objects.filter( user_id=user_details.id).delete() except User.DoesNotExist: response = getResponse('failure', 'detail not found') if user_details: if "first_name" in data: user_details.first_name = data['first_name'] else: user_details.first_name = "" if "last_name" in data: user_details.last_name = data['last_name'] if "email" in data: user_details.email = data['email'] else: user_details.email = "" if "username" in data: user_details.username = data['username'] else: user_details.username = "" if "password" in data: hash_password = make_password(data['password']) user_details.password = hash_password else: user_details.password = "" if "mobile_no" in data: user_details.mobile_no = data['mobile_no'] else: user_details.mobile_no = "" user_details.admin_id = data['admin_id'] user_details.save() for i in data['project_id']: assign_project = UserProject() assign_project.user_id = user_details.id assign_project.project_id = i assign_project.analog_tag = data['analog_tag'] assign_project.digital_tag = data['digital_tag'] assign_project.video_tag = data['video_tag'] assign_project.audio_tag = data['audio_tag'] assign_project.save() response = getResponse('success', 'successfully created') return response
def post(self, request): data = request.data if 'id' in request.data: permission_instance = Permission.objects.get(id=request.data['id']) serializers = ModuleSerializers(permission_instance, data=data) else: serializers = ModuleSerializers(data=data) if serializers.is_valid(): serializers.save() response = getResponse('success', 'successfully created', serializers.data) else: response = getResponse('failure', 'failed to do this operation') return response
def post(self, request): responseblock = {} if 'id' in request.data: try: user_exists = User.objects.get(id=request.data['id']) if user_exists.username == request.data['username']: response = getResponse("failure", "failed to get the user") else: response = self.checkuser(request.data["username"]) except: response = getResponse("failure", "user does not exist") else: response = self.checkuser(request.data["username"]) return response
def dropdownlist(request): try: final_array = [] userGroup = Group.objects.all() for group in userGroup: data = {} data['id'] = group.id data['name'] = group.name final_array.append(data) response = getResponse("success", "successfully got the user", final_array) except Group.DoesNotExist: response = getResponse("failure", "failed to get the group") return response
def post(self, request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) if 'id' in data: tag_instance = self.get_or_object(data['id']) serializers = TagTypeSerializers(tag_instance, data=data) else: serializers = TagTypeSerializers(data=data) if serializers.is_valid(): serializers.save() response = getResponse('success', 'successfully created', serializers.data) else: response = getResponse('failure', 'failed to do this operation', serializers.data) return response
def get(self, request): print("welcome to role") if request.user.id: response = checkCurrentRole(request.user.id) else: response = getResponse('failure', 'something went wrong') return response
def get(self, request): final_array = [] page = request.GET.get("page") count = request.GET.get("count") try: unassign_tag = unassign_tag = TagDetails.objects.exclude(pk__in=[ i.tag_id for i in ProjectComponentsTags.objects.filter(is_active=1) ]) paginator = Paginator(unassign_tag, count) try: page_obj = paginator.page(page) for obj in page_obj: data = {} try: tag_type_inst = TagType.objects.get(id=obj.tag_type_id) except TagType.DoesNotExist: raise Http404 data["tag_id"] = obj.id data["tag_name"] = obj.tag_name data["tag_type"] = tag_type_inst.name data["component_name"] = "-" data["project_name"] = "-" final_array.append(data) previous_page = "" next_page = "" if page_obj.has_previous(): previous_page = str(page_obj.previous_page_number()) if page_obj.has_next(): next_page = str(page_obj.next_page_number()) num_of_pages = paginator.num_pages # final_array.append(data) response = getResponse('success', 'successfully got the unassigned tag', final_array, previous_page, next_page, num_of_pages) except Exception as e: response = getResponse('failure', 'this page does not have results', e) except TagDetails.DoesNotExist: response = getResponse('failure', 'failed to do this operation') return response
def checkCurrentRole(obj): data = {} if obj: try: user_details = User.objects.get(id=obj) try: role = Roles.objects.get(id=user_details.role_id) data["role_id"] = role.id data['role_name'] = role.role_name response = getResponse('success', 'successfully done', data) except Roles.DoesNotExist: response = getResponse('failure', 'something went wrong') except User.DoesNotExist: response = getResponse('failure', 'something went wrong') else: response = getResponse('failure', 'something went wrong') return response
def post(self,request): body_unicode=request.body.decode('utf-8') data=json.loads(body_unicode) if 'id' in data: Comp_tag_instance=self.get_or_object(data['id']) serializers=ProjectSerializers(Comp_tag_instance,data=data) else: serializers=ProjectSerializers(data=data) if serializers.is_valid(raise_exception=True): serializers.save(user_id=request.user.id) if 'id' not in data: response=getResponse('success','successfully updated',serializers.data) else: response=getResponse('success','successfully created',serializers.data) else: response=getResponse('failure','failed to do this operation') return response
def post(self, request): body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) final_array = [] if request.method == "POST": per = Permission.objects.filter(group__id=data["id"]) print(per) if per: for key in per: data = {} data["id"] = key.id # data["code_name"]=key.codename final_array.append(data) response = getResponse("success", "successfully done", final_array) else: response = getResponse("failure", "failed to do this operation") return response
def sendResetPwdEmail(request): print('reset') digits = "".join([random.choice(string.digits) for i in range(8)]) chars = "".join([random.choice(string.ascii_letters) for i in range(15)]) token = digits + chars if request.method == "POST": body_unicode = request.body.decode('utf-8') data = json.loads(body_unicode) email = data['email'] print(email) try: user_check = User.objects.get(email=email) print(user_check) mail_subject = 'Reset password' current_site = get_current_site(request) pwd_rst = PasswordReset() pwd_rst.token = token pwd_rst.expires_at = datetime.datetime.now() + datetime.timedelta( hours=1) pwd_rst.user_id = user_check.id pwd_rst.save() print(token) message = render_to_string('password_reset_mail.html', { 'domain': current_site.domain, 'token': token }) send_html_mail(mail_subject, message, "*****@*****.**") response = getResponse('success', 'successfully sent email') except User.DoesNotExist: print('not found') response = getResponse('failure', 'email not found') # email_s=EmailMessage(mail_subject, message, to=["*****@*****.**"]) # email_s.send() else: response = getResponse('failure', 'something went wrong') return response