public function sort($id, $sort)
{
if (!in_array($sort, array('up', 'down'))) {
return redirect_message(array('admin', $this->get_class()), array('_flash_message' => '排序失敗！'));
}
$total = Banner::count();
switch ($sort) {
case 'up':
$sort = $this->banner->sort;
$this->banner->sort = $this->banner->sort + 1 >= $total ? 0 : $this->banner->sort + 1;
break;
case 'down':
$sort = $this->banner->sort;
$this->banner->sort = $this->banner->sort - 1 < 0 ? $total - 1 : $this->banner->sort - 1;
break;
}
Banner::addConditions($conditions, 'sort = ?', $this->banner->sort);
$banner = $this->banner;
$update = Banner::transaction(function () use($conditions, $banner, $sort) {
if (($next = Banner::find('one', array('conditions' => $conditions))) && (($next->sort = $sort) || true)) {
if (!$next->save()) {
return false;
}
}
if (!$banner->save()) {
return false;
}
return true;
});
if (!$update) {
return redirect_message(array('admin', $this->get_class()), array('_flash_message' => '排序失敗！', 'posts' => $posts));
}
return redirect_message(array('admin', $this->get_class()), array('_flash_message' => '排序成功！'));
}
public function Edit()
{
$input = Input::all();
$banner_id = $input['id'];
$banner = Banner::find($banner_id);
return View::make('admin.banner.add')->with('banner', $banner);
}
/**
* Administration view for banner
*/
function click_action($id)
{
$banner = Banner::find($id);
$banner->clicks += 1;
$banner->store();
$this->redirect($banner->getLink());
}
public function delete($id)
{
$banner = Banner::find($id);
$banner->delete();
Session::flash('success', 'Banner deleted');
return Redirect::to('admin/banners');
}
public function createModel()
{
$model = new Banner();
$criteria = new CDbCriteria();
$criteria->select = new CDbExpression('MAX(sort) as sort');
$max = $model->find($criteria);
$model->sort = $max->sort + 10;
return $model;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function imprimir($posicion)
{
$banner = DB::table('banners')->where('posicion', '=', $posicion)->orderBy('visitas', 'asc')->first();
$id = $banner->id;
$banner = Banner::find($id);
$banner->visitas++;
$banner->save();
$url = '/publicidades/' . $banner->file;
$devolver = array($url, $banner->link);
return $devolver;
}
/**
* Store a newly created resource in storage.
*
* @param MenuRequest $request
* @return \Illuminate\Http\Response
*/
public function store(MenuRequest $request)
{
// content input
$menu['title'] = \Input::get('title');
$menu['eng_title'] = \Input::get('eng_title');
$menu['subtitle'] = \Input::get('subtitle');
$menu['eng_subtitle'] = \Input::get('eng_subtitle');
$menu['slug'] = '/' . \trslug::trslug($menu['title']);
$menu['eng_slug'] = '/eng/' . \trslug::trslug($menu['eng_title']);
$menu['header'] = \Input::get('header');
$menu['active'] = \Input::get('active') === "1";
$menu['body'] = \Input::get('body');
$menu['eng_body'] = \Input::get('eng_body');
$menu['line'] = 999;
$menu = Menu::create($menu);
$this->rebuild();
// content polymorphic relations
//banner relations
if (\Input::get('banner')) {
foreach (\Input::get('banner') as $banner) {
Banner::find($banner)->menus()->save($menu);
}
}
//gallery relations
if (\Input::get('gallery')) {
foreach (\Input::get('gallery') as $gallery) {
Gallery::find($gallery)->menus()->save($menu);
}
}
//linkTitles relations
if (\Input::get('linkTitle')) {
foreach (\Input::get('linkTitle') as $linkTitle) {
LinkTitle::find($linkTitle)->menus()->save($menu);
}
}
return \Redirect::back()->with('message', 'Kaydedildi');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
//
$validation = Validate::BannerValidation(Input::all());
if ($validation->fails()) {
return Redirect::to('banner/create')->withErrors($validation)->withInput();
} else {
$banner = Banner::find($id);
if ($banner->image != "") {
unlink($banner->image);
}
$banner->title = Input::get('title');
$destinationPath = 'img/banners/' . $banner->id . "/";
$filename = $banner->id . "." . Input::file('image')->getClientOriginalExtension();
Input::file('image')->move($destinationPath, $filename);
$banner->image = $destinationPath . $filename;
$banner->save();
return Redirect::to('admin/banner');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$input = Input::all();
$banner = Banner::find($id)->delete();
return Redirect::to('/banners');
}
public static function getBanner($id)
{
$ban = \Banner::find($id);
['img_src' => $ban->img->url('medium'), 'url' => $ban->url];
}
public function aceptarcobro()
{
$cobropid = Input::get('pagodpid');
$cobrop = CobroPendiente::find($cobropid);
$cobrot = $cobrop->cobro->tipo;
$cobro = $cobrop->cobro;
$usuario = $cobrop->cobro->usuario;
$date_now = new DateTime();
//Copiar datos a un nuevo row de CobroHistorial
$cobroH = new CobroHistorial();
$cobroH->cobro_id = $cobrop->cobro_id;
$cobroH->fechaPago = $date_now;
//Mejorar: Aqui mas bien seria la fecha en la que se registro el pago
$cobroH->metodoPago = $cobrop->metodoPago;
$cobroH->referenciaPago = $cobrop->referenciaPago;
$cobroH->cobro_concepto = $cobrop->cobro_concepto;
$cobroH->cobro_tipo = $cobrot->tipo;
$cobroH->usuario_email = $usuario->email;
$cobroH->cobro_datosAdicionales = $cobro->datosAdicionales;
$cobroH->save();
//Actualizar Cobro
//=> Si es el primer cobro (fechaExpiracion ==null y estado=='pendiente'
if ($cobro->fechaExpiracion == null) {
$expdatetime = $date_now->add(new DateInterval('P' . $cobrot->diasVigencia . 'D'));
$cobro->fechaExpiracion = $expdatetime;
} else {
//Si es un cobro para extender el servicio premium
$fechaEDT = new DateTime($cobro->fechaExpiracion);
if ($fechaEDT < $date_now) {
//si servicio ya estaba expirado
$expdatetime = $date_now->add(new DateInterval('P' . $cobrot->diasVigencia . 'D'));
//Agregar los dias a partir de la fecha actual
} else {
//si servicio todavia no expira
$expdatetime = $fechaEDT->add(new DateInterval('P' . $cobrot->diasVigencia . 'D'));
//Agregar los dias a la fecha de expiracion actual
}
$cobro->fechaExpiracion = $expdatetime;
}
$cobro->estado = 'pagado';
//TODO: Falta ver seria un estado diferente cuando se paga por primera vez o las demas veces
$cobro->save();
//Borrar row de cobroPendiente
$cobrop->delete();
//Aqui ya depende del tipo de cobro
if ($cobrot->tipo == 'ser_proveedor') {
//regresar campo 'solicitar_premium' de 1 a 0 y poner habilitar a 1
$prov = Proveedor::find($cobro->datosAdicionales);
$prov->solicitar_premium = 0;
$prov->habilitar = 1;
$prov->no_primer_cobro = 1;
$prov->save();
}
if ($cobrot->tipo == 'clasificado_premium') {
//regresar campo 'solicitar_premium' de 1 a 0 y poner campo premium a 1
$clas = Clasificado::find($cobro->datosAdicionales);
$clas->solicitar_premium = 0;
$clas->premium = 1;
$clas->no_primer_cobro = 1;
$clas->save();
}
if ($cobrot->tipo == 'imagen_proveedor') {
//poner campo 'premium' 1 a 2
$provimg = ProveedorGaleria::find($cobro->datosAdicionales);
$provimg->premium = 2;
$provimg->no_primer_cobro = 1;
$provimg->save();
}
$cobrotipoprefix = substr($cobrot->tipo, 0, 7);
if ($cobrotipoprefix == 'BANNER-') {
//poner solicitar_habilitar a 0 y habilitar a 1
$banner = Banner::find($cobro->datosAdicionales);
$banner->solicitar_habilitar = 0;
$banner->habilitar = 1;
$banner->no_primer_cobro = 1;
$banner->save();
}
return Redirect::to('/administracion/pagospendientes');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$banner = Banner::find($id);
if ($banner->foto) {
$fotolama = $banner->foto;
$filepath = public_path() . DIRECTORY_SEPARATOR . 'uploads/banner' . DIRECTORY_SEPARATOR . $banner->foto;
try {
File::delete($filepath);
} catch (FileNotFoundException $e) {
}
}
$banner->delete();
return Redirect::to('admin/banner')->with('pesan', "<hr><div class='alert alert-info'>Data Berhasil dihapus</div>");
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$authuser = Auth::user();
$banner = Banner::find($id);
//return $clasificado;
$img = $banner->imagen;
File::delete('images/banners/' . $img);
//TODO: Borrar cobro asociado
$banner->delete();
// redirect
Session::flash('message', 'El banner ha sido eliminado exitosamente!');
return Redirect::to('vistausuario/banners')->with(array('usuarioimg' => $authuser->imagen, 'usuarionombre' => $authuser->nombre, 'usuarioid' => $authuser->id));
}
/**
* Show the form for editing the specified resource.
* GET /banners/{id}/edit
*
* @param int $id
* @return Response
*/
public function edit($id = NULL)
{
parent::show();
$banner = Banner::find($id);
$path = $this->banner_path;
return View::make('banners.edit', compact('banner', 'path'));
}
/**
*
* @param type $banner_id
*/
public function delete_action($banner_id)
{
if (Request::int('delete') == 1) {
Banner::find($banner_id)->delete();
PageLayout::postMessage(MessageBox::success(_('Das Banner wurde erfolgreich gelöscht!')));
} elseif (!Request::get('back')) {
$this->flash['delete'] = compact('banner_id');
}
$this->redirect('admin/banner');
}
public function getBannerRight()
{
$bannerRight = Banner::find(array("bn_position = 5 AND bn_status=1 ", "order" => "bn_created_date DESC", "limit" => 2));
if (!empty($bannerRight)) {
return $bannerRight->toArray();
}
return array();
}
