public function uniqueEmail() { $email = Input::get('email'); $buscar_email = UserNeighbors::where('email', '=', $email)->first(); if ($buscar_email) { return Response::json(array("response" => 1)); } else { return Response::json(array("response" => 0)); } }
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 function charges_store() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $collector = Collector::where('user_id', '=', $user_id)->where('urbanism_id', '=', $urbanism->id)->first(); $ano = date("Y"); $neighbor = Input::get('valorid'); $amount = Input::get('amount'); $income_charge = new Payment(); $income_charge->neighbor_property_id = $neighbor; $income_charge->collector_id = $collector->id; $income_charge->amount = $amount; $income_charge->sub_account_id = Input::get('sub_account_id'); $income_charge->coments = Input::get('coments'); $income_charge->deposit = null; $income_charge->debt = null; $income_charge->status_id = 1; $income_charge->updated_at = date('Y') . '-01-01 ' . date('H:i:s'); if ($income_charge->save()) { $neighbor_payments = $income_charge; $payment_state = PaymentStates::where('neighbor_property_id', '=', $neighbor)->where('year', '=', $ano)->orderBy('created_at', 'desc')->first(); $months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"); $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $collector->urbanism_id)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get(); $monthly_ini = MonthlyFee::where('monthly_fee.urbanism_id', '=', $collector->urbanism_id)->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; } } $acumulado = $amount; //para guardar el monto $ValorInicial = $amount; //para guardar el valor inicial del monto ingresado $ValorResto = 0; //para comparar con el valor inicial $balance = Balance::where('neighbor_property_id', '=', $neighbor)->pluck('amount'); $balance_saldo = Balance::where('neighbor_property_id', '=', $neighbor)->first(); if ($balance) { $saldo = $balance; if ($saldo > $amount) { $saldo = $saldo - $amount; $amount = 0; $balance_saldo->amount = $saldo; $balance_saldo->update(['id']); } else { if ($saldo < $amount) { $saldo = $amount - $saldo; $amount = $saldo; $balance_saldo->delete(['id']); } else { $saldo = 0; $amount = 0; $balance_saldo->delete(['id']); } } } else { $saldo = 0; } //Si el usuario no ha realizado ningún pago, se llena la tabla Payment_States por primera vez if (!$payment_state) { $TotalCuotas = 0; $payment_state_detail = new PaymentStates(); $payment_state_detail->neighbor_property_id = $neighbor_payments->neighbor_property_id; $payment_state_detail->year = date('Y', strtotime($neighbor_payments->created_at)); //Ciclo hasta el mes actual for ($i = $mes_ini - 1; $i < date('m'); $i++) { if (date('m') != $i + 1) { if ($amount > $cuotas[$months[$i]]) { $payment_state_detail->{$months}[$i] = $cuotas[$months[$i]]; $amount = $amount - $cuotas[$months[$i]]; } else { if ($amount < $cuotas[$months[$i]] && $amount != 0) { $payment_state_detail->{$months}[$i] = $amount; $amount = 0; } else { $payment_state_detail->{$months}[$i] = $cuotas[$months[$i]]; $amount = 0; } } } else { //si es el mes actual // for: suma todas las cuotas de cada mes, las q se deben for ($j = $mes_ini - 1; $j < date('m'); $j++) { if ($payment_state_detail->{$months}[$j] == null) { $TotalCuotas = $TotalCuotas + $cuotas[$months[$j]]; } elseif ($payment_state_detail->{$months}[$j] < $cuotas[$months[$j]] && $payment_state_detail->{$months}[$j] > 0) { $resto_mes = $cuotas[$months[$j]] - $payment_state_detail->{$months}[$j]; $TotalCuotas = $TotalCuotas + $resto_mes; } } if ($TotalCuotas > $amount) { $TotalCuotas = $TotalCuotas - $amount; $payment_state_detail->{$months}[$i] = "-" . $TotalCuotas; } elseif ($TotalCuotas < $amount) { $TotalCuotas = $amount - $TotalCuotas; $payment_state_detail->{$months}[$i] = $cuotas[$months[$i]] + $TotalCuotas; $amount = $TotalCuotas; } elseif ($TotalCuotas == $amount) { //si la cuota es igual al monto que esta pagando $payment_state_detail->{$months}[$i] = $cuotas[$months[$i]]; $amount = 0; } } } //fin del ciclo $payment_state_detail->accumulated = $acumulado; //Se guardan los datos en Payment_States $payment_state_detail->save(); } else { //si ya tiene registros en payment_state $fondo = $payment_state->accumulated + $amount; $valorResto = 0; $abono = 0; for ($i = $mes_ini - 1; $i < date('m'); $i++) { if (date('m') != $i + 1) { if ($payment_state->{$months}[$i]) { if ($payment_state->{$months}[$i] != $cuotas[$months[$i]] && $payment_state->{$months}[$i] > 0) { $valorResto = $ValorResto + $payment_state->{$months}[$i]; $amount = $amount + $valorResto; if ($amount > $cuotas[$months[$i]]) { $payment_state->{$months}[$i] = $cuotas[$months[$i]]; $amount = $amount - $cuotas[$months[$i]]; } else { $payment_state->{$months}[$i] = $amount; $amount = 0; } } } else { if ($amount > $cuotas[$months[$i]]) { $payment_state->{$months}[$i] = $cuotas[$months[$i]]; $amount = $amount - $cuotas[$months[$i]]; } else { if ($amount < $cuotas[$months[$i]]) { $payment_state->{$months}[$i] = $amount; $amount = 0; } else { $payment_state->{$months}[$i] = $cuotas[$months[$i]]; $amount = 0; } } } } else { //si es el mes actual if ($payment_state->{$months}[$i] < 0) { $deuda = -1 * $payment_state->{$months}[$i]; $deuda = $amount - $deuda; if ($deuda < 0) { $payment_state->{$months}[$i] = $deuda; } else { if ($deuda == 0) { $payment_state->{$months}[$i] = $cuotas[$months[$i]]; } else { $payment_state->{$months}[$i] = $deuda + $cuotas[$months[$i]]; } } } else { $abono = $payment_state->{$months}[$i] + $amount; $payment_state->{$months}[$i] = $abono; } } } $payment_state->accumulated = $fondo; $payment_state->update(['id']); } //---envio por email de recibo al pagador--- $mensaje = null; $monto = Input::get('amount'); $infoCobrador = Neighbors::with('NeighborProperty')->where('user_id', '=', $user_id)->first(); $infoPagador = NeighborProperty::where('id', '=', $neighbor)->first(); $email = UserNeighbors::where('id', '=', $infoPagador->Neighbors->user_id)->pluck('email'); $tipoUrb = $infoPagador->Urbanism->UrbanismType->id; if ($tipoUrb == 3) { $Domicilio = "Piso " . $infoPagador->Building->description . ' - Apartamento ' . $infoPagador->num_house_or_apartment; } else { $Domicilio = "Calle " . $infoPagador->Street->name . ' - Casa ' . $infoPagador->num_house_or_apartment; } $Colony = Urbanism::with('Colony.City')->where('id', '=', $infoPagador->Urbanism->id)->first(); $state = DB::table('states')->where('id', $Colony->Colony->City->state_id)->first(); $dias = array("Domingo", "Lunes", "Martes", "Miércoles", "Jueves", "Viernes", "Sábado"); $meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"); $fecha = $dias[date('w')] . " " . date('d') . " de " . $meses[date('n') - 1] . " del " . date('Y'); $pay_states = PaymentStates::where('neighbor_property_id', '=', $neighbor)->where('year', '=', $ano)->get(); $data = array('Cobrador' => $infoCobrador->name . " " . $infoCobrador->last_name, 'Nombre' => $infoPagador->Neighbors->name . " " . $infoPagador->Neighbors->last_name, 'Domicilio' => $Domicilio, 'monto' => $monto, 'Fecha' => $fecha, 'colonia' => $Colony->Colony->name, 'urbanismo' => $infoPagador->Urbanism->name, 'estado' => $state->name, 'ciudad' => $Colony->Colony->City->name, 'payments' => $pay_states, 'months' => $months, 'cuotas' => $cuotas, 'mes_ini' => $mes_ini); try { Mail::send('emails.Recibo', $data, function ($message) use($email) { $message->to($email); $message->subject('Recibo de pago'); }); } catch (Exception $exc) { Mail::send('emails.Recibo', $data, function ($message) use($email) { $message->to($email); $message->subject('Recibo de pago'); }); } // ---/fin de envio por email de recibo al pagador/---- //se agrego el logs Event::fire('logs', 'hizo un Cobro al Domicilio ' . $Domicilio . ' de un Monto de' . $monto); //fin logs return Redirect::action('IncomesController@charges_index')->with('error', false)->with('msg', 'Cobro ingresado con éxito.')->with('class', 'info'); } else { return Redirect::back()->with('error', true)->with('msg', '¡Algo salió mal! Contacte con administrador.')->with('class', 'danger'); } }