window部分
//字符串
{
“id”: “product_name”,
“label”: “产品”,
“type”: “string”,
“disable”:“1” --不可用
“default”: “
u
s
e
r
i
d
"
−
−
默
认
值
为
当
前
登
录
人
i
d
,
userid" --默认值为当前登录人id ,
userid"−−默认值为当前登录人id,username默认值当前登录人的名字 $telphone --默认值为当前登录人的电话
},
//日期
{
“id”: “sell_date1”,
“label”: “日期”,
“type”: “date”,“uitype”:“datepicker”
},
//数值
{
“id”: “id”,
“label”: “编号”,
“type”: “number”,
“disable”:”{status} == 50 ? ‘1’:‘0’", – 由指定参数来决定是否可用
“visible”:"{status} == 2? ‘1’:‘0’", – 由指定参数来决定是否隐藏
"updatable": "1" --无论值是否改变强制更新
},
// 下拉回显
{
“id”: “rel_manager_id”,
“label”: “关联销售”,
“type”: “number”,
“uitype”: “select”,
“multiple”: “1”, --配置可以多选
“lookup”: “sys/datahub/base_service/subusers”
}
//查找带回(调用数据字典 base_lookup_type && base_lookup_code)
{
“id”: “buyer_name2”,
“label”: “买方名称”,
“type”: “string”,
“lookupwindow”: “121”, --打开哪个页面
“lookupcolumn”: “id,name,type”, --从该页面拿到参数
“paramback”:"{“main”: [“oe_order_ims_header#buyer_type”,“main#type”]}",–页面参数传参
“returnback”: “buyer_id,buyer_name,buyer_type”, -放到当前页面参数
“disable”:“0”,
“visible”: “0”,
“updatable”: “0”,
“required”:“1”, – 必填
“size”: “medium” – 中等大小,
“refreshlookup”:[‘seller_name_second’,‘seller_name_three’],–数值改变后,刷新列表
},
//查找带回(调用接口传参 base_lookup_dtable),
{
“id”: “seller_name_second”,
“label”: “卖方(二级)”,
“type”: “string”,
“disable”: “0”,
“uitype”: “select”,
“lookup”: “/sys/lookup/baseinfo_sublist/ims_client/{id}”,
“param”: “seller_id”, – 传递参数
“refreshlookup”:[‘seller_name_three’], -当此参数改变,刷新指定页面的参数
“size”: “medium” – 占用二分之一,默认四分之一,large
“changereset”:“oe_order_store_lines” --数值改变后清空指定内容
},
//文本框
{
"id": "memo",
"label": "备注",
"type": "string",
"uitype": "textarea"
},
//计算列表中的同行参数
{
"id": "total_price",
"label": "合计",
"type": "number",
"visible": "0",
"compute": "${object}.unit_price * ${object}.amount"
},
//指定指定tab页的指定列参数
{
"id": "sum_price",
"label": "总额",
"type": "number",
"disable":"1",
"compute":"sum(tabs#oe_order_ims_lines#$expr(Math.round(${object}.unit_price * ${object}.amount,2)))"
},
//标签栏title
{
"id": "tmp",
"label": "图片上传",
"uitype": "title",
"size": "large"
},
//图片上传
{
"id": "contract_url",
"label": "合同图片",
"type": "string",
"uitype": "upload",
"required": "1",
"updatable": "1"
},
//可以存多个
{
"id":"aio_type_list",
"label":"基座类型",
"uitype":"inner_table",
"size":"large",
"limit":5,
"uicontent":"[{\"id\":\"aio_type\",\"label\":\"基座类型\",\"savelabel\":\"label\", \"uitype\":\"select\",\"lookup\":\"/sys/lookup/codes/fs_aio_type\"}, {\"id\":\"aio_num\", \"type\":\"number\",\"label\":\"基座数量\"}]",
"chineseid":"aio_type_list_text",
"visible": "{type} >0 && {type} <= 5 ||{type} == 9||{type} == 10? '1':'0'"
},
{
"id": "aio_type_list_text",
"label": "基座类型文本",
"type": "string",
"updatable": "1",
"visible": "0"
},
//指定主表是否发mq的参数
“meta”: {
“name”: “合同管理明细”,
“uitype”: “bill”,
“busitype”: “1”,
“colpk”: [“id”],
“url”: “sys/window/common_detail”,
“msgtag”:“crm.drugstoreOrderAuditedTag” , --发送mq的页签
“msgcondition”:"${bill}.get(“status”) == 30 ?“1”:“0"”,
“main”: [“oe_order_headers#"], – 获取main的所有信息
“tabs”: ["oe_order_store_lines#”] – 获取 tab页的所有信息
“sqlscalar”:“drugstore@select is_free limit_for_free from store_contract where store_id = #{store_id} order by id desc limit 1”, --将其他数据库中的结果集映射到指定字段上
“sqlinit”: “select fn_get_subordinate(#{userid}) leader_list” --将结果集映射到指定字段上
},
“unique”:“code”, – 如果数据冗余,那么根据参数返回友好提示
//billcheck – 提交后全局校验
“billcheck”:“SELECT
GROUP_CONCAT(IF
( amount < 0, CONCAT( ''商品名称为 : ‘’, item_name, ‘’,可用库存量小于当前输入的数量! ‘’ ), null ) )error_msg
FROM
erp_outstock_onhand_v a
WHERE
EXISTS (select 1 from oe_order_ims_lines b where a.item_name = b.product_name and a.item_expiry_date = b.expiry_date and a.item_unit_price = b.unit_price)”
// – 提交后全局触发
“billtrigger”:"
UPDATE hz_parties
JOIN ( SELECT id, cust_id, STATUS, license_url FROM oe_order_headers a WHERE id = {0}) m ON m.cust_id = hz_parties.id
SET hz_parties.coop_status = m.STATUS,
hz_parties.contract_url = IF(m.STATUS
>= 30,m.license_url,hz_parties.contract_url)
WHERE
m.id = {0};
{{$bpm_config_2item_metas}},
– 弘 (这是封装的json字符串,是在sys_segment中定义)
“tabs”: {
“meta”: [
{{$bpm_config_2item_metas}},
],
“items”: [
{{$bpm_config_2item_items}},
]