def update_yn(qid, business_id, supplier_id, is_worked):
if qid:
sql = """
update supplier_qa_history set business_id=%(business_id)s, supplier_id=%(supplier_id)s, update_time=now(), is_worked= %(is_worked)s
where id = %(qid)s and business_id=%(business_id)s and supplier_id=%(supplier_id)s"""
args = {
'qid': qid,
'business_id': business_id,
'supplier_id': supplier_id,
'is_worked': is_worked
}
n = PgDbDumper.update_args(conn_str, sql, args)
logger.info("SupplierQaHistory table update_yn ={}".format(
dict(qid=qid, business_id=business_id,
supplier_id=supplier_id)))
return n
def ignore_feedback(qid, business_id, supplier_id, status, update_user):
if qid:
sql = """
update supplier_qa_history set business_id=%(business_id)s, supplier_id=%(supplier_id)s, update_time=now(), status=%(status)s,update_user=%(update_user)s
where id = %(qid)s and business_id=%(business_id)s and supplier_id=%(supplier_id)s"""
args = {
'qid': qid,
'business_id': business_id,
'supplier_id': supplier_id,
'status': status,
'update_user': update_user
}
n = PgDbDumper.update_args(conn_str, sql, args)
logger.info("SupplierQaHistory table ignore_feedback ={}".format(
dict(qid=qid, business_id=business_id,
supplier_id=supplier_id)))
return n