public function index()
{
$user_id = Auth::user()->id;
$breadcrumbs = Data_users::where('user_id', '=', $user_id)->first();
$breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name;
$colonies_inactive = Expiration::where('status', '=', 1)->get();
$admin_colonies = AssigmentRoleHab::where('role_id', '=', 2)->get();
return View::make('dashboard.colonies.inactive', ['nombre' => $breadcrumbs_data, 'colonies' => $colonies_inactive, 'admin' => $admin_colonies]);
}
public function confirm($code)
{
$confirm = InvitedNeighbors::where('Confirmation_code', '=', $code)->first();
if (!$confirm->confirmed) {
//$confirm->confirmed = true;
//$confirm->update(['id']);
$email = $confirm->email;
$urbanism_id = $confirm->urbanism_id;
$colony = Urbanism::where('id', '=', $urbanism_id)->pluck('colony_id');
$expiration = Expiration::where('colony_id', '=', $colony)->first();
$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);
$usuario = UserNeighbors::where('email', '=', $email)->first();
if ($usuario) {
$rol_vecino = AssigmentRole::where('colony_id', '=', $colony)->where('user_id', '=', $usuario->id)->where('role_id', '=', 6)->first();
if ($rol_vecino) {
$notice_msg = 'Ya se encuentra como vecino en la Colonia, acceda ahora a Habitaria';
return Redirect::action('UsersController@login')->with('notice', $notice_msg);
} else {
$neighbor = Neighbors::where('user_id', '=', $usuario->id)->first();
if ($neighbor) {
$neighborP = NeighborProperty::where('neighbors_id', '=', $neighbor->id)->where('urbanism_id', '=', $urbanism_id)->first();
if (!$neighborP) {
return Redirect::action('NeighborController@register_properties', array('neighbor' => $neighbor->id, 'urbanism_id' => $urbanism_id));
}
} else {
return Redirect::action('NeighborController@register_neighbors', array('user' => $usuario->id, 'urbanism_id' => $urbanism_id));
}
}
} else {
$urbanism = Urbanism::findOrFail($urbanism_id);
$urbanism_name = $urbanism->name;
$urbanism_type = $urbanism->urbanism_type_id;
if ($urbanism_type == 3) {
$catalog = BuildingCatalog::where('urbanism_id', '=', $urbanism_id)->orderBy('id', 'ASC')->lists('description', 'id');
$select = '¿Piso donde vive?';
$select_name = 'name_floor';
} else {
$catalog = StreetCatalog::where('urbanism_id', '=', $urbanism_id)->orderBy('id', 'ASC')->lists('name', 'id');
$select = '¿Calle donde vive?';
$select_name = 'name_street';
}
$notice_msg = Lang::get('confide::confide.alerts.confirmation_invitation');
return View::make('dashboard.neighbors.create', ['email' => $email, 'urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'code' => $code, 'select_name' => $select_name, 'select' => ['' => $select], 'notice' => $notice_msg]);
}
} else {
$notice_msg = 'Acceda a Habitaria con su usuario creado';
return Redirect::action('UsersController@login')->with('notice', $notice_msg);
}
}
public static function boot()
{
parent::boot();
static::creating(function ($expiration) {
do {
$token = sha1(uniqid() . time());
$count = Expiration::where('token', $token)->count();
} while ($count != 0);
$expiration->token = $token;
$minutes = intval(Setting::key('link_duration')->first()->value) > 0 ? intval(Setting::key('link_duration')->first()->value) : 60;
$expiration->expiration = Carbon::now()->addMinutes($minutes);
});
}
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 download($token)
{
$e = Expiration::where('token', $token)->first();
if ($e) {
$expirationDate = Carbon::parse($e->expiration);
$now = Carbon::now();
if ($expirationDate->lte($now)) {
return Response::download(public_path() . '/uploads/plugins/' . Setting::key('plugin_zip')->first()->value);
} else {
echo "Su enlace ha expirado, consulte con el administraor del sistema";
}
} else {
App::abort(403, 'Unauthorized action.');
}
}
public function promo_store()
{
$data = Input::all();
$colonia = Input::get('colony_id');
$code = Input::get('code');
$promo_colonia = Promo::where('colony_id', '=', $colonia)->get();
$code_exist = 0;
foreach ($promo_colonia as $promo) {
if ($code == Crypt::decrypt($promo->code)) {
$code_exist = 1;
$code_id = $promo->id;
$promo_status = $promo->status;
}
}
if ($code_exist == 1) {
if ($promo_status == 0) {
$promo = Promo::where('id', '=', $code_id)->first();
$promo->status = 1;
if ($promo->update(['id'])) {
$expiration = Expiration::where('colony_id', '=', $colonia)->first();
$expiration_old = date('Y-m-j', strtotime($expiration->expiration));
$newExpiration = strtotime('+' . $promo->days . ' day', strtotime($expiration_old));
$newExpiration = date('Y-m-j', $newExpiration);
$expiration->expiration = $newExpiration;
$expiration->update(['id']);
$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);
$notice_msg = 'Código de la promo activado';
return Redirect::route('home')->with('notice_modal', $notice_msg);
}
} else {
$error_msg = 'Este Código de la promo ya se fue utilizado';
return Redirect::back()->with('error_modal', $error_msg);
}
} else {
$error_msg = 'Código de la promo 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');
}
}
}
