{ "widgettype":"VBox", "options":{"cheight":40,"width":"100%"}, "subwidgets":[{ "id":"supplychain_accounting_tbl", "widgettype":"Tabular", "options":{ "width":"100%", "cheight":40, "title":"供销记账表", "css":"card", "editable":{ "new_data_url":"{{entire_url('add_supplychain_accounting.dspy')}}", "delete_data_url":"{{entire_url('delete_supplychain_accounting.dspy')}}", "update_data_url":"{{entire_url('update_supplychain_accounting.dspy')}}" }, "data_url":"{{entire_url('./get_supplychain_accounting.dspy')}}", "data_method":"GET", "data_params":{{json.dumps(params_kw, indent=4, ensure_ascii=False)}}, "row_options":{ "browserfields": { "exclouded": [ "created_by", "created_at" ] }, "editexclouded":[ "id", "resellerid", "created_by", "created_at" ], "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": "supply_contract_id", "title": "供销合同ID", "type": "str", "length": 32, "label": "供销合同ID", "uitype": "code", "valueField": "supply_contract_id", "textField": "supply_contract_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "supply_contracts", "tblvalue": "id", "tbltext": "contract_name", "valueField": "supply_contract_id", "textField": "supply_contract_id_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "supply_contract_item_id", "title": "供销合同产品明细ID", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "供销合同产品明细ID" }, { "name": "distribution_agreement_id", "title": "分销协议ID", "type": "str", "length": 32, "label": "分销协议ID", "uitype": "code", "valueField": "distribution_agreement_id", "textField": "distribution_agreement_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "distribution_agreements", "tblvalue": "id", "tbltext": "agreement_name", "valueField": "distribution_agreement_id", "textField": "distribution_agreement_id_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "distribution_agreement_item_id", "title": "分销协议产品明细ID", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "分销协议产品明细ID" }, { "name": "sub_distributor_id", "title": "二级分销商ID", "type": "str", "length": 32, "label": "二级分销商ID", "uitype": "code", "valueField": "sub_distributor_id", "textField": "sub_distributor_id_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "sub_distributors", "tblvalue": "id", "tbltext": "sub_dist_name", "valueField": "sub_distributor_id", "textField": "sub_distributor_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": "prodtypeid", "title": "产品分类ID", "type": "str", "length": 32, "label": "产品分类ID", "uitype": "code", "valueField": "prodtypeid", "textField": "prodtypeid_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "product_types", "tblvalue": "id", "tbltext": "type_name", "valueField": "prodtypeid", "textField": "prodtypeid_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "productid", "title": "产品ID", "type": "str", "length": 32, "label": "产品ID", "uitype": "code", "valueField": "productid", "textField": "productid_text", "params": { "dbname": "{{get_module_dbname('supplychain')}}", "table": "products", "tblvalue": "id", "tbltext": "product_name", "valueField": "productid", "textField": "productid_text" }, "dataurl": "{{entire_url('/appbase/get_code.dspy')}}" }, { "name": "quantity", "title": "数量", "type": "double", "length": 15, "dec": 4, "nullable": "no", "default": "0", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "数量" }, { "name": "unit_price", "title": "销售单价", "type": "double", "length": 15, "dec": 4, "nullable": "no", "default": "0", "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, "nullable": "no", "default": "0", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "进货金额(应付供应商)" }, { "name": "dist_discount", "title": "分销折扣", "type": "double", "length": 5, "dec": 4, "cwidth": 5, "uitype": "float", "datatype": "double", "label": "分销折扣" }, { "name": "dist_amount", "title": "分销金额(二级分销商应付)", "type": "double", "length": 15, "dec": 2, "nullable": "no", "default": "0", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "分销金额(二级分销商应付)" }, { "name": "profit_amount", "title": "利润金额", "type": "double", "length": 15, "dec": 2, "nullable": "no", "default": "0", "cwidth": 15, "uitype": "float", "datatype": "double", "label": "利润金额" }, { "name": "sale_date", "title": "销售日期", "type": "date", "nullable": "no", "length": 0, "uitype": "date", "datatype": "date", "label": "销售日期" }, { "name": "source_type", "title": "来源类型", "type": "char", "length": 1, "default": "1", "cwidth": 4, "uitype": "str", "datatype": "char", "label": "来源类型" }, { "name": "source_id", "title": "来源记录ID", "type": "str", "length": 32, "cwidth": 18, "uitype": "str", "datatype": "str", "label": "来源记录ID" }, { "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": "创建时间" } ] }, "page_rows":160, "cache_limit":5 } ,"binds":[] }] }