获取有赞分销员所有电话号码存储

虽然是你的一小步，确实进步的一大步，我觉得很有信心了

 

 

#!/usr/bin/env python
# _*_coding:utf-8 _*_
#@Time    :2019/6/18 15:50
#@Author  :Sakura
#@FileName: 有赞分销员接口调通存储数据.py

from app.external.yz.user_api import YzUserApi
from app.utils.x_logger import logger
from app.external.yz.api_util import YzApiUtil
from app.external.yz.trade_api import YzTradeApi
from openpyxl import Workbook

"""
犯的两个错误，
1 from openpyxl import Workbook 写的是小写的workbook ，所以失败
2 token 不会的时候，应该尽早的问下强哥的
"""

class YzSalesmanTradeTestService:

    def __init__(self):
        self.yz_mobile = YzTradeApi()

    def get_mobile(self):
        """
        :return: 分销员所有电话号码
        """
        mobile = []
        page_size = 10
        page_no = 1

        while True:
            list = self.yz_mobile.get_salesman(
                page_no=page_no,
                page_size=page_size,
            )

            for salesman in list:
                bai = salesman['mobile']
                mobile.append(bai)

            if len(list) < page_size:
                break
            else:
                page_no += 1

        return mobile


if __name__ == '__main__':



    mobile = YzSalesmanTradeTestService().get_mobile()
    print(mobile)

    wb = Workbook()
    ws = wb.active
    x = 1
    for i in mobile:
        ws.cell(row=x, column=1, value=i)
        x += 1
    wb.save(R'C:\Users\HBX\Desktop\工作\201904\业务激励分配\baixi03.xlsx')