/** * Update Events from CRM */ public function onUpdateFromCrm() { $crmuserevents = CRMUserEvent::isNotUpdated()->with(['user', 'event'])->get(); \CW::info(['userevents' => $crmuserevents]); if (count($crmuserevents) == 0) { Flash::info("No UserEvents to Create/Update"); // echo "ERROR!"; return; } $crmuserevents->each(function ($userevent) { if ($userevent->user && $userevent->event) { \CW::info([$userevent]); $cmsuser = User::where('email', $userevent->user->email)->first(); $cmsevent = Event::where('crm_event_id', $userevent->event->id)->with('course')->first(); $cmscourse = $cmsevent->course; $cmsusereventstate = UserEventState::where('crm_state_id', $userevent->state_id)->first(); // $cmsuserevent = UserEvent::firstOrNew(['crm_event_id' => $userevent->event->id, 'user_id' => $cmsuser->id]); // $cmsuserevent = $cmsuser->userevents() // $cmsuserevent = $cmsuserevent $cmsuserevent = UserEvent::where('user_id', $cmsuser->id)->where('event_id', $cmsevent->id)->first(); if (!$cmsuserevent) { $cmsuserevent = new UserEvent(); } \CW::info([$cmsuser, $cmsevent, $cmscourse, $cmsuserevent, $cmsusereventstate]); // if (!$cmsuser) { // Log::warning("CMSUser is NULL\n"); // } // if (!$cmsevent) { // Log::warning("CMSEvent is NULL\n"); // } // if (!$cmscourse) { // Log::warning("CMSCourse is NULL\n"); // } // if (!$cmsuserevent) { // Log::warning("CMSUserEvent is NULL\n"); // } // if (!$cmsusereventstate) { // Log::warning("CMSUserEventState is NULL\n"); // } $cmsuserevent->user()->associate($cmsuser); $cmsuserevent->course()->associate($cmscourse); $cmsuserevent->state()->associate($cmsusereventstate); $cmsuserevent->event()->associate($cmsevent); $cmsuserevent->fill(['course_type_id' => $cmscourse->course_type_id, 'course_category_id' => $cmscourse->course_category_id, 'crm_event_id' => $userevent->event->id]); \CW::info([$cmsuserevent]); $cmsuserevent->save(); $userevent->update(['is_updated' => true]); } }); Flash::success("UserEvents is update"); }
/** * Deleted checked usereventstates. */ public function index_onDelete() { if (($checkedIds = post('checked')) && is_array($checkedIds) && count($checkedIds)) { foreach ($checkedIds as $usereventstateId) { if (!($usereventstate = UserEventState::find($usereventstateId))) { continue; } $usereventstate->delete(); } Flash::success(Lang::get('abnmt.mrc::lang.usereventstates.delete_selected_success')); } else { Flash::error(Lang::get('abnmt.mrc::lang.usereventstates.delete_selected_empty')); } return $this->listRefresh(); }
public function onAddCourse() { extract(post()); $user = $this->user(); if (!$user) { Flash::info('Войдите или Зарегистрируйтесь, чтобы записаться на курс!'); return ['#layout-flash-messages' => $this->renderPartial('@message')]; } $course = CourseModel::find($course_id); // $userevents = $user->userevents()->isInOrder(); try { $el = '#js' . $course_id . $type_id . $cat_id; // CW::info(['check' => $order->courses->contains('id', $course->id)]); if ($user->userevents->contains('course_id', $course->id)) { Flash::info('Учебная программа уже в личном кабинете'); return [$el => $this->renderPartial('@button'), '#layout-flash-messages' => $this->renderPartial('@message')]; } $userevent = new UserEventModel(); $userevent->user()->associate($user); $userevent->course()->associate($course); $userevent->state()->associate(UserEventStateModel::find(1)); // Статус: В заявке $userevent->fill(['course_type_id' => $type_id, 'course_category_id' => $cat_id]); $userevent->save(); Flash::success('Учебная программа добавлена в личный кабинет'); return [$el => $this->renderPartial('@button'), '#layout-flash-messages' => $this->renderPartial('@message')]; } catch (Exception $e) { Flash::error('Ошибка!'); return ['#layout-flash-messages' => $this->renderPartial('@message')]; } }
public function onOrder() { extract(post()); if (!post()) { return; } $user = $this->user(); CW::info(['orderPOST' => post()]); // CW::info(['UserEventsId' => array_keys($course_events)]); // CW::info(['EventsId' => array_values($course_events)]); $ids = array_map('intval', $course_events); CW::info(['UserEventId: EventId' => $ids]); $_userevents = $user->userevents()->whereIn('id', array_keys($course_events))->get(); CW::info(['UserEvents' => $_userevents]); $_events = EventModel::whereIn('id', $ids)->get(); CW::info(['Events' => $_events]); // return; $_userevents->each(function ($userevent) use($ids) { if ($userevent->state_id == 9) { $userevent->delete(); } else { // $event = $_events->where('id', $ids[$userevent->id]); $event = EventModel::find($ids[$userevent->id]); // CW::info(['UserEvent' => $userevent]); CW::info(['Event' => $event]); if (!$event) { $userevent->state()->associate(UserEventStateModel::find(7)); // Статус: В списке $userevent->save(); // Flash::info('Войдите или Зарегистрируйтесь, чтобы записаться на курс!'); // return ['#flashMessages' => $this->renderPartial('@message')]; } else { $userevent->event()->associate($event); $userevent->state()->associate(UserEventStateModel::find(6)); // Статус: В обработке $userevent->save(); } } }); // return \Redirect::refresh()->with('order_state', 'complete'); // return \Redirect::to('personal/order/confirm'); $user['profile'] = $user->profile; $userevents = $user->userevents()->select('id', 'course_id', 'event_id', 'state_id')->with(['course' => function ($q) { $q->select('id', 'crm_course_id', 'title'); }, 'event' => function ($q) { $q->select('id', 'crm_event_id', 'hours', 'price', 'date_start', 'date_end', 'teacher'); }, 'state' => function ($q) { $q->select('id', 'crm_state_id', 'title'); }])->get(); // CW::info(['email_data' => $_userevents]); // CW::info(['email_data' => $email_data]); $this->sendEmail(['user' => $user, 'userevents' => $userevents]); Flash::info('Ваша заявка оформлена!'); return ['#layout-flash-messages' => $this->renderPartial('@message')]; // $event = new EventModel; // $userevent = new UserEventModel; }