{ "widgettype":"VBox", "options":{"cheight":40,"width":"100%"}, "subwidgets":[{ "id":"sales_ledger_tbl", "widgettype":"Tabular", "options":{ "width":"100%", "cheight":40, "title":"销售记账表", "css":"card", "editable":{ "new_data_url":"{{entire_url('add_sales_ledger.dspy')}}", "delete_data_url":"{{entire_url('delete_sales_ledger.dspy')}}", "update_data_url":"{{entire_url('update_sales_ledger.dspy')}}" }, "data_url":"{{entire_url('./get_sales_ledger.dspy')}}", "data_method":"GET", "data_params":{{json.dumps(params_kw, indent=4, ensure_ascii=False)}}, "row_options":{ "browserfields": { "exclouded": [ "id" ], "alters": { "settlement_status": { "uitype": "code", "data": [ { "value": "0", "text": "未结算" }, { "value": "1", "text": "已结算" } ] } } }, "fields":[ { "name": "id", "title": "主键ID", "type": "str", "length": 32, "nullable": "no", "cwidth": 18, "uitype": "str", "datatype": "str", "label": "主键ID" }, { "name": "resellerid", "title": "所属分销商机构ID", "type": "str", "length": 32, "nullable": "no", "label": "所属分销商机构ID", "uitype": "code", "valueField": "resellerid", "textField": "resellerid_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "organization", "tblvalue": "id", "tbltext": "orgname", "valueField": "resellerid", "textField": "resellerid_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "sub_reseller_id", "title": "二级分销商ID", "type": "str", "length": 32, "label": "二级分销商ID", "uitype": "code", "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')}}" }, { "name": "supplier_id", "title": "供应商ID", "type": "str", "length": 32, "label": "供应商ID", "uitype": "code", "valueField": "supplier_id", "textField": "supplier_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "suppliers", "tblvalue": "id", "tbltext": "supplier_name", "valueField": "supplier_id", "textField": "supplier_id_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "agreement_id", "title": "分销协议ID", "type": "str", "length": 32, "label": "分销协议ID", "uitype": "code", "valueField": "agreement_id", "textField": "agreement_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "distribution_agreements", "tblvalue": "id", "tbltext": "agreement_name", "valueField": "agreement_id", "textField": "agreement_id_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "contract_id", "title": "供销合同ID", "type": "str", "length": 32, "label": "供销合同ID", "uitype": "code", "valueField": "contract_id", "textField": "contract_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "supply_contracts", "tblvalue": "id", "tbltext": "contract_name", "valueField": "contract_id", "textField": "contract_id_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "prodtypeid", "title": "产品分类ID", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "产品分类ID" }, { "name": "productid", "title": "产品ID", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "产品ID" }, { "name": "sale_date", "title": "销售日期", "type": "date", "nullable": "no", "length": 0, "uitype": "date", "datatype": "date", "label": "销售日期" }, { "name": "quantity", "title": "销售数量", "type": "double", "length": 15, "dec": 2, "nullable": "no", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "销售数量" }, { "name": "unit_price", "title": "销售单价", "type": "double", "length": 15, "dec": 4, "nullable": "no", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "销售单价" }, { "name": "supply_discount", "title": "进货折扣", "type": "double", "length": 5, "dec": 4, "cwidth": 5, "uitype": "float", "datatype": "double", "label": "进货折扣" }, { "name": "supply_amount", "title": "进货金额", "type": "double", "length": 15, "dec": 2, "cwidth": 15, "uitype": "float", "datatype": "double", "label": "进货金额" }, { "name": "distribution_discount", "title": "分销折扣", "type": "double", "length": 5, "dec": 4, "cwidth": 5, "uitype": "float", "datatype": "double", "label": "分销折扣" }, { "name": "distribution_amount", "title": "分销金额", "type": "double", "length": 15, "dec": 2, "cwidth": 15, "uitype": "float", "datatype": "double", "label": "分销金额" }, { "name": "profit_amount", "title": "利润金额", "type": "double", "length": 15, "dec": 2, "cwidth": 15, "uitype": "float", "datatype": "double", "label": "利润金额" }, { "name": "settlement_status", "title": "结算状态", "type": "char", "length": 1, "nullable": "no", "default": "0", "cwidth": 4, "uitype": "code", "datatype": "char", "label": "结算状态", "data": [ { "value": "0", "text": "未结算" }, { "value": "1", "text": "已结算" } ] }, { "name": "remark", "title": "备注", "type": "text", "length": 0, "uitype": "text", "datatype": "text", "label": "备注" }, { "name": "created_by", "title": "创建人", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "创建人" }, { "name": "created_at", "title": "创建时间", "type": "datetime", "nullable": "no", "length": 0, "uitype": "str", "datatype": "datetime", "label": "创建时间" }, { "name": "updated_at", "title": "更新时间", "type": "datetime", "length": 0, "uitype": "str", "datatype": "datetime", "label": "更新时间" } ] }, "data_filter":{ "AND": [ { "field": "sale_date", "op": ">=", "var": "sale_date_start" }, { "field": "sale_date", "op": "<=", "var": "sale_date_end" }, { "field": "productid", "op": "=", "var": "productid" }, { "field": "settlement_status", "op": "=", "var": "settlement_status" } ] }, "filter_labels":{ "sale_date_start": "销售开始日期", "sale_date_end": "销售结束日期", "productid": "产品ID", "settlement_status": "结算状态" }, "page_rows":160, "cache_limit":5 } ,"binds":[] }] }