def Get_data_sign_up(request,usr_id_gy): sql="""SELECT id,sup_name,utime,join_time FROM suppliers_sign_up WHERE cid = %s """%(usr_id_gy) rows,iN = db.select(sql) L=rows[0] return L
def getRecvUser(): sql = """select GROUP_CONCAT(u.login_id) from roles r left join usr_role ur on ur.role_id = r.role_id left join users u on ur.usr_id = u.usr_id where r.role_name = '供应商加入审核(供应商服务平台)'""" rows,iN = db.select(sql) users=rows[0][0] users = users.replace(',','|') return users
def getAuditUserIds(): sql = """select u.usr_id from roles r left join usr_role ur on ur.role_id = r.role_id left join users u on ur.usr_id = u.usr_id where r.role_name = '供应商加入审核(供应商服务平台)'""" rows,iN = db.select(sql) users= [] for e in rows: users.append(str(e[0])) users.append('2938') users.append('2110') users.append('2572') return users
def getSign(): sql = "select sign,expired from tencent_yun_sign where id =1" rows,iN = db.select(sql) if iN == 0: Sign,expired,current = generateSign() sql = "insert into tencent_yun_sign (id,sign,expired,current) values (1,'%s',%s,%s)"%(Sign,expired,current) db.executesql(sql) else: current = int(time.time()) expired = rows[0][1] Sign = rows[0][0] if expired < current + 1000: Sign,expired,current = generateSign() sql = "update tencent_yun_sign set sign='%s',expired=%s,current=%s where id=1"%(Sign,expired,current) db.executesql(sql) return Sign
def IDCardOCR(request): #usr_id,session_key,errorMsg=checkSession(request) #if usr_id==0: # return HttpResponseJsonCORS(errorMsg) usr_id_gy = request.session.get('usr_id_gy','') or testid type = request.POST.get('type') or request.GET.get('type') if str(type) == '4': card_type = 0 elif str(type) == '5': card_type = 1 sql = "select id,fname from suppliers_pic where cid = %s and file_type=%s"%(usr_id_gy,type) print sql rows,iN = db.select(sql) fname = rows[0][1] card_img = os.path.join(front_url,str(usr_id_gy),fname) sMsg = """{ "appid":%s, "bucket":"%s", "card_type":%s, "url_list":[ "%s" ] } """%(appid,bucket,card_type,card_img) url = "/ocr/idcard" print sMsg Sign = getSign() headers = {"Content-Type": "application/json","Authorization": Sign} conn = httplib.HTTPSConnection('recognition.image.myqcloud.com') conn.request('POST', '%s'%url,sMsg,headers) res = conn.getresponse() body = res.read() conn.close() return handleInfo(body,card_type)
def del_attach_file(request): func = request.GET.get('func','') usr_id_gy = request.session.get('usr_id_gy','') or testid usr_id_qy = request.session.get('usr_id_qy','') or 0 if usr_id_gy ==0 and usr_id_qy==0: s = """ { "errcode": -1, "errmsg": "无权访问,请先关注" } """ return HttpResponseJsonCORS(s) fname = request.GET.get('fname','') sql="SELECT fname,file_type,cid FROM suppliers_pic WHERE fname='%s'"%(fname) print sql lT,iN=db.select(sql) if iN>0: L=list(lT[0]) cid = L[2] if L[1] == 7: path=os.path.join(upload_path_mat,'%s'%(cid)) else: path=os.path.join(upload_path,'%s'%(cid)) if fname!='': path=os.path.join(path,fname) try: os.remove(path) except: pass sql="delete from suppliers_pic WHERE fname='%s'"%(fname) db.executesql(sql) s = """ { "error": false } """ return HttpResponseJsonCORS(s)
def sup_join(usr_id_gy): #sql = "select name from sys.columns where object_id=object_id('suppliers')" #rows,iN = byerp.select(sql) sql = """select sup_name,addr,busi_code,allotted_time,sw_no ,faren,lxr_name,lxr_phone,remark ,manage_area,sw_bank_name,sw_bank_no,province,city ,tax_type+1,sw_address,sw_phone,zzjg_no,commpany_memo ,lxr_idcard,lxr_email,case lxr_sex when '男' then 1 else 0 end,lxr_birth from suppliers_sign_up where cid = %s"""%(usr_id_gy) rows,iN=db.select(sql) sup_name = rows[0][0] idcard = rows[0][19] sql = "select id from suppliers where cname='%s'"%(sup_name) rows1,iN = byerp.select(sql) if iN>0: id = rows1[0][0] else: sql = "select max(code) from suppliers" rows2,iN = byerp.select(sql) code1 = rows2[0][0][2:] code = 'SP' + str(int(code1) + 1) sql = "insert into suppliers (code,cname,jg_lb,cid,ctime) values ('%s','%s',2,1,getdate())"%(code,sup_name) byerp.executesql(sql) sql = "select id from suppliers where cname='%s'"%(sup_name) rows2,iN = byerp.select(sql) id = rows2[0][0] sql = """update suppliers set [addr]='%s',[busi_code]='%s',[busi_valid_date]='%s',[tax_code]='%s',[is_busi]=1 ,[faren]='%s',[gysct]='%s',[tel]='%s',[status]=1,[memo]='%s' ,[busi_scope]='%s',[khbank]='%s',bank_info='%s',province='%s',city='%s' ,[nsrsf]=%s,[swdjdz]='%s',[swdjdh]='%s',[jgdmzbh]='%s',[jg_memo]='%s' ,utime = getdate() where id='%s' """%(rows[0][1],rows[0][2],rows[0][3],rows[0][4] ,rows[0][5],rows[0][6],rows[0][7],rows[0][8] ,rows[0][9],rows[0][10],rows[0][11],rows[0][12],rows[0][13] ,rows[0][14],rows[0][15],rows[0][16],rows[0][17],rows[0][18] ,id) print ToGBK(sql) byerp.executesql(sql) sql = "select id from addr_book where license='%s'"%(idcard) rows1,iN = byerp.select(sql) if iN>0: ab_id = rows1[0][0] sql = "select id from addr_book_group where addr_book_id=%s and addr_group_id = 2 "%(ab_id) rows2,iN2 = byerp.select(sql) if iN2 == 0: sql = "insert into addr_book_group (addr_book_id,addr_group_id,ctime) values ('%s',2,getdate())"%(ab_id) byerp.executesql(sql) else: sql = "insert into addr_book (license,status,cid,ctime) values ('%s',1,1,getdate())"%(idcard) byerp.executesql(sql) sql = "select id from addr_book where license='%s'"%(idcard) rows2,iN = byerp.select(sql) ab_id = rows2[0][0] sql = "insert into addr_book_group (addr_book_id,addr_group_id,ctime) values ('%s',2,getdate())"%(ab_id) byerp.executesql(sql) sql = "update addr_book set name='%s',sex=%s,mobile='%s',email='%s',sup_id=%s,coname='%s',utime = getdate() where id = %s"%(rows[0][6],rows[0][21],rows[0][7],rows[0][20],id,sup_name,ab_id) #print ToGBK(sql) byerp.executesql(sql) sql = "update users_gy set status=1,addr_id='%s',usr_name='%s',phone='%s',bandtime=now() where usr_id=%s"%(ab_id,rows[0][6],rows[0][7],usr_id_gy) db.executesql(sql) sql = "update addr_book set sup_id=%s,coname='%s',name='%s',mobile='%s' where id=%s"%(id,sup_name,rows[0][6],rows[0][7],ab_id) db.executesql(sql) return
def saveSupName(request): usr_id_gy = request.session.get('usr_id_gy','') or testid step = request.POST.get('step','1') print request.POST if str(step) == '1': sup_name = request.POST.get('sup_name','') sup_name = MySQLdb.escape_string(sup_name) sup_name = sup_name.strip() sql="""select id from suppliers_sign_up where sup_name = '%s' and cid != %s union select id from suppliers where cname = '%s' and status=1"""%(sup_name,usr_id_gy,sup_name) #print ToGBK(sql) rows,iN=db.select(sql) if iN>0: s = """ { "errcode": -1, "errmsg": "供应商名称重复" } """ return HttpResponseJsonCORS(s) busi_code = request.POST.get('busi_code','') faren = request.POST.get('faren','') addr = request.POST.get('addr','') sup_type = request.POST.get('sup_type','') allotted_time = request.POST.get('allotted_time','') sql="""select id from suppliers_sign_up where cid = %s"""%(usr_id_gy) rows,iN=db.select(sql) if iN>0: sql = """update suppliers_sign_up set busi_code='%s',faren='%s',sup_name='%s',addr='%s',sup_type='%s',allotted_time='%s' where cid= %s """%(busi_code,faren,sup_name,addr,sup_type,allotted_time,usr_id_gy) else: sql = """insert into suppliers_sign_up (busi_code,faren,sup_name,addr,sup_type,allotted_time,cid,ctime) values ('%s','%s','%s','%s','%s','%s','%s',now()) """%(busi_code,faren,sup_name,addr,sup_type,allotted_time,usr_id_gy) db.executesql(sql) elif str(step) == '2': addr = request.POST.get('addr','') gy_phone = request.POST.get('gy_phone','') gy_name = request.POST.get('gy_name','') manage_area = request.POST.get('manage_area','') place = request.POST.get('place[cont]','') province = request.POST.get('place[province_value]','') city = request.POST.get('place[city_value]','') tax_type = request.POST.get('tax_type','') work_address = request.POST.get('work_address','') memo = request.POST.get('memo','') is_merge = request.POST.get('is_merge','') sql = """update suppliers_sign_up set addr='%s',gy_name='%s',gy_phone='%s',manage_area='%s',province='%s' ,city='%s',place='%s',tax_type=%s,work_address='%s',memo='%s',is_merge=%s,utime=now() where cid= %s """%(addr,gy_name,gy_phone,manage_area,province,city,place,tax_type,work_address,memo,is_merge,usr_id_gy) print ToGBK(sql) db.executesql(sql) errcode = mWxPushMsg_Sign_up(request,usr_id_gy) if errcode == 0: sql = """update suppliers_sign_up set status = 1 where cid= %s """%(usr_id_gy) #print sql db.executesql(sql) elif str(step) == '3': sw_address = request.POST.get('sw_address','') sw_bank_name = request.POST.get('sw_bank_name','') sw_bank_no = request.POST.get('sw_bank_no','') sw_no = request.POST.get('sw_no','') sw_phone = request.POST.get('sw_phone','') zzjg_no = request.POST.get('zzjg_no','') commpany_memo = request.POST.get('commpany_memo','') remark = request.POST.get('remark','') sql = """update suppliers_sign_up set sw_address='%s',sw_bank_name='%s',sw_bank_no='%s',sw_no='%s',sw_phone='%s' ,zzjg_no='%s',commpany_memo='%s',remark='%s',join_time=now() where cid= %s """%(sw_address,sw_bank_name,sw_bank_no,sw_no,sw_phone,zzjg_no,commpany_memo,remark,usr_id_gy) print ToGBK(sql) db.executesql(sql) elif str(step) == '4': valid_date = request.POST.get('valid_date','') name = request.POST.get('name','') authority = request.POST.get('authority','') sex = request.POST.get('sex','') phone = request.POST.get('phone','') birth = request.POST.get('birth','') address = request.POST.get('address','') id = request.POST.get('id','') nation = request.POST.get('nation','') email = request.POST.get('email','') sql = """select a.id from addr_book a left join addr_book_group g on a.id = g.addr_book_id left join users_gy u on u.addr_id = a.id where g.addr_group_id = 2 and a.license = '%s' and u.status = 1 """%(id) lT1,iN1=db.select(sql) if iN1>0: s = """ { "errcode": -1, "errmsg": "该身份证已绑定其他供应商,添加失败" } """ return HttpResponseJsonCORS(s) if birth == '': sql = """update suppliers_sign_up set lxr_name='%s',lxr_phone='%s' ,lxr_idcard='%s',lxr_email='%s' where cid= %s """%(name,phone,id,email,usr_id_gy) else: sql = """update suppliers_sign_up set lxr_valid_date='%s',lxr_name='%s',lxr_authority='%s',lxr_sex='%s',lxr_phone='%s' ,lxr_birth='%s',lxr_address='%s',lxr_idcard='%s',lxr_nation='%s',lxr_email='%s' where cid= %s """%(valid_date,name,authority,sex,phone,birth,address,id,nation,email,usr_id_gy) print ToGBK(sql) db.executesql(sql) sup_join(usr_id_gy) errcode = mWxPushMsg_Join(request,usr_id_gy) if errcode == 0: sql = """update suppliers_sign_up set status = 3 where cid= %s """%(usr_id_gy) #print sql db.executesql(sql) s = """ { "errcode": 0, "errmsg": "恭喜您报名成功!" } """ # s=ToGBK(s) return HttpResponseJsonCORS(s) s = """ { "errcode": 0, "errmsg": "保存成功" } """ # s=ToGBK(s) return HttpResponseJsonCORS(s)
def getSupInfo(request): usr_id_gy = request.session.get('usr_id_gy','') or testid print request.POST id = request.POST.get('id','') audit_btn = 0 if id !='': step = '2' usr_id_qy = request.session.get('usr_id_qy','') or testid print "usr_id_qy=%s"%usr_id_qy users = getAuditUserIds() if str(usr_id_qy) in users : audit_btn = 1 #审核人员 else: step = request.POST.get('step','2') sql = "select usr_id from users_gy where usr_id = %s and status=1"%usr_id_gy print sql rows,iN=db.select(sql) if iN>0: s = """ { "errcode": 10001, "errmsg": "用户已绑定供应商,无法进行供应商报名" } """ return HttpResponseJsonCORS(s) sql = "select status from suppliers_sign_up where cid = %s"%usr_id_gy rows,iN=db.select(sql) if iN >0 and str(step)=='1': if rows[0][0] ==1: s = """ { "errcode": 10002, "errmsg": "用户提交供应商报名" } """ return HttpResponseJsonCORS(s) elif rows[0][0] == 2: s = """ { "errcode": 10003, "errmsg": "供应商报名已通过" } """ return HttpResponseJsonCORS(s) #elif rows[0][0] == -1: # s = """ # { # "errcode": 10004, # "errmsg": "供应商报名未通过" # } """ # return HttpResponseJsonCORS(s) if str(step) == '1': sql = "select id,busi_code,faren,sup_name,addr,sup_type,allotted_time,status,audit_memo,'' from suppliers_sign_up where cid = %s"%usr_id_gy rows,iN=db.select(sql) L=[] if iN>0: L = list(rows[0]) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=1"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[9] = os.path.join(front_url,str(usr_id_gy),fname1) names = 'id busi_code faren sup_name addr sup_type allotted_time status audit_memo busi_pic'.split() data = [dict(zip(names, L))] L = json.dumps(data,ensure_ascii=False,cls=ComplexEncoder) s = """ { "errcode": 0, "errmsg": "获取供应商报名信息成功", "data": %s } """%(L) return HttpResponseJsonCORS(s) elif str(step) == '4': sql = """select lxr_name,lxr_phone,lxr_idcard,lxr_email,'','','' from suppliers_sign_up""" sql += " where cid = %s"%usr_id_gy print sql rows,iN=db.select(sql) L=[] if iN>0: L = list(rows[0]) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=4"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[4] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=5"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[5] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,''),'','',file_size,ctime,is_pic,title,cid FROM suppliers_pic WHERE cid = %s and file_type=6"%(usr_id_gy) lT1,iN1=db.select(sql) L2 = [] for e in lT1: L1=list(e) fname = e[0] cid = e[7] L1[0] = os.path.join(front_url,str(cid),fname) L1[1] = os.path.join(front_url,str(cid),'thumbnail',fname) L1[2] = "%s/del_attach_file/?fname=%s"%(data_url,fname) L2.append(L1) names = "url thumbnail delete_url file_size ctime is_pic title".split() L[6] = [dict(zip(names, d)) for d in L2] names = 'lxr_name lxr_phone lxr_idcard lxr_email idcard_pic idcard_pic1 attach'.split() data = [dict(zip(names, L))] L = json.dumps(data,ensure_ascii=False,cls=ComplexEncoder) s = """ { "errcode": 0, "errmsg": "获取供应商联系人信息成功", "data": %s } """%(L) return HttpResponseJsonCORS(s) else: sql = """select id,busi_code,faren,sup_name,addr,sup_type,allotted_time,'','','' ,ifnull(gy_phone,'') ,ifnull(manage_area,''),tax_type,ifnull(work_address,''),province,city ,ifnull(place,''),ifnull(gy_name,''),ifnull(memo,''),is_merge,ifnull(status,0) ,ifnull(sw_address,''),ifnull(sw_bank_name,''),ifnull(sw_bank_no,''),ifnull(sw_no,''),ifnull(sw_phone,''),ifnull(zzjg_no,'') ,ifnull(commpany_memo,''),ifnull(remark,''),lxr_name,lxr_phone,lxr_idcard,lxr_email ,'','','',cid from suppliers_sign_up""" if id != '': sql += " where id = %s"%id else: sql += " where cid = %s"%usr_id_gy print sql rows,iN=db.select(sql) L=[] if iN>0: L = list(rows[0]) usr_id_gy = L[-1] sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=1"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[7] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=3"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[8] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=2"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[9] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=4"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[-4] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=5"%(usr_id_gy) lT1,iN1=db.select(sql) if iN1>0: L1=list(lT1[0]) fname1=L1[0] L[-3] = os.path.join(front_url,str(usr_id_gy),fname1) sql="SELECT ifnull(fname,''),'','',file_size,ctime,is_pic,title,cid FROM suppliers_pic WHERE cid = %s and file_type=6"%(usr_id_gy) lT1,iN1=db.select(sql) L2 = [] for e in lT1: L1=list(e) fname = e[0] cid = e[7] L1[0] = os.path.join(front_url,str(cid),fname) L1[1] = os.path.join(front_url,str(cid),'thumbnail',fname) L1[2] = "%s/del_attach_file/?fname=%s"%(data_url,fname) L2.append(L1) names = "url thumbnail delete_url file_size ctime is_pic title".split() L[-2] = [dict(zip(names, d)) for d in L2] L[-1] = audit_btn names = 'id busi_code faren sup_name addr sup_type allotted_time busi_pic tax_pic org_pic gy_phone manage_area tax_type work_address province city place gy_name memo is_merge status sw_address sw_bank_name sw_bank_no sw_no sw_phone zzjg_no commpany_memo remark lxr_name lxr_phone lxr_idcard lxr_email idcard_pic idcard_pic1 attach audit_btn'.split() data = [dict(zip(names, L))] L = json.dumps(data,ensure_ascii=False,cls=ComplexEncoder) s = """ { "errcode": 0, "errmsg": "获取供应商报名信息成功", "data": %s } """%(L) return HttpResponseJsonCORS(s)
def upload_licence(request): if request.method == "POST": # 请求方法为POST时,进行处理 file_type = request.POST.get('file_type', '1') random_no = request.POST.get('random_no', '') if str(file_type) == '7': usr_id_gy = request.session.get('usr_id_qy','') upload_path1 = upload_path_mat front_url1 = front_url_mat else: usr_id_gy = request.session.get('usr_id_gy','') or testid upload_path1 = upload_path front_url1 = front_url if usr_id_gy ==0: s = """ { "errcode": -1, "errmsg": "无权访问,请先关注" } """ return HttpResponseJsonCORS(s) myFile =request.FILES.get("file", None) # 获取上传的文件,如果没有文件,则默认为None if not myFile: s = """ { "error": true } """ return HttpResponseJsonCORS(s) title = myFile.name f_ext=title.split('.')[-1] fname = "%s_%s_%s.%s"%(usr_id_gy,time.time(),random.randint(0,99),f_ext) path=os.path.join(upload_path1,str(usr_id_gy)) make_sub_path(path) #检查目录是否存在,如果不存在,生成目录 make_sub_path destination = open(os.path.join(path,fname),'wb+') # 打开特定的文件进行二进制的写操作 for chunk in myFile.chunks(): # 分块写入文件 destination.write(chunk) destination.close() if str(file_type) == '1': title = u'营业执照.%s'%(f_ext) elif str(file_type) == '2': title = u'组织机构代码证.%s'%(f_ext) elif str(file_type) == '3': title = u'税务登记证.%s'%(f_ext) elif str(file_type) == '4': title = u'身份证正面.%s'%(f_ext) elif str(file_type) == '5': title = u'身份证反面.%s'%(f_ext) import imghdr imgType = imghdr.what(os.path.join(path,fname)) if imgType in['rgb','gif','pbm','pgm','ppm','tiff','rast','xbm','jpeg','bmp','png']: is_pic = 1 else: is_pic=0 if str(file_type) in ['1','2','3','4','5']: sql="SELECT ifnull(fname,'') FROM suppliers_pic WHERE cid = %s and file_type=%s"%(usr_id_gy,file_type) lT,iN=db.select(sql) if iN>0: L=list(lT[0]) fname1=L[0] path1=os.path.join(upload_path1,str(usr_id_gy)) if fname1!='': path1=os.path.join(path1,fname1) try: os.remove(path1) except: pass sql="delete from suppliers_pic WHERE cid=%s and file_type=%s"%(usr_id_gy,file_type) db.executesql(sql) sql = """insert into suppliers_pic (title,fname,file_size,cid,ctime,file_type,is_pic,random_no) values('%s','%s',%s,%s,now(),%s,%s,'%s'); """%(title,fname,myFile.size,usr_id_gy,file_type,is_pic,random_no) #print sql db.executesql(sql) if is_pic == 1: try: img = Image.open(os.path.join(path,fname)) x,y = img.size if x>500: x1 = 500 y1 = 500*y/x else: x1 = x y1 = y img = img.resize((x1, y1), Image.ANTIALIAS) path = os.path.join(path,'thumbnail') make_sub_path(path) #检查目录是否存在,如果不存在,生成目录 make_sub_path img.save(os.path.join(path,fname)) pic_url = os.path.join(front_url1,str(usr_id_gy),'thumbnail',fname) except: pic_url="" else: pic_url="" url = os.path.join(front_url1,str(usr_id_gy),fname) s = """{"files":[{ "error":false, "size":%s, "name":"%s", "thumbnail_url":"%s", "url":"%s", "delete_url":"%s/del_attach_file/?fname=%s" }]} """%(myFile.size,myFile.name,pic_url,url,data_url,fname) print s return HttpResponseJsonCORS(s) s = """ { "error": true } """ return HttpResponseJsonCORS(s)
def bizlicenseOcr(request): usr_id_gy = request.session.get('usr_id_gy','') or testid type = request.POST.get('type') or 1 sql = "select id,fname from suppliers_pic where cid = %s and file_type=%s"%(usr_id_gy,type) print sql rows,iN = db.select(sql) fname = rows[0][1] card_img = os.path.join(front_url,str(usr_id_gy),fname) sMsg = """{ "appid":"%s", "url":"%s" } """%(appid,card_img) url = "/ocr/bizlicense" print sMsg Sign = getSign() headers = {"Content-Type": "application/json","Authorization": Sign} conn = httplib.HTTPSConnection('recognition.image.myqcloud.com') conn.request('POST', '%s'%url,sMsg,headers) res = conn.getresponse() body = res.read() conn.close() ddata=json.loads(body) code = ddata.get("code") message = ddata.get("message") if code != 0: s = """ { "errcode": %s, "errmsg": "%s" } """%(code,message) return HttpResponseJsonCORS(s) data = ddata.get("data") items = data.get("items") for e in items: if ToGBK(e.get('item')) == ToGBK(u'注册号'): busi_code = e.get('itemstring') if ToGBK(e.get('item')) == ToGBK(u'法定代表人'): faren = e.get('itemstring') if ToGBK(e.get('item')) == ToGBK(u'公司名称'): sup_name = e.get('itemstring') if ToGBK(e.get('item')) == ToGBK(u'地址'): addr = e.get('itemstring') if ToGBK(e.get('item')) == ToGBK(u'主体类型'): sup_type = e.get('itemstring') if ToGBK(e.get('item')) == ToGBK(u'营业期限'): allotted_time = e.get('itemstring') s = """ { "errcode": %s, "errmsg": "%s", "busi_code": "%s", "faren": "%s", "sup_name": "%s", "addr": "%s", "sup_type": "%s", "allotted_time": "%s" } """%(code,message,busi_code,faren,sup_name,addr,sup_type,allotted_time) return HttpResponseJsonCORS(s)