{
    "widgettype": "VBox",
    "options": {
        "width": "100%",
        "height": "100%",
        "padding": "8px",
        "gap": "8px"
    },
    "subwidgets": [
        {
            "widgettype": "Text",
            "options": {"text": "分销商对账", "i18n": true}
        },
        {
            "widgettype": "Text",
            "options": {
                "text": "结算周期内我方供销账务单边明细发生统计（按产品汇总），与分销商数据进行核对",
                "color": "#94A3B8",
                "fontSize": "12px"
            }
        },
        {
            "id": "reseller_reconcile_form",
            "widgettype": "InlineForm",
            "options": {
                "css": "card",
                "padding": "8px",
                "submit_label": "查询",
                "submit_css": "primary",
                "fields": [
                    {
                        "name": "date_start",
                        "uitype": "date",
                        "label": "开始日期",
                        "cwidth": 10
                    },
                    {
                        "name": "date_end",
                        "uitype": "date",
                        "label": "结束日期",
                        "cwidth": 10
                    },
                    {
                        "name": "sub_reseller_id",
                        "uitype": "code",
                        "label": "二级分销商",
                        "cwidth": 15,
                        "valueField": "sub_reseller_id",
                        "textField": "sub_reseller_id_text",
                        "params": {
                            "dbname": "{{get_module_dbname('supplychain')}}",
                            "table": "sub_resellers",
                            "tblvalue": "id",
                            "tbltext": "sub_reseller_name",
                            "valueField": "sub_reseller_id",
                            "textField": "sub_reseller_id_text"
                        },
                        "dataurl": "{{entire_url('/appbase/get_code.dspy')}}"
                    }
                ]
            },
            "binds": [{
                "wid": "self",
                "event": "submit",
                "actiontype": "script",
                "script": "var tbl = bricks.getWidgetById('reseller_reconcile_tbl', bricks.app.root); if(tbl) await tbl.render(params);"
            }]
        },
        {
            "id": "reseller_reconcile_tbl",
            "widgettype": "Tabular",
            "options": {
                "width": "100%",
                "height": "100%",
                "css": "card",
                "data_url": "{{entire_url('./get_reseller_reconcile.dspy')}}",
                "data_method": "GET",
                "data_params": {{json.dumps(params_kw, indent=4, ensure_ascii=False)}},
                "row_options": {
                    "browserfields": {
                        "exclouded": ["id", "record_type"]
                    },
                    "fields": [
                        {
                            "name": "id",
                            "type": "str",
                            "length": 32,
                            "uitype": "str",
                            "label": "ID",
                            "cwidth": 10
                        },
                        {
                            "name": "category",
                            "title": "类别",
                            "type": "str",
                            "length": 20,
                            "uitype": "str",
                            "label": "类别",
                            "cwidth": 8
                        },
                        {
                            "name": "productid_text",
                            "title": "产品",
                            "type": "str",
                            "length": 100,
                            "uitype": "str",
                            "label": "产品",
                            "cwidth": 15
                        },
                        {
                            "name": "tx_count",
                            "title": "交易笔数",
                            "type": "int",
                            "uitype": "int",
                            "label": "交易笔数",
                            "cwidth": 8
                        },
                        {
                            "name": "total_qty",
                            "title": "数量",
                            "type": "double",
                            "length": 15,
                            "dec": 2,
                            "uitype": "float",
                            "label": "数量",
                            "cwidth": 8
                        },
                        {
                            "name": "our_amount",
                            "title": "我方金额(应收)",
                            "type": "double",
                            "length": 15,
                            "dec": 2,
                            "uitype": "float",
                            "label": "我方金额(应收)",
                            "cwidth": 12
                        },
                        {
                            "name": "their_amount",
                            "title": "对方金额(应付)",
                            "type": "double",
                            "length": 15,
                            "dec": 2,
                            "uitype": "float",
                            "label": "对方金额(应付)",
                            "cwidth": 12
                        },
                        {
                            "name": "diff_amount",
                            "title": "差异金额",
                            "type": "double",
                            "length": 15,
                            "dec": 2,
                            "uitype": "float",
                            "label": "差异金额",
                            "cwidth": 10
                        },
                        {
                            "name": "match_status",
                            "title": "核对状态",
                            "type": "str",
                            "length": 1,
                            "uitype": "code",
                            "label": "核对状态",
                            "cwidth": 8,
                            "data": [
                                {"value": "0", "text": "待核对"},
                                {"value": "1", "text": "我方单边"},
                                {"value": "2", "text": "对方单边"},
                                {"value": "3", "text": "一致"}
                            ]
                        }
                    ]
                },
                "page_rows": 200
            }
        }
    ]
}