So, I created a custom dashlet to display data specific to my company. The thing is I needed to use our dataset rather than SuiteCRM’s. So, I made that work. Actually, the entire dashlet works.
The issue is that it doesn’t display inside the dashlet template. Rather the dashlet shows with the pagination buttons, etc. but says “No Data”. Then below it, my data shows. I am sure there is a way to make my code work inside the standard dashlet template, but have not been able to figure this out.
Can someone point me in the right direction?
My code is below.
<?php
if (!defined('sugarEntry') || !sugarEntry)
die('Not A Valid Entry Point');
//require_once('include/Dashlets/Dashlet.php');
require_once('include/Dashlets/DashletGeneric.php');
class CustomQuotesDashlet extends DashletGeneric {
var $height; // height of the dashlet
var $title;
var $description;
var $myQuotes;
var $save;
var $quoteData = array();
/**
* Constructor
*
* @global string current language
* @param guid $id id for the current dashlet (assigned from Home module)
* @param array $def options saved for this dashlet
*/
function CustomQuotesDashlet($id, $def) {
// global $current_user, $app_strings;
$this->loadLanguage('FrtwQuotesDashlet', 'modules/Home/Dashlets/');
//require('modules/Home/Dashlets/CustomQuotesDashlet/CustomQuotesDashlet.data.php');
// parent::Dashlet($id, $def);
if (!empty($def['height'])) {
$this->height = $def['height'];
} else {
$this->height = $this->dashletStrings['LBL_OPT_HEIGHT'];
}
if (!empty($def['title'])) {
$this->title = $def['title'];
} else {
$this->title = $this->dashletStrings['LBL_OPT_TITLE'];
}
if (!empty($def['description'])) {
$this->description = $def['description'];
} else {
$this->description = $this->dashletStrings['LBL_OPT_DESCRIPTION'];
}
if (!empty($def['myQuotes'])) {
$this->myQuotes = $def['myQuotes'];
} else {
$this->myQuotes= "My Quotes";//$this->dashletStrings['LBL_OPT_MYQUOTES'];
}
//parent::Dashlet($id);
parent::DashletGeneric($id, $def);
$this->isConfigurable = true;
$this->hasScript = false;
// if no custom title, use default
/* if(empty($def['title'])) $this->title = $this->dashletStrings['LBL_TITLE'];
else $this->title = $def['title'];
*/
// $this->searchFields = $dashletData['FrtwQuotesDashlet']['searchFields'];
$this->columns = $dashletData['FrtwQuotesDashlet']['columns'];
$this->seedBean = new Task();
}
/**
* Displays the dashlet
*
* @return string html to display dashlet
*/
function display() {
require_once('include/Sugar_Smarty.php');
$sql = "SELECT QuoteNbr, revnbr, crmname, ShipToCity FROM quotes.quotehdr LIMIT 10";
$result = $GLOBALS["db"]->query($sql);
while ($quotes = $GLOBALS["db"]->fetchByAssoc($result)) {
$this->quoteData[] = $quotes;
}
$quoteData = json_decode(json_encode($this->quoteData),FALSE);
$ss = new Sugar_Smarty();
//assign variables
$ss->assign('height', $this->height);
$str = $ss->fetch('modules/Home/Dashlets/CustomQuotesDashlet/CustomQuotesDashlet.tpl');
return parent::display() . $str; // return parent::display for title and such
}
function saveOptions($req) {
global $sugar_config, $timedate, $current_user, $theme;
$options = array();
$options['title'] = $_REQUEST['title'];
//restrain height between 100 and 300 pixels
if (is_numeric($_REQUEST['height'])) {
if ($_REQUEST['height'] > 0 && $_REQUEST['height'] <= 300)
$options['height'] = $_REQUEST['height'];
elseif ($_REQUEST['height'] > 300)
$options['height'] = '300';
else
$options['height'] = '100';
}
$options['description'] = $_REQUEST['description'];
$options['myQuotes'] = $_REQUEST['myQuotes'];
return $options;
}
}
?>