<?php 
include('../../koneksi.php');
$key=$_POST['key'];
/*
if ($key=='simpan_bbm') {
$id=$_POST['id'];
$nama=$_POST['nama'];
$jenis=$_POST['jenis'];
$cek_bbm=pg_query("SELECT id FROM sp_bbm WHERE id='$id'");
 $row_bbm = pg_fetch_row($cek_bbm);
 if ($row_bbm[0] > 0) {
 $upd_bbm = pg_query("UPDATE sp_bbm SET 
 	nama='$nama',
 	jenis='$jenis'
 	WHERE id='$id'");
 } else {
 $ins_bbm = pg_query("INSERT into sp_bbm (
 	nama,
 	jenis
 	) values(
 	'$nama',
 	'$jenis'
 	)
 ");
 }
} else
if ($key=='delete_bbm') {
$id=$_POST['id'];
 $del_bbm = pg_query("DELETE FROM sp_bbm WHERE id='$id'");
}
*/
	if ($key=='simpan_bbm') {
	$id=$_POST['id'];
	$nama=$_POST['nama'];
	$harga=$_POST['harga'];
  	$harga=str_replace('.','',$harga);
  	$harga=str_replace(',','',$harga);
	$cek_bbm=pg_query("SELECT id FROM sp_bbm WHERE id='$id'");
	 $row_bbm = pg_fetch_row($cek_bbm);
	 if ($row_bbm[0] > 0) {
	 $upd_bbm = pg_query("UPDATE sp_bbm SET 
		 nama='$nama',
		 harga='$harga'
		 WHERE id='$id'");
	 } else {
	 $ins_bbm = pg_query("INSERT into sp_bbm (
		 nama,
		 harga
		 ) values(
		 '$nama',
		 '$harga'
		 )
	 ");
	 }
	} else
	if ($key=='delete_bbm') {
	$id=$_POST['id'];
	 $del_bbm = pg_query("DELETE FROM sp_bbm WHERE id='$id'");
	} else
	if ($key=='simpan_kota') {
		$id=$_POST['id'];
		$nama=$_POST['nama'];
		$cek_kota=pg_query("SELECT id FROM sp_kota WHERE id='$id'");
		 $row_kota = pg_fetch_row($cek_kota);
		 if ($row_kota[0] > 0) {
		 $upd_kota = pg_query("UPDATE sp_kota SET 
			 nama='$nama'
			 WHERE id='$id'");
		 } else {
		 $ins_kota = pg_query("INSERT into sp_kota (
			 nama
			 ) values(
			 '$nama'
			 )
		 ");
		 }
		} else
		if ($key=='delete_kota') {
		$id=$_POST['id'];
		 $del_kota = pg_query("DELETE FROM sp_kota WHERE id='$id'");
		} else
	if ($key=='simpan_jarak') {
		$id=$_POST['id'];
		$sp_kota_id=$_POST['sp_kota_id'];
		$jarak=$_POST['jarak'];
		$cek_jarak=pg_query("SELECT id FROM sp_jarak WHERE id='$id'");
		 $row_jarak = pg_fetch_row($cek_jarak);
		 if ($row_jarak[0] > 0) {
		 $upd_jarak = pg_query("UPDATE sp_jarak SET 
		 sp_kota_id='$sp_kota_id',
		 jarak='$jarak'
			 WHERE id='$id'");
		 } else {
		 $ins_jarak = pg_query("INSERT into sp_jarak (
			sp_kota_id,
			jarak
			 ) values(
			 '$sp_kota_id',
			 '$jarak'
			 )
		 ");
		 }
		} else
		if ($key=='delete_jarak') {
		$id=$_POST['id'];
		 $del_jarak = pg_query("DELETE FROM sp_jarak WHERE id='$id'");
		} else
		if ($key=='simpan_uangharian') {
			$id=$_POST['id'];

			$luarkota=$_POST['luarkota'];
  			$luarkota=str_replace('.','',$luarkota);
  			$luarkota=str_replace(',','',$luarkota);

  			$diklat=$_POST['diklat'];
  			$diklat=str_replace('.','',$diklat);
  			$diklat=str_replace(',','',$diklat);

  			$dalamkota_kurang=$_POST['dalamkota_kurang'];
  			$dalamkota_kurang=str_replace('.','',$dalamkota_kurang);
  			$dalamkota_kurang=str_replace(',','',$dalamkota_kurang);

  			$dalamkota_lebih=$_POST['dalamkota_lebih'];
  			$dalamkota_lebih=str_replace('.','',$dalamkota_lebih);
  			$dalamkota_lebih=str_replace(',','',$dalamkota_lebih);

			$cek_uangharian=pg_query("SELECT id FROM sp_uangharian WHERE id='$id'");
			 $row_uangharian = pg_fetch_row($cek_uangharian);
			 if ($row_uangharian[0] > 0) {
			 $upd_uangharian = pg_query("UPDATE sp_uangharian SET 
			 luarkota='$luarkota',
			 diklat='$diklat',
			 dalamkota_kurang='$dalamkota_kurang',
			 dalamkota_lebih='$dalamkota_lebih'
				 WHERE id='$id'");
			 } else {
			 $ins_uangharian = pg_query("INSERT into sp_uangharian (
				luarkota,
				diklat,
				dalamkota_kurang,
				dalamkota_lebih
				 ) values(
				 '$luarkota',
				 '$diklat',
				 '$dalamkota_kurang',
				 '$dalamkota_lebih'
				 )
			 ");
			 }
			} else
			if ($key=='delete_uangharian') {
			$id=$_POST['id'];
			 $del_uangharian = pg_query("DELETE FROM sp_uangharian WHERE id='$id'");
			} else
	if ($key=='simpan_jtspj') {
		$id=$_POST['id'];
		$jumlah_hari=$_POST['jumlah_hari'];
		$cek_jarak=pg_query("SELECT id FROM sp_seting_hari WHERE id=$id");
		 $row_jarak = pg_fetch_row($cek_jarak);
		 if ($row_jarak[0] > 0) {
		 $upd_jarak = pg_query("UPDATE sp_seting_hari SET 
		 jumlah_hari=$jumlah_hari
			 WHERE id='$id'");
		 } else {
		 $ins_jarak = pg_query("INSERT into sp_seting_hari (
			jumlah_hari
			 ) values(
			 $jumlah_hari
			 )
		 ");
		 }
		} else
		if ($key=='delete_jtspj') {
		$id=$_POST['id'];
		 $del_jarak = pg_query("DELETE FROM sp_seting_hari WHERE id='$id'");
		} 
?>