Jumat, 24 Januari 2020

PHP COde CF dan Forward Chaining







<link rel="stylesheet" href="jsacordeon/jquery-ui.css">
  <link rel="stylesheet" href="resources/demos/style.css">
<script src="jsacordeon/jquery-1.12.4.js"></script>
  <script src="jsacordeon/jquery-ui.js"></script>
  <script>
  $( function() {
    $( "#accordion" ).accordion({
      collapsible: true
    });
  } );
  </script>
 
<div id="accordion">
  <h3>Pilih Gejala</h3>
  <div>

<form action="" method="post" enctype="multipart/form-data">

<table class="table table-striped table-bordered table-hover"  width="100%" border="0">
  <tr bgcolor="#cccccc">
    <th width="3%">No</td>
<th width="3%">IDGejala</td>
    <th width="40%">Nama Gejala</td>
<th width="40%">Deskripsi</td>
    <th width="5%">Pilih</td>
  </tr>
<?php 
$no=1;
  $sql="select * from `$tbgejala` order by `id_gejala` asc";
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_gejala=$d["id_gejala"];
$nama_gejala=$d["nama_gejala"];
$deskripsi=$d["deskripsi"];
$color="#dddddd";
$i=$no-1;
echo"<input type='hidden' value='$id_gejala' name='id_gejala$i'>";
if($no %2==0){$color="#eeeeee";}
echo"<tr bgcolor='$color'>
<td>$no</td>
<td>$id_gejala</td>
<td><b>$nama_gejala</b></br>
<td>$deskripsi</td>
<td><div align='center'>
<input type='checkbox'  name='pil$i' value='1'>
</td>
</tr>";

$no++;
}//while checked
?>




<tr>
<td>
<td>
<td colspan="3" align="right">
<input type="hidden" value="<?php echo $i;?>" name="i">
<input name="Simpan" type="submit" id="Simpan" value="Simpan" />
            <input name="Reset" type="Reset" id="Reset" value="Reset" />
</td></tr>
</table>
</form>
</div>
</div>

<?php
if(isset($_POST["Simpan"])){
$no=strip_tags($_POST["i"]);

$sql="select * from `$tbpenyakit` order by `id_penyakit` asc";
$arr=getData($conn,$sql);
$i=0;
foreach($arr as $d) {
$adaP[$i]=0;
//$bobotP[$i]=0;
//$rekapP[$i]="";
$listP[$i]="";
$id_penyakit=$d["id_penyakit"];
$nama_penyakit=$d["nama_penyakit"];
$j=0;
$sql2="select * from `$tbrelasi` where `id_penyakit`='$id_penyakit' order by `id_relasi` asc";
$arr2=getData($conn,$sql2);
foreach($arr2 as $d2) {
$id_gejala=$d2["id_gejala"];
$listP[$i].="$id_gejala#";
$sql3="select `bobot` from `$tbgejala` where `id_gejala`='$id_gejala'";
$d3=getField($conn,$sql3);
$bobot=$d3["bobot"];

$arB[$i][$j]=$bobot;
$arG[$i][$j]=$id_gejala;
$j++;
}//arr2
$arJum[$i]=$j;
$arIP[$i]=$id_penyakit;
$arNP[$i]=$nama_penyakit;
$i++;
}//arr

$x=$i;


$pilihan="";
$p=0;
for($m=0;$m<=$no;$m++){
if(isset($_POST["pil$m"]) && $_POST["pil$m"]==1){
$id_gejalapilih=$_POST["id_gejala$m"];
$arPilihan[$p]=$id_gejalapilih;
$p++;
$pilihan.="$id_gejalapilih#";
}
}

for($i=0;$i<$x;$i++){
$jumG=$arJum[$i];
$c=0;
$adagab="";
for($j=0;$j<$jumG;$j++){
for($k=0;$k<$p;$k++){
$id_gejalapilih=$arPilihan[$k];
if($id_gejalapilih==$arG[$i][$j]){
$adagab.="$id_gejalapilih#";
$adaP[$i]++;
if($c<1){
$bobotP[$i][$c]=$arB[$i][$j];
$rekapP[$i][$c]="$i-$j: $id_gejalapilih (".$arB[$i][$j]."),";
$c++;
}
else{
$bbt=$arB[$i][$j];
$old=$bobotP[$i][$c-1];
$CF=$old+$bbt*(1-$old);
$bobotP[$i][$c]=$CF;
$rekapP[$i][$c]="$id_gejalapilih (".$bbt.")=>$old+$bbt*(1-$old)=>$CF";
$c++;
}//CF
}
}//k
}//j
//echo "PIL $i=".$adagab."<hr>";
$arJum2[$i]=$c;
}//i


$gab="Gejala terpilih: $pilihan<hr>";
$fc=false;
for($i=0;$i<$x;$i++){
$no=$i+1;
$jumG=$arJum[$i];
if($adaP[$i]==$jumG && $jumG>0){
$gab.= "$no.<b>".$arNP[$i]."</b>=".$listP[$i];
$fc=true;
$gab.="<font color='red'>Terdiagnosa 100% $arNP[$i]</font><br>";
}
}//for i

if($fc==true){
echo $gab;
}
else{
for($i=0;$i<$x;$i++){
$jumG=$arJum[$i];
$jumG2=$arJum2[$i];
$VCF[$i]=$bobotP[$i][$jumG2-1];
$SCF[$i]=$rekapP[$i][$jumG2-1];
$rgab= "<b>".$arNP[$i]."</b>=".$listP[$i].": dari $jumG terpilih $jumG2<br>";
for($j=0;$j<$jumG2;$j++){
$rgab.="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CF$j =".$rekapP[$i][$j]."=".$bobotP[$i][$j]."<br>";
}
$RCF[$i]=$rgab;
$gab.="<b>$no</b>".$rgab;
}

//echo $gab;

$array_count = $x;
        for($x = 0; $x < $array_count; $x++){
            for($a = 0 ;  $a < $array_count - 1 ; $a++){
                if($a < $array_count ){
                    if($VCF[$a] < $VCF[$a + 1] ){
                            swap($VCF, $a, $a+1);
swap($SCF, $a, $a+1);
swap($arIP, $a, $a+1);
swap($arNP, $a, $a+1);
swap($RCF, $a, $a+1);
                    }
                }
            }
        }

echo"<hr>";
for($i=0;$i<$x;$i++){
$no=$i+1;
echo "$no.<b>".$arNP[$i]."</b><br>".$RCF[$i]."=<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;".$VCF[$i]."</b><br>";
}//for i
}//false


}//if isset
?>

