
@admin.route('/support_print', methods=["GET", "POST"])
@login_required
def support_print():

    action = request.form.get("action")
    start_date, end_date = get_date_range(request)

    if request.method != "POST":
    #    records = db.session.query(TechSupport).all()
    #    return render_template('support_select.html', records=records)

        records = (
            db.session.query(TechSupport)
            .filter(
                TechSupport.request_date.between(
                    start_date,
                    end_date
                )
            )
            .all()
        )

        return render_template(
            "support_select.html",
            records=records,
            start_date=start_date,
            end_date=end_date
        )

    if action == "set_date":

        records = (
            db.session.query(TechSupport)
            .filter(
                TechSupport.request_date.between(
                    start_date,
                    end_date
                )
            )
            .all()
        )

        return render_template(
            "support_select.html",
            records=records,
            start_date=start_date,
            end_date=end_date
        )

    rec_id = request.form.get("rec_id")

    if action == "select":

        record = (
            db.session.query(TechSupport)
            .filter(TechSupport.rec_id == rec_id)
            .first()
        )

        return render_template(
            'support_print.html',
            rec_id = rec_id,
            record = record, 
            units  = Unit.query.all() )

    return redirect(url_for('admin.support_view'))

