PHP Code Cek tabel name dan ALTER

<?php
require_once"config.php";

echo"<hr>";
cekKolom($conn,"baksos");

echo"<hr>";


$sql='select * from tb_admin';
//$result=$conn->query($sql);
$result = mysqli_query($conn,$sql);

$jc=mysqli_num_fields($result);
echo "Ada sebanyak: ".$jc." Kolom";

echo"<hr>";
while ($fieldinfo=mysqli_fetch_field($result)){
      printf("Name: %s\n",$fieldinfo->name);
      printf("Table: %s\n",$fieldinfo->type);
  echo"<hr>";
   }




$colObj = mysqli_fetch_field_direct($result,1);                           
$col = $colObj->name;
echo "<br/>Kolemm ke-1: ".$col;

mysqli_free_result($result);
$conn -> close();



function cekKolom($conn,$NK){
$ada=0;
$sql = "SELECT * from tb_admin";
if ($result = $conn -> query($sql)) {
  while ($fieldinfo = $result -> fetch_field()) {
if($NK==$fieldinfo -> name){$ada++;}
  }
  $result -> free_result();
}
if($ada==0){
$sql="ALTER TABLE `tb_admin` ADD `".$NK."` VARCHAR(30) NOT NULL ";
process($conn,$sql);
}
return $ada;
}
?>

MULTI Marker PHP dan Direction Revisi

<?php

$setjarak=100;
if(isset($_POST["Set"])){
$setjarak=$_POST["jarak"];
}
//AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg
//AIzaSyCbkraMfyHLJxgO0XMLEWxz6xlLRmQpwYM
?>
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg"></script>


<script>
var map;

Number.prototype.toRad = function() {
   return this * Math.PI / 180;
}

function initialize() {
<?php
$lat0= -6.217003;
$lon0=106.828432;

?>
var lat1=<?php echo $lat0;?>;
var lon1=<?php echo $lon0;?>;

  var myLatlng = new google.maps.LatLng(lat1, lon1);
  var mapOptions = {
    zoom: 10,
    center: myLatlng,
    mapTypeId: google.maps.MapTypeId.ROADMAP
  }
  map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
 var image = 'https://developers.google.com/maps/documentation/javascript/examples/full/images/beachflag.png';
  var location0 = new google.maps.LatLng(lat1,lon1);
 var marker0 = new google.maps.Marker({
        position: location0,
        map: map,
  icon: image
    });
    marker0.setTitle("Posisi Anda");
 var content0="Kampus STIE Perbanas";
    attachSecretMessage(marker0, content0);


// or: new Array();
var arLat= [];
var arLon= [];
var arNama= [];
var arLok= [];
var arJarak= [];
var n=0;
var JM=200000000;
<?php
  $sql="select * from `$tbpb`";// where status='Diterima'
  $arr=getData($conn,$sql);
 $j=0;

  if(isset($_POST["Set"])){ ?>
   JM= <?php echo $_POST["jarak"];?>
 <?php
  }
  else{
  ?>
  var JM=200000000;
  <?php
  }

  foreach($arr as $d) {     
$id_pb=$d["id_pb"];
$id_customer=getCustomer($conn,$d["id_customer"]);
$jam=$d["jam"];
$lat=$d["latitude"];
$long=$d["longitude"];
$status=$d["status"];
$alamat=$d["alamat"];
$gambar=$d["gambar"];
$pesan=$d["pesan"];
$nopol=$d["nopol"];
$jenis_mobil=$d["jenis_mobil"];
  ?>

  var lat2= <?php echo $lat;?>;
  var lon2= <?php echo $long;?>;

var R = 6371; // km
//has a problem with the .toRad() method below.
var x1 = lat2-lat1;
var dLat = x1.toRad();
var x2 = lon2-lon1;
var dLon = x2.toRad();
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
                Math.cos(lat1.toRad()) * Math.cos(lat2.toRad()) *
                Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

 <?php if(isset($_POST["Set"])){ ?>
 if(d <= JM){
      arLat[n]= <?php echo $lat;?>;
  arLon[n]= <?php echo $long;?>;
  arNama[n]= "<?php echo $id_customer;?>";
  arLok[n]= "<?php echo "Hasil cari <=".$_POST["jarak"]." KM : $id_customer  #<a href='direction.php?mnu=direction&lat=$lat0&lon=$lon0&id=$id_pb&origin=$id_customer' target='_blank'>Go Direction</a>";?>;"
  arJarak[n]=d;
  n=n+1;
 }//<=
  <?php
  }//isset
else{
?>
  arLat[n]= <?php echo $lat;?>;
  arLon[n]= <?php echo $long;?>;
  arNama[n]="<?php echo $id_customer;?>";
  arLok[n]= "<?php echo "$id_customer  #<a href='direction.php?mnu=direction&lat=$lat0&lon=$lon0&id=$id_pb&origin=$id_customer' target='_blank'>Go Direction</a>";?>";
  arJarak[n]=d;
n=n+1;
<?php
}//else
  }//foreach
?>

for (var i = 0; i < n; i++) {
    var location = new google.maps.LatLng(arLat[i],arLon[i]);
    var marker = new google.maps.Marker({
        position: location,
        map: map
    });
    marker.setTitle(arNama[i]);
 var content=arNama[i]+"\n"+arLok[i]+" jarak :"+arJarak[i]+" KM";
    attachSecretMessage(marker, content);
}
}

