def getMonth(request):
seriesList = []
seriesChild = {}
seriesData = []
body = {}
positionName = request.POST.get('positionName', None)
year = request.POST.get('year', None)
try:
gradeArray = ['入门', '初级', '中级', '高级', '专家', '不限']
gradeName = [
'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11',
'12'
]
for i in gradeArray:
seriesData = []
seriesChild = {}
for j in gradeName:
count = getfirstDate(i, positionName, year, j)
seriesData.append(count)
seriesChild['name'] = i
seriesChild['data'] = seriesData
seriesList.append(seriesChild)
body['series'] = seriesList
body['gradeName'] = gradeName
result = resp.handle(body, True)
except:
body = 'Error'
result = resp.handle(body, False)
return JsonResponse(result, safe=False)
def getCityNeed(request):
seriesList = []
seriesChild = {}
seriesData = []
body = {}
positionName = request.POST.get('positionName', None)
year = request.POST.get('year', None)
city = request.POST.get('city', None)
# q = Queue()
try:
gradeArray = ['入门', '初级', '中级', '高级', '专家', '不限']
gradeName = [
'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11',
'12'
]
for i in gradeArray:
seriesData = []
seriesChild = {}
for j in gradeName:
# count = Process(target=getfirstData, args=(i,positionName,year,j,city,q))
count = getfirstData(i, positionName, year, j, city)
# count.start()
# seriesData.append(q.get())
seriesData.append(count)
seriesChild['name'] = i
seriesChild['data'] = seriesData
seriesList.append(seriesChild)
# count.join()
body['series'] = seriesList
body['gradeName'] = gradeName
result = resp.handle(body, True)
except:
body = 'Error'
result = resp.handle(body, False)
return JsonResponse(result, safe=False)
def getCity(request):
global MinSalarylist
global MaxSalarylist
global AvgSalarylist
SalaryList = [{}, {}, {}]
MinSalarylist = []
MaxSalarylist = []
AvgSalarylist = []
body = {}
positionName = request.POST.get('positionName', None)
city = request.POST.get('city', None)
try:
getfirstcity('入门', positionName, city)
getfirstcity('初级', positionName, city)
getfirstcity('中级', positionName, city)
getfirstcity('高级', positionName, city)
getfirstcity('专家', positionName, city)
getfirstcity('不限', positionName, city)
SalaryList[0]['name'] = '最低工资'
SalaryList[0]['data'] = MinSalarylist
SalaryList[1]['name'] = '平均工资'
SalaryList[1]['data'] = AvgSalarylist
SalaryList[2]['name'] = '最高工资'
SalaryList[2]['data'] = MaxSalarylist
gradeName = ['入门', '初级', '中级', '高级', '专家', '不限']
body['gradeName'] = gradeName
body['series'] = SalaryList
result = resp.handle(body, True)
except:
body = 'Error'
result = resp.handle(body, False)
return JsonResponse(result, safe=False)
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 getSGrade(request):
SalaryList = [{}, {}, {}, {}, {}]
body = {}
positionName = request.POST.get('positionName', None)
try:
first = getGradeSalary('入门', positionName)
second = getGradeSalary('初级', positionName)
three = getGradeSalary('中级', positionName)
four = getGradeSalary('高级', positionName)
five = getGradeSalary('专家', positionName)
SalaryList[0]['name'] = '入门'
SalaryList[0]['data'] = first
SalaryList[1]['name'] = '初级'
SalaryList[1]['data'] = second
SalaryList[2]['name'] = '中级'
SalaryList[2]['data'] = three
SalaryList[3]['name'] = '高级'
SalaryList[3]['data'] = four
SalaryList[4]['name'] = '专家'
SalaryList[4]['data'] = five
gradeName = ['入门', '初级', '中级', '高级', '专家']
body['gradeName'] = gradeName
body['series'] = SalaryList
result = resp.handle(body, True)
except:
body = 'Error'
result = resp.handle(body, False)
return JsonResponse(result, safe=False)
def getCount(request):
body = {}
try:
body['interNum'] = 1
body['count'] = getSucCount()
body['failCount'] = getFailCount()
body['vaildCount'] = body['count'] - body['failCount']
result = resp.handle(body, True)
except:
body = 'Error'
result = resp.handle(body, False)
return JsonResponse(result, safe=False)
def logout(req):
response = HttpResponse('logout !!')
#清理cookie里保存username
response.delete_cookie('username')
body['msg'] = '退出'
result = resp.handle(body, True)
return JsonResponse(result, safe=False)
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 index(request):
body = {}
username = request.COOKIES.get('username', '')
body['msg'] = '1'
result = resp.handle(body, True)
return JsonResponse(result, safe=False)
