def get(self):
self.get_paras_dict()
qcategory, qcolor, qstyle = self.qdict.get('category', ''), self.qdict.get('color', ''), self.qdict.get('style', '')
order, page = self.qdict.get('order','Fcreate_time'), self.qdict.get('page',1)
work_service = WeddingCompanyWorkService(self.db)
try:
query = work_service.query_work_and_company_name(**self.qdict)
works = self.get_page_data(query,page_size=PAGE_SIZE,page=page)
lst_works = works.result.all()
self.echo('view/weddingcompany/work_list.html',{
'page_html':works.render_admin_html_web(),
'works':lst_works,
'works_count': works.total,
'qcategory': qcategory,
'qcolor': qcolor,
'qstyle': qstyle,
'order':order,
'category_info': _WEDDING_COMPANY_CATEGORY,
'color_info': _WEDDING_COMPANY_COLOR,
'style_info': _WEDDING_COMPANY_STYLE
})
except Exception,e:
self.captureException(*sys.exc_info())
def get(self, work_id):
try:
work_service, company_service = WeddingCompanyWorkService(self.db), CompanyServices(self.db)
work, images = work_service.query_work(work_id=work_id).scalar(), work_service.query_work_images(work_id=work_id).all()
recent_works = work_service.query_work(merchant_id=work.Fmerchant_id,order_by='Fcreate_time').limit(3).offset(0)
company = company_service.get_company_by_uid(work.Fmerchant_id) #公司信息
company_gift = company_service.get_gift(work.Fmerchant_id,1).scalar() #到店礼
order_gift = company_service.get_gift(work.Fmerchant_id,2).scalar() #y优惠
#1.商户订单,2.套系订单 3.作品订单
order_url = '/order/create/3/'+str(work_id)+'/'+str(company.Fuser_id)
category = _WEDDING_COMPANY_CATEGORY.get(work.Fcategory) if _WEDDING_COMPANY_CATEGORY.get(work.Fcategory) else work.Fcategory
color = _WEDDING_COMPANY_COLOR.get(work.Fcolor) if _WEDDING_COMPANY_COLOR.get(work.Fcolor) else work.Fcolor
style = _WEDDING_COMPANY_STYLE.get(work.Fstyle) if _WEDDING_COMPANY_STYLE.get(work.Fstyle) else work.Fstyle
self.echo('view/weddingcompany/work_detail.html',{
'work':work,
'images':images,
'recent_works':recent_works,
'company':company,
'order_gift':order_gift,
'company_gift':company_gift,
'order_url':order_url,
'category': category,
'color': color,
'style': style
})
except Exception,e:
self.captureException(*sys.exc_info())
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, *args, **kwargs):
try:
work_service = WeddingCompanyWorkService(self.db)
work = work_service.query_work(
merchant_id=self.get_current_user().get('Fmerchant_id'))
self.echo(
'crm/weddingcompany/work_list.html', {
'work': work,
'category_info': _WEDDING_COMPANY_CATEGORY,
'color_info': _WEDDING_COMPANY_COLOR,
'style_info': _WEDDING_COMPANY_STYLE
})
except Exception, e:
self.captureException(*sys.exc_info())
def post(self, *args, **kwargs):
self.get_paras_dict()
self.qdict['merchant_id'], self.qdict[
'user_id'] = self.current_user.get(
'Fmerchant_id'), self.current_user.get('Fid')
try:
series_service = WeddingCompanySeriesService(self.db)
series_service.add_series(**self.qdict)
#更新公司最低价与最高价
company_service = CompanyServices(self.db)
company_service.update_range_price(
self.current_user.get('Fmerchant_id'),
WeddingCompanySeriesService(self.db),
WeddingCompanyWorkService(self.db))
#删除套系数量缓存
self.delete_package_count(self.current_user.get('Fmerchant_id'))
self.delete_essence()
self.write(ujson.dumps({'stat': 'ok', 'info': '提交成功'}))
except Exception, e:
self.write(
ujson.dumps({
'stat': 'error',
'info': '错误:' + e.message
}))
self.captureException(*sys.exc_info())
def post(self, work_id):
try:
work_service = WeddingCompanyWorkService()
work_service.set_db(self.db)
work_service.delete_work(work_id)
#更新公司最低价与最高价
company_service = CompanyServices(self.db)
company_service.update_range_price(
self.current_user.get('Fmerchant_id'),
WeddingCompanySeriesService(self.db),
WeddingCompanyWorkService(self.db))
#删除套系数量缓存
self.delete_product_count(self.current_user.get('Fmerchant_id'))
self.write(ujson.dumps({'stat': 'ok', 'info': '提交成功'}))
except Exception, e:
self.write(
ujson.dumps({
'stat': 'error',
'info': '错误:' + e.message
}))
self.captureException(*sys.exc_info())
def get(self, img_id):
try:
work_service, album_service = WeddingCompanyWorkService(
self.db), PhotosServices(self.db)
#删除作品图片
work_service.delete_work_images(img_id=img_id)
#删除相册图片
album_service.delete_photo(photo_id=img_id)
self.write(ujson.dumps({'stat': 'ok', 'info': '提交成功'}))
except Exception, e:
self.write(
ujson.dumps({
'stat': 'error',
'info': '错误:' + e.message
}))
self.captureException(*sys.exc_info())
def get_count(self,type,merchant_id):
'''
todo:获取
:param type:
:param merchant_id:
:return:
'''
if type=='product':
count = self.get_product_count(merchant_id, WeddingCompanyWorkService(self.db))
elif type=='package':
count = self.get_package_count(merchant_id, WeddingCompanySeriesService(self.db))
return count
def get(self, work_id):
try:
work_service = WeddingCompanyWorkService()
work_service.set_db(self.db)
work = work_service.query_work(work_id=work_id).scalar()
images = work_service.query_work_images(work_id=work_id).all()
self.echo(
'crm/weddingcompany/work_edit.html', {
'work': work,
'images': images,
'category_info': _WEDDING_COMPANY_CATEGORY,
'color_info': _WEDDING_COMPANY_COLOR,
'style_info': _WEDDING_COMPANY_STYLE
})
self.write(ujson.dumps({'stat': 'ok', 'info': '提交成功'}))
except Exception, e:
self.write(
ujson.dumps({
'stat': 'error',
'info': '错误:' + e.message
}))
self.captureException(*sys.exc_info())