1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 import com.teamkonzept.lib.templates.*; 6 7 14 public class TKDBGetAllTreeContentVersions extends TKUnprepQuery { 15 16 public static Object [][] paramTypes = 17 { {"SEARCH", new Integer (Types.VARCHAR)} }; 18 19 public static boolean[] setRelevants = 20 { true }; 21 22 public static String sqlString = 23 "SELECT " + 24 " CV.VERSION_ID, CV.INSTANCE_ID, CI.CONTENT_NODE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.AUTHOR, CV.INFO, VS.STATUS, " + 25 " CT.CONTENT_NODE_NAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_PARENT, CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_FORM, CT.CONTENT_NODE_TYPE, CI.NAME " + 26 "FROM " + 27 " CONTENT C,<TK_CASE:KENNUNG> CONTENT_VALUE CVALUE,</TK_CASE> CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_VERSION CV, VERSION_STATUS VS, CONTENT_INSTANCE CI " + 28 "WHERE " + 29 30 " CT.LEFT_NR > (SELECT LEFT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = <TK_CONTENT_NODE_ID>) AND " + 31 " CT.RIGHT_NR < (SELECT RIGHT_NR FROM CONTENT_TREE WHERE CONTENT_NODE_ID = <TK_CONTENT_NODE_ID>) AND " + 32 33 " CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID AND " + 34 " CV.INSTANCE_ID = CI.INSTANCE_ID AND " + 35 " C.CONTENT_ID = CV.CONTENT_ID AND " + 36 " CV.STATUS_ID = VS.STATUS_ID AND " + 37 " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " + 38 39 " <TK_CASE:KENNUNG> AND " + 40 " CVALUE.CONTENT_ID = CV.CONTENT_ID " + 41 " <TK_IF:KENNUNG=0> " + 42 " AND (<TK_LIST:SEARCH_STRING>(CVALUE.VALUE LIKE <TK:SEARCH> " + DBStringFactory.escape() + " ) <TK:CONN> </TK_LIST>) " + 43 " </TK_IF:KENNUNG=0> " + 44 " <TK_IF:KENNUNG=1> " + 45 " AND " + 46 " ((<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_NAME LIKE <TK:SEARCH> " + DBStringFactory.escape() + " ) <TK:CONN> </TK_LIST>) " + 47 " OR " + 48 " (<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_SHORTNAME LIKE <TK:SEARCH> " + DBStringFactory.escape() + " ) <TK:CONN> </TK_LIST>)) " + 49 " </TK_IF> " + 50 " </TK_CASE> " + 51 52 "ORDER BY " + 53 " CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID "; 54 55 public static TKTemplateSyntax sqlTmplSyntax; 56 57 public void initQuery(Connection con) { 58 try 59 { 60 sqlTmplSyntax = new TKTemplateSyntax(sqlString,""); 61 } 62 catch(com.teamkonzept.lib.TKTemplateSyntaxException e) 63 { 64 sqlString = sqlString; } 66 67 super.initQuery( 68 con, 69 paramTypes, 70 setRelevants, 71 sqlTmplSyntax ); 72 } 73 } 74 | Popular Tags |