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 ..."); }