function purge_trash()
{
Env::useHelper("permissions");
$days = config_option("days_on_trash", 0);
$count = 0;
if ($days > 0) {
$date = DateTimeValueLib::now()->add("d", -$days);
$objects = Objects::findAll(array("conditions" => array("`trashed_by_id` > 0 AND `trashed_on` < ?", $date), "limit" => 100));
foreach ($objects as $object) {
$concrete_object = Objects::findObject($object->getId());
if (!$concrete_object instanceof ContentDataObject) {
continue;
}
if ($concrete_object instanceof MailContent && $concrete_object->getIsDeleted() > 0) {
continue;
}
try {
DB::beginWork();
if ($concrete_object instanceof MailContent) {
$concrete_object->delete(false);
} else {
$concrete_object->delete();
}
ApplicationLogs::createLog($concrete_object, ApplicationLogs::ACTION_DELETE);
DB::commit();
$count++;
} catch (Exception $e) {
DB::rollback();
Logger::log("Error delting object in purge_trash: " . $e->getMessage(), Logger::ERROR);
}
}
}
return $count;
}
/**
* Delete specific user
*
* @access public
* @param void
* @return null
*/
function delete()
{
$this->setTemplate('del_user');
$user = Users::findById(get_id());
if (!$user instanceof User) {
flash_error(lang('user dnx'));
$this->redirectTo('administration');
}
// if
if (!$user->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectToReferer(get_url('dashboard'));
}
// if
$delete_data = array_var($_POST, 'deleteUser');
tpl_assign('user', $user);
tpl_assign('delete_data', $delete_data);
if (!is_array($delete_data)) {
$delete_data = array('really' => 0, 'password' => '');
// array
tpl_assign('delete_data', $delete_data);
} else {
if ($delete_data['really'] == 1) {
$password = $delete_data['password'];
if (trim($password) == '') {
tpl_assign('error', new Error(lang('password value missing')));
return $this->render();
}
if (!logged_user()->isValidPassword($password)) {
tpl_assign('error', new Error(lang('invalid login data')));
return $this->render();
}
try {
DB::beginWork();
$user->delete();
ApplicationLogs::createLog($user, null, ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete user', $user->getDisplayName()));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete user'));
}
// try
$this->redirectToUrl($user->getCompany()->getViewUrl());
} else {
flash_error(lang('error delete user'));
$this->redirectToUrl($user->getCompany()->getViewUrl());
}
}
}
function purge_trash()
{
Env::useHelper("permissions");
$days = config_option("days_on_trash", 0);
$count = 0;
if ($days > 0) {
$date = DateTimeValueLib::now()->add("d", -$days);
$managers = array('Comments', 'Companies', 'Contacts', 'MailContents', 'ProjectCharts', 'ProjectEvents', 'ProjectFiles', 'ProjectFileRevisions', 'ProjectForms', 'ProjectMessages', 'ProjectMilestones', 'ProjectTasks', 'ProjectWebpages');
foreach ($managers as $manager_class) {
$manager = new $manager_class();
$prevcount = -1;
while ($prevcount != $count) {
$prevcount = $count;
if ($manager_class == 'MailContents') {
$objects = $manager->findAll(array("include_trashed" => true, "conditions" => array("`trashed_by_id` > 0 AND `trashed_on` < ? AND `is_deleted` = 0", $date), "limit" => 100));
} else {
$objects = $manager->findAll(array("include_trashed" => true, "conditions" => array("`trashed_by_id` > 0 AND `trashed_on` < ?", $date), "limit" => 100));
}
if (is_array($objects)) {
// delete one by one because each one knows what else to delete
foreach ($objects as $o) {
try {
DB::beginWork();
$ws = $o->getWorkspaces();
if ($o instanceof MailContent) {
$o->delete(false);
} else {
$o->delete();
}
ApplicationLogs::createLog($o, $ws, ApplicationLogs::ACTION_DELETE);
DB::commit();
$count++;
} catch (Exception $e) {
DB::rollback();
Logger::log("Error deleting object in purge_trash: " . $e->getMessage(), Logger::ERROR);
}
}
}
}
}
}
return $count;
}
/**
* Delete specific project form
*
* @param void
* @return null
*/
function delete()
{
$project_form = ProjectForms::findById(get_id());
if (!$project_form instanceof ProjectForm) {
flash_error(lang('project form dnx'));
if (ProjectForm::canAdd(logged_user(), active_project())) {
$this->redirectTo('form');
} else {
$this->redirectToUrl(active_project()->getOverviewUrl());
}
// if
}
// if
if (!$project_form->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
if (ProjectForm::canAdd(logged_user(), active_project())) {
$this->redirectTo('form');
} else {
$this->redirectToUrl(active_project()->getOverviewUrl());
}
// if
}
// if
if ($project_form->delete()) {
ApplicationLogs::createLog($project_form, active_project(), ApplicationLogs::ACTION_DELETE, true);
flash_success(lang('success delete project form', $project_form->getName()));
} else {
flash_error(lang('error delete project form'));
}
// if
$this->redirectTo('form');
}
/**
* Open specific milestone
*
* @access public
* @param void
* @return null
*/
function open()
{
$milestone = ProjectMilestones::findById(get_id());
if (!$milestone instanceof ProjectMilestone) {
flash_error(lang('milestone dnx'));
$this->redirectTo('milestone');
}
// if
if (!$milestone->canChangeStatus(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectToReferer(get_url('milestone'));
}
// if
try {
$milestone->setCompletedOn(null);
$milestone->setCompletedById(0);
DB::beginWork();
$milestone->save();
ApplicationLogs::createLog($milestone, active_project(), ApplicationLogs::ACTION_OPEN);
DB::commit();
flash_success(lang('success open milestone', $milestone->getName()));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error open milestone'));
}
// try
$this->redirectToReferer($milestone->getViewUrl());
}
/**
* Delete company logo
*
* @param void
* @return null
*/
function delete_logo() {
if(!logged_user()->isAdministrator()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
} // if
$company = Contacts::findById(get_id());
if(!($company instanceof Contact)) {
flash_error(lang('company dnx'));
ajx_current("empty");
return;
} // if
try {
DB::beginWork();
$company->deleteLogo();
$company->save();
ApplicationLogs::createLog($company, ApplicationLogs::ACTION_EDIT);
DB::commit();
flash_success(lang('success delete company logo'));
ajx_current("back");
} catch(Exception $e) {
DB::rollback();
flash_error(lang('error delete company logo'));
ajx_current("empty");
} // try
} // delete_logo
/**
* Delete specific category
*
* @access public
* @param void
* @return null
*/
function delete_category()
{
$category = ProjectCategories::findById(get_id());
if (!$category instanceof ProjectCategory) {
flash_error(lang('category dnx'));
$this->redirectTo('tickets', 'categories');
}
// if
if (!$category->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectToReferer(get_url('tickets', 'categories'));
}
// if
try {
DB::beginWork();
$category->delete();
ApplicationLogs::createLog($category, $category->getProject(), ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success deleted category', $category->getName()));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete category'));
}
// try
$this->redirectTo('tickets', 'categories');
}
/**
* Delete project
*
* @param void
* @return null
*/
function delete()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$pid = get_id();
$u = Users::findOne(array("conditions" => "personal_project_id = {$pid}"));
if ($u) {
//flash_error("id: $pid, u: ".$u->getId());
ajx_current("empty");
flash_error(lang('cannot delete personal project'));
return;
//$this->redirectTo('administration', 'projects');
}
$project = Projects::findById(get_id());
if (!$project instanceof Project) {
flash_error(lang('project dnx'));
ajx_current("empty");
return;
//$this->redirectTo('administration', 'projects');
}
// if
if (!$project->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
//$this->redirectToReferer(get_url('administration', 'projects'));
}
// if
if (!array_var($_GET, 'confirm')) {
tpl_assign('project', $project);
$this->setTemplate('pre_delete');
return;
}
ajx_current("empty");
try {
$id = $project->getId();
$name = $project->getName();
DB::beginWork();
$project->delete();
CompanyWebsite::instance()->setProject(null);
ApplicationLogs::createLog($project, null, ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete project', $project->getName()));
evt_add("workspace deleted", array("id" => $id, "name" => $name));
ajx_current("start");
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
// try
//$this->redirectTo('administration', 'projects');
}
function fckimagesupload(){
try {
if ( isset( $_FILES['NewFile'] ) && !is_null( $_FILES['NewFile']['tmp_name'] ) )
{
$oFile = $_FILES['NewFile'] ;
}else{
$sErrorNumber = '202';
echo $this->SendUploadResults( $sErrorNumber ) ;
return;
}
$sErrorNumber = '0' ;
$sFileName = $oFile['name'] ;
$file = new ProjectFile();
$file->setFilename($sFileName);
$file->setIsVisible(true);
$file->setCreatedOn(new DateTimeValue(time()));
DB::beginWork();
$file->save();
//FIXME $workspaces = array(personal_project());
/*FIXME if (is_array($workspaces)) {
foreach ($workspaces as $ws) {
$file->addToWorkspace($ws);
}
}*/
$revision = $file->handleUploadedFile($oFile, true, '');
ApplicationLogs::createLog($file, ApplicationLogs::ACTION_ADD);
DB::commit();
echo $this->SendUploadResults( $sErrorNumber, $file->getDownloadUrl() , $file->getFilename() ) ;
} catch (Exception $e) {
DB::rollback();
$sErrorNumber = '202';
echo $this->SendUploadResults( $sErrorNumber ) ;
}
}
function uploadDocument($doc_name, $ws_id, $path)
{
if (str_starts_with($doc_name, "~")) {
return;
}
try {
DB::beginWork();
$project = Projects::findById($ws_id);
//$file = ProjectFiles::findOne(array("conditions" => "`filename` = '$doc_name'"));
$files = ProjectFiles::getAllByFilename($doc_name, $ws_id);
if (is_array($files) && count($files) > 0) {
$file = $files[0];
} else {
$file = null;
}
if (!$file instanceof ProjectFile) {
$file = new ProjectFile();
$file->setFilename($doc_name);
$file->setIsVisible(true);
$file->setIsPrivate(false);
$file->setIsImportant(false);
$file->setCommentsEnabled(true);
$file->setAnonymousCommentsEnabled(false);
//$file->setCreatedOn(new DateTimeValue(time()) );
}
$sourcePath = $path . $doc_name;
$handle = fopen($sourcePath, "r");
$size = filesize($sourcePath);
$file_content = fread($handle, $size);
fclose($handle);
$file_dt['name'] = $file->getFilename();
$file_dt['size'] = strlen($file_content);
$file_dt['tmp_name'] = $sourcePath;
//TEMP_PATH . DIRECTORY_SEPARATOR . rand() ;
$extension = trim(get_file_extension($sourcePath));
$file_dt['type'] = Mime_Types::instance()->get_type($extension);
if (!trim($file_dt['type'])) {
$file_dt['type'] = 'text/html';
}
$file->save();
$file->removeFromAllWorkspaces();
$file->addToWorkspace($project);
$old_revs = $file->getRevisions();
foreach ($old_revs as $rev) {
$rev->delete();
}
$revision = $file->handleUploadedFile($file_dt, true, '');
$file_date = new DateTimeValue(filemtime($sourcePath));
$revision->setCreatedOn($file_date);
$revision->setUpdatedOn($file_date);
$revision->save();
$file->setCreatedOn($file_date);
$file->setUpdatedOn($file_date);
$file->save();
$ws = $file->getWorkspaces();
ApplicationLogs::createLog($file, $ws, ApplicationLogs::ACTION_ADD);
ImportLogger::instance()->log(" File: {$doc_name} [{$ws_id}]");
print " File: {$doc_name} [{$ws_id}]\r\n";
DB::commit();
} catch (Exception $e) {
DB::rollback();
ImportLogger::instance()->logError("{$e}\r\n**************************************************");
print "\r\n\r\nERROR: {$e}\r\n";
}
}
/**
* Log user out
*
* @access public
* @param void
* @return null
*/
function logout()
{
ApplicationLogs::createLog(logged_user(), ApplicationLogs::ACTION_LOGOUT, false, false, true, get_ip_address());
CompanyWebsite::instance()->logUserOut();
$this->redirectTo('access', 'login');
}
function addEmailToWorkspace($id, $destination, $mantainWs = true)
{
$email = MailContents::findById($id);
if ($email instanceof MailContent && $email->canEdit(logged_user())) {
if (!$mantainWs) {
$removed = "";
$ws = $email->getWorkspaces();
foreach ($ws as $w) {
if (can_add(logged_user(), $w, 'MailContents')) {
$email->removeFromWorkspace($w);
$removed .= $w->getId() . ",";
}
}
$removed = substr($removed, 0, -1);
$log_action = ApplicationLogs::ACTION_MOVE;
$log_data = ($removed == "" ? "" : "from:{$removed};") . "to:" . $destination->getId();
} else {
$log_action = ApplicationLogs::ACTION_COPY;
$log_data = "to:" . $destination->getId();
}
$email->addToWorkspace($destination);
ApplicationLogs::createLog($email, $email->getWorkspaces(), $log_action, false, null, true, $log_data);
return 1;
} else {
return 0;
}
}
/**
* Delete group
*
* @param void
* @return null
*/
function delete()
{
if (!can_manage_security(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
$group = Groups::findById(get_id());
if (!$group instanceof Group) {
flash_error(lang('group dnx'));
ajx_current("empty");
return;
}
// if
try {
DB::beginWork();
$group->delete();
ApplicationLogs::createLog($group, null, ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete group', $group->getName()));
ajx_current("reload");
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete group'));
ajx_current("empty");
}
// try
}
function delete()
{
if (!can_manage_templates(logged_user())) {
flash_error(lang("no access permissions"));
ajx_current("empty");
return;
}
ajx_current("empty");
$cotemplate = COTemplates::findById(get_id());
if (!$cotemplate instanceof COTemplate) {
flash_error(lang('template dnx'));
return;
}
// if
if (!$cotemplate->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
return;
}
// if
try {
DB::beginWork();
$cotemplate->delete();
ApplicationLogs::createLog($cotemplate, ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete template', $cotemplate->getObjectName()));
if (array_var($_GET, 'popup', false)) {
ajx_current("reload");
} else {
ajx_current("back");
}
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
}
// try
}
/**
* Delete project link
*
* @param void
* @return null
*/
function delete_link()
{
$project_link = ProjectLinks::findById(get_id());
if (!ProjectLink::canEdit(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectTo('links', 'index');
}
// if
if (!$project_link instanceof ProjectLink) {
flash_error(lang('project link dnx'));
$this->redirectTo('links');
}
// if
try {
DB::beginWork();
$project_link->delete();
ApplicationLogs::createLog($project_link, active_project(), ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete link', $project_link->getTitle()));
$this->redirectTo('links');
} catch (Exception $e) {
DB::rollback();
tpl_assign('error', $e);
}
// try
}
function repetitive_task_related_edit($task, $task_data)
{
$was_template = $task->getIsTemplate();
$task->setFromAttributes($task_data);
$task->setIsTemplate($was_template);
// is_template value must not be changed from ui
$totalMinutes = array_var($task_data, 'time_estimate_hours') * 60 + array_var($task_data, 'time_estimate_minutes');
$task->setTimeEstimate($totalMinutes);
if ($task->getParentId() > 0 && $task->hasChild($task->getParentId())) {
flash_error(lang('task child of child error'));
ajx_current("empty");
return;
}
DB::beginWork();
$task->save();
$task->setObjectName(array_var($task_data, 'name'));
$task->save();
// dependencies
if (config_option('use tasks dependencies')) {
$previous_tasks = array_var($task_data, 'previous');
if (is_array($previous_tasks)) {
foreach ($previous_tasks as $ptask) {
if ($ptask == $task->getId()) {
continue;
}
$dep = ProjectTaskDependencies::findById(array('previous_task_id' => $ptask, 'task_id' => $task->getId()));
if (!$dep instanceof ProjectTaskDependency) {
$dep = new ProjectTaskDependency();
$dep->setPreviousTaskId($ptask);
$dep->setTaskId($task->getId());
$dep->save();
}
}
$saved_ptasks = ProjectTaskDependencies::findAll(array('conditions' => 'task_id = ' . $task->getId()));
foreach ($saved_ptasks as $pdep) {
if (!in_array($pdep->getPreviousTaskId(), $previous_tasks)) {
$pdep->delete();
}
}
} else {
ProjectTaskDependencies::delete('task_id = ' . $task->getId());
}
}
// Add assigned user to the subscibers list
if ($task->getAssignedToContactId() > 0 && Contacts::instance()->findById($task->getAssignedToContactId())) {
if (!isset($_POST['subscribers'])) {
$_POST['subscribers'] = array();
}
$_POST['subscribers']['user_' . $task->getAssignedToContactId()] = 'checked';
}
$object_controller = new ObjectController();
$object_controller->add_to_members($task, array_var($task_data, 'members'));
$object_controller->add_subscribers($task);
$object_controller->link_to_new_object($task);
$object_controller->add_custom_properties($task);
$object_controller->add_reminders($task);
// apply values to subtasks
$assigned_to = $task->getAssignedToContactId();
$subtasks = $task->getAllSubTasks();
$milestone_id = $task->getMilestoneId();
$apply_ms = array_var($task_data, 'apply_milestone_subtasks') == "checked";
$apply_at = array_var($task_data, 'apply_assignee_subtasks', '') == "checked";
foreach ($subtasks as $sub) {
$modified = false;
if ($apply_at || !($sub->getAssignedToContactId() > 0)) {
$sub->setAssignedToContactId($assigned_to);
$modified = true;
}
if ($apply_ms) {
$sub->setMilestoneId($milestone_id);
$modified = true;
}
if ($modified) {
$sub->save();
}
}
$task->resetIsRead();
ApplicationLogs::createLog($task, ApplicationLogs::ACTION_EDIT);
DB::commit();
}
function restore_user()
{
$user = Contacts::findById(get_id());
if (!($user instanceof Contact && $user->isUser())) {
flash_error(lang('user dnx'));
ajx_current("empty");
return;
}
if (!$user->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
try {
DB::beginWork();
$user->setDisabled(false);
$user->unarchive();
ApplicationLogs::createLog($user, ApplicationLogs::ACTION_UNTRASH);
$ret = null;
Hook::fire("user_restored", $user, $ret);
DB::commit();
flash_success('success delete user');
ajx_current("reload");
} catch (Exception $e) {
flash_error($e->getMessage());
DB::rollback();
ajx_current("empty");
}
}
/**
* Delete specific message
*
* @access public
* @param void
* @return null
*/
function delete()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current('empty');
return;
}
ajx_current("empty");
$message = ProjectMessages::findById(get_id());
if (!$message instanceof ProjectMessage) {
flash_error(lang('message dnx'));
ajx_current("empty");
return;
}
// if
if (!$message->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
try {
DB::beginWork();
$message->trash();
DB::commit();
ApplicationLogs::createLog($message, ApplicationLogs::ACTION_TRASH);
flash_success(lang('success deleted message', $message->getObjectName()));
if (array_var($_POST, 'popup', false)) {
ajx_current("reload");
} else {
ajx_current("back");
}
ajx_add("overview-panel", "reload");
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete message'));
ajx_current("empty");
}
// try
}
/**
* Delete avatar
*
* @param void
* @return null
*/
function delete_avatar()
{
$user = Users::findById(get_id());
if (!$user instanceof User) {
flash_error(lang('user dnx'));
$this->redirectTo('dashboard');
}
// if
if (!$user->canUpdateProfile(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectTo('dashboard');
}
// if
$redirect_to = array_var($_GET, 'redirect_to');
if (trim($redirect_to) == '' || !is_valid_url($redirect_to)) {
$redirect_to = $user->getUpdateAvatarUrl();
}
// if
tpl_assign('redirect_to', $redirect_to);
if (!$user->hasAvatar()) {
flash_error(lang('avatar dnx'));
$this->redirectToUrl($redirect_to);
}
// if
try {
DB::beginWork();
$user->deleteAvatar();
$user->save();
ApplicationLogs::createLog($user, null, ApplicationLogs::ACTION_EDIT);
DB::commit();
flash_success(lang('success delete avatar'));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete avatar'));
}
// try
$this->redirectToUrl($redirect_to);
}
function unarchive()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$object_id = get_id('object_id');
$object = Objects::findObject($object_id);
if ($object instanceof ApplicationDataObject && $object->canEdit(logged_user())) {
try {
DB::beginWork();
$object->unarchive();
ApplicationLogs::createLog($object, ApplicationLogs::ACTION_UNARCHIVE);
DB::commit();
flash_success(lang("success unarchive objects", 1));
if ($object instanceof Contact) {
self::reloadPersonsDimension();
}
} catch (Exception $e) {
DB::rollback();
flash_error(lang("error unarchive objects", 1));
}
} else {
flash_error(lang("no access permissions"));
}
ajx_current("back");
}
/**
* Delete selected revision (if you have proper permissions)
*
* @param void
* @return null
*/
function delete_revision()
{
$this->setTemplate('del_revision');
$revision = ProjectFileRevisions::findById(get_id());
if (!$revision instanceof ProjectFileRevision) {
flash_error(lang('file revision dnx'));
$this->redirectToReferer(get_url('files'));
}
// if
$file = $revision->getFile();
if (!$file instanceof ProjectFile) {
flash_error(lang('file dnx'));
$this->redirectToReferer(get_url('files'));
}
// if
$all_revisions = $file->getRevisions();
if (count($all_revisions) == 1) {
flash_error(lang('cant delete only revision'));
$this->redirectToReferer($file->getDetailsUrl());
}
// if
if (!$revision->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectToReferer(get_url('files'));
}
// if
$delete_data = array_var($_POST, 'deleteFileRevision');
tpl_assign('file', $file);
tpl_assign('revision', $revision);
tpl_assign('delete_data', $delete_data);
if (!is_array($delete_data)) {
$delete_data = array('really' => 0, 'password' => '');
// array
tpl_assign('delete_data', $delete_data);
} else {
if ($delete_data['really'] == 1) {
$password = $delete_data['password'];
if (trim($password) == '') {
tpl_assign('error', new Error(lang('password value missing')));
return $this->render();
}
if (!logged_user()->isValidPassword($password)) {
tpl_assign('error', new Error(lang('invalid login data')));
return $this->render();
}
try {
DB::beginWork();
$revision->delete();
ApplicationLogs::createLog($revision, $revision->getProject(), ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete file revision'));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete file revision'));
}
// try
$this->redirectToUrl($file->getDetailsUrl());
} else {
flash_error(lang('error delete file revision'));
$this->redirectToUrl($file->getDetailsUrl());
}
}
}
/**
* Edit a wiki page
*
* @return void
*/
function edit()
{
if (!WikiPage::canEdit(logged_user())) {
flash_error(lang('no wiki page edit permissions'));
$this->redirectToReferer(get_url('wiki'));
}
//Get the page from the url params
$page = Wiki::getPageById(get_id(), active_project());
if (!instance_of($page, 'WikiPage')) {
//If the page doesn't exist, redirect to wiki index
flash_error(lang('wiki page dnx'));
$this->redirectToReferer(get_url('wiki'));
}
// if
//Check that the user can edit this entry
if (!$page->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectTo(get_url('wiki'));
}
// if
// Check that the page isn't locked
if ($page->isLocked() && !$page->canUnlock(logged_user())) {
flash_error(lang('wiki page locked by', $page->getLockedByUser()->getUsername()));
$this->redirectToUrl($page->getViewUrl());
}
// if
//Here we will edit a wiki page
$preview = false;
$data = array_var($_POST, 'wiki', false);
if (false !== $data) {
$preview = array_key_exists('preview', $data);
}
if (!$preview && $data) {
//if(null !== ($data = array_var($_POST, 'wiki'))){
//If we have received data
//Make a new revision
$revision = $page->makeRevision();
$revision->setFromAttributes($data);
$page->setProjectIndex($data['project_index']);
$page->setProjectSidebar($data['project_sidebar']);
$page->setPublish($data['publish']);
$page->setParentId($data['parent_id']);
// Check to see if we want to lock this page
if (isset($data['locked'])) {
if ($data['locked'] == 1 && $page->canLock(logged_user()) && !$page->isLocked()) {
// If we want to lock this page and the user has permissions to lock it, and the page is not already locked
$page->setLocked(true);
$page->setLockedById(logged_user()->getId());
$page->setLockedOn(DateTimeValueLib::now());
} elseif ($data['locked'] == 0 & $page->canUnlock(logged_user()) && $page->isLocked()) {
// Else if we want to unlock the page, and the user is allowed to, and the page is locked
$page->setLocked(false);
}
// if
}
// if
//Set the users ID
$revision->setCreatedById(logged_user()->getId());
try {
//Start the transaction
DB::beginWork();
//Save the page and create revision
//The page will make sure that the revision's project and page Id are correct
$page->save();
ApplicationLogs::createLog($page, active_project(), ApplicationLogs::ACTION_EDIT);
if (plugin_active('tags')) {
//Set the tags
$page->setTagsFromCSV($data['tags']);
}
//Commit changes
DB::commit();
flash_success(lang('success edit wiki page'));
//Redirect to the page we just created
$this->redirectToUrl($page->getViewUrl());
} catch (Exception $e) {
//Get rid of any Db changes we've made
DB::rollback();
//Assign the problem to the template so we can tell the user
tpl_assign('error', $e);
}
//try
} else {
if (array_var($_GET, 'revision')) {
//If we want to make a new revision based off a revision
$revision = $page->getRevision($_GET['revision']);
} else {
$revision = $page->getLatestRevision();
}
}
//if
if (!$data) {
// there was no input POSTed
$data['content'] = $revision->getContent();
}
$data['preview_content'] = do_textile($data['content']);
//Assign revision object
tpl_assign('revision', $revision);
tpl_assign('data', $data);
//Assign the page object
tpl_assign('page', $page);
$tag_names = plugin_active('tags') ? $page->getTagNames() : '';
$tags = is_array($tag_names) ? implode(', ', $tag_names) : '';
tpl_assign('tags', $tags);
//Set the template
$this->setTemplate('edit');
$this->setSidebar(get_template_path('textile_help_sidebar'));
}
/**
* Delete comment
*
* @access public
* @param void
* @return null
*/
function delete_comment()
{
$comment = MessageComments::findById(get_id());
if (!$comment instanceof MessageComment) {
flash_error(lang('comment dnx'));
$this->redirectTo('message');
}
// if
$message = $comment->getMessage();
if (!$message instanceof ProjectMessage) {
flash_error(lang('message dnx'));
$this->redirectTo('message');
}
// if
if (!$comment->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectToUrl($message->getViewUrl());
}
// if
try {
DB::beginWork();
$comment->delete();
ApplicationLogs::createLog($comment, active_project(), ApplicationLogs::ACTION_DELETE);
DB::commit();
flash_success(lang('success delete comment'));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete comment'));
}
// try
$this->redirectToUrl($message->getViewUrl());
}
function list_all()
{
ajx_current("empty");
$context = active_context();
$start = array_var($_GET, 'start', 0);
$limit = array_var($_GET, 'limit', config_option('files_per_page'));
$order = array_var($_GET, 'sort');
if ($order == "updatedOn" || $order == "updated" || $order == "date" || $order == "dateUpdated") {
$order = "updated_on";
}
$order_dir = array_var($_GET, 'dir');
$page = (int) ($start / $limit) + 1;
$hide_private = !logged_user()->isMemberOfOwnerCompany();
if (array_var($_GET, 'action') == 'delete') {
$ids = explode(',', array_var($_GET, 'webpages'));
$succ = 0;
$err = 0;
foreach ($ids as $id) {
$web_page = ProjectWebpages::findById($id);
if (isset($web_page) && $web_page->canDelete(logged_user())) {
try {
DB::beginWork();
$web_page->trash();
ApplicationLogs::createLog($web_page, ApplicationLogs::ACTION_TRASH);
DB::commit();
$succ++;
} catch (Exception $e) {
DB::rollback();
$err++;
}
} else {
$err++;
}
}
if ($succ > 0) {
flash_success(lang("success delete objects", $succ));
}
if ($err > 0) {
flash_error(lang("error delete objects", $err));
}
} else {
if (array_var($_GET, 'action') == 'markasread') {
$ids = explode(',', array_var($_GET, 'ids'));
$succ = 0;
$err = 0;
foreach ($ids as $id) {
$webpage = ProjectWebpages::findById($id);
try {
$webpage->setIsRead(logged_user()->getId(), true);
$succ++;
} catch (Exception $e) {
$err++;
}
}
if ($succ <= 0) {
flash_error(lang("error markasread files", $err));
}
} else {
if (array_var($_GET, 'action') == 'markasunread') {
$ids = explode(',', array_var($_GET, 'ids'));
$succ = 0;
$err = 0;
foreach ($ids as $id) {
$webpage = ProjectWebpages::findById($id);
try {
$webpage->setIsRead(logged_user()->getId(), false);
$succ++;
} catch (Exception $e) {
$err++;
}
}
if ($succ <= 0) {
flash_error(lang("error markasunread files", $err));
}
} else {
if (array_var($_GET, 'action') == 'archive') {
$ids = explode(',', array_var($_GET, 'webpages'));
$succ = 0;
$err = 0;
foreach ($ids as $id) {
$web_page = ProjectWebpages::findById($id);
if (isset($web_page) && $web_page->canEdit(logged_user())) {
try {
DB::beginWork();
$web_page->archive();
ApplicationLogs::createLog($web_page, ApplicationLogs::ACTION_ARCHIVE);
DB::commit();
$succ++;
} catch (Exception $e) {
DB::rollback();
$err++;
}
} else {
$err++;
}
}
if ($succ > 0) {
flash_success(lang("success archive objects", $succ));
}
if ($err > 0) {
flash_error(lang("error archive objects", $err));
}
}
}
}
}
$res = ProjectWebpages::instance()->listing(array("order" => $order, "order_dir" => $order_dir));
$object = array("totalCount" => $res->total, "start" => $start, "webpages" => array());
if (isset($res->objects)) {
$index = 0;
$ids = array();
foreach ($res->objects as $w) {
$ids[] = $w->getId();
$object["webpages"][] = array("ix" => $index++, "id" => $w->getId(), "object_id" => $w->getObjectId(), "ot_id" => $w->getObjectTypeId(), "name" => $w->getObjectName(), "description" => $w->getDescription(), "url" => $w->getUrl(), "updatedOn" => $w->getUpdatedOn() instanceof DateTimeValue ? $w->getUpdatedOn()->isToday() ? format_time($w->getUpdatedOn()) : format_datetime($w->getUpdatedOn()) : '', "updatedOn_today" => $w->getUpdatedOn() instanceof DateTimeValue ? $w->getUpdatedOn()->isToday() : 0, "updatedBy" => $w->getUpdatedByDisplayName(), "updatedById" => $w->getUpdatedById(), "memPath" => json_encode($w->getMembersToDisplayPath()));
}
$read_objects = ReadObjects::getReadByObjectList($ids, logged_user()->getId());
foreach ($object["webpages"] as &$data) {
$data['isRead'] = isset($read_objects[$data['object_id']]);
}
}
ajx_extra_data($object);
}
/**
* Delete specific comment
*
* @param void
* @return null
*/
function delete()
{
$comment = Comments::findById(get_id());
if (!$comment instanceof Comment) {
flash_error(lang('comment dnx'));
ajx_current("empty");
return;
}
// if
$object = $comment->getRelObject();
if (!$object instanceof ContentDataObject) {
flash_error(lang('object dnx'));
ajx_current("empty");
return;
}
// if
if (trim($object->getObjectUrl())) {
$redirect_to = $object->getObjectUrl();
}
if (!$comment->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
try {
DB::beginWork();
$comment->trash();
ApplicationLogs::createLog($comment, ApplicationLogs::ACTION_TRASH);
DB::commit();
flash_success(lang('success delete comment'));
ajx_current("reload");
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete comment'));
ajx_current("empty");
}
// try
}
function unarchive()
{
if (!can_manage_dimension_members(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$member = Members::findById(get_id());
if (!$member instanceof Member) {
flash_error(lang('member dnx'));
ajx_current("empty");
return;
}
if (get_id('user')) {
$user = Contacts::findById($get_id('user'));
} else {
$user = logged_user();
}
if (!$user instanceof Contact) {
ajx_current("empty");
return;
}
try {
DB::beginWork();
set_time_limit(0);
$count = $member->unarchive($user);
evt_add("reload dimension tree", array('dim_id' => $member->getDimensionId()));
if (array_var($_REQUEST, 'dont_back')) {
ajx_current("empty");
} else {
ajx_current("back");
}
flash_success(lang('success unarchive member', $member->getName(), $count));
DB::commit();
ApplicationLogs::createLog($member, ApplicationLogs::ACTION_UNARCHIVE);
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
}
/**
* Delete company logo
*
* @param void
* @return null
*/
function delete_logo()
{
if (!logged_user()->isAdministrator(owner_company())) {
flash_error(lang('no access permissions'));
$this->redirectTo('dashboard');
}
// if
$company = Companies::findById(get_id());
if (!$company instanceof Company) {
flash_error(lang('company dnx'));
$this->redirectToReferer(get_url('administration', 'clients'));
}
// if
try {
DB::beginWork();
$company->deleteLogo();
$company->save();
ApplicationLogs::createLog($company, null, ApplicationLogs::ACTION_EDIT);
DB::commit();
flash_success(lang('success delete company logo'));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete company logo'));
}
// try
$this->redirectToUrl($company->getEditLogoUrl());
}
/**
* Set the status for marked time items
*
* @access public
* @param void
* @return null
*/
function setstatus()
{
if (!logged_user()->isAdministrator(owner_company())) {
flash_error(lang('no access permissions'));
$this->redirectTo('dashboard');
}
// if
$status = array_var($_GET, 'status') ? array_var($_GET, 'status') : 0;
$new_status = abs($status - 1);
$new_status_text = $new_status ? 'billed' : 'unbilled';
$items = array_var($_POST, 'item');
$redirect_to = array_var($_GET, 'redirect_to');
if ($redirect_to == '') {
$redirect_to = get_url('administration', 'time', array('status' => $status));
$redirect_to = str_replace('&', '&', trim($redirect_to));
}
// if
if (is_array($items) && count($items)) {
foreach ($items as $id => $status) {
$time = ProjectTimes::findById($id);
if (!$time instanceof ProjectTime) {
flash_error(lang('time dnx'));
$this->redirectToUrl($redirect_to);
}
// if
$time->setIsClosed($new_status);
try {
DB::beginWork();
$time->save();
ApplicationLogs::createLog($time, $time->getProject(), ApplicationLogs::ACTION_EDIT);
DB::commit();
} catch (Exception $e) {
DB::rollback();
flash_error('There was an error changing the status of one of your items.');
$this->redirectToUrl($redirect_to);
}
// try
}
// foreach
flash_success('Items successfully marked as ' . $new_status_text);
}
// if
$this->redirectToUrl($redirect_to);
}
/**
* Delete locale logo
*
* @param void
* @return null
*/
function delete_logo()
{
$locale = I18nLocales::findById(get_id());
if (!$locale instanceof I18nLocale) {
flash_error(lang('locale dnx'));
$this->redirectToReferer(get_url('i18n', 'index'));
}
// if
if (!$locale->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
$this->redirectTo('i18n', 'index');
}
// if
try {
DB::beginWork();
$locale->deleteLogo();
$locale->save();
ApplicationLogs::createLog($locale, 0, ApplicationLogs::ACTION_EDIT);
DB::commit();
flash_success(lang('success delete logo'));
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete logo', $e));
}
// try
$this->redirectToUrl($locale->getEditLogoUrl());
}
function delete_chart()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$chart = ProjectCharts::findById(get_id());
if (!$chart instanceof ProjectChart) {
flash_error(lang('chart dnx'));
ajx_current("empty");
return;
}
// if
if (!$chart->canDelete(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
try {
DB::beginWork();
$chart->trash();
ApplicationLogs::createLog($chart, $chart->getWorkspaces(), ApplicationLogs::ACTION_TRASH);
DB::commit();
flash_success(lang('success deleted chart', $chart->getTitle()));
ajx_current("back");
} catch (Exception $e) {
DB::rollback();
flash_error(lang('error delete chart'));
ajx_current("empty");
}
// try
}
