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]);
}
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']]);
}
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));
}
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 permission_tree()
{
$attendant_id = Auth::user()->id;
$attendant = Neighbors::with('NeighborProperty')->findOrFail($attendant_id);
return View::make('dashboard.admin.permission.tree', ['attendant' => $attendant]);
}
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]);
}
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]);
}
