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,
})