function getParents($categoryId)
{
$c = new Criteria();
$c->addInnerJoin("categories", "categories.categoryId", "categoryparents.parentId");
$fields = "categoryId, name, urlName, navigationName";
return $this->categoryParent->getParents($categoryId, $c, $fields);
}
function getCategoriesForSelect()
{
$c = new Criteria();
$c->addOrder("parentId");
$c->addInnerJoin("categories", "categories.categoryId", "categoryparents.childId");
$c->add("depth", 1);
return $this->findAll($c, "categoryparents.childId as categoryId, categoryparents.parentId, name, possibleTender", true);
}
/**
* Show keywords starting with letter
*/
function showAction($letter)
{
if (!Config::get('keywordsEnabled') || !preg_match("#^[A-Z0-9]\$#", $letter)) {
return $this->return404();
}
//set adPage for display
Display::set("adPage", "letter{$letter}");
$keywordGroups = array();
//retrieve keywors which start with $letter
$keywords = $this->keyword->getKeywordsWithPrefix($letter);
$keywordIds = array();
foreach ($keywords as $keyword) {
$keywordIds[] = $keyword['keywordId'];
}
//Count validated sites which contain keyword
$c = new Criteria();
$c->add("keywordId", $keywordIds, "IN");
$c->addGroup("keywordId");
$c->addInnerJoin("sites", "sites.siteId", "keywordsofsites.siteId");
$c->add("status", "validated");
$sitesCountsForKeyword = $this->keywordsOfSite->getArray($c, "count(*)", "keywordId");
//foreach keyword on this page check have many sites include it and push it to prefix group
foreach ($keywords as $keyword) {
//if some site have this keyword
if (isset($sitesCountsForKeyword[$keyword['keywordId']])) {
$keyword['count'] = $sitesCountsForKeyword[$keyword['keywordId']];
} else {
//if no set counter to default 0
$keyword['count'] = 0;
}
//if group for this prefix doesn't exists so far
if (!isset($keywordGroups[$keyword['prefix']]['keywords'])) {
//create group for this prefix
$keywordGroups[$keyword['prefix']]['keywords'] = array();
}
//add keyword to prefix group
$keywordGroups[$keyword['prefix']]['keywords'][] = $keyword;
}
$this->set("letter", $letter);
$this->set("keywordGroups", $keywordGroups);
}
function getSitesThatOwnAKeyword($keywordId, $page = false)
{
$c = new Criteria();
$c->add("status", "validated");
$c->addInnerJoin("keywordsofsites", "keywordsofsites.siteId", "sites.siteId");
$c->add("keywordsofsites.keywordId", $keywordId);
$c->addOrder("priority DESC");
$this->addDefaultSortingOrder($c);
if ($page !== false) {
$this->addPageCriteria($c, $page, Config::get("sitesPerPageInKeywords"));
}
return $this->selectWithNewFlag($c);
}
function indexAction()
{
$c = new Criteria();
$c->addInnerJoin("sites", "sites.siteId", "siteproblems.siteId");
$this->set("siteProblems", $this->siteProblem->findAll($c, "siteproblems.*, siteTitle"));
}
function getKeywords($onlyIds = false)
{
$values = array();
if (!$this->haveKeywords) {
return $values;
}
$c = new Criteria();
$c->add("siteId", $this->siteId);
if ($onlyIds) {
$field = "keywordId";
} else {
$field = "keywords.keywordId, keyword";
$c->addInnerJoin("keywords", "keywords.keywordId", "keywordsofsites.keywordId");
}
foreach (Model::factoryInstance("keywordsOfSite")->findAll($c, $field) as $keyword) {
if ($onlyIds) {
$values[] = $keyword['keywordId'];
} else {
$values[] = $keyword;
}
}
return $values;
}
function saveExtraFieldsValues($item, $newItem)
{
$fields = $this->getCategoryFieldsWithOptions($item->categoryId);
$itemId = $item->siteId;
$c = new Criteria();
$c->addInnerJoin('extrafields', 'extrafields.fieldId', 'extrafieldvalues.fieldId');
$c->add('type', 'file');
$files = $this->extraFieldValue->getArray($c, 'text', 'extrafields.fieldId');
$c = new Criteria();
$c->add("itemId", $itemId);
$this->extraFieldValue->del($c);
foreach ($fields as $fieldId => $field) {
$extraFieldValue = new ExtraFieldValueRecord();
$extraFieldValue->itemId = $itemId;
$extraFieldValue->fieldId = $fieldId;
if (!isset($newItem->extraField[$fieldId])) {
continue;
}
$newItemExtraFieldData = $newItem->extraField[$fieldId];
try {
switch ($field['type']) {
case "text":
case "textarea":
$extraFieldValue->text = $newItemExtraFieldData;
break;
case "select":
case "radio":
if (!isset($field['options'][$newItemExtraFieldData])) {
continue 2;
}
case "range":
$extraFieldValue->value = $newItemExtraFieldData;
break;
case 'url':
$extraFieldValue->text = serialize($newItemExtraFieldData);
break;
case "checkbox":
$value = 0;
foreach ($newItemExtraFieldData as $checkBoxValue) {
if (!isset($field['options'][$checkBoxValue])) {
continue 3;
}
$value += pow(2, $checkBoxValue - 1);
//minus 1 because we count from 1,2,3,4.. to have 1,2,4,8
}
$extraFieldValue->value = $value;
break;
case 'file':
$file = new UploadedFile('extraField_' . $fieldId . '_file');
if (!empty($files[$fieldId])) {
$data = unserialize($files[$fieldId]);
} else {
$data = array();
}
$data['title'] = $newItemExtraFieldData['title'];
if ($file->wasUploaded()) {
$filesPath = CODE_ROOT_DIR . 'uploads/files/';
$file->setSavePath($filesPath);
$file->save();
$fileSrc = $file->getSavedFileName();
$data['fileSrc'] = $fileSrc;
}
$extraFieldValue->text = serialize($data);
}
$extraFieldValue->save();
} catch (Exception $e) {
}
}
$this->site->updateByPk(array("haveExtraFields" => !empty($newItem->extraField) ? "1" : "0"), $itemId);
}
/**
* Display sites which have specified keyword
*/
function keywordAction($keywordId, $name, $page)
{
//if this action is disabled
if (!Config::get('keywordsEnabled')) {
return $this->return404();
}
//set adPage for ads
Display::set("adPage", "keyword" . $keywordId);
//get keyword data
$keyword = $this->keyword->findByPk($keywordId);
$this->set("keyword", $keyword);
if (empty($keyword)) {
return $this->return404();
}
if (NameTool::strToAscii($keyword->keyword) != $name) {
$keyword->page = $page;
$this->redirect(AppRouter::getObjectUrl($keyword, "keyword"), 301);
}
//get sites which containt this keyword
$keywordSites = $this->siteList->getSitesThatOwnAKeyword($keywordId, $page);
$this->set("keywordSites", $keywordSites);
//prepare pagination data
$c = new Criteria();
$c->add("status", "validated");
$c->addInnerJoin("keywordsofsites", "keywordsofsites.siteId", "sites.siteId");
$c->add("keywordsofsites.keywordId", $keywordId);
$totalPages = ceil($this->site->getCount($c) / Config::get("sitesPerPageInKeywords"));
$this->set("pageNavigation", array("baseLink" => "/site/keyword/{$keywordId}/{$name}/", "totalPages" => $totalPages, "currentPage" => $page, "title" => $keyword->keyword));
}
