def post(self):
"""编辑团购和商户信息"""
product_id = self.get_argument('product_id')
product = self.db.get('select * from goods_distributor_shop where id = %s', product_id)
params = dict([(name, self.get_argument(name).encode('utf-8')) for name in self.request.arguments])
params.pop("product_id")
params.pop("method")
params.pop("_xsrf")
method = self.get_argument("method")
if 'endTime' in self.request.arguments:
end_time = params['endTime']
request_params = getattr(self, method)(params, str(product.goods_link_id))
wb = Wuba(method)
response = yield wb.fetch(**request_params)
wb.parse_response(response.body)
if wb.is_ok():
#券延期成功之后再延期团购结束日期
if method == 'delay':
params.pop("deadline")
request_params = {'groupbuyId': product.goods_link_id, 'endTime': end_time}
wb = Wuba('editgroupbuyinfo')
response = yield wb.fetch(**request_params)
wb.parse_response(response.body)
if wb.is_ok():
logging.info("延长团购结束日期成功！商品ID=%s", product_id)
self.render('goods/distributor/wuba/result.html', ok=True, title='编辑成功',
explain='<a href="/goods/distributor?shop_id=%s">继续上传58商品</a>' % options.shop_id_wuba)
else:
self.render('goods/distributor/wuba/result.html', ok=False, title='修改出错', explain=wb.message.msg)
def post(self):
"""推送商品"""
arg = lambda k: self.get_argument(k).encode('utf-8')
goods_id = self.get_argument('goods_id')
dg = alloc_distributor_goods(self.db, goods_id, options.shop_id_wuba)
params = dict([(name, self.get_argument(name).encode('utf-8')) for name in self.request.arguments])
params.pop("goods_id")
params.pop("_xsrf")
params['groupbuyId'] = dg.goods_link_id
prod_model_json = dict(prodmodcatename=arg('prodName'), prodprice=arg('prodPrice'),
groupprice=arg('groupPrice'), prodcode='', count=arg('saleMaxNum'))
cityIds = self.request.arguments['cityIds']
ids = []
for cityId in cityIds:
ids.append(int(cityId))
params['cityIds'] = str(ids)
if options.app_mode == 'dev':
params['prodImg'] = 'http://www.itlearner.com/google_commonweal_ad/images/sun/300px.jpg'
params['prodModelJson'] = '{%s}' % json_dumps(prod_model_json)
#商家信息参数
shop_ids = list(arg('shop_ids').split(","))
# 将团购信息参数中的特定key值转移出来，构建商家信息参数
partner_keys = {"partnerId", "title", "shortTitle", "telephone", "webUrl", "busline", "mapImg",
"mapServiceId", "mapUrl", "latitude", "longitude", "address", "circleId"}
partners = []
for shop_id in shop_ids:
partner = {}
for key in partner_keys:
partner[key] = params.pop(key + "_" + shop_id)
partners.append(partner)
request_params = {'groupbuyInfo': params, 'partners': partners}
wb = Wuba('addgroupbuy')
response = yield wb.fetch(**request_params)
wb.parse_response(response.body)
if wb.is_ok():
off_sale_at = datetime.strptime(params['endTime'], '%Y-%m-%d %H:%M:%S')
expire_at = ceiling(datetime.strptime(params['deadline'], '%Y-%m-%d %H:%M:%S'), today=True)
self.db.execute('update goods_distributor_shop set status="PENDING", created_by=%s, created_at=NOW(), '
'offsale_at = %s, expire_at = %s, distributor_goods_id = %s '
'where goods_id=%s and distributor_shop_id=%s and goods_link_id=%s',
self.current_user.name, off_sale_at, expire_at,
wb.message.data.groupbuyId58, goods_id, options.shop_id_wuba, dg.goods_link_id)
self.render('goods/distributor/wuba/result.html', ok=True, title='上传成功',
explain='<a href="http://t.58.com/sh/%s" target="_blank">去58查看商品</a><br/><a href="/goods/distributor?shop=wb">'
'继续上传58商品</a>' % wb.message.data.groupbuyId58)
else:
self.render('goods/distributor/wuba/result.html', ok=False, title='上传出错', explain=wb.message.msg)
def sync_stock():
sql = """
select g.id, gds.distributor_shop_id, gds.distributor_goods_id, gds.goods_link_id, g.stock, ds.taobao_api_info,
ds.distributor_id
from goods g, distributor_shop ds, goods_distributor_shop gds where g.id = gds.goods_id
and gds.distributor_shop_id = ds.id
and g.generate_type = 'IMPORT' and gds.deleted = '0'
and gds.distributor_shop_id in (%s, %s, %s, %s) """
params = [options.shop_id_taobao, options.shop_id_tmall, options.shop_id_jingdong, options.shop_id_wuba]
sync_list = db.query(sql, *params)
for item in sync_list:
if not item.distributor_goods_id or item.distributor_goods_id == '0':
logging.error('商品找不到对应的外部id.商品id: %s', item.id)
continue
if item.distributor_shop_id in (options.shop_id_taobao, options.shop_id_tmall):
if not item.taobao_api_info:
logging.error('商品没有对应的taobao_api_info.商品id: %s', item.id)
continue
app_info = json.loads(item.taobao_api_info, object_hook=json_hook)
# 获取店铺类型
request = Taobao('taobao.item.quantity.update')
request.set_app_info(app_info.app_key, app_info.app_secret_key)
request.set_session(app_info.session)
args = {
'num_iid': item.distributor_goods_id,
'quantity': item.stock,
'type': 1
}
response = yield request(**args)
request.parse_response(response.body)
if request.is_ok():
logging.info('商品id: %s在 %s上更新库存成功，更新为%s', item.id,
{options.shop_id_tmall: '天猫', options.shop_id_taobao: '淘宝'}.get(item.distributor_shop_id),
item.stock)
else:
logging.info('商品id: %s在 %s上更新库存失败', item.id,
{options.shop_id_tmall: '天猫', options.shop_id_taobao: '淘宝'}.get(item.distributor_shop_id))
elif item.distributor_id == options.distributor_id_jingdong:
args = {
'vender_team_id': item.goods_link_id,
'jd_team_id': item.distributor_goods_id,
'max_number': item.stock
}
shop = db.get('select taobao_seller_id, taobao_api_info from distributor_shop where id=%s',
item.distributor_shop_id)
api_info = json.loads(shop.taobao_api_info, object_hook=json_hook)
jd_push = Jingdong('updateMaxNumber', str(shop.taobao_seller_id), api_info.vender_key, api_info.secret_key)
response = yield jd_push.fetch(**args)
jd_push.parse_response(response.body)
if jd_push.is_ok():
logging.info('商品id: %s在京东上更新库存成功，更新为%s', item.id, item.stock)
else:
logging.info('商品id: %s在京东上更新库存失败', item.id)
elif item.distributor_shop_id == options.shop_id_wuba:
args = {
'groupbuyId': item.goods_link_id,
'num': item.stock
}
wuba = Wuba('changeinventory')
response = yield wuba.fetch(**args)
wuba.parse_response(response.body)
if wuba.is_ok():
logging.info('商品id: %s在58上更新库存成功，更新为%s', item.id, item.stock)
else:
logging.info('商品id: %s在58上更新库存失败', item.id)
else:
pass
