Sabtu, 30 Maret 2019

Kode Limited, Unlimited dan AJAX


Kode Autogenerate yang jumlahnya sedikit (<100):

  $sql="select `kd_user` from `$tbuser` order by `kd_user` desc";
  $jum= getJum($conn,$sql);
  $kd="ADM";
if($jum > 0){
$d=getField($conn,$sql);
    $idmax=$d['kd_user'];
$urut=substr($idmax,3,2)+1;//01
if($urut<10){$idmax="$kd"."0".$urut;}
else{$idmax="$kd".$urut;}
}
else{$idmax="$kd"."01";}
$kd_user=$idmax;

jadinya:
ADM01
ADM02
ADM03
dst...


Kode Autogenerate yang jumlahnya Unlimited (>100 ~):

  $sql="select `kd_daftar` from `$tbdaftar` order by `kd_daftar` desc";
  $q=mysqli_query($conn, $sql);
  $jum=mysqli_num_rows($q);
  $th=date("y");
  $bl=date("m")+0;if($bl<10){$bl="0".$bl;}

  $kd="REG".$th.$bl;
  if($jum > 0){
   $d=mysqli_fetch_array($q);
   $idmax=$d["kd_daftar"];
 
   $bul=substr($idmax,5,2);
   $tah=substr($idmax,3,2);
    if($bul==$bl && $tah==$th){
     $urut=substr($idmax,7,3)+1;
     if($urut<10){$idmax="$kd"."00".$urut;}
     else if($urut<100){$idmax="$kd"."0".$urut;}
     else{$idmax="$kd".$urut;}
    }//==
    else{
     $idmax="$kd"."001";
     } 
   }//jum>0
  else{$idmax="$kd"."001";}
  $kd_daftar=$idmax;

jadinya:
REG1903001
REG1903002
REG1903003
...
REG1904001
REG1904002
REG1904003
...
REG2001001
REG2001002
...



Konversi Tanggal ke Hari:

$tgl="2019-03-01";

$dayofweek = date('l', strtotime($tgl));//w =angka, l=nama hari dalam inggris
$hari="Senin";
if($dayofweek=="Sunday"){$hari="Minggu";}
else if($dayofweek=="Monday"){$hari="Senin";}
else if($dayofweek=="Tuesday"){$hari="Selasa";}
else if($dayofweek=="Wednesday"){$hari="Rabu";}
else if($dayofweek=="Thrusday"){$hari="Kamis";}
else if($dayofweek=="Friday"){$hari="Jumat";}
else if($dayofweek=="Saturday"){$hari="Sabtu";}



Konvversi Tanggal ke YMD

function BAL($tanggal){
$arr=split(" ",$tanggal);
if($arr[1]=="Januari" || $arr[1]=="January"){$bul="01";}
else if($arr[1]=="Februari" || $arr[1]=="February"){$bul="02";}
else if($arr[1]=="Maret" || $arr[1]=="March"){$bul="03";}
else if($arr[1]=="April" || $arr[1]=="April"){$bul="04";}
else if($arr[1]=="Mei"  || $arr[1]=="May"){$bul="05";}
else if($arr[1]=="Juni"  || $arr[1]=="June"){$bul="06";}
else if($arr[1]=="Juli"  || $arr[1]=="July"){$bul="07";}
else if($arr[1]=="Agustus"  || $arr[1]=="August"){$bul="08";}
else if($arr[1]=="September"  || $arr[1]=="September"){$bul="09";}
else if($arr[1]=="Oktober"  || $arr[1]=="October"){$bul="10";}
else if($arr[1]=="November"  || $arr[1]=="November"){$bul="11";}
else if($arr[1]=="Nopember"  || $arr[1]=="November"){$bul="11";}
else if($arr[1]=="Desember"  || $arr[1]=="December"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}



Konversi YMD ke Indonesia

function WKT($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,0,4);

$judul_bln=array(1=> "Januari", "Februari", "Maret", "April", "Mei","Juni", "Juli", "Agustus", "September","Oktober", "November", "Desember");
$wk=$tanggal." ".$judul_bln[(int)$bulan]." ".$tahun;
return $wk;
}



Konversi Nominal Ke Rupiah:
<?php function RP($rupiah){return number_format($rupiah,"2",",",".");}?> 


AJAX

Artinya:
saat saya pilih tanggal 13 maret 2019, lalu pilih klinik Umum, maka
pilihan jadwal yang dimunculkan hanyalah
data semua jadwal yang ada di hari tsb ( 13 maret 2019= SABTU), dan klinik yang di sediakan hanya yang kategori UMUM.


<script type="text/javascript">
var xmlHttp

function showKlinik(str){ 
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null){
 alert ("Browser tidak support HTTP Request")
 return
 } 
var tgl=document.getElementById("tanggal_periksa").value;

var url="getjadwal.php"
url=url+"?q="+str+"&tgl="+tgl+"&ket=ok"
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=SC1 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function SC1() { 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 
 document.getElementById("txtHint").innerHTML=xmlHttp.responseText 
 } 
}

