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)
