def Transaction_list_view_search(request): if request.is_ajax(): cus_filter = {} if request.GET['operationon'] != 'false': obj_list = transactions.objects.exclude(content_type=None) # add account filter if request.GET['account'] != '': accountobj = accounts.objects.get(pk=request.GET['account']) obj_list = transactions.objects.filter(Q(accountA=accountobj) | Q(accountB=accountobj)) if request.GET['datestart'] != '': datestart = datetime.datetime.strptime(request.GET['datestart'],"%m/%d/%Y") else: datestart = datetime.datetime.strptime('01/01/1990',"%m/%d/%Y") if request.GET['dateend'] != '': dateend = datetime.datetime.strptime(request.GET['dateend'],"%m/%d/%Y") else: dateend = datetime.datetime.strptime('01/01/9999',"%m/%d/%Y") cus_filter['lastmodified__range'] = [datestart,dateend] obj_list = obj_list.filter(**cus_filter) #onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() outputdict = generate_transaction(obj_list,accountobj) availdata = json_ser.serialize(outputdict) #obj_list) avail_json_data = JSONEncoder().encode(availdata) return HttpResponse(avail_json_data, mimetype='application/json') else: cus_filter = {} obj_list = transactions.objects.all() # add account filter # add startdate filter datestart = datetime.datetime.strptime('03/01/2012',"%m/%d/%Y") dateend = datetime.datetime.strptime('06/01/2012',"%m/%d/%Y") cus_filter['lastmodified__range'] = [datestart,dateend] obj_list = obj_list.filter(**cus_filter) #onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() availdata = json_ser.serialize(obj_list) avail_json_data = JSONEncoder().encode(availdata) return HttpResponse(avail_json_data, mimetype='application/json')
def Asset_list_view_search(request): """ search engine view """ if request.is_ajax(): cus_filter = {} obj_list = asset.objects.all() # add storage filter if request.GET['storage'] != '': location = storage.objects.get(pk=request.GET['storage']) cus_filter['assetstorage__location'] = location cus_filter['assetstorage__moveout'] = None # add onsale filter if request.GET['onsale'] == '2': cus_filter['onsale'] = True elif request.GET['onsale'] == '3': cus_filter['onsale'] = False # add sold filter if request.GET['sold'] == '2': cus_filter['sold'] = True elif request.GET['sold'] == '3': cus_filter['sold'] = False # add purchase filter, get asset group nad if request.GET['purchase'] != '': purobj = PurchaseRequest.objects.get(pk=request.GET['purchase']) groupname = 'Purchase Request %i:' % purobj.id assetgroupobj = assetgroup.objects.get(name__startswith=groupname) obj_list = obj_list & assetgroupobj.assets.all() if request.GET['sell_platform'] != '': #sellslotobjs = Sellingplatformslot.objects.filter(platform__id=request.GET['sell_platform']) #sellrequobjs = SellRequest.objects.filter(sellingplatformslot__platform__id=request.GET['sell_platform']) obj_list = obj_list & asset.objects.filter(sellrequest__sellingplatformslot__platform__id=request.GET['sell_platform']) obj_list = obj_list.filter(**cus_filter) #onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() availdata = json_ser.serialize(obj_list) avail_json_data = JSONEncoder().encode(availdata) return HttpResponse(avail_json_data, mimetype='application/json') else: obj_list = asset.objects.filter(onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() availdata = json_ser.serialize(obj_list) avail_json_data = JSONEncoder().encode(availdata) return HttpResponse(avail_json_data, mimetype='application/json')
def Account_list_view_search(request): if request.is_ajax(): cus_filter = {} obj_list = AccountMonthlySummary.objects.all() # add account filter if request.GET['account'] != '': accountobj = accounts.objects.get(pk=request.GET['account']) cus_filter['account'] = accountobj # add startdate filter if request.GET['year'] != '': cus_filter['year'] = request.GET['year'] if request.GET['month'] != '': if request.GET['month'] != 'Year Upto Date': cus_filter['month'] = request.GET['month'] obj_list = obj_list.filter(**cus_filter) #onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() outputdict = {} outputdict['account'] = obj_list[0].account.__unicode__() outputdict['year'] = obj_list[0].year outputdict['month'] = obj_list[0].month outputdict['total_debit'] = obj_list[0].total_debit outputdict['total_credit'] = obj_list[0].total_credit outputdict['total_transactions'] = obj_list[0].number_of_transaction() outputdict['total_all'] = obj_list[0].total_credit-obj_list[0].total_debit outputdict['transactions'] = generate_transaction(obj_list[0].transaction.all(),obj_list[0].account) availdata = json_ser.serialize(outputdict) #obj_list) avail_json_data = JSONEncoder().encode(availdata) return HttpResponse(avail_json_data, mimetype='application/json') else: cus_filter = {} obj_list = AccountMonthlySummary.objects.all() # add account filter accountobj = accounts.objects.get(pk=2) cus_filter['account'] = accountobj # add startdate filter cus_filter['year'] = '2012' cus_filter['month'] = '5' obj_list = obj_list.filter(**cus_filter) #onsale=True,item__itemproduct__shortname=u'Xbox 360 Wireless') json_ser = Serializer() outputdict = {} outputdict['account'] = obj_list[0].account.__unicode__() outputdict['year'] = obj_list[0].year outputdict['month'] = obj_list[0].month outputdict['total_debit'] = obj_list[0].total_debit outputdict['total_credit'] = obj_list[0].total_credit outputdict['total_transactions'] = obj_list[0].number_of_transaction() outputdict['total_all'] = obj_list[0].total_credit-obj_list[0].total_debit outputdict['transactions'] = generate_transaction(obj_list[0].transaction.all(),obj_list[0].account) availdata = json_ser.serialize(outputdict) #obj_list) avail_json_data = JSONEncoder().encode(outputdict) return HttpResponse(avail_json_data, mimetype='application/json')