<?
include("modulkoneksi.php");

  /*----- LOGOUT -----*/
  if($_GET["modul"]=="logout")
  {
    session_destroy();
    header("location: index.php");
  }

  /////////////////////////// FAKTUR SERVICE /////////////////////////////////////////////////////////

  if($_GET["modul"]=="simpan_faktur_service")
  {
    $inputservice_imeihp = $_POST['inputservice_imeihp'];
    $inputservice_merkhp = $_POST['inputservice_merkhp'];
    $inputservice_tipehp = $_POST['inputservice_tipehp'];
    $inputservice_jenisservice = $_POST['inputservice_jenisservice'];
    $inputservice_biayaservice = $_POST['inputservice_biayaservice'];

    if($_POST["tanggal_nota"]!="" && $_POST["nama_user"]!="" && $_POST["tlp_user"]!="" && $_POST["alamat_user"]!="" && $_POST["kode_teknisi"]!=""
      && $_POST["total_bayar"]!="" && count($inputservice_merkhp) >=0 )
    {

      $query="INSERT INTO faktur_service (tgl_mulai_service,tgl_selesai_service,nama_teknisi,nama_user,alamat_user,tlp_user,total_service,kode_pengguna,status_service)
      VALUES
      ('".date("Y-m-d H:i:s")."','','".$_POST["kode_teknisi"]."',upper('".$_POST["nama_user"]."'),
      upper('".$_POST["alamat_user"]."'),'".$_POST["tlp_user"]."',".(int)$_POST["total_bayar"].",'".$_SESSION["login_kode_pengguna"]."','Dalam Proses')";
      //echo $query."<br/>";
      mysqli_query($koneksi,$query);

      $query5="SELECT no_faktur_service FROM faktur_service ORDER BY no_faktur_service DESC LIMIT 1";
      $r=mysqli_query($koneksi,$query5);
      $r2=mysqli_fetch_array($r,MYSQLI_ASSOC);
      $nofakturservice=$r2["no_faktur_service"];

      foreach( $inputservice_merkhp as $key => $n )
      {
            $query6="INSERT INTO faktur_service_detail
            (no_faktur_service,imei,tipe_hp,biaya_service,merek_hp,no_service_jenis_kerusakan) VALUES
            (".$nofakturservice.",'".$inputservice_imeihp[$key]."','".$inputservice_tipehp[$key]."',".(int)$inputservice_biayaservice[$key].",'".$n."',".$inputservice_jenisservice[$key].")";

            mysqli_query($koneksi,$query6);
      }//endif foreach
      // $_SESSION["pesan_success_simpan_service_so"]="SUKES NOTA DISIMPAN";
      $location="print_faktur_service.php?no_faktur_service=".$nofakturservice."";
      $_SESSION["pesan_success_simpan_faktur_service"]="Nota Faktur Service : ".$r2["no_faktur_service"]." Berhasil Disimpan";
      ?><script>//alert("Sukses");
      window.location.href="<?=$location;?>";
      </script><?

    }//ENDIF PENGECEKAN
    //else{}//else pengecekan
  }//modul simpan faktur service

   /*------/////////////////// FAKTUR SERVICE combo box tipe hp ///////////////////////------*/
  if($_POST["ajax_pilih_merek_service"])
  {
    ?>
            <label class="col-sm-2 control-label" style="width:30%;">Tipe Hp</label>
            <div class="col-sm-5">
              <select id="tipe_hp2" class="form-control select2" style="width:100%;">
                <option value="kosong">Pilih Tipe Hp</option>
        <?
      $query="SELECT * FROM service_tipe_hp WHERE merek_hp='".$_POST["ajax_pilih_merek_service"]."' ORDER BY tipe_hp ASC";
      $r=mysqli_query($koneksi,$query);
      while($r2=mysqli_fetch_array($r,MYSQLI_ASSOC))
      {
    ?>
      <option value="<?=$r2["tipe_hp"];?>"><?=$r2["tipe_hp"];?></option>
    <?
      }
    ?>
              </select>
            </div>
        <?
  }
?>