<main>
  <div class="container-fluid">
    <div class="row align-items-center justify-content-between pt-2">
        <div class="col-auto mb-3">
            <h4>
                <b>job_kebid</b>
            </h4>
        </div>
        <div class="col-12 col-xl-auto mb-3">
          <?php 
          $tgl=$ftgl=date("Y-m-d");

          $today=date("Y-m-d");
          $tday=date("d-D");
          $yesterday=date("Y-m-d", strtotime($tgl)-86400);
          $yday=date("d-D", strtotime($tgl)-86400);
          $y2esterday=date("Y-m-d", strtotime($tgl)-(86400*2));
          $y2day=date("d-D", strtotime($tgl)-(86400*2));
            echo ' <a class="btn btn-xs btn-color-yellow mr-1" href="?op=job_kebid&col=tgl&q='.$y2esterday.'">'.$y2day.'</a> ';
            echo ' <a class="btn btn-xs btn-color-yellow mr-1" href="?op=job_kebid&col=tgl&q='.$yesterday.'">'.$yday.'</a> ';   
            echo ' <a class="btn btn-xs btn-color-yellow mr-1" href="?op=job_kebid&col=tgl&q='.$tgl.'">'.$tday.'</a> ';        
          ?>            
          <a class="btn btn-xs btn-color-lime mr-1 mt-1" href="?op=job_kebid&op2=tool">Tool</a>
<a class="btn btn-xs btn-color-lime mr-1 mt-1" href="?op=job_kebid&op2=js4">Js4</a>
        </div>
    </div>            
          

    <?php
    switch($op2) {
      case "js4";
        fjs4("");
          break;
      case "js42";
          fjs4($_POST['json']);
          $js=json_decode($_POST['json']);
  foreach ($js->naik->kebid as $k => $v) {
    $udt=array(
      'st_naik'=>2,
    );
    Update($db,"daily_rute_price",$udt,"`berangkat_id`=".$v,1);
  }
  
  foreach ($js->turun->kebid as $k => $v) {
    $udt=array(
      'st_turun'=>2,
    );
    Update($db,"daily_rute_price",$udt,"`berangkat_id`=".$v,0);
  }
  foreach ($js->bagasi->kebid as $k => $v) {
    $udt=array(
      'st_bagasi'=>2,
    );
    Update($db,"daily_rute_price",$udt,"`berangkat_id`=".$v,0);
  }
  foreach ($js->penumpang->kebid as $k => $v) {
    $udt=array(
      'st_penumpang'=>2,
    );
    Update($db,"daily_rute_price",$udt,"`berangkat_id`=".$v,0);
  }

/*
          foreach ($js as $k => $v) {
            if($v->to_time!='') {
              $udt=array(
                'dr_time'=>$v->dr_time,
                'to_time'=>$v->to_time,
                'hplus'=>$v->hplus,
                'cek_time'=>1,
                'update_at'=>time(),
              );
              Update($db,"trayek",$udt,"kode_pergi='".$v->kode_rute."' and dr_agen=".$v->dr_agen." and to_agen=".$v->to_agen,1);
            }
          }
*/
          echo "<pre>"; print_r($js); echo "</pre>";
        break;
      case "tool";
          $sql2="SELECT * from `daily_rute_price` where tgl='".date("Y-m-d")."' or tgl='".date("Y-m-d",strtotime('-1 days'))."'";
          //echo $sql.";<br>";
          $res2=mysqli_query($db,$sql2);
          while($r2=mysqli_fetch_assoc($res2)) {
            $idt=array(
              'id'=>$r2['berangkat_id'],
              'kd_armada'=>$r2['kode_rute_armada'],
              'kelas_id'=>$r2['kelas_id'],
              'kelas_item_id'=>$r2['kelas_item_id'],
              'lambung'=>$r2['lambung'],
              'tgl'=>$r2['tgl'],
              'jalan'=>$r2['jalan'],
            );
            $udt=array(
              'kd_armada'=>$r2['kode_rute_armada'],
              'kelas_id'=>$r2['kelas_id'],
              'kelas_item_id'=>$r2['kelas_item_id'],
              'lambung'=>$r2['lambung'],
              'tgl'=>$r2['tgl'],
              'jalan'=>$r2['jalan'],
            );
            InsertUpdate($db,"job_kebid",$idt,$udt,1);
          }
          $url='https://rs2.azkapersada.com/js/kd_armada_dr_time.json';
          echo $url."<br>";
          $js_pergi=file_get_contents($url);
          $jsp=json_decode($js_pergi);  
          foreach ($jsp->dr_time as $k => $v) {
            $udt=array(
              'dr_time'=>$v,
            );
            Update($db,"job_kebid",$udt,"kd_armada='".$k."'",1);
          }              
        break;            


      case "list";
        default;
        list_job_kebid($q,$col,$q1,$col1,$q2,$col2,$lq,$lcol);
    }

    ?>


    
  </div>
