def express_auto_push(db, redis, message_raw, distr_shop_id): express_info = json.loads(message_raw, object_hook=json_hook) logging.info('taobao_express_update consumer pop taobao tid =%s ' % express_info.tid) app_info = json.loads(db.get( 'select taobao_api_info from distributor_shop where id = %s', distr_shop_id).taobao_api_info, object_hook=json_hook) express_company = Taobao('taobao.logistics.offline.send') express_company.set_app_info(app_info.app_key, app_info.app_secret_key) express_company.set_session(app_info.session) response = express_company.sync_fetch(**express_info) express_company.parse_response(response) if express_company.is_ok(): logging.info('outer order express info update success. order %s', express_info.tid) redis.lrem(options.queue_taobao_express_processing, 0, express_info) else: logging.error('outer order express info update failure. order %s', express_info.tid)
def sync(db, products): for product in products: if not product.taobao_api_info: logging.error('sync_ktv_sku: invalid taobao_api_info. product_id: %s', product.product_id) continue taobao_api_info = json.loads(product.taobao_api_info, object_hook=json_hook) iid = product.distributor_goods_id taobao = Taobao('taobao.item.get') taobao.set_app_info(taobao_api_info.app_key, taobao_api_info.app_secret_key) response = taobao.sync_fetch(fields='sku', num_iid=iid) taobao.parse_response(response) if not taobao.is_ok(): logging.error('sync_ktv_sku: get taobao item info failed. goods_distributor_shop_id: %s', product.gds_id) if taobao.error.sub_code == 'isv.item-get-service-error:ITEM_NOT_FOUND': # 商品在淘宝不存在,于是在我们系统中设置为逻辑删除 logging.error('sync_ktv_sku: product not exist. goods_distributor_shop_id: %s', product.gds_id) db.execute('update goods_distributor_shop set deleted=1 where id=%s', product.gds_id) continue local_sku_list = build_taobao_sku(db, product.shop_id, product.product_id) remote_sku_list = [] invalid_skus = [] if 'skus' in taobao.message.item and 'sku' in taobao.message.item.skus: for sku in taobao.message.item.skus.sku: tmp = sku_split_re.split(sku.properties_name) # 例: 27426219:3442354:包厢房型:小包;-1:-1:欢唱时间:17点至20点;-2:-45:日期:12月11日(周三) tb_sku = TaobaoSku( room_type='', dt=None, price=Decimal(sku.price), quantity=sku.quantity, start_time=0, duration=0, sku_id=sku.sku_id ) if len(tmp) != 12: invalid_skus.append(tb_sku) continue tb_sku.parse_taobao_property(tmp[3].encode('utf-8'), tmp[7].encode('utf-8'), tmp[11].encode('utf-8')) remote_sku_list.append(tb_sku) add_sku_list, delete_sku_list, update_price_sku_list, update_quantity_sku_list = diff_local_and_remote( local_sku_list, remote_sku_list ) delete_sku_list.extend(invalid_skus) remote_price_set = set([sku.price for sku in remote_sku_list]) for sku in delete_sku_list: if sku.price in remote_price_set: remote_price_set.remove(sku.price) taobao = Taobao('taobao.item.sku.delete') taobao.set_app_info(taobao_api_info.app_key, taobao_api_info.app_secret_key) taobao.set_session(taobao_api_info.session) response = taobao.sync_fetch( num_iid=iid, properties='%s;$欢唱时间:%s;$日期:%s' % (sku.room_key, sku.human_time_range, sku.human_date), item_price=str(min(remote_price_set) if remote_price_set else sku.price) ) taobao.parse_response(response) logging.info('sync_ktv_sku: %s DELETE[%s] %s %s', product.gds_id, 'OK' if taobao.is_ok() else 'FAIL', sku, '' if taobao.is_ok() else taobao.error.sub_code.encode('utf-8')) for sku in add_sku_list: remote_price_set.add(sku.price) taobao = Taobao('taobao.item.sku.add') taobao.set_app_info(taobao_api_info.app_key, taobao_api_info.app_secret_key) taobao.set_session(taobao_api_info.session) end = sku.start_time + sku.duration end = end - 24 if end >= 24 else end response = taobao.sync_fetch( num_iid=iid, properties='%s;$欢唱时间:%s;$日期:%s' % (sku.room_key, sku.human_time_range, sku.human_date), quantity=sku.quantity, price=sku.price, outer_id=sku.room_type+sku.date.strftime('%Y%m%d')+str(sku.start_time*100+end), item_price=str(min(remote_price_set)) ) taobao.parse_response(response) logging.info('sync_ktv_sku: %s ADD[%s] %s %s', product.gds_id, 'OK' if taobao.is_ok() else 'FAIL', sku, '' if taobao.is_ok() else taobao.error.sub_code.encode('utf-8')) if update_quantity_sku_list: taobao = Taobao('taobao.skus.quantity.update') taobao.set_app_info(taobao_api_info.app_key, taobao_api_info.app_secret_key) taobao.set_session(taobao_api_info.session) response = taobao.sync_fetch( num_iid=iid, skuid_quantities=';'.join(['%s:%s' % (sku.sku_id, sku.quantity) for sku in update_quantity_sku_list]) ) taobao.parse_response(response) logging.info('sync_ktv_sku: UPDATE_QUANTITY[%s] %s', 'OK' if taobao.is_ok() else 'FAIL', taobao.get_field('skuid_quantities')) for sku in update_price_sku_list: taobao = Taobao('taobao.item.sku.price.update') taobao.set_app_info(taobao_api_info.app_key, taobao_api_info.app_secret_key) taobao.set_session(taobao_api_info.session) response = taobao.sync_fetch( num_iid=iid, properties='%s;$欢唱时间:%s;$日期:%s' % (sku.room_key, sku.human_time_range, sku.human_date), quantity=sku.quantity, price=sku.price, item_price=sku.price, # 此处不好确定此时的该商品所有SKU的最低价格,所以就填了当前价格 ) taobao.parse_response(response) logging.info('sync_ktv_sku: %s UPDATE_PRICE[%s] %s', product.gds_id, 'OK' if taobao.is_ok() else 'FAIL', sku, '' if taobao.is_ok() else taobao.error.sub_code.encode('utf-8'))
def taobao_order(db, redis, distributor_order_id, message_raw): """ 处理淘宝的分销订单队列 :param db :param redis :param distributor_order_id: 分销订单id :param message_raw: redis 队列元素值 :type db:torndb.Connection :type redis:redis.client.StrictRedis :type distributor_order_id: int """ distributor_order = db.get('select * from distributor_order where id=%s', distributor_order_id) params = json.loads(distributor_order.message, object_hook=json_hook) shop = db.get('select * from distributor_shop where taobao_seller_id=%s', params.taobao_sid) api_info = json.loads(shop.taobao_api_info, object_hook=json_hook) if not distributor_order.order_id: # 如果还没生成一百券订单 goods_link_id = int(params.outer_iid) # 找到关联的商品 goods_info = db.get('select g.* from goods g, goods_distributor_shop gds ' 'where g.id = gds.goods_id and distributor_shop_id=%s and goods_link_id=%s', shop.id, goods_link_id) if not goods_info and goods_link_id < 20000: goods_info = db.get('select g.* from goods g where g.type="E" and g.id=%s', goods_link_id) if not goods_info: logging.error('taobao order consume failed: goods not found. link_id: %s', goods_link_id) return taobao = Taobao('taobao.trade.get') taobao.set_app_info(api_info.app_key, api_info.app_secret_key) taobao.set_session(api_info.session) response = taobao.sync_fetch(tid=distributor_order.order_no, fields='total_fee,payment,orders.payment,orders.num,' 'orders.sku_properties_name,orders.price') taobao.parse_response(response) order_payment = Decimal(taobao.message.trade.payment) # 创建订单 order_id, order_no = new_distributor_order(db, shop.id, Decimal(taobao.message.trade.total_fee), order_payment, params.mobile) result = new_distributor_item(db, order_id, order_no, order_payment / int(params.num), int(params.num), goods_info, params.mobile, shop.id, params.num_iid, None, False) if not result.ok: logging.error('taobao order consume failed. %s', result.msg) return else: db.execute('update orders set distributor_order_id=%s where id = %s', distributor_order_id, result.order_id) db.execute('update distributor_order set order_id=%s where id=%s', result.order_id, distributor_order_id) ktv_order_result = create_ktv_order(db, order_id, params) else: order_id = distributor_order.order_id ktv_order_result = [] coupons = db.query('select c.sn as coupon_sn from item i, item_coupon c where i.id=c.item_id and i.order_id=%s', order_id) # 告诉淘宝我们已发货 taobao = Taobao('taobao.vmarket.eticket.send') taobao.set_app_info(api_info.app_key, api_info.app_secret_key) if api_info.app_key == options.taobao_kunran_app_key: # 如果是码商,要加上码商的信息 taobao.add_field('codemerchant_id', options.taobao_kunran_id) taobao.set_session(api_info.merchant_session) else: taobao.set_session(api_info.session) response = taobao.sync_fetch(order_id=params.order_id, token=params.token, verify_codes=','.join(['%s:1' % item.coupon_sn for item in coupons])) logging.info('tell taobao coupon send response: %s', response) taobao.parse_response(response) if taobao.is_ok(): logging.info('taobao order complete. distributor_order_id: %s', distributor_order_id) all_order_items = db.query('select * from order_item where order_id=%s', order_id) for item in all_order_items: CouponSMSMessage(db, redis, order_item=item).remark('淘宝订单短信发送').send() redis.lrem(options.queue_distributor_order_processing, 0, message_raw) #只要ktv预订时间有,就给门店经理发送ktv预订的包厢信息 for ktv_info in ktv_order_result: sku = ktv_info['sku'] phone_numbers = ktv_info['manager_mobile'] for phone in (phone_numbers.split(',') if phone_numbers else []): content = str(sku.date) + ktv_info['shop_name'] + '预订【' + str(params.mobile) + \ sku.room_name + " (" + str(params.num) + "间)" + sku.human_time_range + "】" #给经理发送短信告知预订信息 logging.info('send message to manager,phone:%s,content:%s', phone, content) SMSMessage(content, phone).send(redis) else: logging.error('tell taobao coupon send failed: %s', taobao.error)