62 lines
2.1 KiB
PHP
62 lines
2.1 KiB
PHP
<?php
|
|
|
|
$baseData = [
|
|
['sn' => 'VSOL00addd35', 'name' => 'ARTINI', 'rx' => -25.5300, 'volt' => 3.24],
|
|
['sn' => 'VSOL00ad1105', 'name' => 'SATRIA PERUM PANGGUNG', 'rx' => -24.3180, 'volt' => 3.26],
|
|
['sn' => 'HWTCa90adda0', 'name' => 'RIDA AGUS', 'rx' => -21.2500, 'volt' => 3.24],
|
|
['sn' => 'HWTCa90add88', 'name' => 'SMP 6 SITUBONDO', 'rx' => -21.4280, 'volt' => 3.26],
|
|
['sn' => 'HWTCa90aaf00', 'name' => 'BASRIYADI', 'rx' => -21.1360, 'volt' => 3.26],
|
|
['sn' => 'HWTCd1b3aa28', 'name' => 'IRWAN', 'rx' => -22.0780, 'volt' => 3.28],
|
|
['sn' => 'HWTCa90a4760', 'name' => 'TEGUH ADI', 'rx' => -21.0240, 'volt' => 3.24],
|
|
['sn' => 'CDTCaf8e7bf1', 'name' => 'MALD/H1/1/3/13', 'rx' => -22.4420, 'volt' => 3.30],
|
|
['sn' => 'HWTCa90aaed8', 'name' => 'FENTI', 'rx' => -21.4280, 'volt' => 3.28],
|
|
['sn' => 'HWTCa90aabf8', 'name' => 'DESY/SUPARJO', 'rx' => -22.2920, 'volt' => 3.28],
|
|
['sn' => 'HWTCa90addb0', 'name' => 'AYANG', 'rx' => -20.6060, 'volt' => 3.22],
|
|
];
|
|
|
|
$dates = [];
|
|
for ($d = 12; $d <= 19; $d++) {
|
|
$dates[] = "2026-06-" . str_pad($d, 2, "0", STR_PAD_LEFT);
|
|
}
|
|
|
|
$sql = "";
|
|
|
|
foreach ($dates as $date) {
|
|
foreach ($baseData as $row) {
|
|
|
|
// 🔥 variasi biar realistis (fluktuasi kecil)
|
|
$rx = $row['rx'] + rand(-80, 80) / 1000; // ±0.08 dBm
|
|
$volt = $row['volt'] + rand(-5, 5) / 1000; // ±0.005 V
|
|
|
|
$sample = rand(6, 12);
|
|
|
|
$min_rx = $rx - rand(5, 20) / 1000;
|
|
$max_rx = $rx + rand(5, 20) / 1000;
|
|
|
|
$min_v = $volt - rand(1, 5) / 1000;
|
|
$max_v = $volt + rand(1, 5) / 1000;
|
|
|
|
$sql .= "INSERT INTO onu_daily_history
|
|
(sn, ont_name, rx_power, voltage, min_rx, max_rx, min_voltage, max_voltage, last_cause, sample_count, log_date, created_at, updated_at)
|
|
VALUES
|
|
(
|
|
'{$row['sn']}',
|
|
'{$row['name']}',
|
|
" . round($rx, 4) . ",
|
|
" . round($volt, 3) . ",
|
|
" . round($min_rx, 4) . ",
|
|
" . round($max_rx, 4) . ",
|
|
" . round($min_v, 3) . ",
|
|
" . round($max_v, 3) . ",
|
|
NULL,
|
|
{$sample},
|
|
'{$date}',
|
|
'{$date} 08:00:00',
|
|
'{$date} 17:00:00'
|
|
);\n\n";
|
|
}
|
|
}
|
|
|
|
file_put_contents("onu_history_12_19_june.sql", $sql);
|
|
|
|
echo "DONE: file SQL berhasil dibuat"; |