def sync_58(db, step):
goods = db.query(
'select gds.id,gds.status,gds.goods_link_id from goods_distributor_shop gds, distributor_shop ds '
'where gds.distributor_shop_id=ds.id and gds.status <> "PREPARE" and gds.deleted=0 '
'and gds.distributor_goods_id <> "" and ds.distributor_id=%s',
options.distributor_id_wuba)
goods_dict = dict([(g.goods_link_id, g) for g in goods])
goods_slice = [goods[i:i + step] for i in range(0, len(goods), step)]
for slc in goods_slice:
wuba = Wuba('getstatus')
response = wuba.sync_fetch(
groupbuyIds=','.join(map(str, [s.goods_link_id for s in slc])))
# response = wuba.sync_fetch(groupbuyIds='34841', status='-1')
wuba.parse_response(response)
if not wuba.is_ok():
logging.error('sync goods status. wuba request error %s', response)
continue
for product in wuba.message.findall('productList/product'):
g = goods_dict[product.groupbuyIdThirdpart]
if product.status != 0 and g.status != 'OFF_SALE':
db.execute(
'update goods_distributor_shop set status="OFF_SALE", offsale_at=NOW(), onsale_at=NULL '
'where distributor_shop_id=%s and goods_link_id=%s',
options.shop_id_wuba, g.goods_link_id)
logging.info('sync goods status. offsale wuba item %s',
g.goods_link_id)
elif product.status == 0 and g.status != 'ON_SALE':
db.execute(
'update goods_distributor_shop set status="ON_SALE", onsale_at=NOW(), offsale_at=NULL '
'where distributor_shop_id=%s and goods_link_id=%s',
options.shop_id_wuba, g.goods_link_id)
logging.info('sync goods status. onsale wuba item %s',
g.goods_link_id)
def sync_58(db, step):
goods = db.query(
"select gds.id,gds.status,gds.goods_link_id from goods_distributor_shop gds, distributor_shop ds "
'where gds.distributor_shop_id=ds.id and gds.status <> "PREPARE" and gds.deleted=0 '
'and gds.distributor_goods_id <> "" and ds.distributor_id=%s',
options.distributor_id_wuba,
)
goods_dict = dict([(g.goods_link_id, g) for g in goods])
goods_slice = [goods[i : i + step] for i in range(0, len(goods), step)]
for slc in goods_slice:
wuba = Wuba("getstatus")
response = wuba.sync_fetch(groupbuyIds=",".join(map(str, [s.goods_link_id for s in slc])))
# response = wuba.sync_fetch(groupbuyIds='34841', status='-1')
wuba.parse_response(response)
if not wuba.is_ok():
logging.error("sync goods status. wuba request error %s", response)
continue
for product in wuba.message.findall("productList/product"):
g = goods_dict[product.groupbuyIdThirdpart]
if product.status != 0 and g.status != "OFF_SALE":
db.execute(
'update goods_distributor_shop set status="OFF_SALE", offsale_at=NOW(), onsale_at=NULL '
"where distributor_shop_id=%s and goods_link_id=%s",
options.shop_id_wuba,
g.goods_link_id,
)
logging.info("sync goods status. offsale wuba item %s", g.goods_link_id)
elif product.status == 0 and g.status != "ON_SALE":
db.execute(
'update goods_distributor_shop set status="ON_SALE", onsale_at=NOW(), offsale_at=NULL '
"where distributor_shop_id=%s and goods_link_id=%s",
options.shop_id_wuba,
g.goods_link_id,
)
logging.info("sync goods status. onsale wuba item %s", g.goods_link_id)
def partner_api_verify(db, coupon_sn):
# 查找券信息
coupon = db.get(
'select i.*, c.*, c.id cid from item i, item_coupon c where c.sn=%s and i.id=c.item_id',
coupon_sn)
coupon_sn = coupon_sn.encode('utf-8')
logging.info('被验证券sn：%s', coupon.sn)
if not coupon:
raise gen.Return(PropDict(ok=False, coupon_sn=coupon_sn, msg='券号不存在'))
distributor_order = db.get(
'select do.* from distributor_order do, orders o where do.id=o.distributor_order_id '
'and o.id=%s', coupon.order_id)
if coupon.distr_id == options.distributor_id_taobao:
# 淘宝验证
distributor_shop = db.get('select * from distributor_shop where id=%s',
distributor_order.distributor_shop_id)
order_message = json.loads(distributor_order.message,
object_hook=json_hook)
app_info = json.loads(distributor_shop.taobao_api_info,
object_hook=json_hook)
taobao = Taobao('taobao.vmarket.eticket.consume')
taobao.set_app_info(app_info.app_key, app_info.app_secret_key)
if app_info.app_key == options.taobao_kunran_app_key:
taobao.add_fields(codemerchant_id=options.taobao_kunran_id,
posid=options.taobao_coupon_posid)
taobao.set_session(app_info.merchant_session)
else:
taobao.set_session(app_info.session)
response = yield taobao(order_id=distributor_order.order_no,
verify_code=coupon_sn,
token=order_message.token,
consume_num=1)
logging.info('taobao coupon verify. coupon_sn:%s, result:%s',
coupon_sn, response.body)
taobao.parse_response(response.body)
if taobao.is_ok():
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn,
msg='验证成功'))
else:
raise gen.Return(
PropDict(ok=False,
coupon_sn=coupon_sn,
msg=taobao.error.msg.encode('utf-8')))
elif coupon.distr_id == options.distributor_id_jingdong:
# 京东验证
shop = db.get(
'select taobao_seller_id, taobao_api_info from distributor_shop where id=%s',
coupon.distr_shop_id)
api_info = json.loads(shop.taobao_api_info, object_hook=json_hook)
jingdong = Jingdong('verifyCode', str(shop.taobao_seller_id),
api_info.vender_key, api_info.secret_key)
response = yield jingdong(jd_order_id=distributor_order.order_no,
coupon_id=coupon.distr_sn,
coupon_pwd=coupon.distr_pwd)
logging.info('jingdong coupon verify. coupon_sn:%s, result:%s',
coupon_sn, response.body)
jingdong.parse_response(response.body)
if jingdong.is_ok():
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn,
msg='验证成功'))
else:
raise gen.Return(
PropDict(ok=False, coupon_sn=coupon_sn, msg='验证失败'))
elif coupon.distr_shop_id == options.shop_id_wuba:
# 58验证
wuba = Wuba('order.ticketcheck')
# todo 弥补之前的错误
if 211796 < coupon.cid < 219863:
oid = coupon.order_id
else:
oid = coupon.order_no
response = yield wuba(ticketId=coupon.cid,
orderId=oid,
ticketIdIndex=0)
logging.info('wuba coupon verify. coupon_sn:%s, result:%s', coupon_sn,
response.body)
wuba.parse_response(response.body)
if wuba.is_ok() and wuba.message.data.result == 1:
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn,
msg='验证成功'))
else:
raise gen.Return(
PropDict(ok=False, coupon_sn=coupon_sn, msg='验证失败'))
else:
logging.info('partner api verify skip. coupon_sn:%s', coupon_sn)
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn, msg='无需第三方验证'))
def partner_api_verify(db, coupon_sn):
# 查找券信息
coupon = db.get('select i.*, c.*, c.id cid from item i, item_coupon c where c.sn=%s and i.id=c.item_id', coupon_sn)
coupon_sn = coupon_sn.encode('utf-8')
logging.info('被验证券sn：%s', coupon.sn)
if not coupon:
raise gen.Return(PropDict(ok=False, coupon_sn=coupon_sn, msg='券号不存在'))
distributor_order = db.get('select do.* from distributor_order do, orders o where do.id=o.distributor_order_id '
'and o.id=%s', coupon.order_id)
if coupon.distr_id == options.distributor_id_taobao:
# 淘宝验证
distributor_shop = db.get('select * from distributor_shop where id=%s', distributor_order.distributor_shop_id)
order_message = json.loads(distributor_order.message, object_hook=json_hook)
app_info = json.loads(distributor_shop.taobao_api_info, object_hook=json_hook)
taobao = Taobao('taobao.vmarket.eticket.consume')
taobao.set_app_info(app_info.app_key, app_info.app_secret_key)
if app_info.app_key == options.taobao_kunran_app_key:
taobao.add_fields(codemerchant_id=options.taobao_kunran_id, posid=options.taobao_coupon_posid)
taobao.set_session(app_info.merchant_session)
else:
taobao.set_session(app_info.session)
response = yield taobao(order_id=distributor_order.order_no, verify_code=coupon_sn, token=order_message.token,
consume_num=1)
logging.info('taobao coupon verify. coupon_sn:%s, result:%s', coupon_sn, response.body)
taobao.parse_response(response.body)
if taobao.is_ok():
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn, msg='验证成功'))
else:
raise gen.Return(PropDict(ok=False, coupon_sn=coupon_sn, msg=taobao.error.msg.encode('utf-8')))
elif coupon.distr_id == options.distributor_id_jingdong:
# 京东验证
shop = db.get('select taobao_seller_id, taobao_api_info from distributor_shop where id=%s',
coupon.distr_shop_id)
api_info = json.loads(shop.taobao_api_info, object_hook=json_hook)
jingdong = Jingdong('verifyCode', str(shop.taobao_seller_id), api_info.vender_key, api_info.secret_key)
response = yield jingdong(jd_order_id=distributor_order.order_no, coupon_id=coupon.distr_sn,
coupon_pwd=coupon.distr_pwd)
logging.info('jingdong coupon verify. coupon_sn:%s, result:%s', coupon_sn, response.body)
jingdong.parse_response(response.body)
if jingdong.is_ok():
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn, msg='验证成功'))
else:
raise gen.Return(PropDict(ok=False, coupon_sn=coupon_sn, msg='验证失败'))
elif coupon.distr_shop_id == options.shop_id_wuba:
# 58验证
wuba = Wuba('order.ticketcheck')
# todo 弥补之前的错误
if 211796 < coupon.cid < 219863:
oid = coupon.order_id
else:
oid = coupon.order_no
response = yield wuba(ticketId=coupon.cid, orderId=oid, ticketIdIndex=0)
logging.info('wuba coupon verify. coupon_sn:%s, result:%s', coupon_sn, response.body)
wuba.parse_response(response.body)
if wuba.is_ok() and wuba.message.data.result == 1:
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn, msg='验证成功'))
else:
raise gen.Return(PropDict(ok=False, coupon_sn=coupon_sn, msg='验证失败'))
else:
logging.info('partner api verify skip. coupon_sn:%s', coupon_sn)
raise gen.Return(PropDict(ok=True, coupon_sn=coupon_sn, msg='无需第三方验证'))
