流程怎么做判断?

shuaigej

引用了阿

cgrddv

shuaigej 发表于 2016-9-29 14:56
引用了阿

还有ontology里的config.xml，也引用他。还有可能就是没有识别过来，你先删除掉那个引用，保存+编译，然后再增加引用

shuaigej

cgrddv 发表于 2016-9-29 15:17
还有ontology里的config.xml，也引用他。还有可能就是没有识别过来，你先删除掉那个引用，保存+编译，然后 ...

如是做了，还是报这个错

zhaixin

在process文件中引用fn所在目录，就可以了，如果有问题，发一下fn的定义和对应的java文件

shuaigej

<?xml version="1.0" encoding="UTF-8"?>
<model xmlns="http://www.justep.com/model">
<fn name="list" category="自定义函数" code-model="/gdms/baoxiu/logic/code" type="Boolean" code="list1.getlist"><label language="zh_CN">获取设备报修派遣员名单</label>

<parameter type="String" name="id"></parameter>
</fn>
</model>



java文件:
public class list1 {
        public static List<List<String>> getlist(String id) {
      
        String query_alias = "select a.Fix_type_id  from FIXMNG_MAIN a where a= '" +id+ "'";
        Table table_alias = KSQL.select(query_alias, null, "/gdms/baoxiu/data", null);
        Iterator<Row> it_alias = table_alias.iterator();
        String Type_name="";
      
        while (it_alias.hasNext()){
              
               Row r_alias = it_alias.next();        
                 
                   Object v_alias = r_alias.getValue("Fix_type_id");
                  if (v_alias !=null)
                   {
                 
                 
                       Type_name = v_alias.toString();
               }
               }
   
        String query_alias1 = "select a.stuff_en  from FIXMNG_TYPE a where a.Type_name= '" +Type_name+ "'";
        Table table_alias1 = KSQL.select(query_alias1, null, "/gdms/baoxiu/data", null);
        Iterator<Row> it_alias1 = table_alias1.iterator();
        String userid1="";
      
        while (it_alias1.hasNext()){
              
               Row r_alias1 = it_alias1.next();        
                 
                   Object v_alias1 = r_alias1.getValue("stuff_en");
                  if (v_alias1 !=null)
                   {
                 
                 
                    userid1 = v_alias1.toString();
               }
               }
        String[] arrayStr =new String[]{};

        arrayStr = userid1.split(",");
        List list1 = java.util.Arrays.asList(arrayStr);
        return list1;
        }
}

jishuang

你定义的函数名是list不是stufflist啊

shuaigej

stufflist是我的fn名阿

jishuang

看你的fn定义

shuaigej

噢噢,我改了名字,现在不报错了,但是没有取到值,控制台sql输出:
2016-10-09 10:31:24 [SQL Time]sql 执行时间：2ms, exec KSQL: select SA_Task.sName, SA_Task.sProcess, SA_Task.sActivity, SA_Task.sFlowID from SA_Task SA_Task where SA_Task='85B9C89426AE47E69752EEF4754B644E'
  --> sql:SELECT  SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess, SA_Task.SACTIVITY AS sActivity, SA_Task.SFLOWID AS sFlowID FROM SA_Task SA_Task  WHERE SA_Task.sID = ?
--> binds:[85B9C89426AE47E69752EEF4754B644E]

2016-10-09 10:31:24 [SQL Time]sql 执行时间：1ms, exec KSQL: select tr.sTaskID1, tr.sTaskID2 from SA_TaskRelation tr where tr.sTaskID1=:tid0 or tr.sTaskID1=:tid1 or tr.sTaskID1=:tid2
  --> sql:SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TaskRelation tr  WHERE  (tr.STASKID1 =  ? ) OR (tr.STASKID1 =  ? ) OR (tr.STASKID1 =  ? )
