PHP calPercentil Examples

Example #1

File: qosNew.php Project: rafaelurrutia/bmonitor-y-bi

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

Example #2

File: qos.php Project: rafaelurrutia/bmonitor-y-bi

$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");