<?php
//echo "<head><meta http-equiv=\"refresh\" content=\"1\"></head>";
include_once("../db.php");
//isi satu saat tes
ini_set("display_errors", 0);
ini_set('error_reporting', E_ALL);
date_default_timezone_set("Asia/Jakarta");
setlocale(LC_ALL, "id_ID");

if(isset($_GET['v'])) {
  $v=$_GET['v'];
} else {
  $v=0;
}

daily_update_kd_armada('daily_rute_price','kode_rute_armada',$v);
daily_update_kd_armada('bagasi','kd_armada',$v);
daily_update_kd_armada('penumpang','kd_armada',$v);

daily_update_kelas_armada('daily_rute_price','armada_kelas',$v);
daily_update_kelas_armada('bagasi','armada_kelas',$v);
daily_update_kelas_armada('penumpang','armada_kelas',$v);


function daily_update_kd_armada($tbl,$ncol,$v) {
  global $db,$ar;
  $js_rute=file_get_contents('https://rs2.azkapersada.com/js/kd_armada.json');
  $jsr=json_decode($js_rute);
  foreach ($jsr->data as $k => $v) {
    $ar['kd_armada'][$k]=$v->kd_armada;
    $ar['kelas_armada_v9'][$k]=$v->kelas_armada;
    $ar['rute_dr_ccd'][$k]=$v->dr_ccd;
    $ar['rute_to_ccd'][$k]=$v->to_ccd;
    $ar['rute_km'][$k]=$v->km;
    $ar['rute_jam'][$k]=$v->jam;
    $ar['rute_sec'][$k]=$v->sec;
  }

  $tom=date("Y-m-d",strtotime("+1 day"));
  $sql="SELECT `".$ncol."`,`kode_rute` from `".$tbl."` where tgl<'".$tom."' and `kode_rute`!='SJO.101' and (`".$ncol."`='' or `".$ncol."` is null) group by `kode_rute` ";
  $res=mysqli_query($db,$sql);  
  while($r=mysqli_fetch_assoc($res)) {
    if(isset($ar['kd_armada'][$r['kode_rute']])) {
      $udt=array(
        $ncol=>$ar['kd_armada'][$r['kode_rute']],
      );
      Update($db,$tbl,$udt,"kode_rute='".$r['kode_rute']."'",$v);
    }
  }
  echo $tbl.": ".mysqli_num_rows($res)."<br>".$sql."<br>";
}

function daily_update_kelas_armada($tbl,$ncol,$v) {
  global $db,$ar;
  $js_rute=file_get_contents('https://rs2.azkapersada.com/js/kd_armada.json');
  $jsr=json_decode($js_rute);
  foreach ($jsr->data as $k => $v) {
    $ar['kd_armada'][$k]=$v->kd_armada;
    $ar['kelas_armada_v9'][$k]=$v->kelas_armada;
    $ar['rute_dr_ccd'][$k]=$v->dr_ccd;
    $ar['rute_to_ccd'][$k]=$v->to_ccd;
    $ar['rute_km'][$k]=$v->km;
    $ar['rute_jam'][$k]=$v->jam;
    $ar['rute_sec'][$k]=$v->sec;
  }
  $tom=date("Y-m-d",strtotime("+1 day"));
  $sql="SELECT `".$ncol."`,`kode_rute` from `".$tbl."` where tgl<'".$tom."' and `kode_rute`!='SJO.101' and `".$ncol."`=0 group by `kode_rute` ";
  $res=mysqli_query($db,$sql);  
  while($r=mysqli_fetch_assoc($res)) {
    if(isset($ar['kelas_armada_v9'][$r['kode_rute']])) {
      $udt=array(
        $ncol=>$ar['kelas_armada_v9'][$r['kode_rute']],
      );
    } else {
      $udt=array(
        $ncol=>99,
      );      
    }
    Update($db,$tbl,$udt,"kode_rute='".$r['kode_rute']."'",$v);
  }
  echo $tbl.": ".mysqli_num_rows($res)."<br>".$sql."<br>";
}

