Package sk.iway.iwcm.components.file_archiv

Class FileArchivatorDB

java.lang.Object

sk.iway.iwcm.database.JpaDB<FileArchivatorBean>

sk.iway.iwcm.components.file_archiv.FileArchivatorDB

public class FileArchivatorDB
extends JpaDB<FileArchivatorBean>

FileArchivatorDB.java DAO class for manipulating with FileArchivatorBean Title webjet7 Company Interway s.r.o. (www.interway.sk) Copyright Interway s.r.o. (c) 2001-2010

Field Summary

Fields

Modifier and Type	Field	Description
protected static String	cachePrefix

Fields inherited from class sk.iway.iwcm.database.JpaDB

dbName

Constructor Summary

Constructors

Constructor	Description
FileArchivatorDB()

Method Summary

Modifier and Type	Method	Description
static Collection<String>	createCollection(String pageParamName, javax.servlet.http.HttpServletRequest request)	vytvori kolekciu na zaklade hodnot include paramteri
protected static void	filterByDir(List<FileArchivatorBean> fabList, String dirPath, boolean includeSubdirs)
static List<String>	getAllCategories()	vsetky kategorie zvolenej domeny
static List<String>	getAllCategories2(String category1)
static List<FileArchivatorBean>	getByConditions(Collection<String> product, Collection<String> category, Collection<String> productCode, String dirPath, boolean includeSubdirs, boolean asc, Boolean pShowFile, String virtualName, String realName, boolean useCache, int globalId, boolean onlyMain)	Podla parametrov vrati vysledky
static List<FileArchivatorBean>	getByConditions(Collection<String> domain, Collection<String> product, Collection<String> category, Collection<String> productCode, String dirPath_cached, boolean includeSubdirs, boolean asc, Boolean showFile, boolean useCache)
static List<FileArchivatorBean>	getByConditions(Collection<String> domain, Collection<String> product, Collection<String> category, Collection<String> productCode, String dirPath_cached, boolean includeSubdirs, boolean asc, Boolean showFile, String virtualName, String realName, boolean useCache)	Deprecated.
static List<FileArchivatorBean>	getByConditions(Collection<String> domain, Collection<String> product, Collection<String> category, Collection<String> productCode, String dirPath_cached, boolean includeSubdirs, boolean asc, Boolean pShowFile, String virtualName, String realName, boolean useCache, int globalId, boolean onlyMain)
static List<FileArchivatorBean>	getByGlobalId(List<Integer> globalId)	vrati hlavne zaznamy so zadanymi globalId
static List<FileArchivatorBean>	getByHash(FileArchivatorBean fab)	Pokusi sa najst v DB hlavne subory s rovnakym hashom.
static FileArchivatorBean	getByPath(String path, String fileName)
static List<FileArchivatorBean>	getByReferenceId(int referenceId)	BACKWARD COMPATIBILITY
static List<FileArchivatorBean>	getByReferenceId(Long referenceId)	Vrati vysledky podla referencie z cache
static FileArchivatorBean	getByUrl(String url)	Vrati bean podla standardneho WJ url (napr.
static FileArchivatorBean	getByUrl(String url, boolean alsoInactive)
static String	getCachePrefix()
protected static int	getCacheTime(String methodName)
protected static String	getCheckSum(Collection<String> strCollection_1, Collection<String> strCollection_2, Collection<String> strCollection_3, Collection<String> strCollection_4)
static String	getConstantsPrefix()
static int	getCountByReferenceId(Long referenceId)
static List<String>	getDistinctListByProperty(String column)	vrati zoznam nunikatnych hodnot pre stlpec vo file_archiv, okrem null a pradnych + cachuje per domena
static List<FileArchivatorBean>	getFilesToUpload()	Vrati vsetky subory, ktore sa mozu nahrat vzhladom na aktualny cas
static FileArchivatorDB	getInstance()
static List<FileArchivatorBean>	getMainAndHistoryFiles(boolean cleanCache, boolean includeAwaiting)
static List<FileArchivatorBean>	getMainFileList()	Vrati vsetky aktualne (hlavne) subory z cache + zohladni CloudToolsForCore.getDomainId() ak je zapnute
static List<FileArchivatorBean>	getMainFileList(boolean cleanCache)
static List<FileArchivatorBean>	getMainFileList(boolean cleanCache, boolean includeAwaiting)
static int	getNumberOfReference(List<FileArchivatorBean> fabsList, int referenceId)	vrati pocet referencii na subor zo zoznamu fabsList
static FileArchivatorBean	getPatern(String url)	Vrati vzor pre zadany subor
static List<FileArchivatorBean>	getReference(int referenceId, String sortByReference, boolean asc)
static List<FileArchivatorBean>	getReference(Long referenceId, String sortByReference, boolean asc)	vrati zoznam suborov na zaklade referencie
protected static String	getString(Collection<String> strCollection)
static void	removeById(List<FileArchivatorBean> fabsList, int fileArchivId)	vymaze fabID zo zoznamu fabsList
protected static void	removePattern(List<FileArchivatorBean> fabList)
static boolean	saveCategories(int category_1, String category_2, String category_3)	vytvori nove kategorie do manazera kategorii
static List<FileArchivatorBean>	search(FileArchivatorSearchBean fabSearch)	vysledky z databazy bez pouzitia Cache + zohladni CloudToolsForCore.getDomainId() ak je zapnute
static void	sortBy(List<FileArchivatorBean> fabListCache, String sortBy, boolean asc)	zoradi zaznamy podla priority/datumu nahratia/virtualneho nazvu/ID

Methods inherited from class sk.iway.iwcm.database.JpaDB

and, delete, deleteByIds, filterBetween, filterBetween, filterBetween, filterEquals, filterEquals, filterEquals, filterIn, filterNotIn, filterNotNull, filterNull, filterSubstring, filterSubstringIgnoringCase, find, findBy, findBy, findByProperties, findFirst, findFirstByProperties, getAll, getById, getById, getCount, getResultList, getValues, of, or, save

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

cachePrefix

protected static String cachePrefix

Constructor Details

FileArchivatorDB

public FileArchivatorDB()

Method Details

getInstance

public static FileArchivatorDB getInstance()

getMainAndHistoryFiles

public static List<FileArchivatorBean> getMainAndHistoryFiles(boolean cleanCache,
 boolean includeAwaiting)

getByReferenceId

public static List<FileArchivatorBean> getByReferenceId(Long referenceId)

Vrati vysledky podla referencie z cache

Parameters:

referenceId - int

Returns:

List

getByHash

public static List<FileArchivatorBean> getByHash(FileArchivatorBean fab)

Pokusi sa najst v DB hlavne subory s rovnakym hashom. Pozor ! Vracia aj sam seba ;-)

