/** * 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; } }