echo $i; ?> </td> <td><?php echo $tr['USER_ID']; ?> </td> <td><!--a href='index.php?page=form-data-utama-lpj&lpj_id=<?php echo $tr['LPJ_ID']; ?> '--><?php echo $tr['LPJ_NAMA_KEG']; ?> <!--/a--></td> <td style='text-align: right;'><?php echo get_nama_bulan(substr($tr['LPJ_WAKTU_KEG'], 0, 2)) . " " . substr($tr['LPJ_WAKTU_KEG'], 3, 4); ?> </td> <td class='center'><a class='ico ico-Download' href='download-arsip-lpj.php?lpj_id=<?php echo $tr['LPJ_ID']; ?> ' title='Download arsip LPJ'></a> <?php if (is_pengelola_lpj($tr['LPJ_ID'], $_SESSION['login_session']['user_id'])) { ?> <a class='ico ico-Delete' href='hapus-arsip-lpj.php?lpj_id=<?php echo $tr['LPJ_ID']; ?> ' title='Hapus hanya arsip LPJ'></a><?php } else { ?>
// Data Utama LPJ $query = "SELECT * FROM TB_DATA_LPJ WHERE LPJ_ID='{$lpj_id}'"; $result = mysql_query($query); $data_lpj = mysql_fetch_array($result); $waktu_keg_lpj = $data_lpj['LPJ_WAKTU_KEG']; $waktu_kegiatan = explode("-", $data_lpj['LPJ_WAKTU_KEG']); $id_bulan = $waktu_kegiatan[0]; $kode_rek_lpj = $data_lpj['LPJ_KODERING']; $nama_kegiatan = $data_lpj['LPJ_NAMA_KEG']; $bulan = get_nama_bulan($id_bulan); $tahun = $waktu_kegiatan[1]; $nama_organisasi = $data_lpj['LPJ_ORGANISASI']; $nama_unit_kerja = $data_lpj['LPJ_UNIT_KERJA']; $nama_program = $data_lpj['LPJ_PROGRAM']; $nomor_dppa = $data_lpj['LPJ_NO_DPPA']; $tgl_dppa = intval(substr($data_lpj['LPJ_TGL_DPPA'], 8, 2)) . ' ' . get_nama_bulan(substr($data_lpj['LPJ_TGL_DPPA'], 5, 2)) . ' ' . substr($data_lpj['LPJ_TGL_DPPA'], 0, 4); $tgl_update = date_format(date_create($data_lpj['LPJ_TGL_UPDATE']), 'j') . ' ' . $bulan . ' ' . $tahun; // Data LPJ Belanja $query = "SELECT * FROM TB_LPJ_BNDHRA_PNGLUARAN_PMBNTU WHERE LPJ_ID='{$lpj_id}'"; $result = mysql_query($query); $lpj_belanja = array(); while ($fetch = mysql_fetch_array($result)) { $lpj_belanja[] = $fetch; } // Data Penandatangan LPJ $query = "SELECT * FROM TB_PENANDATANGAN_LPJ WHERE LPJ_ID='{$lpj_id}'"; $result = mysql_query($query); $data_ptd = mysql_fetch_array($result); $penyerah_nip = nip_format($data_ptd['PENYERAH']); $penyerah = get_nama_pegawai($data_ptd['PENYERAH']); $penerima_nip = nip_format($data_ptd['PENERIMA']);