function grafik_total_pencapaian_get()
{
$jekel = array('Tercapai' => 'Tercapai', 'Belum Tercapai' => 'Belum Tercapai');
$data = array();
$total = 0;
foreach ($jekel as $key => $row) {
if ($row === 'Tercapai') {
$sql_penerbang_persens = "select IFNULL((SUM(TIME_TO_SEC(jam_ops_total))/\r\n (select IFNULL(SUM(jumlah),0) from tb_rencana_jam_lat_ops where YEAR(bulan) = '" . date("Y") . "'))*100,0) as persen_capai\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_daily_program d on (f.id_daily_program = d.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n left join tb_kode_latihan kl on (f.id_kode_latihan = kl.id)\r\n where c.id is not NULL\r\n ";
$query = $this->db->query($sql_penerbang_persens . " and YEAR(f.tanggal) = '" . date("Y") . "'")->row()->persen_capai;
}
if ($row === 'Belum Tercapai') {
$sql_penerbang_persens = "select IFNULL((SUM(TIME_TO_SEC(jam_ops_total))/\r\n (select IFNULL(SUM(jumlah),0) from tb_rencana_jam_lat_ops where YEAR(bulan) = '" . date("Y") . "'))*100,0) as persen_capai\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_daily_program d on (f.id_daily_program = d.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n left join tb_kode_latihan kl on (f.id_kode_latihan = kl.id)\r\n where c.id is not NULL\r\n ";
$hasil = $this->db->query($sql_penerbang_persens . " and YEAR(f.tanggal) = '" . date("Y") . "'")->row()->persen_capai;
$query = 100 - $hasil;
}
$data[] = array($row, floatval(round2Two($query)));
$total += floatval($query);
}
//return array('data' => $data, 'total' => $total);
$title = "Laporan Pencapaian Total Jam Terbang";
$result['jam_terbang'] = array('data' => $data, 'total' => $total, 'title' => $title);
die(json_encode($result));
}
?>
</td>
<td align="center"><?php
echo time_formation(sec_to_time($total_bln_ini));
?>
</td>
<td align="center"><?php
echo time_formation(sec_to_time($total_bln_bf));
?>
</td>
<td align="center"><?php
echo time_formation(sec_to_time($total_bln));
?>
</td>
<td align="center"><?php
echo round2Two($persen_tercapai);
?>
%</td>
<td></td>
</tr>
</tfoot>
</table>
<table>
<tr>
<td colspan="5"></td>
<td colspan="3" align="center">Komandan Skadron Udara 3</td>
</tr>
<tr>
<td colspan="5"></td>
<td colspan="3" align="center"></td>
</tr>
