Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_SESSION['id_admin']))
- {
- ?>
- <script type="text/javascript" src="jquery.js"></script>
- <script>
- function suggest(inputString){
- if(inputString.length == 0) {
- $('#suggestions').fadeOut();
- } else {
- $('#country').addClass('load');
- $.post("autosuggest.php", {queryString: ""+inputString+""}, function(data){
- if(data.length >0) {
- $('#suggestions').fadeIn();
- $('#suggestionsList').html(data);
- $('#country').removeClass('load');
- }
- });
- }
- }
- function fill(thisValue) {
- $('#country').val(thisValue);
- setTimeout("$('#suggestions').fadeOut();", 100);
- }
- function fill2(thisValue) {
- $('#kode').val(thisValue);
- setTimeout("$('#suggestions').fadeOut();", 100);
- }
- </script>
- <style>
- #result {
- height:20px;
- font-size:12px;
- font-family:Arial, Helvetica, sans-serif;
- color:#333;
- padding:5px;
- margin-bottom:10px;
- background-color:#FFFF99;
- }
- #country{
- padding:3px;
- border:1px #CCC solid;
- font-size:12px;
- }
- .suggestionsBox {
- position: absolute;
- left: 0px;
- top:40px;
- margin: 26px 0px 0px 0px;
- width: 200px;
- padding:0px;
- background-color:#999999;
- border-top: 3px solid #999999;
- color: #fff;
- }
- .suggestionList {
- margin: 0px;
- padding: 0px;
- }
- .suggestionList ul li {
- list-style:none;
- margin: 0px;
- padding: 6px;
- border-bottom:1px dotted #666;
- cursor: pointer;
- }
- .suggestionList ul li:hover {
- background-color: #FC3;
- color:#000;
- }
- ul {
- font-family:Arial, Helvetica, sans-serif;
- font-size:11px;
- color:#FFF;
- padding:0;
- margin:0;
- }
- .load{
- background-image:url(loader.gif);
- background-position:right;
- background-repeat:no-repeat;
- }
- #suggest {
- position:relative;
- }
- </style>
- <body onLoad="document.postform.elements['keterangan_jurnal'].focus();">
- <div class="post">
- <div class="entry">
- <h2 align="center"><strong>Kas Kecil</strong></h2>
- <h2 align="left">
- <?php
- //jurnal baru. cari nomor paling besar yaitu nomor jurnal terakhir
- $kas_keluar=mysql_fetch_array(mysql_query("SELECT max(nomor_bukti) FROM kas_keluar ORDER BY tanggal ASC"));
- $nomor_bukti=$kas_keluar[0]+1;
- $kode_transaksi="KK/".$nomor_bukti;
- ?>
- </h2>
- <form action="?page=./transaksi/kas_keluar" method="post" name="postform">
- <table width="541" border="0">
- <tr>
- <td width="145">Nomor Bukti</td>
- <td width="386" colspan="2">
- <input type="hidden" name="nomor_bukti" value="<?php echo $nomor_bukti;?>">
- <input type="text" disabled="disabled" value="<?php echo $nomor_bukti;?>" size="15"/>
- </td>
- </tr>
- <tr>
- <td>Tanggal</td>
- <td colspan="2"><input type="text" name="tanggal" size="15" value="<?php if(empty($_POST['tanggal'])){ echo $tanggal;}else{ echo $_POST['tanggal']; }?>"/>
- <a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.tanggal);return false;" ><img src="calender/calender.jpeg" alt="" name="popcal" width="34" height="29" border="0" align="absmiddle" id="popcal" /></a></td>
- </tr>
- <tr>
- <td>Pilih Kode</td>
- <td colspan="2"><div id="suggest">
- <input type="text" onKeyUp="suggest(this.value);" name="kode_rekening" onBlur="fill2();" id="kode" size="15"/>
- <div class="suggestionsBox" id="suggestions" style="display: none;"> <img src="arrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
- <div class="suggestionList" id="suggestionsList"> </div>
- </div>
- <input type="text" disabled="disabled" name="keterangan_transaksi" onBlur="fill();" id="country" size="30"/>
- </div></td>
- </tr>
- <tr>
- <td>Keterangan</td>
- <td colspan="2"><input type="text" value="<?php if(isset($_POST['keterangan_transaksi'])){ echo $_POST['keterangan_transaksi']; }?>" name="keterangan_transaksi" size="45"/></td>
- </tr>
- <tr><td colspan="2"></td></tr> <tr>
- <td>Posisi</td>
- <td colspan="2"><select name="normal">
- <option value="debet">Debet</option>
- <option value="kredit">Kredit</option>
- </select></td>
- </tr>
- <tr>
- <td>Jumlah (Rp)</td>
- <td colspan="2"><input type="text" name="jumlah_dk" size="15"/></td>
- </tr>
- <tr>
- <td><input type="submit" value="Simpan" name="simpan"></td>
- <td colspan="2"> </td>
- </tr>
- </table>
- </form>
- <p> </p>
- <p><a href="./transaksi/export_exel.php" target="_blank" title=" Tampilkan dalam file exl"><img src="images/logo_excel.png" border="0"/></a><br />
- <?php
- //untuk menyimpan transaksi
- if(isset($_POST['simpan'])){
- $nomor_bukti=$_POST['nomor_bukti'];
- $tanggal=$_POST['tanggal'];
- $kode_rekening=$_POST['kode_rekening'];
- $keterangan_transaksi=ucwords($_POST['keterangan_transaksi']);
- $normal = $_POST['normal'];
- $jumlah_dk = $_POST['jumlah_dk'];
- echo number_format($saldolama,2,'.',',');
- //untuk jurnal kas keluar, semua transaksi ada sisi DEBET
- $jumlah_dk=ucwords($_POST['jumlah_dk']);
- //untuk jurnal kas keluar, semua transaksi ada sisi KREDIT
- $jumlah_kk=ucwords($_POST['jumlah_dk']);
- if($normal == 'debet'){
- $query=mysql_query("insert into kas_keluar(nomor_bukti, tanggal, kode_rekening, keterangan_transaksi, debet, kredit, saldo) value('$nomor_bukti','$tanggal','$kode_rekening','$keterangan_transaksi','$jumlah_dk','0','0')");
- }else{
- $query=mysql_query("insert into kas_keluar(nomor_bukti, tanggal, kode_rekening, keterangan_transaksi, debet, kredit, saldo) value ('$nomor_bukti','$tanggal','$kode_rekening','$keterangan_transaksi','0','$jumlah_dk','0')");
- }
- if($query){
- //echo "berhasil";
- }else{
- echo mysql_error();
- }
- }else{
- unset($_POST['simpan']);
- }
- //untuk menyelesaikan transaksi
- if(isset($_POST['selesai'])){
- $nomor_bukti=$_POST['nomor_bukti'];
- $tanggal=$_POST['tanggal'];
- $kode_rekening=$_POST['kode_rekening'];
- $keterangan_transaksi=$_POST['keterangan_transaksi'];
- $debet=$_POST['debet'];
- $kredit=$_POST['kredit'];
- $saldo=$_POST['saldo'];
- //karena kas keluar lawan transaksinya adalah kas, maka kas adlah 111.01 yaitu kas unit umum yang ada di sisi KREDIT.
- $kode_rekening="111.01";
- $query=mysql_query("insert into kas_keluar(nomor_bukti,tanggal,kode_rekening,keterangan_transaksi,debet,kredit,saldo,)
- values('$nomor_bukti','$tanggal','$kode_rekening,'$keterangan_transaksi','$debet','$kredit','$saldo')");
- $query=mysql_query("insert into kas_keluar(nomor_bukti,tanggal,kode_rekening,keterangan_transaksi,debet,kredit,saldo) values('$nomor_bukti','$tanggal,'$kode_rekening','$keterangan_transaksi','$debet,'$kredit','$saldo')");
- if($query_transaksi){
- ?>
- <script language="javascript">document.location.href="?page=./transaksi/kas_keluar"</script>
- <?php
- }else{
- echo mysql_error();
- }
- }else{
- unset($_POST['selesai']);
- }
- //untuk mendecode url yang di enrypsi
- //$var=decode($_SERVER['REQUEST_URI']);
- //pecahkan nilai array
- if(isset($_GET['mode'])){
- $mode=$_GET['mode'];
- $nomor_bukti=isset($_GET['nomor_bukti'])?$_GET['nomor_bukti']:0;
- if($mode=='delete'){
- $query=mysql_query("delete from kas_keluar where nomor_bukti='$nomor_bukti'");
- }else{
- echo mysql_error();
- }
- }
- //untuk menampilkan transaksi
- ?>
- </p>
- <table width="388" border="1" class="datatable">
- <tr>
- <th width="9">Tanggal</th>
- <th width="65">Kode Rekening</th>
- <th width="79">Keterangan</th>
- <th width="41">Debit</th>
- <th width="42">Kredit</th>
- <th width="37">Saldo</th>
- <th colspan="2">Action</th>
- </tr>
- <?php
- $tot_debet=$tot_kredit=0;
- $saldolama=0;
- $query=mysql_query("select id from kas_keluar limit 1");
- if(!$query)
- {
- $sql="ALTER TABLE `kas_keluar` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST";//die('gk ada tuh'.mysql_error());
- $q=mysql_query($sql)or die(mysql_error()."<br>$sql");
- }
- $sql=array();
- $query=mysql_query("select * from kas_keluar order by tanggal asc");
- while($row=mysql_fetch_array($query))
- {
- $debet=$row['debet'];
- $kredit=$row['kredit'];
- $id_transaksi=$row['nomor_bukti'];//['id_transaksi']; // ngak ada!!
- $tot_debet=$tot_debet+$debet;
- $tot_kredit=$tot_kredit+$kredit;
- if (($row['kredit']=="0")&&($row['debet']!=="0")) {
- //$saldolama=$saldolama+$datasaldo[debet]-$datasaldo[kredit] ;
- //echo "sd";
- $saldolama=$saldolama+$row['debet'];
- }
- else
- {
- $saldolama=$saldolama-$row['kredit'];
- //echo "aa";
- }
- $tot_saldo=$saldolama;
- ?>
- <tr>
- <td><?php echo $row['tanggal'];?></td>
- <td><?php echo $row['kode_rekening'];?></td>
- <td><?php echo $row['keterangan_transaksi'];?></td>
- <td align="right"><?php if($debet!=="0"){echo number_format($debet,2,'.',',');}else{echo number_format('0',2,'.',',');}; ?></td>
- <td align="right"><?php if($kredit!=="0"){echo number_format($kredit,2,'.',',');}else{echo number_format('0',2,'.',',');}; ?></td>
- <td align="center"><?php
- echo number_format($saldolama,2,'.',',');
- //end hitung saldo sebelumbnya
- ?>
- </td>
- <td width="39" align="center"><a href="?page=./transaksi/kas_keluar&mode=delete&nomor_bukti=<?php echo $id_transaksi; ?>" onClick="return confirm('Apakah Anda yakin?')">Hapus</a></td>
- <td width="24" align="center"><a href="?page=./transaksi/kas_keluar&mode=edit&id_transaksi=<?php echo $id_transaksi; ?>" onClick="return confirm('Apakah Anda yakin?')">Edit</a></td>
- </tr>
- <?php
- //print_r($row);die();
- $sql[]="UPDATE `kas_keluar` SET `saldo` = '$saldolama'
- WHERE `kas_keluar`.`id` =$row[id];";
- }
- ?>
- <tr>
- <td colspan="3" align="center"><b>TOTAL</b></td>
- <td align="right"><b><?php echo number_format($tot_debet,2,'.',','); ?></b></td>
- <td align="right"><b><?php echo number_format($tot_kredit,2,'.',','); ?></b></td>
- <td align="center"><?php echo number_format($tot_saldo,2,'.',','); ?></b></td>
- <td align="center"></td>
- <td align="center"></td>
- </tr>
- </table>
- <br />
- </p>
- </div>
- </div>
- </body>
- <iframe width=174 height=189 name="gToday:normal:calender/agenda.js" id="gToday:normal:calender/agenda.js" src="calender/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;"></iframe>
- <?php
- foreach($sql as $s) $q=mysql_query($s)or die(mysql_error()."<br>$s");
- }else{
- echo "Forbidden Access!";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement