package com.wflow.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface WflowModelPermsMapper extends BaseMapper {

   @Insert({"<script>INSERT INTO xcj_model_perms (id, form_id, perm_type, org_id, create_time) VALUES\n  <foreach collection =\"perms\" item=\"t\" separator =\",\">\n    (#{t.id}, #{t.formId}, #{t.permType}, #{t.orgId}, #{t.createTime})\n  </foreach ></script>"})
   int insertBatch(@Param("perms") List var1);

   @Select({"SELECT * FROM xcj_models WHERE is_delete = 0 AND process_flag=1 AND is_stop = 0 AND (form_id IN (\n\tSELECT form_id FROM xcj_model_perms WHERE perm_type = \'user\' AND org_id = #{userId}\n\tUNION All SELECT p.form_id FROM xcj_model_perms p, xcj_sys_user_dept d \n\tWHERE p.org_id = d.dept_id AND p.perm_type = \'dept\' AND d.user_id = #{userId}\n) OR form_id NOT IN (SELECT form_id FROM xcj_model_perms) ) ORDER by group_id ASC, sort ASC"})
   List selectByPerms(@Param("userId") Integer var1);

   @Select({"SELECT * FROM xcj_models WHERE is_delete = 0 AND project_flag=1 AND process_flag=1 AND is_stop = 0 AND (form_id IN (\n\tSELECT form_id FROM xcj_model_perms WHERE perm_type = \'user\' AND org_id = #{userId}\n\tUNION All SELECT p.form_id FROM xcj_model_perms p, xcj_sys_user_dept d \n\tWHERE p.org_id = d.dept_id AND p.perm_type = \'dept\' AND d.user_id = #{userId}\n) OR form_id NOT IN (SELECT form_id FROM xcj_model_perms) ) ORDER by group_id ASC, sort ASC"})
   List selectByPermsAndProjectFlag(@Param("userId") Integer var1, @Param("projectFlag") Integer var2);
}