Package org.activiti.engine.history

Examples of org.activiti.engine.history.NativeHistoricProcessInstanceQuery.parameter()

410
411
412
413
414
415
416
417
418
419
420
    if( process != null ){
     
      //流程实例ID
      if( StringUtils.isNotEmpty(process.getProcessInstanceId()) ){
        sql.append(" AND t.PROC_INST_ID_ = #{proc_inst_id}");
        query.parameter("proc_inst_id", process.getProcessInstanceId().trim());
      }
     
      //流程属性名称
      if( StringUtils.isNotEmpty(process.getProcessAttributeName()) ){
        sql.append(" AND t.PROC_INST_ID_ IN ( ");
View Full Code Here
418
419
420
421
422
423
424
425
426
427
428
      //流程属性名称
      if( StringUtils.isNotEmpty(process.getProcessAttributeName()) ){
        sql.append(" AND t.PROC_INST_ID_ IN ( ");
        sql.append(" SELECT DISTINCT ACT_PROC_INST_ID FROM T_FLOW_PROCESS_ATTR ");
        sql.append(" WHERE BIZ_NAME LIKE #{proc_attr_name} )");
        query.parameter("proc_attr_name", "%"+process.getProcessAttributeName().trim()+"%");
      }
     
      //流程类型ID
      if( StringUtils.isNotEmpty(process.getProcessDefinitionId()) ){
        sql.append(" AND t.PROC_DEF_ID_ = #{proc_def_id}");
View Full Code Here
424
425
426
427
428
429
430
431
432
433
434
      }
     
      //流程类型ID
      if( StringUtils.isNotEmpty(process.getProcessDefinitionId()) ){
        sql.append(" AND t.PROC_DEF_ID_ = #{proc_def_id}");
        query.parameter("proc_def_id", process.getProcessDefinitionId().trim());
      }
     
      //流程类型Key
      if( StringUtils.isNotEmpty(process.getProcessDefinitionKey()) ){
        sql.append(" AND t.PROC_DEF_ID_ IN ( ");
View Full Code Here
433
434
435
436
437
438
439
440
441
442
443
      if( StringUtils.isNotEmpty(process.getProcessDefinitionKey()) ){
        sql.append(" AND t.PROC_DEF_ID_ IN ( ");
        sql.append(" SELECT DISTINCT ID_ FROM ");
        sql.append( managementService.getTableName( ProcessDefinition.class) );
        sql.append(" WHERE KEY_ = #{proc_def_key} )");
        query.parameter("proc_def_key", process.getProcessDefinitionKey().trim());
      }
     
      boolean includeOwner = StringUtils.isNotEmpty(process.getOwner());
      String assignee = process.getAssignee()==null?null:process.getAssignee().trim();
      String owner = process.getOwner()==null?null:process.getOwner().trim();
View Full Code Here
449
450
451
452
453
454
455
456
457
458
459
        sql.append( managementService.getTableName(HistoricTaskInstance.class) );
        sql.append(" WHERE ASSIGNEE_ = #{assignee}");
       
        sql.append( " ) "+(includeOwner?" ":" OR t.START_USER_ID_ = #{owner} " )+")" );
        if(!includeOwner)
          query.parameter("owner", assignee);
       
        query.parameter("assignee", assignee);
      }
     
      //流程创建者
View Full Code Here
451
452
453
454
455
456
457
458
459
460
461
       
        sql.append( " ) "+(includeOwner?" ":" OR t.START_USER_ID_ = #{owner} " )+")" );
        if(!includeOwner)
          query.parameter("owner", assignee);
       
        query.parameter("assignee", assignee);
      }
     
      //流程创建者
      if( includeOwner ){
        sql.append(" AND t.START_USER_ID_ = #{owner}");
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
      }
     
      //流程创建者
      if( includeOwner ){
        sql.append(" AND t.START_USER_ID_ = #{owner}");
        query.parameter("owner", owner );
      }
     
      //是否完成
      if( process.getFinish() != null ){
        if( process.getFinish() )
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
        Date start = process.getStartPeriod().getStart();
        Date end = process.getStartPeriod().getEnd();
       
        if( start != null ){
          sql.append(" AND t.START_TIME_ >= #{st_start} ");
          query.parameter("st_start", start);
        }
       
        if( end != null ){
          Calendar cal_end = Calendar.getInstance();
          cal_end.setTime(end);
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
          cal_end.setTime(end);
          cal_end.add(Calendar.DAY_OF_MONTH, 1);
          cal_end.add(Calendar.SECOND, -1);
         
          sql.append(" AND t.START_TIME_ <= #{st_end} ");
          query.parameter("st_end", cal_end.getTime());
        }
      }
    }
   
    if( page.getOrderByList() != null && !page.getOrderByList().isEmpty() ){
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.