<tr><td colspan="2">Tanggal</td><td>:</td><td colspan="3"><?php
echo tglindo($bcf15['ndkonfirmasidate']);
?>
</td></tr>
<tr><td colspan="7"><strong><hr size="2"></hr></strong></td></tr>
</table>
</td></tr>
<tr><td height="10" colspan="5"></td></tr>
<tr><td colspan="5"><p style="text-align: justify"> Sehubungan dengan surat <?php
echo $bcf15['Pemohon'];
?>
nomor <?php
echo $bcf15['SuratBatalNo'];
?>
tanggal <?php
echo tglindo($bcf15['SuratBatalDate']);
?>
perihal tersebut diatas, bersama ini disampaikan :</p></td></tr>
<tr><td height="10" colspan="5"></td></tr>
<tr><td valign="top" align="center" width="10">1.</td><td colspan="4"><font size="3" >Bahwa perusahaan tersebut mengajukan permohonan pembatalan BCF 1.5 atas importasi barang dengan data-data sebagai berikut :</font></td></tr>
<tr><td height="3" colspan="5"></td></tr>
<tr><td></td><td colspan="4">
<?php
$sqlkon = "SELECT * FROM bcf15, tpp WHERE bcf15.idtpp=tpp.idtpp and ndkonfirmasino='{$nond}' and tahun='{$tahun}'";
// memanggil data dengan id yang ditangkap tadi
$query = mysql_query($sqlkon);
while ($bcf15 = mysql_fetch_array($query)) {
echo "<table border='0' cellpadding='2' cellspacing='2' width='70%'>";
echo "<tr><td >Nama Importir</td><td colspan='3' >: ";
if ($bcf15['consignee'] == 'To Order') {
echo $bcf15['notify'];
<tbody>
<?php
while ($count < $rpp && $i < $tcount) {
mysql_data_seek($result, $i);
$data = mysql_fetch_array($result);
?>
<tr>
<td width="80px">
<?php
echo ++$no_urut;
?>
</td>
<td>
<?php
echo tglindo($data['tgl_rekam']);
?>
</td>
<td>
<?php
echo $data['judul_berita'];
?>
</td>
<td>
<?php
if ($data['status_berita'] == 0) {
echo "<span style='color:red'>unpublished</span>";
} else {
$j++;
} else {
echo "<tr class=highlight2>";
$j--;
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td class="isitabel"><?php
echo ucwords($data['bcf15no']);
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['bcf15tgl']);
?>
</td>
<td class="isitabel"><?php
if ($data['bamasukno'] == '') {
echo "<font color=blue>TPS :{$data['idtps']}</font>";
} else {
echo "<font color=red>TPP :{$data['nm_tpp']}</font>";
}
?>
</td>
<td class="isitabel"><?php
if ($data['consignee'] == "To Order") {
echo $data['notify'];
} elseif ($data['consignee'] == "to order") {
echo $data['notify'];
}
?>
</td>
<td align="center" class="isitabel"> <?php
if ($data['ndkonfirmasino'] == '') {
echo "";
} else {
echo $data['ndkonfirmasino'];
}
?>
</td>
<td align="center" class="isitabel"> <?php
if ($data['ndkonfirmasino'] == '') {
echo "";
} else {
echo tglindo($data['ndkonfirmasidate']);
}
?>
</td>
<td class="isitabel" align="center"><?php
if ($data['bamasukno'] == '') {
echo "Tidak Masuk TPP";
} else {
echo "{$selisih} Hari";
}
?>
</td>
<td align="center" class="isitabel"> <a href="?hal=validasitpp3&pilih=validasiview&id=<?php
echo ubah_teks($data['idbcf15']);
?>
echo $typecode['nm_type'];
} elseif ($typecode['idtypecode'] == "4") {
echo $typecode['nm_type'];
} elseif ($typecode['idtypecode'] == "5") {
echo $typecode['nm_type'];
} elseif ($typecode['idtypecode'] == "6") {
echo $typecode['nm_type'];
}
}
?>
</td></tr>
<tr><td >Nomor B/L</td><td colspan="2" valign="middle" >: <?php
echo $bcf15['blno'];
?>
/ <?php
echo tglindo($bcf15['bltgl']);
?>
</td></tr>
<tr><td >Jumlah / Jenis Barang</td><td colspan="2" valign="middle" >: <?php
echo $bcf15['amountbrg'];
?>
<?php
echo strtolower($bcf15['satuanbrg']);
?>
<?php
echo strtolower($bcf15['diskripsibrg']);
?>
</td></tr>
</table></td></tr>
<tr><td></td><td height="2" colspan="5"></td></tr>
<tr><td valign="top" >1.</td><td colspan="4" valign="top"><p style="text-align: justify">Berdasarkan pasal 65 Undang - Undang Nomor 10 Tahun 1995 tentang Kepabeanan sebagaimana diubah dengan Undang - Undang Nomor 17 Tahun 2006 dinyatakan sebagai Barang Yang Tidak Dikuasai, karena ditimbun di Tempat Penimbunan Sementara (TPS) yang melebihi jangka waktu 30 (tiga puluh) hari sejak tanggal penimbunan di TPS.</p></td></tr>
<?php
}
// penutup else
?>
<?php
$id = $_POST['id'];
// menangkap id
$sql = "SELECT konf_bcf15no,idbcf15,konf_tglkonftpp,nip_usertpp,ip_usertpp,nm_usertpp FROM kofirmasi_p2 where idbcf15='{$id}'";
$query = mysql_query($sql);
$data = mysql_fetch_array($query);
$tglsimpan = tglindo($data['konf_tglkonftpp']);
$cek = mysql_numrows($query);
if ($cek > 0) {
// echo "Data BCF 1.5 yang Dikonfirmasi";
// echo "<table class='isitabel data' width=50% bgcolor=#1f4265>";
// echo "<tr>";
// echo "<td><font color=#fff>Tgl Simpan</font></td>";
// echo "<td><font color=#fff>$data[konf_tglkonftpp]</font></td>";
// echo "</tr>";
// echo "<tr>";
// echo "<td><font color=#fff>Staf TPP</td>";
// echo "<td><font color=#fff> $data[nm_usertpp]/ NIP $data[nip_usertpp]</font></td>";
// echo "</tr>";
// echo "<tr>";
// echo "<td><font color=#fff>ip Computer</font></td>";
// echo "<td><font color=#fff>$data[ip_usertpp]</font></td>";
echo $bcf15['bcf15no'];
?>
Tanggal : <?php
echo tglindo($bcf15['bcf15tgl']);
?>
</td>
</tr>
<tr>
<td >BC 1.1 </td><td width="3">:</td>
<td >
<?php
echo $bcf15['bc11no'];
?>
/ <?php
echo tglindo($bcf15['bc11tgl']);
?>
/ Pos <?php
echo $bcf15['bc11pos'];
?>
/ Sub Pos : <?php
echo $bcf15['bc11subpos'];
?>
</td>
</tr>
<tr>
<td >Consignee </td><td width="3">:</td>
<td >
<?php
echo $bcf15['consignee'];
<font size="3">Jawaban Konfirmasi Manual Seksi Penindakan</font>
</td>
</tr>
<tr class="isitabel">
<td>
<font color="#000">No /Tgl Nota Dinas</font>
</td>
<td>
<font color="#000">:</font>
</td>
<td>
<?php
echo $data['konf_nondp2'];
?>
/ <?php
echo tglindo($data['konf_tglndp2']);
?>
</td>
</tr>
<tr class="isitabel">
<td>
<font color="#000">Seksi Penimbunan</font>
</td>
<td>
<font color="#000">:</font>
</td>
<td>
<?php
echo $data['idseksip2'];
?>
/ <?php
echo $data['bc11pos'];
?>
/ <?php
echo tglindo($data['bc11tgl']);
?>
</td>
</tr>
<tr>
<td class="judulform">Nomor/tgl BL</td><td class="judulform">:</td>
<td class="isitabel"><?php
echo $data['blno'];
?>
<?php
echo tglindo($data['bltgl']);
?>
</td>
</tr>
<tr>
<td class="judulform">Sarkut/Voy</td><td class="judulform">:</td>
<td class="isitabel"><?php
echo $data['saranapengangkut'];
?>
<?php
echo $data['voy'];
?>
</td>
$dc = 0;
}
if ($isi['desc'] == 'Overnight Trucking') {
$ov = $isi['total'];
} else {
$ov = 0;
}
$aone = $tch + $bong + dc + ov;
$vno = GetValue('code', 'master_truck', array('id' => 'where/' . $qdetail['vehicle_no'])) == '0' ? $qdetail['vehicle_no'] : GetValue('code', 'master_truck', array('id' => 'where/' . $qdetail['vehicle_no']));
$vname = GetValue('name', 'master_truck', array('id' => 'where/' . $qdetail['vehicle_no'])) == '0' ? $qdetail['vehicle_no'] : GetValue('name', 'master_truck', array('id' => 'where/' . $qdetail['vehicle_no']));
}
if ($jo != $isi['jo']) {
?>
<tr>
<td align="center" class="borderkirikanan"><span class=""><?php
echo tglindo($qdetail['create_date']);
?>
</span></td>
<td align="center" class="borderkirikanan"><span class=""><?php
echo $vno;
?>
</span></td>
<td align="center" class="borderkirikanan"><span class=""><?php
echo $isi['jo'];
?>
</span></td>
<td class="borderkirikanan"><?php
echo $qdetail['loading'] . ' - ' . $qdetail['unloading'];
?>
</div></td>
<td align="left" class="borderkirikanan"><?php
?>
</a></td>
</tr>
<tr>
<td class="isitabel" >Tanggal</td><td class="isitabel" width="1">:</td>
<td class="isitabel" ><?php
echo tglindo($bcf15['tglnd']);
?>
</td>
</tr>
<tr>
<td class="isitabel" >Tgl Lembur</td><td class="isitabel" width="1">:</td>
<td class="isitabel" ><?php
echo tglindo($bcf15['waktu_lembur']);
?>
</td>
</tr>
</table><br/>
<table width="100%" align="center" class="isitabel" bgcolor="#fff">
<tr>
<th class="judultabel">Nama </th>
<th class="judultabel">NIP</th>
<th class="judultabel">Gol.</th>
<th class="judultabel">Tempat Tugas</th>
} else {
echo "<tr class=highlight2>";
$j--;
}
?>
<td class="isitabel"><?php
echo $data['nond'];
?>
</td>
<td align="center" class="isitabel"><?php
echo tglindo($data['tglnd']);
?>
</td>
<td align="center" class="isitabel"><?php
echo tglindo($data['waktu_lembur']);
?>
</td>
<td align="center" class="isitabel"><?php
echo $data['nm_seksi'];
?>
</td>
<td align="center" class="isitabel"><a href="?hal=edit_lembur&id=<?php
echo $data[idndlembur];
?>
"><img src="images/new/update.png"/></a></td>
<td align="center" class="isitabel"><a href="?hal=indet_lembur&id=<?php
echo $data[idndlembur];
?>
"><img src="images/new/bc.png" width="20"/></a></td>
<td align="center" class="isitabel"><a href="?hal=cet_lembur&id=<?php
<form method="POST">
<table width="100%" border="0">
<tr>
<td colspan="5"><?php
include '../report/headersurat.html';
?>
</td>
</tr>
<tr><td width="9%">Nomor</td><td width="1%">:</td><td width="50%">NP-<?php
echo $bcfsurat['noagenda'];
?>
</td><td align="right"></td></tr>
<tr><td width="9%">Tanggal </td><td width="1%">:</td><td width="50%"><?php
echo tglindo($bcfsurat['tglagenda']);
?>
</td><td align="right"></td></tr>
<tr><td height="20"></td></tr>
</table>
<table>
<tr><td></td><td colspan="5">Yth. Pimpinan <?php
echo $bcfsurat['asalsurat'];
?>
</td></tr>
</table>
<table>
?>
</td>
<td class="isitabel" valign="top"><?php
echo $data['konf_bcf15no'];
?>
</td>
<td class="isitabel" valign="top"><?php
echo tglindo($data['konf_bcf15tgl']);
?>
</td>
<td class="isitabel" valign="top"><?php
echo $data['konf_bc11no'];
?>
</td>
<td class="isitabel" valign="top"><?php
echo tglindo($data['konf_bc11tgl']);
?>
</td>
<td class="isitabel" valign="top"><?php
echo $data['konf_bc11pos'];
?>
/ <?php
echo $data['konf_bc11psubpos'];
?>
</td>
<td class="isitabel" valign="top"><?php
echo $data['tglajudok'];
?>
</td>
<td class="isitabel" valign="top"><?php
echo $data['tgllengkap'];
<div id="hpage_latestnews">
<ul>
<?php
while ($count < $rpp && $i < $tcount) {
mysql_data_seek($result, $i);
$row_agenda = mysql_fetch_array($result);
?>
<li>
<p style="text-align: justify"><a href="index.php?route=agendapastbaca&id=<?php
echo $row_agenda['id_agenda'];
?>
"><strong><?php
echo $row_agenda['hal_agenda'];
?>
</strong> <small> - <?php
echo tglindo($row_agenda['tgl_agenda']);
?>
</small></a></p>
<p style="text-align: justify"><?php
echo strip_tags(limit_words($row_agenda['uraian_agenda'], 30));
?>
</p>
<p class="readmore"><a href="index.php?route=agendapastbaca&id=<?php
echo $row_agenda['id_agenda'];
?>
">Continue Reading »</a></p>
</li>
<?php
$i++;
$count++;
}
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td class="isitabel"><?php
echo $data['notifikasiadmin'];
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['tglmulainotif']);
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['tglakhirnotif']);
?>
</td>
<td class="isitabel"><?php
echo $data['nama_admin'];
?>
/ <?php
echo $data['nip_admin'];
?>
</td>
<td class="isitabel"><?php
echo $data['tglrekam'];
?>
</td>
<td class="isitabel"><?php
echo $data['statusnotif'];
<table border="0" width="100%">
<tr><td colspan="4" width="60%" ></td><td colspan="2">Lampiran</td></tr>
<tr><td colspan="4"></td><td colspan="2">Nota Dinas Kepala Seksi Tempat Penimbunan</td></tr>
<tr><td colspan="4"></td><td align="left">Nomor</td><td> : S-<?php
echo $bcf15['nond'];
if ($bcf15[kdseksi] == 'tpp3') {
echo "/KPU.01/BD.0503/";
} elseif ($bcf15[kdseksi] == 'tpp2') {
echo "/KPU.01/BD.0404/";
}
echo $tahunkini;
?>
</td></tr>
<tr><td colspan="4"></td><td align="left">Tanggal</td><td> : <?php
echo tglindo($bcf15['tglnd']);
?>
</td></tr>
<tr><td></td><td height="20" colspan="5"></td></tr>
<tr><td></td><td height="30" colspan="6"></td></tr>
</table>
<table class="data">
<tr>
<th class="judultabel">No.</th>
<th class="judultabel">Nama / NIP</th>
<th class="judultabel">Gol.</th>
<th class="judultabel">Tempat Tugas</th>
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td class="isitabel"><?php
echo ucwords($data['nm_lengkap']);
?>
</td>
<td class="isitabel"><?php
echo $data['nip_baru'];
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['tanggal']);
?>
</td>
<td class="isitabel"><?php
echo $data['jamin'];
?>
</td>
<td class="isitabel"><?php
echo $data['jamout'];
?>
</td>
</tr>
<?php
}
?>
<table width="100%" border="0" >
<tr>
<td width="150">Nomor BCF 1.5</td><td width="5">:</td><td><?php
echo $data['bcf15no'];
?>
tanggal <?php
echo tglindo($data['bcf15tgl']);
?>
</td>
</tr>
<tr>
<td >BC 1.1</td><td >:</td><td><?php
echo $data['bc11no'];
?>
tanggal <?php
echo tglindo($data['bc11tgl']);
?>
pos <?php
echo $data['bc11pos'];
?>
</td>
</tr>
</table>
<table width="50%" border="0" cellpadding="2" cellspacing="2">
<tr>
<th class="judultabel">Nomor</th>
<th class="judultabel">Ukuran </th>
while ($data = mysql_fetch_array($query)) {
if ($j == 0) {
// untuk membuat warna tiap row table berbeda dan warna berubah ketika mouse hover
echo "<tr class=highlight1>";
$j++;
} else {
echo "<tr class=highlight2>";
$j--;
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['tgl_libur']);
?>
</td>
<td class="isitabel"><?php
echo $data['keterangan_libur'];
?>
</td>
<td class="isitabel"><?php
echo $data['lamanya'];
?>
</td>
<td class="isitabel"><?php
echo $data['user_input'];
?>
/ <?php
echo $data['nip_user'];
$sql = "SELECT * FROM cuti WHERE idcuti='{$id}'";
$query = mysql_query($sql);
$data = mysql_fetch_array($query);
$tgl_cuti_awal = tglindo($data['tgl_cuti_awal']);
$tgl_cuti_akhir = tglindo($data['tgl_cuti_akhir']);
$alasan_cuti = $data['alasan_cuti'];
$kota_cuti = $data['kota_cuti'];
$nmatasanlangsung = $data['nmatasanlangsung'];
$nipatasanlangsung = $data['nipatasanlangsung'];
$jabatanatasanlangsung = $data['jabatanatasanlangsung'];
$nmpejabatberwenang = $data['nmpejabatberwenang'];
$nippejabatberwenang = $data['nippejabatberwenang'];
$jabatanpejabatberwenang = $data['jabatanpejabatberwenang'];
$tahuncuti = $data['tahuncuti'];
$lamacuti = $data['lamacuti'];
$tglinput = tglindo($data['tglinput']);
$iduser = $data['iduser'];
$seksi = $data['seksi'];
$bidang = $data['bidang'];
$sql1 = "SELECT * FROM user WHERE iduser='******'";
$query1 = mysql_query($sql1);
$data1 = mysql_fetch_array($query1);
$nm_lengkap = $data1['nm_lengkap'];
$nip_baru = $data1['nip_baru'];
$jabatan = $data1['jabatan'];
$pangkat = $data1['pangkat'];
$gol = $data1['gol'];
$document = file_get_contents("mintacuti.rtf");
$document = str_replace("%%nm_lengkap%%", $nm_lengkap, $document);
$document = str_replace("%%nip_baru%%", $nip_baru, $document);
$document = str_replace("%%jabatan%%", $jabatan, $document);
<td>Pos / Sub</td><td>:</td>
<td><?php
echo $bcf15['bc11pos'];
?>
/ <?php
echo $bcf15['bc11subpos'];
?>
</td>
</tr>
<tr>
<td>Surat Pemberitahuan</td><td>:</td>
<td><b><?php
echo $bcf15['suratno'];
?>
/ <?php
echo tglindo($bcf15['suratdate']);
?>
</b></td>
</tr>
<tr>
<td>Alasan Kembali</td><td>:</td>
<td>
<select name="kembali_pilihan" type="text" id="kembali_pilihan" value="" >
<option value="">::Pilih::</option>
<option value="Alamat Tidak Ditemukan">Alamat Tidak Dikenal</option>
<option value="Pindah Lokasi">Pindah Lokasi</option>
<option value="Ditolak">Pemilik Rumah Tidak Menerima</option>
<option value="ALamat Tidak Lengkap">Alamat Tidak Lengkap</option>
<option value="Tidak Diambil">Tidak Diambil</option>
</select>
?>
</td>
<td class="isitabel"><?php
echo $data['nm_pegawai'];
?>
</td>
<td class="isitabel"><?php
echo $data['noHp_pegawai'];
?>
</td>
<td class="isitabel"><?php
echo $data['Jen_kegiatan'];
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['tgl_kegiatan']);
?>
</td>
<td class="isitabel"><?php
echo $data['status_sms'];
?>
</td>
</tr>
<?php
}
?>
$j++;
} else {
echo "<tr class=highlight2>";
$j--;
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td align="center" class="isitabel"><?php
echo $data['nosp'];
?>
</td>
<td align="center" class="isitabel"><?php
echo tglindo($data['tglsp']);
?>
</td>
<td align="center" class="isitabel"><?php
echo $data['nm_tpp'];
?>
</td>
<td align="center" class="isitabel"><?php
echo $data['jumlah_bcf15'];
?>
</td>
<td align="center" class="isitabel"><?php
if ($data['name'] == '') {
echo "<font color=red>Tidak ada file</font>";
} else {
echo $data['notify'];
} else {
echo $data['consignee'];
}
?>
</td>
<td class="isitabel"><?php
echo $Dokumen2Code;
?>
</td>
<td class="isitabel"><?php
echo $data['Dokumen2No'];
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['Dokumen2Date']);
?>
</td>
<td class="isitabel" align="center"><?php
if ($data['bamasukno'] == '') {
echo "Tidak Masuk TPP";
} else {
echo "{$selisihtpp} Hari";
}
?>
</td>
<td class="isitabel" align="center"><?php
echo "{$selisihceisa} Hari";
?>
} elseif ($consignee == 'To The Order') {
$pemilik = $notify;
} else {
$pemilik = $consignee;
}
$bcf15no = $bcf15['bcf15no'];
$bcf15tgl = tglindo($bcf15['bcf15tgl']);
$bcf15tgl1 = $bcf15['bcf15tgl'];
$tahunbcf15 = substr($bcf15tgl1, 0, 4);
$bc11no = $bcf15['bc11no'];
$bc11tgl = tglindo($bcf15['bc11tgl']);
$bc11pos = $bcf15['bc11pos'];
$bc11subpos = $bcf15['bc11subpos'];
$bc11subpos = $bcf15['bc11subpos'];
$blno = $bcf15['blno'];
$bltgl = tglindo($bcf15['bltgl']);
$amountbrg = $bcf15['amountbrg'];
$satuanbrg = $bcf15['satuanbrg'];
$diskripsibrg = $bcf15['diskripsibrg'];
$satuanbrg = $bcf15['satuanbrg'];
$sqlseksi = "SELECT * FROM bcf15, seksi WHERE bcf15.idseksibukaposbc11ceisa=seksi.idseksi and idbcf15='{$id}' ";
// memanggil data dengan id yang ditangkap tadi
$queryseksi = mysql_query($sqlseksi);
$bcf15seksi = mysql_fetch_array($queryseksi);
$seksi = $bcf15seksi['nm_seksi'];
$nip = $bcf15seksi['nip'];
// $sql1 = "SELECT * FROM user WHERE iduser='******'";
// $query1 = mysql_query($sql1);
// $data1 = mysql_fetch_array($query1);
//
$sql = "SELECT max(idbcf15), nocontainer, idsize FROM bcfcontainer where idbcf15='{$bcf15['idbcf15']}'";
include '../../lib/koneksi.php';
include '../../lib/function.php';
//definisikan nama tpp
$sql1 = "SELECT * FROM bcf15,tpp where bcf15.idtpp=tpp.idtpp and bcf15.idtpp like '%{$tpp}%' and bcf15tgl between '{$txttgldari}' and '{$txttglsampai}' ";
$q1 = mysql_query($sql1);
$r1 = mysql_fetch_array($q1);
$title = "<font size='5' color='red'>Daftar BCF 1.5 " . $r1['nm_tpp'] . "</font><br/>";
$titleperiode = "<font size='5' color='red'>Periode tanggal {$txttgldari} and {$txttglsampai} </font>";
$content_header = "<table border='1'><tr><th>NoBCF1.5</th><th>TglBCF1.5</th><th>BC11</th><th>Tgl BC11</th><th>pos</th><th>No BL</th><th>Tgl BL</th><th>Sarkut</th><th>Voy</th><th>Jumlah</th><th>Satuan</th><th>Uraian Brg</th><th>Consignee</th><th>Notify</th><th bgcolor='red'>Dok Pengeluaran</th><th>No Dok</th><th>Tanggal</th><th bgcolor='red'>Dok Pengeluaran</th><th>No Dok</th><th>Tanggal</th><th bgcolor='green'>Status Akhir</th><th>Kep</th><th>Kep-BMN</th><th>Kep-BTD Lelang</th><th>Kep-BTD Musnah</th><th>NHP Lelang</th><th>Tgl NHP</th><th>Jatuh Tempo</th></tr>";
$content_footer = "</table>";
$content_dalam = "";
$content_footspasi = "<br/><br/>";
$content_footnote = "<table border='1'><tr><td colspan='2' >Daftar Kode Dok Pengeluaran</td><td colspan='2' >Status Akhir</td></tr><tr><th bgcolor='red'>Dokumen Pengeluaran</th><th bgcolor='red'>Uraian</th><th bgcolor='green' color='#fff'>Status Akhir</th><th color='#fff' bgcolor='green'>Uraian</th></tr>";
$content_footnote_kode = "<tr><td>1</td><td>SPPB</td><td>5</td><td>Siap Lelang</td></tr><tr><td>2</td><td>BC12</td><td>6</td><td>Lelang 1</td></tr><tr><td>4</td><td>BC23</td><td>7</td><td>Lelang 2</td></tr><tr><td>5</td><td>BC30</td><td>8</td><td>Musnah</td></tr><tr><td>9</td><td>BA Pemusnahan</td><td>9</td><td>BMN</td></tr><tr><td>11</td><td>ND Kasi Manifest</td><td>10</td><td>Re ekspor</td></tr><tr><td>12</td><td>PIB</td><td>11</td><td>Attensi Permohonan Tunda Lelang</td></tr><tr><td>13</td><td>PIBT</td><td>13</td><td>Laku Lelang</td></tr><tr><td>29</td><td>Returnable Package</td></tr></table>";
$sql = "SELECT * FROM bcf15 where idtpp like '%{$tpp}%' and bcf15tgl between '{$txttgldari}' and '{$txttglsampai}' ";
$q = mysql_query($sql);
while ($r = mysql_fetch_array($q)) {
$tglkini = date('Y-m-d');
$queryselisih = "select datediff('{$tglkini}', '{$r['bcf15tgl']}') as selisih";
$hasil = mysql_query($queryselisih);
$data = mysql_fetch_array($hasil);
$data = "<tr><td>" . $r['bcf15no'] . "</td><td>" . tglindo($r['bcf15tgl']) . "</td><td>" . $r['bc11no'] . "</td><td>" . tglindo($r['bc11tgl']) . "</td><td>" . $r['bc11pos'] . "</td><td>" . $r['blno'] . "</td><td>" . tglindo($r['bltgl']) . "</td><td>" . $r['saranapengangkut'] . "</td><td>" . $r['voy'] . "</td><td>" . $r['amountbrg'] . "</td><td>" . $r['satuanbrg'] . "</td><td>" . $r['diskripsibrg'] . "</td><td>" . $r['consignee'] . "</td><td>" . $r['notify'] . "</td><td>" . $r['DokumenCode'] . "</td><td>" . $r['DokumenNo'] . "</td><td>" . tglindo($r['DokumenDate']) . "</td><td>" . $r['Dokumen2Code'] . "</td><td>" . $r['Dokumen2No'] . "</td><td>" . tglindo($r['Dokumen2Date']) . "</td><td>" . $r['idstatusakhir'] . "</td><td>" . $r['NoKepStatus_Akhr'] . "</td><td>" . $r['KepBMNNo'] . "</td><td>" . $r['KepLelang1No'] . "</td><td>" . $r['KepMusnahNo'] . "</td><td>" . $r['NHPLelangNo'] . "</td><td>" . tglindo($r['NHPLelangDate']) . "</td><td>" . $data['selisih'] . " Hari</td></tr>";
$content_dalam = $content_dalam . "\n" . $data;
}
$content_sheet = $title . "\n" . $titleperiode . "\n" . $content_header . "\n" . $content_dalam . "\n" . $content_footer . "\n" . $content_footspasi . "\n" . $content_footnote . "\n" . $content_footnote_kode;
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=export to excel data BCF 1.5 di tpp.xls");
header("Pragma: no-cache");
header("Expires: 0");
print $content_sheet;
}
} elseif ($bcf15['jalur'] == '7') {
$jalur = 'Merah Mita Prioritas';
} elseif ($bcf15['jalur'] == '8') {
$jalur = 'Merah Mita Non Prioritas';
}
if ($bcf15['bamasukno'] == '') {
$notapencacahan = '';
} else {
$notapencacahan = "disertai Nota Hasil Pencacahan ";
}
$tps = $bcf15['idtps'];
$DokumenCode = $bcf15['DokumenCode'];
$DokumenNo = $bcf15['DokumenNo'];
$DokumenDate = tglindo($bcf15['DokumenDate']);
$Dokumen2No = $bcf15['Dokumen2No'];
$Dokumen2Date = tglindo($bcf15['Dokumen2Date']);
if ($DokumenCode == '27') {
$dokumen1 = "Dokumen Ekspor BC 1.2 nomor : {$Dokumen2No} tanggal {$Dokumen2Date} dan telah diterbitkan persetujuan re eksport nomor : {$DokumenNo} tanggal {$DokumenDate} ";
} elseif ($DokumenCode == '4') {
$dokumen1 = "Dokumen BC 2.3 nomor : {$DokumenNo} tanggal {$DokumenDate} dan telah diterbitkan SPPB nomor : {$Dokumen2No} tanggal {$Dokumen2Date} ";
} elseif ($DokumenCode == '5') {
$dokumen1 = "Dokumen BC 3.0 nomor : {$DokumenNo} tanggal {$DokumenDate} dan telah diterbitkan persetujuan re eksport nomor : {$Dokumen2No} tanggal {$Dokumen2Date} ";
} elseif ($DokumenCode == '12') {
$dokumen1 = "Dokumen Pemberitahuan PIB nomor : {$DokumenNo} tanggal {$DokumenDate} dan telah diterbitkan SPPB nomor : {$Dokumen2No} tanggal {$Dokumen2Date} ";
} elseif ($DokumenCode == '13') {
$dokumen1 = "Dokumen Pemberitahuan PIBK nomor : {$DokumenNo} tanggal {$DokumenDate} dan telah diterbitkan SPPB nomor : {$Dokumen2No} tanggal {$Dokumen2Date} ";
} elseif ($DokumenCode == '11') {
$dokumen1 = "dengan nota dinas Kepala Seksi Ad. Manifest nomor : {$Dokumen2No} tanggal {$Dokumen2Date} perihal permohonan pengeluaran returnable package ";
} elseif ($DokumenCode == '30') {
$dokumen1 = "dengan nota dinas Kepala Seksi Ad. Manifest nomor : {$Dokumen2No} tanggal {$Dokumen2Date} perihal permohonan pengeluaran returnable package ";
}
$j++;
} else {
echo "<tr class=highlight2 >";
$j--;
}
?>
<td align="center" class="isitabel"><?php
echo $awal++;
?>
</td>
<td class="isitabel"><?php
echo $data['konf_bcf15no'];
?>
</td>
<td class="isitabel"><?php
echo tglindo($data['konf_bcf15tgl']);
?>
</td>
<td class="isitabel"><?php
echo $data['consignee'];
?>
</td>
<td class="isitabel"><?php
echo $data['notify'];
?>
</td>
<td align=center class="isitabel"><?php
echo $respon;
?>
</td>
<td class="isitabel"><?php
<table border="0" bgcolor="#98badd">
<tr>
<td>No BCF 1.5</td><td>:</td><td><?php
echo $bcf15['bcf15no'];
?>
/ <?php
echo tglindo($bcf15['bcf15tgl']);
?>
</td>
</tr>
<tr>
<td>No Agenda Pembatalan(Surat Pembatalan)<td>:</td><td><?php
echo $bcf15['SetujuBatalNo'];
?>
/ <?php
echo tglindo($bcf15['SetujuBatalDate']);
?>
</td>
</tr>
<tr>
<td colspan="3"><input type="hidden" name="MAX_FILE_SIZE" value="30000000000000" />
Pilih File PDF: <input size="50" name="userfile" type="file" />
</tr>
<tr>
<td colspan="3" align="center"><input class="button putih bigrounded " type="submit" name="addsubmit" value="Upload" /></td>
</tr>
<tr>