Monthpicker dengan jQuery


Download monthpicker Disini
Download jQuery UI Disini

Pengunaan :

CSS dan JS


 <link rel="stylesheet" href="js/jquery-ui.css" />
<script src="js/jquery-1.9.1.js"></script>
<script src="js/jquery-ui.js"></script>
<script src="js/jquery.mtz.monthpicker.js"></script>
<script>

$(function(){

 options = {
    pattern:'/01'+'yyyy/mm',   
    startYear: 2012, 
    monthNames: ['Januari', 'Februari', 'Maret', 'Aprl', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember']
};

   $('#bulan').monthpicker(options);


});
</script>

HTML

Pilih Bulan : <input data-start-year="2012" id="bulan" name="bulan" type="text" />





Demo : http://jsfiddle.net/abbyacakadud/TfSzM/1/
Detail : http://lucianocosta.info/jquery.mtz.monthpicker/

Keranjang Belanja Sederhana jQuery



HTML


<h3>Pilih Barang </h3>
<table border="1">
    <tr>
        <th>No.</th>
        <th>Nama Barang</th>
        <th>Harga</th>
        <th>Beli</th>
    </tr>
<tr>
    <td>1.</td>
    <td>Monitor</td>
    <td>Rp.500.000</td>
    <td><button id="beli" nama="Monitor" harga="500000">Beli</button></td>
</tr>
    <tr>
    <td>2.</td>
    <td>Printer</td>
    <td>Rp.800.000</td>
    <td><button id="beli" nama="Printer" harga="800000">Beli</button></td>
</tr>
    <tr>
        <td>3.</td>
        <td>Sandal</td>
        <td>Rp.10.000</td>
        <td><button id="beli" nama="Sandal" harga="100000">Beli</button></td>
    </tr>
</table>

<h3>Keranjang Belanja</h3>
    <div class="keranjang">
</div>


JS.

var i=0;
$("#beli").live("click", function(){
    var nama=$(this).attr('nama');
    var harga=$(this).attr('harga');
    var total=harga+harga;
    i++;
   $('.keranjang').append('<p>'+i+' | ' +nama+ ' | ' +harga +'<button class="rm">Batal</button></p>');
    
   return false;
});

$(".rm").live("click", function(){
    $(this).parents('p').remove();i--;
});


Mengatasi Event Close Tidak Berfungsi di Dialog jQuery

Mengatasi Event Close Tidak Berfungsi di Dialog jQuery

$( "#konfirmasi" ).dialog({
autoOpen: false,
resizable: false,
height:180,
modal: true,
hide: 'Slide',
buttons: {
"Hapus": function() {   
var del_id = {id : $("#del_id").val()}; 
$.ajax({
type: "POST",
url : "/abby/index.php/home/delete",
data: del_id,
context: $(this),
success: function(msg){  
$(this).dialog('close'); 
$('#show').html(msg); 
}
  });
},
Batal: function() {  
$( this ).dialog( "close" );
},
close: function() {  
});

solusinya :

Ganti $(this).dialog('close');  menjadi $(this).dialog('close').remove(); 
Validasi Upload Tipe File dengan jQuery

Validasi Upload Tipe File dengan jQuery

HTML

<form action"#" method="post">
<input type="file" name="gambar" id="gambar"  />
<input id="tekan" type="submit" value="Upload"/>
</form>

JAVASCRIPT


<script type="text/javascript">


$(function(){
$('#tekan').click(function(){
 var file = $('#gambar').val(); //Ambil Value 
 var ekstensi = ['jpg','png']; //Variabel array untuk penentuan Ekstensi
  if ( file ) { 
   var ambilekstensi = file.split('.');  //Ambil Ekstensi
       ambilekstensi = ambilekstensi.reverse(); 
   if ( $.inArray ( ambilekstensi[0].toLowerCase(), ekstensi ) > -1 ){
          return true;  //jika cocok return true
        } 
   else {
          alert( 'Tipe Foto harus .jpg' );  //Alert jika ekstensi tidak cocok
        }
      }
  else
      {
         alert('Pilih Foto'); //Alert jika value null 
      }
  return false;
 });

});
</script>


Demo : http://jsfiddle.net/fgQw5/

Mencari Minimal dari Hasil Count MySQL

Mencari Minimal dari Hasil Count MySQL



mysql> desc produksi;
+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| id_pegawai | char(4) | YES  |     | NULL    |       |
| id_barang  | char(4) | YES  |     | NULL    |       |
+------------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)



mysql> select * from produksi;
+------------+-----------+
| id_pegawai | id_barang |
+------------+-----------+
| PEG1       | BAR1      |
| PEG1       | BAR2      |
| PEG1       | BAR3      |
| PEG2       | BAR1      |
| PEG2       | BAR2      |
| PEG2       | BAR3      |
| PEG2       | BAR4      |
| PEG3       | BAR1      |
| PEG3       | BAR2      |
| PEG3       | BAR3      |
| PEG3       | BAR4      |
| PEG3       | BAR5      |
| PEG3       | BAR6      |
+------------+-----------+
13 rows in set (0.00 sec)


Mencari Jumlah dengan Query Count :

mysql> select count(id_barang) hasilcount from produksi group by id_pegawai;

+------------+
| hasilcount |
+------------+
|          3 |
|          4 |
|          6 |
+------------+
3 rows in set (0.00 sec)

Mencari Minimal dari hasil count dengan Query Min :

mysql> select min(hasilcount) from (select count(id_barang) hasilcount from produksi group by id_pegawai) as minimal;

+-----------------+
| min(hasilcount) |
+-----------------+
|               3 |
+-----------------+
1 row in set (0.00 sec)