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