class TestNumToId(BasePrivateApiService):
    """
    动态私有OpenAPI
    使用方法
    """
    def execute(self, **kwargs):
        """
        参数：number
        default 设置为None时，如果编码换取不到ID时，程序不会抛出异常
        """
        position_id = DataUtil.convert_num_to_id('OrgPosition', kwargs['number'], default=None) # 组织类，岗位ID
        employee_category_id = DataUtil.convert_num_to_id('EmployeeCategory', kwargs['number'], default=None) # 实体类，用工类型ID
        business_id = DataUtil.convert_num_to_id('Business', kwargs['number'], default=None) # 流程，流程ID
        item_id = DataUtil.convert_num_to_id('common_basic_item_data.性别', kwargs['number'], default=None) # 码表，代码项ID；如果是树形代码项，需要保证number唯一
		return 

<table>
    <thead>
        <tr>
            <th>方法</th>
            <th>描述</th>
        </tr>
    </thead>
    
    <tbody>
    <tr>
        <td>count</td>
        <td>分组统计数值
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :param group_by:
            :param count_by:
            :param distinct_count_by:
            :param sum_by:
            :param avg_by:
            :param min_by:
            :param max_by:
            :param page_index:
            :param page_size:
            :return:
        </td>
    </tr>
    <tr>
        <td>count_value</td>
        <td>统计模型满足条件的个数,只有一个值
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :return:
        </td>
    </tr>
    <tr>
        <td>create</td>
        <td>新增模型数据
            :param model:
            :param info:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>create_batch</td>
        <td>批量新增模型数据
            :param model:
            :param info_list:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>edit</td>
        <td>修改模型数据
            :param model:
            :param id_:
            :param info:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>edit_batch</td>
        <td>批量修改数据
            :param model:
            :param edit_list:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>get</td>
        <td>获取模型数据
            :param model_:
            :param id_:
            :param kwargs:
            :return:
        </td>
    </tr>
    <tr>
        <td>list</td>
        <td>获取列表满足条件的所有数据（数据量少的时候用）
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param fields_key: 直接传字段列表，这边直接进行切割，
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :param page_index:
            :param page_size:
            :return:
        </td>
    </tr>
    <tr>
        <td>list_ids</td>
        <td>获取列表满足条件的所有数据id,直接返回id列表
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param fields_key: 直接传字段列表，这边直接进行切割，
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :param page_index:
            :param page_size:
            :return:
        </td>
    </tr>
    <tr>
        <td>record</td>
        <td>日志记录
            日志查看页面：/common_model_list?model=DynamicLogRecord
            :param content: 内容
            :param category
            :param type_: 1正常 2 异常 3 成功
            :param enabled: 是否执行
            :return:
        </td>
    </tr>
    <tr>
        <td>remove</td>
        <td>删除数据
            :param model:
            :param id_:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>remove_batch</td>
        <td>批量删除数据
            :param model:
            :param ids:
            :param role:
            :return:
        </td>
    </tr>
    <tr>
        <td>yield_count</td>
        <td>aggr接口分批获取,
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :param group_by:
            :param count_by:
            :param distinct_count_by:
            :param sum_by:
            :param avg_by:
            :param max_by:
            :param min_by:
            :param page_size:
            :return:
        </td>
    </tr>
    <tr>
        <td>yield_list</td>
        <td>循环按分页取列表,每次返回一个list 迭代
            :param model:
            :param filter_dict:
            :param state:
            :param fields:
            :param fields_key: 接收fields key列表,['name','position.name']
            :param sorts:
            :param extra_property:
            :param query_str:
            :param filter_str:
            :param page_size:
            :return:
            示例: for group in yield_list:
        </td>
    </tr>
    </tbody>
</table>
<style type="text/css">
    table,
    td,
    th {
        border: 1px solid #000;
        border-collapse: collapse;
    }

    table td {
        white-space: break-spaces;
        padding: 8px 16px;
    }
    
    thead >tr {
        background: rgb(237 238 242);
        height: 32px;
        font-size: 18px;
    }

    tbody > tr:nth-of-type(even) {
        background-color: rgb(237 238 242);
    }
</style>