def getDispatches(self,request): params = request.query_params if 'toDate' in params and 'fromDate' in params: dis = Dispatch.objects.filter(date__range=[getServerDateFromStr(params['fromDate']),getServerDateFromStr(params['toDate'])]) return dis if 'fromDate' in params: dis = Dispatch.objects.filter(date__gte=getServerDateFromStr(params['fromDate'])) return dis dis = Dispatch.objects.all() return dis
def addDispatch(self,request): params = request.data; ds = Dispatch() ds.date = getServerDateFromStr(params['date']) ds.vanNo = params['vanNo'] ds.name = params['name'] ds.remarks = params.get('remarks','') ds.save() for fnId in params['forwardingNotes']: fn = ForwardingNote.objects.get(pk=fnId) fn.isDispatched = True fn.save() ds.forwardingNote.add(fn) return ds
def addForwardingNote(self,request): params = request.data; fn = ForwardingNote() if 'billDates' in params: fn.billDates = ",".join(params['billDates']) fn.fnDate = getServerDateFromStr(params['fnDate']) fn.billNo = params.get('billNo','') fn.billValues = params['billValues'] fn.cases = params['cases'] fn.transporter_id = params['transporter_id'] fn.transporterStation = params['transporterStation'] # if 'transporter_id' in params: # pass # else: # transporter = Transporter() # transporter.name = params['transporter']['name'] # transporter.city = params['transporterStation'] # transporter.org_id = 1 # transporter.save() # fn.transporter_id = transporter.id if 'customer_id' in params: fn.customer_id = params['customer_id'] else: try: customer = Customer.objects.get(name__iexact=params['customer']['name'],city__iexact=params['customer']['city']) except Customer.DoesNotExist: customer = Customer() customer.name = params['customer']['name'] customer.city = params['customer']['city'] customer.org_id =1 customer.save() fn.customer_id = customer.id fn.marka = params['marka'] if 'companyId' in params: fn.company_id = params['companyId'] fn.transporterStation = params['transporterStation'] fn.permitNo = params.get('permitNo','') fn.commodity = params.get('commodity','') fn.save() return fn
def updateDispatch(self,request): params = request.data; ds = Dispatch.objects.get(pk=params['id']) if ds.isLocked: raise PermissionDenied() ds.date = getServerDateFromStr(params['date']) ds.vanNo = params['vanNo'] ds.name = params['name'] ds.remarks = params.get('remarks','') fns = ds.forwardingNote.all() for ofn in fns: ofn.isDispatched = False ofn.save() ds.forwardingNote.remove(ofn) for fnId in params['forwardingNotes']: oFn = ds.forwardingNote.filter() fn = ForwardingNote.objects.get(pk=fnId) fn.isDispatched = True fn.save() ds.forwardingNote.add(fn) # timeout(self.lockDispatch,ds,{},10) return ds
def getForwardingNotes(self,request): params = request.query_params transporterName = '' if 'transporterName' in params: transporterName = params['transporterName'] if 'toDate' in params and 'fromDate' in params: fns = ForwardingNote.objects.filter(isDispatched=False,transporter__name__icontains=transporterName,fnDate__range=[getServerDateFromStr(params['fromDate']),getServerDateFromStr(params['toDate'])]).order_by('-id') return fns if 'fromDate' in params: fns = ForwardingNote.objects.filter(isDispatched=False,transporter__name__icontains=transporterName,fnDate__gte=getServerDateFromStr(params['fromDate'])).order_by('-id') return fns fns = ForwardingNote.objects.filter(isDispatched=False,transporter__name__icontains=transporterName).order_by('-id') return fns