def get(self,request,*arg,**kwargs):
begintime = request.GET.get('begintime', None)
endtime = request.GET.get('endtime', None)
if begintime is None:
begintime = (datetime.now() + timedelta(days=-7)).strftime('%Y-%m-%d %H:%M:%S')
if endtime is None:
endtime = (datetime.now() + timedelta(days=0)).strftime('%Y-%m-%d %H:%M:%S')
users = []
weekUsers = []
orderDealTime = []
effObject = []
weekDealTime = []
orders = WorkOrderManager.count(delete=False)
openOrders = WorkOrderManager.count(status=0)
ordObjects = WorkOrderManager.list(request).exclude(status=0)\
.filter(addedtime__gte=begintime,addedtime__lte=endtime)
effObjects = WorkOrderEffManager.list()
weekOrderObjects = WorkOrderManager.list('',addedtime__gte=begintime,addedtime__lte=endtime)\
.exclude(status=0).exclude(status=3).values('confirmuser').annotate(count=Count('confirmuser'))
for obj in weekOrderObjects:
if obj['confirmuser']:
try:
weekUsers.append({
'username':UserManager.get(id=obj['confirmuser']).username,
'count':obj['count'],
}
)
except Exception:
pass
weekOrderObjects = WorkOrderManager.list('',addedtime__gte=begintime,addedtime__lte=endtime)\
.exclude(status=0).exclude(status=3).values('confirmuser').annotate(sum=Sum('dealtime'))
for obj in weekOrderObjects:
if obj['confirmuser']:
try:
weekDealTime.append({
'username':UserManager.get(id=obj['confirmuser']).username,
'sum':obj['sum'],
})
except Exception:
pass
if effObjects:
for obj in effObjects:
effObject.append({'time':obj.addedtime.strftime('%Y-%m-%d %H:%M:%S'),'value':obj.value})
if ordObjects:
for obj in ordObjects:
orderDealTime.append({'time':obj.dealtime,'id':obj.id})
userObj = WorkOrderManager.group('confirmuser')
for obj in userObj:
if obj['confirmuser']:
try:
users.append({
'username':UserManager.get(id=obj['confirmuser']).username,
'count':obj['count'],
})
except Exception:
pass
objects = {
'effObject':effObject,
'users':users,
'weekUsers':weekUsers,
'orders':orders,
'openorders':openOrders,
'orderDealTime':orderDealTime,
'weekDealTime':weekDealTime,
}
return HttpResponse(json.dumps(objects),
content_type='application/json')
def allowed(self, request, datum):
if WorkOrderManager.list(request, ordertemp=datum.id):
return False
else:
return True
def get(self,request,*arg,**kwargs):
data = json.loads(request.body)
tempTypeId = data.get('id',None)
objects = WorkOrderManager.list(ordertemp=tempTypeId)
return HttpResponse(json.dumps(objects),
content_type='application/json')