--> binds:[A4FA19ACFD9E4C9A82B6244F766DF608, 85B9C89426AE47E69752EEF4754B644E, 958617AAD9E344C699EC67EACF20509E]
2016-10-09 10:31:24 [SQL Time]sql 执行时间：1ms, exec KSQL: select t, t.sProcessTemplateID2, t.sProcess, t.sProcessInstanceID, t.sPlace, t.sFromActivity, t.sFromActivityInstanceID, t.sToActivity, t.sToActivityInstanceID, t.sValue, t.sActive from SA_TokenInstance t where t.sProcessInstanceID = :flowID
  --> sql:SELECT  t.sID, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SPROCESS AS sProcess, t.SPROCESSINSTANCEID AS sProcessInstanceID, t.SPLACE AS sPlace, t.SFROMACTIVITY AS sFromActivity, t.SFROMACTIVITYINSTANCEID AS sFromActivityInstanceID, t.STOACTIVITY AS sToActivity, t.STOACTIVITYINSTANCEID AS sToActivityInstanceID, t.SVALUE AS sValue, t.SACTIVE AS sActive FROM SA_TokenInstance t  WHERE t.SPROCESSINSTANCEID =  ?
--> binds:[958617AAD9E344C699EC67EACF20509E]
2016-10-09 10:31:24 [SQL Time]sql 执行时间：1ms, exec KSQL: select c.sContent from SA_ProcessControl c where c.sProcess='/gdms/baoxiu/process/baoxiu/baoxiuProcess' and c.sActivity='businessActivity2' and c.sOperatorID='v1CptZ5LnDkkineUcXV' and c.sAction='advanceProcessAction' and (c.sProcessTemplateID2 IS NULL or c.sProcessTemplateID2 = '')
  --> sql:SELECT  c.SCONTENT AS sContent FROM SA_ProcessControl c  WHERE  (c.SPROCESS = ?) AND (c.SACTIVITY = ?) AND (c.SOPERATORID = ?) AND (c.SACTION = ?) AND ( (c.SPROCESSTEMPLATEID2 IS NULL) OR (c.SPROCESSTEMPLATEID2 = ?) )
--> binds:[/gdms/baoxiu/process/baoxiu/baoxiuProcess, businessActivity2, v1CptZ5LnDkkineUcXV, advanceProcessAction, ]
2016-10-09 10:31:25 [SQL Time]sql 执行时间：2ms, exec KSQL: select customGroup as sID, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         from SA_OPCustomGroup customGroup                 optional join SA_ResourceControl range1                         on range1.sTypeID = 'customGroup_range' and range1.sResourceID = customGroup         where ((customGroup.sTypeID = 'private' and customGroup.sCreatorID = :currentPersonID())                         or (customGroup.sTypeID = 'public' and (range1 is null or (((((range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos/v1CptZ5LnDkkineUcXV@ZWTlQIGN0jkzYKuhyJe.psm'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn')))))         group by customGroup, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         order by customGroup.sTypeID, customGroup.sSequence
  --> sql:SELECT  customGroup.sID AS sID, customGroup.SNAME AS sName, customGroup.STYPEID AS sTypeID, customGroup.SSEQUENCE AS sSequence FROM SA_OPCustomGroup customGroup LEFT JOIN SA_ResourceControl range1 ON  (range1.STYPEID = ?) AND (range1.sResourceID = customGroup.sID)   WHERE  ( (customGroup.STYPEID = ?) AND (customGroup.SCREATORID =  ? ) ) OR ( (customGroup.STYPEID = ?) AND ( (range1.sID IS NULL) OR ( ( ( (range1.SORGFID = ?) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) ) )    GROUP BY customGroup.sID, customGroup.SNAME, customGroup.STYPEID, customGroup.SSEQUENCE  ORDER BY customGroup.STYPEID ASC, customGroup.SSEQUENCE ASC
--> binds:[customGroup_range, private, v1CptZ5LnDkkineUcXV, public, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos/v1CptZ5LnDkkineUcXV@ZWTlQIGN0jkzYKuhyJe.psm, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt, /AKLwWiuMzZ7A1mIVET2.ogn]
2016-10-09 10:31:25 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT SA_OPOrg.*, member1.sResourceID as groupID, member1 as memberID   FROM SA_OPOrg SA_OPOrg join SA_ResourceControl member1 on SA_OPOrg.sFID = member1.sOrgFID  and member1.sTypeID = 'customGroup_member'         and member1.sResourceID in ('') WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
  --> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID FROM SA_OPOrg SA_OPOrg JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN (?) )   WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND (SA_OPOrg.SVALIDSTATE = ?)   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[customGroup_member, , 0, 1]

jishuang

跟踪一下java代码，看看返回的list中有值吗？