RuleData = {
'adm_apply_budget':[
	{srcNodeId:"adm_merchandise",destNodeId:"adm_apply_budget",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'adm_apply_det':[
	{srcNodeId:"adm_merchandise",destNodeId:"adm_apply_det",layout:"",whereSql:"status='1'",whereType:"",whereValue:""}
],
'adm_apply_wf':[
	{srcNodeId:"oa_workflowapply",destNodeId:"adm_apply_wf",layout:"",whereSql:"apply_code not in (select apply_code from adm_apply_wf)",whereType:"",whereValue:""}
],
'adm_box':[
	{srcNodeId:"adm_order_imp",destNodeId:"adm_box",layout:"",whereSql:"order_det_id not in(select order_det_id from adm_box where auditing='0' and order_det_id  is not null) and adm_order_det.pur_type ='0'",whereType:"",whereValue:""}
],
'adm_box_consume':[
	{srcNodeId:"adm_order_imp2",destNodeId:"adm_box_consume",layout:"",whereSql:"order_id in (select  order_id from adm_order_det  where pur_type='1')",whereType:"",whereValue:""}
],
'adm_box_user':[
	{srcNodeId:"sys_user",destNodeId:"adm_box_user",layout:"/public/layout/layout_tree.js",whereSql:"user_id  not in (SELECT check_userid  from adm_box_user  where box_id= {FKEYID})",whereType:"",whereValue:""}
],
'adm_budget_adddet':[
	{srcNodeId:"prop_budget_det",destNodeId:"adm_budget_adddet",layout:"",whereSql:"budget_det_id not in (SELECT budget_det_id FROM prop_budget_adddet WHERE budget_add_id= {FKEYID})",whereType:"",whereValue:""}
],
'adm_budget_chgdet':[
	{srcNodeId:"prop_budget_det",destNodeId:"adm_budget_chgdet",layout:"",whereSql:"budget_det_id not in (SELECT budget_det_id FROM prop_budget_chgdet WHERE budget_chg_id= {FKEYID})",whereType:"",whereValue:""}
],
'adm_change_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_change_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='change')",whereType:"",whereValue:""}
],
'adm_consume_aydet':[
	{srcNodeId:"adm_consume_sel",destNodeId:"adm_consume_aydet",layout:"",whereSql:"spec_consume_sel.sel_type not in ('4') and consume_sel_id not in (select consume_sel_id from spec_consume_aydet where consume_ay_id={FKEYID}) and spec_consume_sel.sel_num>0 and spec_consume_sel.sel_status='0'",whereType:"",whereValue:""}
],
'adm_consume_indet':[
	{srcNodeId:"consume_order_det_imp",destNodeId:"adm_consume_indet",layout:"",whereSql:"order_det_id not in (select order_det_id  from spec_consume_indet where consume_in_id ={FKEYID}) and (ifnull(order_num,0)-ifnull(in_num,0))>0",whereType:"",whereValue:""}
],
'adm_consume_scrapdet':[
	{srcNodeId:"sel_adm_consume",destNodeId:"adm_consume_scrapdet",layout:"",whereSql:"consume_sel_id not in (select consume_sel_id from spec_consume_scrapdet where consume_scrap_id={FKEYID}) and spec_consume_sel.sel_num>0",whereType:"",whereValue:""}
],
'adm_device_sel':[
	{srcNodeId:"device_scan_more",destNodeId:"adm_device_sel",layout:"",whereSql:"auditing in ('1','3') and more_id not in (select more_id from device_card where more_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sel_hire_det",destNodeId:"adm_device_sel",layout:"",whereSql:"hire_det_id not in  (select hire_det_id from device_card where hire_det_id is not null)",whereType:"",whereValue:""}
],
'adm_invoice_dev':[
	{srcNodeId:"adm_box_det_imp",destNodeId:"adm_invoice_dev",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'adm_loan_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_loan_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from adm_receive_det where receive_id={FKEYID})",whereType:"",whereValue:""}
],
'adm_pay_det':[
	{srcNodeId:"adm_order_pay_imp",destNodeId:"adm_pay_det",layout:"",whereSql:"order_pay_id not in (select order_pay_id from adm_pay_det)",whereType:"",whereValue:""}
],
'adm_pay_dev':[
	{srcNodeId:"adm_box_det_imp",destNodeId:"adm_pay_dev",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'adm_pay_invoice':[
	{srcNodeId:"adm_invoice_det",destNodeId:"adm_pay_invoice",layout:"",whereSql:"invoice_det_id not in (select invoice_det_id from adm_pay_invoice where pay_id={FKEYID})",whereType:"",whereValue:""}
],
'adm_receive_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_receive_det",layout:"/public/layout/layout_tree.js",whereSql:"card_user is null  and device_id not in (select device_id from adm_receive_det where receive_id={FKEYID})",whereType:"",whereValue:""}
],
'adm_return_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_return_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from adm_receive_det where receive_id={FKEYID})",whereType:"",whereValue:""}
],
'adm_scrap_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_scrap_det",layout:"",whereSql:"device_id not in (select device_id from adm_receive_det where receive_id={FKEYID}) and asset_code is not null",whereType:"",whereValue:""}
],
'adm_trans_det':[
	{srcNodeId:"adm_device_sel",destNodeId:"adm_trans_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from adm_receive_det where receive_id={FKEYID})",whereType:"",whereValue:""}
],
'app_role_fun':[
	{srcNodeId:"app_fun",destNodeId:"app_role_fun",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'app_role_user':[
	{srcNodeId:"sys_user",destNodeId:"app_role_user",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select user_id from app_role_user where role_id = {FKEYID})",whereType:"",whereValue:""}
],
'app_user_role':[
	{srcNodeId:"sys_role",destNodeId:"app_user_role",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'app_warnrole':[
	{srcNodeId:"app_role",destNodeId:"app_warnrole",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'assets_out_accounts':[
	{srcNodeId:"device_scan_more",destNodeId:"assets_out_accounts",layout:"",whereSql:"auditing in ('1','3') and more_id not in (select more_id from device_card where more_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sel_hire_det",destNodeId:"assets_out_accounts",layout:"",whereSql:"hire_det_id not in  (select hire_det_id from device_card where hire_det_id is not null)",whereType:"",whereValue:""}
],
'base_set':[
	{srcNodeId:"sel_device",destNodeId:"base_set",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from base_set) and abc_type='A' and ifnull(special_type,'') not in ('行政设备')",whereType:"",whereValue:""}
],
'bench_issue_appointuser':[
	{srcNodeId:"gsys_user_dept",destNodeId:"bench_issue_appointuser",layout:"",whereSql:"sys_user.user_id not in (select edit_userid from bench_issue_report where issue_user_id ={FKEYID})",whereType:"",whereValue:""}
],
'bos_package_fun':[
	{srcNodeId:"sel_fun",destNodeId:"bos_package_fun",layout:"/public/layout/layout_tree.js",whereSql:"reg_type in ('main', 'treemain', 'selfun', 'result') and module_id not like '1010%'",whereType:"",whereValue:""}
],
'bos_package_use':[
	{srcNodeId:"bos_tenant",destNodeId:"bos_package_use",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'bos_var':[
	{srcNodeId:"bos_var",destNodeId:"bos_var",layout:"",whereSql:"bos_tenant_id = 'jxstar'",whereType:"",whereValue:""}
],
'check_asset_adm':[
	{srcNodeId:"adm_box_det_imp",destNodeId:"check_asset_adm",layout:"",whereSql:"box_det_id not in (select box_det_id from check_asset where turn_id={FKEYID})",whereType:"",whereValue:""}
],
'check_asset_orival':[
	{srcNodeId:"sel_device_accept",destNodeId:"check_asset_orival",layout:"/public/layout/layout_tree.js",whereSql:"device_card.device_id not in (select device_id from check_asset  where turn_id = {FKEYID})",whereType:"",whereValue:""}
],
'check_built_det':[
	{srcNodeId:"prop_box_det_imp",destNodeId:"check_built_det",layout:"",whereSql:"box_det_id not in (select box_det_id from check_asset where box_det_id is not null)  and device_code is not null",whereType:"",whereValue:""},
	{srcNodeId:"prop_accept_det_imp",destNodeId:"check_built_det",layout:"",whereSql:"accept_det_id not in (select box_det_id from check_asset where box_det_id is not null)",whereType:"",whereValue:""}
],
'check_orival_det':[
	{srcNodeId:"sel_device_accept",destNodeId:"check_orival_det",layout:"/public/layout/layout_tree.js",whereSql:"device_card.device_id not in (select device_id from check_asset  where turn_id = {FKEYID} )",whereType:"",whereValue:""}
],
'consume_order_det':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"consume_order_det",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from consume_order_det where  order_id = {FKEYID}) and sp_catalog.type_code  like '16%'",whereType:"",whereValue:""}
],
'consume_order_det_imp':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"consume_order_det_imp",layout:"",whereSql:"sp_catalog.sp_id not in (select sp_id from consume_order_det where  order_id = {FKEYID}) and sp_catalog.type_id like '1009%'",whereType:"",whereValue:""}
],
'device_allot_det':[
	{srcNodeId:"sel_device",destNodeId:"device_allot_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='allot') and status in ('6')",whereType:"",whereValue:""}
],
'device_bind_det':[
	{srcNodeId:"sel_devicecard",destNodeId:"device_bind_det",layout:"",whereSql:"device_id not in(select device_id from device_bind_det where bind_id={FKEYID}) and  auditing in ('1','3') and status not in ('6','7','8')",whereType:"",whereValue:""}
],
'device_card':[
	{srcNodeId:"device_scan_more",destNodeId:"device_card",layout:"",whereSql:"auditing in ('1','3') and more_id not in (select more_id from device_card where more_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sel_hire_det",destNodeId:"device_card",layout:"",whereSql:"hire_det_id not in  (select hire_det_id from device_card where hire_det_id is not null)",whereType:"",whereValue:""}
],
'device_card_adm':[
	{srcNodeId:"device_scan_more",destNodeId:"device_card_adm",layout:"",whereSql:"auditing in ('1','3') and more_id not in (select more_id from device_card where more_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sel_hire_det",destNodeId:"device_card_adm",layout:"",whereSql:"hire_det_id not in  (select hire_det_id from device_card where hire_det_id is not null)",whereType:"",whereValue:""}
],
'device_change_det':[
	{srcNodeId:"sel_device",destNodeId:"device_change_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='change')",whereType:"",whereValue:""}
],
'device_change_resi_det':[
	{srcNodeId:"sel_device",destNodeId:"device_change_resi_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id \nand device_vary.auditing not in ('1','3') and device_vary.vary_type='residual') and status in ('1')",whereType:"",whereValue:""}
],
'device_change_type_det':[
	{srcNodeId:"sel_device",destNodeId:"device_change_type_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id \nand device_vary.auditing not in ('1','3') and device_vary.vary_type='type') and status in ('1')",whereType:"",whereValue:""}
],
'device_change_use_det':[
	{srcNodeId:"sel_device",destNodeId:"device_change_use_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id \nand device_vary.auditing not in ('1','3') and device_vary.vary_type='useMonth') and status in ('1')",whereType:"",whereValue:""}
],
'device_chg':[
	{srcNodeId:"check_box_imp",destNodeId:"device_chg",layout:"",whereSql:"box_det_id not in (select box_det_id from device_card where box_det_id is not null) and box_det_id not in (select box_det_id from asset_install where box_det_id is not null and auditing in ('1','3'))",whereType:"",whereValue:""},
	{srcNodeId:"asset_insta",destNodeId:"device_chg",layout:"",whereSql:"install_id not in (select install_id from device_card where install_id is not null) and auditing in ('1','3')",whereType:"",whereValue:""}
],
'device_disable_det':[
	{srcNodeId:"sel_device",destNodeId:"device_disable_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='disable') and status='1'",whereType:"",whereValue:""}
],
'device_enable_det':[
	{srcNodeId:"sel_device",destNodeId:"device_enable_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and vary_type='enable') and status='2'",whereType:"",whereValue:""}
],
'device_file':[
	{srcNodeId:"check_box_imp",destNodeId:"device_file",layout:"",whereSql:"box_det_id not in (select box_det_id from device_card where box_det_id is not null) and box_det_id not in (select box_det_id from asset_install where box_det_id is not null and auditing in ('1','3'))",whereType:"",whereValue:""},
	{srcNodeId:"asset_insta",destNodeId:"device_file",layout:"",whereSql:"install_id not in (select install_id from device_card where install_id is not null) and auditing in ('1','3')",whereType:"",whereValue:""}
],
'device_hire_close':[
	{srcNodeId:"sel_device",destNodeId:"device_hire_close",layout:"/public/layout/layout_tree_cloud.js",whereSql:"device_id not in (select device_hire_det.device_id from device_hire,device_hire_det where device_hire_det.hire_id=device_hire.hire_id and device_hire_det.hire_end_date is null)",whereType:"",whereValue:""}
],
'device_hire_det':[
	{srcNodeId:"sel_device",destNodeId:"device_hire_det",layout:"/public/layout/layout_tree_cloud.js",whereSql:"device_id not in (select device_hire_det.device_id from device_hire,device_hire_det where device_hire_det.hire_id=device_hire.hire_id and device_hire_det.hire_end_date is null)",whereType:"",whereValue:""}
],
'device_idle_det':[
	{srcNodeId:"sel_device",destNodeId:"device_idle_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type in  ('idle','disable','seal')) and status in ('1')",whereType:"",whereValue:""}
],
'device_line_det':[
	{srcNodeId:"sel_device",destNodeId:"device_line_det",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'device_list':[
	{srcNodeId:"check_box_imp",destNodeId:"device_list",layout:"",whereSql:"box_det_id not in (select box_det_id from device_card where box_det_id is not null) and box_det_id not in (select box_det_id from asset_install where box_det_id is not null and auditing in ('1','3'))",whereType:"",whereValue:""},
	{srcNodeId:"asset_insta",destNodeId:"device_list",layout:"",whereSql:"install_id not in (select install_id from device_card where install_id is not null) and auditing in ('1','3')",whereType:"",whereValue:""}
],
'device_loan_det':[
	{srcNodeId:"device_loan_sel",destNodeId:"device_loan_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary_det where vary_id={FKEYID})",whereType:"",whereValue:""}
],
'device_rend_ close':[
	{srcNodeId:"sel_device",destNodeId:"device_rend_ close",layout:"",whereSql:"status='1' and device_id not in (select device_id from device_rend_det where auditing not in ('1','3'))",whereType:"",whereValue:""}
],
'device_rend_det':[
	{srcNodeId:"sel_device",destNodeId:"device_rend_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_rend_det where auditing not in ('1','3'))",whereType:"",whereValue:""}
],
'device_scrap_det':[
	{srcNodeId:"sel_device",destNodeId:"device_scrap_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='scrap') and status in ('1','2','3','4')",whereType:"",whereValue:""}
],
'device_seal_det':[
	{srcNodeId:"sel_device",destNodeId:"device_seal_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='seal') and status in ('1','2')",whereType:"",whereValue:""}
],
'device_trans_det':[
	{srcNodeId:"sel_device",destNodeId:"device_trans_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and vary_type='trans')",whereType:"",whereValue:""}
],
'device_unidle_det':[
	{srcNodeId:"sel_device",destNodeId:"device_unidle_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id \nand device_vary.auditing not in ('1','3') and device_vary.vary_type='unidle') and status in ('2','3','4')",whereType:"",whereValue:""}
],
'device_unseal_det':[
	{srcNodeId:"sel_device",destNodeId:"device_unseal_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from device_vary,device_vary_det where device_vary.vary_id=device_vary_det.vary_id and device_vary.auditing not in ('1','3') and device_vary.vary_type='unseal') and status in ('3')",whereType:"",whereValue:""}
],
'dm_fieldcfg':[
	{srcNodeId:"sel_fieldcfg",destNodeId:"dm_fieldcfg",layout:"",whereSql:"dm_fieldcfg.field_type = '0'",whereType:"",whereValue:""}
],
'event_domain_det':[
	{srcNodeId:"sys_event",destNodeId:"event_domain_det",layout:"",whereSql:"fun_id = 'sysevent' and event_index < 10000",whereType:"",whereValue:""}
],
'fun_attrdes':[
	{srcNodeId:"fun_attr",destNodeId:"fun_attrdes",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'fun_event':[
	{srcNodeId:"sys_event",destNodeId:"fun_event",layout:"",whereSql:"fun_id = 'sysevent' and event_index < 10000",whereType:"",whereValue:""}
],
'fun_tree':[
	{srcNodeId:"fun_tree",destNodeId:"fun_tree",layout:"",whereSql:"tree_id not in (select tree_id from fun_tree where fun_id = {FKEYID})",whereType:"",whereValue:""}
],
'insp_chk_dev':[
	{srcNodeId:"sel_device",destNodeId:"insp_chk_dev",layout:"",whereSql:"auditing in ('1','6') and device_id not in (select device_id from pm_pplan_dev where pplan_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'insp_din_dev':[
	{srcNodeId:"sel_device",destNodeId:"insp_din_dev",layout:"",whereSql:"auditing in ('1','6') and device_id not in (select device_id from pm_pdin_dev where pdin_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'insp_done_dev':[
	{srcNodeId:"sel_device",destNodeId:"insp_done_dev",layout:"",whereSql:"auditing in ('1','6') and device_id not in (select device_id from pm_pplan_dev where pplan_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'insp_plan_dev':[
	{srcNodeId:"sel_device",destNodeId:"insp_plan_dev",layout:"",whereSql:"auditing in ('1','6') and device_id not in (select device_id from pm_pplan_dev where pplan_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'insp_qry_dev':[
	{srcNodeId:"sel_device",destNodeId:"insp_qry_dev",layout:"",whereSql:"auditing in ('1','6') and device_id not in (select device_id from pm_pplan_dev where pplan_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'insure_event_loan_end':[
	{srcNodeId:"insure_pay",destNodeId:"insure_event_loan_end",layout:"",whereSql:"insure_pay.auditing in('1','3') and insure_pay.insure_pay_id not in (select insure_pay_id from insure_event_loan where insure_pay_id is not null)",whereType:"",whereValue:""}
],
'insure_policy_dev':[
	{srcNodeId:"sel_device",destNodeId:"insure_policy_dev",layout:"/public/layout/layout_tree.js",whereSql:"device_id NOT in (SELECT device_id from insure_policy_dev where policy_id= {FKEYID})  and auditing in ('1','3')",whereType:"",whereValue:""}
],
'insure_policy_list':[
	{srcNodeId:"device_card",destNodeId:"insure_policy_list",layout:"/public/layout/layout_tree.js",whereSql:"device_id NOT in (SELECT device_id from insure_policy_dev where policy_id= {FKEYID})",whereType:"",whereValue:""}
],
'lub_din_dev':[
	{srcNodeId:"sel_device",destNodeId:"lub_din_dev",layout:"",whereSql:"auditing in('1','6') and  device_id not in(select  device_id   from  pm_din_dev where din_id={FKEYID})",whereType:"",whereValue:""}
],
'lub_done_labor':[
	{srcNodeId:"sys_user",destNodeId:"lub_done_labor",layout:"",whereSql:"sys_user.user_id not in(select user_id from pm_plan_labor where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'lub_done_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"lub_done_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from pm_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'main_std_chgdet':[
	{srcNodeId:"main_std_item_sel",destNodeId:"main_std_chgdet",layout:"",whereSql:"std_item_id not in (select std_item_id from pm_std_itemchg where std_chg_id = {FKEYID})",whereType:"",whereValue:""}
],
'maint_din_dev':[
	{srcNodeId:"sel_device",destNodeId:"maint_din_dev",layout:"/public/layout/layout_tree.js",whereSql:"auditing in('1','6') and  device_id not in(select  device_id   from  pm_din_dev where din_id={FKEYID})",whereType:"",whereValue:""}
],
'maint_done_labor':[
	{srcNodeId:"sys_user",destNodeId:"maint_done_labor",layout:"",whereSql:"sys_user.user_id not in(select user_id from pm_plan_labor where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'maint_done_labor_check':[
	{srcNodeId:"sys_user",destNodeId:"maint_done_labor_check",layout:"",whereSql:"sys_user.user_id not in(select user_id from pm_plan_labor where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'maint_done_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"maint_done_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from pm_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'maint_done_sp_check':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"maint_done_sp_check",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from pm_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'oa_docs_obj':[
	{srcNodeId:"sys_user",destNodeId:"oa_docs_obj",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_docs_obj where obj_type = '1'  and right_type='0' and obj_id = user_id and docs_id = {FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sys_dept",destNodeId:"oa_docs_obj",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_docs_obj where obj_type = '0' and right_type='0' and obj_id = dept_id and docs_id = {FKEYID})",whereType:"",whereValue:""}
],
'oa_docs_obj1':[
	{srcNodeId:"sys_user",destNodeId:"oa_docs_obj1",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_docs_obj where obj_type = '1'  and right_type='1' and obj_id = user_id and docs_id = {FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sys_dept",destNodeId:"oa_docs_obj1",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_docs_obj where obj_type = '0'  and right_type='1' and obj_id = dept_id and docs_id = {FKEYID})",whereType:"",whereValue:""}
],
'oa_news_obj':[
	{srcNodeId:"sys_dept",destNodeId:"oa_news_obj",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_news_obj where obj_type = '0' and obj_id = dept_id and news_id = {FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sys_user",destNodeId:"oa_news_obj",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select * from oa_news_obj where obj_type = '1' and obj_id = user_id and news_id = {FKEYID})",whereType:"",whereValue:""}
],
'outsourcing_pay_det':[
	{srcNodeId:"sel2_rep_invoice_det2",destNodeId:"outsourcing_pay_det",layout:"",whereSql:"invoice_det_id not in (select invoice_det_id from outsourcing_pay_det)",whereType:"",whereValue:""}
],
'outsourcing_sp_det':[
	{srcNodeId:"rep_out_spsel",destNodeId:"outsourcing_sp_det",layout:"",whereSql:"rep_out_sp.out_sp_id not in (select out_sp_id from outsourcing_sp_det)",whereType:"",whereValue:""}
],
'pay_apply_det':[
	{srcNodeId:"con_pay_imp",destNodeId:"pay_apply_det",layout:"",whereSql:"pay_id not in (select pay_id from pay_apply_det where apply_id ={FKEYID})",whereType:"",whereValue:""}
],
'pay_apply_det_xd':[
	{srcNodeId:"con_pay_imp",destNodeId:"pay_apply_det_xd",layout:"",whereSql:"pay_id not in (select pay_id from pay_apply_det where apply_id ={FKEYID})",whereType:"",whereValue:""}
],
'pay_apply_dev':[
	{srcNodeId:"prop_box_det_imp",destNodeId:"pay_apply_dev",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'pay_apply_invoice':[
	{srcNodeId:"pay_invoice_imp",destNodeId:"pay_apply_invoice",layout:"",whereSql:"pay_invoice_id not in (select pay_invoice_id from pay_apply_invoice where apply_id ={FKEYID})",whereType:"",whereValue:""}
],
'pay_apply_invoice_xd':[
	{srcNodeId:"pay_invoice_det_imp",destNodeId:"pay_apply_invoice_xd",layout:"",whereSql:"invoice_det_id not in (select invoice_det_id from pay_apply_invoice where apply_id ={FKEYID} and invoice_det_id is not null)",whereType:"",whereValue:""}
],
'pay_invoice_dev':[
	{srcNodeId:"prop_box_det_imp",destNodeId:"pay_invoice_dev",layout:"",whereSql:"box_det_id not in (select box_det_id from pay_invoice_dev where box_det_id is not null) and is_invoice = '0'",whereType:"",whereValue:""}
],
'pay_provider_det':[
	{srcNodeId:"rep_provider_det_sel",destNodeId:"pay_provider_det",layout:"",whereSql:"provider_det_id not in (select provider_det_id from  pay_provider_det where provider_det_id is not null)",whereType:"",whereValue:""}
],
'pay_provider_det3':[
	{srcNodeId:"rep_out_spsel",destNodeId:"pay_provider_det3",layout:"",whereSql:"rep_out_sp.out_sp_id not in (select out_sp_id from pay_provider_det where out_sp_id is not null)",whereType:"",whereValue:""}
],
'pchk_din_dev':[
	{srcNodeId:"sel_device",destNodeId:"pchk_din_dev",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in(select  device_id   from  pm_din_dev where din_id={FKEYID})",whereType:"",whereValue:""}
],
'pchk_done_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"pchk_done_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from pm_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'pchk_done_sp_check':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"pchk_done_sp_check",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from pm_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'pchk_std_itemchg':[
	{srcNodeId:"pchk_std_item_sel",destNodeId:"pchk_std_itemchg",layout:"",whereSql:"pm_std_item.std_item_id not in (select std_item_id from pm_std_itemchg where std_chg_id ={FKEYID})",whereType:"",whereValue:""}
],
'plet_fun':[
	{srcNodeId:"sel_fun",destNodeId:"plet_fun",layout:"/public/layout/layout_tree.js",whereSql:"reg_type in ('main','treemain')",whereType:"",whereValue:""}
],
'plet_portlet':[
	{srcNodeId:"sel_plettype",destNodeId:"plet_portlet",layout:"",whereSql:"not exists (select * from plet_portlet where plet_portlet.type_id = v_plet_type.type_id and plet_portlet.templet_id = {FKEYID})",whereType:"",whereValue:""}
],
'prop_apply_det':[
	{srcNodeId:"sel_device",destNodeId:"prop_apply_det",layout:"/public/layout/layout_tree.js",whereSql:"auditing in ('1','3')",whereType:"",whereValue:""}
],
'prop_box':[
	{srcNodeId:"prop_order_imp",destNodeId:"prop_box",layout:"",whereSql:"order_det_id not in(select order_det_id from prop_box where auditing='0' and order_det_id  is not null)",whereType:"",whereValue:""}
],
'prop_box_sp':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"prop_box_sp",layout:"/public/layout/layout_tree.js",whereSql:"sp_id not in (select sp_id from prop_box_sp where box_id={FKEYID} and sp_id is not null)",whereType:"",whereValue:""}
],
'prop_budget_adddet':[
	{srcNodeId:"prop_budget_det",destNodeId:"prop_budget_adddet",layout:"",whereSql:"budget_det_id not in (SELECT budget_det_id FROM prop_budget_adddet WHERE budget_add_id= {FKEYID})",whereType:"",whereValue:""}
],
'prop_budget_chgdet':[
	{srcNodeId:"prop_budget_det",destNodeId:"prop_budget_chgdet",layout:"",whereSql:"budget_det_id not in (SELECT budget_det_id FROM prop_budget_chgdet WHERE budget_chg_id= {FKEYID})",whereType:"",whereValue:""}
],
'prop_cancellation':[
	{srcNodeId:"imp_prop_provider",destNodeId:"prop_cancellation",layout:"",whereSql:"prop_provider.version_status='2'  and source_system ='30' and prop_provider.auditing='1'  and provider_id not in(select provider_id from prop_provider_can)",whereType:"",whereValue:""}
],
'prop_contract_cc':[
	{srcNodeId:"prop_order_sel",destNodeId:"prop_contract_cc",layout:"/public/layout/layout_main.js",whereSql:"not exists (select order_det_id from prop_contract_det where prop_order_det.order_det_id = prop_contract_det.order_det_id)",whereType:"",whereValue:""}
],
'prop_contract_det':[
	{srcNodeId:"prop_order_sel",destNodeId:"prop_contract_det",layout:"/public/layout/layout_main.js",whereSql:"not exists (select order_det_id from prop_contract_det where prop_order_det.order_det_id = prop_contract_det.order_det_id)",whereType:"",whereValue:""}
],
'prop_install':[
	{srcNodeId:"prop_box_imp",destNodeId:"prop_install",layout:"",whereSql:"box_det_id not in(select box_det_id from prop_install where box_det_id is not null)",whereType:"",whereValue:""}
],
'prop_notice_det':[
	{srcNodeId:"prop_contract_cc",destNodeId:"prop_notice_det",layout:"",whereSql:"contract_det_id  not in (select contract_det_id from prop_notice_det where notice_id={FKEYID})",whereType:"",whereValue:""}
],
'prop_order':[
	{srcNodeId:"prop_apply",destNodeId:"prop_order",layout:"",whereSql:"auditing in ('1','3') and apply_id not in (select apply_id from prop_order where apply_id is not null)",whereType:"",whereValue:""}
],
'prop_project_turn':[
	{srcNodeId:"prop_box_det_imp",destNodeId:"prop_project_turn",layout:"",whereSql:"box_det_id not in (select box_det_id from check_asset where box_det_id is not null)  and device_code is not null",whereType:"",whereValue:""}
],
'pur_user':[
	{srcNodeId:"sys_user",destNodeId:"pur_user",layout:"/public/layout/layout_tree.js",whereSql:"user_id  not in (SELECT user_id  from pur_user )",whereType:"",whereValue:""}
],
'rep_apply_invoice':[
	{srcNodeId:"pay_invoice_imp",destNodeId:"rep_apply_invoice",layout:"",whereSql:"pay_invoice_id not in (select pay_invoice_id from pay_apply_invoice where apply_id ={FKEYID})",whereType:"",whereValue:""}
],
'rep_category_user':[
	{srcNodeId:"sys_user",destNodeId:"rep_category_user",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (SELECT user_id FROM rep_category_user WHERE category_id ={FKEYID})",whereType:"",whereValue:""}
],
'rep_device_sel':[
	{srcNodeId:"sel_device",destNodeId:"rep_device_sel",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from rep_device_type)",whereType:"",whereValue:""}
],
'rep_device_type':[
	{srcNodeId:"sel_device",destNodeId:"rep_device_type",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from rep_device_type)",whereType:"",whereValue:""}
],
'rep_fault_chk_labor':[
	{srcNodeId:"sys_user",destNodeId:"rep_fault_chk_labor",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select labor_id from rep_fault_labor where fault_id = {FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_chk_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_fault_chk_sp",layout:"",whereSql:"store_num>0 and sp_id not in (select sp_id from rep_plan_sp where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_chksp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_fault_chksp",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_fault_sp where sp_house_id is not null and fault_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_chkte':[
	{srcNodeId:"sp_store_sel",destNodeId:"rep_fault_chkte",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and other_code not in (select other_code from rep_fault_te where other_code is not null and fault_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_labor':[
	{srcNodeId:"sys_user",destNodeId:"rep_fault_labor",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select labor_id from rep_fault_labor where fault_id = {FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_order':[
	{srcNodeId:"rep_memo",destNodeId:"rep_fault_order",layout:"",whereSql:"auditing ='1'  and  memo_id not in (select memo_id  from  rep_fault  where memo_id  is not null)",whereType:"",whereValue:""}
],
'rep_fault_qry_labor':[
	{srcNodeId:"sys_user",destNodeId:"rep_fault_qry_labor",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select labor_id from rep_fault_labor where fault_id = {FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_qry_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_fault_qry_sp",layout:"",whereSql:"store_num>0 and sp_id not in (select sp_id from rep_plan_sp where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_fault_sp",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_fault_sp where sp_house_id is not null and fault_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_te':[
	{srcNodeId:"sp_store_sel",destNodeId:"rep_fault_te",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and other_code not in (select other_code from rep_fault_te where other_code is not null and fault_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_fault_teww':[
	{srcNodeId:"sp_catalog_lt",destNodeId:"rep_fault_teww",layout:"/public/layout/layout_tree_main.js",whereSql:"",whereType:"",whereValue:""}
],
'rep_invoice_det2':[
	{srcNodeId:"sel_rep_invoice_det2",destNodeId:"rep_invoice_det2",layout:"",whereSql:"noaccount_money>0 and invoice_code not in (select invoice_code from pay_invoice_det2 where invoice_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_invoice_det3':[
	{srcNodeId:"sel_rep_invoice_det2",destNodeId:"rep_invoice_det3",layout:"",whereSql:"noaccount_money>0 and invoice_code not in (select invoice_code from pay_invoice_det2 where invoice_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_invoice_dev':[
	{srcNodeId:"rep_out_imp",destNodeId:"rep_invoice_dev",layout:"",whereSql:"dev_id  not in (select box_det_id from pay_invoice_dev where box_det_id is not null)",whereType:"",whereValue:""}
],
'rep_out_qry_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_out_qry_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_out_sp where out_id={FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sp_catalog_sel",destNodeId:"rep_out_qry_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"sp_id not in (select sp_id from rep_out_sp where out_id={FKEYID} and sp_house_id is null)",whereType:"",whereValue:""}
],
'rep_out_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_out_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_out_sp where out_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'rep_outsp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_outsp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_out_sp where out_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""}
],
'rep_plan_can':[
	{srcNodeId:"rep_plan_sel",destNodeId:"rep_plan_can",layout:"",whereSql:"rep_plan.plan_id not in (select plan_id from rep_plan_can)",whereType:"",whereValue:""}
],
'rep_plan_chg':[
	{srcNodeId:"rep_plan_sel",destNodeId:"rep_plan_chg",layout:"",whereSql:"rep_plan.plan_id not in (select plan_id from rep_plan_chg where auditing not in ('1','3'))",whereType:"",whereValue:""}
],
'rep_plan_chg_sp':[
	{srcNodeId:"device_sp_store_sel",destNodeId:"rep_plan_chg_sp",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_chg_sp where sp_house_id is not null and chg_id={FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_plan_chg_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_chg_sp where sp_house_id is not null and chg_id={FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sp_catalog_sel",destNodeId:"rep_plan_chg_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"sp_id not in (select sp_id from rep_plan_chg_sp where chg_id={FKEYID} and sp_house_id is null)",whereType:"",whereValue:""}
],
'rep_plan_exe_sp':[
	{srcNodeId:"device_sp_store_sel",destNodeId:"rep_plan_exe_sp",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_plan_exe_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sp_catalog_sel",destNodeId:"rep_plan_exe_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"sp_id not in (select sp_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is null)",whereType:"",whereValue:""}
],
'rep_plan_labor':[
	{srcNodeId:"sys_user",destNodeId:"rep_plan_labor",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select user_id from rep_plan_labor where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_plan_qry_labor':[
	{srcNodeId:"sys_user",destNodeId:"rep_plan_qry_labor",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select user_id from rep_plan_labor where plan_id={FKEYID})",whereType:"",whereValue:""}
],
'rep_plan_qry_sp':[
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_plan_qry_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_sp where plan_id={FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sp_catalog_sel",destNodeId:"rep_plan_qry_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"sp_id not in (select sp_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is null)",whereType:"",whereValue:""}
],
'rep_plan_sp':[
	{srcNodeId:"device_sp_store_sel",destNodeId:"rep_plan_sp",layout:"/public/layout/layout_tree.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sp_store_house_sel",destNodeId:"rep_plan_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"store_num>0 and sp_house_id not in (select sp_house_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is not null)",whereType:"",whereValue:""},
	{srcNodeId:"sp_catalog_sel",destNodeId:"rep_plan_sp",layout:"/public/layout/layout_tree_main.js",whereSql:"sp_id not in (select sp_id from rep_plan_sp where plan_id={FKEYID} and sp_house_id is null)",whereType:"",whereValue:""}
],
'rep_provider_det':[
	{srcNodeId:"rep_out_spsel",destNodeId:"rep_provider_det",layout:"",whereSql:"rep_out_sp.out_sp_id not in (select out_sp_id from rep_provider_det)",whereType:"",whereValue:""}
],
'rep_provider_det_sel':[
	{srcNodeId:"rep_out_spsel",destNodeId:"rep_provider_det_sel",layout:"",whereSql:"rep_out_sp.out_sp_id not in (select out_sp_id from rep_provider_det)",whereType:"",whereValue:""}
],
'rpt_detailwf':[
	{srcNodeId:"rpt_wfnode",destNodeId:"rpt_detailwf",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'run_empt_det':[
	{srcNodeId:"sys_user",destNodeId:"run_empt_det",layout:"/public/layout/layout_tree.js",whereSql:"not exists (select user_code from run_empt_det where sys_user.user_code = run_empt_det.user_code and train_id = {FKEYID})",whereType:"",whereValue:""}
],
'run_record_det':[
	{srcNodeId:"sel_devicecard",destNodeId:"run_record_det",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from run_record where device_record_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'run_record_qry':[
	{srcNodeId:"sel_devicecard",destNodeId:"run_record_qry",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from run_record where device_record_id={FKEYID} and device_id is not null)",whereType:"",whereValue:""}
],
'sel2_rep_invoice_det2':[
	{srcNodeId:"sel_rep_invoice_det2",destNodeId:"sel2_rep_invoice_det2",layout:"",whereSql:"noaccount_money>0 and invoice_code not in (select invoice_code from pay_invoice_det2 where invoice_id={FKEYID})",whereType:"",whereValue:""}
],
'sel_device_line_det':[
	{srcNodeId:"sel_device",destNodeId:"sel_device_line_det",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'sel_funcol':[
	{srcNodeId:"sel_field",destNodeId:"sel_funcol",layout:"/jxstar/studio/pub/layout_selfield.js",whereSql:"",whereType:"",whereValue:""}
],
'sel_hire_det':[
	{srcNodeId:"sel_device",destNodeId:"sel_hire_det",layout:"/public/layout/layout_tree_cloud.js",whereSql:"device_id not in (select device_hire_det.device_id from device_hire,device_hire_det where device_hire_det.hire_id=device_hire.hire_id and device_hire_det.hire_end_date is null)",whereType:"",whereValue:""}
],
'sel_rend_det':[
	{srcNodeId:"sel_device",destNodeId:"sel_rend_det",layout:"",whereSql:"status='1' and device_id not in (select device_id from device_rend_det where auditing not in ('1','3'))",whereType:"",whereValue:""}
],
'sel_sp_in_check':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sel_sp_in_check",layout:"/public/layout/layout_tree.js",whereSql:"sp_id not in (select aa.sp_id from sp_in_det aa,sp_catalog bb where aa.sp_id =bb.sp_id  and  aa.sp_id is not null and aa.collect_det_id is null and aa.in_id= {FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sp_collect_det_sel",destNodeId:"sel_sp_in_check",layout:"/public/layout/layout_main.js",whereSql:"noarrive_num > 0 and sp_status in ('40','70') and  collect_det_id not in (select aa.collect_det_id from sp_in_det aa,view_sp_collect_det bb where aa.collect_det_id = bb.collect_det_id and aa.collect_det_id is not null and aa.in_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_adjust_det':[
	{srcNodeId:"sel_sp_adjust",destNodeId:"sp_adjust_det",layout:"",whereSql:"src_id not in (select src_id from sp_adjust_det where adjust_id={FKEYID})",whereType:"",whereValue:""}
],
'sp_apply_det':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_apply_det",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sp_apply_det where sp_apply_det.sp_id =sp_catalog.sp_id and  sp_apply_det.sp_id is not null and sp_apply_det.apply_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_collect_chgdet':[
	{srcNodeId:"sp_collect_det_qry",destNodeId:"sp_collect_chgdet",layout:"/public/layout/layout_main.js",whereSql:"collect_det_id not in (select collect_det_id from sp_collect_chgdet where chg_id= {FKEYID})",whereType:"",whereValue:""}
],
'sp_collect_det':[
	{srcNodeId:"sp_request_det_sel",destNodeId:"sp_collect_det",layout:"/public/layout/layout_main.js",whereSql:"sp_status='20' and view_sp_request_collect.request_det_id not in (select request_det_id  from sp_collect_request) and view_sp_request_collect.house_id = (select house_id from sp_collect where collect_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_collect_det_qry':[
	{srcNodeId:"sp_request_det_sel",destNodeId:"sp_collect_det_qry",layout:"/public/layout/layout_main.js",whereSql:"sp_status='20' and view_sp_request_collect.request_det_id not in (select request_det_id  from sp_collect_request) and view_sp_request_collect.house_id = (select house_id from sp_collect where collect_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_collect_det_qry2':[
	{srcNodeId:"sp_request_det_sel",destNodeId:"sp_collect_det_qry2",layout:"/public/layout/layout_main.js",whereSql:"sp_status='20' and view_sp_request_collect.request_det_id not in (select request_det_id  from sp_collect_request) and view_sp_request_collect.house_id = (select house_id from sp_collect where collect_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_in_check_det':[
	{srcNodeId:"sp_collect_det_sel",destNodeId:"sp_in_check_det",layout:"",whereSql:"collect_det_id not in (select aa.collect_det_id from sp_in_det aa where aa.collect_det_id is not null and aa.in_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_in_other':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_in_other",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'sp_in_other_det':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_in_other_det",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sp_in_det where  sp_in_det.in_id = {FKEYID})  and left(sp_code, 2) <> 16",whereType:"",whereValue:""}
],
'sp_invoice_det':[
	{srcNodeId:"sel_sp_invoice_det",destNodeId:"sp_invoice_det",layout:"",whereSql:"noaccount_money>0 and invoice_code not in (select invoice_code from sp_invoice_det where invoice_id={FKEYID})",whereType:"",whereValue:""}
],
'sp_invoice_detail':[
	{srcNodeId:"sel_sp_in_det",destNodeId:"sp_invoice_detail",layout:"",whereSql:"in_det_id not in (select in_det_id from sp_invoice_detail where  in_num>0)",whereType:"",whereValue:""},
	{srcNodeId:"sp_instore_return",destNodeId:"sp_invoice_detail",layout:"",whereSql:"sp_return_det.out_num>0 and sp_in_det.in_det_id not in (select in_det_id from sp_invoice_detail  where in_num<0)",whereType:"",whereValue:""},
	{srcNodeId:"gas_card_list",destNodeId:"sp_invoice_detail",layout:"",whereSql:"card_id not in (select in_det_id from sp_invoice_detail where invoice_id={FKEYID})",whereType:"",whereValue:""}
],
'sp_move_det':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_move_det",layout:"/public/layout/layout_tree_main.js",whereSql:"store_id not in(select store_id from sp_move_det where move_id={FKEYID}) and store_num > 0",whereType:"",whereValue:""}
],
'sp_out_appdet':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_out_appdet",layout:"/public/layout/layout_tree_main.js",whereSql:"store_id not in(select store_id from sp_out_appdet where out_id={FKEYID}) and (store_num-frozen_number) > 0",whereType:"",whereValue:""}
],
'sp_out_det':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_out_det",layout:"/public/layout/layout_tree.js",whereSql:"store_id not in(select store_id from sp_out_det where out_id={FKEYID}) and (store_num-frozen_number) > 0",whereType:"",whereValue:""}
],
'sp_pay_det':[
	{srcNodeId:"sel_sp_in_det",destNodeId:"sp_pay_det",layout:"",whereSql:"in_det_id not in (select in_det_id from sp_pay_det)",whereType:"",whereValue:""},
	{srcNodeId:"gas_card_list",destNodeId:"sp_pay_det",layout:"",whereSql:"card_id not in (select in_det_id from sp_pay_det)",whereType:"",whereValue:""},
	{srcNodeId:"sp_collect_det_qry2",destNodeId:"sp_pay_det",layout:"",whereSql:"collect_det_id not in (select in_det_id from sp_pay_det)",whereType:"",whereValue:""}
],
'sp_pay_invoice':[
	{srcNodeId:"sel_sp_invoice_det",destNodeId:"sp_pay_invoice",layout:"",whereSql:"invoice_det_id not in (select invoice_det_id from sp_pay_invoice where pay_id={FKEYID}) and sp_invoice_det.is_payed='0'",whereType:"",whereValue:""}
],
'sp_protocol_det':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_protocol_det",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sp_protocol_det where protocol_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_provider_det':[
	{srcNodeId:"sel_sp_in_det",destNodeId:"sp_provider_det",layout:"",whereSql:"in_det_id not in (select in_det_id from sp_provider_det where in_num>0)",whereType:"",whereValue:""},
	{srcNodeId:"sp_instore_return",destNodeId:"sp_provider_det",layout:"",whereSql:"sp_return_det.out_num>0 and sp_in_det.in_det_id not in (select in_det_id from sp_provider_det where in_num<0)",whereType:"",whereValue:""},
	{srcNodeId:"gas_card_list",destNodeId:"sp_provider_det",layout:"",whereSql:"card_id not in (select in_det_id from sp_provider_det)",whereType:"",whereValue:""}
],
'sp_refund_det':[
	{srcNodeId:"sp_out_sel",destNodeId:"sp_refund_det",layout:"",whereSql:"out_det_id not in (select out_det_id from  sp_refund_det where refund_id ={FKEYID})",whereType:"",whereValue:""}
],
'sp_replace_det':[
	{srcNodeId:"sel_sp_collect_det",destNodeId:"sp_replace_det",layout:"",whereSql:"collect_id in (select collect_id  from sp_replace where replace_id ={FKEYID})",whereType:"",whereValue:""}
],
'sp_replace_detail':[
	{srcNodeId:"sel_sp_collect_det",destNodeId:"sp_replace_detail",layout:"",whereSql:"collect_id in (select collect_id  from sp_replace where replace_id ={FKEYID})",whereType:"",whereValue:""}
],
'sp_request_det':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_request_det",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sp_request_det where sp_request_det.sp_id is not null and sp_request_det.request_id = {FKEYID}) and (case when {CURDEPTID} not like '2001000200050001%' then sp_catalog.sp_code not like '16%' else 1=1 end)",whereType:"",whereValue:""}
],
'sp_request_qry':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_request_qry",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sp_request_det where sp_request_det.sp_id =sp_catalog.sp_id and  sp_request_det.sp_id is not null and sp_request_det.request_id = {FKEYID})",whereType:"",whereValue:""}
],
'sp_return_det':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_return_det",layout:"/public/layout/layout_tree_main.js",whereSql:"store_id not in(select store_id from sp_return_det where return_id={FKEYID}) and store_num > 0",whereType:"",whereValue:""}
],
'sp_scarp_out_det':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_scarp_out_det",layout:"/public/layout/layout_tree_main.js",whereSql:"store_id not in(select store_id from sp_out_det where out_id={FKEYID}) and store_num > 0",whereType:"",whereValue:""}
],
'sp_trans_det':[
	{srcNodeId:"sp_store_sel",destNodeId:"sp_trans_det",layout:"/public/layout/layout_tree_main.js",whereSql:"store_id not in(select store_id from sp_trans_det where trans_id={FKEYID}) and store_num > 0",whereType:"",whereValue:""}
],
'sp_uncode':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_uncode",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_code not in(select sp_uncode.sp_code from sp_uncode)",whereType:"",whereValue:""}
],
'sp_unit_convert':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sp_unit_convert",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'spec_pusecard':[
	{srcNodeId:"spec_pressure_sel",destNodeId:"spec_pusecard",layout:"",whereSql:"pressure_id not in (select pressure_id from spec_pusecard where auditing = '0')",whereType:"",whereValue:""}
],
'special_issue_appointuser':[
	{srcNodeId:"gsys_user_dept",destNodeId:"special_issue_appointuser",layout:"",whereSql:"sys_user.user_id not in (select edit_userid from special_matters where issue_user_id ={FKEYID})",whereType:"",whereValue:""}
],
'sys_board':[
	{srcNodeId:"sys_user",destNodeId:"sys_board",layout:"/public/layout/layout_tree.js",whereSql:"user_id not in (select user_id from sys_board)",whereType:"",whereValue:""}
],
'sys_company_headuser':[
	{srcNodeId:"gsys_user_dept",destNodeId:"sys_company_headuser",layout:"",whereSql:"sys_user.user_id not in (select user_id from sys_company_headuser where company_code={FKEYID})",whereType:"",whereValue:""}
],
'sys_company_user':[
	{srcNodeId:"gsys_user_dept",destNodeId:"sys_company_user",layout:"",whereSql:"sys_user.user_id not in (select user_id from sys_company_user where company_code={FKEYID})",whereType:"",whereValue:""}
],
'sys_consume_sp':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sys_consume_sp",layout:"/public/layout/layout_tree.js",whereSql:"sp_catalog.sp_id not in (select sp_id from sys_consume_sp)",whereType:"",whereValue:""}
],
'sys_cost_device':[
	{srcNodeId:"sel_device",destNodeId:"sys_cost_device",layout:"/public/layout/layout_tree.js",whereSql:"device_id NOT in (SELECT device_id from sys_cost_device)",whereType:"",whereValue:""}
],
'sys_cost_sp':[
	{srcNodeId:"sp_catalog_sel",destNodeId:"sys_cost_sp",layout:"/public/layout/layout_tree.js",whereSql:"",whereType:"",whereValue:""}
],
'sys_fun_col':[
	{srcNodeId:"sel_field",destNodeId:"sys_fun_col",layout:"/jxstar/studio/pub/layout_selfield.js",whereSql:"",whereType:"",whereValue:""}
],
'sys_post_user':[
	{srcNodeId:"sys_user",destNodeId:"sys_post_user",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.is_novalid = '0' and not exists (select * from sys_post_user where sys_user.user_id = sys_post_user.user_id and post_id = {FKEYID})",whereType:"",whereValue:""}
],
'sys_qrydet':[
	{srcNodeId:"sel_fun_col",destNodeId:"sys_qrydet",layout:"",whereSql:"fun_col.col_index < 10000",whereType:"",whereValue:""}
],
'sys_role_data':[
	{srcNodeId:"sys_datatype",destNodeId:"sys_role_data",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'sys_role_field':[
	{srcNodeId:"sel_fun_col",destNodeId:"sys_role_field",layout:"",whereSql:"col_code not like '%id'",whereType:"",whereValue:""}
],
'sys_role_fun':[
	{srcNodeId:"sel_fun",destNodeId:"sys_role_fun",layout:"/public/layout/layout_tree.js",whereSql:"reg_type in ('main', 'treemain', 'selfun', 'result','other') and module_id not like '1010%'",whereType:"",whereValue:""}
],
'sys_role_user':[
	{srcNodeId:"sys_user",destNodeId:"sys_role_user",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.is_novalid = '0'",whereType:"",whereValue:""}
],
'sys_target_device':[
	{srcNodeId:"sel_device",destNodeId:"sys_target_device",layout:"/public/layout/layout_tree.js",whereSql:"device_id not in (select device_id from sys_target_device)",whereType:"",whereValue:""}
],
'sys_user_data':[
	{srcNodeId:"sys_datatype",destNodeId:"sys_user_data",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'sys_user_funx':[
	{srcNodeId:"sel_fun",destNodeId:"sys_user_funx",layout:"/public/layout/layout_tree.js",whereSql:"reg_type in ('main', 'treemain', 'selfun')",whereType:"",whereValue:""}
],
'sys_user_manageorg':[
	{srcNodeId:"sys_dept",destNodeId:"sys_user_manageorg",layout:"/public/layout/layout_tree.js",whereSql:"sys_dept.dept_id not in (select dept_id from sys_user_manageorg where user_id={FKEYID})",whereType:"",whereValue:""}
],
'sys_user_manageorg_chg':[
	{srcNodeId:"sys_dept",destNodeId:"sys_user_manageorg_chg",layout:"/public/layout/layout_tree.js",whereSql:"sys_dept.dept_id not in (select dept_id from sys_user_manageorg where user_id={FKEYID})",whereType:"",whereValue:""}
],
'sys_user_role':[
	{srcNodeId:"sys_role",destNodeId:"sys_user_role",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'sys_warnrole':[
	{srcNodeId:"sys_role",destNodeId:"sys_warnrole",layout:"",whereSql:"role_id not in (select role_id from warn_role where warn_id={FKEYID})",whereType:"",whereValue:""}
],
'sys_warnuser':[
	{srcNodeId:"sys_user",destNodeId:"sys_warnuser",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.is_novalid = '0' and not exists (select * from warn_user where sys_user.user_id = warn_user.user_id and warn_id = {FKEYID})",whereType:"",whereValue:""}
],
'tenant_issue_appointuser':[
	{srcNodeId:"gsys_user_dept",destNodeId:"tenant_issue_appointuser",layout:"",whereSql:"sys_user.user_id not in (select edit_userid from tenant_issue_report where issue_user_id ={FKEYID})",whereType:"",whereValue:""}
],
'wf_free_user':[
	{srcNodeId:"sys_user",destNodeId:"wf_free_user",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.is_novalid = '0'",whereType:"",whereValue:""}
],
'wf_node_field':[
	{srcNodeId:"sel_funcol",destNodeId:"wf_node_field",layout:"",whereSql:"not exists (select * from wf_node_field where wf_node_field.col_code = fun_col.col_code and wfnode_id = {FKEYID})",whereType:"",whereValue:""}
],
'wf_order_detcol':[
	{srcNodeId:"sel_funcol",destNodeId:"wf_order_detcol",layout:"",whereSql:"not exists (select * from wf_order_detcol where wf_order_detcol.detail_id = {FKEYID} and  fun_col.col_code = wf_order_detcol.field_name)",whereType:"",whereValue:""}
],
'wf_order_field':[
	{srcNodeId:"sel_funcol",destNodeId:"wf_order_field",layout:"",whereSql:"not exists (select * from wf_order_field where wf_order_field.order_id = {FKEYID} and  fun_col.col_code = wf_order_field.field_name)",whereType:"",whereValue:""}
],
'wf_order_node':[
	{srcNodeId:"wf_node",destNodeId:"wf_order_node",layout:"",whereSql:"",whereType:"",whereValue:""}
],
'wf_temp_user':[
	{srcNodeId:"sys_user",destNodeId:"wf_temp_user",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.user_id not in (select assign_userid from wf_temp_user where tmp_nodeid = {FKEYID})",whereType:"",whereValue:""}
],
'wf_user':[
	{srcNodeId:"sys_user",destNodeId:"wf_user",layout:"/public/layout/layout_tree.js",whereSql:"sys_user.is_novalid = '0' and not exists (select * from wf_user where sys_user.user_id = wf_user.user_id and nodeattr_id = {FKEYID})",whereType:"",whereValue:""},
	{srcNodeId:"sys_post",destNodeId:"wf_user",layout:"",whereSql:"sys_post.auditing = '0' and not exists (select * from wf_user where sys_post.post_id = wf_user.user_id and nodeattr_id = {FKEYID})",whereType:"",whereValue:""}
]
};