from flask import flash, render_template, session, request, redirect, url_for,jsonify
from admin.sponsorinfo import *
from flask import current_app as app

#---------------------主页资助管理----------------------------
#加载菜单信息
@app.route('/spmanage')
def spmanage():
    splist = loadSponsorList()
    return render_template('admin/a_spornor_manage.html', SPresults=splist)



@app.route('/addSPUnit', methods = ['POST'])
def addSPUnit():
    CNname=request.form['txt_CNname']
    ENname=request.form['txt_ENname']
    Link=request.form['txt_Link']
    Status=request.form['txt_Status']
    Order=request.form['txt_Order']
    Unit=[CNname, ENname, Link, Order, Status]
    result=add_SPUnit(Unit)
    if result >0:
        flash('资助方添加成功!')
    else:
        flash('资助方添加失败!')
    return redirect(url_for('spmanage'))

@app.route('/delSPUnit/<Unitid>', methods = ['POST'])
def delSPUnit(Unitid):
    result = del_SPUnit(Unitid)
    if result > 0:
        flash('菜单项删除成功!')
    else:
        flash('菜单项删除失败!')
    return redirect(url_for('spmanage'))

@app.route('/getSPUnit/<Unitid>', methods = ['POST','GET'])
def getSPUnit(Unitid):
    #print("修改用户:", ptid)
    result =loadSPUnitbyID(Unitid)

    if len(result) > 0:
        #print("加载成功")
        return jsonify(result)
    else:
        return redirect(url_for('spmanage'))

@app.route('/editSPUnit', methods = ['POST'])
def editSPUnit():
    SPid = request.form['txt_SPID']
    CNname = request.form['txt_SPCNname']
    ENname = request.form['txt_SPENname']
    Link = request.form['txt_SPLink']
    Status = request.form['txt_SPStatus']
    Order = request.form['txt_SPOrder']
    Unit = [SPid,CNname, ENname, Link, Order, Status]
    result=edit_SPUnit(Unit)
    if result >0:
        flash('编辑成功!')
    else:
        flash('编辑失败!')
    return redirect(url_for('spmanage'))