def GET(self): name_id = web.input()['name_id'] path = web.input()['href'] if not logged(name_id): return render.jmp_parameter('先登录', "/login?url=/download/papers") user = Model.admin_personnel_info_Get(name_id=name_id)[0] paper = Model.admin_papers_manager_Get(href=path)[0] if int(user['credit']) < int(paper['value']): return render.jmp_parameter('积分不够', '/download/papers') downlo = download(path).next() if downlo: user['credit'] = int(user['credit']) - int(paper['value']) if "_id" in user: user.pop("_id") Model.admin_personnel_info_Edit(user) return downlo
def GET(self): name_id=web.input()['name_id'] path=web.input()['href'] if not logged(name_id): return render.jmp_parameter('先登录',"/login?url=/download/papers") user=Model.admin_personnel_info_Get(name_id=name_id)[0] paper=Model.admin_papers_manager_Get(href=path)[0] if int(user['credit']) < int(paper['value']): return render.jmp_parameter('积分不够','/download/papers') downlo= download(path).next() if downlo: user['credit']=int(user['credit']) - int(paper['value']) if "_id" in user:user.pop("_id") Model.admin_personnel_info_Edit(user) return downlo
def GET(self): meeting=Model.admin_meeting_Qurery(_id=web.input()['_id'])[0] participants=Model.admin_meeting_Qurery(meetingID=web.input()['_id']) count = len(participants) filename = meeting['title']+'.xls' wbk =xlwt.Workbook() get_cwd=lambda: os.path.normpath(os.getcwd()) cwd = get_cwd() output_path='/static/temp' sheet =wbk.add_sheet('sheet 1') path=cwd+output_path+'/'+filename alist2=['p_name','p_linkman','p_tel','p_mobile','p_fax','p_email','p_province','p_city','p_addr','p_zip','p_homepage','p_qq','p_job','p_detail'] alist1=['公司名称','联系人','电话','手机','传真','Email','省份','城市','地址','邮编','网址','QQ','职务','与会要求'] for i in range(0,14): sheet.write(0,i,u'%s'%alist1[i]) for i in range(0,count): for j in range(0,14): sheet.write(i+1,j,u'%s'%participants[i][alist2[j]]) wbk.save("%s" %path) downlo= download(path).next() os.remove(path) if downlo: return downlo