video_rewriting/common/feishu_form.py

# -*- coding: utf-8 -*-
import os
import random
import sys
import datetime


sys.path.append(os.getcwd())
from common.feishu_utils import Feishu


class Material():
    """
    获取汇总表所有负责人列表
    """
    @classmethod
    def feishu_list(cls):
        summary = Feishu.get_values_batch("summary", "3e1295")
        list = []
        for row in summary[1:]:
            mark = row[0]
            name = row[1]
            feishu_id = row[3]
            feishu_sheet = row[4]
            number = {"mark": mark, "name": name, "feishu_id": feishu_id, "feishu_sheet": feishu_sheet}
            if mark:
                list.append(number)
            else:
                return list
        return list

    """
    获取对应负责人任务明细
    """
    @classmethod
    def get_task_data(cls, feishu_id, feishu_sheet):
        data = Feishu.get_values_batch(feishu_id, feishu_sheet)
        list = []
        for row in data[1:]:
            task_mark = row[0]
            old_id = row[1]
            video_id = row[2]
            new_id = row[3]
            number = row[4]
            title = row[5]
            if new_id != 'None' and new_id != '' and new_id != None:
                number = {"task_mark": task_mark, "old_id": old_id, "video_id": video_id, "new_id": new_id,
                          "number": number, "title": title}
                list.append(number)
            else:
                return list
        return list