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; }