$topik = $data['topik'];
$topikid = $data['id'];
$tengah .= '<td width="305" valign="top"><div class="borderluar">
<h3 class="bg3"><a href="#">ARTIKEL ' . $topik . ' TERBARU</a></h3>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 ORDER BY id DESC LIMIT 0,1");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$oleh = $datas['user'];
$id = $datas['id'];
$judul = $datas['judul'];
$tgl = $datas['tgl'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$gambar = $datas['gambar'] == '' ? '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/news-default.jpg"height="60"width="80" alt="' . $datas['judul'] . '" />' : '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/' . $datas['gambar'] . '"height="60"width="80" alt="' . $datas['judul'] . '" />';
$tengah .= '<div class="borderdalam">
<div class="date">' . datetimes($tgl) . '</div>
<h4><a href="article-' . $seftitle . '.html" title="' . $judul . '">' . $datas['judul'] . '</a></h4>
' . $gambar . '' . limitTXT(strip_tags($datas[2]), 280) . '';
}
$tengah .= '</div>';
$tengah .= '<div class="box2"><ul>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE topik in(43) and publikasi=1 ORDER BY id DESC LIMIT 1,3");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$id = $datas['id'];
$judul = $datas['judul'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$tengah .= '<li><a href="article-' . $seftitle . '.html" title="' . $judul . '">' . $datas['judul'] . '</a></li>';
}
$tengah .= '</ul></div>';
$data_topik = $koneksi_db->sql_fetchrow($hasil_topik);
$datatt['tgl'] = datetimes($data['tgl']);
$gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg" alt="' . $data[1] . '"/>' : '<img src="mod/news/images/normal/' . $data['gambar'] . '" alt="' . $data[1] . '"/>';
echo '' . $gambar . '
<div class="info" >
<div class="headjud"><a href="article-' . AuraCMSSEO($data[1]) . '.html">' . $data['1'] . '</a></div>
<p class="headket">' . limitTXT(strip_tags($data[2]), 110) . '</p>
</div>
</div>';
}
// End Berita 03 ====================================================================================
// Berita 04 ====================================================================================
echo '<div id="fragment-4" class="ui-tabs-panel ui-tabs-hide">';
global $koneksi_db, $maxdata, $maxkonten;
$hasil = $koneksi_db->sql_query("SELECT * FROM `artikel` where publikasi='1' ORDER BY `id` DESC LIMIT 3,1");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$hasil_topik = $koneksi_db->sql_query("SELECT * FROM `topik` WHERE id='{$data['topik']}'");
$data_topik = $koneksi_db->sql_fetchrow($hasil_topik);
$datatt['tgl'] = datetimes($data['tgl']);
$gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg" alt="' . $data[1] . '"/>' : '<img src="mod/news/images/normal/' . $data['gambar'] . '" alt="' . $data[1] . '"/>';
echo '' . $gambar . '
<div class="info" >
<div class="headjud"><a href="article-' . AuraCMSSEO($data[1]) . '.html">' . $data['1'] . '</a></div>
<p class="headket">' . limitTXT(strip_tags($data[2]), 110) . '
</div>
</div>';
}
echo '</div>';
// End Berita 04 ====================================================================================
<table id="example"class="table table-striped table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>Tanggal</th>
<th>Keterangan</th>
<th>Aksi</th>
</tr>
</thead>';
$admin .= '<tbody>';
$s = mysql_query("SELECT * FROM `hrd_cuti`where karyawan='{$id}' order by tgl desc");
while ($datas = mysql_fetch_array($s)) {
$idphoto = $datas['id'];
$tgl = $datas['tgl'];
$cuti = $datas['cuti'];
$urutan = $no + 1;
$deleted = '<a href="admin.php?pilih=cuti&mod=yes&aksi=hapus_photo&id=' . $idphoto . '&idkary=' . $idkary . '" onclick="return confirm(\'Apakah Anda Ingin Menghapus Cuti Ini ?\')" style="color:red"><span class="btn btn-danger">Hapus</span></a>';
$admin .= '
<tr align="left">
<td>
' . datetimes($tgl, False, false) . '
</td>
<td>
' . $cuti . '
</td>
<td>
' . $deleted . '
</td></tr>';
}
$admin .= '</table>';
}
echo $admin;
$admin .= '<option value="' . $datas['user'] . '"' . $pilihan . '>' . $datas['user'] . '</option>';
}
$admin .= "\n</select>";
}
/////////////////////////////////////
$admin .= '</td><td><input type="submit" name="submit" value="Lihat" class="submit" /></form></td>';
$admin .= '</tr></table></div>';
if (isset($_POST['submit'])) {
$DariTanggal = $_POST[DariTanggal];
$SampaiTanggal = $_POST[SampaiTanggal];
$cabang = $user;
if ($LevelAkses == 'Administrator') {
$cabang = $_POST[cabang];
}
$admin .= '<div class="border">';
$admin .= "<table><tr><td valign='top'>Dari : " . datetimes($_POST[DariTanggal]) . ", Sampai : " . datetimes($_POST[SampaiTanggal]) . "</td><td>,Cabang : {$cabang}</td>";
/*
$admin .='<td><form method="post" action="mod/bukukas/cetakbukukas.php" id="postscetak">';
$admin .="<input type='hidden' name='DariTanggal' value='$DariTanggal' size='53'>
<input type='hidden' name='SampaiTanggal' value='$SampaiTanggal' size='53'>";
$admin .='<input type="submit" name="submit" value="Cetak" class="submit" /></form></td>';*/
$admin .= "</tr></table>";
$admin .= '</div>';
// daftar bukujadwal
$no = 1;
$limit = $maxadmindata;
if ($LevelAkses == 'Administrator') {
$total = $koneksi_db->sql_query("SELECT * FROM bukujadwal WHERE tgl BETWEEN '{$_POST['DariTanggal']}' AND '{$_POST['SampaiTanggal']}'and user ='******'cabang']}' ORDER BY `tgl` asc");
} else {
$total = $koneksi_db->sql_query("SELECT * FROM bukujadwal WHERE tgl BETWEEN '{$_POST['DariTanggal']}' AND '{$_POST['SampaiTanggal']}' and user ='******' ORDER BY `tgl` asc");
}
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Tgl Posting</th>
<th colspan="2" style="text-align:center;padding:10px 5px 10px0 5px;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;width:100px;">Aksi</th>
</tr>';
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$gambar = $data['gambar'];
if ($gambar) {
$urlgambar = ' -
<a href="mod/news/images/normal/' . $data['gambar'] . '" rel="lightbox[roadtrip]">
Gambar</a>';
}
$deleted = '<a href="?pilih=news&mod=yes&aksi=delnews&id=' . $data['id'] . '" onclick="return confirm(\'semua Komentar pada Artikel ini akan dihapus, Apakah Anda Ingin Menghapus Data Ini ?\')" style="color:red"><img src="images/delete.gif"></a>';
$topik = $data["topik"];
$hasil2 = $koneksi_db->sql_query("SELECT * FROM topik WHERE id={$topik}");
$data2 = $koneksi_db->sql_fetchrow($hasil2);
$topik2 = $data2["topik"];
$data_tgl = datetimes($data['tgl'], false, false);
$admin .= '
<tr>
<td style="text-align:left;width:10px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;" valign="top">' . $no . '</td>
<td style="width:20px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;" valign="top"><input type=checkbox name=check' . $no . ' value=' . $data[0] . '></td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data[1] . '' . $urlgambar . ' </span></td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data_tgl . '</td>
<td style="text-align:center;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;width:5px;"><a href=admin.php?pilih=news&mod=yes&aksi=pubnews&id=' . $data[0] . '><img src="images/tidak.png"></a></td>
<td style="text-align:center;padding:5px;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;width:5px;">' . $deleted . ' <a href=admin.php?pilih=news&mod=yes&aksi=editnews&id=' . $data[0] . '&topik=' . $topik . '><img src="images/edit.gif"></a></td>
</tr>';
$no++;
}
$admin .= "<input type=hidden name='tot' value='{$jumlah}'>";
$admin .= "<tr><td style='text-align:left;padding:5px;border-right:1px solid #ccc;border-top:1px solid #ccc;'></td><td colspan=6 style='text-align:left;padding:5px;border-right:1px solid #ccc;border-top:1px solid #ccc;border-bottom:1px solid #ccc;border-left:1px solid #ccc;width:55px;'><input type='submit' value='delete' name='submit'></td></tr>";
$admin .= "</table>";
$admin .= "</form>";
$a = new paging($limit);
if (!$s1) {
$tengah .= '<div class="border">';
$tengah .= "Yang dicari <b>\"{$query}\"</b>";
$tengah .= '</div>';
$offset = int_filter(@$_GET['offset']);
$pg = int_filter(@$_GET['pg']);
$stg = int_filter(@$_GET['stg']);
$hasil2 = $koneksi_db->sql_query("SELECT * FROM artikel WHERE ((judul LIKE '%{$query}%' OR konten LIKE '%{$query}%' OR user LIKE '%{$query}%')AND publikasi=1) ORDER By id LIMIT {$offset},{$limit}");
$tengah .= '<div class="border">';
$tengah .= "Ditemukan <b>" . $jumlah . "</b> artikel mengandung kata: <b>{$query}</b>";
$tengah .= '</div>';
$tengah .= '<div class="border">';
while ($data = $koneksi_db->sql_fetchrow($hasil2)) {
$tengah .= "<p class=\"konten\"><a href=\"?pilih=news&mod=yes&aksi=lihat&id={$data['0']}\">{$data['1']}</a><br />";
$data[5] = datetimes($data['tgl']);
$tengah .= "<span class=\"keterangan\">{$data['5']} - by : <a href=\"?pilih=news&mod=yes&aksi=pesan&id={$data['0']}\">{$data['3']}</a></span></p>";
}
$tengah .= '</div>';
if ($jumlah >= 10) {
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$pg = 1;
}
if (empty($_GET['stg']) and !isset($_GET['stg'])) {
$stg = 1;
}
$tengah .= '<div class="border" style="text-align:center;">';
$tengah .= $a->getPaging($jumlah, $pg, $stg);
</div>
</form>
<td>';
$admin .= "</tr>";
}
$admin .= "</table></div>";
/*****************************************************/
if (isset($_POST['detail'])) {
$dateflag = $_POST['dateflag'];
$date = $_POST['date'];
$admin .= '<div class="col-md-6">';
$admin .= '<table class="table table-nonfluid">';
$admin .= '<tr><td colspan="6" align="center" class="bg-primary"><b>Detail Tanggal ' . $dateflag . '</b></td></tr>';
$query10 = "SELECT * FROM statistiksitus where dateflag = '{$date}' group by ip ORDER BY `id` DESC ";
$admin .= "\n <tr align='center'>\n <td><b>Tanggal</b></td>\n <td><b>IP</b></td>\n <td><b>OS</b></td>\n <td><b>Browser</b></td>\n <td><b>Hits</b></td>\n\t</tr>";
$hasil10 = mysql_query($query10);
while ($data10 = mysql_fetch_array($hasil10)) {
$dateflag = datetimes($data10['dateflag']);
$ip = $data10['ip'];
$os = $data10['os'];
$browser = $data10['browser'];
$gethits = gethits($data10['ip'], $data10['dateflag']);
$admin .= "\n <tr align='center'>\n <td>{$dateflag}</td>\n <td>{$ip}</td>\n <td>{$os}</td>\n <td>{$browser}</td>\n <td>{$gethits}</td>\n\t</tr>";
}
$admin .= '</table>';
$admin .= "</div>";
}
$admin .= "</div>";
}
}
echo $admin;
$data = $koneksi_db->sql_fetchrow($hasil);
$nip = $data['nip'];
$nama = $data['nama'];
$hasilb = $koneksi_db->sql_query("SELECT sum(bayar) as bayar FROM hrd_bayar where pid='{$pid}'");
$datab = $koneksi_db->sql_fetchrow($hasilb);
$bayar = $datab['bayar'];
//$cetak = '<a href="cetak_slip.php?id='.$idphoto.'&idkary='.$idkary.'" target="new"onclick="return confirm(\'Apakah Anda Ingin Mencetak Penggajian Ini ?\')" style="color:blue"><span class="btn btn-warning">Slip</span></a>';
$sisabayar = $pinjaman - $bayar;
if (!$bayar) {
$bayar = '0';
}
$admin .= '
<tr align="left">
<td class="text-center">' . $nip . '</td>
<td>' . $nama . '</td>
<td>' . datetimes($tgl, false, false) . '</td>
<td>' . $pinjaman . '</td>
<td>' . $bayar . '</td>
<td>' . $sisabayar . '</td>
</tr>';
$tsisabayar += $sisabayar;
$tpinjaman += $pinjaman;
$tbayar += $bayar;
}
$admin .= '</table>';
/*
$admin .= '<table width="100%">
<tr>
<td colspan="3">Jumlah</td>
<td>'.$tpinjaman.'</td>
<td>'.$tbayar.'</td>
$style_include[] = '
<style type="text/css">
/*<![CDATA[*/
.box{
padding: 20px;
display: none;
margin-top: 20px;
}
/*]]>*/
</style>';
$script_include[] = $JS_SCRIPT;
$tengah .= '<legend>Dashboard</legend>';
if ($_SESSION['LevelAkses']) {
$username = $_SESSION['UserName'];
$query = $koneksi_db->sql_query("SELECT * FROM useraura where user = '******'");
$data = $koneksi_db->sql_fetchrow($query);
$last_ping = datetimes($data['last_ping'], true);
#####################################
# Administrator
#####################################
if ($_SESSION['LevelAkses']) {
$tengah .= '<div class="border"><font style="color:#21759B;"><b>Last Login :</b> ' . $last_ping . '</font></div>';
$tengah .= '<div class="row">';
/////////////////////////////////////////////////////////////////////////////////////////////
$tengah .= '<div class="col-xs-6">';
/////////////////////////////////////////////////////////////////////////////////////////////
$tengah .= '</div>';
$tengah .= '</div>';
}
}
echo $tengah;
$fotolama = $data['foto'];
$admin .= '<form class="form-inline" method="post" action="" enctype ="multipart/form-data" id="posts">
<table class="table table-striped table-hover">
<tr>
<td>Foto</td>
<td></td>
</tr>';
if (!$fotolama) {
$fotolama = 'profile-default.jpg';
}
$admin .= '<tr>
<td></td>
<td><img src="mod/karyawan/images/normal/' . $fotolama . '" height="120">
<input type="hidden" name="fotolama" value="' . $fotolama . '"></td>
</tr>
<tr>
<td>NIP</td>
<td><input type="hidden" name="nip" value="' . $nip . '">' . $nip . '</td>
</tr>
<tr>
<td>Nama Lengkap</td>
<td>
<input type="hidden" name="nama" value="' . $nama . '">' . $nama . '
</td>
</tr>
<tr>
<td>Departemen</td>
<td><input type="hidden" name="departemen" value="' . $departemen . '">' . getdepartemen($departemen) . '</td>
</tr>
<tr>
<td>Jabatan</td>
<tr>
<td>Tanggal Akhir Percobaan</td>
<td>: ' . datetimes($tglpercobaan, False, false) . '</td>
</tr>';
}
if ($tglkontrak != '0000-00-00') {
echo '
<tr>
<td>Tanggal Akhir Kontrak</td>
<td>: ' . datetimes($tglkontrak, False, false) . '</td>
</tr>';
}
if ($tglresign != '0000-00-00') {
echo '<tr>
<td>Tanggal Resign</td>
<td>: ' . datetimes($tglresign, False, false) . '</td>
</tr>
<tr>
<td>Alasan</td>
<td>: ' . $alasan . '</td>
</tr>';
}
echo '
<tr>
<td>Account PaninBank</td>
<td>: ' . $norek . '</td>
</tr>
<tr>
<td>Nama Rek_Payroll</td>
<td>: ' . $namarek . '</td>
</tr>';
$datas = $koneksi_db->sql_fetchrow($s);
$nama = $datas['nama'];
$admin .= '<h5 class="bg">Bayar Hutang karyawan dengan nama <strong>' . $nama . '</strong></h5>';
if (isset($_POST['submit'])) {
define("GIS_GIF", 1);
define("GIS_JPG", 2);
define("GIS_PNG", 3);
define("GIS_SWF", 4);
include "includes/hft_image.php";
$nip = $_POST['nip'];
$tgl = $_POST['tgl'];
$bayar = $_POST['bayar'];
$tsisabayar = $_POST['tsisabayar'];
$total = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE nip = '" . $_POST['nip'] . "' and id != '" . $id . "'");
$jumlah = $koneksi_db->sql_numrows($total);
$error = '';
if ($jumlah) {
$error .= "Error: NIP karyawan {$nip} sudah ada di dalam database!<br />";
}
if (!$nip) {
$error .= "Error: NIP wajib diisi!<br />";
}
if (!$tgl) {
$error .= "Error: tanggal wajib diisi!<br />";
}
if (!$bayar) {
$error .= "Error: Bayar wajib diisi!<br />";
}
if ($bayar > $tsisabayar) {
$error .= "Error: Nilai Pembayaran lebih Besar dari Sisa yang harus dibayar!<br />";
}
if (file_exists($uploaddir)) {
@chmod($uploaddir, 0644);
}
$large = $normal2 . $simpan;
create_thumbnail($uploaddir, $large, $new_width = 600, $new_height = auto, $quality = 100);
unlink($uploaddir);
$nfotolama = $normal2 . $lampiranlama;
unlink($nfotolama);
$hasil = $koneksi_db->sql_query("update hrd_karyawan set tipe='{$tipe}',tglresign='{$tglresign}',alasan='{$alasan}',lampiran='{$simpan}' where id='{$id}'");
} else {
$hasil = $koneksi_db->sql_query("update hrd_karyawan set tipe='{$tipe}',tglresign='{$tglresign}',alasan='{$alasan}' where id='{$id}'");
}
}
}
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE id={$id}");
$data = $koneksi_db->sql_fetchrow($hasil);
$idkary = $data['id'];
$nip = $data['nip'];
$nama = text_filter($data['nama']);
$departemen = $data['departemen'];
$jabatan = $data['jabatan'];
$status = $data['status'];
$fotolama = $data['foto'];
$tipe = $data['tipe'];
$tglresign = $data['tglresign'];
$alasan = $data['alasan'];
$lampiran = $data['lampiran'];
$lampiranlama = $data['lampiran'];
$admin .= '<form class="form-inline" method="post" action="" enctype ="multipart/form-data" id="posts">
<table class="table table-striped table-hover">
<tr>
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$oleh = $data['user'];
$idperistiwa = $data['id'];
$judul = $data['judul'];
$tgl = $data['tgl'];
$seftitle = $data['seftitle'];
$konten = $data['konten'];
$link = $data['link'];
$query2 = $koneksi_db->sql_query("SELECT * FROM video WHERE peristiwa in({$idperistiwa}) ORDER BY id ASC LIMIT 0,1");
$datas2 = $koneksi_db->sql_fetchrow($query2);
//$gambar = '<iframe width="520" height="415" src="//www.youtube.com/embed/'.$link.'" frameborder="0" allowfullscreen></iframe>';
$gambar = '
<img src="http://img.youtube.com/vi/' . $link . '/0.jpg" width="300px" height="200px"/>';
$urutan = $no + 1;
$tengah .= '<td>
<div class="imgvideo">' . datetimes($tgl) . '<a href="detailvideo-' . AuraCMSSEO($judul) . '.html">' . $gambar . '</a><br>' . $judul . '</div></td>';
if ($urutan % 4 == 0) {
$tengah .= '</tr>';
}
$no++;
}
$tengah .= '</table>';
//end while
if ($jumlah > $limit) {
$tengah .= '<div class="border">';
$tengah .= "<center>";
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$pg = 1;
$tengah .= '</table>';
$tengah .= '</div>';
$tengah .= '</div>';
///////////////////////////////////////////////////////////////////////////
$tengah .= '<div class="col-xs-6">';
// baca tanggal sekarang
$tglNow = date("d");
// baca bulan sekarang
$blnNow = date("m");
// baca tahun-bulan-tanggal sekarang
$now = date("Y-m-d");
$hasil = $koneksi_db->sql_query("SELECT id,nip,nama,tgllahir,(year(curdate())-year(tgllahir)) as umur FROM hrd_karyawan WHERE MONTH(tgllahir) = '{$blnNow} '");
$tengah .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Reminder Ultah Bulan Ini</h3></div>
<table class="table">';
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$id = $data['id'];
$nip = $data['nip'];
$nama = $data['nama'];
$umur = $data['umur'];
$tgllahir = datetimes($data['tgllahir'], False, False);
$tengah .= "<tr><td>{$nama} - {$tgllahir} - {$umur} Tahun</td></tr>";
}
$tengah .= '</table>';
$tengah .= '</div>';
$tengah .= '</div>';
///////////////////////////////////////////////////////////////////////////
$tengah .= '</div>';
}
}
echo $tengah;
<?php
//include"admin/admin_situs.php";
if (!defined('AURACMS_CONTENT')) {
Header("Location: ../index.php");
exit;
}
global $koneksi_db;
$tengah .= '<h4 class="bg">Dashboard</h4>';
if (isset($_SESSION['LevelAkses'])) {
$username = $_SESSION['UserName'];
$query = $koneksi_db->sql_query("SELECT * FROM useraura where user = '******'");
$data = $koneksi_db->sql_fetchrow($query);
$last_ping = datetimes($data['last_ping'], false);
if ($_SESSION['LevelAkses'] == "Administrator") {
$tengah .= '<div class="border"><font style="color:#21759B;"><b>Last Login :</b> ' . $last_ping . '</font></div>';
$tengah .= '<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>';
$tengah .= '<td width="49%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #DFDFDF; border-radius:5px;">
<tr style="background:url(images/bg-tabel.png) top center repeat-x; font-family:Georgia; font-size:14px;">
<td style="text-align:left; padding:9px 10px 9px 10px; border-bottom:1px solid #DFDFDF;">Informasi Website</td>
</tr>';
$total = $koneksi_db->sql_query("SELECT * FROM halaman ");
$jumlah = $koneksi_db->sql_numrows($total);
$tengah .= '<tr>
<td style="padding:4px 10px 4px 10px; border-bottom:1px solid #DFDFDF;"><b>' . $jumlah . '</b> <a href="?pilih=admin_pages">Halaman</a></td>';
$total = $koneksi_db->sql_query("SELECT * FROM artikel where publikasi=1");
$jumlah = $koneksi_db->sql_numrows($total);
$tengah .= '<tr>
<td style="padding:4px 10px 4px 10px; border-bottom:1px solid #DFDFDF;"><b>' . $jumlah . '</b> <a href="?pilih=news&mod=yes"><font style="color:#008000;">Berita</font></a></td>';
$tengah .= '</tr>';
$total = $koneksi_db->sql_query("SELECT * FROM artikel where publikasi=0");
<th>Terisi</th>
<th>Benar</th>
<th>Salah</th>
<th>Nilai</th>
</tr></thead><tbody>';
$no = 1;
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$tgl = $data['tgl'];
$nilai = $data['nilai'];
$terisi = $data['terisi'];
$benar = $data['benar'];
$salah = $data['salah'];
$nama = getnamaguru($data['user']);
$admin .= '<tr>
<td><b>' . $no . '</b></td>
<td>' . datetimes($data['tgl']) . '</td>
<td>' . $data['jam'] . '</td>
<td>' . $nama . '</td>
<td>' . $terisi . '</td>
<td>' . $benar . '</td>
<td>' . $salah . '</td>
<td>' . $nilai . '</td>';
$admin .= '
</tr>';
$no++;
}
$admin .= '</tbody></table>';
}
$admin .= '</div><!-- /.box-body -->
</div><!-- /.box -->';
}
$konten = $data['konten'];
$link = $data['link'];
$topikid = $data['topik'];
$gambar = '<iframe width="600" height="420" src="//www.youtube.com/embed/' . $link . '" frameborder="0" allowfullscreen></iframe>';
//title
$judul_situs = '' . $data['judul'] . ' | ' . $judul_situs . '';
$_META['description'] = limittxt(htmlentities(strip_tags($konten)), 200);
$_META['keywords'] = empty($tags) ? implode(',', explode(' ', htmlentities(strip_tags($judulnya)))) : $tags;
if (empty($judulnya)) {
$tengah .= '<div class="error">Access Denied<br /><br>
Lihat...</div>';
$tengah .= '<meta http-equiv="refresh" content="3; url=index.php">';
} else {
$hits = $hits + 1;
$tengah .= '<br><br><h4 class="katphoto">' . $judulnya . '</h4>';
$tanggal = datetimes($data['tgl']);
$tengah .= '<div class="border"><span class="date">' . $tanggal . '</span></div>';
$tengah .= '<div class="border"><table>
<tr><td>' . $gambar . '</td></tr>
<tr><td>' . $konten . '</td></tr></table></div>';
$no = 0;
$query = $koneksi_db->sql_query("SELECT * FROM video_peristiwa WHERE id!= {$idperistiwa} order by id desc limit 3");
$jumlah = $koneksi_db->sql_numrows($query);
$tengah .= '<h4 class="katphoto">Video Lainnya</h4>';
$tengah .= '<table border="0" cellpadding="0" cellspacing="5"><tr align="left">';
while ($data2 = $koneksi_db->sql_fetchrow($query)) {
$urutan = $no + 1;
$idperistiwa = $data2['id'];
$judulnya = cleantext($data2['judul']);
$konten = $data2['konten'];
$link = $data2['link'];
$data = $koneksi_db->sql_fetchrow($hasil);
$topik = $data['topik'];
$topikid = $data['id'];
$tengah .= '<h4 class="bg">' . $topik . '</h4>';
$tengah .= '<table class="border" width="100%"><tr><td>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE topik in({$topikid}) and publikasi=1 ORDER BY id DESC LIMIT 0,1");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$oleh = $datas['user'];
$id = $datas['id'];
$judul = $datas['judul'];
$tgl = $datas['tgl'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$gambar = $datas['gambar'] == '' ? '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/news-default.jpg"height="60"width="80" title="' . $datas['judul'] . '" />' : '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/' . $datas['gambar'] . '"height="60"width="80" title="' . $datas['judul'] . '" />';
$tengah .= '<div class="date">' . datetimes($tgl) . '</div>
<h4><a href="article-' . $seftitle . '.html" title="' . $judul . '">' . $datas['judul'] . '</a></h4>
' . $gambar . '' . limitTXT(strip_tags($datas[2]), 280) . '';
}
$tengah .= '<div class="box"><ul>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE topik in({$topikid}) and publikasi=1 ORDER BY id DESC LIMIT 1,3");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$id = $datas['id'];
$judul = $datas['judul'];
$konten = $datas['konten'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$tengah .= '<li><a href="article-' . $seftitle . '.html" title ="' . limitTXT(strip_tags($konten), 280) . '">' . $datas['judul'] . '</a></li>';
}
$tengah .= '</ul></div>';
//////////////////////////////////////////////
$hasilp = $koneksi_db->sql_query("SELECT * FROM topik WHERE parentid='{$topik}'");
while ($datap = $koneksi_db->sql_fetchrow($hasilp)) {
$topikp = $datap['id'];
$topikp2 .= $topikp . ',';
}
$topikp2 = substr_replace($topikp2, "", -1, 1);
//$tengah.=$topikp2.'<br>';
///////////////////////////////////////
$totals = $koneksi_db->sql_query("SELECT id FROM artikel WHERE publikasi=1 AND topik in({$topikp2})");
$jumlah = $koneksi_db->sql_numrows($totals);
$a = new paging($limit);
$hasil = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 AND topik in({$topikp2}) ORDER BY id DESC LIMIT {$offset}, {$limit}");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$hits = $data['hits'];
$data[6] = datetimes($data['tgl']);
$gambar = $data[8] == '' ? '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="' . $url_situs . '/timthumb.php?src=' . $url_situs . '/mod/news/images/normal/news-default.jpg&w=120&h=90&zc=1">' : '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="' . $url_situs . '/timthumb.php?src=' . $url_situs . '/mod/news/images/normal/' . $data[8] . '&w=120&h=90&zc=1" alt="' . $data['judul'] . '"/>';
$tengah .= '<div class="news">
<h4><a href="' . $url_situs . '/view-' . $data[11] . '.html" title="' . $data[1] . '">' . $data[1] . '</a></h4>
' . $gambar . '
<div class="date">' . $data[6] . ' • oleh : ' . $data[3] . ' • <img align="absmiddle" src="/images/read.gif"/> DIBACA : ' . $hits . '</div>
' . limitTXT(strip_tags($data[2]), 300) . '</div>';
}
//end while
if ($jumlah > 10) {
$tengah .= '<div class="border">';
$tengah .= "<center>";
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$offset = int_filter(@$_GET['offset']);
$pg = int_filter(@$_GET['pg']);
$stg = int_filter(@$_GET['stg']);
$totals = $koneksi_db->sql_query("SELECT pid FROM testimonial where status='ya' ");
$jumlah = $koneksi_db->sql_numrows($totals);
$a = new paging($limit);
if ($jumlah > 0) {
$hasil = $koneksi_db->sql_query("SELECT * FROM testimonial where status='ya' ORDER BY pid DESC LIMIT {$offset}, {$limit}");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$td = $no % 2;
$pid = $data['pid'];
$nama = $data['nama'];
$email = $data['email'];
$testimonial = $data['testimonial'];
$website = $data['website'];
$tgl = datetimes($data['tgl']);
if ($td == 0) {
$bgcolor = 'bgcolor="#f2f2f2"';
} else {
$bgcolor = '';
}
$tengah .= '<tr ' . $bgcolor . '>
<td style="padding:10px 10px 10px 10px; border-bottom:1px solid #dddddd;"><img src="' . get_gravatar($email) . '" style="float:left; margin-right:10px;"><div class="date">' . $tgl . '</div><b>' . $nama . '</b><br/>' . $testimonial . '</td></tr>';
$no++;
}
if ($jumlah > $limit) {
$tengah .= '<tr>
<td colspan="4" valign="top" style="background:#ffffff; text-align:center; padding:4px 10px 4px 10px;">';
$tengah .= '<div class="border">';
$tengah .= "<center>";
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
</tr>
<tr>
<td>Jenis Kelamin</td>
<td><select name="kelamin" class="form-control">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_kelamin ORDER BY kelamin");
$admin .= '<option value="-">== Jenis Kelamin ==</option>';
while ($datas = $koneksi_db->sql_fetchrow($hasil)) {
$pilihan = $datas['id'] == $kelamin ? "selected" : '';
$admin .= '<option value="' . $datas['id'] . '" ' . $pilihan . '>' . $datas['kelamin'] . '</option>';
}
$admin .= '</select></td>
</tr>
<tr>
<td>Agama</td>
<td><select name="agama" class="form-control">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_agama ORDER BY nama");
$admin .= '<option value="-">== Agama ==</option>';
while ($datas = $koneksi_db->sql_fetchrow($hasil)) {
$pilihan = $datas['id'] == $agama ? "selected" : '';
$admin .= '<option value="' . $datas['id'] . '" ' . $pilihan . '>' . $datas['nama'] . '</option>';
}
$admin .= '</select></td>
</tr>
<tr>
<td>Menikah</td>
<td><select name="menikah" class="form-control">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_menikah ORDER BY id");
$admin .= '<option value="-">== Status ==</option>';
while ($datas = $koneksi_db->sql_fetchrow($hasil)) {
$pilihan = $datas['id'] == $menikah ? "selected" : '';
$admin .= '<option value="' . $datas['id'] . '" ' . $pilihan . '>' . $datas['nama'] . '</option>';
if (isset($_SESSION['LevelAkses']) && $_SESSION['LevelAkses'] == "HRD" || $_SESSION['LevelAkses'] == "Administrator") {
/////////////////////////////////////////////////////////////////////////////////////////////
$tengah .= '<div class="col-xs-6">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan order by tglnaikgolongan asc");
$tengah .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Reminder Kenaikan Golongan</h3></div>
<table class="table">';
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$id = $data['id'];
$nip = $data['nip'];
$nama = $data['nama'];
$golongan = getgolongan($data['golongan']);
$date1 = $data['tglnaikgolongan'];
$date3 = date("Y-m-d");
$telatnaikgolongan = daysBetween($date3, $date1);
$tglnaikgolongan = datetimes($date1, False, False);
if ($telatnaikgolongan <= 90 and $telatnaikgolongan >= 0) {
$tengah .= "<tr><td>{$nama} - {$telatnaikgolongan} Hari ({$tglnaikgolongan}) - {$golongan}</td></tr>";
}
}
$tengah .= '</table>';
$tengah .= '</div>';
$tengah .= '</div>';
///////////////////////////////////////////////////////////////////////////
}
$tengah .= '</div>';
}
} else {
$style_include[] = '<meta http-equiv="refresh" content="1; url=admin.php?pilih=penggajian&mod=yes" />';
}
echo $tengah;