<?php
if($_GET["pro"]=="hapus"){
$id_gejala=$_GET["kode"];
$sql="delete from `$tbgejala` where `id_gejala`='$id_gejala'";
$hapus=process($conn,$sql);
if($hapus) {echo "<script>alert('Data $id_gejala berhasil dihapus !');document.location.href='?mnu=gejala';</script>";}
else{echo"<script>alert('Data $id_gejala gagal dihapus...');document.location.href='?mnu=gejala';</script>";}
}


 function swap(&$arr, $a, $b) {
        $tmp = $arr[$a];
        $arr[$a] = $arr[$b];
        $arr[$b] = $tmp;
    }
?>



PHP Menghtung IMT




Indeks massa tubuh (IMT) adalah proksi heuristik untuk lemak tubuh manusia berdasarkan berat badan seseorang dan tinggi.

1 . Rumus IMT Bayi dan Balita
Untuk menghitung Berat Badan Ideal (BBI) pada bayi, balita dan Anak

a. Usia 1-6 bulan menggunakan rumus :
BBL (gr) +(usia x 600 gram)

b. Usia 7-12 bulan menggunakan rumus :
BBL (gr) + (usia x 500 gram )
(usia/2) +3
Keterangan :
BBL yaitu Berat Badan Lahir Usia dinyatakan dalam bulan.

Contoh 1:
Anak balita memilikiusia 14 bulan. Karena n ialah usia dalam tahun dan bulan maka 1 tahun 2 bulan ditulis dengan 1,2 ( dibaca 1 tahun 2 bulan). kemudidan masukan kedalam rumus yaitu :
(2 x 1,2) + 8 = 2,4 + 8 = 10,4

Contoh 2 :
Anak balita usia 2 tahun 10 bulan, seperti diatas ditulis dengan n=2,10
Kemudian dikali dengan 2, Maka hasilnya yaitu 4,20.

Hasil ini jangan langsung ditambah dengan 8, karena 4,20 diartikan 4 tahun 20 bulan,
20 bulan artinya 1 tahun 8 bulan, jadi 4,20 berubah menjadi 5,8,
baru kemudian ditambah dengan 8 maka Berat badan Idealnya adalah 13,8 kg.


2 . Rumus IMT  Anak
Berat Badan Ideal Balita (0-5 tahun) bisa juga digunakan sampai dg usia 10 tahun :
BBI anak = 2n + 8


3. Rumus IMT Orang Dewasa
Untuk mencari Berat Badan Ideal (BBI) Orang Dewasa (berusia diatas 15 tahun keatas) :
BBI = ((TB – 100) ± 10% (TB-100))

Atau menggunakan Rumus Indeks Massa Tubuh (IMT) keluaran Depkes Republik Indonesia yaitu :
IMT = BB (Kg) / TB^2 (m)



Inteprestasi Status gizi berdasarkan IMT yaitu :
Sangat kurus jika nilai IMT <17.0
Kurus tingkat Ringan Jika nilai IMT berada diantara 17.0- 18.4
Ideal jika nilai IMT berada diantara 18,5 – 25.0
Gemuk Jika IMT berada 25,1 -27.0
Gemuk tingkat berat jika nilai IMT berada >27

Contoh
Diketahui seorang pria dengan tinggi 165 cm mempunyai berat badan 73 kg.
Jika ingin menghitung IMT orang tersebut, maka proses penghitungannya adalah

Berat Badan = 67 kg;
Tinggi Badan = 165 cm = 1,65 m;
IMT = Berat Badan / (Tinggi Badan x Tinggi Badan) = 67 / (1,65 x 1,65)
IMT = 24,6



$tanggal=date("Y-m-d");
$berat_badan=strip_tags($_POST["berat_badan"]);
$tinggi_badan=strip_tags($_POST["tinggi_badan"]);
$tindakan=strip_tags($_POST["tindakan"]);
$imunisasi=strip_tags($_POST["imunisasi"]);
$id_user=strip_tags($_SESSION["cid"]);
$id_balita=strip_tags($_POST["id_balita"]);

$sql="select * from `$tbbalita` where `id_balita`='$id_balita'";
$d=getField($conn,$sql);
$nama_balita=$d["nama_balita"];
$tanggal_lahir=$d["tanggal_lahir"];