</main>

<?php

function list_job_kebid($q,$col,$q1,$col1,$q2,$col2,$lq,$lcol) {
  global $db,$ar;
  $today=date("Y-m-d");
  if($col=='') {
    $col='tgl';
    $q=date("Y-m-d", strtotime("+0 day"));
  }

  ?>
  <table class="table table-bordered" id="dataTable_2d" width="100%" cellspacing="0">
    <thead>
      <tr>
        <th></th>
        <th>tgl</th>
        <th>time</th>
        <th>kd</th>
        <th>kelas</th>
        <th>nl</th>
        <th>jalan</th>                
        <th>step</th>
        <th>pnp</th>
        <th>baga</th>
        <th>naik</th>
        <th>turun</th>
        <th>uAt</th>
        <th>Menu</th>
      </tr>
    </thead>
    <tbody>
        <?php
        $sql = "select * from job_kebid where id>0 ";

        if($col!='' && $q!='') {
            $sql .= " and ".$col."='".$q."'";
        }
        if($col1!='' && $q1!='') {
            $sql .= " and ".$col1."='".$q1."'";
        }
        if($col2!='' && $q2!='') {
            $sql .= " and ".$col2."='".$q2."'";
        }
        if($lcol!='') {
            $sql .= " and ".$lcol." like '%".$lq."%'";
        }
        //$sql .= " order by update_at,job_kebid desc";

        //echo $sql;
        $res = mysqli_query($db, $sql);
        if(mysqli_num_rows($res)>0) {
        while($rw = mysqli_fetch_assoc($res)) {
          if($rw['update_at']>0) {
            $u_at=date("Y-m-d H:i:s",$rw['update_at']);
          } else {
            $u_at="";
          }            
        ?>

      <tr id="row-<?=$rw['id'];?>">
        <td><?=$rw['id'];?></td>
        <td><a href="?op=job_kebid&col=tgl&q=<?=$rw['tgl'];?>"><?=$rw['tgl'];?></a></td>
        <td><?=$rw['dr_time'];?></td>
        <td><a href="?op=job_kebid&col=kd_armada&q=<?=$rw['kd_armada'];?>"><?=$rw['kd_armada'];?></a></td>
        <td><a href="?op=job_kebid&col=kelas_id&q=<?=$rw['kelas_id'];?>"><?=$rw['kelas_id'];?></a></td>
        <td><a href="?op=job_kebid&col=lambung&q=<?=$rw['lambung'];?>"><?=$rw['lambung'];?></a></td>
        <td><a href="?op=job_kebid&col=<?=$col;?>&q=<?=$q;?>&col1=jalan&q1=<?=$rw['jalan'];?>"><?=$rw['jalan'];?></a></td>
        <td><a href="?op=job_kebid&col=step&q=<?=$rw['step'];?>"><?=$rw['step'];?></a></td>
        <td><?=$rw['st_penumpang'];?></td>                
        <td><?=$rw['st_bagasi'];?></td>                
        <td><?=$rw['st_naik'];?></td>                
        <td><?=$rw['st_turun'];?></td>                
        <td><?=$u_at;?></td>
        <td nowrap>                            
        </td>
      </tr>
    <?php
    }
    ?>
    </tbody>
  <?php 
    }      
  ?>   
  </table>
  <?=$sql;?><br><br>  
  <?php
}

function fjs4($json) {
  ?>
  <form action="index.php?op=job_kebid&op2=js42" method="post">
    <div class="form-group row">
        <label for="json" class="col-sm-1 col-form-label">JSON</label>
        <div class="col-sm-11">
          <textarea class="form-control" rows="10" name="json"><?=$json;?></textarea>
        </div>
    </div>

    <div class="form-group row">
        <div class="col-sm-10 offset-sm-2 text-right">
            <button type="submit" name="submit" class="btn btn-primary">Submit</button>
        </div>
    </div>      
  </form>
  <?php
}
?>