NotesWhat is notes.io?

Notes brand slogan

Notes - notes.io

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>AdminLTE 2 | Data Tables</title>
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<!-- Bootstrap 3.3.7 -->
<link rel="stylesheet" href="../../bower_components/bootstrap/dist/css/bootstrap.min.css">
<!-- Font Awesome -->
<link rel="stylesheet" href="../../bower_components/font-awesome/css/font-awesome.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="../../bower_components/Ionicons/css/ionicons.min.css">
<!-- DataTables -->
<!-- <link rel="stylesheet" href="../../bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css"> -->
<link rel="stylesheet" href="//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/AdminLTE.min.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
<link rel="stylesheet" href="../../dist/css/skins/_all-skins.min.css">

<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->

<!-- Google Font -->
<link rel="stylesheet"
href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>
<?php
include 'config.php';
session_start(); //memulai session
$nama = ( isset($_SESSION['nama']) ) ? $_SESSION['nama'] : '';
$npp = ( isset($_SESSION['npp']) ) ? $_SESSION['npp'] : '';
date_default_timezone_set('Asia/Jakarta');
$tanggal_sekarang = date('Y-m-d H:i:s');
?>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

<header class="main-header">
<!-- Logo -->
<a href="index2.html" class="logo">
<!-- mini logo for sidebar mini 50x50 pixels -->
<span class="logo-mini"><b>S</b>KS</span>
<!-- logo for regular state and mobile devices -->
<span class="logo-lg"><b>SISKAS</span>
</a>
<!-- Header Navbar: style can be found in header.less -->
<nav class="navbar navbar-static-top">
<!-- Sidebar toggle button-->
<a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
<span class="sr-only">Toggle navigation</span>
</a>

<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<!-- User Account: style can be found in dropdown.less -->
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<img src="../../dist/img/user2-160x160.jpg" class="user-image" alt="User Image">
<span class="hidden-xs"><?=$_SESSION['nama'];?></span>
</a>
<ul class="dropdown-menu">
<!-- User image -->
<li class="user-header">
<img src="../../dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
<p>
<span class="hidden-xs"><?=$_SESSION['nama'];?></span>
<small>Member since Nov. 2012</small>
</p>
</li>
<!-- Menu Footer-->
<li class="user-footer">
<div class="pull-right">
<a href="#" class="btn btn-default btn-flat">Sign out</a>
</div>
</li>
</ul>
</li>
<!-- Control Sidebar Toggle Button -->
</ul>
</div>
</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li><a href="../../index.php"><i class="fa fa-dashboard"></i>Dashboard</a></li>
<li class="treeview">
<a href="#">
<i class="fa fa-edit"></i> <span>Inputer</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li class="treeview">
<a href="#"><i class="fa fa-circle-o"></i>Kas Masuk
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="uangtarik.php"><i class="fa fa-circle-o"></i>HCS</a></li>
<li><a href="nonsortir.php"><i class="fa fa-circle-o"></i>Non Sortir</a></li>
</ul>
<li class="treeview">
<a href="#"><i class="fa fa-circle-o"></i>Kas Keluar
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="pages/forms/setor-hcs.php"><i class="fa fa-circle-o"></i>HCS</a></li>
<li><a href="pages/forms/sortir.php"><i class="fa fa-circle-o"></i>Sortir</a></li>
<li><a href="pages/forms/nonsortir.php"><i class="fa fa-circle-o"></i>Non Sortir</a></li>
</ul>
</ul>
</li>
<li class="treeview">
<a href="#">
<i class="fa fa-edit"></i> <span>Maintance</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="sortir_detail.php"><i class="fa fa-circle-o"></i>Sortir</a></li>
<!-- <li><a href="pages/forms/sortir.php"><i class="fa fa-circle-o"></i>Sortir</a></li> -->
<li class="treeview">
<a href="#"><i class="fa fa-circle-o"></i>Kas Keluar
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="pages/forms/uangtarik.php"><i class="fa fa-circle-o"></i>HCS</a></li>
<li><a href="pages/forms/sortir.php"><i class="fa fa-circle-o"></i>Sortir</a></li>
<li><a href="pages/forms/nonsortir.php"><i class="fa fa-circle-o"></i>Non Sortir</a></li>
</ul>
</ul>
</li>
</section>
<!-- /.sidebar -->
</aside>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Data Tables
<small>advanced tables</small>
</h1>
</section>

