Exemple #1
0
def get_taobao_taoke(q):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.taobaoke.items.get'
    fields = 'num_iid,title,price,nick,click_url,commission,commission_rate,commission_num,commission_volume,shop_click_url,seller_credit_score,item_location,volume'
    q = q.encode('utf-8')
    order_by = "price_asc"

    req = TaobaoRequest(method,
                        fields=fields,
                        keywords=q,
                        sort=order_by,
                        start_credit='3diamond',
                        page_size=200)

    source = client.execute(req)

    items = source.get('taobaoke_items', {
        'taobaoke_item': []
    }).get('taobaoke_item', [])
    data = [{
        'title': g['title'],
        'nick': g['nick'],
        'num_iid': g['num_iid'],
        'detail_url': g['click_url'],
        'price': float(g['price']),
        'volume': int(g['volume']),
        'score': int(g['seller_credit_score']),
        'post_fee': None,
        'delist_time': None,
        'location': g['item_location'],
        'source': 'taobao'
    } for g in items]
    return data
Exemple #2
0
def taoke_items_convert(num_iids):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)

    method = 'taobao.taobaoke.items.convert'
    fields = 'num_iid,title,nick,pic_url,price,click_url,commission,ommission_rate,commission_num,commission_volume,shop_click_url,seller_credit_score,item_location,volume'

    data = []
    # 每次转换最大输入40个num_iid
    n = len(num_iids) / 40 + (len(num_iids) % 40 and 1 or 0)
    for i in range(n):
        ids = ','.join([str(i) for i in num_iids[i * 40:(i + 1) * 40]])
        req = TaobaoRequest(method,
                            fields=fields,
                            num_iids=ids,
                            nick=nick.encode('utf8'))

        source = client.execute(req)

        items = source.get('taobaoke_items', {
            'taobaoke_item': []
        }).get('taobaoke_item', [])
        data.extend([{
            'num_iid': g['num_iid'],
            'click_url': g['click_url'],
            'pic_url': g['pic_url'],
            'title': g['title'],
            'nick': g['nick'],
            'price': float(g['price']),
            'commission': float(g['commission']),
            'seller_credit_score': int(g['seller_credit_score']),
            'source': 'taobao'
        } for g in items])

    return data
def get_taobao_items(q):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.items.get'
    fields = 'num_iid,title,pic_url,price,nick,score,volume,location,post_fee,delist_time'
    q = q.encode('utf-8')
    order_by = 'price:asc'
    start_score = '8'

    req = TaobaoRequest(method,
                        fields=fields,
                        q=q,
                        order_by=order_by,
                        start_score=start_score,
                        page_size=200)

    source = client.execute(req)

    items = source.get('items',{'item':[]}).get('item',[])
    data = [{'title': g['title'],
             'nick': g['nick'],
             'pic_url': g['pic_url'],
             'num_iid': g['num_iid'],
             'detail_url': "http://item.taobao.com/item.htm?id=%s" % g['num_iid'],
             'price': float(g['price']),
             'volume': int(g['volume']),
             'score': int(g['score']),
             'post_fee': g['post_fee'],
             'delist_time': datetime.datetime.strptime(g['delist_time'],'%Y-%m-%d %H:%S:%M'),
             'location': g['location']['city'],
             'source': 'taobao'} for g in items]
    return data
def taoke_items_convert(num_iids):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    
    method = 'taobao.taobaoke.items.convert'
    fields = 'num_iid,title,nick,pic_url,price,click_url,commission,ommission_rate,commission_num,commission_volume,shop_click_url,seller_credit_score,item_location,volume'

    data = []
    # 每次转换最大输入40个num_iid
    n = len(num_iids)/40 + (len(num_iids) % 40 and 1 or 0)
    for i in range(n):
        ids = ','.join([str(i) for i in num_iids[i*40:(i+1)*40]])
        req = TaobaoRequest(method, 
                            fields=fields,
                            num_iids=ids,
                            nick=nick.encode('utf8'))
        
        source = client.execute(req)
        
        items = source.get('taobaoke_items',{'taobaoke_item':[]}).get('taobaoke_item',[])
        data.extend([{'num_iid': g['num_iid'],
                 'click_url': g['click_url'],
                 'pic_url': g['pic_url'],
                 'title': g['title'],
                 'nick': g['nick'],
                 'price': float(g['price']),
                 'commission': float(g['commission']),
                 'seller_credit_score': int(g['seller_credit_score']),
                 'source': 'taobao'} for g in items])

    return data