function attachSecretMessage(marker, lokasi) {
  var infowindow = new google.maps.InfoWindow({content: lokasi,size: new google.maps.Size(50,50)});
  google.maps.event.addListener(marker, 'click', function() {
    infowindow.open(map,marker);
  });
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>


  <body>
    <div id="map_canvas"  style="width:100%;height:500px;"></div>
 
    <br>
 
     <div align="right">
     <form action="" method="post">
     Set jarak Minimal <input type="text" name="jarak" id="jarak" value="<?php echo $setjarak;?>">
  <input type="submit" value="Set" name="Set">
     </form>
  </div>
 
  </body>

  ++++
<?php
require_once"konmysqli.php";

$id=100;
$id_pb="PNB1912004";
$lat0= -6.217003;
$lon0=106.828432;
$origin="Kampus STIE Perbanas";

if(isset($_GET["id"])){
$id_pb=$_GET["id"];
$lat0=$_GET["lat"];
$lon0=$_GET["lon"];
$origin=$_GET["origin"];
}

$sql="select * from `$tbpb`  where `id_pb`='$id_pb' ";
$d=getField($conn,$sql);
$id_pb=$d["id_pb"];
$id_customer="";//getCustomer($conn,$d["id_customer"]);
$jam=$d["jam"];
$latitude=$d["latitude"];
$longitude=$d["longitude"];
$status=$d["status"];
$alamat=$d["alamat"];
$keterangan=$d["keterangan"];
$gambar=$d["gambar"];
$gambar0=$d["gambar"];
$pesan=$d["pesan"];
$nopol=$d["nopol"];
$jenis_mobil=$d["jenis_mobil"];

?>
<!DOCTYPE html>
<html>
  <head>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no">
    <meta charset="utf-8">
    <title>Travel Modes in Directions</title>
    <style>
      /* Always set the map height explicitly to define the size of the div
       * element that contains the map. */
      #map {
        height: 100%;
      }
      /* Optional: Makes the sample page fill the window. */
      html, body {
        height: 100%;
        margin: 0;
        padding: 0;
      }
      #floating-panel {
        position: absolute;
        top: 10px;
        left: 25%;
        z-index: 5;
        background-color: #fff;
        padding: 5px;
        border: 1px solid #999;
        text-align: center;
        font-family: 'Roboto','sans-serif';
        line-height: 30px;
        padding-left: 10px;
      }
    </style>
  </head>
  <body>
    <div id="floating-panel">
    <b>Mode of Travel: </b>
    <select id="mode">
      <option value="DRIVING">Driving</option>
      <option value="WALKING">Walking</option>
      <option value="BICYCLING">Bicycling</option>
      <option value="TRANSIT">Transit</option>
    </select>
    </div>
    <div id="map"></div>
    <script>
      function initMap() {
        var directionsRenderer = new google.maps.DirectionsRenderer;
        var directionsService = new google.maps.DirectionsService;
        var map = new google.maps.Map(document.getElementById('map'), {
          zoom: 14,
          center: {lat: <?php echo $lat0;?>, lng: <?php echo $lon0;?>}
        });
        directionsRenderer.setMap(map);

        calculateAndDisplayRoute(directionsService, directionsRenderer);
        document.getElementById('mode').addEventListener('change', function() {
          calculateAndDisplayRoute(directionsService, directionsRenderer);
        });
      }

      function calculateAndDisplayRoute(directionsService, directionsRenderer) {
        var selectedMode = document.getElementById('mode').value;
        directionsService.route({
          origin: {lat: <?php echo $lat0;?>, lng: <?php echo $lon0;?>},  // Haight.
          destination: {lat: <?php echo $latitude;?>, lng: <?php echo $longitude;?>},  // Ocean Beach.
          // Note that Javascript allows us to access the constant
          // using square brackets and a string value as its
          // "property."
          travelMode: google.maps.TravelMode[selectedMode]
        }, function(response, status) {
          if (status == 'OK') {
            directionsRenderer.setDirections(response);
          } else {
            window.alert('Directions request failed due to ' + status);
          }
        });
      }

  google.maps.event.addDomListener(window, 'load', initMap);
    </script>
<script async defer
src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&callback=initMap">
</script>
  </body>
</html>


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

?>

PHP MAP MULTI MARKER DAN DIRECTION

Generate dahulu apikey:
https://console.cloud.google.com/apis/credentials/key/80ecde3a-5abc-4c54-af65-45d6446701a9?project=trusty-gradient-251202

Buat Kode sbb:

<?php
require_once"konmysqli.php";


$setjarak=100;
if(isset($_POST["Set"])){
$setjarak=$_POST["jarak"];
}
//AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg

//AIzaSyCbkraMfyHLJxgO0XMLEWxz6xlLRmQpwYM
?>
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&sensor=true"></script>
<script>
var map;

Number.prototype.toRad = function() {
   return this * Math.PI / 180;
}

function initialize() {
var lat1=-6.353019;
var lon1=106.833086;

  var myLatlng = new google.maps.LatLng(lat1, lon1);
  var mapOptions = {
    zoom: 10,
    center: myLatlng,
    mapTypeId: google.maps.MapTypeId.ROADMAP
  }
  map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
 var image = 'https://developers.google.com/maps/documentation/javascript/examples/full/images/beachflag.png';
  var location0 = new google.maps.LatLng(lat1,lon1);
 var marker0 = new google.maps.Marker({
        position: location0,
        map: map,
  icon: image
    });
    marker0.setTitle("Posisi Anda");
 var content0="Jl. RS Fatmawati, Pangkalan Jati, Cilandak, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 16514";
    attachSecretMessage(marker0, content0);


// or: new Array();
var arLat= [];
var arLon= [];
var arNama= [];
var arLok= [];
var arJarak= [];
var n=0;
var JM=200000;
<?php
  $sql="select * from `tb_restoran`";
  $arr=getData($conn,$sql);
 $j=0;

  if(isset($_POST["Set"])){ ?>
   JM= <?php echo $_POST["jarak"];?>
 <?php
  }
  else{
  ?>
  var JM=200000;
  <?php
  }

  foreach($arr as $d) {     
    $kd_sem=$d["id_restoran"];
    $id_restoran0=$d["id_restoran"];
    $nama_restoran=$d["nama_restoran"];
    $alamat=$d["alamat"];
    $telepon=$d["telepon"];
 
    $lat=$d["latitude"];
    $long=$d["longitude"];
    $gambar=$d["gambar"];
  ?>

  var lat2= <?php echo $lat;?>;
  var lon2= <?php echo $long;?>;

var R = 6371; // km
//has a problem with the .toRad() method below.
var x1 = lat2-lat1;
var dLat = x1.toRad();
var x2 = lon2-lon1;
var dLon = x2.toRad();
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
                Math.cos(lat1.toRad()) * Math.cos(lat2.toRad()) *
                Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

 <?php if(isset($_POST["Set"])){ ?>
 if(d <= JM){
      arLat[n]= <?php echo $lat;?>;
  arLon[n]= <?php echo $long;?>;
  arNama[n]= "<?php echo $nama_restoran;?>";
  arLok[n]= "<?php echo "Hasil cari <=".$_POST["jarak"]."KM : $nama_restoran $alamat #<a href='index.php?mnu=direction&x=$lat&y=$long'>Go Direction</a>";?>";
  arJarak[n]=d;
  n=n+1;
 }//<=

  <?php
  }//isset
else{
?>
  arLat[n]= <?php echo $lat;?>;
  arLon[n]= <?php echo $long;?>;
  arNama[n]= "<?php echo $nama_restoran;?>";
  arLok[n]= "<?php echo "Hasil Semua Data : $nama_restoran $alamat #<a href='index.php?mnu=direction&x=$lat&y=$long'>Go Direction</a>";?>";
  arJarak[n]=d;
n=n+1;
<?php
}//else
  }//foreach
?>

for (var i = 0; i < n; i++) {
    var location = new google.maps.LatLng(arLat[i],arLon[i]);
    var marker = new google.maps.Marker({
        position: location,
        map: map
    });
    marker.setTitle(arNama[i]);
 var content=arNama[i]+"\n"+arLok[i]+" jarak :"+arJarak[i]+" KM";
    attachSecretMessage(marker, content);
}
}