<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<!-- /.box-header -->
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No.</th>
<th>Kategori</th>
<th>Sumber</th>
<th>Total</th>
<th>Action</th>
</tr>
</thead>
<?php
$x = 0;
$sql = "Select * from transaction";
$result_transaction = $koneksi->query($sql);
if ($result_transaction->num_rows > 0) {
while($row_transaction = $result_transaction->fetch_assoc()) {
$sql_transaction_detail = "Select * from transactiondetail where Id_TransactionDetail = '".$row_transaction['TransactionDetail_Id']."'";
$result_transaction_detail = $koneksi->query($sql_transaction_detail);
if ($result_transaction_detail->num_rows > 0) {
while($row_transaction_detail = $result_transaction_detail->fetch_assoc()) {
$cukErs = array();
$cukIrs = array();
$cukOrs = array();
$sql_bi_id = "Select * from bi where Id_BI = '".$row_transaction_detail['BI_Id']."'";
$result_bi = $koneksi->query($sql_bi_id);
while($row_bi_id = $result_bi->fetch_assoc()) {
array_push($cukErs, $row_bi_id['Name']);
array_push($cukIrs, "BI");
array_push($cukOrs, $row_bi_id['Id_BI']);
}
$sql_atm_id = "Select * from atm where Id_ATM = '".$row_transaction_detail['ATM_Id']."'";
$result_atm_id = $koneksi->query($sql_atm_id);
while($row_atm_id = $result_atm_id->fetch_assoc()) {
array_push($cukErs, $row_atm_id['Name']);
array_push($cukIrs, "ATM");
array_push($cukOrs, $row_atm_id['Id_ATM']);
}
$sql_cabang_id = "Select * from cabang where Sandi_Cabang = '".$row_transaction_detail['Cabang_Id']."'";
$result_cabang_id = $koneksi->query($sql_cabang_id);
while($row_cabang_id = $result_cabang_id->fetch_assoc()) {
array_push($cukErs, $row_cabang_id['Nama_Outlet']);
array_push($cukIrs, "Cabang");
array_push($cukOrs, $row_cabang_id['Sandi_Cabang']);
}
$sql_tukap_id = "Select * from banktukab where Id_BankTukab = '".$row_transaction_detail['BankTukab_Id']."'";
$result_tukap_id = $koneksi->query($sql_tukap_id);
while($row_tukap_id = $result_tukap_id->fetch_assoc()) {
array_push($cukErs, $row_tukap_id['Name']);
array_push($cukIrs, "Cabang");
array_push($cukOrs, $row_tukap_id['Id_BankTukab']);
}
?>
<tbody>
<tr>
<td><?php echo $x+1; $x++;?></td>
<td><?php foreach ($cukIrs as $key=>$item){
echo "$item";
} ?>
</td>
<td><?php foreach ($cukErs as $key=>$item){
echo "$item";
} ?></td>
<td> 4</td>
<td>X</td>
</tr>
</tbody>
<?php
}
} else {
echo "0 results";
}
}}else {
echo "0 results";
}
$koneksi->close();
?>
<!-- <tfoot>
<tr>
<th>Rendering engine</th>
<th>Browser</th>
<th>Platform(s)</th>
<th>Engine version</th>
<th>CSS grade</th>
</tr>
</tfoot> -->
</table>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<div class="pull-right hidden-xs">
<b>Version</b> 2.4.0
</div>
<strong>Copyright &copy; 2014-2016 <a href="https://adminlte.io">Almsaeed Studio</a>.</strong> All rights
reserved.
</footer>
<!-- Add the sidebar's background. This div must be placed
immediately after the control sidebar -->
<div class="control-sidebar-bg"></div>
</div>
<!-- ./wrapper -->

<!-- jQuery 3 -->
<script src="../../bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="../../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- DataTables -->
<!-- <script src="../../bower_components/datatables.net/js/jquery.dataTables.min.js"></script> -->
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="../../bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="../../bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="../../bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<!-- page script -->
<script>
$(document).ready( function () {
$('#example1').DataTable();
} );
</script>
</body>
</html>
     
 
what is notes.io
 

Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...

With notes.io;

  • * You can take a note from anywhere and any device with internet connection.
  • * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
  • * You can quickly share your contents without website, blog and e-mail.
  • * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
  • * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.

Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.

Easy: Notes.io doesn’t require installation. Just write and share note!

Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )

Free: Notes.io works for 12 years and has been free since the day it was started.


You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;


Email: [email protected]

Twitter: http://twitter.com/notesio

Instagram: http://instagram.com/notes.io

Facebook: http://facebook.com/notesio



Regards;
Notes.io Team

     
 
Shortened Note Link
 
 
Looding Image
 
     
 
Long File
 
 

For written notes was greater than 18KB Unable to shorten.

To be smaller than 18KB, please organize your notes, or sign in.