Package org.activiti.engine.task

Examples of org.activiti.engine.task.NativeTaskQuery.parameter()

637
638
639
640
641
642
643
644
645
646
647
      //任务候选者
      if( StringUtils.isNotEmpty(task.getCandidateUser()) ){
        sql.append(" AND t.ASSIGNEE_ IS NULL "); //未签收
        sql.append(" AND i.TYPE_ = 'candidate'");
        sql.append(" AND i.USER_ID_ = #{candidate_user}");
        query.parameter("candidate_user", task.getCandidateUser().trim());
      }
     
      //任务签收人
      if( StringUtils.isNotEmpty(task.getAssignee()) ){
        sql.append(" AND t.ASSIGNEE_ = #{assignee}");
View Full Code Here
643
644
645
646
647
648
649
650
651
652
653
      }
     
      //任务签收人
      if( StringUtils.isNotEmpty(task.getAssignee()) ){
        sql.append(" AND t.ASSIGNEE_ = #{assignee}");
        query.parameter("assignee", task.getAssignee().trim());
      }
     
      //任务拥有者
      if( StringUtils.isNotEmpty(task.getOwner()) ){
        sql.append(" AND t.OWNER_ = #{owner}");
View Full Code Here
649
650
651
652
653
654
655
656
657
658
659
      }
     
      //任务拥有者
      if( StringUtils.isNotEmpty(task.getOwner()) ){
        sql.append(" AND t.OWNER_ = #{owner}");
        query.parameter("owner", task.getOwner().trim());
      }
     
      //任务到达时间
      if( task.getStartPeriod() != null ){
        Date start = task.getStartPeriod().getStart();
View Full Code Here
659
660
661
662
663
664
665
666
667
668
669
        Date start = task.getStartPeriod().getStart();
        Date end = task.getStartPeriod().getEnd();
       
        if( start != null ){
          sql.append(" AND t.CREATE_TIME_ >= #{st_start} ");
          query.parameter("st_start", start);
        }
       
        if( end != null ){
          Calendar cal_end = Calendar.getInstance();
          cal_end.setTime(end);
View Full Code Here
669
670
671
672
673
674
675
676
677
678
679
          cal_end.setTime(end);
          cal_end.add(Calendar.DAY_OF_MONTH, 1);
          cal_end.add(Calendar.SECOND, -1);
         
          sql.append(" AND t.CREATE_TIME_ <= #{st_end} ");
          query.parameter("st_end", cal_end.getTime());
        }
      }
     
      //流程
      if( StringUtils.isNotEmpty(task.getProcInstStartUser())
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
        sql.append(" WHERE 1=1 ");
       
        //流程创建人
        if( StringUtils.isNotEmpty(task.getProcInstStartUser() ) ){
          sql.append(" AND START_USER_ID_ = #{proc_inst_owner} ");
          query.parameter("proc_inst_owner", task.getProcInstStartUser() );
        }
       
        //流程开始时间
        if( task.getProcStartPeriod() != null ){
          Date start = task.getProcStartPeriod() .getStart();
View Full Code Here
694
695
696
697
698
699
700
701
702
703
704
          Date start = task.getProcStartPeriod() .getStart();
          Date end = task.getProcStartPeriod() .getEnd();
         
          if( start != null ){
            sql.append(" AND START_TIME_ >= #{proc_st_start} ");
            query.parameter("proc_st_start", start);
          }
         
          if( end != null ){
            Calendar cal_end = Calendar.getInstance();
            cal_end.setTime(end);
View Full Code Here
704
705
706
707
708
709
710
711
712
713
714
            cal_end.setTime(end);
            cal_end.add(Calendar.DAY_OF_MONTH, 1);
            cal_end.add(Calendar.SECOND, -1);
           
            sql.append(" AND START_TIME_ <= #{proc_st_end} ");
            query.parameter("proc_st_end", cal_end.getTime());
          }
        }
       
        sql.append(" ) "); //end in
      }
View Full Code Here
714
715
716
717
718
719
720
721
722
723
724
      }
     
      //流程实例编号
      if( StringUtils.isNotEmpty(task.getProcessInstanceId()) ){
        sql.append(" AND t.PROC_INST_ID_ = #{proc_inst_id}");
        query.parameter("proc_inst_id", task.getProcessInstanceId().trim());
      }
     
      //流程属性名称
      if( StringUtils.isNotEmpty(task.getProcessAttributeName()) ){
        sql.append(" AND t.PROC_INST_ID_ IN ( ");
View Full Code Here
722
723
724
725
726
727
728
729
730
731
732
      //流程属性名称
      if( StringUtils.isNotEmpty(task.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", "%"+task.getProcessAttributeName().trim()+"%");
      }
     
      //流程类型Key
      if( StringUtils.isNotEmpty(task.getProcessDefinitionKey()) ){
        sql.append(" AND t.PROC_DEF_ID_ IN ( ");
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.