# plugin-x-spreadsheet

**Repository Path**: baixingpeng/plugin-x-spreadsheet

## Basic Information

- **Project Name**: plugin-x-spreadsheet
- **Description**: 报表查询控件
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: 15.0
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 6
- **Created**: 2024-08-02
- **Last Updated**: 2024-08-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# plugin-x-spreadsheet

#### 介绍

**基于x-spreadsheet，展示方式与体现形式更灵活，展示效果更接近真是数据报表，展示数据范围不受模型约束，总之，你想要的都可以展示出来。**

**前后端高度封装，开发者只关注业务逻辑实现即可，契合odoo快速开发实现的特点。**

#### 效果展示

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/14.0/static/images/211120001.jpg)

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/14.0/static/images/211121002.jpg)

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/14.0/static/images/211123001.png)

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/14.0/static/images/211123002.png)

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/15.0/static/images/211211001.jpg)

![Image text](https://gitee.com/esplets/plugin-x-spreadsheet/raw/15.0/static/images/211211002.jpg)


#### 安装教程

install app

#### 使用说明

1.  新建查询菜单
```
<?xml version="1.0"?>
<odoo>
    <data>
        <record id="action_sheet" model="ir.actions.client">
            <field name="name">X-Spreadsheet</field>
            <field name="tag">x_spreadsheet</field>
            <field name="res_model">demo.x.spreadsheet</field>
            <field name="context">{'res_model': 'demo.x.spreadsheet'}</field>
        </record>
        <menuitem
            id="menu_demo_sheet"
            name="X-Spreadsheet"
            action="action_sheet"
            parent="menu_sheet"
            groups="base.group_user"
            sequence="10" />

    </data>
</odoo>
```
2.  重写数据归集方法
```
# -*- coding: utf-8 -*-

import time
from odoo import api, models, _
from ..resolver.x_spreadsheet import XSpreadsheet


class DemoXSpreadsheet(models.AbstractModel):
    _name = 'demo.x.spreadsheet'
    _description = 'Demo X Spreadsheet'

    def get_x_spreadsheet_data(self, *args, **kwargs):
        """
        :return x_spreadsheet_data
        """
        rows, merges = self._get_data()
        return XSpreadsheet(name="Report Name", freeze='A1', styles=XSpreadsheet.STYLES, merges=merges, rows=rows, cols=11).x_spreadsheet()
```

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 讨论&帮助

![Image text](https://gitee.com/esplets/library-pyecharts/raw/14.0/static/img/qq.png)