{ "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_detail_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_detail_tbl', bricks.app.root); if(tbl) await tbl.render(params);" }] }, { "id": "reseller_detail_tbl", "widgettype": "Tabular", "options": { "width": "100%", "height": "100%", "css": "card", "data_url": "{{entire_url('./get_reseller_detail_reconcile.dspy')}}", "data_method": "GET", "data_params": {{json.dumps(params_kw, indent=4, ensure_ascii=False)}}, "row_options": { "browserfields": { "exclouded": ["id", "record_type", "source_id", "source_type"] }, "fields": [ { "name": "id", "type": "str", "length": 32, "uitype": "str", "label": "ID", "cwidth": 14 }, { "name": "sale_date", "title": "交易日期", "type": "date", "uitype": "date", "label": "交易日期", "cwidth": 10 }, { "name": "product_name", "title": "产品", "type": "str", "length": 100, "uitype": "str", "label": "产品", "cwidth": 14 }, { "name": "counterparty", "title": "分销商", "type": "str", "length": 100, "uitype": "str", "label": "分销商", "cwidth": 12 }, { "name": "quantity", "title": "数量", "type": "double", "length": 15, "dec": 2, "uitype": "float", "label": "数量", "cwidth": 8 }, { "name": "unit_price", "title": "单价", "type": "double", "length": 15, "dec": 4, "uitype": "float", "label": "单价", "cwidth": 8 }, { "name": "our_amount", "title": "我方金额(应收)", "type": "double", "length": 15, "dec": 2, "uitype": "float", "label": "我方金额(应收)", "cwidth": 10 }, { "name": "their_amount", "title": "对方金额(应付)", "type": "double", "length": 15, "dec": 2, "uitype": "float", "label": "对方金额(应付)", "cwidth": 10 }, { "name": "diff_amount", "title": "差异", "type": "double", "length": 15, "dec": 2, "uitype": "float", "label": "差异", "cwidth": 8 }, { "name": "match_status", "title": "核对", "type": "str", "length": 1, "uitype": "code", "label": "核对", "cwidth": 6, "data": [ {"value": "0", "text": "待核对"}, {"value": "1", "text": "我方单边"}, {"value": "2", "text": "对方单边"}, {"value": "3", "text": "一致"} ] } ] }, "page_rows": 200 } } ] }