def sjczpg(index,user_id): if request.method == 'GET': user = SC_User.query.filter_by(id=user_id).first() kpi_train_operate = SC_Kpi_Train_Operate.query.filter_by(index=index,user_id=user_id).first() return render_template("Performance/ygpgkh/sjczpg.html",user=user,index=index,kpi_train_operate=kpi_train_operate) else: try: kpi_train_operate = SC_Kpi_Train_Operate.query.filter_by(index=index,user_id=user_id).first() if kpi_train_operate: kpi_train_operate.job_tendency = request.form['job_tendency'] kpi_train_operate.index = index kpi_train_operate.assess_date = request.form['assess_date'] kpi_train_operate.marketing_plain = request.form['marketing_plain'] kpi_train_operate.marketing_complete = request.form['marketing_complete'] kpi_train_operate.marketing_score = request.form['marketing_score'] kpi_train_operate.sign_plain = request.form['sign_plain'] kpi_train_operate.sign_complete = request.form['sign_complete'] kpi_train_operate.sign_score = request.form['sign_score'] kpi_train_operate.loan_balance_plain = request.form['loan_balance_plain'] kpi_train_operate.loan_balance_complete = request.form['loan_balance_complete'] kpi_train_operate.loan_balance_score = request.form['loan_balance_score'] kpi_train_operate.monitor_plain = request.form['monitor_plain'] kpi_train_operate.monitor_complete = request.form['monitor_complete'] kpi_train_operate.monitor_score = request.form['monitor_score'] kpi_train_operate.ywdlx = request.form['ywdlx'] kpi_train_operate.yxnl = request.form['yxnl'] kpi_train_operate.dqdc = request.form['dqdc'] kpi_train_operate.sdhcs = request.form['sdhcs'] kpi_train_operate.jszs = request.form['jszs'] kpi_train_operate.khfw = request.form['khfw'] kpi_train_operate.kqjl = request.form['kqjl'] kpi_train_operate.zrx = request.form['zrx'] kpi_train_operate.gtxt = request.form['gtxt'] kpi_train_operate.tdxz = request.form['tdxz'] kpi_train_operate.total = request.form['total'] kpi_train_operate.result = request.form['result'] kpi_train_operate.performance = request.form['performance'] kpi_train_operate.focus_on = request.form['focus_on'] kpi_train_operate.next_work_target = request.form['next_work_target'] kpi_train_operate.individual_expectations = request.form['individual_expectations'] kpi_train_operate.user_id = user_id kpi_train_operate.date_1 = datetime.datetime.now() kpi_train_operate.manager = current_user.id kpi_train_operate.date_2 = datetime.datetime.now() else: SC_Kpi_Train_Operate(request.form['job_tendency'],index,request.form['assess_date'],request.form['marketing_plain'], request.form['marketing_complete'],request.form['marketing_score'],request.form['sign_plain'], request.form['sign_complete'],request.form['sign_score'],request.form['loan_balance_plain'], request.form['loan_balance_complete'],request.form['loan_balance_score'],request.form['monitor_plain'], request.form['monitor_complete'],request.form['monitor_score'],request.form['ywdlx'],request.form['yxnl'], request.form['dqdc'],request.form['sdhcs'],request.form['jszs'],request.form['khfw'],request.form['kqjl'], request.form['zrx'],request.form['gtxt'],request.form['tdxz'],request.form['total'],request.form['result'], request.form['performance'],request.form['focus_on'],request.form['next_work_target'],request.form['individual_expectations'], user_id,datetime.datetime.now(),current_user.id,datetime.datetime.now()).add() #同时修改SC_Kpi_Train_Final表 kpi_train_final = SC_Kpi_Train_Final.query.filter_by(user_id=user_id).first() if kpi_train_final: if index == 1: kpi_train_final.score_2 = request.form['total'] elif index == 2: kpi_train_final.score_3 = request.form['total'] elif index == 3: kpi_train_final.score_4 = request.form['total'] else: kpi_train_final = SC_Kpi_Train_Final(user_id) kpi_train_final.add() db.session.flush() if index == 1: kpi_train_final.score_2 = request.form['total'] elif index == 2: kpi_train_final.score_3 = request.form['total'] elif index == 3: kpi_train_final.score_4 = request.form['total'] # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Performance/ygpgkh/pxqpglist')