3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2016
35 * Class contains Contact dashboard related functions.
37 class CRM_Core_BAO_Dashboard
extends CRM_Core_DAO_Dashboard
{
41 * @param array $params
47 public static function create($params) {
48 $hook = empty($params['id']) ?
'create' : 'edit';
49 CRM_Utils_Hook
::pre($hook, 'Dashboard', CRM_Utils_Array
::value('id', $params), $params);
50 $dao = self
::addDashlet($params);
51 CRM_Utils_Hook
::post($hook, 'Dashboard', $dao->id
, $dao);
56 * Get the list of dashlets enabled by admin.
60 * @param bool $checkPermission
61 * All or only authorized for the current user.
66 public static function getDashlets($all = TRUE, $checkPermission = TRUE) {
68 $dao = new CRM_Core_DAO_Dashboard();
74 $dao->domain_id
= CRM_Core_Config
::domainID();
77 while ($dao->fetch()) {
78 if ($checkPermission && !self
::checkPermission($dao->permission
, $dao->permission_operator
)) {
83 CRM_Core_DAO
::storeValues($dao, $values);
84 $dashlets[$dao->id
] = $values;
91 * Get the list of dashlets for the current user or the specified user.
93 * Additionlly, initializes the dashboard with defaults if this is the
94 * user's first visit to their dashboard.
96 * @param bool $flatFormat
97 * This is true if you want simple associated.
98 * array of all the contact's dashlets whether or not they are enabled.
100 * @param int $contactID
101 * Provide the dashlets for the contact id.
102 * passed rather than the current user.
107 public static function getContactDashlets($flatFormat = FALSE, $contactID = NULL) {
110 // Get contact dashboard dashlets.
111 $hasDashlets = FALSE;
112 $dao = new CRM_Contact_DAO_DashboardContact();
113 $dao->contact_id
= $contactID ?
$contactID : CRM_Core_Session
::singleton()->getLoggedInContactID();
114 $dao->orderBy('column_no asc, weight asc');
117 // The available list will only include those which are valid for the domain.
118 $availableDashlets = self
::getDashlets();
119 while ($dao->fetch()) {
120 // When a dashlet is removed, it stays in the table with status disabled,
121 // so even if a user decides not to have any dashlets show, they will still
122 // have records in the table to indicate that we are not newly initializing.
123 if ((!empty($availableDashlets[$dao->dashboard_id
]) && $availableDashlets[$dao->dashboard_id
]['is_active'])) {
126 if ($dao->is_active
) {
127 // append weight so that order is preserved.
128 $dashlets[$dao->column_no
]["{$dao->weight}-{$dao->dashboard_id}"] = $dao->is_minimized
;
132 $dashlets[$dao->dashboard_id
] = $dao->dashboard_id
;
141 // If empty, then initialize contact dashboard for this user.
143 return self
::initializeDashlets($flatFormat);
149 * Setup default dashlets for new users.
151 * When a user accesses their dashboard for the first time, set up
152 * the default dashlets.
154 * @param bool $flatFormat
157 * Array of dashboard_id's
158 * @throws \CiviCRM_API3_Exception
160 public static function initializeDashlets($flatFormat = FALSE) {
162 $getDashlets = civicrm_api3("Dashboard", "get", array(
163 'domain_id' => CRM_Core_Config
::domainID(),
166 $contactID = CRM_Core_Session
::singleton()->getLoggedInContactID();
167 $allDashlets = CRM_Utils_Array
::index(array('name'), $getDashlets['values']);
168 $defaultDashlets = array();
169 $defaults = array('blog' => 1, 'getting-started' => '0');
170 foreach ($defaults as $name => $column) {
171 if (!empty($allDashlets[$name]) && !empty($allDashlets[$name]['id'])) {
172 $defaultDashlets[$name] = array(
173 'dashboard_id' => $allDashlets[$name]['id'],
175 'column_no' => $column,
176 'contact_id' => $contactID,
180 CRM_Utils_Hook
::dashboard_defaults($allDashlets, $defaultDashlets);
181 if (is_array($defaultDashlets) && !empty($defaultDashlets)) {
182 foreach ($defaultDashlets as $id => $defaultDashlet) {
183 $dashboard_id = $defaultDashlet['dashboard_id'];
184 if (!self
::checkPermission($getDashlets['values'][$dashboard_id]['permission'],
185 CRM_Utils_Array
::value('permission_operator', $getDashlets['values'][$dashboard_id]))
190 $assignDashlets = civicrm_api3("dashboard_contact", "create", $defaultDashlet);
192 $values = $assignDashlets['values'][$assignDashlets['id']];
193 $dashlets[$values['column_no']][$values['weight'] - $values['dashboard_id']] = $values['is_minimized'];
196 $dashlets[$dashboard_id] = $defaultDashlet['dashboard_id'];
206 * Check dashlet permission for current user.
208 * @param string $permission
209 * Comma separated list.
210 * @param string $operator
213 * true if use has permission else false
215 public static function checkPermission($permission, $operator) {
217 $permissions = explode(',', $permission);
218 $config = CRM_Core_Config
::singleton();
220 static $allComponents;
221 if (!$allComponents) {
222 $allComponents = CRM_Core_Component
::getNames();
225 $hasPermission = FALSE;
226 foreach ($permissions as $key) {
229 $componentName = NULL;
230 if (strpos($key, 'access') === 0) {
231 $componentName = trim(substr($key, 6));
232 if (!in_array($componentName, $allComponents)) {
233 $componentName = NULL;
237 // hack to handle case permissions
238 if (!$componentName && in_array($key, array(
239 'access my cases and activities',
240 'access all cases and activities',
243 $componentName = 'CiviCase';
246 //hack to determine if it's a component related permission
247 if ($componentName) {
248 if (!in_array($componentName, $config->enableComponents
) ||
249 !CRM_Core_Permission
::check($key)
251 $showDashlet = FALSE;
252 if ($operator == 'AND') {
257 $hasPermission = TRUE;
260 elseif (!CRM_Core_Permission
::check($key)) {
261 $showDashlet = FALSE;
262 if ($operator == 'AND') {
267 $hasPermission = TRUE;
271 if (!$showDashlet && !$hasPermission) {
279 // if permission is not set consider everyone has permission to access it.
285 * Get details of each dashlets.
287 * @param int $dashletID
291 * associted array title and content
293 public static function getDashletInfo($dashletID) {
294 $dashletInfo = array();
296 $params = array(1 => array($dashletID, 'Integer'));
297 $query = "SELECT name, label, url, fullscreen_url, is_fullscreen FROM civicrm_dashboard WHERE id = %1";
298 $dashboadDAO = CRM_Core_DAO
::executeQuery($query, $params);
299 $dashboadDAO->fetch();
302 $dao = new CRM_Contact_DAO_DashboardContact();
304 $session = CRM_Core_Session
::singleton();
305 $dao->contact_id
= $session->get('userID');
306 $dao->dashboard_id
= $dashletID;
309 //reset content based on the cache time set in config
310 $createdDate = strtotime($dao->created_date
);
311 $dateDiff = round(abs(time() - $createdDate) / 60);
313 $config = CRM_Core_Config
::singleton();
314 if ($config->dashboardCacheTimeout
<= $dateDiff) {
315 $dao->content
= NULL;
318 // if content is empty and url is set, retrieve it from url
319 if (!$dao->content
&& $dashboadDAO->url
) {
320 $url = $dashboadDAO->url
;
323 // -lets use relative url for internal use.
324 // -make sure relative url should not be htmlize.
325 if (substr($dashboadDAO->url
, 0, 4) != 'http') {
326 $urlParam = explode('?', $dashboadDAO->url
);
327 $url = CRM_Utils_System
::url($urlParam[0], $urlParam[1], TRUE, NULL, FALSE);
330 //get content from url
331 $dao->content
= CRM_Utils_System
::getServerResponse($url);
332 $dao->created_date
= date("YmdHis");
336 $dashletInfo = array(
337 'title' => $dashboadDAO->label
,
338 'name' => $dashboadDAO->name
,
339 'content' => $dao->content
,
342 if ($dashboadDAO->is_fullscreen
) {
343 $fullscreenUrl = $dashboadDAO->fullscreen_url
;
344 if (substr($fullscreenUrl, 0, 4) != 'http') {
345 $urlParam = explode('?', $dashboadDAO->fullscreen_url
);
346 $fullscreenUrl = CRM_Utils_System
::url($urlParam[0], $urlParam[1], TRUE, NULL, FALSE);
348 $dashletInfo['fullscreenUrl'] = $fullscreenUrl;
354 * Save changes made by use to the Dashlet.
356 * @param array $columns
358 * @param int $contactID
360 * @throws RuntimeException
362 public static function saveDashletChanges($columns, $contactID = NULL) {
364 $contactID = CRM_Core_Session
::getLoggedInContactID();
367 if (empty($contactID)) {
368 throw new RuntimeException("Failed to determine contact ID");
371 //we need to get existing dashlets, so we know when to update or insert
372 $contactDashlets = self
::getContactDashlets(TRUE, $contactID);
374 $dashletIDs = array();
375 if (is_array($columns)) {
376 foreach ($columns as $colNo => $dashlets) {
377 if (!is_int($colNo)) {
381 foreach ($dashlets as $dashletID => $isMinimized) {
382 $isMinimized = (int) $isMinimized;
383 if (in_array($dashletID, $contactDashlets)) {
384 $query = " UPDATE civicrm_dashboard_contact
385 SET weight = {$weight}, is_minimized = {$isMinimized}, column_no = {$colNo}, is_active = 1
386 WHERE dashboard_id = {$dashletID} AND contact_id = {$contactID} ";
389 $query = " INSERT INTO civicrm_dashboard_contact
390 ( weight, is_minimized, column_no, is_active, dashboard_id, contact_id )
391 VALUES( {$weight}, {$isMinimized}, {$colNo}, 1, {$dashletID}, {$contactID} )";
393 // fire update query for each column
394 $dao = CRM_Core_DAO
::executeQuery($query);
396 $dashletIDs[] = $dashletID;
402 if (!empty($dashletIDs)) {
403 // we need to disable widget that removed
404 $updateQuery = " UPDATE civicrm_dashboard_contact
406 WHERE dashboard_id NOT IN ( " . implode(',', $dashletIDs) . ") AND contact_id = {$contactID}";
409 // this means all widgets are disabled
410 $updateQuery = " UPDATE civicrm_dashboard_contact
412 WHERE contact_id = {$contactID}";
415 CRM_Core_DAO
::executeQuery($updateQuery);
421 * @param array $params
424 * $dashlet returns dashlet object
426 public static function addDashlet(&$params) {
428 // special case to handle duplicate entries for report instances
429 $dashboardID = CRM_Utils_Array
::value('id', $params);
431 if (!empty($params['instanceURL'])) {
433 FROM `civicrm_dashboard`
434 WHERE url LIKE '" . CRM_Utils_Array
::value('instanceURL', $params) . "&%'";
435 $dashboardID = CRM_Core_DAO
::singleValueQuery($query);
438 $dashlet = new CRM_Core_DAO_Dashboard();
441 // check url is same as exiting entries, if yes just update existing
442 if (!empty($params['name'])) {
443 $dashlet->name
= CRM_Utils_Array
::value('name', $params);
444 $dashlet->find(TRUE);
447 $dashlet->url
= CRM_Utils_Array
::value('url', $params);
448 $dashlet->find(TRUE);
450 if (empty($params['domain_id'])) {
451 $dashlet->domain_id
= CRM_Core_Config
::domainID();
455 $dashlet->id
= $dashboardID;
458 if (is_array(CRM_Utils_Array
::value('permission', $params))) {
459 $params['permission'] = implode(',', $params['permission']);
461 $dashlet->copyValues($params);
464 // now we need to make dashlet entries for each contact
465 self
::addContactDashlet($dashlet);
475 public static function getDashletName($url) {
476 $urlElements = explode('/', $url);
477 if ($urlElements[1] == 'dashlet') {
478 return $urlElements[2];
480 elseif ($urlElements[1] == 'report') {
481 return 'report/' . $urlElements[3];
487 * Update contact dashboard with new dashlet.
489 * @param object $dashlet
491 public static function addContactDashlet($dashlet) {
492 $admin = CRM_Core_Permission
::check('administer CiviCRM');
494 // if dashlet is created by admin then you need to add it all contacts.
495 // else just add to contact who is creating this dashlet
496 $contactIDs = array();
498 $query = "SELECT distinct( contact_id )
499 FROM civicrm_dashboard_contact
500 WHERE contact_id NOT IN (
501 SELECT distinct( contact_id )
502 FROM civicrm_dashboard_contact WHERE dashboard_id = {$dashlet->id}
505 $dao = CRM_Core_DAO
::executeQuery($query);
506 while ($dao->fetch()) {
507 $contactIDs[] = $dao->contact_id
;
511 //Get the id of Logged in User
512 $session = CRM_Core_Session
::singleton();
513 $contactID = $session->get('userID');
514 if (!empty($contactID)) {
515 $contactIDs[] = $session->get('userID');
519 if (!empty($contactIDs)) {
520 foreach ($contactIDs as $contactID) {
521 $valuesArray[] = " ( {$dashlet->id}, {$contactID} )";
524 $valuesString = implode(',', $valuesArray);
526 INSERT INTO civicrm_dashboard_contact ( dashboard_id, contact_id )
527 VALUES {$valuesString}";
529 CRM_Core_DAO
::executeQuery($query);
534 * @param array $params
535 * Each item is a spec for a dashlet on the contact's dashboard.
538 public static function addContactDashletToDashboard(&$params) {
539 $valuesString = NULL;
541 foreach ($params as $dashboardIDs) {
542 $contactID = CRM_Utils_Array
::value('contact_id', $dashboardIDs);
543 $dashboardID = CRM_Utils_Array
::value('dashboard_id', $dashboardIDs);
544 $column = CRM_Utils_Array
::value('column_no', $dashboardIDs, 0);
545 $columns[$column][$dashboardID] = 0;
547 self
::saveDashletChanges($columns, $contactID);
552 * Reset dashlet cache.
554 * @param int $contactID
555 * Reset cache only for specific contact.
557 public static function resetDashletCache($contactID = NULL) {
561 $whereClause = "WHERE contact_id = %1";
562 $params[1] = array($contactID, 'Integer');
564 $query = "UPDATE civicrm_dashboard_contact SET content = NULL $whereClause";
565 $dao = CRM_Core_DAO
::executeQuery($query, $params);
571 * @param int $dashletID
575 public static function deleteDashlet($dashletID) {
576 $dashlet = new CRM_Core_DAO_Dashboard();
577 $dashlet->id
= $dashletID;