Here are the steps to create new dashlet based on SugarCRM’s OOB dashlet.<\/p>\n\n\n\n
In this blog, we are extending My Open Tasks dashlet to show Tasks until NOW. <\/p>\n\n\n\n
Steps are as below,<\/p>\n\n\n\n
Step 1<\/strong>: Copy modules\/Tasks\/Dashlets\/MyTasksDashlet to custom\/modules\/Tasks\/Dashlets folder. Rename MyTasksDashlet folder to MyTasksUntilNowDashlet. <\/p>\n\n\n\n Step 2<\/strong>: Go to custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/ <\/p>\n\n\n\n Rename MyTasksDashlet.data.php to MyTasksUntilNowDashlet.data.php Step 3<\/strong>: Open custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.data.php <\/p>\n\n\n\n Find and replace MyTasksDashlet to MyTasksUntilNowDashlet <\/p>\n\n\n\n Step 4<\/strong>: Open custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.meta.php<\/p>\n\n\n\n Find and replace MyTasksDashlet to MyTasksUntilNowDashlet<\/p>\n\n\n\n Change LBL_LIST_MY_TASKS to LBL_LIST_MY_TASKS_UNTIL_NOW <\/p>\n\n\n\n Step 5<\/strong>: Open custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.php<\/p>\n\n\n\n Find and replace MyTasksDashlet to MyTasksUntilNowDashlet <\/p>\n\n\n\n Step 6<\/strong>: Lets guide Sugar to take new path Step 7<\/strong>: Lets now add custom functionality.<\/p>\n\n\n\n Add following function in the class <\/p>\n\n\n\n Step 8<\/strong>: Change the name which suits you more. <\/p>\n\n\n\n Step 9<\/strong>: Go to Admin > Repair > Quick Repair and Rebuild. Go to Home > Add dashlet and you should see the new dashlet there.<\/p>\n\n\n\n Hope it works as easy as it was while writing. <\/p>\n\n\n\n Just to make life easier pasting the final look of the main class file.
Rename MyTasksDashlet.meta.php to MyTasksUntilNowDashlet.meta.php
Rename MyTasksDashlet.php to MyTasksUntilNowDashlet.php <\/p>\n\n\n\n
Change\u00a0
require(‘modules\/Tasks\/Dashlets\/MyTasksDashlet\/MyTasksDashlet.data.php’);
to
require(‘custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.data.php’); <\/p>\n\n\n\nfunction process($lvsParams = array()) {\n global $timedate, $current_user;\n $format = $timedate->get_date_time_format($current_user);\n $dbformat = date('Y-m-d H:i:s', strtotime(date($format)));\n\/\/ MYSQL database\n $lvsParams['custom_where'] = ' AND DATE_FORMAT(tasks.date_start, \"%Y-%m-%d %H:%i:%s\") <= \"'. $dbformat.'\" ';\n \/\/ MSSQL \n\/\/ $lvsParams['custom_where'] = \" AND REPLACE(CONVERT(varchar, tasks.date_start,111),'\/','-') = '\".$dbformat.\"')\";\n parent::process($lvsParams);\n } <\/code><\/pre>\n\n\n\n
Lets now change label of the Dashlet to know which is new dashlet we just created.
Create\/Open custom\/modules\/Tasks\/language\/en_us.lang.php and add following line <\/p>\n\n\n\n<?php \n$mod_strings['LBL_LIST_MY_TASKS_UNTIL_NOW'] = 'My Open Tasks until now';<\/code><\/pre>\n\n\n\n
I.e. custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.php <\/p>\n\n\n\n<?php\n\nif (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');\n\nrequire_once('include\/Dashlets\/DashletGeneric.php');\n\nclass MyTasksUntilNowDashlet extends DashletGeneric {\n\n function MyTasksUntilNowDashlet($id, $def = null) {\n require('custom\/modules\/Tasks\/Dashlets\/MyTasksUntilNowDashlet\/MyTasksUntilNowDashlet.data.php');\n\n parent::DashletGeneric($id, $def);\n\n if (empty($def['title']))\n $this->title = translate('LBL_LIST_MY_TASKS', 'Tasks');\n\n $this->searchFields = $dashletData['MyTasksUntilNowDashlet']['searchFields'];\n $this->columns = $dashletData['MyTasksUntilNowDashlet']['columns'];\n $this->seedBean = new Task();\n }\n\n function process($lvsParams = array()) {\n global $timedate, $current_user;\n $format = $timedate->get_date_time_format($current_user);\n $dbformat = date('Y-m-d H:i:s', strtotime(date($format)));\n \n\/\/ MYSQL database\n $lvsParams['custom_where'] = ' AND DATE_FORMAT(tasks.date_start, \"%Y-%m-%d %H:%i:%s\") <= \"'. $dbformat.'\" ';\n \/\/ MSSQL \n\/\/ $lvsParams['custom_where'] = \" AND REPLACE(CONVERT(varchar, tasks.date_start,111),'\/','-') = '\".$dbformat.\"')\";\n parent::process($lvsParams);\n }\n\n}<\/code><\/pre>\n\n\n\n