#foreach ($column in $columns) a.${column.columnName} as "${column.javaField}"#if($foreach.hasNext), #else #end #end and a.parent_id = #{parentId} and a.parent_ids like concat(#{parentIds},'%') and a.parent_ids <> #{parentIds} #foreach($column in $columns) #set($queryType=$column.queryType) #set($javaField=$column.javaField) #set($javaType=$column.javaType) #set($columnName=$column.columnName) #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) #if($column.query || $columnName == $subTableFkName) ##非日期 #if($javaType != 'Date') #if($column.queryType == "EQ") and a.$columnName = #{$javaField} #elseif($queryType == "NE") and a.$columnName != #{$javaField} #elseif($queryType == "GT") and a.$columnName > #{$javaField} #elseif($queryType == "GTE") and a.$columnName >= #{$javaField} #elseif($queryType == "LT") and a.$columnName < #{$javaField} #elseif($queryType == "LTE") and a.$columnName <= #{$javaField} #elseif($queryType == "LIKE") and a.$columnName like concat('%', #{$javaField}, '%') #end #else ##日期 #if($column.queryType == "EQ") and date_format(a.$columnName,'%y%m%d') = date_format(#{begin$AttrName},'%y%m%d') #elseif($queryType == "GT") and date_format(a.$columnName,'%y%m%d') > date_format(#{begin$AttrName},'%y%m%d') #elseif($queryType == "GTE") and date_format(a.$columnName,'%y%m%d') >= date_format(#{begin$AttrName},'%y%m%d') #elseif($queryType == "LT") and date_format(a.$columnName,'%y%m%d') < date_format(#{end$AttrName},'%y%m%d') /if> #elseif($queryType == "LTE") and date_format(a.$columnName,'%y%m%d') <= date_format(#{end$AttrName},'%y%m%d') #elseif($queryType == "BETWEEN") and date_format(a.$columnName,'%y%m%d') >= date_format(#{begin$AttrName},'%y%m%d') and date_format(a.$columnName,'%y%m%d') <= date_format(#{end$AttrName},'%y%m%d') #end #end #end #end order by a.tree_sorts SELECT FROM ${tableName} a WHERE a.id = #{id} SELECT FROM ${tableName} a a.del_flag = #{DEL_FLAG_NORMAL} SELECT count(1) FROM ${tableName} a where a.del_flag = #{DEL_FLAG_NORMAL} SELECT a.id FROM ${tableName} a a.del_flag = #{DEL_FLAG_NORMAL} AND id != #{notEqualId} #foreach($column in $columns) #set($javaField=$column.javaField) #set($javaType=$column.javaType) #set($columnName=$column.columnName) #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)}) #if($column.isUnique == "1") and $columnName = #{$javaField} #end #end SELECT max(a.tree_sort) FROM ${tableName} a WHERE a.del_flag = #{DEL_FLAG_NORMAL} and a.parent_id = #{parentId} select from ${tableName} a and a.del_flag = '0' select from ${tableName} a and a.del_flag = '0' and ( 1 != 1 or a.id in #{id} ) INSERT INTO ${tableName}( #foreach($column in $columns) $column.columnName#if($foreach.hasNext), #end #end ) VALUES ( #foreach($column in $columns) #{$column.javaField}#if($foreach.hasNext), #end #end ) #if($hasDisableEnable) UPDATE ${tableName} SET status = #{status}, version = version + 1 WHERE id = #{id} #end UPDATE ${tableName} SET #foreach($column in $columns) #if($column.javaField != "id" && $column.javaField != "createBy" && $column.javaField != "createDept" && $column.javaField != "createTime" && $column.javaField != "id" && $column.javaField != "version" && $column.javaField != "delFlag") $column.columnName = #{$column.javaField}, #end #end version = version + 1 WHERE id = #{id} and version = #{version} update ${tableName} set parent_ids = when #{item.id} then #{item.parentIds} , tree_sorts = when #{item.id} then #{item.treeSorts} , tree_level = when #{item.id} then #{item.treeLevel} where id in #{item.id} UPDATE ${tableName} SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}