function getItemPhotos($itemId)
{
$c = new Criteria();
$c->add("itemId", $itemId);
$c->addOrder("photoId");
return $this->findAll($c, "photoId, src, altText");
}
public function getTagCloud()
{
$c = new Criteria();
$c->addOrder("searchTimes DESC");
$c->add("banned", "0");
$c->setLimit(Config::get("numberOfTagInTagCloud"));
$tags = $this->findAll($c);
if (count($tags) < min(Config::get("numberOfTagInTagCloud"), Config::get("minNumberOfTagInTagCloud"))) {
return array();
}
usort($tags, array($this, "sortTag"));
$maxSearchTimes = 0;
$minSearchTimes = pow(2, 32);
$minSize = 1;
$maxSize = 10;
foreach ($tags as $tag) {
$maxSearchTimes = max($maxSearchTimes, $tag['searchTimes']);
}
foreach ($tags as $tag) {
$minSearchTimes = min($minSearchTimes, $tag['searchTimes']);
}
$range = $maxSearchTimes - $minSearchTimes;
if ($range == 0) {
$range = 1;
}
$step = ($maxSize - $minSize) / $range;
foreach ($tags as &$tag) {
$tag['size'] = intval($minSize + ($tag['searchTimes'] - $minSearchTimes) * $step);
}
return $tags;
}
function searchValidated($values, $page = false)
{
$c = new Criteria();
$c->add("status", "validated");
$c->add($this->getForbiddenRule());
$c->addOrder("sites.priority DESC");
$this->addDefaultSortingOrder($c);
if (!empty($values['phrase']) || !empty($values['where'])) {
$phrase = !empty($values['phrase']) ? $values['phrase'] : false;
$where = !empty($values['where']) ? $values['where'] : false;
$c->add($this->createSearchCriteria($phrase, $where));
}
if (empty($values['categoryId'])) {
$values['categoryId'] = 0;
}
if (isset($values['categoryId'])) {
$c->addInnerJoin("categoryparents", "categoryparents.childId", "sites.categoryId");
$c->add("categoryparents.parentId", $values['categoryId']);
if (!empty($values['extraField'])) {
$c2 = $this->extraField->createExtraFieldsCriteria($values['categoryId'], $values['extraField']);
$c->add($c2);
}
}
if ($page !== false) {
$c->setPagination($page, Config::get("sitesPerPageInSearch"));
}
$c->setCalcFoundRows(true);
$items = $this->selectWithNewFlag($c);
return $items;
}
/**
* Display category data (subcategories, sites inside, forms to add site in this category or set ads)
*/
function indexAction($parentCategoryId = 0, $page = 1)
{
//if isn't root category = 0
if ($parentCategoryId) {
$perPage = 50;
//get category data
$currentCategory = $this->category->findByPk($parentCategoryId);
//if this category doesn't exists'
if (!$currentCategory) {
return $this->return404();
}
//set category data
$this->set("currentCategory", $currentCategory);
//get validated sites inside this category
$c = new Criteria();
$c->setPagination($page, $perPage);
$this->set("sites", $this->siteList->getSitesInCategory($parentCategoryId, $c));
//prepare pagination data
$c = new Criteria();
$c->add("categoryId", $parentCategoryId);
$c->add("status", "validated");
$totalPages = ceil($this->site->getCount($c) / $perPage);
$this->set("pageNavigation", array("baseLink" => "/admin/category/index/{$parentCategoryId}/", "totalPages" => $totalPages, "currentPage" => $page));
$c = new Criteria();
$c->add("role", "webmaster");
$this->set("webmasters", $this->user->getArray($c, "email"));
$this->set("tempId", md5(rand()));
}
//set this category id
$this->set("parentCategoryId", $parentCategoryId);
//get category parents path
$this->set("categoryParentsData", $this->category->getParents($parentCategoryId));
//get select menu for categories
$this->set("categoriesSelect", $this->category->createOptionsList());
//set data for site form
$this->set("allKeywordsList", $this->keyword->generateSortedList());
$this->set("yesNoOptions", array("0" => _t("No"), "1" => _t("Yes")));
$this->set("priorites", range(0, 10));
$this->set("adCriterias", $this->adCriteria->getSelectList());
//get subcategories in this category
$c = new Criteria();
$c->addOrder("position");
$c->addOrder("name");
$this->set("categories", $this->category->getChilds($parentCategoryId, false, $c));
require CODE_ROOT_DIR . "config/flags.php";
$this->set("countryFlags", $countryFlags);
}
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);
}
function getSiteValidatedComments($siteId)
{
$c = new Criteria();
$c->add("siteId", $siteId);
$c->add("validated", "1");
$c->addOrder("commentId DESC");
return $this->comment->findAll($c);
}
function getOptions($fieldId)
{
$c = new Criteria();
$c->add("fieldId", $fieldId);
$c->addOrder("position");
$options = $this->extraFieldOption->findAll($c);
return $options;
}
function indexAction($page = 1)
{
$perPage = 25;
$c = new Criteria();
$c->addOrder("searchTimes DESC");
$c->setPagination($page, $perPage);
$tags = $this->searchTag->findAll($c);
$this->set("tags", $tags);
//prepare pagination data
$totalPages = ceil($this->searchTag->getCount() / $perPage);
$this->set("pageNavigation", array("baseLink" => "/admin/tag/index/", "totalPages" => $totalPages, "currentPage" => $page));
}
function getChilds($categoryId, $recursive = false, $c = null, $fields = "*")
{
if ($c === null) {
$c = new Criteria();
$c->addOrder("name");
} else {
$c = clone $c;
}
if ($recursive) {
$c->addInnerJoin("categories", "categories.categoryId", "categoryparents.childId");
return $this->categoryParent->getChilds($categoryId, true, $c, $fields);
} else {
$c->add("parentCategoryId", $categoryId);
return $this->findAll($c, $fields);
}
}
/**
* Display left menu categories
*/
function displayCategoriesAction()
{
//get category to display set in /site/category
$parentId = Display::get("currentCategoryId", 0);
$cacheItemName = "categoryMenuHtml" . $parentId . Config::get("language") . "Template" . Config::get("templateName");
//check is this menu was cached before
$cache = Cacher::getInstance();
if (($categoriesHtml = $cache->load($cacheItemName, false)) === null) {
$c = new Criteria();
$c->addOrder('position, name');
$categories = $this->category->getChilds($parentId, false, $c);
$this->set("categories", $categories);
$this->viewFile = "menuleft/categories";
$categoriesHtml = $this->render();
$cache->save($categoriesHtml, $cacheItemName, false, array("category"));
}
return $categoriesHtml;
}
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);
}
public function getChilds($parentId, $recursive = false, Criteria $c = null, $fields = null)
{
if (empty($c)) {
$c = new Criteria();
}
if (empty($fields)) {
$fields = "childId";
if ($recursive) {
$fields .= ", depth";
}
}
$c->add("parentId", $parentId);
if (!$recursive) {
$c->add("depth", 1);
} else {
$c->addOrder("depth");
}
return $this->findAll($c, $fields);
}
/**
* Display all criterions - managment page
*/
function indexAction()
{
$c = new Criteria();
$c->addOrder("name");
$this->set("adCriterias", $this->adCriteria->findAll($c));
}
$pers_tipo = $personal->pers_tipo;
$per_ID = $persona->per_ID;
$bloques_horario = $class_horario->generarBloques();
$smarty->assign("bloques_horario", $bloques_horario);
$horario->FK_personal_pers_ID = $personal->pers_ID;
$horario->hrs_anio = $_SESSION['base_datos']->anio;
$criteria->find($horario);
$valores_horario['lunes'] = explode(";", $horario->hrs_lunes);
$valores_horario['martes'] = explode(";", $horario->hrs_martes);
$valores_horario['miercoles'] = explode(";", $horario->hrs_miercoles);
$valores_horario['jueves'] = explode(";", $horario->hrs_jueves);
$valores_horario['viernes'] = explode(";", $horario->hrs_viernes);
$valores_horario['sabado'] = explode(";", $horario->hrs_sabado);
$smarty->assign("valores_horario", $valores_horario);
$criteria->createCriteria($observacion);
$criteria->addOrder(Order::desc("obs_ID"));
$criteria->add(Restrictions::eq("FK_persona_per_ID", $persona->per_ID));
$criteria->add(Restrictions::eq("obs_anio", $_SESSION['base_datos']->anio));
$listObservaciones = $criteria->lista();
$smarty->assign("listObservaciones", $listObservaciones);
}
if (isset($_GET['exito']) && !isset($_POST['guardar'])) {
if ($_GET['exito'] == "exito") {
$smarty->assign("exito", "La información se ha guardado exitosamente");
}
}
if (isset($_POST['guardar']) && postForm($_POST['postID'])) {
if ($_POST['guardar'] == "Enviar Foto") {
if ($persona->per_ID) {
subirFotoAlumno($per_ID);
}
/**
* Managment panel list of all sites which can be managed
*/
function manageAction()
{
$c = new Criteria();
$c->add("webmasterId", $this->userId);
$c->add("sites.status", "banned", "<>");
$c->addOrder("sites.status");
$c->addOrder("siteTitle");
$c->addLeftJoin("packages", "packages.packageId", "sites.packageId");
$sites = $this->site->findAll($c, "sites.*, packages.name as packageName");
$this->site->attachParents($sites);
$this->set("sites", $sites);
}
if ($periodo == "1S") {
$selectPeriodo1 = "yellow";
$selectPeriodo2 = "";
$offset = 1;
} else {
$selectPeriodo1 = "";
$selectPeriodo2 = "yellow";
$offset = 16;
}
$ramo->ramo_ID = $_GET['ramo'];
$curso->curso = $_GET['curso'];
$alumnos->curso = $curso->curso;
$alumnos->ultima_matricula = $session->getBase_datos()->getAnio();
$criteria->find($ramo);
$criteria->find($curso);
$criteria->addOrder(Order::desc("lista, apellidop, apellidom, nombres"));
$criteria->find($alumnos);
$listAlumnos = $criteria->listResult();
$criteria = new Criteria();
$listaAlumnos = array();
$numLista = array();
$listaColores = array();
$class_notas = new notas();
if (isset($_POST['n'])) {
$arrayNotas = $_POST['n'];
if (count($arrayNotas > 0)) {
foreach ($arrayNotas as $rut => $arrayNotaAlum) {
$criteria = new Criteria();
$notaAlumno = new EntityNotas();
$notaAlumno->rut = $rut;
$notaAlumno->ramo = $ramo->nombre;
function generateSortedList()
{
$c = new Criteria();
$c->addOrder("keyword");
return $this->getArray($c, "keyword");
}
echo "<hr>Entitades en la carpeta generation:<hr>";
$criteriaDBDefault = $_POST["database"];
$criteriaGenerate = new CriteriaGenerate($criteriaDBDefault);
$criteriaGenerate->generateEntity();
listar_directorios_ruta(CRITERIA_PATH_RELATIVE . "generation");
break;
case "CARGAR_PRUEBAS":
echo "Cargando Pruebas";
require_once 'generation/EntityBecas.php';
// require_once 'generation/EntityArancel.php';
$criteria = new Criteria();
$becas = new EntityBecas();
$criteria->createCriteria($becas);
$criteria->add(Restrictions::eq("beca_anio", "2011"));
$criteria->add(Restrictions::between("beca_ID", 4, 9));
$criteria->addOrder(Order::desc("beca_ID"));
//$criteria->
dprCriteria($criteria->getSQL());
$lol = $criteria->lista();
dprCriteria($lol);
//$criteria->add($restrictions);
// $filial = new EntityCCA_FILIAL();
// $filial->ID_FILIAL = 1;
// $criteria->find($filial);
// dpr($filial);
// $filial->APLICACION_ACTUALIZACION = "PruebMerg2";
// $criteria->merge($filial);
// $filial->ID_FILIAL = null;
// $filial->APLICACION_ACTUALIZACION = "Persist";
// $criteria->persist($filial);
// $criteria = new Criteria();
function getChildsOptionListAction()
{
$this->viewClass = "JsonView";
$categoryId = $this->request->id;
$c = new Criteria();
$c->addOrder("position");
if (!empty($this->request->all)) {
$parents = $this->category->getParents($categoryId);
$parentIds = array(0);
foreach ($parents as $parent) {
$parentIds[] = $parent['categoryId'];
}
$levels = array();
foreach ($parentIds as $parentId) {
$newLevel['selectedId'] = $parentId;
$newLevel['childs'] = $this->category->getChilds($parentId, false, $c, "categoryId as id, name, possibleTender");
$levels[] = $newLevel;
}
$this->set("levels", $levels);
} else {
$childs = $this->category->getChilds($categoryId, false, $c, "categoryId as id, name, possibleTender");
$this->set("childs", $childs);
}
}
$criteria->find($alumnoGuardar);
$alumnoGuardar->lista = $i++;
$criteria->merge($alumnoGuardar);
}
moveLocationFast("UTP-listaCurso.php?curso=" . $curso . "&exito=exito");
}
}
$orden_alfabetico = false;
if (isset($_POST['buscar'])) {
if ($_POST['buscar'] == "orden_alfabetico") {
$smarty->assign("warning", "Para que la lista quede guardada debe presionar el botón guardar");
$orden_alfabetico = true;
}
}
$criteria->createCriteria($alumno);
$criteria->add(Restrictions::eq("curso", $curso));
if (!$orden_alfabetico) {
$criteria->addOrder(Order::asc("lista"));
} else {
$criteria->addOrder(Order::asc("apellidop, apellidom, nombres"));
}
$listAlumnos = $criteria->lista();
$smarty->assign("listAlumnos", $listAlumnos);
$smarty->assign("titulo_principal", mostrar_curso($curso, true));
$smarty->assign("title", "UTP: Modificar Cursos");
$smarty->assign("titulo_secundario", "Listado Alumnos");
$menu[] = array("img" => "", "url" => "modificar_cursos.php", "text" => "Volver", "title" => "Volver", "alt" => "Volver");
$menu[] = array("img" => "", "url" => "#", "text" => "Lista Alumnos", "title" => "Lista Alumnos", "alt" => "Lista Alumnos", "id" => "", "class" => "current_page_item");
$smarty->assign("menu", $menu);
$smarty->assign("file_content", "utp/UTP-listaCurso.tpl");
$smarty->display('layout/main.tpl');
function getSimilarSites()
{
$c = new Criteria();
$c->add("categoryId", $this->categoryId);
$c->add("siteId", $this->siteId, "!=");
$c->add("status", "validated");
if (Config::get("similarSiteKeywordMatch")) {
if (empty($this->keywords)) {
return array();
}
$keywordIds = implode(",", array_keys($this->keywords));
$prefix = Config::get("DB_PREFIX");
$c->add("EXISTS(SELECT * FROM " . $prefix . "keywordsofsites\n WHERE " . $prefix . "keywordsofsites.siteId=" . $prefix . "sites.siteId AND keywordId IN ({$keywordIds}))");
}
$c->addOrder("RAND()");
$c->setLimit(Config::get("randomSitesInDetailsCount"));
$siteModel = Model::factoryInstance("site");
$sites = $siteModel->findAll($c, "siteId, siteTitle, description, categoryId");
if (Config::get("advancedUrlRewritingEnabled")) {
$siteModel->attachParents($sites);
}
return $sites;
}
function sendTestEmailAction($messageId)
{
$c = new Criteria();
$c->addOrder("RAND()");
$c->setLimit(1);
$site = $this->site->find($c);
if ($site) {
$mailer = Mailer::getInstance();
$adminEmail = $mailer->getAdminEmail();
$confirmLink = Config::get("siteRootUrl") . $this->moduleLink("confirmSiteEmail/testcode", false);
switch ($messageId) {
case "submitSite":
$mailer->sendAdminNotification($site);
break;
case "webmasterSubmitSite":
$mailer->sendWebmasterNotification($site, $adminEmail);
break;
case "validateSite":
$site->status = "validated";
$mailer->sendSiteStateUpdate($adminEmail, $site);
break;
case "refuseSite":
$site->status = "refused";
$mailer->sendSiteStateUpdate($adminEmail, $site);
break;
case "newsletterEmailAdd":
case "newsletterEmailDel":
case "siteEmail":
case "userEmail":
$mailer->sendEmailConfirmation($messageId, $adminEmail, $confirmLink);
break;
default:
$message = $this->customMessage->findByPk($messageId);
if ($message) {
$site->status = "validated";
$mailer->sendSiteStateUpdate($adminEmail, $site, $message->title, $message->description);
}
}
}
$this->redirect($this->moduleLink("email"));
}
