public function testFileSync()
{
echo "test mediamanager...\n";
if (class_module_system_module::getModuleByName("samplecontent") == null || !is_file(_realpath_ . "/files/images/samples/IMG_3000.JPG")) {
return;
}
$objFilesystem = new class_filesystem();
$objFilesystem->folderCreate(_filespath_ . "/images/autotest");
$objFilesystem->fileCopy(_filespath_ . "/images/samples/IMG_3000.JPG", _filespath_ . "/images/autotest/IMG_3000.jpg");
$objFilesystem->fileCopy(_filespath_ . "/images/samples/IMG_3000.JPG", _filespath_ . "/images/autotest/IMG_3000.png");
$objFilesystem->fileCopy(_filespath_ . "/images/samples/IMG_3000.JPG", _filespath_ . "/images/autotest/PA021805.JPG");
$objFilesystem->fileCopy(_filespath_ . "/images/samples/IMG_3000.JPG", _filespath_ . "/images/autotest/test.txt");
$objRepo = new class_module_mediamanager_repo();
$objRepo->setStrPath(_filespath_ . "/images/autotest");
$objRepo->setStrTitle("autotest repo");
$objRepo->setStrViewFilter(".jpg,.png");
$objRepo->updateObjectToDb();
$objRepo->syncRepo();
$arrFiles = class_module_mediamanager_file::loadFilesDB($objRepo->getSystemid());
$this->assertEquals(3, count($arrFiles));
foreach ($arrFiles as $objOneFile) {
$objOneFile->deleteObjectFromDatabase();
}
$objRepo->deleteObjectFromDatabase();
$arrFiles = $objFilesystem->getFilelist(_filespath_ . "/images/autotest");
$this->assertEquals(1, count($arrFiles));
$this->assertEquals("test.txt", array_values($arrFiles)[0]);
}
/**
* Generic list of all packages available on the local filesystem
* @return string
* @permissions view
* @autoTestable
*/
protected function actionOpenFolder()
{
if (validateSystemid(class_module_system_setting::getConfigValue("_packageserver_repo_id_"))) {
if ($this->getSystemid() == "") {
$this->setSystemid(class_module_system_setting::getConfigValue("_packageserver_repo_id_"));
}
$objIterator = new class_array_section_iterator(class_module_mediamanager_file::getFileCount($this->getSystemid(), false, false, true));
$objIterator->setPageNumber($this->getParam("pv"));
$objIterator->setArraySection(class_module_mediamanager_file::loadFilesDB($this->getSystemid(), false, false, $objIterator->calculateStartPos(), $objIterator->calculateEndPos(), true));
} else {
$objIterator = new class_array_section_iterator(class_module_mediamanager_file::getFlatPackageListCount(false, false));
$objIterator->setPageNumber($this->getParam("pv"));
$objIterator->setArraySection(class_module_mediamanager_file::getFlatPackageList(false, false, $objIterator->calculateStartPos(), $objIterator->calculateEndPos()));
}
return $this->renderList($objIterator);
}
/**
* Internal helper, loads all files available including a traversal
* of the nested folders.
*
* @param $strParentId
* @param int|bool $strCategoryFilter
* @param int $intStart
* @param int $intEnd
* @param bool $strNameFilter
*
* @return class_module_mediamanager_file[]
*/
private function getAllPackages($strParentId, $strCategoryFilter = false, $intStart = null, $intEnd = null, $strNameFilter = false)
{
$arrReturn = array();
if (validateSystemid($strParentId)) {
$arrSubfiles = class_module_mediamanager_file::loadFilesDB($strParentId, false, true, null, null, true);
foreach ($arrSubfiles as $objOneFile) {
if ($objOneFile->getIntType() == class_module_mediamanager_file::$INT_TYPE_FILE) {
//filename based check if the file should be included
if ($strNameFilter !== false) {
if (uniStrpos($strNameFilter, ",") !== false) {
if (in_array($objOneFile->getStrName(), explode(",", $strNameFilter))) {
$arrReturn[] = $objOneFile;
}
} else {
if (uniSubstr($objOneFile->getStrName(), 0, uniStrlen($strNameFilter)) == $strNameFilter) {
$arrReturn[] = $objOneFile;
}
}
} else {
$arrReturn[] = $objOneFile;
}
} else {
$arrReturn = array_merge($arrReturn, $this->getAllPackages($objOneFile->getSystemid()));
}
}
if ($intStart !== null && $intEnd !== null && $intStart > 0 && $intEnd > $intStart) {
if ($intEnd > count($arrReturn)) {
$intEnd = count($arrReturn);
}
$arrTemp = array();
for ($intI = $intStart; $intI <= $intEnd; $intI++) {
$arrTemp[] = $arrReturn[$intI];
}
$arrReturn = $arrTemp;
}
//sort them by filename
usort($arrReturn, function (class_module_mediamanager_file $objA, class_module_mediamanager_file $objB) {
return strcmp($objA->getStrName(), $objB->getStrName());
});
} else {
$arrReturn = class_module_mediamanager_file::getFlatPackageList($strCategoryFilter, true, $intStart, $intEnd, $strNameFilter);
}
return $arrReturn;
}
/**
* @param string $strParentId
*
* @return array
*/
private function getNavigationNodesHelper($strParentId)
{
$arrFoldersDB = class_module_mediamanager_file::loadFilesDB($strParentId, class_module_mediamanager_file::$INT_TYPE_FOLDER, true);
$arrReturn = array();
foreach ($arrFoldersDB as $objOneFolder) {
$objPoint = new class_module_navigation_point();
$objPoint->setIntRecordStatus(1);
$objPoint->setStrName($objOneFolder->getStrName());
$objPoint->setStrPageI($this->getPagename());
$objPoint->setSystemid($objOneFolder->getSystemid());
$objPoint->setStrLinkSystemid($objOneFolder->getSystemid());
$objPoint->setStrLinkAction("mediaFolder");
$objPoint->setBitIsForeignNode(true);
$arrTemp = array("node" => $objPoint, "subnodes" => $this->getNavigationNodesHelper($objOneFolder->getSystemid()));
$arrReturn[] = $arrTemp;
}
return $arrReturn;
}
/**
* Syncs the files in the db with the files in the filesystem
*
* @param string $strPrevID
* @param string $strPath
* @param bool $bitRecursive
* @param \class_module_mediamanager_repo|null $objRepo
*
* @return array [insert, delete]
*/
public static function syncRecursive($strPrevID, $strPath, $bitRecursive = true, class_module_mediamanager_repo $objRepo = null)
{
$arrReturn = array();
$arrReturn["insert"] = 0;
$arrReturn["delete"] = 0;
if ($objRepo == null) {
$objRepo = class_objectfactory::getInstance()->getObject($strPrevID);
while ($objRepo != null && !$objRepo instanceof class_module_mediamanager_repo) {
$objRepo = class_objectfactory::getInstance()->getObject($objRepo->getPrevId());
}
}
//Load the files in the DB
$arrObjDB = class_module_mediamanager_file::loadFilesDB($strPrevID);
//Load files and folder from filesystem
$objFilesystem = new class_filesystem();
//if the repo defines a view-filter, take that one into account
$arrViewFilter = array();
if ($objRepo->getStrViewFilter() != "") {
$arrViewFilter = explode(",", $objRepo->getStrViewFilter());
}
$arrFilesystem = $objFilesystem->getCompleteList($strPath, $arrViewFilter, array(), array(".", "..", ".svn"));
//So, lets sync those two arrays
//At first the files
foreach ($arrFilesystem["files"] as $intKeyFS => $arrOneFileFilesystem) {
//search the db-array for this file
foreach ($arrObjDB as $intKeyDB => $objOneFileDB) {
//File or folder
if ($objOneFileDB->getintType() == self::$INT_TYPE_FILE) {
//compare
if ($objOneFileDB->getStrFilename() == str_replace(_realpath_, "", $arrOneFileFilesystem["filepath"])) {
//And unset from both arrays
unset($arrFilesystem["files"][$intKeyFS]);
unset($arrObjDB[$intKeyDB]);
}
}
}
}
//And loop the folders
foreach ($arrFilesystem["folders"] as $intKeyFolder => $strFolder) {
//search the array for folders
foreach ($arrObjDB as $intKeyDB => $objOneFolderDB) {
//file or folder?
if ($objOneFolderDB->getIntType() == self::$INT_TYPE_FOLDER) {
//compare
if ($objOneFolderDB->getStrFilename() == $strPath . "/" . $strFolder) {
//Unset from both
unset($arrFilesystem["folders"][$intKeyFolder]);
unset($arrObjDB[$intKeyDB]);
}
}
}
}
//the remaining records from the database have to be deleted!
if (count($arrObjDB) > 0) {
foreach ($arrObjDB as $objOneFileDB) {
$objOneFileDB->deleteObjectFromDatabase();
$arrReturn["delete"]++;
}
}
//the remaining records from the filesystem have to be added
foreach ($arrFilesystem["files"] as $arrOneFileFilesystem) {
$strFileName = $arrOneFileFilesystem["filename"];
$strFileFilename = str_replace(_realpath_, "", $arrOneFileFilesystem["filepath"]);
$objFile = new class_module_mediamanager_file();
$objFile->setStrFilename($strFileFilename);
$objFile->setStrName($strFileName);
$objFile->setIntType(self::$INT_TYPE_FILE);
$objFile->updateObjectToDb($strPrevID);
$arrReturn["insert"]++;
}
foreach ($arrFilesystem["folders"] as $strFolder) {
$strFileName = $strFolder;
$strFileFilename = $strPath . "/" . $strFolder;
$objFile = new class_module_mediamanager_file();
$objFile->setStrFilename($strFileFilename);
$objFile->setStrName($strFileName);
$objFile->setIntType(self::$INT_TYPE_FOLDER);
$objFile->updateObjectToDb($strPrevID);
$arrReturn["insert"]++;
}
//Load subfolders
class_carrier::getInstance()->getObjDB()->flushQueryCache();
if ($bitRecursive) {
$objFolders = class_module_mediamanager_file::loadFilesDB($strPrevID, self::$INT_TYPE_FOLDER);
foreach ($objFolders as $objOneFolderDB) {
$arrTemp = class_module_mediamanager_file::syncRecursive($objOneFolderDB->getSystemid(), $objOneFolderDB->getStrFilename(), $bitRecursive, $objRepo);
$arrReturn["insert"] += $arrTemp["insert"];
$arrReturn["delete"] += $arrTemp["delete"];
}
}
return $arrReturn;
}
/**
* Loads the content of a folder
* If requested, loads subactions,too
*
* SPECIAL MODE FOR MODULE FOLDERVIEW
*
* @return string
* @permissions view
* @autoTestable
*/
protected function actionFolderContentFolderviewMode()
{
$strReturn = "<script type='text/javascript'>KAJONA.admin.loader.loadFile('" . class_resourceloader::getInstance()->getCorePathForModule("module_mediamanager") . "/module_mediamanager/admin/scripts/mediamanager.js');</script>";
//if set, save CKEditors CKEditorFuncNum parameter to read it again in KAJONA.admin.folderview.selectCallback()
//so we don't have to pass through the param with all requests
if ($this->getParam("CKEditorFuncNum") != "") {
$strReturn .= "<script type=\"text/javascript\">window.opener.KAJONA.admin.folderview.selectCallbackCKEditorFuncNum = " . (int) $this->getParam("CKEditorFuncNum") . ";</script>";
}
$strTargetfield = $this->getParam("form_element");
$this->setArrModuleEntry("template", "/folderview.tpl");
//list repos or contents?
if ($this->getSystemid() == "") {
//Load the repos
$arrObjRepos = class_module_mediamanager_repo::getObjectList();
$intI = 0;
//Print every repo
/** @var class_module_mediamanager_repo $objOneRepo */
foreach ($arrObjRepos as $objOneRepo) {
//check rights
if ($objOneRepo->rightView()) {
$strActions = "";
$strActions .= $this->objToolkit->listButton(class_link::getLinkAdmin($this->getArrModule("modul"), "folderContentFolderviewMode", "&form_element=" . $strTargetfield . "&systemid=" . $objOneRepo->getSystemid(), "", $this->getLang("action_open_folder"), "icon_folderActionOpen"));
$strReturn .= $this->objToolkit->simpleAdminList($objOneRepo, $strActions, $intI++);
}
}
if (uniStrlen($strReturn) != 0) {
$strReturn = $this->objToolkit->listHeader() . $strReturn . $this->objToolkit->listFooter();
}
if (count($arrObjRepos) == 0) {
$strReturn .= $this->getLang("commons_list_empty");
}
} else {
$objFile = class_objectfactory::getInstance()->getObject($this->getSystemid());
if ($objFile === null || !$objFile->rightView()) {
return $this->getLang("commons_error_permissions");
}
$objIterator = new class_array_section_iterator(class_module_mediamanager_file::getFileCount($this->getSystemid()));
$objIterator->setPageNumber($this->getParam("pv"));
$objIterator->setArraySection(class_module_mediamanager_file::loadFilesDB($this->getSystemid(), false, false, $objIterator->calculateStartPos(), $objIterator->calculateEndPos()));
$strReturn .= $this->actionUploadFileInternal();
$strReturn .= $this->generateNewFolderDialogCode();
$strReturn .= $this->renderFloatingGrid($objIterator, class_module_mediamanager_admin::INT_LISTTYPE_FOLDERVIEW, "&form_element=" . $this->getParam("form_element"), false);
}
return $strReturn;
}
private function updateGalleryLevel($strNewPrevid, $strOldPrevid)
{
$arrFiles = class_module_mediamanager_file::loadFilesDB($strNewPrevid);
$arrOldFiles = $this->objDB->getPArray("SELECT * FROM " . _dbprefix_ . "system, " . _dbprefix_ . "gallery_pic WHERE system_id = pic_id AND system_prev_id = ?", array($strOldPrevid));
foreach ($arrFiles as $objOneFile) {
$strNewFilename = basename($objOneFile->getStrFilename());
echo " searching image/folder " . $strNewFilename . "\n";
foreach ($arrOldFiles as $arrOneOldFile) {
if (basename($arrOneOldFile["pic_filename"]) == $strNewFilename) {
$objOneFile->setStrName($arrOneOldFile["pic_name"]);
$objOneFile->setStrDescription($arrOneOldFile["pic_description"]);
$objOneFile->setStrSubtitle($arrOneOldFile["pic_subtitle"]);
$objOneFile->setIntHits((int) $arrOneOldFile["pic_hits"]);
$objOneFile->updateObjectToDb();
$this->moveComments($arrOneOldFile["pic_id"], $objOneFile->getSystemid());
$this->migrateRatings($arrOneOldFile["pic_id"], $objOneFile->getSystemid());
echo "...update succeeded\n";
if ($objOneFile->getIntType() == class_module_mediamanager_file::$INT_TYPE_FOLDER) {
$this->updateGalleryLevel($objOneFile->getSystemid(), $arrOneOldFile["pic_id"]);
}
}
}
}
}
