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