public function verifyDashboard($moduleName)
{
global $log;
$log->debug("Entering Vtiger_DashBoard_Model::verifyDashboard() method ...");
$adb = PearDatabase::getInstance();
$currentUser = Users_Record_Model::getCurrentUserModel();
$moduleModel = $this->getModule();
$blockId = Settings_WidgetsManagement_Module_Model::getBlocksFromModule($moduleName, $currentUser->getRole());
$query = 'SELECT * FROM `vtiger_module_dashboard` WHERE `blockid` = ?;';
if (count($blockId) == 0) {
return;
}
$params = array($blockId);
$result = $adb->pquery($query, $params);
for ($i = 0; $i < $adb->num_rows($result); $i++) {
$row = $adb->query_result_rowdata($result, $i);
$row['data'] = htmlspecialchars_decode($row['data']);
$query = 'SELECT * FROM `vtiger_module_dashboard_widgets` WHERE `userid` = ? AND `templateid` = ?;';
$params = array($currentUser->getId(), $row['id']);
$resultVerify = $adb->pquery($query, $params);
if (!$adb->num_rows($resultVerify)) {
$query = 'INSERT INTO vtiger_module_dashboard_widgets(`linkid`, `userid`, `templateid`, `filterid`, `title`, `data`, `isdefault`, `active`) VALUES(?,?,?,?,?,?,?,?);';
$active = 0;
if ($row['isdefault']) {
$active = 1;
}
$params = array($row['linkid'], $currentUser->getId(), $row['id'], $row['filterid'], $row['title'], $row['data'], $row['isdefault'], $active);
$adb->pquery($query, $params);
}
}
$log->debug("Exiting Vtiger_DashBoard_Model::verifyDashboard() method ...");
}
