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 config_store() { $user_id = Auth::user()->id; $num_street_id = NULL; $num_floor_id = NULL; $data = Input::all(); $name_floor = Input::get('name_floor'); $name_street = Input::get('name_street'); //~====================SAVE STEP 1=============================== $colony = new Colony(); $colony->location_id = Input::get('city'); $colony->name = Input::get('colony_name'); if ($colony->save()) { $created_colony = date('Y-m-j', strtotime($colony->created_at)); $newExpiration = strtotime('+1 month', strtotime($created_colony)); $newExpiration = date('Y-m-j', $newExpiration); $expiration = new Expiration(); $expiration->colony_id = $colony->id; $expiration->expiration = $newExpiration; $expiration->status = 1; $expiration->save(); $expiration_lic = new LicenseExpiration(); $expiration_lic->colony_id = $colony->id; $expiration_lic->expiration = null; $expiration_lic->save(); $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); $role = AssigmentRole::where('user_id', '=', $user_id)->where('role_id', '=', 2)->where('colony_id', '=', 0)->first(); if ($role) { $rol = AssigmentRole::findOrFail($role->id); $rol->colony_id = $colony->id; $rol->update(['id']); } else { $rol = new AssigmentRole(); $rol->user_id = $user_id; $rol->role_id = 2; $rol->colony_id = $colony->id; $rol->save(); } } $last_colony_add = $colony->id; $urbanism = new Urbanism(); $urbanism->colony_id = $last_colony_add; $urbanism->urbanism_type_id = Input::get('urbanism_type'); //$urbanism->name = Input::get('urbanism_name'); $urbanism->save(); $last_urbanism_add = $urbanism->id; $user_id = Auth::user()->id; $neighbor = Neighbors::where('user_id', '=', $user_id)->pluck('id'); if (!$neighbor) { $admin_colonies = new Neighbors(); $admin_colonies->user_id = $user_id; $admin_colonies->name = Input::get('admin_name'); $admin_colonies->last_name = Input::get('admin_lname'); $admin_colonies->phone = Input::get('admin_phone'); $admin_colonies->save(); $last_adminColonies_add = $admin_colonies->id; } if ($neighbor) { $last_adminColonies_add = $neighbor; } $streets = $data['streets']; if ($urbanism->urbanism_type_id == 3) { foreach ($streets as $Building_name) { $Building = new BuildingCatalog(); $Building->urbanism_id = $last_urbanism_add; $Building->description = $Building_name; $Building->save(); if ($Building_name == $name_floor) { $num_floor_id = $Building->id; } } } else { foreach ($streets as $street_name) { $street = new StreetCatalog(); $street->urbanism_id = $last_urbanism_add; $street->name = $street_name; $street->save(); if ($street_name == $name_street) { $num_street_id = $street->id; } } } $neighbor_properties = new NeighborProperty(); $neighbor_properties->neighbors_id = $last_adminColonies_add; $neighbor_properties->urbanism_id = $last_urbanism_add; $neighbor_properties->num_street_id = $num_street_id; $neighbor_properties->num_floor_id = $num_floor_id; $neighbor_properties->num_house_or_apartment = Input::get('num_house_or_apartment'); $neighbor_properties->status = 1; $neighbor_properties->save(); //~====================SAVE STEP 2=============================== $monthly_fee = new MonthlyFee(); $monthly_fee->urbanism_id = $last_urbanism_add; $monthly_fee->amount = Input::get('monthly_fee'); $monthly_fee->since = date("Y-m") . "-01"; $monthly_fee->until = NULL; $monthly_fee->save(); //~====================SAVE STEP 3=============================== //~====================sub cuentas egreso e ingreso por defecto =============================== $subAccounts_ingreso = new SubAccount(); $subAccounts_ingreso->account_id = 1; $subAccounts_ingreso->urbanism_id = $urbanism->id; $subAccounts_ingreso->description = 'Pago de cuota mensual'; $subAccounts_ingreso->save(); $subAccount_egreso = new SubAccount(); $subAccount_egreso->account_id = 2; $subAccount_egreso->urbanism_id = $urbanism->id; $subAccount_egreso->description = 'Nómina de guardias'; $subAccount_egreso->save(); $cobrador = Collector::where('user_id', '=', $user_id)->where('urbanism_id', '=', $urbanism->id)->pluck('id'); if (!$cobrador) { $collector = new Collector(); $collector->user_id = $user_id; $collector->urbanism_id = $urbanism->id; $collector->save(); } $campoEmail = Input::get('email'); if ($campoEmail) { $invited_neighbors = $data['mails']; $invited_id = md5(uniqid(mt_rand(), true)); foreach ($invited_neighbors as $neighbor_email) { $encrypted = Crypt::encrypt(md5(uniqid(mt_rand(), true))); $invited = new InvitedNeighbors(); $invited->neighbor_id = $last_adminColonies_add; $invited->invited_id = $invited_id; $invited->urbanism_id = $last_urbanism_add; $invited->email = $neighbor_email; $invited->confirmed = false; $invited->confirmation_code = $encrypted; $invited->save(); } return Redirect::action('HomeController@sendMailInvitation', array('invited_id' => $invited_id, 'admin_colonia' => $last_adminColonies_add, 'urbanismo' => $last_urbanism_add)); } else { return Redirect::action('NeighborController@admin_neighbor', array('admin_colonia' => $last_adminColonies_add, 'urbanismo' => $last_urbanism_add)); } }
</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>