Parameters:

fab - FileArchivatorBean

Returns:

List

getMainFileList

public static List<FileArchivatorBean> getMainFileList()

Vrati vsetky aktualne (hlavne) subory z cache + zohladni CloudToolsForCore.getDomainId() ak je zapnute

Returns:

List

getMainFileList

public static List<FileArchivatorBean> getMainFileList(boolean cleanCache)

getMainFileList

public static List<FileArchivatorBean> getMainFileList(boolean cleanCache,
 boolean includeAwaiting)

getFilesToUpload

public static List<FileArchivatorBean> getFilesToUpload()

Vrati vsetky subory, ktore sa mozu nahrat vzhladom na aktualny cas

Returns:

List

getByConditions

public static List<FileArchivatorBean> getByConditions(Collection<String> domain,
 Collection<String> product,
 Collection<String> category,
 Collection<String> productCode,
 String dirPath_cached,
 boolean includeSubdirs,
 boolean asc,
 Boolean showFile,
 boolean useCache)

getByConditions

@Deprecated
public static List<FileArchivatorBean> getByConditions(Collection<String> domain,
 Collection<String> product,
 Collection<String> category,
 Collection<String> productCode,
 String dirPath_cached,
 boolean includeSubdirs,
 boolean asc,
 Boolean showFile,
 String virtualName,
 String realName,
 boolean useCache)

Deprecated.

DEPRECATED, use getByConditions

Parameters:

domain -

product -

category -

productCode -

dirPath_cached -

includeSubdirs -

asc -

showFile -

virtualName -

realName -

useCache -

Returns:

getByConditions

public static List<FileArchivatorBean> getByConditions(Collection<String> domain,
 Collection<String> product,
 Collection<String> category,
 Collection<String> productCode,
 String dirPath_cached,
 boolean includeSubdirs,
 boolean asc,
 Boolean pShowFile,
 String virtualName,
 String realName,
 boolean useCache,
 int globalId,
 boolean onlyMain)

getByConditions

public static List<FileArchivatorBean> getByConditions(Collection<String> product,
 Collection<String> category,
 Collection<String> productCode,
 String dirPath,
 boolean includeSubdirs,
 boolean asc,
 Boolean pShowFile,
 String virtualName,
 String realName,
 boolean useCache,
 int globalId,
 boolean onlyMain)

