Example #1
0
def get_compras_table(request):
    objects = Compra.objects.all()
    list_display = ['fecha', 'tipo', 'identificador', 'proveedor.razon_social', 'neto', 'iva', 'total', 'estado']
    list_global_search = ['proveedor__razon_social', 'numero']
    data_struct = dict(enumerate(map(lambda x: x.replace(".", "__"), list_display)))

    recordsTotal = objects.count()

    objects = filtering(request.GET, objects, data_struct, list_global_search)

    objects = ordering(request.GET, objects, data_struct)

    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start: (start + length)]


    # extract information
    data = make_data(objects, list_display)

    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    return JsonResponse(response)
Example #2
0
def get_compras_table(request):
    objects = Compra.objects.all()
    list_display = [
        'fecha', 'tipo', 'identificador', 'proveedor.razon_social', 'neto',
        'iva', 'total', 'estado'
    ]
    list_global_search = ['proveedor__razon_social', 'numero']
    data_struct = dict(
        enumerate(map(lambda x: x.replace(".", "__"), list_display)))

    recordsTotal = objects.count()

    objects = filtering(request.GET, objects, data_struct, list_global_search)

    objects = ordering(request.GET, objects, data_struct)

    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    # extract information
    data = make_data(objects, list_display)

    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    return JsonResponse(response)
Example #3
0
def get_articulos_table(request):
    objects = Articulo.objects.all()
    desde = request.GET['desde']
    es_b = True if 'es_b' in request.GET else False
    if desde == 'seleccionArticulo':
        list_display = [
            'pk', 'codigo', 'codigo_fabrica', 'denominacion', 'rubro.nombre',
            'precio_venta'
        ]
        # list_filter = ['codigo', 'codigo_fabrica','denominacion']
    elif desde == 'mainArticulos':
        list_display = [
            'codigo', 'codigo_fabrica', 'denominacion', 'linea.nombre',
            'subrubro.nombre', 'ultima_actualizacion_precio'
        ]
        list_global_search = ['denominacion', 'codigo', 'codigo_fabrica']
        data_struct = dict(enumerate(list_display))

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado de los articulos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    # extract information
    data = make_data(objects, list_display, "editarArticulo",
                     "suspenderArticulo", "habilitarArticulo")

    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())
Example #4
0
def get_clientes_table(request):
    objects = Cliente.objects.all()
    list_display = [
        'cuit', 'razon_social', 'localidad', 'get_provincia_display()',
        'telefono'
    ]
    list_global_search = list_display[1:2]
    data_struct = dict(enumerate(list_display))

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado general de los articulos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    # extract information
    detalle = u'''<u>SALDO</u>: <strong>%(saldo)s</strong><br>
                   <u>Información fiscal</u>:  Condición IVA: %(get_cond_iva_display())s - IIBB: %(codigo_ingresos_brutos)s<br>
                   <u>Dirección</u>: %(direccion)s, %(localidad)s (%(get_provincia_display())s) -- CP: %(codigo_postal)s<br>
                   <u>Contacto</u>:  TE: %(telefono)s  FAX: %(fax)s<br>
                   </u>Información extra</u>:<br>
                   %(notas)s'''
    data = make_data(objects, list_display, 'editarCliente',
                     'suspenderCliente', 'habilitarCliente', detalle)

    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())
Example #5
0
def get_proveedores_table(request):
    # SETEOS INICIALES
    objects = Proveedor.objects.all()
    list_display = ['razon_social', 'localidad', 'telefono', 'email']
    list_global_search = ['razon_social']
    data_struct = dict(enumerate(list_display))

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado de los bancos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    # extract information
    data = make_data(objects, list_display, "editarProveedor",
                     "suspenderProveedor", "habilitarProveedor")
    print data
    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())
Example #6
0
def get_proveedores_table(request):
    # SETEOS INICIALES
    objects = Proveedor.objects.all()
    list_display = ['razon_social', 'localidad', 'telefono', 'email']
    list_global_search = ['razon_social']
    data_struct = dict(enumerate(list_display))

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado de los bancos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start: (start + length)]

    # extract information
    data = make_data(objects, list_display, "editarProveedor", "suspenderProveedor", "habilitarProveedor")
    print data
    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())
Example #7
0
def get_condiciones_venta_table(request):
    objects = Condicion_venta.objects.all()
    list_display = ['descripcion']
    list_global_search = list_display
    data_struct = dict(enumerate(list_display))

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado de los articulos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    data = make_data(objects, list_display, 'editarCondicionVenta')
    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())
Example #8
0
def get_subrubros_table(request):
    objects = SubRubro.objects.all()
    list_display = ['rubro.nombre', 'nombre', 'get_iva_display()']
    list_global_search = ['rubro__nombre', 'nombre']
    data_struct = {0: 'rubro__nombre', 1: 'nombre', 2: 'iva'}

    # Cuenta total de articulos:
    recordsTotal = objects.count()

    # Filtrado de los articulos
    objects = filtering(request.GET, objects, data_struct, list_global_search)

    # Ordenado
    objects = ordering(request.GET, objects, data_struct)

    # Conteo de articulos despues dle filtrado
    recordsFiltered = objects.count()

    # finally, slice according to length sent by dataTables:
    start = int(request.GET['start'])
    length = int(request.GET['length'])
    objects = objects[start:(start + length)]

    data = make_data(objects, list_display, 'editarSubrubro')
    # define response
    response = {
        'data': data,
        'recordsTotal': recordsTotal,
        'recordsFiltered': recordsFiltered,
        'draw': request.GET['draw']
    }

    # serialize to json
    s = StringIO()
    json.dump(response, s)
    s.seek(0)
    return HttpResponse(s.read())