$waktuawal  = date_create($tanggal_lahir);
$waktuakhir = date_create();
$diff  = date_diff($waktuawal, $waktuakhir);
$tahun= $diff->y . ' tahun, ';
$bulan= $diff->m . ' bulan, ';
$usiabulan=($tahun *12)+$bulan;

if($usiabulan>60){
echo "<script>alert('Maaf Data ini sudah Kategori Dewasa...(>5 tahun) !');document.location.href='?mnu=pdetailbalita';</script>";
}
else{
if($usiabulan<=6){
$ket="Untuk usia 1-6 bulan dapat memakai rumus: BBL (gr) +( usia x 600 gram )";
$IMT=$berat_badan+($usiabulan*600);
}
else if($usiabulan<=12){
$ket="Untuk usia 7-12 bulan dapat memakai rumus: BBL (gr) + ( usia x 500 gram ) Atau (usia/2) +3";
$IMT=$berat_badan+($usiabulan*500);
}
else{
$ket="Berat Badan Ideal Bagi Balita (sd 5 tahun): BBI anak = 2n + 8";
$IMT=2 * $usiabulan+8;
}
$indeks_massa_tubuh=$IMT;
 
$status="";
if($indeks_massa_tubuh<18.5){$status="Berat Badan Kurang";$keterangan="";}
else if($indeks_massa_tubuh<25){$status="Berat Badan Ideal";$keterangan="";}
else if($indeks_massa_tubuh<30){$status="Berat Badan Lebih";$keterangan="";}
else if($indeks_massa_tubuh<40){$status="Gemuk";$keterangan="";}
else if($indeks_massa_tubuh>=40){$status="Sangat Gemuk";$keterangan="";}

$keterangan=$ket;
$tinggi_badan=$usiabulan;




?>



$indeks_massa_tubuh=$berat_badan/($tinggi_badan * $tinggi_badan);
$status="";
if($indeks_massa_tubuh<18.5){$status="Berat Badan Kurang";$keterangan="";}
else if($indeks_massa_tubuh<25){$status="Berat Badan Ideal";$keterangan="";}
else if($indeks_massa_tubuh<30){$status="Berat Badan Lebih";$keterangan="";}
else if($indeks_massa_tubuh<40){$status="Gemuk";$keterangan="";}
else if($indeks_massa_tubuh>=40){$status="Sangat Gemuk";$keterangan="";}



Reff: https://rumusrumus.com/rumus-imt/

Kamis, 23 Januari 2020

PHP Code selisih Tahun bulan tanggal jam menit detik

$waktuawal  = date_create('2018-02-21 09:00:00'); //waktu di setting
$waktuakhir = date_create(); //2019-02-21 09:35 waktu sekarang
$diff  = date_diff($waktuawal, $waktuakhir);


echo 'Selisih waktu: ';
echo $diff->y . ' tahun, ';
echo $diff->m . ' bulan, ';
echo $diff->d . ' hari, ';
echo $diff->h . ' jam, ';
echo $diff->i . ' menit, ';
echo $diff->s . ' detik, ';





Contoh:
$tanggal_lahir=""20-01-2019;

$waktuawal  = date_create($tanggal_lahir);
$waktuakhir = date_create();

$diff  = date_diff($waktuawal, $waktuakhir);

$tahun= $diff->y . ' tahun, ';
$bulan= $diff->m . ' bulan, ';

$usiabulan=($tahun *12)+$bulan;



Selasa, 21 Januari 2020

PHP Code Promethe









Code sbb:

<?php
$pro="simpan";
$tanggal=WKT(date("Y-m-d"));
?>
<link type="text/css" href="<?php echo "$PATH/base/";?>ui.all.css" rel="stylesheet" /> 
<script type="text/javascript" src="<?php echo "$PATH/";?>jquery-1.3.2.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.core.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.datepicker.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/i18n/ui.datepicker-id.js"></script>
 
  <script type="text/javascript">
      $(document).ready(function(){
        $("#tanggal").datepicker({
dateFormat  : "dd MM yy",     
          changeMonth : true,
          changeYear  : true
        });
      });
    </script> 

<script type="text/javascript">
function PRINT(){
win=window.open('penilaian/print.php','win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, param1=0'); }
</script>
<script language="JavaScript">
function buka(url) {window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');}
</script>

<h4 class="blue">
<i class="ace-icon fa fa-check bigger-110"></i>
<div id="faq-list-1" class="panel-group accordion-style1 accordion-style2">

   <h3>Data Penilaian</h3>

<table width="100%" border="0" class="table table-striped table-bordered table-hover">
  <tr bgcolor="#036">
    <th width="3%"><center>No</th>
    <th width="30%"><center>Siswa</th>
    <th width="15%"><center><?php echo $nparam1;?></th>
    <th width="15%"><center><?php echo $nparam2;?></th>
    <th width="15%"><center><?php echo $nparam3;?></th>
    <th width="15%"><center><?php echo $nparam4;?></th>
    <th width="15%"><center><?php echo $nparam5;?></th>
  </tr>
<?php
  $sv="select * from `$tbpenilaian` where kode_periode='$kode_periodeaktif' order by `kode_penilaian` asc";
  $qv=mysqli_query($conn,$sv);
  $jumv=mysqli_num_rows($qv);
  $i=0;
  $no=1;
    while($dv=mysqli_fetch_array($qv)){                       
                $kode_kelas=$dv["kode_kelas"];               
                $namakelas=getKelas($conn,$dv["kode_kelas"]);
$kode_penilaian=$dv["kode_penilaian"];

$KN[$i]=$dv["kode_penilaian"];

$nis=$dv["nis"];
$nama=getSiswa($conn,$dv["nis"]);

$arNis[$i]=$nis;
$arNama[$i]=$nama;
$keterangan=$dv["keterangan"];
$aparam1[$i]=$dv["param1"];
$aparam2[$i]=$dv["param2"];
$aparam3[$i]=$dv["param3"];
$aparam4[$i]=$dv["param4"];
$aparam5[$i]=$dv["param5"];

$anis[$i]=$dv["nis"];
$anama[$i]=$nis;

$VP[0][$i]=getV1($aparam1[$i]);
$VP[1][$i]=getV2($aparam2[$i]);
$VP[2][$i]=getV3($aparam3[$i]);
$VP[3][$i]=getV4($aparam4[$i]);
$VP[4][$i]=getV5($aparam5[$i]);


$color="#dddddd";
if($no %2==0){$color="#eeeeee";}

echo"<tr bgcolor='$color'>
<td>$no</td>
<td>$nis</td>
<td>".$aparam1[$i]."</td>
<td>".$aparam2[$i]."</td>
<td>".$aparam3[$i]."</td>
<td>".$aparam4[$i]."</td>
<td>".$aparam5[$i]."</td>
</tr>";
$no++;
$i++;
}

            ?> 
   </table><br />
 
<!---------------------------------------------------------------------- -->

 <h3>Data Normalisasi</h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">
  <tr bgcolor="#036">
    <th width="3%"><center>No</th>
    <th width="30%"><center>Siswa</th>
    <th width="15%"><center><?php echo $nparam1;?></th>
    <th width="15%"><center><?php echo $nparam2;?></th>
    <th width="15%"><center><?php echo $nparam3;?></th>
    <th width="15%"><center><?php echo $nparam4;?></th>
    <th width="15%"><center><?php echo $nparam5;?></th>
  </tr>
<?php
  $no=1;
for($j=0;$j<$i;$j++){
$color="#dddddd";
if($no %2==0){$color="#eeeeee";}

echo"<tr bgcolor='$color'>
<td>$no</td>
<td>$nis</td>
<td>".$VP[0][$j]."</td>
<td>".$VP[1][$j]."</td>
<td>".$VP[2][$j]."</td>
<td>".$VP[3][$j]."</td>
<td>".$VP[4][$j]."</td>
</tr>";
$no++;
}

            ?> 
 </table> </br>

<!---------------------------------------------------------------------- -->



 <h3>Data Normalisasi'</h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">

<?php
echo"<tr><td>";
for($j=0;$j<$i;$j++){
echo"<td>".$anis[$j];
}
echo"</tr>";

for($k=0;$k<5;$k++){
echo"<tr><td>";
for($j=0;$j<$i;$j++){
echo"<td>".$VP[$k][$j]."</td>";
}
echo"</tr>";          
}
?>
             
 </table> </br>

<!---------------------------------------------------------------------- -->
<?php
for($k=0;$k<$i;$k++){
for($j=0;$j<$i;$j++){
$COBA[$k][$j]=0;
}
}

for($m=0;$m<$i;$m++){
?>
 <h3>Data Normalisasi' <?php echo "$m - ".($m+1);?></h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">

<?php

for($k=0;$k<5;$k++){
echo"<tr><td>";
for($j=0;$j<$i;$j++){
$SEL[$k][$j]=($VP[$k][$m]-$VP[$k][$j]);
if($SEL[$k][$j]>0){$HA[$m][$k][$j]=1;}
else{$HA[$m][$k][$j]=0;;}

if($m==$j){}
else{
echo"<td>".$SEL[$k][$j]."<td bgcolor='#cccccc'>".$HA[$m][$k][$j]."</td>";
$COBA[$m][$j]+=$HA[$m][$k][$j];
}            

}//j
echo"</tr>";
}//k

?>           
 </table> </br>
<?php
}
?>
<!---------------------------------------------------------------------- -->


 <h3>Data Hasil</h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">

<?php
         


for($k=0;$k<$i;$k++){
echo"<tr><td>";
for($j=0;$j<$i;$j++){
echo"<td>".$COBA[$k][$j]."</td>";
$KA[$k]+=$COBA[$k][$j];
$BA[$k]+=$COBA[$j][$k];
}
echo"</tr>";          
}

?>
             
 </table> </br>

<!---------------------------------------------------------------------- -->


 <h3>Hasil</h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">
<?php
echo"<tr><td>No<td>Nis<td>Nama Siswa<td>LF<td>EF<td>SUM</tr>";
for($k=0;$k<$i;$k++){
$KABA[$k]=$KA[$k]+$BA[$k];
echo"<tr><td>".($k+1)."<td>".$arNis[$k]."<td>".$arNama[$k]."<td>".$KA[$k]."<td>".$BA[$k]."<td>".$KABA[$k]."</tr>";
}
?>
</table>



<?php

  $size = count($arNis);
    for ($i=0; $i<$size; $i++) {
        for ($j=0; $j<$size-1-$i; $j++) {
            if ($KABA[$j+1] > $KABA[$j]) {
                swap($KABA, $j, $j+1);
swap($BA, $j, $j+1);
swap($KA, $j, $j+1);
swap($arNama, $j, $j+1);
swap($arNis, $j, $j+1);
swap($aparam5, $j, $j+1);
swap($KN, $j, $j+1);
            }
        }
    }

$max=$KABA[0];
$ada=1;
for ($i=1; $i<$size; $i++) {
if($KABA[$i]==$max){$ada=$ada+1;}
}
if($ada>1){
for ($i=0; $i<$ada; $i++) {
        for ($j=0; $j<$ada-1-$i; $j++) {
            if ($KABA[$j+1] > $KABA[$j]) {
                swap($KABA, $j, $j+1);
swap($BA, $j, $j+1);
swap($KA, $j, $j+1);
swap($arNama, $j, $j+1);
swap($arNis, $j, $j+1);
swap($aparam5, $j, $j+1);
swap($KN, $j, $j+1);
            }
        }
    }

}
?>



 <h3>Sorting Hasil</h3>
<table width="100%" border="0" class="table table-striped table-bordered table-hover">
<?php

$simpan=process($conn,"delete from tb_hasil where status='0'");

echo"<tr><td>No<td>Nis<td>Nama Siswa<td>LF<td>EF<td>SUM</tr>";
for($k=0;$k<$i;$k++){
$KABA[$k]=$KA[$k]+$BA[$k];
echo"<tr><td>".($k+1)."<td>".$arNis[$k]."<td>".$arNama[$k]."<td>".$KA[$k]."<td>".$BA[$k]."<td>".$KABA[$k]."</tr>";
$kelompok="$kode_periodeaktif" ."_"."$kode_kelas";
$R=$k+1;
$sql="INSERT INTO `tb_hasil` (`id`, `kode_penilaian`, `kode_periode`, `kode_kelas`, `nis`, `LF`, `EF`, `SUM`, `ranking`,`keterangan`,`status`,`kelompok`) VALUES ('', '".$KN[$k]."', '$kode_periodeaktif', '$kode_kelas', '".$arNis[$k]."', '".$KA[$k]."', '".$BA[$k]."', '".$KABA[$k]."', '$R','-','0','$kelompok');";
$simpan=process($conn,$sql);
}
?>
</table>



<?php
function swap(&$arr, $a, $b) {
    $tmp = $arr[$a];
    $arr[$a] = $arr[$b];
    $arr[$b] = $tmp;
}


?>



<a href="?mnu=aplikasi&st=simpan"><input type="button" value="SIMPAN"></a>

</div>


<?php
if(isset($_GET["st"])){
$sql="update `$tbhasil` set status='1'";
$hapus=process($conn,$sql);
if($hapus) {echo "<script>alert('Data hasil berhasil disimpan !');document.location.href='?mnu=hasil';</script>";}
else{echo"<script>alert('Data hasil  gagal disimpan...');document.location.href='?mnu=hasil';</script>";}
}
?>
function getV1($kode){
$v="";
if($kode >=0 && $kode<=2){$v=5;}
elseif($kode >=3 && $kode<=4){$v=4;}
elseif($kode ==5){$v=3;}
elseif($kode ==6 ){$v=2;}
elseif($kode >6 ){$v=1;}
return $v;
}

function getV2($kode){
$v="";
if($kode =="A"){$v=5;}
elseif($kode =="B"){$v=4;}
elseif($kode =="C"){$v=3;}
elseif($kode =="D" ){$v=2;}
elseif($kode =="E"){$v=1;}
return $v;
}
function getV3($kode){
$v="";
if($kode =="A"){$v=5;}
elseif($kode =="B"){$v=4;}
elseif($kode =="C"){$v=3;}
elseif($kode =="D" ){$v=2;}
elseif($kode =="E"){$v=1;}
return $v;
}

function getV4($kode){
$v="";
if($kode >=85 && $kode<=100){$v=5;}
elseif($kode >=75 && $kode<=84){$v=4;}
elseif($kode >=65 && $kode<=74){$v=3;}
elseif($kode >=60 && $kode<=64 ){$v=2;}
elseif($kode <60){$v=1;}
return $v;
}
function getV5($kode){
$v="";
if($kode ==1){$v=5;}
elseif($kode ==2){$v=4;}
elseif($kode ==3){$v=3;}
elseif($kode ==4){$v=2;}
elseif($kode ==5){$v=1;}
return $v;
}

Senin, 20 Januari 2020

PHP Code Sent Mail and Attachment

<?php

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;


date_default_timezone_set("Asia/Jakarta");
require_once "vendor/autoload.php";


$mail = new PHPMailer;


$mail->From = "adiarray1@sarjanacode.com";
$mail->FromName = "Riadi Marta Dinata";

$mail->addAddress("adiarray2@sarjanacode.com", "Recepient Name");
$mail->addAddress("adiarray3@sarjanacode.com"); //Recipient name is optional

//Address to which recipient will reply
$mail->addReplyTo("adiarray1@sarjanacode.com", "Reply");

//CC and BCC
$mail->addCC("adiarray4@sarjanacode.com");
$mail->addBCC("humas@lp2maray.com");

//Send HTML or Plain Text email
$mail->isHTML(true);

$jam=date("H:i:s");
$mail->Subject = "Subject Text TEs I ".$jam;
$mail->Body = "<i>Mail body in HTML</i>";
$mail->AltBody = "This is the plain text version of the email content";

if(!$mail->send()) {
    echo "Mailer Error: " . $mail->ErrorInfo."=".$jam;
}
else {
    echo "Message has been sent successfully".$jam;
}

?>








Sent Attachment:

<?php

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;


date_default_timezone_set("Asia/Jakarta");
require_once "vendor/autoload.php";


$mail = new PHPMailer;


$mail->From = "adiarray1@sarjanacode.com";
$mail->FromName = "Riadi Marta Dinata";

$mail->addAddress("adiarray2@sarjanacode.com", "Recepient Name");
$mail->addAddress("adiarray3@sarjanacode.com"); //Recipient name is optional

//Address to which recipient will reply
$mail->addReplyTo("adiarray1@sarjanacode.com", "Reply");

//CC and BCC
$mail->addCC("adiarray4@sarjanacode.com");
$mail->addBCC("humas@lp2maray.com");

$jam=date("H:i:s");

//Provide file path and name of the attachments
$mail->addAttachment("file.txt", "File.txt");     
$mail->addAttachment("images/aray.jpg"); //Filename is optional

$mail->isHTML(true);

$mail->Subject = "Subject Text";
$mail->Body = "<i>Mail body in HTML</i>".$jam;
$mail->AltBody = "This is the plain text version of the email content";

if(!$mail->send())
{
    echo "Mailer Error: " . $mail->ErrorInfo."=".$jam;
}
else
{
    echo "Message has been sent successfully ".$jam;
}

?>
Download

PHP Selisih Jam Untuk Parkir




        $sql="select * from `$tbparkir` where `id_parkir`='$id_parkir'";
$d=getField($conn,$sql);
$id_parkir=$d["id_parkir"];
                        $tanggal_masuk=($d["tanggal_masuk"]);
$jam_masuk=$d["jam_masuk"];
$gambar=$d["gambar"];
$tanggal_keluar=date("Y-m-d");
$jam_keluar=date("H:i:s");



$waktu_awal        =strtotime("$tanggal_masuk $jam_masuk");
        $waktu_akhir    =strtotime("$tanggal_keluar $jam_keluar");
        $diff    =$waktu_akhir - $waktu_awal;

        $jam    =floor($diff / (60 * 60));
        $menit    =$diff - $jam * (60 * 60);
$menit=floor( $menit / 60 ) ;
$ket="$jam jam $menit menit";

if($menit>5){$jam=$jam+1;}
$biaya=$jam * 2000;
$durasi=$jam;



Membuat Notif Automatis



<html>
<head>
 
<script type="text/javascript">
function Ajax(){
var $http,$self = arguments.callee;

if (window.XMLHttpRequest) {$http = new XMLHttpRequest();}
else if (window.ActiveXObject) {
try {$http = new ActiveXObject('Msxml2.XMLHTTP');}
catch(e) {$http = new ActiveXObject('Microsoft.XMLHTTP');}
}

if ($http) {
$http.onreadystatechange = function(){
if (/4|^complete$/.test($http.readyState)) {
document.getElementById('ReloadThis').innerHTML = $http.responseText;
setTimeout(function(){$self();}, 1000);
}
};
$http.open('GET', 'cek.php' + '?' + new Date().getTime(), true);
$http.send(null);
}
}
</script>
<script type="text/javascript">setTimeout(function() {Ajax();}, 1000);</script>

</head>

<body>
<ol>
    <li class="nav-item">
        <a class="nav-link" href="index.php?mnu=bayar">
          <i class="fab fa-fw fa-wpforms"></i>
          <span>Bayar  <label id="ReloadThis"><?php echo $ada;?></label></span>
        </a>
      </li>



cek.php

<?php

require_once"konmysqli.php";
 $sql="select `id_parkir` from `$tbparkir` where status='2' ";
  $jum=getJum($conn,$sql);
echo " <font color='red'><sup><b>$jum</b></sup></font>";

function getJum($conn,$sql){
  $rs=$conn->query($sql);
  $jum= $rs->num_rows;
$rs->free();
return $jum;
}

?>


Minggu, 19 Januari 2020

PHP GRAFIK ONLINE


  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

      function drawChart() {
        var data = google.visualization.arrayToDataTable([
          ['Year', 'Bimbel', 'Course'],
          ['2020',  1000,      400],
          ['2018',  1170,      460],
          ['2019',  660,       1120],
          ['2020',  2030,      2540]
        ]);

        var options = {
          title: 'LP2M ARAY GRAPH',
          curveType: 'function',
          legend: { position: 'bottom' }
        };

        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>






  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['line']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {

      var data = new google.visualization.DataTable();
      data.addColumn('number', 'Day');
      data.addColumn('number', 'Bimbel PHP');
      data.addColumn('number', 'Bimbel Android');
      data.addColumn('number', 'Bimbel 3D / Animasi');

      data.addRows([
        [1,  37.8, 80.8, 41.8],
        [2,  30.9, 69.5, 32.4],
        [3,  25.4,   57, 25.7],
        [4,  11.7, 18.8, 10.5],
        [5,  11.9, 17.6, 10.4],
        [6,   8.8, 13.6,  7.7],
        [7,   7.6, 12.3,  9.6],
        [8,  12.3, 29.2, 10.6],
        [9,  16.9, 42.9, 14.8],
        [10, 12.8, 30.9, 11.6],
        [11,  5.3,  7.9,  4.7],
        [12,  6.6,  8.4,  5.2],
        [13,  4.8,  6.3,  3.6],
        [14,  4.2,  6.2,  3.4]
      ]);

      var options = {
        chart: {
          title: 'Difficulty Studying and Earnings in Two Weeks of Starting',
          subtitle: 'Level Kesulitan Pembelajaran (Siswa)'
        },
        width: 900,
        height: 500
      };

      var chart = new google.charts.Line(document.getElementById('curve_chart'));

      chart.draw(data, google.charts.Line.convertOptions(options));
    }
   </script>
 </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>


  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['line']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {

      var data = new google.visualization.DataTable();
      data.addColumn('number', 'Day');
      data.addColumn('number', 'Guardians of the Galaxy');
      data.addColumn('number', 'The Avengers');
      data.addColumn('number', 'Transformers: Age of Extinction');

      data.addRows([
        [1,  37.8, 80.8, 41.8],
        [2,  30.9, 69.5, 32.4],
        [3,  25.4,   57, 25.7],
        [4,  11.7, 18.8, 10.5],
        [5,  11.9, 17.6, 10.4],
        [6,   8.8, 13.6,  7.7],
        [7,   7.6, 12.3,  9.6],
        [8,  12.3, 29.2, 10.6],
        [9,  16.9, 42.9, 14.8],
        [10, 12.8, 30.9, 11.6],
        [11,  5.3,  7.9,  4.7],
        [12,  6.6,  8.4,  5.2],
        [13,  4.8,  6.3,  3.6],
        [14,  4.2,  6.2,  3.4]
      ]);


var pilihan2 = {
        chart: {
          title: 'Average Temperatures and Daylight in Iceland Throughout the Year'
        },
        width: 900,
        height: 500,
        series: {
          // Gives each series an axis name that matches the Y-axis below.
          0: {axis: 'Temps'},
          1: {axis: 'Daylight'}
        },
        axes: {
          // Adds labels to each axis; they don't have to match the axis names.
          y: {
            Temps: {label: 'Temps (Celsius)'},
            Daylight: {label: 'Daylight'}
          }
        }
      };
  
      var pilihan1 = {
        chart: {
          title: 'Box Office Earnings in First Two Weeks of Opening',
          subtitle: 'in millions of dollars (USD)'
        },
        width: 900,
        height: 500
      };

      var chart = new google.charts.Line(document.getElementById('curve_chart'));

      chart.draw(data, google.charts.Line.convertOptions(pilihan2));
    }
   </script>
 </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>




<html>
<head>
  <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['line']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {

      var data = new google.visualization.DataTable();
      data.addColumn('number', 'Day');
      data.addColumn('number', 'Guardians of the Galaxy');
      data.addColumn('number', 'The Avengers');
      data.addColumn('number', 'Transformers: Age of Extinction');

      data.addRows([
        [1,  37.8, 80.8, 41.8],
        [2,  30.9, 69.5, 32.4],
        [3,  25.4,   57, 25.7],
        [4,  11.7, 18.8, 10.5],
        [5,  11.9, 17.6, 10.4],
        [6,   8.8, 13.6,  7.7],
        [7,   7.6, 12.3,  9.6],
        [8,  12.3, 29.2, 10.6],
        [9,  16.9, 42.9, 14.8],
        [10, 12.8, 30.9, 11.6],
        [11,  5.3,  7.9,  4.7],
        [12,  6.6,  8.4,  5.2],
        [13,  4.8,  6.3,  3.6],
        [14,  4.2,  6.2,  3.4]
      ]);

      var options = {
        chart: {
          title: 'Box Office Earnings in First Two Weeks of Opening',
          subtitle: 'in millions of dollars (USD)'
        },
        width: 900,
        height: 500,
        axes: {
          x: {
            0: {side: 'top'}
          }
        }
      };

      var chart = new google.charts.Line(document.getElementById('line_top_x'));

      chart.draw(data, google.charts.Line.convertOptions(options));
    }
  </script>
</head>
<body>
  <div id="line_top_x"></div>
</body>
</html>


DB
<?php
require_once"konmysqli.php";
$tbrsl="tb_rsl";


$i=0;
 $sql="select distinct(id_site) from `$tbrsl` order by `id_rsl` asc";
 $jum=getJumM($conn,$sql);
  $arr=getDataM($conn,$sql);
$max=0;
foreach($arr as $d) {
$id_site=$d["id_site"];
$arID[$i]=$id_site;
$arNM[$i]="S".getSite($conn,$id_site);

$j=0;
$sqlv="select `out_3` from `$tbrsl`  where `id_site`='$id_site'";
$jumv=getJumM($conn,$sqlv);
$arJUM[$i]=$jumv;
$arrv=getDataM($conn,$sqlv);
foreach($arrv as $dv) {
$ar[$i][$j]=rand(10,100);//$dv["out_3"];
$j++;
}
if($max<$jumv){$max=$jumv;}
$i++;
}

for($j=0;$j<$i;$j++){
$awal=$arJUM[$j];
for($k=$awal;$k<$max;$k++){
$ar[$j][$k]=$ar[$j][$k-1];
}
}


for($j=0;$j<$i;$j++){
for($k=0;$k<$max;$k++){
//echo "$j-$k=".$ar[$j][$k]."<br>";
}
}
?>

 <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">

      google.charts.load('current', {'packages':['line']});
      google.charts.setOnLoadCallback(drawChart);

    function drawChart() {

      var data = new google.visualization.DataTable();
      data.addColumn('number', 'Site');
  <?php
  $gab="";
    for($i=0;$i<$jum;$i++){
?>
data.addColumn("number", "<?php echo $arNM[$i];?>");
<?php
}
  for($i=0;$i<$max;$i++){
  $no=$i+1;
  $gab2="";
  for($j=0;$j<$jum;$j++){
$gab2.=",".$ar[$j][$i]; 
  }
  $gab.="[$no  $gab2],";
  }
$gab=substr($gab,0,strlen($gab)-1);
  ?>
   
   
      data.addRows([<?php echo $gab;?>]);

      var options = {
        chart: {
          title: 'Difficulty Studying and Earnings in Two Weeks of Starting',
          subtitle: 'Level Kesulitan Pembelajaran (Siswa)'
        },
        width: 900,
        height: 500
      };

      var chart = new google.charts.Line(document.getElementById('curve_chart'));

      chart.draw(data, google.charts.Line.convertOptions(options));
    }
   </script>
</head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>




<?php
 echo $gab;
 ?>






















































Senin, 13 Januari 2020

Normalisasi Level III

E-Commerce


tb_admin
id_admin
nama_admin
kategori (Admin, Pemilik)
email
telepon
username
password
status (Aktif, Tidak Aktif)
keterangan


tb_pelanggan
id_pelanggan
nama_pelanggan
email
telepon
alamat
username
password
status (Aktif, Tidak Aktif)
keterangan


tb_barang
id_barang
nama_barang
jenis (Guitar, Accesoris Guitar, DLL)
merek
spesifikasi
deskripsi
gambar
harga
status
keterangan


tb_order
id_order
tanggal
jam
id_pelanggan
status (Order, Konfirmasi, Pengiriman, Selesai,Batal)
keterangan


tb_order_detail
id (AI)
id_order
id_barang
harga
catatan

tb_konfirmasi
id_konfirmasi
tanggal
jam
id_order
nominal
bukti_bayar
nama_bank
alamat_pengiriman_barang
status (Konfirmasi, Valid, Tidak Valid)
keterangan






Minggu, 12 Januari 2020

PHP For Multi Line Multi Marker + Arahan





<!DOCTYPE html>
<html>
  <head>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no">
    <meta charset="utf-8">
    <title>Draggable Directions</title>
    <style>
      #right-panel {
        font-family: 'Roboto','sans-serif';
        line-height: 30px;
        padding-left: 10px;
      }

      #right-panel select, #right-panel input {
        font-size: 15px;
      }

      #right-panel select {
        width: 100%;
      }

      #right-panel i {
        font-size: 12px;
      }
      html, body {
        height: 100%;
        margin: 0;
        padding: 0;
      }
      #map {
        height: 100%;
        float: left;
        width: 63%;
        height: 100%;
      }
      #right-panel {
        float: right;
        width: 34%;
        height: 100%;
      }
      .panel {
        height: 100%;
        overflow: auto;
      }
    </style>
  </head>
  <body>
    <div id="map"></div>
    <div id="right-panel">
      <p>Total Distance: <span id="total"></span></p>
    </div>
    <script>
      function initMap() {
        var map = new google.maps.Map(document.getElementById('map'), {
          zoom: 12,
          center: {lat: -6.353525, lng: 106.831629} 
        });

        var directionsService = new google.maps.DirectionsService;
        var directionsRenderer = new google.maps.DirectionsRenderer({
          draggable: true,
          map: map,
          panel: document.getElementById('right-panel')
        });

        directionsRenderer.addListener('directions_changed', function() {
          computeTotalDistance(directionsRenderer.getDirections());
        });
//ui-6.353525, 106.831629:
//PLN -6.167230, 106.725907
//-6.306477, 106.882463
//-6.246414, 106.874909
//-6.168428, 106.827406

var myLatLng1 = new google.maps.LatLng({lat: -6.353525, lng: 106.831629});
var myLatLng2 = new google.maps.LatLng({lat: -6.167230, lng: 106.725907});

 
        //displayRoute('Perth, WA', 'Sydney, NSW', directionsService,directionsRenderer);
displayRoute(myLatLng1, myLatLng2, directionsService,directionsRenderer);
      }

      function displayRoute(origin, destination, service, display) {
  var myLatLng1 = new google.maps.LatLng({lat: -6.306477, lng: 106.882463});
var myLatLng2 = new google.maps.LatLng({lat: -6.246414, lng: 106.874909});
var myLatLng3 = new google.maps.LatLng({lat: -6.168428, lng: 106.827406});

//waypoints: [{location: 'Adelaide, SA'}, {location: 'Broken Hill, NSW'}],
        service.route({
          origin: origin,
          destination: destination,
          waypoints: [{location: myLatLng1}, {location: myLatLng2}, {location: myLatLng3}],
          travelMode: 'DRIVING',
          avoidTolls: true
        }, function(response, status) {
          if (status === 'OK') {
            display.setDirections(response);
          } else {
            alert('Could not display directions due to: ' + status);
          }
        });
      }

      function computeTotalDistance(result) {
        var total = 0;
        var myroute = result.routes[0];
        for (var i = 0; i < myroute.legs.length; i++) {
          total += myroute.legs[i].distance.value;
        }
        total = total / 1000;
        document.getElementById('total').innerHTML = total + ' km';
      }
    </script>
    <script async defer
    src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&callback=initMap">
    </script>
  </body>
</html>


REF:
https://developers-dot-devsite-v2-prod.appspot.com/maps/documentation/javascript/examples/directions-draggable



https://developers.google.com/maps/documentation/javascript/reference/3.37/coordinates#LatLng

Mencari Tanggal Terakhir Suatu Bulan

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