foreach ($clocks as $keyClock => $clock) {
$cmd->logs->info("[Neutralidad-2] Creando reporte {$clock}", false, 'logs_neutralidad');
//Limpiar Tabla Neutralidad
$cmd->conexion->query("DELETE FROM `bm_neutralidad` WHERE clock='{$clock}'");
$cmd->conexion->query('INSERT INTO `bm_neutralidad` (`id_item`,`clock`) SELECT `id_item`,"' . $clock . '" FROM `bm_neutralidad_item`');
$get_plantes_sql = "SELECT P.`id_plan`, P.`plan`, P.`nacD`, P.`locD`, P.`intD`, P.`nacU`, P.`locU`, P.`intU`\r\nFROM `bm_plan` P \r\n\tLEFT JOIN `bm_plan_groups` PG USING(`id_plan`) \r\n\tLEFT JOIN `bm_host_groups` HG ON HG.`groupid`=PG.`groupid`\r\nWHERE HG.`type`='NEUTRALIDAD';";
$get_plantes = $cmd->conexion->queryFetch($get_plantes_sql);
foreach ($get_plantes as $keyPlan => $qos_data) {
$plan = str_replace("-", "", $qos_data["plan"]);
CreateVel($plan, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['nacD'], $clock, 'NACBandwidthdown', 102, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['locD'], $clock, 'LOCBandwidthdown', 202, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['intD'], $clock, 'INTBandwidthdown', 302, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['nacU'], $clock, 'NACBandwidthup', 107, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['locU'], $clock, 'LOCBandwidthup', 207, $cmd);
vel_correct($qos_data['id_plan'], $plan, $qos_data['intU'], $clock, 'INTBandwidthup', 307, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'NACBandwidthdown', 100, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'LOCBandwidthdown', 200, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'INTBandwidthdown', 300, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'NACBandwidthup', 105, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'LOCBandwidthup', 205, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'INTBandwidthup', 305, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'NACPINGavg', 100, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'LOCPINGavg', 200, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'INTPINGavg', 300, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'NACPINGstd', 100, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'LOCPINGstd', 200, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'INTPINGstd', 300, $get_group, $cmd);
}
//Generando CSV
$datos = array();
$clock = $value["clock"];
$clock_file = str_replace("/", "_", $clock);
//Limpiar Tabla Neutralidad
$cmd->conexion->query("DELETE FROM `bm_neutralidad` WHERE clock='{$clock}'");
$cmd->conexion->query('INSERT INTO `bm_neutralidad` (`id_item`,`clock`) SELECT `id_item`,"' . $clock . '" FROM `bm_neutralidad_item`');
$get_plantes_sql = "SELECT P.`id_plan`, P.`plan`\nFROM `bm_plan` P \n\tLEFT JOIN `bm_plan_groups` PG USING(`id_plan`) \n\tLEFT JOIN `bm_host_groups` HG ON HG.`groupid`=PG.`groupid`\nWHERE HG.`type`='NEUTRALIDAD';";
$get_plantes = $cmd->conexion->queryFetch($get_plantes_sql);
foreach ($get_plantes as $keyPlan => $qos_data) {
$plan = str_replace("-", "", $qos_data["plan"]);
CreateVel($plan, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['nacD'], $clock, 'NACbandwidthdown.sh', 102, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['locD'], $clock, 'LOCbandwidthdown.sh', 202, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['intD'], $clock, 'INTbandwidthdown.sh', 302, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['nacU'], $clock, 'NACbandwidthup.sh', 107, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['locU'], $clock, 'LOCbandwidthup.sh', 207, $cmd);
vel_correct($qos_data['id_plan'], $qos_data['intU'], $clock, 'INTbandwidthup.sh', 307, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'NACbandwidthdown.sh', 100, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'LOCbandwidthdown.sh', 200, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'INTbandwidthdown.sh', 300, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'NACbandwidthup.sh', 104, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'LOCbandwidthup.sh', 204, $get_group, $cmd);
fillVel($qos_data['id_plan'], $plan, $clock, 'INTbandwidthup.sh', 304, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'NACping_avg.sh', 100, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'LOCping_avg.sh', 200, $get_group, $cmd);
fillPing($qos_data['id_plan'], $plan, $clock, 'INTping_avg.sh', 300, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'NACping_std.sh', 100, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'LOCping_std.sh', 200, $get_group, $cmd);
fillPingS($qos_data['id_plan'], $plan, $clock, 'INTping_std.sh', 300, $get_group, $cmd);
}
//Generando CSV
$datos = array();