function attachSecretMessage(marker, lokasi) {
  var infowindow = new google.maps.InfoWindow({content: lokasi,size: new google.maps.Size(50,50)});
  google.maps.event.addListener(marker, 'click', function() {
    infowindow.open(map,marker);
  });
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>


  <body>
    <div id="map_canvas"  style="width:100%;height:500px;"></div>
 
    <br>
 
     <div align="right">
     <form action="" method="post">
     Set jarak <input type="text" name="jarak" id="jarak" value="<?php echo $setjarak;?>">
  <input type="submit" value="Set" name="Set">
     </form>
  </div>
 
  </body>



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

?>
HASILNYA:

Untuk direction gunakan kode sbb:

OK Mudah yaaaa

PDF 2 WORD

<?php
require 'pdfcrowd.php';

$client = new \Pdfcrowd\HtmlToPdfClient("sahrulrasyid", "360c2654be6b37707a1c512bdcb39db8");
$pdf = $client->convertUrl("https://en.wikipedia.org/wiki/Main_Page");
?>

DOWNLOAD LIB

CACAH WAKTU

<?php
$tanggal_wafat="2018-06-03";
$ar=explode("-",$tanggal_wafat);
$thn=$ar[0];
$bln=$ar[1];
$now=date("Y");
$nowb=date("m");

$sel=$now-$thn;
$lop=$sel;

//--------------------------
$awal=12-$bln;
if($sel==0){$lop=$awal;}
else{$lop=$awal+(12*$sel);}
//-----------------------
$inc=0;
$thntagihan=$thn;
$blntagihan=$bln-1;
echo"TGL Wavat: $tanggal_wafat s/d Bulan $nowb tahun $now =$lop Bulan<br>";
for($i=0;$i<=$lop;$i++){
$blntagihan=$blntagihan+1;
if($blntagihan>12){
$inc=0;
$blntagihan=1;
$thntagihan=$thntagihan+1;
}

echo"$inc $blntagihan $thntagihan<br>";
$inc++;
}


?>

PHP JSON Telegram

Baca Telegram pesan terakhir:

<?php

$url="https://api.telegram.org/bot937760588:AAEUJ78wN4PXsqiPGHws1z1POA-_TcG4P_0A/getUpdates";
$json = file_get_contents($url);
echo $json;

echo"<hr>";
$json = json_decode($json, true);
$jum=count($json['result'])-1;
echo $jum;
$last=$json['result'][$jum]['message']['text'];
echo $last;//var_dump($json['result'][2]['message']['text']);


?>

Kirim pesan:


echo $TOKEN  ="937760588:AAEUJ78wN4PXsqiPGHws1z1POA-_TcG4P_0A";
$chatid ="874965587"; //me
$method = "sendMessage";
$url    = "https://api.telegram.org/bot" . $TOKEN . "/". $method;
$post = [
'chat_id' => $chatid,
'parse_mode' => 'HTML', // aktifkan ini jika ingin menggunakan format type HTML, bisa juga diganti menjadi Markdown
'text' => $pesan
];
$header = [
"X-Requested-With: XMLHttpRequest",
"User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36"
];


$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post ); 
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$datas = curl_exec($ch);
$error = curl_error($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$debug['text'] = $pesan;
$debug['code'] = $status;
$debug['status'] = $error;
$debug['respon'] = json_decode($datas, true);


Hasil baca= {"ok":true,"result":[{"update_id":590513901,
"message":{"message_id":1,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573714779,"text":"/start","entities":[{"offset":0,"length":6,"type":"bot_command"}]}},{"update_id":590513902,
"message":{"message_id":3,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata","language_code":"en"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573715943,"text":"/start","entities":[{"offset":0,"length":6,"type":"bot_command"}]}},{"update_id":590513903,
"message":{"message_id":13,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata","language_code":"en"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573733191,"text":"halo apa kabar"}}]}

LAST:



<?php
session_start();
//error_reporting(0);

require_once"konmysqli.php";

date_default_timezone_set("Asia/Jakarta");
echo WKT(date("Y-m-d"))." # ".date("H:i:s")."<hr>";


$sqlv="select * from `$tbpengguna`  where `status`='Aktif'";
$arrv=getData($conn,$sqlv);
foreach($arrv as $dv) {
$id_pengguna=$dv["id_pengguna"];
$nama_pengguna=$dv["nama_pengguna"];
$nama=$nama_pengguna;
$email=$dv["email"];
$telephone=$dv["telephone"];
$TOKEN=$dv["key"];
$chatid=$dv["id_bot"];
$id_bot=$dv["id_bot"];

if(strlen($TOKEN)>15){
  $sql="select * from `$tbalarm` where id_bot='$id_bot'  and `status_alarm`='Proses' order by `id_alarm` asc";
  $jum=getJum($conn,$sql);
if($jum > 0){
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_alarm=$d["id_alarm"];
$stanggal_alarm=($d["tanggal_alarm"]);

$tanggal_alarm=$d["tanggal_alarm"];
$jam_alarm=$d["jam_alarm"];

$pesan_alarm=$d["pesan_alarm"];
$status_alarm=$d["status_alarm"];
$keterangan_alarm=$d["keterangan_alarm"];

$sel=cekAlarm($tanggal_alarm,$jam_alarm);
echo"$nama=$sel: $pesan_alarm#$stanggal_alarm $jam_alarm<br>";

if($sel==0){
$pesan="Yth $nama_pengguna :$pesan_alarm";
kirim($TOKEN,$chatid,$pesan);
$sql2="Update `$tbalarm` set `status_alarm`='Selesai' where `id_alarm`='$id_alarm'";
$up2=process($conn,$sql2);

$tanggal=date("Y-m-d");
$jam=date("H:i:s");

$ar=explode(":",$jam_alarm);
$J0=$ar[0];
$M0=$ar[1];
$M0=$M0+10;

if($M0>=60){
$J0=$J0+1;
$M0=00;
}

$jam_alarm="$J0:$M0:00";

if($keterangan_alarm=="-"|| $keterangan_alarm==""){
$sql3=" INSERT INTO `$tbalarm` (
`id_alarm` ,
`id_bot` ,
`tanggal` ,
`jam` ,
`tanggal_alarm` ,
`jam_alarm` ,
`pesan_alarm` ,
`status_alarm`,
`keterangan_alarm`
) VALUES (
'',
'$id_bot',
'$tanggal',
'$jam',
'$tanggal_alarm',
'$jam_alarm',
'$pesan_alarm (Reupload)',
'Proses',
'Reupload'
)";

$simpan=process($conn,$sql3);

}//if -
}



}//foreach
}//jum
//=====================================================CEK ADA REQUEST\\\

$tanggal=date("Y-m-d");
$jam=date("H:i:s");

$url="https://api.telegram.org/bot".$TOKEN."/getUpdates";
//echo $url."<hr>";
$json = file_get_contents($url);
//echo $json."<hr>";

$json = json_decode($json, true);
$jumx=count($json['result'])-1;
if($jumx>=0){
$datetele=$json['result'][$jumx]['message']['date'];
$pesantele=$json['result'][$jumx]['message']['text'];
$pesantele=strtolower($pesantele);
echo "Pesan Telegram=".$pesantele."<hr>";
if($pesantele=="request" || $pesantele=="cek" ||$pesantele=="today"){

  $sqln="select * from `$tbrequest` where id_bot='$id_bot' and  `date`='$datetele' order by `id_request` desc";
$ada2=getJum($conn,$sqln);
if($ada2<1){
//simpan
$sqlm=" INSERT INTO `$tbrequest` (
`id_request` ,
`tanggal` ,
`jam` ,
`id_bot` ,
`pesan` ,`date` ,
`status` ,
`keterangan`
) VALUES (
'',
'$tanggal',
'$jam',
'$id_bot',
'$pesantele','$datetele',
'Selesai',
'Request Via Telegram'
)";
$simpan=process($conn,$sqlm);

//***
/*
$gab="<strong>Alarm Hari ini:</strong><ol>";
$sqlb="select * from `$tbalarm` where id_bot='$id_bot'  and `tanggal_alarm`='".date("Y-m-d")."' order by `id_alarm` asc";
  $arrb=getData($conn,$sqlb);
foreach($arrb as $db) {
$tanggal_alarm=WKT($db["tanggal_alarm"]);
$jam_alarm=$db["jam_alarm"];
$pesan_alarm=$db["pesan_alarm"];
$status_alarm=$db["status_alarm"];
$gab.="<li>$pesan_alarm ($status_alarm:$jam_alarm)</li>";
}
$gab.="</ol>";
echo $gab;
*/

$gab="Alarm Hari ini:";
$sqlb="select * from `$tbalarm` where id_bot='$id_bot'  and `tanggal_alarm`='".date("Y-m-d")."' order by `id_alarm` asc";
  $arrb=getData($conn,$sqlb);
foreach($arrb as $db) {
$tanggal_alarm=WKT($db["tanggal_alarm"]);
$jam_alarm=$db["jam_alarm"];
$pesan_alarm=$db["pesan_alarm"];
$status_alarm=$db["status_alarm"];
$gab.="$pesan_alarm ($status_alarm:$jam_alarm), ";
}
$gab.="";
echo $gab;

kirim($TOKEN,$chatid,$gab);
//***


}//ada2
}//if request


}//jumx



//========================================================
}//>15
} //penggunaaktif










function kirim($TOKEN,$chatid,$pesan){
$method = "sendMessage";
$url    = "https://api.telegram.org/bot" . $TOKEN . "/". $method;
//echo $url;
$post = [
'chat_id' => $chatid,
'parse_mode' => 'HTML',
'text' => $pesan
];
$header = [
"X-Requested-With: XMLHttpRequest",
"User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36"
];


$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post ); 
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$datas = curl_exec($ch);
$error = curl_error($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$debug['text'] = $pesan;
$debug['code'] = $status;
$debug['status'] = $error;
$debug['respon'] = json_decode($datas, true);
return 1;
}


function cekAlarm($tanggal,$jam){
date_default_timezone_set("Asia/Jakarta");
$tg=date("Y-m-d");
$J1=date("H");
$M1=date("i");

$kon=1;
if($tg==$tanggal){
$ar=explode(":",$jam);
$J0=$ar[0];
$M0=$ar[1];
if($J1>$J0){
$kon=0;
}
elseif($J1==$J0 && $M1>=$M0){
$kon=0;
}
}//if sama tanggal

return $kon;//"$J1>=$J0 && $M1>=$M0=".$kon;
}

function getEXP($tanggal,$jam){
$awal  = date_create($tanggal ." ".$jam);
$akhir = date_create(); // waktu sekarang
$diff  = date_diff( $awal, $akhir );

$jummenit=$diff->i;
$jumjam=$diff->h;
$kon=0;
if($jummenit>0){
 $kon=1;
}
return $jumjam."-".$jummenit;
}


?>


<?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=split(" ",$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 getData2($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
//$arr = $rs->fetch_all(MYSQLI_ASSOC);
//$arr = mysqli_fetch_all($rs, MYSQLI_ASSOC);
$arr=$rs->fetch_assoc();
$rs->free();
return $arr;
}


/*
$arr=getData($conn,$sql);
$rs=$conn->query($sql);
while ($d = $rs->fetch_assoc()) {
//foreach($arr as $d) {

$arr=getData($conn,$sql2);
foreach($arr as $d) {
$id_request=$d["id_request"];

*/

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 getBot($conn,$kode){
$field="nama_pengguna";
$sql="SELECT `$field` FROM `tb_pengguna` where `id_bot`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $row[$field];
}
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 $kode." - ". $row[$field];
}
function getRequest($conn,$kode){
$field="tanggal";
$sql="SELECT `$field` FROM `tb_request` where `id_request`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $kode." - ". $row[$field];
}
?>

getData idwebhost000

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
//$arr = $rs->fetch_all(MYSQLI_ASSOC);
//$arr = mysqli_fetch_all($rs, MYSQLI_ASSOC);
$arr=$rs->fetch_assoc();
$rs->free();
return $arr;
}


  $sql="select * from `$tbadmin` order by `id_admin` desc";
  $jum=getJum($conn,$sql);
if($jum > 0){

$arr=getData($conn,$sql);
$rs=$conn->query($sql);
while ($d = $rs->fetch_assoc()) {
//foreach($arr as $d) {
$id_admin=$d["id_admin"];
$nama_admin=$d["nama_admin"];
$username=$d["username"];
$email=$d["email"];
$password=$d["password"];


======================================================
Sebelumnya:


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

Bisnis Proses Aplikasi Reseller Client Server

Bagian Customer (Android):
+Menu Guest : menu sisi client hanya melihat2 Produk...
+Registrasi /Forgot Password
+Menu Customer (2 Kategori: Reseller1 dan Reseller2):
*Profil (ubah data acount sendiri2)
*Menu Lihat Produk -> lihat list produk dan Fitur Searching -> Jika tertarik :Pilih Produk, Masukkan jumlah Orderan + Catatan ke Admin ->Simpan
*Menu Lihat Keranjang ->Lihat produk2 yang telah dipilih + Kalkualasi total biaya
pada menu ini Customer bisa hapus atau ubah data produk di keranjangnya
juga pada menu ini terdapat tombol Reset(kosongkan keranjang), dan Tombol Konfirmasi Pembayaran/Termin
*Menu Konfirmasi -> jika cocok Melakukan pembayaran DP atau bisa COD?
-> Jika tidak cocok data orderan bisa di biarkan sj atau di hapus atau diubah2 jumlahnya
*Menu Arsip -> Arsip data orderan sebelum2nya yang sudah selesai / sudah di bayarkan
pada menu ini Customer hanya melihat saja...tidak bisa mengubah atau menghapus data
*Menu Chat dengan Penjual/Admin

Bagian Admin (Web Server):
+Update Data Pegawai / Produksi
+Update Jenis,Harga dan Layanan Produk
+Terima Notifikasi Jika ada Orderan Masuk
+Terima Orderan -> Verifikasi dilanjut atau tidak (melalui cek buku tabungan hasil transferan DP atau COD?)
+Laporan / Arsip Orderan / Transaksi per periode (Harian, Bulanan, Tahunan atau Per tanggal)
+Print Laporan / Cetak PDF
+Monitoring Data Customer
+Chat Pelanggan
+Pendelegasikan tugas Packing/memproduksi ke Bagian Prosuksi
+Monitoring Pengiriman Barang
+MOnitoring Kas Simpan Pinjam Produk (Kasbon/ Pelunasan)

Bagian Produksi /User(Web Client):
+Update Account pribadi
+Terima Notifikasi Jika ada Orderan Masuk dari Admin
+Terima Job dari Admin Tentang Jumlah dan Jenis Produksi yang Diminta
+Laporan Progress
+Update Status -> Packing  
 

Catatan:
Pengerjaan Minimal 1 Minggu dan  Max 3 Minggu
Test Kestabilan 1Bulan
Gratis Hosting dan domain Admin selama 1tahun
Web Client bersifat Responsif : cocok dilihat via HP

Bisnis Proses Aplikasi Absensi Fingerprint Mhs - Dosen

Berikuta dalah tabel Normalisasi untuk Aplikasi Absensi Mahasiswa menggunakan Fingerprint



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

tb_dosen
nidn
nama_dosen
email
telepon
username
password
status(Aktif, Tidak Aktif)
keterangan

tb_mahasiswa
nim
nama_mahasiswa
email
telepon
username
password
status(Aktif, Tidak Aktif)
keterangan

tb_periode
id_periode
nama_periode
status(Aktif, Tidak Aktif)
keterangan

tb_matakuliah
id_matakuliah
nama_matakuliah
sks
status (Wajib, Wajib Pilihan, Pilihan)
keterangan


tb_krs (One to Many dari tb_matakuliah)
id_krs
id_periode
nim
id_matakuliah
keterangan


tb_pengampu
id_pengampu
id_periode
nidn
id_matakuliah
hari
jam
ruang
status (Open,Close)
keterangan

tb_absensi (One to Many dari tb_pengampu)
id_abseni
id_pengampu
tanggal
jam
nim
status  (Hadir,Tidak Hadir)
keterangan

Sent Telegram Data

<?php
require_once"konmysqli.php";


if(isset($_GET['sensor'])){
$sensor = $_GET['sensor'];
$status = $_GET['status'];

$tanggal = date("Y-m-d");
$jam = date("H:i:s");
$catatan = "";

$NF=date("YmdHis");

$gambar="img-$NF.jpg";

//$file="C:\\Users\\USER\\Desktop\\IMGS\sent.jpg";
$file="D:\\ftp\image.jpg";
$newfile="C:\\xampp\\htdocs\\ap_ipcamera_keamanan\\ypathfile\\".$gambar;

$GB="http://192.168.0.123/ap_ipcamera_keamanan/ypathfile/".$gambar;
//$newfile="C:\\xampp\\htdocs\\_PROJECT_FINAL\\arduino\\ap_ipcamera_keamanan\\ypathfile\\".$gambar;

if(!copy($file,$newfile)){
    $catatan= "failed to copy $gambar";
}
else{
    $catatan= "copied $gambar success\n";
}

$sql="INSERT INTO `$tblog`
(`kode_log`, `sensor`, `tanggal`, `jam`,`catatan`, `status`, `gambar`) VALUES
('', '$sensor', '$tanggal', '$jam', '$catatan', '$status', '$gambar')";
$simpan=process($conn,$sql);

//TELEGRAM
$ada=0;
if($sensor == "terbuka"){
$ada=1;
echo $pesan = "Ada Gangguan..sialakndi cek.... \n $GB";
}

echo "sukses";
}
else{
echo "failed";
}

if($ada==1){
//notif telegram
echo $TOKEN  = "883027477:AAFbkuJWd2RyB0_j2HYKMzRQIombn4NgUE4";  // ganti token ini dengan token bot
$chatid = "411787355"; // diganti dan disesuaikan
$method = "sendMessage";
$url    = "https://api.telegram.org/bot" . $TOKEN . "/". $method;
$post = [
'chat_id' => $chatid,
// 'parse_mode' => 'HTML', // aktifkan ini jika ingin menggunakan format type HTML, bisa juga diganti menjadi Markdown
'text' => $pesan
];
$header = [
"X-Requested-With: XMLHttpRequest",
"User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36"
];
// hapus 1 baris ini:
//die('Hapus baris ini sebelum bisa berjalan, terimakasih.');
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
//curl_setopt($ch, CURLOPT_REFERER, $refer);
//curl_setopt($ch, CURLOPT_VERBOSE, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post ); 
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$datas = curl_exec($ch);
$error = curl_error($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$debug['text'] = $pesan;
$debug['code'] = $status;
$debug['status'] = $error;
$debug['respon'] = json_decode($datas, true);
//print_r($debug);
}

?>




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

PHP Code Copy File

<?php
require_once"konmysqli.php";


if(isset($_GET['sensor'])){
$sensor = $_GET['sensor'];
$status = $_GET['status'];

$tanggal = date("Y-m-d");
$jam = date("H:i:s");
$catatan = "";

$NF=date("YmdHis");

$gambar="img-$NF.jpg";

$file="C:\\Users\\USER\\Desktop\\IMGS\sent.jpg";
$newfile="C:\\xampp\\htdocs\\_PROJECT_FINAL\\arduino\\ap_ipcamera_keamanan\\ypathfile\\".$gambar;

if(!copy($file,$newfile)){
    $catatan= "failed to copy $gambar";
}
else{
    $catatan= "copied $gambar success\n";
}

$sql="INSERT INTO `$tblog`
(`kode_log`, `sensor`, `tanggal`, `jam`,`catatan`, `status`, `gambar`) VALUES
('', '$sensor', '$tanggal', '$jam', '$catatan', '$status', '$gambar')";
$simpan=process($conn,$sql);

//TELEGRAM

echo "sukses";
}
else{
echo "failed";
}



?>

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

Cara men JSON KPU Situng

https://kawal-c1.appspot.com/api/c/25962

Jika di lihat menggunakan JSON Editor: https://jsoneditoronline.org/

Hasilnya sama dengan yang dari Situng: https://pemilu2019.kpu.go.id/#/ppwp/hitung-suara/

Hasil JSON Code:
0#25823#25924#25962#IDN#DKI JAKARTA#JAKARTA BARAT#KEBON JERUK#KEBON JERUK#114#145#261#178
1=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '114', '145', '259', '2', '0', '261', '-')
2=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '72', '133', '205', '1', '0', '206', '-')
3=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '61', '133', '194', '1', '0', '195', '-')
4=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '70', '131', '201', '7', '1', '201', '-')
5=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '80', '86', '166', '3', '0', '169', '-')
6=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '95', '152', '247', '3', '1', '255', '-')
7=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '98', '86', '184', '5', '0', '189', '-')
8=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '63', '153', '216', '1', '0', '217', '-')
9=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '73', '128', '0', '0', '1', '204', '-')
10=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '104', '188', '292', '8', '0', '300', '-')
11=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '106', '128', '234', '3', '0', '237', '-')
12=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '157', '234', '1', '1', '234', '-')
13=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '65', '158', '223', '1', '0', '224', '-')
14=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '119', '149', '268', '1', '0', '269', '-')
15=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '115', '132', '247', '3', '0', '250', '-')
16=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '110', '139', '249', '1', '0', '250', '-')
17=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '60', '123', '183', '1', '0', '184', '-')
18=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '113', '138', '251', '2', '0', '253', '-')
19=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '97', '174', '2', '0', '176', '-')
20=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '101', '86', '187', '7', '0', '194', '-')
21=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '73', '151', '224', '1', '0', '225', '-')
22=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '124', '209', '0', '0', '209', '-')
23=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '102', '133', '235', '1', '0', '236', '-')
24=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '96', '144', '240', '2', '0', '242', '-')
25=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '89', '104', '193', '2', '0', '195', '-')
26=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '112', '104', '216', '4', '0', '220', '-')
27=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '96', '132', '228', '1', '0', '229', '-')
28=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '92', '153', '245', '4', '0', '249', '-')
29=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '78', '179', '257', '5', '1', '252', '-')
30=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '119', '204', '1', '0', '205', '-')
31=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '80', '96', '176', '3', '0', '179', '-')
32=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '71', '164', '235', '7', '0', '242', '-')
33=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '61', '139', '200', '3', '0', '203', '-')
34=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '67', '150', '217', '7', '0', '224', '-')
35=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '66', '122', '188', '2', '0', '190', '-')
36=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '70', '187', '257', '7', '0', '264', '-')
37=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '78', '154', '232', '3', '0', '235', '-')
38=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '68', '112', '180', '3', '1', '184', '-')
39=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '157', '242', '3', '0', '245', '-')
40=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '88', '192', '280', '2', '0', '280', '?')
41=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '108', '169', '277', '2', '0', '279', '-')
42=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '90', '164', '254', '0', '0', '254', '-')
43=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '104', '147', '251', '3', '0', '254', '-')
44=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '90', '164', '254', '7', '0', '261', '-')
45=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '87', '172', '259', '2', '0', '261', '-')
46=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '98', '148', '246', '0', '0', '246', '-')
47=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '89', '152', '241', '4', '0', '245', '-')
48=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '92', '158', '250', '2', '0', '252', '-')
49=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '136', '80', '116', '1', '1', '217', '-')
50=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '154', '231', '1', '0', '232', '-')
51=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '87', '187', '274', '4', '0', '278', '-')
52=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '145', '90', '235', '3', '0', '238', '-')
53=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '97', '160', '257', '1', '0', '258', '-')
54=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '108', '133', '241', '2', '0', '243', '-')
55=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '106', '159', '265', '2', '0', '267', '-')
56=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '155', '97', '252', '2', '0', '254', '-')
57=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '51', '192', '243', '1', '0', '244', '-')
58=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '82', '119', '201', '1', '0', '202', '-')
59=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '124', '140', '264', '0', '0', '264', '-')
60=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '112', '155', '264', '3', '1', '270', '-')
61=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '125', '125', '250', '2', '0', '252', '-')
62=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '165', '86', '251', '4', '0', '255', '-')
63=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '142', '92', '234', '9', '0', '243', '-')
64=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '115', '68', '183', '2', '0', '185', '-')
65=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '63', '150', '213', '2', '0', '215', '-')
66=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '58', '141', '199', '5', '0', '204', '-')
67=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '73', '180', '253', '2', '0', '255', '-')
68=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '83', '159', '242', '0', '0', '242', '-')
69=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '56', '133', '189', '2', '1', '209', '-')
70=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '156', '12', '168', '1', '0', '169', '-')
71=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '203', '14', '217', '1', '0', '218', '-')
72=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '123', '11', '134', '0', '0', '134', '-')
73=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '192', '5', '197', '0', '0', '197', '-')
74=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '105', '195', '300', '4', '0', '304', '-')
75=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '83', '106', '189', '1', '0', '190', '-')
76=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '112', '73', '185', '2', '0', '187', '-')
77=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '108', '76', '184', '0', '0', '184', '-')
78=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '112', '77', '189', '1', '1', '189', '-')
79=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '81', '110', '191', '3', '0', '194', '-')
80=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '107', '192', '4', '0', '196', '-')
81=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '73', '128', '201', '2', '0', '203', '-')
82=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '72', '127', '199', '2', '0', '201', '-')
83=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '68', '122', '190', '0', '1', '180', '-')
84=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '62', '168', '230', '1', '0', '231', '-')
85=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '99', '126', '225', '3', '0', '228', '-')
86=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '183', '268', '0', '0', '268', '-')
87=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '86', '128', '214', '5', '0', '219', '-')
88=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '63', '121', '184', '0', '0', '184', '-')
89=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '82', '73', '155', '1', '0', '156', '-')
90=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '97', '138', '235', '2', '0', '237', '-')
91=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '66', '161', '227', '3', '0', '230', '-')
92=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '80', '116', '196', '5', '0', '201', '-')
93=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '84', '77', '161', '1', '1', '159', '-')
94=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '66', '96', '162', '0', '0', '162', '-')
95=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '105', '119', '224', '2', '0', '226', '-')
96=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '101', '168', '269', '4', '0', '273', '-')
97=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '130', '51', '181', '1', '0', '182', '-')
98=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '106', '113', '219', '2', '0', '221', '-')
99=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '115', '89', '204', '1', '0', '205', '-')
100=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '89', '114', '203', '4', '1', '206', '-')
101=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '90', '70', '160', '0', '0', '160', '-')
102=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '120', '104', '224', '1', '0', '225', '-')
103=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '218', '295', '2', '0', '297', '-')
104=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '174', '251', '1', '0', '252', '-')
105=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '61', '196', '257', '8', '0', '265', '-')
106=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '189', '7', '196', '4', '0', '200', '-')
107=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '186', '10', '196', '0', '0', '196', '-')
108=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '152', '18', '170', '1', '0', '171', '-')
109=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '202', '14', '216', '0', '0', '216', '-')
110=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '124', '131', '255', '4', '0', '259', '-')
111=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '104', '156', '260', '5', '0', '265', '-')
112=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '226', '22', '248', '2', '0', '250', '-')
113=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '121', '132', '253', '1', '1', '253', '-')
114=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '241', '8', '249', '0', '0', '249', '-')
115=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '222', '16', '238', '0', '0', '238', '-')
116=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '174', '24', '198', '1', '0', '199', '-')
117=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '95', '119', '214', '3', '0', '217', '-')
118=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '167', '118', '285', '2', '0', '287', '-')
119=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '125', '133', '258', '1', '0', '259', '-')
120=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '128', '144', '272', '2', '0', '274', '-')
121=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '117', '111', '228', '4', '0', '232', '-')
122=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '118', '83', '201', '5', '0', '206', '-')
123=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '46', '180', '226', '0', '0', '226', '-')
124=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '66', '165', '231', '1', '0', '232', '-')
125=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '108', '170', '278', '5', '0', '283', '-')
126=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '104', '82', '186', '1', '0', '187', '-')
127=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '81', '89', '170', '2', '0', '172', '-')
128=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '105', '128', '233', '3', '0', '236', '-')
129=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '79', '105', '184', '0', '0', '184', '-')
130=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '71', '106', '177', '1', '0', '178', '-')
131=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '69', '127', '196', '4', '0', '200', '-')
132=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '121', '198', '1', '0', '199', '-')
133=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '84', '160', '244', '1', '0', '245', '-')
134=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '113', '155', '268', '3', '0', '271', '-')
135=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '79', '160', '239', '10', '0', '249', '-')
136=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '85', '181', '266', '1', '0', '267', '-')
137=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '107', '166', '273', '4', '0', '277', '-')
138=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '80', '194', '274', '5', '0', '279', '-')
139=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '100', '175', '275', '4', '0', '279', '-')
140=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '76', '136', '212', '5', '0', '217', '-')
141=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '64', '109', '173', '2', '0', '175', '-')
142=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '84', '92', '176', '3', '0', '179', '-')
143=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '60', '163', '223', '5', '0', '228', '-')
144=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '54', '106', '160', '1', '1', '160', '-')
145=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '95', '177', '272', '6', '0', '278', '-')
146=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '41', '72', '113', '2', '1', '108', '-')
147=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '66', '173', '239', '5', '0', '244', '-')
148=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '90', '112', '202', '3', '0', '205', '-')
149=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '75', '82', '157', '2', '0', '159', '-')
150=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '100', '104', '204', '2', '0', '206', '-')
151=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '118', '195', '3', '0', '198', '-')
152=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '73', '115', '188', '1', '0', '189', '-')
153=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '121', '63', '184', '4', '0', '188', '-')
154=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '132', '44', '176', '1', '0', '177', '-')
155=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '62', '152', '214', '5', '0', '219', '-')
156=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '65', '151', '216', '3', '0', '219', '-')
157=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '77', '140', '217', '1', '0', '218', '-')
158=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '75', '126', '201', '1', '0', '202', '-')
159=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '124', '96', '220', '0', '0', '220', '-')
160=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '89', '168', '257', '1', '0', '258', '-')
161=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '110', '128', '238', '0', '0', '238', '-')
162=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '59', '131', '190', '3', '0', '193', '-')
163=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '64', '122', '186', '2', '0', '188', '-')
164=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '68', '111', '179', '9', '0', '188', '-')
165=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '98', '92', '190', '2', '0', '192', '-')
166=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '131', '106', '237', '4', '0', '241', '-')
167=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '112', '84', '196', '0', '0', '196', '-')
168=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '110', '137', '247', '1', '0', '248', '-')
169=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '86', '109', '195', '1', '1', '195', '-')
170=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '95', '149', '244', '1', '0', '245', '-')
171=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '90', '128', '218', '2', '0', '220', '-')
172=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '83', '161', '244', '1', '0', '245', '-')
173=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '80', '192', '272', '4', '0', '276', '-')
174=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '86', '173', '259', '2', '0', '261', '-')
175=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '49', '174', '223', '0', '0', '223', '-')
176=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '62', '158', '220', '1', '0', '221', '-')
177=INSERT INTO `tb_report` (`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES ('', '', '0', '25823', '25924', '25962', 'IDN', 'DKI JAKARTA', 'JAKARTA BARAT', 'KEBON JERUK', 'KEBON JERUK', '94', '155', '249', '1', '1', '249', '-')


++++++++++++++++++++++Adapun codenya sbb:

<?php


function get_dataa($url) {
  $ch = curl_init();
  $timeout = 5;
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0)");
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,false);
  curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,false);
  curl_setopt($ch, CURLOPT_MAXREDIRS, 10);
  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
  curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
  $data = curl_exec($ch);
  curl_close($ch);
  return $data;
}
$arrContextOptions=array(
    "ssl"=>array(
        "verify_peer"=>false,
        "verify_peer_name"=>false,
    ),
); 

require_once"konmysqli.php";
//echo date("Y-m-d h:i:s");

$link="https://kawal-c1.appspot.com/api/c/25962";
$response1 = file_get_contents($link, false, stream_context_create($arrContextOptions));
//echo $response1."<hr>";

  $emp = json_decode($response1, true);


  $id1= $emp['parentIds'][0];
  $id2= $emp['parentIds'][1];
  $id3= $emp['parentIds'][2];
  $id4=$emp['id'];
 
 
$name1=$emp['parentNames'][0];
$name2=$emp['parentNames'][1];
$name3=$emp['parentNames'][2];
$name4=$emp['parentNames'][3];
$name5=$emp['name'];

$ard= $emp['data'];

/*
  $N= count($ard);
  $x=$ard[1]["sum"]["pas1"];
  $y=$ard[1]["sum"]["pas2"];
  $z=$ard[1]["sum"]["jum"];
  //echo "$id1#$id2#$id3#$id4#$name1#$name2#$name3#$name4#$name5#$x#$y#$z#$N<br>";
  //25962#0#25823#25924#IDN#DKI JAKARTA#JAKARTA BARAT#KEBON JERUK#114#145#178
  */
 
  for($i=1;$i<count($ard);$i++){
    $pas1=$ard[$i]["sum"]["pas1"];
    $pas2=$ard[$i]["sum"]["pas2"];
$sah=$ard[$i]["sum"]["sah"];
$tsah=$ard[$i]["sum"]["tSah"];


error_reporting(0);
    $janggal=$ard[$i]["sum"]["janggal"]+0;
$pending=$ard[$i]["sum"]["pending"]+0;
    if($janggal==0){$janggal=$pending;}
$ket="-";
$jum=$ard[$i]["sum"]["jum"]+0;
if($jum==0){$jum=$pas1+$pas2;$ket="?";}
$sql="INSERT INTO `tb_report`
(`idr`, `id_detail`, `s1`, `s2`, `s3`, `s4`, `l1`, `l2`, `l3`, `l4`, `l5`, `c21`, `c22`, `sah`, `tsah`, `janggal`, `jum`, `note`) VALUES
('', '$id_detail', '$id1', '$id2', '$id3', '$id4', '$name1', '$name2', '$name3', '$name4', '$name5', '$pas1', '$pas2', '$sah', '$tsah', '$janggal', '$jum', '$ket')";
echo"$i=$sql<br>";
 
  }



/*

$idprop=$emp['parentIds'][1];
$idkab=$emp['parentIds'][2];
$idkec=$emp['parentIds'][3];

$prop=$emp['parentNames'][1];
$kab=$emp['parentNames'][2];
$kec=$emp['parentNames'][3];

$lokasi="$prop-$kab-$kec-$kel";
echo $lokasi."<br>";



$W=date("Y-m-d h:i:s");//2019-05-15 00:00:00
$arx=getArray($response1);
$ts=$arx[0];
$psu=$arx[1];
$chart1=$arx[2];
$chart2=$arx[3];
$images1=$arx[4];
$images2=$arx[5];
$pemilih_j=$arx[6];
$pengguna_j=$arx[7];
$suara_total=$arx[8];
$suara_tidak_sah=$arx[9];
$suara_sah=$arx[10];


echo $sqlX="INSERT INTO `$tbarsip` (`ida`,`idm`, `datetime`, `ts`, `psu`, `chart1`, `chart2`, `images1`, `images2`, `pemilih_j`, `suara_sah`, `pengguna_j`, `suara_total`, `suara_tidak_sah`, `contens`,`link_images1`, `link_images2`, `new_images1`,`new_images2`) VALUES
('', '$idm','$W', '$ts', '$psu', '$chart1', '$chart2', '$images1', '$images2', '$pemilih_j', '$suara_sah', '$pengguna_j', '$suara_total', '$suara_tidak_sah', '$response1', '$URL1', '$URL2', '$IMG1', '$IMG2')";
*/
/*
  $response2 = file_get_contents($link2, false, stream_context_create($arrContextOptions));
  //$response2 = get_dataa($link2);
echo "<h2>DATA RESPONSE2</h2>";//$response2."";
//++++++++++++++++++++++++++++++++++++

  $emp = json_decode($response2, true);
  $idkel= $emp['id'];
  $kel=$emp['name'];

$idprop=$emp['parentIds'][1];
$idkab=$emp['parentIds'][2];
$idkec=$emp['parentIds'][3];

$prop=$emp['parentNames'][1];
$kab=$emp['parentNames'][2];
$kec=$emp['parentNames'][3];

$lokasi="$prop-$kab-$kec-$kel";
echo $lokasi."<br>";

$N= count($emp['data']);
for($i=1;$i<$N;$i++){
$readjson2=$emp['data'][$i]["photos"];
//var_dump($readjson2);

$ii=0;


//$emp = json_decode($readjson2, true);
foreach($readjson2 as $key=>$v){
$y=array2string($v);
if(ADA($y,"sah")>0){
$sah= $v["sum"]["sah"]+0;
if($sah>0){
echo $key ;//gambar
echo"<br>";
$ts= $v["ts"];//kode dokumen
$pas1= $v["sum"]["pas1"];
$pas2= $v["sum"]["pas2"];
$tSah= $v["sum"]["tSah"];
$pending=1;
$yy=array2string($v["sum"]);
if(ADA($yy,"pending")>0){
$pending= $v["sum"]["pending"];
}
$ii++;
echo "<b>TPS:$i-$ii</b>. $pas1#$pas2#$sah#$tSah#$pending";
//$idmq=$ARIDM[$i];
   // $sqlke="select `idm` from `$tbmaster` where `propinsi` like '$prop' and  `kabupaten` like '$kab' and  `kecamatan` like '$kec' and  `kelurahan` like '$kel' and  `tps` ='$i' ";
    $sqlke="select `idm` from `$tbmaster` where `propinsi` ='$propinsi' and  `kabupaten` ='$kabupaten' and  `kecamatan` = '$kecamatan' and  `kelurahan` = '$kelurahan' and  `tps` ='$i' ";
$dke=getField($conn,$sqlke);
$idmq=$dke["idm"];
$contens="$idprop-$idkab-$idkec-$idkel-$i:$pas1#$pas2#$sah#$tSah#$pending#TPS:$i-$ii";
$sqlY="INSERT INTO `$tbdetail` (`id`, `datetime`, `location`, `ts`, `pas1`, `pas2`, `images`, `sah`, `tSah`, `pending`, `contens`, `idm`, `tps`) VALUES
('', '$W', '$lokasi', '$ts', '$pas1', '$pas2', '$key', '$sah', '$tSah', '$pending', '$contens', '$idmq', '$i');";
process($conn,$sqlY);

//$error = json_last_error();
}
echo "<hr>";
}//>0
}
}//for
*/
//++++++++++++++++++++++++++++++++++++

?>






<?php

function getArray($readjson){
$emp = json_decode($readjson, true);
$ar[0]=$emp['ts'];
$ar[1]=$emp['psu']."";
$ar[2]=$emp['chart'][21];
$ar[3]=$emp['chart'][22];
$ar[4]=$emp['images'][0];
$ar[5]=$emp['images'][1];
  $ar[6]=$emp['pemilih_j'];
  $ar[7]=$emp['pengguna_j'];
  $ar[8]=$emp['suara_total'];
$ar[9]=$emp['suara_tidak_sah'];
$ar[10]=$emp['suara_sah'];

return $ar;
}

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 array2string($data){
    $log_a = "";
    foreach ($data as $key => $value) {
        if(is_array($value))    $log_a .= "[".$key."] => (". array2string($value). ") \n";
        else                    $log_a .= "[".$key."] => ".$value."\n";
    }
    return $log_a;
}


//echo ADA("HALO APA KABAR LP2MARAY","LP2MARAY");
function ADA($str,$cari){
$str=($str);
$sp=strstr($str,$cari);
$p=strlen($sp)+0;
return $p;
}


?>