function get_list_jam_logbook($id_penerbang, $bulan)
{
$q = NULL;
if (!empty($bulan) and $bulan !== 'undefined') {
$bulan = explode('-', $bulan);
$bln = $bulan[0] . '-' . $bulan[1];
$q .= " and f.tanggal like ('%{$bln}%')";
}
$sql = "select f.*, jl.nama as exercise,\r\n " . $id_penerbang . " as id_pnbf, pb1.id as id_nrp1, pb1.nama as nrp1, IFNULL(pb2.id, '') as id_nrp2, \r\n IFNULL(pb2.nama,'') as nrp2, pb1. yll, pb1.dff, pb1.dfd, pb1.nff, pb1.nfd,\r\n p.nama as pesawat, p.kode_tail, IFNULL(SUBSTR(c.jam_ops_total,1,5),'-') as total\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 join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n left join tb_penerbang pb2 on (c.id_penerbang_bs = pb2.id)\r\n join tb_kode_latihan kl on (f.id_kode_latihan = kl.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n left join tb_rencana_jam_lat_ops rj on (rj.id_kode_latihan = kl.id)\r\n where (c.id_penerbang_bs = '" . $id_penerbang . "' or c.id_penerbang_fs = '" . $id_penerbang . "')\r\n and c.jam_ops_total != '00:00:00' and c.jam_ops_total is not NULL\r\n {$q} order by f.tanggal asc\r\n ";
//echo "<pre>".$sql."</pre>"; die;
$result = $this->db->query($sql)->result();
foreach ($result as $key => $value) {
$sql_child = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.jam_ops_total))),1,5),'-') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and dp.time_start between '07:00' and '17:00'\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->day_first = $this->db->query($sql_child)->row()->total;
$sql_child2 = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.jam_ops_total))),1,5),'-') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_bs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and dp.time_start between '07:00' and '17:00'\r\n and f.id = '" . $value->id . "'\r\n ";
//echo $sql_child2; die;
$result[$key]->day_dual = $this->db->query($sql_child2)->row()->total;
$sql_child3 = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.jam_ops_total))),1,5),'-') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->night_first = $this->db->query($sql_child3)->row()->total;
$sql_child4 = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.jam_ops_total))),1,5),'-') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_bs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->night_dual = $this->db->query($sql_child4)->row()->total;
/*TOTAL ALL AS FIRST PILOT*/
$sql_child5 = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.jam_ops_total))),1,5),'-') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->all_first = $this->db->query($sql_child5)->row()->total;
$sql_child6 = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.inst_sim))),1,5),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->instrumen_sim = $this->db->query($sql_child6)->row()->total;
$sql_child6a = "select IFNULL(SUBSTR(SEC_TO_TIME(SUM(TIME_TO_SEC(c.inst_act))),1,5),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and pb1.id = '" . $value->id_pnbf . "'\r\n and f.id = '" . $value->id . "'\r\n ";
$result[$key]->instrumen_act = $this->db->query($sql_child6a)->row()->total;
// GET Instruktor
$sql_check_instruktor = "select id_penerbang_inst as id from tb_instruksi_penerbang where id_flight_formasi = '" . $value->id . "'";
$get_instruktor = $this->db->query($sql_check_instruktor)->row();
$sql_child7 = "select ip.id_penerbang_inst, IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and dp.time_start between '07:00' and '17:00'\r\n and f.id = '" . $value->id . "'\r\n ";
// backup // and (ip.id_penerbang_inst = '".$value->id_nrp1."' or ip.id_penerbang_inst = '".$value->id_nrp2."')
$where_instruktor = NULL;
$result[$key]->instruktor_day = '00:00';
$result[$key]->id_instruktor_day = $this->db->query($sql_child7 . $where_instruktor)->row()->id_penerbang_inst;
if (isset($get_instruktor->id) and $get_instruktor->id === $id_penerbang) {
$where_instruktor = " and ip.id_penerbang_inst = '" . $id_penerbang . "'";
$result[$key]->instruktor_day = $this->db->query($sql_child7 . $where_instruktor)->row()->total;
}
$sql_child8 = "select ip.id_penerbang_inst, IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal = '" . $value->tanggal . "' \r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and f.id = '" . $value->id . "'\r\n and (ip.id_penerbang_inst = '" . $value->id_nrp1 . "' or ip.id_penerbang_inst = '" . $value->id_nrp2 . "')";
if ($key === 23) {
//echo $value->tanggal.' '.$sql_child8; die;
}
$result[$key]->instruktor_night = '00:00';
$result[$key]->id_instruktor_night = $this->db->query($sql_child8 . $where_instruktor)->row()->id_penerbang_inst;
if (isset($get_instruktor->id) and $get_instruktor->id === $id_penerbang) {
$where_instruktor = " and ip.id_penerbang_inst = '" . $id_penerbang . "'";
$result[$key]->instruktor_night = $this->db->query($sql_child8 . $where_instruktor)->row()->total;
}
}
$data['data'] = $result;
/*DETAIL BULAN SEBELUMNYA*/
$date = explode('-', $bln);
$lm = mktime(0, 0, 0, $date[1] - 1, date("01"), $date[0]);
// last month
$bulan_lalu = date("Y-m-d", $lm);
$sql_before = "select *, SUM(dff+dfd+nff+nfd) as total\r\n from tb_logbook_carried_forward\r\n where bulan = '" . $bulan_lalu . "'\r\n and id_penerbang = '" . $id_penerbang . "'";
$dflm = $this->db->query($sql_before)->row();
$data['day_first_lm'] = sec_to_time($dflm->dff);
$data['day_dual_lm'] = sec_to_time($dflm->dfd);
$data['night_first_lm'] = sec_to_time($dflm->nff);
$data['night_dual_lm'] = sec_to_time($dflm->nfd);
$data['flight_lm'] = sec_to_time($dflm->total);
$data['first_lm'] = sec_to_time($dflm->dff + $dflm->nff);
$sql_before7 = "select IFNULL(concat(floor(TIME_TO_SEC(pb1.inst_sim)/3600),':',floor(TIME_TO_SEC(pb1.inst_sim )/60)%60),'00:00') as inst_sim, \r\n IFNULL(concat(floor(SUM(TIME_TO_SEC(c.inst_sim))/3600),':',floor(SUM(TIME_TO_SEC(c.inst_sim ))/60)%60),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal < '" . $bln . "-01' \r\n and pb1.id = '" . $id_penerbang . "'\r\n ";
//echo $sql_before7;
$inst_sim = $this->db->query($sql_before7)->row();
$data['instrumen_lm_sim'] = sec_to_time(detik($inst_sim->total) + detik($inst_sim->inst_sim));
$sql_before7a = "select IFNULL(concat(floor(TIME_TO_SEC(pb1.inst_act)/3600),':',floor(TIME_TO_SEC(pb1.inst_act )/60)%60),'00:00') as inst_act, IFNULL(concat(floor(SUM(TIME_TO_SEC(c.inst_act))/3600),':',floor(SUM(TIME_TO_SEC(c.inst_act ))/60)%60),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal < '" . $bln . "-01' \r\n and pb1.id = '" . $id_penerbang . "'\r\n ";
$inst_act = $this->db->query($sql_before7a)->row();
$data['instrumen_lm_act'] = sec_to_time(detik($inst_act->total) + detik($inst_act->inst_act));
$sql_before8 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total,\r\n (select instruksi_day from tb_penerbang where id = '" . $id_penerbang . "') as inst_init\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal < '" . $bln . "-01' \r\n and dp.time_start between '07:00' and '17:00'\r\n and ip.id_penerbang_inst = '" . $id_penerbang . "'";
$inst_day = $this->db->query($sql_before8)->row();
$data['day_instruktor_lm'] = sec_to_time(detik($inst_day->total) + $inst_day->inst_init);
$sql_before9 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total,\r\n (select instruksi_night from tb_penerbang where id = '" . $id_penerbang . "') as inst_init\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal < '" . $bln . "-01' \r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and ip.id_penerbang_inst = '" . $id_penerbang . "'";
//echo $sql_before9;
$inst_night = $this->db->query($sql_before9)->row();
$data['night_instruktor_lm'] = sec_to_time(detik($inst_night->total) + $inst_night->inst_init);
/*TOTAL LICA*/
$sql_total = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and dp.time_start between '07:00' and '17:00'\r\n and pb1.id = '" . $id_penerbang . "'";
$data['day_first_total'] = $this->db->query($sql_total)->row()->total;
$sql_total2 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_bs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and dp.time_start between '07:00' and '17:00'\r\n and pb1.id = '" . $id_penerbang . "'";
$data['day_dual_total'] = $this->db->query($sql_total2)->row()->total;
$sql_total3 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and pb1.id = '" . $id_penerbang . "'";
$data['night_first_total'] = $this->db->query($sql_total3)->row()->total;
$sql_total4 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_bs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and pb1.id = '" . $id_penerbang . "'";
$data['night_dual_total'] = $this->db->query($sql_total4)->row()->total;
$sql_total5 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n left join tb_penerbang pb2 on (c.id_penerbang_bs = pb2.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and (pb1.id = '" . $id_penerbang . "' or pb2.id = '" . $id_penerbang . "')";
$data['flight_total'] = $this->db->query($sql_total5)->row()->total;
$sql_total6 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(c.jam_ops_total ))/60)%60),'00:00') as total\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 dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and pb1.id = '" . $id_penerbang . "'";
$data['first_total'] = $this->db->query($sql_total6)->row()->total;
$sql_total7 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.inst_sim))/3600),':',floor(SUM(TIME_TO_SEC(c.inst_sim ))/60)%60),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and pb1.id = '" . $id_penerbang . "'\r\n ";
$data['instrumen_total_sim'] = $this->db->query($sql_total7)->row()->total;
$sql_total7a = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(c.inst_act))/3600),':',floor(SUM(TIME_TO_SEC(c.inst_act))/60)%60),'00:00') as total\r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n join tb_jenis_latihan jl on (f.id_jenis_latihan = jl.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (c.id_pesawat = p.id)\r\n join tb_penerbang pb1 on (c.id_penerbang_fs = pb1.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and pb1.id = '" . $id_penerbang . "'\r\n ";
$data['instrumen_total_act'] = $this->db->query($sql_total7a)->row()->total;
$sql_total8 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and dp.time_start between '07:00' and '17:00'\r\n and ip.id_penerbang_inst = '" . $id_penerbang . "'";
$data['day_instruktor_total'] = $this->db->query($sql_total8)->row()->total;
$sql_total9 = "select IFNULL(concat(floor(SUM(TIME_TO_SEC(ip.jam_ops_total))/3600),':',floor(SUM(TIME_TO_SEC(ip.jam_ops_total ))/60)%60),'00:00') as total\r\n from tb_instruksi_penerbang ip\r\n join tb_flight_formasi f on (ip.id_flight_formasi = f.id)\r\n join tb_daily_program dp on (f.id_daily_program = dp.id)\r\n join tb_pesawat p on (ip.id_pesawat = p.id)\r\n where f.tanggal <= '" . $bln . "-31' \r\n and (dp.time_start between '17:00' and '24:00' or dp.time_start between '00:01' and '05:00')\r\n and ip.id_penerbang_inst = '" . $id_penerbang . "'";
$data['night_instruktor_total'] = $this->db->query($sql_total9)->row()->total;
$data['penerbang'] = $this->db->get_where('tb_penerbang', array('id' => $id_penerbang))->row();
//die(json_encode($data));
return $data;
}
$nfd = $v->night_first;
}
}
$accu_dff = $dff !== '-' ? $dff : '00:00';
$accu_nff = $nff !== '-' ? $nff : '00:00';
$accu_dfd = $dfd !== '-' ? $dfd : '00:00';
$accu_nfd = $nfd !== '-' ? $nfd : '00:00';
$day_first_total += detik($accu_dff . ':00');
$day_dual_total += detik($accu_dfd . ':00');
$nig_first_total += detik($accu_nff . ':00');
$nig_dual_total += detik($accu_nfd . ':00');
$inst_sim_total += detik(time_formation($v->instrumen_sim) . ':00');
$inst_act_total += detik(time_formation($v->instrumen_act) . ':00');
$inst_fly_day += detik(time_formation($v->instruktor_day) . ':00');
$inst_fly_night += detik(time_formation($v->instruktor_night) . ':00');
$first_pilot = detik($accu_dff . ':00') + detik($accu_nff . ':00');
$first_total += $first_pilot;
?>
<tr>
<td align="center"><?php
echo ++$key;
?>
</td>
<td align="center"><?php
echo $prethel[1];
?>
</td>
<td align="center"><?php
echo $tgl[2];
?>
</td>
function save_penerbang()
{
$id = post_safe('id');
$pangkat = post_safe('pangkat');
$nama = post_safe('nama');
$kode = post_safe('kode');
$kode_dragon = post_safe('kode_dragon');
$jabatan = post_safe('jabatan');
$rating = post_safe('rating');
$prop = post_safe('prop');
$tanggal = post_safe('tanggal');
$yll = post_safe('yll');
$dff = post_safe('dff');
$dfd = post_safe('dfd');
$nff = post_safe('nff');
$nfd = post_safe('nfd');
$inst_day = post_safe('inst_fly_day');
$inst_nig = post_safe('inst_fly_night');
$inst_sim = post_safe('inst_fly_sim');
$inst_act = post_safe('inst_fly_act');
$kualifikasi = post_safe('kualifikasi');
// array
$UploadDirectory = 'assets/images/penerbang/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
$time = $prop . ':00';
$parsed = explode(':', $time);
$seconds = $parsed[0] * 3600 + $parsed[1] * 60 + $parsed[2];
$data = array('id' => $id, 'id_pangkat' => $pangkat, 'nama' => $nama, 'kode_nrp' => $kode, 'kode_dragon' => $kode_dragon, 'id_jabatan' => $jabatan !== '' ? $jabatan : NULL, 'rating_pesawat' => $rating, 'total_propeler' => $seconds, 'tahun' => $tanggal !== '' ? date2mysql($tanggal) : NULL, 'inst_sim' => '', 'yll' => detik($yll), 'dff' => detik($dff), 'dfd' => detik($dfd), 'nff' => detik($nff), 'nfd' => detik($nfd), 'instruksi_day' => detik($inst_day), 'instruksi_night' => detik($inst_nig), 'inst_sim' => $inst_sim, 'inst_act' => $inst_act);
if ($id === '') {
$this->db->insert('tb_penerbang', $data);
$result['act'] = 'add';
$result['id'] = $this->db->insert_id();
foreach ($kualifikasi as $kual) {
$this->db->insert('tb_kualifikasi_penerbang', array('id_penerbang' => $result['id'], 'id_kualifikasi' => $kual));
}
$param = array('id_penerbang' => $result['id'], 'bulan' => $tanggal !== '' ? date2mysql($tanggal) : NULL, 'dff' => detik($dff), 'dfd' => detik($dfd), 'nff' => detik($nff), 'nfd' => detik($nfd));
$this->m_transaksi->save_jam_logbook($param);
} else {
$this->db->where('id', $id);
$this->db->update('tb_penerbang', $data);
$this->db->delete('tb_kualifikasi_penerbang', array('id_penerbang' => $id));
$result['act'] = 'edit';
$result['id'] = $id;
if (is_array($kualifikasi)) {
foreach ($kualifikasi as $kual) {
$this->db->insert('tb_kualifikasi_penerbang', array('id_penerbang' => $result['id'], 'id_kualifikasi' => $kual));
}
}
$param = array('id_penerbang' => $id, 'bulan' => $tanggal !== '' ? date2mysql($tanggal) : NULL, 'dff' => detik($dff), 'dfd' => detik($dfd), 'nff' => detik($nff), 'nfd' => detik($nfd));
$this->m_transaksi->save_jam_logbook($param);
}
if (isset($_FILES['mFile']['name'])) {
$foto = post_safe('gambar');
$FileName = strtolower($_FILES['mFile']['name']);
//uploaded file name
//$FileTitle = $FileName;
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['mFile']['type'];
//file type
//$FileSize = $_FILES['mFile']["size"]; //file size
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
//$uploaded_date = date("Y-m-d H:i:s");
if ($foto !== '') {
@unlink('assets/images/penerbang/' . $foto);
}
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
// case 'application/pdf': //PDF file
// case 'application/msword': //ms word file
// case 'application/vnd.ms-excel': //ms excel file
// case 'application/x-zip-compressed': //zip file
// case 'text/plain': //text file
// case 'text/html': //html file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data['nama']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['mFile']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_penerbang', array('foto' => $NewFileName));
} else {
die('error uploading File!');
}
}
return $result;
}
