def getASD(request, bpcode, unitid, salesoff, salesgrp): data = None status = "Failed" msg = "" UM = None try: if unitid: UM = UnitMaster.objects.get(pk=unitid) SM = ASDMaster.objects.filter(status=1, unit_id=UM, sales_office=salesoff, sales_group=salesgrp, from_date__lte=datetime.now(), to_date__gte=datetime.now()) if SM: data = srz.serialize('python', SM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get ASD') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get ASD') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getCity(request, bpcode, state_id=None, state_code=None): data = None status = "Failed" msg = "" try: SM = None if state_id: SM = StateMaster.objects.get(pk=state_id) if state_code: SM = StateMaster.objects.get(state_code=state_code) if SM: CM = CityMaster.objects.filter(status=1, state_id=SM) else: CM = CityMaster.objects.filter(status=1) if CM: data = srz.serialize('python', CM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get City List') except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get City List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getMaritialStatus(request, bpcode): data = None status = "Failed" msg = "" try: MSM = MaritialStatusMaster.objects.filter(status=1) if MSM: data = srz.serialize('python', MSM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Maritial Status Master List') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Maritial Status Master List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getSalesOff(request, bpcode, unit_id=None, unit_code=None): data = None status = "Failed" msg = "" UM = None try: SM = None if unit_id: UM = UnitMaster.objects.get(pk=unit_id) if unit_code: UM = UnitMaster.objects.get(unit_code=unit_code) if UM: CM = SalesOffMaster.objects.filter(status=1, unit_id=UM) if CM: data = srz.serialize('python', CM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: #status = "Success" msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Sales Off List') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Sales Off List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getlast7daysavg(request, bpcode, agcode): data = None status = "Failed" msg = "" UM = None avg_copy = 0 try: # if unitid: # UM = ZVT_PORTAL_CIR.objects.get(pk=unitid) SM_sum = ZVT_PORTAL_CIR.objects.filter(sold_to_party=agcode, ord_date_f__gte=datetime.now() + timedelta(days=-7)).aggregate( Sum('gross_copy')) SM_first = ZVT_PORTAL_CIR.objects.filter( sold_to_party=agcode, ord_date_f__gte=datetime.now() + timedelta(days=-7)).values('cust_name').distinct() SM_name = SM_first[0]['cust_name'] #print(SM_first) if SM_sum['gross_copy__sum'] > 0: avg_copy = SM_sum['gross_copy__sum'] // 7 if SM_name: data = { 'AGCODE': agcode, 'AGNAME': SM_name, 'AVGCOPY7Days': avg_copy } #data = SM #srz.serialize('python', SM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get last7daysavg') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get last7daysavg') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getRoute(request, bpcode, plant_id=None, plant_code=None, unit_id=None, unit_code=None): data, status, msg = None, "Failed", "" try: PM = None UM = None if plant_id: PM = PlantMaster.objects.get(pk=plant_id) if plant_code: PM = PlantMaster.objects.get(plant_code=plant_code) if unit_id: UM = UnitMaster.objects.get(pk=unit_id) if unit_code: UM = UnitMaster.objects.get(unit_code=unit_code) if PM: RM = RouteMaster.objects.filter(status=1, state_id=PM) elif UM: RM = RouteMaster.objects.filter(status=1, unit_id=UM) else: RM = RouteMaster.objects.filter(status=1) if RM: data = srz.serialize('python', RM) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Route List') except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Route List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getTown(request, bpcode, city_id=None, city_code=None, unit_id=None, unit_code=None): data, status, msg = None, "Failed", "" try: CM = None UM = None if city_id: CM = CityMaster.objects.get(pk=city_id) if city_code: CM = CityMaster.objects.get(city_code=city_code) if unit_id: UM = UnitMaster.objects.get(pk=unit_id) if unit_code: UM = UnitMaster.objects.get(unit_code=unit_code) if CM: TM = TownMaster.objects.filter(status=1, city_id=CM) elif UM: TM = TownMaster.objects.filter(status=1, unit_id=UM) else: TM = TownMaster.objects.filter(status=1) if TM: data = srz.serialize('python', TM) status = "Success" else: msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Town List') except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Town List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getPricegrp(request, bpcode, copies, unit_id=None, unit_code=None): data = None status = "Failed" msg = "" UM = None try: SM = None if unit_id: UM = UnitMaster.objects.get(pk=unit_id) if unit_code: UM = UnitMaster.objects.get(unit_code=unit_code) if UM: CM = PriceGroupMaster.objects.filter(status=1, unit_id=UM, min_copy_limit__lte=copies, max_copy_limit__gte=copies, from_date__lte=datetime.now(), to_date__gte=datetime.now()) if CM: data = srz.serialize('python', CM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: #status = "Success" msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Price grp List') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Price grp List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getEdition(request, bpcode, publication_id=None, publication_code=None): data = None status = "Failed" msg = "" try: EM = None PM = None if publication_id: PM = PublicationMaster.objects.get(pk=publication_id) if publication_code: PM = PublicationMaster.objects.get( publication_code=publication_code) if PM: EM = EditionMaster.objects.filter(status=1, publication_id=PM) else: EM = EditionMaster.objects.filter(status=1) if EM: data = srz.serialize('python', EM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: #status = "Success" msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Edition List') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Edition List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response
def getDroppingPoint(request, bpcode, route_id=None, route_code=None): data = None status = "Failed" msg = "" try: RM = None if route_id: RM = RouteMaster.objects.get(pk=route_id) if route_code: RM = RouteMaster.objects.get(route_code=route_code) if RM: DPM = DroppingPointMaster.objects.filter(status=1, route_id=RM) else: DPM = DroppingPointMaster.objects.filter(status=1) if DPM: data = srz.serialize('python', DPM, use_natural_foreign_keys=True, use_natural_primary_keys=True) status = "Success" else: #status = "Success" msg = "No Data Found" ul = user_log(request, bpcode, 'Agency Request', 'Get Dropping Point List') # response['Cache-Control'] = f'max-age={60*60*24}' except Exception as e: ul = user_log(request, bpcode, 'Agency Request', 'Error on : Get Dropping Point List') msg = str(e) response = JsonResponse({'data': data, 'status': status, 'msg': msg}) return response