/**
* Sets multiple files in categorie(s)
*/
public function multitaggingAction()
{
$status = 0;
$msg = 'Could not assign files in categories';
$r = $this->getRequest();
if (isset($r->fileFilesIds) && isset($r->fileFoldersIds) && is_array($r->fileFilesIds) && is_array($r->fileFoldersIds) && count($r->fileFilesIds) > 0 && count($r->fileFoldersIds) > 0) {
$lDB = new FilfoldersFilfiles();
foreach ($r->fileFilesIds as $fileFilesId) {
$lDB->delete("filfiles_id = '" . $fileFilesId . "' ");
foreach ($r->filfolders_ids as $fileFoldersId) {
$lDB->insert(array('filfolders_id' => $fileFoldersId, 'filfiles_id' => $fileFilesId));
}
}
$msg = count($r->fileFoldersIds) . ' categories assigned to ' . count($r->fileFilesIds) . ' files.';
$status = 1;
}
$this->view->ResultSet = array('message' => $msg, 'status' => $status);
}
/**
*
* @param unknown_type $userId
* @param unknown_type $newAvatar
*/
public static function changeAvatar($userId, $newAvatar = 0)
{
// save information into people table (users)
$people = new Users();
$rowPeople = $people->fetchRow("id = " . $userId);
if (isset($rowPeople)) {
// store old avatar
$oldAvatar = $rowPeople->avatar;
// update avatar
$dataUsers = array('avatar' => $newAvatar);
if (!$people->update($dataUsers, "id = " . $userId)) {
return false;
}
// link avatar to system folder
if ($newAvatar > 0) {
self::linkAvatarToSystemFolder($newAvatar);
}
// if old avatar, check if another user has the same avatar
if ($oldAvatar > 0) {
// search avatar
$select = $people->select()->where('avatar = ?', $oldAvatar);
$rowsetPeople = $people->fetchAll($select);
// if no avatar found, clean link between avatar and folder
if (count($rowsetPeople) == 0) {
$objectFolder = new Filfolders();
// get id of filfolders "adminpeople" and isSystemFolder "1"
$rowFolder = $objectFolder->getFoldersByModule('adminpeople');
$objectLinkFolder = new FilfoldersFilfiles();
$objectLinkFolder->delete('filfiles_id = ' . $oldAvatar . ' AND filfolders_id = ' . $rowFolder->id);
}
}
return true;
}
}
