';
if (!empty($chartData)) {
$row = $chartData[0];
$statusBars = [
['label' => 'Emas', 'value' => $row['petak_emas'], 'color' => '#d4af37'],
['label' => 'Hijau', 'value' => $row['petak_hijau'], 'color' => '#27ae60'],
['label' => 'Kuning', 'value' => $row['petak_kuning'], 'color' => '#f39c12'],
['label' => 'Merah', 'value' => $row['petak_merah'], 'color' => '#e74c3c'],
['label' => 'Hitam', 'value' => $row['petak_hitam'], 'color' => '#2c3e50']
];
$html .= '
';
}
return response()->json([
'status' => 'success',
'data' => $chartData,
'html' => $html
]);
}
function getPemupukanData(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$umur = $request->get('umur');
$params = [$cluster, $kebun, $rayon, $tgl, $umur];
$results = \DB::select('CALL sp_pica_dashboard_2_pemupukan(?, ?, ?, ?, ?)', $params);
$chartData = [];
$total = 0;
foreach ($results as $row) {
$pupuk_1_tepat_waktu = isset($row->pupuk_1_tepat_waktu) ? (int)$row->pupuk_1_tepat_waktu : 0;
$pupuk_1_terlambat = isset($row->pupuk_1_terlambat) ? (int)$row->pupuk_1_terlambat : 0;
$subtotal = $pupuk_1_tepat_waktu + $pupuk_1_terlambat;
$total += $subtotal;
$chartData[] = [
'pupuk_1_tepat_waktu' => $pupuk_1_tepat_waktu,
'pupuk_1_terlambat' => $pupuk_1_terlambat,
'total' => $subtotal
];
}
$html = '
';
$html .= '
Pemupukan 1 (Ha)
';
if (!empty($chartData)) {
$row = $chartData[0];
$statusBars = [
['label' => 'Tepat Waktu', 'value' => $row['pupuk_1_tepat_waktu'], 'color' => '#27ae60'],
['label' => 'Terlambat', 'value' => $row['pupuk_1_terlambat'], 'color' => '#e74c3c']
];
$html .= '
';
foreach ($statusBars as $status) {
$percentage = $total > 0 ? ($status['value'] / $total) * 100 : 0;
$html .= '
';
$html .= round($percentage, 1) . '%';
$html .= '
';
}
$html .= '
';
$html .= '
';
foreach ($statusBars as $status) {
$html .= '
';
$html .= '
';
$html .= '
' . $status['label'] . ': ' . number_format($status['value'], 0, ',', '.') . '';
$html .= '
';
}
$html .= '
';
}
return response()->json([
'status' => 'success',
'data' => $results,
'html' => $html
]);
}
function getTableParameterPemeliharaan(Request $request)
{
$tahun = date('Y');
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$parameter = $request->get('parameter', 'diameter');
$umur = $request->get('umur', '5');
$params = [$tahun, $cluster, $kebun, $parameter, $umur];
$results = \DB::select('CALL sp_pica_dashboard_2_parameter_pemeliharaan(?, ?, ?, ?, ?)', $params);
$html = '';
// Map parameter to display labels
$parameterLabels = [
'diameter' => 'Diameter (mm)',
'tinggi_batang' => 'Tinggi Batang (m)',
'jumlah_batang' => 'Jumlah Batang (per meter)',
'pemupukan_tepat_waktu' => 'Pemupukan Tepat Waktu (%)'
];
$judul = isset($parameterLabels[$parameter]) ? $parameterLabels[$parameter] : ucfirst(str_replace('_', ' ', $parameter));
$html .= '
' . $judul . ' ' . $tahun . '
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Kebun | ';
$html .= 'Jan | ';
$html .= 'Feb | ';
$html .= 'Mar | ';
$html .= 'Apr | ';
$html .= 'Mei | ';
$html .= 'Jun | ';
$html .= 'Jul | ';
$html .= 'Agu | ';
$html .= 'Sep | ';
$html .= 'Okt | ';
$html .= 'Nov | ';
$html .= 'Des | ';
if($parameter === 'pemupukan_tepat_waktu') {
$html .= 'Total | ';
}
$html .= '
';
$html .= '';
$html .= '';
foreach($results as $row) {
$isTotal = stripos($row->nama_rekap, 'total') !== false ? ' class="total-row"' : '';
$html .= '';
$html .= '' . $row->nama_rekap . ' | ';
$html .= '' . ($row->januari ? number_format($row->januari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->februari ? number_format($row->februari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->maret ? number_format($row->maret, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->april ? number_format($row->april, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->mei ? number_format($row->mei, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juni ? number_format($row->juni, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juli ? number_format($row->juli, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->agustus ? number_format($row->agustus, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->september ? number_format($row->september, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->oktober ? number_format($row->oktober, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->november ? number_format($row->november, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->desember ? number_format($row->desember, 2, ',', '.') : '-') . ' | ';
if($parameter === 'pemupukan_tepat_waktu') {
$html .= '' . ($row->total ? number_format($row->total, 2, ',', '.') : '-') . ' | ';
}
$html .= '';
}
$html .= '';
$html .= '
';
return response($html);
}
public function getKuadranKinerjanew(Request $request)
{
$nama_kebun = $request->get('cluster');
$tahun = $request->get('bulan');
$params = [$nama_kebun, $tahun];
$results = \DB::select('CALL kuadran_kinerja_kebun_kso_new(?, ?)', $params);
$html = '';
$html .= '
';
$html .= '
';
$html .= '';
$headers = ['Kebun', 'Target
Produktivitas','Produktivitas
sd Minggu Lalu', 'Produktivitas
sd Minggu Ini', 'Delta
Produktivitas', 'Target
Rendemen','Rendemen
sd Minggu Lalu', 'Rendemen
sd Minggu Ini', 'Delta
Rendemen', 'Target
Pasok Harian','Rata-rata Pasok Harian
sd Minggu Lalu', 'Rata-rata Pasok Harian
sd Minggu Ini', 'Delta
Pasok Harian', 'X Cashcost', 'IPO Protas','IPO Rendemen','IPO Pasok', 'Y IPO
sd Minggu Ini'];
$groupSeparators = [0, 1, 5, 9, 13, 14, 17]; // indices where a group starts (left border)
foreach ($headers as $i => $h) {
$sep = in_array($i, $groupSeparators) && $i > 0 ? ' style="border-left: 2.5px solid rgba(255,255,255,0.35);"' : '';
$html .= '' . $h . '';
}
$html .= '
';
$rowCount = 0;
foreach ($results as $row) {
$rowClass = ($rowCount % 2 === 0) ? 'row-even' : 'row-odd';
$deltaProd = $row->delta_produktivitas ?? 0;
$deltaRend = $row->delta_rendemen ?? 0;
$deltaPasok = $row->delta_pasok_harian ?? 0;
$getDeltaClass = function($val) {
if ($val > 0) return 'td-delta-pos';
if ($val < 0) return 'td-delta-neg';
return 'td-delta-zero';
};
$fmtDelta = function($val, $dec = 2) {
$prefix = $val > 0 ? '▲ ' : ($val < 0 ? '▼ ' : '');
return $prefix . number_format($val, $dec);
};
$html .= '';
$html .= '| ' . htmlspecialchars($row->Kebun ?? '') . ' | ';
$html .= '' . number_format($row->target_produktivitas ?? 0, 2) . ' | ';
$html .= '' . number_format($row->produktivitas_sd_minggu_lalu ?? 0, 2) . ' | ';
$html .= '' . number_format($row->produktivitas_sd_minggu_ini ?? 0, 2) . ' | ';
$html .= '' . $fmtDelta($deltaProd) . ' | ';
$html .= '' . number_format($row->target_rendemen ?? 0, 2) . ' | ';
$html .= '' . number_format($row->rendemen_sd_minggu_lalu ?? 0, 2) . ' | ';
$html .= '' . number_format($row->rendemen_sd_minggu_ini ?? 0, 2) . ' | ';
$html .= '' . $fmtDelta($deltaRend) . ' | ';
$html .= '' . number_format($row->target_pasok_harian ?? 0, 2) . ' | ';
$html .= '' . number_format($row->rata2_pasok_harian_sd_minggu_lalu ?? 0, 2) . ' | ';
$html .= '' . number_format($row->rata2_pasok_harian_sd_minggu_ini ?? 0, 2) . ' | ';
$html .= '' . $fmtDelta($deltaPasok) . ' | ';
$html .= '' . number_format($row->x_cashcost ?? 0, 0) . ' | ';
$html .= '' . number_format($row->ipo_protas ?? 0, 2) . ' | ';
$html .= '' . number_format($row->ipo_rendemen ?? 0, 2) . ' | ';
$html .= '' . number_format($row->ipo_pasok ?? 0, 2) . ' | ';
$html .= '' . number_format($row->y_ipo_sd_minggu_ini ?? 0, 2) . ' | ';
$html .= '
';
$rowCount++;
}
$html .= '
';
$html .= '
';
$setting = \DB::table('setting_kuadran_kinerja')->where('id', 1)->first();
return response()->json([
'html' => $html,
'setting' => [
'xMin' => isset($setting->xMin) ? (float)$setting->xMin : 0.0,
'xMax' => isset($setting->xMax) ? (float)$setting->xMax : 0.0,
'yMin' => isset($setting->yMin) ? (float)$setting->yMin : 0.0,
'yMax' => isset($setting->yMax) ? (float)$setting->yMax : 0.0,
'cashCostMid' => isset($setting->cashCostMid) ? (float)$setting->cashCostMid : 0.0,
'ipoMid' => isset($setting->ipoMid) ? (float)$setting->ipoMid : 0.0
]
]);
}
public function getDashboardMutu(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$params = [$cluster, $kebun, $rayon, $tgl];
$results = \DB::select('CALL sp_pica_dashboard_1_mutu(?, ?, ?, ?)', $params);
$mutuData = [];
$totalMutu = 0;
foreach ($results as $row) {
$mutuA = isset($row->mutu_A) ? (int)$row->mutu_A : 0;
$mutuB = isset($row->mutu_B) ? (int)$row->mutu_B : 0;
$mutuC = isset($row->mutu_C) ? (int)$row->mutu_C : 0;
$mutuD = isset($row->mutu_D) ? (int)$row->mutu_D : 0;
$mutuE = isset($row->mutu_E) ? (int)$row->mutu_E : 0;
$mutuF = isset($row->mutu_F) ? (int)$row->mutu_F : 0;
$mutuG = isset($row->mutu_G) ? (int)$row->mutu_G : 0;
$subtotal = $mutuA + $mutuB + $mutuC + $mutuD + $mutuE + $mutuF + $mutuG;
$totalMutu += $subtotal;
$mutuData[] = [
'blok' => $row->blok ?? 'N/A',
'mutu_A' => $mutuA,
'mutu_B' => $mutuB,
'mutu_C' => $mutuC,
'mutu_D' => $mutuD,
'mutu_E' => $mutuE,
'mutu_F' => $mutuF,
'mutu_G' => $mutuG,
'total' => $subtotal
];
}
$html = '
';
$html .= '
Mutu Tebu (Ton)
';
if (!empty($mutuData)) {
$row = $mutuData[0];
$statusBars = [
['label' => 'Mutu A', 'value' => $row['mutu_A'], 'color' => '#27ae60'],
['label' => 'Mutu B', 'value' => $row['mutu_B'], 'color' => '#3498db'],
['label' => 'Mutu C', 'value' => $row['mutu_C'], 'color' => '#f39c12'],
['label' => 'Mutu D', 'value' => $row['mutu_D'], 'color' => '#e67e22'],
['label' => 'Mutu E', 'value' => $row['mutu_E'], 'color' => '#e74c3c'],
['label' => 'Mutu F', 'value' => $row['mutu_F'], 'color' => '#c0392b'],
['label' => 'Mutu G', 'value' => $row['mutu_G'], 'color' => '#2c3e50']
];
$html .= '
';
foreach ($statusBars as $status) {
$percentage = $totalMutu > 0 ? ($status['value'] / $totalMutu) * 100 : 0;
$html .= '
';
// if ($percentage > 5) {
$html .= round($percentage, 1) . '%';
// }
$html .= '
';
}
$html .= '
';
$html .= '
';
foreach ($statusBars as $status) {
$html .= '
';
$html .= '
';
$html .= '
' . $status['label'] . ': ' . number_format($status['value'], 0, ',', '.') . '';
$html .= '
';
}
$html .= '
';
}
$html .= '
';
return response()->json([
'status' => 'success',
'data' => $mutuData,
'html' => $html,
'total' => $totalMutu
]);
}
public function getDashboardKlentek(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$params = [$cluster, $kebun, $rayon, $tgl];
$results = \DB::select('CALL sp_pica_dashboard_1_klentek(?, ?, ?, ?)', $params);
$klentekData = [];
$totalKlentek = 0;
$totalBelumKlentek = 0;
foreach ($results as $row) {
$klentek = isset($row->klentek_1) ? (float)$row->klentek_1 : 0;
$belumKlentek = isset($row->belum_klentek_1) ? (float)$row->belum_klentek_1 : 0;
$subtotal = $klentek + $belumKlentek;
$totalKlentek += $klentek;
$totalBelumKlentek += $belumKlentek;
$klentekData[] = [
'blok' => $row->blok ?? 'N/A',
'klentek_1' => $klentek,
'belum_klentek_1' => $belumKlentek,
'total' => $subtotal
];
}
$html = '
';
$html .= '
Monitoring Klentek (Ha)
';
$grandTotal = $totalKlentek + $totalBelumKlentek;
if ($grandTotal > 0) {
$statusBars = [
['label' => 'Klentek 1', 'value' => $totalKlentek, 'color' => '#27ae60'],
['label' => 'Belum Klentek 1', 'value' => $totalBelumKlentek, 'color' => '#e74c3c']
];
$html .= '
';
foreach ($statusBars as $status) {
$percentage = $grandTotal > 0 ? ($status['value'] / $grandTotal) * 100 : 0;
$html .= '
';
// if ($percentage > 5) {
$html .= round($percentage, 1) . '%';
// }
$html .= '
';
}
$html .= '
';
$html .= '
';
foreach ($statusBars as $status) {
$html .= '
';
$html .= '
';
$html .= '
' . $status['label'] . ': ' . number_format($status['value'], 3, ',', '.') . '';
$html .= '
';
}
$html .= '
';
}
$html .= '
';
return response()->json([
'status' => 'success',
'data' => $klentekData,
'html' => $html,
'total_klentek' => $totalKlentek,
'total_belum_klentek' => $totalBelumKlentek,
'grand_total' => $grandTotal
]);
}
public function getDashboardKesegaran(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$params = [$cluster, $kebun, $rayon, $tgl];
$results = \DB::select('CALL sp_pica_dashboard_1_kesegaran(?, ?, ?, ?)', $params);
$ksegaranData = [];
$total24Jam = 0;
$total24sd48Jam = 0;
$totalLebihdari48Jam = 0;
foreach ($results as $row) {
$jam24 = isset($row->{'<24jam'}) ? (float)$row->{'<24jam'} : 0;
$jam24sd48 = isset($row->{'24sd48jam'}) ? (float)$row->{'24sd48jam'} : 0;
$jamLebihdari48 = isset($row->{'>48jam'}) ? (float)$row->{'>48jam'} : 0;
$subtotal = $jam24 + $jam24sd48 + $jamLebihdari48;
$total24Jam += $jam24;
$total24sd48Jam += $jam24sd48;
$totalLebihdari48Jam += $jamLebihdari48;
$ksegaranData[] = [
'blok' => $row->blok ?? 'N/A',
'<24jam' => $jam24,
'24sd48jam' => $jam24sd48,
'>48jam' => $jamLebihdari48,
'total' => $subtotal
];
}
$html = '
';
$html .= '
Monitoring Kesegaran Tebu (Ton)
';
$grandTotal = $total24Jam + $total24sd48Jam + $totalLebihdari48Jam;
if ($grandTotal > 0) {
$statusBars = [
['label' => '<24 Jam', 'value' => $total24Jam, 'color' => '#27ae60'],
['label' => '24-48 Jam', 'value' => $total24sd48Jam, 'color' => '#f39c12'],
['label' => '>48 Jam', 'value' => $totalLebihdari48Jam, 'color' => '#e74c3c']
];
$html .= '
';
foreach ($statusBars as $status) {
$percentage = $grandTotal > 0 ? ($status['value'] / $grandTotal) * 100 : 0;
$html .= '
';
if ($percentage > 5) {
$html .= round($percentage, 1) . '%';
}
$html .= '
';
}
$html .= '
';
$html .= '
';
foreach ($statusBars as $status) {
$html .= '
';
$html .= '
';
$html .= '
' . $status['label'] . ': ' . number_format($status['value'], 0, ',', '.') . '';
$html .= '
';
}
$html .= '
';
}
$html .= '
';
return response()->json([
'status' => 'success',
'data' => $ksegaranData,
'html' => $html,
'total_24jam' => $total24Jam,
'total_24sd48jam' => $total24sd48Jam,
'total_lebih48jam' => $totalLebihdari48Jam,
'grand_total' => $grandTotal
]);
}
public function getDashboardKlasifikasiProtas(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$params = [$cluster, $kebun, $rayon, $tgl];
$results = \DB::select('CALL sp_pica_dashboard_1_klasifikasi_protas(?, ?, ?, ?)', $params);
$klasifikasiData = [];
$totalDiatas12Bulan = 0;
$total12Bulan = 0;
$total10sd11Bulan = 0;
$total9Bulan = 0;
$totalDibawah9Bulan = 0;
foreach ($results as $row) {
$diatas12 = isset($row->{'diatas 12 Bulan'}) ? (float)$row->{'diatas 12 Bulan'} : 0;
$bulan12 = isset($row->{'12 Bulan'}) ? (float)$row->{'12 Bulan'} : 0;
$bulan10sd11 = isset($row->{'10-11 Bulan'}) ? (float)$row->{'10-11 Bulan'} : 0;
$bulan9 = isset($row->{'9 Bulan'}) ? (float)$row->{'9 Bulan'} : 0;
$dibawah9 = isset($row->{'dibawah 9 Bulan'}) ? (float)$row->{'dibawah 9 Bulan'} : 0;
$subtotal = $diatas12 + $bulan12 + $bulan10sd11 + $bulan9 + $dibawah9;
$totalDiatas12Bulan += $diatas12;
$total12Bulan += $bulan12;
$total10sd11Bulan += $bulan10sd11;
$total9Bulan += $bulan9;
$totalDibawah9Bulan += $dibawah9;
$klasifikasiData[] = [
'diatas_12_bulan' => $diatas12,
'12_bulan' => $bulan12,
'10sd11_bulan' => $bulan10sd11,
'9_bulan' => $bulan9,
'dibawah_9_bulan' => $dibawah9,
'total' => $subtotal
];
}
$html = '
';
$html .= '
Monitoring Umur Tebu Ditebang (Ha)
';
$grandTotal = $totalDiatas12Bulan + $total12Bulan + $total10sd11Bulan + $total9Bulan + $totalDibawah9Bulan;
if ($grandTotal > 0) {
$statusBars = [
['label' => 'Diatas 12 Bulan', 'value' => $totalDiatas12Bulan, 'color' => '#8e44ad'],
['label' => '12 Bulan', 'value' => $total12Bulan, 'color' => '#3498db'],
['label' => '10-11 Bulan', 'value' => $total10sd11Bulan, 'color' => '#27ae60'],
['label' => '9 Bulan', 'value' => $total9Bulan, 'color' => '#f39c12'],
['label' => 'Dibawah 9 Bulan', 'value' => $totalDibawah9Bulan, 'color' => '#e74c3c']
];
$html .= '
';
foreach ($statusBars as $status) {
$percentage = $grandTotal > 0 ? ($status['value'] / $grandTotal) * 100 : 0;
$html .= '
';
// if ($percentage > 5) {
$html .= round($percentage, 1) . '%';
// }
$html .= '
';
}
$html .= '
';
$html .= '
';
foreach ($statusBars as $status) {
$html .= '
';
$html .= '
';
$html .= '
' . $status['label'] . ': ' . number_format($status['value'], 2, ',', '.') . '';
$html .= '
';
}
$html .= '
';
}
$html .= '
';
return response()->json([
'status' => 'success',
'data' => $klasifikasiData,
'html' => $html,
'total_diatas_12_bulan' => $totalDiatas12Bulan,
'total_12_bulan' => $total12Bulan,
'total_10sd11_bulan' => $total10sd11Bulan,
'total_9_bulan' => $total9Bulan,
'total_dibawah_9_bulan' => $totalDibawah9Bulan,
'grand_total' => $grandTotal
]);
}
public function getStatisticsMasterKebun(Request $request)
{
$results = \DB::table('master_kebun_kso_pica')
->selectRaw('COUNT(DISTINCT cluster) AS total_cluster')
->selectRaw('COUNT(DISTINCT kode_kebun) AS total_kebun')
->selectRaw('SUM(luas_ha) AS total_luas_ha')
->where('kode_kebun', 'LIKE', 'SK%')
->first();
return response()->json([
'total_cluster' => (int)($results->total_cluster ?? 0),
'total_kebun' => (int)($results->total_kebun ?? 0),
'total_luas_ha' => (float)($results->total_luas_ha ?? 0)
]);
}
public function getStatisticsMasterPG(Request $request)
{
$results = \DB::table('master_kebun_kso_pica')
->selectRaw('COUNT(DISTINCT cluster) AS total_cluster')
->selectRaw('COUNT(DISTINCT kode_kebun) AS total_kebun')
->selectRaw('SUM(luas_ha) AS total_luas_ha')
->where('kode_kebun', 'LIKE', 'SG%')
->first();
return response()->json([
'total_cluster' => (int)($results->total_cluster ?? 0),
'total_kebun' => (int)($results->total_kebun ?? 0),
'total_luas_ha' => (float)($results->total_luas_ha ?? 0)
]);
}
public function getTableMasterKebun(Request $request)
{
$results = \DB::table('master_kebun_kso_pica')
->select('id', 'jawa_luarjawa', 'cluster', 'kode_kebun', 'kebun', 'alamat_kebun', 'luas_ha')
->where('kode_kebun', 'LIKE', 'SK%')
->orderBy('id')
->get();
$html = '
';
$html .= '';
$headers = ['No', 'Jawa/Luar Jawa', 'Cluster', 'Kode Kebun', 'Kebun', 'Alamat Kebun', 'Luas (Ha)'];
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$total_luas = 0.0;
foreach ($results as $row) {
$html .= '';
$html .= '| ' . htmlspecialchars($row->id ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->jawa_luarjawa ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->alamat_kebun ?? '') . ' | ';
$luas = isset($row->luas_ha) ? (float)$row->luas_ha : 0.0;
$html .= '' . number_format($luas, 3) . ' | ';
$html .= '
';
$total_luas += $luas;
}
// Total row
$html .= '';
$html .= '| Total | ';
$html .= '' . number_format($total_luas, 3) . ' | ';
$html .= '
';
$html .= '
';
return response($html);
}
public function getTableMasterPG(Request $request)
{
$results = \DB::table('master_kebun_kso_pica')
->select('id', 'jawa_luarjawa', 'cluster', 'kode_kebun', 'kebun', 'alamat_kebun', 'luas_ha')
->where('kode_kebun', 'LIKE', 'SG%')
->orderBy('id')
->get();
$html = '
';
$html .= '';
$headers = ['No', 'Jawa/Luar Jawa', 'Cluster', 'Kode PG', 'Pabrik Gula', 'Alamat PG', 'Luas (Ha)'];
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$total_luas = 0.0;
foreach ($results as $row) {
$html .= '';
$html .= '| ' . htmlspecialchars($row->id ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->jawa_luarjawa ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->alamat_kebun ?? '') . ' | ';
$luas = isset($row->luas_ha) ? (float)$row->luas_ha : 0.0;
$html .= '' . number_format($luas, 3) . ' | ';
$html .= '
';
$total_luas += $luas;
}
// Total row
$html .= '';
$html .= '| Total | ';
$html .= '' . number_format($total_luas, 3) . ' | ';
$html .= '
';
$html .= '
';
return response($html);
}
public function formtablePicapanenrayonkebun(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Pica Panen Rayon Kebun',
'pageNote' => 'Data Pica Panen Rayon Kebun',
),$this->data);
return view($this->module.'.pica_panen_rayonkebun', $this->data);
}
public function gettablePicapanenrayonkebun(Request $request)
{
config(['app.debug' => true]);
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$params = [$cluster, $kebun, $start_date, $end_date];
$results = \DB::select('CALL sp_pica_panen_rayonkebun(?, ?, ?, ?)', $params);
$params2 = [$cluster, $kebun, $start_date, $end_date];
$results2 = \DB::select('CALL sp_nilai_pica_panen_rayonkebun(?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun', 'Protas'];
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = !empty($kebun) ? 6 : 4;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add NILAI PICA headers first
$html .= 'NILAI PICA | ';
// Add LUAS (Ha) and JUMLAH PETAK headers
$html .= 'LUAS (Ha) | ';
$html .= 'JUMLAH PETAK | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
// For NILAI PICA
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// For LUAS (Ha)
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
// For JUMLAH PETAK
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
// Third row - description row for color categories
$html .= '';
$html .= '| 5 | ';
$html .= '4 | ';
$html .= '3 | ';
$html .= '2 | ';
$html .= '1 | ';
$html .= ' | '; // Total Nilai PICA
$html .= '≥ 100 ton/ha | ';
$html .= '85 ≤ X < 100 ton/ha | ';
$html .= '70 ≤ X < 85 ton/ha | ';
$html .= '60 ≤ X < 70 ton/ha | ';
$html .= '< 60 ton/ha | ';
$html .= ' | '; // Total (Ha)
$html .= '≥ 100 ton/ha | ';
$html .= '85 ≤ X < 100 ton/ha | ';
$html .= '70 ≤ X < 85 ton/ha | ';
$html .= '60 ≤ X < 70 ton/ha | ';
$html .= '< 60 ton/ha | ';
$html .= ' | '; // Total Petak
$html .= '
';
$html .= '';
// Gabungkan results dan results2 berdasarkan cluster, kode_kebun, kebun, kode_rayon, rayon
$nilaiPicaMap = [];
foreach ($results2 as $row2) {
$key = $row2->cluster . '|' . $row2->kode_kebun . '|' . $row2->kebun;
if (isset($row2->kode_rayon) && isset($row2->rayon)) {
$key .= '|' . $row2->kode_rayon . '|' . $row2->rayon;
}
$nilaiPicaMap[$key] = [
'emas_pica' => isset($row2->emas_pica) ? (float)$row2->emas_pica : 0.0,
'hijau_pica' => isset($row2->hijau_pica) ? (float)$row2->hijau_pica : 0.0,
'kuning_pica' => isset($row2->kuning_pica) ? (float)$row2->kuning_pica : 0.0,
'merah_pica' => isset($row2->merah_pica) ? (float)$row2->merah_pica : 0.0,
'hitam_pica' => isset($row2->hitam_pica) ? (float)$row2->hitam_pica : 0.0,
'nilai_pica' => isset($row2->nilai_pica) ? (float)$row2->nilai_pica : 0.0,
];
}
$total_emas_ha = 0.0;
$total_hijau_ha = 0.0;
$total_kuning_ha = 0.0;
$total_merah_ha = 0.0;
$total_hitam_ha = 0.0;
$total_ha = 0.0;
$total_emas_petak = 0;
$total_hijau_petak = 0;
$total_kuning_petak = 0;
$total_merah_petak = 0;
$total_hitam_petak = 0;
$total_petak = 0;
$total_emas_pica = 0.0;
$total_hijau_pica = 0.0;
$total_kuning_pica = 0.0;
$total_merah_pica = 0.0;
$total_hitam_pica = 0.0;
$total_nilai_pica = 0.0;
foreach ($results as $row) {
$emas_ha = isset($row->emas_ha) ? (float)$row->emas_ha : 0.0;
$hijau_ha = isset($row->hijau_ha) ? (float)$row->hijau_ha : 0.0;
$kuning_ha = isset($row->kuning_ha) ? (float)$row->kuning_ha : 0.0;
$merah_ha = isset($row->merah_ha) ? (float)$row->merah_ha : 0.0;
$hitam_ha = isset($row->hitam_ha) ? (float)$row->hitam_ha : 0.0;
$total = isset($row->total_ha) ? (float)$row->total_ha : 0.0;
$emas_petak = isset($row->emas_petak) ? (int)$row->emas_petak : 0;
$hijau_petak = isset($row->hijau_petak) ? (int)$row->hijau_petak : 0;
$kuning_petak = isset($row->kuning_petak) ? (int)$row->kuning_petak : 0;
$merah_petak = isset($row->merah_petak) ? (int)$row->merah_petak : 0;
$hitam_petak = isset($row->hitam_petak) ? (int)$row->hitam_petak : 0;
$total_p = isset($row->total_petak) ? (int)$row->total_petak : 0;
$key = $row->cluster . '|' . $row->kode_kebun . '|' . $row->kebun;
if (isset($row->kode_rayon) && isset($row->rayon)) {
$key .= '|' . $row->kode_rayon . '|' . $row->rayon;
}
$nilaiPica = isset($nilaiPicaMap[$key]) ? $nilaiPicaMap[$key] : [
'emas_pica' => 0.0,
'hijau_pica' => 0.0,
'kuning_pica' => 0.0,
'merah_pica' => 0.0,
'hitam_pica' => 0.0,
'nilai_pica' => 0.0,
];
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . (isset($row->protas) && $row->protas !== 0 ? number_format((float)$row->protas, 2) : '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
// Nilai PICA columns (after Protas)
$html .= '' . ($nilaiPica['emas_pica'] !== 0.0 ? number_format($nilaiPica['emas_pica'], 2) : '') . ' | ';
$html .= '' . ($nilaiPica['hijau_pica'] !== 0.0 ? number_format($nilaiPica['hijau_pica'], 2) : '') . ' | ';
$html .= '' . ($nilaiPica['kuning_pica'] !== 0.0 ? number_format($nilaiPica['kuning_pica'], 2) : '') . ' | ';
$html .= '' . ($nilaiPica['merah_pica'] !== 0.0 ? number_format($nilaiPica['merah_pica'], 2) : '') . ' | ';
$html .= '' . ($nilaiPica['hitam_pica'] !== 0.0 ? number_format($nilaiPica['hitam_pica'], 2) : '') . ' | ';
$html .= '' . ($nilaiPica['nilai_pica'] !== 0.0 ? number_format($nilaiPica['nilai_pica'], 2) : '') . ' | ';
// LUAS (Ha) columns
$html .= '' . ($emas_ha !== 0.0 ? number_format($emas_ha, 3) : '') . ' | ';
$html .= '' . ($hijau_ha !== 0.0 ? number_format($hijau_ha, 3) : '') . ' | ';
$html .= '' . ($kuning_ha !== 0.0 ? number_format($kuning_ha, 3) : '') . ' | ';
$html .= '' . ($merah_ha !== 0.0 ? number_format($merah_ha, 3) : '') . ' | ';
$html .= '' . ($hitam_ha !== 0.0 ? number_format($hitam_ha, 3) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 3) : '') . ' | ';
// JUMLAH PETAK columns
$html .= '' . ($emas_petak !== 0 ? $emas_petak : '') . ' | ';
$html .= '' . ($hijau_petak !== 0 ? $hijau_petak : '') . ' | ';
$html .= '' . ($kuning_petak !== 0 ? $kuning_petak : '') . ' | ';
$html .= '' . ($merah_petak !== 0 ? $merah_petak : '') . ' | ';
$html .= '' . ($hitam_petak !== 0 ? $hitam_petak : '') . ' | ';
$html .= '' . ($total_p !== 0 ? $total_p : '') . ' | ';
$html .= '
';
$total_emas_ha += $emas_ha;
$total_hijau_ha += $hijau_ha;
$total_kuning_ha += $kuning_ha;
$total_merah_ha += $merah_ha;
$total_hitam_ha += $hitam_ha;
$total_ha += $total;
$total_emas_petak += $emas_petak;
$total_hijau_petak += $hijau_petak;
$total_kuning_petak += $kuning_petak;
$total_merah_petak += $merah_petak;
$total_hitam_petak += $hitam_petak;
$total_petak += $total_p;
$total_emas_pica += $nilaiPica['emas_pica'];
$total_hijau_pica += $nilaiPica['hijau_pica'];
$total_kuning_pica += $nilaiPica['kuning_pica'];
$total_merah_pica += $nilaiPica['merah_pica'];
$total_hitam_pica += $nilaiPica['hitam_pica'];
$total_nilai_pica += $nilaiPica['nilai_pica'];
}
$html .= '
';
return response($html);
}
public function formtablePicapemeliharaandiameterrayonkebun(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Pica Pemeliharaan Diameter Rayon Kebun',
'pageNote' => 'Data Pica Pemeliharaan Diameter Rayon Kebun',
),$this->data);
return view($this->module.'.pica_pemeliharaan_diameter_rayonkebun', $this->data);
}
public function gettablePicapemeliharaandiameterrayonkebun(Request $request)
{
config(['app.debug' => true]);
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$rayon = $request->get('rayon', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$umur = $request->get('umur', '');
$params = [$cluster, $kebun, $rayon, $start_date, $end_date, $umur];
$results = \DB::select('CALL sp_pica_pemeliharaan_diameter_rayonkebun(?, ?, ?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun', 'Nilai PICA'];
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = (!empty($kebun) && empty($rayon)) ? 6 : 4;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add LUAS (Ha) and JUMLAH PETAK headers
$html .= 'LUAS (Ha) | ';
$html .= 'JUMLAH PETAK | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
// For LUAS (Ha)
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// For JUMLAH PETAK
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$html .= '';
$total_emas_ha = 0.0;
$total_hijau_ha = 0.0;
$total_kuning_ha = 0.0;
$total_merah_ha = 0.0;
$total_hitam_ha = 0.0;
$total_ha = 0.0;
$total_emas_petak = 0;
$total_hijau_petak = 0;
$total_kuning_petak = 0;
$total_merah_petak = 0;
$total_hitam_petak = 0;
$total_petak = 0;
foreach ($results as $row) {
$emas_ha = isset($row->emas_ha) ? (float)$row->emas_ha : 0.0;
$hijau_ha = isset($row->hijau_ha) ? (float)$row->hijau_ha : 0.0;
$kuning_ha = isset($row->kuning_ha) ? (float)$row->kuning_ha : 0.0;
$merah_ha = isset($row->merah_ha) ? (float)$row->merah_ha : 0.0;
$hitam_ha = isset($row->hitam_ha) ? (float)$row->hitam_ha : 0.0;
$total = isset($row->total_ha) ? (float)$row->total_ha : 0.0;
$emas_petak = isset($row->emas_petak) ? (int)$row->emas_petak : 0;
$hijau_petak = isset($row->hijau_petak) ? (int)$row->hijau_petak : 0;
$kuning_petak = isset($row->kuning_petak) ? (int)$row->kuning_petak : 0;
$merah_petak = isset($row->merah_petak) ? (int)$row->merah_petak : 0;
$hitam_petak = isset($row->hitam_petak) ? (int)$row->hitam_petak : 0;
$total_p = isset($row->total_petak) ? (int)$row->total_petak : 0;
$nilai_pica_index = isset($row->nilai_pica_index) ? (float)$row->nilai_pica_index : 0.0;
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . ($nilai_pica_index !== 0.0 ? number_format($nilai_pica_index, 2) : '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
$html .= '' . ($emas_ha !== 0.0 ? number_format($emas_ha, 3) : '') . ' | ';
$html .= '' . ($hijau_ha !== 0.0 ? number_format($hijau_ha, 3) : '') . ' | ';
$html .= '' . ($kuning_ha !== 0.0 ? number_format($kuning_ha, 3) : '') . ' | ';
$html .= '' . ($merah_ha !== 0.0 ? number_format($merah_ha, 3) : '') . ' | ';
$html .= '' . ($hitam_ha !== 0.0 ? number_format($hitam_ha, 3) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 3) : '') . ' | ';
$html .= '' . ($emas_petak !== 0 ? $emas_petak : '') . ' | ';
$html .= '' . ($hijau_petak !== 0 ? $hijau_petak : '') . ' | ';
$html .= '' . ($kuning_petak !== 0 ? $kuning_petak : '') . ' | ';
$html .= '' . ($merah_petak !== 0 ? $merah_petak : '') . ' | ';
$html .= '' . ($hitam_petak !== 0 ? $hitam_petak : '') . ' | ';
$html .= '' . ($total_p !== 0 ? $total_p : '') . ' | ';
$html .= '
';
$total_emas_ha += $emas_ha;
$total_hijau_ha += $hijau_ha;
$total_kuning_ha += $kuning_ha;
$total_merah_ha += $merah_ha;
$total_hitam_ha += $hitam_ha;
$total_ha += $total;
$total_emas_petak += $emas_petak;
$total_hijau_petak += $hijau_petak;
$total_kuning_petak += $kuning_petak;
$total_merah_petak += $merah_petak;
$total_hitam_petak += $hitam_petak;
$total_petak += $total_p;
}
$html .= '
';
return response($html);
}
public function formtableNilaiPicapanenrayonkebun(Request $request)
{
$this->data['pageTitle'] = 'Nilai Pica Panen Rayon Kebun';
$this->data['pageNote'] = 'Data Nilai Pica Panen Rayon Kebun';
return view($this->module.'.nilai_pica_panen_rayonkebun', $this->data);
}
public function gettableNilaiPicapanenrayonkebun(Request $request)
{
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$params = [$cluster, $kebun, $start_date, $end_date];
$results = \DB::select('CALL sp_nilai_pica_panen_rayonkebun(?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun'];
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = !empty($kebun) ? 5 : 3;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add Nilai Pica headers
$html .= 'NILAI PICA | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$html .= '';
$total_emas = 0.0;
$total_hijau = 0.0;
$total_kuning = 0.0;
$total_merah = 0.0;
$total_hitam = 0.0;
$total_nilai = 0.0;
foreach ($results as $row) {
$emas = isset($row->emas_pica) ? (float)$row->emas_pica : 0.0;
$hijau = isset($row->hijau_pica) ? (float)$row->hijau_pica : 0.0;
$kuning = isset($row->kuning_pica) ? (float)$row->kuning_pica : 0.0;
$merah = isset($row->merah_pica) ? (float)$row->merah_pica : 0.0;
$hitam = isset($row->hitam_pica) ? (float)$row->hitam_pica : 0.0;
$total = isset($row->nilai_pica) ? (float)$row->nilai_pica : 0.0;
$isTotalRow = strtoupper(trim($row->kebun ?? '')) === 'GRAND TOTAL';
$rowStyle = $isTotalRow ? 'font-weight:bold;' : '';
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
$html .= '' . ($emas !== 0.0 ? number_format($emas, 2) : '') . ' | ';
$html .= '' . ($hijau !== 0.0 ? number_format($hijau, 2) : '') . ' | ';
$html .= '' . ($kuning !== 0.0 ? number_format($kuning, 2) : '') . ' | ';
$html .= '' . ($merah !== 0.0 ? number_format($merah, 2) : '') . ' | ';
$html .= '' . ($hitam !== 0.0 ? number_format($hitam, 2) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 2) : '') . ' | ';
$html .= '
';
$total_emas += $emas;
$total_hijau += $hijau;
$total_kuning += $kuning;
$total_merah += $merah;
$total_hitam += $hitam;
$total_nilai += $total;
}
$html .= '
';
return response($html);
}
public function formtableCashcostPanen(Request $request)
{
$this->data['pageTitle'] = 'Kuadran PICA - Panen';
$this->data['pageNote'] = '';
return view($this->module.'.cashcost_panen', $this->data);
}
public function gettableCashcostPanen(Request $request)
{
$cluster = $request->get('cluster', '');
$bulan = $request->get('bulan', '');
$params = [$cluster, $bulan];
$results = \DB::select('CALL sp_cashcost_panen(?, ?)', $params);
$html = '
';
$html .= '';
$html .= '';
$headers = ['Nama Cluster', 'Kode Kebun', 'Nama Kebun', 'Bulan', 'Standar Cash Cost
(Exclude Saprodi)', 'Standar Nilai Pica', 'Real Cash Cost
(Exclude Saprodi)', 'Nilai Pica'];
foreach ($headers as $h) {
$html .= '' . $h . ' | ';
}
$html .= '
';
$html .= '';
$total_standar_cashcost = 0.0;
$total_standar_nilai_pica = 0.0;
$total_real_cashcost = 0.0;
$total_nilai_pica = 0.0;
$no = 1;
foreach ($results as $row) {
$standar_cashcost = isset($row->standar_cashcost) ? (float)$row->standar_cashcost : 0.0;
$standar_nilai_pica = isset($row->standar_nilai_pica) ? (float)$row->standar_nilai_pica : 0.0;
$real_cashcost = isset($row->real_cashcost) ? (float)$row->real_cashcost : 0.0;
$nilai_pica = isset($row->nilai_pica) ? (float)$row->nilai_pica : 0.0;
// Alternating row colors
$rowStyle = ($no % 2 == 0) ? 'background-color:#f8f9fa;' : 'background-color:#ffffff;';
// Highlight based on performance
$picaStyle = '';
if ($nilai_pica >= 2.5) {
$picaStyle = 'background-color:#d4edda; color:#155724; font-weight:600;'; // Green for good
} elseif ($nilai_pica < 2.0) {
$picaStyle = 'background-color:#f8d7da; color:#721c24; font-weight:600;'; // Red for poor
}
$html .= '';
$html .= '| ' . htmlspecialchars($row->nama_cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->nama_kebun ?? '') . ' | ';
// Convert month number to name
$bulan_angka = $row->bulan ?? '';
$nama_bulan = '';
if (is_numeric($bulan_angka)) {
$bulan_int = (int)$bulan_angka;
$bulan_names = [
1 => 'Januari', 2 => 'Februari', 3 => 'Maret', 4 => 'April',
5 => 'Mei', 6 => 'Juni', 7 => 'Juli', 8 => 'Agustus',
9 => 'September', 10 => 'Oktober', 11 => 'November', 12 => 'Desember'
];
$nama_bulan = isset($bulan_names[$bulan_int]) ? $bulan_names[$bulan_int] : $bulan_angka;
} else {
$nama_bulan = $bulan_angka;
}
$html .= '' . htmlspecialchars($nama_bulan) . ' | ';
$html .= '' . ($standar_cashcost !== 0.0 ? 'Rp ' . number_format($standar_cashcost, 0, ',', '.') : '-') . ' | ';
$html .= '' . ($standar_nilai_pica !== 0.0 ? number_format($standar_nilai_pica, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($real_cashcost !== 0.0 ? 'Rp ' . number_format($real_cashcost, 0, ',', '.') : '-') . ' | ';
$html .= '' . ($nilai_pica !== 0.0 ? number_format($nilai_pica, 2, ',', '.') : '-') . ' | ';
$html .= '
';
$total_standar_cashcost += $standar_cashcost;
$total_standar_nilai_pica += $standar_nilai_pica;
$total_real_cashcost += $real_cashcost;
$total_nilai_pica += $nilai_pica;
$no++;
}
$html .= '
';
// Prepare data for quadrant chart
$chartData = [];
// Calculate average cashcost for mid-point
$count = count($results);
$avg_cashcost = $count > 0 ? $total_real_cashcost / $count : 0;
foreach ($results as $row) {
$real_cashcost = isset($row->real_cashcost) ? (float)$row->real_cashcost : 0.0;
$nilai_pica = isset($row->nilai_pica) ? (float)$row->nilai_pica : 0.0;
// Determine quadrant based on nilai_pica threshold of 2.5 and cashcost average
$quadrant = '';
if ($nilai_pica >= 2.5 && $real_cashcost <= $avg_cashcost) {
$quadrant = 'Q1'; // High Pica, Low Cost (Best)
} elseif ($nilai_pica >= 2.5 && $real_cashcost > $avg_cashcost) {
$quadrant = 'Q2'; // High Pica, High Cost
} elseif ($nilai_pica < 2.5 && $real_cashcost <= $avg_cashcost) {
$quadrant = 'Q3'; // Low Pica, Low Cost
} else {
$quadrant = 'Q4'; // Low Pica, High Cost (Worst)
}
$chartData[] = [
'kode_kebun' => $row->kode_kebun ?? '',
'nama_kebun' => $row->nama_kebun ?? '',
'real_cashcost' => $real_cashcost,
'nilai_pica' => $nilai_pica,
'quadrant' => $quadrant
];
}
$setting = \DB::table('setting_kuadran_pica')->where('id', 1)->first();
return response()->json([
'html' => $html,
'chartData' => $chartData,
'setting' => [
'xMin' => isset($setting->xMin) ? (float)$setting->xMin : 0.0,
'xMax' => isset($setting->xMax) ? (float)$setting->xMax : 0.0,
'yMin' => isset($setting->yMin) ? (float)$setting->yMin : 0.0,
'yMax' => isset($setting->yMax) ? (float)$setting->yMax : 0.0,
'cashCostMid' => isset($setting->cashCostMid) ? (float)$setting->cashCostMid : 0.0,
'nilaiMid' => isset($setting->nilaiMid) ? (float)$setting->nilaiMid : 0.0
]
]);
}
public function getDataKuadranCashcostPanen(Request $request)
{
try {
// ── 1. Parse parameter ─────────────────────────────────────────────
$dateParam = $request->get('date', date('Y-m-d'));
$cluster = $request->get('cluster', '');
$dt = \DateTime::createFromFormat('Y-m-d', $dateParam);
if (!$dt) {
return response()->json([
'sts' => 'error',
'msg' => "Parameter 'date' harus dalam format YYYY-MM-DD. Contoh: 2026-04-01.",
'data' => null,
]);
}
$tahun = (int) $dt->format('Y');
$bulan = (int) $dt->format('n');
// ── 2. Konstanta kuadran ───────────────────────────────────────────
$x_threshold = 2.5; // Nilai PICA (sumbu x)
$y_threshold = 8500; // Cash Cost tengah (sumbu y, polarity negative)
$x_offset = 0.5;
$y_offset = 500;
$y_min = 0;
$y_max = 25000;
$x_min = 0;
$x_max = 5;
// Definisi kategori
$cat_hijau = [
'id' => 1,
'nama_kategori' => 'Hijau',
'slug' => 'hijau',
'warna' => '#05ed00',
'warna_secondary' => '#018a00',
'warna_text' => '#ffffff',
'desc' => 'PICA baik, Cash Cost rendah (terbaik)',
];
$cat_oranye = [
'id' => 2,
'nama_kategori' => 'Oranye',
'slug' => 'oranye',
'warna' => '#ed9d00',
'warna_secondary' => '#d4a200',
'warna_text' => '#1a1a1a',
'desc' => 'PICA baik, Cash Cost tinggi',
];
$cat_kuning = [
'id' => 3,
'nama_kategori' => 'Kuning',
'slug' => 'kuning',
'warna' => '#eded00',
'warna_secondary' => '#8a8a00',
'warna_text' => '#1a1a1a',
'desc' => 'PICA buruk, Cash Cost rendah',
];
$cat_merah = [
'id' => 4,
'nama_kategori' => 'Merah',
'slug' => 'merah',
'warna' => '#ed0000',
'warna_secondary' => '#8a0000',
'warna_text' => '#ffffff',
'desc' => 'PICA buruk, Cash Cost tinggi (terburuk)',
];
// Urutan slug untuk historical (best → worst), harus sama setiap bulan
$slug_order = ['hijau', 'kuning', 'oranye', 'merah'];
$cat_map = [
'hijau' => $cat_hijau,
'kuning' => $cat_kuning,
'oranye' => $cat_oranye,
'merah' => $cat_merah,
];
// ── 3. Helper: klasifikasi satu baris ke slug kuadran ─────────────
$classify = function ($nilai_pica, $real_cashcost)
use ($x_threshold, $y_threshold) {
$good_x = ($nilai_pica >= $x_threshold);
$good_y = ($real_cashcost < $y_threshold); // polarity negative: rendah = baik
if ($good_x && $good_y) return 'hijau';
if ($good_x && !$good_y) return 'oranye';
if (!$good_x && $good_y) return 'kuning';
return 'merah';
};
// ── 4. Helper: format periode ──────────────────────────────────────
$makePeriod = function (int $y, int $m) {
$last = cal_days_in_month(CAL_GREGORIAN, $m, $y);
$pad = str_pad($m, 2, '0', STR_PAD_LEFT);
return [
'start' => "{$y}-{$pad}-01T00:00:00+07:00",
'end' => "{$y}-{$pad}-{$last}T00:00:00+07:00",
'start_plain' => "{$y}-{$pad}-01",
'end_plain' => "{$y}-{$pad}-{$last}",
];
};
// ── 5. Data bulan ini untuk section ───────────────────────────────
$results = \DB::select('CALL sp_cashcost_panen(?, ?)', [$cluster, $bulan]);
$period = $makePeriod($tahun, $bulan);
$points = [];
foreach ($results as $index => $row) {
$nilai_pica = isset($row->nilai_pica) ? (float) $row->nilai_pica : 0.0;
$real_cashcost = isset($row->real_cashcost) ? (float) $row->real_cashcost : 0.0;
$kode_kebun = $row->kode_kebun ?? ('K' . ($index + 1));
$nama_kebun = $row->nama_kebun ?? $row->nama_cluster ?? '';
$points[] = [
'x' => $nilai_pica,
'y' => $real_cashcost,
'region' => $nama_kebun,
'outputType' => 'Cash Cost vs. Nilai PICA (Masa Panen)',
'periode_start' => $period['start'],
'periode_end' => $period['end'],
'kode_pabrik' => $kode_kebun,
'parameter_id' => $index + 1,
'parameter_slug' => 'cashcost_vs_pica',
'parameter_nickname' => 'Cash Cost',
];
}
// 4 placeholder sudut domain chart (wajib ada persis 4)
$ph_corners = [
['x' => $x_min, 'y' => $y_min],
['x' => $x_min, 'y' => $y_max],
['x' => $x_max, 'y' => $y_min],
['x' => $x_max, 'y' => $y_max],
];
foreach ($ph_corners as $ph) {
$points[] = [
'x' => $ph['x'],
'y' => $ph['y'],
'region' => '',
'outputType' => 'Placeholder',
'periode_start' => $period['start_plain'],
'periode_end' => $period['end_plain'],
'kode_pabrik' => 'placeholder',
'parameter_id' => 0,
'parameter_slug' => 'cashcost_vs_pica',
'parameter_nickname' => 'Cash Cost',
];
}
// ── 6. Bangun sections ─────────────────────────────────────────────
$sections = [
[
'id' => 'cashcost_vs_pica',
'label' => 'Cash Cost',
'icon' => 'CircleDollarSign',
'title' => 'Cash Cost vs. Nilai PICA (Masa Panen)',
'data' => [
'rule' => [
'x_threshold' => $x_threshold,
'y_threshold' => $y_threshold,
'x_offset' => $x_offset,
'y_offset' => $y_offset,
'polarity' => 'negative',
// Q1 top-right setelah flip y = PICA baik + cashcost rendah = hijau
'color_q1' => $cat_hijau,
// Q2 top-left = PICA buruk + cashcost rendah = kuning
'color_q2' => $cat_kuning,
// Q3 bottom-left = PICA buruk + cashcost tinggi = merah (terburuk)
'color_q3' => $cat_merah,
// Q4 bottom-right = PICA baik + cashcost tinggi = oranye
'color_q4' => $cat_oranye,
'desc' => 'Kuadran Cash Cost vs Nilai PICA Masa Panen. '
. 'Sumbu X = Nilai PICA (threshold 2.5), '
. 'Sumbu Y = Real Cash Cost (threshold Rp 8.500, lower is better).',
],
'data' => $points,
],
],
];
// ── 7. Bangun historical (6 bulan terakhir termasuk bulan ini) ─────
$historical = [];
for ($i = 5; $i >= 0; $i--) {
$hist_dt = clone $dt;
$hist_dt->modify("-{$i} month");
$hist_bulan = (int) $hist_dt->format('n');
$hist_tahun = (int) $hist_dt->format('Y');
$date_label = $hist_dt->format('M Y'); // "Apr 2026"
$hist_results = \DB::select('CALL sp_cashcost_panen(?, ?)', [$cluster, $hist_bulan]);
// Kumpulkan kode_kebun per kategori
$buckets_raw = ['hijau' => [], 'kuning' => [], 'oranye' => [], 'merah' => []];
foreach ($hist_results as $row) {
$np = isset($row->nilai_pica) ? (float) $row->nilai_pica : 0.0;
$rc = isset($row->real_cashcost) ? (float) $row->real_cashcost : 0.0;
$kode = trim($row->kode_kebun ?? '');
// Lewati baris tanpa kode atau tanpa data
if ($kode === '' || ($np == 0.0 && $rc == 0.0)) {
continue;
}
$slug = $classify($np, $rc);
$buckets_raw[$slug][] = $kode;
}
// Format bucket sesuai spesifikasi
$data_buckets = [];
foreach ($slug_order as $slug) {
$colors = $cat_map[$slug];
$ids_arr = $buckets_raw[$slug];
if (empty($ids_arr)) {
// Zero records → data harus array kosong []
$data_buckets[] = [
'slug' => $slug,
'warna' => $colors['warna'],
'warna_secondary' => $colors['warna_secondary'],
'warna_text' => $colors['warna_text'],
'data' => [],
];
} else {
// Ada record → data adalah object SectionCountMap
$ids_str = implode(',', $ids_arr);
$data_buckets[] = [
'slug' => $slug,
'warna' => $colors['warna'],
'warna_secondary' => $colors['warna_secondary'],
'warna_text' => $colors['warna_text'],
'data' => [
'cashcost_vs_pica' => [
'ids' => $ids_str,
'count' => count($ids_arr),
],
],
];
}
}
$historical[] = [
'date' => $date_label,
'data' => $data_buckets,
];
}
// ── 8. Return envelope ─────────────────────────────────────────────
return response()->json([
'sts' => 'success',
'msg' => 'OK',
'data' => [
'sections' => $sections,
'historical' => $historical,
],
]);
} catch (\Exception $e) {
return response()->json([
'sts' => 'error',
'msg' => $e->getMessage(),
'data' => null,
]);
}
}
public function gettableKuadranPemeliharaanPicaGrafik(Request $request)
{
config(['app.debug' => true]);
$kebun = $request->get('kebun', NULL);
$kategori = $request->get('kategori', NULL);
$umur = $request->get('umur', '5');
$results = \DB::select('CALL sp_kuadran_pemeliharaan_pica_grafik(?, ?, ?)', [$kebun, $kategori, $umur]);
$html = '
';
$html .= '';
$html .= '';
$headers = ['Kode Kebun', 'Kebun', 'Kategori', 'Umur', 'Rencana Biaya Garap/Ha', 'Realisasi Biaya Garap/Ha', 'Persen Biaya Garap', 'Standar Penyerapan Biaya', 'Standar Nilai PICA', 'Nilai PICA'];
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$html .= '';
$total_rencana = 0.0;
$total_realisasi = 0.0;
$total_persen = 0.0;
$total_standar_biaya = 0.0;
$total_standar_pica = 0.0;
$total_nilai_pica = 0.0;
$no = 1;
foreach ($results as $row) {
$rencana_biaya = isset($row->rencana_biayagarap_perha) ? (float)$row->rencana_biayagarap_perha : 0.0;
$realisasi_biaya = isset($row->realisasi_biayagarap_perha) ? (float)$row->realisasi_biayagarap_perha : 0.0;
$persen_biaya = isset($row->persen_biayagarap) ? (float)$row->persen_biayagarap : 0.0;
$standar_biaya = isset($row->standar_penyerapan_biaya) ? (float)$row->standar_penyerapan_biaya : 0.0;
$standar_pica = isset($row->standar_nilai_pica) ? (float)$row->standar_nilai_pica : 0.0;
$nilai_pica = isset($row->nilai_pica) ? (float)$row->nilai_pica : 0.0;
// Alternating row colors
$rowStyle = ($no % 2 == 0) ? 'background-color:#f8f9fa;' : 'background-color:#ffffff;';
// Highlight based on performance
$picaStyle = '';
if ($nilai_pica >= $standar_pica) {
$picaStyle = 'background-color:#d4edda; color:#155724; font-weight:600;'; // Green for good
} elseif ($nilai_pica < ($standar_pica * 0.8)) {
$picaStyle = 'background-color:#f8d7da; color:#721c24; font-weight:600;'; // Red for poor
}
$html .= '';
$html .= '| ' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kategori ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->umur ?? '') . ' | ';
$html .= '' . ($rencana_biaya !== 0.0 ? 'Rp ' . number_format($rencana_biaya, 0, ',', '.') : '-') . ' | ';
$html .= '' . ($realisasi_biaya !== 0.0 ? 'Rp ' . number_format($realisasi_biaya, 0, ',', '.') : '-') . ' | ';
$html .= '' . ($persen_biaya !== 0.0 ? number_format($persen_biaya, 2, ',', '.') . '%' : '-') . ' | ';
$html .= '' . ($standar_biaya !== 0.0 ? number_format($standar_biaya, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($standar_pica !== 0.0 ? number_format($standar_pica, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($nilai_pica !== 0.0 ? number_format($nilai_pica, 2, ',', '.') : '-') . ' | ';
$html .= '
';
$total_rencana += $rencana_biaya;
$total_realisasi += $realisasi_biaya;
$total_persen += $persen_biaya;
$total_standar_biaya += $standar_biaya;
$total_standar_pica += $standar_pica;
$total_nilai_pica += $nilai_pica;
$no++;
}
// Total row
$html .= '';
$html .= '| TOTAL | ';
$html .= 'Rp ' . number_format($total_rencana, 0, ',', '.') . ' | ';
$html .= 'Rp ' . number_format($total_realisasi, 0, ',', '.') . ' | ';
$html .= '' . number_format($total_persen, 2, ',', '.') . '% | ';
$html .= '' . number_format($total_standar_biaya, 2, ',', '.') . ' | ';
$html .= '' . number_format($total_standar_pica, 2, ',', '.') . ' | ';
$html .= '' . number_format($total_nilai_pica, 2, ',', '.') . ' | ';
$html .= '
';
$html .= '
';
// Prepare data for quadrant chart
$chartData = [];
foreach ($results as $row) {
$nilai_pica = isset($row->nilai_pica) ? (float)$row->nilai_pica : 0.0;
$persen_biaya = isset($row->persen_biayagarap) ? (float)$row->persen_biayagarap : 0.0;
$standar_pica = isset($row->standar_nilai_pica) ? (float)$row->standar_nilai_pica : 0.0;
$standar_penyerapan_biaya = isset($row->standar_penyerapan_biaya) ? (float)$row->standar_penyerapan_biaya : 0.0;
// Determine quadrant based on nilai_pica vs standar and persen_biaya
$quadrant = '';
if ($nilai_pica >= $standar_pica && $persen_biaya >= 80) {
$quadrant = 'Q1'; // High Pica, High Efficiency (Best)
} elseif ($nilai_pica >= $standar_pica && $persen_biaya < 80) {
$quadrant = 'Q2'; // High Pica, Low Efficiency
} elseif ($nilai_pica < $standar_pica && $persen_biaya >= 80) {
$quadrant = 'Q3'; // Low Pica, High Efficiency
} else {
$quadrant = 'Q4'; // Low Pica, Low Efficiency (Worst)
}
$chartData[] = [
'kode_kebun' => $row->kode_kebun ?? '',
'kebun' => $row->kebun ?? '',
'persen_biaya' => $persen_biaya,
'nilai_pica' => $nilai_pica,
'standar_pica' => $standar_penyerapan_biaya,
'quadrant' => $quadrant
];
}
return response()->json([
'html' => $html,
'chartData' => $chartData
]);
}
public function formtablePicapemeliharaanjumlahbatangrayonkebun(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Pica Pemeliharaan Jumlah Batang Rayon Kebun',
'pageNote' => 'Data Pica Pemeliharaan Jumlah Batang Rayon Kebun',
),$this->data);
return view($this->module.'.pica_pemeliharaan_jumlahbatang_rayonkebun', $this->data);
}
public function gettablePicapemeliharaanjumlahbatangrayonkebun(Request $request)
{
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$rayon = $request->get('rayon', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$umur = $request->get('umur', '');
$params = [$cluster, $kebun, $rayon, $start_date, $end_date, $umur];
$results = \DB::select('CALL sp_pica_pemeliharaan_jumlahbatang_rayonkebun(?, ?, ?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun', 'Nilai PICA'];
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = (!empty($kebun) && empty($rayon)) ? 6 : 4;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add LUAS (Ha) and JUMLAH PETAK headers
$html .= 'LUAS (Ha) | ';
$html .= 'JUMLAH PETAK | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
// For LUAS (Ha)
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// For JUMLAH PETAK
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$html .= '';
$total_emas_ha = 0.0;
$total_hijau_ha = 0.0;
$total_kuning_ha = 0.0;
$total_merah_ha = 0.0;
$total_hitam_ha = 0.0;
$total_ha = 0.0;
$total_emas_petak = 0;
$total_hijau_petak = 0;
$total_kuning_petak = 0;
$total_merah_petak = 0;
$total_hitam_petak = 0;
$total_petak = 0;
foreach ($results as $row) {
$emas_ha = isset($row->emas_ha) ? (float)$row->emas_ha : 0.0;
$hijau_ha = isset($row->hijau_ha) ? (float)$row->hijau_ha : 0.0;
$kuning_ha = isset($row->kuning_ha) ? (float)$row->kuning_ha : 0.0;
$merah_ha = isset($row->merah_ha) ? (float)$row->merah_ha : 0.0;
$hitam_ha = isset($row->hitam_ha) ? (float)$row->hitam_ha : 0.0;
$total = isset($row->total_ha) ? (float)$row->total_ha : 0.0;
$emas_petak = isset($row->emas_petak) ? (int)$row->emas_petak : 0;
$hijau_petak = isset($row->hijau_petak) ? (int)$row->hijau_petak : 0;
$kuning_petak = isset($row->kuning_petak) ? (int)$row->kuning_petak : 0;
$merah_petak = isset($row->merah_petak) ? (int)$row->merah_petak : 0;
$hitam_petak = isset($row->hitam_petak) ? (int)$row->hitam_petak : 0;
$total_p = isset($row->total_petak) ? (int)$row->total_petak : 0;
$nilai_pica_index = isset($row->nilai_pica_index) ? (float)$row->nilai_pica_index : 0.0;
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . ($nilai_pica_index !== 0.0 ? number_format($nilai_pica_index, 2) : '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
$html .= '' . ($emas_ha !== 0.0 ? number_format($emas_ha, 3) : '') . ' | ';
$html .= '' . ($hijau_ha !== 0.0 ? number_format($hijau_ha, 3) : '') . ' | ';
$html .= '' . ($kuning_ha !== 0.0 ? number_format($kuning_ha, 3) : '') . ' | ';
$html .= '' . ($merah_ha !== 0.0 ? number_format($merah_ha, 3) : '') . ' | ';
$html .= '' . ($hitam_ha !== 0.0 ? number_format($hitam_ha, 3) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 3) : '') . ' | ';
$html .= '' . ($emas_petak !== 0 ? $emas_petak : '') . ' | ';
$html .= '' . ($hijau_petak !== 0 ? $hijau_petak : '') . ' | ';
$html .= '' . ($kuning_petak !== 0 ? $kuning_petak : '') . ' | ';
$html .= '' . ($merah_petak !== 0 ? $merah_petak : '') . ' | ';
$html .= '' . ($hitam_petak !== 0 ? $hitam_petak : '') . ' | ';
$html .= '' . ($total_p !== 0 ? $total_p : '') . ' | ';
$html .= '
';
$total_emas_ha += $emas_ha;
$total_hijau_ha += $hijau_ha;
$total_kuning_ha += $kuning_ha;
$total_merah_ha += $merah_ha;
$total_hitam_ha += $hitam_ha;
$total_ha += $total;
$total_emas_petak += $emas_petak;
$total_hijau_petak += $hijau_petak;
$total_kuning_petak += $kuning_petak;
$total_merah_petak += $merah_petak;
$total_hitam_petak += $hitam_petak;
$total_petak += $total_p;
}
$html .= '
';
return response($html);
}
public function formtablePicapemeliharaantinggirayonkebun(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Pica Pemeliharaan Tinggi Batang Rayon Kebun',
'pageNote' => 'Data Pica Pemeliharaan Tinggi Batang Rayon Kebun',
),$this->data);
return view($this->module.'.pica_pemeliharaan_tinggi_rayonkebun', $this->data);
}
public function gettablePicapemeliharaantinggirayonkebun(Request $request)
{
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$rayon = $request->get('rayon', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$umur = $request->get('umur', '');
$params = [$cluster, $kebun, $rayon, $start_date, $end_date, $umur];
$results = \DB::select('CALL sp_pica_pemeliharaan_tinggi_rayonkebun(?, ?, ?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun', 'Nilai PICA'];
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = (!empty($kebun) && empty($rayon)) ? 6 : 4;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add LUAS (Ha) and JUMLAH PETAK headers
$html .= 'LUAS (Ha) | ';
$html .= 'JUMLAH PETAK | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
// For LUAS (Ha)
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// For JUMLAH PETAK
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
$html .= '';
$total_emas_ha = 0.0;
$total_hijau_ha = 0.0;
$total_kuning_ha = 0.0;
$total_merah_ha = 0.0;
$total_hitam_ha = 0.0;
$total_ha = 0.0;
$total_emas_petak = 0;
$total_hijau_petak = 0;
$total_kuning_petak = 0;
$total_merah_petak = 0;
$total_hitam_petak = 0;
$total_petak = 0;
foreach ($results as $row) {
$emas_ha = isset($row->emas_ha) ? (float)$row->emas_ha : 0.0;
$hijau_ha = isset($row->hijau_ha) ? (float)$row->hijau_ha : 0.0;
$kuning_ha = isset($row->kuning_ha) ? (float)$row->kuning_ha : 0.0;
$merah_ha = isset($row->merah_ha) ? (float)$row->merah_ha : 0.0;
$hitam_ha = isset($row->hitam_ha) ? (float)$row->hitam_ha : 0.0;
$total = isset($row->total_ha) ? (float)$row->total_ha : 0.0;
$emas_petak = isset($row->emas_petak) ? (int)$row->emas_petak : 0;
$hijau_petak = isset($row->hijau_petak) ? (int)$row->hijau_petak : 0;
$kuning_petak = isset($row->kuning_petak) ? (int)$row->kuning_petak : 0;
$merah_petak = isset($row->merah_petak) ? (int)$row->merah_petak : 0;
$hitam_petak = isset($row->hitam_petak) ? (int)$row->hitam_petak : 0;
$total_p = isset($row->total_petak) ? (int)$row->total_petak : 0;
$nilai_pica_index = isset($row->nilai_pica_index) ? (float)$row->nilai_pica_index : 0.0;
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . ($nilai_pica_index !== 0.0 ? number_format($nilai_pica_index, 2) : '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun) && empty($rayon)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
$html .= '' . ($emas_ha !== 0.0 ? number_format($emas_ha, 3) : '') . ' | ';
$html .= '' . ($hijau_ha !== 0.0 ? number_format($hijau_ha, 3) : '') . ' | ';
$html .= '' . ($kuning_ha !== 0.0 ? number_format($kuning_ha, 3) : '') . ' | ';
$html .= '' . ($merah_ha !== 0.0 ? number_format($merah_ha, 3) : '') . ' | ';
$html .= '' . ($hitam_ha !== 0.0 ? number_format($hitam_ha, 3) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 3) : '') . ' | ';
$html .= '' . ($emas_petak !== 0 ? $emas_petak : '') . ' | ';
$html .= '' . ($hijau_petak !== 0 ? $hijau_petak : '') . ' | ';
$html .= '' . ($kuning_petak !== 0 ? $kuning_petak : '') . ' | ';
$html .= '' . ($merah_petak !== 0 ? $merah_petak : '') . ' | ';
$html .= '' . ($hitam_petak !== 0 ? $hitam_petak : '') . ' | ';
$html .= '' . ($total_p !== 0 ? $total_p : '') . ' | ';
$html .= '
';
$total_emas_ha += $emas_ha;
$total_hijau_ha += $hijau_ha;
$total_kuning_ha += $kuning_ha;
$total_merah_ha += $merah_ha;
$total_hitam_ha += $hitam_ha;
$total_ha += $total;
$total_emas_petak += $emas_petak;
$total_hijau_petak += $hijau_petak;
$total_kuning_petak += $kuning_petak;
$total_merah_petak += $merah_petak;
$total_hitam_petak += $hitam_petak;
$total_petak += $total_p;
}
$html .= '
';
return response($html);
}
public function gettablePicapanenrayonkebun2025(Request $request)
{
$cluster = $request->get('cluster', '');
$kebun = $request->get('kebun', '');
$start_date = $request->get('start_date', '');
$end_date = $request->get('end_date', '');
$params = [$cluster, $kebun, $start_date, $end_date];
$results = \DB::select('CALL sp_pica_panen_rayonkebun_2025(?, ?, ?, ?)', $params);
$params2 = [$cluster, $kebun, $start_date, $end_date];
$results2 = \DB::select('CALL sp_nilai_pica_panen_rayonkebun_2025(?, ?, ?, ?)', $params2);
// Build a lookup map for results2 by composite key
$nilaiPicaMap = [];
foreach ($results2 as $r2) {
$mapKey = ($r2->kode_kebun ?? '') . '|' . ($r2->kode_rayon ?? '');
$nilaiPicaMap[$mapKey] = $r2;
}
$html = '
';
$html .= '';
// First row - main headers
$html .= '';
$headers = ['Cluster', 'Kode Kebun', 'Kebun','Protas'];
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$headers[] = 'Kode Rayon';
$headers[] = 'Rayon';
}
$colspan = !empty($kebun) ? 5 : 3;
foreach ($headers as $h) {
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// Add NILAI PICA headers first
$html .= 'NILAI PICA | ';
// Add LUAS (Ha) and JUMLAH PETAK headers
$html .= 'LUAS (Ha) | ';
$html .= 'JUMLAH PETAK | ';
$html .= '
';
// Second row - color headers
$html .= '';
$colorHeaders = ['Emas', 'Hijau', 'Kuning', 'Merah', 'Hitam', 'Total'];
// For NILAI PICA
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '| ' . htmlspecialchars($h) . ' | ';
}
// For LUAS (Ha)
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
// For JUMLAH PETAK
foreach ($colorHeaders as $h) {
$style = '';
$txt = strtoupper($h);
if (strpos($txt, 'EMAS') !== false) {
$style = 'background-color:#FFD700; color:#000; text-align:center;';
} elseif (strpos($txt, 'HIJAU') !== false) {
$style = 'background-color:#008000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'KUNING') !== false) {
$style = 'background-color:#FFFF00; color:#000; text-align:center;';
} elseif (strpos($txt, 'MERAH') !== false) {
$style = 'background-color:#FF0000; color:#FFF; text-align:center;';
} elseif (strpos($txt, 'HITAM') !== false) {
$style = 'background-color:#000000; color:#FFF; text-align:center;';
} else {
$style = 'background-color:#0265c8; color:#FFF; text-align:center;';
}
$html .= '' . htmlspecialchars($h) . ' | ';
}
$html .= '
';
// Third row - description row for color categories
$html .= '';
// NILAI PICA descriptions (no range labels, just empty)
$html .= '| 5 | ';
$html .= '4 | ';
$html .= '3 | ';
$html .= '2 | ';
$html .= '1 | ';
$html .= ' | '; // Total (PICA)
// LUAS (Ha) descriptions
$html .= '≥ 100 ton/ha | ';
$html .= '85 ≤ X < 100 ton/ha | ';
$html .= '70 ≤ X < 85 ton/ha | ';
$html .= '60 ≤ X < 70 ton/ha | ';
$html .= '< 60 ton/ha | ';
$html .= ' | '; // Total (Ha)
// JUMLAH PETAK descriptions
$html .= '≥ 100 ton/ha | ';
$html .= '85 ≤ X < 100 ton/ha | ';
$html .= '70 ≤ X < 85 ton/ha | ';
$html .= '60 ≤ X < 70 ton/ha | ';
$html .= '< 60 ton/ha | ';
$html .= ' | '; // Total Petak
$html .= '
';
$html .= '';
$total_emas_ha = 0.0;
$total_hijau_ha = 0.0;
$total_kuning_ha = 0.0;
$total_merah_ha = 0.0;
$total_hitam_ha = 0.0;
$total_ha = 0.0;
$total_emas_petak = 0;
$total_hijau_petak = 0;
$total_kuning_petak = 0;
$total_merah_petak = 0;
$total_hitam_petak = 0;
$total_petak = 0;
$total_np_emas = 0.0;
$total_np_hijau = 0.0;
$total_np_kuning = 0.0;
$total_np_merah = 0.0;
$total_np_hitam = 0.0;
$total_np_nilai = 0.0;
foreach ($results as $row) {
$emas_ha = isset($row->emas_ha) ? (float)$row->emas_ha : 0.0;
$hijau_ha = isset($row->hijau_ha) ? (float)$row->hijau_ha : 0.0;
$kuning_ha = isset($row->kuning_ha) ? (float)$row->kuning_ha : 0.0;
$merah_ha = isset($row->merah_ha) ? (float)$row->merah_ha : 0.0;
$hitam_ha = isset($row->hitam_ha) ? (float)$row->hitam_ha : 0.0;
$total = isset($row->total_ha) ? (float)$row->total_ha : 0.0;
$emas_petak = isset($row->emas_petak) ? (int)$row->emas_petak : 0;
$hijau_petak = isset($row->hijau_petak) ? (int)$row->hijau_petak : 0;
$kuning_petak = isset($row->kuning_petak) ? (int)$row->kuning_petak : 0;
$merah_petak = isset($row->merah_petak) ? (int)$row->merah_petak : 0;
$hitam_petak = isset($row->hitam_petak) ? (int)$row->hitam_petak : 0;
$total_p = isset($row->total_petak) ? (int)$row->total_petak : 0;
// Get nilai pica from results2 map
$mapKey = ($row->kode_kebun ?? '') . '|' . ($row->kode_rayon ?? '');
$r2 = isset($nilaiPicaMap[$mapKey]) ? $nilaiPicaMap[$mapKey] : null;
$np_emas = $r2 && isset($r2->emas_pica) ? (float)$r2->emas_pica : 0.0;
$np_hijau = $r2 && isset($r2->hijau_pica) ? (float)$r2->hijau_pica : 0.0;
$np_kuning = $r2 && isset($r2->kuning_pica) ? (float)$r2->kuning_pica : 0.0;
$np_merah = $r2 && isset($r2->merah_pica) ? (float)$r2->merah_pica : 0.0;
$np_hitam = $r2 && isset($r2->hitam_pica) ? (float)$r2->hitam_pica : 0.0;
$np_total = $r2 && isset($r2->nilai_pica) ? (float)$r2->nilai_pica : 0.0;
$html .= '';
$html .= '| ' . htmlspecialchars($row->cluster ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->protas ?? '') . ' | ';
// Add Rayon columns if kebun is provided
if (!empty($kebun)) {
$html .= '' . htmlspecialchars($row->kode_rayon ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->rayon ?? '') . ' | ';
}
// NILAI PICA columns
$html .= '' . ($np_emas !== 0.0 ? number_format($np_emas, 2) : '') . ' | ';
$html .= '' . ($np_hijau !== 0.0 ? number_format($np_hijau, 2) : '') . ' | ';
$html .= '' . ($np_kuning !== 0.0 ? number_format($np_kuning, 2) : '') . ' | ';
$html .= '' . ($np_merah !== 0.0 ? number_format($np_merah, 2) : '') . ' | ';
$html .= '' . ($np_hitam !== 0.0 ? number_format($np_hitam, 2) : '') . ' | ';
$html .= '' . ($np_total !== 0.0 ? number_format($np_total, 2) : '') . ' | ';
// LUAS (Ha) columns
$html .= '' . ($emas_ha !== 0.0 ? number_format($emas_ha, 3) : '') . ' | ';
$html .= '' . ($hijau_ha !== 0.0 ? number_format($hijau_ha, 3) : '') . ' | ';
$html .= '' . ($kuning_ha !== 0.0 ? number_format($kuning_ha, 3) : '') . ' | ';
$html .= '' . ($merah_ha !== 0.0 ? number_format($merah_ha, 3) : '') . ' | ';
$html .= '' . ($hitam_ha !== 0.0 ? number_format($hitam_ha, 3) : '') . ' | ';
$html .= '' . ($total !== 0.0 ? number_format($total, 3) : '') . ' | ';
// JUMLAH PETAK columns
$html .= '' . ($emas_petak !== 0 ? $emas_petak : '') . ' | ';
$html .= '' . ($hijau_petak !== 0 ? $hijau_petak : '') . ' | ';
$html .= '' . ($kuning_petak !== 0 ? $kuning_petak : '') . ' | ';
$html .= '' . ($merah_petak !== 0 ? $merah_petak : '') . ' | ';
$html .= '' . ($hitam_petak !== 0 ? $hitam_petak : '') . ' | ';
$html .= '' . ($total_p !== 0 ? $total_p : '') . ' | ';
$html .= '
';
$total_np_emas += $np_emas;
$total_np_hijau += $np_hijau;
$total_np_kuning += $np_kuning;
$total_np_merah += $np_merah;
$total_np_hitam += $np_hitam;
$total_np_nilai += $np_total;
$total_emas_ha += $emas_ha;
$total_hijau_ha += $hijau_ha;
$total_kuning_ha += $kuning_ha;
$total_merah_ha += $merah_ha;
$total_hitam_ha += $hitam_ha;
$total_ha += $total;
$total_emas_petak += $emas_petak;
$total_hijau_petak += $hijau_petak;
$total_kuning_petak += $kuning_petak;
$total_merah_petak += $merah_petak;
$total_hitam_petak += $hitam_petak;
$total_petak += $total_p;
}
$html .= '
';
return response($html);
}
public function getTableRkapVsRkoVsTakdesVsTakmarVsReal(Request $request)
{
$tgl_awal = $request->get('tgl_awal', date('Y-m-d'));
$tgl_akhir = $request->get('tgl_akhir', date('Y-m-d'));
$results = \DB::select('CALL sp_rkapvsrkovstakdesvstakmarvsreal(?, ?)', [$tgl_awal, $tgl_akhir]);
$html = '
';
$html .= '';
$columns = [];
if (!empty($results)) {
$columns = array_keys((array) $results[0]);
} else {
$columns = [
'kode_kebun','kebun','luas_rkap','tebu_rkap','protas_rkap',
'luas_rko','tebu_rko','protas_rko',
'luas_takdes','tebu_takdes','protas_takdes',
'luas_takmar','tebu_takmar','protas_takmar',
'luas_real','tebu_real','protas_real','tgl_sd'
];
}
foreach ($columns as $col) {
$html .= '| ' . htmlspecialchars(strtoupper(str_replace('_', ' ', $col))) . ' | ';
}
$html .= '
';
$totals = array_fill_keys($columns, 0.0);
foreach ($results as $row) {
$rowArr = (array) $row;
$html .= '';
foreach ($columns as $col) {
$val = $rowArr[$col] ?? '';
if (is_numeric($val)) {
$num = (float) $val;
$totals[$col] += $num;
if (stripos($col, 'luas') !== false) {
$display = number_format($num, 3);
} elseif (stripos($col, 'protas') !== false) {
$display = number_format($num, 2);
} elseif (stripos($col, 'tebu') !== false) {
$display = number_format($num, 1);
} else {
$display = number_format($num, 2);
}
$html .= '| ' . $display . ' | ';
} else {
$html .= '' . htmlspecialchars((string) $val) . ' | ';
}
}
$html .= '
';
}
$html .= '
';
return response($html);
}
private function formatLkpPcrcPicaNumber($value)
{
if ($value === null || $value === '') {
return '';
}
$num = (float) $value;
if ($num == 0.0) {
return '0';
}
if (floor($num) == $num) {
return number_format($num, 0, '.', '');
}
return rtrim(rtrim(number_format($num, 3, '.', ''), '0'), '.');
}
public function getTableLkpRekapPcrcPica(Request $request)
{
$start_date = $request->get('start_date', '2023-10-01');
$end_date = $request->get('end_date', '2026-04-06');
$kode_kat = $request->get('kode_kat', 'PC');
$kebun = $request->get('kebun', 'SK01');
$afdeling = $request->get('afdeling', 'SK01K1');
$results = \DB::select(
'CALL sp_lkp_rekap_pcrc_pica(?, ?, ?, ?, ?)',
[$start_date, $end_date, $kode_kat, $kebun, $afdeling]
);
$columns = [];
if (!empty($results)) {
$columns = array_keys((array) $results[0]);
}
$html = '
';
$html .= '';
foreach ($columns as $col) {
$html .= '| ' . htmlspecialchars(strtoupper(str_replace('_', ' ', $col))) . ' | ';
}
$html .= '
';
if (empty($results)) {
$colspan = count($columns) > 0 ? count($columns) : 1;
$html .= '| Data tidak tersedia |
';
$html .= '
';
return response($html);
}
$numericColumns = [];
$totals = [];
foreach ($columns as $col) {
$numericColumns[$col] = false;
$totals[$col] = 0;
}
foreach ($results as $row) {
$rowArr = (array) $row;
foreach ($columns as $col) {
$value = $rowArr[$col] ?? null;
if (is_numeric($value)) {
$numericColumns[$col] = true;
$totals[$col] += (float) $value;
}
}
}
foreach ($results as $row) {
$rowArr = (array) $row;
$html .= '
';
foreach ($columns as $col) {
$value = $rowArr[$col] ?? '';
if ($numericColumns[$col] && is_numeric($value)) {
$html .= '| ' . $this->formatLkpPcrcPicaNumber($value) . ' | ';
} else {
$html .= '' . htmlspecialchars((string) $value) . ' | ';
}
}
$html .= '
';
}
$html .= '';
return response($html);
}
public function getTableLkpMonitoringUmur(Request $request)
{
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$kode_kat = $request->get('kategori');
$start_date = $request->get('tgl_awal');
$end_date = $request->get('tgl_akhir');
// $umur_min = $request->get('umur');
$jenis_report = $request->get('jenis_report');
$results = \DB::select(
'CALL sp_lkp_monitoring_umur_2(?, ?, ?, ?, ?, ?)',
[$kebun, $rayon, $kode_kat, $start_date, $end_date, $jenis_report]
);
$columns = [];
if (!empty($results)) {
$columns = array_keys((array) $results[0]);
}
$html = '
';
$html .= '';
foreach ($columns as $col) {
$html .= '| ' . htmlspecialchars(strtoupper(str_replace('_', ' ', $col))) . ' | ';
}
$html .= '
';
if (empty($results)) {
$colspan = count($columns) > 0 ? count($columns) : 1;
$html .= '| Data tidak tersedia |
';
$html .= '
';
return response($html);
}
foreach ($results as $row) {
$rowArr = (array) $row;
$html .= '
';
foreach ($columns as $col) {
$value = $rowArr[$col] ?? '';
if (is_numeric($value)) {
$html .= '| ' . htmlspecialchars((string) $value) . ' | ';
} else {
$html .= '' . htmlspecialchars((string) $value) . ' | ';
}
}
$html .= '
';
}
$html .= '';
return response($html);
}
public function formtableKuadranPemeliharaanPica(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Kuadran Pemeliharaan PICA',
'pageNote' => 'Data Kuadran Pemeliharaan PICA',
), $this->data);
return view($this->module.'.kuadran_pemeliharaan_pica', $this->data);
}
public function gettableKuadranPemeliharaanPica(Request $request)
{
config(['app.debug' => true]);
$kebun = $request->get('kebun', '');
$jenis = $request->get('jenis', 'PC');
$umur = $request->get('umur', 'TOTAL');
$results = \DB::select('CALL sp_kuadran_pemeliharaan_pica(?, ?, ?)', [$kebun, $jenis, $umur]);
$columns = [];
if (!empty($results)) {
$columns = array_keys((array) $results[0]);
}
$html = '
';
$html .= '';
$headerLabels = [
'kode_kebun' => 'Kode Kebun',
'kategori' => 'Kategori',
'umur' => 'Umur',
'rencana_bi' => 'Rencana BI',
'realisasi_bi' => 'Realisasi BI',
'standar_pe' => 'Standar PE',
];
foreach ($columns as $col) {
$label = isset($headerLabels[$col]) ? $headerLabels[$col] : strtoupper(str_replace('_', ' ', $col));
$html .= '| ' . htmlspecialchars($label) . ' | ';
}
$html .= '
';
if (empty($results)) {
$colspan = count($columns) > 0 ? count($columns) : 1;
$html .= '| Data tidak tersedia |
';
$html .= '
';
return response($html);
}
$numericTotals = array_fill_keys($columns, 0.0);
$isNumeric = array_fill_keys($columns, false);
foreach ($results as $row) {
$rowArr = (array) $row;
foreach ($columns as $col) {
if (is_numeric($rowArr[$col] ?? null)) {
$isNumeric[$col] = true;
}
}
}
foreach ($results as $row) {
$rowArr = (array) $row;
$html .= '
';
foreach ($columns as $col) {
$value = $rowArr[$col] ?? '';
if ($isNumeric[$col] && is_numeric($value)) {
$numericTotals[$col] += (float) $value;
if (stripos($col, 'rencana') !== false || stripos($col, 'realisasi') !== false) {
$display = number_format((float)$value, 0, ',', '.');
} elseif (stripos($col, 'standar') !== false) {
$display = number_format((float)$value, 2, ',', '.');
} else {
$display = htmlspecialchars((string)$value);
}
$html .= '| ' . $display . ' | ';
} else {
$html .= '' . htmlspecialchars((string)$value) . ' | ';
}
}
$html .= '
';
}
// Total row
$html .= '';
return response($html);
}
public function getTableHighchartColumnMonitoringUmur(Request $request)
{
config(['app.debug' => true]);
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$kode_kat = $request->get('kategori');
$start_date = $request->get('tgl_awal');
$end_date = $request->get('tgl_akhir');
$jenis_report = $request->get('jenis_report');
$kategori_pekerjaan = $request->get('kategori_pekerjaan');
$results = \DB::select(
'CALL sp_lkp_monitoring_umur_grafik(?, ?, ?, ?, ?, ?, ?)',
[$kebun, $rayon, $kode_kat, $start_date, $end_date, $jenis_report, $kategori_pekerjaan]
);
// Group data by kebun and pekerjaan
$groupedData = [];
$pekerjaanTypes = [];
foreach ($results as $row) {
$keb = $row->kode_kebun . ' - ' . $row->kebun;
$pekerjaan = $row->pekerjaan;
$ha = (float)$row->ha;
if (!isset($groupedData[$keb])) {
$groupedData[$keb] = [];
}
$groupedData[$keb][$pekerjaan] = $ha;
if (!in_array($pekerjaan, $pekerjaanTypes)) {
$pekerjaanTypes[] = $pekerjaan;
}
}
// Prepare categories (kebun names)
$categories = array_keys($groupedData);
// Prepare series for each pekerjaan type
$series = [];
foreach ($pekerjaanTypes as $pekerjaan) {
$data = [];
foreach ($categories as $keb) {
$data[] = isset($groupedData[$keb][$pekerjaan]) ? $groupedData[$keb][$pekerjaan] : 0;
}
$series[] = [
'name' => $pekerjaan,
'data' => $data
];
}
return response()->json([
'categories' => $categories,
'series' => $series
]);
}
public function formtableMonitoringPiPemeliharaanPanenPica(Request $request)
{
$this->data = array_merge(array(
'pageTitle' => 'Monitoring PI Pemeliharaan Panen PICA',
'pageNote' => 'Data Monitoring PI Pemeliharaan Panen PICA',
),$this->data);
return view($this->module.'.monitoring_pi_pemeliharaan_panen_pica', $this->data);
}
public function getTableMonitoringPiPemeliharaanPanenPica(Request $request)
{
config(['app.debug' => true]);
$cluster = $request->get('cluster', '');
$tgl = $request->get('tgl', date('Y-m-d'));
$results = \DB::select('CALL sp_monitoring_pi_pemeliharaan_panen_pica(?, ?)', [$cluster, $tgl]);
$html = '
';
$html .= '';
// First row - main group headers
$html .= '';
$html .= '| Cluster | ';
$html .= 'Kode Kebun | ';
$html .= 'Kebun | ';
$html .= ' | ';
$html .= 'Masa Pemeliharaan | ';
$html .= 'Masa Panen | ';
$html .= '
';
// Second row - sub headers
$html .= '';
$html .= '| Pupuk | ';
$html .= 'Jumlah Batang | ';
$html .= 'Tinggi Batang | ';
$html .= 'Diameter Batang | ';
$html .= 'Klentek | ';
$html .= 'Protas | ';
$html .= '
';
$html .= '';
// Group data by cluster -> kebun
$groupedData = [];
foreach ($results as $row) {
$clusterKey = $row->cluster;
$kebunKey = $row->kode_kebun;
if (!isset($groupedData[$clusterKey])) {
$groupedData[$clusterKey] = [];
}
if (!isset($groupedData[$clusterKey][$kebunKey])) {
$groupedData[$clusterKey][$kebunKey] = [
'cluster' => $row->cluster,
'kode_kebun' => $row->kode_kebun,
'kebun' => $row->kebun,
'ha_pupuk' => [],
'jumlah_batang' => [],
'tinggi_batang' => [],
'diameter_batang'=> [],
'klentek' => [],
'protas' => [],
];
}
$uraian = $row->uraian;
$ha = isset($row->ha) ? (float)$row->ha : 0.0;
$persen = isset($row->persen) ? (float)$row->persen : 0.0;
if (strpos($uraian, 'pupuk') !== false) {
$groupedData[$clusterKey][$kebunKey]['ha_pupuk'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
} elseif (strpos($uraian, 'jumlah_batang') !== false) {
$groupedData[$clusterKey][$kebunKey]['jumlah_batang'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
} elseif (strpos($uraian, 'tinggi_batang') !== false) {
$groupedData[$clusterKey][$kebunKey]['tinggi_batang'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
} elseif (strpos($uraian, 'diameter_batang') !== false) {
$groupedData[$clusterKey][$kebunKey]['diameter_batang'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
} elseif (strpos($uraian, 'klentek') !== false) {
$groupedData[$clusterKey][$kebunKey]['klentek'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
} elseif (strpos($uraian, 'protas') !== false) {
$groupedData[$clusterKey][$kebunKey]['protas'][] = ['uraian' => $uraian, 'ha' => $ha, 'persen' => $persen];
}
}
// Render rows
foreach ($groupedData as $clusterName => $kebunList) {
$clusterRowspan = count($kebunList);
$firstKebun = true;
foreach ($kebunList as $kebunKey => $kebunData) {
$html .= '';
if ($firstKebun) {
$html .= '| ' . htmlspecialchars($clusterName) . ' | ';
$firstKebun = false;
}
$html .= '' . htmlspecialchars($kebunData['kode_kebun']) . ' | ';
$html .= '' . htmlspecialchars($kebunData['kebun']) . ' | ';
$html .= ' | ';
// Helper: render item card
// Colors per category: pupuk=#4472C4, jumlah_batang=#7030A0, tinggi_batang=#00B0F0, diameter_batang=#ED7D31, klentek=#70AD47, protas=#375623
// Pupuk
$html .= '';
foreach ($kebunData['ha_pupuk'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'tepat_waktu') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'TEPAT WAKTU';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓';
} elseif (strpos($uraian_raw, 'terlambat') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'TERLAMBAT';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗';
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰';
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
// Jumlah Batang
$html .= '';
foreach ($kebunData['jumlah_batang'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'sudah') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'DIATAS TARGET';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓';
} elseif (strpos($uraian_raw, 'belum') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'DIBAWAH TARGET';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗';
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰';
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
// Tinggi Batang
$html .= '';
foreach ($kebunData['tinggi_batang'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'sudah') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'DIATAS TARGET';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓';
} elseif (strpos($uraian_raw, 'belum') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'DIBAWAH TARGET';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗';
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰';
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
// Diameter Batang
$html .= '';
foreach ($kebunData['diameter_batang'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'sudah') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'DIATAS TARGET';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓';
} elseif (strpos($uraian_raw, 'belum') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'DIBAWAH TARGET';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗';
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰';
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
// Klentek
$html .= '';
foreach ($kebunData['klentek'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'sudah') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'SUDAH';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓'; // checkmark
} elseif (strpos($uraian_raw, 'belum') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'BELUM';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗'; // cross
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰'; // lines
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
// Protas
$html .= '';
foreach ($kebunData['protas'] as $item) {
$uraian_raw = $item['uraian'];
$pct = number_format($item['persen'], 1);
$ha = number_format($item['ha'], 2);
if (strpos($uraian_raw, 'diatas') !== false || strpos($uraian_raw, 'sesuai') !== false || strpos($uraian_raw, 'diatas') !== false) {
$label = 'DIATAS RKAP';
$bg = '#E8F5E9';
$border = '#43A047';
$badge = '#43A047';
$lcolor = '#2e7d32';
$icon = '✓';
} elseif (strpos($uraian_raw, 'dibawah') !== false || strpos($uraian_raw, 'dibawah') !== false) {
$label = 'DIBAWAH RKAP';
$bg = '#FFF3E0';
$border = '#E53935';
$badge = '#E53935';
$lcolor = '#c62828';
$icon = '✗';
} else {
$label = 'TOTAL';
$bg = '#E3F2FD';
$border = '#1E88E5';
$badge = '#1E88E5';
$lcolor = '#1565c0';
$icon = '☰';
}
$html .= '';
$html .= ' ' . $icon . ' ' . $label . ' ';
$html .= ' ';
$html .= '' . $ha . ' ha';
$html .= '' . $pct . '%';
$html .= ' | ';
$html .= '
';
} // end foreach kebunList
} // end foreach groupedData
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '';
return response($html);
}
function settingKuadranKinerja(Request $request)
{
$setting = \DB::table('setting_kuadran_kinerja')->where('id', 1)->first();
return response()->json($setting);
}
function updateSettingKuadranKinerja(Request $request)
{
$xMin = $request->input('xMin');
$xMax = $request->input('xMax');
$yMin = $request->input('yMin');
$yMax = $request->input('yMax');
$cashCostMid = $request->input('cashCostMid');
$ipoMid = $request->input('ipoMid');
$data = [
'xMin' => $xMin,
'xMax' => $xMax,
'yMin' => $yMin,
'yMax' => $yMax,
'cashCostMid' => $cashCostMid,
'ipoMid' => $ipoMid
];
$update = \DB::table('setting_kuadran_kinerja')->updateOrInsert(['id' => 1], $data);
return response()->json($update);
}
function settingKuadranpica(Request $request)
{
$setting = \DB::table('setting_kuadran_pica')->where('id', 1)->first();
return response()->json($setting);
}
function updateSettingKuadranpica(Request $request)
{
$xMin = $request->input('xMin');
$xMax = $request->input('xMax');
$yMin = $request->input('yMin');
$yMax = $request->input('yMax');
$nilaiMid = $request->input('nilaiMid');
$cashCostMid = $request->input('cashCostMid');
$data = [
'xMin' => $xMin,
'xMax' => $xMax,
'yMin' => $yMin,
'yMax' => $yMax,
'nilaiMid' => $nilaiMid,
'cashCostMid' => $cashCostMid
];
$update = \DB::table('setting_kuadran_pica')->updateOrInsert(['id' => 1], $data);
return response()->json($update);
}
function settingKuadranpicapemeliharaan(Request $request)
{
$setting = \DB::table('setting_kuadran_pica_pemeliharaan')->where('id', 1)->first();
return response()->json($setting);
}
function updateSettingKuadranpicapemeliharaan(Request $request)
{
$xMin = $request->input('xMin');
$xMax = $request->input('xMax');
$yMin = $request->input('yMin');
$yMax = $request->input('yMax');
$nilaiMid = $request->input('nilaiMid');
$cashCostMid = $request->input('cashCostMid');
$data = [
'xMin' => $xMin,
'xMax' => $xMax,
'yMin' => $yMin,
'yMax' => $yMax,
'nilaiMid' => $nilaiMid,
'cashCostMid' => $cashCostMid
];
$update = \DB::table('setting_kuadran_pica_pemeliharaan')->updateOrInsert(['id' => 1], $data);
return response()->json($update);
}
function getKuadranKinerjaKebun(Request $request)
{
$nama_kebun = $request->get('cluster');
$tahun = $request->get('bulan');
$params = [$nama_kebun, $tahun];
$results = \DB::select('CALL kuadran_kinerja_kebun_kso_info(?, ?)', $params);
$html = '';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Kebun | ';
$html .= 'Target Produktivitas | ';
$html .= 'Produktivitas SD Minggu Ini | ';
$html .= 'Score Produktivitas | ';
$html .= 'Target Rendemen | ';
$html .= 'Rendemen SD Minggu Ini | ';
$html .= 'Score Rendemen | ';
$html .= 'Target Pasok Harian | ';
$html .= 'Rata2 Pasok Harian SD Minggu Ini | ';
$html .= 'Score Pasok | ';
$html .= 'X Cashcost | ';
$html .= 'IPO Protas | ';
$html .= 'IPO Rendemen | ';
$html .= 'IPO Pasok | ';
$html .= 'Y IPO SD Minggu Ini | ';
$html .= '
';
$html .= '';
$html .= '';
foreach($results as $row) {
$isTotal = stripos($row->Kebun, 'total') !== false ? ' class="total-row"' : '';
$html .= '';
$html .= '' . $row->Kebun . ' | ';
$html .= '' . number_format($row->target_produktivitas, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->produktivitas_sd_minggu_ini, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->score_produktivitas, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->target_rendemen, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->rendemen_sd_minggu_ini, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->score_rendemen, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->target_pasok_harian, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->rata2_pasok_harian_sd_minggu_ini, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->score_pasok, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->x_cashcost, 0, ',', '.') . ' | ';
$html .= '' . number_format($row->ipo_protas, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->ipo_rendemen, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->ipo_pasok, 2, ',', '.') . ' | ';
$html .= '' . number_format($row->y_ipo_sd_minggu_ini, 2, ',', '.') . ' | ';
$html .= '';
}
$html .= '';
$html .= '
';
return response($html);
}
function getDashboard1Pica( Request $request )
{
$tahun = date('Y');
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$params = [$tahun, $cluster, $kebun];
$results = \DB::select('CALL sp_pica_dashboard_1_pica(?, ?, ?)', $params);
$html = '';
$html .= '
Nilai PICA Panen '.date('Y').'
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Kebun | ';
$html .= 'Jan | ';
$html .= 'Feb | ';
$html .= 'Mar | ';
$html .= 'Apr | ';
$html .= 'Mei | ';
$html .= 'Jun | ';
$html .= 'Jul | ';
$html .= 'Agu | ';
$html .= 'Sep | ';
$html .= 'Okt | ';
$html .= 'Nov | ';
$html .= 'Des | ';
$html .= '
';
$html .= '';
$html .= '';
foreach($results as $row) {
$isTotal = stripos($row->nama_rekap, 'total') !== false ? ' class="total-row"' : '';
$html .= '';
$html .= '' . $row->nama_rekap . ' | ';
$html .= '' . ($row->januari ? number_format($row->januari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->februari ? number_format($row->februari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->maret ? number_format($row->maret, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->april ? number_format($row->april, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->mei ? number_format($row->mei, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juni ? number_format($row->juni, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juli ? number_format($row->juli, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->agustus ? number_format($row->agustus, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->september ? number_format($row->september, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->oktober ? number_format($row->oktober, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->november ? number_format($row->november, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->desember ? number_format($row->desember, 2, ',', '.') : '-') . ' | ';
$html .= '';
}
$html .= '';
$html .= '
';
return response($html);
}
function getDashboard2Pica( Request $request )
{
$tahun = $request->get('tahun', date('Y'));
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$params = [$tahun, $cluster, $kebun];
$results = \DB::select('CALL sp_pica_dashboard_2_pica(?, ?, ?)', $params);
$html = '';
$html .= '
PICA Tahun '.$tahun.'
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Kebun | ';
$html .= 'Jan | ';
$html .= 'Feb | ';
$html .= 'Mar | ';
$html .= 'Apr | ';
$html .= 'Mei | ';
$html .= 'Jun | ';
$html .= 'Jul | ';
$html .= 'Agu | ';
$html .= 'Sep | ';
$html .= 'Okt | ';
$html .= 'Nov | ';
$html .= 'Des | ';
$html .= '
';
$html .= '';
$html .= '';
foreach($results as $row) {
$isTotal = stripos($row->nama_rekap, 'total') !== false ? ' class="total-row"' : '';
$html .= '';
$html .= '' . $row->nama_rekap . ' | ';
$html .= '' . ($row->januari ? number_format($row->januari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->februari ? number_format($row->februari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->maret ? number_format($row->maret, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->april ? number_format($row->april, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->mei ? number_format($row->mei, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juni ? number_format($row->juni, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juli ? number_format($row->juli, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->agustus ? number_format($row->agustus, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->september ? number_format($row->september, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->oktober ? number_format($row->oktober, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->november ? number_format($row->november, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->desember ? number_format($row->desember, 2, ',', '.') : '-') . ' | ';
$html .= '';
}
$html .= '';
$html .= '
';
return response($html);
}
function getDashboard1Produktivitas( Request $request )
{
$tahun = $request->get('tahun', date('Y'));
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$parameter = $request->get('parameter', 'produktivitas');
$params = [$tahun, $cluster, $kebun, $parameter];
$results = \DB::select('CALL sp_pica_dashboard_1_parameter_panen(?, ?, ?, ?)', $params);
$html = '';
$judul = ucfirst($parameter);
if (strtolower($parameter) === 'cashcost') {
$judul .= ' Sampai Dengan ';
$tahun = $tahun . ' (Exclude Saprodi)';
}else if (strtolower($parameter) === 'mutuab') {
$judul = 'Mutu A+B';
}
$html .= '
' . $judul . ' '.$tahun.'
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Kebun | ';
$html .= 'Jan | ';
$html .= 'Feb | ';
$html .= 'Mar | ';
$html .= 'Apr | ';
$html .= 'Mei | ';
$html .= 'Jun | ';
$html .= 'Jul | ';
$html .= 'Agu | ';
$html .= 'Sep | ';
$html .= 'Okt | ';
$html .= 'Nov | ';
$html .= 'Des | ';
if(strtolower($parameter) !== 'cashcost') {
$html .= 'Total | ';
}
$html .= '
';
$html .= '';
$html .= '';
foreach($results as $row) {
$isTotal = stripos($row->nama_rekap, 'total') !== false ? ' class="total-row"' : '';
$html .= '';
$html .= '' . $row->nama_rekap . ' | ';
$html .= '' . ($row->januari ? number_format($row->januari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->februari ? number_format($row->februari, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->maret ? number_format($row->maret, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->april ? number_format($row->april, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->mei ? number_format($row->mei, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juni ? number_format($row->juni, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->juli ? number_format($row->juli, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->agustus ? number_format($row->agustus, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->september ? number_format($row->september, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->oktober ? number_format($row->oktober, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->november ? number_format($row->november, 2, ',', '.') : '-') . ' | ';
$html .= '' . ($row->desember ? number_format($row->desember, 2, ',', '.') : '-') . ' | ';
if(strtolower($parameter) !== 'cashcost') {
$html .= '' . ($row->total ? number_format($row->total, 2, ',', '.') : '-') . ' | ';
}
$html .= '';
}
$html .= '';
$html .= '
';
return response($html);
}
function getTableAreaProblemCard(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$results = \DB::select("CALL sp_pica_dashboard_1_pi(?, ?, ?, ?)", [$cluster, $kebun, $rayon, $tgl]);
$html = '
';
$html .= '';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Area Problem | ';
$html .= 'Jumlah Petak | ';
$html .= 'Prosentase | ';
$html .= '
';
$html .= '';
$html .= '';
$parents = [];
$isTotal = false;
foreach($results as $row) {
if(strtolower($row->area_problem) === 'total') {
$isTotal = true;
} elseif($row->parent === '' || $row->parent === null) {
$parents[$row->area_problem] = $row;
}
}
foreach($parents as $parentName => $parentData) {
$bgColor = 'linear-gradient(135deg, #667eea 0%, #764ba2 100%)';
$textColor = 'white';
$parentId = str_replace(' ', '_', $parentName);
$html .= '';
$html .= '| ▶' . $parentName . ' | ';
$html .= '' . number_format($parentData->jumlah_problem, 0, ',', '.') . ' | ';
$html .= '' . number_format($parentData->persen_terhadap_problemarea, 2, ',', '.') . '% | ';
$html .= '
';
foreach($results as $row) {
if($row->parent === $parentName) {
$childId = str_replace(' ', '_', $parentId);
$html .= '';
$html .= '| ' . $row->area_problem . ' | ';
$html .= '' . number_format($row->jumlah_problem, 0, ',', '.') . ' | ';
$html .= '' . number_format($row->persen_terhadap_problemarea, 2, ',', '.') . '% | ';
$html .= '
';
}
}
}
if($isTotal) {
foreach($results as $row) {
if(strtolower($row->area_problem) === 'total') {
$html .= '';
$html .= '| ' . $row->area_problem . ' | ';
$html .= '' . number_format($row->jumlah_problem, 0, ',', '.') . ' | ';
$html .= '' . number_format($row->persen_terhadap_problemarea, 2, ',', '.') . '% | ';
$html .= '
';
}
}
}
$html .= '';
$html .= '
';
//modal detail jumlah problem
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
Loading...
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '
';
$html .= '
';
return response($html);
}
function getTableCorrectiveCard(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$params = [$cluster, $kebun, $rayon, $tgl];
$results = \DB::select('CALL sp_pica_dashboard_1_ca(?, ?, ?, ?)', $params);
// Group results by parent
$grouped = [];
$totals = null;
foreach($results as $row) {
if (strtolower($row->corrective) === 'total') {
$totals = $row;
} else {
$parent = $row->parent ?? 'Uncategorized';
if (!isset($grouped[$parent])) {
$grouped[$parent] = [];
}
$grouped[$parent][] = $row;
}
}
$html = '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Corrective | ';
$html .= 'Mulai | ';
$html .= 'Target Selesai | ';
$html .= 'Progress | ';
$html .= 'Status | ';
$html .= 'Selesai | ';
$html .= 'Total | ';
$html .= '
';
$html .= '';
$html .= '';
$parentIndex = 0;
foreach($grouped as $parent => $rows) {
$parentId = 'parent-' . ($parentIndex++);
// Parent row
$html .= '';
$html .= '| ▶' . htmlspecialchars($parent) . ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= '' . count($rows) . ' | ';
$html .= '
';
// Child rows
foreach($rows as $row) {
$statusColor = strtolower($row->status) === 'close' ? '#4CAF50' : '#ff9800';
$statusBg = strtolower($row->status) === 'close' ? '#e8f5e9' : '#fff3e0';
$dataColor = '#e8f5e9';
$dataTextColor = '#2e7d32';
$html .= '';
$html .= '| ' . htmlspecialchars($row->corrective) . ' | ';
$html .= '' . ($row->bulan_target_mulai ?? '-') . ' | ';
$html .= '' . ($row->bulan_target_selesai ?? '-') . ' | ';
$html .= '' . $row->progress . ' | ';
$html .= '' . $row->status . ' | ';
$html .= '' . ($row->bulan_selesai ?? '-') . ' | ';
$html .= '' . $row->jumlah_corrective . ' | ';
$html .= '
';
}
}
// Total row
if ($totals) {
$html .= '';
$html .= '| ' . htmlspecialchars($totals->corrective) . ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= '' . $totals->progress . ' | ';
$html .= '' . $totals->status . ' | ';
$html .= ' | ';
$html .= '' . $totals->jumlah_corrective . ' | ';
$html .= '
';
}
$html .= '';
$html .= '
';
//modal detail jumlah corrective
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
Loading...
';
$html .= '
';
$html .= '';
$html .= '
'; // Close modal-content
$html .= '
'; // Close modal-dialog
$html .= '
'; // Close modal
$html .= '';
$html .= '
';
$html .= '
';
return response($html);
}
function getTablePiDetil(Request $request)
{
config(['app.debug' => true]);
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$problem = $request->get('problem');
$params = [$cluster, $kebun, $rayon, $tgl, $problem];
$results = \DB::select('CALL sp_pica_dashboard_1_pi_detil(?, ?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Problem | ';
$html .= 'Lahan ID | ';
$html .= 'Afdeling | ';
$html .= 'Total | ';
$html .= '
';
$html .= '';
$html .= '';
$grandTotal = 0;
foreach($results as $row) {
$grandTotal++;
$html .= '';
$html .= '| ' . htmlspecialchars($row->problem) . ' | ';
$html .= '' . htmlspecialchars($row->lahan_id) . ' | ';
$html .= '' . htmlspecialchars($row->afdeling) . ' | ';
$html .= '1 | ';
$html .= '
';
}
// Total row
$html .= '';
$html .= '| TOTAL | ';
$html .= ' | ';
$html .= ' | ';
$html .= '' . $grandTotal . ' | ';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '
';
return response($html);
}
function getTableCaDetil(Request $request)
{
$cluster = $request->get('cluster');
$kebun = $request->get('kebun');
$rayon = $request->get('rayon');
$tgl = $request->get('tgl');
$problem = $request->get('problem');
$params = [$cluster, $kebun, $rayon, $tgl, $problem];
$results = \DB::select('CALL sp_pica_dashboard_1_ca_detil(?, ?, ?, ?, ?)', $params);
$html = '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '';
$html .= '| Corrective | ';
$html .= 'Lahan ID | ';
$html .= 'Afdeling | ';
$html .= 'Total | ';
$html .= '
';
$html .= '';
$html .= '';
$grandTotal = 0;
foreach($results as $row) {
$grandTotal++;
$html .= '';
$html .= '| ' . htmlspecialchars($row->corrective) . ' | ';
$html .= '' . htmlspecialchars($row->lahan_id) . ' | ';
$html .= '' . htmlspecialchars($row->afdeling) . ' | ';
$html .= '1 | ';
$html .= '
';
}
// Total row
$html .= '';
$html .= '| TOTAL | ';
$html .= ' | ';
$html .= ' | ';
$html .= '' . $grandTotal . ' | ';
$html .= '
';
$html .= '';
$html .= '
';
$html .= '
';
$html .= '
';
return response($html);
}
function formtablePicapanenrayonkebunMutu(Request $request)
{
if(!\Auth::check())
return redirect('user/login')->with('status', 'error')->with('message','You are not login');
$this->data = array_merge(array(
'pageTitle' => 'PICA Panen Rayon Kebun Mutu',
'pageNote' => 'Data PICA Panen Rayon Kebun Mutu',
'pageModule'=> 'picapetak',
'return' => self::returnUrl()
),$this->data);
return view($this->module.'.pica_panen_rayon_kebun_mutu', $this->data);
}
function gettablePicapanenrayonkebunMutu(Request $request)
{
config(['app.debug' => true]);
$cluster = $request->input('cluster') ?? null;
$kebun = $request->input('kebun') ?? null;
$start_date = $request->input('start_date') ?? null;
$end_date= $request->input('end_date')??null;
$clusterParam = $cluster ? "'" . addslashes($cluster) . "'" : 'NULL';
$startDateParam = $start_date ? "'" . addslashes($start_date) . "'" : 'NULL';
$endDateParam = $end_date ? "'" . addslashes($end_date) . "'" : 'NULL';
$kebunParam = $kebun ? "'" . addslashes($kebun) . "'" : 'NULL';
$params = [$cluster, $kebun, $start_date, $end_date];
$results = \DB::select('CALL sp_pica_panen_rayonkebun_mutu(?, ?, ?, ?)', $params);
$thStyle = "background: #0265c8; color: #FFF; padding: 10px; font-weight: 600; text-transform: uppercase; font-size: 12px; text-align: center; border: 1px solid #ddd;";
// Color mapping for columns
$colorMap = [
'emas' => ['bg' => '#FFD700', 'color' => '#000'],
'hijau' => ['bg' => '#008000', 'color' => '#FFF'],
'kuning'=> ['bg' => '#FFFF00', 'color' => '#000'],
'merah' => ['bg' => '#FF0000', 'color' => '#FFF'],
'hitam' => ['bg' => '#000000', 'color' => '#FFF']
];
$html = '
';
$html .= '
';
$html .= '';
$html .= '| Cluster | ';
$html .= 'Kode | ';
$html .= 'Kebun | ';
$html .= 'Protas | ';
// Ha columns
foreach (['emas','hijau','kuning','merah','hitam','total'] as $m) {
$bgColor = ($m === 'total') ? '#FFF' : $colorMap[$m]['bg'];
$textColor = ($m === 'total') ? '#333' : $colorMap[$m]['color'];
$haStyle = 'background: ' . $bgColor . '; color: ' . $textColor . '; padding: 10px; font-weight: 600; text-transform: uppercase; font-size: 12px; text-align: center; border: 1px solid #999; white-space: nowrap;';
$html .= '' . strtoupper($m) . ' Ha | ';
}
$html .= ' | ';
// Petak columns
foreach (['emas','hijau','kuning','merah','hitam','total'] as $m) {
$bgColor = ($m === 'total') ? '#FFF' : $colorMap[$m]['bg'];
$textColor = ($m === 'total') ? '#333' : $colorMap[$m]['color'];
$petakStyle = 'background: ' . $bgColor . '; color: ' . $textColor . '; padding: 10px; font-weight: 600; text-transform: uppercase; font-size: 12px; text-align: center; border: 1px solid #999; white-space: nowrap;';
$label = ($m === 'total') ? 'TOTAL Petak' : strtoupper($m) . ' Petak';
$html .= '' . $label . ' | ';
}
$html .= '
';
$html .= '';
$prevCluster = null;
foreach ($results as $i => $row) {
$isGrandTotal = (stripos($row->kebun ?? '', 'GRAND TOTAL') !== false || stripos($row->cluster ?? '', 'GRAND TOTAL') !== false);
$isNewCluster = ($row->cluster !== $prevCluster);
$prevCluster = $row->cluster;
$rowBg = $isGrandTotal ? '#0265c8' : ($i % 2 === 0 ? '#ffffff' : '#f9f9f9');
$rowStyle = 'background: ' . $rowBg . '; border-bottom: 1px solid #ddd;color: ' . ($isGrandTotal ? '#fff' : '#333') . '; font-weight: ' . ($isGrandTotal ? '700' : '400') . ';';
$tdBase = 'padding: 10px; border: 1px solid #ddd; white-space: nowrap;';
$tdNum = $tdBase . ' text-align: right;';
$tdCtr = $tdBase . ' text-align: center;';
$html .= '';
// Cluster cell with badge
$clusterDisplay = htmlspecialchars($row->cluster ?? '');
if ($isGrandTotal) {
$html .= '| ' . $clusterDisplay . ' | ';
} else {
$html .= '' . $clusterDisplay . ' | ';
$html .= '' . htmlspecialchars($row->kode_kebun ?? '') . ' | ';
$html .= '' . htmlspecialchars($row->kebun ?? '') . ' | ';
}
// Protas
$html .= '' . number_format((float)($row->protas ?? 0), 2) . ' | ';
// Ha columns
foreach (['emas_ha','hijau_ha','kuning_ha','merah_ha','hitam_ha','total_ha'] as $col) {
$html .= '' . number_format((float)($row->$col ?? 0), 3) . ' | ';
}
// Separator
$html .= ' | ';
// Petak columns
foreach (['emas_petak','hijau_petak','kuning_petak','merah_petak','hitam_petak','total_petak'] as $col) {
$html .= '' . (int)($row->$col ?? 0) . ' | ';
}
$html .= '
';
}
$html .= '
';
return response($html);
}
function show( Request $request , $id )
{
/* Handle import , export and view */
$task =$id ;
switch( $task)
{
case 'export':
return $this->getExport( $request );
break;
case 'chartPieDataPica':
return $this->chartPieDataPica($request);
break;
case 'chartPieDataLuasPica':
return $this->chartPieDataLuasPica($request);
break;
case 'getTableDataPica':
return $this->getTableDataPica($request);
break;
case 'picaMorfologi':
return $this->picaMorfologi($request);
break;
case 'chartPieDataJmlBatangPica':
return $this->chartPieDataJmlBatangPica($request);
break;
case 'chartPieDataTinggiBatangPica':
return $this->chartPieDataTinggiBatangPica($request);
break;
case 'chartPieDataDiameterBatangPica':
return $this->chartPieDataDiameterBatangPica($request);
break;
case 'chartBarDataPica':
return $this->chartBarDataPica($request);
break;
case 'getTableDataPicaMorfologi':
return $this->getTableDataPicaMorfologi($request);
break;
case 'getAjaxDataPicaPetak':
return $this->getAjaxDataPicaPetak($request);
break;
case 'chartLineAreaProblem':
return $this->chartLineAreaProblem($request);
break;
case 'picaeksekutif':
return $this->picaeksekutif($request);
break;
case 'chartLineAreaProblemDetail':
return $this->chartLineAreaProblemDetail($request);
break;
case 'getKuadranData':
return $this->getKuadranData($request);
break;
case 'kuadranpica':
return $this->kuadranpica($request);
break;
case 'getStatisticsMasterKebun':
return $this->getStatisticsMasterKebun($request);
break;
case 'getStatisticsMasterPG':
return $this->getStatisticsMasterPG($request);
break;
case 'getTableMasterKebun':
return $this->getTableMasterKebun($request);
break;
case 'getTableMasterPG':
return $this->getTableMasterPG($request);
break;
case 'formtablePicapanenrayonkebun':
return $this->formtablePicapanenrayonkebun($request);
break;
case 'gettablePicapanenrayonkebun':
return $this->gettablePicapanenrayonkebun($request);
break;
case 'formtableNilaiPicapanenrayonkebun':
return $this->formtableNilaiPicapanenrayonkebun($request);
break;
case 'gettableNilaiPicapanenrayonkebun':
return $this->gettableNilaiPicapanenrayonkebun($request);
break;
case 'formtablePicapemeliharaandiameterrayonkebun':
return $this->formtablePicapemeliharaandiameterrayonkebun($request);
break;
case 'gettablePicapemeliharaandiameterrayonkebun':
return $this->gettablePicapemeliharaandiameterrayonkebun($request);
break;
case 'formtableCashcostPanen':
return $this->formtableCashcostPanen($request);
break;
case 'gettableCashcostPanen':
return $this->gettableCashcostPanen($request);
break;
case 'formtablePicapemeliharaanjumlahbatangrayonkebun':
return $this->formtablePicapemeliharaanjumlahbatangrayonkebun($request);
break;
case 'gettablePicapemeliharaanjumlahbatangrayonkebun':
return $this->gettablePicapemeliharaanjumlahbatangrayonkebun($request);
break;
case 'formtablePicapemeliharaantinggirayonkebun':
return $this->formtablePicapemeliharaantinggirayonkebun($request);
break;
case 'gettablePicapemeliharaantinggirayonkebun':
return $this->gettablePicapemeliharaantinggirayonkebun($request);
break;
case 'gettablePicapanenrayonkebun2025':
return $this->gettablePicapanenrayonkebun2025($request);
break;
case 'getTableRkapVsRkoVsTakdesVsTakmarVsReal':
return $this->getTableRkapVsRkoVsTakdesVsTakmarVsReal($request);
break;
case 'getTableLkpRekapPcrcPica':
return $this->getTableLkpRekapPcrcPica($request);
break;
case 'getTableLkpMonitoringUmur':
return $this->getTableLkpMonitoringUmur($request);
break;
case 'formtableKuadranPemeliharaanPica':
return $this->formtableKuadranPemeliharaanPica($request);
break;
case 'gettableKuadranPemeliharaanPica':
return $this->gettableKuadranPemeliharaanPica($request);
break;
case 'getTableHighchartColumnMonitoringUmur':
return $this->getTableHighchartColumnMonitoringUmur($request);
break;
case 'gettableKuadranPemeliharaanPicaGrafik':
return $this->gettableKuadranPemeliharaanPicaGrafik($request);
break;
case 'formtableMonitoringPiPemeliharaanPanenPica':
return $this->formtableMonitoringPiPemeliharaanPanenPica($request);
break;
case 'getTableMonitoringPiPemeliharaanPanenPica':
return $this->getTableMonitoringPiPemeliharaanPanenPica($request);
break;
case 'picaeksekutifmasapemeliharaan':
return $this->picaeksekutifmasapemeliharaan($request);
break;
case 'picaeksekutifmasapanen':
return $this->picaeksekutifmasapanen($request);
break;
case 'formKuadranKinerja':
return $this->formKuadranKinerja($request);
break;
case 'getKuadranKinerja':
return $this->getKuadranKinerja($request);
break;
case 'getDataKuadranCashcostPanen':
return $this->getDataKuadranCashcostPanen($request);
break;
case 'settingKuadranKinerja':
return $this->settingKuadranKinerja($request);
break;
case 'updateSettingKuadranKinerja':
return $this->updateSettingKuadranKinerja($request);
break;
case 'settingKuadranpica':
return $this->settingKuadranpica($request);
break;
case 'updateSettingKuadranpica':
return $this->updateSettingKuadranpica($request);
break;
case 'settingKuadranpicapemeliharaan':
return $this->settingKuadranpicapemeliharaan($request);
break;
case 'updateSettingKuadranpicapemeliharaan':
return $this->updateSettingKuadranpicapemeliharaan($request);
break;
case 'getKuadranKinerjanew':
return $this->getKuadranKinerjanew($request);
break;
case 'getKuadranKinerjaKebun':
return $this->getKuadranKinerjaKebun($request);
break;
case 'getPicaDashboard':
return $this->getPicaDashboard($request);
break;
case 'getBarChartProduktivitas':
return $this->getBarChartProduktivitas($request);
break;
case 'getDashboardMutu':
return $this->getDashboardMutu($request);
break;
case 'getDashboardKlentek':
return $this->getDashboardKlentek($request);
break;
case 'getDashboard1Pica':
return $this->getDashboard1Pica($request);
break;
case 'getDashboardKesegaran':
return $this->getDashboardKesegaran($request);
break;
case 'getDashboard1Produktivitas':
return $this->getDashboard1Produktivitas($request);
break;
case 'getDashboardKlasifikasiProtas':
return $this->getDashboardKlasifikasiProtas($request);
break;
case 'getTableAreaProblemCard':
return $this->getTableAreaProblemCard($request);
break;
case 'getTableCorrectiveCard':
return $this->getTableCorrectiveCard($request);
break;
case 'formtablePicapanenrayonkebunMutu':
return $this->formtablePicapanenrayonkebunMutu($request);
break;
case 'gettablePicapanenrayonkebunMutu':
return $this->gettablePicapanenrayonkebunMutu($request);
break;
case 'getDashboardPica2':
return $this->getDashboardPica2($request);
break;
case 'getTableParameterPemeliharaan':
return $this->getTableParameterPemeliharaan($request);
break;
case 'getDashboard2Pica':
return $this->getDashboard2Pica($request);
break;
case 'getDiameterChart':
return $this->getDiameterChart($request);
break;
case 'getJumlahBatangChart':
return $this->getJumlahBatangChart($request);
break;
case 'getTinggiBatangChart':
return $this->getTinggiBatangChart($request);
break;
case 'getPemupukanData':
return $this->getPemupukanData($request);
break;
case 'formKuadranKinerja888':
return $this->formKuadranKinerja888($request);
break;
case 'getKuadranKinerjaTable888':
return $this->getKuadranKinerjaTable888($request);
break;
case 'getTablePiDetil':
return $this->getTablePiDetil($request);
break;
case 'getTableCaDetil':
return $this->getTableCaDetil($request);
break;
case 'getInfoIndikatorKinerja':
return $this->getInfoIndikatorKinerja($request);
break;
default:
// Handle other tasks or show a 404 error
return redirect()->back()->with('status', 'error')->with('message', 'Invalid task specified.');
break;
}
}
}