示例#1
0
def formrowedit(request, formid, rowid):
    """Generate a form to edit rowid in formid"""
    rowid = int(rowid) + HEADERS_ROW
    # get the form object
    try:
        form = Form.objects.get(formid=formid)
    except Form.DoesNotExist:
        raise Http404
    # get the seafform object (Seafile connexion)
    if settings.LOCAL:
        seaf = None
    else:
        seafu = form.owner.seafileuser
        seaf = Seafile(seafu.seafroot)
        seaf.authenticate(form.owner.email, token=seafu.seaftoken, validate=False)
    seafform = SeafForm(form.filepath, seaf, form.repoid)
    seafform.load()
    # create the django form for a specific row
    initials = seafform.get_values_from_data(rowid)
    initials['rowid'] = rowid
    djform = DjForm(
        initials,
        fieldlist=seafform.fields
    )
    return render(request, 'seafform/rowedit.html', {
        'seafform': seafform,
        'djform': djform,
        'modelform': form,
        'rowid': rowid - HEADERS_ROW,
    })
示例#2
0
def formrowedit(request, formid, rowid):
    """Generate a form to edit rowid in formid"""
    rowid = int(rowid) + HEADERS_ROW
    # get the form object
    try:
        form = Form.objects.get(formid=formid)
    except Form.DoesNotExist:
        raise Http404
    # get the seafform object (Seafile connexion)
    if settings.LOCAL:
        seaf = None
    else:
        seafu = form.owner.seafileuser
        seaf = Seafile(seafu.seafroot, verifycerts=settings.VERIFYCERTS)
        seaf.authenticate(form.owner.email, token=seafu.seaftoken, validate=False)
    seafform = SeafForm(form.filepath, seaf, form.repoid)
    seafform.load()
    # create the django form for a specific row
    initials = seafform.get_values_from_data(rowid)
    initials['rowid'] = rowid
    djform = DjForm(
        initials,
        fieldlist=seafform.fields
    )
    return render(request, 'seafform/rowedit.html', {
        'seafform': seafform,
        'djform': djform,
        'modelform': form,
        'rowid': rowid - HEADERS_ROW,
    })
示例#3
0
def new(request):
    """Create a new form"""
    # if this is a POST request we need to process the form data
    if request.method == 'POST':
        path = unquote(request.POST.get('path', ''))
        print('new/path=' + path)
        if path.endswith('.ods'):
            if settings.LOCAL:
                filepath = os.path.join(settings.LOCAL_ROOT, path.lstrip('/'))
                seaf = None
                repoid = 'LOCAL'
                reponame = 'LOCAL'
            else:
                # Connect to Seafile
                seafu = request.user.seafileuser
                seaf = Seafile(seafu.seafroot, verifycerts=settings.VERIFYCERTS)
                seaf.authenticate(request.user.email, token=seafu.seaftoken, validate=False)
                # retreive path info
                parsed_path = parse(path)
                filepath = parsed_path['path']
                repoid = repo_id_from_name(seaf, parsed_path['repo_name'])
                reponame = parsed_path['repo_name']
            # load the form
            seafform = SeafForm(filepath, seaf, repoid)
            seafform.load()
            # create the slug/formid
            max_length = Form._meta.get_field('formid').max_length
            formid = orig = slugify(seafform.title)[:max_length]
            
            for x in itertools.count(1):
                if not Form.objects.filter(formid=formid).exists():
                    break
            # Truncate the original slug dynamically. Minus 1 for the hyphen.
            formid = "%s-%d" % (orig[:max_length - len(str(x)) - 1], x)
            
            # add the new form
            newform = Form(
                owner = request.user,
                filepath = filepath,
                repoid = repoid,
                reponame = reponame,
                formid = formid,
                title = seafform.title,
                creation_datetime = timezone.now(),
                description = seafform.description,
                public = seafform.public,
            )
            newform.save()
            # Redirect + message
            return HttpResponseRedirect(reverse('private') + '?newform=' + formid)
    
    return render(request, 'seafform/new.html', {
        'user': request.user,
        'allow_public': settings.ALLOW_PUBLIC,
    })
