PHP ILU INU IMU

Minggu, 05 Juli 2020

PHP COde FUZZY SUgeno Penyakit Tanaman

BUAT RULENYA (DINAMIS) yaitu sebagai acuan terhadap penilaian oleh pengguna nantinya:

Ahirnya hari yang melelahkan itu terpuaskan dengan hasil yang Optimal....

Pilih Gejala yang dialami....

Gejala yang diinout akan disandingkan dengan Rule yang ada.....(Bisa diubah2...)

Masuk ke perhitungan fuzzyfikasi berdasarkan rule yang dibuat di atas

Dapat kesimpulannya,,,,,

Adapun library kode yang dipakai adalah sbb:

<?php
if (version_compare(phpversion(), "5.3.0", ">=") == 1)
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
else
error_reporting(E_ALL & ~E_NOTICE);
?>
<?php
session_start();
//error_reporting(0);
require_once"konmysqli.php";
date_default_timezone_set("Asia/Jakarta");

$mnu="";
if(isset($_GET["mnu"])){
$mnu=$_GET["mnu"];
}

$kriteria1="Daun Menguning";
$kriteria2="Daun Tetap Hijau";
$kriteria3="Daun Berwarna Coklat";
$kriteria4="Daun Layu";
$kriteria5="Daun Tegak Keatas";
$kriteria6="Daun Pendek";
$kriteria7="Daun Terkulai Pada Pangkal Batang";
$kriteria8="Daun Terdapat Bintik-bintik Hitam";
$kriteria9="Bonggol Membusuk";
$kriteria10="Bonggol Mengeluarkan Lendir Abu-abu";
$kriteria11="Bonggol Berwarna Merah Kecoklatan";
$kriteria12="Buah Mengeluarkan Lendir Abu-abu";
$kriteria13="Daging Buah Berwarna Merah kecoklatan";
$kriteria14="Akar Membusuk";
$kriteria15="Pertumbuhan Tanaman Pisang";

?>

<!DOCTYPE html>

<html lang="">
<head>
<title>Arif Indiarto Noegroho</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<link href="layout/styles/layout.css" rel="stylesheet" type="text/css" media="all">
</head>
<body id="top">
<div class="wrapper row1">
<header id="header" class="hoc clear">

<div id="logo" class="fl_left">
<h1><a href="index.php?mnu=home">SISTEM IDENTIFIKASI PENYAKIT TANAMAN PISANG</a></h1>
</div>

</header>
</div>
<div class="wrapper row2">
<nav id="mainav" class="hoc clear">

<ul class="clear">
<?php
if($_SESSION["cstatus"]=="Administrator"){
echo"
<li ";if($mnu=="home"){echo"class='active'";} echo"><a href='index.php?mnu=home'>Home</a></li>
<li ";if($mnu=="admin"){echo"class='active'";} echo"><a href='index.php?mnu=admin'>Admin</a></li>

<li ";if($mnu=="rule"){echo"class='active'";} echo"><a href='index.php?mnu=rule'>Rule/Aturan</a></li>

<li ";if($mnu=="pengguna"){echo"class='active'";} echo"><a href='index.php?mnu=pengguna'>Pengguna</a></li>

<li ";if($mnu=="pengujian"){echo"class='active'";} echo"><a href='index.php?mnu=pengujian'>Pengujian</a></li>

<li ";if($mnu=="analisa"){echo"class='active'";} echo"><a href='index.php?mnu=analisa'>Analisa</a></li>

<li ";if($mnu=="hasilanalisa"){echo"class='active'";} echo"><a href='index.php?mnu=hasilanalisa'>Hasil</a></li>
<li><a href='index.php?mnu=logout'>Logout</a></li>";
}
else if($_SESSION["cstatus"]=="Pengguna"){
echo"
<li ";if($mnu=="home"){echo"class='active'";} echo"><a href='index.php?mnu=home'>Home</a></li>
<li ";if($mnu=="profil_pengguna"){echo"class='active'";} echo"><a href='index.php?mnu=profil_pengguna'>Profil Pengguna</a></li>

<li ";if($mnu=="prule"){echo"class='active'";} echo"><a href='index.php?mnu=prule'>Rule/Aturan</a></li>

<li ";if($mnu=="ppengujian"){echo"class='active'";} echo"><a href='index.php?mnu=ppengujian'>Pengujian</a></li>

<li ";if($mnu=="analisa"){echo"class='active'";} echo"><a href='index.php?mnu=analisa'>Analisa</a></li>

<li ";if($mnu=="hasil"){echo"class='active'";} echo"><a href='index.php?mnu=hasil'>Hasil</a></li>
<li><a href='index.php?mnu=logout'>Logout</a></li>";
}

else{
echo"<li ";if($mnu=="home"){echo"class='active'";} echo"><a href='index.php?mnu=home'>Home</a></li>";
echo"<li ";if($mnu=="daftar"){echo"class='active'";} echo"><a href='index.php?mnu=daftar'>Pendaftaran</a></li>";
echo"<li><a href='login.php'>Login</a></li>";
}
?>
</ul>

</nav>
</div><?php if($mnu=="home" || $mnu==""){?>



<div class="wrapper bgded overlay" style="background-image:url('images/homepisang.jpg');">
<article id="pageintro" class="hoc clear">

<h3 class="heading">PISANG</h3>
<p><h4>Pisang Merupakan nama umum yang diberikan pada tumbuhan terna raksasa berdaun besar memanjang dari suku Musaceae. Pisang menghasilkan buah konsumsi yang dinamakan sama. Buah ini tersusun dalam tandan dengan kelompok-kelompok tersusun menjari yang disebut sisir. Hampir semua buah pisang memiliki kulit berwarna kuning ketika matang, meskipun ada beberapa yang berwarna jingga, merah, hijau, ungu, atau bahkan hitam. </h4></p>

</article>
</div><?php } ?>



<div class="wrapper row3">
<main class="hoc container clear">


<?php

