def get(self,company_id,*args,**kwargs): company_service = CompanyServices(self.db) user_services = UserServices(self.db) company = company_service.get_company_by_id(company_id) user = user_services.get_user_by_id(company.Fuser_id) self.echo('ops/company/company_edit.html',{'company':company,'user':user})
def post(self, company_id): rspDic = {} rspDic["stat"] = "ok" #返回页面的字典,ok,fail rspDic["msg"] = "" if not company_id: rspDic["stat"] = "fail" rspDic["msg"] = u"公司不存在" return self.write(json.dumps(rspDic)) try: company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) if company.Fmenu_codes: rspDic["stat"] = "fail" rspDic["msg"] = u"解除绑定前,请先解除菜单绑定!" return self.write(json.dumps(rspDic)) dic_app = {} dic_app['Fapp_url'] = '' dic_app['Fapp_token'] = '' dic_app['Fapp_id'] = '' dic_app['Fapp_secret'] = '' company_db = CompanyServices(self.db) company_db.update_company_by_id(int(company_id), **dic_app) except Exception, e: rspDic["stat"] = "fail" rspDic["msg"] = u"微信删除失败"
def get(self, company_id): if not company_id: return self.echo('view/login/404.html', layout='') company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) app_url = '' if company.Fapp_url: app_url = company.Fapp_url else: app_url = setting.WX_APP_URL + '/' + str( company.Fid) #使用公司id作为app url的关键参数 company_db.update_company_by_id(company.Fid, Fapp_url=app_url) app_token = '' if company.Fapp_token: app_token = company.Fapp_token else: uuid_str = uuid.uuid3( uuid.NAMESPACE_DNS, str(company.Fid) + str(company.Fuser_id)) #使用id+user_id生产uuid作为token app_token = str(uuid_str) app_token = app_token.replace('-', '') company_db.update_company_by_id(company.Fid, Fapp_token=app_token) self.echo('ops/weixin/detail.html', { 'company': company, 'app_url': app_url, 'app_token': app_token, })
def get(self, merchant_id): try: company_service, series_service = CompanyServices(self.db), WeddingCompanySeriesService(self.db) work_service = WeddingCompanyWorkService(self.db) company = company_service.get_company_by_id(merchant_id) company_gift = company_service.get_gift(company.Fuser_id,1).scalar() #到店礼 order_gift = company_service.get_gift(company.Fuser_id,2).scalar() #订单礼 works = work_service.query_work(order_by='Fcreate_time',merchant_id=company.Fuser_id) work_count = works.count() works = works.limit(6).offset(0) series = series_service.query_series(order_by='Fcreate_time',merchant_id=company.Fuser_id) series_count = series.count() recommend_series = series.limit(3).offset(0) series = series.limit(6).offset(0) #1.商户订单,2.套系订单 3.作品订单 order_url = '/order/create/1/'+str(company.Fuser_id)+'/'+str(company.Fuser_id) self.echo('view/weddingcompany/merchant_detail.html',{ 'company':company, 'order_gift':order_gift, 'company_gift':company_gift, 'works':works, 'series':series, 'series_count':series_count, 'work_count':work_count, 'recommend_series':recommend_series, 'merchant_id':company.Fuser_id, 'order_url':order_url }) except Exception,e: self.captureException(*sys.exc_info())
def get(self, company_id): if not company_id: return self.echo('view/login/404.html', layout='') company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) self.echo('ops/weixin/delete.html', { 'company': company, })
def get(self, company_id=None): try: #获取输入参数 query = self.request.query qdict = urlparse.parse_qs(query) print('AccessHandler get() qdict=' + str(qdict)) if not qdict: print('qdict is null.') return if not company_id: print('company_id is null.') return #获取token company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) if not company: print('no user!') return #校验 isFromWeixin = self.checkSignature(company.Fapp_token, **qdict) if isFromWeixin: #匹配成功 print('weixin check ok!') if qdict.has_key('echostr'): self.write(qdict.get('echostr')[0]) else: self.write('') else: print('weixin check error!') self.write('[ERROR]not Weixin!') except Exception, e: e = sys.exc_info()[0](traceback.format_exc()) print(e) print('weixin access error!') return
def get(self, company_id, menu_code): if not company_id: return self.echo('view/login/404.html', layout='') error = u'' company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) wxService = WxService(self.db) #获取当前menu code对应的菜单名称 company_menu_name = '' if company.Fmenu_codes: for code in company.Fmenu_codes.split(','): if len(code) > 0: company_menu_name = company_menu_name + ',' + wxService.query_name_by_code( code) company_menu_name = company_menu_name.strip(',') #查询当前所有菜单 menus = wxService.query_menus() try: wxService = WxService(self.db) error = u'' company_db = CompanyServices(self.db) query = company_db.get_companys() query = query.filter(Company.Fid == int(company_id)) company = query.scalar() menu_codes = '' if company.Fmenu_codes.find(menu_code) > -1: #已绑定 menu_codes = company.Fmenu_codes.replace(menu_code, '') else: menu_codes = company.Fmenu_codes #整理code顺序 menu_codes_order = '' menus = wxService.query_menus() for menu in menus: if menu_codes.find(menu.code) > -1: menu_codes_order = menu_codes_order + ',' + menu.code menu_codes = menu_codes_order.strip(',') #更新公众号菜单 menuManager = MenuManager() dic_accessToken = menuManager.getAccessToken( company.Fapp_id, company.Fapp_secret) if len(menu_codes) == 0: # menuManager.delMenu(dic_accessToken.get("access_token")) else: menus = wxService.query_menus() all_menu_str = wx_util.getMenuStr(menus, menu_codes, company.Fuser_id) print("all_menu_str=" + all_menu_str) result = menuManager.refreshMenu( dic_accessToken.get("access_token"), all_menu_str) if result <> 'ok': error = u'绑定失败' raise error #更新menu_codes if menu_codes <> company.Fmenu_codes: company_db.update_company_by_id(int(company_id), Fmenu_codes=menu_codes) #获取menu code对应的菜单名称 company_menu_name = '' if menu_codes: for code in menu_codes.split(','): if len(code) > 0: company_menu_name = company_menu_name + ',' + wxService.query_name_by_code( code) company_menu_name = company_menu_name.strip(',') else: company.Fmenu_codes = '' #查询所有菜单 wxService = WxService(self.db) menus = wxService.query_menus() for menu in menus: if menu.type == 'view': menu.url = setting.WX_APP_URL + menu.url if menu.is_common == 0: #url中存在参数 menu.url = menu.url % (company.Fuser_id) self.echo( 'ops/weixin/menu.html', { 'error': error, 'company': company, 'company_menu_name': company_menu_name, 'menus': menus, 'page_html': '', }) except Exception, e: e = sys.exc_info()[0](traceback.format_exc()) print(e) self.echo( 'ops/weixin/menu.html', { 'error': error, 'company': company, 'company_menu_name': company_menu_name, 'menus': menus, 'page_html': '', })
def post(self, company_id=None): #获取输入参数 print('AccessHandler post()') query = self.request.query qdict = urlparse.parse_qs(query) print('AccessHandler post() qdict=' + str(qdict)) if company_id: print('company_id=' + str(company_id)) #获取token company_db = CompanyServices(self.db) company = company_db.get_company_by_id(int(company_id)) if not company: print('no company!') return #校验 isFromWeixin = self.checkSignature(company.Fapp_token, **qdict) if not isFromWeixin: #匹配不成功 print('not match!') self.write('') return else: print('no company id') self.write('') return nonce = qdict.get('nonce')[0] request_data = str(self.request.body) print('request_data=' + request_data) request_xml = etree.fromstring(request_data) #进行XML解析 msgType = request_xml.find("MsgType").text fromUser = request_xml.find("FromUserName").text toUser = request_xml.find("ToUserName").text result_msg = '' print('msgType=' + msgType) if msgType == 'event': #事件 event = request_xml.find("Event").text #获得事件内容 print('event=' + event) if event == 'subscribe': #关注事件 result_msg = WX_MESSAGE.REPLY_TEXT % ( fromUser, toUser, int(time.time()), unicode('欢迎关注%s!' % (company.Fcompany_name))) elif event == 'unsubscribe': #取消关注事件 result_msg = '' #???后台清理 elif event == 'CLICK': #菜单点击事件 eventKey = request_xml.find("EventKey").text #获得事件KEY值 print('eventKey=' + eventKey) if eventKey == Constant.EVENT_CONTACT: #联系我们 #读取联系信息 msgx_content = '' if company.Fcompany_name: msgx_content = msgx_content + u'名称:' + company.Fcompany_name + '\n' if company.Faddress: msgx_content = msgx_content + u'地址:' + company.Faddress + '\n' if company.Fcontact: msgx_content = msgx_content + u'联系人:' + company.Fcontact + '\n' if company.Fphone: msgx_content = msgx_content + u'电话:' + company.Fphone + '\n' if company.Fqq: msgx_content = msgx_content + u'QQ:' + company.Fqq + '\n' if company.Fmail: msgx_content = msgx_content + u'邮箱:' + company.Fmail result_msg = WX_MESSAGE.REPLY_TEXT % ( fromUser, toUser, int(time.time()), msgx_content) elif event == 'VIEW': #取消关注事件 eventKey = request_xml.find("EventKey").text #获得事件KEY值 print('VIEW url=' + eventKey) #result_msg = WX_MESSAGE.REPLY_TEXT %(fromUser, toUser, int(time.time()), u'未绑定用户,请在菜单中进行绑定.') result_msg = nonce else: content = request_xml.find("Content").text #获得用户所输入的内容 result_msg = WX_MESSAGE.REPLY_TEXT % ( fromUser, toUser, int( time.time()), unicode('欢迎关注%s!' % (company.Fcompany_name))) self.write(result_msg)