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)