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!")