示例#4
0
def formview(request, formid):
    """Display a public form"""
    justaddedrow = None
    # get the form object
    try:
        form = Form.objects.get(formid=formid)
    except Form.DoesNotExist:
        raise Http404
    # get the seafform object (Seafile connexion)
    if settings.LOCAL:
        seaf = None
    else:
        seafu = form.owner.seafileuser
        seaf = Seafile(seafu.seafroot)
        seaf.authenticate(form.owner.email, token=seafu.seaftoken, validate=False)
    seafform = SeafForm(form.filepath, seaf, form.repoid)
    try:
        seafform.load()
    except APIError:
        raise Http404
    
    # build the corresponding DjForm()
    if request.method == 'POST':
        results = False
        # results management
        djform = DjForm(request.POST, fieldlist=seafform.fields)
        if djform.is_valid():
            # check if we replace a row
            if seafform.edit and djform.cleaned_data['rowid'] != 'newrow':
                replace_row = int(djform.cleaned_data['rowid'])
                justaddedrow = replace_row - HEADERS_ROW
            else:
                replace_row = None
                justaddedrow = seafform._first_empty_row - HEADERS_ROW
            # save data
            seafform.post(djform.cleaned_data, replace_row)
            
            # if valid form and form and not edit:
            if seafform.view_as == 'form' and not seafform.edit:
                # redirect to thanks
                return HttpResponseRedirect(reverse('thanks',args=(formid,)))
            elif seafform.view_as == 'form':
                return HttpResponseRedirect(
                    reverse('form',args=(formid,)) + '?results'
                )
                #results = True # redirect to table
                
            # clean fields
            djform = DjForm(fieldlist=seafform.fields)
    else:
        djform = DjForm(fieldlist=seafform.fields)
        results = ('results' in request.GET)
        
    if seafform.view_as == 'form' and not results:
        # form view
        return render(request, 'seafform/form_as_form.html', {
            'seafform': seafform,
            'modelform': form,
            'djform': djform,
        })
        
    elif seafform.view_as == 'table' or (results and seafform.edit):
        # hightlight first column if static field
        first_is_static = (seafform.fields[0].ident == 'static')
        # compute some results
        max_chk = 0
        computations = []
        for colid, field in enumerate(seafform.fields):
            # if check boxe, number of checks
            if field.ident.startswith('check'):
                res = sum(row[colid] for row in seafform.data if row[colid])
                max_chk = max(max_chk, res)
                computations.append(res)
            # if number, the sum
            elif field.ident == 'number':
                computations.append(sum(
                    row[colid] for row in seafform.data if row[colid]
                ))
            else:
                computations.append(None)
        # columns with a star
        max_chk_column = []
        for colid, field in enumerate(seafform.fields):
            if field.ident.startswith('check') and computations[colid] == max_chk:
                max_chk_column.append(colid)
        
        # table view    
        return render(request, 'seafform/form_as_table.html', {
            'seafform': seafform,
            'modelform': form,
            'djform': djform,
            'justaddedrow': justaddedrow,
            'first_is_static': first_is_static,
            'computations': computations,
            'max_chk_column': max_chk_column,
        })

    raise Http404
示例#5
0
def formview(request, formid):
    """Display a public form"""
    justaddedrow = None
    # get the form object
    try:
        form = Form.objects.get(formid=formid)
    except Form.DoesNotExist:
        raise Http404
    # get the seafform object (Seafile connexion)
    if settings.LOCAL:
        seaf = None
    else:
        seafu = form.owner.seafileuser
        seaf = Seafile(seafu.seafroot, verifycerts=settings.VERIFYCERTS)
        seaf.authenticate(form.owner.email, token=seafu.seaftoken, validate=False)
    seafform = SeafForm(form.filepath, seaf, form.repoid)
    try:
        seafform.load()
    except APIError:
        raise Http404
        
    _update_form_attr(form, seafform)
    
    # build the corresponding DjForm()
    if request.method == 'POST':
        results = False
        # results management
        djform = DjForm(request.POST, fieldlist=seafform.fields)
        if djform.is_valid():
            # check if we replace a row
            if seafform.edit and djform.cleaned_data['rowid'] != 'newrow':
                replace_row = int(djform.cleaned_data['rowid'])
                justaddedrow = replace_row - HEADERS_ROW
            else:
                replace_row = None
                justaddedrow = seafform._first_empty_row - HEADERS_ROW
            # save data
            seafform.post(djform.cleaned_data, replace_row)
            
            # if valid form and form and not edit:
            if seafform.view_as == 'form' and not seafform.edit:
                # redirect to thanks
                return HttpResponseRedirect(reverse('thanks',args=(formid,)))
            elif seafform.view_as == 'form':
                return HttpResponseRedirect(
                    reverse('form',args=(formid,)) + '?results'
                )
                #results = True # redirect to table
                
            # clean fields
            djform = DjForm(fieldlist=seafform.fields)
    else:
        djform = DjForm(fieldlist=seafform.fields)
        results = ('results' in request.GET)
        
    if seafform.view_as == 'form' and not results:
        # form view
        return render(request, 'seafform/form_as_form.html', {
            'seafform': seafform,
            'modelform': form,
            'djform': djform,
        })
        
    elif seafform.view_as == 'table' or (results and seafform.edit):
        # hightlight first column if static field
        first_is_static = (seafform.fields[0].ident == 'static')
        # compute some results
        max_chk = 0
        computations = []
        for colid, field in enumerate(seafform.fields):
            # if check boxe, number of checks
            if field.ident.startswith('check'):
                res = sum(row[colid] for row in seafform.data if row[colid])
                max_chk = max(max_chk, res)
                computations.append(res)
            # if number, the sum
            elif field.ident == 'number':
                computations.append(sum(
                    row[colid] for row in seafform.data if row[colid]
                ))
            else:
                computations.append(None)
        # columns with a star
        max_chk_column = []
        for colid, field in enumerate(seafform.fields):
            if field.ident.startswith('check') and computations[colid] == max_chk:
                max_chk_column.append(colid)
        
        # table view    
        return render(request, 'seafform/form_as_table.html', {
            'seafform': seafform,
            'modelform': form,
            'djform': djform,
            'justaddedrow': justaddedrow,
            'first_is_static': first_is_static,
            'computations': computations,
            'max_chk_column': max_chk_column,
        })

    raise Http404