<?php
$dt=tool_noken_kelas_armada();
echo json_encode($dt);

function tool_noken_kelas_armada(){
  global $ar,$db;
  $dt=array();
  //$dt['param']=$js;
  $a=0;
  $sql="SELECT 
    `noken`,kelas_armada,lambung_last
  FROM `noken` where `kelas_armada`=0 and lambung_last!=''";
  $res=mysqli_query($db,$sql);
  //$dt['count']=mysqli_num_rows($res);
  while($r=mysqli_fetch_assoc($res)) {
    $sql1="SELECT armada_kelas from daily_rute_price where lambung='".$r['lambung_last']."' and nopol='".$r['noken']."' and armada_kelas>0 order by tgl desc limit 1";
    //echo $sql1."<br>";
    $res1=mysqli_query($db,$sql1);
    if(mysqli_num_rows($res1)>0) {
      $r1=mysqli_fetch_assoc($res1);
      $udt=array(
        'kelas_armada'=>$r1['armada_kelas'],
      );
      Update($db,"noken",$udt,"noken='".$r['noken']."'",0);
      $dt[$a]['udt']=$udt;
      $dt[$a]['sql']=$sql1;
      $a++;
    }    
  }
  $dt['count']=$a;
  $dt['status']=true;
  return $dt;
  $db->close();
}


function tool_noken_th_rakit_by_ujino(){
  global $ar,$db;
  $dt=array();
  //$dt['param']=$js;
  $a=0;
  $sql="SELECT 
    `noken`,uji_no
  FROM `noken` where `own`=2 and spionam_st=1 and th_rakit='0'";
  $res=mysqli_query($db,$sql);
  $dt['count']=mysqli_num_rows($res);
  while($r=mysqli_fetch_assoc($res)) {
    $sql1="SELECT th_rakit from car_uji where no_uji='".$r['uji_no']."' limit 1";
    //echo $sql1."<br>";
    $res1=mysqli_query($db,$sql1);
    if(mysqli_num_rows($res1)>0) {
      $udt=array(
        'th_rakit'=>$r1['th_rakit'],
      );
      Update($db,"noken",$udt,"noken='".$r['noken']."'",0);
      $dt[$a]['udt']=$udt;
      $dt[$a]['nk']=$r['noken'];
      $a++;
    }    
  }
  $dt['status']=true;
  return $dt;
  $db->close();
}


function tool_noken3(){
  global $ar,$db;
  $dt=array();
  //$dt['param']=$js;
  $a=0;
  $sql="SELECT 
    `noken`
  FROM `noken` where `own`=2 and spionam_st=1 and lambung_last='0'";
  $res=mysqli_query($db,$sql);
  $dt['count']=mysqli_num_rows($res);
  while($r=mysqli_fetch_assoc($res)) {
    $sql1="SELECT lambung,nopol,armada_id,count(*) as jum from daily_rute_price where nopol='".$r['noken']."' and armada_id>0 and lambung!='' group by lambung,nopol,armada_id order by jum desc limit 1";
    //echo $sql1."<br>";
    $res1=mysqli_query($db,$sql1);
    if(mysqli_num_rows($res1)>0) {
      while($r1=mysqli_fetch_assoc($res1)) {

      $sql2="SELECT tgl,kelas_id,armada_kelas from daily_rute_price where nopol='".$r1['nopol']."' and armada_id='".$r1['armada_id']."' and lambung=".$r1['lambung']." order by tgl desc limit 1";
      $res2=mysqli_query($db,$sql2);
      if(mysqli_num_rows($res2)>0) {
        $r2=mysqli_fetch_assoc($res2);
          $udt=array(
            'lambung_last'=>$r1['lambung'],
            'lambung_tgl'=>$r2['tgl'],
            'kelas_armada'=>$r2['armada_kelas'],
          );
          Update($db,"noken",$udt,"noken='".$r['noken']."'",0);
          $dt['udt'][$a]=$udt;
          $a++;
        }
      }
    }    

  }
  $dt['status']=true;
  return $dt;
  $db->close();
}

function tool_noken2(){
  global $ar,$db;
  $dt=array();
  //$dt['param']=$js;
  $sql="SELECT 
    `nopol`
  FROM `daily_rute_price` where nopol!='' and nopol !='00000' and nopol!='000000' group by nopol";
  $res=mysqli_query($db,$sql);
  $dt['count']=mysqli_num_rows($res);
  while($r=mysqli_fetch_assoc($res)) {
      $idt=array(
        'noken'=>$r['nopol'],
      );
      $udt=array(
        'update_at'=>time(),
      );
      InsertUpdate($db,"noken",$idt,$udt,0);
  }
  $dt['status']=true;
  return $dt;
  $db->close();
}


function tool_noken(){
  global $ar,$db;
  $dt=array();
  //$dt['param']=$js;
  $sql="SELECT 
    `noken`
  FROM `armada_v2` group by noken";
  $res=mysqli_query($db,$sql);
  $dt['count']=mysqli_num_rows($res);
  while($r=mysqli_fetch_assoc($res)) {
      $idt=array(
        'noken'=>$r['noken'],
      );
      $udt=array(
        'update_at'=>time(),
      );
      InsertUpdate($db,"noken",$idt,$udt,0);
  }
  $dt['status']=true;
  return $dt;
  $db->close();
}
?>