um-cseg / chez-betty

                     .filter(Item.enabled==True)\

                     .filter(Item.in_stock==0)\

                     .order_by(Item.name).all()

    disabled_items = DBSession.query(Item)\

                     .filter(Item.enabled==False)\

                     .order_by(Item.name).all()

    return {'items': items,

            'out_of_stock_items': out_of_stock_items,

            'disabled_items': disabled_items}

@view_config(route_name='user_ajax_item_request_fuzzy',

             renderer='templates/user/item_request_fuzzy.jinja2',

             permission='user')

def item_request_fuzzy(request):

    new_item = request.POST['new_item']

    matches = DBSession.query(Item)\

            .filter(Item.name.ilike('%'+new_item+'%'))\

            .order_by(Item.name)

    enabled = matches.filter(Item.enabled==True)

    in_stock = enabled.filter(Item.in_stock>0).all()

    out_of_stock = enabled.filter(Item.in_stock==0).all()

    for item in out_of_stock:

        purchase = SubTransaction.all_item_purchases(item.id, limit=1)[0]

        item.most_recent_purchase = purchase

    disabled = matches.filter(Item.enabled==False).all()

    return {

            'in_stock': in_stock,

            'out_of_stock': out_of_stock,

            'disabled': disabled,

    return {

            'in_stock': in_stock,

            'out_of_stock': out_of_stock,

            'disabled': disabled,

            }

@view_config(route_name='user_item_request',

             renderer='templates/user/item_request.jinja2',

             permission='user')

def item_request(request):

    requests = Request.all()

    vendors = Vendor.all()

    return {

            'requests': requests,

            'vendors': vendors,

           }

@view_config(route_name='user_item_request_new',

             request_method='POST',

             permission='user')

def item_request_new(request):

    try:

        request_text = request.POST['request']

        vendor_id = request.POST['vendor']