def voiceapp_grid(request): """Voce App list in json format for flexigrid **Model**: VoiceApp **Fields**: [id, name, user, description, type, gateway__name, updated_date] """ grid_data = grid_common_function(request) page = int(grid_data['page']) start_page = int(grid_data['start_page']) end_page = int(grid_data['end_page']) sortorder_sign = grid_data['sortorder_sign'] sortname = grid_data['sortname'] voiceapp_list = VoiceApp.objects\ .values('id', 'name', 'user', 'description', 'type', 'data', 'tts_language', 'gateway__name', 'updated_date').filter(user=request.user) count = voiceapp_list.count() voiceapp_list = \ voiceapp_list.order_by(sortorder_sign + sortname)[start_page:end_page] rows = [{'id': row['id'], 'cell': ['<input type="checkbox" name="select" class="checkbox"\ value="' + str(row['id']) + '" />', row['name'], row['description'], get_voiceapp_type_name(row['type']), row['gateway__name'], row['data'], row['tts_language'], row['updated_date'].strftime('%Y-%m-%d %H:%M:%S'), '<a href="' + str(row['id']) + '/" class="icon" ' \ + update_style + ' title="' + _('Update Voice App') +\ '"> </a>' +\ '<a href="del/' + str(row['id']) + '/" class="icon" ' \ + delete_style + ' onClick="return get_alert_msg(' +\ str(row['id']) +\ ');" title="' + _('Delete Voice App') + '"> </a>' ]} for row in voiceapp_list] data = {'rows': rows, 'page': page, 'total': count} return HttpResponse(simplejson.dumps(data), mimetype='application/json', content_type="application/json")
def voiceapp_grid(request): """Voce App list in json format for flexigrid **Model**: VoiceApp **Fields**: [id, name, user, description, type, gateway__name, updated_date] """ page = variable_value(request, 'page') rp = variable_value(request, 'rp') sortname = variable_value(request, 'sortname') sortorder = variable_value(request, 'sortorder') query = variable_value(request, 'query') qtype = variable_value(request, 'qtype') # page index if int(page) > 1: start_page = (int(page) - 1) * int(rp) end_page = start_page + int(rp) else: start_page = int(0) end_page = int(rp) sortorder_sign = '' if sortorder == 'desc': sortorder_sign = '-' voiceapp_list = VoiceApp.objects\ .values('id', 'name', 'user', 'description', 'type', 'data', 'gateway__name', 'updated_date').filter(user=request.user) count = voiceapp_list.count() voiceapp_list = \ voiceapp_list.order_by(sortorder_sign + sortname)[start_page:end_page] update_style = 'style="text-decoration:none;background-image:url(' + \ settings.STATIC_URL + 'newfies/icons/page_edit.png);"' delete_style = 'style="text-decoration:none;background-image:url(' + \ settings.STATIC_URL + 'newfies/icons/delete.png);"' rows = [{'id': row['id'], 'cell': ['<input type="checkbox" name="select" class="checkbox"\ value="' + str(row['id']) + '" />', row['name'], row['description'], get_voiceapp_type_name(row['type']), row['gateway__name'], row['data'], row['updated_date'].strftime('%Y-%m-%d %H:%M:%S'), '<a href="' + str(row['id']) + '/" class="icon" ' \ + update_style + ' title="' + _('Update Voice App') + '"> </a>' +\ '<a href="del/' + str(row['id']) + '/" class="icon" ' \ + delete_style + ' onClick="return get_alert_msg(' +\ str(row['id']) +\ ');" title="' + _('Delete Voice App') + '"> </a>' ]} for row in voiceapp_list] data = {'rows': rows, 'page': page, 'total': count} return HttpResponse(simplejson.dumps(data), mimetype='application/json', content_type="application/json")