def get_data_rows(self,ar):
qs = contacts.Partner.objects.all()
if ar.quick_search is not None:
qs = dbtables.add_quick_search_filter(qs,ar.quick_search)
if ar.gridfilters is not None:
qs = dbtables.add_gridfilters(qs,ar.gridfilters)
rows = []
for p in qs:
row = self.get_row_for(p)
if row.amount >= min_amount and row.first_date is not None:
rows.append(row)
def f(a,b): return cmp(a.first_date,b.first_date)
rows.sort(f)
return rows
def choices_response(request,qs,row2dict,emptyValue):
quick_search = request.GET.get(ext_requests.URL_PARAM_FILTER,None)
if quick_search is not None:
qs = dbtables.add_quick_search_filter(qs,quick_search)
count = len(qs)
offset = request.GET.get(ext_requests.URL_PARAM_START,None)
if offset:
qs = qs[int(offset):]
#~ kw.update(offset=int(offset))
limit = request.GET.get(ext_requests.URL_PARAM_LIMIT,None)
if limit:
#~ kw.update(limit=int(limit))
qs = qs[:int(limit)]
rows = [ row2dict(row,{}) for row in qs ]
if emptyValue is not None: # 20121203
empty = dict()
empty[ext_requests.CHOICES_TEXT_FIELD] = emptyValue
empty[ext_requests.CHOICES_VALUE_FIELD] = None
rows.insert(0,empty)
return json_response_kw(count=count,rows=rows)
def choices_response(request, qs, row2dict, emptyValue):
quick_search = request.GET.get(constants.URL_PARAM_FILTER, None)
if quick_search is not None:
qs = dbtables.add_quick_search_filter(qs, quick_search)
count = len(qs)
offset = request.GET.get(constants.URL_PARAM_START, None)
if offset:
qs = qs[int(offset):]
#~ kw.update(offset=int(offset))
limit = request.GET.get(constants.URL_PARAM_LIMIT, None)
if limit:
#~ kw.update(limit=int(limit))
qs = qs[:int(limit)]
rows = [row2dict(row, {}) for row in qs]
if emptyValue is not None: # 20121203
empty = dict()
empty[constants.CHOICES_TEXT_FIELD] = emptyValue
empty[constants.CHOICES_VALUE_FIELD] = None
rows.insert(0, empty)
return json_response_kw(count=count, rows=rows)
