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')