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'); } } }