<?php
function agen() {
  global $db,$ar;
  $dt=array();
  $sql2="SELECT id,kode,parent_id as city_id,name,parent_city as city,zona from `agent` order by id";
  $res2=mysqli_query($db,$sql2);
  $dt['count']=mysqli_num_rows($res2);
  if(mysqli_num_rows($res2)>0) {
    $a=0;
    while($r2=mysqli_fetch_assoc($res2)) {
      $dt['byid'][$r2['id']]=$r2;
      $dt['bykd'][$r2['kode']]=$r2;
      $dt['seq'][$a]=$r2;
      $a++;
    }
  } 
  file_put_contents($ar['app_path']."js/agen.json", json_encode($dt)); 
  //echo json_encode($dt);
return $dt;
//$db->close();
} 
function js_kd_armada() {
  global $db,$ar;
  $dt=$dt1=array();
  $sql2="SELECT id,kode_pergi as kode_rute,kode_rute_armada as kd_armada,kelas_armada as armada_kelas,dr_ccd,to_ccd,dr_agen,to_agen,dr_time,to_time from `trayek` where kode_pergi!='' and kode_pergi!='SJO.101' order by dr_time";
  $res2=mysqli_query($db,$sql2);
  $dt['count']=mysqli_num_rows($res2);
  if(mysqli_num_rows($res2)>0) {
    $a=0;
    while($r2=mysqli_fetch_assoc($res2)) {
      $dt['data'][$r2['kode_rute']]['kd_armada']=$r2['kd_armada'];
      //$dt[$r2['kode_rute']]['armada_kelas']=$r2['armada_kelas'];
      $dt['data'][$r2['kode_rute']]['kelas_armada']=$r2['armada_kelas'];
      $dt['data'][$r2['kode_rute']]['dr_ccd']=$r2['dr_ccd'];
      $dt['data'][$r2['kode_rute']]['to_ccd']=$r2['to_ccd'];
      $dt['data'][$r2['kode_rute']]['dr_agen']=$r2['dr_agen'];
      $dt['data'][$r2['kode_rute']]['to_agen']=$r2['to_agen'];
      $dt['data'][$r2['kode_rute']]['dr_time']=$r2['dr_time'];
      $dt['data'][$r2['kode_rute']]['to_time']=$r2['to_time'];

      $sql3="SELECT `km`,`durasi`,`dr`,`to` from jalur where dr_ccd='".trim($r2['dr_ccd'])."' and to_ccd='".trim($r2['to_ccd'])."' limit 1";
      $res3=mysqli_query($db,$sql3);
      $r3=mysqli_fetch_assoc($res3);
      $ex=explode(" ",$r3['durasi']);
      $dt['data'][$r2['kode_rute']]['km']=$r3['km'];
      $dt['data'][$r2['kode_rute']]['durasi']=$r3['durasi'];
      $dt['data'][$r2['kode_rute']]['jam']=$ex[0];
      $dt['data'][$r2['kode_rute']]['sec']=to_numeric($ex[4]);
      $dt['data'][$r2['kode_rute']]['dr_to']=$r3['dr']." - ".$r3['to'];      
      
      $dt1['data'][$r2['kd_armada']]['dr_ccd']=$r2['dr_ccd'];      
      $dt1['data'][$r2['kd_armada']]['to_ccd']=$r2['to_ccd'];      
      $dt1['data'][$r2['kd_armada']]['kelas_armada']=$r2['armada_kelas'];      
      $dt1['data'][$r2['kd_armada']]['jalur']=$r3['dr']." - ".$r3['to'];      
      $a++;
    }
  }
  file_put_contents($ar['app_path']."js/kd_armada.json", json_encode($dt)); 
  file_put_contents($ar['app_path']."js/armada.json", json_encode($dt1));
  //echo json_encode($dt);
return $dt;
//$db->close();
} 
function js_noken() {
  global $db,$ar;
  $dt=$dt1=$dt2=$dt3=$dt4=array();
  $today=time();
  $sql4="SELECT id,noken,spionam_id,uji_no,uji_exp,merk,model,tipe,th_rakit,kps_exp,spionam_st,cid,tax_exp,stnk_exp,cartax_id,blue_id,rangka,mesin,lambung_last,lambung_tgl from `noken` where id>0 order by noken";
  $res4=mysqli_query($db,$sql4);
  $dt4['count']=mysqli_num_rows($res4);
  while($r4=mysqli_fetch_assoc($res4)) {
    $str_uji=strtotime($r4['uji_exp']);
    $dt4['data'][$r4['noken']]=$r4;

    if($today<$str_uji) {
      $dt4['data'][$r4['noken']]['uji_st']='aktif';
    } else {
      $dt4['data'][$r4['noken']]['uji_st']='';      
    }

    if($today<strtotime($r4['kps_exp'])) {
      $dt4['data'][$r4['noken']]['kps_st']='aktif';
    } else {
      $dt4['data'][$r4['noken']]['kps_st']='';      
    }

    if($today<strtotime($r4['stnk_exp'])) {
      $dt4['data'][$r4['noken']]['stnk_st']='aktif';
    } else {
      $dt4['data'][$r4['noken']]['stnk_st']='';      
    }

    if($today<strtotime($r4['tax_exp'])) {
      $dt4['data'][$r4['noken']]['tax_st']='aktif';
    } else {
      $dt4['data'][$r4['noken']]['tax_st']='';      
    }

  }  
  file_put_contents($ar['app_path']."js/noken.json", json_encode($dt4)); 
  /* */
  //$db->close();
  $dt['success']=true;
  return $dt4;
}

function js_nl_latest() {
  global $db,$ar;
  $dt=array();
  $sql4="SELECT lambung,noken,kelas_armada,rid as armada_id,tgl_last,update_at from `lambung` where tgl_last!='0000-00-00' order by id";
  $res4=mysqli_query($db,$sql4);
  $dt['count']=mysqli_num_rows($res4);
  $a=0;
  while($r4=mysqli_fetch_assoc($res4)) {
    $dt['data'][$a]=$r4;
    $dt['data'][$a]['kelas']=$ar['kelas_armada_v4'][$r4['kelas_armada']];
    $dt['data'][$a]['update_at']=date("Y-m-d H:i:s",$r4['update_at']);
    $a++;
  }  
  //file_put_contents($ar['app_path']."js/noken.json", json_encode($dt4)); 
  /* */
  //$db->close();
  $dt['success']=true;
  return $dt;
} 

?>