?>
/home/u902783705/domains/azkapersada.com/public_html/sub/
rs2/daily/14_update_kd_armada.php
si/common.function
si/dom/get.img
si/api/post_location
si/api/post_loc_v3
si/api/post_tag_v2
si/api/post_tag_v3
common.function
common.function-
footer
header
inc.app.function
inc.ar.app
index
tes_curl
ucol
api/v2/api.function
api/v2/inc.mail
api/v2/index
api/v2/php/agen
api/v2/php/armada_jalan_byday
api/v2/php/armada_perpal_byday
api/v2/php/armada_perpal_byday-
api/v2/php/beda_byday
api/v2/php/cek_rute_baru
api/v2/php/cek_rute_time
api/v2/php/cek_rute_time_v1
api/v2/php/cek_rute_time_v2
api/v2/php/city
api/v2/php/dr_time_byday
api/v2/php/dr_time_jalan_byday
api/v2/php/email_cek
api/v2/php/get_nl_byday
api/v2/php/get_nl_kelas_armada
api/v2/php/js_armada_tax_expire
api/v2/php/js_blue_armada
api/v2/php/js_blue_expire
api/v2/php/js_car_srut_blank
api/v2/php/js_img_todl
api/v2/php/js_jalurnew
api/v2/php/js_kebid
api/v2/php/js_nl_latest
api/v2/php/js_nl_min
api/v2/php/js_noken
api/v2/php/js_noken_mesin_blank
api/v2/php/js_noken_no_lambung
api/v2/php/js_noken_spionam_cek
api/v2/php/js_noken_tax_cek
api/v2/php/js_rute
api/v2/php/js_rute_bycity
api/v2/php/js_rute_min
api/v2/php/js_spionam_id
api/v2/php/js_spionam_kps
api/v2/php/kd_armada
api/v2/php/kd_armada_dr_time
api/v2/php/kd_armada_to_time
api/v2/php/naik_byday
api/v2/php/nk_pilih
api/v2/php/nl_noken_bytgl
api/v2/php/nl_pilih
api/v2/php/nl_reset
api/v2/php/noken_koreksi
api/v2/php/otw
api/v2/php/otw_not_full
api/v2/php/password_forgot
api/v2/php/post_1naik
api/v2/php/post_1turun
api/v2/php/post_blue
api/v2/php/post_dr_time_byday_local
api/v2/php/post_kebid_byday
api/v2/php/post_noken_mesin
api/v2/php/post_noken_no_lambung
api/v2/php/post_sakpol
api/v2/php/post_spionam
api/v2/php/post_spionam_cek
api/v2/php/post_spionam_update
api/v2/php/post_spnm_noken
api/v2/php/ricar
api/v2/php/rute_price
api/v2/php/selisih_bagasi
api/v2/php/signin
api/v2/php/tool
api/v2/php/tool_armada
api/v2/php/tool_lambung
api/v2/php/tool_noken
api/v2/php/turun_byday
api/v2/php/ucol
api/v2/php/uji_no
api/v2/php/update_agen
api/v2/php/update_armada_byday
api/v2/php/update_armada_v2_byday
api/v2/php/update_bagasi_byday
api/v2/php/update_bagasi_city
api/v2/php/update_jalan_byday
api/v2/php/update_penumpang_byday
api/v2/php/update_trayek_dr_time
api/v2/php/update_trayek_to_time
daily/10_tool_seq
daily/14_update_kd_armada
daily/15_update_rute_dr_to_ccd
daily/16_kdagen_to_id
daily/16_kdagen_to_id-
daily/17_update_dr_to_time
inc/inc.cp_sphp
inc/inc.filephp
inc/inc.job_kebid
inc/inc.js_pergi
inc/inc.rs4_css
inc/inc.rs4_html
inc/inc.rs4_h_page
inc/inc.rs4_h_tab
inc/inc.rs4_js
inc/inc.rs4_jsf
inc/inc.t1_css
inc/inc.t1_html
inc/inc.t1_h_page
inc/inc.t1_h_tab
inc/inc.t1_js
inc/inc.t1_jsf
xhr/inc.xhr