if($mnu=="admin"){require_once"admin/admin.php";}
else if($mnu=="daftar"){require_once"pengguna/daftar.php";}
else if($mnu=="pengguna"){require_once"pengguna/pengguna.php";}
else if($mnu=="profil_pengguna"){require_once"pengguna/profil_pengguna.php";}
else if($mnu=="profil_pengguna2"){require_once"pengguna/profil_pengguna2.php";}
else if($mnu=="pengujian"){require_once"pengujian/pengujian.php";}
else if($mnu=="ppengujian"){require_once"pengujian/ppengujian.php";}
else if($mnu=="login"){require_once"login.php";}
else if($mnu=="logout"){require_once"logout.php";}
else if($mnu=="rule"){require_once"rule/rule.php";}
else if($mnu=="prule"){require_once"rule/prule.php";}

else if($mnu=="analisa"||$mnu="fuzzy"){require_once"fuzzy.php";}
else if($mnu=="hasilanalisa"){require_once"hasil/hasilanalisa.php";}
else if($mnu=="hasil"){require_once"hasil/hasil.php";}

else {require_once"home.php";}

?>



<div class="clear"></div>
</main>
</div>












<div class="wrapper row5">
<div id="copyright" class="hoc clear">

<p class="fl_left">Copyright © 2020<a href="#"> arifindiartonoegroho.com</a></p>
<p class="fl_right">Website by <a target="_blank" href="http://www.os-templates.com/" title="Free Website Templates">Arif Indiarto Noegroho</a></p>

</div>
</div>



<a id="backtotop" href="#top"><i class="fa fa-chevron-up"></i></a>
 <?php if($mnu=="home" || $mnu==""){?>
<script src="layout/scripts/jquery.min.js"></script><?php } ?>
<script src="layout/scripts/jquery.backtotop.js"></script>
<script src="layout/scripts/jquery.mobilemenu.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

</body>
</html>

<?php function RP($rupiah){return number_format($rupiah,"2",",",".");}?>
<?php
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;
}
?>
<?php
function WKTP($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,2,2);