function GetXmlHttpObject(){
var xmlHttp=null;
try{xmlHttp=new XMLHttpRequest();}
catch (e){
try{xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");}
  catch (e){xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");}
 }
return xmlHttp;
}
</script>


PADA GUI/ LAYOUT:

<select class="form-control" name="klinik" id="klinik"  onChange="showKlinik(this.value)">
    <option>Pilih Klinik</option>
    <option value="Umum" <?php if($klinik=="Umum"){echo"selected";}?>>Umum</option>
    <option value="Gigi" <?php if($klinik=="Gigi"){echo"selected";}?>>Gigi</option>
  </select>

<div id="txtHint">
  <select class="form-control" name="kd_jadwal" id="kd_jadwal">
    <option>Pilih Jadwal</option>
  <?php
  $s="select * from `tb_jadwal`";
$q=getData($conn,$s);
foreach($q as $d){
$kd_jadwal0=$d["kd_jadwal"];
$jadwal=$d["hari"]." | ".$d["jam"];
echo"<option value='$kd_jadwal0' ";if($kd_jadwal0==$kd_jadwal){echo"selected";} echo">$kd_jadwal0 - $jadwal  </option>";
}
?>
  </select>
  </div>

+++++++++++++++++++++++++++++++++++++++++++++
getjadwal.php
  <?php
date_default_timezone_set("Asia/Jakarta");
require_once"konmysqli.php";

$q=$_GET["q"];
$tgl=BAL($_GET["tgl"]);

$dayofweek = date('l', strtotime($tgl));//w l
$hari="Senin";
if($dayofweek=="Sunday"){$hari="Minggu";}
else if($dayofweek=="Monday"){$hari="Senin";}
else if($dayofweek=="Tuesday"){$hari="Selasa";}
else if($dayofweek=="Wednesday"){$hari="Rabu";}
else if($dayofweek=="Thrusday"){$hari="Kamis";}
else if($dayofweek=="Friday"){$hari="Jumat";}
else if($dayofweek=="Saturday"){$hari="Sabtu";}
?>


  <select class="form-control" name="kd_jadwal" id="kd_jadwal">
    <option>Pilih Jadwal <?php echo $hari;?></option>
  <?php
  $s="select * from `tb_jadwal` where klinik='$q' and hari='$hari'";
$q=getData($conn,$s);
foreach($q as $d){
$kd_jadwal0=$d["kd_jadwal"];
$jadwal=$d["jam"];
$dokter=getDokter($conn,$d["nip_dokter"]);
echo"<option value='$kd_jadwal0' ";echo">$jadwal :$dokter </option>";
}
?>
  </select>
  
  <?php
  function getDokter($conn,$kode){
$field="nama_dokter";
$sql="SELECT `$field` FROM `tb_dokter` where `nip_dokter`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $row[$field];
}
  
function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
//  echo $row['nama_kelas'] . '*<br>';
//}
$rs->free();
return $arr;
}

?>


<?php
function BAL($tanggal){
$arr=split(" ",$tanggal);
if($arr[1]=="Januari" || $arr[1]=="January"){$bul="01";}
else if($arr[1]=="Februari" || $arr[1]=="February"){$bul="02";}
else if($arr[1]=="Maret" || $arr[1]=="March"){$bul="03";}
else if($arr[1]=="April" || $arr[1]=="April"){$bul="04";}
else if($arr[1]=="Mei"  || $arr[1]=="May"){$bul="05";}
else if($arr[1]=="Juni"  || $arr[1]=="June"){$bul="06";}
else if($arr[1]=="Juli"  || $arr[1]=="July"){$bul="07";}
else if($arr[1]=="Agustus"  || $arr[1]=="August"){$bul="08";}
else if($arr[1]=="September"  || $arr[1]=="September"){$bul="09";}
else if($arr[1]=="Oktober"  || $arr[1]=="October"){$bul="10";}
else if($arr[1]=="November"  || $arr[1]=="November"){$bul="11";}
else if($arr[1]=="Nopember"  || $arr[1]=="November"){$bul="11";}
else if($arr[1]=="Desember"  || $arr[1]=="December"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>




di Tidak ada komentar:
Langganan: Postingan (Atom)

Mencari Tanggal Terakhir Suatu Bulan

  $a_date = "$tahun-$bulan-01"; $lastdate= date('t',strtotime($a_date));//Y-m-t <?php require_once"koneksivar.php&...

  • Membuat Soal Random menggunakan SESSION
    Teman2 ...mungkin sering dapat kode random..... btw ini ada share sedikit ttg membuat soal random.....yang beda disini adalah sy menggunaka...
  • Kode Download PHP
    <?php //  <a href='download.php?file=$file' title='Download File'>Download Dokumen</a>  $direktori = "...
  • Source Code Koleksi
    <?php  $sql="select `id_admin` from `$tbadmin` order by `id_admin` desc";   $jum= getJum($conn,$sql);   $kd="ADM"...