function loadMoreComments($paramOne = null, $paramTwo = null)
{
$maximumQuantity = FormElements::filterInteger($paramTwo, true) + 1;
$this->sqlDataArray = array('pirnaCode' => FormElements::filterString($paramOne, true), 'initialItem' => 0, 'maximumQuantity' => $maximumQuantity);
$this->principalData = $this->model->loadMoreComments($this->sqlDataArray);
View::render('information/morecomments', $this->principalData);
}
function update($paramOne = 1)
{
$this->model->checkLogged();
$this->actualPage = FormElements::filterInteger($paramOne);
$this->initialResult = ($this->actualPage - 1) * $this->resultsPerPage;
$this->sqlDataArray = array('initialItem' => $this->initialResult, 'maximumQuantity' => $this->resultsPerPage);
$this->tempQueryData = $this->model->getListUpdate($this->sqlDataArray);
if (FlashMessages::hasFlashMessage()) {
$this->principalData['allResults'] = 0;
$this->principalData['FlashMessage'] = FlashMessages::displayFlashMessage();
} else {
$this->principalData['updateList'] = $this->tempQueryData['updateList'];
$this->principalData['urlQuery'] = $this->tempQueryData['urlQuery'];
$this->principalData['allResults'] = $this->tempQueryData['allResults'];
$this->principalData['totalPages'] = $this->tempQueryData['totalPages'];
$this->temporaryPagination = $this->model->pagination($this->actualPage, $this->tempQueryData['totalPages']);
$this->principalData['pagination'] = $this->temporaryPagination[0];
$this->principalData['activePagination'] = $this->temporaryPagination[1];
}
View::render('sidebar-admin');
View::render('administration/update', $this->principalData);
}
function searchCluster($sqlDataArray = array())
{
if (isset($_POST['search'])) {
$this->dataArray = array('cluster_chromosome' => FormElements::getPostInteger('inputSearchChromosome', true), 'cluster_start' => FormElements::getPostInteger('inputSearchStart', true), 'cluster_end' => FormElements::getPostInteger('inputSearchEnd', true));
$this->formToken = FormElements::getPostString('token', true);
parent::checkFormRequired($this->dataArray);
parent::checkFormToken($this->formToken, 'search/cluster');
} elseif (isset($_GET['cluster_chromosome']) && isset($_GET['cluster_start']) && isset($_GET['cluster_end'])) {
$this->dataArray = array('cluster_chromosome' => FormElements::filterInteger($_GET['cluster_chromosome'], true), 'cluster_start' => FormElements::filterInteger($_GET['cluster_start'], true), 'cluster_end' => FormElements::filterInteger($_GET['cluster_end'], true));
}
if (!in_array('errorRequiredField', $this->dataArray) && (isset($_GET['cluster_chromosome']) || $this->formToken === Session::getSession('formToken')) && !FlashMessages::hasFlashMessage()) {
$cookieData = date('Y-m-d') . '|cluster|' . 'cluster_chromosome|' . $this->dataArray['cluster_chromosome'] . '|cluster_start|' . $this->dataArray['cluster_start'] . '|cluster_end|' . $this->dataArray['cluster_end'];
if (isset($_COOKIE['pirna_db_cache_search'])) {
$newData = $_COOKIE['pirna_db_cache_search'] . '@' . $cookieData;
} else {
$newData = $cookieData;
}
setcookie('pirna_db_cache_search', $newData, time() + 86400 * 30 * 30, '/');
Session::unsetSession('formToken');
$this->sqlAllResults = 'SELECT cluster_code,
cluster_chromosome,
cluster_start,
cluster_end
FROM cluster
WHERE cluster_chromosome = ' . $this->dataArray['cluster_chromosome'] . ' AND
cluster_start >= ' . $this->dataArray['cluster_start'] . ' AND
cluster_end <= ' . $this->dataArray['cluster_end'];
$this->allResults = $this->db->select($this->sqlAllResults);
$this->results[0] = count($this->allResults);
$this->results[1] = ceil($this->results[0] / $sqlDataArray['maximumQuantity']);
$this->sql = 'SELECT cluster_code,
cluster_chromosome,
cluster_start,
cluster_end
FROM cluster
WHERE cluster_chromosome = ' . $this->dataArray['cluster_chromosome'] . ' AND
cluster_start >= ' . $this->dataArray['cluster_start'] . ' AND
cluster_end <= ' . $this->dataArray['cluster_end'] . '
LIMIT :initialItem, :maximumQuantity';
$this->results[2] = $this->db->select($this->sql, $sqlDataArray);
$this->results[3] = '?cluster_chromosome=' . $this->dataArray['cluster_chromosome'] . '&' . 'cluster_start=' . $this->dataArray['cluster_start'] . '&' . 'cluster_end=' . $this->dataArray['cluster_end'];
if ($this->results[0] > 0) {
return $this->results;
} else {
FlashMessages::setFlashMessage('noresult', '<b>Not Found!</b><br />None cluster was found using your query..');
}
}
}
function cluster($paramOne = 1)
{
$this->model->quantityCacheSearch();
$this->model->breadCumbs();
$this->actualPage = FormElements::filterInteger($paramOne);
$this->initialResult = ($this->actualPage - 1) * $this->resultsPerPage;
$this->sqlDataArray = array('initialItem' => $this->initialResult, 'maximumQuantity' => 5);
$this->browseData = $this->model->getBrowseCluster($this->sqlDataArray);
if (FlashMessages::hasFlashMessage()) {
$this->principalData['FlashMessage'] = FlashMessages::displayFlashMessage();
} else {
$this->principalData['countResults'] = $this->browseData['quantityAllCluster'];
$this->principalData['browseData'] = $this->browseData['clusterList'];
$this->principalData['totalPages'] = $this->browseData['totalPages'];
$this->temporaryPagination = $this->model->pagination($this->actualPage, $this->browseData['totalPages']);
$this->principalData['pagination'] = $this->temporaryPagination[0];
$this->principalData['activePagination'] = $this->temporaryPagination[1];
}
if ($this->actualPage === 1) {
$this->cannonicalUrl = URL . 'browse/cluster';
} else {
$this->cannonicalUrl = '';
}
$this->principalData['qttResultPage'] = $this->resultsPerPage;
$this->principalData['activeBrowsePirna'] = '';
$this->principalData['activeBrowseDataset'] = '';
$this->principalData['activeBrowseCluster'] = 'class="active"';
View::setHeaderVars('title', 'Browse piRNA Clusters');
View::setHeaderVars('specificKeywords', DEFAULT_KEYWORDS . ', piRNA cluster List, piRNA cluster, browse piRNA cluster');
View::setHeaderVars('description', 'Browse all the piRNA clusters in the database');
View::setHeaderVars('cannonicalUrl', $this->cannonicalUrl);
View::setHeaderVars('robots', 'index, follow');
View::render('header');
View::render('browse/cluster', $this->principalData);
View::render('footer-clean');
}