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->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)->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 sendMailInvitation()
{
$last_invited_add = Input::get('invited_id');
$inv_admin = Input::get('admin_colonia');
$admin_colonia = Neighbors::where('id', '=', $inv_admin)->first();
$neighbors = InvitedNeighbors::where('invited_id', '=', $last_invited_add)->get();
$urbanism_id = Input::get('urbanismo');
$urbanism = Urbanism::findOrFail($urbanism_id);
$code = Session::get('code');
foreach ($neighbors as $inv_neighbor) {
$email = $inv_neighbor->email;
$data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => $inv_neighbor->confirmation_code, 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->name);
Mail::send('emails.confirm_neighbors', $data, function ($message) use($email) {
$message->subject('Invitación HABITARIA');
$message->to($email);
});
}
$notice_msg = "<h4>A concluido el proceso de registro</h4><p>Vecinos invitados con éxito</p>";
return Redirect::action('NeighborController@admin_neighbor', array('admin_colonia' => $inv_admin, 'urbanismo' => $urbanism_id));
}
public function asignarRol()
{
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$datos = (string) Input::get("rol");
$array = explode(",", $datos);
$num = count($array);
for ($i = 0; $i < $num; $i++) {
$roles = explode(".", $array[$i]);
$id = (int) $roles[1];
$rol = (int) $roles[0];
$urb = (int) $roles[2];
//$permisos = Permisos::all();
//$permisos = Permisos::find($id);
Permisos::where("user_id", "=", $id)->where("colony_id", "=", Session::get("colonia"))->update(array("role_id" => $rol));
$BuscarCollector = Collector::where("user_id", "=", $id)->where('urbanism_id', '=', $urbanism->id)->orderBy('updated_at', 'desc')->first();
if ($rol == 2 || $rol == 3 || $rol == 4 || $rol == 5) {
if (!$BuscarCollector) {
$Collector = new Collector();
$Collector->user_id = $id;
$Collector->urbanism_id = $urb;
$Collector->save();
}
}
if ($rol == 6) {
if ($BuscarCollector) {
$cobrador = Collector::findOrFail($BuscarCollector->id);
$cobrador->delete(['id']);
}
}
//$permisos->role_id = $rol;
//$permisos->save();
}
return Response::json(array("estado" => 1));
}
$accion = "Visito Mi Historial";
break;
case 'dashboard/payments/neighbors':
$accion = "Visito Mis Vecinos";
break;
case 'dashboard/incomes/charge':
$accion = "Visito Ingresos Cobrar";
break;
case 'dashboard/incomes/record':
$accion = "Visito Ingresos Historial";
break;
case 'dashboard/incomes/charge/balances':
$accion = "Visito Ingresos Saldos";
break;
case 'dashboard/expenses':
$accion = "Visito Egresos Registrar Gasto";
break;
}
if ($accion != '' and Auth::check()) {
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
Logs::create(['user' => Auth::user()->Neighbors->name . ' ' . Auth::user()->Neighbors->last_name, 'rol_user' => Role::find(Auth::user()->AssigmentRole[0]->role_id)->name, 'urbanism_id' => $urbanism->id, 'user_email' => Auth::user()->email, 'accion' => $accion, 'fecha' => (new DateTime())->format('d-m-Y H:i:s')]);
}
return false;
});
Event::fire('illuminate.controller');
Event::listen('logs', function ($accion) {
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
Logs::create(['user' => Auth::user()->Neighbors->name . ' ' . Auth::user()->Neighbors->last_name, 'rol_user' => Role::find(Auth::user()->AssigmentRole[0]->role_id)->name, 'urbanism_id' => $urbanism->id, 'user_email' => Auth::user()->email, 'accion' => $accion, 'fecha' => (new DateTime())->format('d-m-Y H:i:s')]);
});
public function confirm_data_fam($code)
{
if (!$code) {
$error_msg = new InvalidConfirmationCodeException();
return Redirect::action('UsersController@login')->with('error', $error_msg);
}
$confirm = InvitedNeighbors::where('Confirmation_code', '=', $code)->first();
if (!$confirm) {
$error_msg = Lang::get('confide::confide.alerts.wrong_confirmation');
return Redirect::action('UsersController@login')->with('error', $error_msg);
}
if (!$confirm->confirmed) {
$email = $confirm->email;
$reg_user = User::where('email', '=', $email)->first();
if ($reg_user) {
$reg_neighbor = Neighbors::where('user_id', '=', $reg_user->id)->first();
$property = NeighborProperty::where('neighbors_id', '=', $reg_neighbor->id)->first();
$urbanism_id = $confirm->urbanism_id;
$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)->first();
} else {
$catalog = StreetCatalog::where('urbanism_id', '=', $urbanism_id)->first();
}
$notice_msg = Lang::get('confide::confide.alerts.confirmation_invitation');
return View::make('dashboard.neighbors.edit_fam', ['email' => $email, 'urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'code' => $code, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'neighbor' => $reg_neighbor, 'property' => $property, 'notice' => $notice_msg]);
} else {
return Redirect::action('ConfirmationController@confirm', $code);
}
} else {
$notice_msg = 'Acceda a Habitaria con su usuario creado';
return Redirect::action('UsersController@login')->with('notice', $notice_msg);
}
}
public function modalEstadoCuenta()
{
$neighbor_property_id = Input::get('neighbor_property_id');
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$urbanismo = $urbanism->id;
$urb_name = $urbanism->name;
$property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->pluck('id');
$vigencia = date("Y-m");
$months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem");
$today = date("Y-m-d");
$ano = date("Y");
$selano = Payment::select(DB::raw('DATE_FORMAT(payments.created_at,\'%Y\') as y'))->groupBy(DB::raw('Year(payments.created_at)'))->orderBy(DB::raw('Year(payments.created_at)'))->get();
$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));
$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[$months[$i - 1]] = $cuota_mensual->amount;
}
}
for ($j = 0; $j <= 11; $j++) {
if ($j + 1 < $mes_ini) {
$saldoAnteriol[$j] = "";
$cuataMes[$j] = "";
$totalDebe[$j] = "";
$pagos[$j] = "";
$saldoTotal[$j] = "";
} elseif ($j + 1 <= date("m")) {
$saldoAnteriol[$j] = $saldoTotal[$j - 1];
$cuataMes[$j] = -$cuotas[$months[$j]];
$totalDebe[$j] = $saldoAnteriol[$j] + $cuataMes[$j];
$neighbor_payments = PaymentStates::with('NeighborProperty')->where('neighbor_property_id', '=', $neighbor_property_id)->first();
if ($neighbor_payments) {
$pagos[$j] = $neighbor_payments->{$months}[$j] == NULL ? 0 : $neighbor_payments->{$months}[$j];
} else {
$pagos[$j] = 0;
}
$saldoTotal[$j] = $totalDebe[$j] + $pagos[$j];
} elseif ($j + 1 > date("m")) {
$saldoAnteriol[$j] = "";
$cuataMes[$j] = "";
$totalDebe[$j] = "";
$pagos[$j] = "";
$saldoTotal[$j] = "";
}
}
$neighbor = NeighborProperty::find($neighbor_property_id);
return View::make('dashboard.payments.neighbors.table_neigbor', compact('breadcrumbs_data', 'saldoAnteriol', 'cuataMes', 'totalDebe', 'pagos', 'saldoTotal', 'mes_ini', 'ini', 'months', 'color', 'neighbor'));
}
public function catologo_egreso()
{
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$catalog = SubAccount::where('urbanism_id', '=', $urbanism->id)->where('account_id', '=', 2)->orderBy('id', 'ASC')->get();
$breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first();
$breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]";
return View::make('dashboard.expenses.catalogo_egresos', ['usuario' => $breadcrumbs_data, 'urbanism_id' => $urbanism->id, 'catalog' => $catalog]);
}
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 sugerenciasPapelera()
{
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$neighbor = Neighbors::where('user_id', '=', $user_id)->first();
$neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->where('neighbors_id', '!=', $neighbor->id)->get();
$breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first();
$breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]";
$suggestions = Suggestion::where('user_id', '=', $user_id)->where('tray', '=', 0)->where('bd_inbox', '=', 1)->orderBy('created_at', 'desc')->paginate(10);
$count = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('bd_inbox', '=', 2)->where('mark', '<>', 'read')->count();
return View::make('dashboard.colonies.suggestions.suggestions_trash', ['usuario' => $breadcrumbs_data, 'urbanism' => $urbanism, 'admin' => $neighbor->id, 'suggestions' => $suggestions, 'count' => $count, 'contador' => 1, 'neighbor' => $neighbor]);
}
public function suggestion()
{
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$neighbor = Neighbors::where('user_id', '=', $user_id)->first();
$neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanism->id)->where('neighbors_id', '!=', $neighbor->id)->get();
$breadcrumbs = Neighbors::where('user_id', '=', $user_id)->first();
$breadcrumbs_data = $breadcrumbs->name . " " . $breadcrumbs->last_name . " [ " . $urbanism->Colony->name . " ]";
$suggestions = DB::table('suggestions')->select('suggestions.id', 'suggestions.user_id', 'neighbors.name', 'neighbors.last_name', 'suggestions.asunto', 'suggestions.contenido', 'suggestions.id_mensaje', 'suggestions.mark', 'suggestions.created_at')->join('neighbors', 'neighbors.user_id', '=', 'suggestions.user_id')->where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->orderBy('created_at', 'desc')->paginate(10);
$count = Suggestion::where('id_receptor', '=', $user_id)->where('tray', '<>', 0)->where('mark', '<>', 'read')->count();
$suggestionsSent = Suggestion::where('user_id', '=', $user_id)->where('tray', '<>', 0)->get();
return View::make('dashboard.colonies.suggestions.suggestion', ['usuario' => $breadcrumbs_data, 'urbanism' => $urbanism->id, 'admin' => $neighbor->id, 'suggestions' => $suggestions, 'count' => $count, 'suggestionsSent' => $suggestionsSent, 'contador' => 1]);
}
public function reportStatus()
{
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$urbanismo = $urbanism->id;
$urb_name = $urbanism->name;
$property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->pluck('id');
$vigencia = date("Y-m");
$months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem");
$today = date("Y-m-d");
$ano = date("Y");
$selano = Payment::select(DB::raw('DATE_FORMAT(payments.created_at,\'%Y\') as y'))->groupBy(DB::raw('Year(payments.created_at)'))->orderBy(DB::raw('Year(payments.created_at)'))->get();
$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));
$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[$months[$i - 1]] = $cuota_mensual->amount;
}
}
$neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanismo)->get();
$breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', self::getUserId())->first();
$breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [" . $breadcrumbs->name_ur . "]";
$data = ['mes_ini' => $mes_ini, 'months' => $months, 'cuotas' => $cuotas, 'selano' => $selano, 'urbanism' => $urbanismo, 'breadcrumbs_data' => $breadcrumbs_data, 'neighbors' => $neighbors, 'ini' => $ini, 'fin' => $fin, 'ano' => $ano, 'breadcrumbs_data' => $breadcrumbs_data];
$pdf = PDF::loadView('dashboard.reports.status.pdf', $data);
return $pdf->download('reporte_Estato_cuanta_general.pdf');
}
public function store_register_neighbors()
{
$post = Input::All();
$urbanismNeigh = Input::get('urbanism');
$neighbor = new Neighbors();
$neighbor->user_id = Input::get('user_id');
//$neighbor->urbanism_id = Input::get('urbanism');
$neighbor->name = Input::get('firstname');
$neighbor->last_name = Input::get('lastname');
$neighbor->phone = Input::get('phone');
$neighbor->save();
$last_neighbor_add = $neighbor->id;
$urbanism_type = Input::get('urbanism_type');
$neighbor_properties = new NeighborProperty();
$neighbor_properties->neighbors_id = $last_neighbor_add;
$neighbor_properties->urbanism_id = Input::get('urbanism');
if ($urbanism_type == 3) {
$neighbor_properties->num_floor_id = Input::get('name_floor');
} else {
$neighbor_properties->num_street_id = Input::get('name_street');
}
$neighbor_properties->num_house_or_apartment = Input::get('num_house_or_apartment');
if ($neighbor_properties->save()) {
$role = Role::where('name', '=', 'vecino')->first();
$colony = Urbanism::where('id', '=', Input::get('urbanism'))->pluck('colony_id');
$rol = new AssigmentRole();
$rol->user_id = Input::get('user_id');
$rol->role_id = $role->id;
$rol->colony_id = $colony;
$rol->save();
}
$colonies = Colony::select('colonies.id')->join('urbanisms', 'urbanisms.colony_id', '=', 'colonies.id')->join('neighbors_properties', 'urbanisms.id', '=', 'neighbors_properties.urbanism_id')->where('neighbors_properties.urbanism_id', '=', $urbanismNeigh)->first();
$user = Neighbors::where('id', '=', $last_neighbor_add)->pluck('user_id');
$user_auth = User::where('id', '=', $user)->first();
Auth::login($user_auth);
if (Auth::check()) {
Session::put('colonia', $colonies->id);
return Redirect::action('HomeController@index');
} else {
return Redirect::action('UsersController@login');
}
}
