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
