function show() { // $this->render("test/ $s = ST::microtime_float(); $start = '2015-11-30'; $end = '2016-01-11'; $events = Vks::where('start_date_time', ">=", $start)->where('start_date_time', '<=', $end)->where('status', VKS_STATUS_APPROVED)->get(); $e = ST::microtime_float(); print $e - $s; }
public function search($phrase) { if (ST::isAjaxRequest()) { $vksWSC = new Vks_controller(); $result = []; $result['ws'] = Vks::where("id", $phrase)->whereIn('status', [VKS_STATUS_APPROVED, VKS_STATUS_PENDING])->take(1)->get(); foreach ($result['ws'] as $vks) { $vksWSC->humanize($vks); } print json_encode($result); } }
/** * Define the application's command schedule. * * @param \Illuminate\Console\Scheduling\Schedule $schedule * @return void */ protected function schedule(Schedule $schedule) { $schedule->call(function () { $vksList = Vks::where('is_verified_by_user', 0)->with('owner', 'location')->get(); // foreach ($vksList as $vks) { if ($vks->is_verified_by_user == 0 && date_create($vks->start_date_time) > date_create($vks->update_at) && date_create($vks->start_date_time)->getTimestamp() - date_create($vks->update_at)->getTimestamp() <= 86400) { $t = view('verificationMail', ['vks' => $vks]); \Mail::sendMailToStack($vks->owner->login, "Просим подтвердить проведение ВКС #{$vks->id}", $t->render()); $vks->is_verified_by_user = USER_VERIFICATION_MAIL_SENDED; $vks->save(); \App::$instance->log->logWrite(LOG_MAIL_SENDED, "Верификационное письмо по ВКС {$vks->id}, отправлено {$vks->owner->login}"); } } })->everyMinute()->sendOutputTo('verification_log.txt'); }
public function collect() { $vc = new Vks_controller(); $request = $this->request->request; // dump($request); $this->validator->validate(['Начало' => [$request->get('dates')['start'], 'required|date'], 'Окончание' => [$request->get('dates')['end'], 'required|date']]); if (!$this->validator->passes()) { $this->putUserDataAtBackPack($this->request); App::$instance->MQ->setMessage($this->validator->errors()->all(), 'danger'); ST::redirect("back"); } $start = date_create($request->get('dates')['start']); $end = date_create($request->get('dates')['end']); if ($start > $end) { $this->putUserDataAtBackPack($this->request); App::$instance->MQ->setMessage("Дата начала больше даты окончания", 'danger'); ST::redirect("back"); } if (date_diff($end, $start)->days > 90) { $this->putUserDataAtBackPack($this->request); App::$instance->MQ->setMessage("Задан слишком большой диапазон для выборки, максимум 60 дней", 'danger'); ST::redirect("back"); } //prepare filter $statuses = []; if ($request->has('filter') && isset($request->get('filter')['status']) && count($request->get('filter')['status'])) { foreach ($request->get('filter')['status'] as $status => $indicator) { $statuses[] = $status; } } // dump($statuses); $collectVkses = []; $collectVksesRaw = Vks::where('start_date_time', '>=', $start)->where('start_date_time', "<=", $end)->whereIn('status', $statuses)->full()->get(); if (count($collectVksesRaw)) { foreach ($collectVksesRaw as $vks) { $collectVkses[] = $vc->humanize($vks); } } else { $this->putUserDataAtBackPack($this->request); App::$instance->MQ->setMessage("ВКС в запрашиваемом периоде не найдено, попробуйте изменить запрос", 'info'); ST::redirect("back"); } // dump($collectVkses); $this->makeExcel($collectVkses); }
public function show($filter = 'all') { Auth::isLoggedOrDie(App::$instance); $selectedFilter = mb_strtolower($filter); $filters = ['all', 'meaning', 'pending', 'status', 'invited', 'deleted']; if (!in_array($selectedFilter, $filters)) { App::$instance->MQ->setMessage("Фильтр не определен, вам будут показаны все записи"); } $statusesForSelect = []; switch ($selectedFilter) { case 'all': $statusesForSelect = [VKS_STATUS_DELETED, VKS_STATUS_APPROVED, VKS_STATUS_PENDING, VKS_STATUS_DROP_BY_USER]; break; case 'meaning': $statusesForSelect = [VKS_STATUS_APPROVED, VKS_STATUS_PENDING]; break; case 'pending': $statusesForSelect = [VKS_STATUS_PENDING]; break; case 'status': $statusesForSelect = [VKS_STATUS_APPROVED]; break; case 'deleted': $statusesForSelect = [VKS_STATUS_DELETED, VKS_STATUS_DROP_BY_USER]; break; default: $statusesForSelect = [VKS_STATUS_DELETED, VKS_STATUS_APPROVED, VKS_STATUS_PENDING, VKS_STATUS_DROP_BY_USER]; break; } $vksList = Vks::where('owner_id', App::$instance->user->id)->whereIn('status', $statusesForSelect)->full()->take($this->getQlimit(30))->skip($this->getQOffset())->orderBy($this->getQOrder(), $this->getQVector())->get(); $vksCtrl = new Vks_controller(); foreach ($vksList as &$vks) { $vks->manipulatable = VKSTimeAnalizator::isManipulatable($vks); $vks->dayBeforeStart = VKSTimeAnalizator::is24ForBegin($vks); $vks = $vksCtrl->humanize($vks); // dump($vks); } $recordsCount = Vks::where('owner_id', App::$instance->user->id)->whereIn('status', $statusesForSelect)->count(); //pages $pages = RenderEngine::makePagination($recordsCount, $this->getQlimit(30), 'route'); $this->render("lk/index", compact('vksList', 'pages', 'filter')); }
public function feedAtParticipant() { $start = date_create($this->request->query->get('start'))->setTime(0, 0); $end = date_create($this->request->query->get('end'))->setTime(23, 59); $requested_participant_id = intval($this->request->query->get('requested_participant_id')); $vkses = Vks::where('start_date_time', ">=", $start)->where('start_date_time', '<=', $end)->whereIn('status', [VKS_STATUS_PENDING, VKS_STATUS_APPROVED])->notSimple()->with('participants')->get(); $filtered_vkses = array(); if (count($vkses)) { foreach ($vkses as $vks) { if (count($vks->participants)) { foreach ($vks->participants as $participant) { if ($participant->id === $requested_participant_id) { $filtered_vkses[] = $vks; } } } } } // dump($vkses); $filtered_vkses = $this->prepareEvents($filtered_vkses); print json_encode($filtered_vkses); //output }
public function showCACodes($date, $partial = false) { $pullFromCa = $this->aksForCaTransportVksInDate($date); $collected = []; $pool = App::$instance->callService("vks_ca_negotiator")->askForPool(); foreach ($pool as $code) { $collected[$code] = []; } foreach ($collected as $key => $val) { foreach ($pullFromCa as $caVks) { $caVks->v_room_num == $key ? $collected[$key][] = $caVks : false; $caVks->tbVks = Vks::where('link_ca_vks_id', $caVks->id)->first(); } } // dump($collected); $date = date_create($date)->format('d.m.Y'); // dump($collected); $this->render('Dashboards/showCaPoolCodes', compact('collected', 'date', 'partial')); }
private function getLoadAtPeriod($timeSpot1, $timeSpot2, $serverNum) { $result = Null; switch ($serverNum) { case 0: foreach (Vks::where('start_date_time', '<=', $timeSpot2)->where('end_date_time', '>=', $timeSpot1)->approved()->get(['id']) as $vks) { $result += Vks_controller::countParticipants($vks->id); } break; } return $result; }
$app->tbId = CAAttendance::where('name', 'like', '%' . TB_PATTERN . '%')->where('is_tb', 1)->first()->id; header($app->opt->header); date_default_timezone_set($app->opt->timezone); //require_once('../init.php'); //start schedule here //----------------------------------------------------------------------------- $now = date_create()->setTimezone(new DateTimeZone(NODE_TIME_ZONE)); $now->modify("+25 minutes"); $now->setTime($now->format('H'), $now->format('i'), 0); $mskTime = clone $now; //dump($now); $mskTime->setTimezone(new DateTimeZone(App::$instance->opt->ca_timezone)); $CaNotes = new NotesCa_controller(); if ($now->format('i') % 15 == 0) { $events = Vks::where(function ($query) use($now) { $query->where('start_date_time', $now)->whereIn('status', [VKS_STATUS_APPROVED]); })->where(function ($query) { $query->where('flag', 1)->orWhere('record_required', 1); })->get(['id', 'start_date_time', 'end_date_time', 'title', 'record_required', 'status', 'approved_by', 'owner_id', 'is_simple', 'flag'])->toArray(); $CaEventsTmp = CAInsideParticipant::where('attendance_id', App::$instance->tbId)->with(['vks' => function ($query) use($mskTime) { $query->where('start_date_time', $mskTime)->whereIn('status', [VKS_STATUS_APPROVED]); }])->get(['vks_id']); //add to events container $CaEvents = []; foreach ($CaEventsTmp as $CAVks) { if ($CAVks->vks) { $CAVks->vks->fromCa = true; $CAVks->vks->tbFlag = $CaNotes->checkFlag($CAVks->vks->id); $CAVks->vks->start_date_time = $CAVks->vks->start_date_time instanceof DateTime ? $CAVks->vks->start_date_time : date_create($CAVks->vks->start_date_time); $CAVks->vks->end_date_time = $CAVks->vks->end_date_time instanceof DateTime ? $CAVks->vks->end_date_time : date_create($CAVks->vks->end_date_time); if ($CAVks->vks->tbFlag) {
public function showSchedule($showType, $date, $attendance_id) { try { $attendance = Attendance::findOrFail($attendance_id); } catch (Exception $e) { $this->error('404'); } $filename = NODE_REAL_PATH . 'storage/user_' . md5(App::$instance->user->ip) . '.txt'; if (is_file($filename)) { $last_seen_stored = json_decode(file_get_contents($filename), JSON_PRETTY_PRINT); } else { $last_seen_stored = array(); } // if (isset($_COOKIE['last_seen_stored'])) { // $last_seen_stored = json_decode($_COOKIE['last_seen_stored'], JSON_PRETTY_PRINT); // } else { // $last_seen_stored = array(); // } $last_seen = $last_seen_stored; //to view $last_seen = array_reverse($last_seen); if (count($last_seen_stored) > 15) { array_shift($last_seen_stored); } $key = array_search($attendance->toArray(), $last_seen_stored); if (is_numeric($key)) { unset($last_seen_stored[$key]); } array_push($last_seen_stored, $attendance->toArray()); // setrawcookie('last_seen_stored', json_encode($last_seen_stored, JSON_FORCE_OBJECT), 60 * 60 * 24 * 90); file_put_contents($filename, json_encode($last_seen_stored)); if ($showType == self::SHOW_SCHEDULE_AS_LIST) { $vc = new Vks_controller(); $start = date_create($date)->setTime(0, 0); $end = date_create($date)->setTime(23, 59); $requested_participant_id = intval($attendance_id); $vkses = Vks::where('start_date_time', ">=", $start)->where('start_date_time', '<=', $end)->whereIn('status', [VKS_STATUS_PENDING, VKS_STATUS_APPROVED])->notSimple()->with('participants', 'connection_codes')->orderBy("start_date_time", 'desc')->get(); $filtered_vkses = array(); if (count($vkses)) { foreach ($vkses as $vks) { if (count($vks->participants)) { foreach ($vks->participants as $participant) { if ($participant->id === $requested_participant_id) { $filtered_vkses[] = $vc->humanize($vks); } } } } } return $this->render('attendance/schedule_list', compact('attendance', 'filtered_vkses', 'date', 'last_seen')); } else { return $this->render('attendance/schedule_graph', compact('date', 'attendance', 'last_seen')); } }
public function hasLocalVks($caVksId) { $result = Vks::where('link_ca_vks_id', $caVksId)->count(); if (ST::isAjaxRequest()) { print json_encode($result ? ['response' => 1] : ['response' => 0]); } else { return $result; } }