def update_assist_detail_To_del_flag(self, user_id):
mysql = MySQL()
query = "UPDATE `assist_detail` SET del_flag=1 WHERE self=0 AND TO_DAYS(create_date) = TO_DAYS(NOW())AND user_id=" + str(
user_id)
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_learning_plan_daily_To_compliance(self, user_id, **kwargs):
mysql = MySQL()
sql = {}
string = ""
if 'exam_type_id' in list(kwargs.keys()):
string = string + " AND exam_type_id=" + str(kwargs['exam_type_id'])
if "subject_id" in list(kwargs.keys()):
string = string + " AND subject_id=" + str(kwargs['subject_id'])
fields = "id,compliance"
query = "SELECT " + fields + " FROM `learning_plan_daily` WHERE DATE_FORMAT(create_date,'%Y%m%d') = DATE_FORMAT(NOW(),'%Y%m%d') AND user_id=" + str(
user_id) + string
print(query)
count = mysql.getRowCount(query)
print('count = ', count)
if count > 0:
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
for i in range(len(sql['id'])):
if ord(sql['compliance'][i]) > 0:
query = "UPDATE `learning_plan_daily` SET compliance=0,answer_sum=0,correct_answer_sum=0 WHERE id=" + str(
sql['id'][i])
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_user_clock_in_To_details(self, user_id, **kwargs):
mysql = MySQL()
sql = {}
string = ""
if 'exam_type_id' in list(kwargs.keys()):
string = string + " AND exam_type_id=" + str(kwargs['exam_type_id'])
if "subject_id" in list(kwargs.keys()):
string = string + " AND subject_id=" + str(kwargs['subject_id'])
fields = "id,clock_in_details"
query = "SELECT " + fields + " FROM `user_clock_in` WHERE DATE_FORMAT(create_date,'%Y%m') = DATE_FORMAT(NOW(),'%Y%m') AND user_id=" + str(
user_id) + string
print(query)
result = mysql.getAllRow(query)
self._getSqlDict(sql, fields, result)
for i in range(len(sql['id'])):
id = sql['id'][i]
clock_in_details = sql['clock_in_details'][i]
index = re.search(str(datetime.datetime.now().day) + ":", clock_in_details).end()
clock_in_details = clock_in_details[:index] + "2" + clock_in_details[index + 1:]
query = "UPDATE `user_clock_in` SET clock_in_details='" + clock_in_details + "' WHERE id=" + str(
id) + " AND user_id=" + str(user_id)
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_commodity_cut_To_create_date(self, commodity_id, user_id_1, user_id_2):
mysql = MySQL()
query = "UPDATE `commodity_cut` SET create_date = DATE_SUB(create_date,INTERVAL '1 0:0:0' DAY_SECOND) WHERE TO_DAYS(create_date)= TO_DAYS(NOW()) AND commodity_id=" + str(
commodity_id) + " AND launch_user_id=" + str(user_id_1) + " AND help_user_id=" + str(user_id_2)
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_learning_plan_To_del_flag(self, user_id, exam_type_id):
mysql = MySQL()
query = "UPDATE `learning_plan` SET del_flag=1 WHERE del_flag=0 AND user_id=" + str(
user_id) + " AND exam_type_id=" + str(exam_type_id)
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_group_order_To_del_flag(self, user_id):
mysql = MySQL()
query = "UPDATE `group_order` SET del_flag=1 WHERE del_flag=0 AND create_by=" + str(
user_id)
print query
mysql.editData(query)
print "MySQL update success！"
def update_already_order_To_pay_status(self, pay_status):
mysql = MySQL()
query = "UPDATE `commodity_order` SET pay_status=" + str(pay_status) + " WHERE id=931"
print(query)
mysql.editData(query)
print("MySQL update success！")
query = "UPDATE `commodity_order_details` SET pay_status=" + str(pay_status) + " WHERE id=932"
print(query)
mysql.editData(query)
print("MySQL update success！")
def update_group_order_To_status(self, id):
mysql = MySQL()
query = "UPDATE `group_order` SET `status`=10 WHERE id=" + str(id)
print(query)
mysql.editData(query)
print("MySQL update success！")