def get_taobao_taoke(q):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.taobaoke.items.get'
    fields = 'num_iid,title,price,nick,click_url,commission,commission_rate,commission_num,commission_volume,shop_click_url,seller_credit_score,item_location,volume'
    q = q.encode('utf-8')
    order_by = "price_asc"

    req = TaobaoRequest(method,
                        fields=fields,
                        keywords=q,
                        sort=order_by,
                        start_credit='3diamond',
                        page_size=200)

    source = client.execute(req)

    items = source.get('taobaoke_items',{'taobaoke_item':[]}).get('taobaoke_item',[])
    data = [{'title': g['title'],
             'nick': g['nick'],
             'num_iid': g['num_iid'],
             'detail_url': g['click_url'],
             'price': float(g['price']),
             'volume': int(g['volume']),
             'score': int(g['seller_credit_score']),
             'post_fee': None,
             'delist_time': None,
             'location': g['item_location'],
             'source': 'taobao'} for g in items]
    return data
Exemple #6
0
def get_taobao_shop(nick):

    key, secret, mynick = appkey
    #key, secret, mynick = myappkey
    client = TaobaoAPI(key, secret)

    method = 'taobao.user.get'
    fields = 'user_id,uid,nick,sex,buyer_credit,seller_credit,location'
    req = TaobaoRequest(method, fields=fields, nick=nick.encode('utf8'))

    source = client.execute(req)

    shop = source.get('user', None)

    return shop
Exemple #7
0
def get_taobao_item(num_iid):

    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.item.get'
    fields = 'num_iid,detail_url,title,pic_url,price,nick,score,volume,location,post_fee,delist_time'

    req = TaobaoRequest(method, fields=fields, num_iid=num_iid)

    source = client.execute(req)
    print source

    item = source.get('item', None)

    return item
def get_taobao_shop(nick):
    
    key, secret, mynick = appkey
    #key, secret, mynick = myappkey
    client = TaobaoAPI(key, secret)
    
    method = 'taobao.user.get'
    fields = 'user_id,uid,nick,sex,buyer_credit,seller_credit,location'
    req = TaobaoRequest(method, fields=fields, nick=nick.encode('utf8'))

    source = client.execute(req)

    shop = source.get('user', None)

    return shop
def get_taobao_item(num_iid):
    
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.item.get'
    fields = 'num_iid,detail_url,title,pic_url,price,nick,score,volume,location,post_fee,delist_time'

    req = TaobaoRequest(method, fields=fields, num_iid=num_iid)

    source = client.execute(req)
    print source

    item = source.get('item', None)

    return item
Exemple #10
0
def get_taobao_items(q):
    key, secret, nick = myappkey
    client = TaobaoAPI(key, secret)
    method = 'taobao.items.get'
    fields = 'num_iid,title,pic_url,price,nick,score,volume,location,post_fee,delist_time'
    q = q.encode('utf-8')
    order_by = 'price:asc'
    start_score = '8'

    req = TaobaoRequest(method,
                        fields=fields,
                        q=q,
                        order_by=order_by,
                        start_score=start_score,
                        page_size=200)

    source = client.execute(req)

    items = source.get('items', {'item': []}).get('item', [])
    data = [{
        'title':
        g['title'],
        'nick':
        g['nick'],
        'pic_url':
        g['pic_url'],
        'num_iid':
        g['num_iid'],
        'detail_url':
        "http://item.taobao.com/item.htm?id=%s" % g['num_iid'],
        'price':
        float(g['price']),
        'volume':
        int(g['volume']),
        'score':
        int(g['score']),
        'post_fee':
        g['post_fee'],
        'delist_time':
        datetime.datetime.strptime(g['delist_time'], '%Y-%m-%d %H:%S:%M'),
        'location':
        g['location']['city'],
        'source':
        'taobao'
    } for g in items]
    return data
