def openid(request): openid = request.GET.get('openid') member = Member.objects.all() member = member.filter(openid=openid) if member: member = member[0] examine = member.demand.examine return iframe_jsonify(regist=True, examine=examine) else: return iframe_jsonify(regist=False, examine=None)
def bind(request): id = request.GET.get('id') openid = request.GET.get('openid') member = Member.objects.filter(id=id) if member: member = member[0] member.openid = openid image = request.GET.get('headurl') image = unquote(image) member.image = image member.save() return iframe_jsonify(data=True) else: return iframe_jsonify(data=False)
def verification_code(request): phone = request.GET.get('phone') member = Member.objects.all().filter(mobile_phone=phone) if member: member = member[0] mobile = str(member.mobile_phone) account = 'cf_chuanshiyun' password = str(hashlib.md5('wly.1234').hexdigest()) code = str(random.random()).split('.')[-1][4:8] content = '感谢您关注清华俱乐部,验证码为【%s】,10分钟内有效。' % code url = 'http://106.ihuyi.cn/webservice/sms.php?method=Submit&account=%s&password=%s&mobile=%s&content=%s' % ( account, password, mobile, content) urllib2.urlopen(url) id = member.id return iframe_jsonify(regist=True, data=code, id=id) else: return iframe_jsonify(regist=False, data=u'', id=u'')
def member_upload_excel(request): from regist.forms import FileUploadForm from member.utils import iframe_jsonify, errors_to_json from member.tasks import check_with_sheet, deal_with_sheet import xlrd if request.method == "POST": form = FileUploadForm(request.POST, files=request.FILES) if form.is_valid(): xls = form.cleaned_data['upload_xls'] book = xlrd.open_workbook(file_contents=xls.read()) try: sheet = book.sheet_by_name(u'Sheet1') except: return iframe_jsonify(state=False, data=u"工作表名字需为'Sheet1'!") nrows = sheet.nrows msg = check_with_sheet(sheet) if msg: return msg for row in xrange(1, nrows): deal_with_sheet(book, sheet, row) return iframe_jsonify(state=True, reverse_url=reverse('member_list')) else: return iframe_jsonify(state=False, error=errors_to_json(form.errors))
def check_with_sheet(sheet): clos = sheet.col_values(0) clos = list(clos) clos.pop(0) if "" in clos: return iframe_jsonify(state=False, data=u"序号填写不全,请检查后重新上传!") if not clos: return iframe_jsonify(state=False, data=u"没有写入序号!") nrows = sheet.nrows for row in xrange(2, nrows): rowval = sheet.row_values(row) sex = rowval[7] state = rowval[11] mobile_phone = str(int(rowval[16])) email = rowval[15] phonesql = Member.objects.filter(mobile_phone=mobile_phone) emailsql = Member.objects.filter(email=email) try: enrol_date = xlrd.xldate_as_tuple(rowval[9], 1) enrol_date = date(*enrol_date[:3]) except: enrol_date = None if len(rowval) < 18: return iframe_jsonify(state=False, data=u"表格内容缺少!") if "" in rowval: if "" in rowval[1]: pass else: return iframe_jsonify(state=False, data=u"内容不允许为空!") if sex not in (u'男', u'女'): return iframe_jsonify(state=False, data=u"性别请输入男或女!") if not enrol_date: return iframe_jsonify(state=False, data=u"请输入日期格式为: YYYY-MM-DD!") if phonesql: return iframe_jsonify(state=False, data=u"电话号码:%s已存在,请重新填写!" % mobile_phone) if emailsql: return iframe_jsonify(state=False, data=u"电子邮箱:%s已存在,请重新填写!" % email) if state not in (u'已在全职创业', u'已在兼职创业', u'准备兼职创业', u'准备全职创业', u'以认识朋友为主'): return iframe_jsonify(state=False, data=u"请输入正确的创业状态!")
def regist_info_basis(request): openid = [] headurl = [] host = 'http://qhcfp.xxxxx.com' url = '%s/regist/info_basis/?pre=up' % host url = quote(url) url = 'http://zgxcw.xxxxx.com/menu.php?active=getuser&cburl=%s' % url if request.GET.get('openid'): openid = request.GET.get('openid') get = dict(request.GET) if get.has_key('headurl'): headurl = True image = request.GET.get('headurl') image = unquote(image) wechat = {'openid': openid, 'image': image} request.session['wechat'] = wechat if request.method == 'POST': form = RegistBasisForm(request.POST) if request.is_ajax(): basis = request.POST basis = dict(basis) for k, v in basis.iteritems(): basis[k] = v[0] request.session['basis'] = basis return iframe_jsonify(state=True, url=url) if form.is_valid(): basis = form.cleaned_data request.session['basis'] = basis return redirect('///regist/info_educate/?pre=up') else: form = RegistBasisForm() if request.GET.get('pre') == 'up': basis = request.session.get('basis') form = RegistBasisForm(initial=basis) return render(request, 'regist_info_basis.html', { 'form': form, 'openid': openid, 'headurl': headurl, })