API tools faq
paste
Advertisement
H4nk

Input Solved

H4nk
Apr 6th, 2013
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.46 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. error_reporting(E_ALL ^ E_NOTICE);
  3. include "koneksi.php";
  4. $tam=mysql_fetch_array(mysql_query("select * from setting"));
  5. $a=$tam['cpu'];
  6. $b=$tam['dpp'];
  7. $c=$tam['manajemen'];
  8. $d=$tam['Pegawai'];
  9. $e=$tam['zakat'];
  10. $f=$tam['bagihasil'];
  11. if(isset($_POST['submit'])){
  12. $tanggal_lahir = $_POST['thn']."-".$_POST['bln']."-".$_POST['tgl'];
  13. $Periode=$_POST['status'];
  14. $lb=$_POST['lb'];
  15. $CPU=$lb*$a;
  16. $DPP=$lb*$b;
  17. $Manajemen=$lb*$c;
  18. $Pegawai=$lb*$d;
  19. $Zakat=$lb*$e;
  20. $bln=$_POST['bln'];
  21. $thn=$_POST['thn'];
  22. //mencari nilai bagi hasil
  23. $bg=$lb*$f;
  24. $basten=mysql_fetch_array(mysql_query("SELECT * FROM totmodal WHERE Month(tgl)='$bln' AND Year(tgl)='$thn' AND periode=$Periode"));
  25. $tot=$basten['tm'];
  26. $md=mysql_fetch_array(mysql_query("select sum(tm) as total from totmodal"));
  27. $total=$md['total'];
  28. $bagihasil=($tot/$total)*$bg;
  29. $input=mysql_query("insert into talokasi values('','$tanggal_lahir','$Periode','$CPU','$DPP','$Manajemen','$Pegawai','$Zakat','$lb','$bagihasil')") ;
  30. }
  31.    else{
  32.     unset($_POST['simpan']);
  33. }
  34. ?>
  35. <?
  36. if(isset($_POST['ubah'])){
  37. $TglTransaksi=$_POST['thn']."-".$_POST['bln']."-".$_POST['tgl'];
  38. $Periode=$_POST['status'];
  39. $lb=$_POST['lb'];
  40. $CPU=$lb*$a;
  41. $DPP=$lb*$b;
  42. $Manajemen=$lb*$c;
  43. $Pegawai=$lb*$d;
  44. $Zakat=$lb*$e;
  45. $id=$_GET['id'];
  46. //mencari nilai bagi hasil
  47. mysql_query("update tAlokasi set  TglTransaksi=' $TglTransaksi',Periode='$Periode',CPU='$CPU',DPP='$DPP',Manajemen='$Manajemen',Pegawai='$Pegawai',Zakat='$Zakat',lb='$lb' where id='$id'")or die(mysql_error());
  48.            echo "<script language='javascript'>
  49.             window.location = 'index.php?simpan=yes'</script>";
  50.     }
  51.  
  52.     if($_GET['ubah']){
  53.             $sql=mysql_query("SELECT * FROM tAlokasi WHERE id='".$_GET[id]."'");
  54.             $res=mysql_fetch_array($sql);
  55.     }
  56.      
  57.     if($_GET['hapus']){
  58.             mysql_query("DELETE FROM tAlokasi WHERE id='".$_GET[id]."'");
  59.             echo "<script language='javascript'>
  60.             window.location = 'index.php?simpan=yes'</script>";
  61.     }
  62.  
  63. ?>
  64. <html>
  65. <head>
  66. <title>Entry Data Pemodal</title>
  67.  
  68. <link type="text/css" href="js/themes/base/ui.all.css" rel="stylesheet" />  
  69. <link rel="stylesheet" type="text/css" href="jQuery-Validation-Engine/css/validationEngine.jquery.css" />  
  70.  
  71.     <script type="text/javascript" src="js/jquery-1.4.js"></script>
  72.     <script type="text/javascript" src="js/ui/ui.core.js"></script>
  73. <script type="text/javascript" src="jQuery-Validation-Engine/js/jquery.validationEngine.js"></script>  
  74. <script type="text/javascript" src="jQuery-Validation-Engine/js/jquery.validationEngine-id.js"></script>
  75.  
  76. <script type="text/javascript" src="js/ui/ui.datepicker.js"></script>
  77. <script type="text/javascript" src="js/ui/i18n/ui.datepicker-id.js"></script>
  78.  
  79.     <script type="text/javascript">
  80.       $(document).ready(function(){
  81.         $( "#tanggal" ).datepicker({ altFormat: 'yy-mm-dd' });
  82.         $( "#tanggal" ).change(function() {
  83.              $( "#tanggal" ).datepicker( "option", "dateFormat","yy-mm-dd" );          
  84.         });
  85.       });
  86.     </script>
  87.    
  88.    
  89.         <script src="datables/media/js/jquery.dataTables.js" type="text/javascript"></script>  
  90.           <style type="text/css">
  91.             @import "datables/media/css/demo_table_jui.css";
  92.             @import "datables/media/themes/ui-lightness/jquery-ui-1.8.4.custom.css";
  93.           </style>
  94.        
  95.         <style>
  96.             *{
  97.                 font-family: arial;
  98.             }
  99.         </style>
  100.         <script type="text/javascript" charset="utf-8">
  101.             $(document).ready(function(){
  102.                 $('#datatables').dataTable({
  103.                     "sPaginationType":"full_numbers",
  104.                     "aaSorting":[[2, "desc"]],
  105.                     "bJQueryUI":true
  106.                 });
  107.             })
  108.            
  109.         </script>
  110.        
  111.        
  112.  
  113.  
  114. <script type="text/javascript">
  115.    $(document).ready(function() {
  116.       $("#formulir").validationEngine();
  117.    });
  118. </script>        
  119. <style type="text/css">
  120.    label {
  121.       float: left;
  122.       width: 200px;
  123.    }
  124. .style1 {
  125.     color: #000000;
  126.     font-weight: bold;
  127. }
  128. </style>
  129. </head>
  130. <body>
  131. <div class="post">
  132.   <div class="post-bgtop">
  133.     <div class="post-bgbtm"> <h2 class="title">Entry Data Alokasi </h2>
  134.       <p>&nbsp;</p>
  135.              <div class="entry">    
  136.               <p>
  137.         </p>
  138. <form name="ex" method="post" action="" id="formulir" >
  139.   <table width="347" border="0" align="center">
  140.     <tr>
  141.       <td>Tanggal Transaksi</td>
  142.       <td><select name="tgl" size="1"  id="tgl">
  143.         <?
  144.   for ($i=1;$i<=31;$i++)
  145.   {
  146.   echo "<option  value=".$i.">".$i."</option>";
  147.   }
  148.   ?>
  149.       </select></td>
  150.       <td><select  name="bln" size="1" id="bln">
  151.         <?
  152.   $bulan=array("","Januari","Pebruari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
  153.   for ($i=1;$i<=12;$i++)
  154.   {
  155.   echo "<option  value=".$i.">".$bulan[$i]."</option>";
  156.   }
  157.   ?>
  158.       </select></td>
  159.       <td><select  name="thn" size="1" id="thn">
  160.         <?
  161.   for ($i=2007;$i<=2020;$i++)
  162.   {
  163.   echo "<option  value=".$i.">".$i."</option>";
  164.   }
  165.   ?>
  166.       </select></td>
  167.     </tr>
  168.     <tr>
  169.       <td>Periode</td>
  170.       <td colspan="3"><select name="status"   id="status" class="styledselect_form_1">
  171.         <option value="1">Satu</option>
  172.         <option value="2">Dua</option>
  173.       </select></td>
  174.       </tr>
  175.     <tr>
  176.       <td>Laba Bersih </td>
  177.       <td colspan="3"><input type="text" name="lb" id="lb" value="<?php echo $res['lb']; ?>" class="validate[required]" onKeyUp="lihat()"></td>
  178.       </tr>
  179.   </table>
  180.   <table width="544" border="0" align="center">
  181.           <tr>
  182.             <td colspan="2">&nbsp;</td>
  183.           </tr>
  184.           <tr>
  185.             <td colspan="2"><div align="center">
  186.                
  187.                
  188.                 <? if($_GET['simpan']){?>
  189.                <input type="submit" onClick="return confirm('Apakah Anda yakin Untuk Simpan Data?')" value="simpan" name="submit"/>
  190.                <? }else{?>
  191.                 <input type="submit" onClick="return confirm('Apakah Anda yakin Untuk Rubah Data?')" name="ubah" id="ubah" value="  Ubah  ">
  192.                 <? }?>
  193.                 <? if($_GET['ubah']==yes){?>
  194.                 <label></label>
  195.                 <input type="reset" name="Ulangi" id="reset" value="Reset">
  196.                 <? }else{?>
  197.                 <input type="submit" value="Kembali" id="kembali" name="kembali">
  198.                 <? }?>
  199.             </div></td>
  200.           </tr>
  201.         </table>
  202.         <p>&nbsp;</p>
  203.         <p>&nbsp;</p>
  204.         <div align="center"></div>
  205.         <div align="center"></div>
  206.       </label>
  207.   <p>&nbsp;</p>
  208.   <p>&nbsp;</p>
  209.   <div class="wrap">
  210.             <div class="header">
  211.             </div>
  212.             <table id="datatables" class="display">
  213.                 <thead>
  214.                     <tr>
  215.                  
  216.                         <th width="18%">Tanggal Transaksi </th>
  217.                         <th width="10%">Periode</th>
  218.                         <th width="13%">CPU</th>
  219.                         <th width="7%">DPP</th>
  220.                         <th width="15%">Manajemen</th>
  221.                         <th width="12%">Pegawai</th>
  222.                         <th width="8%">Zakat</th>
  223.                         <th width="17%">Aksi</th>
  224.                     </tr>
  225.                 </thead>
  226.                 <tbody>
  227.                     <?php
  228.  
  229.   $sql4 = "select * from tAlokasi order by Periode asc";
  230.   $qry = mysql_query($sql4);
  231.   $no = 1;
  232.   while ($data = mysql_fetch_array($qry))
  233.   {
  234.   ?>
  235.                         <tr>
  236.                        
  237.                             <td><?php echo $data['TglTransaksi']; ?></td>
  238.                             <td><?php echo $data['Periode']; ?></td>
  239.                             <td><?php echo $data['CPU']; ?></td>
  240.                             <td><?php echo $data['DPP']; ?></td>
  241.                             <td><?php echo $data['Manajemen']; ?></td>
  242.                             <td><?php echo $data['Pegawai']; ?></td>
  243.                             <td><?php echo $data['Zakat']; ?></td>
  244.                             <td><div align="center" class="style1"><a href="?page=entri_alokasi&amp;ubah=yes&amp;id=<?php echo $data['id']; ?>">edit</a>  | <a href="?page=entri_alokasi&amp;hapus=?&amp;id=<?php echo $data['id']; ?>">hapus</a></div></td>
  245.                         </tr>
  246.                         <?php
  247.                         $no++;
  248.                     }
  249.                     ?>
  250.                 </tbody>
  251.             </table>
  252.         <div class="footer">
  253.             <p align="center"><center>
  254.                BASTEN edisi <?php echo date('Y'); ?>
  255.             </center></p>
  256.         </div>
  257.     </div>
  258.        
  259.   <p>&nbsp;</p>
  260. </form>
  261.    <p></p>
  262.       </div>
  263.     </div>
  264.   </div>
  265. </div>
  266.  
  267.        
  268. </body>
  269. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!