public static function editar($input)
{
$respuesta = array();
$reglas = array('id' => array('required'));
$validator = Validator::make($input, $reglas);
if ($validator->fails()) {
$respuesta['mensaje'] = $validator;
$respuesta['error'] = true;
} else {
$galeria = Galeria::find($input['id']);
if (isset($input['imagenes_existentes']) && $input['imagenes_existentes'] != "") {
foreach ($input['imagenes_existentes'] as $key => $imagen) {
if ($imagen != "") {
$data_imagen = array('id' => $imagen, 'epigrafe' => $input['epigrafes_existentes'][$key]);
$imagen_creada = Imagen::editar($data_imagen);
}
}
}
$data_item = array('id' => $galeria->item_id, 'titulo' => $input['titulo'], 'descripcion' => $input['descripcion'], 'file' => $input['file'], 'epigrafe' => $input['epigrafe']);
$item = Item::editarItem($data_item);
$respuesta['mensaje'] = 'Galeria modificada.';
$respuesta['error'] = false;
$respuesta['data'] = $item['data'];
}
return $respuesta;
}
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');
}
$sql = "SELECT id, galeria_id, null as imagen, video, poster, null as audio, titulo, 'video' as tipo, descripcion, created_at FROM videos ORDER BY created_at desc";
} 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
