API tools faq
paste
Advertisement
cdsatrian

multiple input

cdsatrian
Aug 18th, 2013
152
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.32 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /***********************/
  3. //FILE: form inputan
  4. /***********************/
  5. session_start;
  6. include 'config/fungsi_simpan.php';
  7. ?>
  8. <!DOCTYPE html>
  9.   <html>
  10.     <head>
  11.       <style>
  12.         *,td,th,input {font-family:Verdana,arial,sans-serif;}
  13.         .frame { margin: 1em; border: 1px solid #ccc; }
  14.         .tdku, .th { padding: 10px; margin-left:10px;}
  15.         .button {color:#ffffff;background-color:#066;
  16.                  padding:5px 7px;border:1px solid #033;
  17.                  width:auto;}
  18.       </style>
  19.       <SCRIPT TYPE="text/javascript">
  20.         function numbersonly(myfield, e, dec){
  21.             var key;
  22.             var keychar;
  23.           if (window.event)
  24.             key = window.event.keyCode;
  25.           else if (e)
  26.             key = e.which;
  27.           else
  28.             return true;
  29.           keychar = String.fromCharCode(key);
  30.           // control keys
  31.           if ((key==null) || (key==0) || (key==8) ||
  32.           (key==9) || (key==13) || (key==27) )
  33.           return true;
  34.           // numbers
  35.           else if ((("0123456789").indexOf(keychar) > -1))
  36.           return true;
  37.           // decimal point jump
  38.           else if (dec && (keychar == "."))
  39.           {
  40.             myfield.form.elements[dec].focus();
  41.             return false;
  42.           }
  43.           else
  44.             return false;
  45.         }
  46.          //-->
  47.       </SCRIPT>
  48.       <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  49.       <title>Rekap Absen Baru</title>
  50.       <!-- popup calendar -->
  51.       <link rel="stylesheet" href="dhtmlgoodies_calendar.css" media="screen"></link>
  52.       <script type="text/javascript" src="dhtmlgoodies_calendar.js"></script>
  53.       <!-- end popup calendar -->
  54.       <script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
  55.       <script type="text/javascript" src="js/jquery-ui-1.7.2.custom.min.js"></script>
  56.       <script type="text/javascript">
  57.         $(function(){
  58.             $('#tanggal_lahir').datepicker();
  59.         });
  60.         function gantiTanggal(value){
  61.           document.getElementById('ambiltanggal').value = document.getElementById('f_tanggal').value;
  62.         }
  63.       </script>
  64.       <link href="tabelnya.css" rel="stylesheet" type="text/css" />
  65.     </head>
  66.     <body>
  67.       <h3>Rekap Data Baru</h3>
  68.       <p>
  69.         <?php
  70.          include "config/konek.php";
  71.          $terakhir= "SELECT * FROM bulan ORDER BY id DESC LIMIT 1";  
  72.          $ambilTerakhir = mysql_query($terakhir);
  73.          $tampilTerakhir = mysql_fetch_array($ambilTerakhir);
  74.          $terakhir1= "SELECT * FROM staff WHERE status='OK'";  
  75.          $ambilTerakhir1 = mysql_query($terakhir1);
  76.          if(!isset($_REQUEST['keterangan'])){
  77.             $tampilTerakhir1 = mysql_fetch_array($ambilTerakhir1);
  78.           }
  79.         ?>
  80.       </p>
  81.       <form id="form1" name="form1" method="post" action="simpan_tanggal.php">
  82.       <table   width="900" cellspacing="0" cellpadding="0" class="frame" >
  83.           <tr>
  84.             <td height="35" colspan="8" align="left" valign="middle">
  85.                 Tanggal
  86.                 <input name="tanggal" type="text" id="f_tanggal" value="" size="14"
  87.                   placeholder="masukan tanggal" />
  88.                 <img src="images/calendar.gif" alt="" width="24" height="12"
  89.                      style="cursor:pointer"
  90.                      onclick="displayCalendar(document.getElementById('f_tanggal'),'dd-mm-yyyy',this)" />
  91.                 <input type="submit" name="btn" id="btn" value="Submit" />
  92.                   Tanggal input terakhir <?php echo $tampilTerakhir['tanggal']; ?>
  93.                 <?php
  94.                 if($_POST['ok1']){    
  95.                   $_SESSION['oke']="Last Saved";
  96.                   echo $_SESSION['oke'];  
  97.                 }
  98.                  ?>
  99.             </td>
  100.           </tr>
  101.          </table>
  102.          </form>
  103.          <form action="simpan_absen.php" method="post">
  104.          <table   width="900" cellspacing="0" cellpadding="0" class="frame" >
  105.           <tr>
  106.             <th width="28" height="35">No</th>
  107.             <th width="165">Nama</th>
  108.             <th width="105">Jabatan / Divisi</th>
  109.             <th width="102"> Jam Masuk</th>
  110.             <th width="102">Jam Keluar</th>
  111.             <th width="170"><label for="nama_proyek">Keterangan</label></th>
  112.           </tr>
  113.           <?php
  114.           $ket=array('Hadir','Sakit','Izin','Cuti','Tanpa Keterangan','Tugas Luar');
  115.           $query = "SELECT * FROM  persons order by id LIMIT 100";
  116.           $hasil = mysql_query($query);
  117.           while($data  = mysql_fetch_array($hasil))
  118.           {
  119.           ?>
  120.           <tr>
  121.               <td height="40" align="center"><?php echo $data[id];?></td>
  122.               <td>
  123.                   <?php echo $data[nama];?>
  124.                   <input name="nama[]" type="hidden" value="<?php echo $data[nama];?>" />
  125.             </td>
  126.             <td>
  127.               <?php echo $data['jabatan']; ?>
  128.               <input name="jabatan[]" type="hidden" value="<?php echo $data['jabatan']; ?>" />
  129.             </td>
  130.             <td>
  131.               jam
  132.               <input name="jam1[]" type="text" value="" size="2" maxlength="2"
  133.                      onkeypress="return numbersonly(this, event)" />
  134.               menit
  135.               <input name="menit1[]" type="text" value="" size="2" maxlength="2"  
  136.                      onkeypress="return numbersonly(this, event)" />
  137.             </td>
  138.             <td>
  139.               <label for="jam_keluar">
  140.                 jam
  141.                 <input name="jam2[]" type="text" value="" size="2" maxlength="2" />
  142.                 menit
  143.                 <input name="menit2[]" type="text" value="" size="2" maxlength="2"
  144.                        onkeypress="return numbersonly(this, event)" />
  145.               </label>
  146.             </td>
  147.             <td>
  148.               <label for="keterangan"></label>
  149.               <select name="keterangan[]" id="keterangan">
  150.               <?php
  151.                 $i=0;
  152.                 foreach($ket as $k){
  153.                   echo "<option value='".++$i."'>$k</option>\n";
  154.                 }
  155.               ?>
  156.               </select>
  157.               <input name="tanggal[]" type="hidden" id="tanggal"
  158.                      value="<?php echo $tampilTerakhir['tanggal']; ?>" />
  159.             </td>
  160.         </tr>
  161.        <?php $no++;}?>
  162.        <tr>
  163.          <td colspan="6">
  164.            <input type="submit" value="Simpan" id="tombyol" name="ok1" class="button"/>
  165.          </td>
  166.        </tr>
  167.     </table>
  168.   </form>
  169.   <script type="text/javascript">
  170.     function display_alert()
  171.     {
  172.       alert("Data Deleted" );
  173.     }
  174.   </script>
  175. </body>
  176. </html>
  177.  
  178.  
  179.  
  180. <?php
  181. /***********************/
  182. //FILE : simpan_absen.php
  183. /***********************/
  184. session_start();
  185. include "conn.php";
  186. $jam_masuk   = $_POST["jam1"];
  187. $menit_masuk = $_POST["menit1"];
  188. $jam_keluar  = $_POST["jam2"];
  189. $menit_keluar= $_POST["menit2"];
  190. $tanggal     = $_POST['tanggal'];
  191. $nama        = $_POST['nama'];
  192. $jabatan     = $_POST['jabatan'];  
  193. $jam_masuk   = $_POST['jam_masuk'];  
  194. $jam_keluar  = $_POST['jam_keluar'];      
  195. $keterangan  = $_POST['keterangan'];
  196. $num         = count($nama);
  197. $sql         = "INSERT INTO `seamolec`.`staff`
  198.               (`tanggal`,`nama`,`jabatan`,`jam_masuk`,`jam_keluar`,`total_jam`,
  199.                `hadir`,`izin`,`sakit`,`cuti`,`tugasluar`,`tanpaketerangan`,`status`)
  200.              VALUES ";
  201. $jam_in=array();
  202. $jam_out=array();
  203. $total_jam=array();
  204. for($i=0;$i<$num;$i++){
  205.   if($menit_keluar[$i] < $menit_masuk[$i])
  206.   {
  207.     $jam_keluar[$i]   -= 1;
  208.     $menit_keluar[$i] += 60;
  209.   }
  210.   $jam_in[$i]     = "{$jam_masuk[$i]}{$menit_masuk[$i]}";
  211.   $jam_out[$i]    = "{$jam_keluar[$i]}{$menit_keluar[$i]}";
  212.   $total_jam[$i]  = ($jam_keluar[$i] - $jam_masuk[$i] - 1)."".($menit_keluar[$i] - $menit_masuk[$i]);
  213.   $values="('{$tanggal[$i]}',
  214.           '{$nama[$i]}',
  215.           '{$jabatan[$i]}',
  216.           '{$jam_in[$i]}',
  217.           '{$jam_out[$i]}',
  218.           '{$total_jam[$i]}',
  219.         ".(($keterangan)=="1"?"'1'","NULL").",
  220.         ".(($keterangan)=="2"?"'1'","NULL").",
  221.         ".(($keterangan)=="3"?"'1'","NULL").",
  222.         ".(($keterangan)=="4"?"'1'","NULL").",
  223.         ".(($keterangan)=="5"?"'1'","NULL").",
  224.         ".(($keterangan)=="6"?"'1'","NULL").",
  225.         'OK')";
  226. }
  227. $sql.=implode(",",$values);
  228. $result=mysql_query($sql);
  229. require "rekap_baru.php";
  230. ?>
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!