$getPlanPercentilSQL = "SELECT * FROM `tmp_statsQoS` WHERE `DATE`='" . $param->clock . "' ORDER BY `idItem`,`idPlan`,`groupid`"; $getPlanPercentil = $cmd->conexion->queryFetch($getPlanPercentilSQL); if (!$getPlanPercentil) { $cmd->logs->error("[QoS] Error al obtener los planes a calcular, ", NULL); $cmd->_crontab($var->crontab, "finish"); exit; } $countN = count($getPlanPercentil); $startN = 1; foreach ($getPlanPercentil as $key => $value) { $cmd->basic->timeStart(); $groupid = $value["groupid"]; $id_plan = $value["idPlan"]; $clock = $value["clock"]; $id_item = $value["idItem"]; $percentil = calPercentil($id_item, $id_plan, $clock, $groupid, $param->where, $cmd); if (!isset($percentil[5])) { $percentil[5] = 0; } if (!isset($percentil[80])) { $percentil[80] = 0; } if (!isset($percentil[95])) { $percentil[95] = 0; } $updatePercentil = "UPDATE tmp_statsQoS set PERCENTIL_5=" . $percentil[5] . ",PERCENTIL_95=" . $percentil[95] . ",PERCENTIL_80=" . $percentil[80] . " WHERE groupid=" . $groupid . " AND DATE='" . $param->clock . "'" . " AND idPlan='" . $id_plan . "'" . " AND idItem='" . $id_item . "'"; $cmd->conexion->query($updatePercentil); $duration = $cmd->basic->timeEnd(); $cmd->logs->info("[QoS] Processing statistics " . $clock . " [" . $groupid . "] " . $id_plan . "(" . $startN . " of " . $countN . ") in " . $duration . " seconds"); $startN++; }
$getPlanPercentilSQL = "SELECT * FROM `tmp_statsQoS` WHERE `DATE`='" . $param->clock . "' ORDER BY `groupid`,`idPlan`,`idItem`"; $getPlanPercentil = $cmd->conexion->queryFetch($getPlanPercentilSQL); if (!$getPlanPercentil) { $cmd->logs->error("[QoS] Error al obtener los planes a calcular, ", NULL); $cmd->_crontab($var->crontab, "finish"); exit; } $countN = count($getPlanPercentil); $startN = 1; foreach ($getPlanPercentil as $key => $value) { $cmd->basic->timeStart(); $groupid = $value["groupid"]; $idPlan = $value["idPlan"]; $iditem = $value["idItem"]; $location = $value["location"]; $percentil = calPercentil($iditem, $idPlan, $groupid, $location, $param->where, $cmd); $PercentilArray = array(); foreach ($percentil as $pkey => $pvalue) { $PercentilArray[] = "`PERCENTIL_{$pkey}`='" . $pvalue . "'"; } $updatePercentil = "UPDATE tmp_statsQoS SET " . join(',', $PercentilArray) . " WHERE groupid=" . $groupid . " AND DATE='" . $param->clock . "'" . " AND idPlan='" . $idPlan . "'" . " AND idItem='{$iditem}'" . " AND location='{$location}'"; $cmd->conexion->query($updatePercentil); $duration = $cmd->basic->timeEnd(); $cmd->logs->info("[QoS] Processing statistics " . $param->clock . " [" . $groupid . "] " . $idPlan . "(" . $startN . " of " . $countN . ") in " . $duration . " seconds"); $startN++; } $getPlanPercentilSQL = "SELECT * FROM `tmp_statsQoS` WHERE `DATE`='" . $param->clock . "' ORDER BY `groupid`,`idPlan`,`idItem`"; $getPlanPercentil = $cmd->conexion->queryFetch($getPlanPercentilSQL); if (!$getPlanPercentil) { $cmd->logs->error("[QoS] Error al obtener los planes a calcular, ", NULL); $cmd->_crontab($var->crontab, "finish");