public function index_lic()
{
$user_id = Auth::user()->id;
$breadcrumbs = Data_users::where('user_id', '=', $user_id)->first();
$breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name;
$colonies_active = LicenseExpiration::where('expiration', '!=', '0000-00-00')->get();
$admin_colonies = AssigmentRoleHab::where('role_id', '=', 2)->get();
return View::make('dashboard.colonies.active', ['nombre' => $breadcrumbs_data, 'colonies' => $colonies_active, 'admin' => $admin_colonies]);
}
public function profile()
{
$neighbor_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanismUsers = Urbanism::where('colony_id', '=', $colonia)->first();
$neighbor = Neighbors::with('NeighborProperty')->where('user_id', '=', $neighbor_id)->first();
$role = AssigmentRole::where('user_id', '=', $neighbor_id)->where('colony_id', '=', $colonia)->first();
$neighbor_role = ucfirst($role->Role->name);
$licencia = License::where('colony_id', '=', $colonia)->first();
$expiration_license = LicenseExpiration::where('colony_id', '=', $colonia)->first();
$photo_user = UserPhoto::where('user_id', '=', $neighbor_id)->where('colony_id', '=', $colonia)->pluck('filename');
return View::make('dashboard.neighbors.profile', ['neighbor' => $neighbor, 'colonia_nombre' => $urbanismUsers->Colony->name, 'urbanism' => $urbanismUsers->Colony->name, 'role' => $neighbor_role, 'licencia' => $licencia, 'photo_user' => $photo_user, 'expiration_license' => $expiration_license]);
}
public function license_store()
{
$data = Input::all();
$colonia = Input::get('colony_id');
$code = Input::get('code');
$license_colonia = License::where('colony_id', '=', $colonia)->get();
$code_exist = 0;
foreach ($license_colonia as $lic) {
if ($code == Crypt::decrypt($lic->code)) {
$code_exist = 1;
$code_id = $lic->id;
$lic_status = $lic->status;
}
}
if ($code_exist == 1) {
if ($lic_status == 0) {
$license = License::where('id', '=', $code_id)->first();
$license->status = 1;
if ($license->update(['id'])) {
$expiration = Expiration::where('colony_id', '=', $colonia)->first();
$expiration->status = 2;
$expiration->update(['id']);
Session::put('days_expiration', 0);
$expiration_lic = LicenseExpiration::where('colony_id', '=', $colonia)->first();
if ($expiration_lic->expiration == null) {
$expiration_old = date('Y-m-j');
} else {
$expiration_old = date('Y-m-j', strtotime($expiration_lic->expiration));
}
$newExpiration = strtotime('+' . $license->months . ' month', strtotime($expiration_old));
$newExpiration = date('Y-m-j', $newExpiration);
$expiration_lic->expiration = $newExpiration;
$expiration_lic->update(['id']);
$datetime2 = new DateTime($expiration_lic->expiration);
$datetime1 = new DateTime(date('Y-m-d'));
$interval = $datetime1->diff($datetime2);
$days_expiration = $interval->format('%a');
Session::put('lic_fecha_expiration', $expiration_lic->expiration);
Session::put('lic_expiration', $days_expiration);
$notice_msg = 'Código de la licencia activado';
return Redirect::route('home')->with('notice_modal', $notice_msg);
}
} else {
$error_msg = 'Este Código de licencia ya se fue utilizado';
return Redirect::back()->with('error_modal', $error_msg);
}
} else {
$error_msg = 'Código de la licencia inválido';
return Redirect::back()->with('error_modal', $error_msg);
}
}
public function colsel()
{
Session::put('colonia', Input::get('colonias'));
$expiration = Expiration::where('colony_id', '=', Input::get('colonias'))->where('status', '=', 1)->first();
Session::put('days_expiration', 0);
Session::put('lic_fecha_expiration', 0);
if ($expiration) {
$datetime2 = new DateTime($expiration->expiration);
$datetime1 = new DateTime(date('Y-m-d'));
$interval = $datetime1->diff($datetime2);
$days_expiration = $interval->format('%a');
Session::put('days_expiration', $days_expiration);
if ($days_expiration <= 0) {
return Redirect::route('active.promo');
} else {
return Redirect::route('home');
}
} else {
$lic_expiration = LicenseExpiration::where('colony_id', '=', Input::get('colonias'))->first();
if ($lic_expiration) {
$datetime2 = new DateTime($lic_expiration->expiration);
$datetime1 = new DateTime(date('Y-m-d'));
$interval = $datetime1->diff($datetime2);
$days_expiration = $interval->format('%a');
Session::put('lic_expiration', $days_expiration);
Session::put('lic_fecha_expiration', $lic_expiration->expiration);
if ($days_expiration <= 0) {
return Redirect::route('active.license');
} else {
return Redirect::route('home');
}
} else {
return Redirect::route('home');
}
}
}
</a>
<!--Navigation Itself-->
<div class="navbar-content">
<!--Sidebar Toggler-->
<a href="#" class="btn btn-default left-toggler" title="Panel"><i class="fa fa-bars"></i></a>
<div class="btn-group" >
<a href="#" class="btn btn-default " title="Sugerencias" id="modalEmail"><i class="entypo-mail"></i><!--<span class="new"></span>--></a>
</div>
<?php
$user_id = Auth::user()->id;
$suggestions = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('mark', '<>', 'read')->orderBy('created_at', 'desc')->get();
$count = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('mark', '<>', 'read')->count();
$expiration_license = LicenseExpiration::where('colony_id', '=', Session::get("colonia"))->first();
?>
<div class="btn-group">
<button type="button" title="Notificaciones" class="btn btn-default dropdown-toggle" data-toggle="dropdown"> <i class="entypo-megaphone"></i>@if($count > 0)<span class="new"></span>@endif</button>
<div id="notification-dropdown" class="dropdown-menu">
<div class="dropdown-header">Notificaciones <span class="badge pull-right">{{ $count }}</span></div>
<div class="dropdown-container">
<div class="nano">
<div class="nano-content">
<ul class="notification-dropdown">
@foreach($suggestions as $suggestion)
<li class="bg-info"><a href="{{ URL::route('config.colony.suggestions.view',$suggestion->id_mensaje) }}"> <span class="notification-icon"><i class="fa fa-bolt"></i></span>
<h4>{{ $suggestion->asunto }}</h4>
<p>{{ $suggestion->contenido }}</p>
<span class="label label-default"></span> </a>
