コード例 #1
0
 public function record_index()
 {
     $user_id = Auth::user()->id;
     $AssigmentRole = Auth::user()->AssigmentRole[0]->role_id;
     $colonia = Session::get("colonia");
     $urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
     $urbanismo = $urbanism->id;
     $urb_name = $urbanism->Colony->name;
     $neighbor = Neighbors::where('user_id', '=', $user_id)->pluck('id');
     $property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->where('neighbors_id', '=', $neighbor)->pluck('id');
     $neighbor_payments = Payment::join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.id')->join('neighbors', 'neighbors_properties.neighbors_id', '=', 'neighbors.id')->join('sub_accounts', 'payments.sub_account_id', '=', 'sub_accounts.id')->select('payments.id', 'payments.collector_id', 'payments.created_at', 'payments.amount', 'payments.coments', 'neighbors.name', 'neighbors.last_name', 'sub_accounts.description')->where('neighbor_property_id', '=', $property_id)->orderBy('payments.id', 'ASC')->get();
     $ano = date("Y");
     $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get();
     $monthly_ini = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->orderBy('monthly_fee.created_at', 'ASC')->pluck('since');
     $mes_ini = (int) date("m", strtotime($monthly_ini));
     $meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
     $mes = array("Ene", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
     $cuotas = array();
     foreach ($monthly_all as $cuota_mensual) {
         $ini = (int) date("m", strtotime($cuota_mensual->since));
         $fin = (int) date("m", strtotime($cuota_mensual->until));
         if ($cuota_mensual->until == NULL) {
             $fin = (int) date("m");
         }
         for ($i = $ini; $i <= $fin; $i++) {
             $cuotas[$i] = $cuota_mensual->amount;
         }
     }
     $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first();
     $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urb_name . " ]";
     $total = count($neighbor_payments);
     return View::make('dashboard.payments.record.index_record', ['payments' => $neighbor_payments, 'breadcrumbs_data' => $breadcrumbs_data, 'AssigmentRole' => $AssigmentRole, 'total' => $total, 'cuotas' => $cuotas, 'mes_ini' => $mes_ini, 'meses' => $meses, 'mes' => $mes, 'urbanismo' => $urbanismo]);
 }
コード例 #2
0
 public function config_index()
 {
     $attendant_id = Auth::user()->id;
     $attendant = Neighbors::with('NeighborProperty')->findOrFail($attendant_id);
     $urbanism_types = UrbanismType::orderBy('id', 'ASC')->lists('type', 'id');
     $countries = Country::orderBy('id', 'ASC')->lists('name', 'id');
     return View::make('dashboard.colonies.config.index', ['urbanism_types' => $urbanism_types, 'attendant' => $attendant, 'countries' => $countries, 'select' => ['' => 'Seleccione tipo de desarrollo'], 'select_1' => ['' => 'Seleccione País'], 'select_2' => ['' => 'Seleccione Estado'], 'select_3' => ['' => 'Seleccione Ciudad']]);
 }
コード例 #3
0
 public function vistaAsignar()
 {
     $user_id = Auth::user()->id;
     $colonia = Session::get("colonia");
     $urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
     $urbanismo = $urbanism->id;
     $urb_name = $urbanism->Colony->name;
     $users = Neighbors::select('neighbors.user_id', 'roles.name', 'users.email', 'neighbors_properties.urbanism_id', 'assigned_roles.role_id')->where("neighbors_properties.urbanism_id", "=", $urbanismo)->where("assigned_roles.colony_id", "=", $colonia)->join("users", "neighbors.user_id", "=", "users.id")->join("assigned_roles", "assigned_roles.user_id", "=", "users.id")->join("roles", "assigned_roles.role_id", "=", "roles.id")->join("neighbors_properties", "neighbors_properties.neighbors_id", "=", "neighbors.id")->get();
     $roles = Role::all();
     $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first();
     $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urb_name . " ]";
     return View::make("dashboard.roles.asignarRol")->with(array("users" => $users, "roles" => $roles, 'breadcrumbs_data' => $breadcrumbs_data));
 }
コード例 #4
0
 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]);
 }
コード例 #5
0
 public function permission_tree()
 {
     $attendant_id = Auth::user()->id;
     $attendant = Neighbors::with('NeighborProperty')->findOrFail($attendant_id);
     return View::make('dashboard.admin.permission.tree', ['attendant' => $attendant]);
 }
コード例 #6
0
 public function record_index()
 {
     $user_id = Auth::user()->id;
     $colonia = Session::get("colonia");
     $AssigmentRole = Auth::user()->AssigmentRole[0]->role_id;
     $urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
     $urb_name = $urbanism->Colony->name;
     $collector = Collector::where('user_id', '=', $user_id)->where('urbanism_id', '=', $urbanism->id)->first();
     $collector_neighbor = Neighbors::where('user_id', '=', $user_id)->first();
     $collector_properties = NeighborProperty::where('neighbors_id', '=', $collector_neighbor->id)->pluck('id');
     $neighbors_payments = Payment::join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.id')->join('neighbors', 'neighbors_properties.neighbors_id', '=', 'neighbors.id')->join('sub_accounts', 'payments.sub_account_id', '=', 'sub_accounts.id')->select('payments.id', 'payments.created_at', 'payments.amount', 'payments.coments', 'neighbors.name', 'neighbors.last_name', 'sub_accounts.description')->where('neighbors_properties.urbanism_id', '=', $urbanism->id)->orderBy('created_at')->get();
     $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first();
     $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [" . $urb_name . "]";
     return View::make('dashboard.incomes.record.index', ['incomes' => $neighbors_payments, 'breadcrumbs_data' => $breadcrumbs_data, 'AssigmentRole' => $AssigmentRole, 'total' => 0]);
 }
コード例 #7
0
 public function incomesReport()
 {
     $user_id = Auth::user()->id;
     $colonia = Session::get("colonia");
     $urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
     $neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->get();
     $optionsCorreosVecinos['Todos'] = 'Todos';
     foreach ($neighbors as $key => $neighbor) {
         $tipoUrb = $neighbor->Urbanism->UrbanismType->id;
         if ($tipoUrb == 3) {
             $optionsCorreosVecinos[$neighbor->id] = $neighbor->Neighbors->name . " " . $neighbor->Neighbors->last_name . " | " . $neighbor->Building->description . " - Apartamento " . $neighbor->num_house_or_apartment;
         } else {
             $optionsCorreosVecinos[$neighbor->id] = $neighbor->Neighbors->name . " " . $neighbor->Neighbors->last_name . " | Calle " . $neighbor->Street->name . " - Calle " . $neighbor->num_house_or_apartment;
         }
     }
     $breadcrumbs = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first();
     $breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]";
     return View::make('dashboard.reports.incomes.index', ['optionsCorreosVecinos' => $optionsCorreosVecinos, 'neighbors' => $neighbors, 'breadcrumbs_data' => $breadcrumbs_data]);
 }