public static function sendMail($layout, $recipient) { $mailer = JFactory::getMailer(); $mailer->isHTML(true); $mailer->Encoding = 'base64'; $config = JFactory::getConfig(); $sender = array($config->getValue('config.mailfrom'), $config->getValue('config.fromname')); $mailer->setSender($sender); $mailer->addRecipient($recipient); $mailer->setSubject(TextHelper::_('COBALT_COFFEE_REPORT_SUBJECT') . ' ' . DateHelper::formatDate(date('Y-m-d'))); ob_start(); $layout->display(); $body = ob_get_contents(); ob_end_clean(); $mailer->setBody($body); $send = $mailer->Send(); if ($send !== true) { echo 'Error sending email: ' . $send->message; } }
/** * Mark events as completed * @return [type] [description] */ public function markComplete() { $app = \Cobalt\Container::fetch('app'); //Determine if we are editing a series of events of a single event $event_id = $app->input->get('event_id'); $parent_id = $app->input->get('parent_id'); $date = $app->input->get('due_date') ? $app->input->get('due_date') : $app->input->get('date'); $event_type = $app->input->get('event_type'); $repeats = $app->input->get('repeats'); $completed = $app->input->get('completed') != "" ? $app->input->get('completed') : 1; //Load Tables $oldRow = new EventTable(); $oldRow->load($event_id); //We are only editing a single event entry OR a parent entry if ($repeats == 'none') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $date = DateHelper::formatDBDate(date("Y-m-d H:i:s")); $query->update("#__events")->set(array('completed=' . $completed, 'actual_close="' . $date . '"'))->where("id=" . $event_id); $db->setQuery($query); $db->execute(); //We are dealing with a virtually generated event } else { $id = $parent_id > 0 ? $parent_id : $event_id; //Clone the event and give it the correct // new unique completion date $event = $this->getEvent($id, false); //Add the event to the parent exclusion $exp1 = explode(" ", $date); $append = $event->type == "task" ? $event->due_date : $event->start_time; $exp2 = explode(" ", $append); $excludeDate = $exp1[0] . " " . $exp2[1]; $this->addExcludes($id, $excludeDate); //Merge arrays $data = $app->input->getRequest('post'); $data['completed'] = $completed; $new_data = array_merge($event, $data); if ($event->type == "task") { $new_data['due_date'] = DateHelper::formatDate($excludeDate, false, false); $new_data['type'] = "task"; } else { $new_data['start_time'] = DateHelper::formatDate($excludeDate, false, false); $new_data['end_time'] = DateHelper::formatDate($excludeDate, false, false); $new_data['type'] = "event"; } unset($new_data['id']); unset($new_data['repeats']); unset($new_data['excludes']); // unset($new_data['parent_id']); foreach ($new_data as $key => $data) { if (is_null($data)) { $new_data[$key] = 0; } } //Store new data $id = $this->store($new_data); $event = $this->getEvent($id); //echo json_encode($event); } $row = new EventTable(); $row->load($event_id); $status = "completed"; ActivityHelper::saveActivity($oldRow, $row, 'event', $status); return JFactory::getDbo()->getAffectedRows() ? true : false; }
/** * Prepare HTML field templates for each dataTable column. * * @param string column name * @param object of item * @return string HTML template for propper field */ public function getDataTableFieldTemplate($column, $item) { switch ($column) { case 'id': $template = '<input type="checkbox" class="export" name="ids[]" value="' . $item->id . '" />'; break; case 'name': $template = '<a href="' . RouteHelper::_('index.php?view=deals&layout=deal&id=' . $item->id) . '">' . $item->name . '</a>'; break; case 'company_name': $template = '<a href="' . RouteHelper::_('index.php?view=companies&layout=company&id=' . $item->company_id) . '">' . $item->company_name . '</a>'; break; case 'amount': $template = ConfigHelper::getCurrency() . $item->amount; break; case 'status_name': if (!isset($item->status_id) || !$item->status_id) { $item->status_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $statuses = DealHelper::getStatuses(null, true); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="deal_status_' . $item->id . '_link">'; $template .= ' <span class="deal-status-' . $item->status_name . '">' . $item->status_name . '</span>'; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="deal_status_' . $item->id . '" role="menu">'; if (isset($statuses) && count($statuses)) { foreach ($statuses as $id => $name) { $template .= ' <li>'; $template .= ' <a href="#" class="status_select dropdown_item" data-field="status_id" data-item="deal" data-item-id="' . $item->id . '" data-value="' . $id . '">'; $template .= ' <span class="deal-status-' . OutputFilter::stringURLUnicodeSlug($name) . '">' . $name . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'stage_name': if (!isset($item->stage_id) || !$item->stage_id) { $item->stage_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $stages = DealHelper::getStages(null, true); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="deal_stage_' . $item->id . '_link">'; $template .= ' <span class="deal-stage-' . $item->stage_name . '">' . $item->stage_name . '</span>'; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="deal_stage_' . $item->id . '" role="menu">'; if (isset($stages) && count($stages)) { foreach ($stages as $id => $name) { $template .= ' <li>'; $template .= ' <a href="#" class="stage_select dropdown_item" data-field="stage_id" data-item="deal" data-item-id="' . $item->id . '" data-value="' . $id . '">'; $template .= ' <span class="deal-stage-' . OutputFilter::stringURLUnicodeSlug($name) . '">' . $name . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'source_name': if (!isset($item->source_id) || !$item->source_id) { $item->source_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $sources = DealHelper::getSources(null, true); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="deal_source_' . $item->id . '_link">'; $template .= ' <span class="deal-source-' . $item->source_name . '">' . $item->source_name . '</span>'; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="deal_source_' . $item->id . '" role="menu">'; if (isset($sources) && count($sources)) { foreach ($sources as $id => $name) { $template .= ' <li>'; $template .= ' <a href="#" class="source_select dropdown_item" data-field="source_id" data-item="deal" data-item-id="' . $item->id . '" data-value="' . $id . '">'; $template .= ' <span class="deal-source-' . OutputFilter::stringURLUnicodeSlug($name) . '">' . $name . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'expected_close': if ($item->expected_close == "0000-00-00 00:00:00") { $template = TextHelper::_('COBALT_NOT_SET'); } else { $template = DateHelper::formatDate($item->expected_close); } break; case 'actual_close': if ($item->actual_close == "0000-00-00 00:00:00") { $template = TextHelper::_('COBALT_ACTIVE_DEAL'); } else { $template = DateHelper::formatDate($item->actual_close); } break; case 'action': $template = '<div class="btn-group">'; // @TODO: make these 2 buttons work // $template .= ' <a rel="tooltip" title="'.TextHelper::_('COBALT_VIEW_CONTACTS').'" data-placement="bottom" class="btn" href="javascript:void(0);" onclick="Cobalt.showDealContactsDialogModal('.$item->id.');"><i class="glyphicon glyphicon-user"></i></a>'; // $template .= ' <a rel="tooltip" title="'.TextHelper::_('COBALT_VIEW_NOTES').'" data-placement="bottom" class="btn" href="javascript:void(0);" onclick="openNoteModal(\'.deal->id.\',\'deal\');"><i class="glyphicon glyphicon-file"></i></a>'; $template .= ' <a data-toggle="popover" title="' . TextHelper::_('COBALT_VIEW_DETAILS') . '" data-placement="top" data-html="true" data-content-class="extras-' . $item->id . '" class="btn btn-xs btn-default" href="#" tabindex="0"><i class="glyphicon glyphicon-info-sign"></i></a>'; $template .= '</div>'; $template .= '<div class="extras-' . $item->id . ' hide">'; $template .= ' <b>' . TextHelper::_('COBALT_PRIMARY_CONTACT') . '</b>'; $template .= ' <a href="' . RouteHelper::_('index.php?view=people&layout=person&id=' . $item->primary_contact_id) . '">' . $item->primary_contact_first_name . '</a><br>'; $template .= ' <b>' . TextHelper::_('COBALT_NEXT_ACTION') . '</b><br>'; $template .= '</div>'; break; default: if (isset($column) && isset($item->{$column})) { $template = $item->{$column}; } else { $template = ''; } break; } return $template; }
/** * Get custom field values from picklists // forecasts // otherwise return the value as it was an input field */ public static function getCustomValue($customType, $customNameOrId, $customValue, $itemId) { $db = \Cobalt\Container::fetch('db'); $query = $db->getQuery(true); $id = str_replace("custom_", "", $customNameOrId); $query->select("c.type,c.values")->from("#__" . $customType . "_custom AS c")->where("c.id=" . $id); $db->setQuery($query); $custom = $db->loadObject(); switch ($custom->type) { case "forecast": $query->clear(); $query->select("(d.amount * ( d.probability / 100 )) AS amount")->from("#__deals AS d")->where("d.id=" . $itemId); $db->setQuery($query); $result = $db->loadResult(); return ConfigHelper::getCurrency() . $result; break; case "currency": return ConfigHelper::getCurrency() . $customValue; break; case "picklist": $values = json_decode($custom->values); return array_key_exists($customValue, $values) ? $values[$customValue] : TextHelper::_('COBALT_NONE'); break; case "date": return DateHelper::formatDate($customValue); break; default: return $customValue; break; } return $customValue; }
public function getConversation($id) { //initialize query $query = $this->db->getQuery(true)->select("c.*, u.first_name as owner_first_name, u.last_name as owner_last_name,author.email")->from("#__conversations as c")->where("c.id=" . (int) $id)->where("c.published=" . $this->published)->leftJoin("#__users AS u ON u.id = c.author")->leftJoin("#__users AS author on author.id=u.id"); $results = $db->setQuery($query)->loadAssocList(); //clean results if (count($results) > 0) { foreach ($results as $key => $convo) { $results[$key]['created_formatted'] = DateHelper::formatDate($convo['created']); $results[$key]['owner_avatar'] = CobaltHelper::getGravatar($convo['email']); } } return $results; }
public function getNotes($object_id = NULL, $type = NULL, $display = true) { $app = \Cobalt\Container::fetch('app'); //grab db $db = JFactory::getDBO(); //initialize query $query = $db->getQuery(true); //gen query string $query->select("n.*,cat.name as category_name,comp.name as company_name,\n comp.id as company_id,deal.name as deal_name,deal.id as deal_id,\n person.id as person_id,person.first_name as person_first_name,\n person.last_name as person_last_name, owner.first_name as owner_first_name,\n event.name as event_name, event.id as event_id,\n owner.last_name as owner_last_name, author.email"); $query->from("#__notes as n"); $query->leftJoin("#__notes_categories AS cat ON cat.id = n.category_id"); $query->leftJoin("#__companies AS comp ON comp.id = n.company_id AND comp.published>0"); $query->leftJoin("#__events AS event ON event.id = n.event_id AND event.published>0"); $query->leftJoin("#__deals AS deal ON deal.id = n.deal_id AND deal.published>0"); $query->leftJoin("#__people AS person on n.person_id = person.id AND person.published>0"); $query->leftJoin("#__users AS owner ON n.owner_id = owner.id"); $query->leftJoin("#__users AS author ON author.id = owner.id"); $company_filter = $this->getState('Note.company_name'); if ($company_filter != null) { $query->where("comp.name LIKE '%" . $company_filter . "%'"); } //deal $deal_filter = $this->getState('Note.deal_name'); if ($deal_filter != null) { $query->where("deal.name LIKE '%" . $deal_filter . "%'"); } //person $person_filter = $this->getState('Note.person_name'); if ($person_filter != null) { } if ($object_id) { switch ($type) { case 'person': case 'people': $query->where('n.person_id =' . $object_id); break; case 'company': $query->where('(n.company_id =' . $object_id . ' OR deal.company_id = ' . $object_id . ' OR person.company_id = ' . $object_id . ")"); break; case 'deal': $query->where('n.deal_id=' . $object_id); break; case "event": $query->where("n.event_id={$object_id}"); break; } } //owner $owner_filter = $this->getState('Note.owner_id'); if ($owner_filter != null && $owner_filter != "all") { $owner_type = $this->getState('Note.owner_type'); switch ($owner_type) { case "team": $team_member_ids = UsersHelper::getTeamUsers($owner_filter, TRUE); $query->where("n.owner_id IN (" . implode(',', $team_member_ids) . ")"); break; case "member": $query->where("n.owner_id=" . $owner_filter); break; } } //created $created_filter = $this->getState('Note.created'); if ($company_filter != null) { } //category $category_filter = $this->getState('Note.category_id'); if ($category_filter != null) { $query->where("n.category_id=" . $category_filter); } if ($this->_id) { if (is_array($this->_id)) { $query->where("n.id IN (" . implode(',', $this->_id) . ")"); } else { $query->where("n.id={$this->_id}"); } } /** --------------------------------------------------------------- * Filter data using member role permissions */ $member_id = UsersHelper::getUserId(); $member_role = UsersHelper::getRole(); $team_id = UsersHelper::getTeamId(); if ($this->public_notes != true) { if ($member_role != 'exec') { //manager filter if ($member_role == 'manager') { $query->where('owner.team_id = ' . $team_id); } else { //basic user filter $query->where(array('n.owner_id = ' . $member_id)); } } } $query->where("n.published=" . $this->published); $query->order("n.modified DESC"); //load results $db->setQuery($query); $results = $db->loadAssocList(); //clean results if (count($results) > 0) { foreach ($results as $key => $note) { $results[$key]['created_formatted'] = DateHelper::formatDate($note['created']); $results[$key]['owner_avatar'] = CobaltHelper::getGravatar($note['email']); } } //$app->triggerEvent('onNoteLoad', array(&$results)); if (!$display) { //return results return $results; } else { $notesView = ViewHelper::getView('note', 'default', 'phtml', array('notes' => $results)); return $notesView; } }
/** * Prepare HTML field templates for each dataTable column. * * @param string column name * @param object of item * @return string HTML template for propper field */ public function getDataTableFieldTemplate($column, $item) { switch ($column) { case 'id': $template = '<input type="checkbox" class="export" name="ids[]" value="' . $item->id . '" />'; break; case 'avatar': if (isset($item->avatar) && $item->avatar) { $template = '<img id="avatar_img_' . $item->id . '" data-item-type="people" data-item-id="' . $item->id . '" class="avatar" src="' . JURI::base() . 'src/Cobalt/media/avatars/' . $item->avatar . '"/>'; } else { $template = '<img id="avatar_img_' . $item->id . '" data-item-type="people" data-item-id="' . $item->id . '" class="avatar" src="' . JURI::base() . 'src/Cobalt/media/images/person.png' . '"/>'; } break; case 'name': $template = '<a href="' . RouteHelper::_('index.php?view=people&layout=person&id=' . $item->id) . '">' . $item->first_name . ' ' . $item->last_name . '</a>'; break; case 'company_name': $template = '<a href="' . RouteHelper::_('index.php?view=companies&layout=company&id=' . $item->company_id) . '">' . $item->company_name . '</a>'; break; case 'owner': if (!isset($item->owner_last_name) || !$item->owner_last_name) { $item->status_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $me = array(array('label' => TextHelper::_('COBALT_ME'), 'value' => UsersHelper::getLoggedInUser()->id)); $users = UsersHelper::getUsers(null, true); $users = array_merge($me, $users); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="oerson_owner_' . $item->id . '_link">'; $template .= $item->owner_first_name . ' ' . $item->owner_last_name; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="deal_status_' . $item->id . '" role="menu">'; if (isset($users) && count($users)) { foreach ($users as $id => $user) { $template .= ' <li>'; $template .= ' <a href="#" class="owner_select dropdown_item" data-field="owner_id" data-item="person" data-item-id="' . $item->id . '" data-value="' . $user['value'] . '">'; $template .= ' <span class="person-owner-' . OutputFilter::stringURLUnicodeSlug($user['value']) . '">' . $user['label'] . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'status_name': if (!isset($item->status_id) || !$item->status_id) { $item->status_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $statuses = PeopleHelper::getStatusList(); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="deal_stage_' . $item->id . '_link">'; $template .= ' <span class="person-status-' . $item->status_name . '">' . $item->status_name . '</span>'; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="deal_stage_' . $item->id . '" role="menu">'; if (isset($statuses) && count($statuses)) { foreach ($statuses as $id => $status) { $template .= ' <li>'; $template .= ' <a href="#" class="status_select dropdown_item" data-field="status_id" data-item="people" data-item-id="' . $item->id . '" data-value="' . $status['id'] . '">'; $template .= ' <span class="person-status-' . OutputFilter::stringURLUnicodeSlug($status['id']) . '">' . $status['name'] . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'source_name': if (!isset($item->source_id) || !$item->source_id) { $item->source_name = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $sources = DealHelper::getSources(null, true); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="person_source_' . $item->id . '_link">'; $template .= ' <span class="person-source-' . $item->source_name . '">' . $item->source_name . '</span>'; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="person_source_' . $item->id . '" role="menu">'; if (isset($sources) && count($sources)) { foreach ($sources as $id => $name) { $template .= ' <li>'; $template .= ' <a href="#" class="source_select dropdown_item" data-field="source_id" data-item="people" data-item-id="' . $item->id . '" data-value="' . $id . '">'; $template .= ' <span class="person-source-' . OutputFilter::stringURLUnicodeSlug($name) . '">' . $name . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'type': if (!isset($item->type) || !$item->type) { $item->type = TextHelper::_('COBALT_CLICK_TO_EDIT'); } $types = PeopleHelper::getPeopleTypes(false); $template = '<div class="dropdown">'; $template .= ' <a href="#" class="dropdown-toggle update-toggle-html" role="button" data-toggle="dropdown" id="person_type_' . $item->id . '_link">'; $template .= $item->type; $template .= ' </a>'; $template .= ' <ul class="dropdown-menu" aria-labelledby="person_type_' . $item->id . '" role="menu">'; if (isset($types) && count($types)) { foreach ($types as $id => $name) { $template .= ' <li>'; $template .= ' <a href="#" class="type_select dropdown_item" data-field="type" data-item="people" data-item-id="' . $item->id . '" data-value="' . $id . '">'; $template .= ' <span class="person-type-' . OutputFilter::stringURLUnicodeSlug($name) . '">' . $name . '</span>'; $template .= ' </a>'; $template .= ' </li>'; } } $template .= ' </ul>'; $template .= ' </div>'; break; case 'notes': // $template = '<a rel="tooltip" title="'.TextHelper::_('COBALT_VIEW_NOTES').'" data-placement="bottom" class="btn" href="#" onclick="Cobalt.openNoteModal('.$item->id.', \'people\');"><i class="glyphicon glyphicon-file"></i></a>'; $template = ''; // @TODO: Implement notes modal break; case 'address': $template = $item->work_city . '<br>' . $item->work_state . '<br>' . $item->work_zip . '<br>' . $item->work_country; break; case 'created': $template = DateHelper::formatDate($item->created); break; case 'modified': $template = DateHelper::formatDate($item->modified); break; default: if (isset($column) && isset($item->{$column})) { $template = $item->{$column}; } else { $template = ''; } break; } return $template; }
/** * Prepare HTML field templates for each dataTable column. * * @param string column name * @param object of item * @return string HTML template for propper field */ public function getDataTableFieldTemplate($column, $item) { switch ($column) { case 'id': $template = '<input type="checkbox" class="export" name="ids[]" value="' . $item->id . '" />'; break; case 'name': $template = '<div class="title_holder">'; $template .= '<a href="' . RouteHelper::_('index.php?view=companies&layout=company&company_id=' . $item->id) . '">' . $item->name . '</a>'; $template .= '</div>'; if ($item->address_formatted != '') { $template .= '<address>' . $item->address_formatted . '</address>'; } $template .= '<div class="hidden"><small>' . $item->description . '</small></div>'; break; case 'contact_info': $template = $item->phone . '<br>' . $item->email; break; case 'modified': $template = DateHelper::formatDate($item->modified); break; case 'created': $template = DateHelper::formatDate($item->created); break; case 'action': $template = '<div class="btn-group">'; // @TODO: make these 2 buttons work // $template .= ' <a rel="tooltip" title="'.TextHelper::_('COBALT_VIEW_CONTACTS').'" data-placement="bottom" class="btn" href="#" onclick="showCompanyContactsDialogModal('.$item->id.')"><i class="glyphicon glyphicon-user"></i></a>'; // $template .= ' <a rel="tooltip" title="'.TextHelper::_('COBALT_VIEW_NOTES').'" data-placement="bottom" class="btn" href="#" onclick="openNoteModal('.$item->id.',\'company\');"><i class="glyphicon glyphicon-file"></i></a>'; $template .= '</div>'; break; default: if (isset($column) && isset($item->{$column})) { $template = $item->{$column}; } else { $template = ''; } break; } return $template; }
/** * Prepare HTML field templates for each dataTable column. * * @param string column name * @param object of item * @return string HTML template for propper field */ public function getDataTableFieldTemplate($column, $item) { switch ($column) { case 'id': $template = '<input type="checkbox" class="export" name="ids[]" value="' . $item->id . '" />'; break; case 'type': $file_path = sprintf('%s/media/images/%s.png', JPATH_COBALT, $item->filetype); if (file_exists($file_path)) { $file_src = sprintf('%s/src/Cobalt/media/images/%s.png', JUri::base(), $item->filetype); $template = '<img src="' . $file_src . '" >'; } else { $file_src = sprintf('%s/src/Cobalt/media/images/file.png', JUri::base()); $template = '<img src="' . $file_src . '" >'; } break; case 'name': $template = '<div class="dropdown"><span class="caret"></span><a id="' . $item->id . '" class="document_edit dropdown-toggle" data-toggle="dropdown" role="button" href="javascript:void(0);"> ' . $item->name . '</a>'; $template .= '<ul class="dropdown-menu" role="menu">'; $template .= '<li><a href="' . RouteHelper::_('index.php?task=PreviewDocument&format=raw&tmpl=component&document=' . $item->filename) . '" target="_blank" class="document_preview" id="preview_' . $item->id . '"><i class="glyphicon glyphicon-eye-open"></i> ' . TextHelper::_('COBALT_PREVIEW') . '</a></li>'; $template .= '<li><a href="' . RouteHelper::_('index.php?task=DownloadDocument&format=raw&tmpl=component&document=' . $item->filename) . '" target="_blank" class="document_download" id="download_' . $item->id . '"><i class="glyphicon glyphicon-download"></i> ' . TextHelper::_('COBALT_DOWNLOAD') . '</a></li>'; if ($item->owner_id == UsersHelper::getLoggedInUser()->id) { $template .= '<li><a href="javascript:void(0);" class="document_delete" id="delete_' . $item->id . '"><i class="glyphicon glyphicon-remove"></i> ' . TextHelper::_('COBALT_DELETE') . '</a></li>'; } $template .= '</ul></div>'; break; case 'association': $association_type = $item->association_type; //assign association link switch ($association_type) { case "deal": $view = 'deals'; $association_type = "deal"; $item->association_name = $item->deal_name; break; case "person": $view = "people"; $association_type = "person"; $item->association_name = $item->owner_first_name . " " . $item->owner_last_name; break; case "company": $view = "companies"; $association_type = "company"; $item->association_name = $item->company_name; break; } if (isset($item->association_name)) { $template = '<a href="' . RouteHelper::_('index.php?view=' . $view . '&layout=' . $association_type . '&id=' . $item->association_id) . '" >' . $item->association_name; } else { $template = ""; } break; case 'owner': $template = $item->owner_name; break; case 'size': $template = FileHelper::sizeFormat($item->size); break; case 'created': $template = DateHelper::formatDate($item->created); break; case 'modified': $template = DateHelper::formatDate($item->modified); break; default: if (isset($column) && isset($item->{$column})) { $template = $item->{$column}; } else { $template = ''; } break; } return $template; }
public static function getElapsedTime($date, $showDays = TRUE, $showMonths = TRUE, $showYears = TRUE, $showHours = TRUE, $showMinutes = TRUE, $showSeconds = FALSE) { $time = time() - strtotime($date); // to get the time since that moment $tokens = array(31536000 => 'year', 2592000 => 'month', 604800 => 'week', 86400 => 'day', 3600 => 'hour', 60 => 'minute', 1 => 'second'); foreach ($tokens as $unit => $text) { if ($time < $unit) { continue; } $numberOfUnits = floor($time / $unit); return $numberOfUnits . ' ' . $text . ($numberOfUnits > 1 ? 's' : ''); } return DateHelper::formatDate($date); }