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