$judul_bln=array(1=> "Jan", "Feb", "Mar", "Apr", "Mei","Jun", "Jul", "Agu", "Sep","Okt", "Nov", "Des");
$wk=$tanggal." ".$judul_bln[(int)$bulan]."'".$tahun;
return $wk;
}
?>
<?php
function BAL($tanggal){
$arr=explode(" ",$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"){$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"){$bul="09";}
else if($arr[1]=="Oktober"||$arr[1]=="October"){$bul="10";}
else if($arr[1]=="November"){$bul="11";}
else if($arr[1]=="Nopember"){$bul="11";}
else if($arr[1]=="Desember"||$arr[1]=="December"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>

<?php
function BALP($tanggal){
$arr=explode(" ",$tanggal);
if($arr[1]=="Jan"){$bul="01";}
else if($arr[1]=="Feb"){$bul="02";}
else if($arr[1]=="Mar"){$bul="03";}
else if($arr[1]=="Apr"){$bul="04";}
else if($arr[1]=="Mei"){$bul="05";}
else if($arr[1]=="Jun"){$bul="06";}
else if($arr[1]=="Jul"){$bul="07";}
else if($arr[1]=="Agu"){$bul="08";}
else if($arr[1]=="Sep"){$bul="09";}
else if($arr[1]=="Okt"){$bul="10";}
else if($arr[1]=="Nov"){$bul="11";}
else if($arr[1]=="Nop"){$bul="11";}
else if($arr[1]=="Des"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>

<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

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

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

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;
}

function getAdmin($conn,$kode){
$field="username";
$sql="SELECT `$field` FROM `tb_admin` where `kode_admin`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $row[$field];
}
function getPengguna($conn,$kode){
$field="nama_pengguna";
$sql="SELECT `$field` FROM `tb_pengguna` where `id_pengguna`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $row[$field];
}

function getOut($v){
$hasil="Penyakit Tanaman Pisang";
if($v==0){$hasil="Penyakit Tanaman Pisang ?";}
else if($v<=2){$hasil="Penyakit Layu Fusarium";}
else if($v<=4){$hasil="Penyakit Layu Bakteri";}
else if($v<=5){$hasil="Penyakit Darah";}
else if($v<=7){$hasil="Bercak Daun Sigatoka";}
else if($v<=9){$hasil="Penyakit Kerdil Pisang";}
return $hasil;
}
/*
( Z – 0,1 ) / ( 2 - 0,1 ) = 0,5
Z – 0,1 = 0,5 × 1,9
Z = 0,95 + 0,1
Z1 = 1,05
( Z – 0,1 ) / ( 2 - 0,1 ) = 0,5
Z=(OUT/(MIN-MAX))+MIN;

a. Penyakit Layu Fusarium [ 0,1 - 2 ]
b. Penyakit Layu Bakteri [ 2,1 - 4 ]
c. Penyakit Darah [ 4,1 - 6 ]
d. Bercak Daun Sigatoka [ 6,1 - 7 ]
e. Penyakit Kerdil Pisang [ 7,1 - 9 ]

*/

function getZ($kat,$out){
if($kat=="Penyakit Layu Fusarium"){$min=0.1;$max=2; }
else if($kat=="Penyakit Layu Bakteri"){$min=2.1;$max=4; }
else if($kat=="Penyakit Darah"){$min=4.1;$max=6; }
else if($kat=="Bercak Daun Sigatoka"){$min=6.1;$max=7; }
else if($kat=="Penyakit Kerdil Pisang"){$min=7.1;$max=9; }

$z=($out*($max-$min))+$min;
$H="
( Z – MIN ) / ( MAX - MIN ) = OUT |
( Z – $min ) / ( $max - $min ) = $out<br>
Z=(OUT*(MAX-MIN))+MIN = ($out*($max-$min))+$min=$z";
$ar[0]=$z;
$ar[1]=$H;
return $ar;
}
/*
1. Daun tetap hijau [ Sedikit Sedang Banyak ] [ 0-3 1-5 3-7 ]
2. Daun menguning [ Sedikit Sedang Banyak ] [ 0-3 1-5 3-7 ]
3. Daun berwarna coklat [ Sedikit Sedang Banyak ] [ 0-3 1-5 3-7 ]
4. Daun layu [ Tidak Sebagian Semua ] [ 1-5 2-7 5-8 ]

5. Daun tegak keatas [ Tidak Sebagian Semua ] [ 1-3 2-5 3-8 ]
6. Daun pendek [ Tidak Sebagian Semua ] [ 1-6 3-7 6-9 ]
7. Daun terkulai pada pangkal batang [ Tidak Sedikit Banyak ] [ 0-4 2-5 4-7 ]

8. Daun terdapat bintik-bintik hitam [ Sedikit Sedang Banyak ] [ 0-5 3-7 5-8 ]
9. Bonggol membusuk [ Tidak Sebagian Semua ] [ 0-4 2-6 4-8 ]

10. Bonggol mengeluarkan lendir abu-abu [ Tidak Sedikit Banyak ] [ 0-3 1-4 3-7 ]
11. Bonggol berwarna merah kecoklatan [ Tidak Sedikit Banyak ] [ 0-3 2-4 3-6 ]

12. Buah mengeluarkan lendir abu-abu [ Sedikit Sedang Banyak ] [ 0-2 1-4 2-6 ]
13. Daging buah berwarna merah kecoklatan [ Sedikit Sedang Banyak ] [ 0-3 1-4 3-6 ]

14. Akar membusuk [ Tidak Sebagian Semua ] [ 0-4 2-5 4-7 ]
15. Pertumbuhan tanaman pisang [ Lambat Sedang Cepat ] [ 1-5 3-6 5-8 ]
*/

function getG15($kat,$value){
$arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Lambat"){$min=1;$max=5;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=3;$max=6;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Cepat"){$min=5;$max=8;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Pertumbuhan Tanaman Pisang Kerdil";
$ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG14($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=0;$max=4;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sebagian"){$min=2;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Semua"){$min=4;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Akar membusuk"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG13($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=1;$max=4;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=2;$max=6;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daging buah berwarna merah kecoklatan"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG12($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=2;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=1;$max=4;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=2;$max=6;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Buah mengeluarkan lendir abu-abu"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG11($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedikit"){$min=2;$max=4;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=3;$max=6;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Bonggol berwarna merah kecoklatan"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG10($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedikit"){$min=1;$max=4;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=3;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Bonggol mengeluarkan lendir abu-abu"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG9($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=0;$max=4;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sebagian"){$min=2;$max=6;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Semua"){$min=4;$max=8;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Bonggol membusuk"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG8($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=5;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=3;$max=7;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=5;$max=8;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun terdapat bintik-bintik hitam"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG7($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=0;$max=4;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedikit"){$min=2;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=4;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun terkulai pada pangkal batang"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG6($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=1;$max=6;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sebagian"){$min=3;$max=7;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Semua"){$min=6;$max=9;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun pendek"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG5($kat,$value){ $arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=1;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sebagian"){$min=2;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Semua"){$min=3;$max=8;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun Tegak KeAtas"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG4($kat,$value){
$arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Tidak"){$min=1;$max=5;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sebagian"){$min=2;$max=7;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Semua"){$min=5;$max=8;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun Layu"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG3($kat,$value){
$arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=1;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=3;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun berwarna coklat"; $ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}
function getG2($kat,$value){
$arV=array();
$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=1;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=3;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun Menguning";
$ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getG1($kat,$value){
$arV=array();$ar=array();
$min=0;
$max=0;
if($kat=="Sedikit"){$min=0;$max=3;$arV=getF1($min,$max,$kat,$value);}
else if($kat=="Sedang"){$min=1;$max=5;$arV=getF2($min,$max,$kat,$value);}
else if($kat=="Banyak"){$min=3;$max=7;$arV=getF3($min,$max,$kat,$value);}
$ar[0]=$min;
$ar[1]=$max;
$ar[2]=$kat;
$ar[3]="Daun tetap Hijau";
$ar[4]=$arV[0];
$ar[5]=$arV[1];
return $ar;
}

function getF1($min,$max,$kat,$value){
$ar=array();
$x=$value;//$min+($max-$min)/2;
$out=0;
$sout="";
if($x<=$min){$out=1;$sout="I$kat.Karena $x<=min $min |out=$out";}
else if($x>=$max){$out=0;$sout="III$kat. Karena $x>= max $max |out=$out";}
else {$out=($max-$x)/($max-$min);$sout="II$kat. Karena min $min < $x < max $max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}

function getF2($min,$max,$kat,$value){
$ar=array();
$x=$value;//$min+($max-$min)/2;
$sel=($max-$min)/2;
$mid=$min+$sel;
$out=0;
$sout="";
if($x<=$min || $x>=$max){$out=0;$sout="I$kat.Karena $x<= min $min Atau $x>= max $max |out=$out";}
else if($x>$min && $x<$mid){$out=($x-$min)/($mid-$min);$sout="II$kat.Karena $x > min $min Dan $x < $mid (Nilai Tengah) |out=$out";}
else {$out=($max-$x)/($mid-$min);$sout="III$kat.Karena min $min< $x < max $max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}
function getF3($min,$max,$kat,$value){
$ar=array();
$x=$value;//$min+($max-$min)/2;
$out=0;
if($x<=$min){$out=0;$sout="I$kat.Karena $x<= min $min |out=$out";}
else if($x>=$max){$out=1;$sout="III$kat.Karena $x>= max $max |out=$out";}
else {$out=($x-$min)/($max-$min);$sout="II$kat.Karena min $min< $x <= max $max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}

function getV1($min,$max,$x,$kat){
$avg=($max-$min)/2;
$out=0;
$sout="";
if($x<=$min){$out=1;$sout="I$kat.Karena $x<=$min |out=$out";}
else if($x>=$max){$out=0;$sout="III$kat. Karena $x>=$max |out=$out";}
else {$out=($max-$x)/($max-$min);$sout="II$kat. Karena $min < $x < $max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}

function getV2($min,$max,$x,$kat){
$sel=($max-$min)/2;
$mid=$min+$sel;
$out=0;
$sout="";
if($x<=$min || $x>=$max){$out=0;$sout="I$kat.Karena $x<=$min Atau $x>=$max |out=$out";}
else if($x>$min && $x<$mid){$out=($x-$min)/($mid-$min);$sout="II$kat.Karena $x>$min Dan $x<$mid (Nilai Tengah) |out=$out";}
else {$out=($max-$x)/($mid-$min);$sout="III$kat.Karena $min<$x<$max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}
function getV3($min,$max,$x,$kat){
$avg=($max-$min)/2;
$out=0;
if($x<=$min){$out=0;$sout="I$kat.Karena $x<=$min |out=$out";}
else if($x>=$max){$out=1;$sout="III$kat.Karena $x>=$max |out=$out";}
else {$out=($x-$min)/($max-$min);$sout="II$kat.Karena $min<$x<=$max |out=$out";}
$ar[0]= $out;
$ar[1]= $sout;
return $ar;
}
?>

Jumat, 03 Juli 2020

Layout Cari PHP

<?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>

<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>

<script type="text/javascript">

function PRINT(tgl){
win=window.open('pemasukanbarang/print.php?tgl='+tgl,'win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=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>

<?php
$pilih="bt";
$wkt=WKT(date("Y-m-d"));
$item=$ar[1]." ".$ar[0];

if(isset($_POST["Cari"])){
$pilih=$_POST["pilih"];
$item=$_POST["item"];
}
?>
<div id="accordion">
<h3>Laporan Data Kegiatan</h3>
<div>

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

<tr>
<th><label for="id_keluar">Pencarian Berdasarkan:</label>
<th>
<select name="pilih" class="form-control" >
<option value="bt" <?php if($pilih=="bt"){echo"selected";}?>>Bulan Tahun</option>
<option value="id_kegiatan" <?php if($pilih=="id_kegiatan"){echo"selected";}?>>ID Kegiatan</option>
<option value="tgl" <?php if($pilih=="tgl"){echo"selected";}?>>Tanggal</option>
<option value="nama_pj" <?php if($pilih=="nama_pj"){echo"selected";}?>>Nama PJ</option>
<option value="jabatan_pj" <?php if($pilih=="jabatan_pj"){echo"selected";}?>>Jabatan PJ</option>
<option value="objek_kerja" <?php if($pilih=="objek_kerja"){echo"selected";}?>>Objek Kerja</option>
<option value="jenis_kerusakan" <?php if($pilih=="jenis_kerusakan"){echo"selected";}?>>Jenis Kerusakan</option>
<option value="lokasi" <?php if($pilih=="lokasi"){echo"selected";}?>>Lokasi</option>
<option value="ukuran" <?php if($pilih=="ukuran"){echo"selected";}?>>Ukuran</option>

<option value="status" <?php if($pilih=="status"){echo"selected";}?>>Status</option>

</select>
<th>Item Dicari
<th>
<input name="item" class="form-control" type="text" id="item" value="<?php echo $item;?>" size="15" />
<th >
<input name="Cari" type="submit" class="btn btn-success" id="Cari" value="Cari" />
<a href="?mnu=cari"><input name="Batal" class="btn btn-danger" type="button" id="Batal" value="Batal" /></a>
</th></tr>
</table>
</form>
<hr>

Data Pencarian :

<table class="table table-bordered table-striped table-hover">
<tr bgcolor="#CCCCCC">
<th width="3%">No</th>
<th width="90%">List Kegiatan/Pelaporan</th>
</tr>
<?php

$bulan=date("m");
$tahun=date("Y");
$awal="$tahun-$bulan-01";
$ahir="$tahun-$bulan-31";
$sql="select * from `$tbkegiatan` order by `id_kegiatan` desc ";
if(isset($_POST["Cari"])){
$pilih=trim($_POST["pilih"]);
$item=trim($_POST["item"]);

if($pilih=="bt"){
$ar=explode(" ",$item);
$bln=strtolower($ar[0]);
$bulan=1;
if($bln=="januari"|| $bln=="jan"){$bulan=1;}
else if($bln=="februari"|| $bln=="feb"){$bulan=2;}
else if($bln=="maret"|| $bln=="mar"){$bulan=3;}
else if($bln=="april"|| $bln=="apr"){$bulan=4;}
else if($bln=="mei"|| $bln=="mei"){$bulan=5;}
else if($bln=="juni"|| $bln=="jun"){$bulan=6;}
else if($bln=="juli"|| $bln=="jul"){$bulan=7;}
else if($bln=="agustus"|| $bln=="agu"){$bulan=8;}
else if($bln=="september"|| $bln=="sep"){$bulan=9;}
else if($bln=="oktober"|| $bln=="okt"){$bulan=10;}
else if($bln=="november"|| $bln=="nov"){$bulan=11;}
else if($bln=="desember"|| $bln=="des"){$bulan=12;}

$tahun=$ar[1];
$awal="$tahun-$bulan-01";
$ahir="$tahun-$bulan-31";
$sql="select * from `$tbkegiatan` where `tgl` between '$awal' and '$ahir' order by `id_kegiatan` desc ";
}
else
$sql="select * from `$tbkegiatan`where `$pilih` like '%$item%'";
}

$jum=getJum($conn,$sql);
if($jum > 0){
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_kegiatan=$d["id_kegiatan"];
$id_kegiatan0=$d["id_kegiatan"];
$nama_pj=$d["nama_pj"];
$alamat_pj=$d["alamat_pj"];
$jabatan_pj=$d["jabatan_pj"];
$hari=$d["hari"];
$id_petugas=$d["id_petugas"];
$objek_kerja=$d["objek_kerja"];
$lokasi=$d["lokasi"];
$jenis_kerusakan=$d["jenis_kerusakan"];
$ukuran=$d["ukuran"];
$status=$d["status"];
$keterangan=$d["keterangan"];
$tgl=WKT($d["tgl"]);
$gab="<ol>";

$sqlg="select * from `$tblaporan` where `id_kegiatan`='$id_kegiatan'";
$arrg=getData($conn,$sqlg);
foreach($arrg as $dg) {
$id_laporan=$dg["id_laporan"];
$tgl2=WKT($dg["tgl"]);
$jam=$dg["jam"];
$kondisi_lapangan=$dg["kondisi_lapangan"];
$penanganan=$dg["penanganan"];
$keterangan2=$dg["keterangan"];
$gab.="<li>$penanganan Kondisi Lapangan : $kondisi_lapangan $tgl2 $jam wib</li>";
}
$gab.="</ol>";

$color="#dddddd";
if($no %2==0){$color="#eeeeee";}
echo"<tr bgcolor='$color'>
<td>$no</td>
<td>
<b>$objek_kerja: $jenis_kerusakan #Ukuran $ukuran, Lokasi $lokasi</b>
<br><i>Alamat $alamat_pj Pengerjaan $hari - $tgl <br>PJ: $nama_pj ($jabatan_pj) </i>
<br>Catatan : $keterangan, Petugas: $id_petugas Status $status

<i>$gab<i></td>
</tr>";

$no++;
}//while
}//if
else{echo"<tr><td colspan='7'><blink>Maaf, Data pengeluaran barang belum tersedia...</blink></td></tr>";}
?>
</table>

</div>
</div>

Grafik Group Laporan Bulanan

**$timeStart = strtotime($tanggal1);$timeEnd = strtotime($tanggal2);$sel = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))*12;**

//echo "$tanggal1 $tanggal2=$sel<hr>";

$tahun=$thn1;
$bulan=$bln1;
for($i=0;$i<$sel;$i++){
$bulan=$bulan+0;
if($bulan>12){$tahun=$tahun+1;$bulan=1;}
if($bulan<10){$bulan="0".$bulan;}

$bln="Januari";
if($bulan==1){$bln="Januari";}
else if($bulan==2){$bln="Februari";}
else if($bulan==3){$bln="Maret";}
else if($bulan==4){$bln="April";}
else if($bulan==5){$bln="Mei";}
else if($bulan==6){$bln="Juni";}
else if($bulan==7){$bln="Juli";}
else if($bulan==8){$bln="Agustus";}
else if($bulan==9){$bln="September";}
else if($bulan==10){$bln="Oktober";}
else if($bulan==11){$bln="November";}
else if($bulan==12){$bln="Desember";}

$ARR1[$i]="$tahun-$bulan-01";
$ARR2[$i]="$tahun-$bulan-31";
$ARR3[$i]="$bln $tahun";

echo $i."#".$ARR1[$i]." - ".$ARR2[$i]."<br>";
$bulan=$bulan+1;

}
$sql="select * from `$tbbarang` order by `id_barang` asc";
$jum=getJum($conn,$sql);
if($jum <1){
echo"Maaf Data Belum Tersedia....";
}
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_barang=$d["id_barang"];
$nama_barang=$d["nama_barang"];
$deskripsi=$d["deskripsi"];
$gambar=$d["gambar"];
$gambar0=$d["gambar"];
$status=$d["status"];
$keteranganbrg=$d["keterangan"];
$color="#F8F8FF";

echo"<h3>$no. Data Barang $nama_barang |$id_barang</h3><div>";
echo"<b>$nama_barang</b>";
echo"<table width='100%'>";
echo"<tr><td width='30%' valign='top'>
<div align='center'>";
echo"<a href='#' onclick='buka(\"barang/zoom.php?id=$id_barang\")'>
<img src='$YPATH/$gambar' width='120' height='120' title='date ke $no'/></a>
<br>
ID Barang: $id_barang<br>
Kategori: $keteranganbrg<br>
</div>";
$nom=0;
$mydata="";
$tab="<table width='60%' border='1'><tr bgcolor='#cccccc'><th>No<th>Periode<th>Jumlah</tr>";
for($i=0;$i<$sel;$i++){
$w1=$ARR1[$i];
$w2=$ARR2[$i];
$w3=$ARR3[$i];

$nom=$i+1;
$sql="select sum(`$tbpengeluarandetail`.`jumlah`) as `total`
from `$tbpengeluarandetail`,`$tbpengeluaranbarang` where
`$tbpengeluarandetail`.`id_barang`='$id_barang' and
`$tbpengeluarandetail`.`id_pengeluaran`=`$tbpengeluaranbarang`.`id_pengeluaran` and
`$tbpengeluaranbarang`.`tanggal` between '$w1' and '$w2'
";
$d=getField($conn,$sql);
$in=$d["total"]+0;
$mydata.="[$nom,$in],";
$tab.="<tr><td>$nom<td>$w3<td>$in</tr>";
}
$tab.="</table>";

$mydata=substr($mydata,0,strlen($mydata)-1);
echo"<td valign='top'>";

?>

<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', 'Periode');
data.addColumn('number', 'Pengeluaran Barang');

data.addRows([<?php echo $mydata;?>]);

var options = {
chart: {
title: 'Grafik Pengeluaran Barang',
subtitle: 'TOKO PAKAIAN XYZ JAKARTA'
},
width: 400,
height: 300
};

var chart = new google.charts.Line(document.getElementById("curve_chart"+index));
chart.draw(data, google.charts.Line.convertOptions(options));
index=index+1;
}

</script>
<div id="curve_chart<?php echo $no;?>" style="width: 400px; height: 300px"></div>
<?php
echo $tab;
echo "</td></tr>";
echo"</table><br>";
echo"</div>";
$no++;
}//foreach
?>
</div>

Senin, 29 Juni 2020

Library COde 2020

<?php
$sql="select `id_pedagang` from `$tbpedagang` order by `id_pedagang` 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="PDG".$th.$bl;//KEG1610001
if($jum > 0){
$d=mysqli_fetch_array($q);
$idmax=$d["id_pedagang"];

$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";}
$id_pedagang=$idmax;

?>

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

<tr>
<td><label for="nama_user">Nama User</label>
<td>:
<td colspan="2"><input required placeholder="Nama User" title="Nama User" name="nama_user" class="form-control" type="text" id="nama_user" value="<?php echo $nama_user;?>" size="30" /></td>
</tr>

<tr>
<td height="24"><label for="telepon">Telepon</label>
<td>:<td colspan="2"><input required name="telepon" class="form-control" type="number" id="telepon" value="<?php echo $telepon;?>" size="15" />
</td>
</tr>

<tr>
<td height="24"><label for="email">Email</label>
<td>:
<td><input name="email" type="email" class="form-control" id="email" value="<?php echo $email;?>" size="30" />
</td>
</tr>

<script type="text/javascript">
function PRINT(pk){
win=window.open('customer/print.php?pk='+pk,'win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, username=0'); }
</script>

INI CALLER NYA:
| <img src='ypathicon/print.png' alt='PRINT' OnClick="PRINT('<?php echo $status;?>')"> |

INI CODE PRINTNYA:
<style type="text/css">body {width: 100%;} </style>
<body OnLoad="window.print()" OnFocus="window.close()">
<?php
include "../konmysqli.php";
echo"<link href='../ypathcss/$css' rel='stylesheet' type='text/css' />";
$YPATH="../ypathfile";

$pk="";
$field="id_customer";
$TB="$tbcustomer";
$item="Customer";

$sql="select * from `$TB` order by `$field` asc";
if(isset($_GET["pk"])){
$pk=$_GET["pk"];
$sql="select * from `$TB` where `$field` ='$pk' order by `$field` asc";
}
?>

<h3><center>Laporan Data <?php echo $item;?> <?php echo $pk;?></h3>

<table width="98%" border="0">
<tr>
<th width="2%">No</td>
<th width="50%">Nama Customer</td>
<th width="10%">Status</td>
<th width="40%">Keterangan</td>
</tr>
<?php

$jum=getJum($conn,$sql);
$no=0;
if($jum > 0){
$arr=getData($conn,$sql);
foreach($arr as $d) {
$no++;
$id_customer=$d["id_customer"];
$nama_customer=$d["nama_customer"];
$alamat=$d["alamat"];
$telepon=$d["telepon"];
$email=$d["email"];
$username=$d["username"]
;$password=$d["password"];
$status=$d["status"];
$keterangan=$d["keterangan"];
$color="#cccccc";
if($no %2==1){$color="#dddddd";}

echo"<tr bgcolor='$color'>
<td>$no</td>
<td><b><a href='mailto:$email'>$nama_customer</b> ($id_customer)</a></br>
Alamat : <i>$alamat $telepon</i></td>
<td>$status</td>
<td>$keterangan</td>
</tr>";

}//while
}//if
else{echo"<tr><td colspan='7'><blink>Maaf, Data $item Belum Tersedia...</blink></td></tr>";}
?>

</table>

<a href="excel.php?tabel=tb_admin&pk=id_admin">EXCEL</a>

<?php
date_default_timezone_set("Asia/Jakarta");

require_once"koneksivar.php";

$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
if ($conn->connect_error) {
trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR);
}

$NT="tb_admin";
$PK="id_admin";
if(isset($_GET["tabel"])){
$NT=$_GET["tabel"];
$PK=$_GET["pk"];
}

?>
<!DOCTYPE html>
<html>
<head>
<title>Export Data Kuisioner - <?php echo $NT;?></title>
</head>
<body>
<style type="text/css">
body{
font-family: sans-serif;
}
table{
margin: 20px auto;
border-collapse: collapse;
}
table th,
table td{
border: 1px solid #3c3c3c;
padding: 3px 8px;

}
a{
background: blue;
color: #fff;
padding: 8px 10px;
text-decoration: none;
border-radius: 2px;
}
</style>

<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=$NT.xls");
?>

<center>
<h1> <?php echo strtoupper("Data Kuisioner Tracert Study ".$NT);?><br/>
https://www.upnvj.ac.id/id.html</h1>
</center>
<?php

$sql="select * from `".$NT."`";
$result = mysqli_query($conn,$sql);
$jc=mysqli_num_fields($result);

$gab="<table border='1'><tr><th>No</th>";
for($i=1;$i<$jc;$i++){
$colObj = mysqli_fetch_field_direct($result,$i);
$col= $colObj->name;
$ar[$i-1]=$col;
$gab.="<th>$col</th>";
}
$gab.="</tr>";

$sql="select * from `".$NT."` order by `".$PK."` asc";
$jum=getJum($conn,$sql);
if($jum > 0){
$arr=getData($conn,$sql);
$no=1;
foreach($arr as $d) {
$gab.="<tr><td>$no</td>";
for($i=1;$i<$jc;$i++){
$v=$ar[$i-1];
$data=$d["$v"];
$gab.="<td>$data</td>";
}//for
$gab.="</tr>";
$no++;
}//foreach
}//jum
else{
$gab.="<tr colspan='$jc'>data belum tersedia</tr>";
}
$gab.="</table>";

echo $gab;
?>

</body>
</html>

<?php
$tanggal=date("Y-m-d");
$LAT1=-6.306187;
$LON1=106.873144;
$uri = $_SERVER['REQUEST_URI'];
//echo $uri; // Outputs: URI
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
// echo"<hr>";
$url = $protocol . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
//echo $url; // Outputs: Full URL
//echo"<hr>";
$query = $_SERVER['QUERY_STRING'];
//echo $query; // Outputs: Query String
//echo"<hr>";
$cari="index.php?".$query;
$PATH=str_replace($cari,"",$url);
//echo $PATH;
?>
<link rel="stylesheet" href="https://unpkg.com/leaflet@1.6.0/dist/leaflet.css" integrity="sha512-xwE/Az9zrjBIphAcBb3F6JVqxf46+CDLwfLMHloNu6KEQCAWi6HcDUbeOfBIptF7tcCzusKFjFw2yuvEpDL9wQ==" crossorigin=""/>
<script src="https://unpkg.com/leaflet@1.6.0/dist/leaflet.js" integrity="sha512-gZwIG9x3wUXg2hdXF6+rVkLF/0Vi9U8D2Ntg4Ga5I5BZpVkVxlJWbSQtXPSiUTtC0TjtGOmxa1AJPuV0CPthew==" crossorigin=""></script>

<div id="mapid" style="width: 100%; height: 600px;"></div>
<script>
//-6.356602, 106.831307
//http://localhost/webtracking_pedagang/dir/direction/?lat1=5.022020&lon1=96.095108&lat2=5.121929&lon2=96.253036

var mymap = L.map('mapid').setView([<?php echo $LAT1;?>, <?php echo $LON1;?>], 13);
//andree:pk.eyJ1IjoiYW5kcmUzMjE3OTgiLCJhIjoiY2tia3VmcnczMTJzZzJubHRqdWk1aHozbyJ9.br1i2UWx5I-4AZGuUUoqxw
//default:pk.eyJ1IjoibWFwYm94IiwiYSI6ImNpejY4NXVycTA2emYycXBndHRqcmZ3N3gifQ.rJcFIG214AriISLbB6B5aw
L.tileLayer('https://api.mapbox.com/styles/v1/{id}/tiles/{z}/{x}/{y}?access_token=pk.eyJ1IjoiYW5kcmUzMjE3OTgiLCJhIjoiY2tia3VmcnczMTJzZzJubHRqdWk1aHozbyJ9.br1i2UWx5I-4AZGuUUoqxw', {
maxZoom: 18,
attribution: 'Map data © <a href="https://www.openstreetmap.org/">OpenStreetMap</a> contributors, ' +
'<a href="https://creativecommons.org/licenses/by-sa/2.0/">CC-BY-SA</a>, ' +
'Imagery © <a href="https://www.mapbox.com/">Mapbox</a>',
id: 'mapbox/streets-v11',
tileSize: 512,
zoomOffset: -1
}).addTo(mymap);

//
L.marker([<?php echo $LAT1;?>, <?php echo $LON1;?>]).addTo(mymap).bindPopup("<b>Hello UHAMKA!</b><br />Saya Ada di UHAMKA.").openPopup();

//var myIcon = L.divIcon({className: 'Emoji sunglasses'});
// you can set .my-div-icon styles in CSS
//L.marker([-6.306187, 106.873144], {icon: myIcon}).addTo(map);

L.circle([<?php echo $LAT1;?>, <?php echo $LON1;?>], 1000, {
color: 'yellow',
fillColor: '#fafa03',
fillOpacity: 0.5
}).addTo(mymap).bindPopup("Ini WIlayah Radius UHAMKA");

<?php
$sql="select * from `$tbtracking` where `tanggal`<='$tanggal' group by `id_pedagang` order by id_tracking desc";
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_tracking=$d["id_tracking"];
$jam=$d["jam"];
$latitude=$d["latitude"];
$longitude=$d["longitude"];
$id_pedagang=$d["id_pedagang"];

$LINK=$PATH."dir/direction/?lat1=$LAT1&lon1=$LON1&lat2=$latitude&lon2=$longitude";
//$LINK="?mnu=dir&lat1=$LAT1&lon1=$LON1&lat2=$latitude&lon2=$longitude";

$sql2="select `nama_pedagang`,`telepon` from `$tbpedagang` where `id_pedagang`='$id_pedagang'";
$d2=getField($conn,$sql2);
$nama_pedagang=$d2["nama_pedagang"];
$telepon=$d2["telepon"];
$gab="";
$sql3="select `id_produk`,`nama_produk` from `$tbproduk` where `id_pedagang`='$id_pedagang' and `status`='Tersedia'";
$jum3=getJum($conn,$sql3);
if($jum3 > 0){
$arr3=getData($conn,$sql3);
foreach($arr3 as $d3) {
$id_produk=$d3["id_produk"];
$nama_produk=$d3["nama_produk"];
$gab.="$nama_produk, ";
}//foreach
$gab=substr($gab,0,strlen($gab)-2);
}//jum3
else{
$gab="Tidak Ada Produk di jual...";
}
$info="$nama_pedagang ($telepon)";
$jual="Produk: $gab <a href='$LINK'>direction</a>";

?>

L.marker([<?php echo $latitude;?>, <?php echo $longitude;?>]).addTo(mymap).bindPopup("<b><?php echo $info;?></b><br /><?php echo $jual;?>");//.openPopup();

<?php
}//while
?>

var popup = L.popup();

function onMapClick(e) {
popup
.setLatLng(e.latlng)
.setContent("You clicked the map at " + e.latlng.toString())
.openOn(mymap);
}

mymap.on('click', onMapClick);

</script>

</body>
</html>

<!DOCTYPE html>
<html>
<body>

<div id="player"></div>

<script>
// 2. This code loads the IFrame Player API code asynchronously.
var tag = document.createElement('script');
tag.src = "https://www.youtube.com/AIzaSyAKM239U9OdNjTeEExilchlN7gJQf_-IhU";
var firstScriptTag = document.getElementsByTagName('script')[0];
firstScriptTag.parentNode.insertBefore(tag, firstScriptTag);

// 3. This function creates an <iframe> (and YouTube player)
// after the API code downloads.
var player;
function onYouTubeIframeAPIReady() {
player = new YT.Player('player', {
height: '390',
width: '640',
videoId: 'M7lc1UVf-VE',
events: {
'onReady': onPlayerReady,
'onStateChange': onPlayerStateChange
}
});
}

// 4. The API will call this function when the video player is ready.
function onPlayerReady(event) {
event.target.playVideo();
}

// 5. The API calls this function when the player's state changes.
// The function indicates that when playing a video (state=1),
// the player should play for six seconds and then stop.
var done = false;
function onPlayerStateChange(event) {
if (event.data == YT.PlayerState.PLAYING && !done) {
setTimeout(stopVideo, 6000);
done = true;
}
}
function stopVideo() {
player.stopVideo();
}
</script>
</body>
</html>

<iframe id="player" type="text/html" width="640" height="390"
src="http://www.youtube.com/embed/M7lc1UVf-VE?enablejsapi=1&origin=http://example.com"
frameborder="0"></iframe>

Jumat, 26 Juni 2020

PHP Code Thinkspeak

<?php
$R=rand(1,8);

$kirim="https://api.thingspeak.com/update?api_key=6AQ86NJXWBFB634521&field1=$R";
//get_content($kirim);

echo"<hr>";
$baca="https://api.thingspeak.com/channels/1089670/feeds.json?api_key=5TW0G96C5T5U9F5R21&results=1";
$hasil= get_content($baca);
//var_dump($hasil);

$array = json_decode($hasil, true);
$x=$array["feeds"][0]["field1"];
echo $x;

echo"<hr>";
//var_dump($array);
function get_content($URL){
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $URL);
$data = curl_exec($ch);
curl_close($ch);
return $data;
}

?>

API Requests
https://thingspeak.com/channels/1089670/api_keys

Write a Channel Feed

GET https://api.thingspeak.com/update?api_key=6AQ86NJXWBFB634521&field1=0

Read a Channel Feed

GET https://api.thingspeak.com/channels/1089670/feeds.json?api_key=5TW0G96C5T5U9F5R21&results=2

Read a Channel Field

GET https://api.thingspeak.com/channels/1089670/fields/1.json?api_key=5TW0G96C5T5U9F5R21&results=2

Read Channel Status Updates

GET https://api.thingspeak.com/channels/1089670/status.json?api_key=5TW0G96C5T5U9F5R21

https://jonsuh.com/blog/convert-loop-through-json-php-javascript-arrays-objects/#:~:text=Convert%20JSON%20String%20to%20PHP,the%20objects%20as%20associative%20arrays.

Php Aoto Respon Telegram

<?php

$TOKEN = "883027477:AAHlmv0wznlon8-6B7iNixX0BmegJTsQ0jk21";
$usernamebot= "@sysinter_bot";

$debug = false;

function request_url($method){
global $TOKEN;
return "https://api.telegram.org/bot" . $TOKEN . "/". $method;
}

function get_updates($offset) {
// error_reporting(0);
$url = request_url("getUpdates")."?offset=".$offset;
$resp = file_get_contents($url);
$result = json_decode($resp, true);
if ($result["ok"]==1)
return $result["result"];
return array();
}
function send_reply($chatid, $msgid, $text){
global $debug;
$data = array(
'chat_id' => $chatid,
'text' => $text,
'reply_to_message_id' => $msgid // <---- biar ada reply nya balasannya, opsional, bisa dihapus baris ini
);
// use key 'http' even if you send the request to https://...
$options = array(
'http' => array(
'header' => "Content-type: application/x-www-form-urlencoded\r\n",
'method' => 'POST',
'content' => http_build_query($data),
),
);
$context = stream_context_create($options);
$result = file_get_contents(request_url('sendMessage'), false, $context);
if ($debug)
print_r($result);
}

function create_response($text, $message){
global $usernamebot;
// inisiasi variable hasil yang mana merupakan hasil olahan pesan
$hasil = '';
$fromid = $message["from"]["id"]; // variable penampung id user
$chatid = $message["chat"]["id"]; // variable penampung id chat
$pesanid= $message['message_id']; // variable penampung id message
// variable penampung username nya user
isset($message["from"]["username"])
? $chatuser = $message["from"]["username"]
: $chatuser = '';

// variable penampung nama user
isset($message["from"]["last_name"])
? $namakedua = $message["from"]["last_name"]
: $namakedua = '';
$namauser = $message["from"]["first_name"]. ' ' .$namakedua;
// ini saya pergunakan untuk menghapus kelebihan pesan spasi yang dikirim ke bot.
$textur = preg_replace('/\s\s+/', ' ', $text);
// memecah pesan dalam 2 blok array, kita ambil yang array pertama saja
$command = explode(' ',$textur,2); //
$perintah=$command[0];
$perintah=strtolower($perintah);

switch ($perintah) {
case '/id':
case '/id'.$usernamebot :
$hasil = "$namauser, ID kamu adalah $fromid";
break;

// jika ada permintaan waktu
case '/time':
case '/time'.$usernamebot :
$hasil = "$namauser, waktu lokal bot sekarang adalah :\n";
$hasil .= "\xE2\x8C\x9A".date("d M Y")."\nPukul ".date("H:i:s");
break;

case '/start':
$hasil = "assalamualaikum saudara/i $namauser
berikut list command dari bot ini :
=> /id --> untuk menampilkan id anda
=> /time --> untuk menampilkan waktu lokal anda";
break;

case '/tes':
$hasil = "tessting asfalksf";
break;

case '/on1':
$hasil = "Perintah Menyalakan Lampu 1 Berhasil...";
echo "on1";simpanURL("1");
break;

case '/off1':
$hasil = "Perintah Mematikan Lampu 1 Berhasil...";
echo "off1"; simpanURL("2");
break;

case '/on2':
$hasil = "Perintah Menyalakan Lampu 2 Berhasil...";
echo "on2";simpanURL("3");
break;
case '/off2':
$hasil = "Perintah Mematikan Lampu 2 Berhasil...";
echo "off2"; simpanURL("4");
break;

case '/on3':
$hasil = "Perintah Menyalakan Lampu 3 Berhasil...";
echo "on3";simpanURL("5");
break;
case '/off3':
$hasil = "Perintah Mematikan Lampu 3 Berhasil...";
echo "off3"; simpanURL("6");
break;
case '/open':
$hasil = "Perintah membuka Pintu Berhasil...";
echo "on3";simpanURL("7");
break;
case '/close':
$hasil = "Perintah Menutup Berhasil...";
echo "off3"; simpanURL("8");
break;

default:
$hasil = 'Terimakasih, pesan telah kami terima.';
break;
}
return $hasil;
}

//if (strlen($TOKEN)<20) {die("Token mohon diisi dengan benar!\n");}

function process_message($message){
$updateid = $message["update_id"];
$message_data = $message["message"];
if (isset($message_data["text"])) {
$chatid = $message_data["chat"]["id"];
$message_id = $message_data["message_id"];
$text = $message_data["text"];
$response = create_response($text, $message_data);

if (!empty($response)){
send_reply($chatid, $message_id, $response);
}
}
return $updateid;
}

function process_one(){
global $debug;
$update_id = 0;
echo "-";

if (file_exists("last_update_id"))
$update_id = (int)file_get_contents("last_update_id");

$updates = get_updates($update_id);
// jika debug=0 atau debug=false, pesan ini tidak akan dimunculkan
if ((!empty($updates)) and ($debug) ) {
echo "\r\n===== isi diterima \r\n";
print_r($updates);
}

foreach ($updates as $message){
echo '+';
$update_id = process_message($message);
}

file_put_contents("last_update_id", $update_id + 1);
}

if(isset($_GET["index"]) && $_GET["index"]>0){
$isi=bacaURL();
echo $isi;
}
else{
process_one();
}

/*
while (true) {
process_one();
echo $_SESSION["cdata"]."@";
sleep(1);
}
*/

function simpanURL($R){
$kirim="https://api.thingspeak.com/update?api_key=6AQ86NJXWBFB634521&field1=$R";
prosesURL($kirim);
}

function bacaURL(){
$baca="https://api.thingspeak.com/channels/1089670/feeds.json?api_key=5TW0G96C5T5U9F5R21&results=1";
$hasil= prosesURL($baca);
$array = json_decode($hasil, true);
$x=$array["feeds"][0]["field1"];
return $x;
}

function prosesURL($URL){
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $URL);
$data = curl_exec($ch);
curl_close($ch);
return $data;
}

function bacaTXT(){
$myfile = fopen("data.txt", "r") or die("Unable to open file!");
$isi=fread($myfile,filesize("data.txt"));
fclose($myfile);
//tulisTXT("");
return $isi;
}

function tulisTXT($txt){
$myfile = fopen("data.txt", "w") or die("Unable to open file!");
fwrite($myfile, $txt);
fclose($myfile);
return $txt;
}

if(isset($_GET["baca"])){
$bacadata=$_GET["baca"];
tulisTXT($bacadata);
echo bacaTXT();
}

?>