def update_assignment(task_id, type, target, charge_id, charge_name, deadline):
"""
政府人员更新任务信息，包含 任务名，目标，负责人，截至日期等
"""
sql = "update assignment set type=?, task_target=?, charger_id=?, charger_name=?, deadline=? where task_id=?"
return db.update(sql, type, target, charge_id, charge_name, deadline,
task_id)
def check_news(news_id):
"""
进行已读操作
"""
sql = "update station_news set news_status = 1 where news_id = %s".format(
news_id)
result = db.update(sql, news_id)
return result
def update_history_time(search_text):
"""
更新该搜索文本所在行的时间
:param search_text:
:return:
"""
sql = """
update search_history
set gmt_create = now()
where search_text = ?
"""
return db.update(sql, search_text, bind='data_mining')
def update_record_status(record_id, status):
"""
更新记录状态
"""
sql = "update submit_record set audit_status=? where record_id=?"
return db.update(sql, status, record_id)
def update_year_target(id, numbers):
"""
用户更新年度目标
"""
sql = "update target set numbers=? where id=?"
return db.update(sql, numbers, id)
def update_assignment_progress(task_id, progress):
"""
服务商修改完成度
"""
sql = "update assignment set progress=progress + ? where task_id=?"
return db.update(sql, progress, task_id)
def update_assignment_status(task_id, status):
"""
修改任务的状态
"""
sql = "update assignment set status=? where task_id=?"
return db.update(sql, status, task_id)