def login(request): body = {} db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() username = request.POST.get('username', None) repassword = request.POST.get('password', None) sql = "select username from auth_user where (username=%s or email=%s or phoneNum=%s) and repassword=%s" try: res = cursor.execute(sql, (username, username, username, repassword)) results = cursor.fetchall() if res: for (row, ) in results: result = row body['msg'] = '1' body['username'] = result result = resp.handle(body, True) else: body['msg'] = '输入用户名或密码错误' result = resp.handle(body, True) except: body = 'Error' result = resp.handle(body, False) cursor.close() db.close() return JsonResponse(result, safe=False)
def regist(request): body = {} db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() username = request.POST.get('username', None) phoneNum = request.POST.get('phoneNum', None) email = request.POST.get('email', None) repassword = request.POST.get('password', None) date_joined = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) sqlC = 'select username from auth_user where username=%s or email=%s or phoneNum=%s' res = cursor.execute(sqlC, (username, email, phoneNum)) if res: body['msg'] = '已有账号,请登录!' result = resp.handle(body, True) else: sql = "insert into auth_user(username,phoneNum,email,repassword,date_joined,is_superuser)values (%s,%s,%s,%s,%s,%s)" try: cursor.execute( sql, (username, phoneNum, email, repassword, date_joined, '0')) db.commit() body['msg'] = '1' result = resp.handle(body, True) except: body = 'Error' result = resp.handle(body, False) cursor.close() db.close() return JsonResponse(result, safe=False)
def getfirstGrade(grade, positionName): global MinSalarylist global MaxSalarylist global AvgSalarylist db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() positionName = '%' + positionName + '%' sql = 'select avgSalary from jobdata where grade= %s and positionName like %s and avgSalary>0 and industry!="" order by avgSalary' cursor.execute(sql, (grade, positionName)) #执行sql语句 results = cursor.fetchall() result = [] Sum = 0 if results: for (i, ) in results: result.append(i * 1000) Sum = Sum + int(i * 1000) avgS = float('%.2f' % (Sum / len(result))) minS = result[0] length = len(result) - 1 maxS = result[length] # if(maxS>(avgS*2)): # maxS = avgS + 5520 else: minS = '' maxS = '' avgS = '' MinSalarylist.append(minS) MaxSalarylist.append(maxS) AvgSalarylist.append(avgS) cursor.close() db.close()
def getFailCount(): db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() sql = 'select count(*) from jobdata where avgSalary=0 or (grade="中级" and avgSalary>45) or (grade="高级" and avgSalary>70) or industry="" or financeStage="" or companySize=""' cursor.execute(sql) #执行sql语句 results = cursor.fetchall() for (i, ) in results: result = i cursor.close() db.close() return result
def getSucCount(): db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() sql = 'select count(*) from jobdata' cursor.execute(sql) #执行sql语句 results = cursor.fetchall() for (i, ) in results: result = i cursor.close() db.close() return result
def getGradeSalary(grade, positionName): db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() positionName = '%' + positionName + '%' sql = 'select avgSalary from jobdata where grade= %s and positionName like %s and avgSalary>0 order by avgSalary' cursor.execute(sql, (grade, positionName)) #执行sql语句 results = cursor.fetchall() result = [] Sum = 0 for (i, ) in results: result.append(i) cursor.close() db.close() return result
def getIList(request): body = {} db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() sql = 'select name from industry' industryList = [] try: cursor.execute(sql) #执行sql语句 results = cursor.fetchall() for (row, ) in results: industryList.append(row) body['industryList'] = industryList result = resp.handle(body, True) except: body = 'Error' result = resp.handle(body, False) return JsonResponse(result, safe=False)
def getPCom(request): body = {} db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() sql = 'select companyFullName, count(*) AS count from jobdata group by companyFullName order by count desc' try: cursor.execute(sql) #执行sql语句 results = cursor.fetchall() xAxis = [] series = [] for row in results: if (row[1] > 200): positionName = row[0] hotdata = row[1] xAxis.append(positionName) series.append(hotdata) body['series'] = series body['gradeName'] = xAxis result = resp.handle(body, True) except: body = 'Error' result = resp.handle(body, False) return JsonResponse(result, safe=False)
def getfirstDate(grade, positionName, year, month): db = pymysql.connect(**sqlsetting.con()) cursor = db.cursor() positionName = '%' + positionName + '%' # year = year + '-%' # month = '%-'+month+"-%" datestr = year + '-%' + month + "-%" if year and month: sql = 'select count(*) from jobdata where grade= %s and positionName like %s and createTime like %s and avgSalary>0 and industry!=""' cursor.execute(sql, (grade, positionName, datestr)) #执行sql语句 else: sql = 'select count(*) from jobdata where grade= %s and positionName like %s and avgSalary>0 and industry!=""' cursor.execute(sql, (grade, positionName)) results = cursor.fetchall() result = 0 if results: for (i, ) in results: result = i else: result = 0 cursor.close() db.close() return result