public function addGaleria(Galeria $g)
{
if ($g->getId() != '' && $this->getId() != '') {
$con = BDConexao::__Abrir();
$con->executar("INSERT INTO " . Sistema::$BDPrefixo . "relacionamento_galerias_categorias(categoria, galeria) VALUES('" . $this->getId() . "','" . $g->getId() . "')");
}
}
function indexAction()
{
$oRequest = $this->getRequest();
if (!$oRequest->getParam('pro_id')) {
$this->_redirect('admin/produkty');
}
$this->view->oRequest = $oRequest;
$oProdukty = new Produkty();
$this->view->aProdukt = $oProdukty->fetchRow("pro_id={$oRequest->getParam('pro_id')}");
$oGaleria = new Galeria();
$this->view->aGaleria = $oGaleria->fetchAll("gal_pro_id={$oRequest->getParam('pro_id')}");
$oConfig = new Zend_Config_Ini(APPLICATION_PATH . '/configs/wizytowki.ini', 'wizytowki');
$this->view->sWizytowkiKatalog = $oConfig->wizytowki->uri;
}
public function listar($ordem = "ASC", $campo = self::ID)
{
$info = parent::listar($ordem, $campo);
if (!empty($info)) {
$temp = new Galeria($info[self::ID]);
parent::resgatarObjetos($info);
$temp->titulo = $info[self::TITULO];
$temp->descricao = $info[self::DESCRICAO];
$temp->local = $info[self::LOCAL];
$temp->tipo = $info[self::TIPO];
$temp->setData(new DataHora($info[self::DATA]));
$temp->setVideo($info[self::VIDEO]);
$temp->setURL($info[parent::URL]);
return $temp;
}
}
public function indexAction()
{
$galerias = Galeria::findGaleriasActive()->getData();
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($galerias));
$paginator->setItemCountPerPage(20)->setPageRange(5)->setCurrentPageNumber($this->_request->getParam('page', 1));
$this->view->galerias = $paginator;
}
public function verifyGaleria()
{
$id = (int) $this->_request->getParam('galeria');
$galeria = Galeria::findGaleria($id);
if ($galeria) {
return $galeria;
} else {
$this->_flashMessenger->addError('Galeria No Existe');
$this->_redirect('/backend/galerias');
}
}
public function editar()
{
//Aca se manda a la funcion editarItem de la clase Item
//y se queda con la respuesta para redirigir cual sea el caso
$respuesta = Galeria::editar(Input::all());
if ($respuesta['error'] == true) {
return Redirect::to('admin/item')->withErrors($respuesta['mensaje'])->withInput();
} else {
$menu = $respuesta['data']->seccionItem()->menuSeccion()->url;
$ancla = '#' . $respuesta['data']->seccionItem()->estado . $respuesta['data']->seccionItem()->id;
return Redirect::to('/' . $menu)->with('mensaje', $respuesta['mensaje'])->with('ancla', $ancla);
}
}
public function saveImg($id)
{
$file = Input::file('file');
$fileName = $file->getClientOriginalName();
$filePath = 'img/' . $fileName;
$galeria = Galeria::find($id);
$galeria->nombre = $fileName;
$galeria->ruta = $filePath;
$img = Image::make($file)->resize(1400, 510);
$img->save('img/' . $fileName);
$galeria->save();
return Redirect::to('galeria');
}
public function saveImg($id)
{
$file = Input::file('file');
$fileName = $file->getClientOriginalName();
$filePath = 'http://admin.hospitalsantabarbaradelrieti.com.mx/img/' . $fileName;
$galeria = Galeria::find($id);
$galeria->nombre = $fileName;
$galeria->ruta = $filePath;
$img = Image::make($file)->resize(1400, 510);
$path = public_path('img/' . $fileName);
$img->save($path);
$galeria->save();
return Redirect::to('galeria');
}
function eliminargaleria(Request $request, Response $response)
{
try {
$response = $response->withHeader('Content-type', 'application/json');
$id = $request->getAttribute("id");
$servicio = Galeria::select("*")->where("id", "=", $id)->delete();
$respuesta = json_encode(array('msg' => "Eliminado correctamente", "std" => 1));
$response = $response->withStatus(200);
} catch (Exception $err) {
$respuesta = json_encode(array('msg' => "error", "std" => 0, "err" => $err->getMessage()));
$response = $response->withStatus(404);
}
$response->getBody()->write($respuesta);
return $response;
}
function traerEmprendimiento()
{
require_once 'admin/class/class.galeria.php';
require "galeria_emprendimiento.inc.php";
$db = Conectar();
$sql = "SELECT * FROM emprendimientos ORDER BY id_em DESC";
$resultado = $db->query($sql);
while ($data = $resultado->fetch_object()) {
echo "\n <section class='site-emprendimiento clearfix SombraEmprendiminetos2' id='" . $data->id_em . "'>\n <div class=''>\n <div class='row Contenedor-Emprender'>\n <h2>" . $data->titulo . "</h2>\n <img src='upload/" . $data->banner . "' width='1079' />\n </div>\n </div>\n </section>\n\n <section class='VisitarTienda clearfix'>\n <div class='row Contenedor-Emprender'>\n <article class='Text-TiendaFundacion' style='width:100%;'>\n <p>" . $data->detalle . "</p>\n </article>\n </div>\n </section>";
Galeria::get($data->id_em);
if (!empty($data->video)) {
echo "<section class='VisitarTienda clearfix'>\n <div class='row Contenedor-Emprender'>\n <article class='Text-TiendaFundacion' style='width:100%;'>\n <div class='VideoEmprendimiento'>\n <iframe width='560' height='315' src='" . youTubeLink($data->video) . "' frameborder='0' allowfullscreen></iframe>\n </div> \n </article>\n </div>\n </section>";
}
// traerGaleriaEmprendimiento($data->id_em);
}
}
</div>
</div>
</section> -->
<section class="slider_principal">
<button type="button" class="arrow-left slider-button left">
<span class="icon sliderLeft"></span>
</button>
<button type="button" class="arrow-right slider-button right">
<span class="icon sliderRight"></span>
</button>
<div class="swiper-container">
<div class="swiper-wrapper">
<?php
Galeria::Fundacion();
?>
</div> <!-- /swiper-wrapper -->
<div id="galeria_preloader">
<img src="img/loading_spinner.gif" alt="Cargando...">
</div>
</div> <!-- /swiper-container -->
</section>
<section class="site-QuienesSomos clearfix" id="ContieneQuienesSomos">
<div class="row Col_1Mobile">
<h1 class="TituloSite-QuienesSomos" >Trabajamos para que otros puedan trabajar.</h1>
<div class="col_2 col MobileSobreFundacion">
public function zdjecieusunAction()
{
$oRequest = $this->getRequest();
if (!$oRequest->getParam('gal_id') || !$oRequest->getParam('pro_id')) {
$this->_redirect('admin/produkty');
}
$oGaleria = new Galeria();
$oZdjecie = $oGaleria->fetchRow("gal_id={$oRequest->getParam('gal_id')}");
if (is_object($oZdjecie)) {
$oConfig = new Zend_Config_Ini(APPLICATION_PATH . '/configs/wizytowki.ini', 'wizytowki');
$sWizytowkiKatalog = $oConfig->wizytowki->katalog;
unlink($sWizytowkiKatalog . $oZdjecie->gal_plik);
$oZdjecie->delete();
}
$this->_redirect('admin/galeria?pro_id=' . $oRequest->getParam('pro_id'));
}
public function index()
{
$galeria = Galeria::all();
$testigos = Testigo::all();
return View::make('front.index')->with(compact('galeria', 'testigos'));
}
public function galeria()
{
return Galeria::where('item_id', $this->id)->first();
}
<?php
Event::listen('eliminarArchivo', function ($path) {
if (File::exists($path)) {
return File::delete($path);
} else {
return false;
}
});
Event::listen('auth.login', function ($user) {
$user->last_login = Carbon::now();
$user->save();
Session::flash('status', 'blue lighten-1');
});
Event::listen('register.image', function ($path, $nombre, $album) {
Galeria::create(array('path' => $path, 'nombre' => $nombre, 'album' => $album, 'persona_id' => Auth::user()->id));
});
public function actionAutocompletesearch()
{
$q = "%" . $_GET['term'] . "%";
$result = array();
if (!empty($q)) {
$criteria = new CDbCriteria();
$criteria->select = array('id', "CONCAT_WS(' ',nombre) as nombre");
$criteria->condition = "lower(CONCAT_WS(' ',nombre)) like lower(:nombre) ";
$criteria->params = array(':nombre' => $q);
$criteria->limit = '10';
$cursor = Galeria::model()->findAll($criteria);
foreach ($cursor as $valor) {
$result[] = array('label' => $valor->nombre, 'value' => $valor->nombre, 'id' => $valor->id);
}
}
echo json_encode($result);
Yii::app()->end();
}
<div class="alert alert-info">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4>Instrucciones</h4>
Los campos con <span class="required">*</span> son requeridos.
</div>
<?php
echo $form->errorSummary($model);
?>
<div class="form-group">
<?php
echo $form->labelEx($model, 'galeria_did', array('class' => 'control-label col-lg-2'));
?>
<div class="col-lg-3">
<?php
echo $form->dropDownList($model, 'galeria_did', CHtml::listData(Galeria::model()->findAll(), "id", "nombre"), array("class" => "form-control"));
?>
<?php
echo $form->error($model, 'galeria_did');
?>
</div>
</div>
<div class="form-group">
<?php
echo $form->labelEx($model, 'ruta', array('class' => 'control-label col-lg-2'));
?>
<div class="col-lg-3">
<?php
echo $form->textField($model, 'ruta', array('size' => 60, 'maxlength' => 100, 'class' => 'form-control'));
?>
<?php
public function selectMaisVistos()
{
$sql = "SELECT * ";
$sql .= "FROM galeria glr ";
$sql .= "JOIN categorias_galeria ctg ON ctg.ctg_id = glr.glr_categoria ";
$sql .= "ORDER BY glr.glr_visualizacoes DESC ";
$sql .= "LIMIT 0 , 3";
$result = $this->retrieve($sql);
$lista = array();
while ($qr = mysqli_fetch_array($result)) {
$glr = new Galeria();
$glr->setGlr_idgaleria($qr["glr_idgaleria"]);
$glr->setGlr_nome($qr["glr_nome"]);
$glr->setGlr_arquivo($qr["glr_arquivo"]);
$glr->setGlr_descricao($qr["glr_descricao"]);
$glr->setGlr_data($qr["glr_data"]);
$glr->setGlr_categoria(new CategoriaGaleria());
$glr->getGlr_categoria()->setCtg_id($qr["ctg_id"]);
$glr->getGlr_categoria()->setCtg_categoria($qr["ctg_categoria"]);
$glr->getGlr_categoria()->setCtg_classe($qr["ctg_classe"]);
$glr->setGlr_visualizacoes($qr["glr_visualizacoes"]);
array_push($lista, $glr);
}
return $lista;
}
<?php
$albums = Galeria::distinct()->lists('album');
?>
@extends('layout')
@section ("contenido")
<div class=" container row">
<h4 class="center-align">Subir Imagen</h4>
<p>Eliga un archivo imagen para mostrarla en la galeria</p>
<p class="red-text"> Tenga cuidado con lo que suba, sera visible para todos los usuarios</p>
{{ Form::open(['method' => 'POST','files' => true , 'class' => '']) }}
<div class="file-field input-field">
<div class="btn">
<span>Imagen</span>
<input type="file" name="file" accept="image/*">
</div>
<div class="file-path-wrapper">
<input class="file-path validate" type="text">
</div>
</div>
<div class="input-field">
<input name="nombre" id="nombre" type="text" required="required" maxlength="30" length="30" class="validate">
<label for="nombre">Nombre de la Imagen</label>
</div>
<?php
importar("Utilidades.Galerias.Lista.ListaGalerias");
$tituloPagina = 'Utilidades > Galerias > Cadastrar';
$iTG = new IFAdmin(new Arquivos(Sistema::$adminLayoutCaminhoDiretorio . "/SistemaUtilidades/galeria.html"));
$lI = new ListaIdiomas();
if (!empty($_POST)) {
$erro = '';
if (empty($_POST['titulo'])) {
$erro = "<b>Titulo</b> não preenchido!<br><br>";
}
if (empty($erro)) {
try {
$g = new Galeria();
$g->titulo = $_POST['titulo'];
$g->local = $_POST['local'];
$g->tipo = $_POST['tipo'];
$g->setData(new DataHora($_POST['data']));
$g->setVideo($_POST['video']);
$g->descricao = $_POST['descricao'];
$g->ordem = $_POST['ordem'];
$lG = new ListaGalerias();
$lG->inserir($g);
$g->getURL()->setURL($_POST['url'] ? $_POST['url'] : $g->getId() . "-" . URL::cleanURL($_POST['titulo']));
$lG->alterar($g);
while ($i = $lI->listar()) {
$t = new Traducao();
$t->setIdConteudo($g->getId());
$t->setCampoConteudo(ListaGalerias::TITULO);
$t->setTabelaConteudo($lG->getTabela());
$t->conteudo = $g->titulo;
/**
* Add or edit if exists, given galeria object.
* @param Galeria $galeria
*/
public static function AddEditGaleria(Galeria $galeria)
{
if ($galeria != null) {
self::DeleteGaleria($galeria->GetGID(), $galeria->GetIdJezyk());
self::AddGaleria($galeria);
}
}
public function actionSubir($id)
{
$galeria = Galeria::model()->find('id = ' . $id);
$model = new XUploadForm();
$this->render('subir', array('galeria' => $galeria, 'model' => $model));
}
<div class="galeria-box-pesquisa" >
<input type="text" value="" id="campo-pesquisa-img" name="campo-pesquisa-img" placeholder="Pesquisar"/>
<div style="float:right; position:relative;">
<a href="javascript:diminuir_img();">-</a>
<a href="javascript:aumentar_img();">+</a>
</div>
</div>
<a class="borda" href="javascript:subir_diretorio();">Voltar</a>
<div id="corpo">
<input type="hidden" id="diretorio_atual" value="<?php
echo Galeria::getDirAtual();
?>
"/>
<span id="caminho-atual">Você esta em: <?php
echo Galeria::getDirAtual();
?>
<br></span>
<?php
echo ' <ul class="galeria">';
foreach ($pastas as $i => $a) {
// barra normal precisa de 4 pq ao entrar NESTA string vira duas,
// e ao entrar na string do browser durante compílacao vira uma.
echo "<li>\n <a href=\"javascript:entrar_na_pasta('" . str_replace('\\', '\\\\', $a) . '\\\\' . "');\" data-source='#' title='teste'\n style='width:193px;height:125px;'>\n <img class='img-galeria' src='" . ROOT_URL . "view/img/pastinha.png' width='200' height='150' />\n <span><br>" . basename($a) . "</span>\n </a>\n </li>";
}
foreach ($arquivos as $i => $a) {
echo ' <li>
<a href="javascript:enviar_imagem_ao_pai(\'' . str_replace('view/img/atividades/', '', $a['path'] . $a['file']) . '\');" data-source="#" title="teste"
style="width:193px;height:125px;">
<img class="img-galeria" src="' . ROOT_URL . $a['path'] . $a['file'] . '" width="200" height="150" />
</a><span><br>' . $a["file"] . '</span>
break;
case "listaCategoriasGaleria":
$categoriaGaleria = $categoriaGaleriaController->selectAll();
$lista = array();
foreach ($categoriaGaleria as $key => $value) {
$result = array('id' => utf8_encode($categoriaGaleria[$key]->getCtg_id()), 'categoria' => utf8_encode($categoriaGaleria[$key]->getCtg_categoria()), 'classe' => utf8_encode($categoriaGaleria[$key]->getCtg_classe()));
array_push($lista, $result);
}
print_r(json_encode($lista));
break;
case 'uploadGaleria':
$categoria = $_REQUEST['cat_arquivo'];
$titulo = $_REQUEST['titulo_arquivo'];
$descricao = $_REQUEST['descricao_arquivo'];
$data = date('Y-m-d h:i', time());
$galeria = new Galeria();
$galeria->setGlr_categoria($categoria);
$galeria->setGlr_nome(utf8_decode($titulo));
$galeria->setGlr_descricao(utf8_decode($descricao));
$galeria->setGlr_data($data);
if ($_REQUEST['tipo_arquivo'] == 0) {
$arquivo = $_REQUEST['link_arquivo'];
} else {
$nomeImage = "_" . md5(uniqid(rand(), true)) . '.' . pathinfo($_FILES['file_arquivo']['name'], PATHINFO_EXTENSION);
$arquivo_temporario = $_FILES["file_arquivo"]["tmp_name"];
$local = $path['arquivos_galeria'];
if (filesize($arquivo_temporario) > $maxSize) {
$_SESSION['cadastro'] = "excedeu";
} else {
move_uploaded_file($arquivo_temporario, $local . $nomeImage);
$arquivo = $local . $nomeImage;
<?php
echo $form->textField($model, 'id');
?>
</div>
</div>
<div class="clearfix">
<?php
echo $form->label($model, 'galeria_did');
?>
<div class="input">
<?php
echo $form->dropDownList($model, "galeria_did", CHtml::listData(Galeria::model()->findAll(), 'id', 'nombre'));
?>
</div>
</div>
<div class="clearfix">
<?php
echo $form->label($model, 'ruta');
?>
<div class="input">
<?php
echo $form->textField($model, 'ruta', array('size' => 60, 'maxlength' => 100, 'class' => 'form-control'));
?>
</div>
public function setTotal($param)
{
self::$total = $param;
}
echo "<li>\n <a href=\"javascript:entrar_na_pasta('" . str_replace('\\', '\\\\', $a) . "');\" data-source='#' title='teste'\n style='width:193px;height:125px;'>\n <img class='img-galeria' src='" . ROOT_URL . "view/img/pastinha.png' width='200' height='150' />\n <span><br>" . basename($a) . "</span>\n </a>\n </li>";
}
}
//arquivos
$arquivos = Galeria::lista_arquivos($pasta);
foreach ($arquivos as $i => $a) {
echo ' <li>
<a href="javascript:enviar_imagem_ao_pai(\'' . ROOT_URL . $a['path'] . $a['file'] . '\');" data-source="#" title="teste"
style="width:193px;height:125px;">
<img class="img-galeria" src="' . ROOT_URL . $a['path'] . $a['file'] . '" width="200" height="150" />
</a><span><br>' . $a["file"] . '</span>
</li>';
}
echo '</ul>';
}
if ($filtro != -1 && $filtro != '') {
$arquivos = Galeria::busca_arquivos_recursivo($filtro, $pasta);
echo ' <input type="hidden" id="diretorio_atual" value="' . Galeria::getDirAtual() . '"/>';
echo ' <span id="caminho-atual">Você esta em: ' . Galeria::getDirAtual() . '<br></span>';
echo '<div id="total"> Total Encontrado: ' . Galeria::getTotal() . '</div> ';
echo ' <ul class="galeria">';
foreach ($arquivos as $i => $c) {
echo ' <li>
<a href="javascript:enviar_imagem_ao_pai(\'' . str_replace('\\', '/', ROOT_URL . $c['path']) . '\');" data-source="#" title="teste"
style="width:193px;height:125px;">
<img class="img-galeria" src="' . ROOT_URL . $c['path'] . '" width="200" height="150" />
</a><span><br>' . $c["file"] . '</span>
</li>';
}
echo '</ul>';
}
} else {
$sql = "\n\n SELECT id, galeria_id, imagen, null as video, null as poster, null as audio, titulo, 'imagen' as tipo, descripcion, created_at FROM imagenes WHERE galeria_id = {$id} \n UNION \n SELECT id, galeria_id, null as imagen, video, poster, null as audio, titulo, 'video' as tipo, descripcion, created_at FROM videos WHERE galeria_id = {$id} \n UNION \n SELECT id, galeria_id, null as imagen, null as video, null as poster, audio, titulo, 'audio' as tipo, descripcion, created_at FROM audios WHERE galeria_id = {$id} ORDER BY created_at desc";
}
$items = DB::select($sql);
$subgalerias = "SELECT * FROM subcategorias WHERE galeria_id = " . $id;
$subgalerias = DB::select($subgalerias);
$menu = Galeria::where('menu', '=', 'Si')->orderBy('order')->get();
return View::make('serie', array('cita' => $cita, 'imagenes' => $items, 'galeria' => $galeria, 'menu' => $menu, 'subgalerias' => $subgalerias));
});
Route::get('/sub/{id}', function ($id) {
$cita = Cita::orderBy('created_at', 'desc')->first();
$subGaleria = SubGaleria::find($id);
$sql = "\n\n SELECT id, galeria_id, imagen, null as video, null as poster, null as audio, titulo, 'imagen' as tipo, created_at FROM imagenes WHERE subcategoria_id = {$id} \n UNION \n SELECT id, galeria_id, null as imagen, video, poster, null as audio, titulo, 'video' as tipo, created_at FROM videos WHERE subcategoria_id = {$id} \n UNION \n SELECT id, galeria_id, null as imagen, null as video, null as poster, audio, titulo, 'audio' as tipo, created_at FROM audios WHERE subcategoria_id = {$id} ORDER BY created_at desc";
$items = DB::select($sql);
$galeria = Galeria::find($subGaleria->galeria_id);
$menu = Galeria::where('menu', '=', 'Si')->orderBy('order')->get();
return View::make('serie', array('cita' => $cita, 'imagenes' => $items, 'galeria' => $galeria, 'subGaleria' => $subGaleria, 'menu' => $menu));
});
Route::get('user/login', function () {
return View::make('login');
});
Route::get('user/logout', function () {
Sentry::logout();
return View::make('login');
});
Route::post('user/login', function () {
// Set login credentials
$credentials = array('email' => Input::get('email'), 'password' => Input::get('password'));
$remember = Input::get('remember') ? true : false;
// Try to authenticate the user
$user = Sentry::authenticate($credentials, $remember);
public static function buscar($item_id)
{
return Galeria::where('item_id', $item_id)->first();
}