Exemple #11
0
def order_from_taobao(date):

    key, secret, nick = myappkey

    client = TaobaoAPI(key, secret)
    method = 'taobao.taobaoke.report.get'
    fields = 'trade_id,num_iid,item_title,item_num,seller_nick,pay_price,pay_time,shop_title,commission,outer_code'

    page = 1
    items = []
    while page > 0:
        req = TaobaoRequest(method,
                            fields=fields,
                            date=date.strftime('%Y%m%d'),
                            page_no=page,
                            page_size=40)

        source = client.execute(req)

        items.extend(
            source.get('taobaoke_report',
                       {}).get('taobaoke_report_members',
                               {}).get('taobaoke_report_member', []))
        total = source.get('total_results', 40)
        if total - page * 40 > 0:
            page += 1
        else:
            page = -1

    if items:

        for r in items:
            trade_id = str(r['trade_id'])
            report = TaokeReport.query.filter_by(trade_id=trade_id).first()

            if report is None:
                report = TaokeReport(trade_id=trade_id)
                db.session.add(report)

                report.num_iid = r['num_iid']
                report.pay_time = datetime.datetime.strptime(
                    r['pay_time'], '%Y-%m-%d %H:%S:%M')
                report.pay_price = r['pay_price']
                report.item_title = r['item_title']
                report.item_num = r['item_num']
                report.shop_title = r['shop_title']
                report.seller_nick = r['seller_nick']
                report.real_pay_fee = r['real_pay_fee']

                report.commission = Decimal(str(r['commission']))
                report.commission_rate = r['commission_rate']
                report.outer_code = r['outer_code']

                db.session.flush()

                # 给用户返利
                outer_code = r.get('outer_code', '')
                shorten = [outer_code[:6], outer_code[6:]]

                for i, s in enumerate(shorten):
                    user = User.query.filter_by(shorten=s).first()

                    # 前面为购买者(50%),后面为推荐者(20%返利)
                    rate = 0.5 if i == 0 else 0.2

                    if user:
                        record = FinanceRecord()
                        record.money = Decimal(
                            str(float(report.commission) * rate))
                        record.source = record.BUY if i == 0 else record.COMM
                        record.report = report
                        record.user = user

                        user.money += record.money

                        db.session.add(record)

                db.session.commit()

    return items
Exemple #12
0
def order_from_taobao(date):

    key, secret, nick = myappkey
    
    client = TaobaoAPI(key, secret)
    method = 'taobao.taobaoke.report.get'
    fields = 'trade_id,num_iid,item_title,item_num,seller_nick,pay_price,pay_time,shop_title,commission,outer_code'

    page = 1
    items = []
    while page>0:
        req = TaobaoRequest(method,
                            fields=fields,
                            date=date.strftime('%Y%m%d'),
                            page_no=page,
                            page_size=40)

        source = client.execute(req)

        items.extend(source.get('taobaoke_report',{}).get('taobaoke_report_members',{}).get('taobaoke_report_member',[]))
        total = source.get('total_results',40)
        if total - page*40 > 0:
            page += 1
        else:
            page = -1

    if items:
        
        for r in items:
            trade_id = str(r['trade_id'])
            report = TaokeReport.query.filter_by(trade_id=trade_id).first()

            if report is None:
                report = TaokeReport(trade_id=trade_id)
                db.session.add(report)
                
                report.num_iid = r['num_iid']
                report.pay_time = datetime.datetime.strptime(r['pay_time'], '%Y-%m-%d %H:%S:%M')
                report.pay_price = r['pay_price']
                report.item_title = r['item_title']
                report.item_num = r['item_num']
                report.shop_title = r['shop_title']
                report.seller_nick = r['seller_nick']
                report.real_pay_fee = r['real_pay_fee']
                
                report.commission = Decimal(str(r['commission']))
                report.commission_rate = r['commission_rate']
                report.outer_code = r['outer_code']

                db.session.flush()
                
                # 给用户返利
                outer_code = r.get('outer_code','')
                shorten = [outer_code[:6], outer_code[6:]]

                for i,s in enumerate(shorten):
                    user = User.query.filter_by(shorten=s).first()

                    # 前面为购买者(50%),后面为推荐者(20%返利)
                    rate = 0.5 if i==0 else 0.2

                    if user:
                        record = FinanceRecord()
                        record.money = Decimal(str(float(report.commission) * rate))
                        record.source = record.BUY if i==0 else record.COMM
                        record.report = report
                        record.user = user

                        user.money += record.money

                        db.session.add(record)

                db.session.commit()

    return items