*/ function getId() { return $this->get('folderid'); } /** * Function to set the if for the folder * @param */ function setId($value) { $this->set('folderid', $value); } /** * Function to get the name of the folder * @return */ function getName() { return $this->get('foldername'); } /** * Function returns the instance of Folder model * @return */ public static function getInstance() { return new self(); } /** * Function saves the folder */ function save() { $db = PearDatabase::getInstance(); $folderId = $this->getId(); if(!empty($folderId)) { $db->pquery('UPDATE vtiger_reportfolder SET foldername = ?, description = ? WHERE folderid = ?', array($this->getName(), $this->getDescription(), $folderId)); } else { $result = $db->pquery('SELECT MAX(folderid) AS folderid FROM vtiger_reportfolder', array()); $folderId = (int) ($db->query_result($result, 0, 'folderid')) + 1; $db->pquery('INSERT INTO vtiger_reportfolder(folderid, foldername, description, state) VALUES(?, ?, ?, ?)', array($folderId, $this->getName(), $this->getDescription(), 'CUSTOMIZED')); $this->set('folderid', $folderId); } } /** * Function deletes the folder */ function delete() { $db = PearDatabase::getInstance(); $db->pquery('DELETE FROM vtiger_reportfolder WHERE folderid = ?', array($this->getId())); } /** * Function returns Report Models for the folder * @param $pagingModel * @return */ function getReports($pagingModel) { $paramsList = array( 'startIndex'=>$pagingModel->getStartIndex(), 'pageLimit'=>$pagingModel->getPageLimit(), 'orderBy'=>$this->get('orderby'), 'sortBy'=>$this->get('sortby')); $reportClassInstance = Vtiger_Module_Model::getClassInstance('Reports'); $fldrId = $this->getId (); if($fldrId == 'All') { $fldrId = false; $paramsList = array( 'startIndex'=>$pagingModel->getStartIndex(), 'pageLimit'=>$pagingModel->getPageLimit(), 'orderBy'=>$this->get('orderby'), 'sortBy'=>$this->get('sortby') ); } $reportsList = $reportClassInstance->sgetRptsforFldr($fldrId, $paramsList); if(!$fldrId){ foreach ($reportsList as $reportId => $reports) { $reportsCount += count($reports); } }else{ $reportsCount = count($reportsList); } $pageLimit = $pagingModel->getPageLimit(); if($reportsCount > $pageLimit){ if(!$fldrId){ $lastKey = end(array_keys($reportsList)); array_pop($reportsList[$lastKey]); }else{ array_pop($reportsList); } $pagingModel->set('nextPageExists', true); }else{ $pagingModel->set('nextPageExists', false); } $reportModuleModel = Vtiger_Module_Model::getInstance('Reports'); if($fldrId == false) { return $this->getAllReportModels($reportsList, $reportModuleModel); } else { $reportModels = array(); for($i=0; $i < count($reportsList); $i++) { $reportModel = new Reports_Record_Model(); $reportModel->setData($reportsList[$i])->setModuleFromInstance($reportModuleModel); $reportModels[] = $reportModel; unset($reportModel); } return $reportModels; } } /** * Function to get the description of the folder * @return */ function getDescription() { return $this->get('description'); } /** * Function to get the url for edit folder from list view of the module * @return - url */ function getEditUrl() { return 'index.php?module=Reports&view=EditFolder&folderid='.$this->getId(); } /** * Function to get the url for delete folder from list view of the module * @return - url */ function getDeleteUrl() { return 'index.php?module=Reports&action=Folder&mode=delete&folderid='.$this->getId(); } /** * Function returns the instance of Folder model * @param FolderId * @return */ public static function getInstanceById($folderId) { $folderModel = Vtiger_Cache::get('reportsFolder',$folderId); if(!$folderModel){ $db = PearDatabase::getInstance(); $folderModel = Reports_Folder_Model::getInstance(); $result = $db->pquery("SELECT * FROM vtiger_reportfolder WHERE folderid = ?", array($folderId)); if ($db->num_rows($result) > 0) { $values = $db->query_result_rowdata($result, 0); $folderModel->setData($values); } Vtiger_Cache::set('reportsFolder',$folderId,$folderModel); } return $folderModel; } /** * Function returns the instance of Folder model * @return */ public static function getAll() { $db = PearDatabase::getInstance(); $folders = Vtiger_Cache::get('reports', 'folders'); if (!$folders) { $folders = array(); $result = $db->pquery("SELECT * FROM vtiger_reportfolder ORDER BY foldername ASC", array()); $noOfFolders = $db->num_rows($result); if ($noOfFolders > 0) { for ($i = 0; $i < $noOfFolders; $i++) { $folderModel = Reports_Folder_Model::getInstance(); $values = $db->query_result_rowdata($result, $i); $folders[$values['folderid']] = $folderModel->setData($values); Vtiger_Cache::set('reportsFolder',$values['folderid'],$folderModel); } } Vtiger_Cache::set('reports','folders',$folders); } return $folders; } /** * Function returns duplicate record status of the module * @return true if duplicate records exists else false */ function checkDuplicate() { $db = PearDatabase::getInstance(); $query = 'SELECT 1 FROM vtiger_reportfolder WHERE foldername = ?'; $params = array($this->getName()); $folderId = $this->getId(); if ($folderId) { $query .= ' AND folderid != ?'; array_push($params, $folderId); } $result = $db->pquery($query, $params); if ($db->num_rows($result) > 0) { return true; } return false; } /** * Function returns whether reports are exist or not in this folder * @return true if exists else false */ function hasReports() { $db = PearDatabase::getInstance(); $result = $db->pquery('SELECT 1 FROM vtiger_report WHERE folderid = ?', array($this->getId())); if ($db->num_rows($result) > 0) { return true; } return false; } /** * Function returns whether folder is Default or not * @return true if it is read only else false */ function isDefault() { if ($this->get('state') == 'SAVED') { return true; } return false; } /** * Function to get info array while saving a folder * @return Array info array */ public function getInfoArray() { return array('folderId' => $this->getId(), 'folderName' => $this->getName(), 'editURL' => $this->getEditUrl(), 'deleteURL' => $this->getDeleteUrl(), 'isEditable' => $this->isEditable(), 'isDeletable' => $this->isDeletable()); } /** * Function to check whether folder is editable or not * @return */ public function isEditable() { if ($this->isDefault()) { return false; } return true; } /** * Function to get check whether folder is deletable or not * @return */ public function isDeletable() { if ($this->isDefault()) { return false; } return true; } /** * Function to calculate number of reports in this folder * @return */ public function getReportsCount() { $db = PearDatabase::getInstance(); $params = array(); // To get the report ids which are permitted for the user $query = "SELECT reportmodulesid, primarymodule from vtiger_reportmodules"; $result = $db->pquery($query, array()); $noOfRows = $db->num_rows($result); $allowedReportIds = array(); for($i=0;$i<$noOfRows;$i++){ $primaryModule = $db->query_result($result,$i,'primarymodule'); $reportid = $db->query_result($result,$i,'reportmodulesid'); if(isPermitted($primaryModule,'index') == "yes"){ $allowedReportIds[] = $reportid; } } //End $sql = "SELECT count(*) AS count FROM vtiger_report INNER JOIN vtiger_reportfolder ON vtiger_reportfolder.folderid = vtiger_report.folderid AND vtiger_report.reportid in (".implode(',',$allowedReportIds).")"; $fldrId = $this->getId(); if($fldrId == 'All') { $fldrId = false; } // If information is required only for specific report folder? if($fldrId !== false) { $sql .= " WHERE vtiger_reportfolder.folderid=?"; array_push($params,$fldrId); } $currentUserModel = Users_Privileges_Model::getCurrentUserPrivilegesModel(); if (!$currentUserModel->isAdminUser()) { $currentUserId = $currentUserModel->getId(); $groupId = implode(',',$currentUserModel->get('groups')); if ($groupId) { $groupQuery = "(SELECT reportid from vtiger_reportsharing WHERE shareid IN ($groupId) AND setype = 'groups') OR "; } $sql .= " AND (vtiger_report.reportid IN (SELECT reportid from vtiger_reportsharing WHERE $groupQuery shareid = ? AND setype = 'users') OR vtiger_report.sharingtype = 'Public' OR vtiger_report.owner = ? OR vtiger_report.owner IN (SELECT vtiger_user2role.userid FROM vtiger_user2role INNER JOIN vtiger_users ON vtiger_users.id = vtiger_user2role.userid INNER JOIN vtiger_role ON vtiger_role.roleid = vtiger_user2role.roleid WHERE vtiger_role.parentrole LIKE ?))"; $parentRoleSeq = $currentUserModel->get('parent_role_seq').'::%'; array_push($params, $currentUserId, $currentUserId, $parentRoleSeq); } $result = $db->pquery($sql, $params); return $db->query_result($result, 0, 'count'); } /** * Function to get all Report Record Models * @param $allReportsList * @param - Reports Module Model * @return Reports Record Models */ public function getAllReportModels($allReportsList, $reportModuleModel){ $allReportModels = array(); $folders = self::getAll(); foreach ($allReportsList as $key => $reportsList) { for($i=0; $i < count($reportsList); $i++) { $reportModel = new Reports_Record_Model(); $reportModel->setData($reportsList[$i])->setModuleFromInstance($reportModuleModel); $reportModel->set('foldername', $folders[$key]->getName()); $allReportModels[] = $reportModel; unset($reportModel); } } return $allReportModels; } /** * Function which provides the records for the current view * @param $skipRecords - List of the RecordIds to be skipped * @return List of RecordsIds */ public function getRecordIds($skipRecords=false, $module) { $db = PearDatabase::getInstance(); $baseTableName = "vtiger_report"; $baseTableId = "reportid"; $folderId = $this->getId(); $listQuery = $this->getListViewQuery($folderId); if($skipRecords && !empty($skipRecords) && is_array($skipRecords) && count($skipRecords) > 0) { $listQuery .= ' AND '.$baseTableName.'.'.$baseTableId.' NOT IN ('. implode(',', $skipRecords) .')'; } $result = $db->query($listQuery); $noOfRecords = $db->num_rows($result); $recordIds = array(); for($i=0; $i<$noOfRecords; ++$i) { $recordIds[] = $db->query_result($result, $i, $baseTableId); } return $recordIds; } /** * Function returns Report Models for the folder * @return */ function getListViewQuery($folderId) { $sql = "select vtiger_report.*, vtiger_reportmodules.*, vtiger_reportfolder.folderid from vtiger_report inner join vtiger_reportfolder on vtiger_reportfolder.folderid = vtiger_report.folderid inner join vtiger_reportmodules on vtiger_reportmodules.reportmodulesid = vtiger_report.reportid "; if($folderId != "All") { $sql = $sql." where vtiger_reportfolder.folderid = ".$folderId; } return $sql; } }