Podla parametrov vrati vysledky

Parameters:

product - Collection

category - Collection

productCode - Collection

dirPath - String

includeSubdirs - vratit aj podpriecink

asc - poradie zobrazovania

pShowFile - zobrazovat aj skryte subory

virtualName - String

realName - String

useCache - true / false - vratit z cache

globalId - int

onlyMain - iba hlavne subory

Returns:

List

search

public static List<FileArchivatorBean> search(FileArchivatorSearchBean fabSearch)

vysledky z databazy bez pouzitia Cache + zohladni CloudToolsForCore.getDomainId() ak je zapnute

Parameters:

fabSearch - FileArchivatorSearchBean

Returns:

List

filterByDir

protected static void filterByDir(List<FileArchivatorBean> fabList,
 String dirPath,
 boolean includeSubdirs)

removePattern

protected static void removePattern(List<FileArchivatorBean> fabList)

getPatern

public static FileArchivatorBean getPatern(String url)

Vrati vzor pre zadany subor

Parameters:

url - - cesta v tvare archiv/... k suboru

Returns:

FileArchivatorBean

getByPath

public static FileArchivatorBean getByPath(String path,
 String fileName)

getByUrl

public static FileArchivatorBean getByUrl(String url)

Vrati bean podla standardneho WJ url (napr. /files/archiv/subor.pdb) s tym, ze skontroluje platnost beanu a datumov (najde vyhovujuci, ak je ich viac) Pouziva sa vo vyhladavani pre nahradenie nazvu suboru za virtualny nazov beanu

Parameters:

url - String

Returns:

FileArchivatorBean

getByUrl

public static FileArchivatorBean getByUrl(String url,
 boolean alsoInactive)

getByGlobalId

public static List<FileArchivatorBean> getByGlobalId(List<Integer> globalId)

vrati hlavne zaznamy so zadanymi globalId

Parameters:

globalId - ArrayList

Returns:

List

getCachePrefix

public static String getCachePrefix()

getConstantsPrefix

public static String getConstantsPrefix()

getCheckSum

protected static String getCheckSum(Collection<String> strCollection_1,
 Collection<String> strCollection_2,
 Collection<String> strCollection_3,
 Collection<String> strCollection_4)

getString

protected static String getString(Collection<String> strCollection)

getCacheTime

protected static int getCacheTime(String methodName)

getAllCategories

public static List<String> getAllCategories()

vsetky kategorie zvolenej domeny

Returns:

getAllCategories2

public static List<String> getAllCategories2(String category1)

saveCategories

public static boolean saveCategories(int category_1,
 String category_2,
 String category_3)

vytvori nove kategorie do manazera kategorii

Parameters:

category_1 - int

category_2 - String

category_3 - String

Returns:

boolean

getReference

public static List<FileArchivatorBean> getReference(Long referenceId,
 String sortByReference,
 boolean asc)

vrati zoznam suborov na zaklade referencie

Parameters:

sortByReference - reference (fabId) / time (orderId) / priority (priorityId)

asc - true ak ASC

Returns:

List

createCollection

public static Collection<String> createCollection(String pageParamName,
 javax.servlet.http.HttpServletRequest request)

vytvori kolekciu na zaklade hodnot include paramteri

Parameters:

pageParamName -

request -

Returns:

getNumberOfReference

public static int getNumberOfReference(List<FileArchivatorBean> fabsList,
 int referenceId)

vrati pocet referencii na subor zo zoznamu fabsList

removeById

public static void removeById(List<FileArchivatorBean> fabsList,
 int fileArchivId)

vymaze fabID zo zoznamu fabsList

getDistinctListByProperty

public static List<String> getDistinctListByProperty(String column)

vrati zoznam nunikatnych hodnot pre stlpec vo file_archiv, okrem null a pradnych + cachuje per domena

Parameters:

column - - stlpec vo file_archiv

Returns:

sortBy

public static void sortBy(List<FileArchivatorBean> fabListCache,
 String sortBy,
 boolean asc)

zoradi zaznamy podla priority/datumu nahratia/virtualneho nazvu/ID

Parameters:

fabListCache -

sortBy -

asc -

getByReferenceId

public static List<FileArchivatorBean> getByReferenceId(int referenceId)

BACKWARD COMPATIBILITY

getReference

public static List<FileArchivatorBean> getReference(int referenceId,
 String sortByReference,
 boolean asc)

getCountByReferenceId

public static int getCountByReferenceId(Long referenceId)