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); } }