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
