public function showSimpleCodes($date)
{
$date = date_create($date);
$sc = new Settings_controller();
$codes = $sc->getSimpleVksCodeParams();
$codeRange = range(floatval($codes->code['start']), floatval($codes->code['end']));
$rangeStringed = [];
foreach ($codeRange as $code) {
$rangeStringed[] = (string) $code;
}
if (count($rangeStringed)) {
$vkses = Vks::simple()->where('date', $date)->with(['connection_codes' => function ($query) use($rangeStringed) {
$query->whereIn('value', $rangeStringed);
}])->get();
$collected = [];
foreach ($rangeStringed as $code) {
$collected[$code] = [];
foreach ($vkses as $vks) {
foreach ($vks->connection_codes as $code_vk) {
$code_vk->value == $code ? $collected[$code][] = $vks : false;
}
}
}
$date = $date->format('d.m.Y');
$this->render('Dashboards/showSimpleCodes', compact('collected', 'date'));
} else {
die('range is corrupted');
}
}
public function apiGetCodesInUse()
{
//post data get
$start_date = $this->request->request->get("start_date");
$end_date = $this->request->request->get("end_date");
if (!$start_date || !$end_date) {
return print new Response('params has wrong names', Response::HTTP_FAILED_DEPENDENCY);
}
try {
$start = date_create($start_date)->format("Y-m-d H:i");
$end = date_create($end_date)->format("Y-m-d H:i");
} catch (Exception $e) {
return print new Response('params can\'t be converted to dates', Response::HTTP_CONFLICT);
}
if (date_create($start_date) > date_create($end_date)) {
return print new Response('start bigger than end', Response::HTTP_FAILED_DEPENDENCY);
}
$sc = new Settings_controller();
$connCtrl = new ConnectionCode_controller();
$codesLoadSet = [];
foreach ($sc->getCodesPostfixSet() as $postfixCode) {
$vksSearch = $connCtrl->isCodeInUse($postfixCode, $start, $end, true);
$codesLoadSet[] = array('code' => $postfixCode, 'usage' => isset($vksSearch->id) ? ST::linkToVksPage($vksSearch->id, true) : false);
}
print json_encode($codesLoadSet, JSON_PRETTY_PRINT);
}
public function apiSearchFastTree($phrase, $except = [], $dateTimeforCheck = [])
{
if (!is_array($except) && strlen($except) > 0) {
$except = explode(",", $except);
}
if (!is_array($except) && strlen($except) > 0) {
$except = explode(",", $except);
}
$strict_option = intval(Settings_controller::getOther('attendance_strict'));
$result = [];
$points = Attendance::where("name", "like", "%" . $phrase . "%")->where('active', 1)->whereNotIn("id", $except)->take(500)->get();
foreach ($points as $point) {
$point->free = true;
$point->selectable = true;
$point->path = $this->makePathString($this->fullParentInfo($point->id));
if ($point->container) {
$result['containers'][] = $point;
} else {
if ($point->check) {
if (count($dateTimeforCheck)) {
foreach ($dateTimeforCheck as $dateTimeArr) {
$start = date_create($dateTimeArr['date'] . " " . $dateTimeArr['start_time']);
$end = date_create($dateTimeArr['date'] . " " . $dateTimeArr['end_time']);
// dump($point->id, $start, $end);
$check = $this->isFree($point->id, $start, $end);
// die;
if (!$check) {
$point->free = false;
if ($strict_option) {
if (!Auth::isAdmin(App::$instance)) {
$point->selectable = false;
}
}
break;
}
}
}
}
$result['points'][] = $point;
}
}
print json_encode($result);
}
private function getServerCapacity($serverNum)
{
$settings = new Settings_controller();
return $settings->getServerParam($serverNum)['capacity'];
}
function showNaVks($id)
{
$versionCtrl = new VksVersion_controller();
$load = new Load_controller();
$sc = new Settings_controller();
try {
$vks = Vks::NotSimple()->full()->findOrFail($id);
} catch (Exception $e) {
$this->error('404', $e->getMessage());
}
$vks = $this->humanize($vks);
$att = new AttendanceNew_controller();
$check = boolval(intval(Settings_controller::getOther("attendance_check_enable")));
foreach ($vks->participants as $parp) {
if ($check) {
$parp->free = $att->isFree($parp->id, $vks->start_date_time, $vks->end_date_time, [$vks->id]);
} else {
$parp->free = true;
}
}
if (!self::isVksCanBeApproved($vks)) {
$this->error('500', 'Открыть экран согласования по этой ВКС невозможно, переведите эту ВКС в статус "на согласовании" и попробуйте еще раз');
}
$vks->isPassebByCapacity = $load->isPassedByCapacity($vks->start_date_time, $vks->end_date_time, $this->countParticipants($vks->id), 0);
$caVks = Null;
if ($vks->link_ca_vks_id) {
if ($vks->link_ca_vks_type == 0) {
$caVks = Curl::get(ST::routeToCaApi('getVksWasById/' . $vks->link_ca_vks_id));
} else {
$caVks = Curl::get(ST::routeToCaApi('getVksNsById/' . $vks->link_ca_vks_id));
}
$caVks = json_decode($caVks);
if ($caVks->status == 200) {
$caVks = $caVks->data;
} else {
$caVks = Null;
}
}
$codes = $sc->getCodeDelivery(true);
$versions = $versionCtrl->getVersionsList($vks->id);
$last_version = null;
if (count($versions)) {
$last_version = $versionCtrl->pullVersion($vks->id, $versionCtrl->findLastVersion($vks->id));
}
if ($vks->stack) {
foreach ($vks->stack->vkses as $stVks) {
$this->humanize($stVks);
$stVks->connection_codes = $stVks->connection_codes()->get();
}
}
if ($vks->other_tb_required) {
$vks->CaInPlaceParticipantCount;
$vks->CaIdParticipants;
}
$codesFiltrated = array();
$ca_pool_codes = App::$instance->callService("vks_ca_negotiator")->askForPool();
$currentVksStart = clone $vks->start_date_time;
$currentVksEnd = clone $vks->end_date_time;
if (count($ca_pool_codes)) {
$ca_transport_vkses = App::$instance->callService("vks_ca_negotiator")->aksTransportVksInPeriod($currentVksStart, $currentVksEnd, $ca_pool_codes);
foreach ($ca_pool_codes as $code) {
$codesFiltrated[$code] = array();
if (count($ca_transport_vkses)) {
foreach ($ca_transport_vkses as $ca_tr_vks) {
if ($code == $ca_tr_vks->v_room_num) {
$codesFiltrated[$code][] = $ca_tr_vks;
}
}
}
}
}
$graph = $load->pullLoadDataForJs($vks->humanized->date);
$this->render('vksSubmissions/approvePage', compact('vks', 'graphUrl', 'caVks', 'versions', 'codes', 'last_version', 'graph', 'codesFiltrated'));
}
