180 lines
6.9 KiB
XML
180 lines
6.9 KiB
XML
{
|
|
"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
|
|
}
|
|
}
|
|
]
|
|
}
|