Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
bagaimana cara eksport dari php ke excel tapi templatenya tidak ikut tereksport
saya mau mengeksport koding dibawah ini tapi templatenya tidak ikut tereksport juga. jadi hanya tabelnya aja yang dieksport.
kode :
<?php
session_start();
$login_in = false;
//jika session username belum dibuat, atau session username kosong
if (!isset($_SESSION['NIP']) || empty($_SESSION['NIP'])) {
//redirect ke halaman login
header('location:../formlogin.php');
}else{
$login_in = true;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- Meta, title, CSS, favicons, etc. -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Nominatif Pegawai</title>
<!-- Bootstrap core CSS -->
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link href="../fonts/css/font-awesome.min.css" rel="stylesheet">
<link href="../css/animate.min.css" rel="stylesheet">
<!-- Custom styling plus plugins -->
<link href="../css/custom.css" rel="stylesheet">
<link href="../css/icheck/flat/green.css" rel="stylesheet">
<link href="../css/datatables/tools/css/dataTables.tableTools.css" rel="stylesheet">
<script src="../js/jquery.min.js"></script>
<!--[if lt IE 9]>
<script src="../assets/js/ie8-responsive-file-warning.js"></script>
<![endif]-->
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<?php
include('../koneksi.php');
$limit = 100;
if(!empty($_GET['halaman'])){
$halmn = $_GET['halaman'];
if($halmn == "" || $halmn == "1")
{
$halmn1 = 0;
}else
{
$halmn1 = ($halmn*$limit)-$limit;
}
$ambil = "SELECT pegawai.Nama, pegawai.Tempat_Lahir, pegawai.Tanggal_lahir, pegawai.NIP, pegawai.Jenis_kelamin, pegawai.Agama, pegawai.Golongan_CPNS, pegawai.TMT_CPNS, pegawai.Tingkat_Ijasah, pegawai.Jurusan, pegawai.Nama_Sekolah, pegawai.Tahun_Sekolah,pegawai.Unit_Kerja, pegawai.Usia, pegawai.Masa_Kerja, pegawai.Alamat, pangkat.golongan_ruang, pangkat.TMT, jabatan.nama_jabatan, jabatan.TMT_jabatan, pensiun.TMT_Pensiun from pegawai JOIN pangkat on (pegawai.NIP=pangkat.NIP) JOIN jabatan on (pegawai.NIP=jabatan.NIP) JOIN pensiun ON (pegawai.NIP=pensiun.NIP) ORDER BY pegawai.NIP ASC limit $halmn1,$limit";
$mq = mysql_query($ambil,$connect);}
else
{
$ambil = "SELECT pegawai.Nama, pegawai.Tempat_Lahir, pegawai.Tanggal_lahir, pegawai.NIP, pegawai.Jenis_kelamin, pegawai.Agama, pegawai.Golongan_CPNS, pegawai.TMT_CPNS, pegawai.Tingkat_Ijasah, pegawai.Jurusan, pegawai.Nama_Sekolah, pegawai.Tahun_Sekolah,pegawai.Unit_Kerja, pegawai.Usia, pegawai.Masa_Kerja, pegawai.Alamat, pangkat.golongan_ruang, pangkat.TMT, jabatan.nama_jabatan, jabatan.TMT_jabatan, pensiun.TMT_Pensiun from pegawai JOIN pangkat on (pegawai.NIP=pangkat.NIP) JOIN jabatan on (pegawai.NIP=jabatan.NIP) JOIN pensiun ON (pegawai.NIP=pensiun.NIP) ORDER BY pegawai.NIP ASC limit 0,$limit";
$mq = mysql_query($ambil,$connect);}
?>
<body class="nav-md">
<div class="container body">
<div class="main_container">
<div class="col-md-3 left_col">
<div class="left_col scroll-view">
<!-- sidebar menu -->
<?php
include('../include/sidemenu.php');
?>
<!-- /sidebar menu -->
</div>
</div>
<!-- top navigation -->
<?php
include('../include/topnavigation.php');
?>
<!-- /top navigation -->
<!-- page content -->
<div class="right_col" role="main">
<div class="row tile_count">
<h3 > Laporan Nominatif Pegawai </h3>
</div>
<div class="clearfix"></div>
<div class="">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Tabel Data <small>Nominatif Pegawai</small></h2>
<button type="button" class="pull-right btn btn-round btn-success" onClick="window.location='cetaknominatif.php';">Cetak Excel</button>
<button type="button" class="pull-right btn btn-round btn-success" onclick="window.open('test.php', 'winpopup', 'toolbar=no,statusbar=no,menubar=no,resizable=yes,scrollbars=yes,width=300,height=400');" >Simpan</button>
<button type="button" class="pull-right btn btn-round btn-success" onClick="window.location='detaillnp.php';">Lihat Laporan</button>
<div class="clearfix"></div>
</div>
<div class="x_content">
<table id="tabel" class="table table-striped responsive-utilities jambo_table">
<thead>
<tr class="headings">
<th>No </th>
<th>Nama <br> TTL </th>
<th>NIP </th>
<th>Jenis Kelamin <br>Agama </th>
<th>Golongan CPNS <br>TMT </th>
<th>Golongan Ruang <br>TMT </th>
<th>Jabatan <br>TMT </th>
<th>Tingkat Ijazah <br>Jurusan/Prog.Studi <br>Nama Sekolah <br>Tahun </th>
<th>Latihan <br>Jabatan </th>
<th>Umur <br>Masa Kerja <br>Pensiun </th>
<th>Unit Kerja </th>
<th>Alamat </th>
</tr>
</thead>
<tbody>
<?php
if(!empty($_GET['halaman'])){
if ( $_GET['halaman']>1){
$no = ($_GET['halaman'] * $limit) - ($limit-1);}
else {
$no = 1;}
}
else
{
$no = 1;}
$i = 1;
while ($data = mysql_fetch_array($mq))
{
?>
<tr>
<td><?php echo $no;?></td>
<td>
<?php echo $data["Nama"]; ?> <br>
<?php echo $data["Tempat_Lahir"]; ?> <br>
<?php echo $data["Tanggal_lahir"]; ?>
</td>
<td><?php echo $data ["NIP"]; ?></td>
<td>
<?php echo $data["Jenis_kelamin"]; ?> <br>
<?php echo $data["Agama"]; ?>
</td>
<td>
<?php echo $data["Golongan_CPNS"]; ?> <br>
<?php echo $data["TMT_CPNS"]; ?>
</td>
<td>
<?php echo $data["golongan_ruang"]; ?> <br>
<?php echo $data["TMT"]; ?>
</td>
<td>
<?php echo $data["nama_jabatan"]; ?> <br>
<?php echo $data["TMT_jabatan"]; ?>
</td>
<td>
<?php echo $data["Tingkat_Ijasah"]; ?> <br>
<?php echo $data["Jurusan"]; ?> <br>
<?php echo $data["Nama_Sekolah"]; ?> <br>
<?php echo $data["Tahun_Sekolah"]; ?>
</td>
<td><?php
$np = $data["NIP"];
$qr = mysql_query("select nama_pelatihan, tahun from latihan_jabatan where NIP='$np'");
while ($a = mysql_fetch_array($qr)){
echo $a["nama_pelatihan"]; ?> <br>
<?php echo $a["tahun"]; ?> <br> <br>
<?php
}
?>
</td>
<td>
<?php echo $data["Usia"]; ?> <br>
<?php echo $data["Masa_Kerja"];?> <br>
<?php echo $data["TMT_Pensiun"]; ?>
</td>
<td><?php echo $data["Unit_Kerja"]; ?></td>
<td><?php echo $data["Alamat"]; ?></td>
</tr>
<?php
$i++;
$no++;
};
?>
</tbody>
</table>
</div>
</div>
</div>
<br />
<br />
<br />
</div>
</div>
<!-- footer content -->
<?php
include('../include/footer.php');
?>
<!-- /footer content -->
</div>
<!-- /page content -->
</div>
</div>
<script src="../js/bootstrap.min.js"></script>
<!-- chart js -->
<script src="../js/chartjs/chart.min.js"></script>
<!-- bootstrap progress js -->
<script src="../js/progressbar/bootstrap-progressbar.min.js"></script>
<script src="../js/nicescroll/jquery.nicescroll.min.js"></script>
<!-- icheck -->
<script src="../js/icheck/icheck.min.js"></script>
<script src="../js/custom.js"></script>
<!-- Datatables -->
<script src="../js/datatables/js/jquery.dataTables.js"></script>
<script src="../js/datatables/tools/js/dataTables.tableTools.js"></script>
<script>
$(document).ready(function () {
$('input.tableflat').iCheck({
checkboxClass: 'icheckbox_flat-green',
radioClass: 'iradio_flat-green'
});
});
var asInitVals = new Array();
$(document).ready(function () {
var oTable = $('#tabel').dataTable({
"oLanguage": {
"sSearch": "Search all columns:"
},
"aoColumnDefs": [
{
'bSortable': false,
'aTargets': [0]
} //disables sorting for column one
],
'iDisplayLength': 12,
"sPaginationType": "full_numbers",
"dom": 'T<"clear">lfrtip',
"tableTools": {
"sSwfPath": "../js/datatables/tools/swf/copy_csv_xls_pdf.swf"
}
});
$("tfoot input").keyup(function () {
/* Filter on the column based on the index of this element's parent <th> */
oTable.fnFilter(this.value, $("tfoot th").index($(this).parent()));
});
$("tfoot input").focus(function () {
if (this.className == "search_init") {
this.className = "";
this.value = "";
}
});
$("tfoot input").blur(function (i) {
if (this.value == "") {
this.className = "search_init";
this.value = asInitVals[$("tfoot input").index(this)];
}
});
});
</script>
</body>
</html>
0
2 Jawaban:
rada susah baca kodenya mas. Maksudya template apanya, di kode bagian yang mana?
0
jadi biasanya dalam homepage itu kan ada template yang dari bootsrap atau css.. jadi maksud saya ketika di export ke excell datanya itu hanya tabelnya saja templatenya tidak ikut terexport juga. gitu mas maksud saya. mohon bantuannya mas.. hehehehe
0