public function send_cupon($id)
{
$promo = Promo::where('id', '=', $id)->first();
$user_id = AssigmentRoleHab::where('role_id', '=', 2)->where('colony_id', '=', $promo->colony_id)->pluck('user_id');
$admin_user = DB::connection('habitaria_dev')->select('select email from users where id = ? ', [$user_id]);
foreach ($admin_user as $user) {
$admin_email = $user->email;
}
$admin_neighbor = Neighbors::where('user_id', '=', $user_id)->first();
$colony_data = Colony::where('id', '=', $promo->colony_id)->first();
$colony_name = $colony_data->name;
$data = array('email' => $admin_email, 'days' => $promo->days, 'code' => Crypt::decrypt($promo->code), 'colony' => $colony_name, 'admin' => $admin_neighbor->name . ' ' . $admin_neighbor->last_name);
Mail::send('emails.cupon_promo', $data, function ($message) use($admin_email) {
$message->subject('Promo de HABITARIA');
$message->to($admin_email);
});
$notice_msg = 'Promo enviada al administrador de la Colonia: ' . $colony_name;
return Redirect::back()->with('error', false)->with('msg', $notice_msg)->with('class', 'info');
}
public function promo_store()
{
$data = Input::all();
$colonia = Input::get('colony_id');
$code = Input::get('code');
$promo_colonia = Promo::where('colony_id', '=', $colonia)->get();
$code_exist = 0;
foreach ($promo_colonia as $promo) {
if ($code == Crypt::decrypt($promo->code)) {
$code_exist = 1;
$code_id = $promo->id;
$promo_status = $promo->status;
}
}
if ($code_exist == 1) {
if ($promo_status == 0) {
$promo = Promo::where('id', '=', $code_id)->first();
$promo->status = 1;
if ($promo->update(['id'])) {
$expiration = Expiration::where('colony_id', '=', $colonia)->first();
$expiration_old = date('Y-m-j', strtotime($expiration->expiration));
$newExpiration = strtotime('+' . $promo->days . ' day', strtotime($expiration_old));
$newExpiration = date('Y-m-j', $newExpiration);
$expiration->expiration = $newExpiration;
$expiration->update(['id']);
$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);
$notice_msg = 'Código de la promo activado';
return Redirect::route('home')->with('notice_modal', $notice_msg);
}
} else {
$error_msg = 'Este Código de la promo ya se fue utilizado';
return Redirect::back()->with('error_modal', $error_msg);
}
} else {
$error_msg = 'Código de la promo inválido';
return Redirect::back()->with('error_modal', $error_msg);
}
}
