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(); ?>