/**
* Render select project template widget
*
* @param array $params
* @param Smarty $smarty
* @return string
*/
function smarty_function_select_project_template($params, &$smarty)
{
$options = array(option_tag(lang('-- Create a Blank Project --'), ''), option_tag('', ''));
$value = array_var($params, 'value', null, true);
$projects_loaded = false;
$group_id = ConfigOptions::getValue('project_templates_group');
if ($group_id) {
$group = ProjectGroups::findById($group_id);
if (instance_of($group, 'ProjectGroup')) {
$projects = Projects::findByGroup($group);
$projects_loaded = true;
if (is_foreachable($projects)) {
foreach ($projects as $project) {
$option_attributes = $project->getId() == $value ? array('selected' => true) : null;
$options[] = option_tag($project->getName(), $project->getId(), $option_attributes);
}
// if
}
// if
}
// if
}
// if
if (!$projects_loaded) {
$projects = Projects::findNamesByUser($smarty->get_template_vars('logged_user'));
if (is_foreachable($projects)) {
foreach ($projects as $k => $v) {
$option_attributes = $k == $value ? array('selected' => true) : null;
$options[] = option_tag($v, $k, $option_attributes);
}
// foreach
}
// if
}
// if
return select_box($options, $params);
}
function move_to()
{
$gettype = $_GET['gettype'];
$team_id = $_GET['team_id'];
$project_id = $_GET['project_id'];
$ticket_id = $_GET['ticket_id'];
$move_to_object_id = $_GET['move_to_object_id'];
if (!empty($gettype)) {
$this->smarty->assign('gettype', $gettype);
switch ($gettype) {
case 'projects':
$projects = array();
if (!empty($team_id)) {
$project_obj = new Project($team_id);
//$projects = Milestones::findByProject($project_obj, $this->logged_user);
$projects = Milestones::findActiveByProject($project_obj, STATE_VISIBLE, VISIBILITY_NORMAL, 'name', '', '-1');
}
$this->smarty->assign('projects', $projects);
break;
case 'tickets':
$tickets = array();
if (!empty($project_id)) {
$milestone_obj = new Milestone($project_id);
//$tickets = Tickets::findByMilestone($milestone_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
$tickets = Tickets::findOpenByMilestone($milestone_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
}
$this->smarty->assign('tickets', $tickets);
break;
case 'pages':
$pages_with_milestone = array();
$pages_with_project = array();
if (!empty($team_id)) {
$project_obj = new Project($team_id);
//$pages_with_project = Pages::findByProjectWithoutMilestoneAssociation($project_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
$pages_with_project = Pages::findUnarchivedByProjectWithoutMilestoneAssociation($project_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
} elseif (!empty($project_id)) {
if (!empty($project_id)) {
$milestone_obj = new Milestone($project_id);
$team_id = $milestone_obj->getProjectId();
//$pages_with_milestone = Pages::findByMilestone($milestone_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
$pages_with_milestone = Pages::findUnarchivedByMilestone($milestone_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
$project_obj = new Project($team_id);
//$pages_with_project = Pages::findByProjectWithoutMilestoneAssociation($project_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
$pages_with_project = Pages::findUnarchivedByProjectWithoutMilestoneAssociation($project_obj, STATE_VISIBLE, $this->logged_user->getVisibility());
}
}
$this->smarty->assign('pages_with_milestone', $pages_with_milestone);
$this->smarty->assign('pages_with_project', $pages_with_project);
break;
case 'action':
$move_to_object = new ProjectObject($move_to_object_id);
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS);
mysql_select_db(DB_NAME);
mysql_query("update healingcrystals_attachments set parent_id='" . $move_to_object->getId() . "', parent_type='" . $move_to_object->getType() . "' where id='" . $this->active_attachment->getId() . "'");
mysql_close($link);
$type = $move_to_object->getType();
$obj = new $type($move_to_object_id);
$link = 'Attachment Moved: <a href="' . $obj->getViewUrl() . '">Click to View</a>';
$this->smarty->assign('link', $link);
break;
}
} else {
$teams = Projects::findNamesByUser($this->logged_user);
$this->smarty->assign('teams', $teams);
}
$parent = $this->active_attachment->getParent();
$this->smarty->assign('cur_project_id', $parent->getProjectId());
$this->smarty->assign('cur_attachment_id', $this->active_attachment->getId());
}
function move()
{
$new_parent_id = $this->request->post('new_parent_id');
$new_parent_type = $this->request->post('new_parent_type');
$new_parent_url = '';
$move_mode = false;
if (!empty($new_parent_id) && !empty($new_parent_type)) {
$move_mode = true;
$parent_obj = $sql_part = null;
switch ($new_parent_type) {
case 'milestone':
$parent_obj = new MileStone($new_parent_id);
break;
case 'ticket':
$parent_obj = new Ticket($new_parent_id);
break;
case 'page':
$parent_obj = new Page($new_parent_id);
break;
}
if ($parent_obj) {
$body = $this->active_task->getBody();
$doc = new DOMDocument();
if ($doc->loadHTML($body)) {
$anc_tags = $doc->getElementsByTagName('a');
$new_parent_url = '';
foreach ($anc_tags as $anc) {
if ($anc->nodeValue == 'View Task in Full') {
$href = $anc->getAttribute('href');
$fragment = substr($href, strpos($href, '#'));
$anc->setAttribute('href', $parent_obj->getViewUrl() . $fragment);
break;
}
}
if (!empty($fragment)) {
$body_tag = $doc->getElementsByTagName('body');
$body = $doc->saveXML($body_tag->item(0)->firstChild);
$comment_id = str_replace('#comment', '', $fragment);
}
}
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS);
mysql_select_db(DB_NAME);
$query = "update \n\t\t\t\t\t\t\thealingcrystals_project_objects \n\t\t\t\t\t\t set \n\t\t\t\t\t\t\tproject_id='" . $parent_obj->getProjectId() . "', \n\t\t\t\t\t\t\tmilestone_id='" . $parent_obj->getMilestoneId() . "', \n\t\t\t\t\t\t\tparent_id='" . $parent_obj->getId() . "', \n\t\t\t\t\t\t\tparent_type='" . $parent_obj->getType() . "', \n\t\t\t\t\t\t\tbody = '" . mysql_real_escape_string($body) . "' \n\t\t\t\t\t\t where\tid='" . $this->active_task->getId() . "'";
mysql_query($query, $link);
if (!empty($comment_id)) {
$comment_query = "update \n\t\t\t\t\t\t\thealingcrystals_project_objects \n\t\t\t\t\t\t set \n\t\t\t\t\t\t\tproject_id='" . $parent_obj->getProjectId() . "', \n\t\t\t\t\t\t\tmilestone_id='" . $parent_obj->getMilestoneId() . "', \n\t\t\t\t\t\t\tparent_id='" . $parent_obj->getId() . "', \n\t\t\t\t\t\t\tparent_type='" . $parent_obj->getType() . "', \n\t\t\t\t\t\t\tposition=null\n\t\t\t\t\t\t where\tid='" . $comment_id . "'";
mysql_query($comment_query, $link);
}
mysql_close($link);
$new_parent_url = $parent_obj->getViewUrl() . '#task' . $this->active_task->getId();
$cache_id = TABLE_PREFIX . 'project_objects_id_' . $this->active_task->getId();
$cache_obj = cache_get($cache_id);
if ($cache_obj) {
cache_remove($cache_id);
}
}
} else {
$listing = array();
switch ($this->active_task_parent->getType()) {
case 'Milestone':
//$listing = Milestones::findByProject($this->active_project, $this->logged_user);
$listing = Milestones::findActiveByProject_custom($this->active_project);
break;
case 'Ticket':
$listing = Tickets::findOpenByProjectByNameSort($this->active_project, STATE_VISIBLE, $this->logged_user->getVisibility());
break;
case 'Page':
$categories = Categories::findByModuleSection($this->active_project, 'pages', 'pages');
$listing = Pages::findByCategories($categories, STATE_VISIBLE, $this->logged_user->getVisibility());
/*foreach($categories as $category){
$listing = array_merge($listing, Pages::findByCategory($category, STATE_VISIBLE, $this->logged_user->getVisibility()));
}*/
break;
}
$this->smarty->assign(array('teams' => Projects::findNamesByUser($this->logged_user), 'listing' => $listing, 'task_parent_id' => $this->active_task_parent->getId()));
}
$this->smarty->assign('new_parent_url', $new_parent_url);
$this->smarty->assign('move_mode', $move_mode);
}
/**
* Render jump to projects page
*
* @param void
* @return null
*/
function jump_to_project()
{
$pinned_projects = null;
$active_projects = Projects::findNamesByUser($this->logged_user, PROJECT_STATUS_ACTIVE);
if (is_foreachable($active_projects)) {
$pinned_project_ids = PinnedProjects::findProjectIdsByUser($this->logged_user);
if (is_foreachable($pinned_project_ids)) {
$pinned_projects = array();
foreach ($pinned_project_ids as $id) {
if (isset($active_projects[$id])) {
$pinned_projects[$id] = $active_projects[$id];
unset($active_projects[$id]);
}
// if
}
// if
}
// if
}
// if
$this->smarty->assign(array('active_projects' => $active_projects, 'pinned_projects' => $pinned_projects));
}
/**
* Render recent activities feed
*
* @param void
* @return null
*/
function rss()
{
require_once ANGIE_PATH . '/classes/feed/init.php';
$projects = Projects::findNamesByUser($this->logged_user);
$feed = new Feed($this->owner_company->getName() . ' - ' . lang('Recent activities'), ROOT_URL);
$feed->setDescription(lang('Recent activities in active projects'));
$activities = ActivityLogs::findActiveProjectsActivitiesByUser($this->logged_user, 50);
if (is_foreachable($activities)) {
foreach ($activities as $activity) {
$object = $activity->getObject();
$activity_title = $activity_body = $activity->renderHead();
$activity_title = strip_tags($activity_title);
if ($activity->has_body && ($body = trim($activity->renderBody()))) {
$activity_body .= $body;
}
// if
$item = new FeedItem($activity_title, $object->getViewUrl(), $activity_body, $activity->getCreatedOn());
$item->setId(extend_url($object->getViewUrl(), array('guid' => $activity->getId())));
$feed->addItem($item);
}
// foreach
}
// if
print render_rss_feed($feed);
die;
}
