foreach ($varResult as $type => $valueParam) {
$values[] = "('{$param->clock}', {$groupid}, {$idPlan}, {$idItem}, 'decimal', '{$type}', '{$valueParam}','{$location}')";
}
}
$insertInform = $this->conexion->query($insertInform . join(',', $values), false, 'logs_qoe');
if (!$insertInform) {
$this->logs->error("[QoS] Error al guardar resultado, ", NULL);
return false;
}
$duracion = date("U") - $dateStart;
$this->logs->info("[QoS] Statistics completed in " . $duracion . " seconds for period " . $param->clock);
}
}
$cmd = new Control(true, 'core.bi.node1.baking.cl', true);
/*
$cmd->parametro->remove('STDOUT');
$cmd->parametro->set('STDOUT', true);
$cmd->parametro->remove('DEBUG');
$cmd->parametro->set('DEBUG', true);*/
$cmd->parametro->set('LOGS_FILE', "logs_qoe");
$cmd->logs->info("[QoS] ===============================================");
$cmd->logs->info("[QoS] Starting Statistic Server");
$cmd->logs->info("[QoS] Copyright Baking Software 2013");
$cmd->logs->info("[QoS] Version 3");
$cmd->logs->info("[QoS] ===============================================");
$poller = new ServerQoe($cmd);
$poller->validStart();
$poller->start();
?>
// $this->logs->error("[QoS] Error insert value " , NULL);
// return false;
// }
public function createTMP()
{
$createSQL = "DROP table tableCacheLocation; CREATE TABLE IF NOT EXISTS \n\t\t tableCacheLocation ( INDEX(id_host) ) \n\t\tAS (\n\t\tSELECT H.`id_host` , H.`host`, H.`groupid` ,L.`city` , HD2.city as 'cityf',L.`minTest`, L.`additionalForm`, CONCAT('SDS ', HD2.city ,' (', L.`city`,')') AS 'name'\n\t\t\t FROM `bm_host` H\n\t\t\t\tLEFT OUTER JOIN (SELECT `id_host`, `value` as 'idLocation' FROM `bm_host_detalle` WHERE `id_feature` = 78) HD1 ON ( H.`id_host`=HD1.`id_host`)\n\t\t\t\tLEFT OUTER JOIN (SELECT `id_host`, `value` as 'city' FROM `bm_host_detalle` WHERE `id_feature` = 79) HD2 ON ( H.`id_host`=HD2.`id_host`)\n\t\t\t\tLEFT OUTER JOIN `bm_location` L ON L.`idLocation`=HD1.`idLocation`\n\t\tWHERE `borrado` = 0 AND H.`status` = 1\t\n\t\t)";
$createRESULT = $this->conexion->query($createSQL);
}
}
$cmd = new Control(true, 'core.bi.node1.baking.cl', true);
/*
$cmd->parametro->remove('STDOUT');
$cmd->parametro->set('STDOUT', true);
$cmd->parametro->remove('DEBUG');
$cmd->parametro->set('DEBUG', true);
*
*/
$cmd->parametro->set('LOGS_FILE', "logs_qoe");
$cmd->logs->info("[QoS] ===============================================");
$cmd->logs->info("[QoS] Starting Statistic Server");
$cmd->logs->info("[QoS] Copyright Baking Software 2013");
$cmd->logs->info("[QoS] Version 3");
$cmd->logs->info("[QoS] ===============================================");
$poller = new ServerQoe($cmd);
$poller->validStart();
$poller->start();
$poller->createTMP();
?>
