<#if table.isExternal==0> <#assign tableName='W_'+table.tableName?upper_case > <#else> <#assign tableName=table.tableName> <#assign package=table.variable.package> <#assign class=table.variable.class> <#assign fieldList=table.fieldList> <#assign type="com.hotent."+system+".model."+package+"." +class> <#function getJdbcType dataType> <#assign dbtype=dataType?lower_case> <#assign rtn> <#if dbtype=="number" > NUMERIC <#elseif (dbtype?index_of("char")>-1) > VARCHAR <#elseif (dbtype=="date")> DATE <#elseif (dbtype?ends_with("clob")) > CLOB <#return rtn?trim> <#-- 模板开始 --> <#if table.isExternal==0> <#if table.isMain==0> <#list fieldList as field> <#else> <#list fieldList as field> <#if table.pkField?lower_case==field.fieldName?lower_case> <#list fieldList as field> <#if table.pkField?lower_case!=field.fieldName?lower_case> <#if flowKey?exists> <#if table.isExternal==0> ID,<#if table.isMain==0>REFID,<#list fieldList as field>F_${field.fieldName?upper_case}<#if field_has_next>, <#else> <#list fieldList as field>${field.fieldName?upper_case}<#if field_has_next>, <#if table.isExternal==0> ID,<#if table.isMain==0>REFID,<#list fieldList as field>F_${field.fieldName?upper_case}<#if field_has_next>, <#else> <#list fieldList as field>${field.fieldName?upper_case}<#if field_has_next>, <#if table.isExternal==0> <#list fieldList as field> <#if (field.fieldType=="varchar")> AND F_${field.fieldName?upper_case} LIKE '%<#noparse>${${field.fieldName}}%' <#else> <#if (field.fieldType=="date")> AND F_${field.fieldName?upper_case} =<#noparse>#{${field.fieldName}} AND F_${field.fieldName?upper_case} >=<#noparse>#{begin${field.fieldName},jdbcType=DATE} AND F_${field.fieldName?upper_case} #{end${field.fieldName},jdbcType=DATE}]]> <#else> AND F_${field.fieldName?upper_case} =<#noparse>#{${field.fieldName}} <#else> <#list fieldList as field> <#if table.pkField?lower_case!=field.fieldName?lower_case> <#if (field.fieldType=="varchar")> AND ${field.fieldName?upper_case} LIKE '%<#noparse>${${field.fieldName}}%' <#if (field.fieldType=="date")> AND ${field.fieldName?upper_case} =<#noparse>#{${field.fieldName}} AND ${field.fieldName?upper_case} >=<#noparse>#{begin${field.fieldName},jdbcType=DATE} AND ${field.fieldName?upper_case} #{end${field.fieldName},jdbcType=DATE}]]> <#else> AND ${field.fieldName?upper_case} =<#noparse>#{${field.fieldName}} INSERT INTO ${tableName} <#if table.isExternal==0> (ID,<#if table.isMain==0>REFID, <#list fieldList as field>F_${field.fieldName?upper_case}<#if field_has_next>,) VALUES (<#noparse>#{id,jdbcType=NUMERIC}, <#if table.isMain==0> <#noparse>#{refId,jdbcType=NUMERIC}, <#list fieldList as field><#noparse>#{${field.fieldName},jdbcType=${getJdbcType(field.fieldType)}<#noparse>}<#if field_has_next>, ) <#else> (<#list fieldList as field>${field.fieldName?upper_case}<#if field_has_next>,) VALUES (<#list fieldList as field><#noparse>#{${field.fieldName},jdbcType=${getJdbcType(field.fieldType)}<#noparse>}<#if field_has_next>, ) DELETE FROM ${tableName} WHERE <#if table.isExternal==0> ID=<#noparse>#{id} <#else> ${table.pkField?upper_case}=<#noparse>#{${table.pkField}} UPDATE ${tableName} SET <#if table.isExternal==0> <#if table.isMain==0> REFID=<#noparse>#{refId,jdbcType=NUMERIC}, <#noparse>#{refId,jdbcType=NUMERIC}, <#list fieldList as field> F_${field.fieldName?upper_case}=<#noparse>#{${field.fieldName},jdbcType=${getJdbcType(field.fieldType)}<#noparse>}<#if field_has_next>, WHERE ID=<#noparse>#{id} <#else> <#list fieldList as field> <#if table.pkField?upper_case!=field.fieldName?upper_case> ${field.fieldName?upper_case}=<#noparse>#{${field.fieldName},jdbcType=${getJdbcType(field.fieldType)}<#noparse>}<#if field_has_next>, WHERE ${table.pkField?upper_case}=<#noparse>#{${table.pkField}} <#if table.isMain!=1> DELETE FROM ${tableName} WHERE <#if table.isExternal==0> REFID=<#noparse>#{refId} <#else> ${table.relation?upper_case}=<#noparse>#{${table.relation?lower_case}} SELECT FROM ${tableName} <#if table.isExternal==0> WHERE REFID=<#noparse>#{refId} <#else> WHERE ${table.relation?upper_case}=<#noparse>#{${table.relation?lower_case}} SELECT FROM ${tableName} WHERE <#if table.isExternal==0> ID=<#noparse>#{id} <#else> ${table.pkField?upper_case}=<#noparse>#{${table.pkField}} SELECT FROM ${tableName} order by <#noparse>${orderField} <#noparse>${orderSeq} <#if table.isExternal==0> order by ID desc <#else> order by ${table.pkField?upper_case} desc <#if flowKey?exists> SELECT ,B.runId FROM ${tableName} A,BPM_PRO_RUN B WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.STATUS=4 and B.CREATORID=<#noparse>#{userId} order by B.CREATETIME DESC SELECT * FROM ( SELECT , C.ID_ TASK_ID,C.TASK_DEF_KEY_,B.RUNID FLOW_RUNID,C.PROC_INST_ID_, C.NAME_ NODE_NAME_,C.CREATE_TIME_ TASK_CREATE_TIME_ FROM ${tableName} A,BPM_PRO_RUN B , ACT_RU_TASK C WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.ACTINSTID=C.PROC_INST_ID_ AND C.ASSIGNEE_=<#noparse>#{userId} union SELECT , C.ID_ TASK_ID,C.TASK_DEF_KEY_,B.RUNID FLOW_RUNID,C.PROC_INST_ID_, C.NAME_ NODE_NAME_,C.CREATE_TIME_ TASK_CREATE_TIME_ FROM ${tableName} A,BPM_PRO_RUN B , ACT_RU_TASK C, ACT_RU_IDENTITYLINK D WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.ACTINSTID=C.PROC_INST_ID_ AND C.id_ = D.TASK_ID_ AND D.USER_ID_ = <#noparse>#{userId} AND C.ASSIGNEE_ =0 and C.DESCRIPTION_!='39' UNION SELECT , C.ID_ TASK_ID,C.TASK_DEF_KEY_,B.RUNID FLOW_RUNID,C.PROC_INST_ID_, C.NAME_ NODE_NAME_,C.CREATE_TIME_ TASK_CREATE_TIME_ FROM ${tableName} A,BPM_PRO_RUN B , ACT_RU_TASK C, ACT_RU_IDENTITYLINK D WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.ACTINSTID=C.PROC_INST_ID_ AND C.id_ = D.TASK_ID_ AND C.ASSIGNEE_ =0 and C.DESCRIPTION_!='39' AND D.type_ = 'org' and D.group_id_ in (select uo.orgid from SYS_USER_POS uo where uo.userid= <#noparse>#{userId} ) UNION SELECT , C.ID_ TASK_ID,C.TASK_DEF_KEY_,B.RUNID FLOW_RUNID,C.PROC_INST_ID_, C.NAME_ NODE_NAME_,C.CREATE_TIME_ TASK_CREATE_TIME_ FROM ${tableName} A,BPM_PRO_RUN B , ACT_RU_TASK C, ACT_RU_IDENTITYLINK D WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.ACTINSTID=C.PROC_INST_ID_ AND C.id_ = D.TASK_ID_ AND C.ASSIGNEE_ =0 and C.DESCRIPTION_!='39' AND D.type_ = 'role' and D.group_id_ in (select ur.roleid from sys_user_role ur where ur.userid=<#noparse>#{userId} ) union SELECT , C.ID_ TASK_ID,C.TASK_DEF_KEY_,B.RUNID FLOW_RUNID,C.PROC_INST_ID_, C.NAME_ NODE_NAME_,C.CREATE_TIME_ TASK_CREATE_TIME_ FROM ${tableName} A,BPM_PRO_RUN B , ACT_RU_TASK C, ACT_RU_IDENTITYLINK D WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM AND B.ACTINSTID=C.PROC_INST_ID_ AND C.id_ = D.TASK_ID_ AND C.ASSIGNEE_ =0 and C.DESCRIPTION_!='39' AND D.type_ = 'pos' and D.group_id_ in (select up.posid from sys_user_pos up where up.userid= <#noparse>#{userId} ) ) tmp AND upper(tmp.subject) LIKE <#noparse>#{subject} AND upper(tmp.processName) LIKE <#noparse>#{processName} AND tmp.creatorId =<#noparse>#{creatorId} and tmp.TASK_CREATE_TIME_>=<#noparse>#{beginCreateTime,jdbcType=TIMESTAMP} and tmp.TASK_CREATE_TIME_ <=<#noparse>#{endCreateTime,jdbcType=TIMESTAMP} AND tmp.description_ = <#noparse>#{type} order by tmp.TASK_CREATE_TIME_ desc order by <#noparse>${orderField} <#noparse>${orderSeq} SELECT ,B.runId FROM ${tableName} A,BPM_PRO_RUN_HIS B WHERE A.${table.pkField?upper_case}=B.BUSINESSKEY_NUM and B.CREATORID=<#noparse>#{userId} and B.STATUS=2 order by B.ENDTIME DESC